General Help Topics
This Help module is available in all workbooks and gives
an overview of how to use EFFECT and the help fuction
· -
Structural Overview of EFFECT.
· -
Navigation.
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]
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.