|
Re: Mission Changed - Time to Sell My Q200
Jay,
Please use defined names and named ranges when building your spreadsheets and formulas. It is soooo much easier to follow a spreadsheet formula that reads “=MainTankUseableFuel+1” than it
Jay,
Please use defined names and named ranges when building your spreadsheets and formulas. It is soooo much easier to follow a spreadsheet formula that reads “=MainTankUseableFuel+1” than it
|
By
David J. Gall
·
#55461
·
|
|
Re: Mission Changed - Time to Sell My Q200
smh
Corbin
--
Corbin
N121CG
smh
Corbin
--
Corbin
N121CG
|
By
Corbin <c_geiser@...>
·
#55460
·
|
|
Re: Mission Changed - Time to Sell My Q200
I built the original spreadsheet template, including the columns below that you are referencing, which I am well aware of. Details can be trivial, as in this case, but not always and it is important
I built the original spreadsheet template, including the columns below that you are referencing, which I am well aware of. Details can be trivial, as in this case, but not always and it is important
|
By
Jay Scheevel
·
#55459
·
|
|
Re: Mission Changed - Time to Sell My Q200
Well, remember that I pointed out that "Weight" stops at "baggage". It is clearly not using 5lbs but I guess nobody looks at the actual data in the table. Scary.
Corbin
N121CG
Well, remember that I pointed out that "Weight" stops at "baggage". It is clearly not using 5lbs but I guess nobody looks at the actual data in the table. Scary.
Corbin
N121CG
|
By
Corbin <c_geiser@...>
·
#55458
·
|
|
Re: Mission Changed - Time to Sell My Q200
No need to belabor it further, but the upper section is a summary of weights and moments. There is a weight column, an arm column and a moment column, etc. for each item: pilot, passenger, baggage,
No need to belabor it further, but the upper section is a summary of weights and moments. There is a weight column, an arm column and a moment column, etc. for each item: pilot, passenger, baggage,
|
By
Jay Scheevel
·
#55457
·
|
|
Re: Mission Changed - Time to Sell My Q200
See the screenshot sent earlier and included again below.
--
Corbin
N121CG
See the screenshot sent earlier and included again below.
--
Corbin
N121CG
|
By
Corbin <c_geiser@...>
·
#55456
·
|
|
Re: Mission Changed - Time to Sell My Q200
That is the fuel burn rate. Not the weight. You need to look at the actual formula and weights down below. The fuel burn rate is 5 gallons per hour. That is not the weight. Look at the actual W/B
That is the fuel burn rate. Not the weight. You need to look at the actual formula and weights down below. The fuel burn rate is 5 gallons per hour. That is not the weight. Look at the actual W/B
|
By
Corbin <c_geiser@...>
·
#55455
·
|
|
Re: Mission Changed - Time to Sell My Q200
This is the spreadsheet you originally sent. I have highlighted cell column4/row8. The colors show which cells are reference in the formula. You can see the value is multiplying fuel volume by fuel
This is the spreadsheet you originally sent. I have highlighted cell column4/row8. The colors show which cells are reference in the formula. You can see the value is multiplying fuel volume by fuel
|
By
Jay Scheevel
·
#55454
·
|
|
Re: Mission Changed - Time to Sell My Q200
Main gallonsMain pounds11.066.010.060.09.054.08.048.07.042.06.036.05.030.04.024.03.018.02.012.02.012.02.012.0--
Corbin
N121CG
Main gallonsMain pounds11.066.010.060.09.054.08.048.07.042.06.036.05.030.04.024.03.018.02.012.02.012.02.012.0--
Corbin
N121CG
|
By
Corbin <c_geiser@...>
·
#55453
·
|
|
Re: Mission Changed - Time to Sell My Q200
Can you screenshot the formula you are referring to? I am not showing where it is using 5lbs for fuel weight.
--
Corbin
N121CG
Can you screenshot the formula you are referring to? I am not showing where it is using 5lbs for fuel weight.
--
Corbin
N121CG
|
By
Corbin <c_geiser@...>
·
#55452
·
|
|
Re: Mission Changed - Time to Sell My Q200
Ok, but if you check your spreadsheet formula in your column 4, you will find that it is multiplying the tank volume in gallons by the “fuel burn” to determine fuel weight. This is not right. If
Ok, but if you check your spreadsheet formula in your column 4, you will find that it is multiplying the tank volume in gallons by the “fuel burn” to determine fuel weight. This is not right. If
|
By
Jay Scheevel
·
#55451
·
|
|
Re: Mission Changed - Time to Sell My Q200
I am using the one the builder(s) created specific to my plane. I think Chris is the one confused, not me. :)
Corbin
--
Corbin
N121CG
I am using the one the builder(s) created specific to my plane. I think Chris is the one confused, not me. :)
Corbin
--
Corbin
N121CG
|
By
Corbin <c_geiser@...>
·
#55450
·
|
|
Re: Mission Changed - Time to Sell My Q200
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
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
|
By
Jay Scheevel
·
#55449
·
|
|
Re: 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
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
|
By
Corbin <c_geiser@...>
·
#55448
·
|
|
Re: Mission Changed - Time to Sell My Q200
Hi Corbin,
I think Chris is looking at the results of the formula in column 4 (starting condition moment calculation), where it apparently multiplies the fuel quantity in gallons by the weight per
Hi Corbin,
I think Chris is looking at the results of the formula in column 4 (starting condition moment calculation), where it apparently multiplies the fuel quantity in gallons by the weight per
|
By
Jay Scheevel
·
#55447
·
|
|
Re: Mission Changed - Time to Sell My Q200
Chris,
Look at the formula itself in the W/B. 6 lbs is used for a gallon of gas. See screenshot below.
--
Corbin
N121CG
Chris,
Look at the formula itself in the W/B. 6 lbs is used for a gallon of gas. See screenshot below.
--
Corbin
N121CG
|
By
Corbin <c_geiser@...>
·
#55446
·
|
|
Re: Mission Changed - Time to Sell My Q200
Corbin ------ I may be missing something. I see the fuel burn at 5 GPH
In the W&B it says column 3 fuel main 10 gallons column 4 says 50lbs
Next down for the header it says column 3
Corbin ------ I may be missing something. I see the fuel burn at 5 GPH
In the W&B it says column 3 fuel main 10 gallons column 4 says 50lbs
Next down for the header it says column 3
|
By
Chris Walterson
·
#55445
·
|
|
Re: Terra radio
Does anyone have a Terra TX 760D com you will part with? When I asked last year it seems there were a few on this list that had one or two.
I also have two Navaid autopilot heads if anyone needs a
Does anyone have a Terra TX 760D com you will part with? When I asked last year it seems there were a few on this list that had one or two.
I also have two Navaid autopilot heads if anyone needs a
|
By
Jim Patillo
·
#55444
·
|
|
Re: Terra radio
Adam, I'm not sure what it is worth at the moment as we moved 2-1/2 years ago and some things are still in boxes; I cant seem to find the mounting tray at the moment, sigh.
Mike
Adam, I'm not sure what it is worth at the moment as we moved 2-1/2 years ago and some things are still in boxes; I cant seem to find the mounting tray at the moment, sigh.
Mike
|
By
Mike Bergen
·
#55443
·
|
|
Re: OSH reports?
Thanks Mike and Keith,
I appreciate your OSH summaries and personal observations that you both sent. I hope to be there next year and experience it with all of the Q folks that come. Glad the weather
Thanks Mike and Keith,
I appreciate your OSH summaries and personal observations that you both sent. I hope to be there next year and experience it with all of the Q folks that come. Glad the weather
|
By
Jay Scheevel
·
#55442
·
|