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

{"sheet":"SYSTEM FORMULAE","index":0,"n_rows":15,"n_cols":53,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,4,1],[8,14,9,16],[0,0,0,16]]}
["Higher Maths: Wave Function question solver"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Units",null,"Form of solution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Original Expression",null,"cos","x","+",null,"sin","x",null,null,null,null,null,null,"ksin(x + a)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"enter coefficients of cos x and sin x, including negative sign where appropriate",null,null,null,null,null,null,null,null,null,null,null,null,"ksin(x – a)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kcos(x + a)",null,null,null,"degrees"]
[null,null,null,null,null,"kcosa=",{"$f":"IF(AI4>2,IF(D4=\"cos\",C4,G4),IF(D4=\"sin\",C4,G4))","v":0},null,null,"ksina=",{"$f":"IF(AI4=3,IF(D4=\"sin\",-1*C4,-1*G4),IF(AI4=1,IF(D4=\"cos\",C4,G4),IF(AI4=4,IF(D4=\"sin\",C4,G4),IF(D4=\"cos\",-1*C4,-1*G4))))","v":0},null,null,null,null,"kcos(x – a)",null,null,null,"radians"]
[]
[null,"Solution",null,null,"k","=",{"$f":"ROUND(SQRT(G7^2+K7^2),O11)","v":0},null,"a","=",{"$f":"CONCATENATE(H10,IF(BA3=1,\"°\",\"\"))","v":{"$error":"#DIV/0!"}},null,null,null,"Number of decimal places to round answer to"]
[null,null,null,null,null,{"$f":"IF(INT(G9)=G9,\"\",\"=\")","v":""},{"$f":"IF(INT(G9)=G9,\"\",CONCATENATE(\"√\",G7^2+K7^2))","v":""},{"$f":"IF(BA3=1,ROUND(IF(AND(K7>0,G7>0),K10,IF(AND(K7>0,G7<0),180-K10,IF(AND(K7<0,G7<0),180+K10,360-K10))),O11),ROUND(IF(AND(K7>0,G7>0),K10,IF(AND(K7>0,G7<0),PI()-K10,IF(AND(K7<0,G7<0),PI()+K10,2*PI()-K10))),O11))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"ABS(IF(BA3=2,ATAN(ABS(K7/G7)),DEGREES(ATAN(ABS(K7/G7)))))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Maximum:",{"$f":"IF(G10=\"\",G9,G10)","v":0},null,null,"when x =",{"$f":"CONCATENATE(ROUND(IF(BA3=1,IF(AI4=1,IF(H10<=90,90-H10,450-H10),IF(AI4=2,IF(H10<=270,90+H10,-270+H10),IF(AI4=3,360-H10,IF(AI4=4,H10,\"\")))),IF(AI4=1,IF(H10<=PI()/2,PI()/2-H10,5*PI()/2-H10),IF(AI4=2,IF(H10<=3*PI()/2,PI()/2+H10,-3*PI()/2+H10),IF(AI4=3,2*PI()-H10,IF(AI4=4,H10,\"\"))))),2),IF(BA3=1,\"°\",\"\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,"y-intercept",{"$f":"CONCATENATE(\"( 0 , \",C4,\" )\")","v":"( 0 ,  )"}]
[null,"Minimum:",{"$f":"CONCATENATE(\"–\",IF(G10=\"\",G9,G10))","v":"–0"},null,null,"when x =",{"$f":"CONCATENATE(ROUND(IF(BA3=1,IF(AI4=1,IF(H10<=270,270-H10,630-H10),IF(AI4=2,IF(H10<=90,270+H10,-90+H10),IF(AI4=3,IF(H10<=180,180-H10,540-H10),IF(AI4=4,IF(H10<=180,180+H10,-180+H10),\"\")))),IF(AI4=1,IF(H10<=3*PI()/2,3*PI()/2-H10,7*PI()/2-H10),IF(AI4=2,IF(H10<=PI()/2,3*PI()/2+H10,-PI()/2+H10),IF(AI4=3,IF(H10<=PI(),PI()-H10,3*PI()-H10),IF(AI4=4,IF(H10<=PI(),PI()+H10,-PI()+H10),\"\"))))),2),IF(BA3=1,\"°\",\"\"))","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"CONCATENATE(\"Roots \",IF(BA3=1,\"(1 d.p.)\",\"(2 d.p.)\"))","v":"Roots (1 d.p.)"},{"$f":"IF(BA3=1,CONCATENATE(ROUND(M14,1),\"° and \",ROUND(M14+180,1),\"°\"),CONCATENATE(ROUND(M14,2),\" and \",ROUND(M14+PI(),2)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BA3=1,IF(AI4=1,IF(H10<=180,180-H10,360-H10),IF(AI4=2,IF(H10<=180,H10,H10-180),IF(AI4=3,IF(H10<=90,90-H10,IF(H10<=270,270-H10,450-H10)),IF(AI4=4,IF(H10<=90,90+H10,IF(H10<=270,-90+H10,-270+H10)))))),IF(AI4=1,IF(H10<=PI(),PI()-H10,2*PI()-H10),IF(AI4=2,IF(H10<=PI(),H10,H10-PI()),IF(AI4=3,IF(H10<=PI()/2,PI()/2-H10,IF(H10<=3*PI()/2,3*PI()/2-H10,5*PI()/2-H10)),IF(AI4=4,IF(H10<=PI()/2,PI()/2+H10,IF(H10<=3*PI()/2,-PI()/2+H10,-3*PI()/2+H10)))))))","v":{"$error":"#DIV/0!"}}]
[null,"© Dynamic Maths Ltd, all rights reserved"]