Rafael de Jesus Silva Monteiro rafaeldjsm

## starbuckslocations.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                rafaeldjsm
                / starbuckslocations.ipynb
            
            
              Created
              August 23, 2022 14:11
            
              
                StarbucksLocations.ipynb
              
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## geo-distance-calc.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                rafaeldjsm
                / geo-distance-calc.md
            
            
              Created
              October 26, 2021 18:21
                — forked from richard512/geo-distance-calc.md
            
              
                Calculate distance between lat long coordinates in excel / libre calc
              
          
    Using variables

=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371
Using Cell References

=ACOS(COS(RADIANS(90-A2)) *COS(RADIANS(90-A3)) +SIN(RADIANS(90-A2)) *SIN(RADIANS(90-A3)) *COS(RADIANS(B2-B3))) *6371
That'll work for a table set up like this:


Name
Lat
Long