Apps and W&B spreadsheets for iPhone/Palm/Android/Blackberry
Join Date: Feb 2007
Location: All over
Posts: 33
Likes: 0
Received 0 Likes
on
0 Posts
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???
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???
Join Date: Oct 2003
Location: Over here
Posts: 1,030
Likes: 0
Received 0 Likes
on
0 Posts
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.
Join Date: Feb 2010
Location: I only exist
Posts: 11
Likes: 0
Received 0 Likes
on
0 Posts
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.
Join Date: Feb 2007
Location: All over
Posts: 33
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Join Date: Nov 2001
Location: Iceland
Age: 53
Posts: 509
Likes: 0
Received 0 Likes
on
0 Posts
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
So pd2, where's the fuel calulator you were talking about?
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
So pd2, where's the fuel calulator you were talking about?
Join Date: Feb 2007
Location: All over
Posts: 33
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Join Date: Nov 2001
Location: Iceland
Age: 53
Posts: 509
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Join Date: Feb 2007
Location: All over
Posts: 33
Likes: 0
Received 0 Likes
on
0 Posts
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?
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?
Join Date: Nov 2001
Location: Iceland
Age: 53
Posts: 509
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Last edited by Heli-Ice; 18th Feb 2010 at 07:14.
Join Date: Feb 2007
Location: All over
Posts: 33
Likes: 0
Received 0 Likes
on
0 Posts
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!!!
Of course version 2 of the program will allow for not only pee and sweat, but No 2's.
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!!!
Of course version 2 of the program will allow for not only pee and sweat, but No 2's.
Join Date: Nov 2001
Location: Iceland
Age: 53
Posts: 509
Likes: 0
Received 0 Likes
on
0 Posts
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.
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.
Join Date: Apr 2007
Location: Center of the Universe
Posts: 645
Likes: 0
Received 0 Likes
on
0 Posts
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
* 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
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.
Join Date: Apr 2007
Location: Center of the Universe
Posts: 645
Likes: 0
Received 0 Likes
on
0 Posts
Tadah!!!!
Join Date: Jul 2007
Location: Antigua, West Indies
Age: 55
Posts: 122
Likes: 0
Received 0 Likes
on
0 Posts
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.
Pilot Whiz -- free and let's your play around with the useful load.
Join Date: Apr 2007
Location: Center of the Universe
Posts: 645
Likes: 0
Received 0 Likes
on
0 Posts
Ibal -- major drawback is YOU have to supply the fuel distribution between the tanks