Matrix Games Forums

 Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

Excel tool to mod fpools, bgroups, teams

 
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: The Longest Day >> Mods and Scenarios >> Excel tool to mod fpools, bgroups, teams Page: [1] 2   next >   >>
Login
Message << Older Topic   Newer Topic >>
Excel tool to mod fpools, bgroups, teams - 6/30/2009 6:58:15 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		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
Post #: 1
RE: Excel tool to mod fpools, bgroups, teams - 6/30/2009 11:53:46 PM   
Andrew Williams


Posts: 6116
Joined: 1/8/2001
From: Australia
Status: offline 		thanks Triarius... will have alook at this today.

:)

(in reply to triarius)
Post #: 2
RE: Excel tool to mod fpools, bgroups, teams - 7/1/2009 12:02:23 PM   
Andrew Williams


Posts: 6116
Joined: 1/8/2001
From: Australia
Status: offline 		Very nice indeed Triarius.....

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


good stuff guys

(in reply to Andrew Williams)
Post #: 3
RE: Excel tool to mod fpools, bgroups, teams - 7/13/2009 5:44:41 PM   
Mafi


Posts: 335
Joined: 12/19/2007
From: Germany
Status: offline
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

(in reply to triarius)
Post #: 4
RE: Excel tool to mod fpools, bgroups, teams - 7/13/2009 8:00:59 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		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

(in reply to triarius)
Post #: 5
RE: Excel tool to mod fpools, bgroups, teams - 7/13/2009 8:12:04 PM   
Mafi


Posts: 335
Joined: 12/19/2007
From: Germany
Status: offline
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

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


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		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...

(in reply to Mafi)
Post #: 7
RE: Excel tool to mod fpools, bgroups, teams - 7/18/2009 7:23:35 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		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.

(in reply to triarius)
Post #: 8
RE: Excel tool to mod fpools, bgroups, teams - 7/26/2009 6:23:59 PM   
Mafi


Posts: 335
Joined: 12/19/2007
From: Germany
Status: offline
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

(in reply to triarius)
Post #: 9
RE: Excel tool to mod fpools, bgroups, teams - 8/21/2009 5:50:51 PM   
Rift

 

Posts: 37
Joined: 7/23/2009
Status: offline 		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




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

Attachment (1)

< Message edited by Rift -- 8/21/2009 5:52:22 PM >

(in reply to Mafi)
Post #: 10
RE: Excel tool to mod fpools, bgroups, teams - 8/22/2009 9:54:23 AM   
Rift

 

Posts: 37
Joined: 7/23/2009
Status: offline 		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

(in reply to Rift)
Post #: 11
RE: Excel tool to mod fpools, bgroups, teams - 8/23/2009 4:24:57 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		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.

(in reply to Rift)
Post #: 12
RE: Excel tool to mod fpools, bgroups, teams - 10/1/2009 6:41:45 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		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.

(in reply to triarius)
Post #: 13
RE: Excel tool to mod fpools, bgroups, teams - 12/5/2009 4:28:05 PM   
Richard III


Posts: 710
Joined: 10/24/2005
Status: offline 		Hi

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

TIA.

< Message edited by Richard III -- 12/5/2009 4:29:40 PM >

(in reply to triarius)
Post #: 14
RE: Excel tool to mod fpools, bgroups, teams - 12/6/2009 1:06:23 PM   
kojusoki1

 

Posts: 172
Joined: 1/6/2009
Status: offline 		well i think it is fairly easy to make in excel in weapons.txt

(in reply to Richard III)
Post #: 15
RE: Excel tool to mod fpools, bgroups, teams - 12/12/2009 2:12:18 PM   
kojusoki1

 

Posts: 172
Joined: 1/6/2009
Status: offline 		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

< Message edited by kojusoki1 -- 12/12/2009 2:13:36 PM >

(in reply to kojusoki1)
Post #: 16
RE: Excel tool to mod fpools, bgroups, teams - 12/15/2009 7:49:22 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		I'm afraid it is not possible to edit the weapons file with the spreadsheet...

< Message edited by triarius -- 12/15/2009 7:51:57 PM >

_____________________________


(in reply to Richard III)
Post #: 17
RE: Excel tool to mod fpools, bgroups, teams - 1/28/2010 11:17:46 AM   
7A_Woulf

 

Posts: 91
Joined: 1/28/2010
Status: offline 		Bought TLD a few days ago, with the only purpose of starting my modding career!

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?

(in reply to triarius)
Post #: 18
RE: Excel tool to mod fpools, bgroups, teams - 2/1/2010 7:50:44 AM   
7A_Woulf

 

Posts: 91
Joined: 1/28/2010
Status: offline
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

(in reply to Richard III)
Post #: 19
RE: Excel tool to mod fpools, bgroups, teams - 2/5/2010 8:11:02 PM   
triarius


Posts: 37
Joined: 6/29/2008
From: Belgium
Status: offline 		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.

_____________________________


(in reply to 7A_Woulf)
Post #: 20
RE: Excel tool to mod fpools, bgroups, teams - 2/7/2010 1:08:39 AM   
7A_Woulf

 

Posts: 91
Joined: 1/28/2010
Status: offline 		Using the macro-free spreadsheet,thanks for an excellent tool!!
(...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 )

cheers

(in reply to triarius)
Post #: 21
RE: Excel tool to mod fpools, bgroups, teams - 2/16/2010 9:01:27 PM   
CSO_Talorgan


Posts: 768
Joined: 3/10/2007
Status: offline
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?

(in reply to 7A_Woulf)
Post #: 22
RE: Excel tool to mod fpools, bgroups, teams - 3/28/2010 12:22:15 AM   
d1973

 

Posts: 24
Joined: 7/29/2002
From: Buc
Status: offline 		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???

(in reply to CSO_Talorgan)
Post #: 23
RE: Excel tool to mod fpools, bgroups, teams - 4/4/2010 11:00:51 AM   
CSO_Talorgan


Posts: 768
Joined: 3/10/2007
Status: offline 		Do you mean the white writing on black across the top of the screen?

(in reply to d1973)
Post #: 24
RE: Excel tool to mod fpools, bgroups, teams - 4/4/2010 9:00:39 PM   
Tejszd

 

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



(in reply to CSO_Talorgan)
Post #: 25
RE: Excel tool to mod fpools, bgroups, teams - 4/10/2010 9:41:30 PM   
CSO_Talorgan


Posts: 768
Joined: 3/10/2007
Status: offline
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.

(in reply to Tejszd)
Post #: 26
RE: Excel tool to mod fpools, bgroups, teams - 5/5/2010 8:45:55 PM   
kojusoki1

 

Posts: 172
Joined: 1/6/2009
Status: offline 		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

(in reply to CSO_Talorgan)
Post #: 27
RE: Excel tool to mod fpools, bgroups, teams - 5/7/2010 10:30:32 PM   
CSO_Talorgan


Posts: 768
Joined: 3/10/2007
Status: offline
quote:

ORIGINAL: kojusoki1

it works only for 4 days


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

(in reply to kojusoki1)
Post #: 28
RE: Excel tool to mod fpools, bgroups, teams - 5/7/2010 10:41:02 PM   
kojusoki1

 

Posts: 172
Joined: 1/6/2009
Status: offline 		no, TLD can work for many more days - I did a mod working 24days.
If you want I can copy campaign.txt

(in reply to CSO_Talorgan)
Post #: 29
RE: Excel tool to mod fpools, bgroups, teams - 5/11/2010 5:39:35 PM   
CSO_Talorgan


Posts: 768
Joined: 3/10/2007
Status: offline
quote:

ORIGINAL: kojusoki1

I did a mod working 24days.


Each with four 6 hour segments?

(in reply to kojusoki1)
Post #: 30
Page:   [1] 2   next >   >>
All Forums >> [New Releases from Matrix Games] >> Close Combat Series >> Close Combat: The Longest Day >> Mods and Scenarios >> Excel tool to mod fpools, bgroups, teams Page: [1] 2   next >   >>
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.969