The project entails taking a 290 page State School Directory of Private and Public Schools and extracting the following information out of it. The Directory is in a PDF form. Directory will be given to the winner FreeLAncer at the time of selecting him/her. The targeted information in the School Directory is clearly listed by school under each School District Heading. There are 1500 Public Schools and 300 Private Schools listed in directory. The FreeLAncer should use some sort of data grabber (like List Grabber, Address Grabber or software of choice) to highlight the data and extract the data of each school out of the directory and place it in an Excel spreadsheet which is attached below. If you have a better way of doing it great, but the end product must be in an Excel Spreadsheet.
All data in the directory are in columns and rows starting with the first School District on page 55. Below is the data to be extracted and inputted in the Excel Spreadsheet:
District number of School
Principal Name (Included Salutation Mr or Mrs Separately)
Address of School
Email of Principal (must include)
When you finish ALL of the Public Schools entries in the Excel Spreadsheet now go to "Type of School" (Column N) and place the word "Public" in Column N on each school.
When you transition to Private Schools which begins on Page 270 you will perform the same function after going through the whole private list. Then go to "Type of School" (Column N) and place the word "Private" in Column on each of the Private School entries. Note: Headmaster for Private School is the same as Principal. There are no emails for Private School Headmaster. Is there a way to go to each Private School Website and find the email of the Headmaster. This is required in the job. I must have the email of the Headmaster please.
Thank you for viewing. I look forward to working with you!