{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Exp planification","Costs by categories","Chart"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Exp planification","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["Costing Exercise"]
[null,"Activity structure",2016,"Q1","Q2","Q3","Q4",2017,2018,"Total 2016-2018"]
["Program 1 Improve the sustainable management and use of existing conservation areas and establish more conservation areas throughout the nation ",null,{"$f":"SUM(D3:G3)","v":41000},{"$f":"D4","v":20000},{"$f":"E4","v":15000},1000,5000,10000,15000,{"$f":"C3+H3+I3","v":66000}]
["Sub-program 1.1 Increase the number of new conservation areas throughout the nation",null,{"$f":"SUM(D4:G4)","v":41000},{"$f":"D5","v":20000},{"$f":"E5","v":15000},1000,5000,10000,15000,{"$f":"C4+H4+I4","v":66000}]
["Action 1.1.1 Establish protected areas throughout the nation to enhance biodiversity in Tuvalu  \n",null,41000,{"$f":"SUM(D6:D12)","v":20000},{"$f":"SUM(E6:E12)","v":15000},{"$f":"SUM(F6:F12)","v":1000},{"$f":"SUM(G6:G12)","v":5000},{"$f":"SUM(H6:H12)","v":10000},{"$f":"SUM(I6:I12)","v":15000},{"$f":"C5+H5+I5","v":66000}]
[null,"Activity1: Identify new potential areas for protection",20000,20000,null,null,null,null,null,20000]
[null,"Activity2: Assess the biodiversity of potential areas and select two high priority sites",{"$f":"SUM(D7:G7)","v":10000},null,10000,null,null,null,null,10000]
[null,"Activity3: Collect baseline information on landuse & socio-economic conditions",5000,null,5000,null,null,null,null,5000]
[null,"Activity4: Consult local communities about proposed protected sites",1000,null,null,1000,null,null,null,1000]
[null,"Activity5: Review management plans, including M & E ",5000,null,null,null,5000,null,null,5000]
[null,"Activity6: Develop communication strategy",0,null,null,null,null,10000,null,{"$f":"C11+H11+I11","v":10000}]
[null,"Activity7: Formalise and map new areas ",0,null,null,null,null,null,15000,15000]

{"sheet":"Costs by categories","index":1,"n_rows":15,"n_cols":19,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,1,2,5],[2,7,2,11],[2,13,2,17]]}
[]
["Sub-division of costs by categories"]
[null,2016,null,null,null,null,null,2017,null,null,null,null,null,2018]
["Categories of expenses","Salary","Operating Exp","Transfert","Investissement","Total","Validation","Salary","Operating Exp","Transfert","Investissement","Total","Validation","Salary","Operating Exp","Transfert","Investissement","Total","Validation"]
["Sum by Expenses",{"$f":"B6","v":16700},{"$f":"C6","v":24300},0,0,{"$f":"F6","v":41000},null,{"$f":"H6","v":6000},{"$f":"I6","v":14000},{"$f":"J6","v":0},{"$f":"K6","v":0},{"$f":"L6","v":10000},null,{"$f":"N6","v":5000},{"$f":"O6","v":10000},{"$f":"P6","v":0},{"$f":"Q6","v":0},{"$f":"R6","v":15000}]
[{"$f":"'Exp planification'!A3","v":"Program 1 Improve the sustainable management and use of existing conservation areas and establish more conservation areas throughout the nation "},{"$f":"B7","v":16700},{"$f":"C7","v":24300},{"$f":"D7","v":0},{"$f":"E7","v":0},{"$f":"'Exp planification'!C3","v":41000},{"$f":"IF((B6+C6+D6+E6)=0,0,F6-SUM(B6:E6))","v":0},{"$f":"H7","v":6000},{"$f":"I7","v":14000},{"$f":"J7","v":0},{"$f":"K7","v":0},{"$f":"'Exp planification'!H3","v":10000},{"$f":"IF((H6+I6+J6+K6)=0,0,L6-SUM(H6:K6))","v":-10000},{"$f":"N7","v":5000},{"$f":"O7","v":10000},{"$f":"P7","v":0},{"$f":"Q7","v":0},{"$f":"'Exp planification'!I3","v":15000},{"$f":"IF((N6+O6+P6+Q6)=0,0,R6-SUM(N6:Q6))","v":0}]
[{"$f":"'Exp planification'!A4","v":"Sub-program 1.1 Increase the number of new conservation areas throughout the nation"},{"$f":"B8+B14","v":16700},{"$f":"C8+C14","v":24300},{"$f":"D8+D14","v":0},0,{"$f":"'Exp planification'!C4","v":41000},{"$f":"IF((B7+C7+D7+E7)=0,0,F7-SUM(B7:E7))","v":0},{"$f":"H8+H14","v":6000},{"$f":"I8+I14","v":14000},{"$f":"J8+J14","v":0},{"$f":"K8+K14","v":0},{"$f":"'Exp planification'!H4","v":10000},{"$f":"IF((H7+I7+J7+K7)=0,0,L7-SUM(H7:K7))","v":-10000},{"$f":"N8+N14","v":5000},{"$f":"O8+O14","v":10000},{"$f":"P8+P14","v":0},{"$f":"Q8+Q14","v":0},{"$f":"'Exp planification'!I4","v":15000},{"$f":"IF((N7+O7+P7+Q7)=0,0,R7-SUM(N7:Q7))","v":0}]
[{"$f":"'Exp planification'!A5","v":"Action 1.1.1 Establish protected areas throughout the nation to enhance biodiversity in Tuvalu  \n"},{"$f":"SUM(B9:B15)","v":16700},{"$f":"SUM(C9:C15)","v":24300},{"$f":"SUM(D9:D15)","v":0},{"$f":"SUM(E9:E15)","v":0},{"$f":"'Exp planification'!C5","v":41000},{"$f":"IF((B8+C8+D8+E8)=0,0,F8-SUM(B8:E8))","v":0},{"$f":"SUM(H9:H15)","v":3000},{"$f":"SUM(I9:I15)","v":7000},{"$f":"SUM(J9:J15)","v":0},{"$f":"SUM(K9:K15)","v":0},{"$f":"'Exp planification'!H5","v":10000},{"$f":"IF((H8+I8+J8+K8)=0,0,L8-SUM(H8:K8))","v":0},{"$f":"SUM(N9:N15)","v":5000},{"$f":"SUM(O9:O15)","v":10000},{"$f":"SUM(P9:P15)","v":0},{"$f":"SUM(Q9:Q15)","v":0},{"$f":"'Exp planification'!I5","v":15000},{"$f":"IF((N8+O8+P8+Q8)=0,0,R8-SUM(N8:Q8))","v":0}]
[{"$f":"'Exp planification'!B6","v":"Activity1: Identify new potential areas for protection"},5000,15000,null,null,{"$f":"'Exp planification'!C6","v":20000},0,null,null,null,null,{"$f":"'Exp planification'!H6","v":0},0,null,null,null,null,{"$f":"'Exp planification'!I6","v":0},0]
[{"$f":"'Exp planification'!B7","v":"Activity2: Assess the biodiversity of potential areas and select two high priority sites"},8000,2000,null,null,{"$f":"'Exp planification'!C7","v":10000},0,null,null,null,null,{"$f":"'Exp planification'!H7","v":0},0,null,null,null,null,{"$f":"'Exp planification'!I7","v":0},0]
[{"$f":"'Exp planification'!B8","v":"Activity3: Collect baseline information on landuse & socio-economic conditions"},2500,2500,null,null,{"$f":"'Exp planification'!C8","v":5000},0,null,null,null,null,{"$f":"'Exp planification'!H8","v":0},0,null,null,null,null,{"$f":"'Exp planification'!I8","v":0},0]
[{"$f":"'Exp planification'!B9","v":"Activity4: Consult local communities about proposed protected sites"},200,800,null,null,{"$f":"'Exp planification'!C9","v":1000},0,null,null,null,null,{"$f":"'Exp planification'!H9","v":0},0,null,null,null,null,{"$f":"'Exp planification'!I9","v":0},0]
[{"$f":"'Exp planification'!B10","v":"Activity5: Review management plans, including M & E "},1000,4000,null,null,{"$f":"'Exp planification'!C10","v":5000},0,null,null,null,null,{"$f":"'Exp planification'!H10","v":0},0,null,null,null,null,{"$f":"'Exp planification'!I10","v":0},0]
[{"$f":"'Exp planification'!B11","v":"Activity6: Develop communication strategy"},null,null,null,null,{"$f":"'Exp planification'!C11","v":0},0,3000,7000,null,null,{"$f":"'Exp planification'!H11","v":10000},0,null,null,null,null,{"$f":"'Exp planification'!I11","v":0},0]
[{"$f":"'Exp planification'!B12","v":"Activity7: Formalise and map new areas "},null,null,null,null,{"$f":"'Exp planification'!C12","v":0},{"$f":"IF((B15+C15+D15+E15)=0,0,F15-SUM(B15:E15))","v":0},0,0,null,null,{"$f":"'Exp planification'!H12","v":0},0,5000,10000,null,null,{"$f":"'Exp planification'!I12","v":15000},0]

{"sheet":"Chart","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,6],[0,1,0,6]]}
[2,"Expenses by categories from 2016-2018"]
[]
[null,"Expenses by categories"]
[null,"Categories/years",2016,{"$f":"C4+1","v":2017},{"$f":"D4+1","v":2018},"Total","%"]
[null,"Salary",{"$f":"'Costs by categories'!B5","v":16700},{"$f":"'Costs by categories'!H5","v":6000},{"$f":"'Costs by categories'!N5","v":5000},{"$f":"SUM(C5:E5)","v":27700},{"$f":"F5/$F$9","v":0.36447368421052634}]
[null,"Operating Exp",{"$f":"'Costs by categories'!C5","v":24300},{"$f":"'Costs by categories'!I5","v":14000},{"$f":"'Costs by categories'!O5","v":10000},{"$f":"SUM(C6:E6)","v":48300},{"$f":"F6/$F$9","v":0.63552631578947372}]
[null,"Transfert",{"$f":"'Costs by categories'!D5","v":0},{"$f":"'Costs by categories'!J5","v":0},{"$f":"'Costs by categories'!P5","v":0},{"$f":"SUM(C7:E7)","v":0},{"$f":"F7/$F$9","v":0}]
[null,"Investissement",{"$f":"'Costs by categories'!E5","v":0},{"$f":"'Costs by categories'!K5","v":0},{"$f":"'Costs by categories'!Q5","v":0},{"$f":"SUM(C8:E8)","v":0},{"$f":"F8/$F$9","v":0}]
[null,"TOTAL expenses",{"$f":"SUM(C5:C8)","v":41000},{"$f":"SUM(D5:D8)","v":20000},{"$f":"SUM(E5:E8)","v":15000},{"$f":"SUM(F5:F8)","v":76000},{"$f":"F9/$F$9","v":1}]