Spreadsheet: 103675d1301410056-formulas-inside-excel-charts-book2
Sheet: DataSheet

MTH
Current/Previous | KPI No | Dealer 1 | Dealer 2 | Dealer 3 | Dealer 4 | Dealer 5 | Dealer 6 | Dealer 7 | Dealer 8 | Dealer 9 | Dealer 10
Current | 1 | 3
Current | 1 | 3
Current | 1 | 3
Current | 1 | 3
Current | 1 | 3
Current | 1 | 3
Current | 1 | 3
Current | 1 | 3
Current | 1 | 3
Current | 2 | 4
Current | 2 | 4
Current | 2 | 4
Current | 2 | 4
Current | 2 | 4
Current | 2 | 4
Current | 2 | 4
Current | 2 | 4
Current | 2 | 4
Current | 3 | 5
Current | 3 | 5
Current | 3 | 5
Current | 3 | 5
Current | 3 | 5
Current | 3 | 5
Current | 3 | 5
Current | 3 | 5
Current | 3 | 5
Current | 4 | 1
Current | 4 | 1
Current | 4 | 1
Current | 4 | 1
Current | 4 | 1
Current | 4 | 1
Current | 4 | 1
Current | 4 | 1
Current | 4 | 1
Current | 5 | 2
Current | 5 | 2
Current | 5 | 2
Current | 5 | 2
Current | 5 | 2
Current | 5 | 2
Current | 5 | 2
Current | 5 | 2
Current | 5 | 2
Current | 6 | 5
Current | 6 | 5
Current | 6 | 5
Current | 6 | 5
Current | 6 | 5
Current | 6 | 5
Current | 6 | 5
Current | 6 | 5
Current | 6 | 5
Current | 7 | 7
Current | 7 | 7
Current | 7 | 7
Current | 7 | 7
Current | 7 | 7
Current | 7 | 7
Current | 7 | 7
Current | 7 | 7
Current | 7 | 7
Current | 8 | 3
Current | 8 | 3
Current | 8 | 3
Current | 8 | 3
Current | 8 | 3
Current | 8 | 3
Current | 8 | 3
Current | 8 | 3
Current | 8 | 3
Current | 9 | 4
Current | 9 | 4
Current | 9 | 4
Current | 9 | 4
Current | 9 | 4
Current | 9 | 4
Current | 9 | 4
Current | 9 | 4
Previous | 9 | 4
Previous | 1 | 7
Previous | 1 | 7
Previous | 1 | 7
Previous | 1 | 7
Previous | 1 | 7
Previous | 1 | 7
Previous | 1 | 7
Previous | 1 | 7
Previous | 7 | 7
Previous | 2 | 5
Previous | 2 | 5
Previous | 2 | 5
Previous | 2 | 5
Previous | 2 | 5
Previous | 2 | 5
Previous | 2 | 5
Previous | 2 | 5
Previous | 2 | 5
Previous | 3 | 6
Previous | 3 | 6
Previous | 3 | 6
Previous | 3 | 6
Previous | 3 | 6
Previous | 3 | 6
Previous | 3 | 6
Previous | 3 | 6
Previous | 3 | 6
Previous | 4 | 3
Previous | 4 | 3
Previous | 4 | 3
Previous | 4 | 3
Previous | 4 | 3
Previous | 4 | 3
Previous | 4 | 3
Previous | 4 | 3
Previous | 4 | 3
Previous | 5 | 5
Previous | 5 | 5
Previous | 5 | 5
Previous | 5 | 5
Previous | 5 | 5
Previous | 5 | 5
Previous | 5 | 5
Previous | 5 | 5
Previous | 5 | 5
Previous | 6 | 1
Previous | 6 | 1
Previous | 6 | 1
Previous | 6 | 1
Previous | 6 | 1
Previous | 6 | 1
Previous | 6 | 1
Previous | 6 | 1
Previous | 6 | 1
Previous | 7 | 8
Previous | 7 | 8
Previous | 7 | 8
Previous | 7 | 8
Previous | 7 | 8
Previous | 7 | 8
Previous | 7 | 8
Previous | 7 | 8
Previous | 7 | 8
Previous | 8 | 4
Previous | 8 | 4
Previous | 8 | 4
Previous | 8 | 4
Previous | 8 | 4
Previous | 8 | 4
Previous | 8 | 4
Previous | 8 | 4
Previous | 8 | 4
Previous | 9 | 1
Previous | 9 | 1
Previous | 9 | 1
Previous | 9 | 1
Previous | 9 | 1
Previous | 9 | 1
Previous | 9 | 1
Previous | 9 | 1
Previous | 9 | 1
YTD
Current/Previous | KPI No | Dealer 1 | Dealer 2 | Dealer 3 | Dealer 4 | Dealer 5 | Dealer 6 | Dealer 7 | Dealer 8 | Dealer 9 | Dealer 10
Current | 1
Current | 1
Current | 1
Current | 1
Current | 1
Current | 1
Current | 1
Current | 1
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
R12
Current/Previous | KPI No | Dealer 1 | Dealer 2 | Dealer 3 | Dealer 4 | Dealer 5 | Dealer 6 | Dealer 7 | Dealer 8 | Dealer 9 | Dealer 10
Current | 1
Current | 1
Current | 1
Current | 1
Current | 1
Current | 1
Current | 1
Current | 1
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 2
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 3
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 4
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 5
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 6
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 7
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 8
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Current | 9
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 1
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 2
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 3
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 4
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 5
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 6
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 7
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 8
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9
Previous | 9