Tips

Link to your google sheet from your google document by copying and pasting the range you want.

Update the document when the sheet changes.

Speed up the calculations by simplifying. Click 'Ogden', 'Simplify'. This will convert columns of multiplier functions into a single function. That means the information is sent to the API only once, rather than multiple times.

Use the formula "=MULTIPLIERL(......)" to return a break down of the multiplier for the past, interest and future.

Format your multiplier cells automatically. Click Ogden Split Multipliers/Format.

For standard split multipliers you can enter less data and accept the defaults. The defaults are a frequency of one year with discounts 'AMI'.