Find Jobs
Hire Freelancers

Editing an excel sheet - already produced

£10-20 GBP

Completed
Posted about 6 years ago

£10-20 GBP

Paid on delivery
I require small edits to an excel sheet that ranks performance of a collection of businesses. The changes are basic. Please review the attached - I require some of the ranking tables to have a different title and some minor changes to calculations. "Emp vs P&L £" - The title of this is to be changed to "Food Quality" as a %. The most recently inputted week score should become the "PTD" score (4 weeks in each restaurant period) Ranking high - low. "Staying Legal" - Currently this is accumulative from Weeks 1 - 4, totalling at PTD. As above, I would like the PTD total to be the most recent week's entry. (This is currently the case for a "Sales Budget %" for instance). Ranking unchanged (lowest number, highest ranking) "Food Gap PTD £" - This is to be changed to "Food GP Var to Target YTD" - As above, the most recent entry becoming the PTD score. This measure is a % to one d.p. Where the highest variance ranks the highest on the tables. "Wet Gap PTD £" - This is to be changed to "Food GP Var to Target YTD" - As above, the most recent entry becoming the PTD score. This measure is a % to one d.p. Where the highest variance ranks the highest on the tables. "SPH PTD" - This is to be changed to "Upsell £ per NOM" this is cash number to 2 d.p (£2.04) for instance. Where the highest number ranks the highest on the tables. "Local / National / Guest £" - Changed to "Dessert Penetration" as a % whole number. Ranking highest to lowest. New "Food Quality" measure to be placed on summary rankings sheet next to "Open Complaints" "Dessert Penetration" measure to be placed on summary rankings sheet in place of "Penetration PTD" "Penetration PTD" mesure to placed on summary rankings sheet in place of "Food Quality" (is currently "Emp vs P&L £"
Project ID: 16178420

About the project

14 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Roy
£50 GBP in 1 day
4.9 (438 reviews)
7.2
7.2
14 freelancers are bidding on average £19 GBP for this job
User Avatar
I am a professional financial and a guru in Excel and VBA. I create creative and sophisticated financial & statistic models in a simplified and logical manner. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios. Also, I have experience in accounting, Financial Report Tools.
£20 GBP in 1 day
4.9 (92 reviews)
7.2
7.2
User Avatar
Hi I am interested in your project, because I have excellent experience of Excel and VBA. I am interested in your project, because I have excellent experience of Excel and VBA. Mohsan
£21 GBP in 1 day
5.0 (90 reviews)
6.4
6.4
User Avatar
Hello Sir, Thank you for posting the project. First! Your satisfaction is my top priority. I am interested in it. If you give me chance then i can start right now and able to provide best results. In short, I could produce exactly what you are looking for and I have highly confident that i can do it with quality & accuracy that's all. Thanks so much! Shafaqat Ali
£20 GBP in 1 day
4.9 (112 reviews)
6.2
6.2
User Avatar
Hello there, with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office, i can do the best job in the least time. I will do all and extra to ensure that you won't regret giving me this project. Thanks
£13 GBP in 1 day
5.0 (89 reviews)
5.9
5.9
User Avatar
Hello! I understand the requirements of your project. I have good skills and experience in MS Excel data processing, data scraping, data entry, etc. I finished similar jobs. I have 5 Stars reviews and I offer unlimited revisions, so I will work until you are 110% satisfied. If you are looking for genuine delivery then you should award me the project. Best regards, Leonard!
£19 GBP in 1 day
5.0 (39 reviews)
5.5
5.5
User Avatar
I am an Australian Business Analyst with 15 years professional experience building automation and reporting solutions using Excel and VBA. I have had a look at the workbook, and can see where the ranking settings have been stored for each KPI (on the KPIFormulas sheet which is hidden by default), and where to change the KPI names (basically - everywhere!). I am available to start working now, and would really appreciate the opportunity to work with you on this project!
£17 GBP in 1 day
5.0 (31 reviews)
5.3
5.3
User Avatar
Hi I have more than 11 years of extensive experience in all areas of data entry, data mining, data extraction, blog posting, mailing list development. I am expert in Data Entry work with 52 WPM of keystroke speed with exception interpersonal communication, management and marketing skills. Product Data Entry in CMS like, wordpress, woocommerce,OSCommerce, Amazon, ebay, and Magento, Shopify and similar capacities. SERVICE DESCRIPTION Admin Support Services : =================== Product Data Entry for Online E-commerce Website Data Entry Data Conversion Web Research Mailing List Creation Ads Posting Form Filling Product Uploading Data Mining Data Gathering Image Editing Portal Listing etc. Thanks & Regards Rahul Rahangdale
£18 GBP in 1 day
4.9 (34 reviews)
4.7
4.7
User Avatar
Hi I can help you with your project. I am proficient in excel and can start this task immediately and have it back to you in a couple of hours Please don't hesitate to contact me. Thanks Stephanie
£10 GBP in 1 day
5.0 (13 reviews)
4.1
4.1
User Avatar
Hello Sir, I am EXPERT in excel and data processing, So I am 100% confident that I can make YOUR required edits WITH 100% YOUR SATISFACTION. I review your file and I noticed that is no links between the dashboard and other sheets. So I think you need to link it also or you need it change manual? Looking forward to hearing from you. Thank you for your time Ahmed
£19 GBP in 1 day
5.0 (2 reviews)
1.6
1.6
User Avatar
Hello,I am an experienced , qualified information manager and delight in writing,training in business, case studies course works and term papers. I have participated in several proof reading exercises and in research proposal writing. I work withing given timelines and always ensure there is perfection in all tasks in my list. Assurance a. 100% plagiarism free paper. b. Strict adherence to instructions. c. Early submission to allow you adequate time for review d. Quality and presentable work.
£10 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Pontypridd, United Kingdom
4.8
3
Payment method verified
Member since Dec 5, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.