{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Tabelle1","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[2,1,2,4],[19,1,21,1],[4,1,4,2],[4,3,4,4],[10,4,11,4],[12,4,13,4],[15,4,17,4],[18,4,20,4],[23,1,27,2],[10,3,11,3],[16,3,17,3],[19,3,20,3]]}
[]
[]
[null,"Personalbedarfsrechnung"]
[]
[null,"Zahlen der Vorperiode",null,"Planungsperiode"]
[null,"Umsatz in €",1500000,"Umsatzprognose"]
[null,"Mitarbeiterzahl",30,"Wachstumsprognose in %",6]
[null,"Umsatz pro Mitarbeiter",{"$f":"C6/C7","v":50000},"Umsatzplanung",{"$f":"C6+(C6*E7/100)","v":1590000}]
[null,null,null,"Wachstumsbedarf",{"$f":"ROUND((E8/C8)-C7,1)","v":1.8}]
[null,null,null,"Strukurelle Veränderungen"]
[null,null,null,"Innovationsbedarf (Produktentwicklung, neue Produktionsverfahren, ...)",4]
[]
[null,null,null,"Personalfreisetzung",2]
[null,null,null,"(Rationalisierung, Outsourcing, ... )"]
[null,null,null,"Fluktuation"]
[null,null,null,"Mitarbeiterabgang",2]
[null,null,null,"(Kündigung, Mutterschutz, Erziehungs- zeit, Entlassungen, Pensionierungen, ...)"]
[]
[null,null,null,"Mitarbeiterzugang",1]
[null,"quantitativer Personalbedarf",null,"(Bundeswehr/Zivildienst, Mutterschutz, Auszubildende, ... )"]
[]
[null,null,null,"Personalbedarf",{"$f":"E9+E11-E13+E16-E19","v":4.8}]
[]
[null,"Der Wachstumsbedarf wird nach der \"Kennzahlen-Methode\" ermittelt. (Personalfreisetzung und Mitarbeiterabgang dürfen nicht größer als die bisherige Mitarbeiterzahl sein.)"]

{"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":[]}