{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Disclaimer","Input","Lens calcs","Distance Relay Calcs","LOF Calcs","Sheet1"],"not_rendered":{"charts":8,"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":"Disclaimer","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["DISCLAIMER"]
["This tool was developed by an observer participating with the Protection System Response to Power Swings Standard Drafting Team (PSRPS SDT) as a standard development aid for understanding how the PRC-026-1 - Attachment B criteria (i.e., lens) is applied under the draft PRC-026-1 standard. This tool is provided entirely for demonstration purposes, is not to be relied on for actual calculations, and is not intended to be used for compliance with any NERC Reliability Standard."]

{"sheet":"Input","index":1,"n_rows":31,"n_cols":13,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["NERC Project 2010-13.3 Relay Loadability - Stable Power Swings (PRC-026-1)"]
["Generator Stable Power Swing Calculation Tool Draft"]
[]
["Enter data in the yellow \"fill\" color only. "]
["   Generator data can be provided by manufacturer's stability data sheets."]
["   System Equivalent is provided by the Transmission Owner's Short Circuit Database"]
["Notes: 1. These calcaulations are only necessary when the Elements are reported by the Transmission Coordinator per Requirement R1 or a load responsive"]
["            relay has operated by a unstable or stable power swing per and is reported to the Transmsiion Coordinator per Requirement R2 or R3. "]
["              2. Applicable load responsive relays in this spreadsheet must also comply with other NERC Standards (PRC-001; PRC-019; PRC-025)."]
[" ","Generator Data",null,null,null,null,"Relay Data (at generator terminals)",null,null,null,null,"Upper"]
[null,"MVA Rating","Saturated Xd' (per unit)","Generator kV",null,null,"Location","Generator Terminals",null,null,null,"Ea",1.42]
[null,940,0.38450000000000001,20,null,null,"Impedance ","Ohms","Per unit",null,null,"Eb",1]
[null,null,null,null,null,null,"   Reach",10,{"$f":"H13/(H17)","v":0.65277777777777779}]
[null,"Generator Step-Up Transformer Data",null,null,null,null,"   MTA Angle",85,{"$f":"H14","v":85}]
[null,"MVA Rating","Impedance (per unit) GSU Base","Impedance (per unit) Generator Base",null,null,"PT Ratio",{"$f":"20000/120","v":166.66666666666666},null,null,null,"Lower"]
[null,880,0.1605,{"$f":"(B12/B16)*C16","v":0.1714431818181818},null,null,"CT Ratio",6000,null,null,null,"Eb",1]
[null,null,null,null,null,null,"Base ohms",{"$f":"((D12^2)/940)*(H16/H15)","v":15.319148936170214},null,null,null,"Ea",0.7]
[null,"System Equivalent (per unit) 100MVA Base","Angle","System Equivalent (per unit) Generator Base","High Voltage Rating",null,"40-2"]
[null,7.2300000000000003E-3,86.82,{"$f":"B19*(B12/100)","v":6.7962000000000009E-2},345,null,"40 Z2P (negative offset ohms)",3.4]
[null,null,null,null,null,null,"40Z2D (Diamete - ohms)",34.299999999999997]
[null,null,null,null,null,null,"40-3"]
[null,null,null,null,null,null,"40 Z3P (negative offset ohms)",3.4]
[null,null,null,null,null,null,"40Z3D (Diamete - ohms)",15.3]
[null,null,null,null,null,null,"40-1"]
[null,null,null,null,null,null,"40 Z1P (positive offset ohms)",4.5]
[null,null,null,null,null,null,"40Z1D (Diamete - ohmsr)",42.6]
[null,null,null,null,null,null,"Directional Element (degrees)",-20]
[]
[]
[]
[null,"Distance Relay Characteristic (21-1) Plotted with the Impedance Locus of a Stable Power Swing",null,null,null,null,null,null,"Loss of Field Relay Characteristic (21-1) Plotted with the Impedance Locus of a Stable Power Swing"]

{"sheet":"Lens calcs","index":2,"n_rows":140,"n_cols":24,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"1.42 Ea","1.0Ea","0.7Ea",null,"Calculation Worksheet for Stable Power Swing"]
["Total Impedance",null,"m","(1-m)*EA"]
[{"$f":"Input!C12+Input!D16+Input!D19","v":0.62390518181818178},null,{"$f":"Input!C12/'Lens calcs'!A3","v":0.61627954247709849},{"$f":"(1-C3)*Input!M11","v":0.5448830496825201},{"$f":"(1-C3)*Input!M16","v":0.38372045752290151},{"$f":"(1-C3)*Input!M17","v":0.26860432026603104},null,null,null,null,null,null,null,null,null,null,null,null,null,null,90]
[]
["EA = 1.42; EB = 1.00"]
[null,"Step 1",null,"Step 2","Step 3",null,null,null,"Step 4",null,null,null,null,null,null,"Step 5"]
["Angle","X","Y","X","X","Y","Mag","Angle","X","Y","Eb",null,null,null,null,"Magitude","Angle","R","jX","Mag","Angle","Zr (plot)","Zx (plot)","Angle"]
[0,{"$f":"D$3*(COS(RADIANS(A8)))","v":0.5448830496825201},{"$f":"D$3*(SIN(RADIANS(A8)))","v":0},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"B8+D8","v":1.1611625921596187},{"$f":"C8","v":0},{"$f":"((E8^2)+(F8^2))^0.5","v":1.1611625921596187},{"$f":"DEGREES(ATAN(F8/E8))","v":0},{"$f":"Input!M$11*(COS(RADIANS(A8)))","v":1.42},{"$f":"Input!M$11*(SIN(RADIANS(A8)))","v":0},{"$f":"Input!M$12","v":1},{"$f":"I8-K8","v":0.41999999999999993},{"$f":"J8","v":0},{"$f":"((L8^2)+(M8^2))^0.5","v":0.41999999999999993},{"$f":"DEGREES(ACOS(L8/N8))","v":0},{"$f":"'Lens calcs'!G8/'Lens calcs'!N8","v":2.764672838475283},{"$f":"H8-O8","v":0},{"$f":"P8*(COS(RADIANS(Q8)))","v":2.764672838475283},{"$f":"P8*(SIN(RADIANS(Q8)))","v":0},{"$f":"P8*A$3","v":1.7248937099567101},{"$f":"Q8+U$3","v":90},null,null,0]
[0.5,{"$f":"D$3*(COS(RADIANS(A9)))","v":0.54486230220560317},{"$f":"D$3*(SIN(RADIANS(A9)))","v":4.75494127551676E-3},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"B9+D9","v":1.1611418446827018},{"$f":"C9","v":4.75494127551676E-3},{"$f":"((E9^2)+(F9^2))^0.5","v":1.1611515805180996},{"$f":"DEGREES(ATAN(F9/E9))","v":0.23462813376368791},{"$f":"Input!M$11*(COS(RADIANS(A9)))","v":1.4199459307511233},{"$f":"Input!M$11*(SIN(RADIANS(A9)))","v":1.2391680407690987E-2},{"$f":"Input!M$12","v":1},{"$f":"I9-K9","v":0.4199459307511233},{"$f":"J9","v":1.2391680407690987E-2},{"$f":"((L9^2)+(M9^2))^0.5","v":0.42012871658308909},{"$f":"DEGREES(ACOS(L9/N9))","v":1.6901819462277525},{"$f":"'Lens calcs'!G9/'Lens calcs'!N9","v":2.7637996039922159},{"$f":"H9-O9","v":-1.4555538124640646},{"$f":"P9*(COS(RADIANS(Q9)))","v":2.7629078101585867},{"$f":"P9*(SIN(RADIANS(Q9)))","v":-7.0204583840466322E-2},{"$f":"P9*A$3","v":1.7243488944377823},{"$f":"Q9+U$3","v":88.544446187535939},{"$f":"T9*COS(RADIANS(U9))","v":4.3801003645456034E-2},{"$f":"T9*SIN(RADIANS(U9))","v":1.7237924996438674},0.5]
[2,0.5445511216509008,1.9016144195643781E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1608306641279993,1.9016144195643781E-2,1.160986410135761,0.93850670329698094,{"$f":"Input!M$11*(COS(RADIANS(A10)))","v":1.419134974367116},{"$f":"Input!M$11*(SIN(RADIANS(A10)))","v":4.9557285317551374E-2},{"$f":"Input!M$12","v":1},0.419134974367116,4.9557285317551374E-2,0.42205455958414684,6.7431773607571559,{"$f":"'Lens calcs'!G10/'Lens calcs'!N10","v":2.7507969852989826},-5.804670657460175,2.7366921845773726,-0.27820844919430388,1.716236493257868,84.195329342539821,{"$f":"T10*COS(RADIANS(U10))","v":0.17357569307792686},{"$f":"T10*SIN(RADIANS(U10))","v":1.7074364349991427},2]
[3,0.54413630640010835,2.8516975445706163E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1604158488772067,2.8516975445706163E-2,1.1607661953270259,1.4077483883379092,{"$f":"Input!M$11*(COS(RADIANS(A11)))","v":1.4180539393514948},{"$f":"Input!M$11*(SIN(RADIANS(A11)))","v":7.4317057864980246E-2},{"$f":"Input!M$12","v":1},0.41805393935149482,7.4317057864980246E-2,0.42460819739733019,10.080114068356458,{"$f":"'Lens calcs'!G11/'Lens calcs'!N11","v":2.7337347758287165},-8.6723656800185491,2.7024792382396692,-0.41220358011402736,1.7055912923561019,81.327634319981456,0.25717594959714751,1.6860908004937822,3]
[4,0.54355574195921974,3.8009120148797634E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1598352844363182,3.8009120148797634E-2,1.1604579183399806,1.8769760655303716,{"$f":"Input!M$11*(COS(RADIANS(A12)))","v":1.4165409513689502},{"$f":"Input!M$11*(SIN(RADIANS(A12)))","v":9.9054192716657927E-2},{"$f":"Input!M$12","v":1},0.4165409513689502,9.9054192716657927E-2,0.4281566270211159,13.376586522888196,{"$f":"'Lens calcs'!G12/'Lens calcs'!N12","v":2.7103584181653901},-11.499610457357825,2.6559508460665975,-0.5403405020893024,1.6910066616779174,78.500389542642182,0.33712123919975368,1.6570614955153344,4]
[5,0.54280960517378773,4.7489686905689166E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1590891476508862,4.7489686905689166E-2,1.1600616029179047,2.3461850523816543,{"$f":"Input!M$11*(COS(RADIANS(A13)))","v":1.4145964712902785},{"$f":"Input!M$11*(SIN(RADIANS(A13)))","v":0.12376115470167459},{"$f":"Input!M$12","v":1},0.41459647129027855,0.12376115470167459,0.43267430871204104,16.620885582314511,{"$f":"'Lens calcs'!G13/'Lens calcs'!N13","v":2.6811427892982751},-14.274700529932856,2.5983617055895474,-0.66109235628005336,1.6727788794376472,75.725299470067142,0.4124589467435168,1.6211313323552474,5]
[6,0.54189812332430487,5.6955787843906307E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1581776658014034,5.6955787843906307E-2,1.1595772795851544,2.8153706550544353,{"$f":"Input!M$11*(COS(RADIANS(A14)))","v":1.412221091422948},{"$f":"Input!M$11*(SIN(RADIANS(A14)))","v":0.14843041784006791},{"$f":"Input!M$12","v":1},0.41222109142294805,0.14843041784006791,0.43812990899287352,19.802669150292235,{"$f":"'Lens calcs'!G14/'Lens calcs'!N14","v":2.6466517253995909},-16.987298495237802,2.5311771098978197,-0.77324497663415293,1.6512597259448363,73.012701504762191,0.48243154773692726,1.5792145149648189,6]
[7,0.54082157405697262,6.6404539497403076E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1571011165340712,6.6404539497403076E-2,1.159004985645125,3.2845281655032714,{"$f":"Input!M$11*(COS(RADIANS(A15)))","v":1.4094155353306772},{"$f":"Input!M$11*(SIN(RADIANS(A15)))","v":0.17305446763530941},{"$f":"Input!M$12","v":1},0.4094155353306772,0.17305446763530941,0.44448726566533414,22.913130016336027,{"$f":"'Lens calcs'!G15/'Lens calcs'!N15","v":2.6075099899887113},-19.628601850832755,2.4559872694208078,-0.87591944854184711,1.6268389943966324,70.371398149167248,0.54649068280058277,1.532303183871129,7]
[8,0.53958028529912627,7.5833063684893717E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1558598277762249,7.5833063684893717E-2,1.1583447651777605,3.7536528585927584,{"$f":"Input!M$11*(COS(RADIANS(A16)))","v":1.4061806576130298},{"$f":"Input!M$11*(SIN(RADIANS(A16)))","v":0.19762580336329291},{"$f":"Input!M$12","v":1},0.40618065761302979,0.19762580336329291,0.45170641435996928,25.945078863394944,{"$f":"'Lens calcs'!G16/'Lens calcs'!N16","v":2.5643752852592088},-22.191426004802185,2.3744246127817332,-0.96857026686996961,1.5999270285996985,67.808573995197818,0.60429600845519305,1.4814158197511533,8]
[9,0.53817463515934627,8.5238488386574565E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1544541776364448,8.5238488386574565E-2,1.1575966690366157,4.2227399891936042,{"$f":"Input!M$11*(COS(RADIANS(A17)))","v":1.4025174436450956},{"$f":"Input!M$11*(SIN(RADIANS(A17)))","v":0.22213694035712783},{"$f":"Input!M$12","v":1},0.40251744364509556,0.22213694035712783,0.45974461683613965,28.892948947685401,{"$f":"'Lens calcs'!G17/'Lens calcs'!N17","v":2.5179123945005357},-24.670208958491799,2.2880907600984588,-1.0509631296727202,1.5709385902931101,65.329791041508201,0.65570134250266376,1.4275516816957305,9]
[10,0.53660505181228191,9.4617948618969078E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1528845942893804,9.4617948618969078E-2,1.1567607548454655,4.6917847892528197,{"$f":"Input!M$11*(COS(RADIANS(A18)))","v":1.3984270092773352},{"$f":"Input!M$11*(SIN(RADIANS(A18)))","v":0.24658041228704106},{"$f":"Input!M$12","v":1},0.39842700927733521,0.24658041228704106,0.46855734061620341,31.752734500851975,{"$f":"'Lens calcs'!G18/'Lens calcs'!N18","v":2.4687709583723527},-27.060949711599157,2.1984975108507991,-1.1231378987842882,1.5402789936507495,62.939050288400843,0.70073155494790196,1.3716539892341877,10]
[11,0.53487201336822576,0.10396858730762962,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1511515558453242,0.10396858730762962,1.155837086994467,5.1607824648341554,{"$f":"Input!M$11*(COS(RADIANS(A19)))","v":1.3939106004956827},{"$f":"Input!M$11*(SIN(RADIANS(A19)))","v":0.27094877343469359},{"$f":"Input!M$12","v":1},0.39391060049568272,0.27094877343469359,0.4780991518593547,34.521878021215386,{"$f":"'Lens calcs'!G19/'Lens calcs'!N19","v":2.4175677419617898},-29.36109555638123,2.1070237656341813,-1.1853626609721526,1.5083330416064415,60.63890444361877,0.73955390651431485,1.3145830455932235,11]
[12,0.53297604772747609,0.11328755615742993,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1492555902045747,0.11328755615742993,1.1548257366358736,5.6297281931248682,{"$f":"Input!M$11*(COS(RADIANS(A20)))","v":1.3889695930420041},{"$f":"Input!M$11*(SIN(RADIANS(A20)))","v":0.29523460096121823},{"$f":"Input!M$12","v":1},0.38896959304200407,0.29523460096121823,0.48832449653482674,37.199122459948278,{"$f":"'Lens calcs'!G20/'Lens calcs'!N20","v":2.3648736543641995},-31.569394266823409,2.0148882232214418,-1.2380843464923639,1.4754569273031239,58.430605733176591,0.77244723930456316,1.257099203252287,12]
[13,0.53091773241953366,0.12257201652018347,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1471972748966321,0.12257201652018347,1.1537267816793035,6.0986171194048087,{"$f":"Input!M$11*(COS(RADIANS(A21)))","v":1.383605491995034},{"$f":"Input!M$11*(SIN(RADIANS(A21)))","v":0.31943049716828831},{"$f":"Input!M$12","v":1},0.38360549199503402,0.31943049716828831,0.49918835724597183,39.784343345507423,{"$f":"'Lens calcs'!G21/'Lens calcs'!N21","v":2.3112053094435696},-33.685726226102616,1.9231361915604905,-1.2818803263606,1.4419729688075373,56.314273773897384,0.79977177808716038,1.1998546352566735,13]
[14,0.52869769442718073,0.1318191402593232,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1449772369042792,0.1318191402593232,1.1525403067865632,6.567444353973741,{"$f":"Input!M$11*(COS(RADIANS(A22)))","v":1.3778199313119148},{"$f":"Input!M$11*(SIN(RADIANS(A22)))","v":0.34352909175152818},{"$f":"Input!M$12","v":1},0.37781993131191483,0.34352909175152818,0.51064678337983282,42.278373740188783,{"$f":"'Lens calcs'!G22/'Lens calcs'!N22","v":2.2570205948585653},-35.710929386215042,1.8326379765640719,-1.3174141385573694,1.4081668446026139,54.289070613784958,0.82194150764647889,1.1433923299751121,14]
[15,0.52631660999549568,0.14102611061137921,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.1425961524725943,0.14102611061137921,1.1512664033660276,7.0362049690327124,{"$f":"Input!M$11*(COS(RADIANS(A23)))","v":1.371614673330477},{"$f":"Input!M$11*(SIN(RADIANS(A23)))","v":0.36752304404557945},{"$f":"Input!M$12","v":1},0.37161467333047704,0.36752304404557945,0.52265730009160505,44.682832185053208,{"$f":"'Lens calcs'!G23/'Lens calcs'!N23","v":2.2027175419997915},-37.646627216020498,1.7440959912345961,-1.3453972436395933,1.3742868885354784,52.353372783979502,0.83940031191064113,1.0881505265195828,15]
[30,0.47188256311660087,0.27244152484126,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.0881621055936994,0.27244152484126,1.1217491486548783,14.056113799277329,{"$f":"Input!M$11*(COS(RADIANS(A24)))","v":1.2297560733739028},{"$f":"Input!M$11*(SIN(RADIANS(A24)))","v":0.70999999999999985},{"$f":"Input!M$12","v":1},0.2297560733739028,0.70999999999999985,0.7462491897832747,72.068413766957363,{"$f":"'Lens calcs'!G24/'Lens calcs'!N24","v":1.5031830707657534},-58.012299967680036,0.79629198701872395,-1.2749425146439084,0.93784370707212017,31.987700032319964,0.79544324140663758,0.49681069694127811,30]
[45,0.38529049938411647,0.38529049938411641,{"$f":"C$3*Input!M$12","v":0.61627954247709849},1.001570041861215,0.38529049938411641,1.0731222286718032,21.041061742947782,{"$f":"Input!M$11*(COS(RADIANS(A25)))","v":1.0040916292848976},{"$f":"Input!M$11*(SIN(RADIANS(A25)))","v":1.0040916292848974},{"$f":"Input!M$12","v":1},4.091629284897591E-3,1.0040916292848974,1.004099965855096,89.766523507492408,{"$f":"'Lens calcs'!G25/'Lens calcs'!N25","v":1.0687404294032892},-68.725461764544633,0.38777874094229126,-0.99590850659804009,0.66679269192330082,21.274538235455367,0.62135247788332404,0.24193716587282588,45]
[60,0.27244152484126011,0.47188256311660082,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.88872106731835854,0.47188256311660082,1.0062297396067039,27.966877665248287,{"$f":"Input!M$11*(COS(RADIANS(A26)))","v":0.71000000000000008},{"$f":"Input!M$11*(SIN(RADIANS(A26)))","v":1.2297560733739028},{"$f":"Input!M$12","v":1},-0.28999999999999992,1.2297560733739028,1.2634872377669668,103.26901922590785,{"$f":"'Lens calcs'!G26/'Lens calcs'!N26","v":0.79639090093626208},-75.302141560659564,0.2020617253755701,-0.77033079013649641,0.49687240984698416,14.697858439340436,0.48061337168025442,0.1260673575089406,60]
[75,0.14102611061137921,0.52631660999549568,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.75730565308847764,0.52631660999549568,0.92223696854816894,34.798748573533885,{"$f":"Input!M$11*(COS(RADIANS(A27)))","v":0.36752304404557945},{"$f":"Input!M$11*(SIN(RADIANS(A27)))","v":1.371614673330477},{"$f":"Input!M$12","v":1},-0.63247695595442055,1.371614673330477,1.5104151455506665,114.75530280371842,{"$f":"'Lens calcs'!G27/'Lens calcs'!N27","v":0.61058509063873312},-79.956554230184537,0.10648291333791451,-0.60122836100551691,0.38094720199042981,10.043445769815463,0.37510948988739445,6.6435241406621257E-2,75]
[90,3.3378131321221817E-17,0.5448830496825201,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.61627954247709849,0.5448830496825201,0.82261656457131083,41.481479687423104,{"$f":"Input!M$11*(COS(RADIANS(A28)))","v":8.6985540298512016E-17},{"$f":"Input!M$11*(SIN(RADIANS(A28)))","v":1.42},{"$f":"Input!M$12","v":1},-0.99999999999999989,1.42,1.7367786272291583,125.15417763214741,{"$f":"'Lens calcs'!G28/'Lens calcs'!N28","v":0.47364502975471678},-83.672697944724305,5.2199439090333109E-2,-0.47075984617424749,0.29550958840639469,6.3273020552756947,0.29370950742004315,3.2567500536461368E-2,90]
[105,-0.14102611061137929,0.52631660999549568,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.47525343186571922,0.52631660999549568,0.7091367981266341,47.918591322562683,{"$f":"Input!M$11*(COS(RADIANS(A29)))","v":-0.36752304404557962},{"$f":"Input!M$11*(SIN(RADIANS(A29)))","v":1.371614673330477},{"$f":"Input!M$12","v":1},-1.3675230440455797,1.371614673330477,1.9368650154543965,134.91441360779211,{"$f":"'Lens calcs'!G29/'Lens calcs'!N29","v":0.36612608130580937},-86.995822285229423,1.918821797220259E-2,-0.36562292010129693,0.22842795932547941,3.0041777147705773,0.22811403444269424,1.1971628622713951E-2,105]
[120,-0.27244152484125994,0.47188256311660087,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34383801763583854,0.47188256311660087,0.5838644840587891,53.920985263721597,{"$f":"Input!M$11*(COS(RADIANS(A30)))","v":-0.70999999999999963},{"$f":"Input!M$11*(SIN(RADIANS(A30)))","v":1.2297560733739028},{"$f":"Input!M$12","v":1},-1.7099999999999995,1.2297560733739028,2.1062763351469336,144.27798841642954,{"$f":"'Lens calcs'!G30/'Lens calcs'!N30","v":0.27720222380889958},-90.357003152707932,-1.7272027421782958E-3,-0.27719684279458645,0.17294790384589581,-0.35700315270793226,0.1729445466031824,-1.077610740895626E-3,120]
[135,-0.38529049938411641,0.38529049938411647,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.23098904309298207,0.38529049938411647,0.44922678787520387,59.056504477610943,{"$f":"Input!M$11*(COS(RADIANS(A31)))","v":-1.0040916292848974},{"$f":"Input!M$11*(SIN(RADIANS(A31)))","v":1.0040916292848976},{"$f":"Input!M$12","v":1},-2.0040916292848974,1.0040916292848976,2.2415582210975011,153.38817703914557,{"$f":"'Lens calcs'!G31/'Lens calcs'!N31","v":0.20040826227357841},-94.331672561534631,-1.5136825987481678E-2,-0.19983580281456095,0.12503575331166281,-4.3316725615346314,0.12467859288880098,-9.4439441698699403E-3,135]
[150,-0.47188256311660087,0.27244152484126,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.14439697936049761,0.27244152484126,0.30834213482147854,62.075922460768233,{"$f":"Input!M$11*(COS(RADIANS(A32)))","v":-1.2297560733739028},{"$f":"Input!M$11*(SIN(RADIANS(A32)))","v":0.70999999999999985},{"$f":"Input!M$12","v":1},-2.2297560733739026,0.70999999999999985,2.3400666970725008,162.33745941547733,{"$f":"'Lens calcs'!G32/'Lens calcs'!N32","v":0.13176638734580709},-100.2615369547091,-2.3473086423594334E-2,-0.12965876386853201,8.2209731854510734E-2,-10.261536954709101,8.0894774645717163E-2,-1.4644980252946522E-2,150]
[165,-0.52631660999549568,0.14102611061137937,{"$f":"C$3*Input!M$12","v":0.61627954247709849},8.9962932481602809E-2,0.14102611061137937,0.16727729402062444,57.465510416419164,{"$f":"Input!M$11*(COS(RADIANS(A33)))","v":-1.3716146733304768},{"$f":"Input!M$11*(SIN(RADIANS(A33)))","v":0.36752304404557984},{"$f":"Input!M$12","v":1},-2.3716146733304768,0.36752304404557984,2.3999227793120665,171.19108905408135,{"$f":"'Lens calcs'!G33/'Lens calcs'!N33","v":6.9701115161952903E-2},-113.72557863766218,-2.8044697938947732E-2,-6.3810190191951333E-2,4.3486886928048252E-2,-23.725578637662181,3.9811508313562151E-2,-1.7497232366635168E-2,165]
[180,-0.5448830496825201,6.6756262642443634E-17,{"$f":"C$3*Input!M$12","v":0.61627954247709849},7.1396492794578381E-2,6.6756262642443634E-17,7.1396492794578381E-2,5.3571988703754812E-14,{"$f":"Input!M$11*(COS(RADIANS(A34)))","v":-1.42},{"$f":"Input!M$11*(SIN(RADIANS(A34)))","v":1.7397108059702403E-16},{"$f":"Input!M$12","v":1},-2.42,1.7397108059702403E-16,2.42,180,{"$f":"'Lens calcs'!G34/'Lens calcs'!N34","v":2.9502682972966272E-2},-179.99999999999994,-2.9502682972966272E-2,-2.9818162985841825E-17,1.8406876784372698E-2,-89.999999999999943,1.7476148566562445E-17,-1.8406876784372698E-2,180]
[195,-0.52631660999549568,-0.14102611061137926,{"$f":"C$3*Input!M$12","v":0.61627954247709849},8.9962932481602809E-2,-0.14102611061137926,0.16727729402062436,-57.465510416419157,{"$f":"Input!M$11*(COS(RADIANS(A35)))","v":-1.371614673330477},{"$f":"Input!M$11*(SIN(RADIANS(A35)))","v":-0.36752304404557951},{"$f":"Input!M$12","v":1},-2.3716146733304768,-0.36752304404557951,2.3999227793120661,{"$f":"-DEGREES(ACOS(L35/N35))","v":-171.19108905408143},{"$f":"'Lens calcs'!G35/'Lens calcs'!N35","v":6.970111516195289E-2},113.72557863766227,-2.8044697938947812E-2,6.3810190191951277E-2,4.3486886928048245E-2,203.72557863766227,-3.9811508313562123E-2,-1.7497232366635227E-2,195]
[210,-0.47188256311660082,-0.27244152484126011,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.14439697936049767,-0.27244152484126011,0.30834213482147865,-62.075922460768233,{"$f":"Input!M$11*(COS(RADIANS(A36)))","v":-1.2297560733739028},{"$f":"Input!M$11*(SIN(RADIANS(A36)))","v":-0.71000000000000008},{"$f":"Input!M$12","v":1},-2.2297560733739026,-0.71000000000000008,2.3400666970725008,{"$f":"-DEGREES(ACOS(L36/N36))","v":-162.33745941547733},{"$f":"'Lens calcs'!G36/'Lens calcs'!N36","v":0.13176638734580712},100.2615369547091,-2.3473086423594337E-2,0.12965876386853203,8.2209731854510762E-2,190.2615369547091,-8.0894774645717191E-2,-1.4644980252946513E-2,210]
[225,-0.38529049938411652,-0.38529049938411641,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.23098904309298196,-0.38529049938411641,0.4492267878752037,-59.056504477610957,{"$f":"Input!M$11*(COS(RADIANS(A37)))","v":-1.0040916292848976},{"$f":"Input!M$11*(SIN(RADIANS(A37)))","v":-1.0040916292848974},{"$f":"Input!M$12","v":1},-2.0040916292848978,-1.0040916292848974,2.2415582210975016,-153.38817703914557,{"$f":"'Lens calcs'!G37/'Lens calcs'!N37","v":0.2004082622735783},94.331672561534617,-1.5136825987481624E-2,0.19983580281456084,0.12503575331166272,184.33167256153462,-0.1246785928888009,-9.4439441698698934E-3,225]
[240,-0.27244152484126027,-0.47188256311660065,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34383801763583821,-0.47188256311660065,0.58386448405878877,-53.920985263721604,{"$f":"Input!M$11*(COS(RADIANS(A38)))","v":-0.71000000000000063},{"$f":"Input!M$11*(SIN(RADIANS(A38)))","v":-1.2297560733739024},{"$f":"Input!M$12","v":1},-1.7100000000000006,-1.2297560733739024,2.1062763351469345,-144.27798841642954,{"$f":"'Lens calcs'!G38/'Lens calcs'!N38","v":0.27720222380889931},90.357003152707932,-1.727202742178294E-3,0.27719684279458617,0.17294790384589565,180.35700315270793,-0.17294454660318223,-1.0776107408956002E-3,240]
[250,-0.18636097874814289,-0.5120225809779857,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.42991856372895559,-0.5120225809779857,0.66857841340423629,-49.981578734185248,{"$f":"Input!M$11*(COS(RADIANS(A39)))","v":-0.48566860352244934},{"$f":"Input!M$11*(SIN(RADIANS(A39)))","v":-1.3343635215159899},{"$f":"Input!M$12","v":1},-1.4856686035224493,-1.3343635215159899,1.9969319485262633,-138.07118426465465,{"$f":"'Lens calcs'!G39/'Lens calcs'!N39","v":0.33480280281841723},88.089605530469399,1.1161152236232466E-2,0.33461671425054013,0.20888520356566145,178.08960553046938,-0.20876910194388579,6.9635007152471281E-3,250]
[260,-9.4617948618969078E-2,-0.53660505181228191,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.52166159385812938,-0.53660505181228191,0.74838212173799668,-45.80900232051421,{"$f":"Input!M$11*(COS(RADIANS(A40)))","v":-0.24658041228704106},{"$f":"Input!M$11*(SIN(RADIANS(A40)))","v":-1.3984270092773352},{"$f":"Input!M$12","v":1},-1.246580412287041,-1.3984270092773352,1.873382188602764,-131.71432676536284,{"$f":"'Lens calcs'!G40/'Lens calcs'!N40","v":0.39948181758692125},85.905324444848631,2.8524900415460477E-2,0.3984621094142306,0.24923877603462583,175.90532444484865,-0.24860257482174178,1.7796833180053356E-2,260]
[270,{"$f":"D$3*(COS(RADIANS(A41)))","v":-1.0013439396366545E-16},{"$f":"D$3*(SIN(RADIANS(A41)))","v":-0.5448830496825201},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"B41+D41","v":0.61627954247709837},{"$f":"C41","v":-0.5448830496825201},{"$f":"((E41^2)+(F41^2))^0.5","v":0.82261656457131072},{"$f":"DEGREES(ATAN(F41/E41))","v":-41.481479687423104},{"$f":"Input!M$11*(COS(RADIANS(A41)))","v":-2.6095662089553607E-16},{"$f":"Input!M$11*(SIN(RADIANS(A41)))","v":-1.42},{"$f":"Input!M$12","v":1},{"$f":"I41-K41","v":-1.0000000000000002},{"$f":"J41","v":-1.42},{"$f":"((L41^2)+(M41^2))^0.5","v":1.7367786272291585},{"$f":"-DEGREES(ACOS(L41/N41))","v":-125.15417763214744},{"$f":"'Lens calcs'!G41/'Lens calcs'!N41","v":0.47364502975471662},{"$f":"H41-O41","v":83.672697944724334},{"$f":"P41*(COS(RADIANS(Q41)))","v":5.219943909033288E-2},{"$f":"P41*(SIN(RADIANS(Q41)))","v":0.47075984617424732},{"$f":"P41*A$3","v":0.29550958840639457},173.67269794472435,{"$f":"T41*COS(RADIANS(U41))","v":-0.29370950742004304},{"$f":"T41*SIN(RADIANS(U41))","v":3.2567500536461187E-2},270]
[]
["1.0 calculation"]
[null,"Step 1",null,"Step 2","Step 3",null,null,null,"Step 4",null,null,null,null,null,null,"Step 5"]
["Angle","X","Y","X","X","Y","Mag","Angle","X","Y","Eb",null,null,null,null,"Magitude","Angle","R","jX","Mag","Angle","Zr (plot)","Zx (plot)","Angle"]
[0,{"$f":"E$3*(COS(RADIANS(A46)))","v":0.38372045752290151},{"$f":"E$3*(SIN(RADIANS(A46)))","v":0},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"B46+D46","v":1},{"$f":"C46","v":0},{"$f":"((E46^2)+(F46^2))^0.5","v":1},{"$f":"DEGREES(ATAN(F46/E46))","v":0},{"$f":"Input!M$16*(COS(RADIANS(A46)))","v":1},{"$f":"Input!M$16*(SIN(RADIANS(A46)))","v":0},{"$f":"Input!M$12","v":1},{"$f":"I46-K46","v":0},{"$f":"J46","v":0},{"$f":"((L46^2)+(M46^2))^0.5","v":0},null,null,null,null,null,null,null,null,null,0]
[1,{"$f":"E$3*(COS(RADIANS(A47)))","v":0.38366201503862901},{"$f":"E$3*(SIN(RADIANS(A47)))","v":6.6968453829900606E-3},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"B47+D47","v":0.99994155751572755},{"$f":"C47","v":6.6968453829900606E-3},{"$f":"((E47^2)+(F47^2))^0.5","v":0.99996398244389917},{"$f":"DEGREES(ATAN(F47/E47))","v":0.38371766535419016},{"$f":"Input!M$16*(COS(RADIANS(A47)))","v":0.99984769515639127},{"$f":"Input!M$16*(SIN(RADIANS(A47)))","v":1.7452406437283512E-2},{"$f":"Input!M$12","v":1},{"$f":"I47-K47","v":-1.5230484360873042E-4},{"$f":"J47","v":1.7452406437283512E-2},{"$f":"((L47^2)+(M47^2))^0.5","v":1.7453070996747869E-2},{"$f":"DEGREES(ACOS(L47/N47))","v":90.499999999999901},{"$f":"'Lens calcs'!G47/'Lens calcs'!N47","v":57.294443059919267},{"$f":"H47-O47","v":-90.116282334645717},{"$f":"P47*(COS(RADIANS(Q47)))","v":-0.11627954247700838},{"$f":"P47*(SIN(RADIANS(Q47)))","v":-57.294325064654814},{"$f":"P47*A$3","v":35.746299914470391},{"$f":"Q47+U$3","v":-0.11628233464571736},{"$f":"T47*COS(RADIANS(U47))","v":35.746226296613472},{"$f":"T47*SIN(RADIANS(U47))","v":-7.2547409090851417E-2},1]
[2,0.38348670538795837,1.3391650842002665E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99976624786505686,1.3391650842002665E-2,0.99985593296356867,0.76741857582020589,{"$f":"Input!M$16*(COS(RADIANS(A48)))","v":0.99939082701909576},{"$f":"Input!M$16*(SIN(RADIANS(A48)))","v":3.4899496702500969E-2},{"$f":"Input!M$12","v":1},-6.0917298090423788E-4,3.4899496702500969E-2,3.4904812874567023E-2,90.999999999999943,{"$f":"'Lens calcs'!G48/'Lens calcs'!N48","v":28.645216823153401},-90.232581424179742,-0.11627954247706919,-28.644980815379714,17.871899210270762,-0.2325814241797417,{"$f":"T48*COS(RADIANS(U48))","v":17.871751963797809},{"$f":"T48*SIN(RADIANS(U48))","v":-7.2547409090892773E-2},2]
[3,0.38319458197190737,2.0082377074440962E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99947412444900585,2.0082377074440962E-2,0.99967586112302764,1.1510859671280278,{"$f":"Input!M$16*(COS(RADIANS(A49)))","v":0.99862953475457383},{"$f":"Input!M$16*(SIN(RADIANS(A49)))","v":5.2335956242943835E-2},{"$f":"Input!M$12","v":1},-1.3704652454261668E-3,5.2335956242943835E-2,5.2353896615746312E-2,91.500000000000043,{"$f":"'Lens calcs'!G49/'Lens calcs'!N49","v":19.094583703295132},-90.348914032872017,-0.11627954247711382,-19.094229648512801,11.91320971714684,-0.34891403287201683,11.912988820533498,-7.2547409090918349E-2,3]
[4,0.38278573377409847,2.6766986020280027E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.9990652762511969,2.6766986020280027E-2,0.99942378286265043,1.5347030562331434,{"$f":"Input!M$16*(COS(RADIANS(A50)))","v":0.9975640502598242},{"$f":"Input!M$16*(SIN(RADIANS(A50)))","v":6.9756473744125302E-2},{"$f":"Input!M$12","v":1},-2.4359497401758023E-3,6.9756473744125302E-2,6.9798993405001938E-2,92.000000000000043,{"$f":"'Lens calcs'!G50/'Lens calcs'!N50","v":14.31859879502259},-90.465296943766901,-0.11627954247710925,-14.318126641457802,8.9334479845901669,-0.46529694376690145,8.9331534055344815,-7.2547409090916129E-2,4]
[5,0.38226028533365336,3.3443441482879699E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99853982781075179,3.3443441482879699E-2,0.99909972049968299,1.9182530319022781,{"$f":"Input!M$16*(COS(RADIANS(A51)))","v":0.99619469809174555},{"$f":"Input!M$16*(SIN(RADIANS(A51)))","v":8.7155742747658166E-2},{"$f":"Input!M$12","v":1},-3.8053019082544548E-3,8.7155742747658166E-2,8.7238774730671986E-2,92.5,{"$f":"'Lens calcs'!G51/'Lens calcs'!N51","v":11.452473095640727},-90.581746968097718,-0.11627954247709646,-11.451882774215601,7.1452573090035632,-0.58174696809771831,7.1448890044074886,-7.2547409090908704E-2,5]
[6,0.381618396707257,4.0109709749229797E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99789793918435543,4.0109709749229797E-2,0.99870370272896802,2.3017190452666338,{"$f":"Input!M$16*(COS(RADIANS(A52)))","v":0.99452189536827329},{"$f":"Input!M$16*(SIN(RADIANS(A52)))","v":0.10452846326765347},{"$f":"Input!M$12","v":1},-5.4781046317267101E-3,0.10452846326765347,0.10467191248588767,93.000000000000028,{"$f":"'Lens calcs'!G52/'Lens calcs'!N52","v":9.5412769195711196},-90.698280954733391,-0.11627954247710275,-9.5405683438641056,5.9528521112826409,-0.69828095473339147,5.9524100272273239,-7.2547409090911716E-2,6]
[7,0.38086026342040324,4.6763760209438787E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99713980589750173,4.6763760209438787E-2,0.99823576462388552,2.6850842003317146,{"$f":"Input!M$16*(COS(RADIANS(A53)))","v":0.99254615164132198},{"$f":"Input!M$16*(SIN(RADIANS(A53)))","v":0.12186934340514748},{"$f":"Input!M$12","v":1},-7.4538483586780169E-3,0.12186934340514748,0.12209707906971373,93.500000000000028,{"$f":"'Lens calcs'!G53/'Lens calcs'!N53","v":8.175754671853559},-90.814915799668313,-0.11627954247710144,-8.1749277380498366,5.1008957050436434,-0.81491579966831296,5.10037977675848,-7.2547409090911591E-2,7]
[8,0.37998611640783547,5.3403565975277276E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.9962656588849339,5.3403565975277276E-2,0.99769594763750902,3.0683315444327373,{"$f":"Input!M$16*(COS(RADIANS(A54)))","v":0.99026806874157036},{"$f":"Input!M$16*(SIN(RADIANS(A54)))","v":0.13917310096006544},{"$f":"Input!M$12","v":1},-9.731931258429638E-3,0.13917310096006544,0.13951294748825058,93.999999999999986,{"$f":"'Lens calcs'!G54/'Lens calcs'!N54","v":7.1512785415241291},-90.931668455567248,-0.11627954247709572,-7.1503331283559648,4.4617197386820733,-0.93166845556724809,4.4611298905074968,-7.2547409090907969E-2,8]
[9,0.37899622194320165,6.0027104497587733E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99527576442030008,6.0027104497587733E-2,0.99708429960398881,3.4514440586244963,{"$f":"Input!M$16*(COS(RADIANS(A55)))","v":0.98768834059513777},{"$f":"Input!M$16*(SIN(RADIANS(A55)))","v":0.15643446504023087},{"$f":"Input!M$12","v":1},-1.231165940486223E-2,0.15643446504023087,0.15691819145568989,94.499999999999986,{"$f":"'Lens calcs'!G55/'Lens calcs'!N55","v":6.3541663994103743},-91.048555941375483,-0.11627954247709571,-6.3531023680873515,3.9643973427271111,-1.0485559413754828,3.9637334880710604,-7.2547409090907622E-2,9]
[10,0.37789088155794504,6.6632358182372592E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99417042403504352,6.6632358182372592E-2,0.99640087474016314,3.8344046479944653,{"$f":"Input!M$16*(COS(RADIANS(A56)))","v":0.98480775301220802},{"$f":"Input!M$16*(SIN(RADIANS(A56)))","v":0.17364817766693033},{"$f":"Input!M$12","v":1},-1.519224698779198E-2,0.17364817766693033,0.17431148549531633,95,{"$f":"'Lens calcs'!G56/'Lens calcs'!N56","v":5.7162089572516201},-91.165595352005539,-0.11627954247709854,-5.7150261513806715,3.5663723887847913,-1.1655953520055391,3.5656344300728215,-7.2547409090909398E-2,10]
[11,0.37667043194945482,7.3217315005372971E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99294997442655331,7.3217315005372971E-2,0.99564573364740983,4.2171961318877438,{"$f":"Input!M$16*(COS(RADIANS(A57)))","v":0.98162718344766398},{"$f":"Input!M$16*(SIN(RADIANS(A57)))","v":0.1908089953765448},{"$f":"Input!M$12","v":1},-1.8372816552336024E-2,0.1908089953765448,0.19169150504044796,95.499999999999986,{"$f":"'Lens calcs'!G57/'Lens calcs'!N57","v":5.1940002945739465},-91.282803868112239,-0.11627954247709736,-5.192698540069081,3.240563698149848,-1.2828038681122393,3.2397515267688073,-7.2547409090908191E-2,11]
[12,0.37533524487850434,7.9779969124950653E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99161478735560282,7.9779969124950653E-2,0.99481894331374465,4.5998012340322845,{"$f":"Input!M$16*(COS(RADIANS(A58)))","v":0.97814760073380569},{"$f":"Input!M$16*(SIN(RADIANS(A58)))","v":0.20791169081775934},{"$f":"Input!M$12","v":1},-2.1852399266194311E-2,0.20791169081775934,0.20905692653530694,95.999999999999986,{"$f":"'Lens calcs'!G58/'Lens calcs'!N58","v":4.7586031221296698},-91.400198765967701,-0.11627954247709693,-4.7571822271112927,2.9689171461128789,-1.4001987659677013,2.9680306423480936,-7.2547409090908385E-2,12]
[13,0.37388572705600964,8.6318321493086964E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.99016526953310813,8.6318321493086964E-2,0.99392057711617809,4.982202572552672,{"$f":"Input!M$16*(COS(RADIANS(A59)))","v":0.97437006478523525},{"$f":"Input!M$16*(SIN(RADIANS(A59)))","v":0.224951054343865},{"$f":"Input!M$12","v":1},-2.5629935214764754E-2,0.224951054343865,0.22640642753581347,96.499999999999986,{"$f":"'Lens calcs'!G59/'Lens calcs'!N59","v":4.3899839237512701},-91.51779742744732,-0.11627954247709787,-4.3884436784349772,2.7389337181269311,-1.51779742744732,2.7379727510928249,-7.2547409090908704E-2,13]
[14,0.3723223200191414,9.2830380464312121E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.98860186249623982,9.2830380464312121E-2,0.99295071482334074,5.3643826498604819,{"$f":"Input!M$16*(COS(RADIANS(A60)))","v":0.97029572627599647},{"$f":"Input!M$16*(SIN(RADIANS(A60)))","v":0.24192189559966773},{"$f":"Input!M$12","v":1},-2.9704273724003527E-2,0.24192189559966773,0.24373868681029498,97,{"$f":"'Lens calcs'!G60/'Lens calcs'!N60","v":4.0738330374125935},-91.635617350139512,-0.11627954247709785,-4.0721732139872975,2.5416855419038198,-1.6356173501395119,2.5406499694678741,-7.2547409090908788E-2,14]
[15,0.370645499996828,9.9314162402379738E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.98692504247392643,9.9314162402379738E-2,0.99190944259838953,5.7463238424090175,{"$f":"Input!M$16*(COS(RADIANS(A61)))","v":0.96592582628906831},{"$f":"Input!M$16*(SIN(RADIANS(A61)))","v":0.25881904510252074},{"$f":"Input!M$12","v":1},-3.4074173710931688E-2,0.25881904510252074,0.26105238444010315,97.499999999999986,{"$f":"'Lens calcs'!G61/'Lens calcs'!N61","v":3.7996567038673303},-91.753676157590974,-0.11627954247709776,-3.7978770563625757,2.37062550667302,-1.7536761575909736,2.3695151753729937,-7.254740909090876E-2,15]
[30,0.33231166416662034,0.19186022876145073,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.94859120664371877,0.19186022876145073,0.96779937213359601,11.434280211061868,{"$f":"Input!M$16*(COS(RADIANS(A62)))","v":0.86602540378443871},{"$f":"Input!M$16*(SIN(RADIANS(A62)))","v":0.49999999999999994},{"$f":"Input!M$12","v":1},-0.13397459621556129,0.49999999999999994,0.51763809020504148,105,{"$f":"'Lens calcs'!G62/'Lens calcs'!N62","v":1.8696448164203705},-93.565719788938139,-0.11627954247709867,-1.8660254037844388,1.1664810891241724,-3.5657197889381393,1.1642229188254762,-7.2547409090909273E-2,30]
[45,0.27133133759444822,0.27133133759444822,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.88761088007154676,0.27133133759444822,0.92815611250596108,16.997724755312564,{"$f":"Input!M$16*(COS(RADIANS(A63)))","v":0.70710678118654757},{"$f":"Input!M$16*(SIN(RADIANS(A63)))","v":0.70710678118654746},{"$f":"Input!M$12","v":1},-0.29289321881345243,0.70710678118654746,0.76536686473017945,112.5,{"$f":"'Lens calcs'!G63/'Lens calcs'!N63","v":1.2126944022239203},-95.502275244687439,-0.11627954247709849,-1.2071067811865477,0.75660632150940632,-5.5022752446874392,0.75312017579015333,-7.2547409090909162E-2,45]
[60,0.19186022876145081,0.33231166416662028,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.8081397712385493,0.33231166416662028,0.87379684824258974,22.352743215948532,{"$f":"Input!M$16*(COS(RADIANS(A64)))","v":0.50000000000000011},{"$f":"Input!M$16*(SIN(RADIANS(A64)))","v":0.8660254037844386},{"$f":"Input!M$12","v":1},-0.49999999999999989,0.8660254037844386,0.99999999999999989,119.99999999999999,{"$f":"'Lens calcs'!G64/'Lens calcs'!N64","v":0.87379684824258985},-97.64725678405145,-0.11627954247709836,-0.86602540378443882,0.54516638147494723,-7.64725678405145,0.54031773700729457,-7.2547409090908996E-2,60]
[75,9.9314162402379738E-2,0.370645499996828,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.71559370487947827,0.370645499996828,0.80588611920732112,27.38213401269617,{"$f":"Input!M$16*(COS(RADIANS(A65)))","v":0.25881904510252074},{"$f":"Input!M$16*(SIN(RADIANS(A65)))","v":0.96592582628906831},{"$f":"Input!M$12","v":1},-0.74118095489747926,0.96592582628906831,1.2175228580174413,127.50000000000001,{"$f":"'Lens calcs'!G65/'Lens calcs'!N65","v":0.66190635674765841},-100.11786598730384,-0.11627954247709853,-0.65161268642060299,0.41296680585325812,-10.117865987303844,0.40654453159628018,-7.2547409090909204E-2,75]
[90,2.3505726282550578E-17,0.38372045752290151,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.61627954247709849,0.38372045752290151,0.72597648997565112,31.908055546426304,{"$f":"Input!M$16*(COS(RADIANS(A66)))","v":6.1257422745431001E-17},{"$f":"Input!M$16*(SIN(RADIANS(A66)))","v":1},{"$f":"Input!M$12","v":1},-0.99999999999999989,1,1.4142135623730949,135,{"$f":"'Lens calcs'!G66/'Lens calcs'!N66","v":0.5133428990437906},-103.09194445357369,-0.11627954247709839,-0.5,0.32027729476298872,-13.091944453573689,0.31195259090909094,-7.2547409090909079E-2,90]
[105,-9.931416240237978E-2,0.370645499996828,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.51696538007471871,0.370645499996828,0.63610635184982789,35.63915598629265,{"$f":"Input!M$16*(COS(RADIANS(A67)))","v":-0.25881904510252085},{"$f":"Input!M$16*(SIN(RADIANS(A67)))","v":0.96592582628906831},{"$f":"Input!M$12","v":1},-1.2588190451025207,0.96592582628906831,1.5867066805824703,142.5,{"$f":"'Lens calcs'!G67/'Lens calcs'!N67","v":0.4008972544417076},-106.86084401370735,-0.1162795424770984,-0.38366349398948019,0.25012187442286343,-16.86084401370735,0.23936964197450553,-7.2547409090909065E-2,105]
[120,-0.19186022876145067,0.33231166416662034,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.42441931371564778,0.33231166416662034,0.53903877040158255,38.06021939806665,{"$f":"Input!M$16*(COS(RADIANS(A68)))","v":-0.49999999999999978},{"$f":"Input!M$16*(SIN(RADIANS(A68)))","v":0.86602540378443871},{"$f":"Input!M$12","v":1},-1.4999999999999998,0.86602540378443871,1.732050807568877,150.00000000000003,{"$f":"'Lens calcs'!G68/'Lens calcs'!N68","v":0.31121417919499861},-111.93978060193338,-0.11627954247709867,-0.28867513459481287,0.19416813905505181,-21.939780601933379,0.18010591233576481,-7.2547409090909232E-2,120]
[135,-0.27133133759444822,0.27133133759444822,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34494820488265027,0.27133133759444822,0.43887351117668894,38.188085325174846,{"$f":"Input!M$16*(COS(RADIANS(A69)))","v":-0.70710678118654746},{"$f":"Input!M$16*(SIN(RADIANS(A69)))","v":0.70710678118654757},{"$f":"Input!M$12","v":1},-1.7071067811865475,0.70710678118654757,1.8477590650225735,157.5,{"$f":"'Lens calcs'!G69/'Lens calcs'!N69","v":0.23751663270629245},-119.31191467482515,-0.11627954247709846,-0.20710678118654757,0.1481878579134617,-29.311914674825147,0.12921499397197136,-7.2547409090909107E-2,135]
[150,-0.33231166416662034,0.19186022876145073,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.28396787831047815,0.19186022876145073,0.34270702253171109,34.044557712758241,{"$f":"Input!M$16*(COS(RADIANS(A70)))","v":-0.86602540378443871},{"$f":"Input!M$16*(SIN(RADIANS(A70)))","v":0.49999999999999994},{"$f":"Input!M$12","v":1},-1.8660254037844388,0.49999999999999994,1.9318516525781368,164.99999999999997,{"$f":"'Lens calcs'!G70/'Lens calcs'!N70","v":0.17739820864317105},-130.95544228724174,-0.11627954247709839,-0.1339745962155614,0.11067966161773737,-40.955442287241738,8.3587444810887299E-2,-7.2547409090909065E-2,150]
[165,-0.37064549999682794,9.9314162402379849E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.24563404248027054,9.9314162402379849E-2,0.2649516666844835,22.014349486767269,{"$f":"Input!M$16*(COS(RADIANS(A71)))","v":-0.9659258262890682},{"$f":"Input!M$16*(SIN(RADIANS(A71)))","v":0.25881904510252102},{"$f":"Input!M$12","v":1},-1.9659258262890682,0.25881904510252102,1.9828897227476208,172.50000000000003,{"$f":"'Lens calcs'!G71/'Lens calcs'!N71","v":0.13361896208597485},-150.48565051323277,-0.11627954247709857,-6.5826248793697903E-2,8.3365562834606874E-2,-60.48565051323277,4.1069337722040973E-2,-7.2547409090909162E-2,165]
[180,-0.38372045752290151,4.7011452565101155E-17,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.23255908495419697,4.7011452565101155E-17,0.23255908495419697,1.1582251543904494E-14,{"$f":"Input!M$16*(COS(RADIANS(A72)))","v":-1},{"$f":"Input!M$16*(SIN(RADIANS(A72)))","v":1.22514845490862E-16},{"$f":"Input!M$12","v":1},-2,1.22514845490862E-16,2,180,{"$f":"'Lens calcs'!G72/'Lens calcs'!N72","v":0.11627954247709849},-180,-0.11627954247709849,-1.4245970180329845E-17,7.2547409090909121E-2,-90,4.4440673077675441E-18,-7.2547409090909121E-2,180]
[195,-0.370645499996828,-9.9314162402379766E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.24563404248027049,-9.9314162402379766E-2,0.26495166668448339,-22.014349486767259,{"$f":"Input!M$16*(COS(RADIANS(A73)))","v":-0.96592582628906831},{"$f":"Input!M$16*(SIN(RADIANS(A73)))","v":-0.25881904510252079},{"$f":"Input!M$12","v":1},-1.9659258262890682,-0.25881904510252079,1.9828897227476208,{"$f":"-DEGREES(ACOS(L73/N73))","v":-172.50000000000003},{"$f":"'Lens calcs'!G73/'Lens calcs'!N73","v":0.13361896208597479},150.48565051323277,-0.11627954247709851,6.5826248793697875E-2,8.3365562834606832E-2,240.48565051323277,-4.1069337722040938E-2,-7.2547409090909135E-2,195]
[210,-0.33231166416662028,-0.19186022876145081,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.28396787831047821,-0.19186022876145081,0.34270702253171115,-34.044557712758241,{"$f":"Input!M$16*(COS(RADIANS(A74)))","v":-0.8660254037844386},{"$f":"Input!M$16*(SIN(RADIANS(A74)))","v":-0.50000000000000011},{"$f":"Input!M$12","v":1},-1.8660254037844386,-0.50000000000000011,1.9318516525781366,{"$f":"-DEGREES(ACOS(L74/N74))","v":-164.99999999999997},{"$f":"'Lens calcs'!G74/'Lens calcs'!N74","v":0.1773982086431711},130.95544228724174,-0.11627954247709843,0.13397459621556143,0.11067966161773742,220.95544228724174,-8.3587444810887354E-2,-7.2547409090909093E-2,210]
[225,-0.27133133759444827,-0.27133133759444822,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34494820488265021,-0.27133133759444822,0.43887351117668888,-38.188085325174846,{"$f":"Input!M$16*(COS(RADIANS(A75)))","v":-0.70710678118654768},{"$f":"Input!M$16*(SIN(RADIANS(A75)))","v":-0.70710678118654746},{"$f":"Input!M$12","v":1},-1.7071067811865477,-0.70710678118654746,1.8477590650225737,-157.5,{"$f":"'Lens calcs'!G75/'Lens calcs'!N75","v":0.23751663270629239},119.31191467482515,-0.11627954247709843,0.20710678118654752,0.14818785791346165,209.31191467482515,-0.12921499397197131,-7.2547409090909079E-2,225]
[240,-0.19186022876145092,-0.33231166416662022,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.42441931371564756,-0.33231166416662022,0.53903877040158232,-38.060219398066657,{"$f":"Input!M$16*(COS(RADIANS(A76)))","v":-0.50000000000000044},{"$f":"Input!M$16*(SIN(RADIANS(A76)))","v":-0.86602540378443837},{"$f":"Input!M$12","v":1},-1.5000000000000004,-0.86602540378443837,1.7320508075688776,-150.00000000000003,{"$f":"'Lens calcs'!G76/'Lens calcs'!N76","v":0.31121417919499839},111.93978060193336,-0.11627954247709847,0.2886751345948127,0.19416813905505168,201.93978060193336,-0.1801059123357647,-7.2547409090909107E-2,240]
[250,-0.13124012587897388,-0.36057928237886316,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.48503941659812461,-0.36057928237886316,0.60438452539315157,-36.627187143579704,{"$f":"Input!M$16*(COS(RADIANS(A77)))","v":-0.34202014332566855},{"$f":"Input!M$16*(SIN(RADIANS(A77)))","v":-0.93969262078590843},{"$f":"Input!M$12","v":1},-1.3420201433256684,-0.93969262078590843,1.6383040885779834,-145,{"$f":"'Lens calcs'!G77/'Lens calcs'!N77","v":0.36890863522030626},108.3728128564203,-0.11627954247709854,0.35010376910485497,0.23016400913142249,198.3728128564203,-0.21843155571859529,-7.2547409090909148E-2,250]
[260,-6.6632358182372592E-2,-0.37789088155794504,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.54964718429472592,-0.37789088155794504,0.66701839972204757,-34.509120570005734,{"$f":"Input!M$16*(COS(RADIANS(A78)))","v":-0.17364817766693033},{"$f":"Input!M$16*(SIN(RADIANS(A78)))","v":-0.98480775301220802},{"$f":"Input!M$12","v":1},-1.1736481776669303,-0.98480775301220802,1.532088886237956,-140,{"$f":"'Lens calcs'!G78/'Lens calcs'!N78","v":0.43536534055795623},105.49087942999427,-0.1162795424770985,0.41954981558864002,0.27162669195814632,195.49087942999427,-0.26175930397661507,-7.2547409090909121E-2,260]
[270,{"$f":"E$3*(COS(RADIANS(A79)))","v":-7.0517178847651736E-17},{"$f":"E$3*(SIN(RADIANS(A79)))","v":-0.38372045752290151},{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.61627954247709837,{"$f":"C79","v":-0.38372045752290151},0.72597648997565101,{"$f":"DEGREES(ATAN(F79/E79))","v":-31.908055546426311},{"$f":"Input!M$16*(COS(RADIANS(A79)))","v":-1.83772268236293E-16},{"$f":"Input!M$16*(SIN(RADIANS(A79)))","v":-1},{"$f":"Input!M$12","v":1},-1.0000000000000002,-1,1.4142135623730951,{"$f":"-DEGREES(ACOS(L79/N79))","v":-135},{"$f":"'Lens calcs'!G79/'Lens calcs'!N79","v":0.51334289904379038},103.09194445357369,-0.11627954247709835,0.49999999999999983,0.32027729476298855,193.09194445357369,-0.31195259090909078,-7.254740909090901E-2,270]
[]
["1.0 calculation"]
[null,"Step 1",null,"Step 2","Step 3",null,null,null,"Step 4",null,null,null,null,null,null,"Step 5"]
["Angle","X","Y","X","X","Y","Mag","Angle","X","Y","Eb",null,null,null,null,"Magitude","Angle","R","jX","Mag","Angle","Zr (plot)","Zx (plot)","Angle"]
[0,{"$f":"F$3*(COS(RADIANS(A84)))","v":0.26860432026603104},{"$f":"F$3*(SIN(RADIANS(A84)))","v":0},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"B84+D84","v":0.88488386274312947},{"$f":"C84","v":0},{"$f":"((E84^2)+(F84^2))^0.5","v":0.88488386274312947},{"$f":"DEGREES(ATAN(F84/E84))","v":0},{"$f":"Input!M$17*(COS(RADIANS(A84)))","v":0.7},{"$f":"Input!M$17*(SIN(RADIANS(A84)))","v":0},{"$f":"Input!M$12","v":1},{"$f":"I84-K84","v":-0.30000000000000004},{"$f":"J84","v":0},{"$f":"((L84^2)+(M84^2))^0.5","v":0.30000000000000004},{"$f":"DEGREES(ACOS(L84/N84))","v":180},{"$f":"'Lens calcs'!G84/'Lens calcs'!N84","v":2.949612875810431},{"$f":"H84-O84","v":-180},{"$f":"P84*(COS(RADIANS(Q84)))","v":-2.949612875810431},{"$f":"P84*(SIN(RADIANS(Q84)))","v":-3.613713657377721E-16},{"$f":"P84*A$3","v":1.8402787575757569},{"$f":"Q84+U$3","v":-90},{"$f":"T84*COS(RADIANS(U84))","v":1.1273073382225468E-16},{"$f":"T84*SIN(RADIANS(U84))","v":-1.8402787575757569},0]
[20,{"$f":"F$3*(COS(RADIANS(A85)))","v":0.2524054976652042},{"$f":"F$3*(SIN(RADIANS(A85)))","v":9.1868088115281757E-2},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"B85+D85","v":0.86868504014230274},{"$f":"C85","v":9.1868088115281757E-2},{"$f":"((E85^2)+(F85^2))^0.5","v":0.87352930379065785},{"$f":"DEGREES(ATAN(F85/E85))","v":6.0368958566444881},{"$f":"Input!M$17*(COS(RADIANS(A85)))","v":0.65778483455013581},{"$f":"Input!M$17*(SIN(RADIANS(A85)))","v":0.23941410032796809},{"$f":"Input!M$12","v":1},{"$f":"I85-K85","v":-0.34221516544986419},{"$f":"J85","v":0.23941410032796809},{"$f":"((L85^2)+(M85^2))^0.5","v":0.41764857344390427},{"$f":"DEGREES(ACOS(L85/N85))","v":145.02332245305377},{"$f":"'Lens calcs'!G85/'Lens calcs'!N85","v":2.0915414521533959},{"$f":"H85-O85","v":-138.98642659640927},{"$f":"P85*(COS(RADIANS(Q85)))","v":-1.5781812581058288},{"$f":"P85*(SIN(RADIANS(Q85)))","v":-1.3725485647653564},{"$f":"P85*A$3","v":1.3049235499860283},{"$f":"Q85+U$3","v":-48.986426596409274},{"$f":"T85*COS(RADIANS(U85))","v":0.85634016185421369},{"$f":"T85*SIN(RADIANS(U85))","v":-0.98463546478056418},20]
[30,0.23261816491663423,0.13430216013301549,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.84889770739373271,0.13430216013301549,0.85945586729903101,8.9901214836875454,{"$f":"Input!M$17*(COS(RADIANS(A86)))","v":0.60621778264910708},{"$f":"Input!M$17*(SIN(RADIANS(A86)))","v":0.34999999999999992},{"$f":"Input!M$12","v":1},-0.39378221735089292,0.34999999999999992,0.52684384280523378,138.36878841450957,{"$f":"'Lens calcs'!G86/'Lens calcs'!N86","v":1.6313294328785748},-129.37866693082202,-1.0349851405987422,-1.2609684680100983,1.0177948864254587,-39.378666930822021,0.78672476130083469,-0.64573259232437474,30]
[45,0.18993193631611374,0.18993193631611371,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.8062114787932122,0.18993193631611371,0.82828201053187578,13.256351663487806,{"$f":"Input!M$17*(COS(RADIANS(A87)))","v":0.49497474683058329},{"$f":"Input!M$17*(SIN(RADIANS(A87)))","v":0.49497474683058318},{"$f":"Input!M$12","v":1},-0.50502525316941671,0.49497474683058318,0.70714249365939907,135.57583220692251,{"$f":"'Lens calcs'!G87/'Lens calcs'!N87","v":1.171308495753933},-122.31948054343471,-0.62622803121477921,-0.98984950631204693,0.73078544000853862,-32.319480543434707,0.61757223620825519,-0.39070691367469884,45]
[60,0.13430216013301555,0.2326181649166342,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.75058170261011403,0.2326181649166342,0.78580156715438032,17.21910690921095,{"$f":"Input!M$17*(COS(RADIANS(A88)))","v":0.35000000000000003},{"$f":"Input!M$17*(SIN(RADIANS(A88)))","v":0.60621778264910697},{"$f":"Input!M$12","v":1},-0.64999999999999991,0.60621778264910697,0.8888194417315588,136.99608805717719,{"$f":"'Lens calcs'!G88/'Lens calcs'!N88","v":0.88409583573410189},-119.77698114796624,-0.43906435260368104,-0.76736428183431271,0.55159197313838215,-29.776981147966239,0.47876255177861538,-0.27393452474108176,60]
[75,6.951991368166581E-2,0.25945184999777959,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.68579945615876425,0.25945184999777959,0.73323676703703777,20.722647478523488,{"$f":"Input!M$17*(COS(RADIANS(A89)))","v":0.18117333157176452},{"$f":"Input!M$17*(SIN(RADIANS(A89)))","v":0.67614807840234781},{"$f":"Input!M$12","v":1},-0.81882666842823548,0.67614807840234781,1.0619102301308105,140.4517277622798,{"$f":"'Lens calcs'!G89/'Lens calcs'!N89","v":0.69048846713409529},-119.72908028375632,-0.34241286879780686,-0.59960632962540394,0.43079933263065534,-29.729080283756318,0.37409749610427023,-0.21363316316418088,75]
[90,1.6454008397785402E-17,0.26860432026603104,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.61627954247709849,0.26860432026603104,0.67227134056224536,23.549892342658968,{"$f":"Input!M$17*(COS(RADIANS(A90)))","v":4.28801959218017E-17},{"$f":"Input!M$17*(SIN(RADIANS(A90)))","v":0.7},{"$f":"Input!M$12","v":1},-1,0.7,1.2206555615733703,145.00797980144134,{"$f":"'Lens calcs'!G90/'Lens calcs'!N90","v":0.55074614143871814},-121.45808745878237,-0.28742048207441401,-0.46979865771812074,0.3436133715099855,-31.458087458782373,0.29310981696156191,-0.17932312812690668,90]
[105,-6.9519913681665838E-2,0.25945184999777959,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.54675962879543261,0.25945184999777959,0.6051953024832476,25.385571669283284,{"$f":"Input!M$17*(COS(RADIANS(A91)))","v":-0.18117333157176457},{"$f":"Input!M$17*(SIN(RADIANS(A91)))","v":0.67614807840234781},{"$f":"Input!M$12","v":1},-1.1811733315717645,0.67614807840234781,1.361009428014196,150.21155360564629,{"$f":"'Lens calcs'!G91/'Lens calcs'!N91","v":0.44466650269004243},-124.82598193636301,-0.2539427591275128,-0.36502242903868187,0.27742973520928593,-34.825981936363007,0.22773938495709314,-0.15843620330486158,105]
[120,-0.13430216013301546,0.23261816491663423,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.48197738234408305,0.23261816491663423,0.53517605303342641,25.763487768827254,{"$f":"Input!M$17*(COS(RADIANS(A92)))","v":-0.34999999999999981},{"$f":"Input!M$17*(SIN(RADIANS(A92)))","v":0.60621778264910708},{"$f":"Input!M$12","v":1},-1.3499999999999999,0.60621778264910708,1.4798648586948739,155.81752564444361,{"$f":"'Lens calcs'!G92/'Lens calcs'!N92","v":0.36163846305899189},-130.05403787561636,-0.23271789864148229,-0.27681177289913556,0.22562811104726815,-40.054037875616359,0.17270429950004842,-0.14519390286425921,120]
[135,-0.18993193631611371,0.18993193631611374,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.42634760616098477,0.18993193631611374,0.46674020794440929,24.012308087709659,{"$f":"Input!M$17*(COS(RADIANS(A93)))","v":-0.49497474683058318},{"$f":"Input!M$17*(SIN(RADIANS(A93)))","v":0.49497474683058329},{"$f":"Input!M$12","v":1},-1.4949747468305832,0.49497474683058329,1.5747855389421019,161.68068621602183,{"$f":"'Lens calcs'!G93/'Lens calcs'!N93","v":0.29638334643201808},-137.66837812831216,-0.21910421719397824,-0.19959065621931216,0.1849151056435494,-47.668378128312156,0.12452564465772017,-0.13670025646553938,135]
[150,-0.23261816491663423,0.13430216013301549,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.38366137756046426,0.13430216013301549,0.40648877333573097,19.292797210109892,{"$f":"Input!M$17*(COS(RADIANS(A94)))","v":-0.60621778264910708},{"$f":"Input!M$17*(SIN(RADIANS(A94)))","v":0.34999999999999992},{"$f":"Input!M$12","v":1},-1.6062177826491071,0.34999999999999992,1.6439086243761283,167.70722314185903,{"$f":"'Lens calcs'!G94/'Lens calcs'!N94","v":0.24726968841713787},-148.41442593174915,-0.21063886903216505,-0.12951280115401284,0.15427283991001955,-58.41442593174915,8.0803707751776435E-2,-0.13141868188148909,150]
[165,-0.25945184999777954,6.9519913681665893E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.35682769247931895,6.9519913681665893E-2,0.36353682140661031,11.024697502472705,{"$f":"Input!M$17*(COS(RADIANS(A95)))","v":-0.6761480784023477},{"$f":"Input!M$17*(SIN(RADIANS(A95)))","v":0.18117333157176471},{"$f":"Input!M$12","v":1},-1.6761480784023477,0.18117333157176471,1.6859110761854244,173.83090160228517,{"$f":"'Lens calcs'!G95/'Lens calcs'!N95","v":0.21563226349349093},-162.80620409981248,-0.20599573879587699,-6.374189091380271E-2,0.13453408656077254,-72.806204099812476,3.9768896040010777E-2,-0.12852180886721232,165]
[180,-0.26860432026603104,3.2908016795570804E-17,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34767522221106745,3.2908016795570804E-17,0.34767522221106745,5.4231373249462885E-15,{"$f":"Input!M$17*(COS(RADIANS(A96)))","v":-0.7},{"$f":"Input!M$17*(SIN(RADIANS(A96)))","v":8.5760391843603401E-17},{"$f":"Input!M$12","v":1},-1.7,8.5760391843603401E-17,1.7,180,{"$f":"'Lens calcs'!G96/'Lens calcs'!N96","v":0.20451483659474556},-180,-0.20451483659474556,-2.5056103605994144E-17,0.12759786631016046,-90,7.8163164379764871E-18,-0.12759786631016046,180]
[195,-0.25945184999777959,-6.9519913681665824E-2,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.35682769247931889,-6.9519913681665824E-2,0.36353682140661026,-11.024697502472694,{"$f":"Input!M$17*(COS(RADIANS(A97)))","v":-0.67614807840234781},{"$f":"Input!M$17*(SIN(RADIANS(A97)))","v":-0.18117333157176455},{"$f":"Input!M$12","v":1},-1.6761480784023477,-0.18117333157176455,1.6859110761854244,{"$f":"-DEGREES(ACOS(L97/N97))","v":-173.83090160228517},{"$f":"'Lens calcs'!G97/'Lens calcs'!N97","v":0.21563226349349091},162.80620409981248,-0.20599573879587696,6.3741890913802696E-2,0.13453408656077254,252.80620409981248,-3.9768896040010791E-2,-0.12852180886721229,195]
[210,-0.2326181649166342,-0.13430216013301555,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.38366137756046426,-0.13430216013301555,0.40648877333573097,-19.292797210109899,{"$f":"Input!M$17*(COS(RADIANS(A98)))","v":-0.60621778264910697},{"$f":"Input!M$17*(SIN(RADIANS(A98)))","v":-0.35000000000000003},{"$f":"Input!M$12","v":1},-1.6062177826491069,-0.35000000000000003,1.6439086243761281,{"$f":"-DEGREES(ACOS(L98/N98))","v":-167.70722314185903},{"$f":"'Lens calcs'!G98/'Lens calcs'!N98","v":0.2472696884171379},148.41442593174912,-0.21063886903216494,0.12951280115401304,0.15427283991001958,238.41442593174912,-8.0803707751776491E-2,-0.13141868188148909,210]
[225,-0.1899319363161138,-0.18993193631611371,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.42634760616098466,-0.18993193631611371,0.46674020794440924,-24.012308087709663,{"$f":"Input!M$17*(COS(RADIANS(A99)))","v":-0.49497474683058335},{"$f":"Input!M$17*(SIN(RADIANS(A99)))","v":-0.49497474683058318},{"$f":"Input!M$12","v":1},-1.4949747468305834,-0.49497474683058318,1.5747855389421022,-161.68068621602183,{"$f":"'Lens calcs'!G99/'Lens calcs'!N99","v":0.29638334643201802},137.66837812831216,-0.21910421719397818,0.19959065621931213,0.18491510564354935,227.66837812831216,-0.12452564465772013,-0.13670025646553935,225]
[240,-0.13430216013301563,-0.23261816491663415,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.48197738234408283,-0.23261816491663415,0.53517605303342619,-25.763487768827257,{"$f":"Input!M$17*(COS(RADIANS(A100)))","v":-0.35000000000000031},{"$f":"Input!M$17*(SIN(RADIANS(A100)))","v":-0.60621778264910686},{"$f":"Input!M$12","v":1},-1.3500000000000003,-0.60621778264910686,1.4798648586948744,-155.81752564444361,{"$f":"'Lens calcs'!G100/'Lens calcs'!N100","v":0.36163846305899161},130.05403787561636,-0.2327178986414821,0.27681177289913539,0.22562811104726799,220.05403787561636,-0.17270429950004831,-0.14519390286425909,240]
[250,-9.1868088115281715E-2,-0.2524054976652042,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.5244114543618168,-0.2524054976652042,0.58199304868485779,-25.702067669473962,{"$f":"Input!M$17*(COS(RADIANS(A101)))","v":-0.23941410032796798},{"$f":"Input!M$17*(SIN(RADIANS(A101)))","v":-0.65778483455013581},{"$f":"Input!M$12","v":1},-1.2394141003279679,-0.65778483455013581,1.4031493864360758,-152.04410604785102,{"$f":"'Lens calcs'!G101/'Lens calcs'!N101","v":0.4147762556936927},126.34203837837705,-0.24579820739415115,0.33409966107301187,0.25878105522243799,216.34203837837705,-0.20844650978715037,-0.15335477527483099,250]
[260,-4.6642650727660814E-2,-0.26452361709056149,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.56963689174943766,-0.26452361709056149,0.62805965675295095,-24.90885185695555,{"$f":"Input!M$17*(COS(RADIANS(A102)))","v":-0.12155372436685122},{"$f":"Input!M$17*(SIN(RADIANS(A102)))","v":-0.68936542710854554},{"$f":"Input!M$12","v":1},-1.1215537243668512,-0.68936542710854554,1.3164753885787999,-148.42294670909803,{"$f":"'Lens calcs'!G102/'Lens calcs'!N102","v":0.47707664131189897},123.51409485214248,-0.26341410137955806,0.39776265898126012,0.29765058863890781,213.51409485214248,-0.24816618407218655,-0.16434542281468612,260]
[270,-4.9362025193356206E-17,-0.26860432026603104,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.61627954247709849,-0.26860432026603104,0.67227134056224536,-23.549892342658968,{"$f":"Input!M$17*(COS(RADIANS(A103)))","v":-1.286405877654051E-16},{"$f":"Input!M$17*(SIN(RADIANS(A103)))","v":-0.7},{"$f":"Input!M$12","v":1},-1.0000000000000002,-0.7,1.2206555615733705,{"$f":"-DEGREES(ACOS(L103/N103))","v":-145.00797980144134},{"$f":"'Lens calcs'!G103/'Lens calcs'!N103","v":0.55074614143871803},121.45808745878237,-0.28742048207441395,0.46979865771812063,0.34361337150998544,211.45808745878236,-0.29310981696156191,-0.17932312812690657,270]
[]
["Left Lens",120,240]
[]
[0.7,{"$f":"(1-C3)*A107","v":0.26860432026603104},{"$f":"B107*(COS(RADIANS(B$105)))","v":-0.13430216013301546},{"$f":"B107*(SIN(RADIANS(B$105)))","v":0.23261816491663423},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"C107+E107","v":0.48197738234408305},{"$f":"D107","v":0.23261816491663423},{"$f":"((F107^2)+(G107^2))^0.5","v":0.53517605303342641},{"$f":"DEGREES(ATAN(G107/F107))","v":25.763487768827254},{"$f":"A107*(COS(RADIANS(B$105)))","v":-0.34999999999999981},{"$f":"A107*(SIN(RADIANS(B$105)))","v":0.60621778264910708},{"$f":"Input!M$12","v":1},{"$f":"J107-L107","v":-1.3499999999999999},{"$f":"K107","v":0.60621778264910708},{"$f":"((M107^2)+(N107^2))^0.5","v":1.4798648586948739},{"$f":"DEGREES(ACOS(M107/O107))","v":155.81752564444361},{"$f":"'Lens calcs'!H107/'Lens calcs'!O107","v":0.36163846305899189},{"$f":"I107-P107","v":-130.05403787561636},{"$f":"Q107*(COS(RADIANS(R107)))","v":-0.23271789864148229},{"$f":"Q107*(SIN(RADIANS(R107)))","v":-0.27681177289913556},{"$f":"Q107*A$3","v":0.22562811104726815},{"$f":"R107+U$3","v":-40.054037875616359},{"$f":"U107*COS(RADIANS(V107))","v":0.17270429950004842},{"$f":"U107*SIN(RADIANS(V107))","v":-0.14519390286425921}]
[0.75,{"$f":"(1-C$3)*A108","v":0.28779034314217611},{"$f":"B108*(COS(RADIANS(B$105)))","v":-0.143895171571088},{"$f":"B108*(SIN(RADIANS(B$105)))","v":0.24923374812496524},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"C108+E108","v":0.47238437090601049},{"$f":"D108","v":0.24923374812496524},{"$f":"((F108^2)+(G108^2))^0.5","v":0.53410154004710186},{"$f":"DEGREES(ATAN(G108/F108))","v":27.81648520432832},{"$f":"A108*(COS(RADIANS(B$105)))","v":-0.37499999999999983},{"$f":"A108*(SIN(RADIANS(B$105)))","v":0.649519052838329},{"$f":"Input!M$12","v":1},{"$f":"J108-L108","v":-1.3749999999999998},{"$f":"K108","v":0.649519052838329},{"$f":"((M108^2)+(N108^2))^0.5","v":1.5206906325745546},{"$f":"DEGREES(ACOS(M108/O108))","v":154.71500395394821},{"$f":"'Lens calcs'!H108/'Lens calcs'!O108","v":0.35122300920790117},{"$f":"I108-P108","v":-126.8985187496199},{"$f":"Q108*(COS(RADIANS(R108)))","v":-0.21087413707169322},{"$f":"Q108*(SIN(RADIANS(R108)))","v":-0.2808731039300883},{"$f":"Q108*A$3","v":0.21912985541858451},{"$f":"R108+U$3","v":-36.898518749619896},{"$f":"U108*COS(RADIANS(V108))","v":0.17523818497533883},{"$f":"U108*SIN(RADIANS(V108))","v":-0.13156546683046691}]
[0.8,{"$f":"(1-C$3)*A109","v":0.30697636601832123},{"$f":"B109*(COS(RADIANS(B$105)))","v":-0.15348818300916056},0.2658493313332963,{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"C109+E109","v":0.46279135946793792},{"$f":"D109","v":0.2658493313332963},{"$f":"((F109^2)+(G109^2))^0.5","v":0.53371500762911184},{"$f":"DEGREES(ATAN(G109/F109))","v":29.875105138849221},-0.39999999999999986,0.69282032302755103,{"$f":"Input!M$12","v":1},{"$f":"J109-L109","v":-1.4},{"$f":"K109","v":0.69282032302755103},{"$f":"((M109^2)+(N109^2))^0.5","v":1.5620499351813308},{"$f":"DEGREES(ACOS(M109/O109))","v":153.6704965083151},{"$f":"'Lens calcs'!H109/'Lens calcs'!O109","v":0.34167602175096629},{"$f":"I109-P109","v":-123.79539136946588},{"$f":"Q109*(COS(RADIANS(R109)))","v":-0.19005003428037717},{"$f":"Q109*(SIN(RADIANS(R109)))","v":-0.2839427553391603},{"$f":"Q109*A$3","v":0.21317344047344966},{"$f":"R109+U$3","v":-33.795391369465875},{"$f":"U109*COS(RADIANS(V109))","v":0.17715335639583435},{"$f":"U109*SIN(RADIANS(V109))","v":-0.11857320119225037}]
[0.85,0.3261623888944663,-0.16308119444723307,0.28246491454162731,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.45319834802986542,0.28246491454162731,0.53401794970207495,31.934047449902934,-0.42499999999999982,0.73612159321677284,{"$f":"Input!M$12","v":1},-1.4249999999999998,0.73612159321677284,1.6039014932345439,152.68018394739272,{"$f":"'Lens calcs'!H110/'Lens calcs'!O110","v":0.33294934380610597},-120.74613649748979,-0.17021540253540748,-0.28615027919019359,0.20772882088359285,-30.746136497489786,0.17853064196548118,-0.10619827166710842]
[0.9,0.34534841177061137,-0.1726742058853056,0.29908049774995832,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.44360533659179291,0.29908049774995832,0.53500919504909517,33.988007041612029,-0.44999999999999979,0.77942286340599487,{"$f":"Input!M$12","v":1},-1.4499999999999997,0.77942286340599487,1.6462077633154326,151.74050304473346,{"$f":"'Lens calcs'!H111/'Lens calcs'!O111","v":0.32499494108301152},-117.75249600312142,-0.15133489303060393,-0.28760991269593927,0.20276602780638558,-27.752496003121422,0.17944131487327139,-9.441862395169405E-2]
[0.95,0.36453443464675644,-0.18226721732337814,0.31569608095828933,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.43401232515372035,0.31569608095828933,0.53668492984036875,36.031755428573611,-0.47499999999999976,0.82272413359521679,{"$f":"Input!M$12","v":1},-1.4749999999999996,0.82272413359521679,1.6889345754054534,150.8481363467599,{"$f":"'Lens calcs'!H112/'Lens calcs'!O112","v":0.31776537567272534},-114.8163809181863,-0.13336981416859722,-0.28842213272400247,0.19825546448461454,-24.816380918186297,0.17994806315755654,-8.3210118157915722E-2]
[1,0.38372045752290151,-0.19186022876145067,0.33231166416662034,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.42441931371564778,0.33231166416662034,0.53903877040158255,38.06021939806665,-0.49999999999999978,0.86602540378443871,{"$f":"Input!M$12","v":1},-1.4999999999999998,0.86602540378443871,1.732050807568877,150.00000000000003,{"$f":"'Lens calcs'!H113/'Lens calcs'!O113","v":0.31121417919499861},-111.93978060193338,-0.11627954247709867,-0.28867513459481287,0.19416813905505181,-21.939780601933379,0.18010591233576481,-7.2547409090909232E-2]
[1.05,0.40290648039904658,-0.20145324019952321,0.34892724737495134,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.41482630227757528,0.34892724737495134,0.54206188301885494,40.068553844205923,-0.5249999999999998,0.90932667397366063,{"$f":"Input!M$12","v":1},-1.5249999999999999,0.90932667397366063,1.7755280904564703,149.19323054941873,{"$f":"'Lens calcs'!H114/'Lens calcs'!O114","v":0.30529614593678228},-109.12467670521281,-0.10002260353974728,-0.28844620903208906,0.19047584743907831,-19.124676705212806,0.17996308449093079,-6.2404620647393931E-2]
[1.1000000000000001,0.42209250327519171,-0.21104625163759577,0.36554283058328241,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.40523329083950271,0.36554283058328241,0.54574314562388349,42.052206269844405,-0.54999999999999982,0.95262794416288266,{"$f":"Input!M$12","v":1},-1.5499999999999998,0.95262794416288266,1.8193405398660252,148.42517128680521,{"$f":"'Lens calcs'!H115/'Lens calcs'!O115","v":0.29996756168807825},-106.3729650169608,-8.4557488096433819E-2,-0.28780300427881655,0.18715131611455713,-16.372965016960805,0.17956178571239398,-5.2755854984894296E-2]
[1.1499999999999999,0.44127852615133673,-0.22063926307566825,0.38215841379161336,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.39564027940143021,0.38215841379161336,0.55006934464353108,44.006971006737757,-0.57499999999999973,0.99592921435210446,{"$f":"Input!M$12","v":1},-1.5749999999999997,0.99592921435210446,1.8634645153584222,147.69335856879815,{"$f":"'Lens calcs'!H116/'Lens calcs'!O116","v":0.29518638005174452},-103.68638756206039,-6.9843257379906196E-2,-0.28680466935985743,0.18416831211643458,-13.686387562060389,0.17893891938326537,-4.3575570194384468E-2]
[1.2,0.4604645490274818,-0.23023227451374079,0.39877399699994437,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.3860472679633577,0.39877399699994437,0.55502539922537253,45.929031853925004,-0.59999999999999976,1.0392304845413265,{"$f":"Input!M$12","v":1},-1.5999999999999996,1.0392304845413265,1.9078784028338909,146.99550840111692,{"$f":"'Lens calcs'!H117/'Lens calcs'!O117","v":0.29091235500174362},-101.06647654719191,-5.5839982037538045E-2,-0.28550288036849636,0.18150172574051829,-11.066476547191911,0.17812672648592132,-3.4838854145854192E-2]
[1.25,0.47965057190362692,-0.23982528595181335,0.41538958020827543,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.37645425652528514,0.41538958020827543,0.56059460450633347,47.814992515286107,-0.62499999999999978,1.0825317547305484,{"$f":"Input!M$12","v":1},-1.6249999999999998,1.0825317547305484,1.9525624189766633,146.3295034916849,{"$f":"'Lens calcs'!H118/'Lens calcs'!O118","v":0.28710713627282691},-98.514510976398796,-4.2509050673819875E-2,-0.28394275533916025,0.17912763005759558,-8.5145109763987961,0.17715335639583429,-2.6521616989567887E-2]
[1.3,0.49883659477977199,-0.24941829738988588,0.43200516341660644,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.36686124508721263,0.43200516341660644,0.56675888556382492,49.661894869838314,-0.64999999999999969,1.1258330249197703,{"$f":"Input!M$12","v":1},-1.6499999999999997,1.1258330249197703,1.9974984355438177,145.69338090449855,{"$f":"'Lens calcs'!H119/'Lens calcs'!O119","v":0.28373433264268122},-96.031486034660247,-2.9813377063564701E-2,-0.28216366539342619,0.17702332039549248,-6.0314860346602472,0.17604337295977018,-1.8600720437457339E-2]
[1.35,0.51802261765591706,-0.25901130882795842,0.44862074662493751,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.35726823364914007,0.44862074662493751,0.57349905412048663,51.467225682818849,-0.67499999999999971,1.1691342951089922,{"$f":"Input!M$12","v":1},-1.6749999999999998,1.1691342951089922,2.0426698215815495,145.08532039330458,{"$f":"'Lens calcs'!H120/'Lens calcs'!O120","v":0.2807595471677608},-93.618094710485735,-1.7717529295552561E-2,-0.28019995089490529,0.17516733632289219,-3.6180947104857353,0.17481820130853151,-1.1054058336510686E-2]
[1.4,0.53720864053206208,-0.26860432026603093,0.46523632983326846,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34767522221106756,0.46523632983326846,0.58079506087452648,53.228912827076122,-0.69999999999999962,1.2124355652982142,{"$f":"Input!M$12","v":1},-1.6999999999999997,1.2124355652982142,2.0880613017821097,144.50363345534541,{"$f":"'Lens calcs'!H121/'Lens calcs'!O121","v":0.27815038781612011},-91.274720628269279,-6.1877993578324597E-3,-0.27808155167390236,0.1735394682832142,-1.2747206282692787,0.17349652105738816,-3.8606000834029092E-3]
[1.42,0.5448830496825201,-0.27244152484125994,0.47188256311660087,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34383801763583854,0.47188256311660087,0.5838644840587891,53.920985263721597,-0.70999999999999963,{"$f":"A122*(SIN(RADIANS(B$105)))","v":1.2297560733739028},{"$f":"Input!M$12","v":1},-1.7099999999999995,1.2297560733739028,2.1062763351469336,144.27798841642954,{"$f":"'Lens calcs'!H122/'Lens calcs'!O122","v":0.27720222380889958},-90.357003152707932,-1.7272027421782958E-3,-0.27719684279458645,0.17294790384589581,-0.35700315270793226,0.1729445466031824,-1.077610740895626E-3]
[]
["Right Lens",240]
[0.7,{"$f":"(1-C$3)*A125","v":0.26860432026603104},{"$f":"B125*(COS(RADIANS(B$124)))","v":-0.13430216013301563},{"$f":"B125*(SIN(RADIANS(B$124)))","v":-0.23261816491663415},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"C125+E125","v":0.48197738234408283},{"$f":"D125","v":-0.23261816491663415},{"$f":"((F125^2)+(G125^2))^0.5","v":0.53517605303342619},{"$f":"DEGREES(ATAN(G125/F125))","v":-25.763487768827257},{"$f":"A125*(COS(RADIANS(B$105)))","v":-0.34999999999999981},{"$f":"A125*(SIN(RADIANS(B$124)))","v":-0.60621778264910686},{"$f":"Input!M$12","v":1},{"$f":"J125-L125","v":-1.3499999999999999},{"$f":"K125","v":-0.60621778264910686},{"$f":"((M125^2)+(N125^2))^0.5","v":1.4798648586948739},{"$f":"-DEGREES(ACOS(M125/O125))","v":-155.81752564444361},{"$f":"'Lens calcs'!H125/'Lens calcs'!O125","v":0.36163846305899172},{"$f":"I125-P125","v":130.05403787561636},{"$f":"Q125*(COS(RADIANS(R125)))","v":-0.23271789864148218},{"$f":"Q125*(SIN(RADIANS(R125)))","v":0.27681177289913544},{"$f":"Q125*A$3","v":0.22562811104726804},{"$f":"R125+U$3","v":220.05403787561636},{"$f":"U125*COS(RADIANS(V125))","v":-0.17270429950004837},{"$f":"U125*SIN(RADIANS(V125))","v":-0.14519390286425912}]
[0.75,{"$f":"(1-C$3)*A126","v":0.28779034314217611},{"$f":"B126*(COS(RADIANS(B$124)))","v":-0.14389517157108819},{"$f":"B126*(SIN(RADIANS(B$124)))","v":-0.24923374812496513},{"$f":"C$3*Input!M$12","v":0.61627954247709849},{"$f":"C126+E126","v":0.47238437090601026},{"$f":"D126","v":-0.24923374812496513},{"$f":"((F126^2)+(G126^2))^0.5","v":0.53410154004710153},{"$f":"DEGREES(ATAN(G126/F126))","v":-27.81648520432832},{"$f":"A126*(COS(RADIANS(B$105)))","v":-0.37499999999999983},{"$f":"A126*(SIN(RADIANS(B$124)))","v":-0.64951905283832878},{"$f":"Input!M$12","v":1},{"$f":"J126-L126","v":-1.3749999999999998},{"$f":"K126","v":-0.64951905283832878},{"$f":"((M126^2)+(N126^2))^0.5","v":1.5206906325745546},{"$f":"-DEGREES(ACOS(M126/O126))","v":-154.71500395394821},{"$f":"'Lens calcs'!H126/'Lens calcs'!O126","v":0.35122300920790095},{"$f":"I126-P126","v":126.8985187496199},{"$f":"Q126*(COS(RADIANS(R126)))","v":-0.21087413707169309},{"$f":"Q126*(SIN(RADIANS(R126)))","v":0.28087310393008813},{"$f":"Q126*A$3","v":0.21912985541858437},{"$f":"R126+U$3","v":216.89851874961988},{"$f":"U126*COS(RADIANS(V126))","v":-0.17523818497533875},{"$f":"U126*SIN(RADIANS(V126))","v":-0.13156546683046677}]
[0.8,0.30697636601832123,-0.15348818300916076,-0.26584933133329619,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.4627913594679377,-0.26584933133329619,0.53371500762911162,-29.875105138849221,-0.39999999999999986,-0.6928203230275507,{"$f":"Input!M$12","v":1},-1.4,-0.6928203230275507,1.5620499351813306,-153.67049650831513,{"$f":"'Lens calcs'!H127/'Lens calcs'!O127","v":0.34167602175096617},123.7953913694659,-0.1900500342803772,0.28394275533916014,0.21317344047344958,213.7953913694659,-0.17715335639583421,-0.11857320119225043]
[0.85,0.3261623888944663,-0.16308119444723329,-0.2824649145416272,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.45319834802986519,-0.2824649145416272,0.53401794970207472,-31.934047449902934,-0.42499999999999982,-0.73612159321677262,{"$f":"Input!M$12","v":1},-1.4249999999999998,-0.73612159321677262,1.6039014932345439,-152.68018394739272,{"$f":"'Lens calcs'!H128/'Lens calcs'!O128","v":0.33294934380610586},120.74613649748979,-0.17021540253540743,0.28615027919019353,0.20772882088359279,210.74613649748977,-0.17853064196548116,-0.10619827166710835]
[0.9,0.34534841177061137,-0.17267420588530585,-0.29908049774995821,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.44360533659179263,-0.29908049774995821,0.53500919504909483,-33.988007041612029,-0.44999999999999979,-0.77942286340599454,{"$f":"Input!M$12","v":1},-1.4499999999999997,-0.77942286340599454,1.6462077633154324,-151.74050304473346,{"$f":"'Lens calcs'!H129/'Lens calcs'!O129","v":0.32499494108301136},117.75249600312142,-0.15133489303060385,0.28760991269593911,0.20276602780638547,207.75249600312142,-0.17944131487327128,-9.4418623951693967E-2]
[0.95,0.36453443464675644,-0.18226721732337839,-0.31569608095828922,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.43401232515372012,-0.31569608095828922,0.53668492984036842,-36.031755428573611,-0.47499999999999976,-0.82272413359521646,{"$f":"Input!M$12","v":1},-1.4749999999999996,-0.82272413359521646,1.6889345754054532,-150.84813634675993,{"$f":"'Lens calcs'!H130/'Lens calcs'!O130","v":0.31776537567272517},114.81638091818633,-0.13336981416859725,0.2884221327240023,0.19825546448461442,204.81638091818633,-0.1799480631575564,-8.3210118157915777E-2]
[1,0.38372045752290151,-0.19186022876145092,-0.33231166416662022,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.42441931371564756,-0.33231166416662022,0.53903877040158232,-38.060219398066657,-0.49999999999999978,-0.86602540378443837,{"$f":"Input!M$12","v":1},-1.4999999999999998,-0.86602540378443837,1.732050807568877,-150.00000000000003,{"$f":"'Lens calcs'!H131/'Lens calcs'!O131","v":0.3112141791949985},111.93978060193336,-0.11627954247709851,0.28867513459481281,0.19416813905505173,201.93978060193336,-0.18010591233576476,-7.2547409090909121E-2]
[1.05,0.40290648039904658,-0.20145324019952346,-0.34892724737495123,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.414826302277575,-0.34892724737495123,0.54206188301885461,-40.068553844205923,-0.5249999999999998,-0.90932667397366029,{"$f":"Input!M$12","v":1},-1.5249999999999999,-0.90932667397366029,1.7755280904564701,-149.19323054941873,{"$f":"'Lens calcs'!H132/'Lens calcs'!O132","v":0.30529614593678212},109.12467670521281,-0.10002260353974722,0.2884462090320889,0.19047584743907819,199.12467670521281,-0.17996308449093068,-6.2404620647393882E-2]
[1.1000000000000001,0.42209250327519171,-0.21104625163759605,-0.3655428305832823,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.40523329083950244,-0.3655428305832823,0.54574314562388315,-42.052206269844419,-0.54999999999999982,-0.95262794416288232,{"$f":"Input!M$12","v":1},-1.5499999999999998,-0.95262794416288232,1.819340539866025,-148.42517128680521,{"$f":"'Lens calcs'!H133/'Lens calcs'!O133","v":0.29996756168807809},106.37296501696079,-8.4557488096433722E-2,0.28780300427881639,0.18715131611455701,196.37296501696079,-0.17956178571239387,-5.2755854984894213E-2]
[1.1499999999999999,0.44127852615133673,-0.22063926307566856,-0.38215841379161325,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.39564027940142993,-0.38215841379161325,0.55006934464353074,-44.006971006737771,-0.57499999999999973,-0.99592921435210402,{"$f":"Input!M$12","v":1},-1.5749999999999997,-0.99592921435210402,1.8634645153584219,-147.69335856879815,{"$f":"'Lens calcs'!H134/'Lens calcs'!O134","v":0.29518638005174436},103.68638756206037,-6.9843257379906099E-2,0.28680466935985727,0.18416831211643447,193.68638756206036,-0.17893891938326528,-4.3575570194384371E-2]
[1.2,0.4604645490274818,-0.23023227451374109,-0.39877399699994426,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.38604726796335742,-0.39877399699994426,0.5550253992253722,-45.929031853925018,-0.59999999999999976,-1.039230484541326,{"$f":"Input!M$12","v":1},-1.5999999999999996,-1.039230484541326,1.9078784028338907,-146.99550840111692,{"$f":"'Lens calcs'!H135/'Lens calcs'!O135","v":0.29091235500174351},101.06647654719191,-5.5839982037538025E-2,0.28550288036849625,0.18150172574051823,191.06647654719191,-0.17812672648592126,-3.4838854145854199E-2]
[1.25,0.47965057190362692,-0.23982528595181368,-0.41538958020827532,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.3764542565252848,-0.41538958020827532,0.56059460450633325,-47.814992515286121,-0.62499999999999978,-1.082531754730548,{"$f":"Input!M$12","v":1},-1.6249999999999998,-1.082531754730548,1.9525624189766631,-146.3295034916849,{"$f":"'Lens calcs'!H136/'Lens calcs'!O136","v":0.28710713627282686},98.514510976398782,-4.2509050673819805E-2,0.28394275533916019,0.17912763005759552,188.51451097639878,-0.17715335639583424,-2.6521616989567835E-2]
[1.3,0.49883659477977199,-0.24941829738988622,-0.43200516341660627,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.3668612450872123,-0.43200516341660627,0.56675888556382448,-49.661894869838321,-0.64999999999999969,-1.1258330249197699,{"$f":"Input!M$12","v":1},-1.6499999999999997,-1.1258330249197699,1.9974984355438175,-145.69338090449855,{"$f":"'Lens calcs'!H137/'Lens calcs'!O137","v":0.28373433264268105},96.031486034660233,-2.9813377063564621E-2,0.28216366539342608,0.1770233203954924,186.03148603466025,-0.1760433729597701,-1.8600720437457283E-2]
[1.35,0.51802261765591706,-0.25901130882795875,-0.44862074662493728,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.35726823364913973,-0.44862074662493728,0.5734990541204863,-51.467225682818871,-0.67499999999999971,-1.1691342951089918,{"$f":"Input!M$12","v":1},-1.6749999999999998,-1.1691342951089918,2.0426698215815495,-145.08532039330458,{"$f":"'Lens calcs'!H138/'Lens calcs'!O138","v":0.28075954716776064},93.618094710485707,-1.7717529295552426E-2,0.28019995089490513,0.17516733632289208,183.61809471048571,-0.1748182013085314,-1.1054058336510589E-2]
[1.4,0.53720864053206208,-0.26860432026603126,-0.46523632983326829,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34767522221106723,-0.46523632983326829,0.58079506087452626,-53.228912827076137,-0.69999999999999962,-1.2124355652982137,{"$f":"Input!M$12","v":1},-1.6999999999999997,-1.2124355652982137,2.0880613017821097,-144.50363345534541,{"$f":"'Lens calcs'!H139/'Lens calcs'!O139","v":0.27815038781612006},91.274720628269279,-6.187799357832458E-3,0.27808155167390231,0.17353946828321415,181.27472062826928,-0.17349652105738811,-3.8606000834028771E-3]
[1.42,0.5448830496825201,-0.27244152484126027,-0.47188256311660065,{"$f":"C$3*Input!M$12","v":0.61627954247709849},0.34383801763583821,-0.47188256311660065,0.58386448405878877,-53.920985263721604,-0.70999999999999963,-1.2297560733739024,{"$f":"Input!M$12","v":1},-1.7099999999999995,-1.2297560733739024,2.1062763351469336,-144.27798841642954,{"$f":"'Lens calcs'!H140/'Lens calcs'!O140","v":0.27720222380889942},90.357003152707932,-1.7272027421782947E-3,0.27719684279458628,0.1729479038458957,180.35700315270793,-0.17294454660318229,-1.0776107408956004E-3]

{"sheet":"Distance Relay Calcs","index":3,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"Calculation Worksheet for 21-1 Relay "]
["Distance Relay connected at the generator terminals"]
["21 (Diameter)"]
["   Sec ohms",{"$f":"Input!H13","v":10}]
["   Per unit",{"$f":"Input!I13","v":0.65277777777777779}]
["Center (gen terminals)",0]
["Max Torque Angle",{"$f":"Input!H14","v":85}]
[]
[null,"Angle","Shift",null,"R","X"]
[null,0,{"$f":"B$7-B10","v":85},{"$f":"COS(RADIANS(C10))*B$5","v":5.6893332071387949E-2},{"$f":"COS(RADIANS(B10))*D10","v":5.6893332071387949E-2},{"$f":"SIN(RADIANS(B10))*D10","v":0}]
[null,10,{"$f":"B$7-B11","v":75},{"$f":"COS(RADIANS(C11))*B$5","v":0.16895132110858993},{"$f":"COS(RADIANS(B11))*D11","v":0.16638457090939449},{"$f":"SIN(RADIANS(B11))*D11","v":2.933808902492702E-2}]
[null,20,65,0.275875809747401,0.2592384626729699,9.4355083989891009E-2]
[null,30,55,0.37441795150693291,0.32425545763793395,0.18720897575346643]
[null,40,45,0.4615835932745519,0.35359354666286097,0.29670021459147294]
[null,50,35,0.53472425113309185,0.34371412322726491,0.40962254118146191]
[null,60,25,0.59161758320447988,0.29580879160224,0.51235585638063341]
[null,70,15,0.6305349143831418,0.21565564178916047,0.59250900619371283]
[null,80,5,0.65029376125433391,0.11292232658998901,0.6404143378187378]
[null,90,-5,0.65029376125433391,3.9835319841873111E-17,0.65029376125433391]
[null,100,-15,0.6305349143831418,-0.10949123883800649,0.62095567222940684]
[null,110,-25,0.59161758320447988,-0.20234513060158194,0.5559386772644429]
[null,120,-35,0.53472425113309185,-0.26736212556654582,0.46308478550086746]
[null,130,-45,0.4615835932745519,-0.296700214591473,0.35359354666286097]
[null,140,-55,0.37441795150693291,-0.28682079115587689,0.24067122007287206]
[null,150,-65,0.275875809747401,-0.23891545953085194,0.13793790487370047]
[null,160,-75,0.16895132110858993,-0.15876230971777242,5.7784755060621036E-2]
[null,170,-85,5.6893332071387949E-2,-5.6028994518600959E-2,9.8794234355960367E-3]
[null,180,-95,-5.6893332071388018E-2,5.6893332071388018E-2,-6.9702777881864071E-18]
[null,190,-105,-0.16895132110859001,0.16638457090939457,2.9338089024927058E-2]
[null,200,-115,-0.27587580974740095,0.25923846267296985,9.4355083989890967E-2]
[null,210,-125,-0.37441795150693291,0.3242554576379339,0.18720897575346648]
[null,220,-135,-0.46158359327455184,0.35359354666286091,0.29670021459147289]
[null,230,-145,-0.53472425113309197,0.34371412322726502,0.40962254118146191]
[null,240,-155,-0.59161758320447988,0.29580879160224022,0.5123558563806333]
[null,250,-165,-0.6305349143831418,0.2156556417891603,0.59250900619371294]
[null,260,-175,-0.65029376125433391,0.11292232658998895,0.6404143378187378]
[null,270,-185,-0.65029376125433391,1.1950595952561934E-16,0.65029376125433391]
[null,280,-195,-0.6305349143831418,-0.10949123883800628,0.62095567222940695]
[null,290,-205,-0.59161758320447988,-0.2023451306015821,0.5559386772644429]
[null,300,-215,-0.53472425113309185,-0.26736212556654598,0.4630847855008674]
[null,310,-225,-0.46158359327455195,-0.296700214591473,0.35359354666286102]
[null,320,-235,-0.37441795150693308,-0.286820791155877,0.2406712200728722]
[null,330,-245,-0.27587580974740084,-0.23891545953085172,0.13793790487370053]
[null,340,-255,-0.16895132110858985,-0.15876230971777236,5.778475506062096E-2]
[null,350,-265,-5.6893332071388025E-2,-5.6028994518601029E-2,9.8794234355960558E-3]
[null,360,-275,5.6893332071387789E-2,5.6893332071387789E-2,-1.3940555576372759E-17]

{"sheet":"LOF Calcs","index":4,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Calculation worksheet for Loss of Field Relays"]
[]
["40-1",null,null,null,null,null,"40-2",null,"40-3"]
["Zone 2 Radius (RX)",{"$f":"Input!H26/2","v":21.3},"Dir Pt 1 ",{"$f":"((((2*B$6*B$5)))+(SQRT((2*B$6*B$5)^2-4*(1+B$6^2)*(B$5^2-B$4^2))))/(2*(1+B$6^2))","v":18.836225519567133},null,null,"Center",{"$f":"((Input!H20/2)+Input!H19)/Input!H17","v":1.341458333333333},"Center",{"$f":"((Input!H23/2)+Input!H22)/Input!H17","v":0.7213194444444444}]
["Zone 2 Center (RX)",{"$f":"-(B4-Input!H25)","v":-16.8},"Dir Pt 2",{"$f":"((((2*B$6*B$5)))-(SQRT((2*B$6*B$5)^2-4*(1+B$6^2)*(B$5^2-B$4^2))))/(2*(1+B$6^2))","v":-8.0373936768332754},null,null,"Radius",{"$f":"(Input!H20/2)/Input!H17","v":1.1195138888888887},"Radius",{"$f":"(Input!H23/2)/Input!H17","v":0.49937500000000001}]
["Directional Slope",{"$f":"TAN(RADIANS(Input!H27))","v":-0.36397023426620234},"Rad 1",{"$f":"ACOS(D4/B$4)","v":0.48573973467714682}]
["Zone 2 Radius (RX)",{"$f":"B4/Input!H17","v":1.3904166666666666},"Rad 2",{"$f":"ACOS(D5/B$4)","v":1.9577212181149144}]
["Zone 2 Center (RX)",{"$f":"B5/Input!H17","v":-1.0966666666666667}]
[]
["R (per unit)","X (per unit)","R (ohms)","X (ohms)","Angle (Degrees)","Radians","R (per unit)","X (per unit)","R (per unit)","X (per unit)"]
[{"$f":"C11/Input!H$17","v":1.3904166666666666},{"$f":"D11/Input!H$17","v":-1.0966666666666667},{"$f":"B$4*COS(RADIANS(E11))","v":21.3},{"$f":"IF(AND(F11>$D$6,F11<$D$7),C11*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F11))","v":-16.8},0,{"$f":"E11*PI()/180","v":0},{"$f":"H$5*COS(RADIANS(E11))","v":1.1195138888888887},{"$f":"H$5*(SIN(RADIANS(E11)))-H$4","v":-1.341458333333333},{"$f":"J$5*COS(RADIANS(E11))","v":0.49937500000000001},{"$f":"J$5*(SIN(RADIANS(E11)))-J$4","v":-0.7213194444444444}]
[{"$f":"C12/Input!H$17","v":1.3692931132507242},{"$f":"D12/Input!H$17","v":-0.85522334630227226},20.976405139160033,{"$f":"IF(AND(F12>$D$6,F12<$D$7),C12*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F12))","v":-13.101293815694385},10,{"$f":"E12*PI()/180","v":0.17453292519943295},1.1025059573826252,-1.147056786654959,0.4917883716604714,-0.63460388572202109]
[{"$f":"C13/Input!H$17","v":1.3065642814844067},{"$f":"D13/Input!H$17","v":-0.62111615905093476},20.015452822739849,{"$f":"IF(AND(F13>$D$6,F13<$D$7),C13*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F13))","v":-9.5149709471632562},20,0.3490658503988659,1.0519989402562242,-0.95856203260047845,0.46925900250496305,-0.55052313537118858]
[{"$f":"C14/Input!H$17","v":1.2041361551786134},{"$f":"D14/Input!H$17","v":-0.43826971848876412},18.446341100608546,{"$f":"IF(AND(F14>$D$6,F14<$D$7),C14*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F14))","v":-6.7139190917427696},30,0.52359877559829882,0.96952746766728704,-0.78170138888888874,0.4324714360148541,-0.47163194444444445]
[{"$f":"C15/Input!H$17","v":1.0651209611200123},{"$f":"D15/Input!H$17","v":-0.38767232574069349},16.316746638434232,{"$f":"IF(AND(F15>$D$6,F15<$D$7),C15*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F15))","v":-5.9388100964531771},40,0.69813170079773179,0.85759739357785014,-0.62184867668356236,0.38254344378253968,-0.40032738185722888]
[{"$f":"C16/Input!H$17","v":0.89374260563499242},{"$f":"D16/Input!H$17","v":-0.32529570554665427},13.691376086323288,{"$f":"IF(AND(F16>$D$6,F16<$D$7),C16*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F16))","v":-4.9832533615657679},50,0.87266462599716477,0.71960965664977083,-0.48386093975548283,0.32099206258721558,-0.33877600066190472]
[{"$f":"C17/Input!H$17","v":0.69520833333333343},{"$f":"D17/Input!H$17","v":-0.25303513994714949},10.650000000000002,{"$f":"IF(AND(F17>$D$6,F17<$D$7),C17*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F17))","v":-3.8762829949350559},60,1.0471975511965976,0.55975694444444446,-0.37193086566604605,0.24968750000000006,-0.28884800842959035]
[{"$f":"C18/Input!H$17","v":0.47555050761573203},{"$f":"D18/Input!H$17","v":-0.17308622966230944},7.2850290528367463,{"$f":"IF(AND(F18>$D$6,F18<$D$7),C18*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F18))","v":-2.6515337309970808},70,1.2217304763960306,0.38289630073285458,-0.289459393077109,0.17079630907325588,-0.25206044193948141]
[{"$f":"C19/Input!H$17","v":0.2414433203643945},{"$f":"D19/Input!H$17","v":-8.7878181875038403E-2},3.6987061843056179,{"$f":"IF(AND(F19>$D$6,F19<$D$7),C19*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F19))","v":-1.3462189563835671},80,1.3962634015954636,0.19440154667837395,-0.23895237595070773,8.6715558722423383E-2,-0.229531072783973]
[{"$f":"C20/Input!H$17","v":8.5173341542293021E-17},{"$f":"D20/Input!H$17","v":-3.1000561074383652E-17},1.3047831044776803E-15,{"$f":"IF(AND(F20>$D$6,F20<$D$7),C20*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F20))","v":-4.7490221220332409E-16},90,1.5707963267948966,6.8578535561048121E-17,-0.22194444444444428,3.0590425483499608E-17,-0.22194444444444439]
[{"$f":"C21/Input!H$17","v":-0.24144332036439434},{"$f":"D21/Input!H$17","v":8.7878181875038347E-2},-3.6987061843056157,{"$f":"IF(AND(F21>$D$6,F21<$D$7),C21*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F21))","v":1.3462189563835663},100,1.7453292519943295,-0.19440154667837381,-0.23895237595070773,-8.6715558722423328E-2,-0.229531072783973]
[{"$f":"C22/Input!H$17","v":-0.47555050761573187},{"$f":"D22/Input!H$17","v":0.17308622966230938},-7.2850290528367436,{"$f":"IF(AND(F22>$D$6,F22<$D$7),C22*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F22))","v":2.6515337309970799},110,1.9198621771937625,-0.38289630073285447,-0.28945939307710877,-0.17079630907325583,-0.25206044193948135]
[{"$f":"C23/Input!H$17","v":-0.69520833333333298},{"$f":"D23/Input!H$17","v":0.1074694885119467},-10.649999999999995,{"$f":"IF(AND(F23>$D$6,F23<$D$7),C23*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F23))","v":1.6463411006085451},120,2.0943951023931953,-0.55975694444444413,-0.37193086566604594,-0.2496874999999999,-0.2888480084295903]
[{"$f":"C24/Input!H$17","v":-0.89374260563499242},{"$f":"D24/Input!H$17","v":-3.1545705546654354E-2},-13.691376086323288,{"$f":"IF(AND(F24>$D$6,F24<$D$7),C24*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F24))","v":-0.48325336156576881},130,2.2689280275926285,-0.71960965664977083,-0.48386093975548283,-0.32099206258721558,-0.33877600066190472]
[{"$f":"C25/Input!H$17","v":-1.0651209611200121},{"$f":"D25/Input!H$17","v":-0.20292406103167407},-16.316746638434228,{"$f":"IF(AND(F25>$D$6,F25<$D$7),C25*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F25))","v":-3.1086239136767091},140,2.4434609527920612,-0.85759739357785003,-0.62184867668356203,-0.38254344378253963,-0.40032738185722877]
[{"$f":"C26/Input!H$17","v":-1.2041361551786134},{"$f":"D26/Input!H$17","v":-0.40145833333333347},-18.446341100608546,{"$f":"IF(AND(F26>$D$6,F26<$D$7),C26*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F26))","v":-6.1500000000000021},150,2.6179938779914944,-0.96952746766728704,-0.78170138888888874,-0.4324714360148541,-0.47163194444444445]
[{"$f":"C27/Input!H$17","v":-1.3065642814844067},{"$f":"D27/Input!H$17","v":-0.62111615905093454},-20.015452822739849,{"$f":"IF(AND(F27>$D$6,F27<$D$7),C27*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F27))","v":-9.5149709471632526},160,2.7925268031909272,-1.051998940256224,-0.95856203260047834,-0.469259002504963,-0.55052313537118847]
[{"$f":"C28/Input!H$17","v":-1.3692931132507242},{"$f":"D28/Input!H$17","v":-0.85522334630227248},-20.976405139160033,{"$f":"IF(AND(F28>$D$6,F28<$D$7),C28*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F28))","v":-13.101293815694387},170,2.9670597283903604,-1.1025059573826252,-1.1470567866549592,-0.4917883716604714,-0.63460388572202109]
[{"$f":"C29/Input!H$17","v":-1.3904166666666666},{"$f":"D29/Input!H$17","v":-1.0966666666666665},-21.3,{"$f":"IF(AND(F29>$D$6,F29<$D$7),C29*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F29))","v":-16.799999999999997},180,3.1415926535897931,-1.1195138888888887,-1.3414583333333328,-0.49937500000000001,-0.72131944444444429]
[{"$f":"C30/Input!H$17","v":-1.3692931132507242},{"$f":"D30/Input!H$17","v":-1.3381099870310611},-20.976405139160033,{"$f":"IF(AND(F30>$D$6,F30<$D$7),C30*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F30))","v":-20.498706184305618},190,3.3161255787892263,-1.1025059573826252,-1.5358598800117069,-0.4917883716604714,-0.80803500316686783]
[{"$f":"C31/Input!H$17","v":-1.3065642814844067},{"$f":"D31/Input!H$17","v":-1.5722171742823985},-20.015452822739849,{"$f":"IF(AND(F31>$D$6,F31<$D$7),C31*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F31))","v":-24.085029052836745},200,3.4906585039886591,-1.0519989402562242,-1.7243546340661875,-0.46925900250496305,-0.89211575351770023]
[{"$f":"C32/Input!H$17","v":-1.2041361551786132},{"$f":"D32/Input!H$17","v":-1.7918750000000001},-18.446341100608542,{"$f":"IF(AND(F32>$D$6,F32<$D$7),C32*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F32))","v":-27.450000000000003},210,3.6651914291880923,-0.96952746766728692,-1.9012152777777773,-0.43247143601485405,-0.97100694444444446]
[{"$f":"C33/Input!H$17","v":-1.0651209611200123},{"$f":"D33/Input!H$17","v":-1.9904092723016589},-16.316746638434232,{"$f":"IF(AND(F33>$D$6,F33<$D$7),C33*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F33))","v":-30.491376086323285},220,3.839724354387525,-0.85759739357785014,-2.0610679899831035,-0.38254344378253968,-1.04231150703166]
[{"$f":"C34/Input!H$17","v":-0.89374260563499264},{"$f":"D34/Input!H$17","v":-2.1617876277866785},-13.691376086323292,{"$f":"IF(AND(F34>$D$6,F34<$D$7),C34*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F34))","v":-33.116746638434229},230,4.0142572795869578,-0.71960965664977095,-2.1990557269111832,-0.32099206258721563,-1.1038628882269841]
[{"$f":"C35/Input!H$17","v":-0.69520833333333387},{"$f":"D35/Input!H$17","v":-2.3008028218452794},-10.650000000000009,{"$f":"IF(AND(F35>$D$6,F35<$D$7),C35*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F35))","v":-35.246341100608539},240,4.1887902047863905,-0.55975694444444479,-2.3109858010006197,-0.24968750000000023,-1.1537908804592982]
[{"$f":"C36/Input!H$17","v":-0.47555050761573164},{"$f":"D36/Input!H$17","v":-2.403230948151073},-7.2850290528367401,{"$f":"IF(AND(F36>$D$6,F36<$D$7),C36*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F36))","v":-36.815452822739843},250,4.3633231299858233,-0.3828963007328543,-2.393457273589557,-0.17079630907325574,-1.1905784469494074]
[{"$f":"C37/Input!H$17","v":-0.24144332036439436},{"$f":"D37/Input!H$17","v":-2.4659597799173909},-3.6987061843056162,{"$f":"IF(AND(F37>$D$6,F37<$D$7),C37*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F37))","v":-37.776405139160033},260,4.5378560551852569,-0.19440154667837384,-2.4439642907159582,-8.6715558722423342E-2,-1.2131078161049158]
[{"$f":"C38/Input!H$17","v":-2.5552002462687905E-16},{"$f":"D38/Input!H$17","v":-2.4870833333333331},-3.9143493134330409E-15,{"$f":"IF(AND(F38>$D$6,F38<$D$7),C38*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F38))","v":-38.1},270,4.7123889803846897,-2.0573560668314436E-16,-2.4609722222222219,-9.1771276450498825E-17,-1.2206944444444443]
[{"$f":"C39/Input!H$17","v":0.24144332036439389},{"$f":"D39/Input!H$17","v":-2.4659597799173909},3.6987061843056086,{"$f":"IF(AND(F39>$D$6,F39<$D$7),C39*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F39))","v":-37.776405139160033},280,4.8869219055841224,0.19440154667837345,-2.4439642907159582,8.6715558722423161E-2,-1.2131078161049158]
[{"$f":"C40/Input!H$17","v":0.47555050761573225},{"$f":"D40/Input!H$17","v":-2.4032309481510739},7.2850290528367498,{"$f":"IF(AND(F40>$D$6,F40<$D$7),C40*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F40))","v":-36.815452822739857},290,5.0614548307835552,0.3828963007328548,-2.393457273589557,0.17079630907325596,-1.1905784469494074]
[{"$f":"C41/Input!H$17","v":0.69520833333333343},{"$f":"D41/Input!H$17","v":-2.3008028218452798},10.650000000000002,{"$f":"IF(AND(F41>$D$6,F41<$D$7),C41*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F41))","v":-35.246341100608547},300,5.2359877559829888,0.55975694444444446,-2.3109858010006201,0.24968750000000006,-1.1537908804592985]
[{"$f":"C42/Input!H$17","v":0.8937426056349923},{"$f":"D42/Input!H$17","v":-2.161787627786679},13.691376086323286,{"$f":"IF(AND(F42>$D$6,F42<$D$7),C42*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F42))","v":-33.116746638434236},310,5.4105206811824216,0.71960965664977061,-2.1990557269111832,0.32099206258721552,-1.1038628882269841]
[{"$f":"C43/Input!H$17","v":1.0651209611200121},{"$f":"D43/Input!H$17","v":-1.9904092723016593},16.316746638434228,{"$f":"IF(AND(F43>$D$6,F43<$D$7),C43*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F43))","v":-30.491376086323292},320,5.5850536063818543,0.85759739357784992,-2.0610679899831039,0.38254344378253957,-1.04231150703166]
[{"$f":"C44/Input!H$17","v":1.2041361551786129},{"$f":"D44/Input!H$17","v":-1.7918750000000006},18.446341100608539,{"$f":"IF(AND(F44>$D$6,F44<$D$7),C44*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F44))","v":-27.45000000000001},330,5.7595865315812871,0.9695274676672867,-1.9012152777777778,0.43247143601485394,-0.97100694444444469]
[{"$f":"C45/Input!H$17","v":1.3065642814844067},{"$f":"D45/Input!H$17","v":-1.5722171742823983},20.015452822739849,{"$f":"IF(AND(F45>$D$6,F45<$D$7),C45*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F45))","v":-24.085029052836742},340,5.9341194567807207,1.0519989402562242,-1.7243546340661873,0.46925900250496305,-0.89211575351770023]
[{"$f":"C46/Input!H$17","v":1.3692931132507242},{"$f":"D46/Input!H$17","v":-1.3381099870310622},20.976405139160033,{"$f":"IF(AND(F46>$D$6,F46<$D$7),C46*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F46))","v":-20.498706184305636},350,6.1086523819801526,1.1025059573826252,-1.5358598800117069,0.4917883716604714,-0.80803500316686772]
[{"$f":"C47/Input!H$17","v":1.3904166666666666},{"$f":"D47/Input!H$17","v":-1.0966666666666669},21.3,{"$f":"IF(AND(F47>$D$6,F47<$D$7),C47*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F47))","v":-16.800000000000004},360,6.2831853071795862,1.1195138888888887,-1.3414583333333332,0.49937500000000001,-0.72131944444444451]
[{"$f":"C48/Input!H$17","v":1.3692931132507242},{"$f":"D48/Input!H$17","v":-0.85522334630227292},20.976405139160033,{"$f":"IF(AND(F48>$D$6,F48<$D$7),C48*TAN(Input!H$27*PI()/180),B$5+B$4*SIN(F48))","v":-13.101293815694394},370,6.457718232379019,1.1025059573826252,-1.1470567866549595,0.49178837166047146,-0.63460388572202131]

{"sheet":"Sheet1","index":5,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
["21-2","center","radius"]
[null,0,0.26]
[]
["Angle"]
[0,{"$f":"C$4*COS(RADIANS(A7))","v":0.26},{"$f":"C$4*SIN(RADIANS(A7))-0.17","v":-0.17}]
[30,{"$f":"C$4*COS(RADIANS(A8))","v":0.22516660498395408},{"$f":"C$4*SIN(RADIANS(A8))-0.17","v":-4.0000000000000036E-2}]
[60,0.13000000000000003,5.5166604983954037E-2]
[90,1.5926929913812061E-17,0.09]
[120,-0.12999999999999995,5.5166604983954065E-2]
[150,-0.22516660498395408,-4.0000000000000036E-2]
[180,-0.26,-0.16999999999999998]
[210,-0.22516660498395405,-0.30000000000000004]
[240,-0.13000000000000012,-0.39516660498395401]
[270,-4.7780789741436179E-17,-0.43000000000000005]
[300,0.13000000000000003,-0.39516660498395406]
[330,0.22516660498395399,-0.30000000000000016]
[360,0.26,-0.17000000000000007]
[]
[]
[]
[]
[]
["0.5 GE Method"]
[null,"Radius",0.41499999999999998,"Center",0.20749999999999999]
["Angle","R ","X"]
[0,{"$f":"C$26*COS(RADIANS(A28))","v":0.41499999999999998},{"$f":"C$26*SIN(RADIANS(A28))-0.2075","v":-0.20749999999999999}]
[30,{"$f":"C$26*COS(RADIANS(A29))","v":0.35940054257054205},{"$f":"C$26*SIN(RADIANS(A29))-0.2075","v":0}]
[60,0.20750000000000005,0.151900542570542]
[90,2.5421830439353865E-17,0.20749999999999999]
[120,-0.20749999999999991,0.15190054257054206]
[150,-0.35940054257054205,0]
[180,-0.41499999999999998,-0.20749999999999993]
[210,-0.35940054257054199,-0.41500000000000004]
[240,-0.20750000000000018,-0.5669005425705419]
[270,-7.6265491318061591E-17,-0.62249999999999994]
[300,0.20750000000000005,-0.56690054257054201]
[330,0.35940054257054188,-0.41500000000000015]
[360,0.41499999999999998,-0.2075000000000001]