{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Vorlage","Gemeinde allgemeine Daten","Betriebskosten","Schuldendienst","Einnahmen","Gemeinde Zusammenfassung","Hilfe"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":65,"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":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":true,"merged":[[3,3,3,6],[5,2,5,5]]}
[]
[]
[]
[{"$f":"B4+A3","v":1},1]
[]
[1,null,null,null,null,null,null,{"$f":"A6+H5","v":1}]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(E9:F9)","v":0},null,null,null,null,null,1,{"$f":"M9+N8","v":1}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G11:H11)","v":0},null,null,null,null,null,1,{"$f":"O11+P10","v":1}]
[]
[null,null,null,null,null,{"$f":"SUM(D13:E13)","v":0},null,null,null,null,null,null,null,null,null,null,1,{"$f":"Q13+R12","v":1}]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(G15:H15)","v":0},null,null,null,null,null,null,null,null,null,1,{"$f":"S15+T14","v":1}]

{"sheet":"Gemeinde allgemeine Daten","index":1,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[51,1,51,2],[51,4,51,5],[54,7,54,9],[23,4,23,8],[24,4,24,8],[28,6,28,8],[30,6,30,8],[32,6,32,7],[34,1,34,4],[34,6,34,7],[22,4,22,8],[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[17,4,17,8],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8]]}
["Förderungsansuchen für die "]
["Gewährung eines Beitrages zum"]
["Schuldendienst und Betriebskosten"]
["Wasserversorgung"]
["Antragsdaten Gemeinde/Wassergenossenschaft"]
["gem. den Förderungsrichtlinien des Landes 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 Wasserverband"]
[]
[null,"Name der Anlage"]
[]
[null,"Antrag für das Rechnungsjahr ",null,null,null,null,2024]
[]
[null,"Wasserverbrauch Gemeinde"]
[]
["Beilagen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ort",null,null,"Datum",null,null,"Rechtsverbindliche Fertigung"]
[]
[]
[null,null,null,null,null,null,null,"Name, Funktion"]

{"sheet":"Betriebskosten","index":2,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[24,3,24,6],[25,3,25,6]]}
["WASSERVERSORGUNG"]
[]
["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.) Ausgaben der Gemeinde "]
[]
[null,"1.1) Betriebskosten "]
[]
[null,null,"Förderbare Kosten"]
[]
[null,null,"Wassermeister","Ortsnetz"]
[null,null,null,"Anteilige Kosten Wasserverband"]
[]
[null,null,"Stromkosten","Ortsnetz"]
[null,null,null,"Anteilige Kosten Wasserverband"]
[]
[null,null,"Gesamt Förderbare Kosten",null,null,null,null,{"$f":"SUM(H13:H18)","v":0}]
[]
[{"$f":"SUM(B25:B29)","v":0},null,"nicht förderbare Kosten"]
[null,null,"Verwaltung"]
[null,null,"Instandsetzungsarbeiten"]
[null,null,"Anteilige Kosten Wasserverband"]
[null,null,"sonstige"]
[]
[]
[null,null,"Summe nicht förderbare Kosten",null,null,null,null,{"$f":"SUM(H22:H27)","v":0}]

{"sheet":"Schuldendienst","index":3,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["WASSERVERSORGUNG"]
[]
["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"]
[]
["2) Schuldendienst"]
[null,"jeweils Jahresdaten"]
[]
["ohne Bankspesen, Überziehungszinsen und Nebenkosten"]
[]
["2.1) Ortsnetz"]
[{"$f":"(AnzahlUWWF+AnzahlUFG+AnzahlLand+AnzahlSonstigDarlehen)","v":0}]
["U-WWF + Verkaufte U-WWF Darlehen"]
[{"$f":"SUM(M18:M23)","v":0}]
["BA","Bank","Kontonr.","Datum Schluss- Rate","Tilgung ","Zinsen","Annuität"]
[null,null,null,null,null,null,{"$f":"SUM(E18:F18)","v":0}]
[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,{"$f":"SUM(UWWFTilgung:E20)","v":0},{"$f":"SUM(UWWFZinsen:F20)","v":0},{"$f":"SUM(UWWFAnnuität:G20)","v":0}]
[]
[]
[]
["UFG"]
[{"$f":"SUM(O28: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(G28:H28)","v":0}]
[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,{"$f":"SUM(UFGTilgung:G30)","v":0},{"$f":"SUM(UFGZinsen:H30)","v":0},{"$f":"SUM(UFGAnnuität:I30)","v":0},{"$f":"SUM(UFGFZ:J30)","v":0}]
[]
[null,null,null,null,null,null,null,"Annuität netto gesamt",null,{"$f":"G31+H31-J31","v":0}]
[]
[]
[]
["Zinsgestützte Landeshypothekenbank Darlehen"]
[{"$f":"SUM(Q40:Q47)","v":0}]
["BA","Kontonr","Datum Schluss- Rate","Tilgung ","Zinsen","Annuität","Annuitäten Zusch. Land"]
[null,null,null,null,null,{"$f":"SUM(D40:E40)","v":0}]
[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,{"$f":"SUM(LandTilgung:D42)","v":0},{"$f":"SUM(LandZinsen:E42)","v":0},{"$f":"SUM(LandAnnuität:F42)","v":0},{"$f":"SUM(LandFZ:G42)","v":0}]
[]
[null,null,null,null,"Annuität netto gesamt",null,{"$f":"D43+E43-G43","v":0}]
[]
[]
[]
[]
["Sonstige Darlehen"]
["Darlehen lt. Finanzierungsplan"]
[{"$f":"SUM(S55:S60)","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":"E21+F21","v":0},"keine",{"$f":"F64","v":0}]
["Summe UFG",null,null,null,null,{"$f":"G31+H31","v":0},{"$f":"J31","v":0},{"$f":"F65-G65","v":0}]
["Summe Zinsgestütze Hypo Darlehen",null,null,null,null,{"$f":"D43+E43","v":0},{"$f":"G43","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}]
[]
[]
["2.2) Schuldendienst Vorschreibung Wasserverband/Gruppenanlage"]
[null,"Anteil Gemeinde",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Betrag gesamt"]
[]
[]
[null,"Summe Schuldendienst",null,null,null,null,null,{"$f":"H74+H68","v":0}]

{"sheet":"Einnahmen","index":4,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5]]}
["WASSERVERSORGUNG"]
[]
["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}]
[]
["3.) Einnahmen"]
[]
[null,"Anschlussgebühr"]
[]
[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,1.5,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(A23:A30)","v":0}]
[null,"Sonstige Einnahmen"]
[]
[]
[]
[]
[]
[]
[null,"Einnahmen",null,null,null,null,{"$f":"SUM(G8:G27)","v":0}]
[]
[]
[null,"Gemeindebeitrag"]

{"sheet":"Gemeinde Zusammenfassung","index":5,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["WASSERVERSORGUNG"]
[]
["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":"Schuldendienst!H77","v":0}]
[null,"Betriebskosten (Wassermeister, Strom)",null,null,null,null,{"$f":"Betriebskosten!H19","v":0}]
[]
[null,"Summe Ausgaben",null,null,null,null,{"$f":"SUM(G11:G12)","v":0}]
[]
[null,"Einnahmen",null,null,null,null,{"$f":"Einnahmen!G29","v":0}]
[null,"Gemeindebeitrag",null,null,null,null,{"$f":"Einnahmen!G32","v":0}]
[]
[null,{"$f":"IF(G19>0,\"förderbarer Abgang\",\"rechnerischer Übschuss\")","v":"rechnerischer Übschuss"},null,null,null,null,{"$f":"G14-G16-G17","v":0}]

{"sheet":"Hilfe","index":6,"n_rows":97,"n_cols":4,"rows_kept":97,"cut":false,"hidden":false,"merged":[[26,0,26,2],[26,4,26,6],[35,0,35,2],[35,4,35,6],[15,0,15,2],[24,0,24,2],[24,4,24,6],[25,0,25,2],[25,4,25,6],[62,0,62,2],[62,4,62,6],[63,0,63,2],[63,4,63,6],[44,0,44,2],[44,4,44,6],[53,0,53,2],[53,4,53,6],[81,0,81,2],[81,4,81,6],[90,0,90,2],[64,0,64,2],[64,4,64,6],[73,0,73,2],[73,4,73,6]]}
["WASSERVERSORGUNG"]
[]
["Gemeinde",{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Beitrag zum Schuldendienst",null,"Rechnungsjahr",{"$f":"Betriebskosten!H4","v":2024}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1/___/   Leistungen Personal"]
["Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C17:C21)","v":0}]
[]
[]
["Wartung, Instandhaltung, Betriebsmittel"]
[]
["1/____/4____   Gebrauchs- Verbrauchsgüter Handleswarenverbrauch"]
["Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C29:C32)","v":0}]
[]
[]
["1/___  /0 ____    Anlagen"]
["Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C37:C41)","v":0}]
[]
[]
["1/___/61-62   Instandhaltung Transportkosten"]
["Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C47:C50)","v":0}]
[]
[]
["1/____/728       Entgelte für sonstige Leistungen von Gewerbetreibenden"]
["Bezeichnung",null,"Betrag"]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C56:C59)","v":0}]
[]
[]
["Sonstige Kosten"]
[]
["1/___/63-64   Porto Telefon, Rechtsberatung"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C67:C70)","v":0}]
[]
[]
["1/___/67,69   Versicherungen, Schadensfälle"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C76:C79)","v":0}]
[]
["1/___/70-71 Miet- und Pachtzins, öffentliche Abgaben"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C84:C87)","v":0}]
[]
[]
["1/___/726 Zahlungen an WV mit Außnahme von Betriebskosten und Schuldendienst"]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C93:C96)","v":0}]