Has anyone compiled a spreadsheet of unit stats? I've tried to get the stats to import into Excel and Quattro Pro but I'm having a heck of a time getting them sorted.
:help:
Printable View
Has anyone compiled a spreadsheet of unit stats? I've tried to get the stats to import into Excel and Quattro Pro but I'm having a heck of a time getting them sorted.
:help:
Thanks R'as!
Thanks again, these are great; Is there any way you can add a "cost" column?
Wow, that saves me a buttload of work :) Thanks m8!
I've started with infantry and will add to the others. May take a while, it's Christmas. :san_smiley:Quote:
Originally Posted by Dionysus9
Only thing missing is the morale score....
Thanks for the great work!!!
There's a new version here.
I've added the mental stats. Should be a complete list now.
:bow:
Great, any way to get this in excell document, so it can be sorted?
Another Spreadsheet: http://www.twcenter.net/forums/downl...do=file&id=984
There seems to be a lot of people with a lot of time out there and we are thankful for this spreadsheets.
don't quite understand this fully, but I shall print it out now and figure it out
Thanks m8 :) :)
I second that, thanks again for ure efforts :yes:Quote:
Originally Posted by Aonar
This is fairly easy to do.Quote:
Originally Posted by Lavos
1. Open your excel program.
2. Open the web page at R'as link (for example, the infantry one).
3. Select the text you want to copy. (Select the upper left corner of the table with your left mouse button. While holding the button down, move the mouse to the lower right corner, showing all the text to be highlighted. Release the left mouse button and click the right mouse button, opening the menu. Select "Copy".)
4. Paste the text into excel. (Go to your excel program. Pick an empty tab. Click in the upper left cell. Right click with your mouse. Select "Paste Special". Select "HTML". Text is now pasted in row and column format).
5. Rename the excel tab. (Right click on the tab you just pasted the sats into. Pick "Rename". Change name to what you want. Eg. "Infantry".)
6. Repeat steps 2 to 5 as needed.
I'm using Win XP and Excel 2002. I was able to complete this faster than it took me to write this post. Hope this helps.
Thank you R'as and others for compiling the stat files! ~:cheers:
Agravain of Orkney
Good idea but it's a pity it doesn't work with Microsofts spreadsheet program (Microsoft Works). The 'Paste Special' is greyed out. :thumbsdown:
I don't have Excel.
The copy/paste puts all the details in but not in their correct columns, only in their rows. Hard to read the information when it is like that.
http://www.openoffice.org/Quote:
I don't have Excel.
Open office is a free source code program. It is like MS Office. It is a very good program.
I've cleaned up the tables a bit and uploaded the excel file.
Download here
:bow:
R'as