Cancelled

Excel Ranking

I manage a group of restaurants and require construction of an updated version of the attached KPi Ranking system :

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 [url removed, login to view] 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.

Skills: Excel, Excel Macros, Excel VBA

See more: i manage, how can i manage time efficiently in coordinating work commitments and personal need, excel 2007 i want all my workbooks customized, sample excel macro box score, excel vba radio button group, excel half time score, excel sheet containing data 3000 restaurants, manage group policy must log computer, manage group policy must log 2008, excel spreadsheet list san diego restaurants, backtesting excel ranking, manage group hotels project using xml, excel ranking based sum, excel thinks soccer score date, excel ranking across range, excel ranking vba, excel ranking, excel ranking formula, excel vba open xml file, open excel standalone java, excel project manage template web design, open xml vbscript excel, excel macro open files, amibroker open excel

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

Project ID: #15591602

35 freelancers are bidding on average £378 for this job

jaylancer43

Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an En More

£500 GBP in 5 days
(532 Reviews)
8.1
seaanddream

Hi, my name is Sevinc. I read your "Excel Ranking" project descriptions carefully before bidding. I checked the attached template as well... I got what you need and ready to go ahead as soon as we can clarify further More

£250 GBP in 5 days
(231 Reviews)
7.4
£400 GBP in 3 days
(249 Reviews)
7.6
bouslimi1979

Dear, I ll make all these change to your Master file. I just need few clarifications. Ready to start. Thanks Expérience et Compétences appropriées Excel/VBA Expert Étapes proposées £150 GBP - initial £150 GBP - Final More

£300 GBP in 5 days
(181 Reviews)
7.2
schoudhary1553

Greeting, I have understood your Excel Ranking task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Excel, Exce More

£350 GBP in 6 days
(213 Reviews)
7.3
aarifakhtar

Hi: I believe that you want to make changes in your current restaurant ranking program. I can certainly support you make the changes that you have mentioned in the projects specifications. Relevant Skills and Experien More

£250 GBP in 3 days
(151 Reviews)
6.9
TonmoyRoy111

Dear client, I would like to have a discussion with you. I have vast experience in excel and I believe I can do this project. So pl contact me for discussion. Roy Relevant Skills and Experience excel, macro Proposed More

£250 GBP in 4 days
(231 Reviews)
6.3
paris2785

Hi there. I am Paris. I have just read all your brief. Everything written there makes sense and can be implemented by using a combination of formulas and code. I can do both. Relevant Skills and Experience I've been d More

£250 GBP in 3 days
(112 Reviews)
6.4
wsh2

Highly experienced (25+years) EXCEL Programming and Database expert with excellent Data Integration, Reporting, and User Interface skills. Nice workbook! Can we please have the password for the VBA. Relevant Skills More

£373 GBP in 10 days
(29 Reviews)
6.0
osmemon

I am an Excel and VBA expert with 100% client satisfaction history. I saw the files and seperate restaurant sheet. I can do macro as per your requirement. See my profile for client reviews. Relevant Skills and Experie More

£250 GBP in 1 day
(32 Reviews)
5.5
satishtl

- Can get the ranking, KPI titles changed and also the order as required. - Have very good Excel automation skills. - Have the PTDs per the number of weeks data. Relevant Skills and Experience - Have expertise in Exce More

£300 GBP in 5 days
(37 Reviews)
5.2
tiaratechies

Hello, I was certified in excel & working on it for number of years. So, I am pretty sure about handling this project. Relevant Skills and Experience excel Proposed Milestones £250 GBP - milestone

£250 GBP in 1 day
(36 Reviews)
5.2
royalcalif

"Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. Thank you very much for your opportunity to bid" Relevant Skills and Experienc More

£250 GBP in 6 days
(42 Reviews)
4.9
prabakarm23

It can be created using Excel VBA, kindly contact me to discuss further Relevant Skills and Experience worked on VB and VBA also with .NET by compiling Applications like SAP, IE,etc Proposed Milestones £333 GBP - Fin More

£333 GBP in 7 days
(45 Reviews)
4.5
£250 GBP in 10 days
(18 Reviews)
5.0
aimefx

Hi, I am expert in excel, vba and power bi. I can create the KPI dashboard and Ranking system in excel and power. I am ready to start working on your project now. Relevant Skills and Experience You can check some of More

£250 GBP in 3 days
(27 Reviews)
4.8
AhmedHassan1122

Excel VBA Developer Relevant Skills and Experience Excel VBA Proposed Milestones £555 GBP - Full Price

£250 GBP in 1 day
(12 Reviews)
4.4
chintuag

Dear Hiring Manager, I have read the project description and would like to offer my expertise for it. I am a professional with over a decade experience in excel. I have worked on projects in excel involving macros, c More

£445 GBP in 4 days
(10 Reviews)
4.1
vmadhavan15

The macro is password protected and I have break the password to see them.. and I could able to do this one if you are happy with my proposal please ping me and thank you also apologies for breaking Relevant Skills an More

£250 GBP in 3 days
(10 Reviews)
4.2
jasalaz100

Immediate [login to view URL], fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Relevant Skills and Experience Experience of 6 years usi More

£333 GBP in 5 days
(13 Reviews)
4.0