CIMS Charger Information Management System Presented By: Clean Fuel Connection Inc.

1. CIMS Charger Information Management System Presented By: Clean Fuel Connection Inc. Prosum Technology Consulting

2. Agenda • Issues Identified by Infrastructure Working Group Stakeholders • Potential Solution – Charger Information Management System (CIMS) • Issues faced by automakers, public policy makers, charger manufacturers and distributors in finding maintaining infrastructure information • Development of CIMS as a Solution • Capabilities of CIMS - System Demonstration • Recommendations

3. Background • Infrastructure Needs Assessment Issues Identified by Infrastructure Stakeholder Working Group: • Identify existing charger and vehicle population - inductive and conductive - small paddle and large paddle - public and private • Match infrastructure needs to projected vehicles - maintain inductive infrastructure as long as cars on the road • convert additional large paddle chargers to small paddle if needed for small paddle vehicles • add conductive chargers to inductive only sites • convert inductive chargers to conductive • repair chargers (particularly out of warranty) • add public chargers where needed by drivers • develop sustainable maintenance and repair program • Find funding sources

4. Problems with Current Situation Identified by Needs Assessment Sub-Committee • Lack of real-time accurate information about chargers: • For drivers - Location information - address/charger type/charger quantity/access/ directions/site contact - Operational Status - Availability—in use? ICE’d? • For site owners - Usage (for site owners) - Electricity Cost - Operational Status, Warranty Status - For OEMs • Accurate information on locations and types of chargers • For Manufacturers • Warranty information • Charger history, Location history • Charger site contacts • - For Public Policy Makers • Gaps in charger infrastructure • Strategically plan and design future infrastructure

5. Problems with Current Situation Identified by Needs Assessment Sub-Committee • No system in place to obtain and maintain accurate information on chargers—information quickly becomes obsolete • Information gathering process is labor intensive • Inventories, locations, and status manually recorded and maintained on excel files/spreadsheets • Information is never readily available from any source • Inconsistent information on various websites • No communication with public charger site owners • No continuity for charger maintenance, service, or modifications • Dependent on users to report information – users discover charger inoperable when they need to use it • No ongoing communication with Fleets (I.e. SCE/LADWP/SMUD//Military) who maintain their own internal infrastructure • No process to acquire updated information on installations, service, or public access sites • No feedback loop on charger service and failure data with manufacturer or service provider • Trend analysis • Product improvements • Retrofit campaigns

6. Previous Efforts—Edison EV • No database, each customer estimate was a unique Excel file • Charger serial numbers and locations kept in Excel spreadsheet, not consistently updated • Updates very labor intensive, had to visit site to collect charger S/N • No customer data base for analysis of costs, trends, notifications, infrastructure planning, etc.

7. Previous Efforts—Edison EV • Unable to identify locations for self installed chargers • Unable to easily update public charging lists • Unable to manage service parts inventories with service contractors • Difficult to provide real time information on out-of-service chargers and locations • Difficult to respond to simple data requests – how many public chargers, fleet chargers, residential chargers, average installation costs, etc. • Unable to track warranty status • Unable to identify customers entitled to special campaign incentives, discounts, etc.

8. Lessons Learnedfrom Edison EV Experience • The infrastructure process is fragmented and needs to be connected • Manufacturer, distributor, service provider, user, owner • Sustainability of the infrastructure requires continuous communication – real time feedback • Need a solution that allows continuous update of information for all stakeholders in the normal course of business

9. Development of CIMS • Problem carried over to SMUD and CFCI • GMATV consults with Prosum • Conducted process analysis with SMUD/CFCI • Main problem was fragmented data flow – no connectivity, delayed communication, no data control

10. Analysis Results • Need for a common database system • consistent, efficient data collection • establish accountability and control of the workflow management process • Make user data an output of the infrastructure management data • installation location data, service status, notifications • Integrate user feedback (EV owners, Fleets, Public Site owners) • via website / Internet • prescribed data forms

11. CIMSBackground • GM and Southern Company were developing similar database systems • same problem, similar solution paths • ability to track charger location, history, & repair records • a tool for analysis • Prosum purchased Southern Company’s system and expanded it to be GM’s charger database

12. CIMS: Workflow ManagementSystem User Data Location / Mapping / Status Operational Data Sales / Installation / Warranty / Service Internet Web Site Manufacturer Distributor Service Provider Users GMATV CFCI AER MagneCharge EV1 Owners Web Based Front End Southern Company Web Based Front End Web Based Front End Web Based Front End Web Based Front End CIMS Central Database

13. Abilities of CIMS • Real-time data feeds from distributors and service providers to a centralized database • Always up-to-date: eliminate need for ad hoc data discovery, merging and updates • Maintains full history of sites • Ability to provide email or pager notification to service providers

14. Abilities of CIMS • Track chargers / fueling station locations, technology, manufacturer, warranty, etc • Can query database to create standard reports or one-time reports for infrastructure management • Provides low-maintenance data feed to online charger location and trip planning tools

15. Abilities of CIMS • Can be extended to support other user information services: • information web sites • handheld and wireless devices • vehicle navigation systems and on-board services, e.g. Onstar

16. System Data Flow Locator Web Site Distributors Install & Service Info Locator Info CIMS Reporting, warranty tracking Charger Manufacturers Handheld Devices Vehicle Nav Systems Onstar Public Agencies Reporting

17. Distributors Front End CIMS

18. Front End Distributors CIMS

19. CIMS Charger Manufacturers Back End

20. CIMS Charger Manufacturers Back End

21. CIMS Charger Manufacturers Back End

22. Web Mapping CIMS

23. Web Mapping CIMS

24. CIMS

25. CIMS SolutionWhat Does It Mean To You? Provides the ability to connect, communicate, and control through a Workflow Management System

26. CIMS Vision: Shared Workflow Management System User Data Location / Mapping / Status Operational Data Sales / Installation / Warranty / Service Internet Web Sites Users Consumer / Fleet Manufacturer Distributor Service Provider GMATV CFCI AER MagneCharge EV1 Owners EVI Southern Company EV1 Club SCE AVCON Calstart LADWP TAL / TICO NREL Municipalities CIMS Central Database CARB, AQMD, CEC Reports

27. Sample Outputs of CIMS • Ongoing updates to public charging websites • Changes to charging locations • Broken or repaired chargers • Analysis of small paddle and large paddle inductive locations • Develop list of sites to be converted • Analysis of sites with inductive charging only • Develop list of sites to add conductive • Analysis of areas that need charging infrastructure • Develop priority list for new charging infrastructure • Development of charger maintenance and repair program • Chargers out of warranty • Failure rates • Problematic locations

28. Recommendations • Use CIMS as the tool to • Collect charger information statewide • Connect all the infrastructure stakeholders • Provide ongoing updates to a database • Assess scope of work for system implementation • Coordinate needs of all stakeholders so that correct information is gathered • Complete collection and validation of charger information statewide • GM info complete, need conductive and TICO (small paddle) charger data • Develop links between stakeholders so that each can feed updates into the database and receive updates back • Develop reports so that required information is fed directly to each stakeholder in appropriate format for their application • i.e. would provide updates that could incorporated into Clean Car maps or EV1 Club website without re-entering data • Maintenance of database – server, backup, security

29. Recommendations • Develop funding requirements • Establish plan to be self-sustaining in 3 years • Impute system maintenance cost into out-of-warranty service contracts • Fee for specific reports or queries

30. End