Page 1 of 2
Panzer Corps Units stats in a friendly PDF
Posted: Wed Jan 04, 2012 12:00 am
by VPaulus
Posted: Wed Jan 04, 2012 12:03 am
by lucke689
Thanks! That is handy to have...
Posted: Wed Jan 04, 2012 12:28 am
by jaggy
Thanks, VPaulus! I wanted to check out unit comparisons of German and Allied units and this is perfect.

Posted: Wed Jan 04, 2012 11:55 am
by impar
Missing the switch ability.
Posted: Wed Jan 04, 2012 12:09 pm
by VPaulus
impar wrote:Missing the switch ability.
I would have to reduce the font size.
Is that so important?
Posted: Wed Jan 04, 2012 12:17 pm
by 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.
Posted: Wed Jan 04, 2012 12:24 pm
by VPaulus
impar wrote: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.

Posted: Wed Jan 04, 2012 12:44 pm
by Kerloc
thanks for that pdf - very useful
Posted: Wed Jan 04, 2012 1:39 pm
by 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.
Posted: Wed Jan 04, 2012 9:53 pm
by spartan18a
Awesome, again my suggestion integrate it in the library in the game.

Posted: Thu Jan 05, 2012 10:24 am
by Aloo
spartan18a wrote:Awesome, again my suggestion integrate it in the library in the game.

That is a good idea. Not everyone is using the forums.
Re: Panzer Corps Units stats in a friendly PDF
Posted: Tue May 29, 2012 12:52 pm
by timberwolf15
what are forums ... sorry just kidding
Re: Panzer Corps Units stats in a friendly PDF
Posted: Wed May 30, 2012 9:04 am
by fliegenderstaub
Very useful! Thank you!

Re:
Posted: Fri Jun 01, 2012 10:55 am
by TJD
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
Re: Panzer Corps Units stats in a friendly PDF
Posted: Fri Aug 10, 2012 8:56 pm
by robman
Any chance of getting an updated Excel version that incorporates the changes in 1.10/AK? Pretty please? [insert Bambi icon here]
Re: Panzer Corps Units stats in a friendly PDF
Posted: Fri Aug 10, 2012 9:54 pm
by Chris10
robman wrote: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 ?
Re: Panzer Corps Units stats in a friendly PDF
Posted: Fri Aug 10, 2012 11:39 pm
by 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.
Re: Panzer Corps Units stats in a friendly PDF
Posted: Sat Aug 11, 2012 4:17 am
by 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
Re: Panzer Corps Units stats in a friendly PDF
Posted: Sat Aug 11, 2012 12:06 pm
by Chris10
robman wrote: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

Re: Panzer Corps Units stats in a friendly PDF
Posted: Sat Aug 11, 2012 2:07 pm
by robman
chris10 wrote:robman wrote: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.
