ST Alpha - "LAT! should be LAT1 ..." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 151

In response to "Seriously, I need someone to check my math. I bet Reagen could do it." by loosilu at work

LAT! should be LAT1 ...

Posted by zork Sep 14 '10, 13:42

radians(lat1 *minus* lat2/2) ???

why times 60?

are my first reactions.

Responses:

yeah, I just wrote it as LAT for simplicity here. It's a cell number in excel. - loosilu at work Sep 14, 13:44 14
- Without knowing what the conversion factors are, there is no way to tell you the math is correct, imo. (nm) - musubi Sep 14, 13:45 8
  - hmmmm, what conversion factors are you referring to? -- nm - loosilu at work Sep 14, 13:48 7
    - the 6080 and 60, I'm assuming are unit conversions. (nm) - musubi Sep 14, 13:54 6
      - the 6080 is to convert to feet. I don't know about the 60. - loosilu at work Sep 14, 13:57 5
        
        oh wait, I'm averaging to find the center point. -- nm - loosilu at work Sep 14, 13:58 4
        
        Yes, averging would find the mid-latitude, but why then cosine that? - musubi Sep 14, 14:01 3
        
        I don't know!!! *cries* I know, I know, I have asked him several times to tell me what's what. - loosilu at work Sep 14, 14:07 2
        
        Just put in a series of known points and test if it gives you an accurate reading. - musubi Sep 14, 14:09 1
        
        I am, and it's not. I know I got something wrong. that's why I'm asking. -- nm - loosilu at work Sep 14, 14:28
- times 60 would be for "minutes" but you said the coords are decimal. -- nm - zork Sep 14, 13:45 4
  - the 60 is bothering me. -- nm - loosilu at work Sep 14, 13:49 3
    - me too plus I think you meant ... - zork Sep 14, 13:52 2
      - I have 350 locations, and for each of those I have to find the closest among 120 shelters. It is going to be a spreadsheet with a formula. -- nm - loosilu at work Sep 14, 13:55 1
        
        so far this is the best I can find ... -- (link) - zork Sep 14, 14:07

Post a message top

LAT! should be LAT1 ...

Replies are disabled on threads older than 7 days.