{"text_format":"2","workbook":"xls","n_sheets":8,"sheets":["Fertigung_Ges","Maschine 1","Maschine 2","Maschine 1_Std","Maschine 2_Std","Ges_Std","H_Faktor","Tabelle1"],"not_rendered":{"charts":3,"images":3,"macros":0,"external_links":1,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Fertigung_Ges","index":0,"n_rows":78,"n_cols":25,"rows_kept":78,"cut":false,"hidden":false,"merged":[[2,0,2,12],[3,0,3,12],[0,0,1,0]],"flags":["formulas_cached_only"]}
["Datum: 15.10.2011"]
[]
["Kapazitätsauslastung"]
["Fertigung Gesamt"]
[]
[]
[]
[]
[null,"Oktr 11\nKW 40-43","Nov 11\nKW 44-48","Dez 11\nKW 49 -52","Jan 12\nKW 01-04"]
["Verfügbare Kapazität",201.6,252,239.4,226.79999999999998,214.2,239.4,264.59999999999997,163.79999999999998,264.6,270.9,245.7,233.09999999999997,233.1,252,226.8,264.59999999999997,220.5,258.29999999999995,270.9,214.2,264.6,270.9,252,233.09999999999997]
["Kapazitätsbelegung",160,125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Auslastung %",0.7936507936507937,0.49603174603174605,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Über-/Unterbelegung (-)",-41.599999999999994,-127,-239.4,-226.79999999999998,-214.2,-239.4,-264.59999999999997,-163.79999999999998,-264.6,-270.9,-245.7,-233.09999999999997,-233.1,-252,-226.8,-264.59999999999997,-220.5,-258.29999999999995,-270.9,-214.2,-264.6,-270.9,-252,-233.09999999999997]
["Kapazitätsbelegung mit Projekten",160,125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Auslastung % mit Projekten",0.7936507936507937,0.49603174603174605,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Über-/Unterbelegung (-) m. Projekten",-41.599999999999994,-127,-239.4,-226.79999999999998,-214.2,-239.4,-264.59999999999997,-163.79999999999998,-264.6,-270.9,-245.7,-233.09999999999997,-233.1,-252,-226.8,-264.59999999999997,-220.5,-258.29999999999995,-270.9,-214.2,-264.6,-270.9,-252,-233.09999999999997]
{"$rows_empty":46}
["Kapazitätsangebot für Fertigung Gesamt"]
[]
["Monate",2011,2011,2011,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012]
[null,"Oktober","November","Dezember","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Januar","Februar","März","April","Mai","Juni","Juli","August","September"]
["Anzahl MA",2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["Leiharbeiter Std.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["-- Urlaubsstunden",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["verfügbarer Kapazitätsbestand gesamt",201.6,252,239.4,226.79999999999998,214.2,239.4,264.59999999999997,163.79999999999998,264.6,270.9,245.7,233.09999999999997,233.1,252,226.8,264.59999999999997,220.5,258.29999999999995,270.9,214.2,264.6,270.9,252,233.09999999999997]
{"$rows_empty":7}
["Verteiler:"]

{"sheet":"Maschine 1","index":1,"n_rows":89,"n_cols":25,"rows_kept":89,"cut":false,"hidden":false,"merged":[[93,3,93,5],[0,0,1,0],[92,8,92,12],[2,0,2,12],[3,0,3,12]],"flags":["formulas_cached_only"]}
["Datum: 15.10.2011"]
[]
["Kapazitätsauslastung"]
["Maschine 1"]
[]
[]
[]
[]
[null,"Oktr 11\nKW 40-43","Nov 11\nKW 44-48","Dez 11\nKW 49 -52","Jan 12\nKW 01-04"]
["Verfügbare Kapazität",100.8,126,119.7,113.39999999999999,107.1,119.7,132.29999999999998,81.89999999999999,126,132.29999999999998,119.7,100.8,107.1,119.7,107.1,132.29999999999998,100.8,126,126,81.89999999999999,126,132.29999999999998,126,100.8]
["Kapazitätsbelegung",160,125,0,0,0,0,0,0,0,0,0,0,0]
["Auslastung %",1.5873015873015874,0.9920634920634921,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Über-/Unterbelegung (-)",59.2,-1,-119.7,-113.39999999999999,-107.1,-119.7,-132.29999999999998,-81.89999999999999,-126,-132.29999999999998,-119.7,-100.8,-107.1,-119.7,-107.1,-132.29999999999998,-100.8,-126,-126,-81.89999999999999,-126,-132.29999999999998,-126,-100.8]
["Kapazitätsbelegung mit Projekten",160,125,0,0,0,0,0,0,0,0,0,0,0]
["Auslastung % mit Projekten",1.5873015873015874,0.9920634920634921,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Über-/Unterbelegung (-) m. Projekten",59.2,-1,-119.7,-113.39999999999999,-107.1,-119.7,-132.29999999999998,-81.89999999999999,-126,-132.29999999999998,-119.7,-100.8,-107.1,-119.7,-107.1,-132.29999999999998,-100.8,-126,-126,-81.89999999999999,-126,-132.29999999999998,-126,-100.8]
{"$rows_empty":46}
["Kapazitätsangebot für Maschine 1"]
[]
["Monate",2011,2011,2011,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012]
[null,"Oktober","November","Dezember","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Januar","Februar","März","April","Mai","Juni","Juli","August","September"]
["Anzahl MA",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Langzeitkrank",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["anwesende Mitarbeiter",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Arbeitstage pro Monat",20,21,19,20,19,21,23,21,22,22,20,21,20,21,19,21,19,21,23,21,22,22,20,21]
["./. Statistische Urlaubsverteilung",4,1,0,2,2,2,2,8,2,1,1,5,3,2,2,0,3,1,3,8,2,1,0,5]
["Arbeitstage pro Monat / netto",16,20,19,18,17,19,21,13,20,21,19,16,17,19,17,21,16,20,20,13,20,21,20,16]
["Verfügbarer Kap_Bestand pro MA/Monat",100.8,126,119.7,113.39999999999999,107.1,119.7,132.29999999999998,81.89999999999999,126,132.29999999999998,119.7,100.8,107.1,119.7,107.1,132.29999999999998,100.8,126,126,81.89999999999999,126,132.29999999999998,126,100.8]
["Verfügbarer Kap_Bestand gesamt",100.8,126,119.7,113.39999999999999,107.1,119.7,132.29999999999998,81.89999999999999,126,132.29999999999998,119.7,100.8,107.1,119.7,107.1,132.29999999999998,100.8,126,126,81.89999999999999,126,132.29999999999998,126,100.8]
["Leiharbeiter Std."]
["-- Urlaubsstunden"]
["verfügbarer Kapazitätsbestand gesamt",100.8,126,119.7,113.39999999999999,107.1,119.7,132.29999999999998,81.89999999999999,126,132.29999999999998,119.7,100.8,107.1,119.7,107.1,132.29999999999998,100.8,126,126,81.89999999999999,126,132.29999999999998,126,100.8]
[]
[]
[{"$nulls":4}," "]
{"$rows_empty":8}
["Verteiler: "]

{"sheet":"Maschine 2","index":2,"n_rows":88,"n_cols":25,"rows_kept":88,"cut":false,"hidden":false,"merged":[[2,0,2,12],[3,0,3,12],[0,0,1,0]],"flags":["formulas_cached_only"]}
["Datum: 15.10.2011"]
[]
["Kapazitätsauslastung"]
["Schleifen Bohren Montieren"]
[]
[]
[]
[]
[null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Verfügbare Kapazität",100.8,126,119.7,113.39999999999999,107.1,119.7,132.29999999999998,81.89999999999999,138.6,138.6,126,132.29999999999998,126,132.29999999999998,119.7,132.29999999999998,119.7,132.29999999999998,144.9,132.29999999999998,138.6,138.6,126,132.29999999999998]
["Kapazitätsbelegung",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Auslastung %",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Über-/Unterbelegung (-)",-100.8,-126,-119.7,-113.39999999999999,-107.1,-119.7,-132.29999999999998,-81.89999999999999,-138.6,-138.6,-126,-132.29999999999998,-126,-132.29999999999998,-119.7,-132.29999999999998,-119.7,-132.29999999999998,-144.9,-132.29999999999998,-138.6,-138.6,-126,-132.29999999999998]
["Kapazitätsbelegung mit Projekten",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Auslastung % mit Projekten",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Über-/Unterbelegung (-) m. Projekten",-100.8,-126,-119.7,-113.39999999999999,-107.1,-119.7,-132.29999999999998,-81.89999999999999,-138.6,-138.6,-126,-132.29999999999998,-126,-132.29999999999998,-119.7,-132.29999999999998,-119.7,-132.29999999999998,-144.9,-132.29999999999998,-138.6,-138.6,-126,-132.29999999999998]
{"$rows_empty":46}
["Kapazitätsangebot für Maschine 2"]
[]
["Monate",2011,2011,2011,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012,2012]
[null,"Oktober","November","Dezember","Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Januar","Februar","März","April","Mai","Juni","Juli","August","September"]
["Anzahl MA",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Langzeitkrank",0,0,0,0,0,0,0,0]
["anwesende Mitarbeiter",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
["Arbeitstage pro Monat",20,21,19,20,19,21,23,21,22,22,20,21,20,21,19,21,19,21,23,21,22,22,20,21]
["./. Statistische Urlaubsverteilung",4,1,0,2,2,2,2,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Arbeitstage pro Monat / netto",16,20,19,18,17,19,21,13,22,22,20,21,20,21,19,21,19,21,23,21,22,22,20,21]
["Verfügbarer Kap_Bestand pro MA/Monat",100.8,126,119.7,113.39999999999999,107.1,119.7,132.29999999999998,81.89999999999999,138.6,138.6,126,132.29999999999998,126,132.29999999999998,119.7,132.29999999999998,119.7,132.29999999999998,144.9,132.29999999999998,138.6,138.6,126,132.29999999999998]
["Verfügbarer Kap_Bestand gesamt",100.8,126,119.7,113.39999999999999,107.1,119.7,132.29999999999998,81.89999999999999,138.6,138.6,126,132.29999999999998,126,132.29999999999998,119.7,132.29999999999998,119.7,132.29999999999998,144.9,132.29999999999998,138.6,138.6,126,132.29999999999998]
["Leiharbeiter Std."]
["-- Urlaubsstunden"]
["verfügbarer Kapazitätsbestand gesamt",100.8,126,119.7,113.39999999999999,107.1,119.7,132.29999999999998,81.89999999999999,138.6,138.6,126,132.29999999999998,126,132.29999999999998,119.7,132.29999999999998,119.7,132.29999999999998,144.9,132.29999999999998,138.6,138.6,126,132.29999999999998]
{"$rows_empty":10}
["Verteiler: "]

{"sheet":"Maschine 1_Std","index":3,"n_rows":63,"n_cols":109,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,101,6,104],[6,105,6,108],[61,11,61,15],[62,11,62,15],[6,83,6,87],[6,88,6,91],[6,92,6,95],[6,96,6,100],[6,66,6,69],[6,70,6,74],[6,75,6,78],[6,79,6,82],[6,51,6,54],[6,55,6,57],[6,58,6,61],[6,62,6,65],[6,33,6,36],[6,37,6,41],[6,42,6,45],[6,46,6,50],[6,11,6,15],[6,16,6,19],[6,20,6,23],[6,24,6,28],[61,16,61,19],[62,7,62,10],[62,58,62,61],[62,42,62,45],[62,37,62,41],[62,33,62,36],[62,29,62,32],[62,24,62,28],[62,20,62,23],[62,16,62,19],[67,105,67,106],[62,62,62,65],[62,66,62,69],[62,70,62,74],[62,75,62,78],[62,79,62,82],[62,83,62,87],[61,46,61,50],[61,51,61,54],[61,55,61,57],[62,46,62,50],[62,51,62,54],[62,55,62,57],[6,7,6,10],[61,37,61,41],[61,42,61,45],[61,24,61,28],[61,29,61,32],[61,33,61,36],[61,7,61,10],[61,20,61,23],[6,6,7,6],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[6,29,6,32],[61,66,61,69],[61,70,61,74],[61,75,61,78],[61,79,61,82],[61,83,61,87],[61,88,61,91],[61,58,61,61],[61,62,61,65],[61,92,61,95],[61,96,61,100],[62,88,62,91],[61,101,61,104],[61,105,61,108],[62,92,62,95],[62,96,62,100],[62,101,62,104],[62,105,62,108]],"flags":["formulas_cached_only"]}
[]
["Fertigungsauslastung Maschine 1"]
[]
["Datum: 15.10.2011"]
[]
[]
["Auftrag","Kunde","Typ","Projektl.","Start","LT","Gesamt Reststunden","2011-10-01",null,null,null,"2011-11-01",{"$nulls":4},"2011-12-01",null,null,null,"2012-01-01",null,null,null,"2012-02-01"]
[{"$nulls":7},40,41,42,43,44,45,46,47,48,49,50,51,52,1,2,3,4,5,6,7,8,9,10,11,12,13]
[{"$nulls":6},80,20,20,20,20]
[{"$nulls":6},55,5,5,null,null,15,30]
[{"$nulls":6},150,10,20,20,20,20,20,20,null,20]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0," "]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
["Auslastung ohne Projekte",{"$nulls":5},150,35,45,40,40,35,50,20,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Auslastung mit Projekten",{"$nulls":5},150,35,45,40,40,35,50,20,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Kapazitätsbelegung ohne Projekte",{"$nulls":6},160,null,null,null,125,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0]
["Kapazitätsbelegung mit Projekten",{"$nulls":6},160,null,null,null,125,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0]

{"sheet":"Maschine 2_Std","index":4,"n_rows":63,"n_cols":109,"rows_kept":63,"cut":false,"hidden":false,"merged":[[61,16,61,19],[62,20,62,23],[62,16,62,19],[61,58,61,61],[61,55,61,57],[61,42,61,45],[61,37,61,41],[61,33,61,36],[61,29,61,32],[61,24,61,28],[61,20,61,23],[68,107,68,108],[62,7,62,10],[62,11,62,15],[61,51,61,54],[61,70,61,74],[61,75,61,78],[61,79,61,82],[61,46,61,50],[62,70,62,74],[62,75,62,78],[62,79,62,82],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,6,7,6],[6,4,7,4],[6,5,7,5],[6,58,6,61],[6,20,6,23],[6,7,6,10],[6,11,6,15],[6,16,6,19],[61,7,61,10],[61,11,61,15],[6,42,6,45],[6,55,6,57],[6,46,6,50],[6,51,6,54],[6,24,6,28],[6,29,6,32],[6,33,6,36],[6,37,6,41],[6,101,6,104],[6,105,6,108],[61,62,61,65],[61,66,61,69],[61,92,61,95],[61,96,61,100],[61,83,61,87],[61,88,61,91],[6,62,6,65],[6,66,6,69],[62,42,62,45],[62,37,62,41],[62,33,62,36],[6,96,6,100],[6,70,6,74],[6,92,6,95],[6,75,6,78],[6,79,6,82],[6,83,6,87],[6,88,6,91],[62,58,62,61],[62,62,62,65],[62,66,62,69],[62,46,62,50],[62,51,62,54],[62,55,62,57],[62,29,62,32],[62,24,62,28],[61,101,61,104],[61,105,61,108],[62,83,62,87],[62,88,62,91],[62,92,62,95],[62,96,62,100],[62,101,62,104],[62,105,62,108]],"flags":["formulas_cached_only"]}
[]
["Auslastung Maschine 2"]
[]
["Datum: 15.10.2011"]
[]
[]
["Auftrag","Kunde","Typ","Projektl.","Start","LT","Gesamt Reststunden","2011-10-01",null,null,null,"2011-11-01",{"$nulls":4},"2011-12-01",null,null,null,"2012-01-01",null,null,null,"2012-02-01"]
[{"$nulls":7},40,41,42,43,44,45,46,47,48,49,50,51,52,1,2,3,4,5,6,7,8,9,10,11,12,13]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[]
["Auslastung ohne Projekte",{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Auslastung mit Projekten",{"$nulls":5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Kapazitätsbelegung ohne Projekte",{"$nulls":6},0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0]
["Kapazitätsbelegung mit Projekten",{"$nulls":6},0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0,null,null,null,0,{"$nulls":4},0,null,null,null,0]

{"sheet":"Ges_Std","index":5,"n_rows":76,"n_cols":55,"rows_kept":76,"cut":false,"hidden":false,"merged":[[6,7,6,8],[63,0,63,5],[64,0,64,5],[59,0,59,5],[60,0,60,5],[61,0,61,5],[62,0,62,5],[6,23,6,24],[6,25,6,26],[6,9,6,10],[6,11,6,12],[6,13,6,14],[6,21,6,22],[6,15,6,16],[6,17,6,18],[6,19,6,20],[6,27,6,28],[6,29,6,30],[6,47,6,48],[6,49,6,50],[6,31,6,32],[6,33,6,34],[6,35,6,36],[6,37,6,38],[6,51,6,52],[6,53,6,54],[6,39,6,40],[6,41,6,42],[6,43,6,44],[6,45,6,46]],"flags":["formulas_cached_only"]}
["Fertigungsauslastung Gesamt"]
[]
["Datum: 15.10.2011"]
[]
[]
[]
[{"$nulls":7},"Oktr 11\nKW 40-43",null,"Nov 11\nKW 44-48",null,"Dez 11\nKW 49 -52",null,"Jan 12\nKW 01-04"]
["Auftrag","Kunde","Typ","Projektl.","Start","LT","Gesamtstd.","Bear 1","Bear2","Bear 3","Bear 4","Bear 5","Bear 6","Bear 7","Bear 8","Bear 9","Bear 10","Bear 11","Bear 12","Bear 13","Bear 14","Bear 15","Bear 16","Bear 17","Bear 18","Bear 19","Bear 20","Bear 21","Bear 22","Bear 23","Bear 24","Bear 25","Bear 26","Bear 27","Bear 28","Bear 29","Bear 30","Bear 31","Bear 32","Bear 33","Bear 34","Bear 35","Bear 36","Bear 37","Bear 38","Bear 39","Bear 40","Bear 41","Bear 42","Bear 43","Bear 44","Bear 45","Bear 46","Bear 47","Bear 48"]
[{"$nulls":6},80,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},55,10,0,45,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},150,70,0,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Verfügbare Kapazität",{"$nulls":5},4428.9,100.8,100.8,126,126,119.7,119.7,113.39999999999999,0,107.1,107.1,119.7,119.7,132.29999999999998,132.29999999999998,81.89999999999999,81.89999999999999,126,138.6,132.29999999999998,138.6,119.7,126,100.8,132.29999999999998,107.1,126,119.7,132.29999999999998,107.1,119.7,132.29999999999998,132.29999999999998,100.8,119.7,126,132.29999999999998,126,144.9]
["Kapazitätsbelegung ohne Projekte",{"$nulls":5},285,160,0,125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Über-/Unterbelegung (-) ohne Projekte",{"$nulls":5},-4143.900000000001,59.2,-100.8,-1,-126,-119.7,-119.7,-113.39999999999999,0,-107.1,-107.1,-119.7,-119.7,-132.29999999999998,-132.29999999999998,-81.89999999999999,-81.89999999999999,-126,-138.6,-132.29999999999998,-138.6,-119.7,-126,-100.8,-132.29999999999998,-107.1,-126,-119.7,-132.29999999999998,-107.1,-119.7,-132.29999999999998,-132.29999999999998,-100.8,-119.7,-126,-132.29999999999998,-126,-144.9]
["Kapazitätsbelegung mit Projekten",{"$nulls":5},285,160,0,125,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Über-/Unterbelegung (-) mit Projekten",{"$nulls":5},-4143.900000000001,59.2,-100.8,-1,-126,-119.7,-119.7,-113.39999999999999,0,-107.1,-107.1,-119.7,-119.7,-132.29999999999998,-132.29999999999998,-81.89999999999999,-81.89999999999999,-126,-138.6,-132.29999999999998,-138.6,-119.7,-126,-100.8,-132.29999999999998,-107.1,-126,-119.7,-132.29999999999998,-107.1,-119.7,-132.29999999999998,-132.29999999999998,-100.8,-119.7,-126,-132.29999999999998,-126,-144.9]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]
[{"$nulls":14},0]

{"sheet":"H_Faktor","index":6,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Ermittlung des Stundenfaktors",{"$nulls":11},"Geers 12.10.2011"]
[]
["Tarifliche Normalarbeitszeit",8,"Std./Tag"]
[]
["Krankheit, Kur",null,0.031]
[]
["Ausfall für Besprechungen, Schulung, Versammlung, Wartezeit etc.",null,0.046]
[]
["Stundenfaktor",null,0.077]
[]
["ca.",7.384,"Std./Tag Angestellte"]
["ca.",7.384,"Std./Tag Gewerbliche"]
[]
[]
["Statistische Urlaubsverteilung 2012"]
[]
[null,20,20,23,20,19,23,20,20,25,20,19,25,254]
[null,4,1,1,1,2,2,2,7,3,0,1,6,30]
[null,"Jan 12\nKW 01-05","Feb 11\nKW 06-09","März 12\nKW 10-13","April 12\nKW 14-17","Mai 12\nKW 18-22","Juni 12\nKW 23-26","Juli 12\nKW 27-30","Aug 12\nKW 31-35","Sept 12\nKW 36-39","Okt 12\nKW 40-44","Nov 12\nKW 45-48","Dez 12\nKW 49-52","Gesamt"]
["Arbeitstage",8,18,20,19,20,20,22,23,20,22,21,19,232]
["./. Stat. Urlaubsverteilung",4,1,0,2,2,2,2,8,2,1,1,5,30]
["anw. Arbeitstage pro MA",4,17,20,17,18,18,20,15,18,21,20,14,202]
["X"]
["Stundenfaktor Gew.",6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3]
[" = monatl. Arbeitszeit pro Mitarbeiter/Gew.",25.2,107.1,126,107.1,113.39999999999999,113.39999999999999,126,94.5,113.39999999999999,132.29999999999998,126,88.2,1272.6]
["Stundenfaktor Ang.",6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5]
[" = monatl. Arbeitszeit pro Mitarbeiter/Ang.",26,110.5,130,110.5,117,117,130,97.5,117,136.5,130,91,1313]
[]
[]
[]
["Statistische Urlaubsverteilung 2008"]
[]
[null,20,20,21,21,19,22,21,23,22,21,21,22,253]
[null,4,2,2,1,2,1,1,8,3,1,1,4,30]
[null,"Jan 08\nKW 1-5","Feb 08\nKW 6-9","Mrz 08\nKW 10-13","Apr 08\nKW 14-18","Mai 08\nKW 19-22","Jun 08\nKW 23-26","Jul 08\nKW 27-31","Aug 08\nKW 32-35","Sep 08\nKW 36-39","Okt 08\nKW 40-44","Nov 08\nKW 45-48","Dez 08\nKW 49-52","Gesamt"]
["Arbeitstage",22,21,19,21,19,21,23,21,22,22,20,21,252]
["./. Stat. Urlaubsverteilung",3,2,2,0,3,1,3,8,2,1,0,5,30]
["anw. Arbeitstage pro MA",19,19,17,21,16,20,20,13,20,21,20,16,222]
["X"]
["Stundenfaktor Gew.",6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3,6.3]
[" = monatl. Arbeitszeit pro Mitarbeiter/Gew.",119.7,119.7,107.1,132.29999999999998,100.8,126,126,81.89999999999999,126,132.29999999999998,126,100.8,1398.6]
["Stundenfaktor Ang.",6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5,6.5]
[" = monatl. Arbeitszeit pro Mitarbeiter/Ang.",123.5,123.5,110.5,136.5,104,130,130,84.5,130,136.5,130,104,1443]

{"sheet":"Tabelle1","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}