Posted: Thu Feb 28, 2008 7:46 pm Post subject: CC Data spreadsheet Workbooks and Revised QClone
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.
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.
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
Posted: Fri Feb 29, 2008 5:04 am Post subject: Care, Feeding and Maintenence of the CC Data Workbooks
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.
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....
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
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
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!