{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Tabelle1","index":0,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Beispiel einer Personalberechnung im Rahmen der Ausgabenbasis:"]
[]
["Personalberechnung Herrn Mustermann:"]
[]
["Nettojahresarbeitszeit",null,1650,"Std. (max.für eine Ganztagskraft)"]
["Monatliche Nettoarbeitszeit",null,{"$f":"ROUND(C10/12,2)","v":137.5},"Std. (1650/12) "]
[]
[]
["Abrechnung Jahr 20XX:"]
["Monat","Gehalt","monatl. Nettoarbeitzeit","monatlicher Std. Satz","geleistete Std.\nlt. Stundenzettel (Dezimal)","Personalausgaben (max. das gezahlte reguläre Monatsgehalt)","Übertrag ins Virtuelle Konto"]
["Januar",5000,{"$f":"$C$11","v":137.5},{"$f":"ROUND(B16/C16,2)","v":36.36},50,{"$f":"IF((D16*E16)<=B16,(D16*E16),B16)","v":1818},{"$f":"IF(E16<=C16,\"\",(E16-C16))","v":""}]
["Februar",5000,{"$f":"$C$11","v":137.5},{"$f":"ROUND(B17/C17,2)","v":36.36},50.5,{"$f":"IF((D17*E17)<=B17,(D17*E17),B17)","v":1836.18},{"$f":"IF(E17<=C17,\"\",(E17-C17))","v":""}]
["März",5000,137.5,36.36,50.75,1845.27,""]
["April",5000,137.5,36.36,60,2181.6,""]
["Mai",5000,137.5,36.36,65,2363.4,""]
["Juni",5000,137.5,36.36,70.5,2563.38,""]
["Juli",5000,137.5,36.36,80.5,2926.98,""]
["August",5000,137.5,36.36,99.25,3608.73,""]
["September",5000,137.5,36.36,100.75,3663.27,""]
["Oktober",5000,137.5,36.36,160,{"$f":"IF((D25*E25)<=B25,(D25*E25),B25)","v":5000},22.5]
["November",5000,137.5,36.36,180,5000,42.5]
["Dezember",5000,137.5,36.36,130,4726.8,""]
["Gesamt:",null,{"$f":"SUM(C16:C27)","v":1650},{"$f":"SUM(D16:D27)/12","v":36.360000000000007},{"$f":"SUM(E16:E27)","v":1097.25},{"$f":"SUM(F16:F27)","v":37533.61},{"$f":"SUM(G16:G27)","v":65}]
[]
[]
["Berechnung Jahressonderzahlung (als separate Zeile in der Belegliste aufführen):"]
["Berechnung Weihnachtsgeld:","Gesamtgehalt Nov. ","reguläres monatl. Gehalt","Differenz = Weihnachtsgeld","Weihnachtsgeld/1650","multipliziert mit allen abgerechneten Std. pro Jahr"]
["November",7000,5000,{"$f":"B33-C33","v":2000},{"$f":"ROUND(D33/C10,2)","v":1.21},{"$f":"(E28*E33)","v":1327.6724999999999}]
[]
[]
["Ausgleich virtuelles Konto (als separate Zeile in der Belegliste aufführen):"]
["Guthaben virtuelles Konto","durchschnittlicher Stundensatz","multipliziert mit den Stunden gemäß virtuellem Konto"]
[{"$f":"G28","v":65},{"$f":"D28","v":36.360000000000007},{"$f":"A38*B38","v":2363.4000000000005}]

{"sheet":"Tabelle2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}