===Fall 2017===
<onlyinclude>
[[Julia Wang]] [[Work Logs]] [[Julia Wang (Work Log)|(log page)]]
9/5-9/8/2017 Putting together [[University Patents]] report
*9/5 10-12 Looked at report, created artifacts, cleaned University Patents folder
*9/6 10-12 Spoke with Ed about project organization
*9/7 2:30-4:30 Writing report
*9/8 10-12 Making data into time series: gyear, make tables and charts
9/11-9/15/2017 Deadline: 9/15 - convert data to time-series, new charts
*9/11 10-12 Converting to time-series
*9/12 10-12 Check accuracy, converting to time-series, talked to Jeemin about next project
*9/13 10-12 Fix R&D data, previous SQL code
*9/14 2:30pm-4pm, 10:30pm-12am Fix R&D data
*9/15 10-12, 2-3 join data
9/18-9/22/2017
*9/18 10-12 cleaning data
*9/19 10-12 cleaning data
*9/20 10-12 created time-series data set
*9/21 2:30-4 reran regressions
*9/22 10-12, 2-3 remade charts
9/25-9/29 finish draft
*9/25 10-12 remaking charts
*9/26 10-12 data pull for Augusta University
*9/27 10-12 data pull for Augusta University
*9/29 10-12 reran log regressions
10/2-10/6
*10/2 10-12 work on University Patents draft, close to sending
*10/3 10-12 Distracted by Augusta project, Reorganizing patent database
*10/4 10-12 Reorganizing whole patent database by city, state, pulling Crunchbase data for Augusta
*10/5 2:15-2:45 Augusta patents
*10/6 10-12 Reorganizing patents, figure out misspellings
10/11-10/13
*10/11 10-12 pulling Houston patents
*10/12 10-12 University patents, sent draft to Anne
10/16-10/20
*10/16 10-12 pulled Houston patent addresses
*10/17 10-12 pulled Houston patent addresses
*10/18 10-12 edited University Patents
*10/19 2:30-4:30 edited University Patents, tabled patent database reorganization until it is cleaned by Oliver/Shelby/Ed
*10/20 10-12 edited University Patents
10/23-10/27
*10/23 10-12 editing University Patents
*10/24 10-12 reran regressions, fixed problem with Cornell
*10/25 10-12 sent 2nd draft to Anne
*10/26 2:30-4:30
*10/27 10-12
</onlyinclude>
===Spring 2017===
1/10/2017-1/20/2017 Finished [[Accelerator Seed List (Data)]]
1/23/2017 Working on blog settings, images for the slider, published [[Patents and the Cancer Moonshot: How Subject Matter Eligibility Affects Research]]
2/6/2017 Began proposal on Berkeley/Broad (Harvard+MIT) CRISPR patent dispute
2/13/2017 Working on [[University Patents]], Lit Reviews, determining how to identify patents in database
2/16/2017-2/17/2017 Worked on [[Working with Wordpress]], determined best practices for photo dimensions, created wiki image for the slider, received list of patent assignees from Marcela (in University Patents folder of RDP)
2/20/2017 Working on [[University Patents]], figuring out misspellings within patent data
3/29/2017 Matched ~46,000 entries, working on the ~90,000 that didn't match
4/5/2017 Matched ~128,000 entries, working on the ~6,000 that didn't match
4/10-4/28/2017 Joining information, working on issue brief
===Fall 2016===
08/31/2016 3:00-5:00 Set up work log, looked through new wiki and blog, categorized pages
12/2/2016 1:00-5:00 Accelerators, [[Patents and the Cancer Moonshot: How Subject Matter Eligibility Affects Research]], [[South by South Lawn (Blog Post)|South by South Lawn]], [[Entrepreneurship at Rice in 2016 (Blog Post)|Entrepreneurship at Rice in 2016]] are all in Wordpress
1/10/2017-1/20/2017 Finished [[Accelerator Seed List (Data)]]
1/23/2017 Working on blog settings, images for the slider, published [[Patents and the Cancer Moonshot: How Subject Matter Eligibility Affects Research]]
2/6/2017 Began proposal on Berkeley/Broad (Harvard+MIT) CRISPR patent dispute
2/13/2017 Working on [[University Patents]], Lit Reviews, determining how to identify patents in database
2/16/2017-2/17/2017 Worked on [[Working with Wordpress]], determined best practices for photo dimensions, created wiki image for the slider, received list of patent assignees from Marcela (in University Patents folder of RDP)
2/20/2017 Working on [[University Patents]], figuring out misspellings within patent data
3/29/2017 Matched ~46,000 entries, working on the ~90,000 that didn't match
4/5/2017 Matched ~128,000 entries, working on the ~6,000 that didn't match
4/10-4/28/2017 Joining information, working on issue brief
9/5-9/8/2017 Putting together [[University Patents]] report
*9/5 10-12 Looked at report, created artifacts, cleaned University Patents folder
*9/6 10-12 Spoke with Ed about project organization
*9/7 2:30-4:30 Writing report
*9/8 10-12 Making data into time series: gyear, make tables and charts
9/11-9/15/2017 Deadline: 9/15 - convert data to time-series, new charts
*9/11 10-12 Converting to time-series
*9/12 10-12 Check accuracy, converting to time-series, talked to Jeemin about next project
*9/13 10-12 Fix R&D data, previous SQL code
*9/14 2:30pm-4pm, 10:30pm-12am Fix R&D data
*9/15 10-12, 2-3 join data
9/18-9/22/2017
*9/18 10-12 cleaning data
*9/19 10-12 cleaning data
*9/20 10-12 created time-series data set
*9/21 2:30-4 reran regressions
*9/22 10-12, 2-3 remade charts
9/25-9/29 finish draft
*9/25 10-12 remaking charts
*9/26 10-12 data pull for Augusta University
*9/27 10-12 data pull for Augusta University
*9/29 10-12 reran log regressions
10/2-10/6
*10/2 10-12 work on University Patents draft, close to sending
*10/3 10-12 Distracted by Augusta project, Reorganizing patent database
*10/4 10-12 Reorganizing whole patent database by city, state, pulling Crunchbase data for Augusta
*10/5 2:15-2:45 Augusta patents
*10/6 10-12 Reorganizing patents, figure out misspellings
10/11-10/13
*10/11 10-12 pulling Houston patents
*10/12 10-12 University patents, sent draft to Anne
10/16-10/20
*10/16 10-12 pulled Houston patent addresses
*10/17 10-12 pulled Houston patent addresses
*10/18 10-12 edited University Patents
*10/19 2:30-4:30 edited University Patents, tabled patent database reorganization until it is cleaned by Oliver/Shelby/Ed
*10/20 10-12 edited University Patents
10/23-10/27
*10/23 10-12 editing University Patents
*10/24 10-12 reran regressions, fixed problem with Cornell
*10/25 10-12 sent 2nd draft to Anne
*10/26 2:30-4:30
*10/27 10-12
[[Category:Work Log]]