{"id":215,"date":"2026-04-07T07:49:05","date_gmt":"2026-04-07T07:49:05","guid":{"rendered":"https:\/\/www.visualaudit.pt\/?p=215"},"modified":"2026-04-07T07:49:05","modified_gmt":"2026-04-07T07:49:05","slug":"funcoes","status":"publish","type":"post","link":"https:\/\/www.visualaudit.pt\/index.php\/2026\/04\/07\/funcoes\/","title":{"rendered":"Fun\u00e7\u00f5es"},"content":{"rendered":"<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/2026\/03\/logo_aef.svg\" alt=\"\"><\/p>\n<h1>O seu Excel j\u00e1 fala &#8220;contabilistiqu\u00eas&#8221;?<\/h1>\n<div>An\u00e1lise contabil\u00edstica diretamente no Excel, sem tabelas auxiliares, sem f\u00f3rmulas complexas.<\/div>\n<div>\n<p class=\"p1\">O <span class=\"s1\"><b>Visual Audit &#8211; Excel Functions<\/b><\/span> \u00e9 um conjunto de fun\u00e7\u00f5es que transforma o Excel numa camada direta de an\u00e1lise sobre dados contabil\u00edsticos.<br \/>Na pr\u00e1tica, elimina a necessidade de:<\/p>\n<ul>\n<li class=\"p1\">exportar dados do ERP<\/li>\n<li class=\"p1\">construir tabelas auxiliares<\/li>\n<li class=\"p1\">criar pivots complexos<\/li>\n<li class=\"p1\">manter ficheiros interm\u00e9dios<\/li>\n<\/ul>\n<p class=\"p1\">Em vez disso, o utilizador trabalha diretamente com f\u00f3rmulas que v\u00e3o buscar os dados \u00e0 origem e devolvem o resultado j\u00e1 tratado.<br \/>Isto permite:<\/p>\n<ul>\n<li class=\"p1\">criar mapas de an\u00e1lise reutiliz\u00e1veis<\/li>\n<li class=\"p1\">atualizar resultados automaticamente<\/li>\n<li class=\"p1\">reduzir erros manuais<\/li>\n<li class=\"p1\">acelerar significativamente o trabalho de auditoria e controlo<\/li>\n<\/ul>\n<p class=\"p4\"><span class=\"s3\">O Visual Audit &#8211; Excel Functions funciona como uma <\/span><b>linguagem de consulta contabil\u00edstica dentro do Excel<\/b><span class=\"s3\">.<\/span><\/p>\n<pre>\u2022 Express\u00f5es de contas (21*, 11+12, 21* - 218) <br \/>\u2022 M\u00faltiplos exerc\u00edcios (EmpresaA + EmpresaB) <br \/>\u2022 Meses em formato flex\u00edvel (jan, 1, janeiro, fecho)<\/pre>\n<\/div>\n<h1>\n<p>Exemplos R\u00e1pidos<\/p>\n<\/h1>\n<div>\n<p class=\"p1\">Estes exemplos mostram o tipo de an\u00e1lises que normalmente exigiriam v\u00e1rias opera\u00e7\u00f5es no Excel \u2014 aqui resolvidas numa \u00fanica f\u00f3rmula.<\/p>\n<\/div>\n<ul>\n<li>\n<h3>Total de clientes<\/h3>\n<p>Agrega automaticamente todas as contas de clientes e devolve o saldo total.<\/p>\n<div>\n<p class=\"p1\">=VA.Saldo(<span class=\"s1\">&#8220;21&#8221;<\/span>, <span class=\"s1\">&#8220;AnoN&#8221;<\/span>)<\/p>\n<\/div>\n<\/li>\n<li>\n<h3>Clientes com saldo credor (an\u00f3malo)<\/h3>\n<p>Clientes com saldo credor s\u00e3o, em muitos casos, situa\u00e7\u00f5es que exigem an\u00e1lise.  Esta fun\u00e7\u00e3o permite identific\u00e1-los diretamente, sem necessidade de filtros adicionais.<\/p>\n<div>\n<p class=\"p1\">=VA.SaldoSeCredor(<span class=\"s1\">&#8220;211*&#8221;<\/span>, <span class=\"s1\">&#8220;AnoN&#8221;<\/span>)<\/p>\n<\/div>\n<\/li>\n<li>\n<h3>Gastos at\u00e9 junho<\/h3>\n<p>Permite acompanhar a evolu\u00e7\u00e3o de custos ao longo do ano.<\/p>\n<div>\n<p class=\"p1\">=VA.DebitoAteAoMes(<span class=\"s1\">&#8220;6222???&#8221;<\/span>, <span class=\"s2\">6<\/span>, <span class=\"s1\">&#8220;AnoN&#8221;<\/span>)<\/p>\n<\/div>\n<\/li>\n<li>\n<h3>Proveitos de um m\u00eas espec\u00edfico<\/h3>\n<p>Isola movimentos mensais, facilitando an\u00e1lises peri\u00f3dicas.<\/p>\n<div>\n<p class=\"p1\">=VA.CreditoDoMes(<span class=\"s1\">&#8220;71*&#8221;<\/span>, <span class=\"s1\">&#8220;jan&#8221;<\/span>, <span class=\"s1\">&#8220;AnoN&#8221;<\/span>)<\/p>\n<\/div>\n<\/li>\n<li>\n<h3>Excluir uma conta<\/h3>\n<p>Utilizando operadores de c\u00e1lculo (+,-), permite excluir contas espec\u00edficas sem alterar dados ou criar estruturas auxiliares.<\/p>\n<div>\n<p class=\"p1\"><span class=\"s1\">=VA.Saldo(<\/span>&#8220;21* &#8211; 218&#8221;<span class=\"s1\">, <\/span>&#8220;AnoN&#8221;<span class=\"s1\">)<\/span><\/p>\n<\/div>\n<\/li>\n<li>\n<h3>Comparar exerc\u00edcios<\/h3>\n<p>Permite an\u00e1lise comparativa direta, sem prepara\u00e7\u00e3o de dados.<\/p>\n<div>\n<p class=\"p1\">=VA.Saldo(<span class=\"s1\">&#8220;71*&#8221;<\/span>, <span class=\"s1\">&#8220;AnoN&#8221;<\/span>) &#8211; VA.Saldo(<span class=\"s1\">&#8220;71*&#8221;<\/span>, <span class=\"s1\">&#8220;AnoN-1&#8221;<\/span>)<\/p>\n<\/div>\n<\/li>\n<\/ul>\n<h1>\n<p>Como interpretar os par\u00e2metros utilizados nas fun\u00e7\u00f5es<\/p>\n<\/h1>\n<ul>\n<li>\n<h3>Contas<\/h3>\n<p>l\u00f3gica de sele\u00e7\u00e3o<\/p>\n<div>\n<p class=\"p1\">O par\u00e2metro <span class=\"s1\">conta<\/span> define que contas devem ser inclu\u00eddas no c\u00e1lculo.<br \/>Em vez de indicar apenas uma conta, \u00e9 poss\u00edvel definir regras:<\/p>\n<pre class=\"p1\">\"21*\"<span class=\"Apple-converted-space\">\u00a0 \u00a0 \u00a0 \u00a0 <\/span>\u2192 todas as contas da classe 21 <br \/>\"21* - 218\"<span class=\"Apple-converted-space\">\u00a0 <\/span>\u2192 todas exceto a 218 <br \/>\"11+12\"<span class=\"Apple-converted-space\">\u00a0 \u00a0 \u00a0 <\/span>\u2192 combina\u00e7\u00e3o de classes <br \/>\"12??\" <span class=\"Apple-converted-space\">\u00a0 \u00a0 \u00a0 <\/span>\u2192 padr\u00e3o com estrutura fixa<\/pre>\n<p class=\"p1\">Isto permite adaptar a an\u00e1lise diretamente na f\u00f3rmula, sem depender da estrutura do ficheiro.<br \/>Internamente, o sistema:<\/p>\n<ul>\n<li class=\"p1\">interpreta a express\u00e3o<\/li>\n<li class=\"p1\">resolve os padr\u00f5es<\/li>\n<li class=\"p1\">constr\u00f3i a lista de contas<\/li>\n<li class=\"p1\">aplica agrega\u00e7\u00e3o<\/li>\n<\/ul>\n<\/div>\n<\/li>\n<li>\n<h3>Meses<\/h3>\n<div>\n<p>Para o m\u00eas de janeiro \u00e9 poss\u00edvel utilizar:<\/p>\n<pre class=\"p1\">1<br \/>01<br \/>jan<br \/>janeiro<\/pre>\n<p class=\"p1\">Al\u00e9m dos meses normais, existem per\u00edodos adicionais:<\/p>\n<pre class=\"p1\">abertura <span class=\"Apple-converted-space\">\u00a0 \u00a0 \u00a0 \u00a0 <\/span>\u2192 in\u00edcio do exerc\u00edcio <br \/>regulariza\u00e7\u00f5es <span class=\"Apple-converted-space\">\u00a0 <\/span>\u2192 ajustes <br \/>apuramentos<span class=\"Apple-converted-space\">\u00a0 \u00a0 \u00a0 <\/span>\u2192 apuramento de resultados <br \/>fecho<span class=\"Apple-converted-space\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>\u2192 encerramento<\/pre>\n<p class=\"p1\">Isto permite an\u00e1lises mais completas do que um simples calend\u00e1rio mensal.<\/p>\n<\/div>\n<\/li>\n<li>\n<h3>Exerc\u00edcios<\/h3>\n<p>agrega\u00e7\u00e3o autom\u00e1tica<\/p>\n<div>\n<p class=\"p1\">O par\u00e2metro <span class=\"s1\">exercicio<\/span> define a origem dos dados.<br \/>Pode ser:<\/p>\n<ul>\n<li class=\"p1\">um \u00fanico exerc\u00edcio<\/li>\n<li class=\"p1\">v\u00e1rias empresas<\/li>\n<li class=\"p1\">combina\u00e7\u00f5es<\/li>\n<\/ul>\n<p class=\"p1\">Exemplo:<\/p>\n<pre>AnoN<br \/>AnoN + AnoN-1 <br \/>EmpresaA + EmpresaB<\/pre>\n<p class=\"p1\">Neste caso:<\/p>\n<ul>\n<li class=\"p1\">cada refer\u00eancia \u00e9 processada<\/li>\n<li class=\"p1\">os valores s\u00e3o agregados automaticamente<\/li>\n<\/ul>\n<p class=\"p1\">Isto elimina a necessidade de consolida\u00e7\u00e3o manual.<\/p>\n<\/div>\n<\/li>\n<\/ul>\n<h1>\n<p>Fun\u00e7\u00f5es de Contas<\/p>\n<\/h1>\n<ul>\n<li>\n<h3>VA.ContaExiste<\/h3>\n<p>Permite verificar se existem movimentos para uma conta antes de a incluir num mapa.<\/p>\n<div>\n<pre class=\"p1\">=VA.ContaExiste(<span class=\"s1\">\"21*\"<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.NomeDaConta<\/h3>\n<p>Devolve a descri\u00e7\u00e3o da conta, \u00fatil para tornar os mapas mais leg\u00edveis.<\/p>\n<div>\n<pre class=\"p1\">=VA.NomeDaConta(<span class=\"s1\">\"2111\"<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<\/pre>\n<\/div>\n<\/li>\n<\/ul>\n<hr>\n<h1>\n<p>Fun\u00e7\u00f5es de D\u00e9bito<\/p>\n<\/h1>\n<ul>\n<li>\n<h3>VA.Debito<\/h3>\n<p>Devolve o total acumulado a d\u00e9bito at\u00e9 ao fecho do exerc\u00edcio.<\/p>\n<div>\n<pre class=\"p1\">=VA.Debito(<span class=\"s1\">\"62*\"<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.DebitoAteAoMes<\/h3>\n<p>Devolve o d\u00e9bito acumulado desde a abertura at\u00e9 ao m\u00eas indicado.<\/p>\n<div>\n<pre>=VA.DebitoAteAoMes(\"62*\", 6, \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.DebitoNoMes<\/h3>\n<p>Devolve o valor a d\u00e9bito apenas no m\u00eas indicado.<\/p>\n<div>\n<pre>=VA.DebitoNoMes(\"62*\", \"jan\", \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.DebitoNoPeriodo<\/h3>\n<p>Devolve o total a d\u00e9bito entre os meses indicados.<\/p>\n<div>\n<pre>=VA.DebitoNoPeriodo(\"62*\", 1, 6, \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<\/ul>\n<hr>\n<h1>\n<p>Fun\u00e7\u00f5es de Cr\u00e9dito<\/p>\n<\/h1>\n<ul>\n<li>\n<h3>VA.Credito<\/h3>\n<p>Devolve o total acumulado a cr\u00e9dito at\u00e9 ao fecho do exerc\u00edcio.<\/p>\n<div>\n<pre>=VA.Credito(\"71*\", \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.CreditoAteAoMes<\/h3>\n<p>Devolve o cr\u00e9dito acumulado desde a abertura at\u00e9 ao m\u00eas indicado.<\/p>\n<div>\n<pre>=VA.CreditoAteAoMes(\"71*\", 6, \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.CreditoDoMes<\/h3>\n<p>Devolve o valor a cr\u00e9dito apenas no m\u00eas indicado.<\/p>\n<div>\n<pre>=VA.CreditoDoMes(\"71*\", \"jan\", \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.CreditoNoPeriodo<\/h3>\n<p>Devolve o total a cr\u00e9dito entre os meses indicados, soma valores mensais ,n\u00e3o corresponde a um acumulado cont\u00ednuo<\/p>\n<div>\n<pre>=VA.DebitoNoPeriodo(\"62*\", 1, 6, \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<\/ul>\n<hr>\n<h1>\n<p>Fun\u00e7\u00f5es de Saldo<\/p>\n<\/h1>\n<ul>\n<li>\n<h3>VA.Saldo<\/h3>\n<p>Devolve o saldo acumulado at\u00e9 ao fecho do exerc\u00edcio.<\/p>\n<div>\n<pre>==VA.Saldo(\"2111\", \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.SaldoAteAoMes<\/h3>\n<p>Devolve o saldo acumulado desde a abertura at\u00e9 ao m\u00eas indicado.<\/p>\n<div>\n<pre>=VA.SaldoAteAoMes(\"121\", 6, \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.SaldoDoMes<\/h3>\n<p>Devolve o saldo apenas no m\u00eas indicado.<\/p>\n<div>\n<pre>=VA.SaldoDoMes(\"51\", \"jan\", \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.CreditoNoPeriodo<\/h3>\n<p>Devolve o total a cr\u00e9dito entre os meses indicados, soma valores mensais ,n\u00e3o corresponde a um acumulado cont\u00ednuo<\/p>\n<div>\n<pre>=VA.DebitoNoPeriodo(\"62*\", 1, 6, \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<\/ul>\n<hr>\n<h1>\n<p>Filtros (Credor \/ Devedor)<\/p>\n<\/h1>\n<ul>\n<li>\n<h3>VA.SaldoSeCredor<\/h3>\n<p>Devolve o saldo apenas se for credor, retorna valores negativos, caso contr\u00e1rio retorna 0<\/p>\n<div>\n<pre>=VA.SaldoSeCredor(\"21*\", \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<li>\n<h3>VA.SaldoSeDevedor<\/h3>\n<p>Devolve o saldo apenas se for devedor,retorna valores positivos, aso contr\u00e1rio retorna 0<\/p>\n<div>\n<pre>=VA.SaldoSeDevedor(\"221?????\", \"AnoN\")<\/pre>\n<\/div>\n<\/li>\n<\/ul>\n<div>\n<p>Variantes por m\u00eas e per\u00edodo<\/p>\n<pre class=\"p1\">=VA.SaldoDoMesSeDevedor(<span class=\"s1\">\"21*\"<\/span>, <span class=\"s1\">\"jan\"<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<br \/>=VA.SaldoDoMesSeCredor(<span class=\"s1\">\"21*\"<\/span>, <span class=\"s1\">\"jan\"<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<br \/>=VA.SaldoAteAoMesSeDevedor(<span class=\"s1\">\"21*\"<\/span>, <span class=\"s2\">6<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<br \/>=VA.SaldoAteAoMesSeCredor(<span class=\"s1\">\"21*\"<\/span>, <span class=\"s2\">6<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<br \/>=VA.SaldoNoPeriodoSeDevedor(<span class=\"s1\">\"21*\"<\/span>, <span class=\"s2\">1<\/span>, <span class=\"s2\">6<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<br \/>=VA.SaldoNoPeriodoSeCredor(<span class=\"s1\">\"21*\"<\/span>, <span class=\"s2\">1<\/span>, <span class=\"s2\">6<\/span>, <span class=\"s1\">\"AnoN\"<\/span>)<\/pre>\n<ul>\n<li class=\"p1\">Aplicam o mesmo comportamento ao per\u00edodo indicado<\/li>\n<li class=\"p1\">Primeiro calculam o saldo<\/li>\n<li class=\"p1\">Depois aplicam o filtro ao resultado<\/li>\n<\/ul>\n<\/div>\n<p><!--more--><br \/>\n<!-- {\"type\":\"layout\",\"children\":[{\"type\":\"section\",\"props\":{\"image_position\":\"center-center\",\"padding_top\":\"xsmall\",\"style\":\"primary\",\"title_breakpoint\":\"xl\",\"title_position\":\"top-left\",\"title_rotation\":\"left\",\"vertical_align\":\"middle\",\"width\":\"default\"},\"children\":[{\"type\":\"row\",\"children\":[{\"type\":\"column\",\"props\":{\"image_position\":\"center-center\",\"position_sticky_breakpoint\":\"m\"},\"children\":[{\"type\":\"image\",\"props\":{\"image\":\"wp-content\/uploads\/2026\/03\/logo_aef.svg\",\"image_height\":70,\"image_svg_color\":\"emphasis\",\"margin_bottom\":\"default\",\"margin_top\":\"default\"}},{\"type\":\"headline\",\"props\":{\"content\":\"O seu Excel j\u00e1 fala \\\"contabilistiqu\u00eas\\\"?\",\"image_align\":\"left\",\"image_margin\":\"xsmall\",\"text_align\":\"center\",\"title_element\":\"h1\",\"title_style\":\"heading-small\"}},{\"type\":\"text\",\"props\":{\"column_breakpoint\":\"m\",\"content\":\"An\u00e1lise contabil\u00edstica diretamente no Excel, sem tabelas auxiliares, sem f\u00f3rmulas complexas.\",\"margin_bottom\":\"default\",\"margin_top\":\"default\",\"text_align\":\"center\",\"text_style\":\"lead\"}}]}]}],\"name\":\"Contabilistiqu\u00eas\"},{\"type\":\"section\",\"props\":{\"image_position\":\"center-center\",\"style\":\"\",\"title_breakpoint\":\"xl\",\"title_position\":\"top-left\",\"title_rotation\":\"left\",\"vertical_align\":\"middle\",\"width\":\"default\"},\"children\":[{\"type\":\"row\",\"children\":[{\"type\":\"column\",\"props\":{\"image_position\":\"center-center\",\"position_sticky_breakpoint\":\"m\"},\"children\":[{\"type\":\"text\",\"props\":{\"column_breakpoint\":\"m\",\"content\":\"\n\n<p class=\\\"p1\\\">O <span class=\\\"s1\\\"><b>Visual Audit - Excel Functions<\/b><\/span> \u00e9 um conjunto de fun\u00e7\u00f5es que transforma o Excel numa camada direta de an\u00e1lise sobre dados contabil\u00edsticos.<br \/>Na pr\u00e1tica, elimina a necessidade de:<\/p>\n\n\\n\n\n<ul>\\n\n\n<li class=\\\"p1\\\">exportar dados do ERP<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">construir tabelas auxiliares<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">criar pivots complexos<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">manter ficheiros interm\u00e9dios<\/li>\n\n\\n<\/ul>\n\n\\n\n\n<p class=\\\"p1\\\">Em vez disso, o utilizador trabalha diretamente com f\u00f3rmulas que v\u00e3o buscar os dados \u00e0 origem e devolvem o resultado j\u00e1 tratado.<br \/>Isto permite:<\/p>\n\n\\n\n\n<ul>\\n\n\n<li class=\\\"p1\\\">criar mapas de an\u00e1lise reutiliz\u00e1veis<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">atualizar resultados automaticamente<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">reduzir erros manuais<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">acelerar significativamente o trabalho de auditoria e controlo<\/li>\n\n\\n<\/ul>\n\n\\n\n\n<p class=\\\"p4\\\"><span class=\\\"s3\\\">O Visual Audit - Excel Functions funciona como uma <\/span><b>linguagem de consulta contabil\u00edstica dentro do Excel<\/b><span class=\\\"s3\\\">.<\/span><\/p>\n\n\\n\n\n<pre>\u2022 Express\u00f5es de contas (21*, 11+12, 21* - 218) <br \/>\u2022 M\u00faltiplos exerc\u00edcios (EmpresaA + EmpresaB) <br \/>\u2022 Meses em formato flex\u00edvel (jan, 1, janeiro, fecho)<\/pre>\n\n\",\"margin_bottom\":\"default\",\"margin_top\":\"default\"}},{\"type\":\"headline\",\"props\":{\"content\":\"\n\n<p>Exemplos R\u00e1pidos<\/p>\n\n\",\"image_align\":\"left\",\"image_margin\":\"xsmall\",\"title_element\":\"h1\",\"title_style\":\"text-lead\"}},{\"type\":\"text\",\"props\":{\"column_breakpoint\":\"m\",\"content\":\"\n\n<p class=\\\"p1\\\">Estes exemplos mostram o tipo de an\u00e1lises que normalmente exigiriam v\u00e1rias opera\u00e7\u00f5es no Excel \u2014 aqui resolvidas numa \u00fanica f\u00f3rmula.<\/p>\n\n\",\"margin_bottom\":\"default\",\"margin_top\":\"default\"}},{\"type\":\"grid\",\"props\":{\"content_column_breakpoint\":\"m\",\"filter_align\":\"left\",\"filter_all\":true,\"filter_grid_breakpoint\":\"m\",\"filter_grid_width\":\"auto\",\"filter_position\":\"top\",\"filter_style\":\"tab\",\"grid_column_align\":false,\"grid_default\":\"1\",\"grid_medium\":\"3\",\"image_align\":\"top\",\"image_grid_breakpoint\":\"m\",\"image_grid_width\":\"1-2\",\"image_svg_color\":\"emphasis\",\"item_animation\":true,\"lightbox_bg_close\":true,\"link_style\":\"default\",\"link_text\":\"Read more\",\"margin_bottom\":\"default\",\"margin_top\":\"default\",\"meta_align\":\"below-title\",\"meta_element\":\"div\",\"meta_style\":\"text-meta\",\"panel_padding\":\"small\",\"panel_style\":\"card-secondary\",\"show_content\":true,\"show_hover_image\":true,\"show_hover_video\":true,\"show_image\":true,\"show_link\":true,\"show_meta\":true,\"show_title\":true,\"show_video\":true,\"title_align\":\"top\",\"title_element\":\"h3\",\"title_grid_breakpoint\":\"m\",\"title_grid_width\":\"1-2\",\"title_hover_style\":\"reset\",\"title_style\":\"text-small\"},\"children\":[{\"type\":\"grid_item\",\"props\":{\"content\":\"\n\n<p class=\\\"p1\\\">=VA.Saldo(<span class=\\\"s1\\\">\\\"21\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<\/p>\n\n\",\"meta\":\"Agrega automaticamente todas as contas de clientes e devolve o saldo total.\",\"title\":\"Total de clientes\"}},{\"type\":\"grid_item\",\"props\":{\"content\":\"\n\n<p class=\\\"p1\\\">=VA.SaldoSeCredor(<span class=\\\"s1\\\">\\\"211*\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<\/p>\n\n\",\"meta\":\"Clientes com saldo credor s\u00e3o, em muitos casos, situa\u00e7\u00f5es que exigem an\u00e1lise.  Esta fun\u00e7\u00e3o permite identific\u00e1-los diretamente, sem necessidade de filtros adicionais.\",\"title\":\"Clientes com saldo credor (an\u00f3malo)\"}},{\"type\":\"grid_item\",\"props\":{\"content\":\"\n\n<p class=\\\"p1\\\">=VA.DebitoAteAoMes(<span class=\\\"s1\\\">\\\"6222???\\\"<\/span>, <span class=\\\"s2\\\">6<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<\/p>\n\n\",\"meta\":\"Permite acompanhar a evolu\u00e7\u00e3o de custos ao longo do ano.\",\"title\":\"Gastos at\u00e9 junho\"}},{\"type\":\"grid_item\",\"props\":{\"content\":\"\n\n<p class=\\\"p1\\\">=VA.CreditoDoMes(<span class=\\\"s1\\\">\\\"71*\\\"<\/span>, <span class=\\\"s1\\\">\\\"jan\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<\/p>\n\n\",\"meta\":\"Isola movimentos mensais, facilitando an\u00e1lises peri\u00f3dicas.\",\"title\":\"Proveitos de um m\u00eas espec\u00edfico\"}},{\"type\":\"grid_item\",\"props\":{\"content\":\"\n\n<p class=\\\"p1\\\"><span class=\\\"s1\\\">=VA.Saldo(<\/span>\\\"21* - 218\\\"<span class=\\\"s1\\\">, <\/span>\\\"AnoN\\\"<span class=\\\"s1\\\">)<\/span><\/p>\n\n\",\"meta\":\"Utilizando operadores de c\u00e1lculo (+,-), permite excluir contas espec\u00edficas sem alterar dados ou criar estruturas auxiliares.\",\"title\":\"Excluir uma conta\"}},{\"type\":\"grid_item\",\"props\":{\"content\":\"\n\n<p class=\\\"p1\\\">=VA.Saldo(<span class=\\\"s1\\\">\\\"71*\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>) - VA.Saldo(<span class=\\\"s1\\\">\\\"71*\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN-1\\\"<\/span>)<\/p>\n\n\",\"meta\":\"Permite an\u00e1lise comparativa direta, sem prepara\u00e7\u00e3o de dados.\",\"title\":\"Comparar exerc\u00edcios\"}}]}]}]}]},{\"type\":\"section\",\"props\":{\"image_position\":\"center-center\",\"style\":\"muted\",\"title_breakpoint\":\"xl\",\"title_position\":\"top-left\",\"title_rotation\":\"left\",\"vertical_align\":\"middle\",\"width\":\"default\"},\"children\":[{\"type\":\"row\",\"children\":[{\"type\":\"column\",\"props\":{\"image_position\":\"center-center\",\"position_sticky_breakpoint\":\"m\"},\"children\":[{\"type\":\"headline\",\"props\":{\"content\":\"\n\n<p>Como interpretar os par\u00e2metros utilizados nas fun\u00e7\u00f5es<\/p>\n\n\",\"image_align\":\"left\",\"image_margin\":\"xsmall\",\"title_element\":\"h1\",\"title_style\":\"text-lead\"}},{\"type\":\"switcher\",\"props\":{\"content_column_breakpoint\":\"m\",\"image_align\":\"top\",\"image_grid_breakpoint\":\"m\",\"image_grid_width\":\"1-2\",\"image_svg_color\":\"emphasis\",\"link_style\":\"default\",\"link_text\":\"Read more\",\"margin_bottom\":\"default\",\"margin_top\":\"default\",\"meta_align\":\"below-title\",\"meta_element\":\"div\",\"meta_style\":\"text-meta\",\"nav\":\"tab\",\"nav_align\":\"left\",\"nav_grid_breakpoint\":\"m\",\"nav_grid_width\":\"auto\",\"nav_position\":\"top\",\"show_content\":true,\"show_image\":true,\"show_label\":true,\"show_link\":true,\"show_meta\":true,\"show_thumbnail\":true,\"show_title\":true,\"switcher_animation\":\"fade\",\"switcher_height\":true,\"thumbnav_height\":\"75\",\"thumbnav_svg_color\":\"emphasis\",\"thumbnav_width\":\"100\",\"title_align\":\"top\",\"title_element\":\"h3\",\"title_grid_breakpoint\":\"m\",\"title_grid_width\":\"1-2\"},\"children\":[{\"type\":\"switcher_item\",\"props\":{\"content\":\"\n\n<p class=\\\"p1\\\">O par\u00e2metro <span class=\\\"s1\\\">conta<\/span> define que contas devem ser inclu\u00eddas no c\u00e1lculo.<br \/>Em vez de indicar apenas uma conta, \u00e9 poss\u00edvel definir regras:<\/p>\n\n\\n\n\n<pre class=\\\"p1\\\">\\\"21*\\\"<span class=\\\"Apple-converted-space\\\">\u00a0 \u00a0 \u00a0 \u00a0 <\/span>\u2192 todas as contas da classe 21 <br \/>\\\"21* - 218\\\"<span class=\\\"Apple-converted-space\\\">\u00a0 <\/span>\u2192 todas exceto a 218 <br \/>\\\"11+12\\\"<span class=\\\"Apple-converted-space\\\">\u00a0 \u00a0 \u00a0 <\/span>\u2192 combina\u00e7\u00e3o de classes <br \/>\\\"12??\\\" <span class=\\\"Apple-converted-space\\\">\u00a0 \u00a0 \u00a0 <\/span>\u2192 padr\u00e3o com estrutura fixa<\/pre>\n\n\\n\n\n<p class=\\\"p1\\\">Isto permite adaptar a an\u00e1lise diretamente na f\u00f3rmula, sem depender da estrutura do ficheiro.<br \/>Internamente, o sistema:<\/p>\n\n\\n\n\n<ul>\\n\n\n<li class=\\\"p1\\\">interpreta a express\u00e3o<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">resolve os padr\u00f5es<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">constr\u00f3i a lista de contas<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">aplica agrega\u00e7\u00e3o<\/li>\n\n\\n<\/ul>\n\n\",\"meta\":\"l\u00f3gica de sele\u00e7\u00e3o\",\"title\":\"Contas\"}},{\"type\":\"switcher_item\",\"props\":{\"content\":\"\n\n<p>Para o m\u00eas de janeiro \u00e9 poss\u00edvel utilizar:<\/p>\n\n\\n\n\n<pre class=\\\"p1\\\">1<br \/>01<br \/>jan<br \/>janeiro<\/pre>\n\n\\n\n\n<p class=\\\"p1\\\">Al\u00e9m dos meses normais, existem per\u00edodos adicionais:<\/p>\n\n\\n\n\n<pre class=\\\"p1\\\">abertura <span class=\\\"Apple-converted-space\\\">\u00a0 \u00a0 \u00a0 \u00a0 <\/span>\u2192 in\u00edcio do exerc\u00edcio <br \/>regulariza\u00e7\u00f5es <span class=\\\"Apple-converted-space\\\">\u00a0 <\/span>\u2192 ajustes <br \/>apuramentos<span class=\\\"Apple-converted-space\\\">\u00a0 \u00a0 \u00a0 <\/span>\u2192 apuramento de resultados <br \/>fecho<span class=\\\"Apple-converted-space\\\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 <\/span>\u2192 encerramento<\/pre>\n\n\\n\n\n<p class=\\\"p1\\\">Isto permite an\u00e1lises mais completas do que um simples calend\u00e1rio mensal.<\/p>\n\n\",\"title\":\"Meses\"}},{\"type\":\"switcher_item\",\"props\":{\"content\":\"\n\n<p class=\\\"p1\\\">O par\u00e2metro <span class=\\\"s1\\\">exercicio<\/span> define a origem dos dados.<br \/>Pode ser:<\/p>\n\n\\n\n\n<ul>\\n\n\n<li class=\\\"p1\\\">um \u00fanico exerc\u00edcio<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">v\u00e1rias empresas<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">combina\u00e7\u00f5es<\/li>\n\n\\n<\/ul>\n\n\\n\n\n<p class=\\\"p1\\\">Exemplo:<\/p>\n\n\\n\n\n<pre>AnoN<br \/>AnoN + AnoN-1 <br \/>EmpresaA + EmpresaB<\/pre>\n\n\\n\n\n<p class=\\\"p1\\\">Neste caso:<\/p>\n\n\\n\n\n<ul>\\n\n\n<li class=\\\"p1\\\">cada refer\u00eancia \u00e9 processada<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">os valores s\u00e3o agregados automaticamente<\/li>\n\n\\n<\/ul>\n\n\\n\n\n<p class=\\\"p1\\\">Isto elimina a necessidade de consolida\u00e7\u00e3o manual.<\/p>\n\n\",\"meta\":\"agrega\u00e7\u00e3o autom\u00e1tica\",\"title\":\"Exerc\u00edcios\"}}]}]}]}]},{\"type\":\"section\",\"props\":{\"image_position\":\"center-center\",\"style\":\"default\",\"title_breakpoint\":\"xl\",\"title_position\":\"top-left\",\"title_rotation\":\"left\",\"vertical_align\":\"middle\",\"width\":\"default\"},\"children\":[{\"type\":\"row\",\"children\":[{\"type\":\"column\",\"props\":{\"image_position\":\"center-center\",\"position_sticky_breakpoint\":\"m\"},\"children\":[{\"type\":\"headline\",\"props\":{\"content\":\"\n\n<p>Fun\u00e7\u00f5es de Contas<\/p>\n\n\",\"image_align\":\"left\",\"image_margin\":\"xsmall\",\"title_element\":\"h1\",\"title_style\":\"text-lead\"}},{\"type\":\"description_list\",\"props\":{\"column_breakpoint\":\"m\",\"layout\":\"grid-2\",\"list_element\":\"ul\",\"meta_align\":\"below-content\",\"meta_style\":\"text-meta\",\"show_content\":true,\"show_link\":true,\"show_meta\":true,\"show_title\":true,\"title_element\":\"div\",\"title_grid_column_gap\":\"small\",\"title_grid_row_gap\":\"small\",\"title_grid_width\":\"small\",\"title_style\":\"text-small\"},\"children\":[{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre class=\\\"p1\\\">=VA.ContaExiste(<span class=\\\"s1\\\">\\\"21*\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<\/pre>\n\n\",\"meta\":\"Permite verificar se existem movimentos para uma conta antes de a incluir num mapa.\",\"title\":\"VA.ContaExiste\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre class=\\\"p1\\\">=VA.NomeDaConta(<span class=\\\"s1\\\">\\\"2111\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<\/pre>\n\n\",\"meta\":\"Devolve a descri\u00e7\u00e3o da conta, \u00fatil para tornar os mapas mais leg\u00edveis.\",\"title\":\"VA.NomeDaConta\"}}]},{\"type\":\"divider\",\"props\":{\"divider_element\":\"hr\"}},{\"type\":\"headline\",\"props\":{\"content\":\"\n\n<p>Fun\u00e7\u00f5es de D\u00e9bito<\/p>\n\n\",\"image_align\":\"left\",\"image_margin\":\"xsmall\",\"title_element\":\"h1\",\"title_style\":\"text-lead\"}},{\"type\":\"description_list\",\"props\":{\"column_breakpoint\":\"m\",\"layout\":\"grid-2\",\"list_element\":\"ul\",\"meta_align\":\"below-content\",\"meta_style\":\"text-meta\",\"show_content\":true,\"show_link\":true,\"show_meta\":true,\"show_title\":true,\"title_element\":\"div\",\"title_grid_column_gap\":\"small\",\"title_grid_row_gap\":\"small\",\"title_grid_width\":\"small\",\"title_style\":\"text-small\"},\"children\":[{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre class=\\\"p1\\\">=VA.Debito(<span class=\\\"s1\\\">\\\"62*\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<\/pre>\n\n\",\"meta\":\"Devolve o total acumulado a d\u00e9bito at\u00e9 ao fecho do exerc\u00edcio.\",\"title\":\"VA.Debito\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.DebitoAteAoMes(\\\"62*\\\", 6, \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o d\u00e9bito acumulado desde a abertura at\u00e9 ao m\u00eas indicado.\",\"title\":\"VA.DebitoAteAoMes\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.DebitoNoMes(\\\"62*\\\", \\\"jan\\\", \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o valor a d\u00e9bito apenas no m\u00eas indicado.\",\"title\":\"VA.DebitoNoMes\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.DebitoNoPeriodo(\\\"62*\\\", 1, 6, \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o total a d\u00e9bito entre os meses indicados.\",\"title\":\"VA.DebitoNoPeriodo\"}}]},{\"type\":\"divider\",\"props\":{\"divider_element\":\"hr\"}},{\"type\":\"headline\",\"props\":{\"content\":\"\n\n<p>Fun\u00e7\u00f5es de Cr\u00e9dito<\/p>\n\n\",\"image_align\":\"left\",\"image_margin\":\"xsmall\",\"title_element\":\"h1\",\"title_style\":\"text-lead\"}},{\"type\":\"description_list\",\"props\":{\"column_breakpoint\":\"m\",\"layout\":\"grid-2\",\"list_element\":\"ul\",\"meta_align\":\"below-content\",\"meta_style\":\"text-meta\",\"show_content\":true,\"show_link\":true,\"show_meta\":true,\"show_title\":true,\"title_element\":\"div\",\"title_grid_column_gap\":\"small\",\"title_grid_row_gap\":\"small\",\"title_grid_width\":\"small\",\"title_style\":\"text-small\"},\"children\":[{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.Credito(\\\"71*\\\", \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o total acumulado a cr\u00e9dito at\u00e9 ao fecho do exerc\u00edcio.\",\"title\":\"VA.Credito\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.CreditoAteAoMes(\\\"71*\\\", 6, \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o cr\u00e9dito acumulado desde a abertura at\u00e9 ao m\u00eas indicado.\",\"title\":\"VA.CreditoAteAoMes\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.CreditoDoMes(\\\"71*\\\", \\\"jan\\\", \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o valor a cr\u00e9dito apenas no m\u00eas indicado.\",\"title\":\"VA.CreditoDoMes\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.DebitoNoPeriodo(\\\"62*\\\", 1, 6, \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o total a cr\u00e9dito entre os meses indicados, soma valores mensais ,n\u00e3o corresponde a um acumulado cont\u00ednuo\",\"title\":\"VA.CreditoNoPeriodo\"}}]},{\"type\":\"divider\",\"props\":{\"divider_element\":\"hr\"}},{\"type\":\"headline\",\"props\":{\"content\":\"\n\n<p>Fun\u00e7\u00f5es de Saldo<\/p>\n\n\",\"image_align\":\"left\",\"image_margin\":\"xsmall\",\"title_element\":\"h1\",\"title_style\":\"text-lead\"}},{\"type\":\"description_list\",\"props\":{\"column_breakpoint\":\"m\",\"layout\":\"grid-2\",\"list_element\":\"ul\",\"meta_align\":\"below-content\",\"meta_style\":\"text-meta\",\"show_content\":true,\"show_link\":true,\"show_meta\":true,\"show_title\":true,\"title_element\":\"div\",\"title_grid_column_gap\":\"small\",\"title_grid_row_gap\":\"small\",\"title_grid_width\":\"small\",\"title_style\":\"text-small\"},\"children\":[{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>==VA.Saldo(\\\"2111\\\", \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o saldo acumulado at\u00e9 ao fecho do exerc\u00edcio.\",\"title\":\"VA.Saldo\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.SaldoAteAoMes(\\\"121\\\", 6, \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o saldo acumulado desde a abertura at\u00e9 ao m\u00eas indicado.\",\"title\":\"VA.SaldoAteAoMes\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.SaldoDoMes(\\\"51\\\", \\\"jan\\\", \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o saldo apenas no m\u00eas indicado.\",\"title\":\"VA.SaldoDoMes\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.DebitoNoPeriodo(\\\"62*\\\", 1, 6, \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o total a cr\u00e9dito entre os meses indicados, soma valores mensais ,n\u00e3o corresponde a um acumulado cont\u00ednuo\",\"title\":\"VA.CreditoNoPeriodo\"}}]},{\"type\":\"divider\",\"props\":{\"divider_element\":\"hr\"}},{\"type\":\"headline\",\"props\":{\"content\":\"\n\n<p>Filtros (Credor \/ Devedor)<\/p>\n\n\",\"image_align\":\"left\",\"image_margin\":\"xsmall\",\"title_element\":\"h1\",\"title_style\":\"text-lead\"}},{\"type\":\"description_list\",\"props\":{\"column_breakpoint\":\"m\",\"layout\":\"grid-2\",\"list_element\":\"ul\",\"meta_align\":\"below-content\",\"meta_style\":\"text-meta\",\"show_content\":true,\"show_link\":true,\"show_meta\":true,\"show_title\":true,\"title_element\":\"div\",\"title_grid_column_gap\":\"small\",\"title_grid_row_gap\":\"small\",\"title_grid_width\":\"small\",\"title_style\":\"text-small\"},\"children\":[{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.SaldoSeCredor(\\\"21*\\\", \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o saldo apenas se for credor, retorna valores negativos, caso contr\u00e1rio retorna 0\",\"title\":\"VA.SaldoSeCredor\"}},{\"type\":\"description_list_item\",\"props\":{\"content\":\"\n\n<pre>=VA.SaldoSeDevedor(\\\"221?????\\\", \\\"AnoN\\\")<\/pre>\n\n\",\"meta\":\"Devolve o saldo apenas se for devedor,retorna valores positivos, aso contr\u00e1rio retorna 0\",\"title\":\"VA.SaldoSeDevedor\"}}]},{\"type\":\"text\",\"props\":{\"column_breakpoint\":\"m\",\"content\":\"\n\n<p>Variantes por m\u00eas e per\u00edodo<\/p>\n\n\\n\n\n<pre class=\\\"p1\\\">=VA.SaldoDoMesSeDevedor(<span class=\\\"s1\\\">\\\"21*\\\"<\/span>, <span class=\\\"s1\\\">\\\"jan\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<br \/>=VA.SaldoDoMesSeCredor(<span class=\\\"s1\\\">\\\"21*\\\"<\/span>, <span class=\\\"s1\\\">\\\"jan\\\"<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<br \/>=VA.SaldoAteAoMesSeDevedor(<span class=\\\"s1\\\">\\\"21*\\\"<\/span>, <span class=\\\"s2\\\">6<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<br \/>=VA.SaldoAteAoMesSeCredor(<span class=\\\"s1\\\">\\\"21*\\\"<\/span>, <span class=\\\"s2\\\">6<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<br \/>=VA.SaldoNoPeriodoSeDevedor(<span class=\\\"s1\\\">\\\"21*\\\"<\/span>, <span class=\\\"s2\\\">1<\/span>, <span class=\\\"s2\\\">6<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<br \/>=VA.SaldoNoPeriodoSeCredor(<span class=\\\"s1\\\">\\\"21*\\\"<\/span>, <span class=\\\"s2\\\">1<\/span>, <span class=\\\"s2\\\">6<\/span>, <span class=\\\"s1\\\">\\\"AnoN\\\"<\/span>)<\/pre>\n\n\\n\n\n<ul>\\n\n\n<li class=\\\"p1\\\">Aplicam o mesmo comportamento ao per\u00edodo indicado<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">Primeiro calculam o saldo<\/li>\n\n\\n\n\n<li class=\\\"p1\\\">Depois aplicam o filtro ao resultado<\/li>\n\n\\n<\/ul>\n\n\",\"margin_bottom\":\"default\",\"margin_top\":\"default\"}}]}]}]}],\"version\":\"5.0.28\"} --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>O seu Excel j\u00e1 fala &#8220;contabilistiqu\u00eas&#8221;? An\u00e1lise contabil\u00edstica diretamente no Excel, sem tabelas auxiliares, sem f\u00f3rmulas complexas. O Visual Audit &#8211; Excel Functions \u00e9 um conjunto de fun\u00e7\u00f5es que transforma o Excel numa camada direta de an\u00e1lise sobre dados contabil\u00edsticos.Na pr\u00e1tica, elimina a necessidade de: exportar dados do ERP construir tabelas auxiliares criar pivots complexos [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-215","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/posts\/215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/comments?post=215"}],"version-history":[{"count":1,"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":216,"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/posts\/215\/revisions\/216"}],"wp:attachment":[{"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/media?parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/categories?post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.visualaudit.pt\/index.php\/wp-json\/wp\/v2\/tags?post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}