...
- 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 | ||||
---|---|---|---|---|
|
...
- Create a backup-file with name XXX_LocationsProcessed_originals_versionnumber.xls.
- Open the spreadsheet NGMS-locations_Generator.xls.
- Activate the data-spreadsheet and run the macro 'SortLocationsAddParents' held in the NGMS_Locations_generator-spreadsheet.
- The macro asks what to items to process. Normally you would like to process all. Dependent on the model size it can take up to 2 hours (e.g. YNN).
- Check the results
- Are the newly generated worksheets properly filled ?
- Did the concatenate functions give proper results (especially for parents) ?
- Is the IDMapping OK ?
- If anything is incorrect:
...