Preparing Drive Creation Spreadsheets for Category 1 Games 2014 to Present
Jump to navigation
Jump to search
For games occurring 2014 to present, do the following to prepare drive spreadsheets for later data populating steps:
- Open file marked as DRIVE_CREATION_SPREADSHEET
- Delete all columns not pertaining to drives; that is, only the following columns should remain:
- Add/edit data in the cells each column as follows:
- Instance of (P17) American Football Drive (Q220)
- Occurring in Game (P39) - use the Q number for game that is being indexed
- Part of (P21) - use the Q number for relevant game
- Home Team Score at Start of Play or Drive (P10)
- Visiting Team Score at Start of Play or Drive (P10)
This process will generate Item pages (i.e., Q numbers) for each drive to be used in Drive Data Preparation
Navigation:
- Next procedural step: Preparing Drive Data Spreadsheets for Category 1 Games 2014 to Present
- Previous procedural step: Downloading and Initial Prepping of Spreadsheets for Category 1 Games 2014 to Present
- Return to Data Preparation Procedures