Acvf Acf

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 9

Calculation of ACVF & ACF

***

Enter value in the orange cells only

Spacing(mm)
6
Ordinate no
x (mm)
Z(x) (mm)
0
0
0.00004
1
6
0.00005
2
12
0.00004
3
18
0.00008
4
24
0
5
30
0
6
36
0.000015
7
42
0
8
48
0.000035
9
54
0.00002
10
60
0.00006
Sample L
60
ACVF (mm2)
7.533E-10
Zmean (mm) 3.090909E-005
Ordinate no
x (mm)
Z(x) (mm)
10
60
0.00006
11
66
0.00007
12
72
0.0001
13
78
0.0001
14
84
0.00005
15
90
0.00008
16
96
0.00005
17
102
0.00009
18
108
0.0001
19
114
0.00005
20
120
0.00005
Sample L
60
ACVF (mm2)
5.373E-09
Zmean (mm) 7.272727E-005

Ordinate no
20
21
22
23
24
25
26
27

x (mm)
120
126
132
138
144
150
156
162

Z(x) (mm)
0.00005
0.00008
0.00008
0.00002
0.00007
0.0001
0.00005
0.000035

Origin at (mm)
Z(x+)
Z(x)*Z(x+)
0.00005
0.000000002
0.00004
0.000000002
0.00008
3.2E-009
0
0
0
0
0.000015
0
0
0
0.000035
0
0.00002
7E-010
0.00006
1.2E-009
0
0
Variance, 2

6.4008E-010

ACF

1.177

Z(x+)
0.00007
0.0001
0.0001
0.00005
0.00008
0.00005
0.00009
0.0001
0.00005
0.00005
0

Z(x)*Z(x+)
4.2E-009
0.000000007
0.00000001
0.000000005
0.000000004
0.000000004
4.5E-009
0.000000009
0.000000005
2.5E-009
0

Variance, 2

4.3802E-010

ACF

12.267

Z(x+)
0.00008
0.00008
0.00002
0.00007
0.0001
0.00005
0.000035
0.00004

Z(x)*Z(x+)
0.000000004
6.4E-009
1.6E-009
1.4E-009
0.000000007
0.000000005
1.75E-009
1.4E-009

0
SM
1
4
2
4
2
4
2
4
2
4
1

SM
1
4
2
4
2
4
2
4
2
4
1

SM
1
4
2
4
2
4
2
4

28
168
29
174
30
180
Sample L
60
ACVF (mm2)
2.850E-09
Zmean (mm) 5.227273E-005

0.00004
0.00005
0

Ordinate no
x (mm)
Z(x) (mm)
30
180
0
31
186
0.00004
32
192
0.00006
33
198
0.000125
34
204
0.00011
35
210
0.00002
36
216
0
37
222
0.00008
38
228
0
39
234
0.000015
40
240
0.00011
Sample L
60
ACVF (mm2)
3.020E-09
Zmean (mm) 5.090909E-005
Ordinate no
40
41
42
43
44
45
46
47
48
49
50
Sample L
ACVF (mm2)
Zmean (mm)

x (mm)
240
246
252
258
264
270
276
282
288
294
300
60
8.575E-09

Ordinate no
50
51
52
53
54
55

x (mm)
300
306
312
318
324
330

Z(x) (mm)
0.00011
0.000015
0.0001
0.00007
0.00022
0.0001
0.00018
0.00003
0.00001
0.0001
0.00011

0.000095
Z(x) (mm)
0.00011
0.00011
0.000055
0.000095
0.00018
0.0001

0.00005
0
0

0.000000002
0
0

Variance, 2

7.6074E-010

ACF

3.746

Z(x+)
0.00004
0.00006
0.000125
0.00011
0.00002
0
0.00008
0
0.000015
0.00011
0

Z(x)*Z(x+)
0
2.4E-009
7.5E-009
1.375E-008
2.2E-009
0
0
0
0
1.65E-009
0

Variance, 2

2.1401E-009

ACF

1.411

Z(x+)
0.000015
0.0001
0.00007
0.00022
0.0001
0.00018
0.00003
0.00001
0.0001
0.00011
0

Z(x)*Z(x+)
1.65E-009
1.5E-009
0.000000007
1.54E-008
0.000000022
0.000000018
5.4E-009
3E-010
0.000000001
0.000000011
0

Variance, 2

3.8045E-009

ACF

2.254

Z(x+)
0.00011
0.000055
0.000095
0.00018
0.0001
0.00004

Z(x)*Z(x+)
1.21E-008
6.05E-009
5.225E-009
1.71E-008
0.000000018
0.000000004

2
4
1

SM
1
4
2
4
2
4
2
4
2
4
1

SM
1
4
2
4
2
4
2
4
2
4
1

SM
1
4
2
4
2
4

56
336
57
342
58
348
59
354
60
360
Sample L
60
2
ACVF (mm )
7.065E-09
Zmean (mm) 8.545455E-005

0.00004
0.00004
0.00011
0.00008
0.00002

Ordinate no
x (mm)
60
360
61
366
62
372
63
378
64
384
65
390
66
396
67
402
68
408
69
414
70
420
Sample L
60
2
ACVF (mm )
9.859E-09
Zmean (mm) 8.927273E-005

Z(x) (mm)
0.00002
0.000095
0.00006
0.0002
0.00018
0.000115
0.00004
0.00008
0
0.000095
0.000097

Sample L
0-60
60-120
120-180
180-240
240-300
300-360
360-420
Average

ACVF*10^9
7.533E-01

5.373E+00
2.850E+00
3.020E+00
8.575E+00
7.065E+00
9.859E+00
5.356E+00

ACF
1.177
12.267
3.746
1.411
2.254
3.805
2.898
3.937

0.00004
0.00011
0.00008
0.00002
0

1.6E-009
4.4E-009
8.8E-009
1.6E-009
0

Variance, 2

1.8566E-009

ACF

3.805

Z(x+)
0.000095
0.00006
0.0002
0.00018
0.000115
0.00004
0.00008
0
0.000095
0.000097
0

Z(x)*Z(x+)
1.9E-009
5.7E-009
0.000000012
0.000000036
2.07E-008
4.6E-009
3.2E-009
0
0
9.215E-009
0

Variance, 2

3.4017E-009

ACF

2.898

2
4
2
4
1

SM
1
4
2
4
2
4
2
4
2
4
1

Product
2.00E-009
8.00E-009
6.4E-009
0
0
0
0
0
1.4E-009
4.8E-009
0
2.26E-008

Product
4.2E-009
2.80E-008
2.00E-008
2.00E-008
8.00E-009
1.60E-008
9.00E-009
3.60E-008
1.00E-008
1.00E-008
0
1.61E-007

Product
4.00E-009
2.56E-008
3.2E-009
5.6E-009
1.40E-008
2.00E-008
3.5E-009
5.6E-009

(Zi-Zmean)2
8.264E-011
3.645E-010
8.264E-011
2.410E-009
9.554E-010
9.554E-010
2.531E-010
9.554E-010
1.674E-011
1.190E-010
8.463E-010
9.554E-010

0.4
0.5
0.4
0.8
0
0
0.15
0
0.35
0.2
0.6

(Zi-Zmean)2
1.620E-010
7.438E-012
7.438E-010
7.438E-010
5.165E-010
5.289E-011
5.165E-010
2.983E-010
7.438E-010
5.165E-010
5.165E-010
4.818E-009

0.6
0.7
1
1
0.5
0.8
0.5
0.9
1
0.5
0.5

(Zi-Zmean)2
5.165E-012
7.688E-010
7.688E-010
1.042E-009
3.143E-010
2.278E-009
5.165E-012
2.983E-010

0.5
0.8
0.8
0.2
0.7
1
0.5
0.35

4.00E-009
0
0
8.55E-008

1.506E-010
5.165E-012
2.732E-009
9.554E-010

Product
0
9.6E-009
1.50E-008
5.50E-008
4.4E-009
0
0
0
0
6.6E-009
0
9.06E-008

(Zi-Zmean)2

Product
1.65E-009
6.00E-009
1.40E-008
6.16E-008
4.40E-008
7.20E-008
1.08E-008
1.2E-009
2.00E-009
4.40E-008
0
2.57E-007

Product
1.21E-008
2.42E-008
1.05E-008
6.84E-008
3.60E-008
1.60E-008

2.592E-009
1.190E-010
8.264E-011
5.489E-009
3.492E-009
9.554E-010
2.592E-009
8.463E-010
2.592E-009
1.289E-009
3.492E-009
9.554E-010

0.4
0.5
0

0
0.4
0.6
1.25
1.1
0.2
0
0.8
0
0.15
1.1

(Zi-Zmean)2
2.25E-010
6.4E-009
2.500E-011
6.250E-010
1.563E-008
2.500E-011
7.225E-009
4.225E-009
7.225E-009
2.500E-011
2.25E-010
9.554E-010

1.1
0.15
1
0.7
2.2
1
1.8
0.3
0.1
1
1.1

(Zi-Zmean)2
6.025E-010
6.025E-010
9.275E-010
9.112E-011
8.939E-009
2.116E-010

1.1
1.1
0.55
0.95
1.8
1

3.2E-009
1.76E-008
1.76E-008
6.4E-009
0
2.12E-007

2.066E-009
2.066E-009
6.025E-010
2.975E-011
4.284E-009
9.554E-010

Product
1.9E-009
2.28E-008
2.40E-008
1.44E-007
4.14E-008
1.84E-008
6.4E-009
0
0
3.69E-008
0
2.96E-007

(Zi-Zmean)2
4.799E-009
3.280E-011
8.569E-010
1.226E-008
8.231E-009
6.619E-010
2.428E-009
8.598E-011
7.970E-009
3.280E-011
5.971E-011
9.554E-010

0.4
0.4
1.1
0.8
0.2

0.2
0.95
0.6
2
1.8
1.15
0.4
0.8
0
0.95
0.97

ACVF & ACF vs Sample Length

ACVF*10^9

ACF

VF*10^9

ACF

You might also like