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

{"sheet":"Sheet1","index":0,"n_rows":44,"n_cols":12,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Rays at a single spherical interface in the paraxial approximation."]
[]
[null,null,"x","z",null,null,"Type Ctrl+m to run the macro."]
["R1 (cm)",3,2,{"$f":"-SIGN($B$4)*SQRT($B$4^2-C4^2)+$B$4","v":0.76393202250021019}]
[null,null,{"$f":"C4-0.1","v":1.9},{"$f":"-SIGN($B$4)*SQRT($B$4^2-C5^2)+$B$4","v":0.67836264675122004}]
[null,null,{"$f":"C5-0.1","v":1.7999999999999998},0.59999999999999964]
[null,null,1.6999999999999997,0.52815858113834491]
["n1",1,1.5999999999999996,0.46228449191009569]
["n2",1.5,1.4999999999999996,0.40192378864668354]
[null,null,1.3999999999999995,0.3467001677156798]
["object x",0.3,1.2999999999999994,0.29629883308084493]
["object z",-18,1.1999999999999993,0.25045458302649592]
["q(max)",0.05,1.0999999999999992,0.20894285260942702]
["limit",20,0.99999999999999922,0.17157287525380971]
[null,null,0.89999999999999925,0.1381823957491628]
[null,null,0.79999999999999927,0.10863354103980782]
[null,null,0.69999999999999929,8.2809570837035551E-2]
[null,null,0.59999999999999931,6.0612308660186187E-2]
[null,null,0.49999999999999933,4.1960108450191935E-2]
[null,null,0.39999999999999936,2.6786250536298795E-2]
[null,null,0.29999999999999938,1.5037688680139993E-2]
[null,null,0.19999999999999937,6.67409058084667E-3]
[null,null,9.9999999999999367E-2,1.6671298870098994E-3]
[null,null,-6.3837823915946501E-16,0,null,"The ray tracing matrices:"]
[null,null,-0.10000000000000064,1.6671298870098994E-3,null,"T23",null,"R",null,"T12",null,"r1"]
[null,null,{"$f":"C25-0.1","v":-0.20000000000000065},6.674090580847114E-3,null,1,0,1,{"$f":"(B8-B9)/B4","v":-0.16666666666666666},1,0,{"$f":"B8*B13","v":0.05}]
[null,null,-0.30000000000000066,1.5037688680139993E-2,null,{"$f":"B14/B9","v":13.333333333333334},1,0,1,{"$f":"-B12/B8","v":18},1,{"$f":"B11","v":0.3}]
[null,null,-0.40000000000000069,2.6786250536298795E-2,null,"The results of the matrix multiplications:"]
[null,null,-0.50000000000000067,4.1960108450191935E-2,null,{"$f":"MMULT(F26:G27,H29:H30)","v":-0.14999999999999997},null,{"$f":"MMULT(H26:I27,J29:J30)","v":-0.14999999999999997},null,{"$f":"MMULT(J26:K27,L26:L27)","v":0.05}]
[null,null,-0.60000000000000064,6.0612308660186631E-2,null,-0.7999999999999996,null,1.2,null,1.2]
[null,null,{"$f":"C30-0.1","v":-0.70000000000000062},8.2809570837035551E-2]
[null,null,{"$f":"C31-0.1","v":-0.8000000000000006},0.10863354103980782]
[null,null,{"$f":"C32-0.1","v":-0.90000000000000058},0.13818239574916324,null,"Results:"]
[null,null,{"$f":"C33-0.1","v":-1.0000000000000007},0.17157287525381015,"z",-18,0,20]
[null,null,{"$f":"C34-0.1","v":-1.1000000000000008},0.20894285260942791,"ray1 x",0.3,1.2,-0.8]
[null,null,-1.2000000000000008,0.25045458302649637,"ray2 x",0.3,0.9,-0.65555555555555567]
[null,null,-1.3000000000000009,0.29629883308084537,"ray3 x",0.3,0.6,-0.51111111111111107]
[null,null,-1.400000000000001,0.34670016771568068,"ray4 x",0.3,0.3,-0.36666666666666675]
[null,null,-1.5000000000000011,0.40192378864668488,"ray5 x",0.3,1.1102230246251565E-16,-0.22222222222222227]
[null,null,-1.6000000000000012,0.46228449191009657,"ray6 x",0.3,-0.3,-7.777777777777789E-2]
[null,null,-1.7000000000000013,0.5281585811383458,"ray7 x",0.3,-0.6,6.6666666666666652E-2]
[null,null,-1.8000000000000014,0.60000000000000098]
[null,null,-1.9000000000000015,0.67836264675122138]
[null,null,-2.0000000000000013,0.76393202250021153]