Copyright © Gaffney Systems Pty Ltd - ABN 67 134 159 167
Many software programs and systems in the electricity industry reduce a
user's day to a routine of manually entering data, pressing a button,
waiting for a process to run, then copying and pasting results from one application into
another, before repeating.
Gaffprice has been built to allow as much automation as possible,
and integrate with a user's existing data systems.
- The program works as a Component Object Model (COM) add-in for Microsoft Excel, which means that users can:
- Work in a familiar spreadsheet format
- Open and run Gaffprice from other applications
- Set up macros to run processes before or after a price is calculated
- Enter formulas so that parameters update automatically.
- Gaffprice can connect to an existing forward curve data source,
the MMS Infoserver database, or a customer load database.
- Prices are generated in seconds, with as little as one button click.
- A minimum of manual processes means greater accuracy.
Once Gaffprice has been set up, there are a minimum of five pieces of data required as input for pricing:
- The region of the customer
- Their historical load data
- The start date of their contract
- The end date of their contract
- The start date of the historical NEM data to be analysed.
When a customer provides a retailer with a sample of their historical load, this can be included by:
- Entering the starting date of their data
- Copying and pasting in their half-hourly MW.
Comment tags provide information on every item.
Tariff prices can be split by time-of-use.
Besides the final tariff, users can view price statistics, gross amounts and DSM value.
Next Page: About Us