Wiki Markup |
---|
{scrollbar} |
Section | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||
|
...
- 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="fc27dda6-8ea1-4b1d-9d21-648560341c4f"><ac:plain-text-body><![CDATA[
B18
LocationDescription
Description in Explorer-tooltip
location type, GW-unit, Formation
=T40 & " modelled at ("&M40&", "&N40&") [R"&p40&", C"&q40&"] in GW-unit " & W40 & " ("&X40&") from " & Y40 &" formation."
]]></ac:plain-text-body></ac:structured-macro>
B19
Tooltip on map
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&") located at NGR ("&K40&", &L40& "), Row: "&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="0e152754-25b0-4565-84c6-a93128cc753f"><ac:plain-text-body><![CDATA[
B16
LocationDescription
Description in Explorer-tooltip
location type, GW-unit, Formation
=O36 & " modelled at ("&H36&", "&I36&") [R"&K36&", C"&L36&") in GW-unit " & P36 & " ("&Q36&") from " & R36 &" formation."
]]></ac:plain-text-body></ac:structured-macro>
B17
B17
Tooltip on map
free text Explorer-tooltip
borehole details (if any), NGR, model coordinates (XYZ and RC)
="BH top: "&U36&" mAOD, base: "&V36&" mAOD, located at NGR ("&F36&", "&G36&"), Row: "&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.
Info Expand Expand recommended concatenations Expand recommended concatenations cell
item
used in
recommended content
recommended concatenate function
B14
LocationName
Explorer (map and filter)
consentNo, purpose code, sitename
=IF(I37="";X37;IF(J37<>"";I37&"_"&J37&" - "&X37;I37 &" - "&X37))
B15
ShortName
Graph legends
if possible shorter version of above
=IF(I37="";X37;IF(J37<>"";I37&"_"&J37;I37))
B16
LocationDescription
Description in Explorer-tooltip
site description, purpose, remark if any
=Y37&" for "&AA37 &" purposes. "&AE37
B17
Tooltip on map
free text Explorer-tooltip
licence holder (if any), NGR, model coordinates (XYZ and RC)
="Licenceholder: " &Z37&"\n Easting: "&N37&", Northing: " &M37& " Model-X: "&P37& ", Model-Y: "&Q37&" \Row: "&S37&", Column: "&T37&", Layer: "&R37&" \"
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
Anchor | ||||
---|---|---|---|---|
|
...