뺽ؼ
MISSILES AND SPACE VEHICLES
1999 1ڡNo.1 1999



Excelƽʣķ

ժҪƽʣػнҪڡMicrosoft OfficeеExcelǿݴܣͨƽʣģ壬ػнƽʣķ㹤ϸExcelģĽƽʣģƹ̡
ʡƽػк
Residual Propellant Analysis and Calculation 
by Using Excel 
Yang Jianmin
(Beijing Institute of Astronautical Systems Engineering,100076)
AbstractResidual propellang analysis and calculation of launch vehicle is an important part in post -flight data analysis.This paper discusses the construction of residual propellant template in Excel format by using the powerful sheet processing and data processing function of Excel,and the residual propellant analysis and calculation by using the residual propellant template.The design process of construcing the residual propellant template is detailed.
Key WordsRemaining propellant mass,Launch vehicle,Post flight analysis,Computer,Software.
1ǰ
ƽʣػнҪڣǷܼܵҪֶΡ
ػƽԪаװƽʣҺλɸźŷѶ㡣ػйУƽҺλﵽĳѶλõҺʱͽźŷңϵͳңϵͳ¼Ѷ㷢źŵʱ䡣ͨѶӦݻԼźųʱƽʣɸźŷѶԵõɸƽʣӦʱ䣬ͨС˷Ԥⷢػʱƽʣлܷܷ
 Microsoft ExcelһɻĿƱԼͼ߰Դ޸ĹάάͼΣһϵҵѧ͹
ExcelƱܡݴܣԼͼܿɽΪӵػнͨһƽʣģ壬ػнƽʣķ㹤
2񲢽м
һƽʣģ壬8Ϣ1ΪѶϢΪַʽ2Ϊźųֵʱ䣻3ΪѶ෨ʵʾ룻4ΪѶҺλӦƽݻ5Ϊƽ¶ȣ6ΪӦѶҺλƽʣ7к͵8ΪѶ෨۾뼰ӦݻֵϢ(ͼ1)


ͼ1ƽʣ
2к͵3ϢBCΪѶϢңΪÿƽʣʵʰװλûв죬DƽݻǸʵʵķѶ෨ľ룬GHṩĲֵвֵõExcelṩԻعԤ⺯FORECASTͨúԽвֵ㡣D3Ԫ룺
IFB3FORECASTC3H3H4G3G4
ʹExcelIFʽΪ
IFLogicaltest valueiftruevalueiffalse
ΪLogicaltestΪ棬valueiftrueĲvalueiffalseĲˣD3ԪĺΪB3ԪΪգûӦѶңʱD3ԪΪգи÷ѶӦҺλݻļ㣬FORECASTC3H3H4G3G4C3ΪʵʷѶ෨ľ룬G3G4H3H4Ϊֵxy顣D3ԪD4D5ѶҺλݻļ㣬ͨExcelԶ书ɣÿԪ롣
ΪõӦѶƽҪ֪ƽ¶ȡE3Ԫƽ¶ȡE4E5ȵԪE3ԪһͨExcelԶ书ɡFΪƽF3Ԫݻ¶ȽƽĹʽ
IFB3=D3*(1.45815-E3*0.002 5
京ΪûӦѶҺλңF3ԪΪգD3ԪƽݻԼE3Ԫƽ¶ȣƽļ㣬F3ԪʾF4 F5ȵԪݿͨԶ书ɡ
3ͼС
ƽʣѶӦƽϺΪĵǴеõƽԼػʱƽʣнʱƽʣȲˣĹζԼõƽʣƽеõҪĶ
סCtrlţͬʱBFбBFѡBFСڡ롱˵ͼѡСԭǶ롱ѡͼеġXYɢͼS)ͼƽʣʱĶӦϵͼڹϡڹ˫ͼʹ䴦ڼ״̬ѡߣڡ롱˵еߣR)Ϊߡ
ԤҲƻعûع飬ͼʵǰģݵʣҺλңƽʣǷǳġңػʱ䣬ͨعػʱƽʣ
ѡĻϳͼ2ʾġߡԻ򡣵Իеġ͡ťڶԻеġԤ⣯ع͡Уѡкʵ͡ͼ2ʾĻعУֱѡСԡ͡ʽƽʣĻعͣɽԡع͡ʽعʾͼϡԡǼɷyaxbС˷ֱߣڷƽļ㡣ʽǼɷybc1xc2x2ʮc3x3++c6x6С˷ߡѡиʱָʽĽѡ2ߡʹöϣԽΪ׼ȷؼ㷢ػʱƽʣ


ͼ2ߡԻ
ڡߡԻġѡťѡСʾʽ(E)ͼʾߵͬʱعֱ߻ߵļ㹫ʽʾͼϡЩ߹ʽԼңⷢػʱ䣬㷢ػʱƽʣ
4ƽʣ
ƽʣ߼߹ʽͼ3C23Ԫңػʱ䣬ͼе߹ʽC25Ԫػʱƽļ㹫ʽ̡ڱʾУػʱƽʣΪ442 kg,ƽΪ199.59 kg/s


ͼ3ͼʣ
ĳһƽʣ㴦󣬿Excel༭˵еġƶƹػƽʣֱ滻GHݣƽʣļ㹤
5Ϊģļ
ͨѡвDeleteɾСźųʱ䡱Ѷ෨ʵʾ롱ƽ¶ȡݣԼC25ԪݣڼģнѶ෨۾뼰ӦݻGHݣļF)˵ѡΪA)ڡͣT)ѡģ塱ͣȻڡļģƣȡΪPROPRES(ͼ4)󰴡桱ƽʣģƹ̡


ͼ4ƽʣģ
6ʣģʹ
Ҫңƽʣʱֱӵʣģ壬£
ExcelڡļF)˵У½Nѡڡ½ԻеġáǩмҵPRORRESģ壬˫ģ弴ɴƽʣģ壻BӦλƽʣѶֵʱ䣬CӦλƽʣѶҺλʵݻB3C3Ԫֱ뷢Ѷ1ֵʱԼӦݻExcelңӦļ򿪣ճʽB,Cһ롣
E3Ԫƽ¶ȡʱѶӦƽʣϾʾFУͬʱʣͼԼعʽʾڱеͼϡʱC23Ԫ뷢ػʱ䣻C25ԪͼеĻعϵʱػʱƽʣʾC25ԪСΪʹƽʣĽĿģʱԽC25ԪĿɫ
ߵλ(ϵͳƲ100076)
ο
[1]־գ춫ȱ.ʹMicrosoft Excel 7 for Windows(95İ).ӹҵ磬1996.
[2]봺ɽ.Office 97ģExcelƪ.԰,1998(8):32
ոڣ1998-09-21
