Welcome to Close Combat Series
  Login or Register Home  ·  Downloads  ·  Forums  ·  Combat Camera  ·  Help  

  Survey
Do incapacitations count as a soldier's kills?

Yes
No



Results
Polls

Votes 1179
Comments: 1

  Shout Box!!

Only registered users can shout. Please login or create an account.

  Main Menu
Articles & News  
    Help
    Player`s News
    Site News
    Multiplayer
    Terrain Challenge
    Boot Camp
Community  
    Forums
    Downloads
    Combat Camera
    MOOXE @ Youtube
    Statistics
Members  
    Private Messages
    Your Account
    Logout

  Donations
Anonymous - $25.00
08/15/2022

Anonymous - $25.00
08/15/2022

Anonymous - $25.00
12/18/2021

Anonymous - $100.00
11/08/2021

Anonymous - $15.00
04/09/2021

Anonymous - $100.00
04/05/2021

Anonymous - $20.00
02/20/2021

Anonymous - $10.00
12/29/2020

Anonymous - $1.00
11/06/2020

ZAPPI4 - $20.00
10/10/2020

Find our site useful? Make a small donation to show your support.



Search for at
Close Combat Series Advanced Search


 Author
Message
 
Senior_Drill

Rep: 9.7
votes: 2


PostPosted: Thu Feb 28, 2008 7:46 pm Post subject: CC Data spreadsheet Workbooks and Revised QClone Reply with quote

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.



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:  753 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:  524 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:  674 Time(s)



C'est magnifique, mais ce n'est pas la guerre.


Last edited by Senior_Drill on Sat Mar 01, 2008 12:45 am; edited 1 time in total
Back to top
View user's profile Send private message
 
Senior_Drill

Rep: 9.7
votes: 2


PostPosted: Fri Feb 29, 2008 3:09 am Post subject: CC Data spreadsheet Workbooks and Revised QClone, cont. Reply with quote

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.



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:  516 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:  496 Time(s)



C'est magnifique, mais ce n'est pas la guerre.


Last edited by Senior_Drill on Fri Feb 29, 2008 5:08 am; edited 2 times in total
Back to top
View user's profile Send private message
 
Senior_Drill

Rep: 9.7
votes: 2


PostPosted: Fri Feb 29, 2008 3:25 am Post subject: CC Data spreadsheet Workbooks and Revised QClone, cont. Reply with quote

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:  445 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:  441 Time(s)



C'est magnifique, mais ce n'est pas la guerre.
Back to top
View user's profile Send private message
 
Senior_Drill

Rep: 9.7
votes: 2


PostPosted: Fri Feb 29, 2008 4:00 am Post subject: CC Data spreadsheet Workbooks and Revised QClone, cont. Reply with quote

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:  457 Time(s)



C'est magnifique, mais ce n'est pas la guerre.
Back to top
View user's profile Send private message
 
Tejszd

Rep: 133.6
votes: 19


PostPosted: Fri Feb 29, 2008 4:01 am Post subject: Reply with quote

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
Back to top
View user's profile Send private message
 
Senior_Drill

Rep: 9.7
votes: 2


PostPosted: Fri Feb 29, 2008 5:04 am Post subject: Care, Feeding and Maintenence of the CC Data Workbooks Reply with quote

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.


C'est magnifique, mais ce n'est pas la guerre.
Back to top
View user's profile Send private message
 
Senior_Drill

Rep: 9.7
votes: 2


PostPosted: Fri Feb 29, 2008 5:07 am Post subject: Reply with quote

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!


C'est magnifique, mais ce n'est pas la guerre.
Back to top
View user's profile Send private message
 
squadleader_id

Rep: 53.2
votes: 7


PostPosted: Sat Mar 01, 2008 12:14 am Post subject: Reply with quote

Thanks a lot, Drill and Tejszd!
These workbooks are great tools for modders...especially for noob modders.
Back to top
View user's profile Send private message Visit poster's website
 
yukongold

Rep: 7


PostPosted: Mon Mar 03, 2008 1:04 am Post subject: Reply with quote

Indeed, Thank-you to Senior Drill and all who contributed to the workbooks.

cheers
Back to top
View user's profile Send private message
 
Tejszd

Rep: 133.6
votes: 19


PostPosted: Sun Mar 23, 2008 9:25 pm Post subject: Reply with quote

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:  486 Time(s)

Back to top
View user's profile Send private message
 
Tejszd

Rep: 133.6
votes: 19


PostPosted: Tue Jun 10, 2008 8:16 am Post subject: Reply with quote

Bump - Administrators please update the download section with the "CC5-Stock-Data Workbook Rev10.zip" posted in this thread....
Back to top
View user's profile Send private message
 
Tejszd

Rep: 133.6
votes: 19


PostPosted: Wed Jul 02, 2008 4:56 am Post subject: Reply with quote

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


Bump
Back to top
View user's profile Send private message
 
 
Post new topicReply to topic printer-friendly view Close Combat Series Forum Index -> Modding Workshop


 
   
 


Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum




Forums ©





In August of 2004, Zappi, Homba, Bambam887, RedScorpion and MOOXE all pitched
in to create this Close Combat site. I would to thank all the people who have visited and
found this site to thier liking. I hope you had time to check out some of the great Close Combat
mods and our forums. I'd also like to thank all the members of our volunteer staff that have
helped over the years, and all our users that contributed to this site!