Work Logs

From edegan.com
Revision as of 17:16, 9 March 2016 by imported>Sahil
Jump to navigation Jump to search

Komal Agarwal

Komal Agarwal Work Logs (log page)

20160318 12:00 wiki pages, center presentations

20160318 5:00 working with Harsh on matching coding

20160316 12:00 wiki pages

20160316 5:00 wiki pages, working with team on compiling ecosystem data

20160314 12:00 wiki pages

20160314 5:00 wiki pages for startup accelerators

20160311 12:00 team meeting, coordinate with team on working on benchmarking accelerators, planning wiki pages based on our data

20160311 5:00 compiling pages onto the wiki

20160309 12:00 map icons

20160309 5:00 finished creating lists of startups at benchmarking accelerators

20160226 12:00 map icons

20160226 5:00 finished compiling list of icon ideas

20160224 12:00 map information

20160224 5:00 map information, designing map icons

20160222 12:00 map information

20160222 5:00 finished: startup blink information compilation (see: "StartupBlink Map Listed Houston Startups" in Drive) and Houston Startups list compilation (see: "Komal—Houston Startups List" in Google drive), assigned roles to team members

20160219 12:00 compiling map information

20160219 5:00 compiling list of Houston startups through online maps of the startup scene in Houston, continue working on map information document

20160217 12:00 work on compiling map information excel sheet

20160217 5:00 researched startup maps to benchmark against, compiled information on map document, researched entrepreneurship-related organizations, meetups, communities, etc.

20160215 12:00 compile list of questions and deliverables for Houston ecosystem project, meeting with Ed and team to define project goals

20160212 12:00 add time sheet to Wiki, Houston Entrepreneurship Ecosystem Accelerator Research, coordinated brainstorming meeting with team on further defining the project goals

Pedro Alvarez

Pedro Alvarez Work Logs (log page)

20160328-20160404 (Fri, Mon, Wed, Mon) Goal: Match the F500 and VC Backed Data

  • Progress: I encountered plenty of difficulties finding the appropriate data points, formatting the text/sql files, and ultimately performing the match. While I've performed the initial match, I would like to verify that there were no "hiccups" in the importing process. After I'm done with that, I'll pull NAICS codes and match those to the matched VC/F500 companies.

20160325 (Fri): 1:00-Goal: Work on VC/F500 spreadsheets

  • Progress: 4:00- I have extracted information on the industry sectors, dates of financing, and specific location of these firms. Next monday, I want to run the match function, and then really begin analyzing trends in the fortune 500 and VC funding

20160323 (Wed): 1:00-Goal: Look for useful VC data

  • Progress: 4:30- Using sdc platinum, i extracted information about every single vc-backed firm available. this extensive data took a while to organize, but it's finally in an understandable excel format. On friday, i hope to continue with the analysis

20160321 (Mon): 1:00- Goal: Research Fortune 500 companies' composition over time, try to gauge from the data where exactly they

  • Progress: 4:40- I compiled an Excel spreadsheet of F500 companies from 1980-2015, and began working on compiling lists of the largest VC-Backed firms over the same time frame.

20160318 (Fri): 1:33- Goal: Today, I'm continuing on the small business finance/access to capital page on the wiki.

  • Progress: 4:30- I've cleaned up most of my wiki page, and am going to research a new topic for a couple of days.

20160316 (Wed): 1:00- Goal: Continue on Monday's work

  • Progress: 4:30- I've got a more quantitatively fortified section on the credit decline as a factor in small business finance

20160314 (Mon): 1:00- Goal: Move all notes on Small Business access to capital from Google Doc to wiki format.

  • 4:30- Progress: I need to continue doing this task, and additionally, find more general data on how access to capital looks now, and how it may change in the future.

20160311 (Fri): I was in an interview and did not come in today.

20160309 (Wed): 1:00- Goal: Add Graphics to Access to Capital portion, Make headway on the candidates stance section of paper

  • 4:30-Progress: I'm almost done with the access to capital candidate portion, and will review what I have done with Ed.

20160307 (Mon): 12:58- Goal: Finish the Access to Capital portion of my article. Start on overview.

  • 4:30- Progress: I'm done with my access to capital portion, and will trim verbose or unessential portions. I'm also planning on adding more graphics.

20160226 (Fri): I was sick and did not come in today.

20160224 (Wed): 1:10- Goal: Finish some administrative housekeeping tasks and begin writing the article

  • 4:30: Progress: I'm about halfway done with my rough draft of the segment of my article dealing with Access to Capital and how candidates have addressed it.

20160222 (Mon): 1:00- Goal: Continue research on how non-financial governmental institutions influence small business growth

  • 4:24- Progress: I'm wrapping up the research for this article, and plan on starting a first draft this Wednesday.

20160219 (Fri): 1:00- Goal: Continue research on which government-controlled regulations/policies have substantive impacts on small business operation

  • 1:40: Jason and I are shooting to co-author a report analyzing the policies affecting small business, and how they have (or haven't) been addressed in this election so far
  • 4:37: Progress: I've done a bit of research on how access to capital is being address both by the government, and by small business owners. On Monday, I'll look more into how alternative policies (Healthcare, Environmental, Minimum wage, etc.,) policies have affected small businesses.

20160217 (Wed) 1:05- Goal: Get assigned to a new project, as Ed gave his presentation last night.

  • 4:30 Progress: I am researching the effect of various government-controlled/mandated policies on the incubation and development of small businesses.

20160215 (Mon) 12:58- Goal: Help tie up loose ends on GDP/Macroeconomic research pertaining to Ed's Presentation tomorrow

  • 4:30: Progress: I have done all necessary macroeconomic research for the presentation.

20160212 (Fri) 12:56 - Goal: Finish Sanders research, get another project

  • 1:30: Instead of completing the Sanders profile, I am working on collecting data that links growth in innovation/technology sectors to macroeconomic, GDP-based growth.
  • 5:30: Progress: I found a couple of useful studies that indicate a positive relationship between job growth in tech. These data should be useful for Ed's presentation.

20160210 (Wed) 12:02 - Goal: Build wiki page, get assigned to a project, and fill out my work log.

  • 2:00: I completed my first few assignments, and am now working on detailing different POTUS candidates' stances on religious issues
  • 3:30: Progress: I have completed half of Bernie Sanders' religious profile. I plan on finishing the other half this Friday, 2/12.

Ben Baldazo

Ben Baldazo Work Logs (Work Log)

contributing Projects

worklog

2017-11-21: Worked with Ed to set up all of the ground work to begin joining tables for the purpose stated in yesterday's work log. Should be able to finish it upon returning next week, but until then, notes are all held within "Z:\bulk\crunchbase\AccFunding.psql" with the important parts under the header of "From Ed on 21st of Nov. To finish on Nov 27" 2017-11-20: Attempting to link 3 tables from psql crunchbasebulk to find accelerators that have invested in companies. Likely found success with the table "Acc_Funded_Cos" but the investor column is dirty, thus trying to do it cleaner with the aforementioned 3 table link

  • This is all noted in "Z:\bulk\crunchbase\AccFunding.psql" and the code for "Acc_Funded_Cos" is emphasized

2017-09-25: Followed Talk:Ben Baldazo (Work Log) to create documentation infrastructure for Augusta Startup Ecosystem


Carlin Cherry

Carlin Cherry Work Logs (log page)

042216 (Fri) 1:00: last day of mcnair until next year! make sure everything is ready for next year, check edits to women in entrep rough first draft of issue brief. wrap up. party!

042216 (Fri) 3:30:

042016 (Wed) 12:45: determine final report data, start writing

042016 (Wed) 4:15: rough first draft of report completed, party planning for friday coordinated with ed. feeling feverish so i'm taking off 30 minutes early.

041516 (Fri) 12:30: reexamine psql tables and start finalizing data for article. Not sure how much I'll be able to do today since I'm only here for 1 hour; bulk of work happening mon/wed.

041516 (Fri) 1:30: starting refining the data is going to be a beast i don't want to get started today and not be able to finish. So today i'm going to plan the party for friday.

041316 (Wed) 1:00: upload titles table to psql. join tables. reevaluate for how to proceed.

041316 (Wed) 3:00: done! play w results on friday

041116 (Mon) 1:00: play with data tables. We have a working table for total percentage of women, so now do it by state, city, round no. Try to get some solidified results that I can use in the research report. Management meeting @4.

041116 (Mon) 4:30: computer died. left early. need to upload table, join

040816 (Fri) 12:30: reformat tables w new data pulled

040816 (Fri) 3:00: IT WORKS! next steps are to refine data. need: to group by year by percent women CEO's? (although total percentage of women is already minuscule, so I'm not sure how revealing it would be to further group by jobtitle), still have the doctor subset of the data problem. figure out any other things we might want to discover (group by state? city? no rounds?)

040616 (Wed) 1:00: continue w lit review (1.5 hours), one last go at getting commonnames to properly work (1 hour), w remaining time work on either manually assigning womanman variable to names or proceed with data analysis if by some miracle the commonnames thing works.

040616 (Wed) 5:00: lit review, one last go at common names, prepped to join tables before realizing that neither of them had founding dates. repulled data from SDC, ran perl script on it. Friday, start with reformatting tables with new data pulled.

040416 (Mon) 1:00: clean up commonnames data sheet and get that thing up and running correctly! do some work on lit review since i was gone on Friday. management meeting at 4.

left from 2:30-3 for a meeting

040416 (Mon) 5:00:commonnames is still giving us issues. might go through manually on some of them, otherwise discount drs data??

033016 (Wed) 1:00: do a lot of work focusing on the subset of women data dealing w doctors

033016 (Wed) 5:00: did the work but conclusion is that we need to clean up the data sheet - script should be working fine, data is screwy

032816 (Mon) 1:00: sql database stuff (with lit review if i get stuck on databases) plus management meeting at 4

032816 (Mon) 5:00: made mr/mrs tables in sql, resolidified some of the data management

032516 (Fri) 1:00: met w ed for lit reviews, new best practice is going to be doing lit reviews on fridays/ when i don't have comp sci people to help with databases, and doing the data crunching mon/wed/when i have rachel and comp sci.

032516 (Fri) 3:00: worked on lit review list -- only compiled, no analysis yet.

032316 (Wed) 1:00: more database stuff w rachel and ed

032316 (Wed) 5:30: done

032116 (Mon) 1:00: database stuff, management meeting

032116 (Mon) 5:00: done

031816 (Fri) 1:00: meet with rachel and hopefully ed to figure out how to code in SQL

031816 (Fri) 2:00: done

031616 (Wed) 1:00: continue article

031616 (Wed) 2:00: I need to learn SQL coding to make graphs / interpret data before any more substantial progress on the article can be made. Learning to do this on Friday will help.

031416 (Mon) 1:00: sdc pulls with rachel, continue article, management meeting

031416 (Mon) 4:30: all of the above

031116 (Fri) 1:00: continue women article

031116 (Fri) 3:00: set up RDP and mapping software. 1.5 meeting with team. ended with a little research on women article.

030916 (Wed) 1:00: develop women article outline, set first draft goal, continue work

030916 (Wed) 5:00: continued researching article, did SDC platnium pull with Rachel. goal is to be finished with project in 2 weeks.

030716 (Mon) 1:00: post spring break reacquaintance with projects, continue researching environmental impact on small business as part of the larger article on regulation affecting small business, management meeting

030716 (Mon) 5:00: handed off regulation project to pedro, jason, meghana. Starting new issue brief on women in entrepreneurship. had meeting

022416 (Wed) 12:00: finish article, check in w other teams to see how they're progressing

022416 (Wed) 4:00: finished [Business Dynamism in High Tech], watched Rachel do VC data, now researching environmental impact on small business as part of larger article on regulation affecting small business

022216 (Mon) 1:00: write body paragraphs of Business Dynamism article, if Rachel does VC watch/learn from her, management meeting at 3 or 4

022216 (Mon) 4:53: wrote intro, outline, first pp of article, management meeting 3:30-4:40, met w team to get project updates

021916 (Fri) 12:30: continue to research Business Dynamism in High Tech. Meet with Pedro and Jason to see which projects are yielding interesting results.

021916 (Fri) 2:58: worked on short article about business dynamism, hopefully finish in 1 week. hop on with Jason and Pedro researching candidates/regulation after finishing business dynamism article. met w Pedro and Jason for gameplan, met w Rachel and Ed for VC.

021716 (Wed) 12:54: ed's presentation = done. move on to either cultivator article, SBA, or pres candidate-specific research. meet w ed to discuss (since skipped management meeting on Mon, can we hold today?)

021716 (Wed) 2:50-3:30: had to leave for meeting

021716 (Wed) 3:30-5:00: met w Pedro, Jason, Ed and decided how to proceed. I will be researching Business Dynamism in High Tech. Goal is to churn out academic paper or news article from either my, pedro, or jason's research.

021616 (Tues) 1:07: help ed with presentation prep

021616 (Tues) 2:19: wrote RTF doc with relevant slide background information

021516 (Mon) 12:52: meet w Ed's presentation team to crystallize research, I am taking over Julia's portion (market for ideas) because she's not here until Wednesday, management meeting. quick note: glitch happened with my log page and somehow linked it to Ramee's, so "Carlin Cherry1" is my new log page.

021516 (Mon) 4:53: team ed presentation met with ed to discuss presentation, reformatted presentation and ideas (quotes wiki page, etc) but presentation itself still needs a lot of work - will probably be passed off to Rachel and Claudio to finish tomorrow afternoon

Will Cleland

Will Cleland Work Logs (log page)

Meghana Gaur

Meghana Gaur Work Logs (log page)

2017-12-1: worked with ed to build tables with firm/portco data on distance and fund/portco data on performance

2017-11-16: finished calculating great circle distances between firms, portco's, and branch offices (look at roundlinewithgcd table)

2017-11-14: worked on getting all roundline tables down to the firm level, instead of fund; running into small problems with calculating gcd between firms and portco's (will discuss with Ed)

2017-11-14: worked on joining ipo information to roundline; aggregated ipo information to the fund level (rather than fund)

2017-11-09: reloaded firm coords and also fund coords - re-building roundlinewithgcd (code is written, but fund coords weren't correctly loaded, so this code will be re-run), wrote code for fundtofirms and portcotofirms, but this code will be re-run once the firm codes are correctly loaded; working on joining portcoexitmaster to roundlinejoinerlean

2017-11-08: loaded roundlinewithgcd table (calculating gcd between portcos and funds), created GCD example with notes in datawork folder in MatchingEntrepsToVCs, worked on building portcostofirms

2017-11-07: loaded portcocoords table, joined portcocoords to roundlinejoinerlean, calculate gcd distance between funds and portco's, work on joining funds to firms

2017-11-03: loaded table/sql script for firms office locations into vcdb2 with latitude and longitude coordinates; joined coordinates to all clean base tables for firms, funds, branch offices, joined co and fund coordinates to roundlinejoinerlean in new table: roundlinecoords

2017-11-02: met with Ed; loaded tables/sql script for branch office and fund office locations into vcdb2 with latitude and longitude coordinates

2017-10-27: come up with next steps for matching firms to funds - for geocoding branch offices

2017-10-26: update VC Database Rebuild wiki; identify key for bocore table; verify that fundbasecore table was correctly cleaned after being being rebuilt by Ed

2017-10-24: met with Ed to discuss firmbase and branch office tables; find key for firmbasecore table; remove undisclosed firms from both firmbasecore and bocore

2017-10-12: peer edit and put Shelby's blog post into Wordpress; see what needs to be done on VC project; continue literature review for matching models

2017-10-11: finished loading tables (firmbase and branchoffice)

2017-10-6: load data using SQL code into tables, which is on Retrieving US VC Data From SDC

2017-09-29: completed pulling/normalizing data, still need to load data using SQL code into tables, which is on Retrieving US VC Data From SDC

2017-09-28: met with Ed, worked on pulling firm and branch office data from SDC

2017-09-22: join portcos and funds; and begin literature review of matching games/venture capital (located in "Matching Entreps to VC's project folder" on E drive."

2017-09-21: work with Ed on research project

2017-09-19: continue to work on joining portcoexits and roundlinejoiner tables in vcdb2, in MatchingEntrepsToVC folder under project management

2017-09-15: work on joining portcoexits and roundlinejoiner; create txt file called "Notes on Matching Funds to portcos" in the "Matching Entreps to VC's project folder" on E drive.

2017-09-14: build table roundlinejoinerapprop (appropriate the funds between funds; work on joining portcoexits and roundlinejoiner)

2017-09-27: rebuild portcoexits and work on apportioning amounts in roundlinejoiner

2017-09-07: work with Ed to familiarize with SQL script for VC project/vcdb2 database

2017-09-05: receive project from Ed; reacquaint with wiki, RDP, etc.


Jackie Li

Jackie Li Work Logs (log page)

20160420 (Wed) 2:30 Start editing first draft paper with the comments Ed made during our last discussion


20160415 (Fri) 1:00 Fact sheet fact sheet fact sheet

20160415 (Fri) 3:30 Checked out the other top 10 patent trolls

20160413 (Wed) 2:50 - Keep compiling fact sheet

20160413 (Wed) 5:20 - found more statistics on patent trolls. Not sure if all of them are useful.. this is proving to be a difficult task

20160408 (Fri) 1:00 Work on issue brief

20160408 (Fri) 4:00 Met with Ed to discuss his thoughts on the first draft. Currently compiling fact sheet so we have more systematic numbers and facts instead of case study facts.

20160406 (Wed) 3:00 Finish first draft of issue brief today

20160406 (Wed) 5:30 Done with first draft. Got code from Kranthi, have to find files with priority claims.

20160404 (Mon) 2:30 finish the patent data coding

20160404 (Mon) 3:30 done with patent data versions 4.2-4.5, files from earlier versions are not on the bulk drive. Need Kranthi to give me code to search for keywords among all the files to be done with this project.

20160330 (Wed) 2:30 Work on issue brief, learn computer things from Kranthi

20160330 (Wed) 5:30 Working on the patent data stuff with Kranthi, currently looking at v. 4.3 of the USPTO data. Asking Kranthi on how to search patent-claims in the whole folder

20160324 (Fri) 1:00 - Bring Albert up to speed with what Julia and I did last Wednesday, continue refining and adding to the issue brief draft

20160325 (Fri) 4:00 - Fixed up some holes in the draft we created last Wednesday. Found data on Intellectual Ventures, a legitimate PAE and compared it to eDekka. Hopefully Albert will come to work on Monday so we can reconvene, look at our work and decide where to go from there.

20160323 (Wed) 2:15 - Create outline for issue brief, add information to it

20160323 (Wed) 5:15 - Added section "Are Patent Trolls Really that Big of a Problem? + Why Stricter Demand Letter Requirements Isn't the Solution" to the truth about Patent trolls page

20160321 (Mon) 2:30 - Finish classifying the companies eDekka is suing

20160321 (Mon) 4:30 - Goal accomplished

20160318 (Fri) 1:00 - Keep working on companies Edekka sued in 2015

20160318 (Fri) 4:00 - Made progress on classifying Edekka's defendants as small businesses or not. Had big group meeting with the McNair Center.

20160316 (Wed) 2:05 - Keep digging around Judge Rodney Gilstrap

20160316 (Wed) 5:05 - Added a lot of information to the file 'Patent Trolls Data2' (Couldn't figure out how to edit original file). Found that settlements are MUCH more likely in E.D. Texas, maybe because companies are scared they will lose in court? Also started researching companies edekka sued in 2015, and currently classifying each one as a small business or not.

20160314 (Mon) 2:30 - Keep going

20160314 (Mon) 4:30 - Is there something fishy going on with Judge Rodney Gilstrap? Currently using Lex Machina to try and figure out exactly in how many of his terminated cases was a settlement reached. So far it seems like a large majority of his cases reach an out of court settlement, but why? If not, is he more inclined to favor the plaintiff?

20160311 (Fri) 4:00 - Submitted potential tweet, continued working on truth behind patent trolls. Need to get a better understanding on demand letters and how more stringent demand letter requirements may actually hurt patent holders with legitimate concerns.

20160311 (Fri) 1:00 - Continue digging on the biggest PAEs and determine if they are trolls or not

20160309 (Wed) 5:00 - Found direction! Created and working on The Truth Behind Patent Trolls. Excited about where this project is headed.

20160309 (Wed) 2:25 - Research is converging with Albert's. Plan out how we're going to differentiate PAEs within NPEs.

20160307 (Mon) 2:30 - Continue plowing through Innovation Act

20160307 (Mon) 4:00 - Need to differentiate between NPEs and PAEs, read Katznelson Study. Next step is getting a list of all patent cases filed by NPEs and determine how many of those are actually from PAEs.

20160226 (Fri) 1:10 - Continue working on patent legislation

20160226 (Fri) 4:10 - Added a ton of information to Innovation Act. Am currently reading through the act line by line, and writing a summary so I know what points to tackle and further investigate. Lots of articles point to the existence of patent trolls, might have to go dig through data ourselves to determine whether or not this is a salient issue

20160224 (Wed) 2:30 - Determine what deliverables I can create/work on vs. random research

20160224 (Wed) 5:30 - Currently working on patent legislation, in particular the Innovation Act

20160222 (Mon) 2:25 - Work on prize system, not patents

20160222 (Mon) 4:25 - Wrote section 'problems & considerations surrounding the prize system', added material to MIPF page. Might want to move the graph and intro information to the main page?

20160219 (Fri) 1:00 - Continue to work on patent reform wiki page

20160219 (Fri) 4:00 - Researched and wrote summaries on patent reform legislation, did research into and wrote section about the Medical Innovation Prize Fund Act proposed by Bernie Sanders.

20160217 (Wed) 2:30 - Find a new project to work on

20160217 (Wed) 5:30 - Worked on patent reform page, dug into Bernie Sander's stance on how patents are stifling innovation, and his prize system. Working on Medical Innovation Prize Act of 2005

20160215 (Mon) 2:30 - Work on Ed's Talk

20160215 (Mon) 4:30 - Added slides to Ed's presentation, dug into Politifact article about how small businesses are not dying off

20160212 (Fri) 1:00 -Structure Ed's Baker Institute talk, have a rough outline

20160212 (Fri) 4:00 - Have information for a slide on 'Market for Entrepreneurship, met with group and reevaluated/set new goals and outlines for Ed's talk

20160210 (Wed) 14:30 - Work on Ed's Baker Institute Talk

20160210 (Wed) 17:30 - Added in multiple sections in "Regulations in Relations to Small Businesses"; a section on Increasing operational costs from EPA Regulations, writing points on Expansion of Overtime Eligibility. Had a group meeting with the group working on Ed's talk

Albert Nabiullin

Albert Nabiullin Work Logs (log page)

Ramee Saleh

Ramee Saleh1 Work Logs (log page)

20160212 (Fri) 1:30 Add work/time log to wiki page, continue compiling service firms in Houston

20160212 (Fri) 3:45 Met with team, brainstormed research questions, assigned tasks

20160215 (Mon) 1:30 Continue developing questions; adjusted same glitch Carlin mentioned on the Wiki regarding our pages

20160215 (Mon) 5:00 Finished meeting with Ed honing in on research questions and methods

20160219 (Fri) 2:00 Continue inputting addresses into the sheet for the map

20160222 (Mon) 1:30 Continue to organize Excel spreadsheets

20160222 (Mon) 2:25 Finished organizing the Excel spreadsheets; will now create sheet that aligns which companies use which FlexSpaces/Service Firms

20160222 (Mon) 3:10 Finished compiling relevant information; will ask Iris for new task when she returns

20160307 (Mon) 1:40 Finished old tasks; begin researching on TMC

20160310 (Fri) 2:00 Came in late because of lunch meeting (oops); new plan of action: help Komal with Booth startups, continue researching TMC (and their masse exodus), perhaps create skeleton for wiki pages

20160318 (Fri) 1:15 Continued to help Komal with Booth startups

20160318 (Fri) 2:00 Created wikipage for TMC; currently adding content

20160321 (Fri) 2:00 Continue creating wikipage for TMC

20160324 (Mon) 1:00 Help Iris with cleaning lsts

20160404 (Mon) 1:00 Had a team meeting to organize files

20160404 (Mon) 5:00 Finished task!

20160408 (Fri) 2-5 Cleaning up Mathces

20160411 (Mon) 1:00 Check the websites from Houston startup list

20160411 (Mon)

Claudio Sanchez

Claudio Sanchez Work Logs (log page)

2016/02/09(tues) 1:00- work on Mcnair presentation

2016/02/09(tues) 4:00- accomplished

2016/02/10(wed) 3:00- work on entrepreneurial hub page

2016/02/10(wed) 5:00- accomplished

2016/02/15(mon) 3:00- finish up hub data

2016/02/15(mon) 5:00 finished hub data, started looking for quotes for second event

2016/02/16(Tues) 1:00- work on presentation

2016/02/16(Tues) 5:00

2016/02/22(Mon) 3:00- work on STEM grad student data set

2016/02/22(Mon) 5:00 found first 51 MSA's

2016/02/23(Tues) 1:00- work on STEM grad student data set

2016/02/23(Tues) 4:00- finished 51-159 MSA's

2016/02/26(Fri) 3:00- work on STEM grad student data set

2016/02/26 (Fri) 4:30- finished 159-208 MSA's

2016/03/07 (Mon) 3:00- work on STEM grad student data set

2016/03/07(Mon) 5:00 finished 209-277 MSA's

2016/03/08 (Tues) 1:00- work on STEM grad student data set

2016/03/08 (Tues) 4:00 finished 277-404 MSA's

2016/03/11 (Fri) 3:00- work on STEM grad student data set

2016/03/11 (Fri) 4:15 finished 404-449 MSA's

2016/03/14 (mon) 2:45- work on STEM grad student data set

2016/03/14 (mon) 4:30 finished Data Set

2016/03/15 (Tues) 1:00 Organize Baker Data

2016/03/16 (Tues) 4:00- Got all data into Excel

2016/03/16 (Wed) 3:00 Sort Data by Center and type

2016/03/16 (Wed) 5:00- Messed up data, had to start over

2016/03/21 (Mon) 3:00 Sort Data by center and type

2016/03/21 (Mon) 5:00- Finished Sorting data

2016/03/22 (Tues) 1:00- Work on making the data usable

2016/03/22 (Tues) 4:00 sorted into different excel sheets

2016/03/23 (Fri) 3:00- Make graphs out of the data

2016/03/23 (Fri) 5:00 Made a graph for bakers overall output

2016/03/28 (mon) 3:00- Make more specific graphs

2016/03/28 (mon) 5:00 made graphs for several specific things

2016/03/29 (Tues) 1:00- Start making table on different baker outputs

2016/03/29 (Tues) 3:00- finished around half

2016/04/01 (Fri) 3:00- Finish previous project

2016/04/01 (Fri) 5:00 finished/ put on wiki

2016/04/04 (mon) 3:00- Work on hub dataset

2016/04/04 (mon) 5:00- Worked on dataset

2016/04/02 (Tues) 1:00- Work on Hub dataset

2016/04/02 (Tues) 4:00 Worked on Hub dataset

2016/04/03 (mon) 3:00- Work on Hub dataset

2016/04/03 (mon) 5:00- finished Hub dataset

Julia Wang

Julia Wang Work Logs (log page)

12/4-12/8 finalizing University Patents report

  • 12/4 9-12 edits, sent to Ed, confirming catering for party
  • 12/5 9-12 final edits, sent to Ed
  • 12/6 1-4 making City Agglomeration graphics
  • 12/7 1-3 wrapping up everything

11/27-12/1

  • 11/27 10-12 edits, sent to Ed
  • 11/29 10-12 catering order for lunch party, wiki page organization
  • 11/30 2:30-4:30 edits
  • 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
  • 11/8 10-12 met with Ed, editing
  • 11/9 2:30-5:30 redoing graphs, restructuring introduction
  • 11/10 10-12, 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

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 revisions
  • 10/27 10-12 sent 3rd draft

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/11-10/13

  • 10/11 10-12 pulling Houston patents
  • 10/12 10-12 University patents, sent draft to Anne

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

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

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/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/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


David Zhang

David Zhang Work Logs (log page)

20160211 (Thu) 16:00 - Create personal page and work log

20160211 (Thu) 16:15 - Search for startups and add address

20160212 (Fri) 16:00 - Continue adding addresses for startups

20160215 (Mon) 16:00 - Collect information of startups, VCs, incubators, and etc. in Houston

20160217 (Wed) 16:00 - Compile lists of Houston startups, VCs, indubators and etc. in txt files

20160222 (Mon) 16:00 - Collect data of investors, entrepreneurs on Rice Alliance

20160224 (Wed) 16:00 - Collect data of investors, entrepreneurs on Rice Alliance

20160226 (Fri) 16:00 - Collect data of investors, entrepreneurs on Rice Alliance

20160307 (Mon) 16:00 - Finish collecting data of investors, entrepreneurs on Rice Alliance

Alex Jiang

Alex Jiang Work Logs (log page)

Since the three servers were set up right before spring break, I'm moving from testing things on the test webserver to recreating things on the actual webserver. For more detailed notes, see Web Server Documentation.

20160411 pushing forward with creating templates in SMW: I have templates and forms for startups, VC funds, and accelerators. now working on the events between these types of organizations.

20160408 going back to SMW for another crack at implementing inheritance. successfully got a vehicle-bicycle inheritance pair to work (there are templates for both objects, and a form for Bicycle pages that includes both templates)

20160406 playing around with inheritance (aka foreign keys) in Cargo; it didn't work. Then, trying it out in Semantic Mediawiki.

20160330 came up with a SQL table schema for the organizations and events, but had difficulty translating it into Cargo (because I couldn't figure out how to do foreign keys). One option is to just ask for the information common to all organizations in each organization subtype (e.g. startup, VC fund, accelerator, incubator, etc.). Or I could look into #cargo_attach which seems to be helpful in this sort of situation.

20160328 Installed Google Analytics extensions on the test web server and production web server for the Mediawiki sites. I can't install on the test blog because I need port 21 opened, but I think I could install on production blog if I wanted to (because all of its ports are opened).

20160328 Finished example data structure for Cargo. #cargo_query is basically just SQL, which is nice. but creating the templates isn't as easy (honestly, we will probably have to create templates by hand anyways). also, there's native JSON support in cargo, so let's go with Cargo!

20160328 Finished the example data structure for Semantic Forms with a few difficulties. Scaling SF up may be difficult so I'm going to look into Cargo, which will hopefully be simpler.

20160325 Trying out an example for Semantic Forms. Working out the data structure for the Semantic Forms with Ed.

20160325 Installing Semantic Forms

20160325 Installing Semantic Mediawiki, looking into alternatives (Cargo?), investigating bugs in previously installed extensions that may be due to installing from Mediawiki's extension distributor (which isn't necessarily up to date with the repository)

20160323 Turns out Piwik does work (my browser was sending DoNotTrack requests), but Google Analytics is probably more stable in the long run anyways. Also, Semantic Mediawiki (especially Semantic Forms)

20160321 End of Day: Piwik looks promising but I can't confirm that it's tracking anything yet... Also, it may have some complications with MobileFrontend. Also, Semantic Mediawiki (particularly the Halo extension) looks promising but we're not sure if it's well maintained.

20160321 Turns out OWA sucks. Let's try Piwik instead.

20160321 Configuring BibTex extension and Open Web Analytics

20160316 Configuring Google Analytics on mediawiki and on WordPress blog. Maybe we should look into open-source alternatives, e.g. Open Web Analytics and Piwik

20160316 Installing WordPress blog on web server

20160316 Testing infoboxes (got them to work, but I had to remove the custom CSS from Common.css)

20160314 Trying out open-source blogging platforms (Ghost and WordPress)

20160311 Setting up the mediawiki for users and BibTex citations

20160309 working with Julia for the mediawiki CSS. ran into some issues with using custom typefaces, so wasn't able to make further progress.

Sahil Patnayakuni

Sahil Patnayakuni Work Logs (log page)

20160422 (Fri) 1:00 Finalizing design of wiki

20160420 (Wed) 2:00 working on design of webserver wiki

20160415 (Fri) 1:00 Finalizing data structure

20160413 (Wed) 1:30 Continuing to construct data structure

20160408 (Fri) 3:00 Attempting to recreate data structure of organizations and events on testwiki

20160408 (Fri) 1:00 Rechecking to see if semantic mediawiki errors persist

20160406 (Wed) 4:00 After discussion, retrying semantic mediawiki

20160406 (Wed) 1:00 Attempting to create functional Cargo structure for businesses and organizations.

20160404 (Mon) 1:00 Identifying issues with Cargo and attempting to resolve them.

20160330 (Wed) 2:00 Attempting to create data structure for semantic data in Cargo/sql tables

20160330 (Wed) 1:00 Creating example Cargo pages on test wiki

20160328 (Mon) 2:00 Trying out Cargo instead of Semantic Mediawiki because Cargo is closer to SQL puprortedly

20160328 (Mon) 1:00 Attempting to figure out Semantic Forms

20160323 (Wed) 5:10 Attempting to install Semantic Mediawiki on test web server

20160323 (Wed) 2:30 Researching Semantic Mediawiki extensions that could be useful

20160323 (Wed) 2:15 Writing wiki FAQ on using the NormalizeFixedWidth Script.

20160321 (Mon) 1:30 Researching Semantic Mediawiki

20160318 (Fri) 5:00 Documenting Webcrawler success.

20160318 (Fri) 4:00 all Bug cases cleared up working with Will in order to modify data in order to fit into SQL

20160318 (Fri) 1:30 Continue working on webcrawler, all data found clearing up buggy cases.

20160316 (Wed) 1:30 found everything except salary, performance and signing bonus per year, finding those.

20160314 (Mon) 3:15: looking through each player's fanager page to find data.

20160314 (Mon) 1:30: successfully located data, editing wiki for documentation.

20160311 (Fri) 2:00: looking through HTML tables for NHL Data

20160309 (Wed) 4:15: Setting up Komodo IDE on RDP server

20160309 (Wed) 3:30: Set up my personal page and work log page and added to work log page

20160309 (Wed) 3:00: Wrote mac section for how to connect to RDP server and map a network drive in RDP Documentation

20160309 (Wed) 2:30: Created account for myself on RDP server and then connected to it from my laptop.

20160307 (Mon) 3:00: Determined how the data from general fanager was to be structured for the matcher and located data on general fanager

20160307 (Mon) 1:00: Determined what data to search for in general fanager html.

Before spring break 2016 created Govtrack Webcrawler to pull data on relevant bills from the Govtrack API

Retrieved from "http://www.edegan.com/mediawiki/index.php?title=Work_Logs&oldid=40811"