{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Arbeitsblatt","Daten_Abteilungen","Daten_Fluss"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Arbeitsblatt","index":0,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zum Aufrufen des Dialogs auf die Schaltfläche \"Kreisverfahren…\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"klicken!"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gesamtlänge Materialfluss"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Daten_Fluss!$K:$K)","v":2830.3976464115076},"km"]

{"sheet":"Daten_Abteilungen","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Pos","Abteilung","Bezeichnung","Startmaschine","Endemaschine","Eingehende Verbindungen","Ausgehende Verbindungen","Anzahl:",{"$f":"COUNT(D:D)","v":15},null,"Achtung: Die Abteilungen müssen eindeutig sein!"]
[15,"C","Beispiel C",1,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B2)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B2)","v":0}]
[14,"A","Beispiel A",0.12,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B3)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B3)","v":1}]
[13,"B","Beispiel B",0.95,0.02,{"$f":"COUNTIF(Daten_Fluss!A:A,B4)","v":2},{"$f":"COUNTIF(Daten_Fluss!B:B,B4)","v":2}]
[12,"J","Beispiel J",0,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B5)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B5)","v":1}]
[11,"D","Beispiel D",0,0.02,{"$f":"COUNTIF(Daten_Fluss!A:A,B6)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B6)","v":1}]
[10,"F","Beispiel F",0,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B7)","v":2},{"$f":"COUNTIF(Daten_Fluss!B:B,B7)","v":2}]
[9,"M","Beispiel M",0,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B8)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B8)","v":2}]
[8,"L","Beispiel L",0,1,{"$f":"COUNTIF(Daten_Fluss!A:A,B9)","v":0},{"$f":"COUNTIF(Daten_Fluss!B:B,B9)","v":2}]
[7,"G","Beispiel G",0,0.05,{"$f":"COUNTIF(Daten_Fluss!A:A,B10)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B10)","v":1}]
[6,"I","Beispiel I",0,1,{"$f":"COUNTIF(Daten_Fluss!A:A,B11)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B11)","v":3}]
[5,"O","Beispiel O",0,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B12)","v":3},{"$f":"COUNTIF(Daten_Fluss!B:B,B12)","v":1}]
[4,"N","Beispiel N",0,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B13)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B13)","v":1}]
[3,"E","Beispiel E",1,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B14)","v":1},{"$f":"COUNTIF(Daten_Fluss!B:B,B14)","v":0}]
[2,"H","Beispiel H",0,0.05,{"$f":"COUNTIF(Daten_Fluss!A:A,B15)","v":0},{"$f":"COUNTIF(Daten_Fluss!B:B,B15)","v":0}]
[1,"K","Beispiel K",0,0,{"$f":"COUNTIF(Daten_Fluss!A:A,B16)","v":2},{"$f":"COUNTIF(Daten_Fluss!B:B,B16)","v":1}]

{"sheet":"Daten_Fluss","index":2,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Von","Nach","Jahresbedarf",null,null,"JB-max",{"$f":"MAX(C:C)","v":15915},null,"Länge [points]","Länge [m]","Länge*JB [km]","Maßstab [1 point in m]",{"$f":"1/5.5","v":0.18181818181818182},null,"Achtung: Die Transporte \"Von\" / \"Nach\" müssen eindeutig sein!"]
["I","L",15915,null,null,null,null,null,164.22716796336852,{"$f":"I2*$M$1","v":29.859485084248821},{"$f":"J2*C2/1000","v":475.21370511582001}]
["C","N",11395,null,null,null,null,null,101.53881796982111,{"$f":"I3*$M$1","v":18.461603267240204},{"$f":"J3*C3/1000","v":210.36996923020212}]
["E","A",9206,null,null,null,null,null,170.94997025479759,31.081812773599562,286.13916839375753]
["N","J",8568,null,null,null,null,null,122.24601816166356,22.226548756666102,190.43706974711517]
["J","O",7378,null,null,null,null,null,204.510739364069,37.18377079346709,274.3418609142002]
["O","B",5210,null,null,null,null,null,95.157238917138642,17.301316166752482,90.139857228780428]
["B","I",5065,null,null,null,null,null,0,0,0]
["A","K",5065,null,null,null,null,null,91.846605966599526,16.699382903018098,84.582374403786673]
["K","F",4755,null,null,null,null,null,269.12595799850004,48.931992363363648,232.67162368779415]
["F","I",4709,null,null,null,null,null,94.378290438046562,17.159689170553921,80.804976304138421]
["O","D",4604,null,null,null,null,null,92.765636858243383,16.866479428771523,77.653271290064097]
["D","B",3878,null,null,null,null,null,100.587602563869,18.288655011612544,70.923404135033451]
["O","M",3434,null,null,null,null,null,77.000963434041608,14.000175169825747,48.076601533181616]
["M","F",3363,null,null,null,null,null,141.77212023463696,25.776749133570355,86.687207336197105]
["F","L",3103,null,null,null,null,null,190.27710243807792,34.595836806923259,107.35088161188287]
["B","G",2978,null,null,null,null,null,161.31575630661092,29.330137510292897,87.345149505652245]
["G","I",2950,null,null,null,null,null,364.73276142017659,66.3150475309412,195.62939021627653]
["K","M",4755,null,null,null,null,null,268.38512022438243,48.797294586251354,232.03113575762518]
[null,null,null,null,null,null,null,null,0]