| Microsoft Excel 9.0 Answer Report | ||||||
| Worksheet: [petromorcase.xls]Sheet1 | ||||||
| Report Created: 10/16/2001 9:41:20 PM | ||||||
| Target Cell (Max) | ||||||
| Cell | Name | Original Value | Final Value | |||
| $I$5 | Zone 1 Revenue | 7203.5 | 7203.5 | |||
| Adjustable Cells | ||||||
| Cell | Name | Original Value | Final Value | |||
| $D$24 | Zone 1 A | 1 | 1 | |||
| $E$24 | Zone 1 B | 0 | 0 | |||
| $F$24 | Zone 1 C | 0 | 0 | |||
| $G$24 | Zone 1 D | 0 | 0 | |||
| $H$24 | Zone 1 E | 0 | 0 | |||
| $I$24 | Zone 1 F | 0 | 0 | |||
| $D$25 | Zone 2 A | 0 | 0 | |||
| $E$25 | Zone 2 B | 1 | 1 | |||
| $F$25 | Zone 2 C | 0 | 0 | |||
| $G$25 | Zone 2 D | 0 | 0 | |||
| $H$25 | Zone 2 E | 0 | 0 | |||
| $I$25 | Zone 2 F | 0 | 0 | |||
| $D$26 | Zone 3 A | 0 | 0 | |||
| $E$26 | Zone 3 B | 0 | 0 | |||
| $F$26 | Zone 3 C | 1 | 1 | |||
| $G$26 | Zone 3 D | 0 | 0 | |||
| $H$26 | Zone 3 E | 0 | 0 | |||
| $I$26 | Zone 3 F | 0 | 0 | |||
| $D$27 | Zone 4 A | 0 | 0 | |||
| $E$27 | Zone 4 B | 4.36E-23 | 0.00E+00 | |||
| $F$27 | Zone 4 C | 0 | 0 | |||
| $G$27 | Zone 4 D | 6.66134E-12 | 0 | |||
| $H$27 | Zone 4 E | 1 | 1 | |||
| $I$27 | Zone 4 F | 0 | 0 | |||
| Constraints | ||||||
| Cell | Name | Cell Value | Formula | Status | Slack | |
| $D$28 | Total A | 1 | $D$28<=1 | Binding | 0 | |
| $E$28 | Total B | 1 | $E$28<=1 | Binding | 0 | |
| $F$28 | Total C | 1 | $F$28<=1 | Binding | 0 | |
| $G$28 | Total D | 0 | $G$28<=1 | Not Binding | 1 | |
| $H$28 | Total E | 1 | $H$28<=1 | Binding | 0 | |
| $I$28 | Total F | 0 | $I$28<=1 | Not Binding | 1 | |
| $J$24 | Zone 1 Total | 1 | $J$24<=1 | Binding | 0 | |
| $J$25 | Zone 2 Total | 1 | $J$25<=1 | Binding | 0 | |
| $J$26 | Zone 3 Total | 1 | $J$26<=1 | Binding | 0 | |
| $J$27 | Zone 4 Total | 1 | $J$27<=1 | Binding | 0 | |