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

Room Size | S2000 part # | UC-Engine | Displays | Quantity D | Mounts | Quantity M | [NAME] | Quantity TX | [NAME] | Quantity RX | Speaker Bar Mount | Switcher | 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