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))
  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 foreach 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.
Keywords: Transmission Settlements