Category Archives: software

Making IP Addresses Sortable By Number

Posted on November 21, 2014 by mathscinotes

My oldest son called me last night and was wondering how to use Excel to sort a long list of IPv4 addresses in numerical order. These IPv4 addresses are written in a human readable form using octets (Figure 1), which … Continue reading →

Posted in software | Leave a comment

Inserting Images into Excel Comments Using VBA

Posted on November 14, 2013 by mathscinotes

I use Excel for basic statistical analysis of manufacturing and field return data as part of daily routine. I also use Excel for department budgeting. During these tasks, I frequently need to add information to my spreadsheets about my information … Continue reading →

Posted in Management, software | Leave a comment

Volcano Math

Posted on July 24, 2012 by mathscinotes

I was listening to Planetary Radio the other night and they had an interesting interview with Rosaly Lopes, a researcher at the Jet Propulsion Laboratory who has discovered more volcanoes than anyone else. Her discoveries were of volcanoes on other … Continue reading →

Posted in General Science, software | Tagged , | 4 Comments

Randomly Choosing a Winner from a Weighted List with Excel

Posted on April 28, 2012 by mathscinotes

My wife is participating in a friendly contest at work that encourages employees to exercise. The employees record how many laps they walk around a set course during a month. At the end of the month, an Excel “drawing” is … Continue reading →

Posted in software | 3 Comments

Worked PageRank Example

Posted on January 2, 2012 by mathscinotes

Introduction One of my sons asked me if I could work through a PageRank calculation example a couple of different ways (algebraic and iterative). It was an interesting exercise and I thought it would be worth documenting here. I used … Continue reading →

Posted in software | Tagged , | Leave a comment