<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><div class=""><div class=""><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;"><div class=""></div></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><br class="Apple-interchange-newline">
</div>
<div><br class=""><blockquote type="cite" class=""><div class="">On 4 Apr 2020, at 10:31, Marcio Boareto <<a href="mailto:marcioboareto@gmail.com" class="">marcioboareto@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Prezado Prof Daniel<div class=""><br class=""></div><div class=""><br class=""></div><div class="">Ficaria muito agradecido se puder me ajudar. </div><div class="">Segue a planilha "dados", os resultados, o artigo e o script do R studio, se tiver como reproduzir.</div><div class=""><br class=""></div><div class="">O artigo onde estou tentando reproduzir o modelo (está dando erro, pois o pacote de leitura da planilha foi descontinuado (xlsReadWrite) e estou tentando utilizar outro pacote para exportar o modelo para uma planilha.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">Desde já agradeço vossa atenção.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em sáb., 4 de abr. de 2020 às 10:22, Daniel Guimarães Tiezzi <<a href="mailto:dtiezzi@usp.br" class="">dtiezzi@usp.br</a>> escreveu:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="auto" class="">Ok, seria melhor VC enviar parte da sua planilha para podemos reproduzir o erro e resolver para VC.<div dir="auto" class=""><br class=""></div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, 4 Apr 2020, 10:17 Marcio Boareto, <<a href="mailto:marcioboareto@gmail.com" target="_blank" class="">marcioboareto@gmail.com</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr" class="">Bom dia<div class=""><br class=""></div><div class="">Prezado Prof Daniel</div><div class=""><br class=""></div><div class="">Não consegui resolver e o erro ainda persiste. Estou aprendo recentemente a usar o R para cálculo de eficiência em análise envoltória de dados, estou com dificuldades em exportar os resultados para uma planilha.</div><div class=""><br class=""></div><div class="">Muito obrigado pela ajuda!</div></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Em sáb., 4 de abr. de 2020 às 09:49, Daniel Guimarães Tiezzi <<a href="mailto:dtiezzi@usp.br" rel="noreferrer" target="_blank" class="">dtiezzi@usp.br</a>> escreveu:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="">Bom dia<div class=""><br class=""></div><div class="">O erro gerado diz que a dimensão do objeto que você está tentando inserir como rownames do seu dataframe são diferentes.</div><div class=""><br class=""></div><div class="">Verifique isso:</div><div class=""><br class=""></div><div class="">> dim(planilha)[1]</div><div class="">> length(dados [ ,1])</div><div class=""><br class=""></div><div class="">Esses valoras devem ser iguais.</div><div class=""><br class=""></div><div class="">Daniel</div><div class=""><br class=""></div><div class=""> </div><div class=""><br class=""><div class="">
<div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;" class="">Daniel Tiezzi, MD, PhD<br class="">Oncologia / Mastologia</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;" class="">Professor Associado - Livre Docente<br class="">Departamento de Ginecologia e Obstetrícia<br class="">Setor de Mastologia e Oncologia Ginecológica<br class="">Faculdade de Medicina de Ribeirão Preto - USP<br class="">Tel.: 16 3602-2488<br class=""><a href="mailto:dtiezzi@usp.br" rel="noreferrer" target="_blank" class="">e-mail: dtiezzi@usp.br</a></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px;" class=""><br class=""></div><br class="">
</div>
<div class=""><br class=""><blockquote type="cite" class=""><div class="">On 4 Apr 2020, at 09:02, Marcio Boareto por (R-br) <<a href="mailto:r-br@listas.c3sl.ufpr.br" rel="noreferrer" target="_blank" class="">r-br@listas.c3sl.ufpr.br</a>> wrote:</div><br class=""><div class=""><div dir="ltr" class="">Bom dia<div class=""><br class=""></div><div class="">Preciso gerar uma planilha em excel dos dados gerados no modelo, porém está dando erro ao tentar colocar o nome das empresas na coluna 1 da planilha, segue o script: está dando erro no comando rownames</div><div class=""><br class=""></div><div class=""><table border="0" cellspacing="0" cellpadding="0" width="834" style="width:625.5pt;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial" class="">
<tbody class=""><tr class="">
<td valign="top" style="padding:0cm 0cm 6pt 4.5pt" class=""><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">#modelo retirado do artigo disponível
em: <a href="https://www.aedb.br/seget/arquivos/artigos13/44218525.pdf" rel="noreferrer" target="_blank" class="">https://www.aedb.br/seget/arquivos/artigos13/44218525.pdf</a></span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> require(lpSolve) # carrega pacote
lpSolve previamente instalado</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class="">Carregando pacotes exigidos:
lpSolve</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> require(xlsx) # carrega pacote
xlsReadWrite previamente instalado</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class="">Carregando pacotes exigidos: xlsx</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> setwd('c:/Users/Usuário/UFG/MESTRADO
2017/MESTRADO 2019/R') # define o diretório de trabalho</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">>
library(readxl)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">>
library(openxlsx)</span></div><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif"><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class=""> </span></p><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class="">Attaching package: ‘openxlsx’</span></div><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif"><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class=""> </span></p><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class="">The following objects are masked from ‘package:xlsx’:</span></div><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif"><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class=""> </span></p><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class=""> createWorkbook,
loadWorkbook, read.xlsx, saveWorkbook, write.xlsx</span></div><p class="MsoNormal" style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif"><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class=""> </span></p><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> library(xlsx)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> dados <-
read_excel("C:/Users/Usuário/UFG/MESTRADO 2017/MESTRADO
2019/R/dados.xlsx", col_names=TRUE)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> View(dados)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> dados</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""># A tibble: 18 x 5</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">
</span><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">UTILITY OPEX NETWORK MWH CUSTOMERS</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> <i class=""><chr></i> <i class=""><dbl></i> <i class=""><dbl></i> <i class=""><dbl></i> <i class=""><dbl></i></span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> </span><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">1
ELETROPAULO <u class="">1</u>249<u class="">143</u>613 <u class="">45</u>213 39<u class="">922</u>710 5<u class="">987</u>873</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> 2 CEMIG <u class="">1</u>682<u class="">334</u>644 <u class="">460</u>219 37<u class="">476</u>802 6<u class="">832</u>546</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> 3 CPFL - PAULISTA 497<u class="">290</u>782 <u class="">89</u>879 25<u class="">267</u>579 3<u class="">502</u>793</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> 4 COPEL <u class="">1</u>018<u class="">866</u>491 <u class="">224</u>817 23<u class="">525</u>040 3<u class="">628</u>209</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> 5 LIGHT 557<u class="">206</u>112 <u class="">58</u>074 22<u class="">902</u>552 3<u class="">640</u>182</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> 6 CELESC 721<u class="">455</u>274 <u class="">144</u>896 18<u class="">105</u>811 2<u class="">237</u>127</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> 7 COELBA 436<u class="">436</u>014 <u class="">215</u>001 14<u class="">286</u>757 4<u class="">622</u>046</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> 8 ELEKTRO 414<u class="">602</u>018 <u class="">107</u>116 13<u class="">398</u>558 2<u class="">123</u>670</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class=""> 9 CPFL - PIRATININGA 195<u class="">789</u>961 <u class="">22</u>236 13<u class="">013</u>378 1<u class="">367</u>488</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">10 BANDEIRANTE 286<u class="">832</u>273 <u class="">27</u>496 12<u class="">536</u>237 1<u class="">482</u>518</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">11 CELPE 350<u class="">651</u>684 <u class="">120</u>428 10<u class="">001</u>560 2<u class="">994</u>259</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">12 AMPLA 436<u class="">532</u>756 <u class="">51</u>050 9<u class="">506</u>961 2<u class="">365</u>558</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">13 CELG 691<u class="">472</u>253 <u class="">199</u>494 9<u class="">344</u>291 2<u class="">213</u>198</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">14 RGE 186<u class="">357</u>415 <u class="">84</u>997 7<u class="">993</u>103 1<u class="">226</u>079</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">15 COELGE 316<u class="">166</u>876 <u class="">120</u>300 7<u class="">929</u>212 2<u class="">744</u>830</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">16 ESCELSA 241<u class="">433</u>335 <u class="">56</u>960 7<u class="">897</u>969 1<u class="">185</u>432</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">17 AES SUL 206<u class="">122</u>962 <u class="">76</u>133 7<u class="">616</u>460 1<u class="">150</u>518</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";border:1pt none windowtext;padding:0cm" class="">18 CEEE 385<u class="">990</u>997 <u class="">71</u>892 7<u class="">277</u>929 1<u class="">438</u>072</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> inputs<- data.frame(dados[,2])
# seleciona coluna 2 do objeto data</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> outputs <-
data.frame(dados[,c(3,4,5)]) # seleciona colunas 3, 4 e 5 do objeto data</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> N<- dim(dados)[1] # número de
DMUs</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> s <- dim(inputs)[2] # número
de inputs</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> m <- dim(outputs)[2] # número
de outputs</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">>
f.rhs <- c(rep(0,1,N),1) # RHS</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> f.dir <-
c(rep("<=",1,N),"=") # direção das restrições</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> aux <-
cbind(-1*inputs,outputs) # matriz com os coeficientes tecnológicos em (6)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> for (i in 1:N) {</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+ f.obj <-
c(0*rep(1,s),as.numeric(outputs[i,])) # coeficientes da função objetivo</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+ f.con <- rbind(aux
,c(as.numeric(inputs[i,]), + rep(0,1,m))) # adiciona a restrição bTz=1</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+ results <-
lp("max",as.numeric(f.obj),f.con,f.dir,f.rhs,scale=1,compute.sens=TRUE)
# resolve PPL</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
multipliers <- results$solution #
multiplicadores</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
efficiency <- results$objval #
indices de eficiência</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
duals <- results$duals # ???</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
if (i==1) {</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
weights <- multipliers</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
effcrs <- efficiency</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
lambdas <- duals [seq(1,N)]</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
} else {</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
weights <-
rbind(weights,multipliers)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
effcrs <- rbind(effcrs ,
efficiency)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+
lambdas <-
rbind(lambdas,duals[seq(1,N)])</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+ }</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">+ }</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> ###################################################################</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> planilha <-
cbind(effcrs,weights)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> #ESSA PARTE NÃO ESTÁ
FUNCIONANDO###################################</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-size:10pt;font-family:"Lucida Console";color:blue" class="">> rownames(planilha) <- dados
[,1] # nomeas das linhas (empresas)</span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class="">Error in dimnames(x) <- dn : </span></div><div style="margin:0cm 0cm 0.0001pt;line-height:normal;word-break:break-all;font-size:12pt;font-family:"Times New Roman",serif" class=""><span lang="EN-US" style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class=""> </span><span style="font-size:10pt;font-family:"Lucida Console";color:rgb(197,6,11)" class="">comprimento
de 'dimnames' [1] não é igual ao tamanho do array</span></div>
</td>
</tr>
<tr class="">
<td valign="top" style="padding:0cm 0cm 6pt 4.5pt" class=""><br class="">Segue a planilha gerada, na coluna A preciso constar os nomes da coluna A (UTILITY)<br class=""><table border="0" cellpadding="0" cellspacing="0" width="506" style="border-collapse:collapse;width:380pt" class="">
<colgroup class=""><col width="86" style="width:65pt" class="">
<col width="84" span="5" style="width:63pt" class="">
</colgroup><tbody class=""><tr height="20" style="height:15pt" class="">
<td height="20" width="86" style="height:15pt;width:65pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class=""></td>
<td width="84" style="width:63pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency</td>
<td width="84" style="width:63pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">OPEX</td>
<td width="84" style="width:63pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">NETWORK</td>
<td width="84" style="width:63pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">MWH</td>
<td width="84" style="width:63pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">CUSTOMERS</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">effcrs</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,58270216</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">8,00548E-10</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">6,07396E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">5,6817E-08</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,579460003</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">5,94412E-10</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">9,73842E-07</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">3,50295E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.1</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,885425355</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,0109E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,52572E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,42719E-07</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.2</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,518585846</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">9,81483E-10</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">7,95216E-07</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,11913E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,10933E-08</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.3</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,775513183</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,79467E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,36166E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,27372E-07</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.4</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,523933705</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,38609E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,28427E-06</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,86596E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.5</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,29129E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,85644E-06</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,61264E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">4,92426E-08</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.6</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,687899797</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,41195E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,95421E-06</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,75023E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">5,18359E-08</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.7</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">5,10751E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">7,6844E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.8</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,698435209</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">3,48636E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,64519E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,47436E-07</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.9</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,82245379</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,85183E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,16376E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,02402E-07</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.10</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,549836367</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,29078E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,73807E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,62583E-07</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.11</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,585646</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,44619E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,93566E-06</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.12</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">5,36603E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">8,79133E-06</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">3,16227E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.13</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,819757504</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">3,16289E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,98655E-07</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.14</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,669679648</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">4,14193E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">3,35587E-06</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">4,72283E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">8,90153E-08</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.15</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,840551996</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">4,85147E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">3,93075E-06</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">5,53189E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">1,04264E-07</td>
</tr>
<tr height="20" style="height:15pt" class="">
<td height="20" style="height:15pt;padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">efficiency.16</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">0,44597084</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,59073E-09</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,09906E-06</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">2,95408E-08</td>
<td align="right" style="padding-top:1px;padding-right:1px;padding-left:1px;font-size:11pt;font-family:Calibri,sans-serif;vertical-align:bottom;border:none;white-space:nowrap" class="">5,56781E-08</td>
</tr>
</tbody></table><br class="">Se puderem ajudar, fico agradecido.<br class="">Atenciosamente<br class=""><br class="">Márcio Boareto</td>
</tr>
<tr class="">
<td valign="top" style="padding:0cm 0cm 6pt 4.5pt" class="">
<table border="0" cellspacing="0" cellpadding="0" width="834" style="width:625.5pt" class="">
<tbody class=""><tr class="">
<td width="1" valign="top" style="width:0.75pt;padding:0cm" class=""><div style="margin:0cm 0cm 0.0001pt;line-height:115%;font-size:12pt;font-family:"Times New Roman",serif" class=""><span style="font-family:"Lucida Console";color:blue" class="">></span></div></td></tr></tbody></table></td></tr></tbody></table><div dir="ltr" class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div class=""><br class=""></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
_______________________________________________<br class="">R-br mailing list<br class=""><a href="mailto:R-br@listas.c3sl.ufpr.br" rel="noreferrer" target="_blank" class="">R-br@listas.c3sl.ufpr.br</a><br class=""><a href="https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br" rel="noreferrer" target="_blank" class="">https://listas.inf.ufpr.br/cgi-bin/mailman/listinfo/r-br</a><br class="">Leia o guia de postagem (<a href="http://www.leg.ufpr.br/r-br-guia" rel="noreferrer" target="_blank" class="">http://www.leg.ufpr.br/r-br-guia</a>) e forneça código mínimo reproduzível.<br class=""></div></blockquote></div><br class=""></div></div></blockquote></div><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div dir="ltr" class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class="">
<div class=""><em class=""><font face="tahoma,sans-serif" class="">Márcio Boareto</font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">Administrador </font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">CRA-GO 15993</font></em></div><div class=""><em class=""><font face="tahoma,sans-serif" class="">Mestre em Gestão Organizacional pela UFG Catalão.</font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">Especialista em Gestão Financeira e Controladoria - UFG Catalão</font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">Graduado em Administração de Empresas - UFG Catalão</font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">64 98137-9049 whatsapp</font></em></div><div class=""><i class="">Lattes</i>:<span style="color:rgb(50,108,153);font-family:Tahoma,Geneva,sans-serif;font-size:11px" class=""><a href="http://lattes.cnpq.br/8524063708922235" rel="noreferrer" target="_blank" class="">http://lattes.cnpq.br/8524063708922235</a></span><em class=""><font face="tahoma,sans-serif" class=""><br class=""></font></em></div><div class=""><em class=""><font face="tahoma,sans-serif" class="">ORCID: </font></em><font face="tahoma, sans-serif" class=""><i class=""><a href="https://orcid.org/0000-0003-0398-8774" rel="noreferrer" target="_blank" class="">https://orcid.org/0000-0003-0398-8774</a></i></font></div>
<div class=""><br class=""></div><div class=""><br class=""></div></div></div></div></div></div></div></div></div></div></div></div>
</blockquote></div>
</blockquote></div><br clear="all" class=""><div class=""><br class=""></div>-- <br class=""><div dir="ltr" class="gmail_signature"><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class=""><div dir="ltr" class="">
<div class=""><em class=""><font face="tahoma,sans-serif" class="">Márcio Boareto</font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">Administrador </font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">CRA-GO 15993</font></em></div><div class=""><em class=""><font face="tahoma,sans-serif" class="">Mestre em Gestão Organizacional pela UFG Catalão.</font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">Especialista em Gestão Financeira e Controladoria - UFG Catalão</font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">Graduado em Administração de Empresas - UFG Catalão</font></em></div>
<div class=""><em class=""><font face="tahoma,sans-serif" class="">64 98137-9049 whatsapp</font></em></div><div class=""><i class="">Lattes</i>:<span style="color:rgb(50,108,153);font-family:Tahoma,Geneva,sans-serif;font-size:11px" class=""><a href="http://lattes.cnpq.br/8524063708922235" target="_blank" class="">http://lattes.cnpq.br/8524063708922235</a></span><em class=""><font face="tahoma,sans-serif" class=""><br class=""></font></em></div><div class=""><em class=""><font face="tahoma,sans-serif" class="">ORCID: </font></em><font face="tahoma, sans-serif" class=""><i class=""><a href="https://orcid.org/0000-0003-0398-8774" target="_blank" class="">https://orcid.org/0000-0003-0398-8774</a></i></font></div>
<div class=""><br class=""></div><div class=""><br class=""></div></div></div></div></div></div></div></div></div></div></div></div>
<span id="cid:f_k8lnhhul0"><resultscrs.xlsx></span><span id="cid:f_k8lnhhwk1"><script -seget.R></span><span id="cid:f_k8lnhhwm2"><dados.xlsx></span><span id="cid:f_k8lnhhws3"><44218525.pdf></span><span id="cid:f_k8lnmqd44"><script.docx></span></div></blockquote></div><br class=""></div></body></html>