Monthly Archives: October 2016

I Am Now A Grandpa

I am bursting with excitement right now. My youngest son and his wife now have a little girl. The baby arrived about 3 weeks early, but both mother and baby are doing fine. I could not be happier for their family.
Continue reading

Posted in Personal | 5 Comments

Excel Data Table with More Than Two Input Variables

I am a big fan of Excel data tables, but I often struggle because they are designed to work with one or two input variables and a single output function. Many of calculations that I do have more than two input variables that I need to vary. These calculations also often have multiple output values. This post discusses how to create a data table with more than 3 input variables and more than one output variable. Continue reading

Posted in Excel | 2 Comments

Tree Felling Miracle

I have seen a number of people fell trees onto homes and cars. Here is one case where two good-ol' boys dropped one successfully. Continue reading

Posted in Humor | Comments Off on Tree Felling Miracle

What R-Value Is Good Enough?

I plan on retiring at my lake home in Northern Minnesota. The first step in my retirement preparations is building a large garage on my retirement property that will allow me to work on my various projects – I have not mentioned it before, but I love doing auto body work. I am currently building a garage similar to that shown in Figure 1. Because northern Minnesota is quite cold in the winter, I needed to insulate and heat this structure. This post will review some observations that I made as to the value of insulation and of using modern ventilation systems with heat recovery capability. Continue reading

Posted in Construction | 4 Comments

Fighter Plane Statistics

So I prowled around the web and found a site that seemed to have some good information on the combat history of active jet fighters, including the F-16. I thought I would use this question as a vehicle for sharpening my Power Query and Excel web scraping skills by making comparison table between the active duty fighter jets. Continue reading

Posted in History Through Spreadsheets, Military History | Comments Off on Fighter Plane Statistics

Using Excel's Icon Sets for Testing Equality -- Ugh

I use Excel everyday, but that does not mean that I have used every feature. Yesterday, I was asked to prepare an analysis for our marketing group of the maximum possible distances that over which a customer can be served using various types of fiber optic communication systems – we call this parameter "reach". During this analysis, I saw what I thought was an ideal opportunity to use Excel's icon sets for the first time (Figure 1). Continue reading

Posted in Excel | 7 Comments

Battery Room Ventilation Math

In this post, I will be looking at how these ventilation calculations are performed. My focus here is on standard wet-cell batteries, which simply release any gases generated during charging. Other battery types, like Absorbed Glass Mat (AGM), will attempt to recombine the H2 and O2 released during charging. The AGM battery's internal gas recombination will reduce the amount of H2 released by these batteries – example shown here. I will compare the output of my model to those generated by a number of web-based and textbook sources. The results are in good agreement. Continue reading

Posted in Batteries | 1 Comment

Effective R Value of Common Wall Construction Methods

Because the winters are hard in this part of the country, I have become interested in the insulation value of different types of wall construction. My contractor has his preferred approach, and I am curious as to how it compares with other framing methods.

In this post, I will put together a simple model for computing the R-value of different types of wall construction. This analysis will provide me a quantitative basis for understanding which methods are the most economically sound. Continue reading

Posted in Construction | 1 Comment