Spreadsheet: 275265d1383424682-min-formula-yields-inaccurate-result-when-using-negative-number-master-tally-11022013
Sheet: MASTER TALLY

PEACHTREE      ITEM NUMBERS |  | # | size | THU Price Case | FRI Price Case | SAT Price Case | TUES Price Case | PURCH COST |  | In Stock [NAME] | ETA  Wed | ETA  Thurs | ETA Fri | ETA Sat | ETA Mon | [NAME] | TOTAL AVAIL |  | Thur | Fri | Sat | Mon | Tue | Wed | TOTAL SOLD |  | Thur | Frid | Sat | Mon | Tue | Wed | [NAME] |  | ORDER |  |  | Wed | Thu | Fri | Sat | Mon | Tue |  | Wed | Thur | Fri | Sat | Mon | Tue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOLD |  |  |  |  |  |  |  | AVAILABLE |  |  |  |  |  |  |  |  |  |  | RETURNED TO STOCK |  |  |  |  |  |  | SHRUNK
 | 2013-10-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-10-23 00:00:00 | 2013-10-24 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00 | 2013-10-28 00:00:00 | 2013-10-29 00:00:00
 | NEW FORMULAS |  |  |  |  |  |  |  |  | 0 | NO |  |  |  |  |  | 0
LUCK-60145-25 | Beans, Green 25# | 25 | lbs | 39 | 39 | 39 | 39 | 27 |  | 10 |  |  |  |  |  |  | 11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 | 10 | 10 | 11 | 11 | 11 | 11 |  |  |  |  | 0 | 0 | 0 | 1 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
LUCK-64650-24 | Chard, Red 24ct | 24 | ct | 36 | 36 | 36 | 36 | 24 |  | 10 |  |  |  |  |  |  | 9 |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 7 | 7 | 7 | 7 | 8 | 9 | 9 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 1 | 0 | 0
LUCK-64630-24 | Chard, Rainbow 24ct | 24 | ct | 36 | 36 | 36 | 36 | 24 |  | 10 |  |  |  |  |  |  | 11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 | 10 | 10 | 11 | 11 | 11 | 11 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | -1 | 0 | 0
 | POSITIVE WORKS BUT NEG DOES NOT
LUCK-64660-24 | Chard, Gold 24ct | 24 | ct | 36 | 36 | 36 | 36 | 24 |  | 10 |  |  |  |  |  |  | 16 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 11 | 12 | 13 | 14 | 15 | 16 | 16 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
LUCK-60915-24 | Celery 24ct | 24 | ct | 40 | 40 | 40 | 40 | 28 |  | 10 |  |  |  |  |  |  | 4 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | -11 | -10 | -8 | -5 | -1 | 4 | 4 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 1 | 1 | 1 | 1 | 1 | 1
LUCK-61025-24 | Collards 24ct | 24 | ct | 32 | 32 | 32 | 32 | 22 |  | 10 |  |  |  |  |  |  | 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
LUCK-61460-24 | Fennel 24ct | 24 | ct | 35 | 35 | 35 | 35 | 24 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | [NAME], Green 24ct | 24 | ct | 39 | 39 | 39 | 39 | 24 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
LUCK-61780-24 | [NAME], Lacinata 24ct | 24 | ct | 39 | 39 | 39 | 39 | 27 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
LUCK-61785-24 | Kale, Red Bor 24ct | 24 | ct | 39 | 39 | 39 | 39 | 28 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 | ORIGINAL [NAME] |  |  |  |  |  |  |  |  | 0 | NO |  |  |  |  |  | 0
LUCK-61885-20 | Leeks 20# | 20 | lbs | 32 | 32 | 32 | 32 | 22 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LUCK-62040-24 | Lettuce, Green Leaf 24ct | 24 | ct | 29 | 29 | 29 | 29 | 20 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LUCK-62160-24 | Lettuce, Red Leaf 24ct | 24 | ct | 29 | 29 | 29 | 29 | 20 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LUCK-62170-24 | Lettuce, Red Salad Bowl 24ct | 24 | ct | 29 | 29 | 29 | 29 | 20 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LUCK-62280-24 | Lettuce, Romaine 24ct | 24 | ct | 32 | 32 | 32 | 32 | 22 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LUCK-61990-24 | Lettuce, Green Boston 24ct | 24 | ct | 30 | 30 | 30 | 30 | 21 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LUCK-61965-24 | Lettuce, Red Boston 24ct | 24 | ct | 30 | 30 | 30 | 30 | 21 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LUCK-62735-20 | Onions, Cipollini 20# | 20 | lbs | 39 | 39 | 39 | 39 | 28 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
LUCK-64012-24 | Scallions 24ct | 24 | ct | 38 | 38 | 38 | 38 | 26 |  | 0 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0