Page 1 of 1

Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 1:01 am
by 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 274 times

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 1:05 am
by turn4441
Allied Corps unit availability chart
Allied Unit Availability Ver II.jpg
Allied Unit Availability Ver II.jpg (837.12 KiB) Viewed 2796 times

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 1:13 am
by turn4441
Italian Unit Availability Chart
Italian Unit Availability.jpg
Italian Unit Availability.jpg (599.96 KiB) Viewed 2794 times

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 1:14 am
by turn4441
Soviet Unit Availability Chart
Soviet Corps Unit Availability V III.jpg
Soviet Corps Unit Availability V III.jpg (779.1 KiB) Viewed 2793 times

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 1:18 am
by turn4441
U.S. Corps Availability Chart
US Unit Availability V-IV.jpg
US Unit Availability V-IV.jpg (730.7 KiB) Viewed 2790 times

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 1:56 am
by 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

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 2:10 am
by 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.

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 5:40 am
by 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..

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Thu Sep 29, 2022 7:08 am
by terminator
Please, could you add the posters in the zip file ? The pictures are too small :( Thanks !

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Tue Oct 04, 2022 6:37 pm
by faos333
thanks again for this !!!

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Fri Oct 07, 2022 9:22 pm
by allophyl
Is there one for Germany too?

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Fri Oct 07, 2022 10:45 pm
by 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.

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Fri Oct 07, 2022 11:04 pm
by 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

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Sun Oct 09, 2022 6:30 pm
by faos333
The above image in resized version - missing details because of smaller size
,
HFn1S6s 998-562-rs.png
HFn1S6s 998-562-rs.png (376.17 KiB) Viewed 2596 times

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Tue Apr 25, 2023 11:06 am
by Japoivvb
Someone has original chart files to edit them? Or knows which tool was used for them?

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Tue Apr 25, 2023 4:31 pm
by turn4441
The ones I did (all but German) were done in Excel.

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Tue Apr 25, 2023 7:12 pm
by 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.

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Wed Apr 26, 2023 11:27 am
by 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 91 times
Italian Unit Availability.zip
(499.47 KiB) Downloaded 83 times
US Corps Availability.zip
(983.17 KiB) Downloaded 77 times

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Wed Apr 26, 2023 11:35 am
by turn4441
Soviet

Re: Panzer Corps Excel Reference & National Unit Upgrade Charts - Rerun

Posted: Wed Apr 26, 2023 11:38 am
by 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.