{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Problem1","Problem 2","Problem 3","Problem 4"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"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":"Problem1","index":0,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Create Weight Matrix"]
[]
[null,null,"Routes: Route #1",1,2,3,1,3,null,"W",{"$f":"w(D5:H7, D10:F10, D12:F12)","v":0},52,76]
[null,null,"Route #2",2,1,3,1,null,null,null,44,0,32]
[null,null,"Route #3",3,1,2,null,null,null,null,96,0,0]
[]
[null,null,null,"A","B","C"]
[null,null,"Frequency:",64,44,80]
[]
[null,null,"Handling Cost:",0.5,1,0.25]
[]
[]
[]
[]
[]
[]
[null,"Create Weight Matrix"]
[]
[null,"Routes: Route #1",1,2,3,1,3,null,"W",{"$f":"w(C21:G23, C26:E26, C28:E28)","v":0},52,76]
[null,"Route #2",2,1,3,1,null,null,null,44,0,32]
[null,"Route #3",3,1,2,null,null,null,null,96,0,0]
[]
[null,null,"A","B","C"]
[null,"Frequency:",64,44,80]
[]
[null,"Handling Cost:",0.5,1,0.25]

{"sheet":"Problem 2","index":1,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
["(a)","a=a1"]
[]
[null,null,1,2,3,4,"TC"]
["a1",null,1,2,3,4,3830]
[null,"a2",1,2,4,3,3680]
[null,"a4",1,3,2,4,5330]
[null,"a6",1,4,3,2,4810]
[null,"a12",2,1,3,4,4170]
[null,"a16",3,2,1,4,4500]
[null,"a22",4,2,3,1,5270]
["a2",null,1,2,4,3,3680]
[null,"a1",1,2,3,4,3830]
[null,"a3",1,3,4,2,5660]
[null,"a5",1,4,2,3,4330]
[null,"a11",2,1,4,3,4020]
[null,"a15",3,2,4,1,4320]
[null,"a21",4,2,1,3,5300]
[]
["(b)","a=a17"]
[]
[null,null,1,2,3,4,"TC"]
["a17",null,3,4,1,2,4180]
[null,"a16",3,2,1,4,4500]
[null,"a14",3,1,4,2,5680]
[null,"a8",2,4,1,3,5520]
[null,"a6",1,4,3,2,4810]
[null,"a20",4,3,1,2,4280]
[null,"a18",3,4,2,1,3670]
["a18",null,3,4,2,1,3670]
[null,"a17",3,4,1,2,4180]
[null,"a15",3,2,4,1,4320]
[null,"a13",3,1,2,4,5350]
[null,"a7",2,4,3,1,5490]
[null,"a5",1,4,2,3,4330]
[null,"a19",4,3,2,1,3770]
[]
["(c)","a=a23"]
[]
[null,null,1,2,3,4,"TC"]
["a23",null,4,1,3,2,4930]
[null,"a22",4,2,3,1,5270]
[null,"a20",4,3,1,2,4280]
[null,"a14",3,1,4,2,5680]
[null,"a12",2,1,3,4,4170]
[null,"a6",1,4,3,2,4810]
[null,"a24",4,1,2,3,4450]
["a12",null,2,1,3,4,4170]
[null,"a11",2,1,4,3,4020]
[null,"a9",2,3,1,4,4820]
[null,"a7",2,4,3,1,5490]
[null,"a1",1,2,3,4,3830]
[null,"a23",4,1,3,2,4930]
[null,"a13",3,1,2,4,5350]
["a1",null,1,2,3,4,3830]
[null,"a2",1,2,4,3,3680]
[null,"a4",1,3,2,4,5330]
[null,"a6",1,4,3,2,4810]
[null,"a12",2,1,3,4,4170]
[null,"a16",3,2,1,4,4500]
[null,"a22",4,2,3,1,5270]
["a2",null,1,2,4,3,3680]
[null,"a1",1,2,3,4,3830]
[null,"a3",1,3,4,2,5660]
[null,"a5",1,4,2,3,4330]
[null,"a11",2,1,4,3,4020]
[null,"a15",3,2,4,1,4320]
[null,"a21",4,2,1,3,5300]

{"sheet":"Problem 3","index":2,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[20,13,20,14]]}
[]
["Create Weight Matrix",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,1,2,3,4,5,6,7,8]
["Routing :    1",3,6,5,8,6,4,null,null,null,1,{"$f":"w(B4:I9,B13:G13,B15:G15)","v":0},0,0,7872,0,0,278382,0]
[2,5,3,4,1,7,5,null,null,null,2,0,0,0,0,0,51822,0,0]
[3,8,4,2,6,5,3,1,7,null,3,51822,0,0,226560,7872,1936,0,0]
[4,6,1,4,7,3,5,8,2,null,4,226560,25272,0,0,0,441000,7872,0]
[5,5,8,2,6,5,3,1,7,null,5,0,0,278382,0,0,0,0,36358]
[6,7,6,4,6,4,null,null,null,null,6,7872,0,0,883936,53758,0,0,0]
[null,null,null,null,null,null,null,null,null,null,7,0,0,7872,0,226560,441000,0,0]
[null,null,null,null,null,null,null,null,null,null,8,0,34422,0,25272,0,1936,0,0]
["Item : ",1,2,3,4,5,6]
["Flow : ",242,472,351,82,118,735]
[]
["Handling Cost : ",8,480,72,96,225,600]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"=dist(Locations,[1 or 2])"]
["Create Distance Matrix",null,null,null,null,null,null,null,"=dijk(Paths)",null,null,null,null,"Distance Matrix"]
[null,null,null,"Start (i)","End (j)","Dist (dij)",null,null,null,1,2,3,4,5,6,7,8]
[null,"Paths:",1,1,-2,52,null,null,1,{"$f":"dijk(D23:F33)","v":0},52,54,55,122,79,124,184]
[null,null,2,1,-3,54,null,null,2,52,0,30,95,70,55,100,150]
[null,null,3,1,-4,55,null,null,3,54,30,0,65,100,25,70,130]
[null,null,4,2,-3,30,null,null,4,55,95,65,0,120,40,85,145]
[null,null,5,2,-5,70,null,null,5,122,70,100,120,0,80,35,80]
[null,null,6,3,-6,25,null,null,6,79,55,25,40,80,0,45,105]
[null,null,7,4,-6,40,null,null,7,124,100,70,85,35,45,0,60]
[null,null,8,5,-7,35,null,null,8,184,150,130,145,80,105,60,0]
[null,null,9,5,-8,80]
[null,null,10,6,-7,45]
[null,null,11,7,-8,60]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Cost:"]
[null,{"$f":"sdpi(L4:S11,J23:Q30)","v":1},7,6,2,5,4,3,8,144189558]
["                    ",1,3,4,7,5,6,2,8,154302420]
["                    Best Layout:",1,7,6,2,5,4,3,8,144189558]
[null,5,3,1,8,4,7,6,2,170610330]
[null,8,3,5,1,4,7,6,2,162958598]
[null,8,1,7,5,4,3,6,2,172371446]
[null,1,3,4,7,5,6,2,8,154302420]
[null,1,3,4,7,5,6,2,8,154302420]
[null,1,7,6,2,5,4,3,8,144189558]
[null,3,4,6,5,2,7,1,8,153980980]
[null,8,1,4,2,3,6,7,5,171492284]
[null,5,7,3,8,6,1,4,2,170935392]
[null,5,3,4,7,8,6,1,2,154726426]
[null,1,3,4,7,5,6,2,8,154302420]
[null,5,7,3,8,6,1,4,2,170935392]

{"sheet":"Problem 4","index":3,"n_rows":24,"n_cols":22,"rows_kept":24,"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]
["Paths:",1,1,-4,42,1,{"$f":"dijk(C3:E21)","v":0},138,99,42,63,106,43,253,182,248,86,56,25,126,87,260]
[null,2,1,-13,25,2,138,0,65,96,94,32,149,115,44,110,52,82,132,12,118,122]
[null,3,2,-9,44,3,99,65,0,57,55,33,111,180,109,175,13,43,93,53,79,187]
[null,4,2,-14,12,4,42,96,57,0,26,64,82,211,140,206,44,14,64,84,50,218]
[null,5,3,-11,13,5,63,94,55,26,0,62,56,209,138,204,42,12,38,82,24,216]
[null,6,4,-12,14,6,106,32,33,64,62,0,118,147,76,142,20,50,100,20,86,154]
[null,7,5,-12,12,7,43,150,111,82,56,118,0,265,194,260,98,68,18,138,80,272]
[null,8,5,-13,38,8,77,115,145,116,90,147,34,0,71,71,132,102,52,127,114,83]
[null,9,5,-15,24,9,148,44,109,140,138,76,105,71,0,66,96,126,123,56,162,78]
[null,10,6,-11,20,10,148,110,175,187,161,142,105,71,66,0,162,173,123,122,185,12]
[null,11,6,-14,20,11,86,52,13,44,42,20,98,167,96,162,0,30,80,40,66,174]
[null,12,7,-13,18,12,56,82,43,14,12,50,68,197,126,192,30,0,50,70,36,204]
[null,13,7,-17,16,13,25,132,93,64,38,100,18,247,176,242,80,50,0,120,62,254]
[null,14,8,17,18,14,126,12,53,84,82,20,138,127,56,122,40,70,120,0,106,134]
[null,15,8,-18,38,15,87,118,79,50,24,86,80,233,162,228,66,36,62,106,0,240]
[null,16,9,-18,33,16,160,122,187,199,173,154,117,83,78,12,174,185,135,134,197,0]
[null,17,10,-16,12]
[null,18,10,-18,33]
[null,19,11,-12,30]
[null,null,14,-15,20]
[null,null,15,-16,10]
[null,null,16,-17,33]