Fort Walton Beach Council agenda — 09-13-11 regular — reading text

the line in the first pane, and the label and the total or average value, when set by the user, shall be automatically set in the same manner. The software shall allow graphs with up to 4 panes to be generated in this manner. Teledyne Isco Flowlink Professional Software for Windows / Engineering Specifications Page 9 of 14  luawdlnb3 6uu01Noty rsold Mrt t ell : OS40 20- t t 811 joi IelilwgnS oast auApalal guawgaepy a( m B) Format of Graphs and Tables a YY aUm i) The software shall convert a graph into a table, and vice versa, with a single click. The average and total values of the data over the time span for flow rate and rainfall data, and the average value of the data over the time span for all other types of data, shall be displayed at the bottom of the table. ii) The time span for a graph or table shall be any number of hours, days, weeks, months, or years, and shall begin with either the current or prior day, week, or month, a relative day and time, or an absolute date and time. Dates shall be selected from a calendar. iii) The software shall allow the user to enter a label for each line, to select the type of each line to be either a line graph, bar graph, or point graph, and to select the units of measure, pane, Y axis, color, line type, and symbol for each line. iv) The software shall generate graphs with up to 4 Y axes, with each Y axis either automatically or manually scaled. v) A movable vertical line shall mark a time stamp on the graph with which to compare the values of all data points intersected by the vertical line. Each value is reported in the legend. vi) Up to two horizontal lines shall be displayed at user- specified values for annotation of ranges, limits, etc. vii) The software shall have the capability to create and save graph/table templates using data from any site, with all properties of the graph or table specified by the user. When a different site is dragged and dropped onto a template, the data from this site shall be substituted for the template site, with all other properties of the graph or table remaining identical to that of the template. The software shall then allow the user to save the new graph or table. viii) The software shall include over 150 standard graph/ table templates, including a variety of graphs and tables, with daily, weekly, and monthly time spans, with one and more than one data type, with raw data, and average, minimum, maximum, and total data. When a site is dragged and dropped onto a template, the data from this site shall be displayed on the template, with all other properties of the graph or table remaining identical to that of the template. The software shall then allow the user to save the new graph or table. The software shall allow the user to modify the standard templates and save the new templates. Q Presentation of Graphs and Tables i) The software shall generate graphs with up to 4 panes, with a user specified relative height for each pane. ii) The software shall print graphs and tables in either portrait or landscape orientation. Teledyne Isco Flowlink Professional Softwarefor Windows / Engineering Specifications Page 10 of14  tuawdinb3 6upolluoW Mold iZO- tt 811 : mltt) LZo- Lt 811 jol Ien1wgng oosl auRpalal quawgoepy w am 00 a d iii) The software shall invert selected data in a graph for ease of comparison or a reference. iv) The software shall include the capability to scroll the graph or table 25% of the time span to the left and right, to scroll the graph or table to the previous and next time span, and to scroll the graph or table to the beginning and end of the data. v) The software shall display the date, time, and value at a cursor on a graph when a location on the graph is clicked. The cursor shall move to the left and right on the graph, and between the different lines on the graph, by using the arrows on the computer keyboard. vi) The software shall have zoom capabilities for both X and Y axes. vii) The software shall allow the user to magnify the time scale on a graph, decreasing the time span that is displayed, and unmagnify the time scale on a graph, increasing the time span that is displayed. viii) The software shall have savable text box labeling, for on- screen viewing and exported PDF and HTML formats. ix) The software shall allow the user to specify that a line in a graph or table be generated using either original or edited data. x) The software shall allow the user to display date, time, and bottle number of samples in graph and tables. xi) The software shall have the capability to generate graphs and reports with data from more than one site. 7) EDITING DATA —The software shall include capabilities for adjusting the times and values of stored readings. The software shall display the original and edited data in graph and table format simultaneously (except for scatter plot graphs), and the data can be edited in either view. The software shall allow single values on a graph to be moved to new points by clicking and dragging. The software shall save both the original and edited data, and shall include the capability to restore all or selected edited data to the original values. The software shall include the capability to undo all editing since the last time changes were saved. A) The software shall cut or copy data from one time period and paste the data into another time period. Types of reading adjustments shall be constant, fixed, and proportional. B) A constant adjustment shall set all selected readings to a constant value. A constant multiplier value shall be applied to the original values. A fixed adjustment shall add or subtract a fixed value from all selected readings. A proportional adjustment shall distribute a positive or negative value over all selected readings. An auto -correct adjustment shall calculate a selected range of Teledyne Isco Flowlink Professional Software for If <ndows / Engineering Specifications Page 11 of 14  luawdinb3 6u! l011MoLAI Mold 20- 1, 1, 911 : 0£ v0 tZ0- 4t 811 jol I ell! wgng oosl aw( pal a1 : lu0wg0entl , y vm a m data points so that a straight line connects them. A time adjustment shall adjust a selected readings forward or backward by a fixed amount. C) There shall be scatter plot editing capability, for both single point and X or Y axis adjustment. 8) DATA ANALYSIS A) The software shall have the capability to convert level and velocity data into flow rate based on a variety of flow conversions, including those retrieved from instruments and those generated independent of the instruments. The software shall also be able to calculate volumes over time from the flow rate. B) The software shall allow the user to enter a relative time shift, or an absolute date and time, for each data set, so that data from more than one time period can be compared. C) The software shall be able to generate graphs and tables that include addition, subtraction, multiplication, and division of data, and to employ series formula operators. D) The software shall be able to generate graphs and tables that include average, minimum, maximum, and total values calculated over a specified summary interval, and to include the date and time of the minimum and maximum values in tables. E) The software shall be able to save the data from the lines of a graph or the columns in a table as datasets in a new site, so that these calculated datasets can be included in other graphs and tables. F) The software shall be capable of creating a reference curve from a baseline data set for comparison with other data sets of the same measurement type. A series formula shall report the differences between the reference curve and the compared data set. G) The software shall be capable of data accumulation with or without resetting to zero at each summary interval, across the displayed time span. 1-1) The software shall have the capability to plot two data sets as an X -Y scatter plot so the relationship between the data sets can be easily viewed. 1) The software shall be able to superimpose a third-degree polynomial or a Manning formula curve over scatter plot dam, with user -specified upper and lower limits. 9) EXPORTING DATA A) The software shall export the data from any graph or table to an ASCII spreadsheet file in comma separated value format for analysis with other software. The file shall include a header identifying the type ofdam, units of measure, resolution, and number of significant digits for each column in the file, followed Teledyne Isco Flowlink Professional Software for Windows / Engineering Specifications