{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["supported and tested functions","example setup sheet","formulasheet"],"not_rendered":{"charts":0,"images":1,"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":"supported and tested functions","index":0,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"Supported and Tested Functions"]
[null,null,null,null,null,"*,/,+,-,^"]
[]
[]
[]
[]
[null,null,1,"tested functions, Excel to Canvas"]
[null,null,"Input Units","Input Name","Input Value","Nothing in this column!!","Output Value","Excel form","Output Units","variables","Canvas form of equation"]
[null,null,"feet","theta",6.28,null,{"$f":"ABS(E15)","v":1},"absolute value",null,"[negativevalue]","abs((negativevalue))"]
[null,null,"lbm","negativevalue",-1,null,{"$f":"ACOS(E16)","v":0.78554916339974368},"acos",null,"[some_number]","acos((some_number))"]
[null,null,"mph","some_number",0.70699999999999996,null,{"$f":"ASIN(E16)","v":0.78524716339515288},"asin",null,"[some_number]","asin((some_number))"]
[null,null,null,"some_degrees",360,null,{"$f":"ATAN(E16)","v":0.6154085176292563},"atan",null,"[some_number]","atan((some_number))"]
[null,null,null,"some_exp",1,null,{"$f":"COS(E16)","v":0.76031396174443966},"cos"]
[null,null,null,"some_lnx",2.71,null,{"$f":"RADIANS(E17)","v":6.2831853071795862},"radians",null,"[some_degrees]","deg_to_rad((some_degrees))"]
[null,null,null,"some_log",10,null,{"$f":"EXP(E18)","v":2.7182818284590451},"exp ",null,"[some_exp]","e((some_exp))"]
[null,null,null,"some_hundred",100,null,{"$f":"LN(E19)","v":0.99694863489160956},"ln",null,"[some_lnx]","ln((some_lnx))"]
[null,null,null,"some_pi",{"$f":"2*PI()","v":6.2831853071795862},null,{"$f":"LOG(E20,10)","v":1},"log",null,"[some_log]","log((some_log),10)"]
[null,null,null,"some_radians",{"$f":"45*6.28/360","v":0.78500000000000003},null,{"$f":"PI()*E21","v":314.15926535897933},"Pi",null,"[some_hundred]","pi()*(some_hundred)"]
[null,null,null,"some_two",2,null,{"$f":"DEGREES(E22)","v":360},"deg",null,"[some_pi]","rad_to_deg((some_pi))"]
[null,null,null,null,null,null,{"$f":"_xlfn.SEC(E18)","v":1.8508157176809255},"sec",null,"[some_exp]","sec((some_exp))"]
[null,null,null,null,null,null,{"$f":"SIN(E23)","v":0.70682518110536596},"sin",null,"[some_radians]","sin((some_radians))"]
[null,null,null,null,null,null,{"$f":"SQRT(E24)","v":1.4142135623730951},"sqrt",null,"[some_two]","sqrt((some_two))"]
[null,null,null,null,null,null,{"$f":"TAN(E16)","v":0.85432569732917008},"tan",null,"[some_number]","tan((some_number))"]

{"sheet":"example setup sheet","index":1,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"Sample Sheet, copy cells to create a new problem, or copy entire sheet"]
[]
[]
[]
[]
[]
[null,null,1,"A vehicle of mass m=1000 lbm is undergoing a skidpad test, the turn radius is 25 feet, the vehicle velocity is 20 mph.  Calculate the lateral force in lbf applied to the vehicle."]
[null,null,"Input Units","Input Name","Input Value","Nothing in this column!!","Output Value","Output Names","Output Units","Variables","Equation"]
[null,null,"feet","turnradius",25,null,{"$f":"E16*5280/3600","v":29.333333333333332},"vel","feet per second"]
[null,null,"lbm","mass",1000,null,{"$f":"G14^2/E14","v":34.417777777777772},"accel","feet per sq second"]
[null,null,"mph","velocity",20,null,{"$f":"E15*G15/32.2","v":1068.8750862663903},"force","lbm","[turnradius][mass][velocity]","(mass)*(((velocity)*5280/3600)^2/(turnradius))/32.2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"click on this cell, then select the \"Get Formula\" button"]

{"sheet":"formulasheet","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Input Names","Inputs",null,"Outputs","Output Names"]
[null,null,null,null,null,null,null,null,"explicit equation creator"]
[null,null,null,null,null,{"$f":"D5^(D6-1)","v":2.1576692799745936},"I1",null,"test sheet: formulasheet"]
[null,null,"CompRatio",9,null,{"$f":"D5^F4+D5","v":123.53540300161102},"La",null,"input names: column C"]
[null,null,"K",1.35,null,{"$f":"1/F5+D6","v":1.3580948454912716},"something",null,"inputs values: column D"]
[null,null,null,null,"Final Equation",{"$f":"1-F6+D6","v":0.99190515450872851},"Efficiency",null,"output equation: below final equation"]
[null,null,null,null,"Eqn Chk",{"$f":"1-(1/((9)^((9)^((1.35)-1))+(9))+(1.35))+(1.35)","v":0.99190515450872851}]
[null,null,null,null,"Eqn String","1-(1/((CompRatio)^((CompRatio)^((K)-1))+(CompRatio))+(K))+(K)"]
[null,null,null,null,"Input String","[CompRatio][K]"]