10===Fall 2017===<onlyinclude> [[Matthew Ringheanu]] [[Work Logs]] [[Matthew Ringheanu (Work Log)|(log page)]] 9/1711/2016 2017 2:00-5:00 pm: Created personal wiki page as well as work log; Read Spoke to Ed about the research project to which I have been assigned; Wrote going forward. Organized the current updated data for our project. 9/12/2017 3:00-5:00 pm: Began going through the Cleaned Cohort Data Excel file and found a short summary few problems with it. Will continue the cleaning process for the rest of what I believe it is the week. 9/13/2017 2:00-5:00 pm: Sorted through Cleaned Cohort Data and finalized our List of Accelerators. We can begin the process of creating our PercentVC table. 9/14/2017 3:00-5:00 pm: Completely finalized our dataset of accelerators and included some helpful linksstartups. Met with Michelle Passo to discuss objectives of the research for credit course. 9/18/2017 2:00-4:00 pm: Talked with Peter about the LinkedIn crawler data. Went through VC page that Meghana sent me.
109/1819/2016 42017 3:00-65:00 pm: Met with research partner Shrey who filled me in on where we are with the project; Began looking on websites Completed SDC pull of certain accelerators for how to determine their cohorts and listed these steps on the wikiupdated VC Data.
109/1920/2016 2017 2:00-5:00 pm: Finished looking on the remaining accelerator websites and wrote the steps on determining how Attempted several times to manually locate run the cohortsMatcher. Cleaned our pulled data.
109/2021/2016 42017 3:00-65:00 pm: Met with Peter and Christy Came extremely close to discuss running the Matcher the correctly. Reviewed the possibility of creating a web crawler that will pull final LinkedIn data from individual accelerator sitesPeter.
109/2425/2016 2017 2:00-5:00 pm: Brainstormed with Albert and Julia about changes to Finalized the category name for SBDE. Spoke to Ed about full scope matched file of accelerator projectcompanies with VC portfolio companies. Gave Ben the data on Georgia accelerators.
109/2526/2016 42017 3:00-65:00 pm: Brainstormed with Shrey about different potential industry focuses within accelerators, as well as different variables Worked on finding the duplicates in our Matched file in order to search for in terms of accelerators, startups, cohorts, etchave the most accurate data.
109/2627/2016 2017 2:00-5:00 pm: Began searching for more databases including lists of accelerators as well as some characteristics of those accelerators; Began searching for characteristics that identify accelerators on their websitesAttempted to find a way to organize the duplicate matches.
109/2728/2016 2017 4:00-65:00 pm: Continued searching for relevant lists of accelerators running through matched data in order to include on our page. Added some links that have high potential under the tab (Obtained from List of Accelerators or various Google searches)organize it effectively.
10/312/2016 2017 2:00-5:00 pm: Began constructing a list of variables that clearly distinguish an accelerator Talked to Ed about next steps for the project. Practiced accessing the crunchbase database on its websiteSQL. This is in an effort to allow a crawler to crawl through many Google searches and identify acceleratorsBrushed up on SQL code.
1110/13/2016 42017 3:00-65:00 pm: Continued looking Searched the database for variables that could identify accelerators from their websites. Searched through numerous different websites of accelerators obtained from our current databasescrunchbase investment information.
1110/24/2016 2017 2:00-45:00 pm: Continued combing through websites of numerous accelerators, well-known Pulled the funding rounds table from SQL and other, matched it with the companies that have received VC funding in the hopes of finding identifying variablesorder to gather round dates.
1110/6/2017 3/2016 4:00-65:00 pm: Finalized my list of variables that could be used Went through the matched data. Brainstormed ways to distinguish get the websites of dates for cohort companies going through accelerators. Slightly re-arranged our list of accelerator databases in order of relevance.
10/11/7/2016 2017 2:00-53:00 30 pm: Began compiling Looked into using the WhoIs Parser in order to find when the list of all companies went through their accelerators. Created a new TextPad document with information from a new database.
1110/812/2016 42017 3:00-65:00 pm: Worked with Shrey Discovered that the Wayback Machine will not be a good option for finding when companies went through their accelerators. Created a list of VCCompanies and their earliest round date. Included a column for the date they went through their accelerators and Ben will fill it in order to compile all when we find a good method of our accelerator databases into one long list on Textpadfinding this date.
1110/916/2016 2017 2:00-53:00 30 pm: Continued formulating a database for all accelerators and all of the available info givenworking on sorting VCCompanies by their earliest round date.
1110/1017/2016 42017 3:00-65:00 pm: Worked with Shrey and Peter in order Ben to develop find a crawler solution to our problem of data acquisition. Finalized earliest round date for f6sVCCompanies.
1110/1418/2016 2017 2:00-5:00 pm: Began sorting Updated our VC data with Ed's help in order to increase the Seed-DB database in an Excel documentaccuracy and completion of our data.
1110/1519/2016 42017 3:00-65:00 pm: Conducted some Google searches Organized all of our matched data and updated it in an attempt order to find more accelerator databasesreflect the most recent SDC pull with Ed. Began looking through Executive Orders searching for keywordsMatched Crunchbase data with our cohort companies.
1110/1620/2016 2017 2:00-53:00 30 pm: Completed searching through Executive OrdersGenerated the new list of VCCompanies as well as their earliest round dates.
1110/1723/2016 42017 2:00-63:00 30 pm: Continued working Worked on Google searches for state accelerator list. Looked through f6s for common words that can be used to distinguish accelerators once we have finalized sorting out the crawlerdiscrepancies in our matched data.
1110/2124/2016 22017 3:00-5:00 pm: Randomly chose 10 accelerators from Excel Went through list of VCCompanies and began adding respective accelerators on the RDP. Went through each website and listed the steps that I took in order to determine whether or not the website belonged to an accelerator. Will continue extracting cohort information tomorrowproceed with VCPercentage table.
1110/2225/2016 42017 2:00-65:00 pm: Listed out all steps for extracting cohort information from the ten randomly chosen accelerators. Worked with Peter in order to build a tool that will search all Continued going through list of the HTMLs VCCompanies and attempt to identify each one as an accelerator as well as extract some basic informationadding accelerators.
1110/2826/2016 22017 3:0030-5:00 30 pm: Merged the F6S accelerator Continued going through list with our other list, then posted it of VCCompanies and adding accelerators. Will have this completed on the project page. Learned process for accelerator data extraction from EdMonday.
1110/2930/2016 42017 2:00-63:00 30 pm: Began process Finished adding all of the accelerators to the list of collecting data from VCCompanies. Added a column indicating whether or not the 20 company went through two or more accelerators that I am responsible for.
1110/3031/2016 22017 3:00-5:00 pm: Continued collecting Began compiling data from accelerators. Finished 15/20in the column for Date Company went through Accelerator.
1211/1/2016 42017 2:00-64:00 pm: Continued collecting data from accelerators. Finished original 20, picked up a new set of 20Finalized entering dates for Y Combinator cohort companies.
12</2/2016 2:00-5:00 pm: Continued collecting data from accelerators. Finished next 20.onlyinclude>
12/8/2016 1:00-3:00 pm: Completed collecting data from accelerators for the semester.===Spring 2017===
1/18/2017 1:00-5:00 pm: Continued collecting data for accelerator project. Helped Catherine draft tweets for the McNair Center twitter account.
5/3/2017 11:00-1:00 pm: Talked to Ed and Anne about future report. Continued working through list of crunchbase potential accelerators. Last day of work for this semester.
9/11/2017 2:00-5:00 pm: Spoke to Ed about the project going forward. Organized the current updated data for our project.===Fall 2016===
910/1217/2017 32016 2:00-5:00 pm: Began going through Created personal wiki page as well as work log; Read about the Cleaned Cohort Data Excel file and found research project to which I have been assigned; Wrote a few problems with short summary of what I believe it. Will continue the cleaning process for the rest of the week.is and included some helpful links
910/1318/2017 22016 4:00-56:00 pm: Sorted through Cleaned Cohort Data Met with research partner Shrey who filled me in on where we are with the project; Began looking on websites of certain accelerators for how to determine their cohorts and finalized our List of Accelerators. We can begin listed these steps on the process of creating our PercentVC table.wiki
910/1419/2017 32016 2:00-5:00 pm: Completely finalized our dataset of accelerators Finished looking on the remaining accelerator websites and startups. Met with Michelle Passo wrote the steps on determining how to discuss objectives of manually locate the research for credit coursecohorts.
910/1820/2017 22016 4:00-46:00 pm: Talked Met with Peter about and Christy to discuss the LinkedIn possibility of creating a web crawler that will pull data. Went through VC page that Meghana sent mefrom individual accelerator sites.
910/1924/2017 32016 2:00-5:00 pm: Completed SDC pull Brainstormed with Albert and Julia about changes to the category name for SBDE. Spoke to Ed about full scope of updated VC Dataaccelerator project.
910/2025/2017 22016 4:00-56:00 pm: Attempted several times Brainstormed with Shrey about different potential industry focuses within accelerators, as well as different variables to run the Matcher. Cleaned our pulled datasearch for in terms of accelerators, startups, cohorts, etc.
910/2126/2017 32016 2:00-5:00 pm: Came extremely close to running the Matcher the correctly. Reviewed the final LinkedIn data from Peter.Began searching for more databases including lists of accelerators as well as some characteristics of those accelerators; Began searching for characteristics that identify accelerators on their websites
910/2527/2017 22016 4:00-56:00 pm: Finalized the matched file Continued searching for relevant lists of accelerator companies with VC portfolio companiesaccelerators to include on our page. Gave Ben Added some links that have high potential under the data on Georgia acceleratorstab (Obtained from List of Accelerators or various Google searches).
910/2631/2017 32016 2:00-5:00 pm: Worked Began constructing a list of variables that clearly distinguish an accelerator on finding the duplicates its website. This is in our Matched file in order an effort to allow a crawler to have the most accurate datacrawl through many Google searches and identify accelerators.
911/271/2017 22016 4:00-56:00 pm: Attempted to find a way to organize the duplicate matchesContinued looking for variables that could identify accelerators from their websites. Searched through numerous different websites of accelerators obtained from our current databases.
911/282/2017 42016 2:00-54:00 pm: Continued running combing through matched data websites of numerous accelerators, well-known and other, in order to organize it effectivelythe hopes of finding identifying variables.
1011/23/2017 22016 4:00-56:00 pm: Talked Finalized my list of variables that could be used to Ed about next steps for distinguish the projectwebsites of accelerators. Practiced accessing the crunchbase database on SQL. Brushed up on SQL codeSlightly re-arranged our list of accelerator databases in order of relevance.
1011/37/2017 32016 2:00-5:00 pm: Searched Began compiling the list of all accelerators. Created a new TextPad document with information from a new database for crunchbase investment information.
1011/8/2016 4/2017 2:00-56:00 pm: Pulled the funding rounds table from SQL Worked with Shrey and matched it with the companies that have received VC funding Ben in order to gather round datescompile all of our accelerator databases into one long list on Textpad.
1011/69/2017 32016 2:00-5:00 pm: Went through the matched data. Brainstormed ways to get the dates Continued formulating a database for cohort companies going through all acceleratorsand all of the available info given.
11/10/11/2017 22016 4:00-36:30 00 pm: Looked into using the WhoIs Parser Worked with Shrey and Peter in order to find when the companies went through their acceleratorsdevelop a crawler for f6s.
1011/1214/2017 32016 2:00-5:00 pm: Discovered that Began sorting the Wayback Machine will not be a good option for finding when companies went through their accelerators. Created a list of VCCompanies and their earliest round date. Included a column for the date they went through their accelerators and will fill it Seed-DB database in when we find a good method of finding this datean Excel document.
1011/1615/2017 22016 4:00-36:30 00 pm: Continued working on sorting VCCompanies by their earliest round dateConducted some Google searches in an attempt to find more accelerator databases. Began looking through Executive Orders searching for keywords.
1011/1716/2017 32016 2:00-5:00 pm: Worked with Ben to find a solution to our problem of data acquisition. Finalized earliest round date for VCCompaniesCompleted searching through Executive Orders.
1011/1817/2017 22016 4:00-56:00 pm: Updated our VC data with Ed's help in order Continued working on Google searches for state accelerator list. Looked through f6s for common words that can be used to increase distinguish accelerators once we have finalized the accuracy and completion of our datacrawler.
1011/1921/2017 32016 2:00-5:00 pm: Organized all Randomly chose 10 accelerators from Excel list of our matched data accelerators on the RDP. Went through each website and updated it listed the steps that I took in order to reflect determine whether or not the most recent SDC pull with Edwebsite belonged to an accelerator. Matched Crunchbase data with our Will continue extracting cohort companiesinformation tomorrow.
1011/2022/2017 22016 4:00-36:30 00 pm: Generated Listed out all steps for extracting cohort information from the new list ten randomly chosen accelerators. Worked with Peter in order to build a tool that will search all of VCCompanies the HTMLs and attempt to identify each one as an accelerator as well as their earliest round datesextract some basic information.
1011/2328/2017 2016 2:00-35:30 00 pm: Worked Merged the F6S accelerator list with our other list, then posted it on sorting out the discrepancies in our matched project page. Learned process for accelerator dataextraction from Ed.
1011/2429/2017 32016 4:00-56:00 pm: Went through list Began process of VCCompanies and began adding respective collecting data from the 20 accelerators in order to proceed with VCPercentage tablethat I am responsible for.
1011/2530/2017 2016 2:00-5:00 pm: Continued going through list of VCCompanies and adding collecting data from accelerators. Finished 15/20.
1012/261/2017 32016 4:3000-56:30 00 pm: Continued going through list of VCCompanies and adding collecting data from accelerators. Will have this completed on MondayFinished original 20, picked up a new set of 20.
1012/302/2017 2016 2:00-35:30 00 pm: Finished adding all of the Continued collecting data from accelerators to the list of VCCompanies. Added a column indicating whether or not the company went through two or more acceleratorsFinished next 20.
1012/318/2017 32016 1:00-53:00 pm: Began compiling Completed collecting data in from accelerators for the column for Date Company went through Acceleratorsemester.
11/1/2017 2:00-4:00 pm: Finalized entering dates for Y Combinator cohort companies.
[[Matthew Ringheanu]] [[Work Logs]] [[Matthew Ringheanu (Work Log)|(log page)]]
[[Category:Work Log]]