XL Spreadsheet for Range & Bearing - Pensacola Fishing Forum

Go Back   Pensacola Fishing Forum > General Discussion > Reefs and Wrecks

Like Tree1Likes
Reply
 
Thread Tools Search this Thread Display Modes
Old 05-30-2014, 06:50 AM   #1
Senior Member
Trigger
 
Sailorboy's Avatar
 
Join Date: Sep 2011
Location: visit Pcola regulary
Posts: 278
Default XL Spreadsheet for Range & Bearing

in an effort to save a few bucks by not buying a new easy to use GPS... I wanted to take all of the public numbers and calculate range and bearing from the pass. We have gotten the range to work but we cannot get the bearing to work. I don't know if the equation I am using is wrong or not .... any ideas

my equation =(MOD(ATAN2((COS($J$2)*SIN(J3))-(SIN($J$2)*COS(J3)*COS(K3-$K$2)), SIN(K3-$K$2)*COS(J3)),2*PI()))*180/PI()

gotten from
http://deathpod3000.wordpress.com/2009/04/30/how-to-calculate-distance-and-bearing-to-a-latitude-longitude-waypoint-in-excel/

thanks
Sailorboy is offline   Reply With Quote Quick reply to this message
Sponsored Links
Advertisement
 
Old 05-30-2014, 09:35 AM   #2
Kim
Senior Member
Blue Marlin
 
Join Date: Aug 2008
Posts: 4,905
Default

Buy a GPS and then spend all that spare time you have on your hangs rigging your gear and fishing.
Kim is offline   Reply With Quote Quick reply to this message
Old 05-30-2014, 09:44 AM   #3
Senior Member
Grouper
 
Join Date: Sep 2007
Location: Gulf Breeze
Posts: 650
Default

Some people are just to smart for their own good
Keep up the good work !
__________________
Tranquility
31 ft Cape Horn
Twin Suzuki 300's
Trble Make-rr is offline   Reply With Quote Quick reply to this message
 
Old 05-30-2014, 10:09 AM   #4
Senior Member
Trigger
 
Sailorboy's Avatar
 
Join Date: Sep 2011
Location: visit Pcola regulary
Posts: 278
Default

LOL.... yea, I know I'm a tightwad.. I keep using the excuse that I am learning something new
Trble Make-rr likes this.
Sailorboy is offline   Reply With Quote Quick reply to this message
Old 05-30-2014, 10:25 AM   #5
Senior Member
Grand Slam
 
sealark's Avatar
 
Join Date: Sep 2007
Location: Pensacola, Sherman Cove Marina
Posts: 8,724
Default

Oops
__________________
I Dont know where I'm going but I damn sure know where i've been

Last edited by sealark; 05-30-2014 at 06:44 PM.
sealark is offline   Reply With Quote Quick reply to this message
Old 05-30-2014, 11:31 AM   #6
Senior Member
Sailfish
 
Stressless's Avatar
 
Join Date: Oct 2007
Posts: 1,501
Default

Mag North or True?
Stressless is offline   Reply With Quote Quick reply to this message
Old 05-30-2014, 04:23 PM   #7
Senior Member
Trigger
 
Sailorboy's Avatar
 
Join Date: Sep 2011
Location: visit Pcola regulary
Posts: 278
Default

Trying for magnetic N..
Sailorboy is offline   Reply With Quote Quick reply to this message
Old 05-30-2014, 06:40 PM   #8
Senior Member
Grouper
 
Join Date: Oct 2007
Posts: 1,051
Default

=if(atan2(cos($h$2)*sin(h2)-sin($h$2)*cos(h2)*cos(i2-$i$2), sin(i2-$i$2)*cos(h2))*57.29578>0,abs(atan2(cos($h$2)*sin( h2)-sin($h$2)*cos(h2)*cos(i2-$i$2), sin(i2-$i$2)*cos(h2))*57.29578-360),abs(atan2(cos($h$2)*sin(h2)-sin($h$2)*cos(h2)*cos(i2-$i$2), sin(i2-$i$2)*cos(h2))*57.29578))

DreamWeaver21 is offline   Reply With Quote Quick reply to this message
Old 05-30-2014, 06:43 PM   #9
Senior Member
Grouper
 
Join Date: Oct 2007
Posts: 1,051
Default

I have a sheet that I post after the weekend.
DreamWeaver21 is offline   Reply With Quote Quick reply to this message
Old 05-30-2014, 07:13 PM   #10
Senior Member
White Marlin
 
chaps's Avatar
 
Join Date: Aug 2009
Location: Milton, FL
Posts: 3,176
Default

pm your email and I will send you a file
chaps is offline   Reply With Quote Quick reply to this message
Reply

Quick Reply
Message:
Options

Register Now

In order to be able to post messages on the Pensacola Fishing Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.
User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.
Password:
Confirm Password:
Email Address
Please enter a valid email address for yourself.
Email Address:
How Did You Find Us?
Tell us how you heard about Pensacola Fishing Forum.

Log-in



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




All times are GMT -4. The time now is 08:09 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO 3.6.0 RC 2
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.