{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MinMaxMod","TranspModb"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":99,"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":"MinMaxMod","index":0,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,2,43,3],[2,2,2,4],[4,0,8,0],[10,2,10,5],[12,0,14,0],[18,1,18,4],[29,1,29,5],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[42,1,42,3]]}
["MiniMax",null,"Heinsco"]
[]
[null,"Cost","Warehouse",null,null,null,null,"Fixed","Plant",null,"MMSolver"]
[null,"From/To",1,2,3,null,null,"Cost","Capacity",null,{"$f":"MIN($E$44)","v":889000}]
["Plant",1,600,700,500,null,null,25000,500,null,{"$f":"COUNT($C$21:$E$25,$C$32:$F$34,$I$21:$I$25,$J$32:$J$34)","v":35}]
[null,2,700,500,700,null,null,35000,200,null,{"$f":"$C$26:$E$26=$C$28:$E$28","v":true}]
[null,3,800,400,900,null,null,40000,300,null,{"$f":"$C$35:$F$35>=$C$37:$F$37","v":true}]
[null,4,500,600,700,null,null,50000,400,null,{"$f":"$F$21:$F$25<=$H$21:$H$25","v":true}]
[null,5,700,600,500,null,null,40000,400,null,{"$f":"$G$32:$G$34<=$I$32:$I$34","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"($I$21:$I$25=0)+($I$21:$I$25=1)=1","v":true}]
[null,"Cost","Costumer",null,null,null,null,"Fixed",null,null,{"$f":"($J$32:$J$34=0)+($J$32:$J$34=1)=1","v":true}]
[null,"From/To",1,2,3,4,null,"Cost",null,null,{"$f":"{32767,32767,0.000001,0.01,TRUE,FALSE,FALSE,1,2,1,0.0001,TRUE}","v":32767}]
["War",1,60,80,40,70,null,30000,null,null,{"$f":"{0,0,2,100,0,FALSE,FALSE,0.075,0,0,FALSE,30}","v":0}]
[null,2,70,40,60,80,null,40000]
[null,3,50,50,50,50,null,30000]
[]
[null,"Demand",400,300,250,350]
[]
[null,"Shipments Plant-Warehouse",null,null,null,null,null,"UBound","use","Plant"]
[null,"From/To",1,2,3,"Total",null,"Logical","plant","Capacity"]
[null,1,0,0,500,{"$f":"SUM(C21:E21)","v":500},"<=",{"$f":"I21*J21","v":500},1,{"$f":"I5","v":500}]
[null,2,0,0,0,{"$f":"SUM(C22:E22)","v":0},"<=",{"$f":"I22*J22","v":0},0,{"$f":"I6","v":200}]
[null,3,0,0,0,{"$f":"SUM(C23:E23)","v":0},"<=",{"$f":"I23*J23","v":0},0,{"$f":"I7","v":300}]
[null,4,400,0,0,{"$f":"SUM(C24:E24)","v":400},"<=",{"$f":"I24*J24","v":400},1,{"$f":"I8","v":400}]
[null,5,0,0,400.00000000000006,{"$f":"SUM(C25:E25)","v":400.00000000000006},"<=",{"$f":"I25*J25","v":400},1,{"$f":"I9","v":400}]
[null,"Received",{"$f":"SUM(C21:C25)","v":400},{"$f":"SUM(D21:D25)","v":0},{"$f":"SUM(E21:E25)","v":900},null,null,null,{"$f":"SUM(I21:I25)","v":3}]
[null,null,"=","=","="]
[null,"Shipped",{"$f":"+G32","v":399.99999999999989},{"$f":"G33","v":0},{"$f":"+G34","v":900.00000000000023}]
[]
[null,"Shipments Warehouse-Customer",null,null,null,null,null,null,"UBound","use","War"]
[null,"From/To",1,2,3,4,"Total",null,"Logical","War","Demand"]
[null,1,149.99999999999986,0,250.00000000000003,0,{"$f":"SUM(C32:F32)","v":399.99999999999989},"<=",{"$f":"J32*K32","v":1300},1,{"$f":"SUM($C$37:$F$37)","v":1300}]
[null,2,0,0,0,0,{"$f":"SUM(C33:F33)","v":0},"<=",{"$f":"J33*K33","v":0},0,{"$f":"SUM($C$37:$F$37)","v":1300}]
[null,3,250.00000000000014,300.00000000000006,0,349.99999999999994,{"$f":"SUM(C34:F34)","v":900.00000000000023},"<=",{"$f":"J34*K34","v":1300},1,{"$f":"SUM($C$37:$F$37)","v":1300}]
[null,"Shipped",{"$f":"SUM(C32:C34)","v":400},{"$f":"SUM(D32:D34)","v":300.00000000000006},{"$f":"SUM(E32:E34)","v":250.00000000000003},{"$f":"SUM(F32:F34)","v":349.99999999999994},null,null,null,{"$f":"SUM(J32:J34)","v":2}]
[null,null,">=",">=",">=",">="]
[null,"Demand",{"$f":"+C17","v":400},{"$f":"+D17","v":300},{"$f":"+E17","v":250},{"$f":"+F17","v":350}]
[]
[null,"Element",null,null,"Cost"]
[null,"Plants to Warehouses",null,null,{"$f":"SUMPRODUCT(C5:E9,C21:E25)","v":650000}]
[null,"Warehouses to Customers",null,null,{"$f":"SUMPRODUCT(C13:F15,C32:F34)","v":64000}]
[null,"Plant Fixed Costs",null,null,{"$f":"SUMPRODUCT(H5:H9,I21:I25)","v":115000}]
[null,"Warehouses Fixed Costs",null,null,{"$f":"SUMPRODUCT(H13:H15,J32:J34)","v":60000}]
[null,null,"Total Cost",null,{"$f":"SUM(E40:E43)","v":889000}]

{"sheet":"TranspModb","index":1,"n_rows":36,"n_cols":25,"rows_kept":36,"cut":false,"hidden":false,"merged":[[2,18,2,20],[4,18,4,20],[32,3,32,6],[2,3,2,6],[3,3,3,6],[11,3,11,6],[17,3,17,6],[26,3,26,6]]}
["Facility Location",null,"Alocação de Aeronaves (b)"]
[]
[null,null,null,"Viagens/UnidAero/Rota   V𝑎𝑟",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disp Aero",null,null,null,"TMbSolver",null,"VarRange"]
[null,null,null,"Rotas 𝑟",null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,8,6,null,"$D$20:$G$22",null,"$D$20:$G$22"]
["Aero 𝑎","CapAero 𝐶𝑎","DispAero 𝐷𝑎  ",1,2,3,4,null,null,null,null,null,null,null,"QtdFal","CtoViag","CtoFal","CtoTotal","# Aeron Nec",null,null,null,"$D$20:$G$22",null,"$D$29:$G$31"]
[1,40,7,3,2,2,1,null,null,"Penalidade",25,30,35,60,3180,69600,101850,171450,7,0,6,null,"$D$20:$G$22",null,"$D$24:$G$24"]
[2,60,8,4,3,3,2,null,null,"Penalidade*2",50,60,70,120,660,173000,39700,212700,7,8,6,null,"$D$20:$G$22"]
[3,100,6,5,4,4,2,null,null,"Penalidade*3",75,90,105,180,580,174700,57750,232450,7,8,6,null,"$D$20:$G$22"]
[null,null,"DemPass 𝐷𝑟",975,1065,915,1425,null,null,"Penalidade*100",2500,3000,3500,6000,580,174700,1925000,2099700,7,8,6,null,"$D$20:$G$22"]
[null,null,"CtoFal 𝑓𝑟  ",50,60,70,120,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$D$20:$G$22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$D$20:$G$22",null,",,"]
[null,null,null,"Custo Viagem/Aero/Rota   𝐶𝑣𝑎𝑟  ",null,null,null,null,null,null,null,null,null,null,null,"Boat",null,null,null,null,null,null,"$D$20:$G$22"]
[null,null,"Aero 𝑎",1,2,3,4,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,"$D$20:$G$22"]
[null,null,1,1500,1900,2100,2800]
[null,null,2,2100,2600,2800,3700]
[null,null,3,3200,3700,3900,5800,null,null,null,null,null,null,null,null,null,null,null,"SaidaR",null,null,null,"SaidaA"]
[null,null,null,null,null,null,null,null,null,"Custo",{"$f":"SUMPRODUCT(D20:G22,D14:G16)+SUMPRODUCT(D24:G24,D10:G10)","v":212700},null,null,null,null,null,null,null,"Rota 𝑟","Aero 𝑎","𝑄𝑣𝑎𝑟",null,"Aero 𝑎","Rota 𝑟","𝑄𝑣𝑎𝑟"]
[null,null,null,"# viag/aero/rota   𝑄𝑣𝑎𝑟",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,18,null,1,1,18]
[null,null,"Aero 𝑎",1,2,3,4,null,null,"CtoViag",{"$f":"SUMPRODUCT(D20:G22,D14:G16)","v":173000},null,null,null,null,null,null,null,2,3,8,null,1,4,1]
[null,null,1,18,0,0,1,null,null,"CtoFal",{"$f":"SUMPRODUCT(D24:G24,D10:G10)","v":39700},null,null,null,null,null,null,null,3,3,8,null,2,4,16]
[null,null,2,0,0,0,16,null,null,"CtoTotal",{"$f":"SUM(K19:K20)","v":212700},null,null,null,null,null,null,null,4,3,4,null,3,2,8]
[null,null,3,0,8,8,4,null,null,null,null,null,null,null,null,null,null,null,4,1,1,null,3,3,8]
[null,null,"PasTransp 𝑇𝑟",{"$f":"SUMPRODUCT(D20:D22,$B$6:$B$8)","v":720},{"$f":"SUMPRODUCT(E20:E22,$B$6:$B$8)","v":800},{"$f":"SUMPRODUCT(F20:F22,$B$6:$B$8)","v":800},{"$f":"SUMPRODUCT(G20:G22,$B$6:$B$8)","v":1400},"# Falta",null,null,null,null,null,null,null,null,null,null,4,2,16,null,3,4,4]
[null,null,"Falta 𝐹𝑟",255,265,115,25,{"$f":"SUM(D24:G24)","v":660}]
[null,null,"Trans+Falta  𝑇𝐹𝑟",{"$f":"D24+D23","v":975},{"$f":"E24+E23","v":1065},915,1425]
[]
[null,null,null,"# aero/rota   𝑄𝑎𝑟  "]
[null,null,"Aero 𝑎",1,2,3,4,"# AeroNec 𝑄𝑎"]
[null,null,1,6,0,0,1,{"$f":"SUM(D29:G29)","v":7}]
[null,null,2,0,0,0,8,{"$f":"SUM(D30:G30)","v":8}]
[null,null,3,0,2,2,2,6]
[]
[null,null,null,"# max viag/aero/rota   𝑄𝑣𝑎𝑟𝑀𝑎𝑥"]
[null,null,null,{"$f":"D29*D6","v":18},0,0,1]
[null,null,null,0,0,0,16]
[null,null,null,0,8,8,4]