Spreadsheet: 746002d1630427577-count-days-open-by-date-range-table-formula-count-days-open-by-range
Sheet: Sheet1 (2)

RO# | RO-DATE | RO-STATUS | ADV# | TECH# | YEAR | MK | MODEL | CWI | TECH-HRS | LBR-GRS-SUM-CAT | C-PART-GRS-DV | SUB-COST | MISC-AMT | Days Open |  |  |  |  |  | Open | Days
670915 | 2021-08-31 00:00:00 | NO STATUS | 2969 |  | 2017 | BM | I8 | C | 0 | 319.95 | 0 | 0 | 20.17 |  |  | RO-STATUS | Days Open | Count of Days Open |  | 0 | Days 0-1
670916 | 2021-08-31 00:00:00 | NO STATUS | 78 |  | 2018 | BF | X5 | C | 0 | 42.3 | 0 | 0 | 7.15 |  |  | FINISHED | Days 0-1 | 2 |  | 2 | Days 2-3
670808 | 2021-08-30 00:00:00 | IN PROCESS | 246 | 8865 | 2018 | BM | 650I GC | W | 2.1 | 510.38 | 0 | 0 | 24.02 |  |  |  | Days 6-10 | 1 |  | 4 | Days 4-5
670809 | 2021-08-30 00:00:00 | FINISHED | 1284 | 8709 | 2017 | BF | X5 5.0 XI | C | 7.5 | 968.23 | 276.25 | 0 | 84.97 |  |  |  | Days 11-15 | 2 |  | 6 | Days 6-10
670813 | 2021-08-30 00:00:00 | FINISHED | 58 | 571 | 2002 | BF | X5-SERIES | C | 0 | 0 | 0 | 0 | 0 |  |  |  | Days 16-20 | 2 |  | 11 | Days 11-15
670816 | 2021-08-30 00:00:00 | IN PROCESS | 2969 | 666 | 2018 | BF | X3 | C | 4 | 202 | 475.06 | 0 | 20.77 |  |  |  | Days 2-3 | 2 |  | 16 | Days 16-20
670818 | 2021-08-30 00:00:00 | IN PROCESS | 78 | 90 | 2004 | BM | 330I DISC | C | 0 | 727.41 | 9.67 | 0 | 0 |  |  |  | Days 30-59 | 3 |  | 21 | Days 21 -29
670761 | 2021-08-28 00:00:00 | NO STATUS | 8268 |  | 2015 | BF | X5 | C | 0 | 0 | 0 | 0 | 0 |  |  | FINISHED Total |  | 12 |  | 30 | Days 30-59
670768 | 2021-08-28 00:00:00 | FINISHED | 2969 | 4005 | 2003 | BM | 3-SERIES | W | 1 | 128.8 | 0 | 0 | 0 |  |  | IN PROCESS | Days 0-1 | 3 |  | 60 | Days 60 >
670771 | 2021-08-28 00:00:00 | FINISHED | 246 | 4058 | 2014 | BM | I3 REX | C | 0.6 | 16 | 38.19 | 0 | 2.47 |  |  |  | Days 6-10 | 6
670772 | 2021-08-28 00:00:00 | IN PROCESS | 2969 |  | 2019 | BF | X3 | C | 0 | 0 | 0 | 0 | 0 |  |  |  | Days 11-15 | 4
670773 | 2021-08-28 00:00:00 | IN PROCESS | 2969 | 5003 | 2016 | BF | X1 2.8 XI | W | 1.6 | 655.13 | 0 | 0 | 19.28 |  |  |  | Days 16-20 | 3
670776 | 2021-08-28 00:00:00 | NO STATUS | 8268 |  | 2018 | BM | 5 SERIES | C | 0 | 43.17 | 0 | 0 | 0 |  |  |  | Days 2-3 | 2
670745 | 2021-08-27 00:00:00 | NO STATUS | 318 |  | 2018 | BF | X1 | I | 0 | 450.37 | 0 | 0 | 34.9 |  |  |  | Days 30-59 | 3
670746 | 2021-08-27 00:00:00 | NO STATUS | 318 |  | 2019 | BF | X3 | I | 0 | 277 | 0 | 0 | 17.59 |  |  |  | Days 4-5 | 1
670747 | 2021-08-27 00:00:00 | NO STATUS | 318 |  | 2018 | BF | X5 | I | 0 | 320.17 | 0 | 0 | 23.18 |  |  | IN PROCESS Total |  | 22
670748 | 2021-08-27 00:00:00 | NO STATUS | 318 |  | 2013 | BF | X6 5.0 XI | I | 0 | 277 | 0 | 0 | 17.59 |  |  | NO STATUS | Days 0-1 | 2
670749 | 2021-08-27 00:00:00 | IN PROCESS | 2173 | 1340 | 2019 | BF | X3 | C | 0 | 0 | 16.56 | 0 | 0 |  |  |  | Days 2-3 | 2
670554 | 2021-08-26 00:00:00 | ON HOLD | 8268 | 2824 | 2017 | BM | 3 SERIES | C | 0 | 278.44 | 0 | 0 | 0 |  |  |  | Days 4-5 | 4
670555 | 2021-08-26 00:00:00 | ON HOLD | 2969 | 926 | 2006 | BM | 3-SERIES | C | 0 | 0 | 0 | 0 | 0 |  |  |  | Days 60 > | 5
670534 | 2021-08-25 00:00:00 | IN PROCESS | 92324 | 4292 | 2016 | BM | 3 SERIES | C | 1 | 115 | 0 | 0 | 9.31 |  |  | NO STATUS Total |  | 13
670536 | 2021-08-25 00:00:00 | IN PROCESS | 2969 | 451 | 2021 | BM | 3 SERIES | W | 0 | 0 | 0 | 0 | 0 |  |  | ON HOLD | Days 6-10 | 2
670543 | 2021-08-25 00:00:00 | IN PROCESS | 401 | 451 | 2011 | BM | 3 SERIES | C | 1 | 2331.79 | 167.28 | 0 | 60.92 |  |  |  | Days 11-15 | 1
670330 | 2021-08-24 00:00:00 | IN PROCESS | 401 | 2824 | 2016 | BF | X5 EDRIVE | C | 0.5 | 44.75 | 59.33 | 0 | 7.63 |  |  |  | Days 30-59 | 2
670331 | 2021-08-24 00:00:00 | ON HOLD | 58 | 4004 | 2019 | BF | X3 | W | 1 | 73.4 | 0 | 0 | 6.08 |  |  |  | Days 4-5 | 2
670335 | 2021-08-24 00:00:00 | FINISHED | 2969 | 9999 | 2008 | BM | 328IT | C | 4.3 | 449.38 | 83.36 | 0 | 44.78 |  |  |  | Days 60 > | 2
670324 | 2021-08-23 00:00:00 | IN PROCESS | 318 | 601 | 2015 | BM | I3 | I | 5.1 | 1493.35 | 256.15 | 0 | 106.6 |  |  | ON HOLD Total |  | 9
670216 | 2021-08-21 00:00:00 | IN PROCESS | 78 | 5003 | 2007 | BM | 3-SERIES | C | 5.8 | 1052.35 | 216.31 | 0 | 60.03 |  |  | Grand Total |  | 56
670217 | 2021-08-21 00:00:00 | ON HOLD | 2969 | 4058 | 2014 | BM | 550 | C | 0.5 | 3311.45 | 118.86 | 0 | 200.92
670089 | 2021-08-20 00:00:00 | IN PROCESS | 78 |  | 2004 | BM | 525I | C | 0 | 0 | 0 | 0 | 0
670098 | 2021-08-20 00:00:00 | IN PROCESS | 8268 | 674 | 2016 | BM | 3 SERIES | C | 0.5 | 1314.71 | 234.23 | 0 | 63.92
670101 | 2021-08-20 00:00:00 | ON HOLD | 8268 | 3338 | 2013 | BM | 5 SERIES | C | 0.5 | 31.3 | 0 | 0 | 6.51
669872 | 2021-08-18 00:00:00 | FINISHED | 92324 | 3332 | 2015 | BF | X5 | C | 7.45 | 1030.95 | 272.3 | 0 | 68.22
669938 | 2021-08-18 00:00:00 | IN PROCESS | 318 |  | 2021 | BM | 330I SA | W | 0 | 0 | 0 | 0 | 0
669762 | 2021-08-17 00:00:00 | FINISHED | 92324 | 926 | 2012 | BF | X5 | C | 2.9 | 232.95 | 124.63 | 0 | 24.39
669760 | 2021-08-16 00:00:00 | IN PROCESS | 318 | 786 | 2018 | BM | 3 SERIES | I | 7.1 | 624.52 | 51 | 0 | 49.13
669614 | 2021-08-14 00:00:00 | IN PROCESS | 92324 |  | 2019 | BF | X5 | C | 5.7 | 575.13 | 120.57 | 0 | 22.67
669649 | 2021-08-14 00:00:00 | IN PROCESS | 58 | 2824 | 2019 | BM | 330I | W | 1.2 | 133.96 | 0 | 0 | 4.72
669512 | 2021-08-13 00:00:00 | IN PROCESS | 58 | 4058 | 2020 | BM | 840I GC | C | 0 | 224.95 | 58.19 | 0 | 14.47
669532 | 2021-08-13 00:00:00 | FINISHED | 58 | 8709 | 2011 | BM | 135 CIA | C | 10.3 | 1524.14 | 471.66 | 0 | 60.92
669563 | 2021-08-13 00:00:00 | FINISHED | 58 | 3860 | 2019 | BF | X5 | W | 6.3 | 773.64 | 0 | 0 | 4
668369 | 2021-07-30 00:00:00 | FINISHED | 1284 | 926 | 2007 | BM | 7-SERIES | C | 2 | 297.62 | 100.59 | 0 | 23.27
668383 | 2021-07-30 00:00:00 | ON HOLD | 1284 | 373 | 2010 | BM | 3-SERIES | C | 0 | 0 | 0 | 0 | 0
668261 | 2021-07-29 00:00:00 | FINISHED | 246 | 90 | 2012 | BM | 6 SERIES | C | 13.1 | 1909.75 | 283.4 | 0 | 66.92
668319 | 2021-07-29 00:00:00 | ON HOLD | 2173 | 8518 | 2013 | BF | X3 | C | 3.6 | 289.15 | 194.44 | 0 | 20.17
667500 | 2021-07-20 00:00:00 | IN PROCESS | 246 | 601 | 2021 | BF | X3 30SI | W | 0.7 | -22.05 | 0 | 0 | 0
667194 | 2021-07-16 00:00:00 | FINISHED | 246 | 7050 | 2018 | BF | X3 30I | C | 12 | 1309.56 | 813.35 | 270 | 0.97
667125 | 2021-07-15 00:00:00 | IN PROCESS | 20 |  | 2021 | BM | 530I | C | 0 | 0 | 0 | 0 | 0
666943 | 2021-07-13 00:00:00 | IN PROCESS | 246 | 7050 | 2016 | BM | 7 SERIES | C | 0 | 64.95 | 171.76 | 0 | 0.97
665956 | 2021-07-01 00:00:00 | ON HOLD | 401 | 8518 | 2017 | BM | 3 SERIES | C | 26.8 | 3993.66 | 0 | 0 | 0.97
666000 | 2021-07-01 00:00:00 | NO STATUS | 20 |  | 2021 | BF | [NAME] | C | 0 | 0 | 0 | 0 | 0
665863 | 2021-06-30 00:00:00 | NO STATUS | 20 |  | 2021 | BM | 330I SA | C | 0 | 0 | 0 | 0 | 0
665870 | 2021-06-30 00:00:00 | NO STATUS | 20 |  | 2021 | BM | 330I SA | C | 0 | 0 | 0 | 0 | 0
664691 | 2021-06-16 00:00:00 | ON HOLD | 246 |  | 2011 | BF | X5 | C | 0 | 0 | 0 | 0 | 0
663682 | 2021-06-04 00:00:00 | NO STATUS | 20 |  | 2021 | BM | 530I | C | 0 | 0 | 0 | 0 | 0
659918 | 2021-04-20 00:00:00 | NO STATUS | 20 |  | 2021 | BM | 430I CPE | C | 0 | 0 | 0 | 0 | 0