SPLAT Interface Documentation

The SPLAT interface is an excel workbook with a set of macros operated via buttons or short-cut keys. The workbook can be used in conjunction with the standard MESSAGE model interface. The workbook has been developed for single or multi-country MESSAGE_V5 models.

The workbook has a core set of spreadsheets that the user can add to or duplicate as needed for managing input data and results for the model they are working on. This guide describes the features of the latest stable version of the SPLAT excel interface.

Note

This guide focuses on the use of the SPLAT excel interface to interact with the MESSAGE software. For a basic guide on how to use MESSAGE directly, refer to Restoring and opening a model using the MESSAGE interface.

Contents

• 1. Getting Started
  • 1.1. Pre-requisites
  • 1.2. Conventions
  • 1.3. First Steps
• 2. Working with Demand
  • 2.1. Viewing demand input
  • 2.2. Changing demand input
• 3. Working with Technologies
  • 3.1. Technology Types in SPLAT
  • 3.2. Viewing technology inputs
  • 3.3. Adding a technology
  • 3.4. Renaming a technology
  • 3.5. Deleting a technology
  • 3.6. Changing a technology
  • 3.7. Defining some key technologies
  • 3.8. Technology naming in the SPLAT model
  • 3.9. Country Code in the SPLAT model
• 4. Defining Time
  • 4.1. Defining time zones and granularity
• 5. Working with Scenarios
  • 5.1. Add a scenario
  • 5.2. Select a scenario
• 6. How-To Guides
  • 6.1. Change decimal seperator in windows environment
  • 6.2. Installing an Alternative (Faster) Free Solver
  • 6.3. Installing an Alternative (Faster) Commercial Solver
  • 6.4. Restoring and opening a model using the MESSAGE interface
  • 6.5. Copying a scenario using the MESSAGE interface
• 7. Description of Sheets
  • 7.1. Main
  • 7.2. Input Sheets
  • 7.3. Constraint Sheets
  • 7.4. ReportGen-Annual
  • 7.5. ReportGen-Profiles
  • 7.6. TimeSlices
• 8. MESSAGE
  • 8.1. Objective function in MESSAGE
  • 8.2. Components in MESSAGE
  • 8.3. Databases in MESSAGE
  • 8.4. Significance of various MESSAGE model files
  • 8.5. SPLAT MESSAGE workflow