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:
- 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.
- Copy the formulas in the green and yellow shaded regions to additional rows as needed to match the length of the original data.
- Copy the green shaded region (including headers in rows 1 and 2) into the Interfaces Case Info Display. (Model Explorer -> Aggregations -> Interfaces)
- 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)
December 3, 2018