Connor Rothschild (Work Log) - Revision history

Connorrothschild: /* Summer 2018 */

2018-07-30T22:29:10Z

Summer 2018

2018-07-27T21:54:21Z

Summer 2018

2018-07-19T21:45:22Z

2018-07-18T21:45:26Z

Summer 2018

2018-07-16T21:47:23Z

2018-07-13T17:18:30Z

Summer 2018

2018-07-11T15:44:18Z

2018-07-09T21:55:50Z

2018-06-29T20:15:36Z

2018-06-29T20:14:38Z

← Older revision		Revision as of 22:29, 30 July 2018
Line 2:		Line 2:

	<onlyinclude>		<onlyinclude>
		+
		+	7/30/2018 -
		+	*Recoded founders' education
		+	*In the process of recoding founders' job experience
		+	*Worked with Minh to test MTurk survey
		+	*Talked through MTurk logistics and strategy with Minh
		+	*Recoded equity and investment variables given new SeedDB data
		+	*Renormalized investment amount based on midpoint of ranges, and upper bounds (upon Hira's request)
		+
		+	7/29/2018 -
		+	*Finalized multiple campuses work, refined addresses
		+	*Upon Hira's request, recoded dead/alive variable for updated accuracy

	7/27/2018 -		7/27/2018 -

← Older revision		Revision as of 21:54, 27 July 2018
Line 2:		Line 2:

	<onlyinclude>		<onlyinclude>
		+
		+	7/27/2018 -
		+	*Recoded founders
		+	*Fixed multiple campuses and cohorts
		+	*Fixed the Google Sheet
		+
		+	7/26/2018 -
		+	*Cleaned up and fixed the Google Sheet with timing info.
		+	*Recoded the employee count variable.
		+	*Normalized investment amount
		+
		+	7/25/2018 -
		+	*Created a comprehensive Google Sheet with new timing info, collaborated with other interns to find data. Cleaned up sheet.
		+
		+	7/24/2018 -
		+	Sick day :(
		+
		+	7/23/2018 -
		+	*Helped Minh with Demo Day information.

	7/19/2018 -		7/19/2018 -

@@ Line 2: / Line 2: @@
 <onlyinclude>
 /18/2018 -
-*Helped Augi with MA cleaning.
+*Helped Augi with MA cleaning
-*Talked to Minh about Demo Day progress.
+*Talked to Minh about Demo Day progress
 /17/2018 -

@@ Line 2: / Line 2: @@
 <onlyinclude>
 /16/2018 -
@@ Line 16: / Line 26: @@
 These new variables can be found in:
-  /McNair/Projects/Accelerators/Summer 2018/'''Crunchbase Info Populated Empty Cells.xlsx'''
+  /McNair/Projects/Accelerators/Summer 2018/'''Crunchbase Info Populated Empty Cells.xlsx''' (OUTDATED:: DON'T USE)
 Upon Ed's approval, I'll move this sheet to replace Cohort Companies in '''The File to Rule Them All'''.

← Older revision		Revision as of 21:47, 16 July 2018
Line 2:		Line 2:

	<onlyinclude>		<onlyinclude>
		+
		+	7/16/2018 -
		+	*Merged cohort company data with Crunchbase data, by doing a Vlookup then cleaning up data. I used a =IF(A2="",B2,A2) formula to merge cells only when blanks were present. This provided us updated data for four columns:
		+	**colocation (removed 6324 blanks)
		+	**codescription (removed 5151 blanks)
		+	**costatus (removed 7342 blanks)
		+	**courl (removed 6670 blanks)
		+	and new columns:
		+	**address
		+	**founded_on date
		+	**employee_count
		+	**linkedin_url
		+
		+	These new variables can be found in:
		+	/McNair/Projects/Accelerators/Summer 2018/'''Crunchbase Info Populated Empty Cells.xlsx'''
		+
		+	Upon Ed's approval, I'll move this sheet to replace Cohort Companies in '''The File to Rule Them All'''.

	7/13/2018 -		7/13/2018 -

← Older revision		Revision as of 17:18, 13 July 2018
Line 2:		Line 2:

	<onlyinclude>		<onlyinclude>
		+
		+	7/13/2018 -
		+	*Using SQL, matched our cohort companies with information from Crunchbase. This gave us a lot of new information, like employee counts, company status, the date founded, and the location of the company. This data can be found here:
		+	/McNair/Projects/Accelerators/Summer 2018/'''Cohort Companies With Crunchbase Info.xlsx'''
		+
		+	7/12/2018 -
		+
		+	*Created 'The File to Rule them All' with finalized info on accelerators, cohort companies, and founders.
		+	*Attempted to match our company data to Crunchbase data with SQL to get more info on companies.
		+
		+	7/11/2018 -
		+
		+	*Worked on LinkedIn Founders data. Cleaned up data, removed duplicates, checked for fidelity.
		+	*Worked with Maxine to finish Crunchbase matching.

	7/10/2018 -		7/10/2018 -

← Older revision		Revision as of 15:44, 11 July 2018
Line 2:		Line 2:

	<onlyinclude>		<onlyinclude>
		+
		+	7/10/2018 -
		+	*Merged Clean Cohort Data (Veeral) and Cohort List (new) in the Accelerator Master Variable List file. Cross-referenced this list with Ed's data sent last week, titled accelerator_data_noflag.txt. We found that there are 4866 more entries in the new merged file, meaning Ed's merging may have dropped valid entries. (This was after filtering the list so we only looked at the accelerators on our list).

	7/9/2018 -		7/9/2018 -

← Older revision		Revision as of 21:55, 9 July 2018
Line 2:		Line 2:

	<onlyinclude>		<onlyinclude>
		+
		+	7/9/2018 -
		+	*Worked with Maxine to remove duplicates/gather clean data for Crunchbase matching

	06/29/2018 -		06/29/2018 -

@@ Line 23: / Line 23: @@
   /bulk/McNair/Projects/Accelerators/Summer 2018/Duplicate Companies.xlsx
-*Dylan taught interns basic Excel skills
+*Dylan taught interns Excel skills
 /26/2018 -

@@ Line 2: / Line 2: @@
 <onlyinclude>
 /28/2018 -
@@ Line 10: / Line 21: @@
 /27/2018 -
 *Finished coding duplicates. Final file can be found at:
-  /bulk/McNair/Projects/Accelerators/Summer 2018/DUPLICATE COMPANIES MASTER SHEET.xlsx
+  /bulk/McNair/Projects/Accelerators/Summer 2018/Duplicate Companies.xlsx
 *Dylan taught interns basic Excel skills