...
- Keelung.ids: File with the branch information, generated by Netter
- Calcdim.his and Calcdim.hia: File Files with static information from cross-sections that can be found in the SOBEK work folder. Information on bottom level and street level will be extracted from this file.
- Reachdim.his and Reachdim.hia: File Files with static information from reaches that can be found in the SObEK work folder. Information on the length of the reaches will be extracted from this file.
- Calcpnt.his: SOBEK File with computed water levels on all calculation nodes.
- Reachseg.his: SOBEK File with computed discharges and velocities.
...
- Open the "FEWS Longitudinal profiles.xls" file in EXCEL, this file has 4 worksheets named;
- Calcdim: information that will be copied from the Calcdim.his file.
- Rechdim: information that will be copied from the Rechdim.his file.
- Gridpoints: branch information for levels that will be computed within the EXCEL sheet.
- Segments: branch information for flows that will be computed within the EXCEL sheet.
- Delete all information from these 4 worksheets.
- Open the "Calcdim.his" file in ODS_View.exe (this is a viewer for HIS files installed on all machines that have SOBEK installed). Make sure the corresponding "Calcdim.hia" file is in the same directory.
- Select all data in ODS_View and export the data to a CSV file "Calcdim.csv" by pressing the "<Export data> button.
- Open the "Calcdim.csv" file in EXCEL and convert the column with data from "data to columns", can be found under the "Data" menu item.
- Copy the data for all cells to the Calcdim worksheet in the "FEWS Longitudinal profiles.xls" file.
- Select all data in ODS_View and export the data to a CSV file "Calcdim.csv" by pressing the "<Export data> button.
- Open the "RechdimReachdim.his" file in ODS_View.exe (this is a viewer for HIS files installed on all machines that have SOBEK installed). Make sure the corresponding "Reachdim.hia" file is in the same directory.
- Select all data in ODS_View and export the data to a CSV file "Rechdim.csv" by pressing the "<Export data> button.
- Open the "Rechdim.csv" file in EXCEL and convert the column with data from "data to columns", can be found under the "Data" menu item.
- Copy the data for all cells to the Rechdim worksheet in the "FEWS Longitudinal profiles.xls" file.
- Open the "Visual Basic Editor" in EXCEL by pressing ALT+F11. In the top part of the procedure you need to change the filename of the SOBEK Ids file (i.e. "d:\Test\Hsintien.ids").
- Then press F5 from the Visual Basic Editor. The procedure will now run and fill the Gridpoints and Segments worksheets.
- In XML-Spy you can now create two new branches with ids for the Level and Flow branches; "Hsientien_Level" and "Hsientien_Flow".
- Copy the first 5 columns of the EXCEL sheet Gridpoints to the "Hsientien_Level" pt elements.
- Enter also the startChainage and endChainage values in the corresponding elements.
- Copy the first 2 columns of the EXCEL sheet Segments to the "Hsientien_Flow" pt elements.
- Enter also the startChainage and endChainage values in the corresponding elements.
- Copy the first 5 columns of the EXCEL sheet Gridpoints to the "Hsientien_Level" pt elements.
...