Monthly Archives: December 2017

Audie Murphy's Rifle and the Power of Databases

Posted on 26-December-2017 by mathscinotes

When I was a boy, I read the memoir To Hell and Back by Audie Murphy and was very impressed with his accomplishments as an infantry soldier during WW2 (Figure 1). It is a very American tale – a dirt poor teenager from family with a dead mother and missing father accomplishes amazing feats through sheer determination and force of will. He later starred in a movie version of his book that is well worth watching. I should mention that the book tells a better tale than the movie. Continue reading →

Posted in Military History, software | 10 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

Super Bowl Winners and Losers Using Power Query

Posted on 13-December-2017 by mathscinotes

I was reading a post on Statista showing the NFL teams with the most Super Bowl wins. Since my staff includes a number of football fans — mainly Viking and Packer supporters — I decided it would be a good training exercise to show them how to gather the football statistics and present them in the same manner as shown on Statista. I should mention that I do not follow football at all; this is purely a data analysis exercise for me. Continue reading →

Posted in Excel, Statistics | Comments Off on Super Bowl Winners and Losers Using Power Query

My Star Trek TOS Database

Posted on 8-December-2017 by mathscinotes

The people on my team frequently chide me for using management analogies drawn from the original Star Trek television series, which fans refer to as Star Trek TOS. Because of these analogies, I need to provide exact references for the younger folks on our team who have not memorized every episode. I decided that it was time for me to put together an online list that I could search and sort as the need arises. I grabbed the data from the Internet Movie Database (IMBD), including their overall reviews of each episode. Continue reading →

Posted in Science Fiction | 5 Comments

Cannon Bore Measured in Pounds

Posted on 7-December-2017 by mathscinotes

I have been pulling together some WW2 data for an article that I want to publish in the next year or two. During my research, I have noticed that the British specified the caliber of their artillery by the nominal mass of the projectile (lbm or pound mass) and not by the bore diameter. I was curious as to how the British came to this particular system and decided to investigate further. As with many military standards, it traces its history back hundreds of years. Continue reading →

Posted in Military History | Comments Off on Cannon Bore Measured in Pounds

The Pacific War and Manufacturing Capacity

Posted on 4-December-2017 by mathscinotes

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 | Comments Off on The Pacific War and Manufacturing Capacity