{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Menu","Controle Animal","Alimentação"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":2,"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":"Menu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Controle Animal","index":1,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[[2,0,2,1],[0,0,0,5],[3,0,3,1],[4,0,4,1],[3,7,3,10],[4,7,4,10]]}
[{"$f":"\"Consulta - \" &C3","v":"Consulta - Lote A"},null,null,null,null,null,null,null,null,null,null,null,null,"Configurações:"]
[{"$f":"TODAY()","v":"2020-12-17"},null,"Lote",null,null,null,null,null,null,null,null,null,null,"Lote A"]
["Selecione o Lote:",null,"Lote A",null,null,null,null,null,null,null,null,null,null,"Lote B"]
[" Após seleção, clique em atualizar.",null,null,null,null,null,null,"LEGENDA",null,null,null,null,null,"Lote C"]
["Para nova consulta, limpe o filtro.",null,null,null,null,null,null,"Celulás em azul claro liberado prenchimento!",null,null,null,null,null,"Pós-Parto"]
[]
["ID/BRINCO","NOME","DATA PARTO","LITRO/DIA","Nº DO PARTO","LOTE","DEL","Situação"]
[6,"Lareira","2020-05-22",56,5,"Lote A",{"$f":"A2-C8","v":209},"Prenha"]
[26,"Gorila","2020-02-22",10,3,"Lote A",{"$f":"A2-C9","v":299},"Prenha"]
[27,"Brahma","2020-01-23",25,4,"Lote A",{"$f":"A2-C10","v":329},"Prenha"]
[7,"Escala","2020-04-05",31,2,"Lote A",{"$f":"A2-C11","v":256},"Vazia"]
[5,"Patrulha","2019-12-28",24,4,"Lote A",{"$f":"A2-C12","v":355},"Prenha"]
[28,"Skol","2020-08-06",48,1,"Lote A",{"$f":"A2-C13","v":133},"Prenha"]
[13,"Oferta","2020-05-29",41,4,"Lote A",{"$f":"A2-C14","v":202},"Vazia"]
[3,"Feiticeira","2020-07-23",19,2,"Lote A",{"$f":"A2-C15","v":147},"Inseminada"]
[29,"Natércia","2020-07-27",36,1,"Lote A",{"$f":"A2-C16","v":143},"Prenha"]
[18,"Lorena","2020-05-05",24.2,4,"Lote B",{"$f":"A2-C17","v":226},"Inseminada"]
[14,"Surpresa","2020-04-19",24,4,"Lote B",{"$f":"A2-C18","v":242},"Inseminada"]
[19,"Evidência","2020-06-03",23.6,5,"Lote B",{"$f":"A2-C19","v":197},"Inseminada"]
[2,"Nectárina","2020-08-25",23,4,"Lote B",{"$f":"A2-C20","v":114},"Prenha"]
[10,"Pintura","2020-03-12",23,3,"Lote B",{"$f":"A2-C21","v":280},"Prenha"]
[16,"Itatiba","2020-03-17",23,3,"Lote B",{"$f":"A2-C22","v":275},"Prenha"]
[20,"Paula","2020-08-08",22,1,"Lote B",{"$f":"A2-C23","v":131},"Prenha"]
[17,"Predileta","2020-04-20",21.5,4,"Lote B",{"$f":"A2-C24","v":241},"Inseminada"]
[15,"Floresta","2020-02-13",20.9,2,"Lote B",{"$f":"A2-C25","v":308},"Inseminada"]
[11,"Revista","2020-03-14",20.2,7,"Lote B",{"$f":"A2-C26","v":278},"Vazia"]
[8,"Mancha","2020-02-16",20,1,"Lote B",{"$f":"A2-C27","v":305},"Vazia"]
[12,"Caravela","2020-04-16",19.5,2,"Lote C",{"$f":"A2-C28","v":245},"Vazia"]
[9,"Caravana","2020-02-23",19,1,"Lote C",{"$f":"A2-C29","v":298},"Prenha"]
[22,"Paródia","2020-08-14",18,3,"Lote C",{"$f":"A2-C30","v":125},"Inseminada"]
[25,"Autrália","2020-03-21",16.8,2,"Lote C",{"$f":"A2-C31","v":271},"Prenha"]
[24,"Dinamarca","2020-05-24",13,5,"Lote C",{"$f":"A2-C32","v":207},"Prenha"]
[23,"Heliodora","2020-03-23",12.7,2,"Lote C",{"$f":"A2-C33","v":269},"Inseminada"]
[4,"Salomé","2020-05-15",12,3,"Pós-parto",{"$f":"A2-C34","v":216},"Prenha"]
[21,"Baleia","2020-08-09",8,1,"Lote B",{"$f":"A2-C35","v":130},"Prenha"]
[1,"Serenata","2020-08-27",5,3,"Lote B",{"$f":"A2-C36","v":112},"Prenha"]
[null,null,null,null,null,null,{"$f":"A2-C37","v":44182}]
[null,null,null,null,null,null,{"$f":"A2-C38","v":44182}]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]
[null,null,null,null,null,null,"="]

{"sheet":"Alimentação","index":2,"n_rows":32,"n_cols":36,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,35,7,36],[1,34,3,36],[6,34,7,34],[11,23,12,23],[3,23,4,23],[5,23,6,23],[13,23,14,23],[11,21,12,22],[13,21,14,22],[7,23,8,23],[3,8,4,9],[5,5,6,7],[5,8,6,9],[1,10,2,14],[3,10,4,12],[3,13,4,14],[5,10,6,12],[5,13,6,14],[13,5,14,7],[13,8,14,9],[13,10,14,12],[13,13,14,14],[7,5,8,7],[7,8,8,9],[9,5,10,7],[9,8,10,9],[11,5,12,7],[11,8,12,9],[7,10,8,12],[7,13,8,14],[9,10,10,12],[9,13,10,14],[11,10,12,12],[11,13,12,14],[5,18,6,19],[7,18,8,19],[9,18,10,19],[11,18,12,19],[13,18,14,19],[1,21,2,23],[1,0,2,4],[13,0,14,2],[3,3,4,4],[5,3,6,4],[7,3,8,4],[9,3,10,4],[11,3,12,4],[13,3,14,4],[1,15,2,19],[3,15,4,17],[5,15,6,17],[3,0,4,2],[5,0,6,2],[7,0,8,2],[9,0,10,2],[11,0,12,2],[1,5,2,9],[3,5,4,7],[0,0,0,19],[17,0,17,19],[18,0,19,7],[27,16,27,19],[28,16,28,19],[30,16,30,19],[31,16,31,19],[29,9,29,19],[9,29,10,30],[11,29,13,30],[3,29,4,30],[5,29,6,30],[7,29,8,30],[3,25,4,25],[3,26,4,27],[5,25,6,25],[5,26,6,27],[9,25,10,25],[9,26,10,27],[7,15,8,17],[9,15,10,17],[11,15,12,17],[13,15,14,17],[3,18,4,19],[26,16,26,19],[24,9,24,19],[25,9,25,15],[26,9,26,15],[27,9,27,15],[28,9,28,15],[30,9,30,15],[31,9,31,15],[23,9,23,15],[20,0,22,4],[23,0,25,4],[20,5,22,7],[23,5,25,7],[18,9,19,19],[20,16,20,19],[21,16,21,19],[20,9,20,15],[21,9,21,15],[22,9,22,19],[23,16,23,19],[25,16,25,19],[0,21,0,36],[4,34,5,34],[4,35,5,36],[7,26,8,27],[7,25,8,25],[1,25,2,27],[1,29,2,32],[21,21,31,26],[17,21,20,26],[3,31,4,32],[5,31,6,32],[7,31,8,32],[9,31,10,32],[11,31,13,32],[9,23,10,23],[7,21,8,22],[9,21,10,22],[3,21,4,22],[5,21,6,22],[8,34,8,36],[9,34,11,34],[9,35,11,36],[12,34,14,34],[12,35,14,36]]}
["DADOS DOS LOTES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANÁLISE GERAL"]
["Dados - Lote A ",null,null,null,null,"Dados - Lote B",null,null,null,null,"Dados - Lote C",null,null,null,null,"Dados - Pós Parto",null,null,null,null,null,"Produção TOTAL",null,null,null,"ANÁLISE DE CUSTO DIÁRIO",null,null,null,"ANÁLISE DE CUSTO MENSAL",null,null,null,null,"Custo Alimentar"]
[]
["Média de produção (L)",null,null,{"$f":"AVERAGE('Controle Animal'!D8:D16)","v":32.222222222222221},null,"Média de produção (L)",null,null,{"$f":"AVERAGE('Controle Animal'!D17:D36)","v":18.47},null,"Média de produção (L)",null,null,{"$f":"AVERAGE('Controle Animal'!D28:D33)","v":16.5},null,"Média de produção (L)",null,null,{"$f":"AVERAGE('Controle Animal'!D34)","v":12},null,null,"Nº Lactantes:",null,{"$f":"COUNT('Controle Animal'!A8:A200)","v":29},null,"Quantidade gasta de Volumoso (kg/dia)",{"$f":"F24","v":720},null,null,"Quantidade gasta de Volumoso kg/mês",null,{"$f":"AA4*30","v":21600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Produção por mês (L)",{"$f":"X10","v":18873.3}]
["Produção total  (L/dia)",null,null,{"$f":"COUNT('Controle Animal'!E8,'Controle Animal'!E9,'Controle Animal'!E10,'Controle Animal'!E11,'Controle Animal'!E12,'Controle Animal'!E13,'Controle Animal'!E14,'Controle Animal'!E15,'Controle Animal'!E16)*D4","v":290},null,"Produção total  (L/dia)",null,null,{"$f":"COUNT('Controle Animal'!D17,'Controle Animal'!D18,'Controle Animal'!D19,'Controle Animal'!D20,'Controle Animal'!D21,'Controle Animal'!D22,'Controle Animal'!D23,'Controle Animal'!D24,'Controle Animal'!D25,'Controle Animal'!D26,'Controle Animal'!D27,'Controle Animal'!D35,'Controle Animal'!D36)*I4","v":240.10999999999999},null,"Produção total  (L/dia)",null,null,{"$f":"COUNT('Controle Animal'!D28,'Controle Animal'!D29,'Controle Animal'!D30,'Controle Animal'!D31,'Controle Animal'!D32,'Controle Animal'!D33)*N4","v":99},null,"Produção total  (L/dia)",null,null,{"$f":"COUNT('Controle Animal'!D34)*S4","v":12},null,null,"Média de produção (L)",null,{"$f":"AVERAGE('Controle Animal'!D8:D200)","v":22.737931034482759},null,"Despesa com Volumoso por dia (R$)",{"$f":"AA4*Q32","v":144},null,null,"Despesa com Volumoso (R$ por mês)",null,{"$f":"AA6*30","v":4320}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renda Bruta mensal(R$)",{"$f":"AJ5*X12","v":36802.934999999998}]
["Consumo (kg de matéria seca/dia)",null,null,{"$f":"(Q24*Q26/100)*COUNT('Controle Animal'!D8,'Controle Animal'!D9,'Controle Animal'!D10,'Controle Animal'!D11,'Controle Animal'!D12,'Controle Animal'!D13,'Controle Animal'!D14,'Controle Animal'!D15,'Controle Animal'!D16)","v":135},null,"Consumo (kg de matéria seca/dia)",null,null,{"$f":"(Q24*Q26/100)*COUNT('Controle Animal'!D17,'Controle Animal'!D18,'Controle Animal'!D19,'Controle Animal'!D20,'Controle Animal'!D21,'Controle Animal'!D22,'Controle Animal'!D23,'Controle Animal'!D24,'Controle Animal'!D25,'Controle Animal'!D26,'Controle Animal'!D27,'Controle Animal'!D35,'Controle Animal'!D36)","v":195},null,"Consumo (kg de matéria seca/dia)",null,null,{"$f":"(Q24*Q26/100)*COUNT('Controle Animal'!D28,'Controle Animal'!D29,'Controle Animal'!D30,'Controle Animal'!D31,'Controle Animal'!D32,'Controle Animal'!D33)","v":90},null,"Consumo (kg de matéria seca/dia)",null,null,{"$f":"(Q24*Q26/100)*COUNT('Controle Animal'!D34)","v":15},null,null,"Produção/dia (L)",null,{"$f":"D6+I6+N6","v":629.11},null,"Quantidade gasta de Concentrado (kg/dia)",{"$f":"F21","v":186.66666666666666},null,null,"Quantidade gasta de Concentrado kg/mês",null,{"$f":"AA8*30","v":5600}]
[]
["Consumo de alimento concentrado (kg/dia)",null,null,{"$f":"D8-D12","v":54},null,"Consumo de alimento concentrado (kg/dia)",null,null,{"$f":"I8-I12","v":78},null,"Consumo de alimento concentrado (kg/dia)",null,null,{"$f":"N8-N12","v":36},null,"Consumo de alimento concentrado (kg/dia)",null,null,{"$f":"S8-S12","v":6},null,null,"Produção/mês (L)",null,{"$f":"X8*30","v":18873.3},null,"Despesa com Concentrado por dia (R$)",{"$f":"AA8*Q31","v":223.99999999999997},null,null,"Despesa com Concentrado por mês (R$)",null,{"$f":"AA10*30","v":6719.9999999999991},null,null,"Custo com alimentação mensal(R$)",{"$f":"AF12/AJ5","v":0.58495334679149913}]
[]
["Consumo de alimento volumoso(kg/dia)",null,null,{"$f":"D8*Alimentação!Q21/100","v":81},null,"Consumo de alimento volumoso(kg/dia)",null,null,{"$f":"I8*Q21/100","v":117},null,"Consumo de alimento volumoso(kg/dia)",null,null,{"$f":"N8*Q21/100","v":54},null,"Consumo de alimento volumoso(kg/dia)",null,null,{"$f":"S8*Q21/100","v":9},null,null,"Preço/litro (R$):",null,1.95,null,null,null,null,null,"Despesa/total/mês(R$):",null,{"$f":"AF6+AF10","v":11040}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custo com alimentação mensal(%)",{"$f":"(AJ10*100)/X12","v":29.997607527769187}]
["Consumo total de matéria seca/mês",null,null,{"$f":"D8*30","v":4050},null,"Consumo total de matéria seca/mês",null,null,{"$f":"I8*30","v":5850},null,"Consumo total de matéria seca/mês",null,null,{"$f":"N8*30","v":2700},null,"Consumo total de matéria seca/mês",null,null,{"$f":"S8*30","v":450},null,null,"Ganho Mensal(R$):",null,{"$f":"X12*X10","v":36802.934999999998}]
[]
[]
[]
["DADOS DA ALIMENTAÇÃO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEGENDA"]
["Consumo de matéia natural por dia (kg)",null,null,null,null,null,null,null,null,"Parâmetros do Rebanho"]
[]
["Concentrado:",null,null,null,null,{"$f":"(D10+I10+N10)*100/Q28","v":186.66666666666666},null,null,null,"Relação Volumoso",null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,"Relação Concentrado",null,null,null,null,null,null,40,null,null,null,null,"Células em azul claro devem ser preenchidas!"]
[]
["Volumoso:",null,null,null,null,{"$f":"(D12+I12+N12)*100/Q29","v":720},null,null,null,"Peso vivo médio do lote (kg):",null,null,null,null,null,null,500]
[]
[null,null,null,null,null,null,null,null,null,"Relação Matéria Seca(%)",null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Nº animais:",null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,"Matéria Seca/Concentrado(%)",null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,"Matéria Seca/Volumoso (%)",null,null,null,null,null,null,35]
[]
[null,null,null,null,null,null,null,null,null," Custo Concentrado(R$):",null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null," Custo Volumoso (R$:",null,null,null,null,null,null,0.2]