Monthly Archives: November 2021

Was Ulysses Grant a Butcher?

This post uses a combination of data from a Github repo by Jeffery Arnold that contains a fantastic amount of Civil War battle data and some Wikipedia scraping to generate similar tables. I should note that my casualty results are significantly different than Bonekemper's because there are large differences between sources of Civil War casualty data. The reasons behind these differences are complex, but the Arnold repo has data from a number of sources. I chose his Wikipedia file because it is easy to check where the data came from. Continue reading

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

Duplicate Drach's U-Boat Tonnage and Sunk Charts

I am a huge fan of Drachinifel's naval history channel. The other day, Drach was participating in the Armchair Admiral's program, during which he presented two charts on the Battle of the Atlantic that I have never seen before: (1) A chart of tonnage sunk by U-boats versus time and (2) a chart of U-boats sunk versus time. The unique aspect of the charts was that the data points were colored based on whether the Enigma cipher was broken at the time and whether centimetric (microwave) radar was deployed. These charts really got me thinking about the impact of technology on the struggle against U-boats. Continue reading

Posted in Excel, History Through Spreadsheets, Military History, Naval History | Comments Off on Duplicate Drach's U-Boat Tonnage and Sunk Charts