For the modders - Fpool calculator

[Andrew Williams]

Tejszd has released a fpool calculaor that works with both WaR and tLD.

Warning this is for modders only and requires excel.

Get it from the bottom right of this page http://closecombat.matrixgames.com/WaR/WaRmods.html

[Platoon_Michael]

Looks pretty neat.

But shouldnt it say Copy calculated data from F17 to AT141
Instead of
Copy calculated data from F17 to AS141

[Tejszd]

Thanks for the feedback Platoon_Michael.

You are right for WAR it should be the AT column. So I just changed the instruction line to the following;

"Copy calculated data from E17 to AT142 for WAR or B37 for TLD to your fpool sheet and paste special values into the upper left cell of the selected BG's data area"

[Platoon_Michael]

A Huge thank-you to Tejszd for creating the Force Pool Calculator.
I messed around with it for a few hours last night and it works GREAT.
No longer does one have to edit every single line,One thing none of us were interested in doing.

Using it with the BG pages I made with the Icons,the Workbook is becomming very easy to use (inmho)
Hopefully it wont take to long to do every page but here's how I think it will look.Unless you think it might need something else?
Does it need an explaination on every page?

[Platoon_Michael]

In the Quantities columns for Team Class's 21-25 shouldnt that be 0 (zero) and not -1?
In WAR ours are set at 0
Or is that just the way TLD does it?


Thanks

[Platoon_Michael]

What the best way to use this in reverse?

It's great that I can use this to reduce the German FP but how do I reverse it to add for the Allies?

I also need help in finding a very efficient way to edit each line independently.
I.E.
Editing each line for Recruit to have a different Class than what Line has.

[Tejszd]

For class 21-25 I believe the team type should be -1 as there is a team number 0. As long as quantity is 0 there is no difference except maybe the team name appearing (though I remember it being discussed to hide units with no quantity thus there may not be any difference).


For an increasing forcepool put in a negative percentage instead of a positive one.


I understand what you want but not sure how/when change unit types automatically. Unfortunately for now you will need manually edit the unit type as desired....

[Platoon_Michael]

21-25 I did figure out that one later on.

Thanks for the negative percentage advice.Didn't know that one.

I was just wondering if anyone knew how to write a formula that once entered on Day 0 at Recruit or Elite would change every line for said Class,kind of a one and done type deal?
Ive been doing it manually,It stinks.
Compound that with new Weapon Class's and new Soldier Class's and new teams..........It escalates from stinks to Sucks.


Oh well.
Thanks for the info.