Spreadsheet: 769716d1645649108-help-with-formula-to-pull-description-and-add-quantities-from-lookup-list-bom-template
Sheet: Parts List

CCTV |  |  |  |  | Access |  |  |  |  | Intrusion |  |  |  |  | Headend |  |  |  |  |  | Networking |  |  |  | Vendors
QTY | Part No. | Descriptions | Cost |  | QTYs | Part No. | Descriptions | Cost |  | QTYs | Part No. | Desriptions | Cost |  | QTYs | Part No. | Desriptions | Cost |  | QTYs | Part No. | Desriptions | Cost |  | [NAME] | Contact Person | [NAME] | Phone
 | ADV-CAM-P-5y | Genetec™ Advantage for 1 Omnicast™ [NAME] – 5 |  |  |  | 5200C | HES Strike | 105 |  |  | 8080-T | 3/4" Recessed Contact | 3.3 |  |  | 24 Port Patch Panel | 24 Port Patch Panel | 60 |  |  | U6-Pro-US | Access Point Wifi 6 Pro | 149 |  | ADI | [NAME] | [EMAIL] | [PHONE]
 | GSC-OM-P-1C | 1 camera connection |  |  |  | 8080-T | 3/4" Recessed Contact | 3.3 |  |  | AC-100 | Glass Break Detector | 35.85 |  |  | 27 RU Rack | 27 RU Rack | 1500 |  |  |  |  |  |  | Wesco | [NAME] | [EMAIL] | [PHONE]
 | HT-F1XX-WM | Wall mount for the (TNO-X6072EPT1-Z, TNO-X8072EPT1-Z, and TNO-X6322EPT1-Z) | 484.5 |  |  | Connection to Lock | Lock provided by other we connect to the lock | 0 |  |  | [NAME] SET | Outdoor Sounder | 35.9 |  |  | 43" Monitor |  | 660 |  |  |  |  |  |  | SES
 | License PN TBD | Part number Calculated at bottom | 84.15 |  |  | DS-160 | Request to Exit Motion Detector | 59.9 |  |  | [NAME] | Motion Detector 90' | 116 |  |  | 48 Port Patch Panel | 48 Port Patch Panel | 90 |  |  |  |  |  |  | 3xLogic | [NAME] | [EMAIL] | [PHONE]
 | PNM-9084RQZ | 2MP x 4ch multi-directional camera, Motorized PTRZ support, [NAME]. 60fps@2MP(H.265, H.264), 3.2~10mm(3.1x) motorized varifocal lens, IR viewable length : 30m, H.265, H.264, MJPEG codec, Multi streaming, Video analytics, WiseStreamⅡ, IP66, IK10, NEMA4X | 1468.8 |  |  | PLATEDGB-CHAR | US Metal Plate for double [NAME] color | 10.4 |  |  | [NAME] | 360 degree motion detector | 49.8 |  |  | ADV-STANDARD-U-5Y | Genetec™ Advantage Flat Rate for 1 Unified Omnicast™ or Synergis™ Standard system – 5 years | 525 |  |  |  |  |  |  | Genetec | [NAME] | [EMAIL]
 | QNV-6012R1 | Wisenet Q network indoor dome camera, 2MP @ 30fps, 2.8mm fixed focal lens (113°), triple codec H.265/H.264/MJPEG with Wisestream II, 120dB WDR, IR LEDs range 65', defocus detection, hallway View, no audio in/out, SD card, video analytics, CVBS, open platform, PoE/12VDC, white color | 201.45 |  |  | PLATEGB-CHAR | US Metal Plate for single [NAME] color | 5.78 |  |  | GRI 200-36 | Overhead Door Contact | 23.1 |  |  | [NAME] | Altronix 4Amp Power Supply | 164.9 |  |  |  |  |  |  | Unifi
 | QNV-6082R1 | Wisenet Q network outdoor vandal dome camera, 2MP @ 30fps, motorized vari-focal lens 3.1x (3.2 ~ 10.0mm) (109°~33°), triple codec H.265/H.264/MJPEG with Wisestream II, 120dB WDR, IR LEDs range 98', defocus detection, hallway View, no audio in/out, SD card, video analytics, CVBS, open platform, IP66, IK10, PoE/12VDC, white color | 272.85 |  |  | R-MPKW-CHAR-AH | MINI Metal Surface Mount Prox Reader - HID Compatible + backlit keypad - Wiegand output- Charcoal color | 231 |  |  | HS2LCDENG N | DSC English LED Keypad | 99.95 |  |  | BP72V24RTEXL | UPS battery extention pack. | 1260 |  |  |  |  |  |  | Compass | [NAME] | [EMAIL] | [PHONE]
 | [NAME] | Wisenet Q network outdoor vandal dome camera, 5MP @ 30fps, 2.8mm fixed focal lens (104°), triple codec H.265/H.264/MJPEG with Wisestream II, 120dB WDR, IR LEDs range 65', defocus detection, hallway [NAME],  SD card, video analytics, CVBS, open platform, IP66, IK10, PoE, white color | 239.7 |  |  | R-MPW-CHAR-AH | MINI Metal Surface Mount Prox reader – HID Compatible - Wiegand output - Charcoal color | 92.4 |  |  | HUSK-20 | Holdup button. | 15.8 |  |  | CAD Engineering | CAD Fee |  |  |  |  |  |  |  | Grainger
 | SBP-122HMW | [NAME] adapter for the (QND-8080R/6082R, QNV-8010R/20R/30R, QNV-6012R/22R/32R, LNV-6012R/22R/32R, HCF-8010V ), white color |  |  |  | S-EIDC32 | eIDC - PoE network door controller supports one (1) door with one (IN only) or two (IN/OUT) readers. Includes the faceplate, plaster ring and mounting screws. 2 year warranty. Minimum order quantity: 1 | 341 |  |  |  |  |  |  |  | EXR2000RT2U | [NAME] backup. (860W/4 hour backup time) | 1130 |  |  |  |  |  |  | See Final Part Number At Bottom
 | SBP-300BW | Wall Mount Base, Works with Mounts SBP-300WMW1, white |  |  |  | S-SNSR-180-12-W | GRI 180-12-W Steel Door Switch Set (White). Bag of 10. Minimum order quantity:  1 _x000D_ | 33.06 |  |  |  |  |  |  |  | GSC-1MobileU | 1 Security Center Mobile app connection | 137.5
 | SBP-300KMW | Corner Mount Adapter Accessory, use with SBP-300WMW1, White color, made of aluminum |  |  |  | S-SNSR-29-A-W | GRI 29-A-W Surface Mount Switch Set (White). Bag of 10. Minimum order quantity:  1 _x000D_ | 26.07 |  |  |  |  |  |  |  | GSC-BASE-5.10 | Genetec Security Center (GSC) Base Package - Version  5.10 which includes: 1 Directory, 5 Security Desk client  connections (incl. Web Client), Plan Manager Basic,  Alarm Management, Advanced Reporting, System  Partitioning, [NAME], IO [NAME], Email Support, [NAME] (actual macros sold  separately), Support for server virtualization, all  supported languages. Must purchase a SynergisTM,  OmnicastTM, or [NAME] base package to enable  access control, video, or LPR content respectively. | 0
 | SBP-300WMW1 | Wall Mount Accessory (white), Compatible with white hanging caps |  |  |  | SY-40KNKS-00-000000 | HID Signo 40 reader, Wall mount, 13.56mHz &125kHz, OSDP/Wiegand, Pigtail, [NAME], BLE | 289.25 |  |  |  |  |  |  |  | GSC-OM-P | GSC Omnicast™ Professional Package which includes:  Archiving support, Media Router, [NAME], Remote Security Desk, Camera Sequences, Camera Blocking, Camera  Dewarping, Time Zone, [NAME] recording, trickling and  archive transfer, [NAME] and [NAME], [NAME].  250 cameras, [NAME]. 10 clients, [NAME]. 20 Archivers | 621.5
 | [NAME] | Can be used with PNM-9084RQZ/9085RQZ. Mount screw size : PF 1 1/2", White | 1.05 |  |  | SY-40NKS-00-000000 | HID Signo 40 reader, Wall mount, 13.56mHz &125kHz, OSDP/Wiegand, Pigtail, [NAME], BLE | 176.15 |  |  |  |  |  |  |  | HS2128NK | DSC Alarm Control Panel | 215
 | SBP-390WMW2 | Wall Mount Accessory, 2x knock out built-in, compatible with all full size outdoor PTZs and all caps, Ivory color PNM-9084RQZ | 1.06 |  |  | SY-LP1501 | Mercury [NAME], [NAME],  2In/2Out/2Rd, PoE+ Support (Software Connections included) | 454.8 |  |  |  |  |  |  |  | HSM2108 | [NAME] | 29.2
 | TNO-X6072EPT1-Z | Explosion proof camera using the XNB-6000 (2MP @ 60fps) + 2.8~9mm Lens PoE Only (No Wiper), -40°C ~ +55°C (-40°F ~ +131°F), type 4x, IP66, FM (Factory Mutual)”, C1/D1 certification | 3544.5 |  |  | Vonduprin 4200 | HES Strike | 105 |  |  |  |  |  |  |  | Misc-Pathway | [NAME] | 3000
 | WAVE-PRO-01 | WAVE Professional License. Enables one (1) IP stream recording, includes life-time SW upgrade. No annual & maintenance cost required. | 84.15 |  |  | GRI 200-36 | Overhead Door Contact | 23.1 |  |  |  |  |  |  |  | Nook PC |  | 550
 | WAVE-PRO-04 | WAVE Professional License. Enables four (4) IP stream recording, includes life-time SW upgrade. No annual & maintenance cost required. | 336.6 |  |  |  |  |  |  |  |  |  |  |  |  | Programming | Programming Fee
 | WAVE-PRO-08 | WAVE Professional License. Enables eight (8) IP stream recording, includes life-time SW upgrade. No annual & maintenance cost required. | 673.2 |  |  |  |  |  |  |  |  |  |  |  |  | S-ACC-CLM | Infinias Clam Shell Card.  Minimum Order Quantity: 25 | 1.62
 | WAVE-PRO-16 | WAVE Professional License. Enables sixteen (16) IP stream recording, includes life-time SW upgrade. No annual & maintenance cost required. | 1346.4 |  |  |  |  |  |  |  |  |  |  |  |  | SE3333H | MorphoManager® PRO With Enrollment Reader | 150
 | WAVE-PRO-24 | WAVE Professional License. Enables twenty-four (24) IP stream recording, includes life-time SW upgrade. No annual & maintenance cost required. | 2019.6 |  |  |  |  |  |  |  |  |  |  |  |  | SQL Server |  | 1000
 | WAVE-PRO-48 | WAVE Professional License. Enables forty-eight (48) IP stream recording, includes life-time SW upgrade. No annual & maintenance cost required. | 4039.2 |  |  |  |  |  |  |  |  |  |  |  |  | SV-2011E-R14-160T-16-210 | Streamvault™ 2011E series - 2U 14 Bay Streamvault™  Appliance 160TB (1) [NAME] 4210 16GB RAM (2)  240GB M.2 SSD (10) 16TB SATA HDD (2) 1GbE RJ45  Ports (2) 1100W PSU Windows Server 2019, Supports  Data RAID 0, 1, 5, 6, 10,  5YR NBD KYHD Warranty.  Genetec™ Security Center pre-installed. License sold  separately. | 12243
 | XNF-8010RW | Wisenet X powered by Wisenet 5 network indoor fisheye (white color), 6MP CMOS sensor, 2048x2048 @ 30fps, 1.6mm fixed lens (192°), triple codec H.265/H.264/MJPEG with WiseStream II technology, 120dB WDR, USB port for easy installation, advanced video, sound classification and business analytics, high powered IR LEDs range of 49', simple focus, dual SD card, HLC, defog detection, DIS, 12VDC/PoE, white color | 484.5 |  |  |  |  |  |  |  |  |  |  |  |  | SV-2011E-R6S-D480-236 | Streamvault™ 2011E Appliance series Rackmount 1U    (1) [NAME]   (2) 1GbE RJ45 (2) 480GB 2.5 hot-plug SSD  (2) 350W PSU, Windows Server IoT Standard  2019,  RAID1 for OS Drives, no RAID for archive drives,   5YR NBD KYHD, [NAME], Genetec™ Security  Center pre-installed. License sold separately | 3979.25
 | PNM-7002VD | Network vandal outdoor Multi-sensor Multi-Directional dome camera, (2MP X 2 sensors sold separately) 4MP @ 60fps, modular lenses from 2.4, 2.8, 3.6 and 6mm lenses, triple codec H.265/H.264/MJPEG with WiseStream II technology, 150dB WDR, built in analytics, 4x SD card, hallway view, HLC, defog detection, DIS, PoE, IP66/IK10, -40°C ~ +55°C (-40°F ~ +131°F). [NAME] modules: SLA-2M2402D (2.4mm), [NAME] (2.8mm), SLA-2M3602D (3.6mm), SLA-2M6002D (6mm). WHITE COLOR | 561 |  |  |  |  |  |  |  |  |  |  |  |  | TL880LTVZ N | DSC Alarm Communicator | 201
 | [NAME] | 1/2.8" 2MP CMOS with a 2.8mm fixed focal lens, FoV: H: 107.4˚, V: 62.2˚, for the PNM-7002VD | 43.35 |  |  |  |  |  |  |  |  |  |  |  |  | USW-24 | 24 Port Switch | 650
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USW-48 | 48 Port Switch | 1200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WRR-P-S202W1-96TB | [NAME] Recorder with 4 Professional licenses, [NAME], 96TB raw (74TB usable after disk formatting & RAID 6 configuration), 470 [NAME] recording B/W, 14 HDD Bay (3.5"), [NAME], 16GB RAM, Dual 240GB SSD OS drives (RAID 1), Windows 10 Pro, Support RAID 0/1/5/6 + 8GB NV cache, Nvidia GPU, MiniDP output, VGA output, [NAME] NICs, IPMI, Redundant 750W power supplies, [NAME] and mouse included, [NAME] kit included | 15129.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USG-PRO-4 | Gateway | 450
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GSC-Sy-S | GSC Synergis™ Standard Package which includes: 1  Access Manager. [NAME]. 64 readers, [NAME]. 1 Access  Manager, [NAME]. 5 clients, [NAME]. | 550
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SY-CLOUDLINK | Synergis™ [NAME] with 2GB of RAM, 16[NAME],  image installed with Synergis™ access control firmware,  four RS-485 ports, PoE. | 690
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SY-MR16IN-S3 | Mercury [NAME] Monitor Module Series 3 | 525.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SY-SV4RD-E2VM | Genetec Enclosure by LSP E2 Mercury, HID, 12VDC, 75W, 4 Reader, Panduit | 1000