{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Vorlage","Gemeinde allgemeine Daten","Gemeinde Betriebskosten","Gemeinde Schuldendienst","Gemeinde Einnahmen","Gemeinde Zusammenfassung","Hilfe"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":58,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vorlage","index":0,"n_rows":25,"n_cols":20,"rows_kept":25,"cut":false,"hidden":true,"merged":[[16,2,16,5],[13,4,13,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,1,"sonstige Betriebskosten",null,null,null,null,0,{"$f":"B10+I9","v":1}]
[]
[null,1,"sonstige Kosten",null,null,null,null,0,null,{"$f":"B12+J11","v":1}]
[]
[null,1,"PW",{"$f":"1+D13","v":1},null,null,null,0]
[]
[]
[null,null,null,null,null,null,null,1,{"$f":"H17+I16","v":1}]
[]
[null,null,null,null,null,null,{"$f":"SUM(E19:F19)","v":0},null,null,null,null,null,1,{"$f":"M19+N18","v":1}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G21:H21)","v":0},null,null,null,null,null,1,{"$f":"O21+P20","v":1}]
[]
[null,null,null,null,null,{"$f":"SUM(D23:E23)","v":0},null,null,null,null,null,null,null,null,null,null,1,{"$f":"Q23+R22","v":1}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G25:H25)","v":0},null,null,null,null,null,null,null,null,null,1,{"$f":"S25+T24","v":1}]

{"sheet":"Gemeinde allgemeine Daten","index":1,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[56,7,56,9],[28,6,28,8],[34,6,34,7],[24,4,24,8],[53,1,53,2],[53,4,53,5],[34,1,34,4],[30,6,30,8],[35,6,35,7],[32,6,32,7],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[18,4,18,8],[17,4,17,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[4,0,4,9],[19,4,19,8],[20,4,20,8]]}
["Förderungsansuchen für die "]
["Gewährung eines Beitrages zum"]
["Schuldendienst und Betriebskosten"]
["Abwasser"]
["Antragsdaten Gemeinde"]
["gem. den Förderungsrichtlinien des Landes vom vom 21.10.2016, Zl. 20011-RU/2016/251-2016"]
[]
[]
["An das"]
["Land Salzburg"]
["Abteilung Wasser"]
["Postfach 527"]
["5010 Salzburg"]
[]
[]
["Förderungswerber"]
[]
[null,"Name"]
[null,"Ort"]
[null,"Postleitzahl"]
[null,"Straße/Nummer"]
[null,"Telefonnummer"]
[null,"Telefaxnummer"]
[null,"E-Mail"]
[null,"Ansprechperson / Durchwahl"]
[]
[]
[]
[null,"Mitglied beim RHV/Gruppenanlage"]
[]
[null,"Name der Anlage"]
[]
[null,"Antrag für das Rechnungsjahr ",null,null,null,null,2024]
[]
[null,"Wasserverbrauch Gemeinde"]
[null,"Wasserverbrauch RHV/Gruppenanlage gesamt "]
[]
["Beilagen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ort",null,null,"Datum",null,null,"Rechtsverbindliche Fertigung"]
[]
[]
[null,null,null,null,null,null,null,"Name, Funktion"]

{"sheet":"Gemeinde Betriebskosten","index":2,"n_rows":80,"n_cols":10,"rows_kept":80,"cut":false,"hidden":false,"merged":[[76,4,76,6],[77,4,77,6]]}
["ABWASSER"]
[]
["Gemeinde",null,null,{"$f":"'Gemeinde allgemeine Daten'!E18","v":0}]
["Beitrag zum Schuldendienst",null,null,null,null,null,"Rechnungsjahr",{"$f":"'Gemeinde allgemeine Daten'!G33","v":2024}]
[]
[]
["1.) Förderbare Betriebskosten nach Pauschalsätzen"]
[null,"Eine Darstellung der detailierten Betriebskosten ist nicht erforderlich."]
[null,"Die Berechnung der förderbaren Betriebskosten erfolgt automatisiert."]
[]
[]
[]
[]
[null,"1.1) Betriebskosten "]
[]
[null,null,"Vorschreibung RHV"]
[{"$f":"SUM(AnzahlPW+AnzahlARA+AnzahlKanal)","v":2}]
[{"$f":"SUM(B25:B28)","v":0},null,"Kläranlage"]
[]
[null,null,"Energiekosten",null,"Kläranlage"]
[null,null,null,null,"Hebeanlage zur Kläranlage"]
[null,null,null,null,"sonst"]
[null,null,"Schlammbehandlung und -beseitigung"]
[null,null,"Wartung Instandhaltung"]
[null,null,"sonstige Betriebskosten"]
[null,null,"sonstige Betriebskosten"]
[null,null,"Gesamt Kläranlage",null,null,null,null,{"$f":"SUM(BKVorschreibungRHV:H26)","v":0}]
[]
[{"$f":"SUM(B30:B33)","v":0},null,"Kanal"]
[null,null,"Wartung, Instandhaltung"]
[null,null,"sonstige Kosten"]
[null,null,"Gesamt Kanal",null,null,null,null,{"$f":"SUM(BKWartungKanal:H31)","v":0}]
[]
[null,null,"Personalkosten (Kanal u. Kläranlage) "]
[]
[]
[null,null,"Summe Betriebskosten",null,null,null,null,{"$f":"H32+H27+H34","v":0}]
[]
[null,null,"1.2) Verwaltungsaufwand"]
[]
[]
[null,null,"Summe Betrieb und Verwaltung",null,null,null,null,{"$f":"H39+H37","v":0}]
[]
[]
[]
[null,null,"Berechnung"]
[null,null,"Wassermenge",{"$f":"IF('Gemeinde allgemeine Daten'!G36>0,'Gemeinde allgemeine Daten'!G36,'Gemeinde allgemeine Daten'!G35)","v":0}]
[null,null,"Betrag",{"$f":"IF(D47<D53,H59*(I59-J59*D47/1000),IF(D47<D54,H60*(I60-J60*D47/1000),H61*I61))","v":1.6269}]
[]
[]
[null,null,"Werte"]
[null,null,"von","bis",null,"Errechneter Wert","Menge"]
[null,null,0,267000,null,{"$f":"H59*(I59-J59*G53/1000)","v":0.93574800000000002},264000]
[null,null,267000,1200000,null,{"$f":"H60*(I60-J60*G54/1000)","v":0.90418239999999994},268000]
[null,null,1200000,null,null,{"$f":"H61*I61","v":0.33660000000000001},2500000]
[]
[]
[null,null,"Formel",null,null,null,null,"Index"]
[null,null,"bis 267.000","Index ","x","(€ 0,87 - 0,0014 x Q in m³ / 1.000)",null,{"$f":"$H$68","v":1.87},0.87,1.4E-3]
[null,null,"von 267.000 bis 1.200.000","Index ","x","(€ 0,58 - 0,00036 x Q in m³ / 1.000)",null,{"$f":"$H$68","v":1.87},0.57999999999999996,3.6000000000000002E-4]
[null,null,"ab 1.200.000","Index ","x",0.18,null,{"$f":"$H$68","v":1.87},0.18]
[]
[]
[]
[null,null,"Summe Betriebskosten Kläranlage und Kanal"]
[null,null,"Verwaltungskosten"]
[]
[null,null,"Index Berechnung Pauschalsatz",null,null,null,null,1.87]
[]
[null,null,"förderbare Betriebskosten",null,null,null,null,{"$f":"D48*'Gemeinde allgemeine Daten'!G35","v":0}]
[]
[]
["2.) Betriebskosten förderbar zu 100% Pumpwerke "]
[null,null,"(jedoch nicht Hebeanlage zur Kläranlage)"]
[]
[null,null,null,null,"Bezeichnung"]
[{"$f":"SUM(B77:B79)","v":2},1,"PW",1]
[null,1,"PW",2]
[]
[null,null,"Summe Betriebskosten 100% förderbar ",null,null,null,null,{"$f":"SUM(BKPW1:H79)","v":0}]

{"sheet":"Gemeinde Schuldendienst","index":3,"n_rows":81,"n_cols":10,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["ABWASSER"]
[]
["Gemeinde",null,{"$f":"'Gemeinde allgemeine Daten'!E18","v":0}]
["Beitrag zum Schuldendienst",null,null,null,null,null,null,null,"Rechnungsjahr",{"$f":"'Gemeinde allgemeine Daten'!G33","v":2024}]
[]
["Gemeindedaten"]
[]
["3) Schuldendienst"]
[null,"jeweils Jahresdaten"]
[]
["ohne Bankspesen, Überziehungszinsen und Nebenkosten"]
[]
["3.1) Ortsnetz"]
[null,"einschl. allfälliger Darlehen die vom Reinhaltungsverband verwaltet werden"]
[{"$f":"(AnzahlUWWF+AnzahlUFG+AnzahlLand+AnzahlSonstigDarlehen)","v":0}]
["UWWF + Verkaufte UWWF Darlehen"]
[{"$f":"SUM(M19:M23)","v":0}]
["BA","Bank","Kontonr.","Datum Schluss-rate","Tilgung ","Zinsen","Annuität"]
[null,null,null,null,null,null,{"$f":"SUM(E19:F19)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(E20:F20)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(E21:F21)","v":0}]
[null,null,null,null,{"$f":"SUM(UWWFTilgung:E21)","v":0},{"$f":"SUM(UWWFZinsen:F21)","v":0},{"$f":"SUM(UWWFAnnuität:G21)","v":0}]
[]
[]
[]
["UFG"]
[{"$f":"SUM(O29:O35)","v":0}]
["BA","Bank","Konto-nummer","Zinssatz","Datum Schluss-rate","Nominale²","Tilgung ","Zinsen","Annuität","Finanzierungs Zusch."]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G29:H29)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G30:H30)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G31:H31)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(UFGTilgung:G31)","v":0},{"$f":"SUM(UFGZinsen:H31)","v":0},{"$f":"SUM(UFGAnnuität:I31)","v":0},{"$f":"SUM(UFGFZ:J31)","v":0}]
[]
[null,null,null,null,null,null,null,"Annuität netto gesamt",null,{"$f":"G32+H32-J32","v":0}]
[]
[]
[]
["Zinsgestütze Landeshypothekenbank Darlehen"]
[{"$f":"SUM(Q41:Q47)","v":0}]
["BA","Kontonr","Datum Schlussrate","Tilgung ","Zinsen","Annuität","Annuitäten Zusch. Land"]
[null,null,null,null,null,{"$f":"SUM(D41:E41)","v":0}]
[null,null,null,null,null,{"$f":"SUM(D42:E42)","v":0}]
[null,null,null,null,null,{"$f":"SUM(D43:E43)","v":0}]
[null,null,null,{"$f":"SUM(LandTilgung:D43)","v":0},{"$f":"SUM(LandZinsen:E43)","v":0},{"$f":"SUM(LandAnnuität:F43)","v":0},{"$f":"SUM(LandFZ:G43)","v":0}]
[]
[null,null,null,null,"Annuität netto gesamt",null,{"$f":"D44+E44-G44","v":0}]
[]
[]
[]
["Sonstige Darlehen"]
["Darlehen lt. Finanzierungsplan"]
[{"$f":"SUM(S55:S61)","v":0}]
["BA","Bank","Kontonummer","Zinssatz","Datum Schluss-rate","Nominale²","Tilgung ","Zinsen","Annuität"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G54:H54)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G55:H55)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G56:H56)","v":0}]
[null,null,null,null,null,null,{"$f":"SUM(SonstigTilgung:G56)","v":0},{"$f":"SUM(SonstigZinsen:H56)","v":0},{"$f":"SUM(SonstigAnnuität:I56)","v":0}]
[]
[null,null,null,null,null,"Annuität gesamt",null,null,{"$f":"G57+H57","v":0}]
[]
[]
[]
["Zusammenfassung",null,null,null,null,"Annuität","Zuschüsse","Gesamt"]
["Summe UWWF",null,null,null,null,{"$f":"E22+F22","v":0},"keine",{"$f":"F64","v":0}]
["Summe UFG",null,null,null,null,{"$f":"G32+H32","v":0},{"$f":"J32","v":0},{"$f":"F65-G65","v":0}]
["Summe Zinsgestütze Hypo Darlehen",null,null,null,null,{"$f":"D44+E44","v":0},{"$f":"G44","v":0},{"$f":"F66-G66","v":0}]
["Summe Sonstige Darlehen",null,null,null,null,{"$f":"G57+H57","v":0},"keine",{"$f":"F67","v":0}]
[null,null,null,null,null,{"$f":"SUM(F64:F67)","v":0},{"$f":"SUM(G64:G67)","v":0},{"$f":"SUM(H64:H67)","v":0}]
[]
[]
["3.2) Schuldendienst Vorschreibung Reinhaltungsverband/Gruppenanlage"]
[null,"Anteil Gemeinde",null,{"$f":"'Gemeinde allgemeine Daten'!E18","v":0}]
[]
[null,"Betrag gesamt"]
[]
[]
[null,"Summe Schuldendienst",null,null,null,null,null,{"$f":"H74+H68","v":0}]
[]
[]
[]
[null,"²  Nominale bei Rückzahlungsbeginn bzw. lt. Finanzierungsplan bei Kollaudierung"]

{"sheet":"Gemeinde Einnahmen","index":4,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,2,24,5],[22,2,22,5],[23,2,23,5]]}
["ABWASSER"]
[]
["Gemeinde",null,null,{"$f":"'Gemeinde allgemeine Daten'!E18","v":0}]
["Beitrag zum Schuldendienst",null,null,null,null,"Rechnungsjahr",{"$f":"'Gemeinde allgemeine Daten'!G33","v":2024}]
[]
["4.) Einnahmen"]
[]
[null,"Intersessentbeitrag"]
[]
[null,"Benützungsgebühr"]
[null,null,"Wasserverbrauch",null,{"$f":"'Gemeinde allgemeine Daten'!G35","v":0}]
[null,null,"Beschlossene Gebühr",null,null,{"$f":"E11*E12","v":0}]
[null,null,"Gebühr Landessatz",null,3.8,null,{"$f":"E11*E13","v":0}]
[]
[]
[null,null,"Nachverrechnungen"]
[]
[null,null,"(Eingabe der Zahlen ohne Einheit)"]
[]
[null,null,"gemäß § 9 Abs. 1 und Abs. 4 Benützungsgebührgesetzes"]
[]
[{"$f":"SUM(H:H)","v":3},"Sonstige Einnahmen"]
[null,null,null,null,null,null,null,1,{"$f":"H23+I22","v":1}]
[null,null,null,null,null,null,null,1,{"$f":"H24+I23","v":2}]
[null,null,null,null,null,null,null,1,{"$f":"H25+I24","v":3}]
[]
[]
[null,"Einnahmen",null,null,null,null,{"$f":"SUM(G8:G27)","v":0}]
[]
[]
[null,"Gemeindebeitrag"]

{"sheet":"Gemeinde Zusammenfassung","index":5,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["ABWASSER"]
[]
["Gemeinde",null,{"$f":"'Gemeinde allgemeine Daten'!E18","v":0}]
["Beitrag zum Schuldendienst",null,null,null,null,"Rechnungsjahr",{"$f":"'Gemeinde allgemeine Daten'!G33","v":2024}]
[]
[]
[]
["Zusammenfassung"]
[]
[]
[null,"Schuldendienst",null,null,null,null,{"$f":"'Gemeinde Schuldendienst'!H77","v":0}]
[null,"Betriebskosten (pauschal gefördert)",null,null,null,null,{"$f":"'Gemeinde Betriebskosten'!H70","v":0}]
[null,"Betriebskosten (100% gefördert)",null,null,null,null,{"$f":"'Gemeinde Betriebskosten'!H80","v":0}]
[]
[null,"Summe Ausgaben",null,null,null,null,{"$f":"SUM(G11:G13)","v":0}]
[]
[null,"Einnahmen",null,null,null,null,{"$f":"'Gemeinde Einnahmen'!G28","v":0}]
[null,"Gemeindebeitrag",null,null,null,null,{"$f":"'Gemeinde Einnahmen'!G31","v":0}]
[]
[null,{"$f":"IF(G20>0,\"förderbarer Abgang\",\"rechnerischer Übschuss\")","v":"rechnerischer Übschuss"},null,null,null,null,{"$f":"G15-G17-G18","v":0}]

{"sheet":"Hilfe","index":6,"n_rows":103,"n_cols":7,"rows_kept":103,"cut":false,"hidden":false,"merged":[[31,0,31,2],[31,4,31,6],[11,0,11,2],[21,0,21,2],[30,0,30,2],[30,4,30,6],[68,4,68,6],[59,0,59,2],[59,4,59,6],[68,0,68,2],[32,0,32,2],[32,4,32,6],[41,0,41,2],[41,4,41,6],[50,0,50,2],[50,4,50,6],[69,0,69,2],[69,4,69,6],[70,0,70,2],[70,4,70,6],[96,0,96,2],[79,0,79,2],[79,4,79,6],[87,0,87,2],[87,4,87,6]]}
["ABWASSER"]
[]
["Gemeinde",null,{"$f":"'Gemeinde Betriebskosten'!D3","v":0}]
["Beitrag zum Schuldendienst",null,null,null,null,"Rechnungsjahr",{"$f":"'Gemeinde Betriebskosten'!H4","v":2024}]
[]
[]
[]
[]
[]
[]
[]
["1/___/   Leistungen Personal"]
["Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C13:C18)","v":0}]
[]
[]
["Schlammbehandlung/Schlammbeseitigung"]
["Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C23:C27)","v":0}]
[]
[]
["Wartung, Instandhaltung, Betriebsmittel außer Schlambehandlung/Beseitigung",null,null,null,"Wartung, Instandhaltung, Betriebsmittel"]
["Kläranlage",null,null,null,"Kanal"]
["1/____/4____   Gebrauchs- Verbrauchsgüter Handleswarenverbrauch",null,null,null,"1/____/4____   Gebrauchs- Verbrauchsgüter Handleswarenverbrauch"]
["Bezeichnung",null,"Betrag",null,"Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C35:C38)","v":0},null,null,null,{"$f":"SUM(G35:G38)","v":0}]
[]
[]
["1/___  /0 ____    Anlagen",null,null,null,"1/___  /0 ____    Anlagen"]
["Bezeichnung",null,"Betrag",null,"Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C43:C47)","v":0},null,null,null,{"$f":"SUM(G43:G47)","v":0}]
[]
[]
["1/___/61-62   Instandhaltung Transportkosten",null,null,null,"1/___/61-62   Instandhaltung Transportkosten"]
["Bezeichnung",null,"Betrag",null,"Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C53:C56)","v":0},null,null,null,{"$f":"SUM(G53:G56)","v":0}]
[]
[]
["1/____/728       Entgelte für sonstige Leistungen von Gewerbetreibenden",null,null,null,"1/____/728       Entgelte für sonstige Leistungen von Gewerbetreibenden"]
["Bezeichnung",null,"Betrag",null,"Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C62:C65)","v":0},null,null,null,{"$f":"SUM(G62:G65)","v":0}]
[]
[]
["Sonstige Kosten",null,null,null,"Sonstige Kosten"]
["Kläranlage",null,null,null,"Kanal"]
["1/___/63-64   Porto Telefon, Rechtsberatung",null,null,null,"1/___/63-64   Porto Telefon, Rechtsberatung"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C73:C76)","v":0},null,null,null,{"$f":"SUM(G73:G76)","v":0}]
[]
[]
["1/___/67,69   Versicherungen, Schadensfälle",null,null,null,"1/___/67,69   Versicherungen, Schadensfälle"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C82:C85)","v":0},null,null,null,{"$f":"SUM(G82:G85)","v":0}]
[]
["1/___/70-71 Miet- und Pachtzins, öffentliche Abgaben",null,null,null,"1/___/70-71 Miet- und Pachtzins, öffentliche Abgaben"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C90:C93)","v":0},null,null,null,{"$f":"SUM(G90:G93)","v":0}]
[]
[]
["1/___/726 Zahlungen an RHV mit Außnahme von Betriebskosten und Schuldendienst"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C99:C102)","v":0}]