{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Quote","Definitions","Rates","Guide"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,15,1,16],[0,13,0,14],[0,3,0,7],[0,9,0,11],[0,15,0,16]]}
[null,"Name",":","Linear Projects",null,null,null,null,"Email:",null,null,null,"Phone No.",null,null,"Instructions:\nEnable Macros if prompted to.\nSelect Family size & limits desired"]
[null,"SME HEALTH COVER QUOTE"]
[null,"No of Families",null,"Family Size",null,"IP Limit",null,"OP Limit",null,"Dental Limit",null,"Optical Limit",null,"Maternity Limit"]
[null,null,null,null,null,null,"Premium",null,"Premium",null,"Premium",null,"Premium",null,"Premium"]
[null,1,null,"M+3",null,10000000,{"$f":"IFERROR(VLOOKUP($D5,Rates!$B$3:$I$10,Guide!D3,0)*B5,\"\")","v":239775},100000,{"$f":"IFERROR(IF(H5>Guide!I3,\"Check Limit\",VLOOKUP($D5,Rates!$S$3:$X$10,Guide!E3,0))*B5,\"\")","v":91380},null,{"$f":"IFERROR(IF(J5>Guide!J3,\"Check Limit\",VLOOKUP($D5,Rates!$Z$3:$AE$10,Guide!F3,0))*B5,\"\")","v":""},null,{"$f":"IFERROR(IF(L5>Guide!K3,\"Check Limit\",VLOOKUP($D5,Rates!$AG$3:$AL$10,Guide!G3,0))*B5,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N5,Rates!$C$15:$H$16,2,0)*B5,\"\")","v":""}]
[null,3,null,"M",null,2000000,{"$f":"IFERROR(VLOOKUP($D6,Rates!$B$3:$I$10,Guide!D4,0)*B6,\"\")","v":129594},100000,{"$f":"IFERROR(IF(H6>Guide!I4,\"Check Limit\",VLOOKUP($D6,Rates!$S$3:$X$10,Guide!E4,0))*B6,\"\")","v":98896.325475618345},null,{"$f":"IFERROR(IF(J6>Guide!J4,\"Check Limit\",VLOOKUP($D6,Rates!$Z$3:$AE$10,Guide!F4,0))*B6,\"\")","v":""},null,{"$f":"IFERROR(IF(L6>Guide!K4,\"Check Limit\",VLOOKUP($D6,Rates!$AG$3:$AL$10,Guide!G4,0))*B6,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N6,Rates!$C$15:$H$16,2,0)*B6,\"\")","v":""}]
[null,1,null,"M+2",null,2000000,{"$f":"IFERROR(VLOOKUP($D7,Rates!$B$3:$I$10,Guide!D5,0)*B7,\"\")","v":84671},100000,{"$f":"IFERROR(IF(H7>Guide!I5,\"Check Limit\",VLOOKUP($D7,Rates!$S$3:$X$10,Guide!E5,0))*B7,\"\")","v":80107.30654895211},null,{"$f":"IFERROR(IF(J7>Guide!J5,\"Check Limit\",VLOOKUP($D7,Rates!$Z$3:$AE$10,Guide!F5,0))*B7,\"\")","v":""},null,{"$f":"IFERROR(IF(L7>Guide!K5,\"Check Limit\",VLOOKUP($D7,Rates!$AG$3:$AL$10,Guide!G5,0))*B7,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N7,Rates!$C$15:$H$16,2,0)*B7,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D8,Rates!$B$3:$I$10,Guide!D6,0)*B8,\"\")","v":""},null,{"$f":"IFERROR(IF(H8>Guide!I6,\"Check Limit\",VLOOKUP($D8,Rates!$S$3:$X$10,Guide!E6,0))*B8,\"\")","v":""},null,{"$f":"IFERROR(IF(J8>Guide!J6,\"Check Limit\",VLOOKUP($D8,Rates!$Z$3:$AE$10,Guide!F6,0))*B8,\"\")","v":""},null,{"$f":"IFERROR(IF(L8>Guide!K6,\"Check Limit\",VLOOKUP($D8,Rates!$AG$3:$AL$10,Guide!G6,0))*B8,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N8,Rates!$C$15:$H$16,2,0)*B8,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D9,Rates!$B$3:$I$10,Guide!D7,0)*B9,\"\")","v":""},null,{"$f":"IFERROR(IF(H9>Guide!I7,\"Check Limit\",VLOOKUP($D9,Rates!$S$3:$X$10,Guide!E7,0))*B9,\"\")","v":""},null,{"$f":"IFERROR(IF(J9>Guide!J7,\"Check Limit\",VLOOKUP($D9,Rates!$Z$3:$AE$10,Guide!F7,0))*B9,\"\")","v":""},null,{"$f":"IFERROR(IF(L9>Guide!K7,\"Check Limit\",VLOOKUP($D9,Rates!$AG$3:$AL$10,Guide!G7,0))*B9,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N9,Rates!$C$15:$H$16,2,0)*B9,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D10,Rates!$B$3:$I$10,Guide!D8,0)*B10,\"\")","v":""},null,{"$f":"IFERROR(IF(H10>Guide!I8,\"Check Limit\",VLOOKUP($D10,Rates!$S$3:$X$10,Guide!E8,0))*B10,\"\")","v":""},null,{"$f":"IFERROR(IF(J10>Guide!J8,\"Check Limit\",VLOOKUP($D10,Rates!$Z$3:$AE$10,Guide!F8,0))*B10,\"\")","v":""},null,{"$f":"IFERROR(IF(L10>Guide!K8,\"Check Limit\",VLOOKUP($D10,Rates!$AG$3:$AL$10,Guide!G8,0))*B10,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N10,Rates!$C$15:$H$16,2,0)*B10,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D11,Rates!$B$3:$I$10,Guide!D9,0)*B11,\"\")","v":""},null,{"$f":"IFERROR(IF(H11>Guide!I9,\"Check Limit\",VLOOKUP($D11,Rates!$S$3:$X$10,Guide!E9,0))*B11,\"\")","v":""},null,{"$f":"IFERROR(IF(J11>Guide!J9,\"Check Limit\",VLOOKUP($D11,Rates!$Z$3:$AE$10,Guide!F9,0))*B11,\"\")","v":""},null,{"$f":"IFERROR(IF(L11>Guide!K9,\"Check Limit\",VLOOKUP($D11,Rates!$AG$3:$AL$10,Guide!G9,0))*B11,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N11,Rates!$C$15:$H$16,2,0)*B11,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D12,Rates!$B$3:$I$10,Guide!D10,0)*B12,\"\")","v":""},null,{"$f":"IFERROR(IF(H12>Guide!I10,\"Check Limit\",VLOOKUP($D12,Rates!$S$3:$X$10,Guide!E10,0))*B12,\"\")","v":""},null,{"$f":"IFERROR(IF(J12>Guide!J10,\"Check Limit\",VLOOKUP($D12,Rates!$Z$3:$AE$10,Guide!F10,0))*B12,\"\")","v":""},null,{"$f":"IFERROR(IF(L12>Guide!K10,\"Check Limit\",VLOOKUP($D12,Rates!$AG$3:$AL$10,Guide!G10,0))*B12,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N12,Rates!$C$15:$H$16,2,0)*B12,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D13,Rates!$B$3:$I$10,Guide!D11,0)*B13,\"\")","v":""},null,{"$f":"IFERROR(IF(H13>Guide!I11,\"Check Limit\",VLOOKUP($D13,Rates!$S$3:$X$10,Guide!E11,0))*B13,\"\")","v":""},null,{"$f":"IFERROR(IF(J13>Guide!J11,\"Check Limit\",VLOOKUP($D13,Rates!$Z$3:$AE$10,Guide!F11,0))*B13,\"\")","v":""},null,{"$f":"IFERROR(IF(L13>Guide!K11,\"Check Limit\",VLOOKUP($D13,Rates!$AG$3:$AL$10,Guide!G11,0))*B13,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N13,Rates!$C$15:$H$16,2,0)*B13,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D14,Rates!$B$3:$I$10,Guide!D12,0)*B14,\"\")","v":""},null,{"$f":"IFERROR(IF(H14>Guide!I12,\"Check Limit\",VLOOKUP($D14,Rates!$S$3:$X$10,Guide!E12,0))*B14,\"\")","v":""},null,{"$f":"IFERROR(IF(J14>Guide!J12,\"Check Limit\",VLOOKUP($D14,Rates!$Z$3:$AE$10,Guide!F12,0))*B14,\"\")","v":""},null,{"$f":"IFERROR(IF(L14>Guide!K12,\"Check Limit\",VLOOKUP($D14,Rates!$AG$3:$AL$10,Guide!G12,0))*B14,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N14,Rates!$C$15:$H$16,2,0)*B14,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D15,Rates!$B$3:$I$10,Guide!D13,0)*B15,\"\")","v":""},null,{"$f":"IFERROR(IF(H15>Guide!I13,\"Check Limit\",VLOOKUP($D15,Rates!$S$3:$X$10,Guide!E13,0))*B15,\"\")","v":""},null,{"$f":"IFERROR(IF(J15>Guide!J13,\"Check Limit\",VLOOKUP($D15,Rates!$Z$3:$AE$10,Guide!F13,0))*B15,\"\")","v":""},null,{"$f":"IFERROR(IF(L15>Guide!K13,\"Check Limit\",VLOOKUP($D15,Rates!$AG$3:$AL$10,Guide!G13,0))*B15,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N15,Rates!$C$15:$H$16,2,0)*B15,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D16,Rates!$B$3:$I$10,Guide!D14,0)*B16,\"\")","v":""},null,{"$f":"IFERROR(IF(H16>Guide!I14,\"Check Limit\",VLOOKUP($D16,Rates!$S$3:$X$10,Guide!E14,0))*B16,\"\")","v":""},null,{"$f":"IFERROR(IF(J16>Guide!J14,\"Check Limit\",VLOOKUP($D16,Rates!$Z$3:$AE$10,Guide!F14,0))*B16,\"\")","v":""},null,{"$f":"IFERROR(IF(L16>Guide!K14,\"Check Limit\",VLOOKUP($D16,Rates!$AG$3:$AL$10,Guide!G14,0))*B16,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N16,Rates!$C$15:$H$16,2,0)*B16,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D17,Rates!$B$3:$I$10,Guide!D15,0)*B17,\"\")","v":""},null,{"$f":"IFERROR(IF(H17>Guide!I15,\"Check Limit\",VLOOKUP($D17,Rates!$S$3:$X$10,Guide!E15,0))*B17,\"\")","v":""},null,{"$f":"IFERROR(IF(J17>Guide!J15,\"Check Limit\",VLOOKUP($D17,Rates!$Z$3:$AE$10,Guide!F15,0))*B17,\"\")","v":""},null,{"$f":"IFERROR(IF(L17>Guide!K15,\"Check Limit\",VLOOKUP($D17,Rates!$AG$3:$AL$10,Guide!G15,0))*B17,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N17,Rates!$C$15:$H$16,2,0)*B17,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D18,Rates!$B$3:$I$10,Guide!D16,0)*B18,\"\")","v":""},null,{"$f":"IFERROR(IF(H18>Guide!I16,\"Check Limit\",VLOOKUP($D18,Rates!$S$3:$X$10,Guide!E16,0))*B18,\"\")","v":""},null,{"$f":"IFERROR(IF(J18>Guide!J16,\"Check Limit\",VLOOKUP($D18,Rates!$Z$3:$AE$10,Guide!F16,0))*B18,\"\")","v":""},null,{"$f":"IFERROR(IF(L18>Guide!K16,\"Check Limit\",VLOOKUP($D18,Rates!$AG$3:$AL$10,Guide!G16,0))*B18,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N18,Rates!$C$15:$H$16,2,0)*B18,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP($D19,Rates!$B$3:$I$10,Guide!D17,0)*B19,\"\")","v":""},null,{"$f":"IFERROR(IF(H19>Guide!I17,\"Check Limit\",VLOOKUP($D19,Rates!$S$3:$X$10,Guide!E17,0))*B19,\"\")","v":""},null,{"$f":"IFERROR(IF(J19>Guide!J17,\"Check Limit\",VLOOKUP($D19,Rates!$Z$3:$AE$10,Guide!F17,0))*B19,\"\")","v":""},null,{"$f":"IFERROR(IF(L19>Guide!K17,\"Check Limit\",VLOOKUP($D19,Rates!$AG$3:$AL$10,Guide!G17,0))*B19,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP($N19,Rates!$C$15:$H$16,2,0)*B19,\"\")","v":""}]
[]
[null,"Premium Sub-totals",null,null,null,null,{"$f":"SUM(G5:G19)","v":454040},null,{"$f":"SUM(I5:I19)","v":270383.63202457048},null,{"$f":"SUM(K5:K19)","v":0},null,{"$f":"SUM(M5:M19)","v":0},null,{"$f":"SUM(O5:O19)","v":0}]
[]
[]
[null,null,null,null,null,"Basic Premium:",{"$f":"SUM(G21,I21,K21,M21,O21)","v":724423.63202457048}]
[]
[null,null,null,null,null,"Levies @ 0.45% :",{"$f":"0.45%*G24","v":3259.9063441105677}]
[]
[null,null,null,null,null,"Stamp Duty:",40]
[]
[null,null,null,null,null,"Total Premium Payable:",{"$f":"SUM(G24:G28)","v":727723.5383686811}]
[]
[]
[null,"Quote issued by",":",null,null,"Samuel Mwangi",null,null,"Date:",{"$f":"TODAY()","v":"2025-04-28"}]
[]
[]
[null,"DOCUMENTATION REQUIRED AT THE POINT OF APPLYING FOR COVER"]
[null,"i)              Duly filled scheme Application Form by the scheme contact person or sponsor, signed and stamped."]
[null,"ii)             Duly filled and signed application form by each employee."]
[null,"iii)            Certificate of Incorporation/Registration , CR12 and KRA PIN Certificate for the group."]
[null,"iv)           Letter of appointment of the insurance agent or broker if any."]
[null,"v)            List of Members covered and dependents (where applicable) and relevant details. All employees or members of the organization must enrol."]
[null,"vi)           Company Logo for medical cards processing (Optional)"]
[null,"vii)           Proof of premium payment and the quotation. Cover will only commence after premiums payment."]
[]
[null,"GENERAL CONDITIONS"]
[]
[null,"i)      Eligibility is all persons and their legal dependants from age of zero (0) months to sixty five (65) years. Existing members can continue renewing in the "]
[null,"scheme up to the age of seventy (70 years)."]
[null,"ii)     Eligible dependents include one spouse, own children from the age of zero (0) months to eighteen years (18), or up to twenty five (25) years if "]
[null,"proof of schooling is provided. "]
[null,"iii)   Co-Pays apply as per the details on the benefits schedule provided in this brochure."]
[null,"iv)   A countrywide network of providers is accessible to members."]
[null,"v)   Waiting Periods have been waived under the product, provided the all the employees in of the organization taking cover are enrolled."]
[null,"vi)    All scheduled admissions must be pre authorised at least 48 hours prior to admission. "]
[null,"For emergency admissions the hospital should contact Old Mutual General Insurance within 48 hours of admission."]
[null,"vii)   All hospital bills shall be paid net of National Hospital Insurance Fund (NHIF) rebates as shall be advised from Old Mutual General Insurance."]
[null,"viii)  Medical cards must be presented at the accredited panel of service providers for access to service. Each member will also be required to "]
[null,"complete and sign a claim form."]
[null,"ix)    A member travelling outside the country will be eligible for emergency medical benefits up to a period of six (6) weeks in any one visit. "]
[null,"All medical expenses will be on reimbursement basis and will be within the acceptable guidelines of the customary and reasonable charges and "]
[null,"as per the policy terms and conditions. Travel and accommodation costs are not covered. "]

{"sheet":"Definitions","index":1,"n_rows":10,"n_cols":17,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CRITICAL ILLNESS"]
[null,null,"Family Sizes",null,"Inpatient Limits",null,"Outpatient Limits",null,"Dental Limits",null,"Optical Limits",null,"Maternity Limits",null,"Age Band","Member Only","Member Plus Family"]
[null,null,"M",null,250000,null,50000,null,10000,null,10000,null,50000,null,"19-29",1333,2000]
[null,null,"M+1",null,500000,null,100000,null,20000,null,20000,null,75000,null,"30-40",1890,2835]
[null,null,"M+2",null,1000000,null,150000,null,30000,null,30000,null,100000,null,"41-50",3637,5455]
[null,null,"M+3",null,2000000,null,200000,null,40000,null,40000,null,150000,null,"51-64",10159,15238]
[null,null,"M+4",null,3000000,null,250000,null,50000,null,50000,null,200000,null,"65 +",0,0]
[null,null,"M+5",null,5000000,null,null,null,null,null,null,null,300000]
[null,null,"M+6",null,10000000]

{"sheet":"Rates","index":2,"n_rows":40,"n_cols":38,"rows_kept":40,"cut":false,"hidden":true,"merged":[[1,18,1,23],[1,25,1,30],[1,32,1,37],[1,6,1,10],[13,1,13,6]]}
[null,"IP Row"]
[null,null,null,null,null,null,"INPATIENT",null,null,null,null,null,null,null,null,null,null,null,"OUTPATIENT",null,null,null,null,null,null,"DENTAL",null,null,null,null,null,null,"OPTICAL"]
[null," Family Size ",250000,500000,1000000,2000000,3000000,5000000,10000000,null,null,null,null,null,null,null,null,null,"Family Size",50000,100000,150000,200000,250000,null,"Family Size",10000,20000,30000,40000,50000,null,"Family Size",10000,20000,30000,40000,50000]
[1,"M",32139,34040,37595,43198,43811,53685,78010,null,null,null,null,null,null,null,null,1,"M",30344.639880819253,32965.441825206115,38284.05460902075,42238.560688665733,42504.578120152102,1,"M",1999.8999999999999,3329.8999999999996,6000.4,8617.6456543096283,9086.6147487306753,1,"M",4196.0772095636448,8425.4498628225701,10259.29096915628,11409.549567587232,12559.808166018185]
[2,"M+1",40529,45849,51066,62672,69729,96781,133688,null,null,null,null,null,null,null,null,2,"M+1",49999,60416.104731152976,69870.716930285969,77170.069918783585,80182.69635445936,2,"M+1",2886.1,6549.9426341724375,8657.5999999999985,14384.335906549335,16151.076091112425,2,"M+1",6609.1845093456195,11684.121244530023,14841.202154307277,16113.218261699687,17385.234369092097]
[3,"M+2",50464,58458,76833,84671,106121,140666,185048,null,null,null,null,null,null,null,null,3,"M+2",49999,80107.30654895211,88506.172507880998,94075.416894614231,99655.405815101258,3,"M+2",3917.2621252255376,9419.9749548553445,11612.446874275603,19083.563765709994,21995.041938899572,3,"M+2",8509.9410339145543,14210.611672246043,18355.293394190528,19687.301672260546,21019.309950330568]
[4,"M+3",63098,75633,102044,111661,141187,184884,239775,null,null,null,null,null,null,null,null,4,"M+3",49999,91380,106765.7910857161,115042.3425002477,119755.26587045948,4,"M+3",5135.7546883094728,12456.050284556464,15451.912069381853,24275.795229254938,28402.68916962923,4,"M+3",9999,17062.147034362777,22343.433381407613,23762.853978441355,25182.274575475094]
[5,"M+4",74459,92081,129722,139832,179040,228402,287428,null,null,null,null,null,null,null,null,5,"M+4",49999,96318,126085.88999913128,132050.26591112567,137343.88997089147,5,"M+4",6231.4949199705634,14940.01214388878,19124.964888137889,27828.728943798724,32936.026326367522,5,"M+4",9999,18784.709115104495,24685.067568446877,26096.662529595309,27508.257490743752]
[6,"M+5",86263,108684,156873,167750,216297,272070,336592,null,null,null,null,null,null,null,null,6,"M+5",49999,98648.25,136047.75674190471,160020.73552231726,155217.65871361329,6,"M+5",7371.359603865455,17622.436257815738,22857.836163018266,31970.923280803632,38143.101442886618,6,"M+5",9999,19999,27623.021628929229,29061.283565865167,30499.545502801102]
[7,"M+6",97618,125129,184559,195924,254158,315587,384222,null,null,null,null,null,null,null,null,7,"M+6",49999,99817.5,145288.88227100685,171453.63030784042,184703.62982590226,7,"M+6",8477.1107300362364,19999,26544.460510114652,35657.547627900014,42829.295333274596,7,"M+6",9999,19999,29999,31538.209978526633,32976.471915462564]
[null," Additional Premium per Member Above 50 ",19325,20381,22130,26417,31265,47336,70654,null,null,null,null,null,null,null,null,null,"Maximum Dental",10000,30000,40000,50000,50000]
[null,"Maximum OP",50000,100000,150000,200000,250000,250000,250000,null,null,null,null,null,null,null,null,null,"Maximum Optical",10000,30000,40000,50000,50000]
[null,null,2,{"$f":"C13+1","v":3},{"$f":"D13+1","v":4},5,6,7,8,null,null,null,null,null,null,null,null,null,null,2,{"$f":"T13+1","v":3},{"$f":"U13+1","v":4},5,6,null,null,2,{"$f":"AA13+1","v":3},{"$f":"AB13+1","v":4},5,6,null,null,2,{"$f":"AH13+1","v":3},{"$f":"AI13+1","v":4},5,6]
[null,"MATERNITY RATES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OP Limit",50000,100000,150000,200000,250000]
[null,"Maternity",50000,75000,100000,150000,200000,300000,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"T15+1","v":3},4,5,6]
[null,"Per Family",10482.944184832013,14482.944184832013,20482.944184832013,28292.660063369287,38471.211465159358,54828.314268739516]
[null,null,2,{"$f":"C17+1","v":3},{"$f":"D17+1","v":4},5,6,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Premium per Member Above 50",32740.651965959707,35568.39237315824,41306.962703223326,45573.716494319313,45860.738656235924]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Limited to OP Limit - 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Dental",10000,20000,30000,40000,50000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum Optical",10000,20000,30000,40000,50000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"T38+1","v":3},{"$f":"U38+1","v":4},{"$f":"V38+1","v":5},{"$f":"W38+1","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OP Limit",50000,100000,150000,200000,250000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"T40+1","v":3},{"$f":"U40+1","v":4},{"$f":"V40+1","v":5},{"$f":"W40+1","v":6}]

{"sheet":"Guide","index":3,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"IP Limit","OP Limit","Dental Limit","Optical Limit","Maternity Limit","Max OP","Max Dental","Max Optical"]
[]
[null,null,"Principal Member 1",{"$f":"HLOOKUP(Quote!F5,Rates!$C$3:$I$13,11,0)","v":8},{"$f":"HLOOKUP(Quote!H5,Rates!$S$3:$X$13,11,0)","v":3},{"$f":"HLOOKUP(Quote!J5,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L5,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N5,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F5,Rates!$C$3:$I$12,10,0)","v":250000},{"$f":"HLOOKUP(Quote!H5,Rates!$S$3:$X$12,9,0)","v":30000},{"$f":"HLOOKUP(Quote!H5,Rates!$S$3:$X$12,10,0)","v":30000}]
[null,null,"Principal Member 2",{"$f":"HLOOKUP(Quote!F6,Rates!$C$3:$I$13,11,0)","v":5},{"$f":"HLOOKUP(Quote!H6,Rates!$S$3:$X$13,11,0)","v":3},{"$f":"HLOOKUP(Quote!J6,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L6,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N6,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F6,Rates!$C$3:$I$12,10,0)","v":200000},{"$f":"HLOOKUP(Quote!H6,Rates!$S$3:$X$12,9,0)","v":30000},{"$f":"HLOOKUP(Quote!H6,Rates!$S$3:$X$12,10,0)","v":30000}]
[null,null,"Principal Member 3",{"$f":"HLOOKUP(Quote!F7,Rates!$C$3:$I$13,11,0)","v":5},{"$f":"HLOOKUP(Quote!H7,Rates!$S$3:$X$13,11,0)","v":3},{"$f":"HLOOKUP(Quote!J7,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L7,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N7,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F7,Rates!$C$3:$I$12,10,0)","v":200000},{"$f":"HLOOKUP(Quote!H7,Rates!$S$3:$X$12,9,0)","v":30000},{"$f":"HLOOKUP(Quote!H7,Rates!$S$3:$X$12,10,0)","v":30000}]
[null,null,"Principal Member 4",{"$f":"HLOOKUP(Quote!F8,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H8,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J8,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L8,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N8,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F8,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H8,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H8,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 5",{"$f":"HLOOKUP(Quote!F9,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H9,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J9,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L9,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N9,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F9,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H9,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H9,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 6",{"$f":"HLOOKUP(Quote!F10,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H10,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J10,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L10,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N10,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F10,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H10,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H10,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 7",{"$f":"HLOOKUP(Quote!F11,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H11,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J11,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L11,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N11,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F11,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H11,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H11,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 8",{"$f":"HLOOKUP(Quote!F12,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H12,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J12,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L12,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N12,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F12,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H12,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H12,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 9",{"$f":"HLOOKUP(Quote!F13,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H13,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J13,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L13,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N13,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F13,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H13,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H13,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 10",{"$f":"HLOOKUP(Quote!F14,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H14,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J14,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L14,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N14,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F14,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H14,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H14,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 11",{"$f":"HLOOKUP(Quote!F15,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H15,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J15,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L15,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N15,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F15,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H15,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H15,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 12",{"$f":"HLOOKUP(Quote!F16,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H16,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J16,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L16,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N16,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F16,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H16,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H16,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 13",{"$f":"HLOOKUP(Quote!F17,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H17,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J17,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L17,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N17,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F17,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H17,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H17,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 14",{"$f":"HLOOKUP(Quote!F18,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H18,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J18,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L18,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N18,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F18,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H18,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H18,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]
[null,null,"Principal Member 15",{"$f":"HLOOKUP(Quote!F19,Rates!$C$3:$I$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H19,Rates!$S$3:$X$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!J19,Rates!$Z$3:$AE$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!L19,Rates!$AG$3:$AL$13,11,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!N19,Rates!$C$15:$H$17,3,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!F19,Rates!$C$3:$I$12,10,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H19,Rates!$S$3:$X$12,9,0)","v":{"$error":"#N/A"}},{"$f":"HLOOKUP(Quote!H19,Rates!$S$3:$X$12,10,0)","v":{"$error":"#N/A"}}]