Category Archives: software

Inserting Images into Excel Comments Using VBA

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 | 16 Comments

Volcano Math

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

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 | 34 Comments

Worked PageRank Example

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