metering international · • network and meter asset management • remote connect/disconnect...

October 27, 2009, New York, NY USA

MDMS Implementation and Lessons Learned

Wayne Young Director Meter Reading, Billing & Collections

JEA Jacksonville, Florida

METERING INTERNATIONAL SMART ENERGY

EAST COAST

JEA at a Glance

– Originally “Jacksonville Electric Authority” • In 1997 JEA took over water and sewage for the city

• About 2100 permanent employees – Customer base

• 420,000 electric • 305,000 water • 231,000 sewer

– Service Territory: 900 square miles – 8 th Largest Municipal in the US


AMR Project Overview

• Main focus: customer service, system reliability and accuracy, and cost savings

• Replacement or retro‐fit of approx. 360,000 electric an 280,000 water meters to communicate with network

• Development of interfaces to JEA information systems including its customer information systems (CC&B), outage management system (OMS), field maintenance system (FMS), Meter Data Management System (MDMS) etc.


RF/Fiber Optic Network Meter Reading System

M e te r R FE

C e llM a s te r

`

C e lln e t S y s tem C on tro lle r

O C D B

M ic roC e ll C o n tro lle r (M C C )

R F T ra n sm iss io n : 1 w a y c om m un ica tio n T ra n sm its e ve ry 5 m in u te s

R F T ra n sm is s io n : 2 w a y com m un ica tio n T yp ica l c om m un ica tio n o n ce p e r d a y O n d em and c a p ab ility

L e a se d c ircu it: 2 w a y c om m un ic a tio n A lw a y s o n


720,000 METERS

32 MASTER CELLS

3,200 MICRO CELLS

Network center

Metering, Billing/CIS America 2008, San Diego, CA

JEA Territory – AMI Coverage


AMI Overview – AMI Coverage


AMI Overview – Micro Cell Locations

Why JEA Chose MDMS?

• Initial plan to use ‘new’ CIS (CAIR)

–JEA’s new Customer Information System (CIS) had not fully stabilized and adding complex interfaces to it was not feasible

• JEA built its own MDM system to store data, interface with vendor data base and eliminate/reduce new CIS interfaces

• Complexity and lack of internal SMEs in AMR lead to external vendor


– Single repository for all meter sources

– Easier access to meter data for analysis and business intelligence

– Interfaces to other essential systems (Outage management, System Planning, Data Warehouse, etc.)

–MDMS will be easier to change for BPL, mesh RF and other AMR technologies

– Easier to develop new exception processing in MDMS


Why JEA Chose MDMS?

–Customer, Operational, Revenue Enhancements • Network and Meter Asset Management

• Remote Connect/Disconnect

– Virtual Move In/Out

• Outage Management

• Distribution planning and engineering • Bellwether Meters for Outage Management

• Load Research and Management

• Leak detection, excessive consumption, etc.

Scope of Initial AMS MDMS Project


Other Read Sources

(FFDS, FMS, CC&B, etc.)

Other Read Sources

(FFDS, FMS, CC&B, etc.)

MV90 MV90

AMR (Cellnet) AMR

(Cellnet)

ITRON ITRON

MDMS

CC&B

GIS

Data Warehouse

• Daily usage • VEE •SLS Data •Interval usage

• Connectivity data

• Interval Data • Winter Peak • Summer Peak • NonCoincident Peak

• Customer data

Meter Reads Source Systems Data Repository BI Applications

Ad hoc Analytics

Canned Reports

GIS

0

10

20

30

40

50

60

70

80

90

1st Qtr 2nd Qtr 3rd Qtr 4th Qtr

East

West North

•Transformer non coincient peak •Transformer winter peak •Transformer summer peak

Business Intelligence

•Transformer peak threshold •Transformer peak by month

•Daily transformer load

• Daily Usage

Load Research

AMI System Flow & Business Intelligence


–MDMS Web Viewer (CSR/Billing Support/other areas)

–MDMS Interface to Outage Application • Special Outage Interface – Duval County School Board

–Load and Customer Research

AMI Overview – MDM System Interfaces


AMI Overview – MDMS Web Viewer


Daily reads for one month period

AMI Overview – MDMS Web Viewer


AMI Overview – Outage Map


Used during Tropical Storm FAY – August 2008

AMI Overview – Outage Map


Each extrapolation means an avoided AMRLAG read

0

500

1000

1500

2000

2500

3000

3500

4000

4500

Feb‐09 Mar‐09 Apr‐09 May‐09 Jun‐09 Jul‐09 Aug‐09

Electric

Water

Total


Extrapolation for electric and water reads

Extrapolated Reads Used for Billing

–Utilized Data • 15 Minute electric interval consumption (AMI / MV90, MDMS, Data Warehoue) • Daily electric and water consumption (MDM System) –Electric ‐ Load characteristics –Water ‐ Usage Statistics / Seasonal Indexes

Load and Customer Research


Electric Meters Currently Monitored “Today”

AMR (~2500) + MV90 (~1000) 3,500

Intervals per Day 96

Total readings per day 336,000

Total readings per year 122,640,000

Load Research Tallying The Data


• Using AMS Data – Develop table of factors to convert daily energy use into peak demand estimates

– Factors developed for high, medium and low customers

• Data Collection & Cleaning – Collected 15 minute interval data for one year –Very High Quality AMR Data –Validation, Estimation & Edit (VEE) Process

Transformer Load Management (TLM) Factors


– Aqua Lines show 15 Min Interval Data Missing from Data Warehouse

– Multiple reasons: Data ‘Stuck’ in MDM System, network wide issue for example early Nov data missing across all accounts

– Missing data is experienced with all rate classes

Visualize IT Energy Print – AMR Res Customer 15 Minute Interval Data

Current AMIMDM Data Challenges


AMI Electric Outputs – Load Research Interruptible Customers Hourly KW MV90 Meter Readings on 080707

Service Point

Customer Name 1:00 3:00 5:00 7:00 9:00 11:00 13:00 15:00 16:00 18:00 23:00

271620939 VARIOUS C/I CUSTOMERS 1,755.00 1,962.60 1,849.20 2,154.30 1,624.50 2,080.50 1,988.70 1,915.20 1,856.10 2,091.00 1,720.50 3298800400 34.56 30.72 34.56 30.72 34.56 26.88 26.88 34.56 30.72 34.56 34.56 1298800258 11,445.12 13,995.36 12,227.04 13,908.96 13,700.16 10,333.44 8,688.96 10,277.28 10,620.00 10,458.72 13,102.56 4347910179 82.62 85.26 83.34 265.80 388.44 495.72 496.80 493.38 493.80 494.94 189.18 1603910253 1,008.84 1,082.65 1,018.29 1,068.48 1,065.22 1,019.76 1,019.34 924.42 894.18 853.65 962.43 7098100530 4,672.80 4,756.32 4,728.24 4,620.96 4,634.64 4,631.04 4,735.44 4,722.48 5,049.36 4,929.12 5,172.48 7103330884 297.90 299.78 324.15 310.73 315.45 298.05 301.13 306.15 321.53 303.60 321.38 1861900152 8,146.56 8,471.04 8,443.20 8,410.56 8,174.40 8,440.32 8,198.40 8,428.80 8,291.52 8,111.04 7,985.28 2312920580 1,158.99 1,178.41 1,041.28 1,139.88 1,185.87 1,058.50 1,083.18 1,056.09 1,063.96 1,169.28 1,008.21 5060600050 1,076.16 1,097.76 1,095.84 1,133.52 1,154.16 1,143.12 1,167.72 1,349.64 1,189.68 1,215.96 1,175.28 2072810975 231.68 227.96 224.68 218.88 248.40 242.48 227.32 233.08 248.28 233.68 238.28 1057700599 268.86 242.22 226.92 344.46 388.56 417.30 450.72 439.86 470.10 455.04 450.42 6679910067 367.20 372.24 380.25 454.14 518.67 532.98 520.02 427.59 424.71 401.58 361.17 1650600276 21,898.80 22,876.00 22,565.20 22,500.80 21,271.60 10,208.80 6,358.80 14,400.40 18,068.40 17,964.80 21,683.20 4294400683 317.34 356.85 456.84 489.96 680.67 994.14 861.66 907.29 956.61 975.60 345.33 4690120687 423.79 455.90 518.18 479.23 435.31 470.74 525.31 508.32 529.99 482.40 451.37 7372920427 5,916.00 5,826.00 5,779.20 5,778.00 5,800.80 5,493.60 5,869.20 5,470.80 5,636.40 5,748.00 5,684.40 7456920914 847.39 839.49 829.95 771.33 780.22 782.34 808.26 809.54 807.39 755.01 854.27 Hourly Total Interruptible Load MW 82.52 86.38 84.13 88.67 86.34 77.25 72.19 81.28 85.07 80.12 86.09

8610810406 VARIOUS C/I CUSTOMERS 1,746.64 1,760.64 1,753.92 1,794.80 1,816.08 1,839.04 1,885.52 1,866.48 1,859.76 1,857.52 1,841.28 5046620135 1,018.68 993.36 987.36 1,014.72 1,037.16 1,130.16 1,228.68 1,245.12 1,244.04 1,232.76 1,061.04 5080695950 1,179.30 1,148.10 1,139.20 1,160.70 1,153.20 1,301.70 1,341.70 1,402.40 1,389.40 1,427.60 1,224.40 7012500939 99.36 101.28 83.04 240.00 1,845.12 2,583.36 2,385.12 2,516.16 1,264.32 1,048.80 68.16 2467420688 255.00 265.30 260.50 268.70 285.70 313.10 336.20 334.90 339.20 330.60 279.50 272710030 400.49 394.15 386.67 435.42 554.84 585.64 521.49 524.22 501.86 464.46 377.08 1974110507 62.90 62.85 63.53 65.50 67.04 67.87 68.30 66.94 66.90 65.12 62.25 7791800792 229.56 218.88 225.12 219.24 209.52 210.60 207.96 207.12 213.36 212.04 215.64 3055800469 462.00 465.50 480.00 470.60 477.00 481.20 478.00 492.70 499.80 493.30 491.70 Hourly Total Curtailable Load MW 13.95 13.84 13.71 14.50 16.94 18.49 18.61 17.84 16.72 16.02 13.95

Hourly Total Interrupti ble/Curta ilable Load MW 96.47 100.22 97.84 103.17 103.28 95.74 90.80 99.12 101.79 96.14 100.04

• ~60 Interruptible/Curtailable Customers • Summer Peak: 07Aug at 4:00 PM 102 MW available for DSM Consideration • Winter Peak: 30Jan at 7:00 AM 118 MW Available for DSM Consideration


MDM Water Outputs – Load Research Customer Name Winter Summer Win/Sum Index

Usage Indicator

VARIOUS C/I CUSTOMERS 52,421,062.91 HS/LW** 2,954,003.54 48,749,058.50 0.060596115 HS/LW 5,570,006.68 38,521,046.23 0.144596454 HS/LW 10,318,012.38 39,182,047.02 0.263335205 HS/LW 16,336,019.60 52,255,062.71 0.312620802 HS/LW

981,376.00 2,861,100.00 0.343006536 HS/LW 15,512,018.61 35,010,042.01 0.443073408 HS/LW 13,780,016.54 29,456,035.35 0.467816404 HS/LW 18,864,560.00 39,935,720.00 0.472373104 HS/LW 7,146,008.58 14,819,017.78 0.482218773 HS/LW 58,525,016.00 115,330,138.40 0.507456393 HS/LW 11,320,013.58 21,385,025.66 0.529342997 HS/LW 39,120,046.94 70,130,084.16 0.557821189 HS/LW 25,789,030.95 44,129,052.95 0.584400281 HS/LW 27,939,033.53 45,858,055.03 0.609250294 Neutral 38,315,045.98 53,705,064.45 0.713434503 HW/LS*** 69,847,083.82 93,001,111.60 0.751034935 HW/LS 23,887,028.66 29,379,035.25 0.813063753 HW/LS 26,385,700.00 32,272,460.00 0.817591841 HW/LS 14,370,017.24 9,846,011.82 1.459475929 HW/LS 33,122,039.75 5,001,006.00 6.623075385 HW/LS

• Monthly Usage from MDM of Top Water Users • Winter: Dec thru Feb and Summer: May thru Sep • 0.6 is Neutral Customer (HS/LW < 0.6, HW/LS > 0.6)


– Customer • Household usage rates with comparable homes • Real time notification of higher than expected usage

• Customer access through Google • Partnership with Commercial Customers for DSM implementation

– Engineering and Operations • Water hydraulic model calibration • Water and Wastewater system optimization

Business Enablement


– Partner with the right vendor

• AMR/MDMS is a new field for most utilities and so, finding internal resources with right skills/experience will be difficult

– Develop separate system to house data and interface with other systems

• CIS is not the right system

Lessons Learned


–Manage stakeholder expectation

• Requirements will be fuzzy at best. New requirements will be surfacing as you deliver basic functionality. You must have a process to enhance the functionally delivered at the same time as you are adding new functionality.

– Use Six Sigma or other quality tools during the project to run things smoothly

Lessons Learned


–Must have the highest level of sponsorship and buy‐in

• Have a vision/plan to use data beyond billing

• Identify short and long term owners

– New method of doing business

• Advanced Metering Systems Steering Committee established to provide formal structure and process for planning, decision making and policy recommendations to support AMS

Lessons Learned


Wayne Young Director Meter Reading, Billing & Collections JEA

21 West Church St. Jacksonville Florida, 32202

Office: 9046657728 email: [email protected]

Questions?


AMS System Performance

89.0

91.0

93.0

95.0

97.0

99.0

Monthly Billing Read % Electric

Daily Read % Electric

Monthly Billing Read % Water

Daily Read % Water

Merrill Rd Cellmaster down from May 12 to May 20


Current AMI‐MDM Data Challenges

Visualize IT Energy Print – AMR Commercial Customers 15 Minute Interval Data – Aug to Feb

– Pulled ~300 Sample Points from ~2500 AMR Load Profile Accounts (6 Samples Shown Above)

– Aqua Lines show Interval Data Missing from DW. Multiple reasons: Data ‘Stuck’ in MDM System, network wide issue for example early Nov data missing across all accounts


AMI Electric Outputs – Load Research Interruptible Customers Hourly KW MV90 Meter Readings on 013007

Service Point

Customer Name 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 24:00

271620939 VARIOUS C/I CUSTOMERS 1,995.00 2,233.80 2,220.90 1,884.90 1,951.80 2,223.90 2,135.70 2,212.20 2,111.10 2,310.30 2,114.70 2,224.50 3298800400 32,739.84 35,343.36 37,071.36 33,446.40 35,919.36 34,440.96 35,765.76 28,800.00 35,646.72 35,324.16 35,846.40 32,413.44 1298800258 10,477.44 11,592.00 11,756.16 11,116.80 11,900.16 12,067.20 11,197.44 11,937.60 11,113.92 11,378.88 11,364.48 13,524.48 1099530307 129.60 110.88 80.64 77.76 79.20 108.00 2,520.96 4,641.60 3,860.64 4,748.16 4,513.44 113.76 5720300297 6,663.83 6,862.28 6,810.30 6,678.00 6,934.73 6,745.73 6,700.05 6,591.38 6,507.90 6,733.13 6,578.78 6,358.28 7586600379 2,285.28 2,362.50 2,234.34 1,962.36 1,924.20 1,857.78 1,826.64 1,879.74 1,402.92 1,356.48 1,602.18 2,361.42 7573800553 370.80 417.15 390.69 378.27 387.54 457.74 421.65 475.47 459.72 447.66 478.80 437.13 2312920580 526.68 603.75 646.27 642.07 649.42 649.84 622.44 500.43 481.85 463.58 566.27 402.99 5060600050 1,319.40 1,145.76 1,235.88 1,050.24 1,317.48 1,113.96 1,091.28 1,182.24 1,108.68 1,114.68 1,304.28 1,128.48 2072810975 212.24 208.56 212.60 214.88 210.44 184.44 178.48 221.08 235.04 234.72 232.60 231.60 1057700599 383.16 363.66 306.48 197.34 192.42 271.44 371.64 391.74 363.96 361.50 382.92 420.66 2139196838 156.80 156.20 152.20 152.90 155.00 237.70 464.20 469.60 482.30 482.50 476.70 434.40 1650600276 13,932.80 14,512.40 13,983.20 12,930.40 11,527.60 8,724.80 7,145.60 4,698.40 3,948.00 6,739.60 6,652.80 6,092.80 2258085055 86.58 86.04 88.11 83.25 90.27 91.98 92.70 79.02 78.84 74.16 71.10 83.25 4294400683 428.83 434.11 463.78 508.13 604.70 746.88 814.66 1,079.04 1,216.61 1,031.90 961.06 371.52 4690120687 461.30 432.86 418.39 453.46 470.09 489.38 491.47 458.71 456.55 450.22 478.37 474.84 7372920427 12,420.00 11,911.20 11,542.80 11,650.80 12,121.20 11,946.00 11,157.60 10,448.40 10,532.40 10,573.20 10,480.80 12,254.40 7456920914 714.82 696.48 679.10 687.74 623.62 495.84 665.09 562.18 532.80 671.14 664.03 776.54 Hourly Total Interruptible Load MW 108.30 112.52 113.13 107.03 110.16 106.36 107.38 100.84 105.10 108.92 109.31 103.81

8610810406 VARIOUS C/I CUSTOMERS 1,601.04 1,588.72 1,591.52 1,587.60 1,591.52 1,597.12 1,600.48 1,629.60 1,629.04 1,638.00 1,648.08 1,607.76 5046620135 957.36 952.68 959.16 957.36 949.80 955.80 966.48 965.88 944.16 955.32 959.76 945.24 8507067450 236.64 239.91 243.06 235.20 226.98 242.73 239.94 233.34 287.13 342.57 308.91 271.17 7012500939 36.48 35.04 35.52 35.52 34.56 42.72 755.52 996.96 2,561.28 2,276.64 2,119.68 36.00 2467420688 234.07 242.21 232.06 234.07 246.67 254.95 279.79 316.66 288.72 270.86 265.75 240.41 272710030 309.14 327.10 317.50 310.46 319.88 321.64 367.93 409.02 414.22 422.14 406.56 294.98 1974110507 59.63 59.84 60.29 60.97 61.10 63.01 63.94 67.14 70.21 72.04 73.53 60.76 7791800792 141.48 138.12 133.80 142.56 143.16 138.72 138.48 131.76 131.52 129.48 129.12 130.20 3055800469 429.50 424.00 439.20 438.00 434.10 444.80 442.70 434.40 445.60 451.10 441.90 432.40 Hourly Total Curtailable Load MW 10.92 10.90 10.89 10.28 9.59 9.77 10.73 11.37 13.21 13.27 13.21 9.84

Hourly Total Interrupti ble/Curtai

119.22 123.42 124.02 117.31 119.76 116.13 118.12 112.21 118.32 122.19 122.52 113.65

§ ~60 Interruptible/Curtailable Customers § Winter Peak: 30Jan at 7:00 AM § I/C Coincident Peak (CP) 118 MW Available for DSM Consideration


metering international · • network and meter asset management • remote connect/disconnect...

Documents