Skip to content

Instantly share code, notes, and snippets.

@tilfin

tilfin/gist:c35d3ee0545b16059860c849da60a114

Created October 13, 2017 06:13
Show Gist options
  • Save tilfin/c35d3ee0545b16059860c849da60a114 to your computer and use it in GitHub Desktop.
Save tilfin/c35d3ee0545b16059860c849da60a114 to your computer and use it in GitHub Desktop.
Download ZIP
スプレッドシートで緯度経度差から距離を算出する
Raw
gistfile1.txt
差の距離をキロメートルで
```
=sqrt(power((<緯度1>-<緯度2>)/0.0111, 2)+power((<経度1>-<経度2>)/0.0091, 2))*1000
```
多分 Excel も同じ
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment