Spreadsheet: 884531d1733759996-find-min-qty-base-on-no-of-consecutive-days-sample-data-1-abc10-
Sheet: Calculation

 |  |  |  |  |  |  |  |  |  |  | Min qty within range of UNIT# from Column H(greater then 0 and consecutive days) | =H4-L4 | Min qty within range of UNIT# from Column M (greater than 0 and consecutive days) | =M3-20 | Min qty within range of UNIT# from Column O(greater then 0 and consecutive days) | =O4-p4 | Min qty within range of UNIT# from Column Q(grateater then 0 and consecutive days) | =[NAME] | Min qty within range of UNIT# from Column S(grateater then 0 and consecutive days) | =S4-T4 | Min qty within range of UNIT# from Column U (grateater then 0 and consecutive days) | =U4-V4 | Min qty within range of UNIT# from Column W (grateater then 0 and consecutive days) | =[NAME] | Min qty within range of UNIT# from Column Y (grateater then 0 and consecutive days) | =Y4-Z4 | Min qty within range of UNIT# from Column AA (grateater then 0 and consecutive days) | =AA4-Ab4 | Min qty within range of UNIT# from Column AC (grateater then 0 and consecutive days) | =[NAME] | Min qty within range of UNIT# from Column AE (grateater then 0 and consecutive days) | =AE4-AF4 | Min qty within range of UNIT# from Column AG (grateater then 0 and consecutive days) | =[NAME] | Min qty within range of UNIT# from Column AI (grateater then 0 and consecutive days) | [NAME]
VENDUNIT | Equip# | EQUIPDESC | WORKDATE | EQUIPType | RATE | Sum of EquipCost | Sum of EQUIPQTY | [NAME] | Status | QTY Check |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remaining
(blank) | 1934657 | LOCK | 2024-05-02 00:00:00 | TIME | 1.9 |  | 69 |  |  |  | 16 |  | 20 |  | 33
(blank) | 1934657 | LOCK | 2024-05-03 00:00:00 | TIME | 1.9 |  | 69 |  |  |  | 16 |  | 20 |  | 33
(blank) | 1934657 | LOCK | 2024-05-04 00:00:00 | TIME | 1.9 |  | 69 |  |  |  | 16 |  | 20 |  | 33
(blank) | 1934657 | LOCK | 2024-05-05 00:00:00 | TIME | 1.9 |  | 69 |  |  |  | 16 |  | 20 |  | 33
(blank) | 1934657 | LOCK | 2024-05-06 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-07 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-08 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-09 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-10 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-11 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-12 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-13 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-14 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-05-15 00:00:00 | TIME | 1.9 |  | 553 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94
(blank) | 1934657 | LOCK | 2024-05-16 00:00:00 | TIME | 1.9 |  | 553 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94
(blank) | 1934657 | LOCK | 2024-05-17 00:00:00 | TIME | 1.9 |  | 553 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94
(blank) | 1934657 | LOCK | 2024-05-18 00:00:00 | TIME | 1.9 |  | 561 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94
(blank) | 1934657 | LOCK | 2024-05-19 00:00:00 | TIME | 1.9 |  | 561 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94
(blank) | 1934657 | LOCK | 2024-05-20 00:00:00 | TIME | 1.9 |  | 537 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94
(blank) | 1934657 | LOCK | 2024-05-21 00:00:00 | TIME | 1.9 |  | 579 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42
(blank) | 1934657 | LOCK | 2024-05-22 00:00:00 | TIME | 1.9 |  | 685 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86
(blank) | 1934657 | LOCK | 2024-05-23 00:00:00 | TIME | 1.9 |  | 731 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-05-24 00:00:00 | TIME | 1.9 |  | 731 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-05-25 00:00:00 | TIME | 1.9 |  | 717 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-05-26 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-05-27 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-05-28 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-05-29 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-05-30 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-05-31 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-06-01 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-06-02 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-06-03 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-06-04 00:00:00 | TIME | 1.9 |  | 699 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20 |  | 86 |  | 14
(blank) | 1934657 | LOCK | 2024-06-05 00:00:00 | TIME | 1.9 |  | 599 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44 |  | 94 |  | 42 |  | 20
(blank) | 1934657 | LOCK | 2024-06-06 00:00:00 | TIME | 1.9 |  | 443 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116 |  | 44
(blank) | 1934657 | LOCK | 2024-06-07 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-06-08 00:00:00 | TIME | 1.9 |  | 399 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112 |  | 116
(blank) | 1934657 | LOCK | 2024-06-09 00:00:00 | TIME | 1.9 |  | 283 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67 |  | 112
(blank) | 1934657 | LOCK | 2024-06-10 00:00:00 | TIME | 1.9 |  | 171 |  |  |  | 16 |  | 20 |  | 33 |  | 35 |  | 67
(blank) | 1934657 | LOCK | 2024-06-11 00:00:00 | TIME | 1.9 |  | 104 |  |  |  | 16 |  | 20 |  | 33 |  | 35
(blank) | 1934657 | LOCK | 2024-06-12 00:00:00 | TIME | 1.9 |  | 36 |  |  |  | 16 |  | 20
(blank) | 1934657 | LOCK | 2024-06-13 00:00:00 | TIME | 1.9 |  | 16 |  |  |  | 16
(blank) | 1934657 | LOCK | 2024-06-14 00:00:00 | TIME | 1.9 |  | 16 |  |  |  | 16
(blank) | 1934657 | LOCK | 2024-06-15 00:00:00 | TIME | 1.9 |  | 16 |  |  |  | 16
(blank) | 1934657 | LOCK | 2024-06-16 00:00:00 | TIME | 1.9 |  | 16 |  |  |  | 16
(blank) | 1934657 | LOCK | 2024-06-17 00:00:00 | TIME | 1.9 |  | 16 |  |  |  | 16
 |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  | Week
 |  |  |  |  |  |  |  |  |  | Day
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-04 00:00:00 | TIME | 4.45 |  | 180
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-05 00:00:00 | TIME | 4.45 |  | 180
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-06 00:00:00 | TIME | 4.45 |  | 1132
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-07 00:00:00 | TIME | 4.45 |  | 1012
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-08 00:00:00 | TIME | 4.45 |  | 1012
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-09 00:00:00 | TIME | 4.45 |  | 1012
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-10 00:00:00 | TIME | 4.45 |  | 1012
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-11 00:00:00 | TIME | 4.45 |  | 1012
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-12 00:00:00 | TIME | 4.45 |  | 1012
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-13 00:00:00 | TIME | 4.45 |  | 1012
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-02 00:00:00 | TIME | 4.45 |  | 180
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-03 00:00:00 | TIME | 4.45 |  | 180
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-07 00:00:00 | TIME | 4.45 |  | 120
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-08 00:00:00 | TIME | 4.45 |  | 120
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-09 00:00:00 | TIME | 4.45 |  | 120
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-10 00:00:00 | TIME | 4.45 |  | 120
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-11 00:00:00 | TIME | 4.45 |  | 120
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-12 00:00:00 | TIME | 4.45 |  | 120
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-13 00:00:00 | TIME | 4.45 |  | 120
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-14 00:00:00 | TIME | 4.45 |  | 1132
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-15 00:00:00 | TIME | 4.45 |  | 1492
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-16 00:00:00 | TIME | 4.45 |  | 1492
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-17 00:00:00 | TIME | 4.45 |  | 1492
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-18 00:00:00 | TIME | 4.45 |  | 1516
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-19 00:00:00 | TIME | 4.45 |  | 1528
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-20 00:00:00 | TIME | 4.45 |  | 1528
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-21 00:00:00 | TIME | 4.45 |  | 1546
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-22 00:00:00 | TIME | 4.45 |  | 1564
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-23 00:00:00 | TIME | 4.45 |  | 1688
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-24 00:00:00 | TIME | 4.45 |  | 1688
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-25 00:00:00 | TIME | 4.45 |  | 1688
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-26 00:00:00 | TIME | 4.45 |  | 1664
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-27 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-28 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-29 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-30 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-05-31 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-01 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-02 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-03 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-04 00:00:00 | TIME | 4.45 |  | 1646
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-05 00:00:00 | TIME | 4.45 |  | 1411
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-06 00:00:00 | TIME | 4.45 |  | 971
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-07 00:00:00 | TIME | 4.45 |  | 885
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-08 00:00:00 | TIME | 4.45 |  | 885
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-09 00:00:00 | TIME | 4.45 |  | 706
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-10 00:00:00 | TIME | 4.45 |  | 355
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-11 00:00:00 | TIME | 4.45 |  | 263
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-12 00:00:00 | TIME | 4.45 |  | 68
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-13 00:00:00 | TIME | 4.45 |  | 48
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-14 00:00:00 | TIME | 4.45 |  | 48
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-15 00:00:00 | TIME | 4.45 |  | 48
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-16 00:00:00 | TIME | 4.45 |  | 48
(blank) | 1934987 | HOSE -  QUICK CONNECT | 2024-06-17 00:00:00 | TIME | 4.45 |  | 48