...
Info | ||
---|---|---|
| ||
Locations on the Explorer-map have tooltips showing details on licences, coordinates etc. Within a tooltip, a line-feed is established by useing '\n' (backward slash n). |
Step 5.1 Check table structure of all worksheets in Data spreadsheet handed over
Go to #Step 5.2. Grids_loc
The starting condition of this step is a populated DataTemplate, which contains all relevant information for the model.
Info | ||
---|---|---|
| ||
OSreferences will provide the unique key to identify locations. The sorting macro will add layer details where needed, but the configurator has to ensure that two different boreholes/gauges etc. have two differents OSreferences. |
...
Step 5.1 Check table structure of all worksheets in Data spreadsheet handed over
Go to #Step 5.2. Grids_loc
The starting condition of this step is a populated DataTemplate, which contains all relevant information for the model.
When running the NGMS_Locations_Generator, it will pick up this spreadsheet, conduct a variety of checks and sorts all locations in the appropriate order. For this purpose, the Generator uses hardWhen running the NGMS_Locations_Generator, it will pick up this spreadsheet, conduct a variety of checks and sorts all locations in the appropriate order. For this purpose, the Generator uses hard-coded references to named worksheets and specific columns within a worksheet. To prevent failure in this processing, the following checks the need to be conducted on the table structure of the populated DataTemplate.
...
- Populate column I (OSreference) based on XY-coordinate of borehole (column K and L).
Go to: How to populate OSreference coordinates from kilometer-coordinates - 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.)
...
- Populate column I (OSreference) based on XY-coordinate of borehole (column K and L). Go to: How to populate OSreference coordinates from kilometer-coordinates
- 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 XY-position of the grid cell will be adopted as the XY-coordinate of the point location for this boreholegauge. Taking this position over the actual NGR-coordinate will ensures that the interpolation from gridcell to flow 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 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.
...
- Remove the example rows (if any) such that the row 36 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.
- 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.)
Expand 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
- Populate column I (OSreference) based on XY-coordinate of borehole (column K and L).
Go to: How to populate OSreference coordinates from kilometer-coordinates - Verify that the column(s) as used for the location name are properly populated with appropriate information (i.e. preferably no 'unknowns, 'na' etc.)
Anchor | ||||
---|---|---|---|---|
|
...