Spreadsheet: chris_stokley__3949__052101 Weather Difference Forecast Compare
Sheet: ForecastedWeather050701-051301

FORECAST USING FORECASTED WEATHER DATA
PGE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME].
2001-05-21 00:00:00 | 50.273752 | 49.371576 | 48.773919 | 48.261542 | 48.004384 | 48.795997 | 50.378325 | 52.450306 | 54.075382 | 57.402648 | 57.925829 | 59.149558 | 59.952264 | 60.084356 | 61.356124 | 62.832474 | 64.033478 | 63.907199 | 62.787318 | 59.673997 | 58.509878 | 58.234199 | 55.827652 | 52.907372
2001-05-22 00:00:00 | 48.68275404950496 | 47.88163935901797 | 47.40822096633368 | 47.15082472493172 | 47.23791855473607 | 48.56450391733119 | 50.69947565266552 | 52.58998213274589 | 53.19985454833397 | 53.68558701281546 | 55.04288343217071 | 55.8934512714869 | 56.4834835426978 | 56.47488561106874 | 57.04224821184425 | 57.96247445099756 | 58.65375346162103 | 58.64267646217896 | 57.942430816599 | 55.85820011662512 | 55.57694446544469 | 55.14171224046319 | 52.93489115928739 | 50.44586599760437
2001-05-23 00:00:00 | 49.079052 | 48.273484 | 47.767909 | 47.466429 | 47.472611 | 48.595958 | 50.669161 | 52.608752 | 53.441383 | 54.598756 | 55.711408 | 56.621135 | 57.287981 | 57.389878 | 58.061849 | 59.07818 | 59.954932 | 59.945347 | 59.01377 | 56.735949 | 56.242646 | 56.029598 | 53.789295 | 51.259206
2001-05-24 00:00:00 | 49.102833 | 48.226192 | 47.788854 | 47.493626 | 47.440383 | 48.655066 | 50.745213 | 52.606175 | 53.34604 | 54.490904 | 55.633944 | 56.45354 | 57.114945 | 57.210763 | 57.771797 | 58.91873 | 59.611277 | 59.844732 | 58.760671 | 56.360954 | 55.982351 | 55.757783 | 53.522401 | 51.16775
2001-05-25 00:00:00 | 48.874869 | 48.072045 | 47.512663 | 47.31611 | 47.306066 | 48.521265 | 50.612054 | 52.522805 | 53.467368 | 54.171206 | 55.496058 | 56.390351 | 57.000534 | 57.091632 | 57.720078 | 58.613538 | 59.197097 | 59.020931 | 57.977459 | 55.819567 | 55.164147 | 54.901907 | 53.161699 | 51.252051
2001-05-26 00:00:00 | 47.7162 | 46.78428 | 46.364389 | 45.959007 | 45.9722 | 46.142504 | 46.60491 | 47.920682 | 49.20232 | 50.538457 | 50.903735 | 51.69583 | 52.139479 | 52.676527 | 52.840883 | 53.450547 | 54.816193 | 55.176793 | 54.533956 | 53.58825 | 53.219482 | 52.784591 | 51.079013 | 49.24436
2001-05-27 00:00:00 | 48.07404 | 46.974939 | 46.476626 | 46.03882 | 45.964603 | 46.042519 | 46.421605 | 47.678057 | 48.982349 | 50.681229 | 51.060343 | 51.81743 | 52.537582 | 53.353549 | 53.778809 | 54.42446 | 55.720031 | 56.240754 | 55.729232 | 54.692051 | 54.252712 | 53.753686 | 51.590253 | 49.264174
SDGE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME].
2001-05-20 00:00:00 | 53.936875 | 53.080506 | 52.811275 | 52.012672 | 51.41594 | 51.894634 | 53.542891 | 55.303683 | 58.771634 | 60.175704 | 61.579254 | 62.060314 | 62.06775 | 61.990198 | 61.518766 | 61.038707 | 61.090507 | 60.976394 | 61.35302 | 61.383834 | 60.73981 | 58.751219 | 56.676495 | 54.492291
2001-05-21 00:00:00 | 54.054804 | 53.163566 | 52.689099 | 52.860793 | 53.950427 | 58.431561 | 64.062017 | 68.153578 | 71.373448 | 72.724091 | 73.917537 | 73.763064 | 73.760688 | 73.701208 | 72.548798 | 70.150878 | 67.715906 | 66.815859 | 66.947706 | 66.268524 | 65.543252 | 63.098969 | 60.601942 | 55.319206
2001-05-22 00:00:00 | 56.53037844786526 | 55.48566208535789 | 55.17377878251424 | 55.25124907345569 | 55.65829134677567 | 59.41183695649309 | 64.42381975135767 | 68.1050912287451 | 71.5724119233325 | 72.04127234081518 | 73.07109809033578 | 73.52354767902554 | 73.99988820545501 | 73.69675791282882 | 72.70362721583241 | 71.51103535345489 | 70.4947615916184 | 68.7848432873706 | 67.53584005550594 | 67.14559075578687 | 66.20745172919257 | 63.39743061400325 | 60.37400290635837 | 58.47361475122764
2001-05-23 00:00:00 | 57.204741 | 56.111564 | 55.680008 | 55.039214 | 55.512145 | 59.875422 | 64.651478 | 67.971554 | 70.913707 | 71.409713 | 72.208314 | 72.597281 | 72.658772 | 72.488204 | 71.176658 | 69.211659 | 68.030195 | 66.622759 | 66.109213 | 65.959916 | 64.741178 | 61.442367 | 58.534151 | 58.301737
2001-05-24 00:00:00 | 55.348609 | 54.538208 | 54.196296 | 53.907909 | 54.729165 | 59.025161 | 64.783409 | 68.428327 | 71.523448 | 72.36663 | 73.382756 | 73.876273 | 74.102646 | 74.045157 | 72.813586 | 70.304634 | 68.861481 | 68.260505 | 67.525596 | 66.804802 | 65.690813 | 62.403401 | 58.080363 | 56.796816
2001-05-25 00:00:00 | 56.217584 | 54.919717 | 54.784256 | 54.466098 | 55.489768 | 59.922899 | 65.396756 | 68.687193 | 71.621687 | 72.359939 | 73.542571 | 73.854438 | 74.036099 | 73.514403 | 72.365172 | 70.132645 | 68.126404 | 66.479463 | 64.868283 | 64.756064 | 64.419645 | 62.639759 | 60.761197 | 56.869333
2001-05-26 00:00:00 | 57.00693 | 56.062486 | 55.577735 | 54.808341 | 54.364848 | 55.851672 | 57.867792 | 60.130512 | 62.480995 | 63.798222 | 64.691803 | 64.813491 | 64.836587 | 64.685218 | 64.202431 | 64.191048 | 64.303674 | 63.007581 | 62.542424 | 62.663707 | 62.138249 | 60.762321 | 58.901739 | 58.074506
SCE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME].
2001-05-21 00:00:00 | 4.829119181383945 | 4.558712048162232 | 4.421305094603065 | 4.541976189330166 | 4.986966713314192 | 5.87742357706665 | 6.25072062103802 | 6.208195043886814 | 6.462040962167081 | 6.762534006190721 | 6.868087562247351 | 6.972896529588915 | 7.002816748738211 | 7.086007329759082 | 7.22074599421632 | 7.601380780173272 | 8.08935906498584 | 8.546309240957179 | 9.176297731749493 | 10.13676240679967 | 9.628431534057494 | 8.099008959807032 | 6.46718019728768 | 5.371465030876672
2001-05-22 00:00:00 | 4.875669040062903 | 4.583950928996448 | 4.486690215589601 | 4.587007214262223 | 5.123769389220263 | 6.079725497409558 | 6.463011428398221 | 6.235503132052888 | 6.356012024187986 | 6.521871784901006 | 6.712275531340699 | 6.996349410766827 | 7.07311549232997 | 7.214702836848449 | 7.520962356613743 | 7.941580096805726 | 8.433438897767857 | 8.835118178831024 | 9.334142036870016 | 10.29638915610954 | 9.874366664916646 | 8.302084934819216 | 6.612034401848872 | 5.444727632739837
2001-05-23 00:00:00 | 5.265644951378746 | 4.917770855409325 | 4.697538281530591 | 4.731412211147886 | 5.246551456760931 | 6.093743631518214 | 6.453773244713804 | 6.413999272543282 | 6.647425606824321 | 6.988704695713709 | 7.429061590838477 | 7.855654443558564 | 8.18256484141401 | 8.420997760209094 | 8.95257686052472 | 9.331136936935838 | 9.852959061301767 | 9.929458196320217 | 9.939290668868114 | 10.91909200698441 | 10.62723949912864 | 9.061291323782083 | 7.135155245644071 | 5.929546905336294
2001-05-24 00:00:00 | 5.072173071121693 | 4.758030602864394 | 4.569819385920159 | 4.641011522608283 | 5.140774401974046 | 6.032157817528025 | 6.374581219171876 | 6.281828801083702 | 6.472677482925415 | 6.707275700102528 | 6.930430646225382 | 7.298767909206989 | 7.513863156697672 | 7.723879811781101 | 8.011724029503645 | 8.484043373857528 | 8.914696082207785 | 9.110674294226195 | 9.513363872168894 | 10.53106063758838 | 10.20302276914054 | 8.710847741900649 | 6.949423714078988 | 5.751187504503244
2001-05-25 00:00:00 | 4.99542926353607 | 4.694951817943092 | 4.527083487951783 | 4.619450425059679 | 5.143959687312054 | 6.01700689727588 | 6.514715602855472 | 6.296666672728684 | 6.434097237248695 | 6.619954996452964 | 6.831583200468888 | 7.076157346904647 | 7.169605129499947 | 7.325515147889676 | 7.645785925976814 | 7.874162923415165 | 8.238553693025041 | 8.429181256440891 | 8.770904150452855 | 9.59655941582353 | 9.438603507683517 | 8.44304621376017 | 7.005067337168644 | 5.903128211512949
2001-05-26 00:00:00 | 5.236058425722149 | 4.865674027594857 | 4.630741669018547 | 4.599521877710282 | 4.705653130072299 | 5.105055696171443 | 5.814954533168105 | 6.537853362057914 | 7.149844161379521 | 7.576820523362148 | 7.69558869048833 | 7.862904904836506 | 7.900267235172288 | 7.978161617970182 | 8.066481962952835 | 8.164122451460205 | 8.257706761160582 | 8.27552554114421 | 8.721159916754692 | 9.476197443577787 | 9.291209378384545 | 8.420073136540891 | 7.169220842603577 | 6.0030892590832
2001-05-27 00:00:00 | 5.120446292491583 | 4.721459791339607 | 4.518984559559295 | 4.450541454134537 | 4.575275884737199 | 4.890316766642192 | 5.579914713933825 | 6.3511607468451 | 6.943035648391027 | 7.225461864545391 | 7.194274285910765 | 7.276642714638863 | 7.286327314963452 | 7.225754694107687 | 7.224160454042368 | 7.349375307414686 | 7.602443959692114 | 7.889938366459136 | 8.577411667065991 | 9.688796037958655 | 9.307348250672428 | 8.047469218667002 | 6.506682989148564 | 5.40761956502564
PGE2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME].
2001-05-21 00:00:00 | 3.644276 | 3.495691 | 3.390037 | 3.336991 | 3.371755 | 3.583969 | 4.068823 | 4.46242 | 4.682809 | 5.122976 | 5.306011 | 5.519281 | 5.541989 | 5.724132 | 5.781745 | 5.876419 | 5.95078 | 6.016141 | 5.948311 | 5.618768 | 5.48257 | 5.342795 | 4.802582 | 4.166824
2001-05-22 00:00:00 | 3.667349166590938 | 3.517439289792339 | 3.393845524744113 | 3.331936817513058 | 3.370159183181501 | 3.67083820992196 | 4.162864916929492 | 4.5601287844156 | 4.721632300510088 | 5.079922545205965 | 5.180162254369002 | 5.38959398459219 | 5.443676112439669 | 5.503870979359738 | 5.591693956738456 | 5.685738889733353 | 5.787411131937779 | 5.891396288809312 | 5.84649030902141 | 5.535633098653086 | 5.377606605294918 | 5.265208483232641 | 4.753233775028884 | 4.126889928208382
2001-05-23 00:00:00 | 3.780795 | 3.597766 | 3.467383 | 3.39097 | 3.444264 | 3.632173 | 4.14352 | 4.584294 | 4.692115 | 5.226307 | 5.316251 | 5.508634 | 5.598966 | 5.744004 | 5.808358 | 5.858668 | 5.949971 | 6.042474 | 5.941403 | 5.614097 | 5.459079 | 5.420256 | 4.895851 | 4.265339
2001-05-24 00:00:00 | 3.799445 | 3.630525 | 3.516686 | 3.429937 | 3.456416 | 3.748563 | 4.22342 | 4.600523 | 4.692395 | 5.082723 | 5.259942 | 5.358037 | 5.430901 | 5.491845 | 5.505015 | 5.637796 | 5.698326 | 5.87681 | 5.786495 | 5.496754 | 5.388488 | 5.317004 | 4.800258 | 4.217066
2001-05-25 00:00:00 | 3.756365 | 3.602154 | 3.45352 | 3.407492 | 3.435367 | 3.70045 | 4.163415 | 4.542241 | 4.693028 | 5.023944 | 5.16831 | 5.352052 | 5.352668 | 5.443738 | 5.517737 | 5.597804 | 5.653824 | 5.701337 | 5.628341 | 5.342929 | 5.128096 | 5.046138 | 4.645397 | 4.161376
2001-05-26 00:00:00 | 3.708496 | 3.514952 | 3.400369 | 3.325829 | 3.332147 | 3.445743 | 3.605789 | 3.910154 | 4.309918 | 4.68171 | 4.739236 | 4.967367 | 5.038391 | 5.102668 | 5.110127 | 5.150358 | 5.221728 | 5.307232 | 5.25507 | 5.12937 | 4.922861 | 4.837643 | 4.44134 | 4.001894
2001-05-27 00:00:00 | 1.572248 | 1.363358 | 1.265142 | 1.204159 | 1.198061 | 1.244524 | 1.366522 | 1.620406 | 1.945604 | 2.252192 | 2.241977 | 2.282614 | 2.331954 | 2.411921 | 2.512293 | 2.590094 | 2.689491 | 2.85393 | 2.933214 | 2.892054 | 2.953455 | 2.871029 | 2.394848 | 1.860919
[NAME] | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME].
2001-05-21 00:00:00 | 0.083229 | 0.07829 | 0.075693 | 0.07797 | 0.086142 | 0.102041 | 0.108398 | 0.106637 | 0.110905 | 0.116105 | 0.118184 | 0.120093 | 0.120663 | 0.122467 | 0.125431 | 0.132883 | 0.142146 | 0.150769 | 0.1628 | 0.18155 | 0.172178 | 0.143499 | 0.112912 | 0.093192
2001-05-22 00:00:00 | 0.08400739621597716 | 0.07872124294148866 | 0.07695651298367398 | 0.07883215429694981 | 0.08874376775483439 | 0.1059468338254195 | 0.1124314094250185 | 0.1072392239722457 | 0.10895100288436 | 0.1117458850701821 | 0.1152999060614703 | 0.1207871141481773 | 0.122502271886867 | 0.125506852743277 | 0.1317907346463577 | 0.1400512246444337 | 0.1494425456475111 | 0.1569661641914478 | 0.166335550530721 | 0.1849395031255963 | 0.1772643315596112 | 0.1477650121326739 | 0.1160418300642663 | 0.09454501747101596
2001-05-23 00:00:00 | 0.091578 | 0.085121 | 0.081026 | 0.081702 | 0.090992 | 0.105943 | 0.112094 | 0.110524 | 0.11436 | 0.120705 | 0.12939 | 0.137918 | 0.144406 | 0.149525 | 0.160256 | 0.167639 | 0.1775 | 0.178536 | 0.178178 | 0.197081 | 0.191757 | 0.162265 | 0.126035 | 0.103716
2001-05-24 00:00:00 | 0.087716 | 0.081986 | 0.078571 | 0.079961 | 0.089145 | 0.105001 | 0.110696 | 0.108181 | 0.111217 | 0.115466 | 0.119778 | 0.126938 | 0.131337 | 0.135682 | 0.141502 | 0.150642 | 0.158982 | 0.162467 | 0.169802 | 0.189482 | 0.183401 | 0.155491 | 0.122626 | 0.100342
2001-05-25 00:00:00 | 0.005903 | 0.005654 | 0.005418 | 0.005514 | 0.005842 | 0.006068 | 0.006469 | 0.006534 | 0.00671 | 0.007005 | 0.007467 | 0.007931 | 0.008434 | 0.008924 | 0.009398 | 0.009648 | 0.009809 | 0.009513 | 0.009376 | 0.010085 | 0.010019 | 0.009136 | 0.007749 | 0.006743
2001-05-26 00:00:00 | 0.006217 | 0.005862 | 0.005572 | 0.005494 | 0.005569 | 0.005599 | 0.006026 | 0.006529 | 0.007089 | 0.007566 | 0.007996 | 0.008473 | 0.008963 | 0.009394 | 0.009769 | 0.010097 | 0.010203 | 0.00986 | 0.009648 | 0.010398 | 0.010194 | 0.009252 | 0.008014 | 0.007024
2001-05-27 00:00:00 | 0.005894 | 0.005575 | 0.005412 | 0.005344 | 0.005354 | 0.005438 | 0.005787 | 0.006476 | 0.006889 | 0.007213 | 0.007385 | 0.007565 | 0.007697 | 0.007835 | 0.008096 | 0.008256 | 0.008264 | 0.008324 | 0.00881 | 0.009869 | 0.009482 | 0.008425 | 0.007029 | 0.006084
SDGE2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | Daily Total | Hrly. [NAME].
2001-05-21 00:00:00 | 41.808355 | 40.9902 | 40.636936 | 40.936702 | 42.22376 | 45.497942 | 48.804316 | 52.401409 | 56.067269 | 58.404986 | 60.529239 | 61.454834 | 62.337841 | 62.974705 | 63.17731 | 62.953741 | 62.370321 | 60.904284 | 58.453834 | 58.000136 | 57.361126 | 54.308358 | 50.434081 | 46.711264
2001-05-22 00:00:00 | 44.36484053941325 | 43.31373692346549 | 42.91584732479555 | 42.91581571774027 | 44.12185963107351 | 47.11954542770168 | 50.51632139989129 | 53.77052790142274 | 57.37110437665035 | 59.82171952036684 | 61.6372482474705 | 62.50507159857224 | 63.53303473513737 | 64.12762261309824 | 64.2832160247867 | 64.23960882576134 | 63.66546901494946 | 62.23466185219763 | 59.82551037933548 | 59.15413870576817 | 58.55502528127848 | 55.29931828016976 | 51.17985526982333 | 47.11597020095929
2001-05-23 00:00:00 | 45.715205 | 44.711817 | 44.308267 | 44.153528 | 45.615166 | 49.263233 | 52.662201 | 55.811784 | 60.084991 | 62.559205 | 65.607987 | 67.070386 | 68.01505 | 68.766304 | 69.475986 | 69.184719 | 68.574741 | 66.840078 | 63.235762 | 62.252721 | 61.598807 | 57.625924 | 52.836983 | 48.919602
2001-05-24 00:00:00 | 46.035054 | 45.186938 | 44.81697 | 44.503884 | 46.048257 | 49.484014 | 52.986583 | 56.166414 | 60.521015 | 62.685479 | 66.039351 | 66.931565 | 67.918164 | 69.014887 | 69.15349 | 68.866015 | 68.221387 | 66.474008 | 62.937138 | 62.204416 | 61.545046 | 57.508262 | 52.827443 | 48.903782
2001-05-25 00:00:00 | 45.827858 | 44.93341 | 44.489991 | 44.410366 | 45.821667 | 49.187162 | 52.608515 | 55.723476 | 59.623157 | 61.568346 | 64.593259 | 65.513555 | 66.319449 | 66.947907 | 67.150641 | 66.605638 | 65.465058 | 63.214508 | 59.331476 | 58.707383 | 58.574098 | 55.477182 | 51.551305 | 48.189798
2001-05-26 00:00:00 | 43.981862 | 43.015632 | 42.634388 | 42.487727 | 43.551255 | 46.262296 | 48.693025 | 50.131543 | 52.091715 | 54.446645 | 56.965401 | 57.539484 | 57.923916 | 58.320114 | 58.296048 | 58.142821 | 57.817549 | 56.552058 | 54.834249 | 54.355826 | 54.233534 | 51.801638 | 48.509539 | 45.46779
2001-05-27 00:00:00 | 42.251632 | 41.288095 | 40.926076 | 40.952043 | 41.922492 | 44.382018 | 46.845927 | 48.307021 | 49.959264 | 51.654204 | 53.613728 | 54.376672 | 55.367757 | 56.40876 | 56.142238 | 56.578542 | 56.375452 | 55.591473 | 54.234132 | 53.481546 | 52.903036 | 50.436554 | 47.491107 | 44.487283