Category Archives: Naval History

Battleship Classes and Throw Weights

I just finished reading The Battle of Surigao Strait by Anthony Tully, a battle that saw the final clash of battleships. For a battleship aficionado, the climax of the fight was the contest between two Japanese battleships and six US battleships, where five of the six US battleships had been sunk or heavily damaged during the Pearl Harbor attack – only the USS Mississippi had escaped the carnage of Pearl Harbor. These were old battleships (Table 1) with two having been commissioned during WW1 and the rest shortly after the WW1 ended. Continue reading

 
Posted in History Through Spreadsheets, Military History, Naval History | 11 Comments

US Cruiser Production During WW2

I have been working through the book Collect, Combine and Transform Data Using Power Query in Excel and Power BI by Gil Raviv – it is an excellent Power Query (PQ) resource. I particularly like the methods discussed in Chapter 10, which focused on how to make your queries robust, that is, insensitive to minor deviations in the input data. Chapter 10 spoke to me, and I immediately began looking for some practice data that suffered from common inconsistencies: headings in different cases, minor spelling errors in the data body, and inconsistent wording (example, "Co." instead of "Company"). I found that data in the Wikipedia's information on US WW2 cruisers. In this post, I will look at the production of cruisers by the US during WW2. See Figure 1 for a typical example of a WW2 US light cruiser. Continue reading

 
Posted in History Through Spreadsheets, Naval History | 2 Comments

US Submarine Production During WW2

One WW2 topic that continues to intrigue me was how US war planners kept the Imperial Japanese Navy (IJN) at bay long enough to build a large naval force. The key was the use of submarines for commerce raiding to disrupt the war material supply chain and tie down Japanese surface forces with convoy defense duty. This post will use Power Query to scrape the Wikipedia for this data. The Wikipedia is becoming a wonderful source for WW2 information. Continue reading

 
Posted in Excel, History Through Spreadsheets, Naval History | 1 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

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 | 2 Comments

Earth's Curvature and Battleship Gunnery

I must admit that I am a bit of a battleship junkie. I have been reading some old US Navy manuals on battleship fire control, which discuss the various effects that must be corrected for to ensure accurate fire (Figure 1). In this post, I want to examine how the curvature of the Earth affected the gunnery direction. Curvature corrections are only needed for very long-range artillery. Continue reading

 
Posted in Ballistics, Naval History | 51 Comments

Torpedo Engine Technology for a Venus Space Probe?

I just finished reading an interesting article on a NASA proposal for a Venus space probe that uses power generation technology developed for a US Navy torpedo program back in the 1980s. Like many spacecraft, torpedoes need power generation systems that are small, generate massive power for a short period, and must be storable for years with the ability to turn on almost instantly with high reliability. Continue reading

 
Posted in Naval History, Space | Leave a comment

WW2 Submarine Endurance on Batteries

I have been reading the book The Bravest Man, a biography of the WW2 exploits of US Navy submarine commander Dick O'Kane. I have not formed an opinion on the book since I just started reading it, but the book does highlight the submerged maneuvering limitations imposed on a ww2 submarine because of its lead-acid battery-based power plant. The book's discussion made me curious about the operational characteristics of a Gato-class submarine when operating submerged on batteries. In this post, I will be examining the Gato-class submarine's run time versus speed plot (Figure 1). Continue reading

 
Posted in Naval History | Leave a comment

The Bounty Mutiny and the Pitcairn Island Position Error

I liked reading the book Longitude by Dava Sobel and I also enjoyed the television movie version. I was recently doing some reading about the Bounty mutiny when I realized that the problem of measuring longitude played a role in that tale as well. The story of longitude is one of technology and obsession. While mariners had been able to measure their latitude accurately for centuries, measuring one's longitude required the development of accurate timepieces. Longitude is the story of the development of the marine chronometer. In essence, our modern GPS systems are extremely accurate clocks that provide the ultimate realization of the longitude goal. Continue reading

 
Posted in Naval History, Navigation | Leave a comment

Index/Instrument Error Correction in Sextant Measurements

Sextants make measurements that are subject to systematic errors – all instruments are subject to systematic errors. Alas, much of my career has been spent on calibrating out systematic instrument errors. Even with all my efforts, residual systematic errors remain. Continue reading

 
Posted in Naval History, Navigation | 2 Comments