Spreadsheet: 882008d1730258615-using-a-word-in-a-formula-where-the-word-has-a-set-numerical-value-test-kits
Sheet: Part #s

Room Size | S2000 part # | Crestron UC | Displays | Quantity D | Mounts | Quantity M | Crestron Transmitters | Quantity TX | Crestron Recievers | Column1 | SpeakerBar Mount | 2x1 | Total Cost
X-Small | XSM-SGL-VC-1WP | X | 4P_B55EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | XSM-SGL-UTVC-1 | UC_M50_T | 4P_B55EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
Small | SM-SGL-VC-1WP | X | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | SM-SGL-VC-2WP | X | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | SM-SGL-VC-1TBL | X | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | SM-SGL-VC-2TBL | X | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X
 | SM-SGL-UTVC-1WP | UC_B30_T | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | SM-SGL-UTVC-1TBL | UC_B30_T | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | SM-SGL-UTVC-2WP | UC_B30_T | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | MD5428 | HD-MD4X1-4KZ-E
 | SM-SGL-UTVC-2TBL | UC_B30_T | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | MD5428 | X
 | SM-SGL-UXTVC-1WP | UC_BX30_T | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | SM-SGL-UXTVC-1TBL | UC_BX30_T | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | SM-SGL-UXTVC-2WP | UC_BX30_T | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | MD5428 | HD-MD4X1-4KZ-E
 | SM-SGL-UXTVC-2TBL | UC_BX30_T | 4P_B65EJ2U | 1 | ST650 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | MD5428 | X
 | SM-DUAL-UTVC-1WP | UC_B30_T | 4P_B65EJ2U | 2 | ST650 | 2 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | SM-DUAL-UTVC-1TBL | UC_B30_T | 4P_B65EJ2U | 2 | ST650 | 2 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | SM-DUAL-UTVC-2WP | UC_B30_T | 4P_B65EJ2U | 2 | ST650 | 2 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | SM-DUAL-UTVC-2TBL | UC_B30_T | 4P_B65EJ2U | 2 | ST650 | 2 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X
 | SM-DUAL-UXTVC-1WP | UC_BX30_T | 4P_B65EJ2U | 2 | ST650 | 2 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | SM-DUAL-UXTVC-1TBL | UC_BX30_T | 4P_B65EJ2U | 2 | ST650 | 2 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | SM-DUAL-UXTVC-2WP | UC_BX30_T | 4P_B65EJ2U | 2 | ST650 | 2 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | SM-DUAL-UXTVC-2TBL | UC_BX30_T | 4P_B65EJ2U | 2 | ST650 | 2 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X
Medium | MED-SGL-VC-1WP | X | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | MED-SGL-VC-2WP | X | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | MED-SGL-VC-1TBL | X | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | MED-SGL-VC-2TBL | X | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X
 | MED-SGL-UTVC-1WP | UC_B30_T | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | MED-SGL-UTVC-1TBL | UC_B30_T | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | MED-SGL-UTVC-2WP | UC_B30_T | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | MD5428 | HD-MD4X1-4KZ-E
 | MED-SGL-UTVC-2TBL | UC_B30_T | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | MD5428 | X
 | MED-SGL-UXTVC-1WP | UC_BX30_T | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | MED-SGL-UXTVC-1TBL | UC_BX30_T | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | MED-SGL-UXTVC-2WP | UC_BX30_T | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | MD5428 | HD-MD4X1-4KZ-E
 | MED-SGL-UXTVC-2TBL | UC_BX30_T | 4P_B75EJ2U | 1 | ST660 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | MD5428 | X
 | MED-DUAL-UTVC-1WP | UC_B30_T | 4P_B75EJ2U | 2 | ST660 | 2 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | MED-DUAL-UTVC-1TBL | UC_B30_T | 4P_B75EJ2U | 2 | ST660 | 2 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | MED-DUAL-UTVC-2WP | UC_B30_T | 4P_B75EJ2U | 2 | ST660 | 2 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | MED-DUAL-UTVC-2TBL | UC_B30_T | 4P_B75EJ2U | 2 | ST660 | 2 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X
 | MED-DUAL-UXTVC-1WP | UC_BX30_T | 4P_B75EJ2U | 2 | ST660 | 2 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | MED-DUAL-UXTVC-1TBL | UC_BX30_T | 4P_B75EJ2U | 2 | ST660 | 2 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | MED-DUAL-UXTVC-2WP | UC_BX30_T | 4P_B75EJ2U | 2 | ST660 | 2 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | MED-DUAL-UXTVC-2TBL | UC_BX30_T | 4P_B75EJ2U | 2 | ST660 | 2 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X
Large | LRG-SGL-VC-1WP | X | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | LRG-SGL-VC-2WP | X | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | LRG-SGL-VC-1TBL | X | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | LRG-SGL-VC-2TBL | X | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X
 | LRG-SGL-UTVC-1WP | UC_B30_T | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | LRG-SGL-UTVC-1TBL | UC_B30_T | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | LRG-SGL-UTVC-2WP | UC_B30_T | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | MD5428 | HD-MD4X1-4KZ-E
 | LRG-SGL-UTVC-2TBL | UC_B30_T | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | MD5428 | X
 | LRG-SGL-UXTVC-1WP | UC_BX30_T | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | LRG-SGL-UXTVC-1TBL | UC_BX30_T | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | MD5428 | X
 | LRG-SGL-UXTVC-2WP | UC_BX30_T | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | MD5428 | HD-MD4X1-4KZ-E
 | LRG-SGL-UXTVC-2TBL | UC_BX30_T | 4P_B86EJ2U | 1 | ST670 | 1 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | MD5428 | X
 | LRG-DUAL-UTVC-1WP | UC_B30_T | 4P_B86EJ2U | 2 | ST670 | 2 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | LRG-DUAL-UTVC-1TBL | UC_B30_T | 4P_B86EJ2U | 2 | ST670 | 2 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | LRG-DUAL-UTVC-2WP | UC_B30_T | 4P_B86EJ2U | 2 | ST670 | 2 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | LRG-DUAL-UTVC-2TBL | UC_B30_T | 4P_B86EJ2U | 2 | ST670 | 2 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X
 | LRG-DUAL-UXTVC-1WP | UC_BX30_T | 4P_B86EJ2U | 2 | ST670 | 2 | HD_TXC_4KZ_101_1G_W | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | LRG-DUAL-UXTVC-1TBL | UC_BX30_T | 4P_B86EJ2U | 2 | ST670 | 2 | HD_TXC_4KZ_101 | 1 | HD_RXC_4KZ_101 | 1 | X | X
 | LRG-DUAL-UXTVC-2WP | UC_BX30_T | 4P_B86EJ2U | 2 | ST670 | 2 | HD_TXC_4KZ_101_1G_W | 2 | HD_RXC_4KZ_101 | 2 | X | HD-MD4X1-4KZ-E
 | LRG-DUAL-UXTVC-2TBL | UC_BX30_T | 4P_B86EJ2U | 2 | ST670 | 2 | HD_TX_301_C_E | 1 | HD_RX_4K_210_C_E | 1 | X | X