Daily Archives: 18-October-2020

Lake Water Temperature Report Using Power Query and FILTERXML

I have a cabin in northern Minnesota on a small lake where I have been staying isolated from the rest of the US while COVID rages around me.  I track various lake metrics like height relative to sea level, clarity, and temperature.  I gather this information into a report that I send to the other folks who live on the lake. In this post, I show how I put together a chart of lake water temperature vs time using Excel and Power Query. I also demonstrate how to use the FILTERXML function to parse some rather messy data. I find myself using FILTERXML for data parsing more and more. Continue reading

 
Posted in Cabin, Excel | 1 Comment