{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Berechnung"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":1,"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":"Berechnung","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,1,50,5],[51,1,51,5],[41,1,41,5],[42,1,42,5],[0,0,0,6],[24,1,24,5],[25,1,25,5],[28,1,28,5],[1,1,1,5],[45,1,45,5]]}
[]
[null,"Berechnung der Arbeitszeit bei geringfügiger Beschäftigung"]
[]
[]
[null,"Entgeltgruppe",null,3,{"$nulls":4},"Bei Tarifänderungen bitte hier anpassen!"]
[]
[null,"Leistungsentgelt",null,15,"in %",{"$f":"D7/100*(VLOOKUP(D5,I8:J23,2))","v":291.52499999999998},null,null,"EG","Grundentgelt"]
[{"$nulls":8},2,1846.5]
[null,"Belastungszulage",null,2.5,"in %",{"$f":"D9/100*J13","v":60.737500000000004},null,null,3,1943.5]
[{"$nulls":8},4,2041]
[null,"Freiwillige Zulage ",{"$nulls":6},5,2162.5]
[null,"(monatlich)",null,0,{"$nulls":4},6,2284]
[{"$nulls":8},7,2429.5]
[null," Zuschläge",null,20,"in %",{"$f":"D14/100*(VLOOKUP(D5,I8:J23,2))","v":388.70000000000005},null,null,8,2599.5]
[{"$nulls":8},9,2770]
[null,"Vermögens-Altersvorsorge-wirksame Leistung",null,"ja",null,{"$f":"IF(D16=\"\",\"\",(IF(D16=\"ja\",26.59,\"0\")))","v":26.59},null,null,10,2952]
[{"$nulls":8},11,3146.5]
[null,"Urlaubsanspruch",null,30,"in Tage",{"$f":"D18/21.75*0.5*(VLOOKUP(D5,I8:J23,2)+F7+F9+D12+F14)","v":1851.3534482758625},null,null,12,3365]
[{"$nulls":8},13,3583.5]
[null,"betriebliche Sonderzahlung",null,55,"in %",{"$f":"D20/100*(F7+F9+F14+D12+VLOOKUP(D5,I8:J23,2))","v":1476.4543750000003},null,null,14,3802.5]
[{"$nulls":8},15,4021]
[null,"sonst. Zahlungen (Ergebnisbet. usw.) ",{"$nulls":6},16,4288.5]
[null,"wenn anteilig",{"$nulls":6},17,4531]
[]
[null,"Monatlich zu leistende Arbeitsstunden:"]
[null,{"$f":"400/((((VLOOKUP(D5,I8:J23,2)+F7+F9+D12+F14+F16)*12+F18+F20+D23)/12/4.35)/35)","v":20.379003837082571}]
[]
[]
[null,"Weitere  zu berücksichtigende Leistungen:"]
[]
[null,"sonst.  Zahlungen (Ergebnisbeteiligung, usw.)  "]
[]
[null,"Essenszuschuss (entsprechend Arbeitstagen) € Gesamt / Tage"]
[]
[{"$nulls":4},"Arbeitstage"]
[]
[null,"Gesamtsumme",null,null,null,{"$f":"D37/21.75*D35","v":0}]
[]
[null,"Fahrgeld (entsprechend Arbeitstagen)"]
[null,"Gesamtsumme",null,null,null,{"$f":"D40/21.75*D35","v":0}]
[]
[null,"Monatliche Arbeitstunden mit zusätzlichen Leistungen"]
[null,{"$f":"(400-D31-F37-F40)/((((VLOOKUP(D5,I8:J23,2)+F7+F9+D12+F14+F16)*12+F18+F20+D23)/12/4.35)/35)","v":20.379003837082571}]
[]
[]
[null,"Zu berücksichtigende Einmalzahlungen"]
[]
[null,"Jubiläumszulage, Einmalzahlungen"]
[]
[]
[null,"Zu leistende Arbeitsstunden im Monat der Auszahlung"]
[null,{"$f":"(400-D31-F37-F40-D48)/((((VLOOKUP(D5,I8:J23,2)+F7+F9+D12+F14+F16)*12+F18+F20+D23)/12/4.35)/35)","v":20.379003837082571}]
["erstellt durch Ortsfrauenausschuss der IG Metall Schwäbisch Hall",{"$nulls":4},"2008-06-01"]