...
- 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)
- 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.
- Open the "Rechdim.his" file in ODS_View.exe (this is a viewer for HIS files installed on all machines that have SOBEK installed)
- 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.