A FERC roll forward can be automated with a Chain Control sheet or can be done manually. We recommend using a chain to help automate the process, but we have outlined recommended steps for both approaches.
How to roll forward
Step 1: Copy a folder
- From Files, right-click the folder you want to roll forward and select Copy.
- Make sure the folder contains all the documents that you want to roll forward and click Next.
- Choose whether or not to include existing comments or outline labels.
- Select Include Wdata connections and Create Copies of Linked Files.
- Update the name of your folder to reflect the new reporting cycle and click Copy.
- You’ll receive a notification and an email when your copied folder is ready. Rename files within the folder to reflect the new reporting cycle.
Tip: When renaming files, include dates (or year and quarter) to help identify current filings.
Step 2: Update your Chain Control Sheet
The Chain Control sheet is the mapping guide that the Chain will reference to update data within the spreadsheet.
Be sure to update the Chain Control sheet in the Form Spreadsheet if schedule tables increased or if new supplemental pages with historical columns were added in the last reporting cycle.
To update Chain Control Sheet:
- Make sure that section names in the Chain Control sheet match the referenced section names.
- Set the row number for the rolling forward column’s header in Grab Cell Start and Historical Grab Start. For tables that increased in size, ensure row number of Grab Cell End and Historical Grab End are updated accordingly
Note: Some Chain Control sheets have been shortened down to five columns where Historical Grab Start and Paste Cell are in the same cell. If this is the case for you, ignore the Paste Cell column and do not delete any columns.
If you have supplemental pages that need to be rolled forward, you’ll have to add them to the Chain Control sheet.
- Add a row below the main schedule in the Chain Control sheet.
- Add a new SheetName that aligns with the referenced section name.
- Copy down the reference cells from the main schedule.
Step 3: Navigate to Chains
Once you’ve updated your Chain Control sheet, navigate to Chain Builder.
The Chain Builder, which is the chains environment, lives in Wdata. Keep in mind that the Chain Builder is only accessible to certain Wdata roles. For admins, it is Workspace Owner role and for non-admins, it is the Chain Owner role.
To access the Chain Builder:
- On the left-hand panel in Workiva, open Wdata.
- On the left-hand panel in Wdata, open Chains.
Step 4: Run Chains
Once you've opened Chain Builder, you may proceed to run chains.
- Click Build.
- Click on the FERC Roll forward chain and select Execute.
- Select Run with Inputs.
To get the Spreadsheet ID and Chain Control Sheet ID, navigate back to the spreadsheet you are rolling forward.
- Click into the Chain Control section.
- Spreadsheet ID: In the URL, copy the string of characters between the two backslashes after "spreadsheet"
- Chain Control Sheet ID: In the URL, copy the string of characters between the two backslashes after "sheet"
Tip: Double-click on the string of characters to easily grab the entire ID.
Step 5: Update dates page
After the chain is complete, update Reporting Period and Current Year fields from the Dates page under Admin. We recommend you publish after you update the quarter and year.
Step 6: Clear current period
Clear out the data in the current period columns.
Tip: After updating the dates page and before clearing the current period data, verify that the current year and prior year match to confirm a successful roll forward.
Step 2: Identify roll-forward sections and columns
Use the Chain Control sheet to track schedules needing roll forward. Identify all sections and columns with beginning balances.
Step 3: Move current data to historical data section
- Highlight the first ‘Historical Data’ column and right-click to insert a column to the left.
- Copy the column required for roll forward (including the date and column header) and paste it into the new column in the historical data section.
- Use the paste clipboard to select ‘Paste Only Values’ and remove ‘Apply Formatting’.
Step 4: Update dates page
Once the existing current period data has been added to the historical data, update Reporting Period and Current Year fields from the Dates page under Admin. Publish the updates so they flow through to the destination.
Step 5: Clear current period and publish
Clear the current data or begin updating the column with new numbers. If you have formulas for these cells, they should update once their source data is updated (TB, Workpapers, etc.). To finish, Publish changes so that all updated cells show the same data in the document as they do the spreadsheet.
Tip: Lock and color code all cells with formulas in a light yellow color to avoid accidental updates and to match other formulas.
If there are any errors, you’ll see a red exclamation mark icon under Run Details.
To understand where and why your error happened:
- In View Last Run, click on the red exclamation mark to open a panel.
- Use the down-arrow next to Value to find out which schedule the chain errored out on.
- Click on the value and select LOGS to see which Spreadsheet section the error occurred and what the error was.
Common troubleshooting tips are included below.
Error Message: Unable to retrieve sheet data: Insufficient permissions for the selected content.
- The Integration User within Workiva created needs Permissions to the FERC Master Spreadsheet in order to make edits to it.
- Open Permissions in the Master Spreadsheet and give the Integration User at least Editor permissions to the Spreadsheet.
Section Names Don't Match
Error Message: The sheet ID/Name is not valid.
- The Chain Control sheet may have a SheetName in Column A that the chain can't find in the Spreadsheet.
- Check that any new sections you've added in the prior period name in the Outline Panel on the left matches the name in the SheetName column.
- Check any existing sections you've renamed in the Outline Panel prior to the period that got updated in the Chain Control sheet SheetName column.
Invalid Sheet ID
Error Message: Error executing transformation path not found [SheetName]
- Confirm that the Chain Control sheet in the Spreadsheet is open when you take the Sheet ID from the URL
- Confirm that the Chain Control sheet ID is the letters and numbers after sheet/ in the URL.