Robinson Helicopter Weight and Balance

Struggling with the pre-flight weight and balance calculations on your Robinson R22 or R44 helicopter? Then try out these MS Excel spreadsheets. 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

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! All you need to do is add the details of your aircraft to the data tables, and you’re good to go.

Please feel free to leave any comments or suggestions on how the CG calculator could be improved.

  R22 Weight and Balance spreadsheet (14.1 KiB, 3,259 hits)

  R44 Weight and Balance spreadsheet (17.8 KiB, 3,708 hits)

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.

Posted in Rotorcraft.

Steven Hale

Steven Hale leads the operation and development of the international Birmingham Solar Oscillations Network (BiSON), a global network of automated robotic solar telescope run by the University of Birmingham in the UK. His research interests are instrumentation and electronics, and high-resolution optical spectroscopy techniques. In his spare time he has many interests including photography and aviation, and has a private helicopter license rated on the Robinson R22 and R44 aircraft.

This is a private blog and in no way represents opinions or endorsements from the University of Birmingham.

19 Comments

  1. Pingback: Robinson R22 Helicopter Weight and Balance – Steven Hale Photography

  2. Pingback: Robinson R44 Helicopter Weight and Balance – Steven Hale Photography

  3. 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

  4. 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.

  5. Thanks Man, that helps a bunch. Thank you for your quick response.
    Lonnie

  6. Wow nice program. Feel like making one for a Bell 206 L III and IV?

  7. 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?

  8. 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

  9. Thanks! I don’t have the file here right now, but I’ll email it over to you later today.

  10. Pingback: Bell 206B Helicopter Weight and Balance – Steven Hale Photography

  11. 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

  12. 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.

  13. The spreadsheets for both the R22 and R44 have been updated. The layout is now cleaner than ever, with all the lookup tables moved out onto a separate page. The drop-down aircraft-selection list now updates automatically as you add more aircraft to the data table, and there’s no more fiddly locking/unlocking to update the values.

    Just directly type in the details of your aircraft, and you’re good to go in seconds!

  14. Steve, great job!

    For further improvement: Closely looking on the cg limitations according to R44 Raven I POH page 2-4, I see the chart line reaching from (2200 lbs; 92.0 in) towards (2400 lbs; 93.0 in) as opposed to your spreadsheet reaching from (2200 lbs; 92.0 in) via (2300 lbs; 92.0 in) towards (2400 lbs; 92.5 in), providing some extra space for cg limit violations.

    I guess this allowed you simplification to have a single spreadsheet for both the Raven I & II, but I would appreciate a respective refinement.

    Marcus

  15. Hi Marcus,

    Many thanks for your comments.

    You are quite correct. I have made the small modification to the CG limits for the R44 Raven I and uploaded a new version of the spreadsheet.

    Thanks!

    Steve.

  16. hello, i purchased or made a donation for this program quite some time ago and i love it ! my question is, do you have or do you plan to make a version that can be installed and run on an android tablet? would be nice for the wife to have onsite when doing tour rides

    thanks
    Dan

  17. Hello Daniel,

    I have no plans to make a native Android app, but I believe the spreadsheet does work on standard Android spreadsheet viewers.

    Steve.

  18. The comments are more encouraging including the calculations that are in within,they’ve inspired me a lot.THANKS A LOT!

Leave a Reply

Your email address will not be published. Required fields are marked *