Knowledge Base

NERC Book of Flowgates

A spreadsheet template for importing interfaces from the NERC Book of Flowgates (2018 edition) may be downloaded here.

To use the spreadsheet:

  1. Place the original data from the NERC Book of Flowgates in the gray shaded region (columns A through AE, beginning with the column headers in row 2.) Add additional rows as needed.
  2. Copy the formulas in the green and yellow shaded regions to additional rows as needed to match the length of the original data.
  3. Copy the green shaded region (including headers in rows 1 and 2) into the Interfaces Case Info Display. (Model Explorer -> Aggregations -> Interfaces)
  4. Copy the yellow shaded region (including headers in rows 1 and 2) into the Interface Elements Case Info Display. (Model Explorer -> Aggregations -> Interfaces -> Interface Elements -> All Interface/Element Pairs)

Tags: ,,

December 3, 2018