View Full Version : Knots meters & time calculations
PapaG39
08-24-07, 03:09 PM
I'm having a heck of a time coming up with the correct answers on my calculator.
I printed out a bunch of stuff to read in reference to knots, meters & kilometers, but I'm still not coming up with the correct answers to simple problems.
Such as: using the 0-1200 meters map I went with my little sub for 1000 meters in 9 minutes. I think the formula is KM (1.0) devided by my 9 minutes should give me the knots I'm going.. It doesn't so I must be doing something wrong.
The same thing in distance to go time. KM devided by my knots should give me time to a spot. But it doesn't work out.. it seems to be way off...
This is driving me more crazy then I already am...lol..
GoldenRivet
08-24-07, 03:13 PM
http://www.csgnetwork.com/csgtsd.html
a good time speed distance calculator, allows you to choose from different speed and distance measures and mix and match them.
http://www.convert-me.com/en/convert/length
good online distance converter
maybe these will help you?
1kn = 1.88km/h
So if you got your time in seconds or minutes, calculate the hours of it, the distance in km and you can calculate your speed in km/h.
Then just divide by 1.88 and you got the knots you where travelling.
I'm using a standard hand held calculator for those things, working well.
Time enroute -- Distance in kilometres divided by 1.8 = miles to go, divide by speed in knots = time enroute.
The answer will be in hours and decimals of hour.
Example: 7.25 seven hours and 15 minutes
7.5 seven hours and 30 minutes.
six minutes is one tenth of an hour.
:D
PapaG39
08-25-07, 03:38 AM
I know that this is clear as glass to u guys, but it is mud to me.
We are dealing in meters, kilometers & knots here & I can't get them sorted.
I did a trial run with a boat & wrote down the figures. using the online calculator it comes out correctly.
I did 1500 meters in 3:11 & the boat indicated 15kts
using my calculator I did: Speed X Time, 15kts X 3.183 = 47.74 what the heck is this number??? I went 1.5 km. or 1500 meters.
Distance divided by speed = time 1.5 divided by 15kts = .10 ??
Distance divided by time = speed 1.5 divided by 3.183 = .47
I have no idea what i'm doing here...maybe you really can't teach an old dog new tricks.. these meters kilometers & knots have me stopped.
I know that the minutes have to be converted to a decimal by dividing minutes by 60. Is it the same way for the seconds?
PapaG39
08-25-07, 01:45 PM
I know that there must be a good explanation on this forum on kilometers vs knots, but darned if I can run across it via the search method.
I know that someone must have had as much problem understanding this meters, kilometers, knots & minutes/seconds, degrees stuff as me...
At least one other guy on the planet anyway...
joegrundman
08-25-07, 07:33 PM
Hi there Papa G
Have you installed GWX? With this mod there are some speed conversion tables that are extremely useful.
I have also built myself a KM whiz wheel.
http://www.subsim.com/radioroom/showthread.php?t=114351&highlight=whiz+wheel
These things are worth their weight in gold, and can be used for so much. One of the small capabilites of the reverse side, which is a cricular slide rule, is that you can very quickly cross reference 1000m with 9 minutes to obtain a speed of 3.6knots.
Alternatively you can install any of the nomograph mods, which enable you to do this. A nomograph is a scale that will appear on your navmap and can be used to solve any speed/time/distance calculation assuming you know two of the factors. Run a search to find a nomograph mod. You can also find them linked from Wazoo's basic manual targetting tutorial.
Finally, you can just make sure that you take time measurements in increments of 3min15seconds. In 3min 15secs an object moves 100m for every knot of speed, so a 6knot object travels 600m, or 0.6km. At 9min 45 secs therefore a 6 knot object travels 1.8km. (kilometers is written with a small km; KM means Kriegsmarine).
If you'd taken your reading at 9min 45secs, and it had travelled 1200m, the speed would be 1200/3 per 3min 15 secs= 400m per 3 min 15 secs = 4 knots
joe
I draw lines on the game map with MoBo and it tells me the speed... :yep:
...among other things. :ping:
Notice below it calculates speed as 15.4kts for a 25 min elapsed time between M1 and M2
But in this case I'm determining contact direction of relative motion (DRM), converting it to true motion (TM or TC) and then plotting a course to intercept at 17kts.
http://xl-logic.com/mobo/tutorial_pics/mobo_challenge_answer.png
PapaG39
08-26-07, 02:46 AM
Wow! that wiz wheel is just what I'm looking for. I like wheels for doing these type of problems. By the time I do the math the ship has sailed away to the end of the ocean & fell off.
I used that online calculator & did a bunch of basic time & distance numbers to at least give me a ball park idea of speed, distances and times.
I am getting very slow at math in my old age so I need lots of quick reference numbers to give me a heads up to the situation....lol..
I don't know how , but I thought you could do a spread sheet graft with knots on one side & distance on another & times in the middle or some such thing.
I thought computers were suppose to do that type of stuff...
I don't have GWX..(Everyone keeps asking me that)
I'm just trying to keep my head up above water with the standard install/1.4b patch as it is...lol.. I don't need "more difficult" at this point.
I ran across a post that they guy was saying that if you zoomed the map out to where the little boat showed up (0-1250 meters) that you could put a check at the end of the line
after the SO reported target bearing xxx & that would be where the target is. then you can get a few checks & get his heading & by doing a time check between points can get hes speed.
I've been working on that..., but I had to figure out the formula on what do do & when to get the times/speeds & distances to work out.
I think I have it now.
for instance:
Time = distance - Speed
(kts x 1.8532 = xxx) Distance - xxx = zzz X 60 = Time
Anyway, it seems to work...lol.. or
Speed = Distance - Time
(min - 60 = xxx) Distance - xxx = zzz - 1.8532 = kts.
please correct me if I'm wrong.., but it seems to work. I don't know what key is suppose to be the divide mark on a computer either.
joegrundman
08-26-07, 06:01 AM
I'm glad you are making progress :D
I'd really get used to the fact that at 3 minutes, 15 seconds an object moves 100m for every knot of speed. It completely eliminates the need for any calculation. If in that interval the target has moved 700m/ 0.7km, the speed is 7kts. If the target moved 0.9km the speed is 9 knots.
It is a very quick process to get used to taking surface measurements at this time interval.
Assuming you are on the surface, click on the WO and ask for range and bearing to target, and promptly start the stopwatch. Press F5 to get to the navmap and quickly draw it in on the map. If you have the whiz wheel mentioned above you can equally quickly obtain the true bearing to target relative to north. otheriwse, just add the reported bearing to your present course.
When the stopwatch reaches 3 min 15secs, do it again.
for instance:
Time = distance - Speed
(kts x 1.8532 = xxx) Distance - xxx = zzz X 60 = Time
Anyway, it seems to work...lol.. or
Speed = Distance - Time
(min - 60 = xxx) Distance - xxx = zzz - 1.8532 = kts.
please correct me if I'm wrong.., but it seems to work. I don't know what key is suppose to be the divide mark on a computer either.
Computer mult: *
Computer div: /
TSD calculations follow the format of: Time * Speed = Distance
So moving the variables around...
D = T * S
T = D / S
S = D / T
PapaG39
08-26-07, 12:49 PM
joegrundman...aahhhaa.
That's the first explanation of the 3 15 rule that made sense to my old brain. yes I will definately incorporate that into my way of doing things.. The ol "KISS" (keep it simple saint) principle always works best for me...
Thought I'd get me a simple stopwatch from some watch shop for use in SH III. I have been wanting one anyway. That way I can sit on the couch & time the grand kids as they run back & forth...lol..
CapitanPiluso
08-28-07, 10:37 AM
I draw lines on the game map with MoBo and it tells me the speed... :yep:
...among other things. :ping:
Notice below it calculates speed as 15.4kts for a 25 min elapsed time between M1 and M2
But in this case I'm determining contact direction of relative motion (DRM), converting it to true motion (TM or TC) and then plotting a course to intercept at 17kts.
http://xl-logic.com/mobo/tutorial_pics/mobo_challenge_answer.png
Thats looks really good ...would mind telling me how to get that MoBo??
Thanks in advance
EZeemering
08-28-07, 11:56 AM
Thats looks really good ...would mind telling me how to get that MoBo??
Thanks in advance
Click on the little wheel in his signature ;)
von Zelda
08-28-07, 12:05 PM
Keep it simple!
I only use two equations:
Knots x 1.852 = Distance in kilometers
(example: 7 knots x 1.852 = 12.964 km)
and
Distance in kiometers divided by time in minutes x 32.5 = knots
This is the same equation as the 3-minute 15-second rule rewritten to solve for any amount of time.
(example: .6 kilometers divided by 3 minutes x 32.5 = 6.5 knots)
CapitanPiluso
08-29-07, 01:06 PM
Thats looks really good ...would mind telling me how to get that MoBo??
Thanks in advance
Click on the little wheel in his signature ;)
Thank you EZ, I downloaded it but seems the help pdf link is broken...where can I find it ??
Thanks
robj250
09-04-07, 02:45 PM
Okay, I have one for you. I cannot get the arrival time at the intercept. Here is the information:
Time of day = 12:12 (24 hours clock)
Here are the calculations I have done so far.
Uboat = Nautical M = 102.2 which equals 6.01 hours at 17 kts = 0.3 time in days
Target = NM = 151.4 = 25.23 hrs = 1.1 days
So what I need to know is what time of the day or night will the target (convoy) reach the intercept point?
I need help.
Rob
Okay, I have one for you. I cannot get the arrival time at the intercept. Here is the information:
Time of day = 12:12 (24 hours clock)
Here are the calculations I have done so far.
Uboat = Nautical M = 102.2 which equals 6.01 hours at 17 kts = 0.3 time in days
Target = NM = 151.4 = 25.23 hrs = 1.1 days
So what I need to know is what time of the day or night will the target (convoy) reach the intercept point?
I need help.
Rob
First, to determine an intercept course you need to know:
1) Convoy Heading
2) Convoy Speed
3) Intercept Speed
4) Convoy Bearing
In which case you can calculate time of intercept if you know a fifth variable...
5) Distance to Convoy
If you want to set time as the constant, you can solve for speed to achieve the time.
I don't think I see numbers 1, 4 or 5 provided in your description. ...and if you've calculated an intercept point and the time to traverse for uboat and target are different; that's not a valid point of intercept cuz the times should be equal.
robj250
09-04-07, 04:55 PM
Okay, I have one for you. I cannot get the arrival time at the intercept. Here is the information:
Time of day = 12:12 (24 hours clock)
Here are the calculations I have done so far.
Uboat = Nautical M = 102.2 which equals 6.01 hours at 17 kts = 0.3 time in days
Target = NM = 151.4 = 25.23 hrs = 1.1 days
So what I need to know is what time of the day or night will the target (convoy) reach the intercept point?
I need help.
Rob
First, to determine an intercept course you need to know:
1) Convoy Heading
2) Convoy Speed
3) Intercept Speed
4) Convoy Bearing
In which case you can calculate time of intercept if you know a fifth variable...
5) Distance to Convoy
If you want to set time as the constant, you can solve for speed to achieve the time.
I don't think I see numbers 1, 4 or 5 provided in your description. ...and if you've calculated an intercept point and the time to traverse for uboat and target are different; that's not a valid point of intercept cuz the times should be equal.
You don't really need to know 1, 2, 3, 4, or 5 to solve my equation at mentioned above. However here it is
1 = North
2 = 6 kts
3 = Uboat - variable but use 17 kts.
4 = 90° as the Uboat is travelling 270°
5 = 102.2 nautical miles.
Oh, and by the way the convoy has to travel 151.4 nautical miles for the intercept for wich I got the first mention information
I need the time equation set so that I can plug in various variables to pick an appropriate time of intercept that I LIKE.
Okay, I have one for you. I cannot get the arrival time at the intercept. Here is the information:
Time of day = 12:12 (24 hours clock)
Here are the calculations I have done so far.
Uboat = Nautical M = 102.2 which equals 6.01 hours at 17 kts = 0.3 time in days
Target = NM = 151.4 = 25.23 hrs = 1.1 days
So what I need to know is what time of the day or night will the target (convoy) reach the intercept point?
I need help.
Rob
First, to determine an intercept course you need to know:
1) Convoy Heading
2) Convoy Speed
3) Intercept Speed
4) Convoy Bearing
In which case you can calculate time of intercept if you know a fifth variable...
5) Distance to Convoy
If you want to set time as the constant, you can solve for speed to achieve the time.
I don't think I see numbers 1, 4 or 5 provided in your description. ...and if you've calculated an intercept point and the time to traverse for uboat and target are different; that's not a valid point of intercept cuz the times should be equal.
You don't really need to know 1, 2, 3, 4, or 5 to solve my equation at mentioned above. However here it is
1 = North
2 = 6 kts
3 = Uboat - variable but use 17 kts.
4 = 90° as the Uboat is travelling 270°
5 = 102.2 nautical miles.c
Oh, and by the way the convoy has to travel 151.4 nautical miles for the intercept for wich I got the first mention information
...well are you quizing me on what's the equation and you already know the answer or are you looking for help with solving the problem?
Direction your uboat is travelling is irrelevent since you're solving for what course to take for the intercept. For that example the intercept course would be 0° and you're just trailing the convoy. That's just solving a two-trains type of problem I guess. Assuming train A is travelling at x speed when will train B overtake at y speed? Is that what you're talking about?
robj250
09-04-07, 06:09 PM
Okay, I have one for you. I cannot get the arrival time at the intercept. Here is the information:
Time of day = 12:12 (24 hours clock)
Here are the calculations I have done so far.
Uboat = Nautical M = 102.2 which equals 6.01 hours at 17 kts = 0.3 time in days
Target = NM = 151.4 = 25.23 hrs = 1.1 days
So what I need to know is what time of the day or night will the target (convoy) reach the intercept point?
I need help.
Rob
First, to determine an intercept course you need to know:
1) Convoy Heading
2) Convoy Speed
3) Intercept Speed
4) Convoy Bearing
In which case you can calculate time of intercept if you know a fifth variable...
5) Distance to Convoy
If you want to set time as the constant, you can solve for speed to achieve the time.
I don't think I see numbers 1, 4 or 5 provided in your description. ...and if you've calculated an intercept point and the time to traverse for uboat and target are different; that's not a valid point of intercept cuz the times should be equal.
You don't really need to know 1, 2, 3, 4, or 5 to solve my equation at mentioned above. However here it is
1 = North
2 = 6 kts
3 = Uboat - variable but use 17 kts.
4 = 90° as the Uboat is travelling 270°
5 = 102.2 nautical miles.c
Oh, and by the way the convoy has to travel 151.4 nautical miles for the intercept for wich I got the first mention information
...well are you quizing me on what's the equation and you already know the answer or are you looking for help with solving the problem?
Direction your uboat is travelling is irrelevent since you're solving for what course to take for the intercept. For that example the intercept course would be 0° and you're just trailing the convoy. That's just solving a two-trains type of problem I guess. Assuming train A is travelling at x speed when will train B overtake at y speed? Is that what you're talking about?
???
Bsically I want to know what time from 12:12 to an intercept point on the bearing the sub takes and the speed the sub has to travel in order to intercept, so I would have to determine the distance to travel on the bearing I am taking to the intercept the north travelling convoy, so therefore I would have to calculate the distance for the convoy to the new point I chose for the sub to intercept. Does that make sense?
So therefore the information I gave first was hythetical.
So I would already know 1, 2, 3, 4, 5 - that's how I arrived at the hypthetical information in relation to time.
robj250
09-04-07, 06:47 PM
Let's look at it in a different light.
I know the convoy is travelling north at 6 kts.
The time is 12:12
I have to travel west to intercept
So, I need a hypothetical equation which would give me a suitable time that I would like to use to intercept.
If I were to travel west a distance of 102.2 nautical miles I would intercept the the north travelling convoy (6 kts) and it would be 151.4 nautical miles for the convoy to reach my point.
Therefore, I need to know the time from 12:12 to ??? for the intercept, and if the time is not suitable, I change the variables for the diatance the convoy has to travel and the distance I would have to travel, say if I went NW instead of W, or I went SW instead of W, so I would need to know the time of day it would be for the intercept if I used that information.
It is the time of day that I am trying to find is when the variables are changed with the start time as 12:12
It would also give me information as to how fast I would have to travel.
So what I am looking for, is a variable equation using, distance for both, with the convoy being constant at 6 nts but I woula have to figure out how fast I would have to travel to reach the intercept, on the course I choose.
Hope this clarifies the situation. As for me, it is clear as mud.
Rob
joegrundman
09-04-07, 07:09 PM
Assuming i understand your problem correctly, which is far from certain, you want to know how long it takes a 6kt convoy to travel 154nm. That's 154nm/6kts=25.66hours=25 hours and 40minutes. Eta from 1210 departure is 1350 the following day, assuming no change in time zone.
I'm not sure why you have measurements in nm tho. But basically nm/kts=time in hours.
robj250
09-04-07, 07:52 PM
Assuming i understand your problem correctly, which is far from certain, you want to know how long it takes a 6kt convoy to travel 154nm. That's 154nm/6kts=25.66hours=25 hours and 40minutes. Eta from 1210 departure is 1350 the following day, assuming no change in time zone.
I'm not sure why you have measurements in nm tho. But basically nm/kts=time in hours.
Okay, let's use km.
Convoy heading N has to go 280 km to reach a point where the sub has to go 189 km to meet at a 90 deg angle. So what I an hoping for is a formula that I can use that having a constant 6 kts for the convoy and travelling N.
What I need is a formula that I can plug figures in for the distance I have to travel and at what speed I have to travel to intercept at a suitable time I prefer.
Convoy 6 kt = ?? distance
Uboat speed ? distance ??
Time at start = 12:12
Want to know time of intercept to see if it is suitable for me, so that I can change the variable to achieve a suitable meet time and the angle I would have to travel to meet that time.
So, if I travel at 17 knots for the distance of 189 km I most certainly arrive too early and would have to wait quite a long time for the convoy to travel at 6 kts the diatance of 280 km to where I am.
So I need to know (by hook and by crook) the course I need to travel to attain a suitable time for me to intercept. Let's say a twilight time of 17:00, or early morning hours, what course I would have to travel.
I know the formula can be designed, because my old math teacher did something like that for me many years ago and he has passed away and I don't have the example.
I know what you're after... but the formula requires the inputs that I previously mentioned.
Look here:
http://xl-logic.com/mobo/tutorial_pics/TSD_20070904_01.png
I adjusted the distances to 100nm for the sub distance and 120nm for the contacts. Intercepts are plotted as red crosshairs for all contacts M1 to M6. Notice that for M1-M3 the intercept solution works for a 5kt speed.
But notice for contacts M4-M5 the blue node is not a valid intercept.
Now you say, "Well, I'll just always assume a right-angle intercept as suggested by the M1 position. In that case, there is only 1 valid solution for speed (5kts) and you would not be able to vary the time.
What you want to figure out is something more like this...
http://xl-logic.com/mobo/tutorial_pics/TSD_20070904_02.png
In which case you need the variables I previously mentioned in order to determine the proper intercept course and speed for an M1 intercept (in this case 228° and 27kts yields a traverse time of 5hrs). Notice the intercept distance of 135 will change as we adjust speed and time. You can't just use a set distance as an input and hope to arrive at the kind of solution you're looking for.
Here's the minimum data required for that solution:
http://xl-logic.com/mobo/tutorial_pics/TSD_20070904_03.png
1) Convoy M1 Heading
2) Convoy M1 Speed
3) Intercept Speed
4) Convoy M1 Bearing
In which case you can calculate time of intercept if you know a fifth variable...
5) Distance to M1 Convoy
...and as previously mentioned, the fact that OwnShip heading is 270° is irrelevent.
robj250
09-04-07, 09:44 PM
@aaronblood
I greatly appreciate all the work you have put into this, but I have no comprehension of your diagrams.
Also, they do not give me what I require which is time of arrival at the intercept point.
Thanks very much for trying.
Rob
See your PM
In the second diagram if the current time is 12:00 then the arrival time at the point of intercept is 12:00 + 5hrs.. or 17:00.
What I'm telling you in the pictures is that the equation for an intercept is based on speed and angles... the only way to vary time for intercept is by adjusting the speed and/or approach angle.
Wait a minute... are you always drawing a right angle like that?
...and you're wanting to use the two sides of the right angle as the inputs? :hmm:
That might be doable. :yep:
robj250
09-05-07, 12:11 PM
Wait a minute... are you always drawing a right angle like that?
...and you're wanting to use the two sides of the right angle as the inputs? :hmm:
That might be doable. :yep:
No. I do not always intercept at a right angle. It just happens to be the easiest to intercept the north bound convoy. It's just whether the time the convoy reaches the point of intercept is SUITABLE for me, not them.
The majority of my intercepts are NOT right angles.
von Zelda
09-05-07, 12:15 PM
I greatly appreciate all the work you have put into this, but I have no comprehension of your diagrams.
Also, they do not give me what I require which is time of arrival at the intercept point.
There is a simple way to determine intercept course but it is alittle hard to put into words. I'll try.
1) Draw a line that represents target's course
2) Draw a line from the target to your ship and beyond.
3) Having a estimate of targets speed in knots, draw a circle from the target's present position with the radius of the circle equal to the speed in knots of the target.
4) At the point that this circle intersects the target's course line, draw another circle with the radius of your boat's speed (usually max. speed of 15 -17 knots depending on weather).
5) Observe the point of this second circle that intersects the line from target to your boat. (It is the second intersect point which gives the smallest angle to intercept.) This the center point for your angle tool. So, using the angle tool, draw a line from the target to the above stated center point and click, then draw the second line of the angle toward the point that the first circle intercepts target's course. Read the angle produced by the angle tool, this is your angle for intercept.
6) Now redraw, using the angle tool, this above angle from your boat's position toward the target's course. This gives you an estimated point of intercept based on the speed of the two boats. Adjust your course. Often you'll want to adjust this angle a little in order to arrive at an intercept point well before the target!
To determine time of intercept:
1) Your speed in knots X 1.852 = kilometers per hour
2) Measure distance to intercept point
3) Estimated distance divided by kilometers per hour (#1) = hours and minutes measured in tenths.
Hope this is helpful.
robj250
09-05-07, 01:33 PM
I greatly appreciate all the work you have put into this, but I have no comprehension of your diagrams.
Also, they do not give me what I require which is time of arrival at the intercept point.
There is a simple way to determine intercept course but it is alittle hard to put into words. I'll try.
1) Draw a line that represents target's course
2) Draw a line from the target to your ship and beyond.
3) Having a estimate of targets speed in knots, draw a circle from the target's present position with the radius of the circle equal to the speed in knots of the target.
4) At the point that this circle intersects the target's course line, draw another circle with the radius of your boat's speed (usually max. speed of 15 -17 knots depending on weather).
5) Observe the point of this second circle that intersects the line from target to your boat. (It is the second intersect point which gives the smallest angle to intercept.) This the center point for your angle tool. So, using the angle tool, draw a line from the target to the above stated center point and click, then draw the second line of the angle toward the point that the first circle intercepts target's course. Read the angle produced by the angle tool, this is your angle for intercept.
6) Now redraw, using the angle tool, this above angle from your boat's position toward the target's course. This gives you an estimated point of intercept based on the speed of the two boats. Adjust your course. Often you'll want to adjust this angle a little in order to arrive at an intercept point well before the target!
I assume I am supposed to do this during the game on the nav map.
To determine time of intercept:
1) Your speed in knots X 1.852 = kilometers per hour
2) Measure distance to intercept point
3) Estimated distance divided by kilometers per hour (#1) = hours and minutes measured in tenths.
Hope this is helpful.
re #2 measure distance to intercept point - pardon my ignorance. but my brain does not function very well with the mental problems I have, so what do I use to measure the distance with to get kilometers?
First off, assisting with intercepts is one of the main reasons why I built MoBo (http://www.subsim.com/radioroom/showthread.php?t=116572). :roll:
However, if you like Excel (http://www.XL-Logic.com), I can lay the calculations bare for you and maybe after reviewing it you will eventually come around to the notion that you can't just build a table of times/speeds/courses for intercepts. There's a reason why navy ships have a maneuvering board station.
Intercept Math in Excel (http://www.xl-logic.com/mobo/intercept_math.zip)
But who knows... maybe you'll be able to piece something together that will help you.
robj250
09-05-07, 03:34 PM
First off, assisting with intercepts is one of the main reasons why I built MoBo (http://www.subsim.com/radioroom/showthread.php?t=116572). :roll:
However, if you like Excel (http://www.XL-Logic.com), I can lay the calculations bare for you and maybe after reviewing it you will eventually come around to the notion that you can't just build a table of times/speeds/courses for intercepts. There's a reason why navy ships have a maneuvering board station.
Intercept Math in Excel (http://www.xl-logic.com/mobo/intercept_math.zip)
But who knows... maybe you'll be able to piece something together that will help you.
Thanks for you input guys.
By using my original spreadsheet and plugging in the Distance Time suggested by von Zelda, the spreadsheet works fine.
Rob
robj250
09-05-07, 04:35 PM
First off, assisting with intercepts is one of the main reasons why I built MoBo (http://www.subsim.com/radioroom/showthread.php?t=116572). :roll:
However, if you like Excel (http://www.XL-Logic.com), I can lay the calculations bare for you and maybe after reviewing it you will eventually come around to the notion that you can't just build a table of times/speeds/courses for intercepts. There's a reason why navy ships have a maneuvering board station.
Intercept Math in Excel (http://www.xl-logic.com/mobo/intercept_math.zip)
But who knows... maybe you'll be able to piece something together that will help you.
Thanks for the Excel sheet. I had to open it with Quattro Pro then save it for the year of my Excel.
I'll try to figure out all this information, and your diragrams using your special tool and the information in the spreadsheet. However, it looks quit complicated for me.
I will send you my re-designed spreadsheet.
Yes, I realize that's why the Navy has a Manouvering board. I bought some of those sheet, but I find it combersome to use.
Thanks Rob
Yes, I realize that's why the Navy has a Manouvering board. I bought some of those sheet, but I find it combersome to use.
Hehehe...
Yeah, I find the paper one's cumbersome to use too! :ping:
;)
vBulletin® v3.8.11, Copyright ©2000-2025, vBulletin Solutions Inc.