Changes

912/54-912/8/2017 Putting together finalizing [[University Patents]] report*12/4 9-12 edits, sent to Ed, confirming catering for party*12/5 109-12 Looked at reportfinal edits, created artifacts, cleaned University Patents foldersent to Ed*912/6 1-4 making City Agglomeration graphics*12/7 1-3 wrapping up everything 11/27-12/1 *11/27 10-12 Spoke with edits, sent to Ed about project *11/29 10-12 catering order for lunch party, wiki page organization*911/7 30 2:30-4:30 Writing reportedits*12/1 10-12 met with Ed, edits 11/20-11/22 *11/20 10-12 edits*11/21 10-12 met with Ed, edits*11/22 10-12 met with Ed, edits 11/13-11/17 deadline 11/16 final draft*11/13 10-12 redoing reg table*11/14 10-12 edits*11/15 10-12:30 edits*11/16 2:30-4 met with Ed, edits*11/17 10-12 edits 11/6-11/10 deadline 11/16 final draft*11/6 10-12 4th draft*911/8 10-12 Making data into time seriesmet with Ed, editing*11/9 2:30-5: gyear30 redoing graphs, restructuring introduction*11/10 10-12, make tables and 3-4:30 redoing charts, rewriting body 10/30-11/3 deadline 11/16 final draft*10/30 10-12 revisions*10/31 10-12 revisions*11/1 10-12 revisions, new data for basic funding*11/2 10-12 revisions

910/1123-9/15/2017 Deadline: 910/15 - convert data to time-series, new charts27*910/11 23 10-12 Converting to time-seriesediting University Patents*910/12 24 10-12 Check accuracyreran regressions, converting to time-series, talked to Jeemin about next projectfixed problem with Cornell!*910/13 25 10-12 Fix R&D data, previous SQL codesent 2nd draft to Anne*910/14 26 2:30pm30-4pm, 104:30pm-12am Fix R&D data30 revisions*910/15 27 10-12, 2-3 join datasent 3rd draft

910/1816-910/22/201720*910/18 16 10-12 cleaning datapulled Houston patent addresses*910/19 17 10-12 cleaning datapulled Houston patent addresses*910/20 18 10-12 created time-series data setedited University Patents*910/21 19 2:30-4 reran regressions:30 edited University Patents, tabled patent database reorganization until it is cleaned by Oliver/Shelby/Ed*910/22 20 10-12, 2-3 remade chartsedited University Patents

910/2511-910/29 finish draft13*910/25 11 10-12 remaking chartspulling Houston patents*910/26 10-12 data pull for Augusta University*9/27 10-12 data pull for Augusta University*9/29 10-12 reran log regressionspatents, sent draft to Anne

9/25-9/29 finish draft*9/25 10-12 remaking charts*9/1126 10-12 data pull for Augusta University*9/27 10-12 data pull for Augusta University*9/29 10-12 reran log regressions 9/1318-9/22/2017*9/18 10-12 cleaning data*9/11 19 10-12 pulling Houston patentscleaning data*9/20 10-12 created time-series data set*9/21 2:30-4 reran regressions*9/12 22 10-12 University patents, sent draft to Anne2-3 remade charts

109/1611-109/15/2017 Deadline: 9/2015 - convert data to time-series, new charts*109/16 11 10-12 pulled Houston patent addressesConverting to time-series*109/17 12 10-12 pulled Houston patent addressesCheck accuracy, converting to time-series, talked to Jeemin about next project*109/18 13 10-12 edited University PatentsFix R&D data, previous SQL code*109/19 14 2:3030pm-44pm, 10:30 edited University Patents, tabled patent database reorganization until it is cleaned by Oliver/Shelby/Ed30pm-12am Fix R&D data*109/20 15 10-12 edited University Patents, 2-3 join data

109/235-109/27*108/23 10-12 editing 2017 Putting together [[University Patents]] report*109/24 5 10-12 reran regressionsLooked at report, fixed problem with Cornellcreated artifacts, cleaned University Patents folder*109/25 6 10-12 sent 2nd draft to AnneSpoke with Ed about project organization*109/26 7 2:30-4:30 Writing report*109/27 8 10-12 Making data into time series: gyear, make tables and charts