Laserfiche WebLink
QUERYING & CHARTING SOFTWARE AND ITS OPERATION <br />The Querying and Charting Software is executed to present pre- computed river flows and <br />subreach gains in both a graphical and tabular format. The pre- computed river flows and <br />subreach gains are the sole product of the PFM described above. Following are instructions <br />regarding the computer installation of the Querying and Charting Software (as it applies to the <br />Lower South Platte River) and steps to assist user's during its operation. The Querying and <br />Charting Software is written in Microsoft's Visual BASIC (for Applications) and operates within <br />the Microsoft Excel environment (version 5.0). A hard copy of the Visual Basic module which <br />controls the Querying and Charting Software is located in Appendix V. Future versions of the <br />Querying and Charting software will allow its use with output from PFM for other river <br />segments (i.e. other then the Lower South Platte River). <br />INSTALLATION INSTRUCTIONS <br />The Querying and Charting Software for the Lower South Platte River, along with the necessary <br />supporting files, are all contained on the accompanying 3.5" - 1.44 megabyte diskette. In total, <br />seven files associated with the Querying and Charting Software are contained on the disk. The <br />individual file names and corresponding file descriptions are as follows: <br />chr prog.zip - A Microsoft Excel Workbook containing the Visual BASIC code module, dialog <br />boxes, charts, and worksheets used to query and display (in graphical and tabular format) desired <br />information. This file exists in a compressed format (.zip) on the diskette. Upon execution of <br />setup.bat, cMprog.zip is uncompressed and resides in the newly created directory c :\ncwcd as <br />chrtprog.xls. A copy of the Microsoft Visual BASIC module of this Excel Workbook is included <br />in Appendix V. <br />flowout.zip - A database file containing all of the daily calculated point flows at locations above and <br />below each defined node (as described above) in the Lower South Platte River. This file exists in <br />a compressed format (.zip) on the diskette. Upon execution of setup.bat, flowout.zip is <br />uncompressed and resides in the newly created directory c.\ncwcd as flowout.dbf. flowout.dbf is <br />accessed from Excel by executing special ODBC (Open Database Connectivity) drivers and SQL <br />(Structured Query Language) commands. <br />gainout.zip - A database file containing all of the daily calculated subreach gains (as described <br />above) in the Lower South Platte River. This file exists in a compressed format (.zip) on the <br />diskette. Upon execution of setup.bat, goinout.zip is uncompressed and resides in the newly created <br />directory c.\ncwcd as gainout.dbf. gaincut.dbf is accessed from Excel by executing special ODBC <br />drivers and SQL commands. <br />histdiv.zip - A database file containing total daily diversion amounts from State's River Diversion <br />Records for ditches /canals (described in section entitled 'Input Data Tables for the Lower South <br />30 ptflguid.wpd <br />