WeDid: Automated Energy Savings Certificate (ESC) Calculations
May 30, 2014 /
Posted in We Did
Challenges
The IPART has a specific formula for the Energy Savings Scheme (ESS) to calculate Energy Savings Certificates (ESC). The company needs to capture the baseline lighting system (current) and compare it with the upgraded lighting system (proposed). The current calculation is done using excel and it poses some challenges:
- the calculation is not accurate because not all scenarios are considered
- not extensible
- difficult to track the itemised calculations
Solution:
- Capture current and new lighting system in Salesforce
- Calculate saved MWH and ESC
- Calculate the estimated ESC money value and prepare a ROI report to end customer in quote
| Related Objects | Opportunity, Quote, Custom Object |
| Components | Apex Class, Apex Trigger, Visualforce Page, Data Model Design |
| Complexity | Complex |