Author Archives: mathscinotes

Weed and Feed Math

Posted on 28-August-2021 by mathscinotes

Two weeks ago, the grass around my garage looked pretty scraggly and weed-infested, so I decided it was time for fertilizer and weed-killer. I am not very knowledgeable about lawns and lawn care, so I decided to research online. This research is summarized in this post. Yes, it was time for some fertilizer and weed-killer. Continue reading →

Posted in Cabin | 3 Comments

Lightning Damage at My Garage

Posted on 12-August-2021 by mathscinotes

During a major storm two weeks ago with 80 mile per hour winds (129 kph) and heavy rain,  a lightning strike near my garage destroyed two TVs, a power adapter for my robot lawnmowers, a wireless router, two data switches, and my furnace's propane tank regulator and copper feedline. As an illustration of the damage, Figure 1 shows the residue left from my mower power adapter exploding. The light region inside the smudge is from my fingers wiping across the smudge to see how thick the film was. The film was removed using mineral spirits. A small burn mark is all that remains. Continue reading →

Posted in Cabin | 2 Comments

Excel Spillable Ranges are Great!

Posted on 8-August-2021 by mathscinotes

I use Python or R for my large-scale data work, but I do find Excel a very powerful ad hoc data analysis tool, particularly with some of the new functions that use spillable ranges. Today, I was given a large table of Engineering Change Orders (ECOs) and a comma-separated list of the documents each ECO affected (very abbreviated form shown in Figure 1). Continue reading →

Posted in Excel | Comments Off on Excel Spillable Ranges are Great!

Effect of Lumber Price Rise on House Cost

Posted on 27-June-2021 by mathscinotes

Quote of the Day Great things are not done by impulse, but by a series of small things brought together. — Vincent van Gogh Introduction I recently went into a home center and was shocked to see a 2‑in x … Continue reading →

Posted in Construction | 4 Comments

Our House Design Process

Posted on 27-May-2021 by mathscinotes

A number of people have asked questions about the process we used to design and build our cabin in northern Minnesota (Figure 1), a build that I have discussed in other posts (link, link). The questions center on the tools we used, what the build process was like, and things to watch for. The following post examines our design and build process from the standpoint of what went well and not so well. Continue reading →

Posted in Cabin, Construction | Comments Off on Our House Design Process

Ben Franklin and the Gulf Stream

Posted on 30-April-2021 by mathscinotes

One of my favorite Youtube channels is Wind Hippie Sailing. The Wind Hippie is a free spirit who does not worry about little details like currents and wind – this is the charm of her channel.  While sailing from North Carolina to Puerto Rico, she soon learned the power of the Gulf Stream when she discovered that she was making very slow (maybe negative) progress. Fortunately, she was able to get out of that situation. I was worried she might end up somewhere dangerous, like a reef. Continue reading →

Posted in History of Science and Technology, Naval History, Navigation | 6 Comments

US Daylight Saving Time Date Calculation in Excel

Posted on 14-March-2021 by mathscinotes

I recently had a situation where I needed to correct a number of date/time values because they did not take into account Daylight Saving Time (DST). To be specific, some transactions from China were recorded assuming a fixed time offset with respect to US Central Standard Time. Because of DST, this is not always the case. My customer only works in Excel, so the work was done in Excel. Continue reading →

Posted in Excel | 6 Comments

Taffy 3 Total Displacement vs Yamato Using R

Posted on 10-March-2021 by mathscinotes

I was watching a documentary on the Battle Off Samar on my favorite Youtube naval channel called Drachinifel. During this show, Drachinifel stated that the battleship Yamato displaced more tonnage than the entire Task Group 77.4.3 (call sign Taffy 3) defense force. I found this a remarkable statement and one that I could verify using a little bit of web scraping. Because one of the students I tutor use R, I thought this would be a good exercise to implement using R and Rmarkdown (a great report generation tool). Continue reading →

Posted in History Through Spreadsheets, Naval History | 2 Comments

US Battleship Fuel Usage

Posted on 16-January-2021 by mathscinotes

In this post, I will examine the fuel consumption of the three most modern battleship classes that the US deployed during WW2: South Dakota, North Carolina, and Iowa classes. The data is scraped from the Hyperwar website, which is one of my favorite targets for data extraction. In this case, the Hyperwar page contains a set of tables from the US Navy document FTP 218: War Service Fuel Consumption of US Navy Surface Vessels. Continue reading →

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

50 Destroyer Pre-War Base Deal

Posted on 7-January-2021 by mathscinotes

This post is going to look at the Destroyers for Bases deal between the US and UK. The bargain was an executive agreement announced on 2-Sep-1940 to trade 50 WW1-era US destroyers to the UK for US basing rights in the Caribbean, Bermuda, and Newfoundland. I have seen the destroyers described as obsolete, which seemed odd for ~20-year-old destroyers that nominally have 30 year lifetime (typical for most US Navy ships). Continue reading →

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