{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet","Data_Departments","Data_Flow"],"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":"Worksheet","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,"Click the button \"Circle method…\" to open"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"the dialog box!"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total length of material flow"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Data_Flow!$K:$K)","v":2581.5065768513227},"km"]

{"sheet":"Data_Departments","index":1,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Pos","Department","Caption","Start-Department","End-Department","In going connections","Out going connections","Count:",{"$f":"COUNT(D:D)","v":15},null,"Attention: The department caption has to be unique!"]
[15,"C","Example C",1,0,{"$f":"COUNTIF(Data_Flow!A:A,B2)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B2)","v":0}]
[14,"A","Example A",0.12,0,{"$f":"COUNTIF(Data_Flow!A:A,B3)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B3)","v":1}]
[13,"B","Example B",0.95,0.02,{"$f":"COUNTIF(Data_Flow!A:A,B4)","v":2},{"$f":"COUNTIF(Data_Flow!B:B,B4)","v":2}]
[12,"J","Example J",0,0,{"$f":"COUNTIF(Data_Flow!A:A,B5)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B5)","v":1}]
[11,"D","Example D",0,0.02,{"$f":"COUNTIF(Data_Flow!A:A,B6)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B6)","v":1}]
[10,"F","Example F",0,0,{"$f":"COUNTIF(Data_Flow!A:A,B7)","v":2},{"$f":"COUNTIF(Data_Flow!B:B,B7)","v":2}]
[9,"M","Example M",0,0,{"$f":"COUNTIF(Data_Flow!A:A,B8)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B8)","v":2}]
[8,"L","Example L",0,1,{"$f":"COUNTIF(Data_Flow!A:A,B9)","v":0},{"$f":"COUNTIF(Data_Flow!B:B,B9)","v":2}]
[7,"G","Example G",0,0.05,{"$f":"COUNTIF(Data_Flow!A:A,B10)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B10)","v":1}]
[6,"I","Example I",0,1,{"$f":"COUNTIF(Data_Flow!A:A,B11)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B11)","v":3}]
[5,"O","Example O",0,0,{"$f":"COUNTIF(Data_Flow!A:A,B12)","v":3},{"$f":"COUNTIF(Data_Flow!B:B,B12)","v":1}]
[4,"N","Example N",0,0,{"$f":"COUNTIF(Data_Flow!A:A,B13)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B13)","v":1}]
[3,"E","Example E",1,0,{"$f":"COUNTIF(Data_Flow!A:A,B14)","v":1},{"$f":"COUNTIF(Data_Flow!B:B,B14)","v":0}]
[2,"H","Example H",0,0.05,{"$f":"COUNTIF(Data_Flow!A:A,B15)","v":0},{"$f":"COUNTIF(Data_Flow!B:B,B15)","v":0}]
[1,"K","Example K",0,0,{"$f":"COUNTIF(Data_Flow!A:A,B16)","v":2},{"$f":"COUNTIF(Data_Flow!B:B,B16)","v":1}]

{"sheet":"Data_Flow","index":2,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["From","To","Annual amount",null,null,"max amount",{"$f":"MAX(C:C)","v":15915},null,"Length [points]","Length [m]","Length*(annual amount) [km]","Scale factor [1 point in m]",{"$f":"1/5.5","v":0.18181818181818182},"Attention: The combination \"From\"/\"To\" has to be unique!"]
["I","L",15915,null,null,null,null,null,161.00342717229998,{"$f":"I2*$M$1","v":29.273350394963632},{"$f":"J2*C2/1000","v":465.88537153584622}]
["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,193.1471500882123,35.117663652402236,259.09812242742368]
["O","B",5210,null,null,null,null,null,105.20671161943589,19.128493021715617,99.659448643138361]
["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,63.816325521804288,11.602968276691689,54.638377614941163]
["O","D",4604,null,null,null,null,null,92.478933743855293,16.814351589791872,77.413274719401784]
["D","B",3878,null,null,null,null,null,100.587602563869,18.288655011612544,70.923404135033451]
["O","M",3434,null,null,null,null,null,149.71497106521716,27.220903830039482,93.47658375235558]
["M","F",3363,null,null,null,null,null,95.637800673098482,17.388691031472451,58.478167938841857]
["F","L",3103,null,null,null,null,null,191.30766338040087,34.783211523709248,107.9323053580698]
["B","G",2978,null,null,null,null,null,136.5503468765352,24.827335795733674,73.935805999694892]
["G","I",2950,null,null,null,null,null,111.45299925662827,20.264181683023324,59.779335964918808]
["K","M",4755,null,null,null,null,null,180.54131506719381,32.825693648580696,156.08617329900122]
[null,null,null,null,null,null,null,null,0]