{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","SYSTEM FORMULAE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Worksheet","index":0,"n_rows":12,"n_cols":34,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,1],[0,2,0,33],[1,0,1,1],[3,0,3,1],[5,0,5,1]]}
[null,null,{"$f":"CONCATENATE(\"Solve for k and a, where \",IF(B7=1,\"0 ≤ a < 360°\",IF(B7=2,\"0 ≤ a < 2π\",\"'a' is in either degrees or radians as indicated\")))","v":"Solve for k and a, where 'a' is in either degrees or radians as indicated"}]
["Variables",null,1,"deg","solve for 0 ≤ a <",null,null,null,"360°",null,null,null,null,2,"rad","solve for 0 ≤ a <",null,null,null,"2π",null,null,null,null,3,"deg","solve for 0 ≤ a <",null,null,null,"360°"]
["SHOW ANSWERS",false,null,"k","cos","a","=","–1","k","=",9.0549999999999997,"(√82)",null,null,"k","cos","a","=",9,"k","=",9.0549999999999997,"(√82)",null,null,"k","cos","a","=",6,"k","=",6.7080000000000002,"(√45)"]
["Coefficients",null,null,"k","sin","a","=",9,"a","=","96.34°",null,null,null,"k","sin","a","=","–1","a","=","6.173",null,null,null,"k","sin","a","=",3,"a","=","26.565°"]
["Maximum (absolute) value of left-hand side",10,null,null,null,null,null,null,null,null,83.659808254090095,null,null,null,null,null,null,null,null,null,null,0.11065722117389563,null,null,null,null,null,null,null,null,null,null,26.56505117707799]
["Units",null,4,"rad","solve for 0 ≤ a <",null,null,null,"2π",null,null,null,null,5,"rad","solve for 0 ≤ a <",null,null,null,"2π",null,null,null,null,6,"deg","solve for 0 ≤ a <",null,null,null,"360°"]
["Degrees",3,null,"k","cos","a","=",3,"k","=",9.4870000000000001,"(√90)",null,null,"k","cos","a","=",3,"k","=",7.6159999999999997,"(√58)",null,null,"k","cos","a","=","–6","k","=",6.3250000000000002,"(√40)"]
["Radians",null,null,"k","sin","a","=",9,"a","=","1.249",null,null,null,"k","sin","a","=",7,"a","=","1.166",null,null,null,"k","sin","a","=",2,"a","=","161.565°"]
["A mixture of degrees and radians",null,null,null,null,null,null,null,null,null,1.2490457723982544,null,null,null,null,null,null,null,null,null,null,1.1659045405098132,null,null,null,null,null,null,null,null,null,null,18.43494882292201]
["Answers",null,7,"rad","solve for 0 ≤ a <",null,null,null,"2π",null,null,null,null,8,"deg","solve for 0 ≤ a <",null,null,null,"360°",null,null,null,null,9,"deg","solve for 0 ≤ a <",null,null,null,"360°"]
["Number of decimal places to round answers to",3,null,"k","cos","a","=",8,"k","=",11.314,"(√128)",null,null,"k","cos","a","=","–3","k","=",6.7080000000000002,"(√45)",null,null,"k","cos","a","=",10,"k","=",14.141999999999999,"(√200)"]
[null,null,null,"k","sin","a","=",8,"a","=","0.785",null,null,null,"k","sin","a","=","–6","a","=","243.435°",null,null,null,"k","sin","a","=","–10","a","=","315°"]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":12,"n_cols":32,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[1,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"deg"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(B1=\"deg\",\"360°\",\"2π\")","v":"360°"},null,null,null,null,2,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"deg"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(M1=\"deg\",\"360°\",\"2π\")","v":"360°"},null,null,null,null,3,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"rad"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(X1=\"deg\",\"360°\",\"2π\")","v":"2π"}]
[null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":-8},"k","=",{"$f":"ROUND(SQRT(F3^2+F2^2),Worksheet!$B$11)","v":8.0619999999999994},{"$f":"IF(INT(I2)=I2,\"\",CONCATENATE(\"(√\",F3^2+F2^2,\")\"))","v":"(√65)"},null,null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":-1},"k","=",{"$f":"ROUND(SQRT(Q3^2+Q2^2),Worksheet!$B$11)","v":4.1230000000000002},{"$f":"IF(INT(T2)=T2,\"\",CONCATENATE(\"(√\",Q3^2+Q2^2,\")\"))","v":"(√17)"},null,null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":-8},"k","=",{"$f":"ROUND(SQRT(AB3^2+AB2^2),Worksheet!$B$11)","v":10.63},{"$f":"IF(INT(AE2)=AE2,\"\",CONCATENATE(\"(√\",AB3^2+AB2^2,\")\"))","v":"(√113)"}]
[null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":1},"a","=",{"$f":"CONCATENATE(IF(B1=\"deg\",ROUND(IF(AND(F3>0,F2>0),I4,IF(AND(F3>0,F2<0),180-I4,IF(AND(F3<0,F2<0),180+I4,360-I4))),Worksheet!$B$11),ROUND(IF(AND(F3>0,F2>0),I4,IF(AND(F3>0,F2<0),PI()-I4,IF(AND(F3<0,F2<0),PI()+I4,2*PI()-I4))),Worksheet!$B$11)),IF(B1=\"deg\",\"°\",\"\"))","v":"172.875°"},null,null,null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":-4},"a","=",{"$f":"CONCATENATE(IF(M1=\"deg\",ROUND(IF(AND(Q3>0,Q2>0),T4,IF(AND(Q3>0,Q2<0),180-T4,IF(AND(Q3<0,Q2<0),180+T4,360-T4))),Worksheet!$B$11),ROUND(IF(AND(Q3>0,Q2>0),T4,IF(AND(Q3>0,Q2<0),PI()-T4,IF(AND(Q3<0,Q2<0),PI()+T4,2*PI()-T4))),Worksheet!$B$11)),IF(M1=\"deg\",\"°\",\"\"))","v":"255.964°"},null,null,null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":-7},"a","=",{"$f":"CONCATENATE(IF(X1=\"deg\",ROUND(IF(AND(AB3>0,AB2>0),AE4,IF(AND(AB3>0,AB2<0),180-AE4,IF(AND(AB3<0,AB2<0),180+AE4,360-AE4))),Worksheet!$B$11),ROUND(IF(AND(AB3>0,AB2>0),AE4,IF(AND(AB3>0,AB2<0),PI()-AE4,IF(AND(AB3<0,AB2<0),PI()+AE4,2*PI()-AE4))),Worksheet!$B$11)),IF(X1=\"deg\",\"°\",\"\"))","v":"3.86"}]
[null,null,null,null,null,null,null,null,{"$f":"ABS(IF(B1=\"rad\",ATAN(ABS(F3/F2)),DEGREES(ATAN(ABS(F3/F2)))))","v":7.1250163489017977},null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(IF(M1=\"rad\",ATAN(ABS(Q3/Q2)),DEGREES(ATAN(ABS(Q3/Q2)))))","v":75.963756532073532},null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(IF(X1=\"rad\",ATAN(ABS(AB3/AB2)),DEGREES(ATAN(ABS(AB3/AB2)))))","v":0.71882999962162453}]
[4,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"rad"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(B5=\"deg\",\"360°\",\"2π\")","v":"2π"},null,null,null,null,5,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"rad"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(M5=\"deg\",\"360°\",\"2π\")","v":"2π"},null,null,null,null,6,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"deg"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(X5=\"deg\",\"360°\",\"2π\")","v":"360°"}]
[null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":10},"k","=",{"$f":"ROUND(SQRT(F7^2+F6^2),Worksheet!$B$11)","v":12.805999999999999},{"$f":"IF(INT(I6)=I6,\"\",CONCATENATE(\"(√\",F7^2+F6^2,\")\"))","v":"(√164)"},null,null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":2},"k","=",{"$f":"ROUND(SQRT(Q7^2+Q6^2),Worksheet!$B$11)","v":9.2200000000000006},{"$f":"IF(INT(T6)=T6,\"\",CONCATENATE(\"(√\",Q7^2+Q6^2,\")\"))","v":"(√85)"},null,null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":-1},"k","=",{"$f":"ROUND(SQRT(AB7^2+AB6^2),Worksheet!$B$11)","v":9.0549999999999997},{"$f":"IF(INT(AE6)=AE6,\"\",CONCATENATE(\"(√\",AB7^2+AB6^2,\")\"))","v":"(√82)"}]
[null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":8},"a","=",{"$f":"CONCATENATE(IF(B5=\"deg\",ROUND(IF(AND(F7>0,F6>0),I8,IF(AND(F7>0,F6<0),180-I8,IF(AND(F7<0,F6<0),180+I8,360-I8))),Worksheet!$B$11),ROUND(IF(AND(F7>0,F6>0),I8,IF(AND(F7>0,F6<0),PI()-I8,IF(AND(F7<0,F6<0),PI()+I8,2*PI()-I8))),Worksheet!$B$11)),IF(B5=\"deg\",\"°\",\"\"))","v":"0.675"},null,null,null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":9},"a","=",{"$f":"CONCATENATE(IF(M5=\"deg\",ROUND(IF(AND(Q7>0,Q6>0),T8,IF(AND(Q7>0,Q6<0),180-T8,IF(AND(Q7<0,Q6<0),180+T8,360-T8))),Worksheet!$B$11),ROUND(IF(AND(Q7>0,Q6>0),T8,IF(AND(Q7>0,Q6<0),PI()-T8,IF(AND(Q7<0,Q6<0),PI()+T8,2*PI()-T8))),Worksheet!$B$11)),IF(M5=\"deg\",\"°\",\"\"))","v":"1.352"},null,null,null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":9},"a","=",{"$f":"CONCATENATE(IF(X5=\"deg\",ROUND(IF(AND(AB7>0,AB6>0),AE8,IF(AND(AB7>0,AB6<0),180-AE8,IF(AND(AB7<0,AB6<0),180+AE8,360-AE8))),Worksheet!$B$11),ROUND(IF(AND(AB7>0,AB6>0),AE8,IF(AND(AB7>0,AB6<0),PI()-AE8,IF(AND(AB7<0,AB6<0),PI()+AE8,2*PI()-AE8))),Worksheet!$B$11)),IF(X5=\"deg\",\"°\",\"\"))","v":"96.34°"}]
[null,null,null,null,null,null,null,null,{"$f":"ABS(IF(B5=\"rad\",ATAN(ABS(F7/F6)),DEGREES(ATAN(ABS(F7/F6)))))","v":0.67474094222355274},null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(IF(M5=\"rad\",ATAN(ABS(Q7/Q6)),DEGREES(ATAN(ABS(Q7/Q6)))))","v":1.3521273809209546},null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(IF(X5=\"rad\",ATAN(ABS(AB7/AB6)),DEGREES(ATAN(ABS(AB7/AB6)))))","v":83.659808254090095}]
[7,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"rad"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(B9=\"deg\",\"360°\",\"2π\")","v":"2π"},null,null,null,null,8,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"rad"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(M9=\"deg\",\"360°\",\"2π\")","v":"2π"},null,null,null,null,9,{"$f":"IF(Worksheet!$B$7=1,\"deg\",IF(Worksheet!$B$8=2,\"rad\",CHOOSE(RANDBETWEEN(1,2),\"rad\",\"deg\")))","v":"rad"},"solve for 0 ≤ a <",null,null,null,{"$f":"IF(X9=\"deg\",\"360°\",\"2π\")","v":"2π"}]
[null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":-8},"k","=",{"$f":"ROUND(SQRT(F11^2+F10^2),Worksheet!$B$11)","v":8.9440000000000008},{"$f":"IF(INT(I10)=I10,\"\",CONCATENATE(\"(√\",F11^2+F10^2,\")\"))","v":"(√80)"},null,null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":7},"k","=",{"$f":"ROUND(SQRT(Q11^2+Q10^2),Worksheet!$B$11)","v":7.6159999999999997},{"$f":"IF(INT(T10)=T10,\"\",CONCATENATE(\"(√\",Q11^2+Q10^2,\")\"))","v":"(√58)"},null,null,"k","cos","a","=",{"$f":"RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)","v":6},"k","=",{"$f":"ROUND(SQRT(AB11^2+AB10^2),Worksheet!$B$11)","v":8.4849999999999994},{"$f":"IF(INT(AE10)=AE10,\"\",CONCATENATE(\"(√\",AB11^2+AB10^2,\")\"))","v":"(√72)"}]
[null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":4},"a","=",{"$f":"CONCATENATE(IF(B9=\"deg\",ROUND(IF(AND(F11>0,F10>0),I12,IF(AND(F11>0,F10<0),180-I12,IF(AND(F11<0,F10<0),180+I12,360-I12))),Worksheet!$B$11),ROUND(IF(AND(F11>0,F10>0),I12,IF(AND(F11>0,F10<0),PI()-I12,IF(AND(F11<0,F10<0),PI()+I12,2*PI()-I12))),Worksheet!$B$11)),IF(B9=\"deg\",\"°\",\"\"))","v":"2.678"},null,null,null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":-3},"a","=",{"$f":"CONCATENATE(IF(M9=\"deg\",ROUND(IF(AND(Q11>0,Q10>0),T12,IF(AND(Q11>0,Q10<0),180-T12,IF(AND(Q11<0,Q10<0),180+T12,360-T12))),Worksheet!$B$11),ROUND(IF(AND(Q11>0,Q10>0),T12,IF(AND(Q11>0,Q10<0),PI()-T12,IF(AND(Q11<0,Q10<0),PI()+T12,2*PI()-T12))),Worksheet!$B$11)),IF(M9=\"deg\",\"°\",\"\"))","v":"5.878"},null,null,null,"k","sin","a","=",{"$f":"RANDBETWEEN(1,Worksheet!$B$5)*(-1)^RANDBETWEEN(1,2)","v":6},"a","=",{"$f":"CONCATENATE(IF(X9=\"deg\",ROUND(IF(AND(AB11>0,AB10>0),AE12,IF(AND(AB11>0,AB10<0),180-AE12,IF(AND(AB11<0,AB10<0),180+AE12,360-AE12))),Worksheet!$B$11),ROUND(IF(AND(AB11>0,AB10>0),AE12,IF(AND(AB11>0,AB10<0),PI()-AE12,IF(AND(AB11<0,AB10<0),PI()+AE12,2*PI()-AE12))),Worksheet!$B$11)),IF(X9=\"deg\",\"°\",\"\"))","v":"0.785"}]
[null,null,null,null,null,null,null,null,{"$f":"ABS(IF(B9=\"rad\",ATAN(ABS(F11/F10)),DEGREES(ATAN(ABS(F11/F10)))))","v":0.46364760900080609},null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(IF(M9=\"rad\",ATAN(ABS(Q11/Q10)),DEGREES(ATAN(ABS(Q11/Q10)))))","v":0.40489178628508338},null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(IF(X9=\"rad\",ATAN(ABS(AB11/AB10)),DEGREES(ATAN(ABS(AB11/AB10)))))","v":0.78539816339744828}]