Greetings to all ppruning in this foul weather. I am trying in my fumbling way to automate a spreadsheet that will give me heading to fly (true is fine) and groundspeed given TAS, wind, and track required. My problem is not the formula as such but how to insert the variables on an .xls spreadsheet. Is there anyone here with a higher geek rating who could show me an example?
The actual spreadsheet is done as far as pretty goes but isn't much use as it doesn't yet do the calculations. Here is the link to it in my dropbox....
A6 Plog
In case anyone is feeling kind. I realise I will need two cells for wind speed and direction, but that is as far as my brain takes me.