Spreadsheet: 681723d1591713177-sumproduct-must-ignore-negative-values-lq
Sheet: RICHARD

Design | Lalique |  | Lalique |  |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK
SUPPLIER | B&S |  | B&S |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31
LEAD TIME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | check formulae
H/p - F/P | H/P |  |  |  |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | week |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK |  |  | WEEK
 |  |  |  |  |  |  | 2011-01-02 00:00:00
 |  |  |  |  | Shelf | Stock | PO | Potential | Potential | PO | Potential | Potential |  | Potential | Potential |  | Potential | Potential |  | Potential | Potential |  | Potential | Potential |  | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential | PO | Potential | Potential
 |  |  |  |  | Stock | in |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock | moved from | Stock | Stock | moved from | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock |  | Stock | Stock
 |  |  |  |  |  | Weeks |  |  | in |  |  | in |  |  | in |  |  | in | 2011-02-06 00:00:00 |  | in | 2011-02-20 00:00:00 |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in |  |  | in
 |  | COST | SIZE | COLOUR |  |  |  |  | Weeks | INITIAL ORDER |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks | Qty not changed |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks |  |  | Weeks
COMMENT |  | £ |  | ETA |  |  |  |  |  | 158565 |  |  | 158637 |  |  |  |  |  | 158638 |  |  | 158639 |  |  | 158871 |  |  |  |  |  |  |  |  | 158872 |  |  |  |  |  |  |  |  | 158873 |  |  |  |  |  |  |  |  | 158874 |  |  |  |  |  |  |  |  | 158875 |  |  |  |  |  |  |  |  | 158876
 |  |  |  | ORDER NO |  |  |  |  |  | 2011-01-09 00:00:00 |  |  | 2011-01-16 00:00:00 |  |  |  |  |  | 2011-01-30 00:00:00 |  |  | 2011-02-06 00:00:00 |  |  | 2011-02-13 00:00:00 |  |  |  |  |  |  |  |  | 2011-03-06 00:00:00 |  |  |  |  |  |  |  |  | 2011-03-27 00:00:00 |  |  |  |  |  |  |  |  | 2011-04-17 00:00:00 |  |  |  |  |  |  |  |  | 2011-05-08 00:00:00 |  |  |  |  |  |  |  |  | 2011-05-29 00:00:00
DCLAL-BLAC-116X137LE |  |  | 116x137 | Black/gold |  |  |  |  |  | 250 |  |  | 85 |  |  |  |  |  | 20 |  |  | 15 |  |  | 10 |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 10
DCLAL-BLAC-116X182LE |  |  | 116x182 | Black/gold |  |  |  |  |  | 250 |  |  | 65 |  |  |  |  |  | 15 |  |  | 10 |  |  | 80 |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 10
DCLAL-BLAC-116X228LE |  |  | 116x228 | Black/gold |  |  |  |  |  | 250 |  |  | 95 |  |  |  |  |  | 20 |  |  | 20 |  |  | 10 |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 15
DCLAL-BLAC-168X137LE |  |  | 168x137 | Black/gold |  |  |  |  |  | 250 |  |  | 60 |  |  |  |  |  | 10 |  |  | 10 |  |  | 65 |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  | 10
DCLAL-BLAC-168X182LE |  |  | 168x182 | Black/gold |  |  |  |  |  | 250 |  |  | 105 |  |  |  |  |  | 25 |  |  | 20 |  |  | 100 |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  | 10
DCLAL-BLAC-168X228LE |  |  | 168x228 | Black/gold |  |  |  |  |  | 250 |  |  | 200 |  |  |  |  |  | 35 |  |  | 45 |  |  | 130 |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  | 30
DCLAL-BLAC-228X137LE |  |  | 228x137 | Black/gold |  |  |  |  |  | 250 |  |  | 45 |  |  |  |  |  | 10 |  |  | 10 |  |  | 30 |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  | 15
DCLAL-BLAC-228X182LE |  |  | 228x182 | Black/gold |  |  |  |  |  | 250 |  |  | 130 |  |  |  |  |  | 25 |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  | 20
DCLAL-BLAC-228X228LE |  |  | 228x228 | Black/gold |  |  |  |  |  | 250 |  |  | 220 |  |  |  |  |  | 60 |  |  | 35 |  |  | 125 |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  | 80 |  |  |  |  |  |  |  |  | 85 |  |  |  |  |  |  |  |  | 85 |  |  |  |  |  |  |  |  | 40
DCLAL-BLAC-TIEX076TD |  |  | 076cm Oblong Tieback | Black/gold |  |  |  |  |  | 500 |  |  | 300 |  |  |  |  |  | 50 |  |  | 50 |  |  | 100 |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  | 125 |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  | 50
DCLAL-BLAC-045x045CC |  |  | 18" Cushion | Black/gold |  |  |  |  |  | 1250 |  |  | 650 |  |  |  |  |  | 100 |  |  | 150 |  |  | 400 |  |  |  |  |  |  |  |  | 150 |  |  |  |  |  |  |  |  | 250 |  |  |  |  |  |  |  |  | 250 |  |  |  |  |  |  |  |  | 250 |  |  |  |  |  |  |  |  | 100
DCLAL-BLAC-060X060UF |  |  | 24" CUSHION | Black/gold |  |  |  |  |  | 1250 |  |  | 650 |  |  |  |  |  | 100 |  |  | 150 |  |  | 700 |  |  |  |  |  |  |  |  | 150 |  |  |  |  |  |  |  |  | 100 |  |  |  |  |  |  |  |  | 250 |  |  |  |  |  |  |  |  | 250 |  |  |  |  |  |  |  |  | 100
DCLAL-BLAC-060X060CC |  |  | CURTAIN | TOTALS
 |  |  |  | VALUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 03.04 |  |  |  |  |  | 17.04 |  |  |  |  |  | 01.05 |  |  |  |  |  | 15.05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 158871 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 158873 |  |  |  |  |  | 158874 |  |  |  |  |  | 158875 |  |  |  |  |  | 158876
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  | 20 |  |  |  |  |  | 20 |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  | 20 |  |  |  |  |  | 20 |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  | 20 |  |  |  |  |  | 20 |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  | 20 |  |  |  |  |  | 20 |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  | 25 |  |  |  |  |  | 25 |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 |  |  |  |  |  | 50 |  |  |  |  |  | 50 |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  | 10 |  |  |  |  |  | 10 |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  | 35 |  |  |  |  |  | 35 |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  | 60 |  |  |  |  |  | 60 |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 |  |  |  |  |  | 70 |  |  |  |  |  | 70 |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160 |  |  |  |  |  | 160 |  |  |  |  |  | 160 |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160 |  |  |  |  |  | 160 |  |  |  |  |  | 160 |  |  |  |  |  | 100