The spreadsheet using 2014-normalized dollars is now being produced on the build server.

The calculation is not actually very complicated, but parsing the spreadsheet turned out to be a bit tricky, and I think that code could be tightened up a bit to reduce risky assumptions that work in the case of our own spreadsheets but might not generalize very well. Things to think about:

• This of course normalizes $1 transactions, so we'll have to take account of that when we decide which transactions are for nominal amounts in later processing.
• Some transactions take place before 1914, the earliest year for which we have a rate, so I've done those all at the 1914 rate.
• There are 268 instances of zero dates (0000-00-00) which have consideration values. I think rather than fudging those, we should fill them in by revisiting the records. We could make a principled decision to use the transfer date instead, assuming there is one.