<div dir="ltr"><div><div><div>Estimada Mónica.<br><br></div>Esa función no está prevista en ABCD. Lo que puedes hacer es exportar los resultados a una hoja de cálculo trabajarlos desde ahí<br><br></div>Saludos,<br><br></div>Guilda<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Mar 10, 2015 at 8:21 PM, Mônica <span dir="ltr"><<a href="mailto:tnica01@gmail.com" target="_blank">tnica01@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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 style="border-collapse:collapse;border-spacing:0px;color:rgb(0,0,0);font-family:Arial,Helvetica;font-size:12px" bgcolor="#eeeeee" border=""><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 style="font-family:arial;font-size:10px" bgcolor="#ffffff">1</td><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">7</td></tr><tr><td style="font-family:arial;font-size:10px" bgcolor="#ffffff">2</td><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">1</td></tr><tr><td style="font-family:arial;font-size:10px" bgcolor="#ffffff">4</td><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">1</td></tr><tr><td style="font-family:arial;font-size:10px" bgcolor="#ffffff">9</td><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">1</td></tr><tr><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">Total</td><td style="font-family:arial;font-size:10px" bgcolor="#ffffff"><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 style="border-collapse:collapse;width:207pt;border-spacing:0px" border="0" cellpadding="0" cellspacing="0" width="275">
<colgroup><col style="width:64pt" width="85">
<col style="width:75pt" width="100">
<col style="width:68pt" width="90">
</colgroup><tbody><tr style="height:15pt" height="20">
<td style="height:15pt;width:64pt" height="20" width="85"><b>Exemplares </b></td>
<td style="border-left-style:none;width:75pt" width="100"><b>Total</b></td>
<td style="border-left-style:none;width:68pt" width="90"><b>Total</b></td>
</tr>
<tr style="height:15pt" height="20">
<td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">1</td>
<td style="border-top-style:none;border-left-style:none;width:75pt" width="100">7</td>
<td style="border-top-style:none;border-left-style:none;width:68pt" width="90">7</td>
</tr>
<tr style="height:15pt" height="20">
<td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">2</td>
<td style="border-top-style:none;border-left-style:none;width:75pt" width="100">1</td>
<td style="border-top-style:none;border-left-style:none;width:68pt" width="90">2</td>
</tr>
<tr style="height:15pt" height="20">
<td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">4</td>
<td style="border-top-style:none;border-left-style:none;width:75pt" width="100">1</td>
<td style="border-top-style:none;border-left-style:none;width:68pt" width="90">4</td>
</tr>
<tr style="height:15pt" height="20">
<td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">9</td>
<td style="border-top-style:none;border-left-style:none;width:75pt" width="100">1</td>
<td style="border-top-style:none;border-left-style:none;width:68pt" width="90">9</td>
</tr>
<tr style="height:15pt" height="20">
<td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">Total</td>
<td style="border-top-style:none;border-left-style:none;width:75pt" width="100">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 style="border-collapse:collapse;border-spacing:0px;color:rgb(0,0,0);font-family:Arial,Helvetica;font-size:12px" bgcolor="#eeeeee" border=""><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 style="font-family:arial;font-size:10px" bgcolor="#ffffff">1</td><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">7</td></tr><tr><td style="font-family:arial;font-size:10px" bgcolor="#ffffff">2</td><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">1</td></tr><tr><td style="font-family:arial;font-size:10px" bgcolor="#ffffff">4</td><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">1</td></tr><tr><td style="font-family:arial;font-size:10px" bgcolor="#ffffff">9</td><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">1</td></tr><tr><td style="font-family:arial;font-size:10px" align="center" bgcolor="#ffffff">Total</td><td style="font-family:arial;font-size:10px" bgcolor="#ffffff"><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"><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"><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 style="border-collapse:collapse;width:207pt;border-spacing:0px" border="0" cellpadding="0" cellspacing="0" width="275"><colgroup><col style="width:64pt" width="85"><col style="width:75pt" width="100"><col style="width:68pt" width="90"></colgroup><tbody><tr style="height:15pt" height="20"><td style="height:15pt;width:64pt" height="20" width="85"><b>Copies </b></td><td style="border-left-style:none;width:75pt" width="100"><b>Total</b></td><td style="border-left-style:none;width:68pt" width="90"><b>Total</b></td></tr><tr style="height:15pt" height="20"><td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">1</td><td style="border-top-style:none;border-left-style:none;width:75pt" width="100">7</td><td style="border-top-style:none;border-left-style:none;width:68pt" width="90">7</td></tr><tr style="height:15pt" height="20"><td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">2</td><td style="border-top-style:none;border-left-style:none;width:75pt" width="100">1</td><td style="border-top-style:none;border-left-style:none;width:68pt" width="90">2</td></tr><tr style="height:15pt" height="20"><td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">4</td><td style="border-top-style:none;border-left-style:none;width:75pt" width="100">1</td><td style="border-top-style:none;border-left-style:none;width:68pt" width="90">4</td></tr><tr style="height:15pt" height="20"><td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">9</td><td style="border-top-style:none;border-left-style:none;width:75pt" width="100">1</td><td style="border-top-style:none;border-left-style:none;width:68pt" width="90">9</td></tr><tr style="height:15pt" height="20"><td style="height:15pt;border-top-style:none;width:64pt" height="20" width="85">Total</td><td style="border-top-style:none;border-left-style:none;width:75pt" width="100">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>
</blockquote></div><br></div>