...
- 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 settings Expand recommended concatenations settings 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
...