View Single Post
  #4  
Old March 4th, 2011, 01:00 AM
Mobhack's Avatar

Mobhack Mobhack is offline
National Security Advisor
 
Join Date: Mar 2005
Location: Dundee
Posts: 5,994
Thanks: 488
Thanked 1,928 Times in 1,254 Posts
Mobhack is on a distinguished road
Default Re: Spreadsheet Of Statistics For Tanks

Quote:
Originally Posted by jeffreywilens View Post
Thanks. I looked at Mobhack and viewed an individual OOB (I picked an obscure one so as not to mess anything up). I did not see an "export to CSC" command. I did see "write CSV files" but couldn't see where any file was saved.

Probably I'm looking for more of a crib sheet and I may have to manually write down the pertinent information onto the spreadsheet if there is no way to filter certain fields and have them input into the correct fields on the spreadsheet.

I do have Excel.
CSV is "Comma Separated Variable" - a format as old as computers, most likely. A simple text file you can open in a text editor, with variables separated by commas.

If you unzip the file to somewhere, excel should show it as an excel type (with appropriate icon). Otherwise, use file/open and select CSV from the types available in the dialogue. You may need to tell it that line 1 of the data is column headers.

For Mobhack - load the file and then press the "dump CSV" button. All OOBS will be processed (ignore any messages re missing oobs, in WW2 anyway). The info text bar at the bottom will tell you where. Each OOB will have a separate weapons, units and formations CSV file dumped.

(All the WW2 OOBS as a CSV dump are 12MB)

Combining several OOBS into one spreadsheet if required, I leave up to you.

Andy

NB - the CSV dumps do not have all the added data, the code is very old. Things like winter icon numbers and so on wont be listed.
Reply With Quote