Work Logs

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.

Carlin Cherry Work Logs (log page)

Albert Nabiullin Work Logs (log page)

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.