Planned intervention: On Wednesday June 26th 05:30 UTC Zenodo will be unavailable for 10-20 minutes to perform a storage cluster upgrade.
Published June 17, 2023 | Version 2.5
Software Open

Macro "goal seek" - Determination of Paris-compatible emission paths

Description

VBA macro "goal seek" for determining the free parameter in the Regensburg Model Scenario Types RM 1 - 6 in various Excel tools (see "Supplement to; Software").

With the scenario types RM 1 - 6, emission paths can be determined that adhere to a predefined budget, covering the entire range of plausible possibilities. For the mathematical description see "Supplement to; Technical note".

This upload gives the possibility to save the Excel tools as xlsx files and thus remove all macros. The BAS file can be checked for malicious code using a text editor and then imported into the Excel tools.

Of course, it is easier if you use the integrated macros. The macros in the Excel tools are signed with a certificate from Sectigo to the author Andreas Wolfsteiner. This secures the origin of the macros and changes are not possible without cancelling the signature.

Files

goal_seek_2_5.pdf

Files (100.9 kB)

Name Size Download all
md5:9e577c977c637fba9cce7333bf2fb808
20.6 kB Download
md5:5132a486bda0f02bba9cd0f02bc8ec02
80.3 kB Preview Download

Additional details

Related works

Is supplement to
Software: 10.5281/zenodo.4580310 (DOI)
Software: 10.5281/zenodo.4568839 (DOI)
Software: 10.5281/zenodo.4584562 (DOI)
Software: 10.5281/zenodo.5846043 (DOI)
Technical note: 10.5281/zenodo.4540475 (DOI)