Average Temperature based on Start Date and End Date

Question

I have data in two different files. File 1 contains Start and End Dates. File 2 contains Temperature readings every 10 minutes. I want to get the average temperature (and standard deviation) between start and end dates.

Average Temp by Start and End Date.xlsx

usmanbashir · Answer

@Kris_Farwell - See if this works. The macro will go through each Start/Date record one at a time (instead of everything all at once in previous workflow), then join to your list of dates, filter to records within the date range, then produce your metrics utilizing the summarize tool.

Hope this helps!

AvgTemp_StartEnd_Dates_UsingMacro.yxzp

Kris_Farwell · Answer

Do you have an example of this?

usmanbashir · Answer

@Kris_Farwell - Ahhhh. A batch macro that controls the filter is another option that won't require a join.