Fill in dates & lat/long for weather data

Question

Hi,

I have hurricane data from 4 major hurricanes over the last 2 years.  The data comes in random hourly increments (sometimes 3 hour increments, 6, 9, etc) and I need to fill in the data to make it hourly (with the lat/longs to fill in the coordinates in between the two known points.

Data attached.  Can someone please help resolve this?

Hurricane_Path_Data.xlsx

Claje · Accepted Answer

Hi,

I've attached an example that should help.

Basically I would use the Multi-Row formula tool to get information on the next reported time and location, and then use Generate Rows and some math to figure out how far the hurricane moved (on average) in each hour.  Note that this method provides a linear path for the hurricane, so it does not take into account any possibility for acceleration in one specific hour or anything like that.  You could probably write a more complex algorithm to account for this if you needed a less regimented distance.