Completed

Update Excel Sheet

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 [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.

Kemahiran: Excel, Excel Macros, Excel VBA

Lihat lagi: excel refresh f9, how to refresh excel sheet automatically, excel auto update data from another worksheet, refresh excel sheet vba, refresh excel shortcut, automatically update excel spreadsheet from another spreadsheet, how to refresh excel formulas, automatically update data in excel from one sheet to another, update excel sheet code, python update excel sheet, update excel sheet python, want update excel sheet joomla website, update excel sheet website vb, update excel sheet access, project update excel sheet, read update excel sheet access, update excel sheet vb6, bombay stock exchange automatic update excel sheet, programs open excel sheet, update access excel sheet

Tentang Majikan:
( 1 ulasan ) Pontypridd, United Kingdom

ID Projek: #15598480

Dianugerahkan kepada:

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 Lagi

£175 GBP dalam 7 hari
(139 Ulasan)
7.1

23 pekerja bebas membida secara purata £138 untuk pekerjaan ini

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 dalam 3 hari
(160 Ulasan)
7.2
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 Lagi

£200 GBP dalam 3 hari
(198 Ulasan)
7.1
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 Lagi

£210 GBP dalam 3 hari
(235 Ulasan)
6.9
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 Lagi

£150 GBP dalam 3 hari
(26 Ulasan)
6.2
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 Lagi

£194 GBP dalam 3 hari
(93 Ulasan)
6.0
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 dalam 15 hari
(36 Ulasan)
5.3
£20 GBP dalam 3 hari
(29 Ulasan)
5.4
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 Lagi

£100 GBP dalam 3 hari
(22 Ulasan)
5.3
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 Lagi

£100 GBP dalam 5 hari
(62 Ulasan)
4.8
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 Lagi

£250 GBP dalam 3 hari
(4 Ulasan)
3.9
AhmedHassan1122

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

£150 GBP dalam 3 hari
(11 Ulasan)
4.0
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 Lagi

£138 GBP dalam 3 hari
(6 Ulasan)
3.6
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 Lagi

£150 GBP dalam 3 hari
(6 Ulasan)
3.3
wsnel

I would be honored to update and alter your spreadsheet. I guarantee that my end product will be elegant, thoroughly tested and made to your specifications. Relevant Skills and Experience I am an excellent Excel VBA c Lagi

£55 GBP dalam 3 hari
(3 Ulasan)
3.1
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 Lagi

£111 GBP dalam 5 hari
(3 Ulasan)
2.7
RushService

Shoot me message to discuss further more details of Update Excel [login to view URL] provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after the work done.

£100 GBP dalam 3 hari
(3 Ulasan)
2.9
£45 GBP dalam 3 hari
(4 Ulasan)
2.0
kshanor

A proposal has not yet been provided

£20 GBP dalam sehari
(0 Ulasan)
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 Lagi

£222 GBP dalam 3 hari
(0 Ulasan)
0.0
£100 GBP dalam 3 hari
(0 Ulasan)
0.0