{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["Intro","English","Metric","Best Mass","Class","Revisions"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":3,"defined_names":162,"comments":18,"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":"Intro","index":0,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[7,5,7,7]],"flags":["formulas_cached_only"]}
[]
[null,"EzAlt.xls"]
[null," ALTITUDE & VELOCITY PREDICTOR FOR AMATEUR ROCKETS"]
[]
[{"$nulls":5},"Written by:","Richard A.Nakka*"]
[{"$nulls":5},"Version:",1.1]
[{"$nulls":5},"Date:","Oct. 2005"]
[{"$nulls":5},"For free distribution"]
[{"$nulls":5},"* \"Best Mass\" worksheet written by Jorge Andres Serrano Ardila"]
[]
[null,"This spreadsheet predicts the peak altitude a rocket will achieve, based on user inputted"]
[null,"data describing the rocket, which consists of:"]
[null,"- Motor average thrust"]
[null,"- Motor total impulse"]
[null,"- Propellant mass"]
[null,"- Rocket empty mass"]
[null,"- Rocket maximum diameter"]
[null,"- Drag coefficient"]
[]
[null,"The spreadsheet also predicts: maximum velocity, acceleration, burnout altitude, and time to"]
[null,"peak altitude."]
[null,"This spreadsheet is meant to be very simple to use, with instant answers outputted on the same page."]
[null,"It is intended primarily for preliminary design work of an amateur rocket, when a quick and reasonably"]
[null,"accurate estimate of the flight performance is needed."]
[null,"As such, this spreadsheet is ideally suited to studying \"what if\" scenarios (what if drag is reduced,"]
[null,"what if mass is reduced, what if motor output or size is increased, etc.)"]
[]
[null,"For versatility, the analysis is performed using either English or Metric units of measure."]
[]
[null,"The \"Best Mass\" worksheet automatically determines the rocket mass that will result in the greatest"]
[null,"altitude (available in metric only)."]
[]
[null,"Note that this software is intended for predicting the flight performance of \"typical\" amateur rockets,"]
[null,"(see below) and as such, the results may not be valid for atypical configurations. Also, the validity"]
[null,"encompasses rockets that operate only within the subsonic flight regime. If the predicted maximum"]
[null,"velocity is greater than the speed of sound at sea level, a warning message is given."]
[]
[null,"The methodology utilized by this spreadsheet is novel in its approach to the solution of a rocket's"]
[null,"flight performance. The performance is calculated, using energy conservation methods, for the "]
[null,"condition of zero aerodynamic drag losses. This provides the ideal values for altitude, velocity, etc."]
[null,"A Drag Influence Number is then used to correlate the ideal data to actual (predicted) values based"]
[null,"on drag reduction factors which are applied to the ideal values."]
[null,"The Drag Influence Number (N) is defined as:"]
[]
[]
[]
[]
[null,"where Cd is the drag coefficient, D is the rocket diameter, Vbo is the burnout velocity for the "]
[null,"condition of zero drag, and mr is the rocket dead mass (1000 is used to reduce the number to a"]
[null,"more convenient magnitude)."]
[]
[null,"The drag reduction factors, which are derived functions of the Drag Influence Number, are applied to"]
[null,"the ideal values of peak altitude, maximum velocity, time to peak altitude, and burnout altitude."]
[null,"These factors were derived through an investigative analysis which involved running a large number of"]
[null,"flight simulations using a conventional flight simulation software. The flight simulations were based on"]
[null,"\"typical\" amateur sized rockets, in particular:"]
[]
[null,"Motor range:",null,"F to K   (50 to 2000 N-s.)"]
[null,"Rocket mass: ",null,"0.5 to 8 kg.  (1 to 18 lb.)"]
[null,"Rocket diameter:",null,"4 to 15 cm   (1.5 to 6 inch)"]
[]
[null,"For more complete details on the both the methodology and on the simulations that were run, visit:"]
[null,"Richard Nakka's Experimental Rocketry Website"]
[null,"http://www.nakka-rocketry.net"]

{"sheet":"English","index":1,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null," ALTITUDE & VELOCITY PREDICTOR FOR AMATEUR ROCKETS"]
[null,"(valid for subsonic rockets only)",{"$nulls":5},"EzAlt.xls","(MS Excel 97)"]
[{"$nulls":7},"Version:",1]
[null,"Instructions: Enter data in blue text (boxed cells).",{"$nulls":5},"Date:","Dec. 2002"]
[]
[null,null,null,"Title",null,"Test rocket"]
[null,null,null,"Motor average thrust","F =",100,"lb."]
[null,null,null,"Motor total impulse","It =",80,"lb-sec."]
[null,null,null,"Motor propellant weight","mp =",0.85,"lb.",null,"Input data"]
[null,null,null,"Rocket dead weight","mr =",6,"lb."]
[null,null,null,"Rocket diameter (max)","D =",2.5,"inch"]
[null,null,null,"Rocket drag coefficient","Cd =",0.4]
[]
[null,null,null,"Motor thrust time","t =",0.8,"sec."]
[null,null,null,"Motor classification",null,"I"]
[null,null,null,"Rocket avg. flight weight","mra =",6.425,"lb."]
[]
[null,null,null,"Acceleration","a =",500.85603112840465,"feet/sec2"]
[{"$nulls":4},"or   a =",15.56420233463035,"g's"]
[]
[null,null,null,"Peak altitude","z2 =",2334.261944919682,"feet"]
[null,null,null,"Time to peak altitude","t2 =",12.451361867704284,"sec.",null,"Ideal (no drag"]
[null,null,null,"Max velocity","v1 =",374.94082490272376,"feet/sec.",null,"resistance)"]
[null,null,null,"Burnout altitude","z1 =",149.97632996108953,"feet  "]
[]
[null,null,null," Drag Influence number","N =",77.40144956269437,"Out of valid range!"]
[null,null,null,"Peak altitude reduction factor","f1 =",0.8446513365779914]
[null,null,null,"Time to peak reduction factor","f2 =",0.8956046816274342,null,null,"Drag reduction factors"]
[null,null,null,"Max velocity reduction factor","f3 =",0.9908031321844782]
[null,null,null,"Burnout altitude reduction factor","f4 =",0.9966262135902921]
[]
[null,null,null,"Peak altitude","Z peak =",1971.637471699551,"feet"]
[null,null,null,"Time to peak altitude","t peak =",11.15149798135327,"sec.",null,"Predicted (with"]
[null,null,null,"Max velocity","V max =",371.49254369745074,"feet/sec.",null,"drag)"]
[{"$nulls":4},"or  V max =",253.2836162929219,"MPH"]
[null,null,null,"Burnout altitude","Z bo =",149.47034185728896,"feet "]
[null,null,null,""]

{"sheet":"Metric","index":2,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null," ALTITUDE & VELOCITY PREDICTOR FOR AMATEUR ROCKETS"]
[null,"(valid for subsonic rockets only)",{"$nulls":5},"EzAlt.xls","(MS Excel 97)"]
[{"$nulls":7},"Version:",1]
[null,"Instructions: Enter data in blue text (boxed cells).",{"$nulls":5},"Date:","Dec. 2002"]
[]
[null,null,null,"Title",null,"Test rocket"]
[null,null,null,"Motor average thrust","F =",500,"N."]
[null,null,null,"Motor total impulse","It =",1000,"N-sec."]
[null,null,null,"Motor propellant mass","mp =",0.8,"kg.",null,"Input data"]
[null,null,null,"Rocket dead mass","mr =",3.5,"kg."]
[null,null,null,"Rocket diameter (max)","D =",15,"cm."]
[null,null,null,"Rocket drag coefficient","Cd =",0.45]
[]
[null,null,null,"Motor thrust time","t =",2,"sec."]
[null,null,null,"Motor classification",null,"J"]
[null,null,null,"Rocket avg. flight mass","mra =",3.9,"kg."]
[]
[null,null,null,"Acceleration","a =",128.2051282051282,"metre/sec2"]
[{"$nulls":4},"or   a =",13.071485339022043,"g's"]
[]
[null,null,null,"Peak altitude","z2 =",3095.2526510312937,"metres"]
[null,null,null,"Time to peak altitude","t2 =",26.14297067804409,"sec.",null,"Ideal (no drag"]
[null,null,null,"Max velocity","v1 =",236.79425641025642,"metre/sec.",null,"resistance)"]
[null,null,null,"Burnout altitude","z1 =",236.79425641025642,"metres"]
[]
[null,null,null," Drag Influence number","N =",1622.0689676356385,"Out of valid range!"]
[null,null,null,"Peak altitude reduction factor","f1 =",0.25215375981126226]
[null,null,null,"Time to peak reduction factor","f2 =",0.4054633298448885,null,null,"Drag reduction factors"]
[null,null,null,"Max velocity reduction factor","f3 =",0.892812375190285]
[null,null,null,"Burnout altitude reduction factor","f4 =",0.9276266951984999]
[]
[null,null,null,"Peak altitude","Z peak =",780.4795935233176,"metres"]
[null,null,null,"Time to peak altitude","t peak =",10.60001594315704,"sec.",null,"Predicted (with"]
[null,null,null,"Max velocity","V max =",211.41284249705842,"metre/sec.",null,"drag)"]
[{"$nulls":4},"or  V max =",761.0862329894103,"km/hr"]
[null,null,null,"Burnout altitude","Z bo =",219.65667351583238,"metres"]
[null,null,null,""]

{"sheet":"Best Mass","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[5.999999999999997,780.4795935233176,null,null,"Directions: Enter range of values for rocket dead mass (min, max)"]
["Mass [kg]","Altitude [m]","m","alt","Minimum mass:",2,"kg"]
[2,616.0193673460518,616,2,"Maximum mass:",6,"kg"]
[2.1739130434782608,647.476644740955,647,2.1739130434782608,"Interval:",0.17391304347826086,"kg"]
[2.3478260869565215,675.7203243489176,675,2.3478260869565215,"Best mass:",3.7391304347826075,"kg"]
[2.5217391304347823,700.696298677693,700,2.5217391304347823,"Maximum altitude:",785.505236061774,"m"]
[2.695652173913043,722.3737739352583,722,2.695652173913043]
[2.8695652173913038,740.7502925401428,740,2.8695652173913038]
[3.0434782608695645,755.8547173470955,755,3.0434782608695645]
[3.2173913043478253,767.7483401125594,767,3.2173913043478253]
[3.391304347826086,776.5243071957059,776,3.391304347826086]
[3.565217391304347,782.3055989255278,782,3.565217391304347]
[3.7391304347826075,785.2418389587324,785,3.7391304347826075]
[3.9130434782608683,785.505236061774,785,3.9130434782608683]
[4.086956521739129,783.2859679891982,783,4.086956521739129]
[4.26086956521739,778.7873046465602,778,4.26086956521739]
[4.4347826086956506,772.2207378662918,772,4.4347826086956506]
[4.608695652173911,763.8013422991716,763,4.608695652173911]
[4.782608695652172,753.7435414854414,753,4.782608695652172]
[4.956521739130433,742.2574004463384,742,4.956521739130433]
[5.130434782608694,729.5455157192952,729,5.130434782608694]
[5.304347826086954,715.8005290829948,715,5.304347826086954]
[5.478260869565215,701.2032544188356,701,5.478260869565215]
[5.652173913043476,685.9213791489302,685,5.652173913043476]
[5.826086956521737,670.1086823883309,670,5.826086956521737]
[5.999999999999997,653.9047005384947,653,5.999999999999997]

{"sheet":"Class","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[7,2,7,4],[8,2,8,4],[6,1,6,5]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,"Rocket Motor Classification System"]
[null,"Class","Total Impulse"]
[null,null,"(Newton-seconds)"]
[null,"A",1.26,"-",2.5,"A"]
[null,"B",2.5,"-",5,"B"]
[null,"C",5,"-",10,"C"]
[null,"D",10,"-",20,"D"]
[null,"E",20,"-",40,"E"]
[null,"F",40,"-",80,"F"]
[null,"G",80,"-",160,"G"]
[null,"H",160,"-",320,"H"]
[null,"I",320,"-",640,"I"]
[null,"J",640,"-",1280,"J"]
[null,"K",1280,"-",2560,"K"]
[null,"L",2560,"-",5120,"L"]

{"sheet":"Revisions","index":5,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[null,"Record of Revisions"]
[]
["Version","Date","Worksheet","Changes"]
[1,"2002-12-20","All","Initial release"]
[1.1,"2005-10-01","Intro, Best Mass","Introduction revised; Best Mass worksheet added."]