Convert calculations into simple numbers in an Excel spreadsheet, and other modifications
$30-250 USD
着払い
I have an XLS spreadsheet (120 rows by 8 columns) which contains descriptions, caffeine content, price, etc for a number of products. (this is for a store that sells tea).
I need the data from the spreadsheet to be modified so that I can import Sheet 1 into InDesign and make it into a printed menu/catalog.
- The prices are currently calculated by referencing sheet 2. (for example, the price of one of the items looks like this “=VLOOKUP(B25;$Sheet2.$C$4:$U$174;19;0)”) These need to be converted into simple strings of numbers (2 decimal places) with a dollar sign before them, i.e., “$8.99”.
- Column A can be deleted, it is just a spacer.
- In the xls, there is an extra row (colored light grey) for padding between each product. These need to be removed.
- Each category of tea has a "header" row — this can stay, but if possible it would be best if the cells were merged into one, similar to how you can do this in HTML using the “colspan” attribute. (I am not sure if you can even do this with Excel)
- The Caffeine and Antioxidant columns can be deleted
- The remaining columns (Origin, Steep Time, Steep Temperature, and Price per Ounce) should be combined into the Name column.
- The numbers in the temperature column each need to have a degree symbol (°) placed after them.
- The steep time and temperature should be separated by a comma
- “/oz” should be placed after the price
- Each item in this first column should be on its own line.
So after you are finished, each product will consist of just two columns. An example of how this first column should read is:
“Sencha Green
Japan
2-3 min, 175°
$8.99/oz”
And of course the second column is just the description like it is now.
プロジェクトID: #7963328
プロジェクトについて
24人のフリーランサーが、平均$84 で、この仕事に入札しています。
Dear Sir/Madam, I'm happy to help you on this task. I went trough the attachment and descriptions and 100% sure that I can do this perfectly within 1 hour. Awaiting for your feedback to start the task. Best regards, もっと
Dear sir, Greetings. I have understood each and every details that you have described. However, able to complete this within 1 day, just took additional day. Ready to negotiate the bid amount. Let me know if you もっと
I have the expertise in Excel and can do the conversions very quickly and correctly as you have described. Ready to start work immediately
I have completed many projects in Excel. I can do this task quickly and correctly.. Please message me for any clarifications.
hey there, I can do this task easily. you said you have 120 x 8 data description. and you need to get the printed catalogue. I can do it. can you send me the file.
Hi, I am a marketing person and have worked with excel frequently. I can help you by doing up this before end of today. You can rely on me. Thanks
Dear Hiring Manager I have relevant sort of expertise and interested to give my highest effort in making the paper. I have ideas on referencing systems and will ensure the highest standard To satisfy you. Lets d もっと
I have great maths skills and possess sound experience to support this skill. I have been working as a C++ Programming Developer for most of my career and have grown a passion for it. I have a widened knowledge and sou もっと
Highly proficient in using MS Excel formulas and functions to transform data and format its display. Strong typing and data entry skills. Works quickly and efficiently to complete tasks as assigned.
Able to do your work proper as having sufficient knowledge of Microsoft office. Easily understand the project.
I bring with me an advanced Microsoft Office Suite Applications background combined with a focus on Administrative, Customer Service and an extensive IT Background Skill Set. I am a fanatic when it comes to the "s もっと