Wednesday, June 26, 2013

Excel/Data Enry/New Spreadsheet from Given One





Job Posting Link: https://www.odesk.com/jobs/~01bf38f90a8fc49f1c 


Job Description:


 "Please take a look at the attached spreadsheet called Current Alliance Inventory.  There is also another spreadsheet attached to this Post called Sample Template.  The Sample Template is the template that you will be working with and this is the spreadsheet that you will be inputting the data into.

The task is for you to Data Enter all of the data from Current Alliance Inventory on to the Sample Template.  For the sake of this task while you are inputting the data, Column B  for Machine State will always be Used.

For Column G, the data you will need to enter will always be Yes


For Column S, where it says “price”, I would like for you to look at the Asking Price from the Spreadsheet called Current Alliance Inventory and Add $300 to this Asking Price in order to Complete Column S on the Sample Template Spreadsheet.  For the first product on the Current Alliance Inventory Spreadsheet you will notice that the Asking Price is listed as $500.00  Therefore when you look at the Sample Template, you will notice that the price is $800.00

Column O and Column P on the Sample Template will always be Configurable

When you are looking at the Current Alliance Inventory spreadsheet and in Column E you will see a number listed for Avail. Qty.  Whatever number is listed there is the amount of times you will need to enter this particular “product” on to the Sample Template.  For the first product on the Current Alliance Inventory Spreadsheet you will notice that the number list for the Wascomat W75 machine is 7.  Therefore when you look at the Sample Template, you will see that the Wascomat W75 is listed 7 times on the spreadsheet.


*please note that I have also completed the second product listed (milnor) on the Current Alliance Inventory spreadsheet on to the Sample Template to provide you with a second example of this task

In your response to this Job Post please let me know when you could have this task completed by as time is of the essence.  Thank you""



Client's Feedback: Been using Odesk for quite a while now and this Contractor is the real deal.  Very professional and fast and provides excellent work!  Five Stars all around! 


Screenshot of The Job:



Data Entry

No comments:

Post a Comment