{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Início","Instruções","Despesas Totais","Markup","Precificação","Cálculo PE","Cálculo PE Específico","Seu próximo passo"],"not_rendered":{"charts":1,"images":14,"defined_names":5,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Início","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[13,5,13,10],[15,1,15,13],[16,1,16,13],[17,1,17,13],[18,1,18,13]]}
{"$rows_empty":10}
[{"$nulls":3},"Dúvidas sobre a ferramenta?"]
[{"$nulls":3},"Assista o vídeo tutorial clicando aqui"]
[]
[{"$nulls":5},"Clique nos botões acima para verificar a planilha"]
[]
[null,"Versão Especial da Planilha de Precificação da 4blue disponibilizada GRATUITAMENTE."]
[null,"Proibido qualquer tipo compartilhamento fora da sua empresa; Proibida a venda; Proibido o uso em serviços (consultorias, acessorias, etc.)"]
[null,"Visto que esta versão foi especialmente disponibilizada gratuitamente, não conseguiremos dar suporte ou tirar dúvidas específicas. "]
[null,"Assista o vídeo tutorial para garantir o uso correto."]

{"sheet":"Instruções","index":1,"n_rows":167,"n_cols":15,"rows_kept":167,"merged":[[2,14,2,18]]}
[]
[null,"5 passos ESSENCIAIS para utilizar a ferramenta de Precificação para Produtos"]
[null,"Este mini manual é muito simples e visual, perca 5 minutos aqui e ganhe anos de vida da sua empresa =)",{"$nulls":12},"Assista ao vídeo tutorial clicando aqui"]
{"$rows_empty":8}
[{"$nulls":8},"Você pode preencher suas contas e valores de acordo "]
[{"$nulls":8},"com a necessidade da sua empresa."]
[]
[{"$nulls":8},"Ao lado um exemplo de uma empresa "]
[{"$nulls":8},"qualquer: foi utilizado outras nomenclaturas "]
[{"$nulls":8},"para as contas destacadas, também pode-se"]
[{"$nulls":8},"adicionar contas nos espaços vazios. "]
[{"$nulls":8},"Logo depois foram adicionados os valores"]
[{"$nulls":8},"das despesas de cada conta"]
[]
[{"$nulls":8},"A mesma situação acontece para os os outros"]
[{"$nulls":8},"tipos de despesas e também na parte dos "]
[{"$nulls":8},"Investimentos!"]
[]
[]
[{"$nulls":8},"ATENÇÃO: NUNCA exclua ou insira linhas,"]
[{"$nulls":8},"senão algumas fórmulas serão perdidas"]
{"$rows_empty":13}
[{"$nulls":4},"A primeira coisa a ser preenchida é o Faturamento Previsto.  A partir deste"]
[{"$nulls":4},"faturamento previsto será calculado o % da despesa fixa (entenda melhor em"]
[{"$nulls":4},"nosso e-book de precificação para produtos). "]
[{"$nulls":4},"Este faturamento indica um faturamento ideal da sua empresa. Não pode nem "]
[{"$nulls":4},"ser um valor alto demais, que a empresa nunca alcance (faz o preço final fica"]
[{"$nulls":4},"menor), mas nem um valor muito baixo (faz o preço final ficar maior)."]
[]
[]
[]
[{"$nulls":8},"Para as linhas premium, gold e prata"]
[{"$nulls":8},"deve-se preencher os percentuais que incidem "]
[{"$nulls":8},"sobre as vendas."]
[{"$nulls":8},"No exemplo ao lado inserimos novos valores."]
[]
[{"$nulls":8},"Já o lucro desejado e o investimento são valores"]
[{"$nulls":8},"percentuais que se deseja obter, ou seja, quero"]
[{"$nulls":8},"ter 22% de lucro líquido e quero reinvestir na "]
[{"$nulls":8},"empresa 10% do meu faturamento."]
[]
[{"$nulls":8},"Atenção! Não é só porque você colocou no lucro"]
[{"$nulls":8},"líquido desejado um valor que ele vai efetivamente"]
[{"$nulls":8},"acontecer. Para tal seria necessário que você vendesse"]
[{"$nulls":8},"sua capacidade máxima produtiva pelo preço ideal."]
{"$rows_empty":10}
[null,null,"Abaixo uma explicação sobre cada um dos campos a serem preenchidos:"]
{"$rows_empty":17}
[null,null,"Todas as células pintadas são protegidas, pois estão com cálculos automáticos."]
{"$rows_empty":35}
[null,"PONTO DE EQUILÍBRIO"]
{"$rows_empty":7}
[{"$nulls":10},"O cálculo é todo automático."]
[{"$nulls":10},"A planilha traz a Despesa Fixa Total cadastrada"]
[]
[{"$nulls":10},"e o percentual médio da margem de contribuição."]
[]
[{"$nulls":10},"O cálculo do PE faz-se dividindo a Despesa Fixa"]
[{"$nulls":10},"pelo % da margem de contribuição."]
[{"$nulls":10},"Neste exemplo, a empresa tem que faturar mais de 27 mil"]
[{"$nulls":10},"para pagar os quase 18 mil de despesas fixas."]
{"$rows_empty":11}
[null,"Primeiro você preenche quais são suas contas ou "]
[null,"investimentos e os valores:"]
{"$rows_empty":7}
[null,"Para depois verificar o quanto precisa faturar a mais"]
[null,"para alcançar o ponto de equilíbrio"]

{"sheet":"Despesas Totais","index":2,"n_rows":86,"n_cols":6,"rows_kept":86,"merged":[[4,1,4,2],[60,1,60,2]]}
[]
[null,"Despesas Totais Mensais"]
[]
[{"$nulls":4},"Total Despesas e Investimentos (mês)",{"$f":"SUM(F6,F7)","v":{"v":55000,"d":"R$ 55,000.00"}}]
[null,"Despesas Fixas (mês)"]
[null,"Despesas Financeiras",{"$f":"SUM(C7:C12)","v":{"v":55000,"d":"R$ 55,000.00"}},null,"Despesa Fixa Total (mês)",{"$f":"SUM(C6,C13,C28,C39,C45,C52)","v":{"v":55000,"d":"R$ 55,000.00"}}]
[null,"Tarifas Bancárias",null,null,"Investimento Fixo Total (mês)",{"$f":"SUM(C62,C69,C75,C81)","v":0}]
[null,"Aluguel e tarifas Operadora Cartão",{"v":55000,"d":"R$ 55,000.00"}]
[null,"DOC/TED"]
[null,"Outros custos com despesas financeiras"]
[null,"balbalbal"]
[]
[null,"Despesas Administrativas",{"$f":"SUM(C14:C27)","v":0}]
[null,"Telefone e Internet"]
[null,"Celular"]
[null,"Energia Elétrica"]
[null,"Aluguel e Condomínio"]
[null,"Água"]
[null,"IPTU"]
[null,"VTs / Gasolina / Estacionamento / Táxi"]
[null,"Almoço / Supermercado / Lanches"]
[null,"Correios"]
[null,"Cartórios"]
[null,"Outras despesas administrativas"]
[]
[]
[]
[null,"Despesas com Pessoal",{"$f":"SUM(C29:C38)","v":0}]
[null,"Salário de Funcionários"]
[null,"Bolsa de Estágio"]
[null,"VT e VR"]
[null,"Rescisão"]
[null,"FGTS/INSS"]
[null,"INSS - Federação - Sindicato"]
[null,"Pro-Labores"]
[null,"Plano de Saúde"]
[null,"Outras despesas com pessoal"]
[]
[null,"Despesas com Serviços de Terceiros",{"$f":"SUM(C40:C44)","v":0}]
[null,"Contador"]
[null,"TI"]
[null,"Advogado"]
[null,"Outras despesas com serviços de terceiros"]
[]
[null,"Despesas com Materiais e Equipamentos",{"$f":"SUM(C46:C51)","v":0}]
[null,"Manutenção Equipamentos Informática"]
[null,"Softwares"]
[null,"Materiais de Expediente/Manutenção/Limpeza"]
[null,"Manutenção Veículo"]
[null,"Outras despesas com materiais"]
[]
[null,null,{"$f":"SUM(C53:C59)","v":0}]
{"$rows_empty":8}
[null,"Investimentos Fixos (mês)"]
[null,"Investimentos em Marketing",{"$f":"SUM(C63:C68)","v":0}]
[null,"Papelaria",0]
[null,"Site / internet",0]
[null,"Mídias/ Propaganda"]
[null,"Eventos"]
[null,"Outros investimentos em marketing",0]
[]
[null,"Investimentos em Bens Materiais",{"$f":"SUM(C70:C74)","v":0}]
[null,"Compra de Equipamentos de Informárica",0]
[null,"Reformas / Estrutura"]
[null,"Mobiliário",0]
[null,"Outros investimentos em bens materiais",0]
[null,null,0]
[null,"Investimentos em Gestão Empresarial",{"$f":"SUM(C76:C80)","v":0}]
[null,"Consultoria",0]
[null,"Treinamentos"]
[null,"Outros investimentos desenv. empresarial"]
[]
[]
[null,"Outros investimentos ",{"$f":"SUM(C82:C86)","v":0}]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]
[null,null,0]

{"sheet":"Markup","index":3,"n_rows":20,"n_cols":27,"rows_kept":20,"merged":[[1,2,1,3],[1,22,1,28],[6,22,7,28],[7,1,7,2],[7,4,7,5],[7,7,7,8],[19,22,19,25]]}
[]
[null,"Faturamento Previsto",{"v":195000,"d":"R$ 195,000.00"},{"$nulls":19},"CAPACIDADE PRODUTIVA"]
[]
[]
[]
[]
[{"$nulls":22},"Nesta parte você vai calcular sua capacidade produtiva máxima. Atenção: horas produtivas são diferentes de horas de trabalho. O objetivo aqui é identificar quantas horas você consegue, efetivamente vender!"]
[null,"Linha Premium",null,null,"Linha Gold",null,null,"Linha Prata"]
[null,{"$f":"IF(B8=\"\",\"\",B8)","v":"Linha Premium"},null,null,{"$f":"IF(E8=\"\",\"\",E8)","v":"Linha Gold"},null,null,{"$f":"IF(H8=\"\",\"\",H8)","v":"Linha Prata"}]
[null,"Impostos sobre faturamento",{"v":0.065,"d":"6.5%"},null,"Impostos sobre faturamento",{"$f":"C10","v":{"v":0.065,"d":"6.5%"}},null,"Impostos sobre faturamento",{"$f":"F10","v":{"v":0.065,"d":"6.5%"}},{"$nulls":13},"Número de pessoas produtivas",2]
[null,"Comissões de venda",{"v":0.02,"d":"2.0%"},null,"Comissões de venda",{"$f":"C11","v":{"v":0.02,"d":"2.0%"}},null,"Comissões de venda",{"$f":"F11","v":{"v":0.02,"d":"2.0%"}},{"$nulls":13},"Horas diárias máximas produtivas (média por pessoa)",6,{"$f":"IF(X11>=8,\"Hey! Você acha que as pessoas realmente conseguem PRODUZIR mais que 8h por dia, consegue?!\",\"\")","v":""}]
[null,"% de cartão crédito / débito",{"v":0.01,"d":"1.0%"},null,"% de cartão crédito / débito",{"v":0.01,"d":"1.0%"},null,"% de cartão crédito / débito",{"v":0.01,"d":"1.0%"},{"$nulls":13},"Dias trabalhados no mês (média por pessoa)",20]
[null,"% das Despesas Fixas x Faturamento",{"$f":"'Despesas Totais'!$F$4/Markup!$C$2","v":{"v":0.28205128205128205,"d":"28.2%"}},null,"% das Despesas Fixas x Faturamento",{"$f":"'Despesas Totais'!$F$4/Markup!$C$2","v":{"v":0.28205128205128205,"d":"28.2%"}},null,"% das Despesas Fixas x Faturamento",{"$f":"'Despesas Totais'!$F$4/Markup!$C$2","v":{"v":0.28205128205128205,"d":"28.2%"}},{"$nulls":13},"HORAS PRODUTIVAS MÁXIMAS NO MÊS",{"$f":"X10*X11*X12","v":240}]
[null,"Outro % sobre venda",{"v":0.01,"d":"1.0%"},null,"Outro % sobre venda",null,null,"Outro % sobre venda"]
[{"$nulls":22},"% de produtividade",{"v":0.7,"d":"70%"},{"$f":"IF(X15<60%,\"Hey! Você não está sendo improdutivo demais não? Se você diminuir demais sua produtividade, o seu preço final vai aumentar!\",IF(X15>=95%,\"Hey! Como pode uma empresa ser tão produtiva assim? Você não está exagerando não?!\",\"\"))","v":""}]
[null,"% Lucro Líquido desejado",{"v":0.2,"d":"20.0%"},null,"% Lucro Líquido desejado",{"v":0.1,"d":"10.0%"},null,"% Lucro Líquido desejado",{"v":0.15,"d":"15.0%"}]
[{"$nulls":22},"Horas reais de produtividade mensal por pessoa",{"$f":"X11*X12*X15","v":84}]
[null,"Taxa de Marcação",{"$f":"100%/(100%-SUM(C10:C16))","v":{"v":2.4216081962123566,"d":"2.422"}},null,"Taxa de Marcação",{"$f":"100%/(100%-SUM(F10:F16))","v":{"v":1.912233390536896,"d":"1.912"}},null,"Taxa de Marcação",{"$f":"100%/(100%-SUM(I10:I16))","v":{"v":2.114394144754676,"d":"2.114"}}]
[]
[{"$nulls":22},"Horas reais de produtividade mensal total:",{"$nulls":3},{"$f":"X13*X15","v":168}]

{"sheet":"Precificação","index":4,"n_rows":502,"n_cols":29,"rows_kept":502}
[{"$nulls":16},"Média ponderada",null,{"$f":"Markup!C2","v":{"v":195000,"d":"195,000.00"}}]
[{"$nulls":16},{"$f":"SUMPRODUCT(Q4:Q500,T4:T500)/SUM(T4:T500)","v":{"v":0.5061111111111111,"d":"50.6%"}},null,{"$f":"IF(SUM(S4:S500)<S1,\"Faltam dados de faturamento, a soma está menor que o faturamento previsto (aba Markup)\",IF(SUM(S4:S500)>S1,\"Tem muito faturamento aí, mais faturamento do que o previsto (aba Markup)\",\"\"))","v":"Faltam dados de faturamento, a soma está menor que o faturamento previsto (aba Markup)"}]
["Status do Preço","Cód. Produto","Produto","Custo variável (do produto)","Outros variáveis envolvidos","Linha do Produto","Taxa Marcação Praticada","Custo Variável Unitários","Preço Sugerido do Produto",null,"Preço Praticado ","Diferença","%",null,null,"Margem de Contribuição","% Margem de Contribuição",null,"Faturamento por mês deste produto","% de faturamento deste item",{"$nulls":3},"Linha do produto","Taxa de Marcação"]
[{"$f":"IF(L4=\"Falta Dados\",\"\",IF(L4=\"\",\"\",IF(L4<0,\"Abaixo do ideal\",\"Preço bom\")))","v":"Preço bom"},null,"EXEMPLO",{"v":7,"d":"7.00"},null,"Linha Prata",{"$f":"IF(F4=$X$4,$Y$4,IF(F4=$X$5,$Y$5,IF(F4=$X$6,$Y$6,\"\")))","v":2.1149999999999998},{"$f":"IF(SUM(D4:E4)=0,\"\",SUM(D4:E4))","v":{"v":7,"d":"7.00"}},{"$f":"IF(OR(H4=\"\",G4=\"\"),\"\",H4*G4)","v":{"v":14.804999999999998,"d":"14.81"}},null,{"v":21,"d":"21.00"},{"$f":"IF(AND(K4>0,I4=\"\"),\"Falta Dados\",IF(K4=\"\",\"\",K4-I4))","v":{"v":6.195000000000002,"d":"6.20"}},{"$f":"IF(K4=\"\",\"\",L4/K4)","v":{"v":0.2950000000000001,"d":"29.5%"}},null,null,{"$f":"IF(I4=\"\",\"\",(K4-H4-O4-(K4*SUM($AC$4:$AC$7))))","v":{"v":11.795,"d":"11.80"}},{"$f":"IF(P4=\"\",\"\",(P4/K4))","v":{"v":0.5616666666666666,"d":"56.2%"}},null,{"v":100,"d":"100.00"},{"$f":"IF(S4=\"\",\"\",S4/SUM($S$4:$S$500))","v":{"v":0.5,"d":"50.0%"}},{"$nulls":3},{"$f":"IF(Markup!B9=\"\",\"\",Markup!B9)","v":"Linha Premium"},{"$f":"IF(X4=\"\",\"\",ROUNDUP(Markup!C18,3))","v":{"v":2.4219999999999997,"d":"2.422"}},null,null,"Impostos sobre faturamento",{"$f":"IF(Markup!C10=\"\",\"\",Markup!C10)","v":{"v":0.065,"d":"6.5%"}}]
["Abaixo do ideal",null,"EXEMPLO",{"v":4,"d":"4.00"},null,"Linha Premium",2.4219999999999997,{"$f":"IF(SUM(D5:E5)=0,\"\",SUM(D5:E5))","v":{"v":4,"d":"4.00"}},{"v":9.687999999999999,"d":"9.69"},null,{"v":9,"d":"9.00"},{"v":-0.6879999999999988,"d":"-0.69"},{"$f":"IF(K5=\"\",\"\",L5/K5)","v":{"v":-0.07644444444444431,"d":"-7.6%"}},null,null,{"v":4.055,"d":"4.06"},{"$f":"IF(P5=\"\",\"\",(P5/K5))","v":{"v":0.45055555555555554,"d":"45.1%"}},null,{"v":100,"d":"100.00"},{"$f":"IF(S5=\"\",\"\",S5/SUM($S$4:$S$500))","v":{"v":0.5,"d":"50.0%"}},{"$nulls":3},{"$f":"IF(Markup!E9=\"\",\"\",Markup!E9)","v":"Linha Gold"},{"$f":"IF(X5=\"\",\"\",ROUNDUP(Markup!F18,3))","v":{"v":1.9129999999999998,"d":"1.913"}},null,null,"Comissões de venda",{"$f":"IF(Markup!C11=\"\",\"\",Markup!C11)","v":{"v":0.02,"d":"2.0%"}}]
["",{"$nulls":5},"",{"$f":"IF(SUM(D6:E6)=0,\"\",SUM(D6:E6))","v":""},"",null,null,"",{"$f":"IF(K6=\"\",\"\",L6/K6)","v":""},null,null,"","",null,null,"",{"$nulls":3},{"$f":"IF(Markup!H9=\"\",\"\",Markup!H9)","v":"Linha Prata"},{"$f":"IF(X6=\"\",\"\",ROUNDUP(Markup!I18,3))","v":{"v":2.1149999999999998,"d":"2.115"}},null,null,"% de cartão crédito / débito",{"$f":"IF(Markup!C12=\"\",\"\",Markup!C12)","v":{"v":0.01,"d":"1.0%"}}]
[{"$f":"IF(L7=\"Falta Dados\",\"\",IF(L7=\"\",\"\",IF(L7<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"",{"$f":"IF(SUM(D7:E7)=0,\"\",SUM(D7:E7))","v":""},"",null,null,{"$f":"IF(AND(K7>0,I7=\"\"),\"Falta Dados\",IF(K7=\"\",\"\",K7-I7))","v":""},{"$f":"IF(L7=\"Falta Dados\",\"\",IF(K7=\"\",\"\",L7/K7))","v":""},null,null,"","",null,null,"",{"$nulls":7},"Outro % sobre venda",{"$f":"IF(Markup!C14=\"\",\"\",Markup!C14)","v":{"v":0.01,"d":"1.0%"}}]
[{"$f":"IF(L8=\"Falta Dados\",\"\",IF(L8=\"\",\"\",IF(L8<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"","","",null,null,{"$f":"IF(AND(K8>0,I8=\"\"),\"Falta Dados\",IF(K8=\"\",\"\",K8-I8))","v":""},{"$f":"IF(K8=\"\",\"\",L8/K8)","v":""},null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},{"$f":"IF(F68=$X$4,$Y$4,IF(F68=$X$5,$Y$5,IF(F68=$X$6,$Y$6,\"\")))","v":""},"",{"$f":"IF(OR(H68=\"\",G68=\"\"),\"\",H68*G68)","v":""},null,null,"","",null,null,{"$f":"IF(I68=\"\",\"\",(K68-H68-O68-(K68*SUM($AC$4:$AC$7))))","v":""},"",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"",{"$f":"IF(P69=\"\",\"\",(P69/K69))","v":""},null,null,{"$f":"IF(S69=\"\",\"\",S69/SUM($S$4:$S$500))","v":""}]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"",{"$f":"IF(SUM(D71:E71)=0,\"\",SUM(D71:E71))","v":""},"",null,null,"",{"$f":"IF(K71=\"\",\"\",L71/K71)","v":""},null,null,"","",null,null,""]
[{"$f":"IF(L72=\"Falta Dados\",\"\",IF(L72=\"\",\"\",IF(L72<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"","","",null,null,{"$f":"IF(AND(K72>0,I72=\"\"),\"Falta Dados\",IF(K72=\"\",\"\",K72-I72))","v":""},"",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},{"$f":"IF(F132=$X$4,$Y$4,IF(F132=$X$5,$Y$5,IF(F132=$X$6,$Y$6,\"\")))","v":""},"",{"$f":"IF(OR(H132=\"\",G132=\"\"),\"\",H132*G132)","v":""},null,null,"","",null,null,{"$f":"IF(I132=\"\",\"\",(K132-H132-O132-(K132*SUM($AC$4:$AC$7))))","v":""},"",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"",{"$f":"IF(P133=\"\",\"\",(P133/K133))","v":""},null,null,{"$f":"IF(S133=\"\",\"\",S133/SUM($S$4:$S$500))","v":""}]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"",{"$f":"IF(SUM(D135:E135)=0,\"\",SUM(D135:E135))","v":""},"",null,null,"",{"$f":"IF(K135=\"\",\"\",L135/K135)","v":""},null,null,"","",null,null,""]
[{"$f":"IF(L136=\"Falta Dados\",\"\",IF(L136=\"\",\"\",IF(L136<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"","","",null,null,{"$f":"IF(AND(K136>0,I136=\"\"),\"Falta Dados\",IF(K136=\"\",\"\",K136-I136))","v":""},"",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},{"$f":"IF(F196=$X$4,$Y$4,IF(F196=$X$5,$Y$5,IF(F196=$X$6,$Y$6,\"\")))","v":""},"",{"$f":"IF(OR(H196=\"\",G196=\"\"),\"\",H196*G196)","v":""},null,null,"","",null,null,{"$f":"IF(I196=\"\",\"\",(K196-H196-O196-(K196*SUM($AC$4:$AC$7))))","v":""},"",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"",{"$f":"IF(P197=\"\",\"\",(P197/K197))","v":""},null,null,{"$f":"IF(S197=\"\",\"\",S197/SUM($S$4:$S$500))","v":""}]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"",{"$f":"IF(SUM(D199:E199)=0,\"\",SUM(D199:E199))","v":""},"",null,null,"",{"$f":"IF(K199=\"\",\"\",L199/K199)","v":""},null,null,"","",null,null,""]
[{"$f":"IF(L200=\"Falta Dados\",\"\",IF(L200=\"\",\"\",IF(L200<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"","","",null,null,{"$f":"IF(AND(K200>0,I200=\"\"),\"Falta Dados\",IF(K200=\"\",\"\",K200-I200))","v":""},"",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},{"$f":"IF(F260=$X$4,$Y$4,IF(F260=$X$5,$Y$5,IF(F260=$X$6,$Y$6,\"\")))","v":""},"",{"$f":"IF(OR(H260=\"\",G260=\"\"),\"\",H260*G260)","v":""},null,null,"","",null,null,{"$f":"IF(I260=\"\",\"\",(K260-H260-O260-(K260*SUM($AC$4:$AC$7))))","v":""},"",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"",{"$f":"IF(P261=\"\",\"\",(P261/K261))","v":""},null,null,{"$f":"IF(S261=\"\",\"\",S261/SUM($S$4:$S$500))","v":""}]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"",{"$f":"IF(SUM(D263:E263)=0,\"\",SUM(D263:E263))","v":""},"",null,null,"",{"$f":"IF(K263=\"\",\"\",L263/K263)","v":""},null,null,"","",null,null,""]
[{"$f":"IF(L264=\"Falta Dados\",\"\",IF(L264=\"\",\"\",IF(L264<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"","","",null,null,{"$f":"IF(AND(K264>0,I264=\"\"),\"Falta Dados\",IF(K264=\"\",\"\",K264-I264))","v":""},"",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},{"$f":"IF(F324=$X$4,$Y$4,IF(F324=$X$5,$Y$5,IF(F324=$X$6,$Y$6,\"\")))","v":""},"",{"$f":"IF(OR(H324=\"\",G324=\"\"),\"\",H324*G324)","v":""},null,null,"","",null,null,{"$f":"IF(I324=\"\",\"\",(K324-H324-O324-(K324*SUM($AC$4:$AC$7))))","v":""},"",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"",{"$f":"IF(P325=\"\",\"\",(P325/K325))","v":""},null,null,{"$f":"IF(S325=\"\",\"\",S325/SUM($S$4:$S$500))","v":""}]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"",{"$f":"IF(SUM(D327:E327)=0,\"\",SUM(D327:E327))","v":""},"",null,null,"",{"$f":"IF(K327=\"\",\"\",L327/K327)","v":""},null,null,"","",null,null,""]
[{"$f":"IF(L328=\"Falta Dados\",\"\",IF(L328=\"\",\"\",IF(L328<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"","","",null,null,{"$f":"IF(AND(K328>0,I328=\"\"),\"Falta Dados\",IF(K328=\"\",\"\",K328-I328))","v":""},"",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},{"$f":"IF(F388=$X$4,$Y$4,IF(F388=$X$5,$Y$5,IF(F388=$X$6,$Y$6,\"\")))","v":""},"",{"$f":"IF(OR(H388=\"\",G388=\"\"),\"\",H388*G388)","v":""},null,null,"","",null,null,{"$f":"IF(I388=\"\",\"\",(K388-H388-O388-(K388*SUM($AC$4:$AC$7))))","v":""},"",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"",{"$f":"IF(P389=\"\",\"\",(P389/K389))","v":""},null,null,{"$f":"IF(S389=\"\",\"\",S389/SUM($S$4:$S$500))","v":""}]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"",{"$f":"IF(SUM(D391:E391)=0,\"\",SUM(D391:E391))","v":""},"",null,null,"",{"$f":"IF(K391=\"\",\"\",L391/K391)","v":""},null,null,"","",null,null,""]
[{"$f":"IF(L392=\"Falta Dados\",\"\",IF(L392=\"\",\"\",IF(L392<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"","","",null,null,{"$f":"IF(AND(K392>0,I392=\"\"),\"Falta Dados\",IF(K392=\"\",\"\",K392-I392))","v":""},"",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},{"$f":"IF(F452=$X$4,$Y$4,IF(F452=$X$5,$Y$5,IF(F452=$X$6,$Y$6,\"\")))","v":""},"",{"$f":"IF(OR(H452=\"\",G452=\"\"),\"\",H452*G452)","v":""},null,null,"","",null,null,{"$f":"IF(I452=\"\",\"\",(K452-H452-O452-(K452*SUM($AC$4:$AC$7))))","v":""},"",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"",{"$f":"IF(P453=\"\",\"\",(P453/K453))","v":""},null,null,{"$f":"IF(S453=\"\",\"\",S453/SUM($S$4:$S$500))","v":""}]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"",{"$f":"IF(SUM(D455:E455)=0,\"\",SUM(D455:E455))","v":""},"",null,null,"",{"$f":"IF(K455=\"\",\"\",L455/K455)","v":""},null,null,"","",null,null,""]
[{"$f":"IF(L456=\"Falta Dados\",\"\",IF(L456=\"\",\"\",IF(L456<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},"","","",null,null,{"$f":"IF(AND(K456>0,I456=\"\"),\"Falta Dados\",IF(K456=\"\",\"\",K456-I456))","v":""},"",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
["",{"$nulls":5},"","","",null,null,"","",null,null,"","",null,null,""]
[{"$f":"IF(L499=\"Falta Dados\",\"\",IF(L499=\"\",\"\",IF(L499<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},{"$f":"IF(F499=$X$4,$Y$4,IF(F499=$X$5,$Y$5,IF(F499=$X$6,$Y$6,\"\")))","v":""},{"$f":"IF(SUM(D499:E499)=0,\"\",SUM(D499:E499))","v":""},{"$f":"IF(OR(H499=\"\",G499=\"\"),\"\",H499*G499)","v":""},null,null,{"$f":"IF(AND(K499>0,I499=\"\"),\"Falta Dados\",IF(K499=\"\",\"\",K499-I499))","v":""},{"$f":"IF(K499=\"\",\"\",L499/K499)","v":""},null,null,{"$f":"IF(I499=\"\",\"\",(K499-H499-O499-(K499*SUM($AC$4:$AC$7))))","v":""},{"$f":"IF(P499=\"\",\"\",(P499/K499))","v":""},null,null,""]
[{"$f":"IF(L500=\"Falta Dados\",\"\",IF(L500=\"\",\"\",IF(L500<0,\"Abaixo do ideal\",\"Preço bom\")))","v":""},{"$nulls":5},{"$f":"IF(F500=$X$4,$Y$4,IF(F500=$X$5,$Y$5,IF(F500=$X$6,$Y$6,\"\")))","v":""},{"$f":"IF(SUM(D500:E500)=0,\"\",SUM(D500:E500))","v":""},{"$f":"IF(OR(H500=\"\",G500=\"\"),\"\",H500*G500)","v":""},null,null,{"$f":"IF(AND(K500>0,I500=\"\"),\"Falta Dados\",IF(K500=\"\",\"\",K500-I500))","v":""},{"$f":"IF(K500=\"\",\"\",L500/K500)","v":""},null,null,{"$f":"IF(I500=\"\",\"\",(K500-H500-O500-(K500*SUM($AC$4:$AC$7))))","v":""},{"$f":"IF(P500=\"\",\"\",(P500/K500))","v":""},null,null,""]
[]
["FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM","FIM",null,"FIM","FIM"]

{"sheet":"Cálculo PE","index":5,"n_rows":21,"n_cols":20,"rows_kept":21}
[]
[{"$nulls":8},"Cálculo Ponto de Equilíbrio"]
[]
[{"$nulls":9},"Consultoria Tipo 01","Consultoria tipo 02","Serviço 3","Serviço 4","Serviço 5","Serviço 6","Serviço 7","Serviço 8","Serviço 9","Serviço 10","Serviço 11"]
[{"$nulls":3},"Despesa Total (mês)",{"$f":"'Despesas Totais'!F4","v":{"v":55000,"d":"R$ 55,000.00"}},{"$nulls":3},"Preço de Venda dos Produtos/Serviços:",{"v":5000,"d":"R$ 5,000.00"},{"v":2000,"d":"R$ 2,000.00"}]
[{"$nulls":8},"Custo com Serviço",0,null,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"Média da Margem de Contribuição",{"$f":"Precificação!Q2","v":{"v":0.5061111111111111,"d":"50.6%"}},{"$nulls":3},"Custo com tercerização",{"v":1000,"d":"R$ 1,000.00"},null,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"Outros custos serviço",0,null,0,0,0,0,0,0,0,0,0]
[{"$nulls":3},"Ponto de Equilíbrio",{"$f":"E5/E7","v":{"v":108671.78924259057,"d":"R$ 108,671.79"}},{"$nulls":3},"Comissão",0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"Impostos ",{"$f":"J5*16%","v":{"v":800,"d":"R$ 800.00"}},{"$f":"K5*16%","v":{"v":320,"d":"R$ 320.00"}},0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"Custo com Transporte ",{"v":120,"d":"R$ 120.00"},{"v":80,"d":"R$ 80.00"},0,0,0,0,0,0,0,0,0]
[{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":8},"Margem de Contribuição Unitária",{"$f":"J5-SUM(J6:J13)","v":{"v":3080,"d":"R$ 3,080.00"}},{"v":1600,"d":"R$ 1,600.00"},0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"Margem de Contribuição (%)",{"$f":"IF(OR(J5=0,J15=0),FALSE,J15/J5)","v":{"v":0.616,"d":"62%"}},{"v":0.8,"d":"80%"},false,false,false,false,false,false,false,false,false]
[]
[{"$nulls":8},"Faturamento Total médio (ou esperado) com Produto/Serviço ao mês",{"v":7000,"d":"R$ 7,000.00"},{"v":3000,"d":"R$ 3,000.00"}]
[]
[{"$nulls":8},"Despesa Total (mês)",{"$f":"'Despesas Totais'!F4","v":{"v":55000,"d":"R$ 55,000.00"}},null,"Média da Margem de Contribuição",{"$f":"IF(OR(SUM(J16:T16)*SUM(J18:T18)=0,SUM(J18:T18)=0),0,SUM(J16:T16*J18:T18)/SUM(J18:T18))","v":{"v":0.6712,"d":"67%"}},null,"Ponto de Equilíbrio",{"$f":"IF(OR(M20=0,J20=0),0,J20/M20)","v":{"v":81942.78903456495,"d":"R$ 81,942.79"}}]
[{"$nulls":14},"PE em Unidades",{"$f":"IF(P20=0,0,P20/(SUM(J5:T5*J18:T18)/SUM(J18:T18)))","v":{"v":19.986046105991452,"d":"20"}}]

{"sheet":"Cálculo PE Específico","index":6,"n_rows":22,"n_cols":7,"rows_kept":22}
[]
[null,"Cálculo PE Específico"]
[]
[null,"Contratar pessoas"]
[]
[null,"Investimento em treinamentos"]
[]
[null,"Exemplo 01",{"v":3000,"d":"R$ 3,000.00"},{"$nulls":3},"Preencha quais são os tipos de Investimentos"]
[{"$nulls":6},"Contratar pessoas"]
[null,"Média da Margem de Contrubuição",{"$f":"'Cálculo PE'!E7","v":{"v":0.5061111111111111,"d":"51%"}},{"$nulls":3},"Aumento de Salário"]
[{"$nulls":6},"Contratar Consultoria"]
[null,{"$f":"B22","v":"Faturamento para alcançar o PE "},{"$f":"IF(OR(SUM($C$4,$C$6,$C$8)=0,$C$10=0),0,SUM($C$4,$C$6,$C$8)/$C$10)","v":{"v":5927.55214050494,"d":"R$ 5,927.55"}},{"$nulls":3},"Investimento em treinamentos"]
[{"$nulls":6},"Exemplo 01"]
[{"$nulls":6},"Exemplo 02"]
[{"$nulls":6},"Exemplo 03"]
[]
[]
[]
[null,{"$f":"B4","v":"Contratar pessoas"},{"$f":"C4","v":0}]
[null,{"$f":"B6","v":"Investimento em treinamentos"},{"$f":"C6","v":0}]
[null,{"$f":"B8","v":"Exemplo 01"},{"$f":"C8","v":3000}]
[null,"Faturamento para alcançar o PE ",{"$f":"C12","v":{"v":5927.55214050494,"d":"R$ 5,927.55"}}]

{"sheet":"Seu próximo passo","index":7,"n_rows":0,"n_cols":0,"rows_kept":0}