ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need suggestions for organizing spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/78513-need-suggestions-organizing-spreadsheet.html)

nander

Need suggestions for organizing spreadsheet
 

I'm running an incentive program for my employees to participate in a
monthly quiz. The incentive works like this. $10 per participating
employee in the monthly pool. Then an additional $10 per participating
employee in the quarterly pool. I'll throw in an extra $10 into the
monthly pool if someone gets a perfect score (if 2 people get a perfect
score they split the monthly pot and the $10, etc.) The quarterly pot
goes to the employee(s) with the highest quarterly score. I've attached
a basic spreadsheet. I'm open to any and all suggestions on the smart
way to organize this data for ease of maintenance and use

Employee
Roger
Mark
David
Andrew
Mickey
Danny
Donald


+-------------------------------------------------------------------+
|Filename: FLYER QUIZZ.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4485 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=524517



All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com