{"text_format":"3","workbook":"xls","n_sheets":42,"sheets":["Balanceamento","Composição ingredientes","Ajuda","Plan6","Plan7","Plan8","Plan9","Plan10","Plan11","Plan12","Plan13","Plan14","Plan15","Plan16","Plan17","Plan18","Plan19","Plan20","Plan21","Plan22","Plan23","Plan24","Plan25","Plan26","Plan27","Plan28","Plan29","Plan30","Plan31","Plan32","Plan33","Plan34","Plan35","Plan36","Plan37","Plan38","Plan39","Plan2","Plan3","Plan41","Plan42","Plan40"],"not_rendered":{"images":1,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Balanceamento","index":0,"n_rows":77,"n_cols":13,"rows_kept":77,"merged":[[15,1,16,1],[16,5,16,11],[27,3,27,4],[27,6,27,7],[27,9,27,11],[56,8,57,11],[57,5,58,5],[57,6,58,6],[60,8,60,11],[62,8,62,11],[64,8,64,11],[66,8,66,11],[68,8,68,11],[70,8,70,11],[72,8,72,11],[74,8,74,11]],"flags":["formulas_cached_only"]}
[null,"PARTE 1 - COMPOSIÇÃO DOS INGREDIENTES DA DIETA"]
["Tipo de alimento","Ingredientes","MS                                                              % "," NDT                % da MS","EM                                  Mcal/ kg MS","Elm                                    Mcal/ kg MS","Elg                                Mcal/ kg MS"," PB                            % da MS","Degr. PB            % da MS","PDR                                     % da MS","Ca                                    % MS","P                                          % MS","Preço                       R$/kg"]
["Volumoso principal","Past. Ruim (Mai/Jun/Jul)",40,{"v":55,"d":"55.0"},{"v":1.9909999999999999,"d":"1.991"},{"v":1.1434979173455,"d":"1.143"},{"v":0.5837582263062,"d":"0.584"},6.5,68,{"v":4.42,"d":"4.4"},{"v":0.3,"d":"0.30"},0.13]
["Volumoso suplementar","Cana-de-açúcar",26,{"v":63,"d":"63.0"},{"v":2.2806,"d":"2.281"},{"v":1.4112131539374682,"d":"1.411"},{"v":0.8281671546679155,"d":"0.828"},{"v":4,"d":"4.0"},65,2.6,0.23,0.06]
["Concentrado","Milho, grão",88,{"v":85,"d":"85.0"},3.077,{"v":2.0948103820964996,"d":"2.095"},{"v":1.4273407279025996,"d":"1.427"},9.5,45,{"v":4.275,"d":"4.3"},0.03,{"v":0.3,"d":"0.30"}]
["Concentrado","Soja, farelo",90,{"v":82,"d":"82.0"},{"v":2.9684000000000004,"d":"2.968"},{"v":2.0053704313177927,"d":"2.005"},{"v":1.3510448674831488,"d":"1.351"},{"v":46,"d":"46.0"},65,29.9,{"v":0.4,"d":"0.40"},0.71]
["Concentrado","Uréia + sulfato de amônio*",99,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":260,"d":"260.0"},80,{"v":208,"d":"208.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Concentrado","Algodão, caroço",91,{"v":90,"d":"90.0"},3.258,{"v":2.241763787876,"d":"2.242"},{"v":1.5513293080464003,"d":"1.551"},{"v":21,"d":"21.0"},66,{"v":13.86,"d":"13.9"},0.17,0.62]
["Concentrado","Calcário calcítico",100,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"},{"v":37.7,"d":"37.70"},0.21,0.15]
["Concentrado","Mistura mineral (6% de P)",100,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"},{"v":7.7,"d":"7.70"},{"v":6,"d":"6.00"}]
["Concentrado","Rumensin",100,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.00"},{"v":8,"d":"8.000"}]
["Concentrado","Sal branco",100,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["Concentrado","Soja, casca",88,{"v":78,"d":"78.0"},{"v":2.8236000000000003,"d":"2.824"},{"v":1.884470577406688,"d":"1.884"},{"v":1.2469027649807232,"d":"1.247"},{"v":12,"d":"12.0"},50,{"v":6,"d":"6.0"},{"v":0.5,"d":"0.50"},0.17]
["Concentrado","Branco",1,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":8,"d":"8.000"}]
["Concentrado","Branco",1,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},0,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":8,"d":"8.000"}]
[null,"ANEXO A"]
[{"$nulls":5},"Consumo de matéria seca, % do peso vivo"]
[null,"Qualidade                                                   da dieta","% NDT","% PB","Fator calculo PDR","Vaca                                           parida","Vaca                                        seca","Novilha 1/3 final","Bezerro                                      até 200 kg","Novilho                                 200-350 kg","Boi engorda                                     zebu","Boi engorda                             mestiço"]
[null,"Pastagem ruim","50-54","4-6",10.5,{"v":2,"d":"2.00"},{"v":1.8,"d":"1.80"},{"v":1.8,"d":"1.80"},{"v":1.6,"d":"1.60"},{"v":1.8,"d":"1.80"},1.85,{"v":1.8,"d":"1.80"}]
[null,"Pastagem média","55-58","7-9",{"v":11,"d":"11.0"},{"v":2.2,"d":"2.20"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":1.9,"d":"1.90"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"}]
[null,"Pastagem boa","59-62","10-12",11.5,{"v":2.4,"d":"2.40"},{"v":2.2,"d":"2.20"},{"v":2.2,"d":"2.20"},{"v":2.2,"d":"2.20"},{"v":2.2,"d":"2.20"},2.15,{"v":2.2,"d":"2.20"}]
[null,"Pastagem muito boa","63-66","13-15",{"v":12,"d":"12.0"},{"v":2.6,"d":"2.60"},{"v":2.4,"d":"2.40"},{"v":2.4,"d":"2.40"},{"v":2.5,"d":"2.50"},{"v":2.4,"d":"2.40"},{"v":2.3,"d":"2.30"},{"v":2.4,"d":"2.40"}]
[null,"Confinamento silagem ruim",null,null,{"v":12,"d":"12.0"},null,{"v":2.2,"d":"2.20"},{"$nulls":3},{"v":2.2,"d":"2.20"},{"v":2.3,"d":"2.30"}]
[null,"Confinamento silagem boa",null,null,12.5,null,{"v":2.4,"d":"2.40"},{"$nulls":3},{"v":2.4,"d":"2.40"},{"v":2.5,"d":"2.50"}]
[null,"Confinamento com cana",null,null,{"v":12,"d":"12.0"},null,{"v":2.2,"d":"2.20"},{"$nulls":3},{"v":2.2,"d":"2.20"},{"v":2.3,"d":"2.30"}]
[]
[null,"PARTE 2 - SUPOSIÇÕES E ESTIMATIVAS"]
["Suposições: ","Peso vivo médio,                                                                           kg",400,"Consumo                                                     matéria seca,                                                  % PV ",null,2,"Consumo concentrado                                                                   matéria natural, kg",null,3,"Volumoso suplementar,                                                                       kg matéria natural",null,null,10]
[]
[null,"PARTE 3 - BALANCEAMENTO DO CONCENTRADO"]
[null,"Ingredientes","Concentrado % na matéria natural","kg/cab/dia matéria natural","kg/cab/dia matéria seca","NDT, kg/cab/dia","PB, kg/cab/dia","PDR,  g/cab/dia","Concentrado materia seca, kg","Concentrado matéria seca, %","R$                                                     cab/dia"]
["Volumoso principal","Past. Ruim (Mai/Jun/Jul)",null,{"v":6.813180000000001,"d":"6.813"},{"v":2.7252720000000004,"d":"2.725"},{"v":1.4988996000000003,"d":"1.5"},{"v":177.14268000000004,"d":"177"},{"v":120.4570224,"d":"120"},null,null,{"v":0,"d":"0.000"}]
["Volumoso suplementar","Cana-de-açúcar",null,{"v":10,"d":"10.000"},{"v":2.6,"d":"2.600"},{"v":1.6380000000000001,"d":"1.6"},104,{"v":67.60000000000001,"d":"68"},null,null,{"v":0,"d":"0.000"}]
["Concentrado","Milho, grão",{"v":75.32000000000001,"d":"75.32"},{"v":2.2596000000000003,"d":"2.260"},{"v":1.9884480000000002,"d":"1.988"},{"v":1.6901808000000003,"d":"1.7"},{"v":188.90256000000002,"d":"189"},{"v":85.00615200000001,"d":"85"},{"v":66.28160000000001,"d":"66.282"},{"v":74.34206394070725,"d":"74.342"},{"v":0,"d":"0.000"}]
["Concentrado","Soja, farelo",{"v":17.7,"d":"17.70"},{"v":0.5309999999999999,"d":"0.531"},{"v":0.47789999999999994,"d":"0.478"},{"v":0.39187799999999995,"d":"0.4"},{"v":219.83399999999997,"d":"220"},{"v":142.89209999999997,"d":"143"},{"v":15.93,"d":"15.930"},{"v":17.867237341516596,"d":"17.867"},{"v":0,"d":"0.000"}]
["Concentrado","Uréia + sulfato de amônio*",{"v":3.4,"d":"3.40"},0.102,{"v":0.10097999999999999,"d":"0.101"},{"v":0,"d":"0.0"},{"v":262.54799999999994,"d":"263"},{"v":210.03839999999997,"d":"210"},{"v":3.3659999999999997,"d":"3.366"},{"v":3.7753371557780824,"d":"3.775"},{"v":0,"d":"0.000"}]
["Concentrado","Algodão, caroço",{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,0,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["Concentrado","Calcário calcítico",{"v":1.5,"d":"1.50"},0.045,0.045,{"v":0,"d":"0.0"},0,0,{"v":1.5,"d":"1.500"},{"v":1.6824140622896981,"d":"1.682"},{"v":0.00675,"d":"0.007"}]
["Concentrado","Mistura mineral (6% de P)",{"v":2,"d":"2.00"},{"v":0.06,"d":"0.060"},{"v":0.06,"d":"0.060"},{"v":0,"d":"0.0"},0,0,{"v":2,"d":"2.000"},{"v":2.2432187497195977,"d":"2.243"},{"v":0,"d":"0.000"}]
["Concentrado","Rumensin",0.08,{"v":0.0024,"d":"0.002"},{"v":0.0024,"d":"0.002"},{"v":0,"d":"0.0"},0,0,{"v":0.08,"d":"0.080"},{"v":0.08972874998878391,"d":"0.090"},{"v":0.0192,"d":"0.019"}]
["Concentrado","Sal branco",{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,0,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["Concentrado","Soja, casca",{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,0,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["Concentrado","Branco",{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,0,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["Concentrado","Branco",{"v":0,"d":"0.00"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,0,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"SOMA",{"v":100.00000000000001,"d":"100.0"},{"v":19.813180000000003,"d":"19.8"},{"v":8,"d":"8.0"},{"v":5.218958400000001,"d":"5.2"},{"v":952.42724,"d":"952"},{"v":625.9936743999999,"d":"626"},{"v":89.1576,"d":"89.2"},{"v":100,"d":"100.0"},{"v":0.025949999999999997,"d":"0.03"}]
[]
[null,null,"exigência nutricional",{"$nulls":4},{"v":626.2750080000001,"d":"626"}]
[null,null,"sobra",{"$nulls":4},{"v":-0.28133360000015273,"d":"-0"}]
[]
[null,"PARTE 4 - Teores de NDT e PB da dieta e do concentrado "]
[null,"Concentração energética da dieta",null,null,{"v":65.23698000000002,"d":"65.2"},"% da MS"]
[null,"Concentração energética do concentrado",null,null,{"v":77.84188896964478,"d":"77.8"},"% da MS",null,"% de matéria seca do concentrado",null,null,{"v":89.1576,"d":"89.2"}]
[null,"Proteína bruta da dieta",null,null,{"v":11.9053405,"d":"11.9"},"% da MS"]
[null,"Proteína bruta do concentrado",null,null,{"v":25.097301856487835,"d":"25.1"},"% da MS"]
[]
[]
[null,"PARTE 5 -  Energia Líquida da dieta e consumo de Cálcio e Fósforo",{"$nulls":6},"PARTE 6 - Ganho de peso esperado e                                                                      Exigência de fósforo"]
["Tipo de alimento","Ingredientes","MS       kg/cab/dia","Elm, Mcal/dia","Elg,                                  Mcal/dia","Consumo de  Ca, g/dia","Consumo de   P, g/dia"]
[]
["Volumoso principal","Past. Ruim (Mai/Jun/Jul)",{"v":2.7252720000000004,"d":"2.725"},{"v":3.116342856200006,"d":"3.116"},{"v":1.5908999489219504,"d":"1.591"},{"v":8.175816000000001,"d":"8.2"},{"v":3.5428536000000004,"d":"3.5"}]
["Volumoso suplementar","Cana-de-açúcar",{"v":2.6,"d":"2.600"},{"v":3.669154200237417,"d":"3.669"},{"v":2.1532346021365805,"d":"2.153"},{"v":5.980000000000001,"d":"6.0"},{"v":1.56,"d":"1.6"},null,"Elm, Mcal/dia",{"$nulls":3},{"v":6.542734902164384,"d":"6.54"}]
["Concentrado","Milho, grão",{"v":1.9884480000000002,"d":"1.988"},{"v":4.1654215146590206,"d":"4.165"},{"v":2.8381928157164684,"d":"2.838"},{"v":0.5965344,"d":"0.6"},{"v":5.965344,"d":"6.0"}]
["Concentrado","Soja, farelo",{"v":0.47789999999999994,"d":"0.478"},{"v":0.958366529126773,"d":"0.958"},{"v":0.6456643421701967,"d":"0.646"},{"v":1.9116,"d":"1.9"},{"v":3.393089999999999,"d":"3.4"},null,"Alimento para mantença, kg",{"$nulls":3},{"v":4.395047962730695,"d":"4.40"}]
["Concentrado","Uréia + sulfato de amônio*",{"v":0.10097999999999999,"d":"0.101"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Concentrado","Algodão, caroço",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,"Alimento para ganho peso, kg",{"$nulls":3},{"v":3.604952037269304,"d":"3.60"}]
["Concentrado","Calcário calcítico",0.045,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":16.965,"d":"17.0"},{"v":0.0945,"d":"0.1"}]
["Concentrado","Mistura mineral (6% de P)",{"v":0.06,"d":"0.060"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":4.62,"d":"4.6"},3.6,null,"Elg, Mcal/dia",{"$nulls":3},{"v":3.257070429565953,"d":"3.26"}]
["Concentrado","Rumensin",{"v":0.0024,"d":"0.002"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Concentrado","Sal branco",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,"Ganho de peso em jejum esperado, kg",{"$nulls":3},{"v":0.7351196598382801,"d":"0.735"}]
["Concentrado","Soja, casca",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Concentrado","Branco",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},null,"Fósforo (P) mantença , g/dia",{"$nulls":3},{"v":9.882352941176471,"d":"10"}]
["Concentrado","Branco",{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
[null,"SOMA",{"v":7.999999999999999,"d":"8.000"},{"v":11.909285100223217,"d":"11.909"},{"v":7.227991708945196,"d":"7.228"},{"v":38.2489504,"d":"38"},{"v":18.1557876,"d":"18"},null,"Fósforo (P) para ganho peso, g/dia ",{"$nulls":3},{"v":4.954895257977023,"d":"5"}]
[null,"Elm da dieta (Mcal/kg)",null,{"v":1.4886606375279023,"d":"1.489"}]
[null,"Elg da dieta (Mcal/kg)",null,null,{"v":0.9034989636181496,"d":"0.903"},{"$nulls":3},"Exigência de Fósforo (P) total, g/dia",{"$nulls":3},{"v":15.609398305112492,"d":"16"}]
[]
[{"$nulls":11},"Coeficiente absorção P",{"v":95.05330000000001,"d":"95.1"}]

{"sheet":"Composição ingredientes","index":1,"n_rows":74,"n_cols":14,"rows_kept":74,"merged":[[14,12,14,13]],"flags":["formulas_cached_only"]}
[]
[null,"COMPOSIÇÃO DOS ALIMENTOS"]
[null,"Ingredientes","MS         % "," NDT                % da MS","EM Mcal/ kg MS","Elm Mcal/ kg MS","Elg Mcal/ kg MS"," PB               % da MS","Degr. PB            % da MS","PDR % da MS","Ca               % MS","P                                                    % MS","Preço  R$/kg","Obs"]
[null,"Algodão, caroço",91,{"v":90,"d":"90.0"},3.258,{"v":2.241763787876,"d":"2.242"},{"v":1.5513293080464003,"d":"1.551"},{"v":21,"d":"21.0"},66,{"v":13.86,"d":"13.9"},0.17,0.62]
[null,"Algodão, farelo",91,68.5,{"v":2.4797,"d":"2.480"},{"v":1.5887374333305164,"d":"1.589"},{"v":0.9872822755167903,"d":"0.987"},{"v":31,"d":"31.0"},56,{"v":17.36,"d":"17.4"},0.22,0.76]
[null,"Amendoim, farelo",89,{"v":77,"d":"77.0"},{"v":2.7874,"d":"2.787"},{"v":1.8539316567480517,"d":"1.854"},{"v":1.2204129666802128,"d":"1.220"},{"v":52,"d":"52.0"},65,33.8,0.14,0.79]
[null,"Arroz, farelo desengordurado",90,{"v":60,"d":"60.0"},2.172,{"v":1.312202628704,"d":"1.312"},{"v":0.7383888118656001,"d":"0.738"},{"v":18,"d":"18.0"},61,{"v":10.98,"d":"11.0"},0.12,{"v":1.4,"d":"1.40"}]
[null,"Arroz, farelo integral",89,{"v":67,"d":"67.0"},{"v":2.4254000000000002,"d":"2.425"},{"v":1.5408135300801726,"d":"1.541"},{"v":0.944566059336581,"d":"0.945"},14.5,65,{"v":9.425,"d":"9.4"},0.08,1.55]
[null,"Arroz, grão",89,{"v":75,"d":"75.0"},2.715,{"v":1.7924561466874995,"d":"1.792"},{"v":1.166863935675,"d":"1.167"},{"v":8,"d":"8.0"},65,5.2,0.04,0.25]
["volumoso","Aveia, feno",90,{"v":55,"d":"55.0"},{"v":1.9909999999999999,"d":"1.991"},{"v":1.1434979173455,"d":"1.143"},{"v":0.5837582263062,"d":"0.584"},{"v":10,"d":"10.0"},68,6.8,0.32,0.25]
[null,"Aveia, grão",89,{"v":75,"d":"75.0"},2.715,{"v":1.7924561466874995,"d":"1.792"},{"v":1.166863935675,"d":"1.167"},{"v":13,"d":"13.0"},68,{"v":8.84,"d":"8.8"},0.07,0.38]
["volumoso","Bagaço cana hidrolizado",45,{"v":50,"d":"50.0"},{"v":1.81,"d":"1.810"},{"v":0.9698604805000004,"d":"0.970"},{"v":0.4225014402,"d":"0.423"},1.6,20,{"v":0.32,"d":"0.3"},0.04,0.03]
["volumoso","Bagaço cana in natura",50,{"v":33,"d":"33.0"},{"v":1.1946,"d":"1.195"},{"v":0.33756661251462816,"d":"0.338"},{"v":-0.18117975665386044,"d":"-0.181"},1.6,31,{"v":0.496,"d":"0.5"},0.04,0.03]
[null,"Calcário calcítico",100,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"},{"v":37.7,"d":"37.70"},0.21]
[null,"Cama de frango",82,{"v":57,"d":"57.0"},{"v":2.0634,"d":"2.063"},{"v":1.2115508088210927,"d":"1.212"},{"v":0.6463812974012693,"d":"0.646"},{"v":21,"d":"21.0"},75,{"v":15.75,"d":"15.8"},{"v":3.7,"d":"3.70"},{"v":1.7,"d":"1.70"},"uso proibido em rações "]
["volumoso","Cana-de-açúcar",26,{"v":63,"d":"63.0"},{"v":2.2806,"d":"2.281"},{"v":1.4112131539374682,"d":"1.411"},{"v":0.8281671546679155,"d":"0.828"},{"v":4,"d":"4.0"},65,2.6,0.23,0.06]
["volumoso","Capim elefante, 60 dias",20,{"v":58,"d":"58.0"},{"v":2.0996,"d":"2.100"},{"v":1.245288762503328,"d":"1.245"},{"v":0.677303942056819,"d":"0.677"},8.5,75,{"v":6.375,"d":"6.4"},{"v":0.6,"d":"0.60"},{"v":0.2,"d":"0.20"}]
[null,"Girassol, farelo",90,{"v":68,"d":"68.0"},{"v":2.4616,"d":"2.462"},{"v":1.5728025377774077,"d":"1.573"},{"v":0.9730986579981313,"d":"0.973"},{"v":46,"d":"46.0"},70,32.2,0.45,0.96]
[null,"Levedura seca",89,{"v":80,"d":"80.0"},{"v":2.8960000000000004,"d":"2.896"},{"v":1.9451656929280006,"d":"1.945"},{"v":1.2993302894592005,"d":"1.299"},{"v":34,"d":"34.0"},53,{"v":18.02,"d":"18.0"},0.12,0.83]
[null,"Levedura úmida",23,{"v":80,"d":"80.0"},{"v":2.8960000000000004,"d":"2.896"},{"v":1.9451656929280006,"d":"1.945"},{"v":1.2993302894592005,"d":"1.299"},{"v":34,"d":"34.0"},58,{"v":19.72,"d":"19.7"},0.12,0.83]
[null,"Mandioca, raspa",90,{"v":80,"d":"80.0"},{"v":2.8960000000000004,"d":"2.896"},{"v":1.9451656929280006,"d":"1.945"},{"v":1.2993302894592005,"d":"1.299"},{"v":4,"d":"4.0"},55,2.2,0.15,0.07]
[null,"Melaço",74,{"v":75,"d":"75.0"},2.715,{"v":1.7924561466874995,"d":"1.792"},{"v":1.166863935675,"d":"1.167"},5.5,85,{"v":4.675,"d":"4.7"},{"v":1,"d":"1.00"},0.11]
[null,"Melaço em pó",94,{"v":72,"d":"72.0"},{"v":2.6064,"d":"2.606"},{"v":1.6992038808965124,"d":"1.699"},{"v":1.0850647163117566,"d":"1.085"},{"v":10,"d":"10.0"},80,{"v":8,"d":"8.0"},{"v":1.1,"d":"1.10"},0.15]
[null,"Milho, farelo de gérmen",88,{"v":86,"d":"86.0"},{"v":3.1132,"d":"3.113"},{"v":2.1244044115656635,"d":"2.124"},{"v":1.4524463027700096,"d":"1.452"},{"v":60,"d":"60.0"},42,25.2,0.07,{"v":0.5,"d":"0.50"}]
[null,"Milho, gérmen (Refinazil)",88,{"v":75,"d":"75.0"},2.715,{"v":1.7924561466874995,"d":"1.792"},{"v":1.166863935675,"d":"1.167"},{"v":23,"d":"23.0"},70,16.1,{"v":0.3,"d":"0.30"},{"v":0.7,"d":"0.70"}]
[null,"Milho, grão",88,{"v":85,"d":"85.0"},3.077,{"v":2.0948103820964996,"d":"2.095"},{"v":1.4273407279025996,"d":"1.427"},9.5,45,{"v":4.275,"d":"4.3"},0.03,{"v":0.3,"d":"0.30"}]
[null,"Milho, resíduo (quebradinho)",87,{"v":82,"d":"82.0"},{"v":2.9684000000000004,"d":"2.968"},{"v":2.0053704313177927,"d":"2.005"},{"v":1.3510448674831488,"d":"1.351"},{"v":10,"d":"10.0"},46,4.6,0.03,{"v":0.3,"d":"0.30"}]
[null,"Milho, rolão (MDPS)",88,{"v":77,"d":"77.0"},{"v":2.7874,"d":"2.787"},{"v":1.8539316567480517,"d":"1.854"},{"v":1.2204129666802128,"d":"1.220"},8.5,50,{"v":4.25,"d":"4.3"},0.06,0.23]
["volumoso","Milho, silagem",33,{"v":63,"d":"63.0"},{"v":2.2806,"d":"2.281"},{"v":1.4112131539374682,"d":"1.411"},{"v":0.8281671546679155,"d":"0.828"},7.2,75,5.4,0.31,0.22]
[null,"Mistura mineral (4% de P)",100,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"},{"v":5.1,"d":"5.10"},{"v":4,"d":"4.00"}]
[null,"Mistura mineral (6% de P)",100,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"},{"v":7.7,"d":"7.70"},{"v":6,"d":"6.00"}]
[null,"Mistura mineral (8% de P)",100,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.0"},0,{"v":0,"d":"0.0"},{"v":10.2,"d":"10.20"},{"v":8,"d":"8.00"}]
["volumoso","Pastagem boa (Nov/Dez/Jan)",20,{"v":63,"d":"63.0"},{"v":2.2806,"d":"2.281"},{"v":1.4112131539374682,"d":"1.411"},{"v":0.8281671546679155,"d":"0.828"},11.5,70,{"v":8.05,"d":"8.1"},{"v":0.3,"d":"0.30"},0.17]
["volumoso","Past. Média (Fev/Mar/Abr)",30,{"v":59,"d":"59.0"},{"v":2.1358,"d":"2.136"},{"v":1.278838372934476,"d":"1.279"},{"v":0.7079719560594868,"d":"0.708"},{"v":9,"d":"9.0"},70,6.3,{"v":0.3,"d":"0.30"},0.15]
["volumoso","Past. Ruim (Mai/Jun/Jul)",40,{"v":55,"d":"55.0"},{"v":1.9909999999999999,"d":"1.991"},{"v":1.1434979173455,"d":"1.143"},{"v":0.5837582263062,"d":"0.584"},6.5,68,{"v":4.42,"d":"4.4"},{"v":0.3,"d":"0.30"},0.13]
["volumoso","Past. Mui ruim (Ago/Set/Out)",50,{"v":51,"d":"51.0"},{"v":1.8462,"d":"1.846"},{"v":1.0050005174448438,"d":"1.005"},{"v":0.4553037282029617,"d":"0.455"},{"v":4,"d":"4.0"},65,2.6,{"v":0.3,"d":"0.30"},0.11]
[null,"Polpa cítrica",91,{"v":79,"d":"79.0"},{"v":2.8598000000000003,"d":"2.860"},{"v":1.9148809266035167,"d":"1.915"},{"v":1.273207381754943,"d":"1.273"},6.5,65,{"v":4.225,"d":"4.2"},{"v":1.9,"d":"1.90"},0.12]
[null,"Polpa cítrica úmida",28,{"v":81,"d":"81.0"},{"v":2.9322000000000004,"d":"2.932"},{"v":1.9753278649696044,"d":"1.975"},{"v":1.3252749605498253,"d":"1.325"},{"v":7,"d":"7.0"},65,{"v":4.55,"d":"4.6"},{"v":1.9,"d":"1.90"},0.13]
[null,"Resíduo cervejaria",21,{"v":66,"d":"66.0"},{"v":2.3892,"d":"2.389"},{"v":1.5086630764370246,"d":"1.509"},{"v":0.9158100821291137,"d":"0.916"},{"v":23,"d":"23.0"},52,{"v":11.96,"d":"12.0"},0.29,0.54]
[null,"Soja, casca",88,{"v":78,"d":"78.0"},{"v":2.8236000000000003,"d":"2.824"},{"v":1.884470577406688,"d":"1.884"},{"v":1.2469027649807232,"d":"1.247"},{"v":12,"d":"12.0"},50,{"v":6,"d":"6.0"},{"v":0.5,"d":"0.50"},0.17]
[null,"Soja, farelo",90,{"v":82,"d":"82.0"},{"v":2.9684000000000004,"d":"2.968"},{"v":2.0053704313177927,"d":"2.005"},{"v":1.3510448674831488,"d":"1.351"},{"v":46,"d":"46.0"},65,29.9,{"v":0.4,"d":"0.40"},0.71]
[null,"Soja, grão",89,{"v":91,"d":"91.0"},{"v":3.2942,"d":"3.294"},{"v":2.270864389509324,"d":"2.271"},{"v":1.575682598098834,"d":"1.576"},{"v":38,"d":"38.0"},70,26.6,0.25,0.55]
[null,"Sorgo, grão",88,{"v":82,"d":"82.0"},{"v":2.9684000000000004,"d":"2.968"},{"v":2.0053704313177927,"d":"2.005"},{"v":1.3510448674831488,"d":"1.351"},10.6,50,5.3,0.03,{"v":0.3,"d":"0.30"}]
[null,"Sorgo, silagem",30,{"v":60,"d":"60.0"},2.172,{"v":1.312202628704,"d":"1.312"},{"v":0.7383888118656001,"d":"0.738"},{"v":8,"d":"8.0"},75,{"v":6,"d":"6.0"},{"v":0.4,"d":"0.40"},0.22]
[null,"Sulfato de amônio",99,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":125,"d":"125.0"},80,{"v":100,"d":"100.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Trigo, farelo",88,{"v":71,"d":"71.0"},{"v":2.5702,"d":"2.570"},{"v":1.6678307710882838,"d":"1.668"},{"v":1.057390907270578,"d":"1.057"},{"v":17,"d":"17.0"},73,{"v":12.41,"d":"12.4"},0.13,{"v":1.2,"d":"1.20"}]
[null,"Triguilho",89,{"v":79,"d":"79.0"},{"v":2.8598000000000003,"d":"2.860"},{"v":1.9148809266035167,"d":"1.915"},{"v":1.273207381754943,"d":"1.273"},{"v":17,"d":"17.0"},73,{"v":12.41,"d":"12.4"},0.07,0.38]
[null,"Triticale",88,{"v":84,"d":"84.0"},{"v":3.0408,"d":"3.041"},{"v":2.065108701291776,"d":"2.065"},{"v":1.4020742787032066,"d":"1.402"},17.5,71,{"v":12.425,"d":"12.4"},0.06,0.33]
["volumoso","Tyfton, feno médio",87,{"v":56,"d":"56.0"},{"v":2.0272,"d":"2.027"},{"v":1.1776215232983036,"d":"1.178"},{"v":0.6152005496365054,"d":"0.615"},10.6,70,{"v":7.42,"d":"7.4"},{"v":0.4,"d":"0.40"},0.18]
["volumoso","Tyfton, feno bom",87,{"v":52,"d":"52.0"},{"v":1.8824,"d":"1.882"},{"v":1.0399312910123526,"d":"1.040"},{"v":0.4878270783587326,"d":"0.488"},7.8,70,{"v":5.46,"d":"5.5"},{"v":0.4,"d":"0.40"},{"v":0.2,"d":"0.20"}]
[null,"Uréia, (45% de nitrogênio)",99,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":281,"d":"281.0"},80,224.8,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Uréia + sulfato de amônio*",99,{"v":0,"d":"0.0"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":260,"d":"260.0"},80,{"v":208,"d":"208.0"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,"* 85% de uréia + 15% de sulfato de amônio"]
[]
[null,"OUTROS ALIMENTOS"]
[null,"Ingredientes","MS         % "," NDT                % da MS","EM Mcal/ kg MS","Elm Mcal/ kg MS","Elg Mcal/ kg MS"," PB               % da MS","Degr. PB            % da MS","PDR % da MS","Ca               % MS","P                                                    % MS","Preço  R$/kg","Obs"]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]
[{"$nulls":4},{"v":0,"d":"0.000"},{"v":-1.12,"d":"-1.120"},{"v":-1.65,"d":"-1.650"},null,null,{"v":0,"d":"0.0"}]

{"sheet":"Ajuda","index":2,"n_rows":86,"n_cols":9,"rows_kept":86,"merged":[[0,4,1,9],[27,8,29,12]],"flags":["formulas_cached_only"]}
[{"$nulls":4},"AJUDA"]
[]
[]
[null,"COMENTÁRIO INICIAL: "]
[null,"O presente arquivo é composto de três planilhas (orelhas): \"Balanceamento\", \"Composição ingredientes\" e \"Ajuda\" "]
[null,"Os cálculos foram feitos procurando-se ajustar as necessidades de PDR  às do NDT consumido"]
[null,"(na proporção de 10,5 a 12,5% de PDR em relação ao NDT) (linha 30 da planilha Balanceamento). "]
[]
[null,"ATENÇÃO ÀS CORES DAS CÉLULAS"]
[]
[null,null,"Contém fórmulas. Não digitar nada nelas."]
[]
[null,null,"Células marginais. Não digitar nada nelas."]
[]
[null,null,"Contém fórmula. Mudar o valor do fator para cálculo de PDR da fórmula se for o caso."]
[]
[null,null,"Podem ser \"digitadas\" (não contém fórmulas)"]
[]
[null,null,"Podem ser \"digitadas\" (não contém fórmulas)"]
[]
[null,"PASSOS A SEREM SEGUIDOS:"]
[]
[null,"Planilha Composição ingredientes:"]
[null,"É apresentado uma relação dos ingredientes mais comuns com suas composições."]
[null,"Linhas ","Informações existentes podem ser substituídas por outras mais recentes ou mais precisas."]
[null,"3 a 51","Inserir linhas com novos ingredientes caso haja informações sobre os mesmos."]
[null,"Colunas"]
[null,"D E F I","Não digitar (contém fórmulas)",{"$nulls":5},"Observação: a impressão das planilhas está configurada para papel tamnho A4, orientação \"paisagem\" "]
[]
[]
[null,"Planilha Balanceamento:"]
[null,"1 - Compor a dieta. (PARTE 1 - COMPOSIÇÃO DOS INGREDIENTES DA DIETA)"]
[null,"Linhas","Copiar e colar os ingredientes da planilha \"Composição ingredientes\", ou digitar diretamente nas"]
[null,"3 a 15"," células de  cor marrom. Substituir ingredientes que não serão utilizados ou utilizar as linhas \"Branco\"."]
[null,null,"Sempre colocar os volumosos nas linhas 3 e 4"]
[]
[null,"Colunas"]
[null," E F G J","Não digitar (contém fórmulas)"]
[]
[null,"2 - Definir a PARTE 2 - SUPOSIÇÕES E ESTIMATIVAS"]
[null,"Linha ","Definir o peso vivo médio (kg), as estimativas de consumo total  de matéria seca (% do peso vivo)"]
[null,28," e a quantidade de concentrado e de volumoso suplementar a serem fornecidas em kg/cabeça/dia."]
[null,null,"Sugestões de consumo total de MS são apresentadas no ANEXO A. Outras informações podem obtidas "]
[null,null,"da pesquisa ou experiência própria."]
[]
[null,"3 - Como fazer a PARTE 3 - BALANCEAMENTO DO CONCENTRADO"]
[null,"Células","Por tentativa, digitar a percentagem de cada componente até que a sobra de PDR  (Linha 49) "]
[null,"C36 a C45","seja igual a zero. "]
[null,null,"O consumo de matéria natural (kg/cabeça/dia) de cada um dos ingredientes é mostrado na coluna D."]
[null,null,"Começar ajustando os ingredientes que apresentem mais limitações como aditivos, uréia, mistura mineral "]
[null,null,"carbonato de cálcio e fonte de enxofre deixando-se outras fontes de energia e de proteína para o final."]
[null,null,"Como pode ser observado na célula C35, o ingrediente que estiver nesta posição, "]
[null,null,"no caso o milho, sai por diferença (fórmula)."]
[]
[null,"Linha","Conforme pode ser observado no ANEXO A, os fatores para cálculo da proteína degradável "]
[null,48,"no rúmen (PDR) devem variar de 10,5 a 12,5% do consumo de NDT, em função do tipo de dieta. "]
[null,null,"Um destes valores deve ser utilizado na fórmula da célula H48. (Em caso de dúvida manter o valor existente)"]
[]
[null,"PARTE 4 - TEORES DE NDT E PB DA DIETA E DO CONCENTRADO "]
[null,"Os valores deste ítem são para ser lidos e analisados."]
[]
[null,"PARTE 5 -  ENERGIA LIQUIDA DA DIETA E CONSUMO DE CALCIO E FOSFORO"]
[null,"Neste ítem deve ser avaliado particularmente o consumo de fósforo (P) da célula G74, que deve ser comparado "]
[null,"com a exigência do elemento mostrado na PARTE 6. Caso seja necessário alterar a quantidade de mistura mineral "]
[null,"do concentrado e/ou o teor de P da mistura mineral."]
[null,"Observar também a relação Ca:P. É recomendável que a mesma seja de cerca de 2:1"]
[]
[null,"PARTE 6 - GANHO ESPERADO E EXIGENCIA DE FÓSFORO"]
[null,"Os dados de ganho de peso esperado e a exigência de fósforo podem ser analisados."]
[null,"O ganho de peso pode ser ajustado variando-se a relação concentrado volumoso."]
[]
[null,"7 - Glossário de abreviaturas"]
[null,"Ca               ","Cálcio"]
[null,"Degr.PB   ","Degradabilidade da proteína bruta (no rúmen)"]
[null,"Elg ","Energia líquida de ganho de peso"]
[null,"Elm ","Energia líquida de mantença"]
[null,"EM ","Energia Metabolizável"]
[null,"Mcal","Megacalorias"]
[null,"MS","Matéria seca"]
[null," NDT","Nutrientes digestíveis totais"]
[null,"P        ","Fósforo"]
[null,"PDR   ","Proteína degradável no rúmen"]
[null," PB   ","Proteína bruta"]
[]
[]
[null,"Planilha desenvolvida por José Marques da Silva Eng.-Agr., M.Sc., CREA No 11.938/D-Visto 1.302/MS"]

{"sheet":"Plan6","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"flags":["formulas_cached_only"]}
["Planilha desenvolvida por José Marques da Silva Eng.-Agr., M.Sc., CREA No 11.938/D-Visto 1.302/MS"]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

{"sheet":"Plan2","index":37,"n_rows":18,"n_cols":9,"rows_kept":18,"flags":["formulas_cached_only"]}
["RESUMO DOS RESULTADOS"]
[]
["Estatística de regressão"]
["R múltiplo",0.98046860292346]
["R-Quadrado",0.9613186813186815]
["R-quadrado ajustado",0.9516483516483518]
["Erro padrão",0.3236694374850745]
["Observações",6]
[]
["ANOVA"]
[null,"gl","SQ","MQ","F","F de significação"]
["Regressão",1,10.414285714285716,10.414285714285716,99.40909090909115,0.0005684878331376989]
["Resíduo",4,0.4190476190476181,0.10476190476190453]
["Total",5,10.833333333333334]
[]
[null,"Coeficientes","Erro padrão","Stat t","valor-P","95% inferiores","95% superiores","Inferior 95,0%","Superior 95,0%"]
["Interseção",13.84761904761905,0.5199860455130925,26.63075128094065,1.1818056689439258e-05,12.403903346503217,15.291334748734883,12.403903346503217,15.291334748734883]
["Variável X 1",-0.015428571428571437,0.0015474358865973233,-9.970410769325973,0.0005684878331376969,-0.019724951120349922,-0.011132191736792951,-0.019724951120349922,-0.011132191736792951]

{"sheet":"Plan3","index":38,"n_rows":18,"n_cols":9,"rows_kept":18,"flags":["formulas_cached_only"]}
["RESUMO DOS RESULTADOS"]
[]
["Estatística de regressão"]
["R múltiplo",0.992160933792905]
["R-Quadrado",0.9843833185448092]
["R-quadrado ajustado",0.9804791481810116]
["Erro padrão",0.3236694374850752]
["Observações",6]
[]
["ANOVA"]
[null,"gl","SQ","MQ","F","F de significação"]
["Regressão",1,26.414285714285715,26.414285714285715,252.136363636363,9.193557942313361e-05]
["Resíduo",4,0.4190476190476201,0.10476190476190503]
["Total",5,26.833333333333336]
[]
[null,"Coeficientes","Erro padrão","Stat t","valor-P","95% inferiores","95% superiores","Inferior 95,0%","Superior 95,0%"]
["Interseção",-0.152380952380942,0.5199860455130936,-0.29304815714925747,0.7840594452281191,-1.5960966534967775,1.2913347487348934,-1.5960966534967775,1.2913347487348934]
["Variável X 1",0.02457142857142854,0.001547435886597327,15.878802336333889,9.193557942313396e-05,0.020275048879650044,0.028867808263207034,0.020275048879650044,0.028867808263207034]

{"sheet":"Plan41","index":39,"n_rows":18,"n_cols":9,"rows_kept":18,"flags":["formulas_cached_only"]}
["RESUMO DOS RESULTADOS"]
[]
["Estatística de regressão"]
["R múltiplo",0.9781800942313535]
["R-Quadrado",0.9568362967504598]
["R-quadrado ajustado",0.9460453709380747]
["Erro padrão",0.6473388749701499]
["Observações",6]
[]
["ANOVA"]
[null,"gl","SQ","MQ","F","F de significação"]
["Regressão",1,37.15714285714286,37.15714285714286,88.67045454545449,0.000708968112582122]
["Resíduo",4,1.6761904761904773,0.41904761904761934]
["Total",5,38.833333333333336]
[]
[null,"Coeficientes","Erro padrão","Stat t","valor-P","95% inferiores","95% superiores","Inferior 95,0%","Superior 95,0%"]
["Interseção",-1.304761904761886,1.0399720910261863,-1.254612422795327,0.277926640360467,-4.192193306993554,1.5826694974697824,-4.192193306993554,1.5826694974697824]
["Variável X 1",0.02914285714285709,0.003094871773194651,9.416499059918937,0.0007089681125821263,0.020550097759300105,0.03773561652641407,0.020550097759300105,0.03773561652641407]

{"sheet":"Plan42","index":40,"n_rows":18,"n_cols":9,"rows_kept":18,"flags":["formulas_cached_only"]}
["RESUMO DOS RESULTADOS"]
[]
["Estatística de regressão"]
["R múltiplo",0.9850843349661501]
["R-Quadrado",0.9703911469957022]
["R-quadrado ajustado",0.9629889337446278]
["Erro padrão",0.013427457317714078]
["Observações",6]
[]
["ANOVA"]
[null,"gl","SQ","MQ","F","F de significação"]
["Regressão",1,0.023635935396810026,0.023635935396810026,131.09472992484362,0.0003320563983976426]
["Resíduo",4,0.0007211864400761333,0.00018029661001903332]
["Total",5,0.02435712183688616]
[]
[null,"Coeficientes","Erro padrão","Stat t","valor-P","95% inferiores","95% superiores","Inferior 95,0%","Superior 95,0%"]
["Interseção",0.6565332781551908,0.021571670424569967,30.434976301483097,6.942887519585945e-06,0.5966405953419103,0.7164259609684713,0.5966405953419103,0.7164259609684713]
["Variável X 1",0.0007350169739040674,6.419552454699328e-05,11.449660690380533,0.00033205639839763493,0.0005567812548312419,0.0009132526929768929,0.0005567812548312419,0.0009132526929768929]

{"sheet":"Plan40","index":41,"n_rows":21,"n_cols":16,"rows_kept":21,"flags":["formulas_cached_only"]}
["x","y"]
[200,11,{"v":10.761619999999999,"d":"10.8"},{"v":4.9411764705882355,"d":"4.9"},{"v":5,"d":"5.0"},null,5,4.76182,null,5,4.52384]
[250,10,{"v":9.99012,"d":"10.0"},{"v":6.176470588235294,"d":"6.2"},{"v":6,"d":"6.0"},null,6,5.9903699999999995,null,6,5.980989999999999]
[300,9,{"v":9.21862,"d":"9.2"},{"v":7.411764705882354,"d":"7.4"},{"v":7,"d":"7.0"},null,7,7.21892,null,7,7.438139999999999]
[350,8,{"v":8.447119999999998,"d":"8.4"},{"v":8.647058823529413,"d":"8.6"},{"v":8,"d":"8.0"},null,8,8.44747,null,8,8.89529]
[400,8,{"v":7.675619999999999,"d":"7.7"},{"v":9.882352941176471,"d":"9.9"},{"v":9,"d":"9.0"},null,10,9.67602,null,11,10.35244]
[450,7,{"v":6.90412,"d":"6.9"},{"v":11.11764705882353,"d":"11.1"},{"v":10,"d":"10.0"},null,11,10.904569999999998,null,12,11.80959]
[]
[0.5,1,1.5,200,{"v":3.8264615640795103,"d":"3.83"},{"v":7.652923128159021,"d":"7.65"},{"v":11.479384692238531,"d":"11.48"},null,6,11,16,0.6377435940132518,0.6957202843780927,0.7174615432649082]
[0.5,1,1.5,250,{"v":3.6718944760752685,"d":"3.67"},{"v":7.343788952150537,"d":"7.34"},{"v":11.015683428225806,"d":"11.02"},null,5,10,15,0.7343788952150537,0.7343788952150537,0.7343788952150537]
[0.5,1,1.5,300,{"v":3.5511169386548573,"d":"3.55"},{"v":7.102233877309715,"d":"7.10"},{"v":10.653350815964572,"d":"10.65"},null,5,9,13,0.7102233877309715,0.7891370974788572,0.8194885243049671]
[0.5,1,1.5,350,{"v":3.4527132883967577,"d":"3.45"},{"v":6.9054265767935155,"d":"6.91"},{"v":10.358139865190273,"d":"10.36"},null,4,8,12,0.8631783220991894,0.8631783220991894,0.8631783220991894]
[0.5,1,1.5,400,{"v":3.3701283809135627,"d":"3.37"},{"v":6.740256761827125,"d":"6.74"},{"v":10.110385142740688,"d":"10.11"},null,4,8,11,0.8425320952283907,0.8425320952283907,0.9191259220673352]
[0.5,1,1.5,450,{"v":3.299270086640647,"d":"3.30"},{"v":6.598540173281294,"d":"6.60"},{"v":9.897810259921942,"d":"9.90"},null,4,7,10,0.8248175216601618,0.942648596183042,0.9897810259921942]
[{"$nulls":14},"y","x"]
[200,5,{"v":3.8264615640795103,"d":"3.83"},{"v":7.652923128159021,"d":"7.65"},{"v":11.479384692238531,"d":"11.48"},{"v":8.82646156407951,"d":"8.83"},{"v":12.65292312815902,"d":"12.65"},{"v":16.479384692238533,"d":"16.48"},11,16,21,0.802405596734501,0.7908076955099388,0.7847326043923111,0.7926486322122503,200]
[250,6,{"v":3.6718944760752685,"d":"3.67"},{"v":7.343788952150537,"d":"7.34"},{"v":11.015683428225806,"d":"11.02"},{"v":9.671894476075268,"d":"9.67"},{"v":13.343788952150536,"d":"13.34"},{"v":17.015683428225806,"d":"17.02"},11,16,21,0.8792631341886608,0.8339868095094085,0.8102706394393241,0.8411735277124645,250]
[300,7,{"v":3.5511169386548573,"d":"3.55"},{"v":7.102233877309715,"d":"7.10"},{"v":10.653350815964572,"d":"10.65"},{"v":10.551116938654857,"d":"10.55"},{"v":14.102233877309715,"d":"14.10"},{"v":17.653350815964572,"d":"17.65"},12,16,20,0.8792597448879048,0.8813896173318572,0.8826675407982286,0.8811056343393302,300]
[350,8,{"v":3.4527132883967577,"d":"3.45"},{"v":6.9054265767935155,"d":"6.91"},{"v":10.358139865190273,"d":"10.36"},{"v":11.452713288396758,"d":"11.45"},{"v":14.905426576793516,"d":"14.91"},{"v":18.358139865190275,"d":"18.36"},12,16,20,0.9543927740330632,0.9315891610495948,0.9179069932595137,0.9346296427807239,350]
[400,10,{"v":3.3701283809135627,"d":"3.37"},{"v":6.740256761827125,"d":"6.74"},{"v":10.110385142740688,"d":"10.11"},{"v":13.370128380913563,"d":"13.37"},{"v":16.740256761827126,"d":"16.74"},{"v":20.11038514274069,"d":"20.11"},14,18,21,0.9550091700652545,0.9300142645459515,0.9576373877495566,0.9475536074535875,400]
[450,11,{"v":3.299270086640647,"d":"3.30"},{"v":6.598540173281294,"d":"6.60"},{"v":9.897810259921942,"d":"9.90"},{"v":14.299270086640647,"d":"14.30"},{"v":17.598540173281293,"d":"17.60"},{"v":20.89781025992194,"d":"20.90"},15,18,21,0.9532846724427098,0.9776966762934052,0.9951338219010447,0.9753717235457199,450]