Looking for a graphical excel based W&B sheet for my mooney

[Houman]

Hi,

 

I have a very well done Excel W&B sheet for my previous plane ( Beech Sundowner ) that I got from a Beech Forum, and I'm looking to find somethig similar for the Mooney Rocket.

 

I know there are W&B excel sheet in the download center, but I was wondering if someone has something that not only shows the weight, but also shows where in CG will my flight start and finish ( Calculating the fuel from amount in tank to empty ).

 

Here is what I have for the Beech, unfortunetly I'm not that good with Excel to adapt it for the Mooney

I tried to attach the Excel file here, but it said that I don't have permission to upload this kind of file

 

Thanks for any help or advice

[WardHolbrook]

Why not use the one in "Tools" at Fltplan.com? 

 

If you guys aren't using fltplan.com for your flight planning you are missing out on probably the best deal in aviation. It's probably the single most useful aviation website out there and it's free.

[Mooneymite]

Why not use the one in "Tools" at Fltplan.com? 

 

If you guys aren't using fltplan.com for your flight planning you are missing out on probably the best deal in aviation. It's probably the single most useful aviation website out there and it's free.

 

+1

 

Yes, the graphical presentation inside the envelope for the entire flight is perfect.

 

Once you set it up, you can use it on-line, or off-line.

[kellym]

Hi,

 

I have a very well done Excel W&B sheet for my previous plane ( Beech Sundowner ) that I got from a Beech Forum, and I'm looking to find somethig similar for the Mooney Rocket.

 

I know there are W&B excel sheet in the download center, but I was wondering if someone has something that not only shows the weight, but also shows where in CG will my flight start and finish ( Calculating the fuel from amount in tank to empty ).

 

Here is what I have for the Beech, unfortunetly I'm not that good with Excel to adapt it for the Mooney

I tried to attach the Excel file here, but it said that I don't have permission to upload this kind of file

 

Thanks for any help or advice

W-B-Image.jpg

Roy Epperson authored a very good Excel spreadsheet for his F model. It was very easily modified for other Mooney models.

I just searched for his website, apparently gone, as he sold his Mooney a few years ago. Send me a PM at kellym at aviating.com and I can send you a copy.

[yvesg]

I have an Excel With graphic I adapted for my M20C at home. I'll post it when I am back home.

Yves

[donkaye]

Mooneyspace doesn't seem to accept Excel files for upload.  Email me at:  donkaye@earthlink.net and I will send you the file.  I adapted Roy Epperson's spreadsheet to the Rocket.  Just modify for your plane's empty weight and arm.

[1964-M20E]

Here you go set up for an F model.  You will need to review it and make sure it works for your plane.

 

When you download it change the.txt extension to .xls

W-B Mooney 2012-11-19.txt

[IndyTim]

I also use the W&B in Xavion. It's quick, and always ready to go on my iPad.

[mooniac15u]

Why not use the one in "Tools" at Fltplan.com? 

 

If you guys aren't using fltplan.com for your flight planning you are missing out on probably the best deal in aviation. It's probably the single most useful aviation website out there and it's free.

 

The W&B tool is good but no real advantage over a good spreadsheet.  In general the UI design on Fltplan.com is terrible.  It is very clunky to use and the pages are cluttered with extraneous information.

[WardHolbrook]

The W&B tool is good but no real advantage over a good spreadsheet.  In general the UI design on Fltplan.com is terrible.  It is very clunky to use and the pages are cluttered with extraneous information.

What you say about the UI is true, but its overall utility has made it the defacto standard for bizjet flight planning. It's all there, everything you would need, in one location. The "clunkyness" goes away with just a little experience using it.  

[Marauder]

Why not use the one in "Tools" at Fltplan.com?

If you guys aren't using fltplan.com for your flight planning you are missing out on probably the best deal in aviation. It's probably the single most useful aviation website out there and it's free.

Someone say "FREE"?

I have the fltplan app. If it weren't a bit clumsy on the download stuff, I would use it more.

Sent from my iPad using Tapatalk

[Marauder]

Here is a screen shot from Aviation W&B. Pick something that floats your boat. They all work...

Sent from my iPad using Tapatalk

[mooniac15u]

What you say about the UI is true, but its overall utility has made it the defacto standard for bizjet flight planning. It's all there, everything you would need, in one location. The "clunkyness" goes away with just a little experience using it.  

 

The clunkiness doesn't really go away.  You just develop a level of familiarity that allows you to derive enough value in spite of the clunkiness.  If I want to do a W&B calculation I have to navigate to the main page, login, click on tools, click on Weight & Balance, and then select my plane.  That's 5 steps before I can start entering numbers.  With a spreadsheet I just open it up and start entering.

 

You posed the question: "Why not use the one in "Tools" at Fltplan.com?"  At least one reason is that it isn't very user friendly.

 

I agree, there is lots of good information there.  I have had an account for a while now but I don't find myself using it much because of the interface.

[Marauder]

The clunkiness doesn't really go away. You just develop a level of familiarity that allows you to derive enough value in spite of the clunkiness. If I want to do a W&B calculation I have to navigate to the main page, login, click on tools, click on Weight & Balance, and then select my plane. That's 5 steps before I can start entering numbers. With a spreadsheet I just open it up and start entering.

You posed the question: "Why not use the one in "Tools" at Fltplan.com?" At least one reason is that it isn't very user friendly.

I agree, there is lots of good information there. I have had an account for a while now but I don't find myself using it much because of the interface.

I am not a big fan of the GUI either. The download pages drive me nuts. I find it sometimes deletes stuff that I thought I had downloaded. I also am not a big fan of doing setups on the website so I can use it on the app.

What I do like is the checklist page. Makes it nice to have the list available on the iPad.

Sent from my iPad using Tapatalk

[mooniac15u]

What I do like is the checklist page. Makes it nice to have the list available on the iPad.

 

 

Agreed!  The custom checklists are a nice feature.

[midlifeflyer]

Is this the kind of thing you are looking for? I've made one of these for every make/model I've flown until just about a year ago. 

 

 

[WardHolbrook]

I think it's basically just a matter of your personal SOP. I like the fact that I can go to the website and very quickly and easily come up with routing for the city pairs that we typically go too, down load all of the applicable winds, weather, notams, TFRs etc, notify the FBO(s) of our ETA and needs and finally send our passengers trip info sheets. I appreciate the computerized flight planning that is easy to "dial in" for your particular airplane(s). I don't care what you're flying, from a light single to the largest bizjet, the times and fuel burns are bang on. The accuracy and completeness of the information is great as well as the speed and ease at which you can put together a flight plan. I figure no more than 10 minutes per leg - regardless of the distance. I do a lot of non-stop, coast to coast flying and it seldom takes more than 10 minutes to put together, file and print everything out. Easy peasy and it's free. And then there are the checklists, W&B charts, IFR expected route. departure and arrival notifications, and several other neat and helpful tools.

 

Over the years, I've used just about every way to gather info and flight plan. The easiest is, of course, using services like Universal and the other $$$ flight planning services. For domestic US / Canada flight planning Fltplan.com is as good as any of the paid programs. You have to put up with some annoyances but then you're not having to shell out $$$ per flight plan either. But you're right, it's a bit clunky but they do periodically make improvements. Overall, it just a matter of spending some time playing around with it until it becomes part of your personal SOP.

 

I'd better stop while I'm ahead, I'm starting to sound like a Fltplan.com ad.   

[Marauder]

Since this thread has taken a left turn to intercept the hold at "hijacked" intersection, can some you of heavier iron guys explain to me what the ACAS is and what hardware it uses to transmit information? I like the concept of inflight PIREPS but I suspect there must be some sort of satellite communication hardware required.

 

 

Dear Pilots, As you know, Lockheed Martin has been on a mission to modernize and bring real innovation to online Flight Services. Two more big steps were taken with our May 15th 9.0 release and our June 30th 9.1 release. Recognizing that pilot safety is the top priority, we’re excited to announce inflight electronic PIREP submission along with many other enhancements and brand new capabilities not available elsewhere.

 

Inflight PIREP submission is the most recent component of our Flight Services Data Link strategy, building on the cockpit to ground communications capability we put in place for inflight Adverse Condition Alerting Service (ACAS) alerts and Surveillance-Enhanced Search and Rescue (SE-SAR). Every pilot knows the value of PIREPs. Our PIREP submission infrastructure lets you submit PIREPs without contacting Flight Service via radio, and Urgent PIREPs are immediately uplinked to other pilots registered for ACAS and flying in the same area. The first two vendors integrating with our PIREP submission infrastructure will be announced at AirVenture Oshkosh, with more coming right behind. Speaking of ACAS and SE-SAR, Garmin and DeLorme have joined the group of industry partners that have integrated with those services.

 

And, based on your feedback, we’ve improved the ACAS alert messages. The text and inflight satellite communications messages are easier to understand, and the email alerts now contain complete information about the adverse condition, including a graphic showing where it’s located along your route of flight. NextGen Briefings just keep getting better. We’ve added color-coded time tags for intersections with adverse conditions, letting you know if a condition is active when passing (red), within an hour of being active (orange), or an hour or more from being active (green).

 

We’ve also reorganized NOTAMs so that less frequently referenced NOTAMs (e.g., airports along the route of flight) are segregated into their own tab, and we’ve added filters to obstruction and Navaid NOTAMs to help you focus on the ones that are relevant to your flight. Plain text translation is now available for several more sections. Wondering what’s changed since your last briefing? Our Delta Briefing capability has you covered. If you received a standard briefing for a flight (online or via specialist), all subsequent online briefings contain an automatically inserted new section under Adverse Conditions called “Delta”. It contains all new or modified adverse conditions since your last standard briefing. Pilots can also email copies of their briefings to themselves and schedule a briefing to be generated and emailed at a specific time. All pilot interactions with the web portal have always been recorded. Now pilots can view and print the last 15 days of their transaction history on the website (see History under the Flight Planning & Briefing menu selection).

 

To support flight planning, we’ve implemented our Altitude Optimization tool. It checks two levels above and below the flight plan altitude and provides time and fuel burn estimates based on forecast winds and aircraft performance characteristics. The NavLog function is also available. You can get more details from the Announcements function in the web portal (automatically displays the first time you logon after a release, and always available under the Help menu selection). Try it out and let us know what you think! In the meantime, we’re busy working on another batch of capabilities we’ll be deploying in the fall.

 

Sent from my iPad using Tapatalk

[mooniac15u]

I think it's basically just a matter of your personal SOP. I like the fact that I can go to the website and very quickly and easily come up with routing for the city pairs that we typically go too, down load all of the applicable winds, weather, notams, TFRs etc, notify the FBO(s) of our ETA and needs and finally send our passengers trip info sheets. I appreciate the computerized flight planning that is easy to "dial in" for your particular airplane(s). I don't care what you're flying, from a light single to the largest bizjet, the times and fuel burns are bang on. The accuracy and completeness of the information is great as well as the speed and ease at which you can put together a flight plan. I figure no more than 10 minutes per leg - regardless of the distance. I do a lot of non-stop, coast to coast flying and it seldom takes more than 10 minutes to put together, file and print everything out. Easy peasy and it's free. And then there are the checklists, W&B charts, IFR expected route. departure and arrival notifications, and several other neat and helpful tools.

 

Over the years, I've used just about every way to gather info and flight plan. The easiest is, of course, using services like Universal and the other $$$ flight planning services. For domestic US / Canada flight planning Fltplan.com is as good as any of the paid programs. You have to put up with some annoyances but then you're not having to shell out $$$ per flight plan either. But you're right, it's a bit clunky but they do periodically make improvements. Overall, it just a matter of spending some time playing around with it until it becomes part of your personal SOP.

 

I'd better stop while I'm ahead, I'm starting to sound like a Fltplan.com ad.   

 

The type of flying you do makes a big difference in terms of needs.  If I need something from an FBO (e.g. rental car) I usually know many days ahead of time and I usually call ahead to arrange that.  I don't send any trip info to my passengers because they are in the next room.  The destinations where I usually fly don't have arrival procedures and I almost always get routed direct.  More often than not I prefer to fly VFR so I don't even file a flight plan.  I don't know what records they keep for fltplan.com but I still like to get a DUATS briefing and TFR check just as a CYA.

 

I can see why you might put up with some of the UI issues since you seem to use a lot more of the tools.  For me it doesn't offer enough value to make it worth the trouble.  It is unlikely to become part of my SOP any time soon.  Different tools for different needs.

[midlifeflyer]

I think it's basically just a matter of your personal SOP. I like the fact that I can go to the website and very quickly and easily come up with routing for the city pairs that we typically go too, down load all of the applicable winds, weather, notams, TFRs etc, notify the FBO(s) of our ETA and needs and finally send our passengers trip info sheets. I appreciate the computerized flight planning that is easy to "dial in" for your particular airplane(s). I don't care what you're flying, from a light single to the largest bizjet, the times and fuel burns are bang on. The accuracy and completeness of the information is great as well as the speed and ease at which you can put together a flight plan. I figure no more than 10 minutes per leg - regardless of the distance. I do a lot of non-stop, coast to coast flying and it seldom takes more than 10 minutes to put together, file and print everything out. Easy peasy and it's free. And then there are the checklists, W&B charts, IFR expected route. departure and arrival notifications, and several other neat and helpful tools.

 

Over the years, I've used just about every way to gather info and flight plan. The easiest is, of course, using services like Universal and the other $$$ flight planning services. For domestic US / Canada flight planning Fltplan.com is as good as any of the paid programs. You have to put up with some annoyances but then you're not having to shell out $$$ per flight plan either. But you're right, it's a bit clunky but they do periodically make improvements. Overall, it just a matter of spending some time playing around with it until it becomes part of your personal SOP.

 

I'd better stop while I'm ahead, I'm starting to sound like a Fltplan.com ad.   

There's a reason this site is the darling of Part 91 corporate and non-dispatched Part 135. You mentioned a few of them. For IFR it can't be beat, not even by the "newbie" real-route selection capability of apps like ForeFlight. I do most of my IFR cross country planning using it.

 

The FltPlan Go! app, OTOH, while I have it, it still leaves me a bit cold. And their checklists are something I can definitely do without, but that's just a personal bias against check-as-you-go electronic checklists (as opposed to "paper" checklists in electronic format).

[WardHolbrook]

There's a reason this site is the darling of Part 91 corporate and non-dispatched Part 135. You mentioned a few of them. For IFR it can't be beat, not even by the "newbie" real-route selection capability of apps like ForeFlight. I do most of my IFR cross country planning using it.

 

The FltPlan Go! app, OTOH, while I have it, it still leaves me a bit cold. And their checklists are something I can definitely do without, but that's just a personal bias against check-as-you-go electronic checklists (as opposed to "paper" checklists in electronic format).

I'm a new comer to the Fltplan.com party. Up until a year or so ago, when they closed down, I had been a 20+ year Flitesoft user. Circumstances forced me into looking for something else. I miss Flitesoft, it's capabilities and accuracy, once you got everything dialed in, were simply amazing. I turned to FP.com because that's what everybody else seemed to be using. It took me a couple of months to adjust my personal SOPs and get comfortable with everything, but now I completely understand why it's so popular among the IFR pros out there. I don't use all of the features. We use a program called Ultra-Nav for W&B and takeoff/landing performance calculations and old fashioned paper checklists (together with flows) for our normal procedures. All in all, it's pretty much what you are used to, but if it takes you an hour to plan a two hour cross country flight you could probably find a better way to do it.

[yvesg]

Here is mine as promised. Excel and a nice graphic to show where stuff is. Change the extension to .xls

 

Yves

M20C W and B Calculation.txt

[midlifeflyer]

Nice Yves. And for anyone interested, here's mine.

 

Similar instructions - save and change the extension to xlsx. Obviously, it's at your own risk and you really need to confirm the numbers including the CG window itself (move the graph aside to see those numbers) 

MooneyJWt&Bal.txt

[EDNR-Cruiser]

One of the many reason why I prefer self-made solutions is that you can add as much stuff as you want... - and I want much.
My Excel W&B for example does not only calculate the CG with take-off weight and dry tanks, it also calculates stall speeds and best glide based on TOW today plus contains some other useful information like the speeds chart, range and endurance based on fuel on board, etc.
Unfortunately this sheet mixes German and English language, so it might not be be very useful for you as is but it's easy to adapt and it might give you some ideas for your own sheets...
If you have any questions or if you are interested in the file, please send me a PM...