This section is intended to provide help to developers of other  programs who would like to import AquaCalc CSV output or interact with DataLink or with the latest version of the AquaCalc Pro Plus. If you are developing we strongly encourage that you contact AquaCalc LLC so that we may assist you.

Topic include:

• AquaCalc Pro Plus Output Samples
• Using command codes for automatically downloading the AquaCalc Pro Plus
• Calling DataLink from Another Program

AquaCalc Pro Plus Output

AquaCalc Pro Plus currently has two versions of the output, these are based on the old AquaCalc Pro version 1.7 output format. See below for the detailed description of

• Output File Changes for AquaCalc Pro and Pro Plus
• Header Description and
• Measurement Section Column Descriptions

Sample AquaCalc Pro Plus CSV Output:

Output Version 2.1 Sample: Simple .6 single point in vertical

The following AquaCalc Pro Plus Output version 2.1 sample is a simple single point measurement:

Download here: AquaCalc_Pro_Plus_Output_v2_1_CSV_Single_Point_Measurement.csv

A Section Summary Report in PDF format from DataLink showing this measurement can downloaded.

Download here: Section_Summary_Report_from DataLink_APP_Single_Point_Measurement.pdf

<csv>
AquaCalc Pro Plus(tm) by AquaCalc LLC (c)2017

S/N:,14100313    
Firmware Version:, V2.4.2
File Version:, V2.1

Sect ID:,            TRMQ20170913  
User ID:,              SMR           
Meter name:,           PYGMY std2
Meter id:,             P1      
Meter type:,           PYGMY
Meter Standard:,       SAE  
Meter Revs/Pulses:,   1/1
Meter Const.S1:,      0.9604
Meter Const.O1:,      0.0312
Meter Const.C1:,      0.0000
Meter Const.S2:,      0.0000
Meter Const.O2:,      0.0000
Meter Const.C2:,      0.0000
Meter Const.S3:,      0.0000
Meter Const.O3:,      0.0000
Beg Time:,           09/13/17 22:13
End Time:,           09/13/17 23:27
Sect Time:,           1.23
Line Not Used:,       0.00
Beg Gage height:,     1.22
End Gage height:,     1.22
Beg Staff height:,    1.22
End Staff height:,    1.22
Estimated Q:,        67.18
Adjusted  Q:,        67.18
Measure time:,       40
Measure standard:,     SAE  
Measure equipment:,    TopSet Rod
Sounding Weight:,      NA
Measure ice:,          No
Flood Measurement:,    No
Flood Coef:,          0.00
Max Vertical Q:,      5%
Percent Slope:,       0.0000
Measure Start at:,     REW
Vertical Count:,     39
Section Velocity:,    1.79
Section Width:,      45.50
Section Area:,       36.95
Section Q:,          66.27
Section Diff:,       -0.91
Section Pct Err:,    -1.4%
Section Quality:,      Fair    
Section WetPerim:,Na      
Section Hyd Rad:,     0.00
Section Manning:,     0.0000
Section Chezy:,       0.0000

VERT,   DIST,TDPTH,IDRFT,EDPTH,OBS, TIME,REVS,HA,HC:VF,METH,CLOCK, MVEL, OVEL, VVEL,   SSAREA,        SSQ, SSPCT, FLAGS
 1,    55.50, 0.00, 0.00, 0.00,   E,     ,    ,  ,     ,    ,22:13,     ,     , 0.00,     0.00,     0.00,  0.0%,
 2,    55.00, 0.48, 0.00, 0.48,  o6,40.98,  30, 0, 1.00,1.00,22:14, 0.73, 0.73, 0.73,     0.60,     0.44,  0.7%,
 3,    53.00, 0.51, 0.00, 0.51,  o6,40.95,  41, 0, 1.00,1.00,22:15, 0.99, 0.99, 0.99,     1.02,     1.01,  1.5%,
 4,    51.00, 0.64, 0.00, 0.64,  o6,40.94,  39, 0, 1.00,1.00,22:17, 0.95, 0.95, 0.95,     0.96,     0.91,  1.4%,
 5,    50.00, 0.67, 0.00, 0.67,  o6,40.50,  79, 0, 1.00,1.00,22:18, 1.90, 1.90, 1.90,     0.67,     1.28,  1.9%,
 6,    49.00, 0.76, 0.00, 0.76,  o6,40.12,  72, 0, 1.00,1.00,22:19, 1.75, 1.75, 1.75,     0.76,     1.33,  2.0%,
 7,    48.00, 0.85, 0.00, 0.85,  o6,40.42,  75,11, 0.98,1.00,22:20, 1.81, 1.78, 1.78,     0.85,     1.51,  2.3%,
 8,    47.00, 0.81, 0.00, 0.81,  o6,40.01,  72,14, 0.97,1.00,22:21, 1.76, 1.71, 1.71,     0.81,     1.38,  2.1%,
 9,    46.00, 0.79, 0.00, 0.79,  o6,40.08,  89,14, 0.97,1.00,22:23, 2.16, 2.10, 2.10,     0.79,     1.66,  2.5%,
10,    45.00, 0.89, 0.00, 0.89,  o6,40.45,  58,14, 0.97,1.00,22:24, 1.41, 1.37, 1.37,     0.89,     1.22,  1.8%,
11,    44.00, 0.73, 0.00, 0.73,  o6,40.46,  67,14, 0.97,1.00,22:26, 1.62, 1.57, 1.57,     0.73,     1.15,  1.7%,
12,    43.00, 0.90, 0.00, 0.90,  o6,40.25, 112,20, 0.94,1.00,22:29, 2.70, 2.54, 2.54,     0.68,     1.72,  2.6%,
13,    42.50, 1.02, 0.00, 1.02,  o6,40.24, 104,20, 0.94,1.00,22:27, 2.51, 2.36, 2.36,     0.77,     1.81,  2.7%,
14,    41.50, 1.02, 0.00, 1.02,  o6,40.01, 105,20, 0.94,1.00,22:30, 2.55, 2.40, 2.40,     0.77,     1.83,  2.8%,
15,    41.00, 1.07, 0.00, 1.07,  o6,40.21,  89,20, 0.94,1.00,22:33, 2.16, 2.03, 2.03,     0.53,     1.08,  1.6%,
16,    40.50, 1.08, 0.00, 1.08,  o6,40.29,  86,14, 0.97,1.00,22:31, 2.08, 2.02, 2.02,     0.54,     1.09,  1.6%,
17,    40.00, 0.92, 0.00, 0.92,  o6,40.27, 115,20, 0.94,1.00,22:34, 2.77, 2.61, 2.61,     0.69,     1.80,  2.7%,
18,    39.00, 1.06, 0.00, 1.06,  o6,40.15,  89,14, 0.97,1.00,22:35, 2.16, 2.10, 2.10,     1.06,     2.22,  3.3%,
19,    38.00, 1.32, 0.00, 1.32,  o6,40.08,  90,14, 0.97,1.00,22:36, 2.19, 2.12, 2.12,     1.32,     2.80,  4.2%,
20,    37.00, 1.32, 0.00, 1.32,  o6,40.17,  80,14, 0.97,1.00,22:37, 1.94, 1.89, 1.89,     1.32,     2.49,  3.8%,
21,    36.00, 1.13, 0.00, 1.13,  o6,40.62,  68,14, 0.97,1.00,22:39, 1.64, 1.59, 1.59,     1.13,     1.80,  2.7%,
22,    35.00, 0.80, 0.00, 0.80,  o6,40.06, 104,20, 0.94,1.00,22:40, 2.52, 2.37, 2.37,     0.80,     1.90,  2.9%,
23,    34.00, 1.09, 0.00, 1.09,  o6,40.28,  76,20, 0.94,1.00,22:41, 1.84, 1.73, 1.73,     1.09,     1.89,  2.9%,
24,    33.00, 1.03, 0.00, 1.03,  o6,40.26,  81,14, 0.97,1.00,22:42, 1.96, 1.90, 1.90,     1.03,     1.96,  3.0%,
25,    32.00, 0.82, 0.00, 0.82,  o6,40.27,  91,14, 0.97,1.00,22:44, 2.20, 2.14, 2.14,     0.82,     1.75,  2.6%,
26,    31.00, 1.00, 0.00, 1.00,  o6,40.05,  98,14, 0.97,1.00,22:45, 2.38, 2.31, 2.31,     1.00,     2.31,  3.5%,
27,    30.00, 1.10, 0.00, 1.10,  o6,40.19,  99,14, 0.97,1.00,22:46, 2.40, 2.33, 2.33,     1.10,     2.56,  3.9%,
28,    29.00, 1.10, 0.00, 1.10,  o6,40.17,  90,20, 0.94,1.00,22:48, 2.18, 2.05, 2.05,     1.38,     2.82,  4.3%,
29,    27.50, 0.92, 0.00, 0.92,  o6,40.31,  82,20, 0.94,1.00,22:51, 1.98, 1.87, 1.87,     1.26,     2.36,  3.6%,
30,    26.25, 0.97, 0.00, 0.97,  o6,40.33,  82,20, 0.94,1.00,22:52, 1.98, 1.86, 1.86,     1.33,     2.49,  3.8%,
31,    24.75, 0.73, 0.00, 0.73,  o6,40.10,  72,14, 0.97,1.00,22:53, 1.76, 1.70, 1.70,     1.19,     2.02,  3.0%,
32,    23.00, 0.91, 0.00, 0.91,  o6,40.19, 104,30, 0.87,1.00,22:55, 2.52, 2.19, 2.19,     1.25,     2.74,  4.1%,
33,    22.00, 0.77, 0.00, 0.77,  o6,40.12, 100,30, 0.87,1.00,22:56, 2.43, 2.11, 2.11,     0.96,     2.03,  3.1%,
34,    20.50, 0.92, 0.00, 0.92,  o6,40.49,  63,20, 0.94,1.00,22:57, 1.53, 1.43, 1.43,     1.38,     1.98,  3.0%,
35,    19.00, 0.45, 0.00, 0.45,  o6,41.59,  27, 0, 1.00,1.00,23:00, 0.65, 0.65, 0.65,     0.79,     0.52,  0.8%,
36,    17.00, 0.67, 0.00, 0.67,  o6,41.72,  30, 0, 1.00,1.00,23:01, 0.72, 0.72, 0.72,     1.17,     0.85,  1.3%,
37,    15.50, 0.82, 0.00, 0.82,  o6,40.03,  68, 0, 1.00,1.00,23:04, 1.66, 1.66, 1.66,     1.23,     2.05,  3.1%,
38,    14.00, 0.83, 0.00, 0.83,  o6,40.18,  63, 0, 1.00,1.00,23:06, 1.54, 1.54, 1.54,     2.28,     3.51,  5.3%,
39,    10.00, 0.00, 0.00, 0.00,   E,     ,    ,  ,     ,    ,23:27,     ,     , 0.00,     0.00,     0.00,  0.0%,

</csv>
 

Output Version 2.0: Ice measurement with .2 and .8 velocities in vertical:

This section measurement shows a two point measurement with ice draft and is a good representative of both situations.

Download here: AquaCalc_Pro_Plus_CSV_Output_v2_0_Ice Measurement.csv

A Section Summary Report in PDF format from DataLink showing this measurement can downloaded.

Download here: Section_Summary_Report_from_DataLink_Ice_Measurement.pdf

<csv>
AquaCalc Pro Plus(tm) by JBS Instruments (c)2014

S/N:,13070180    
Firmware Version:, V2.1.8
File Version:, V2.0

Sect ID:,            NAB02 20140318
User ID:,              13070180      
Meter name:,           ICE      
Meter id:,             I00011  
Meter type:,           NonStd
Meter Standard:,       SAE  
Meter Revs/Pulses:,   1/1
Meter Const.S1:,      1.0000
Meter Const.O1:,      0.0000
Meter Const.C1:,      0.0000
Meter Const.S2:,      0.0000
Meter Const.O2:,      0.0000
Meter Const.C2:,      0.0000
Meter Const.S3:,      0.0000
Meter Const.O3:,      0.0000
Beg Time:,           03/18/14 14:40
End Time:,           03/19/14 10:18
Sect Time:,             NA
Line Not Used:,       0.00
Beg Gage height:,     0.00
End Gage height:,     0.00
Beg Staff height:,    0.00
End Staff height:,    0.00
Estimated Q:,       153.00
Adjusted  Q:,       153.00
Measure time:,       40
Measure standard:,    
Measure equipment:,    Sect.Rod 
Sounding Weight:,      NA
Measure ice:,          Yes
Flood Measurement:,    No
Flood Coef:,          1.00
Max Vertical Q:,      5%
Percent Slope:,       0.0000
Measure Start at:,     REW
Vertical Count:,     22
Section Velocity:,    0.09
Section Width:,     180.00
Section Area:,      529.25
Section Q:,          46.50
Section Diff:,     -106.50
Section Pct Err:,   -69.6%
Section Quality:,      na      
Section WetPerim:,Na      
Section Hyd Rad:,     0.00
Section Manning:,     0.0000
Section Chezy:,       0.0000

VERT,   DIST,TDPTH,IDRFT,EDPTH,OBS, TIME,REVS,HA,HC:VF,METH,CLOCK, MVEL, OVEL, VVEL,   SSAREA,        SSQ, SSPCT, FLAGS
 1,    50.00, 0.00, 0.00, 0.00,   E,     ,    ,  ,     ,    ,00:00,     ,     , 0.00,     0.00,     0.00,  0.0%,
 2,    60.00, 4.10, 2.20, 1.90,  o6,41.89,   7, 0, 1.00,1.00,15:44, 0.05, 0.05, 0.05,    19.00,     0.97,  2.1%,
 3,    70.00, 6.00, 2.40, 3.60,  o2,42.17,  13, 0, 1.00,1.00,16:01, 0.09, 0.09
 3,    70.00, 6.00, 2.40, 3.60,  o8,43.28,  10, 0, 1.00,1.00,15:58, 0.07, 0.07, 0.08,    36.00,     2.96,  6.4%,
 4,    80.00, 7.80, 2.40, 5.40,  o2,40.53,  15, 0, 1.00,1.00,16:10, 0.11, 0.11
 4,    80.00, 7.80, 2.40, 5.40,  o8,41.63,  11, 0, 1.00,1.00,16:07, 0.08, 0.08, 0.10,    54.00,     5.22, 11.2%,
 5,    90.00, 7.60, 2.60, 5.00,  o2,42.44,  16, 0, 1.00,1.00,16:13, 0.11, 0.11
 5,    90.00, 7.60, 2.60, 5.00,  o8,42.38,  16, 0, 1.00,1.00,16:14, 0.12, 0.12, 0.11,    37.50,     4.31,  9.3%,
 6,    95.00, 7.30, 2.60, 4.70,  o2,41.93,  14, 0, 1.00,1.00,16:17, 0.10, 0.10
 6,    95.00, 7.30, 2.60, 4.70,  o8,42.56,  16, 0, 1.00,1.00,16:18, 0.11, 0.11, 0.11,    23.50,     2.54,  5.5%,
 7,   100.00, 7.10, 2.70, 4.40,  o2,40.00,  13, 0, 1.00,1.00,16:21, 0.10, 0.10
 7,   100.00, 7.10, 2.70, 4.40,  o8,40.43,  15, 0, 1.00,1.00,16:19, 0.11, 0.11, 0.11,    22.00,     2.33,  5.0%,
 8,   105.00, 7.00, 2.50, 4.50,  o2,41.67,  14, 0, 1.00,1.00,16:24, 0.10, 0.10
 8,   105.00, 7.00, 2.50, 4.50,  o8,41.68,  14, 0, 1.00,1.00,16:22, 0.10, 0.10, 0.10,    22.50,     2.30,  4.9%,
 9,   110.00, 7.00, 2.40, 4.60,  o2,42.52,  14, 0, 1.00,1.00,16:28, 0.10, 0.10
 9,   110.00, 7.00, 2.40, 4.60,  o8,42.40,  17, 0, 1.00,1.00,16:26, 0.12, 0.12, 0.11,    23.00,     2.56,  5.5%,
10,   115.00, 6.90, 2.40, 4.50,  o2,40.76,  13, 0, 1.00,1.00,16:31, 0.10, 0.10
10,   115.00, 6.90, 2.40, 4.50,  o8,42.95,  14, 0, 1.00,1.00,16:29, 0.10, 0.10, 0.10,    22.50,     2.21,  4.8%,
11,   120.00, 6.80, 2.50, 4.30,  o2,42.49,  15, 0, 1.00,1.00,16:33, 0.11, 0.11
11,   120.00, 6.80, 2.50, 4.30,  o8,42.42,  14, 0, 1.00,1.00,16:32, 0.10, 0.10, 0.10,    32.25,     3.36,  7.2%,
12,   130.00, 6.30, 2.50, 3.80,  o2,42.42,  12, 0, 1.00,1.00,16:36, 0.09, 0.09
12,   130.00, 6.30, 2.50, 3.80,  o8,43.28,  14, 0, 1.00,1.00,16:34, 0.10, 0.10, 0.09,    38.00,     3.51,  7.5%,
13,   140.00, 5.70, 2.20, 3.50,  o2,43.18,  11, 0, 1.00,1.00,16:39, 0.08, 0.08
13,   140.00, 5.70, 2.20, 3.50,  o8,42.77,  13, 0, 1.00,1.00,16:37, 0.09, 0.09, 0.09,    35.00,     2.98,  6.4%,
14,   150.00, 5.40, 2.00, 3.40,  o2,40.62,  12, 0, 1.00,1.00,16:41, 0.09, 0.09
14,   150.00, 5.40, 2.00, 3.40,  o8,40.82,  13, 0, 1.00,1.00,16:40, 0.10, 0.10, 0.09,    34.00,     3.18,  6.8%,
15,   160.00, 5.30, 1.90, 3.40,  o2,42.31,  10, 0, 1.00,1.00,16:44, 0.07, 0.07
15,   160.00, 5.30, 1.90, 3.40,  o8,41.53,  12, 0, 1.00,1.00,16:42, 0.09, 0.09, 0.08,    34.00,     2.72,  5.8%,
16,   170.00, 5.40, 2.20, 3.20,  o2,42.53,   8, 0, 1.00,1.00,16:47, 0.06, 0.06
16,   170.00, 5.40, 2.20, 3.20,  o8,43.29,  10, 0, 1.00,1.00,16:45, 0.07, 0.07, 0.06,    32.00,     2.04,  4.4%,
17,   180.00, 4.00, 2.70, 1.30,  o6,42.78,  11, 0, 1.00,1.00,16:48, 0.08, 0.08, 0.08,    13.00,     1.02,  2.2%,
18,   190.00, 4.50, 2.70, 1.80,  o6,42.77,  10, 0, 1.00,1.00,16:50, 0.07, 0.07, 0.07,    18.00,     1.28,  2.8%,
19,   200.00, 3.90, 2.30, 1.60,  o6,43.37,   9, 0, 1.00,1.00,16:51, 0.06, 0.06, 0.06,    16.00,     1.01,  2.2%,
20,   210.00, 3.50, 2.40, 1.10,  o6,40.00,   0, 0, 1.00,1.00,16:53, 0.00, 0.00, 0.00,    11.00,     0.00,  0.0%,
21,   220.00, 3.00, 2.40, 0.60,    ,     ,    ,  ,     ,    ,15:28,     ,     , 0.00,     6.00,     0.00,  0.0%,
22,   230.00, 0.00, 0.00, 0.00,   E,     ,    ,  ,     ,    ,15:28,     ,     , 0.00,     0.00,     0.00,  0.0%,

</csv>

 

AquaCalc Pro Plus Output - Header Description

<csv>	Computer File Type identifying Comma Separated Value
AquaCalc Pro Plus(tm) by AquaCalc LLC (c)2017	Header beginning
	(blank line)
S/N:                     0000006F2B19	Current Meter Identification Number	Default
Firmware Version:     V2.0.0	Firmware Version Identification	Default
File Version:         V2.0	File Version	Default
	(blank line)
Gage ID:                  1534000.709	Gaging Station Identification Number	User	15,a,n
User ID:                   MARK JONES	Hydrogapher Identification	User	15, a,n
Meter name:              A94156	Meter Name	User	10, a,n
Meter id:                   A94156	Meter Identification Number	User
Meter type:                PAA11	Meter Type	User	n/a
Meter Standard:         SAE	Measurment Type SAE=English/SI=Metric	User	n/a
Meter Revs/Pulses:     1/1	Ratio of Meter Revolutions per pulse	User	n/a
Meter Const.S1:          2.2048	Meter Constant 1: m1 – slope (m) of line segment 1 where Velocity = (m * rev/sec) +b	User / Default standard meters	1.4, n
Meter Const.O1:          0.0178	Meter Constant 1: O1 – Offset (b) of line segment 1 where Velocity = (m * rev/sec) +b		1.4, n
Meter Const.C1:          0	Velocity changeover point of line segment 1 to line segment 2		2.2, n
Meter Const.S2:          0	Meter Constant 2: O2 – Offset (b) of line segment 2 where Velocity = (m * rev/sec) +b		1.4, n
Meter Const.O2:          0	Meter Constant 2: m2 – slope (m) of line segment 2 where Velocity = (m * rev/sec) +b		1.4, n
Meter Const.C2:          0	Velocity changeover point of line segment 2 to line segment 3		2.2, n
Meter Const.S3:          0	Meter Constant 3: m3 – slope (m) of line segment 3 where Velocity = (m * rev/sec) +b		1.4, n
Meter Const.O3:          0	Meter Constant 3: O3 – Offset (b) of line segment 3 where Velocity = (m * rev/sec) +b		1.4, n
Beg Time:           02/23/10 09:41	Date and Time at the Beginning of the Measurement	Calculated
End Time:           02/23/10 10:16	Date and Time at the end of the Measurement	Calculated
Meas Time:                0.58	Time for Duration of the entire Measurement	Calculated
Line Not Used:              0.00	This line is not used.
Beg Gage height:        0	Inside Gage Height Reading from Inside Gage at Beginning of Measurement	User	4.2, n
End Gage height:        0	Inside Gage Height Reading from Inside Gage at End of Measurement	User	4.2, n
Beg Staff height:         0	Stage Height Reading from Staff Gage at Beginning of Measurement	User	4.2, n
End Staff height:         0	Stage Height Reading from Staff Gage at End of Measurement	User	4.2, n
Estimated Q:               230	Estimated Discharge - based on Stage Height and Rating Curve / Table	Calculated	6.2, n
Adjusted  Q:                230	Adjusted Estimated Discharge based on Stage Height and Rating Curve / Table. (This value is entered during measurement and changes warning messages.)	User	6.2, n
Measure time:             40	User recommended Measurement Time in Seconds (1-99)	User	2, n
Measure standard:      SAE	Measurement Units – SAE=English / SI=Metric	User
Measure equipment:    TopSet Rod		User
Sounding Weight:       NA
Measure ice:              No	Identifies whether Ice Draft Mode used
Flood Measurement:    No	Identifies whether .2 Flood Mode used	User
Flood Coef:                0
Max Vertical Q:           5%			2n
Percent Slope:            0			1.4, n
Measure Start at:        REW	Beginning Edge of Water / Bank: REW:Right Edge of Water / LEW: Left Edge of Water	User
Vertical Count:           22	Number of Verticals in the Measurement	Calculated
Section Velocity:        0.74	Mean Velocity	Calculated
Section Width:           144	Width in Feet of the Stream not including Width of Piers, Islands, etc.	Calculated
Section Area:            261.65	Cross-section Area	Calculated
Section Q:                192.68	Total Discharge of Water	Calculated
Section Diff:             -37.32		Calculated
Section Pct Err:       -16.20%	Percent difference from Estimated Q	Calculated
Section Quality:         na		User
Section WetPerim:    145.46		Calculated
Section Hyd Rad:      1.8		Calculated
Section Manning:       0		Calculated
Section Chezy:          0		Calculated

AquaCalc Pro Plus Output - Measurement Section Column Descriptions

Column Heading	Description	Created by	Width, Type
VERT	Vertical Number	Calculated	2, number
DIST	Tag Line Distance	User	5, number
TDPTH	Total Depth	User	4, number
IDRFT	Ice Draft	User	4, number
EDPTH	Effective Depth	Calculated	4, number
OBS	Observation Depth	User	2, alpha-num
TIME	Observation Time in seconds	Calculated	5, number
REVS	Revolutions	Calculated	3, number
HA	Horizontal Angle	Calculated	2, number
HC:VF	Horizontal Coefficient : Vertical Factor	User	4, number
METH	Method Coefficient	User	4, number
CLOCK	Clock time of observation	Calculated	5, alpha-num
MVEL	Measured Velocity	Calculated	4, number
OVEL	Observed Velocity	Calculated or User	4, number
VVEL	Vertical Velocity	Calculated	4, number
SSAREA	Subsection Area	Calculated	4, number
SSQ	Sub-Section Discharge	Calculated	4, number
SSPCT	Sub-Section Percent of Total Discharge	Calculated	4, alpha-num
FLAGS	Not used

 

Output File Changes for AquaCalc Pro and Pro Plus

Output File Changes from Output Version 2.0 to Output Version 2.1 (January 2018, first implemented in firmware 2.4.2)

The AquaCalc Pro Plus (APP) has made changes to the AquaCalc Pro (AQP) version 2.0 output format. The new format is version 2.1and includes small changes. The order of items, the number of characters were kept as close to version 1.5 as possible.

1. Line 2: Changed from: “AquaCalc Pro Plus(tm) by JBS Instruments (c)2012” to “AquaCalc Pro Plus(tm) by AquaCalc LLC (c)2017”
2. Line 6: Changed from “File Version:, V2.0” to ” “File Version:, V2.1”

Output File Changes from Output Version 1.5 to Output Version 2.0

The AquaCalc Pro Plus (APP) has made changes to the AquaCalc Pro (AQP) version 1.5 output format. The new format is version 2.0 and includes small changes. The order of items, the number of characters were kept as close to version 1.5 as possible.

1. Line 2: Changed from: “AquaCalc Pro (tm) by JBS Instruments (c)2002” to “AquaCalc Pro Plus(tm) by JBS Instruments (c)2012”
2. Line 6: Changed from “File Version:, V1.5” to ” “File Version:, V2.0”
3. Line 8: Change from “Gage ID:” to “Sect ID:”
4. Line 20: Line 20 was mislabeled in Output Version 1.5. “Meter Const.C1” changed to “Meter Const.C2”.
5. Line 26: This line was a duplicate with line 48. “Section Diff:” changed to “Line Not Used:”, but this line will be repurposed in future output formats. (Suggestions are welcome).
6. An additional line “<\csv>”was added at the second to last line, (before the End of File character) to close the opening XML tag properly.

---

Using command codes for automatically downloading the AquaCalc Pro Plus

The AquaCalc Pro Plus (APP) has two way communication when the unit is placed in the Connections screen. This allows for the discovery of the APP using the Send Version Report command, followed by a Section List request for a list of sections measurements, and then finally a Send CSV command that will allow the retrieval of a CSV file containing the full measurement.

In the Connections screen the APP will listen for commands and respond with XML formatted Version reports and Sections Lists and a CSV format Section Output representing the data collected

The AquaCalc Pro Plus (APP) must be in the Connections screen for data exchange commands to work. The APP appears as a serial communications port to a Window computer with the USB Driver installed. Windows will assign the APP a virtual Communications Port (COM Port) and the APP receives standard ASCII over the USB connection at 19200 baud rate using the serial port communications protocol.

• Note: There must be a minimum of 1000 milliseconds (1 second) between commands. There should be a 4000 millisecond (4 second) delay after the Delete Section or Delete Observation commands to allow the AquaCalc Pro Plus to finish processing.

Connections screen commands

Send Version Report  = <sendver>

Send CSV  = <sendcsv>0</sendcsv>

List Sections  = <listsec>

Delete Section  = <delsect>0</delsect>

Delete Observations  = <delobs>0</delobs> (NOT IMPLEMENTED)

Send Version Report

The version report gives the status of an AquaCalc Pro Plus, including the firmware version that is running and the serial number of the unit.

Version Report Sample:

<vr>AquaCalcPro2,2.0.1,2.0.0,04/30/12 14:36,P3000001,BOBSAQUACALC    </vr>

Where:

• AquaCalcPro2 is the model number (an AquaCalc Pro Plus)
• 2.1.0 represents the boot version (not important for downloading),
• 2.0.0 represents the firmware version.
• 04/30/12 14:36 (mm/dd/yy hh:mm) is the date of the firmware version.
• P3000001 is the serial number of the unit.
• BOBAQUACALC is the AquaCalc ID (a user entered value)

• Each command string is followed by a Carriage Return followed by a Line Feed (ASCII character 13 followed by ASCII character 10).

List Sections

Prompts the APP to send an XML formatted list of the sections it has in memory with some basic information about the section in a CSV encoded string.

<listsec> - list the sections:

The items in the string include:

• AquaCalc Memory location (01 through 30 at the present time, may be increased in the future) Note: this memory location is used in the Send CSV command.
• Section ID (alpha-numeric, 16 characters),
• User ID (alpha-numeric, 16 characters)
• Measurement Date and Time (alpha-numeric date time format, 14 characters)
• Number of Verticals in the Section (numeric)
• Total Discharge / Q (numeric with decimal, nn.nn)

• Section List format output example

<sectionlist>

<section>04,YELLOW CREEK,TOM JONES,11/23/10 12:00,22,99.99</section>

<section>05,YELLOW CREEK,TOM JONES,11/24/10 12:00,25,00.99</section>

</sectionlist>

Each section line includes the following:

<section> memory location,SID,User ID,Beginning Time,Number of verticals,discharge </section>

Send CSV

Requests a section measurement be sent in a CSV format from the memory location specified.

<sendcsv>01</sendcsv> – send the active section in memory location 1 using the traditional APP csv format.

Delete Section

This command deletes a complete section measurement, all verticals, and all observations. Typically used after downloading a section to the computer.

<delsect>02</delsect>– delete the entire section in location 2

Delete Observations (NOT IMPLEMENTED)

The delete observations command removes only the observation data but maintains the section information and the vertical locations.

<delobsv>03</delobs> – delete only the observations in location 3

Calling DataLink from Another Program

DataLink 3 can be called from another program and used to download and review AquaCalc measurements. But, since DataLink can be installed and updated directly from our website using Microsoft’s ClickOnce technology, the location of the executable may not be obvious. ClickOnce installs the executable (AquaCalc DataLink 3.exe) into the Users folder. The file path for the executable can be found using registry keys.

We have added a registry keys in the HKEY_CURRENT_USER space to identify the location of the DataLink 3 executable (AquaCalc DataLink 3.exe),

HKEY_CURRENT_USER/JBSEnergy/DataLinkApplicationPath

Accessing the Download Log XML file

AquaCalc DataLink 3.1 and above has the ability to create an optional download log that lists the file names and file paths from the last download in an XML log file. These log files were created at the request of the USGS to aid in importing downloaded measurements to their systems.

We have added a registry key in the HKEY_CURRENT_USER space to identify the location of the DataLink download log file:

HKEY_CURRENT_USER/JBSEnergy/DataLinkDownloadLogPath

This key is not created until a download log is created the first time. To write to the download log file (and create the Registry Keys)

1. In DataLink3.1 and above, the user must first go into “Settings” using the toolbar icon, and select the Options tab, and check the “Write to Download Log File” checkbox. If you would like this log deleted each time DataLink 3 is restarted, check the box “Delete Download Log on Startup” otherwise the log will continue to grow.
2. Initiate a Download Session in DataLink.

In the log, each “Download Session”  begins when the user clicks the Download button, and ends when the Download Section Measurements window is closed. There can be several Download sessions per open and close of DataLink if the user opens and closes the Download Section Measurements screen several times. The log is further delineated by the AquaCalc model, and in the case of the AquaCalc Pro Plus, the serial number of the AquaCalc.

As a developer, you will be looking for the XML tag “<filepath>” in the log to identify a line containing a file path to the downloaded file. The following XML log shows one automated AquaCalc Pro Plus download session, followed by two downloads from an older AquaCalc Pro.
 
<DownloadSession datetime="4/23/2013 1:19:13 PM">
<AquaCalc Pro Plus SN="13020117">
<filepath>C:\Users\Greg\Documents\5___13020117_13020117_030513_1656.csv</filepath>
<filepath>C:\Users\Greg\Documents\031313_0829_13020117_13020117_031313_0830.csv</filepath>
<filepath>C:\Users\Greg\Documents\032213_1226_13020117_13020117_032213_1226.csv</filepath>
</AquaCalc Pro Plus>
</DownloadSession>
<DownloadSession datetime="4/23/2013 1:23:39 PM">
<AquaCalcPro>
<filepath>C:\Users\Greg\Documents\042313_1410___000000_0000.csv</filepath>
</AquaCalcPro>
<AquaCalcPro>
<filepath>C:\Users\Greg\Documents\TEST_GR__040913_1629.csv</filepath>
</AquaCalcPro>
</DownloadSession>
 

If you have additional questions or suggestions, we would be happy to help.

 

Need Accessories or Cables?

We have replacement parts and cables for the AquaCalc line of stream flow computers including the Digital Pygmy Magnetic Head retro fit your old Pygmy Current Meter with a new digital magnetic sensor.

Find Accessories and Cables here.

Contact Us