Spreadsheet: larry_may__21650__Balance Sheet0721
Sheet: Sheet4

REGION |  | [NAME] |  |  | RED=CALCULATED FROM ESCALATORS |  |  |  |  | rbs0415a  impexp derived from calculators
all |  |  |  |  | BLUE = DERIVED ALGERBRAICALLY
 |  |  |  |  | BLACK = FROM DATA
ESCALATORS |  | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
PRODUCTION |  | 0.9975 | 0.9975 | 0.9975 | 0.9975 | 0.9975 | 0.9975 | 0.9975 | 0.9975 | 0.9975 | 0.9975 | 0.9975 | 0.9975
imp/exp |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
NORMAL CURVE |  | 0.9885002523295329 | 1.013171912501779 | 1.004087239298206 | 0.9716859042507231 | 0.9893066825911624 | 1.012816056250969 | 1.020370100306822 | 1.031358945704506 | 1.037994036003288 | 1.037978227629932 | 1.027350712089943 | 1.048186022586211 | 1.032344373679835
ADJUSTMENT |  | 0 | 0 | 0 | 0 | 0 | 0 | -0.03504124354365088 | -0.05129902366374318 | -0.05712925493930016 | 0.0399845221204695 | 0.04882639460389587 | -0.02503014046080488
CONSUMPTION ESCALATOR
 |  |  |  |  |  |  |  | -0.03504124354365088 | -0.05129902366374318 | -0.05712925493930016 | 0.0399845221204695 | 0.04882639460389587 | -0.02503014046080488
Fundamental | Year | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  |  |  |  | Apr-Oct | Nov-Mar | Year
01.DryProduction | 1992 | 1622.321 | 1429.422 | 1508.853 | 1480.978 | 1520.137 | 1480.761 | 1528.68 | 1489.45 | 1475.126 | 1568.333 | 1549.1 | 1614.746
ESCALATOR | 1993 | 1594.998 | 1449.705 | 1578.81 | 1516.324 | 1552.11 | 1504.857 | 1555.524 | 1573.15 | 1519.154 | 1569.714 | 1583.805 | 1662.409
 | 1994 | 1711.72 | 1588.867 | 1668.052 | 1591.23 | 1627.825 | 1569.018 | 1592.973 | 1613.973 | 1528.801 | 1569.36 | 1546.429 | 1623.826
 | 1995 | 1531.084433 | 1364.76167945 | 1515.4830072 | 1466.16219505 | 1508.16215135 | 1453.8441608 | 1502.45937385 | 1492.3992675 | 1447.09591995 | 1472.22171405 | 1516.14932525 | 1571.91287115
 | 1996 | 1627.967 | 1540.036 | 1629.856 | 1609.856 | 1642.827 | 1596.997 | 1634.471 | 1633.75 | 1571.099 | 1596.586 | 1574.655 | 1611.842
 | 1997 | 1665.77 | 1509.387 | 1676.934 | 1600.316 | 1666.106 | 1575.463 | 1637.434 | 1634.39 | 1595.225 | 1638.207 | 1586.091 | 1612.461
 | 1998 | 1653.474 | 1521.582 | 1658.111 | 1589.802 | 1645.352 | 1600.552 | 1628.849 | 1647.947 | 1647.947
 | 1999
historical [NAME]
avg
min
04.NetImp/Exp | 1992 | -80.42993108048032 | 142.2508493887529 | -237.3560562659845 | -45.19207142857144 | -54.43840444753302 | -29.67955215686273 | -76.85290436746989 | -44.88283033620021 | -60.34475196850397 | -66.81268592057772 | -15.01010663507107 | -42.29788141176461
DERIVED | 1993 | -16.59151505892639 | -17.97518951241955 | -3.279693240093293 | 5.071099821746902 | -15.91583243658718 | -25.67369659442724 | -26.54428518518513 | -31.94521783625749 | 17.99397810789684 | 1.20268632707795 | -14.87836440677978 | -15.78840206185561
 | 1994 | -131.7945065037445 | -163.3709909248055 | -21.44099071358743 | 13.73948656898644 | 47.43596280400578 | 4.58472214182352 | 57.90083442265802 | 27.63579059829071 | 55.50736888888876 | 58.6655699658704 | 55.44978993563482 | 65.89804118773954
 | 1995 | 105.1284151065338 | 134.4430328291119 | 78.16484837673994 | 75.42161955674165 | 186.33493097291 | 66.8789044329749 | 103.5968839990314 | 95.49615821059419 | 95.76945047354634 | 95.78173547893698 | 158.7850215156414 | 107.7088733566781
 | 1996 | 9.740109204368077 | 59.8022760171308 | -126.8238770937076 | 4.051538882804001 | 19.70929631979701 | 3.074482806052278 | 23.79554874651812 | 24.70872491467571 | 14.59546533238028 | 13.9441201828869 | 4.716253164557035 | -6.405853486319487
 | 1997 | 15.93005166931651 | 65.44609840425537 | -46.47254838709676 | 4.79294425863972 | 3.905457214240931 | 48.00637722908089 | 9.97868369987062 | 3.337503285151128 | 48.91468096885798 | 103.7026849315068 | -9.576109814323566 | 54.38551295336786
 | 1998 | 29.05646552444636 | 11.67967364414864 | 25.73269132893485 | 59.32921122029045 | -22.81876370510388 | 43.27731309686217 | 86.29324902723731 | 54.076 | -73.186
 | 1999
historical [NAME]
avg
min
05.Supplemental | 1992 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 | 1993 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 | 1994 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 | 1995 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 | 1996 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 | 1997 | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 | 1998 | #REF! | #REF! | #REF!
 | 1999
historical [NAME]
avg
min
07.WorkGas | 1992 | 1937.447 | 1554.542 | 1257.915 | 1276.674 | 1547.527 | 1865.26 | 2164.651 | 2460.341 | 2745.196 | 2926.971 | 2753.496 | 2274.636
DERIVED FROM | 1993 | 1718.28 | 1167.017 | 863.838 | 975.497 | 1407.509 | 1781.136 | 2131.133 | 2452.351 | 2805.993 | 2959.516 | 2755.059 | 2314.045
INJWTH | 1994 | 1556.342 | 1038.96 | 904.266 | 1122.108 | 1524.682 | 1868.507 | 2252.793 | 2595.45 | 2919.535 | 3089.737 | 2990.617 | 2601.538
 | 1995 | 2036.855 | 1565.503 | 1326.013 | 1339.805 | 1702.945 | 2010.765 | 2301.551 | 2499.52 | 2790.213 | 2951.589 | 2723.141 | 2149.604
 | 1996 | 1480.553 | 1116.2795 | 752.006 | 843.137 | 1145.996 | 1498.97 | 1877.524 | 2235.844 | 2595.413 | 2799.581 | 2548.188 | 2170.206
 | 1997 | 1496.693 | 1154.444 | 984.712 | 1050.931 | 1327.254 | 1725.51 | 2018.006 | 2334.104 | 2667.048 | 2965.031 | 2698.399 | 2170.286
 | 1998 | 1714.48 | 1418.119 | 1183.83 | 1382.214 | 1775.372 | 2098.265 | 2415.529 | 2694.953 | 2946.153 | 3172.494 | 3077.010421352248 | 2803.009742699066
 | 1999 | 2095.007085599321 | 1745.006613992873 | 1460.005981350076 | 1569.006510469506
historical [NAME]
avg
min
09.NetInj/With | 1992 | -504.072 | -382.905 | -296.627 | 18.759 | 270.853 | 317.733 | 299.391 | 295.69 | 284.855 | 181.775 | -173.475 | -478.86
 | 1993 | -556.356 | -551.263 | -303.179 | 111.659 | 432.012 | 373.627 | 349.997 | 321.218 | 353.642 | 153.523 | -204.457 | -441.014
 | 1994 | -757.703 | -517.382 | -134.694 | 217.842 | 402.574 | 343.825 | 384.286 | 342.657 | 324.085 | 170.202 | -99.12 | -389.079
 | 1995 | -564.683 | -471.352 | -239.49 | 13.792 | 363.14 | 307.82 | 290.786 | 197.969 | 290.693 | 161.376 | -228.448 | -573.537
 | 1996 | -669.051 | -364.2735 | -364.2735 | 91.131 | 302.859 | 352.974 | 378.554 | 358.32 | 359.569 | 204.168 | -251.393 | -377.982
 | 1997 | -673.513 | -342.249 | -169.732 | 66.219 | 276.323 | 398.256 | 292.496 | 316.098 | 332.944 | 297.983 | -266.632 | -528.113
 | 1998 | -455.806 | -296.361 | -234.289 | 198.384 | 393.158 | 322.893 | 317.264 | 279.424 | 251.2 | 226.341 | -95.48357864775211 | -274.0006786531816
 | 1999 | -708.0026570997454 | -350.0004716064483 | -285.0006326427965 | 109.0005291194297
historical [NAME]
avg
min
10.Cons.Actual | 1992
ESCALATOR | 1993
 | 1994
 | 1995
 | 1996
 | 1997
 | 1998
 | 1999
historical [NAME]
avg
min
11.Demand(DOE) | 1992 | 2052.351 | 1862.587 | 1756.838 | 1526.029 | 1266.114 | 1121.039 | 1163.829 | 1121.69 | 1108.113 | 1213.71 | 1509.094 | 1935.626
ESCALATOR | 1993 | 2108.987 | 2001.405 | 1964.813 | 1528.728 | 1162.25 | 1154.712 | 1204.865 | 1221.773 | 1135.562 | 1334.228 | 1597.399 | 1942.028
 | 1994 | 2301.344 | 2109.723 | 1852.847 | 1478.279 | 1255.622 | 1236.938 | 1231.703 | 1248.274 | 1214.348 | 1322.422 | 1517.227 | 1907.93
 | 1995 | 2193.593 | 2011.572 | 1888.033 | 1590.333 | 1384.364 | 1229.651 | 1319.678 | 1354.063 | 1224.913 | 1327.985 | 1725.026 | 2107.003
 | 1996 | 2324.893 | 2106.661 | 1970.797 | 1626.076 | 1390.559 | 1286.014 | 1264.74 | 1293.956 | 1220.021 | 1347.397 | 1696.544 | 2024.516
 | 1997 | 2298.571 | 2086.318 | 1871.207 | 1605.098 | 1448.893 | 1274.152 | 1357.551 | 1344.599 | 1313.013 | 1363.017 | 1709.809 | 2111.976
 | 1998 | 2166.401 | 1890.79 | 1922.663 | 1539.302 | 1345.53 | 1323.645 | 1408.842 | 1422.599 | 1323.561
 | 1999
historical [NAME]
avg
min
12.BalanceItem | 1992
 | 1993
 | 1994
 | 1995
 | 1996
 | 1997
 | 1998
 | 1999
historical [NAME]
avg
min
13.DaysSupply | 1992
(w/DemandActual) | 1993
 | 1994
 | 1995
 | 1996
 | 1997
 | 1998
 | 1999
historical [NAME]
avg
min
CONSUMPTIONRES | 1992 | 783.89 | 694.097 | 572.169 | 430.01 | 250.357 | 161.708 | 131.284 | 125.101 | 136.422 | 239.414 | 435.287 | 715.439
 | 1993 | 832.172 | 766.645 | 701.219 | 450.885 | 235.435 | 165.662 | 130.366 | 120.265 | 140.855 | 252.252 | 453.47 | 700.048
 | 1994 | 942.17 | 827.042 | 624.468 | 387.967 | 244.611 | 153.556 | 123.83 | 121.461 | 131.774 | 225.084 | 364.37 | 640.965
 | 1995 | 806.624 | 744.149 | 588.415 | 412.428 | 255.673 | 156.688 | 125.014 | 114.116 | 136.373 | 226.818 | 514.637 | 752.867
 | 1996 | 916.424 | 815.139 | 691.899 | 463.987 | 265.336 | 160.374 | 122.508 | 115.354 | 136.175 | 242.191 | 495.984 | 739.561
 | 1997 | 904.333 | 769.764 | 614.627 | 436.443 | 280.896 | 160.653 | 127.719 | 114.083 | 128.756 | 235.444 | 502.21 | 732.869
 | 1998 | 795.633 | 677.973 | 632.929 | 410.044 | 229.358 | 154.182 | 129.277 | 114.295 | 122.393
 | 1999
historical [NAME]
avg
min
CONSUMPTIONCOM | 1992 | 407.819 | 363.265 | 312.141 | 248.016 | 167.985 | 123.49 | 121.082 | 120 | 119.469 | 164.194 | 253.654 | 378.196
 | 1993 | 414.753 | 400.603 | 368.361 | 253.8 | 153.09 | 123.136 | 118.444 | 110.372 | 118.242 | 166.66 | 256.861 | 358.249
 | 1994 | 468.7 | 430.554 | 345.248 | 233.615 | 161.584 | 131.556 | 127.454 | 118.403 | 116.192 | 159.435 | 236.822 | 338.629
 | 1995 | 424.427 | 407.207 | 337.854 | 250.043 | 181.564 | 131.484 | 132.246 | 128.298 | 128.33 | 168.424 | 295.33 | 411.948
 | 1996 | 472.02 | 436.38 | 383.59 | 278.987 | 183.063 | 138.465 | 130.363 | 127.716 | 130.128 | 174.684 | 300.242 | 405.42
 | 1997 | 468.401 | 417.93 | 361.541 | 264.467 | 228.347 | 143.051 | 128.956 | 130.417 | 135.492 | 182.807 | 307.654 | 405.661
 | 1998 | 436.225 | 383.711 | 364.36 | 254.192 | 171.063 | 142.74 | 147.279 | 156.97 | 156.646
 | 1999
historical [NAME]
avg
min
CONSUMPTIONINDUST | 1992 | 694.016 | 637.191 | 667.321 | 621.398 | 613.574 | 572.163 | 580.237 | 576.415 | 580.864 | 599.976 | 633.614 | 669.103
 | 1993 | 700.459 | 674.77 | 703.9 | 652.356 | 608.99 | 613.124 | 624.088 | 636.227 | 620.156 | 683.157 | 681.29 | 711.974
 | 1994 | 723.701 | 704.688 | 699.186 | 654.264 | 632.898 | 635.279 | 619.831 | 630.791 | 673.033 | 677.879 | 687.693 | 723.583
 | 1995 | 766.799 | 694.358 | 720.872 | 703.645 | 692.943 | 647.342 | 661.684 | 659.275 | 652.694 | 697.05 | 722.348 | 772.596
 | 1996 | 771.957 | 721.551 | 743.13 | 718.716 | 682.362 | 695.343 | 664.545 | 694.032 | 676.777 | 707.398 | 733.427 | 750.305
 | 1997 | 790.102 | 757.938 | 739.216 | 715.744 | 710.039 | 674.772 | 682.963 | 713.623 | 718.379 | 701.041 | 726.395 | 779.803
 | 1998 | 766.449 | 697.711 | 733.643 | 687.063 | 654.142 | 649.794 | 685.564 | 695.814 | 667.314
 | 1999
historical [NAME]
avg
min
CONSUMPTIONELECTRIC | 1992 | 166.626 | 168.034 | 205.207 | 226.605 | 234.198 | 263.678 | 331.226 | 300.174 | 271.358 | 210.126 | 186.539 | 172.888
 | 1993 | 161.603 | 159.387 | 191.333 | 171.687 | 164.735 | 252.79 | 331.967 | 354.909 | 256.309 | 232.159 | 205.778 | 171.757
 | 1994 | 166.773 | 147.439 | 183.945 | 202.433 | 216.529 | 316.547 | 360.588 | 377.619 | 293.349 | 260.024 | 228.342 | 204.753
 | 1995 | 195.743 | 165.858 | 240.892 | 224.217 | 254.184 | 294.137 | 400.734 | 452.374 | 307.516 | 235.693 | 192.711 | 169.592
 | 1996 | 164.492 | 133.591 | 152.178 | 164.386 | 259.798 | 291.832 | 347.324 | 356.854 | 276.941 | 223.124 | 166.891 | 129.23
 | 1997 | 135.735 | 140.686 | 155.823 | 188.444 | 229.611 | 295.676 | 417.913 | 386.476 | 330.386 | 243.725 | 173.55 | 193.643
 | 1998 | 168.094 | 131.395 | 191.731 | 188.003 | 290.967 | 376.929 | 446.722 | 455.52 | 377.208
 | 1999
historical [NAME]
avg
min
 |  | JAN-91 | FEB-91 | MAR-91 | APR-91 | MAY-91 | JUN-91 | [NAME] | AUG-91 | SEP-91 | OCT-91 | NOV-91 | DEC-91
 |  | JAN-92 | FEB-92 | MAR-92 | APR-92 | MAY-92 | JUN-92 | JUL-92 | AUG-92 | SEP-92 | OCT-92 | NOV-92 | DEC-92
 |  | JAN-93 | FEB-93 | MAR-93 | APR-93 | MAY-93 | JUN-93 | JUL-93 | AUG-93 | SEP-93 | OCT-93 | NOV-93 | DEC-93
 |  | JAN-94 | FEB-94 | MAR-94 | [NAME] | MAY-94 | [NAME] | JUL-94 | AUG-94 | SEP-94 | [NAME] | [NAME] | DEC-94
 |  | [NAME] | FEB-95 | MAR-95 | APR-95 | MAY-95 | JUN-95 | JUL-95 | AUG-95 | SEP-95 | OCT-95 | NOV-95 | DEC-95
 |  | JAN-96 | FEB-96 | MAR-96 | APR-96 | MAY-96 | JUN-96 | JUL-96 | AUG-96 | SEP-96 | OCT-96 | NOV-96 | DEC-96
 |  | JAN-97 | FEB-97 | MAR-97 | APR-97 | MAY-97 | JUN-97 | JUL-97 | AUG-97 | SEP-97 | OCT-97 | NOV-97 | DEC-97
 |  | [NAME] | FEB-98 | MAR-98 | APR-98 | MAY-98 | JUN-98 | [NAME] | AUG-98 | SEP-98 | OCT-98 | NOV-98 | DEC-98
 |  | JAN-99 | FEB-99 | MAR-99 | APR-99 | MAY-99 | JUN-99 | JUL-99 | AUG-99 | SEP-99 | OCT-99 | NOV-99 | DEC-99