Spreadsheet: 109765d1306526392-formula-requiring-three-actions-auto-data-pt-sample
Sheet: April 2011 Raw Data

Identifier1 | Identifier2 | Zone | Make | Zone Rank | Dealer Name | April MTD | MTD Percent | [NAME] | YTD Percent
NortheastAcuraMotorcars Acura Volvo | NortheastAcura1 | Northeast | Acura | 1 | Motorcars Acura Volvo | 11 | 0.647058823529411 | 43 | 0.716666666666666
NortheastAcuraAirport [NAME] | NortheastAcura2 | Northeast | Acura | 2 | [NAME] | 5 | 0.294117647058823 | 14 | 0.233333333333333
NortheastAcuraPark [NAME] | NortheastAcura3 | Northeast | Acura | 3 | [NAME] | 1 | 0.0588235294117647 | 3 | 0.05
NorthwestAcuraAirport Acura | NorthwestAcura1 | Northwest | Acura | 1 | [NAME] | 21 | 0.839999999999999 | 68 | 0.8
NorthwestAcuraMotorcars Acura Volvo | NorthwestAcura2 | Northwest | Acura | 2 | Motorcars Acura Volvo | 4 | 0.16 | 14 | 0.164705882352941
NorthwestAcuraPark Acura | NorthwestAcura3 | Northwest | Acura | 3 | [NAME] | 0 | 0 | 2 | 0.0235294117647058
NorthwestAcuraAcura Columbus | NorthwestAcura4 | Northwest | Acura | 4 | Acura Columbus | 0 | 0 | 1 | 0.0117647058823529
SoutheastAcuraMotorcars Acura Volvo | SoutheastAcura1 | Southeast | Acura | 1 | Motorcars Acura Volvo | 16 | 0.32 | 84 | 0.4375
SoutheastAcuraPark Acura | SoutheastAcura2 | Southeast | Acura | 2 | [NAME] | 16 | 0.32 | 62 | 0.322916666666666
SoutheastAcuraAirport [NAME] | SoutheastAcura3 | Southeast | Acura | 3 | [NAME] | 16 | 0.32 | 39 | 0.203125
SoutheastAcuraLindsay Acura | SoutheastAcura4 | Southeast | Acura | 4 | [NAME] | 0 | 0 | 3 | 0.015625
SoutheastAcuraAcura/Mitsubishi of Boardman | SoutheastAcura5 | Southeast | Acura | 5 | Acura/Mitsubishi of Boardman | 0 | 0 | 2 | 0.0104166666666666
SoutheastAcuraColumbia Acura | [NAME] | Southeast | Acura | 6 | [NAME] | 1 | 0.02 | 1 | 0.00520833333333333
SoutheastAcuraDave White Chevrolet | SoutheastAcura7 | Southeast | Acura | 7 | [NAME] | 1 | 0.02 | 1 | 0.00520833333333333
SouthwestAcuraAirport Acura | SouthwestAcura1 | Southwest | Acura | 1 | [NAME] | 12 | 0.479999999999999 | 54 | 0.556701030927835
SouthwestAcuraMotorcars Acura Volvo | SouthwestAcura2 | Southwest | Acura | 2 | Motorcars Acura Volvo | 8 | 0.32 | 27 | 0.278350515463917
SouthwestAcuraPark [NAME] | SouthwestAcura3 | Southwest | Acura | 3 | [NAME] | 4 | 0.16 | 12 | 0.123711340206185
SouthwestAcuraLindsay [NAME] | SouthwestAcura4 | Southwest | Acura | 4 | [NAME] | 0 | 0 | 2 | 0.0206185567010309
SouthwestAcuraHidy Acura | [NAME] | Southwest | Acura | 5 | [NAME] | 1 | 0.04 | 1 | 0.0103092783505154
SouthwestAcuraMathews Acura | SouthwestAcura6 | Southwest | Acura | 6 | Mathews Acura | 0 | 0 | 1 | 0.0103092783505154
EastAcuraMotorcars Acura Volvo | EastAcura1 | East | Acura | 1 | Motorcars Acura Volvo | 27 | 0.402985074626865 | 127 | 0.503968253968253
EastAcuraPark Acura | EastAcura2 | East | Acura | 2 | [NAME] | 17 | 0.253731343283582 | 65 | 0.257936507936507
EastAcuraAirport Acura | EastAcura3 | East | Acura | 3 | [NAME] | 21 | 0.313432835820895 | 53 | 0.21031746031746
EastAcuraLindsay [NAME] | EastAcura4 | East | Acura | 4 | [NAME] | 0 | 0 | 3 | 0.0119047619047619
EastAcuraAcura/Mitsubishi of Boardman | EastAcura5 | East | Acura | 5 | Acura/Mitsubishi of Boardman | 0 | 0 | 2 | 0.00793650793650793
[NAME] | EastAcura6 | East | Acura | 6 | [NAME] | 1 | 0.0149253731343283 | 1 | 0.00396825396825396
EastAcuraDave White Chevrolet | EastAcura7 | East | Acura | 7 | [NAME] | 1 | 0.0149253731343283 | 1 | 0.00396825396825396
WestAcuraAirport Acura | WestAcura1 | West | Acura | 1 | [NAME] | 33 | 0.66 | 122 | 0.67032967032967
WestAcuraMotorcars Acura Volvo | WestAcura2 | West | Acura | 2 | Motorcars Acura Volvo | 12 | 0.239999999999999 | 41 | 0.225274725274725
WestAcuraPark Acura | WestAcura3 | West | Acura | 3 | [NAME] | 4 | 0.08 | 14 | 0.0769230769230769
WestAcuraLindsay Acura | WestAcura4 | West | Acura | 4 | [NAME] | 0 | 0 | 2 | 0.0109890109890109
WestAcuraHidy Acura | WestAcura5 | West | Acura | 5 | [NAME] | 1 | 0.02 | 1 | 0.00549450549450549
WestAcuraMathews Acura | [NAME] | West | Acura | 6 | Mathews Acura | 0 | 0 | 1 | 0.00549450549450549
WestAcuraAcura Columbus | WestAcura7 | West | Acura | 7 | Acura Columbus | 0 | 0 | 1 | 0.00549450549450549