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.