Views:
  1. Open the excel transmission statement and navigate to the summary tab and highlight all cells (Ctrl-A) and apply the excel filter.
  2. Insert this formula into column L row 2
         =IF(OR(AND(G2="OISR",K2="NERCID"),AND(G2="Invoice",B2="NERCID")),I2,IF(G2="Invoice/OISR",0,(0-I2) +ABS(J2)))
  3. Change NERCID to your assigned NERCID
  4. Copy formula down to all rows on the summary sheet.
  5. Set Invoice/OISR filter to “Invoice/OISR”.   The Invoice/OISR lines per settlement must be the absolute value of the sum of individual settlement distributions. For example, if the TS1 settlement has 4 “Invoice/OISR” lines, you must add the distribution amounts together and then take absolute value of that sum.  This can be accomplished using this formula:
    =ABS(SUM(TS1_Distribution1, TS1_Distribution2,TS1_Distribution3, TS1_Distribution4))   
  6. After doing step 5 for each settlement (TS0,TS1,R2,R3,TS4,R5…..), Sum these absolute values together.  This value is called the “Invoice/OISR total value”
  7. Set Invoice/OISR filter to “OISR”
  8. Sum of column L plus the “Invoice/OISR total value” should match the OISR report total.
  9.  If Interest is applicable, add the sum of column J to the total from step 8. 
Keywords: Transmission Settlements