Begin

Document Sample
Begin Powered By Docstoc
					<=======================  CUT NAME    ====================>                               Trade Date
LSEGUNADJ_Q_09_RESLOWR_COAST_NIDR_NWS_NOTOU_D_U1_S03_99_SU1                                10/1/2003

                                                                 Key: QSE,REP,PROFILEcode,LOSScode



  For application of Loss Factors, you must begin with the unadjusted data cut (LSEGUNADJ_). Distribution losses must be
  loss data cut (LSEGDL_). The data necessary for this calculation (and the transmission loss calculation) can be found on t
  The file that was needed for this example is copied under the tab named "DLF". Other information that will be needed (TDS
  the cut name itself, as shown by the key above. In our example, the TDSPcode is 99 (which equates to a fictitious TDSP n
  "D". Armed with this data, we'll be able to proceed to the tab named "ApplyDLF", to see how this information is used.

  NOTE: If the LOSScode is "T", no distribution losses will be applied, and the LSEGUNADJ_ cut will be copied and renamed
  losses added to the unadjusted cut. This is what essentially happens when a loss factor of zero is applied using the formula
                     0:15       0:30        0:45        1:00       1:15        1:30        1:45      2:00      2:15
                  0.1238     0.1238      0.1238      0.1237     0.1237      0.1237      0.1237    0.1236    0.1236

          LOSScode,UFEzone,CMzone,TDSP,SubUFEzone



ADJ_). Distribution losses must be applied first, which will produce the distribution
  loss calculation) can be found on the ERCOT portal, under Public Information.
 nformation that will be needed (TDSP, and LOSScode) can be found embedded in
which equates to a fictitious TDSP named "example TDSP") and the loss code is
  how this information is used.

DJ_ cut will be copied and renamed to LSEGDL_, reflecting zero distribution
of zero is applied using the formulas.
   2:30      2:45      3:00      3:15      3:30      3:45      4:00      4:15      4:30
0.1236    0.1236    0.1236    0.1236    0.1236    0.1235    0.1235    0.1235    0.1235
   4:45      5:00      5:15      5:30      5:45      6:00      6:15      6:30      6:45
0.1235    0.1235    0.1236    0.1236    0.1236    0.1236    0.1236    0.1236    0.1237
   7:00      7:15      7:30      7:45      8:00      8:15      8:30      8:45      9:00
0.1237    0.1237    0.1237    0.1237    0.1236    0.1236    0.1236    0.1236    0.1236
   9:15      9:30      9:45    10:00    10:15    10:30    10:45    11:00    11:15
0.1236    0.1236    0.1236    0.1236   0.1236   0.1236   0.1236   0.1236   0.1236
 11:30    11:45    12:00    12:15    12:30    12:45    13:00    13:15    13:30
0.1237   0.1237   0.1237   0.1237   0.1237   0.1238   0.1238   0.1238   0.1238
 13:45    14:00    14:15    14:30    14:45    15:00    15:15    15:30    15:45
0.1239   0.1239   0.1239   0.1240   0.1240   0.1240   0.1240   0.1241   0.1241
 16:00    16:15    16:30    16:45    17:00    17:15    17:30    17:45    18:00
0.1242   0.1242   0.1243   0.1243   0.1243   0.1243   0.1244   0.1244   0.1244
 18:15    18:30    18:45    19:00    19:15    19:30    19:45    20:00    20:15
0.1244   0.1244   0.1244   0.1244   0.1244   0.1244   0.1244   0.1244   0.1244
 20:30    20:45    21:00    21:15    21:30    21:45    22:00    22:15    22:30
0.1244   0.1244   0.1244   0.1244   0.1243   0.1243   0.1243   0.1243   0.1242
 22:45    23:00    23:15    23:30    23:45   24:00:00
0.1241   0.1241   0.1240   0.1240   0.1239     0.1239
CUTNAME                                                   START TIME     STOP TIME
FORECASTED LOAD                                              2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
CENTERPOINT ENERGY HOUSTON ELECTRIC LLC (TDSP)_DLF_LC_D      2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
SHARYLAND UTILITIES LP (TDSP)_DLF_LC_A                       2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
example (TDSP)_DLF_LC_D                                      2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
ONCOR ELECTRIC DELIVERY COMPANY_DLF_LC_A                     2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
ONCOR ELECTRIC DELIVERY COMPANY_DLF_LC_B                     2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
TEXAS-NEW MEXICO POWER CO (TDSP)_DLF_LC_A                    2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
TEXAS-NEW MEXICO POWER CO (TDSP)_DLF_LC_B                    2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
TEXAS-NEW MEXICO POWER CO (TDSP)_DLF_LC_C                    2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
TEXAS-NEW MEXICO POWER CO (TDSP)_DLF_LC_D                    2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
TEXAS-NEW MEXICO POWER CO (TDSP)_DLF_LC_E                    2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
AEP TEXAS CENTRAL COMPANY_DLF_LC_A                           2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
AEP TEXAS CENTRAL COMPANY_DLF_LC_B                           2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
AEP TEXAS NORTH COMPANY_DLF_LC_A                             2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
AEP TEXAS NORTH COMPANY_DLF_LC_B                             2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
TXU SESCO CO (TDSP)_DLF_LC_A                                 2/21/2004    2/21/2004 23:59
CUTNAME                                                   START TIME     STOP TIME
TXU SESCO CO (TDSP)_DLF_LC_B                                 2/21/2004    2/21/2004 23:59
        1:00           2:00           3:00           4:00           5:00           6:00           7:00
      23880          23521          23527          23768          24315          25319          26808
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.032493954    0.032493954    0.032493954    0.032493954    0.032429315    0.032429315    0.032429315
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.087801852    0.087801852    0.087801852    0.087801852    0.086913385    0.086913385    0.086913385
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.012108119    0.012108119    0.012108119    0.012108119    0.011967764    0.011967764    0.011967764
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.033554937    0.033554937    0.033554937    0.033554937    0.033335569    0.033335569    0.033335569
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.012108119    0.012108119    0.012108119    0.012108119    0.011967764    0.011967764    0.011967764
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.064500942    0.064500942    0.064500942    0.064500942     0.06390407     0.06390407     0.06390407
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.037818065    0.037818065    0.037818065    0.037818065    0.037524643    0.037524643    0.037524643
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.028068695    0.028068695    0.028068695    0.028068695    0.027854178    0.027854178    0.027854178
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.030721631    0.030721631    0.030721631    0.030721631    0.030458206    0.030458206    0.030458206
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.034861516    0.034861516    0.034861516    0.034861516    0.034561419    0.034561419    0.034561419
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.056819689    0.056819689    0.056819689    0.056819689    0.056568333    0.056568333    0.056568333
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.020561452    0.020561452    0.020561452    0.020561452    0.020429426    0.020429426    0.020429426
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.057423501    0.057423501    0.057423501    0.057423501    0.057019967    0.057019967    0.057019967
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.010635672    0.010635672    0.010635672    0.010635672    0.010598394    0.010598394    0.010598394
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.033554937    0.033554937    0.033554937    0.033554937    0.033335569    0.033335569    0.033335569
        0:15           0:30           0:45           1:00           1:15           1:30           1:45
0.012108119    0.012108119    0.012108119    0.012108119    0.011967764    0.011967764    0.011967764
        8:00           9:00          10:00          11:00          12:00          13:00          14:00
      27945          28378          28261          27796          27206          26397          25483
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.032429315    0.032430396    0.032430396    0.032430396    0.032430396    0.032473788    0.032473788
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.086913385    0.086928234    0.086928234    0.086928234    0.086928234     0.08752467     0.08752467
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.011967764     0.01197011     0.01197011     0.01197011     0.01197011    0.012064331    0.012064331
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.033335569    0.033339235    0.033339235    0.033339235    0.033339235    0.033486499    0.033486499
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.011967764     0.01197011     0.01197011     0.01197011     0.01197011    0.012064331    0.012064331
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
 0.06390407    0.063914046    0.063914046    0.063914046    0.063914046    0.064314731    0.064314731
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.037524643    0.037529547    0.037529547    0.037529547    0.037529547    0.037726524    0.037726524
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.027854178    0.027857763    0.027857763    0.027857763    0.027857763    0.028001771    0.028001771
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.030458206    0.030462609    0.030462609    0.030462609    0.030462609    0.030639448    0.030639448
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.034561419    0.034566435    0.034566435    0.034566435    0.034566435    0.034767893    0.034767893
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.056568333    0.056572534    0.056572534    0.056572534    0.056572534    0.056741272    0.056741272
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.020429426    0.020431632    0.020431632    0.020431632    0.020431632    0.020520263    0.020520263
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.057019967    0.057026712    0.057026712    0.057026712    0.057026712    0.057297608    0.057297608
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.010598394    0.010599017    0.010599017    0.010599017    0.010599017    0.010624042    0.010624042
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.033335569    0.033339235    0.033339235    0.033339235    0.033339235    0.033486499    0.033486499
        2:00           2:15           2:30           2:45           3:00           3:15           3:30
0.011967764     0.01197011     0.01197011     0.01197011     0.01197011    0.012064331    0.012064331
       15:00          16:00          17:00          18:00          19:00          20:00          21:00
      24937          24762          24865          25282          27223          28417          28292
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.032473788    0.032473788    0.032572277    0.032572277    0.032572277    0.032572277     0.03275305
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
 0.08752467     0.08752467    0.088878408    0.088878408    0.088878408    0.088878408    0.091363146
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.012064331    0.012064331    0.012278186    0.012278186    0.012278186    0.012278186     0.01267071
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.033486499    0.033486499    0.033820745    0.033820745    0.033820745    0.033820745    0.034434242
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.012064331    0.012064331    0.012278186    0.012278186    0.012278186    0.012278186     0.01267071
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.064314731    0.064314731    0.065224171    0.065224171    0.065224171    0.065224171    0.066893417
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.037726524    0.037726524    0.038173605    0.038173605    0.038173605    0.038173605    0.038994206
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.028001771    0.028001771    0.028328626    0.028328626    0.028328626    0.028328626    0.028928559
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.030639448    0.030639448    0.031040822    0.031040822    0.031040822    0.031040822     0.03177753
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.034767893    0.034767893    0.035225143    0.035225143    0.035225143    0.035225143    0.036064411
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.056741272    0.056741272    0.057124257    0.057124257    0.057124257    0.057124257    0.057827213
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.020520263    0.020520263    0.020721428    0.020721428    0.020721428    0.020721428     0.02109066
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.057297608    0.057297608    0.057912463    0.057912463    0.057912463    0.057912463    0.059041009
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.010624042    0.010624042    0.010680842    0.010680842    0.010680842    0.010680842    0.010785097
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.033486499    0.033486499    0.033820745    0.033820745    0.033820745    0.033820745    0.034434242
        3:45           4:00           4:15           4:30           4:45           5:00           5:15
0.012064331    0.012064331    0.012278186    0.012278186    0.012278186    0.012278186     0.01267071
       22:00          23:00       24:00:00
      27862          26918          25623
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
 0.03275305     0.03275305     0.03275305    0.033021149    0.033021149    0.033021149    0.033021149
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.091363146    0.091363146    0.091363146    0.095048182    0.095048182    0.095048182    0.095048182
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
 0.01267071     0.01267071     0.01267071    0.013252849    0.013252849    0.013252849    0.013252849
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.034434242    0.034434242    0.034434242    0.035344099    0.035344099    0.035344099    0.035344099
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
 0.01267071     0.01267071     0.01267071    0.013252849    0.013252849    0.013252849    0.013252849
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.066893417    0.066893417    0.066893417    0.069369023    0.069369023    0.069369023    0.069369023
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.038994206    0.038994206    0.038994206    0.040211213    0.040211213    0.040211213    0.040211213
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.028928559    0.028928559    0.028928559    0.029818299    0.029818299    0.029818299    0.029818299
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
 0.03177753     0.03177753     0.03177753    0.032870118    0.032870118    0.032870118    0.032870118
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.036064411    0.036064411    0.036064411    0.037309103    0.037309103    0.037309103    0.037309103
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.057827213    0.057827213    0.057827213    0.058869745    0.058869745    0.058869745    0.058869745
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
 0.02109066     0.02109066     0.02109066    0.021638256    0.021638256    0.021638256    0.021638256
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.059041009    0.059041009    0.059041009    0.060714719    0.060714719    0.060714719    0.060714719
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.010785097    0.010785097    0.010785097    0.010939714    0.010939714    0.010939714    0.010939714
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
0.034434242    0.034434242    0.034434242    0.035344099    0.035344099    0.035344099    0.035344099
        5:30           5:45           6:00           6:15           6:30           6:45           7:00
 0.01267071     0.01267071     0.01267071    0.013252849    0.013252849    0.013252849    0.013252849
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.033225869    0.033225869    0.033225869    0.033225869    0.033303832    0.033303832    0.033303832
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.097862074    0.097862074    0.097862074    0.097862074     0.09893368     0.09893368     0.09893368
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
 0.01369737     0.01369737     0.01369737     0.01369737    0.013866656    0.013866656    0.013866656
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.036038866    0.036038866    0.036038866    0.036038866    0.036303452    0.036303452    0.036303452
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
 0.01369737     0.01369737     0.01369737     0.01369737    0.013866656    0.013866656    0.013866656
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.071259395    0.071259395    0.071259395    0.071259395    0.071979299    0.071979299    0.071979299
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
 0.04114052     0.04114052     0.04114052     0.04114052    0.041494424    0.041494424    0.041494424
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.030497704    0.030497704    0.030497704    0.030497704     0.03075644     0.03075644     0.03075644
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.033704418    0.033704418    0.033704418    0.033704418    0.034022142    0.034022142    0.034022142
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.038259549    0.038259549    0.038259549    0.038259549    0.038621504    0.038621504    0.038621504
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.059665822    0.059665822    0.059665822    0.059665822    0.059968989    0.059968989    0.059968989
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.022056401    0.022056401    0.022056401    0.022056401    0.022215641    0.022215641    0.022215641
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.061992763    0.061992763    0.061992763    0.061992763    0.062479477    0.062479477    0.062479477
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.011057779    0.011057779    0.011057779    0.011057779    0.011102742    0.011102742    0.011102742
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
0.036038866    0.036038866    0.036038866    0.036038866    0.036303452    0.036303452    0.036303452
        7:15           7:30           7:45           8:00           8:15           8:30           8:45
 0.01369737     0.01369737     0.01369737     0.01369737    0.013866656    0.013866656    0.013866656
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.033303832    0.033282766    0.033282766    0.033282766    0.033282766    0.033199042    0.033199042
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
 0.09893368    0.098644124    0.098644124    0.098644124    0.098644124    0.097493323    0.097493323
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.013866656    0.013820914    0.013820914    0.013820914    0.013820914    0.013639117    0.013639117
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.036303452    0.036231958    0.036231958    0.036231958    0.036231958    0.035947819    0.035947819
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.013866656    0.013820914    0.013820914    0.013820914    0.013820914    0.013639117    0.013639117
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.071979299    0.071784775    0.071784775    0.071784775    0.071784775    0.071011668    0.071011668
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.041494424    0.041398797    0.041398797    0.041398797    0.041398797    0.041018737    0.041018737
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
 0.03075644    0.030686527    0.030686527    0.030686527    0.030686527     0.03040867     0.03040867
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.034022142    0.033936291    0.033936291    0.033936291    0.033936291    0.033595086    0.033595086
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.038621504    0.038523701    0.038523701    0.038523701    0.038523701    0.038134996    0.038134996
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.059968989    0.059887071    0.059887071    0.059887071    0.059887071    0.059561499    0.059561499
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.022215641    0.022172613    0.022172613    0.022172613    0.022172613    0.022001604    0.022001604
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.062479477    0.062347963    0.062347963    0.062347963    0.062347963     0.06182528     0.06182528
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.011102742    0.011090592    0.011090592    0.011090592    0.011090592    0.011042307    0.011042307
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.036303452    0.036231958    0.036231958    0.036231958    0.036231958    0.035947819    0.035947819
        9:00           9:15           9:30           9:45          10:00          10:15          10:30
0.013866656    0.013820914    0.013820914    0.013820914    0.013820914    0.013639117    0.013639117
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.033199042    0.033199042     0.03309281     0.03309281     0.03309281     0.03309281    0.032947147
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.097493323    0.097493323    0.096033168    0.096033168    0.096033168    0.096033168    0.094031023
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.013639117    0.013639117    0.013408451    0.013408451    0.013408451    0.013408451    0.013092165
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.035947819    0.035947819    0.035587298    0.035587298    0.035587298    0.035587298    0.035092956
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.013639117    0.013639117    0.013408451    0.013408451    0.013408451    0.013408451    0.013092165
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.071011668    0.071011668    0.070030736    0.070030736    0.070030736    0.070030736    0.068685696
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.041018737    0.041018737    0.040536511    0.040536511    0.040536511    0.040536511     0.03987529
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
 0.03040867     0.03040867    0.030056121    0.030056121    0.030056121    0.030056121    0.029572709
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.033595086    0.033595086     0.03316216     0.03316216     0.03316216     0.03316216    0.032568538
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.038134996    0.038134996    0.037641801    0.037641801    0.037641801    0.037641801    0.036965538
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.059561499    0.059561499    0.059148407    0.059148407    0.059148407    0.059148407    0.058581981
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.022001604    0.022001604    0.021784625    0.021784625    0.021784625    0.021784625    0.021487107
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
 0.06182528     0.06182528    0.061162091    0.061162091    0.061162091    0.061162091    0.060252734
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.011042307    0.011042307    0.010981042    0.010981042    0.010981042    0.010981042    0.010897036
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.035947819    0.035947819    0.035587298    0.035587298    0.035587298    0.035587298    0.035092956
       10:45          11:00          11:15          11:30          11:45          12:00          12:15
0.013639117    0.013639117    0.013408451    0.013408451    0.013408451    0.013408451    0.013092165
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.032947147    0.032947147    0.032947147    0.032782579    0.032782579    0.032782579    0.032782579
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.094031023    0.094031023    0.094031023     0.09176902     0.09176902     0.09176902     0.09176902
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.013092165    0.013092165    0.013092165    0.012734827    0.012734827    0.012734827    0.012734827
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.035092956    0.035092956    0.035092956    0.034534454    0.034534454    0.034534454    0.034534454
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.013092165    0.013092165    0.013092165    0.012734827    0.012734827    0.012734827    0.012734827
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.068685696    0.068685696    0.068685696    0.067166083    0.067166083    0.067166083    0.067166083
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
 0.03987529     0.03987529     0.03987529    0.039128249    0.039128249    0.039128249    0.039128249
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.029572709    0.029572709    0.029572709    0.029026555    0.029026555    0.029026555    0.029026555
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.032568538    0.032568538    0.032568538    0.031897869    0.031897869    0.031897869    0.031897869
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.036965538    0.036965538    0.036965538    0.036201503    0.036201503    0.036201503    0.036201503
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.058581981    0.058581981    0.058581981    0.057942039    0.057942039    0.057942039    0.057942039
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.021487107    0.021487107    0.021487107    0.021150973    0.021150973    0.021150973    0.021150973
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.060252734    0.060252734    0.060252734    0.059225353    0.059225353    0.059225353    0.059225353
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.010897036    0.010897036    0.010897036    0.010802127    0.010802127    0.010802127    0.010802127
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.035092956    0.035092956    0.035092956    0.034534454    0.034534454    0.034534454    0.034534454
       12:30          12:45          13:00          13:15          13:30          13:45          14:00
0.013092165    0.013092165    0.013092165    0.012734827    0.012734827    0.012734827    0.012734827
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
 0.03268427     0.03268427     0.03268427     0.03268427    0.032652761    0.032652761    0.032652761
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.090417758    0.090417758    0.090417758    0.090417758    0.089984661    0.089984661    0.089984661
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.012521363    0.012521363    0.012521363    0.012521363    0.012452945    0.012452945    0.012452945
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.034200819    0.034200819    0.034200819    0.034200819    0.034093885    0.034093885    0.034093885
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.012521363    0.012521363    0.012521363    0.012521363    0.012452945    0.012452945    0.012452945
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.066258306    0.066258306    0.066258306    0.066258306    0.065967352    0.065967352    0.065967352
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.038681985    0.038681985    0.038681985    0.038681985    0.038538952    0.038538952    0.038538952
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.028700297    0.028700297    0.028700297    0.028700297    0.028595728    0.028595728    0.028595728
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.031497229    0.031497229    0.031497229    0.031497229    0.031368819    0.031368819    0.031368819
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.035745088    0.035745088    0.035745088    0.035745088    0.035598801    0.035598801    0.035598801
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.057559754    0.057559754    0.057559754    0.057559754    0.057437226    0.057437226    0.057437226
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.020950175    0.020950175    0.020950175    0.020950175    0.020885817    0.020885817    0.020885817
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.058611622    0.058611622    0.058611622    0.058611622    0.058414913    0.058414913    0.058414913
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
 0.01074543     0.01074543     0.01074543     0.01074543    0.010727258    0.010727258    0.010727258
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.034200819    0.034200819    0.034200819    0.034200819    0.034093885    0.034093885    0.034093885
       14:15          14:30          14:45          15:00          15:15          15:30          15:45
0.012521363    0.012521363    0.012521363    0.012521363    0.012452945    0.012452945    0.012452945
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.032652761    0.032671306    0.032671306    0.032671306    0.032671306    0.032746388    0.032746388
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.089984661    0.090239569    0.090239569    0.090239569    0.090239569    0.091271577    0.091271577
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.012452945    0.012493214    0.012493214    0.012493214    0.012493214    0.012656244    0.012656244
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.034093885    0.034156824    0.034156824    0.034156824    0.034156824    0.034411633    0.034411633
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.012452945    0.012493214    0.012493214    0.012493214    0.012493214    0.012656244    0.012656244
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.065967352    0.066138599    0.066138599    0.066138599    0.066138599    0.066831901    0.066831901
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.038538952    0.038623137    0.038623137    0.038623137    0.038623137    0.038963965    0.038963965
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.028595728    0.028657274    0.028657274    0.028657274    0.028657274     0.02890645     0.02890645
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.031368819    0.031444397    0.031444397    0.031444397    0.031444397    0.031750381    0.031750381
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.035598801    0.035684902    0.035684902    0.035684902    0.035684902    0.036033482    0.036033482
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.057437226    0.057509342    0.057509342    0.057509342    0.057509342    0.057801307    0.057801307
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.020885817    0.020923697    0.020923697    0.020923697    0.020923697    0.021077053    0.021077053
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.058414913     0.05853069     0.05853069     0.05853069     0.05853069    0.058999419    0.058999419
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.010727258    0.010737954    0.010737954    0.010737954    0.010737954    0.010781255    0.010781255
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.034093885    0.034156824    0.034156824    0.034156824    0.034156824    0.034411633    0.034411633
       16:00          16:15          16:30          16:45          17:00          17:15          17:30
0.012452945    0.012493214    0.012493214    0.012493214    0.012493214    0.012656244    0.012656244
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.032746388    0.032746388    0.033095871     0.033095871     0.033095871     0.033095871     0.033310854
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.091271577    0.091271577     0.09607524      0.09607524      0.09607524      0.09607524     0.099030199
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.012656244    0.012656244    0.013415097     0.013415097     0.013415097     0.013415097     0.013881903
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.034411633    0.034411633    0.035597686     0.035597686     0.035597686     0.035597686     0.036327283
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.012656244    0.012656244    0.013415097     0.013415097     0.013415097     0.013415097     0.013881903
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.066831901    0.066831901        0.070059        0.070059        0.070059        0.070059     0.07204414
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.038963965    0.038963965    0.040550406     0.040550406     0.040550406     0.040550406        0.0415263
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
 0.02890645     0.02890645    0.030066279     0.030066279     0.030066279     0.030066279     0.030779744
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.031750381    0.031750381    0.033174634     0.033174634     0.033174634     0.033174634     0.034050759
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.036033482    0.036033482    0.037656012     0.037656012     0.037656012     0.037656012     0.038654105
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.057801307    0.057801307     0.05916031      0.05916031      0.05916031      0.05916031     0.059996295
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.021077053    0.021077053    0.021790877     0.021790877     0.021790877     0.021790877     0.022229984
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.058999419    0.058999419       0.0611812       0.0611812       0.0611812       0.0611812    0.062523315
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.010781255    0.010781255    0.010982807     0.010982807     0.010982807     0.010982807     0.011106791
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.034411633    0.034411633    0.035597686     0.035597686     0.035597686     0.035597686     0.036327283
       17:45          18:00           18:15           18:30           18:45           19:00           19:15
0.012656244    0.012656244    0.013415097     0.013415097     0.013415097     0.013415097     0.013881903
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.033310854     0.033310854     0.033310854     0.033288348    0.033288348    0.033288348    0.033288348
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.099030199     0.099030199     0.099030199     0.098720844    0.098720844    0.098720844    0.098720844
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.013881903     0.013881903     0.013881903     0.013833033    0.013833033    0.013833033    0.013833033
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.036327283     0.036327283     0.036327283     0.036250901    0.036250901    0.036250901    0.036250901
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.013881903     0.013881903     0.013881903     0.013833033    0.013833033    0.013833033    0.013833033
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
 0.07204414      0.07204414      0.07204414     0.071836315    0.071836315    0.071836315    0.071836315
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
   0.0415263       0.0415263       0.0415263    0.041424134    0.041424134    0.041424134    0.041424134
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.030779744     0.030779744     0.030779744     0.030705051    0.030705051    0.030705051    0.030705051
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.034050759     0.034050759     0.034050759     0.033959038    0.033959038    0.033959038    0.033959038
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.038654105     0.038654105     0.038654105     0.038549615    0.038549615    0.038549615    0.038549615
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.059996295     0.059996295     0.059996295     0.059908776    0.059908776    0.059908776    0.059908776
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.022229984     0.022229984     0.022229984     0.022184014    0.022184014    0.022184014    0.022184014
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.062523315     0.062523315     0.062523315     0.062382809    0.062382809    0.062382809    0.062382809
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.011106791     0.011106791     0.011106791     0.011093812    0.011093812    0.011093812    0.011093812
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.036327283     0.036327283     0.036327283     0.036250901    0.036250901    0.036250901    0.036250901
        19:30           19:45           20:00          20:15          20:30          20:45          21:00
0.013881903     0.013881903     0.013881903     0.013833033    0.013833033    0.013833033    0.013833033
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.033210925    0.033210925    0.033210925    0.033210925    0.033040955    0.033040955    0.033040955
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.097656663    0.097656663    0.097656663    0.097656663    0.095320414    0.095320414    0.095320414
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.013664921    0.013664921    0.013664921    0.013664921    0.013295855    0.013295855    0.013295855
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.035988148    0.035988148    0.035988148    0.035988148    0.035411315    0.035411315    0.035411315
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.013664921    0.013664921    0.013664921    0.013664921    0.013295855    0.013295855    0.013295855
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.071121399    0.071121399    0.071121399    0.071121399    0.069551908    0.069551908    0.069551908
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.041072681    0.041072681    0.041072681    0.041072681     0.04030112     0.04030112     0.04030112
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.030448108    0.030448108    0.030448108    0.030448108    0.029884028    0.029884028    0.029884028
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.033643515    0.033643515    0.033643515    0.033643515    0.032950833    0.032950833    0.032950833
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.038190167    0.038190167    0.038190167    0.038190167    0.037401055    0.037401055    0.037401055
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.059607709    0.059607709    0.059607709    0.059607709    0.058946762    0.058946762    0.058946762
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.022025876    0.022025876    0.022025876    0.022025876     0.02167871     0.02167871     0.02167871
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.061899467    0.061899467    0.061899467    0.061899467    0.060838364    0.060838364    0.060838364
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.011049161    0.011049161    0.011049161    0.011049161    0.010951136    0.010951136    0.010951136
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.035988148    0.035988148    0.035988148    0.035988148    0.035411315    0.035411315    0.035411315
       21:15          21:30          21:45          22:00          22:15          22:30          22:45
0.013664921    0.013664921    0.013664921    0.013664921    0.013295855    0.013295855    0.013295855
       23:00          23:15          23:30          23:45       24:00:00
0.033040955    0.032807787    0.032807787    0.032807787    0.032807787
       23:00          23:15          23:30          23:45       24:00:00
0.095320414    0.092115497    0.092115497    0.092115497    0.092115497
       23:00          23:15          23:30          23:45       24:00:00
0.013295855    0.012789562    0.012789562    0.012789562    0.012789562
       23:00          23:15          23:30          23:45       24:00:00
0.035411315    0.034620002    0.034620002    0.034620002    0.034620002
       23:00          23:15          23:30          23:45       24:00:00
0.013295855    0.012789562    0.012789562    0.012789562    0.012789562
       23:00          23:15          23:30          23:45       24:00:00
0.069551908    0.067398847    0.067398847    0.067398847    0.067398847
       23:00          23:15          23:30          23:45       24:00:00
 0.04030112    0.039242675    0.039242675    0.039242675    0.039242675
       23:00          23:15          23:30          23:45       24:00:00
0.029884028    0.029110211    0.029110211    0.029110211    0.029110211
       23:00          23:15          23:30          23:45       24:00:00
0.032950833    0.032000597    0.032000597    0.032000597    0.032000597
       23:00          23:15          23:30          23:45       24:00:00
0.037401055    0.036318532    0.036318532    0.036318532    0.036318532
       23:00          23:15          23:30          23:45       24:00:00
0.058946762     0.05804006     0.05804006     0.05804006     0.05804006
       23:00          23:15          23:30          23:45       24:00:00
 0.02167871    0.021202459    0.021202459    0.021202459    0.021202459
       23:00          23:15          23:30          23:45       24:00:00
0.060838364     0.05938272     0.05938272     0.05938272     0.05938272
       23:00          23:15          23:30          23:45       24:00:00
0.010951136    0.010816664    0.010816664    0.010816664    0.010816664
       23:00          23:15          23:30          23:45       24:00:00
0.035411315    0.034620002    0.034620002    0.034620002    0.034620002
       23:00          23:15          23:30          23:45       24:00:00
0.013295855    0.012789562    0.012789562    0.012789562    0.012789562
LSEGUNADJ_Q_09_RESLOWR_COAST_NIDR_NWS_NOTOU_D_U1_S03_99_SU1                                10/1/2003
Loss factors found on Tab "DLF" example (TDSP)_DLF_LC_D                                    10/1/2003
LSEGDL_Q_09_RESLOWR_COAST_NIDR_NWS_NOTOU_D_U1_S03_99


 THE FORMULA:       The interval values displayed above as loss factors must first be put through the following formula that ca

 DLOSSadjustedLOAD = unadjustedLOAD * [ 1 / (1 - Dlossfactor)]; for the first interval this would equate to LSEGDL

 This formula has been incorporated into the cells on row 8 above, producing the resulting LSEGDL cut, or Distribution Loss A
 characteristics found in the LSEGUNADJ_ cut remain in the LSEGDL cut, except for the last element, SubUFEZone. The re
 prior to saving to the database. The loss factors are not rounded, although for display purposes in this sheet they appear t
 DA6 , you will see the factor displayed to 15 digits in the edit window.

 These calculations must be performed on every LSEGUNADJ cut. If the cut is identified as one that does not need to be adju
 distribution loss factor would be zero. By plugging zero into the above formula, it's obvious that the LSEGDL_ cut would be e
 This resultant cut will be used in the application of transmission losses, found on the Tab named "ApplyTLF".
                     0:15     0:30     0:45     1:00     1:15     1:30     1:45     2:00       2:15
                  0.1238   0.1238   0.1238   0.1237   0.1237   0.1237   0.1237   0.1236     0.1236
               0.012108 0.012108 0.012108 0.012108 0.011968 0.011968 0.011968 0.011968     0.01197
                  0.1253   0.1253   0.1253   0.1252   0.1252   0.1252   0.1252   0.1251     0.1251


 through the following formula that calculates the actua l losses per interval:

rval this would equate to LSEGDL = . 1238 * [ 1 / (1 - .012108118885449)]

g LSEGDL cut, or Distribution Loss Adjusted Load Cut. Notice that all of the other
 last element, SubUFEZone. The resulting values are rounded to four decimals
urposes in this sheet they appear t o be rounded. By selecting any cell, J6 through


 as one that does not need to be adjuste d for distribution losses (loss code T), its
us that the LSEGDL_ cut would be e qual to the LSEGUNADJ_ cut.
b named "ApplyTLF".
    2:30       2:45       3:00      3:15     3:30     3:45     4:00     4:15     4:30
 0.1236     0.1236     0.1236    0.1236   0.1236   0.1235   0.1235   0.1235   0.1235
0.01197    0.01197    0.01197 0.012064 0.012064 0.012064 0.012064 0.012278 0.012278
 0.1251     0.1251     0.1251    0.1251   0.1251    0.125    0.125    0.125    0.125
      4:45     5:00     5:15     5:30     5:45     6:00     6:15     6:30     6:45
   0.1235   0.1235   0.1236   0.1236   0.1236   0.1236   0.1236   0.1236   0.1237
0.012278 0.012278 0.012671 0.012671 0.012671 0.012671 0.013253 0.013253 0.013253
    0.125    0.125   0.1252   0.1252   0.1252   0.1252   0.1253   0.1253   0.1254
      7:00     7:15     7:30     7:45     8:00     8:15     8:30     8:45     9:00
   0.1237   0.1237   0.1237   0.1237   0.1236   0.1236   0.1236   0.1236   0.1236
0.013253 0.013697 0.013697 0.013697 0.013697 0.013867 0.013867 0.013867 0.013867
   0.1254   0.1254   0.1254   0.1254   0.1253   0.1253   0.1253   0.1253   0.1253
      9:15     9:30     9:45   10:00    10:15    10:30    10:45    11:00    11:15
   0.1236   0.1236   0.1236   0.1236   0.1236   0.1236   0.1236   0.1236   0.1236
0.013821 0.013821 0.013821 0.013821 0.013639 0.013639 0.013639 0.013639 0.013408
   0.1253   0.1253   0.1253   0.1253   0.1253   0.1253   0.1253   0.1253   0.1253
    11:30    11:45    12:00    12:15    12:30    12:45    13:00    13:15    13:30
   0.1237   0.1237   0.1237   0.1237   0.1237   0.1238   0.1238   0.1238   0.1238
0.013408 0.013408 0.013408 0.013092 0.013092 0.013092 0.013092 0.012735 0.012735
   0.1254   0.1254   0.1254   0.1253   0.1253   0.1254   0.1254   0.1254   0.1254
    13:45    14:00    14:15    14:30    14:45    15:00    15:15    15:30    15:45
   0.1239   0.1239   0.1239   0.1240   0.1240   0.1240   0.1240   0.1241   0.1241
0.012735 0.012735 0.012521 0.012521 0.012521 0.012521 0.012453 0.012453 0.012453
   0.1255   0.1255   0.1255   0.1256   0.1256   0.1256   0.1256   0.1257   0.1257
    16:00    16:15    16:30    16:45    17:00    17:15    17:30    17:45    18:00
   0.1242   0.1242   0.1243   0.1243   0.1243   0.1243   0.1244   0.1244   0.1244
0.012453 0.012493 0.012493 0.012493 0.012493 0.012656 0.012656 0.012656 0.012656
   0.1258   0.1258   0.1259   0.1259   0.1259   0.1259    0.126    0.126    0.126
    18:15    18:30    18:45    19:00    19:15    19:30    19:45    20:00    20:15
   0.1244   0.1244   0.1244   0.1244   0.1244   0.1244   0.1244   0.1244   0.1244
0.013415 0.013415 0.013415 0.013415 0.013882 0.013882 0.013882 0.013882 0.013833
   0.1261   0.1261   0.1261   0.1261   0.1262   0.1262   0.1262   0.1262   0.1261
    20:30    20:45    21:00    21:15    21:30    21:45    22:00    22:15    22:30
   0.1244   0.1244   0.1244   0.1244   0.1243   0.1243   0.1243   0.1243   0.1242
0.013833 0.013833 0.013833 0.013665 0.013665 0.013665 0.013665 0.013296 0.013296
   0.1261   0.1261   0.1261   0.1261    0.126    0.126    0.126    0.126   0.1259
    22:45    23:00      23:15      23:30      23:45   24:00:00
   0.1241   0.1241    0.1240     0.1240     0.1239      0.1239
0.013296 0.013296    0.01279    0.01279    0.01279     0.01279
   0.1258   0.1258    0.1256     0.1256     0.1255      0.1255
CUTNAME       START TIME     STOP TIME                0:15        0:30       0:45        1:00
ACTUAL LOAD      10/1/2003    10/1/2003 23:59       22325       21993      21743       21667
CUTNAME       START TIME     STOP TIME                0:15        0:30       0:45        1:00
TLF ACTUAL       10/1/2003    10/1/2003 23:59 0.018862336 0.018826754 0.01879996 0.018791815
        1:15        1:30        1:45        2:00        2:15        2:30        2:45
      21480       21425       21233       21161       21140       21204       21208
        1:15        1:30        1:45        2:00        2:15        2:30        2:45
0.018771773 0.018765879 0.018745301 0.018737585 0.018735334 0.018742193 0.018742622
        3:00        3:15        3:30        3:45        4:00        4:15        4:30
      21149       21288       21314       21308       21456       21725       21932
        3:00        3:15        3:30        3:45        4:00        4:15        4:30
0.018736298 0.018751196 0.018753982 0.018753339 0.018769201 0.018798031 0.018820216
        4:45        5:00        5:15        5:30        5:45        6:00        6:15
      22163       22514       23303       23872       24610       25420       26596
        4:45        5:00        5:15        5:30        5:45        6:00        6:15
0.018844974 0.018882592 0.018967153 0.019028136 0.019107231 0.019194043 0.019320081
        6:30        6:45        7:00        7:15        7:30        7:45          8:00
      27764       28662       29233       29619       29582       29265         28936
        6:30        6:45        7:00        7:15        7:30        7:45          8:00
0.019445261 0.019541504 0.019602701 0.019644071 0.019640105 0.019606131    0.01957087
        8:15          8:30        8:45        9:00        9:15        9:30        9:45
      28952         28961       28898       28878       29008       23974       29192
        8:15          8:30        8:45        9:00        9:15        9:30        9:45
0.019572585    0.01957355 0.019566798 0.019564654 0.019578587 0.019039068 0.019598307
       10:00       10:15       10:30       10:45       11:00     11:15       11:30
      29202       29195       29260       29409       29483     29428       29458
       10:00       10:15       10:30       10:45       11:00     11:15       11:30
0.019599379 0.019598629 0.019605595 0.019621564 0.019629495 0.0196236 0.019626816
       11:45       12:00       12:15       12:30       12:45       13:00       13:15
      29383       29347       29243       29280       29253       29262       29305
       11:45       12:00       12:15       12:30       12:45       13:00       13:15
0.019618777 0.019614919 0.019603773 0.019607738 0.019604845 0.019605809 0.019610418
       13:30       13:45       14:00       14:15       14:30       14:45       15:00
      29050       29158       29109       29176       29121       28967       28944
       13:30       13:45       14:00       14:15       14:30       14:45       15:00
0.019583088 0.019594663 0.019589411 0.019596592 0.019590698 0.019574193 0.019571728
       15:15       15:30       15:45       16:00         16:15       16:30       16:45
      28867       28790       28788       28748         28766       28796       28878
       15:15       15:30       15:45       16:00         16:15       16:30       16:45
0.019563475 0.019555223 0.019555008 0.019550721    0.01955265 0.019555866 0.019564654
       17:00       17:15       17:30       17:45       18:00       18:15       18:30
      28941       29088       29670       30578       31488       31815       31974
       17:00       17:15       17:30       17:45       18:00       18:15       18:30
0.019571406 0.019587161 0.019649537 0.019746852 0.019844381 0.019879427 0.019896468
       18:45       19:00       19:15       19:30       19:45         20:00       20:15
      32004       31916       31712       31592       31461         31283       31122
       18:45       19:00       19:15       19:30       19:45         20:00       20:15
0.019899683 0.019890252 0.019868388 0.019855527 0.019841487    0.01982241 0.019805155
       20:30       20:45     21:00       21:15       21:30      21:45       22:00
      31025       30840     30529       30208       29780      29113       28567
       20:30       20:45     21:00       21:15       21:30      21:45       22:00
0.019794759 0.019774931 0.0197416 0.019707197 0.019661326 0.01958984 0.019531323
       22:15       22:30       22:45       23:00       23:15       23:30       23:45
      27983       27413       26690       25960       25178       24629       24089
       22:15       22:30       22:45       23:00       23:15       23:30       23:45
0.019468732 0.019407643 0.019330155 0.019251917 0.019168107 0.019109267 0.019051393
        0:00
      23564
        0:00
0.018995126
Data cut produced from previous step, ApplyDLF. Distribution Loss Adjusted Load or DLA_LOAD.
                                                                                    TradeDate       0:15
LSEGDL_Q_09_RESLOWR_COAST_NIDR_NWS_NOTOU_D_U1_S03_99                                10/1/2003    0.1413
                                              TLF ACTUAL                            10/1/2003 0.018862
LSEGTL_Q_09_RESLOWR_COAST_NIDR_NWS_NOTOU_D_U1_S03_99                                             0.1440


  THE FORMULA:       The interval values displayed above as loss factors must first be put through the following formula that c
  interval:

    TLOSSadjustedLOAD = DLA_LOAD * ( 1 / 1 - Tlossfactor); for the first interval this would equate to LSEGTL = .

  This formula has been incorporated into the cells on row 6 above, producing the resulting LSEGTL cut, or Transmission Los
  Notice, again, that all of the other characteristics found in the LSEGDL_ cut remain in the LSEGTL cut. These calculations
  cut. The losscode and TDSP code is not relevant to this process, since this factor is applied to all non-exempt load, ERCOT
  This resultant cut will be used in the allocation of UFE, or Unaccounted For Energy, which will be explained on another spre
                    0:30        0:45      1:00     1:15     1:30     1:45     2:00     2:15     2:30
                 0.1223      0.1223    0.1222   0.1222   0.1222   0.1222   0.1221   0.1221   0.1221
              0.018827       0.0188 0.018792 0.018772 0.018766 0.018745 0.018738 0.018735 0.018742
                 0.1246      0.1246    0.1245   0.1245   0.1245   0.1245   0.1244   0.1244   0.1244


ugh the following formula that calculates the actua l losses per


would equate to LSEGTL = .1413 * ( 1 / 1 - .0.018862336257)

SEGTL cut, or Transmission Loss Adjusted Load Cut.
  EGTL cut. These calculations m ust be performed on every LSEGDL
             exempt load, ERCOT wide.
 ill be explained on another sprea dsheet.
      2:45     3:00     3:15     3:30     3:45     4:00     4:15       4:30      4:45
   0.1221   0.1221   0.1221   0.1221    0.122    0.122    0.122       0.122    0.122
0.018743 0.018736 0.018751 0.018754 0.018753 0.018769 0.018798     0.01882 0.018845
   0.1244   0.1244   0.1244   0.1244   0.1243   0.1243   0.1243     0.1243    0.1243
      5:00     5:15     5:30     5:45     6:00       6:15      6:30     6:45     7:00
    0.122    0.122    0.122    0.122    0.122       0.122    0.122   0.1221   0.1221
0.018883 0.018967 0.019028 0.019107 0.019194     0.01932 0.019445 0.019542 0.019603
   0.1243   0.1244   0.1244   0.1244   0.1244     0.1244    0.1244   0.1245   0.1245
      7:15       7:30      7:45     8:00     8:15     8:30     8:45     9:00     9:15
    0.122       0.122    0.122   0.1219   0.1219   0.1219   0.1219   0.1219   0.1219
0.019644     0.01964 0.019606 0.019571 0.019573 0.019574 0.019567 0.019565 0.019579
   0.1244     0.1244    0.1244   0.1243   0.1243   0.1243   0.1243   0.1243   0.1243
      9:30     9:45   10:00    10:15    10:30    10:45    11:00    11:15    11:30
   0.1219   0.1219   0.1219   0.1219   0.1219   0.1219   0.1219   0.1219    0.122
0.019039 0.019598 0.019599 0.019599 0.019606 0.019622 0.019629 0.019624 0.019627
   0.1243   0.1243   0.1243   0.1243   0.1243   0.1243   0.1243   0.1243   0.1244
    11:45    12:00    12:15    12:30    12:45    13:00      13:15    13:30    13:45
    0.122    0.122   0.1221   0.1221   0.1222   0.1222    0.1222    0.1222   0.1223
0.019619 0.019615 0.019604 0.019608 0.019605 0.019606    0.01961 0.019583 0.019595
   0.1244   0.1244   0.1245   0.1245   0.1246   0.1246    0.1246    0.1246   0.1247
    14:00    14:15    14:30    14:45    15:00    15:15    15:30    15:45    16:00
   0.1223   0.1223   0.1224   0.1224   0.1224   0.1225   0.1226   0.1226   0.1227
0.019589 0.019597 0.019591 0.019574 0.019572 0.019563 0.019555 0.019555 0.019551
   0.1247   0.1247   0.1248   0.1248   0.1248   0.1249    0.125    0.125   0.1251
    16:15    16:30    16:45    17:00    17:15      17:30    17:45    18:00    18:15
   0.1226   0.1227   0.1227   0.1227   0.1227    0.1228    0.1228   0.1228   0.1227
0.019553 0.019556 0.019565 0.019571 0.019587    0.01965 0.019747 0.019844 0.019879
    0.125   0.1251   0.1251   0.1251   0.1252    0.1253    0.1253   0.1253   0.1252
    18:30    18:45      19:00    19:15    19:30    19:45    20:00    20:15    20:30
   0.1227   0.1227    0.1227    0.1227   0.1227   0.1227   0.1227   0.1227   0.1227
0.019896    0.0199   0.01989 0.019868 0.019856 0.019841 0.019822 0.019805 0.019795
   0.1252   0.1252    0.1252    0.1252   0.1252   0.1252   0.1252   0.1252   0.1252
    20:45    21:00    21:15    21:30      21:45    22:00    22:15    22:30      22:45
   0.1227   0.1227   0.1227   0.1226    0.1226    0.1226   0.1226   0.1225    0.1224
0.019775 0.019742 0.019707 0.019661    0.01959 0.019531 0.019469 0.019408    0.01933
   0.1252   0.1252   0.1252   0.1251      0.125    0.125    0.125   0.1249    0.1248
    23:00    23:15    23:30    23:45 24:00:00
   0.1224   0.1224   0.1224   0.1223   0.1223
0.019252 0.019168 0.019109 0.019051 0.018995
   0.1248   0.1248   0.1248   0.1247   0.1247

				
DOCUMENT INFO