LAGO   Consulting   &   Services LLC
    • Home
    • About Us
      • The Company
      • Leadership
      • Certifications
    • Services
      • Modeling Services
      • Consulting Services
      • Software Development >
        • Fill Sinks Plus
        • HEC-RAS to MIKE11
        • SWMM5 to Shp
        • Lago Toolbox
    • Projects
    • FAQ/Contact
    • LAGO-LG2 JV
  • MENU

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
  1. each well may be referred by using different well names,
  2. application dates may not correspond to the end of the months, and
  3. 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.
Picture
Picture
Picture

​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.
Picture
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 support@lago-consulting.com.  
 
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.
Picture
If you are interested on purchasing this tool contact us for more information. ​
Picture
  • Home
  • About Us
    • The Company
    • Leadership
    • Certifications
  • Services
    • Modeling Services
    • Consulting Services
    • Software Development >
      • Fill Sinks Plus
      • HEC-RAS to MIKE11
      • SWMM5 to Shp
      • Lago Toolbox
  • Projects
  • FAQ/Contact
  • LAGO-LG2 JV
Modeling Services
Picture

- Data mining & Processing
- Conceptualization & Setup
- Sensitivity Tests
- Model Calibration
- Model Telescoping
- Design Storm Simulations
- Scenario Evaluations
​- Post-Processing of results
- Peer review
- Model QA/QC
- Mass balance checks
- Fixing numerical instabilities
- Calibration/validation checks
​- Reservoir Storage Modeling
- GIS data mgmt. and tools

Consulting Areas
Picture

- Natural resources planning
- Stormwater management
- Groundwater management
- Surface water structure design
- Water supply planning
- Species and sediment transport
- Salt water intrusion
- Floodplain delineation & management
- Floodway Encroachment Analysis
​- Urban and coastal flooding
- Water quality studies
- Wetland conservation and restoration
- Wellhead protection area delineation
- Landscape ecology
- Water regulations permitting

Featured Software
Picture

MIKE 11
MIKE SHE
MIKE21
ECOLab
MODFLOW
GWV (Vistas)
MODHMS
​GIS-ArcMap

HEC-RAS
​HEC-HMS
EPA-SWMM
​XP-SWMM
ICPR
​RiverFlow2D
WASP
HSPF

Software Development
Picture

Spreadsheet modeling
File format converters
Pre- & post-processing tools
A la carte software (C#, Python, etc)


Employee Login   ​
         About    |    Terms  and Conditions    |    Privacy Policy    |    Certifications    | ​   Tools    |    Contact us     
Picture
4237 Henderson Blvd #201, Tampa FL 33629.   |   P.O. Box 10481, Tampa, FL, 33679   |   813-774-5559
www.lago-consulting.com & Lago Consulting & Services LLC.    © 2023  All Rights Reserved