They say that when you have nothing to talk about, you've got two topics to keep the conversation going: The weather, and Excel. (What, did you think I was going to say sports?) My …
Continue Reading about Review: Visual Crossing Weather for Excel →
Three-way lookups in Excel with SUMPRODUCT()
It's wild to think that everything we do with computers comes down to manipulating its 0 and 1 states. So, it makes sense that using Boolean logic (that is, the manipulation of 0 and 1 or FALSE and …
Continue Reading about Three-way lookups in Excel with SUMPRODUCT() →
Downloading 24-Hour Weather Updates in R
This post serves as a follow-up on a previous post about scheduled collection of Weather.gov's XML feed in R, which itself was a follow-up to retrieving real-time data from Weather.gov in …
Continue Reading about Downloading 24-Hour Weather Updates in R →
Recording Weather.gov History using R and the Windows Task Scheduler
Postscript: Turns out this method using Weather.gov's XML feed is not as effective as using their HTML feed. Check out the HTML sequel here. One of my most popular posts is on retrieving real-time …
Continue Reading about Recording Weather.gov History using R and the Windows Task Scheduler →