Spreadsheet: 209315d1359061475-conditional-formatting-highlight-entire-column-with-todays-date-tank-farm-inventory-spreadsheet-modified-by-moo
Sheet: Sheet1

 | Jan. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar.
 |  | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | 2013-01-04 00:00:00 | 2013-01-05 00:00:00 | 2013-01-06 00:00:00 | 2013-01-07 00:00:00 | 2013-01-08 00:00:00 | 2013-01-09 00:00:00 | 2013-01-10 00:00:00 | 2013-01-11 00:00:00 | 2013-01-12 00:00:00 | 2013-01-13 00:00:00 | 2013-01-14 00:00:00 | 2013-01-15 00:00:00 | 2013-01-16 00:00:00 | 2013-01-17 00:00:00 | 2013-01-18 00:00:00 | 2013-01-19 00:00:00 | 2013-01-20 00:00:00 | 2013-01-21 00:00:00 | 2013-01-22 00:00:00 | 2013-01-23 00:00:00 | 2013-01-24 00:00:00 | 2013-01-25 00:00:00 | 2013-01-26 00:00:00 | 2013-01-27 00:00:00 | 2013-01-28 00:00:00 | 2013-01-29 00:00:00 | 2013-01-30 00:00:00 | 2013-01-31 00:00:00 | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00 | 2013-02-16 00:00:00 | 2013-02-17 00:00:00 | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00
2ME |  |  | Wed | 2013-01-03 00:00:00 | 2013-01-04 00:00:00 | 2013-01-05 00:00:00 | 2013-01-06 00:00:00 | 2013-01-07 00:00:00 | 2013-01-08 00:00:00 | 2013-01-09 00:00:00 | 2013-01-10 00:00:00 | 2013-01-11 00:00:00 | 2013-01-12 00:00:00 | 2013-01-13 00:00:00 | 2013-01-14 00:00:00 | 2013-01-15 00:00:00 | 2013-01-16 00:00:00 | 2013-01-17 00:00:00 | 2013-01-18 00:00:00 | 2013-01-19 00:00:00 | 2013-01-20 00:00:00 | 2013-01-21 00:00:00 | 2013-01-22 00:00:00 | 2013-01-23 00:00:00 | 2013-01-24 00:00:00 | 2013-01-25 00:00:00 | 2013-01-26 00:00:00 | 2013-01-27 00:00:00 | 2013-01-28 00:00:00 | 2013-01-29 00:00:00 | 2013-01-30 00:00:00 | 2013-01-31 00:00:00 |  | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00 | 2013-02-04 00:00:00 | 2013-02-05 00:00:00 | 2013-02-06 00:00:00 | 2013-02-07 00:00:00 | 2013-02-08 00:00:00 | 2013-02-09 00:00:00 | 2013-02-10 00:00:00 | 2013-02-11 00:00:00 | 2013-02-12 00:00:00 | 2013-02-13 00:00:00 | 2013-02-14 00:00:00 | 2013-02-15 00:00:00 | 2013-02-16 00:00:00 | 2013-02-17 00:00:00 | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-23 00:00:00 | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00
Delivery Day |  |  |  |  |  |  |  |  |  | 45000 |  |  |  |  |  |  |  | 45000 |  |  |  |  |  |  |  |  |  |  | 45000 |  |  | 45000
Projected Inventory |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50289 | 45690 | 39690 | 33690 | 27690 | 21690 | 60690 | 54690 | 48690 | 87690 |  | 81690 | 75690 | 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
Actual Usage |  |  |  |  |  |  |  | 2126 | 0 | 9860 | 4385 |  |  |  | 1038 | 1980 | 938 |  |  |  |  | 4666 | 4599 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 |  | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
Tank Farm Total |  |  |  |  |  |  | 6674 | 4548 | 4548 | 39688 | 35303 | 35303 | 35303 | 11085 | 10047 | 8067 | 7129 | 52129 | 52129 | 52129 | 54955 | 50289 | 45690 | 39690 | 33690 | 27690 | 21690 | 15690 | 54690 | 48690 | 42690 | 81690 |  | 75690 | 0
Butyl Crudes
Delivery Day |  |  |  |  |  |  |  | 45000 | 45000 |  | 45000 | 45000 |  |  |  | 45000 | 45000 | 45000 |  |  |  |  | 45000 | 45000 |  | 45000 |  |  | 45000 |  | 45000
Projected Inventory |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81412 | 102618 | 79098 | 100578 | 77058 | 53538 | 75018 | 51498 | 72978 | 49458
Actual Usage |  |  |  |  |  |  |  |  | 23499 | 24435 | 2407 |  |  |  |  | 20369 | 18675 | 23520 | 23520 | 23520 | 23520 | 12357 | 21206 | 23520 | 23520 | 23520 | 23520 | 23520 | 23520 | 23520 | 23520 | 23520
Tank Farm Total |  |  |  |  |  |  | 27544 | 90720 | 67221 | 42786 | 85379 | 130379 | 130379 | 36940 | 52086 | 76717 | 85392 | 106872 | 83352 | 59832 | 48769 | 36412 | 57618 | 79098 | 55578 | 77058 | 53538 | 30018 | 51498 | 27978 | 49458 | 25938
Tall Oil
Delivery Day |  |  |  |  |  |  |  |  | 45000 |  |  | 45000 |  |  | 45000 |  |  | 45000 | 45000 |  |  | 45000 | 45000 |  | 45000 | 45000 |  |  | 45000
Projected Inventory |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78836 | 68586 | 90581 | 112576 | 89571 | 66566 | 88561 | 65556 | 42551 | 19546
Actual Usage |  |  |  |  |  |  |  | 0 | 0 | 13965 | 20181 |  |  |  | 24844 | 3332 | 0 |  |  |  |  | 23005 | 10288 | 23005 | 23005 | 23005 | 23005 | 23005 | 23005 | 23005 | 23005 | 23005
Tank Farm Total |  |  |  |  |  |  | 37649 | 37649 | 83577 | 69612 | 49431 | 94431 | 94431 | 32949 | 53105 | 49773 | 49773 | 94773 | 139773 | 139773 | 11841 | 33836 | 68586 | 45581 | 67576 | 89571 | 66566 | 43561 | 65556 | 42551 | 19546 | -3459