Re: Mission Changed - Time to Sell My Q200
toggle quoted message Show quoted text
See what you are saying, Corbin. However, if you used the spreadsheet that I sent you a while back as a template, the initial weight and moment are calculated in the upper section and then the weight/moment history are computed incrementally from that initial value using the fuel burn rate and weight of a gallon, in the columns below. Just trying to clear up the confusion. Here is my spreadsheet snapshot similar to yours.
From: main@Q-List.groups.io <main@Q-List.groups.io> On Behalf Of Corbin via groups.io
Sent: Monday, August 8, 2022 4:57 PM
To: Q List <main@Q-List.groups.io>
Subject: Re: [Q-List] Mission Changed - Time to Sell My Q200
The answer is always in the formula and cell references. That formula is using fuel burn rate for the time component in the W/B. The header name of “Weight” is just through to baggage.
It is a relative reference for the fuel burn calculation below. He needs to look at the actual formula for the weight of the fuel further down in the W/B. For example, the first row shows 11 gallons of gas and 66 lbs which is the 10 gallons entered above in the cell he is looking at plus the 1 gallon of unusable fuel for a total of 11 gallons. The weight shows 66 lbs. The second row shows 10 gallons at 60 lbs and so on and so on. As time goes on (first column) the rate that fuel burns if 5 gallons per hour. This is how the total fuel in main decreases as time passes. The weight is updated by multiplying the gallons times 6lbs. If the relative reference, using fuel burn was not calculated then the time component in the first column would be inaccurate.
The screenshot shows what I am referring to quite easily.