{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculation","Alpha Constants"],"not_rendered":{"charts":0,"images":1,"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":"Calculation","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,1,14,5],[11,1,12,5],[9,1,10,5]]}
[]
[null,"General properties"]
[null,"m1",45,"mm"]
[null,"e",45,"mm"]
[null,"m2",45,"mm"]
[]
[null,"Alpha Calculation"]
[null,null,"alpha=",{"$f":"alpha(C$3,C$5,C$4)","v":5.7727591250000003}]
[null,null,null,"=alpha(m1,m2,e)"]
[null,"Alpha can be calculated using the custom function \"alpha\" where the three arguments are m1, m2 and e"]
[]
[null,"The custom function is implemented in VBA (Alt+F11 to access) and uses the values tabulated on the sheet called \"Alpha Constants\""]
[]
[null,"This function is for information only. Don't use without verify the accuracy."]
[]
[null,"Nick Stevens. Tor Engineering Ltd. October 2017"]
[null,"www.tor-eng.com"]

{"sheet":"Alpha Constants","index":1,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"m1",45,"mm",null,null,null,{"$f":"H4+H5*$F$5+H6*$F$6+H7*$F$7+H8*$F$8+H9*$F$9+H10*$F$10+H11*$F$11+H12*$F$12+H13*$F$13+H14*$F$14+H15*$F$15","v":0.30853447500000009},{"$f":"I4+I5*$F$5+I6*$F$6+I7*$F$7+I8*$F$8+I9*$F$9+I10*$F$10+I11*$F$11+I12*$F$12+I13*$F$13+I14*$F$14+I15*$F$15","v":0.81639176437500005},5.7727591250000021,5.7999290000000014,-0.97494712500001413,24.08883708749994]
[null,"m2",45,"mm",null,null,null,"F1","F2","F3","F4","F5","F6"]
[null,"e",45,"mm",null,null,"constant",0.99477448000000002,1.04213142,8.1302830000000004,1.2456659999999999,-86.505200000000002,-226.979097]
[null,null,null,null,null,{"$f":"C2/(C2+C4)","v":0.5},"λ1",null,null,4.4882949999999999,39.333002999999998,478.58886999999999,1095.760732]
[null,"[Ref. SCI P207-95 Figure 2.16]",null,null,null,{"$f":"C3/(C2+C4)","v":0.5},"λ2",-2.4584850299999998,-0.85759182,-3.4412310000000002,-3.5803319999999998,79.430092000000002,-12.118677699999999]
[null,null,null,null,null,{"$f":"F5^2","v":0.25},"λ12",null,null,-16.699660999999999,-55.940604999999998,-935.10279400000002,-1848.467314]
[null,null,null,null,null,{"$f":"F6^2","v":0.25},"λ22",3.1549716800000001,1.1582806299999999,4.6576409999999999,40.544586000000002,-329.85473300000001,717.104423]
[null,"alpha",{"$f":"alpha(C2,C3,C4)","v":5.7727591250000003},null,null,{"$f":"F5*F6","v":0.25},"λ1λ2",null,null,-6.8025320000000002,-55.34357,-68.228566999999998,-264.30702400000001]
[null,null,null,null,null,{"$f":"F5^3","v":0.125},"λ13",null,null,8.7474740000000004,21.049462999999999,809.05616399999997,1369.007748]
[null,null,null,null,null,{"$f":"F6^3","v":0.125},"λ23",-2.23017434,-0.79910192000000002,-1.197675,-33.001767999999998,531.67295200000001,-2120.5160580000002]
[null,null,null,null,null,{"$f":"F5*(F6^2)","v":0.125},"λ1λ22",null,null,-1.2273590000000001,2.7924099999999998,252.193252,-69.105001999999999]
[null,null,null,null,null,{"$f":"(F5^2)*F6","v":0.125},"λ12λ2",null,null,8.3182170000000006,44.062493000000003,-44.242643999999999,195.69790499999999]
[null,null,null,null,null,{"$f":"F5^4","v":6.25E-2},"λ14",null,null,null,null,-254.65983700000001,-381.68578300000001]
[null,null,null,null,null,{"$f":"F6^4","v":6.25E-2},"λ24",0.52850211999999996,0.21398138999999999,null,null,-605.622885,2562.1467680000001]
[]
[null,null,null,null,null,null,"[Ref. SCI P207-95 Appendix III]"]