{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["QuotationTool","Lists","Sheet1","AfyaImaraJunior","PricingTable","BenefitsSchedule","BenefitsLookup","AfyaImara","AfyaImaraCounty","AfyaImaraSeniors","AfyaImaraExecutive"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"QuotationTool","index":0,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[31,2,31,4],[5,2,5,4],[0,4,3,9],[48,5,48,6],[4,2,4,8],[4,9,7,9],[13,3,13,5],[13,0,13,2],[13,6,13,9],[9,0,9,1],[44,0,44,1],[45,0,45,1],[34,0,34,1],[44,2,44,5],[45,2,45,5],[29,7,29,8],[9,3,9,4],[10,3,10,4],[11,3,11,4],[17,3,17,4],[12,3,12,4],[14,0,14,9],[10,6,10,9]]}
[null,null,null,null,"Old Mutual General Insurance Kenya Ltd,\nOld Mutual Tower| Upper Hill Road | PO Box 43013 | Nairobi 00100, Kenya \nTel + 254 2850 000 | Office Cell 0711 065 000 |\nWebsite www.oldmutual.co.ke \n"]
[]
[]
[]
[null,"Attn:","ABSOLOM IRUNGU",null,null,null,null,null,null,"[ Page 1/2 of Quotation ]"]
[null,"Date",{"$f":"TODAY()","v":"2025-04-07"}]
[]
[null,"RE:","AfyaImara",{"$f":"IF(OR(C8=Lists!B4,C8=Lists!B5,C8=Lists!B6,C8=Lists!B8),\"Family Cover\",\"Children Cover\")","v":"Family Cover"}]
[]
["Cover Scope",null,"Inpatient",10000000,null,{"$f":"IFERROR(VLOOKUP(D10,Lists!$I$5:$J$33,2,FALSE),\"Limit not Available\")","v":"    Per Family Per Annum"}]
[null,null,"Outpatient",100000,null,"Per Person Per Annum",{"$f":"IFERROR(IF(D11>VLOOKUP(D10,Lists!$I$5:$K$13,3,0),\"This OP Limit is not available for the selected IP Limit\",\"\"),\"Please select IP Limit\")","v":""}]
[null,null,"Family Size","M+3"]
[null,null,{"$f":"IF(C8=\"AfyaImara Seniors\",\"Dental & Optical\",\"\")","v":""}]
["Cover Option for Junior Only:",null,null,null,null,null,{"$f":"IF(AND($C$8<>Lists!$B$7,QuotationTool!D14<>\"\"),\"Please delete this cover option\",\"\")","v":""}]
["[ Schedule Of Benefits Slected Above Detailed in PAGE 2]"]
[]
["Premiums For Selected Benefits above"]
[null,"Relation","Name","DOB / Age",null,"Inpatient","Individual\nOP Option","Outpatient",null,"Total"]
[1,"Principal",null,"Age","1900-02-11",{"$f":"IF(B19=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B19&Sheet1!D19&Sheet1!B19,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":68869.84375},"Yes",{"$f":"IF(OR(B19=\"\",G19=\"No\",G19=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B19&Sheet1!D19&Sheet1!B19,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B19&Sheet1!D19&Sheet1!B19,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":35226},null,{"$f":"SUM(F19,H19)","v":104095.84375}]
[2,"Spouse",null,"Age","1900-02-08",{"$f":"IF(B20=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B20&Sheet1!D20&Sheet1!B20,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":48736},"Yes",{"$f":"IF(OR(B20=\"\",G20=\"No\",G20=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B20&Sheet1!D20&Sheet1!B20,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B20&Sheet1!D20&Sheet1!B20,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":35226},null,{"$f":"SUM(F20,H20)","v":83962}]
[3,"Child",null,"Age","1900-01-14",{"$f":"IF(B21=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B21&Sheet1!D21&Sheet1!B21,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":31578},"Yes",{"$f":"IF(OR(B21=\"\",G21=\"No\",G21=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B21&Sheet1!D21&Sheet1!B21,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B21&Sheet1!D21&Sheet1!B21,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":35226},null,66804]
[4,"Child",null,"Age","1900-01-07",{"$f":"IF(B22=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B22&Sheet1!D22&Sheet1!B22,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":31578},"Yes",{"$f":"IF(OR(B22=\"\",G22=\"No\",G22=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B22&Sheet1!D22&Sheet1!B22,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B22&Sheet1!D22&Sheet1!B22,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":35226},null,66804]
[5,null,null,null,null,{"$f":"IF(B23=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B23&Sheet1!D23&Sheet1!B23,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":""},null,{"$f":"IF(OR(B23=\"\",G23=\"No\",G23=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B23&Sheet1!D23&Sheet1!B23,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B23&Sheet1!D23&Sheet1!B23,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":""},null,0]
[6,null,null,null,null,{"$f":"IF(B24=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B24&Sheet1!D24&Sheet1!B24,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":""},null,{"$f":"IF(OR(B24=\"\",G24=\"No\",G24=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B24&Sheet1!D24&Sheet1!B24,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B24&Sheet1!D24&Sheet1!B24,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":""},null,0]
[7,null,null,null,null,{"$f":"IF(B25=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B25&Sheet1!D25&Sheet1!B25,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":""},null,{"$f":"IF(OR(B25=\"\",G25=\"No\",G25=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B25&Sheet1!D25&Sheet1!B25,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B25&Sheet1!D25&Sheet1!B25,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":""},null,{"$f":"SUM(F25,H25)","v":0}]
[8,null,null,null,null,{"$f":"IF(B26=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B26&Sheet1!D26&Sheet1!B26,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":""},null,{"$f":"IF(OR(B26=\"\",G26=\"No\",G26=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B26&Sheet1!D26&Sheet1!B26,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B26&Sheet1!D26&Sheet1!B26,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":""},null,{"$f":"SUM(F26,H26)","v":0}]
[9,null,null,null,null,{"$f":"IF(B27=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B27&Sheet1!D27&Sheet1!B27,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":""},null,{"$f":"IF(OR(B27=\"\",G27=\"No\",G27=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B27&Sheet1!D27&Sheet1!B27,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B27&Sheet1!D27&Sheet1!B27,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":""},null,{"$f":"SUM(F27,H27)","v":0}]
[10,null,null,null,null,{"$f":"IF(B28=\"\",\"\",IFERROR(VLOOKUP($C$8&$D$14&B28&Sheet1!D28&Sheet1!B28,PricingTable!$F:$N,MATCH(QuotationTool!$D$10,PricingTable!$F$3:$N$3,0),FALSE),\"\"))","v":""},null,{"$f":"IF(OR(B28=\"\",G28=\"No\",G28=\"\"),\"\",IF($C$8=Lists!$B$7,IFERROR(VLOOKUP($C$8&$D$14&B28&Sheet1!D28&Sheet1!B28,PricingTable!$F$32:$W$53,MATCH(QuotationTool!$D$11,PricingTable!$F$32:$W$32,0),FALSE),\"\"),IF($C$8=Lists!$B$8,IFERROR(VLOOKUP($C$8&$D$14&B28&Sheet1!D28&Sheet1!B28,PricingTable!$F$54:$W$65,MATCH(QuotationTool!$D$11,PricingTable!$F$54:$W$54,0),FALSE),\"\"),IF($F$11=\"Per Family Per Annum\",\"\",IFERROR(VLOOKUP($C$8,PricingTable!$AU$5:$BC$10,PricingTable!$AV$3,FALSE),\"\")))))","v":""},null,0]
[null,null,null,null,null,null,{"$f":"IF(OR($C$8=Lists!$B$7,$C$8=Lists!$B$8),\"\",IF($F$11=\"Per Family Per Annum\",\"OP Per Family\",\"\"))","v":""},{"$f":"IF(OR(G29=\"\"),\"\",IFERROR(VLOOKUP(C8&D12,PricingTable!$AG:$AQ,PricingTable!$AI$3,FALSE),\"\"))","v":""},null,{"$f":"H29","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C8=\"AfyaImara Seniors\",\"Dental & Optical:\",\"\")","v":""},null,{"$f":"IF(AND(C8=\"AfyaImara Seniors\",D13=\"Yes\"),32352,0)","v":0}]
[null,null,null,null,null,null,"Total Premiums",null,null,{"$f":"SUM(J19:J30,F30)","v":321665.84375}]
[null,null,null,null,null,null,"Stamp Duty",null,"Yes",{"$f":"IF(I32=\"Yes\",40,0)","v":40}]
[null,null,null,null,null,null," TL & PHPF - 0.45% ",null,null,{"$f":"J31*0.45%","v":1447.4962968750001}]
[null,null,null,null,null,null,"Total Payable",null,null,{"$f":"SUM(J31:J33)","v":323153.340046875}]
["Notes:"]
[{"$f":"IF(VLOOKUP(Sheet1!F36,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(Sheet1!F36,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE))","v":"a) AFYAIMARA is a Comprehensive Family cover, Providing Inpatient and Outpatient Benefits"}]
[{"$f":"IF(VLOOKUP(Sheet1!F37,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(Sheet1!F37,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE))","v":"b) A Waiting Period of 28 Days for Illness Claims and 60 Days for Surgical Claims Applies. Accidents are covered immediately."}]
[{"$f":"IF(VLOOKUP(Sheet1!F38,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(Sheet1!F38,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE))","v":"c) Applicants Above 60 Years are required to submit a medical report in the prescribed manner for eligibility"}]
[{"$f":"IF(VLOOKUP(Sheet1!F39,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(Sheet1!F39,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE))","v":"d) Eligibility is for applicants from 0-65 Years of age. Existing members can continue renewing in the scheme for life subject to renewal review by Old Mutual General Insurance Company Ltd."}]
[{"$f":"IF(VLOOKUP(Sheet1!F40,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(Sheet1!F40,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE))","v":"e) A Co-Pay of KES 500 is applicable in all visits. KES 2,000 Co-Pay is applicable at Aga Khan Hospital - Nairobi, Nairobi Hospital,Pandya Hospital,Karen Hospital,AAR and MP Shah"}]
[{"$f":"IF(VLOOKUP(Sheet1!F41,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(Sheet1!F41,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE))","v":"f) Application Forms Must be dully filled and Submitted for Processing & Consideration."}]
[{"$f":"IF(VLOOKUP(Sheet1!F42,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(Sheet1!F42,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE))","v":"g) Premiums: Payment be paid in full to activate cover, unless a payment plan is approved."}]
[{"$f":"IF(VLOOKUP(Sheet1!F43,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(Sheet1!F43,Lists!$AB$2:$AG$13,MATCH(QuotationTool!$C$8,Lists!$AB$2:$AG$2,0),FALSE))","v":"h) Critical Illness lumpsum payment of KES 750,000 is payable upon first positive diagnosis for Cancer, stroke, heart attack, renal/kidney failure, paraplegia or paralysis. This embedded cover  has a 28-day waiting period."}]
[]
["Issued By;",null,"Samuel Maina"]
["Designation",null,"Business Development Manager"]
["For: Old Mutual Group"]
[]
[null,null,{"$f":"\"          This Quote is Valid for 90 Days up to  \"","v":"          This Quote is Valid for 90 Days up to  "},null,null,{"$f":"TODAY()+90","v":"2025-07-06"}]

{"sheet":"Lists","index":1,"n_rows":63,"n_cols":33,"rows_kept":63,"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":"B4","v":"AfyaImara"},{"$f":"B5","v":"AfyaImara County"},{"$f":"B6","v":"AfyaImara Seniors"},{"$f":"B7","v":"AfyaImara Junior"},{"$f":"B8","v":"AfyaImara Executive"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product","Option","Combination","Inpatient Options","Outpatient Options","Maternity Options","Dental & Optical","OP Limit",null,null,null,1,"a) AFYAIMARA is a Comprehensive Family cover, Providing Inpatient and Outpatient Benefits","a) AFYAIMARA COUNTY is a LOW COST Comprehensive Family cover, Providing Inpatient  & Outpatient Benefits","a) AFYAIMARA SENIORS is a Comprehensive Individual Cover, Providing Inpatient and Optional Outpatient Benefits","a) AFYAIMARA JUNIOR is a Comprehensive CHILDREN COVER, Providing Inpatient and Outpatient benefits.","a) AFYAIMARA EXECUTIVE is a Comprehensive Individual Cover, Providing Inpatient and Optional Outpatient Benefits"]
[null,"AfyaImara",null,null,null,"Limits","Product","Option",null,null,null,null,null,null,"Ages",null,"AfyaImara",1,{"$f":"Q4&R4","v":"AfyaImara1"},500000,50000,40000,"15,000 Each",60000,null,null,null,2,"b) A Waiting Period of 28 Days for Illness Claims and 60 Days for Surgical Claims Applies. Accidents are covered immediately.","b) A Waiting Period of 28 Days for Illness Claims and 60 Days for Surgical Claims Applies. Accidents are covered immediately.","b) Cover is Designed for SENIOR CITIZENS above 65 Years.","b) Cover is Designed for Children, 18 Years and Below.","b) Cover is Designed to offer High Cover Limits, Comprehensive Provider Access Across and WorldWide Cover Scope"]
[null,"AfyaImara County",null,null,null,"Inpatient",{"$f":"QuotationTool!$C$8","v":"AfyaImara"},null," - Select - ",null,"OP Limit",null,null,null,"Child (0 -18 yrs)",null,"AfyaImara",2,{"$f":"Q5&R5","v":"AfyaImara2"},1000000,60000,75000,"30,000 Dental & 25,000 Optical",60000,null,null,null,3,"c) Applicants Above 60 Years are required to submit a medical report in the prescribed manner for eligibility","c) Applicants Above 60 Years are required to submit a medical report in the prescribed manner for eligibility","c) Eligibility is for applicants from 65-80 Years of age. One can then renew cover for LIFE.","c) A Waiting Period of 28 Days for Illness Claims and 60 Days for Surgical Claims Applies. Accidents are covered immediately.","c) Eligibility is for applicants from 0-80 Years of age. One can renew cover until the age of 85 years."]
[null,"AfyaImara Seniors",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},1,{"$f":"IFERROR(VLOOKUP(G6&H6,$S$3:$T$24,2,FALSE),\"\")","v":500000},"    Per Family Per Annum",{"$f":"IFERROR(VLOOKUP(G6&H6,$S$3:$X$24,6,FALSE),\"\")","v":60000},null,null,null,"19 yrs - 29 yrs",null,"AfyaImara",3,{"$f":"Q6&R6","v":"AfyaImara3"},3000000,100000,100000,null,100000,null,null,null,4,"d) Eligibility is for applicants from 0-65 Years of age. Existing members can continue renewing in the scheme for life subject to renewal review by Old Mutual General Insurance Company Ltd.","d) Eligibility is for applicants from 0-65 Years of age. One can renew cover until age 70, where they may transition to AfyaImara Seniors","d) Applicants are required to submit a medical report in the prescribed manner for eligibility","d) Application Forms Must be dully filled and Submitted for Processing & Consideration.","d) Applicants Above 60 Years are required to submit a medical report in the prescribed manner for eligibility"]
[null,"AfyaImara Junior",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},2,{"$f":"IFERROR(VLOOKUP(G7&H7,$S$3:$T$24,2,FALSE),\"\")","v":1000000},"    Per Family Per Annum",{"$f":"IFERROR(VLOOKUP(G7&H7,$S$3:$X$24,6,FALSE),\"\")","v":60000},null,null,null,"30 yrs - 40 yrs",null,"AfyaImara",4,{"$f":"Q7&R7","v":"AfyaImara4"},5000000,150000,null,null,200000,null,null,null,5,"e) A Co-Pay of KES 500 is applicable in all visits. KES 2,000 Co-Pay is applicable at Aga Khan Hospital - Nairobi, Nairobi Hospital,Pandya Hospital,Karen Hospital,AAR and MP Shah","e) A Co-Pay of KES 200 is applicable in all visits.","e) A Waiting Period of 28 Days for Illness Claims and 60 Days for Surgical Claims Applies. Accidents are covered immediately.","e) Premiums: Payment be paid in full to activate cover, unless a payment plan is approved.","e) A Waiting Period of 28 Days for Illness Claims and 60 Days for Surgical Claims Applies. Accidents are covered immediately."]
[null,"AfyaImara Executive",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},3,3000000,"    Per Family Per Annum",100000,null,null,null,"41 yrs - 50 yrs",null,"AfyaImara",5,{"$f":"Q8&R8","v":"AfyaImara5"},10000000,200000,null,null,200000,null,null,null,6,"f) Application Forms Must be dully filled and Submitted for Processing & Consideration.","f) Application Forms Must be dully filled and Submitted for Processing & Consideration.","f) A Co-Pay of Kes 1,000 is applicable in all visits.","f) Services provided under this product can be accessed on the Hospital Network specified under each option below","f) Application Forms Must be dully filled and Submitted for Processing & Consideration."]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},4,5000000,"    Per Family Per Annum",200000,null,null,null,"51 yrs - 65 yrs",null,null,null,null,null,null,null,null,null,null,null,null,7,"g) Premiums: Payment be paid in full to activate cover, unless a payment plan is approved.","g) Premiums: Payment be paid in full to activate cover, unless a payment plan is approved.","f) Application Forms Must be dully filled and Submitted for Processing & Consideration.","*Unlimited Panel Option","g) Premiums: Payment be paid in full to activate cover, unless a payment plan is approved."]
[null,"Principal",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},5,10000000,"    Per Family Per Annum",200000,null,null,null,"66 Years and Above",null,{"$f":"$B$5","v":"AfyaImara County"},1,{"$f":"Q10&R10","v":"AfyaImara County1"},100000,25000,20000,null,25000,null,null,null,8,"h) Critical Illness lumpsum payment of KES 750,000 is payable upon first positive diagnosis for Cancer, stroke, heart attack, renal/kidney failure, paraplegia or paralysis. This embedded cover  has a 28-day waiting period.","  ","h) Premiums: Payment be paid in full to activate cover, unless a payment plan is approved.","*Gertrude's Hospital Option"]
[null,"Spouse",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},6,"","    Per Family Per Annum","",null,null,null,null,null,{"$f":"$B$5","v":"AfyaImara County"},2,"AfyaImara County2",250000,40000,40000,null,40000,null,null,null,9,"  ","  ","  ","  ","  "]
[null,"Child",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},7,"","    Per Family Per Annum","",null,null,null,null,null,{"$f":"$B$5","v":"AfyaImara County"},3,"AfyaImara County3",500000,50000,null,null,50000,null,null,null,10,"  ","  ","  ","  ","  "]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},8,"","    Per Family Per Annum","",null,null,null,null,null,{"$f":"$B$5","v":"AfyaImara County"},4,"AfyaImara County4",1000000,null,null,null,50000,null,null,null,11,"  ","  ","  ","  ","  "]
[null,null,null,null,null,"Outpatient",{"$f":"QuotationTool!$C$8","v":"AfyaImara"},null," - Select - ",null,null,null,null,null,null,null,{"$f":"$B$6","v":"AfyaImara Seniors"},1,"AfyaImara Seniors1",500000,100000,null,null,100000,null,null,null,null,null,null,null,"  "]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},1,{"$f":"IF(G15=\"AfyaImara Executive\",200000,IFERROR(VLOOKUP(G15&H15,$S$4:$U$24,3,FALSE),\"\"))","v":50000},"Per Person Per Annum",null,null,null,null,null,null,{"$f":"$B$6","v":"AfyaImara Seniors"},2,"AfyaImara Seniors2",1000000,150000,null,null,150000,null,null,null,"Hospital List"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},2,{"$f":"IF(G15=\"AfyaImara Executive\",250000,IFERROR(VLOOKUP(G16&H16,$S$4:$U$24,3,FALSE),\"\"))","v":60000},"Per Family Per Annum",null,null,null,null,null,null,{"$f":"$B$6","v":"AfyaImara Seniors"},3,"AfyaImara Seniors3",3000000,200000,null,null,200000,null,null,null,1,null,null,null,"Unlimited UAP Hospital Panel Access"]
[null,"Designations",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},3,{"$f":"IFERROR(VLOOKUP(G17&H17,$S$4:$U$24,3,FALSE),\"\")","v":100000},null,null,null,null,null,null,null,{"$f":"$B$6","v":"AfyaImara Seniors"},4,"AfyaImara Seniors4",5000000,null,null,null,200000,null,null,null,2,null,null,null,"Limited Hospital Panel Access"]
[null,"Agent",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},4,150000,null,null,null,null,null,null,null,{"$f":"$B$6","v":"AfyaImara Seniors"},5,{"$f":"Q18&R18","v":"AfyaImara Seniors5"},10000000,null,null,null,200000]
[null,"Business Development Officer",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},5,200000,null,null,null,null,null,null,null,{"$f":"$B$7","v":"AfyaImara Junior"},1,{"$f":"Q19&R19","v":"AfyaImara Junior1"},500000,50000,null,null,50000]
[null,"Unit Manager",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},6,"",null,null,null,null,null,null,null,{"$f":"$B$7","v":"AfyaImara Junior"},2,"AfyaImara Junior2",1000000,75000,null,null,75000]
[null,"Sales Advisor",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},7,"",null,null,null,null,null,null,null,{"$f":"$B$7","v":"AfyaImara Junior"},3,"AfyaImara Junior3",3000000,100000,null,null,100000]
[null,"Financial Advisor",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},8,"",null,null,null,null,null,null,null,{"$f":"$B$7","v":"AfyaImara Junior"},4,"AfyaImara Junior4",5000000,150000,null,null,150000]
[null,"Business Development Manager",null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},9,"",null,null,null,null,null,null,null,{"$f":"$B$8","v":"AfyaImara Executive"},1,"AfyaImara Executive1",10000000,250000,null,null,250000]
[null,"Retail Manager",null,null,null,"Maternity",{"$f":"QuotationTool!$C$8","v":"AfyaImara"},null," - Select - ",null,null,null,null,null,null,null,{"$f":"$B$8","v":"AfyaImara Executive"},2,"AfyaImara Executive2",20000000,250000,null,null,250000]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},1,{"$f":"IFERROR(VLOOKUP(G25&H25,$S$3:$V$24,4,FALSE),\"\")","v":40000},"    Per Family Per Annum",null,null,null,null,null,null,"Relation"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},2,{"$f":"IFERROR(VLOOKUP(G26&H26,$S$3:$V$24,4,FALSE),\"\")","v":75000},"    Per Family Per Annum",null,null,null,null,null,null,"Product","Option","Comb","Relation Options"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},3,100000,"    Per Family Per Annum",null,null,null,null,null,null,"AfyaImara",1,{"$f":"Q27&R27","v":"AfyaImara1"},"Principal"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},4,0,"    Per Family Per Annum",null,null,null,null,null,null,"AfyaImara",2,"AfyaImara2","Spouse"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},5,0,null,null,null,null,null,null,null,"AfyaImara",3,"AfyaImara3","Child"]
[null,null,null,null,null,"Dental & Optical",{"$f":"QuotationTool!$C$8","v":"AfyaImara"},null," - Select - ",null,null,null,null,null,null,null,{"$f":"$B$7","v":"AfyaImara Junior"},1,"AfyaImara Junior1","Principal"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},1,{"$f":"IFERROR(VLOOKUP(G31&H31,$S$3:$W$24,5,FALSE),\"\")","v":"15,000 Each"},"    Per Person Per Annum",null,null,null,null,null,null,{"$f":"$B$7","v":"AfyaImara Junior"},2,"AfyaImara Junior2","Child 1"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},2,{"$f":"IFERROR(VLOOKUP(G32&H32,$S$3:$W$24,5,FALSE),\"\")","v":"30,000 Dental & 25,000 Optical"},"    Per Person Per Annum",null,null,null,null,null,null,{"$f":"$B$7","v":"AfyaImara Junior"},3,"AfyaImara Junior3","Child 2"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},3,0,null,null,null,null,null,null,null,"AfyaImara Junior",4,"AfyaImara Junior4","Child 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior",5,"AfyaImara Junior5","Child 4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior",6,"AfyaImara Junior6","Child 5"]
[null,null,null,null,null,"Relation","Product","Option","Relation",null,null,null,null,null,null,null,"AfyaImara Junior",7,"AfyaImara Junior7","Child 6"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},1,{"$f":"IFERROR(VLOOKUP(G37&H37,S26:T49,2,FALSE),\"\")","v":"Principal"},null,null,null,null,null,null,null,"AfyaImara Junior",8,"AfyaImara Junior8","Child 7"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},2,{"$f":"IFERROR(VLOOKUP(G38&H38,S27:T49,2,FALSE),\"\")","v":"Spouse"},null,null,null,null,null,null,null,"AfyaImara Junior",9,"AfyaImara Junior9","Child 8"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},3,{"$f":"IFERROR(VLOOKUP(G39&H39,S28:T49,2,FALSE),\"\")","v":"Child"},null,null,null,null,null,null,null,"AfyaImara Junior",10,"AfyaImara Junior10","Child 9"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},4,{"$f":"IFERROR(VLOOKUP(G40&H40,S29:T50,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"AfyaImara Junior",11,"AfyaImara Junior11","Child 10"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},5,{"$f":"IFERROR(VLOOKUP(G41&H41,S30:T51,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$B$6","v":"AfyaImara Seniors"},1,"AfyaImara Seniors1","Principal"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},6,{"$f":"IFERROR(VLOOKUP(G42&H42,S31:T52,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$B$6","v":"AfyaImara Seniors"},2,"AfyaImara Seniors2","Spouse"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},7,{"$f":"IFERROR(VLOOKUP(G43&H43,S32:T53,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$B$6","v":"AfyaImara Seniors"},3,"AfyaImara Seniors3","Child"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},8,{"$f":"IFERROR(VLOOKUP(G44&H44,S33:T60,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"AfyaImara County",1,"AfyaImara County1","Principal"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},9,{"$f":"IFERROR(VLOOKUP(G45&H45,S34:T61,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"AfyaImara County",2,"AfyaImara County2","Spouse"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},10,{"$f":"IFERROR(VLOOKUP(G46&H46,S35:T62,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,"AfyaImara County",3,"AfyaImara County3","Child"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$8","v":"AfyaImara Executive"},1,"AfyaImara Executive1","Principal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$8","v":"AfyaImara Executive"},2,"AfyaImara Executive2","Spouse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$B$8","v":"AfyaImara Executive"},3,"AfyaImara Executive3","Child"]
[null,null,null,null,null,"Hospital Access"]
[null,null,null,null,null,"Notes","Product","Option","Note"]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},1,{"$f":"IF(VLOOKUP(H52,$AB$16:$AG$17,MATCH(G52,$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(H52,$AB$16:$AG$17,MATCH(G52,$AB$2:$AG$2,0),FALSE))","v":""}]
[null,null,null,null,null,null,{"$f":"QuotationTool!$C$8","v":"AfyaImara"},2,{"$f":"IF(VLOOKUP(H53,$AB$16:$AG$17,MATCH(G53,$AB$2:$AG$2,0),FALSE)=0,\"\",VLOOKUP(H53,$AB$16:$AG$17,MATCH(G53,$AB$2:$AG$2,0),FALSE))","v":""}]
[]
[]
[null,"AGE RANGES"]
[null,"AfyaImara","AfyaImara County","AfyaImara Seniors","AfyaImara Junior","AfyaImara Executive"]
[null,"Child (0 -18 yrs)","Child (0 -18 yrs)"]
[null,"19 yrs - 29 yrs","19 yrs - 29 yrs"]
[null,"30 yrs - 40 yrs","30 yrs - 40 yrs"]
[null,"41 yrs - 50 yrs","41 yrs - 50 yrs"]
[null,"51 yrs - 65 yrs","51 yrs - 70 yrs"]
[null,"66 Years and Above"]

{"sheet":"Sheet1","index":2,"n_rows":43,"n_cols":13,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[null," - Product - HospitalAccess- Relation - Age Band - ChildNo"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," - How Age is computed"]
[null,null,null,null,null,null,null,null,null,null," - Combination"]
[null,null,null,null,null,null,null,null,null,null," - Combination in rates table"]
[null,null,null,null,null,null,null,null,null,null," - Lookup benefits"]
[null,null,null,null,null,null,null,null,null,null," - Test"]
[null,"Count of Child","Comp Age","Age-Band",null,null,null,null,null,null," - add logo, and look"]
[null,{"$f":"IF(QuotationTool!B19=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B19,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D19=\"Age\",QuotationTool!E19,(TODAY()-QuotationTool!E19)/365)","v":42},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B19<>\"\",C19>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B19<>\"\",C19>=65),\"65 Years and Above\",IF(QuotationTool!B19=\"\",\"\",IF(AND(C19>0,C19<19),Lists!$O$5,IF(AND(C19>=19,C19<30),Lists!$O$6,IF(AND(C19>=30,C19<41),Lists!$O$7,IF(AND(C19>=41,C19<51),Lists!$O$8,IF(AND(C19>=51,C19<=65),Lists!$O$9,IF(AND(C19>=66),Lists!$O$10,\"Check Age\")))))))))","v":"41 yrs - 50 yrs"},null,null,null,null,null,null," - add printing"]
[null,{"$f":"IF(QuotationTool!B20=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B20,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D20=\"Age\",QuotationTool!E20,(TODAY()-QuotationTool!E20)/365)","v":39},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B20<>\"\",C20>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B20<>\"\",C20>=65),\"65 Years and Above\",IF(QuotationTool!B20=\"\",\"\",IF(AND(C20>0,C20<19),Lists!$O$5,IF(AND(C20>=19,C20<30),Lists!$O$6,IF(AND(C20>=30,C20<41),Lists!$O$7,IF(AND(C20>=41,C20<51),Lists!$O$8,IF(AND(C20>=51,C20<=65),Lists!$O$9,IF(AND(C20>=66),Lists!$O$10,\"Check Age\")))))))))","v":"30 yrs - 40 yrs"},null,null,null,null,null,null," - test"]
[null,{"$f":"IF(QuotationTool!B21=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B21,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D21=\"Age\",QuotationTool!E21,(TODAY()-QuotationTool!E21)/365)","v":14},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B21<>\"\",C21>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B21<>\"\",C21>=65),\"65 Years and Above\",IF(QuotationTool!B21=\"\",\"\",IF(AND(C21>0,C21<19),Lists!$O$5,IF(AND(C21>=19,C21<30),Lists!$O$6,IF(AND(C21>=30,C21<41),Lists!$O$7,IF(AND(C21>=41,C21<51),Lists!$O$8,IF(AND(C21>=51,C21<=65),Lists!$O$9,IF(AND(C21>=66),Lists!$O$10,\"Check Age\")))))))))","v":"Child (0 -18 yrs)"},null,null,null,null,null,null," - complete"]
[null,{"$f":"IF(QuotationTool!B22=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B22,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D22=\"Age\",QuotationTool!E22,(TODAY()-QuotationTool!E22)/365)","v":7},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B22<>\"\",C22>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B22<>\"\",C22>=65),\"65 Years and Above\",IF(QuotationTool!B22=\"\",\"\",IF(AND(C22>0,C22<19),Lists!$O$5,IF(AND(C22>=19,C22<30),Lists!$O$6,IF(AND(C22>=30,C22<41),Lists!$O$7,IF(AND(C22>=41,C22<51),Lists!$O$8,IF(AND(C22>=51,C22<=65),Lists!$O$9,IF(AND(C22>=66),Lists!$O$10,\"Check Age\")))))))))","v":"Child (0 -18 yrs)"}]
[null,{"$f":"IF(QuotationTool!B23=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B23,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D23=\"Age\",QuotationTool!E23,(TODAY()-QuotationTool!E23)/365)","v":125.35342465753425},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B23<>\"\",C23>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B23<>\"\",C23>=65),\"65 Years and Above\",IF(QuotationTool!B23=\"\",\"\",IF(AND(C23>0,C23<19),Lists!$O$5,IF(AND(C23>=19,C23<30),Lists!$O$6,IF(AND(C23>=30,C23<41),Lists!$O$7,IF(AND(C23>=41,C23<51),Lists!$O$8,IF(AND(C23>=51,C23<=65),Lists!$O$9,IF(AND(C23>=66),Lists!$O$10,\"Check Age\")))))))))","v":""}]
[null,{"$f":"IF(QuotationTool!B24=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B24,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D24=\"Age\",QuotationTool!E24,(TODAY()-QuotationTool!E24)/365)","v":125.35342465753425},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B24<>\"\",C24>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B24<>\"\",C24>=65),\"65 Years and Above\",IF(QuotationTool!B24=\"\",\"\",IF(AND(C24>0,C24<19),Lists!$O$5,IF(AND(C24>=19,C24<30),Lists!$O$6,IF(AND(C24>=30,C24<41),Lists!$O$7,IF(AND(C24>=41,C24<51),Lists!$O$8,IF(AND(C24>=51,C24<=65),Lists!$O$9,IF(AND(C24>=66),Lists!$O$10,\"Check Age\")))))))))","v":""},null,null,null,null,null,null,"CRITICAL ILLNESS","Principal Member Rate"]
[null,{"$f":"IF(QuotationTool!B25=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B25,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D25=\"Age\",QuotationTool!E25,(TODAY()-QuotationTool!E25)/365)","v":125.35342465753425},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B25<>\"\",C25>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B25<>\"\",C25>=65),\"65 Years and Above\",IF(QuotationTool!B25=\"\",\"\",IF(AND(C25>0,C25<19),Lists!$O$5,IF(AND(C25>=19,C25<30),Lists!$O$6,IF(AND(C25>=30,C25<41),Lists!$O$7,IF(AND(C25>=41,C25<51),Lists!$O$8,IF(AND(C25>=51,C25<=65),Lists!$O$9,IF(AND(C25>=66),Lists!$O$10,\"Check Age\")))))))))","v":""},null,null,null,null,null,null,"Age Band"]
[null,{"$f":"IF(QuotationTool!B26=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B26,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D26=\"Age\",QuotationTool!E26,(TODAY()-QuotationTool!E26)/365)","v":125.35342465753425},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B26<>\"\",C26>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B26<>\"\",C26>=65),\"65 Years and Above\",IF(QuotationTool!B26=\"\",\"\",IF(AND(C26>0,C26<19),Lists!$O$5,IF(AND(C26>=19,C26<30),Lists!$O$6,IF(AND(C26>=30,C26<41),Lists!$O$7,IF(AND(C26>=41,C26<51),Lists!$O$8,IF(AND(C26>=51,C26<=65),Lists!$O$9,IF(AND(C26>=66),Lists!$O$10,\"Check Age\")))))))))","v":""},null,null,null,null,null,null,"19-29",2000,2000]
[null,{"$f":"IF(QuotationTool!B27=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B27,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D27=\"Age\",QuotationTool!E27,(TODAY()-QuotationTool!E27)/365)","v":125.35342465753425},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B27<>\"\",C27>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B27<>\"\",C27>=65),\"65 Years and Above\",IF(QuotationTool!B27=\"\",\"\",IF(AND(C27>0,C27<19),Lists!$O$5,IF(AND(C27>=19,C27<30),Lists!$O$6,IF(AND(C27>=30,C27<41),Lists!$O$7,IF(AND(C27>=41,C27<51),Lists!$O$8,IF(AND(C27>=51,C27<=65),Lists!$O$9,IF(AND(C27>=66),Lists!$O$10,\"Check Age\")))))))))","v":""},null,null,null,null,null,null,"30-40",2835,2835]
[null,{"$f":"IF(QuotationTool!B28=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B28,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D28=\"Age\",QuotationTool!E28,(TODAY()-QuotationTool!E28)/365)","v":125.35342465753425},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B28<>\"\",C28>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B28<>\"\",C28>=65),\"65 Years and Above\",IF(QuotationTool!B28=\"\",\"\",IF(AND(C28>0,C28<19),Lists!$O$5,IF(AND(C28>=19,C28<30),Lists!$O$6,IF(AND(C28>=30,C28<41),Lists!$O$7,IF(AND(C28>=41,C28<51),Lists!$O$8,IF(AND(C28>=51,C28<=65),Lists!$O$9,IF(AND(C28>=66),Lists!$O$10,\"Check Age\")))))))))","v":""},null,null,null,null,null,null,"41-50",5455,5455]
[null,{"$f":"IF(QuotationTool!B29=\"Child\",IF(QuotationTool!$C$8=\"AfyaImara Junior\",\"Child\"&COUNTIF(QuotationTool!B$19:B29,\"Child\"),\"\"),\"\")","v":""},{"$f":"IF(QuotationTool!D29=\"Age\",QuotationTool!E29,(TODAY()-QuotationTool!E29)/365)","v":125.35342465753425},{"$f":" IF(AND(QuotationTool!$C$8=Lists!$B$8,QuotationTool!B29<>\"\",C29>=65),\"65 yrs - 80 yrs\",   IF(AND(QuotationTool!$C$8=Lists!$B$6,QuotationTool!B29<>\"\",C29>=65),\"65 Years and Above\",IF(QuotationTool!B29=\"\",\"\",IF(AND(C29>0,C29<19),Lists!$O$5,IF(AND(C29>=19,C29<30),Lists!$O$6,IF(AND(C29>=30,C29<41),Lists!$O$7,IF(AND(C29>=41,C29<51),Lists!$O$8,IF(AND(C29>=51,C29<=65),Lists!$O$9,IF(AND(C29>=66),Lists!$O$10,\"Check Age\")))))))))","v":""},null,null,null,null,null,null,"51-64",15238,15238]
[null,null,null,null,null,null,null,null,null,null,"65 +",0,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,1]
[null,null,null,null,null,2]
[null,null,null,null,null,3]
[null,null,null,null,null,4]
[null,null,null,null,null,5]
[null,null,null,null,null,6]
[null,null,null,null,null,7]
[null,null,null,null,null,8]

{"sheet":"AfyaImaraJunior","index":3,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,"INPATIENT",null,null,null,null,null,null,"OP",null,null,null,null,null,null,null,null,"OPTIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unlimited Panel"]
[{"$f":"R2","v":"Unlimited Panel"},"Cover limit",500000,1000000,3000000,5000000,null,null,50000,75000,100000,150000,null,null,null,null,null,"Gertrude's Panel"]
[]
[null,"One Child",32953.846153846149,34601.538461538461,37715.676923076928,40355.774307692314,null,null,24990,26239.5,28076.265000000003,30041.603550000003]
[null,"2 Children",51784.615384615368,54373.846153846142,59267.492307692301,67259.623846153845,null,null,46231.5,48543.075000000004,51941.090250000008,55576.966567500014]
[null,"3 Children",68261.538461538454,71674.615384615376,80469.090692307698,90800.492192307691,null,null,46462.657500000001,51108.923250000007,54686.547877500008,58514.606228925011]
[null,"4 Children",82384.615384615376,86503.846153846142,99003.651923076919,110978.37934615387,null,null,46617.533024999997,55941.039629999992,67129.247555999988,80555.097067199982]
[null,"5 Children",98437.846153846127,103359.73846153844,116041.97837076921,131156.26650000003,null,null,46734.076857562497,60754.299914831245,78980.589889280614,102674.7668560648]
[null,"6 Children",116162.3076923077,121970.42307692309,132947.76115384619,151334.15365384618,null,null,46827.545011277631,63217.185765224807,85343.2007830535,115213.32105712223]
[null,"Extra Child",17724.461538461575,18610.684615384656,20285.646230769278,21705.641466923127,null,null,454.36363636363632,649.09090909090901,973.63636363636363,1363.0909090909088]
[]
[{"$f":"R3","v":"Gertrude's Panel"},"Cover limit",500000,1000000,3000000,5000000,null,null,50000,75000,100000,150000]
[]
[null,"One Child",29538.461538461539,31015.384615384617,34116.923076923078,37528.61538461539,{"$f":"C15","v":29538.461538461539},null,19250,20212.5,23244.375,26731.031249999996]
[null,"2 Children",49230.769230769227,51692.307692307688,56861.538461538461,62547.692307692312,{"$f":"C16-C15","v":19692.307692307688},null,35612.5,37393.125,43002.09375,49452.407812499994]
[null,"3 Children",66461.538461538454,69784.615384615376,76763.076923076922,84439.384615384624,{"$f":"C17-C16","v":17230.769230769227},null,35790.5625,39369.618750000001,45275.061562499999,52066.320796874992]
[null,"4 Children",81230.769230769234,85292.307692307702,93821.538461538483,103203.69230769234,14769.23076923078,null,35909.864375000005,43091.837250000004,51710.204700000002,62052.245640000001]
[null,"5 Children",96000,100800,110880.00000000001,121968.00000000003,14769.230769230766,null,35999.639035937507,46799.530746718759,60839.389970734388,79091.206961954711]
[null,"6 Children",110769.23076923077,116307.69230769231,127938.46153846156,140732.30769230772,14769.230769230766,null,36071.638314009382,48696.711723912667,65740.560827282112,88749.757116830864]
[null,"Extra Child",14769.230769230766,15507.692307692305,17058.461538461535,18764.307692307691,null,null,350,500,750,1050]

{"sheet":"PricingTable","index":4,"n_rows":121,"n_cols":56,"rows_kept":121,"cut":false,"hidden":true,"merged":[[3,33,3,42],[3,46,3,55]]}
[null,null,null,null,null,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]
[null,null,null,null,null," - Product - HospitalAccess- Relation - Age - ChildNo","Inpatient",null,null,null,null,null,null,null,null,"Outpatient",null,null,null,null,null,null,null,null,"Maternity",null,null,null,null,"Dental & Optical"]
[null,null,null,null,null,null,100000,250000,500000,1000000,3000000,5000000,10000000,20000000,null,50000,60000,100000,150000,200000,null,null,null,null,20000,40000,75000,100000,null,"15,000 Each","30,000 Dental & 25,000 Optical",null,null,"Column No.",{"$f":"MATCH(QuotationTool!$D$11,PricingTable!$AI$5:$AP$5,0)+2","v":8},null,null,null,null,null,null,null,null,null,null,null,"Column No.",{"$f":"MATCH(QuotationTool!$D$11,PricingTable!$AV$5:$BC$5,0)+1","v":7}]
[null,null,null,null,null,null,"Inpatient","Inpatient","Inpatient","Inpatient","Inpatient","Inpatient","Inpatient","Inpatient",null,"Outpatient","Outpatient","Outpatient","Outpatient","Outpatient","Outpatient","Outpatient","Outpatient",null,"Maternity","Maternity","Maternity","Maternity",null,"Dental & Optical","Dental & Optical",null,null,"PER FAMILY OP RATES",null,null,null,null,null,null,null,null,null,null,null,null,"PER PERSON OP RATES"]
["AfyaImara","Age Band","Relation","Child No","Hospital Access","Combination",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Family Size","Limit",25000,40000,50000,60000,100000,150000,200000,"N/A",null,null,null,"Family Size","Limit",25000,40000,50000,60000,100000,150000,200000,"N/A"]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"Child (0 -18 yrs)","Child",null,null,{"$f":"A6&E6&C6&B6&D6","v":"AfyaImaraChildChild (0 -18 yrs)"},null,null,{"$f":"AfyaImara!C6","v":13929},{"$f":"AfyaImara!D6","v":17102},{"$f":"AfyaImara!E6","v":26795},{"$f":"AfyaImara!F6","v":28496},{"$f":"AfyaImara!G6","v":31578},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,null,null,null,null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,{"$f":"A6&AI6","v":"AfyaImaraM"},1,"M",null,null,32934,33266,35226,37892,41512,null,null,null,null,"AfyaImara","M",null,null,32934,33266,35226,37892,41512]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"19 yrs - 29 yrs","Principal",null,null,{"$f":"A7&E7&C7&B7&D7","v":"AfyaImaraPrincipal19 yrs - 29 yrs"},null,null,{"$f":"AfyaImara!C4","v":32256.6875},{"$f":"AfyaImara!D4","v":34283.6875},{"$f":"AfyaImara!E4","v":49171.6875},{"$f":"AfyaImara!F4","v":53024.6875},{"$f":"AfyaImara!G4","v":60534.6875},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,{"$f":"AfyaImara!$D$34","v":10830},{"$f":"AfyaImara!$D$33","v":17100},{"$f":"AfyaImara!$D$32","v":25650},null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,{"$f":"A7&AI7","v":"AfyaImaraM+1"},2,"M+1",null,null,44986,49269,66533,70452,77987,null,null,null,null,"AfyaImara County","M",9390,10821,11775]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"19 yrs - 29 yrs","Spouse",null,null,"AfyaImaraSpouse19 yrs - 29 yrs",null,null,{"$f":"AfyaImara!C5","v":23900},{"$f":"AfyaImara!D5","v":25582},{"$f":"AfyaImara!E5","v":38516},{"$f":"AfyaImara!F5","v":41671},{"$f":"AfyaImara!G5","v":46337},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,null,null,null,null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,"AfyaImaraM+2",3,"M+2",null,null,48748,54844,82895,88794,92489,null,null,null,null,"AfyaImara Seniors","M",null,null,null,null,{"$f":"AfyaImaraSeniors!C7","v":94968},{"$f":"AfyaImaraSeniors!D7","v":101270},{"$f":"AfyaImaraSeniors!E7","v":107534}]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"30 yrs - 40 yrs","Principal",null,null,"AfyaImaraPrincipal30 yrs - 40 yrs",null,null,{"$f":"AfyaImara!C8","v":33863},{"$f":"AfyaImara!D8","v":35223},{"$f":"AfyaImara!E8","v":52342},{"$f":"AfyaImara!F8","v":56437},{"$f":"AfyaImara!G8","v":64692},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,{"$f":"AfyaImara!$D$34","v":10830},{"$f":"AfyaImara!$D$33","v":17100},{"$f":"AfyaImara!$D$32","v":25650},null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,"AfyaImaraM+3",4,"M+3",null,null,48797,55910,98147,106762,111223,null,null,null,null,"AfyaImara Junior","M"]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"30 yrs - 40 yrs","Spouse",null,null,"AfyaImaraSpouse30 yrs - 40 yrs",null,null,{"$f":"AfyaImara!C9","v":25023},{"$f":"AfyaImara!D9","v":26785},{"$f":"AfyaImara!E9","v":40457},{"$f":"AfyaImara!F9","v":43799},{"$f":"AfyaImara!G9","v":48736},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,null,null,null,null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,"AfyaImaraM+4",5,"M+4",null,null,48846,57804,98245,121829,126966,null,null,null,null,"AfyaImara Executive","M"]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"41 yrs - 50 yrs","Principal",null,null,"AfyaImaraPrincipal41 yrs - 50 yrs",null,null,{"$f":"AfyaImara!C12","v":38058.84375},{"$f":"AfyaImara!D12","v":39384.84375},{"$f":"AfyaImara!E12","v":62184.84375},{"$f":"AfyaImara!F12","v":62633.84375},{"$f":"AfyaImara!G12","v":68869.84375},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,{"$f":"AfyaImara!$D$34","v":10830},{"$f":"AfyaImara!$D$33","v":17100},{"$f":"AfyaImara!$D$32","v":25650},null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,"AfyaImaraM+5",6,"M+5",null,null,49339,58095,100250,136895,142709]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"41 yrs - 50 yrs","Spouse",null,null,"AfyaImaraSpouse41 yrs - 50 yrs",null,null,{"$f":"AfyaImara!C13","v":26128},{"$f":"AfyaImara!D13","v":27925},{"$f":"AfyaImara!E13","v":46043},{"$f":"AfyaImara!F13","v":46446},{"$f":"AfyaImara!G13","v":49650},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,null,null,null,null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,"AfyaImaraM+6",7,"M+6",null,null,49837,58387,100260,148202,157539]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"51 yrs - 65 yrs","Principal",null,null,"AfyaImaraPrincipal51 yrs - 65 yrs",null,null,{"$f":"AfyaImara!C16","v":55550.125},{"$f":"AfyaImara!D16","v":56704.125},{"$f":"AfyaImara!E16","v":76889.125},{"$f":"AfyaImara!F16","v":82030.125},{"$f":"AfyaImara!G16","v":91449.125},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,{"$f":"AfyaImara!$D$34","v":10830},{"$f":"AfyaImara!$D$33","v":17100},{"$f":"AfyaImara!$D$32","v":25650},null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,"AfyaImara"]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"51 yrs - 65 yrs","Spouse",null,null,"AfyaImaraSpouse51 yrs - 65 yrs",null,null,{"$f":"AfyaImara!C17","v":31575},{"$f":"AfyaImara!D17","v":34484},{"$f":"AfyaImara!E17","v":50161},{"$f":"AfyaImara!F17","v":54280},{"$f":"AfyaImara!G17","v":60121},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,null,null,null,null,{"$f":"AfyaImara!$E$38","v":12190},22390,null,"AfyaImara"]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"66 Years and Above","Principal",null,null,{"$f":"A15&E15&C15&B15&D15","v":"AfyaImaraPrincipal66 Years and Above"},null,null,{"$f":"AfyaImara!C20","v":82829},{"$f":"AfyaImara!D20","v":95227},{"$f":"AfyaImara!E20","v":142417},{"$f":"AfyaImara!F20","v":162180},{"$f":"AfyaImara!G20","v":185511},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,null,null,null,null,null,null,null,"AfyaImara",null,null,null,null,null,null,null,null,null,null,null,null,null,"SENIORS DENTAL OPTICAL"]
[{"$f":"Lists!$B$4","v":"AfyaImara"},"66 Years and Above","Spouse",null,null,{"$f":"A16&E16&C16&B16&D16","v":"AfyaImaraSpouse66 Years and Above"},null,null,{"$f":"AfyaImara!C21","v":64526},{"$f":"AfyaImara!D21","v":78683},{"$f":"AfyaImara!E21","v":115311},{"$f":"AfyaImara!F21","v":131186},{"$f":"AfyaImara!G21","v":145655},null,null,null,null,null,{"$f":"AfyaImara!$D$28","v":26247},{"$f":"AfyaImara!$D$27","v":30732},{"$f":"AfyaImara!$D$26","v":33800},null,null,null,null,null,null,null,null,null,null,null,"AfyaImara",null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["AfyaImara County",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara CountyM",null,"M",9390,10821,11775,null,null,null,null,null,null,null,null,"No"]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"Child (0 -18 yrs)","Child",null,null,"AfyaImara CountyChildChild (0 -18 yrs)",{"$f":"AfyaImaraCounty!C6","v":5438},{"$f":"AfyaImaraCounty!D6","v":6725},{"$f":"AfyaImaraCounty!E6","v":10552},{"$f":"AfyaImaraCounty!F6","v":13856},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara CountyM+1",null,"M+1",10841,18050,22856]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"19 yrs - 29 yrs","Principal",null,null,"AfyaImara CountyPrincipal19 yrs - 29 yrs",{"$f":"AfyaImaraCounty!C4","v":11184},{"$f":"AfyaImaraCounty!D4","v":14833},{"$f":"AfyaImaraCounty!E4","v":23189},{"$f":"AfyaImaraCounty!F4","v":26908},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$29","v":5700},{"$f":"AfyaImaraCounty!$D$28","v":9500},null,null,null,null,null,null,"AfyaImara CountyM+2",null,"M+2",15921,22120,26252]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"19 yrs - 29 yrs","Spouse",null,null,"AfyaImara CountySpouse19 yrs - 29 yrs",{"$f":"AfyaImaraCounty!C5","v":9438},{"$f":"AfyaImaraCounty!D5","v":11223},{"$f":"AfyaImaraCounty!E5","v":17818},{"$f":"AfyaImaraCounty!F5","v":20488},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara CountyM+3",null,"M+3",21002,26647,30411]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"30 yrs - 40 yrs","Principal",null,null,"AfyaImara CountyPrincipal30 yrs - 40 yrs",{"$f":"AfyaImaraCounty!C8","v":11752},{"$f":"AfyaImaraCounty!D8","v":15471},{"$f":"AfyaImaraCounty!E8","v":24203},{"$f":"AfyaImaraCounty!F8","v":28068},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$29","v":5700},{"$f":"AfyaImaraCounty!$D$28","v":9500},null,null,null,null,null,null,"AfyaImara CountyM+4",null,"M+4",23856,30788,35408]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"30 yrs - 40 yrs","Spouse",null,null,"AfyaImara CountySpouse30 yrs - 40 yrs",{"$f":"AfyaImaraCounty!C9","v":9846},{"$f":"AfyaImaraCounty!D9","v":11681},{"$f":"AfyaImaraCounty!E9","v":18638},{"$f":"AfyaImaraCounty!F9","v":21428},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara CountyM+5",null,"M+5",24603,34661,41366]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"41 yrs - 50 yrs","Principal",null,null,"AfyaImara CountyPrincipal41 yrs - 50 yrs",{"$f":"AfyaImaraCounty!C12","v":14100},{"$f":"AfyaImaraCounty!D12","v":18111},{"$f":"AfyaImaraCounty!E12","v":28495},{"$f":"AfyaImaraCounty!F12","v":32864},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$29","v":5700},{"$f":"AfyaImaraCounty!$D$28","v":9500},null,null,null,null,null,null,"AfyaImara County"]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"41 yrs - 50 yrs","Spouse",null,null,"AfyaImara CountySpouse41 yrs - 50 yrs",{"$f":"AfyaImaraCounty!C13","v":11722},{"$f":"AfyaImaraCounty!D13","v":13791},{"$f":"AfyaImaraCounty!E13","v":22072},{"$f":"AfyaImaraCounty!F13","v":25262},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara County"]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"51 yrs - 65 yrs","Principal",null,null,"AfyaImara CountyPrincipal51 yrs - 65 yrs",{"$f":"AfyaImaraCounty!C16","v":17662},{"$f":"AfyaImaraCounty!D16","v":22117},{"$f":"AfyaImaraCounty!E16","v":34445},{"$f":"AfyaImaraCounty!F16","v":40144},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$29","v":5700},{"$f":"AfyaImaraCounty!$D$28","v":9500},null,null,null,null,null,null,"AfyaImara County"]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"51 yrs - 65 yrs","Spouse",null,null,"AfyaImara CountySpouse51 yrs - 65 yrs",{"$f":"AfyaImaraCounty!C17","v":14600},{"$f":"AfyaImaraCounty!D17","v":17027},{"$f":"AfyaImaraCounty!E17","v":26622},{"$f":"AfyaImaraCounty!F17","v":31142},null,null,null,null,null,{"$f":"AfyaImaraCounty!$D$24","v":5053},{"$f":"AfyaImaraCounty!$D$23","v":8165},{"$f":"AfyaImaraCounty!$D$22","v":10239},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara County"]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"66 Years and Above","Principal",null,null,{"$f":"A27&E27&C27&B27&D27","v":"AfyaImara CountyPrincipal66 Years and Above"},{"$f":"G25","v":17662},22117,34445,40144,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara County"]
[{"$f":"Lists!$B$5","v":"AfyaImara County"},"66 Years and Above","Spouse",null,null,"AfyaImara CountySpouse66 Years and Above",14600,17027,26622,31142,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara County"]
["AfyaImara Seniors",null,null,null,null,"AfyaImara Seniors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Seniors"]
[{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"65 Years and Above","Principal",null,null,"AfyaImara SeniorsPrincipal65 Years and Above",null,null,{"$f":"AfyaImaraSeniors!C4","v":116352},{"$f":"AfyaImaraSeniors!D4","v":132299},{"$f":"AfyaImaraSeniors!E4","v":178535},{"$f":"AfyaImaraSeniors!F4","v":206231},{"$f":"AfyaImaraSeniors!G4","v":229049},null,null,null,null,null,null,{"$f":"AfyaImaraSeniors!$C$7","v":94968},{"$f":"AfyaImaraSeniors!$D$7","v":101270},{"$f":"AfyaImaraSeniors!$E$7","v":107534},null,null,null,null,null,null,null,null,null,null,"AfyaImara Seniors"]
[{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"65 Years and Above","Spouse",null,null,"AfyaImara SeniorsSpouse65 Years and Above",null,null,{"$f":"AfyaImaraSeniors!C4","v":116352},{"$f":"AfyaImaraSeniors!D4","v":132299},{"$f":"AfyaImaraSeniors!E4","v":178535},{"$f":"AfyaImaraSeniors!F4","v":206231},{"$f":"AfyaImaraSeniors!G4","v":229049},null,null,null,null,null,null,{"$f":"AfyaImaraSeniors!$C$7","v":94968},{"$f":"AfyaImaraSeniors!$D$7","v":101270},{"$f":"AfyaImaraSeniors!$E$7","v":107534},null,null,null,null,null,null,null,null,null,null,"AfyaImara Seniors"]
["AfyaImara Junior","XX","XXX",{"$f":"C32","v":"XXX"},{"$f":"D32","v":"XXX"},"XXX","XXX","XXX","XXX","XXX","XXX","XXX","XXX","XXX","XX",50000,75000,100000,150000,"XX","XX","XX","XX",null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child1",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child1",null,null,{"$f":"AfyaImaraJunior!C5","v":32953.846153846149},{"$f":"AfyaImaraJunior!D5","v":34601.538461538461},{"$f":"AfyaImaraJunior!E5","v":37715.676923076928},{"$f":"AfyaImaraJunior!F5","v":40355.774307692314},null,null,null,{"$f":"AfyaImaraJunior!I5","v":24990},{"$f":"AfyaImaraJunior!J5","v":26239.5},{"$f":"AfyaImaraJunior!K5","v":28076.265000000003},{"$f":"AfyaImaraJunior!L5","v":30041.603550000003},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child2",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child2",null,null,{"$f":"AfyaImaraJunior!C6-AfyaImaraJunior!C5","v":18830.76923076922},{"$f":"AfyaImaraJunior!D6-AfyaImaraJunior!D5","v":19772.307692307681},{"$f":"AfyaImaraJunior!E6-AfyaImaraJunior!E5","v":21551.815384615373},{"$f":"AfyaImaraJunior!F6-AfyaImaraJunior!F5","v":26903.849538461531},null,null,null,{"$f":"AfyaImaraJunior!I6-AfyaImaraJunior!I5","v":21241.5},{"$f":"AfyaImaraJunior!J6-AfyaImaraJunior!J5","v":22303.575000000004},{"$f":"AfyaImaraJunior!K6-AfyaImaraJunior!K5","v":23864.825250000005},{"$f":"AfyaImaraJunior!L6-AfyaImaraJunior!L5","v":25535.363017500011},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child3",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child3",null,null,{"$f":"AfyaImaraJunior!C7-AfyaImaraJunior!C6","v":16476.923076923085},{"$f":"AfyaImaraJunior!D7-AfyaImaraJunior!D6","v":17300.769230769234},{"$f":"AfyaImaraJunior!E7-AfyaImaraJunior!E6","v":21201.598384615398},{"$f":"AfyaImaraJunior!F7-AfyaImaraJunior!F6","v":23540.868346153846},null,null,null,{"$f":"AfyaImaraJunior!I7-AfyaImaraJunior!I6","v":231.15750000000116},{"$f":"AfyaImaraJunior!J7-AfyaImaraJunior!J6","v":2565.8482500000027},{"$f":"AfyaImaraJunior!K7-AfyaImaraJunior!K6","v":2745.4576274999999},{"$f":"AfyaImaraJunior!L7-AfyaImaraJunior!L6","v":2937.639661424997},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child4",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child4",null,null,{"$f":"AfyaImaraJunior!C8-AfyaImaraJunior!C7","v":14123.076923076922},{"$f":"AfyaImaraJunior!D8-AfyaImaraJunior!D7","v":14829.230769230766},{"$f":"AfyaImaraJunior!E8-AfyaImaraJunior!E7","v":18534.561230769221},{"$f":"AfyaImaraJunior!F8-AfyaImaraJunior!F7","v":20177.887153846183},null,null,null,{"$f":"AfyaImaraJunior!I8-AfyaImaraJunior!I7","v":154.87552499999583},{"$f":"AfyaImaraJunior!J8-AfyaImaraJunior!J7","v":4832.1163799999849},{"$f":"AfyaImaraJunior!K8-AfyaImaraJunior!K7","v":12442.699678499979},{"$f":"AfyaImaraJunior!L8-AfyaImaraJunior!L7","v":22040.490838274971},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child5",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child5",null,null,{"$f":"AfyaImaraJunior!C9-AfyaImaraJunior!C8","v":16053.230769230751},{"$f":"AfyaImaraJunior!D9-AfyaImaraJunior!D8","v":16855.892307692295},{"$f":"AfyaImaraJunior!E9-AfyaImaraJunior!E8","v":17038.326447692292},{"$f":"AfyaImaraJunior!F9-AfyaImaraJunior!F8","v":20177.887153846154},null,null,null,{"$f":"AfyaImaraJunior!I9-AfyaImaraJunior!I8","v":116.54383256250003},{"$f":"AfyaImaraJunior!J9-AfyaImaraJunior!J8","v":4813.2602848312526},{"$f":"AfyaImaraJunior!K9-AfyaImaraJunior!K8","v":11851.342333280627},{"$f":"AfyaImaraJunior!L9-AfyaImaraJunior!L8","v":22119.66978886482},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child6",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child6",null,null,{"$f":"AfyaImaraJunior!C10-AfyaImaraJunior!C9","v":17724.461538461575},{"$f":"AfyaImaraJunior!D10-AfyaImaraJunior!D9","v":18610.684615384656},{"$f":"AfyaImaraJunior!E10-AfyaImaraJunior!E9","v":16905.782783076982},{"$f":"AfyaImaraJunior!F10-AfyaImaraJunior!F9","v":20177.887153846154},null,null,null,{"$f":"AfyaImaraJunior!I10-AfyaImaraJunior!I9","v":93.468153715133667},{"$f":"AfyaImaraJunior!J10-AfyaImaraJunior!J9","v":2462.8858503935626},{"$f":"AfyaImaraJunior!K10-AfyaImaraJunior!K9","v":6362.6108937728859},{"$f":"AfyaImaraJunior!L10-AfyaImaraJunior!L9","v":12538.554201057428},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child7",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child7",null,null,{"$f":"AfyaImaraJunior!C11","v":17724.461538461575},{"$f":"AfyaImaraJunior!D11","v":18610.684615384656},{"$f":"AfyaImaraJunior!E11","v":20285.646230769278},{"$f":"AfyaImaraJunior!F11","v":21705.641466923127},null,null,null,{"$f":"AfyaImaraJunior!I11","v":454.36363636363632},{"$f":"AfyaImaraJunior!J11","v":649.09090909090901},{"$f":"AfyaImaraJunior!K11","v":973.63636363636363},{"$f":"AfyaImaraJunior!L11","v":1363.0909090909088},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child8",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child8",null,null,{"$f":"I39","v":17724.461538461575},{"$f":"J39","v":18610.684615384656},20285.646230769278,21705.641466923127,null,null,null,{"$f":"P39","v":454.36363636363632},{"$f":"Q39","v":649.09090909090901},973.63636363636363,1363.0909090909088,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child9",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child9",null,null,{"$f":"I40","v":17724.461538461575},18610.684615384656,20285.646230769278,21705.641466923127,null,null,null,{"$f":"P40","v":454.36363636363632},649.09090909090901,973.63636363636363,1363.0909090909088,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child10",{"$f":"AfyaImaraJunior!$R$2","v":"Unlimited Panel"},"AfyaImara JuniorUnlimited PanelChildChild (0 -18 yrs)Child10",null,null,17724.461538461575,18610.684615384656,20285.646230769278,21705.641466923127,null,null,null,454.36363636363632,649.09090909090901,973.63636363636363,1363.0909090909088,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[null,null,null,null,null,null,null,null,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":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child1",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child1",null,null,{"$f":"AfyaImaraJunior!C15","v":29538.461538461539},{"$f":"AfyaImaraJunior!D15","v":31015.384615384617},{"$f":"AfyaImaraJunior!E15","v":34116.923076923078},{"$f":"AfyaImaraJunior!F15","v":37528.61538461539},null,null,null,{"$f":"AfyaImaraJunior!I15","v":19250},{"$f":"AfyaImaraJunior!J15","v":20212.5},{"$f":"AfyaImaraJunior!K15","v":23244.375},{"$f":"AfyaImaraJunior!L15","v":26731.031249999996},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child2",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child2",null,null,{"$f":"AfyaImaraJunior!C16-AfyaImaraJunior!C15","v":19692.307692307688},{"$f":"AfyaImaraJunior!D16-AfyaImaraJunior!D15","v":20676.923076923071},{"$f":"AfyaImaraJunior!E16-AfyaImaraJunior!E15","v":22744.615384615383},{"$f":"AfyaImaraJunior!F16-AfyaImaraJunior!F15","v":25019.076923076922},null,null,null,{"$f":"AfyaImaraJunior!I16-AfyaImaraJunior!I15","v":16362.5},{"$f":"AfyaImaraJunior!J16-AfyaImaraJunior!J15","v":17180.625},{"$f":"AfyaImaraJunior!K16-AfyaImaraJunior!K15","v":19757.71875},{"$f":"AfyaImaraJunior!L16-AfyaImaraJunior!L15","v":22721.376562499998},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child3",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child3",null,null,{"$f":"AfyaImaraJunior!C17-AfyaImaraJunior!C16","v":17230.769230769227},{"$f":"AfyaImaraJunior!D17-AfyaImaraJunior!D16","v":18092.307692307688},{"$f":"AfyaImaraJunior!E17-AfyaImaraJunior!E16","v":19901.538461538461},{"$f":"AfyaImaraJunior!F17-AfyaImaraJunior!F16","v":21891.692307692312},null,null,null,{"$f":"AfyaImaraJunior!I17-AfyaImaraJunior!I16","v":178.0625},{"$f":"AfyaImaraJunior!J17-AfyaImaraJunior!J16","v":1976.4937500000015},{"$f":"AfyaImaraJunior!K17-AfyaImaraJunior!K16","v":2272.9678124999991},{"$f":"AfyaImaraJunior!L17-AfyaImaraJunior!L16","v":2613.9129843749979},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child4",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child4",null,null,{"$f":"AfyaImaraJunior!C18-AfyaImaraJunior!C17","v":14769.23076923078},{"$f":"AfyaImaraJunior!D18-AfyaImaraJunior!D17","v":15507.692307692327},{"$f":"AfyaImaraJunior!E18-AfyaImaraJunior!E17","v":17058.461538461561},{"$f":"AfyaImaraJunior!F18-AfyaImaraJunior!F17","v":18764.307692307717},null,null,null,{"$f":"AfyaImaraJunior!I18-AfyaImaraJunior!I17","v":119.30187500000466},{"$f":"AfyaImaraJunior!J18-AfyaImaraJunior!J17","v":3722.2185000000027},{"$f":"AfyaImaraJunior!K18-AfyaImaraJunior!K17","v":6435.1431375000029},{"$f":"AfyaImaraJunior!L18-AfyaImaraJunior!L17","v":9985.9248431250089},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child5",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child5",null,null,{"$f":"AfyaImaraJunior!C19-AfyaImaraJunior!C18","v":14769.230769230766},{"$f":"AfyaImaraJunior!D19-AfyaImaraJunior!D18","v":15507.692307692298},{"$f":"AfyaImaraJunior!E19-AfyaImaraJunior!E18","v":17058.461538461532},{"$f":"AfyaImaraJunior!F19-AfyaImaraJunior!F18","v":18764.307692307688},null,null,null,{"$f":"AfyaImaraJunior!I19-AfyaImaraJunior!I18","v":89.774660937502631},{"$f":"AfyaImaraJunior!J19-AfyaImaraJunior!J18","v":3707.6934967187553},{"$f":"AfyaImaraJunior!K19-AfyaImaraJunior!K18","v":9129.185270734386},{"$f":"AfyaImaraJunior!L19-AfyaImaraJunior!L18","v":17038.96132195471},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child6",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child6",null,null,{"$f":"AfyaImaraJunior!C20-AfyaImaraJunior!C19","v":14769.230769230766},{"$f":"AfyaImaraJunior!D20-AfyaImaraJunior!D19","v":15507.692307692312},{"$f":"AfyaImaraJunior!E20-AfyaImaraJunior!E19","v":17058.461538461546},{"$f":"AfyaImaraJunior!F20-AfyaImaraJunior!F19","v":18764.307692307688},null,null,null,{"$f":"AfyaImaraJunior!I20-AfyaImaraJunior!I19","v":71.999278071874869},{"$f":"AfyaImaraJunior!J20-AfyaImaraJunior!J19","v":1897.1809771939079},{"$f":"AfyaImaraJunior!K20-AfyaImaraJunior!K19","v":4901.1708565477238},{"$f":"AfyaImaraJunior!L20-AfyaImaraJunior!L19","v":9658.5501548761531},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child7",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child7",null,null,{"$f":"AfyaImaraJunior!C21","v":14769.230769230766},{"$f":"AfyaImaraJunior!D21","v":15507.692307692305},{"$f":"AfyaImaraJunior!E21","v":17058.461538461535},{"$f":"AfyaImaraJunior!F21","v":18764.307692307691},null,null,null,{"$f":"AfyaImaraJunior!I21","v":350},{"$f":"AfyaImaraJunior!J21","v":500},{"$f":"AfyaImaraJunior!K21","v":750},{"$f":"AfyaImaraJunior!L21","v":1050},null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child8",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child8",null,null,{"$f":"I50","v":14769.230769230766},{"$f":"J50","v":15507.692307692305},17058.461538461535,18764.307692307691,null,null,null,{"$f":"P50","v":350},{"$f":"Q50","v":500},750,1050,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child9",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child9",null,null,{"$f":"I51","v":14769.230769230766},15507.692307692305,17058.461538461535,18764.307692307691,null,null,null,{"$f":"P51","v":350},500,750,1050,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
[{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Child (0 -18 yrs)","Child","Child10",{"$f":"AfyaImaraJunior!$R$3","v":"Gertrude's Panel"},"AfyaImara JuniorGertrude's PanelChildChild (0 -18 yrs)Child10",null,null,14769.230769230766,15507.692307692305,17058.461538461535,18764.307692307691,null,null,null,350,500,750,1050,null,null,null,null,null,null,null,null,null,null,null,null,null,"AfyaImara Junior"]
["AfyaImara Executive","xx",{"$f":"B54","v":"xx"},{"$f":"C54","v":"xx"},"xx","xx","xx","xx","xx","xx","xx","xx","xx","xx","xx","xx","xx","xx","xx","xx","xx",200000,250000,null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Child (0 -18 yrs)","Child",null,null,"AfyaImara ExecutiveChildChild (0 -18 yrs)",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D7","v":97360},{"$f":"AfyaImaraExecutive!E7","v":111268},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C27","v":43029},{"$f":"AfyaImaraExecutive!D27","v":47030},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"19 yrs - 29 yrs","Principal",null,null,"AfyaImara ExecutivePrincipal19 yrs - 29 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D5","v":222424},{"$f":"AfyaImaraExecutive!E5","v":259199},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C28","v":54286},{"$f":"AfyaImaraExecutive!D28","v":59334},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"19 yrs - 29 yrs","Spouse",null,null,"AfyaImara ExecutiveSpouse19 yrs - 29 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D6","v":195174},{"$f":"AfyaImaraExecutive!E6","v":228056},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C28","v":54286},{"$f":"AfyaImaraExecutive!D28","v":59334},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"30 yrs - 40 yrs","Principal",null,null,"AfyaImara ExecutivePrincipal30 yrs - 40 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D9","v":231972},{"$f":"AfyaImaraExecutive!E9","v":270111},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C29","v":64577},{"$f":"AfyaImaraExecutive!D29","v":70582},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"30 yrs - 40 yrs","Spouse",null,null,"AfyaImara ExecutiveSpouse30 yrs - 40 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D10","v":203059},{"$f":"AfyaImaraExecutive!E10","v":237067},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C29","v":64577},{"$f":"AfyaImaraExecutive!D29","v":70582},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"41 yrs - 50 yrs","Principal",null,null,"AfyaImara ExecutivePrincipal41 yrs - 50 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D13","v":243559},{"$f":"AfyaImaraExecutive!E13","v":283353},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C30","v":79820},{"$f":"AfyaImaraExecutive!D30","v":87243},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"41 yrs - 50 yrs","Spouse",null,null,"AfyaImara ExecutiveSpouse41 yrs - 50 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D14","v":211374},{"$f":"AfyaImaraExecutive!E14","v":246570},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C30","v":79820},{"$f":"AfyaImaraExecutive!D30","v":87243},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"51 yrs - 65 yrs","Principal",null,null,"AfyaImara ExecutivePrincipal51 yrs - 65 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D17","v":280840},{"$f":"AfyaImaraExecutive!E17","v":325959},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C31","v":95064},{"$f":"AfyaImaraExecutive!D31","v":103904},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"51 yrs - 65 yrs","Spouse",null,null,"AfyaImara ExecutiveSpouse51 yrs - 65 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D18","v":241896},{"$f":"AfyaImaraExecutive!E18","v":281452},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C31","v":95064},{"$f":"AfyaImaraExecutive!D31","v":103904},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"65 yrs - 80 yrs","Principal",null,null,"AfyaImara ExecutivePrincipal65 yrs - 80 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D21","v":556653},{"$f":"AfyaImaraExecutive!E21","v":641175},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C32","v":102605},{"$f":"AfyaImaraExecutive!D32","v":112146},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"65 yrs - 80 yrs","Spouse",null,null,"AfyaImara ExecutiveSpouse65 yrs - 80 yrs",null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!D22","v":471379},{"$f":"AfyaImaraExecutive!E22","v":543718},null,null,null,null,null,null,null,{"$f":"AfyaImaraExecutive!C32","v":102605},{"$f":"AfyaImaraExecutive!D32","v":112146},null,null,null,null,null,null,null,null,null,"AfyaImara Executive"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"AfyaImara ExecutivePrincipal66 Years and Above",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,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":"A71&AI71","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,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":"BenefitsSchedule","index":5,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[33,0,33,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[3,10,4,10],[8,0,8,1],[9,0,9,1],[23,0,23,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[3,1,4,2],[44,0,44,2],[39,0,39,1],[3,0,4,0],[0,2,2,2],[5,0,6,2],[10,0,10,1],[11,0,11,1],[7,0,7,2],[41,0,41,1],[42,0,42,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[40,0,40,1]]}
[null,null,"[ Page 2/2 of Quotation ] "]
[]
[]
[{"$f":"QuotationTool!C5","v":"ABSOLOM IRUNGU"},{"$f":"QuotationTool!C8&\"  -  Health Insurance QUOTATION\"","v":"AfyaImara  -  Health Insurance QUOTATION"}]
[]
["Benefits Schedule"]
[]
["Inpatient"]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K9,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Overall Limit"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K9,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":10000000},null,null,null,null,null,null,"Inpatient",1]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K10,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Bed"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K10,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":"En Suite / Max Kes 26,000"},null,null,null,null,null,null,"Inpatient",2]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K11,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Lodger Fee for Accompanying Parent/Guardian "},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K11,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":"12 Years"},null,null,null,null,null,null,"Inpatient",3]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K12,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Emergency Evacuation Within East Africa"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K12,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":"Road & Air Ambulance"},null,null,null,null,null,null,"Inpatient",4]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K13,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Accidents"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K13,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":"To overall Limit"},null,null,null,null,null,null,"Inpatient",5]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K14,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Newly Diagnosed Chronic illnesses"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K14,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":3500000},null,null,null,null,null,null,"Inpatient",6]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K15,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Chronic, Pre-existing illnesses, Congenital Conditions & HIV/AIDS "},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K15,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":1000000},null,null,null,null,null,null,"Inpatient",7]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K16,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Organ Transplant (cost of donor or securing the organ is excluded). This is in addition to the relevant condition’s benefit allocation."},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K16,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":500000},null,null,null,null,null,null,"Inpatient",8]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K17,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Psychiatric and Psychological Illnesses"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K17,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":700000},null,null,null,null,null,null,"Inpatient",9]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K18,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Post Hospitalization 21 days after discharge (On Reimbursement)"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K18,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":30000},null,null,null,null,null,null,"Inpatient",10]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K19,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Neo-natal and prematurity conditions."},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K19,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":500000},null,null,null,null,null,null,"Inpatient",11]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K20,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"In patient non-accident related dental surgery/ treatment"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K20,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":250000},null,null,null,null,null,null,"Inpatient",12]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K21,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"In patient non-accident related eye treatments excluding surgery for refractive errors and laser treatment"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K21,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":200000},null,null,null,null,null,null,"Inpatient",13]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K22,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Accident Related Inpatient Dental and Ophthalmological treatment"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K22,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":5000000},null,null,null,null,null,null,"Inpatient",14]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K23,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Illness related reconstructive/plastic surgery (excludes cosmetic, obstetrics and gynecology related)"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K23,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":300000},null,null,null,null,null,null,"Inpatient",15]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K24,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Non accident related maxillofacial surgery (Excluding routine dental surgery and dental fixtures)"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K24,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":500000},null,null,null,null,null,null,"Inpatient",16]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K25,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Gynecological surgery"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K25,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":500000},null,null,null,null,null,null,"Inpatient",17]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K26,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Cost of purchase of internal and external surgical implants, appliances, and prostheses (excluding dental fixtures)"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K26,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":500000},null,null,null,null,null,null,"Inpatient",18]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K27,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Last Expense - Per Member (as a stand-alone benefit)"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K27,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":150000},null,null,null,null,null,null,"Inpatient",19]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K28,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Passive War /Terrorism and Political Violence "},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K28,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":1000000},null,null,null,null,null,null,"Inpatient",20]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K29,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Maternity: Normal Delivery, Elective & subsequent Caesarean sections, First Ever Emergency Caesarean Section, Ectopic Pregnancy, Maternity Complications before & after delivery"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K29,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":200000},null,null,null,null,null,null,"Inpatient",21]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K30,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Covid-19 Treatment (moderate cases)"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K30,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":250000},null,null,null,null,null,null,"Inpatient",22]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K31,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":"Covid-19 Treatment (Critical cases requiring ICU/HDU) \nThis is a cumulative amount that will be inclusive of any amounts already paid for in the treatment of moderate inpatient cases"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K31,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":1000000},null,null,null,null,null,null,"Inpatient",23]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K32,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K32,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"Inpatient",24]
[{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&BenefitsSchedule!K33,BenefitsLookup!$A:$E,5,FALSE),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$10&K33,BenefitsLookup!$A:$M,MATCH(QuotationTool!$D$10,BenefitsLookup!$A$3:$M$3,0),FALSE),\"\")","v":""},null,null,null,null,null,null,"Inpatient",25]
[{"$f":"IFERROR(IF(QuotationTool!$D$11>0,VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$11&BenefitsSchedule!K34,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":"Outpatient Overall Cover"},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$11&BenefitsSchedule!K34,BenefitsLookup!$A:$V,MATCH(QuotationTool!$D$11,BenefitsLookup!$O$3:$V$3,0)+14,FALSE),\"\")","v":100000},null,null,null,null,null,null,"Outpatient",1]
[{"$f":"IFERROR(IF(QuotationTool!$D$11>0,VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$11&BenefitsSchedule!K35,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$11&BenefitsSchedule!K35,BenefitsLookup!$A:$V,MATCH(QuotationTool!$D$11,BenefitsLookup!$O$3:$V$3,0)+14,FALSE),\"\")","v":""},null,null,null,null,null,null,"Outpatient",2]
[{"$f":"IFERROR(IF(QuotationTool!$D$11>0,VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$11&BenefitsSchedule!K36,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$11&BenefitsSchedule!K36,BenefitsLookup!$A:$V,MATCH(QuotationTool!$D$11,BenefitsLookup!$O$3:$V$3,0)+14,FALSE),\"\")","v":""},null,null,null,null,null,null,"Outpatient",3]
[{"$f":"IFERROR(IF(OR(QuotationTool!$D$13=PricingTable!$AD$3,QuotationTool!$D$13=PricingTable!$AE$3),VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$13&BenefitsSchedule!K37,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$13&BenefitsSchedule!K37,BenefitsLookup!$A:$AD,MATCH(QuotationTool!$D$13,BenefitsLookup!$AC$3:$AD$3,0)+28,FALSE),\"\")","v":""},null,null,null,null,null,null,"Dental & Optical",1]
[{"$f":"IFERROR(IF(OR(QuotationTool!$D$13=PricingTable!$AD$3,QuotationTool!$D$13=PricingTable!$AE$3),VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$13&BenefitsSchedule!K38,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$13&BenefitsSchedule!K38,BenefitsLookup!$A:$AD,MATCH(QuotationTool!$D$13,BenefitsLookup!$AC$3:$AD$3,0)+28,FALSE),\"\")","v":""},null,null,null,null,null,null,"Dental & Optical",2]
[{"$f":"IFERROR(IF(QuotationTool!$D$12>0,VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K39,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K39,BenefitsLookup!$A:$AA,MATCH(QuotationTool!$D$12,BenefitsLookup!$X$3:$AA$3,0)+23,FALSE),\"\")","v":""},null,null,null,null,null,null,"Maternity",0]
[{"$f":"IFERROR(IF(QuotationTool!$D$12>0,VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K40,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K40,BenefitsLookup!$A:$AA,MATCH(QuotationTool!$D$12,BenefitsLookup!$X$3:$AA$3,0)+23,FALSE),\"\")","v":""},null,null,null,null,null,null,null,1]
[{"$f":"IFERROR(IF(QuotationTool!$D$12>0,VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K41,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K41,BenefitsLookup!$A:$AA,MATCH(QuotationTool!$D$12,BenefitsLookup!$X$3:$AA$3,0)+23,FALSE),\"\")","v":""},null,null,null,null,null,null,"Maternity",2]
[{"$f":"IFERROR(IF(QuotationTool!$D$12>0,VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K42,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K42,BenefitsLookup!$A:$AA,MATCH(QuotationTool!$D$12,BenefitsLookup!$X$3:$AA$3,0)+23,FALSE),\"\")","v":""},null,null,null,null,null,null,"Maternity",3]
[{"$f":"IFERROR(IF(QuotationTool!$D$12>0,VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K43,BenefitsLookup!$A:$E,5,FALSE),\"\"),\"\")","v":""},null,{"$f":"IFERROR(VLOOKUP(QuotationTool!$C$8&QuotationTool!$C$12&BenefitsSchedule!K43,BenefitsLookup!$A:$AA,MATCH(QuotationTool!$D$12,BenefitsLookup!$X$3:$AA$3,0)+23,FALSE),\"\")","v":""},null,null,null,null,null,null,"Maternity",4]
[]
["Payment Methods:"]
["BANK PAYMENT","MPESA PAYMENT"]
["Bank Name : Kenya Commercial Bank","Paybill No:   505800"]
["Account Name : Old Mutual General Insurance Company Ltd","Acc No : Policy No./Member No."]
["Account No: 1107154170"]
["Branch : Moi Avenue"]
["Swift Code : KCBLKENX    , Branch Code : 100"]

{"sheet":"BenefitsLookup","index":6,"n_rows":131,"n_cols":30,"rows_kept":131,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Benefit Table",null,null,null,"Inpatient",null,null,null,null,null,null,null,null,"Outpatient",null,null,null,null,null,null,null,null,"Maternity",null,null,null,null,"Dental & Optical"]
["Combination","Product","Benefit","Option","Benefit",100000,250000,500000,1000000,3000000,5000000,10000000,20000000,null,10000,25000,50000,60000,100000,150000,200000,250000,null,20000,40000,75000,100000,null,"15,000 Each","30,000 Dental & 25,000 Optical"]
[{"$f":"B4&C4&D4","v":"AfyaImaraInpatient1"},{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",1,"Overall Limit",null,null,500000,1000000,3000000,5000000,10000000]
[{"$f":"B5&C5&D5","v":"AfyaImaraInpatient2"},{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",2,"Bed",null,null,"General Ward / Max Kes 8,000","General Ward / Max Kes 10,000","Standard Private Room / Max Kes 18,000","Standard Private Room / Max Kes 18,000","En Suite / Max Kes 26,000"]
["AfyaImaraInpatient3",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",3,"Lodger Fee for Accompanying Parent/Guardian ",null,null,"12 Years","12 Years","12 Years","12 Years","12 Years"]
["AfyaImaraInpatient4",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",4,"Emergency Evacuation Within East Africa",null,null,"Road Ambulance","Road Ambulance","Road & Air Ambulance","Road & Air Ambulance","Road & Air Ambulance"]
["AfyaImaraInpatient5",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",5,"Accidents",null,null,"To overall Limit","To overall Limit","To overall Limit","To overall Limit","To overall Limit"]
["AfyaImaraInpatient6",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",6,"Newly Diagnosed Chronic illnesses",null,null,350000,700000,2000000,2500000,3500000]
["AfyaImaraInpatient7",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",7,"Chronic, Pre-existing illnesses, Congenital Conditions & HIV/AIDS ",null,null,250000,400000,700000,800000,1000000]
["AfyaImaraInpatient8",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",8,"Organ Transplant (cost of donor or securing the organ is excluded). This is in addition to the relevant condition’s benefit allocation.",null,null,100000,200000,200000,300000,500000]
["AfyaImaraInpatient9",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",9,"Psychiatric and Psychological Illnesses",null,null,200000,300000,500000,500000,700000]
["AfyaImaraInpatient10",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",10,"Post Hospitalization 21 days after discharge (On Reimbursement)",null,null,20000,20000,30000,30000,30000]
["AfyaImaraInpatient11",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",11,"Neo-natal and prematurity conditions.",null,null,200000,250000,400000,400000,500000]
["AfyaImaraInpatient12",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",12,"In patient non-accident related dental surgery/ treatment",null,null,150000,150000,200000,200000,250000]
["AfyaImaraInpatient13",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",13,"In patient non-accident related eye treatments excluding surgery for refractive errors and laser treatment",null,null,150000,150000,200000,200000,200000]
["AfyaImaraInpatient14",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",14,"Accident Related Inpatient Dental and Ophthalmological treatment",null,null,500000,1000000,3000000,5000000,5000000]
["AfyaImaraInpatient15",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",15,"Illness related reconstructive/plastic surgery (excludes cosmetic, obstetrics and gynecology related)",null,null,200000,200000,250000,300000,300000]
["AfyaImaraInpatient16",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",16,"Non accident related maxillofacial surgery (Excluding routine dental surgery and dental fixtures)",null,null,200000,300000,400000,400000,500000]
["AfyaImaraInpatient17",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",17,"Gynecological surgery",null,null,200000,300000,400000,400000,500000]
["AfyaImaraInpatient18",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",18,"Cost of purchase of internal and external surgical implants, appliances, and prostheses (excluding dental fixtures)",null,null,300000,300000,400000,400000,500000]
["AfyaImaraInpatient19",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",19,"Last Expense - Per Member (as a stand-alone benefit)",null,null,75000,100000,100000,150000,150000]
["AfyaImaraInpatient20",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",20,"Passive War /Terrorism and Political Violence ",null,null,300000,500000,700000,1000000,1000000]
["AfyaImaraInpatient21",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",21,"Maternity: Normal Delivery, Elective & subsequent Caesarean sections, First Ever Emergency Caesarean Section, Ectopic Pregnancy, Maternity Complications before & after delivery",null,null,50000,75000,100000,150000,200000]
["AfyaImaraInpatient22",{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",22,"Covid-19 Treatment (moderate cases)",null,null,250000,250000,250000,250000,250000]
[{"$f":"B26&C26&D26","v":"AfyaImaraInpatient23"},{"$f":"Lists!$B$4","v":"AfyaImara"},"Inpatient",23,"Covid-19 Treatment (Critical cases requiring ICU/HDU) \nThis is a cumulative amount that will be inclusive of any amounts already paid for in the treatment of moderate inpatient cases",null,null,500000,1000000,1000000,1000000,1000000]
["AfyaImaraOutpatient1",{"$f":"Lists!$B$4","v":"AfyaImara"},"Outpatient",1,"Outpatient Overall Cover",null,null,null,null,null,null,null,null,null,null,null,null,60000,100000,150000]
[{"$f":"B28&C28&D28","v":"AfyaImara0"},{"$f":"Lists!$B$4","v":"AfyaImara"},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Y3","v":40000},{"$f":"Z3","v":75000},{"$f":"AA3","v":100000}]
["AfyaImara1",{"$f":"Lists!$B$4","v":"AfyaImara"},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Maternity Limit","Full Maternity Limit","Full Maternity Limit"]
["AfyaImara2",{"$f":"Lists!$B$4","v":"AfyaImara"},null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Maternity Limit","Full Maternity Limit","Full Maternity Limit"]
["AfyaImara3",{"$f":"Lists!$B$4","v":"AfyaImara"},null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Maternity Limit","Full Maternity Limit","Full Maternity Limit"]
["AfyaImara4",{"$f":"Lists!$B$4","v":"AfyaImara"},null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Maternity Limit","Full Maternity Limit","Full Maternity Limit"]
[{"$f":"B33&C33&D33","v":"AfyaImara1"},{"$f":"Lists!$B$4","v":"AfyaImara"},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15000,25000]
[{"$f":"B34&C34&D34","v":"AfyaImara2"},{"$f":"Lists!$B$4","v":"AfyaImara"},null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15000,30000]
[{"$f":"B35&C35&D35","v":"AfyaImara CountyInpatient1"},{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",1,"Overall Limit",100000,250000,500000,1000000]
[{"$f":"B36&C36&D36","v":"AfyaImara CountyInpatient2"},{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",2,"Bed","General Ward / Max Kes 8,000","General Ward / Max Kes 8,000","General Ward / Max Kes 8,000","Standard Private / Max Kes 14,000"]
["AfyaImara CountyInpatient3",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",3,"Lodger Fee for Accompanying Parent","12 Years","12 Years","12 Years","12 Years"]
["AfyaImara CountyInpatient4",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",4,"Emergency Evacuation Within East Africa","Road Ambulance","Road Ambulance","Road Ambulance","Road & Air Ambulance"]
["AfyaImara CountyInpatient5",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",5,"Acute Illnesses, and Accidents","To overall Limit","To overall Limit","To overall Limit","To overall Limit"]
["AfyaImara CountyInpatient6",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",6,"Newly Diagnosed Chronic illnesses",50000,50000,300000,400000]
["AfyaImara CountyInpatient7",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",7,"Chronic, Pre-existing conditions, Congenital defects and genetic disorders, HIV/AIDS and related conditions",50000,50000,200000,250000]
["AfyaImara CountyInpatient8",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",8,"Organ Transplant (cost of donor or securing the organ is excluded)",50000,50000,200000,250000]
["AfyaImara CountyInpatient9",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",9,"Psychiatric and Psychological Illnesses",50000,50000,100000,150000]
["AfyaImara CountyInpatient10",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",10,"Post Hospitalization 21 days after discharge (On Reimbursement)",5000,10000,15000,20000]
["AfyaImara CountyInpatient11",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",11,"Neo-natal and prematurity conditions.",50000,100000,200000,250000]
["AfyaImara CountyInpatient12",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",12,"In patient non-accident related dental surgery/ treatment",30000,60000,100000,120000]
["AfyaImara CountyInpatient13",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",13,"In patient non-accident related eye treatments excluding surgery for refractive errors and laser treatment",30000,60000,100000,120000]
[{"$f":"B48&C48&D48","v":"AfyaImara CountyInpatient14"},{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",14,"Accident Related Inpatient Dental and Ophthalmological treatment ",100000,200000,500000,1000000]
["AfyaImara CountyInpatient15",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",15,"Illness related reconstructive/plastic surgery (excludes cosmetic, obstetrics and gynecology related)",50000,75000,100000,120000]
["AfyaImara CountyInpatient16",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",16,"Non accident related maxillofacial surgery (Excluding routine dental surgery and dental fixtures)",30000,75000,150000,200000]
["AfyaImara CountyInpatient17",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",17,"Gynecological surgery ",40000,100000,200000,300000]
["AfyaImara CountyInpatient18",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",18,"Internal and external surgical implants, appliances, joint replacements, and prostheses (excluding dental fixtures)",60000,150000,250000,300000]
["AfyaImara CountyInpatient19",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",19,"Last Expense - Per Member",50000,50000,75000,100000]
["AfyaImara CountyInpatient20",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",20,"Passive War /Terrorism and Political Violence",50000,50000,300000,400000]
["AfyaImara CountyInpatient21",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",21,"Home Nursing (Subject to Pre-authorization)  ","90 days","90 days","90 days","90 days"]
["AfyaImara CountyInpatient22",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",22,"Maternity:   Subject to one (1) waiting period"]
["AfyaImara CountyInpatient23",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",23,"Normal Delivery, Elective & subsequent Caesarean sections, First Ever Emergency Caesarean Section, Including Ectopic Pregnancy, Maternity Complications before & after delivery","Not Covered",30000,40000,50000]
[{"$f":"B58&C58&D58","v":"AfyaImara CountyInpatient24"},{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",24,"Covid-19 Treatment (moderate cases)",100000,250000,250000,250000]
["AfyaImara CountyInpatient25",{"$f":"Lists!$B$5","v":"AfyaImara County"},"Inpatient",25,"Covid-19 Treatment (Critical cases requiring ICU/HDU) \nThis is a cumulative amount that will be inclusive of any amounts already paid for in the treatment of moderate inpatient cases",100000,250000,500000,1000000]
[{"$f":"B60&C60&D60","v":"AfyaImara County1"},{"$f":"Lists!$B$5","v":"AfyaImara County"},null,1,"Outpatient Overall Cover",null,null,null,null,null,null,null,null,null,{"$f":"O3","v":10000},{"$f":"P3","v":25000},{"$f":"Q3","v":50000}]
[{"$f":"B61&C61&D61","v":"AfyaImara County0"},{"$f":"Lists!$B$5","v":"AfyaImara County"},null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"X3","v":20000},{"$f":"Y3","v":40000}]
["AfyaImara County1",{"$f":"Lists!$B$5","v":"AfyaImara County"},null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Maternity Limit","Full Maternity Limit"]
["AfyaImara County2",{"$f":"Lists!$B$5","v":"AfyaImara County"},null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Maternity Limit","Full Maternity Limit"]
["AfyaImara County3",{"$f":"Lists!$B$5","v":"AfyaImara County"},null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Maternity Limit","Full Maternity Limit"]
["AfyaImara County4",{"$f":"Lists!$B$5","v":"AfyaImara County"},null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Full Maternity Limit","Full Maternity Limit"]
[{"$f":"B66&C66&D66","v":"AfyaImara SeniorsInpatient1"},{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",1,"Overall Limit",null,null,500000,1000000,3000000,5000000,10000000]
[{"$f":"B67&C67&D67","v":"AfyaImara SeniorsInpatient2"},{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",2,"Bed",null,null,"General Ward / Max Kes 8,000","General Ward / Max Kes 10,000","Standard Private Room / Max Kes 18,000","Standard Private Room / Max Kes 18,000","En Suite / Max Kes 26,000"]
["AfyaImara SeniorsInpatient3",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",3,"Emergency Evacuation Within East Africa",null,null,"Road Ambulance","Road Ambulance","Road & Air Ambulance","Road & Air Ambulance","Road & Air Ambulance"]
["AfyaImara SeniorsInpatient4",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",4,"Accidents",null,null,"To overall Limit","To overall Limit","To overall Limit","To overall Limit","To overall Limit"]
["AfyaImara SeniorsInpatient5",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",5,"Acute Conditions",null,null,"To overall Limit","To overall Limit","To overall Limit","To overall Limit","To overall Limit"]
["AfyaImara SeniorsInpatient6",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",6,"Newly Diagnosed Chronic illnesses after inception of cover",null,null,350000,700000,2000000,2500000,3500000]
["AfyaImara SeniorsInpatient7",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",7,"Chronic, Pre-existing illnesses, Congenital Conditions & HIV/AIDS ",null,null,250000,400000,700000,800000,1000000]
["AfyaImara SeniorsInpatient8",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",8,"Organ Transplant (cost of donor or securing the organ is excluded). This is in addition to the relevant condition’s benefit allocation.",null,null,100000,200000,200000,300000,500000]
["AfyaImara SeniorsInpatient9",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",9,"Psychiatric and Psychological Illnesses",null,null,200000,300000,500000,500000,700000]
["AfyaImara SeniorsInpatient10",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",10,"Post Hospitalization 21 days after discharge (On Reimbursement)",null,null,20000,20000,30000,30000,30000]
["AfyaImara SeniorsInpatient11",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",11,"In patient non-accident related dental surgery/ treatment",null,null,150000,150000,200000,200000,250000]
["AfyaImara SeniorsInpatient12",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",12,"In patient non-accident related eye treatments excluding surgery for refractive errors and laser treatment",null,null,150000,150000,200000,200000,200000]
["AfyaImara SeniorsInpatient13",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",13,"Accident Related Inpatient Dental and Ophthalmological treatment",null,null,500000,1000000,3000000,5000000,5000000]
["AfyaImara SeniorsInpatient14",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",14,"Illness related reconstructive/plastic surgery (excludes cosmetic, obstetrics and gynecology related)",null,null,200000,200000,250000,300000,300000]
["AfyaImara SeniorsInpatient15",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",15,"Non accident related maxillofacial surgery (Excluding routine dental surgery and dental fixtures)",null,null,200000,300000,400000,400000,500000]
["AfyaImara SeniorsInpatient16",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",16,"Gynecological surgery",null,null,200000,300000,400000,400000,500000]
["AfyaImara SeniorsInpatient17",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",17,"Cost of purchase of internal and external surgical implants, appliances, and prostheses (excluding dental fixtures)",null,null,300000,300000,400000,400000,500000]
["AfyaImara SeniorsInpatient18",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",18,"Last Expense - Per Member (as a stand-alone benefit)",null,null,75000,100000,100000,150000,150000]
["AfyaImara SeniorsInpatient19",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",19,"Passive War /Terrorism and Political Violence ",null,null,300000,500000,700000,1000000,1000000]
["AfyaImara SeniorsInpatient20",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",20,"Covid-19 Treatment (moderate cases)",null,null,250000,250000,250000,250000,250000]
["AfyaImara SeniorsInpatient21",{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Inpatient",21,"Covid-19 Treatment (Critical cases requiring ICU/HDU) ",null,null,500000,1000000,1000000,1000000,1000000]
[{"$f":"B87&C87&D87","v":"AfyaImara SeniorsOutpatient1"},{"$f":"Lists!$B$6","v":"AfyaImara Seniors"},"Outpatient",1,"Outpatient Overall Cover",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S3","v":100000},{"$f":"T3","v":150000},{"$f":"U3","v":200000}]
[{"$f":"B88&C88&D88","v":"AfyaImara JuniorInpatient1"},{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",1,"Overall Limit",null,null,500000,1000000,3000000,5000000]
[{"$f":"B89&C89&D89","v":"AfyaImara JuniorInpatient2"},{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",2,"Bed",null,null,"General Ward","General Ward","Private Room.","Private Room."]
["AfyaImara JuniorInpatient3",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",3,null,null,null,"Max Kes 8,000","Max Kes 8,000","Max Kes 17,000","Max Kes 17,000"]
["AfyaImara JuniorInpatient4",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",4,"Lodger Fee for Accompanying Parent",null,null,"Children 12 Years and below","Children 12 Years and below","Children 12 Years and below","Children 12 Years and below"]
["AfyaImara JuniorInpatient5",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",5,"Emergency Evacuation Within East Africa",null,null,"Road Ambulance","Road Ambulance","Air Ambulance &","Air Ambulance &"]
["AfyaImara JuniorInpatient6",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",6,null,null,null,null,null,"Road Ambulance","Road Ambulance"]
["AfyaImara JuniorInpatient7",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",7,"Pre-existing illnesses",null,null,"Kes 250,000","Kes 450,000","Kes 750,000","Kes 750,000"]
["AfyaImara JuniorInpatient8",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",8,"Organ Transplant (cost of donor or securing the organ is excluded)",null,null,"Kes 500,000","Kes 500,000","Kes 500,000","Kes 500,000"]
["AfyaImara JuniorInpatient9",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",9,"Newly Diagnosed Chronic illnesses",null,null,"Kes 250,000","Kes 500,000","Kes 1,000,000","Kes 1,500,000"]
["AfyaImara JuniorInpatient10",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",10,"Psychiatric and Psychological Illnesses",null,null,"Kes 250,000","Kes 300,000","Kes 500,000","Kes 1,000,000"]
["AfyaImara JuniorInpatient11",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",11,"Post Hospitalization 21 days after discharge",null,null,"Kes 15,000","Kes 15,000","Kes 20,000","Kes 30,000"]
["AfyaImara JuniorInpatient12",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",12,"(Related to Reason for Admission)"]
["AfyaImara JuniorInpatient13",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",13,"Congenital condition, neo-natal and prematurity conditions.",null,null,"Kes 200,000","Kes 250,000","Kes 300,000","Kes 350,000"]
["AfyaImara JuniorInpatient14",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",14,"Non - accidental dental in-patient illnesses.",null,null,"Kes 200,000","Kes 300,000","Kes 300,000","Kes 350,000"]
["AfyaImara JuniorInpatient15",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",15,"Non - accidental Optical in-patient illnesses.",null,null,"Kes 200,000","Kes 300,000","Kes 300,000","Kes 350,000"]
["AfyaImara JuniorInpatient16",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",16,"Accident Related Dental and Optical treatment",null,null,"Full Inpatient Limit","Full Inpatient Limit","Full Inpatient Limit","Full Inpatient Limit"]
["AfyaImara JuniorInpatient17",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",17,"External prosthesis and external medical appliances. Includes wheelchairs, implants",null,null,"Kes 300,000","Kes 400,000","Kes 400,000","Kes 500,000"]
["AfyaImara JuniorInpatient18",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",18,"Last Expense",null,null,"Kes 50,000 Per Person","Kes 75,000 Per Person","Kes 100,000 Per Person","Kes 150,000 Per Person"]
["AfyaImara JuniorInpatient19",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",19,"Passive War /Terrorism and Political Violence treatments",null,null,"Kes 500,000","Kes 1,000,000","Kes 2,000,000","Kes 2,000,000"]
["AfyaImara JuniorInpatient20",{"$f":"Lists!$B$7","v":"AfyaImara Junior"},"Inpatient",20,"Home Nursing(Subject to Pre-authorization)  ",null,null,"90 Days","90 Days","90 Days","90 Days"]
["AfyaImara ExecutiveInpatient1",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",1,"Inpatient Overall Cover (Kshs)",null,null,null,null,null,null,10000000,20000000]
[{"$f":"B109&C109&D109","v":"AfyaImara ExecutiveInpatient2"},{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",2,"Bed limits",null,null,null,null,null,null,"Ensuite (up to 40,000 per day)","Ensuite (up to 40,000 per day)"]
["AfyaImara ExecutiveInpatient3",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",3,"Inpatient expenses related to acute conditions or accidents",null,null,null,null,null,null,"Fully Covered","Fully Covered"]
["AfyaImara ExecutiveInpatient4",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",4,"Pre-existing chronic conditions on full disclosure at the time of joining after one year waiting period",null,null,null,null,null,null,2000000,3000000]
["AfyaImara ExecutiveInpatient5",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",5,"Chronic conditions diagnosed after inception of cover",null,null,null,null,null,null,2000000,5000000]
["AfyaImara ExecutiveInpatient6",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",6,"Gynecological surgery (one year waiting period) ",null,null,null,null,null,null,500000,750000]
["AfyaImara ExecutiveInpatient7",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",7,"Psychiatry and psychotherapy after one year of cover",null,null,null,null,null,null,500000,750000]
["AfyaImara ExecutiveInpatient8",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",8,"Cancer treatment after one year of cover",null,null,null,null,null,null,2000000,3000000]
["AfyaImara ExecutiveInpatient9",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",9,"Congenital defects and genetic disorders after one year of cover",null,null,null,null,null,null,500000,750000]
["AfyaImara ExecutiveInpatient10",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",10,"HIV / AIDS and related conditions after one year of cover",null,null,null,null,null,null,2000000,4000000]
["AfyaImara ExecutiveInpatient11",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",11,"Illness related reconstructive/plastic surgery from the third year of cover (excludes cosmetic, obstetrics and gynecology related) ",null,null,null,null,null,null,250000,500000]
["AfyaImara ExecutiveInpatient12",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",12,"Non accident related maxillofacial surgery (Excluding routine dental surgery and dental fixtures) after one year of cover",null,null,null,null,null,null,500000,750000]
["AfyaImara ExecutiveInpatient13",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",13,"In patient non-accident related eye treatments excluding surgery for refractive errors and laser treatment (one year waiting period)",null,null,null,null,null,null,250000,500000]
["AfyaImara ExecutiveInpatient14",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",14,"In patient non-accident related dental surgery/treatment (after six months of cover and subject to written pre-authorization)",null,null,null,null,null,null,250000,500000]
["AfyaImara ExecutiveInpatient15",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",15,"Organ transplantation after two years of cover (cost of donor or securing the organ is excluded)",null,null,null,null,null,null,500000,750000]
["AfyaImara ExecutiveInpatient16",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",16,"Internal and external surgical implants and joint replacements (excluding dental fixtures) after one year of cover",null,null,null,null,null,null,750000,1000000]
["AfyaImara ExecutiveInpatient17",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",17,"Post-hospitalization treatment related to cause of pre-authorization (limited to the first 3 weeks after discharge)",null,null,null,null,null,null,150000,200000]
["AfyaImara ExecutiveInpatient18",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",18,"Last Expenses per member (death as a result of covered conditions)",null,null,null,null,null,null,300000,350000]
[{"$f":"B126&C126&D126","v":"AfyaImara ExecutiveInpatient19"},{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",19,"  "]
["AfyaImara ExecutiveInpatient20",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",20,"Maternity- As a limit within Overall Inpatient Cover",null,null,null,null,null,null,400000,600000]
["AfyaImara ExecutiveInpatient21",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Inpatient",21,"  "]
["AfyaImara ExecutiveOutpatient1",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Outpatient",1,"Outpatient Overall Cover",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U3","v":200000},{"$f":"V3","v":250000}]
["AfyaImara ExecutiveOutpatient2",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Outpatient",2,"WELLNESS PACKAGE (Principal Member & Spouse Only)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50000,50000]
["AfyaImara ExecutiveOutpatient3",{"$f":"Lists!$B$8","v":"AfyaImara Executive"},"Outpatient",3,"Dental/Optical Checkups",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25000,25000]

{"sheet":"AfyaImara","index":7,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":true,"merged":[[0,2,0,6]]}
[null,null,"INPATIENT",null,null,null,null,null,null,"Outpatient Rates"]
[null,"AfyaImara Rates",null,null,null,null,null,"OP Option","Family Size","Limit",50000,60000,100000,150000,200000,"N/A"]
[null,"19 yrs - 29 yrs",500000,1000000,3000000,5000000,10000000,null,1,"M",32934,33266,35226,37892,41512]
[null,"Principal Member",32256.6875,34283.6875,49171.6875,53024.6875,60534.6875,"Yes",2,"M+1",44986,49269,66533,70452,77987]
[null,"Spouse",23900,25582,38516,41671,46337,"No",3,"M+2",48748,54844,82895,88794,92489]
[null,"Child (0 -18 yrs)",13929,17102,26795,28496,31578,null,4,"M+3",48797,55910,98147,106762,111223]
[null,"30 yrs - 40 yrs",null,null,null,null,null,null,5,"M+4",48846,57804,98245,121829,126966]
[null,"Principal Member",33863,35223,52342,56437,64692,null,6,"M+5",49339,58095,99028,136895,142709]
[null,"Spouse",25023,26785,40457,43799,48736,null,7,"M+6",49837,58387,99282,148202,157539]
[null,"Child (0 -18 yrs)",13929,17102,26795,28496,31578]
[null,"41 yrs - 50 yrs"]
[null,"Principal Member",38058.84375,39384.84375,62184.84375,62633.84375,68869.84375,null,null,"YES","NO"]
[null,"Spouse",26128,27925,46043,46446,49650]
[null,"Child (0 -18 yrs)",13929,17102,26795,28496,31578,null,{"$f":"MATCH(\"M+1\",$J$3:$J$9,0)","v":2}]
[null,"51 yrs - 65 yrs"]
[null,"Principal Member",55550.125,56704.125,76889.125,82030.125,91449.125,null,null,"OP LIMITS RULES"]
[null,"Spouse",31575,34484,50161,54280,60121,null,"IP","OP Limit"]
[null,"Child (0 -18 yrs)",13929,17102,26795,28496,31578,null,500000,60000]
[null,"66 Years and Above",null,null,null,null,null,null,1000000,60000]
[null,"Principal Member",82829,95227,142417,162180,185511,null,3000000,100000]
[null,"Spouse",64526,78683,115311,131186,145655,null,5000000,200000]
[null,"Child (0 -18 yrs.)",13929,17102,26795,28496,31578,null,10000000,200000]
[]
[null,"Outpatient Per Life"]
[null,"Option","Limit","Premium/Person"]
[null,"Option 1",150000,33800]
[null,"Option 2",100000,30732]
[null,"Option 3",60000,26247]
[]
[null,"Maternity Per Family"]
[null,"Option","Limit","Premium/Family"]
[null,"Option 1",100000,25650]
[null,"Option 2",75000,17100]
[null,"Option 3",40000,10830]
[]
[null,"Optical & Dental Per Life"]
[null,"Option","Dental Limit","Optical Limit","Premium/Life"]
[null,1,15000,15000,12190]
[null,2,30000,25000,18390]

{"sheet":"AfyaImaraCounty","index":8,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
[null,"AfyaImara County Rates",null,null,null,null,null,null,"Family Size","Limit",25000,40000,50000,"N/A"]
[null,"19 yrs. - 29 yrs.",100000,250000,500000,1000000,null,null,1,"M",9390,10821,11775]
[null,"Principal Member",11184,14833,23189,26908,null,null,2,"M+1",10841,18050,22856]
[null,"Spouse",9438,11223,17818,20488,null,null,3,"M+2",15921,22120,26252]
[null,"Child (0 -18 yrs.)",5438,6725,10552,13856,null,null,4,"M+3",21002,26647,30411]
[null,"30 yrs. - 40 yrs.",null,null,null,null,null,null,5,"M+4",23856,30788,35408]
[null,"Principal Member",11752,15471,24203,28068,null,null,6,"M+5",24603,34661,41366]
[null,"Spouse",9846,11681,18638,21428]
[null,"Child (0 -18 yrs.)",5438,6725,10552,13856]
[null,"41 yrs. - 50 yrs."]
[null,"Principal Member",14100,18111,28495,32864]
[null,"Spouse",11722,13791,22072,25262]
[null,"Child (0 -18 yrs.)",5438,6725,10552,13856]
[null,"51 yrs. - 70 yrs."]
[null,"Principal Member",17662,22117,34445,40144]
[null,"Spouse",14600,17027,26622,31142]
[null,"Child (0 -18 yrs.)",5438,6725,10552,13856]
[]
[null,"Outpatient Per Life"]
[null,"Option","Limit","Premium/Life"]
[null,"Option 1",50000,10239]
[null,"Option 2",25000,8165]
[null,"Option 3",10000,5053]
[]
[null,"Maternity Per Family"]
[null,"Option","Limit","Premium/Family"]
[null,"Option 1",40000,9500]
[null,"Option 2",20000,5700]

{"sheet":"AfyaImaraSeniors","index":9,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,"AfyaImara Seniors Rates"]
[null,"Inpatient Per Person",500000,1000000,3000000,5000000,10000000]
[null,"Rate Per Person",116352,132299,178535,206231,229049]
[]
[null,"Outpatient Per Person",100000,150000,200000]
[null,"Rate Per Person",94968,101270,107534]
[]
[null,"Dental and Optical Rates"]
[null,"Limit","Dental 20,000","Optical 20,000"]
[null,"Per Person",16176,16176,{"$f":"D11+C11","v":32352}]

{"sheet":"AfyaImaraExecutive","index":10,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,3,1,4]]}
[]
[null,null,null,"Annual Cover limits"]
[null,"Age Band","Beneficiary",10000000,20000000]
[]
[null,"19 yrs - 29 yrs","Principal Member",222424,259199]
[null,null,"Spouse",195174,228056]
[null,null,"Child (0 months to 18 yrs)",97360,111268]
[]
[null,"30 yrs - 40 yrs","Principal Member",231972,270111]
[null,null,"Spouse",203059,237067]
[null,null,"Child (0 months to 18 yrs)",97360,111268]
[]
[null,"41 yrs - 50 yrs","Principal Member",243559,283353]
[null,null,"Spouse",211374,246570]
[null,null,"Child (0 months to 18 yrs)",97360,111268]
[]
[null,"51 yrs - 65 yrs","Principal Member",280840,325959]
[null,null,"Spouse",241896,281452]
[null,null,"Child (0 months to 18 yrs)",97360,111268]
[]
[null,"65 yrs - 80 yrs","Principal Member",556653,641175]
[null,null,"Spouse",471379,543718]
[null,null,"Child (0 months to 18 yrs)",97360,111268]
[]
[]
[null,"Cover Limit",200000,250000]
[null,"0 months to 18 yrs",43029,47030]
[null,"19 yrs - 29 yrs",54286,59334]
[null,"30 yrs - 40 yrs",64577,70582]
[null,"41 yrs - 50 yrs",79820,87243]
[null,"51 yrs - 65 yrs",95064,103904]
[null,"65 yrs - 80 yrs",102605,112146]