{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Cover","Einfache BSC","Gesamt","Finanzen","Kunden","Prozesse","Lernen & Entwicklung"],"not_rendered":{"charts":1,"images":0,"macros":1,"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",8]
[null,"Thema","Strategisches Prozess-Controlling"]
[]
[null,"Inhalt","Balanced Score Card"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Einfache BSC","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,0,13,0],[0,0,0,1],[0,2,0,3],[0,4,0,5],[2,0,3,0],[4,0,6,0],[7,0,10,0]]}
["Strategie",null,"Balanced Score Card",null,"Aktionsplan"]
["Perspektiven","Ziele","Kennzahl","Vorgabe","Initiative","Zeitraum"]
["Finanzen","Umsatz steigern","Umsatzanteil neuer Kunden",0.2,"Werbung","3 Monate"]
[null,"Kosten reduzieren","Fehlmengen",0.15,"Werkzeuge"]
["Kunden","Kunden binden","Anzahl Kundenkarten",50,"Kundenprogramm","Jahr"]
[null,"Neue Kunden gewinnen","Anteil Neuzugänge",5,"Ausstellung","2 / Jahr"]
[null,"Kundenservice optimieren","Anzahl Beschwerden",0.02,"Qualitätsmanagement"]
["Intern","Ausschuss verringern","Anteil der Fehlmengen",0.05,"Qualitätsmanagement"]
[null,"Vorschläge fördern","Reaktionszeit","1 Woche","Verantwortlicher"]
[null,"Prozesse ausweiten","Anzahl Prozesse",2,"Prozesse umstellen","Jahr"]
[null,"Produktpalette erweitern","Umsatzanteil Innovation",0.1,"Investition","6 Monate"]
["Potential","Beziehung zu den Kunden","Mitarbeiterwechsel","2-5 Jahre","Mitarbeiterbindung"]
[null,"Produktinfos erweitern","Umsatzanteil durch Infos",0.15,"Informationen erweitern","3 Monate"]
[null,"Mitarbeiterverantwortung","Anzahl Teammeetings","2 / Woche","flache Hierarchie","Jahr"]
["Lieferanten","Strategische Partnerschaft","Umsatzanteil",0.1,"Lieferanalyse","3 Monate"]
["Bank","Vertrauensverhältnis","Anzahl Meetings","1 / Monat","Finanzplan","Monat"]

{"sheet":"Gesamt","index":2,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[0.65979925303454712,0.88168534080298788,0.96063492063492051,1.063251633986928]
[0.8174808429118775,0.9375,1.0407088122605366,0.94770114942528738]
[0.93956916099773236,0.90691609977324261,0.97616213151927433,0.99027777777777781]
[0.67375478927203059,0.88749999999999996,0.94846743295019154,0.91762452107279702]

{"sheet":"Finanzen","index":3,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["FINANZEN"]
["Strategisches Ziel","Kennzahl","Einheit","Toleranz \nunten","Zielwert","Q1","Q2","Q3","Q4"]
["Return of Investment steigern","Return of Invest","%",11,14,9,13,15,16.100000000000001]
["Umsatz erhöhen","Umsatzsteigerung zum Vorjahr","%",2,10.199999999999999,9.8000000000000007,10,10.199999999999999,9.8000000000000007]
["Deckungsbeitrag erhöhen","Durchschnitt Deckungsbetrag je Kunde","Euro",70,90,50,70,91,101]
["Cashflow verbessern","Durchschnitt Cashflow","Euro",20000,25000,12000,21000,19000,25500]

{"sheet":"Kunden","index":4,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["KUNDEN "]
["Strategisches Ziel","Kennzahl","Einheit","Toleranz \nunten","Zielwert","Q1","Q2","Q3","Q4"]
["Kundenzufriedenheit verbessern","Kundenzufriedenheit","Score",5,5.8,5.4,5.8,6.1,4.2]
["Empfehlungen ausweiten","Empfehlungen/Kunde","Anzahl",3,4,3,4,5,4]
["Anteil Neukunden erhöhen","Bestellungen Neukunden / Bestellungen","%",15,20,10,15,19,22]
["Beschwerdemanagement verbessern","Erfolgreich bearbeitete Beschwerden","%",85,90,98,90,82,87]

{"sheet":"Prozesse","index":5,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["PROZESSE"]
["Strategisches Ziel","Kennzahl","Einheit","Toleranz \nunten","Zielwert","Q1","Q2","Q3","Q4"]
["Qualität verbessern","Anzahl nicht-fehlerhafter Produkte","%",94,98,95,92,99,98]
["Prozessabläufe beschleunigen","Auftragsbearbeitung geringer als 5 Tage","%",80,90,92,85,89,91]
["Anzahl neuer Produkte erhöhen","Anzahl Produkte jünger als ein Jahr","%",10,20,12,16,17,19]
["Leistung Kernprozesse verbessern","Durchschnitt bearbeitete Bestellungen / Tag","Anzahl",1.5,1.8,2.1,1.7,1.9,1.8]

{"sheet":"Lernen & Entwicklung","index":6,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["LERNEN & ENTWICKLUNG"]
["Strategisches Ziel","Kennzahl","Einheit","Toleranz \nunten","Zielwert","Q1","Q2","Q3","Q4"]
["technische Infrastruktur aufbauen","Erfolreich abgeschl. Projekte zur Infrastrktur","Anzahl",3,5,2,4,5,5]
["Kompetenz der Mitarbeiter erweitern","Summe Schulungstage","Anzahl",70,90,100,90,70,65]
["Betriebsklima verbessern","Betriebsklima","Score",5,5.8,5.9,5.8,5.7,5.5]
["Aktivitäten zur kontinuierlichen\nVerbesserung erhöhen (KVP)","Durchschnitt KVP-Maßnahmen","Anzahl",20,60,10,45,62,60]