Need data input from 8 PDF files into a single EXCEL sheet.
Will not pay more than $30 for this job so please don't bid above that.
Job needs to be completed within 2 days.
Spreadsheet has many columns but only 6 columns need to be filled out.
Column names to be filled out are ItemSKU, ItemDesc, ItemPrice, FModel, FColor, FBrand
8 PDF's have 29 pages in total.
First 7 PDF's need the following data filled out. (OPAL documents)
ItemSKU(Excel) = Reference(PDF)
ItemDesc(Excel) = Description(PDF)
ItemPrice(Excel) = Gross Unit Price (PDF)
FModel(Excel) = First 7 characters of Reference field (PDF)
FColor(Excel) = Last 3 characters of Reference field (PDF) along with colour listed in Description field (PDF)
FBrand(Excel) = brand name can be found in the Description field (PDF)
For the other pdf the format is slightly different (allison)
Item codes/brand names key
BB = Benetton
BN = Benetton
BE = Benetton
MO = Moschino
RH = Zero RH+
SY = Sisley
fields need to be entered into the spreadsheet in the following format:
ItemSKU(Excel) = ITEM CODE(PDF)
ItemDesc(Excel) = Please fill in item code brand name at the beginning, from the key above, and then add the DESCRIPTION(PDF)
eg. if item code is BB17801 and description field is PLASTIC OPTICAL FRAMES, please fill in spreadsheet with Benetton PLASTIC OPTICAL FRAMES
ItemPrice(Excel) = PRICE - DISC.(PDF)
FModel(Excel) = first 5 characters of ITEM CODE(PDF) eg. if item code is BB17801, FModel will be BB178
FColor(Excel) = last 2 characters of ITEM CODE(PDF) eg. if item code is BB17801, FColor will be 01
FBrand(Excel) = item code brand name, so again using the key above if the item code is BB178, FBrand will be Benetton
Please bid only if you understand the requirements and are sure you can complete the project within the specified time frame (2 days).
Once winning bidder has been chosen documents will be sent.
If completed work is found to be incorrect it will need to be revised and re-completed by winning bidder until satisfactory.
25 фрілансерів(-и) у середньому готові виконати цю роботу за $32
Hello,Done Similar kind of job .... Project will be done with 100% accuracy and perfectly on time.. plz send further details so, i can make sample work for u as well... Waiting for ur reply...Thank You
Ready to start and can assure you that I can complete in time and with better quality according to your requirements. Please check PM for details. Thank you!
HI sir, I have experienced in this job. Just few days before i finished job like this. if you given me this opportunity i will deliver in quality and [login to view URL]
Hello sir, I can do this job for you. I can make 60/pm. Also i'm working manually. Not using any software. You can hire me for your particular job. I'm available into freelancer chat.. Thanks.