Spreadsheet: 53186d1253116633-how-to-pick-up-latest-number-from-spread-sheet-september-fandi-report
Sheet: MORI

SOLD | SALE |  |  |  |  |  |  | DAILY GROSS |  |  |  |  | MONTH TO UNIT GROSS |  |  |  |  | AVERAGE GROSS AT UNIT
UNITS | DATE | CUSTOMER | STORE | YEAR | MAKE | MODEL | STOCK# | TOTAL | RESERVE | AM | WARR | GAP | TOTAL | RESERVE | AM | WARR | GAP | TOTAL | RESERVE | AM | WARR | GAP
1 | 2009-09-01 00:00:00 | MONTOYA | CORONA | 2009 | CHEVY | TAHOE | [NAME] | 1874.65 | 784.65 | 0 | 1090 | 0 | 1874.65 | 784.65 | 0 | 1090 | 0 | 1874.65 | 784.65 | 0 | 1090 | 0
2 | 2009-09-01 00:00:00 | ARGUELLES | CORONA | 2008 | CHEVY | MALIBU | C468 | 3168.4 | 826.4 | 666 | 1125 | 551 | 5043.05 | 1611.05 | 666 | 2215 | 551 | 2521.525 | 805.525 | 333 | 1107.5 | 275.5
3 | 2009-09-01 00:00:00 | NAVA | CORONA | 2008 | CHEVY | MALIBU | C499 | 270 | 0 | 270 | 0 | 0 | 5313.05 | 1611.05 | 936 | 2215 | 551 | 1771.016666666667 | 537.0166666666667 | 312 | 738.3333333333334 | 183.6666666666667
4 | 2009-09-02 00:00:00 | DANIEL | CORONA | 2009 | CHEVY | SUBURBAN | TCK0310 | 100 | 100 | 0 | 0 | 0 | 5413.05 | 1711.05 | 936 | 2215 | 551 | 1353.2625 | 427.7625 | 234 | 553.75 | 137.75
5 | 2009-09-04 00:00:00 | LEWIN | CORONA | 2010 | CHEVY | CAMARO | CCL0009 | 2667 | 300 | 786 | 1050 | 531 | 8080.05 | 2011.05 | 1722 | 3265 | 1082 | 1616.01 | 402.21 | 344.4 | 653 | 216.4
6 | 2009-09-05 00:00:00 | TAWIL | CORONA | 2009 | CHEVY | TAHOE | TCK0312 | 2327 | 100 | 541 | 1135 | 551 | 10407.05 | 2111.05 | 2263 | 4400 | 1633 | 1734.508333333333 | 351.8416666666667 | 377.1666666666667 | 733.3333333333334 | 272.1666666666667
7 | 2009-09-05 00:00:00 | FRAZEE | CORONA | 2009 | CHEVY | SUBURBAN | TCK0239 | 1706 | 100 | 366 | 1240 | 0 | 12113.05 | 2211.05 | 2629 | 5640 | 1633 | 1730.435714285714 | 315.8642857142858 | 375.5714285714286 | 805.7142857142857 | 233.2857142857143
8 | 2009-09-05 00:00:00 | GAGNER | CORONA | 2009 | CHEVY | SILVERADO | TCK0235 | 356 | 100 | 256 | 0 | 0 | 12469.05 | 2311.05 | 2885 | 5640 | 1633 | 1558.63125 | 288.88125 | 360.625 | 705 | 204.125
9 | 2009-09-07 00:00:00 | TEANO | CORONA | 2009 | CHEVY | TAHOE | TCK0313 | 2009.05 | 1198.05 | 811 | 0 | 0 | 14478.1 | 3509.1 | 3696 | 5640 | 1633 | 1608.677777777778 | 389.9 | 410.6666666666667 | 626.6666666666666 | 181.4444444444445
10 | 2009-09-07 00:00:00 | RIOS | CORONA | 2008 | CHEVY | HHR | C479 | 0 | 0 | 0 | 0 | 0 | 14478.1 | 3509.1 | 3696 | 5640 | 1633 | 1447.81 | 350.91 | 369.6 | 564 | 163.3
11 | 2009-09-07 00:00:00 | PAIT | CORONA | 2008 | SUZUKI | XL7 | C473 | 1341.8 | 730.8 | 611 | 0 | 0 | 15819.9 | 4239.900000000001 | 4307 | 5640 | 1633 | 1438.172727272727 | 385.4454545454546 | 391.5454545454546 | 512.7272727272727 | 148.4545454545455
12 | 2009-09-08 00:00:00 | NAVA | CORONA | 2009 | CHEVY | TAHOE | TCK0175 | 3384.5 | 100 | 1493.5 | 1195 | 596 | 19204.4 | 4339.900000000001 | 5800.5 | 6835 | 2229 | 1600.366666666667 | 361.6583333333334 | 483.375 | 569.5833333333334 | 185.75
13 | 2009-09-08 00:00:00 | SHEVITSKI | CORONA | 2009 | CHEVY | TAHOE | TCK0247 | 0 | 0 | 0 | 0 | 0 | 19204.4 | 4339.900000000001 | 5800.5 | 6835 | 2229 | 1477.261538461538 | 333.8384615384616 | 446.1923076923077 | 525.7692307692307 | 171.4615384615385
14 | 2009-09-08 00:00:00 | WALTER | CORONA | 2007 | HYUNDAI | ELANTRA | C476 | 0 | 0 | 0 | 0 | 0 | 19204.4 | 4339.900000000001 | 5800.5 | 6835 | 2229 | 1371.742857142857 | 309.9928571428572 | 414.3214285714286 | 488.2142857142857 | 159.2142857142857
15 | 2009-09-08 00:00:00 | MARTINEZ | CORONA | 2008 | CHEVY | HHR | C453 | 2411 | 0 | 2411 | 0 | 0 | 21615.4 | 4339.900000000001 | 8211.5 | 6835 | 2229 | 1441.026666666666 | 289.3266666666667 | 547.4333333333333 | 455.6666666666667 | 148.6
16 | 2009-09-08 00:00:00 | HEATON | CORONA | 2000 | CHEVY | SILVERADO | CK0197A | 797.59 | 171.59 | 0 | 0 | 626 | 22412.99 | 4511.490000000001 | 8211.5 | 6835 | 2855 | 1400.811875 | 281.968125 | 513.21875 | 427.1875 | 178.4375
17 | 2009-09-09 00:00:00 | ROSKI | CORONA | 2006 | FORD | TAURUS | C242 | 0 | 0 | 0 | 0 | 0 | 22412.99 | 4511.490000000001 | 8211.5 | 6835 | 2855 | 1318.411176470588 | 265.3817647058824 | 483.0294117647059 | 402.0588235294118 | 167.9411764705882
18 | 2009-09-12 00:00:00 | GAULT | CORONA | 2009 | CHEVY | IMPALA | CCK0040 | 2143 | 100 | 466 | 981 | 596 | 24555.99 | 4611.490000000001 | 8677.5 | 7816 | 3451 | 1364.221666666667 | 256.1938888888889 | 482.0833333333333 | 434.2222222222222 | 191.7222222222222
19 | 2009-09-12 00:00:00 | DRESSELHAUS | CORONA | 2008 | CHEVY | CORVETTE | CCJ0735 | 370 | 0 | 370 | 0 | 0 | 24925.99 | 4611.490000000001 | 9047.5 | 7816 | 3451 | 1311.894210526316 | 242.71 | 476.1842105263158 | 411.3684210526316 | 181.6315789473684
20 | 2009-09-12 00:00:00 | FITZPATRICK | CORONA | 2009 | CHEVY | TAHOE | TCK0073 | 1860.64 | 508.64 | 801 | 0 | 551 | 26786.63 | 5120.130000000001 | 9848.5 | 7816 | 4002 | 1339.3315 | 256.0065000000001 | 492.425 | 390.8 | 200.1
21 | 2009-09-14 00:00:00 | DISS | CORONA | 2009 | CHEVY | MALIBU | CCK0316 | 3857.97 | 1265.97 | 801 | 1240 | 551 | 30644.6 | 6386.100000000001 | 10649.5 | 9056 | 4553 | 1459.266666666667 | 304.1000000000001 | 507.1190476190476 | 431.2380952380952 | 216.8095238095238
22 | 2009-09-14 00:00:00 | MCMANUS | CORONA | 2009 | CHEVY | SILVERADO | TCK0156 | 1799.31 | 1088.31 | 711 | 0 | 0 | 32443.91 | 7474.410000000002 | 11360.5 | 9056 | 4553 | 1474.723181818182 | 339.7459090909092 | 516.3863636363636 | 411.6363636363636 | 206.9545454545455
23 | 2009-09-15 00:00:00 | STANLEY | CORONA | 2010 | CHEVY | CAMARO | CCL0020 | 1192.67 | 1192.67 | 0 | 0 | 0 | 33636.58 | 8667.080000000002 | 11360.5 | 9056 | 4553 | 1462.46 | 376.8295652173914 | 493.9347826086956 | 393.7391304347826 | 197.9565217391304
24 | 2009-09-15 00:00:00 | CRICK | CORONA | 2007 | CHEVY | COLORADO | C466 | 3300.83 | 738.83 | 811 | 1200 | 551 | 36937.41 | 9405.910000000002 | 12171.5 | 10256 | 5104 | 1539.05875 | 391.9129166666667 | 507.1458333333333 | 427.3333333333333 | 212.6666666666667
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100