{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Balloon Burst Estimator"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"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":"Balloon Burst Estimator","index":0,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,null,"Totex Balloon Burst Estimator – by Steve Randall"]
[]
[null,"Gas",null,null,"Chosen Gas Density(Kg/cu m)",null,null,"Air density at 0C,101 kPa",null,null,"Air Density Model",null,null,null,"Gas","density"]
[null,"Helium",null,null,0.1786,null,null,1.205,null,null,7238.3,null,null,null,"Hydrogen",0.0899,"at 0C,101 kPa"]
[{"$nulls":14},"Helium",0.1786,"at 0C,101 kPa"]
[]
["Launch Vol (cu m)",null,"Launch Dia (m)",null,"Area (sq  m)",null,"Balloon (g)",null,"Payload (g)",null,"Burst Dia (m)",null,"Burst Volume (cu m)",null,"Burst Volume Ratio",null,"Burst height (m)"]
[7,null,2.373375596579243,null,4.4240785213826666,null,3000,null,2800,null,13,null,1150.3465099894624,null,164.33521571278035,null,36929.14313706473]
[]
["Gross Lift(Kg)",null,"Free Lift (Kg)",null,"Free Lift (N)",null,"Balloon Cd",null,"Ascent Rate (m/sec)",null,"Ascent rate (ft/min)",null,"Neutral Lift Kg",null,"Time to burst (min)",null,"Burst Height (ft)"]
[7.1848,null,1.3848000000000003,null,13.584888000000003,null,0.25,null,4.5151074276609755,null,888.57314176368,null,4.1848,null,136.31696007506238,null,121127.58948957232]
[]
[]
["Notes: "]
[null,"Fill in the green cells - results in yellow cells (Pink cells are intermediate calculations, Tan cells are constants)"]
[null,"Based on Kaymont Totex Sounding Balloon Data"]
[null,"Model tends to under estimate balloon burst for small balloons by upto 3.5% - and over estimate for big balloons by upto 3.5%"]
[null,"Air density model based on NRLMSISE Standard Atmosphere Model - good to 80Km"]
[]
["Totex Balloon Data:"]
[null,"Balloon (g)",null,200,300,350,450,500,600,700,800,1000,1200,1500,2000,3000]
[null,"Burst dia (m)",null,3,3.78,4.12,4.72,4.99,6.02,6.53,7,7.86,8.63,9.44,10.54,13]
[null,"Cd",null,0.25,0.25,0.25,0.25,0.25,0.3,0.3,0.3,0.3,0.25,0.25,0.25,0.25]