Matrix Games Forums

A look through the keyhole #10!The Age of Shadows on Distant Worlds starts now!Paypal System UpdateDistant Worlds: Shadows Final Teaser!Distant Worlds: Legends gets Updated!Recruiting Testers for Commander: the Great War on Mac!Armageddon invasion starts in 2014Command Rommels Panzers in Battle Academy!Servers UpdateThe Deal goes Fourth!		 Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

For the modders - Fpool calculator

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [Current Games From Matrix.] >> [World War II] >> Close Combat: Wacht am Rhein >> Mods and Scenarios >> For the modders - Fpool calculator Page: [1]
Login
Message << Older Topic   Newer Topic >>
For the modders - Fpool calculator - 9/8/2009 1:44:31 AM   
Andrew Williams


Posts: 6112
Joined: 1/8/2001
From: Australia
Status: offline 		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




< Message edited by Andrew Williams -- 9/8/2009 1:45:35 AM >
Post #: 1
RE: For the modders - Fpool calculator - 9/9/2009 9:42:34 PM   
Platoon_Michael


Posts: 855
Joined: 3/9/2003
Status: offline 		Looks pretty neat.

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

(in reply to Andrew Williams)
Post #: 2
RE: For the modders - Fpool calculator - 9/10/2009 2:58:26 AM   
Tejszd

 

Posts: 2677
Joined: 11/17/2007
Status: offline 		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"



< Message edited by Tejszd -- 9/10/2009 6:27:16 PM >

(in reply to Platoon_Michael)
Post #: 3
RE: For the modders - Fpool calculator - 9/10/2009 10:27:34 AM   
Platoon_Michael


Posts: 855
Joined: 3/9/2003
Status: offline 		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?




Attachment (1)

< Message edited by Platoon_Michael -- 9/11/2009 10:10:51 AM >

(in reply to Tejszd)
Post #: 4
RE: For the modders - Fpool calculator - 9/17/2009 9:09:35 AM   
Platoon_Michael


Posts: 855
Joined: 3/9/2003
Status: offline 		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

(in reply to Platoon_Michael)
Post #: 5
RE: For the modders - Fpool calculator - 3/11/2012 4:50:29 PM   
Platoon_Michael


Posts: 855
Joined: 3/9/2003
Status: offline 		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.

(in reply to Platoon_Michael)
Post #: 6
RE: For the modders - Fpool calculator - 3/11/2012 5:44:05 PM   
Tejszd

 

Posts: 2677
Joined: 11/17/2007
Status: offline 		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....

(in reply to Platoon_Michael)
Post #: 7
RE: For the modders - Fpool calculator - 3/12/2012 4:02:47 AM   
Platoon_Michael


Posts: 855
Joined: 3/9/2003
Status: offline 		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.






Attachment (1)

< Message edited by Platoon_Michael -- 3/12/2012 4:16:37 AM >

(in reply to Tejszd)
Post #: 8
Page:   [1]
All Forums >> [Current Games From Matrix.] >> [World War II] >> Close Combat: Wacht am Rhein >> Mods and Scenarios >> For the modders - Fpool calculator Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.133