Create a curve set data file

The following procedure assumes that a Microsoft Excel spreadsheet that you can use as a template is stored on your system. For each curve set that you create, save a copy of this spreadsheet and modify the parameters as required.

curveset010.xls is an Excel spreadsheet that acts as a template to enter curveset information. The spreadsheet resides in the following directory:

%DNAInstallRoot%\Realtime\sdk\CPM\

To create a curve set data file

1. Open the Microsoft Excel spreadsheet you are using as a template.

2. Save the spreadsheet as a new file that you can modify to reflect the curve set you are configuring.

3. Using the following format, enter the name and description of the curve set and surge alarm limits:

   Example:

   curveset: <Name of Curve Set>

   description: <description>

   group: <group>

   surgecontrol: x: <x-coord> y: <y-xcoord> deadbandx: <deadband xcoord>

   deadbandy: <deadband y-coord> slope: <slope value>

   surgewarn: x: <x-coord> y: <y-xcoord> deadbandx: <deadband xcoord>

   deadbandy: <deadband y-coord>

   Example:

   curveset: CURVESET010

   description: test record for curveset database group: CPMTEST

   surgecontrol: x: 7.25 y: 15 deadbandx: 7.3

   deadbandy: 15 slope: 4.6

   surgewarn: x: 8 y: 15 deadbandx: 8.1

   deadbandy: 15

4. Enter the number of curves.

5. Using the following format, create an entry for each curve:

   Example:

   number of curves: <Name of Curve Set>

   number of curves: <number of curves (max. 20)>

   curve: color: <color value> thickness: <thickness value>

   < X - axis (Flow Rate) values up to 30 points>

   < Y - axis ( Pressure ) values up to 30 points>

   Example:

   number of curves: 16

   curve: color: 170 thickness: 1

   X- Axis 6 7 9 11.3 13

   Y-Axis Speed1 12 11.7 11 8.24 5

   curve: color: 170 thickness: 1

   X- Axis 6.74 9 11 13 14.5

   Y-Axis Speed2 16 15 14 11.56 8.52

   curve: color: 170 thickness: 1

   X- Axis 7.45 9.33 11 13.54 15.78

   Y-Axis Speed3 19 18.4 17.7 15.86 12.25

   curve: color: 170 thickness: 1

   X- Axis 8.46 11 13 15 17

   Y-Axis Speed4 24 22.81 21.57 19 15.49

   and so on...

   Note: You will need to enter head pressure (y) and flow rate (x) coordinates for different speeds and efficiencies. You will also need to enter surge and surge warning lines, and a stonewall line, if desired. These are entered in the same manner as the speed and efficiency curves.

6. Enter the number of labels.

7. Using the following format, create an entry for each label:

   Example:

   number of labels: <number of labels (max. 24)>

   label: color: <color value> size: <size value> text: <text string>

   x: <X coord> y: <Y coord>

   Example:

   number of labels: 18

   label: color: 196 size: 2 text: EFFICIENCY(%) x: 17 y: 35

   label: color: 170 size: 2 text: SPEED(kr/min) x: 19.5 y: 10

   label: color: 10 size: 2 text: SURGE x: 9 y: 30

   label: color: 196 size: 2 text: 80 x: 12 y: 31

   and so on...

8. Once you have entered all the data for the curve set, save the spreadsheet in tab-delimited text format.