...
The worksheet GWabs_org is populated by the data provider.
Notes on the use of columns:
- The sorting macro contains hard-coded column references. It is therefore essential that column E is empty and column F holds the LicenceNo. One may not list more than 4 WEL files in the first 4 columns. If more WEL-files need to be accounted for, is recommended to create a second spreadsheet (see details #More than four runs provided).
- The XY-position of the NGR will be adopted as the XY-coordinate of the point location for this borehole. Taking this position over the actual NGR-coordinate ensures that the interpolation from grid cell to OBH - using the closest distance method - will be in line with the way 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 abstraction. It is essential that this OSreference is based on the NGR coordinate.
Please conduct the following verification and preparation steps:
- Remove the example rows (if any) such that the row 40 is the first one containing the actual data
- Define concatenate functions for cell B16, B17, B18, B19, B21, B22. The actual contents depends on data availability.
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<>"";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 variations
...
- create a copy of the spreadsheet
- remove the additional columns (E possibly F) from the 'original' spreadsheet and ensure that concantenate 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 concantenate functions are still valid
| Anchor | ||||
|---|---|---|---|---|
|
...