How to convert a Green Button XML file to Excel format then import into OptiMiser using the Scrape tool.
Here's the formula to convert the unix timestamp into an Excel date: =(((C2/60)/60)/24)+DATE(1970,1,1)
Green Button to OptiMiser: How to use Green Button XML files to load utility data into OptiMiser audit software
Home
Green Button to OptiMiser: How to use Green Button XML files to load utility data into OptiMiser audit software
Related Articles
-
-
OptiMiser TOU Update Demo 2020-01-08
Ryan Moore, , Residential Videos, Videos, AMI, APS, Arizona, interval, Time-of-use, TOU, 0
Demoing the new time-of-use features in OptiMiser Audit Tool.
-
-
OptiMiser Residential Energy Audit Software 102: Report Generation
Ryan Moore, , Residential, Residential Videos, Videos, 0
How to configure and generate the audit report you want.
-
OptiMiser Residential Energy Audit Software: Measure Costs
Ryan Moore, , Residential, Residential Videos, Videos, 0
Explore quick and detailed ways to get your pricing just the way you want it every time.
-
Live Intro Webinar: OptiMiser Home Performance Audit Tool
Ryan Moore, , Intro Video, Residential, Residential Videos, Videos, 0
Recording of live OptiMiser residential audit tool webinar from May 31, 2016.
-
2017/12/19 OptiMiser Intro Webinar – Energy Upgrade California version
Ryan Moore, , Intro Video, Residential Videos, Videos, 0
OptiMiser's Ryan Moore provides a one-hour end-to-end overview of OptiMiser residential audit software using the configuration for California (includes...
-