Page History

...

1. Populate column I (OSreference) based on XY-coordinate of borehole (column K and L).
   Go to: How to populate OSreference coordinates from kilometer-coordinates
2. Check that column A,B,C,D are populated in correspondence to the provided runs (ModuleDataSets)
3. Check that the number of locations/licences as listed in the spreadsheet corresponds (at least) to the number of wells in each WEL-file
4. Verify that the column(s) as used for the location name are properly populated with appropriate information (i.e. preferably no 'unknowns, 'na' etc.)

...

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. Note the difference with column usage for the GW abstraction points.
• 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 OsreferenceOSreference. 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 steps should be conducted to prepare and verify the data provided:verification and preparation steps:

1. Remove the example rows (if any) such that the row 36 is the first one containing the actual data
2. Define concatenate functions for cell B16, B17, B18, B19, B21, B22. The actual contents depends on data availability.

   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

1. Populate column I (OSreference) based on XY-coordinate of borehole (column K and L).
   Go to: How to populate OSreference coordinates from kilometer-coordinates
2. Verify that the column(s) as used for the location name are properly populated with appropriate information (i.e. preferably no 'unknowns, 'na' etc.)
3. ensure that the OSreference column is populated (how to) as this column will provide the key for unique identification
4. ensure that the NGR-coordinates are given in kilometers as this determines

...