Hawaiian Electric Companies Release Power Supply Improvement Plan Update

Ascend Analytics has been working vigorously to help Hawaiian Electric Companies (HECO) update their energy plans, which outlines a plan charting the near-term actions that will lead to the use of renewable resources to meet 100% of Hawai’i’s power generation needs by 2045.

HECO’s 2016 Power Supply Improvement Plan (PSIP) Update outlines a detailed plan charting the specific actions for the years 2017 through 2021 to accelerate the achievement of Hawai’i’s 100% Renewable Portfolio Standard (RPS) by 2045.

The work that went into creating the PSIP incorporated Renewable Energy Planning Principles, which helped guide the creation and direction of the plan.

For details and more information, please see the links below!

Solar Irradiance Nowcasting Case Studies Near Sacramento

Check out the article, “Solar Irradiance Nowcasting Case Studies Near Sacramento” to learn about the solar power forecasting system, designed to predict solar irradiance and power generation at solar farms.

The system is comprised of several component models operating on both the nowcasting and day-ahead forecast horizons. The different nowcasting models include a statistical forecasting model, two satellite-based forecasting models, and a numerical weather prediction model. It is important to better understand and assess the strengths and weaknesses of these short-range models in order to facilitate further improvements.

Tyler McCandless, co-author of the article and Project Manager here at Ascend, helped write the paper from his dissertation research. The paper has been published in the Journal of Applied Meteorology & Climatology.

Click Here to Read the Article!

Fundamentals of Integrated Resource Design Plans

On October 17-18, Dr. Gary Dorris, CEO & Co-Founder of Ascend Analytics will be teaching a course on the Fundamentals of Integrated Resource Design Plans. The course will take place at the SCPPA (Southern California Public Power Authority) offices in Glendora, CA and is open to members of SCPPA. As of now, 30+ registered members have already signed up for the course!

Much of the course content will focus on California Senate Bill 350 “Clean Energy and Pollution Reduction Act of 2015”. To summarize, this legislation requires that California is producing 50% of its electricity from renewables by the year 2030. For more information and course details, please click here!


Best Practices in Portfolio Hedging for Utilities

Ascend Analytics welcomes you to attend the “Best Practices in Portfolio Hedging for Utilities” course on October 6-7, 2016 taking place in Chicago, IL. This 2-day course provides a hands-on experience that will walk attendees through exercises on portfolio hedging for real utility portfolios. You will learn the steps and techniques necessary to effectively manage portfolio positions, adhere to budgets and risk limits, and to optimize operations.

For course details, registration information, and to download the official brochure, click here!

Gas & Power Hedging and Risk Management for Utilities

Join Dr. Carlos Blanco, Ascend’s Managing Director of Analytic Solutions, on September 19-20, 2016 for a comprehensive training session on gas and power hedging and risk management for utilities in an applied context.

The course will enable participants to gain a practical working knowledge of gas and power markets, their main players and common traded instruments. Delegates will gain a practical understanding of the various dimensions of risk for utilities active in gas and power markets and the various tools to manage and transfer those risks.

Click Here for Event Details

Synopsis of the Ascend Best Practices & User Summit

On May 2 thru 4th 2016, Ascend Analytics held its Portfolio Management, Best Practices and User Summit on the PowerSimm software suite. More than 40 attendees spent this time in beautiful Boulder, Colorado sharing best practices, experiences and knowledge on how they have used PowerSimm to add value via meaningful uncertainty to their utility and municipal operations, portfolio management and planning decisions. The presenters and panel discussion members included the following:

  • Ascend Analytics – Gary Dorris, CEO – Hedge Strategies and Applications Workshop. In this session Gary covered key distinctive attributes of PowerSimm with regard to hedging strategies.
  • TVA- Eric Hummel, Risk Manager – Mastering Uncertainty as a Tool for Better Decision Analysis. Eric shared 3 examples of how PowerSimm is adding value to TVA in PPA’s, Commodity Contracting and Portfolio Risk Reporting.
  • AEP – John Kinateder, Director, Market Risk Analytics- Ensuring Hedge Optimization. John’s many years of experience helped the crowd better understand how to use PowerSimm to evaluate different hedge strategies.
  • Duke Energy – Pedram Mohseni, Lead Qualitative Analyst, Fuels & Systems Optimization – Adopting Solar in an Uncertain Regulatory Environment. Pedram shared about how Duke Energy is considering risk with regard to solar integration.
  • Ascend Analytics – Sean Burrows, CTO– Data Reporting, Visualization and Management Metrics. Sean showed users some of the improvements and updates that have been made and are coming to PowerSimm and the User Interface(U/I).
  • AES – Viktor Stafiychuk, Risk Manager – Global Portfolio Management, Case Study.   Viktor presented the AES global portfolio and a pilot study on the application of simulation to analyze illiquid markets.
  • Dayton Power & Light (DP&L) – Scott Wrigglesworth, Associate Director, Commercial Portfolio Analytics – Optimizing Short Term Operations Decisions. In this session, Scott demonstrated how DP&L has used PowerSimm to maximize revenue via trading, hedging and risk mitigation.
  • Rocky Mountain Institute (RMI) – Herve Touati, Managing Director – Utility Investment Planning under Variable Renewable Energy Sources. Herve shared RMI’s global view of renewable expansion and valuation.
  • Ernst & Young – Thomas Lord, Executive Director, Commodity Markets – Fuel Commodity Management Under Volatile Supply Conditions. Thomas spoke candidly on the good, the bad and the ugly of commodity hedging.
  • Riverside Public Utilities (RPU) – Scott Lesch, Resource Manager – Use of Ascend Reports for Resource Planning & Energy Risk Management.   Scott took some time to share how RPU is using PowerSimm to share information internally and externally and to make informed decisions.
  • RES Americas – Patrick Leslie, Energy Storage Manager – RES Energy Storage Solutions. In this presentation, Patrick shared details on RES’s twelve energy storage projects across the USA and some study cases on storage project valuation.
  • American Power Net – Bruce Sher, VP National Accounts – Innovations in Predictive Analysis. Bruce shared some insights on energy storage deployment methodologies and rationalization.

The event culminated with a training session for all users and levels of expertise. The summit was a great professional experience for PowerSimm users who came away with an improved knowledge of how to add value to their business via PowerSimm. We at Ascend really appreciated the chance to meet many of our users in discussion sessions, presentations, the training day and after hour events. We look forward to next year’s event, and to staying in touch to help meet your analytical business needs with PowerSimm.

If you would like more information on this or future events, please fill out a contact request form on Ascend’s website specifying the information you are seeking. If you would like a copy of a specific presentation listed above, please contact Beau Demmler at bdemmler@ascendanalytics.com.

Carlos Blanco joins Ascend!

Ascend Analytics is proud to announce the welcoming of Carlos Blanco! With over 150 publications and leadership at FEA as VP of risk solutions, Carlos is widely respected in the industry. His expertise is highly sought-after for risk management consulting and analytics. Carlos’s recent projects include simulation-based market & credit risk models, trading & risk policies, gas & power forward curve development, hedging strategy design, and asset optimization for energy portfolios in North America & Europe.

Carlos is also a faculty member at the Oxford Princeton Programme, where he has designed and delivered more than 100 workshops on market, counterparty, and enterprise risk management courses to leading financial institutions, energy producers, trading firms and utilities. Welcome to the team Carlos!



PowerSimm Editor 4.1

We are excited to announce the release of PowerSimm Editor 4.1. This new release of PowerSimm is a major upgrade from previous versions, involving significant improvements on the user interface functionality, menu contents and layouts, new validation rules for notifying users of errant inputs or configuration, and remediation of existing bugs. This new UI makes substantive strides to improve the software usability and error trapping of problematic data or configurations. PowerSimm 4.1 also incorporates, for the first time, a user interface for Credit Manager, our enhanced analysis tool for credit exposure.

A lot of valuable feedback from client users and our analysts went into the development of this new release. Our main goal was to provide users a more integrated and intuitive editing/execution environment. Diligent validation and QA testing were performed on this new release by experienced IT and Services analysts to ensure error-free functionality of various components.

Major highlights from the new version of PowerSimm™ are given below. More detailed lists of enhancements, new validation rules, and bug fixes are provided in Appendices 1 through 3 at the end.

Updated Look with a New Menu System – The main editor now features a leaner UI theme inspired by Windows 8 Metro where icons for the most commonly used editors are tiled in meaningful groupings. The menu system of PowerSimm™ has been significantly changed with this release. All previous menu functionality is still present, but has been organized in a more intuitive form.


Tabbed Windows – In a form similar to web browsers but placed at the bottom of the frame, the newly-featured windows tabs allow the user to focus on, organize, and close work windows with more ease.


Backstage Menu – Also new in this version is what is termed a “backstage” menu section, accessible by clicking on the gear icon in the upper left corner of the main editor. The backstage menu hosts the configuration and administrative functions of the main editor.


Completely Rebuilt Generation Editor – The generation editor was rebuilt to improve its usability by grouping the types of configuration data into several screens: Resource Variables, Scheduled Outages, and Historical Input. Additional features include an added end date filter, a more accessible flat view toggle, and additional validation rules, including new checks of heat rate, startup/shut down, and outage data.


Many New Validation Rules – PowerSimm™ Editor version 4.1 adds many new input data validation checks to help prevent configuration errors in new or updated data. New and updated validation rules for the Generation Editor, Instrument Editor, Forward Curve Editor, and many more, improve the reliability of configurations and data. This includes more checks on generator configuration, trade details, load and pricing data, to name a few. Also, the new Report Manager has improved capability of preventing data- and configuration-related run failures. Building on the input data error checking process in version 4.0, the “Check Data” link allows users to check if their changes (additions or updates) have any issues before submitting the changes to the database.


User Interface Integration for Credit Manager – PowerSimm™ now features a user interface for Credit Manager, a credit risk analysis tool for collateral, exposure, and simulated potential future exposure across multiple departments.

Upgrading to PowerSimm™ 4.1 – This new version of PowerSimm™ will be available for installation on ATLAS. For all features to work, a database update is required. Please meet with your Ascend project manager for creating an update plan to review the new editor and develop a deployment testing schedule.

Appendix 1 – Enhancements

  • Credit UI
  • Using ribbon menus with new menu layout
  • Updated icons
  • Tabbed MDI windows
  • Metro-style facelift to main form
  • Added speed-dial
  • Moved book indicator to status bar
  • Permissions for study creation/deletion added
  • Altered the report manager study list logic to exclude studies whose types do not have a showflag=1 condition
  • Removed hiding the variable editor if there is an issue getting the data. The variable editor will open and display an exception instead.
  • Made the following changes to the User Management screen –
    • User List filtered to show only OPS users
    • Ability to edit the user – role mapping
    • Replaced the OPS username by Windows friendly name in the User List in the UI
  • Ability to scroll and drag the tree nodes in Portfolio Editor
  • Replaced Portfoliomanagement trigger with procedure to avoid missing column errors
  • Added filter to Market price model, basis, wind, spot and Load editor to filter moduleprocess
  • Added default variable functionality to startpowersimmstudy
  • Added new sensitivity job tables and their trigger logic
  • Added logic to automatically update the calculation order in case of missing values
  • Jobidtable logging records application modifying the table
  • Log machine running cost in the jobrunnerspectable_log
  • Locations all default to 1 (world) in items
  • Added and updated validation rules for:
    • Generation Editor
    • Instrument Editor
    • Forward Curve Editor
    • Main Model Editor
    • Renewables Editor
    • Load Editor
    • Basis Editor
    • Gas Storage Editor
  • AscendHelp table updated and consolidated to POWERMAN
  • Report manager has new validation rule selection capability
  • Report Manager does not show CD studies in study lists
  • ScheduleStudyToRun updated to include OPS parameters
  • Spot Price Editor updated to be a “filter form” similar to load, wind, etc.
  • Default time step of 4 set in Report Manager
  • Job Error triggers consolidated and updated
  • Portfolio Links now copy with portfolios when copied
  • Study name duplicates prevented
  • Instrument dates adjusted for hour ending. Dates entered in as dates (no times) are given a 1 AM time.
  • Generation Editor rebuilt
  • Report Manager variable search is no longer case sensitive
  • Basis editor date filter logic update
  • Item name added to DSM dropdown in gen editor
  • Archived variables filtered from variable editor
  • Process flow drop-downs in various UIs filtered for context
  • Deleted forward prices indicated in model editor
  • Grids given export to excel function
  • Sensitivity refresh button added to Report Manager
  • Label changes in Generation Editor
  • Calculation Order auto-populated in a better way from the variable editor

Appendix 2 – New Validation Checks

  • Generation Editor
    • Unit Type not null
    • Non-negative times and costs
    • Non-negative Ramp-up/Ramp-down rate
    • Non-negative MMBTUs
    • Non-negative emissions
    • 0 <= Must Run
    • Min <= Max Gen
    • All three historical levels fields filled out (or none)
    • Heat rate Gen’s are monotonically increasing
    • Scheduled Outages: Start/End/% – all or none
    • Set of Fuel Types must equal set of fuel types in HR tab
    • Linked Res.: State must be filled if Unit is filled in
    • Fuel Cost Multiplier must be > 0
  • Instrument Editor
    • Commodity needs to be filled out
    • Instrument Type required
    • Peak Period needs to be filled out
    • one out of the 6 PRICE columns should be filled out for each record
    • Warn on missing Quantity and/or Quantity type
    • Transaction date cannot be null
  • Forward Curve Editor
    • Must have commodity filled out
    • Multiple Commodity/Peak Period (PP) pairs are not allowed within a given item
    • Use CD is checked, market name must be filled out
    • If Use Adjustments is checked, make sure there are adjustments!  (NOT USED!!! HIDE Adjustments tab and checkbox)
    • If one column is filled out, then they all need to be (less Update Date)
    • PP must match the parent
  • Main Model Editor
    • Description, Curve Type, Process Flow, Source & Weight Schema must all be filled out.
    • Description should be unique (database change)
    • Must be filled out: System Load, Gas %, Electric % (6 columns)
  • Renewables Editor
    • Expected Peak > Capacity –> Error
    • TimeIntervalInHours * ExpectedPeakGen < ExpectedEnergy –> Error
    • StartDate>EndDate –> Error
    • Gaps –> Warning
    • Overlaps –> Warning
  • Load Editor
    • Data type should be set (default to Energy)
    • Load needs a value
    • For a load, if forecasts are filled out, but no data, warn regarding setting the proper process flow.
    • Total installed Cap = Sum of other cap
    • Expected Peak Demand*[Hours in (End Date – Start Date)] > Expected Energy
    • Of use column checked then fill out other columns
    • Run orders exclusive
    • Check if more than one record per load => Run order filled out
  • Basis Editor
    • Check for overlapping date ranges in the scaling data
    • Check for date gaps in the scaling data
  • Gas Storage Editor
    • Check for overlap in Capacity date ranges
    • Check for Utilization Min < Max
  • Report Manager
    • Warn on previous study resubmission

Appendix 3 – Bug Fixes

  • Limited number of jobs shown in Study Viewer to 10,000 to prevent memory errors.
  • Load, Hydro, Wind, FC editors, ST price, Weather handle database errors upon save.
  • Fixed: Instrument Editor throws an error when there are zero instrument items
  • Modified Ascendhelp table entries to point to latest value
  • Modified AALOOKUPIDTABLE primary key from composite to single key, added foreign keys
  • Added unique key to counterpartyratings table
  • Fixed language errors in jobidtable triggers, made it schema independent and combined them into a single trigger
  • Modified basis editor to point to newly created view to show archived forwardcurve values correctly
  • Double-click of some item types (hydro, wind, FC, load) in portfolio editor opens form with item in focus
  • User Management error when closing fixed
  • Null active flags in instruments set to 0
  • “copy” concatenation added for long item names
  • Various credit database corrections (missing FKs and PKs)
  • Extra line after paste issue fixed
  • Credit date interval issue in Report Manager fixed