{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":1,"images":0,"macros":0,"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":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Find the principal points and focal points of a lens in the paraxial approximation:"]
[null,null,"lens drawing"]
[null,null,"x","z"]
["R1 (cm)",3,1.3,{"$f":"-SIGN($B$4)*SQRT($B$4^2-C4^2)+$B$4","v":0.29629883308084537}]
["R2 (cm)",-3,{"$f":"C4-0.1","v":1.2},{"$f":"-SIGN($B$4)*SQRT($B$4^2-C5^2)+$B$4","v":0.25045458302649592}]
["D (cm)",1,{"$f":"C5-0.1","v":1.0999999999999999},0.20894285260942747]
["n1",1,0.99999999999999989,0.17157287525380971]
["n2",1,0.89999999999999991,0.13818239574916324]
["n'",1.5,0.79999999999999993,0.10863354103980782]
["P",{"$f":"(B9-B7)/B4","v":0.16666666666666666},0.7,8.2809570837035551E-2]
["P'",{"$f":"(B8-B9)/B5","v":0.16666666666666666},0.6,6.0612308660186187E-2]
["Psyst",{"$f":"B10+B11-B10*B11*B6/B9","v":0.31481481481481477},0.5,4.1960108450191935E-2]
["D1",{"$f":"-B11*B6/(B12*B9)","v":-0.35294117647058826},0.4,2.6786250536298795E-2]
["D2",{"$f":"-B10*B6/(B12*B9)","v":-0.35294117647058826},0.30000000000000004,1.5037688680139993E-2]
["t",{"$f":"B6*(1-(B10+B11)/(B9*B12))","v":0.29411764705882348},0.20000000000000004,6.67409058084667E-3]
[null,null,0.10000000000000003,1.6671298870098994E-3]
["f",{"$f":"B7/B12","v":3.1764705882352944},0,0]
["f'",{"$f":"B8/B12","v":3.1764705882352944},-0.1,1.6671298870098994E-3]
[null,null,-0.2,6.67409058084667E-3]
[null,null,-0.30000000000000004,1.5037688680139993E-2]
[null,null,-0.4,2.6786250536298795E-2]
[null,null,-0.5,4.1960108450191935E-2]
[null,null,-0.6,6.0612308660186187E-2]
[null,null,-0.7,8.2809570837035551E-2]
[null,null,-0.79999999999999993,0.10863354103980782,null,null,"z coordinate of:"]
[null,null,{"$f":"C25-0.1","v":-0.89999999999999991},0.13818239574916324,null,"Plane 1 (H)",null,null,"F",null,null,"orange line:","H"]
[null,null,-0.99999999999999989,0.17157287525380971,null,{"$f":"-B13","v":0.35294117647058826},1.5,null,{"$f":"-B13-B17","v":-2.8235294117647061},0,null,"green line:","H'"]
[null,null,-1.0999999999999999,0.20894285260942747,null,{"$f":"-B13","v":0.35294117647058826},-1.5,null,null,null,null,"red dot:","F"]
[null,null,-1.2,0.25045458302649592,null,null,null,null,null,null,null,"blue dot","F'"]
[null,null,-1.3,0.29629883308084537,null,"Plane 2 (H')",null,null,"F'"]
[null,null,-1.3,{"$f":"-SIGN($B$5)*SQRT($B$5^2-C31^2)+$B$5+$B$6","v":0.70370116691915463},null,{"$f":"-B13+B15","v":0.64705882352941169},1.5,null,{"$f":"B6+B14+B18","v":3.8235294117647061},0]
[null,null,{"$f":"C31+0.1","v":-1.2},{"$f":"-SIGN($B$5)*SQRT($B$5^2-C32^2)+$B$5+$B$6","v":0.74954541697350408},null,{"$f":"-B13+B15","v":0.64705882352941169},-1.5]
[null,null,{"$f":"C32+0.1","v":-1.0999999999999999},0.79105714739057253]
[null,null,-0.99999999999999989,0.82842712474619029,null,"."]
[null,null,-0.89999999999999991,0.86181760425083676,null,null,"."]
[null,null,-0.79999999999999993,0.89136645896019218]
[null,null,-0.7,0.91719042916296445,null,"."]
[null,null,-0.6,0.93938769133981381]
[null,null,-0.5,0.95803989154980806]
[null,null,-0.4,0.97321374946370121]
[null,null,-0.30000000000000004,0.98496231131986001]
[null,null,-0.20000000000000004,0.99332590941915333]
[null,null,-0.10000000000000003,0.9983328701129901]
[null,null,0,1]
[null,null,0.1,0.9983328701129901]
[null,null,0.2,0.99332590941915333]
[null,null,0.30000000000000004,0.98496231131986001]
[null,null,0.4,0.97321374946370121]
[null,null,0.5,0.95803989154980806]
[null,null,0.6,0.93938769133981381]
[null,null,0.7,0.91719042916296445]
[null,null,0.79999999999999993,0.89136645896019218]
[null,null,0.89999999999999991,0.86181760425083676]
[null,null,0.99999999999999989,0.82842712474619029]
[null,null,1.0999999999999999,0.79105714739057253]
[null,null,1.2,0.74954541697350408]
[null,null,1.3,0.70370116691915463]
[null,null,1.3,{"$f":"-SIGN($B$4)*SQRT($B$4^2-C58^2)+$B$4","v":0.29629883308084537}]