...
- Remove the example rows (if any) such that the row 40 is the first one containing the actual data
- Populate column I (OSreference) based on NGR (Easting, Northing) of borehole (column K and L).
- 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
- Define concatenate functions for cell B16, B17, B18, B19, B21, B22. The actual contents depends on data availability.
- Verify that the column(s) as used for the concatenate functions are properly populated with appropriate information (i.e. preferably no empty cells, 'unknowns, 'na' etc.). If necessary apply an 'IF-construction on the concatenate function. This verification is especially critical for columns being used in location names.
Info Expand Expand recommended concatenations with max. 4 WEL files Expand recommended concatenations with max. 4 WEL files 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
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="519357f5-9463-4db3-a02c-4da1e1f874bc"><ac:plain-text-body><![CDATA[
B18
LocationDescription
Description in Explorer-tooltip
location type, GW-unit, Formation
=T40 & " in GW-unit modelled at ("& W40 M40&" (, "&X40N40&") from [R"& Y40 &" formation." p40&", C"&q40&"] in GW-unit " & W40 & " ("&X40&") from " & Y40 &" formation."
]]></ac:plain-text-body></ac:structured-macro>
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 located at NGR (")& "Easting: "&K40&", Northing: " &L40& "), "&M40P40&", Model-YColumn: "&N40Q40&""&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
...
- Remove the example rows (if any) such that the row 36 is the first one containing the actual data
- Populate column D (OSreference) based on XY-coordinate of the associated grid cell (column H and I).
- Define concatenate functions for cell B14, B15, B16, B17, B19, B20. The actual contents depends on data availability.
- Verify that the column(s) as used for the concatenate functions are properly populated with appropriate information (i.e. preferably no empty cells, 'unknowns, 'na' etc.). If necessary apply an 'IF-construction on the concatenate function. This verification is especially critical for columns being used in location names.
- Verify that observation locations do not refer to layer numbers which are not supported by the model. Data mapping is done on a model layer basis. Hence, an observation in layer 0 will not receive information if the model contains layer 1-3.
Info Expand Expand recommended concatenations Expand recommended concatenations cell
item
used in
recommended content
recommended concatenate function
B14
LocationName
Explorer (map and filter)
site name & site code (optional layer)
=N36&" - "&C36
B15
ShortName
Graph legends
if possible shorter version of above
<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="477ad40e-70f1-4515-be9d-4e357bb23c7d"><ac:plain-text-body><![CDATA[
B16
LocationDescription
Description in Explorer-tooltip
location type, GW-unit, Formation , GW-unit, Formation
=O36 & " modelled at ("&H36&", "&I36&") [R"&K36&", C"&L36&") =O36 & " in GW-unit " & P36 & " ("&Q36&") from " & R36 &" formation."
]]></ac:plain-text-body></ac:structured-macro>
B17
Tooltip on map
free text Explorer-tooltip
borehole details (if any), NGR, model coordinates (XYZ and RC)
="Top of boreholeBH top: "&U36&" mAOD, Base of boreholebase: "&V36&" mAOD\n Easting: , located at NGR ("&F36&", Northing: "&G36&" "&H36& ", Model-Y: "&I36&" "), "&K36&", Column: "&L36&", Layer: "&J36&""
B19
Caption
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
B20
Shortcut
Shortcuts in GraphDisplay
see shortname or variations
see shortname or variations
...
- Remove the example rows (if any) such that the row 37 is the first one containing the actual data
- Populate column L (OSreference) based on the NGR-coordinate of the discharge or abstraction point (column N and O).
- Define concatenate functions for cell B14, B15, B16, B17, B19, B20. The actual contents depends on data availability.
- Verify that the column(s) as used for the concatenate functions are properly populated with appropriate information (i.e. preferably no empty cells, 'unknowns, 'na' etc.). If necessary apply an 'IF-construction on the concatenate function. This verification is especially critical for columns being used in location names.
| Anchor | ||||
|---|---|---|---|---|
|
...
- The Stream/rivername is normally used as unique identifier. Please do not use a slash (/)
in the name. - A new branch is identified by a changing name.
...