Entry of Lighting from PDF Catalogue and File Renaming
$2-8 AUD/小时
Hello,
We have a PDF of lighting products which need to be entered into an excel spreadsheet. The spreadsheet already has the prices and the product code. The rest of the information needs to be entered in from the catalogue.
The fields are :
- Product name (Just a description of the light, ie Hanging light, or wall light, or large lamp post(
- Collection Name (common to 4-6 products at at time)
- Description (this comes from the PDF and is listed on the side for a group of products)
- Category (You need to pick whether a light is outdoor wall lighting, outdoor lamp post or if appropriate, consult us on the creation of new category type)
- Finish Shown ( if the light comes in multiple finishes, you need to list them in a list in one field, but on separate lines)
- Other versions (If the light comes in other models, they also need to be listed here)
- Page number of the Catalogue
- Size
- Units (ie mm or cm)
- Width (if applicable)
- Diameter (if applicable)
- and creating a new column for new types of measurements as they arise (i.e. Max Drop, Min Height etc)
- Number of Lights
- Type of Light ( e.g. E27)
- Outdoor Rating (ie IP44)
The source of this data is in a PDF. We currently have the first 100 pages of the 187 page catalogue. We will supply the excel spreadsheet with test data for you to help you understand.
The last part, and most important part : We will supply you with images of the lights. You must search through the photos and find the matching light from the catalogue. You must then rename the photo file to the EXACT code specified in the excel spreadsheet. Some of the photos are missing (you would note that in the excel spread sheet) and some are poorly labeled, so sometimes needs to be done by inspection.
It is better if :
- You use a Mac and have Numbers available
-
I realised it would be more helpful if I gave you more specific details. The excel file is attached. It explains what is required in the text above the columns. The catalogue is also attached (18mb).
N.B. If you have a mac and can use Pages, please let us know, because we will have to go through and add the images to the spreadsheet in Pages, so would save us time if you could do it as you go.
项目ID： #4284175
关于项目
授予：
Hello dear Sir/Ma'am. I am a highly qualified, certified, talented and highly professional MS Office, Adobe Acrobat, Adobe LiveCycle Form Designer, Adobe Photoshop and Adobe Illustrator expert. I have exceptional s 更多
有14名威客正在参与此工作的竞标，均价$6/小时
Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards
Hi there I have good attention to detail and sure can help for this project. Ready to start..
I am fast, efficient and accurate (somewhat pedantic and detail oriented!), and deliver quality work. I would enjoy working on a project such as yours. I am available to start immediately.
I'm interested in the proposed project. I leave a private message with more information. Yours faithfully
I can do it for you as I am having a good typing speed, and have been working on net for quite a long time now. Thanks.
