Page History

----

...

Step 5.1 Check table structure of all worksheets in Data spreadsheet handed over

Go to #Step Step 5.2. Grids_loc
The starting condition of this step is a populated DataTemplate, which contains all relevant information for the model.

When running the locations-generator macro, it will pick up this spreadsheet, conduct a variety of checks and sorts all locations in the appropriate order. For this purpose, the Generator uses hard-coded references to named worksheets and specific columns within a worksheet. To prevent failure in this processing, the following checks the need to be conducted on the table structure of the populated DataTemplate.

The comparison is done against the Empty_DataTemplate spreadsheet.

The comparison is done against the Empty_DataTemplate spreadsheet.

1. worksheet Model_info
   • ensure that the geological layers record are
   worksheet Model_info
   • ensure that the geological layers record are filled, as the generator checks this list to assign the observation boreholes to model layers
   • calculate the simulation length in days by subtracting end-date - start-date (B65-B64) and setting the cell format to general. this simulation length needs to be used in the runMF-spreadsheet to specify the export length
2. worksheet GWabs_org
   • ensure that no more than 4 runs are listed (column A-D), as the IdMapping can currently handle 4 runs only
     Note: If more than 4 runs are to be processed, use a second spreadsheet and fill column A-D with the line numbers of the wells in those runs. Please ensure that both spreadsheets contain the same locations.
   • ensure that LicenceNo starts in column F (i.e. C6)
3. worksheet SWlat_org
   • See above: ensure that no more than 4 runs are listed (column A-D), as the IdMapping can currently handle 4 runs only
     Note: If more than 4 runs are to be processed, use a second spreadsheet and fill column A-D with the line numbers of the wells in those runs. Please ensure that both spreadsheets contain the same locations.
   • ensure that ConsentNo/LicenceNo starts in column I (i.e. C9).
4. worksheet Branches_org
   • check if reachNr is in column C (C3); chainage is in column D (C4), OSRef is in column J (C10)
   • if not, copy the worksheet from the Empty_DataTemplate and populate again
     or
   • add column D and column J from the Empty_DataTemplate.xls
5. worksheet GWabs_IDmap_hist; GWabs_IDmap_nat; GWabs_IDmap_recact; GWabs_IDmap_fullic
   • if not available, copy all 4 from Empty_DataTemplate
6. worksheet SWlat_IDmap_hist; SWlat_IDmap_nat; SWlat_IDmap_recact; SWlat_IDmap_fullic
   • if not available, copy all 4 from Empty_DataTemplate

...

1. Remove the example rows (if any) such that the row 40 is the first one containing the actual data
2. Populate column I (OSreference) based on NGR (Easting, Northing) of borehole (column K and L).
3. Check that column A,B,C,D are populated in correspondence to the provided runs (ModuleDataSets)
4. Check that the number of locations/licences as listed in the spreadsheet corresponds (at least) to the number of wells in each WEL-file
5. Define concatenate functions for cell B16, B17, B18, B19, B21, B22. The actual contents depends on data availability.
6. 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   B18 LocationDescription Description in Explorer-tooltip location type, GW <ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="6d341a8e-111f-406b-a3bc-62887f808897"><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 free text Explorer-tooltip 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

...

1. Remove the example rows (if any) such that the row 36 is the first one containing the actual data
2. Populate column D (OSreference) based on XY-coordinate of the associated grid cell (column H and I).
3. Define concatenate functions for cell B14, B15, B16, B17, B19, B20. The actual contents depends on data availability.
4. 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.
5. 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="81373899-e3c2-436f-a401-85682f09e155"><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 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

...

1. Remove the example rows (if any) such that the row 35 is the first one containing the actual data
2. Populate column B (OSreference) based on XY-coordinate of the associated grid cell(column F and G).
3. Define concatenate functions for cell B12, B13, B14, B15, B17, B18. The actual contents depends on data availability.
4. Verify that the column(s) as used for the location name are properly populated with appropriate information (i.e. preferably no 'unknowns, 'na' etc.)
5. Verify that observations do not refer to layer numbers which are not supported by the model. Data mapping is done on a model layer basis. Hence, gaugeboards in layer 0 do 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 B12 LocationName Explorer (map and filter) site name & site code =L35&" - "&A35 B13 ShortName Graph legends if possible shorter version of above   B14 LocationDescription Description in Explorer-tooltip site description, river (if necessary) =M35 & " " & N35 B15 Tooltip on map free text Explorer-tooltip NGR, model coordinates (XYZ and RC) ="Easting: "&D35&", Northing: " &E35& " Model-X: "&F35& ", Model-Y: "&G35&" \Row: "&I35&", Column: "&J35&", Layer: "&H35&" \" B17 Caption Shortcuts in GraphDisplay see shortname or variations see shortname or variations B18 Shortcut Shortcuts in GraphDisplay see shortname or variations see shortname or variations

...

1. Remove the example rows (if any) such that the row 37 is the first one containing the actual data
2. Populate column L (OSreference) based on the NGR-coordinate of the discharge or abstraction point (column N and O).
3. Define concatenate functions for cell B14, B15, B16, B17, B19, B20. The actual contents depends on data availability.
4. 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. Image Removed'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

...

Step 5.10 Populate and verify worksheets for SW laterals: SWlat_IDMap (4 worksheets)

Go to #Step Step 5.11. Generate Location XML-files

...