Archive for the ‘ spreadsheet ’ Category

Historical data

I have in our svn by the way a OpenOffice.org spreadsheet about historical data about the basic design parameters for aircraft. There are just couple of aircraft currently in the list, but I will add more later and also you can help, you can send me more lines to the sheet, just take the sheet as a template and fill your lines and send it to me karoliina dot t dot salminen at gmail dot com. I will copy-paste your additions to the table. I am particularly interested in fast composite aircraft and not so interested in the parameters of tube and fabric aircraft or metal aircraft (except interesting ones, like RV). All data even for fabric and tube, is welcome of course, but I wanted to let you know what I am interested in the most.

Here is the spreadsheet in OpenOffice.org format:
WeightAndBasicParametersHistoricalStatistics.ods

Here is the current version of the spreadsheet in PDF-format for quick viewing:
WeightAndBasicParametersHistoricalStatistics.pdf

>Historical data

>I have in our svn by the way a OpenOffice.org spreadsheet about historical data about the basic design parameters for aircraft. There are just couple of aircraft currently in the list, but I will add more later and also you can help, you can send me more lines to the sheet, just take the sheet as a template and fill your lines and send it to me karoliina dot t dot salminen at gmail dot com. I will copy-paste your additions to the table. I am particularly interested in fast composite aircraft and not so interested in the parameters of tube and fabric aircraft or metal aircraft (except interesting ones, like RV). All data even for fabric and tube, is welcome of course, but I wanted to let you know what I am interested in the most.

Here is the spreadsheet in OpenOffice.org format:
WeightAndBasicParametersHistoricalStatistics.ods

Here is the current version of the spreadsheet in PDF-format for quick viewing:
WeightAndBasicParametersHistoricalStatistics.pdf

Will it climb?

I created new spreadsheet for calculating climb rate at sea level. I created it to investigate single engine situation in a quick way.

You can download it from here:
climbcalc.ods

WARNING! You have to know what input values you enter, otherwise the results will be bogus. For example the value of K depends on aspect ratio and e.

Will it climb?

I created new spreadsheet for calculating climb rate at sea level. I created it to investigate single engine situation in a quick way.

You can download it from here:
climbcalc.ods

WARNING! You have to know what input values you enter, otherwise the results will be bogus. For example the value of K depends on aspect ratio and e.

Aircraft range calculator

You can download it from here (it is in the katix.org gforge svn):
RangeCalculator.ods

Some calculated results:

Target range = 1500 nm
Fuel consumption = 31.5 liters/h (2 x Rotax 912ULS, with economy cruise power)


[kts] [h]  [l] [kg]
Speed Endurance required Fuel liters Fuel weight
100 15 472.47 335.45
110 13.64 429.52 304.96
120 12.5 393.73 279.55
130 11.54 363.44 258.04
140 10.71 337.48 239.61
150 10 314.98 223.64
160 9.38 295.29 209.66
170 8.82 277.92 197.33
180 8.33 262.48 186.36
190 7.89 248.67 176.56
200 7.5 236.24 167.73
210 7.14 224.99 159.74
220 6.82 214.76 152.48
230 6.52 205.42 145.85
240 6.25 196.86 139.77
250 6 188.99 134.18
260 5.77 181.72 129.02
270 5.56 174.99 124.24
280 5.36 168.74 119.81
290 5.17 162.92 115.67

Aircraft range calculator

You can download it from here (it is in the katix.org gforge svn):
RangeCalculator.ods

Some calculated results:

Target range = 1500 nm
Fuel consumption = 31.5 liters/h (2 x Rotax 912ULS, with economy cruise power)


[kts] [h]  [l] [kg]
Speed Endurance required Fuel liters Fuel weight
100 15 472.47 335.45
110 13.64 429.52 304.96
120 12.5 393.73 279.55
130 11.54 363.44 258.04
140 10.71 337.48 239.61
150 10 314.98 223.64
160 9.38 295.29 209.66
170 8.82 277.92 197.33
180 8.33 262.48 186.36
190 7.89 248.67 176.56
200 7.5 236.24 167.73
210 7.14 224.99 159.74
220 6.82 214.76 152.48
230 6.52 205.42 145.85
240 6.25 196.86 139.77
250 6 188.99 134.18
260 5.77 181.72 129.02
270 5.56 174.99 124.24
280 5.36 168.74 119.81
290 5.17 162.92 115.67