Panzer General II - Equipment List Report/Editor using Excel 97 (v1.8)
        by David Bird 11/05/01
	http://www.geocities.com/dbirdil/

This EXCEL 97 spreadsheet creates several types of reports from PG2
equipment lists.  It also contains an Editor which allows you to change
the Equipment Files. I have only tested this using Excel 97, I do not
know if it will run for any other versions of Excel.

The reports and editor requires two files; Equip97.eqp & Equip97.txt.


Reports/Editor Options:

a) Equipment Editor - creates a Report similar to the Equipment List, but
   with more detail.  Some unknown fields can be set, but whether they affect
   the game is unknown.

b) Equipment List - similar to the Report you get with PG2 with a
   few extra columns.

c) Byte by Byte Report - is a Byte by Byte report of the Equip97.eqp
   file.  It helped in determining the contents of this file.  Some of the
   data is still unknown on how it is used.

d) Compare Equipment List - shows the differences between Equipment files.
   To be compared, the Equipment files need to have to loaded into the Spreadsheet
   using Options a,b, or c.


Options Boxes:

   Multiple Countries - Allows multiple countries to be specified for a unit.
	Note: The Country column is ignored on the Editor when saving updates

   Calculate Cost - Calculate Unit Prestige using Raymond Schroder
        formula used in his Ultimate PzG II Equipment List.

        Prestige Cost=
        =ROUNDUP(SQRT((Mo+In+Ra*Ra*Ra+SA*SA+HA*HA+AA*AA+GD*GD+AD*AD+10*TT*Rarity),0)*12

        Rarity is a user specified value that is not stored in the equipment
        file. To get this value I calculated it by reversing this formula. The
        Prestige cost is automaticlly recomputed when any of the value in this
        formula is changed.



   Include Icon & Sound - Include on the report the Icon and the sound values for
   equipment.

   Include Equip. Name - Include the equipment names when comparing the equipment
   from two Sheets (Reports).

   Enter Sheet Name - allows you to specify the Sheet name for the new Report.

   Equipment File Type - Specifies the country names listed for each unit.
        Original - Displays unit countries available in the original game
        Waffenkrammer WW2 - Substitute Japan/China for Austria/Spain
	Waffenkrammer WW3 - Substitute WW3 Country names for many countries
        Use GUI97.TXT     - Country names identified in the GUI97.TXT is used
                            to assign country names to the units.


Equipment Editor - This editor allows you to edit the entire equipment list at one time.
	You can change units attributes, add new ones, and delete old unused ones.

	Warning: Be careful when deleting.  The program will requence the units numbers when
	saving the Equipment Files.

	When the Equipment files are first opened by the editor, backups are made of the
	files by creating copies of the files in the same directory prefixed with Bu_.


Warning: The editor does very little edit checking.  If invalid numbers are
	entered it will abend and you will need to fix the problem.  Or you can cancel
	all your changes and start again.  Invalid values for Character fields will default.

Note: Most fields requiring numbers, the largest value allowed by this editor is 255.
	The program will abend if it can't handle a value larger than this.


Warning Again: You will be using this editor at you own risk.


Editor Options:

   SAVE - Save Equipment File.

   Save As - Allows you to specify a new File Prefix name to the equipment files.
	Once saved under the new name it becomes the default and you don't need
	to specify it again.

   Sort by Country - Sort units by Country, Type, and Name

   Sort by Equipment # - Sort Units by Equipment Unit #

Note: You can use Excel Data Sort tool to sort the reports/editor however you want.


Equipment columns and expected values:


#	- Equipment Number assigned to each unit.
	All rows should be sequentially number starting with 0.  No Skipping.
	When the Equipment Files are saved, all rows are sorted by this column and renumbered
	sequentially starting with Unit #0.   Supposedly UNIT 0 is a valid unit, but I have
	yet to an equipment that uses it.  When including unit 0 there is PG2 maximum
	of 1000.  Please do not exceed this.

Country	- Valid values are (Caps are Ignored)
        - If Multiple Country Option is used only the corresponding countries
        for that column are valid.  Names in the Country column will be ignored
        for Saves.
 Original        Waffenkrammer
                 WW2            WW3
 --------------- -------------- ---------------------
Country1
 Non
 Austria         Japan          Japan
 Belgium                        North Vietnam
 Bulgaria                       Syria
 Czk                            West Germany
 Denmark                        Australia
 Finland                        Israel
 France
Country2
 Germany                        Grossdeutschland
 Greece
 USA
 Hungary
 Turkey
 Italy
 Netherlands                    South Vietnam
 Norway
Country3
 Poland
 Portugal                       East Germany
 Romania
 Spain           China          China
 USSR
 Sweden
 Switzerland                    Taiwan
 UK
Country4
 Yugoslavia                     Egypt
 Nationalist                    North Korea
 Republican                     South Korea


 Note: If all country fields contain spaces then the Unit is for All Countries.


Equipment Name - I don't know if there is any size limit, So don't make them to big.


Class	Unit Class
	None 	- None
	AD	- Air Defense
	AT	- Anti-tank
	ATP	- Air Transport
	ATY	- Artillery
	Flak 	- Flak (notused?)
	FRT	- Fortification
	FTR	- Fighter
	INF 	- Infantry
	LB   	- Level Bomber
	NTP	- Naval Transport
	RCN	- Recon
	SUB  	- Submarine (notused?)
	sDD  	- Destroyer
	sBS  	- Battleship
	sCV  	- Aircraft Carrier
        sBC  	- Battle Cruiser
	sCR  	- Cruiser
	sLC  	- Light Cruiser
	TB	- Tactical Bomber
	TK	- Tank
	TPT	- Land Transport

Date	Available Date 	- Valid date
        - Month greator than 12 are set to 12
Ex.	Expiration Year - Two digit Year
	Warning: if entering a a year with century  EXCEL may prefix the year with 20
			This does not affect the year being saved since the century is stripped of.
Cost	Cost		- Number divisible 12
Mo	Movement 	- Valid Number
SP	Spotting Range 	- Valid Number
Fu	Fuel		- Valid Number
Am	Ammunition	- Valid Number
In	Initiative	- Valid Number
Ra	Firing Range	- Valid Number
SA	Soft Attack	- Valid Number
HA	Hard Attack	- Valid Number
AA	Air Attack	- Valid Number
NA	Naval Attack	- Valid Number
GD	Ground Defense	- Valid Number
AD	Air Defense	- Valid Number
CD	Close Combat	- Valid Number
TT	Target Type
	S	- Soft
	H 	- Hard
	A	- Air
	N	- Naval
RM	Range Modifier	- Valid Number
MM	Movement Method
	A	- Air (Airplanes)
	AT	- All-Terrain (Most Recon)
	DN	- Deep Naval (Navy Ships)
	HT	- Half-track
	L	- Leg
	Mt	- Mountain
	T	- Tracked
	TO	- Towed
	W	- Wheeled
	Co	- Coastal (1/2 Movement) - Used?
	N	- Naval (1/4 Movement) - Used?
	Am 	- Amphibious (can move 1 hex at sea pr turn, moves normally at land) - Used?
	LC	- Landing Craft	(moves normally at sea, need transport to move on land) - Used?
Air	Air Unit		- 'Y' or spaces
Exist	Unit Exist		- 'Y'
Bit02	Bit 2			- 'Y' or spaces - Used?
Ignore Entrenchment	- 'Y' or spaces
Bridging			- 'Y' or spaces
No Soft Attack		- 'Y' or spaces
No Hard Attack		- 'Y' or spaces
No Air Attack		- 'Y' or spaces
No Purchase			- 'Y' or spaces
No Leader?			- 'Y' or spaces
	- I think this field is used
Move in Terrain as Clear- 'Y' or spaces - Used?
Bit11	Bit 11		- 'Y' or spaces - Used?
Bit12	Bit 12		- 'Y' or spaces - Used?
Bit13	Bit 13		- 'Y' or spaces - Used?
Bit14	Bit 14		- 'Y' or spaces - Used?
Bit15	Bit 15		- 'Y' or spaces - Used?
Icon	Corresponds to the name of an Icon file
Bomb Size	- Only used by Level Bombers
	- Valid number from 0 to 255.
	- Values larger then 128 will cause suppression/destroyed to the unit
        of almost 100% of the time.
	- Value of 255 will suppress unit 100%, remove approx 70% ammo and 30% fuel
	- See Builders Paradise Equipment Spec for details in setting this field
	http://w1.1661.telia.com/~u166103891/pg2spec.html

AS 20??	Attack Sound	- Corresponds to a 20## sound file
MS 10??	Movement Sound	- Corresponds to a 10## sound file
DS 30??	Death Sound		- Corresponds to a 30## sound file


Equipment List Report:

Most of the values for the various field come straight from the PG2 Manual.
Listed below are the field values that are unique to this report.  Many seem
not to be used.


Unit Class:
	Flak - Flak (notused?)
	LB   - Level Bomber
	SUB  - Submarine (notused?)
	sDD  - Destroyer
	sBS  - Battleship
	sCV  - Aircraft Carrier
        sBC  - Battle Cruiser
	sCR  - Cruiser
	sLC  - Light Cruiser

Movement Method:
	DN   - Deep Navy ( same as N in the PG2 Manual)
	Co   - Coastal (half move rate) (notused?)
	AT   - All clear ground terran (notused?)
	N    - Navy (notused?)
	LC   - Landing Craft (notused?)
	Mt   - Mountain
	Am   - Amphibious (notused?)

Unit Special
	Ignore Ent. - Ignore Entrenchment
	Bridging    - Bridging
	NoSA        - Cannot Start a Soft Attack
	NoHA        - Cannot Start a Hard Attack
	NoAA        - Cannot Start an Air Attack
	NoPur	     	- Cannot Purchase Unit
	NoLdr       - Cannot have a Leader?
	ClrTrn      - Move in terran as Clear (notused?)



References Used:
   Equipment Spec. Made by Lasse Hintze Jensen
	- A link to this spec. was found on the Builders Paradise Web Site Under Info & Spec
	- http://w1.1661.telia.com/~u166103891/pg2index.html
   Equipment Spec. from  Panzer Command Center
	- http://www.geocities.com/TimesSquare/Arena/2715/mainpage.htm

Equipment lists that contain new Icons, Sounds, and Countries.
The Waffenkrammer equipment files where the first to take advantage of all three.

      Waffenkrammer WW1 - Contains WW1 Units from around the world.
                http://www.geocities.com/TimesSquare/Dome/4756/ndownload.htm

      Waffenkrammer WW2 - Contains Japan & China units.  Allows Tactical Bombers
                to attack other aircraft.
		http://www.geocities.com/TimesSquare/Dome/4756/ndownload.htm

      Waffenkrammer WW3 - World War 3 equipment file
		http://www.geocities.com/TimesSquare/Dome/4756/ndownload.htm

      Oronzo Equipment List - Is required when using
                Oronzo's many Custom Scenarios.
		Now all the towed equipment now has a movement of 1.
                Combat Odds are not shown.
		http://www.bossanova.com/oronzo/panzergeneral2.html

      Brian Gosley List - Is similar to Waffenkrammer file.
            "It is not 100% historically accurate but is created for variety
            & playability.  with an emphasis on variety"
            http://www.bossanova.com/oronzo/pzdown.html
                 OR
            http://w1.1661.telia.com/~u166103891/pg2eqp.html

      Ted Grospes - Contains Recon Aircraft.
		http://www.bossanova.com/oronzo/pzdown.html
                 OR
            http://w1.1661.telia.com/~u166103891/pg2eqp.html


      AdlerKorps Europe - Includes new units for Bulgaria, Belgium, Denmark,
            Turkey, Portugal, Sweden, Yugoslavia,Greece, Slovakia & Croatia
            http://www.itk.mh.se/~svh9829/pg2.html

      ThomasKluetsch - Author's Description
		"The Equipment is a modified Waffenkammer upgrade.
		I made to improve some stats and to introduce some of my icons.
		The new units replace some units from Switzerland."
            http://members.tripod.de/ThomasKluetsch/

      David Ficke - Based on the Zerstorer Equipment with new units and icons.
		I don't know if the equipment file takes advantange of any Waffenkrammer
		sounds or icons.  But you do need to update the panzer.dat file to
		use it.
             http://www.geocities.com/_hylian_knight/

      Professional Wargamers League - Season II Equipment File
             http://www.prowargamers.com/download.html



New Equipment Lists for PG2 without the Waffenkrammer enhancement.

	AdlerKorps - Includes new units for Bulgaria, Belgium,
		Denmark, Turkey, Portugal, Sweden, Yugoslavia and Greece.
            http://www.itk.mh.se/~svh9829/pg2.html

	Cherkassy Pocket 1944 List - Equipment list setup for a hypothetical attempt by
		the German army to escape from Stalingrad Equipment.
		You can find this list at the Wargamers Scenario Archive for Panzer General II
		http://www.wargamer.com/archive/

	Justin G. Prince Equipmmen List - Equipment list from the Duetsches Afrika Korps site owner.
            "It adds very many more units, including captured units and some of Rommel's "Funnies",
            common to the Afrika Korps."
             http://www.angelfire.com/ok/panzerkampfwagon/scenarios.html
            You can also find this list at the Wargamers Scenario Archive for Panzer General II
             http://www.wargamer.com/archive/

	Swedish Equipment 1.1 - This is Ray Schroder's Ultimate Equipment file v. 2.61 with
		Swedish equipment added.  Oronzo has posted it on his site
		http://www.bossanova.com/oronzo/pz2info.htm

Classic Equipment Lists:

	Armory v1.5 - A good list which added a 4th German transport by converting
		the Recon Unit 250/1 to a TPT.
		http://ourworld.compuserve.com/homepages/sgt_stryker/armory.html

	Ultimate Panzer General II v2.61 - Widely used equipment list.
		http://www.geocities.com/TimesSquare/Arena/5096/

	WaffenSS   - Used in the Waffen SS campaign
	Spain	     - Used in the Spain Campaign
	FreeFrench - Used in Free French Campaign
		These three campaigns can be found at either of these two sites
		http://perso.wanadoo.fr/stephane.grateau/newuk.htm
		http://www.teleweb.net/stevebrown/pg2.htm


Hints:
1) The equipment file names should end with *.eqp and *.txt and
   exist in the same directory.

2) Create copies of the equipment files to include the name of the source.
	example: Oronzo_Equip97.eqp and Oronzo_Equip97.txt

3) Sheet names cannot contain / : & and some other special characters.


Change History:

1.8  - 12/15/04 - Added supported for Countries 28 to 31 which are listed at the bottom
                  of GUI97.TXT file
                - Renamed Bit11 to Phase Movement
                - Tested the Month Expiration for equipment was being saved

1.73 - 11/05/01 - Added Support for the Month Expire column
                - Fixed problem with Coastal Movement Method
                - Fixed problem with GUI97 country names
                - All Not used Columns are editable
                  countries identified in GUI97.TXT
                - Removed WW1 From Country List


1.72 - 09/05/00 - Add option to list countries identified in GUI97.TXT
		- Removed WW1 From Country List
1.71 - 08/24/00 - Fixed Calcluate Cost when not using Multiple Countries Option
		- Change Avail Date to work correctly with different language
                  versions of Excel

1.70 - 08/22/00 - Add Calculate Cost
                  Add Icon Count

1.69 - 06/02/00 - Fix Country names on Report

1.68 - 05/30/00 - Added Alder Europe Countries Slovakia & Croatia
			They take the place of Austria & Spain
                - Fix saving with wrong countries selected on menu.

1.67 - 05/23/00 - Fix problem with date available of 02/01/1900
                - Fixed setting country for China in WW1
                - Fixed problem with Equipment names with commas
                - Equipment Month Avail Column will report values greator than 12
                  if the Equipment file contains them.

1.66 - 05/22/00 - Added support for Waffenkrammer WW1 & WW3 equipment lists.
                - Fix some equipment available date problems for the year 1900

1.65 - 05/01/00 - Fixed Level Bomb Size. Updating the wrong byte.
                - Fixed Compare Report.  Multi-Country units where causing problems.
                - Add Edit option to allow editing of NotUsed Fields.   These fields
                  currently contain x'00' or spaces. Bomb Size use to be one of these
                  fields, by allowing these fields to editted may be more options will
                  be uncovered.  Remember Single byte number fields largest value is 255.
                - Create a settings file, so  when new releases of this file is loaded
                  the old settings don't get lost.  This settings file is saved in the
                  same directory this Speadsheet is.

1.64 - 04/19/00 - Add country Non.  It was specified as a valid value in the
                  Builders Paradise PG2 Equipment Spec v1.06.  I don't know what
                  will result if you use it.
                - Fixed the Compare report to properly report changes when
                  additional countries are assigned to a Unit.
                - Report Units as All Countries if no country is specified.
                Oronzo verified this setting works in PG2.

1.63 - 03/23/00 - There was a problem with systems setup without a printer driver
                  that invalidated all the PageSetup references.  I added logic that
                  will ignore errors from these references.

1.62 - 03/20.00 - Add logic to test if Equipment File Directory exist before changing to it
                - Add logic to skip any errors from PrintTitleRows

1.61 - 03/16/00 - Fixing a Undeclared variable

1.6  - 03/14/00 - Added changes from the Builders Paradise PG2 Equipment Spec v1.06
		- Unit 0 is considered a Valid unit even though SSI skipped it
		- Unit Spec.  Move in terran as Clear
		- Clarification of the Bomb Size
		- Handles adding Units with Multiple Countries and Reports them
		  Separately on the Report option.
		- Fixed a problem that leaves the Sort Column on the Sheet
		- Changed Compare Report to ignore Case

1.53 - 01/17/00 - Added support to Waffenkrammer WW3 Country Names

1.52 - 01/05/00 - Fixed a looping problem in Compare Equipment List option

1.51 - 12/22/99 - Removed the trailing Zero record from the Equipment Editor Sheet
		  Having problems if an extra record was in the Equipment Name file
		- Fixed a missing column after saving problem
		- Added fra (French) to the file type drop down.
		- Change Default sheet for Equipment to Edit
1.5  - 12/21/99 - Save Equipment file location
	 	- Get Equipment name file without prompting.
	   	  Must Have same file prefix as equipment unit file.

Disclaimer
These files are freeware and maybe freely distributed.
The author makes no warranty as to the suitability of the files for their intended or any
other purpose. Furthermore, the author is not responsible for any damage to your system nor
is he liable for any other damages whatsoever that may be incurred by use of these files.

A Big thanks, to all the PG2 equipment files makers.  Their work motivated me to create this tool.
