@ncscswitch:
If you know HOW to do that, contact our site owner (DJensen) and see if he wants to do the data capture…
I’m a software engineer by trade, so I know how. I don’t have a lot of free-time however.
A simple spreadsheet to track a single players stats would look like this:
Games Games as Axis Wins Losses Ties Wins as Axis Rounds Played Total Battles Total Battles as Axis Total Battles Won Total Battles Won as Axis Win Percentage Axis Win Percentage Allied Win Percentage Rounds per Game Average Battles per Round Battle Victory Percentage Axis Battle Victory Percentage Allied Battle Victory Percentage Win Percentage plus Victory Percentage
=C2/A2 =F2/B2 =(C2-F2)/(A2-B2) =G2/A2 =H2/G2 =J2/H2 =K2/I2 =(J2-K2)/(H2-I2) =L2+Q2
The names are all on one line separated by tabs, the next line has 11 tabs, then each formula is separated by a tab. Paste this into notepad and save as stats.txt
Then open Excel. Open a new workbook. On the menu, go to Data –> Import External Data --> Import Data…
Navigate to the location of your .txt file. At the bottom for “Files of Type:”, select “Text Files”. Select “stats.txt” and then click on the “Open” button.
On the “Text Import Wizard”, click on “Delimited” and then click on the “Finish” button. On the “Import Data” window, select “Existing Worksheet” and then click on the “Ok” button.
That should give you the working spreadsheet. Feel free to do a little word wrap, centering, and other formatting to suit your tastes. You only need to enter data up to “Total Battles Won as Axis”. The rest of them will calculate themselves. I have validated that copying the above code and pasting it into Notepad version 5.1 and then importing with Excel version 10.6834.6830 SP3 works.
UPDATE: correction for Allied Win Percentage