ÐÏࡱá>þÿ þÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿRoot Entryÿÿÿÿÿÿÿÿ*0_šîÏ»òÀð^ðÕgIÆ Contentsÿÿÿÿÿÿÿÿÿÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿþÿÿÿýÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿþÿÿÿ ÿÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿRoot Entryÿÿÿÿÿÿÿÿ*0_šîÏ»òÀð^°s²3gIÆ@ Contentsÿÿÿÿÿÿÿÿÿÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿþÿÿÿýÿÿÿþÿÿÿ ÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿþÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿ  !"#$þÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿì‹{\rtf1\ansi\ansicpg1252\deff0\deflang1046{\fonttbl{\f0\fnil\fcharset0 Courier New;}} {\colortbl ;\red0\green0\blue255;\red0\green0\blue0;\red255\green0\blue0;} \viewkind4\uc1\pard\cf1\f0\fs20 title\cf2 : Mistura com meta - Problema 4 da Lista; \par \par \cf1 sets\cf2 : \par parametros /\cf1 @ole\cf2 ('MisturaMetas(R).xls','parametros')/: tl, \par tu, \par tr, \par wdt, \par dtn, \par dtp; \par \tab pilhas /\cf1 @ole\cf2 ('MisturaMetas(R).xls','pilhas')/: y, \par x, \par Qu, \par nunidret; \par \par \tab matriz(pilhas,parametros): t; \par \cf1 endsets\cf2 \par \par \cf1 data\cf2 : \par \tab tl, tu, tr, t, wdt, Qu, p, retmin, unidret = \par \tab\tab\cf1 @ole\cf2 ('MisturaMetas(R).xls', 'tl', 'tu','tr','t','wdt','Qu','p','retmin','unidret'); \par \cf1 enddata\cf2 \par \par [fo] \cf1 min\cf2 = \cf1 @sum\cf2 (parametros(j): wdt(j)*dtn(j)) + \cf1 @sum\cf2 (parametros(j): wdt(j)*dtp(j)) + \cf1 @sum\cf3 (\cf2 pilhas(i): y(i)\cf3 )\cf2 ; \par \par \cf1 @for\cf2 (parametros(j): \cf1 @sum\cf2 (pilhas(i): (t(i,j) - tu(j))*x(i)) <= 0); \par \p  !"#þÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿÿì‹{\rtf1\ansi\ansicpg1252\deff0\deflang1046{\fonttbl{\f0\fnil\fcharset0 Courier New;}} {\colortbl ;\red0\green0\blue255;\red0\green0\blue0;\red255\green0\blue0;} \viewkind4\uc1\pard\cf1\f0\fs20 title\cf2 : Mistura com meta - Problema 4 da Lista; \par \par \cf1 sets\cf2 : \par parametros /\cf1 @ole\cf2 ('MisturaMetas(R).xls','parametros')/: tl, \par tu, \par tr, \par wdt, \par dtn, \par dtp; \par \tab pilhas /\cf1 @ole\cf2 ('MisturaMetas(R).xls','pilhas')/: y, \par x, \par Qu, \par nunidret; \par \par \tab matriz(pilhas,parametros): t; \par \cf1 endsets\cf2 \par \par \cf1 data\cf2 : \par \tab tl, tu, tr, t, wdt, Qu, p, retmin, unidret = \par \tab\tab\cf1 @ole\cf2 ('MisturaMetas(R).xls', 'tl', 'tu','tr','t','wdt','Qu','p','retmin','unidret'); \par \cf1 enddata\cf2 \par \par [fo] \cf1 min\cf2 = \cf1 @sum\cf2 (parametros(j): wdt(j)*dtn(j)) + \cf1 @sum\cf2 (parametros(j): wdt(j)*dtp(j)); \par \par \cf1 @for\cf2 (parametros(j): \cf1 @sum\cf2 (pilhas(i): (t(i,j) - tu(j))*x(i)) <= 0); \par \par \cf1 @for\cf2 (parametros(j): \cf1 @sum\cf2 (par \cf1 @for\cf2 (parametros(j): \cf1 @sum\cf2 (pilhas(i): (t(i,j) - tl(j))*x(i)) >= 0); \par \par \cf1 @for\cf2 (parametros(j): \cf1 @sum\cf2 (pilhas(i): (t(i,j) - tr(j))*x(i)) + dtn(j) - dtp(j) = 0); \par \par \cf1 @sum\cf2 (pilhas(i): x(i)) = p; \par \par \cf1 @for\cf2 (pilhas(i): \cf1 @BND\cf2 (0, x(i), Qu(i))); \par \par \cf1 @for\cf2 (pilhas(i) | Qu(i) #ne# 0: y(i) >= x(i)/Qu(i)); \par \par \cf1 @for\cf2 (pilhas(i): x(i) >= retmin*y(i)); \par \par \cf1 @for\cf2 (pilhas(i): nunidret(iilhas(i): (t(i,j) - tl(j))*x(i)) >= 0); \par \par \cf1 @for\cf2 (parametros(j): \cf1 @sum\cf2 (pilhas(i): (t(i,j) - tr(j))*x(i)) + dtn(j) - dtp(j) = 0); \par \par \cf1 @sum\cf2 (pilhas(i): x(i)) = p; \par \par \cf1 @for\cf2 (pilhas(i): \cf1 @BND\cf2 (0, x(i), Qu(i))); \par \par \cf1 @for\cf2 (pilhas(i) | Qu(i) #ne# 0: y(i) >= x(i)/Qu(i)); \par \par \cf1 @for\cf2 (pilhas(i): x(i) >= retmin*y(i)); \par \par \cf1 @for\cf2 (pilhas(i): nunidret(i) = x(i) / unidret); \par \par \cf1 @for\cf2 (pilhas(i): \par \tab\cf1 @GIN\cf2 (nunidret(i)); \par \tab\cf1 @BIN\cf2 (y(i)); \par ); \par \par \cf1 data\cf2 : \par \tab\cf1 @ole\cf2 ('MisturaMetas\cf3 (\cf2 R\cf3 )\cf2 .xls','x','dtn','dtp') = x, dtn, dtp; \par \cf1 enddata\cf2 \par } 2 : \par parametros /\cf1 @ole\cf2 ('MisturaMetas.xls','parametros')/: tl, \par tu, \par tr, \par ) = x(i) / unidret); \par \par \cf1 @for\cf2 (pilhas(i): \par \tab\cf1 @GIN\cf2 (nunidret(i)); \par \tab\cf1 @BIN\cf2 (y(i)); \par ); \par \par \cf1 data\cf2 : \par \tab\cf1 @ole\cf2 ('MisturaMetas(R).xls','x','dtn','dtp') = x, dtn, dtp; \par \cf1 enddata\cf2 \par } cf1 @ole\cf2 ('MisturaMetas.xls','parametros')/: tl, \par tu, \par tr, \par