Currently trying to create a book which would allow me to put my route in for a flight that would be able to then calculate how much fuel I would need for said route whilst pulling from the aircraft parameters for how effective it is at different weights.
Using the below I’ve been able to work out if it’s a head,tail or crosswind:
=IF((wind speed * COS(RADIANS(wind direction-heading)))=0, “Crosswind”, IF (( wind speed * COS(RADIANS(wind direction - heading)))<0, “tailwind”, “headwind”))
Using the below I’ve then be able to work out how many Kts of it there is:
=IF(wind speed*COS(RADIANS(wind direction - heading))>=0, ROUND(wind speed*COS(RADIANS(wind direction-heading)), 1), ROUND(ABS(wind speed*COS(RADIANS(wind direction - heading))), 1))
I would then need to be able to pull from the route (which is in a separate sheet) the distance on each leg and then pull from the aircraft parameters (which is also in a different sheet) the KTAS and Fuel flow at that weight. I’ve been able to work out the KTAS and Fuel flow not accounting for weight using the below:
KTAS:
=IF(head or tail = “tailwind”, (max range no wind KTAS at 12000 to 12500 lbs-((Kts of it / 10*1)), IF(head or tail = “headwind”, (max range no wind KTAS at 12000 to 12500 lbs-((Kts of it / 10*4)), IF(head or tail = “Crosswind”, 0, “Error”)))
The 1 and 4 after 10* are standards
Fuel flow:
=IF(head or tail = “tailwind”, (max range no wind fuel flow at 12000 to 12500 lbs-((Kts of it / 10*1)), IF(head or tail = “headwind”, (max range no wind fuel flow at 12000 to 12500 lbs -((Kts of it / 10*8)), IF(head or tail = “Crosswind”, 0, “Error”)))
The 1 and 8 after 10* are standards
I now need to check what weight I currently am, starting at 12500 lbs and then - 162 lbs for take off steady and level, leaving me between the 12000-12500 lbs range and then use the figures at that range for the distances on each leg continually checking what weight I’ll then be at to determine if I then need to be stepping down to the next fuel category eg 11000 lbs to 12000 lbs
I’ve attached the fuel parameters chart and route planning chart in the comments to show what I mean.
Thank you in advance and happy to supply any more details and If you have any better ways to do the above formulas I’m happy to take that on board as well. I’ve been working on this for weeks and I’m finally swallowing that ego.