Monthly Pumping SFWMD to Table
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
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.
In order to have full functionality of this tool, the user needs to complete the registration by following these steps:
After these steps, the authorization code will be sent to the email that you provided during the PayPal payment process.
Users can report bugs and send comments by email to firstname.lastname@example.org.
Created by Lago Consulting & Services LLC. © 2015. Last updated on 11/17/2015