Spreadsheet: 24147d1214260888-report-a-list-line-by-line-based-on-name-criteria-example-bonus
Sheet: Main

 | ver. 2008/06/20
 |  |  |  |  |  |  | Bonuses for Jan-00 through Jan-00
 |  |  |  |  |  |  | Approval Manager: |  |  |  | Start Date:
 |  |  |  |  |  |  | Total Dealer Installs & Upgrades: |  |  |  | End Date:
 | Total Installer Generated Sales |  | List Installers | [NAME]. | Bonus |  |  | Totals of Modules Installed
 | Upfront Sales: |  | [NAME] |  |  |  | Main F&I: |  |  | CUDL:
 | [NAME]. Sales: |  | [NAME] |  |  |  | Desklog: |  |  | Barcoding:
 | Monthly Sales: |  | [NAME] |  |  |  | CRM: |  |  | Registration:
 |  |  |  |  |  |  | ILH: |  |  | F&I Menu:
 | Total Contract Amounts |  |  |  |  |  | Service: |  |  | Credco:
 | Monthly per Station: |  |  |  |  |  | Fast Lease: |  |  | AAX:
 | [NAME]. Monthly Amount: |  |  |  |  |  | F&I Express: |  |  | Accounting:
 | Total Upfront Amount: |  |  |  |  |  | Dealertrack: |  |  | Custom:
 |  |  |  |  |  |  | Route One: |  |  | Total Modules:
 | Installer Totals Statistics
 | Total Installer Days: |  |  |  |  |  |  | Cost / Revenue Analysis
 | Bonus Based Days: |  |  |  |  |  | Item |  | Daily | Monthly | Yearly | Total
 | Stations Installed: |  |  |  |  |  | Installer Salary
 | Bonuses/Comm. Paid: |  |  |  |  |  | Installer Bonus
 |  |  |  |  |  |  | Installer Expenses
 | Total Revenues |  |  |  |  |  | Installer Total Debit
 | Upfront Amount: |  |  |  |  |  | Monthly Sales
 | Monthly Amount: |  |  |  |  |  | Upfront / Misc. Sales
 |  |  |  |  |  |  | Monthly by Station
 | Total Debits |  |  |  |  |  | Upfront by Station
 | Salary Adjustment: |  |  |  |  |  | Monthly by [NAME]
 | Total Expenses: |  |  |  |  |  | Upfront by [NAME]
 | Total Salary for Period: |  |  |  |  |  | Monthly by Installer
 | Total Commisions: |  |  |  |  |  | Upfront by Installer
 | Total Bonuses: |  |  |  |  |  | Efficiency Monthlies
 | Overall Total: |  |  |  |  |  | Efficiency Upfronts
 | DCH Honda of [NAME] | Upfront Sales | Monthly Sales | [NAME]. Sales | Bonus | Mod. # | Module | Comm. | Custom | Pos. Day | Instlr. Days | Bns/Sales
 | Totals: | 640 | 0 | 0 | 2168.75 | 11 | 506.25 | 19.2 | 0 | 16 | 81 | 2694.2
 | Total Stations: | 0 | Main F&I | Desklog | CRM | ILH | Service | Fast Lease | F&I Express | Dealertrack | Route One | CUDL
 | Monthly per Station: |  | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0
 | [NAME]. Monthly Amount: |  | Barcoding | Registration | F&I Menu | Credco | AAX | Accounting | Custom | Custom | Custom
 | Total Upfront Amount: |  | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0
 | Dealer Name | Dates of Install | Employee | Type | Bonus | Mod. % | Module | Sales | Custom | Pos. Days | Days | Total
 | DCH Honda of [NAME] | 04/07 - 04/25 | [NAME] | Lead | 588.8888888888889 | 1 | 100 | 3.792592592592592 |  | 16 | 16 | 692.6814814814815
 | DCH Honda of [NAME] | 04/07 - 04/25 | [NAME] | [NAME]. | 170.1388888888889 | 1 | 43.75 | 1.659259259259259 |  | 16 | 7 | 215.5481481481482
 | DCH Honda of [NAME] | 04/07 - 04/25 | [NAME] | Accounting | 388.8888888888889 | 1 | 100 | 3.792592592592592 |  | 16 | 16 | 492.6814814814815
 | DCH Honda of [NAME] | 04/07 - 04/25 | [NAME] | Accounting | 243.0555555555555 | 1 | 62.5 | 2.37037037037037 |  | 16 | 10 | 307.9259259259259
 | DCH Honda of [NAME] | 04/07 - 04/25 | [NAME] | Installer | 388.8888888888889 | 1 | 100 | 3.792592592592592 |  | 16 | 16 | 492.6814814814815
 | DCH Honda of [NAME] | 04/07 - 04/25 | [NAME] | Installer | 388.8888888888889 | 1 | 100 | 3.792592592592592 |  | 16 | 16 | 492.6814814814815