...
- 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.)
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
| Anchor | ||||
|---|---|---|---|---|
|
...