140 likes | 156 Views
Explore past and future processes, software solutions, and enhancements for a revamped UN GHG inventory system. Learn about upcoming timelines, system benefits, and plans for the 2010 gap year. This presentation covers existing process flows, future web-based flows, 2008 shortcomings, and proposed software solutions for improved data entry, validation, estimation, and reporting. Agency focal points will benefit from a new, crash-free office calculator, streamlined data reporting, and enhanced reporting tools. Obtain insights on timelines, training, and actionable steps for a more efficient GHG inventory reporting system.
E N D
The UN GHG Inventory Shoa Ehsani SUN Geneva, Palais de Nation, February 2010
Today’s presentation • How things worked in the past (2008) • What we are suggesting for the future “to be” system solution • Interim enhancements for the 2010 gap year • Time lines for our work
Today’s presentation • How things worked in the past (2008) • What we are suggesting for the future “to be” system solution • Interim enhancements for the 2010 gap year • Time lines for our work
Specific Issues with Calculator and Data • Office GHG Calculator: • Large: can only open one at a time • Difficult to e-mail • Compatibility with older Excel programs • Bugs in the programming resulted in some crashes • Emission Factors not available for all activities • ICAO Travel Calculator: • Excellent accuracy but needed very precise data format to work • Would reject data if exact routing was not available, needs scalability • No default class, difficult when entering 20,000 flights (this should be economy) • Didn’t have all airport codes, also some flights are from military bases • Need to wait for data-pack to update calculator’s flight information every year • Data Gathering: • Not able to get all field offices to reply • Manual not translated into all UN languages • Mining data from central ERPs not always easy or possible (e.g. Agency flight records) • No light-and-easy reporting document
Future “To Be” Software Solution Fully web-based system to include: • Online data entry • Data feeds from ERP systems • Support manual data collection (flat file for Field Offices without internet access • Workflows for managing data collection and approval • Data validation/quality checks • Data estimating and extrapolation support • Emission factor management • Dashboards and flexible reporting • Help menus and multi language support Schedule TBD, dependent on funding and resources
Benefits to Agency Focal Points • The new GHG office calculator will be on the web and will not crash! • Ability to report and upload data as early as you like. • “Many hands make light work” – every office/ node can report by themselves. • Ability to verify data on a continuous basis and edit data.
Enhancements for 2010 Gap Year Enhancements are on the way to make reporting of 2009 data more efficient and accurate: • Simplified data entry spreadsheet (flat file) for GHG and travel data • Same “look and feel”, small file size, no “bugs” • More user friendly • User Manual updates • Address data collection, data extrapolating, etc. • Enhanced “back end” tool • To be developed by DFS • Accept upload of data collection spreadsheets • Incorporate GHG emission factors and calculations • Improved reporting of GHG emissions • Training/ Workshops • Need to on training topics? • Timing, when should this happen?
Timelines For SUN Work Q1FY10 Q2FY10 Q3FY10 Q4FY10 Q4FY09 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Interim Enhanced GHG Reporting Tool for 2010 Existing Process Review/Gap Analysis Recommend Enhancements Enhanced Spreadsheet (Flat File) Development Flat File Available Back End Tool Development, Test Back End Tool Available User Manual Updates Screening Project (To Be Solution) Business Requirements Definition Complete Evaluate Internal vs. External Development Approved Planned System Development and Implementation Milestone
Timelines For Agencies/SMFPs Q1FY10 Q2FY10 Q3FY10 Q4FY10 Q4FY09 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec GHG Reporting Schedule for 2010 Send out “Flat-file” to all outlying Offices Existing Process Review/Gap Analysis Data Collection and Verification Data Input Review Report & Print 2010 Tool Development GHG Report Ready Existing Process Review/Gap Analysis Enhanced Spreadsheet (Flat File) Development Flat File Available Back End Development, Test Inventory Work Back End Tool Available Milestone/Event User Manual Updates Tool Preparation: Complete To be done