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

 | Category |  | Crestron UC |  |  |  |  |  | Crestron Transmitters |  |  |  | [NAME] |  | Displays |  |  |  | Mounts |  |  |  | SpeakerBar Mount |  | 2x1
 | Component | Total Cost | UC_B30_T | UC_BX30_T | UC_C100_T | UC_CX100_T | UC_M50_T | X | HD_TXC_4KZ_101_1G_W | HD_TXC_4KZ_101 | HD_TX_301_C_E | HD_TX_4KZ_401 | HD_RXC_4KZ_101 | HD_RX_4K_210_C_E | 4P_B55EJ2U | 4P_B65EJ2U | 4P_B75EJ2U | 4P_B86EJ2U | ST650 | ST660 | ST670 | SA771PU | MD5428 | X | HD-MD4X1-4KZ-E | X
Room Size | S2000 part # | Cost | 50 | 60 | 70 | 80 | 90 | 0 | 10 | 20 | 30 | 40 | 10 | 20 | 10 | 20 | 30 | 40 | 10 | 20 | 30 | 40 | 10 | 0 | 10 | 0
X-Small | XSM-SGL-VC-1WP |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  | 1 |  |  |  | 1 |  |  |  |  | 1 |  | 1
 | XSM-SGL-UTVC-1 |  |  |  |  |  | 1 |  | 1 |  |  |  | 1 |  | 1 |  |  |  | 1 |  |  |  |  | 1 |  | 1
Small | SM-SGL-VC-1WP |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  | 1 |  | 1
 | SM-SGL-VC-2WP |  |  |  |  |  |  | 1 | 2 |  |  |  | 2 |  |  | 1 |  |  | 1 |  |  |  |  | 1 | 1
 | SM-SGL-VC-1TBL |  |  |  |  |  |  | 1 |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  |  | 1 |  | 1
 | SM-SGL-VC-2TBL |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  | 1 |  |  | 1 |  |  |  |  | 1 |  | 1
 | SM-SGL-UTVC-1WP |  | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1
 | SM-SGL-UTVC-1TBL |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1
 | SM-SGL-UTVC-2WP |  | 1 |  |  |  |  |  | 2 |  |  |  | 2 |  |  | 1 |  |  | 1 |  |  |  | 1 |  | 1
 | SM-SGL-UTVC-2TBL |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1
 | SM-SGL-UXTVC-1WP |  |  | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1
 | SM-SGL-UXTVC-1TBL |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1
 | SM-SGL-UXTVC-2WP |  |  | 1 |  |  |  |  | 2 |  |  |  | 2 |  |  | 1 |  |  | 1 |  |  |  | 1 |  | 1
 | SM-SGL-UXTVC-2TBL |  |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1
 | SM-DUAL-UTVC-1WP |  | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  |  | 1 |  | 1
 | SM-DUAL-UTVC-1TBL |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  |  | 1 |  | 1
 | SM-DUAL-UTVC-2WP |  | 1 |  |  |  |  |  | 2 |  |  |  | 2 |  |  | 2 |  |  | 2 |  |  |  |  | 1 | 1
 | SM-DUAL-UTVC-2TBL |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  | 2 |  |  | 2 |  |  |  |  | 1 |  | 1
 | SM-DUAL-UXTVC-1WP |  |  | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  |  | 1 |  | 1
 | SM-DUAL-UXTVC-1TBL |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  |  | 1 |  | 1
 | SM-DUAL-UXTVC-2WP |  |  | 1 |  |  |  |  | 2 |  |  |  | 2 |  |  | 2 |  |  | 2 |  |  |  |  | 1 | 1
 | SM-DUAL-UXTVC-2TBL |  |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  | 2 |  |  | 2 |  |  |  |  | 1 |  | 1
Medium | MED-SGL-VC-1WP |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1 |  | 1
 | MED-SGL-VC-2WP |  |  |  |  |  |  | 1 | 2 |  |  |  | 2 |  |  |  | 1 |  |  | 1 |  |  |  | 1 | 1
 | MED-SGL-VC-1TBL |  |  |  |  |  |  | 1 |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  |  | 1 |  | 1
 | MED-SGL-VC-2TBL |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1 |  | 1
 | MED-SGL-UTVC-1WP |  | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | MED-SGL-UTVC-1TBL |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | MED-SGL-UTVC-2WP |  | 1 |  |  |  |  |  | 2 |  |  |  | 2 |  |  |  | 1 |  |  | 1 |  |  | 1 |  | 1
 | MED-SGL-UTVC-2TBL |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | MED-SGL-UXTVC-1WP |  |  | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | MED-SGL-UXTVC-1TBL |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | MED-SGL-UXTVC-2WP |  |  | 1 |  |  |  |  | 2 |  |  |  | 2 |  |  |  | 1 |  |  | 1 |  |  | 1 |  | 1
 | MED-SGL-UXTVC-2TBL |  |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | MED-DUAL-UTVC-1WP |  | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 2 |  |  | 2 |  |  |  | 1 |  | 1
 | MED-DUAL-UTVC-1TBL |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 2 |  |  | 2 |  |  |  | 1 |  | 1
 | MED-DUAL-UTVC-2WP |  | 1 |  |  |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  | 2 |  |  |  | 1 | 1
 | MED-DUAL-UTVC-2TBL |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  | 1 |  | 1
 | MED-DUAL-UXTVC-1WP |  |  | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 2 |  |  | 2 |  |  |  | 1 |  | 1
 | MED-DUAL-UXTVC-1TBL |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 2 |  |  | 2 |  |  |  | 1 |  | 1
 | MED-DUAL-UXTVC-2WP |  |  | 1 |  |  |  |  | 2 |  |  |  | 2 |  |  |  | 2 |  |  | 2 |  |  |  | 1 | 1
 | MED-DUAL-UXTVC-2TBL |  |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 2 |  |  | 2 |  |  |  | 1 |  | 1
Large | LRG-SGL-VC-1WP |  |  |  |  |  |  | 1 | 1 |  |  |  | 1 |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  | 1
 | LRG-SGL-VC-2WP |  |  |  |  |  |  | 1 | 2 |  |  |  | 2 |  |  |  |  | 1 |  |  | 1 |  |  | 1 | 1
 | LRG-SGL-VC-1TBL |  |  |  |  |  |  | 1 |  | 1 |  |  | 1 |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  | 1
 | LRG-SGL-VC-2TBL |  |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1 |  |  | 1 |  | 1
 | LRG-SGL-UTVC-1WP |  | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1
 | LRG-SGL-UTVC-1TBL |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1
 | LRG-SGL-UTVC-2WP |  | 1 |  |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 1 |  |  | 1 |  | 1 |  | 1
 | LRG-SGL-UTVC-2TBL |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1
 | LRG-SGL-UXTVC-1WP |  |  | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1
 | LRG-SGL-UXTVC-1TBL |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1
 | LRG-SGL-UXTVC-2WP |  |  | 1 |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 1 |  |  | 1 |  | 1 |  | 1
 | LRG-SGL-UXTVC-2TBL |  |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1
 | LRG-DUAL-UTVC-1WP |  | 1 |  |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 2 |  |  | 2 |  |  | 1 |  | 1
 | LRG-DUAL-UTVC-1TBL |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  |  | 2 |  |  | 2 |  |  | 1 |  | 1
 | LRG-DUAL-UTVC-2WP |  | 1 |  |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 2 |  |  | 2 |  |  | 1 | 1
 | LRG-DUAL-UTVC-2TBL |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 2 |  |  | 2 |  |  | 1 |  | 1
 | LRG-DUAL-UXTVC-1WP |  |  | 1 |  |  |  |  | 1 |  |  |  | 1 |  |  |  |  | 2 |  |  | 2 |  |  | 1 |  | 1
 | LRG-DUAL-UXTVC-1TBL |  |  | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  |  |  | 2 |  |  | 2 |  |  | 1 |  | 1
 | LRG-DUAL-UXTVC-2WP |  |  | 1 |  |  |  |  | 2 |  |  |  | 2 |  |  |  |  | 2 |  |  | 2 |  |  | 1 | 1
 | LRG-DUAL-UXTVC-2TBL |  |  | 1 |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 2 |  |  | 2 |  |  | 1 |  | 1