Preparing Drive Data Spreadsheets for Category 1 Games 2014 to Present

1. Use Q numbers for each drive generated in previous step
2. Split out P24/P25 columns
3. Convert P27 to seconds from minutes/seconds (use this: Time to Decimal Calculator)
4. Convert P33 to relevant Q numbers as follows:
   1. INT to Q34
   2. MISSED FG to Q31
   3. PUNT to Q37
   4. FG to Q30
   5. TD to Q
   6. END OF HALF to Q
   7. DOWNS to Q

---

Navigation:

• Next procedural step: [[]]
• Previous procedural step: Preparing Drive Creation Spreadsheets for Category 1 Games 2014 to Present

• Return to Data Preparation Procedures