Excel tool to mod fpools, bgroups, teams (Full Version)

All Forums >> [New Releases from Matrix Games] >> Close Combat Series >> Close Combat: The Longest Day >> Mods and Scenarios



Message

triarius -> Excel tool to mod fpools, bgroups, teams (6/30/2009 6:58:15 PM)

I have created an Excel sheet to edit the fpool, bgroup and teams files. You can find it here. The Excel sheet contains macros.

Triarius



Andrew Williams -> RE: Excel tool to mod fpools, bgroups, teams (6/30/2009 11:53:46 PM)

thanks Triarius... will have alook at this today.

:)



Andrew Williams -> RE: Excel tool to mod fpools, bgroups, teams (7/1/2009 12:02:23 PM)

Very nice indeed Triarius.....

There is a similar editor underway in access for WaR...


good stuff guys



Mafi -> RE: Excel tool to mod fpools, bgroups, teams (7/13/2009 5:44:41 PM)


quote:

ORIGINAL: triarius

I have created an Excel sheet to edit the fpool, bgroup and teams files. You can find it here. The Excel sheet contains macros.

Triarius


Hi Triarius,

thanks for your tool! Sadly to say, my environment is telling: "VisualBasic Makros are not supported by MS-Excel 2008 Macintosh".

But thanks a lot! A big help for the PC-users.
Mafi



triarius -> RE: Excel tool to mod fpools, bgroups, teams (7/13/2009 8:00:59 PM)

Mafi,

I have copied the Excel 97 version onto my iMac, which is running a Dutch version of System 7 and a UK version of Excel 98. The Mac is quite happy to open the macros, but then there are plenty of problems in the spreadsheet and with the macros. Who said Excel sheets are compatible between Mac and PC ?.

Anyway, I am willing to see if I can develop a Mac version for Excel 98, but first I want to make sure I am solving the right problem. Have you tried with the Excel 2007 or with the Excel 97 version ?

Triarius



Mafi -> RE: Excel tool to mod fpools, bgroups, teams (7/13/2009 8:12:04 PM)


quote:

ORIGINAL: triarius

Have you tried with the Excel 2007 or with the Excel 97 version ?

Triarius


Hi Triarius,

I have used Mac:Office 2008 on Intel MacBook. This Excel version is not accepting VisualBasic.
Thanks for the hints for older PPC versions!

Mafi



triarius -> RE: Excel tool to mod fpools, bgroups, teams (7/14/2009 6:08:42 PM)

I am working on a macro-free version of the spreadsheet. This should help people who have platform or security issues. It will involve some manual copying and pasting, though. Stay tuned...



triarius -> RE: Excel tool to mod fpools, bgroups, teams (7/18/2009 7:23:35 PM)

The folder now also contains a version without macros, for those of you who have platform or security issues. The Excel 97/2003 version of the new spreadsheet seems to work fine on my iMac. I also corrected a small bug in the teams editor: the option "Tank, gun or mortar crew" was not available.



Mafi -> RE: Excel tool to mod fpools, bgroups, teams (7/26/2009 6:23:59 PM)


quote:

ORIGINAL: triarius

The folder now also contains a version without macros, for those of you who have platform or security issues. The Excel 97/2003 version of the new spreadsheet seems to work fine on my iMac. I also corrected a small bug in the teams editor: the option "Tank, gun or mortar crew" was not available.


Hi Triarius,
the file CCEditor v1 (No macros Excel 2003).xls is working on Mac:Office2008's Excel. Thanks a lot!

Cheers
Mafi



Rift -> RE: Excel tool to mod fpools, bgroups, teams (8/21/2009 5:50:51 PM)

Hi Triarius,

I'm trying to edit the team data and failing everytime I hit the "Read the force pool for this unit from original data" button the following error occurs:

I am using Microsoft Works 2000.

Any help would be much appreciated.

Take it easy

[image]local://upfiles/32331/0AE64892965D482888D05D6F65B43480.jpg[/image]

oh yeah I should probably say that I am fairly computer clueless especially in excel, sorry



Rift -> RE: Excel tool to mod fpools, bgroups, teams (8/22/2009 9:54:23 AM)

Hi,

Please ignore my last post, I downloaded a trial copy of Excel 2007 and the spreedsheet works brilliantly.

Very impressed, Triarius you've created an excellent tool, thank you.

Take it easy



triarius -> RE: Excel tool to mod fpools, bgroups, teams (8/23/2009 4:24:57 PM)

I have added a slightly changed version of the Excel 2007 file with macro's (CCEditor V1a) to the folder.

If you edit a unit in BgroupsEditor, often you will also want to edit the teams of that unit. But in TeamsEditor, it can sometimes be difficult to find the exact team. In the drop-down menu in TeamsEditor (cell F3), I have now listed each team twice: once with their name (as before), and once with a description starting with their code.

If you want to be sure you are editing the right team, retrieve its code in BgroupsEditor in the cells below E14. Then go to TeamEditor, cell F3, and scroll down until you see the teams starting with their code. Select the right team, based on its code, and proceed.



triarius -> RE: Excel tool to mod fpools, bgroups, teams (10/1/2009 6:41:45 PM)

Version 1b now available, at the usual place. This allows you to edit nation, name and icon of teams. As before, you can also edit the composition of infantry teams, but not of other teams.



Richard III -> RE: Excel tool to mod fpools, bgroups, teams (12/5/2009 4:28:05 PM)

Hi

I wonder if I can use your editor to change ammo loadouts in the mortar squads ?

TIA.



kojusoki1 -> RE: Excel tool to mod fpools, bgroups, teams (12/6/2009 1:06:23 PM)

well i think it is fairly easy to make in excel in weapons.txt



kojusoki1 -> RE: Excel tool to mod fpools, bgroups, teams (12/12/2009 2:12:18 PM)

One thing - after editing teams, I stronlgy suggest to check them in the workbook as I had some problems with ammo check. If you open the "official" TLD workbook excel, you will find some tables checking if some of the values are correct. Total ammo is not correct - at least in my case. Please, check it as I can be wrong, but I think I am not



triarius -> RE: Excel tool to mod fpools, bgroups, teams (12/15/2009 7:49:22 PM)

I'm afraid it is not possible to edit the weapons file with the spreadsheet...



7A_Woulf -> RE: Excel tool to mod fpools, bgroups, teams (1/28/2010 11:17:46 AM)

Bought TLD a few days ago, with the only purpose of starting my modding career! [8D]

This is an excellent tool, but I get the same error-message as Rift when I tries to use the macro versions on my Excel 2002, so I takes a lot of cut & pasting to work with it...


But just a question; -In the TeamsEditor you can chose "Role" for every soldier, what does the different roles mean? [&:]



7A_Woulf -> RE: Excel tool to mod fpools, bgroups, teams (2/1/2010 7:50:44 AM)


quote:

ORIGINAL: Richard III

Hi

I wonder if I can use your editor to change ammo loadouts in the mortar squads ?

TIA.


You change the ammo load in the soldiers file, easiest way is to use the CC Longest Day Workbook v13. (I use both that and triarius workbook parallel when I'm working on the teams and FP's.)

But I've run in to two questions this first week, don't know if they belong here or somewhere else in the forum:

1) Sometimes the British Bren gunners are coded as 'Basic soldier', sometimes as 'Tank, gun or mortar crew'. Which one is correct?
2) I'm planing on creating forward observers, but the CC Longest Day Workbook v13 says "Weapon class index for soldier / vehicle data files. 200 max is arbitrary and can be increased. NOTE: Some weapon classes are hard coded! Off board artilleries, mortars and all grenades should never change indexed positions."
-Does this mean that I can't create different 'Arty Explosion' to represent different calibres? (My plan is to have two types: 150mm artillery and off-shore naval bombardment; -One or two salvoes of really big guns...)

Cheers



triarius -> RE: Excel tool to mod fpools, bgroups, teams (2/5/2010 8:11:02 PM)

I'm afraid you can not use the macros with Excel 2002, you need at least Excel 2003. For Mafi, I created a version which is "macro-free". I suggest you use this one (if you are not already doing so). You will still have to cut and paste a lot, but the spreadsheet should offer you some guidance.

I'm not really a specialist on how CC works, but I think the role of each soldier defines how he behaves, what influence he has on the morale of his troops, and maybe also what influence he has on other teams nearby.

By the way, I noticed there is a problem with one of these roles in the spreadsheet: "Tank, gun or mortar crew" is always split over two lines in the drop-down menu. This is due to Excel, and I have found no solution for it. You should simply type this one by hand.



7A_Woulf -> RE: Excel tool to mod fpools, bgroups, teams (2/7/2010 1:08:39 AM)

Using the macro-free spreadsheet,thanks for an excellent tool!! [8D]
(...and there is no problems with the "Tank, gun or mortar crew" in the drop-down menu of that version, works like a charm.)

I think I've cracked the 'mystery' with the Bren-gunner as well: In 'soldier' he has the Bren as a crewed weapon, so I think they must be "Tank, gun or mortar crew" in order to use it... (Seems logical anyway [8|])

cheers



CSO_Talorgan -> RE: Excel tool to mod fpools, bgroups, teams (2/16/2010 9:01:27 PM)


quote:

ORIGINAL: 7A_Woulf

NOTE: Some weapon classes are hard coded! Off board artilleries, mortars and all grenades should never change indexed positions."


I thought this did not apply to the re-releases?



d1973 -> RE: Excel tool to mod fpools, bgroups, teams (3/28/2010 12:22:15 AM)

I managed to change everything I wanted except the unit names.I mean I changed the names in bgroups and fpools and replaced the text files in BASE folder,but when I open the game and try to create a new scenario the battle groups names are unchanged! Am I missing anything???



CSO_Talorgan -> RE: Excel tool to mod fpools, bgroups, teams (4/4/2010 11:00:51 AM)

Do you mean the white writing on black across the top of the screen?



Tejszd -> RE: Excel tool to mod fpools, bgroups, teams (4/4/2010 9:00:39 PM)

You are probably right CSO_Talorgan, he still needs to edit the graphical names in ScrnGadg.gdg....

Use RtBTool to extract/open the current file and then edit the TGA graphic files (make sure to save in 16 bit and if I remember correctly to flip them upside when you save the new version). Then use RtBTool to repack the file....





CSO_Talorgan -> RE: Excel tool to mod fpools, bgroups, teams (4/10/2010 9:41:30 PM)


quote:

ORIGINAL: Tejszd

flip them upside when you save the new version). Then use RtBTool to repack the file....


I think flipping is only necessary with GadgetMunger.



kojusoki1 -> RE: Excel tool to mod fpools, bgroups, teams (5/5/2010 8:45:55 PM)

Triarius - you have created a wonderfull tool - but it works only for 4 days :)
I have created a sub mod for 25days and had to do many things manually. Any chance you can make it for a preseted number of days?

thanx
Michal



CSO_Talorgan -> RE: Excel tool to mod fpools, bgroups, teams (5/7/2010 10:30:32 PM)


quote:

ORIGINAL: kojusoki1

it works only for 4 days


That's a game limitation rather than something Triarius has done.



kojusoki1 -> RE: Excel tool to mod fpools, bgroups, teams (5/7/2010 10:41:02 PM)

no, TLD can work for many more days - I did a mod working 24days.
If you want I can copy campaign.txt



CSO_Talorgan -> RE: Excel tool to mod fpools, bgroups, teams (5/11/2010 5:39:35 PM)


quote:

ORIGINAL: kojusoki1

I did a mod working 24days.


Each with four 6 hour segments?



Page: [1] 2   next >   >>

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
1.296875