{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Matrix"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",7]
[null,"Thema","Strategisches Prozess-Controlling"]
[]
[null,"Inhalt","KPI Reporting Matrix"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-26"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Matrix","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Metrik","Team","Reporting\nFrequenz","Status","Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug"]
[{"$f":"LINEST(F2:M2)","v":70.80952380952381},"Einnahmen","A ","monatl.","Ist",2600,2604,2740,2812,2860,2900,2960,3120]
[null,null,null,null,"Soll",2533,2610,2687,2768,2851,2937,2955,3050]
[{"$f":"LINEST(F4:M4)","v":73.607142857142861},"Kosten","B","monatl.","Ist",2213,2314,2401,2430,2511,2612,2670,2740]
[null,null,null,null,"Soll",2443,2413,2486,2560,2637,2716,2750,2808]
[{"$f":"LINEST(F6:M6)","v":-7.4936507936507937E-3},"Reingewinn","C","monatl.","Ist",0.17499999999999999,0.125,0.14099999999999999,0.157,0.13900000000000001,0.111,0.115,0.10764761904761901]
[null,null,null,null,"Soll",8.1000000000000003E-2,8.1000000000000003E-2,8.1000000000000003E-2,8.1000000000000003E-2,8.1000000000000003E-2,8.1000000000000003E-2,8.1000000000000003E-2,8.1000000000000003E-2]
[{"$f":"LINEST(F8:M8)","v":0.53690476190476222},"Lieferzeit","D ","monatl.","Ist",30,30.3,29.5,30.1,31.3,33.5,32.200000000000003,33.200000000000003]
[null,null,null,null,"Soll",30,30,30,30,30,30,30,30]
[{"$f":"LINEST(F10:M10)","v":1.6428571428571431E-2},"%-Anteil Direktverkauf","E","monatl.","Ist",0.35,0.47,0.53,0.49,0.35,0.61,0.53,0.49]
[null,null,null,null,"Soll",0.67,0.67,0.67,0.67,0.67,0.67,0.67,0.67]
[{"$f":"LINEST(F12:M12)","v":34.702380952380949},"Interne Kosten/Kunde","F","monatl.","Ist",7508,7636,7735,7766,7676,7725,7788,7833]
[null,null,null,null,"Soll",7500,7500,7500,7500,7500,7500,7500,7500]
[{"$f":"LINEST(F14:M14)","v":-172.08333333333334},"Wartungskosten/Kunde","G","monatl.","Ist",14900,14950,14878,14570,14004,14325,14002,13830]
[null,null,null,null,"Soll",14500,14500,14500,14500,14500,14500,14500,14500]