Category Archives: Navigation

Battleship Shell Size Comparison

Posted on 26-January-2020 by mathscinotes

During some routine research on battleships, I encountered some photos on the web that I thought were worth sharing here. My hope with these photos is to give readers a feel for the size of these guns and their projectiles. Continue reading →

Posted in Ballistics, Naval History | 1 Comment

Battleship Classes and Throw Weights

Posted on 26-July-2019 by mathscinotes

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

US Cruiser Production During WW2

Posted on 30-December-2018 by mathscinotes

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

Posted on 26-December-2018 by mathscinotes

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

Posted on 12-August-2018 by mathscinotes

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

Liberty Ship Production Data

Posted on 22-May-2018 by mathscinotes

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

Posted on 20-December-2017 by mathscinotes

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

Torpedo Engine Technology for a Venus Space Probe?

Posted on 24-October-2017 by mathscinotes

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 | Comments Off on Torpedo Engine Technology for a Venus Space Probe?

Unfortunate Satellite Launch Problem Allows Test of Relativistic Time Dilation

Posted on 1-April-2016 by mathscinotes

In November 2015, the European Space Agency (ESA) had a launch problem with two of its Galileo navigational satellites that resulted in both satellites being placed into highly elliptical orbits. ESA can burn some of the satellites' station-keeping fuel to bring these orbits back to standard, but this will take some time. While the orbit adjustments are occurring, ESA will use the satellites to provide another test of Einstein's general theory of relativity. Specifically, they will test the prediction that clocks will run slower the closer they approach a massive object. Continue reading →

Posted in Astronomy, Navigation | Comments Off on Unfortunate Satellite Launch Problem Allows Test of Relativistic Time Dilation

WW2 Submarine Endurance on Batteries

Posted on 16-February-2016 by mathscinotes

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 | Comments Off on WW2 Submarine Endurance on Batteries