by smoss » Fri Jun 08, 2018 9:53 pm
Don't remember where I originally picked this up to credit, but it is an excel sheet showing graphical results, which I then added a component for flight speeds (based off interpolation of the AFM tables, and added a few extra "zones" for front and back seat floors, using estimates of what the moments there would be. Enter empty mass and moment for your particular bird under the graph in yellow fields, then enter all the weights, etc., in the top section yellow fields. Weight, CG, etc will then auto calculate and show point on graph. For flight speeds, enter fuel on board at any given time (yellow field under fuel remaining) and flight speeds (vy, best glide, landing speed full flaps) will calculate. ONLY CHANGE VALUES IN YELLOW FIELDS, all the rest are calculated or standards. The first page/sheet is for DA40 with long range tanks, the second one is some example results, the third sheet/page is for DA40 with standard tanks. I don't use the standard tank one, so the bells and whistles are not added. Feel free to ask if there is confusion. I have greatly appreciated this over the years, especially being able to easily pull up plane/weight specific flight speeds.
- Attachments
-
- DA40 weight-bal 3.xls
- (52 KiB) Downloaded 794 times
Don't remember where I originally picked this up to credit, but it is an excel sheet showing graphical results, which I then added a component for flight speeds (based off interpolation of the AFM tables, and added a few extra "zones" for front and back seat floors, using estimates of what the moments there would be. Enter empty mass and moment for your particular bird under the graph in yellow fields, then enter all the weights, etc., in the top section yellow fields. Weight, CG, etc will then auto calculate and show point on graph. For flight speeds, enter fuel on board at any given time (yellow field under fuel remaining) and flight speeds (vy, best glide, landing speed full flaps) will calculate. ONLY CHANGE VALUES IN YELLOW FIELDS, all the rest are calculated or standards. The first page/sheet is for DA40 with long range tanks, the second one is some example results, the third sheet/page is for DA40 with standard tanks. I don't use the standard tank one, so the bells and whistles are not added. Feel free to ask if there is confusion. I have greatly appreciated this over the years, especially being able to easily pull up plane/weight specific flight speeds.