{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["SEW","Verarbeitung"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"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"}

{"sheet":"SEW","index":0,"n_rows":58,"n_cols":49,"rows_kept":58,"cut":false,"hidden":false,"merged":[[6,33,6,36],[6,37,6,40],[6,41,6,44],[48,3,53,6],[6,45,6,48],[6,1,6,4],[6,5,6,8],[6,9,6,12],[6,13,6,16],[6,17,6,20],[6,21,6,24],[6,25,6,28],[6,29,6,32]]}
["Übersicht Serviceersatzwagen in der Reisacher-Gruppe"]
["Stand: 31.08.22"]
[]
[]
["1. Zu Befüllen von AHR"]
[]
[null,"2022-01-01",null,null,null,"2022-02-01",null,null,null,"2022-03-01",null,null,null,"2022-04-01",null,null,null,"2022-05-01",null,null,null,"2022-06-01",null,null,null,"2022-07-01",null,null,null,"2022-08-01",null,null,null,"2022-09-01",null,null,null,"2022-10-01",null,null,null,"2022-11-01",null,null,null,"2022-12-01"]
["Betrieb","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv","Anzahl SEW Gesamt (Stand im APAS)","davon eigene VFW (über monatliche Umbuchungsliste)","davon Fahrzeuge Reisacher Service e.K.","davon extern zugewiesen (wie Buchbinder), ständig aktiv"]
["MM",{"$f":"SUM(C9:E9)","v":15},14,1,0,{"$f":"SUM(G9:I9)","v":18},17,1,0,{"$f":"SUM(K9:M9)","v":17},16,1,0,{"$f":"SUM(O9:Q9)","v":19},18,1,0,{"$f":"SUM(S9:U9)","v":21},19,2,0,{"$f":"SUM(W9:Y9)","v":25},23,2,0,{"$f":"SUM(AA9:AC9)","v":20},18,2,0,{"$f":"SUM(AE9:AG9)","v":16},14,2,0,{"$f":"SUM(AI9:AK9)","v":0},null,null,null,{"$f":"SUM(AM9:AO9)","v":0},null,null,null,{"$f":"SUM(AQ9:AS9)","v":0},null,null,null,{"$f":"SUM(AU9:AW9)","v":0}]
["ULM",28,8,16,4,34,15,16,3,33,14,16,3,33,15,16,2,36,17,16,3,42,23,16,3,41,22,16,3,34,15,16,3,0,null,null,null,0,null,null,null,0,null,null,null,0]
["KRU",2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,2,0,0,null,null,null,0,null,null,null,0,null,null,null,0]
["LL",13,0,12,1,15,0,13,2,14,0,13,1,15,0,14,1,16,1,14,1,18,0,16,2,22,1,16,5,21,2,15,4,0,null,null,null,0,null,null,null,0,null,null,null,0]
["GZ",7,0,5,2,7,0,5,2,7,0,5,2,7,0,5,2,6,0,5,1,6,0,5,1,6,0,5,1,5,0,4,1,0,null,null,null,0,null,null,null,0,null,null,null,0]
["AAM",40,21,18,1,39,20,18,1,40,22,18,0,38,21,17,0,40,23,17,0,39,22,17,0,31,14,17,0,36,19,17,0,0,null,null,null,0,null,null,null,0,null,null,null,0]
[]
["Summe",{"$f":"SUM(B9:B15)","v":105},{"$f":"SUM(C9:C15)","v":43},{"$f":"SUM(D9:D15)","v":54},{"$f":"SUM(E9:E15)","v":8}]
[{"$nulls":4},"Buchbinder auf Reserve (werden kaum bewegt) "]
[]
["beispiel Jan.2020","Gesamt Gruppe","MM","ULM","KRU","LL","GZ","A"]
["Somit verfügbare Miettage (bei 30 Tagen im Monat)",{"$f":"+B16*30","v":3150},{"$f":"+$Z9*30","v":600},{"$f":"+$B10*30","v":840},{"$f":"+$B11*30","v":60},{"$f":"+$B12*30","v":390},{"$f":"+$B13*30","v":210},{"$f":"+$B14*30","v":1200}]
["verfügbare Miettage bei durchschnittlich 22 AT",{"$f":"+B16*22","v":2310},{"$f":"+$B9*22","v":330},{"$f":"+$B10*22","v":616},{"$f":"+$B11*22","v":44},{"$f":"+$B12*22","v":286},{"$f":"+$B13*22","v":154},{"$f":"+$B14*22","v":880}]
["Tatsächlich vermietet lt. Quell MIS im Januar 2020",2419,540,526,13,388,55,897]
["Auslastung in % bei 30 Tagen",{"$f":"+B22/B20","v":0.76793650793650792},{"$f":"+C22/C20","v":0.9},0.62619047619047619,0.21666666666666667,0.99487179487179489,0.26190476190476192,0.74750000000000005]
["Auslastung in % bei 22 Arbeitstagen im Januar o. Sa.",{"$f":"+B22/B21","v":1.0471861471861472},{"$f":"+C22/C21","v":1.6363636363636365},0.85389610389610393,0.29545454545454547,1.3566433566433567,0.35714285714285715,1.0193181818181818]
[]
[]
[]
["2. Übersicht"]
[]
[null,"2022-01-01","2022-02-01","2022-03-01","2022-04-01","2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01"]
["Arbeitstage pro Monat",20,20,23,19,21,20,22,22,22,20,21,21]
[null,"mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS","mögliche Miettage lt. APAS",null,"1. HF gibt bis 11. des Folgemonats die Zahlen ein"]
["MM",{"$f":"+B$31*B9","v":300},{"$f":"+$C$31*F9","v":360},{"$f":"+$D$31*J9","v":391},{"$f":"+$E$31*N9","v":361},{"$f":"+$F$31*R9","v":441},{"$f":"+$G$31*V9","v":500},{"$f":"+$H$31*Z9","v":440},{"$f":"+$I$31*AD9","v":352},{"$f":"+$J$31*AH9","v":0},{"$f":"+$K$31*AL9","v":0},{"$f":"+$L$31*AP9","v":0},{"$f":"+$M$31*AT9","v":0},null,"2. Arbeitstage werden einmal oben eingegeben für das ganze Jahre"]
["ULM",{"$f":"+$B$31*B10","v":560},680,759,627,756,840,902,748,0,0,0,0,null,"3. Zahlen müssen dann von 2. auf 3. ohne Formelverweis eingetragen werden (HF). Diesen Wert übernimmt dann immer Herr Winter."]
["KRU",{"$f":"+$B$31*B11","v":40},40,46,38,42,40,44,44,0,0,0,0]
["LL",{"$f":"+$B$31*B12","v":260},300,322,285,336,360,484,462,0,0,0,0]
["GZ",{"$f":"+$B$31*B13","v":140},140,161,133,126,120,132,110,0,0,0,0]
["AAM",{"$f":"+$B$31*B14","v":800},780,920,722,840,780,682,792,0,0,0,0]
[]
["*die möglichen zur Verfügung stehenden Miettage übermittelt AHR monatlich an Herr Winter über Dateizugriff Link im Haus Global Cube"]
["Masterdatei wird somit nur bei Global Cube abgelegt, keine monaliche E-Mail nötig, automatisieter Abgriff"]
["Wichtig: Nur Zahlen ändern, nicht die Datei."]
[]
[]
["3. Datenquelle für Herr Winter"]
[]
[null,"je nach Monat von 2. runter zukopieren (HF)"]
[null,"mögliche Miettage lt. APAS"]
["MM",352,null," --> Zellwerte für Herr Winter (B49 bis B54)"]
["ULM",748]
["KRU",44]
["LL",462]
["GZ",110]
["AAM",792]
[]
[]
[]
["4. Darstellung im MIS"]

{"sheet":"Verarbeitung","index":1,"n_rows":7,"n_cols":19,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Betrieb Nr","Vstufe 1","Zeile mit Bez","Konto","Bereich","Marke_FIBU","Jahr","Mögl_Miettage_1","Mögl_Miettage_2","Mögl_Miettage_3","Mögl_Miettage_4","Mögl_Miettage_5","Mögl_Miettage_6","Mögl_Miettage_7","Mögl_Miettage_8","Mögl_Miettage_9","Mögl_Miettage_10","Mögl_Miettage_11","Mögl_Miettage_12"]
[10,"Mögl. Miettage",null,null,"SC",null,2022,{"$f":"SEW!B33","v":300},{"$f":"SEW!C33","v":360},{"$f":"SEW!D33","v":391},{"$f":"SEW!E33","v":361},{"$f":"SEW!F33","v":441},{"$f":"SEW!G33","v":500},{"$f":"SEW!H33","v":440},{"$f":"SEW!I33","v":352},{"$f":"SEW!J33","v":0},{"$f":"SEW!K33","v":0},{"$f":"SEW!L33","v":0},{"$f":"SEW!M33","v":0}]
[40,"Mögl. Miettage",null,null,"SC",null,2022,{"$f":"SEW!B34","v":560},{"$f":"SEW!C34","v":680},{"$f":"SEW!D34","v":759},{"$f":"SEW!E34","v":627},{"$f":"SEW!F34","v":756},{"$f":"SEW!G34","v":840},{"$f":"SEW!H34","v":902},{"$f":"SEW!I34","v":748},{"$f":"SEW!J34","v":0},{"$f":"SEW!K34","v":0},{"$f":"SEW!L34","v":0},{"$f":"SEW!M34","v":0}]
[30,"Mögl. Miettage",null,null,"SC",null,2022,{"$f":"SEW!B35","v":40},{"$f":"SEW!C35","v":40},{"$f":"SEW!D35","v":46},{"$f":"SEW!E35","v":38},{"$f":"SEW!F35","v":42},{"$f":"SEW!G35","v":40},{"$f":"SEW!H35","v":44},{"$f":"SEW!I35","v":44},{"$f":"SEW!J35","v":0},{"$f":"SEW!K35","v":0},{"$f":"SEW!L35","v":0},{"$f":"SEW!M35","v":0}]
[50,"Mögl. Miettage",null,null,"SC",null,2022,{"$f":"SEW!B36","v":260},{"$f":"SEW!C36","v":300},{"$f":"SEW!D36","v":322},{"$f":"SEW!E36","v":285},{"$f":"SEW!F36","v":336},{"$f":"SEW!G36","v":360},{"$f":"SEW!H36","v":484},{"$f":"SEW!I36","v":462},{"$f":"SEW!J36","v":0},{"$f":"SEW!K36","v":0},{"$f":"SEW!L36","v":0},{"$f":"SEW!M36","v":0}]
[55,"Mögl. Miettage",null,null,"SC",null,2022,{"$f":"SEW!B37","v":140},{"$f":"SEW!C37","v":140},{"$f":"SEW!D37","v":161},{"$f":"SEW!E37","v":133},{"$f":"SEW!F37","v":126},{"$f":"SEW!G37","v":120},{"$f":"SEW!H37","v":132},{"$f":"SEW!I37","v":110},{"$f":"SEW!J37","v":0},{"$f":"SEW!K37","v":0},{"$f":"SEW!L37","v":0},{"$f":"SEW!M37","v":0}]
[60,"Mögl. Miettage",null,null,"SC",null,2022,{"$f":"SEW!B38","v":800},{"$f":"SEW!C38","v":780},{"$f":"SEW!D38","v":920},{"$f":"SEW!E38","v":722},{"$f":"SEW!F38","v":840},{"$f":"SEW!G38","v":780},{"$f":"SEW!H38","v":682},{"$f":"SEW!I38","v":792},{"$f":"SEW!J38","v":0},{"$f":"SEW!K38","v":0},{"$f":"SEW!L38","v":0},{"$f":"SEW!M38","v":0}]