{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Intro","Rice","rice+plantain","Cocoa","Oil palm","Pastures","Timber","Charcoal","NTFP","30-year analysis","OppCost Intro","OppCost","Tradeoffs","Eligibility filter"],"not_rendered":{"charts":12,"images":0,"macros":1,"external_links":2,"defined_names":0,"comments":6,"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":"Intro","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["The workbook contains 14 spreadsheet pages, divided into three sections."]
["1. Land use budget and profit analysis"]
["2. Opportunity cost and tradeoff analysis"]
["3. Eligibility filter"]
[]
["1. Land use budget and profit analysis"]
["The first set of spreadsheets provides 8 sample land use budgets of agricultural of forest land uses"]
["Many of the parameters, such as prices and yields, can be changed in order to conduct sensitivity and scenario analyses"]
[]
["A 30-year analysis of profits is also supplied Data is linked to the land use budgets."]
["The profit analysis of net present value (NPV) can be adjusted per discount rate."]
[]
["2. Opportunity cost and tradeoff analyses"]
[]
["3. REDD program eligibility filter of land use changes"]

{"sheet":"Rice","index":1,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Rice Budget"]
["Rice","Per hectare"]
[]
["Profit",{"$f":"I6-B6","v":45.300000000000011}]
[]
["Inputs",{"$f":"SUM(D8:D12)+(SUM(F17:F22))+(SUM(M18:M22))","v":234.7},null,null,null,null,null,"Income",{"$f":"I8*J8","v":280}]
["Product","Quantitiy","Price","Cost","Units",null,null,null,"Harvest (kg)","Price"]
["Seed",25,0.2,{"$f":"B8*C8","v":5},"kg",null,null,{"$f":"A2","v":"Rice"},2000,0.14000000000000001]
["Fertilizer",null,null,{"$f":"B9*C9","v":0},"kg"]
["Herbicides",null,null,{"$f":"B10*C10","v":0},"liter"]
["Insecticides",1,4,{"$f":"B11*C11","v":4},"liter"]
["Tools",null,null,{"$f":"SUM(L18:L23)","v":0.2},"unit  "]
[]
[]
["Labor","Family",null,"Purchased"]
["Activity","Workdays","Price","Workdays","Price","Cost"]
["Preparation",{"$f":"N27","v":20},3,{"$f":"N38","v":0},null,{"$f":"(B17*C17)+(D17*E17)","v":60},null,"Tools",null,"Price","Duration","area pro-rate","Yearly cost"]
["Seeding",12,3,0,null,36,null,"machete",null,2.5,1,0.2,{"$f":"J18*K18*L18","v":0.5}]
["Weeding",16,3,4,3,60]
["Harvest",16,3,4,3,60]
["Threshing",2,3,0,null,6]
["Transport",1,3,0,null,3]
[]
[]
["Family labor calendar"]
["Activity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Abr ","May ","Jun ","Jul ","Total "]
["Preparation",20,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B27:M27)","v":20}]
["Seeding",null,12,null,null,null,null,null,null,null,null,null,null,12]
["Weeding",null,null,8,null,8,null,null,null,null,null,null,null,16]
["Harvest",null,null,null,null,null,16,null,null,null,null,null,null,16]
["Drying/husking",null,null,null,null,null,2,null,null,null,null,null,null,2]
["Transport",null,null,null,null,null,1,null,null,null,null,null,null,1]
[]
["Total  ",{"$f":"SUM(B27:B32)","v":20},12,8,0,8,19,0,0,0,0,0,0,{"$f":"SUM(N27:N32)","v":67}]
[]
["Purchased labor calendar"]
["Activity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Abr ","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B38:M38)","v":0}]
["Seeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,2,null,2,null,null,null,null,null,null,null,4]
["Harvest",null,null,null,null,null,4,null,null,null,null,null,null,4]
["Drying/husking",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
["Total ",{"$f":"SUM(B38:B43)","v":0},0,2,0,2,4,0,0,0,0,0,0,8]

{"sheet":"rice+plantain","index":2,"n_rows":34,"n_cols":17,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Rice-plantain-fallow"]
[null,"Four year fallow",null,null,null,"Eight year fallow"]
["Annual net income"]
["Year","Total","Rice","Plantain","Forest Conv","Total","Rice","Plantain","Forest Conv","labor rice","labor plantain","labor total","8yr","4yr"]
[1,{"$f":"C5+D5+E5","v":-60},{"$f":"B40","v":0},{"$f":"B90","v":0},-60,{"$f":"G5+H5+I5","v":-60},{"$f":"B40","v":0},{"$f":"B90","v":0},-60,165,300,{"$f":"K5+J5","v":465},{"$f":"F5+L5","v":405},{"$f":"L5+B5","v":405}]
[{"$f":"A5+1","v":2},{"$f":"C6+D6","v":0},null,{"$f":"B91","v":0},null,{"$f":"G6+H6","v":0},null,{"$f":"B91","v":0},null,null,258,{"$f":"K6+J6","v":258},{"$f":"F6+L6","v":258},{"$f":"L6+B6","v":258}]
[{"$f":"A6+1","v":3},0,null,{"$f":"B92","v":0},null,0,null,{"$f":"B92","v":0},null,null,258,258,258,258]
[4,0,null,null,null,0,null,null,null,null,null,null,0,0,0.1,"Discount rate"]
[5,0,null,null,null,0,null,null,null,null,null,null,0,0,null,"4yr","8yr"]
[6,0,null,null,null,0,null,null,null,null,null,null,0,0,"NPV",{"$f":"NPV(O8,B5:B34)","v":-54.54545454545454},{"$f":"NPV(O8,F5:F34)","v":-54.54545454545454}]
[7,0,null,null,null,0,null,null,null,null,null,null,0,0]
[8,0,{"$f":"C5","v":0},{"$f":"D5","v":0},null,0,null,null,null,null,null,null,0,0]
[9,0,null,{"$f":"D6","v":0},null,0,null,null,null,null,null,null,0,0]
[10,0,null,{"$f":"D7","v":0},null,0,null,null,null,null,null,null,0,0]
[11,0,null,null,null,0,null,null,null,null,null,null,0,0,"notes:"]
[12,0,null,null,null,0,{"$f":"(I44*J44*1.1)-(B42)","v":0},{"$f":"H5","v":0},null,null,null,{"$f":"L5","v":465},465,465,"forest conversion considered separately"]
[13,0,null,null,null,0,null,{"$f":"H6","v":0},null,null,null,{"$f":"L6","v":258},258,258,"another 20 days for land preparation"]
[14,0,null,null,null,0,null,{"$f":"H7","v":0},null,null,null,{"$f":"L7","v":258},258,258,"longer (8yr) fallow has 10% higher yield of rice due to soil fertility and fewer weeds"]
[15,0,{"$f":"C12","v":0},{"$f":"D12","v":0},null,0,null,null,null,null,null,null,0,0,"initial year no higher yield b/c of remaining trunks in field that reduce area"]
[16,0,null,{"$f":"D13","v":0},null,0,null,null,null,null,null,null,0,0,"farmily vs. purchased labor dependent upon particular farm"]
[17,0,null,{"$f":"D14","v":0},null,0,null,null,null,null,null,null,0,0]
[18,0,null,null,null,0,null,null,null,null,null,null,0,0]
[19,0,null,null,null,0,null,null,null,null,null,null,0,0]
[20,0,null,null,null,0,null,null," ",null,null,null,0,0]
[21,0,null,null,null,0,null,null,null,null,null,null,0,0]
[22,0,{"$f":"C19","v":0},{"$f":"D5","v":0},null,0,null,null,null,null,null,null,0,0]
[23,0,null,{"$f":"D6","v":0},null,0,{"$f":"G16","v":0},{"$f":"H5","v":0},null,null,null,{"$f":"L16","v":465},465,465]
[24,0,null,{"$f":"D7","v":0},null,0,null,{"$f":"H6","v":0},null,null,null,{"$f":"L17","v":258},258,258]
[25,0,null,null,null,0,null,{"$f":"H7","v":0},null,null,null,{"$f":"L18","v":258},258,258]
[26,0,null,null,null,0,null,null,null,null,null,null,0,0]
[27,0,null,null,null,0,null,null,null,null,null,null,0,0]
[28,0,null,null,null,0,null,null,null,null,null,null,0,0]
[29,0,{"$f":"C26","v":0},{"$f":"D5","v":0},null,0,null,null,null,null,null,null,0,0]
[30,0,null,{"$f":"D6","v":0},null,0,null,null,null,null,null,null,0,0]

{"sheet":"Cocoa","index":3,"n_rows":283,"n_cols":31,"rows_kept":283,"cut":false,"hidden":false,"merged":[]}
["Cocoa"]
["per hectare basis"]
["Summary"]
["Net income ($/ha/yr)",null,{"$f":"C5-C6","v":96.600000000000023},null,"not including establishment costs"]
["Gross income",null,{"$f":"B10*B14","v":720}]
["Production costs ",null,{"$f":"C70","v":623.4}]
[]
[null,null,null,"key adjustable parameters in yellow cells"]
["Production"]
["Yield",600,"kg/ha"]
[]
["Prices of inputs (US$)",null,null,null,"Price variation  "]
["Item","Price","Unit","Min","Max","Notes/questions"]
["Cocoa",1.2,"kg",null,null,"farmgate or market; price variation"]
[]
["Labor (wage rate)",3,"day",null,null,"social benefits included?"]
["Land (rental rate)",10,"hectare",null,null,"depends on land quality and access"]
[]
["Harvest transport",0.1,"kg farm-mkt",null,null,"= 0 if farm gate sale"]
[]
[null,null,null,null,null,"Application rate"]
["Seed/plant",1,"seed/plant",null,null,600,"plants/ha"]
["Fertilizer",2,"kg",null,null,30,"kg/ha "]
["Pesticides",25,"liter",null,null,2,"liter/ha "]
["Herbicides",0,"liter",null,null,0,"liter/ha "]
[]
["Costs"]
["Establishment","quantity","cost",null,null,null,null,"Tools","Price","Duration","Area used","Cost/year"]
["Labor",null,null,"family","hired",null,null,"Machete",4,2,5,{"$f":"I29/J29/K29","v":0.4}]
["   preparation",10,{"$f":"B30*B$16","v":30},10,0,null,null,"Shovel",5,1,5,{"$f":"I30/J30/K30","v":1}]
["   planting",{"$f":"D31+E31","v":20},{"$f":"B31*B$16","v":60},8,12,null,null,"Sprayer",20,1,5,{"$f":"I31/J31/K31","v":4}]
["   nursery",{"$f":"D32+E32","v":0},{"$f":"B32*B$16","v":0},0,0,null,null,"Units","US$","years","ha","$/ha"]
["Subtotal Labor",{"$f":"SUM(B30:B32)","v":30},{"$f":"SUM(C30:C32)","v":90}]
["Capital Inputs*"]
["  Machete",null,{"$f":"L29","v":0.4}]
["  Shovel",null,{"$f":"L30","v":1}]
["  Sprayer",null,{"$f":"L31","v":4}]
["  Seeds/plants",600,{"$f":"B38*B22","v":600}]
["  Fertilizer",{"$f":"F23","v":30},{"$f":"B39*B23","v":60}]
["  Pesticides",{"$f":"F24","v":2},{"$f":"B40*B24","v":50}]
["  Herbicides",{"$f":"F25","v":0},{"$f":"B41*B25","v":0}]
["  Machinery rental"]
["Land"]
["  Rental rate",null,{"$f":"B17","v":10}]
["Total est. costs",null,{"$f":"SUM(C33:C44)","v":815.4}]
[]
["Replanting (year 21)",null,{"$f":"C45","v":815.4}]
[]
["Production/Maintenance","quantity","cost"]
["Labor",null,null,"family","hired"]
["   Weeding ",{"$f":"D51+E51","v":18},{"$f":"B51*B$16","v":54},8,10]
["   Ground circles",{"$f":"D52+E52","v":0},{"$f":"B52*B$16","v":0}]
["   Row maintenance",0,0]
["   Pruning",1,3,1]
["   Drying",32,96,32]
["   Fertilizing",1,3,1]
["   Phytosanitary control",4,12,4]
["   Harvest",90,270,30,60,"should be adjusted if large increase/decrease"]
["Subtotal labor",{"$f":"SUM(B51:B58)","v":146},{"$f":"SUM(C51:C58)","v":438}]
["Inputs"]
["  Fertilizer",30,{"$f":"B61*B23","v":60}]
["  Pesticides",2,{"$f":"B62*B24","v":50}]
["  Herbicides"]
["  Tools",null,{"$f":"SUM(C35:C37)","v":5.4},null,null,"sum of establishment cost of tools"]
["Land"]
["Rental cost/value",null,{"$f":"B17","v":10}]
["Transport"]
["Farm to market",{"$f":"B10","v":600},{"$f":"B68*B19","v":60}]
[]
["Total costs production/maintenance",null,{"$f":"SUM(C59:C68)","v":623.4}]
[]
["year",1,{"$f":"B72+1","v":2},{"$f":"C72+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
["costs",{"$f":"C45","v":815.4},{"$f":"0.12*C70","v":74.807999999999993},{"$f":"0.25*C70","v":155.85},{"$f":"0.7*C70","v":436.37999999999994},{"$f":"C70","v":623.4},{"$f":"F73","v":623.4},{"$f":"G73","v":623.4},623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4,623.4]
["yield",0,0,200,600,{"$f":"B10","v":600},{"$f":"F74","v":600},{"$f":"G74","v":600},{"$f":"H74","v":600},{"$f":"I74","v":600},600,600,600,600,600,600,600,600,600,600,600,600,600,600,600,600,600,600,600,600,600]
["gross income",{"$f":"B74*$B14","v":0},{"$f":"C74*$B14","v":0},240,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720,720]
["net income, profit",{"$f":"B75-B73","v":-815.4},{"$f":"C75-C73","v":-74.807999999999993},{"$f":"D75-D73","v":84.15},{"$f":"E75-E73","v":283.62000000000006},{"$f":"F75-F73","v":96.600000000000023},96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023,96.600000000000023]
[]
["labor",{"$f":"B33","v":30},24,53,112,{"$f":"B59","v":146},{"$f":"F78","v":146},{"$f":"G78","v":146},146,146,146,146,146,146,146,146,146,146,146,146,146,146,146,146,146,146,146,146,146,146,146]
["labor income",{"$f":"B78*3","v":90},{"$f":"C78*3","v":72},159,336,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438,438]
["income",{"$f":"B79+B76","v":-725.4},{"$f":"C79+C76","v":-2.8079999999999927},243.15,619.62000000000012,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6,534.6]
["% of annual maintenance estimate",null,{"$f":"C73/$F73","v":0.12},{"$f":"D73/$F73","v":0.25},{"$f":"E73/$F73","v":0.7},{"$f":"F73/$F73","v":1}]
[]
["Calendar family labor"]
["Year 1"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,4,null,null,null,null,null,null,null,null,{"$f":"SUM(B86:M86)","v":4}]
["Planting",null,null,null,8,null,null,null,null,null,null,null,null,8]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Control",null,null,null,null,null,null,4,null,null,null,null,null,4]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B86:B91)","v":0},0,0,12,0,0,4,0,0,0,0,0,16]
[]
["Year 2"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B96:M96)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Control",null,null,null,null,null,null,4,null,null,null,null,null,4]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B96:B101)","v":0},0,0,0,0,0,4,0,0,0,0,0,4]
[]
["Year 3"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B106:M106)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",1,1,1,null,null,null,null,null,null,null,1,2,6]
["Control",2,1,1,null,null,null,4,null,null,null,1,2,11]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B106:B111)","v":3},2,2,0,0,0,4,0,0,0,2,4,17]
[]
["Year 4"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B116:M116)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",4,3,3,null,null,null,null,null,null,null,4,4,18]
["Control",4,4,3,null,null,null,4,null,null,null,4,4,23]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B116:B121)","v":8},7,6,0,0,0,4,0,0,0,8,8,41]
[]
["Year 5"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B126:M126)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",6,6,6,null,null,null,null,null,null,null,6,6,30]
["Control",7,6,6,null,null,null,4,null,null,null,6,7,36]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B126:B131)","v":13},12,12,0,0,0,4,0,0,0,12,13,66]
[]
["Year 6"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B136:M136)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",6,6,6,null,null,null,null,null,null,null,6,6,30]
["Control",7,6,6,null,null,null,4,null,null,null,6,7,36]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B136:B141)","v":13},12,12,0,0,0,4,0,0,0,12,13,66]
[]
["Year 7"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B146:M146)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",6,6,6,null,null,null,null,null,null,null,6,6,30]
["Control",7,6,6,null,null,null,4,null,null,null,6,7,36]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B146:B151)","v":13},12,12,0,0,0,4,0,0,0,12,13,66]
[]
["Year 8"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B156:M156)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",6,6,6,null,null,null,null,null,null,null,6,6,30]
["Control",7,6,6,null,null,null,4,null,null,null,6,7,36]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B156:B161)","v":13},12,12,0,0,0,4,0,0,0,12,13,66]
[]
["Year 9"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B166:M166)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",6,6,6,null,null,null,null,null,null,null,6,6,30]
["Control",7,6,6,null,null,null,4,null,null,null,6,7,36]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B166:B171)","v":13},12,12,0,0,0,4,0,0,0,12,13,66]
[]
["Year 10"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B176:M176)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Harvest",6,6,6,null,null,null,null,null,null,null,6,6,30]
["Control",7,6,6,null,null,null,4,null,null,null,6,7,36]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B176:B181)","v":13},12,12,0,0,0,4,0,0,0,12,13,66]
[]
["Calendar Hired Labor"]
["Year 1"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B187:M187)","v":0}]
["Planting",null,null,null,12,null,null,null,null,null,null,null,null,12]
["Weeding",10,null,null,null,null,null,10,null,null,null,null,null,20]
["Harvest",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B187:B192)","v":10},0,0,12,0,0,10,0,0,0,0,0,32]
[]
["Year 2"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B197:M197)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",10,null,null,10,null,null,10,null,null,10,null,null,40]
["Harvest",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B197:B202)","v":10},0,0,10,0,0,10,0,0,10,0,0,40]
[]
["Year 3"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B207:M207)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",10,null,null,10,null,null,10,null,null,10,null,null,40]
["Harvest",2,2,2,null,null,null,null,null,null,null,2,4,12]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B207:B212)","v":12},2,2,10,0,0,10,0,0,10,2,4,52]
[]
["Year 4"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B217:M217)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,10,null,null,null,null,null,10]
["Harvest",7,7,7,null,null,null,null,null,null,null,7,8,36]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B217:B222)","v":7},7,7,0,0,0,10,0,0,0,7,8,46]
[]
["Year 5"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B227:M227)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,10,null,null,null,null,null,10]
["Harvest",12,12,12,null,null,null,null,null,null,null,12,12,60]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B227:B232)","v":12},12,12,0,0,0,10,0,0,0,12,12,70]
[]
["Year 6"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B237:M237)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,10,null,null,null,null,null,10]
["Harvest",12,12,12,null,null,null,null,null,null,null,12,12,60]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B237:B242)","v":12},12,12,0,0,0,10,0,0,0,12,12,70]
[]
["Year 7"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B247:M247)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,10,null,null,null,null,null,10]
["Harvest",12,12,12,null,null,null,null,null,null,null,12,12,60]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B247:B252)","v":12},12,12,0,0,0,10,0,0,0,12,12,70]
[]
["Year 8"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B257:M257)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,10,null,null,null,null,null,10]
["Harvest",12,12,12,null,null,null,null,null,null,null,12,12,60]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B257:B262)","v":12},12,12,0,0,0,10,0,0,0,12,12,70]
[]
["Year 9"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B267:M267)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,10,null,null,null,null,null,10]
["Harvest",12,12,12,null,null,null,null,null,null,null,12,12,60]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B267:B272)","v":12},12,12,0,0,0,10,0,0,0,12,12,70]
[]
["Year 10"]
["Actitivity","Aug","Sep ","Oct ","Nov ","Dec","Jan","Feb ","Mar ","Apr","May ","Jun ","Jul ","Total "]
["Preparation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(B277:M277)","v":0}]
["Planting",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Weeding",null,null,null,null,null,null,10,null,null,null,null,null,10]
["Harvest",12,12,12,null,null,null,null,null,null,null,12,12,60]
["Control",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Transport",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total  ",{"$f":"SUM(B277:B282)","v":12},12,12,0,0,0,10,0,0,0,12,12,70]

{"sheet":"Oil palm","index":4,"n_rows":76,"n_cols":31,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Oil palm"]
["per hectare"]
["Summary",null,null,"key adjustable parameters in yellow cells"]
["Net income",{"$f":"B5-B6","v":80.800000000000011},"US$/ha"]
["Gross Income",{"$f":"B9*B13","v":344}]
["Production costs",{"$f":"C63","v":263.2},null,"not including establishment costs"]
[]
["Production"]
["Racime yield",8,"t/ha",null,"6 tons reported, 14 tons expected potential"]
[]
["Prices (US$)"]
["Item","Price","Unit","Min","Max","Notes/questions"]
["Racime (bunch)",43,"ton",null,null,"farmgate or market; price variation"]
[]
["Labor (wage rate)",3,"day",null,null,"social benefits included?"]
[]
["Harvest transport",0,"kg farm-mkt",null,null,"= 0 if farm gate sale"]
[]
[null,null,null,null,null,"Application rate"]
["Seed/plant",1,"seed/plant",null,null,0,"plants/ha"]
["Fertilizer",2,"kg",null,null,50,"kg/ha "]
["Pesticides",25,"liter",null,null,0,"liter/ha "]
["Herbicides",0,"liter",null,null,0,"liter/ha "]
[]
["Costs"]
["Establishment","workdays","cost ($/ha)","family","hired"]
["Labor",null,null,null,null,null,null,"Tools","Price","Duration","Area used","Cost/year"]
["   preparation",{"$f":"D28+E28","v":34},{"$f":"B28*B$15","v":102},34,0,null,null,"Machete",4,2,5,{"$f":"I28/J28/K28","v":0.4}]
["   planting",{"$f":"D29+E29","v":34},{"$f":"B29*B$15","v":102},34,0,null,null,"Shovel",5,1,5,{"$f":"I29/J29/K29","v":1}]
["   nursery",{"$f":"D30+E30","v":20},{"$f":"B30*B$15","v":60},20,0,null,null,"Sprayer",20,1,5,{"$f":"I30/J30/K30","v":4}]
["Subtotal labor",{"$f":"SUM(B28:B30)","v":88},{"$f":"B31*B$15","v":264},null,null,null,null,"Units","US$","years","ha","$/ha"]
["Capital Inputs*"]
["  Machete",null,{"$f":"L28","v":0.4}]
["  Shovel",null,{"$f":"L29","v":1}]
["  Sprayer",null,{"$f":"L30","v":4}]
["  Seeds/plants",{"$f":"F20","v":0},{"$f":"B36*B20","v":0}]
["  Fertilizer",{"$f":"F21","v":50},{"$f":"B37*B21","v":100}]
["  Pesticides",{"$f":"F22","v":0},{"$f":"B38*B22","v":0}]
["  Herbicides",{"$f":"F22","v":0},{"$f":"B39*B22","v":0}]
["  Machinery rental",0,0]
["Land"]
["  Rental rate",null,0]
["Total est. costs",null,{"$f":"SUM(C31:C42)","v":369.4}]
[]
["Production/Maintenance","workdays","cost"]
["Labor",null,null,"family","hired"]
["   Weeding ",{"$f":"D47+E47","v":5.7},{"$f":"B47*B$15","v":17.100000000000001},5.7,0]
["   Ground circles",{"$f":"D48+E48","v":2.1},{"$f":"B48*B$15","v":6.3000000000000007},2.1,0]
["   Row maintenance",1.4,4.1999999999999993,1.4,0]
["   Pruning",1.9,5.6999999999999993,1.9,0]
["   Leaf stacking",1.9,5.6999999999999993,1.9,0]
["   Fertilizing",1.4,4.1999999999999993,1.4,0]
["   Phytosanitary control",2,6,2,0]
["   Harvest",28,84,28,0,"should be adjusted if large increase/decrease"]
["Subtotal labor",{"$f":"SUM(B47:B54)","v":44.400000000000006},{"$f":"SUM(C47:C54)","v":133.19999999999999}]
["Inputs"]
["  Fertilizer",{"$f":"F21","v":50},{"$f":"B57*B21","v":100}]
["  Pesticides",{"$f":"F22","v":0},{"$f":"B58*B22","v":0}]
["  Herbicides",{"$f":"F23","v":0},{"$f":"B59*B23","v":0}]
["  Tools",null,20,null,null,"sum of establishment cost of tools"]
["Land"]
["Rental cost/value",null,10]
["Total costs production/maintenance",null,{"$f":"SUM(C55:C62)","v":263.2}]
[]
["year",1,{"$f":"B65+1","v":2},{"$f":"C65+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
["costs",{"$f":"C43","v":369.4},70,70,70,{"$f":"0.57*C$63","v":150.02399999999997},{"$f":"0.71*C$63","v":186.87199999999999},{"$f":"0.85*C$63","v":223.71999999999997},{"$f":"C63","v":263.2},{"$f":"I66","v":263.2},{"$f":"J66","v":263.2},263.2,263.2,263.2,263.2,263.2,263.2,263.2,263.2,263.2,263.2,454,19,19,19,24,75,110,144,144,144]
["yield",0,0,0,0,{"$f":"0.57*B9","v":4.5599999999999996},{"$f":"0.71*B9","v":5.68},{"$f":"0.85*B9","v":6.8},{"$f":"B9","v":8},{"$f":"I67","v":8},8,8,8,8,8,8,8,8,8,8,8,0,0,0,0,{"$f":"F67","v":4.5599999999999996},{"$f":"G67","v":5.68},6.8,8,8,8]
["gross income",0,0,0,0,{"$f":"F67*$B13","v":196.07999999999998},244.23999999999998,292.39999999999998,344,344,344,344,344,344,344,344,344,344,344,344,344,0,0,0,0,{"$f":"F68","v":196.07999999999998},244.23999999999998,292.39999999999998,344,344,344]
["net income // profit",{"$f":"B68-B66","v":-369.4},{"$f":"C68-C66","v":-70},{"$f":"D68-D66","v":-70},{"$f":"E68-E66","v":-70},{"$f":"F68-F66","v":46.056000000000012},57.367999999999995,68.680000000000007,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,-454,-19,-19,-19,172.07999999999998,169.23999999999998,182.39999999999998,200,200,200]
[]
["labor",{"$f":"B31","v":88},15,17,19.600000000000001,29.3,36.700000000000003,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44,44]
["labor income",{"$f":"B71*3","v":264},{"$f":"C71*3","v":45},51,58.800000000000004,87.9,110.10000000000001,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132,132]
["% annual maintenance estimate",null,{"$f":"C71/$B55","v":0.33783783783783777},0.38288288288288286,0.44144144144144143,0.65990990990990983,0.82657657657657657,0.99099099099099086]
[]
["Sources: OLAMSA, CTARU"]
["income",{"$f":"B72+B69","v":-105.39999999999998},{"$f":"C72+C69","v":-25},-19,-11.199999999999996,133.95600000000002,167.46800000000002,200.68,212.8,212.8,212.8,212.8,212.8,212.8,212.8,212.8,212.8,212.8,212.8,212.8,212.8,-322,113,113,113,304.08,301.24,314.39999999999998,332,332,332]

{"sheet":"Pastures","index":5,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["Dual purpose (beef and milk) farm Pucallpa, Peru"]
["per hectare"]
[null,null,null,null,"key adjustable parameters in yellow cells"]
["Summary","traditional/degraded pastures",null,"improved pastures"]
["Net income ($/ha/yr)",{"$f":"B39","v":48},null,{"$f":"D39","v":84},null,"not including establishment costs"]
[{"$f":"A34","v":"Gross income "},{"$f":"B34","v":106},null,{"$f":"D34","v":159}]
["Production costs ",{"$f":"B32","v":58},null,{"$f":"D32","v":75}]
[]
["Prices (US$) ",null,null,null,null,"Notes"]
["Milk ($/kg)",0.32]
["Meat ($/kg culled cow)",0.6]
["Labor ($/day)a",3,null,"productivity",null,"Could be considered higher if social benefits included"]
["Land ($/ha)",200,null,"multiplier"]
["Animal unit AU ($)",500,null,1.5]
[]
["Animal units (animals/ha)",0.6,null,{"$f":"B16*D$14","v":0.89999999999999991}]
["Establishment costs",null,"labor",null,"labor"]
["Livestock (AU*$500/AU)",{"$f":"B16*B14","v":300},null,{"$f":"D16*B14","v":449.99999999999994},null,"could be lower since often raised on-farm"]
["Shed, corral, equipment",35,null,53]
["Preparation",0,null,0,null,"could be higher if converting forest"]
["Pasture seeding",3,1,120,5]
["Fencesb",84,3,84,3,"could be higher or lower depending on farm size"]
["Total",{"$f":"SUM(B18:B22)","v":422},{"$f":"SUM(C18:C22)","v":4},{"$f":"SUM(D18:D22)","v":707},{"$f":"SUM(E18:E22)","v":8}]
[]
["Production costs "]
["Labor",20,4.5,{"$f":"E26*B12","v":18},6]
["Supplements",10,null,{"$f":"B27*D$14","v":15}]
["Animal health",12,null,{"$f":"B28*D$14","v":18}]
["Maintenance ",11,null,{"$f":"B29*D$14","v":16.5}]
["Land rental",0,null,0]
["Other",5,null,{"$f":"B31*D$14","v":7.5}]
["Total",{"$f":"SUM(B26:B31)","v":58},null,{"$f":"SUM(D26:D31)","v":75}]
[]
["Gross income ",{"$f":"SUM(B35:B37)","v":106},null,{"$f":"SUM(D35:D37)","v":159}]
["Milk ",64,null,{"$f":"B35*D$14","v":96}]
["Beef (culled cows)",17,null,{"$f":"B36*D$14","v":25.5}]
["Veal",25,null,{"$f":"B37*D$14","v":37.5}]
[]
["Net income",{"$f":"B34-B32","v":48},null,{"$f":"D34-D32","v":84}]
[]
["a. Does not include social benefits, estimated at 24% "]
["b. An average of 5280m, $0.90/m,  4 wires & posts at 3m"]
["c. Animal unit (AU) conversion: Cow = 1.0; heifer = 0.7; female calf = 0.3; bull = 1.3."]
["land rental = 10% land value"]

{"sheet":"Timber","index":6,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,1,2,2]]}
["Timber "]
["per hectare","key adjustable parameters in yellow cells"]
[]
["Profit",{"$f":"B6-B7","v":450},"$/ha"]
[]
["Revenues",{"$f":"B10*B13","v":3060},"$/ha"]
["Costs",{"$f":"E23","v":2610},"$/ha",null,null,null,null,null,null,"Other parameter estimates from literature"]
[null,null,null,null,null,null,null,"Range",null,"Bauch 2005",null,"Southgate","Vera & Schwartzman 2005",null,"Holmes 1999",null,"Verissimo 2002"]
["Parameters",null,"unit",null,null,null,null,"low","high ","low","high",1998,"low","high","low","high","low","high"]
["Price timber",120,"$/m3",null,null,null,null,{"$f":"MIN(J10:R10)","v":50},{"$f":"MAX(J10:R10)","v":250},null,null,null,null,null,null,null,50,250,"very dependent on timber quality"]
["Quantity harvested",30,"m3/ha",null,null,null,null,{"$f":"MIN(J11:R11)","v":15},{"$f":"MAX(J11:R11)","v":40},27,27,null,15,40]
["Waste",15,"%",null,null,null,null,{"$f":"MIN(J12:R12)","v":7.6},{"$f":"MAX(J12:R12)","v":24},19,19,null,null,null,24,7.6]
["Quantity sold",{"$f":"B11*(100-B12)/100","v":25.5},"m3"]
[]
[]
[]
["Costs",null,"unit",null,null,"unit",null,"Range"]
["Harvesting",35,"$/m3",null,{"$f":"B18*B$11","v":1050},"$/ha",null,{"$f":"MIN(J18:R18)","v":6.2},{"$f":"MAX(J18:R18)","v":48.4},32.1,48.4,null,null,null,6.2,7,25,31]
["Transportation",20,"$/m3",null,{"$f":"B19*B$11","v":600},"$/ha",null,{"$f":"MIN(J19:R19)","v":18},{"$f":"MAX(J19:R19)","v":47},18,35,null,null,null,null,null,19,47]
["Milling",24,"$/m3",null,{"$f":"B20*B$11","v":720},"$/ha",null,{"$f":"MIN(J20:R20)","v":33},{"$f":"MAX(J20:R20)","v":108},67,108,null,null,null,null,null,33,33]
["Stumpage fee",8,"$/m3",null,{"$f":"B21*B$11","v":240},"$/ha",null,{"$f":"MIN(J21:R21)","v":5},{"$f":"MAX(J21:R21)","v":35},8.1999999999999993,8.1999999999999993,35,5,35,9,7.6]
[]
["Total Costs",{"$f":"SUM(B18:B22)","v":87},"$/m3",null,{"$f":"SUM(E18:E22)","v":2610},"$/ha"]

{"sheet":"Charcoal","index":7,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Charcoal"]
["per hectare","key adjustable parameters in yellow cells"]
[null,null,"unit","Parameters",null,"unit"]
["Profit",{"$f":"B6-B7","v":377.88},"$/ha","Price charcoal",8.1000000000000003E-2,"$/kg"]
[null,null,null,"Quantity harvested",6480,"kg/ha"]
["Revenues",{"$f":"E4*E5","v":524.88},"$/ha","Wage rate",3,"$/day"]
["Costs",{"$f":"D12","v":147},"$/ha"]
[]
["Costs",null,"unit"]
["Labor",49,"workday",{"$f":"B10*E6","v":147},"$/ha"]
["Transport","see below notes"]
["Total Costs",null,null,{"$f":"D10","v":147},"$/ha"]
[]
["Notes:"]
["analysis assumes no transport"]
["cost for the first two years, since the trees are nearby the farm. "]
["if charcoal activity continues for more than one year,"]
[" 8 extra person-days is  required for carrying charcoal bags during"]
["years 3 and 4, 16 extra person-days for years"]
["5 and 6, 24 person-days for years 7 and 8 and"]
["32 extra person-days for years 9 and 10."]
[]
["since charcoal production is largely a smallholder farmer activity,"]
["available labor may be severely limited. Therefore charcoal production "]
["should be analyzed within a whole farm context."]
[]
["Source: Labarta, R., D. White, S. Swinton. Does Charcoal Production "]
["Slow Agricultural Expansion into the Peruvian Amazon Rainforest? World Development, 36 (3):527–540."]

{"sheet":"NTFP","index":8,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Non-timber forest products"]
["NTFP",null,"Other revenue estimates"]
[null,null,"Godoy","Belcher","Belcher","Belcher","Seroa da Motta 2002"]
["Profit",null,"1996 US$","wild","managed","cultivated"]
[1,"$/ha",2.7,1.8,3.8,25.6,0.2]
[]
[]
["cost information unknown"]

{"sheet":"30-year analysis","index":9,"n_rows":50,"n_cols":33,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Land use","NPV","Land use trajectory",1,{"$f":"D1+1","v":2},{"$f":"E1+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[]
["Oil palm",{"$f":"NPV($B$18,D3:AG3)","v":245.37256398048822},"Transitional",{"$f":"'[1]Oil palm'!B69","v":-369.4},{"$f":"'[1]Oil palm'!C69","v":-70},{"$f":"'[1]Oil palm'!D69","v":-70},{"$f":"'[1]Oil palm'!E69","v":-70},{"$f":"'[1]Oil palm'!F69","v":46.056000000000012},{"$f":"'[1]Oil palm'!G69","v":57.367999999999995},{"$f":"'[1]Oil palm'!H69","v":68.680000000000007},{"$f":"'[1]Oil palm'!I69","v":80.800000000000011},{"$f":"'[1]Oil palm'!J69","v":80.800000000000011},{"$f":"'[1]Oil palm'!K69","v":80.800000000000011},{"$f":"'[1]Oil palm'!L69","v":80.800000000000011},{"$f":"'[1]Oil palm'!M69","v":80.800000000000011},{"$f":"'[1]Oil palm'!N69","v":80.800000000000011},{"$f":"'[1]Oil palm'!O69","v":80.800000000000011},{"$f":"'[1]Oil palm'!P69","v":80.800000000000011},{"$f":"'[1]Oil palm'!Q69","v":80.800000000000011},{"$f":"'[1]Oil palm'!R69","v":80.800000000000011},{"$f":"'[1]Oil palm'!S69","v":80.800000000000011},{"$f":"'[1]Oil palm'!T69","v":80.800000000000011},{"$f":"'[1]Oil palm'!U69","v":80.800000000000011},{"$f":"'[1]Oil palm'!V69","v":-454},{"$f":"'[1]Oil palm'!W69","v":-19},{"$f":"'[1]Oil palm'!X69","v":-19},{"$f":"'[1]Oil palm'!Y69","v":-19},{"$f":"'[1]Oil palm'!Z69","v":172.07999999999998},{"$f":"'[1]Oil palm'!AA69","v":169.23999999999998},{"$f":"'[1]Oil palm'!AB69","v":182.39999999999998},{"$f":"'[1]Oil palm'!AC69","v":200},{"$f":"'[1]Oil palm'!AD69","v":200},{"$f":"'[1]Oil palm'!AE69","v":200}]
["Cocoa",604.04227051577675,"Transitional",{"$f":"[1]Cocoa!B76","v":-815.4},{"$f":"[1]Cocoa!C76","v":-74.807999999999993},{"$f":"[1]Cocoa!D76","v":84.15},{"$f":"[1]Cocoa!E76","v":283.62000000000006},{"$f":"[1]Cocoa!F76","v":96.600000000000023},{"$f":"[1]Cocoa!G76","v":96.600000000000023},{"$f":"[1]Cocoa!H76","v":96.600000000000023},{"$f":"[1]Cocoa!I76","v":96.600000000000023},{"$f":"[1]Cocoa!J76","v":96.600000000000023},{"$f":"[1]Cocoa!K76","v":96.600000000000023},{"$f":"[1]Cocoa!L76","v":96.600000000000023},{"$f":"[1]Cocoa!M76","v":96.600000000000023},{"$f":"[1]Cocoa!N76","v":96.600000000000023},{"$f":"[1]Cocoa!O76","v":96.600000000000023},{"$f":"[1]Cocoa!P76","v":96.600000000000023},{"$f":"[1]Cocoa!Q76","v":96.600000000000023},{"$f":"[1]Cocoa!R76","v":96.600000000000023},{"$f":"[1]Cocoa!S76","v":96.600000000000023},{"$f":"[1]Cocoa!T76","v":96.600000000000023},{"$f":"[1]Cocoa!U76","v":96.600000000000023},{"$f":"[1]Cocoa!V76","v":96.600000000000023},{"$f":"[1]Cocoa!W76","v":96.600000000000023},{"$f":"[1]Cocoa!X76","v":96.600000000000023},{"$f":"[1]Cocoa!Y76","v":96.600000000000023},{"$f":"[1]Cocoa!Z76","v":96.600000000000023},{"$f":"[1]Cocoa!AA76","v":96.600000000000023},{"$f":"[1]Cocoa!AB76","v":96.600000000000023},{"$f":"[1]Cocoa!AC76","v":96.600000000000023},{"$f":"[1]Cocoa!AD76","v":96.600000000000023},{"$f":"[1]Cocoa!AE76","v":96.600000000000023}]
["Rice+plantain 8y fallow",302.35101788309072,"Cyclical",{"$f":"'[1]rice+plantain'!F5","v":-132.56666666666666},{"$f":"'[1]rice+plantain'!F6","v":158.13333333333333},{"$f":"'[1]rice+plantain'!F7","v":115.13333333333333},{"$f":"'[1]rice+plantain'!F8","v":0},{"$f":"'[1]rice+plantain'!F9","v":0},{"$f":"'[1]rice+plantain'!F10","v":0},{"$f":"'[1]rice+plantain'!F11","v":0},{"$f":"'[1]rice+plantain'!F12","v":0},{"$f":"'[1]rice+plantain'!F13","v":0},{"$f":"'[1]rice+plantain'!F14","v":0},{"$f":"'[1]rice+plantain'!F15","v":0},{"$f":"'[1]rice+plantain'!F16","v":-44.566666666666663},{"$f":"'[1]rice+plantain'!F17","v":158.13333333333333},{"$f":"'[1]rice+plantain'!F18","v":115.13333333333333},{"$f":"'[1]rice+plantain'!F19","v":0},{"$f":"'[1]rice+plantain'!F20","v":0},{"$f":"'[1]rice+plantain'!F21","v":0},{"$f":"'[1]rice+plantain'!F22","v":0},{"$f":"'[1]rice+plantain'!F23","v":0},{"$f":"'[1]rice+plantain'!F24","v":0},{"$f":"'[1]rice+plantain'!F25","v":0},{"$f":"'[1]rice+plantain'!F26","v":0},{"$f":"'[1]rice+plantain'!F27","v":-44.566666666666663},{"$f":"'[1]rice+plantain'!F28","v":158.13333333333333},{"$f":"'[1]rice+plantain'!F29","v":115.13333333333333},{"$f":"'[1]rice+plantain'!F30","v":0},{"$f":"'[1]rice+plantain'!F31","v":0},{"$f":"'[1]rice+plantain'!F32","v":0},{"$f":"'[1]rice+plantain'!F33","v":0},{"$f":"'[1]rice+plantain'!F34","v":0}]
["Rice+plantain 4y fallow",409.23797961031033,"Cyclical",{"$f":"'[1]rice+plantain'!B5","v":-132.56666666666666},{"$f":"'[1]rice+plantain'!B6","v":158.13333333333333},{"$f":"'[1]rice+plantain'!B7","v":115.13333333333333},{"$f":"'[1]rice+plantain'!B8","v":0},{"$f":"'[1]rice+plantain'!B9","v":0},{"$f":"'[1]rice+plantain'!B10","v":0},{"$f":"'[1]rice+plantain'!B11","v":0},{"$f":"'[1]rice+plantain'!B12","v":-72.566666666666663},{"$f":"'[1]rice+plantain'!B13","v":158.13333333333333},{"$f":"'[1]rice+plantain'!B14","v":115.13333333333333},{"$f":"'[1]rice+plantain'!B15","v":0},{"$f":"'[1]rice+plantain'!B16","v":0},{"$f":"'[1]rice+plantain'!B17","v":0},{"$f":"'[1]rice+plantain'!B18","v":0},{"$f":"'[1]rice+plantain'!B19","v":-72.566666666666663},{"$f":"'[1]rice+plantain'!B20","v":158.13333333333333},{"$f":"'[1]rice+plantain'!B21","v":115.13333333333333},{"$f":"'[1]rice+plantain'!B22","v":0},{"$f":"'[1]rice+plantain'!B23","v":0},{"$f":"'[1]rice+plantain'!B24","v":0},{"$f":"'[1]rice+plantain'!B25","v":0},{"$f":"'[1]rice+plantain'!B26","v":-72.566666666666663},{"$f":"'[1]rice+plantain'!B27","v":158.13333333333333},{"$f":"'[1]rice+plantain'!B28","v":115.13333333333333},{"$f":"'[1]rice+plantain'!B29","v":0},{"$f":"'[1]rice+plantain'!B30","v":0},{"$f":"'[1]rice+plantain'!B31","v":0},{"$f":"'[1]rice+plantain'!B32","v":0},{"$f":"'[1]rice+plantain'!B33","v":-72.566666666666663},{"$f":"'[1]rice+plantain'!B34","v":158.13333333333333}]
["Improved pasture",617.95255292482432,"Direct",{"$f":"[1]Pastures!D39-[1]Pastures!D23","v":-623},{"$f":"[1]Pastures!D39","v":84},{"$f":"E7","v":84},{"$f":"F7","v":84},84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84]
["Traditional pasture",335.97288738561394,"Direct",{"$f":"[1]Pastures!B39-[1]Pastures!B23","v":-374},{"$f":"[1]Pastures!B39","v":48},{"$f":"E8","v":48},48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48]
[]
["w/Charcoal",{"$f":"NPV($B$18,D10:AG10)","v":359.88571428571424},"Conversion",{"$f":"[1]Charcoal!B4","v":377.88}]
["Charcoal+oil palm",{"$f":"NPV($B$18,D11:AG11)","v":605.2582782662023},"Direct",{"$f":"D10+D3","v":8.4800000000000182},{"$f":"E10+E3","v":-70},-70,-70,46.056000000000012,57.367999999999995,68.680000000000007,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,80.800000000000011,-454,-19,-19,-19,172.07999999999998,169.23999999999998,182.39999999999998,200,200,200]
["Charcoal+rice+plantain 8y fallow ",{"$f":"NPV($B$18,D12:AG12)","v":662.23673216880491},"Direct",{"$f":"D5+D10","v":245.31333333333333},{"$f":"E5","v":158.13333333333333},{"$f":"F5","v":115.13333333333333},0,0,0,0,0,0,0,0,-44.566666666666663,158.13333333333333,115.13333333333333,0,0,0,0,0,0,0,0,-44.566666666666663,158.13333333333333,115.13333333333333,0,0,0,0,0]
["w/Timber",{"$f":"NPV($B$18,D13:AG13)","v":428.57142857142856},"Conversion",{"$f":"[1]Timber!B4","v":450}]
["Timber+improved pasture",{"$f":"NPV($B$18,D14:AG14)","v":1046.5239814962531},"Direct",{"$f":"D13+D7","v":-173},{"$f":"E7","v":84},{"$f":"F7","v":84},84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84,84]
[]
["NTFP collection",{"$f":"NPV($B$18,D16:AG16)","v":15.37245102688283},"Forest harvest",{"$f":"[1]NTFPs!A4","v":1},{"$f":"D16","v":1},{"$f":"E16","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
["discount rate",0.05]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Annually  discounted"]
[null,"NPV","Land use trajectory",1,{"$f":"D36+1","v":2},{"$f":"E36+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[]
["Oil palm",{"$f":"SUM(D38:AG38)","v":245.37256398048854},"Transitional",{"$f":"D3/((1+$B$18)^(D$1))","v":-351.8095238095238},-63.492063492063487,-60.468631897203316,-57.589173235431737,36.086081122871356,42.808884874250055,48.809593753336749,54.688620451917934,52.084400430398027,49.604190886093356,47.242086558184148,44.992463388746813,42.849965132139815,40.809490602037933,38.866181525750399,37.015410976905144,35.252772358957273,33.574068913292642,31.975303726945373,30.452670216138454,-162.95983354699266,-6.4951475506458163,-6.1858548101388706,-5.8912902953703536,50.815700953750898,47.597181982980239,48.855533385643348,51.018727428616714,48.589264217730189,46.275489731171632]
["Cocoa",{"$f":"SUM(D39:AG39)","v":604.04227051577709},"Transitional",-776.57142857142856,-67.853061224489792,72.691933916423707,233.33487590047361,75.688627680853159,72.084407315098247,68.651816490569743,65.3826823719712,62.269221306639231,59.304020292037364,56.480019325749865,53.790494595952261,51.229042472335479,48.789564259367133,46.466251675587728,44.253573024369274,42.146260023208825,40.139295260198878,38.227900247808456,36.407524045531865,34.67383242431606,33.022697546967684,31.450188139969214,29.952560133304019,28.526247746003826,27.167854996194119,25.874147615422967,24.642045348021878,23.468614617163688,22.3510615401559]
["Rice+plantain 8y fallow",302.35101788309083,"Cyclical",-126.25396825396824,143.43159486016629,99.456502177590593,0,0,0,0,0,0,0,0,-24.816387603446568,83.86148291537593,58.150156988217397,0,0,0,0,0,0,0,0,-14.509627861676615,49.03207221269642,33.999192448135673,0,0,0,0,0]
["Rice+plantain 4y fallow",409.2379796103105,"Cyclical",-126.25396825396824,143.43159486016629,99.456502177590593,0,0,0,0,-49.115976371215062,101.93415661790768,70.681879257659418,0,0,0,0,-34.905807418134735,72.442702010906757,50.232291966930035,0,0,0,0,-24.806905645185861,51.483675823331232,35.699152070542461,0,0,0,0,-17.629804700333104,36.58848721411303]
["Improved pasture",617.95255292482477,"Direct",-593.33333333333326,76.19047619047619,72.562358276643977,69.10700788251809,65.816197983350548,62.682093317476721,59.697231730930199,56.854506410409726,54.14714896229497,51.568713297423784,49.113060283260744,46.774343126914999,44.546993454204753,42.42570805162358,40.405436239641496,38.481367847277617,36.64892175931201,34.903735008868587,33.241652389398652,31.658716561332049,30.151158629840047,28.715389171276239,27.347989686929747,26.045704463742616,24.805432822612016,23.624221735820967,22.499258796019966,21.427865520019019,20.407490971446681,19.435705687092085]
["Traditional pasture",335.97288738561423,"Direct",-356.19047619047615,43.537414965986393,41.464204729510847,39.489718790010336,37.609255990486027,35.818339038558129,34.112703846245829,32.488289377376987,30.941227978454268,29.467836169956446,28.064605876148995,26.728196072522856,25.455424830974145,24.243261743784906,23.088820708366569,21.989353055587209,20.942241005321151,19.944991433639192,18.99522993679923,18.090695177904028,17.229233502765741,16.40879381215785,15.627422678245569,14.88325969356721,14.17453304149258,13.49955527761198,12.856719312011409,12.244494582868011,11.661423412255246,11.106117535481191]
[]
["w/Charcoal",{"$f":"NPV($B$18,D45:AG45)","v":342.74829931972783},"Conversion",{"$f":"D10/((1+$B$18)^(D$1))","v":359.88571428571424}]
["Charcoal+oil palm",244.0137146888307,"Direct",{"$f":"D11/((1+$B$18)^(D$1))","v":8.0761904761904937},{"$f":"E11/((1+$B$18)^(E$1))","v":-63.492063492063487},-60.468631897203316,-57.589173235431737,36.086081122871356,42.808884874250055,48.809593753336749,54.688620451917934,52.084400430398027,49.604190886093356,47.242086558184148,44.992463388746813,42.849965132139815,40.809490602037933,38.866181525750399,37.015410976905144,35.252772358957273,33.574068913292642,31.975303726945373,30.452670216138454,-162.95983354699266,-6.4951475506458163,-6.1858548101388706,-5.8912902953703536,50.815700953750898,47.597181982980239,48.855533385643348,51.018727428616714,48.589264217730189,46.275489731171632]
["Charcoal+rice+plantain 8y fallow ",519.06140735728945,"Direct",{"$f":"D12/((1+$B$18)^(D$1))","v":233.63174603174602},143.43159486016629,99.456502177590593,0,0,0,0,0,0,0,0,-24.816387603446568,83.86148291537593,58.150156988217397,0,0,0,0,0,0,0,0,-14.509627861676615,49.03207221269642,33.999192448135673,0,0,0,0,0]
["w/Timber",408.16326530612241,"Conversion",{"$f":"D13/((1+$B$18)^(D$1))","v":428.57142857142856}]
["Timber+improved pasture",542.53260457573936,"Direct",{"$f":"D14/((1+$B$18)^(D$1))","v":-164.76190476190476},{"$f":"E14/((1+$B$18)^(E$1))","v":76.19047619047619},72.562358276643977,69.10700788251809,65.816197983350548,62.682093317476721,59.697231730930199,56.854506410409726,54.14714896229497,51.568713297423784,49.113060283260744,46.774343126914999,44.546993454204753,42.42570805162358,40.405436239641496,38.481367847277617,36.64892175931201,34.903735008868587,33.241652389398652,31.658716561332049,30.151158629840047,28.715389171276239,27.347989686929747,26.045704463742616,24.805432822612016,23.624221735820967,22.499258796019966,21.427865520019019,20.407490971446681,19.435705687092085]
["NTFP collection",9.233799768326886,"Forest harvest",{"$f":"D16/((1+$B$18)^(D$1))","v":0.95238095238095233},0.90702947845804982,0.86383759853147601,0.82270247479188197,0.78352616646845896,0.74621539663662761,0.71068133013012147,0.67683936202868722,0.64460891621779726,0.61391325354075932,0.5846792890864374,0.5568374181775595,0.53032135064529462,0.50506795299551888,0.48101709809097021,0.45811152199140021,0.43629668761085727,0.41552065486748313,0.39573395701665059,0.37688948287300061,0.35894236464095297,0.3418498710866219,0.32557130579678267,0.31006791028265024,0.29530277169776209,0.28124073495024959,0.2678483190002377,0.25509363714308358,0.24294632108865097,0.23137744865585813]

{"sheet":"OppCost Intro","index":10,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Introduction to opportunity costs"]
["Land use changes in tropical forest margins affect both carbon stocks and profitability. Generally, C stocks decrease "]
["emitting CO2 in the process. At the same time, human changes to land typically increases its profitability."]
[]
[null,null,null,null,null,"If we look at a pairwise comparison of 'logged forest' that is converted to"]
[null,null,null,null,null,"extensive agriculture, a substantial loss in C stock, from"]
[null,null,null,null,null,{"$f":"Tradeoffs!B12","v":200},"  to ",{"$f":"Tradeoffs!B14","v":15},"Mg C/ha","will lead to CO2 emissions of ",null,null,{"$f":"F7-H7","v":185},"tC/ha or"]
[null,null,null,null,null,{"$f":"44/12*(F7-H7)","v":678.33333333333326},"t CO2/ha. (Note that emissions are counted as CO2 and "]
[null,null,null,null,null,"stocks as C, the difference is (12+2*16)/12). "]
[null,null,null,null,null,"Meanwhile, profitability expressed as discounted future revenue flow (Net Present Value or NPV) "]
[null,null,null,null,null,"in $/ha, increased from",null,null,{"$f":"Tradeoffs!C12","v":200},"  to ",{"$f":"Tradeoffs!C14","v":600},"$/ha. To avoid these CO2 emissions"]
[null,null,null,null,null," (because they contribute to global warming), compensation is needed to off-set"]
[null,null,null,null,null,"an 'opportunity cost' for those who can no longer convert forest land to agricultural use, of"]
[null,null,null,null,null,{"$f":"(K11-I11)/F8","v":0.58968058968058978},"$/tCO2e."]
[]
[]
[]
["Knowing the basic numbers of the current levels of emissions and the economic consequences"]
["of land use change that cause emissions (or lead to the net sequestration of C and increase in C stocks) is essential information"]
["for all engaged in the carbon-related discussions. "]
[]
["The opportunity costs differ from country to country, and region to region. Rather than using 'standard' numbers."]
["as in the previous example, we need to have methods to derive good estimates for any set of conditions. This set of worksheets"]
["is designed to help you achieve that."]

{"sheet":"OppCost","index":11,"n_rows":68,"n_cols":32,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Opportunity cost estimate worksheet (national level)",null,null,null,null,null,null,"Land use distribution"]
["Data inputs:  ",null,null,"Outputs: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate calculations",null,null,null,null,null,null,"Sorted","Cumulative"]
["1. Land uses (LU) initial & changes",null,null,"1. Final land use estimates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"and Macro results",null,null,"Emissions","Abs value","OpCost","Emissions","OppCost","Emissions"]
["2. C stock per LU",null,null,"2.Opportunity cost curve",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B45","v":0},{"$f":"ABS(X4)","v":0},{"$f":"B37","v":0},0,-0.77922077922077937,{"$f":"AA4","v":0}]
["3. Profit per LU",null,null,"3. National level summary ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B46","v":0},{"$f":"ABS(X5)","v":0},{"$f":"B38","v":-1.4727272727272729},171.11111111111111,-0.77922077922077937,{"$f":"AC4+AA5","v":171.11111111111111}]
["4. Workdays per LU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B47","v":0},0,{"$f":"B39","v":-1.2352941176470589},0,0,{"$f":"AC5+AA6","v":171.11111111111111}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B48","v":0},0,{"$f":"B40","v":-0.64772727272727271},0,0,171.11111111111111]
["All numbers in yellow cells are parameters that you can change",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C45","v":305.55555555555554},305.55555555555554,{"$f":"C37","v":1.4727272727272729},0,0,171.11111111111111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C46","v":0},0,{"$f":"C38","v":0},0,0,171.11111111111111]
["Land use legend","Time-averaged C stock ","Profit-ability ","Employment ",null,null,null,"Land use change matrix","Final landuse",{"$f":"A12","v":"Natural forest"},{"$f":"A13","v":"Logged forest"},{"$f":"A14","v":"Agro-forestry"},{"$f":"A15","v":"Extensive agriculture"},"Inconsis-tency check",null,null,null,null,null,null,null,null,null,{"$f":"C47","v":0},0,{"$f":"C39","v":-1.1363636363636365},0,0.5844155844155845,171.11111111111111]
[null,"(Mg C/ha)","(NPV, $/ha)","(workdays/year)",null,null,null,"Initial landuse",null,{"$f":"SUM(J12:J15)","v":0.15},{"$f":"SUM(K12:K15)","v":0.25},{"$f":"SUM(L12:L15)","v":0.30000000000000004},{"$f":"SUM(M12:M15)","v":0.30000000000000004},null,null,null,null,null,null,null,null,null,null,{"$f":"C48","v":0},0,{"$f":"C40","v":-0.43062200956937802},684.44444444444446,0.5844155844155845,855.55555555555554]
["Natural forest",250,30,5,null,null,null,{"$f":"A37","v":"Natural forest"},0.4,0.15,0.25,0,0,{"$f":"J12+K12+L12+M12-I12","v":0},null,null,null,null,null,null,null,null,null,{"$f":"D45","v":0},0,{"$f":"D37","v":1.2352941176470589},0,0.64772727272727271,855.55555555555554]
["Logged forest",200,300,15,null,null,null,{"$f":"A38","v":"Logged forest"},0.3,0,0,0.1,0.2,{"$f":"J13+K13+L13+M13-I13","v":0},null,null,null,null,null,null,null,null,null,{"$f":"D46","v":293.33333333333331},293.33333333333331,{"$f":"D38","v":1.1363636363636365},0,0.64772727272727271,855.55555555555554]
["Agro-forestry",80,800,120,null,null,null,{"$f":"A39","v":"Agro-forestry"},0.1,0,0,0.1,0,{"$f":"J14+K14+L14+M14-I14","v":0},null,null,null,null,null,null,null,null,null,{"$f":"D47","v":0},0,{"$f":"D39","v":0},0,0.73636363636363644,855.55555555555554]
["Extensive agriculture",10,600,100,null,null,null,{"$f":"A40","v":"Extensive agriculture"},0.2,0,0,0.1,0.1,{"$f":"J15+K15+L15+M15-I15","v":0},null,null,null,null,null,null,null,null,null,{"$f":"D48","v":-171.11111111111111},171.11111111111111,{"$f":"D40","v":-0.77922077922077937},611.11111111111109,0.73636363636363644,1466.6666666666665]
[null,null,null,null,null,null,null,"LU change (%/year)",{"$f":"SUM(I12:I15)","v":1},{"$f":"100*(1-J11/$I12)/$B$19","v":2.0833333333333335},{"$f":"100*(1-K11/$I12)/$B$19","v":1.25},{"$f":"100*(1-L11/$I12)/$B$19","v":0.83333333333333293},{"$f":"100*(1-M11/$I12)/$B$19","v":0.83333333333333293},null,null,null,null,null,null,null,null,null,null,{"$f":"E45","v":0},0,{"$f":"E37","v":0.64772727272727271},0,1.2352941176470589,1466.6666666666665]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E46","v":928.88888888888891},928.88888888888891,{"$f":"E38","v":0.43062200956937802},0,1.2352941176470589,1466.6666666666665]
[null,null,null,null,null,null,null,"Opportunity cost curves",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E47","v":0},0,{"$f":"E39","v":0.77922077922077937},0,1.9480519480519483,1466.6666666666665]
["Period of analysis",30,"years",null,null,null,null,null,"Original",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E48","v":0},0,{"$f":"E40","v":0},171.11111111111111,1.9480519480519483,1637.7777777777776]
["Size of country",2000000,"km2"]
["Total population",1000000]
["Pop working age",0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ordered results from macro program (needed for cumulative emissions curve)"]
["Workdays / year",230,"days",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"scenario 1",null,"scenario 2"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"original",null,"logged forest",null,"logged forest"]
["CO2/C conversion",{"$f":"(2*16+12)/12","v":3.6666666666666665},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$300 -> 400",null,"200 -> 150tC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OppCost","Emission","OppCost","Emission","OppCost","Emission"]
["Performance at national scale:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.77922077922077937,0,-0.77922077922077937,0,-0.77922077922077937,0]
["Total LU-based emission, Pg CO2e/yr",null,{"$f":"SUM(C54:G61)/1000","v":3.6250000000000002E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-0.77922077922077937,171.11111111111111,-0.77922077922077937,171.11111111111111,-0.77922077922077937,171.11111111111111]
["Total C stock in land use, Pg C",null,{"$f":"(I12*B12+I13*B13+I14*B14+I15*B15)*100*B20/10^9","v":34},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,171.11111111111111,0,171.11111111111111,0,171.11111111111111]
["Total NPV of land uses (M$)",null,{"$f":"(I12*C12+I13*C13+I14*C14+I15*C15)*B20/10^4","v":60400},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,171.11111111111111,0,171.11111111111111,0,171.11111111111111]
["Total rural employment",null,{"$f":"(I12*D12+I13*D13+I14*D14+I15*D15)*B20/(B21*B22*B23)","v":0.55797101449275366},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,171.11111111111111,0,171.11111111111111,0,171.11111111111111]
["Emissions as percentage of C stock",null,{"$f":"100*(C28/B25)/C29","v":2.9077540106951872E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,171.11111111111111,0,171.11111111111111,0,171.11111111111111]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43062200956937802,171.11111111111111,0.28708133971291866,171.11111111111111,0.5844155844155845,171.11111111111111]
["(vertical axis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.43062200956937802,1100,0.28708133971291866,1100,0.5844155844155845,855.55555555555554]
["Opportunity costs of land uses changes: $ per tCO2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64772727272727271,1100,0.64772727272727271,1100,0.64772727272727271,855.55555555555554]
["Initial    \\ Final",{"$f":"J10","v":"Natural forest"},{"$f":"K10","v":"Logged forest"},{"$f":"L10","v":"Agro-forestry"},{"$f":"M10","v":"Extensive agriculture"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.64772727272727271,1100,0.64772727272727271,1100,0.64772727272727271,855.55555555555554]
[{"$f":"A12","v":"Natural forest"},{"$f":"IF($B12<>B$41,-($C12-B$42)/(44/12*($B12-B$41)),0)","v":0},{"$f":"IF($B12<>C$41,-($C12-C$42)/(44/12*($B12-C$41)),0)","v":1.4727272727272729},{"$f":"IF($B12<>D$41,-($C12-D$42)/(44/12*($B12-D$41)),0)","v":1.2352941176470589},{"$f":"IF($B12<>E$41,-($C12-E$42)/(44/12*($B12-E$41)),0)","v":0.64772727272727271},null,null,null,"Scenario 2 Logged forest $300 -> $400 NPV/ha",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1363636363636365,1100,0.90909090909090906,1100,0.73636363636363644,855.55555555555554]
[{"$f":"A13","v":"Logged forest"},{"$f":"IF($B13<>B$41,($C13-B$42)/(44/12*($B13-B$41)),0)","v":-1.4727272727272729},{"$f":"IF($B13<>C$41,-($C13-C$42)/(44/12*($B13-C$41)),0)","v":0},{"$f":"IF($B13<>D$41,-($C13-D$42)/(44/12*($B13-D$41)),0)","v":1.1363636363636365},{"$f":"IF($B13<>E$41,-($C13-E$42)/(44/12*($B13-E$41)),0)","v":0.43062200956937802},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.1363636363636365,1393.3333333333333,0.90909090909090906,1393.3333333333333,0.73636363636363644,1466.6666666666665]
[{"$f":"A14","v":"Agro-forestry"},{"$f":"IF($B14<>B$41,($C14-B$42)/(44/12*($B14-B$41)),0)","v":-1.2352941176470589},{"$f":"IF($B14<>C$41,($C14-C$42)/(44/12*($B14-C$41)),0)","v":-1.1363636363636365},{"$f":"IF($B14<>D$41,-($C14-D$42)/(44/12*($B14-D$41)),0)","v":0},{"$f":"IF($B14<>E$41,($C14-E$42)/(44/12*($B14-E$41)),0)","v":0.77922077922077937},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2352941176470589,1393.3333333333333,1.2352941176470589,1393.3333333333333,1.2352941176470589,1466.6666666666665]
[{"$f":"A15","v":"Extensive agriculture"},{"$f":"IF($B15<>B$41,($C15-B$42)/(44/12*($B15-B$41)),0)","v":-0.64772727272727271},{"$f":"IF($B15<>C$41,($C15-C$42)/(44/12*($B15-C$41)),0)","v":-0.43062200956937802},{"$f":"IF($B15<>D$41,-($C15-D$42)/(44/12*($B15-D$41)),0)","v":-0.77922077922077937},{"$f":"IF($B15<>E$41,-($C15-E$42)/(44/12*($B15-E$41)),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.2352941176470589,1393.3333333333333,1.2352941176470589,1393.3333333333333,1.2352941176470589,1466.6666666666665]
["Carbon ",{"$f":"B12","v":250},{"$f":"B13","v":200},{"$f":"B14","v":80},{"$f":"B15","v":10},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4727272727272729,1393.3333333333333,2.0181818181818185,1393.3333333333333,1.9480519480519483,1466.6666666666665]
["NPV Profits",{"$f":"C12","v":30},{"$f":"C13","v":300},{"$f":"C14","v":800},{"$f":"C15","v":600},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4727272727272729,1698.8888888888887,2.0181818181818185,1698.8888888888887,1.9480519480519483,1637.7777777777776]
["(horizontal axis)"]
["Emissions, Tg CO2e/yr",null,null,null,null,null,null,null," "," "," "," "]
[{"$f":"H12","v":"Natural forest"},{"$f":"(($B12-B$41)*$B$25*J12*100*$B$20/10^6)/$B$19","v":0},305.55555555555554,0,0]
[{"$f":"H13","v":"Logged forest"},0,0,293.33333333333331,928.88888888888891]
[{"$f":"H14","v":"Agro-forestry"},0,0,0,0]
[{"$f":"H15","v":"Extensive agriculture"},0,0,-171.11111111111111,0]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Scenario 2 Logged forest 200 -> 150tc/ha"]
[]
["Intermediate calculations"]
[]
["% change of initial LU",null,null,null,null,null,null,null," "," "," "," "]
[{"$f":"A45","v":"Natural forest"},{"$f":"J12/$I12","v":0.37499999999999994},0.625,0,0]
[{"$f":"A46","v":"Logged forest"},0,0,0.33333333333333337,0.66666666666666674]
[{"$f":"A47","v":"Agro-forestry"},0,0,1,0]
[{"$f":"A48","v":"Extensive agriculture"},0,0,0.5,0.5]
[]
["% change of final LU","Sum of changes"]
["Final land use",{"$f":"SUM(B65:B68)","v":5.6249999999999988E-2},{"$f":"SUM(C65:C68)","v":9.375E-2},{"$f":"SUM(D65:D68)","v":0.53333333333333344},{"$f":"SUM(E65:E68)","v":0.31666666666666671}]
[{"$f":"J11","v":0.15},{"$f":"B58*$A65","v":5.6249999999999988E-2},9.375E-2,0,0]
[{"$f":"K11","v":0.25},0,0,8.3333333333333343E-2,0.16666666666666669]
[{"$f":"L11","v":0.30000000000000004},0,0,0.30000000000000004,0,null," "]
[{"$f":"M11","v":0.30000000000000004},0,0,0.15000000000000002,0.15000000000000002]

{"sheet":"Tradeoffs","index":12,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Tradeoff comparisons"]
["Data inputs:  ",null,null,"Output: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Active values"]
["1. C stock per LU",null,null,"Tradeoff graphs: "]
["2. Profit per LU",null,null,"1. Profitability  v Carbon"]
["3. Workdays per LU",null,null,"2. Profitability v Employment"]
[null,null,null,"3. Employment v Carbon"]
[]
[]
["Land use legend","Time-averaged C stock ","Profitability ","Rural employment "]
[null,"(Mg C/ha)","(NPV, $/ha)","(workdays/year)"]
["Natural forest",250,2,5]
["Logged forest",200,200,15]
["Agro-forestry",80,800,120]
["Extensive agriculture",15,600,100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[" "]
[" "]
[" "]

{"sheet":"Eligibility filter","index":13,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,3,3,4]]}
["At the current stage of international negotiations, it is not yet clear what the 'eligibility rules' will be. "]
["Here you can see the consequences of the various possible outcomes."]
[null,"Please make your choice here"]
[null,"Effective forest definition",7,{"$f":"IF(C4<7,\"Stricter than Kyoto\",IF(C4=7,\"Kyoto forest\",IF(OR(C4<=1,C4>11),\"Out of range\",\"\")))","v":"Kyoto forest"},null,{"$f":"CONCATENATE(\"First class of 'non-forest' is: \",INDEX($B$10:$B$20,MATCH($C$4+1,$A$10:$A$20)))","v":"First class of 'non-forest' is: Improved pastures"}]
[null,"# of D's",2,{"$f":"IF(OR(C5<1,C5>2),\"Out of range\",\"\")","v":""},null,{"$f":"CONCATENATE(\"Last class of 'forest' is: \",INDEX($B$10:$B$20,MATCH($C$4,$A$10:$A$20)))","v":"Last class of 'forest' is: Oil palm "},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"This landscape had \",P23,\" % forest which contains \",Q23*[2]OpCost2!B28*100/10^9, \" Pg C\")","v":"This landscape had 81.01 % forest which contains 25.0412 Pg C"}]
[null,"# of +'s",2,{"$f":"IF(OR(C6<0,C6>2),\"Out of range\",\"\")","v":""},{"$f":"CONCATENATE(\"You chose: \",IF(C5=1,\"RED\",IF(AND(C5=2,C6=0),\"REDD\",IF(AND(C5=2,C6=1),\"REDD+\",IF(AND(C5=2,C6=2),\"REDD++/AFOLU accounting\")))))","v":"You chose: REDD++/AFOLU accounting"},null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE([2]OpCost2!B27,\" years later, this landscape had \",P24,\" % forest which contains \",Q24*[2]OpCost2!B28/10^7,\" PgC\")","v":"30 years later, this landscape had 78.01 % forest which contains 21.3112 PgC"}]
[null,null,{"$f":"IF(C8<=$C$4,1,0)","v":1},{"$f":"IF(D8<=$C$4,1,0)","v":1},1,1,1,1,1,0,0,0,0]
[null,null,1,2,3,4,5,6,7,8,9,10,11,null,null," "]
[null,null,"Natural forest","Logged forest","Heavily logged forest","Agroforest 1","Agroforest 2","Cocoa","Oil palm ","Improved pastures","Low productivity pastures","Extensive crops","Intensive crops"]
[1,"Natural forest",{"$f":"IF(C$8=$A10,0,IF(AND($C$5=1,$A10<=$C$4,C$8>$C$4),1,IF(AND($C$5=2,$C$6=0,$A10<=$C$4,C$8>$A10),1,IF(AND($C$5=2,$C$6=1,$A10<=$C$4),1,IF(AND($C$5=2,$C$6=2),1,0)))))","v":0},1,1,1,1,1,1,1,1,1,1,{"$f":"IF(A10<=$C$4,1,0)","v":1}]
[2,"Logged forest",1,0,1,1,1,1,1,1,1,1,1,{"$f":"IF(A11<=$C$4,1,0)","v":1}]
[3,"Heavily logged forest",1,1,0,1,1,1,1,1,1,1,1,1]
[4,"Agroforest 1",1,1,1,0,1,1,1,1,1,1,1,1]
[5,"Agroforest 2",1,1,1,1,0,1,1,1,1,1,1,1]
[6,"Cocoa",1,1,1,1,1,0,1,1,1,1,1,1]
[7,"Oil palm ",1,1,1,1,1,1,0,1,1,1,1,1,{"$f":"IF(P24<P23,CONCATENATE(\"Deforestation affected \",-100*(P24-P23)/P23,\" % of the forest.\"),CONCATENATE(\"Forest cover increased by \", P24-P23,\" %\"))","v":"Deforestation affected 3.70324651277618 % of the forest."}]
[8,"Improved pastures",1,1,1,1,1,1,1,0,1,1,1,0,{"$f":"CONCATENATE(\"Eligible emissions are \",P25,\" which is \",100*P25/P26,\"%  of the total net emissions.\")","v":"Eligible emissions are 455.155555555555 which is 100%  of the total net emissions."}]
[9,"Low productivity pastures",1,1,1,1,1,1,1,1,0,1,1,0]
[10,"Extensive crops",1,1,1,1,1,1,1,1,1,0,1,0]
[11,"Intensive crops",1,1,1,1,1,1,1,1,1,1,0,0]
[null," "]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,"% cover","C stock"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before",{"$f":"100*(C7*[2]OpCost2!H12+D7*[2]OpCost2!H13+E7*[2]OpCost2!H14+F7*[2]OpCost2!H15+G7*[2]OpCost2!H16+H7*[2]OpCost2!H17+I7*[2]OpCost2!H18+J7*[2]OpCost2!H19+K7*[2]OpCost2!H20+L7*[2]OpCost2!H21+M7*[2]OpCost2!H22)","v":81.009999999999991},{"$f":"C7*[2]OpCost2!H12*[2]OpCost2!B12+D7*[2]OpCost2!H13*[2]OpCost2!B13+E7*[2]OpCost2!H14*[2]OpCost2!B14+F7*[2]OpCost2!H15*[2]OpCost2!B15+G7*[2]OpCost2!H16*[2]OpCost2!B16+H7*[2]OpCost2!H17*[2]OpCost2!B17+I7*[2]OpCost2!H18*[2]OpCost2!B18+J7*[2]OpCost2!H19*[2]OpCost2!B19+K7*[2]OpCost2!H20*[2]OpCost2!B20+L7*[2]OpCost2!H21*[2]OpCost2!B21+M7*[2]OpCost2!H22*[2]OpCost2!B22","v":125.206},{"$f":"100*Q23/P23","v":154.556227626219}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After",{"$f":"100*(C7*[2]OpCost2!I11+D7*[2]OpCost2!J11+E7*[2]OpCost2!K11+F7*[2]OpCost2!L11+G7*[2]OpCost2!M11+H7*[2]OpCost2!N11+I7*[2]OpCost2!O11+J7*[2]OpCost2!P11+K7*[2]OpCost2!Q11+L7*[2]OpCost2!R11+M7*[2]OpCost2!S11)","v":78.010000000000005},{"$f":"C7*[2]OpCost2!I11*[2]OpCost2!B12+D7*[2]OpCost2!J11*[2]OpCost2!B13+E7*[2]OpCost2!K11*[2]OpCost2!B14+F7*[2]OpCost2!L11*[2]OpCost2!B15+G7*[2]OpCost2!M11*[2]OpCost2!B16+H7*[2]OpCost2!N11*[2]OpCost2!B17+I7*[2]OpCost2!O11*[2]OpCost2!B18+J7*[2]OpCost2!P11*[2]OpCost2!B19+K7*[2]OpCost2!Q11*[2]OpCost2!B20+L7*[2]OpCost2!R11*[2]OpCost2!B21+M7*[2]OpCost2!S11*[2]OpCost2!B22","v":106.556},{"$f":"100*Q24/P24","v":136.59274451993335}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eligible",{"$f":"SUM([2]OpCost2!Y3:Y125)","v":455.1555555555554}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Net",{"$f":"SUM([2]OpCost2!W3:W125)","v":455.1555555555554}]