{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Premium Calculator","Sheet2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":54,"n_cols":28,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["Particulars / SI","Rs. 10,000","Rs. 20,000","Rs. 25,000","Rs. 50,000","Rs. 75,000","Rs. 1 lakh","Rs. 1.5 lakhs","Rs. 2 lakhs","Rs. 2.5 lakhs","Rs. 3 lakhs","Rs. 5 lakhs","Rs. 10 lakhs","Rs. 15 lakhs","Rs. 20 lakhs","Rs. 25 lakhs","Rs. 35 lakhs","Rs. 50 lakhs","Rs. 75 lakhs","Rs. 1 crore","Rs. 1.5 crores","Rs. 2 crores","Rs. 2.5 crores","Rs. 3 crores","Rs. 3.5 crores","Rs. 4 crores","Rs. 4.5 crores","Rs. 5 crores"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28]
["Identity Theft Cover",0.755,0.755,0.755,0.755,0.755,0.755,0.56599999999999995,0.45300000000000001,0.39600000000000002,0.34,0.245,0.17,0.16200000000000001,0.151,0.13600000000000001,0.106,7.5999999999999998E-2,6.4000000000000001E-2,5.5E-2,4.7E-2,0.04,3.5999999999999997E-2,3.2000000000000001E-2,0.03,2.8000000000000001E-2,2.5999999999999999E-2,2.5999999999999999E-2]
["IT Theft/ Theft of Funds/ Financial Loss Cover",3.7280000000000002,3.7280000000000002,3.7280000000000002,3.7280000000000002,3.7280000000000002,3.7280000000000002,2.7959999999999998,2.2370000000000001,1.9570000000000001,1.6779999999999999,1.212,0.83899999999999997,0.80200000000000005,0.746,0.67100000000000004,0.52200000000000002,0.373,0.317,0.27,0.23300000000000001,0.19600000000000001,0.17699999999999999,0.158,0.14899999999999999,0.14000000000000001,0.13,0.127]
["E-mail Spoofing Cover",0.63500000000000001,0.63500000000000001,0.63500000000000001,0.63500000000000001,0.63500000000000001,0.63500000000000001,0.47599999999999998,0.38100000000000001,0.33300000000000002,0.28599999999999998,0.20599999999999999,0.14299999999999999,0.13700000000000001,0.127,0.114,8.8999999999999996E-2,6.4000000000000001E-2,5.3999999999999999E-2,4.5999999999999999E-2,0.04,3.3000000000000002E-2,0.03,2.7E-2,2.5000000000000001E-2,2.4E-2,2.1999999999999999E-2,2.1999999999999999E-2]
["Cyberbullying Cover ",1.365,1.365,1.365,1.365,1.365,1.365,1.024,0.81899999999999995,0.71599999999999997,0.61399999999999999,0.44400000000000001,0.307,0.29299999999999998,0.27300000000000002,0.246,0.191,0.13600000000000001,0.11600000000000001,9.9000000000000005E-2,8.5000000000000006E-2,7.1999999999999995E-2,6.5000000000000002E-2,5.8000000000000003E-2,5.5E-2,5.0999999999999997E-2,4.8000000000000001E-2,4.5999999999999999E-2]
["Malware Cover ",1.579,1.579,1.579,1.579,1.579,1.579,1.1839999999999999,0.94699999999999995,0.82899999999999996,0.71099999999999997,0.51300000000000001,0.35499999999999998,0.33900000000000002,0.316,0.28399999999999997,0.221,0.158,0.13400000000000001,0.114,9.9000000000000005E-2,8.3000000000000004E-2,7.4999999999999997E-2,6.7000000000000004E-2,6.3E-2,5.8999999999999997E-2,5.5E-2,5.3999999999999999E-2]
["Media Liability Claims Cover ",1.4139999999999999,1.4139999999999999,1.4139999999999999,1.4139999999999999,1.4139999999999999,1.4139999999999999,1.0609999999999999,0.84899999999999998,0.74299999999999999,0.63600000000000001,0.46,0.318,0.30399999999999999,0.28299999999999997,0.255,0.19800000000000001,0.14099999999999999,0.12,0.10299999999999999,8.7999999999999995E-2,7.3999999999999996E-2,6.7000000000000004E-2,0.06,5.7000000000000002E-2,5.2999999999999999E-2,0.05,4.8000000000000001E-2]
["Cyber Extortion Cover ",1.4910000000000001,1.4910000000000001,1.4910000000000001,1.4910000000000001,1.4910000000000001,1.4910000000000001,1.1180000000000001,0.89400000000000002,0.78300000000000003,0.67100000000000004,0.48499999999999999,0.33500000000000002,0.32100000000000001,0.29799999999999999,0.26800000000000002,0.20899999999999999,0.14899999999999999,0.127,0.108,9.2999999999999999E-2,7.8E-2,7.0999999999999994E-2,6.3E-2,0.06,5.6000000000000001E-2,5.1999999999999998E-2,5.0999999999999997E-2]
["Privacy Breach and Data Breach First Party Cover",1.323,1.323,1.323,1.323,1.323,1.323,0.99199999999999999,0.79400000000000004,0.69399999999999995,0.59499999999999997,0.43,0.29799999999999999,0.28399999999999997,0.26500000000000001,0.23799999999999999,0.185,0.13200000000000001,0.112,9.6000000000000002E-2,8.3000000000000004E-2,6.9000000000000006E-2,6.3E-2,5.6000000000000001E-2,5.2999999999999999E-2,0.05,4.5999999999999999E-2,4.4999999999999998E-2]
["Privacy Breach and Data Breach (of Third Party) Liability Cover",1.323,1.323,1.323,1.323,1.323,1.323,0.99199999999999999,0.79400000000000004,0.69399999999999995,0.59499999999999997,0.43,0.29799999999999999,0.28399999999999997,0.26500000000000001,0.23799999999999999,0.185,0.13200000000000001,0.112,9.6000000000000002E-2,8.3000000000000004E-2,6.9000000000000006E-2,6.3E-2,5.6000000000000001E-2,5.2999999999999999E-2,0.05,4.5999999999999999E-2,4.4999999999999998E-2]
["Counselling Services ",0.68100000000000005,0.68100000000000005,0.68100000000000005,0.68100000000000005,0.68100000000000005,0.68100000000000005,0.51,0.40799999999999997,0.35699999999999998,0.30599999999999999,0.221,0.153,0.14599999999999999,0.13600000000000001,0.123,9.5000000000000001E-2,6.8000000000000005E-2,5.8000000000000003E-2,4.9000000000000002E-2,4.2999999999999997E-2,3.5999999999999997E-2,3.2000000000000001E-2,2.9000000000000001E-2,2.7E-2,2.5999999999999999E-2,2.4E-2,2.3E-2]
["IT Consultant Services Cover ",0.68100000000000005,0.68100000000000005,0.68100000000000005,0.68100000000000005,0.68100000000000005,0.68100000000000005,0.51,0.40799999999999997,0.35699999999999998,0.30599999999999999,0.221,0.153,0.14599999999999999,0.13600000000000001,0.123,9.5000000000000001E-2,6.8000000000000005E-2,5.8000000000000003E-2,4.9000000000000002E-2,4.2999999999999997E-2,3.5999999999999997E-2,3.2000000000000001E-2,2.9000000000000001E-2,2.7E-2,2.5999999999999999E-2,2.4E-2,2.3E-2]
["Online Sales Cover",0.94799999999999995,0.94799999999999995,0.94799999999999995,0.94799999999999995,0.94799999999999995,0.94799999999999995,0.71099999999999997,0.56899999999999995,0.498,0.42699999999999999,0.308,0.21299999999999999,0.20399999999999999,0.19,0.17100000000000001,0.13300000000000001,9.5000000000000001E-2,8.1000000000000003E-2,6.9000000000000006E-2,5.8999999999999997E-2,0.05,4.4999999999999998E-2,0.04,3.7999999999999999E-2,3.5999999999999997E-2,3.3000000000000002E-2,3.2000000000000001E-2]
["Online Shopping Cover",6.4009999999999998,6.4009999999999998,6.4009999999999998,6.4009999999999998,6.4009999999999998,6.4009999999999998,4.8010000000000002,3.8410000000000002,3.3610000000000002,2.8809999999999998,2.08,1.44,1.3759999999999999,1.28,1.1519999999999999,0.89600000000000002,0.64,0.54400000000000004,0.46400000000000002,0.4,0.33600000000000002,0.30399999999999999,0.27200000000000002,0.25600000000000001,0.24,0.224,0.218]
["Replacement of Hardware Cover",2.9020000000000001,2.9020000000000001,2.9020000000000001,2.9020000000000001,2.9020000000000001,2.9020000000000001,2.1760000000000002,1.7410000000000001,1.5229999999999999,1.306,0.94299999999999995,0.65300000000000002,0.624,0.57999999999999996,0.52200000000000002,0.40600000000000003,0.28999999999999998,0.247,0.21,0.18099999999999999,0.152,0.13800000000000001,0.123,0.11600000000000001,0.109,0.10199999999999999,9.9000000000000005E-2]
["Consequential Loss (Theft of Funds) Cover",0.373,0.373,0.373,0.373,0.373,0.373,0.28000000000000003,0.224,0.19600000000000001,0.16800000000000001,0.121,8.4000000000000005E-2,0.08,7.4999999999999997E-2,6.7000000000000004E-2,5.1999999999999998E-2,3.6999999999999998E-2,3.2000000000000001E-2,2.7E-2,2.3E-2,0.02,1.7999999999999999E-2,1.6E-2,1.4999999999999999E-2,1.4E-2,1.2999999999999999E-2,1.2999999999999999E-2]
["Liability arising due to Underage Dependent Children",0.746,0.746,0.746,0.746,0.746,0.746,0.56000000000000005,0.44800000000000001,0.39200000000000002,0.33600000000000002,0.24299999999999999,0.16800000000000001,0.16,0.14899999999999999,0.13400000000000001,0.104,7.4999999999999997E-2,6.3E-2,5.3999999999999999E-2,4.7E-2,3.9E-2,3.5000000000000003E-2,3.2000000000000001E-2,0.03,2.8000000000000001E-2,2.5999999999999999E-2,2.5000000000000001E-2]
["Network Security Liability",1.077,1.077,1.077,1.077,1.077,1.077,0.80800000000000005,0.64600000000000002,0.56499999999999995,0.48499999999999999,0.35,0.24199999999999999,0.23200000000000001,0.215,0.19400000000000001,0.151,0.108,9.1999999999999998E-2,7.8E-2,6.7000000000000004E-2,5.7000000000000002E-2,5.0999999999999997E-2,4.5999999999999999E-2,4.2999999999999997E-2,0.04,3.7999999999999999E-2,3.6999999999999998E-2]
["Smart Home Cover",0.95199999999999996,0.95199999999999996,0.95199999999999996,0.95199999999999996,0.95199999999999996,0.95199999999999996,0.71399999999999997,0.57099999999999995,0.5,0.42799999999999999,0.309,0.214,0.20499999999999999,0.19,0.17100000000000001,0.13300000000000001,9.5000000000000001E-2,8.1000000000000003E-2,6.9000000000000006E-2,5.8999999999999997E-2,0.05,4.4999999999999998E-2,0.04,3.7999999999999999E-2,3.5999999999999997E-2,3.3000000000000002E-2,3.2000000000000001E-2]
["Unauthorized Physical transaction",8.3330000000000002,8.3330000000000002,8.3330000000000002,8.3330000000000002,8.3330000000000002,8.3330000000000002,6.25,5,4.375,3.75,2.7080000000000002,1.875,1.792,1.667,1.5,1.167,0.83299999999999996,0.70799999999999996,0.60399999999999998,0.52100000000000002,0.438,0.39600000000000002,0.35399999999999998,0.33300000000000002,0.313,0.29199999999999998,0.28299999999999997]
[]
["Yes"]
["No"]
[]
[]
["Choose your Limit of Liability",0]
["Rs. 10,000",10000]
["Rs. 20,000",20000]
["Rs. 25,000",25000]
["Rs. 50,000",50000]
["Rs. 75,000",75000]
["Rs. 1 lakh",{"$f":"1*10^5","v":100000}]
["Rs. 1.5 lakhs",{"$f":"1.5*10^5","v":150000}]
["Rs. 2 lakhs",{"$f":"2*10^5","v":200000}]
["Rs. 2.5 lakhs",{"$f":"2.5*10^5","v":250000}]
["Rs. 3 lakhs",{"$f":"3*10^5","v":300000}]
["Rs. 5 lakhs",{"$f":"5*10^5","v":500000}]
["Rs. 10 lakhs",{"$f":"10*10^5","v":1000000}]
["Rs. 15 lakhs",{"$f":"15*10^5","v":1500000}]
["Rs. 20 lakhs",{"$f":"20*10^5","v":2000000}]
["Rs. 25 lakhs",{"$f":"25*10^5","v":2500000}]
["Rs. 35 lakhs",{"$f":"35*10^5","v":3500000}]
["Rs. 50 lakhs",{"$f":"50*10^5","v":5000000}]
["Rs. 75 lakhs",{"$f":"75*10^5","v":7500000}]
["Rs. 1 crore",{"$f":"1*10^7","v":10000000}]
["Rs. 1.5 crores",{"$f":"1.5*10^7","v":15000000}]
["Rs. 2 crores",{"$f":"2*10^7","v":20000000}]
["Rs. 2.5 crores",{"$f":"2.5*10^7","v":25000000}]
["Rs. 3 crores",{"$f":"3*10^7","v":30000000}]
["Rs. 3.5 crores",{"$f":"3.5*10^7","v":35000000}]
["Rs. 4 crores",{"$f":"4*10^7","v":40000000}]
["Rs. 4.5 crores",{"$f":"4.5*10^7","v":45000000}]
["Rs. 5 crores",{"$f":"5*10^7","v":50000000}]

{"sheet":"Premium Calculator","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[3,0,3,7]]}
[]
[]
[]
[" Cyber Protect Group Insurance Policy - Premium Calculator"]
[]
[null,null,null,null,"Choose your Limit of Liability (LOL)"]
[]
[]
["Choose your Cover","Identity Theft Cover"]
["Select Yes or No"]
[]
["Choose your Cover"]
["Select Yes or No"]
[]
[null,"Choose your Cover"]
[null,"Select Yes or No"]
[]
[null,null,null,null,"Total Premium for the above selection"]
[null,null,null,null,{"$f":"Sheet2!AF110","v":"   "}]
[]
[]
[null,"Note: \nThe above premium is not inclusive of GST. \nFor final rates and varied options, please contact an authorised Magma-HDI representative. "]

{"sheet":"Sheet2","index":2,"n_rows":110,"n_cols":35,"rows_kept":110,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Premium Calculator'!B10=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!B9,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!B9,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!C10=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!C9,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!C9,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!D10=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!D9,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!D9,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!E10=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!E9,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!E9,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!F10=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!F9,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!F9,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!G10=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!G9,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!G9,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!H10=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!H9,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!H9,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Premium Calculator'!B13=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!B12,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!B12,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!C13=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!C12,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!C12,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!D13=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!D12,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!D12,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!E13=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!E12,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!E12,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!F13=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!F12,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!F12,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!G13=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!G12,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!G12,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!H13=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!H12,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!H12,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Premium Calculator'!B16=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!B15,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!B15,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!C16=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!C15,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!C15,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!D16=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!D15,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!D15,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!E16=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!E15,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!E15,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!F16=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!F15,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!F15,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!G16=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!G15,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!G15,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}},{"$f":"IF(AND('Premium Calculator'!H16=\"Yes\",NOT(ISNA(MATCH('Premium Calculator'!H15,Sheet1!$A$3:$A$21,0)))),VLOOKUP('Premium Calculator'!H15,Sheet1!$A$1:$AB$21,HLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$1:$AB$2,2,0),0))*VLOOKUP('Premium Calculator'!$E$7,Sheet1!$A$27:$B$54,2,0)/1000","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Premium Calculator'!$E$7),\"   \",ROUND(SUM(AC106:AI108),0))","v":"   "}]