{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Stundennachweis_Abrechnung","Datentabelle","Drop Down"],"not_rendered":{"images":1,"defined_names":5,"comments":1},"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 4.0 / ab Juni 2023"]
[]
["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":60.65,"d":"60.65 €"},{"$f":"ROUND(F2+(D2-F2)*0.5,2)","v":{"v":55.74,"d":"55.74 €"}},{"v":50.83,"d":"50.83 €"},{"$f":"ROUND(0.9*F2,2)","v":{"v":45.75,"d":"45.75 €"}},{"$f":"ROUND(J2+(F2-J2)*0.5,2)","v":{"v":44.44,"d":"44.44 €"}},{"$f":"ROUND(0.8*F2,2)","v":{"v":40.66,"d":"40.66 €"}},{"v":38.05,"d":"38.05 €"},{"$f":"ROUND(M2+(J2-M2)*0.5,2)","v":{"v":36.67,"d":"36.67 €"}},{"$f":"ROUND(0.95*J2,2)","v":{"v":36.15,"d":"36.15 €"}},{"v":35.28,"d":"35.28 €"},{"v":50.83,"d":"50.830 €"},{"$f":"ROUND(0.9*N2,2)","v":{"v":45.75,"d":"45.750 €"}},{"$nulls":4},"Chorprobe/Ensembleprobe bis einschl. 60 min",1,{"v":60.65,"d":"60.650 €"},{"$f":"ROUND(X2+(V2-X2)*0.5,2)","v":{"v":55.74,"d":"55.740 €"}},{"v":50.83,"d":"50.830 €"},{"$f":"ROUND(0.9*X2,2)","v":{"v":45.75,"d":"45.750 €"}},{"$f":"ROUND(AB2+(X2-AB2)*0.5,2)","v":{"v":44.44,"d":"44.440 €"}},{"$f":"ROUND(0.8*X2,2)","v":{"v":40.66,"d":"40.660 €"}},{"v":38.05,"d":"38.050 €"},{"$f":"ROUND(AE2+(AB2-AE2)*0.5,2)","v":{"v":36.67,"d":"36.670 €"}},{"$f":"ROUND(0.95*AB2,2)","v":{"v":36.15,"d":"36.150 €"}},{"v":35.28,"d":"35.280 €"},{"v":50.83,"d":"50.830 €"},{"$f":"ROUND(0.9*AF2,2)","v":{"v":45.75,"d":"45.750 €"}}]
["Gottesdienste an Sonntagen (einschl. Vorabend) und Feiertagen","Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"$f":"ROUND(F3+(D3-F3)*0.5,2)","v":{"v":83.62,"d":"83.62 €"}},{"v":76.25,"d":"76.25 €"},{"$f":"ROUND(0.9*F3,2)","v":{"v":68.63,"d":"68.63 €"}},{"$f":"ROUND(J3+(F3-J3)*0.5,2)","v":{"v":66.67,"d":"66.67 €"}},{"$f":"ROUND(0.8*F3,2)","v":{"v":61,"d":"61.00 €"}},{"v":57.08,"d":"57.08 €"},{"$f":"ROUND(M3+(J3-M3)*0.5,2)","v":{"v":55.01,"d":"55.01 €"}},{"$f":"ROUND(0.95*J3,2)","v":{"v":54.23,"d":"54.23 €"}},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"$f":"ROUND(0.9*N3,2)","v":{"v":68.63,"d":"68.630 €"}},{"$nulls":4},"Chorprobe/Ensembleprobe bis einschl. 90 min",1.5,{"v":90.98,"d":"90.980 €"},{"v":83.62,"d":"83.620 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"},{"v":66.67,"d":"66.670 €"},{"v":61,"d":"61.000 €"},{"v":57.08,"d":"57.080 €"},{"v":55.01,"d":"55.010 €"},{"$f":"ROUND(0.95*AB3,2)","v":{"v":54.23,"d":"54.230 €"}},{"v":52.93,"d":"52.930 €"},{"v":76.25,"d":"76.250 €"},{"$f":"ROUND(0.9*AF3,2)","v":{"v":68.63,"d":"68.630 €"}}]
["Gottesdienste an Sonntagen (einschl. Vorabend) und Feiertagen","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"$f":"ROUND(0.9*N4,2)","v":{"v":68.63,"d":"68.630 €"}},{"$nulls":4},"Chorprobe/Ensembleprobe bis einschl. 120 min",2,{"v":121.3,"d":"121.300 €"},{"v":111.49,"d":"111.490 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"},{"v":88.89,"d":"88.890 €"},{"v":81.34,"d":"81.340 €"},{"v":76.1,"d":"76.100 €"},{"v":73.34,"d":"73.340 €"},{"v":72.3,"d":"72.300 €"},{"v":70.57,"d":"70.570 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"}]
["Werktagsgottesdienst","Orgelspiel",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"},{"$nulls":4},"Chorprobe mit Kinder- und Jugendchor bis einschl. 60 min",1,{"v":60.65,"d":"60.650 €"},{"v":55.74,"d":"55.740 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"},{"v":44.44,"d":"44.440 €"},{"v":40.66,"d":"40.660 €"},{"v":38.05,"d":"38.050 €"},{"v":36.67,"d":"36.670 €"},{"v":36.15,"d":"36.150 €"},{"v":35.28,"d":"35.280 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"}]
["Werktagsgottesdienst","Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"$f":"ROUND(F6+(D6-F6)*0.5,2)","v":{"v":83.62,"d":"83.62 €"}},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"},{"$nulls":4},"Chorprobe mit Kinder- und Jugendchor bis einschl. 90 min",1.5,{"v":90.98,"d":"90.980 €"},{"v":83.62,"d":"83.620 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"},{"v":66.67,"d":"66.670 €"},{"v":61,"d":"61.000 €"},{"v":57.08,"d":"57.080 €"},{"v":55.01,"d":"55.010 €"},{"v":54.23,"d":"54.230 €"},{"v":52.93,"d":"52.930 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Werktagsgottesdienst","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"$f":"ROUND(F7+(D7-F7)*0.5,2)","v":{"v":83.62,"d":"83.62 €"}},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"},{"$nulls":4},"Prozession mit Chorgesang bis einschl. 60 min",1,{"v":60.65,"d":"60.650 €"},{"v":55.74,"d":"55.740 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"},{"v":44.44,"d":"44.440 €"},{"v":40.66,"d":"40.660 €"},{"v":38.05,"d":"38.050 €"},{"v":36.67,"d":"36.670 €"},{"v":36.15,"d":"36.150 €"},{"v":35.28,"d":"35.280 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"}]
["Christmette","Orgelspiel",2,{"v":121.3,"d":"121.30 €"},{"v":111.49,"d":"111.49 €"},{"v":101.67,"d":"101.67 €"},{"v":91.5,"d":"91.50 €"},{"v":88.89,"d":"88.89 €"},{"v":81.34,"d":"81.34 €"},{"v":76.1,"d":"76.10 €"},{"v":73.34,"d":"73.34 €"},{"v":72.3,"d":"72.30 €"},{"v":70.57,"d":"70.57 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"},{"$nulls":4},"Prozession mit Chorgesang bis einschl. 90 min",1.5,{"v":90.98,"d":"90.980 €"},{"v":83.62,"d":"83.620 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"},{"v":66.67,"d":"66.670 €"},{"v":61,"d":"61.000 €"},{"v":57.08,"d":"57.080 €"},{"v":55.01,"d":"55.010 €"},{"v":54.23,"d":"54.230 €"},{"v":52.93,"d":"52.930 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Christmette","Chorleitung (mit Einsingen)",2.5,{"v":151.63,"d":"151.63 €"},{"v":139.36,"d":"139.36 €"},{"v":127.08,"d":"127.08 €"},{"v":114.37,"d":"114.37 €"},{"v":111.11,"d":"111.11 €"},{"v":101.66,"d":"101.66 €"},{"v":95.13,"d":"95.13 €"},{"v":91.67,"d":"91.67 €"},{"v":90.37,"d":"90.37 €"},{"v":88.21,"d":"88.21 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"},{"$nulls":4},"Unterricht bis einschl. 30 min",0.5,{"v":30.33,"d":"30.330 €"},{"v":27.88,"d":"27.880 €"},{"v":25.42,"d":"25.420 €"},{"v":22.88,"d":"22.880 €"},{"v":22.23,"d":"22.230 €"},{"v":20.34,"d":"20.340 €"},{"v":19.03,"d":"19.030 €"},{"v":18.34,"d":"18.340 €"},{"v":18.08,"d":"18.080 €"},{"v":17.64,"d":"17.640 €"},{"v":25.42,"d":"25.420 €"},{"v":22.88,"d":"22.880 €"}]
["Christmette","Orgelspiel und Chorleitung (mit Einsingen)",2.5,{"v":151.63,"d":"151.63 €"},{"v":139.36,"d":"139.36 €"},{"v":127.08,"d":"127.08 €"},{"v":114.37,"d":"114.37 €"},{"v":111.11,"d":"111.11 €"},{"v":101.66,"d":"101.66 €"},{"v":95.13,"d":"95.13 €"},{"v":91.67,"d":"91.67 €"},{"v":90.37,"d":"90.37 €"},{"v":88.21,"d":"88.21 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"},{"$nulls":4},"Unterricht bis einschl. 60 min",1,{"v":60.65,"d":"60.650 €"},{"v":55.74,"d":"55.740 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"},{"v":44.44,"d":"44.440 €"},{"v":40.66,"d":"40.660 €"},{"v":38.05,"d":"38.050 €"},{"v":36.67,"d":"36.670 €"},{"v":36.15,"d":"36.150 €"},{"v":35.28,"d":"35.280 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"}]
["Kinderchristmette","Orgelspiel",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"},{"$nulls":4},"Konzertdauer bis einschl. 60 Minuten + Einsingen/Einspielen",1.5,{"v":90.98,"d":"90.980 €"},{"v":83.62,"d":"83.620 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"},{"v":66.67,"d":"66.670 €"},{"v":61,"d":"61.000 €"},{"v":57.08,"d":"57.080 €"},{"v":55.01,"d":"55.010 €"},{"v":54.23,"d":"54.230 €"},{"v":52.93,"d":"52.930 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Kinderchristmette","Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"},{"$nulls":4},"Konzertdauer bis einschl. 90 Minuten + Einsingen/Einspielen",2,{"v":121.3,"d":"121.300 €"},{"v":111.49,"d":"111.490 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"},{"v":88.89,"d":"88.890 €"},{"v":81.34,"d":"81.340 €"},{"v":76.1,"d":"76.100 €"},{"v":73.34,"d":"73.340 €"},{"v":72.3,"d":"72.300 €"},{"v":70.57,"d":"70.570 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"}]
["Kinderchristmette","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"},{"$nulls":4},"Konzertdauer über 90 Minuten + Einsingen/Einspielen",2.5,{"v":151.63,"d":"151.630 €"},{"v":139.36,"d":"139.360 €"},{"v":127.08,"d":"127.080 €"},{"v":114.37,"d":"114.370 €"},{"v":111.11,"d":"111.110 €"},{"v":101.66,"d":"101.660 €"},{"v":95.13,"d":"95.130 €"},{"v":91.67,"d":"91.670 €"},{"v":90.37,"d":"90.370 €"},{"v":88.21,"d":"88.210 €"},{"v":127.08,"d":"127.080 €"},{"v":114.37,"d":"114.370 €"}]
["Gottesdienst in der Osternacht","Orgelspiel",2,{"v":121.3,"d":"121.30 €"},{"v":111.49,"d":"111.49 €"},{"v":101.67,"d":"101.67 €"},{"v":91.5,"d":"91.50 €"},{"v":88.89,"d":"88.89 €"},{"v":81.34,"d":"81.34 €"},{"v":76.1,"d":"76.10 €"},{"v":73.34,"d":"73.34 €"},{"v":72.3,"d":"72.30 €"},{"v":70.57,"d":"70.57 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"},{"$nulls":4},{"$f":"'Drop Down'!E14","v":"Sonstige vereinbarte Tätigkeit gem. § 12 Abs. 3 Anlage 4f zur AVO"},null,{"v":36.39,"d":"36.390 €"},{"v":33.45,"d":"33.450 €"},{"v":30.5,"d":"30.500 €"},{"v":27.45,"d":"27.450 €"},{"v":26.67,"d":"26.670 €"},{"v":24.4,"d":"24.400 €"},{"v":22.83,"d":"22.830 €"},{"v":22,"d":"22.000 €"},{"v":21.69,"d":"21.690 €"},{"v":21.17,"d":"21.170 €"},{"v":30.5,"d":"30.500 €"},{"v":27.45,"d":"27.450 €"}]
["Gottesdienst in der Osternacht","Chorleitung (mit Einsingen)",2.5,{"v":151.63,"d":"151.63 €"},{"v":139.36,"d":"139.36 €"},{"v":127.08,"d":"127.08 €"},{"v":114.37,"d":"114.37 €"},{"v":111.11,"d":"111.11 €"},{"v":101.66,"d":"101.66 €"},{"v":95.13,"d":"95.13 €"},{"v":91.67,"d":"91.67 €"},{"v":90.37,"d":"90.37 €"},{"v":88.21,"d":"88.21 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"}]
["Gottesdienst in der Osternacht","Orgelspiel und Chorleitung (mit Einsingen)",2.5,{"v":151.63,"d":"151.63 €"},{"v":139.36,"d":"139.36 €"},{"v":127.08,"d":"127.08 €"},{"v":114.37,"d":"114.37 €"},{"v":111.11,"d":"111.11 €"},{"v":101.66,"d":"101.66 €"},{"v":95.13,"d":"95.13 €"},{"v":91.67,"d":"91.67 €"},{"v":90.37,"d":"90.37 €"},{"v":88.21,"d":"88.21 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"}]
["Gottesdienst am Gründonnerstag","Orgelspiel",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"}]
["Gottesdienst am Gründonnerstag","Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Gottesdienst am Gründonnerstag","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Karfreitagsliturgie","Orgelspiel",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Karfreitagsliturgie","Chorleitung (mit Einsingen)",2,{"v":121.3,"d":"121.30 €"},{"v":111.49,"d":"111.49 €"},{"v":101.67,"d":"101.67 €"},{"v":91.5,"d":"91.50 €"},{"v":88.89,"d":"88.89 €"},{"v":81.34,"d":"81.34 €"},{"v":76.1,"d":"76.10 €"},{"v":73.34,"d":"73.34 €"},{"v":72.3,"d":"72.30 €"},{"v":70.57,"d":"70.57 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Karfreitagsliturgie","Orgelspiel und Chorleitung (mit Einsingen)",2,{"v":121.3,"d":"121.30 €"},{"v":111.49,"d":"111.49 €"},{"v":101.67,"d":"101.67 €"},{"v":91.5,"d":"91.50 €"},{"v":88.89,"d":"88.89 €"},{"v":81.34,"d":"81.34 €"},{"v":76.1,"d":"76.10 €"},{"v":73.34,"d":"73.34 €"},{"v":72.3,"d":"72.30 €"},{"v":70.57,"d":"70.57 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Erstkommunionsfeiern","Orgelspiel",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Erstkommunionsfeiern","Chorleitung (mit Einsingen)",2,{"v":121.3,"d":"121.30 €"},{"v":111.49,"d":"111.49 €"},{"v":101.67,"d":"101.67 €"},{"v":91.5,"d":"91.50 €"},{"v":88.89,"d":"88.89 €"},{"v":81.34,"d":"81.34 €"},{"v":76.1,"d":"76.10 €"},{"v":73.34,"d":"73.34 €"},{"v":72.3,"d":"72.30 €"},{"v":70.57,"d":"70.57 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Erstkommunionsfeiern","Orgelspiel und Chorleitung (mit Einsingen)",2,{"v":121.3,"d":"121.30 €"},{"v":111.49,"d":"111.49 €"},{"v":101.67,"d":"101.67 €"},{"v":91.5,"d":"91.50 €"},{"v":88.89,"d":"88.89 €"},{"v":81.34,"d":"81.34 €"},{"v":76.1,"d":"76.10 €"},{"v":73.34,"d":"73.34 €"},{"v":72.3,"d":"72.30 €"},{"v":70.57,"d":"70.57 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"}]
["Firmungen","Orgelspiel",2,{"v":121.3,"d":"121.30 €"},{"v":111.49,"d":"111.49 €"},{"v":101.67,"d":"101.67 €"},{"v":91.5,"d":"91.50 €"},{"v":88.89,"d":"88.89 €"},{"v":81.34,"d":"81.34 €"},{"v":76.1,"d":"76.10 €"},{"v":73.34,"d":"73.34 €"},{"v":72.3,"d":"72.30 €"},{"v":70.57,"d":"70.57 €"},{"v":101.67,"d":"101.670 €"},{"v":91.5,"d":"91.500 €"}]
["Firmungen","Chorleitung (mit Einsingen)",2.5,{"v":151.63,"d":"151.63 €"},{"v":139.36,"d":"139.36 €"},{"v":127.08,"d":"127.08 €"},{"v":114.37,"d":"114.37 €"},{"v":111.11,"d":"111.11 €"},{"v":101.66,"d":"101.66 €"},{"v":95.13,"d":"95.13 €"},{"v":91.67,"d":"91.67 €"},{"v":90.37,"d":"90.37 €"},{"v":88.21,"d":"88.21 €"},{"v":127.08,"d":"127.080 €"},{"v":114.37,"d":"114.370 €"}]
["Firmungen","Orgelspiel und Chorleitung (mit Einsingen)",2.5,{"v":151.63,"d":"151.63 €"},{"v":139.36,"d":"139.36 €"},{"v":127.08,"d":"127.08 €"},{"v":114.37,"d":"114.37 €"},{"v":111.11,"d":"111.11 €"},{"v":101.66,"d":"101.66 €"},{"v":95.13,"d":"95.13 €"},{"v":91.67,"d":"91.67 €"},{"v":90.37,"d":"90.37 €"},{"v":88.21,"d":"88.21 €"},{"v":127.08,"d":"127.080 €"},{"v":114.37,"d":"114.370 €"}]
["Tauffeiern","Orgelspiel",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":127.08,"d":"127.080 €"},{"v":114.37,"d":"114.370 €"}]
["Tauffeiern","Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Tauffeiern","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Trauungen","Orgelspiel",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"}]
["Trauungen","Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Trauungen","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Seelenamt + Aussegnung \nbzw. Trauerfeier + Aussegnung","Orgelspiel",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"}]
["Seelenamt + Aussegnung \nbzw. Trauerfeier + Aussegnung","Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Seelenamt + Aussegnung \nbzw. Trauerfeier + Aussegnung","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Andachten (bis einschl. 30min)","Orgelspiel",0.5,{"v":30.33,"d":"30.33 €"},{"v":27.88,"d":"27.88 €"},{"v":25.42,"d":"25.42 €"},{"v":22.88,"d":"22.88 €"},{"v":22.23,"d":"22.23 €"},{"v":20.34,"d":"20.34 €"},{"v":19.03,"d":"19.03 €"},{"v":18.34,"d":"18.34 €"},{"v":18.08,"d":"18.08 €"},{"v":17.64,"d":"17.64 €"},{"v":25.42,"d":"25.420 €"},{"$f":"ROUND(0.9*N38,2)","v":{"v":22.88,"d":"22.880 €"}}]
["Andachten (bis einschl. 30min)","Chorleitung (mit Einsingen)",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"}]
["Andachten (bis einschl. 30min)","Orgelspiel und Chorleitung (mit Einsingen)",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"}]
["Andachten (bis einschl. 60min)","Orgelspiel",1,{"v":60.65,"d":"60.65 €"},{"v":55.74,"d":"55.74 €"},{"v":50.83,"d":"50.83 €"},{"v":45.75,"d":"45.75 €"},{"v":44.44,"d":"44.44 €"},{"v":40.66,"d":"40.66 €"},{"v":38.05,"d":"38.05 €"},{"v":36.67,"d":"36.67 €"},{"v":36.15,"d":"36.15 €"},{"v":35.28,"d":"35.28 €"},{"v":50.83,"d":"50.830 €"},{"v":45.75,"d":"45.750 €"}]
["Andachten (bis einschl. 60min)","Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]
["Andachten (bis einschl. 60min)","Orgelspiel und Chorleitung (mit Einsingen)",1.5,{"v":90.98,"d":"90.98 €"},{"v":83.62,"d":"83.62 €"},{"v":76.25,"d":"76.25 €"},{"v":68.63,"d":"68.63 €"},{"v":66.67,"d":"66.67 €"},{"v":61,"d":"61.00 €"},{"v":57.08,"d":"57.08 €"},{"v":55.01,"d":"55.01 €"},{"v":54.23,"d":"54.23 €"},{"v":52.93,"d":"52.93 €"},{"v":76.25,"d":"76.250 €"},{"v":68.63,"d":"68.630 €"}]

{"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"]