Spreadsheet of M2TW unit stats?

[Dionysus9]

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.

[R'as al Ghul]

https://forums.totalwar.org/vb/showthread.php?t=75809
https://forums.totalwar.org/vb/showthread.php?t=75805
https://forums.totalwar.org/vb/showthread.php?t=75812
https://forums.totalwar.org/vb/showthread.php?t=75790

[Dionysus9]

Thanks R'as!

[Dionysus9]

Thanks again, these are great; Is there any way you can add a "cost" column?

[YellowMelon]

Wow, that saves me a buttload of work :) Thanks m8!

[R'as al Ghul]

Thanks again, these are great; Is there any way you can add a "cost" column?

I've started with infantry and will add to the others. May take a while, it's Christmas.

[RTKMercurius]

Only thing missing is the morale score....

Thanks for the great work!!!

[R'as al Ghul]

There's a new version here.
I've added the mental stats. Should be a complete list now.

[Lavos]

Great, any way to get this in excell document, so it can be sorted?

[CeltiberoMordred]

Another Spreadsheet: http://www.twcenter.net/forums/downl...do=file&id=984

[Fenix7]

There seems to be a lot of people with a lot of time out there and we are thankful for this spreadsheets.

[ELITEofWARMANGINGERYBREADMEN88]

don't quite understand this fully, but I shall print it out now and figure it out

Thanks m8 :) :)

[RTKBarrett]

There seems to be a lot of people with a lot of time out there and we are thankful for this spreadsheets.

I second that, thanks again for ure efforts

[Agravain of Orkney]

Great, any way to get this in excell document, so it can be sorted?

This is fairly easy to do.

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!

[Jochi Khan]

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.
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.

[Fenix7]

I don't have Excel.

http://www.openoffice.org/

Open office is a free source code program. It is like MS Office. It is a very good program.

[R'as al Ghul]

I've cleaned up the tables a bit and uploaded the excel file.
Download here


R'as