ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Revision History
2
3
4
DateRev no.Revision Log
5
31-May-184.0.0First Version
6
27-Jun-184.0.11. CORE - AGS: Add Remarks (Core references)
2. ISPT - AGS: Correct formula for SPTN -Extrapolate (Hidden column)
7
2-Aug-184.0.2GEOL - AGS: Added Soil Type for "Sandstone" under pick list
8
25-Sep-184.0.31. UNIT - AGS: Add units of 'Mpa/s', 'yyy-mm-ddThh:mm', 'hh:mm:ss' and 'mm:ss'
9
2. Lab Test Sheets: Change 'SAMP_ID' and 'SAMP_REF' to picklist
10
3. Added new sheet for Consolidation test "CONG-AGS" and "CONS-AGS"
11
17-May-194.0.41. GEOL - AGS: Add GEOL_GEO2 for more geological rock types.
12
2. GEOL - AGS: Add GEOL-LEG for more geological rock types from code 818 to 849.
13
3. Correct <UNITS> in "CONS - AGS" sheet for CONS_TEMP to "DegC".
14
4. Correct missing PROJ_ID formula of "='PROJ - AGS'!A6" for "CONG - AGS" and "CONS - AGS" sheet.
15
5. Edit the column of description of each sheet for "Field heading in group" for enough space for all wording and easy view.
16
3-Mar-214.0.5GEOL - AGS: correct the formula for column "GEOL_GEO2"
17
17-Jan-254.0.6Extend all the spreadsheet rows for data key-in from Sheet "LOCA - AGS" until the end sheet of "PIPE - AGS" up to row 5000.
18
16-Oct-264.0.71. TRET - AGS: Add TRET_CELL, TRET_DEVF and TRET_PWPF for triaxial (CIU) test results.
19
2. Add new sheet "SHBT - AGS" with SHBT_TESN, SHBT_NORM, SHBT_PEAK and SHBT_REM for direct shear box test results.
20
3. TREG - AGS: Add TREG_TYPE (Test type) with pick list from ABBR - AGS, e.g. CU / CUM for CIU triaxial tests.
21
4. Add new sheets "TRIG - AGS" and "TRIT - AGS" for UU triaxial tests (TRIG_TYPE, TRIT_CU).
22
5. Add new sheet "IVAN - AGS" for in situ vane shear test results (IVAN_TYPE, IVAN_IVAN, IVAN_IVAR).
23
6. GEOL - AGS: Expand Major, Minor 1 and Minor 2 pick lists:Added CHERT, TUFF, GRIOTTE, ARENITE, SERPENTINITE, ANDESITE,
24
DIORITE, DOLOMIT, VOLCANIC ROCK, METAMORPHIC ROCK and PEBBLE.
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100