Spreadsheet: 874484d1721088605-need-help-with-sumifs-function-equal-to-another-cell-value-test
Sheet: Audio

 | Spec. Item # | Description | Mfg | Model # | Qty
 | ERK-ACC
 | NA
 | PP |  |  |  | 1
 | C |  |  |  | 30
 | CC |  |  |  | 8
 | SLV |  |  |  | 84
[NAME] | ANT |  |  |  | 6
[NAME] | ANT-RAD |  |  |  | 1
[NAME] | ALA |  |  |  | 1
[NAME] | S33 |  |  |  | 4
[NAME] | S54 |  |  |  | 203
[NAME] | S55 |  |  |  | 48
[NAME] | S51-MAIN |  |  |  | 12
[NAME] | S51-SUB |  |  |  | 15
[NAME] | S51-BAR |  |  |  | 92
[NAME] | S51-BUMP |  |  |  | 33
[NAME] | S52-MAIN |  |  |  | 14
[NAME] | S52-SUB |  |  |  | 2
[NAME] | S52-BAR |  |  |  | 14
[NAME] | S52-BUMP |  |  |  | 12
[NAME] | S53-MAIN |  |  |  | 33
[NAME] | S53-SUB |  |  |  | 61
[NAME] | S53-BAR |  |  |  | 45
[NAME] | S53-BUMP |  |  |  | 96
[NAME] | S55 |  |  |  | 24
[NAME] | S60 |  |  |  | 60
[NAME] | AMP3-4 |  |  |  | 4
[NAME] | AMP7-2 |  |  |  | 88
[NAME] | AMP8-2 |  |  |  | 33
[NAME] | AMP9-2 |  |  |  | 16
AUDIO | ERK |  |  |  | 28
AUDIO | WIR-SM |  |  |  | 1
AUDIO | WIR-ANT |  |  |  | 2
AUDIO | ANT-CMB |  |  |  | 1
AUDIO | WTX-HH1 |  |  |  | 6
AUDIO | WTX-HH2 |  |  |  | 6
AUDIO | WTX-HH3 |  |  |  | 2
AUDIO | WTX-HH4 |  |  |  | 12
AUDIO | WTX-BP1 |  |  |  | 4
AUDIO | WTX-BP2 |  |  |  | 6
AUDIO | WTX-BP3 |  |  |  | 6
[NAME] | WTX-BP4 |  |  |  | 4
[NAME] | WTX-BP7 |  |  |  | 8
AUDIO | SBRC1 |  |  |  | 4
AUDIO | SBRC2 |  |  |  | 6
AUDIO | SBRC3 |  |  |  | 10
AUDIO | WIR1b |  |  |  | 1
AUDIO | WSR |  |  |  | 4
AUDIO | AD-610 |  |  |  | 2
[NAME] | MPR |  |  |  | 2
[NAME] | AUD.CLIP |  |  |  | 2
[NAME] | DIG-INT |  |  |  | 2
[NAME] | APB |  |  |  | 10
[NAME] | IEM |  |  |  | 2
[NAME] | ANT-4 |  |  |  | 1
[NAME] | MIX-I/O-1 |  |  |  | 2
[NAME] | MIX-I/O-3 |  |  |  | 3
[NAME] | MIX-I/O3b |  |  |  | 8
[NAME] | MIX-I/O3c |  |  |  | 2
[NAME] | MIX-ENG |  |  |  | 2
[NAME] | MIX-ENG-DAN |  |  |  | 4
[NAME] | MIX-ENG-MADI |  |  |  | 1
[NAME] | MIX-CNTL-1a |  |  |  | 2
[NAME] | MIX-CNTL-1b |  |  |  | 6
[NAME] | MIX-CNTL-1c |  |  |  | 2
[NAME] | MIX-CNTL-1d |  |  |  | 4
[NAME] | MIX-CNTL-1e |  |  |  | 4
[NAME] | MON |  |  |  | 6
[NAME] | S98 |  |  |  | 1
[NAME] | S99 |  |  |  | 4
[NAME] | MIX-I/O-2 |  |  |  | 2
[NAME] | CPU-WAVES |  |  |  | 2
[NAME] | CPU |  |  |  | 5
[NAME] | CM |  |  |  | 4
[NAME] | PA |  |  |  | 10
[NAME] | SG-SWT |  |  |  | 2
[NAME] | DIG-ENHS |  |  |  | 4
[NAME] | DSP-I/Oa |  |  |  | 8
[NAME] | DSP-I/Ob |  |  |  | 1
[NAME] | MIX-ANA |  |  |  | 1
[NAME] | TX-70A |  |  |  | 2
[NAME] | DSPa |  |  |  | 14
[NAME] | DSPb |  |  |  | 8
[NAME] | AVB-CONV |  |  |  | 2
[NAME] | LINE AMP |  |  |  | 2
[NAME] | GPIO |  |  |  | 2
[NAME] | ADA |  |  |  | 4
[NAME] | MICPRE |  |  |  | 1
[NAME] | -30 PAD |  |  |  | 4
[NAME] | MONO SUM |  |  |  | 5
[NAME] | TX-A2D |  |  |  | 2
[NAME] | TX-ISO |  |  |  | 6
[NAME] | TX-MIC |  |  |  | 4
[NAME] | POL |  |  |  | 2
[NAME] | DIST-AMP |  |  |  | 5
[NAME] | DIST-AMP1 |  |  |  | 10
[NAME] | DIST-AMP2 |  |  |  | 35
[NAME] | DIST-AMP3 |  |  |  | 14
[NAME] | MSG-RPTRc |  |  |  | 2
[NAME] | AM/FM |  |  |  | 1
[NAME] | IPTV-TUNER |  |  |  | 1
[NAME] | BGM-PLYR |  |  |  | 4
[NAME] | ST-ISO |  |  |  | 5
[NAME] | HA |  |  |  | 1
[NAME] | MEDIA-CNV |  |  |  | 2
[NAME] | NET-SWT |  |  |  | 50
[NAME] | AMP1-4 |  |  |  | 31
[NAME] | AMP2-4 |  |  |  | 49
[NAME] | AMP3-4 |  |  |  | 46
[NAME] | AMP4-4 |  |  |  | 3
 | TP1 |  |  |  | 1
 | DB4 |  |  |  | 2
 | [NAME] |  |  |  | 2
 | ANC |  |  |  | 1
 | DJ |  |  |  | 1
AUDIO | ERK |  |  |  | 2
AUDIO | ERK |  |  |  | 41
AUDIO | ERK |  |  |  | 2
AUDIO | ERK |  |  |  | 28
ELEV | CAB DISP |  |  |  | 20
ELEV | S30 |  |  |  | 25
 | DB1 |  |  |  | 15
 | DB4 |  |  |  | 20
 | DB6 |  |  |  | 5
 | S28 |  |  |  | 114
RR | DB1 |  |  |  | 3
RR | DB2 |  |  |  | 0
RR | DB3 |  |  |  | 0
RR | DB4 |  |  |  | 6
RR | DB6 |  |  |  | 2
RR | S01 |  |  |  | 648
RR | S02 |  |  |  | 4
 | S03 |  |  |  | 12
 | S04 |  |  |  | 251
 | S28 |  |  |  | 12
 | DB2 |  |  |  | 3
 | DB4 |  |  |  | 2
 | DB6 |  |  |  | 1
 | DB4 |  |  |  | 3
 | DB4 |  |  |  | 1
 | DB? |  |  |  | 5
 | S28 |  |  |  | 16
 | S31 |  |  |  | 13
 | S33 |  |  |  | 4
 | S31 |  |  |  | 20
 | TP3 |  |  |  | 3
 | BT1 |  |  |  | 2
 | DB1 |  |  |  | 0
 | DB2 |  |  |  | 5
 | AV3 |  |  |  | 4
 | AV3-ENC |  |  |  | 4
 | DEC1 |  |  |  | 2
 | ML2 |  |  |  | 4
 | DSP-I/Oa |  |  |  | 4
 | DSP-I/Ob |  |  |  | 4
 | S28 |  |  |  | 52
 | VPL |  |  |  | 2
 | WIR1a |  |  |  | 2
 | WIR1b
 | WIR1c
 | WIR1d
 | [NAME]
 | WIR1e1
 | WIR1e2
 | WIR1f
 | ALA
 | ALT
 | DAP
 | TP1 |  |  |  | 1
 | PG |  |  |  | 1
 | S16 |  |  |  | 2
 | S28 |  |  |  | 2
 | DB1 |  |  |  | 6
 | DB3 |  |  |  | 21
 | DB4 |  |  |  | 8
 | DB5 |  |  |  | 1
 | TP1 |  |  |  | 1
 | TP3 |  |  |  | 1
 | DB2 |  |  |  | 1
 | UC-ENGINE1 |  |  |  | 1
 | ENC1 |  |  |  | 4
 | DEC1 |  |  |  | 1
 | AV-SW |  |  |  | 1
 | FB |  |  |  | 2
 | FB-CVR |  |  |  | 2
 | JBR |  |  |  | 1
 | CRCK |  |  |  | 1
 | CP |  |  |  | 1
 | CCM |  |  |  | 2
 | CAM |  |  |  | 1
 | S28 |  |  |  | 6
 | AMP6-4 |  |  |  | 1
 | DAP |  |  |  | 1
 | TP1 |  |  |  | 1
 | TP3 |  |  |  | 1
 | DB2 |  |  |  | 1
 | UC-ENGINE1 |  |  |  | 1
 | ENC1 |  |  |  | 4
 | DEC1 |  |  |  | 1
 | AV-SW |  |  |  | 1
 | FB |  |  |  | 2
 | FB-CVR |  |  |  | 2
 | JBR |  |  |  | 1
 | CRCK |  |  |  | 1
 | CP |  |  |  | 1
 | CCM |  |  |  | 1
 | CAM |  |  |  | 1
 | S28 |  |  |  | 6
 | AMP6-4 |  |  |  | 1
 | DAP |  |  |  | 1
 | TP1 |  |  |  | 1
 | TP3 |  |  |  | 1
 | DB2 |  |  |  | 1
 | UC-ENGINE1 |  |  |  | 1
 | ENC1 |  |  |  | 4
 | DEC1 |  |  |  | 1
 | AV-SW |  |  |  | 1
 | FB |  |  |  | 2
 | FB-CVR |  |  |  | 2
 | JBR |  |  |  | 1
 | CRCK |  |  |  | 1
 | CP |  |  |  | 1
 | CCM |  |  |  | 2
 | CAM |  |  |  | 1
 | S28 |  |  |  | 8
 | AMP6-4 |  |  |  | 1
 | DAP |  |  |  | 1
 | DB3 |  |  |  | 8
 | DB4 |  |  |  | 2
 | DB3 |  |  |  | 2
 | TP1 |  |  |  | 1
 | DB6 |  |  |  | 4
 | ENC3 |  |  |  | 1
 | FB |  |  |  | 1
 | FB-CVR |  |  |  | 1
 | TP1 |  |  |  | 1
 | DB6 |  |  |  | 13
 | S28 |  |  |  | 14
 | DB1 |  |  |  | 1
 | DB1 |  |  |  | 2
 | DB3 |  |  |  | 2
 | DB4 |  |  |  | 1
 | DB3 |  |  |  | 2
 | DB4 |  |  |  | 2
 | DB4 |  |  |  | 2
 | DB2 |  |  |  | 6
 | ML3 |  |  |  | 3
 | AV3 |  |  |  | 3
 | AV3-ENC |  |  |  | 3
 | ENC1 |  |  |  | 1
 | ENC3 |  |  |  | 3
 | BT1 |  |  |  | 3
 | TP3 |  |  |  | 3
 | DEC1 |  |  |  | 1
 | DSP-I/Oa |  |  |  | 5
 | DSP-I/Ob |  |  |  | 3
 | WIR1a |  |  |  | 1
 | WIR1b
 | WIR1c
 | WIR1d
 | [NAME]
 | WIR1e1
 | WIR1e2
 | WIR1f
 | S28 |  |  |  | 48
 | CP |  |  |  | 1
 | WPS |  |  |  | 1
 | ALA
 | ALT
 | DAP
 | TP3 |  |  |  | 1
 | DB6 |  |  |  | 2
 | S28 |  |  |  | 6
 | TP1 |  |  |  | 1
 | UC-ENGINE1 |  |  |  | 1
 | ENC1 |  |  |  | 4
 | DEC1 |  |  |  | 1
 | AV-SW |  |  |  | 1
 | FB |  |  |  | 2
 | FB-CVR |  |  |  | 2
 | JBR |  |  |  | 1
 | CRCK |  |  |  | 1
 | CP |  |  |  | 1
 | CCM |  |  |  | 1
 | CAM |  |  |  | 1
 | S28 |  |  |  | 6
 | AMP6-4 |  |  |  | 1
 | DAP |  |  |  | 1
 | TP3 |  |  |  | 1
 | DB2 |  |  |  | 1
 | CR-RCK |  |  |  | 1
 | ENC3 |  |  |  | 2
 | FB |  |  |  | 2
 | FB-CVR |  |  |  | 2
 | JBR |  |  |  | 1
 | S28 |  |  |  | 4
 | CCM |  |  |  | 1
 | DB6 |  |  |  | 0
 | DB1 |  |  |  | 3
 | AV3 |  |  |  | 1
 | AV3-ENC |  |  |  | 1
 | ENC1
 | DB2 |  |  |  | 5
 | DEC1 |  |  |  | 1
 | ML4 |  |  |  | 1
 | TP3 |  |  |  | 1
 | POV |  |  |  | 1
 | MF |  |  |  | 1
 | ALA |  |  |  | 1
 | PF |  |  |  | 1
 | S08 |  |  |  | 15
 | PM |  |  |  | 2
 | DSP-I/Oa |  |  |  | 2
 | DSP-I/Ob |  |  |  | 2
 | WIR1a |  |  |  | 1
 | WIR1b
 | WIR1c
 | WIR1d
 | [NAME]
 | WIR1e1
 | WIR1e2
 | WIR1f
 | ADA |  |  |  | 3
 | ALA |  |  |  | 1
 | ALT |  |  |  | 1
 | DAP |  |  |  | 1
 | AV3 |  |  |  | 1
 | AV3-ENC |  |  |  | 1
 | ENC1
 | DEC1 |  |  |  | 1
 | DB4 |  |  |  | 4
 | ML3 |  |  |  | 1
 | TP3 |  |  |  | 1
 | POV |  |  |  | 1
 | MF |  |  |  | 1
 | ALA |  |  |  | 1
 | PF |  |  |  | 1
 | S08 |  |  |  | 12
 | PM |  |  |  | 1
 | DSP-I/Oa |  |  |  | 2
 | DSP-I/Ob |  |  |  | 2
 | WIR1a |  |  |  | 1
 | WIR1b
 | WIR1c
 | WIR1d
 | [NAME]
 | WIR1e1
 | WIR1e2
 | WIR1f
 | ADA |  |  |  | 3
 | ALA |  |  |  | 1
 | ALT |  |  |  | 1
 | DAP |  |  |  | 1
 | DB4 |  |  |  | 9
 | DB2 |  |  |  | 1
 | TP1 |  |  |  | 1
 | [NAME] |  |  |  | 2
 | DMRX |  |  |  | 1
 | CAM |  |  |  | 1
 | CCM |  |  |  | 1
 | AV-SW |  |  |  | 1
 | UC-ENGINE1 |  |  |  | 1
 | UC-SB1 |  |  |  | 1
 | ENC1 |  |  |  | 3
 | DEC1 |  |  |  | 1
 | FB |  |  |  | 1
 | FB-CVR |  |  |  | 1
 | S28 |  |  |  | 4
 | AMP6-4 |  |  |  | 1
 | DAP |  |  |  | 1
 | DB6 |  |  |  | 6
 | DB2 |  |  |  | 1
 | DEC3 |  |  |  | 2
 | AV3 |  |  |  | 1
 | AV3-ENC |  |  |  | 1
 | ML3 |  |  |  | 1
 | DSP-I/Oa |  |  |  | 2
 | DSP-I/OB |  |  |  | 2
 | TP3 |  |  |  | 1
 | ALA |  |  |  | 1
 | S28 |  |  |  | 35
 | WIR1a |  |  |  | 1
 | WIR1b
 | WIR1c
 | WIR1d
 | [NAME]
 | WIR1e1
 | WIR1e2
 | WIR1f
 | ALA
 | ALT
 | DAP
 | DB4 |  |  |  | 4
 | TP2 |  |  |  | 1
 | S13 |  |  |  | 16
 | AV3 |  |  |  | 1
 | AV3-ENC |  |  |  | 1
 | ENC1 |  |  |  | 2
 | ENC3 |  |  |  | 1
 | ML2 |  |  |  | 1
 | DSP-I/Oa |  |  |  | 1
 | DSP-I/Ob |  |  |  | 1
 | BT1 |  |  |  | 1
 | TP3 |  |  |  | 1
 | TP1 |  |  |  | 1
 | CP |  |  |  | 1
 | WPS |  |  |  | 1
 | DEC1 |  |  |  | 1
 | S36 |  |  |  | 39
 | S14 |  |  |  | 14
 | ZA |  |  |  | 8
 | DAP
 | DB4 |  |  |  | 1
 | DB4 |  |  |  | 1
 | DB4 |  |  |  | 8
 | ZA |  |  |  | 6
 | DB4 |  |  |  | 2
 | DB4 |  |  |  | 2
 | DB4 |  |  |  | 10
 | ZA |  |  |  | 2
 | DB4 |  |  |  | 2
 | DB6 |  |  |  | 5
 | ML3 |  |  |  | 1
 | AV3 |  |  |  | 1
 | AV3-ENC |  |  |  | 1
 | TP2 |  |  |  | 1
 | ALA |  |  |  | 1
 | DB2 |  |  |  | 1
 | ML2 |  |  |  | 1
 | AV2 |  |  |  | 1
 | ENC1 |  |  |  | 2
 | ENC3 |  |  |  | 1
 | DEC1 |  |  |  | 1
 | DSP-I/Oa |  |  |  | 1
 | DSP-I/Ob |  |  |  | 1
 | CP |  |  |  | 1
 | WPS |  |  |  | 2
 | TP3 |  |  |  | 1
 | S13 |  |  |  | 6
 | DAP |  |  |  | 1
 | DB2 |  |  |  | 1
 | ML2 |  |  |  | 1
 | AV2 |  |  |  | 1
 | ENC1 |  |  |  | 2
 | ENC3 |  |  |  | 2
 | DEC1 |  |  |  | 1
 | DSP-I/Oa |  |  |  | 1
 | DSP-I/Ob |  |  |  | 1
 | CP |  |  |  | 1
 | WPS |  |  |  | 2
 | TP3 |  |  |  | 1
 | S13 |  |  |  | 6
 | DAP |  |  |  | 1
 | DB1 |  |  |  | 2
 | DB1 |  |  |  | 1
 | TP1 |  |  |  | 1
 | DB1 |  |  |  | 1
 | S28 |  |  |  | 4
 | DB4 |  |  |  | 1
 | S13 |  |  |  | 3
 | TP10 |  |  |  | 1
 | TP1 |  |  |  | 1
 | S13 |  |  |  | 9
 | TP1 |  |  |  | 1
 | S13 |  |  |  | 3
 | TP1 |  |  |  | 1
 | DB2 |  |  |  | 1
 | DB4 |  |  |  | 1
 | S13 |  |  |  | 5
 | DB1 |  |  |  | 1
CLUB | DB2 |  |  |  | 12
CLUB | TP3 |  |  |  | 2
CLUB | BT1 |  |  |  | 1
 | AV4 |  |  |  | 2
 | [NAME] |  |  |  | 2
 | DMRX |  |  |  | 2
 | AV4-ENC |  |  |  | 2
 | AV4-DEC |  |  |  | 2
CLUB | WPS |  |  |  | 1
CLUB | CP |  |  |  | 1
CLUB | ENC1 |  |  |  | 1
CLUB | ML2 |  |  |  | 1
CLUB | ML3 |  |  |  | 2
CLUB | ALA |  |  |  | 1
CLUB | S21 |  |  |  | 3
CLUB | S22 |  |  |  | 1
CLUB | S36 |  |  |  | 12
CLUB | S39 |  |  |  | 38
CLUB | S40 |  |  |  | 7
CLUB | WIR1a |  |  |  | 1
CLUB | WIR1b
CLUB | WIR1c
CLUB | WIR1d
CLUB | [NAME]
CLUB | WIR1e1
CLUB | WIR1e2
CLUB | WIR1f
CLUB | DEC3 |  |  |  | 1
CLUB | ALT |  |  |  | 1
CLUB | DSP-I/Oa |  |  |  | 3
CLUB | DSP-I/OB |  |  |  | 3
CLUB | DB2 |  |  |  | 13
CLUB | TP3 |  |  |  | 2
CLUB | BT1 |  |  |  | 1
 | AV4 |  |  |  | 2
 | [NAME] |  |  |  | 2
 | DMRX |  |  |  | 2
 | AV4-ENC |  |  |  | 2
 | AV4-DEC |  |  |  | 2
CLUB | WPS |  |  |  | 1
CLUB | CP |  |  |  | 1
CLUB | ENC1 |  |  |  | 1
CLUB | ML2 |  |  |  | 1
CLUB | ML3 |  |  |  | 1
CLUB | DB2 |  |  |  | 13
CLUB | ALA |  |  |  | 1
CLUB | S21 |  |  |  | 10
CLUB | S22 |  |  |  | 2
CLUB | S36 |  |  |  | 12
CLUB | S39 |  |  |  | 22
CLUB | S40 |  |  |  | 7
CLUB | WIR1a |  |  |  | 1
CLUB | WIR1b
CLUB | WIR1c
CLUB | WIR1d
CLUB | [NAME]
CLUB | WIR1e1
CLUB | WIR1e2
CLUB | WIR1f
CLUB | DEC3 |  |  |  | 1
CLUB | ALT |  |  |  | 1
CLUB | DSP-I/Oa |  |  |  | 3
CLUB | DSP-I/OB |  |  |  | 3
CONCOURSE | DB1 |  |  |  | 8
CONCOURSE | DB2 |  |  |  | 4
CONCOURSE | DB4 |  |  |  | 15
CONCOURSE | [NAME] |  |  |  | 94
CONCOURSE | S07 |  |  |  | 44
CONCOURSE | BPIPE |  |  |  | 8
CONCOURSE | DB4 |  |  |  | 2
CONCOURSE | DB4 |  |  |  | 1
CONCOURSE | DB4 |  |  |  | 2
CONCOURSE | DB4 |  |  |  | 1
CONCOURSE | DB4 |  |  |  | 2
CONCOURSE | DB4 |  |  |  | 2
CONCOURSE | DB4 |  |  |  | 1
RETAIL | DB4 |  |  |  | 10
 | AV4 |  |  |  | 2
 | [NAME] |  |  |  | 2
 | DMRX |  |  |  | 2
 | AV4-ENC |  |  |  | 2
 | AV4-DEC |  |  |  | 2
CLUB | WPS |  |  |  | 1
CLUB | CP |  |  |  | 1
CLUB | ENC1 |  |  |  | 1
CLUB | ML2 |  |  |  | 1
CLUB | DB2 |  |  |  | 1
CLUB | DB4 |  |  |  | 4
CLUB | TV1C |  |  |  | 4
CLUB | BT1 |  |  |  | 1
CLUB | TP3 |  |  |  | 1
CLUB | S18 |  |  |  | 15
CLUB | S19 |  |  |  | 6
CLUB | WIR1a |  |  |  | 1
CLUB | WIR1b
CLUB | WIR1c
CLUB | WIR1d
CLUB | [NAME]
CLUB | WIR1e1
CLUB | WIR1e2
CLUB | WIR1f
CLUB | DEC3 |  |  |  | 1
CLUB | ALT |  |  |  | 1
CLUB | DSP-I/Oa |  |  |  | 3
CLUB | DSP-I/OB |  |  |  | 3
CORR | S21 |  |  |  | 26
CLUB | DB1 |  |  |  | 2
CLUB | DB2 |  |  |  | 23
CLUB | DB3 |  |  |  | 2
CLUB | DB4 |  |  |  | 0
CLUB | TVL |  |  |  | 9
CLUB | [NAME] |  |  |  | 12
CLUB | TP3 |  |  |  | 1
CLUB | AV2 |  |  |  | 1
CLUB | AV3 |  |  |  | 1
CLUB | AV3-ENC |  |  |  | 1
CLUB | AV4 |  |  |  | 2
CLUB | [NAME] |  |  |  | 4
CLUB | DMRX |  |  |  | 4
CLUB | AV4-ENC |  |  |  | 4
CLUB | AV4-DEC |  |  |  | 4
CLUB | WPS |  |  |  | 1
CLUB | CP |  |  |  | 1
CLUB | ENC2 |  |  |  | 3
CLUB | ML2 |  |  |  | 3
CLUB | ML3 |  |  |  | 1
CLUB | ENC3 |  |  |  | 3
 | FB |  |  |  | 1
 | FB-CVR |  |  |  | 1
CLUB | ALA |  |  |  | 1
CLUB | ALT |  |  |  | 1
CLUB | S18 |  |  |  | 32
CLUB | S19 |  |  |  | 5
CLUB | S21 |  |  |  | 106
CLUB | S22 |  |  |  | 39
CLUB | WIR1a |  |  |  | 1
CLUB | WIR1b
CLUB | WIR1c
CLUB | WIR1d
CLUB | [NAME]
CLUB | WIR1e1
CLUB | WIR1e2
CLUB | WIR1f
CLUB | DEC3 |  |  |  | 1
CLUB | ALT |  |  |  | 1
CLUB | DSP-I/Oa |  |  |  | 6
CLUB | DSP-I/OB |  |  |  | 3
CLUB | DB2 |  |  |  | 42
CLUB | DB3
CLUB | DB4 |  |  |  | 6
CLUB | TVL |  |  |  | 9
CLUB | [NAME] |  |  |  | 24
CLUB | TP3 |  |  |  | 3
CLUB | AV2 |  |  |  | 2
CLUB | AV3 |  |  |  | 1
CLUB | AV3-ENC |  |  |  | 1
CLUB | AV4 |  |  |  | 4
CLUB | [NAME] |  |  |  | 4
CLUB | DMRX |  |  |  | 4
CLUB | AV4-ENC |  |  |  | 4
CLUB | AV4-DEC |  |  |  | 4
CLUB | ML3 |  |  |  | 1
CLUB | BT1 |  |  |  | 1
CLUB | AV4 |  |  |  | 1
CLUB | [NAME] |  |  |  | 1
CLUB | DMRX |  |  |  | 1
CLUB | AV4-ENC |  |  |  | 1
CLUB | AV4-DEC |  |  |  | 1
CLUB | WPS |  |  |  | 1
CLUB | CP |  |  |  | 1
CLUB | ENC2 |  |  |  | 3
CLUB | ML2 |  |  |  | 3
CLUB | ML3 |  |  |  | 1
CLUB | ENC3 |  |  |  | 1
 | FB |  |  |  | 1
 | FB-CVR |  |  |  | 1
CLUB | ALA |  |  |  | 1
CLUB | ALT |  |  |  | 1
 | WIR1a |  |  |  | 2
 | WIR1b
 | WIR1c
 | WIR1d
 | [NAME]
 | WIR1e1
 | WIR1e2
 | WIR1f
CLUB | S18 |  |  |  | 32
CLUB | S19 |  |  |  | 5
CLUB | S21 |  |  |  | 95
CLUB | S22 |  |  |  | 38
CLUB | WIR1a |  |  |  | 1
CLUB | WIR1b
CLUB | WIR1c
CLUB | WIR1d
CLUB | [NAME]
CLUB | WIR1e1
CLUB | WIR1e2
CLUB | WIR1f
CLUB | DEC3 |  |  |  | 1
CLUB | ALT |  |  |  | 1
CLUB | DSP-I/Oa |  |  |  | 3
CLUB | DSP-I/Ob |  |  |  | 3
FOH | S31 |  |  |  | 9
FOH | DB2 |  |  |  | 5
FOH | S28 |  |  |  | 40
FOH | S33 |  |  |  | 4
RETAIL | DB1 |  |  |  | 2
RETAIL | S18 |  |  |  | 4
RETAIL | S07 |  |  |  | 3
RETAIL | DB1 |  |  |  | 2
RETAIL | S18 |  |  |  | 4
RETAIL | DB1 |  |  |  | 2
RETAIL | S18 |  |  |  | 4
RETAIL | DB1 |  |  |  | 2
RETAIL | S18 |  |  |  | 4
RETAIL | DB4 |  |  |  | 2
BOH | BT1 |  |  |  | 1
BOH | TP3 |  |  |  | 1
BOH | S28 |  |  |  | 2
BOH | DB1 |  |  |  | 4
BOH | DB3 |  |  |  | 2
 | S25 |  |  |  | 5
 | S36 |  |  |  | 7
 | S60 |  |  | 6 | 7
 | NA
 | NA | 20.B1.08
 | TP3 |  |  |  | 1
 | [NAME] |  |  |  | 4
 | NA
 | NA | BAR - 10.D3.02
 | DB4 |  |  |  | 2
 | NA
 | NA | BAR - 20.A3.00
 | TP3 |  |  |  | 1
 | [NAME] |  |  |  | 4
 | NA
 | NA | BAR - 20.C2.00
 | DB4 |  |  |  | 2
 | NA
 | NA | BAR - 20.D1.00
 | DB4 |  |  |  | 2
 | NA
 | NA | MARKET - 20.C2.12
 | DB4 |  |  |  | 2
 | NA
 | NA | MARKET - 20.D1.12
 | [NAME] |  |  |  | 2
 | NA
 | NA | BAR SPEAKERS
 | S04 |  |  |  | 6
 | NA
 | NA | CLUB LEVEL CONCOURSE
 | [NAME] |  |  |  | 24
 | DB1 |  |  |  | 0
 | S07 |  |  |  | 10
 | TP3 |  |  |  | 1
 | BT1 |  |  |  | 1
 | NA
 | NA | UPPER LEVEL CONCOURSE
 | [NAME] |  |  |  | 110
 | DB1 |  |  |  | 18
 | DB4 |  |  |  | 2
 | S07 |  |  |  | 16
 | S35 |  |  |  | 12
 | NA
 | NA | TERRACE - 10.C3.11
 | S18 |  |  |  | 10
 | NA
 | NA | TERRACE - 10.D1.11
 | S18 |  |  |  | 10
 | NA
 | NA | TERRACE - 20.T1
 | [NAME] |  |  |  | 8
 | DB1 |  |  |  | 8
 | ML4 |  |  |  | 2
 | S20 |  |  |  | 30
 | NA
 | NA | TERRACE - 30.T2
 | [NAME] |  |  |  | 6
 | ML4 |  |  |  | 3
 | NA
 | NA | NURSING - 20.A0.06
 | DB4 |  |  |  | 1
 | NA
 | NA | BREAK ROOM - 20.B0.08
 | DB4 |  |  |  | 1
 | NA
 | NA | SENSORY ROOM - 20.B0.07
 | DB4 |  |  |  | 1
 | NA
 | NA | FIRST AID - 20.B0.05
 | DB4 |  |  |  | 1
 | NA
CONCOURSE | NA | FIRST AID - 10.A1.06
CONCOURSE | DB4 |  |  |  | 1
 | NA
 | NA | FIRST AID - 20.C1.06
 | DB4 |  |  |  | 1
 | NA
 | NA | FIRST AID - 30.A1.06
 | DB4 |  |  |  | 1
 | NA
CONCOURSE | NA | MARKET??? - 30.xx.xx
CONCOURSE | DB4 |  |  |  | 4
CONCOURSE | S07 |  |  |  | 2
 | NA
 | NA | MARKET - 05.B0.10
 | DB4 |  |  |  | 2
 | NA
 | NA | SENSORY ROOM - 30.B1.06
 | DB3 |  |  |  | 1
 | NA
 | NA | NURSING - 30.B1.07
 | DB3 |  |  |  | 1
 | NA
 | NA | STAFF BREAK ROOM - 30.C2.00
 | DB4 |  |  |  | 1
 | NA
 | NA | BAR - 30.C0.09
 | [NAME] |  |  |  | 4
 | S07 |  |  |  | 8
 | NA
 | NA | BAR - 30.D0-10
 | [NAME] |  |  |  | 6
 | S07 |  |  |  | 4
 | NA
 | NA | SENSORY/??? ROOM - 30.D1.07
 | DB3 |  |  |  | 2
 | DB4 |  |  |  | 1
 | NA
 | NA | EDGEFIELD [NAME] (ADAM'S CLUB)
CLUB | TP3 |  |  |  | 3
CLUB | DB2 |  |  |  | 8
CLUB | M2 |  |  |  | 1
CLUB | ML2 |  |  |  | 3
CLUB | ML3 |  |  |  | 1
 | ENC3 |  |  |  | 1
 | FB |  |  |  | 1
 | FB-CVR |  |  |  | 1
 | AV4 |  |  |  | 4
 | [NAME] |  |  |  | 4
 | DMRX |  |  |  | 4
 | AV4-ENC |  |  |  | 4
 | AV4-DEC |  |  |  | 4
CLUB | WPS |  |  |  | 2
CLUB | CP |  |  |  | 2
CLUB | ENC1 |  |  |  | 2
CLUB | [NAME] |  |  |  | 4
CLUB | S18 |  |  |  | 104
CLUB | S19 |  |  |  | 28
CLUB | WIR1a |  |  |  | 1
CLUB | WIR1b
CLUB | WIR1c
CLUB | WIR1d
CLUB | [NAME]
CLUB | WIR1e1
CLUB | WIR1e2
CLUB | WIR1f
CLUB | DEC3 |  |  |  | 1
CLUB | ALT |  |  |  | 1
CLUB | DSP-I/Oa |  |  |  | 3
CLUB | DSP-I/OB |  |  |  | 3
 | NA
 | NA | 1350 CLUB / EDGEFIELD CLUB SOUTH
CLUB | TP3 |  |  |  | 5
CLUB | DB1 |  |  |  | 10
CLUB | DB2 |  |  |  | 8
CLUB | ML2 |  |  |  | 4
CLUB | ML3 |  |  |  | 1
 | ENC3 |  |  |  | 1
 | FB |  |  |  | 1
 | FB-CVR |  |  |  | 1
 | AV4 |  |  |  | 6
 | [NAME] |  |  |  | 6
 | DMRX |  |  |  | 6
 | AV4-ENC |  |  |  | 6
 | AV4-DEC |  |  |  | 6
CLUB | WPS |  |  |  | 2
CLUB | CP |  |  |  | 2
CLUB | ENC1 |  |  |  | 2
CLUB | [NAME] |  |  |  | 8
CLUB | S18 |  |  |  | 107
CLUB | S19 |  |  |  | 28
CLUB | S36 |  |  |  | 20
CLUB | WIR1a |  |  |  | 1
CLUB | WIR1b
CLUB | WIR1c
CLUB | WIR1d
CLUB | [NAME]
CLUB | WIR1e1
CLUB | WIR1e2
CLUB | WIR1f
CLUB | DEC3 |  |  |  | 1
CLUB | ALT |  |  |  | 1
CLUB | DSP-I/Oa |  |  |  | 3
CLUB | DSP-I/OB |  |  |  | 3
 | NA
 | NA | TERRACE - 15.AT.01
 | [NAME] |  |  |  | 16
 | DB1 |  |  |  | 12
 | ML4 |  |  |  | 1
 | S24 |  |  |  | 8
 | NA
 | NA | TERRACE - 15.BT.01
 | [NAME] |  |  |  | 16
 | DB1 |  |  |  | 12
 | ML4 |  |  |  | 1
 | S24 |  |  |  | 8
 | NA
 | NA | SUITE CONCOURSE - CLUB LEVEL
 | TP3 |  |  |  | 1
 | DB1 |  |  |  | 10
 | TP1 |  |  |  | 1
 | [NAME] |  |  |  | 33
 | S07 |  |  |  | 5
 | NA
 | NA | LOGE SEATING
 | TVL |  |  |  | 176
 | DB1 |  |  |  | 2
 | NA
 | NA | LOGE - 50 YD. LINE
 | ERK |  |  |  | 2
 | ANC |  |  |  | 2
 | NA
 | NA | Cheer Lockers / Lounge / RR - 00.D3.37
 | TP1 |  |  |  | 4
 | DB1 |  |  |  | 5
 | BT1 |  |  |  | 4
 | NA
 | NA | HOME FAMILY - 00.D4.00
 | DB4 |  |  |  | 4
 | NA
 | NA | VISITING FAMILY - 00.C1.10
 | DB1 |  |  |  | 4
 | NA
 | NA | PRESS DINING - 40.A1.00
 | DB1 |  |  |  | 14
 | S09 |  |  |  | 38
 | TP2 |  |  |  | 1
 | S09 |  |  |  | 45
 | S11 |  |  |  | 37
 | S12 |  |  |  | 20
 | S19 |  |  |  | 15
 | TV1C |  |  |  | 4
 | DB2 |  |  |  | 5
 | DB3 |  |  |  | 2
 | DB4 |  |  |  | 64
 | [NAME] |  |  |  | 64
 | DV |  |  |  | 26
 | NT |  |  |  | 29
 | HD |  |  |  | 8
 | MF |  |  |  | 19
 | RA |  |  |  | 12
 | RE |  |  |  | 5
 | CO |  |  |  | 2
 | BC |  |  |  | 17
 | ENC3 |  |  |  | 2
 | FB |  |  |  | 2
 | FB-CVR |  |  |  | 2
 | PA |  |  |  | 5
 | NA
 | NA
 | NA | CONTROL LEVEL ENTRANCE
 | S34 |  |  |  | 27
 | NA
 | NA | CONTINGENT GEAR - CONSUMABLES
 | ENC3
 | ENC3
 | CJ3
 | DEC1
 | DEC1
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 | NA
 |  | NEED TO ADD TO FORMULAS SUB LENGTH AT TOP OF COLUMN PAST THIS POINT