{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Example 1","Example 2","Example 3","Kitchen Ex Data","DAN407","Template"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":19,"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":"Example 1","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,1,21,2]]}
[]
["Create Weight Matrix"]
[]
["Routes: Route #1",1,2,3,4,null,null,"W:",{"$f":"w(B4:F6,B9:D9,B11:D11)","v":0},46,0,0]
["Route #2",2,4,1,2,3,null,null,0,0,34,22]
["Route #3",3,4,1,2,4,null,null,0,0,0,36]
[null,null,null,null,null,null,null,null,22,0,0,0]
[null,"Part #1","Part #2","Part #3"]
["Frequency:",8,5,12]
[]
["Handling Cost:",3,2,1]
[]
[]
["Create Distance Matrix"]
[null,"X","Y"]
["Locations:",0,0,null,null,null,null,"D:",{"$f":"dist(B16:C19)","v":0},10,35,50]
[null,10,0,null,null,null,null,null,10,0,25,40]
[null,35,0,null,null,null,null,null,35,25,0,15]
[null,50,0,null,null,null,null,null,50,40,15,0]
[]
[]
["Find Best Layout","Best Layout:",null,null,null,"Cost:"]
[null,{"$f":"sdpi(I4:L7,I16:L19)","v":3},4,2,1,3670]

{"sheet":"Example 2","index":1,"n_rows":111,"n_cols":7,"rows_kept":111,"cut":false,"hidden":false,"merged":[[80,1,80,2],[109,1,109,2],[9,1,9,2],[24,1,24,2],[37,1,37,2],[52,1,52,2]]}
["Scenario A",null,null,"(OPEN SPACE)"]
[]
[null,"W:"]
[null,0,46,0,0,0]
[null,0,0,34,22,0]
[null,0,0,0,36,0]
[null,22,0,0,0,0]
[null,0,0,0,0,0]
[]
[null,"Locations:"]
[null,"X","Y"]
[null,33,80]
[null,45,76]
[null,56,80]
[null,52,90]
[null,35,90]
[]
[null,"D:"]
[null,{"$f":"dist(B12:C16,2)","v":0},12.649110640673518,23,21.470910553583888,10.198039027185569]
[null,12.649110640673518,0,11.704699910719626,15.652475842498529,17.204650534085253]
[null,23,11.704699910719626,0,10.770329614269007,23.259406699226016]
[null,21.470910553583888,15.652475842498529,10.770329614269007,0,17]
[null,10.198039027185569,17.204650534085253,23.259406699226016,17,0]
[]
[null,"Best Layout:",null,null,null,null,"Cost:"]
[null,{"$f":"sdpi(B4:F8,B19:F23)","v":1},2,3,4,5,2184.2652532629463]
[]
[]
["Scenario B",null,null,"(RECTANGULAR GRID)"]
[]
[null,"W:"]
[null,0,46,0,0,0]
[null,0,0,34,22,0]
[null,0,0,0,36,0]
[null,22,0,0,0,0]
[null,0,0,0,0,0]
[]
[null,"Locations:"]
[null,"X","Y"]
[null,0,0]
[null,90,0]
[null,0,40]
[null,50,40]
[null,90,40]
[]
[null,"D:"]
[null,{"$f":"dist(B40:C44,1)","v":0},90,40,90,130]
[null,90,0,130,80,40]
[null,40,130,0,50,90]
[null,90,80,50,0,40]
[null,130,40,90,40,0]
[]
[null,"Best Layout:",null,null,null,null,"Cost:"]
[null,{"$f":"sdpi(B32:F36,B47:F51)","v":5},3,1,2,4,9320]
[]
[]
["Scenario C",null,null,"(CIRCULATING CONVEYOR)"]
[]
[null,"W:"]
[null,0,46,0,0,0]
[null,0,0,34,22,0]
[null,0,0,0,36,0]
[null,22,0,0,0,0]
[null,0,0,0,0,0]
[]
[null,"Routes:"]
[null,"Start","End","Distance"]
[null,1,2,9]
[null,2,3,18]
[null,3,4,16]
[null,4,5,12]
[null,5,1,17]
[]
[null,"D:"]
[null,{"$f":"dijk(B68:D72)","v":0},9,27,43,55]
[null,63,0,18,34,46]
[null,45,54,0,16,28]
[null,29,38,56,0,12]
[null,17,26,44,60,0]
[]
[null,"Best Layout:",null,null,null,null,"Cost:"]
[null,{"$f":"sdpi(B60:F64,B75:F79)","v":3},4,5,1,2,2774]
[]
[]
["Scenario D",null,null,"(GENERAL NETWORK)"]
[]
[null,"W:"]
[null,0,46,0,0,0]
[null,0,0,34,22,0]
[null,0,0,0,36,0]
[null,22,0,0,0,0]
[null,0,0,0,0,0]
[]
[null,"Routes:"]
[null,"Start","End","Distance"]
[null,1,-2,52]
[null,1,-3,54]
[null,1,-4,55]
[null,2,-3,30]
[null,3,-5,25]
[null,4,-5,40]
[]
[null,"D:"]
[null,{"$f":"dijk(B96:D101)","v":0},52,54,55,79]
[null,52,0,30,95,55]
[null,54,30,0,65,25]
[null,55,95,65,0,40]
[null,79,55,25,40,0]
[]
[null,"Best Layout:",null,null,null,null,"Cost:"]
[null,{"$f":"sdpi(B88:F92,B104:F108)","v":3},4,2,5,1,6728]

{"sheet":"Example 3","index":2,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["Create Weight Matrix",null,null,null,null,null,null,null,null,null,"Weight Matrix"]
[null,null,null,null,null,null,null,null,1,2,3,4,5]
["Part Routes: Route #1",1,3,2,null,null,null,1,{"$f":"w(Route_Input,Frequency,Handling_Cost)","v":0},0,93.699999999999989,47.3,0]
["Route #2",4,5,2,3,null,null,2,43.699999999999996,0,186.7,0,0]
["Route #3",5,2,3,1,4,null,3,47.3,50,0,0,43.699999999999996]
["Route #4",4,2,null,null,null,null,4,0,56,0,0,139.39999999999998]
["Route #5",2,1,3,5,null,null,5,0,186.7,0,0,0]
[]
[null,"Part #1","Part #2","Part #3","Part #4","Part #5"]
["Frequency:",20,17,11,8,23]
[]
["Handling Cost:",2.5,8.1999999999999993,4.3,7,1.9]
[]
[]
["Create Distance Matrix",null,null,null,null,null,null,null,null,null,"Distance Matrix"]
[null,"Start","End","Distance",null,null,null,null,1,2,3,4,5]
["Locations:",1,-2,15,null,null,null,1,{"$f":"dijk(Paths)","v":0},15,60,21,54]
[null,1,-3,60,null,null,null,2,15,0,47,16,39]
[null,1,-4,21,null,null,null,3,60,47,0,55,8]
[null,2,-4,16,null,null,null,4,21,16,55,0,47]
[null,2,-5,39,null,null,null,5,54,39,8,47,0]
[null,3,-5,8]
[null,4,-5,47]
[]
[]
["Find Best Layout"]
[null,"Layout:",null,null,null,null,"Cost:"]
[null,{"$f":"sdpi(W_Matrix,D_Matrix)","v":3},2,4,1,5,23200.5]

{"sheet":"Kitchen Ex Data","index":3,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Kitchen Layout Example Data"]
[]
["Meal:     Snack",4,3]
["Drink",7,4,5,1]
["Breakfast",7,1,7,4,7,1]
["Lunch",4,5,3,5,4,2,1]
["Dinner",6,5,4,1,5,2,3,5,1]
["Cleanup",1,5,1,4,1,5]
[]
["Frequency:",25,10,7,2,6,8]
[]
[null,null,"X","Y"]
["Locations:",1,0,3.75]
[null,2,0,6.25]
[null,3,0,8.75]
[null,4,7.25,11]
[null,5,8.5,9.75]
[null,6,8.5,2.25]
[null,7,6,0]

{"sheet":"DAN407","index":4,"n_rows":27,"n_cols":26,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"=dijk(Paths)",null,null,null,null,"Distance Matrix"]
[null,null,"(i)"," (j)"," (dij)",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Paths:",1,1,-11,7,1,{"$f":"dijk(C3:E26)","v":0},13,26,33,29,27,31,40,43,55,7,13,22,31,40,15,24,39]
[null,2,1,-16,15,2,13,0,13,46,28,26,35,44,54,44,6,12,21,30,39,28,37,26]
[null,3,2,-3,13,3,26,13,0,53,26,29,38,47,57,31,19,15,24,33,42,35,44,13]
[null,4,2,-11,6,4,33,46,53,0,37,25,16,7,10,40,40,38,30,21,25,18,9,50]
[null,5,3,-12,15,5,29,28,26,37,0,12,21,30,40,31,22,16,7,16,25,36,28,13]
[null,6,3,-18,13,6,27,26,29,25,12,0,9,28,35,38,20,14,5,14,23,25,16,25]
[null,7,4,-8,7,7,31,35,38,16,21,9,0,23,26,47,29,23,14,23,32,16,7,34]
[null,8,4,-9,10,8,40,44,47,7,30,28,23,0,17,38,38,32,23,14,23,25,16,43]
[null,9,4,-17,9,9,43,54,57,10,40,35,26,17,0,30,48,42,33,24,15,28,19,48]
[null,10,5,-13,7,10,55,44,31,40,31,38,47,38,30,0,48,42,33,24,15,58,49,18]
[null,11,5,-18,13,11,7,6,19,40,22,20,29,38,48,48,0,6,15,24,33,22,31,32]
[null,12,6,-7,9,12,13,12,15,38,16,14,23,32,42,42,6,0,9,18,27,20,29,28]
[null,13,6,-13,5,13,22,21,24,30,7,5,14,23,33,33,15,9,0,9,18,29,21,20]
[null,14,7,-17,7,14,31,30,33,21,16,14,23,14,24,24,24,18,9,0,9,38,30,29]
[null,15,8,-14,14,15,40,39,42,25,25,23,32,23,15,15,33,27,18,9,0,43,34,33]
[null,16,9,-15,15,16,15,28,35,18,36,25,16,25,28,58,22,20,29,38,43,0,9,48]
[null,17,10,-15,15,17,24,37,44,9,28,16,7,16,19,49,31,29,21,30,34,9,0,41]
[null,18,10,-18,18,18,39,26,13,50,13,25,34,43,48,18,32,28,20,29,33,48,41,0]
[null,19,11,-12,6,19]
[null,20,12,-13,9,20]
[null,21,12,-16,20]
[null,22,13,-14,9]
[null,23,14,-15,9]
[null,24,16,-17,9]
[null,25]

{"sheet":"Template","index":5,"n_rows":77,"n_cols":33,"rows_kept":77,"cut":false,"hidden":false,"merged":[[1,17,1,18],[20,17,20,18]]}
[]
["Create Weight Matrix",null,null,null,null,null,null,null,null,null,null,null,"=w(Routes,Flow,Handling_Cost)",null,null,null,null,"Weight Matrix"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
["Routing :    1",null,null,null,null,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,null,null,null,null,null,3]
[4,null,null,null,null,null,null,null,null,null,null,null,4]
[5,null,null,null,null,null,null,null,null,null,null,null,5]
[6,null,null,null,null,null,null,null,null,null,null,null,6]
[7,null,null,null,null,null,null,null,null,null,null,null,7]
[8,null,null,null,null,null,null,null,null,null,null,null,8]
[9,null,null,null,null,null,null,null,null,null,null,null,9]
[10,null,null,null,null,null,null,null,null,null,null,null,10]
[]
["Item : ",1,2,3,4,5,6,7,8,9,10]
["Flow : "]
[]
["Handling Cost : "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"=dist(Locations,[1 or 2])"]
["Create Distance Matrix",null,null,null,null,null,null,null,null,null,null,null,"=dijk(Paths)",null,null,null,null,"Distance Matrix"]
[null,null,"X","Y",null,null,"Start (i)","End (j)","Dist (dij)",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Locations :",1,null,null,"Paths:",1,null,null,null,null,null,null,1]
[null,2,null,null,null,2,null,null,null,null,null,null,2]
[null,3,null,null,null,3,null,null,null,null,null,null,3]
[null,4,null,null,null,4,null,null,null,null,null,null,4]
[null,5,null,null,null,5,null,null,null,null,null,null,5]
[null,6,null,null,null,6,null,null,null,null,null,null,6]
[null,7,null,null,null,7,null,null,null,null,null,null,7]
[null,8,null,null,null,8,null,null,null,null,null,null,8]
[null,9,null,null,null,9,null,null,null,null,null,null,9]
[null,10,null,null,null,10,null,null,null,null,null,null,10]
[null,11,null,null,null,11,null,null,null,null,null,null,11]
[null,12,null,null,null,12,null,null,null,null,null,null,12]
[null,13,null,null,null,13,null,null,null,null,null,null,13]
[null,14,null,null,null,14,null,null,null,null,null,null,14]
[null,15,null,null,null,15,null,null,null,null,null,null,15]
[null,16,null,null,null,16,null,null,null,null,null,null,16]
[null,17,null,null,null,17,null,null,null,null,null,null,17]
[null,18,null,null,null,18,null,null,null,null,null,null,18]
[null,19,null,null,null,19,null,null,null,null,null,null,19]
[null,20,null,null,null,20,null,null,null,null,null,null,20]
[null,null,"* for open space and rectangular layouts",null,null,21]
[null,null,null,null,null,22]
[null,null,null,null,null,23]
[null,null,null,null,null,24]
[null,null,null,null,null,25]
[null,null,null,null,null,null,"* for circular and general layouts."]
[]
["Find Best Layout",1,2,3,4,5,6,7,8,9,10]
["Layout:",null,null,null,null,null,null,null,null,null,null,"Cost:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"  =sdpi(Weight_Matrix,Distance_Matrix)"]
[null,null,"* for finding overall best layout"]
[null,"OR"]
[]
["Layout:",null,null,null,null,null,null,null,null,null,null,"Cost:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"* for observing the per iteration layouts"]
[null,"OR"]
[]
["Layout:",null,null,null,null,null,null,null,null,null,null,"Cost:"]
[]
[null,null,"* for observing a single iteration layout"]