{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Dashboard"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":1,"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":"Dashboard","index":0,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[12,1,13,1],[12,2,13,2],[12,3,12,5],[13,7,13,8],[34,1,35,1],[34,3,34,5]]}
[]
[null,"Dashboard"]
[]
[]
[]
[null,"Sachgebiet","Personalabteilung"]
[]
[]
[]
[]
[]
[]
[null,"Bezeichnung Oberthema","Bezeichnung Unterpunkte","Bewertungsprognose",null,null,"Tendenz"]
[null,null,null,"6 Monate","12 Monate","24 Monate","letzte Woche","Legende"]
[null,"Personal","Test A",5,1,2,{"$f":"IF(D37=\"\",\"\",D37)","v":5},1,"keine Einschränkungen"]
[null,"Personal","Test B",4,1,2,4,2,"beherrschbare Einschränkungen kein Handlungsbedarf "]
[null,{"$f":"IF(IFERROR(INDEX([1]Pivots!G:G,ROW(B3)+3),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!G:G,ROW(B3)+3),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!H:H,ROW(B3)+3),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!H:H,ROW(B3)+3),\"\"))","v":""},{"$f":"IF(D39=\"\",\"\",D39)","v":""},"","","",3,"relevante Einschränkungen vorhanden bzw. absehbar / möglich damit Handlungsbedarf "]
[null,{"$f":"IF(IFERROR(INDEX([1]Pivots!G:G,ROW(B4)+3),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!G:G,ROW(B4)+3),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!H:H,ROW(B4)+3),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!H:H,ROW(B4)+3),\"\"))","v":""},"","","","",4,"signifikante Einschränkungen daher Handlungsbedarf , Kenntnisnahme durch und mögl. Handlungsbedarf auf strategischer Ebene"]
[null,{"$f":"IF(IFERROR(INDEX([1]Pivots!G:G,ROW(B5)+3),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!G:G,ROW(B5)+3),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!H:H,ROW(B5)+3),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!H:H,ROW(B5)+3),\"\"))","v":""},"","","","",5,"derzeit keine Bewertung möglich"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entscheidungsmatrix",null,"Ergebnis - Übertrag"]
[null,null,"Vorwerte","6 Monate","12 Monate","24 Monate"]
[null,{"$f":"C15","v":"Test A"},4,{"$f":"IF(IFERROR(INDEX([1]Pivots!B:B,ROW(B1)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!B:B,ROW(B1)+4),\"\"))","v":5},{"$f":"IF(IFERROR(INDEX([1]Pivots!C:C,ROW(C1)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!C:C,ROW(C1)+4),\"\"))","v":1},{"$f":"IF(IFERROR(INDEX([1]Pivots!D:D,ROW(D1)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!D:D,ROW(D1)+4),\"\"))","v":2}]
[null,"Test B",2,{"$f":"IF(IFERROR(INDEX([1]Pivots!B:B,ROW(B2)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!B:B,ROW(B2)+4),\"\"))","v":4},{"$f":"IF(IFERROR(INDEX([1]Pivots!C:C,ROW(C2)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!C:C,ROW(C2)+4),\"\"))","v":1},{"$f":"IF(IFERROR(INDEX([1]Pivots!D:D,ROW(D2)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!D:D,ROW(D2)+4),\"\"))","v":2}]
[null,"",{"$f":"IFERROR(GETPIVOTDATA(\"Max. von Bewertung\",[1]Pivots!$L$3,\"Oberthema\",$B17,\"Unterthema\",$B39,\"Zeitraum (Monate)\",6),\"\")","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!B:B,ROW(B3)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!B:B,ROW(B3)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!C:C,ROW(C3)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!C:C,ROW(C3)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!D:D,ROW(D3)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!D:D,ROW(D3)+4),\"\"))","v":""}]
[null,"",{"$f":"IFERROR(GETPIVOTDATA(\"Max. von Bewertung\",[1]Pivots!$L$3,\"Oberthema\",$B18,\"Unterthema\",$B40,\"Zeitraum (Monate)\",6),\"\")","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!B:B,ROW(B4)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!B:B,ROW(B4)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!C:C,ROW(C4)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!C:C,ROW(C4)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!D:D,ROW(D4)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!D:D,ROW(D4)+4),\"\"))","v":""}]
[null,"",{"$f":"IFERROR(GETPIVOTDATA(\"Max. von Bewertung\",[1]Pivots!$L$3,\"Oberthema\",$B19,\"Unterthema\",$B41,\"Zeitraum (Monate)\",6),\"\")","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!B:B,ROW(B5)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!B:B,ROW(B5)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!C:C,ROW(C5)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!C:C,ROW(C5)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!D:D,ROW(D5)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!D:D,ROW(D5)+4),\"\"))","v":""}]
[null,0,{"$f":"IFERROR(GETPIVOTDATA(\"Max. von Bewertung\",[1]Pivots!$L$3,\"Oberthema\",$B20,\"Unterthema\",$B42,\"Zeitraum (Monate)\",6),\"\")","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!B:B,ROW(B6)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!B:B,ROW(B6)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!C:C,ROW(C6)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!C:C,ROW(C6)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!D:D,ROW(D6)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!D:D,ROW(D6)+4),\"\"))","v":""}]
[null,0,{"$f":"IFERROR(GETPIVOTDATA(\"Max. von Bewertung\",[1]Pivots!$L$3,\"Oberthema\",$B21,\"Unterthema\",$B43,\"Zeitraum (Monate)\",6),\"\")","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!B:B,ROW(B7)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!B:B,ROW(B7)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!C:C,ROW(C7)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!C:C,ROW(C7)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!D:D,ROW(D7)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!D:D,ROW(D7)+4),\"\"))","v":""}]
[null,0,{"$f":"IFERROR(GETPIVOTDATA(\"Max. von Bewertung\",[1]Pivots!$L$3,\"Oberthema\",$B22,\"Unterthema\",$B44,\"Zeitraum (Monate)\",6),\"\")","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!B:B,ROW(B8)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!B:B,ROW(B8)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!C:C,ROW(C8)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!C:C,ROW(C8)+4),\"\"))","v":""},{"$f":"IF(IFERROR(INDEX([1]Pivots!D:D,ROW(D8)+4),\"\")=0,\"\",IFERROR(INDEX([1]Pivots!D:D,ROW(D8)+4),\"\"))","v":""}]