Get documents about "Begin
Document Sample
<======================= 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
