{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["2016","2017","2018","2019","2020","Infofelder"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"2016","index":0,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,11,56,18],[41,16,41,17],[42,11,42,17],[44,10,49,10],[45,11,45,12],[46,11,46,12],[47,12,47,17],[48,12,48,17],[49,11,49,15],[32,10,42,10],[32,11,32,17],[33,11,33,15],[33,17,33,18],[34,11,34,17],[39,14,39,16],[40,12,40,17],[41,11,41,15],[50,10,50,18],[52,10,52,18],[22,0,22,4],[22,15,22,16],[27,4,28,4],[29,10,29,18],[36,11,36,14],[36,15,36,16],[30,10,30,18],[3,9,3,11],[3,12,4,12],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[0,2,0,14],[0,15,0,18],[2,1,2,4],[2,7,2,12],[2,14,2,18],[2,20,4,20],[3,4,4,4],[3,5,4,5],[3,7,4,7],[3,8,4,8]]}
[{"$f":"(MID(CELL(\"dateiname\",A1),FIND(\"]\",CELL(\"dateiname\",A1))+1,30))+1-1","v":2016},"PB",{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16)&IF(ISBLANK(Infofelder!A19),\"\",\", geb. \"&Infofelder!A19)","v":"Lara Mustermann, geb. 01.10.2005"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A11),\"\",Infofelder!A11)&\":   \"&IF(ISBLANK(Infofelder!A12),\"\",Infofelder!A12)","v":"Zuständig:   Marie Louise Krankenstand-Müller"},null,null,null,null,"Bemerkungen"]
[{"$f":"IFERROR(INDIRECT(A1-1&\"!A5\"),0)","v":"00:00:00"},{"$f":"IFERROR(INDIRECT(A1-1&\"!B5\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!C5\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(A1-1&\"!D5\"),0)","v":0},true,false,null,30.3333333333333,null,null,null,false,null,null,{"$f":"ROUND((C5*D5+B5)*P25,0)","v":0},false,true,false]
[null," Persönliches Budget",null,null,null,null,null,"Leistungsnachweise",null,null,null,null,null,null,"Zahlungen",null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A5),\"\",Infofelder!A5)","v":"Blattschutz aufheben und/oder Änderungen machen, NUR nach Einweisung in die Funktion des Formulars!"}]
["Gültig ab:","Auslagen/M.","Stunden./M.","€ /Std.","Budget\npro Monat","kumuliert",null,"Âuslagen\n€ /Monat","Stunden h /Monat","Nachweis",null,null,"kumuliert",null,"Über-\nzahlung\n(Rot)","Vorschlag","Überweisung","kumuliert","Budget\nüberschritten\n(Rot)"]
[null,null,null,null,null,null,null,null,null,"Eingereicht","Kürzung","Akzeptiert"]
[]
["Saldovorträge aus",{"$f":"A1-1&\":\"","v":"2015:"},null,null,"     Tag-genau",{"$f":"IFERROR(INDIRECT(A1-1&\"!F23\"),0)","v":0},null,null,null,null,null,"     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!M23\"),0)","v":0},null,{"$f":"-R7+M7","v":0},"    Vorauszahlg.","     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!r23\"),0)","v":0},null,null,"Bemerkungen zum Monat:"]
["November",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o20\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q20\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U20\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(A1-1&\"!V20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W20\"),0)","v":0}]
["Dezember",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o21\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q21\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U21\"),\"\")","v":""},{"$f":"IFERROR(INDIRECT(A1-1&\"!V21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W21\"),0)","v":0}]
["Januar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"E10+F7","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D10),D5,D10)*I10,2)+H10","v":0},{"$f":"L10-J10","v":0},{"$f":"IF( AND(J10>E10,L2=TRUE),E10,J10)","v":0},{"$f":"L10+M7","v":0},31,{"$f":"M10-R10","v":0},{"$f":"IF( AND(L9=0,E9>0,Q2=TRUE),0,IF(Q2=FALSE,O10,IF(P2=TRUE,IF(T10>E10,E10,T10),T10))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+R7","v":0},{"$f":"F10-M10","v":0},{"$f":"E10+O7","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Februar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F10+E11","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D11),D5,D11)*I11,2)+H11","v":0},0,{"$f":"IF( AND(J11>E11,L2=TRUE),E11,J11)","v":0},{"$f":"L10+L11+M7","v":0},{"$f":"IF(   ((A1-2000)/4)=ROUND( ((A1-2000)/4),0),29,28)","v":29},0,{"$f":"IF(AND(L10=0,E10>0,Q2=TRUE),0,IF(Q2=FALSE,O11,IF(P2=TRUE,IF(T11>E11,E11,T11),T11))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+R7","v":0},0,{"$f":"E11+O10","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["März",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F11+E12","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D12),D5,D12)*I12,2)+H12","v":0},0,{"$f":"IF( AND(J12>E12,L2=TRUE),E12,J12)","v":0},{"$f":"L10+L11+L12+M7","v":0},31,0,{"$f":"IF(AND(L11=0,E11>0,Q2=TRUE),0,IF(Q2=FALSE,O12,IF(P2=TRUE,IF(T12>E12,E12,T12),T12))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["April",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D13),D5,D13)*I13,2)+H13","v":0},0,{"$f":"IF( AND(J13>E13,L2=TRUE),E13,J13)","v":0},{"$f":"L10+L11+L12+L13+M7","v":0},30,0,{"$f":"IF(AND(L12=0,E12>0,Q2=TRUE),0,IF(Q2=FALSE,O13,IF(P2=TRUE,IF(T13>E13,E13,T13),T13))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Mai",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D14),D5,D14)*I14,2)+H14","v":0},0,{"$f":"IF( AND(J14>E14,L2=TRUE),E14,J14)","v":0},{"$f":"L10+L11+L12+L13+L14+M7","v":0},31,0,{"$f":"IF(AND(L13=0,E13>0,Q2=TRUE),0,IF(Q2=FALSE,O14,IF(P2=TRUE,IF(T14>E14,E14,T14),T14))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juni",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D15),D5,D15)*I15,2)+H15","v":0},0,{"$f":"IF( AND(J15>E15,L2=TRUE),E15,J15)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+M7","v":0},30,0,{"$f":"IF(AND(L14=0,E14>0,Q2=TRUE),0,IF(Q2=FALSE,O15,IF(P2=TRUE,IF(T15>E15,E15,T15),T15))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juli",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D16),D5,D16)*I16,2)+H16","v":0},0,{"$f":"IF( AND(J16>E16,L2=TRUE),E16,J16)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+M7","v":0},31,0,{"$f":"IF(AND(L15=0,E15>0,Q2=TRUE),0,IF(Q2=FALSE,O16,IF(P2=TRUE,IF(T16>E16,E16,T16),T16))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["August",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D17),D5,D17)*I17,2)+H17","v":0},0,{"$f":"IF( AND(J17>E17,L2=TRUE),E17,J17)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+M7","v":0},31,0,{"$f":"IF(AND(L16=0,E16>0,Q2=TRUE),0,IF(Q2=FALSE,O17,IF(P2=TRUE,IF(T17>E17,E17,T17),T17))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["September",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D18),D5,D18)*I18,2)+H18","v":0},0,{"$f":"IF( AND(J18>E18,L2=TRUE),E18,J18)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+M7","v":0},30,0,{"$f":"IF(AND(L17=0,E17>0,Q2=TRUE),0,IF(Q2=FALSE,O18,IF(P2=TRUE,IF(T18>E18,E18,T18),T18))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Oktober",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D19),D5,D19)*I19,2)+H19","v":0},0,{"$f":"IF( AND(J19>E19,L2=TRUE),E19,J19)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+M7","v":0},31,0,{"$f":"IF(AND(L18=0,E18>0,Q2=TRUE),0,IF(Q2=FALSE,O19,IF(P2=TRUE,IF(T19>E19,E19,T19),T19))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["November",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D20),D5,D20)*I20,2)+H20","v":0},0,{"$f":"IF( AND(J20>E20,L2=TRUE),E20,J20)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+M7","v":0},30,0,{"$f":"IF(AND(L19=0,E19>0,Q2=TRUE),0,IF(Q2=FALSE,O20,IF(P2=TRUE,IF(T20>E20,E20,T20),T20))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Dezember",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D21),D5,D21)*I21,2)+H21","v":0},0,{"$f":"IF( AND(J21>E21,L2=TRUE),E21,J21)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+L21+M7","v":0},31,0,{"$f":"IF(AND(L20=0,E20>0,Q2=TRUE),0,IF(Q2=FALSE,O21,IF(P2=TRUE,IF(T21>E21,E21,T21),T21))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+Q21+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
[]
[{"$f":"\"Saldovorträge für \"&A1+1&\":\"&\"                                     Restbudget vortragen:\"","v":"Saldovorträge für 2017:                                     Restbudget vortragen:"},null,null,null,null,{"$f":"IF(F2=TRUE,S21,0)","v":0},null,null,null,null,null,null,{"$f":"IF(O21>0,O21,0)","v":0},null,null,{"$f":"\"      + \" & ROUND(O2,2)&\" € Finanzreserve\"","v":"      + 0 € Finanzreserve"},null,{"$f":"IF(O21<0,-O21,0)","v":0}]
[]
["Mittelwerte:",{"$f":"IFERROR(IF((SUM(B10:B21)/12)>0,SUM(B10:B21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(C10:C21, \"<>0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(E10:E21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF((SUM(H10:H21)/12)>0,SUM(H10:H21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(I10:I21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(AVERAGEIF(L10:L21, \"<>0\"),\"\")","v":""},null,null,"Finanzreserve =",0.05,{"$f":"IFERROR(AVERAGEIF(Q10:Q21, \"<>0\"),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16 & \" - \")  & \"Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Lara Mustermann - Leistungsnachweis für Dezember 2015"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"Lara Mustermann, geb. 01.10.2005"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J37+9","v":10},{"$f":"INDEX(A:A,J33-1)&\"  \"&J34","v":"Dezember  2015"},{"$f":"\"Saldo per \"&INDEX(A:A,J33-2)","v":"Saldo per November"},null,null,null,null,null,null,{"$f":"INDEX(O:O,J33-2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<11,A1-1,A1)","v":2015},null,{"$f":"\"      Zahlung für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Zahlung für Dezember 2015"},null,null,null,null,null,{"$f":"-INDEX(Q:Q,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(MATCH(30503.7362772129,Q9:Q21,1)-1=0,1,MATCH(30503.7362772129,Q9:Q21,1)-1)","v":1},null,{"$f":"\"Saldo nach Zahlung \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Zahlung Dezember 2015"},null,null,null,null,null,null,{"$f":"S33+R34","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K55),J35,K55)","v":1},null,{"$f":"\"Leistungsnachweis \"&INDEX(A:A,J33-1)","v":"Leistungsnachweis Dezember"},null,null,null,"Sonderauslagen     Stunden",null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Budgetlimit",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"ROUND(INDEX(V:V,J33-1),2)","v":0},{"$f":"ROUND(INDEX(W:W,J33-1),2)","v":0},{"$f":"INDEX(E:E,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nachweis",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"INDEX(H:H,J33-1)","v":0},{"$f":"INDEX(I:I,J33-1)","v":0},{"$f":"INDEX(J:J,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L2=TRUE,R40<0),\"Kürzung\",\"\")","v":""},null,{"$f":"IF(AND(L2=TRUE,R40<0),\"(Wegen Budgetüberschreitung)\",\"\")","v":""},null,null,{"$f":"Q42-R39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33-1)","v":"Bemerkungen\nDezember"},{"$f":"IF(INDEX(U:U,J33-1)=0,\"\",INDEX(U:U,J33-1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"      Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Leistungsnachweis für Dezember 2015"},null,null,null,null,{"$f":"INDEX(L:L,J33-1)","v":0},null,{"$f":"Q42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Saldo nach Leist.nachweis \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Leist.nachweis Dezember 2015"},null,null,null,null,null,null,{"$f":"SUM(S35:S42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(A:A,J33)&\"  \"&J50","v":"Januar  2016"},null,"Budget",null,{"$f":"INDEX(A:A,J33)","v":"Januar"},null,null,null,{"$f":"INDEX(E:E,J33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," - Überzahlung",null,null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},null,null,null,{"$f":"S43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R2=TRUE,\"+ Finanzreserve\",\"\")","v":""},null,null,null,null,null,null,{"$f":"ROUND(IF(R2=TRUE,O2,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," =",{"$f":"\"Ermittelte Vorauszahlung für \"&INDEX(A:A,J33)&\" \"&J50","v":"Ermittelte Vorauszahlung für Januar 2016"},null,null,null,null,null,{"$f":"ROUND(INDEX(P:P,J33),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33)","v":"Bemerkungen\nJanuar"},{"$f":"IF(INDEX(U:U,J33)=0,\"\",INDEX(U:U,J33))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<10,A1-1,A1)","v":2016},null,{"$f":"\"      Überweisung für \"&INDEX(A:A,J33)&\" \"&J50","v":"      Überweisung für Januar 2016"},null,null,null,null,{"$f":"\"Differenz: \"","v":"Differenz: "},{"$f":"ROUND(S50-S48,2)","v":0},{"$f":"ROUND(INDEX(Q:Q,J33),2)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Details zur Vorauszahlung \"&INDEX(A:A,J33)&\" \"&J50& \" und dem Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Details zur Vorauszahlung Januar 2016 und dem Leistungsnachweis für Dezember 2015"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dieses Feld leer lassen. \nDie Auswertung stellt sich dann automatisch auf den Monat mit der aktuelle Vorauszahlung ein.\nBei Bedarf eingeben (für Kontoabstimmung etc.): Die Nummer des Monats, in dem die Vorauszahlung stattfindet. \n1-12 = Monate des laufenden Jahres. 0 = Dezember des Vorjahres."]

{"sheet":"2017","index":1,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,11,56,18],[36,11,36,14],[52,10,52,18],[48,12,48,17],[50,10,50,18],[49,11,49,15],[33,11,33,15],[41,11,41,15],[41,16,41,17],[44,10,49,10],[45,11,45,12],[46,11,46,12],[47,12,47,17],[33,17,33,18],[36,15,36,16],[39,14,39,16],[40,12,40,17],[32,10,42,10],[34,11,34,17],[42,11,42,17],[32,11,32,17],[22,0,22,4],[22,15,22,16],[27,4,28,4],[29,10,29,18],[30,10,30,18],[0,2,0,14],[0,15,0,18],[2,1,2,4],[2,7,2,12],[2,14,2,18],[2,20,4,20],[3,4,4,4],[3,5,4,5],[3,7,4,7],[3,8,4,8],[3,17,4,17],[3,18,4,18],[3,9,3,11],[3,12,4,12],[3,14,4,14],[3,15,4,15],[3,16,4,16]]}
[{"$f":"(MID(CELL(\"dateiname\",A1),FIND(\"]\",CELL(\"dateiname\",A1))+1,30))+1-1","v":2017},"PB",{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16)&IF(ISBLANK(Infofelder!A19),\"\",\", geb. \"&Infofelder!A19)","v":"Lara Mustermann, geb. 01.10.2005"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A11),\"\",Infofelder!A11)&\":   \"&IF(ISBLANK(Infofelder!A12),\"\",Infofelder!A12)","v":"Zuständig:   Marie Louise Krankenstand-Müller"},null,null,null,null,"Bemerkungen"]
[{"$f":"IFERROR(INDIRECT(A1-1&\"!A5\"),0)","v":"00:00:00"},{"$f":"IFERROR(INDIRECT(A1-1&\"!B5\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!C5\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!D5\"),0)","v":0},true,false,null,30.3333333333333,null,null,null,false,null,null,{"$f":"ROUND((C5*D5+B5)*P25,0)","v":0},false,true,false]
[null," Persönliches Budget",null,null,null,null,null,"Leistungsnachweise",null,null,null,null,null,null,"Zahlungen",null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A5),\"\",Infofelder!A5)","v":"Blattschutz aufheben und/oder Änderungen machen, NUR nach Einweisung in die Funktion des Formulars!"}]
["Gültig ab:","Auslagen/M.","Stunden./M.","€ /Std.","Budget\npro Monat","kumuliert",null,"Âuslagen\n€ /Monat","Stunden h /Monat","Nachweis",null,null,"kumuliert",null,"Über-\nzahlung\n(Rot)","Vorschlag","Überweisung","kumuliert","Budget\nüberschritten\n(Rot)"]
[null,null,null,null,null,null,null,null,null,"Eingereicht","Kürzung","Akzeptiert"]
[]
["Saldovorträge aus",{"$f":"A1-1&\":\"","v":"2016:"},null,null,"     Tag-genau",{"$f":"IFERROR(INDIRECT(A1-1&\"!F23\"),0)","v":0},null,null,null,null,null,"     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!M23\"),0)","v":0},null,{"$f":"-R7+M7","v":0},"    Vorauszahlg.","     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!r23\"),0)","v":0},null,null,"Bemerkungen zum Monat:"]
["November",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o20\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q20\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U20\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!V20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W20\"),0)","v":0}]
["Dezember",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o21\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q21\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U21\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!V21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W21\"),0)","v":0}]
["Januar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"E10+F7","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D10),D5,D10)*I10,2)+H10","v":0},{"$f":"L10-J10","v":0},{"$f":"IF( AND(J10>E10,L2=TRUE),E10,J10)","v":0},{"$f":"L10+M7","v":0},31,{"$f":"M10-R10","v":0},{"$f":"IF( AND(L9=0,E9>0,Q2=TRUE),0,IF(Q2=FALSE,O10,IF(P2=TRUE,IF(T10>E10,E10,T10),T10))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+R7","v":0},{"$f":"F10-M10","v":0},{"$f":"E10+O7","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Februar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F10+E11","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D11),D5,D11)*I11,2)+H11","v":0},0,{"$f":"IF( AND(J11>E11,L2=TRUE),E11,J11)","v":0},{"$f":"L10+L11+M7","v":0},{"$f":"IF(   ((A1-2000)/4)=ROUND( ((A1-2000)/4),0),29,28)","v":28},0,{"$f":"IF(AND(L10=0,E10>0,Q2=TRUE),0,IF(Q2=FALSE,O11,IF(P2=TRUE,IF(T11>E11,E11,T11),T11))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+R7","v":0},0,{"$f":"E11+O10","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["März",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F11+E12","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D12),D5,D12)*I12,2)+H12","v":0},0,{"$f":"IF( AND(J12>E12,L2=TRUE),E12,J12)","v":0},{"$f":"L10+L11+L12+M7","v":0},31,0,{"$f":"IF(AND(L11=0,E11>0,Q2=TRUE),0,IF(Q2=FALSE,O12,IF(P2=TRUE,IF(T12>E12,E12,T12),T12))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["April",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D13),D5,D13)*I13,2)+H13","v":0},0,{"$f":"IF( AND(J13>E13,L2=TRUE),E13,J13)","v":0},{"$f":"L10+L11+L12+L13+M7","v":0},30,0,{"$f":"IF(AND(L12=0,E12>0,Q2=TRUE),0,IF(Q2=FALSE,O13,IF(P2=TRUE,IF(T13>E13,E13,T13),T13))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Mai",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D14),D5,D14)*I14,2)+H14","v":0},0,{"$f":"IF( AND(J14>E14,L2=TRUE),E14,J14)","v":0},{"$f":"L10+L11+L12+L13+L14+M7","v":0},31,0,{"$f":"IF(AND(L13=0,E13>0,Q2=TRUE),0,IF(Q2=FALSE,O14,IF(P2=TRUE,IF(T14>E14,E14,T14),T14))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juni",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D15),D5,D15)*I15,2)+H15","v":0},0,{"$f":"IF( AND(J15>E15,L2=TRUE),E15,J15)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+M7","v":0},30,0,{"$f":"IF(AND(L14=0,E14>0,Q2=TRUE),0,IF(Q2=FALSE,O15,IF(P2=TRUE,IF(T15>E15,E15,T15),T15))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juli",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D16),D5,D16)*I16,2)+H16","v":0},0,{"$f":"IF( AND(J16>E16,L2=TRUE),E16,J16)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+M7","v":0},31,0,{"$f":"IF(AND(L15=0,E15>0,Q2=TRUE),0,IF(Q2=FALSE,O16,IF(P2=TRUE,IF(T16>E16,E16,T16),T16))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["August",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D17),D5,D17)*I17,2)+H17","v":0},0,{"$f":"IF( AND(J17>E17,L2=TRUE),E17,J17)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+M7","v":0},31,0,{"$f":"IF(AND(L16=0,E16>0,Q2=TRUE),0,IF(Q2=FALSE,O17,IF(P2=TRUE,IF(T17>E17,E17,T17),T17))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["September",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D18),D5,D18)*I18,2)+H18","v":0},0,{"$f":"IF( AND(J18>E18,L2=TRUE),E18,J18)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+M7","v":0},30,0,{"$f":"IF(AND(L17=0,E17>0,Q2=TRUE),0,IF(Q2=FALSE,O18,IF(P2=TRUE,IF(T18>E18,E18,T18),T18))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Oktober",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D19),D5,D19)*I19,2)+H19","v":0},0,{"$f":"IF( AND(J19>E19,L2=TRUE),E19,J19)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+M7","v":0},31,0,{"$f":"IF(AND(L18=0,E18>0,Q2=TRUE),0,IF(Q2=FALSE,O19,IF(P2=TRUE,IF(T19>E19,E19,T19),T19))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["November",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D20),D5,D20)*I20,2)+H20","v":0},0,{"$f":"IF( AND(J20>E20,L2=TRUE),E20,J20)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+M7","v":0},30,0,{"$f":"IF(AND(L19=0,E19>0,Q2=TRUE),0,IF(Q2=FALSE,O20,IF(P2=TRUE,IF(T20>E20,E20,T20),T20))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Dezember",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D21),D5,D21)*I21,2)+H21","v":0},0,{"$f":"IF( AND(J21>E21,L2=TRUE),E21,J21)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+L21+M7","v":0},31,0,{"$f":"IF(AND(L20=0,E20>0,Q2=TRUE),0,IF(Q2=FALSE,O21,IF(P2=TRUE,IF(T21>E21,E21,T21),T21))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+Q21+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
[]
[{"$f":"\"Saldovorträge für \"&A1+1&\":\"&\"                                     Restbudget vortragen:\"","v":"Saldovorträge für 2018:                                     Restbudget vortragen:"},null,null,null,null,{"$f":"IF(F2=TRUE,S21,0)","v":0},null,null,null,null,null,null,{"$f":"IF(O21>0,O21,0)","v":0},null,null,{"$f":"\"      + \" & ROUND(O2,2)&\" € Finanzreserve\"","v":"      + 0 € Finanzreserve"},null,{"$f":"IF(O21<0,-O21,0)","v":0}]
[]
["Mittelwerte:",{"$f":"IFERROR(IF((SUM(B10:B21)/12)>0,SUM(B10:B21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(C10:C21, \"<>0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(E10:E21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF((SUM(H10:H21)/12)>0,SUM(H10:H21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(I10:I21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(AVERAGEIF(L10:L21, \"<>0\"),\"\")","v":""},null,null,"Finanzreserve =",0.05,{"$f":"IFERROR(AVERAGEIF(Q10:Q21, \"<>0\"),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16 & \" - \")  & \"Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Lara Mustermann - Leistungsnachweis für Dezember 2016"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"Lara Mustermann, geb. 01.10.2005"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J37+9","v":10},{"$f":"INDEX(A:A,J33-1)&\"  \"&J34","v":"Dezember  2016"},{"$f":"\"Saldo per \"&INDEX(A:A,J33-2)","v":"Saldo per November"},null,null,null,null,null,null,{"$f":"INDEX(O:O,J33-2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<11,A1-1,A1)","v":2016},null,{"$f":"\"      Zahlung für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Zahlung für Dezember 2016"},null,null,null,null,null,{"$f":"-INDEX(Q:Q,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(MATCH(30503.7362772129,Q9:Q21,1)-1=0,1,MATCH(30503.7362772129,Q9:Q21,1)-1)","v":1},null,{"$f":"\"Saldo nach Zahlung \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Zahlung Dezember 2016"},null,null,null,null,null,null,{"$f":"S33+R34","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K55),J35,K55)","v":1},null,{"$f":"\"Leistungsnachweis \"&INDEX(A:A,J33-1)","v":"Leistungsnachweis Dezember"},null,null,null,"Sonderauslagen     Stunden",null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Budgetlimit",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"ROUND(INDEX(V:V,J33-1),2)","v":0},{"$f":"ROUND(INDEX(W:W,J33-1),2)","v":0},{"$f":"INDEX(E:E,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nachweis",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"INDEX(H:H,J33-1)","v":0},{"$f":"INDEX(I:I,J33-1)","v":0},{"$f":"INDEX(J:J,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L2=TRUE,R40<0),\"Kürzung\",\"\")","v":""},null,{"$f":"IF(AND(L2=TRUE,R40<0),\"(Wegen Budgetüberschreitung)\",\"\")","v":""},null,null,{"$f":"Q42-R39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33-1)","v":"Bemerkungen\nDezember"},{"$f":"IF(INDEX(U:U,J33-1)=0,\"\",INDEX(U:U,J33-1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"      Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Leistungsnachweis für Dezember 2016"},null,null,null,null,{"$f":"INDEX(L:L,J33-1)","v":0},null,{"$f":"Q42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Saldo nach Leist.nachweis \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Leist.nachweis Dezember 2016"},null,null,null,null,null,null,{"$f":"SUM(S35:S42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(A:A,J33)&\"  \"&J50","v":"Januar  2017"},null,"Budget",null,{"$f":"INDEX(A:A,J33)","v":"Januar"},null,null,null,{"$f":"INDEX(E:E,J33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," - Überzahlung",null,null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},null,null,null,{"$f":"S43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R2=TRUE,\"+ Finanzreserve\",\"\")","v":""},null,null,null,null,null,null,{"$f":"ROUND(IF(R2=TRUE,O2,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," =",{"$f":"\"Ermittelte Vorauszahlung für \"&INDEX(A:A,J33)&\" \"&J50","v":"Ermittelte Vorauszahlung für Januar 2017"},null,null,null,null,null,{"$f":"ROUND(INDEX(P:P,J33),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33)","v":"Bemerkungen\nJanuar"},{"$f":"IF(INDEX(U:U,J33)=0,\"\",INDEX(U:U,J33))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<10,A1-1,A1)","v":2017},null,{"$f":"\"      Überweisung für \"&INDEX(A:A,J33)&\" \"&J50","v":"      Überweisung für Januar 2017"},null,null,null,null,{"$f":"\"Differenz: \"","v":"Differenz: "},{"$f":"ROUND(S50-S48,2)","v":0},{"$f":"ROUND(INDEX(Q:Q,J33),2)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Details zur Vorauszahlung \"&INDEX(A:A,J33)&\" \"&J50& \" und dem Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Details zur Vorauszahlung Januar 2017 und dem Leistungsnachweis für Dezember 2016"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dieses Feld leer lassen. \nDie Auswertung stellt sich dann automatisch auf den Monat mit der aktuelle Vorauszahlung ein.\nBei Bedarf eingeben (für Kontoabstimmung etc.): Die Nummer des Monats, in dem die Vorauszahlung stattfindet. \n1-12 = Monate des laufenden Jahres. 0 = Dezember des Vorjahres."]

{"sheet":"2018","index":2,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,11,56,18],[41,16,41,17],[42,11,42,17],[44,10,49,10],[45,11,45,12],[46,11,46,12],[47,12,47,17],[48,12,48,17],[49,11,49,15],[32,10,42,10],[32,11,32,17],[33,11,33,15],[33,17,33,18],[34,11,34,17],[39,14,39,16],[40,12,40,17],[41,11,41,15],[50,10,50,18],[52,10,52,18],[22,0,22,4],[22,15,22,16],[27,4,28,4],[29,10,29,18],[36,11,36,14],[36,15,36,16],[30,10,30,18],[3,9,3,11],[3,12,4,12],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[0,2,0,14],[0,15,0,18],[2,1,2,4],[2,7,2,12],[2,14,2,18],[2,20,4,20],[3,4,4,4],[3,5,4,5],[3,7,4,7],[3,8,4,8]]}
[{"$f":"(MID(CELL(\"dateiname\",A1),FIND(\"]\",CELL(\"dateiname\",A1))+1,30))+1-1","v":2018},"PB",{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16)&IF(ISBLANK(Infofelder!A19),\"\",\", geb. \"&Infofelder!A19)","v":"Lara Mustermann, geb. 01.10.2005"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A11),\"\",Infofelder!A11)&\":   \"&IF(ISBLANK(Infofelder!A12),\"\",Infofelder!A12)","v":"Zuständig:   Marie Louise Krankenstand-Müller"},null,null,null,null,"Bemerkungen"]
[{"$f":"IFERROR(INDIRECT(A1-1&\"!A5\"),0)","v":"00:00:00"},{"$f":"IFERROR(INDIRECT(A1-1&\"!B5\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!C5\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!D5\"),0)","v":0},true,false,null,30.3333333333333,null,null,null,false,null,null,{"$f":"ROUND((C5*D5+B5)*P25,0)","v":0},false,true,false]
[null," Persönliches Budget",null,null,null,null,null,"Leistungsnachweise",null,null,null,null,null,null,"Zahlungen",null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A5),\"\",Infofelder!A5)","v":"Blattschutz aufheben und/oder Änderungen machen, NUR nach Einweisung in die Funktion des Formulars!"}]
["Gültig ab:","Auslagen/M.","Stunden./M.","€ /Std.","Budget\npro Monat","kumuliert",null,"Âuslagen\n€ /Monat","Stunden h /Monat","Nachweis",null,null,"kumuliert",null,"Über-\nzahlung\n(Rot)","Vorschlag","Überweisung","kumuliert","Budget\nüberschritten\n(Rot)"]
[null,null,null,null,null,null,null,null,null,"Eingereicht","Kürzung","Akzeptiert"]
[]
["Saldovorträge aus",{"$f":"A1-1&\":\"","v":"2017:"},null,null,"     Tag-genau",{"$f":"IFERROR(INDIRECT(A1-1&\"!F23\"),0)","v":0},null,null,null,null,null,"     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!M23\"),0)","v":0},null,{"$f":"-R7+M7","v":0},"    Vorauszahlg.","     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!r23\"),0)","v":0},null,null,"Bemerkungen zum Monat:"]
["November",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o20\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q20\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U20\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!V20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W20\"),0)","v":0}]
["Dezember",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o21\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q21\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U21\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!V21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W21\"),0)","v":0}]
["Januar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"E10+F7","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D10),D5,D10)*I10,2)+H10","v":0},{"$f":"L10-J10","v":0},{"$f":"IF( AND(J10>E10,L2=TRUE),E10,J10)","v":0},{"$f":"L10+M7","v":0},31,{"$f":"M10-R10","v":0},{"$f":"IF( AND(L9=0,E9>0,Q2=TRUE),0,IF(Q2=FALSE,O10,IF(P2=TRUE,IF(T10>E10,E10,T10),T10))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+R7","v":0},{"$f":"F10-M10","v":0},{"$f":"E10+O7","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Februar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F10+E11","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D11),D5,D11)*I11,2)+H11","v":0},0,{"$f":"IF( AND(J11>E11,L2=TRUE),E11,J11)","v":0},{"$f":"L10+L11+M7","v":0},{"$f":"IF(   ((A1-2000)/4)=ROUND( ((A1-2000)/4),0),29,28)","v":28},0,{"$f":"IF(AND(L10=0,E10>0,Q2=TRUE),0,IF(Q2=FALSE,O11,IF(P2=TRUE,IF(T11>E11,E11,T11),T11))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+R7","v":0},0,{"$f":"E11+O10","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["März",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F11+E12","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D12),D5,D12)*I12,2)+H12","v":0},0,{"$f":"IF( AND(J12>E12,L2=TRUE),E12,J12)","v":0},{"$f":"L10+L11+L12+M7","v":0},31,0,{"$f":"IF(AND(L11=0,E11>0,Q2=TRUE),0,IF(Q2=FALSE,O12,IF(P2=TRUE,IF(T12>E12,E12,T12),T12))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["April",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D13),D5,D13)*I13,2)+H13","v":0},0,{"$f":"IF( AND(J13>E13,L2=TRUE),E13,J13)","v":0},{"$f":"L10+L11+L12+L13+M7","v":0},30,0,{"$f":"IF(AND(L12=0,E12>0,Q2=TRUE),0,IF(Q2=FALSE,O13,IF(P2=TRUE,IF(T13>E13,E13,T13),T13))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Mai",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D14),D5,D14)*I14,2)+H14","v":0},0,{"$f":"IF( AND(J14>E14,L2=TRUE),E14,J14)","v":0},{"$f":"L10+L11+L12+L13+L14+M7","v":0},31,0,{"$f":"IF(AND(L13=0,E13>0,Q2=TRUE),0,IF(Q2=FALSE,O14,IF(P2=TRUE,IF(T14>E14,E14,T14),T14))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juni",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D15),D5,D15)*I15,2)+H15","v":0},0,{"$f":"IF( AND(J15>E15,L2=TRUE),E15,J15)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+M7","v":0},30,0,{"$f":"IF(AND(L14=0,E14>0,Q2=TRUE),0,IF(Q2=FALSE,O15,IF(P2=TRUE,IF(T15>E15,E15,T15),T15))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juli",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D16),D5,D16)*I16,2)+H16","v":0},0,{"$f":"IF( AND(J16>E16,L2=TRUE),E16,J16)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+M7","v":0},31,0,{"$f":"IF(AND(L15=0,E15>0,Q2=TRUE),0,IF(Q2=FALSE,O16,IF(P2=TRUE,IF(T16>E16,E16,T16),T16))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["August",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D17),D5,D17)*I17,2)+H17","v":0},0,{"$f":"IF( AND(J17>E17,L2=TRUE),E17,J17)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+M7","v":0},31,0,{"$f":"IF(AND(L16=0,E16>0,Q2=TRUE),0,IF(Q2=FALSE,O17,IF(P2=TRUE,IF(T17>E17,E17,T17),T17))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["September",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D18),D5,D18)*I18,2)+H18","v":0},0,{"$f":"IF( AND(J18>E18,L2=TRUE),E18,J18)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+M7","v":0},30,0,{"$f":"IF(AND(L17=0,E17>0,Q2=TRUE),0,IF(Q2=FALSE,O18,IF(P2=TRUE,IF(T18>E18,E18,T18),T18))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Oktober",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D19),D5,D19)*I19,2)+H19","v":0},0,{"$f":"IF( AND(J19>E19,L2=TRUE),E19,J19)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+M7","v":0},31,0,{"$f":"IF(AND(L18=0,E18>0,Q2=TRUE),0,IF(Q2=FALSE,O19,IF(P2=TRUE,IF(T19>E19,E19,T19),T19))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["November",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D20),D5,D20)*I20,2)+H20","v":0},0,{"$f":"IF( AND(J20>E20,L2=TRUE),E20,J20)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+M7","v":0},30,0,{"$f":"IF(AND(L19=0,E19>0,Q2=TRUE),0,IF(Q2=FALSE,O20,IF(P2=TRUE,IF(T20>E20,E20,T20),T20))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Dezember",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D21),D5,D21)*I21,2)+H21","v":0},0,{"$f":"IF( AND(J21>E21,L2=TRUE),E21,J21)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+L21+M7","v":0},31,0,{"$f":"IF(AND(L20=0,E20>0,Q2=TRUE),0,IF(Q2=FALSE,O21,IF(P2=TRUE,IF(T21>E21,E21,T21),T21))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+Q21+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
[]
[{"$f":"\"Saldovorträge für \"&A1+1&\":\"&\"                                     Restbudget vortragen:\"","v":"Saldovorträge für 2019:                                     Restbudget vortragen:"},null,null,null,null,{"$f":"IF(F2=TRUE,S21,0)","v":0},null,null,null,null,null,null,{"$f":"IF(O21>0,O21,0)","v":0},null,null,{"$f":"\"      + \" & ROUND(O2,2)&\" € Finanzreserve\"","v":"      + 0 € Finanzreserve"},null,{"$f":"IF(O21<0,-O21,0)","v":0}]
[]
["Mittelwerte:",{"$f":"IFERROR(IF((SUM(B10:B21)/12)>0,SUM(B10:B21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(C10:C21, \"<>0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(E10:E21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF((SUM(H10:H21)/12)>0,SUM(H10:H21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(I10:I21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(AVERAGEIF(L10:L21, \"<>0\"),\"\")","v":""},null,null,"Finanzreserve =",0.05,{"$f":"IFERROR(AVERAGEIF(Q10:Q21, \"<>0\"),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16 & \" - \")  & \"Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Lara Mustermann - Leistungsnachweis für Dezember 2017"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"Lara Mustermann, geb. 01.10.2005"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J37+9","v":10},{"$f":"INDEX(A:A,J33-1)&\"  \"&J34","v":"Dezember  2017"},{"$f":"\"Saldo per \"&INDEX(A:A,J33-2)","v":"Saldo per November"},null,null,null,null,null,null,{"$f":"INDEX(O:O,J33-2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<11,A1-1,A1)","v":2017},null,{"$f":"\"      Zahlung für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Zahlung für Dezember 2017"},null,null,null,null,null,{"$f":"-INDEX(Q:Q,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(MATCH(30503.7362772129,Q9:Q21,1)-1=0,1,MATCH(30503.7362772129,Q9:Q21,1)-1)","v":1},null,{"$f":"\"Saldo nach Zahlung \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Zahlung Dezember 2017"},null,null,null,null,null,null,{"$f":"S33+R34","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K55),J35,K55)","v":1},null,{"$f":"\"Leistungsnachweis \"&INDEX(A:A,J33-1)","v":"Leistungsnachweis Dezember"},null,null,null,"Sonderauslagen     Stunden",null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Budgetlimit",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"ROUND(INDEX(V:V,J33-1),2)","v":0},{"$f":"ROUND(INDEX(W:W,J33-1),2)","v":0},{"$f":"INDEX(E:E,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nachweis",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"INDEX(H:H,J33-1)","v":0},{"$f":"INDEX(I:I,J33-1)","v":0},{"$f":"INDEX(J:J,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L2=TRUE,R40<0),\"Kürzung\",\"\")","v":""},null,{"$f":"IF(AND(L2=TRUE,R40<0),\"(Wegen Budgetüberschreitung)\",\"\")","v":""},null,null,{"$f":"Q42-R39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33-1)","v":"Bemerkungen\nDezember"},{"$f":"IF(INDEX(U:U,J33-1)=0,\"\",INDEX(U:U,J33-1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"      Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Leistungsnachweis für Dezember 2017"},null,null,null,null,{"$f":"INDEX(L:L,J33-1)","v":0},null,{"$f":"Q42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Saldo nach Leist.nachweis \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Leist.nachweis Dezember 2017"},null,null,null,null,null,null,{"$f":"SUM(S35:S42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(A:A,J33)&\"  \"&J50","v":"Januar  2018"},null,"Budget",null,{"$f":"INDEX(A:A,J33)","v":"Januar"},null,null,null,{"$f":"INDEX(E:E,J33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," - Überzahlung",null,null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},null,null,null,{"$f":"S43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R2=TRUE,\"+ Finanzreserve\",\"\")","v":""},null,null,null,null,null,null,{"$f":"ROUND(IF(R2=TRUE,O2,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," =",{"$f":"\"Ermittelte Vorauszahlung für \"&INDEX(A:A,J33)&\" \"&J50","v":"Ermittelte Vorauszahlung für Januar 2018"},null,null,null,null,null,{"$f":"ROUND(INDEX(P:P,J33),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33)","v":"Bemerkungen\nJanuar"},{"$f":"IF(INDEX(U:U,J33)=0,\"\",INDEX(U:U,J33))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<10,A1-1,A1)","v":2018},null,{"$f":"\"      Überweisung für \"&INDEX(A:A,J33)&\" \"&J50","v":"      Überweisung für Januar 2018"},null,null,null,null,{"$f":"\"Differenz: \"","v":"Differenz: "},{"$f":"ROUND(S50-S48,2)","v":0},{"$f":"ROUND(INDEX(Q:Q,J33),2)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Details zur Vorauszahlung \"&INDEX(A:A,J33)&\" \"&J50& \" und dem Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Details zur Vorauszahlung Januar 2018 und dem Leistungsnachweis für Dezember 2017"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dieses Feld leer lassen. \nDie Auswertung stellt sich dann automatisch auf den Monat mit der aktuelle Vorauszahlung ein.\nBei Bedarf eingeben (für Kontoabstimmung etc.): Die Nummer des Monats, in dem die Vorauszahlung stattfindet. \n1-12 = Monate des laufenden Jahres. 0 = Dezember des Vorjahres."]

{"sheet":"2019","index":3,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,11,56,18],[41,16,41,17],[42,11,42,17],[44,10,49,10],[45,11,45,12],[46,11,46,12],[47,12,47,17],[48,12,48,17],[49,11,49,15],[32,10,42,10],[32,11,32,17],[33,11,33,15],[33,17,33,18],[34,11,34,17],[39,14,39,16],[40,12,40,17],[41,11,41,15],[50,10,50,18],[52,10,52,18],[22,0,22,4],[22,15,22,16],[27,4,28,4],[29,10,29,18],[36,11,36,14],[36,15,36,16],[30,10,30,18],[3,9,3,11],[3,12,4,12],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[0,2,0,14],[0,15,0,18],[2,1,2,4],[2,7,2,12],[2,14,2,18],[2,20,4,20],[3,4,4,4],[3,5,4,5],[3,7,4,7],[3,8,4,8]]}
[{"$f":"(MID(CELL(\"dateiname\",A1),FIND(\"]\",CELL(\"dateiname\",A1))+1,30))+1-1","v":2019},"PB",{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16)&IF(ISBLANK(Infofelder!A19),\"\",\", geb. \"&Infofelder!A19)","v":"Lara Mustermann, geb. 01.10.2005"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A11),\"\",Infofelder!A11)&\":   \"&IF(ISBLANK(Infofelder!A12),\"\",Infofelder!A12)","v":"Zuständig:   Marie Louise Krankenstand-Müller"},null,null,null,null,"Bemerkungen"]
[{"$f":"IFERROR(INDIRECT(A1-1&\"!A5\"),0)","v":"00:00:00"},{"$f":"IFERROR(INDIRECT(A1-1&\"!B5\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!C5\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!D5\"),0)","v":0},true,false,null,30.3333333333333,null,null,null,false,null,null,{"$f":"ROUND((C5*D5+B5)*P25,0)","v":0},false,true,false]
[null," Persönliches Budget",null,null,null,null,null,"Leistungsnachweise",null,null,null,null,null,null,"Zahlungen",null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A5),\"\",Infofelder!A5)","v":"Blattschutz aufheben und/oder Änderungen machen, NUR nach Einweisung in die Funktion des Formulars!"}]
["Gültig ab:","Auslagen/M.","Stunden./M.","€ /Std.","Budget\npro Monat","kumuliert",null,"Âuslagen\n€ /Monat","Stunden h /Monat","Nachweis",null,null,"kumuliert",null,"Über-\nzahlung\n(Rot)","Vorschlag","Überweisung","kumuliert","Budget\nüberschritten\n(Rot)"]
[null,null,null,null,null,null,null,null,null,"Eingereicht","Kürzung","Akzeptiert"]
[]
["Saldovorträge aus",{"$f":"A1-1&\":\"","v":"2018:"},null,null,"     Tag-genau",{"$f":"IFERROR(INDIRECT(A1-1&\"!F23\"),0)","v":0},null,null,null,null,null,"     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!M23\"),0)","v":0},null,{"$f":"-R7+M7","v":0},"    Vorauszahlg.","     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!r23\"),0)","v":0},null,null,"Bemerkungen zum Monat:"]
["November",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o20\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q20\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U20\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!V20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W20\"),0)","v":0}]
["Dezember",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o21\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q21\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U21\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!V21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W21\"),0)","v":0}]
["Januar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"E10+F7","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D10),D5,D10)*I10,2)+H10","v":0},{"$f":"L10-J10","v":0},{"$f":"IF( AND(J10>E10,L2=TRUE),E10,J10)","v":0},{"$f":"L10+M7","v":0},31,{"$f":"M10-R10","v":0},{"$f":"IF( AND(L9=0,E9>0,Q2=TRUE),0,IF(Q2=FALSE,O10,IF(P2=TRUE,IF(T10>E10,E10,T10),T10))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+R7","v":0},{"$f":"F10-M10","v":0},{"$f":"E10+O7","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Februar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F10+E11","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D11),D5,D11)*I11,2)+H11","v":0},0,{"$f":"IF( AND(J11>E11,L2=TRUE),E11,J11)","v":0},{"$f":"L10+L11+M7","v":0},{"$f":"IF(   ((A1-2000)/4)=ROUND( ((A1-2000)/4),0),29,28)","v":28},0,{"$f":"IF(AND(L10=0,E10>0,Q2=TRUE),0,IF(Q2=FALSE,O11,IF(P2=TRUE,IF(T11>E11,E11,T11),T11))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+R7","v":0},0,{"$f":"E11+O10","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["März",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F11+E12","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D12),D5,D12)*I12,2)+H12","v":0},0,{"$f":"IF( AND(J12>E12,L2=TRUE),E12,J12)","v":0},{"$f":"L10+L11+L12+M7","v":0},31,0,{"$f":"IF(AND(L11=0,E11>0,Q2=TRUE),0,IF(Q2=FALSE,O12,IF(P2=TRUE,IF(T12>E12,E12,T12),T12))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["April",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D13),D5,D13)*I13,2)+H13","v":0},0,{"$f":"IF( AND(J13>E13,L2=TRUE),E13,J13)","v":0},{"$f":"L10+L11+L12+L13+M7","v":0},30,0,{"$f":"IF(AND(L12=0,E12>0,Q2=TRUE),0,IF(Q2=FALSE,O13,IF(P2=TRUE,IF(T13>E13,E13,T13),T13))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Mai",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D14),D5,D14)*I14,2)+H14","v":0},0,{"$f":"IF( AND(J14>E14,L2=TRUE),E14,J14)","v":0},{"$f":"L10+L11+L12+L13+L14+M7","v":0},31,0,{"$f":"IF(AND(L13=0,E13>0,Q2=TRUE),0,IF(Q2=FALSE,O14,IF(P2=TRUE,IF(T14>E14,E14,T14),T14))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juni",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D15),D5,D15)*I15,2)+H15","v":0},0,{"$f":"IF( AND(J15>E15,L2=TRUE),E15,J15)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+M7","v":0},30,0,{"$f":"IF(AND(L14=0,E14>0,Q2=TRUE),0,IF(Q2=FALSE,O15,IF(P2=TRUE,IF(T15>E15,E15,T15),T15))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juli",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D16),D5,D16)*I16,2)+H16","v":0},0,{"$f":"IF( AND(J16>E16,L2=TRUE),E16,J16)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+M7","v":0},31,0,{"$f":"IF(AND(L15=0,E15>0,Q2=TRUE),0,IF(Q2=FALSE,O16,IF(P2=TRUE,IF(T16>E16,E16,T16),T16))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["August",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D17),D5,D17)*I17,2)+H17","v":0},0,{"$f":"IF( AND(J17>E17,L2=TRUE),E17,J17)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+M7","v":0},31,0,{"$f":"IF(AND(L16=0,E16>0,Q2=TRUE),0,IF(Q2=FALSE,O17,IF(P2=TRUE,IF(T17>E17,E17,T17),T17))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["September",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D18),D5,D18)*I18,2)+H18","v":0},0,{"$f":"IF( AND(J18>E18,L2=TRUE),E18,J18)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+M7","v":0},30,0,{"$f":"IF(AND(L17=0,E17>0,Q2=TRUE),0,IF(Q2=FALSE,O18,IF(P2=TRUE,IF(T18>E18,E18,T18),T18))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Oktober",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D19),D5,D19)*I19,2)+H19","v":0},0,{"$f":"IF( AND(J19>E19,L2=TRUE),E19,J19)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+M7","v":0},31,0,{"$f":"IF(AND(L18=0,E18>0,Q2=TRUE),0,IF(Q2=FALSE,O19,IF(P2=TRUE,IF(T19>E19,E19,T19),T19))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["November",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D20),D5,D20)*I20,2)+H20","v":0},0,{"$f":"IF( AND(J20>E20,L2=TRUE),E20,J20)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+M7","v":0},30,0,{"$f":"IF(AND(L19=0,E19>0,Q2=TRUE),0,IF(Q2=FALSE,O20,IF(P2=TRUE,IF(T20>E20,E20,T20),T20))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Dezember",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D21),D5,D21)*I21,2)+H21","v":0},0,{"$f":"IF( AND(J21>E21,L2=TRUE),E21,J21)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+L21+M7","v":0},31,0,{"$f":"IF(AND(L20=0,E20>0,Q2=TRUE),0,IF(Q2=FALSE,O21,IF(P2=TRUE,IF(T21>E21,E21,T21),T21))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+Q21+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
[]
[{"$f":"\"Saldovorträge für \"&A1+1&\":\"&\"                                     Restbudget vortragen:\"","v":"Saldovorträge für 2020:                                     Restbudget vortragen:"},null,null,null,null,{"$f":"IF(F2=TRUE,S21,0)","v":0},null,null,null,null,null,null,{"$f":"IF(O21>0,O21,0)","v":0},null,null,{"$f":"\"      + \" & ROUND(O2,2)&\" € Finanzreserve\"","v":"      + 0 € Finanzreserve"},null,{"$f":"IF(O21<0,-O21,0)","v":0}]
[]
["Mittelwerte:",{"$f":"IFERROR(IF((SUM(B10:B21)/12)>0,SUM(B10:B21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(C10:C21, \"<>0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(E10:E21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF((SUM(H10:H21)/12)>0,SUM(H10:H21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(I10:I21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(AVERAGEIF(L10:L21, \"<>0\"),\"\")","v":""},null,null,"Finanzreserve =",0.05,{"$f":"IFERROR(AVERAGEIF(Q10:Q21, \"<>0\"),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16 & \" - \")  & \"Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Lara Mustermann - Leistungsnachweis für Dezember 2018"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"Lara Mustermann, geb. 01.10.2005"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J37+9","v":10},{"$f":"INDEX(A:A,J33-1)&\"  \"&J34","v":"Dezember  2018"},{"$f":"\"Saldo per \"&INDEX(A:A,J33-2)","v":"Saldo per November"},null,null,null,null,null,null,{"$f":"INDEX(O:O,J33-2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<11,A1-1,A1)","v":2018},null,{"$f":"\"      Zahlung für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Zahlung für Dezember 2018"},null,null,null,null,null,{"$f":"-INDEX(Q:Q,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(MATCH(30503.7362772129,Q9:Q21,1)-1=0,1,MATCH(30503.7362772129,Q9:Q21,1)-1)","v":1},null,{"$f":"\"Saldo nach Zahlung \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Zahlung Dezember 2018"},null,null,null,null,null,null,{"$f":"S33+R34","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K55),J35,K55)","v":1},null,{"$f":"\"Leistungsnachweis \"&INDEX(A:A,J33-1)","v":"Leistungsnachweis Dezember"},null,null,null,"Sonderauslagen     Stunden",null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Budgetlimit",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"ROUND(INDEX(V:V,J33-1),2)","v":0},{"$f":"ROUND(INDEX(W:W,J33-1),2)","v":0},{"$f":"INDEX(E:E,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nachweis",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"INDEX(H:H,J33-1)","v":0},{"$f":"INDEX(I:I,J33-1)","v":0},{"$f":"INDEX(J:J,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L2=TRUE,R40<0),\"Kürzung\",\"\")","v":""},null,{"$f":"IF(AND(L2=TRUE,R40<0),\"(Wegen Budgetüberschreitung)\",\"\")","v":""},null,null,{"$f":"Q42-R39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33-1)","v":"Bemerkungen\nDezember"},{"$f":"IF(INDEX(U:U,J33-1)=0,\"\",INDEX(U:U,J33-1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"      Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Leistungsnachweis für Dezember 2018"},null,null,null,null,{"$f":"INDEX(L:L,J33-1)","v":0},null,{"$f":"Q42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Saldo nach Leist.nachweis \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Leist.nachweis Dezember 2018"},null,null,null,null,null,null,{"$f":"SUM(S35:S42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(A:A,J33)&\"  \"&J50","v":"Januar  2019"},null,"Budget",null,{"$f":"INDEX(A:A,J33)","v":"Januar"},null,null,null,{"$f":"INDEX(E:E,J33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," - Überzahlung",null,null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},null,null,null,{"$f":"S43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R2=TRUE,\"+ Finanzreserve\",\"\")","v":""},null,null,null,null,null,null,{"$f":"ROUND(IF(R2=TRUE,O2,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," =",{"$f":"\"Ermittelte Vorauszahlung für \"&INDEX(A:A,J33)&\" \"&J50","v":"Ermittelte Vorauszahlung für Januar 2019"},null,null,null,null,null,{"$f":"ROUND(INDEX(P:P,J33),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33)","v":"Bemerkungen\nJanuar"},{"$f":"IF(INDEX(U:U,J33)=0,\"\",INDEX(U:U,J33))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<10,A1-1,A1)","v":2019},null,{"$f":"\"      Überweisung für \"&INDEX(A:A,J33)&\" \"&J50","v":"      Überweisung für Januar 2019"},null,null,null,null,{"$f":"\"Differenz: \"","v":"Differenz: "},{"$f":"ROUND(S50-S48,2)","v":0},{"$f":"ROUND(INDEX(Q:Q,J33),2)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Details zur Vorauszahlung \"&INDEX(A:A,J33)&\" \"&J50& \" und dem Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Details zur Vorauszahlung Januar 2019 und dem Leistungsnachweis für Dezember 2018"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dieses Feld leer lassen. \nDie Auswertung stellt sich dann automatisch auf den Monat mit der aktuelle Vorauszahlung ein.\nBei Bedarf eingeben (für Kontoabstimmung etc.): Die Nummer des Monats, in dem die Vorauszahlung stattfindet. \n1-12 = Monate des laufenden Jahres. 0 = Dezember des Vorjahres."]

{"sheet":"2020","index":4,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,11,56,18],[41,16,41,17],[42,11,42,17],[44,10,49,10],[45,11,45,12],[46,11,46,12],[47,12,47,17],[48,12,48,17],[49,11,49,15],[32,10,42,10],[32,11,32,17],[33,11,33,15],[33,17,33,18],[34,11,34,17],[39,14,39,16],[40,12,40,17],[41,11,41,15],[50,10,50,18],[52,10,52,18],[22,0,22,4],[22,15,22,16],[27,4,28,4],[29,10,29,18],[36,11,36,14],[36,15,36,16],[30,10,30,18],[3,9,3,11],[3,12,4,12],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,17,4,17],[3,18,4,18],[0,2,0,14],[0,15,0,18],[2,1,2,4],[2,7,2,12],[2,14,2,18],[2,20,4,20],[3,4,4,4],[3,5,4,5],[3,7,4,7],[3,8,4,8]]}
[{"$f":"(MID(CELL(\"dateiname\",A1),FIND(\"]\",CELL(\"dateiname\",A1))+1,30))+1-1","v":2020},"PB",{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16)&IF(ISBLANK(Infofelder!A19),\"\",\", geb. \"&Infofelder!A19)","v":"Lara Mustermann, geb. 01.10.2005"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A11),\"\",Infofelder!A11)&\":   \"&IF(ISBLANK(Infofelder!A12),\"\",Infofelder!A12)","v":"Zuständig:   Marie Louise Krankenstand-Müller"},null,null,null,null,"Bemerkungen"]
[{"$f":"IFERROR(INDIRECT(A1-1&\"!A5\"),0)","v":"00:00:00"},{"$f":"IFERROR(INDIRECT(A1-1&\"!B5\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!C5\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!D5\"),0)","v":0},true,false,null,30.3333333333333,null,null,null,false,null,null,{"$f":"ROUND((C5*D5+B5)*P25,0)","v":0},false,true,false]
[null," Persönliches Budget",null,null,null,null,null,"Leistungsnachweise",null,null,null,null,null,null,"Zahlungen",null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A5),\"\",Infofelder!A5)","v":"Blattschutz aufheben und/oder Änderungen machen, NUR nach Einweisung in die Funktion des Formulars!"}]
["Gültig ab:","Auslagen/M.","Stunden./M.","€ /Std.","Budget\npro Monat","kumuliert",null,"Âuslagen\n€ /Monat","Stunden h /Monat","Nachweis",null,null,"kumuliert",null,"Über-\nzahlung\n(Rot)","Vorschlag","Überweisung","kumuliert","Budget\nüberschritten\n(Rot)"]
[null,null,null,null,null,null,null,null,null,"Eingereicht","Kürzung","Akzeptiert"]
[]
["Saldovorträge aus",{"$f":"A1-1&\":\"","v":"2019:"},null,null,"     Tag-genau",{"$f":"IFERROR(INDIRECT(A1-1&\"!F23\"),0)","v":0},null,null,null,null,null,"     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!M23\"),0)","v":0},null,{"$f":"-R7+M7","v":0},"    Vorauszahlg.","     Budget-Clip",{"$f":"IFERROR(INDIRECT(A1-1&\"!r23\"),0)","v":0},null,null,"Bemerkungen zum Monat:"]
["November",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L20\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o20\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q20\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U20\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!V20\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W20\"),0)","v":0}]
["Dezember",null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!E21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!H21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!I21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!J21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!K21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!L21\"),0)","v":0},null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!o21\"),0)","v":0},null,{"$f":"IFERROR(INDIRECT(A1-1&\"!Q21\"),0)","v":0},null,null,null,{"$f":"IFERROR(INDIRECT(A1-1&\"!U21\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!V21\"),0)","v":0},{"$f":"IFERROR(INDIRECT(A1-1&\"!W21\"),0)","v":0}]
["Januar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"E10+F7","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D10),D5,D10)*I10,2)+H10","v":0},{"$f":"L10-J10","v":0},{"$f":"IF( AND(J10>E10,L2=TRUE),E10,J10)","v":0},{"$f":"L10+M7","v":0},31,{"$f":"M10-R10","v":0},{"$f":"IF( AND(L9=0,E9>0,Q2=TRUE),0,IF(Q2=FALSE,O10,IF(P2=TRUE,IF(T10>E10,E10,T10),T10))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+R7","v":0},{"$f":"F10-M10","v":0},{"$f":"E10+O7","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Februar",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F10+E11","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D11),D5,D11)*I11,2)+H11","v":0},0,{"$f":"IF( AND(J11>E11,L2=TRUE),E11,J11)","v":0},{"$f":"L10+L11+M7","v":0},{"$f":"IF(   ((A1-2000)/4)=ROUND( ((A1-2000)/4),0),29,28)","v":29},0,{"$f":"IF(AND(L10=0,E10>0,Q2=TRUE),0,IF(Q2=FALSE,O11,IF(P2=TRUE,IF(T11>E11,E11,T11),T11))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+R7","v":0},0,{"$f":"E11+O10","v":0},null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["März",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"F11+E12","v":0},true,null,null,{"$f":"ROUND(IF(ISBLANK(D12),D5,D12)*I12,2)+H12","v":0},0,{"$f":"IF( AND(J12>E12,L2=TRUE),E12,J12)","v":0},{"$f":"L10+L11+L12+M7","v":0},31,0,{"$f":"IF(AND(L11=0,E11>0,Q2=TRUE),0,IF(Q2=FALSE,O12,IF(P2=TRUE,IF(T12>E12,E12,T12),T12))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["April",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D13),D5,D13)*I13,2)+H13","v":0},0,{"$f":"IF( AND(J13>E13,L2=TRUE),E13,J13)","v":0},{"$f":"L10+L11+L12+L13+M7","v":0},30,0,{"$f":"IF(AND(L12=0,E12>0,Q2=TRUE),0,IF(Q2=FALSE,O13,IF(P2=TRUE,IF(T13>E13,E13,T13),T13))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Mai",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D14),D5,D14)*I14,2)+H14","v":0},0,{"$f":"IF( AND(J14>E14,L2=TRUE),E14,J14)","v":0},{"$f":"L10+L11+L12+L13+L14+M7","v":0},31,0,{"$f":"IF(AND(L13=0,E13>0,Q2=TRUE),0,IF(Q2=FALSE,O14,IF(P2=TRUE,IF(T14>E14,E14,T14),T14))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juni",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D15),D5,D15)*I15,2)+H15","v":0},0,{"$f":"IF( AND(J15>E15,L2=TRUE),E15,J15)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+M7","v":0},30,0,{"$f":"IF(AND(L14=0,E14>0,Q2=TRUE),0,IF(Q2=FALSE,O15,IF(P2=TRUE,IF(T15>E15,E15,T15),T15))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Juli",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D16),D5,D16)*I16,2)+H16","v":0},0,{"$f":"IF( AND(J16>E16,L2=TRUE),E16,J16)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+M7","v":0},31,0,{"$f":"IF(AND(L15=0,E15>0,Q2=TRUE),0,IF(Q2=FALSE,O16,IF(P2=TRUE,IF(T16>E16,E16,T16),T16))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["August",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D17),D5,D17)*I17,2)+H17","v":0},0,{"$f":"IF( AND(J17>E17,L2=TRUE),E17,J17)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+M7","v":0},31,0,{"$f":"IF(AND(L16=0,E16>0,Q2=TRUE),0,IF(Q2=FALSE,O17,IF(P2=TRUE,IF(T17>E17,E17,T17),T17))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["September",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D18),D5,D18)*I18,2)+H18","v":0},0,{"$f":"IF( AND(J18>E18,L2=TRUE),E18,J18)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+M7","v":0},30,0,{"$f":"IF(AND(L17=0,E17>0,Q2=TRUE),0,IF(Q2=FALSE,O18,IF(P2=TRUE,IF(T18>E18,E18,T18),T18))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Oktober",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D19),D5,D19)*I19,2)+H19","v":0},0,{"$f":"IF( AND(J19>E19,L2=TRUE),E19,J19)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+M7","v":0},31,0,{"$f":"IF(AND(L18=0,E18>0,Q2=TRUE),0,IF(Q2=FALSE,O19,IF(P2=TRUE,IF(T19>E19,E19,T19),T19))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["November",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D20),D5,D20)*I20,2)+H20","v":0},0,{"$f":"IF( AND(J20>E20,L2=TRUE),E20,J20)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+M7","v":0},30,0,{"$f":"IF(AND(L19=0,E19>0,Q2=TRUE),0,IF(Q2=FALSE,O20,IF(P2=TRUE,IF(T20>E20,E20,T20),T20))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
["Dezember",null,null,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK( INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))*IF(ISBLANK(INDEX(D:D,ROW())),D5,INDEX(D:D,ROW())))+IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},0,true,null,null,{"$f":"ROUND(IF(ISBLANK(D21),D5,D21)*I21,2)+H21","v":0},0,{"$f":"IF( AND(J21>E21,L2=TRUE),E21,J21)","v":0},{"$f":"L10+L11+L12+L13+L14+L15+L16+L17+L18+L19+L20+L21+M7","v":0},31,0,{"$f":"IF(AND(L20=0,E20>0,Q2=TRUE),0,IF(Q2=FALSE,O21,IF(P2=TRUE,IF(T21>E21,E21,T21),T21))+IF(R2=TRUE,O2,0))","v":0},null,{"$f":"Q10+Q11+Q12+Q13+Q14+Q15+Q16+Q17+Q18+Q19+Q20+Q21+R7","v":0},0,0,null,{"$f":"IF(INDEX(G:G,ROW())=TRUE,IF(ISBLANK(INDEX(B:B,ROW())),B5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(B:B,ROW())),0 )","v":0},{"$f":"IF(INDEX(G:G,ROW())=TRUE,(IF(ISBLANK(INDEX(C:C,ROW())),C5*IF(E2=TRUE,(1/H2)*INDEX(N:N,ROW()),1),INDEX(C:C,ROW()))))","v":0}]
[]
[{"$f":"\"Saldovorträge für \"&A1+1&\":\"&\"                                     Restbudget vortragen:\"","v":"Saldovorträge für 2021:                                     Restbudget vortragen:"},null,null,null,null,{"$f":"IF(F2=TRUE,S21,0)","v":0},null,null,null,null,null,null,{"$f":"IF(O21>0,O21,0)","v":0},null,null,{"$f":"\"      + \" & ROUND(O2,2)&\" € Finanzreserve\"","v":"      + 0 € Finanzreserve"},null,{"$f":"IF(O21<0,-O21,0)","v":0}]
[]
["Mittelwerte:",{"$f":"IFERROR(IF((SUM(B10:B21)/12)>0,SUM(B10:B21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(C10:C21, \"<>0\"),\"\")","v":""},null,{"$f":"IFERROR(AVERAGEIF(E10:E21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF((SUM(H10:H21)/12)>0,SUM(H10:H21)/12,\"\"),\"\")","v":""},{"$f":"IFERROR(AVERAGEIF(I10:I21, \"<>0\"),\"\")","v":""},null,null,{"$f":"IFERROR(AVERAGEIF(L10:L21, \"<>0\"),\"\")","v":""},null,null,"Finanzreserve =",0.05,{"$f":"IFERROR(AVERAGEIF(Q10:Q21, \"<>0\"),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Infofelder!A16),\"\",Infofelder!A16 & \" - \")  & \"Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Lara Mustermann - Leistungsnachweis für Dezember 2019"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"Lara Mustermann, geb. 01.10.2005"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J37+9","v":10},{"$f":"INDEX(A:A,J33-1)&\"  \"&J34","v":"Dezember  2019"},{"$f":"\"Saldo per \"&INDEX(A:A,J33-2)","v":"Saldo per November"},null,null,null,null,null,null,{"$f":"INDEX(O:O,J33-2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<11,A1-1,A1)","v":2019},null,{"$f":"\"      Zahlung für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Zahlung für Dezember 2019"},null,null,null,null,null,{"$f":"-INDEX(Q:Q,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(MATCH(30503.7362772129,Q9:Q21,1)-1=0,1,MATCH(30503.7362772129,Q9:Q21,1)-1)","v":1},null,{"$f":"\"Saldo nach Zahlung \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Zahlung Dezember 2019"},null,null,null,null,null,null,{"$f":"S33+R34","v":0}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(K55),J35,K55)","v":1},null,{"$f":"\"Leistungsnachweis \"&INDEX(A:A,J33-1)","v":"Leistungsnachweis Dezember"},null,null,null,"Sonderauslagen     Stunden",null,"Betrag"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Budgetlimit",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"ROUND(INDEX(V:V,J33-1),2)","v":0},{"$f":"ROUND(INDEX(W:W,J33-1),2)","v":0},{"$f":"INDEX(E:E,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Nachweis",null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},{"$f":"INDEX(H:H,J33-1)","v":0},{"$f":"INDEX(I:I,J33-1)","v":0},{"$f":"INDEX(J:J,J33-1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(L2=TRUE,R40<0),\"Kürzung\",\"\")","v":""},null,{"$f":"IF(AND(L2=TRUE,R40<0),\"(Wegen Budgetüberschreitung)\",\"\")","v":""},null,null,{"$f":"Q42-R39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33-1)","v":"Bemerkungen\nDezember"},{"$f":"IF(INDEX(U:U,J33-1)=0,\"\",INDEX(U:U,J33-1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"      Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"      Leistungsnachweis für Dezember 2019"},null,null,null,null,{"$f":"INDEX(L:L,J33-1)","v":0},null,{"$f":"Q42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Saldo nach Leist.nachweis \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Saldo nach Leist.nachweis Dezember 2019"},null,null,null,null,null,null,{"$f":"SUM(S35:S42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(A:A,J33)&\"  \"&J50","v":"Januar  2020"},null,"Budget",null,{"$f":"INDEX(A:A,J33)","v":"Januar"},null,null,null,{"$f":"INDEX(E:E,J33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," - Überzahlung",null,null,{"$f":"INDEX(A:A,J33-1)","v":"Dezember"},null,null,null,{"$f":"S43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R2=TRUE,\"+ Finanzreserve\",\"\")","v":""},null,null,null,null,null,null,{"$f":"ROUND(IF(R2=TRUE,O2,0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null," =",{"$f":"\"Ermittelte Vorauszahlung für \"&INDEX(A:A,J33)&\" \"&J50","v":"Ermittelte Vorauszahlung für Januar 2020"},null,null,null,null,null,{"$f":"ROUND(INDEX(P:P,J33),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Bemerkungen\n\"&INDEX(A:A,J33)","v":"Bemerkungen\nJanuar"},{"$f":"IF(INDEX(U:U,J33)=0,\"\",INDEX(U:U,J33))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(J33<10,A1-1,A1)","v":2020},null,{"$f":"\"      Überweisung für \"&INDEX(A:A,J33)&\" \"&J50","v":"      Überweisung für Januar 2020"},null,null,null,null,{"$f":"\"Differenz: \"","v":"Differenz: "},{"$f":"ROUND(S50-S48,2)","v":0},{"$f":"ROUND(INDEX(Q:Q,J33),2)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"\"Details zur Vorauszahlung \"&INDEX(A:A,J33)&\" \"&J50& \" und dem Leistungsnachweis für \"&INDEX(A:A,J33-1)&\" \"&J34","v":"Details zur Vorauszahlung Januar 2020 und dem Leistungsnachweis für Dezember 2019"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Dieses Feld leer lassen. \nDie Auswertung stellt sich dann automatisch auf den Monat mit der aktuelle Vorauszahlung ein.\nBei Bedarf eingeben (für Kontoabstimmung etc.): Die Nummer des Monats, in dem die Vorauszahlung stattfindet. \n1-12 = Monate des laufenden Jahres. 0 = Dezember des Vorjahres."]

{"sheet":"Infofelder","index":5,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,0,6,0],[4,2,6,2],[14,2,16,2],[17,2,19,2]]}
[]
["Zentrale Eingaben in die gelben Felder:"]
[]
["Folgender Text erscheint auf allen Budget-Tabellen rechts oben."]
["Blattschutz aufheben und/oder Änderungen machen, NUR nach Einweisung in die Funktion des Formulars!",null,"Texte zentral in das gelbe Feld links eingegeben, werden auf allen Budget-Tabellen der Mappe unterhalb der rechten Hauptüberschrift angezeigt."]
[]
[]
[]
[]
["Diese Eingaben erscheinen im Kopf aller Budget-Tabellen:",null,"Beispiel:"]
["Zuständig",null,"Sachbearbeitung"]
["Marie Louise Krankenstand-Müller",null,"Marie Louise Krankenstand-Müller"]
[]
[]
["Zu Fördernde Person",null,"Erscheint in der Titelzeile \n\n… und im Kopf des Ausdrucks mit den Details zum Leistungsnachweis und der Vorauszahlung."]
["Lara Mustermann"]
[]
["Geburtstag der zu fördernden Person",null,"Erscheint in der Titelzeile"]
["01.10.2005"]