Indirect Rebound Effect: Households vs Firms (MULTI2C: Centro-Interior-Rest of Portugal)

Description

This repository provides the data and model used in the analysis presented in the manuscript listed above. The study develops an environmentally extended multi-regional input-output (MRIO) model to estimate the economic, energy, environmental, and employment impacts—including indirect rebound effects (RE)—of electricity efficiency improvements in Portugal. The analysis is conducted across three regions (Coast Centro, Interior Centro, and Rest of Portugal) and compares efficiency gains occurring at the household (consumption) and firm (production) levels. The model is fully implemented in Microsoft Excel, using interlinked worksheets and standard formulas. No external scripts or macros are required.

Steps to reproduce

This repository includes: - MULTI2C_C_I_RP_IndirectRE.xlsx Core dataset and model implementation - model_structure.png Diagram of the MRIO model structure (corresponds to Table 1) - model_structure_legend.png Legend for the model structure diagram (Table 2) - README_REPLICATION.txt The analysis can be fully replicated by following these steps: 1. Open file: MULTI2C_C_I_RP_IndirectRE.xlsx 2. Construct the technical coefficients matrix (A):(A sheet): Divide each element in cells E5:BMR1708 by corresponding total output (row 1720). 3. Build the identity matrix (I). Create identity matrix I with same dimension. 4. Compute I-A: Subtract A from I, cell by cell, to obtain I-A. 5. Compute the Leontief Inverse Matrix (Leontief & Simulation sheet): - Use excel function MINVERSE() to invert the I-A matrix (same cell range: E5:BMR1708). 7. Apply simulation scenarios (see Section 6). 8. Recompute outputs using: Output = Leontief Inverse × Final Demand 9. Extract results from: sheet "Table_results"

Institutions

• University of Coimbra

  Coimbra, Coimbra

Categories

Licence