Spreadsheet of M2TW unit stats?

[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