Monthly Pumping SFWMD to Table

Purpose
This tool allows converting the monthly pumping report from the SFWMD into a table. Processing the data in those sequential reports may be difficult because

each well may be referred by using different well names,
application dates may not correspond to the end of the months, and
there may be pumping data not reported for some months and wells.

The tool allows the user to decode the well names used in the report. The output table contains the monthly pumping for each month and each well.

Usage
The user must specify the excel file and its worksheet to process, as well as the columns containing the permit number, the well name, the date, and the pumping amount.
The tool produces warnings and errors while trying to convert the rows in the excel file. Errors are usually related to well names that cannot be decoded, and the user can fix those by including new phrases to delete in the original well name or by adding new crosswalk relations between the desired and the excel well names.
A complete list of added features can be seen in the tab “Well Name Decoding”, which can be deleted by the user.
Adding and deleting phrases to delete and crosswalk relations in the tool’s GUI is the recommended approach. However, the user may opt to open the file “Documents\LagoToolbox\MonthlyPumpingSFWMD2Table_Data.csv” in a text editor in order to make changes in a more flexible and quicker way. In the last approach, the user may want to use a text editor (e.g. TextPad) that detects if a new version of this file has been saved by the tool.
The tool generates the output table as soon as all the error messages are fixed. However, in the case that the user modifies the original excel file or the decoding file “MonthlyPumpingSFWMD2Table_Data.csv”, the output table can be regenerated by pressing the button “Create csv File with Table”.
The free version allows the user to get pumping rates for the first three rows in the table (i.e., for the first three months).

Example of use
The screens shown below illustrate the processing of the excel file “11-00017-W City of Naples PWS.xlsx”, which is provided with the installation of the Lago Toolbox.

Registration
In order to have full functionality of this tool, the user needs to complete the registration by following these steps:

Go to the right-top corner in this tool, click on the “About” button, and copy the Mac address shown there.

In the tool’s webpage, use the box above the "Add to Cart" button to enter the Mac address. Then, click on the "Add to Cart" button right below to enter your payment information.

After these steps, the authorization code will be sent to the email that you provided during the PayPal payment process.

Support
Users can report bugs and send comments by email to [email protected].

Created by Lago Consulting & Services LLC. © 2015. Last updated on 11/17/2015

Questions?
Contact Us

Lago consulting and services understands the customer's risks when downloading or installing software from internet. The integrity of the software we offer here as well as the legitimacy of our company are ensured by our code signing certificate.

Free version available in the Toolbox or here
for an independent download.

If you are interested on purchasing this tool contact us for more information.