Completed

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 £"

Skills: Data Entry, Data Processing, Excel, PDF, Word

See more: 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

About the Employer:
( 1 review ) Pontypridd, United Kingdom

Project ID: #16178420

Awarded to:

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 in 1 day
(234 Reviews)
6.3

15 freelancers are bidding on average £19 for this job

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 in 1 day
(62 Reviews)
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 More

£20 GBP in 1 day
(41 Reviews)
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 More

£20 GBP in 1 day
(99 Reviews)
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 More

£19 GBP in 1 day
(32 Reviews)
5.3
£18 GBP in 1 day
(16 Reviews)
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 More

£18 GBP in 1 day
(28 Reviews)
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 in 1 day
(5 Reviews)
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 More

£17 GBP in 1 day
(6 Reviews)
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 More

£19 GBP in 1 day
(2 Reviews)
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 More

£10 GBP in 1 day
(0 Reviews)
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 More

£13 GBP in 1 day
(0 Reviews)
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 More

£15 GBP in 1 day
(0 Reviews)
0.0
£18 GBP in 2 days
(0 Reviews)
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 in 1 day
(0 Reviews)
0.0