Anti-Dilution Calculations: Full-ratchet and Broad-based Weighted Average models

I think I got this right. If you see an error ping me directly and I will happily correct it. The logic came from here: http://www.startupcompanylawyer.com/2007/08/04/what-is-full-ratchet-anti-dilution-protection/ and here: http://www.startupcompanylawyer.com/2007/08/04/what-is-weighted-average-anti-dilution-protection/ and I have simply done the work of translating it to Excel in the attached spreadsheet.