{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Berechnung"],"not_rendered":{"external_links":1,"defined_names":1,"comments":6},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Berechnung","index":0,"n_rows":53,"n_cols":10,"rows_kept":53,"merged":[[0,0,0,6],[1,1,1,5],[24,1,24,5],[25,1,25,5],[28,1,28,5],[41,1,41,5],[42,1,42,5],[45,1,45,5],[50,1,50,5],[51,1,51,5]],"flags":["formulas_cached_only"]}
[]
[null,"Berechnung der Arbeitszeit bei geringfügiger Beschäftigung"]
[]
[]
[null,"Entgeltgruppe",null,4,{"$nulls":4},"Bei Tarifänderungen bitte hier anpassen!"]
[]
[null,"Leistungsentgelt",null,15,"in %",{"v":373.34999999999997,"d":"373.35 €"},null,null,"EG","Grundentgelt"]
[{"$nulls":8},2,{"v":2252,"d":"2,252.00 €"}]
[null,"Belastungszulage",null,null,"in %",0,null,null,3,{"v":2370.5,"d":"2,370.50 €"}]
[{"$nulls":8},4,{"v":2489,"d":"2,489.00 €"}]
[null,"Freiwillige Zulage ",{"$nulls":6},5,{"v":2637,"d":"2,637.00 €"}]
[null,"(monatlich)",null,0,{"$nulls":4},6,{"v":2785,"d":"2,785.00 €"}]
[{"$nulls":8},7,{"v":2963,"d":"2,963.00 €"}]
[null," Zuschläge",null,null,"in %",0,null,null,8,{"v":3170.5,"d":"3,170.50 €"}]
[{"$nulls":8},9,{"v":3377.5,"d":"3,377.50 €"}]
[null,"Vermögens-Altersvorsorge-wirksame Leistung",null,"ja",null,{"v":26.59,"d":"26.59 €"},null,null,10,{"v":3600,"d":"3,600.00 €"}]
[{"$nulls":8},11,{"v":3837,"d":"3,837.00 €"}]
[null,"Urlaubsanspruch",null,30,"in Tage",{"v":1974.0344827586207,"d":"1,974.03 €"},null,null,12,{"v":4103.5,"d":"4,103.50 €"}]
[{"$nulls":8},13,{"v":4370.5,"d":"4,370.50 €"}]
[null,"betriebliche Sonderzahlung",null,55,"in %",{"v":1574.2925,"d":"1,574.29 €"},null,null,14,{"v":4637,"d":"4,637.00 €"}]
[{"$nulls":8},15,{"v":4903.5,"d":"4,903.50 €"}]
[null,"sonst. Zahlungen (Ergebnisbet. usw.) ",{"$nulls":6},16,{"v":5229.5,"d":"5,229.50 €"}]
[null,"wenn anteilig",null,0,{"$nulls":4},17,{"v":5526,"d":"5,526.00 €"}]
[]
[null,"Monatlich zu leistende Arbeitsstunden:"]
[null,{"v":21.51346177416262,"d":"21.51"}]
[]
[]
[null,"Weitere  zu berücksichtigende Leistungen:"]
[]
[null,"sonst.  Zahlungen (Ergebnisbeteiligung, usw.)  "]
[]
[null,"Essenszuschuss (entsprechend Arbeitstagen) € Gesamt / Tage"]
[]
[{"$nulls":4},"Arbeitstage"]
[]
[null,"Gesamtsumme",{"$nulls":3},0]
[]
[null,"Fahrgeld (entsprechend Arbeitstagen)"]
[null,"Gesamtsumme",{"$nulls":3},0]
[]
[null,"Monatliche Arbeitstunden mit zusätzlichen Leistungen"]
[null,{"v":21.51346177416262,"d":"21.51"}]
[]
[]
[null,"Zu berücksichtigende Einmalzahlungen"]
[]
[null,"Jubiläumszulage, Einmalzahlungen"]
[]
[]
[null,"Zu leistende Arbeitsstunden im Monat der Auszahlung"]
[null,{"v":21.51346177416262,"d":"21.51"}]
["erstellt durch Ortsfrauenausschuss der IG Metall Schwäbisch Hall",{"$nulls":4},"2015-04-01"]