Spreadsheet: 93448d1293028215-sumproduct-problem-attached-a-stripped-down-sumproduct_stripped_down_ws
Sheet: Sheet1

 |  | code4 |  |  |  |  |  |  |  | code2 | unavailable |  |  | Available | code3 |  |  |  |  | code5 |  |  |  | Effective Availability
 |  | bvb365 |  |  |  |  |  |  |  |  | 1 |  |  | 0 | BVB365 |  |  |  |  | BVB |  |  |  | 0 |  |  |  |  |  |  |  |  | 4833.370000000009 | BVA | 0
 |  | [NAME] |  |  |  |  |  |  |  | od | 0 |  |  | 1 | [NAME] |  |  |  |  | BVB |  |  |  | 1 |  |  |  |  |  |  |  |  | 748.88 | BVB | 3
 |  | bvb331 |  |  |  |  |  |  |  | su | 1 |  |  | 1 | BVB331 |  |  |  |  | BVB |  |  |  | 0 |  |  |  |  |  |  |  |  | 6243.860000000013 | BVC | 0
 |  | tVs34C |  |  |  |  |  |  |  |  | 0 |  |  | 0 | BVB34C |  |  |  |  | BVB |  |  |  | 1 |  |  |  |  |  |  |  |  | 353 | BVS | 3
 |  | BVB351 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | BVB351 |  |  |  |  | BVB |  |  |  | 1
 |  | BVB356 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | BVB356 |  |  |  |  | BVB |  |  |  | 1
 |  | BVB342 |  |  |  |  |  |  |  | LL | 1 |  |  | 0 | BVB342 |  |  |  |  | BVB |  |  |  | 0 |  |  |  |  |  |  |  |  | 12179.11 | 12179.11
 |  | BVB362 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVB362 |  |  |  |  | BVB |  |  |  | 1
 |  | BVB371 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVB371 |  |  |  |  | BVB |  |  |  | 1
 |  | [NAME] |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | [NAME] |  |  |  |  | BVB |  |  |  | 1
 |  | BVB356 |  |  |  |  |  |  |  | LL | 1 |  |  | 0 | BVB356 |  |  |  |  | BVB |  |  |  | 0
 |  | BVB320 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | BVB320 |  |  |  |  | BVB |  |  |  | 0
 |  | BVB331 |  |  |  |  |  |  |  | OF | 1 |  |  | 0 | BVB331 |  |  |  |  | BVB |  |  |  | 0
 |  | BVB347 |  |  |  |  |  |  |  | LL | 1 |  |  | 0 | BVB347 |  |  |  |  | BVB |  |  |  | 0
 |  | BVB325 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVB325 |  |  |  |  | BVB |  |  |  | 1
 |  | BVB326 |  |  |  |  |  |  |  | MX | 0.25 |  |  | 0.75 | BVB326 |  |  |  |  | BVB |  |  |  | 0.75
 |  | BVB374 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVB374 |  |  |  |  | BVB |  |  |  | 1
 |  | BVB376 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVB376 |  |  |  |  | BVB |  |  |  | 1
 |  | BVB372 |  |  |  |  |  |  |  | SK | 1 |  |  | 0 | BVB372 |  |  |  |  | BVB |  |  |  | 0
 |  | BVB325 |  |  |  |  |  |  |  | SK | 1 |  |  | 0 | BVB325 |  |  |  |  | BVB |  |  |  | 0
 |  | BVA752 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA752 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA462 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA462 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA653 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA653 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA433 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA433 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA577 |  |  |  |  |  |  |  | SU | 1 |  |  | 0 | BVA577 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA219 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA219 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA393 |  |  |  |  |  |  |  | OD | 1 |  |  | 0 | BVA393 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA727 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA727 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA664 |  |  |  |  |  |  |  | LL | 1 |  |  | 0 | BVA664 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA545 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA545 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA558 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA558 |  |  |  |  | BVA |  |  |  | 1
 |  | BVAA15 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | BVAA15 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA565 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA565 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA675 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA675 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA622 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA622 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA722 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | BVA722 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA554 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA554 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA715 |  |  |  |  |  |  |  | EX | 0.25 |  |  | 0.75 | BVA715 |  |  |  |  | BVA |  |  |  | 0.75
 |  | BVA638 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | BVA638 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA230 |  |  |  |  |  |  |  | LL | 1 |  |  | 0 | BVA230 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA745 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA745 |  |  |  |  | BVA |  |  |  | 1
 |  | BVAB53 |  |  |  |  |  |  |  | SK | 1 |  |  | 0 | BVAB53 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA219 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA219 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA738 |  |  |  |  |  |  |  | SU | 1 |  |  | 0 | BVA738 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA554 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA554 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA664 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA664 |  |  |  |  | BVA |  |  |  | 1
 |  | BVA313 |  |  |  |  |  |  |  | LL | 1 |  |  | 0 | BVA313 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA734 |  |  |  |  |  |  |  | TF | 1 |  |  | 0 | BVA734 |  |  |  |  | BVA |  |  |  | 0
 |  | BVA411 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVA411 |  |  |  |  | BVA |  |  |  | 1
 |  | BVC822 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC822 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC7P3 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC7P3 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC654 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC654 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC664 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC664 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC675 |  |  |  |  |  |  |  | TF | 1 |  |  | 0 | BVC675 |  |  |  |  | BVC |  |  |  | 0
 |  | BVC758 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC758 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC333 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC333 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC737 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC737 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC345 |  |  |  |  |  |  |  | SK | 1 |  |  | 0 | BVC345 |  |  |  |  | BVC |  |  |  | 0
 |  | BVC639 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC639 |  |  |  |  | BVC |  |  |  | 1
 |  | BVCB39 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVCB39 |  |  |  |  | BVC |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVC7B1 |  |  |  |  |  |  |  | LL | 1 |  |  | 0 | BVC7B1 |  |  |  |  | BVC |  |  |  | 0
 |  | BVC957 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC957 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC613 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC613 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC245 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC245 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC671 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVC671 |  |  |  |  | BVC |  |  |  | 1
 |  | BVC639 |  |  |  |  |  |  |  | SK | 1 |  |  | 0 | BVC639 |  |  |  |  | BVC |  |  |  | 0
 |  | BVS812 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS812 |  |  |  |  | BVS |  |  |  | 1
 |  | BVS771 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS771 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS227 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS227 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS346 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | BVS346 |  |  |  |  | BVS |  |  |  | 0 |  |  |  |  |  | 0
 |  | BVS812 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS812 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS224 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS224 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS222 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS222 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS552 |  |  |  |  |  |  |  | LL | 1 |  |  | 1 | BVS552 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS236 |  |  |  |  |  |  |  | LL | 1 |  |  | 1 | BVS236 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS179 |  |  |  |  |  |  |  | LL | 1 |  |  | 1 | BVS179 |  |  |  |  | BVS |  |  |  | 0 |  |  |  |  |  | 0
 |  | BVS343 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS343 |  |  |  |  | BVS |  |  |  | 1
 |  | BVS815 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS815 |  |  |  |  | BVS |  |  |  | 1
 |  | BVS396 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS396 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS227 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS227 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS815 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS815 |  |  |  |  | BVS |  |  |  | 1
 |  | BVS215 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS215 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS215 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS215 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS353 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS353 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS216 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | BVS216 |  |  |  |  | BVS |  |  |  | 0 |  |  |  |  |  | 0
 |  | BVS226 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS226 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS14 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS14 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS622 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS622 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS223 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS223 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS238 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS238 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS348 |  |  |  |  |  |  |  | OD | 1 |  |  | 0 | BVS348 |  |  |  |  | BVS |  |  |  | 0 |  |  |  |  |  | 0
 |  | BVS622 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS622 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS382 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS382 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS214 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS214 |  |  |  |  | BVS |  |  |  | 1
 |  | BVS225 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS225 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS224 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS224 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0
 |  | BVS353 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS353 |  |  |  |  | BVS |  |  |  | 1
 |  | BVS39B |  |  |  |  |  |  |  | TF | 1 |  |  | 0 | BVS39B |  |  |  |  | BVS |  |  |  | 0
 |  | BVS352 |  |  |  |  |  |  |  | 0 | 0 |  |  | 1 | BVS352 |  |  |  |  | BVS |  |  |  | 1 |  |  |  |  |  | 0