Computerized weight and balance
 

Happy New Years to ALL.
Does anyone have a copy, and are willing to share, of a computerized W&B for a C337 with 4200 gross weight? We in the Civil Air Patrol use a W&B that you simple "plug-in" the values and the computer does the actual calculations. I've seen similar programs on the internet, but some are quite costly.
Thanks, BILLS bstory@pa.rr.com

I use EXCEL which is simply a spreadsheet on the computer. Takes very little time to set up. If you have access to any type of computer spreadsheet software, you can make one. Simply use the W&B data supplied by your manual and once that is set up, you simply need to plug in your weights and at what stations for a particular flight and presto, the computer will spit out what you are looking for.

Good Luck,

Ed

Computerized weight and balance
 

Thanks Ed. A member, Gord, just sent me the Excel W&B program. Appreciate it though.
BILLS

BILLS;
Any chance you could attach that spreadsheet in a post? I also fly a 4200lb bird and am pretty much useless creating spreadsheets, but using one shoud be easy enough! Thanks

Bill Taylor

Computerized weight and balance
 

Bill, My friend Bill just helped me modify the spreadsheet to perform the WT&BAL on the computer. I'll be happy to send it to you. I have to Thank Gord as well for his assistance in this matter. Be aware you MUST check the information in the spreadsheet for your aircraft. Not responsible for errors.
You'll need to have Excel program to use this. I'm enclosing my e-mail address because there seems to be a problem attaching it to this web site-sorry.bstory@pa.rr.com
BILLS

At the risk of getting in trouble, I don't EVER do a weight and balance (w&b) calculation. For like the last 10 years.

I trained with a CFI that weighed over 300 lbs, did the w&b and it was OK. Early on, when I was building a house in the Bahamas, I made some trips with just me and lots of cargo, did the w&b and it was OK (to be fair, heavier stuff like beer cases went on the 2nd row of seats or near the front of the cargo area).

After several more w&b with pretty extreme loads, I concluded that it's very hard to get a Skymaster outside the w&b parameters, if you adhere to the max weight restriction on the cargo area and use minimal common sense (obviously, if one day I have an extraordinary load, like very light kids and a heavy cargo load, I will do a w&b).

Do other readers feel the same way? Or have you found instances where a Skymaster is outside the w&b parameters?

Ernie

Depends on the Skymaster. My 1977 T337G could only carry 400lbs in the cabin with full fuel due to all the additional equipment ( AC, intercoolers, full deice, etc.), so I was leaving myself down on fuel, and doing a W&B anytime I had more than me and one passenger. It never hurts to check, and matters more to some planes than others.

Ernie;
I agree with your point, however in my case I fly "Angel Flights" and a detailed W&B is required to be done and sent in to the organization for every mission. I am trying to automate this a bit and use my iPad to simply email them the documents.
Bill

I see your point, Bill. And, Jeff, by w&b I really mean the full weight by station calculation. On the weight alone, I do that on every flight (it's in my head: 1664 lbs minus the fuel weight minus a personal margin of 100 lbs; since virtually all my flights are to the Bahamas carrying 80 gal of fuel, that leaves ~ 1080 lbs for passengers and cargo).

Ernie

Because you're using the same aircraft stations every time, it's an easy calculation that you can do on Excell or any other application that can add or subtract.

You can also get commercial software such as http://eflite.com/software/aircraft_...lators_std.php

www.fltplan.com has a weight and balance feature, but you have to build the profile. A lot of aircraft are in there already, but not the Skymaster. Be the first to build one yourself, and then it's there for everyone to use or modify for their own use.

I actually prefer the American Aeronautics plotters, and have used them on numerous light aircraft, a lot of medium turboprops and turbojets, and some faster, bigger equipment, too. They work great. I've used them under Part 135 a lot, and the FAA likes them. They're easy to use quickly, to use for multiple legs in the ame airplane with differing fuel or passenger loads, and if you order their duplicating forms, you'll get two copies with each weight and balance; one to leave behind or forward to your agency, and another to keep as a permanent record. Very handy. They come in aluminum and fit neatly in a flight "can" or your flight bag, and last forever. You can have them custom made for your aircraft, or accept a standard one for your make and model.

http://flyincg.com

They sell the ifly software, or the American Aeronautics plotters.

The nice thing with the vector graph and plotter method is that you can clearly see from the graph where your CG lies, where it will go with fuel burn, if you're in CG with your empty weight, zero fuel weight, loaded weight, and as you add each items, and it's very easy to see what you need to do to the load to bring it in CG or keep it there; you can plan out the entire trip that way and see exactly what fuel burn, or taking on or deplaning passengers or cargo will do to your load, where to put it to make the CG work out, etc, immediately and visually.

If you don't want a permanent record, you can get the laminated graph and draw on it with a grease pencil, too. Very economical. I recommend keeping a record of your CG for each flight, but it's up to you.

I have used this one for years. It takes a little work to set up but the sliding scales make it easy to size up your loads.
http://www.skybound.nl/cgi-bin/service/wb/index.cgi

I just sent in the data for a generic T-337G to fltplan.com so hopefully that will be an option soon.

Well it seems I need a CG Graph with the arm which my POH does not have.....anyone have one? 1973 T-337G.

W & B data
 

If you want to build a spreadsheet for this the formulae for the fore and aft c of g limits are not in the POH. You can get them from the Type Certificate Data Sheet which may vary with each model. The aft limit is quite simple as it is a straight line. The forward limit changes with increase in gross wt.
I have run several scenarios for an E model and it's very difficult to get it outside the limits. Max weight in luggage compartment and very light pilot might bust the aft limit otherwise if you load as per the weight limits at each station it stays within the limits.
You will need to alter the attached spreadsheet for your aircraft and make sure the results match the POH method before relying on it.
I have a version that will run on your iPad, you just need to buy the "Numbers" ap.

This is the best W&B app out there. You can have multiple aircraft and it works great. On the iPad is so convenient because you have it with you anyway. Just another great reason to have the iPad in the cockpit.

It's only $5.99


http://warbredstudios.com/flightscale/flightscale.html

Thanks Herb, that would have saved me a LOT of bother! I like the idea of emailing the load sheet once you're done.

Herb;
Quick question. Does it let you save flight data? And if so, is there any way to print from it? Angel Flight requires a piece of paper to be faxed or mailed to them for each flight. Thanks.

Bill

Downloaded this app and yes, sure does let you email directly from an iPad.

+1 Thanks!

After fooling around with this for a few days it really is a neat app. However, it is now $6.99...you got a good deal Herb!

Computerized weight and balance
 

Hello ALL.
I have a friend that customized an Excel spreadsheet for 4200 gross weight Skymaster!! We in the CAP use the Excel spreadsheet for all our airplane. It works great-best of all it's FREE!!
If any one needs a copy let me know. You have to have Excel though.
BILLS

You could post it here....but if you don't, I'd like a copy: learjetter_AT_gmail.com

Thanks

W&B on iPad
 

All you need is "Numbers" on your iPad. I have a customisable spreadsheet I can send anyone who wants it. You can email from your iPad or take a screen shot and email that to keep your minders informed.

I like this one for $4.99:

https://itunes.apple.com/us/app/wnb-...408836204?mt=8

because it allows for some pre-set weights at certain stations. For example, I don't have to remember how much my rear seats weigh - I can just move the "rear seats" slider to the right when they're installed, and to the left when they're not. I also carry some odd but specific cargo occasionally and it lets me add or subtract it with a finger swipe, and I don't have to remember how much it weighs or its station.

I use it to send emails of W&B for PALS (similar to Angel Flight) preflight.

Weight and Balance Pro is really easy to use. It makes it so there is no excuse in knowing your W/B. Not sure if it is on Android or not but for the Apple products it's sweet.


Photos
1. Cover
2. Work Page for Skymaster
3. Envelope and gross
4. Building the stations
5. Building the envelope

One simple trick I use (which can be used on any app) is to make myself a permanent part of the solution. For instance, on W&B Pro (that's the one I linked to above) I can enter my weight & station and make it a "hidden" field that doesn't need to be updated each time. I just use the slider for the copilot's weight. After all, if I'm computing a W&B I know exactly who's in the front left seat.

Sure, I vary by 5-10 lbs seasonally but it's close enough. :)

Numbers Spreadsheet
 

Here is a screen shot of the spreadsheet I use. The neat thing here is it's all on one iPad screen plus it has a quick fuel calculation at the bottom as one is often juggling load vs distance / fuel. You can email this page or take a "snapshot" of the page for future reference. (Press 'home' button and on/off button simultaneously to take a snapshot on an iPad). This spreadsheet is in kg lit & knots for Australia. I have a version in lbs & gal only for USA.

Computerized weight and balance
 

Herb.
Thanks for the update. I contacted the Web site for B n W Pro. I unfortunately I don't own an I-Pod or I-Pad and asked them if they had a Windows version, they do not. They also said they didn't offer the Skymaster version.
Thanks any ways.
BILLS

You can program any the data for a 337 (or any aircraft) yourself. it's not hard and only needs to be done once. If you do get an iPad or iPhone, don't let the lack of a 337-specific template worry you.

Bill
They only offer some common templates, like 172, PA 28, so as I posted photo 4 and 5 show the work page to make the Skymaster template. It's not a problem, any aircraft can be used.

Computerized weight and balance
 

Thanks for the reply. I do already have a computerized version of a W & B program, that we use in the Civil Air Patrol. It has been adapted for my 1965 C337. It works well, and is easy to use.
Thanks again, BILLS

Numbers
 

An alternative to Numbers for the iPad is "CloudOn", which is currently free, and gives you access to Excel, Word, and PowerPoint. You can save documents to your drop box.
Internet connection required for use.