Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

[turn4441]

As per faos333 request, here is a link to my Excel Panzer Corps reference sheet. The only change from the "Ver VIIIc" version of several years ago, is the V-2 rocket I found in the V-Rocket scenario of Allied Corps (October 10, 1944) and mentioned recently and have included it for that scenario. I'm not sure if you get the V-2 for destroying the hangar(s) near Leiden, or just capturing Leiden, but it shows up as a train by Leiden, then you need to unload it in a city you control, then use the switch (W) key to convert it from horizontal to vertical, at which point you can attack a target in its range one time.

Again, thanks to Pete and faos333 for keeping people aware of this. I'm pretty sure Pete put it in the stickies or 'Tips and Tricks' but it doesn't hurt to recycle things a bit for newbies. I will also repost the Unit Availability sheets below. Good gaming to all!

Panzer Corps Reference ver VIIId Excel spreadsheet tabs:
Timeline: lists all scenarios by campaign/dlc (color coded and selectable using the arrow at the top of the colomn)
Prestige: lists prestige by scenario for DV, MV, Loss, and per turn (if available)
Cheats-Hotkeys: self-explanatory
Switchables: units that can switch categories, e.g. artillery to anti-tank, etc.
Unit Info: other tabs show a reduced version (necessary info) of the unit table by unit type and nationality

Panzer Corps Reference ver VIIId.zip

(253.5 KiB) Downloaded 247 times

[turn4441]

Allied Corps unit availability chart

Allied Unit Availability Ver II.jpg (837.12 KiB) Viewed 2360 times

[turn4441]

Italian Unit Availability Chart

Italian Unit Availability.jpg (599.96 KiB) Viewed 2358 times

[turn4441]

Soviet Unit Availability Chart

Soviet Corps Unit Availability V III.jpg (779.1 KiB) Viewed 2357 times

[turn4441]

U.S. Corps Availability Chart

US Unit Availability V-IV.jpg (730.7 KiB) Viewed 2354 times

[turn4441]

I have also included the original Panzer Corps Unit Availability chart that I patterned the others above (which aren't as nice) off of. I'll find the credit and pass it along shortly.

PzC Unit Upgrade Chart.jpg

[turn4441]

I believe it was ThvN that did the original PC German availability chart. Please correct this if I'm wrong as I want to give credit where due.

[PanzerTum]

Such a wealth of information, thanks a lot!

I also use the excel to record my progress in the game, ending prestige, prestige after repairs and purchases, units bought and sold, prestige compare to previous GC runthrough, scenario results.

One of my favorite parts after a scenario is filling out these details..

[terminator]

Please, could you add the posters in the zip file ? The pictures are too small Thanks !

[faos333]

thanks again for this !!!

[allophyl]

Is there one for Germany too?

[turn4441]

Yes, and you can probably find it somewhere. I was going to load a higher resolution version that was clearer when enlarged and that's why I removed it from the post above. I was editing my post but, subsequently my internet connection went to crap ever since and I had trouble uploading it and haven't had a chance to fix it. I'll see what I can do.

[turn4441]

As I can't get the image to upload like the others, for some reason, here is a link to a higher resolution version (hopefully) of the German Upgrade Chart. Again, it should also be in the stickies somewhere.

https://i.imgur.com/HFn1S6s.png

[faos333]

The above image in resized version - missing details because of smaller size
,

HFn1S6s 998-562-rs.png (376.17 KiB) Viewed 2160 times

[Japoivvb]

Someone has original chart files to edit them? Or knows which tool was used for them?

[turn4441]

The ones I did (all but German) were done in Excel.

[Japoivvb]

great! can you upload here too, please? I would like to have a template to do the same look and feel for other nations/mod and I would not like to start from 0.

[turn4441]

I'll try, been a while since I uploaded anything. Probably have to use Zips since I'm pretty sure Excel files can't be loaded. Will at least save you from having to convert all the 4 image unit files to single images like I did.

Allied Corps Availability.zip

(822.24 KiB) Downloaded 78 times

Italian Unit Availability.zip

(499.47 KiB) Downloaded 73 times

US Corps Availability.zip

(983.17 KiB) Downloaded 67 times

[turn4441]

Soviet

[turn4441]

Oops, the Soviet file is being problematic, I think as it is just over 1 MB even though total attachments can be up to 4 MB. I would PM it to you but I don't think attachments are allowed (at least I don't see how). However, If you PM me your email, then I can send it to you.