Spreadsheet: 773312d1647787718-make-project-form-with-master-database-of-electrical-components-using-job-id-database-with-form
Sheet: Sample Data

Job ID | Project Name | Component [NAME] | Rating | Model | Make | Req. Qty. | Issued Qty. | Balance | Breif [NAME] | Status | ETA
1151(Lot-1) | ABC | 150W DIN Series 24VAC, 5A, 1 Output | MDR-100-24 | EDR-150-24 | Meanwell | 150 | 150 |  | Material Issued from Stock | Completed | -
1151(Lot-1) | ABC | 2 Gang DIN Rail Support |  |  | Local Make | 5 | 3 |  | refer to procurment | On Purchase | Two Weeks
1151(Lot-1) | ABC | 2.5 EARTH TERMINAL | ACDC-JUSLKG3 | PTV 2,5-PE - 1078963 | Klemsan / Phoenix | 450 | 300 |  | refer to procurment | Supplier's End | 2022-02-24 00:00:00
1151(Lot-1) | ABC | 230VAC Fan C/W Filter and grill 204x204 IP43 | FK6623.230 | 701.25 | Oskar / Wintop / Axial | 150 | 100 |  | refer to procurment | On Purchase | Two Weeks
1151(Lot-1) | ABC | 3-24V Electronic Tone Buzzer Alarm 95DB | PC | [NAME] | Himel/Schnieder/Galaxy | 150 | 125 |  | refer to procurment | On Purchase | Two Weeks
1152 | XYZ | 32A 3P Isolator [NAME] Lockable | CR03200G3 | GA032 C | LOVATO / Kripal | 150 | 110 |  | refer to procurment | Supplier's End | 2022-02-24 00:00:00
1152 | XYZ | AUX. SWITCH |  | OF SD | ABB | 15 | 15 |  | Material Issued from Stock | Completed | -
1152 | XYZ | AUXILIARY CONTACT BLOCK | 1NO 1NC | LAD-N11 | SCHNEIDER | 8 | 8 |  | Material Issued from Stock | Completed | -
1152 | XYZ | Cage Terminal, 2.5mm | ACDC-JST2.5 | 470105 CS 2,5/5 | Klemsan / Phoenix | 600 | 280 |  | refer to procurment | Supplier's End | 2022-02-24 00:00:00
1152 | XYZ | COMMON TRIP INDICATION LIGHT (Y) |  | AD16-22D/S | CAMSCO | 3 | 3 |  | Material Issued from Stock | Completed | -
1152 | XYZ | CONTROL RELAY WITH BASE | 220V AC |  | FINDER/EQU | 3 | 3 |  | Material Issued from Stock | Completed | -
1152 | XYZ | CONTROL TERMINAL BLOCK | 2.5mm | TB 2.5 | PHOENIX | 100 | 55 |  | refer to procurment | On Purchase | -
1151(Lot-2) | ABC | DIGITAL VOLTMETER (3-PHASE) | 0-500V | MBO3V | CIRCUTOR / SFERE | 2 | 2 |  | Material Issued from Stock | Completed | -
1151(Lot-2) | ABC | Electric Strike Lock with Night [NAME] |  | ASF802 | Chinese/DROP Bolt | 1 | 1 |  | Material Issued from Stock | Completed | -
1151(Lot-2) | ABC | END PLATE | 6mm | D-TB 6 | PHOENIX | 4 | 4 |  | Material Issued from Stock | Completed | -
1151(Lot-2) | ABC | END PLATE | 2.5mm | D-TB 2.5 | PHOENIX | 4 | 4 |  | Material Issued from Stock | Completed | -
8876 | JKL | END STOPPER |  | E/TB | SCHNEIDER | 6 | 6 |  | Material Issued from Stock | Completed | -
8876 | JKL | END STOPPER |  | E/TB | PHOENIX CONTACT | 12 | 12 |  | Material Issued from Stock | Completed | -
8876 | JKL | F17 MinitMan Fingerprint Scanner IP 65 rated |  | F1700/F1900 | ZKTECO | 1 | 1 |  | Material Issued from Stock | Completed | -
8876 | JKL | FAULT SIGNALING CONTACT | 1NO 1NC | GV2-AD1010 | SCHNEIDER | 10 | 10 |  | Material Issued from Stock | Completed | -
8876 | JKL | MCB  IC60N  DP  6A | ACDC-GW92607 | SE.A9F74616 | SCHNEIDER ELECTRIC | 150 | 80 |  | refer to procurment | On Purchase | -
8876 | JKL | MCB DOMAE SP 06A | ACDC-GW92605 | SE.A9F774606 | SCHNEIDER ELECTRIC | 300 | 250 |  | refer to procurment | On Purchase | -
8876 | JKL | M-O-A SWITCH 1 POLE |  | CA-109 | CAMSCO | 1 | 1 |  | Material Issued from Stock | Completed | -
2224 | CDE | M-O-A SWITCH 1 POLE |  | CA-109 | CAMSCO | 1 | 1 |  | Material Issued from Stock | Completed | -
2224 | CDE | Moxa 8 ports unmanaged. | PC | EDS-2008-ELP | Moxa | 15 | 4 |  | refer to procurment | On Purchase | -
2224 | CDE | ON DELAY TIMER WITH BASE | 220V AC | [NAME] | AUTONICS/TEND/NUX | 5 | 5 |  | Material Issued from Stock | Completed | -
2224 | CDE | ON/OFF PUSH BUTTONS(G.R) | 1NO, 1NC | FPB-EA | CAMSCO | 4 | 4 |  | Material Issued from Stock | Completed | -
2224 | CDE | ON/OFF/TRIP INDICATION LIGHTS(G,R,Y) | 220V AC | AD16-22D/S | CAMSCO | 27 | 27 |  | Material Issued from Stock | Completed | -
2224 | CDE | ON/OFF/TRIP INDICATION LIGHTS(G,R,Y) | 220V AC | AD16-22D/S | CAMSCO | 90 | 90 |  | Material Issued from Stock | Completed | -