Distance between 2 points and time taken - Speed keeps increasing as the distance get further why?

Goodluckboss

New Member
Joined
May 25, 2014
Messages
25
Hi guys,

I am trying to calculate the time taken between 2 points for a game with X and Y coordinates.

When I plot in the actual time taken based on the game data, and the X Y coordinates, I can't find a constant speed between them.

I noticed as the distance get further, the speed seems to increase.

Does anyone know where I got the formula wrong?

I am using a simple pythagoras formula to calculate distance between 2 points
 

Attachments

  • Screenshot 2021-05-20 20.38.12.jpg
    Screenshot 2021-05-20 20.38.12.jpg
    221.3 KB · Views: 31

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Your calculations look good to me.
What makes you think they're wrong.
 
Upvote 0
That is because I am trying to reverse engineer the formula used to calculate the march time between 2 X Y coord. However, with an increasing Speed the further the distance, I do not know how to calculate it.

If the distance is 20 vs the distance is 40, the speed is actually different.
 
Upvote 0
Is the speed meant to be constant?
 
Upvote 0
I thought it was but when I compared the actual data vs the calculated data, it seems that there is an acceleration added into it. How would the formula be changed to adapt to an acceleration element in this case?
 
Upvote 0
I've no idea because I have no idea what you are trying to do, or what your formulae are.
 
Upvote 0
Hi,​
as the Velocity formula must be known …​
 
Upvote 0

Forum statistics

Threads
1,214,979
Messages
6,122,557
Members
449,088
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top