{"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":805000},{"$f":"D4","v":50000},{"$f":"E4","v":300000},325000,130000,1280000,1600000,{"$f":"C3+H3+I3","v":3685000}]
["Sub-program 1.1 Increase the number of new conservation areas throughout the nation",null,{"$f":"SUM(D4:G4)","v":805000},{"$f":"D5","v":50000},300000,325000,130000,1280000,1600000,{"$f":"C4+H4+I4","v":3685000}]
["Action 1.1.1 Establish protected areas throughout the nation to enhance biodiversity in Tuvalu  \n",null,805000,{"$f":"SUM(D6:D12)","v":50000},300000,325000,130000,1280000,1600000,{"$f":"C5+H5+I5","v":3685000}]
[null,"Develop a sustainable financing mechanism to support conservation areas' management",200000,50000,50000,50000,50000,null,null,200000]
[null,"Develop critieria for site selection",250000,null,250000,null,null,null,null,250000]
[null,"Develop guidelines for conservation action planning",275000,null,null,275000,null,null,null,275000]
[null,"Develop site-based management plan",80000,null,null,null,80000,null,null,80000]
[null,"Provide financial & technical support for site management",0,null,null,null,null,1280000,1500000,2780000]
[null,"Evaluate management effectiveness",0,null,null,null,null,null,100000,100000]
[null,"Endowment",0,null,null,null,null,null,null,0]

{"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":295000},{"$f":"C6","v":435000},0,75000,{"$f":"F6","v":805000},null,{"$f":"H6","v":768000},{"$f":"I6","v":462000},{"$f":"J6","v":0},{"$f":"K6","v":50000},{"$f":"L6","v":1280000},null,{"$f":"N6","v":844800},{"$f":"O6","v":763200},{"$f":"P6","v":0},{"$f":"Q6","v":92000},{"$f":"R6","v":1600000}]
[{"$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":295000},{"$f":"C7","v":435000},{"$f":"D7","v":0},{"$f":"E7","v":75000},{"$f":"'Exp planification'!C3","v":805000},{"$f":"IF((B6+C6+D6+E6)=0,0,F6-SUM(B6:E6))","v":0},{"$f":"H7","v":768000},{"$f":"I7","v":462000},{"$f":"J7","v":0},{"$f":"K7","v":50000},{"$f":"'Exp planification'!H3","v":1280000},{"$f":"IF((H6+I6+J6+K6)=0,0,L6-SUM(H6:K6))","v":0},{"$f":"N7","v":844800},{"$f":"O7","v":763200},{"$f":"P7","v":0},{"$f":"Q7","v":92000},{"$f":"'Exp planification'!I3","v":1600000},{"$f":"IF((N6+O6+P6+Q6)=0,0,R6-SUM(N6:Q6))","v":-100000}]
[{"$f":"'Exp planification'!A4","v":"Sub-program 1.1 Increase the number of new conservation areas throughout the nation"},{"$f":"B8+B14","v":295000},{"$f":"C8+C14","v":435000},0,75000,{"$f":"'Exp planification'!C4","v":805000},{"$f":"IF((B7+C7+D7+E7)=0,0,F7-SUM(B7:E7))","v":0},{"$f":"H8+H14","v":768000},{"$f":"I8+I14","v":462000},{"$f":"J8+J14","v":0},{"$f":"K8+K14","v":50000},{"$f":"'Exp planification'!H4","v":1280000},{"$f":"IF((H7+I7+J7+K7)=0,0,L7-SUM(H7:K7))","v":0},{"$f":"N8+N14","v":844800},{"$f":"O8+O14","v":763200},{"$f":"P8+P14","v":0},{"$f":"Q8+Q14","v":92000},{"$f":"'Exp planification'!I4","v":1600000},{"$f":"IF((N7+O7+P7+Q7)=0,0,R7-SUM(N7:Q7))","v":-100000}]
[{"$f":"'Exp planification'!A5","v":"Action 1.1.1 Establish protected areas throughout the nation to enhance biodiversity in Tuvalu  \r"},{"$f":"SUM(B9:B15)","v":295000},{"$f":"SUM(C9:C15)","v":435000},{"$f":"SUM(D9:D15)","v":0},{"$f":"SUM(E9:E15)","v":75000},{"$f":"'Exp planification'!C5","v":805000},{"$f":"IF((B8+C8+D8+E8)=0,0,F8-SUM(B8:E8))","v":0},{"$f":"SUM(H9:H15)","v":768000},{"$f":"SUM(I9:I15)","v":462000},{"$f":"SUM(J9:J15)","v":0},{"$f":"SUM(K9:K15)","v":50000},{"$f":"'Exp planification'!H5","v":1280000},{"$f":"IF((H8+I8+J8+K8)=0,0,L8-SUM(H8:K8))","v":0},{"$f":"SUM(N9:N15)","v":844800},{"$f":"SUM(O9:O15)","v":663200},{"$f":"SUM(P9:P15)","v":0},{"$f":"SUM(Q9:Q15)","v":92000},{"$f":"'Exp planification'!I5","v":1600000},{"$f":"IF((N8+O8+P8+Q8)=0,0,R8-SUM(N8:Q8))","v":0}]
[{"$f":"'Exp planification'!B6","v":"Develop a sustainable financing mechanism to support conservation areas' management"},200000,null,null,null,{"$f":"'Exp planification'!C6","v":200000},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":"Develop critieria for site selection"},45000,205000,null,null,{"$f":"'Exp planification'!C7","v":250000},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":"Develop guidelines for conservation action planning"},50000,225000,null,null,{"$f":"'Exp planification'!C8","v":275000},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":"Develop site-based management plan"},null,5000,null,75000,{"$f":"'Exp planification'!C9","v":80000},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":"Provide financial & technical support for site management"},null,null,null,null,{"$f":"'Exp planification'!C10","v":0},0,768000,462000,null,50000,{"$f":"'Exp planification'!H10","v":1280000},0,844800,563200,null,92000,{"$f":"'Exp planification'!I10","v":1500000},0]
[{"$f":"'Exp planification'!B11","v":"Evaluate management effectiveness"},null,null,null,null,{"$f":"'Exp planification'!C11","v":0},0,null,null,null,null,{"$f":"'Exp planification'!H11","v":0},0,null,100000,null,null,{"$f":"'Exp planification'!I11","v":100000},0]
[{"$f":"'Exp planification'!B12","v":"Endowment"},null,null,null,null,{"$f":"'Exp planification'!C12","v":0},0,null,null,null,null,{"$f":"'Exp planification'!H12","v":0},{"$f":"IF((H15+I15+J15+K15)=0,0,L15-SUM(H15:K15))","v":0},null,null,null,null,{"$f":"'Exp planification'!I12","v":0},{"$f":"IF((N15+O15+P15+Q15)=0,0,R15-SUM(N15:Q15))","v":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":295000},{"$f":"'Costs by categories'!H5","v":768000},{"$f":"'Costs by categories'!N5","v":844800},{"$f":"SUM(C5:E5)","v":1907800},{"$f":"F5/$F$9","v":0.5040422721268164}]
[null,"Operating Exp",{"$f":"'Costs by categories'!C5","v":435000},{"$f":"'Costs by categories'!I5","v":462000},{"$f":"'Costs by categories'!O5","v":763200},{"$f":"SUM(C6:E6)","v":1660200},{"$f":"F6/$F$9","v":0.43862615587846765}]
[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":75000},{"$f":"'Costs by categories'!K5","v":50000},{"$f":"'Costs by categories'!Q5","v":92000},{"$f":"SUM(C8:E8)","v":217000},{"$f":"F8/$F$9","v":5.7331571994715981E-2}]
[null,"TOTAL expenses",{"$f":"SUM(C5:C8)","v":805000},{"$f":"SUM(D5:D8)","v":1280000},{"$f":"SUM(E5:E8)","v":1700000},{"$f":"SUM(F5:F8)","v":3785000},{"$f":"F9/$F$9","v":1}]