The Swiss Gas Industry Association (VSG) promotes the injection of biogas into the grid via a biogas development fund. We created an Excel tool for the VSG to revise the previous funding system and to subsequently manage the fund. The tool models the financial impact of the current support system and various new systems. It facilitates various forecasts and presents the most important key figures in a user-friendly cockpit.
- Obtaining data on existing biogas plants and current funding levels
- Modeling of the fund’s revenue development across multiple scenarios
- Enabling the entry of various funding models
- Modeling the development of gas production and the disbursed production volume
- Designing attractive illustrations to show the most important results
Picture Credits: Biogas (gazenergie.ch)
Dr. Sabine Perch-Nielsen