WitE2 Database-Weapon/Locations/GroundUnits Naming Issues-Double Entries

[terry1040]

I am currently improving my skills with Microsoft PowerBI, so doing some analysis with the Commander Reports is a nice motivation.

I noticed a couple of naming issues/double/triple entries in the database.
This is concerning the Weapons, Locations and Ground Unit Names

Example for Weapons:
Weapon Type Load Eff Rng Acc MaxCeil RoF Blast Rng AAir ASoft AArm Pen HEAT HVAP
152mm M-10 L/25 Howitzer heavy gun 0 0 4000 275 0 4 9 0 234 59 93 0 0 405
152mm M-10 L/25 Howitzer heavy gun 0 0 13550 275 0 4 9 0 234 59 0 0 0 449
152mm M-10 L/25 Howitzer heavy gun 0 0 13550 275 0 4 9 0 234 59 93 0 0 518

All 3 weapons have the same name, but different values (maybe due to improvements over the course of time, maybe a bug, maybe the wrong name in the first place).

If these entries are really all the same weapon, I suggest to change the names into something like this:

152mm M-10 L/25 Howitzer (early)
152mm M-10 L/25 Howitzer (mid)
152mm M-10 L/25 Howitzer (late)

This would tremendously help the Data Analytics out of the Commander's Report and would also be a bit more precise, i.e. unique.

Here is the complete List of Weapons with multiple entries...

• 12.7mm DShK TMG

• 122mm M-30 L/23 Howitzer

• 152mm M-10 L/25 Howitzer

• 155mm M1A1 L/45 Gun

• 15mm Besa TMG

• 165 USG Drop Tank

• 203mm/50 M1924 Gun

• 20mm Flak30 L/65 Gun

• 20mm M35 L/65 Gun

• 50mm Type 89 Grenade Launcher

• 5in/38 Mk 12 Gun

• 6.5mm Breda BMG

• 7.5mm FM Mle 24/29 AAMG

• 7.5mm MAC 31 BMG

• 7.62mm DT TMG

• 7.92mm ZB M1924 Rifle

• 7.92mm vz.26 BMG

• 75mm M1A1 L/16 Howitzer

• 75mm M34 L/46 Gun

• 76.2mm F-22 L/51 Gun

• 8mm 35M Rifle

...similar Problem with the Location Names...

• 2xBar (Soviet and Yugoslavia)

• 2xKalach (Soviet/Stalingrad Area West and Soviet/Stalingrad Area West, but closer to the city)

• 2xRoquefort (France/Bordeaux Area and France/MassiveCentral)

...and an even longer List for the Ground units. This is mainly because the equipment has been used with different nations.

For example: For the Tiger used in Germany and Hugary the name should be changed into "Tiger" and "Tiger (HU)" respectively. Both have the same base data, but different build limts and productions dates.

• 100mm vz.30 Howitzer

• 105mm Skoda Field Gun

• 105mm leFH18 Howitzer

• 120mm GrW 42 Mortar

• 122mm M1910 Howitzer

• 122mm leFH388(r) Howitzer

• 149mm vz.25 Howitzer

• 150mm Nebelwerfer

• 150mm sFH18 Howitzer

• 150mm sIG33 Infantry Gun

• 160mm Stielgranate AT Gun

• 20mm Flak38 AA Gun

• 20mm Quad Flak38 AA Gun

• 20mm Solothurn AT-Rifle

• 240mm H39 Howitzer

• 37mm Flak36 AA Gun

• 37mm PaK36 AT Gun

• 37mm vz.37 AT Gun

• 45mm M37 AT Gun

• 50mm GrW 36 Mortar

• 50mm PaK38 AT Gun

• 7.62mm Maxim Machine Gun

• 7.92mm MG34 Machine Gun

• 7.92mm MG42 Machine Gun

• 7.92mm PzB 39 AT-Rifle

• 75mm M15 Mountain Gun

• 75mm PaK40 AT Gun

• 75mm PaK97/38 AT Gun

• 75mm leFK18 Field Gun

• 75mm leIG18 Infantry Gun

• 76.2mm PaK36(r) AT Gun

• 80mm vz.30 Field Gun

• 81mm GrW 34 Mortar

• 81mm Mle 27/31 Mortar

• 88mm Flak18 AA Gun

• Air Support

• BT-7 M1937

• Bicycle Recon Squad

• Cavalry Squad

• Cavalry Squad (-)

• Cavalry Squad 43

• Flamethrower Squad

• Labor Squad

• Marder III

• Motorcycle Squad

• OA vz.30 Armored Car

• Panzer 35(t)

• Panzer IIIm

• Panzer IIIn

• Panzer IIf

• Panzer IVf

• Panzer IVg

• Panzer IVh

• Panzer IVj

• Panzerschreck Team

• Pioneer Squad 39

• Pioneer Squad 43

• R-35

• Recon Squad

• Rifle Squad 39

• Rifle Squad 41

• Rifle Squad 42

• Rifle Squad 43

• SdKfz-222 Armored Car

• SdKfz-222B Armored Car

• SdKfz-223B Armored Car

• Stug IIIg

• Submachine Gun Squad

• Support

• T-28E

• T-34 M1941

• T-38

• T-60 M1941

• Tiger

Thanks for your ongoing support for this fantastic game.

Cheers
Terry

[Denniss]

There may be duplicates for different installations or different nations using them.
In your 152mm M-10 examples:
The first device #423 is used in the KV-2 hence the much shorter range
the second device #512 is the version in use by Finland
the third device #582 is the soviet standard variant hence the availability of HEAT ammo

Many of your list may be covered by this explanation but not all.
the 165 USG drop tank is indeed a dupe

[terry1040]

There may be duplicates for different installations or different nations using them.
In your 152mm M-10 examples:
The first device #423 is used in the KV-2 hence the much shorter range
the second device #512 is the version in use by Finland
the third device #582 is the soviet standard variant hence the availability of HEAT ammo

Many of your list may be covered by this explanation but not all.
the 165 USG drop tank is indeed a dupe

My focus was to mainly highlight the naming problems within in the commander's report.
For an easy analytics with a tool like Excel / Power Bi, it would be very helpul to have *unique* unit names across the board.

[Wiedrock]

+1 (for spreadsheet nerds)

[...][ For an easy analytics with a tool like Excel / Power Bi [...]

I've been also playing around with CSV Exports of [CR: Unit > Supply] Data some months ago to automate to show differences between turns for MEN, AFV and so on.
As far as I've understood it, the CSV "lines/blocks" (however they are called) are not specified in any way but what's written in them (altough I am a newbee in all of this so this might be wrong). To access a "block" I've come up with the solution of searching the 1st column for the name of the unit I want to have access to. In case of the Tiger, there is the nationality in the 2nd column which you could add as a "AND" to the search thingy.

If you are doing a different approach I'd like to hear how you are accessing the "line data" to learn from it! I am new to this as mentioned.


P.S.: Why would you want to access/export the [CR: Equipment > Weapon] data like the different "152mm M-10" barrels? What can be "seen" there which needs to be analized? As far as I guess, this only shows raw data which doesn't change at all and is just being used in battle calculations.
I am interesetd in it since I can't come up with a idea about that, other than combining this weapon export with battle reports to say "Divisions using A instead of B hit on average 10% less" ....or such stuff.

[Wiedrock]

the third device #582 is the soviet standard variant hence the availability of HEAT ammo

Hey Denniss, could you elaborate what you mean with this. The Unit got [AArm 93] and [HEAT 0].

Secondly, could you tell us what the last column stands for? It states it's HVAP, the Devices in the Editor only got HEAT Pen and HVAP Pen, those are 0 for all three Devices in their Editor IDs, while the CR states it's value is ~400-500 each. Where do that numbers come from?

[Denniss]

looked at the wrong gun while writing about HEAT - sorry.
CR is buggy as the top column naming does not alway match the data shown below