Ukończone

Editing an excel sheet - already produced

I require small edits to an excel sheet that ranks performance of a collection of businesses. The changes are basic. Please review the attached - I require some of the ranking tables to have a different title and some minor changes to calculations.

"Emp vs P&L £" - The title of this is to be changed to "Food Quality" as a %. The most recently inputted week score should become the "PTD" score (4 weeks in each restaurant period) Ranking high - low.

"Staying Legal" - Currently this is accumulative from Weeks 1 - 4, totalling at PTD. As above, I would like the PTD total to be the most recent week's entry. (This is currently the case for a "Sales Budget %" for instance). Ranking unchanged (lowest number, highest ranking)

"Food Gap PTD £" - This is to be changed to "Food GP Var to Target YTD" - As above, the most recent entry becoming the PTD score. This measure is a % to one d.p. Where the highest variance ranks the highest on the tables.

"Wet Gap PTD £" - This is to be changed to "Food GP Var to Target YTD" - As above, the most recent entry becoming the PTD score. This measure is a % to one d.p. Where the highest variance ranks the highest on the tables.

"SPH PTD" - This is to be changed to "Upsell £ per NOM" this is cash number to 2 d.p (£2.04) for instance. Where the highest number ranks the highest on the tables.

"Local / National / Guest £" - Changed to "Dessert Penetration" as a % whole number. Ranking highest to lowest.

New "Food Quality" measure to be placed on summary rankings sheet next to "Open Complaints"

"Dessert Penetration" measure to be placed on summary rankings sheet in place of "Penetration PTD"

"Penetration PTD" mesure to placed on summary rankings sheet in place of "Food Quality" (is currently "Emp vs P&L £"

Umiejętności: Wprowadzanie danych, Przetwarzanie danych, Excel, PDF, Word

Zobacz więcej: excel sheet calculations hotels reservations, excel sheet calculations hotels, getafreelancercom extract data website excel sheet, formatting and editing of worksheet in ms excel, editing and formatting a worksheet, how to edit excel sheet online, how to edit data in excel cell, how to edit an excel spreadsheet that is read only, entering data in excel worksheet, what is editing in ms excel, editing a worksheet, data entry, data processing, excel, word, pdf, format and layout, microsoft excel, league fixture excel sheet, creating standalone excel sheet

O pracodawcy:
( 1 ocena ) Pontypridd, United Kingdom

Numer ID Projektu: #16178420

Przyznany użytkownikowi:

TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy

£50 GBP w 1 dzień
(234 ocen)
6.3

15 freelancerów złożyło ofertę na kwotę £19 do tego projektu

MohsanEijaz

Hi I am interested in your project, because I have excellent experience of Excel and VBA. I am interested in your project, because I have excellent experience of Excel and VBA. Mohsan

£21 GBP w ciągu 1 dnia
(62 Oceny)
5.9
dgled

I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced form Więcej

£20 GBP w ciągu 1 dnia
(41 Oceny)
6.0
shafaqat11

Hello Sir, Thank you for posting the project. First! Your satisfaction is my top priority. I am interested in it. If you give me chance then i can start right now and able to provide best results. In short, I cou Więcej

£20 GBP w ciągu 1 dnia
(99 Oceny)
5.7
lpetraru

Hello! I understand the requirements of your project. I have good skills and experience in MS Excel data processing, data scraping, data entry, etc. I finished similar jobs. I have 5 Stars reviews and I offer unlim Więcej

£19 GBP w ciągu 1 dnia
(32 Oceny)
5.3
£18 GBP w ciągu 1 dnia
(16 Oceny)
4.9
rahulrahangdale

Hi I have more than 11 years of extensive experience in all areas of data entry, data mining, data extraction, blog posting, mailing list development. I am expert in Data Entry work with 52 WPM of keystroke spee Więcej

£18 GBP w ciągu 1 dnia
(28 Oceny)
4.6
clearcutwritings

Hi I can help you with your project. I am proficient in excel and can start this task immediately and have it back to you in a couple of hours Please don't hesitate to contact me. Thanks Stephanie

£10 GBP w ciągu 1 dnia
(5 Oceny)
3.6
katiewells3

I am an Australian Business Analyst with 15 years professional experience building automation and reporting solutions using Excel and VBA. I have had a look at the workbook, and can see where the ranking settings hav Więcej

£17 GBP w ciągu 1 dnia
(6 Oceny)
3.3
ahmednm21

Hello Sir, I am EXPERT in excel and data processing, So I am 100% confident that I can make YOUR required edits WITH 100% YOUR SATISFACTION. I review your file and I noticed that is no links between the dashboard Więcej

£19 GBP w ciągu 1 dnia
(2 Oceny)
1.6
stephenwaititu

Hello,I am an experienced , qualified information manager and delight in writing,training in business, case studies course works and term papers. I have participated in several proof reading exercises and in researc Więcej

£10 GBP w ciągu 1 dnia
(0 Oceny)
0.0
supper5guy

Hello there, with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office, i can do the best job in the least time. I will do all and extra to ensur Więcej

£13 GBP w ciągu 1 dnia
(0 Oceny)
0.0
Tanyai

I am able to work efficiently and independently. I respect deadlines and quality checks and take them as a way of proving my service's worth. My number one goal is to ensure that you are satisfied with the final produc Więcej

£15 GBP w ciągu 1 dnia
(0 Oceny)
0.0
£18 GBP w ciągu 2 dni
(0 Oceny)
0.0
utkarshv43

Dear employer, I have read your requirements explicitly and I firmly believe that I can do it. As I have done this type of work before so I can assure you the best quality work at your prescribed time.

£10 GBP w ciągu 1 dnia
(0 Oceny)
0.0