Robinson Helicopter Weight and Balance
Struggling with the pre-flight weight and balance calculations on your Robinson R22 or R44 helicopter? Then try out this MS Excel spreadsheet. Unlike many of the other weight and balance spreadsheets available on the internet, this CG calculator has a clean and readable layout. It is also very easily customised to match the details of your own aircraft.
Robinson R22 R44 Weight and Balance Calculator
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!
Please feel free to leave any comments or suggestions on how the CG calculator could be improved.
Robinson Helicopter Weight and Balance for Windows Mobile
A cut-down version of the weight and balance calculator is now available for Excel Mobile on PocketPC (PPC).
How You Can Help
If you make use of these FREE tools, please consider making a donation to help fund further development!
Legal Stuff
All files and tools on this page are provided “as is” with no express or implied warranty for accuracy or accessibility. Use at your own risk. All calculations should be checked against the relevant pilot’s operating hand book before being relied upon for flight planning purposes.
[...] MS Excel spreadsheet has a clear layout and simple tables for adding additional aircraft [...]
[...] now updated my helicopter weight and balance spreadsheet to include the Robinson R44. I have maintained the same format for both the R22 and the R44 so that [...]
This thing looks really cool, but I’ll be danged if I can get to let me put my own basic empty weight in, which doesn’t do me any good, for everything else. I don’t under stand what those G-TBTA and all that is, Looks like you should be able to put your aircraft in there and save it but that doesn’t seem to be what it is and I am not finding any tutorials any where. Thanks for any help you might be able give.
Lonnie
Thanks for your comments, Lonnie.
I do intend to put some tutorials up at some point, just haven’t got around to it yet.
The G-BTBA etc. are UK style aircraft registrations. You can just change those to match the format of your countries aircraft.
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.
The aircraft registration field is setup as a drop-down list. You need to select cell I2 then go to “Data/Data Validation” and edit the “source” field so that all your new aircraft registrations show up in the drop down list. If you like, you could just remove the drop-down list and manually type in the required aircraft registration each time.
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 still have trouble, feel free to send me your aircraft information and I’ll provide you with an updated spreadsheet.
Thanks Man, that helps a bunch. Thank you for your quick response.
Lonnie
Wow nice program. Feel like making one for a Bell 206 L III and IV?
Hi JT,
I did actually start working on a version for the Jetranger III, but I never fully tested it and so I haven’t put it online.
If you like I can send you the file as far as I got, and you can have a look to see if it is any use to you?
Hi Steve
thats so far the best Excel CG sheet I found – congratulations for the good work!
As I’m currently doing/searching one for a JetRanger I would appreciate if you can forward me your Beta Version and we can work out finalizing and testing it together (I’m more than willing to share)…
John
Thanks! I don’t have the file here right now, but I’ll email it over to you later today.
[...] the success of my CG calculator for the Robinson R22 and R44, I have now produced a version for the Bell [...]
Steve, Neat utility!
This is so well done! I am a Robinson pilot and will donate to your software as well tell other about it.
Can you please tell me how to use the Alt. and temp feature? It gives a 3 digit negative number when I enter
the pressure alt and the outside air temp.
Thank you again,
Jim
Hi Jim,
Many thanks for your interest.
The pressure altitude and temperature boxes are used to calculate the density altitude. Simply enter your current pressure altitude in feet and the ambient temperature in degrees Celsius, and it will tell you your current density altitude. It doesn’t do anything with this figure, it’s just there to give you a heads up regarding performance in case your density altitude is higher than you think!
If you would like a version that does the calculation using degrees Fahrenheit, I’ll make the conversion and get back to you with a new spreadsheet.
Thanks again. If you need any further help, just ask!
Steve.