Panzer Corps Units stats in a friendly PDF

PC : Turn based WW2 goodness in the mold of Panzer General. This promises to be a true classic!

Moderators: Slitherine Core, Panzer Corps Moderators, Panzer Corps Design, Slitherine Core, Panzer Corps Moderators, Panzer Corps Design

VPaulus
Slitherine
Slitherine
Posts: 7778
Joined: Mon Dec 27, 2010 8:33 pm
Location: Portugal

Panzer Corps Units stats in a friendly PDF

Post by VPaulus » Wed Jan 04, 2012 12:00 am

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
Lance Corporal - SdKfz 222
Lance Corporal - SdKfz 222
Posts: 24
Joined: Wed Oct 05, 2011 10:10 am
Location: Minnesota

Post by lucke689 » Wed Jan 04, 2012 12:03 am

Thanks! That is handy to have...

jaggy
Staff Sergeant - Kavallerie
Staff Sergeant - Kavallerie
Posts: 349
Joined: Fri Aug 05, 2011 12:12 pm

Post by jaggy » Wed Jan 04, 2012 12:28 am

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

impar
Master Sergeant - Bf 109E
Master Sergeant - Bf 109E
Posts: 452
Joined: Sun Jul 24, 2011 8:53 am
Location: Portugal

Post by impar » Wed Jan 04, 2012 11:55 am

Missing the switch ability.

VPaulus
Slitherine
Slitherine
Posts: 7778
Joined: Mon Dec 27, 2010 8:33 pm
Location: Portugal

Post by VPaulus » Wed Jan 04, 2012 12:09 pm

impar wrote:Missing the switch ability.
I would have to reduce the font size.
Is that so important?

impar
Master Sergeant - Bf 109E
Master Sergeant - Bf 109E
Posts: 452
Joined: Sun Jul 24, 2011 8:53 am
Location: Portugal

Post by impar » Wed Jan 04, 2012 12:17 pm

Once more switchable units appear, yes.

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

You have now something like this:
Image
That might be enough to squeeze one more column.

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

VPaulus
Slitherine
Slitherine
Posts: 7778
Joined: Mon Dec 27, 2010 8:33 pm
Location: Portugal

Post by VPaulus » Wed Jan 04, 2012 12:24 pm

impar wrote:Once more switchable units appear, yes.
Instead of reducing font size, my suggestion would be something like this:
Image
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
Senior Corporal - Ju 87G
Senior Corporal - Ju 87G
Posts: 94
Joined: Tue Sep 06, 2011 12:51 pm

Post by Kerloc » Wed Jan 04, 2012 12:44 pm

thanks for that pdf - very useful

El_Condoro
Panzer Corps Moderator
Panzer Corps Moderator
Posts: 2072
Joined: Tue Jun 03, 2008 9:32 am

Post by El_Condoro » Wed Jan 04, 2012 1:39 pm

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
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 31
Joined: Wed Dec 28, 2011 2:26 pm
Location: Spain

Post by spartan18a » Wed Jan 04, 2012 9:53 pm

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

Aloo
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 217
Joined: Mon Oct 31, 2011 12:38 pm
Location: Poland
Contact:

Post by Aloo » Thu Jan 05, 2012 10:24 am

spartan18a wrote:Awesome, again my suggestion integrate it in the library in the game. :D
That is a good idea. Not everyone is using the forums.

gunny
Lance Corporal - SdKfz 222
Lance Corporal - SdKfz 222
Posts: 21
Joined: Wed Nov 25, 2009 9:17 pm

Re: Panzer Corps Units stats in a friendly PDF

Post by gunny » Tue May 29, 2012 12:52 pm

what are forums ... sorry just kidding

fliegenderstaub
Sergeant - Panzer IIC
Sergeant - Panzer IIC
Posts: 181
Joined: Fri Feb 17, 2012 1:20 pm

Re: Panzer Corps Units stats in a friendly PDF

Post by fliegenderstaub » Wed May 30, 2012 9:04 am

Very useful! Thank you! :)
...and like the once-mighty Mahi-Mahi, you will end
up on a poo-poo platter in the Tikki Hut of life! -Al Bundy -

TJD
Staff Sergeant - StuG IIIF
Staff Sergeant - StuG IIIF
Posts: 295
Joined: Sat Apr 10, 2010 8:32 pm

Re:

Post by TJD » Fri Jun 01, 2012 10:55 am

El_Condoro wrote: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
Master Sergeant - Bf 109E
Master Sergeant - Bf 109E
Posts: 485
Joined: Mon Jan 30, 2012 10:05 pm

Re: Panzer Corps Units stats in a friendly PDF

Post by robman » Fri Aug 10, 2012 8:56 pm

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

Chris10
Captain - Bf 110D
Captain - Bf 110D
Posts: 890
Joined: Tue Mar 27, 2012 1:06 am
Location: Spain

Re: Panzer Corps Units stats in a friendly PDF

Post by Chris10 » Fri Aug 10, 2012 9:54 pm

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.. :P
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..Image
If people have Excel they can do all this themself..especially making an Excel spreadsheet out of the equipment.pzdat...why asking others ?

robman
Master Sergeant - Bf 109E
Master Sergeant - Bf 109E
Posts: 485
Joined: Mon Jan 30, 2012 10:05 pm

Re: Panzer Corps Units stats in a friendly PDF

Post by robman » Fri Aug 10, 2012 11:39 pm

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
Slitherine
Slitherine
Posts: 7778
Joined: Mon Dec 27, 2010 8:33 pm
Location: Portugal

Re: Panzer Corps Units stats in a friendly PDF

Post by VPaulus » Sat Aug 11, 2012 4:17 am

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
Captain - Bf 110D
Captain - Bf 110D
Posts: 890
Joined: Tue Mar 27, 2012 1:06 am
Location: Spain

Re: Panzer Corps Units stats in a friendly PDF

Post by Chris10 » Sat Aug 11, 2012 12:06 pm

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 :wink:

robman
Master Sergeant - Bf 109E
Master Sergeant - Bf 109E
Posts: 485
Joined: Mon Jan 30, 2012 10:05 pm

Re: Panzer Corps Units stats in a friendly PDF

Post by robman » Sat Aug 11, 2012 2:07 pm

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 :wink:
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. :D

Post Reply

Return to “Panzer Corps”