{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["WW  hawk","Sheet1"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":1,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"WW  hawk","index":0,"n_rows":36,"n_cols":23,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Klaus Scharnhorst EDF Theory",{"$nulls":6},"Spreadsheet implemented by R.Sharman 2011"]
["fan=",3631.681107549801,"mm^2","FSA=",2924.8227604920976,null,"mm^2",null,"figures given for example are from a West Wings Hawk EDF for fan size and fan swept area size",{"$nulls":6}," "]
["motor=",706.8583470577034,"mm^2",{"$nulls":5},"size of motor in EDF unit reducing total area to swept area"]
[]
["note: Figures in black are given or calculated and should not be over written",{"$nulls":8},"to use the spreadsheet for your example:"]
["note: figures in red are input values which can be changed.  ",{"$nulls":8}," first enter the size of the entry duct in square millimetres (this may be tricky as it is porbably an odd shape)"]
[{"$nulls":9}," next enter the diameter of the exit duct. As this is probably round this should be easy"]
["airspeed","W=",37,"m/sec","..or..",null,80.93918181818182,"mph",null," then enter the speed at which the model flies straight and level -- how do you know this? You will have to guess or measure"]
["air density","rho=",1.22521,"kg/m^3","..or..",null,1.2242914983507518,"oz/ft^3",null,"now…"]
["force","N=",3.59694310194,"oz","..or..",null,101.97153846844803,"g",null,"the spreadsheet calculates all remaining values - do not change black values"]
["fan","wemotec",2924.8227604920976,{"$nulls":6},"read the first panel from left to right to get values for dynamic thrust, power and motor "]
[null,"FSA ratio=",1.2537511843565632,{"$nulls":6},"read the second panel from right to left to get values for static thrust. "]
[null,"exhaust ratio=",0.8421052631578946]
[{"$nulls":9},"If you have a measured value of static thrust you can play around to find the flying speed, etc."]
[]
["Dynamic analysis","inlet diameter","inlet area","inlet speed","air mass input",null,"exit diameter","exit area","exit speed","air mass output",null,"speed delta","Mass flow/sec","Thrust","Power needed for flight",null,"System power gain","System power loss","Power of System","Efficiency of system",null,"motor efficiency","Required motor power"]
["variable","di","Ai","vi","Qi = Ai*vi",null,"de","Ae = pi*(d/2)^2","Ve = (Ai/Ae)*vi","Qe = Ae*ve",null,"dv = ve-vi","M=Qe*rho","T= M*dv","Pflight = T*vi",null,"Pgain = (M/2)*vi^2","Ploss = (M/2)*ve^2","Psys = Ploss-Pgain",null,null,"Emot","Pmot = Pfan/Emot"]
["units","mm","mm^2","m/sec","m3/sec",null,"mm","mm^2","m/s","m3/sec",null,"m/s","kg/sec","N","watt",null,"Watt","Watt","Watt","%",null,"%","Watt"]
[]
[null,68.32985738711768,3667,37,0.135679,null,56,2463.0086404143976,55.0866926626665,0.135679,null,18.0866926626665,0.16623526758999999,3.006646194596455,111.24590920006884,null,113.78804066535498,252.22409269894476,138.43605203358976,0.8035905933887542,null,0.85,162.86594356892914]
[]
["Static analysis","inlet diameter","inlet area","inlet speed","air mass input",null,"de","Ae = pi*(d/2)^2","exit speed","air mass output",null,"speed delta","Mass flow/sec","Thrust","Power needed for flight",null,"System power gain","System power loss","Power of System","Efficiency of system",null,"motor efficiency","Required motor power"]
["variable","di","Ai","vi","Qi= Ai*vi",null,"de","Ae","ve= ((2*Ploss)/(Ae*rho))^(1/3)","Qe=Ae*ve",null,"dv = ve","M=Qe*rho","T= M*dv","Pflight = T*vi",null,"Pgain = 0","Ploss = Psys-Pgain","Psys = Pmot*Emot","efficiency",null,"Emot","Pmot = (obs)"]
["units","mm","mm^2","m/sec","m3/sec",null,"mm","mm^2","m/s","m3/sec",null,"m/s","kg/sec","N","watt",null,"Watt","Watt","Watt","%",null,"Watt","Watt"]
[]
[null,68.32985738711768,3667,0,0,null,56,2463.0086404143976,45.10253071853749,0.11108792286431363,null,45.10253071853749,0.1361060339725857,6.138726578226853,0,null,0,138.43605203358976,138.43605203358976,0,null,0.85,162.86594356892914]
[]
["Summary"]
[null,"vi","Td","Ts","Psys",null,"Pmot"]
[null,0,0,0,0,null,0]
[null,10,0.22,0.448,2.7,null,3.2]
[null,20,0.878,1.794,21.9,null,25.7]
[null,30,1.997,4.036,73.8,null,86.8]
[null,40,3.514,7.175,174.9,null,205.8]
[null,50,5.491,11.21,341.6,null,401.9]
[null,60,7.906,16.143,590.3,null,694.5]

{"sheet":"Sheet1","index":1,"n_rows":23,"n_cols":23,"rows_kept":23,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Pete Dizz P1091"]
[]
["note: Figures in black are given or calculated and should not be over written"]
["note: figures in red are input values which can be changed.  "]
[null,null,33]
["airspeed","W=",37,"m/sec",null,null,80.93918181818182,"mph"]
["air density","rho=",1.22521,"kg/m^3",null,null,1.2242914983507518,"oz/ft^3"]
["force","N=",3.59694310194,"oz",null,null,101.97153846844803,"g"]
["fan","wemotec",2924.8227604920976]
[null,"FSA ratio=",1.018865156635549]
[null,"exhaust ratio=",0.8724489795918366]
[]
["Dynamic analysis","inlet diameter","inlet area","inlet speed","air mass input",null,"exit diameter","exit area","exit speed","air mass output",null,"speed delta","Mass flow/sec","Thrust","Power needed for flight",null,"System power gain","System power loss","Power of System","Efficiency of system",null,"motor efficiency","Required motor power"]
["variable","di","Ai","vi","Qi = Ai*vi",null,"de","Ae = pi*(d/2)^2","Ve = (Ai/Ae)*vi","Qe = Ae*ve",null,"dv = ve-vi","M=Qe*rho","T= M*dv","Pflight = T*vi",null,"Pgain = (M/2)*vi^2","Ploss = (M/2)*ve^2","Psys = Ploss-Pgain",null,null,"Emot","Pmot = Pfan/Emot"]
["units","mm","mm^2","m/sec","m3/sec",null,"mm","mm^2","m/s","m3/sec",null,"m/s","kg/sec","N","watt",null,"Watt","Watt","Watt","%",null,"%","Watt"]
[]
[null,61.597514911811054,2980,37,0.11026,null,57,2551.7586328783095,43.20941588257896,0.11026,null,6.209415882578959,0.1350916546,0.8388402656771109,31.0370898300531,null,92.4702375737,126.11168143807421,33.64144386437421,0.9225849507286136,null,0.85,39.57816925220495]
[]
["Static analysis","inlet diameter","inlet area","inlet speed","air mass input",null,"de","Ae = pi*(d/2)^2","exit speed","air mass output",null,"speed delta","Mass flow/sec","Thrust","Power needed for flight",null,"System power gain","System power loss","Power of System","Efficiency of system",null,"motor efficiency","Required motor power"]
["variable","di","Ai","vi","Qi= Ai*vi",null,"de","Ae","ve= ((2*Ploss)/(Ae*rho))^(1/3)","Qe=Ae*ve",null,"dv = ve","M=Qe*rho","T= M*dv","Pflight = T*vi",null,"Pgain = 0","Ploss = Psys-Pgain","Psys = Pmot*Emot","efficiency",null,"Emot","Pmot = (obs)"]
["units","mm","mm^2","m/sec","m3/sec",null,"mm","mm^2","m/s","m3/sec",null,"m/s","kg/sec","N","watt",null,"Watt","Watt","Watt","%",null,"Watt","Watt"]
[]
[null,61.597514911811054,2980,0,0,null,57,2551.7586328783095,27.815369431168683,0.07097810907268412,null,27.815369431168683,0.0869630890169433,2.4189104478818857,0,null,0,33.64144386437421,33.64144386437421,0,null,0.85,39.57816925220495]