Versions Compared

Old Version 8

changes.mady.by.user Marc van Dijk

Saved on

compared with

New Version 9

changes.mady.by.user Marc van Dijk

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following steps need to be followed in order to make the branch file.1.

  1. 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.
  2. Delete all information from these 4 worksheets.
  3. 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.
      Image Modified
    #*
    • 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.
  4. 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.
  5. 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").
    Image Modified
  6. Then press F5 from the Visual Basic Editor. The procedure will now run and fill the Gridpoints and Segments worksheets.
  7. 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.
      Image Modified
      Image Modified
    #*
    • 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.
      Image Modified
      Image Modified