Spreadsheet: 106330d1303497700-consolidating-a-list-into-another-in-the-same-worksheet-new-commission-sheet_wip
Sheet: Sheet1

 | HMC April Scorecard Summary
 | Employee | Units | Volume | Gross Commission | Monthly Capture Rate Bonus | Quarterly IFQ Bonus |  | Assistant/ Associate Name | Assistant / Associate Bonus Expense |  | Miscellaneous Expense | Payable  Commission
 | [NAME] | 12 | 2654978 | 16991.8592 | 0 | 796.4934 |  | [NAME] | 2500
 | [NAME] | 10 | 3000000 | 13200 | 0 | 899.9999999999999 |  | [NAME] | 2000
 | TBD |  |  |  |  |  |  | Suzie | 3000
 | TBD |  |  |  |  |  |  | [NAME]
 | TBD |  |  |  |  |  |  | [NAME] | 3500
 | TBD |  |  |  |  |  |  | [NAME]
 | TBD |  |  |  |  |  |  | Billy | 1500
 | TOTAL | 22 | 5654978 | 30191.8592 | 0 |  | 0 | 0 | 0 |  | 0 | 0
 | Assistant / Associate Name |  | Bonus Amt
 | Billy |  | 2000
 | Suzie |  | 3000
 | [NAME] |  | 3500
 | Billy |  | 1500
 |  |  | 10000
 | HMC - Employee Name
 | [NAME] | TOP |  |  |  |  | IFQ | Monthly | Quarterly
 |  | Units | Volume |  |  |  | Total Loans | 5 | 12 |  | Gross Commission |  | 16991.8592
 | PRODUCTION | 12 | 2654978 |  | Amount |  | Loans >= 85% | 4 | 10
 | Loans less than min |  |  |  | 0 |  |  | 0.8 | 0.8333333333333334 |  | IFQ Quarterly Bonus |  | 796.4934
 | Loans above [NAME] |  |  | Tier (bps) | 0 |  |  |  |  |  | Capture Rate Bonus
 | Home Equity Loans |  |  | 45 | 0 |  | Capture Rate | Monthly | YTD |  | Asst / Assoc Salary |  | 0
 | Prefer to [NAME] |  |  | 25 | 0 |  | Total Loans |  |  |  | Asst / Assoc Bonus
 | Standard Production |  | 2654978 | 64 | 16991.8592 |  | L&F Loans |  |  |  | [NAME] |  | 2500
 | Gross Commission |  |  |  | 16991.8592 |  |  | #N/A | #N/A
 |  |  |  |  |  |  | L&F Volume |  |  |  | [NAME]
 |  | [NAME] (bps)
 |  |  |  |  |  |  | Asst / Assoc | Monthly | Exp Amt
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | [NAME] ($)
 | 2011 Standard Commission Schedule (000s) |  |  | Min Loan Amt | [NAME]
 | 1 - 3 | $0 - $499 | 29 | 172413.7931034483 | 3448275.862068966 |  | Assistant / Associate HMC Schedule
 | 4 - 6 | $500 - $899 | 44 | 113636.3636363636 | 2272727.272727272 |  | 0 - 5 units   OR   $0 - $2M |  | 100% of salary
 | 7 - 9 | $900 - $1399 | 49 | 102040.8163265306 | 2040816.326530612 |  | 6 - 10 units   OR   $2.01M - $3M |  | 50% of salary |  |  |  | 0
 | 10 - 12 | $1400 - $1899 | 59 | 84745.76271186442 | 1694915.254237288 |  | 11 - 14 units   OR   $3.01M - $4.5M |  | 33% of salary
 | 13+ | $1900+ | 64 | 78125 | 1562500 |  | 15+ units   OR   $4.501M+ |  | 0% of salary |  | Net (payable) Commission |  | 15288.3526
 | HMC - Employee Name
 | [NAME] | TOP |  |  |  |  | IFQ | Monthly | Quarterly
 |  | Units | Volume |  |  |  | Total Loans | 5 | 12 |  | Gross Commission |  | 13200
 | PRODUCTION | 10 | 3000000 |  | Amount |  | Loans >= 85% | 4 | 10
 | Loans less than min |  |  |  | 0 |  |  | 0.8 | 0.8333333333333334 |  | IFQ Quarterly Bonus |  | 899.9999999999999
 | Loans above [NAME] |  |  | Tier (bps) | 0 |  |  |  |  |  | Capture Rate Bonus
 | Home Equity Loans |  |  | 45 | 0 |  | Capture Rate | Monthly | YTD |  | Asst / Assoc Salary |  | 0
 | Prefer to [NAME] |  |  | 25 | 0 |  | Total Loans |  |  |  | Asst / Assoc Bonus
 | Standard Production |  | 3000000 | 44 | 13200 |  | L&F Loans |  |  |  | [NAME] |  | 2000
 | Gross Commission |  |  |  | 13200 |  |  | #N/A | #N/A
 |  |  |  |  |  |  | L&F Volume |  |  |  | [NAME]
 |  | [NAME] (bps) |  | 44
 |  |  |  |  |  |  | Asst / Assoc | Monthly | Exp Amt
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | [NAME] ($)
 | 2011 Standard Commission Schedule (000s) |  |  | Min Loan Amt | [NAME]
 | 1 - 3 | $0 - $499 | 29 | 172413.7931034483 | 3448275.862068966 |  | Assistant / Associate HMC Schedule
 | 4 - 6 | $500 - $899 | 44 | 113636.3636363636 | 2272727.272727272 |  | 0 - 5 units   OR   $0 - $2M |  | 100% of salary
 | 7 - 9 | $900 - $1399 | 49 | 102040.8163265306 | 2040816.326530612 |  | 6 - 10 units   OR   $2.01M - $3M |  | 50% of salary |  |  |  | 0
 | 10 - 12 | $1400 - $1899 | 59 | 84745.76271186442 | 1694915.254237288 |  | 11 - 14 units   OR   $3.01M - $4.5M |  | 33% of salary
 | 13+ | $1900+ | 64 | 78125 | 1562500 |  | 15+ units   OR   $4.501M+ |  | 0% of salary |  | Net (payable) Commission |  | 12100