{"text_format":"2","workbook":"xls","n_sheets":9,"sheets":["Problema 1","Problema 2","Problema 3","Problema 4","Problema 5","Problema 6","Problema 9","Problema 10","Clutter"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":189,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Problema 1","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,9]],"flags":["formulas_cached_only"]}
[]
[null,"Casal de Rancheiros"]
[null,"Variáveis de decisão:"]
[null,null,"X1:","cabeças de gado"]
[null,null,"X2:","cabeças de ovelhas"]
[]
[]
[null,null,null,"Z","X1","X2"]
[null,"F. Obj:","Maximizar",5800,60,10]
[null,null,null,"Solução:",80,100]
[null,null,null,"Sujeito a:"]
[null,null,null,"UAs)",1,0.2,100,"<=",100]
[null,null,null,"Máx. ovelhas)",null,1,100,"<=",200]
[null,null,null,"Mín. gado)",1,null,80,">=",50]
[null,null,null,"Mín. ovelhas)",null,1,100,">=",100]

{"sheet":"Problema 2","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,9]],"flags":["formulas_cached_only"]}
[]
[null,"Fábrica de Parafusos"]
[null,"Variáveis de decisão:"]
[null,null,"X1:","parafusos para marcenaria"]
[null,null,"X2:","parafusos para serralheria"]
[]
[]
[null,null,null,"Z","X1","X2"]
[null,"F. Obj:","Maximizar",61.33333333333334,0.05,0.03]
[null,null,null,"Solução:",1066.666666666667,266.66666666666646]
[null,null,null,"Sujeito a:"]
[null,null,null,"Máq. de fenda)",4,2,4800.000000000001,"<=",4800]
[null,null,null,"Máq. de rosca)",3,6,4800,"<=",4800]

{"sheet":"Problema 3","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,1,16,2],[19,1,19,2],[22,1,22,2]],"flags":["formulas_cached_only"]}
["Resolução do exercício aplicado em sala de aula"]
[]
["Variáveis","P","S"]
["Solução",23.999999999970598,8.000000000007557,null,"Z",3119.9999999982606,3119.9999999982606]
["Coef.F.O.",90,120]
["sujeito a",{"$nulls":4},"RHS"]
["Max.Padrão",3,null,71.9999999999118,"<=",72]
["Max.Seletiva",null,6,48.00000000004534,"<=",96]
["Max. Total",3,6,119.99999999995714,"<=",120]
[]
["Resolução Gráfica"]
["F.O.","P","S"]
["ponto 1",0,25.999999999985505]
["ponto 2",34.666666666666664,-1.4495071809506044e-11]
[]
["Restrições"]
[null,"Max.Padrão"]
["ponto 1",24,0]
["ponto 2",24,30]
[null,"Max.Seletiva"]
["ponto 1",0,16]
["ponto 2",40,16]
[null,"Max. Total"]
["ponto 1",0,20]
["ponto 2",40,0]

{"sheet":"Problema 4","index":3,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,0,22,0],[1,1,1,13],[11,0,13,0],[14,0,16,0],[17,0,19,0]],"flags":["formulas_cached_only"]}
[]
[null,"A comunidade do Vale Psi Kodel"]
[null,null,"Variáveis de decisão:"]
[null,"Xij:","hectares da eco-vila i plantados com a cultura j"]
[]
[]
[]
[]
[null,null,"X11","X12","X13","X21","X22","X23","X31","X32","X33"]
[null,"Solução:",133.33333333333331,100,0,100,250,0,25,150,0,null,"=",633333.3333333333]
["F.Obj.","Máx. Z:",1000,750,250,1000,750,250,1000,750,250]
["Área","Eco-Sol:",1,1,1,{"$nulls":6},233.33333333333331,"<=",400]
[null,"Eco-Terra:",null,null,null,1,1,1,null,null,null,350,"<=",600]
[null,"Eco-Lua:",{"$nulls":6},1,1,1,175,"<=",300]
["Plantios","Beterraba:",1,null,null,1,null,null,1,null,null,258.3333333333333,"<=",600]
[null,"Algodão:",null,1,null,null,1,null,null,1,null,500,"<=",500]
[null,"Sorgo:",null,null,1,null,null,1,null,null,1,0,"<=",325]
["Irrigação","Eco-Sol:",999,666,333,{"$nulls":6},199799.99999999997,"<=",199800]
[null,"Eco-Terra:",null,null,null,999,666,333,null,null,null,266400,"<=",266400]
[null,"Eco-Lua:",{"$nulls":6},999,666,333,124875,"<=",124875]
["Proporção","Sol-Terra",600,600,600,-400,-400,-400,null,null,null,0,"=",0]
[null,"Sol-Lua",null,null,null,300,300,300,-600,-600,-600,0,"=",0]
[null,"Terra-Lua",300,300,300,null,null,null,-400,-400,-400,0,"=",0]

{"sheet":"Problema 5","index":4,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,14],[12,0,16,0],[17,0,20,0]],"flags":["formulas_cached_only"]}
[]
[null,"ONG formadora de educadores ambientais"]
[null,null,"Variáveis de decisão:"]
[null,"Xt:","trainees formados no mês t"]
[null,"Yt:","educadores no início do mês t"]
[]
[]
[]
[null,null,"X1","X2","X3","X4","X5","Y1","Y2","Y3","Y4","Y5"]
[null,"Solução:",40.000000000000156,140.00000000000068,554.0000000000024,2271.1000000000095,9376.065000000039,50,87.50000000000006,223.1250000000009,765.9687500000032,2998.7703125000126,null,"=",20631893.125000086]
["F.Obj.","Min. Z:",1000,1000,1000,1000,1000,2000,2000,2000,2000,2000]
[null,"Início",{"$nulls":5},1,{"$nulls":4},50,"=",50]
["Horas aula","Mês 1",-50,{"$nulls":4},160,{"$nulls":4},5999.999999999993,">=",6000]
[null,"Mês 2",null,-50,{"$nulls":4},160,null,null,null,6999.9999999999745,">=",7000]
[null,"Mês 3",null,null,-50,{"$nulls":4},160,null,null,8000.0000000000255,">=",8000]
[null,"Mês 4",null,null,null,-50,{"$nulls":4},160,null,9000.000000000044,">=",9000]
[null,"Mês 5",{"$nulls":4},-50,{"$nulls":4},160,11000.000000000058,">=",11000]
["Educadores","Mês 2-1",1,{"$nulls":4},0.95,-1,null,null,null,9.947598300641403e-14,"=",0]
[null,"Mês 3-2",null,1,{"$nulls":4},0.95,-1,null,null,-1.7053025658242404e-13,"=",0]
[null,"Mês 4-3",null,null,1,{"$nulls":4},0.95,-1,null,0,"=",0]
[null,"Mês 5-4",null,null,null,1,{"$nulls":4},0.95,-1,0,"=",0]

{"sheet":"Problema 6","index":5,"n_rows":38,"n_cols":65,"rows_kept":38,"cut":false,"hidden":false,"merged":[[36,0,36,1],[37,0,37,1],[1,1,1,25],[10,0,29,0],[30,0,32,0],[33,0,35,0]],"flags":["formulas_cached_only"]}
[]
[null,"Balanço Racial-Cultural da Secretaria de Educação de Tupinambá"]
[null,"Variáveis de decisão:"]
[null,"Njk=","alunos NATIVOS residentes na sub-região j destinados para a escola k"]
[null,"Gjk=","alunos GAUCHOS residentes na sub-região j destinados para a escola k"]
[]
[]
[null,null,"N11","N12","N13","N21","N22","N23","N31","N32","N33","N41","N42","N43","N51","N52","N53","N61","N62","N63","N71","N72","N73","N81","N82","N83","N91","N92","N93","N01","N02","N03","G11","G12","G13","G21","G22","G23","G31","G32","G33","G41","G42","G43","G51","G52","G53","G61","G62","G63","G71","G72","G73","G81","G82","G83","G91","G92","G93","G01","G02","G03"]
[null,"Solução:",196.8750029805576,103.12499702626354,0,400.0000000096634,0,0,199.99999999914735,0,0,0,0,0,0,199.99999999914735,0,0,99.99999999957367,0,0,250.0000000003002,0,0,0,300.00000000738964,0,109.37500006069135,40.62499993845597,0,0,350.0000000085265,149.99999995225164,0,0,0,0,0,299.9999990524203,0,0,53.124999864313345,412.173464135779,34.701536221668206,0,199.99999993661962,0,0,325.3265362711461,24.67346461276904,199.99999993662027,0,0,0,0,199.99999993661942,0,0,249.9999999207037,0,0,99.9999999683099,null,"=",5093.619385382301]
["F.Obj.","Mín. Z=",1.2,1.5,3.3,2.6,4,5.5,0.7,1.1,2.8,1.8,1.3,2,1.5,0.4,2.3,2,0.6,1.7,1.2,1.4,3.1,3.5,2.3,1.2,3.2,1.2,0.7,3.8,1.8,1,1.2,1.5,3.3,2.6,4,5.5,0.7,1.1,2.8,1.8,1.3,2,1.5,0.4,2.3,2,0.6,1.7,1.2,1.4,3.1,3.5,2.3,1.2,3.2,1.2,0.7,3.8,1.8,1]
["Culturas por Sub-região","N1",1,1,1,{"$nulls":57},300.00000000682115,"=",300]
[null,"N2",null,null,null,1,1,1,{"$nulls":54},400.0000000096634,"=",400]
[null,"N3",{"$nulls":6},1,1,1,{"$nulls":51},199.99999999914735,"=",200]
[null,"N4",{"$nulls":9},1,1,1,{"$nulls":48},0,"=",0]
[null,"N5",{"$nulls":12},1,1,1,{"$nulls":45},199.99999999914735,"=",200]
[null,"N6",{"$nulls":15},1,1,1,{"$nulls":42},99.99999999957367,"=",100]
[null,"N7",{"$nulls":18},1,1,1,{"$nulls":39},250.0000000003002,"=",250]
[null,"N8",{"$nulls":21},1,1,1,{"$nulls":36},300.00000000738964,"=",300]
[null,"N9",{"$nulls":24},1,1,1,{"$nulls":33},149.99999999914732,"=",150]
[null,"N0",{"$nulls":27},1,1,1,{"$nulls":30},350.0000000085265,"=",350]
[null,"G1",{"$nulls":30},1,1,1,{"$nulls":27},149.99999995225164,"=",150]
[null,"G2",{"$nulls":33},1,1,1,{"$nulls":24},0,"=",0]
[null,"G3",{"$nulls":36},1,1,1,{"$nulls":21},299.9999990524203,"=",300]
[null,"G4",{"$nulls":39},1,1,1,{"$nulls":18},500.00000022176056,"=",500]
[null,"G5",{"$nulls":42},1,1,1,{"$nulls":15},199.99999993661962,"=",200]
[null,"G6",{"$nulls":45},1,1,1,{"$nulls":12},350.00000088391516,"=",350]
[null,"G7",{"$nulls":48},1,1,1,{"$nulls":9},199.99999993662027,"=",200]
[null,"G8",{"$nulls":51},1,1,1,{"$nulls":6},199.99999993661942,"=",200]
[null,"G9",{"$nulls":54},1,1,1,null,null,null,249.9999999207037,"=",250]
[null,"G0",{"$nulls":57},1,1,1,99.9999999683099,"=",100]
["Gaúchos por no. de vagas na escola","1-2",{"$nulls":30},2000,-1500,null,2000,-1500,null,2000,-1500,null,2000,-1500,null,2000,-1500,null,2000,-1500,null,2000,-1500,null,2000,-1500,null,2000,-1500,null,2000,-1500,null,-0.002904105989728123,"=",0]
[null,"1-3",{"$nulls":30},1300,null,-1500,1300,null,-1500,1300,null,-1500,1300,null,-1500,1300,null,-1500,1300,null,-1500,1300,null,-1500,1300,null,-1500,1300,null,-1500,1300,null,-1500,-0.0025428180815652013,"=",0]
[null,"2-3",{"$nulls":31},1300,-2000,null,1300,-2000,null,1300,-2000,null,1300,-2000,null,1300,-2000,null,1300,-2000,null,1300,-2000,null,1300,-2000,null,1300,-2000,null,1300,-2000,-0.0008735325536690652,"=",0]
["Capacidade da escola",1,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1500.000001794974,"<=",1500]
[null,2,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,1699.9999974295208,"<=",2000]
[null,3,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,1300.0000006144423,"<=",1300]
["% mínimo (Escola 2)",{"$nulls":32},1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,937.5000003435447,"<=",1400]
["% máximo (Escola 2)",{"$nulls":32},1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,null,1,null,937.5000003435447,">=",600]

{"sheet":"Problema 9","index":6,"n_rows":39,"n_cols":22,"rows_kept":39,"cut":false,"hidden":false,"merged":[[1,1,1,21],[9,2,10,2],[9,3,10,3],[9,4,10,4],[9,15,9,16],[9,17,9,18],[9,5,10,5],[9,6,10,6],[9,9,9,10],[9,11,9,12],[9,13,9,14],[8,9,8,18],[8,2,8,6],[8,7,8,8]],"flags":["formulas_cached_only"]}
[]
[null,"Plano de uso e ocupação do solo no município de Na. Sra. dos Planos"]
[null,null,"Variáveis de decisão:"]
[null,"Xj:","Hectares destinados ao uso j"]
[null,"Yij:","Hectares da zona i destinados ao uso j"]
[null,"Vser:","Valor dos serviços"]
[null,"Vimp:","Valor dos impostos"]
[]
[null,null,"Hectares alocados no uso j",{"$nulls":4},"Valores",null,"Hectares da zona i alocados no uso j"]
[null,null,"X1","X2","X3","X4","X5","Serviço","Imposto","Residência",null,"Comércio",null,"Indústria",null,"Parque",null,"Turismo"]
[{"$nulls":7},"Vser","Vimp","Y11","Y21","Y12","Y22","Y13","Y23","Y14","Y24","Y15","Y25",null,null,"RHS"]
[null,"Solução)",2419.35483870934,387.0967741935103,290.3225806452707,193.54838709674698,1189.6774193549952,10656.258064514772,747540.6451614021,1669.3548387093922,750,127.09677419349347,260,0,290.3225806452711,133.54838709674706,60,0,1189.6774193549952,null,"=",747540.6451613356]
[null,"F.Obj. Max. Z=",130,400,950,null,2]
[null,"Calcula serviço)",2.5,4,10,0.5,0.05,-1,{"$nulls":11},1.4497345546260476e-09,"=",0]
[null,"Calcula imposto)",130,400,950,null,2,null,-1,{"$nulls":10},-6.647314876317978e-08,"=",0]
[null,"Balanço Res)",-1,{"$nulls":6},1,1,{"$nulls":8},5.206857167650014e-11,"=",0]
[null,"Balanço Com)",null,-1,{"$nulls":7},1,1,{"$nulls":6},-1.6825651982799172e-11,"=",0]
[null,"Balanço Ind)",null,null,-1,{"$nulls":8},1,1,{"$nulls":4},3.979039320256561e-13,"=",0]
[null,"Balanço Prq)",null,null,null,-1,{"$nulls":9},1,1,null,null,8.526512829121202e-14,"=",0]
[null,"Balanço Tur)",{"$nulls":4},-1,{"$nulls":10},1,1,0,"=",0]
[null,"Balanço Imposto-Serviço)",{"$nulls":5},1,-0.02,{"$nulls":10},-4294.554838713269,"<=",0]
[null,"Aumento de Pop)",8,{"$nulls":16},19354.83870967472,"<=",20000]
[null,"Adequação 11)",{"$nulls":7},1,{"$nulls":9},1669.3548387093922,"<=",1710]
[null,"Adequação 21)",{"$nulls":8},1,{"$nulls":8},750,"<=",1320]
[null,"Adequação 12)",{"$nulls":9},1,{"$nulls":7},127.09677419349347,"<=",170]
[null,"Adequação 22)",{"$nulls":10},1,{"$nulls":6},260,"<=",260]
[null,"Adequação 31)",{"$nulls":11},1,{"$nulls":5},0,"<=",420]
[null,"Adequação 32)",{"$nulls":12},1,{"$nulls":4},290.3225806452711,"<=",950]
[null,"Adequação 41)",{"$nulls":13},1,null,null,null,133.54838709674706,"<=",220]
[null,"Adequação 42)",{"$nulls":14},1,null,null,60,"<=",60]
[null,"Adequação 51)",{"$nulls":15},1,null,0,"<=",1480]
[null,"Adequação 52)",{"$nulls":16},1,1189.6774193549952,"<=",1940]
[null,"Limitação de Área Z1)",{"$nulls":7},1,null,1,null,1,null,1,null,1,null,1929.9999999996328,"<=",1930]
[null,"Limitação de Área Z2)",{"$nulls":8},1,null,1,null,1,null,1,null,1,2550.0000000002665,"<=",2550]
[null,"Balanço Área Verde)",-1,-1,-1,3,3,{"$nulls":12},1052.9032258071052,">=",0]
[null,"Balanço Res-Ind)",1,-2.5,-5,{"$nulls":14},-7.889866537880152e-10,">=",0]
[null,"Balanço Com-Res)",-0.16,1,{"$nulls":15},1.5916157281026244e-11,">=",0]
[null,"Balanço Res-Prq1)",{"$nulls":7},-1,{"$nulls":5},12.5,null,null,null,-5.3887561080046e-11,">=",0]
[null,"Balanço Res-Prq2)",{"$nulls":8},-1,{"$nulls":5},12.5,null,null,0,">=",0]

{"sheet":"Problema 10","index":7,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":false,"merged":[[15,0,16,0],[17,0,18,0],[19,0,20,0],[21,0,22,0]],"flags":["formulas_cached_only"]}
["Problema"]
["X1 - lotes de coleções de apostilas"]
["X2 - lotes de DVD's multimídia"]
[]
["Estrutura matemática"]
[null,null,null,"Variável","X1","X2",null,null,"Z"]
[null,null,null,"Solução",3.6666666667134535,4.166666666434239,null,null,616.6666666573997]
["Orc) 100 X1 + 60 X2 < 550",null,null,"Minimizar",100,60,null,null,"RHS"]
["APri) 70 X1 + 26 X2 > 330",null,null,null,70,26,364.99999999723195,">",330]
["APu) 200 X1 + 100 X2 > 1150",null,null,null,200,100,1149.9999999861145,">",1150]
["AUn) 50 X1 + 40 X2 > 350",null,null,null,50,40,349.99999999304225,">",350]
[]
[]
["Z =",550]
["Gráfico","X1","X2"]
["Orçamento",0,9.166666666666666]
[null,5.5,0]
["Alunos Pri",0,12.692307692307692]
[null,4.714285714285714,0]
["Alunos Pub",0,11.5]
[null,5.75,0]
["Alunos Uni",0,8.75]
[null,7,0]
{"$rows_empty":20}
[null,null,null,"Variável","X1","X2","DN1","DN2","DN3","DP1","DP2","DP3",null,null,"Z*"]
[{"$nulls":4},0,0,50,100,200,0,0,0,null,"=",0]
[{"$nulls":4},0,0,0,0,0,0,0,0]
[null,null,null,"Orça)",100,60,{"$nulls":6},0,"<=",550]
[null,null,null,"Priv)",70,26,1,null,null,-1,null,null,0,"=",330]
[null,null,null,"Pub)",200,100,null,1,null,null,-1,null,0,"=",1150]
[null,null,null,"Uni)",50,40,null,null,1,null,null,-1,0,"=",350]

{"sheet":"Clutter","index":8,"n_rows":20,"n_cols":35,"rows_kept":20,"cut":false,"hidden":false,"merged":[[9,0,9,1],[1,1,1,14],[10,0,11,0],[12,0,19,0]],"flags":["formulas_cached_only"]}
[]
[null,"Modelo de PL básico para manejo florestal - problema de produção de 500.000 cunits/ano - Clutter et al"]
[null,"Variáveis de decisão:"]
[null,"Xik:","hectares da unidade de manejo i submetidos ao regime k"]
[]
[]
[]
[null,null,"X11","X12","X13","X14","X15","X16","X17","X18","X19","X110","X111","X112","X113","X114","X115","X21","X22","X23","X24","X25","X26","X27","X28","X29","X210","X211","X212","X213","X214","X215"]
["Solução",250761008.7778045,0,15616.842996015008,19149.75105323631,0,0,0,16233.766233766235,0,14245.014245014247,12886.59793814433,11868.027533823879,0,0,0,0,34364.26116838488,8892.960925553623,0,21742.77790606152,0,0,0,0,0,0,0,0,0,0,0]
["Coef. FObj.:",null,2099,2159,2195,2196,2104,2158,2192,2074,2153,2082,1993,1892,1775,1652,1589,856,915,951,953,773,827,861,699,778,703,635,573,517,466,443]
["Restrições de área","Unidade 1",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,{"$nulls":15},90000,"=",90000]
[null,"Unidade 2",{"$nulls":15},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,65000.00000000002,"=",65000]
["Restrições de produção","Biênio 1",52.22,52.22,52.22,52.22,{"$nulls":26},1815511.5412519039,">=",1000000]
[null,"Biênio 2",{"$nulls":4},61.6,61.6,61.6,{"$nulls":23},1000000.0000000001,">=",1000000]
[null,"Biênio 3",{"$nulls":7},70.2,70.2,{"$nulls":21},1000000.0000000001,">=",1000000]
[null,"Biênio 4",{"$nulls":9},77.6,{"$nulls":20},1000000,">=",1000000]
[null,"Biênio 5",{"$nulls":10},84.26,{"$nulls":19},1000000.0000000001,">=",1000000]
[null,"Biênio 6",29.1,{"$nulls":10},90.24,null,null,null,29.1,{"$nulls":14},1000000.0000000001,">=",1000000]
[null,"Biênio 7",null,40.8,null,null,29.1,{"$nulls":7},94.9,null,null,null,40.8,null,null,29.1,{"$nulls":10},1000000.0000000001,">=",1000000]
[null,"Biênio 8",null,null,52.22,null,null,40.8,null,29.1,{"$nulls":5},98.56,null,null,null,52.22,null,null,40.8,null,29.1,{"$nulls":7},1000000,">=",1000000]