Convert calculations into simple numbers in an Excel spreadsheet, and other modifications

In Bearbeitung Veröffentlicht Jun 29, 2015 Bezahlt bei Lieferung
In Bearbeitung Bezahlt bei Lieferung

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.

Datenverarbeitung Excel Microsoft Office

Projekt-ID: #7963328

Über das Projekt

24 Vorschläge Remote Projekt Aktiv Jun 29, 2015

24 Freelancer bieten im Durchschnitt $84 für diesen Job

ZAZwork

Dear Concern I am interested in your job post involving these skills. It says that you are looking for someone who knows English & MS Office, also who is a detail-oriented person. I think that I am the right person Mehr

$50 USD in 1 Tag
(130 Bewertungen)
7.5
priyal1997

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, Mehr

$35 USD in 1 Tag
(195 Bewertungen)
6.7
bdoutsource

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 Mehr

$35 USD in 1 Tag
(144 Bewertungen)
6.4
surekash7096

I have the expertise in Excel and can do the conversions very quickly and correctly as you have described. Ready to start work immediately

$77 USD in 1 Tag
(68 Bewertungen)
5.4
teeares

I have completed many projects in Excel. I can do this task quickly and correctly.. Please message me for any clarifications.

$30 USD in 1 Tag
(52 Bewertungen)
5.1
dank111

Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can modify the spreadsheet as desired to be readily importable to InDesign. Please message me so that we can proceed further. Thanks Mehr

$40 USD in 1 Tag
(10 Bewertungen)
4.3
jnekam

A proposal has not yet been provided

$100 USD in 2 Tagen
(12 Bewertungen)
4.0
scientificstuffs

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.

$100 USD in 3 Tagen
(1 Bewertung)
3.0
mdmaroufb

Hi, I am the expert in Copy typing, data entry, data processing, Ms Excel. MS work, This work is very easy for me, I have 12 year experience like this type of work. I think I am the perfect person for your project sir Mehr

$30 USD in 3 Tagen
(9 Bewertungen)
2.5
itsmeagain

A proposal has not yet been provided

$35 USD in 1 Tag
(2 Bewertungen)
1.2
DukhishyamKar

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

$35 USD in 1 Tag
(1 Bewertung)
1.1
salam12894

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 Mehr

$50 USD in 3 Tagen
(1 Bewertung)
0.3
coorymak

A proposal has not yet been provided

$30 USD in 1 Tag
(0 Bewertungen)
0.0
amanbhargava95

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 Mehr

$150 USD in 3 Tagen
(0 Bewertungen)
0.0
pedrohernandez88

La propuesta todavía no ha sido proveída

$155 USD in 3 Tagen
(0 Bewertungen)
0.0
dsloane1234

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.

$30 USD in 1 Tag
(0 Bewertungen)
0.0
Jaskaransingh3

Able to do your work proper as having sufficient knowledge of Microsoft office. Easily understand the project.

$155 USD in 3 Tagen
(0 Bewertungen)
0.0
wtrevormedina

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 Mehr

$111 USD in 3 Tagen
(0 Bewertungen)
0.0
dhavaljvara

A proposal has not yet been provided

$30 USD in 2 Tagen
(0 Bewertungen)
0.0
freelanserr

A proposal has not yet been provided

$155 USD in 3 Tagen
(0 Bewertungen)
0.0