PPRuNe Forums

PPRuNe Forums (https://www.pprune.org/)
-   Rotorheads (https://www.pprune.org/rotorheads-23/)
-   -   Apps and W&B spreadsheets for iPhone/Palm/Android/Blackberry (https://www.pprune.org/rotorheads/213798-apps-w-b-spreadsheets-iphone-palm-android-blackberry.html)

pd2 16th February 2010 05:41

Worrying behaviour
 
I find it amusing the number of requests for W&B programs.

As Captains or Co-Pilots of these aircraft, it would be more than reasonable to expect that you would have the knowledge to calculate the W&B of your aircraft.

With even just a basic understanding of MS Excel, you should then be able to create your own W&B calculator.

So all these people looking for W&B programs, how are you currently calculating the W&B?? or is this fundamental aspect of planning not being completed.

Does this sound harsh, or is this a reasonable assumption. What is next??? A fuel calculator???

Gomer Pylot 16th February 2010 19:22

I can't speak for others, but I've used computer w&b programs to explore loading configurations, and experiment with different loads to see what will happen when I move something from here to there. It's easy on a computer, and lets me learn where and when I need to be careful with an actual calculation. I have both Palm and PC programs, and while I seldom, if ever, use them for actual calculations, they can show worst-case scenarios, and whether I'm likely to have a problem. Having programs for aircraft that I don't even fly is also instructive. When it comes to calculating the actual weight and balance of the aircraft I'm about to pull pitch in, I use the approved method of calculation, but it's educational to play with other calculations while I'm not flying.

WikiRFM 16th February 2010 19:57


I've used computer w&b programs to explore loading configurations, and experiment with different loads to see what will happen when I move something from here to there.
That's why I developed this one for the R22 and this one for the R44. I also have one for the Mariner. Where I trained, most students didn't do W&B except before cross country flights or check rides, even though we had several instructors pushing 220+. And the W&B data sheets the school provided had some problems (like somebody changing the arm or moment in the template). Since I made a habit of doing W&B before every flight, it made sense to make the spreadsheets, and then figured out that they could be pretty useful learning tools--like, which helicopter can I fly in with my 235 lb instructor...?

pd2 16th February 2010 22:05

Totally agree with you Gomer Pylot. The electronic W&B are a very useful and time saving tool. I use them for every flight.

My criticism is directed to the almost desperate requests for these tools, which makes these tools seem like some sort of Holy Grail.

My point is that pilots should be able to do these for themselves. All that is needed is a basic knowledge of Excel or other spreadsheet program.

If I download one of these programs listed on the thread, how do I know it is correct and/or accurate? I am sure that more than a few will probably just download the program and start plugging away with figures for their flight and probably not even check correct BEW, arms and moments specific for their aircraft.

Heli-Ice 16th February 2010 23:08

pd2

I use my excel w&b for every flight as a timesaver. I made it myself using the real figures from the Schweizer I use it for.

Of course do I check its accuracy by handcalculating it regularly. I am required by the regulations governing Aerial Work, to check my spreadsheet at regular intervals to confirm it is working properly.

I had not given it a thought that someone would be so stu... to just download a w&b spredsheet and start using it without confirming its accuracy and adapting it to his own aircraft. Good pointer :ok:

So pd2, where's the fuel calulator you were talking about? :cool:

pd2 17th February 2010 22:47

Heli-Ice,

I am currently designing the fuel calculator. It will revolutionise the aviation industry. Once specific data is entered by the user it will calculate the following:

* Fuel Type
* Aircraft Fuel Burn Rate
* Capacity of Tank(s)
* Range for a given quantity of fuel
* Endurance
* Refuel Quantity at next destination.
* Holding, Variable and Fixed Reserves

There is very little input required from the user. The user needs to input the following information for the caculator to work.

* Fuel Type
* Aircraft Fuel Burn Rate
* Capacity of Tank(s)
* Range for a given quantity of fuel
* Endurance
* Refuel Quantity at next destination
* Holding, Variable and Fixed Reserves

If pilots are unsure of the data for their aircraft, some of the data is available from the Flight Manual.

If you have any suggestions to improve the spreadsheet, let me know so I an incorporate the changes.
:hmm:

Heli-Ice 18th February 2010 00:10

pd2

I see, it is the simple type you are working on. I already love it.

Improvements you ask? Can you make only one window for the data input? My ten thumbs and hand-eye-brain coordination is terrible. :)

pd2 18th February 2010 00:20

Well I need to create the foundation for the program initially. This is a laborious process, and I may need to call on a friend to check the mathematical equations. Once I have that all set up and working correctly, I can modify it to calculate almost anything. So it is slow going now.

I am currently toying with the idea of creating a module to calculate the varying fuel burn rates during a climb or descent, or with changes in density altitudes. I know what you are thinking... this guy lives in the clouds, but I believe it is possible.

What do you think? Is this being over optimistic?

Heli-Ice 18th February 2010 06:50

Over optimistic? Naahhhh... Beeing an optimistic is what keeps you in this business. Some guys ahead of us believed they could build a thing called helicopter and that it would fly!?! and thats what they did.

How about adding a module that calculates heli pilot calorie burn in various circumstances? It would give him some idea about the minimum calories he has to aquire the following night at the bar.

Just remember when you get all tangled up in the math lab tests that 2+2 doesn't allways equal four in this business.

pd2 18th February 2010 08:01

hmmmm... what a brilliant idea.

Not only can I measure the metabolic calorie burn, but if we add in the nett fluid of fluid pee'd and sweated and the fluid intake during the flight, not only can I provide an even more precise fuel consumption rate, I can also link this to the W&B module for CofG movements during the flight.

Brilliant!!!:D

Of course version 2 of the program will allow for not only pee and sweat, but No 2's.

Heli-Ice 18th February 2010 08:13

You got yourself a business plan there man.

Since I am extremely fair, I'll settle for 10% of net profits, or a nice little house by a frozen lake somewhere in Canada, for my great advice and idealogy in this project.

Over and out.

EN48 18th February 2010 12:02


I am currently designing the fuel calculator. It will revolutionise the aviation industry. Once specific data is entered by the user it will calculate the following:

* Fuel Type
* Aircraft Fuel Burn Rate
* Capacity of Tank(s)
* Range for a given quantity of fuel
* Endurance
* Refuel Quantity at next destination.
* Holding, Variable and Fixed Reserves

There is currently available a product that does (most of) this automatically in-flight using a fuel flow transducer installed in the acft fuel system: The Shadin MiniFlo/MicroFlo series. Yes, more expensive than a PDA type solution, but certified and works quite nicely (from personal experience). ;)

Much of my flying is quite predictable as far as loading is concerned, so I have made up several pro forma W&B charts which cover the most common loading configurations for my acft. Using these, it is easy to see graphically how slight variations from these standard configurations will affect W&B. For significant departures from standard, a careful new calculatiion is in order. I have laminated these in plastic and carry them in the acft. Obviously not as useful for an operator with little standard pattern to loading.

munsterflyer 29th March 2010 20:35

helicopter apps
 
anybody have good apps for helicopters,like weight and balance

Mungo5 29th March 2010 20:45

Tadah!!!!

iwizwheel

EN48 30th March 2010 12:19


Tadah!!!!

I have just purchased this iBal application for the iPhone ($10) and find it quite good. It was not previously available for the B407, so I contacted the company and they agreed to make it available for the 407 if I supplied the needed W&B info. The currently available first release doesnt yet support the 5250 GW or aux fuel options, but this is said to be coming in the next release. If one already has an iPhone, a great deal at $10! :ok:

choppertop 30th March 2010 16:40

Ibal -- major drawback is YOU have to supply the fuel distribution between the tanks. Doesn't work it out for you. And £5.99??

Pilot Whiz -- free and let's your play around with the useful load.

EN48 30th March 2010 19:01


Ibal -- major drawback is YOU have to supply the fuel distribution between the tanks
Really? I have only played with this for an hour or so, but cant see how one might do this with the B407 fuel system. iBal does show the most fwd, most aft, and zero fuel CG's on the 407. Does this apply to types other than the 407? So far it gives equivalent results to the examples in the RFM. :confused:

munsterflyer 31st March 2010 13:15

iphone apps
 
any of ye have good apps for helicopters like weight and balance would be good cheers

CaptDean 31st March 2010 13:49

try iBal
 
try iBal it only has R44,R22, 350 and jet ranger, but it works fine

EN48 31st March 2010 14:01


it only has R44,R22, 350 and jet ranger
iBal also has: Hughes 300, 206L, B407, EC 120 and three variants of AS350. :ok:


All times are GMT. The time now is 05:59.


Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.