tag:blogger.com,1999:blog-36220188613902811292024-03-05T20:10:18.917-08:00Básico do ExcelEspaço para o apoio das aprendizagens dos alunos dos cursos técnicos em Administração e Contabilidade da EMEB Dr. Liberato Salzano Vieira da Cunha (Porto Alegre/RS), na disciplina de Introdução à Informática - Módulo Excel. Comentários são muito bem-vindos!Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-3622018861390281129.post-32017703964498268412011-12-13T13:54:00.001-08:002011-12-13T13:54:13.669-08:00Função SE e exercício avaliativo para BA2<div style="font-family: inherit;">
<span style="font-size: small;">A função condicional <b>"se"</b> é
utilizada para retornar um determinado resultado mediante a um teste lógico
referente ao valor contido em uma célula indicada. </span></div>
<div style="font-family: inherit;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: inherit;">
<span style="font-size: small;">Por exemplo:</span></div>
<div style="font-family: inherit;">
<span style="font-size: small;">1) Se NOTA DO ALUNO for MAIOR QUE 7,0 o aluno está APROVADO, senão REPROVADO.</span></div>
<div style="font-family: inherit;">
<span style="font-size: small;">2) Se VALOR CONTAS DO MÊS for maior que SALÁRIO, indivíduo está ENDIVIDADO, senão EDUCADO FINANCEIRAMENTE</span></div>
<div style="font-family: inherit;">
<span style="font-size: small;">3) Se JOGADOR fez mais que 10 gols, o atleta é GOLEADOR, senão PERNA DE PAU.</span></div>
<div style="font-family: inherit;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: inherit; margin: 0cm; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;">À <b>função se</b> são passados
três argumentos inseridos entre parênteses e separados pelo sinal ; (ponto e
vírgula):</span></div>
<div style="font-family: inherit; margin: 0cm;">
<span style="font-size: small;"><b>Descrição dos argumentos</b></span></div>
<div class="MsoNormal" style="font-family: inherit; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>Teste lógico:</b></span><span style="font-size: small;"> Verifica uma
condição estabelecida. </span></div>
<div class="MsoNormal" style="font-family: inherit; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>Valor se verdadeiro:</b></span><span style="font-size: small;"> Apresenta um
resultado caso a condição estabelecida seja satisfeita. </span></div>
<div class="MsoNormal" style="font-family: inherit; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>Valor se falso: </b></span><span style="font-size: small;">Apresenta um
resultado caso a condição estabelecida não seja satisfeita. </span></div>
<br />
SINTAXE:<b> = SE(CÉLULA>=7;"APROVADO";"REPROVADO")</b><br />
<br />
<b>= SE(CÉLULA>=7;"APROVADO";SE(CÉLULA<=5;"REPROVADO";"RECUPERAÇÃO"</b><br />
<a href="https://docs.google.com/document/d/1vZ9CWgiY3Ea4rN8CSkX4ZqC1DrWude-1-EmB60InmSI/edit?hl=pt_BR">
</a><br />
<div style="margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<a href="https://docs.google.com/document/d/1vZ9CWgiY3Ea4rN8CSkX4ZqC1DrWude-1-EmB60InmSI/edit?hl=pt_BR"><br /></a></div>
<a href="https://docs.google.com/document/d/1vZ9CWgiY3Ea4rN8CSkX4ZqC1DrWude-1-EmB60InmSI/edit?hl=pt_BR">
<span style="font-family: Arial, sans-serif; font-size: 10pt;"></span>
<iframe allowfullscreen="" frameborder="0" height="315" src="http://www.youtube.com/embed/uy64VOF1YYo" width="420"></iframe></a><br />
<div>
<br /></div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdHmctGkvnI5ZBuSKcNyNM1Awp3tJyghAs4BYY4TDP0z0W-GZW8WYB1hGVjI5VK1KVDZZmDaQrwZ6mpz0tme5Z0v93692Agl7Q9hplyPnVzbCpiMNQE0I7LDUpx36qJqR5nGP1wCaIeUs/s1600/exercicio5-ba2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdHmctGkvnI5ZBuSKcNyNM1Awp3tJyghAs4BYY4TDP0z0W-GZW8WYB1hGVjI5VK1KVDZZmDaQrwZ6mpz0tme5Z0v93692Agl7Q9hplyPnVzbCpiMNQE0I7LDUpx36qJqR5nGP1wCaIeUs/s1600/exercicio5-ba2.JPG" /></a></div>
<div>
<br />
<br />
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div>
<br /></div>
</div>Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-60450088967141597372011-11-01T01:56:00.000-07:002011-11-01T01:56:21.417-07:00Aula 10 - Gráficos<br />
<div style="text-align: justify;">
O MS Excel permite a criação de gráficos incorporados na planilha e folha de gráfico.</div>
<div style="text-align: justify;">
• Use o gráfico incorporado quando você quiser acrescentar dados da planilha e mostrar o gráfico junto com ela.<br />• Use a folha de gráfico quando você quiser exibir um gráfico em uma folha separada em sua pasta de trabalho.</div>
<div style="text-align: justify;">
Ambos estão vinculados aos dados da planilha a partir da qual foram criados e serão atualizados toda vez que a planilha for atualizada.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGAkfHfW9wRjDyacR28MBZL7Xi-44htTGTDrdb660-9rQw9Bw2bpi_84vAdHBa5cFkbrBgKWUrzXpHZQtoPXN24Lsg9tJrbkUJuKmJBxtEhoxUClygbvUkWTyjMbO7ZMij2lKRhoSv3mA/s1600/grafico-barras.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="186" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGAkfHfW9wRjDyacR28MBZL7Xi-44htTGTDrdb660-9rQw9Bw2bpi_84vAdHBa5cFkbrBgKWUrzXpHZQtoPXN24Lsg9tJrbkUJuKmJBxtEhoxUClygbvUkWTyjMbO7ZMij2lKRhoSv3mA/s320/grafico-barras.jpg" width="320" /></a></div>
<div style="text-align: justify;">
</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: center;">
<b>Usando o Assistente de gráfico para criar um gráfico</b></div>
<div style="text-align: justify;">
O Assistente de gráfico orienta você passo a passo na criação de um gráfico, através de uma seqüência de caixas de diálogo. Para utilizá-lo, deve-se realizar a sequência de passos abaixo:</div>
<div style="text-align: justify;">
<br /></div>
1. Selecione as células que contém os dados que criarão o gráfico.<br />2. Clique no botão Assistente de gráfico na barra de ferramentas Padrão.<br />3. O Assistente de gráfico exibirá, então, as quatro etapas para a criação de um novo gráfico.<br />
<br />
<div style="text-align: justify;">
<i>a. 1 de 4: selecione o tipo de gráfico desejado, através das fichas Tipos padrão ou Tipos personalizados e clique Avançar.</i><br /><i>b. 2 de 4: confirme o Intervalo de dados e/ou Seqüência e clique Avançar.</i><br /><i>c. 3 de 4: especifique o título: do gráfico, dos eixos categorias (X) e valores (Y), legenda, linhas de grade, rótulos de dados e tabela de dados e clique Avançar.</i><br /><i>d. 4 de 4: posicione o gráfico como uma nova planilha ou como um objeto em plan1</i><br /><i>e. Clique no botão Concluir.</i></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: center;">
<b>Trabalhando com um gráfico selecionando:</b></div>
• clique dentro da área do gráfico. Marcadores de seleção aparecerão.<br />• dê um duplo clique na área do gráfico. A caixa de diálogo Formatar área do gráfico será exibida. Altere Fonte, Padrões e Propriedades.<br /><br /><b>Movendo:</b><br />• clique na área do gráfico para selecioná-lo e arraste para o novo local mantendo o botão do mouse pressionado.<br />
<br /><b>Alterando as dimensões:</b><br />1. Clique na área do gráfico para selecioná-lo.<br />2. Posicione o ponteiro do mouse sobre um dos marcadores de seleção. Uma seta dupla aparecerá.<br />3. Arraste a seta para redimensionar o gráfico.<br />
<br /><b>Modificando o tipo do gráfico:</b><br />1. Clique na área do gráfico para selecioná-lo.<br />2. Observe que a barra de ferramentas Gráficos será exibida.<br />3. Clique na seta drop-dow do campo Tipo de gráfico dessa barra e faça a escolha de um novo tipo para o gráfico clicando nele.<br />4. Ou, se preferir, selecione o menu Gráfico / Tipo de gráficos... e você terá mais opções de escolha para a alteração do tipo do gráfico, através das fichas Tipos padrão e Tipos personalizados.<br />5. Clique em uma das opções disponíveis e clique Ok.<br />
<br /><b>Modificando o gráfico:</b><br />1. Acrescentando ou removendo legendas<br />• clique no gráfico para selecioná-lo.<br />• selecione o menu Gráfico / Opções de gráfico...<br />• clique na ficha Legenda e selecione uma das opções disponíveis.<br />• clique Ok.<br />2. Modificando a posição da legenda<br />• clique duas vezes na legenda.<br />• a caixa de diálogo Formatar legenda será exibida.<br />• clique na ficha Posicionamento e selecione uma das opções disponíveis.<br />• clique Ok.<br />3. Modificando as dimensões da legenda<br />• clique uma vez na legenda.<br />• posicione o ponteiro do mouse em um dos marcadores de seleção. Uma seta dupla aparecerá.<br />• arraste a seta para redimensionar a legenda.<br />4. Acrescentando ou removendo linhas de grade<br />• clique no gráfico para selecioná-lo.<br />• selecione o menu Gráfico / Opções de gráfico...<br />• clique na ficha Linhas de grade e selecione uma das opções disponíveis.<br />• clique Ok.<br />5. Acrescentando rótulos<br />• clique no gráfico para selecioná-lo.<br />• selecione o menu Gráfico / Opções de gráfico...<br />• clique na ficha Rótulos de dados e selecione uma das opções disponíveis.<br />• clique Ok.<br />6. Inserindo ou alterando títulos<br />• clique no gráfico para selecioná-lo.<br />• selecione o menu Gráfico / Opções de gráfico...<br />• clique na ficha Título e digite um título e um texto para os eixos se achar necessário.<br />• clique Ok.<br />7. Modificando a fonte e cor dos títulos<br />• clique com botão direito do mouse no título que deseja formatar a fonte.<br />• um submenu será exibido.<br />• clique na opção Formatar título do gráfico.<br />• clique na ficha Fonte.<br />• mude a fonte, o estilo, o tamanho e a cor.<br />• clique Ok.<br />8. Modificando o alinhamento de títulos<br />• clique com botão direito do mouse no título que deseja formatar a fonte.<br />• um submenu será exibido.<br />• clique na opção Formatar título do gráfico.<br />• clique na ficha Alinhamento.<br />• faça as alterações e clique Ok.<br />
<br />
<div style="text-align: justify;">
Fonte: <b>Apostila Básico do Microsoft Excel 2003</b> - Escola de Artes, Ofícios e Computação - UNIFESP - disponível em: <cite>www.unifesp.br/proex/dac/eaoc/apostilas/excel_2003/apostila.pdf - <span style="font-family: inherit;">acesso em 29/08/2011</span></cite></div>Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-57042526648502913762011-10-22T14:04:00.000-07:002011-10-22T14:06:30.801-07:00Aula 09 - PROCH<br />
<span style="font-size: x-small;">FONTE: CadGuru Curso Excel 2010 - disponível em: http://www.cadguru.com.br/cursos/curso-de-excel-2010/6-funcoes-de-logica-e-pesquisa/6-6-realizando-pesquisas-com-a-funcao-proch/ acesso em 22/10/2011</span><br />
<br />
<span style="font-size: small;"><span style="font-size: x-large;">Exercício: </span>transformar a planilha que usamos no PROCV para o PROCH, eliminando as colunas endereço e bairro. Deve ter esta aparência: </span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7ha87aHLeHECMpSxGctWIjIRLpmgwpPFC06i65IsEH5svvYoviAom08HNP_NZA-r7f1GG96NDV77pTkCgcmpsD6rjkriVkX9QDZDBuOxy6syLuEK2lDdTRQ9io7N1-GYhNRF3h-XlbPo/s1600/telaexercicioproch2.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="217" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7ha87aHLeHECMpSxGctWIjIRLpmgwpPFC06i65IsEH5svvYoviAom08HNP_NZA-r7f1GG96NDV77pTkCgcmpsD6rjkriVkX9QDZDBuOxy6syLuEK2lDdTRQ9io7N1-GYhNRF3h-XlbPo/s640/telaexercicioproch2.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: small;">
PLAN 1 - renomear para CONSULTA </span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="font-size: small;"> </span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiobxARkamoo5GWHNUr5Dy4rD4zHx-2q5LctESsYUGj4FHaXRiqv33z_gLMDS4IytKd91yIRbDCHCKmZJZ2-TAvkgmPxoXBKlOPDDme1MISYRe1_DJKruJ0PA-TfV6-7TJEmTamt-eUY-M/s1600/telaexercicioproch.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="126" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiobxARkamoo5GWHNUr5Dy4rD4zHx-2q5LctESsYUGj4FHaXRiqv33z_gLMDS4IytKd91yIRbDCHCKmZJZ2-TAvkgmPxoXBKlOPDDme1MISYRe1_DJKruJ0PA-TfV6-7TJEmTamt-eUY-M/s640/telaexercicioproch.JPG" width="640" /> </a></div>
<div class="separator" style="clear: both; text-align: center;">
PLAN 2 - renomear para BANCO DE DADOS</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiobxARkamoo5GWHNUr5Dy4rD4zHx-2q5LctESsYUGj4FHaXRiqv33z_gLMDS4IytKd91yIRbDCHCKmZJZ2-TAvkgmPxoXBKlOPDDme1MISYRe1_DJKruJ0PA-TfV6-7TJEmTamt-eUY-M/s1600/telaexercicioproch.JPG" style="margin-left: 1em; margin-right: 1em;"><br /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-79142848770017529532011-10-20T08:03:00.000-07:002011-10-20T08:12:25.174-07:00Aula 08 - Função SOMASE e Função CONT.SE<div style="text-align: justify;">
Use a função <b class="bterm">SOMASE</b> para somar os valores em um <a class="glossary" href="http://www.blogger.com/blogger.g?blogID=3622018861390281129">intervalo<span class="AsstInlineDefText"><span class="ACICollapsed" id="divInlineDef_748012010_2"> (intervalo: duas ou mais células em uma planilha. As células de um intervalo podem ser adjacentes ou não adjacentes.)</span></span></a>
que atendem aos critérios que você especificar. Por exemplo, suponha
que em uma coluna que contém números, você deseja somar apenas os
valores maiores que 5. É possível usar a seguinte fórmula: <b>=SOMASE(B2:B25,">5")</b></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<b>Veja o exemplo - <a href="https://docs.google.com/spreadsheet/ccc?key=0AjcieE70bZZddFc1eU1wbXpkTUhrTGpYb29KNVRDaGc&hl=pt_BR">Exercício 1 Função SOMASE</a></b></div>
<div style="text-align: justify;">
<br /></div>
A função <b class="bterm">CONT.SE</b> conta o número de células
dentro de um intervalo que atendem a um único critério que você
especifica. Por exemplo, é possível contar todas as células que começam
com uma certa letra ou todas as células que contêm um número maior do
que ou menor do que um número que você especificar. Por exemplo, suponha
uma planilha que contenha uma lista de tarefas na coluna A e o nome da
pessoa atribuída a cada tarefa na coluna B. Você pode usar a função <b class="bterm">CONT.SE</b>
para contar quantas vezes o nome de uma pessoa aparece na coluna B e,
dessa maneira, determinar quantas tarefas são atribuídas a essa pessoa.
Por exemplo:<br />
<pre>=CONT.SE(B2:B25,"Nancy")</pre>
<pre> </pre>
<pre><a href="https://docs.google.com/spreadsheet/ccc?key=0AjcieE70bZZddFQ5TTFYdDI3dS00eVZPVTNPR0hhMkE&hl=pt_BR" style="font-family: inherit;">Exercício 2 - Função Cont.SE </a></pre>
<pre> </pre>
<pre>Fonte das explicações: Página de Suporte do Excel da Microsoft, disponível em: </pre>
<pre>http://office.microsoft.com/pt-br/excel-help/funcao-somase-HP010342932.aspx e </pre>
<pre>http://office.microsoft.com/pt-br/excel-help/cont-se-funcao-cont-se-HP010342346.aspx</pre>
<pre>acesso em 20/10/2011.</pre>
<pre> </pre>
<pre> </pre>
<pre></pre>
<pre></pre>
<pre>vÍDEO EXEMPLIFICANDO A FUNÇÃO CONT.SE:</pre>
<pre><iframe allowfullscreen="" frameborder="0" height="315" src="http://www.youtube.com/embed/XMC6qppAZjM" width="420"></iframe> </pre>
<pre> </pre>
<pre>VÍDEO EXEMPLIFICANDO A FUNÇÃO SOMASE: </pre>
<pre> </pre>
<pre><iframe width="420" height="315" src="http://www.youtube.com/embed/pm1udUqjZis" frameborder="0" allowfullscreen></iframe> </pre>
<pre> </pre>
<div style="text-align: justify;">
<b> </b></div>Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-3356036130461432752011-10-16T13:31:00.000-07:002012-06-19T14:03:22.435-07:00Aula 07: Formatação Condicional<div style="text-align: justify;">
Esta formatação aplica formatos especiais na planilha, dependendo do seu resultado. Para utilizá-la, deve-se clicar em <b>Formatar, Formatação Condicional...</b>, uma caixa de diálogo abrirá:</div>
<div style="text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiTo9bvvQSWZAxkdwamlpygu5YTXbA4pbJ5iyXzyWwvPrrqf1XP458VBjo27e5Q_QFcsfy2ii7tmNyG8JbFvyAvriBfEOxuBXT6MMKURc857xYKBGDApUh7Z_4kGQF5Z4_8xEtancr3Rc/s1600/formatacaocondicional.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div style="text-align: justify;">
<img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAg4AAADACAIAAADjpHyDAAAgAElEQVR4nOydd1wT9//H30Bbbfv7fr/dtXtXra21Vq1177pBtuwle4g46sAtuK17b8WFKLJlhzACJIwkd5eEFcjekEASMj6/P0BrN21tlfZej+eDx/HJ5+4+985xz1wuOQCRIUOGDBkyvxp41AMgQ4YMGTKPe0hVkCFDhgyZ3wipCjJkyJAh8xshVUGGDBkyZH4jpCrIkCFDhsxvhFQFGTJkyJD5jZCqIEOGDBkyv5G+qsJqtbaK9E4JzTYz6uwWYXYLG+zsG55c1PCUY8NTrvwBHoKBfuKBQdKBAZKBwfKngxUDA+QDA+QDlygGBioGBioG+isG+ipJ+jOqgX4akv6MYqCfnKS/4qt42k/5tJ9yoJ/yaT/1037Kgb7KgX7KgX7KgR7KgYsVAxfLBroqBrpIB3pIBrpIB7opBzorBzhJBywSDVgoHrBINMBJ+qST/ElHle0kgeMGfmtrp9VieciqMFusy0+JYBb7CT/ZgGXWF9ei1zejt7agD3egYXvRF/vR2ENo3EE0/giaeBRNPo4mH0eTjqGJDzDhKBp/BE0g6c9MPEbSj5lwlKQfM/4IGn8ETTiKJh5DE4+iCUfR2ANo7H701QH09WE05iAacwCNOYDGHERj9vdOjz6APt+LPtv9PR8kone2oufXoScCdTCGtfw7odncV1v8tip0XealR4UwgwO+Cpvw9idi9M/GGf+zwvjcWtOL8ZZXN6FBW9Ab29Cb29CbCejNBPT+DvTODvRmAnorAb2egF5PQG8loLe2oTcT0BskJCSPiNe3ote3kPRbtqJBm9GrW9AbCei1BPTqNvTKZvTyOvTKauug9eaX400vrTG/uNr84rfml1aZXl5tfmmN5aU1phdWd/9vZff/Vhj/t8L4v5Wm/4s2PhttfCbaaBfRDQF6+Jq79KBMp39IqtDoTDCWBvYc8GoBPyH4CcFfAkEyCFVBuNY2Wg/RBog22kR328R0Q7TRNqYbYowQ3W0b0w3RBog02kYabSOMNuEGICEheVSEGCCYpN8SZoBQA4TpIdwI4XoI74JwHYRoIaAdvFTgrICFCpgvg7lymCuFuXKYJ4O5EpgngnlCmCOA2QKYLYCpfJjaCHOawbEVFjXDVCa8R9Fo+3Ri8duqcFzFgdn1YF8Pbo3gwgP3RvDkg68YAqSwRG4TqrQJVdqEqW0iOmzCtTYRWpvwdpswdS8hSpsAjU2AxsZfbeOrtPEh6b8obHzkJP0YX5J+jo/Mxvs+Uhsvic1iETgLRq6S7ssxXCw3XSw3XSw3XyzrwXSxzPT9RKnpEtV4saT7WE7XZwFcmECHSQwYXQFDcxwDih+OKuCjfBhPg2/oNotwcOSCexN4toCPGAKkECizWSLvAUJUvQQrbZbIIVBmEyADXyn4yMBLCh4SWCwGd5J+jYiEhOTR4CYEFwG4tIGLEFyE4NIGTgKYzx8dJ6KVNqGMk+jyNnRmPTq+2nokzno4znpoqfVAtGV/tGVfhHl3iHl3sCnBTx/voj268m4O8ZknG4ZTYXg+fJIGA08+JFV8nAyjKDCz2saeDU48cG8Cz7afqsJmidwmSA6BUgiQ2vjKwEcCPmLwEIOHGBaLwV0ErgJwIem/CMG5jaQf48Qn+Sfg3AZObeDIBwc+zGy8VqJD2ac0Rzeqjm2Rb18qiQ+QrPQUL3MTxziJohxEEQtFIXOEgdPbfCe2uXzZNPv9qgkv8/bG7b6qgo+KYUgevH8NXtj2kFTxejKMKrGZQrdZgIELDxY3g6cQfCQ2/jIIkIK/1CZIZhMkt/GX9bTY+MnAWwqekl5P9CjRlTzQkJA8Uh75MY7kz+DIh0Ut4MAHRz44tIIDH+xbYEZjNkOPLm5Rn93VnnxCeWyLLDFKuiVCuiVcsn6JdG2AdLWvZKWXKNK+LWCaMHBGq+fX5eNeqY+zv1rUCe+XwkcUeP86PL/hIaqCCtPqYQEXXJvAUwBeYnASg7PkHlLwkdn4y2y9e84npOAjBS/pD1Uhunfe9FfiLIR5bTC3DRwFMF8Azn2YxV4As9vgmzaYLwCnP7rSuW0wXwBuQrAXwJw2cBKC6y93+8Nb5yoERyHMbgN7wc8s/+8or4CkP9NK0o9xbAOH1u+xb4UFfJjaklZlsJ5co/hutepUouLgOvWl/bLEpaIYZ3GsmyjSQRS2oM1jnHi5uywhSuA7qcVlZMWkN1jful4u0sNHFfBhJXxwG57f+JBU8UYajK6E6WywbwTnNnATDfSX+p/siE7qXJ9pWZ9hWZ9heXd1F3jLbX2ktt5SGx+pzY/OKtz+qCfmC2Ben4+tTkI7N6HjbpXX4Y6nvcRzE1XP+il+4+g/t21wjDT2km7tDcOsbeqBXpI+2eWHAhjgIXLeo5q+RQ32kpErpD6H1M8F/mS9zsIn3ISOu5UztqrBVfq719KDo/AFf7H/EfWIb1XgKOl9U4iEpI84C8GJpN/iKAQHATi0gX0rLGyFBW0wvxWmNqdVGSxHlku3hMkSojTXjiKEDKxqcZRzm980QeDMVscRAp+JemYVQki61rdpzoe0KW+x1yy+XGiED6vgQxp8kArPb3pIqnirEMbWwTQOODSDixCcRS+HyRBCHQr1rsTs73Zmfbczc/DcW7aurbb+SvCS2nhJbb2ltl4S8BCDuxjcxL2qcP4hLg9MuAh/0MGl9+fcRKXXIQ04S35m3p/OMr9t5lZlYa32clrzzTJtEkX3/KxCWNT2MytyEYKrEOa1LUxU1LVarmc2njtXWlUjnrW6EeY1g4voxyv6lbUvFLy2RGK2oNwSAQwtSUzTI2QZ6VsOc5p+sBxH4TOeIoHKWlAhgQll4Cr5tW35pQ2c1zZ5gxwhlHCCDV/TwU366I8+JP2IR36wI/kzOAphkRAWCWFBWy/zW2FaS1q1wfRdtGSNr3RTiGLPt93NBEJIX0cTBH3T6vCZwGeivp6GENIzSoT+k5oXfEyb/CZ79eLLhUb4gA4fVMEHqQ/vrOKtAhiLwYwGWNgCziJwFr8YqkAI5eWwYOBu+IoKowvsphbbeYvBRwFeclgsBw+5rbfc1ksOrhJwloCrGNzE4CQEBwE43tOjowCcejZe8MCuLOptWSR40l3IV1lYuBRG54GbFJwE4CQCRxE43HunyFEAiwTgKIJFQnASwiLBR7GqzxaXvDwl3XMNffDki3YjU3rr2/PT6YE/GwfBsChJg8zCqm99afhx+CJzclTtkBnXbWbUgLP03iwCcO5520fwg5H3LMdZCIsEME/weogUIZSZSoe3Lr4X1zknpOiloQdhHhecJL2zOArBWQiu4vHfCsbOPmc3/Dq4yn88qu+LI/rBKnpq4iAERyHMbftmqwIhtHlzBnySAR6KR3/0ISEh+Xu496LznifaYG6PKoymfZHiODfphmDxUlfpmgAjl4UQ6qqmCMPmGFjVCKGuyvy2RUNbpr/OdxxWOel19hq3y4Xd8H49vFcNH6Y9xLOKAviKBbOawEkA7hJwlbwYqrQiVFqE/fer28+tRk9Hd0Ow/v9CNQnpXWUNpnSGYewGDbgoBvgp7zCM+SzjsfxO1++UwcfVBzM7j+fpqbh+/XXt/O3ttyr1pbjecbfaZpHsOT/5xeLOHLo2vbrLea8GnGWnC/QIoS5d14aTTTBN6Hu4/S6jM69Gtydd93aYHBZKP12mPJmvL8EMaVWd0zapYZ5k5Lfq1GJJRon4QIpkuH89zGt7PURxtkhfShjOFHS+HiyHRVJwkYKLFOZIos9qEUKxqzJsPrkKjlKYJ4SZGMxrXbSrvRgzlhH6sJPt4CSFudKYcx3JFfob5fpSXL81RftKkAycZLBQEny8o5TozmZ0IoTOX6bb+9zKY5mzqZL3vXFwEsdd1OXVG0vxrmXn2gd6yI7ndmXTdXsvNdpM5Y5eo05nGEsJw5Zk7VOLpTBHunC7Oq3acL6oi4rpj9/t/DhaAfMkE+JVd2u77jK054s6R65UwhzJjM1qhNCmLVnw6V3waO/dFhISkn8JPS8l7YUwTwjz22B6a1p1d/fOYFHEQslqX8lKb2HoAvEKDwNRgxAyifkIIT0tX+DyKX/6y20LPmi1/7hqwqvYapfLBSYYzIJhdTAkF57f/JBU8V45jOPCXAE4S8BdDu7yFyPUWoO1vV1fViWsqJPP3SKw8VAlZptEcn3MusI76ew6nvbjsFYbT2VnNzJ2dMSuLxg2N/XA2XqE0I7TeOiqXLPFcpfROc6HWlTa2tFpHhLABXv5mFi+m99VSjG3Q2/5MpL3Ybi0y4I4HMm7w/fBl4WDogxzgws3bc406o0HUqRveDeVcCx0lnKex82j52qXbquEaXXP+Gunx9SFR6eIRZoSzPCmd+MNmonJUQXFZDFqBLcoiv95CsBZAe5ymCNNTO1CCM1adAHGVsBiFbgrwFE1fUsHX2k9fYW9fluhVNYZsKsVpkkO3TUghJZvK49ak2fUGzedbYPJjQt26pQ6dOZy7VyXywih27dqXhx8PaUWIYTGO95acUoqazdHrSuOWpN79hr79YVlQ2OkCCE6Q/DRjFR6myWrkB+xIru1TbPtkghmiQKO6RBCB8+zXJekKRXaa/lymM19JkA7I5IeEXVDLFSVs7Q23xBTNmt6VTE8D7y04Cb/W3GRkZCQPDrk4CiHRXJYJAcHGSwSwyxhWnV39zY/YeBMSZy7JG6xKNZV4DtZssbHpBAjhLr5XHHg+LYZLwrt3xMueLtt4XvV417AVjpdLjLBMAI+Y8PgbHh510NSxftVMKEB5gnBRQKeCvBUvhihtVpRWVnTix/seX3M2f8bdvJpDz6/EzVzhfDSwfAjQoSszrElML9RYUQ8rO2Jd4/AaPq+mzKE0JiZZ/8zrQghlJfDhP+e3ZveiRAau+DaOwGt1yrMJdXihgYZQsghIA2mYjorqqniwZun/+vVHnuxq5ytLavgI4slp6h5rl8GQih25R14/YKdU9uz4+8OmF69aF9XIVNfXN6qUXcqlJ0TnJIRQleuVsN/Tlwu6kDINMQhDxZKYLEG5ioTbusRQpPnnYWpBHhpwV0F85RbbhkQQuNmn/vP1EKErOm5jTCkZFeWBSH05fQzz86uRgjl5HLg3awdWVaE0JdTT/1nci5CKONODbx8bV8+QghNn38ab+pgsQQwaB/MJp6dw7Abk/Okm6TLivLyiEVeVxBC4Utvw3vJzXIzn6+AEXmLD+kRQkERKTAku1VjFbXKnx552+G7riKWobi8tV3T2dmue2r4tckb2++pIh+8u8Bd9beymKQ/464m6d+4asClHVzawVkDjgpYpIDZyjSG2bjRQ+AzSbzUWbzMTRQyV7LczcCqQgiZ5SKEkL48S+zysfCbF0QL3xQseJP+1f/hK+wvFyP4rAGGcWFwIbzy3cNSBRMmNcN8AbhLwUsJHu0vRekRQsV5TPj4GoQhCDY+E2lUGlEjmw+vngm8jBBCXkuSYTpTYUI8VgsMvgCLjHuzzQih0TPO/ncxHyGUncaA167vK0AIoWnzz1YyVSJp5xtfnI/YUIoQWuh2GWayOhGqq+bBW5cDzyOE0NqdFc8OO6PTm+7m81x9ryCEAkOvwSgaLDbB/I7RGzq7LehWVuNTbx/LKxN16gyTZ59CCF04Xwov3TpDQwhZh089B/Zi8O2CRR1RFw0IITe/6zCXD956cOqAue17s7oRQiOnnbZ1aEIIFeUx4fXru3IRQmj0zLP/cecjhHIyauC1aweKEELok/Enn/NsQwilp9LhjeSDxQghNNP+nFqlo1c2wrvnwMsEjlpw0/5nia7LgnLzOO7+1xFCgaHX4XNaQztSiqTwzvnFR7sRQsERyTC2ukWHOLhw0vzzRitKzmh46u3jBRVii0H/xIcnJm/R9qriiyIIMIG39u/DSwseJP0Zd5J+zuJ7uHaASzs4tcPc9jSG1bDOudV9jCjSXhj8jWTFYgNRixAy1JdJ4+yN3FqEkJ6aJnV+Tzzz/4TzBjG+fJJYNv9yCYKRfBjZAkOL4NVDD0kVH7BhYivMk8BiJfi2g6f2pRgjQoiSz4RPk21ikG2YaUBkdykfCZrEb028ub0AmY3GWfZn4BuWwox4rBa7oZfAxbwvx4IQGjPr3HNeAoRQdnoNvHnzuyKEEJq24By7sYNV3zrg7RP7szoRQl5LbtrZNxgQYpQT8NzZkCsIIWTvdul910qEEJXaMNfrVqcVHTxYAFPYXyVax2+xjkmwWBHauSv3uS9ScRkyaDunL7os06HMtNpBE/JzGpBSJv9g9DFwVtgEdINn17A1xia5tby0YaBrM3joFx0yDVlpCb5gQQi5Btz8YrkEIXTyeCG8lbwrH/WM/L+e90b+1s2VqQghtMg35WlPKUIo4zYd3kw5VIIQQlPmn8tndAhbJC9MynwhxuJ0xPJ8tHXgEkOXFRUWcqY4Xe1GaNPW7LddWGI9Ki1mw1tnPE5YEEIhkTdhfA1fhwhMOGXBBYRQQuLd50emceTIqte9NPrS1O0GhFD8+nT4nALByMZP//fhqwcvkv6MN0l/xksPnvdYrAN3Lbi0wwJtWo1Vv2oB33G4wH+adF2AkVOPEDJg1eKImUK3YdKwSd1ENULIWHlX7jlUNO0ZxnAgYmZfpiIYLYaxrfB5CQx6WKr4mIBJrbBACp5qGz8teHW+stSIEGKUETAs2S4WPRlhtouwTP/OXMNW1OKqFi3atrfkuQ8PPukpMSEkaRbYDr0EruhooQUh9PXs8895CxBCJQUseOPmsTKEEBo/98KktaIaluzqXdG1KpPFivYdoDy1iHupytKt04bvbh4Ugc4XttMrG0/kG5ql3aIW8Si3vOWXVfW1becp+noxWrKD86wDb93NLqy26USOprTBaDXqncNyvA8oeDxpFUeHy1BA2M2BQ8+Ctw4CzeBvBO9ul4OdtWxpZrnqBgMxms1z4upf9BBeLulqbhA3yFFGifjTrw7AF9RDFIQQ+nrO+f953Rv5hzffXYXyajtbW+TnSy0IobysOngj5TStp+eFEXGi8lp5XqWitAVdL5C/4FAzwK8dIYTVNv3ns6sJmUZ+g6iOb6rAO6fPOwWD0wLPIYRQZOxtGF+jtiC1WPa/zy+sS+nCaptP5LSXNRpRd9cc/6y3ojR1QpR+s+JFBzYEIggwkpD0FX8T+JH0W3y7wccIPt3gYwRvPXjqwb0LFurTalDnsm+a537U6jpKcWAdQsjAqhKFzxb6fCUOGi92+0geNKrHFurl34i+BsZQwCNnXC5DMFYOk6QwkgGvHnlIqnifBZPawEEOXhobP51NgOHpKIvTPtWMGQeeGpXy1Er01FLLk0stEGMZs0UTuIbi4HL+v8OOw1zmE7GWeQe75tufeOrTizZh6LPtVpellEHvbRsQqHHcp5k6Ze+TX6QN34tcYopefT8B3FTjtmgXx+QNn5cyN7b6qxmnn5pFe3W52X0jNs/1IkymP7+8y2MrZ5rT9TF+1PmBGS+MvGjnJt+R1omzBQHhN//36UlY2GAXYbTfJljgc+tz57sLIinvjjlp48yftlkeFJs5bd7pJ4ecBedW23CLbZjFNsxsE2KBoO5hsaLgdaXhYUmT5p1/fsw1cBS9usLouRkLWHLlozHH4MtMG3/dZ9uRy1LKoPe3PXV/5KPvQCh6b7XRZ12V/5IrroEpkyd/98TIjM/3IZfoolc/SAR39eBV7b5ryoPDrg39+qjNxIKnwg32+3Wz5x62/eTaM8tMjpubgsJvjpx8HD69ZuOpfnsjcl7HHDJks509b/Zhq73LWduPz9hFGh0SBAt8UkY4586PKP7gq5M2roJPNpjm+GW+MOOubaDeNtxiG2omIekLEGSBQJL+ixmCzBBkhkAz+JnA1wTeJnAypdWjzqhpzdPfaHUbJVwyU7E7ThzjIHAfKfIfJ/YdJfEeLln4qiLsa/VaR9mCl0QTn6B/BFj41MulCMYpYaICvqiDQQ9LFW/XwSQBOCjAu8PWv8s2yGAbZgKfTnDgDQxWPxVnHbDMMmC59akVCKLM4C4EB66dn/TJOGQbh2CJCeybnwhQ2i1FEGoFB7GNS6tNuBW8jDC/4YnAdgixgoPIxrXVNtwKARawbwMnAbgowElgF9gBwVZwUcI8jp2fAsIRuGnAvhlc5eAotvGQQIDl0y2oDO/8ZEEaLGi2jbBCBAKvLljYDK4ScJKCmxCCu8HXCAv4MK/BxldtG4VsI5BthLUHCEcQaAZHCcxpgIVNNj4q2wgrhCJwVcGcBnDk24UYbaMRBPeO3Pb+yAM0tlFWCEbgJIN5jTC/GRY02v1oc5ZYwUkKcxvBscUuWG8TicC7G+Y3PuGngggEHlqY1wT2TbZBnbbRCMKs4KKERU12oUbwt8L85id85BCBwLMLFjaDS+/m2IYYIdACLjJbL5ltmPnBbfk7CCfp54SR9G8g2AJLLL3W9zWDmzWTjdqDv+Z+/Vyz/bBmpxEtCz/hOw1vdf+y1W1Em+swofNHwkXviGb+TzjBVjT5qdZxduXvAHPJhGuVCCa1wyQVjKyGQYcfkire+l4VNv6ddgFddiFGu3DTU8vQgGVoQKylRxW9rEIDVqOnVqKnlqEnliG7OGS3AtnFIrtoZBeFbJci22XILgrZRSPbZch26QON0cguGtnGIttYZLsU2cYiuxhkF4XsYpDtMmS39N50z6NLkW0sgmAUlYxSS5XvTbgAgV29faJ/0Of7xd5b3Y+J7h1Az1w94+xZ6fdj+IWR97bH9i7f7keb88Cjvct5cN6Ye6O6t4reLe2ZMfZet59uTlTvr71D/duIRI/+SEfyJ/k7X1iQ/BX02KJHGAEW8LCeKkGSeI+Kz54s/eL/Ksa+XDFuUPm4VyvGvVw57qWqr59jjP0/xqgBNSPtaoZDzVCofB9y3wHOtsBTxVaYou1VxUP7BFSPKhYpwLPdxltn69dlG2iwXWJ4IsT4VIRxQJRlQLRlwFLLgFjLgFjLU0utTy61PLnU8sRSq12s1S7WahdtvXegsTx0nllmfXZG0YCJObahRtsI61+xCpLvedQvqUhI/uX0nlIEmWGJGQLM4GX+ekM3tZDdsMmnOnByXdjMmohvGOHf1IZ/Uxc+qz58BjtsKhYyGQueyA4ajwV8Xec9lhnvczePO3JpJ8xsh0lKGFkNr+x7WKqohckCcFCAuxI8VOCptvVpt/XrsA3stA3RPxFmfDLc8GSE8clI05NRpicjzXaRFttIi22UuZdIq004sg2z2IaabEMeMrDEBMEWm1CrbYj5oS+c5EFsgs2wBJH0Z6wk/ZggKwRZwd8CvhbwNYKvEby7wbMb3Ixj442XKlAyAyVXo2Q6SmagZAa6wUA3qtGNKnSD/sB0JTqQiUZEdcKsDpijgUlK+PLhqmJiK3wjgrk8mM+BhTxY2ASLmsFFCK4im8ViGw+JjafUxlth46W08VaBjwb8NOCrAV8N+GjApx0822GxBtw14PZX0A5u7X/Nkkl+VOcOkn6Ms5qkf+PaDo4acFCBgwLsFbBQBfYqWKiAWTKYJIdJcpgoh0kymCKDKXKYIodJUhgvhslSmCyDcVIYK4XRIhgjgq+FMFEIU8QwUQVf0uGVvQ9JFW/WwthmmNgKE9gwpgrG0uFrOoxjwIQ6mFAHE+phIhMmMmESCyZiMIkNE9kwiQUTe2D3TkxgwwQ2TCTpz0wg6c98zSTpx4xjwgQWfM2Cr5nwNet7xtbDmHoYUw+je6iDMXUwuh7G1MNX9x4aUwejau9RB1/Wwpc18AUOXwjhy6qH9r2KAV9ybBzE01c1plGIK9nsqznsKznYlRzsag77B2SzSP7ZXCHpzzzy/YfkT/Lzz2xOH2F/z132lbusdAoxJbQR3s2Flx/SG1DPTmyy8ZQHHeAhRJh1nPuYfgEzCQkJCcnjDUKE39YGeC0DXnxItwt8ZnyjzWKZzx6eRUcopCQkJCQk/R5rF+GxoQFez4QXd5OqICEhISH5GUhVkJCQkJD8BqQqSEhISEh+A2sX4bGhEV5Le2jXKp4lVUFCQkLyz8LaRXhsbIJBt+CF/qOKdgWhlP1Mu1JKdCgJjZxQywm1nJA/6uKSkJCQ/DO4p4rbj0AVKhnRpelFLSfkkr4OuoVPyCWETv2DRqWUkEsIDo9o4RMyKSFo+3md3F+1VvXoq09CQkLSL3hkqtAoCJWcuFuG55TiOVSc10hoFL89XJWMUMqIWSux4iqCziKUDzzUqSaqmcQL89gxB7GAbXj8KRx1/fxC1HJCoyDq8V9zCQkJCQnJfR6+Kp75uuE3VaGWE4Z2Yv91fGIMNnkpNikMu12EGzsIs46w6gljByEXE10awqonrF2EWdd7xqBTEchAID0xIQa7kYdvOI0rpUSnurdbl5pgsPBNZ3AKHZ+5BDuXjndrCZOWsOqJbu33b0apZIRKTsSfwsZFYTo1aQsSEhKS3+ZvVYVSxlHJuRoFV63g7r9ORH6Hd6qJLg2hUxMaBWFoJ767hscfwpNycGQicsvxxNN4/HF8zxW8S0OYuwhaLbH+KL7hNP6RL7uwksgowc2dREUtEX8Y33AK5zUSIiGx8zK++RheVosjI9HdQRy9hccfws+m4dbOXltoFIRYSExdho0KxzrvqUIl46jkXBISEpJ/D4+pKlRyrkTI5nErmxtpdczKj/1YbW2cDhWhlBJKGdGuIL67jvvtwGJ2YX47sPQKPGAnNioQi9mP+W/HDt/EK+rx0D1Y9C4seBf2kR/7UhY+cSlWXoeH7sVidmJLdmI4lxAKiG+PYxuPYJEHsOJq/EIm7rcdi9mF+W3Hzqbj969tGNqJilp8YgymVRFKGaGUcVqaGTxORQOvkoSEhOQfDpfG49JaW2p+ly3+JlWo5FypiF3PLMHYZQI+g43TR4SwuA1Eu7LnbINoVxCfLcFq2ThCxPFbuOc2LGo/duQWjhDB5hDjY7DEi7jLJgwhAjBWK8kAACAASURBVBmIGSuwM2m400Zs23l88VYMIQLpiS4N0dpKBO7EQnZj77uyEy7g36zC8ipwhIjkfHx8DGbu7B1Ml4bILccn3FOFQkq08WubG6ubm+gkJCQk/2xamuiNvKra2iJ+M6Pvtvg7VKGUcaRijMUswfFyhZSjVfIEAu6ocKwOIwwdhFZF6NSEVkWMicDKa3CEiMPJeNAuLHo/tisJR91EeQ0x+1tsz1XcfQuGzIROTUyNw86m444bsF1JuOc2DJkIvYbgtxLOG7EzaXhaCT5/FbbjEm4fj2WU4AgRSTn4jJWY6d549BqiqBKfFIvp28k3oEhISP6N8JtrauuK+S01ShnnMVKFqI3JZpfKpUTPsDQKIreccN2E0ZlELUbUsAixkJi3BruRh7e0Etsu4CuOYUt2YYkXcWQiShnEpFjsRCruvgVraSFq2MTIUOx0Gj5nNXbsFu6xFRO3ETiXYBHEV5FYHUaoVYRvIrb+NB64Ezt9B29pJQ7cwN22YN1aQiEllFJCpyIuZeGfBmDNLYRa/uivF5GQkJD8zajk3KaGKh6nQtW3E4teVbz2l6uinsDL7o9JKSOMHURuOT46DBsTjo0OwFKLcLmUmLMaG+OLhezBtJ3EiqPYqVTcrCfoTMJ9M9alIY6k4GMCsNFh2NgoLJOK+yZi3TriSi7++nz2O4vZTIJgc4ivo7AxYdhwL+x0Gt6hIZw2YmN8Me9tmExMqGSEQkpoFIRaTixaj40PwLZfxJGV6FD+jq90kJCQkPwDUMm5/GY6j0t7HFXx4JmOUkZoFIRUTEjEhFREyCWERkHIJIRERCikhFrec8H5+84qOaGSERIRIRX3PqRVEfU4cfk27rYJu1mA69vvLVBEKCS9y5dLCMm9hfcsRyklLmXjh67hR1PwQ8n4ket4VT3RQX4dj4SE5N+ESs5taeoPquhBfe8mHL3XDOSEWt778l/1gCp6WpSy3s4qOaGUEsYO4m4Z7hiDpVG+/7bdjxco+36B95cZuR93Xou5bMKcN2KOq7DUYtzQ/uifORISEpK/jX6mih+h/D3IpUSHkrDqiU41Ie/bLD1rMekIa9c99IRWRcglv2/Vjw9/rHQkZEn/tjL2nUc+5n8G/wpVqOUclYwg6SNqOUf5/fkWWbqHU9LePyQZhyypSkao5Jx2BbdD2VfalVy1nKOWc36vLVTkPvwT1HJOe58r36HkahScnuL/k1WhlHFkYvxCRsnRlOKTt//dpFJOpVJO3aGcukM5/cucvF18OLmQzanXqbnNLazjt4pOPPKRP7b0oaSnUilHU4ovZpbIJLhOzaXSqw/eKHz0I3/UdTt9h3LkZuHeK7l7ku7+JnuT7h66UdBT7dZWdh+PWQop0aHi1rBryII/yOk7lFOpxQev5/el8nuS7u67mnsspehoSvGd4op25W8f/furKlQyjkjAPnCD0iJpl6o7/9WodEKFrk2ma5PpWqU9aPnfo2uRaNtkOpm682wmo5ReaWjnsfCaI7fKpapHPfLHFYlKJ5A/WE8d/wcl1bZItCKFrkXSfuBGsUjINrTzkvOod0o5j3zkjxiVroBW67Tm9MeLd77vkvi+6/ZfJfF9t+1Tow9nUhnHbpdyG+o1ir6qQqfm5pZVXM6te/Sb/NggkikOX88dF7q/t7a/XnyXxCGeOyN2X82lsU7foWj/8ao4fptqtVr7Mo5/cDoNqFGK2C3WGp6pkmOmEeYKzFjK6qYwjRSmsajOlEs3UpgGkxndLmGV0iv17TwWXnM+q/pRD/zxjawDcYWovslcze0pqamM3U1ldVOYxuL67sLa7hy6gdls0unNJ1OpIiFbr+Gl5FNLma2PeuCPOAqNNnxXUsKFfGm79sF2C7Jqu7p1etOPULZ3HbxJDdmRtPlMVguf/btUkVdekVFOPKotfQyTW8ny2nwhpZhpQZYH2w1m888Wn9UsXXbwdvTe6xcySrSqf7oqTt+htimtdDa/lVfTwq0jCELSUMnCeZKGSoIg+NzaBxobxA2VBEG0cOv43FqCICSNvY0cAm/h1rXyanCCc78nh8CbufWtvBqM4EobaSycJ26o6mls4zHuN4oaqrgE1sRltvEYGP59I4+DNXGZgh80VvM4WCOXJeDR2T9oZDdyWEIenY3zpI00Ns4T8qobOOwGDlvIo7PuNQp49EYOi8dhi3jVPT3rWByrogYhxJdZsDYLT2Rltphrmyw1jRY6z0wjLOWYuRwzlbDNhXXmtLIugcyaSv1eFecyq/7YHvmPj8WKsDZzg9iKCyy1TebaJgujwVzNtVTglnLMVIaZKCxzHsN0t6pLojScuvO9Kih1LY967I84VXjrzKVH5Rodj6vMTMcz07mZ6dzMdE4ptVmtkilkUrlMKpdJ1SqlQiaVSsRdnbp2nX5O3HHfrUkiIf57VZFWij/qLX6Msupo+tqTmQih4qKWzHTOveJzOYSgXS3vqbxSIVcpFT3TCFkK6dzBHjvOpVN0/3hVnMus5Da1bV4T7Rp90CPmwLyIM0uWbZ8Zfik4LnFe5FmPmAMeMQfmRZ4NjkucGX55Sdz2+ZFnFscc8IzZf78xePn2WSEnF4bs947dPzfi3P2eCyJPu8Uc8l66b07E+ZC4hJnhl5bE7VgYedot5pBP7L4JAWcCY7fNCr8UuGynfeQp1+gjPrH7ZodfCI1LmBl+KXDZToeoky7RR3xj98wOvxC6PGFqyEW3sETH6JNzQw4vjtw1J+JiSFzCrPBLAct2OUafmBt82CNy5+yIi6FxCd+EX/SP3eUYfdwp+rh/7O5Z4ZdC4xJmR1xcHLlrTvBhp5gTAbG7vgm/GBq3bZTPhWtJFxBCjcJuRoMJa7PUNFqquZYqjoVGmKksc3GdubjOUlhnzq8xZ9L0QgWpij7FYkE1DUZ2q5nJN9N5lmqupZJjqcDNFKa5uM5SVGcpqDXnMUz5DL1ERariB6HUNU+POYYQCg1JBwgFiAOIA4gdNepUUxOXIHAcxzEMo1AobDabxWKJRCKEzLNjj7nEXxCLCFIVfybBO5MP3ixBCA0YkAAQDRAHsAxg5Y4deS0tXBzHcRyn0+llZWU9z0K3vpNoah20cMu5dIpOzftLVLGpCV5LfSxUcTaT1spv8l154sMl9E9Cqz4IKH/Ll/a+f+ng4OpPQ2mfhFZ9Elr1aShtSEj1Z2EVQ0N+pvFd/0rvXfjSE03v+lf8pGfl/Z6fhlUMDakeFkr7JKTyoyWVm5L4U9cwBy8pHxpaPSyU9klo5dAHe4ZWDwutHNbTGEZ7N6By+rc1CTdEb3qXLT3R5LGL82FA2ZCQ6k/DaENDq9/3L4892eS+815jKG1oaNX3s4fShoZWv+tb6rKdWHuB/65/eU/jB8F1Xy+5kZp8CSHEE3RXcbuZfAudZ6ZxLDTCTMNNlHrTXYYll2HNZVhyGZYsWpeIVEXfYrEgOtdQ12yubbZUccw0wkwjzBVsU2Gt+YGSmgsYXVJSFT8Mtb55WvRRhFB6et2yZVdWrEhZuzbNxWXnnHlxD3arra29N2m1GjSzYo64bbj4K6pQ3rvl2v0vTpGq+GnCdt/cc6UAIZSYmLV8+fUVK1I2bMj+ZJjfxcvZ9/soFAoul9v7i9nAYOGvO/w7VHEms1Lcxl2xbseQ4IoP/SkHb7dQmKq0CtmoyLJhwSVfhJf2MDyUOiK89Ivw0s/DSj8PpY4MLx0eSv0shDo8hPqeT/F3KS3ZVfJ3vIt6G0OpvT3DqJ+HUkeEld5fzoiw0k+DqR8GUFgt2oC9zMEBlM9CqJ+FUD8Po97v09Otp71nYmJcRWq5NPIw9vriwuwq+XcpLW97FfUs9vOw0jc9C+/S5buTm9/zKe6Zq2cA9xkaVOKwkZFOky1OrPtkSe9GfRZWMSoo9cLVOwghbpupAu+ubbbQG1AV11pJWGi4qbjOnFtjza9FuTXWu3RLZoVepLD8AVWwWKzNmzf3pec/JhYLqiSMjAZzTZOVzkVVHCsNN1dgpvxaS34tyq9FuQxLDt2cz9CTqvhRqPXN06KPIIROnDg0c+b4b76ZMHfulJFfDh076Ssun8/EcSaTWV9fT6VS6+rqamtr+S1NVqN6ZvQhtw2XfkkVShlHo+QpZZz7E6QqfjZhu1N2JxUgZPbxcZk1a8I330xYsGD6K68/t3n7toa2NiabzWQyq6qqysvLe56FDrWUwcL+Lao4l1nR2CJwjbv4gT/1wG3+0bRW94Tadee4N6mSUZFln987yo+JLhsZUToirHRUZNnoqLIRYaXjYysmL6dNWFbxlmfRjmtNt6iSNzwKxsaUT1lBm7CsYlhwyejIsp4Zv4ou7zms9xzBJy+njV1aTue1e++s/2RJyeTltCkraKMiyz4LoY68r6Ww0snLaZOX08ZElw0NKpnxbWXoftbwUOobHoW3qJId15oGB1Luj+dD/+KUUsm2K43v+xZPjKuYspw2Nqb80+CSkfes88mSEvuNdP89zKFBJffXMiysckpoUuHtYwghvLWbyuqua7beLhLE702r4lrKcZRfhzIrDcu3p17Jk+XWWDMq9L9yVtHZ2alSqTo6OhBCZrNZq9WqVCqVSoUQKiws/PLLL1UqlcFgMJlMCCGttveK5f0+/7BYLKiMbajmmuuazd+dLzuUVFnPRxSmtZCFzqQ2rt6bmcMw5tBNpCp+ml5VWAw8Lqe4uLioqKiosLDkzBnsmWfaP/pI9emn6jt3VBpNVVWVQqFQq9Xt7Spzl/zXVdGl5ackn506ZfzUKePTbl/q0vJJVfxswnan7LyUi5C5vLy8qKioqKiosKCg3NOzbdCgjsGDVdOnaxSKJj6/vr5eo9FoNBpjl7q6nvlvUcWZzCpZGxEVt37L1dYrReIhQZQP/Io/8Cted46bTpMNDqT0nBaUslWz11YNci9YfYZ7nSIe5F5wPKO1jK3OocvHRJcnXGm8USL+KICSXCKubeworleOiS5be5Z77q7gdHZbyH724ADKiLDST0Ooa89yaxs7ahs7tF3mhRvok5fTyjE1laXacb3p8zDq52GlI8JKPw0piT6C1TV11Dd1hBxgjY0pz6yS5TIUlwtEgwMpNyjibUkNyVSJ05aat7yKVp3iHEnjn78r2HK54eMASkalrJStvpArHBNd1nOm8lkI1Xkro5ipzGMo9t9uGRFe2tM+PKzii8D0E0k5CCG8tbuUba4ijBHx5ycuWrlub2o5Yc5lmKI3X5vstDJy49Ucujmz0vhLqpDL5eHh4TNnzvT29lYoFFeuXBkyZMjYsWPHjh1LEASLxXruuefGjh2bkpKyYsWKgwcPRkREdHZ2ZmVlzZw5c+bMmTdv3uzq6vozu/jjFosFlbINdc3W24XNCwISZnnEn0tl0XjoSq7YKXjXDPe1u89XFjKtpCp+Gmp987Sow1ZLp9nc/X0rk4kAEAAKCDCpVDqTiUGn9zxisXQbO8Qzow/+kioMnW0ZaZenTB53/erJa1dOjh41Iivjml7XSqripwnbnbL9Yg5Cph+0rl7dW/zkZANC/La2+29AmY3ttJrav1YVGx8bVZzLrGhsaZsVcuZohvB0juAtr8KREaUf+VOC97FohPrjAMrnodTPw0ozaLLIw+zhodRDd/hH01tfds333lm3/CSx/1ZLLkOxNanxVHbbuVzh1qTGoUElgXuZ2VXytee4yo7uuOP40KCSEWGlH/lTYo/hBTWKz8NKx0SX03ntixNrBwdSVp/hRB/BqCx1wtXG93yLhwRSfHbWVeCaMdHlE5ZVfB5GLcPUB1Nbwg6wU6iSa0XiU1ltW5MaKCyVe2Lt64sLN19quFokOpsj2JrU+Jp7QfQRbOkxPLlEcoMifs+n6LMQ6oRlFWy+dtOlhrCD7FJMfSyj9R3vot6zipCkgtvHEUKslu6C2m5GgzW7XOEde2SCw/LNh++u2Zs2wWG534pTySXqnBpreoXhly5re3p6Ll26NCkpKT4+3sHB4bvvvgsODlar1UKhcO7cucnJybNmzVKr1QaDYcGCBUOGDBEIBFVVVaNGjUpKSkpKSvrkk0+ys7N/9RnuZzFbEKXeUI6ZaxtNp5Jrv/HcOMd70+GrdI+oA1OdV8cfzM2u7c6mm/PIy9o/CbW+eWrUYatFz+c3V1dX19TU0DGMe+ECevZZ9OabyNa22c+vuqqqgEI5ceLE4cNHCvLvmg2qGVG/qApjl+DO7Yv//e9/Zs6cMm3qhIkTx1ZW5HR2tJCq+GnCdqdsv5iNkIHFYjIYjJqammoeT+HsjN58Ez35ZPerr9bv30+vr0+5devYsWPHjh1rayEYTNa/RRU91yoCYraezJGczhYMci/4MqL0fd9i/93M2sb2j/wpPS/MJyyrYDVrV5wkqrntr3sUOG9h3KRKsqrklRwNlaXacrnhVHbb1SLxunO8V90KXLfVFNUpt11pvFokftOzsOfdp4/8KStPEgW1ire9ij7yp5Rhar/d9cuO40V1yuxquVBh2JbUqwr/PfVVHM1H/pRhwSVDgkpqGjuquJr8GkV2tTz8EPtCnnBrUkN+rdItofYNj8INF3iX8oVncgSbLzUsTqzNocuzquScNl1yieRdn6LPQqjjYiuECgOFqSqoVWZUypbsYw0OpDxwrSIVIcRsNubRjRW4id6AsiqUPrFHprqsnua6JvDb03doHXlMlMkw367QC+Q/rwp3d/dRo0Y5ODi4uLicOHFi3759y5cvRwgZjcbp06dfu3Zt/vz5PT0XLFiQnp6OEKLRaC+++KKDg4ODg4OPj09zc/Mf2rcf05gtqKhOT2V2V2BmRhM6kVw312fTNNc1M9zXbjqSV4Ch7FpLBt2UU02q4sfpUYVJ32554KzCymS2JySgqir0yito8GDU0pKWnw8AAODu7oJQ94yoA7+kim698PzZg1Mmj0PIhFD7ndsXmXWUdlUDqYqfJmxPSsL5LIT0DzZ27t1rzM9Hu3YhOzu0dClCyC8goKf4eTl32LzGf4sqzmbSWvnNXrEHPXewU8ulc9dVv+ya/3ko9WK+cNNFXs9F4M9DqaMiyw6m8s/lCuLPc19xy6cRmtVnODA9c/LyioJaZcLVxpNZbbfLpN+e5j694O7CDXQaod52pfFasbjnJfwX4aUf+lHWnuVSmMrnnfIGuRcU1inXnuXyhJ1vehTCrMxT2YIDt1ve8y0eHEBZso9Z19QxyL3gHe/CjwOK8VbdzG8rn5iTM3UFzX9P/eUC0dakBhpHM389/ekFd1ecJC4XCE9nt2253MDma6espMH0zNjjeEaltOesYuqKygZh54d+lAHzc1y31SzZxxwaVPJFeOmnYbRxwTduJ19GCNU3Ge/Su8swcynbTG9EOTSFZ/RB37hjWfR2KhdlMUyZDNOt8q7WX/hexcyZM/Py8nqmb9++vWvXrtjYWIRQZ2fnrFmzLl26NG3atJ5H58+fn5aWhhDKzs6+35iZmdnQ0NCXXaG/xGxBBbUGCtNcyjaXss01zehkcv08ny0bDt0t5aJ8piWTYcqgm7KqusTk9yp+GGp9y9SoQxaTViIW8ni8pqampqYmFkFUYViH0dhx8WIHhdKu0+Xn5YWGhgYFBZ09e8ps1MyI/EVVaDVNtYyCsFC/VSuiVq6I9PN1r6UXajXNpCp+mrA9KQnnMxHqbGlpaWxsbGpqampsrKivbxCJOgyGjh07OnQ6mUJx5MiR4ODgJUuWYMxqBov9L1IFn98S9O3x1z1LfHYxM2jya8WS7GrF+osN7/kWjwgvGxFe9kV42eDAknnx9AZR13u+xUOCSnx3M29SJdcpEipLXUG0J15rSi6RLtzASCmV3iiRptFkAXtZu240p5bL3vYuGhFeOiK8bFgwddqqqpNZbSml0tRyWUeX2WtH/foLvMwqRXKJRKQ07rjW/I5P8achpROWVRxKbU0tl6XRZJ476kMPsNMqZNcpkjSa3HN7XXKJZMf15sB9rDSa/EaJhM3XXcgXXcwXJVxtCt7PSqPJb1AkWGvnnXLZO95Fw0NLR0aUbb7cmFkpv06R3CqTeWyvGxJUMiK8dFhY5fjg62k3LyKE6pq6c6q7yzBzKWamss30JpRSKE4ukRYSKKPWlM4wpTNMN8v0rTJ0h8r8qSqysrICAgK8vLw8PDxu3LiRmJgYFhaGENLpdF9++SWO4zt27PDy8srLy1u0aNHNmzcRQgKBYNOmTV5eXl5eXkuXLuXxeH98B3/8YragvBpDUb25FOulqgGdS+PkMk05TEtGjSm9xpRWbcqo1JOq+FGo9S1TIg+ZuzukUmFTU1NLS0tLSwufzz91+vScOXPmuLrOcXS0t7e/evVqcHCwl5f3yRPHzN3q6VH73X9BFXIJ3q0XMmuLV8RFrIiLwFmlxi6BXIKTqvhpwvakJJzLRFZdayu/ubm5p/g4jsfExMyZO3fOYo858+YtX7789OnTPj4+3t4+rDpaDZv1msOWc+kl/3xVnMmslLRylq/ZOnhJ+VtehZ7ba+PPc5cexT7wKxoWXPJZSC/DlpR8FV3mtaP20+CS4aElb3sVeu+oiz/P/fY0Z3FCzcxvK502M15zL/DZVRd/nht1mP2WZ+E3q6scN9GHBFJ6ljA8lPq+b9GkuIp157jrznFijmJfhFGHBlHWnuXEn+PGHsOnr6QNCaIMDyn50L94TFTZunOctWc5s9dWvelREHWYHX+e67ur7jX3AqctjFmrK9/yKow+gsWf5644ic+Lr164nj7z28q3vQpjjvY22m/oXfXQIMrQIMq3p4n481z7jfS3vQqHh1I/Cyn5JLjsc7/bpy/fQQgxeMa0iu4SlrmEZS5hmylscwUXUTgoo86UXme+U2u+TTddL9XzZdY7v/AJqIKCgjNnzvScMfB4PDabjRAym80lJSUIIZ1Od+bMGRzH6+vrJRJJzyzt7e1nzpw5c+aMUqn8/Xv1Yx2zBeVUG/JqeuvZA60B5bIt6XWm9Hpzao35VpUpjVTFT1JS3zI54oBBJ+/u/sHbIJs2bYYHcuDAgd43oNxcENJOi/juVz4BJZfgHeomZJYis7RD3SiX4AryE1A/l9DdKVvPpCFz+4ONarV6xIgR9ys/ceKkuLi4nunsjGQmgb1qv/mvVcVf/7+1+6SK85kV9U2qLVsT12zes27LPv9VJ9etW+8ad35nwqbw9WfWbdm7dsu+8PVndiVu8ltzacOGDRHrT6/dsm/9lj1+q07Gx8c7Lzu/YcOG4LUnYtft3bhtj8/KU/Hr4l3jLuxM3BK89sTSdfs2bt0VEn9uV+LGwHWXdiRuCV17IvzbPcvWJCyOO7UzYaP/2kur1230W3EkbNW+tRt3hMSf3524IWjdpS1btgSsPBy6al/8psSQ+PMbN6xzWXZu3YbNyzYdj1x7IH5TQnD8hQ3r412XnVu1blP4miNRaw+u37RtSfzFjevXuS47u2rt5vC1h5ZvOrp1W2JQ/KVdCRvc4s6uWLs1cu3BZZuObtuWELTu4p7EDc6xF8ozjiGEGLzuO+XdFKaZwjRT2GYK21zCNuezzFlMcxbTnFZnvvVbqiDzYMwWlF1lyGWYKUwzhdVbUgrbfJdlzmKaM5nm1BpzCqmKn0sV0TY+dB8bYyoljSpZk1rW0gOHVVmUm9oDJT+tAaeXFKQX5d6urSzA2NUTQ/f4JlwVCslva/+prDqaHrHzolTYoJI2qaXNPZWXixqqy/LuF59BK8TrK4pyUwvv3mrEq5LuZH/glng+o+QvvLHHY6KKE6lUdadF3aE3dqoNnepOXYepU6nTak2dyk5dh+GBRu1PG7sebNT8tKe+U2PsVOt0WlOXUqfVdv98o6pL16HX/bSxXa/TGDtVP2ls/9nG7vuNut7Grh82GjtV+h82arVa1K1CCFVzjbeo3QW15uJ6U0GtuaDWXFBnymGaM+tNGXWmOzWmlGrTFUpXs4RURZ9itqAMmiGrylxYZy6q6y1pfr05i2nOqDNl1JpSGaabld23yrtED6jiZj61jPVvv12gRtsVtedKeOLZK7fvpGdn3snsJSsvt6CE0kM+hZKVm5tPKS6kUtLu5kRvPxW+Kynhwt2Wlt93u8Dc8orMCs6j3uLHKIUMjvu6E5uPXrmdmZmW1Vv5tKys3KLC+8W/W1iQnZ9XUEIpLCk+c/2W74bjyw/dupBJ/QtvF/iYqOL4barBaPrNVfyzw2wyJBd3plUYMmn6HjJo+lSa8WaF8WaF8UaZ4UpJ19VirfAPfVv7XxiLBeXRu25Ru9Jp35c0vdJwu8J4s8J4s9x4vdSQROlKp3Xe/15Fz03Ir+SzOK2KfzVtikI67hp/9h2nbYMWbB5k/6ss3Pyaw5aZS49mV7CO3Cr7XTch71Rz88orTqXTH/0mPzZw2xTHb1HGhezvqe1vFH/B5vddE5fuv5lTyTmZWqxV/Xbl+7cqTqSW/ukjQ7+P1Yr4IjOn1dQgsNzDzGmzEG1Wos1KtFnYLeZmiQUhlEplU6tp+nYeE6u5mE3ehPwXo+tCvFYTT2C+X1KewHyvnla81cJuMSvakcWCem5CrlNzq+oZp1KLzqUX/8u5mFmSlFN65fdwIbMkKZsqaMP6/q+N2pUcFlF3Ju3Rb+/jw/kMyuUs6u+qfFJ26Zk0Sm55ZXsfJN2PVSERYruSCu+UEjmVvH8zuVW8AkbDr1DIaChgNNyt5O1MKqmoqTZ08DBO3fZLRdm0Rz/4x5O86l8raSGjoZDRkE9vuFNK7E4qkIgwpYzQKDg6FVdLouLq1Fydmtdneue6fyvAviCXEmo5WfA/XXwVV6fitis58j7UvL/ehFwpJeQSopRBz6CUZZaQ9IncMhq/la1RcERCrIBWmUmW7s+RQSkrZdDlv+d/2ZOQ9FP6qyp60Km4nWqSvsNTyTlyCaGUEY96JP8QtH24HkhC8g+gf6uC5B+MUsbp0vJJSB4iKvKQ8kchVUHyOKKUcSRCaPy3jAAAIABJREFUViklPSfzKgnJQ4FanCYWssijyh/jMVDFOFIVJD+mq4NfTs184YUXppEh85Dy/PPPUylpXVr+I9+9+yOkKkgeR7o6+LnZ16dMmdKXnYwMmb5k+vTpWRlJpCr+GKQqSB5Hujr4eTk3SFWQeYiZPn16duYVUhV/jH+7Knr+w/sfmFGt4KkV3D7O/pvdVHKuWvHbd+zq7/S91KQqyDz0kKr4k3+8j1oVf+KytlLGaVc1KqSEXIJrlA1qBVejbPi9gpFLcI2Sp1bw5JLfMZdMjIkFLI2yoedWl31Zyy+0Explg1SECfh1fVzUr1aj4W/bdf4Afd9AUhVkHnr6ogqljNAouB3K/kS7kvs3fLKrf6tCKsKaGqoVUkIp5/CbGMLWepxdKhYw+2gLva71dsr5wABPqQhr4lX1sQRqBU8hwUeNGjF/3qzv9m7191tsMoh+pX9nBz83J3mxu2NnB/+nA1PKOCoZJzjIe/ToLzBWaYe66Y89kUoZRypiNzdU/9V7zB9DJecqpcQih7n0qjyt5re3kVQFmYeeX1eFXELIxCxBM72unlpGKyylFTx0KKV3KdSchwW1Ir9nsYzaktZmulzE+l0vdv/An3B/VYVW01xNy502dYJCSlgtsqBAr0MHEuLXLWNU53d2tJgMIpNB1KFu7Orga5QNcgmmUTboda1yCdbzaLdeaDKILp4/7GA/5/zZg8eP7kZI1TOXQdcml2BaTXPPr2oF9//Ze++4KLJ0/3+/v7++4bX33r17d+/OhjvhTlhnRh0DWQSRDKIgIDkLYkLMWVQEQSRJzihJBAUVRETFBKJIpqGbbhpoOlZ3V1VX5/T8/ijtZR0DM+PMOHP7vN5/dJ8+9ZznOed0fapOVZ1CeBRMNEF+leJTnNnhkGDfGy11FhYmsZtC1Qq2TDJN2pzrM8IbU0hZAHhHe4OF+XKFdNrgmBihkYfYeg1vY1RQSvIRKc4UcCmo8HktBDqJ8MYU0hlcTJcT07iYTuZjIrpSxlIr2KR9Apsk8xXSmc7bV1ycV4MekUmmEB5FIZ3RKDkq+exL7aaSz5Ll5x7jiwRUskHIbeXE83CE/HFczJBJpqQ4U4JOIrwx8gSO3BzhjSmIGfJMTkNujv9jc7Jq0kmdmqdVcpYuWfTowXWlbOZF70y+7jzDKBXG9M7TG6RCJKAi3FHuzEDN9TaPPfnmMZkWGzMsojPfLebvGtLmqq3ncuqaBZxh4Q+blvjVSoUUn+p60LLg758pZSwAmY+3x/GEPT3dbbzZESF/vCDvTEHemaePbz68f502/hhHJ6mU7jsdlyXYTEd7Q0HemdLiTNAJ6uuKPdY4U4Yf9vfebr1Wk5+bWlyU3n6jXoJNP7x3jTSC8MZUCs7szGB+7pmCvDPPnnQQ6GRdTWFxYfq1piqdmqtVcTtvX8nLSaksPyeTTJNNifDGtCru1aYLZSWZu3ZutrWxBMCfPL6Zl5NSVHAWE02Qk0WgFYQE+QYGrL90sUTApZCe5+WkDg/cUyvYt281zkz1X79aTaV0XajMy8tJmWH2X2msqCg7p5TNSnDmo/vXSSelOLOn68Ynn3xYUpR+9/YV0Ilbr9fm5aTUVheq5LNCAZVsWCF/vPpCfn5u6vWrVVoVl9xTo8IJKT5VXpqVn3fmRkudXiu+03E5LyflfEWOWsEeHXrQ33u7p7ut+2GrBJ1EhRMT4z232xtR4QQmot/puMygPZFLpkuKMwryztxubyRw1rXmqvzc1KrzeXJiRq3kDvV3FuSdKcw78/lnn4wM3UeFEwV5Z/JyUynDD9SK2VeqhVEqjOmdpzdLBSEav3LzxoYjFQ13hxUqjVan/6Vwt5+x4WjlxRvtcvxHnH/+BUsFJqIzaE9iokOvNFY8e9qxMSqo41bjypUW7TfqszOTwsP8vTzdW6/XODmuulhbBIBVnc+3XmGu16LlZdmbYsIiIwLPV+TUVBWEBPvu2b318MH4c1lJ/n6e7m4On3z8oVolaLxUFhMdEhUZlHn25PhYz4mEvT7eHuu93K81V6lkrCOHdm7fGrV5U/jt9sbHj26Eh/oFBHiv93IrzE8TIzSRgEpgk81Xzvv7eQUEeNustHB1Wd337FFMdEhAgLfnOteMsycEXIoYoYFWEL0xZMk3XwcHbxgZvH/m9NH1Xu4B/uvjtm8cHX64dMlCL0+31NNH83NT/vSnPwYEbDh8aGdYqJ/nOrfK8nMqJedyY0XMxpCNUcHnspPv3Wn64IP/9PFec6Eyt739amDA+oAAHx9vj6rzeaQskbNAhw7Gb9sSGRMdcq25isCYIgFVyKcW5KWFh/n7+njk5aTcvdO2OTY8Lm5TVETgpYulpcUZixZ9FRUZeP1qtUI6o5LPNtSXWZgvV8lntSruKlurqvO55ytyw0L9fLzX5J5LUciRrIxTmzeFR0UG1lQVDg093LYlKiBg/Xovt7/99c/dj26knD7qvX5NgP/6uO3Ro8MPXjnnZpQKY3rn6c1SoZZMHMmt2JR2+UVx/S8EAIB9edd2Z1XrlT/iFfv3QCq+7x1QCG9Mq+K0tV50cV69f+/2nfGxADJbG8vy0uz/73/9r/LSLAAAkKyytWqoLwVA62qK7FevBJBfbijfuWNTTHTIF5//d2lxZlio34H9cXt3bwNQAggP7NuelZ4IILx181J8XEzc9ui//fXPJUUZlhYmABho+FKcqZDOnE46vG/PNgcH2+Agn82x4Ykn9gPA5MTTv3/xGXd2GBVO6NRca2vzizXFANB5p8l7/ZqD++O2bo4AAFzMWPD3z8ZGHuFiBmj5gQHrc8+dBoCuBy2LFn4JGj6AboPvutNJR2xWWkZFBAJI01KPhYf5A4CVpcnd2010as+XX34OOuHdjss74mJ2xEX/+c8fVJSdc3K0BRADEKvtrMtKsgDg8aO2xYu/JrBJkYAqElBVMhbpuaODrbOzHWj5qHCCOzv8v//P/967ZyuAGgCCAr3NzZYfPLgzJNj3s08/rijL/vTTj+/dadJr+AhvTCljXWmsXGVrpZSxNEqOu5tDSVHG7373rwlH9wBoQSvQqTjlpVm7d24OCvS2MF+ecvpIgJ8XgA40PPvVKwvz08xMlwIIAbQea5zTziToVNz3QSoeP34c/SIdOnToHVouKSmZmnr1C/KkUmlMTEx0dPT169dfWSAvL29gYOB1lmdmZqqqqh4+fHjlypX5+1NWVsZgMN5ajHwDNofDmb/l9zy9WSo0xMSOtJKdOdcBQKNRG9BqNQbm5n8/3omRuajVKgDd8eKWmJTzoJ4V8n+sOahfsFQI+eNKGauhvmy9l3viif1bt0QCiFdYmXa0N1RVF+3etdnH2+Nac5XHGqfLDeUAxKWLJeu93C/WlUdFBuXlpR07stvMbBkpFQcP7DiwPw4A27I5Ij3tBABx5fL5sBC/vLwzp5MOL1r0VWX5uVW2Vgopi5y437932949W3Nz0wID1sdsDNkZH3siYR+AZHjg3tIli3jsEVQ4oVVxnJxWXajMAyBar9eu93I/kbBv25ZIAJw9M7hs6SIqpZuUiqBA7zMpxwDE3Q9bzUyX4mIGABrg73X2TIKry2rK8EMA7EzqscCA9QCy1XbWrddr+5522NvbXL9eGx7mn5d3JiX5yMKFX56vyLG1sZQT06BHPNY4FeanARCdHVcsLUwIbFKM0AiMeeCF50EB3t7r3XVqLtnI9XUlRw7v9FjjXFqaFb9jk7urQ05W8tkzx9vb6vNyUgP8vQAkAu4Y2eaXGypsbay0Ki5oBW6u9jVVhU1N1YcPxK9b61peml1anLk5Njwv7+yunbGODrYZ6SeDArwBUFw8scrWqrQ402alhRSfAhB7ebplZyVpX3VTwE8sFXfv3o2Jicl6kY4fP/4O1WLZsmWdnZ3fzkdRdPv27ZmZmdnZ2U+fvvpNU62trZOTk6/8ic1mb9269eDBg+Hh4Y8efYcXt5ibm7e3t7+5TFVV1fbt27Ozs9/hu9OLi4s7OjrelbXvkd4qFbvTS+OyrgKASqVQqRRKpUKrVQOAXq8lUamUSqWC/PW7olQq1GoVgP57W3i1WYUM9PJDeU1bzlQZpeK1oMIJhDd2ImFfoP96JuMZgTGXLV18v/MqaBH2zJCd7Yojh3YGBnhXnc8jiNmykiwf77V7d2+J37EJQDZJ711hZZafmxoU6L1v7/ajh3ft3b312NHdIgFVIWMlHN0dFOANQKBCmqWFaVlJ5mo7a4Q3zp0dwcR0k+XftLfVA8hLizODArz37d1++GA8QbC6HrSYmS4zSMWaNU5FBWcJYvZibdEad6fkU4djY0IJYoYy/NDMdAlt7DEuZoBOsMF33emkwwDinq42SwuTGWY/gU/5bfDMyki0W2Xd9aAFADudfNjXZy2AfKW1+fWr1c+e3HKwt01OOhTg7wVA4GK6paVpWUnW6lUrOLNDKjnL29sjK+MUQcxeb662tbEipUImmVq+bDHpeXlJlqvLap36+RG9TDKFiiZCgn2Dg3z27NpyOukIgJRO7Uk4uic785SHhzNoeQZ5br5yYZXtCqFgHBVO2Ky0rK0uBBCJBDRfn7Ux0SFRkYFpqQkA8p7uG6vtVmZlngrwW09IpmaYfeZmy8pLs+1WrWDPDBIY03Oda15u6vsgFdnZ2QEBAYavLBZr6dKl5GetVksQhFQqNXw1ZJI5BEGo1epXmiXLODo6Pnz40JBj2JBCoSxcuHBuedI4QRAqleqV1giC0OufzzkolcoHDx5MT0+PjIwYyshksrf64+bmdufOnW/7Y0gajSY8PPzkyZNzbWo0mrlOKhQK8oNOp5vbFEql0mBHqVQSBKFQKABArVavX78+KSmJ3Orb4fwEaT5SsT2zCQDkckIuJ3Q63Z07HZaWFtbWK6ytV9ja2jKZdACtXq/R6zVqtUIuJ7RalUol12hUKpWczFep5FqtSq/XKBRSuZxQqxVkPoB2ZGQwNjYWALRaJbmtXq/R6dRkMbVaodEoVSo5Wfs8kclw0EgO5jYapeJN3iC8MdDyy0uzwsP8ATAxQlu31uV6c7XdqhXWK8wPHYwXCqiMiSdenm5mZsu+/vrvIcG+QuHs7l2bzcyWLVu6yNbGsra6aNvWqKRTh8iD3+XLv7EwXx4RHiAWTZ08vt/MbJnJ8m/+/vfPphjPOtobFi368qOP/quhvmx2etDN1cHMbNlXX34RuykMQVhbNkeamS2zsbF80t2GiSZIGWPSe/1815mZLVu08Esfbw+RiHXwwA4zs2VmpktvtzfiYrpIQNWpuZtjw3Oyk7UqDi6mN12uNFm+xMxsWerpo6iI7ubq8PTxTZ1OlHMuOXZTmE4nWe/lfutmw2DfXXd3R7F4MinxEOnkF198Sqf2NF8+b2qy5GzaCS6HHhzkY2a2zNnZbmTwPvl8HyqcoAw/MHgeszFEq3p+L9ZaDxdLC5ONkUGsqQEBlxIbE2ZmttxmpUV/7+3zFTnhYf5aFefFiKHiYkZFabap6VIz06Ufffi3Gy11vt4eVpamm2MjOKxhHnskKiLQzGzZN4u/dnS0RcVTKclHSCc//+wT6lj3teYqE5MlZmbLzp45joomXjnyfmKpqK6uDgkJodFoNBqNzCEnXiQSyfHjxy0sLGxsbMbHxwGgpqbmwIEDZ86csbCw6O3t7e/vt7CwiI+PxzBsrkGFQlFXV2dhYXHhwgUXF5fHjx9rNJr29nYLCwsLC4va2lqlUunl5fXb3/726NGjlZWV5H45ODi4pqbGxsYmKioKRVEAiI6OvnXrlk6ne/z4Mblteno6WdfAwICzs7ONjU1qaqpEIgEALpfr7u5uYWERFxf3kj9KpbKhocHCwqKiosLDw+P+/ftarbazs5O0WV5eLpfLDYXb2to++OCDDz/8sK+vTygUOjg4WFhY7N+/H8dxAAgJCSktLT148GBzc/POnTtzc3MtLCw6OzupVKqFhYXBczabHRQUZGFh4efnJxKJmpqa/vjHP3788cfDw8Majaarq4usOj8/XyaT/Xg9OzfNTyquAOjlcolcLgGAgoJcOztbBoMxMjI4Ojook+FqtXxoqH9oqE8sFmi1SjZ7Wi6XTE7SUFRIo1GGhvqkUmxykkahDOv1aoVCyuHMDA31Dw31A+ifPXvy5ZcLxsaG2ewphUJKp1OHhvqoVAqAFkG4KCrkcGb4fLZCISUdmA8yGQYa7GBug1Eq3uKQSEDlsUc5rCGyMHtmiMcepY09Hqd0cVhDEpQhQSeZ9N7x0S46tYc9MyhBJzmsofHRLtpYN2tqgM8Z5bCGubMjPPYIhzU0Qe2hUroYtCc4Osljj46PdlEp3aypAQ5rqPP2lbBQv107NxMYU4ozJyeekjY5rCEJypydHiS/SlAG6QnCGyewyanJZ+OjXRPjPbPTgzg6yZ0dJqvGXzwqSAbLY4+IXjyzTaV0j1O6+BwKLmbMTg8IuGPkMqtkjOyZQQGXgvDGZqcHcDGDz3nu5PTkMzFCQ4U0KqVrerKPwKemmX3jo12MiadzrxsT2OQcz//xAAqd2jNO6Zqe7JOgkxJ0cnZ6gCxDYJN8zij7RfOSYKIJkYBKpXSNU7qY9F4Bl0JuzprqJzdnTQ2Mj3ZNjD9mTf2Tk1PPnXweo4BLwcWvfobxJ5YKjUZz4cIFKysrKyurioqKrq4uMv/o0aMJCQlarZbP55POVFdX//73v6+qqhIIBIsXL7azs0MQ5MyZM9u2bZtrsLm52dPTE0GQo0eP/u53v6PT6aOjoy4uLlqtVqvV+vn5Xbt2bXp62tTUVCKRJCUlbdmyBQCWLl26ePFiBEGKi4vDwsIAwNnZuaWlBUEQGxsbPp9PGmxubgaA6OhokUik1WoTEhISEhIAwMHB4dGjRwiCpKenx8TEzPXn5s2bHh4eCIIkJib++7//O4VCodPpjo6OpD8hISFVVVWGwkqlctOmTceOHVOr1atWrerr60MQ5OTJk7t27QIAU1PTr7/+GsOwGzdu/Ou//mt+fj6CICtXrjQxMUEQpLS0lPR8//79nZ2dWq32zp07a9asUSgUQUFBKSkparWaTqevWrUKQRAEQUJDQ0tKSn7Mvv1HmrdUaGUyXCbDAaCsrMTe3q67u7uz8/b9+3dRVNTU1GBhYW5lZZmUdBJBEBcX54SEIwcP7q+vr/3rX/9iZWVZVlYcEOBvY7Py2bMnOp2mrq7axcXZxcW5vb11dHToP/7j95aWFllZGVqt5uDBfe7urr6+PpOTjPz8nJCQ4Li4bS0t13S65w7MB6kUBTV6IKdhS9qvXip+8CLkc1fFIPdiuJiOi+lzMulzcsZQ4QT5FRPRxQgVFU6IERpp5EX+hJA/JkZo5FeljDU8eG+1nfWJ4/t0ah7ZUq+2KXr5ZjXyplhcTMeeF3tuc25opAOG2HExAxczXtQyIRJQSWfIijDhBHmBmjx3MThJ3uNExo4KaWRJMsZvuUR/qX0MmaRN0iXDtq9cdMTQyGQs5OaGYnNbeG5LznUSF9PfMOZ+xjugYmJiHBwcyKsLx44dW7t2bVVVVV5e3p///GcAKCwsjIiIIEuam5tPTEwAQHZ2dlRU1FwjDQ0NHh4e5Gc7O7uBgQEqlfr5559XVVVVVVV9+umnTU1Ncrl8xYoVAJCamrpjxw4AsLW17e3tBYCqqipfX18AWLt2bVtbm0AgMDc3/7arFy9erKqqWrt27fHjxwHAwsKCSqWSTgYHB88tef36dTc3N/Kzk5NTT0/P9PS0wZ8FCxZUVFTMLb9r166zZ88CgImJyezsLACkpaVt3ryZDKenpwcAampqfHx8yPI2Njbk5ZaamhrScwC4e/duVVXVwYMH7e3tASA6OrqgoAAAqFSqpaUlWSY8PDwvL++79M/3T/OQirLtmZcB1FIpKpWiAFBbW/WnP/2nk5OTvb3dunUe7e03rKwsCQIFgKCgwNzcbBsb61WrbHU6TW5utr+/HwDY2a26ebOFQhk0NTUBgPHx0YKC3Pz83K+//urixWoHh9VKpZQ0fvNma2lp0YED+1xdXUpKCj/44IPm5iaN5nnt84QgRKASvadScXzyNx80v0dS8cMRcMdUMhaBMV95hIvwxsUITSljySRT76Q6jYJt2CnPqWWMvHeWrEhOTJOPWbxyWOs1fI2S8wMXAnlNU1AU0hkpPiV4dVOMoULam59Ofyf8xFIxOjo694ork8lcsmQJAKSkpCxatCgkJCQ8PDwtLQ0A8vPzSVXQ6XRWVlbkNeesrKyXjuIvX768bt068rO9vf3AwMDk5OSf/vSnkJCQkJCQvXv3zs7O8vl8Kysr+Gep6OvrA4Dz58/7+/vDHKmwsrLS6XQG+0qlsqSkJDAwMCoqytzcPDk5GQCsra1HR0cBoKCggDy0N6TW1tY1a9aQn11cXHp6eths9gcffED6s2fPnpcunsfHx6empgKAhYUFefuW4czJzs7OoAobNmwgy9vZ2ZGeV1VVkZ63tLRERESEhob6+Pi4uLgAQFRUVG5uLgDQaDRra2tyw4iICFI/foI0H6nYlt4IoCQIEUGIAHQFBbkBAX4AAKACgMHBXlNTE5kMA4CQkKCsrPQ1a9xHRwcAIDs7Izg4EAAcHFbfunVjbGzY1tZmcHBgx47t4eHhgYH+//3fn9TX19rbr1arZRqN8saN6+HhoWFh4a6uzq6uLunpZ2JjYwBAIhHJZCiAjiDEOC7U65VarRzHhTIZRmZKJCLSPRKJBNErkX3Z9Uap+HF3Sc93TMR0Qd6ZjvYGGf5aMXgnzogEVFRISz19lDL88KUdLiaiM+m9UZFBuedS2lrraqoKFdKZb1tAhRO4mBEZHrh399aXzk7eUVPMlJdmXWuqkkte8Y/CRHTaWHdK8hGEN2aompTSd7sK208sFenp6YaTAACYmpr65ptvAGDnzp2nT58mM8k9Wl5eHnlWodPpLC0t6XQ6AGRmZkZHR881ePHiRVdXV/Kzg4NDf3//wMCAjY0NmXPlypWRkRGBQEAeXKekpMTFxQGAjY0NeVZRWVnp5+cHAB4eHm1tbXw+n5QuAKipqens7FQqlR999BEAoChqbm6elJQEAEuWLGEymQBQXFxsOLQnU3Nzs6OjI/nZzc3t8ePHcw/tr127RtZrSDt27EhJSQGAhQsXIggCAGfPniU1ctWqVeRZRXV1teGsYtWqVaSFCxcukJ6bmJiQF/P9/PxWr14NABEREaWlpQAwPj6+bNkycsOQkJCsrKx5dtMPTPORiq3pjQBKHBfhuAhAl5+f4+29HgAkErFaLXv69PHixYvIe8oDA/1TU0+7u7s9edIFAFlZ6YGB/gBgb7+6ra1lZGTQ3d3txIljGzY8byJHR4fS0mLy4AAAVq5cUVVVCQCTk+Nr1rinpaVERoYDgEyGsVhTp08niUQ8lUpRVXX+2rUrKpViZmYyJSVJLBYQBEq6R4JhiFZOSkW1USresvPFRHQSkYCKCskZG3LahEZODZG/fruwIQdA7Oxkl3bmuF7FJX99acrFsOFLzTQnnyrkj2OiiRfbjokRmqEuQ1vjYoacmFqyZGH1hfwD+7YL+eMG9+TEVE9X23/97S/HE/b99a9/3hEXA3oh+avBGXKF2u1bo44c2llbXYQKaeQKiWQ4ZPgvAv+HtBhqN0xqzXWSnF8SCagiwTgmogNgvj5rDx2IBw1/TsnnppSy2d6eWwsWfI5wKYboJOjk8OC9uG0byZDFCO1Fa9Bf2nz+wvYTSwWTyTxy5Ijri+Tl5UWeZIyOjm7fvp3MJHdzOTk5oaGhAKDT6UxMTMgJqPT09MjIyLkG2Wx2cnIyueG//Mu/DA0N4Tiek5ND5uzbt29qaorL5ZqYmABAcnLy1q1bAcDKyoo8YC8vL/f29gYAV1fXpqYmpVJZXl7u5ubm4eGxY8cOCoUCAI2NjW5ubnFxcV5eXseOHQOAjo4OLy8vV1fXqKiol3b9PB4vNTWVrP3f/u3fent7pVJpQUEBmbNr1y7D9Xwybdu27dSpUwDQ0tLi4eHh6uoaGxtLPuFhbW3d3d0NABcuXPD09CTLW1tbk55XVlaSnnd3d/v7+/v6+sbGxjo4OADAli1bFixYMDY2RhBEaWkpWfWhQ4dedzfwO0/zk4oGAAWOC3FcCKDNzz/n47MeAGQyXKkkJBJxbm62o6ODm5vb3r276XS6lZXl48cPASAjI83PzxcAbG1tWluvDQ8PWFpa0On0vXt3u7m5OTo6/OEPfxgaelZQkOvs7FRYWNDT0xMQ4O/m5mZububk5JiWlhIWFgIASiUxOjr00Ucf8XgsAPDz892zZxcADA/3ffzxxwIBRyrFSPdIMEyglQv2ZV80SsVbvEeFEwzaEzr1yQyzH+GNcWdHyANePofCY4+IBNQZZj+D9mSK8YxccWiG2U+nPmHQnrzYC9MYtCdihOqxxikvNwV0CJPe++JiNYOc4REJqAIuhayFzxnFxYwX62HQxAiNQXvCoD3hsIYJjDk92Uen9sxOD0rQSR5nlPzKpPfiYga5Bi2D9nSG2Wdhvrz1eu3t9gZSRUh/EN4Ya2rg3p2moYF7jZfK6bQnMsn0DLOfTu2ZmeonL02TnfTVV188eXxTik9hIjp5SZlBe0KaIq94z0z1v7i0PsadHRa+eP8onzNKYJMvnByQoJPc2WExQpudHhRwKbiITjZLgL/XqZMH9Woek95Lpz2ZnR6UiBm4mMFhDbGmBu7cumxmuhQVTYgEVNJzXMxgTQ1cv1rN54yKBFTuLHkFfpzcnD0zJEEZQv44d3b4dVNqP7tUAACCIG0v0oMHDwz5TCazra3NMD3F5/MNuzYKhULeG8rj8cjD+blJIpGQ1h49emS4YZTMIW8lUiqV5E6fy+VOT08DwNjYGHlXrlAoJM9XaDSaWCwmDe7fv3/FihVsNttQRVtb29jYGI7jMzMzZM6DBw/a2tpIsy/r2tO7AAAgAElEQVQlqVRq8Ie830mr1ZI5hioMaXp62vDw3d27d9va2gxaMj4+/pKTr8t8+vTpnTt3tFotuS2Lxbp79y55fxTpPDm39vo+ecdpXlJxtgFAjmEIhiFSKUaljnZ2dszOTk1P06em6DweC8OQxsb6hoY6BmNco1H09Dzi8VgEgTIY44ODzwgC7e19PDs7JRCwe3oeaTQKBmO8oaGusfFiR0cbQYhRVNDYePHp024ATVfX/YaGuqamxmd9PXT6+PBwP0GgEokQQTg9PY9QVEAQ6MhIP5U6ShCoIRPHhaR7JCjK18j4e7OMUvF6V8grwC3XakyWf2NmuvSzTz+pqykKDPR+/OiGTicszD+7KSZUp8X37dm22s56rYfzDLP/Ym3RZ59+Yma61GT5N63XaySSmabLlSYmSyzMl//+97+rrS6cpD9dZWtlZrZs86ZwAWeUbBQCmxweuGe3ytre3ubUyQPkkbhIQJWIGXW1RaYmS0yWL7l0sZTNGnJ1sTczWxYc5CNEphOO7lmw4HMzs2WrbK0Gnt3BsamsjFNmpktNTZb88Y//cbmhPCxkAy6iZ2Ykkv486b7JnR1et87F2ckuJfkoIZli0nvXe7qbmS1bv34Nk95LnjFgIvo333y9cOGCsDB/DJ0+nXTEzHSZyfJv7nRcftrT7uXplnzq8ImEfeRSiZSRh6tsVwj54wD43t1bkxIPCrgUHx8Pe3vbyIhARMA8sC/uyKFdsZvC+p523LvTtHz5NxYWJn/4w3/k5aToVFx/P0/71StjokM4s8MIf3xTTKi52fKFC79c8s1CDJ3MzUmxt7exW7Wi/Ub98MC9qKig0uKM2E3he3dvvVhbRGDM9evd7Vev3LYlksseVsrZa9wdr145/8pZtfdBKt7zpFarh4eHo6KiDBNixvRd01ulYld62dazlwBkGCbAMIFGI79zp33lSmsTk+WmpiampiZOTg4IwgbQ6HQKuRxDUb5aLZVIRCjKl8lQpVKConyViiAIkUQiVKulKMqXyzGdTqHTKbRaOYYhBCHS6RQKBU6WJH9SqQiZDFUoJCjKxzABjgvVaikpAwqFhKzIkEn6ZgAVcTVS7r6sus1njFLxGsiVZS3MlzNoT1CU4bnO9eyZhNWrV97vvAqApaUmeK5zBVDeunmpojT7RMJejzVOZ9OOe65zRVEGg/Zk1aoVF87nrrZbMT3ZhwonPNe55J5LdnN1uHv7CopOHTuyOzoqRK/hC/njuJghElBLijLqaoocHW1Tko/o1Dw5MX3rZoONjSV7ZohJ7xUJaHarrJsuV6LoNLkC0vatUfv3bkfRaXLB14K8M16ebqiIPsPsX7nSoqwky9lpdV5Oio/3GrFwgkF7IuSPS1BGeWl2XU2Rh7vT6aTDIcE+58tzUHS6ouycu5ujWsEmO8nMdGlHe4OEmDmbdiIwYD2KTtKpPXZ21nU1Rf/3//6fuO3RhtvAJqg9ri72D+9d43LHIsIDiosyvTzdDuyPu3ixPCI8IDTE78jhXX/5ywe3b12mUrrMzZZTKV0oygjw90pKPARA1NcVV1/Ij4oI2rZ14949W48f24uizDu3Ljs52hYXZlivMKurLSotzvzii08ry8+5udoXF6b/7nf/VpB3Rk5MK6QzNVUF5BJbUZFBAERYqN/N1ovzvKRhlIqX0sTEhK2traWlJTkPZkzfI739rCKjbFNKHajFiIAl4LOECJvDnqLTRg0w6BQBn4UIZt8TBHwWjzMpEzF3nq3amlYDarZRKl4tFT1dbcuXfYOJ6ABoSLBvxtkTLi6rH9y7BoBmnD0ZEuzb398dGrLB09N9pbXFajvrrIzEkGBfABQT0a2tzctK/rHIhN+GteeykuxXr+x/dgdAknzqUEiQL2gF5BNqBflnXJxXe3q6ffhff009fVSv4cuJ6bbWiytWmCllsxJ0UiaZNjdbfqfjMgBRUpQREea/c8cmcoc78OyO3aoV2Zmn1nu5A4hlkmk7O+uykqy1Hi6Z6Ym+Ph4AIgnKECO08tIsdzcHT0/3//7ko5TkI74+HpcvlQMQDfVl9qtXGqTC3GzZs6e3APDkpMPBQT4AGCqcWLHCvLQ4027VCplkynB5QCllddxssF+98kxqwoYN6wCUlhYmlhYma9wdPde51lYXbt+2kVySZODZnaVLFgn54wBYRHjA6eQjDzqvenm6eXq6L1r01ZbNkXHbNqYkHwGQ9PfednZaVVqc+cEH/+m5ztXN1T4qIrCt9aK7u2NG+slAfy8AkUTMaLhYum6ti6en+1df/T0yIgC0fNDwCey1q44bpcKYfuz0ZqlQYbSMC5fcduU/ftojZo9iHArKpuDccalgwgAhoKGcMZRDQTlj7wcUlD3c+/Thut3nUi+0gupHuSvyFy8VUnyq60Hr11/9Xa/hA+giIwLPnjluZWU60HcXAIoKzm7ZHOHrsyY/9wwATNGfubrZn007HhToDXpEyB+3sbEsLko3M10KIALQBgV6Z2UkWliY0MYfA0Dq6SPe6z1AhxDY5MCzux9++DcAEQDs2b3l8MF4vYavkM5cv1ptYrIEAAcdolZwvv56QfejVgCoLD/n77tuV3xs4okDAOizJ7ccHWzTUo+t9XAG0AKIHRxsSosz1611TUk+ut7LjcxkMp795S9/UkpnAOBEwr7DB+Pd3exbrtYAwLXmKgvz5eRbLkip6OluA0ATju0JDFgPoNepecuXf1NUkL7azppcGZBsIomYQaV079yxaeuWyIu1xVoN8s3ir/p6OwBgcqK39VrNltjw4wn7SCcX/P1ztWIWQB8bE5Zy+uiyZYuHBjoBoL6uNCoyKHojuVwHTIw9dnWxO510xG/DWgAAUNTWFF6/WuXmap+RfjLAzwv0QhFC++jDvzEmngJARVm2n58n6MSV5ecGnt0l31polApj+unTm15tJKCiyPjo2NPdWdVuOzJDD+dGHs0LP5L7nhNxNDf8SI7L9rMxKZUTM1NyCQvhzfdy4P8gqUCFE+yZoRPH9/n6rA0O9v3k4w9LitIbLpVt8FkbGuq/eNFXYWF+9+61hwT7hob6OzrYWq8wS0s9tn69O4BQyB//ZvHXdzouJ5865LfBMzR4w3/+8T/KSjLraop8fTxCQ/3DQjZ0tF2S4lOokMZjj55OPuy9fk1oqN9//ddfTp08AFoBJqJPMZ4dOrAjwH/9Bt91N2/UN9SX+vmuCw31Dwr0vnOnNSzU7+jhXQDY08c3ly5ZONh3d0dcTGjwBn8/zz/84ffnK3JWWJkN9XfuiIuJ3hgSHOTzpPtmXk6Kj7dHaKj/f3/y0eFD8TdvNgb4eYWG+vv7e9XXFRMYk+ykhV8v6H7UqlRw+npvb44NDw3x8/VZezbteMu1mmXLFhseFxeSC5/oBJXlOdbW5gBSXEw/X5Hjt8EzLCzAx9ujualuY2TQwQM7QC/ksoZPJR708V4TGur31798kHH25NUr5/02rAsN9V+6ZJG/n9fDBx2hIRtCQ/2dnewWfr1gaPB+3Pbo0JANfhs8D+yPa79Rb7dqRUrKUc+1rqBDMOFEUcFZX991oaH+ixZ9GRToA6D86ssvqs/nk69LMkqFMf306W1vwRuTYQzWLK2y5f7RktYjRS1HSlrfLcfKbh4ra39XHCm9caS49Uhxa27jvclZFmgxEUI3TkC9umsJjCngUrKzkspLs0yWL8nOPAVAVJSdy8pILCo4+/D+Nb1W1Hq9NisjMS8n5eaN+qH+znt3m8m7iVqu1Qi4FD5nNDszKSvjVHlp1sR4j0bJLi3OyMpIbG+r16t5Au4YwhuXoAwRQs3JTs7KSCwtzhweuEfeBCWXTLOm+rMzT2VnJj3taQcdUlWZl5WR2HzlvF4rune3+dmTDgnGZE31X79arZLPjg4/yMo4lZ2ZVHU+jzbWfaOlTq1gT032LVjwmbubI58zqpDO5OemZmUklhRl9D3tAJ2wvq4kKyOxvq6EXIKJbJDW67UzzD6RgKpRcvqe3s7KSDyXlSQSUNmsoRvXa8kbVQ1gIvro0IOO9gbySWm1gl19IT8rI7HpcqVeK7rfebW35xYuZpBtci4rKSsjsawkc3ToAWj4FypzszISC/PT7t1t1mlEN2/UZ2Uk5p473Xz5vFrFHR68T4Yj4FD4HEp7W/1A393OO00SMUMsoCqkrPLSbLIjuh+2SrDp9hv1VEr3t589NEqFMf00aR7v1qZKxJN6JRu0/B8FHfJOETw3q+YriFkRMq9/1v9EqRA+f3h4QqviAiijN4acTTuuU3PVCrZWxdWquDLJFMKlKKQz5FeFdEaCMuTENDmdp5SxyAcRyF+1Ki55v6lGwdaquIZiwhfPUWtVHLKY4SZa8tWhczPV8lmtiquUshAuRSaZJrBJhEshn/RGeGMSdJIsTL73FEDccrXGbtWKxBMHJOgkOXGkUT6vhdyWfH2QSsaa+9ZcpYwlRmgI77lYkuXJ+7KUMta3mwgXM+a+HpW0qZSRTk6Rz6iTj2EbmoLUQrXc0JLTCJciJ563pEo+i3DHiBfhoMIJMUJVSGck6KSh3USC8W93BHnHsFEqjOlnSfOQinEhfwzhjSE8yi+QH/Ftqb94qZgbxuTEU9ZU/0vH1O8zYoQ2w+zv6WpjTQ1IX7OmyP9Y5JLpW2315FO+xmRM7yQ5OTndaKl5t8sK/M/hVyIVCG+MXK5u7tH3ew65HgaBMcm3bvzs/rxXKIiZ2+0NH3/8ybVrLUaMvBM++eTTmzfq5vlkj5GX+JVIhZFfGRJ0cmzkkZenm4uznREj74R1a11e9y53I2/FKBVG3kdeXB/iapQcI0beCVoVFxXSjGfw3w+jVBgxYsSIkbfw3krF8PhYl9goFUaMGDHyHoAKJ6aZ759UcNkjg4P3GPRecmE+I0aMGDHycyFGaNzZkaGhB5OM3vdIKki1mJ0ZHBjoZEz08tgjnNlhI0aMGDHy08Nlj8xODw4N3adRe4Tznun5iaRCyB8XIzTW9ODoyMMxyiMjRowYMfJzQRl9RKf1iL7LFYGfTirIcwsjRowYMfI+8J2ubfykUmHEiBEjRn6JGKXCiBEjRoy8BaNUGDFixIiRt2CUCiO/NH7uGd7vMyksoAr5b5wa/rk9/F4z3d/zMamf3fN33338n9/JHyGof8IoFUZ+SSC8MRF/TCamKvGJHwMFRlNg1HeFwawco6GCMQH31UtQILwxFBmTo7QfLah3FpEC+4eTMpQm4o19p3U1EP44wqNIROMK7EeJVPluu29OsBLh+OteSEeOSemPNibfcVBzhjqKjAnm3X1GqTDyiwHhjYm4I3Tqk0ut1zMqa9Mrat45Z0rPnympfFecragmzVZeaaJQHqO80W//MwVciog7NDD4sPLKlR8jorMV1e8wojOl50mzGZW1jW0tM5PPRLzR+asFwhnhsQY6HtzKq67LrqzJPv9uqc0sr8ooq3xXZFZUZZ+vzaqsKayr73p6T8QdEnBHvz0mhdwRJv3p5baWzPM/yphMe7djsvz5mCxvvDI03CXmjQjm905Wo1QY+WUgElCFvFHGRG/q+Sse+0o2HKv2P1bjn/CuOV77Lnlh1mVPyeH8i1OT/eJ/fv+lSEAVsIcHBrviM2rW7i9/9+H8aEFtOFbtsruopLGFxx4WC+bZg+Pc6f6aq61rdhX6JNY77atx2l/7jjnwrtlf63ygZs3hi2vicrp7H4pe2qsKqEIeZYrRm13T7LG/ZMOxql/AmDz+3KzrntI92bUMep9YMC+lN0qFkV8GIgFVhlLLGpu8j1Q+o7LnM1jfn8TgiAISLhQ2XFMRky8FhQlG9mWd35bZxBURP7eb3y119E6s3Vt0/+kjGUqfTw/iQmr/wAP3XQVn60fGxNDP/WUwyId+DmxN74g9XYkJyYs0c8akmFrXcs3zQNmjkemfu0O+W2IjeNip2oyqKyoJYz7dZ5QKI78MRAKqRjKxJ700LusqAOj1Op1O+zr0ej0AvKHAT4sOAA4VtsSdrQLVjHDOiYVIQJUKRx23pTXeGwEAne5NQc0fANDr9T9qUHq9Tq/Xue4qqr95R0Uw59ODUvHE3QftJjF592j6Z0wlB1XNit532CIVW6TqYWgqOvnWm7NwMUMk+KcxqZZMnCw4H5F86Sdo85e6+IePyZQLtyMSy0DJEvLffmJhlAojvwxEAqqGmNiRWrw7pwUA1GqVWq3SajUAAKAnvxpQqZQKhRxAr9Np5+aTO7iXCv/YqFRKAM2Rwmubz1wA1ezLUiGi2MaeaekeNwT1SvR63dx/mUbzphqVSoVKpXwp89ut8cOCUoBO4RxfUHfzrnreUnHnQftXIZnX++U0rhJADbofjCHpVKBTAQCAFnQqAC0AvAP7OjXoVc+m1NnXpsw2phPo5Lel4mhu5cbUxjd3Hwm5iyeTVqv+Ie2vUMh/WA8qATRnq9qDj5eBetYoFUZ+PZBSsfNsSXz2VQBQKuUqlUIqlczMTCEIX6VSKJVyEr1eX1V1YdeuXQKBQCDgqVRKMl+lUnI4s1wu25DzvVGpFKQPb81UKuUKuRR0sgO5V7aerX6lVNhtSWt+MAKge0N1KCqi02mjoyMUygiNNq5QyJRKxSsL6/X6LVs219df1Ov1cywop6enhELBD4+dRC4j9ArMaUdefXvn/KXi7sNbX4dmNfXKRmdkes0P9QEAGAz66OgIizUNACqVgs/nYhiqVitVKgWTyZg7Kr5nRyvlKqXs8YQyo3nSPDqDQJnfloqE/PNRpy+9suv/MQYUMp1OK5VKyB6kUEYIAv9+faHRqEUiZO3atVwuW6tVf7+4FAoZaGWny1tDT5YbpcLIr4oXUlG6I6sZAORyCQCMjg7/5je/2bx5EwDIZBK5/Pl0f2lpcUREeHFxUVPT5RdnHgAAxcUFZWUlc3NkMoluzsGpUimVySRaLXl8Cmq1QqEgAECrVQHoySqUSimKCnt6ugBgbqZYjPT0dM/NJJHJcNDg+881vE4qVm9Ju3JvEEBj2OQlAPSpqSkff/yxpaWlhYW5h8caMlKZTCKTSQBArZYrFFJDFGvWuBcVFQCAUikzBHjiREJ7+w0A0GqVAHq5XPK66uaDVIpp5ULHuNzvKhVfhWQ1PJYOMQmt+vvXTvZ+X1+vk5OjlZWVj483nT4BAD4+3g0N9QBQXFy0efMmvV6jUEh/SJgKOaGQSx6Ny89cZrxBKiKTLwLA64zIZBKtVi2TSZOSTllZWVlYmFtYmI+NjQLoyf7S6zVkP84dljKZBOD5qaRcTmg0ihc/6rjc2cWLF01PTxoKaDRKckiQnTt3+L3OJdDgSWXXwoxSYeRXxhypaALQKZVSiQQrLS1ycnKKjY0ZHR1RqeQA+traqrKyspCQoE2bNg4PD1OpFACoqakqKMi7fbt9dHRwYKAXAJqaGgsKcq9dawKA0dGhCxcqCgpyy8tLdDqlWq0cHR0qLMwrKMhDEK5SKXv06P7s7PSNG9dVKoVcLlGr5RwOKzQ0+Ny5zIcP7wGATqdSq2Vs9kxISHBOTnZX130yUybD5HKJTIaBBpuHVKjlcskrAYD4+LgjRw4ZBIxGo9y+3U5+bW+/MTPD1OlUxcWFhYV5g4MDISFBJSWFPT2PhUKeSiUfHR0aGOh9+vQxjUZ5/PgRj8e+dq1ZqZS+rrr5IJWiWjniGJfz3aUis/YR0c+QaNXfv3aVSv706ePAQP/BwX6NRn3rVntISND4+JiXl+e1a02XLtVFRkZIpdgPjFEulyjkEoUcvzciS7pEf5tU6F7vrUwkEiYlnTx27KhGo5ZKMakUU6nkXC6rsDCvoCB3ZGQAAG7fbi8tLSooyCUVHQAePLhbUJBbUVGq1SoRhFtQkFtQkMvlzspkuInJcj6fzWROkBY4HJZOp3r4sJPLZbW0XFWp5G+OSybDQYMllV39blKRYJQKI+89/ywVWq1WNTDwbPHixQBw9Ohh8sSiqqrS339DUFCQqanJgQP7Y2NjsrIyrl9v9vPbEBgYUFxcdODAvgMH9rW33wwKCggKCgoKCujo6Dh69NCnn34aFBTk6+uTl5cjk0m7uh5s3bo5Pj4uJSV5cLDvo48+DA4OysxM12jUMhkulWJarZLDmQkODomICE9IOD4yMgig12iUs7NTwcEhkZERCQnHR0eHAPRSKSaVoqBG9527tO1NUjEAoJLJ8FdCxmhtveLEiRPHjx/DcfTZs9716z0fPXrY2Xl3wwaf4eGBgoI8Hx9vf3+/5uamjRsjCwvzVq60JvdBJ08mbN++NSIivLAw39TUxMfHJzHxhEajeF1184EgxBqZ4DtLxaNbXwZnnr+PP6VjGuX3rx0AnJwcamouAIBCIQGAU6dO7t69MzZ2U0CA/969ewgCU6vlUin2Q2KUyXC5FJfLsNtD0pN1E+bRGQT2OqmoA9C+3lvN3bu3zMxMAUCpJBQKQqEgNBoFk0nfsiU2Pj5+z57d/f19lpYWq1fbBQUFhYaGdHbe7erqiowMDwoK2rx5E4NBS0pKjI+Pi4+PP3Hi2PDwgJWVJYJwBwefbdkSGx+/IzHxOIUy9PnnnwUG+qemntZq1W+OSyrFQI0mlRqlwsivDoNUxGVeBlBrtUoGg2ppaQEAJ04kHDiwDwAWLvx6bGwYACory7Zt2xIfvz0nJ8va2opKHSUH565d8adOnXR3d71zpx0AWlqaPT09jh07cvJkAgCgKPL555/L5fjo6OCOHdv37t39xz/+oaHh4ueff5aZmQYABCEmCJQgUIIQk3soCmUwOTk5MjKiq+uRYbZqZGQgOTk5Kiqip6dbo1FKJCJQivZmv0kqLnf2ASheGH8ZADh27Ii5uen+/fv37dvDZk8DaIeGBqOjo2Jiomk0qkDA+eKLL9RqGRmmj493QUGus7MjKRWnT5/as2dXbGx0aWmRmZnZ3r27AYA8tpVKMYJApVJUJsPIugyZbwbHhSqC77D93HeSis5HHX8PzCi6JeoeF6uVb6niDQDA2rVrKivLAID8evLk8UOH9m/evOk3v/nNzMzkP3fW90cqRaUy8Y0+/PCF8ddLxYWIpFoA9euM6PWqe/duW1uv0GoVL9pWrNHIEYQbHx+3Z8+ezz//PCsr3dNz3cDAMwCoqqoIDPTfsmVTWloK2aG3b7f/7ne/27t39969e3/729+WlhbZ268WifgMBnXHju179uz54x//UFtbtXjxolOnTgKAVPqWuCQSMShFiaXNRqkw8mvDIBXbMxsBNBKJyN/f9//9v//n7u7+8ccfffLJJw8edNrbr376tBsA8vNztm3bsmPH9nPnMp2dHZ896wFQA8Du3TsTE4/7+KxvaWkGgMuXLwYE+B07dphUmslJqo2N9a1bNyIiwkpKiouK8hcu/Lq2tsrBYbVSScjlmEQiIiEIkVyO6/Xajo6b4eHh+/btoVLHlUopmdne3hoeHrZ//56JCapCQeA4olcge7MuvkEqGu8+A53MYP8lAGDnzrjjx4+RfzGlkiAIEQBs375l//49AMBgjC9dukQo5Gg0cgDYsMEnPz/HwcGeFM7U1OTdu3du2hRdWJjn7OzIZk+p1TKJRKhQ4HI5LpGICEKsVBJkXQoFPjfS14FhAqWE+z2k4vOAjOwW5MGIUKV4SxVvAADc3FwqKkoAQC7HAeD48aP79u2Oidm4aVP0tm1beLxZtfq17Tl/CEIkJYTNPeiestE3SEV4Ui2A8nVGdDrF3bvtFhZmOp1SqZQoFLhGI5+dZYaHh2ZkpBUXF9vYWOfmZq9b59HZ2QEAJSWFMTEbd+7ccfp0EgAAaG/fvvnZZ58VFeWfO5dx4UL56Oignd2qW7daIyPDSkoKiosLFy1aWFVV6eTkgONChULy1rhwXKhTIInFTWEnK4xSYeRXxT+kIqMRQMvhzPztb3+7eLHmypWGzs5Oa2vrM2dOe3uvv3WrDUWx06dPxcbGbNmyOTPz7Lp1HrdvtwsEHLlcHh8fd+zYkeDgwNraKhTFKipKw8PDDh7ct2fPLnKHa21tVViY5+LiDAAAmtWr7crKii0tLXi8WakUw3ERjpP7U6Knp2vlSpvIyPDW1hYWi6nRKBUKSXf3w5UrbTZujGxtbZmdZarVCgwTYhiilSN7Mt8kFQ13noFWRtr/NgCwY8f22NhNKIrNzEyy2dMKhay0tGTPnl07d+6oq6vhcmcsLMzHx0c4nBmlUunl5ZmTk7VmjfujR/dRFDt06EB8fFxkZERe3jkbm5XDwwNKpVSn0yYkHM3NPafTaScmxvz8fIVCnk6nPXr0UGFhnk6nfZ0zJCgqkGNc+23fUSq6Oj4LyEhvEnQOICr5m+y/GZkMHx0dCgjw6+y8LRIJL126GBYWymLNuLu7XbnScOPGdX9/Pw5nxtBl3xuJRERIhI2PRDuLRsyjM6Svk4pTtQDK1xkhCBTHRZmZ6fHxcSKRYGZmksebHRrqW7x4kUjEB4DIyPCUlCRXVxfy+lNBQV5YWOiBA/sSEo6iKCYWC27cuO7i4gyg0es1iYnHr169Ym+/urS0yM5uFXlbsJOTQ3FxgbX1iqkpulwueWtcGCbUypCTxU1hiUapMPLr4p+lQs3lzvj4eCuVz+8bSUg4Ult7QSBgOzjYm5qafvnlguTkxMOHD5aVFXE40w4O9iYmy0+cSDh7NjU5ORFBBF5e60xNTX19vREESUg4eurUSZ1Ox2TSXF1dhEJuRUWJqamJqanJp5/+d2vr1fXrPfn8WXLWBceFMhk+OUnz9/d98ODO5CQNQCuX4zIZxmBQ/f03PHzYyWROkJkYhuC4EMMEWrngbVLRC1opaf/b6HTa3NzsZcuWrl5tt2qVbXh42P37d0NDg0UigUDACQz07+l59OzZY1NTExOT5aWlRbt376ytrZqamrC1tTE1NV2w4O/p6Wl79+4+f75swwbfsbFhhUKi1+u3b9+anHxKr9ePjQ3Z2uxDjuIAAAkaSURBVK5EEI5er9+yJTY19bRer3udMyQoypdj7O8qFfe6Oj71z0ht5N3p56vkb7L/ZjAM0emU4+Mjzs6OZmZmGzb4cjjTABAcHNTYeBEAamuroqOjVCopeQT9vZFIhIQEuXhfuD1v+I1SUQOgeIO3cjmuUikyM9PNzEyXL19uYrJ8fHykq+v+8uXLTE1NP/vs05qaC2FhoQ8fdup0uqqqyujoKLFYtHXrZlNTU0dHe5GIf+lSnampiZmZaUFBLpfLcnd3Y7On6+tryYH6yScfX7/e5OPjPTMzKZNh82lArUxwsviKUSqM/NowSMW2jAYABYoKmpoaGhsvNl6uv3y5vq6uur6+lsdjcbkzTCaNxZoUiXhCIVck4ikUOIs1OTU1weFMk5kKhYTNnmIyaRzOtFyBC4UcoZBL7tMFArZUKsZwhMmkkZugqEAgYGMYYgDHEbGYz2ZPKZWEXI5jmOBbmRiZSYKifI2Mvzuz7g1Scen2U72GmFvLXGQyfGCgt7KyrKSksLS0qKKipLX1KoJw5HJcLsd4PJZIxJPLselp+tTUBI/HEgq5YjFfLsdnZhhMJm12lmloDQRho6gAxxEcFwqFXJGIi+NCQ4w4LhQKOSIRj9ybvAGxmCtDZ+23ZX9nqfBLT6rndDzjKeVvsj8f5Ap8dpbJZNK43BmFAsdxIYJwRGIeOaU2O8t8axRvBccRCS6o6RRszh0ye71UhJ2qAZC/2ZRUimLY83E1NTWBogKZDJuammAyaWz2lFjMRxAOivJxXCgS8wQCtlyO8wWzTCZteppOECKJRMScmmAyaTiOSKViPn+WIMQSiZDM5HCmUZSPIGwMQzD87XGhKF8t5Z8oumyUCiO/NkipiE8r3ZbeAKAQirihocGOjg4ODvYODvbOzk5OTo5PnjzS6RRSqVgqFUskQomEPP4VSAkyRyTBhRKJEEUFBCGWSsUEIUJRAVkSRQUYJiBzyH8jCY4jBCHCMAGK/gOyJIa+PRNFBSIhR01wdmfWbk2refUjeJvPXOp4olPjKCr49uYoKlCrFTU1F1xdXUhcXJy3bo1VKiQ4hqCogCBEGIZgmOB54LhQIhHhOIKiAkMULzKFc2MhG+Qlzw2Zb4QvRNgy8Yz9tqyL7fe+k1R8suHsiTr27T4uqHkKgv8D0ShEGqVIrRAqCL6C4KkVQqVMoCB4SpngReYPQ8ZXEtzqu7yYc0OmG9NfKRXH8s6HJVYDSF/XfQZwXGjoEQwTGLrs+TCTiDAMIYsREnJkishf545JsmfJ/nrrQH0dYhFXRXBOFjWGniwHNdsoFUZ+PTxfAyqzIvp0tUbK4/OYUgkil4nnIhSweBwmnzv1/sDjMDmzExiPtjWlYkfmRVBxvi0VjtvOVlztlEvYPC7zlf7zOExUxJkbKSFBeJyfLSguZ5LNovFZFNvN6Y23H85fKu53dXwRlJXWLKq9x+mmsB4Mz/4CGJopvsXdUTxmGZMlw6dfsQZUUXXAsQo1wePzXt197xs8DpMzS8d4tAPZNVFJF4xSYeTXhYCqQGklDVedd+Rcar3FmujjTvZzGP8E+32kj03vvX7zpnNcRnHzHZ2SM/ftDiIBlUAo8enng46Vdj68z57sZzP6Xmfq/QmWM9k/Nf6ksPaK3daMx0MjCglzPvsaXEQdHOpavSVn3cGWuFzWrmxiVzb2C+CcZF+O2GFbffTp8wop558jpSowWs31Voe4c9XNbdO0Z9zJn328zXNMPmu/fWvNzqzMizd1Ss7r3to0l+dS8acmo1QYed8RCcZmZ4bO1V1z2JZhFZW6IirF6r1nRVSKVdRpy+jUpPJmMcYnsJmX/pYiPmWM1rf3XI1t7NkVz8u/76yIOm0ZlWK3JaPu1gO5XIQJ6fORCpFgHOGOtty967gt+6+e5z5wKfyTa8H7zwcuBR97Fm/YXzQ+SVfI+C+9x0kkGOPMDhc1tjrFZVr9YrovxSrqtGVUypHCRkTMk+Iso1QY+VWB8MYJlC4STvWOUtq6B9u6Btsev2Pan4y2P6G8K9oeD7V1D7Z1D3YPjaOYUK1EhALay0Hxx2U4k82ZfDQwcqN7oK37nQc19A4jan8y2vZ4sK178GbP0ACVrlJgciln/j2IIjQpPv3/t3c/vzHncRzHPwmJw17YdkOESmzWaU975O4PcEWwcXT0N8hqjWRvTv4ByV78qlsFiQOtamIYqtOwVNsxOh2lFepAQzDe38On0q8+Xnkcepof3/mmz7Sdzrc2VrsydGvgxuDAzcwuDw1fHhrJZ3jg5uDAjcGrt24/mvj/7cKLZmP0iyhOTdxtPX/QbNQHq9VL10twTl66PvLhnLw2fLfRnHwz3/j6nPwmqaBkmtP352bG5tv1hfZ4Wbxu1Weej3a+6v29mcaDV62xhVI9qVetseZ0oYsafa4xWWs3R+dny/JM6wvt8fnZ8faLh43O31KbU7W5mYclOydn663vnZNfkgrKqLpcJnL7/JaD39KU8BkVvqq2l6+cT+oTqQAgsPQOKKkAoAOpACAgFQAEpAKAgFQAEFi6trZUANCBVAAQkAoAAlIBQGApFT6EHIAOpAKAgFQAEJAKAAJSAUBAKgAIeLMsAAGpACAgFQAEpAKAwNKHkPuzNgAdSAUAAakAICAVAASkAoCAa2sDEJAKAAJSAUBAKgAILEMqdkoFwE9lGT6EXCoAfi5SAUBAKgAISAUAARdMBSDgzbIABKQCgIBUABCQCgACH1OxSSoA6EAqAAhIBQCB/Kn4Zddo2jd1+N/a4mL13cvY2w9fzN159xKAlWhxsXroWD1tzPcveGt33Fm3+/FfR58dOf34QOXRwcrEwcrT7zh08sn+vsm9/0zvPT4FwMrT+Lvvye97RtLWM6nrRJ5UpN/Ordn+X/rzfPrjXNp2Nm07H+u5kLb0p60XI/3FhLdT2JZ88t5jkeOQ8aaKPvj+Qooe/4Ivd5FDkU/mQ5FRvtN+VdxjVivztM9r84XUcyb1nE7dlUyp6D6VuvrS+t60vjdtKOh4+nVF2pBP3nv8wTf14x+815ESWRWvdW/qOpG6K9l+qjAzs1U+qTAzs2BSYWZmwaTCzMyCSYWZmQWTCjMzCyYVZmYW7D2ZfsDiVKyDKAAAAABJRU5ErkJggg==" /> </div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
Se a célula que se quer formatar condicionalmente contiver valores, deve-se manter o conteúdo do <b>1º campo</b> que estará <b>"o valor da célula é"</b>, <b>selecionar a frase</b> de comparação no <b>2º campo</b>, digitar um valor constante ou fómula no <b>3º e 4º campos</b>, e clicar no botão <b>Formatar</b>, daí escolher o formato que quiser (alterando cor de fonte, cor de preenchimento da célula). Se a célula contiver um texto, no <b>2º campo</b> escolher <b>é igual a</b> e no <b>3º campo digitar o texto</b> ao qual quer se aplicar a formatação, clicar no botão Formatar e definir a formatação desejada.<br />
<br />
<a href="https://docs.google.com/spreadsheet/ccc?key=0AjcieE70bZZddDVHYVRoaFE2eWtSVVBWZkg1UkNlSnc&hl=pt_BR">Exercício de Formatação Condicional</a><br />
<a href="https://docs.google.com/spreadsheet/ccc?key=0AjcieE70bZZddDFMRWFxTE5hMzREMW5wUlYxZFB6bmc&hl=pt_BR">Exercício de Formatação Condicional feito</a><br />
<a href="https://docs.google.com/spreadsheet/ccc?key=0AjcieE70bZZddDBtNmYtUl92TThsdVdEU20wNXBmSXc&hl=pt_BR">Exercício de PROCV para BA1</a> </div>Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-36329886378517102472011-09-28T16:46:00.003-07:002011-10-06T14:17:15.254-07:00Aula 6: Função SE<div style="font-family: inherit;">
<span style="font-size: small;">A função condicional <b>"se"</b> é
utilizada para retornar um determinado resultado mediante a um teste lógico
referente ao valor contido em uma célula indicada. </span></div>
<div style="font-family: inherit;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: inherit;">
<span style="font-size: small;">Por exemplo:</span></div>
<div style="font-family: inherit;">
<span style="font-size: small;">1) Se NOTA DO ALUNO for MAIOR QUE 7,0 o aluno está APROVADO, senão REPROVADO.</span></div>
<div style="font-family: inherit;">
<span style="font-size: small;">2) Se VALOR CONTAS DO MÊS for maior que SALÁRIO, indivíduo está ENDIVIDADO, senão EDUCADO FINANCEIRAMENTE</span></div>
<div style="font-family: inherit;">
<span style="font-size: small;">3) Se JOGADOR fez mais que 10 gols, o atleta é GOLEADOR, senão PERNA DE PAU.</span></div>
<div style="font-family: inherit;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: inherit; margin: 0cm; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;">À <b>função se</b> são passados
três argumentos inseridos entre parênteses e separados pelo sinal ; (ponto e
vírgula):</span></div>
<div style="font-family: inherit; margin: 0cm;">
<span style="font-size: small;"><b>Descrição dos argumentos</b></span></div>
<div class="MsoNormal" style="font-family: inherit; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>Teste lógico:</b></span><span style="font-size: small;"> Verifica uma
condição estabelecida. </span></div>
<div class="MsoNormal" style="font-family: inherit; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>Valor se verdadeiro:</b></span><span style="font-size: small;"> Apresenta um
resultado caso a condição estabelecida seja satisfeita. </span></div>
<div class="MsoNormal" style="font-family: inherit; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>Valor se falso: </b></span><span style="font-size: small;">Apresenta um
resultado caso a condição estabelecida não seja satisfeita. </span></div>
<br />
SINTAXE:<b> = SE(CÉLULA>=7;"APROVADO";"REPROVADO")</b><br />
<br />
<b>= SE(CÉLULA>=7;"APROVADO";SE(CÉLULA<=5;"REPROVADO";"RECUPERAÇÃO")</b><br />
<br />
<ul>
<li><a href="https://docs.google.com/document/d/1vZ9CWgiY3Ea4rN8CSkX4ZqC1DrWude-1-EmB60InmSI/edit?hl=pt_BR"><b>EXERCÍCIO 1</b></a></li>
<li><b>EXERCÍCIO 2</b></li>
<li><b>EXERCÍCIO 3</b></li>
</ul>
<div style="margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<br /></div>
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;"></span>
<iframe allowfullscreen="" frameborder="0" height="315" src="http://www.youtube.com/embed/uy64VOF1YYo" width="420"></iframe>Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-86689228320125922502011-09-28T16:46:00.001-07:002011-09-28T17:16:23.882-07:00Aula 5: Fórmulas e Valor Absoluto<br />
<div class="MsoNormal">
<a href="http://www.blogger.com/blogger.g?blogID=3622018861390281129" name="trinta6"></a><a href="http://www.blogger.com/blogger.g?blogID=3622018861390281129#indice"><b><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">ABSOLUTO:
</span></b><span style="font-family: "Arial","sans-serif"; font-size: 10pt;"></span></a></div>
<div class="MsoNormal" style="text-align: justify; text-indent: 45.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">É representada pelo
sinal de $ (cifrão), precedendo a linha ou coluna que ficará fixa.</span></div>
<div class="MsoNormal" style="text-align: justify; text-indent: 45.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">Linha absoluta - A$10</span></div>
<div class="MsoNormal" style="text-align: justify; text-indent: 45.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">Coluna absoluta - $A10</span></div>
<div class="MsoNormal" style="text-align: justify; text-indent: 45.0pt;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">Linha e Coluna
absolutas - $A$10<b><span style="font-family: "Arial","sans-serif"; font-weight: normal;"></span></b></span></div>
<div class="MsoNormal">
<b><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">Absoluto:</span></b></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; border: none; mso-border-alt: solid windowtext .5pt; mso-border-insideh: .5pt solid windowtext; mso-border-insidev: .5pt solid windowtext; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 480;">
<tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;">
<td style="background: #D9D9D9; border: solid windowtext 1.0pt; mso-border-alt: solid windowtext .5pt; mso-border-bottom-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<br /></div>
</td>
<td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">A</span></b></div>
</td>
<td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">B</span></b></div>
</td>
<td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">C</span></b></div>
</td>
<td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">D</span></b></div>
</td>
<td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">E</span></b></div>
</td>
<td style="background: #D9D9D9; border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .5pt; mso-border-left-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">F</span></b></div>
</td>
</tr>
<tr style="mso-yfti-irow: 1;">
<td style="background: #D9D9D9; border-top: none; border: solid windowtext 1.0pt; mso-border-bottom-alt: .75pt; mso-border-color-alt: windowtext; mso-border-left-alt: .5pt; mso-border-right-alt: .5pt; mso-border-style-alt: solid; mso-border-top-alt: .75pt; mso-border-top-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">1</span></b></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-bottom-alt: silver; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: windowtext; mso-border-right-alt: silver; mso-border-style-alt: solid; mso-border-top-alt: black; mso-border-top-alt: solid black .5pt; mso-border-width-alt: .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div class="MsoNormal">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">Absoluto
</span><span style="font-family: Wingdings; font-size: 10pt;">ê</span><span style="font-family: "Arial","sans-serif"; font-size: 10pt;"></span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div class="MsoNormal">
<br /></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">SOMA</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">SUB</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">MULT</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid black .5pt; mso-border-top-alt: solid black .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="text-align: center;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">DIV</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 2;">
<td style="background: #D9D9D9; border-top: none; border: solid windowtext 1.0pt; mso-border-bottom-alt: .75pt; mso-border-color-alt: windowtext; mso-border-left-alt: .5pt; mso-border-right-alt: .5pt; mso-border-style-alt: solid; mso-border-top-alt: .75pt; mso-border-top-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">2</span></b></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">5</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">6</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2+B2</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2-B2</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2*B2</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2/B2</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 3;">
<td style="background: #D9D9D9; border-top: none; border: solid windowtext 1.0pt; mso-border-bottom-alt: .75pt; mso-border-color-alt: windowtext; mso-border-left-alt: .5pt; mso-border-right-alt: .5pt; mso-border-style-alt: solid; mso-border-top-alt: .75pt; mso-border-top-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">3</span></b></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<br /></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">3</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2+B3</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2-B3</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2*B3</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2/B3</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 4;">
<td style="background: #D9D9D9; border-top: none; border: solid windowtext 1.0pt; mso-border-bottom-alt: .75pt; mso-border-color-alt: windowtext; mso-border-left-alt: .5pt; mso-border-right-alt: .5pt; mso-border-style-alt: solid; mso-border-top-alt: .75pt; mso-border-top-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">4</span></b></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<br /></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">9</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2+B4</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2-B4</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2*B4</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2/B4</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 5;">
<td style="background: #D9D9D9; border-top: none; border: solid windowtext 1.0pt; mso-border-bottom-alt: .75pt; mso-border-color-alt: windowtext; mso-border-left-alt: .5pt; mso-border-right-alt: .5pt; mso-border-style-alt: solid; mso-border-top-alt: .75pt; mso-border-top-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">5</span></b></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<br /></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">6</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2+B5</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2-B5</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2*B5</span></div>
</td>
<td style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid silver .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 69.85pt;" valign="top" width="93"><div align="right" class="MsoNormal" style="text-align: right;">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">=$A$2/B5</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 6;">
<td style="background: #D9D9D9; border-top: none; border: solid windowtext 1.0pt; mso-border-bottom-alt: .75pt; mso-border-color-alt: windowtext; mso-border-left-alt: .5pt; mso-border-right-alt: .5pt; mso-border-style-alt: solid; mso-border-top-alt: .75pt; mso-border-top-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">6</span></b></div>
</td>
<td colspan="6" style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 419.1pt;" valign="top" width="559"><div class="MsoNormal">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">Utilize
o sinal $ para indicar que uma célula é absoluto.</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 7;">
<td style="background: #D9D9D9; border-top: none; border: solid windowtext 1.0pt; mso-border-bottom-alt: .75pt; mso-border-color-alt: windowtext; mso-border-left-alt: .5pt; mso-border-right-alt: .5pt; mso-border-style-alt: solid; mso-border-top-alt: .75pt; mso-border-top-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">7</span></b></div>
</td>
<td colspan="6" style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 419.1pt;" valign="top" width="559"><div class="MsoNormal">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">Utilize
o sinal antes da coluna e antes da linha: $A$2</span></div>
</td>
</tr>
<tr style="mso-yfti-irow: 8; mso-yfti-lastrow: yes;">
<td style="background: #D9D9D9; border-top: none; border: solid windowtext 1.0pt; mso-border-bottom-alt: .75pt; mso-border-color-alt: windowtext; mso-border-left-alt: .5pt; mso-border-right-alt: .5pt; mso-border-style-alt: solid; mso-border-top-alt: .75pt; mso-border-top-alt: solid windowtext .75pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 24.15pt;" valign="top" width="32"><div align="center" class="MsoNormal" style="text-align: center;">
<b style="mso-bidi-font-weight: normal;"><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">8</span></b></div>
</td>
<td colspan="6" style="border-bottom: solid silver 1.0pt; border-left: none; border-right: solid silver 1.0pt; border-top: none; mso-border-alt: solid silver .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid silver .5pt; padding: 0cm 5.4pt 0cm 5.4pt; width: 419.1pt;" valign="top" width="559"><div class="MsoNormal">
<span style="font-family: "Arial","sans-serif"; font-size: 10pt;">Utilize
a Alça de Preenchimento para concluir as fórmulas </span></div>
</td>
</tr>
</tbody></table>
<br />
Fonte: Apostila Aprendendo Excel
Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-41500159391586744962011-09-28T16:45:00.001-07:002011-09-28T16:45:59.190-07:00Aula 4Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-78663037347553544812011-09-11T05:33:00.000-07:002012-06-01T18:10:27.666-07:00Aula 3: 13 de setembroAtalhos para Windows:<br />
<br />
<b>ALT + F4: </b>Fecha o Excel<br />
<b>CTRL + F4: </b>Fecha apenas o arquivo (Pasta de Trabalho) que está em uso.<br />
<b>SHIFT + setas de direção:</b> seleciona um grupo de células<br />
<b>SHIFT + barra de espaços:</b> seleciona toda a linha<br />
<br />
<br />
<div style="text-align: center;">
<i><b>Autopreenchimento</b></i> </div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: justify;">
Quando precisamos preencher uma faixa de células com textos ou valores iguais ou valores sequenciais, utilizamos o recurso de autopreenchimento. Para isso utilizaremos a Alça de Preechimento quando necessitarmos de valores sequenciais e os atalhos CTRL + R no autopreechimento à direita e CTRL + D no autopreenchimento abaixo quando necessitarmos de valores iguais.</div>
<div style="text-align: center;">
<div style="text-align: left;">
O vídeo abaixo mostra um exemplo de utilização deste recurso: </div>
<br /></div>
<iframe allowfullscreen="" frameborder="0" height="345" src="http://www.youtube.com/embed/CqdmnJufBd4" width="420"></iframe>
<br />
<div style="text-align: justify;">
</div>
<div style="margin-bottom: .0001pt; margin: 0cm;">
<span style="font-size: x-small;">Disponível em: http://www.youtube.com/watch?v=CqdmnJufBd4</span><br />
<br />
<a href="http://www.blogger.com/blogger.g?blogID=3622018861390281129#indice"><b><span style="font-family: "Arial","sans-serif"; font-size: 10pt;">CALCULANDO
NO EXCEL</span></b></a></div>
<br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">O Excel é possibilita a criação de cálculos simples,
com apenas um clique do mouse. Para executar qualquer operação matemática você
deve seguir alguns passos:</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">1° - Qualquer célula do Excel poderá executar um
cálculo, portanto, posicione a célula ativa no local onde deseja o resultado.
Você pode fazer isso clicando com o mouse ou utilizando as setas de direção do
teclado;</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">2° - Ao começar uma fórmula (conta, no Excel) sempre
a termine primeiro para depois executar outra tarefa;</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">3° - Sempre comece uma fórmula com o sinal de =
(igual);</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">4° Ao terminar a fórmula, pressione unicamente Enter
ou Tab.</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">Existem duas maneiras de você criar uma fórmula:</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">Você pode digitar a fórmula inteira, utilizando os
endereços das células. Exemplo:</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>=a2+b2</b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">Esta fórmula somaria o conteúdo da célula A2 com o
conteúdo da célula B2. Outros exemplos:</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>=c4-c5</b><b><span style="font-weight: normal;"> (Subtração)</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>=f8*g15</b><b><span style="font-weight: normal;"> (Multiplicação)</span></b></span></div>
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span><br />
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b>=a7/b32</b><b><span style="font-weight: normal;"> (Divisão)</span></b></span></div>
<div>
</div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">Outra maneira é utilizar o mouse. </span></b></span></div>
<div style="text-align: justify;">
<span style="font-size: small;"><span style="font-family: inherit;"></span></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">1°
- Digite o sinal de = (igual);</span></b></span></div>
<div style="text-align: justify;">
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">2°
Clique sobre a célula A1;</span></b></span></div>
<div style="text-align: justify;">
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b></b><b><span style="font-weight: normal;"></span></b></span></div>
<div style="text-align: justify;">
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">3° - Digite o sinal de + (soma)</span></b></span></div>
<div style="text-align: justify;">
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">4° - Clique sobre a célula B1;</span></b></span></div>
<div style="text-align: justify;">
<span style="font-size: small;"><span style="font-family: inherit;">
</span></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;">5° - Finalize com Enter.</span></b></span></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<br /></div>
<div style="font-family: inherit; margin: 0cm 0cm 0.0001pt; text-align: justify; text-indent: 45pt;">
<span style="font-size: small;"><b><span style="font-weight: normal;"><b><span style="font-size: x-small;">Conteúdo retirado da Apostila Aprendendo Microsoft Excel - Disponível em: http://www.oficinadanet.com.br/download.php?area=apostilas&id=685 - acesso em 11/09/2011 </span></b></span></b></span><br />
<br />
<div style="font-family: inherit;">
<i><u><span style="font-size: small;"><b><span style="font-weight: normal;">Exercícios:</span></b></span></u></i></div>
<span style="font-size: small;"><span style="font-family: inherit; font-weight: normal;"><span style="font-size: x-small;"><i><u><span style="font-size: small;"><b style="font-family: inherit;">1. Elaborar esta planilha e realizar os cálculos: <a href="https://docs.google.com/document/d/1LLWKsokJnpseUpARcKiMt8IxYSn2z7UWSNck_7ULApo/edit?hl=pt_BR">EXERCÍCIO 1</a></b></span></u></i> </span></span><b><span style="font-weight: normal;"><b><span style="font-size: x-small;"><br /></span></b></span></b></span></div>
<div style="text-align: justify;">
</div>Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-67848283304387680742011-09-07T18:32:00.000-07:002011-09-11T04:29:53.618-07:00Aula 2: Como os dados são interpretados e operadores matemáticos<br />
<div class="MsoNormal" style="text-align: justify;">
<span style="font-size: large;"><u><b>COMO OS DADOS SÃO INTERPRETADOS</b></u></span><br />
<br /></div>
<div class="MsoNormal" style="font-family: Arial,Helvetica,sans-serif; text-align: justify;">
Podemos digitar dois tipos de
dados nas planilhas:</div>
<div class="MsoNormal" style="font-family: Arial,Helvetica,sans-serif; text-align: justify;">
VALOR CONSTANTE: é digitado
diretamente na célula e pode ser um texto ou um número com vários formatos
(data, hora, moeda, porcentagem, fração ou notação científica)</div>
<div class="MsoNormal" style="font-family: Arial,Helvetica,sans-serif; text-align: justify;">
FÓRMULA: é uma sequência de
valores, referências de células, nomes, funções ou operadores que produzam um
novo valor a partir dos valores existentes. As fórmulas sempre começam com um
sinal de igual. Os valores resultantes das fórmulas são atualizados quando os
valores originais são alterados.</div>
<div class="MsoNormal" style="font-family: Arial,Helvetica,sans-serif; text-align: justify;">
<br /></div>
<div class="MsoNormal" style="font-family: Arial,Helvetica,sans-serif; text-align: center;">
<i><b><span style="font-size: small;"><u>OPERADORES MATEMÁTICOS</u></span></b></i></div>
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: medium none; font-family: Arial,Helvetica,sans-serif;">
<tbody>
<tr align="center">
<td style="border: 1pt solid black; padding: 0cm 5.4pt; width: 216.1pt;" valign="top" width="288"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<b><span style="font-size: small;"><i>ARITMÉTICOS</i></span></b></div>
</td>
<td style="border: 1pt solid black; padding: 0cm 5.4pt; width: 216.1pt;" valign="top" width="288"><div align="center" class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<b><span style="font-size: small;"><i>RELACIONAIS</i></span></b></div>
</td>
</tr>
<tr style="mso-yfti-irow: 1; mso-yfti-lastrow: yes;">
<td style="border: 1pt solid black; padding: 0cm 5.4pt; text-align: center; width: 216.1pt;" valign="top" width="288"><div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">^ Potenciação</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">& Concatenação</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">* Multiplicação</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">/ Divisão</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">+ Adição</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">- Subtração</span></div>
</td>
<td style="border-color: -moz-use-text-color black black -moz-use-text-color; border-style: none solid solid none; border-width: medium 1pt 1pt medium; padding: 0cm 5.4pt; text-align: center; width: 216.1pt;" valign="top" width="288"><div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">= Igualdade</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">< menor que</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">> maior que</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;"><= menor ou igual</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;">>= maior ou igual</span></div>
<div class="MsoNormal" style="line-height: normal; margin-bottom: 0cm;">
<span style="font-size: small;"><> diferente</span></div>
</td>
</tr>
</tbody></table>
Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0tag:blogger.com,1999:blog-3622018861390281129.post-7273588643359924632011-09-07T18:20:00.000-07:002012-05-27T18:23:05.902-07:00Aula 1: Excel, planilha, pasta de trabalho<br />
<div class="MsoNormal" style="text-align: justify;">
<b>MICROSOFT EXCEL</b></div>
<div>
</div>
<div class="MsoNormal" style="text-align: justify;">
Programa de planilha eletrônica
desenvolvido pela Microsoft que pode ser utilizado para calcular, armazenar,
trabalhar com lista de dados, fazer relatórios e gráficos. Recomendado para
planejamentos, previsões, análises estatísticas e financeiras, simulações e
manipulação numérica em geral.</div>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
</div>
<div class="MsoNormal" style="text-align: justify;">
<b>PLANILHA ELETRÔNICA</b> é um conjunto de colunas e linhas, cuja
a intersecção chamamos de células. Cada célula possui um endereço único ou
referência. Por exemplo, a referência da célula da coluna A com a linha 1 é A1.</div>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
</div>
<div class="MsoNormal" style="text-align: justify;">
<b>O EXCEL </b>possui 256 colunas identificadas por letras de A até
IV e 65.536 linhas.</div>
<div class="MsoNormal" style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
</div>
<div class="MsoNormal" style="text-align: justify;">
<b>PASTA de trabalho </b>é um arquivo do
Microsoft EXCEL. Cada pasta pode conter 255 planilhas, que podem diferir uma
das outras, podendo existir em uma mesma pasta planilhas com dados diferentes.</div>
<div style="text-align: justify;">
</div>
<div class="MsoNormal" style="text-align: justify;">
Para avançar de uma planilha para
outra (exemplo de PLAN1 para PLAN2) use as teclas de atalho CTRL+PAGEDOWN e
para retornar (exemplo de PLAN2 para PLAN1) use as teclas CTRL+PAGEUP.<br />
<br />
Tela do Excel 2003<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9FmezR_8nfAfl5Yk2WNqs9lxyGYQJXPnXir4aHLYCWcPdyUSm8eQRU3mQP_AGs_hFSg0Sa3T8MSqXj4tYMXSuvxvp6TqINPbHpt-kALdTR_N_Y7cip99tUhxztS8dsNrzF0NKglL7iB0/s1600/tela+do+excel.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="558" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi9FmezR_8nfAfl5Yk2WNqs9lxyGYQJXPnXir4aHLYCWcPdyUSm8eQRU3mQP_AGs_hFSg0Sa3T8MSqXj4tYMXSuvxvp6TqINPbHpt-kALdTR_N_Y7cip99tUhxztS8dsNrzF0NKglL7iB0/s640/tela+do+excel.png" width="540" /></a></div>
</div>Nelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com1tag:blogger.com,1999:blog-3622018861390281129.post-67612545717192310942011-09-07T18:17:00.000-07:002011-09-07T18:20:37.673-07:00BEM-VINDOS<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhL__T45LJLWV9ccgxT_r1DexYaMm-h2qC88eLM99lF3i5EtDG2KHhkLuMFo5jVH5CrosYe3mx0-aqoTaY5Ohyi9pnhKcX-bwMw6nu7AVKNWWA55ZeNot-qJYbrgbQ3XBqEffhc0wzQt9M/s1600/Excel2007.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="200" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhL__T45LJLWV9ccgxT_r1DexYaMm-h2qC88eLM99lF3i5EtDG2KHhkLuMFo5jVH5CrosYe3mx0-aqoTaY5Ohyi9pnhKcX-bwMw6nu7AVKNWWA55ZeNot-qJYbrgbQ3XBqEffhc0wzQt9M/s200/Excel2007.PNG" width="200" /></a></div>
<br />
<div style="text-align: justify;">
Alunos e alunas das turmas do 1º semestre dos cursos técnicos em Administração e Contabilidade da EMEB Dr. Liberato Salzano Vieira da Cunha, sejam muito bem-vindos a este blogue, que conterá teoria e orientações sobre o Excel, que é uma parte da nossa disciplina de Introdução à Informática. Através deste, espero facilitar e apoiar o aprendizado de vocês nesta ferramenta tão útil para quem lida com números.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaoBtUU3eJUs7kfTS0UddHFBiCSY6IO4ixCvc8m87aol1ItNCME8pqsyHWWpVtJ_p1IPvaiwMy-NmBA-uf2Zmqkcgfy9kRhZTHDQg8Xwnb4X5a3sNlkogz0tZvqhfVfJHrhGsD8Y6mH0A/s1600/orkut-hi5-myspace-abraco_%252839%2529.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="165" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaoBtUU3eJUs7kfTS0UddHFBiCSY6IO4ixCvc8m87aol1ItNCME8pqsyHWWpVtJ_p1IPvaiwMy-NmBA-uf2Zmqkcgfy9kRhZTHDQg8Xwnb4X5a3sNlkogz0tZvqhfVfJHrhGsD8Y6mH0A/s200/orkut-hi5-myspace-abraco_%252839%2529.gif" width="200" /></a></div>
<br />
<br />
Um abração,<br />
profª Jaqueline FrancoNelza Jaquelinehttp://www.blogger.com/profile/00336984908081876126noreply@blogger.com0