Comment Details
| Comment Author: | Simon Selkrig |
| Organization: | Origin Energy |
| Comment Date: | Thursday, 05 November 2009 |
| Comments: |
Is this approach sufficiently analytically rigorous? If not, do you think more sophisticated models are likely to produce significantly different results?: Congratulations must go firstly to Scott Murtishaw, from California Public Utilities Commission; as an experienced Excel carbon/financial modeler, i can see the great level of detail which he has put into this model. I am to explain further from a personalised email, but in a nutshell there are few tips which could improve the useability of this WCI calculator going forward. 1) Avoid using Pivot Tables because they are not dynamic, users must continuously update the table to reflect changes in the source data. This is time-consuming, onerous & fraught with danger - human errors can occur 2) Improved Presentation. Attempt to flow the name of the calculator through every worksheet, maintain consistent fonts, styles for the name of the worksheet on each sheet, and present a simplied/attractive dashboard form of the "EmFacPvtTable" on a separate sheet which is more clear/clean. |
| Comments: |
Are there any other corrections or improvements that you suggest?: Avoid, as mentioned above, avoid the use of Pivot Tables by adopting dynamic Excel formulas such as Sumifs or Sumproduct. Whenever the source data or variables are changed to cruch/calculate the Emissions numbers, these formulae will change as well. Where possible, insert some simple Error Checks in the model; this will act as a further check to safeguard against calculation errors or a user potentially compromising the calculator model. |
| Comments: |
Other/General Comments: I am happy to provide further feedback, or respond to questions going forward. I have been undertaking the GHG emission modelling under the Australian Department of Climate Change regulatory requirements. Here are my details. Kind regards, Simon Selkrig Senior Analyst, Carbon Data Carbon Markets, Energy Risk Management Origin Level 43, 264 - 278 George St, Sydney NSW 2000 GPO Box 5376, Sydney NSW 2001, Australia Phone: +61 2 8345 5312 simon.selkrig@originenergy.com.au Together we can make a difference.™ |