Laserfiche WebLink
<br />South Platte Water Rights Management System <br /> <br />Sheet. The only difference between the Water Information Sheet and the Checksheet <br />formulas is that references on the Checksheet take the form Rxx. where xx is the row <br />number of the value to be used in the formula. Formula values are not stored in the <br />database, but are calculated every time the checksheet is created. <br /> <br />5. Cumulative: a formula row that is stored in the database so its values can be <br />accessed. This row is exactly the same as a fannula row except that the computed <br />value is saved in the database when the user saves the Checksheet. Cumulative rows <br />have an additional argument-the row ID -which identifies the row in the database. <br />The saved values are referenced by rows of type carryover, which get values from the <br />previous day, or column. <br /> <br />6. Carryo'Ver: a row which gets the value from a cumulative row of the previous day. <br />this type of row takes three arguments: the indention level. the row ID of the carry- <br />over row from which yesterday's value is fetched, and the quoted text string which is <br />displayed as the row title on the Checksheet. If no value is present for the referenced <br />carryover row, this value defaults to zero. <br /> <br />Example: <br /> <br />locator 0 <br />string 0 "UPSTREAM ADMIN ACCTS" <br />flow 1 1 "Antero" <br />flow 1 2 "Eleven Mile" <br />flow 1 3 "Cheesman" <br />formula 0 "Tot Admin Accounts" R3 R4 + R5 + <br />string 0 <br />string 0 "UPSTREAM NAT FLOW" <br />flow 1 4 "Cheesman Natural" <br />flow 1 5 "Grant Gauge" <br />flow 1 6 "Roberts Tunnel" <br />formula 0 "Tot Upstream Natural" R9 RIO + Rll - <br />string 0 " " <br />locator 0 <br />string 0 "CHATFIELD RELEASE" <br />formula 0 "Required Release" R21 R31 + R40 + R52 - R61 - <br />flow 1 39 "Fish Hatchery" <br />flow 1 40 "CF Ditches Delivery" <br />formula 0 "Required Outlet ReI" R64 R65 - R66 - <br />flow 1 41 "Actual Outlet Rel" <br />string 0 " " <br />string 0 "CF ADMIN ACCOUNT" <br />carryover 1 42 "Carryover" <br />formula 0 "Checksheet" R67 R68 - 2 * <br />cumulative 0 42 "Cumulative" R71 R72 + <br />string 0 " " <br />string 0 "TOT SYSTEM ACCOUNT" <br />carryover 1 45 "Carryover" <br />formula 0 "CUrrentU R6 R72 + <br />cumulative 0 45 "Cumulative" R76 R77 + <br /> <br />10 <br /> <br />Administrators Manual <br />