Share via

Location Data Type Weather Data Incorrect

Anonymous
2022-01-26T16:21:00+00:00

Hello,

I am attempting to use the "Location" data type to generate historical weather information for certain cities, for example Jacksonville. However, when generating (weather.history.daily).meanprecipitation, I get values that make no sense.

This is obviously incorrect. Jacksonville gets nearly ~75mm of precipitation in an average January. The perplexing bit is that the weather.history.daily values return a very similar value...

But these are still far too low, if added up they only get ~12mm for the month!

What might I be missing? Is the average precipitation expressed over a different time scale than indicated as daily, weekly, monthly, or is there an error in my work? Thank you!

Microsoft 365 and Office | Excel | For business | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-01-26T17:55:20+00:00

    Hi James,

    Thanks for posting in the community.

    According to your description, the data from Excel Data Type is wrong. What if you select the Data Type to Cities, choose the right city, does the same situation exist?

    Also, please provide a screenshot of your Office version. Click Excel in the menu and choose About Microsoft Excel.

    Regards,

    George

    Was this answer helpful?

    0 comments