Weight and Balance Calculator - Excel or Foreflight?

[byrdflyr]

Does anyone have a W&B Calculator set up for a 231 on Excel? I realize each needs to be customized based on the a/c's actual data.  Just looking for a good head start.  One thing I'm trying to do is calibrate against the default 252 Encore W&B profile in Foreflight. 

[MBDiagMan]

This Is a very easy spreadsheet to build in Excel.  I did one for my 140 years ago that has served me well.  If I didn’t have Foreflight at hand, I would have one ready to send you.  If you don’t want to build a spreadsheet, I fully expect there are multiple apps available.

[Hank]

I found a good spreadsheet that someone else made, complete with a loading graph and color-coding for both weight and CG. Just had to put in my empty weight and CG, and verify the seat stations listed in the TCDS. Just do some searches on the internet and see what you find.

[bill98]

10 hours ago, Hank said:

I found a good spreadsheet that someone else made, complete with a loading graph and color-coding for both weight and CG. Just had to put in my empty weight and CG, and verify the seat stations listed in the TCDS. Just do some searches on the internet and see what you find.

Can you share that with me pretty please ?

[jwilcoxon78]

I know it's not the true question but fltpln.com has a WTB function that's served me well. 

 

[Bob_Belville]

I am now using Garmin Pilot W&B. It's handy since I use the same app on the IPad for flight planning and filing. Once I set it up for my specific E it is very easy to input data for people, luggage, and fuel for instant graph that red flaps any problems. 

[jaylw314]

4 minutes ago, jwilcoxon78 said:

I know it's not the true question but fltpln.com has a WTB function that's served me well. 

 

and it's FREE!!!!

[jwilcoxon78]

1 minute ago, jaylw314 said:

and it's FREE!!!!

Now I'm curious to see how long it remains so.  Garmin and free don't mesh well!

[flight2000]

Here's one I used for my M20E.  Just change the numbers to match your 252 in the constant data tab (tab 2).  If nothing else, it's a good head start.

Brian

P.S.  ...making no claims that it will be correct once modified.  Please make sure you run some manual calculations to test the inputs before trusting the spreadsheet (or any app based calculator for that matter).

M20E W&B.xls

Edited January 30, 2019 by flight2000
Added the P.S. info....

[jaylw314]

23 minutes ago, jwilcoxon78 said:

Now I'm curious to see how long it remains so.  Garmin and free don't mesh well!

Gee, thanks for raining on my parade

[Bob_Belville]

28 minutes ago, jwilcoxon78 said:

Now I'm curious to see how long it remains so.  Garmin and free don't mesh well!

Hey, thread creep question, has anyone figured out how to import or sync trips planned in GP into FltPlan?

[Marauder]

Hey, thread creep question, has anyone figured out how to import or sync trips planned in GP into FltPlan?

I think you can only do it the other way around. You can create a FltPln trip and import it into GP.






Sent from my iPad using Tapatalk Pro

[ArtVandelay]

Gee, thanks for raining on my parade

No one is forcing you to upgrade. If they change, just keep the old version.


Tom

[Bob_Belville]

1 hour ago, Marauder said:

 

I think you can only do it the other way around. You can create a FltPln trip and import it into GP.






Sent from my iPad using Tapatalk Pro

 

Yeah, that's what I concluded. Perhaps that will be a future feature.

[midlifeflyer]

15 minutes ago, Bob_Belville said:

Yeah, that's what I concluded. Perhaps that will be a future feature.

Maybe. Garmin's Fltplan acquisition was the acquisition of the primary flight planning site for corporate aviation (and I think self-dispatched small Part 135). An enhancement to Garmin Pilot in response to ForeFlight targeting that market over the past two years or so. The other way makes a little less sense, although, in theory, it could be part of an effort to integrate online and tablet flight planning like ForeFlight (and FlyQ) have done.

[1964-M20E]

Here is the one I use.  I adapted it form one I found years ago.

 

I like Excel because I don't use fore flight.  If I know I'm going to be close on a flight I do the W&B before hand and verify I'm within limits.

 

 

M20F wtbal rev 0.zip