<div dir="ltr">Olá,<div><br></div><div>Gostaria de gerar uma estatística da quantidade de exemplares.</div><div><br></div><div>Usei uma variável Exemplares com o formato de extração:</div><div><br></div><div><span style="font-size:12.8000001907349px"> f(nocc(v949^d),2,0)</span><br></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">E gerei a saída do MFN 1 a 10.</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">Onde:</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">MFN 1: 2 exemplares</span></div><div><span style="font-size:12.8000001907349px">MFN 2: 1 exemplar</span><br></div><div><span style="font-size:12.8000001907349px">MFN 3: 1 exemplar</span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">MFN 4: 4 exemplares</span></div><div><span style="font-size:12.8000001907349px">MFN 5: 1 exemplar</span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">MFN 6: 9 exemplar</span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">MFN 7: 1 exemplar</span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">MFN 8: 1 exemplar</span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">MFN 9: 1 exemplar</span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">MFN 10: 1 exemplar</span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">Total: 22 exemplares</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">A tabela gerada no ABCD é:</span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><br></div><div><table border="" bgcolor="#eeeeee" style="border-collapse:collapse;border-spacing:0px;color:rgb(0,0,0);font-family:Arial,Helvetica;font-size:12px"><tbody><tr><th style="color:rgb(255,255,255);border:1px solid rgb(157,157,157);background:rgb(132,132,132)">Exemplares</th><th style="color:rgb(255,255,255);border:1px solid rgb(157,157,157);background:rgb(132,132,132)">Total</th></tr><tr><td bgcolor="#ffffff" style="font-family:arial;font-size:10px">1</td><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">7</td></tr><tr><td bgcolor="#ffffff" style="font-family:arial;font-size:10px">2</td><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">1</td></tr><tr><td bgcolor="#ffffff" style="font-family:arial;font-size:10px">4</td><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">1</td></tr><tr><td bgcolor="#ffffff" style="font-family:arial;font-size:10px">9</td><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">1</td></tr><tr><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">Total</td><td bgcolor="#ffffff" style="font-family:arial;font-size:10px"><strong>10<br><br></strong></td></tr></tbody></table><br></div><div>Para eu saber o valor correto da quantidade de exemplares nessa faixa de MFN terei que multiplicar e somar os valores manualmente:</div><div><br></div><div><span style="font-size:12.8000001907349px"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">1 x 7 = 7<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">2 x 1 = 2<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">4 x 1 = 4<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">9 x 1 = 9<br></div></span><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif">Total = 22 </div></div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif">Tem como eu gerar uma tabela no ABCD com os valores prontos das quantidade de exemplares? Exemplo:</div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif"><b>Formato de extração:<span style="font-size:12.8000001907349px;font-family:arial,sans-serif"> f(nocc(v949^d),2,0)</span></b></div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif"><b><span style="font-size:12.8000001907349px;font-family:arial,sans-serif"><br></span></b></div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif"><table border="0" cellpadding="0" cellspacing="0" width="275" style="border-collapse:collapse;width:207pt;border-spacing:0px">
<colgroup><col width="85" style="width:64pt">
<col width="100" style="width:75pt">
<col width="90" style="width:68pt">
</colgroup><tbody><tr height="20" style="height:15pt">
<td height="20" width="85" style="height:15pt;width:64pt"><b>Exemplares </b></td>
<td width="100" style="border-left-style:none;width:75pt"><b>Total</b></td>
<td width="90" style="border-left-style:none;width:68pt"><b>Total</b></td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">1</td>
<td width="100" style="border-top-style:none;border-left-style:none;width:75pt">7</td>
<td width="90" style="border-top-style:none;border-left-style:none;width:68pt">7</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">2</td>
<td width="100" style="border-top-style:none;border-left-style:none;width:75pt">1</td>
<td width="90" style="border-top-style:none;border-left-style:none;width:68pt">2</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">4</td>
<td width="100" style="border-top-style:none;border-left-style:none;width:75pt">1</td>
<td width="90" style="border-top-style:none;border-left-style:none;width:68pt">4</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">9</td>
<td width="100" style="border-top-style:none;border-left-style:none;width:75pt">1</td>
<td width="90" style="border-top-style:none;border-left-style:none;width:68pt">9</td>
</tr>
<tr height="20" style="height:15pt">
<td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">Total</td>
<td width="100" style="border-top-style:none;border-left-style:none;width:75pt">10</td>
<td style="border-top-style:none;border-left-style:none">22</td>
</tr></tbody></table></div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif">Obrigada.</div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-size:12.8000001907349px;font-family:arial,helvetica,sans-serif">---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------</div><div class="gmail_default"><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px">Hello,</span></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px"><br></span></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px">I would like to generate a statistic amount of copies in a database:</span></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px"><br></span></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px">I used a variable Copies with the extraction format:</span></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px"><br></span></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px"> f (nocc (v949 ^ d), 2.0)</span></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px"><br></span></font></div><div class="gmail_default"><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px">I generated the output of the MFN 1 to 10.</span></font></div><div style="font-family:arial,helvetica,sans-serif;font-size:12.8000001907349px"><br></div><div><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px">The number of copies in MFN 1-10 are:</span></font><br></div><div><font face="arial, helvetica, sans-serif"><span style="font-size:12.8000001907349px"><br></span></font></div><div><font face="arial, helvetica, sans-serif"><div style="font-size:12.8000001907349px">MFN 1: 2 copies</div><div style="font-size:12.8000001907349px">MFN 2: 1 copy</div><div style="font-size:12.8000001907349px">MFN 3: 1 copy</div><div style="font-size:12.8000001907349px">MFN 4: 4 copies</div><div style="font-size:12.8000001907349px">MFN 5: 1 copy</div><div style="font-size:12.8000001907349px">MFN 6: 9 copy</div><div style="font-size:12.8000001907349px">MFN 7: 1 copy</div><div style="font-size:12.8000001907349px">MFN 8: 1 copy</div><div style="font-size:12.8000001907349px">MFN 9: 1 copy</div><div style="font-size:12.8000001907349px">MFN 10: 1 copy</div><div style="font-size:12.8000001907349px">Total: 22 copies</div><div style="font-size:12.8000001907349px"><br></div><div><span style="font-size:12.8000001907349px">The table is generated in the ABCD:</span><br></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><strong><br></strong></div><div><table border="" bgcolor="#eeeeee" style="border-collapse:collapse;border-spacing:0px;color:rgb(0,0,0);font-family:Arial,Helvetica;font-size:12px"><tbody><tr><th style="color:rgb(255,255,255);border:1px solid rgb(157,157,157);background:rgb(132,132,132)">Exemplares</th><th style="color:rgb(255,255,255);border:1px solid rgb(157,157,157);background:rgb(132,132,132)">Total</th></tr><tr><td bgcolor="#ffffff" style="font-family:arial;font-size:10px">1</td><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">7</td></tr><tr><td bgcolor="#ffffff" style="font-family:arial;font-size:10px">2</td><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">1</td></tr><tr><td bgcolor="#ffffff" style="font-family:arial;font-size:10px">4</td><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">1</td></tr><tr><td bgcolor="#ffffff" style="font-family:arial;font-size:10px">9</td><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">1</td></tr><tr><td align="center" bgcolor="#ffffff" style="font-family:arial;font-size:10px">Total</td><td bgcolor="#ffffff" style="font-family:arial;font-size:10px"><strong>10<br><br></strong></td></tr></tbody></table><br></div><div>To find the correct value of the number of copies that MFN range I have to multiply and add up the values manually:<br></div><div><br></div><div><span style="font-family:arial,sans-serif;font-size:12.8000001907349px"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">1 x 7 = 7<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">2 x 1 = 2<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">4 x 1 = 4<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">9 x 1 = 9<br></div></span><div class="gmail_default" style="font-size:12.8000001907349px">Total = 22 </div><div class="gmail_default" style="font-size:12.8000001907349px"><br></div><div class="gmail_default"><span style="font-size:12.8000001907349px">Can I generate a table in ABCD with ready values of number of copies?How? Example:</span><br></div><div class="gmail_default"><span style="font-size:12.8000001907349px"><br></span></div><div class="gmail_default"><div class="gmail_default" style><span style="font-size:12.8000001907349px"><b>Extraction format (PFT)</b></span><b style="font-size:12.8000001907349px"> :<span style="font-size:12.8000001907349px;font-family:arial,sans-serif"> f(nocc(v949^d),2,0)</span></b></div><div class="gmail_default" style><b style="font-size:12.8000001907349px"><span style="font-size:12.8000001907349px;font-family:arial,sans-serif"><br></span></b></div><div class="gmail_default" style="font-size:12.8000001907349px"><table border="0" cellpadding="0" cellspacing="0" width="275" style="border-collapse:collapse;width:207pt;border-spacing:0px"><colgroup><col width="85" style="width:64pt"><col width="100" style="width:75pt"><col width="90" style="width:68pt"></colgroup><tbody><tr height="20" style="height:15pt"><td height="20" width="85" style="height:15pt;width:64pt"><b>Copies </b></td><td width="100" style="border-left-style:none;width:75pt"><b>Total</b></td><td width="90" style="border-left-style:none;width:68pt"><b>Total</b></td></tr><tr height="20" style="height:15pt"><td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">1</td><td width="100" style="border-top-style:none;border-left-style:none;width:75pt">7</td><td width="90" style="border-top-style:none;border-left-style:none;width:68pt">7</td></tr><tr height="20" style="height:15pt"><td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">2</td><td width="100" style="border-top-style:none;border-left-style:none;width:75pt">1</td><td width="90" style="border-top-style:none;border-left-style:none;width:68pt">2</td></tr><tr height="20" style="height:15pt"><td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">4</td><td width="100" style="border-top-style:none;border-left-style:none;width:75pt">1</td><td width="90" style="border-top-style:none;border-left-style:none;width:68pt">4</td></tr><tr height="20" style="height:15pt"><td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">9</td><td width="100" style="border-top-style:none;border-left-style:none;width:75pt">1</td><td width="90" style="border-top-style:none;border-left-style:none;width:68pt">9</td></tr><tr height="20" style="height:15pt"><td height="20" width="85" style="height:15pt;border-top-style:none;width:64pt">Total</td><td width="100" style="border-top-style:none;border-left-style:none;width:75pt">10</td><td style="border-top-style:none;border-left-style:none">22<br><br></td></tr></tbody></table><br></div><div class="gmail_default" style="font-size:12.8000001907349px">Thanks,</div><div class="gmail_default" style="font-size:12.8000001907349px">Mônica.</div><div class="gmail_default" style="font-size:12.8000001907349px"><br></div></div></div></font></div></div></div>