Systrends Updates

Last Chance to Sign Up for the eTariff Conference 2018

Systrends News Bites - Tue, 01/23/2018 - 09:27
Registrations are due for the eTariff conference. Rooms at the Embassy are only available until February 9th.  Don't miss out on extensive training and discussions about eTariff!! Email for more information  Forums: Systrends News


Systrends News Bites - Thu, 10/26/2017 - 09:18

Take notice that on December 5, 2017, staff of the Federal Energy Regulatory Commission (Commission) will hold an Electric Quarterly Report (EQR) Users Group meeting. The meeting will take place from 1:00 p.m. to 5:00 p.m. (EST) in the Commission Meeting Room at 888 First Street, NE, Washington, DC 20426. All interested persons are invited to attend. For those unable to attend in person, access to the meeting will be available via webcast. 


Register online at  Forums: Systrends News

FERC Notice Regarding Headers & Footers in Documents

Systrends News Bites - Wed, 09/13/2017 - 07:57

Take notice that the Commission’s electronic tariff system (eTariff) does not reproduce footnotes, headers, or footers in the Real-Text-Format (RTF) tariff text posted on the Commission’s website ([1]  To the extent footnotes, headers or footers are needed in tariff text, filers should enter them separately in the body of the document on each page where needed rather than by using automatic features of the word processing program.


[1] This applies to footnotes created programmatically by the word processing software, such as the Insert Footnote Tool in Microsoft Word, and text added to the header or footer areas of a document, such as using the Insert Header or Footer Tool in Microsoft Word or clicking in the header or footer areas of the document.  

Forums: Systrends News

eTariff User Conference 2018

Systrends News Bites - Tue, 08/29/2017 - 12:06
AttachmentSize eTariff Conference 2018.pdf765.8 KB

Save the date - March 6 - 8, 2018 will be the next eTariff User Conference.

There are great things planned for this conference including a training for all level users and a tour of Palo Verde Nuclear Plant.

The three day conference will cover everything you ever wanted to know about the eTariff software from Systrends.

For more information download the conference itinerary and registration form here


Any questions - email


Forums: Systrends News

EQR Servers will be down June 5th

Systrends News Bites - Mon, 06/05/2017 - 13:05
All EQR servers will be down for maintenance after 5PM Pacific on June 5, 2017 They will be back up and running the morning of June 6th We apologize for any inconvenience.    Forums: Systrends News

eTariff 2.7.2 Update is now avaliable

Systrends News Bites - Mon, 06/05/2017 - 13:03

eTariff version 2.7.2 was just released to all hosted customers

Some of the enhancements/fixes in this release include

  • Filing Type dropdown is now in numerical order based on filing code
  • Staying on current section that was just edited (and saved) – rather than taking the user back to the top section in the outline box
  • Dockets are now linked inside the filing
  • Adding multiple related dockets and orders
  • Metadata report is now sorted by collation value
  • CEII Report now lists filings that contain both CEII and/or Privileged documents
  • NEW Reports – the reports have been enhanced in this version. You will see a whole new look and feel
  • New Enhancement of allowing access to CEII document based on company and user name – see Admin Tab > Security > User Administration on how that is set up

Release notes for this version have been attached for your reference and will also be able to be found in the Help Tab > Release notes

Forums: Systrends News

eTariff Version 2.7.1 has a Help Guide :)

Systrends News Bites - Wed, 05/17/2017 - 09:52

In the Help Tab you will find a PDF of a User Guide that you can download, save and print.

If you have a question about how to do something or need to train a new user, this guide will come in very handy.  Don't forget about the videos on the dashboard page as well. They provide great step by step instructions on common procedures in eTariff


Forums: Systrends News

New eTariff Reports Coming in Next Release

Systrends News Bites - Thu, 05/11/2017 - 11:03

I had the opportunity to take a speak peak the new version of eTariff that will be coming out soon. I was reviewing the changes done to the report tab and I am thinking all users are going to enjoy the new format, ease, and comfort of the new style.

I can't wait until everyone can see and use the new reports!

Update coming soon on when 2.7.2 eTariff will be available.


Forums: Systrends News

Filing 5 or 15 Min Increments prior to Q1

Systrends News Bites - Mon, 04/17/2017 - 09:44

If you are re-filing a quarter prior to Q1 you cannot use 5 and 15 min interval in the increment name. You can keep the begin and end date to that but  increment should set to hourly. Systrends EQR software will throw an error if you use 5 or 15 min interval in the increment column for a quarter prior to Q1

If you have any questions please contact us.


Forums: Systrends News

Notice of Electric Quarterly Report Users Group Meeting

Systrends News Bites - Mon, 04/17/2017 - 07:26
Take notice that on May 16, 2017, staff of the Federal Energy Regulatory
Commission (Commission) will hold an Electric Quarterly Report (EQR) Users Group
meeting. The meeting will take place from 1:00 p.m. to 5:00 p.m. (EST), in the
Commission Meeting Room at 888 First Street, NE, Washington, DC 20426. All
interested persons are invited to attend. For those unable to attend in person, access to
the meeting will be available via webcast.   This meeting will provide a forum for dialogue between Commission staff and
EQR users to discuss potential improvements to the EQR program and the EQR filing process.
Please note that matters pending before the Commission and subject to ex parte limitations
cannot be discussed at this meeting. An agenda of the meeting will be provided in a subsequent
  Due to the nature of the discussion, those interested in actively participating in the
discussion are encouraged to attend in person. All interested persons (whether attending
in person or via webcast) are asked to register online at
registration/05-16-17-form.asp. There is no registration fee. Anyone with Internet
access who wants to listen to the meeting can do so by navigating to’s
Calendar of Events, locating the EQR Users Group Meeting on the Calendar, and
clicking on the link to the webcast. The webcast will allow persons to listen to the
technical conference and they can email questions during the meeting to Forums: Systrends News

Systrends will be hosting an eTariff Conference March 8 & 9, 2017

Systrends News Bites - Thu, 10/27/2016 - 08:19

March 9 and 10, 2017
Embassy Suites Hotel
Tempe, Arizona

Our upcoming Systrends eTariff conference is the best way to obtain leading knowledge of eTariff software and FERC Viewer; and also offers an opportunity to network with like-minded colleagues in the industry.

From beginners to seasoned users, there is something for everyone to learn. Topics include information on:

  • eTariff Releases,
  • Current and Future Enhancements, and
  • How-To Procedures.

Our two-day conference format is designed to help users gain a better understanding of all aspects of eTariff software. The conference will offer an in-depth look at eTariff features including ones you may not have known were available.

We hope to see you in March!

Click Here to see agenda and conference registration form.

Forums: Systrends News

New EQR Validation Process!

Systrends News Bites - Tue, 10/04/2016 - 10:18

Now User can choose between two options to validate and save the Data in eFileEQR.

1. Online Data Process

2. Background Data Process

User Can Select the checkbox for any one process through which they want to validate and save the data.

Online Data process:

This process is the same as it has been where it will validate and show warnings on the screen and users need to export the validation report.. 


  • Upload the document (Import File Type and Select Files to upload)
  • Click on Load EQR Data
  • Select appropriate Data Update Options (Overwrite/Save)
  • Click on Validate and Save.
  • Validations errors will display if warnings and/or Errors exist in the data.
  • If there are no Validation Errors (Errors/Warnings), the data would be directly saved)
  • And with no errors and allowed warnings user can again click on Validate and Save or Save button to save the data.


Background Data Process

This process is implemented to save user time to load the data on to the grid and wait until the validation process completes on the screen and again wait for it to save.  This process is now moved into Queue Process which will process in the background and allow user to work on something else while the file validates and saves

User has to select Backend Data Process if he wishes to process the uploaded document in Queue.


  • Upload the document (Import File Type and select file to upload)
  • Select appropriate Data Update Options. (Overwrite/Append)
  • Select “Backend Data process”
  • Select “Allow Warning” if user wishes to save the data if only warnings occur in the data. Errors will not save but validation report will generate to show where errors occur.
  • Do not Select Allow warnings if user wants to run a validation only. Reupload of data will be required if not selected. By not selecting "allow warnings' it only produces a validation report and no save.
  • Click Add Validation to Queue.
  • An alert shows up that the process has been added to queue.


  • User can just run validations by not selecting “Allow Warnings” and can download the validation document from queue after the process is completed.
  • If User wants to save the data with warnings and no Errors, you can select the “Allow Warnings” which will still generate validation document in the queue, but saves the data also if there are only warnings.
  • Opening queue automatically (Showing up queue items once the validation item is added to queue) sometimes taking few seconds of waiting time.
  • User should not try to import or edit data on the filings which has current process running on the queue with the background process. We have implemented to deactivate Import and Ready to link buttons in Filing Import and Staging, but still needs to implement in the Ready to link module (We are showing an alert while the process is added to queue). 
  • When the last status column on the queue shows “Validation Errors”, that means the validation report is generated, but data is not saved.
  • When the last status column on the queue shows “complete”, that means the validation report is generated and data is also saved.



The same process also implemented in Staging Filing and Ready to link.

Ready to Link:

Staging Filing:

Forums: Systrends News

Docket RM16-17 - New Data Collection for Analytics and Surveillance for MBRs

Systrends News Bites - Thu, 08/11/2016 - 13:03

FERC has proposed to revise it regulations to collect certain data for analytics and surveillance purposes form MBR sellers and entities.

FERC held a technical workshop to discuss the data dictionary in the NOPR. 

Systrends attended the workshop and will plan to develop software to convert data to the XML format that FERC is requiring in the NOPR. FERC will not be building any software for this filing.

More details will come as comments and final rule is provided by FERC.


Forums: Systrends News

Q2 2016 EQR Filings Due August 1st

Systrends News Bites - Mon, 07/11/2016 - 11:04

As a reminder when the last day of the month falls on a weekend (non-business day) FERC gives you until the first business day after the end of the month to submit filings.

Since the last day of July falls on a Sunday - all filers have until Monday August 1st to submit their 2nd quarter data.

Contact Systrends if you have any questions or need any assistance. 

Forums: Systrends News

FERC is updating data/filing requirements for for EQR starting Q4 2016

Systrends News Bites - Thu, 06/16/2016 - 12:38

Here is a list of changes/updates FERC will be implementing starting Q4 2016

A.      Increment Name

1.  Field Numbers 28 and 61 are required data fields that currently require EQR
filers to designate the “Increment Name,” or the terms of a particular contract or sale,
as “Hourly,” “Daily,” Weekly,” “Monthly,” or “Yearly” in the Contract Data and Transaction Data sections of the EQR.  Based on our review of EQR data, some EQR filers are reporting “Increment Name” in an inconsistent manner.  For example, certain EQR filers designate some transactions in the Transaction Data section as “Daily”
when they should, in fact, be designated as “Hourly” transactions.  Conversely, some transactions that should be designated as “Daily” are instead mislabeled as “Hourly.”  We clarify that, if the price associated with a transaction does not change on an hourly basis, then that transaction should not be listed as “Hourly.”  However, if the price associated with a transaction does change on an hourly basis, then it must be listed as “Hourly.”  

2.  In addition, the most granular “Increment Name” currently available in the Contract Data and Transaction Data sections is “Hourly.”  Thus, for example, even transactions that are settled on a sub-hourly basis, such as in five-minute or fifteen-minute increments, can only be reported in the EQR as “Hourly.”  In order to align actual transactional data with the “Increment Name” required by Field Number 61, we will add values for sub-hourly transaction increments in the form of “(5) - Five-Minute” and “(15) - Fifteen-Minute” to Field Number 61.  Accordingly, EQR filers will be required to report transactions that occur on a sub-hourly basis, i.e., in five-minute or fifteen-minute increments, as applicable, using the relevant designations in the Transaction Data Section of the EQR.  We will include definitions in Field Number 28 for “(5) - Five-Minute” as “[t]erms of the contract (if specifically noted in the contract) set for up to 5 minutes” and for “(15) - Fifteen Minute” as “[t]erms of the contract (if specifically noted in the contract) set for up to 15 minutes.”  Similarly, we will include definitions in Field Number 61 for “(5) - Five-Minute” as “[t]erms of the particular sale for up to 5 minutes” and for “(15) - Fifteen-Minute” as “[t]erms of the particular sale for up to 15 minutes.”    

3.  Finally, the use of the word “consecutive” in the definitions of the specific increments listed under “Increment Name” in both the Contract Data and Transaction Data sections has created some confusion among filers with respect to how they should report peak and off-peak contracts and transactions.  For example, “Daily” transactions are defined in Field Number 61 as “Terms of the particular sale set for more than 6 and up to 60 consecutive hours . . . Includes sales over a peak or off-peak block during a single day.”  Some EQR filers interpret “consecutive” in this context to mean that daily off-peak transactions should be reported as “Hourly” because off-peak hours can extend over more than one single day.  However, these transactions should be reported as “Daily” and not “Hourly.”  To ensure greater consistency in how peak or off-peak contracts or transactions are reported, we will delete the word “consecutive” from the definitions listed under “Increment Name” in the Contract Data and Transaction Data sections.   

B. Commencement Date of Contract Terms

4.  Currently, the EQR Data Dictionary defines the “Commencement Date of Contract Terms” in Field Number 22, in relevant part, as “[t]he date the terms of the contract reported in fields 18, 23 and 25 through 44 (as defined in the data dictionary) became effective.  If those terms become effective on multiple dates (i.e., due to one or more amendments), the date to be reported in this field is the date the most recent amendment became effective.”  Field Number 22 requires that any amendment to the specified fields necessitates a change to the “Contract Commencement Date” and a new corresponding contract number.  Accordingly, for example, if the termination date of a contract changes, then the EQR filer must change the “Contract Commencement Date” in Field Number 22 and submit a new corresponding contract number. 

5. In Order No. 2001-H, the Commission stated that an amendment to key terms associated with the products and services offered under any given jurisdictional contract would require a change to the information collected in Field Number 22 regarding the date that service commenced under the contract.The Commission noted that information about when key terms were established is necessary to better understand the market conditions at the time a contract was put into place.

6. In Order No. 2001-I, the Commission delineated Field Numbers 18, 23, and 25 through 44 as fields containing key terms where changes to those fields would require a change in the date reported in Field Number 22.  We find that the current definition of “Commencement Date of Contract Terms” should include two additional key contractual terms:  “Seller Company Name” (Field Number 16) and “Customer Company Name” (Field Number 17).  For example, if the name of the Seller Company or the Customer Company changes, EQR filers must list a new “Commencement Date of Contract Terms” in Field Number 22.  We will therefore add Field Numbers 16 and 17 to the list of specified fields in the definition of “Commencement Date of Contract Terms.”  The definition of Field Number 22 will be revised, in relevant part, to “[t]he date the terms of the contract reported in fields 16, 17, 18, 23 and 25 through 44 (as defined in the data dictionary) became effective.”  

C.  Transmission-Related Data

7.  In Order No. 2001, the Commission required public utilities to file EQRs summarizing contractual terms and conditions in their agreements for all jurisdictional services, including transmission service.  In particular, Order No. 2001 required public utilities to file information in the EQR about standard and non-conforming transmission service agreements under their Open Access Transmission Tariffs (OATT) in the Contract Data Section of the EQR. However, based on our review of EQR data, many transmission providers are not filing the necessary transmission-related data.  We affirm the requirement set forth in Order No. 2001 that public utilities, including RTOs and ISOs,must file information about generally applicable transmission service (i.e., standard forms of transmission service agreements) and any agreements with individual terms and conditions or unexecuted agreements for any service (i.e., non-conforming transmission service agreements) in the Contract Data Section of the EQR.  Pursuant to Order No. 768, this requirement also applies to non-public utilities required to file EQRs that have an OATT on file with the Commission.

D.  Time Zone Field Options

8.  Currently, options associated with the “Time Zone” field, which are listed in Appendix D of the EQR Data Dictionary, include “UT (Universal Time) and “NA (Not Applicable).”  “Universal Time” is a modern continuation of Greenwich Mean Time.  Based on our review of EQR data, it appears that no EQR filers use the “Universal Time” option when reporting time zone information.  Therefore, the Commission will eliminate this option from Appendix D.  In addition, the Commission will eliminate the option “Not Applicable” from Appendix D because this is not an appropriate option for reporting time zone information. 

E.  Removal of E-Tag ID-Related Data Fields

9. In Order No. 768-B, the Commission rescinded the requirement for EQR filers to submit e-Tag ID data for each transaction reported in the EQR if an e-Tag was used to schedule the transaction.  Accordingly, we will delete the fields related to the e-Tag ID reporting requirement (i.e., Field Numbers 75 through 78) from the EQR Data Dictionary.


To view the document for this Issuance, click here

Forums: Systrends News

Systrends now offers Cyber Security Audits for your company

Systrends News Bites - Fri, 06/10/2016 - 09:01
How a Systrends Cyber Security audit can benefit your organization A Systrends Cyber Security audit can provide a systems security baseline.  The baseline (i.e., your current cyber security status) serves as the starting point for developing your cyber security strategy and for compliance with FERC CIP standards. A comprehensive Systrends Cyber Security audit will help your organization answer the following questions: What is the security risk category of the systems that make up your infrastructure—High, Medium, or Low? What are the current security controls for these systems? Who are the people managing and operating these systems? Who uses these systems (internal, external) and how do they use them? What information access does each group/subgroup have? Are your system controls documented? Are your controls and procedures current and able to be understood and implemented? A comprehensive Systrends Cyber Security audit will: Ensure your compliance with the FERC CIP standards. Take the cyber security evaluation and audit burden off your staff and internal security personnel. Manage the project and make sure all systems and people are identified and evaluated. Document, update, and organize your cyber security policy and procedures. Train your designated staff to keep your cyber security controls and policies current. Protect your organization and infrastructure from cyber threats and confirm that the right physical, administrative, and technological security controls are in place.Forums: Systrends News

eTariff 2.6.1 and a new version of EQR are coming out this week

Systrends News Bites - Mon, 04/11/2016 - 07:53

The latest version of eTariff (version 2.6.1) is now available.

For those who have Sandbox sites with Systrends it will be updated automatically.

Hosted customers will be updated soon.

To review a copy of the eTariff Release Notes please go to the Release Notes Page on (must be logged in to view)

Release notes will also appear under the Help Tab > Release Notes in your eTariff application

If you do not see a link to version 2.6.1 release notes then your eTariff has not been updated yet.


The latest EQR version should be out by this weekend

Forums: Systrends News

Q1 2016 EQR Filings Due by the end of April - Filing Overview

Systrends News Bites - Mon, 04/11/2016 - 07:37
AttachmentSize Import.png8.05 KB Validation.png52.68 KB Q12016 EQR Filings Due by End of April - Filing Overview Here is a quick overview of how to set up a filing. 1. Log into eFileEQR 2. Select the company from dropdown menu 3. Go the Filing Tab and select "Create New Filing" 4. Enter in Filing Details a. Filing Title (usually includes quarter and year that you are filing) b. Keep Status at Draft c. Filing type is New if this is the first time filing for the quarter; Replace if it is not the first time d. Select the Year for the filing data e. Select the Quarter for the filing data f. Filing agent details will be saved and can be selected from the Contact Person dropdown g. If you are a new filing agent then type in the contact information exactly how you are registered with FERC   5. Click Save   6. The system will take you back to the filing library where you will open the filing you just created by clicking on the title   7. For Import Data method - select Import Button  8. Select the File type that you are loading (Excel, CSV or Zip) and browse/Select Files and choose the file that you need to load.   9. Click "Load EQR Data" Button   10. Select Filing Modification Options for the data that you are loading (ID Data, Transactions, Contracts, Index Reporting) a. Select New/Overwrite checkboxes if this is the first set of data that is being loaded b. Select Append if this is an additional set of data being loaded to what is already in the filing   11. Click Validate & Save Filing button   12. A validation of the data will run. When it is finished the system will indicate if you have any warnings and/or errors in the data a. If you have any errors: Click "Export Validation Report" and open the document when completed in the queue. Correct any errors highlighted in red and Repeat step 7-11. All validation reports are now saved in the "Filing Validation History" tab but you must click export validation report button in order for it to save in the history b. If you have ONLY warnings:  You can still Export a validation report to save a copy of the warnings for future reference BUT most importantly you need to click the SAVE FILING button again to save the data with the warnings   13. Repeat Step 7 - 12 until ID Data, Contract Data, and Transaction Data files are all loaded. (if all the data is on one excel then you do not need to repeat)   14. Go to the FERC Submission Tab 15. Click Generate XML 16. When XML is complete, the the Submit to FERC link will appear. Click it and enter in FERC credentials and Submit. If you used copy forward method to load ID data and contracts or the Ready to Link method to pull over data from staging and need help then please contact Renee at renee.feeney@systrends.comForums: Systrends News

Systrends will be attending the Energy Marketing Conference

Systrends News Bites - Mon, 02/22/2016 - 11:44

March 3rd, 2016

For more information on the conference visit 

Forums: Systrends News


Subscribe to Systrends aggregator - Systrends Updates Forum Front Page