Panzer Corps Units stats in a friendly PDF

[VPaulus]

Finally I had some time to update to 1.05.
Added more columns.
http://www.gamefront.com/files/21149601 ... +Stats.pdf

1.10:
PDF:
http://www.sendspace.com/file/a2gvq2

A table in Excel:
http://www.sendspace.com/file/jlg3ds

[lucke689]

Thanks! That is handy to have...

[jaggy]

Thanks, VPaulus! I wanted to check out unit comparisons of German and Allied units and this is perfect.

[impar]

Missing the switch ability.

[VPaulus]

Missing the switch ability.

I would have to reduce the font size.
Is that so important?

[impar]

Once more switchable units appear, yes.

Instead of reducing font size, my suggestion would be something like this:


You have now something like this:

That might be enough to squeeze one more column.

And, ideally, the column would indicate into what unit it is switched to/from.

[VPaulus]

Once more switchable units appear, yes.
Instead of reducing font size, my suggestion would be something like this:

Because that was a quick and dirty job, otherwise I wouldn't do it.
Even though it took me more than one hour to do it, I'm not used to work in spreadsheets.

[Kerloc]

thanks for that pdf - very useful

[El_Condoro]

If anyone likes to use Excel, I have added a filtered form of the 1.05 efile here http://dl.dropbox.com/u/16283408/Panzer ... 01.05.xlsx (XLSX)
http://dl.dropbox.com/u/16283408/Panzer ... 201.05.xls (XLS)

The switch is listed at the end and the flags, classes and movement types have been converted to words from numbers.

[spartan18a]

Awesome, again my suggestion integrate it in the library in the game.

[Aloo]

Awesome, again my suggestion integrate it in the library in the game.

That is a good idea. Not everyone is using the forums.

[timberwolf15]

what are forums ... sorry just kidding

[fliegenderstaub]

Very useful! Thank you!

[TJD]

If anyone likes to use Excel, I have added a filtered form of the 1.05 efile here http://dl.dropbox.com/u/16283408/Panzer ... 01.05.xlsx (XLSX)
http://dl.dropbox.com/u/16283408/Panzer ... 201.05.xls (XLS)

The switch is listed at the end and the flags, classes and movement types have been converted to words from numbers.

Special thanks for making this available in Excel, and in both formats. The filters in Excel make this a very useful and accessible resource. I learned a lot very quickly.

Best,

Tim

[robman]

Any chance of getting an updated Excel version that incorporates the changes in 1.10/AK? Pretty please? [insert Bambi icon here]

[Chris10]

Any chance of getting an updated Excel version that incorporates the changes in 1.10/AK? Pretty please? [insert Bambi icon here]

[insert "If need be.." icon here]...but dont expect wonders Bambi ...
I just excluded a few columns and converted straight to PDF from Excel Spreadsheet..
so there is a truckload of unneccessary entrys and empty reserved lines but for the moment it has to do until somebody else has time to make a
proper one
http://www.file-upload.net/download-465 ... 0.rar.html

EDIT: I wonder..
If people have Excel they can do all this themself..especially making an Excel spreadsheet out of the equipment.pzdat...why asking others ?

[robman]

Many thanks! Bambi is happy. How does one convert the pzdat file to a spreadsheet? I have Excel but I don't know how to do this.

[VPaulus]

I've added a few more columns, namely the traits.
I've also sorted by country, a second level by class and finally in alphabetical.
PDF:
http://www.sendspace.com/file/a2gvq2

A table in Excel:
http://www.sendspace.com/file/jlg3ds

[Chris10]

Many thanks! Bambi is happy. How does one convert the pzdat file to a spreadsheet? I have Excel but I don't know how to do this.

Launch Excel > File > Open > navigate to data folder > check ALL FILE TYPES > .pzdat files appear > navigate to equipment.pzdat > click open >
Excel promt window about format > click continue-continue-finish> Excel converts the file into spreadsheet from there you can save to whatever or export to PDF

[robman]

Many thanks! Bambi is happy. How does one convert the pzdat file to a spreadsheet? I have Excel but I don't know how to do this.

Launch Excel > File > Open > navigate to data folder > check ALL FILE TYPES > .pzdat files appear > navigate to equipment.pzdat > click open >
Excel promt window about format > click continue-continue-finish> Excel converts the file into spreadsheet from there you can save to whatever or export to PDF

That is SO EASY! Thanks for the help. For others trying this, make sure that "delimited" is selected in Excel's format window. It automatically takes care of the rest.