EXCEL Weight and Balance Sheet Help Needed!

J

Jazzyjazz

New Member
Good Day,
I use a Microsoft Excel sheet that I created to calculate Weight and Balance for a Piper Cheyenne II that I fly. I have been unable to get the sheet to calculate the aircraft moments and insert them into the calculations. The calculated moments are non linear.
Can one of you Excel pros help me to write a formula to calculate these moments for this particular cell? I will supply the Excel sheet and the Weight and Balance data to any one interested.
Or maybe someone can suggest a Freeware program for a Windows based pda that will perform the same duty?
Most Respectfully,
Jasper
 
I'll give it a shot for the fun of it. I'd recommend that anyone else that is familiar with doing this go ahead and volunteer also, since there is no guarantee that I'll get it right.
smile.gif


I'll PM you an email address.
 
Jasper,

Send it to me and I'll check it out. I've done a bunch of them for different airplanes. When you are done, you should be able to enter the pax and cargo weights and fuel load and get the total weight and CG location. Check for a PM.

Bawb
 
For my final in programming in university, i created a CG and weight shift calculator in C if you want it. PM me if you would like.
 
That's strange. I've emailed them to you a couple of times. I must not be using a correct email address.

I'll try again.
 
[ QUOTE ]
That's strange. I've emailed them to you a couple of times. I must not be using a correct email address.

I'll try again.

[/ QUOTE ]
Did you get them this time???
 
Good Day,

Kudos and Thanks to ALL (Bawb, PaulThomas, ILStud, and bigbadboblittle ) who offered their time and help.

Special Thanks to STEVEC who used Excel LOOKUP formula to give me a most EXCELLENT sheet that both satisfies and teaches me how to create my own sheet the next time that I need one.

This sheet can easily be modified, by adding and deleting cells or, by changing names and values to suit any number of different aircraft. It works GREAT in my pda!

Anyone wanting to have a copy of this sheet is free to pm me with an email address and I will foward you a copy.

For the Legal Eagles...
"As always, Mr. Phelps, if captured (or crashed), the secretary will disavow any and all knowledge..." meaning USE ON YOUR OWN RESPONSIBILITY.

Respectfully,
Jasper
 
Can someone send a copy of the Excel one to me? I'd like a starting point to modify for my planes.
Thanks!
LC
 
[ QUOTE ]
Can someone send a copy of the Excel one to me?

[/ QUOTE ]

And your email address would be????
grin.gif
 
[ QUOTE ]
Can someone send a copy of the Excel one to me?

[/ QUOTE ]

And your email address would be????
grin.gif
 
You must log in or register to reply here.
Back
Top