{"text_format":"3","workbook":"xls","n_sheets":4,"sheets":["sisdia","P1","P2","P3"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"sisdia","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"P1","index":1,"n_rows":66,"n_cols":18,"rows_kept":66,"merged":[[5,1,8,1],[5,6,7,6],[6,11,9,11],[9,6,11,6],[10,1,17,1],[11,11,16,11],[13,6,21,6],[18,11,35,11],[19,1,27,1],[23,6,26,6],[29,6,32,6],[30,1,33,1],[34,6,37,6],[36,1,41,1],[37,11,44,11],[40,6,47,6],[44,1,47,1],[48,11,54,11],[51,4,53,4],[51,5,51,6],[52,5,52,6],[53,5,53,6],[56,11,63,11],[57,1,63,1],[57,5,57,6],[58,5,58,6],[59,5,59,6],[60,5,60,6],[61,5,61,6],[61,14,61,15],[62,5,62,6],[62,14,62,15],[63,5,63,6],[63,14,63,15]],"flags":["formulas_cached_only"]}
[null,null,"         Volkswagen Caminhões e Ônibus",{"$nulls":4},"DEMONSTRATIVO ECONÔMICO-FINANCEIRO"]
["LN","Concessionária :",{"$nulls":4},"Região :",{"$nulls":3},"   Período :",null,"Demonstração de Resultados Geral","Mês","% VL","Acumulado","% VL","LN"]
[1,"Cidade / UF :",{"$nulls":4},"Faixa :",{"$nulls":3},"  Jan/    à",null,"Vendas Brutas Totais",0,0,0,0,1]
[2,"DN :",{"$nulls":4},"Satélite :",{"$nulls":3}," /        /",null,"Vendas Líquidas Totais",0,0,0,0,2]
[3,"ATIVO",{"$nulls":4},"PASSIVO",{"$nulls":5},"Custos Totais",0,0,0,0,3]
[4,"Disponível","Caixa Geral",null,null,0,"VW/BVW","Veículos Novos",null,null,0,null,"Lucro Bruto Total",0,0,0,0,4]
[5,null,"Bancos Conta Movimento",null,null,0,null,"Veículos Usados",null,null,0,"Variáveis","Comissões e Prêmios",0,0,0,0,5]
[6,null,"Aplicações de Liquidez Imediata",null,null,0,null,"Peças e Acessórios (VW / DSH)",null,null,0,null,"Enc. e Prov. s/ Comissões e Prêmios",0,0,0,0,6]
[7,null,"Contratos em Trânsito",null,null,0,null,"Total Obrigações VW / BVW",null,null,0,null,"Revisão de Entrega de Veículos",0,0,0,0,7]
[8,null,"Total do Disponível",null,null,0,"Bancos","Bancos - Saldos Credores",null,null,0,null,"Cortesia",0,0,0,0,8]
[9,"Realizável CP","Fundo de Capitalização - Caminhões",null,null,0,null,"Empréstimos - CP - Banco VW",null,null,0,null,"Total Despesas Variáveis",0,0,0,0,9]
[10,null,"Conta Corrente - VW",null,null,0,null,"Empréstimos - CP - Outros Bancos",null,null,0,"Salários","Remuneração Dirigentes",0,0,0,0,10]
[11,null,"Valores a Receber - VW",null,null,0,null,"Total Bancos",null,null,0,null,"Salários - Gerência e Supervisão",0,0,0,0,11]
[12,null,"Valores a Receber (vide abertura)",null,null,0,"Provisões","Juros",null,null,0,null,"Salários - Funcionários",0,0,0,0,12]
[13,null,"Adiantamento a Fornecedores",null,null,0,null,"Seguros",null,null,0,null,"Provisões - 13o. Sal. e Férias",0,0,0,0,13]
[14,null,"Despesas Antecipadas",null,null,0,null,"Salários e Comissões",null,null,0,null,"Encargos Sociais",0,0,0,0,14]
[15,null,"Impostos a Recuperar",null,null,0,null,"Encargos Sociais",null,null,0,null,"Benefícios",0,0,0,0,15]
[16,null,"Adiantamento a Funcionários",null,null,0,null,"Provisões Trabalhistas",null,null,0,null,"Total Despesas de Salários",0,0,0,0,16]
[17,null,"Total do Realizável de Curto Prazo",null,null,0,null,"Impostos sobre Vendas",null,null,0,"Semi-Fixas","Manut. e Garantia - Veículos Usados",0,0,0,0,17]
[18,"Estoques","Veículos Novos - Caminhões",null,null,0,null,"Imposto de Renda e Contribuição Social",null,null,0,null,"Veículos em Operação",0,0,0,0,18]
[19,null,"Veículos Novos - Ônibus",null,null,0,null,"Outros Impostos e Taxas",null,null,0,null,"Materiais Diversos / Escritório",0,0,0,0,19]
[20,null,"Veículos Usados - Caminhões",null,null,0,null,"Participações e Dividendos",null,null,0,null,"Propaganda e Promoção de Vendas",0,0,0,0,20]
[21,null,"Veículos Usados - Ônibus",null,null,0,null,"Total Provisões",null,null,0,null,"Donativos e Contribuições",0,0,0,0,21]
[22,null,"Peças & Acessórios - Originais VW",null,null,0,"Outr. Obrig.","Fornecedores - não VW",null,null,0,null,"Tempo Improdutivo",0,0,0,0,22]
[23,null,"Peças & Acessórios - Não Originais",null,null,0,null,"Tít. e Contas a Receber - Saldos Credores",null,null,0,null,"Garantias Recusadas - VW",0,0,0,0,23]
[24,null,"Outras Mercadorias",null,null,0,null,"Recebimentos Antecipados",null,null,0,null,"Garantia de Serviço (retorno)",0,0,0,0,24]
[25,null,"Materiais Diversos / Escritório",null,null,0,null,"Contas a Pagar - Outros",null,null,0,null,"Serviços Profissionais - Terceiros",0,0,0,0,25]
[26,null,"Serviços em Andamento",null,null,0,null,"Total Outras Obrigações",null,null,0,null,"Processamento Dados - Terceiros",0,0,0,0,26]
[27,null,"Total dos Estoques",null,null,0,null,"TOTAL DO PASSIVO CIRCULANTE",null,null,0,null,"Viagens, Represent. e Hospitalidade",0,0,0,0,27]
[28,null,"TOTAL DO ATIVO CIRCULANTE",null,null,0,"Exig. LP","Empréstimos - LP",null,null,0,null,"Publicações, Assinaturas e Assoc.",0,0,0,0,28]
[29,"Real. LP","Contas de Sócios / Coligadas",null,null,0,null,"Impostos Parcelados",null,null,0,null,"Legais e Auditoria",0,0,0,0,29]
[30,null,"Depósitos Judiciais",null,null,0,null,"Provisão Contigênciais Fiscais e Trabalhistas",null,null,0,null,"Multas",0,0,0,0,30]
[31,null,"Participações em Outras Sociedades",null,null,0,null,"Mútuos - Sócios e Coligadas",null,null,0,null,"Despesas de Comunicação",0,0,0,0,31]
[32,null,"Outros Realizáveis de Longo Prazo",null,null,0,null,"TOTAL DO EXIGÍVEL A LONGO PRAZO",null,null,0,null,"Treinamento",0,0,0,0,32]
[33,null,"TOTAL DO REALIZÁVEL A LONGO PRAZO",null,null,0,"Outr. Pass.","Fundo de Capitalização - Contribuição VW",null,null,0,null,"Despesas Bancárias",0,0,0,0,33]
[34,null,"Ativo Imob.","Custo","Depr. Acum.",null,null,"Contrato de Manutenção Próprio",null,null,0,null,"Juros Operacionais",0,0,0,0,34]
[35,"Ativo Imobilizado","Terreno",0,null,0,null,"Passivos Não Operacionais",null,null,0,null,"Total Despesas Semi-Fixas",0,0,0,0,35]
[36,null,"Prédios e Benf.",0,0,0,null,"Outros Passivos",null,null,0,"Fixas","Aluguel",0,0,0,0,36]
[37,null,"Máq. e Equip.",0,0,0,null,"TOTAL OUTROS PASSIVOS",null,null,0,null,"Leasing",0,0,0,0,37]
[38,null,"Móveis e Utens.",0,0,0,null,"PATRIMÔNIO LÍQUIDO",{"$nulls":4},"Amortizações e Depreciações",0,0,0,0,38]
[39,null,"Veíc. Demonst.*",0,0,0,"Patrimônio Líquido","Capital Social",null,null,0,null,"Manutenção",0,0,0,0,39]
[40,null,"Veíc. Empresa**",0,0,0,null,"Capital a Realizar",null,null,0,null,"Água, Luz e Gás",0,0,0,0,40]
[41,null,"TOTAL DO ATIVO IMOBILIZADO",null,null,0,null,"Reservas de Capital",null,null,0,null,"Impostos e Taxas - Imóveis",0,0,0,0,41]
[42,null,"* no. veíc. demon. : ",0,"** no. veíc. empr.. : ",0,null,"Reservas de Reavaliações",null,null,0,null,"Impostos e Taxas Diversos",0,0,0,0,42]
[43,"Outros Ativos","Ativos Diferidos - Valores a Amortizar",null,null,0,null,"Reservas de Lucros",null,null,0,null,"Seguros",0,0,0,0,43]
[44,null,"Amortizações Acumuladas",null,null,0,null,"Lucros ou Prejuízos Acumulados",null,null,0,null,"Total Despesas Fixas",0,0,0,0,44]
[45,null,"Ativos Não Operacionais",null,null,0,null,"Lucro ou Prejuízo do Período",null,null,0,null,"Total Despesas Administrativas",0,0,0,0,45]
[46,null,"Outros Ativos",null,null,0,null,"Lucro ou Prejuízo do Mês",null,null,0,null,"Total Despesas Operacionais",0,0,0,0,46]
[47,null,"TOTAL OUTROS ATIVOS",null,null,0,null,"TOTAL PATRIMÔNIO LÍQUIDO",null,null,0,"Lucro","Lucro ou Prejuízo Operacional",0,0,0,0,47]
[48,null,"TOTAL DO ATIVO",null,null,0,null,"TOTAL PASSIVO + PATRIMÔNIO LÍQUIDO",null,null,0,null,"Outras Receitas (-) Outras Despesas",0,0,0,0,48]
[49,{"$nulls":11},"Lucro ou Prej. Líq. antes Part. e IR",0,0,0,0,49]
[50,{"$nulls":3},"Análise de Capital de Giro Líquido","Cap.Giro Mínimo",null,0,{"$nulls":4},"Participações e Dividendos",0,0,0,0,50]
[51,{"$nulls":4},"Cap.Giro Real",null,0,{"$nulls":4},"Lucro ou Prejuízo Líq. antes IR",0,0,0,0,51]
[52,{"$nulls":4},"Índ. Capitaliz. (%)",null,0,{"$nulls":4},"Imp. de Renda / Contrib. Social",0,0,0,0,52]
[53,{"$nulls":11},"Lucro ou Prej. Líq. após Part. e IR",0,0,0,0,53]
[54,{"$nulls":16},54]
[55,{"$nulls":7},"Vencidos",null,null,"Estoques","Análise de Estoques - Veículos","no. un. total","> 30 d","> 60 d","> 90 d",55]
[56,"Valores a Receber","Análise de Valores a Receber",null,null,"Total",null,"A Vencer","1-30 dias","31-90 dias","mais 90 dias",null,"Caminhões Novos",0,0,0,0,56]
[57,null,"Valores a Receber - Veículos Novos",null,null,0,null,0,0,0,0,null,"Ônibus Novos",0,0,0,0,57]
[58,null,"Valores a Receber - Veículos Usados",null,null,0,null,0,0,0,0,null,"Caminhões Usados",0,0,0,0,58]
[59,null,"Valores a Receber - Peças e Serviços",null,null,0,null,0,0,0,0,null,"Ônibus Usados",0,0,0,0,59]
[60,null,"Valores a Receber - Agregados",null,null,0,null,0,0,0,0,null,"Análise de Estoques - Peças&Acess.","até 180 d","entre 180 e 360 d",null,"> 360 d",60]
[61,null,"Outros Valores a Receber",null,null,0,null,0,0,0,0,null,"Peças & Acessórios - Originais VW",0,0,null,0,61]
[62,null,"Perdas por Recebimentos de Créditos (red.)",null,null,0,null,0,0,0,0,null,"Peças & Acessórios - Não Originais",0,0,null,0,62]
[]
[{"$nulls":8}," = campos Reservados"]

{"sheet":"P2","index":2,"n_rows":66,"n_cols":28,"rows_kept":66,"merged":[[1,0,2,0],[1,1,2,2],[1,27,2,27],[7,1,10,1],[12,1,17,1],[19,1,36,1],[38,1,45,1],[51,3,52,6],[51,11,51,12],[51,13,51,14],[51,15,52,18],[51,23,51,24],[51,25,51,26],[52,11,52,12],[52,13,52,14],[52,23,52,24],[52,25,52,26],[54,1,63,1],[54,25,54,26],[55,3,55,4],[55,7,55,8],[55,11,55,12],[55,15,55,16],[55,19,55,20],[55,23,55,24],[55,25,55,26],[56,3,56,4],[56,7,56,8],[56,11,56,12],[56,15,56,16],[56,19,56,20],[56,23,56,24],[56,25,56,26],[57,3,57,4],[57,7,57,8],[57,11,57,12],[57,15,57,16],[57,19,57,20],[57,23,57,24],[57,25,57,26],[58,3,58,4],[58,7,58,8],[58,11,58,12],[58,15,58,16],[58,19,58,20],[58,23,58,24],[58,25,58,26],[59,3,59,4],[59,7,59,8],[59,11,59,12],[59,15,59,16],[59,19,59,20],[59,23,59,24],[59,25,59,26],[60,3,60,4],[60,7,60,8],[60,11,60,12],[60,15,60,16],[60,19,60,20],[60,23,60,24],[60,25,60,26],[61,3,61,4],[61,7,61,8],[61,11,61,12],[61,15,61,16],[61,19,61,20],[61,23,61,24],[61,25,61,26],[62,3,62,4],[62,7,62,8],[62,11,62,12],[62,15,62,16],[62,19,62,20],[62,23,62,24],[62,25,62,26],[63,3,63,4],[63,7,63,8],[63,11,63,12],[63,15,63,16],[63,19,63,20],[63,23,63,24],[63,25,63,26]],"flags":["formulas_cached_only"]}
[null,null,"LUCRATIVIDADE DEPARTAMENTAL"]
["LN","Dem. de Result. Departamental",null,"Veíc.Novos - Caminhões",{"$nulls":3},"Veíc.Novos - Ônibus",{"$nulls":3},"Veículos Usados",{"$nulls":3},"Assist. Técnica",{"$nulls":3},"Peças & Acessórios",{"$nulls":3},"Administração",{"$nulls":3},"LN"]
[{"$nulls":3},"Mês","%VL","Acum.","%VL","Mês","%VL","Acum.","%VL","Mês","%VL","Acum.","%VL","Mês","%VL","Acum.","%VL","Mês","%VL","Acum.","%VL","Mês","%VL","Acum.","%VL"]
[1,null,"Vendas Brutas Totais",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$nulls":5},1]
[2,null,"Vendas Líquidas Totais",0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,{"$nulls":5},2]
[3,null,"Custos Totais",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":4},3]
[4,null,"Lucro Bruto Total",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":4},4]
[5,"Variáveis","Comissões e Prêmios",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5]
[6,null,"Enc. e Prov. s/ Comissões e Prêmios",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,6]
[7,null,"Revisão de Entrega de Veículos",0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":12},7]
[8,null,"Cortesia",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":4},8]
[9,null,"Total Despesas Variáveis",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9]
[10,"Salários","Remuneração Dirigentes",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10]
[11,null,"Salários - Gerência e Supervisão",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,11]
[12,null,"Salários - Funcionários",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,12]
[13,null,"Provisões - 13o. Sal. e Férias",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,13]
[14,null,"Encargos Sociais - todos",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,14]
[15,null,"Benefícios",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15]
[16,null,"Total Despesas de Salários",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,16]
[17,"Semi-Fixas","Manut. e Garantia - Veículos Usados",{"$nulls":8},0,0,0,0,{"$nulls":12},17]
[18,null,"Veículos em Operação",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,18]
[19,null,"Materiais Diversos / Escritório",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19]
[20,null,"Propaganda e Promoção de Vendas",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,20]
[21,null,"Donativos e Contribuições",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,21]
[22,null,"Tempo Improdutivo",{"$nulls":12},0,0,0,0,{"$nulls":8},22]
[23,null,"Garantias Recusadas - VW",{"$nulls":12},0,0,0,0,0,0,0,0,{"$nulls":4},23]
[24,null,"Garantia de Serviço (retorno)",{"$nulls":12},0,0,0,0,{"$nulls":8},24]
[25,null,"Serviços Profissionais - Terceiros",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,25]
[26,null,"Processamento Dados - Terceiros",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,26]
[27,null,"Viagens, Represent. e Hospitalidade",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,27]
[28,null,"Publicações, Assinaturas e Assoc.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,28]
[29,null,"Legais e Auditoria",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,29]
[30,null,"Multas",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30]
[31,null,"Despesas de Comunicação",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,31]
[32,null,"Treinamento",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,32]
[33,null,"Despesas Bancárias",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,33]
[34,null,"Juros Operacionais",0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":4},0,0,0,0,{"$nulls":4},34]
[35,null,"Total Despesas Semi-Fixas",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,35]
[36,"Fixas","Aluguel",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,36]
[37,null,"Leasing",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,37]
[38,null,"Amortizações e Depreciações",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,38]
[39,null,"Manutenção",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,39]
[40,null,"Água, Luz e Gás",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,40]
[41,null,"Impostos e Taxas - Imóveis",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,41]
[42,null,"Impostos e Taxas Diversos",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,42]
[43,null,"Seguros",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,43]
[44,null,"Total Despesas Fixas",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,44]
[45,null,"Total Despesas Operacionais",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,45]
[46,null,"Lucro ou Prejuízo Operacional",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$nulls":4},46]
[47,{"$nulls":26},47]
[48,{"$nulls":10},"Mês",null,"Acumulado",{"$nulls":9},"Mês",null,"Acumulado",null,48]
[49,null,null,"Outras Receitas",{"$nulls":3},"Receitas Financeiras Líquidas",{"$nulls":3},0,null,0,null,"Outras Despesas",{"$nulls":3},"Despesas Financeiras",{"$nulls":3},0,null,0,null,49]
[50,{"$nulls":6},"Receitas não Operacionais Líq.",{"$nulls":3},0,null,0,{"$nulls":5},"Despesas não Operacionais",{"$nulls":3},0,null,0,null,50]
[51,{"$nulls":26},51]
[52,"Cargos","Quadro de Pessoal",{"$nulls":22},"Total Geral",null,52]
[53,null,"Titular / Dirigente",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,53]
[54,null,"Gerência / Supervisão",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,54]
[55,null,"Vendedor (Veíc., Peças) / Cons. Téc.",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,55]
[56,null,"Produtivos",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,56]
[57,null,"Funcionários",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,57]
[58,null,"Funcionários Terceiros",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,58]
[59,null,"Total",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,59]
[60,null,"Admissões",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,60]
[61,null,"Demissões",0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,{"$nulls":3},0,null,0,null,61]
[]
[{"$nulls":6}," = campos Reservados"]

{"sheet":"P3","index":3,"n_rows":63,"n_cols":28,"rows_kept":63,"merged":[[1,1,1,2],[1,13,1,16],[3,13,8,13],[4,1,10,1],[11,13,15,13],[12,1,18,1],[21,13,21,16],[22,1,26,1],[23,13,32,13],[31,1,37,1],[35,13,41,13],[39,1,45,1],[45,20,45,21],[45,25,45,26],[46,13,54,13],[46,17,46,18],[46,20,46,21],[46,22,46,23],[46,25,46,26],[47,17,47,18],[47,20,47,21],[47,22,47,23],[47,25,47,26],[48,17,48,18],[48,20,48,21],[48,22,48,23],[48,25,48,26],[49,1,53,1],[49,17,49,18],[49,20,49,21],[49,22,49,23],[49,25,49,26],[50,17,50,18],[50,20,50,21],[50,22,50,23],[50,25,50,26],[51,17,51,18],[51,20,51,21],[51,22,51,23],[51,25,51,26],[52,17,52,18],[52,20,52,21],[52,22,52,23],[52,25,52,26],[53,17,53,18],[53,20,53,21],[53,22,53,23],[53,25,53,26],[54,17,54,18],[54,20,54,21],[54,22,54,23],[54,25,54,26],[55,17,55,18],[55,20,55,21],[55,22,55,23],[55,25,55,26],[57,20,57,21],[57,25,57,26],[58,17,58,18],[58,20,58,21],[58,22,58,23],[58,25,58,26],[60,17,60,18],[60,20,60,21],[60,22,60,23],[60,25,60,26]],"flags":["formulas_cached_only"]}
[null,null,"ANÁLISE DAS RECEITAS E DO LUCRO BRUTO"]
["LN","VENDAS",null,"Mês",{"$nulls":4},"Acumulado",{"$nulls":4},"VENDAS - CONT.",{"$nulls":3},"Mês",{"$nulls":4},"Acumulado",{"$nulls":4},"LN"]
[1,null,"Veículos Novos","Un.","V. Líq.","L. Bruto","PUV","% VL","Un.","V. Líq.","L. Bruto","PUV","% VL",null,"Veículos Usados",null,null,"Un.","V. Líq.","L. Bruto","PUV","% VL","Un.","V. Líq.","L. Bruto","PUV","% VL",1]
[2,null,"Caminhões",{"$nulls":10},"Usados","Caminhões Usados",null,null,0,0,0,0,0,0,0,0,0,0,2]
[3,"Caminhões Estoque","3,5 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Recondicionamento",{"$nulls":4},0,0,{"$nulls":3},0,0,null,3]
[4,null,"7 a 9 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Total Caminhões Usados",null,null,0,0,0,0,0,0,0,0,0,0,4]
[5,null,"12 e 13 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Ônibus Usados",null,null,0,0,0,0,0,0,0,0,0,0,5]
[6,null,"14 e 15 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Recondicionamento",{"$nulls":4},0,0,{"$nulls":3},0,0,null,6]
[7,null,"17 a 23 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Total Ônibus Usados",null,null,0,0,0,0,0,0,0,0,0,0,7]
[8,null,"24 a 26 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Total Cam. e Ônibus Usados",null,null,0,0,0,0,0,0,0,0,0,0,8]
[9,null,"45 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Agregados Usados",{"$nulls":12},9]
[10,null,"Total Caminhões - Fat. Estoq.",0,0,0,0,0,0,0,0,0,0,"Agreg. Usados","Financiamento / Leasing",null,null,0,0,0,0,0,0,0,0,0,0,10]
[11,"Caminhões Fat. Direto","3,5 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Seguro",null,null,0,0,0,0,0,0,0,0,0,0,11]
[12,null,"7 a 9 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Consórcio",null,null,0,0,0,0,0,0,0,0,0,0,12]
[13,null,"12 e 13 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Despachantes",null,null,0,0,0,0,0,0,0,0,0,0,13]
[14,null,"14 e 15 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Contratos de Manutenção - VW",null,null,0,0,0,0,0,0,0,0,0,0,14]
[15,null,"17 a 23 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Total Agregados Usados",null,null,0,0,0,0,0,0,0,0,0,0,15]
[16,null,"24 a 26 Ton.",0,0,0,0,0,0,0,0,0,0,null,"Total Geral - Veículos Usados",null,null,0,0,0,0,0,0,0,0,0,0,16]
[17,null,"45 Ton.",0,0,0,0,0,0,0,0,0,0,{"$nulls":14},17]
[18,null,"Total Caminhões - Fat. Direto",0,0,0,0,0,0,0,0,0,0,null,"TOTAL GERAL - VENDAS",null,null,0,0,0,0,0,0,0,0,0,0,18]
[19,null,"Total Caminhões",0,0,0,0,0,0,0,0,0,0,{"$nulls":14},19]
[20,null,"Agregados - Caminhões",{"$nulls":10},"PÓS-VENDAS",{"$nulls":3},"Mês",{"$nulls":4},"Acumulado",{"$nulls":4},20]
[21,"Agregados Cam.","Financiamento / Leasing",0,0,0,0,0,0,0,0,0,0,null,"Serv. Gerais","Custo Md. MO =",0,"PS","V. Líq.","L. Bruto","% VL","OS","PS","V. Líq.","L. Bruto","% VL","OS",21]
[22,null,"Seguro",0,0,0,0,0,0,0,0,0,0,"Serv. Gerais","Clientes","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,22]
[23,null,"Consórcio",0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,null,0,0,0,0,null,0,0,0,0,23]
[24,null,"Despachantes",0,0,0,0,0,0,0,0,0,0,null,"Serv. Rápido","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,24]
[25,null,"Contratos Manutenção - VW",0,0,0,0,0,0,0,0,0,0,null,"Garantia","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,25]
[26,null,"Total Agregados Caminhões",0,0,0,0,0,0,0,0,0,0,null,"Desloc. VW","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,26]
[27,null,"Total Geral Caminhões",0,0,0,0,0,0,0,0,0,0,null,"Revisões","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,27]
[28,{"$nulls":13},"Interna","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,28]
[29,null,"Ônibus",{"$nulls":11},"Sub-Total",{"$nulls":3},0,0,0,0,null,0,0,0,0,29]
[30,"Ônibus Estoque","Mini",0,0,0,0,0,0,0,0,0,0,null,"Serviços de Terceiros",{"$nulls":3},0,0,0,0,null,0,0,0,0,30]
[31,null,"Micro",0,0,0,0,0,0,0,0,0,0,{"$nulls":5},0,0,0,0,null,0,0,0,0,31]
[32,null,"Motor Dianteiro",0,0,0,0,0,0,0,0,0,0,null,"Total Serviços Gerais",null,null,0,0,0,0,0,0,0,0,0,0,32]
[33,null,"Motor Traseiro",0,0,0,0,0,0,0,0,0,0,null,"Fun.&Pint.","Custo Md. MO =",0,"PS","V. Líq.","L. Bruto","% VL","OS","PS","V. Líq.","L. Bruto","% VL","OS",33]
[34,null,"Rodoviário",0,0,0,0,0,0,0,0,0,0,"Fun. & Pintura","Clientes","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,34]
[35,null,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":3},0,null,0,0,0,0,null,0,0,0,0,35]
[36,null,null,0,0,0,0,0,0,0,0,0,0,null,"Garantia","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,36]
[37,null,"Total Ônibus - Fat. Estoq.",0,0,0,0,0,0,0,0,0,0,null,"Interna","Taxa  MO =",0,null,0,0,0,0,null,0,0,0,0,37]
[38,"Ônibus Fat. Direto","Mini",0,0,0,0,0,0,0,0,0,0,null,"Sub-Total",{"$nulls":3},0,0,0,0,null,0,0,0,0,38]
[39,null,"Micro",0,0,0,0,0,0,0,0,0,0,null,"Serviços de Terceiros",{"$nulls":3},0,0,0,0,null,0,0,0,0,39]
[40,null,"Motor Dianteiro",0,0,0,0,0,0,0,0,0,0,{"$nulls":5},0,0,0,0,null,0,0,0,0,40]
[41,null,"Motor Traseiro",0,0,0,0,0,0,0,0,0,0,null,"Total Funilaria & Pintura",null,null,0,0,0,0,0,0,0,0,0,0,41]
[42,null,"Rodoviário",0,0,0,0,0,0,0,0,0,0,null,"Total Geral - Assist. Técnica",null,null,0,0,0,0,0,0,0,0,0,0,42]
[43,null,null,0,0,0,0,0,0,0,0,0,0,{"$nulls":14},43]
[44,null,null,0,0,0,0,0,0,0,0,0,0,null,"Peças e Acessórios",null,null,"V. Líq.",null,"L. Bruto","% VL",null,"V. Líq.",null,"L. Bruto","% VL",null,44]
[45,null,"Total Ônibus - Fat. Direto",0,0,0,0,0,0,0,0,0,0,"Peças & Acessórios","Oficina",null,null,0,null,0,0,null,0,null,0,0,null,45]
[46,null,"Total Ônibus",0,0,0,0,0,0,0,0,0,0,null,"Balcão",null,null,0,null,0,0,null,0,null,0,0,null,46]
[47,null,"Agregados - Ônibus",{"$nulls":11},"Atacado",null,null,0,null,0,0,null,0,null,0,0,null,47]
[48,"Agregados Ônib.","Financiamento / Leasing",0,0,0,0,0,0,0,0,0,0,null,"Garantia",null,null,0,null,0,0,null,0,null,0,0,null,48]
[49,null,"Seguro",0,0,0,0,0,0,0,0,0,0,null,"Acessórios",null,null,0,null,0,0,null,0,null,0,0,null,49]
[50,null,"Consórcio",0,0,0,0,0,0,0,0,0,0,null,"Ajuste de Inventário",null,null,0,null,0,0,null,0,null,0,0,null,50]
[51,null,"Despachantes",0,0,0,0,0,0,0,0,0,0,null,"Total Peças e Acessórios",null,null,0,null,0,0,null,0,null,0,0,null,51]
[52,null,"Contratos Manutenção - VW",0,0,0,0,0,0,0,0,0,0,null,"Outras Mercadorias",null,null,0,null,0,0,null,0,null,0,0,null,52]
[53,null,"Total Agregados Ônibus",0,0,0,0,0,0,0,0,0,0,{"$nulls":4},0,null,0,0,null,0,null,0,0,null,53]
[54,null,"Total Geral Ônibus",0,0,0,0,0,0,0,0,0,0,null,"Total Geral - Peças e Acess.",null,null,0,null,0,0,null,0,null,0,0,null,54]
[55,{"$nulls":26},55]
[56,null,"Total Geral - Cam. e Ônibus",0,0,0,0,0,0,0,0,0,0,null,"Contrato de Manutenção",null,null,"V. Líq.",null,"L. Bruto","% VL",null,"V. Líq.",null,"L. Bruto","% VL",null,56]
[57,{"$nulls":13},"Contr. Manutenção - Próprio",null,null,0,null,0,0,null,0,null,0,0,null,57]
[58,{"$nulls":26},58]
[59,null,"Total Geral - Veículos Novos",0,0,0,0,0,0,0,0,0,0,null,"TOTAL GERAL - PÓS-VENDAS",null,null,0,null,0,0,null,0,null,0,0,null,59]
[]
[{"$nulls":6}," = campos Reservados"]