Category Archives: software

Inserting Images into Excel Comments Using VBA

Posted on 14-November-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 | 27 Comments

Volcano Math

Posted on 24-July-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 28-April-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 held to award a prize to one of the exercisers. To encourage more exercising, the likelihood of winning is to be proportional to the number of laps each person walked during the month. I was asked if I could write an Excel worksheet that would perform this task. Continue reading →

Posted in software | 42 Comments

Worked PageRank Example

Posted on 2-January-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 , | Comments Off on Worked PageRank Example