Spreadsheet: 864348d1711554979-how-to-summarize-the-counts-based-on-4-fields-is-xlookup-or-spill-is-better-for-drop-down-products_dj
Sheet: COUNT_Item

Description | Vendor | Part_Number | Lot_Number | EXP | Total COUNT from IN_Item | Total COUNT from OUT_Item | TOTAL_REMAIN | Trigger_Level | Order_Action
 | Agilent | 5191-6595 | 6730796 | 2024-01-10 00:00:00 |  |  |  | 0.5
5191-6595 dsDNA 910/915, 500, 4C (Gel and buffer of DNF-910/915-FR) | Agilent | 5191-6595 | 6772355 | 2024-11-05 00:00:00 | 1 | 0 | 1 | 1 | Order
5x Capillary Conditioning Solution | Agilent | DNF-475-0100 | [PHONE] | 2024-01-11 00:00:00 | 1 | 0 | 1 | 0.5 | None
AmPure XP beads (BeckmanCoulter) | BeckmanCouter | A63881 | 19899400 | 2024-08-14 00:00:00 | 1 | 1 | 0 | 1 | Order
AmPure XP beads (BeckmanCoulter) | BeckmanCouter | A63881 | 19060200 | 2023-01-20 00:00:00 | 1 | 1 | 0 | 1 | Order
E-Gel EX 1% Agarose | Fisher | 0 | 0 | 00:00:00 | 0 | 0 | 0 | 1 | Order
E-Gel EX 2% Agarose | Fisher | G402022 | U290623-01 | 2024-06-29 00:00:00 | 2 | 0 | 2 | 1 | None
LYSOL L.C. QUAT. 1 GAL | Fisher | NC9645698 | NL2134703A | 2028-04-14 00:00:00 | 3 | 0 | 3 | 1 | None
NEBNext [NAME] kit for Illumina | REB | E7630L | 10157957 | 2024-05-01 00:00:00 | 1 | 0 | 1 | 0 | None
NEBNExt Q5 Hotstart HIFI Mastermix | REB | M0543L | 10107278 | 2023-04-30 00:00:00 | 63 | 63 | 0 | 0 | Order
NEBNExt Q5 Hotstart HIFI Mastermix | REB | M0543L | 10196608 | 2024-06-30 00:00:00 | 8 | 4 | 4 | 3 | None
NEBNext Quick Ligation Module | REB | E6056S | 10180435 | 2025-03-01 00:00:00 | 2 | 1 | 1 | 2 | Order
NEBNext Quick Ligation Module | REB | E6056S | 10171482 | 2023-08-24 00:00:00 | 1 | 1 | 0 | 1 | Order
AgPathID OneStep (500 reactions) | Them | 4387424 | 2203145 | 2023-03-29 00:00:00 | 1 | 1 | 0 | 1 | Order
AgPathID OneStep (500 reactions) | Them | 4387424 | 2203416 | 2023-04-11 00:00:00 | 1 | 1 | 0 | 1 | Order
E-gel EX 2% Agarose, 10/box | Them | G401002 | U171023-01 | 2024-10-17 00:00:00 | 0 | 0 | 0 | 0 | Order
GeneRuler 100bp DNA ladder, 50ug | Them | SM0243 | 2764377 | NO_EXP | 3 | 0 | 3 | 0 | None
Quant it hsDNA 1X | Them | [NAME] | 2486610 | NO_EXP | 12 | 7 | 5 | 0 | None
Quant-iT 1X dsDNA BR Assay Standards | Them | Q33264 | 2507859 | NO_EXP | 1 | 0 | 1 | 0 | None
Qubit 1X dsDNA HS Assay [NAME] | Them | Q33231 | 2373198 | NO_EXP | 2 | 2 | 0 | 5 | Order
sequencing standard kit V3.1 | Them | 4404312 | 2805011 | NO_EXP | 1 | 0 | 1 | 5 | Order
S_III OneStep_PlatinumTaq | Them | 12574-026 | 2416647 | 2027-03-14 00:00:00 | 14 | 10 | 4 |  | None
S_III OneStep_PlatinumTaq | Them | 12574-026 | 2441027 | 2027-03-17 00:00:00 | 12 | 6 | 6 | 5 | None
S_III OneStep_PlatinumTaq | Them | 12574-026 | 2455789 | 2027-06-21 00:00:00 | 1 | 0 | 1 |  | None
S_III OneStep_PlatinumTaq | Them | 12574-026 | 2531338 | 2027-10-12 00:00:00 | 5 | 0 | 5 |  | None
S_III OneStep_PlatinumTaq | Them | 12574-026 | 2339004 | 2026-04-14 00:00:00 | 2 | 2 | 0 | 1 | Order
S_III OneStep_PlatinumTaq_HiFi | Them | 12574-035 | 2463624 | 2024-04-14 00:00:00 | 2 | 2 | 0 |  | Order
S_III OneStep_PlatinumTaq_HiFi | Them | 12574-035 | 2498497 | 2024-09-05 00:00:00 | 1 | 0 | 1 |  | None
S_III OneStep_PlatinumTaq_HiFi | Them | 12574-035 | 2769088 | 2025-10-22 00:00:00 | 2 | 0 | 2 |  | None
S_IV First-Strand Synthesis System | Them | 18091050 | 1236186 | 2024-01-31 00:00:00 | 1 | 1 | 0 |  | Order
S_IV First-Strand Synthesis System | Them | 18091050 | 1245462 | 2024-01-31 00:00:00 | 1 | 1 | 0 | 1 | Order
S_IV First-Strand Synthesis System | Them | 18091050 | 2694218 | 2024-08-31 00:00:00 | 8 | 8 | 0 |  | Order
S_IV First-Strand Synthesis System | Them | 18091050 | 12383617 | 2024-03-31 00:00:00 | 10 | 10 | 0 | 2 | Order
S_IV First-Strand Synthesis System | Them | 18091050 | 2658152 | 2024-08-31 00:00:00 | 6 | 6 | 0 |  | Order
S_IV First-Strand Synthesis System | Them | 18091050 | 2847620 | 2025-03-31 00:00:00 | 12 | 2 | 10 |  | None