MACC Builder Pro

Marginal Abatement Cost Curves are a great way to present a number of alternative projects or policies and their financial performance and environmental benefits. See Niall Enright’s article on this subject for more information about MACCs.

Unfortunately Excel does not natively draw the variable-width columns that are required to create these charts. That is where MACC Builder Pro comes in. It is an Excel spreadsheet  which will overcome this limitation and permit high quality MACCs to be easily drawn. It works with Windows versions of Excel 2003 through to 2013, although some of the features will vary from version to version.

MBP_MACC_Example

MACC Builder pro is a very flexible tool with a large number of options. An example of the MACCs created with MACC Builder Pro can be seen above (click on the image to see the full sized version).

Professional Charting with Categories! With MACC Builder pro, you can get a very professional look to your MACC charts, ideal for incorporation into reports and publications. The example above shows how categories can be used to colour-code different technologies.

Highly Flexible Labelling and Outputs! Project can be labelled using callouts with the project name (as shown above), or with numbering or lettering.  These callouts can be dragged and dropped to adjust spacing (not Excel 2003). CHarts can be accompanies by project list to which up 4 of a dozen different data values can be added. Summary Statistics can also be added to the MACC output.

Completely customisable styles! Create you own custom style-set for all the fonts and colours used in MACCBuilderPro. Or use one of the many inbuilt styles, such as “Desert” shown above.

Save Chart setting for later use! You can save the data and settings for an individual chart at any time and restore these as needed. Because MACCBuilderPro is an Excel spreadsheet you can make copies and keep them with client or project files. Never worry about recreating that important chart again.

Innovative Data Presentation! You can communicate project or technology performance in terms of Payback or Internal Rate of Return (IRR) as well as the traditional Marginal Abatement Costs. These forms of presentation may overcome some of the limitations of MACCs and provide alternative ways of showcasing relative strengths and weaknesses of alternative choices. You can even choose a chart based on “variance” from a given value, or you can plot an index line (as seen in the Carbon Price, above).

Integrated with other Office Apps. There is a one-click option to send the MACC charts or project details to Microsoft Word or Powerpoint. Powerpoint can be used to offer additional file export options not offered by Excel.

Purchase a MACC Builder Pro license 

From 1st June 2017,  MACCBuilder Pro v3.0 is offered as part of the companion files for the book “Energy and Resource Efficiency without the tears – the complete guide to adding value and sustaining change in an organisation”. These files are in a downloadable a zip file (27 MB) containing:

>Over 70 spreadsheet models that build on the data and financial analysis techniques set out in this book. These Excel spreadsheets extend the learning points in this book, and enable practitioners to employ the analysis and presentation techniques set out in this book.

>5 Business case models, as used by the author in investment appraisals.

>Over 200 illustrations and cartoons for use in educational materials and presentations; and 10 posters, summarizing key concepts.

>A lighting hours tool to create daily, weekly or monthly lighting demand profiles based on a place name or coordinates.

>A complete set of certified ISO 50001 process documentation (provided courtesy of Peel Land and Property Group).

>MACCBuilder Pro, a tool to draw Marginal Abatement Cost Curves (version 3, previously sold for £85).

>MATOD a simple M&T spreadsheet system for non-commercial use.

>A software specification document that can form the basis for the selection and procurement of a resource-efficiency tool.

Please visit this page to purchase all these files for just £29.99.

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Our mission

To deliver outstanding results for customers and support best practices in our profession.

Energy and Resource Efficiency without the tears

Niall Enright’s book was published in June 2017 and last updated in September 2018.

To get the FREE PDF visit the download page.

4380 Downloads

To buy a print version of the book or order the companion files please visit our store.

If you appreciate the book and want to make a donation towards the publication costs (and support future publications),  click the link below. This is entirely optional!

 

Free Lighting Hours Tool

We were so frustrated at SustainSuccess with trying to find daylight hour tables for client locations that we wrote our own Excel/Google Maps/NOAA “mashup” to calculate lighting hours for any location on Earth! We are providing it FREE to fellow practitioners. Simply fill in this form and we’ll send you a download link.

1295 Downloads

Ideas and Challenges

Despite self-congratulatory case studies to the contrary, the reality is that Sustainability and Resource Efficiency are NOT EASY to implement successfully in organisations.

In a series of blogs, articles, book reviews, and extracts from Niall Enright's book you will find hints, tips and suggestions to make Sustainability a Success.

Contact SustainSuccess

P: +44 7812 519 965
F: +44 161 969 1361 E: mail@sustainsuccess.co.uk

A:19 Harboro Road
    Sale
    M33 5AF, UK

To send me an email, simply click here, or complete the contact form.

For full contact details in internet format vCard click here or scan the QR code below.

Posts, Articles and Reviews

May 2024
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  

Archive