...
- 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, B21, B22. The actual contents depends on data availability.
[expand}Expand Expand recommended settings: Expand recommended settings: item
used in
recommended content
recommended concatenate function
LocationName
Explorer (map and filter)
licence code, purpose code (if any), site name, layer
=IF(O40<>"";F40&""&G40&" - "&S40&" (L"&O40&")";F40&""&G40&" - "&S40)
ShortName
Graph legends
if possible shorter version of above
LocationDescription
Description in Explorer-tooltip
location type, GW-unit, Formation
=T40 & " in GW-unit " & W40 & " ("&X40&") from " & Y40 &" formation."
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&""
Caption
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
Shortcut
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
Anchor | ||||
---|---|---|---|---|
|
...