Spreadsheet: 885557d1735253389-quick-question-about-how-to-omit-certain-characteristic-rows-from-an-overall-calculation-test-booklet-for-house-deals
Sheet: Sheet1

Working Days |  | 25 |  | Trade-in | under allowance | -6900 |  | SOLD NEW | 19 | Warranties Sold | 10 |  |  | SALES COMMISSIONS | 1401.31 | Front End Gross - NEW | -20457.5
Days Worked |  | 19 |  | Trade-in | over allowance | 0 |  | SOLD USED | 16 | Warranty Penetration | 0.2857 |  |  |  |  | Front End Gross - USED | -18565.12
 |  |  | worked |  |  |  |  |  |  | Finance Deals | 20
 |  |  |  |  |  |  |  | TRACKING NEW | 25 | Finance Penetration | 0.5714 |  |  | NVDR's | 10 | Back End Gross - NEW | 21169.22
 |  |  |  |  | NEW 2023's | 8 |  | TRACKING USED | 21 | TRACKING TOTAL UNITS | 46 |  |  |  |  | Back End Gross - USED | 25638.45
2024-09-01 00:00:00 |  |  |  |  | TRACKING = |  |  | #[NAME]! |  | GROSS TRACKING = | 10243.49 |  |  | -39022.62 | 46807.67 | 7785.05 | NEW
 | DATE | Deal # | N / U | Trade | ACV | Trade Allowance | Trade | Customer Name | age | YR / Make / Model | VSC | F&I | Stock # | FRONT END GROSS | BACK END GROSS | TOTAL DEAL GROSS | SALES 1
 |  |  |  |  |  | Used in Deal | Over / Under
1 | 2024-12-02 00:00:00 | 11573 | New |  |  |  | 0 | Turner |  | 25 Jeep Compass | Yes | F&I | ST534434 | -1748.66 | 4414.63 | 2665.97 | [NAME]
2 | 2024-12-04 00:00:00 | 11594 | Used |  |  |  | 0 | [NAME] |  | 2019 Chevrolet 1500 | No | $ | KG178405 | -647.98 |  | -647.98 | House
3 | 2024-12-04 00:00:00 | 11610 | New | 2016 Jeep Wrangler | 13500 | 12700 | -800 | Guevara |  | 2024 Jeep Gladiator | No | F&I | RL100685 | -4783.44 | 2773.91 | -2009.53 | [NAME]
4 | 2024-12-05 00:00:00 | 11620 | Used |  |  |  | 0 | Dobbins |  | 2019 Nissan Altima | No | F&I | KC229853P | -2462.83 |  | -2462.83 | Tarin
5 | 2024-12-06 00:00:00 | 11428 | Used | 2019 Impala | 1500 | 1000 | -500 | Wilkins |  | 2020 Versa | No | F&I | LL844045 | 1218.41 | 194.66 | 1413.07 | [NAME]
6 | 2024-12-06 00:00:00 | 11546 | New |  |  |  | 0 | [NAME] |  | 2024 Pacifica | No | $ | RR121372 | -5432.84 |  | -5432.84 | Tarin
7 | 2024-12-07 00:00:00 | 11645 | Used |  |  |  | 0 | Atkins |  | 2021 Durango | Yes | F&I | MC793264P | 205 | 2922.16 | 3127.16 | Tarin
8 | 2024-12-07 00:00:00 | 11642 | Used |  |  |  | 0 | Sanchez | 225 | 2015 Ford F150 | No | $ | FKD98603P | -5964.84 |  | -5964.84 | [NAME]
9 | 2024-12-07 00:00:00 | 11646 | Used |  |  |  | 0 | Hernandez | 63 | 2008 Corvette | No | $ | 85100403 | -143.96 |  | -143.96 | [NAME]
10 | 2024-12-07 00:00:00 | 11550 | Used |  |  |  | 0 | Lopez | 61 | 2021 Chev Exp Van | No | $ | m1301445P | -3437 |  | -3437 | [NAME]
11 | 2024-12-09 00:00:00 | 11665 | Used | 2019 Mercedes C-Class | 19500 | 19500 | 0 | Jordan |  | 2022 Dodge Durango | No | F&I | NC205763 | 1000 | 300 | 1300 | House
12 | 2024-12-09 00:00:00 | 11666 | New | 2022 Ram 1500 | 26500 | 24000 | -2500 | Keepers |  | 2024 Ram 1500 | No | F&I | RN150623 | 6176.75 | 1567 | 7743.75 | [NAME]
13 | 2024-12-10 00:00:00 | 11674 | Used |  |  |  | 0 | Torres | 94 | 2018 F150 | Yes | F&I | JKF02337P | -851.38 | 3613.41 | 2762.03 | [NAME]
14 | 2024-12-12 00:00:00 | 11715 | New | 2023 Honda Ridgeline | 30100 | 29000 | -1100 | Riddle |  | 2025 Ram 1500 | NO | F&I | SN634140 | -3370.03 | 534.36 | -2835.67 | House
15 | 2024-12-13 00:00:00 | 11718 | Used |  |  |  | 0 | Kimmel | 80 | 2020 LR RR Evoque | YES | F&I | LH029768 | -4072.52 | 2659 | -1413.52 | JACK
16 | 2024-12-13 00:00:00 | 11722 | USED | 2017 CHEVY MALIBU | 7000 | 5500 | -1500 | KEMP | 97 | 2021 JEEP WRANGLER | YES | F&I | MW526578P | -36.29 | 5238.22 | 5201.93 | JOE
17 | 2024-12-14 00:00:00 | 11693 | Used |  |  |  | 0 | Caldwell | 58 | 2019 HYUN SANTA FE | YES | F&I | KU302178 | 1117.03 | 1868.79 | 2985.82 | TARIN
18 | 2024-12-14 00:00:00 | 11735 | Used |  |  |  | 0 | REYES | 70 | 2021 RAM 1500 | YES | F&I | MN669545 | -2241.06 | 3692.84 | 1451.78 | TARIN
19 | 2024-12-16 00:00:00 | 11725 | Used |  |  |  | 0 | [NAME] | 87 | 2023 Dodge Charger | Yes | F&I | PH571668P | -3967.34 | 3400.64 | -566.7 | Tarin
20 | 2024-12-16 00:00:00 | 11737 | NEW | 2019 RAM 1500 | 20500 | 20000 | -500 | KELLER |  | 2025 COMPASS | No | F&I | ST535262 | -952.56 | 1190.89 | 238.33 | FERNANDO
21 | 2024-12-18 00:00:00 | 11779 | NEW |  |  |  | 0 | LOZANO |  | 2025 COMPASS | Yes | F&I | ST29666 | 786.94 | 4337.86 | 5124.8 | [NAME]
22 | 2024-12-20 00:00:00 | 11801 | New |  |  |  | 0 | STEELE 33 |  | 2023 Wrangler | NO | $ | PW522732 | $- |  | $- | HOUSE
23 | 2024-12-20 00:00:00 | 11802 | New |  |  |  | 0 | STEELE 33 |  | 2023 Wrangler 4xe | NO | $ | PW566495 | $- |  | $- | House
24 | 2024-12-20 00:00:00 | 11803 | New |  |  |  | 0 | STEELE 33 |  | 2023 Gladiator | NO | $ | PL565498 | $- |  | $- | House
25 | 2024-12-20 00:00:00 | 11805 | New |  |  |  | 0 | STEELE 33 |  | 2023 Gladiator | NO | $ | PL525167 | $- |  | $- | House
26 | 2024-12-20 00:00:00 | 11807 | New |  |  |  | 0 | STEELE 33 |  | 2023 Challenger | NO | $ | PH645295 | $- |  | $- | House
27 | 2024-12-20 00:00:00 | 11808 | New |  |  |  | 0 | STEELE 33 |  | 2023 Challenger Scat | NO | $ | PH692608 | $- |  | $- | House
28 | 2024-12-20 00:00:00 | 11809 | New |  |  |  | 0 | STEELE 33 |  | 2023 Challenger | NO | $ | PH620908 | $- |  | $- | House
29 | 2024-12-20 00:00:00 | 11810 | New |  |  |  | 0 | STEELE 33 |  | 2023 Challenger | NO | $ | PH669208 | $- |  | $- | House
30 | 2024-12-20 00:00:00 | 11806 | New | 2022 Charger | 15900 | 15900 | 0 | Anaya |  | 2025 Jeep Grand Cher | Yes | F&I | SC280252 | -118.53 | 1595 | 1476.47 | Tarin
31 | 2024-12-20 00:00:00 | 11676 | New |  |  |  | 0 | Cardenas/Almada |  | 2024 [NAME] PHEV | NO | F&I | RR137893 | -4539.94 | 1198.15 | -3341.79 | [NAME]
32 | 2024-12-21 00:00:00 | 11814 | New |  |  |  | 0 | Salinas |  | 2024 Ram 2500 |  | $ | RG329003 | -3668.12 | 1347 | -2321.12 | [NAME]
33 | 2024-12-21 00:00:00 | 11826 | Used |  |  |  | 0 | Isales |  | 2014  Encore |  | F&I | [NAME] | -1562.14 | 1748.73 | 186.59 | [NAME]
34 | 2024-12-21 00:00:00 | 11833 | New | 2021 Ram 1500 | 18500 | 18500 | 0 | Palacios |  | 2025 Ram 1500 |  | F&I | SN616092 | -2807.07 | 2210.42 | -596.65 | [NAME]
35 | 2024-12-23 00:00:00 | 11856 | Used |  |  |  | 0 | [NAME] |  | 2018 Ford Mustang |  | $ | J5184184P | 3281.78 |  | 3281.78 | [NAME]
36 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | $-