Find Jobs
Hire Freelancers

Excel Ranking

£250-750 GBP

Annulé
Publié il y a plus de 6 ans

£250-750 GBP

Payé lors de la livraison
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 [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.
N° de projet : 15591602

Concernant le projet

33 propositions
Projet à distance
Actif à il y a 6 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
33 freelances proposent en moyenne £367 GBP pour ce travail
Avatar de l'utilisateur
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 Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you. Proposed Milestones £500 GBP - Please pay me once the job is 100% complete
£500 GBP en 5 jours
5,0 (732 commentaires)
8,5
8,5
Avatar de l'utilisateur
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 delivery
£300 GBP en 5 jours
4,9 (276 commentaires)
7,7
7,7
Avatar de l'utilisateur
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 project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.
£250 GBP en 5 jours
4,9 (281 commentaires)
7,8
7,8
Avatar de l'utilisateur
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, Excel Macros, Excel VBA Proposed Milestones £350 GBP - For Excel Ranking Job
£350 GBP en 6 jours
4,9 (315 commentaires)
7,9
7,9
Avatar de l'utilisateur
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 developing Excel spreadsheets with or without VBA code for almost a decade. Feel free to check past projects' reviews in my portfolio. Proposed Milestones £250 GBP - Once and only if you are happy with the final result. When shall I start? I can deliver within 1-3 days.
£250 GBP en 3 jours
4,9 (223 commentaires)
7,4
7,4
Avatar de l'utilisateur
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 Milestones £250 GBP - after completion
£250 GBP en 4 jours
4,9 (346 commentaires)
6,9
6,9
Avatar de l'utilisateur
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 Experience I am very experienced in Excel and have delivered nearly 125 projects on the Freelancer website. Also, I always take my projects to completion. Proposed Milestones £250 GBP - Edits Made to this Existing Excel Macro Your Excel file has VBA code at the back-end. Please share the password to allow me to make edits.
£250 GBP en 3 jours
4,9 (168 commentaires)
7,0
7,0
Avatar de l'utilisateur
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 en 1 jour
5,0 (51 commentaires)
6,9
6,9
Avatar de l'utilisateur
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 and Experience Strong Accounting, BOM, Costing, Finance, Inventory, MRP, Order Processing, Payroll+Time, Project Tracking, Sales & Marketing, and Statistics application knowledge. English is our only language. Proposed Milestones £173 GBP - Down payment £200 GBP - Upon completion Please contact us via chat before awarding. Respectfully, Carol+Bill.
£373 GBP en 10 jours
4,9 (29 commentaires)
6,0
6,0
Avatar de l'utilisateur
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 Experience Excel VBA Proposed Milestones £250 GBP - only Looking for your response.
£250 GBP en 1 jour
4,8 (34 commentaires)
5,6
5,6
Avatar de l'utilisateur
- 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 Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., Proposed Milestones £300 GBP - Day5 - Get the ranking and change the Titles and PTD calculation
£300 GBP en 5 jours
4,7 (48 commentaires)
6,0
6,0
Avatar de l'utilisateur
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 and Experience VBA Proposed Milestones £250 GBP - final payment
£250 GBP en 3 jours
4,9 (28 commentaires)
5,1
5,1
Avatar de l'utilisateur
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 - Final Output
£333 GBP en 7 jours
5,0 (49 commentaires)
4,6
4,6
Avatar de l'utilisateur
Excel VBA Developer Relevant Skills and Experience Excel VBA Proposed Milestones £555 GBP - Full Price
£250 GBP en 1 jour
4,9 (16 commentaires)
4,5
4,5
Avatar de l'utilisateur
Hello, I am an analytics consultant with more than 6 years of experience working with excel for clients of 2 major consulting firms. With more than 50 excel based analysis projects delivered in past 6 years, I am well positioned to take up this job smoothly. Please ping for more details.
£400 GBP en 7 jours
5,0 (6 commentaires)
4,2
4,2
Avatar de l'utilisateur
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, complex formulas, interaction with external applications (PDF, Outlook, Access), dashboards, web scraping, etc. I'm sure you would be satisfied with my work. Looking forward to hear from you. Regards Chintu
£445 GBP en 4 jours
5,0 (11 commentaires)
4,0
4,0
Avatar de l'utilisateur
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 best. I am an honest and responsible freelancer ! I believe in quality and professionalism !Can you give me a chance to work for you?
£555 GBP en 10 jours
5,0 (6 commentaires)
3,3
3,3
Avatar de l'utilisateur
I guarantee you a first class service with the quality and in the time it deserves by putting at your disposal all my knowledge and years of practice. Habilidades y experiencia relevante Advanced proficiency on Microsoft Offices. Strong attention to detail and ability to manage multiple priorities. Strong use and development using the technologies that it raises. Htos propuestos £600 GBP - Development and materialization of the requirements £66 GBP - Validation of deliverables with the client
£666 GBP en 6 jours
5,0 (1 commentaire)
2,6
2,6
Avatar de l'utilisateur
Work will be done on time with maximum efficiency and lest eroors,do consider my proposal Relevant Skills and Experience I'm good at Microsoft Excel,word, poweroint et And many more
£333 GBP en 9 jours
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Guaranteed satisfaction on theKPI Ranking System Relevant Skills and Experience Excel, Dashboarding on Excel, Proposed Milestones £100 GBP - on agreement £455 GBP - on delivery of excel tool Additional Services Offered £50 GBP - development of visual dashboards for individual restaurants £50 GBP - development of dashboard for KPI ranking to help team meetings Most of the data is derived fm other attribute. is it filled in Manually or automated with formulae?
£555 GBP en 10 jours
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED KINGDOM
Pontypridd, United Kingdom
4,8
3
Méthode de paiement vérifiée
Membre depuis déc. 5, 2016

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.