Re: Spreadsheet - Emulating CAS/TAS whizz wheel
one25six,
Good Heavens .. a chap is away for a bit and the world jumps in to fix the problem.
In addition to the information in the two previous posts, I dug out some old FT spreadsheets I used to use and extracted the relevant bits to suit your needs. As I don't have a convenient means to link the sheet here, I will email it to you. Provided that I haven't made any cell coding errors it should replicate the prayer wheel for subsonic/tropospheric calculations. If you have a play with it and the answers from the prayer wheel don't match up, please send me some examples and I will track down my coding error(s) for you.
You will note that selfin's approach is akin to the physicist's view on life (perhaps he/she is one of those good folk), while Genghis' is the traditional engineer/aerodynamicist/FT approach (an instance of which he is). My sheet is much the same as G's suggestion but lets you play with higher subsonic Mach if you want to amuse yourself over a coffee and daydream a bit as to how your bird might go with an old mil surplus jet strapped to it ....
One note .. be prepared for some minor variations between one method and another .. round-off errors, minor variations in constants, etc., play a part in the final numbers coming out of the sausage machine ...
Do let us know how the FT work pans out in due course .. have fun.
PS .. email didn't work out too well as the previous comms have been via PM .. perhaps you can PM/email me with your email contact details. If you have it somewhere already, my apologies .. but we are all still trying to get up to speed with the new, improved PPRuNe ..