# Google Sheets Havesine in Thunkable / almost converted

**URL:** https://community.thunkable.com/t/google-sheets-havesine-in-thunkable-almost-converted/2758910
**Category:** Questions about Thunkable X
**Created:** [December 23, 2023, 10:26pm UTC](https://community.thunkable.com/t/google-sheets-havesine-in-thunkable-almost-converted/2758910 "2023-12-23T22:26:44Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![cresto.pgaxq2](https://avatars.discourse-cdn.com/v4/letter/c/8edcca/32.png) [@cresto.pgaxq2](https://community.thunkable.com/u/cresto.pgaxq2)
#### Post date: [December 23, 2023, 10:26pm UTC](https://community.thunkable.com/t/google-sheets-havesine-in-thunkable-almost-converted/2758910/1 "2023-12-23T22:26:44Z")

</div>

Hey hey everyone ,

I’ve been working on executing the Google sheets havesine formula to the highest level in Thunkable.

When building a current app and converting to yards , I’ve found the current ones weren’t 100%.

Almost there.

I have it broken down to the point where it needs to combine

Sin1+Cos1xCos2xSin2

And find the Atan2.

The first part last calc seems simple but it doesn’t calculate correctly.

I also used the formula of a young man who created the Atan2, it doesn’t seem to be working as well.

I have included the link with of the details from another solid thunker I’ve been corresponding with.

I kept getting different data in Thunkable than Google sheets.

Would love to solve this one. So close to full conversion.

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [December 24, 2023, 12:26am UTC](https://community.thunkable.com/t/google-sheets-havesine-in-thunkable-almost-converted/2758910/2 "2023-12-24T00:26:25Z")

</div>

I’m removing your link to our private messages but including a link to your original topic. It’s best to add details to the existing topic rather than starting a new one. That way, people have the background info that you’ve already discussed here.

Original topic: [Haversine Formulas (Or ACOS/COS/SINor SQT) Not functioning with Sensor Location](https://community.thunkable.com/t/haversine-formulas-or-acos-cos-sinor-sqt-not-functioning-with-sensor-location/2753592)

---

<div class="post-metadata">

### Author: ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [December 24, 2023, 7:36pm UTC](https://community.thunkable.com/t/google-sheets-havesine-in-thunkable-almost-converted/2758910/3 "2023-12-24T19:36:35Z")

</div>


