Update Excel Sheet

Fullført Lagt ut 6 år siden Betales ved levering
Fullført Betales ved levering

I manage a group of restaurants and require the attached excel tracker updated to reflect the below with some additions :

I require :

13 Restaurants ranked - with one to be removed in January - this removal needs to be either incorporated into the project or a function provided where restaurants can be added or removed myself.

From the attachment the following restaurants need removing : Arnos

From the attachment the following restaurants need names changing : "Chingford" to "Larkswood" and the "Unicorn" to "Gidea Park"

I require the following KPi Titles changing :

Reputation Score changed to [login to view URL] Review Score - the data should read as "Greyhound 3.8" there will only ever be one decimal place and the highest number should be ranked first and the lowest number ranked last.

"Reactive Call Outs" changed to "Bookings %" with results being recorded as a percentage always to one decimal place. i.e "Greyhound 24.7%" with the highest % being ranked first.

I require the tables to be organised in a different order :

"Penetration" moved next to "SPH £"

"Open Complaints" moved next to "Complaint Ratio"

I require a printable A4 landscape sheet created with 4 further rankings tables using PTD "Combined Score" rankings data :

All restaurants rankings table from PTD sheet "Combined Score" rankings table

East Ranking Table (Title "East" - using same scores from PTD) - Beehive, Compasses, Greyhound, Gryphon, Navigation, Unicorn, Larkswood

West (As above) - Croxley Green, Garston, Jolly Badger, Kings Arms, Oakmere, Windmill

Final Ranking Table : East vs West - Total scores across each area averaged (average score from 7 sites for East and 6 sites for West) So this will just be East and West in this table.

The current tables are already ranking correctly and this needs to remain (i.e highest % first for Sales Budget % and lowest number first for reactive call outs)

The format of entry needs to remain the same aswell as the drop down menu on the "KPi" sheet - "Week 1 -4 and PTD" needs to be available.

"PTD" is accumulation of the following KPi's (The rest of the KPi's appear on the PTD report as whatever the most recent entry is i.e if entry is inputted up to week 3 then week 3 becomes PTD.

Excel Excel Macros Excel VBA

Prosjekt-ID: #15598480

Om prosjektet

22 bud Eksternt prosjekt Aktiv 6 år siden

Tildelt til:

someka

Hi there. I will work on your existing Excel doc and improve it according to your description. Besides those todo's I can also improve the styling and usability. Relevant Skills and Experience Excel, VBA, Data Visuali Mer

£175 GBP på 7 dager
(141 omtaler)
7.1

22 frilansere byr i gjennomsnitt £142 for denne jobben

schoudhary1553

Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. Relevant Skills and Experience I have more than 7 years of experience in E Mer

£200 GBP på 3 dager
(312 Omtaler)
7.9
asin1987

Dear employer, PLease check my reviews on below lik. I have 10 years of experience. I will do this job. Please give an opportunity Relevant Skills and Experience Macro VBA Proposed Milestones £150 GBP - Proje Mer

£100 GBP på 3 dager
(182 Omtaler)
7.6
FINGERRPRINT

Hi there, i have gone through the description. we can do these all changes. Ready to discuss more details in chat. Thank you Relevant Skills and Experience excel Proposed Milestones £221 GBP - excel

£189 GBP på 3 dager
(199 Omtaler)
7.6
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Looking forward to work with you. Thanks & Regards Khushi India Relevant Skills and Experience Excel, Excel Macros, Excel VBA Propo Mer

£210 GBP på 3 dager
(250 Omtaler)
7.0
sisicirnes

Hi there, my name is Irnes, and I'm interested in this project. I'm hardworking and responsible freelancer and successful completion is my main target. Relevant Skills and Experience My best skills are related to data Mer

£150 GBP på 3 dager
(59 Omtaler)
6.6
rohitpithisaria

Hello I am an excel expert and have completed more than 100 projects in excel. The file is password protected, do you have password or should I crack it? Regards Rohit Relevant Skills and Experience Excel Macro vba Mer

£194 GBP på 3 dager
(113 Omtaler)
6.5
caabdul

Hi there, I am Accountant cum excel vba expert so can deliver perfect job. Thanks Relevant Skills and Experience Accounting, Excel, Visual basic Proposed Milestones £300 GBP - Milestone

£300 GBP på 15 dager
(49 Omtaler)
6.1
beltran0404

Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I am excel expert then I can review and update your excel document according to your requirements. Please contact me by chat Mer

£100 GBP på 5 dager
(119 Omtaler)
5.5
suyashdhoot

Hi I am a very experienced statistician and data scientist. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Mer

£250 GBP på 3 dager
(10 Omtaler)
4.9
AhmedHassan1122

Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones £150 GBP - Full Price

£150 GBP på 3 dager
(16 Omtaler)
4.5
chintuag

Dear Hiring Manager, I have read the project description and would like to offer my expertise for the project. I am an expert in excel and have worked on multiple projects. These includes macros, complex formulas, we Mer

£138 GBP på 3 dager
(11 Omtaler)
4.1
ufoteam

Why? Why? why don't you award the project to me ?I really want to get this project. If you can, please contact me and let me know how much your budget is, and I'll try my best to offer you the best price.I will do my b Mer

£150 GBP på 3 dager
(6 Omtaler)
3.3
AnilTitusJacob

You have described the requirements in detail. To insert or remove a hotel we can give TWO buttons. The editing of wordings is easy. The layout can be re-organised as you suggested. Relevant Skills and Experience Deg Mer

£111 GBP på 5 dager
(4 Omtaler)
2.8
biplobhosain

I feel that I am the exact match for your requirements after thoroughly reviewing the job description and desired skills Stay tuned, I'm still working on this proposal.

£44 GBP på 5 dager
(1 anmeldelse)
0.0
nehamohan24

Hi, I am proficient in this job and have successfully accomplished such project before. Please connect to discuss further. Thanks, Neha Relevant Skills and Experience Excel, VBA, Macros Proposed Milestones £222 GBP Mer

£222 GBP på 3 dager
(0 Omtaler)
0.0
kshanor

A proposal has not yet been provided

£20 GBP på 1 dag
(0 Omtaler)
0.0
tpizalate

Can have this done for you by tomorrow. Relevant Skills and Experience Database Manager for Major construction company 6+ years Proposed Milestones £150 GBP - Provide working excel file.

£150 GBP på 1 dag
(0 Omtaler)
0.0