{"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"]
[]
[null,"Gas",null,null,"Chosen Gas Density",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 Dia (m)",null,"Volume at Launch",null,"Area",null,"Balloon (g)",null,"Payload (g)",null,"Burst Dia (m)",null,"Burst Volume (cu m)",null,"Burst Volume Ratio",null,"Burst height (m)"]
[1.41373,null,1.479442342773414,null,1.5697223049380866,null,1000,null,150,null,7.86,null,254.25310212724793,null,171.85739165111107,null,37253.10537515941]
[]
["Gross Lift",null,"Free Lift (Kg)",null,"Free Lift (N)",null,"Balloon Cd",null,"Ascent Rate (m/sec)",null,"Ascent Rate (m/min)",null,null,"Time to burst (min)",null,null,"Burst Height (ft)"]
[1.5184996206226322,null,0.3684996206226323,null,3.614981278308023,null,0.3,null,3.5694594986273094,null,214.16756991763856,null,null,173.9437272855347,null,null,122190.18563052286]
[]
[]
["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"]
[]
[]
[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]