General Help Topics

This Help module is available in all workbooks and gives an overview of how to use EFFECT and the help fuction

The Help Function

On every sheet you find the same three Help icons in the LCG Model menu:
- General Help gives you the overview of how EFFECT is structured, how to navigate among the different modules and various color and other conventions
- Page Help gives you an overview of the current sheet you are in, how to modify and fill data in.
- Glossary gives you an alphabetic list of various terms used in the sheets. [To the top]

Structural Overview of EFFECT

EFFECT consists of 8 excel workbooks, that are linked together, plus a workbook that is only used to start the model. Press here to see a schematic overview. One General Module, containing economic forecast, population data, fuel prices, income and price elasticities and CO2 Emission factors, feeds into the six sector modules: Power/electricity production, Transport CO2-emissions, Household electricity use, Industry electricity management, Non-residential electricity consumption and Agricultural CO2 emissions (not ready yet). The transport, household, industry, non-residential and agricultural module’s projected power consumption can be fed into the power module or it may be fully based on the population and economic data. A summary of the various sectors’ CO2 emissions and economic development can be found in the summary module. [To the top]

Navigation

You always start the EFFECT model by starting the workbook called “START_EFFECT_Model.xlsm”. This workbook will open the two workbooks: General module and Summary, and take you to the Summary workbook. You navigate to the other modules via the ribbon in the top called “EFFECT Model”. In the left side of the ribbon are the links between all the modules. The regular sector modules can be opened and closed one by one whereas closing the General or the Summary module will close EFFECT with all its modules. [To the top]

Design Conventions

Certain color codes and specific signs have been used around all the workbooks and sheets to signify various functions and tell where the data comes from or should be inserted. Press here to see (and possibly print) an overview of all design conventions. [To the top]

Data Input

EFFECT comes pre-populated with data so that you can see how it works, but one of your first tasks will be to change this for data that is valid for your country. It is good practice to go through all the sheets in each workbook from left to right. To help you keep track of the data that you input, each row with data entry has a field (normally in column ”F”) that is grey with a red corner. As you go through the spreadsheets entering your data use this box to keep track of where you are.

- Enter “0” if that row currently has inadequate data and the cell will turn RED.

- Enter 1 if that row currently has proxy, or temporary data and the cell will turn YELLOW.

- Enter 2 if that row currently has good data and the cell will turn GREEN

Checking for this box is an easy way to see: (i) where data needs to be entered; and (ii) What still needs to be done.

You can navigate between data entry rows by selecting in Excel’s Ribbon “Review” and “Comments” and using the “Previous” and “Next” commands to move from one of these cells to the following.

[To the top]