In Progress

XLS Performance Scorecard

I have a scorecard that I commissioned/awarded another programmer and he was unable to complete it do to some personal health concerns. I have attached a file that is nearly 95% complete but just needs a few tweeks and finish, specifically with regard to "quality" as you will note from the attached. Specifically to get calculations to perform correctly, see example: if A accevedo has one return for the period you would take 1/8 which equals .125. That number must be turned into a % by multiplying by 100, giving you 12.5%. then we are only weighting that % at 50% which equals 6.25%. That number would then be subtracted from the quality % and if the retention and prebooking were flawless than the maximum quality% a Acevedo could achieve with 1 return would be 93.75%. With an absolute of 8 maximum returns for any given year. Additionally, I need the scorecard or dashboard to collect and store historical data with the ability to reset annually/monthly. Also, see attached Compensation Guidelines which explains KPI's (Key Performance Indicators) for better understanding what has been done w/ spreadsheet thus far and to ensure calculations are accurate to support the guidelines.

Skills: Excel

See more: xls scorecard, performance dashboard xls, performance scorecard xls, xls performance scorecard, scorecard xls, xls performance dashboard, programmer for spreadsheet, n equals, i was awarded, better health store, excel spreadsheet programmer, retention, kpi dashboard, excel w, data performance excel, key performance indicators excel, compensation excel, performance dashboard excel, excel kpi dashboard excel, excel performance dashboard, dashboard kpi excel, xls excel data, dashboard monthly, dashboard xls, excel spreadsheet compensation

About the Employer:
( 0 reviews ) Avon, United States

Project ID: #1158774

Awarded to:

vserv

Pls see your messages. Thanks

$250 USD in 5 days
(53 Reviews)
5.6

10 freelancers are bidding on average $327 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$350 USD in 5 days
(57 Reviews)
6.3
vbexcel

Excel / Word expert.

$250 USD in 5 days
(25 Reviews)
5.2
Krusche

Please check you PMB

$320 USD in 4 days
(21 Reviews)
5.2
telemarketing555

Hi, please check your PM. Thank you.

$350 USD in 10 days
(22 Reviews)
4.3
jacoby

Dear stillingsm, I am experienced excel expert and professional accountant and quite interesting in your project. Please check pm. Thanks. Jacob

$300 USD in 10 days
(1 Review)
2.0
pawankumarmaurya

this work is solved in 1 days

$500 USD in 1 day
(0 Reviews)
0.0
ksrslm

Will provide a perfect XLS scorecard.

$250 USD in 10 days
(0 Reviews)
0.0
JANoufel

Hi, now I'm ready for this work.

$450 USD in 3 days
(0 Reviews)
0.0
proboscis

***** Can you please refer to the PM for details on the bid? ******

$250 USD in 7 days
(0 Reviews)
0.0