Find Jobs
Hire Freelancers

Deconstruct Scorecard, understand Formula and Ranking System

$30-250 USD

Closed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
I have a scorecard that ranks my against my partners for performance, it has many metrics on it. But I want to know how the formula works for ranking with an excel file I can plug in scenarios to find which metrics are weighted more than others Attaching 12 samples of the scorecard
Project ID: 14032465

About the project

22 proposals
Remote project
Active 7 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
22 freelancers are bidding on average $163 USD for this job
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$180 USD in 3 days
4.9 (230 reviews)
7.4
7.4
User Avatar
Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar excel projects for various clients and businesses. If you'd like to view my qualifications, experience and previous work, take a look at my Freelancer Portfolio, and if you are comfortable with those please contact me. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
$90 USD in 2 days
5.0 (193 reviews)
6.8
6.8
User Avatar
Hello! We are extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hear from you soon. Thanks!
$277 USD in 5 days
4.9 (44 reviews)
6.3
6.3
User Avatar
hi, Please send me samples of the scorecard. I can help you if you want to get the high scores at the beginning of the list. about me: I create all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards. And more, I am financial specialist and guru in Excel and VBA. I create creative and sophisticated financial models in a simplified and logical manner including clear assumptions, drivers, financial statements, valuations, proper sensitivity analysis, scenarios and dashboards that are easy to understand by the client and their investors. Over 35 years, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a variety of firms including, startups, retailers, power plants, farms, universities, equipment manufacturers, among others.
$250 USD in 3 days
4.9 (50 reviews)
6.2
6.2
User Avatar
Hi there, Your project has caught my eye - I didn't see the attachments of the examples of the scorecards in the project description, I would love to take a look at them to see the ranking formulas and the metric weighting system to get an understanding of how it all works so I can then explain it to you. I have over 15 years of corporate experience working in Excel creating advanced automated dashboards, reports and calculators which included beautiful graphical displays of data/information. I enjoy creating complex algorithms using Excel formulas to extract meaningful conclusions from Excel data to help clients use the data to improve their businesses. Also, creating charts and graphical representations of data in Excel is one of my favorite things to do. I have built countless dashboards with complex RANK formulas used in various algorithms throughout my career. I have a few portfolio items on my Freelancer home profile if you want to take a look, and I have a more detailed file with numerous screen shots of my work as well – I can send it over for your review if you’d like. Hopefully I can hear more and we can work together! Thanks either way for reading my proposal and best of luck, Shaun
$115 USD in 2 days
5.0 (64 reviews)
6.3
6.3
User Avatar
to me Hi ! I am a  "Dean Scholarship" recipient for business graduate studies from NYU Stern.   I am CFA (USA) charter holder. I created balanced scorecards for a large listed company in Singapore wherein I did following : 1. Established a daily reporting system for analysing commercial and technical performance of the manufacturing machinery. 2. Identified alternate channels for adding sales in new geographies through Chambers of Commerce, Diplomatic Missions and Trade Bodies located globally  along with analytical data from World Bank and Industry Associations 3. Reviewed function/business wise performance through monthly Balanced Scorecards for Marketing, Merchandising ,  Logistics, Finance & Planning functions 4. Ensured timely execution of weekly & monthly  Sales and Operation Planning process for ensuring timely dispatches of  goods   5. Designed  functionalities for  CEO level Dashboards & recommending best industry practices for “Creative Design Team” formation 6. Carried out External & Internal Benchmarking together with Business Analytics 7. Highlighted variations in daily MIS for all functions across the group & coordinating efforts to achieve the targets 
$97 USD in 1 day
5.0 (20 reviews)
5.9
5.9
User Avatar
Hi, I am a management professional and work on various aspects of new business and market performance. I deal with requirement associated with market research, fact finding, feasibility studies, and bench-marking etc. I am interested in the work and would like to know if we can discuss this further. Kind Regards, PRD Analyst NOTE: I CAN PROVIDE YOU MULTIPLE VARIABLE COMPARISON ANALYSIS METRIC/RANKING SYSTEM
$200 USD in 6 days
4.6 (13 reviews)
5.0
5.0
User Avatar
Hi, Can we discuss the project further? I have done similar project and understood the project outline. Please give me a chance. A trial will convince you. Looking forward to work with you.
$155 USD in 3 days
4.4 (15 reviews)
4.9
4.9
User Avatar
I am hopeful of breaking the formula by running various analysis on the excel sheet. Also I will break any paasword on your sheet, so you have direct access to all the formula. We can discuss the details over chat. Thanks, Varun Bansal
$100 USD in 3 days
4.9 (33 reviews)
4.5
4.5
User Avatar
I am a Data Entry/Data Processing Expert with years of experience. I know the value of time. If you are looking for data entry work, I am the right person for you.
$75 USD in 3 days
4.3 (14 reviews)
3.5
3.5
User Avatar
I will provide you with high quality accurate work as i have pretty good knowledge in Microsoft office applications, i am also fluent in both English and Arabic and i have a fast typing speed as well as a mechanical keyboard which will guarantee satisfying results.
$55 USD in 2 days
5.0 (1 review)
0.4
0.4
User Avatar
I HAVE MICROSOFT CERTIFICATION IN DATA ANALYSIS IN EXCEL. I CAN DO IN DEPTH ANALYSIS AND PROVIDE THE OUTCOME ACCORDING YOUR ULTIMATE BENEFIT. YOU ARE WELCOME.
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$45 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have a good problem solving and Data analytics skills .Have good hands on MS excel. ease in identifying formulas
$88 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have a deep understanding of the different business analysis tools such as the balanced scorecard and SWOT analyysis. I believe i am the right candidate to undertake this tsk and can guarantee you a high quality piece. I can send you samples of my work on balanced scorecards analysis t provve my ability to complete the project.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, you have not attaching the scorecard. Good at excel formula, preparing tracker & template, Microsoft Office (e.g. excel. Word, Power Point, etc). Fill in spreadsheet with accurate data. Can help to do data analysis depend on required info. Feel free to contact me for further details.
$222 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Employer, I am an expert in Business Analytics . I have done couple of good projects on BA. Please share your work once with us to have a great experience. Thanks Team Enlightica
$166 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$555 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
You need power rankings, weighted rankings or potentially recency calcs combined with a rankif function (which doesn't really exist but can be created via a sumproduct function) to get what you need done. I'll offer less than average since this is my first job.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NIGERIA
AGBADO, Nigeria
5.0
10
Member since Dec 1, 2014

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.