Quote of the Day
At least you figured it out. My first two husbands never did.
— Female employee told me this after I mentioned that my wife's nickname for me was "The Paycheck" – this nickname was a joke between my wife and me.
I occasionally watch WW2 documentaries on television, and one of these programs provided a bit of history on the Battle of Kursk. This battle may have been the greatest clash of armored forces in history. The coverage highlighted the role of medium tanks, like the Soviet T34 (Figure 1) and the German Panzer Mk V (aka Panther [Figure 2]), and heavy tanks, like the German Panzer Mk VI (aka Tiger I). One of the themes of the documentary was the massive size of Soviet armored forces compared to their German opponents. This discussion piqued my curiosity about the number of tanks produced by the major combatants.
I performed a quick web search and soon found that the Wikipedia has data for the Soviet, German, and American armor production in an odd, but usable form. The articles had all the data I wanted but in separate tables that would need to be cleaned up separately, consolidated, and then turned into pivot tables. I very much wanted to include UK tank data, but what I found had a weird format and decided to skip including it.
Points of Interest
I am interested in three things:
- Total tank production by all parties separately.
- Total tank production of Allies versus Germans.
- Weight mix of tanks produced (light, medium, and heavy).
My interest in the mix of tank weights is driven by the first-person accounts I have read from US veterans that show great concern about encountering heavy tanks, like Tiger Is and Tiger IIs. In the case of the US, the armor philosophy was focused on medium tanks, specifically the M4 Sherman. The lone US heavy tank, the M26 Pershing, was not deployed until late in the war. This decision is a major topic of discussion even today with some first-person accounts referring to the Sherman tanks as a deathtrap. Opposing arguments are that the Sherman was not that bad (particularly the Easy 8 and Firefly variants) and that quantity has a quality all its own. There is some empirical support for this position.
- The Sherman Easy 6 performed well against the Soviet T34/85 in Korea.
- Shermans performed well at the Battle of Arracourt against German forces with a large number of Panthers.
- The Soviets used a large number of Shermans and all reports I have seen indicate that they liked them.
I have to mention that making direct comparisons of armor effectiveness is difficult because training and operational tactics are critical to achieving good field performance.
Using Excel and Power Query, I grabbed data from three Wikipedia pages: US armor production, Soviet armor production, and German armor production. The data includes both tanks and self-propelled guns. I consolidated the data into a single pivot table (Figure 3).
While the table contains all the data available, it is a difficult format for people to interpret quickly. We need to find a graphical way to present the data.
Figure 4 shows the relative armor production and mix of the German versus the Allies. The Allies produced more than four times more armor than the Germans did. Also note the amount of heavy armor produced by the Allies.
Figure 5 shows how US and Soviet production compared. The Soviets outproduced the US in total numbers, particularly in heavy armor.
Here is how I interpret this data:
- The US and Soviets outproduced the Germans in tanks by more than a factor of 4.
- The Soviets outproduced the US in armored vehicles by almost 20%.
- The Soviets produced significantly more heavy tanks than both the US and Germany.
- While quite a bit has been written about the German Tiger tanks, relatively few of them (less than 2000) were produced.
For those who are interested, my workbook is here.