Having spent some time looking on the internet for a good Weight and Balance Calculator for the Robinson R22 Helicopter and finding most of them to be poorly designed and difficult to customise, I decided to create my own.
This MS Excel spreadsheet has a clear layout and simple tables for adding additional aircraft details.
Simply enter your weight, and the weight of your passengers plus their baggage, and the calculator will tell you how much fuel you can load to reach MTOW, and also show you the CG position on the charts taken from the POH. Simple drop-down lists allow you to choose your doors and dual-control configuration, and see how the change in weight affects your CG position. If things start to light up red – you know you’re overloaded!
Great spreadsheet! I do have one question though. I am rather poor at the use of Excel. How exactly do I edit the aircraft tables?
thanks,
Andy
Thanks for your comments.
The first thing you need to do in order to edit the spreadsheet is unlock it. The sheet is “protected” so that certain cells cannot be changed by accident. In Office 2003 this is “Tools/Protection/Unprotect Sheet” and in Office 2007 is “Review Tab/Unprotect Sheet”.
You will then be able to change the “Aircraft Information” section to match your aircraft. All you have to edit after that is update cell I2 “Data/Data Validation” so that all your new aircraft registrations show up in the drop down list.
If you want to change the aircraft type, from say R22 Beta to R22 Beta II, then you just need to update the two CG columns with the correct parameters.
Make sure you “Protect” the sheet again after your changes to ensure that nothing gets changed by accident.
If you like, just send me your aircraft information and I’ll provide you with an updated spreadsheet.
Hey,
Love your spreadsheet. Would love to use it but can’t figure out how change the drop down list from cell I2.
Tnanks, Great job!
Gary
Hi Gary,
To change the contents of the drop down list, you need to select it
and then go to the Data Validation tab.
Thanks for your interest!
Steve.