<div dir="ltr">












Pessoal,<div>   Será que podem me ajudar a pensar em um problema. Tenho um grupo de pessoas que preciso redistribuir de acordo com uma porcentagem, mas não estou conseguindo distribui-las de forma mais justa e que não desequilibre muito a relevância. </div><div>   Segue um exemplo da minha base de dados:</div><div><br></div><div>












<table border="0" cellpadding="0" cellspacing="0" width="815" style="border-collapse:collapse;width:612pt">

 <colgroup><col width="84" style="width:63pt">
 <col width="102" style="width:77pt">
 <col width="79" style="width:59pt">
 <col width="135" span="2" style="width:101pt">
 <col width="142" style="width:107pt">
 <col width="138" style="width:104pt">
 </colgroup><tbody><tr height="51" style="height:38.25pt">
  <td height="51" class="gmail-xl65" width="84" style="height:38.25pt;width:63pt;font-family:"Courier New",monospace;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;vertical-align:bottom;border:none;white-space:nowrap"></td>
  <td class="gmail-xl66" width="102" style="width:77pt;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border:0.5pt solid windowtext;white-space:normal;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none">Relevância</td>
  <td class="gmail-xl66" width="79" style="border-left:none;width:59pt;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;white-space:normal;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none">Total Grupo</td>
  <td class="gmail-xl66" width="135" style="border-left:none;width:101pt;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;white-space:normal;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none">Nova
  Redistribuição</td>
  <td class="gmail-xl66" width="135" style="border-left:none;width:101pt;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;white-space:normal;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none">Arredondamento</td>
  <td class="gmail-xl66" width="142" style="border-left:none;width:107pt;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;white-space:normal;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none">Arredondamento
  para baixo</td>
  <td class="gmail-xl66" width="138" style="border-left:none;width:104pt;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;white-space:normal;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none">Arredondamento
  para cima</td>
 </tr>
 <tr height="20" style="height:15pt">
  <td height="20" class="gmail-xl65" style="height:15pt;font-family:"Courier New",monospace;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;vertical-align:bottom;border:none;white-space:nowrap"></td>
  <td class="gmail-xl67" style="border-top:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">0,90%</td>
  <td class="gmail-xl68" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">80</td>
  <td class="gmail-xl69" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>        </span>0,721 </td>
  <td class="gmail-xl78" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>          </span>1,0 </td>
  <td class="gmail-xl70" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>           </span>-<span>  
  </span></td>
  <td class="gmail-xl71" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>          </span>1,0 </td>
 </tr>
 <tr height="20" style="height:15pt">
  <td height="20" class="gmail-xl65" style="height:15pt;font-family:"Courier New",monospace;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;vertical-align:bottom;border:none;white-space:nowrap"></td>
  <td class="gmail-xl67" style="border-top:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">1,80%</td>
  <td class="gmail-xl68" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">80</td>
  <td class="gmail-xl69" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>        </span>1,441 </td>
  <td class="gmail-xl78" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>          </span>1,0 </td>
  <td class="gmail-xl70" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>           </span>1,0 </td>
  <td class="gmail-xl71" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>          </span>2,0 </td>
 </tr>
 <tr height="20" style="height:15pt">
  <td height="20" class="gmail-xl65" style="height:15pt;font-family:"Courier New",monospace;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;vertical-align:bottom;border:none;white-space:nowrap"></td>
  <td class="gmail-xl67" style="border-top:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">25,23%</td>
  <td class="gmail-xl68" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">80</td>
  <td class="gmail-xl69" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>       </span>20,180 </td>
  <td class="gmail-xl78" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>         </span>20,0 </td>
  <td class="gmail-xl70" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>          </span>20,0 </td>
  <td class="gmail-xl71" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>         </span>21,0 </td>
 </tr>
 <tr height="20" style="height:15pt">
  <td height="20" class="gmail-xl65" style="height:15pt;font-family:"Courier New",monospace;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;vertical-align:bottom;border:none;white-space:nowrap"></td>
  <td class="gmail-xl67" style="border-top:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">27,93%</td>
  <td class="gmail-xl68" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">80</td>
  <td class="gmail-xl69" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>       </span>22,342 </td>
  <td class="gmail-xl78" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>         </span>22,0 </td>
  <td class="gmail-xl70" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>          </span>22,0 </td>
  <td class="gmail-xl71" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>         </span>23,0 </td>
 </tr>
 <tr height="20" style="height:15pt">
  <td height="20" class="gmail-xl65" style="height:15pt;font-family:"Courier New",monospace;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;vertical-align:bottom;border:none;white-space:nowrap"></td>
  <td class="gmail-xl72" style="border-top:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:none;border-left:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">44,14%</td>
  <td class="gmail-xl73" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:none;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap">80</td>
  <td class="gmail-xl74" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:none;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>       </span>35,315 </td>
  <td class="gmail-xl78" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>         </span>35,0 </td>
  <td class="gmail-xl70" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:center;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>          </span>35,0 </td>
  <td class="gmail-xl71" style="border-top:none;border-left:none;font-family:"Courier New",monospace;text-align:left;vertical-align:middle;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-weight:400;font-style:normal;text-decoration:none;white-space:nowrap"><span>         </span>36,0 </td>
 </tr>
 <tr height="21" style="height:15.75pt">
  <td height="21" class="gmail-xl75" style="height:15.75pt;font-weight:700;font-family:"Courier New",monospace;text-align:center;border:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-style:normal;text-decoration:none;vertical-align:bottom;white-space:nowrap">SOMA</td>
  <td class="gmail-xl76" style="border-left:none;font-weight:700;font-family:"Courier New",monospace;text-align:center;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-style:normal;text-decoration:none;vertical-align:bottom;white-space:nowrap">100%</td>
  <td class="gmail-xl77" style="border-left:none;font-weight:700;font-family:"Courier New",monospace;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-style:normal;text-decoration:none;vertical-align:bottom;white-space:nowrap"> </td>
  <td class="gmail-xl75" style="border-left:none;font-weight:700;font-family:"Courier New",monospace;text-align:center;border-top:0.5pt solid windowtext;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-style:normal;text-decoration:none;vertical-align:bottom;white-space:nowrap">80</td>
  <td class="gmail-xl75" style="border-top:none;border-left:none;font-weight:700;font-family:"Courier New",monospace;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-style:normal;text-decoration:none;vertical-align:bottom;white-space:nowrap">79</td>
  <td class="gmail-xl75" style="border-top:none;border-left:none;font-weight:700;font-family:"Courier New",monospace;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-style:normal;text-decoration:none;vertical-align:bottom;white-space:nowrap">78</td>
  <td class="gmail-xl75" style="border-top:none;border-left:none;font-weight:700;font-family:"Courier New",monospace;text-align:center;border-right:0.5pt solid windowtext;border-bottom:0.5pt solid windowtext;padding-top:1px;padding-right:1px;padding-left:1px;color:black;font-size:11pt;font-style:normal;text-decoration:none;vertical-align:bottom;white-space:nowrap">83</td>
 </tr>

</tbody></table>



<br></div><div><div><font face="monospace, monospace"><br></font></div><div><div><font face="monospace, monospace">relev=c(0.009009009,0.018018018,0.252252252,0.279279279,0.441441441)</font></div><div><font face="monospace, monospace">n=80</font></div><div><font face="monospace, monospace">relev*n</font></div><div><font face="monospace, monospace">sum(relev*n)</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">ceiling(relev*n)</font></div><div><font face="monospace, monospace">sum(ceiling(relev*n))</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">floor(relev*n)</font></div><div><font face="monospace, monospace">sum(floor(relev*n))</font></div><div><font face="monospace, monospace"><br></font></div><div><font face="monospace, monospace">round(relev*n)</font></div><div><font face="monospace, monospace">sum(round(relev*n))</font></div></div><div><br></div><div><br></div><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><br></div><div>------------------------------------------------------------------------------------------</div><font size="2">Vanessa Felix do Nascimento Sergio<br>Graduada em Estatística - ICE/UFJF<br>Mestre em Saúde Coletiva - IMS/UERJ</font><div><a href="http://lattes.cnpq.br/2516291371035474" style="font-family:arial,helvetica,sans-serif;font-size:small" target="_blank">http://lattes.cnpq.br/2516291371035474</a><br></div><div><font size="2">(21) 97557-3956<br>-------------------------------------------------------------------------------------------<br></font><br></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div></div>