Category Archives: Spreadsheet Tips

Generating Sitemap Links with Excel

We have become good friends with the Ysais family of Kyle, Texas.  They visited us in Colorado last summer and we all had a great time.  Corrina stays in touch with Marie almost every day, our daughter Skypes and plays … Continue reading

Posted in Spreadsheet Tips | Tagged , , , , | 1 Comment

A Tool That Would Have Helped Reinhart and Rogoff

Economists Carmen Reinhart and Ken Rogoff (“R&R”) have been widely cited for a study that concluded that growth rates for countries with public debt over 90% of GDP are lower than for countries with less debt.  A recent critique by Thomas Herndon … Continue reading

Posted in Economics, Spreadsheet Tips | Tagged , , , , | 10 Comments

Fast Formulas #3: The Spreadsheet

Fast Formulas #3: Pool Average Life with CPR Prepayments showed a shortcut for finding the weighted average life (“WAL”) of a homogenous pool of loans assuming a constant prepayment rate.  The shortcut, Formula 3.1, takes just a few steps to calculate … Continue reading

Posted in Fast Formulas, Math, Spreadsheet Tips | Tagged , , , | 2 Comments

A Big, Avoidable Mistake

Yesterday, I found a multi-million dollar error in a spreadsheet that had been prepared by someone else. The spreadsheet’s author had employed some of Excel’s most advanced features, but had not followed a simple practice that would have prevented the … Continue reading

Posted in Spreadsheet Tips | Tagged | 7 Comments

Good Fences Make Good Spreadsheets, Part 3

Good Fences Make Good Spreadsheets, Part 1 discussed the idea of using border rows or border columns to surround blocks of cells. The borders assure that totals will include any new cells that are inserted into the block. Part 2 in … Continue reading

Posted in Spreadsheet Tips | Tagged | 3 Comments

Tables vs. Fences

In Good Fences Make Good Spreadsheets, Part 1 and Part 2, I advocated the use of border rows and columns to manage blocks of data for SUM calculations. These borders, or “fences”, ensure that the totals will always reflect any … Continue reading

Posted in Spreadsheet Tips | Tagged , | 6 Comments

Good Fences Make Good Spreadsheets, Part 2

Good Fences Make Good Spreadsheets, Part 1 discussed the idea of using border rows or border columns to hold blocks of data for use by the SUM function. The borders assure that the SUM function will include any new cells … Continue reading

Posted in Spreadsheet Tips | Tagged | 5 Comments