...
- Remove the example rows (if any) such that the row 40 is the first one containing the actual data
- Populate column I (OSreference) based on NGR (Easting, Northing) of borehole (column K and L).
- Check that column A,B,C,D are populated in correspondence to the provided runs (ModuleDataSets)
- Check that the number of locations/licences as listed in the spreadsheet corresponds (at least) to the number of wells in each WEL-file
- Define concatenate functions for cell B16, B17, B18, B19, B21, B22. The actual contents depends on data availability.
- Verify that the column(s) as used for the location name are properly populated with appropriate information (i.e. preferably no 'unknowns, 'na' etc.)
Define concatenate functions for cell B16, B17, B18, B19, B21, B22. The actual contents depends on data availability.Info Expand Expand recommended concatenations with max. 4 WEL files Expand recommended concatenations with max. 4 WEL files cell
item
used in
recommended content
recommended concatenate function
B16
LocationName
Explorer (map and filter)
licence code, purpose code (if any), site name, layer
=IF(O40<>
Expand Expand recommended concatenations with max. 4 WEL files Expand recommended concatenations with max. 4 WEL files cell
item
used in
recommended content
recommended concatenate function
B16
LocationName
Explorer (map and filter)
=IF(O40<>licence code, purpose code (if any), site name, layer
variations"";F40&""&G40&" - "&S40&" (L"&O40&")";F40&""&G40&" - "&S40)
B17
ShortName
Graph legends
if possible shorter version of above
B18
LocationDescription
Description in Explorer-tooltip
location type, GW-unit, Formation
=T40 & " in GW-unit " & W40 & " ("&X40&") from " & Y40 &" formation."
B19
Tooltip on map
free text Explorer-tooltip
licence holder, licence details, NGR, model coordinates (XYZ and RC)
=IF(U40="";"";"Licence holder: " &U40 & " (" &F40 & " - "&G40&")\n ")& "Easting: "&K40&", Northing: " &L40& " "&M40& ", Model-Y: "&N40&" "&P40&", Column: "&Q40&", Layer: "&O40&""
B21
Caption
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
B22
Shortcut
Shortcuts in GraphDisplay
see shortname or variations
see shortname or
- Populate column I (OSreference) based on XY-coordinate of borehole (column K and L).
- Check that column A,B,C,D are populated in correspondence to the provided runs (ModuleDataSets)
- Check that the number of locations/licences as listed in the spreadsheet corresponds (at least) to the number of wells in each WEL-file
- Verify that the column(s) as used for the location name are properly populated with appropriate information (i.e. preferably no 'unknowns, 'na' etc.)
...
- create a copy of the spreadsheet
- remove the additional columns (E possibly F) from the 'original' spreadsheet and ensure that concatenate functions are still valid
- in the spreadsheet-copy, move contents of additional columns (E possibly F) to column A and B. Empty column C and D if needed.
Ensure that concatenate functions are still valid
...
Step 5.5 Populate and verify worksheet for observation boreholes: OBH_org
Go to #Step 5.6. Gauges
The worksheet OBH_org is populated by the data provider.
Notes on the use of columns:
- The XY-position of the grid cell will be adopted as the XY-coordinate of the point location for this borehole. Taking this position over the actual NGR-coordinate will ensures that the interpolation from gridcell to OBH - using the closest distance method - will be in line with the way that the model has been set up.
- The NGR-coordinates are typically displayed in the tooltip.
- The OSreference will be used for the unique identifier of each borehole. It is recommended, but not required, to convert the gridcell position to OSreference. In any case, please document properly what coordinate has been used for this purpose.
- The sorting macro contains hard-coded column references. It is therefore essential that SitceCode starts at column C. Note the difference with column usage for the GW abstraction points.
Please conduct the following verification and preparation steps:
...
variations
Anchor | ||||
---|---|---|---|---|
|
If the table accounts for more than 4 WEL files (i.e. column E and possibly F are used to hold line numbers as well), one should do the following steps:
- create a copy of the spreadsheet
- remove the additional columns (E possibly F) from the 'original' spreadsheet and ensure that concatenate functions are still valid
- in the spreadsheet-copy, move contents of additional columns (E possibly F) to column A and B. Empty column C and D if needed.
Ensure that concatenate functions are still valid
Anchor | ||||
---|---|---|---|---|
|
Step 5.5 Populate and verify worksheet for observation boreholes: OBH_org
Go to #Step 5.6. Gauges
The worksheet OBH_org is populated by the data provider.
Notes on the use of columns:
- The XY-position of the grid cell will be adopted as the XY-coordinate of the point location for this borehole. Taking this position over the actual NGR-coordinate will ensures that the interpolation from gridcell to OBH - using the closest distance method - will be in line with the way that the model has been set up.
- The NGR-coordinates are typically displayed in the tooltip.
- The OSreference will be used for the unique identifier of each borehole. It is recommended, but not required, to convert the gridcell position to OSreference. In any case, please document properly what coordinate has been used for this purpose.
- The sorting macro contains hard-coded column references. It is therefore essential that SitceCode starts at column C. Note the difference with column usage for the GW abstraction points.
Please conduct the following verification and preparation steps:
- Remove the example rows (if any) such that the row 36 is the first one containing the actual data
- Populate column D (OSreference) based on XY-coordinate of the associated grid cell (column H and I).
- Define concatenate functions for cell B14, B15, B16, B17, B19, B20. The actual contents depends on data availability.
- Verify that the column(s) as used for the concatenate functions are properly populated with appropriate information (i.e. preferably no empty cells, 'unknowns, 'na' etc.). If necessary apply an 'IF-construction on the concatenate function.
- Verify that observations do not refer to layer numbers which are not supported by the model. (E.g. an observation in layer 0 does not receive information if the model contains layer 1-3).
Info
...
Expand Expand recommended concatenations Expand recommended concatenations cell
item
used in
recommended content
recommended concatenate function
B16
LocationName
Explorer (map and filter)
site name & site code (optional layer)
=N36&" - "&C36
B17
ShortName
Graph legends
if possible shorter version of above
B18
LocationDescription
Description in Explorer-tooltip
location type, GW-unit, Formation
=O36 & " in GW-unit " & P36 & " ("&Q36&") from " & R36 &" formation."
B19
Tooltip on map
free text Explorer-tooltip
borehole details (if any), NGR, model coordinates (XYZ and RC)
="Top of borehole: "&U36&" mAOD, Base of borehole: "&V36&" mAOD\n Easting: "&F36&", Northing: " &G36& " "&H36& ", Model-Y: "&I36&" "&K36&", Column: "&L36&", Layer: "&J36&""
B21
Caption
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
B22
...
Shortcut
...
Shortcuts in GraphDisplay
...
see shortname or variations
...
see shortname or variations
...
Shortcut
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
...
Anchor | ||||
---|---|---|---|---|
|
...
- The XY-position of the grid cell will be adopted as the XY-coordinate of the point location for this gauge. Taking this position over the actual NGR-coordinate will ensures that the interpolation from gridcell to gauge - using the closest distance method - will be in line with the way that the model has been set up.
- The NGR-coordinates are typically displayed in the tooltip.
- The OSreference will be used for the unique identifier of each boreholegauge. It is recommended, but not required, to convert the gridcell position to OSreference. In any case, please document properly what coordinate has been used for this purpose.
- The sorting macro contains hard-coded column references. It is therefore essential that SitceCode starts at column C. Note the difference with column usage for the GW abstraction points.
...
- Remove the example rows (if any) such that the row 36 35 is the first one containing the actual data
- Populate column B (OSreference) based on XY-coordinate of the associated grid cell(column F and G).
- Define concatenate functions for cell B16B12, B17B13, B18B14, B19B15, B21B17, B22B28. The actual contents depends on data availability.Populate column I (OSreference) based on XY-coordinate of borehole (column K and L).
- Verify that the column(s) as used for the location name are properly populated with appropriate information (i.e. preferably no 'unknowns, 'na' etc.) 'na' etc.)
- Verify that observations do not refer to layer numbers which are not supported by the model. (E.g. Gaugeboards in layer 0 do not receive information if the model contains layer 1-3).
Info Expand Expand recommended concatenations Expand recommended concatenations cell
item
used in
recommended content
recommended concatenate function
B16
LocationName
Explorer (map and filter)
site name & site code
...
=
...
L35&" - "&
...
A35
B17
ShortName
Graph legends
if possible shorter version of above
B18
LocationDescription
Description in Explorer-tooltip
...
location type, GW-unit, Formation
...
site description, river (if necessary)
=M35 & " " & N35
B19
Tooltip on map
free text Explorer-tooltip
...
NGR, model coordinates (XYZ and RC)
=
...
"
...
Easting: "&
...
D35&", Northing: " &
...
E35& " "&
...
...
...
...
...
B21
Caption
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
B22
Shortcut
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
Anchor | ||||
---|---|---|---|---|
|
...