I will have approximately 4 PDF's per week where I need portions transposed into Excel. If things go well, there is a chance for additional files on top of the weekly ones.
Please submit your quote on a per file basis.
Please reference the attached sample PDF and Excel file.
In the spreadsheet, generally if the field is in grey, you do not need to enter it.
This data will always be found on the first page of the PDF. You should be able to see where the fields match up on the PDF. For the Visiting Team and Home Team, the visiting team will always be the first team and only the first word is needed. The home team will be the second team and only the first word is needed.
This data will be found in two places in the PDF. It is labeled Starting Lineups and Substitutes. The transposition of the data should be fairly obvious based on the example. If the data is taken from the Starting Lineups section, StarterInd column in the spreadsheet should be TRUE. If it is taken from the Substitutes section, the StaterInd column in the spreadsheet should be FALSE.
This data is pulled from the PLAY BY PLAY section of the PDF. It will vary what page this is found on. In the sample provided, it starts on page 11 and ends on page 18. The sample provided does not do every line, but all the plays must be completed.
Most of the data should be fairly obvious. The following should be noted:
· The QUARTER column starts on 1. In the PDF, you will see text that says End of Quarter and a summary box. The lines after this should be Quarter 2. There will be 4 Quarters in every game and possibly an overtime (OT)
· The Pos column in the PDF must be split into the letter and number components
· The Clock column must be entered as time. So when it says (15:00) in the PDF, this should be entered as 0:15:00 in Excel.