Close Combat Series :: View topic - CC Data spreadsheet Workbooks and Revised QClone

CC Data spreadsheet Workbooks and Revised QClone

through

[^/[Print]\]

Close Combat Series -> Modding Workshop

#1: CC Data spreadsheet Workbooks and Revised QClone Author: Senior_Drill, Location: 22134

Posted: Thu Feb 28, 2008 7:46 pm
—
These have been around for a while, but I never did get around to posting all of them here I believe.

Attached are zip files for fulll stand alone folders of the revised QClone for CC2 through CC5 and one for CCMv3.1 and RtB. The columns have full infomation and there are no "Unknown" columns in them.

Also attached are MS Excel Data workbooks for CC3, CoI, CC4, CC5, CCMv3.1, RtB and CCMT. I never did get around to doing one for CC2 as the files are .txt and have the tables below the data fields and one does not need Qclone for editing them.

If you do not have MS Excel, then get the freeware Open Office Suite. The workbook and the game data fpr CoI was done on Open Office.

Sorry, out of time. I have to go. CoI, CC4, CC5 and all will be posted later tonight.

Last edited by Senior_Drill on Sat Mar 01, 2008 12:45 am; edited 1 time in total

QClone for RtB-CCMv3.1.zip

Description:

This is the real QClone for RtB and CCMv3.1 The previous one was a copy of the CC2 to CC5 version.
Use only the CC3 buttons and menus. Read the ReadMe.

Download

Filename:

QClone for RtB-CCMv3.1.zip

Filesize:

342.08 KB

Downloaded:

757 Time(s)

CC3 Data Workbook Rev1.zip

Description:

CC3 Data Workbook with the stock and patched data

Download

Filename:

CC3 Data Workbook Rev1.zip

Filesize:

84.86 KB

Downloaded:

528 Time(s)

Qclone for CC2 to CC5.zip

Description:

Revised Qclone for CC2 to CC5. It unzips as a full, stand alone folder with the revised Qclone .ini's. It can be placed along side your original Qclone.

Download

Filename:

Qclone for CC2 to CC5.zip

Filesize:

343.58 KB

Downloaded:

680 Time(s)

#2: CC Data spreadsheet Workbooks and Revised QClone, cont. Author: Senior_Drill, Location: 22134

Posted: Fri Feb 29, 2008 3:09 am
—
Ok, I'm back and now for the rest of them. Looks like a three attachment limit per post.

Edited to remove the faulty CC5 Data Workbook.

See Tejszd's post below.

Last edited by Senior_Drill on Fri Feb 29, 2008 5:08 am; edited 2 times in total

CC4-Stock- Data Workbook Rev3.zip

Description:

CC4 Stock and Patched Data Workbook. Revised QClone for CC2 to CC5 format

Download

Filename:

CC4-Stock- Data Workbook Rev3.zip

Filesize:

301.83 KB

Downloaded:

520 Time(s)

CC3 COI Data Workbook Rev1.zip

Description:

CC3 Cross of Iron Data Workbook. Revised QClone for CC2 to CC5 format

Download

Filename:

CC3 COI Data Workbook Rev1.zip

Filesize:

160.61 KB

Downloaded:

499 Time(s)

#3: CC Data spreadsheet Workbooks and Revised QClone, cont. Author: Senior_Drill, Location: 22134

Posted: Fri Feb 29, 2008 3:25 am
—
RtB, CCMv3.1

CCMT in a few minutes while I ensure it has been updated with the patch data.

CCMv3.1 Data Workbook Rev2.zip

Description:

CCM v3.1 Data Workbook.
Revised QClone for RtB and CCMv3.1 format

Download

Filename:

CCMv3.1 Data Workbook Rev2.zip

Filesize:

496.13 KB

Downloaded:

448 Time(s)

CC RtB Data Workbook.zip

Description:

CC RtB Data Workbook.
Revised Qclone for RtB and CCMv3.1 format

Download

Filename:

CC RtB Data Workbook.zip

Filesize:

488.48 KB

Downloaded:

444 Time(s)

#4: CC Data spreadsheet Workbooks and Revised QClone, cont. Author: Senior_Drill, Location: 22134

Posted: Fri Feb 29, 2008 4:00 am
—
And finally, CCMT

Note to Mooxe and Mods: These should be made available in the downloads section.

CCMT Stock Plus Patch Data Workbook Rev1.zip

Description:

CCMT Stock Plus Patch Data Workbook. There is no QClone for this and none is needed as the data files are .txt file

Download

Filename:

CCMT Stock Plus Patch Data Workbook Rev1.zip

Filesize:

300.98 KB

Downloaded:

462 Time(s)

#5: Author: Tejszd, Location: Canada

Posted: Fri Feb 29, 2008 4:01 am
—
Drill,

Not sure what happened but the vehicles sheet within CC5-Stock-Data Workbook Rev8.zip does not scroll properly any more and and the conditional formatting isn't working.

I have a different version of CC5-Stock-Data Workbook Rev8.zip that you posted in the CSO forum that works....

Edit: Deleted attachment as it has been replaced by a newer version CC5-Stock-Data Workbook Rev10.xls posted later in this thread.

Last edited by Tejszd on Sun Mar 23, 2008 9:52 pm; edited 1 time in total

#6: Care, Feeding and Maintenence of the CC Data Workbooks Author: Senior_Drill, Location: 22134

Posted: Fri Feb 29, 2008 5:04 am
—
Several of the worksheets in the CC Data Workbooks contain calculator formulas in sections to the right of the game data.

Great care should be taken to not mess these sections up as the repair process can be long and tedious, even if you know and understand the formulas. You can mess up the sections by

1. Pasting an entire row from one worksheet or workbook to another, even if it has the same calculators. The relative reference will change to the worksheet the new data came from.

2. Dragging and droppping a range of data or an entire row will also change the relative reference of the calulator cells.

3. Deleting or inserting an entire row of data can mess up the formulas or have a row with no calculator formulas.

Make it a general rule for yourself to NEVER edit directly on a worksheet that has calulator sections.

Instead, create a new worksheet and name it something like Soldiers Work. Copy the header and game data file from the worksheet and paste it on this new worksheet. You are now free to cut and paste, drag and drop and add or delete rows, sections or columns all you want.

When you are done, copy the data and paste it back to the original worksheet. The Ammo count columns in the BlueTeams, RedTeams and Soldiers worksheets can then be updated and the Vehicles worksheet can be checked for gun information errors. If you have deleted rows of data and are now pasting in fewer lines, simply highlight the range of extra cells and press the Delete key.

MAKING A DATA WORKBOOK OF AN EXISTING MOD

This is fairly easy. First, make a copy of the game's stock data workbook and rename it for the mod.

Open the workbook and highlight all the data including the Qclone header line and press the Delete Key on each worksheet.

Open the Revised Qclone for CC2 - CC5 and open the Data\Base files for the mod.

Then use File\Export\Tab Delimited to create a text file of the data. Open this text file with MS Excel or Open Office. Highlight the entire range of data (and just the data, none of the blank cells) and paste it into cell A4. Repeat for each data file.

Go to the Ammo Count (very last data) columns in the RU/AlsTeams, GETeams and Soldiers worksheets and change the numbers to those from the calculators. If you can copy and paste several rows of data from the calculator to the Ammo Count column at the same time, remember to select Paste Special\Values so that you don't paste the formulas instead of the number they have produce.

After making any changes to the data you want (remembering to do most of that on a copy of the worksheet first!) highlight and Copy the QClone header row and the game data.

Then open the data .adb file in QClone. The go File\Import\Tab Delimited. Check the bottom rows to ensure that there are no extra lines that need to be deleted and repack the .adb.

#7: Author: Senior_Drill, Location: 22134

Posted: Fri Feb 29, 2008 5:07 am
—

Tejszd wrote:

Drill,

Not sure what happened but the vehicles sheet within CC5-Stock-Data Workbook Rev8.zip does not scroll properly any more and and the conditional formatting isn't working.

I have a different version of CC5-Stock-Data Workbook Rev8.zip that you posted in the CSO forum that works....

Thanks for the quick catch Tejszd!

#8: Author: squadleader_id, Location: Soerabaja

Posted: Sat Mar 01, 2008 12:14 am
—
Thanks a lot, Drill and Tejszd!
These workbooks are great tools for modders...especially for noob modders.

#9: Author: yukongold, Location: Whitehorse,Canada

Posted: Mon Mar 03, 2008 1:04 am
—
Indeed, Thank-you to Senior Drill and all who contributed to the workbooks.

cheers

#10: Author: Tejszd, Location: Canada

Posted: Sun Mar 23, 2008 9:25 pm
—
I have updated the CC5-Stock-Data Workbook to Rev10 adding the following changes;

9) AlsTeams and GeTeams Sheets: added columns to; check soldier list defined, soldier type defined and team size for mismatch; check Team size against vehicle crew size for mismatch and check team ammo against infantry ammo value or vehicle ammo value for mismatch.

10)Soldiers Sheet: added columns to check Soldier ammo entered against calculated ammo for a mismatch

CC5-Stock-Data Workbook Rev10.zip

Description:

Download

Filename:

CC5-Stock-Data Workbook Rev10.zip

Filesize:

444.67 KB

Downloaded:

490 Time(s)

#11: Author: Tejszd, Location: Canada

Posted: Tue Jun 10, 2008 8:16 am
—
Bump - Administrators please update the download section with the "CC5-Stock-Data Workbook Rev10.zip" posted in this thread....

#12: Author: Tejszd, Location: Canada

Posted: Wed Jul 02, 2008 4:56 am
—

Tejszd wrote:

Bump - Administrators please update the download section with the "CC5-Stock-Data Workbook Rev10.zip" posted in this thread....

Bump

Close Combat Series -> Modding Workshop

output generated using printer-friendly topic mod. All times are GMT

Page 1 of 1