{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":[" Quote Engine","Income Replaecment Rates","Life and Truama Rates","Data-->","Tax Calculator","Drop Downs"],"not_rendered":{"charts":2,"images":2,"macros":1,"external_links":1,"defined_names":16,"comments":0,"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":" Quote Engine","index":0,"n_rows":43,"n_cols":24,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,6,2,13]]}
[]
[null,null,null,null,null,null,"NZALPA MEMBERS INSURANCES PRICE INDICATOR"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calc only"]
[null,null,null,"Quoting Requirements",null,null,null,"Indicative Quote Summary ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Member Age",null,{"$f":"IF(F16=\"\",\"\",DATEDIF(F16,X9,\"Y\")+1)","v":""}]
[null,null,null,"Income Protection (GDI)",null,"N",null,"Income Protection (GDI)",null,null,null,null,null,"Life and Trauma (GLI & GCI)",null,null,null,null,null,null,null,"Spouse Age",null,{"$f":"IF(F17=\"\",\"\",DATEDIF(F17,X9,\"Y\")+1)","v":""}]
[null,null,null,"Member Life Cover (GLI)",null,"N",null,null,"Illustrative Premium ",null,null,null,null,null,"Illustrative Premium "]
[null,null,null,"Member Trauma Cover (GCI)",null,"N",null,"WD","GDI Annual ","GDI Monthly",null,null,null,"Type","GLI\\GCI Annual","GLI\\GCI Monthly",null,null,null,null,null,"Renewal Date",null,"2026-04-01"]
[null,null,null,"Spouse Life Cover (GLI)",null,"N",null,30,{"$f":"IF($F$7=\"N\",0,(SUMIFS('Income Replaecment Rates'!$D:$D,'Income Replaecment Rates'!$C:$C,$H10,'Income Replaecment Rates'!$B:$B,$X$6)*(($F$24*24))))","v":0},{"$f":"I10/12","v":0},{"$f":"IF(H10=$F$26,I10,0)","v":0},null,null,"Member (Life)",{"$f":"IF(F8=\"N\",0,(SUMIFS('Life and Truama Rates'!B3:B55,'Life and Truama Rates'!$A3:$A55,$X$6)*' Quote Engine'!$F$31)/1000)","v":0},{"$f":"O10/12","v":0}]
[null,null,null,"Spouse Trauma Cover (GCI)",null,"N",null,45,{"$f":"IF($F$7=\"N\",0,(SUMIFS('Income Replaecment Rates'!$D:$D,'Income Replaecment Rates'!$C:$C,$H11,'Income Replaecment Rates'!$B:$B,$X$6)*(($F$24*24))))","v":0},{"$f":"I11/12","v":0},{"$f":"IF(H11=$F$26,I11,0)","v":0},null,null,"Member (Trauma)",{"$f":"IF(F9=\"N\",0,IF(F32>300000,0,(SUMIFS('Life and Truama Rates'!G:G,'Life and Truama Rates'!D:D,$X$6)*$F$32)/1000))","v":0},{"$f":"O11/12","v":0}]
[null,null,null,{"$f":"IF(AND(F8=\"N\",F9=\"N\"),IF(OR(F10=\"Y\",F11=\"Y\"),\"No Spouse Cover without the equivalent Member Cover\",\"\"),IF(AND(F8=\"Y\",F9=\"N\"),IF(F11=\"Y\",\"No Spouse Cover without the equivalent Member Cover\",\"\"),IF(AND(F9=\"Y\",F8=\"N\"),\"No Trauma Cover without Life Cover\",IF(AND(F8=\"Y\",F9=\"Y\",F10=\"N\",F11=\"Y\"),\"No Trauma Cover without Life Cover\",\"\"))))","v":""},null,null,null,90,{"$f":"IF($F$7=\"N\",0,(SUMIFS('Income Replaecment Rates'!$D:$D,'Income Replaecment Rates'!$C:$C,$H12,'Income Replaecment Rates'!$B:$B,$X$6)*(($F$24*24))))","v":0},0,{"$f":"IF(H12=$F$26,I12,0)","v":0},null,null,"Spouse (Life)",{"$f":"IF(F39=\"N/A\",0,IF(F10=\"N\",0,IF(F8=\"N\",0,IF(F36>F31,0,(SUMIFS('Life and Truama Rates'!B4:B51,'Life and Truama Rates'!$A4:$A51,$X$7)*$F$36)/1000))))","v":0},0]
[null,null,null,"Member Details ",null,null,null,180,{"$f":"IF($F$7=\"N\",0,(SUMIFS('Income Replaecment Rates'!$D:$D,'Income Replaecment Rates'!$C:$C,$H13,'Income Replaecment Rates'!$B:$B,$X$6)*(($F$24*24))))","v":0},0,{"$f":"IF(H13=$F$26,I13,0)","v":0},null,null,"Spouse(Trauma)",{"$f":"IF(F11=\"N\",0,IF(F8=\"N\",0,IF(F37>150000,0,IF(F37>F32,0,(SUMIFS('Life and Truama Rates'!G:G,'Life and Truama Rates'!D:D,$X$7)*$F$37)/1000))))","v":0},0]
[null,null,null,{"$f":"IF(AND(F7=\"N\",F8=\"N\"),\"\",\"Member Name\")","v":""},null,null,null,365,{"$f":"IF($F$7=\"N\",0,(SUMIFS('Income Replaecment Rates'!$D:$D,'Income Replaecment Rates'!$C:$C,$H14,'Income Replaecment Rates'!$B:$B,$X$6)*(($F$24*24))))","v":0},0,{"$f":"IF(H14=$F$26,I14,0)","v":0},null,null,"Total",{"$f":"SUM(O10:O13)","v":0},{"$f":"SUM(P10:P13)","v":0}]
[null,null,null,{"$f":"IF(AND(F8=\"N\",F7=\"N\"),\"\",\"Member Number\")","v":""},null,null,{"$f":"IF(AND(F7=\"N\", F8=\"N\"),\"\",\"4 digits\")","v":""},null,null,null,{"$f":"IF(I15=$F$26,J15,0)","v":0}]
[null,null,null,{"$f":"IF(AND(F7=\"N\",F8=\"N\"),\"\",\"Member Date of Birth\")","v":""},null,null,{"$f":"IF(AND(F7=\"N\",F8=\"N\"),\"\",\"dd/mm/yyyy\")","v":""}]
[null,null,null,{"$f":"IF(OR(F8=\"N\",F10=\"N\"),\"\",\"Spouse Date of Birth\")","v":""}]
[null,null,null,{"$f":"IFERROR(IF(AND(F16=\"\",F17=\"\"),\"\",IF(AND(F7=\"Y\",X6>65), \"Ineligible Member age for selection\",IF(AND(F7=\"Y\",X6<18), \"Ineligible Member age for selection\",  IF(AND(F8=\"Y\",X6>69),\"Ineligible Member age for Selection\",IF(AND(F8=\"Y\",X6<18),\"Ineligible Member age for Selection\", IF(AND(F10=\"Y\", F8=\"y\",F17=\"\"), \"Spouse DOB can't be blank\", IF(AND(F8=\"Y\",X7>69, F10=\"Y\"), \"Ineligible Spouse Age for Seleciton\",IF(AND(F8=\"Y\",X6>69), \"Ineligible Member Age for Seleciton\", IF(AND(F8=\"Y\",X7<18, F10=\"Y\",X7>0), \"Ineligible Spouse Age for Seleciton\",IF(AND(F8=\"Y\",X6<18, X6>0), \"Ineligible Member Age for Seleciton\",\"\")))))))))),\"Date formatting error\")","v":""}]
[null,null,null,"Income Protection (GDI)"]
[null,null,null,{"$f":"IF(F7=\"N\",\"\",\"Gross Salary\")","v":""}]
[null,null,null,{"$f":"IF(F7=\"N\",\"\",\"Net Salary\")","v":""},null,{"$f":"F20-SUM('Tax Calculator'!D4:D10)","v":0}]
[null,null,null,{"$f":"IF(F7=\"N\",\"\",\"Max Annual Benefit*\")","v":""},null,{"$f":"IF((F21*0.9)/12<25000, (F21*0.9), 25000*12)","v":0}]
[null,null,null,{"$f":"IF(F7=\"N\",\"\",\"Max Monthly Benefit\")","v":""},null,{"$f":"F22/12","v":0}]
[null,null,null,{"$f":"IF(F7=\"N\",\"\",\"Elected Monthly Benefit\")","v":""},null,{"$f":"F23","v":0}]
[null,null,null,{"$f":"IF(F7=\"N\",\"\",\"Fortnightly Equivalent.\")","v":""},null,{"$f":"(F24*12)/26","v":0}]
[null,null,null,{"$f":"IF(F7=\"N\",\"\",\"Wait Period\")","v":""}]
[null,null,null,{"$f":"IF(ROUNDUP(F24,2)>(ROUNDUP(F23,2)),\"Cant select a monthly benefit above the max\",\"\")","v":""}]
[null,null,null,{"$f":"IF(F7=\"Y\",\"Annual Premium\",\"\")","v":""},null,{"$f":"IFERROR(IF(F7=\"n\",\"\",IF(X6=\"\",0,IF(OR(X6>65,X6<18), \"N/A\",IF(D27<>\"\",\"N/A\",SUMIFS('Income Replaecment Rates'!D:D,'Income Replaecment Rates'!B:B,' Quote Engine'!X6,'Income Replaecment Rates'!C:C,' Quote Engine'!F26)*((F24*24)))))),\"N/A\")","v":""}]
[null,null,null,{"$f":"IF(F7=\"N\",\"\",\"*90% of net annual salary maxed at 300k\")","v":""}]
[null,null,null,"Life & Trauma (GLI & GCI)"]
[null,null,null,{"$f":"IF(F8=\"Y\",\"Life Sum Insured (Member)\",\"\")","v":""}]
[null,null,null,{"$f":"IF(OR(F8=\"N\",F9=\"N\"),\"\",\"Trauma Sum Insured (Member)\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q33=\"N/A\", \"Ineligible Selection\",\"\")","v":""}]
[null,null,null,{"$f":"IF(F32>300000,\"Max Member Trauma Sum Insured is 300k\",\"\")","v":""},null,null,null,null,null,null,null,null,"Total Proposed Annual Premium across all selections*:",null,null,null,{"$f":"IFERROR(IF(OR(F28=\"N/A\",F40=\"N/A\"),\"N/A\",IF(AND(F7=\"Y\",F8=\"Y\",F28>0,F31>0),(F28+F40)-(F28*0.05)-(O10*0.05)-(O11*0.05),IF(F28=\"\",F40,IF(F40=\"\",F28,IFERROR(F28+F40,0))))),\"N/A\")","v":0}]
[null,null,null,{"$f":"IF(F8=\"Y\",\"L&T Annual Premium (Member)\",\"\")","v":""},null,{"$f":"IFERROR(IF(D33<>\"\",\"n/a\",IF(X6=\"\",0,IF(OR(X6>70, X6<17), \"N/A\",IF(F8=\"N\",0,IF(AND(F8=\"Y\",F9=\"Y\"),((SUMIFS('Life and Truama Rates'!B3:B55,'Life and Truama Rates'!A3:A55,$X$6)*F31)/1000)+(SUMIFS('Life and Truama Rates'!$G:$G,'Life and Truama Rates'!$D:$D,X6)*F32)/1000,IF(AND(F8=\"Y\",F9=\"N\"),(SUMIFS('Life and Truama Rates'!B3:B55,'Life and Truama Rates'!A3:A55,$X$6)*F31)/1000,IF(AND(F8=\"N\",F9=\"Y\"),(SUMIFS('Life and Truama Rates'!$G:$G,'Life and Truama Rates'!$D:$D,X6)*F32)/1000))))))),\"N/A\")","v":0},null,null,null,null,null,null,"Total Proposed Monthly Premium across all selections*:",null,null,null,{"$f":"IFERROR(Q33/12,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q33=\"N/A\",\"\",IF(Q34>0,\"Monthly premium can be paid by monthly direct debit\",\"\"))","v":""}]
[null,null,null,{"$f":"IF(OR(F10=\"N\",F8=\"N\"),\"\",\"Life Sum Insured (Spouse)\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(Q33=\"N/A\",\"\",IF(AND(F7=\"Y\",F8=\"Y\",F9=\"Y\",F28>0,F31>0),\"*Quote includes a 5% discount on Member Income Replacement, Life & Trauma Cover\",IF(AND(F7=\"Y\",F8=\"Y\",F28>0,F31>0),\"*Quote includes a 5% discount on Member Income Replacement and Life Cover\",\"\")))","v":""}]
[null,null,null,{"$f":"IF(OR(F11=\"N\",F10=\"N\",F9=\"N\", F8=\"N\"),\"\",\"Trauma Sum Insured (Spouse)\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",F7=\"Y\",F28>0),\"The calculation for Income replacement provided is based on recommended \",\"\")","v":""}]
[null,null,null,{"$f":"IF(F37>150000,\"Max Spouse Trauma Sum Insured 150k\",IF(AND(X7>50,F36>500000,F36>F31),\"Max Sum Insured for over 50's is 500k & Spouse Sum Insured can't exceed members\",IF(AND(X7>50,F36>500000,F37>F32),\"Max Sum Insured for over 50's is 500k & Spouse Sum Insured can't exceed members\",IF(AND(X7>50,F36>500000),\"Max Sum Insured for over 50's is 500k\",IF(F36>F31,\"Spouse Sum Insured can't exceed members\",IF(F37>F32,\"Spouse Sum Insured can't exceed members\",\"\"))))))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",F7=\"Y\", F28>0),\"income cover of gross base plus margin, 90% of net after tax unless smaller elected\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(F10=\"Y\",F8=\"Y\"),\"L&T Annual Premium (Spouse)\",\"\")","v":""},null,{"$f":"IFERROR(IF(D38<>\"\",\"N/A\",IF(AND(F8=\"Y\",F10=\"Y\",F17=\"\"), \"N/A\",IF(X7=\"\",0,IF(OR(X7>70,X7<17),\"N/A\",IF(AND(F10=\"Y\",F11=\"Y\"),((SUMIFS('Life and Truama Rates'!B3:B55,'Life and Truama Rates'!A3:A55,$X$7)*F36)/1000)+(SUMIFS('Life and Truama Rates'!$G:$G,'Life and Truama Rates'!$D:$D,X7)*F37)/1000,IF(AND(F10=\"Y\",F11=\"N\"),(SUMIFS('Life and Truama Rates'!B3:B55,'Life and Truama Rates'!A3:A55,$X$7)*F36)/1000,IF(AND(F8=\"N\",F9=\"Y\"),(SUMIFS('Life and Truama Rates'!$G:$G,'Life and Truama Rates'!$D:$D,X7)*F37)/1000))))))),\"N/A\")","v":0},null,null,null,null,null,null,{"$f":"IF(AND(F28<>\"\",F7=\"Y\", F28>0),\"monthly benefit is selected\",\"\")","v":""}]
[null,null,null,{"$f":"IF(F8=\"Y\",\"L&T Annual Premium (Total)\",\"\")","v":""},null,{"$f":"IF(OR(F39=\"N/A\",F34=\"N/A\"),\"N/A\",F39+F34)","v":0}]
[null,null,null,null,null,null,null,"Premium Indicator Disclaimer: This premium indicator is an estimate only and is provided for general guidance purposes. It is not a quotation, offer, or confirmation "]
[null,null,null,null,null,null,null,"of insurance cover. All cover is subject to full underwriting, disclosure of all material information, and written acceptance by the insurer."]
[null,null,null,null,null,null,null," Final terms, conditions, limits, and premium may change, or the risk may be declined.No insurance cover exists until written confirmation of cover has been issued by the insurer."]

{"sheet":"Income Replaecment Rates","index":1,"n_rows":247,"n_cols":4,"rows_kept":247,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Age","WD","Rate"]
[null,17,30,""]
[null,18,30,{"$f":"D7","v":2.4731287500000003E-3}]
[null,19,30,{"$f":"D7","v":2.4731287500000003E-3}]
[null,20,30,{"$f":"D7","v":2.4731287500000003E-3}]
[null,21,30,2.4731287500000003E-3]
[null,22,30,2.5456737500000005E-3]
["ak",23,30,2.6182200000000001E-3]
["o",24,30,2.6907637500000006E-3]
["z",25,30,2.7633100000000006E-3]
["au",26,30,2.8358550000000004E-3]
["be",27,30,2.9677537500000005E-3]
[null,28,30,3.0996550000000002E-3]
[null,29,30,3.231555000000001E-3]
[null,30,30,3.3634562500000006E-3]
[null,31,30,3.4953550000000008E-3]
[null,32,30,3.6272550000000007E-3]
[null,33,30,3.8514862500000006E-3]
[null,34,30,4.0757162500000008E-3]
[null,35,30,4.2999474999999999E-3]
[null,36,30,4.5241775000000005E-3]
[null,37,30,4.7484075000000002E-3]
[null,38,30,4.9594475000000011E-3]
[null,39,30,5.1704875000000011E-3]
[null,40,30,5.3815287500000005E-3]
[null,41,30,5.7789877083333349E-3]
[null,42,30,6.3839696249999994E-3]
[null,43,30,7.5657959999999996E-3]
[null,44,30,9.0747333333333329E-3]
[null,45,30,1.2178785416666666E-2]
[null,46,30,1.431556729166667E-2]
[null,47,30,1.6619427499999999E-2]
[null,48,30,1.8390187291666669E-2]
[null,49,30,2.0220299166666664E-2]
[null,50,30,2.1372779479166666E-2]
[null,51,30,2.2554934374999999E-2]
[null,52,30,2.3766770000000003E-2]
[null,53,30,2.4762066666666666E-2]
[null,54,30,2.5771652500000002E-2]
[null,55,30,2.6795527499999999E-2]
[null,56,30,2.7038443333333332E-2]
[null,57,30,2.7281359166666661E-2]
[null,58,30,2.9056516875000001E-2]
[null,59,30,3.0738241874999996E-2]
[null,60,30,3.2887119791666669E-2]
[null,61,30,3.5035990624999999E-2]
[null,62,30,3.7184879166666664E-2]
[null,63,30,3.9707395833333332E-2]
[null,64,30,4.3351062499999996E-2]
[null,65,30,4.8303020833333328E-2]
[null,17,45,""]
[null,18,45,{"$f":"D56","v":2.3412287500000008E-3}]
[null,19,45,{"$f":"D56","v":2.3412287500000008E-3}]
[null,20,45,{"$f":"D56","v":2.3412287500000008E-3}]
[null,21,45,2.3412287500000008E-3]
[null,22,45,2.4071787499999999E-3]
[null,23,45,2.4731287500000003E-3]
[null,24,45,2.5390787499999998E-3]
[null,25,45,2.6050287500000002E-3]
[null,26,45,2.6709800000000003E-3]
[null,27,45,2.7974675000000003E-3]
[null,28,45,2.9237874999999999E-3]
[null,29,45,3.0502762500000005E-3]
[null,30,45,3.1765962500000001E-3]
[null,31,45,3.3030862500000001E-3]
[null,32,45,3.4294050000000004E-3]
[null,33,45,3.6404462500000006E-3]
[null,34,45,3.8514862500000006E-3]
[null,35,45,4.0625262500000002E-3]
[null,36,45,4.2735675000000004E-3]
[null,37,45,4.4846062500000011E-3]
[null,38,45,4.6956475000000004E-3]
[null,39,45,4.9066875000000013E-3]
[null,40,45,5.1177275000000013E-3]
[null,41,45,5.5063943750000002E-3]
[null,42,45,6.0937896250000002E-3]
[null,43,45,7.2175800000000003E-3]
[null,44,45,8.6526533333333346E-3]
[null,45,45,1.1607218749999999E-2]
[null,46,45,1.363835E-2]
[null,47,45,1.5828024999999999E-2]
[null,48,45,1.7504256250000003E-2]
[null,49,45,1.923544583333333E-2]
[null,50,45,2.0320873958333333E-2]
[null,51,45,2.1433784374999997E-2]
[null,52,45,2.2574170937500002E-2]
[null,53,45,2.3513409999999998E-2]
[null,54,45,2.4465839062500001E-2]
[null,55,45,2.5431461666666665E-2]
[null,56,45,2.5655688124999999E-2]
[null,57,45,2.5879918124999998E-2]
[null,58,45,2.7655075833333334E-2]
[null,59,45,2.9243375208333332E-2]
[null,60,45,3.1205387708333334E-2]
[null,61,45,3.3260836458333332E-2]
[null,62,45,3.5316281666666664E-2]
[null,63,45,3.7932312499999996E-2]
[null,64,45,4.1202333333333327E-2]
[null,65,45,4.5873791666666663E-2]
[null,17,90,""]
[null,18,90,{"$f":"D105","v":1.4179262500000002E-3}]
[null,19,90,{"$f":"D105","v":1.4179262500000002E-3}]
[null,20,90,{"$f":"D105","v":1.4179262500000002E-3}]
[null,21,90,1.4179262500000002E-3]
[null,22,90,1.4640925000000001E-3]
[null,23,90,1.5102575000000003E-3]
[null,24,90,1.5102575000000003E-3]
[null,25,90,1.5564225000000004E-3]
[null,26,90,1.6025875000000001E-3]
[null,27,90,1.7312737500000002E-3]
[null,28,90,1.8136287500000003E-3]
[null,29,90,1.8961500000000005E-3]
[null,30,90,1.9785037500000004E-3]
[null,31,90,2.0610250000000006E-3]
[null,32,90,2.1433787500000005E-3]
[null,33,90,2.2357087500000004E-3]
[null,34,90,2.3280387500000002E-3]
[null,35,90,2.4203687500000005E-3]
[null,36,90,2.5126987499999999E-3]
[null,37,90,2.6050287500000002E-3]
[null,38,90,2.7567150000000007E-3]
[null,39,90,2.9083987500000004E-3]
[null,40,90,3.0600850000000006E-3]
[null,41,90,3.3188290000000001E-3]
[null,42,90,3.6998018749999995E-3]
[null,43,90,4.3131374999999996E-3]
[null,44,90,5.1001400000000004E-3]
[null,45,90,6.7598854166666658E-3]
[null,46,90,7.8590531250000012E-3]
[null,47,90,9.0351624999999991E-3]
[null,48,90,1.0073878749999999E-2]
[null,49,90,1.1156559166666666E-2]
[null,50,90,1.1873766041666666E-2]
[null,51,90,1.261295625E-2]
[null,52,90,1.3374129791666668E-2]
[null,53,90,1.405177E-2]
[null,54,90,1.47447953125E-2]
[null,55,90,1.5453208958333334E-2]
[null,56,90,1.5714810625000002E-2]
[null,57,90,1.5976412291666669E-2]
[null,58,90,1.6817278333333335E-2]
[null,59,90,1.7751569999999998E-2]
[null,60,90,1.8966149166666668E-2]
[null,61,90,2.0087299166666663E-2]
[null,62,90,2.1019529583333304E-2]
[null,63,90,2.2796752083333333E-2]
[null,64,90,2.4758768125E-2]
[null,65,90,2.7281359166666661E-2]
[null,17,180,""]
[null,18,180,{"$f":"D154","v":1.1871024999999999E-3}]
[null,19,180,{"$f":"D154","v":1.1871024999999999E-3}]
[null,20,180,{"$f":"D154","v":1.1871024999999999E-3}]
[null,21,180,1.1871024999999999E-3]
[null,22,180,1.2200763750000003E-3]
[null,23,180,1.2530512500000001E-3]
[null,24,180,1.2860275000000001E-3]
[null,25,180,1.3190025000000003E-3]
[null,26,180,1.3519775E-3]
[null,27,180,1.4125162500000002E-3]
[null,28,180,1.4728862500000004E-3]
[null,29,180,1.5334237500000002E-3]
[null,30,180,1.5937937500000003E-3]
[null,31,180,1.6543325000000003E-3]
[null,32,180,1.7147025000000002E-3]
[null,33,180,1.8202225000000002E-3]
[null,34,180,1.9257437500000004E-3]
[null,35,180,2.0312625000000004E-3]
[null,36,180,2.1367825000000004E-3]
[null,37,180,2.2423037500000002E-3]
[null,38,180,2.3544187500000001E-3]
[null,39,180,2.4665337500000004E-3]
[null,40,180,2.5786487500000003E-3]
[null,41,180,2.7804558750000007E-3]
[null,42,180,3.0831666249999997E-3]
[null,43,180,3.6404460000000003E-3]
[null,44,180,4.3527066666666668E-3]
[null,45,180,5.8255916666666669E-3]
[null,46,180,6.8313322916666672E-3]
[null,47,180,7.9140124999999995E-3]
[null,48,180,8.7592727083333349E-3]
[null,49,180,9.6331112499999996E-3]
[null,50,180,1.0184343854166666E-2]
[null,51,180,1.0749868749999999E-2]
[null,52,180,1.1329679791666667E-2]
[null,53,180,1.1800673333333334E-2]
[null,54,180,1.22782584375E-2]
[null,55,180,1.2762445416666667E-2]
[null,56,180,1.2874556875E-2]
[null,57,180,1.2986675416666666E-2]
[null,58,180,1.3920967083333331E-2]
[null,59,180,1.4668400416666666E-2]
[null,60,180,1.5696124791666669E-2]
[null,61,180,1.6723845625000001E-2]
[null,62,180,1.7751569999999998E-2]
[null,63,180,1.8872719999999999E-2]
[null,64,180,2.064788125E-2]
[null,65,180,2.2983610416666665E-2]
[null,17,365,""]
[null,18,365,{"$f":"D203","v":9.5627700000000017E-4}]
[null,19,365,{"$f":"D203","v":9.5627700000000017E-4}]
[null,20,365,{"$f":"D203","v":9.5627700000000017E-4}]
[null,21,365,9.5627700000000017E-4]
[null,22,365,9.8265700000000006E-4]
[null,23,365,1.009036875E-3]
[null,24,365,1.0354168750000001E-3]
[null,25,365,1.0617967500000003E-3]
[null,26,365,1.0881767500000002E-3]
[null,27,365,1.1377236250000001E-3]
[null,28,365,1.1871024999999999E-3]
[null,29,365,1.2366493750000001E-3]
[null,30,365,1.2860275000000001E-3]
[null,31,365,1.3355737500000003E-3]
[null,32,365,1.3849525000000002E-3]
[null,33,365,1.4708125000000003E-3]
[null,34,365,1.5564225000000004E-3]
[null,35,365,1.6421575000000004E-3]
[null,36,365,1.7278937500000003E-3]
[null,37,365,1.8136287500000003E-3]
[null,38,365,1.8927675000000002E-3]
[null,39,365,1.9719075000000003E-3]
[null,40,365,2.0510475E-3]
[null,41,365,2.2011950416666671E-3]
[null,42,365,2.4302616249999996E-3]
[null,43,365,2.8807004999999997E-3]
[null,44,365,3.4557866666666669E-3]
[null,45,365,4.638491666666667E-3]
[null,46,365,5.4529750000000005E-3]
[null,47,365,6.331207499999999E-3]
[null,48,365,7.0017025000000009E-3]
[null,49,365,7.6941783333333326E-3]
[null,50,365,8.1283526041666665E-3]
[null,51,365,8.2610124999999996E-3]
[null,52,365,9.0296670833333332E-3]
[null,53,365,9.408883333333333E-3]
[null,54,365,9.7935921874999984E-3]
[null,55,365,1.0183796875E-2]
[null,56,365,1.0277222500000001E-2]
[null,57,365,1.0370651666666666E-2]
[null,58,365,1.1118088541666666E-2]
[null,59,365,1.1678663541666665E-2]
[null,60,365,1.2519529583333333E-2]
[null,61,365,1.3360392083333334E-2]
[null,62,365,1.4201254583333335E-2]
[null,63,365,1.513554625E-2]
[null,64,365,1.6536987291666666E-2]
[null,65,365,1.7694577499999999E-2]

{"sheet":"Life and Truama Rates","index":2,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Life",null,null,null,"Trauma"]
["Age ","All Genders",null,"Age","Male","Female","Blended"]
[18,0.38,null,18,0.44645806389975901,0.41717425540740921,{"$f":"(E3*0.917)+(F3*(1-0.917))","v":0.44402750779489397}]
[19,0.4,null,19,0.71841343293117144,0.71121249641665918,0.71781575520046692]
[20,0.44,null,20,0.8021843277166637,0.76377933297259837,0.79899671315290632]
[21,0.48,null,21,1.0410153887813198,0.94716318287551027,1.0332256556911377]
[22,0.5,null,22,1.2248793011185322,1.1039035676747266,1.2148383152426963]
[23,0.51,null,23,1.4471482081998104,1.2556032969137847,1.4312499805630703]
[24,0.52,null,24,1.6365328385314821,1.4370668970794931,1.6199771653909669]
[25,0.52,null,25,1.826397531297455,1.6305320581027223,1.8101406970222922]
[26,0.51,null,26,1.7443068550320155,1.3955414965124724,1.7153593302748935]
[27,0.5,null,27,1.6922200809103769,1.3060098525153705,1.6601646319535914]
[28,0.49,null,28,1.695820549167633,1.2604039212567928,1.6596809690510332]
[29,0.48,null,29,1.6713373650182917,1.3986619023354279,1.6487053016156141]
[30,0.47,null,30,1.7121426719338608,1.6098893734277868,1.7036556481578566]
[31,0.46,null,31,1.6761379893612995,1.6979808301219868,1.6779509451444368]
[32,0.46,null,32,1.6614960851151246,1.8340785302462681,1.6758204280610094]
[33,0.46,null,33,1.7099823909795073,2.016262224063428,1.7354036171254728]
[34,0.46,null,34,1.789912786290593,2.2925381550035473,1.8316306918937681]
[35,0.46,null,35,2.0781902780882331,2.5757749912410288,2.1194898092799153]
[36,0.47,null,36,2.2975788105637061,2.7690001210471071,2.3367067793338281]
[37,0.49,null,37,2.6230611410196594,3.0013503392487024,2.65445914447267]
[38,0.51,null,38,3.0330344599125563,3.3042697352925177,3.0555469877690933]
[39,0.54,null,39,3.5558224508661453,3.8717035326360825,3.5820405806530502]
[40,0.56999999999999995,null,40,4.1808637403258082,4.5296290988453505,4.20981126508293]
[41,0.6,null,41,4.3020795049867635,5.3622973911401166,4.3900775895374915]
[42,0.64,null,42,4.9991301595915498,5.8169165164229888,5.0670064272085593]
[43,0.69,null,43,5.5507218966031875,6.7299952664631411,5.6486015863015631]
[44,0.74,null,44,6.1560806262565162,7.1078044022578828,6.2350736996646292]
[45,0.79,null,45,6.8543314369470529,7.8607823304587141,6.9378668611085201]
[46,0.85,null,46,7.6013085847191233,8.0796908004998862,7.6410143086289271]
[47,0.92,null,47,8.167062163542635,8.6464045041919988,8.2068475778165322]
[48,0.99,null,48,8.7887430159621918,8.7858626413563865,8.7885039448699089]
[49,1.07,null,49,9.3561768133057566,9.1939157105120799,{"$f":"(E34*0.917)+(F34*(1-0.917))","v":9.3427091417738808}]
[50,1.18,null,50,10.154040579113712,9.7404667919635575,10.11971395478025]
[51,1.3,null,51,11.026073991021146,10.527049090565447,10.984654924283323]
[52,1.43,null,52,11.741607049346513,10.968946561339349,11.677476228841918]
[53,1.58,null,53,12.436737454214095,11.598308412707718,12.367147843769066]
[54,1.75,null,54,14.127517347821568,12.370728869497732,13.981703904120689]
[55,1.95,null,55,15.408323922536145,13.563684018735261,15.255218810520672]
[56,2.16,null,56,16.64640494059795,14.778482008733475,16.491367337253198]
[57,2.39,null,57,18.137478861536287,16.22731043545334,17.978934882171401]
[58,2.65,null,58,19.466051648463797,18.041226343458973,19.347791148148396]
[59,2.96,null,59,22.421796056453921,21.035375746193164,22.306723170702277]
[60,3.32,null,60,26.049147810030885,24.343245949742933,25.907557955626984]
[61,3.7,null,61,30.002461956498109,28.009962822932568,29.83708452841217]
[62,4.18,null,62,34.504487465371156,32.098894607089768,34.304823258133801]
[63,4.79,null,63,39.361999206843969,37.10594579684728,39.174746773814249]
[64,5.48,null,64,43.130009253671076,41.789674937103193,43.018761505395943]
[65,6.28,null,65,47.591709518062864,47.258066126223795,47.564017116540221]
[66,7.2,null,66,null,null,52.591930859567569]
[67,8.25,null,67,null,null,58.153873975541323]
[68,9.35,null,68,null,null,64.307256410885856]
[69,10.58,null,69,null,null,71.115085640009497]

{"sheet":"Data-->","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Tax Calculator","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Fidelity Life"]
[null,"Tax Bands",null,{"$f":"' Quote Engine'!F20","v":0}]
[null,"Up to","Rate","Tax"]
[null,15600,0.105,{"$f":"IF(' Quote Engine'!$F$20>B4,C4*B4,' Quote Engine'!$F$20*C4)","v":0}]
[null,53500,0.17499999999999999,{"$f":"IF(' Quote Engine'!$F$20<B4,0,IF(' Quote Engine'!$F$20>B5,C5*(B5-B4),(' Quote Engine'!$F$20-B4)*C5))","v":0}]
[null,78100,0.3,{"$f":"IF(' Quote Engine'!$F$20<B5,0,IF(' Quote Engine'!$F$20>B6,C6*(B6-B5),(' Quote Engine'!$F$20-B5)*C6))","v":0}]
[null,180000,0.33,{"$f":"IF(' Quote Engine'!$F$20<B6,0,IF(' Quote Engine'!$F$20>B7,C7*(B7-B6),(' Quote Engine'!$F$20-B6)*C7))","v":0}]
[null,18000000.010000002,0.39,{"$f":"IF(' Quote Engine'!$F$20<B7,0,IF(' Quote Engine'!$F$20>B8,C8*(B8-B7),(' Quote Engine'!$F$20-B7)*C8))","v":0}]
[]
[null,"ACC Levy",1.67E-2,{"$f":"IF(' Quote Engine'!F20>152790.01,152790*C10,C10*' Quote Engine'!F20)","v":0}]
[null,null,null,{"$f":"D2-D4-D5-D6-D7-D8-D10","v":0},null,{"$f":"' Quote Engine'!F24*12","v":0}]

{"sheet":"Drop Downs","index":5,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
[null,"WD",null,"Age"]
[null,30,null,17,null,"Y"]
[null,45,null,18,null,"N"]
[null,90,null,19]
[null,180,null,20]
[null,365,null,21]
[null,730,null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,null,null,30]
[null,null,null,31]
[null,null,null,32]
[null,null,null,33]
[null,null,null,34]
[null,null,null,35]
[null,null,null,36]
[null,null,null,37]
[null,null,null,38]
[null,null,null,39]
[null,null,null,40]
[null,null,null,41]
[null,null,null,42]
[null,null,null,43]
[null,null,null,44]
[null,null,null,45]
[null,null,null,46]
[null,null,null,47]
[null,null,null,48]
[null,null,null,49]
[null,null,null,50]
[null,null,null,51]
[null,null,null,52]
[null,null,null,53]
[null,null,null,54]
[null,null,null,55]
[null,null,null,56]
[null,null,null,57]
[null,null,null,58]
[null,null,null,59]
[null,null,null,60]
[null,null,null,61]
[null,null,null,62]
[null,null,null,63]
[null,null,null,64]
[null,null,null,65]