Category Archives: History Through Spreadsheets

US and Canada Aircraft Production During WW2

While looking for some good summer history reading, I found the book America's Hundred Thousand: U.S. Production Fighters of World War II. This book covers the production miracle associated with scaling up up the US aircraft industry to supply planes for every front during WW2. Its title refers to the fact that the US produced ~100K fighter aircraft during WW2, which lasted for 44 months for the US (Figure 2). I decided that I would look at the numbers for all forms of aircraft produced by the US during WW2. Fortunately, the Hyperwar website has put the Army Air Forces Statistical Digest online, which gives me easy access to the data. The Digest contains aircraft production data for both the US and Canada. Figure 1 shows the production numbers for the 11 categories of aircraft production listed in the Statistical Digest. In addition to 100K fighter aircraft, there were nearly 200K of other aircraft manufactured as well. Continue reading

 
Posted in History Through Spreadsheets | Leave a comment

Web Scraping WW2 Landing Ship Data

I have been working on improving my web scraping abilities by analyzing WW2 data. I have focused on topics related to how the US took the 14th largest military in the world and in roughly 18 months turned it into a military that could fight anywhere in the world. In this post, I want to look in detail at how war materials were delivered to beaches around the world using a vessel called a Landing Ship Tank (LST). I have wanted to write about the LST for a while, but the web data was distributed on about 1200 separate pages – one for each ship. While a Python script would have worked nicely, I wanted to try gathering the data without doing any programming. I found some software that did a good job automating this task, which I will discuss later in this post. Continue reading

 
Posted in History Through Spreadsheets, Military History, Naval History | Leave a comment

1968 Vietnam War Statistics

It has been 50 years since 1968, and I have been seeing quite a few retrospectives on television about that tumultuous year. I was in 6th-grade in 1968 and the chaos of that year is still very clear in my memory – I remember spending quite a bit of class time on the Paris peace talks. One lesson was about how the Paris Peace negotiators argued about the shape of the table at which they would sit. Arguing about the shape of a table while people were dying seemed ridiculous to a 12-year boy. After hearing all these recent discussions about 1968, I decided to look at the US Vietnam casualty data (Figure 1) to see what insights I could gain on that year. All my work is done in Excel and my workbook is here. Continue reading

 
Posted in History Through Spreadsheets | 4 Comments

State Casualty Rates During the Vietnam War

My first engineering manager was named Marl Godfrey. He was an excellent manager who also had keen insights into the human condition. These insights made quite an impression on my 22-year old self – I actually kept a notebook of his comments. Some of his most insightful comments were about the US military and the Vietnam War. Marl has grown up in Oklahoma and he had served in Vietnam. He once commented that Oklahoma had very aggressive draft boards, which resulted in Oklahoma having a relatively high death rate during the conflict. I was reminded of this statement when I recently reviewed my quote database. I thought that I should be able to determine how death rates varied by state during the Vietnam War, which is the subject of this post. Continue reading

 
Posted in History Through Spreadsheets | Leave a comment

Liberty Ship Production Data

One WW2 battle that we hear little about was fought by logisticians. Their battle was between what could be produced versus what could be delivered in time to matter.  This point was driven home to me when I heard a WW2 historian say that the US had the manufacturing capacity to produce 150K tanks, but that level of tank production would consume all the US steel and leave nothing to build the ships needed to carry the tanks to the fight. Continue reading

 
Posted in Excel, History Through Spreadsheets, Naval History | 1 Comment

The Pacific War and Manufacturing Capacity

I was watched a particularly interesting lecture by Victor Davis Hanson on his new book The Second World Wars. While Hanson is generally thought of as an ancient Greek scholar, he does an excellent job of analyzing WW2 from a novel set of viewpoints: ideas, air, water, earth, fire, and people. Continue reading

 
Posted in History Through Spreadsheets, Military History | Leave a comment

Great Lakes Shipwreck Statistics

I was driving home from my cabin construction project yesterday when I heard on the radio Gordon Lightfoot singing about the sinking of the Great Lakes freighter Edmund Fitzgerald (Figure 1). The sinking occurred when I was in high-school, and it was the first I had ever heard of a sinking on Lake Superior. Continue reading

 
Posted in History Through Spreadsheets | Leave a comment

Countries That Are Graying Fastest

I have been working hard to address the issues associated with an aging workforce (blog post). However, aging is problem for the entire world – the median age of the world is increasing. Aging populations put enormous strains on the infrastructure of country. I have been reading quite a few articles lately on the effect of aging populations on quite a few developed nations: South Korea, China, Germany, and Italy. Many nations are facing the problems associated with aging populations: high medical expenses, providing elder care, paying pensions, etc. Continue reading

 
Posted in History Through Spreadsheets | Leave a comment

WW2 Tank Production Comparison Between Combatants

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 … Continue reading

 
Posted in Excel, History Through Spreadsheets, Military History | 8 Comments

Retired Hurricane Name Statistics

I was reading an article that stated that names of Hurricane Harvey and Irma could be the eighth pair of back-to-back hurricane whose names have been retired since the 1954. I have never thought about which hurricane names have been retired, so I started to search around the web. As usual, the Wikipedia provided an excellent data source. Continue reading

 
Posted in History Through Spreadsheets | Leave a comment