SUBSIM Radio Room Forums - View Single Post

NEOCortex · 05-18-07, 07:39 PM

I figured I'd join this forum and contribute alittle of my own efforts in determining a targets speed and AOB. I've made an excel file which does all my calculations for me.

http://files.filefront.com//;7546056;/

It may help to have some experience with excel to use this, but probably not necessary.

Instructions on this spreadsheet:
Cells in blue are where you input your information, cells in red show the most critical results.
In game, when you want to gather data on a target, set your subs speed and direction, then input your subs speed into the spread sheet.
As quick as possible, get a range/bearing to the target AND start the timer. This will be the range and bearing at time 0 seconds in the spreadsheet.
Keep recording range and bearing data at various times. When you are satisfied or just want results, enter all these readings into the spreadsheet. Extend the formulas in the 6 columns to the right to cover all the entries you just made (if necessary).
Note: DO NOT extend the formulas further then the entered data (w/ the exception of the AOB column), as this will create cells with nonsense values, and these values will screwup the final calculations.

This spreadsheet will take the readings you input and calculate an average speed and heading for the target.
If this is done correctly, then the spreadsheet will calculate the AOB for the all the bearings you took data at, as well as any future bearings you wish to look at.
It will also give you the heading of the target relative to your sub and the targets speed.

Final notes:
These calculations will only work if you use the right units, i.e. meters and seconds.
If you change direction or speed while you're doing this, start over!
If it looks like the target changed direction or speed during this process, start over!
The "averaging" was done by a linear fit of the data provided. See graph in spreadsheet to understand what is going on.
Positive AOB angles imply starboard and negative AOB angles imply port.
The positive x direction was defined as the forward direction of your sub and the positive y direction is defined as right 90 degrees of your sub.

05-18-07, 07:39 PM	#58
NEOCortex Bilge Rat Join Date: May 2007 Posts: 1 Downloads: 0 Uploads: 0	I figured I'd join this forum and contribute alittle of my own efforts in determining a targets speed and AOB. I've made an excel file which does all my calculations for me. http://files.filefront.com//;7546056;/ It may help to have some experience with excel to use this, but probably not necessary. Instructions on this spreadsheet: Cells in blue are where you input your information, cells in red show the most critical results. In game, when you want to gather data on a target, set your subs speed and direction, then input your subs speed into the spread sheet. As quick as possible, get a range/bearing to the target AND start the timer. This will be the range and bearing at time 0 seconds in the spreadsheet. Keep recording range and bearing data at various times. When you are satisfied or just want results, enter all these readings into the spreadsheet. Extend the formulas in the 6 columns to the right to cover all the entries you just made (if necessary). Note: DO NOT extend the formulas further then the entered data (w/ the exception of the AOB column), as this will create cells with nonsense values, and these values will screwup the final calculations. This spreadsheet will take the readings you input and calculate an average speed and heading for the target. If this is done correctly, then the spreadsheet will calculate the AOB for the all the bearings you took data at, as well as any future bearings you wish to look at. It will also give you the heading of the target relative to your sub and the targets speed. Final notes: These calculations will only work if you use the right units, i.e. meters and seconds. If you change direction or speed while you're doing this, start over! If it looks like the target changed direction or speed during this process, start over! The "averaging" was done by a linear fit of the data provided. See graph in spreadsheet to understand what is going on. Positive AOB angles imply starboard and negative AOB angles imply port. The positive x direction was defined as the forward direction of your sub and the positive y direction is defined as right 90 degrees of your sub.