Spreadsheet: 100734d1298997252-excel-2007-vlookup-pic-doodles
Sheet: 794580

 | Purchase Order # | 764580
PO Limit  % Completed | 0.008514345000000001 | 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 | 0 | 0
PO Limit  QTY Remaining | 9914856.55 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
ACTION | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED
Product Description | 1000000
Line No | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
PO Line Limit | 10000000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
ENTER START DATE IN BLUE MM/DD/YY | Enter Daily Sales as per PO Limit unit
2011-01-01 00:00:00 | 42571.2 | <<<  need dollar amounts to transfer into columb B
2011-01-02 00:00:00 | 42572.25
2011-01-03 00:00:00
2011-01-04 00:00:00
2011-01-05 00:00:00
2011-01-06 00:00:00
2011-01-07 00:00:00
2011-01-08 00:00:00
2011-01-09 00:00:00
2011-01-10 00:00:00
2011-01-11 00:00:00
2011-01-12 00:00:00
2011-01-13 00:00:00
2011-01-14 00:00:00
2011-01-15 00:00:00
2011-01-16 00:00:00
2011-01-17 00:00:00
2011-01-18 00:00:00
2011-01-19 00:00:00
2011-01-20 00:00:00
2011-01-21 00:00:00
2011-01-22 00:00:00
2011-01-23 00:00:00
2011-01-24 00:00:00
2011-01-25 00:00:00
2011-01-26 00:00:00
2011-01-27 00:00:00
2011-01-28 00:00:00
2011-01-29 00:00:00
2011-01-30 00:00:00
2011-01-31 00:00:00
2011-02-01 00:00:00
2011-02-02 00:00:00
2011-02-03 00:00:00
2011-02-04 00:00:00
2011-02-05 00:00:00
2011-02-06 00:00:00
2011-02-07 00:00:00
2011-02-08 00:00:00
2011-02-09 00:00:00
2011-02-10 00:00:00
2011-02-11 00:00:00
2011-02-12 00:00:00
2011-02-13 00:00:00
2011-02-14 00:00:00
2011-02-15 00:00:00
2011-02-16 00:00:00
2011-02-17 00:00:00
2011-02-18 00:00:00
2011-02-19 00:00:00
2011-02-20 00:00:00
2011-02-21 00:00:00
2011-02-22 00:00:00
2011-02-23 00:00:00
2011-02-24 00:00:00
2011-02-25 00:00:00
2011-02-26 00:00:00
2011-02-27 00:00:00
2011-02-28 00:00:00
2011-03-01 00:00:00
2011-03-02 00:00:00
2011-03-03 00:00:00
2011-03-04 00:00:00
2011-03-05 00:00:00
2011-03-06 00:00:00
2011-03-07 00:00:00
2011-03-08 00:00:00
2011-03-09 00:00:00
2011-03-10 00:00:00
2011-03-11 00:00:00
2011-03-12 00:00:00
2011-03-13 00:00:00
ADD NEW LINES "Press "+"
Total | 85143.45000000001 | 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 | 0 | 0
% of PO Complete | 0.008514345000000001 | 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 | 0 | 0
ACTION | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED
 | If | then return
 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75
 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9 | 0.9
 | >.90 | >.90 | >.90 | >.90 | >.90 | >.90 | >.91 | >.92 | >.93 | >.94 | >.95 | >.96 | >.97 | >.98 | >.99 | >.100 | >.101 | >.102 | >.103 | >.104 | >.105 | >.106 | >.107 | >.108 | >.109 | >.110 | >.111 | >.112 | >.113 | >.114 | >.115 | >.116 | >.117 | >.118 | >.119 | >.120 | >.121
 | a
 | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED | PROCEED
 | 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 | 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 | 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 | 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
PROCEED
STOP ORDER AND CALL GM URGENT ACTION REQUIRED
CALL CUSTOMER AND CONFIRM REMAINING QUANTITIES