Spreadsheet: 884616d1733841039-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
(blank) | 1934657 | LOCK | 2024-05-03 00:00:00 | TIME | 1.9 |  | 69
(blank) | 1934657 | LOCK | 2024-05-04 00:00:00 | TIME | 1.9 |  | 69
(blank) | 1934657 | LOCK | 2024-05-05 00:00:00 | TIME | 1.9 |  | 69
(blank) | 1934657 | LOCK | 2024-05-06 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-07 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-08 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-09 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-10 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-11 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-12 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-13 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-14 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-05-15 00:00:00 | TIME | 1.9 |  | 553
(blank) | 1934657 | LOCK | 2024-05-16 00:00:00 | TIME | 1.9 |  | 553
(blank) | 1934657 | LOCK | 2024-05-17 00:00:00 | TIME | 1.9 |  | 553
(blank) | 1934657 | LOCK | 2024-05-18 00:00:00 | TIME | 1.9 |  | 561
(blank) | 1934657 | LOCK | 2024-05-19 00:00:00 | TIME | 1.9 |  | 561
(blank) | 1934657 | LOCK | 2024-05-20 00:00:00 | TIME | 1.9 |  | 537
(blank) | 1934657 | LOCK | 2024-05-21 00:00:00 | TIME | 1.9 |  | 579
(blank) | 1934657 | LOCK | 2024-05-22 00:00:00 | TIME | 1.9 |  | 685
(blank) | 1934657 | LOCK | 2024-05-23 00:00:00 | TIME | 1.9 |  | 731
(blank) | 1934657 | LOCK | 2024-05-24 00:00:00 | TIME | 1.9 |  | 731
(blank) | 1934657 | LOCK | 2024-05-25 00:00:00 | TIME | 1.9 |  | 717
(blank) | 1934657 | LOCK | 2024-05-26 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-05-27 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-05-28 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-05-29 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-05-30 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-05-31 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-06-01 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-06-02 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-06-03 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-06-04 00:00:00 | TIME | 1.9 |  | 699
(blank) | 1934657 | LOCK | 2024-06-05 00:00:00 | TIME | 1.9 |  | 599
(blank) | 1934657 | LOCK | 2024-06-06 00:00:00 | TIME | 1.9 |  | 443
(blank) | 1934657 | LOCK | 2024-06-07 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-06-08 00:00:00 | TIME | 1.9 |  | 399
(blank) | 1934657 | LOCK | 2024-06-09 00:00:00 | TIME | 1.9 |  | 283
(blank) | 1934657 | LOCK | 2024-06-10 00:00:00 | TIME | 1.9 |  | 171
(blank) | 1934657 | LOCK | 2024-06-11 00:00:00 | TIME | 1.9 |  | 104
(blank) | 1934657 | LOCK | 2024-06-12 00:00:00 | TIME | 1.9 |  | 36
(blank) | 1934657 | LOCK | 2024-06-13 00:00:00 | TIME | 1.9 |  | 16
(blank) | 1934657 | LOCK | 2024-06-14 00:00:00 | TIME | 1.9 |  | 16
(blank) | 1934657 | LOCK | 2024-06-15 00:00:00 | TIME | 1.9 |  | 16
(blank) | 1934657 | LOCK | 2024-06-16 00:00:00 | TIME | 1.9 |  | 16
(blank) | 1934657 | LOCK | 2024-06-17 00:00:00 | TIME | 1.9 |  | 16
(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