{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Tree biomass"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"Tree biomass","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[20,1,20,4],[2,1,2,5],[21,1,21,4],[3,1,3,5],[4,1,4,5],[23,3,23,4],[19,1,19,4]]}
[]
[]
[null,"Calculator for total tree carbon. Insert tree circumference (cm) in green cell only."]
[null,"Total tree carbon, including roots, is given as kilograms in yellow cell"]
[null,"Ignore all other columns and cells"]
[null,null,"Circumference",null,null,"DBH"]
[null,null,"(at 130cm)",null,null,"(at 130cm)"]
[null,null,0,null,null,{"$f":"C8/PI()","v":0}]
[null,null,null," "]
[]
[]
[null,"Biomass Calculations ","Tree ","Total Carbon","Total Carbon","Carbon Dioxide"]
[null,"Based on Snowdon et al (2000)","Biomass",null,"Inc.Roots","Equivalent"]
[null,null,"(kg)","(kg)","(kg)","(kg)"]
[]
[null,null,{"$f":"EXP(-1.4481+(2.2364*(LN(F8))))","v":{"$error":"#NUM!"}},{"$f":"C16*0.5","v":{"$error":"#NUM!"}},{"$f":"D16+(D16*0.25)","v":{"$error":"#NUM!"}},{"$f":"E16*3.667","v":{"$error":"#NUM!"}}]
[]
[]
[]
[null,"For trees that have more than one trunk or stem"]
[null,"Calculator for equivalent circumference for tree with up to 5 stems"]
[null,"Enter the number given in the blue cell in the green cell above"]
[]
[null,"Stem Circumference cm ","Area","Equivalent circumference"]
[null,0,{"$f":"PI()*(((B25/PI())*0.5)^2)","v":0}]
[null,0,{"$f":"PI()*(((B26/PI())*0.5)^2)","v":0}]
[null,0,{"$f":"PI()*(((B27/PI())*0.5)^2)","v":0}]
[null,0,{"$f":"PI()*(((B28/PI())*0.5)^2)","v":0}]
[null,0,{"$f":"PI()*(((B29/PI())*0.5)^2)","v":0}]
[null,"Total",{"$f":"C25+C26+C27+C28+C29","v":0},null,{"$f":"(SQRT(C30/PI())*(1/0.5))*PI()","v":0}]