{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Stundennachweis_Abrechnung","Datentabelle","Drop Down"],"not_rendered":{"images":1,"defined_names":5,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Stundennachweis_Abrechnung","index":0,"n_rows":31,"n_cols":13,"rows_kept":31,"merged":[[2,1,2,4],[2,8,4,10],[4,1,4,4],[5,0,5,3],[6,1,6,4],[6,5,6,6],[6,7,6,8],[8,0,8,3],[8,4,8,6],[8,7,8,8],[8,10,8,12],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,9,8],[9,10,10,10],[9,11,10,11],[9,12,10,12],[25,0,25,1],[25,3,25,4],[25,10,25,11],[26,0,26,1],[26,3,26,4],[29,0,29,1],[29,3,29,4],[30,0,30,1],[30,3,30,4]]}
["Abrechnungsnachweis kirchenmusikalischer Tätigkeiten und Stundennachweis nach Mindestlohngesetz",{"$nulls":7},"Version 5.0 / ab Januar 2025"]
[]
["Arbeitnehmer/in:",{"$nulls":4},"Abrechnungszeitraum (Kalendermonat/Jahr)",null,null,"Hinweis: Das Formular ist am Monatsende bei der zuständigen personalverwaltenden Dienststelle einzureichen."]
[]
["Einstufung/\nEntgeltsatz nach Entgeltstufe"]
[]
["Arbeitgeber:"]
[]
["Dokumentation: Arbeitszeit nach MiLoG",{"$nulls":3},"Abrechnungsrelevante Daten",null,null,"Fahrtkostenzuschuss",null,null,"Berechnung des Entgelts"]
["Datum","Beginn ","Ende ","Arbeitszeit abzüglich Pausen (in Stunden:\nMinuten)","1) Anlass / Gottesdienst und","Tätigkeit","2) Chorproben / sonstige Tätigkeiten","nur sofern im begründeten Ausnahmefall vertraglich vereinbart",null,null,"Vergütungs-satz","Vergütungs-satz sonstige Tätigkeiten","Summe"]
[{"$nulls":7},"Kilometer Wegstrecke KFZ","Fahrtkosten-ersatz ÖPNV","Hilfsspalte Fahrtkosten"]
[{"$nulls":9},{"$f":"ROUND(IF(AND(H12<=5,I12=\"\"),MIN(11,I12*1),MIN(H12*0.3+I12,11)),2)","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E12&F12,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E12&F12,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G12,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G12,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K12+IF(G12='Drop Down'!$E$14,L12*((D12-INT(D12))*24),Stundennachweis_Abrechnung!L12),2)","v":0}]
[{"$nulls":9},{"$f":"ROUND(IF(AND(H13<=5,I13=\"\"),MIN(11,I13*1),MIN(H13*0.3+I13,11)),2)","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E13&F13,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E13&F13,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G13,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G13,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K13+IF(G13='Drop Down'!$E$14,L13*((D13-INT(D13))*24),Stundennachweis_Abrechnung!L13),2)","v":0}]
[{"$nulls":9},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E14&F14,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E14&F14,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G14,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G14,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K14+IF(G14='Drop Down'!$E$14,L14*((D14-INT(D14))*24),Stundennachweis_Abrechnung!L14),2)","v":0}]
[{"$nulls":9},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E15&F15,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E15&F15,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G15,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G15,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K15+IF(G15='Drop Down'!$E$14,L15*((D15-INT(D15))*24),Stundennachweis_Abrechnung!L15),2)","v":0}]
[{"$nulls":9},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E16&F16,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E16&F16,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G16,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G16,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K16+IF(G16='Drop Down'!$E$14,L16*((D16-INT(D16))*24),Stundennachweis_Abrechnung!L16),2)","v":0}]
[{"$nulls":9},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E17&F17,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E17&F17,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G17,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G17,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K17+IF(G17='Drop Down'!$E$14,L17*((D17-INT(D17))*24),Stundennachweis_Abrechnung!L17),2)","v":0}]
[{"$nulls":9},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E18&F18,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E18&F18,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G18,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G18,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K18+IF(G18='Drop Down'!$E$14,L18*((D18-INT(D18))*24),Stundennachweis_Abrechnung!L18),2)","v":0}]
[null,null," ",{"$nulls":6},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E19&F19,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E19&F19,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G19,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G19,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K19+IF(G19='Drop Down'!$E$14,L19*((D19-INT(D19))*24),Stundennachweis_Abrechnung!L19),2)","v":0}]
[{"$nulls":9},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E20&F20,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E20&F20,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G20,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G20,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K20+IF(G20='Drop Down'!$E$14,L20*((D20-INT(D20))*24),Stundennachweis_Abrechnung!L20),2)","v":0}]
[null,null," ",{"$nulls":6},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E21&F21,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E21&F21,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G21,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G21,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K21+IF(G21='Drop Down'!$E$14,L21*((D21-INT(D21))*24),Stundennachweis_Abrechnung!L21),2)","v":0}]
[null,null," ",{"$nulls":6},0,{"$f":"IF(ISNA(INDEX(Datentabelle!A:O,MATCH(E22&F22,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0))),0,INDEX(Datentabelle!A:O,MATCH(E22&F22,Datentabelle!A:A&Datentabelle!B:B,0),MATCH($B$5,Datentabelle!$A$1:$O$1,0)))","v":0},{"$f":"IF(ISNA(INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G22,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0))),0,INDEX(Datentabelle!T:AG,MATCH(Stundennachweis_Abrechnung!G22,Datentabelle!T:T,0),MATCH(Stundennachweis_Abrechnung!$B$5,Datentabelle!$T$1:$AG$1,0)))","v":0},{"$f":"ROUND(K22+IF(G22='Drop Down'!$E$14,L22*((D22-INT(D22))*24),Stundennachweis_Abrechnung!L22),2)","v":0}]
[{"$nulls":6},"Summe Fahrtkostenzuschuss:",{"$f":"SUM(J12:J22)","v":0},null,null,"Summe Entgelt:",null,{"$f":"SUM(M12:M22)","v":0}]
[]
[]
[]
["Datum",null,null,"Unterschrift Kirchenmusiker/-in",null,null,"Datum",null,"Unterschrift Sachbearbeiter/-in"]
[]
[]
[]
["Datum",null,null,"Unterschrift Anordnungsberechtigte/-r"]

{"sheet":"Datentabelle","index":1,"n_rows":43,"n_cols":33,"rows_kept":43,"hidden":true}
["Anlass Gottesdienst","Tätigkeit","DE","A","B+50% (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)","B","90%B","C+50%  (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)","80%B","C","D+50% (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)","95%C","D","B (Besitzstand gem. § 16 Abs. 1 Anlage 4f zur AVO)","90%B (Besitzstand nach § 16 Abs. 2 Anlage 4f zur AVO)",{"$nulls":4},"sonstige Tätigkeit","Diensteinheiten","A","B+50% (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)","B","90%B","C+50%  (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)","80%B","C","D+50% (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)","95%C","D","B (Besitzstand gem. § 16 Abs. 1 Anlage 4f zur AVO)","90%B (Besitzstand nach § 16 Abs. 2 Anlage 4f zur AVO)"]
["Gottesdienste an Sonntagen (einschl. Vorabend) und Feiertagen","Orgelspiel",1,{"v":62.93,"d":"62.93 €"},{"$f":"ROUND(F2+(D2-F2)*0.5,2)","v":{"v":58.03,"d":"58.03 €"}},{"v":53.13,"d":"53.13 €"},{"$f":"ROUND(0.9*F2,2)","v":{"v":47.82,"d":"47.82 €"}},{"$f":"ROUND(J2+(F2-J2)*0.5,2)","v":{"v":46.76,"d":"46.76 €"}},{"$f":"ROUND(0.8*F2,2)","v":{"v":42.5,"d":"42.50 €"}},{"v":40.38,"d":"40.38 €"},{"$f":"ROUND(M2+(J2-M2)*0.5,2)","v":{"v":39.01,"d":"39.01 €"}},{"$f":"ROUND(0.95*J2,2)","v":{"v":38.36,"d":"38.36 €"}},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"$f":"ROUND(0.9*N2,2)","v":{"v":47.82,"d":"47.820 €"}},{"$nulls":4},"Chorprobe/Ensembleprobe bis einschl. 60 min",1,{"v":62.93,"d":"62.930 €"},{"$f":"ROUND(X2+(V2-X2)*0.5,2)","v":{"v":58.03,"d":"58.030 €"}},{"v":53.13,"d":"53.130 €"},{"$f":"ROUND(0.9*X2,2)","v":{"v":47.82,"d":"47.820 €"}},{"$f":"ROUND(AB2+(X2-AB2)*0.5,2)","v":{"v":46.76,"d":"46.760 €"}},{"$f":"ROUND(0.8*X2,2)","v":{"v":42.5,"d":"42.500 €"}},{"v":40.38,"d":"40.380 €"},{"$f":"ROUND(AE2+(AB2-AE2)*0.5,2)","v":{"v":39.01,"d":"39.010 €"}},{"$f":"ROUND(0.95*AB2,2)","v":{"v":38.36,"d":"38.360 €"}},{"v":37.63,"d":"37.630 €"},{"v":53.13,"d":"53.130 €"},{"$f":"ROUND(0.9*AF2,2)","v":{"v":47.82,"d":"47.820 €"}}]
["Gottesdienste an Sonntagen (einschl. Vorabend) und Feiertagen","Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"$f":"ROUND(F3+(D3-F3)*0.5,2)","v":{"v":87.05,"d":"87.05 €"}},{"v":79.7,"d":"79.70 €"},{"$f":"ROUND(0.9*F3,2)","v":{"v":71.73,"d":"71.73 €"}},{"$f":"ROUND(J3+(F3-J3)*0.5,2)","v":{"v":70.14,"d":"70.14 €"}},{"$f":"ROUND(0.8*F3,2)","v":{"v":63.76,"d":"63.76 €"}},{"v":60.58,"d":"60.58 €"},{"$f":"ROUND(M3+(J3-M3)*0.5,2)","v":{"v":58.52,"d":"58.52 €"}},{"$f":"ROUND(0.95*J3,2)","v":{"v":57.55,"d":"57.55 €"}},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"$f":"ROUND(0.9*N3,2)","v":{"v":71.73,"d":"71.730 €"}},{"$nulls":4},"Chorprobe/Ensembleprobe bis einschl. 90 min",1.5,{"v":94.4,"d":"94.400 €"},{"v":87.05,"d":"87.050 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"},{"v":70.14,"d":"70.140 €"},{"v":63.76,"d":"63.760 €"},{"v":60.58,"d":"60.580 €"},{"v":58.52,"d":"58.520 €"},{"$f":"ROUND(0.95*AB3,2)","v":{"v":57.55,"d":"57.550 €"}},{"v":56.45,"d":"56.450 €"},{"v":79.7,"d":"79.700 €"},{"$f":"ROUND(0.9*AF3,2)","v":{"v":71.73,"d":"71.730 €"}}]
["Gottesdienste an Sonntagen (einschl. Vorabend) und Feiertagen","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"$f":"ROUND(0.9*N4,2)","v":{"v":71.73,"d":"71.730 €"}},{"$nulls":4},"Chorprobe/Ensembleprobe bis einschl. 120 min",2,{"v":125.87,"d":"125.870 €"},{"v":116.07,"d":"116.070 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"},{"v":93.52,"d":"93.520 €"},{"v":85.02,"d":"85.020 €"},{"v":80.77,"d":"80.770 €"},{"v":78.02,"d":"78.020 €"},{"v":76.73,"d":"76.730 €"},{"v":75.27,"d":"75.270 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"}]
["Werktagsgottesdienst","Orgelspiel",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"},{"$nulls":4},"Chorprobe mit Kinder- und Jugendchor bis einschl. 60 min",1,{"v":62.93,"d":"62.930 €"},{"v":58.03,"d":"58.030 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"},{"v":46.76,"d":"46.760 €"},{"v":42.5,"d":"42.500 €"},{"v":40.38,"d":"40.380 €"},{"v":39.01,"d":"39.010 €"},{"v":38.36,"d":"38.360 €"},{"v":37.63,"d":"37.630 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Werktagsgottesdienst","Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"$f":"ROUND(F6+(D6-F6)*0.5,2)","v":{"v":87.05,"d":"87.05 €"}},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"},{"$nulls":4},"Chorprobe mit Kinder- und Jugendchor bis einschl. 90 min",1.5,{"v":94.4,"d":"94.400 €"},{"v":87.05,"d":"87.050 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"},{"v":70.14,"d":"70.140 €"},{"v":63.76,"d":"63.760 €"},{"v":60.58,"d":"60.580 €"},{"v":58.52,"d":"58.520 €"},{"v":57.55,"d":"57.550 €"},{"v":56.45,"d":"56.450 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Werktagsgottesdienst","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"$f":"ROUND(F7+(D7-F7)*0.5,2)","v":{"v":87.05,"d":"87.05 €"}},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"},{"$nulls":4},"Prozession mit Chorgesang bis einschl. 60 min",1,{"v":62.93,"d":"62.930 €"},{"v":58.03,"d":"58.030 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"},{"v":46.76,"d":"46.760 €"},{"v":42.5,"d":"42.500 €"},{"v":40.38,"d":"40.380 €"},{"v":39.01,"d":"39.010 €"},{"v":38.36,"d":"38.360 €"},{"v":37.63,"d":"37.630 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Christmette","Orgelspiel",2,{"v":125.87,"d":"125.87 €"},{"v":116.07,"d":"116.07 €"},{"v":106.27,"d":"106.27 €"},{"v":95.64,"d":"95.64 €"},{"v":93.52,"d":"93.52 €"},{"v":85.02,"d":"85.02 €"},{"v":80.77,"d":"80.77 €"},{"v":78.02,"d":"78.02 €"},{"v":76.73,"d":"76.73 €"},{"v":75.27,"d":"75.27 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"},{"$nulls":4},"Prozession mit Chorgesang bis einschl. 90 min",1.5,{"v":94.4,"d":"94.400 €"},{"v":87.05,"d":"87.050 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"},{"v":70.14,"d":"70.140 €"},{"v":63.76,"d":"63.760 €"},{"v":60.58,"d":"60.580 €"},{"v":58.52,"d":"58.520 €"},{"v":57.55,"d":"57.550 €"},{"v":56.45,"d":"56.450 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Christmette","Chorleitung (mit Einsingen)",2.5,{"v":157.33,"d":"157.33 €"},{"v":145.08,"d":"145.08 €"},{"v":132.83,"d":"132.83 €"},{"v":119.55,"d":"119.55 €"},{"v":116.9,"d":"116.90 €"},{"v":106.26,"d":"106.26 €"},{"v":100.96,"d":"100.96 €"},{"v":97.52,"d":"97.52 €"},{"v":95.91,"d":"95.91 €"},{"v":94.08,"d":"94.08 €"},{"v":132.83,"d":"132.830 €"},{"v":119.55,"d":"119.550 €"},{"$nulls":4},"Unterricht bis einschl. 30 min",0.5,{"v":31.47,"d":"31.470 €"},{"v":29.02,"d":"29.020 €"},{"v":26.57,"d":"26.570 €"},{"v":23.91,"d":"23.910 €"},{"v":23.38,"d":"23.380 €"},{"v":21.26,"d":"21.260 €"},{"v":20.19,"d":"20.190 €"},{"v":19.51,"d":"19.510 €"},{"v":19.18,"d":"19.180 €"},{"v":18.82,"d":"18.820 €"},{"v":26.57,"d":"26.570 €"},{"v":23.91,"d":"23.910 €"}]
["Christmette","Orgelspiel und Chorleitung (mit Einsingen)",2.5,{"v":157.33,"d":"157.33 €"},{"v":145.08,"d":"145.08 €"},{"v":132.83,"d":"132.83 €"},{"v":119.55,"d":"119.55 €"},{"v":116.9,"d":"116.90 €"},{"v":106.26,"d":"106.26 €"},{"v":100.96,"d":"100.96 €"},{"v":97.52,"d":"97.52 €"},{"v":95.91,"d":"95.91 €"},{"v":94.08,"d":"94.08 €"},{"v":132.83,"d":"132.830 €"},{"v":119.55,"d":"119.550 €"},{"$nulls":4},"Unterricht bis einschl. 60 min",1,{"v":62.93,"d":"62.930 €"},{"v":58.03,"d":"58.030 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"},{"v":46.76,"d":"46.760 €"},{"v":42.5,"d":"42.500 €"},{"v":40.38,"d":"40.380 €"},{"v":39.01,"d":"39.010 €"},{"v":38.36,"d":"38.360 €"},{"v":37.63,"d":"37.630 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Kinderchristmette","Orgelspiel",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"},{"$nulls":4},"Konzertdauer bis einschl. 60 Minuten + Einsingen/Einspielen",1.5,{"v":94.4,"d":"94.400 €"},{"v":87.05,"d":"87.050 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"},{"v":70.14,"d":"70.140 €"},{"v":63.76,"d":"63.760 €"},{"v":60.58,"d":"60.580 €"},{"v":58.52,"d":"58.520 €"},{"v":57.55,"d":"57.550 €"},{"v":56.45,"d":"56.450 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Kinderchristmette","Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"},{"$nulls":4},"Konzertdauer bis einschl. 90 Minuten + Einsingen/Einspielen",2,{"v":125.87,"d":"125.870 €"},{"v":116.07,"d":"116.070 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"},{"v":93.52,"d":"93.520 €"},{"v":85.02,"d":"85.020 €"},{"v":80.77,"d":"80.770 €"},{"v":78.02,"d":"78.020 €"},{"v":76.73,"d":"76.730 €"},{"v":75.27,"d":"75.270 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"}]
["Kinderchristmette","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"},{"$nulls":4},"Konzertdauer über 90 Minuten + Einsingen/Einspielen",2.5,{"v":157.33,"d":"157.330 €"},{"v":145.08,"d":"145.080 €"},{"v":132.83,"d":"132.830 €"},{"v":119.55,"d":"119.550 €"},{"v":116.9,"d":"116.900 €"},{"v":106.26,"d":"106.260 €"},{"v":100.96,"d":"100.960 €"},{"v":97.52,"d":"97.520 €"},{"v":95.91,"d":"95.910 €"},{"v":94.08,"d":"94.080 €"},{"v":132.83,"d":"132.830 €"},{"v":119.55,"d":"119.550 €"}]
["Gottesdienst in der Osternacht","Orgelspiel",2,{"v":125.87,"d":"125.87 €"},{"v":116.07,"d":"116.07 €"},{"v":106.27,"d":"106.27 €"},{"v":95.64,"d":"95.64 €"},{"v":93.52,"d":"93.52 €"},{"v":85.02,"d":"85.02 €"},{"v":80.77,"d":"80.77 €"},{"v":78.02,"d":"78.02 €"},{"v":76.73,"d":"76.73 €"},{"v":75.27,"d":"75.27 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"},{"$nulls":4},{"$f":"'Drop Down'!E14","v":"Sonstige vereinbarte Tätigkeit gem. § 12 Abs. 3 Anlage 4f zur AVO"},null,{"v":37.76,"d":"37.760 €"},{"v":34.82,"d":"34.820 €"},{"v":31.88,"d":"31.880 €"},{"v":28.69,"d":"28.690 €"},{"v":28.06,"d":"28.060 €"},{"v":25.5,"d":"25.500 €"},{"v":24.23,"d":"24.230 €"},{"v":23.41,"d":"23.410 €"},{"v":23.02,"d":"23.020 €"},{"v":22.58,"d":"22.580 €"},{"v":31.88,"d":"31.880 €"},{"v":28.69,"d":"28.690 €"}]
["Gottesdienst in der Osternacht","Chorleitung (mit Einsingen)",2.5,{"v":157.33,"d":"157.33 €"},{"v":145.08,"d":"145.08 €"},{"v":132.83,"d":"132.83 €"},{"v":119.55,"d":"119.55 €"},{"v":116.9,"d":"116.90 €"},{"v":106.26,"d":"106.26 €"},{"v":100.96,"d":"100.96 €"},{"v":97.52,"d":"97.52 €"},{"v":95.91,"d":"95.91 €"},{"v":94.08,"d":"94.08 €"},{"v":132.83,"d":"132.830 €"},{"v":119.55,"d":"119.550 €"}]
["Gottesdienst in der Osternacht","Orgelspiel und Chorleitung (mit Einsingen)",2.5,{"v":157.33,"d":"157.33 €"},{"v":145.08,"d":"145.08 €"},{"v":132.83,"d":"132.83 €"},{"v":119.55,"d":"119.55 €"},{"v":116.9,"d":"116.90 €"},{"v":106.26,"d":"106.26 €"},{"v":100.96,"d":"100.96 €"},{"v":97.52,"d":"97.52 €"},{"v":95.91,"d":"95.91 €"},{"v":94.08,"d":"94.08 €"},{"v":132.83,"d":"132.830 €"},{"v":119.55,"d":"119.550 €"}]
["Gottesdienst am Gründonnerstag","Orgelspiel",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Gottesdienst am Gründonnerstag","Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Gottesdienst am Gründonnerstag","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Karfreitagsliturgie","Orgelspiel",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Karfreitagsliturgie","Chorleitung (mit Einsingen)",2,{"v":125.87,"d":"125.87 €"},{"v":116.07,"d":"116.07 €"},{"v":106.27,"d":"106.27 €"},{"v":95.64,"d":"95.64 €"},{"v":93.52,"d":"93.52 €"},{"v":85.02,"d":"85.02 €"},{"v":80.77,"d":"80.77 €"},{"v":78.02,"d":"78.02 €"},{"v":76.73,"d":"76.73 €"},{"v":75.27,"d":"75.27 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"}]
["Karfreitagsliturgie","Orgelspiel und Chorleitung (mit Einsingen)",2,{"v":125.87,"d":"125.87 €"},{"v":116.07,"d":"116.07 €"},{"v":106.27,"d":"106.27 €"},{"v":95.64,"d":"95.64 €"},{"v":93.52,"d":"93.52 €"},{"v":85.02,"d":"85.02 €"},{"v":80.77,"d":"80.77 €"},{"v":78.02,"d":"78.02 €"},{"v":76.73,"d":"76.73 €"},{"v":75.27,"d":"75.27 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"}]
["Erstkommunionsfeiern","Orgelspiel",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Erstkommunionsfeiern","Chorleitung (mit Einsingen)",2,{"v":125.87,"d":"125.87 €"},{"v":116.07,"d":"116.07 €"},{"v":106.27,"d":"106.27 €"},{"v":95.64,"d":"95.64 €"},{"v":93.52,"d":"93.52 €"},{"v":85.02,"d":"85.02 €"},{"v":80.77,"d":"80.77 €"},{"v":78.02,"d":"78.02 €"},{"v":76.73,"d":"76.73 €"},{"v":75.27,"d":"75.27 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"}]
["Erstkommunionsfeiern","Orgelspiel und Chorleitung (mit Einsingen)",2,{"v":125.87,"d":"125.87 €"},{"v":116.07,"d":"116.07 €"},{"v":106.27,"d":"106.27 €"},{"v":95.64,"d":"95.64 €"},{"v":93.52,"d":"93.52 €"},{"v":85.02,"d":"85.02 €"},{"v":80.77,"d":"80.77 €"},{"v":78.02,"d":"78.02 €"},{"v":76.73,"d":"76.73 €"},{"v":75.27,"d":"75.27 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"}]
["Firmungen","Orgelspiel",2,{"v":125.87,"d":"125.87 €"},{"v":116.07,"d":"116.07 €"},{"v":106.27,"d":"106.27 €"},{"v":95.64,"d":"95.64 €"},{"v":93.52,"d":"93.52 €"},{"v":85.02,"d":"85.02 €"},{"v":80.77,"d":"80.77 €"},{"v":78.02,"d":"78.02 €"},{"v":76.73,"d":"76.73 €"},{"v":75.27,"d":"75.27 €"},{"v":106.27,"d":"106.270 €"},{"v":95.64,"d":"95.640 €"}]
["Firmungen","Chorleitung (mit Einsingen)",2.5,{"v":157.33,"d":"157.33 €"},{"v":145.08,"d":"145.08 €"},{"v":132.83,"d":"132.83 €"},{"v":119.55,"d":"119.55 €"},{"v":116.9,"d":"116.90 €"},{"v":106.26,"d":"106.26 €"},{"v":100.96,"d":"100.96 €"},{"v":97.52,"d":"97.52 €"},{"v":95.91,"d":"95.91 €"},{"v":94.08,"d":"94.08 €"},{"v":132.83,"d":"132.830 €"},{"v":119.55,"d":"119.550 €"}]
["Firmungen","Orgelspiel und Chorleitung (mit Einsingen)",2.5,{"v":157.33,"d":"157.33 €"},{"v":145.08,"d":"145.08 €"},{"v":132.83,"d":"132.83 €"},{"v":119.55,"d":"119.55 €"},{"v":116.9,"d":"116.90 €"},{"v":106.26,"d":"106.26 €"},{"v":100.96,"d":"100.96 €"},{"v":97.52,"d":"97.52 €"},{"v":95.91,"d":"95.91 €"},{"v":94.08,"d":"94.08 €"},{"v":132.83,"d":"132.830 €"},{"v":119.55,"d":"119.550 €"}]
["Tauffeiern","Orgelspiel",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Tauffeiern","Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Tauffeiern","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Trauungen","Orgelspiel",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Trauungen","Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Trauungen","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Seelenamt + Aussegnung \nbzw. Trauerfeier + Aussegnung","Orgelspiel",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Seelenamt + Aussegnung \nbzw. Trauerfeier + Aussegnung","Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Seelenamt + Aussegnung \nbzw. Trauerfeier + Aussegnung","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Andachten (bis einschl. 30min)","Orgelspiel",0.5,{"v":31.47,"d":"31.47 €"},{"v":29.02,"d":"29.02 €"},{"v":26.57,"d":"26.57 €"},{"v":23.91,"d":"23.91 €"},{"v":23.38,"d":"23.38 €"},{"v":21.26,"d":"21.26 €"},{"v":20.19,"d":"20.19 €"},{"v":19.51,"d":"19.51 €"},{"v":19.18,"d":"19.18 €"},{"v":18.82,"d":"18.82 €"},{"v":26.57,"d":"26.570 €"},{"$f":"ROUND(0.9*N38,2)","v":{"v":23.91,"d":"23.910 €"}}]
["Andachten (bis einschl. 30min)","Chorleitung (mit Einsingen)",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Andachten (bis einschl. 30min)","Orgelspiel und Chorleitung (mit Einsingen)",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Andachten (bis einschl. 60min)","Orgelspiel",1,{"v":62.93,"d":"62.93 €"},{"v":58.03,"d":"58.03 €"},{"v":53.13,"d":"53.13 €"},{"v":47.82,"d":"47.82 €"},{"v":46.76,"d":"46.76 €"},{"v":42.5,"d":"42.50 €"},{"v":40.38,"d":"40.38 €"},{"v":39.01,"d":"39.01 €"},{"v":38.36,"d":"38.36 €"},{"v":37.63,"d":"37.63 €"},{"v":53.13,"d":"53.130 €"},{"v":47.82,"d":"47.820 €"}]
["Andachten (bis einschl. 60min)","Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]
["Andachten (bis einschl. 60min)","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":94.4,"d":"94.40 €"},{"v":87.05,"d":"87.05 €"},{"v":79.7,"d":"79.70 €"},{"v":71.73,"d":"71.73 €"},{"v":70.14,"d":"70.14 €"},{"v":63.76,"d":"63.76 €"},{"v":60.58,"d":"60.58 €"},{"v":58.52,"d":"58.52 €"},{"v":57.55,"d":"57.55 €"},{"v":56.45,"d":"56.45 €"},{"v":79.7,"d":"79.700 €"},{"v":71.73,"d":"71.730 €"}]

{"sheet":"Drop Down","index":2,"n_rows":227,"n_cols":15,"rows_kept":227,"hidden":true}
["Gottesdienst",null,"Tätigkeiten",null,"sonstige Tätigkeiten",null,"Qualifikation",null,"Arbeitgeber",null,"Auftraggeber",null,"GKG",null,"Fonds"]
["Gottesdienste an Sonntagen (einschl. Vorabend) und Feiertagen",null,"Orgelspiel",null,"Chorprobe/Ensembleprobe bis einschl. 60 min",null,"A",null,"Aachtal",null,"Römisch-katholische Kirchengemeinde",null,"Baden-Baden",null,"Lindenberg"]
["Werktagsgottesdienst",null,"Chorleitung (mit Einsingen)",null,"Chorprobe/Ensembleprobe bis einschl. 90 min",null,"B",null,"Achern",null,"Katholische Gesamtkirchengemeinde",null,"Freiburg"]
["Christmette",null,"Orgelspiel und Chorleitung (mit Einsingen)",null,"Chorprobe/Ensembleprobe bis einschl. 120 min",null,"90%B",null,"Achertal St. Nikolaus",null,"Erzdiözese Freiburg",null,"Karlsruhe"]
["Kinderchristmette",{"$nulls":3},"Chorprobe mit Kinder- und Jugendchor bis einschl. 60 min",null,"80%B",null,"Adelsheim-Osterburken-Seckach",null,"Kapellenfond",null,"Konstanz"]
["Gottesdienst in der Osternacht",{"$nulls":3},"Chorprobe mit Kinder- und Jugendchor bis einschl. 90 min",null,"C",null,"Aglasterhausen-Neunkirchen",{"$nulls":3},"Mannheim"]
["Gottesdienst am Gründonnerstag",{"$nulls":3},"Prozession mit Chorgesang bis einschl. 60 min",null,"95%C",null,"Am Litzelberg"]
["Karfreitagsliturgie",{"$nulls":3},"Prozession mit Chorgesang bis einschl. 90 min",null,"D",null,"An der Eschach"]
["Erstkommunionsfeiern",{"$nulls":3},"Unterricht bis einschl. 30 min",null,"B+50% (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)",null,"An der Glotter"]
["Firmungen",{"$nulls":3},"Unterricht bis einschl. 60 min",null,"C+50%  (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)",null,"An der Schutter"]
["Tauffeiern",{"$nulls":3},"Konzertdauer bis einschl. 60 Minuten + Einsingen/Einspielen",null,"D+50% (Besitzstand gem. § 16 Abs. 2 Anlage 4f zur AVO)",null,"An Wolf und Kinzig"]
["Trauungen",{"$nulls":3},"Konzertdauer bis einschl. 90 Minuten + Einsingen/Einspielen",null,"B (Besitzstand gem. § 16 Abs. 1 Anlage 4f zur AVO)",null,"Appenweier-Durbach"]
["Seelenamt + Aussegnung \nbzw. Trauerfeier + Aussegnung",{"$nulls":3},"Konzertdauer über 90 Minuten + Einsingen/Einspielen",null,"90%B (Besitzstand nach § 16 Abs. 2 Anlage 4f zur AVO)",null,"Auf der Baar"]
["Andachten (bis einschl. 30min)",{"$nulls":3},"Sonstige vereinbarte Tätigkeit gem. § 12 Abs. 3 Anlage 4f zur AVO",{"$nulls":3},"Bad Dürrheim"]
["Andachten (bis einschl. 60min)",{"$nulls":7},"Bad Krozingen-Hartheim"]
[{"$nulls":8},"Bad Rappenau/Obergimpern"]
[{"$nulls":8},"Bad Säckingen-Murg"]
[{"$nulls":8},"Bad Schönborn-Kronau"]
[{"$nulls":8},"Baden-Baden"]
[{"$nulls":8},"Baden-Baden-Oos"]
[{"$nulls":8},"Baden-Baden-Rebland"]
[{"$nulls":8},"Batzenberg-Obere Möhlin"]
[{"$nulls":8},"Beim Titisee"]
[{"$nulls":8},"Beuron"]
[{"$nulls":8},"Biet"]
[{"$nulls":8},"Billigheim-Neudenau-Schefflenz"]
[{"$nulls":8},"Birnau Mariä-Himmelfahrt"]
[{"$nulls":8},"Bisingen-Grosselfingen-Rangendingen"]
[{"$nulls":8},"Blumberg"]
[{"$nulls":8},"Bonndorf-Wutach"]
[{"$nulls":8},"Boxberg-Ahorn"]
[{"$nulls":8},"Bregtal"]
[{"$nulls":8},"Breisach-Merdingen"]
[{"$nulls":8},"Bretten-Walzbachtal"]
[{"$nulls":8},"Bruchsal Michaelsberg"]
[{"$nulls":8},"Bruchsal St. Vinzenz"]
[{"$nulls":8},"Brühl-Ketsch"]
[{"$nulls":8},"Buchen"]
[{"$nulls":8},"Bühl/Vimbuch"]
[{"$nulls":8},"Bühlertal"]
[{"$nulls":8},"Burladingen-Jungingen"]
[{"$nulls":8},"Deggenhausertal"]
[{"$nulls":8},"Deubach"]
[{"$nulls":8},"Donaueschingen"]
[{"$nulls":8},"Dreisamtal"]
[{"$nulls":8},"Durmersheim-Au a. Rh."]
[{"$nulls":8},"Egg"]
[{"$nulls":8},"Eggingen-Stühlingen Hl. Kreuz"]
[{"$nulls":8},"Elztal-Limbach-Fahrenbach"]
[{"$nulls":8},"Emmendingen-Teningen"]
[{"$nulls":8},"Empfingen-Dießener Tal"]
[{"$nulls":8},"Eppingen"]
[{"$nulls":8},"Ettenheim"]
[{"$nulls":8},"Ettlingen Land"]
[{"$nulls":8},"Ettlingen Stadt"]
[{"$nulls":8},"Eutingen"]
[{"$nulls":8},"Eyachtal-Haigerloch St. Anna"]
[{"$nulls":8},"Forbach-Weisenbach"]
[{"$nulls":8},"Forst-Ubstadt-Weiher"]
[{"$nulls":8},"Freiburg Mitte"]
[{"$nulls":8},"Freiburg Nord"]
[{"$nulls":8},"Freiburg Nordwest"]
[{"$nulls":8},"Freiburg Ost"]
[{"$nulls":8},"Freiburg Südwest"]
[{"$nulls":8},"Freiburg-Tuniberg"]
[{"$nulls":8},"Freiburg-Wiehre-Günterstal"]
[{"$nulls":8},"Freudenberg"]
[{"$nulls":8},"Friedenweiler"]
[{"$nulls":8},"Friesenheim"]
[{"$nulls":8},"Gaggenau"]
[{"$nulls":8},"Gaggenau-Ottenau"]
[{"$nulls":8},"Gammertingen-Trochtelfingen"]
[{"$nulls":8},"Gernsbach"]
[{"$nulls":8},"Gottmadingen"]
[{"$nulls":8},"Graben-Neudorf-Linkenheim"]
[{"$nulls":8},"Grenzach-Wyhlen"]
[{"$nulls":8},"Großrinderfeld-Werbach"]
[{"$nulls":8},"Grünsfeld-Wittighausen"]
[{"$nulls":8},"Hanauerland"]
[{"$nulls":8},"Hardheim-Höpfingen Im Madonnenland"]
[{"$nulls":8},"Haslach"]
[{"$nulls":8},"Hausach-Hornberg"]
[{"$nulls":8},"Hechingen St. Luzius"]
[{"$nulls":8},"Heidelberg"]
[{"$nulls":8},"Heitersheim"]
[{"$nulls":8},"Hemsbach"]
[{"$nulls":8},"Herbolzheim-Rheinhausen"]
[{"$nulls":8},"Heuberg St. Barbara"]
[{"$nulls":8},"Hockenheim"]
[{"$nulls":8},"Hohenfels"]
[{"$nulls":8},"Hohenstoffeln-Hilzingen"]
[{"$nulls":8},"Höri"]
[{"$nulls":8},"Hotzenwald St. Wendelinus"]
[{"$nulls":8},"Iffezheim-Ried"]
[{"$nulls":8},"Immendingen-Möhringen St. Sebastian"]
[{"$nulls":8},"Jestetten"]
[{"$nulls":8},"Kämpfelbachtal"]
[{"$nulls":8},"Kandern-Istein"]
[{"$nulls":8},"Karlsdorf-Neuthard-Büchenau"]
[{"$nulls":8},"Karlsruhe Alb-Südwest St. Nikolaus"]
[{"$nulls":8},"Karlsruhe Allerheiligen"]
[{"$nulls":8},"Karlsruhe Nord-Ost St. Raphael"]
[{"$nulls":8},"Karlsruhe Südwest"]
[{"$nulls":8},"Karlsruhe-Durlach-Bergdörfer"]
[{"$nulls":8},"Karlsruhe-Hardt"]
[{"$nulls":8},"Kehl"]
[{"$nulls":8},"Kenzingen"]
[{"$nulls":8},"Kippenheim Maria Frieden"]
[{"$nulls":8},"Kirchtal-Donau"]
[{"$nulls":8},"Klettgau-Wutöschingen"]
[{"$nulls":8},"Kloster Wittichen"]
[{"$nulls":8},"Königheim"]
[{"$nulls":8},"Konstanz Altstadt"]
[{"$nulls":8},"Konstanz St. Georg-Maria Hilf"]
[{"$nulls":8},"Konstanzer Bodanrückgemeinden"]
[{"$nulls":8},"Konstanz-Petershausen"]
[{"$nulls":8},"Kraichtal-Elsenz Hl. Geist"]
[{"$nulls":8},"Krauchenwies-Rulfingen"]
[{"$nulls":8},"Krautheim-Ravenstein-Assamstadt"]
[{"$nulls":8},"Krebsbachtal/Hegau"]
[{"$nulls":8},"Külsheim-Bronnbach"]
[{"$nulls":8},"Küssaberg-Hohentengen St. Christophorus"]
[{"$nulls":8},"Ladenburg-Heddesheim"]
[{"$nulls":8},"Laiz-Leibertingen"]
[{"$nulls":8},"Lauda-Königshofen"]
[{"$nulls":8},"Laufenburg-Albbruck"]
[{"$nulls":8},"Lauf-Sasbachtal"]
[{"$nulls":8},"Leimen-Nußloch-Sandhausen"]
[{"$nulls":8},"Letzenberg"]
[{"$nulls":8},"Löffingen"]
[{"$nulls":8},"Lörrach-Inzlingen"]
[{"$nulls":8},"Malsch b. E."]
[{"$nulls":8},"Mannheim Maria Magdalena"]
[{"$nulls":8},"Mannheim Nord"]
[{"$nulls":8},"Mannheim St. Johannes XXII"]
[{"$nulls":8},"Mannheim St. Martin"]
[{"$nulls":8},"Mannheim Süd"]
[{"$nulls":8},"Mannheim Südwest"]
[{"$nulls":8},"Mannheim-Neckarstadt"]
[{"$nulls":8},"March-Gottenheim"]
[{"$nulls":8},"Maria Bronnen"]
[{"$nulls":8},"Markdorf"]
[{"$nulls":8},"Markgräflerland"]
[{"$nulls":8},"Marxzell St. Markus"]
[{"$nulls":8},"Meersburg"]
[{"$nulls":8},"Meßkirch-Sauldorf"]
[{"$nulls":8},"Mittlerer Hegau"]
[{"$nulls":8},"Mittlerer Hochrhein St. Verena"]
[{"$nulls":8},"Mittleres Elz- und Simonswäldertal"]
[{"$nulls":8},"Mittleres Wiesental"]
[{"$nulls":8},"Mosbach-Elz-Neckar Mose"]
[{"$nulls":8},"Mudau"]
[{"$nulls":8},"Neckar-Elsenz"]
[{"$nulls":8},"Neckartal-Hoher Odenwald Edith Stein"]
[{"$nulls":8},"Nördlicher Kaiserstuhl"]
[{"$nulls":8},"Oberer Hegau"]
[{"$nulls":8},"Oberer Linzgau"]
[{"$nulls":8},"Oberes Elztal"]
[{"$nulls":8},"Oberes Renchtal"]
[{"$nulls":8},"Oberes Schlüchttal"]
[{"$nulls":8},"Oberes Wiesental"]
[{"$nulls":8},"Oberes Wolftal"]
[{"$nulls":8},"Oberhausen-Philippsburg"]
[{"$nulls":8},"Oberkirch"]
[{"$nulls":8},"Offenburg St. Ursula"]
[{"$nulls":8},"Östlicher Hochschwarzwald"]
[{"$nulls":8},"Ostrachtal"]
[{"$nulls":8},"Östringen"]
[{"$nulls":8},"Ottersweier Maria Linden"]
[{"$nulls":8},"Pfinztal"]
[{"$nulls":8},"Pforzheim"]
[{"$nulls":8},"Radolfzell St. Radolt"]
[{"$nulls":8},"Rastatt"]
[{"$nulls":8},"Reichenau"]
[{"$nulls":8},"Renchen"]
[{"$nulls":8},"Rheinfelden"]
[{"$nulls":8},"Rheinmünster-Lichtenau"]
[{"$nulls":8},"Rheinstetten"]
[{"$nulls":8},"Rust"]
[{"$nulls":8},"Salem-Heiligenberg"]
[{"$nulls":8},"Schliengen"]
[{"$nulls":8},"Schriesheim-Dossenheim"]
[{"$nulls":8},"Schutterwald-Hohberg-Neuried"]
[{"$nulls":8},"Schwetzingen"]
[{"$nulls":8},"See-End"]
[{"$nulls":8},"Sickingen"]
[{"$nulls":8},"Sigmaringen"]
[{"$nulls":8},"Singen"]
[{"$nulls":8},"Sinsheim-Angelbachtal"]
[{"$nulls":8},"Sinzheim-Hügelsheim"]
[{"$nulls":8},"Sipplingen"]
[{"$nulls":8},"St. Blasien"]
[{"$nulls":8},"St. Georgen-Hexental"]
[{"$nulls":8},"St. Georgen-Tennenbronn"]
[{"$nulls":8},"St. Märgen-St. Peter"]
[{"$nulls":8},"Staufen-St. Trudpert"]
[{"$nulls":8},"Steinachtal St. Hildegund"]
[{"$nulls":8},"Stockach"]
[{"$nulls":8},"Straßberg-Veringen"]
[{"$nulls":8},"Stutensee-Weingarten"]
[{"$nulls":8},"Südhardt-Rhein"]
[{"$nulls":8},"Tauberbischofsheim"]
[{"$nulls":8},"Tengen Bernhard von Baden"]
[{"$nulls":8},"Todtmoos-Bernau"]
[{"$nulls":8},"Triberg Maria in der Tanne"]
[{"$nulls":8},"Überlingen"]
[{"$nulls":8},"Villingen"]
[{"$nulls":8},"Vogtsburg"]
[{"$nulls":8},"Vorderes Kinzigtal St. Pirmin"]
[{"$nulls":8},"Vorderes Murgtal"]
[{"$nulls":8},"Waghäusel-Hambrücken"]
[{"$nulls":8},"Waibstadt"]
[{"$nulls":8},"Wald"]
[{"$nulls":8},"Waldbronn-Karlsbad"]
[{"$nulls":8},"Waldkirch"]
[{"$nulls":8},"Walldorf-St. Leon-Rot"]
[{"$nulls":8},"Walldürn"]
[{"$nulls":8},"Wehr"]
[{"$nulls":8},"Weil a. Rh."]
[{"$nulls":8},"Weinheim-Hirschberg"]
[{"$nulls":8},"Wertheim"]
[{"$nulls":8},"Wiesloch-Dielheim"]
[{"$nulls":8},"Winterlingen St. Gertrud"]
[{"$nulls":8},"Wollmatingen-Allensbach"]
[{"$nulls":8},"Zell a. H."]
[{"$nulls":8},"Zell i. W."]
[{"$nulls":8},"Zwischen Brigach und Kirnach"]