Data Entry - Handwritten Data into an Excel SpreadSheet
$30-100 USD
Terminado
Publicado hace más de 11 años
$30-100 USD
Pagado a la entrega
We need you to transfer handwritten data into an excel spreadsheet. Data represents our physical inventory of food and beverages we have in stock.
The job is to identify pertinent data from each page, and input this information into an excel spreadsheet.
There are a total of 132 pages of raw data. Result should be a spreadsheet with 4 columns.
Columns are:
Page Number (from the pdf file)
Row Number
Item Number
Count
Page Number is from the pdf file. Digits only, no alpha or special characters.
Row number corresponds to the row number on each page. Digits only, no alpha or special characters.
The Item number must be formatted as TEXT. No decimals. No special characters. All zeros as written must be entered. You get this from the colum "Item Key" on the typed sheet. Or the column "PAE/UNFI Item No." on the handwritten sheet.
The Count must be Formatted as a number. No decimals no special characters.
Disregard all entries with actual count = 0 , or any blank or crossed out rows.
See attached sample of raw data, and sample output of the Excel spreadsheet.
## Deliverables
Please see attached raw data and desired output on Excel