{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inicial","Questão1","Questão2","Questão3"],"not_rendered":{"charts":5,"images":5,"macros":1,"external_links":0,"defined_names":0,"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":"Inicial","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"N. USP"]
[null,468941]

{"sheet":"Questão1","index":1,"n_rows":38,"n_cols":35,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Área amostral de cada local (m2)",null,null,null,{"$f":"ROUND(AleatorioEntreFixo()*20*MID(Inicial!B18,5,3),0)","v":242}]
[null,null,null,null,null,null,null,null,null,null,"Número de famílias identificadas",null,null,null,{"$f":"ROUND(AleatorioEntreFixo()*4*MID(Inicial!B18,2,2)*1,0)","v":179}]
[null,null,null,null,null,null,null,null,null,null,"No","Espécie","Grupo","ni","PAP med","DAP","Unidades","Da","Dr","AB","Doa","Dor","Fa","Fr","VIa","VIr","H"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ecológico",null,"cm","cm","amostrais","ind/ha","%","m2/ha",null,"%","%","%","%","%"]
[null,null,null,null,null,null,null,null,null,null,1,"Zeyheria tuberculosa","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":80},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":22.000705599784851},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":65},null,null,null,null,null,null,null,null,null,null,null,null,null,"GE","% Fr","% Dr","%Dor","%Vir"]
[null,null,null,null,null,null,null,null,null,null,2,"Rollinia silvatica","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":113},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":196.71579539775848},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":46},null,null,null,null,null,null,null,null,null,null,null,null,null,"P",{"$f":"SUMIFS(X8:X37,M8:M37,\"P\")","v":0},{"$f":"SUMIFS(S8:S37,$M$8:$M$37,\"P\")","v":0},{"$f":"SUMIFS(V8:V37,$M$8:$M$37,\"P\")","v":0},{"$f":"SUMIFS(Z8:Z37,$M$8:$M$37,\"P\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,3,"Bauhinia forficata","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":155},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":169.75571259856224},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":49},null,null,null,null,null,null,null,null,null,null,null,null,null,"SI",{"$f":"SUMIFS($X$8:$X$37,$M$8:$M$37,\"SI\")","v":0},{"$f":"SUMIFS($S$8:$S$37,$M$8:$M$37,\"SI\")","v":0},{"$f":"SUMIFS($V$8:$V$37,$M$8:$M$37,\"SI\")","v":0},{"$f":"SUMIFS($Z$8:$Z$37,$M$8:$M$37,\"SI\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,4,"Zanthoxylum rhoifolium","ST",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":126},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":135.33033832907677},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":58},null,null,null,null,null,null,null,null,null,null,null,null,null,"ST",{"$f":"SUMIFS($X$8:$X$37,$M$8:$M$37,\"ST\")","v":0},{"$f":"SUMIFS($S$8:$S$37,$M$8:$M$37,\"ST\")","v":0},{"$f":"SUMIFS($V$8:$V$37,$M$8:$M$37,\"ST\")","v":0},{"$f":"SUMIFS($Z$8:$Z$37,$M$8:$M$37,\"ST\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,5,"Sparattosperma leucanthum","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":31},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":221.14078745245934},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":44}]
[null,null,null,null,null,null,null,null,null,null,6,"Hortia arborea","ST",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":42},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":407.35022753477097},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":53}]
[null,null,null,null,null,null,null,null,null,null,7,"Vitex sellowiana","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":143},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":109.51130762696266},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":33}]
[null,null,null,null,null,null,null,null,null,null,8,"Croton floribundus","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":106},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":30.738405187924702},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":9}]
[null,null,null,null,null,null,null,null,null,null,9,"Senna macranthera","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":57},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":109.76429417729378},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":52}]
[null,null,null,null,null,null,null,null,null,null,10,"Coutarea hexandra","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":159},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":143.68369534611702},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":37}]
[null,null,null,null,null,null,null,null,null,null,11,"Dictyoloma vandellianum","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":51},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":66.363834341367081},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":38}]
[null,null,null,null,null,null,null,null,null,null,12,"Piptocarpha macropoda","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":33},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":167.76527146498361},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":51}]
[null,null,null,null,null,null,null,null,null,null,13,"Sapium glandulatum","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":41},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":156.14319011569023},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":6}]
[null,null,null,null,null,null,null,null,null,null,14,"Siparuna guianensis","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":133},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":71.738755255937576},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":63}]
[null,null,null,null,null,null,null,null,null,null,15,"Dalbergia nigra","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":164},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":140.87754189968109},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":40}]
[null,null,null,null,null,null,null,null,null,null,16,"Eriotheca candolleana","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":93},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":78.545016497373581},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":4}]
[null,null,null,null,null,null,null,null,null,null,17,"Nectandra rigida","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":172},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":176.30898728966713},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":43}]
[null,null,null,null,null,null,null,null,null,null,18,"Cecropia glaziovii","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":72},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":210.22838845849037},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":47}]
[null,null,null,null,null,null,null,null,null,null,19,"Vismia guianensis","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":79},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":98.389098842938736},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":57}]
[null,null,null,null,null,null,null,null,null,null,20,"Vernonia diffusa ","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":73},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":248.95388424396515},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":61}]
[null,null,null,null,null,null,null,null,null,null,21,"Solanum cernuum","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":32},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":43.41358482837677},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":31}]
[null,null,null,null,null,null,null,null,null,null,22,"Xylopia sericea","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":106},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":112.46441766619682},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":46}]
[null,null,null,null,null,null,null,null,null,null,23,"Senna multijuga","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":68},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":318.69857341051102},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":33}]
[null,null,null,null,null,null,null,null,null,null,24,"Peschiera fuchsiaefolia ","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":82},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":83.945263475179672},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":11}]
[null,null,null,null,null,null,null,null,null,null,25,"Solanum granuloso-leprosum","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":139},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":11.725635727246603},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":51}]
[null,null,null,null,null,null,null,null,null,null,26,"Cupania sp.","ST",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":188},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":124.67092588543892},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":25}]
[null,null,null,null,null,null,null,null,null,null,27,"Myrcia fallax","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":118},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":194.31568562984467},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":14}]
[null,null,null,null,null,null,null,null,null,null,28,"Myrcia sp.","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":39},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":109.05213624238968},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,29,"Nectandra saligna","SI",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":49},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":90.751524716615677},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":40}]
[null,null,null,null,null,null,null,null,null,null,30,"Miconia cinnamomifolia","P",{"$f":"ROUND(MID(Inicial!$B$18,4,2)*2*AleatorioEntreFixo(),0)","v":171},{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5,IF(AND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5>125,AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5<=220),(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/1.5,(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*5)/2))","v":118.55852097272873},null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,2,2)*1,0)","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,{"$f":"ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,1,2)*10,0)","v":177}]

{"sheet":"Questão2","index":2,"n_rows":22,"n_cols":29,"rows_kept":22,"cut":false,"hidden":false,"merged":[[6,8,6,18],[4,21,4,28],[6,24,6,25]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"FA",{"$f":"IF(ISEVEN(Inicial!B18)=TRUE,0.5,0.7)","v":0.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simulado (Pretendido)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ab2=",10,null,"q2=",1.4,null,"b1=",{"$f":"LN($Z$6)/(I11/100-I12/100)","v":-3.3647223662121295}]
[null,null,null,null,null,null,null,null,"Observado",null,null,null,null,null,null,null,null,null,null,null,null,null,"D2 = 50",null,"Corte"]
[null,null,null,null,null,null,null,null,"D","F","F","ln(F)","Fest","Ab","Hf","Vmed","V","Vest","q",null,null,null,"F","V","F","V"]
[null,null,null,null,null,null,null,null,"cm",null,"n/ha",null,"n/ha","m2/ha","m","m3/ha","m3/ha","m3/ha",null,null,"Soma","b0","n/ha","m3/ha","n/ha","m3/ha"]
[null,null,null,null,null,null,null,null,0,{"$f":"FREQUENCY(Questão1!P8:P37,Questão2!I11:I21)","v":0}]
[null,null,null,null,null,null,null,null,20,0,null,null,null,null,{"$f":"IF(L11=0,0,2.8088*EXP(0.0212*I11))","v":0}]
[null,null,null,null,null,null,null,null,30,0,null,null,null,null,{"$f":"IF(L12=0,0,2.8088*EXP(0.0212*I12))","v":0}]
[null,null,null,null,null,null,null,null,40,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,50,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,60,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,70,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,80,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,90,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,100,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,110,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,120,0,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X11:X21)","v":0}]

{"sheet":"Questão3","index":3,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,"Chuva",null,null,null,null,null,null,null,null,"Áreas (ha)"]
[null,null,null,null,null,null,null,null,"Dia","T (h)","P (mm)","i (mm/h)","e","E","R",null,"Fator"]
[null,null,null,null,null,null,null,null,1,0.5,12,null,null,null,null,null,"R"]
[null,null,null,null,null,null,null,null,null,1,6,null,null,null,null,null,"a"]
[null,null,null,null,null,null,null,null,null,1.5,22,null,null,null,null,null,"b"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c"]
[null,null,null,null,null,null,null,null,2,0.5,26,null,null,null,null,null,"M"]
[null,null,null,null,null,null,null,null,null,1,11,null,null,null,null,null,"K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rtotal =",null,null,"S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C"]
[null,null,null,null,null,null,null,null,"Solo",null,null,null,null,null,null,null,"P"]
[null,null,null,null,null,null,null,null,"Areia grossa (%)",null,null,null,{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!B18,3,2)*1<15,15,AleatorioEntreFixo()*MID(Inicial!B18,3,2)*1)","v":87.533892810344696},null,null,null,"A (ton/ha)"]
[null,null,null,null,null,null,null,null,"silte + Areia fina (%)",null,null,null,{"$f":"100-M15-M17","v":2.466107189655304},null,null,null,"Atotal (ton/ano)"]
[null,null,null,null,null,null,null,null,"Argila (%)",null,null,null,{"$f":"IF(AleatorioEntreFixo()*MID(Inicial!B18,6,2)*1<10,10,IF(AleatorioEntreFixo()*MID(Inicial!B18,6,2)*1>30,30))","v":10}]
[null,null,null,null,null,null,null,null,"MO (%)",null,null,null,{"$f":"IF(AleatorioEntreFixo()*RIGHT(Inicial!B18,2)*1/5<=1,3,AleatorioEntreFixo()*RIGHT(Inicial!B18,2)*1/5)","v":5.9960045456886295}]
[null,null,null,null,null,null,null,null,"Permeabilidade",null,null,null,{"$f":"IF(Inicial!B18<=8881066,\"muito baixo\",IF(AND(Inicial!B18>8881066,Inicial!B18<=9172411),\"baixa\",IF(AND(Inicial!B18>9172411,Inicial!B18<=9463756),\"baixa a moderada\",IF(AND(Inicial!B18>9463756,Inicial!B18<=9755101),\"moderada\",IF(AND(Inicial!B18>9755101,Inicial!B18<=10046446),\"alta\",\"muito alta\")))))","v":"muito baixo"}]
[null,null,null,null,null,null,null,null,"declividade (%)",null,null,null,{"$f":"RIGHT(Inicial!B18,3)*1/100","v":9.41}]
[null,null,null,null,null,null,null,null,"Comprimento da encosta (m)",null,null,null,{"$f":"RIGHT(Inicial!B18,3)*1/10","v":94.1}]
[null,null,null,null,null,null,null,null,"Cobertura (%)",null,null,null,{"$f":"IF(ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*10,0)<25,25,IF(ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*10,0)>75,75,ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*10,0)))","v":727}]
[null,null,null,null,null,null,null,null,"Cobertura com gramínea (%)",null,null,null,{"$f":"IF(ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*10,0)<0,,IF(ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*10,0)>95,95,ROUND(AleatorioEntreFixo()*MID(Inicial!$B$18,3,2)*10,0)))","v":755}]