{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","OriginalURL","SingleDateQuery","TableOfDates","Recap","Sheet4"],"not_rendered":{"charts":0,"images":7,"macros":0,"external_links":1,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2056]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: Tama66 / Pixabay"]

{"sheet":"OriginalURL","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Load data from"]
["https://www.wunderground.com/history/airport/KDFW/2015/1/2/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]

{"sheet":"SingleDateQuery","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"TableOfDates","index":3,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"URL","https://www.wunderground.com/history/airport/KDFW/2015/1/2/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
[null,null,null,"Airport","MCO"]
[null,null,null,"Date","2016-10-01"]
[null,null,null,"Start",{"$f":"\"https://www.wunderground.com/history/airport/K\"&E2&\"/\"","v":"https://www.wunderground.com/history/airport/KMCO/"}]
[null,null,null,"End","/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
[]
["Date","Format","URL"]
[{"$f":"$E$3","v":"2016-10-01"},{"$f":"TEXT(A8,\"YYYY/M/D\")","v":"2016/10/1"},{"$f":"$E$4&B8&$E$5","v":"https://www.wunderground.com/history/airport/KMCO/2016/10/1/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="}]
[{"$f":"A8+1","v":"2016-10-02"},{"$f":"TEXT(A9,\"YYYY/M/D\")","v":"2016/10/2"},{"$f":"$E$4&B9&$E$5","v":"https://www.wunderground.com/history/airport/KMCO/2016/10/2/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="}]
[{"$f":"A9+1","v":"2016-10-03"},"2016/10/3","https://www.wunderground.com/history/airport/KMCO/2016/10/3/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-04","2016/10/4","https://www.wunderground.com/history/airport/KMCO/2016/10/4/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-05","2016/10/5","https://www.wunderground.com/history/airport/KMCO/2016/10/5/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-06","2016/10/6","https://www.wunderground.com/history/airport/KMCO/2016/10/6/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-07","2016/10/7","https://www.wunderground.com/history/airport/KMCO/2016/10/7/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-08","2016/10/8","https://www.wunderground.com/history/airport/KMCO/2016/10/8/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-09","2016/10/9","https://www.wunderground.com/history/airport/KMCO/2016/10/9/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-10","2016/10/10","https://www.wunderground.com/history/airport/KMCO/2016/10/10/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-11","2016/10/11","https://www.wunderground.com/history/airport/KMCO/2016/10/11/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-12","2016/10/12","https://www.wunderground.com/history/airport/KMCO/2016/10/12/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-13","2016/10/13","https://www.wunderground.com/history/airport/KMCO/2016/10/13/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-14","2016/10/14","https://www.wunderground.com/history/airport/KMCO/2016/10/14/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]
["2016-10-15","2016/10/15","https://www.wunderground.com/history/airport/KMCO/2016/10/15/DailyHistory.html?&reqdb.zip=&reqdb.magic=&reqdb.wmo="]

{"sheet":"Recap","index":4,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Episode Recap"]
[]
[null,"Today's trick is adapted from the M is for Data Monkey book"]
[null,"Build a query to get data from one web page"]
[null,"Edit the query to change it into a function with (VariableName)=> before Let"]
[null,"Change the hard-coded URL to VariableName"]
[null,"Rename the query to fxWeather"]
[null,"Close & Load. The data will disappear."]
[null,"Use Excel Trickery to create a table of all URL's"]
[null,"Create a query from that table."]
[null,"Add a new column of Weather = fxWeather([URL])"]
[null,"Expand the column. Uncheck Prefix"]
[null,"Amazing!"]

{"sheet":"Sheet4","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Date","Max Temperature","Min Temperature","Precipitation"]
["2016-10-01","89 °F","71 °F","0.00 in"]
["2016-10-02","90 °F","73 °F","T in"]
["2016-10-03","88 °F","74 °F","0.13 in"]
["2016-10-04","88 °F","75 °F","0.49 in"]
["2016-10-05","92 °F","74 °F","T in"]
["2016-10-06","86 °F","73 °F","1.25 in"]
["2016-10-07","78 °F","76 °F","0.74 in"]
["2016-10-08","89 °F","73 °F","0.00 in"]
["2016-10-09","86 °F","68 °F","0.00 in"]
["2016-10-10","82 °F","65 °F","0.00 in"]
["2016-10-11","83 °F","68 °F","0.03 in"]
["2016-10-12","83 °F","71 °F","0.05 in"]
["2016-10-13","86 °F","69 °F","T in"]
["2016-10-14","85 °F","71 °F","T in"]
["2016-10-15","88 °F","73 °F","0.05 in"]