Sorry I didn't get back to you much sooner, n01487477 and Tarkana. The formulas in this file are constructed back to front but even if they weren't, they just won't allow the flexibility you need to plan your production.
I'm a month into a campaign and have used the planner to overhaul my production. It works, but I'll have to qualify that as it's not without its faults and limitations.
1. There are still some errors and ommisions in the lists so I advise anyone using the planner to check vs the in-game production lists. It only takes an hour or so to filter the at start production and verify all the numbers are right. I also think one engine type is completely missing from the list so watch out!
2. Human error. This planner does work, but with such detail, lack of formulas and complicated inter-relations of effects, you will make mistakes even after you've figured out how it works.
Example. An offline Ju 88G assembly comes on line.
On the Assembly page, add one to online production and reduce the offline assemblies by one. In the same line, add two to the current requirement field (JU 88G has two engines).
On Parts page, add one to Ju 88 Production requirement, subtract one each from the Current Surplus/Deficit and Additional Planned Requirement fields.
On Engines page, add two to Junkers Jumo 213E Production Requirement, and subtract two each from Current Surplus/Deficit and Additional Planned Requirement fields.
If you can do that every time an assembly comes online and make no errors, you're a better man than I. And you treat the parts and engines coming on/offline differently...
3. Even if you do all that, the best excel sheet in the world will not adjust its values to reflect either the temporary effects of bombing or the permanent effects of losing ground and factories. Even the in game production list leaves overrun factories in the 'Planned' section but you'll never get them back!
So, for squeaky clean production planning, around every game month or after a major overhaul I recommend you check the entire planner against the in game production list, for errors.
If you like tinkering with data, once you're used to it and until the benefits are incorporated in a future patch, you will find this useful. After having my doubts the first few times I used it, I think it's great . It may not be for everyone though, and except for data geniouseseses, you will get a head ache or two learning to use it.
< Message edited by Tuk -- 1/21/2010 4:53:51 PM >