Lateral Speed Method - Page 2

SnipersLaww · 02-20-25, 11:37 AM

Quote:

Originally Posted by Efshapo

Thank you for your feedback!

I did, thank you!
I also developed a TDC simulator in Excel to measure the error injected by the False AOB 90 method.

man.. i would love to be able to have a graph/display like that in my spreadsheet calculator that ive been building. im still learning the program and formulas and such though so just completing the calculators alone has been rough but its nearly mostly done. a graph display is just a bit too advanced for me yet.

Aktungbby · 02-20-25, 11:43 AM

SnipersLaww!

Efshapo · 02-24-25, 02:55 PM

Quote:

Originally Posted by SnipersLaww

man.. i would love to be able to have a graph/display like that in my spreadsheet calculator that ive been building. im still learning the program and formulas and such though so just completing the calculators alone has been rough but its nearly mostly done. a graph display is just a bit too advanced for me yet.

Hey, you know what they say about a picture and a thousand words...

I even refined it since then, see the screenshot attached.

SnipersLaww · 03-06-25, 12:44 AM

Quote:

Originally Posted by Efshapo

Hey, you know what they say about a picture and a thousand words...

I even refined it since then, see the screenshot attached.

ugh.. i want it... i doubt it would fit in with my master sheet ive made but i still want it for my own personal interests

SnipersLaww · 03-06-25, 02:19 AM

ive been working on my own sheet for use in multiple games and started off with a bunch of different calculators at first and managed to compress it down to about this much so far of what i feel is important. with not actually knowing spreadsheet formulas and spending alot of time with ai bots trying to help build it i feel i have pretty much hit the limit on what i can get an ai bot to understand to assist me with. (there were a few spots ai just couldnt figure out what i was trying to say to it either with what i wanted on my larger sheet) your sliders and charts are i feel the next level on what i want to try adding to it.. if even not for my compressed sheet shown here.

Fidd · 03-09-25, 09:55 PM

There was a little trick I used to use for calculating the amount of cross-wind component when landing an aircraft with a wind, say 45 degrees off the nose. It also used sines, but of course sine-tables and calculators are of limited use when flying an aeroplane!

It worked thus, and all you need is an analogue wrist-watch or just an imagined clockface.

Angular difference of runway to wind's origin. Lets say 45 degrees. You think of that as 45 minutes on your watch and convert that to the proportion of an hour, so in this case 3/4 of the watchface. If the wind is 20 knots, then you have 15 knots (3/4 of 20) cross-wind component, ie the value of wind. pushing the aircraft sideways across the runway. We needed to know this as there were limits on how much crosswind a particular aircraft type could be landed with, before control was lost as it landed and slowed. Which could create disagreeable amounts of paper-work post-incident!

If the angular difference is say 30 degrees, then that's half the watch-face, therefore 1/2 the total windspeed, so if 18 knots, that's 9 knots cross-wind.

This technique is surprisingly accurate for sine values and is a really useful fast and dirty way of calculating the sorts of sums your method requires, whilst you're doing other things and can't be mucking about with calculators etc. With a little practice you can do such sum in your head.

SnipersLaww · 03-17-25, 09:15 AM

Quote:

Originally Posted by Efshapo

Hey, you know what they say about a picture and a thousand words...

I even refined it since then, see the screenshot attached.

could you possibly teach me how you made that chart? i dont use excel though i use another app and i am having problems trying to figure out how to make one. i am just trying to make one to just show an intercept course.. not all the fancy torpedo intercepts. my calculator doesnt really need it but it is something i want to learn how to add.

02-20-25, 11:43 AM	#17
Aktungbby Gefallen Engel U-666 Join Date: Jul 2013 Location: On a tilted, overheated, overpopulated spinning mudball on Collision course with Andromeda Galaxy Posts: 29,973 Downloads: 24 Uploads: 0	welcome aboard! SnipersLaww! __________________ "Only two things are infinite; The Universe and human squirrelyness?!!

03-06-25, 02:19 AM	#20
SnipersLaww Nub Join Date: Feb 2025 Posts: 4 Downloads: 8 Uploads: 0	ive been working on my own sheet for use in multiple games and started off with a bunch of different calculators at first and managed to compress it down to about this much so far of what i feel is important. with not actually knowing spreadsheet formulas and spending alot of time with ai bots trying to help build it i feel i have pretty much hit the limit on what i can get an ai bot to understand to assist me with. (there were a few spots ai just couldnt figure out what i was trying to say to it either with what i wanted on my larger sheet) your sliders and charts are i feel the next level on what i want to try adding to it.. if even not for my compressed sheet shown here.

03-09-25, 09:55 PM	#21
Fidd Captain Join Date: Apr 2005 Location: Blighty! Posts: 540 Downloads: 10 Uploads: 0	There was a little trick I used to use for calculating the amount of cross-wind component when landing an aircraft with a wind, say 45 degrees off the nose. It also used sines, but of course sine-tables and calculators are of limited use when flying an aeroplane! It worked thus, and all you need is an analogue wrist-watch or just an imagined clockface. Angular difference of runway to wind's origin. Lets say 45 degrees. You think of that as 45 minutes on your watch and convert that to the proportion of an hour, so in this case 3/4 of the watchface. If the wind is 20 knots, then you have 15 knots (3/4 of 20) cross-wind component, ie the value of wind. pushing the aircraft sideways across the runway. We needed to know this as there were limits on how much crosswind a particular aircraft type could be landed with, before control was lost as it landed and slowed. Which could create disagreeable amounts of paper-work post-incident! If the angular difference is say 30 degrees, then that's half the watch-face, therefore 1/2 the total windspeed, so if 18 knots, that's 9 knots cross-wind. This technique is surprisingly accurate for sine values and is a really useful fast and dirty way of calculating the sorts of sums your method requires, whilst you're doing other things and can't be mucking about with calculators etc. With a little practice you can do such sum in your head.