{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Vision","Vision Retail Network"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Vision","index":0,"n_rows":56,"n_cols":10,"rows_kept":56,"merged":[[0,1,0,2],[0,4,0,5],[0,6,0,9],[1,1,1,2],[1,4,1,5],[1,6,1,7],[1,8,1,9],[2,1,2,2],[3,1,3,2],[4,1,4,2],[4,4,4,5],[4,6,4,7],[4,8,4,9],[5,1,5,2],[5,6,5,7],[6,1,6,2],[6,6,13,7],[6,8,6,9],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[13,4,13,5],[13,8,13,9],[14,1,14,2],[14,6,17,7],[15,1,15,2],[16,1,16,2],[17,1,17,2],[17,4,17,5],[17,8,17,9],[18,1,18,2],[18,6,25,7],[18,8,18,9],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[25,4,25,5],[25,8,25,9],[26,1,26,2],[26,4,26,5],[26,6,26,7],[26,8,26,9],[27,1,27,2],[27,4,27,5],[27,6,27,9],[29,1,30,2],[29,4,29,5],[29,6,29,9],[30,4,30,5],[30,6,30,7],[30,8,30,9],[31,4,31,5],[31,6,31,7],[31,8,31,9],[32,4,32,5],[32,6,32,7],[32,8,32,9],[33,4,33,5],[33,6,33,7],[33,8,33,9],[34,4,34,5],[34,6,34,7],[34,8,34,9],[35,1,35,2],[35,4,35,5],[35,6,35,7],[35,8,35,9],[36,1,36,2],[36,4,36,5],[36,6,36,7],[36,8,36,9],[37,6,37,9],[38,1,38,2],[38,4,38,5],[38,6,38,7],[38,8,38,9],[40,1,40,9],[43,1,43,4],[46,4,47,4],[46,6,47,6],[46,7,47,7],[46,8,47,8],[46,9,47,9]]}
[{"$nulls":6},"Carrier Name"]
[null,"Vision Benefits",null,null,"Example Responses",null,"Base Plan",null,"Buy Up Plan"]
[null,"Network",null,null,"Network","Non- Network","Network","Non- Network","Network","Non- Network"]
[null,"Exam",null,null,"$XX Copay","$XX Allowance"]
[null,"Frequency",null,null,"Once Every XX Months"]
[null,"Materials",null,null,"$XX Copay","N/A","Not Covered"]
[null,"Lenses",{"$nulls":4},"Not Covered"]
[null,"Single Lenses",null,null,"100% after Materials Copay","$XX Allowance"]
[null,"Bifocal Lenses",null,null,"100% after Materials Copay","$XX Allowance"]
[null,"Trifocal Lenses",null,null,"100% after Materials Copay","$XX Allowance"]
[null,"Lenticular Lenses",null,null,"100% after Materials Copay","$XX Allowance"]
[null,"Standard Progressive",null,null,"100% after Materials Copay","$XX Allowance"]
[null,"Premium Progressive",null,null,"100% after Materials Copay","$XX Allowance"]
[null,"Frequency",null,null,"Once Every XX Months"]
[null,"Frames",{"$nulls":4},"Not Covered"]
[null,"Retail Allowance",null,null,"$","$"]
[null,"Remaining Balance Discount",null,null,"%","N/A"]
[null,"Frequency",null,null,"Once Every XX Months"]
[null,"Contact Lenses",{"$nulls":4},"Not Covered"]
[null,"Contact Lens Fitting - Standard",null,null,"$XX Copay","N/A"]
[null,"Contact Lens Fitting - Premium",null,null,"$XX Copay","N/A"]
[null,"Elective Allowance - Conventional",null,null,"$","$"]
[null,"Elective Allowance - Disposable",null,null,"$","$"]
[null,"Remaining Balance Discount",null,null,"%","N/A"]
[null,"Medically Necessary Allowance",null,null,"Covered 100%","$"]
[null,"Frequency",null,null,"Once Every XX Months"]
[null,"Lasik Benefits",null,null,"Discounts Available"]
[null,"Participation Requirement",null,null,"%"]
[]
[null,"Monthly Rates",{"$nulls":4},{"$f":"G1","v":"Carrier Name"}]
[{"$nulls":6},{"$f":"G2","v":"Base Plan"},null,{"$f":"I2","v":"Buy Up Plan"}]
[null,"Employee Only",null,null,{"v":0,"d":"$0.00"}]
[null,"Employee + Spouse",null,null,{"v":0,"d":"$0.00"}]
[null,"Employee + Child(ren)",null,null,{"v":0,"d":"$0.00"}]
[null,"Family",null,null,{"v":0,"d":"$0.00"}]
[null,"Monthly Total",{"$nulls":4},{"$f":"SUMPRODUCT($C$32:$C$35, G32:G35)","v":{"v":0,"d":"$0"}},null,{"$f":"SUMPRODUCT($D$32:$D$35, I32:I35)","v":{"v":0,"d":"$0"}}]
[null,"Annual Total by Plan",{"$nulls":4},{"$f":"G36*12","v":{"v":0,"d":"$0"}},null,{"$f":"I36*12","v":{"v":0,"d":"$0"}}]
[null,"Annual Total",{"$nulls":4},{"$f":"G37+I37","v":{"v":0,"d":"$0"}}]
[null,"Rate Guarantee",null,null,"5 Years"]
[null,"Notes:"]
[null,"\"This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  Please refer to the actual quote from the insurance company for specific coverage details and rates.\""]
[]
[]
[]
[{"$nulls":4},"    Complete the table below with the monthly rates for the coverage proposed above.  "]
[]
[{"$nulls":4},"Monthly Rates","Year 1","Year 2\n (1/1/23 -12/31/23)","Year 3\n (1/1/24 -12/31/24)","Year 4*\n (1/1/25 -12/31/25","Year 5*\n (1/1/26 -12/31/26)"]
[{"$nulls":5},"(1/1/22 -12/31/22)"]
[{"$nulls":4},"BASE PLAN      "]
[{"$nulls":4},"   Employee Only","$","$","$","$","$"]
[{"$nulls":4},"BUY-UP PLAN"]
[{"$nulls":4},"   Employee Only","$","$","$","$","$"]
[{"$nulls":4},"   Employee + Spouse","$","$","$","$","$"]
[{"$nulls":4},"   Employee + Child(ren)","$","$","$","$","$"]
[{"$nulls":4},"   Family","$","$","$","$","$"]
[{"$nulls":4},"* In order for the contract to extend to years 4 and 5, the proposer must provide firm premium rates for those years."]

{"sheet":"Vision Retail Network","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[13,1,13,2],[14,1,14,2],[15,1,15,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[21,1,21,2],[22,1,22,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[28,1,28,2],[29,1,29,2],[38,1,38,2]]}
[null,null,"Carrier Name"]
[null,"Network","Network Name"]
[null,"LensCrafters","P"]
[null,"Wal-Mart Vision Center","P"]
[null,"Sam's Club","P"]
[null,"Target Optical","P"]
[null,"EyeGlass World","P"]
[null,"Visionworks","P"]
[null,"PearleVision","P"]
[null,"Costco","P"]
[null,"America's Best","P"]
[]
[null,"Carrier Website:"]