Re: [allocations-admins] Problem with the revised allocations spreadsheet
Here is a revised spreadsheet moving SprayFlame-LES to industry and correcting the sums and summary percentages. I now see that SprayFlame-LES is marked as priority 1 because it is part of a strategic initiative, so I restored the allocation. That leaves 6.35M hours to allocate on Fusion; more if the committee reduces SprayFlame-LES. This is just enough to cover the deficit on Blues. Ray On 3/26/15, 4:06 PM, "Bair, Raymond A." <[email protected]> wrote:
All of the formulas for sums (row 162) are incorrect. The correct total for column AE (New Decisions) was 34,597,000 not 20,797,000!
The value in cell A3 is incorrect. Should be 2015. (Makes no difference since 2014 and 2015 are not leap years.)
Most of the industry projects are listed twice, on both the Data page and the Industry page.
biodiesel-combustion
CAT-engine-modeling
cavitation-modeling
dual-fuel-sprays
LES-Engine
LES-sprays
We should also move the new project spray-flame-les to Industry (2.85M request). Correct?
What should we do now? I have suggestions bsed on past practice. See attached spreadsheet for numbers.
Reducing ApsRenewalLattice to 2M, and OPV to 500K.
Doing the above changes the total to 27,497,000. Now 26% over-allocated.
If we keep the priority 0-2 projects as they are, and scale the rest down to no less than 100K (for the 2nd half), then the scale factor is 71%.
See attached spreadsheet.
My revised total, percent allocation (relative to 100%), and scale factor are at the bottom of column AE
Comments and suggestions?
Ray
----------------------------------------- Ray Bair Computing, Environment, and Life Sciences Argonne National Laboratory and the University of Chicago TCS Building 240, Room 4122 9700 South Cass Avenue Argonne, IL 60439 email: rbair(at)anl.gov Phone: (630)252-5751
participants (1)
-
Bair, Raymond A.