I have about 1100 Word documents which contain information about Indiana High Schools and their basketball records. I need this data compiled into an Excel form that I have prepared (and begun the compiling). This cannot be done automatically; it must be a manual process, and would be well suited for a data capture shop. In the Excel, there is a school_no field, and this matches the filename of the Word document. Within that Word document, you will find data for the school, such as its mascot and school colors, in the top part of the document. The mascots are already populated within the Excel, but the colors are not. So colors should be populated for each record within the Excel matching that school, but only for the years that are represented in the Excel, and only for the years that are in the Word document. (There may be years in the Word document that are not in the Excel; these are to be ignored as the Excel is the target form that governs the process.) Other information in the detail portion of the Word document (which may be incomplete) is the team’s record (for example “14-06?? means 14 wins and 6 losses for that year), and coach’s name. These must be populated in the Excel when present, and only for the years shown in the Word document. What we will end up with is an Excel having everything populated that is possible to populate, but ONLY for the years and schools already present in the Excel. No records are to be added to the Excel. I will include example files to show you how I have done some of them. Time to complete these tasks ranges from about 10 sec per Word doc to about a minute. So total effort is about 14-15 total hours of work if the process is set up to be efficient.
1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No 3rd party components unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).