{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instruções","Dados Prop","CaractSistema","CaractZoot","Instal","Maq Equip e Veic","Mat Escrit","Relatório_Econ","PiqEngord","Lista_Bens","Informações","AlocaçãoCustos","Custos F V","RelatZoot"],"not_rendered":{"charts":1,"images":3,"macros":1,"external_links":0,"defined_names":46,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instruções","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,1,15,19],[16,1,16,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Aluno de pós-graduação: Gustavo Lineu Sartorello"]
[null,"Professor responsável: Dr. Augusto Hauber Gameiro"]

{"sheet":"Dados Prop","index":1,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[26,2,26,4],[28,2,28,4],[38,2,38,4],[6,2,6,4],[8,2,8,4],[22,2,22,4],[16,2,16,4],[18,2,18,4]]}
[]
[]
[]
[]
[null,"DADOS DE IDENTIFICAÇÃO DA PROPRIEDADE"]
[]
[null,"NOME DA PROPRIEDADE:"]
[]
[null,"ENDEREÇO COMPLETO:"]
[]
[null,"BAIRRO:",null,"CEP: "]
[]
[null,"CIDADE/UF:"]
[]
[null,"TELEFONES:"]
[]
[null,"E-MAIL:"]
[]
[null,"NOME DO RESPONSÁVEL"]
[]
[null,"TELEFONE DO RESPONSÁVEL"]
[]
[null,"E-MAIL DO RESPONSÁVEL:"]
[]
[null,"DADOS DE IDENTIFICAÇÃO DO PROPRIETÁRIO"]
[]
[null,"NOME DO PROPRIETÁRIO:"]
[]
[null,"ENDEREÇO COMPLETO:"]
[]
[null,"BAIRRO:",null,"CEP: "]
[]
[null,"COMPLEMENTO"]
[]
[null,"CIDADE/UF:"]
[]
[null,"TELEFONES:"]
[]
[null,"E-MAIL:"]

{"sheet":"CaractSistema","index":2,"n_rows":110,"n_cols":11,"rows_kept":110,"cut":false,"hidden":false,"merged":[[95,2,95,3],[87,2,87,3],[51,2,51,3],[37,2,37,3]]}
[]
[]
[]
[]
[null,null,"Lotação máxima projetada para o período das secas",null,null,"animais"]
[null,null,"Lotação máxima projetada para a estação chuvosa",null,null,"animais"]
[null,null,"Qual é o tempo de duração da estação chuvosa",null,null,"meses"]
[]
[null,null,"Engorda de animais próprios + compras (Pessoa Física)",null,null,"animais"]
[null,null,"Engorda de animais de prestação de serviço (Pessoa Jurídica)",null,null,"animais"]
[]
[null,null,"Área de ocupação da atividade de confinamento",null,null,"hectares"]
[null,null,"Custo de oportunidade da terra",null,null,"ha/ano","?"]
[null,null,"Juros sobre o capital imobilizado ",null,null,"ao ano","?"]
[null,null,"Juros sobre o capital de giro",null,null,"ao ano","?"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Mão de obra fixa"]
[null,null,null,null,null,null,"Valor Mensal"]
[null,null,"Função","Descrição da função","Nº de Funcionários","Meses trabalhados","por funcionário","Salário Anual","Custo Salário/boi","Custo Salário/@","Custo Salário/Diária Boi"]
[null,null,null,null,null,null,null,{"$f":"(F26*G26*E26)+((((F26/12)*G26*E26)+((F26/12)*G26*E26)+((F26/12)*G26*E26*(1/3)))*1.107)","v":0},{"$f":"H26/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I26/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H26/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"(F27*G27*E27)+((((F27/12)*G27*E27)+((F27/12)*G27*E27)+((F27/12)*G27*E27*(1/3)))*1.107)","v":0},{"$f":"H27/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I27/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H27/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"(F28*G28*E28)+((((F28/12)*G28*E28)+((F28/12)*G28*E28)+((F28/12)*G28*E28*(1/3)))*1.107)","v":0},{"$f":"H28/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I28/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H28/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H29/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I29/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H29/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H30/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I30/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H30/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H31/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I31/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H31/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H32/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I32/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H32/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H33/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I33/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H33/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H34/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I34/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H34/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H35/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I35/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H35/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H36/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I36/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H36/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H37/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I37/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H37/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C23&\" - Total\"","v":"Mão de obra fixa - Total"},null,{"$f":"SUM(E26:E37)","v":0},null,null,{"$f":"SUM(H26:H37)","v":0},{"$f":"SUM(I26:I37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J26:J37)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26:K37)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"Contratação de serviços"]
[]
[]
[null,null,"Mão de obra temporária"]
[]
[null,null,"Função","Descrição da Função","Nº de horas mensais","Meses trabalhados","R$/hora","R$/ano","Custo/boi","Custo/@","Custo/Diária Boi"]
[null,null,null,null,null,null,null,{"$f":"E47*F47*G47","v":0},{"$f":"H47/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I47/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H47/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"E48*F48*G48","v":0},{"$f":"H48/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I48/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H48/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H49/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I49/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H49/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H50/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I50/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H50/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,0,{"$f":"H51/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I51/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"H51/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C44&\" - Total\"","v":"Mão de obra temporária - Total"},null,null,null,null,{"$f":"SUM(H47:H51)","v":0},{"$f":"SUM(I47:I51)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J47:J51)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K47:K51)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Contratação de serviços administrativos"]
[]
[null,null,null,"Descrição do serviço","Período contratado","Valor mensal","Valor anual","Custo/boi","Custo/@","Custo/Diária Boi"]
[11,null,null,null,null,null,{"$f":"E57*F57","v":0},{"$f":"G57/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H57/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G57/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,null,null,null,null,null,{"$f":"E58*F58","v":0},{"$f":"G58/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H58/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G58/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,null,null,null,null,null,0,{"$f":"G59/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H59/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G59/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,null,null,null,null,null,0,{"$f":"G60/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H60/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G60/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,null,null,null,null,null,0,{"$f":"G61/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H61/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G61/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,null,null,null,null,null,0,{"$f":"G62/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H62/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G62/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,null,null,null,null,null,0,{"$f":"G63/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H63/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G63/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C54&\" - Total\"","v":"Contratação de serviços administrativos - Total"},null,null,{"$f":"SUM(F57:F63)","v":0},{"$f":"SUM(G57:G63)","v":0},{"$f":"SUM(H57:H63)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I57:I63)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J57:J63)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"Hora máquina"]
[null,null,null,"Máquina","R$/hora"]
[null,null,null,"Pá/esteira"]
[]
[]
[null,null,"Combustíveis"]
[]
[null,null,"Descrição","Litros mensais","R$/Litro","Meses","R$/ano","Custo/boi","Custo/@","Custo/Diária Boi"]
[null,null,null,null,null,null,{"$f":"D75*E75*F75","v":0},{"$f":"G75/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H75/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G75/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"D76*E76*F76","v":0},{"$f":"G76/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H76/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G76/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,{"$f":"G77/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H77/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G77/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C72&\" - Total\"","v":"Combustíveis - Total"},{"$f":"SUM(D75:D77)","v":0},null,null,{"$f":"SUM(G75:G77)","v":0},{"$f":"SUM(H75:H77)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I75:I77)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J75:J77)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"Energia Elétrica"]
[]
[null,null,"Local","Kw/mês","Meses","R$/Kw","R$/ano","Custo/boi","Custo/@","Custo/Diária Boi"]
[null,null,null,null,null,null,{"$f":"D84*E84*F84","v":0},{"$f":"G84/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H84/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G84/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"D85*E85*F85","v":0},{"$f":"G85/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H85/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G85/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,{"$f":"G86/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H86/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G86/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0,{"$f":"G87/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H87/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G87/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C81&\" - Total\"","v":"Energia Elétrica - Total"},null,null,null,{"$f":"SUM(G84:G87)","v":0},{"$f":"SUM(H84:H87)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I84:I87)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J84:J87)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"Telefonia e serviço de internet"]
[]
[null,null,null,null,"Meses","R$/mês","R$/ano","Custo/boi","Custo/@","Custo/Diária Boi"]
[null,null,null,null,null,null,{"$f":"F94*E94","v":0},{"$f":"G94/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H94/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G94/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,{"$f":"F95*E95","v":0},{"$f":"G95/(RelatZoot!$D$7-(RelatZoot!$D$7*RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H95/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G95/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C91&\" - Total\"","v":"Telefonia e serviço de internet - Total"},null,null,null,{"$f":"SUM(G94:G95)","v":0},{"$f":"SUM(H94:H95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I94:I95)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J94:J95)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"Animais de trabalho"]
[]
[null,null,"Tropa de animais para serviço no confinamento",null,null,"unidades"]
[null,null,"Valor por animal",null,null,"R$/animal"]
[null,null,"Vida útil",null,null,"anos"]
[null,null,"Valor residual após tempo de serviço",null,null,"porcentagem"]
[]
[]
[null,null,"Custo da Construção - conforme Sinduscon SP"]
[]
[null,null,"Instalações convencionais - CUB (GI)",null,null,"R$/m²","?"]
[null,null,"Casa de funcionários e escritório administrativo - CUB (RP1Q)",null,null,"R$/m²","?"]

{"sheet":"CaractZoot","index":3,"n_rows":77,"n_cols":14,"rows_kept":77,"cut":false,"hidden":false,"merged":[[4,4,4,6],[62,10,63,10],[23,2,23,5],[59,11,60,11],[59,10,60,10],[57,2,58,2],[57,10,57,11],[57,6,57,8],[53,5,53,6]]}
[]
[]
[]
[]
[null,null,"Animais de engorda","Raça:"]
[]
[null,null,null,"Categoria",1]
[null,null,null,"Condição sexual",1]
[]
[null,null,"Idade média incial",null,null,"meses"]
[null,null,"Peso vivo inicial médio",null,null,"kg/animal",null,null,null,null,null,"Cálculo Boi Magro - atrelado ao Boi Gordo"]
[null,null,"Peso vivo final médio",null,null,"kg/animal",null,null,null,null,null,null,"Boi Magro peso em @",{"$f":"E11*0.5/15","v":0}]
[null,null,"Rendimento de carcaça",null,null,"%",null,null,null,null,null,null,"Boi Magro (R$/cab)",{"$f":"N12*E19","v":0}]
[null,null,"Dias médios que os animais permanecem em confinamento",null,null,"dias",null,null,null,null,null,null,"Ágio (%)",0.1]
[null,null,"Mortalidade",null,null,"%",null,null,null,null,null,null,"Boi Magro com ágio",{"$f":"(N13*N14)+N13","v":0}]
[null,null,"Período em que ocorre a mortalidade dos animais",null,null,"dias","?",null,null,null,null,null,"R$/@ do Boi Magro",{"$f":"N15/N12","v":{"$error":"#DIV/0!"}}]
[null,null,"Oferta de dieta média, em quilos de matéria seca por dia",null,null,"kgMS/dia"]
[null,null,"Valor de aquisição do animal para engorda",null,null,"R$/animal","Dica"]
[null,null,"Valor recebido por arroba de boi gordo",null,null,"R$/@"]
[null,null,"Valor cobrado pela diária boi - (Pessoa Jurídica)",null,null,"R$/animal ao dia"]
[]
[]
[]
[null,null,{"$f":"C26&\" e \"&C41","v":"Protocolo Sanitário e Protocolo de Identificação"}]
[]
[null,null,"Protocolo Sanitário"]
[]
[null,null,null,"Descrição Produto","R$/dose animal","Custo/boi","Custo/@","Custo/Diária Boi"]
[17,null,null,null,null,{"$f":"E29","v":0},{"$f":"F29/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F29/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F30/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F30/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F31/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F31/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F32/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F32/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F33/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F33/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F34/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F34/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F35/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F35/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F36/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F36/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F37/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F37/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[17,null,null,null,null,0,{"$f":"F38/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F38/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C26&\" \"&TEXT(\"- Total\",\"..\")","v":"Protocolo Sanitário - Total"},null,{"$f":"SUM(E29:E38)","v":0},{"$f":"SUM(F29:F38)","v":0},{"$f":"SUM(G29:G38)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H29:H38)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Protocolo de Identificação"]
[]
[null,null,null,"Descrição Produto","R$/unidade animal","Custo/boi","Custo/@","Custo/Diária Boi"]
[9,null,null,null,null,{"$f":"E44","v":0},{"$f":"F44/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F44/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[9,null,null,null,null,0,{"$f":"F45/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F45/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[9,null,null,null,null,0,{"$f":"F46/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F46/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[9,null,null,null,null,0,{"$f":"F47/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F47/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[9,null,null,null,null,0,{"$f":"F48/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F48/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[6,null,null,null,null,0,{"$f":"F49/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F49/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[7,null,null,null,null,0,{"$f":"F50/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F50/RelatZoot!$D$12","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"C41&\" - Total\"","v":"Protocolo de Identificação - Total"},null,{"$f":"SUM(E44:E50)","v":0},{"$f":"SUM(F44:F50)","v":0},{"$f":"SUM(G44:G50)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H44:H50)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,"Oferta média/cabeça (kgMS)",{"$f":"CaractZoot!E17","v":0},null,"Perdas na alimentação (%)"]
[null,null,"Oferta média/cabeça (kgMN)",{"$f":"H76","v":0}]
[]
[]
[null,null,"Alimentos","Custo","Teor de","Custo","Fornecimento",null,null,"Custo"]
[null,null,null,"R$/t MN","MS, %","R$/t MS","%","KgMN","kgMS","R$/ingred"]
[null,null,null,null,1E-3,{"$f":"D60/E60","v":0},null,{"$f":"(I60/E60)","v":0},{"$f":"($D$54*G60)","v":0},{"$f":"(I60*F60)/1000","v":0}]
[null,null,null,null,1E-3,{"$f":"D61/E61","v":0},null,0,0,0]
[null,null,null,null,1E-3,{"$f":"D62/E62","v":0},null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,{"$f":"D68/E68","v":0},null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,null,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,1E-3,0,null,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(G60:G75)","v":0},{"$f":"SUM(H60:H75)","v":0},{"$f":"SUM(I60:I75)","v":0},{"$f":"SUM(J60:J75)","v":0},"Custo/dia/animal"]
[null,null,null,null,null,null,null,null,null,{"$f":"J76/D54","v":{"$error":"#DIV/0!"}},"Custo Kg/MS"]

{"sheet":"Instal","index":4,"n_rows":91,"n_cols":7,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Instalações - Custos e descrição das construções"]
[]
[null,null,"Piquetes/currais de engorda"]
[]
[null,null,"Deseja informar os custos e demais informações dos piquetes",null,null,null,"?"]
[]
[null,null,"Frequência da limpeza dos currais de engorda - em média",null,null,"vezes por piquete ao ano"]
[]
[null,null,"Sistema de irrigação nos currais de engorda"]
[]
[null,null,"Custo total das instalações",null,null,"R$","Dica"]
[null,null,"Vida útil do sistema",null,null,"anos"]
[null,null,"Valor residual do sistema após o período de depreciação",null,null,"porcentagem"]
[null,null,"Taxa de manutenção do curral",null,null,"porcentagem"]
[]
[]
[]
[null,null,"Curral de Manejo dos Animais"]
[]
[null,null,"Capacidade de processamento de animais curral de manejo",null,null,"animais"]
[]
[null,null,"Deseja informar o valor do curral",null,null,null,"?"]
[]
[null,null,"Vida útil do curral",null,null,"anos"]
[null,null,"Valor residual do curral após o período de depreciação",null,null,"porcentagem"]
[null,null,"Taxa de manutenção do curral",null,null,"porcentagem"]
[]
[]
[]
[null,null,"Fábrica de Ração e anexos"]
[]
[null,null,"Área de construção do Aprisco - boxes de armazenamento + áreas anexas",null,null,"m²"]
[null,null,"Valor do m² construído",null,null,"R$/m²"]
[]
[null,null,"Vida útil da construção",null,null,"anos"]
[null,null,"Valor residual da construção após o período de depreciação",null,null,"porcentagem"]
[null,null,"Taxa de manutenção da construção",null,null,"porcentagem"]
[null,null,"Rateio da construção ( parte pertencente ao confinamento )",null,null,"porcentagem"]
[]
[]
[]
[null,null,"Escritório Administrativo"]
[]
[null,null,"Área de construção do escritório",null,null,"m²"]
[null,null,"Valor do m² construído",null,null,"R$/m²"]
[]
[null,null,"Vida útil da construção",null,null,"anos"]
[null,null,"Valor residual da construção após o período de depreciação",null,null,"porcentagem"]
[null,null,"Taxa de manutenção da construção",null,null,"porcentagem"]
[null,null,"Rateio da construção ( parte pertencente ao confinamento )",null,null,"porcentagem"]
[]
[]
[]
[null,null,"Barracão de Máquinas"]
[]
[null,null,"Área de construção do aprisco",null,null,"m²"]
[null,null,"Valor do m² construído",null,null,"R$/m²"]
[]
[null,null,"Vida útil da construção",null,null,"anos"]
[null,null,"Valor residual da construção após o período de depreciação",null,null,"porcentagem"]
[null,null,"Taxa de manutenção da construção",null,null,"porcentagem"]
[null,null,"Rateio da construção ( parte pertencente ao confinamento )",null,null,"porcentagem"]
[]
[]
[]
[null,null,"Casas para funcionários do confinamento"]
[]
[null,null,"Quantas casas são utilizadas pelos funcionários",null,null,"unidades"]
[null,null,"Área de construção da casa",null,null,"m²"]
[null,null,"Valor do m² construído",null,null,"R$/m²"]
[]
[null,null,"Vida útil da construção",null,null,"anos"]
[null,null,"Valor residual da construção após o período de depreciação",null,null,"porcentagem"]
[null,null,"Taxa de manutenção da construção",null,null,"porcentagem"]
[null,null,"Rateio da construção ( parte pertencente ao confinamento )",null,null,"porcentagem"]
[]
[]
[]
[null,null,"Demais construções:","Área de Vivência e outros (selaria, sanitários, quiosques, ...)"]
[]
[null,null,"Área de construção",null,null,"m²"]
[null,null,"Valor do m² construído",null,null,"R$/m²"]
[]
[null,null,"Vida útil da construção",null,null,"anos"]
[null,null,"Valor residual da construção após o período de depreciação",null,null,"porcentagem"]
[null,null,"Taxa de manutenção da construção",null,null,"porcentagem"]
[null,null,"Rateio da construção ( parte pertencente ao confinamento )",null,null,"porcentagem"]

{"sheet":"Maq Equip e Veic","index":5,"n_rows":58,"n_cols":16,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,null,3,4,5,6,8,9,10,11,12,13,14,15,16]
[null,null,"Unidades","Valor Sugerido","Vida Útil (anos)",{"$f":"Lista_Bens!F2","v":"Valor Residual (%)"},{"$f":"Lista_Bens!H2","v":"Taxa de Manutenção"},{"$f":"Lista_Bens!I2","v":"Manutenção"},{"$f":"Lista_Bens!J2","v":"Depreciação"},{"$f":"Lista_Bens!K2","v":"Manutenção"},{"$f":"Lista_Bens!L2","v":"Depreciação"},{"$f":"Lista_Bens!M2","v":"Manutenção"},{"$f":"Lista_Bens!N2","v":"Depreciação"},{"$f":"Lista_Bens!O2","v":"Manutenção"},{"$f":"Lista_Bens!P2","v":"Depreciação"}]
[null,"Máquinas"]
[1,null,{"$f":"VLOOKUP($A4,MaqEquip_Maq,C$1,0)","v":0},0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"C4*D4","v":0}]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[7,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,{"$f":"VLOOKUP($A14,MaqEquip_Maq,C$1,0)","v":0},0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[null,{"$f":"B3&\" - Total\"","v":"Máquinas - Total"},null,{"$f":"C4*D4+C5*D5+C6*D6+C7*D7+C8*D8+C9*D9+C10*D10+C11*D11+C12*D12+C13*D13+C14*D14+C15*D15+C16*D16+C17*D17+C18*D18+C19*D19+C20*D20+C21*D21+C22*D22+C23*D23","v":0},null,null,null,{"$f":"SUM(H4:H23)","v":0},0,{"$f":"SUM(J4:J23)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K4:K23)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[null,"Equipamentos"]
[1,null,{"$f":"VLOOKUP($A26,MaqEquip_Equip,C$1,0)","v":0},0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"C26*D26","v":0}]
[6,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,{"$f":"VLOOKUP($A36,MaqEquip_Equip,C$1,0)","v":0},0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[14,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[null,null,null,{"$f":"C26*D26+C27*D27+C28*D28+C29*D29+C30*D30+C31*D31+C32*D32+C33*D33+C34*D34+C35*D35+C36*D36+C37*D37+C38*D38+C39*D39+C40*D40+C41*D41+C42*D42+C43*D43+C44*D44+C45*D45","v":0},null,null,null,{"$f":"SUM(H26:H45)","v":0},0,{"$f":"SUM(J26:J45)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K26:K45)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[null,"Veículos"]
[1,null,{"$f":"VLOOKUP($A48,MaqEquip_Veic,C$1,0)","v":0},0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"C48*D48","v":0}]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[null,{"$f":"B47&\" - Total\"","v":"Veículos - Total"},null,{"$f":"C48*D48+C49*D49+C50*D50+C51*D51+C52*D52+C53*D53+C54*D54+C55*D55+C56*D56+C57*D57","v":0},null,null,null,{"$f":"SUM(H48:H57)","v":0},0,{"$f":"SUM(J48:J57)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K48:K57)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(P4:P57)","v":0}]

{"sheet":"Mat Escrit","index":6,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,0,2,1]]}
[null,null,3,4,5,6,8,9,10,11,12,13,14,15,16]
[null,null,"Unidades","Valor Sugerido","Vida Útil (anos)",{"$f":"Lista_Bens!F2","v":"Valor Residual (%)"},{"$f":"Lista_Bens!H2","v":"Taxa de Manutenção"},{"$f":"Lista_Bens!I2","v":"Manutenção"},{"$f":"Lista_Bens!J2","v":"Depreciação"},{"$f":"Lista_Bens!K2","v":"Manutenção"},{"$f":"Lista_Bens!L2","v":"Depreciação"},{"$f":"Lista_Bens!M2","v":"Manutenção"},{"$f":"Lista_Bens!N2","v":"Depreciação"},{"$f":"Lista_Bens!O2","v":"Manutenção"},{"$f":"Lista_Bens!P2","v":"Depreciação"}]
["Material de Escritório"]
[1,null,{"$f":"VLOOKUP($A4,MaqEquip_Mat,C$1,0)","v":0},0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"C4*D4","v":0}]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[1,null,0,0,0.1,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]
[null,null,null,{"$f":"C4*D4+C5*D5+C6*D6+C7*D7+C8*D8+C9*D9+C10*D10+C11*D11+C12*D12+C13*D13+C14*D14+C15*D15+C16*D16+C17*D17+C18*D18","v":0},null,null,null,{"$f":"SUM(H4:H18)","v":0},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0]

{"sheet":"Relatório_Econ","index":7,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,4,1,7],[1,3,2,3]]}
[]
[null,null,null,"Itens do custo",{"$f":"AlocaçãoCustos!H2","v":"CUSTO POR:"}]
[null,null,null,null,{"$f":"AlocaçãoCustos!$I$3","v":"animal"},{"$f":"AlocaçãoCustos!$J$3","v":"arroba"},{"$f":"AlocaçãoCustos!$K$3","v":"diária boi"},"% do CT"]
[null,"A - CUSTOS VARIÁVEIS - CV"]
[null,null,1,"Aquisição de animais",{"$f":"AlocaçãoCustos!I6","v":0},{"$f":"AlocaçãoCustos!J6","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K6","v":"-"},{"$f":"E5/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,2,"Alimentação",{"$f":"AlocaçãoCustos!I7","v":0},{"$f":"AlocaçãoCustos!J7","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K7","v":0},{"$error":"#DIV/0!"}]
[null,null,3,"Manejo sanitário",{"$f":"AlocaçãoCustos!I8","v":0},{"$f":"AlocaçãoCustos!J8","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K8","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,4,"Manejo de identificação",{"$f":"AlocaçãoCustos!I9","v":0},{"$f":"AlocaçãoCustos!J9","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,5,"Outros custos variáveis ",{"$f":"AlocaçãoCustos!I18","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J18","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K18","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,6,{"$f":"'Custos F V'!C62","v":"Impostos Variáveis"},{"$f":"AlocaçãoCustos!I20","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J20","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K20","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,{"$f":"AlocaçãoCustos!B22 &AlocaçãoCustos!C22","v":"SubTotal A - Custos Variáveis (1 a 6)"},null,{"$f":"AlocaçãoCustos!I22","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J22","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K22","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"B - CUSTOS SEMIFIXOS - CSF"]
[null,null,7,{"$f":"CaractSistema!C81","v":"Energia Elétrica"},{"$f":"AlocaçãoCustos!I25","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J25","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K25","v":{"$error":"#DIV/0!"}},{"$f":"E13/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,8,{"$f":"CaractSistema!C91","v":"Telefonia e serviço de internet"},{"$f":"AlocaçãoCustos!I26","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J26","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K26","v":{"$error":"#DIV/0!"}},{"$f":"E14/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,9,{"$f":"CaractSistema!C72","v":"Combustíveis"},{"$f":"AlocaçãoCustos!I27","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J27","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K27","v":{"$error":"#DIV/0!"}},{"$f":"E15/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,10,"Outros custos semifixos",{"$f":"AlocaçãoCustos!I29","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J29+AlocaçãoCustos!J14","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K29+AlocaçãoCustos!K14","v":{"$error":"#DIV/0!"}},{"$f":"E16/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"AlocaçãoCustos!B31 &AlocaçãoCustos!C31","v":"SubTotal B - Custos Semifixos (7 a 10)"},null,{"$f":"AlocaçãoCustos!I31","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J31","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K31","v":{"$error":"#DIV/0!"}},{"$f":"E17/$E$33","v":{"$error":"#DIV/0!"}}]
[null,"C - CUSTOS FIXOS - CF"]
[null,null,11,"Mão de obra ",{"$f":"AlocaçãoCustos!I35","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J35","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K35","v":{"$error":"#DIV/0!"}},{"$f":"E19/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,12,"Depreciações",{"$f":"AlocaçãoCustos!I45","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J45","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K45","v":{"$error":"#DIV/0!"}},{"$f":"E20/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,13,"Manutenção",{"$f":"AlocaçãoCustos!I54","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J54","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K54","v":{"$error":"#DIV/0!"}},{"$f":"E21/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,14,"Outros custos fixos",{"$f":"AlocaçãoCustos!I57","v":0},{"$f":"AlocaçãoCustos!J57","v":0},{"$f":"AlocaçãoCustos!K57","v":0},{"$f":"E22/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"AlocaçãoCustos!B59 &AlocaçãoCustos!C59","v":"SubTotal C - Custos Fixos (11 a 14)"},null,{"$f":"AlocaçãoCustos!I59","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J59","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K59","v":{"$error":"#DIV/0!"}},{"$f":"E23/$E$33","v":{"$error":"#DIV/0!"}}]
[null,"D - CUSTO COM A RENDA DOS FATORES - CO"]
[null,null,15,"Remuneração do capital de giro",{"$f":"AlocaçãoCustos!I68","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J68","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K68","v":{"$error":"#DIV/0!"}},{"$f":"E25/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,16,"Remuneração do capital fixo",{"$f":"AlocaçãoCustos!I70","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J70","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K70","v":{"$error":"#DIV/0!"}},{"$f":"E26/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,17,"Remuneração da terra",{"$f":"AlocaçãoCustos!I72","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J72","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K72","v":{"$error":"#DIV/0!"}},{"$f":"E27/$E$33","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"AlocaçãoCustos!B74 &AlocaçãoCustos!C74","v":"SubTotal D - Renda dos Fatores (15 a 17)"},null,{"$f":"AlocaçãoCustos!I74","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J74","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K74","v":{"$error":"#DIV/0!"}},{"$f":"E28/$E$33","v":{"$error":"#DIV/0!"}}]
[]
[null,"E - CUSTO OPERACIONAL EFETIVO - COE (A + B + 11)",null,null,{"$f":"AlocaçãoCustos!I77","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J77","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K77","v":{"$error":"#DIV/0!"}},{"$f":"E30/$E$33","v":{"$error":"#DIV/0!"}}]
[null,"F - CUSTO OPERACIONAL TOTAL - COT (A + B + C)",null,null,{"$f":"AlocaçãoCustos!I78","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J78","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K78","v":{"$error":"#DIV/0!"}},{"$f":"E31/$E$33","v":{"$error":"#DIV/0!"}}]
[]
[null,"G - CUSTO TOTAL - CT (A + B + C + D)",null,null,{"$f":"AlocaçãoCustos!I80","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J80","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K80","v":{"$error":"#DIV/0!"}}]
[]
[null,"H - CUSTO OPERACIONAL POR DIA - COPd",null,null,null,null,{"$f":"AlocaçãoCustos!K83","v":{"$error":"#DIV/0!"}}]
[]
[null,"RECEITAS",null,null,{"$f":"RelatZoot!D14*RelatZoot!D19","v":0},{"$f":"RelatZoot!D14","v":0},{"$f":"CaractZoot!E20","v":0}]
[]
[null,null,"Lucro ou Prejuízo Econômico - Atividade",null,{"$f":"E37-E33","v":{"$error":"#DIV/0!"}},{"$f":"F37-F33","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,null,"Renda ao Produtor",null,{"$f":"E39+E28","v":{"$error":"#DIV/0!"}},{"$f":"F39+F28","v":{"$error":"#DIV/0!"}},{"$f":"G39+G28","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"AlocaçãoCustos!B87","v":"Perdas econômicas"},null,{"$f":"AlocaçãoCustos!I87","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J87","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"AlocaçãoCustos!B88","v":"Perdas econômicas por diária boi"},null,{"$f":"AlocaçãoCustos!I88","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!J88","v":{"$error":"#DIV/0!"}},{"$f":"AlocaçãoCustos!K88","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"AlocaçãoCustos!J86","v":"Ociosidade do sistema (%)"},null,{"$f":"AlocaçãoCustos!K86","v":{"$error":"#DIV/0!"}}]

{"sheet":"PiqEngord","index":8,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[18,5,18,7]]}
[]
[]
[null,null,"Custo total das instalações por animal",{"$f":"H35/RelatZoot!M7","v":{"$error":"#DIV/0!"}},"R$/animal"]
[]
[null,null,"Espaço por animal no período da estação seca",null,"m²",null,"Piquetes de engorda"]
[null,null,"Espaço de cocho por animal",null,"cm lineares por animal",null,"Número de piquetes",null,{"$f":"CaractSistema!E5/PiqEngord!D7","v":{"$error":"#DIV/0!"}},"unidades"]
[null,null,"Capacidade máxima de animais por curral na estação seca",null,"animais",null,"Largura",null,{"$f":"IF(PiqEngord!D6>0,(PiqEngord!D6*PiqEngord!D7)/100,(33.3334*PiqEngord!D7)/100)","v":0},"m"]
[null,null,"Número de linhas de cocho",null,"linhas",null,"Pronfundidade",null,{"$f":"((PiqEngord!D5*PiqEngord!D7)/I7)","v":{"$error":"#DIV/0!"}},"m"]
[null,null,"Largura útil da pista de trato",null,"metros",null,"Largura sem porteira",null,{"$f":"I7-PiqEngord!D10","v":0},"m"]
[null,null,"Porteira, largura",null,"metros",null,"Área do piquete",null,{"$f":"I7*I8","v":{"$error":"#DIV/0!"}},"m²"]
[null,null,"Distancia entre palanques",null,"metros"]
[null,null,"Quantidade de fios na cerca, sem choque",null,"unidades"]
[null,null,"Quntidade de fios de cordoalha no cocho",null,"unidades"]
[]
[null,null,"Vida útil da instalação",null,"anos"]
[null,null,"Valor residual da instalação após o período de depreciação",null,"porcentagem"]
[null,null,"Taxa de manutenção",null,"porcentagem"]
[]
[null,null,"Descrição","Valor",null,"Total do sistema"]
[null,null,"Mão de obra para montagem do piquete (cerca)",null,"R$/piquete",{"$f":"I6","v":{"$error":"#DIV/0!"}},"unidades",{"$f":"F20*D20","v":{"$error":"#DIV/0!"}}]
[null,null,"Preparo do solo - terraplanagem (Limpeza e compactação)",null,"R$/m²",null,null,{"$f":"(D21*I10*I6)*1.05","v":{"$error":"#DIV/0!"}}]
[null,null,"Pista de trato (corte, aterro, e base de solo brita)",null,"R$/m²",null,null,{"$f":"(D22*D9*I7*I6)*1.05","v":{"$error":"#DIV/0!"}}]
[null,null,"Porteiras - em aço",null,"R$/unidade",{"$f":"I6*1.05","v":{"$error":"#DIV/0!"}},"unidades",{"$f":"D23*F23","v":{"$error":"#DIV/0!"}}]
[null,null,"Palanques comuns (2.20m e 10-12 cm de bitola)",null,"R$/unidade",{"$f":"(((I7/PiqEngord!D11)-2)+(((I8/PiqEngord!D11)-2)+((I9/PiqEngord!D11)-2))*1.05)*I6","v":{"$error":"#DIV/0!"}},"unidades",{"$f":"(F24+((I8/PiqEngord!D11)*PiqEngord!D8))*D24","v":{"$error":"#DIV/0!"}}]
[null,null,"Palanques - Esticadores (3.50 m e 10-12 cm de bitola)",null,"R$/unidade",null,"un/piq",{"$f":"((F25*I6)+(PiqEngord!D8*2))*D25","v":{"$error":"#DIV/0!"}}]
[null,null,"Arame liso galvanizado",null,"R$/metro",{"$f":"((((I8*PiqEngord!D12)+(I9*PiqEngord!D12))*I6)+(I8*PiqEngord!D12*PiqEngord!D8))/1000","v":{"$error":"#DIV/0!"}},"km",{"$f":"F26*1000*D26","v":{"$error":"#DIV/0!"}}]
[null,null,"Arame fio de choque",null,"R$/metro",{"$f":"(((I8+I9)*I6)+(PiqEngord!D8*I8))/1000","v":{"$error":"#DIV/0!"}},"km",{"$f":"F27*1000*D27","v":{"$error":"#DIV/0!"}}]
[null,null,"Cordoalha para curral",null,"R$/metro",{"$f":"(PiqEngord!I7*I6*PiqEngord!D13)/1000","v":{"$error":"#DIV/0!"}},"km",{"$f":"F28*1000*D28","v":{"$error":"#DIV/0!"}}]
[null,null,"Cochos em concreto",null,"R$/metro",{"$f":"I6*I7","v":{"$error":"#DIV/0!"}},"unidades",{"$f":"D29*F29","v":{"$error":"#DIV/0!"}}]
[null,null,"Bebedouros em concreto",null,"R$/unidade",null,"un/piq",{"$f":"D30*F30*I6","v":{"$error":"#DIV/0!"}}]
[null,null,"Concretagem da área de cocho",null,"R$/m²",null,"metros linear",{"$f":"D31*F31*I6*I7","v":{"$error":"#DIV/0!"}}]
[null,null,"Acessórios para abastecimento de água (canalização, bombas, juntas e etc)",null,"R$/animal",null,null,{"$f":"D32*D7*I6","v":{"$error":"#DIV/0!"}}]
[null,null,"Reservatório para fornecimento de água aos bebedouros",null,"R$/unidade",null,"capacidade mil L",{"$f":"D33","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"SUM(H20:H33)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Lista_Bens","index":9,"n_rows":190,"n_cols":16,"rows_kept":190,"cut":false,"hidden":false,"merged":[[102,2,102,6],[114,2,114,6],[0,8,0,9],[0,14,0,15],[0,12,0,13],[0,10,0,11],[3,2,3,6],[67,2,67,6]]}
[null,null,null,null,null,null,null,null,"Unidade",null,"Boi",null,"@",null,"Diária Boi"]
[null,null,"Unidades","Valor Unitário","vida útil    (anos)","Valor Residual (%)","Valor Residual (R$)","Taxa de Manutenção","Manutenção","Depreciação","Manutenção","Depreciação","Manutenção","Depreciação","Manutenção","Depreciação"]
[]
[null,null,"Máquinas"]
[1,null,null,null,0.1,null,{"$f":"D5*F5","v":0},null,{"$f":"D5*H5*C5","v":0},{"$f":"((D5-G5)/E5)*C5","v":0},{"$f":"I5/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J5/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K5/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L5/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I5/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J5/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[2,"Pá carregadeira - Volvo - L60F ",1,350000,6,0.2,70000,0.1,35000,46666.666666666664,{"$f":"I6/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J6/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K6/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L6/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I6/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J6/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[3,"Pá carregadeira - Komatsu - Wa200",null,null,0.1,null,0,null,0,0,{"$f":"I7/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J7/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K7/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L7/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I7/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J7/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[4,"Pá carregadeira - New Holland - W130",1,310000,6,0.2,62000,0.1,31000,41333.333333333336,{"$f":"I8/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J8/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K8/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L8/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I8/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J8/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[5,"Pá carregadeira - New Holland - 12D",1,290000,10,0.2,58000,0.05,14500,23200,{"$f":"I9/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J9/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K9/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L9/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I9/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J9/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[6,"Pá carregadeira - Caterpillar - 924k",1,386400,6,0.2,77280,0.1,38640,51520,{"$f":"I10/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J10/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K10/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L10/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I10/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J10/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[7,null,null,null,0.1,null,{"$f":"D11*F11","v":0},null,{"$f":"D11*H11*C11","v":0},{"$f":"((D11-G11)/E11)*C11","v":0},{"$f":"I11/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J11/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K11/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L11/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I11/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J11/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[8,"Caminhão toco - F14000 ",1,210000,10,0.2,42000,0.1,21000,16800,{"$f":"I12/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J12/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K12/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L12/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I12/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J12/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[9,"Caminhão trucado - Cargo - 2629 (290 cv)",2,315000,10,0.2,63000,0.1,63000,50400,{"$f":"I13/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J13/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K13/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L13/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I13/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J13/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[10,"Caminhão - Cargo - 1119 (bombeiro)",1,0,10,0.2,0,0.1,0,0,{"$f":"I14/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J14/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K14/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L14/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I14/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J14/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,"Caminhão vasculante - F14000 160",1,90000,10,0.2,18000,0.1,9000,7200,{"$f":"I15/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J15/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K15/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L15/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I15/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J15/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[12,"Caminhão bombeiro - 140 cv",1,80000,10,0.2,16000,0.1,8000,6400,{"$f":"I16/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J16/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K16/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L16/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I16/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J16/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[13,"Caminhão - VW - 13190 - 160cv - carroceria para tanque de 8100 L",1,160000,10,0.2,32000,0.1,16000,12800,{"$f":"I17/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J17/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K17/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L17/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I17/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J17/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[14,"Caminhão - VW - 15190 - 190cv",1,175000,10,0.2,35000,0.1,17500,14000,{"$f":"I18/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J18/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K18/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L18/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I18/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J18/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[15,"Caminhão VW - 23230 - 225cv - para distribuir ração",1,200000,10,0.2,40000,0.1,20000,16000,{"$f":"I19/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J19/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K19/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L19/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I19/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J19/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[16,"Caminhão Mercedes - 1419/48 - 9500 kg carga útil - carroceria para tanque de 8100 L",1,160000,10,0.2,32000,0.1,16000,12800,{"$f":"I20/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J20/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K20/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L20/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I20/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J20/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[17,"Caminhão Mercedes - 1719/48 - 12230 kg carga útil",1,175000,10,0.2,35000,0.1,17500,14000,{"$f":"I21/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J21/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K21/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L21/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I21/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J21/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[18,"Caminhão Mercedes - 2426/48 - 17560 kg car útil ",2,220000,10,0.2,44000,0.1,44000,35200,{"$f":"I22/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J22/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K22/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L22/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I22/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J22/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[19,"Caminhão Iveco - HD 90V18 - 9 toneladas e 180 cv",1,108000,10,0.2,21600,0.1,10800,8640,{"$f":"I23/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J23/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K23/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L23/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I23/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J23/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[20,"Caminhão Iveco - HD 130V18 - 13 toneladas e 180 cv",1,135000,10,0.2,27000,0.1,13500,10800,{"$f":"I24/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J24/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K24/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L24/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I24/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J24/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[21,"Caminhão Iveco - Tractor Attack 170E22 - (4x2) 17 toneladas e 220cv",1,170000,10,0.2,34000,0.1,17000,13600,{"$f":"I25/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J25/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K25/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L25/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I25/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J25/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[22,"Caminhão Iveco - Tractor Attack 240E22 - (6x2) 24 toneladas e 220cv",1,185000,10,0.2,37000,0.1,18500,14800,{"$f":"I26/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J26/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K26/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L26/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I26/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J26/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[23,null,null,null,0.1,null,0,null,0,0,{"$f":"I27/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J27/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K27/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L27/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I27/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J27/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[24,null,null,null,0.1,null,0,null,0,0,{"$f":"I28/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J28/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K28/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L28/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I28/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J28/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[25,null,null,null,0.1,null,0,null,0,0,{"$f":"I29/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J29/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K29/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L29/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I29/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J29/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[26,"Distribuidor de ração S22 - Siltomac - para caminhão toco",1,95000,10,0.2,{"$f":"D30*F30","v":19000},0.1,9500,7600,{"$f":"I30/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J30/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K30/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L30/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I30/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J30/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[27,"Distribuidor de ração S25 - Siltomac - para caminhao trucado",2,102000,10,0.2,20400,0.1,20400,16320,{"$f":"I31/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J31/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K31/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L31/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I31/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J31/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[28,"Misturador e Distribuidor de ração - por tração - Siltomac - TS 13.5",1,158000,10,0.2,31600,0.1,15800,12640,{"$f":"I32/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J32/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K32/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L32/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I32/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J32/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[29,"Misturador e Distribuidor de ração - Kuhn - Rio Audi 3120 - 8m³",1,143520,10,0.2,28704,0.1,14352,11481.6,{"$f":"I33/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J33/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K33/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L33/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I33/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J33/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[30,"Misturador e Distribuidor de ração - Kuhn - Rio Audi 3130 - 12m³",1,172640,10,0.2,34528,0.1,17264,13811.2,{"$f":"I34/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J34/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K34/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L34/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I34/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J34/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[31,"Misturador e Distribuidor de ração - Kuhn - Euromix 870 - 8m³",1,222560,10,0.2,44512,0.1,22256,17804.8,{"$f":"I35/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J35/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K35/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L35/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I35/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J35/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[32,"Misturador e Distribuidor de ração - Kuhn Profile 1880 - 18m³",1,397280,10,0.2,79456,0.1,39728,31782.400000000001,{"$f":"I36/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J36/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K36/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L36/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I36/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J36/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[33,"Misturador e Distribuidor de ração - Casale - RX 85T - simples 9.5m³",null,null,0.1,null,null,null,0,0,{"$f":"I37/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J37/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K37/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L37/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I37/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J37/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[34,"Misturador e Distribuidor de ração - Casale - RX 110T - Totalmix - 11.8m³",1,187437,10,0.2,{"$f":"D38*F38","v":37487.4},0.1,18743.7,14994.960000000001,{"$f":"I38/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J38/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K38/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L38/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I38/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J38/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[35,"Misturador e Distribuidor de ração - Casale - RX 150T - 16m³",null,null,0.1,null,null,null,0,0,{"$f":"I39/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J39/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K39/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L39/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I39/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J39/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[36,"Misturador e Distribuidor de ração - Casale - RX 175T - Totalmix - 19m³",1,344457,10,0.2,{"$f":"D40*F40","v":68891.400000000009},0.1,34445.700000000004,27556.559999999998,{"$f":"I40/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J40/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K40/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L40/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I40/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J40/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[37,"Misturador e Distribuidor de ração - Casale - RX 200C - 21.5m³ Mecânica",1,368633,10,0.2,73726.600000000006,0.1,36863.300000000003,29490.640000000003,{"$f":"I41/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J41/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K41/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L41/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I41/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J41/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[38,"Misturador e Distribuidor de ração - Casale - RX 200C - 21.5m³ Hidrostática",1,438244,10,0.2,87648.8,0.1,43824.4,35059.520000000004,{"$f":"I42/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J42/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K42/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L42/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I42/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J42/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[39,null,null,null,0.1,null,null,null,0,0,{"$f":"I43/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J43/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K43/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L43/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I43/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J43/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[40,null,null,null,0.1,null,0,0.1,0,0,{"$f":"I44/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J44/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K44/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L44/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I44/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J44/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[41,null,null,null,0.1,null,0,null,0,0,{"$f":"I45/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J45/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K45/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L45/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I45/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J45/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[42,"Trator Valtra BM 100 - 106 cv",1,141700,10,0.2,{"$f":"D46*F46","v":28340},0.1,14170,11336,{"$f":"I46/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J46/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K46/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L46/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I46/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J46/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[43,"Trator Valtra A750 - 78 cv",1,100000,10,0.2,20000,0.1,10000,8000,{"$f":"I47/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J47/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K47/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L47/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I47/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J47/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[44,"Trator Case iH - Farmall - 130 - 131cv - Cabinado",1,178000,10,0.2,35600,0.1,17800,14240,{"$f":"I48/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J48/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K48/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L48/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I48/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J48/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[45,"Trator Case iH - Farmall - 95 - 104cv - Cabinado",1,135000,10,0.2,27000,0.1,13500,10800,{"$f":"I49/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J49/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K49/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L49/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I49/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J49/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[46,"Trator John Deere - 6110J - 110cv",1,176000,10,0.2,35200,0.1,17600,14080,{"$f":"I50/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J50/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K50/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L50/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I50/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J50/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[47,"Trator John Deere - 5085E - cabinado - 85cv",1,128000,10,0.2,25600,0.1,12800,10240,{"$f":"I51/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J51/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K51/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L51/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I51/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J51/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[48,"Trator John Deere - 5065E - 65cv",1,80000,10,0.2,16000,0.1,8000,6400,{"$f":"I52/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J52/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K52/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L52/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I52/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J52/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[49,"Trator Massey Ferguson - 4275 - 75cv - Traçado e sem redutor e capota",1,106000,10,0.2,21200,0.1,10600,8480,{"$f":"I53/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J53/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K53/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L53/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I53/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J53/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[50,"Trator Massey Ferguson - 250X - 50cv - manutenção de cerca",1,70000,10,0.2,14000,0.1,7000,5600,{"$f":"I54/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J54/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K54/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L54/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I54/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J54/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[51,"Trator New Holland - TL 95E - Cabinado - 105cv ",1,130000,10,0.2,26000,0.1,13000,10400,{"$f":"I55/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J55/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K55/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L55/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I55/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J55/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[52,null,null,null,0.1,null,0,null,0,0,{"$f":"I56/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J56/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K56/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L56/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I56/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J56/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[53,null,null,null,0.1,null,0,null,0,0,{"$f":"I57/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J57/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K57/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L57/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I57/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J57/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[54,"Plaina de Raspagagem - Star Plan 3000",1,32000,10,0.2,6400,0.05,1600,2560,{"$f":"I58/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J58/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K58/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L58/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I58/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J58/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[55,null,null,null,0.1,null,0,null,0,0,{"$f":"I59/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J59/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K59/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L59/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I59/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J59/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[56,null,null,null,0.1,null,0,null,0,0,{"$f":"I60/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J60/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K60/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L60/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I60/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J60/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[57,null,null,null,0.1,null,0,null,0,0,{"$f":"I61/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J61/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K61/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L61/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I61/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J61/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[58,null,null,null,0.1,null,0,null,0,0,{"$f":"I62/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J62/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K62/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L62/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I62/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J62/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[59,null,null,null,0.1,null,0,null,0,0,{"$f":"I63/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J63/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K63/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L63/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I63/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J63/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[60,null,null,null,0.1,null,0,null,0,0,{"$f":"I64/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J64/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K64/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L64/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I64/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J64/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[61,null,null,null,0.1,null,0,null,0,0,{"$f":"I65/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J65/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K65/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L65/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I65/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J65/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[62,null,null,null,0.1,null,0,null,0,0,{"$f":"I66/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J66/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K66/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L66/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I66/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J66/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[63,null,null,null,0.1,null,0,null,0,0,{"$f":"I67/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J67/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K67/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L67/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I67/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J67/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,"Equipamentos"]
[1,null,null,null,0.1,null,{"$f":"D69*F69","v":0},null,{"$f":"D69*H69*C69","v":0},{"$f":"((D69-G69)/E69)*C69","v":0},{"$f":"I69/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J69/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K69/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L69/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I69/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J69/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[2,"Misturador estacionário - Kuhn - REEL Commercial RC 270 - 20 m³ motor 75cv",1,464880,10,0.1,{"$f":"D70*F70","v":46488},0.1,{"$f":"D70*H70*C70","v":46488},{"$f":"((D70-G70)/E70)*C70","v":41839.199999999997},{"$f":"I70/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J70/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K70/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L70/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I70/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J70/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[3,"Misturador estacionário - Siltomac - S 19.5 ",1,360700,10,0.1,null,0.1,36070,36070,{"$f":"I71/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J71/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K71/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L71/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I71/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J71/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[4,"Misturador estacionário - Casale RX 200E 21.5m³",null,null,0.1,null,null,null,0,0,{"$f":"I72/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J72/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K72/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L72/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I72/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J72/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[5,null,null,null,0.1,null,null,null,0,0,{"$f":"I73/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J73/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K73/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L73/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I73/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J73/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[6,null,null,null,0.1,null,{"$f":"D74*F74","v":0},null,0,0,{"$f":"I74/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J74/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K74/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L74/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I74/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J74/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[7,"Esteira - (misturador -> caminhão) - Helo Máquinas - TMHEV 8",1,32000,5,0.2,6400,0.05,1600,5120,{"$f":"I75/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J75/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K75/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L75/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I75/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J75/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[8,"Balança / Digi Star - XR4600",1,16000,5,0.1,null,0.05,800,3200,{"$f":"I76/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J76/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K76/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L76/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I76/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J76/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[9,null,null,null,0.1,null,null,null,0,0,{"$f":"I77/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J77/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K77/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L77/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I77/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J77/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[10,"Moinho de rolo - Mendes & Mendo",1,80000,5,0.2,16000,0.2,16000,12800,{"$f":"I78/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J78/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K78/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L78/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I78/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J78/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,"Reservatórios de melaço For Lev - 4 tanques - 15 mil L (NBR 15.682)",1,24000,5,0.2,4800,0.05,1200,3840,{"$f":"I79/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J79/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K79/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L79/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I79/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J79/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[12,"Transformador 150 kwa",1,25000,5,0,0,0.1,2500,5000,{"$f":"I80/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J80/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K80/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L80/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I80/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J80/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[13,"Gerador - estacionário 150 kWa",1,150000,15,0.2,30000,0.1,15000,8000,{"$f":"I81/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J81/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K81/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L81/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I81/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J81/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[14,null,null,null,0.1,null,0,null,0,0,{"$f":"I82/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J82/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K82/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L82/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I82/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J82/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[15,"Brete - Silencer - hidráulico",1,100000,10,0.2,20000,0.1,10000,8000,{"$f":"I83/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J83/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K83/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L83/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I83/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J83/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[16,"Brete - Backhouser (hidráulico com parede móvel)",1,97000,10,0.2,19400,0.1,9700,7760,{"$f":"I84/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J84/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K84/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L84/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I84/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J84/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[17,"Brete - Kontentor - (Hidráulico com controle)",null,null,0.1,null,0,null,0,0,{"$f":"I85/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J85/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K85/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L85/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I85/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J85/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[18,"Brete - Romancini - (Pneumático)",null,null,0.1,null,null,null,0,0,{"$f":"I86/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J86/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K86/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L86/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I86/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J86/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[19,"Balança do tronco de contenção - Tru-Test XR-5000 + XHD",1,32258,5,0.1,null,0.05,1612.9,6451.6,{"$f":"I87/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J87/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K87/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L87/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I87/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J87/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[20,null,null,null,0.1,null,null,null,0,0,{"$f":"I88/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J88/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K88/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L88/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I88/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J88/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[21,null,null,null,0.1,null,null,null,0,0,{"$f":"I89/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J89/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K89/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L89/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I89/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J89/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[22,"Broca perfuradora de solo",1,2000,5,0,0,0.1,200,400,{"$f":"I90/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J90/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K90/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L90/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I90/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J90/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[23,"Carreta de 4 rodas",1,4000,10,0.2,800,0.1,{"$f":"D91*H91*C91","v":400},{"$f":"((D91-G91)/E91)*C91","v":320},{"$f":"I91/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J91/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K91/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L91/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I91/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J91/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[24,"Balança Rodoviária 25m - 100 toneladas",1,86300,15,0.2,17260,0.1,8630,4602.666666666667,{"$f":"I92/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J92/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K92/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L92/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I92/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J92/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[25,null,null,null,0.1,null,0,null,0,0,{"$f":"I93/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J93/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K93/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L93/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I93/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J93/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[26,"Outras Ferramentas (pá, enchada, furadeira, e demais itens de oficina)",1,15000,5,0,0,0,0,3000,{"$f":"I94/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J94/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K94/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L94/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I94/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J94/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[27,null,null,null,0.1,null,0,null,0,0,{"$f":"I95/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J95/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K95/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L95/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I95/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J95/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[28,"Leitor do sistema de rastreabilidade",1,4608,5,0,0,0.05,230.4,921.6,{"$f":"I96/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J96/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K96/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L96/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I96/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J96/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[29,"Tanque 8.100 L para água potável (bombeiro)",1,8770,10,0.2,1754,null,0,701.6,{"$f":"I97/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J97/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K97/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L97/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I97/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J97/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[30,null,null,null,0.1,null,0,null,0,0,{"$f":"I98/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J98/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K98/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L98/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I98/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J98/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[31,null,null,null,0.1,null,0,null,0,0,{"$f":"I99/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J99/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K99/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L99/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I99/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J99/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[32,null,null,null,0.1,null,0,null,0,0,{"$f":"I100/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J100/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K100/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L100/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I100/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J100/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[33,null,null,null,0.1,null,0,null,0,0,{"$f":"I101/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J101/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K101/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L101/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I101/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J101/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal de Máquinas e Equipamentos",null,{"$f":"SUM(D5:D101)","v":9128387},null,null,{"$f":"SUM(G5:G101)","v":1688076.2000000002},null,{"$f":"SUM(I5:I101)","v":960618.4},864864.34666666656,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Veículos"]
[1,null,null,null,0.1,null,{"$f":"D104*F104","v":0},null,{"$f":"D104*H104*C104","v":0},{"$f":"((D104-G104)/E104)*C104","v":0},{"$f":"I104/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J104/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K104/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L104/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I104/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J104/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[2,"Fiat - Strada",1,35000,5,0.4,14000,0.1,{"$f":"D105*H105*C105","v":3500},{"$f":"((D105-G105)/E105)*C105","v":4200},{"$f":"I105/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J105/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K105/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L105/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I105/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J105/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[3,"Fiat - Pálio",1,36000,5,0.4,14400,0.1,3600,4320,{"$f":"I106/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J106/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K106/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L106/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I106/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J106/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[4,"Fiat - Uno",1,28000,5,0.4,11200,0.1,2800,3360,{"$f":"I107/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J107/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K107/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L107/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I107/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J107/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[5,"VW - Gol ",1,36000,5,0.4,14400,0.1,{"$f":"D108*H108*C108","v":3600},{"$f":"((D108-G108)/E108)*C108","v":4320},{"$f":"I108/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J108/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K108/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L108/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I108/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J108/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[6,"GM - Montana",null,null,0.1,null,0,null,0,0,{"$f":"I109/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J109/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K109/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L109/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I109/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J109/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[7,"Motocicleta - Honda Bros",1,10000,5,0.4,4000,0.1,1000,1200,{"$f":"I110/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J110/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K110/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L110/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I110/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J110/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[8,"Quadriciclo - Honda  - Motor Tracs",null,null,0.1,null,0,null,0,0,{"$f":"I111/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J111/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K111/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L111/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I111/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J111/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[9,null,null,null,0.1,null,0,null,{"$f":"D112*H112*C112","v":0},{"$f":"((D112-G112)/E112)*C112","v":0},{"$f":"I112/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J112/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K112/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L112/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I112/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J112/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[10,null,null,null,0.1,null,0,null,0,0,{"$f":"I113/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J113/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K113/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L113/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I113/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J113/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,"Subtotal de Veículos",null,{"$f":"SUM(D104:D113)","v":145000},null,null,{"$f":"SUM(G104:G113)","v":58000},null,{"$f":"SUM(I104:I113)","v":14500},{"$f":"SUM(J104:J113)","v":17400},{"$f":"SUM(K104:K113)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L104:L113)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"Material de Escritório e Utensílios"]
[]
[1,null,null,null,0.1,null,{"$f":"D117*F117","v":0},null,{"$f":"D117*H117*C117","v":0},{"$f":"((D117-G117)/E117)*C117","v":0},{"$f":"I117/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J117/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K117/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L117/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I117/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J117/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[2,"Computadores",6,2500,5,0,0,0.1,{"$f":"D118*H118*C118","v":1500},{"$f":"((D118-G118)/E118)*C118","v":3000},{"$f":"I118/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J118/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K118/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L118/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I118/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J118/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[3,"Impressoras",1,3500,5,0,0,0.1,350,700,{"$f":"I119/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J119/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K119/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L119/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I119/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J119/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[4,"Climatização",4,2000,5,0,0,0.1,800,1600,{"$f":"I120/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J120/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K120/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L120/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I120/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J120/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[5,null,null,null,0.1,null,0,null,0,0,{"$f":"I121/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J121/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K121/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L121/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I121/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J121/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[6,"Irrigação do jardim do escritório",0.5,50000,10,0,0,0.1,{"$f":"D122*H122*C122","v":2500},{"$f":"((D122-G122)/E122)*C122","v":2500},{"$f":"I122/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J122/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K122/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L122/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I122/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J122/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[7,null,null,null,0.1,null,0,null,0,0,{"$f":"I123/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J123/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K123/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L123/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I123/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J123/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[8,"Sistema de radiocomunicação",1,7490,5,0,0,0.1,749,1498,{"$f":"I124/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J124/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K124/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L124/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I124/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J124/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[9,"Cadeiras",10,200,5,0,0,0.05,100,400,{"$f":"I125/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J125/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K125/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L125/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I125/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J125/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[10,"Mesas",10,500,5,0,0,0.05,250,1000,{"$f":"I126/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J126/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K126/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L126/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I126/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J126/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[11,"Ventiladores",3,200,3,0,0,0,0,200,{"$f":"I127/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J127/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K127/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L127/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I127/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J127/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[12,"Frigobar/Geladeira",1,1250,5,0,0,0.05,62.5,250,{"$f":"I128/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J128/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K128/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L128/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I128/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J128/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[13,null,null,null,0.1,null,0,null,0,0,{"$f":"I129/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J129/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K129/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L129/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I129/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J129/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[14,null,null,null,0.1,null,{"$f":"D130*F130","v":0},null,{"$f":"D130*H130*C130","v":0},{"$f":"((D130-G130)/E130)*C130","v":0},{"$f":"I130/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J130/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K130/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L130/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I130/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J130/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[15,null,null,null,0.1,null,0,null,0,0,{"$f":"I131/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"J131/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K131/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"L131/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I131/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"J131/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I117:I121)","v":2650},5300,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"CaractZoot!C24","v":"Protocolo Sanitário e Protocolo de Identificação"}]
[]
[null,{"$f":"CaractZoot!C26","v":"Protocolo Sanitário"}]
[1,"Clostridioses"]
[2,"Doenças Respiratórias"]
[3,"Botulismo"]
[4,"Carbúnculos"]
[5,"Anti-parasitário"]
[6,"Anti-helmintico"]
[7,"Anti-inflamatório"]
[8,"Endectocida"]
[9,"Outros"]
[10]
[11]
[12,"Suplemento mineral"]
[13,"Suplemento vitamínico"]
[14,"Suplemento min e vitam"]
[15,"Outros"]
[16]
[17]
[1,{"$f":"CaractZoot!C41","v":"Protocolo de Identificação"}]
[2,"Brinco de identificação"]
[3,"Brinco da rastreabilidade"]
[4,"Chip eletrônico"]
[5,"Marcação a ferro"]
[6,"Outros"]
[7]
[8]
[9]
[10]
[]
[null,"Curral"]
[null,"Capacidade de processamento de animais"]
[null,0,399]
[null,400,599]
[null,600,799,600000]
[null,800,999]
[null,1000,2000]
[]
[null,{"$f":"CaractSistema!C54","v":"Contratação de serviços administrativos"}]
[]
[1,"Software de controle financeiro"]
[2,"Software de gestão da dieta"]
[3,"Software de rastreabilidade bovina"]
[4,"Software gestão da dieta e rastreabilidade"]
[5]
[6]
[7,"Consultoria"]
[8,"Honorários contábeis"]
[9,"Auditoria"]
[10]
[11]
[]
[1,"Macho"]
[2,"Fêmea"]
[]
[1,"Não Castrado"]
[2,"Castrado"]

{"sheet":"Informações","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"AlocaçãoCustos","index":11,"n_rows":88,"n_cols":11,"rows_kept":88,"cut":false,"hidden":false,"merged":[[1,7,1,10],[79,1,80,1],[79,7,80,7],[79,8,80,8],[79,9,80,9],[79,10,80,10],[79,2,80,6]]}
[null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-07-21"},{"$f":"NOW()","v":42572.604805787036}]
[null,null,null,null,null,null,null,"CUSTO POR:"]
[null,null,null,null,null,null,null,"atividade","animal","arroba","diária boi"]
[null,"A - Custos Variáveis (1 a 6)"]
[]
[null,null,"1. Aquisição de animais",null,null,null,null,{"$f":"RelatZoot!D5*RelatZoot!D8","v":0},{"$f":"IF(CaractSistema!E9>0,RelatZoot!D8,0)","v":0},{"$f":"I6/RelatZoot!D19","v":{"$error":"#DIV/0!"}},"-"]
[null,null,"2. Alimentação",null,null,null,null,{"$f":"CaractZoot!J76*RelatZoot!H17*(1+CaractZoot!H54)","v":0},{"$f":"RelatZoot!$D$12*CaractZoot!$J$76*(1+CaractZoot!H54)","v":0},{"$f":"I7/RelatZoot!D19","v":{"$error":"#DIV/0!"}},{"$f":"CaractZoot!J76*(1+CaractZoot!H54)","v":0}]
[null,null,{"$f":"\"3. \"&CaractZoot!C39","v":"3. Protocolo Sanitário - Total"},null,null,null,null,{"$f":"CaractZoot!E39*RelatZoot!D7","v":0},{"$f":"CaractZoot!F39","v":0},{"$f":"CaractZoot!G39","v":{"$error":"#DIV/0!"}},{"$f":"CaractZoot!H39","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"\"4. \"&CaractZoot!C51","v":"4. Protocolo de Identificação - Total"},null,null,null,null,{"$f":"CaractZoot!E51*RelatZoot!D7","v":0},{"$f":"CaractZoot!F51","v":0},{"$f":"CaractZoot!G51","v":{"$error":"#DIV/0!"}},{"$f":"CaractZoot!H51","v":{"$error":"#DIV/0!"}}]
[]
[null,"SubTotal ","Custos variáveis (1 a 4)",null,null,null,null,{"$f":"SUM(H6:H9)","v":0},{"$f":"SUM(I6:I9)","v":0},{"$f":"SUM(J6:J9)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,null,"5. Outros custos variáveis"]
[null,null,5.0999999999999996,{"$f":"'Custos F V'!B51","v":"Limpeza e aterramento dos piquetes"},null,null,null,{"$f":"'Custos F V'!G51","v":0},{"$f":"'Custos F V'!H51","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!I51","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!J51","v":{"$error":"#DIV/0!"}}]
[null,null,5.2,{"$f":"'Custos F V'!B56","v":"Transporte de animais mortos"},null,null,null,{"$f":"'Custos F V'!F56","v":0},{"$f":"'Custos F V'!G58","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!H58","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!I58","v":{"$error":"#DIV/0!"}}]
[null,null,5.3,{"$f":"CaractSistema!C52","v":"Mão de obra temporária - Total"},null,null,null,{"$f":"CaractSistema!H52","v":0},{"$f":"CaractSistema!I52","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!J52","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!K52","v":{"$error":"#DIV/0!"}}]
[]
[null,"SubTotal ",{"$f":"C13","v":"5. Outros custos variáveis"},null,null,null,null,{"$f":"SUM(H14:H16)","v":0},{"$f":"SUM(I14:I16)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J14:J16)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[null,null,{"$f":"\"6. \"&'Custos F V'!C62","v":"6. Impostos Variáveis"},null,null,null,null,{"$f":"'Custos F V'!D73","v":0},{"$f":"'Custos F V'!E73","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!F73","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!G73","v":{"$error":"#DIV/0!"}}]
[]
[null,"SubTotal ",{"$f":"B4","v":"A - Custos Variáveis (1 a 6)"},null,null,null,null,{"$f":"SUM(H11+H18+H20)","v":0},{"$f":"SUM(I11+I18+I20)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J11+J18+J20)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K11+K18+K20)","v":{"$error":"#DIV/0!"}}]
[]
[null,"B - Custos Semifixos (7 a 10)"]
[null,null,{"$f":"\"7. \"&CaractSistema!C81","v":"7. Energia Elétrica"},null,null,null,null,{"$f":"CaractSistema!G88","v":0},{"$f":"CaractSistema!H88","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!I88","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!J88","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"\"8. \"&CaractSistema!C91","v":"8. Telefonia e serviço de internet"},null,null,null,null,{"$f":"CaractSistema!G96","v":0},{"$f":"CaractSistema!H96","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!I96","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!J96","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"\"9. \"&CaractSistema!C72","v":"9. Combustíveis"},null,null,null,null,{"$f":"CaractSistema!G78","v":0},{"$f":"CaractSistema!H78","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!I78","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!J78","v":{"$error":"#DIV/0!"}}]
[null,null,"10. Outros custos semifixos"]
[null,null,null,{"$f":"\"10.1 \"&CaractSistema!C54","v":"10.1 Contratação de serviços administrativos"},null,null,null,{"$f":"CaractSistema!G64","v":0},{"$f":"CaractSistema!H64","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!I64","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!J64","v":{"$error":"#DIV/0!"}}]
[]
[null,"SubTotal ",{"$f":"B24","v":"B - Custos Semifixos (7 a 10)"},null,null,null,null,{"$f":"SUM(H25:H29)","v":0},{"$f":"SUM(I25:I29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J25:J29)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K25:K29)","v":{"$error":"#DIV/0!"}}]
[]
[null,"C - Custos Fixos (11 a 14)"]
[]
[null,null,{"$f":"\"11. \"& CaractSistema!C23","v":"11. Mão de obra fixa"},null,null,null,null,{"$f":"CaractSistema!H38","v":0},{"$f":"CaractSistema!I38","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!J38","v":{"$error":"#DIV/0!"}},{"$f":"CaractSistema!K38","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"12. Depreciações"]
[null,null,12.1,{"$f":"\"Subtotal \"&'Maq Equip e Veic'!B3","v":"Subtotal Máquinas"},null,null,null,{"$f":"'Maq Equip e Veic'!I24","v":0},{"$f":"'Maq Equip e Veic'!K24","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!M24","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!O24","v":{"$error":"#DIV/0!"}}]
[null,null,12.2,{"$f":"\"Subtotal \"&'Maq Equip e Veic'!B25","v":"Subtotal Equipamentos"},null,null,null,{"$f":"'Maq Equip e Veic'!I46","v":0},{"$f":"'Maq Equip e Veic'!K46","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!M46","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!O46","v":{"$error":"#DIV/0!"}}]
[null,null,12.3,{"$f":"\"Subtotal \"&'Maq Equip e Veic'!B47","v":"Subtotal Veículos"},null,null,null,{"$f":"'Maq Equip e Veic'!I58","v":0},{"$f":"'Maq Equip e Veic'!K58","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!M58","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!O58","v":{"$error":"#DIV/0!"}}]
[null,null,12.4,"Subtotal Materiais de Escritório",null,null,null,{"$f":"'Mat Escrit'!I19","v":0},{"$f":"'Mat Escrit'!K19","v":{"$error":"#DIV/0!"}},{"$f":"'Mat Escrit'!M19","v":{"$error":"#DIV/0!"}},{"$f":"'Mat Escrit'!O19","v":{"$error":"#DIV/0!"}}]
[null,null,12.5,"Subtotal de Construções",null,null,null,{"$f":"'Custos F V'!L33","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!N33","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!P33","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!R33","v":{"$error":"#DIV/0!"}}]
[null,null,12.6,{"$f":"'Custos F V'!C34","v":"Animais de trabalho"},null,null,null,{"$f":"'Custos F V'!J37","v":0},{"$f":"'Custos F V'!K37","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!L37","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!M37","v":{"$error":"#DIV/0!"}}]
[]
[null,"SubTotal ",{"$f":"C37","v":"12. Depreciações"},null,null,null,null,{"$f":"SUM(H38:H43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I38:I43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J38:J43)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K38:K43)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"13. Manutenções"]
[null,null,13.1,{"$f":"D38","v":"Subtotal Máquinas"},null,null,null,{"$f":"'Maq Equip e Veic'!H24","v":0},{"$f":"'Maq Equip e Veic'!J24","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!L24","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!N24","v":{"$error":"#DIV/0!"}}]
[null,null,13.2,{"$f":"D39","v":"Subtotal Equipamentos"},null,null,null,{"$f":"'Maq Equip e Veic'!H46","v":0},{"$f":"'Maq Equip e Veic'!J46","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!L46","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!N46","v":{"$error":"#DIV/0!"}}]
[null,null,13.3,{"$f":"D40","v":"Subtotal Veículos"},null,null,null,{"$f":"'Maq Equip e Veic'!H58","v":0},{"$f":"'Maq Equip e Veic'!J58","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!L58","v":{"$error":"#DIV/0!"}},{"$f":"'Maq Equip e Veic'!N58","v":{"$error":"#DIV/0!"}}]
[null,null,13.4,"Subtotal Materiais de Escritório",null,null,null,{"$f":"'Mat Escrit'!H19","v":0},{"$f":"'Mat Escrit'!J19","v":{"$error":"#DIV/0!"}},{"$f":"'Mat Escrit'!L19","v":{"$error":"#DIV/0!"}},{"$f":"'Mat Escrit'!N19","v":{"$error":"#DIV/0!"}}]
[null,null,13.5,{"$f":"D42","v":"Subtotal de Construções"},null,null,null,{"$f":"'Custos F V'!K33","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!M33","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!O33","v":{"$error":"#DIV/0!"}},{"$f":"'Custos F V'!Q33","v":{"$error":"#DIV/0!"}}]
[]
[null,"SubTotal ",{"$f":"C47","v":"13. Manutenções"},null,null,null,null,{"$f":"SUM(H48:H52)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I48:I52)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J48:J52)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K48:K52)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"14. Outros custos fixos"]
[null,null,14.1,{"$f":"'Custos F V'!F62","v":"Impostos Fixos"},null,null,null,{"$f":"'Custos F V'!D75","v":0},{"$f":"'Custos F V'!E75","v":0},{"$f":"'Custos F V'!F75","v":0},{"$f":"'Custos F V'!G75","v":0}]
[]
[null,"SubTotal ",{"$f":"B33","v":"C - Custos Fixos (11 a 14)"},null,null,null,null,{"$f":"SUM(H35,H45,H54,H57)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I35,I45,I54,I57)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"D - Renda dos Fatores (15 a 17)"]
[]
[null,null,"15. Remuneração do capital de giro"]
[null,null,15.1,"Animais",null,null,null,{"$f":"(RelatZoot!D8*((1+RelatZoot!$M$20)^(RelatZoot!$D$12)-1))*RelatZoot!D5","v":0},{"$f":"IF(CaractSistema!E9>0,H64/(RelatZoot!$D$5*(1-RelatZoot!$D$15)),0)","v":0},{"$f":"I64/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"I64/RelatZoot!D12","v":{"$error":"#DIV/0!"}}]
[null,null,15.2,"Alimentação",null,null,null,{"$f":"H7*((1+RelatZoot!$M$20)^(RelatZoot!$D$12/2)-1)","v":0},{"$f":"H65/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I65/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K7*((1+RelatZoot!$M$20)^(RelatZoot!$D$12/2)-1)","v":0}]
[null,null,15.3,"Demais itens do capital de giro ",null,null,null,{"$f":"(H22-H6-H7+H31+H35)*((1+RelatZoot!$M$20)^(RelatZoot!$D$12/2)-1)","v":0},{"$f":"H66/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I66/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"(K22-K7+K31+K35)*((1+RelatZoot!$M$20)^(RelatZoot!$D$12/2)-1)","v":{"$error":"#DIV/0!"}}]
[]
[null,"SubTotal ",{"$f":"C63","v":"15. Remuneração do capital de giro"},null,null,null,null,{"$f":"SUM(H64:H66)","v":0},{"$f":"SUM(I64:I66)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J64:J66)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K64:K66)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"16. Remunerações do capital fixo (imobilizado)",null,null,null,null,{"$f":"SUM('Maq Equip e Veic'!P58,'Mat Escrit'!P19,'Custos F V'!F33,'Custos F V'!F37)*((1+RelatZoot!$M$18)^(365)-1)","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Maq Equip e Veic'!P58,'Mat Escrit'!P19,'Custos F V'!F33,'Custos F V'!F37)*((1+RelatZoot!$M$18)^(365)-1)/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I70/RelatZoot!D19","v":{"$error":"#DIV/0!"}},{"$f":"SUM('Maq Equip e Veic'!P58,'Mat Escrit'!P19,'Custos F V'!F33,'Custos F V'!F37)*((1+RelatZoot!$M$18)^(365)-1)/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"17. Remuneração da terra",null,null,null,null,{"$f":"(RelatZoot!M15*RelatZoot!M16)","v":0},{"$f":"(RelatZoot!M15*RelatZoot!M16)/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"I72/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"(RelatZoot!M15*RelatZoot!M16)/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[null,"SubTotal ",{"$f":"B61","v":"D - Renda dos Fatores (15 a 17)"},null,null,null,null,{"$f":"H68+H70+H72","v":{"$error":"#DIV/0!"}},{"$f":"I68+I70+I72","v":{"$error":"#DIV/0!"}},{"$f":"J68+J70+J72","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[null,"E - Custo Operacional Efetivo - COE",null,null,null,null,null,{"$f":"H22+H31+H35","v":0},{"$f":"I22+I31+I35","v":{"$error":"#DIV/0!"}},{"$f":"J22+J31+J35","v":{"$error":"#DIV/0!"}},{"$f":"K22+K31+K35","v":{"$error":"#DIV/0!"}}]
[null,"F - Custo Operacional Total - COT",null,null,null,null,null,{"$f":"H22+H31+H59","v":{"$error":"#DIV/0!"}},{"$f":"I22+I31+I59","v":{"$error":"#DIV/0!"}},{"$f":"J22+J31+J59","v":{"$error":"#DIV/0!"}},{"$f":"K22+K31+K59","v":{"$error":"#DIV/0!"}}]
[]
[null,"G -","Custo Total (A + B + C)",null,null,null,null,{"$f":"H22+H31+H59+H74","v":{"$error":"#DIV/0!"}},{"$f":"I22+I31+I59+I74","v":{"$error":"#DIV/0!"}},{"$f":"J22+J31+J59+J74","v":{"$error":"#DIV/0!"}},{"$f":"K22+K31+K59+K74-K64","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"H - Custo Operacional - COP (sem alimentação, animais e impostos)",null,null,null,null,null,{"$f":"(H80-H7-H6-H64-H65-H20)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"H83/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"RelatZoot!G18","v":"Ociosidade do sistema (%)"},{"$f":"RelatZoot!H18","v":{"$error":"#DIV/0!"}}]
[null,"Perdas econômicas",null,null,null,null,null,{"$f":"IF(RelatZoot!D5>0,RelatZoot!D7*RelatZoot!D15*(RelatZoot!D16*AlocaçãoCustos!K80+(AlocaçãoCustos!H6/RelatZoot!D5)),0)","v":0},{"$f":"H87/RelatZoot!D7","v":{"$error":"#DIV/0!"}},{"$f":"I87/RelatZoot!D19","v":{"$error":"#DIV/0!"}}]
[null,"Perdas econômicas por diária boi",null,null,null,null,null,{"$f":"RelatZoot!D7*RelatZoot!D15*(RelatZoot!D16*AlocaçãoCustos!K80)","v":{"$error":"#DIV/0!"}},{"$f":"H88/RelatZoot!D7","v":{"$error":"#DIV/0!"}},{"$f":"I88/RelatZoot!D19","v":{"$error":"#DIV/0!"}},{"$f":"H88/RelatZoot!H17","v":{"$error":"#DIV/0!"}}]

{"sheet":"Custos F V","index":12,"n_rows":75,"n_cols":18,"rows_kept":75,"cut":false,"hidden":true,"merged":[[51,2,51,8],[0,16,0,17],[0,2,1,7],[2,2,2,7],[0,12,0,13],[3,10,3,11],[42,2,42,7],[40,2,41,7],[33,2,33,7],[0,14,0,15],[27,10,27,11],[10,2,10,7],[16,2,16,7],[26,2,26,7],[11,10,11,11],[17,10,17,11]]}
[null,null,"CUSTOS FIXOS",null,null,null,null,null,null,null,null,null,"Boi",null,"@",null,"Diária boi"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Manutenção","Depreciação","Manutenção","Depreciação","Manutenção","Depreciação"]
[null,null,{"$f":"B6","v":"Piquetes/currais de engorda"}]
[null,null,null,null,null,null,null,null,null,null,"Anual"]
[null,null,null,null,"R$/cab","Valor (R$)","vida útil (anos)","Valor Residual (%)","Valor Residual (R$)","Taxa de Manutenção","Manutenção","Depreciação"]
[null,{"$f":"Instal!C7","v":"Piquetes/currais de engorda"},null,null,{"$f":"PiqEngord!D3","v":{"$error":"#DIV/0!"}},{"$f":"E6*RelatZoot!$M$7","v":{"$error":"#DIV/0!"}},{"$f":"IF(PiqEngord!D15>0,PiqEngord!D15,10)","v":10},{"$f":"IF(PiqEngord!D16<>\"\",PiqEngord!D16,0.2)","v":0.2},{"$f":"F6*H6","v":{"$error":"#DIV/0!"}},{"$f":"IF(PiqEngord!D17<>\"\",PiqEngord!D17,0.15)","v":0.15},{"$f":"F6*J6","v":{"$error":"#DIV/0!"}},{"$f":"(F6-I6)/G6","v":{"$error":"#DIV/0!"}},{"$f":"K6/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L6/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M6/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N6/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K6/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L6/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0.1]
[]
[null,{"$f":"Instal!C13","v":"Sistema de irrigação nos currais de engorda"},null,null,null,{"$f":"Instal!E15","v":0},{"$f":"IF(Instal!E16>0,Instal!E16,0.001)","v":1E-3},{"$f":"Instal!E17","v":0},{"$f":"F9*H9","v":0},{"$f":"Instal!E18","v":0},{"$f":"F9*J9","v":0},{"$f":"(F9-I9)/G9","v":0},{"$f":"K9/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L9/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M9/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N9/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K9/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L9/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"B14","v":"Curral de Manejo dos Animais"}]
[null,null,null,null,null,null,null,null,null,null,"Anual"]
[null,null,null,"Capacidade de processamento",null,"Valor (R$)","vida útil (anos)","Valor Residual (%)","Valor Residual (R$)","Taxa de Manutenção","Manutenção","Depreciação"]
[null,{"$f":"Instal!C22","v":"Curral de Manejo dos Animais"},null,{"$f":"Instal!E24","v":0},{"$f":"Instal!F24","v":"animais"},{"$f":"VLOOKUP(Instal!E24,Lista_Bens!B166:D170,3,1)","v":0},{"$f":"IF(Instal!E28>0,Instal!E28,10)","v":10},{"$f":"IF(Instal!E29<>\"\",Instal!E29,0.2)","v":0.2},{"$f":"F14*H14","v":0},{"$f":"IF(Instal!E30<>\"\",Instal!E30,0.1)","v":0.1},{"$f":"F14*J14","v":0},{"$f":"(F14-I14)/G14","v":0},{"$f":"K14/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L14/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M14/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N14/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K14/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L14/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0.1,null,{"$f":"F15*H15","v":0},null,{"$f":"F15*J15","v":0},{"$f":"(F15-I15)/G15","v":0},{"$f":"K15/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L15/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M15/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N15/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K15/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L15/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Demais instalações"]
[null,null,null,null,null,null,null,null,null,null,"Anual"]
[null,null,"R$/m²","m²","Rateio (%)","Valor (R$)","vida útil (anos)","Valor Residual (%)","Valor Residual (R$)","Taxa de Manutenção","Manutenção","Depreciação"]
[null,{"$f":"Instal!C34","v":"Fábrica de Ração e anexos"},{"$f":"Instal!E37","v":0},{"$f":"Instal!E36","v":0},{"$f":"Instal!E42","v":0},{"$f":"IF(Instal!E37>0,C20*D20*E20,CaractSistema!E109*D20*E20)","v":0},{"$f":"IF(Instal!E39>0,Instal!E39,10)","v":10},{"$f":"IF(Instal!E40<>\"\",Instal!E40,0.2)","v":0.2},{"$f":"F20*H20","v":0},{"$f":"IF(Instal!E41<>\"\",Instal!E41,0.05)","v":0.05},{"$f":"F20*J20","v":0},{"$f":"(F20-I20)/G20","v":0},{"$f":"K20/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L20/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M20/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N20/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K20/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L20/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Instal!C46","v":"Escritório Administrativo"},{"$f":"Instal!E49","v":0},{"$f":"Instal!E48","v":0},{"$f":"Instal!E54","v":0},{"$f":"IF(Instal!E49>0,C21*D21*E21,CaractSistema!E110*D21*E21)","v":0},{"$f":"IF(Instal!E51>0,Instal!E51,20)","v":20},{"$f":"IF(Instal!E52<>\"\",Instal!E52,0.2)","v":0.2},{"$f":"F21*H21","v":0},{"$f":"IF(Instal!E53<>\"\",Instal!E53,0.1)","v":0.1},{"$f":"F21*J21","v":0},{"$f":"(F21-I21)/G21","v":0},{"$f":"K21/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L21/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M21/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N21/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K21/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L21/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Instal!C58","v":"Barracão de Máquinas"},{"$f":"Instal!E61","v":0},{"$f":"Instal!E60","v":0},{"$f":"Instal!E66","v":0},{"$f":"IF(Instal!E61>0,(C22*D22)*E22,(CaractSistema!E109*D22)*E22)","v":0},{"$f":"IF(Instal!E63>0,Instal!E63,10)","v":10},{"$f":"IF(Instal!E64<>\"\",Instal!E64,0.2)","v":0.2},{"$f":"F22*H22","v":0},{"$f":"IF(Instal!E65<>\"\",Instal!E65,0.05)","v":0.05},{"$f":"F22*J22","v":0},{"$f":"(F22-I22)/G22","v":0},{"$f":"K22/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L22/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M22/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N22/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K22/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L22/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"Instal!D83","v":"Área de Vivência e outros (selaria, sanitários, quiosques, ...)"},{"$f":"Instal!E86","v":0},{"$f":"Instal!E85","v":0},{"$f":"Instal!E91","v":0},{"$f":"IF(Instal!E86>0,(C23*D23)*E23,(CaractSistema!E109*D23)*E23)","v":0},{"$f":"IF(Instal!E88>0,Instal!E88,10)","v":10},{"$f":"IF(Instal!E89<>\"\",Instal!E89,0.2)","v":0.2},{"$f":"F23*H23","v":0},{"$f":"IF(Instal!E90<>\"\",Instal!E90,0.05)","v":0.05},{"$f":"F23*J23","v":0},{"$f":"(F23-I23)/G23","v":0},{"$f":"K23/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L23/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M23/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N23/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K23/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L23/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0.1,null,null,null,null,null,{"$f":"K24/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L24/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M24/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N24/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K24/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L24/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0.1,null,null,null,null,null,{"$f":"K25/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L25/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M25/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N25/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K25/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L25/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[null,null,{"$f":"B30","v":"Casas para funcionários do confinamento"}]
[null,null,null,null,null,null,null,null,null,null,"Anual"]
[null,null,"R$/un","Rateio (%)","Unidades","Valor (R$)","vida útil (anos)","Valor Residual (%)","Valor Residual (R$)","Taxa de Manutenção","Manutenção","Depreciação"]
[null,{"$f":"Instal!C70","v":"Casas para funcionários do confinamento"},{"$f":"IF(Instal!E74>0,Instal!E73*Instal!E74,Instal!E73*CaractSistema!E110)+IF(Instal!E73=0,120*CaractSistema!E110)","v":0},{"$f":"Instal!E79","v":0},{"$f":"Instal!E72","v":0},{"$f":"(C30*E30*D30)","v":0},{"$f":"IF(Instal!E76>0,Instal!E76,20)","v":20},{"$f":"IF(Instal!E77>0,Instal!E77,0.1)","v":0.1},{"$f":"F30*H30","v":0},{"$f":"IF(Instal!E78>0,Instal!E78,0.05)","v":0.05},{"$f":"F30*J30","v":0},{"$f":"(F30-I30)/G30","v":0},{"$f":"K30/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L30/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M30/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N30/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K30/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L30/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0.1,null,null,null,null,null,{"$f":"K31/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L31/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M31/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N31/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K31/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L31/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,0.1,null,null,null,null,null,{"$f":"K32/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"L32/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"M32/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"N32/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"K32/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}},{"$f":"L32/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"SUM(F6,F9,F14,F20:F23,F30)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(K6:K32)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,{"$f":"CaractSistema!C99","v":"Animais de trabalho"}]
[null,null,null,null,null,null,null,null,null,"Anual"]
[null,null,null,"Unidades","R$/animal","Valor Unitário","Vida útil (anos)","Valor Residual (%)","Valor Residual (R$)","Depreciação","Custo/boi","Custo/@","Custo/DB"]
[null,{"$f":"CaractSistema!C101","v":"Tropa de animais para serviço no confinamento"},null,{"$f":"CaractSistema!E101","v":0},{"$f":"CaractSistema!E102","v":0},{"$f":"E37*D37","v":0},{"$f":"IF(CaractSistema!E103>0,CaractSistema!E103,10)","v":10},{"$f":"IF(CaractSistema!E104<>\" \",CaractSistema!E104,0)","v":0},{"$f":"F37*H37","v":0},{"$f":"(F37-I37)/G37","v":0},{"$f":"J37/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"K37/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"J37/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,"CUSTOS VARIÁVEIS"]
[]
[null,null,"Limpeza"]
[]
[null,null,"Hmaq/curral","Qtdds horas Maq","R$/h máquina","Nº de anim/piq","R$/Anual","Custo Limpeza/boi","Custo Limpeza/@","Custo Limpeza/DB"]
[null,"Raspagem/Carregamento  - Pá carregadeira",4,{"$f":"(Instal!$E$11*PiqEngord!$D$7)*C46","v":0},{"$f":"CaractSistema!E69","v":0},{"$f":"PiqEngord!$D$7","v":0},{"$f":"D46*E46","v":0},{"$f":"G46/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H46/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G46/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Viagens/piq","Qtdds Viagens","R$/viagem","Nº de anim/piq","R$/Anual","Custo Limpeza/boi","Custo Limpeza/@","Custo Limpeza/DB"]
[null,"Transporte do esterco ",{"$f":"F46/10","v":0},{"$f":"(Instal!$E$11*PiqEngord!$D$7)*C49","v":0},26.5,{"$f":"PiqEngord!$D$7","v":0},{"$f":"D49*E49","v":0},{"$f":"G49/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"H49/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"G49/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[]
[null,"Limpeza e aterramento dos piquetes",null,null,null,null,{"$f":"SUM(G49:G50,G46:G47)","v":0},{"$f":"SUM(H49:H50,H46:H47)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I49:I50,I46:I47)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J49:J50,J46:J47)","v":{"$error":"#DIV/0!"}}]
[null,null,"Mortalidade"]
[]
[null,null,null,"R$/h maq","Unidades","R$/Anual","Mortalidade/boi","Mortalidade/@","Mortalidade/DB"]
[null,"Protocolo Saninátio e de Identificação",null,null,{"$f":"RelatZoot!$D$7*RelatZoot!$D$15","v":0},{"$f":"E55*(CaractZoot!E39+CaractZoot!E51)","v":0},{"$f":"F55/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"G55/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F55/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,"Transporte de animais mortos",null,{"$f":"CaractSistema!E69","v":0},{"$f":"RelatZoot!$D$7*RelatZoot!$D$15","v":0},{"$f":"E56*(D56/2)","v":0},{"$f":"F56/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"G56/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F56/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,"Custo da mortalidade (Aquisição + dias de alimentação)",null,null,{"$f":"RelatZoot!$D$7*RelatZoot!$D$15","v":0},{"$f":"E57*((RelatZoot!D8)+(RelatZoot!D16*CaractZoot!J76))","v":0},{"$f":"F57/(RelatZoot!$D$7*(1-RelatZoot!$D$15))","v":{"$error":"#DIV/0!"}},{"$f":"G57/RelatZoot!$D$19","v":{"$error":"#DIV/0!"}},{"$f":"F57/RelatZoot!$H$17","v":{"$error":"#DIV/0!"}}]
[null,"Mortalidade dos animais",null,null,null,{"$f":"SUM(F55:F57)","v":0},{"$f":"SUM(G55:G57)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H55:H57)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(I55:I57)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,"Impostos Variáveis",null,"/ ","Impostos Fixos"]
[]
[null,null,"Taxa (%)","R$/Anual","R$/boi","R$/@","R$/DB"]
[null,"Funrural - Pessoa Física",2.3E-2,{"$f":"C65*(RelatZoot!$H$15*RelatZoot!$D$14)","v":0},{"$f":"IF(RelatZoot!D5>0,D65/(RelatZoot!$D$5*(1-RelatZoot!D15)),0)","v":0},{"$f":"IF(RelatZoot!D5>0,D65/RelatZoot!$H$15,0)","v":0},{"$f":"IF(RelatZoot!D5>0,D65/(RelatZoot!$H$17*(RelatZoot!$D$5/RelatZoot!$D$7)),0)","v":0}]
[null,"IRPF - Pessoa Física",0.27500000000000002,"((((Receita-despesas)*20%)-o que aparece na tabela(9.xxx,00))*27,5%)"]
[null,"Funrural - Pessoa Jurídica - Presumido",2.8500000000000001E-2,{"$f":"C67*(RelatZoot!$D$12*RelatZoot!$M$13*RelatZoot!$D$6)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D67/(RelatZoot!$D$6*(1-RelatZoot!$D$15)),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D67/(RelatZoot!$H$16-RelatZoot!$H$15),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D67/(RelatZoot!$H$17*(RelatZoot!$D$6/RelatZoot!$D$7)),0)","v":0}]
[null,"IRPJ",0.15,{"$f":"C68*((RelatZoot!$D$12*RelatZoot!$M$13*RelatZoot!$D$6)*0.32)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D68/(RelatZoot!$D$6*(1-RelatZoot!$D$15)),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D68/(RelatZoot!$H$16-RelatZoot!$H$15),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D68/(RelatZoot!$H$17*(RelatZoot!$D$6/RelatZoot!$D$7)),0)","v":0}]
[null,"IRPJ adicional",0.1,{"$f":"IF(RelatZoot!D6>0,C69*(((RelatZoot!$D$12*RelatZoot!$M$13*RelatZoot!$D$6)*0.32)-240000),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D69/(RelatZoot!$D$6*(1-RelatZoot!$D$15)),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D69/(RelatZoot!$H$16-RelatZoot!$H$15),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D69/(RelatZoot!$H$17*(RelatZoot!$D$6/RelatZoot!$D$7)),0)","v":0}]
[null,"CSLL",0.09,{"$f":"C70*((RelatZoot!$D$12*RelatZoot!$M$13*RelatZoot!$D$6)*0.32)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D70/(RelatZoot!$D$6*(1-RelatZoot!$D$15)),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D70/(RelatZoot!$H$16-RelatZoot!$H$15),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D70/(RelatZoot!$H$17*(RelatZoot!$D$6/RelatZoot!$D$7)),0)","v":0}]
[null,"PIS",6.4999999999999997E-3,{"$f":"C71*(RelatZoot!$D$12*RelatZoot!$M$13*RelatZoot!$D$6)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D71/(RelatZoot!$D$6*(1-RelatZoot!$D$15)),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D71/(RelatZoot!$H$16-RelatZoot!$H$15),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D71/(RelatZoot!$H$17*(RelatZoot!$D$6/RelatZoot!$D$7)),0)","v":0}]
[null,"COFINS",0.03,{"$f":"C72*(RelatZoot!$D$12*RelatZoot!$M$13*RelatZoot!$D$6)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D72/(RelatZoot!$D$6*(1-RelatZoot!$D$15)),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D72/(RelatZoot!$H$16-RelatZoot!$H$15),0)","v":0},{"$f":"IF(RelatZoot!$D$6>0,D72/(RelatZoot!$H$17*(RelatZoot!$D$6/RelatZoot!$D$7)),0)","v":0}]
[null,{"$f":"C62&\" - Total\"","v":"Impostos Variáveis - Total"},null,{"$f":"SUM(D65:D72)","v":0},{"$f":"SUM((E65*(RelatZoot!$D$5/RelatZoot!$D$7))+(SUM(E67:E72)*(RelatZoot!$D$6/RelatZoot!$D$7)))","v":{"$error":"#DIV/0!"}},{"$f":"SUM((F65*(RelatZoot!$D$5/RelatZoot!$D$7))+(SUM(F67:F72)*(RelatZoot!$D$6/RelatZoot!$D$7)))","v":{"$error":"#DIV/0!"}},{"$f":"SUM((G65*(RelatZoot!$D$5/RelatZoot!$D$7))+(SUM(G67:G72)*(RelatZoot!$D$6/RelatZoot!$D$7)))","v":{"$error":"#DIV/0!"}}]
[]
[null,"ITR"]

{"sheet":"RelatZoot","index":13,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":true,"merged":[[7,11,7,12],[1,4,1,8]]}
[]
[null,null,null,null,"Painel de Informações"]
[]
[]
[null,null,"Animais - próprios + compras",{"$f":"CaractSistema!E9","v":0},null,null,null,null,null,null,null,"Águas","Secas"]
[null,null,"Animais - prestação de serviço",{"$f":"CaractSistema!E10","v":0},null,null,null,null,null,null,"duração (meses)",{"$f":"CaractSistema!E7","v":0},{"$f":"12-L6","v":12}]
[null,null,"Animais confinados ao ano",{"$f":"D5+D6","v":0},null,null,null,null,null,null,"Lotação  (animais)",{"$f":"CaractSistema!E6","v":0},{"$f":"CaractSistema!E5","v":0}]
[null,null,"Boi Magro (R$/cab)",{"$f":"CaractZoot!E18","v":0},null,null,null,null,null,null,"Lotação média ao ano",{"$f":"(L6/12)*L7+(M6/12)*M7","v":0}]
[null,null,"PV inicial médio (kg/cab)",{"$f":"CaractZoot!E11","v":0}]
[null,null,"PV final médio (kg/cab)",{"$f":"CaractZoot!E12","v":0},null,null,null,null,null,null,null,"Capacidade teorica anual (animais)",{"$f":"L8*(360/D12)","v":{"$error":"#DIV/0!"}}]
[null,null,"PV médio período (kg/cab)",{"$f":"(D9+D10)/2","v":0},null,null,null,null,null,null,null,"Capacidade teorica anual (@)",{"$f":"M10*D19","v":{"$error":"#DIV/0!"}}]
[null,null,"Dias em confinamento",{"$f":"CaractZoot!E14","v":0},null,null,null,null,null,null,null,"DB - capacidade max teorica nominal",{"$f":"M10*D12","v":{"$error":"#DIV/0!"}}]
[null,null,"Rend. de Carcaça médio (%)",{"$f":"CaractZoot!E13","v":0},null,null,null,null,null,null,null,"Valor cobrado da diária boi - DB",{"$f":"CaractZoot!E20","v":0}]
[null,null,"Valor recebido por @",{"$f":"CaractZoot!E19","v":0}]
[null,null,"Mortalidade (%)",{"$f":"CaractZoot!E15","v":0},null,null,"Quantidade vendidas de @",{"$f":"$D$19*D5*(1-$D$15)","v":0},null,null,null,"Área de ocupação do sistema (ha)",{"$f":"CaractSistema!E12","v":0}]
[null,null,"Período de Mortalidade (dias)",{"$f":"CaractZoot!E16","v":0},null,null,"Quantidade produzida de @",{"$f":"$D$19*D7*(1-$D$15)","v":0},null,null,null,"Arrendamento - outra atividade (R$/ano)",{"$f":"CaractSistema!E13","v":0}]
[null,null,null,null,null,null,"Quantidade produzida de DB",{"$f":"(D7*(1-D15)*D12)+(D7*D15*D16)","v":0},null,null,null,"Juros sobre capital imobiliz. (ao ano)",{"$f":"CaractSistema!E14","v":0}]
[null,null,"Ganho de peso médio (kg/dia)",{"$f":"(D10-D9)/D12","v":{"$error":"#DIV/0!"}},null,null,"Ociosidade do sistema (%)",{"$f":"1-($H$16/$M$11)","v":{"$error":"#DIV/0!"}},null,null,null,"Juros sobre capital imobiliz. (ao dia)",{"$f":"(1+M17/100)^(100/365)-1","v":0}]
[null,null,"Carcaça em @",{"$f":"(D10*D13)/15","v":0},null,null,null,null,null,null,null,"Juros sobre capital de giro (ao ano)",{"$f":"CaractSistema!E15","v":0}]
[null,null,"Arrobas produzidas no período @",{"$f":"D19-((D9*0.5)/15)","v":0},null,null,null,null,null,null,null,"Juros sobre capital de giro (ao dia)",{"$f":"(1+M19/100)^(100/365)-1","v":0}]