{
  "dsoName": "\t Elektrizitätsversorgung Niederbipp",
  "dsoNumber": 10126012345,
  "tariffs": [
    {
      "customerVoltageLevel": 7,
      "tariffName": "Standard BasisStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher bis 50 MWh/a",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.102,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Standard Netznutzung",
      "tariffType": "grid",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbrauch < 50 MWh/a",
      "prices": {
        "base": {
          "price": 8,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.065,
            "priceUnit": "CHF/kWh"
          }
        ],
        "power": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0,
            "priceUnit": "CHF/kW/M"
          }
        ],
        "reactivePower": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0,
            "priceUnit": "CHF/kVarh"
          }
        ],
        "refundStorage": {
          "price": 0.065,
          "priceUnit": "CHF/kWh"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Messtarif Direktmessung",
      "tariffType": "metering",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit Direktmessung",
      "prices": {
        "base": {
          "price": 5.5,
          "priceUnit": "CHF/M"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Messtarif halbindirekt NE7",
      "tariffType": "metering",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit halbindirekter Messung",
      "prices": {
        "base": {
          "price": 14.5,
          "priceUnit": "CHF/M"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Flex BasisStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit unterbrechbarer Stromlieferung",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.102,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Flex Netznutzung",
      "tariffType": "grid",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit unterbrechbarer Stromlieferung",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.055,
            "priceUnit": "CHF/kWh"
          }
        ],
        "power": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0,
            "priceUnit": "CHF/kW/M"
          }
        ],
        "reactivePower": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0,
            "priceUnit": "CHF/kVarh"
          }
        ],
        "refundStorage": {
          "price": 0.055,
          "priceUnit": "CHF/kWh"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Gewerbe BasisStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50000 MWh",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.09,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Gewerbe Netznutzung",
      "tariffType": "grid",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50 MWh/a",
      "prices": {
        "base": {
          "price": 25,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.053,
            "priceUnit": "CHF/kWh"
          }
        ],
        "power": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 6.4,
            "priceUnit": "CHF/kW/M"
          }
        ],
        "reactivePower": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.047,
            "priceUnit": "CHF/kVarh"
          }
        ],
        "refundStorage": {
          "price": 0.053,
          "priceUnit": "CHF/kWh"
        }
      }
    },
    {
      "customerVoltageLevel": 5,
      "tariffName": "Industrie BasisStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50 MWh/a",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.09,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 5,
      "tariffName": "Industrie Netznutzung",
      "tariffType": "grid",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "Endverbraucher mit eigener Trafostation",
      "customerType": "Endverbraucher mit eigener Trafostation",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.028,
            "priceUnit": "CHF/kWh"
          }
        ],
        "power": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 9,
            "priceUnit": "CHF/kW/M"
          }
        ],
        "reactivePower": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.047,
            "priceUnit": "CHF/kVarh"
          }
        ],
        "refundStorage": {
          "price": 0.028,
          "priceUnit": "CHF/kWh"
        }
      }
    },
    {
      "customerVoltageLevel": 5,
      "tariffName": "Messtarif halbindirekt NE5",
      "tariffType": "metering",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit halbindirekter Messung auf NE 5",
      "prices": {
        "base": {
          "price": 46.5,
          "priceUnit": "CHF/M"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Standard MixStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher bis 50 MWh/a",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.0985,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Flex MixStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit unterbrechbarer Stromlieferung",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.0985,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Gewerbe MixStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50000 MWh",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.00865,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 5,
      "tariffName": "Industrie MixStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2027-01-01",
      "endDate": "2027-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50 MWh/a",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.00865,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    }
  ]
}

data_2026 = {
  "dsoName": "\t Elektrizitätsversorgung Niederbipp",
  "dsoNumber": 10126012345,
  "tariffs": [
    {
      "customerVoltageLevel": 7,
      "tariffName": "Standard BasisStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher bis 50 MWh/a",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.12,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Standard Netznutzung",
      "tariffType": "grid",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbrauch < 50 MWh/a",
      "prices": {
        "base": {
          "price": 8,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.071,
            "priceUnit": "CHF/kWh"
          }
        ],
        "power": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0,
            "priceUnit": "CHF/kW/M"
          }
        ],
        "reactivePower": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0,
            "priceUnit": "CHF/kVarh"
          }
        ],
        "refundStorage": {
          "price": 0.071,
          "priceUnit": "CHF/kWh"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Messtarif Direktmessung",
      "tariffType": "metering",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit Direktmessung",
      "prices": {
        "base": {
          "price": 5.5,
          "priceUnit": "CHF/M"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Messtarif halbindirekt NE7",
      "tariffType": "metering",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit halbindirekter Messung",
      "prices": {
        "base": {
          "price": 14.5,
          "priceUnit": "CHF/M"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Flex BasisStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit unterbrechbarer Stromlieferung",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.12,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Flex Netznutzung",
      "tariffType": "grid",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit unterbrechbarer Stromlieferung",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.0615,
            "priceUnit": "CHF/kWh"
          }
        ],
        "power": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0,
            "priceUnit": "CHF/kW/M"
          }
        ],
        "reactivePower": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0,
            "priceUnit": "CHF/kVarh"
          }
        ],
        "refundStorage": {
          "price": 0.0615,
          "priceUnit": "CHF/kWh"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Gewerbe BasisStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50000 MWh",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.1055,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Gewerbe Netznutzung",
      "tariffType": "grid",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50 MWh/a",
      "prices": {
        "base": {
          "price": 25,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.0585,
            "priceUnit": "CHF/kWh"
          }
        ],
        "power": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 8,
            "priceUnit": "CHF/kW/M"
          }
        ],
        "reactivePower": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 5.5,
            "priceUnit": "CHF/kVarh"
          }
        ],
        "refundStorage": {
          "price": 0.0585,
          "priceUnit": "CHF/kWh"
        }
      }
    },
    {
      "customerVoltageLevel": 5,
      "tariffName": "Industrie BasisStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50 MWh/a",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.1055,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 5,
      "tariffName": "Industrie Netznutzung",
      "tariffType": "grid",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "Endverbraucher mit eigener Trafostation",
      "customerType": "Endverbraucher mit eigener Trafostation",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.032,
            "priceUnit": "CHF/kWh"
          }
        ],
        "power": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 9,
            "priceUnit": "CHF/kW/M"
          }
        ],
        "reactivePower": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.055,
            "priceUnit": "CHF/kVarh"
          }
        ],
        "refundStorage": {
          "price": 0.032,
          "priceUnit": "CHF/kWh"
        }
      }
    },
    {
      "customerVoltageLevel": 5,
      "tariffName": "Messtarif halbindirekt NE5",
      "tariffType": "metering",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit halbindirekter Messung auf NE 5",
      "prices": {
        "base": {
          "price": 46.5,
          "priceUnit": "CHF/M"
        }
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Standard MixStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher bis 50 MWh/a",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.116,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Flex MixStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher mit unterbrechbarer Stromlieferung",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.116,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 7,
      "tariffName": "Gewerbe MixStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50000 MWh",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.1015,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    },
    {
      "customerVoltageLevel": 5,
      "tariffName": "Industrie MixStrom",
      "tariffType": "electricity",
      "tariffForm": "constant",
      "startDate": "2026-01-01",
      "endDate": "2026-12-31",
      "comment": "",
      "customerType": "Endverbraucher > 50 MWh/a",
      "prices": {
        "base": {
          "price": 0,
          "priceUnit": "CHF/M"
        },
        "energy": [
          {
            "from": "00:00",
            "to": "00:00",
            "price": 0.1015,
            "priceUnit": "CHF/kWh"
          }
        ]
      }
    }
  ]
}

# Clean leading tab in dsoName and merge chronologically (2026 then 2027)
merged_niederbipp = {
    "dsoName": data_2026["dsoName"].strip(),
    "dsoNumber": data_2026["dsoNumber"],
    "tariffs": data_2026["tariffs"] + data_2027["tariffs"]
}

file_path_nb = "niederbipp_tarife_2026_2027.json"
with open(file_path_nb, "w", encoding="utf-8") as f:
    json.dump(merged_niederbipp, f, ensure_ascii=False, indent=2)

print(f"File saved as {file_path_nb}")