{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Powers","Calculator","MG Calculator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Powers","index":0,"n_rows":43,"n_cols":6,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
["Rx","Power","Diopters flat","Reverse","Alignment 2","Optic Zone"]
[1,2.25,{"$f":"B3+A3","v":3.25},{"$f":"C3+2","v":5.25},-0.62,6]
[1.1200000000000001,2.25,3.37,{"$f":"C4+2","v":5.37},-0.62]
[1.25,2.25,3.5,5.5,-0.62]
[1.37333333333333,2.25,3.62333333333333,5.6233333333333295,-0.62,"Steep Curve Width"]
[1.49833333333333,2.25,3.74833333333333,5.7483333333333295,-0.62,1]
[1.62333333333333,2,3.62333333333333,{"$f":"C8+2.25","v":5.8733333333333295},-0.75]
[1.74833333333333,2,3.74833333333333,{"$f":"C9+2.25","v":5.9983333333333295},-0.75]
[1.87333333333333,2,3.87333333333333,6.1233333333333295,-0.75]
[1.99833333333333,2,3.99833333333333,6.2483333333333295,-0.75]
[2.12333333333333,2,4.1233333333333295,6.3733333333333295,-0.75]
[2.24833333333333,1.75,3.99833333333333,{"$f":"C13+2.5","v":6.4983333333333295},-0.87]
[2.37333333333333,1.75,4.1233333333333295,{"$f":"C14+2.5","v":6.6233333333333295},-0.87]
[2.49833333333333,1.75,4.2483333333333295,6.7483333333333295,-0.87]
[2.62333333333333,1.75,4.3733333333333295,6.8733333333333295,-0.87]
[2.74833333333333,1.75,4.4983333333333295,6.9983333333333295,-0.87]
[2.87333333333333,1.5,4.3733333333333295,{"$f":"C18+2.75","v":7.1233333333333295},-1]
[2.99833333333333,1.5,4.4983333333333295,{"$f":"C19+2.75","v":7.2483333333333295},-1]
[3.12333333333333,1.5,4.6233333333333295,7.3733333333333295,-1]
[3.24833333333333,1.5,4.7483333333333295,7.4983333333333295,-1]
[3.37333333333333,1.5,4.8733333333333295,7.6233333333333295,-1]
[3.49833333333333,1.25,4.7483333333333295,{"$f":"C23+3","v":7.7483333333333295},-1.1200000000000001]
[3.62333333333333,1.25,4.8733333333333295,{"$f":"C24+3","v":7.8733333333333295},-1.1200000000000001]
[3.74833333333333,1.25,4.9983333333333295,7.9983333333333295,-1.1200000000000001]
[3.87333333333333,1.25,5.1233333333333295,8.1233333333333295,-1.1200000000000001]
[3.99833333333333,1.25,5.2483333333333295,8.2483333333333295,-1.1200000000000001]
[4.1233333333333304,1,5.1233333333333304,{"$f":"C28+3.25","v":8.3733333333333313},-1.25]
[4.2483333333333304,1,5.2483333333333304,{"$f":"C29+3.25","v":8.4983333333333313},-1.25]
[4.37,1,5.37,8.620000000000001,-1.25]
[4.4983333333333304,1,5.4983333333333304,8.7483333333333313,-1.25]
[4.62,1,5.62,8.870000000000001,-1.25]
[4.7483333333333304,0.75,5.4983333333333304,{"$f":"C33+3.5","v":8.9983333333333313},-1.37]
[4.87,0.75,5.62,{"$f":"C34+3.5","v":9.120000000000001},-1.37]
[4.9983333333333304,0.75,5.7483333333333304,9.2483333333333313,-1.37]
[5.12,0.75,5.87,9.370000000000001,-1.37]
[5.25,0.75,6,9.5,-1.37]
[5.37,0.5,5.87,{"$f":"C38+3.75","v":9.620000000000001},-1.5]
[5.5,0.5,6,{"$f":"C39+3.75","v":9.75},-1.5]
[5.62,0.5,6.12,9.870000000000001,-1.5]
[5.75,0.5,6.25,10,-1.5]
[5.87,0.5,6.37,10.120000000000001,-1.5]
[6,0.5,{"$f":"B43+A43","v":6.5},{"$f":"C43+3.75","v":10.25},-1.5]

{"sheet":"Calculator","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,3,1,4],[5,1,5,2],[5,3,5,4]]}
[]
[null,"Right (OD)",null,"Left (OS)"]
[null,"Flat K",45,"Flat K",46.75]
[null,"Rx",6,"Rx",1]
[null,"HVID",12,"HVID",12]
[null,"LENS SPECIFICATIONS",null,"LENS SPECIFICATIONS"]
[null,"Base Curve",{"$f":"337.48/((C3-(C8+C4)))","v":8.7657142857142869},"Base Curve",{"$f":"337.48/((E3-(E8+E4)))","v":7.7581609195402299}]
[null,"Power",{"$f":"LOOKUP(C4,Powers!A3:A42,Powers!B3:B42)","v":0.5},"Power",{"$f":"LOOKUP(Calculator!E4,Powers!A3:A42,Powers!B3:B42)","v":2.25}]
[null,"Diameter",{"$f":"_xlfn.IFS(C5>12,\"11\",C5>10.9,\"10.6\",C5>9.6,\"10.2\")","v":"10.6"},"Diameter",{"$f":"_xlfn.IFS(E5>12,\"11\",E5>10.9,\"10.6\",E5>9.6,\"10.2\")","v":"10.6"}]
[null,"Optic Zone",6,"Optic Zone",6]
[null,null,{"$f":"LOOKUP(C4,Powers!A3:A43,Powers!D3:D43)+(337.48/C7)","v":48.75},null,{"$f":"LOOKUP(E4,Powers!A3:A43,Powers!D3:D43)+(337.48/E7)","v":48.75}]
[null,"Steep Curve",{"$f":"337.48/C11","v":6.9226666666666672},"Steep Curve",{"$f":"337.48/E11","v":6.9226666666666672}]
[null,"Width",1,"Width",1]
[null,"Alignment 1",{"$f":"337.48/C3","v":7.4995555555555562},"Alignment 1",{"$f":"337.48/E3","v":7.2188235294117655}]
[null,"Width",{"$f":"_xlfn.IFS(C5>10.9,\".6\",C5>9.6,\".5\")","v":".6"},"Width",{"$f":"_xlfn.IFS(E5>10.9,\".6\",E5>9.6,\".5\")","v":".6"}]
[null,null,{"$f":"LOOKUP(C4,Powers!A3:A43,Powers!E3:E43)+C3","v":43.5},null,{"$f":"LOOKUP(E4,Powers!A3:A43,Powers!E3:E43)+E3","v":46.13}]
[null,"Alignment 2",{"$f":"337.48/C16","v":7.7581609195402299},"Alignment 2",{"$f":"337.48/E16","v":7.3158465207023626}]
[null,"Width",{"$f":"_xlfn.IFS(C5>12,\".5\",C5>10.9,\".4\",C5>9.6,\".3\")","v":".4"},"Width",{"$f":"_xlfn.IFS(E5>12,\".5\",E5>10.9,\".4\",E5>9.6,\".3\")","v":".4"}]
[null,"Peripheral Curve",{"$f":"_xlfn.IFS(C5>11.9,\"12.00\",C5>10.9,\"12.00\",C5>9.9,\"11.50\",C5>8.9,\"11.50\")","v":"12.00"},"Peripheral Curve",{"$f":"_xlfn.IFS(E5>11.9,\"12.00\",E5>10.9,\"12.00\",E5>9.9,\"11.50\",E5>8.9,\"11.50\")","v":"12.00"}]
[null,"Width",{"$f":"_xlfn.IFS(C5>12,\".4\",C5>10.9,\".3\",C5>9.9,\".3\",C5>8.9,\".3\")","v":".3"},"Width",{"$f":"_xlfn.IFS(E5>12,\".4\",E5>10.9,\".3\",E5>9.9,\".3\",E5>8.9,\".3\")","v":".3"}]

{"sheet":"MG Calculator","index":2,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[10,2,10,6],[4,3,4,6],[5,3,5,6],[6,3,6,6],[7,3,7,6],[8,3,8,6],[40,2,40,6],[11,2,11,3],[11,5,11,6],[16,3,16,6],[21,2,21,6],[22,2,22,3],[22,5,22,6]]}
[]
[]
[]
[null,null,{"$f":"TODAY()","v":"2022-04-15"}]
[null,null,"Account Number:"]
[null,null,"Point of Contact Name:"]
[null,null,"Phone Number:"]
[null,null,"Email:"]
[null,null,"Patient Name:"]
[]
[null,null,"ENTER PATIENT DATA"]
[null,null,"OD LENS",null,null,"OS LENS"]
[null,null,"Flat K (D)",3,null,"Flat K (D)",null,null,null," "]
[null,null,"Rx (sphere) \n(between -1.00 and -6.00)",-1,null,"Rx (sphere) \n(between -1.00 and -6.00)"]
[null,null,"HVID (mm)",14,null,"HVID (mm)"]
[]
[null,null,"NOTES:",null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,"MG LENS DESIGN"]
[null,null,"OD LENS",null,null,"OS LENS"]
[null,null,"POWER",{"$f":"LOOKUP(-D14,Powers!A3:A43,Powers!B3:B43)","v":2.25},null,"POWER",{"$f":"LOOKUP(-G14,Powers!A3:A43,Powers!B3:B43)","v":{"$error":"#N/A"}}]
[null,null,"BASE CURVE",{"$f":"337.48/((D13-(D24-D14)))","v":-1349.92},null,"BASE CURVE",{"$f":"337.48/((G13-(G24-G14)))","v":{"$error":"#N/A"}}]
[null,null,"DIAMETER",{"$f":"_xlfn.IFS(D15>12,\"11\",D15>10.9,\"10.6\",D15>9.6,\"10.2\")","v":"11"},null,"DIAMETER",{"$f":"_xlfn.IFS(G15>12,\"11\",G15>10.9,\"10.6\",G15>9.6,\"10.2\")","v":{"$error":"#N/A"}}]
[null,null,"OZ",{"$f":"Powers!F3","v":6},null,"OZ",{"$f":"Powers!F3","v":6}]
[null,null,"STEEP CURVE RADIUS",{"$f":"337.48/(LOOKUP(-D14,Powers!$A3:$A43,Powers!$D3:$D43)+(337.48/'MG Calculator'!D25))","v":67.496000000000009},null,"STEEP CURVE RADIUS",{"$f":"337.48/(LOOKUP(-G14,Powers!$A3:$A43,Powers!$D3:$D43)+(337.48/'MG Calculator'!G25))","v":{"$error":"#N/A"}}]
[null,null,"STEEP CURVE WIDTH",{"$f":"Powers!F7","v":1},null,"STEEP CURVE WIDTH",{"$f":"Powers!F7","v":1}]
[null,null,"ALIGHNMENT CURVE 1 RADIUS",{"$f":"337.48/D13","v":112.49333333333334},null,"ALIGHNMENT CURVE 1 RADIUS",{"$f":"337.48/G13","v":{"$error":"#DIV/0!"}}]
[null,null,"ALIGNMENT CURVE 1 WIDTH",{"$f":"_xlfn.IFS(D15>10.9,\"0.6\",D15>9.6,\"0.5\")","v":"0.6"},null,"ALIGNMENT CURVE 1 WIDTH",{"$f":"_xlfn.IFS(G15>10.9,\"0.6\",G15>9.6,\"0.5\")","v":{"$error":"#N/A"}}]
[null,null,"ALIGHNMENT CURVE 2 RADIUS",{"$f":"337.48/(LOOKUP(-D14,Powers!A3:A43,Powers!E3:E43)+D13)","v":141.79831932773109},null,"ALIGHNMENT CURVE 2 RADIUS",{"$f":"337.48/(LOOKUP(-G14,Powers!A3:A43,Powers!E3:E43)+G13)","v":{"$error":"#N/A"}}]
[null,null,"ALIGNMENT CURVE 2 WIDTH",{"$f":"_xlfn.IFS(D15>12,\"0.5\",D15>10.9,\"0.4\",D15>9.6,\"0.3\")","v":"0.5"},null,"ALIGNMENT CURVE 2 WIDTH",{"$f":"_xlfn.IFS(G15>12,\"0.5\",G15>10.9,\"0.4\",G15>9.6,\"0.3\")","v":{"$error":"#N/A"}}]
[null,null,"PERIPHERAL CURVE RADIUS",{"$f":"_xlfn.IFS(D15>11.9,\"12.00\",D15>10.9,\"12.00\",D15>9.9,\"11.50\",D15>8.9,\"11.50\")","v":"12.00"},null,"PERIPHERAL CURVE RADIUS",{"$f":"_xlfn.IFS(G15>11.9,\"12.00\",G15>10.9,\"12.00\",G15>9.9,\"11.50\",G15>8.9,\"11.50\")","v":{"$error":"#N/A"}}]
[null,null,"PERIPHERAL CURVE WIDTH",{"$f":"_xlfn.IFS(D15>12,\"0.4\",D15>10.9,\"0.3\",D15>9.9,\"0.3\",D15>8.9,\"0.3\")","v":"0.4"},null,"PERIPHERAL CURVE WIDTH",{"$f":"_xlfn.IFS(G15>12,\"0.4\",G15>10.9,\"0.3\",G15>9.9,\"0.3\",G15>8.9,\"0.3\")","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[null,null,"Visionary Contact Lens\ninfo@visionarylens.com\n800-488-2020"]