Document No LM0670 Issue A Rev 2 November 2017 Page 14 of 15
Data Collection
A B C D E F G H
1
Test #
Approx
flow rate
Weight
collected
Time for
test
Density
Calculated
Volume
Displayed
Flow rate
Actual flow
rate
2
Litres/hour Kg Seconds gm/cm³ Litres
Litres/hour
3
Col C
Col F*3600
4
Col E
Col D
5
6
1 1500 25.106 60.015 1.0015 25.068 1500 1503.73
7
2 1500 24.976 59.866 1.0015 24.939 1495 1499.66
8
3 1500 24.807 59.432 1.0015 24.770 1492 1500.39
9
10
4 1200 15.887 44.215 1.0015 15.863 1245 1291.59
11
5 1200 16.015 43.965 1.0015 15.991 1240 1309.40
12
6 1200 15.757 44.023 1.0015 15.733 1233 1286.61
13
14
7 Etc.
15
8 Etc.
Data Analysis
A B C D E F G H I
16
Data
Sets
Displayed
Flow rate
Actual flow
rate
Difference
17
(Col G/Col
H)-1
18 Average of tests 1, 2 and 3
1495.667 1501.262 -0.37%
19 Average of tests 4, 5 and 6
1239.333 1295.863 -4.36%
20 Average of tests 7, 8 and 9
21 Etc.
Etc.
Original Data
Revised Data, after calibration
A B C D E F G H I
22
Flow Rate
Meter
Factor
New Flow
Rate
Old
Difference
New
23
Run
Litres per
hour
Pulses
per litre
Run
Litres per
hour
Pulses
per litre
was
Pulses per
litre
24
# l/hr ppl # l/hr
ppl
ppl
25
from original or last calibration certificate
Col G
x(1+Col H)
26 1 1686.06 851.815 1
1501.262
851.815 -0.37%
848.640
27 2 1237.26 850.707 2
1295.863
850.707 -4.36%
813.596
28 3 918.06 851.688 3
Etc.
29 4 603.90 857.140
30 5 484.314 868.801
31 6 363.030 879.710
32 7 244.398 890.983
33 8 127.716 918.669
34 9 53.412 941.109