SCADA Reporting - PowerPoint PPT Presentation


Title: SCADA Reporting


1
  • SCADA Reporting
  • Partnering For Successful Implementation and
    Continued Development in Ontario
  • OWWA Annual Conference
  • Niagara Falls, May 8, 2012

2
Co-Authors Acknowledgements
  • Jason Low, Sharmane Propper
  • Eric Tietz Eric_at_Thinklearning.com
  • Tim Sutherns
  • Michael OMeara York Region
  • Karen McMillan Township of Centre Wellington
  • Mike Linschoten Region of Halton

3
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

4
NO R in SCADA
  • We saw a need in the industry
  • Reporting requirements often as an afterthought
  • Solutions often developed with significant
    investment in custom programming or complex model
    set-up
  • The report controller/bottleneck
  • Succession planning
  • Eramosas opportunity to give back to the
    industry

5
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

6
Benefits of the Application
  • Open source and web based
  • Designed for the municipal water and wastewater
    industry
  • Reports are configured rather than programmed
  • Enables all users to configure, view and share
    reports
  • Report distribution via e-mail and on a schedule
  • Low overhead and start-up costs
  • Very easy to acquire report configuration skills
  • The User Group Approach

7
e.SCADA.r Partners
User Group Service Population gt 4 Million People
8
Anticipated e.SCADA.r Partners This Quarter
Service Population an additional gt 2 Million
People
9
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

10
York Region
11
York Region
  • 90 Water Facilities with gt 150 km Mains
  • WPCPs that discharge to Lake Simcoe, Lake Ontario
    and local rivers
  • 3200 historian tags
  • 35 local collectors (iFix and Fix32)
  • Centralized Proficy Historian for SCADA data

12
York Region - Issues
  • Complex tools discourage users
  • Separate SCADA network limits access
  • Data contention between sources
  • High number of tags is confusing for end users

13
York Region Why e.SCADA.r
  • Faster than OEM portal
  • Easy to configure/upgrade/migrate
  • Low overhead
  • Directly accesses operational data
  • No client software required
  • Collaborative support
  • Code sharing
  • Genuine interest in product by developer

14
York Region - Benefits
  • Improved User Experience
  • Increased functionality and data integration
  • No client application to download or install
  • Near real time access to data
  • Customizable
  • Automated report delivery

15
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

16
Halton Region
  • Primarily Implemented For Water
  • Three Well based systems
  • Three lake based systems

17
Halton Region - Issues
  • Historically large and cumbersome reports
  • Ministry of Environment
  • Council
  • Budgeting
  • Research
  • Different reporting for lake well based systems
  • Time consuming

18
Halton Region Implementation
  • Burloak WPP commissioning 2009 e.SCADA.r pilot
  • Comparison trials versus existing Excel reporting
    program
  • built trust
  • improved staff participation
  • Initial reports were produced in tandem with
    existing reports and compared daily for accuracy
  • As confidence built - Ministry of Environment
    Compliance reports were generated and presented
    during site inspection

19
Halton Region Benefits Before vs. After
  • Before
  • Preparatory work for MOE inspection could take
    weeks
  • Creating parameters and criteria
  • Downloading of data for many parameters time
    consuming and difficult UV dose/Transmittance/flo
    ws/intensity
  • Review of data very labour intensive prior and
    during inspection
  • After
  • Review of data much faster and in more detail
  • Regulatory data review graphically
  • Daily reports can be downloaded, saved as PDF
    documents and sent to MOE inspector prior to
    inspection
  • Time prior to inspection to gather data if
    requested
  • Estimated that MOE inspection times cut in half

20
Halton Region - Benefits
  • 63 staff members currently have access and use
    the reporting program
  • Less than 20 originally trained
  • The trainees become the trainers

21
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

22
Centre Wellington
  • Largest Towns are Fergus and Elora
  • Total Population 26,049
  • Approximately 407 km2
  • Numerous Remote Facilities - WAN

23
Centre Wellington Water System Network Layout
24
Centre Wellington - Response to Low Chlorine
Residual
25
Centre Wellington
  • Data query
  • Review exacttime frame
  • Any related parameters

26
  • Detaileddata dumpfor MOEreview ofissue
  • Nextlowest1.05

27
Centre Wellington Monthly Summary
  • Excellent review platform with comments captured

28
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

29
User Group Seminar 1 Ideas
  • Standard MOE reporting templates/formats
  • Geospatial links, graphic browsing interface
  • Overlapping data from different time periods
  • External data source links
  • LIMS, Rainfall, CMMS, AM systems, Geospatial
  • Manual data entry and Calculated data storage

30
Release of Version 1.0
  • Modularized Design
  • Enterprise Application
  • BIRT Reporting Engine Business Intelligence
    Reporting Tool
  • Enhanced Web-Based Report Designer Interface

31
Version 1.0 Planned Add-ons
  • MOE Report Formats
  • External Data Links
  • Manual Calculated Data Entry/Storage
  • Geospatial Links

32
  • SCADA Reporting
  • Partnering For Successful Implementation and
    Continued Development in Ontario
  • Questions?
  • dennis.mutti_at_eramosa.com
View by Category
About This Presentation
Title:

SCADA Reporting

Description:

SCADA Reporting Partnering For Successful Implementation and Continued Development in Ontario OWWA Annual Conference Niagara Falls, May 8, 2012 – PowerPoint PPT presentation

Number of Views:198
Avg rating:3.0/5.0
Slides: 33
Provided by: Jason457
Learn more at: http://www.hydrantnsi.com
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: SCADA Reporting


1
  • SCADA Reporting
  • Partnering For Successful Implementation and
    Continued Development in Ontario
  • OWWA Annual Conference
  • Niagara Falls, May 8, 2012

2
Co-Authors Acknowledgements
  • Jason Low, Sharmane Propper
  • Eric Tietz Eric_at_Thinklearning.com
  • Tim Sutherns
  • Michael OMeara York Region
  • Karen McMillan Township of Centre Wellington
  • Mike Linschoten Region of Halton

3
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

4
NO R in SCADA
  • We saw a need in the industry
  • Reporting requirements often as an afterthought
  • Solutions often developed with significant
    investment in custom programming or complex model
    set-up
  • The report controller/bottleneck
  • Succession planning
  • Eramosas opportunity to give back to the
    industry

5
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

6
Benefits of the Application
  • Open source and web based
  • Designed for the municipal water and wastewater
    industry
  • Reports are configured rather than programmed
  • Enables all users to configure, view and share
    reports
  • Report distribution via e-mail and on a schedule
  • Low overhead and start-up costs
  • Very easy to acquire report configuration skills
  • The User Group Approach

7
e.SCADA.r Partners
User Group Service Population gt 4 Million People
8
Anticipated e.SCADA.r Partners This Quarter
Service Population an additional gt 2 Million
People
9
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

10
York Region
11
York Region
  • 90 Water Facilities with gt 150 km Mains
  • WPCPs that discharge to Lake Simcoe, Lake Ontario
    and local rivers
  • 3200 historian tags
  • 35 local collectors (iFix and Fix32)
  • Centralized Proficy Historian for SCADA data

12
York Region - Issues
  • Complex tools discourage users
  • Separate SCADA network limits access
  • Data contention between sources
  • High number of tags is confusing for end users

13
York Region Why e.SCADA.r
  • Faster than OEM portal
  • Easy to configure/upgrade/migrate
  • Low overhead
  • Directly accesses operational data
  • No client software required
  • Collaborative support
  • Code sharing
  • Genuine interest in product by developer

14
York Region - Benefits
  • Improved User Experience
  • Increased functionality and data integration
  • No client application to download or install
  • Near real time access to data
  • Customizable
  • Automated report delivery

15
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

16
Halton Region
  • Primarily Implemented For Water
  • Three Well based systems
  • Three lake based systems

17
Halton Region - Issues
  • Historically large and cumbersome reports
  • Ministry of Environment
  • Council
  • Budgeting
  • Research
  • Different reporting for lake well based systems
  • Time consuming

18
Halton Region Implementation
  • Burloak WPP commissioning 2009 e.SCADA.r pilot
  • Comparison trials versus existing Excel reporting
    program
  • built trust
  • improved staff participation
  • Initial reports were produced in tandem with
    existing reports and compared daily for accuracy
  • As confidence built - Ministry of Environment
    Compliance reports were generated and presented
    during site inspection

19
Halton Region Benefits Before vs. After
  • Before
  • Preparatory work for MOE inspection could take
    weeks
  • Creating parameters and criteria
  • Downloading of data for many parameters time
    consuming and difficult UV dose/Transmittance/flo
    ws/intensity
  • Review of data very labour intensive prior and
    during inspection
  • After
  • Review of data much faster and in more detail
  • Regulatory data review graphically
  • Daily reports can be downloaded, saved as PDF
    documents and sent to MOE inspector prior to
    inspection
  • Time prior to inspection to gather data if
    requested
  • Estimated that MOE inspection times cut in half

20
Halton Region - Benefits
  • 63 staff members currently have access and use
    the reporting program
  • Less than 20 originally trained
  • The trainees become the trainers

21
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

22
Centre Wellington
  • Largest Towns are Fergus and Elora
  • Total Population 26,049
  • Approximately 407 km2
  • Numerous Remote Facilities - WAN

23
Centre Wellington Water System Network Layout
24
Centre Wellington - Response to Low Chlorine
Residual
25
Centre Wellington
  • Data query
  • Review exacttime frame
  • Any related parameters

26
  • Detaileddata dumpfor MOEreview ofissue
  • Nextlowest1.05

27
Centre Wellington Monthly Summary
  • Excellent review platform with comments captured

28
AGENDA
  • The Need
  • Reporting Tool and Approach
  • York Regions Experience
  • Halton Regions Experience
  • Centre Wellingtons Experience
  • Plans

29
User Group Seminar 1 Ideas
  • Standard MOE reporting templates/formats
  • Geospatial links, graphic browsing interface
  • Overlapping data from different time periods
  • External data source links
  • LIMS, Rainfall, CMMS, AM systems, Geospatial
  • Manual data entry and Calculated data storage

30
Release of Version 1.0
  • Modularized Design
  • Enterprise Application
  • BIRT Reporting Engine Business Intelligence
    Reporting Tool
  • Enhanced Web-Based Report Designer Interface

31
Version 1.0 Planned Add-ons
  • MOE Report Formats
  • External Data Links
  • Manual Calculated Data Entry/Storage
  • Geospatial Links

32
  • SCADA Reporting
  • Partnering For Successful Implementation and
    Continued Development in Ontario
  • Questions?
  • dennis.mutti_at_eramosa.com
About PowerShow.com