Design of a simple linear calculation model in MS Excel environment for the purpose of calculation of renewable energy substitution and GHG emission savings in the transport sector in the Czech Republic. It will allow to summarize total energy consumption, calculation of total RES substitution, calculation of average GHG emission factor and GHG savings and other parameters for individual years based on aggregate input data.