Matrix Games Forums

 Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

Pilot version for Excel editor available

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

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [New Releases from Matrix Games] >> Close Combat Series >> Close Combat: Last Stand Arnhem >> Mods and Scenarios >> Pilot version for Excel editor available Page: [1]
Login
Message << Older Topic   Newer Topic >>
Pilot version for Excel editor available - 8/25/2010 7:59:17 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		I have made a pilot version of the Excel editor. It allows some basic editing of the force pools file. You can find it here. It is meant to be used with the ModInstaller, made by Bernd. Much indebted to xe5, for explaining how the force pools txt file works, elsewhere in this forum.

_____________________________
Post #: 1
RE: Pilot version for Excel editor available - 8/28/2010 11:59:26 AM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		Added functionality to edit bgroups file.

_____________________________


(in reply to triarius)
Post #: 2
RE: Pilot version for Excel editor available - 8/28/2010 5:17:11 PM   
Tejszd

 

Posts: 3437
Joined: 11/17/2007
Status: offline 		Thank you Triarius!

(in reply to triarius)
Post #: 3
RE: Pilot version for Excel editor available - 8/29/2010 5:53:51 PM   
xe5

 

Posts: 783
Joined: 5/3/2009
Status: offline 		This is a very useful tool. Im now able to edit fpools.txt without having to refer to a separate list of team class numbers.

Suggestions:

BGroups.txt has a new column (D) that is skewing the LSA Editor's display of that file. Column D now refers to the shared parent formation forcepool as specified in /data/base/formations.txt.

On the BGroups tab, in the Force Pool editing space, display the 'net' team quantities in addition to the 'gross' team quantities. eg. if a 'gross' quantity for a team was 54, then the 'net' quantity at Recruit difficulty, (54 x .462) would be 24. This would allow tool users to better visualize the actual forcepool quantities available in-game. It would be ideal if the 'net/net' forcepool quantities could be displayed as factored by both the Difficulty level modifier and Start Day modifier.

(in reply to Tejszd)
Post #: 4
RE: Pilot version for Excel editor available - 9/8/2010 8:21:30 PM   
kojusoki1

 

Posts: 172
Joined: 1/6/2009
Status: offline 		5cents from me
Here in the attachment you can find all forcepools - usefull to know what we have in our Bgs to plan strategic movement.
Made from Triarius tool

Attachment (1)

(in reply to xe5)
Post #: 5
RE: Pilot version for Excel editor available - 9/10/2010 11:51:46 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		Another pilot available (I wait with version 1 until we have the Workbook).

You can now edit the active roster and all difficulty multipliers. Following the suggestion from xe5, you can see how many teams you will actually have available for any given day and difficulty level.

If you are using Excel 2010, you can add a Close Combat tab to your ribbon. The icons are still the standard Excel ones, though.

(in reply to kojusoki1)
Post #: 6
RE: Pilot version for Excel editor available - 9/11/2010 7:12:23 PM   
xe5

 

Posts: 783
Joined: 5/3/2009
Status: offline 		re: "The contents of these fields are tentative pending the publication of the [LSA] Workbook"

The final version of your Excel editor should be officially incorporated into the LSA workbook.

Hoping you'll add a 'Reinforcements Editing Space' with the capacity to create up to 5 reinforcement force pools.

The Base and Actual Quantities columns are misleading and could be deleted from the Active Roster Editing Space. For example - At 'Line' difficulty, on Day 1, the 1st Air Landing Bde would have 7 Command Infantry units in its forcepool (2 x Co HQ + 5 Plt HQ) instead of the 15 Command Infantry teams indicated by slots 1, 6 and 11 in the Active Roster Editing Space.




(in reply to triarius)
Post #: 7
RE: Pilot version for Excel editor available - 9/25/2010 2:32:27 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		Yet another version of the pilot...

Major changes:

- All battle group data are loaded in one go.
- You can now also edit the reinforcements. I have given each battle group 5 reinforcements, the original ones completed with dummy reinforcements of 9 empty teams on turn 99.
- The interface of the editor uses dialogue boxes. Changes also to the Close Combat ribbon.
- Some extensive reprogramming. You should not notice this, except by the disappearance of the technical spaces, and the appearance (I hope not) of bugs.

(in reply to xe5)
Post #: 8
RE: Pilot version for Excel editor available - 9/25/2010 4:33:56 PM   
xe5

 

Posts: 783
Joined: 5/3/2009
Status: offline 		Im getting a #VALUE! error in the Force Pool/Actual Quantity (D20:D44) and Active Roster/Base Quantity (E53:E67) columns on the FPoolRosterEditor worksheet.

The effort youre putting into creating and improving this tool is much appreciated.

(in reply to triarius)
Post #: 9
RE: Pilot version for Excel editor available - 9/25/2010 5:33:30 PM   
Tejszd

 

Posts: 3437
Joined: 11/17/2007
Status: offline 		Thanks Triarius!

(in reply to xe5)
Post #: 10
RE: Pilot version for Excel editor available - 9/25/2010 6:59:17 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		Argh ! I think it's due to a confusion between the decimal point and the decimal comma, which has been causing me headaches all along. The global multipliers were written with a point, and we use a comma over here, so my Excel probably saved it as text. For some weird reason, my PC refuses to switch to the decimal point, even when I change the international settings.

I've posted a new version, can you check that this solves the problem ?

(in reply to Tejszd)
Post #: 11
RE: Pilot version for Excel editor available - 9/25/2010 7:02:40 PM   
xe5

 

Posts: 783
Joined: 5/3/2009
Status: offline 		Fixed the #VALUE! error in the Force Pool/Actual Quantity column (D20:D44) by manually changing the five Difficulty Modifier decimal separators on the GMultiEditor worksheet from commas to points. The #VALUE! error in the Active Roster/Base Quantity column (E53:E67) was simultaneously resolved since it resulted from me having selected "Actual Quantity" as the Active Roster quantity indicator.

If the decimal separator selection (point or comma) on the Home worksheet is supposed to effect changes on the GMultiEditor worksheet, its not working.

Being a firm believer in "feature creep", here's another suggestion - per the image below, add an option to show "Available Slots" to the Active Roster quantity indicator based on the current Actual Quantity values selected for the Force Pool configuration. BG point strength based on currently selected Actual Quantities would also be worthwhile info.




Attachment (1)

(in reply to Tejszd)
Post #: 12
RE: Pilot version for Excel editor available - 9/25/2010 7:16:36 PM   
xe5

 

Posts: 783
Joined: 5/3/2009
Status: offline 		The new version solves the decimal separator problem, although toggling the separator selection on the Home worksheet still doesnt seem to change the GMultiEditor separators.
Thanks for the prompt customer service and money back guarantee

(in reply to xe5)
Post #: 13
RE: Pilot version for Excel editor available - 9/25/2010 7:31:18 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		Toggling the seperator field does not change the actual entries in the spreadsheet. It does two things when you have selected "comma":

1/ when you open the txt file, it adds a condition that the decimal seperator is the point and the thousands seperator the comma (cfr the dialogue box you get when opening a text file in Excel) ;
2/ when you save the txt file, it sets all fields at "text" format, and then runs through the whole sheet to replace comma's with points.

Wish the whole world would switch to the point (or the comma or whatever)...

Somebody has also pointed out the following. Load for instance Kampfgruppe Knaust, and look at the first reinforcement they get: it's each time one sniper ! This seems rather unlikely, so these fields probably code for something else.

Many thanks to xe5 and this other person for helping me out.

(in reply to xe5)
Post #: 14
RE: Pilot version for Excel editor available - 9/25/2010 8:04:51 PM   
xe5

 

Posts: 783
Joined: 5/3/2009
Status: offline 		Even stranger that the 1st Polish Parachute Bde reinforcements on turn 40 would include 1 US Sniper in addition to 9 Polish snipers.

After looking through all the reinforcement data again, diese andere Person is correct that the second and third fields in each line of reinforcement data code for something other than team type and quantity. Working values for the second field are- 0, 1, 2; for the third field- 0, 1. Guessing these may specify conditions which need to be met before reinforcement can happen.


(in reply to triarius)
Post #: 15
RE: Pilot version for Excel editor available - 1/8/2011 8:48:49 AM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		Due to persistent problems with my provider, I've had to put a copy of the editor here.

(in reply to xe5)
Post #: 16
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> Close Combat Series >> Close Combat: Last Stand Arnhem >> Mods and Scenarios >> Pilot version for Excel editor available 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.750