{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["1a Fase","2a Fase","Amost Aleatoria Simples","Amostragem Dupla"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"1a Fase","index":0,"n_rows":46,"n_cols":3,"rows_kept":46,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["ponto","area.basal","(x_1j – mu_hat_x1)^2"]
["01-2",28,8.090864197530868]
["01-4",56,632.801975308642]
["01-6",48,294.31308641975306]
["02-1",32,1.3353086419753073]
["02-3",24,46.84641975308643]
["02-5",26,23.468641975308646]
["02-7",26,23.468641975308646]
["03-1",48,294.31308641975306]
["03-3",32,1.3353086419753073]
["03-5",44,173.06864197530862]
["03-7",40,83.82419753086418]
["04-1",32,1.3353086419753073]
["04-3",56,632.801975308642]
["04-5",28,8.090864197530868]
["04-7",76,2039.0241975308638]
["05-2",22,78.2241975308642]
["05-4",20,117.60197530864198]
["05-6",14,283.73530864197534]
["05-8",18,164.97975308641978]
["08-1",56,632.801975308642]
["08-3",28,8.090864197530868]
["09-2",22,78.2241975308642]
["09-4",24,46.84641975308643]
["10-2",28,8.090864197530868]
["10-4",28,8.090864197530868]
["10-6",32,1.3353086419753073]
["11-1",24,46.84641975308643]
["11-3",30,0.7130864197530874]
["11-5",26,23.468641975308646]
["12-1",22,78.2241975308642]
["12-3",28,8.090864197530868]
["12-5",30,0.7130864197530874]
["13-1",28,8.090864197530868]
["14-1",40,83.82419753086418]
["14-4",20,117.60197530864198]
["15-1",24,46.84641975308643]
["15-3",26,23.468641975308646]
["16-1",30,0.7130864197530874]
["16-3",34,9.957530864197528]
["17-2",24,46.84641975308643]
["18-2",20,117.60197530864198]
["32-1",14,283.73530864197534]
["33-1",34,9.957530864197528]
["33-3",36,26.579753086419746]
["34-2",10,434.49086419753087]

{"sheet":"2a Fase","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["ponto","area.basal","n.arvores","volume","mdap","mh ",null,"(y_i – mu_hat_y)^2","(x_2i – mu_hat_x2) (y_i – mu_hat_y)"]
["02-7",26,1329.18,298.15,15.71,25.51,null,31.124001234567523,3.7192592592592435]
["04-3",56,2839.44,649.91,15.66,25.42,null,127691.08151234564,10958.392592592592]
["05-6",14,1043.4,147.8,12.87,22.97,null,20958.67461234568,1640.7392592592591]
["09-4",24,1609.79,266.81,13.28,23.2,null,663.6348456790128,34.34814814814813]
["10-4",28,1409.22,329.56,15.54,25.24,null,1368.1779012345673,98.63703703703706]
["12-1",22,1431.74,244.55,13.59,23.53,null,2306.027112345679,160.0703703703703]
["14-4",20,1050.53,233.2,15.2,24.95,null,3524.928834567904,316.64592592592595]
["17-2",24,954.65,294.37,17.78,27.16,null,3.2360012345678775,-2.398518518518508]
["32-1",14,604.82,168.79,17,26.53,null,15321.763467901239,1402.8525925925926]

{"sheet":"Amost Aleatoria Simples","index":2,"n_rows":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Amostragem Dupla em Inventário com Pontos de Bitterlich"]
["Correção para População Finita é Nula ",null,"N = infinito"]
[]
[]
["1a. Fase: Variável Auxiliar: X =  área basal"]
[]
[]
[]
[]
[]
["2a. Fase: Variável de Interesse: Y = volume"]
["Tamanho da amostra","n_2 =",9]
["Médias amostrais","mu_hat_x2 =",25.333333333333332,"m2/ha"]
[null,"mu_hat_y =",292.5711111111111,"m3/ha"]
["Variâncias populacionais","s2_y =",21483.581036111103,"(m3/ha)^2"]
[]
[]
["Estimadores"]
[]
["Média da Var. De Intresse","mu_hat_y =",232.11999999999998,"m3/ha"]
["Variância da estimativa","Var( mu_hat_y ) =",2387.0645595679002,"(m3/ha)^2"]
[]
["Erro Amostral Aproximado"]
["Estatística t","t = ",2.306004135204167]
["Erro Amostral",null,112.66581540721242,"m3/ha"]
["Erro Amostral %",null,48.53774573807188,"%"]
[]
[]
["Tamanho de Amostra para Erroa Amostral Desejado"]
[]
["Erro Amostral  Desejado %","E_% = ",13]
[]
[null,"Iteração","t","n*"]
[null,1,2.2009851600916392,615]
[null,2,1.963835116331508,490]
[null,3,1.9648270804771373,490]
[null,4,1.9648270804771373,490]

{"sheet":"Amostragem Dupla","index":3,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Amostragem Dupla em Inventário com Pontos de Bitterlich"]
["Correção para População Finita é Nula ",null,"N = infinito"]
[]
[]
["1a. Fase: Variável Auxiliar: X =  área basal"]
["Tamanho da amostra","n_1 =",45]
["Média amostral","mu_hat_x1 =",30.844444444444445,"m2/ha"]
["Variância populacional","s2_x1 =",160.45252525252536,"(m2/ha)^2"]
[]
[]
["2a. Fase: Variável de Interesse: Y = volume"]
["Tamanho da amostra","n_2 =",9]
["Médias amostrais","mu_hat_x2 =",25.333333333333332,"m2/ha"]
[null,"mu_hat_y =",292.5711111111111,"m3/ha"]
["Variâncias populacionais","s2_y =",21483.581036111103,"(m3/ha)^2"]
[null,"s2_xy =",1826.6258333333335,"(m2/ha)*(m3/ha)"]
[]
["Estimadores"]
["Estimador de Razão","R =",11.548859649122807,"m3/ha / m2/ha"]
["Média da Var. De Intresse","mu_DR =",356.2181598440546,"m3/ha"]
["Variância da estimativa","Var( mu_DR ) =",539.0335186865882,"(m3/ha)^2"]
[]
["Erro Amostral Aproximado"]
["Estatística t","t = ",2]
["Erro Amostral",null,46.434190794568096,"m3/ha"]
["Erro Amostral %",null,13.035323863021494,"%"]