Update Excel Sheet
£20-250 GBP
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.
Prosjekt-ID: #15598480
Om prosjektet
22 frilansere byr i gjennomsnitt £142 for denne jobben
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
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
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
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
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
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
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
Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones £150 GBP - Full Price
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
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.
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
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.