Spreadsheet: 697004d1601074061-student-needs-help-with-formula-profit-sharing-group-project
Sheet: Profit Sharing

 | Company Points | 216
 | Profit Sharing % | 1
 | Total Profit Sharing Amount |  |  |  |  |  | Legend | Points
 |  |  |  |  |  |  | Below Average | 0
 | Billable hours | 0.1 |  |  |  |  | Firm Average | 1
 | Non Billable Hours | 0.05 |  |  |  |  | Average | 2
 | Dollars Managed | 0.05 |  |  |  |  | Slightly Above Average | 3
 | Write Offs Performance | 0.05 |  |  |  |  | Above Average | 4
 | Unbilled Dollars | 0.05 |  |  |  |  | Excellent | 5
 | Collention Credits | 0.05 |  |  |  |  | 25 | 0
 | Origination credits | 0.05 |  |  |  |  | 50 | 1
 | Billing Rate | 0.15 |  |  |  |  | 100 | 2
 | Quality of Legal Work | 0.2 |  |  |  |  | 150 | 3
 | External Respect in community | 0.1 |  |  |  |  | 200 | 4
 | Cooperativeness with other partners | 0.1
 | committee work and firm management | 0.05
 | Number of employees | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sum for employees
 | Employee 1 |  |  | Employee 2 |  |  | Employee 3 |  |  | Employee 4 |  | Employee 5 |  | Employee 6 |  |  | Employee 7 |  | Employee 8
 | Billable hours | 1 |  | Billable hours | 2 |  | Billable hours | 1 |  | Billable hours | 2 | Billable hours | 2 | Billable hours | 1 |  | Billable hours | 1 | Billable hours | 0
 | Non Billable Hours | 2 |  | Non Billable Hours | 3 |  | Non Billable Hours | 1 |  | Non Billable Hours | 1 | Non Billable Hours | 1 | Non Billable Hours | 4 |  | Non Billable Hours | 3 | Non Billable Hours | 3
 | Dollars Managed | 2 |  | Dollars Managed | 3 |  | Dollars Managed | 0 |  | Dollars Managed | 0 | Dollars Managed | 1 | Dollars Managed | 2 |  | Dollars Managed | 1 | Dollars Managed | 2
 | Write Offs Performance | 2 |  | Write Offs Performance | 2 |  | Write Offs Performance | 1 |  | Write Offs Performance | 2 | Write Offs Performance | 2 | Write Offs Performance | 3 |  | Write Offs Performance | 1 | Write Offs Performance | 2
 | Unbilled Dollars | 2 |  | Unbilled Dollars | 2 |  | Unbilled Dollars | 1 |  | Unbilled Dollars | 0 | Unbilled Dollars | 1 | Unbilled Dollars | 2 |  | Unbilled Dollars | 1 | Unbilled Dollars | 2
 | Collention Credits | 2 |  | Collention Credits | 2 |  | Collention Credits | 1 |  | Collention Credits | 1 | Collention Credits | 1 | Collention Credits | 2 |  | Collention Credits | 1 | Collention Credits | 2
 | Origination credits | 2 |  | Origination credits | 4 |  | Origination credits | 0 |  | Origination credits | 1 | Origination credits | 0 | Origination credits | 3 |  | Origination credits | 1 | Origination credits | 4
 | Billing Rate | 2 |  | Billing Rate | 1 |  | Billing Rate | 2 |  | Billing Rate | 2 | Billing Rate | 2 | Billing Rate | 2 |  | Billing Rate | 2 | Billing Rate | 2
 | Quality of Legal Work | 0 |  | Quality of Legal Work | 0 |  | Quality of Legal Work | 0 |  | Quality of Legal Work | 0 | Quality of Legal Work | 0 | Quality of Legal Work | 0 |  | Quality of Legal Work | 0 | Quality of Legal Work | 0.02
 | External Respect in community | 0 |  | External Respect in community | 0 |  | External Respect in community | 0 |  | External Respect in community | 0 | External Respect in community | 0 | External Respect in community | 0 |  | External Respect in community | 0 | External Respect in community | 0.02
 | Cooperativeness with other partners | 0 |  | Cooperativeness with other partners | 0 |  | Cooperativeness with other partners | 0 |  | Cooperativeness with other partners | 0 | Cooperativeness with other partners | 0 | Cooperativeness with other partners | 0 |  | Cooperativeness with other partners | 0 | Cooperativeness with other partners | 0.02
 | committee work and firm management | 0 |  | committee work and firm management | 0 |  | committee work and firm management | 0 |  | committee work and firm management | 0 | committee work and firm management | 0 | committee work and firm management | 0 |  | committee work and firm management | 0 | committee work and firm management | 0.05
 | Profit Sharing Amount
 | Total Profit Sharing Amount
 | [NAME] (should be zero)