{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Ashburton EAC","Calculations","Lists","Instruments","Allocation Detail"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":43,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ashburton EAC","index":0,"n_rows":127,"n_cols":587,"rows_kept":127,"cut":false,"hidden":false,"merged":[[19,0,19,1],[12,0,12,2],[14,0,14,2],[16,0,16,1],[17,0,17,1],[18,0,18,1],[40,0,40,1],[3,0,3,1],[29,0,29,3],[30,0,30,3],[31,0,31,3],[37,0,37,5],[32,0,32,3],[35,0,35,5],[10,0,10,1],[5,0,5,1],[6,0,6,1],[8,0,8,1],[11,0,11,1],[9,0,9,2],[7,0,7,2],[33,0,33,3],[41,0,41,1],[42,0,42,1],[43,0,43,1],[39,0,39,1],[3,2,3,4],[4,0,4,1],[21,0,21,3],[27,0,27,3],[28,0,28,3],[22,0,22,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[13,0,13,1],[15,0,15,1]]}
[]
[null,null,"Ashburton Fund Managers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Lump sum investment"]
["Investment amount",null,null,null,0,{"$f":"IF(AND(C4=\"Ashburton Tax Free Savings Account\",E7>Lists!$A$27),\"Maximum permissible contribution exceeded.\",\"\")","v":""}]
["Initial advisor fee percentage (excl. VAT)",null,null,null,0]
[]
["Monthly recurring investment"]
["Investment amount",null,null,null,0,{"$f":"IF(AND(C4=\"Ashburton Tax Free Savings Account\",E11>Lists!$A$28),\"Maximum permissible contribution exceeded\",\"\")","v":""}]
["Annual escalation percentage",null,null,null,0]
["Initial advisor fee percentage (excl. VAT)",null,null,null,0]
[]
["Annual advisor fee percentage (excl. VAT)",null,null,null,0]
[]
["Regular disinvestment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Income amount per frequency",null,null,null,0,{"$f":"IF(E18=0,\"\",IF(AND(C2=Lists!#REF!,'Ashburton EAC'!C4=Lists!#REF!),\"\",IF(AND('Ashburton EAC'!C2=Lists!#REF!,'Ashburton EAC'!C4=Lists!#REF!),\"\",IF(E18=\"\",\"\",\"Regular disinvestment not allowed.\"))))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Income frequency",null,null,null,"Select:"]
["Income escalation",null,null,null,0]
[]
["Investment allocation\n\nInstrument name",null,null,null,"Lump sum \nallocation (%)","Recurring investment allocation (%)"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[{"$f":"IF(OR(E34>1,F34>1),\"The total allocation is greater than 100%, please check.\",\"\")","v":""},null,null,null,{"$f":"SUM(E23:E33)","v":0},{"$f":"SUM(F23:F33)","v":0}]
[]
[{"$f":"\"Effective Annual Cost:   \"&C4","v":"Effective Annual Cost:   "}]
[]
["The Effective Annual Cost (EAC) is a measure which has been introduced to allow you to compare the cost you incur when you invest in different financial products. It is expressed as a percentage of your investment amount. The EAC is made up of four charges, which are added together, as shown in the table below. Some of the charges may vary, depending on your investment period. The EAC calculation assumes that an investor terminates his or her investment in the financial product at the end of the relevant periods shown in the table.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Charges",null,"1 Year","3 Years","5 Years","10 Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Investment management",null,{"$f":"Calculations!B50","v":0},{"$f":"Calculations!C50","v":0},{"$f":"Calculations!D50","v":0},{"$f":"Calculations!E50","v":0}]
["Advice",null,{"$f":"IF(F34>0,Calculations!B51,(E8+E15)*1.15)","v":0},{"$f":"IF(F34>0,Calculations!C51,((E8/3)+E15)*1.15)","v":0},{"$f":"IF(F34>0,Calculations!D51,((E8/5)+E15)*1.15)","v":0},{"$f":"IF(F34>0,Calculations!E51,((E8/10)+E15)*1.15)","v":0}]
["Administration",null,{"$f":"Calculations!$D$65","v":0},{"$f":"Calculations!$D$65","v":0},{"$f":"Calculations!$D$65","v":0},{"$f":"Calculations!$D$65","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Effective Annual Cost",null,{"$f":"SUM(C41:C43)","v":0},{"$f":"SUM(D41:D43)","v":0},{"$f":"SUM(E41:E43)","v":0},{"$f":"SUM(F41:F43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Calculations","index":1,"n_rows":127,"n_cols":112,"rows_kept":127,"cut":false,"hidden":true,"merged":[[0,14,0,16],[0,53,0,71],[0,73,0,90],[0,92,0,110],[0,24,0,30],[0,33,0,51]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation Excluding Fees",null,null,null,null,null,null,null,null,"Advice fees - 10 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advice fees - 5 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advice fees - 3 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Advice fees - 1 years"]
[null,null,null,null,null,"Payment number","Month","Allocation then\nAsh U/T value at start of month","Ash U/T recurring value at start of month","Recurring investment (Ash u/t)","Ash u/t return on recurring","Return","ASH u/t annual fee","ASH recurring u/t annual fee","ASH u/t annual advice fee (Lump sum)","ASH u/t annual advice fee (Recurring)","Tot annual advice fee","Recurring value at end","Value before income","Income from ASH u/t","Income payment","Value at end",null,null,"Payment number","Month","Value at start of month","Recurring investment","Return","Income payment","Value at end",3.2661049652431538E-3,null,"Payment number","Month","Ash U/T value at start of month","Ash U/T recurring value at start of month","Tot value at start of month","Recurring investment (Ash u/t)","Ash u/t return","Ash u/t return","Return","ASH u/t annual fee","ASH recurring u/t annual fee","ASH u/t annual advice fee","ASH u/t annual advice fee","Tot annual advice fee","Recurring value at end","Value before income","Income from ASH u/t","Income payment","Value at end",4.2284820894709745E-3,"Payment number","Month","Ash U/T value at start of month","Ash U/T recurring value at start of month","Tot value at start of month","Recurring investment (Ash u/t)","Ash u/t return","Ash u/t return","Return","ASH u/t annual fee","ASH recurring u/t annual fee","ASH u/t annual advice fee","ASH u/t annual advice fee","Tot annual advice fee","Recurring value at end","Value before income","Income from ASH u/t","Income payment","Value at end",4.0822054915426037E-3,"Payment number","Month","Ash U/T value at start of month","Ash U/T recurring value at start of month","Tot value at start of month","Recurring investment (Ash u/t)","Ash u/t return","Ash u/t return","ASH u/t annual fee","ASH recurring u/t annual fee","ASH u/t annual advice fee","ASH u/t annual advice fee","Tot annual advice fee","Recurring value at end","Value before income","Income from ASH u/t","Income payment","Value at end",3.88809237169344E-3,"Payment number","Month","Ash U/T value at start of month","Ash U/T recurring value at start of month","Tot value at start of month","Recurring investment (Ash u/t)","Ash u/t return","Ash u/t return","Return","ASH u/t annual fee","ASH recurring u/t annual fee","ASH u/t annual advice fee","ASH u/t annual advice fee","Tot annual advice fee","Recurring value at end","Value before income","Income from ASH u/t","Income payment","Value at end",2.9198560510362973E-3]
[null,null,null,{"$f":"(1+B45)^(1/12)-1","v":4.8675505653430484E-3},null,1,0,{"$f":"'Allocation Detail'!D13","v":0},0,{"$f":"IF(G3/$D$16-INT(G3/$D$16)=0,ROUND($D$19*$D$20*((1+$D$17)^INT(G3/12)),2),0)","v":0},{"$f":"ROUND(J3*((1+$B$45)^(1/12)-1),2)","v":0},{"$f":"ROUND(H3*((1+$B$45)^(1/12)-1),2)","v":0},{"$f":"IFERROR(ROUND(-SUM(H3,L3)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(J3,K3)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"ROUND(-(H3+L3)*$B$11/12*1.15,2)","v":0},{"$f":"ROUND(-(I3+J3+K3)*$B$11/12*1.15,2)","v":0},{"$f":"-SUM(H3:I3,L3:L3)*$B$11/12*1.15","v":0},{"$f":"SUM(I3,J3,K3,N3,P3)","v":0},{"$f":"SUM(H3,L3,M3,O3)","v":0},{"$f":"IFERROR(U3*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((G3/$D$41)-INT(G3/$D$41)=0,$D$39*((1+$D$42)^INT(G3/12)),0)),-S3))","v":0},{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),S3+R3,MAX(R3+S3+U3,0))","v":0},{"$f":"SUM(M3:N3,Q3)/(S3)*-12","v":{"$error":"#DIV/0!"}},null,1,0,{"$f":"D8","v":0},{"$f":"IF(G3/$D$16-INT(G3/$D$16)=0,ROUND($D$14*((1+$D$17)^INT(G3/12)),2),0)","v":0},{"$f":"(AA3+AB3)*$AF$2","v":0},{"$f":"MAX(-IF($D$41=\"\",0,IF((Z3/$D$41)-INT(Z3/$D$41)=0,$D$39*((1+$D$42)^INT(Z3/12)),0)),-SUM(AA3,AB3,AC3))","v":0},{"$f":"MAX(SUM(AA3:AD3),0)","v":0},{"$f":"IF(AE3=0,AA3,0)","v":0},null,1,0,{"$f":"'Allocation Detail'!D13/(1-$B$9*1.15)","v":0},0,{"$f":"SUM(AJ3:AK3)","v":0},{"$f":"D14","v":0},{"$f":"ROUND(AM3*BA$2,2)","v":0},{"$f":"ROUND(AJ3*BA$2,2)","v":0},{"$f":"SUM(AO3:AO3)","v":0},{"$f":"IFERROR(ROUND(-SUM(AJ3,AO3)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AM3,AN3)*'Allocation Detail'!H13/12,2),0)","v":0},0,0,0,{"$f":"SUM(AK3,AM3,AN3,AR3,AT3)","v":0},{"$f":"SUM(AJ3,AO3,AQ3,AS3)","v":0},{"$f":"IFERROR(AY3*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((AI3/$D$41)-INT(AI3/$D$41)=0,$D$39*((1+$D$42)^INT(AI3/12)),0)),-AW3))","v":0},{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),AW3+AV3,MAX(AV3+AW3+AY3,0))","v":0},null,1,0,{"$f":"'Allocation Detail'!D13/(1-$B$9*1.15)","v":0},0,{"$f":"SUM(BD3:BE3)","v":0},{"$f":"IF(BC3/$D$16-INT(BC3/$D$16)=0,ROUND($D$14*$D$20*((1+$D$17)^INT(BC3/12)),2),0)","v":0},{"$f":"ROUND(BG3*BU$2,2)","v":0},{"$f":"ROUND(BD3*BU$2,2)","v":0},{"$f":"SUM(BI3:BI3)","v":0},{"$f":"IFERROR(ROUND(-SUM(BD3,BI3)*'Allocation Detail'!E13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BG3,BH3)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,{"$f":"-SUM(BD3:BE3,BI3:BI3)*$B$11/12*1.15","v":0},{"$f":"SUM(BE3,BG3,BH3,BL3,BN3)","v":0},{"$f":"SUM(BD3,BI3,BK3,BM3)","v":0},{"$f":"IFERROR(BS3*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((BC3/$D$41)-INT(BC3/$D$41)=0,$D$39*((1+$D$42)^INT(BC3/12)),0)),-BQ3))","v":0},{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),BQ3+BP3,MAX(BP3+BQ3+BS3,0))","v":0},null,1,0,{"$f":"'Allocation Detail'!$D$13/(1-$B$9*1.15)","v":0},0,{"$f":"SUM(BX3:BY3)","v":0},{"$f":"IF(BW3/$D$16-INT(BW3/$D$16)=0,ROUND($D$14*$D$20*((1+$D$17)^INT(BW3/12)),2),0)","v":0},{"$f":"ROUND(CA3*CN$2,2)","v":0},{"$f":"ROUND(BX3*CN$2,2)","v":0},{"$f":"IFERROR(ROUND(-SUM(BX3,CC3)*'Allocation Detail'!E13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CA3,CB3)*'Allocation Detail'!H13/12,2),0)","v":0},0,0,{"$f":"-SUM(BX3:BY3,CC3:CC3)*$B$11/12*1.14","v":0},{"$f":"SUM(BY3,CA3,CB3,CE3)","v":0},{"$f":"SUM(BX3,CC3,CD3)","v":0},{"$f":"IFERROR(CL3*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((BW3/$D$41)-INT(BW3/$D$41)=0,$D$39*((1+$D$42)^INT(BW3/12)),0)),-CJ3))","v":0},{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),CJ3+CI3,MAX(CI3+CJ3+CL3,0))","v":0},null,1,0,{"$f":"'Allocation Detail'!D13/(1-$B$9*1.15)","v":0},0,{"$f":"SUM(CQ3:CR3)","v":0},{"$f":"IF(CP3/$D$16-INT(CP3/$D$16)=0,ROUND($D$14*$D$20*((1+$D$17)^INT(CP3/12)),2),0)","v":0},{"$f":"ROUND(CT3*DH$2,2)","v":0},{"$f":"ROUND(CQ3*DH$2,2)","v":0},{"$f":"SUM(CV3:CV3)","v":0},{"$f":"IFERROR(ROUND(-SUM(CQ3,CV3)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CT3,CU3)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,{"$f":"SUM(CR3,CT3,CU3,CY3,DA3)","v":0},{"$f":"SUM(CQ3,CV3,CX3,CZ3)","v":0},{"$f":"IFERROR(DF3*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((CP3/$D$41)-INT(CP3/$D$41)=0,$D$39*((1+$D$42)^INT(CP3/12)),0)),-DD3))","v":0},{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),DD3+DC3,MAX(DC3+DD3+DF3,0))","v":0}]
[null,null,null,null,null,{"$f":"F3+1","v":2},{"$f":"G3+1","v":1},{"$f":"ROUND(SUM(H3,L3,M3,O3,T3),2)","v":0},{"$f":"SUM(I3,J3,K3,N3,P3)","v":0},0,{"$f":"ROUND((J4+I4)*((1+$B$45)^(1/12)-1),2)","v":0},0,{"$f":"IFERROR(ROUND(-SUM(H4,L4)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I4,J4,K4)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"ROUND(-(H4+L4)*$B$11/12*1.15,2)","v":0},{"$f":"ROUND(-(I4+J4+K4)*$B$11/12*1.15,2)","v":0},{"$f":"-SUM(H4:I4,L4:L4)*$B$11/12*1.15","v":0},{"$f":"SUM(I4,J4,K4,N4,P4)","v":0},{"$f":"SUM(H4,L4,M4,O4)","v":0},{"$f":"IFERROR(U4*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),S4+R4,MAX(R3+S4+U4,0))","v":0},{"$f":"SUM(M4:N4,Q4)/(S4)*-12","v":{"$error":"#DIV/0!"}},null,{"$f":"Y3+1","v":2},{"$f":"Z3+1","v":1},{"$f":"AE3","v":0},0,{"$f":"(AA4+AB4)*$AF$2","v":0},0,{"$f":"MAX(SUM(AA4:AD4),0)","v":0},{"$f":"IF(AE4=0,AA4,0)","v":0},null,{"$f":"AH3+1","v":2},{"$f":"AI3+1","v":1},{"$f":"ROUND(SUM(AJ3,AO3,AQ3,AS3,AX3),2)","v":0},{"$f":"SUM(AK3,AM3,AN3,AR3,AT3)","v":0},0,{"$f":"IF(AI4/$D$16-INT(AI4/$D$16)=0,ROUND($D$14*$D$20*((1+$D$17)^INT(AI4/12)),2),0)","v":0},{"$f":"ROUND((AM4+AK4)*BA$2,2)","v":0},0,0,{"$f":"IFERROR(ROUND(-SUM(AJ4,AO4)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK4,AM4,AN4)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,{"$f":"SUM(AK4,AM4,AN4,AR4,AT4)","v":0},{"$f":"SUM(AJ4,AO4,AQ4,AS4)","v":0},{"$f":"IFERROR(AY4*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),AW4+AV4,MAX(AV3+AW4+AY4,0))","v":0},null,{"$f":"BB3+1","v":2},{"$f":"BC3+1","v":1},{"$f":"ROUND(SUM(BD3,BI3,BK3,BM3,BR3),2)","v":0},{"$f":"SUM(BE3,BG3,BH3,BL3,BN3)","v":0},0,0,{"$f":"ROUND((BE4+BG4)*BU$2,2)","v":0},{"$f":"ROUND(BD4*BU$2,2)","v":0},0,{"$f":"IFERROR(ROUND(-SUM(BD4,BI4)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE4,BG4,BH4)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,{"$f":"-SUM(BD4:BE4,BI4)*$B$11/12*1.15","v":0},{"$f":"SUM(BE4,BG4,BH4,BL4,BN4)","v":0},{"$f":"SUM(BD4,BI4,BK4,BM4)","v":0},{"$f":"IFERROR(BS4*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BV3+1","v":2},{"$f":"BW3+1","v":1},{"$f":"ROUND(SUM(BX3,CC3,CD3,CF3,CK3),2)","v":0},{"$f":"SUM(BY3,CA3,CB3,CE3,CG3)","v":0},0,0,{"$f":"ROUND((CA4+BY4)*CN$2,2)","v":0},0,{"$f":"IFERROR(ROUND(-SUM(BX4,CC4)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY4,CA4,CB4)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,{"$f":"-SUM(BX4:BY4,CC4)*$B$11/12*1.14","v":0},{"$f":"SUM(BY4,CA4,CB4,CE4)","v":0},{"$f":"SUM(BX4,CC4,CD4)","v":0},{"$f":"IFERROR(CL4*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"CO3+1","v":2},{"$f":"CP3+1","v":1},{"$f":"ROUND(SUM(CQ3,CV3,CX3,CZ3,DE3),2)","v":0},{"$f":"SUM(CR3,CT3,CU3,CY3,DA3)","v":0},0,0,{"$f":"ROUND((CT4+CR4)*DH$2,2)","v":0},0,0,{"$f":"IFERROR(ROUND(-SUM(CQ4,CV4)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR4,CT4,CU4)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,{"$f":"SUM(CR4,CT4,CU4,CY4,DA4)","v":0},{"$f":"SUM(CQ4,CV4,CX4,CZ4)","v":0},{"$f":"IFERROR(DF4*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,{"$f":"F4+1","v":3},{"$f":"G4+1","v":2},0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H5,L5)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I5,J5,K5)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"ROUND(-(H5+L5)*$B$11/12*1.15,2)","v":0},{"$f":"ROUND(-(I5+J5+K5)*$B$11/12*1.15,2)","v":0},{"$f":"-SUM(H5:I5,L5:L5)*$B$11/12*1.15","v":0},0,0,{"$f":"IFERROR(U5*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,{"$f":"Y4+1","v":3},2,{"$f":"AE4","v":0},0,0,0,0,0,null,{"$f":"AH4+1","v":3},2,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ5,AO5)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK5,AM5,AN5)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY5*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB4+1","v":3},2,0,0,0,0,{"$f":"ROUND((BE5+BG5)*BU$2,2)","v":0},0,0,{"$f":"IFERROR(ROUND(-SUM(BD5,BI5)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE5,BG5,BH5)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,{"$f":"-SUM(BD5:BE5,BI5)*$B$11/12*1.15","v":0},0,0,{"$f":"IFERROR(BS5*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BV4+1","v":3},2,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX5,CC5)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY5,CA5,CB5)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,{"$f":"SUM(BY5,CA5,CB5,CE5)","v":0},{"$f":"SUM(BX5,CC5,CD5)","v":0},{"$f":"IFERROR(CL5*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"CO4+1","v":3},2,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ5,CV5)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR5,CT5,CU5)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF5*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,4,3,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H6,L6)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I6,J6,K6)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U6*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,4,3,0,0,0,0,0,0,null,4,3,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ6,AO6)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK6,AM6,AN6)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY6*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB5+1","v":4},3,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD6,BI6)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE6,BG6,BH6)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS6*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,4,3,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX6,CC6)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY6,CA6,CB6)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL6*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,4,3,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ6,CV6)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR6,CT6,CU6)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF6*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Lump Sum Investment",null,null,null,null,5,4,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H7,L7)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I7,J7,K7)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U7*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,5,4,0,0,0,0,0,0,null,5,4,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ7,AO7)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK7,AM7,AN7)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY7*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB6+1","v":5},4,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD7,BI7)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE7,BG7,BH7)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS7*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,5,4,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX7,CC7)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY7,CA7,CB7)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL7*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,5,4,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ7,CV7)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR7,CT7,CU7)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF7*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Investment Amount",null,null,{"$f":"'Ashburton EAC'!E7","v":0},null,6,5,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H8,L8)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I8,J8,K8)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U8*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,6,5,0,0,0,0,0,0,null,6,5,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ8,AO8)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK8,AM8,AN8)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY8*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB7+1","v":6},5,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD8,BI8)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE8,BG8,BH8)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS8*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,6,5,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX8,CC8)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY8,CA8,CB8)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL8*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,6,5,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ8,CV8)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR8,CT8,CU8)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF8*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Initial Advice Fee",{"$f":"'Ashburton EAC'!E8","v":0},0.15,{"$f":"B9*D8*(1+C9)","v":0},null,7,6,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H9,L9)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I9,J9,K9)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U9*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,7,6,0,0,0,0,0,0,null,7,6,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ9,AO9)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK9,AM9,AN9)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY9*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB8+1","v":7},6,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD9,BI9)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE9,BG9,BH9)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS9*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,7,6,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX9,CC9)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY9,CA9,CB9)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL9*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,7,6,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ9,CV9)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR9,CT9,CU9)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF9*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Net Allocation",null,null,{"$f":"D8-D9","v":0},null,8,7,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H10,L10)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I10,J10,K10)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U10*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,8,7,0,0,0,0,0,0,null,8,7,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ10,AO10)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK10,AM10,AN10)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY10*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB9+1","v":8},7,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD10,BI10)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE10,BG10,BH10)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS10*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,8,7,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX10,CC10)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY10,CA10,CB10)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL10*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,8,7,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ10,CV10)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR10,CT10,CU10)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF10*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Ongoing Advice Fee",{"$f":"'Ashburton EAC'!E15","v":0},null,null,null,9,8,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H11,L11)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I11,J11,K11)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U11*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,9,8,0,0,0,0,0,0,null,9,8,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ11,AO11)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK11,AM11,AN11)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY11*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB10+1","v":9},8,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD11,BI11)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE11,BG11,BH11)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS11*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,9,8,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX11,CC11)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY11,CA11,CB11)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL11*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,9,8,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ11,CV11)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR11,CT11,CU11)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF11*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,10,9,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H12,L12)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I12,J12,K12)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U12*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,10,9,0,0,0,0,0,0,null,10,9,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ12,AO12)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK12,AM12,AN12)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY12*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB11+1","v":10},9,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD12,BI12)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE12,BG12,BH12)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS12*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,10,9,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX12,CC12)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY12,CA12,CB12)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL12*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,10,9,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ12,CV12)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR12,CT12,CU12)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF12*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Recurring Debit Order Investment",null,null,null,null,11,10,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H13,L13)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I13,J13,K13)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U13*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,11,10,0,0,0,0,0,0,null,11,10,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ13,AO13)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK13,AM13,AN13)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY13*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB12+1","v":11},10,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD13,BI13)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE13,BG13,BH13)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS13*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,11,10,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX13,CC13)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY13,CA13,CB13)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL13*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,11,10,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ13,CV13)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR13,CT13,CU13)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF13*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Investment Amount",null,null,{"$f":"'Ashburton EAC'!E11","v":0},null,12,11,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H14,L14)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I14,J14,K14)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U14*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,12,11,0,0,0,0,0,0,null,12,11,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ14,AO14)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK14,AM14,AN14)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY14*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB13+1","v":12},11,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD14,BI14)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE14,BG14,BH14)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS14*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,12,11,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX14,CC14)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY14,CA14,CB14)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL14*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,12,11,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(CQ14,CV14)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(CR14,CT14,CU14)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(DF14*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Frequency",null,null,"Monthly",null,13,12,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H15,L15)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I15,J15,K15)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U15*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,13,12,0,0,0,0,0,0,null,13,12,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ15,AO15)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK15,AM15,AN15)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY15*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB14+1","v":13},12,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD15,BI15)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE15,BG15,BH15)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS15*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,13,12,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX15,CC15)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY15,CA15,CB15)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL15*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Frequency multiple",null,null,{"$f":"IF(D15=\"Monthly\",1,IF(D15=\"Quarterly\",3,IF(D15=\"Half-yearly\",6,IF(D15=\"Annually\",12,\"\"))))","v":1},null,14,13,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H16,L16)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I16,J16,K16)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U16*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,14,13,0,0,0,0,0,0,null,14,13,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ16,AO16)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK16,AM16,AN16)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY16*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB15+1","v":14},13,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD16,BI16)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE16,BG16,BH16)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS16*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,14,13,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX16,CC16)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY16,CA16,CB16)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL16*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 year",{"$f":"ROUND(DG14,0)","v":0}]
["Annual Escalation",null,null,{"$f":"'Ashburton EAC'!E12","v":0},null,15,14,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H17,L17)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I17,J17,K17)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U17*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,15,14,0,0,0,0,0,0,null,15,14,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ17,AO17)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK17,AM17,AN17)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY17*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB16+1","v":15},14,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD17,BI17)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE17,BG17,BH17)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS17*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,15,14,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX17,CC17)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY17,CA17,CB17)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL17*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($V$14,0)","v":0}]
["Initial Advice Fee",{"$f":"'Ashburton EAC'!E13","v":0},0.15,{"$f":"D14*B18*(1+C18)","v":0},null,16,15,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H18,L18)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I18,J18,K18)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U18*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,16,15,0,0,0,0,0,0,null,16,15,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ18,AO18)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK18,AM18,AN18)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY18*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB17+1","v":16},15,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD18,BI18)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE18,BG18,BH18)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS18*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,16,15,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX18,CC18)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY18,CA18,CB18)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL18*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DG16-DG17","v":0}]
["Net Allocation",null,null,{"$f":"D14-D18","v":0},null,17,16,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H19,L19)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I19,J19,K19)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U19*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,17,16,0,0,0,0,0,0,null,17,16,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ19,AO19)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK19,AM19,AN19)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY19*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB18+1","v":17},16,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD19,BI19)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE19,BG19,BH19)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS19*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,17,16,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX19,CC19)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY19,CA19,CB19)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL19*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Internal u/t allocation",null,null,1,null,18,17,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H20,L20)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I20,J20,K20)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U20*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,18,17,0,0,0,0,0,0,null,18,17,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ20,AO20)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK20,AM20,AN20)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY20*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB19+1","v":18},17,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD20,BI20)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE20,BG20,BH20)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS20*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,18,17,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX20,CC20)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY20,CA20,CB20)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL20*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,19,18,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H21,L21)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I21,J21,K21)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U21*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,{"$f":"Y20+1","v":19},18,0,0,0,0,0,0,null,{"$f":"AH20+1","v":19},18,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ21,AO21)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK21,AM21,AN21)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY21*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB20+1","v":19},18,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD21,BI21)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE21,BG21,BH21)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS21*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BV20+1","v":19},18,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX21,CC21)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY21,CA21,CB21)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL21*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,20,19,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H22,L22)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I22,J22,K22)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U22*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,20,19,0,0,0,0,0,0,null,20,19,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ22,AO22)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK22,AM22,AN22)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY22*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB21+1","v":20},19,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD22,BI22)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE22,BG22,BH22)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS22*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,20,19,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX22,CC22)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY22,CA22,CB22)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL22*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Investment Allocation",null,null,null,null,21,20,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H23,L23)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I23,J23,K23)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U23*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,21,20,0,0,0,0,0,0,null,21,20,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ23,AO23)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK23,AM23,AN23)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY23*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB22+1","v":21},20,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD23,BI23)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE23,BG23,BH23)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS23*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,21,20,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX23,CC23)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY23,CA23,CB23)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL23*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Instrument Name","LS Annual WAF","Lump sum %","Recurring %","Recurring Annual WAF",22,21,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H24,L24)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I24,J24,K24)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U24*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,22,21,0,0,0,0,0,0,null,22,21,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ24,AO24)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK24,AM24,AN24)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY24*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB23+1","v":22},21,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD24,BI24)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE24,BG24,BH24)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS24*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,22,21,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX24,CC24)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY24,CA24,CB24)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL24*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A23=\"\",\"\",'Ashburton EAC'!A23)","v":""},{"$f":"IFERROR(VLOOKUP(A25,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A25,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A25,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A25,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},23,22,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H25,L25)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I25,J25,K25)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U25*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,23,22,0,0,0,0,0,0,null,23,22,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ25,AO25)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK25,AM25,AN25)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY25*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB24+1","v":23},22,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD25,BI25)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE25,BG25,BH25)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS25*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,23,22,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX25,CC25)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY25,CA25,CB25)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL25*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A24=\"\",\"\",'Ashburton EAC'!A24)","v":""},{"$f":"IFERROR(VLOOKUP(A26,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A26,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A26,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A26,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},24,23,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H26,L26)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I26,J26,K26)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U26*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,24,23,0,0,0,0,0,0,null,24,23,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ26,AO26)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK26,AM26,AN26)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY26*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB25+1","v":24},23,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD26,BI26)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE26,BG26,BH26)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS26*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,24,23,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX26,CC26)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY26,CA26,CB26)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL26*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A25=\"\",\"\",'Ashburton EAC'!A25)","v":""},{"$f":"IFERROR(VLOOKUP(A27,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A27,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A27,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A27,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},25,24,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H27,L27)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I27,J27,K27)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U27*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,25,24,0,0,0,0,0,0,null,25,24,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ27,AO27)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK27,AM27,AN27)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY27*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB26+1","v":25},24,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD27,BI27)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE27,BG27,BH27)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS27*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,25,24,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX27,CC27)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY27,CA27,CB27)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL27*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A26=\"\",\"\",'Ashburton EAC'!A26)","v":""},{"$f":"IFERROR(VLOOKUP(A28,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A28,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A28,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A28,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},26,25,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H28,L28)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I28,J28,K28)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U28*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,26,25,0,0,0,0,0,0,null,26,25,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ28,AO28)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK28,AM28,AN28)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY28*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB27+1","v":26},25,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD28,BI28)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE28,BG28,BH28)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS28*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,26,25,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX28,CC28)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY28,CA28,CB28)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL28*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A27=\"\",\"\",'Ashburton EAC'!A27)","v":""},{"$f":"IFERROR(VLOOKUP(A29,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A29,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A29,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A29,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},27,26,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H29,L29)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I29,J29,K29)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U29*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,27,26,0,0,0,0,0,0,null,27,26,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ29,AO29)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK29,AM29,AN29)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY29*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB28+1","v":27},26,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD29,BI29)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE29,BG29,BH29)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS29*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,27,26,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX29,CC29)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY29,CA29,CB29)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL29*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A28=\"\",\"\",'Ashburton EAC'!A28)","v":""},{"$f":"IFERROR(VLOOKUP(A30,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A30,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A30,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A30,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},28,27,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H30,L30)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I30,J30,K30)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U30*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,28,27,0,0,0,0,0,0,null,28,27,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ30,AO30)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK30,AM30,AN30)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY30*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB29+1","v":28},27,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD30,BI30)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE30,BG30,BH30)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS30*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,28,27,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX30,CC30)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY30,CA30,CB30)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL30*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A29=\"\",\"\",'Ashburton EAC'!A29)","v":""},{"$f":"IFERROR(VLOOKUP(A31,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A31,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A31,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A31,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},29,28,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H31,L31)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I31,J31,K31)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U31*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,29,28,0,0,0,0,0,0,null,29,28,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ31,AO31)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK31,AM31,AN31)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY31*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB30+1","v":29},28,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD31,BI31)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE31,BG31,BH31)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS31*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,29,28,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX31,CC31)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY31,CA31,CB31)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL31*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A30=\"\",\"\",'Ashburton EAC'!A30)","v":""},{"$f":"IFERROR(VLOOKUP(A32,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A32,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A32,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A32,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},30,29,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H32,L32)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I32,J32,K32)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U32*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,30,29,0,0,0,0,0,0,null,30,29,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ32,AO32)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK32,AM32,AN32)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY32*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB31+1","v":30},29,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD32,BI32)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE32,BG32,BH32)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS32*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,30,29,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX32,CC32)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY32,CA32,CB32)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL32*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A31=\"\",\"\",'Ashburton EAC'!A31)","v":""},{"$f":"IFERROR(VLOOKUP(A33,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A33,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A33,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A33,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},31,30,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H33,L33)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I33,J33,K33)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U33*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,31,30,0,0,0,0,0,0,null,31,30,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ33,AO33)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK33,AM33,AN33)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY33*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB32+1","v":31},30,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD33,BI33)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE33,BG33,BH33)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS33*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,31,30,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX33,CC33)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY33,CA33,CB33)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL33*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A32=\"\",\"\",'Ashburton EAC'!A32)","v":""},{"$f":"IFERROR(VLOOKUP(A34,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A34,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A34,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A34,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},32,31,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H34,L34)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I34,J34,K34)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U34*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,32,31,0,0,0,0,0,0,null,32,31,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ34,AO34)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK34,AM34,AN34)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY34*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB33+1","v":32},31,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD34,BI34)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE34,BG34,BH34)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS34*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,32,31,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX34,CC34)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY34,CA34,CB34)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL34*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[{"$f":"IF('Ashburton EAC'!A33=\"\",\"\",'Ashburton EAC'!A33)","v":""},{"$f":"IFERROR(VLOOKUP(A35,'Allocation Detail'!$A$3:$E$12,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A35,'Ashburton EAC'!$A$23:$E$33,5,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A35,'Ashburton EAC'!$A$23:$F$33,6,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(A35,'Allocation Detail'!$A$3:$H$12,8),0)","v":0},33,32,0,0,{"$f":"IF(G35/$D$16-INT(G35/$D$16)=0,ROUND($D$19*$D$20*((1+$D$17)^INT(G35/12)),2),0)","v":0},0,{"$f":"ROUND(H35*((1+$B$45)^(1/12)-1),2)","v":0},{"$f":"IFERROR(ROUND(-SUM(H35,L35)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I35,J35,K35)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U35*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((G35/$D$41)-INT(G35/$D$41)=0,$D$39*((1+$D$42)^INT(G35/12)),0)),-S35))","v":0},0,{"$error":"#DIV/0!"},null,33,32,0,{"$f":"IF(G35/$D$16-INT(G35/$D$16)=0,ROUND($D$14*((1+$D$17)^INT(G35/12)),2),0)","v":0},0,{"$f":"MAX(-IF($D$41=\"\",0,IF((Z35/$D$41)-INT(Z35/$D$41)=0,$D$39*((1+$D$42)^INT(Z35/12)),0)),-SUM(AA35,AB35,AC35))","v":0},0,0,null,33,32,0,0,{"$f":"SUM(AJ35:AK35)","v":0},{"$f":"IF(AI35/$D$16-INT(AI35/$D$16)=0,ROUND($D$14*$D$20*((1+$D$17)^INT(AI35/12)),2),0)","v":0},0,{"$f":"ROUND(AJ35*BA$2,2)","v":0},{"$f":"SUM(AO35:AO35)","v":0},{"$f":"IFERROR(ROUND(-SUM(AJ35,AO35)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK35,AM35,AN35)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY35*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((AI35/$D$41)-INT(AI35/$D$41)=0,$D$39*((1+$D$42)^INT(AI35/12)),0)),-AW35))","v":0},0,null,{"$f":"BB34+1","v":33},32,0,0,{"$f":"SUM(BD35:BE35)","v":0},{"$f":"IF(BC35/$D$16-INT(BC35/$D$16)=0,ROUND($D$14*$D$20*((1+$D$17)^INT(BC35/12)),2),0)","v":0},0,0,{"$f":"SUM(BI35:BI35)","v":0},{"$f":"IFERROR(ROUND(-SUM(BD35,BI35)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE35,BG35,BH35)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS35*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((BC35/$D$41)-INT(BC35/$D$41)=0,$D$39*((1+$D$42)^INT(BC35/12)),0)),-BQ35))","v":0},{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),BQ35+BP35,MAX(BP35+BQ35+BS35,0))","v":0},null,33,32,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX35,CC35)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY35,CA35,CB35)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL35*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,{"$f":"SUMPRODUCT(B25:B35,C25:C35)","v":0},{"$f":"SUM(C25:C35)","v":0},{"$f":"SUM(D25:D35)","v":0},null,34,33,{"$f":"ROUND(SUM(H35,L35,M35,O35,T35),2)","v":0},{"$f":"SUM(I35,J35,K35,N35,P35)","v":0},0,{"$f":"ROUND((J36+I36)*((1+$B$45)^(1/12)-1),2)","v":0},0,{"$f":"IFERROR(ROUND(-SUM(H36,L36)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I36,J36,K36)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U36*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),S36+R36,MAX(R35+S36+U36,0))","v":0},{"$error":"#DIV/0!"},null,34,33,0,0,0,0,0,0,null,34,33,{"$f":"ROUND(SUM(AJ35,AO35,AQ35,AS35,AX35),2)","v":0},{"$f":"SUM(AK35,AM35,AN35,AR35,AT35)","v":0},0,0,{"$f":"ROUND((AM36+AK36)*BA$2,2)","v":0},0,0,{"$f":"IFERROR(ROUND(-SUM(AJ36,AO36)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK36,AM36,AN36)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY36*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),AW36+AV36,MAX(AV35+AW36+AY36,0))","v":0},null,{"$f":"BB35+1","v":34},33,{"$f":"ROUND(SUM(BD35,BI35,BK35,BM35,BR35),2)","v":0},{"$f":"SUM(BE35,BG35,BH35,BL35,BN35)","v":0},0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD36,BI36)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE36,BG36,BH36)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS36*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,34,33,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX36,CC36)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY36,CA36,CB36)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL36*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,35,34,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H37,L37)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I37,J37,K37)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U37*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,{"$f":"Y36+1","v":35},34,0,0,0,0,0,0,null,{"$f":"AH36+1","v":35},34,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ37,AO37)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK37,AM37,AN37)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY37*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB36+1","v":35},34,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD37,BI37)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE37,BG37,BH37)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS37*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BV36+1","v":35},34,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX37,CC37)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY37,CA37,CB37)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL37*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Regular Disinvestment",null,null,null,null,36,35,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H38,L38)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I38,J38,K38)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U38*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,36,35,0,0,0,0,0,0,null,36,35,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ38,AO38)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK38,AM38,AN38)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY38*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB37+1","v":36},35,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD38,BI38)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE38,BG38,BH38)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS38*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,36,35,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BX38,CC38)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BY38,CA38,CB38)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(CL38*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Income Amount per Frequency",null,null,{"$f":"IF(OR('Ashburton EAC'!E18=\"\",'Ashburton EAC'!E18=0),\"\",'Ashburton EAC'!E18)","v":""},null,37,36,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H39,L39)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I39,J39,K39)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U39*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,37,36,0,0,0,0,0,0,null,37,36,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ39,AO39)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK39,AM39,AN39)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY39*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB38+1","v":37},36,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD39,BI39)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE39,BG39,BH39)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS39*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Income Frequency",null,null,{"$f":"'Ashburton EAC'!E19","v":"Select:"},null,38,37,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H40,L40)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I40,J40,K40)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U40*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,38,37,0,0,0,0,0,0,null,38,37,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ40,AO40)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK40,AM40,AN40)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY40*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB39+1","v":38},37,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD40,BI40)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE40,BG40,BH40)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS40*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 YEARS",{"$f":"ROUND(CM38,0)","v":0}]
["Frequency multiple",null,null,{"$f":"IF(D40=\"Monthly\",1,IF(D40=\"Quarterly\",3,IF(D40=\"Half-yearly\",6,IF(D40=\"Annually\",12,\"\"))))","v":""},null,39,38,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H41,L41)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I41,J41,K41)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U41*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,39,38,0,0,0,0,0,0,null,39,38,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ41,AO41)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK41,AM41,AN41)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY41*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB40+1","v":39},38,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD41,BI41)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE41,BG41,BH41)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS41*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(V38,0)","v":0}]
["Income escalation",null,null,{"$f":"'Ashburton EAC'!E20","v":0},null,40,39,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H42,L42)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I42,J42,K42)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U42*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,40,39,0,0,0,0,0,0,null,40,39,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ42,AO42)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK42,AM42,AN42)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY42*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB41+1","v":40},39,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD42,BI42)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE42,BG42,BH42)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS42*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CM41-CM40","v":0}]
[null,null,null,null,null,41,40,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H43,L43)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I43,J43,K43)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U43*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,41,40,0,0,0,0,0,0,null,41,40,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ43,AO43)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK43,AM43,AN43)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY43*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB42+1","v":41},40,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD43,BI43)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE43,BG43,BH43)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS43*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Reduction in Yield","All Fees",null,null,null,42,41,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H44,L44)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I44,J44,K44)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U44*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,42,41,0,0,0,0,0,0,null,42,41,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ44,AO44)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK44,AM44,AN44)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY44*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB43+1","v":42},41,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD44,BI44)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE44,BG44,BH44)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS44*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Assumed Gross Return p.a.",0.06,{"$f":"(1+B45)^(1/12)-1","v":4.8675505653430484E-3},null,null,43,42,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H45,L45)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I45,J45,K45)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U45*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,43,42,0,0,0,0,0,0,null,43,42,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ45,AO45)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK45,AM45,AN45)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY45*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB44+1","v":43},42,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD45,BI45)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE45,BG45,BH45)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS45*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Return after all charges p.a.",{"$f":"(1+AF2)^12-1","v":3.9905032371594373E-2},null,null,null,44,43,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H46,L46)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I46,J46,K46)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U46*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,44,43,0,0,0,0,0,0,null,44,43,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ46,AO46)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK46,AM46,AN46)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY46*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB45+1","v":44},43,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD46,BI46)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE46,BG46,BH46)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS46*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Reduction in Yield p.a.",{"$f":"B45-B46","v":2.0094967628405624E-2},"Sanity check:",{"$f":"SUM(E50:E52)-B47","v":-1.2033629253046074E-2},null,45,44,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H47,L47)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I47,J47,K47)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U47*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,45,44,0,0,0,0,0,0,null,45,44,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ47,AO47)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK47,AM47,AN47)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY47*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB46+1","v":45},44,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD47,BI47)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE47,BG47,BH47)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS47*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,{"$f":"DH2","v":2.9198560510362973E-3},null,null,null,46,45,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H48,L48)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I48,J48,K48)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U48*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,46,45,0,0,0,0,0,0,null,46,45,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ48,AO48)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK48,AM48,AN48)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY48*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB47+1","v":46},45,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD48,BI48)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE48,BG48,BH48)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS48*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,"1 Year","3 Years","5 Years","10 Years",47,46,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H49,L49)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I49,J49,K49)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U49*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,47,46,0,0,0,0,0,0,null,47,46,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ49,AO49)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK49,AM49,AN49)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY49*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB48+1","v":47},46,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD49,BI49)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE49,BG49,BH49)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS49*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Investment Management Charge",{"$f":"'Allocation Detail'!$E$13","v":0},{"$f":"'Allocation Detail'!$E$13","v":0},{"$f":"'Allocation Detail'!$E$13","v":0},{"$f":"'Allocation Detail'!$E$13","v":0},48,47,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H50,L50)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I50,J50,K50)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U50*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,48,47,0,0,0,0,0,0,null,48,47,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ50,AO50)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK50,AM50,AN50)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY50*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB49+1","v":48},47,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD50,BI50)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE50,BG50,BH50)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS50*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Advice Charge",{"$f":"B45-((1+DH2)^12-1)","v":2.4393527772731127E-2},{"$f":"B45-((1+CN2)^12-1)","v":1.2332107389713076E-2},{"$f":"B45-((1+BU2)^12-1)","v":9.8985791735172746E-3},{"$f":"B45-((1+BA2)^12-1)","v":8.0613383753595502E-3},49,48,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H51,L51)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I51,J51,K51)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U51*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,49,48,0,0,0,0,0,0,null,49,48,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ51,AO51)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK51,AM51,AN51)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY51*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB50+1","v":49},48,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD51,BI51)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE51,BG51,BH51)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS51*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Administration Charge",0,0,0,0,50,49,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H52,L52)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I52,J52,K52)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U52*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,50,49,0,0,0,0,0,0,null,50,49,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ52,AO52)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK52,AM52,AN52)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY52*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB51+1","v":50},49,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD52,BI52)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE52,BG52,BH52)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS52*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,51,50,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H53,L53)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I53,J53,K53)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U53*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,{"$f":"Y52+1","v":51},50,0,0,0,0,0,0,null,{"$f":"AH52+1","v":51},50,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ53,AO53)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK53,AM53,AN53)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY53*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB52+1","v":51},50,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD53,BI53)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE53,BG53,BH53)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS53*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Investment Management Charge",{"$f":"W127","v":0},{"$f":"W126","v":0},{"$f":"W125","v":0},{"$f":"W124","v":0},52,51,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H54,L54)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I54,J54,K54)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U54*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,52,51,0,0,0,0,0,0,null,52,51,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ54,AO54)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK54,AM54,AN54)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY54*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB53+1","v":52},51,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD54,BI54)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE54,BG54,BH54)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS54*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Advice Charge",{"$f":"X127","v":0},{"$f":"X126","v":0},{"$f":"X125","v":0},{"$f":"X124","v":0},53,52,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H55,L55)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I55,J55,K55)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U55*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,53,52,0,0,0,0,0,0,null,53,52,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ55,AO55)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK55,AM55,AN55)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY55*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB54+1","v":53},52,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD55,BI55)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE55,BG55,BH55)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS55*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["Administration Charge",{"$f":"Y127","v":0},{"$f":"Y126","v":0},{"$f":"Y125","v":0},{"$f":"Y124","v":0},54,53,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H56,L56)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I56,J56,K56)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U56*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,54,53,0,0,0,0,0,0,null,54,53,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ56,AO56)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK56,AM56,AN56)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY56*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB55+1","v":54},53,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD56,BI56)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE56,BG56,BH56)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS56*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
["All fees result",{"$f":"V127","v":0},{"$f":"V126","v":0},{"$f":"V125","v":0},{"$f":"V124","v":0},55,54,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H57,L57)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I57,J57,K57)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U57*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,55,54,0,0,0,0,0,0,null,55,54,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ57,AO57)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK57,AM57,AN57)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY57*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB56+1","v":55},54,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD57,BI57)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE57,BG57,BH57)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS57*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,56,55,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H58,L58)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I58,J58,K58)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U58*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,56,55,0,0,0,0,0,0,null,56,55,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ58,AO58)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK58,AM58,AN58)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY58*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB57+1","v":56},55,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD58,BI58)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE58,BG58,BH58)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS58*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,57,56,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H59,L59)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I59,J59,K59)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U59*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,57,56,0,0,0,0,0,0,null,57,56,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ59,AO59)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK59,AM59,AN59)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY59*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB58+1","v":57},56,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD59,BI59)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE59,BG59,BH59)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS59*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,58,57,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H60,L60)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I60,J60,K60)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U60*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,58,57,0,0,0,0,0,0,null,58,57,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ60,AO60)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK60,AM60,AN60)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY60*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB59+1","v":58},57,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD60,BI60)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE60,BG60,BH60)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS60*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,59,58,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H61,L61)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I61,J61,K61)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U61*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,59,58,0,0,0,0,0,0,null,59,58,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ61,AO61)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK61,AM61,AN61)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY61*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB60+1","v":59},58,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD61,BI61)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE61,BG61,BH61)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS61*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,60,59,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H62,L62)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I62,J62,K62)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U62*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,60,59,0,0,0,0,0,0,null,60,59,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ62,AO62)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK62,AM62,AN62)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY62*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,{"$f":"BB61+1","v":60},59,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(BD62,BI62)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(BE62,BG62,BH62)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(BS62*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,61,60,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H63,L63)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I63,J63,K63)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U63*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,61,60,0,0,0,0,0,0,null,61,60,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ63,AO63)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK63,AM63,AN63)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY63*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,62,61,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H64,L64)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I64,J64,K64)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U64*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,62,61,0,0,0,0,0,0,null,62,61,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ64,AO64)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK64,AM64,AN64)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY64*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 year",{"$f":"ROUND(BT62,0)","v":0}]
[null,null,null,null,null,63,62,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H65,L65)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I65,J65,K65)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U65*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,63,62,0,0,0,0,0,0,null,63,62,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ65,AO65)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK65,AM65,AN65)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY65*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($V$62,0)","v":0}]
[null,null,null,null,null,64,63,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H66,L66)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I66,J66,K66)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U66*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,64,63,0,0,0,0,0,0,null,64,63,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ66,AO66)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK66,AM66,AN66)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY66*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BT64-BT65","v":0}]
[null,null,null,null,null,65,64,0,0,{"$f":"IF(G67/$D$16-INT(G67/$D$16)=0,ROUND($D$19*$D$20*((1+$D$17)^INT(G67/12)),2),0)","v":0},0,{"$f":"ROUND(H67*((1+$B$45)^(1/12)-1),2)","v":0},{"$f":"IFERROR(ROUND(-SUM(H67,L67)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I67,J67,K67)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U67*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((G67/$D$41)-INT(G67/$D$41)=0,$D$39*((1+$D$42)^INT(G67/12)),0)),-S67))","v":0},0,{"$error":"#DIV/0!"},null,65,64,0,{"$f":"IF(G67/$D$16-INT(G67/$D$16)=0,ROUND($D$14*((1+$D$17)^INT(G67/12)),2),0)","v":0},0,{"$f":"MAX(-IF($D$41=\"\",0,IF((Z67/$D$41)-INT(Z67/$D$41)=0,$D$39*((1+$D$42)^INT(Z67/12)),0)),-SUM(AA67,AB67,AC67))","v":0},0,0,null,65,64,0,0,{"$f":"SUM(AJ67:AK67)","v":0},{"$f":"IF(AI67/$D$16-INT(AI67/$D$16)=0,ROUND($D$14*$D$20*((1+$D$17)^INT(AI67/12)),2),0)","v":0},0,{"$f":"ROUND(AJ67*BA$2,2)","v":0},{"$f":"SUM(AO67:AO67)","v":0},{"$f":"IFERROR(ROUND(-SUM(AJ67,AO67)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK67,AM67,AN67)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY67*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((AI67/$D$41)-INT(AI67/$D$41)=0,$D$39*((1+$D$42)^INT(AI67/12)),0)),-AW67))","v":0},0]
[null,null,null,null,null,66,65,{"$f":"ROUND(SUM(H67,L67,M67,O67,T67),2)","v":0},{"$f":"SUM(I67,J67,K67,N67,P67)","v":0},0,{"$f":"ROUND((J68+I68)*((1+$B$45)^(1/12)-1),2)","v":0},0,{"$f":"IFERROR(ROUND(-SUM(H68,L68)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I68,J68,K68)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,{"$f":"SUM(I68,J68,K68,N68,P68)","v":0},{"$f":"SUM(H68,L68,M68,O68)","v":0},{"$f":"IFERROR(U68*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),S68+R68,MAX(R67+S68+U68,0))","v":0},{"$f":"SUM(M68:N68,Q68)/(S68)*-12","v":{"$error":"#DIV/0!"}},null,66,65,0,0,{"$f":"(AA68+AB68)*$AF$2","v":0},0,{"$f":"MAX(SUM(AA68:AD68),0)","v":0},{"$f":"IF(AE68=0,AA68,0)","v":0},null,66,65,{"$f":"ROUND(SUM(AJ67,AO67,AQ67,AS67,AX67),2)","v":0},{"$f":"SUM(AK67,AM67,AN67,AR67,AT67)","v":0},0,0,{"$f":"ROUND((AM68+AK68)*BA$2,2)","v":0},0,0,{"$f":"IFERROR(ROUND(-SUM(AJ68,AO68)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK68,AM68,AN68)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,{"$f":"SUM(AK68,AM68,AN68,AR68,AT68)","v":0},{"$f":"SUM(AJ68,AO68,AQ68,AS68)","v":0},{"$f":"IFERROR(AY68*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),AW68+AV68,MAX(AV67+AW68+AY68,0))","v":0}]
[null,null,null,null,null,{"$f":"F68+1","v":67},{"$f":"G68+1","v":66},0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H69,L69)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I69,J69,K69)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"ROUND(-(H69+L69)*$B$11/12*1.15,2)","v":0},{"$f":"ROUND(-(I69+J69+K69)*$B$11/12*1.15,2)","v":0},{"$f":"-SUM(H69:I69,L69:L69)*$B$11/12*1.15","v":0},0,0,{"$f":"IFERROR(U69*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,{"$f":"Y68+1","v":67},66,{"$f":"AE68","v":0},0,0,0,0,0,null,{"$f":"AH68+1","v":67},66,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ69,AO69)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK69,AM69,AN69)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY69*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,68,67,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H70,L70)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I70,J70,K70)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U70*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,68,67,0,0,0,0,0,0,null,68,67,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ70,AO70)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK70,AM70,AN70)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY70*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,69,68,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H71,L71)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I71,J71,K71)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U71*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,69,68,0,0,0,0,0,0,null,69,68,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ71,AO71)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK71,AM71,AN71)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY71*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,70,69,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H72,L72)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I72,J72,K72)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U72*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,70,69,0,0,0,0,0,0,null,70,69,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ72,AO72)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK72,AM72,AN72)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY72*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,71,70,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H73,L73)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I73,J73,K73)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U73*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,71,70,0,0,0,0,0,0,null,71,70,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ73,AO73)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK73,AM73,AN73)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY73*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,72,71,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H74,L74)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I74,J74,K74)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U74*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,72,71,0,0,0,0,0,0,null,72,71,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ74,AO74)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK74,AM74,AN74)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY74*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,73,72,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H75,L75)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I75,J75,K75)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U75*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,73,72,0,0,0,0,0,0,null,73,72,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ75,AO75)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK75,AM75,AN75)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY75*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,74,73,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H76,L76)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I76,J76,K76)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U76*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,74,73,0,0,0,0,0,0,null,74,73,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ76,AO76)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK76,AM76,AN76)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY76*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,75,74,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H77,L77)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I77,J77,K77)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U77*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,75,74,0,0,0,0,0,0,null,75,74,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ77,AO77)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK77,AM77,AN77)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY77*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,76,75,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H78,L78)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I78,J78,K78)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U78*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,76,75,0,0,0,0,0,0,null,76,75,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ78,AO78)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK78,AM78,AN78)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY78*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,77,76,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H79,L79)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I79,J79,K79)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U79*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,77,76,0,0,0,0,0,0,null,77,76,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ79,AO79)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK79,AM79,AN79)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY79*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,78,77,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H80,L80)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I80,J80,K80)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U80*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,78,77,0,0,0,0,0,0,null,78,77,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ80,AO80)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK80,AM80,AN80)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY80*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,79,78,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H81,L81)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I81,J81,K81)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U81*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,79,78,0,0,0,0,0,0,null,79,78,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ81,AO81)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK81,AM81,AN81)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY81*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,80,79,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H82,L82)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I82,J82,K82)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U82*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,80,79,0,0,0,0,0,0,null,80,79,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ82,AO82)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK82,AM82,AN82)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY82*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,81,80,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H83,L83)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I83,J83,K83)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U83*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,81,80,0,0,0,0,0,0,null,81,80,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ83,AO83)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK83,AM83,AN83)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY83*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,82,81,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H84,L84)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I84,J84,K84)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U84*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,82,81,0,0,0,0,0,0,null,82,81,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ84,AO84)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK84,AM84,AN84)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY84*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,83,82,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H85,L85)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I85,J85,K85)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U85*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,{"$f":"Y84+1","v":83},82,0,0,0,0,0,0,null,{"$f":"AH84+1","v":83},82,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ85,AO85)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK85,AM85,AN85)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY85*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,84,83,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H86,L86)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I86,J86,K86)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U86*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,84,83,0,0,0,0,0,0,null,84,83,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ86,AO86)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK86,AM86,AN86)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY86*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,85,84,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H87,L87)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I87,J87,K87)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U87*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,85,84,0,0,0,0,0,0,null,85,84,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ87,AO87)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK87,AM87,AN87)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY87*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,86,85,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H88,L88)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I88,J88,K88)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U88*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,86,85,0,0,0,0,0,0,null,86,85,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ88,AO88)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK88,AM88,AN88)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY88*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,87,86,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H89,L89)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I89,J89,K89)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U89*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,87,86,0,0,0,0,0,0,null,87,86,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ89,AO89)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK89,AM89,AN89)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY89*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,88,87,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H90,L90)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I90,J90,K90)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U90*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,88,87,0,0,0,0,0,0,null,88,87,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ90,AO90)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK90,AM90,AN90)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY90*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,89,88,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H91,L91)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I91,J91,K91)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U91*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,89,88,0,0,0,0,0,0,null,89,88,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ91,AO91)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK91,AM91,AN91)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY91*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,90,89,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H92,L92)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I92,J92,K92)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U92*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,90,89,0,0,0,0,0,0,null,90,89,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ92,AO92)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK92,AM92,AN92)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY92*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,91,90,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H93,L93)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I93,J93,K93)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U93*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,91,90,0,0,0,0,0,0,null,91,90,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ93,AO93)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK93,AM93,AN93)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY93*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,92,91,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H94,L94)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I94,J94,K94)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U94*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,92,91,0,0,0,0,0,0,null,92,91,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ94,AO94)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK94,AM94,AN94)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY94*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,93,92,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H95,L95)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I95,J95,K95)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U95*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,93,92,0,0,0,0,0,0,null,93,92,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ95,AO95)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK95,AM95,AN95)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY95*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,94,93,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H96,L96)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I96,J96,K96)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U96*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,94,93,0,0,0,0,0,0,null,94,93,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ96,AO96)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK96,AM96,AN96)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY96*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,95,94,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H97,L97)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I97,J97,K97)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U97*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,95,94,0,0,0,0,0,0,null,95,94,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ97,AO97)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK97,AM97,AN97)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY97*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,96,95,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H98,L98)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I98,J98,K98)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U98*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,96,95,0,0,0,0,0,0,null,96,95,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ98,AO98)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK98,AM98,AN98)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY98*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,97,96,0,0,{"$f":"IF(G99/$D$16-INT(G99/$D$16)=0,ROUND($D$19*$D$20*((1+$D$17)^INT(G99/12)),2),0)","v":0},0,{"$f":"ROUND(H99*((1+$B$45)^(1/12)-1),2)","v":0},{"$f":"IFERROR(ROUND(-SUM(H99,L99)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I99,J99,K99)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U99*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((G99/$D$41)-INT(G99/$D$41)=0,$D$39*((1+$D$42)^INT(G99/12)),0)),-S99))","v":0},0,{"$error":"#DIV/0!"},null,97,96,0,{"$f":"IF(G99/$D$16-INT(G99/$D$16)=0,ROUND($D$14*((1+$D$17)^INT(G99/12)),2),0)","v":0},0,{"$f":"MAX(-IF($D$41=\"\",0,IF((Z99/$D$41)-INT(Z99/$D$41)=0,$D$39*((1+$D$42)^INT(Z99/12)),0)),-SUM(AA99,AB99,AC99))","v":0},0,0,null,97,96,0,0,{"$f":"SUM(AJ99:AK99)","v":0},{"$f":"IF(AI99/$D$16-INT(AI99/$D$16)=0,ROUND($D$14*$D$20*((1+$D$17)^INT(AI99/12)),2),0)","v":0},0,{"$f":"ROUND(AJ99*BA$2,2)","v":0},{"$f":"SUM(AO99:AO99)","v":0},{"$f":"IFERROR(ROUND(-SUM(AJ99,AO99)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK99,AM99,AN99)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY99*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},{"$f":"IF($D$39=\"\",0,MAX(-IF($D$41=\"\",0,IF((AI99/$D$41)-INT(AI99/$D$41)=0,$D$39*((1+$D$42)^INT(AI99/12)),0)),-AW99))","v":0},0]
[null,null,null,null,null,98,97,{"$f":"ROUND(SUM(H99,L99,M99,O99,T99),2)","v":0},{"$f":"SUM(I99,J99,K99,N99,P99)","v":0},0,{"$f":"ROUND((J100+I100)*((1+$B$45)^(1/12)-1),2)","v":0},0,{"$f":"IFERROR(ROUND(-SUM(H100,L100)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I100,J100,K100)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U100*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),S100+R100,MAX(R99+S100+U100,0))","v":0},{"$error":"#DIV/0!"},null,98,97,0,0,0,0,0,0,null,98,97,{"$f":"ROUND(SUM(AJ99,AO99,AQ99,AS99,AX99),2)","v":0},{"$f":"SUM(AK99,AM99,AN99,AR99,AT99)","v":0},0,0,{"$f":"ROUND((AM100+AK100)*BA$2,2)","v":0},0,0,{"$f":"IFERROR(ROUND(-SUM(AJ100,AO100)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK100,AM100,AN100)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY100*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,{"$f":"IF(OR($D$8=0,$D$39=0,$D$8=\"\",$D$39=\"\"),AW100+AV100,MAX(AV99+AW100+AY100,0))","v":0}]
[null,null,null,null,null,99,98,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H101,L101)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I101,J101,K101)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U101*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,{"$f":"Y100+1","v":99},98,0,0,0,0,0,0,null,{"$f":"AH100+1","v":99},98,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ101,AO101)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK101,AM101,AN101)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY101*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,100,99,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H102,L102)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I102,J102,K102)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U102*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,100,99,0,0,0,0,0,0,null,100,99,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ102,AO102)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK102,AM102,AN102)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY102*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,101,100,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H103,L103)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I103,J103,K103)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U103*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,101,100,0,0,0,0,0,0,null,101,100,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ103,AO103)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK103,AM103,AN103)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY103*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,102,101,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H104,L104)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I104,J104,K104)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U104*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,102,101,0,0,0,0,0,0,null,102,101,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ104,AO104)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK104,AM104,AN104)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY104*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,103,102,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H105,L105)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I105,J105,K105)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U105*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,103,102,0,0,0,0,0,0,null,103,102,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ105,AO105)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK105,AM105,AN105)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY105*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,104,103,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H106,L106)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I106,J106,K106)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U106*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,104,103,0,0,0,0,0,0,null,104,103,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ106,AO106)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK106,AM106,AN106)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY106*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,105,104,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H107,L107)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I107,J107,K107)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U107*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,105,104,0,0,0,0,0,0,null,105,104,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ107,AO107)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK107,AM107,AN107)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY107*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,106,105,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H108,L108)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I108,J108,K108)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U108*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,106,105,0,0,0,0,0,0,null,106,105,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ108,AO108)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK108,AM108,AN108)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY108*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,107,106,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H109,L109)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I109,J109,K109)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U109*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,107,106,0,0,0,0,0,0,null,107,106,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ109,AO109)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK109,AM109,AN109)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY109*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,108,107,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H110,L110)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I110,J110,K110)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U110*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,108,107,0,0,0,0,0,0,null,108,107,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ110,AO110)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK110,AM110,AN110)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY110*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,109,108,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H111,L111)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I111,J111,K111)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U111*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,109,108,0,0,0,0,0,0,null,109,108,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ111,AO111)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK111,AM111,AN111)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY111*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,110,109,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H112,L112)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I112,J112,K112)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U112*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,110,109,0,0,0,0,0,0,null,110,109,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ112,AO112)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK112,AM112,AN112)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY112*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,111,110,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H113,L113)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I113,J113,K113)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U113*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,111,110,0,0,0,0,0,0,null,111,110,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ113,AO113)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK113,AM113,AN113)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY113*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,112,111,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H114,L114)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I114,J114,K114)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U114*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,112,111,0,0,0,0,0,0,null,112,111,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ114,AO114)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK114,AM114,AN114)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY114*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,113,112,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H115,L115)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I115,J115,K115)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U115*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,113,112,0,0,0,0,0,0,null,113,112,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ115,AO115)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK115,AM115,AN115)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY115*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,114,113,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H116,L116)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I116,J116,K116)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U116*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,114,113,0,0,0,0,0,0,null,114,113,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ116,AO116)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK116,AM116,AN116)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY116*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,115,114,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H117,L117)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I117,J117,K117)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U117*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,{"$f":"Y116+1","v":115},114,0,0,0,0,0,0,null,{"$f":"AH116+1","v":115},114,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ117,AO117)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK117,AM117,AN117)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY117*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,116,115,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H118,L118)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I118,J118,K118)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U118*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,116,115,0,0,0,0,0,0,null,116,115,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ118,AO118)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK118,AM118,AN118)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY118*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,117,116,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H119,L119)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I119,J119,K119)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U119*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,117,116,0,0,0,0,0,0,null,117,116,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ119,AO119)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK119,AM119,AN119)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY119*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,118,117,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H120,L120)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I120,J120,K120)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U120*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,118,117,0,0,0,0,0,0,null,118,117,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ120,AO120)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK120,AM120,AN120)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY120*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,119,118,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H121,L121)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I121,J121,K121)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U121*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,119,118,0,0,0,0,0,0,null,119,118,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ121,AO121)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK121,AM121,AN121)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY121*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,120,119,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(H122,L122)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(I122,J122,K122)*'Allocation Detail'!$E$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(U122*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0,{"$error":"#DIV/0!"},null,120,119,0,0,0,0,0,0,null,120,119,0,0,0,0,0,0,0,{"$f":"IFERROR(ROUND(-SUM(AJ122,AO122)*'Allocation Detail'!$E$13/12,2),0)","v":0},{"$f":"IFERROR(ROUND(-SUM(AK122,AM122,AN122)*'Allocation Detail'!$H$13/12,2),0)","v":0},0,0,0,0,0,{"$f":"IFERROR(AY122*('Allocation Detail'!#REF!/'Allocation Detail'!#REF!),0)","v":0},0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H122)","v":0},{"$f":"SUM(I3:I122)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,"IMC","AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 Years",{"$f":"ROUND(V122,0)","v":0},0,{"$f":"AZ124","v":0},null,null,null,null,null,"10 Years",{"$f":"AE122","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10 Years",{"$f":"ROUND(AZ122,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 years",{"$f":"ROUND(V62,0)","v":0},0,{"$f":"AZ62","v":0},null,null,null,null,null,"5 years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(V122,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 Years",{"$f":"ROUND(V38,0)","v":0},0,{"$f":"AZ38","v":0},null,null,null,null,null,"3 Years",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ124-AZ125","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 Year",{"$f":"ROUND(V14,0)","v":0},0,{"$f":"AZ14","v":0},null,null,null,null,null,"1 Year"]

{"sheet":"Lists","index":2,"n_rows":122,"n_cols":6,"rows_kept":122,"cut":false,"hidden":true,"merged":[[10,2,10,4]]}
["Product name",null,null,null,"Dropdown"]
["Select:",null,null,null,"Select:"]
["Ashburton Ashmore","Ashburton Fund Managers",null,null,{"$f":"IF(HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F3,FALSE)=0,\"\",HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F3,FALSE))","v":"N/A"},2]
["Ashburton Investment Account","N/A",null,null,{"$f":"IF(HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F4,FALSE)=0,\"\",HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F4,FALSE))","v":""},{"$f":"F3+1","v":3}]
["Ashburton Tax Free Savings Account",null,null,null,{"$f":"IF(HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F5,FALSE)=0,\"\",HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F5,FALSE))","v":""},{"$f":"F4+1","v":4}]
["Ashburton Retirement Annuity",null,null,null,{"$f":"IF(HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F6,FALSE)=0,\"\",HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F6,FALSE))","v":""},5]
[null,null,null,null,{"$f":"IF(HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F7,FALSE)=0,\"\",HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F7,FALSE))","v":""},{"$f":"F6+1","v":6}]
[null,null,null,null,{"$f":"IF(HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F8,FALSE)=0,\"\",HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F8,FALSE))","v":""},{"$f":"F7+1","v":7}]
[null,null,null,null,{"$f":"IF(HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F9,FALSE)=0,\"\",HLOOKUP('Ashburton EAC'!$C$2,Lists!$A$3:$C$10,F9,FALSE))","v":""},{"$f":"F8+1","v":8}]
[]
[null,"Ashburton Fund Managers",{"$f":"A3","v":"Ashburton Ashmore"}]
["Recurring & Income frequency",null,"Ashburton Investment Account","Ashburton Tax Free Savings Account","Ashburton Retirement Annuity"]
["Select:","Ashburton Africa Equity Opportunities Feeder Fund","Ashburton Balanced Fund","Ashburton Balanced Fund","Ashburton Balanced Fund"]
["Monthly","Ashburton Balanced Fund","Ashburton Equity Fund","Ashburton Equity Fund","Ashburton Money Market Fund"]
["Quarterly","Ashburton Defensive Fund","Ashburton Global Flexible Fund","Ashburton Global Flexible Fund","Ashburton SA Income Fund"]
["Half-yearly","Ashburton Enhanced Value SA Tracker Fund","Ashburton Money Market Fund","Ashburton Money Market Fund","Ashburton Stable Fund"]
["Annualy","Ashburton Equity Fund","Ashburton SA Income Fund","Ashburton SA Income Fund","Ashburton Targeted Return Fund"]
[null,"Ashburton Global 1200 SA Tracker Fund","Ashburton Stable Fund","Ashburton Targeted Return Fund"," "]
[null,"Ashburton Global Flexible Fund","Ashburton Targeted Return Fund"," "," "]
["Platform","Ashburton Govi Tracker Fund"," "," "," "]
["Select:","Ashburton Growth Fund"," "," "," "]
["Ashburton Ashmore","Ashburton Low Beta SA Composite Tracker Fund"," "," "," "]
["Ashburton Fund Managers","Ashburton Momentum SA Tracker Fund"," "," "," "]
[null,"Ashburton Money Market Fund"," "," "," "]
[null,"Ashburton Multi Manager Bond Fund"," "," "," "]
["TFSA Limits","Ashburton Multi Manager Equity Fund"," "," "," "]
[36000,"Ashburton Multi Manager Income Fund"," "," "," "]
[{"$f":"A27/12","v":3000},"Ashburton Multi Manager Property Fund"," "," "," "]
[null,"Ashburton Multi Manager Prudential Flexible Fund"," "," "," "]
[null,"Ashburton Property Tracker Fund"," "," "," "]
[null,"Ashburton SA Equity Fund"," "," "," "]
[null,"Ashburton SA Income Fund"," "," "," "]
[null,"Ashburton Stable Fund"," "," "," "]
[null,"Ashburton Targeted Return Fund"," "," "," "]
[null,"Atlantic BCI Enhanced Income Fund"," "," "," "]
[null,"Atlantic BCI Real Income Fund"," "," "," "]
[null,"Atlantic BCI Stable Income Fund"," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "," "," "," "]
[null," "]

{"sheet":"Instruments","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["TFSA","FUND NAME","ASISA Classification","Fund Code","TIC","Performance Fee","Min fee","Max fee"]
["NO","Ashburton  Equity Fund ",null,"ASEA1",1.15E-2]
["Yes","Ashburton SA Income Fund ",null,"ASIB1",7.4749999999999999E-3]
["Yes","Ashburton Targeted Return Fund ",null,"ASTRB4",9.1999999999999998E-3]
["Yes","Ashburton Balanced Fund ",null,"ABFA1",1.15E-2]
["Yes","Ashburton Money Market Fund ",null,"ASMMB1",3.4499999999999999E-3]
["Yes","Ashburton Bond Fund",null,"ASHBA",9.7750000000000007E-3]
["Yes","Ashburton Property Fund ",null,"ATFPA",1.265E-2]
["Yes","Ashburton Diversified Income Fund",null,"ASIFB",6.8999999999999999E-3]
["Yes","Ashburton Stable Income Fund",null,"ASSIFA",5.1749999999999999E-3]
["Yes","Ashburton Global Flexible Fund  ",null,"AGFA1",1.7249999999999998E-2]
["Yes","Ashburton Global Leaders ZAR Equity Feeder Fund",null,"ASGFDA",6.3249999999999999E-3]
[null,"Ashburton GOVI Tracker Fund",null,"ASGTL",3.4499999999999999E-3]

{"sheet":"Allocation Detail","index":4,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,0,0,7]]}
["Ashburton (Internal & Single Managed Models) Unit Trust Allocation"]
["Instrument Name","TIC (Incl VAT)","Lump sum %","Lump sum amt","WAF","Recurring %","Recurring amt","WAF"]
[{"$f":"'Ashburton EAC'!A23","v":0},{"$f":"IFERROR(VLOOKUP(A3,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A3=\"\",\"\",IFERROR(VLOOKUP(A3,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C3*Calculations!$D$10,\"\")","v":0},{"$f":"C3*B3","v":0},{"$f":"IF(A3=\"\",0,IFERROR(VLOOKUP(A3,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F3*Calculations!$D$19,\"\")","v":0},{"$f":"IF(OR(A3=\"\",F3=0),0,B3*(G3/$G$13))","v":0}]
[{"$f":"'Ashburton EAC'!A24","v":0},{"$f":"IFERROR(VLOOKUP(A4,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A4=\"\",\"\",IFERROR(VLOOKUP(A4,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C4*Calculations!$D$10,\"\")","v":0},{"$f":"C4*B4","v":0},{"$f":"IF(A4=\"\",0,IFERROR(VLOOKUP(A4,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F4*Calculations!$D$19,\"\")","v":0},{"$f":"IF(OR(A4=\"\",F4=0),0,B4*(G4/$G$13))","v":0}]
[{"$f":"'Ashburton EAC'!A25","v":0},{"$f":"IFERROR(VLOOKUP(A5,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A5=\"\",\"\",IFERROR(VLOOKUP(A5,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C5*Calculations!$D$10,\"\")","v":0},0,{"$f":"IF(A5=\"\",0,IFERROR(VLOOKUP(A5,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F5*Calculations!$D$19,\"\")","v":0},0]
[{"$f":"'Ashburton EAC'!A26","v":0},{"$f":"IFERROR(VLOOKUP(A6,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A6=\"\",\"\",IFERROR(VLOOKUP(A6,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C6*Calculations!$D$10,\"\")","v":0},0,{"$f":"IF(A6=\"\",0,IFERROR(VLOOKUP(A6,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F6*Calculations!$D$19,\"\")","v":0},0]
[{"$f":"'Ashburton EAC'!A27","v":0},{"$f":"IFERROR(VLOOKUP(A7,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A7=\"\",\"\",IFERROR(VLOOKUP(A7,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C7*Calculations!$D$10,\"\")","v":0},0,{"$f":"IF(A7=\"\",0,IFERROR(VLOOKUP(A7,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F7*Calculations!$D$19,\"\")","v":0},0]
[{"$f":"'Ashburton EAC'!A28","v":0},{"$f":"IFERROR(VLOOKUP(A8,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A8=\"\",\"\",IFERROR(VLOOKUP(A8,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C8*Calculations!$D$10,\"\")","v":0},0,{"$f":"IF(A8=\"\",0,IFERROR(VLOOKUP(A8,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F8*Calculations!$D$19,\"\")","v":0},0]
[{"$f":"'Ashburton EAC'!A29","v":0},{"$f":"IFERROR(VLOOKUP(A9,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A9=\"\",\"\",IFERROR(VLOOKUP(A9,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C9*Calculations!$D$10,\"\")","v":0},0,{"$f":"IF(A9=\"\",0,IFERROR(VLOOKUP(A9,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F9*Calculations!$D$19,\"\")","v":0},0]
[{"$f":"'Ashburton EAC'!A30","v":0},{"$f":"IFERROR(VLOOKUP(A10,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A10=\"\",\"\",IFERROR(VLOOKUP(A10,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C10*Calculations!$D$10,\"\")","v":0},0,{"$f":"IF(A10=\"\",0,IFERROR(VLOOKUP(A10,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F10*Calculations!$D$19,\"\")","v":0},0]
[{"$f":"'Ashburton EAC'!A31","v":0},{"$f":"IFERROR(VLOOKUP(A11,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A11=\"\",\"\",IFERROR(VLOOKUP(A11,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C11*Calculations!$D$10,\"\")","v":0},0,{"$f":"IF(A11=\"\",0,IFERROR(VLOOKUP(A11,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F11*Calculations!$D$19,\"\")","v":0},0]
[{"$f":"'Ashburton EAC'!A32","v":0},{"$f":"IFERROR(VLOOKUP(A12,Instruments!$B$2:$E$13,4,FALSE),0)","v":0},{"$f":"IF(A12=\"\",\"\",IFERROR(VLOOKUP(A12,Calculations!$A$25:$C$35,3,FALSE),0))","v":0},{"$f":"IFERROR(C12*Calculations!$D$10,\"\")","v":0},0,{"$f":"IF(A12=\"\",0,IFERROR(VLOOKUP(A12,Calculations!$A$25:$D$35,4,FALSE),0))","v":0},{"$f":"IFERROR(F12*Calculations!$D$19,\"\")","v":0},0]
[null,null,{"$f":"SUM(C3:C12)","v":0},0,{"$f":"SUM(E3:E12)","v":0},{"$f":"IF(A13=\"\",0,VLOOKUP(A13,'Ashburton EAC'!A33:F43,6,FALSE)*E13)","v":0},0,0]