Tag Archives: Excel Tables

Generating Sitemap Links with Excel

Posted on April 13, 2016 by Win Smith

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

Posted on April 17, 2013 by Win Smith

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

Posted on August 21, 2012 by Win Smith

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

Tables vs. Fences

Posted on May 10, 2011 by Win Smith

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