Transfer handwritten data into MS Excel
$30-100 USD
Pago na entrega
We need you to transfer handwritten data into an excel spreadsheet. The job is to identify pertinent data from each page and input this information into an excel spreadsheet. There are a total of 147 pages of raw data. Each page contains approximately 16 rows of handwritten data. Deliverable should be a spreadsheet containing approximately 1991 rows of data with five columns.
The expectation is to have a five column spreadsheet. The columns will be:
-Page Number (the page number of the pdf file…not what might be written on the page) Digits only ??" no alpha characters or special characters*. (Column formatted as Number without leading zero, decimals, and comma separators)
-Counted by name (if the box in the upper right hand corner has no written name in it ??" leave it blank)
-Location > Data displayed as: A##A (Capital Letter,Digit,Digit,Capital Letter)
Example: Y09C Note: the leading zero on the numeric portion as needed.*
-5 or 6 digit item number (Column formatted as text ??" HOWEVER, all characters entered will be numeric with leading zeros as indicated in written portion but no decimals or comma separators)*
-Actual physical count
Digits only ??" no alpha characters or special characters*. (Column formatted as Number without leading zero, decimals, and comma separators)
*No special characters: I call Special characters dashes, slashes, dollar signs, and the like. #$%^&*
Attached is a sample of one of the pages.
If we accept your bid, I will ask that you send output for the first four pages of count sheets to me. I can give you some feedback regarding your product to avoid mis-understandings of these instructions.
Let us know when you can have the work delivered by. Indicate a specific date and time.
Finally, the output should be .xls. Do not send .xlsx files.
## Deliverables
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).
Finally, the output should be .xls. Do not send .xlsx files.
* * *This broadcast message was sent to all bidders on Wednesday Nov 3, 2010 12:35:02 PM:
Sample page & output is now posted. Sorry about that, EJ
## Platform
MS Excel (between 2000 and 2007)
ID do Projeto: #3830986