{"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":13,"n_cols":10,"rows_kept":13,"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":105000},{"$f":"D4","v":30000},{"$f":"E4","v":25000},25000,25000,20000,350000,{"$f":"C3+H3+I3","v":475000}]
["Sub-program 1.1 Increase the number of new conservation areas throughout the nation",null,{"$f":"SUM(D4:G4)","v":105000},{"$f":"D5","v":30000},25000,25000,25000,20000,350000,{"$f":"C4+H4+I4","v":475000}]
["Action 1.1.1 Establish protected areas throughout the nation to enhance biodiversity in Tuvalu  \n",null,105000,{"$f":"SUM(D6:D12)","v":30000},{"$f":"SUM(E6:E12)","v":25000},{"$f":"SUM(F6:F12)","v":25000},{"$f":"SUM(G6:G12)","v":25000},{"$f":"SUM(H6:H12)","v":20000},{"$f":"SUM(I6:I12)","v":350000},{"$f":"C5+H5+I5","v":475000}]
[null,"Gap analysis (bio-physical) (stakeholder consultation and consultancy",45000,30000,15000,null,null,null,null,45000]
[null,"Social feasibility study (Stakholder consultation and consultancy)",60000,null,10000,25000,25000,null,null,60000]
[null,"First legislative draft ",0,null,null,null,null,5000,null,5000]
[null,"Interministerial consultations",0,null,null,null,null,10000,null,10000]
[null,"Legistlative draft enacted; gazetting",0,null,null,null,null,5000,null,5000]
[null,"Physical infrastructure",0,null,null,null,null,null,300000,300000]
[null,"Management plans and training",0,null,null,null,null,null,50000,50000]
[null,"Note: recurrent managements cost after 2018: salaries and operating costs"]

{"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":0},{"$f":"C6","v":0},0,0,{"$f":"F6","v":105000},null,{"$f":"H6","v":0},{"$f":"I6","v":0},{"$f":"J6","v":0},{"$f":"K6","v":0},{"$f":"L6","v":20000},null,{"$f":"N6","v":0},{"$f":"O6","v":0},{"$f":"P6","v":0},{"$f":"Q6","v":0},{"$f":"R6","v":350000}]
[{"$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":0},{"$f":"C7","v":0},{"$f":"D7","v":0},{"$f":"E7","v":0},{"$f":"'Exp planification'!C3","v":105000},{"$f":"IF((B6+C6+D6+E6)=0,0,F6-SUM(B6:E6))","v":0},{"$f":"H7","v":0},{"$f":"I7","v":0},{"$f":"J7","v":0},{"$f":"K7","v":0},{"$f":"'Exp planification'!H3","v":20000},{"$f":"IF((H6+I6+J6+K6)=0,0,L6-SUM(H6:K6))","v":0},{"$f":"N7","v":0},{"$f":"O7","v":0},{"$f":"P7","v":0},{"$f":"Q7","v":0},{"$f":"'Exp planification'!I3","v":350000},{"$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":0},{"$f":"C8+C14","v":0},0,0,{"$f":"'Exp planification'!C4","v":105000},{"$f":"IF((B7+C7+D7+E7)=0,0,F7-SUM(B7:E7))","v":0},{"$f":"H8+H14","v":0},{"$f":"I8+I14","v":0},{"$f":"J8+J14","v":0},{"$f":"K8+K14","v":0},{"$f":"'Exp planification'!H4","v":20000},{"$f":"IF((H7+I7+J7+K7)=0,0,L7-SUM(H7:K7))","v":0},{"$f":"N8+N14","v":0},{"$f":"O8+O14","v":0},{"$f":"P8+P14","v":0},{"$f":"Q8+Q14","v":0},{"$f":"'Exp planification'!I4","v":350000},{"$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:B13)","v":0},{"$f":"SUM(C9:C13)","v":0},0,0,{"$f":"'Exp planification'!C5","v":105000},{"$f":"IF((B8+C8+D8+E8)=0,0,F8-SUM(B8:E8))","v":0},{"$f":"SUM(H9:H13)","v":0},{"$f":"SUM(I9:I13)","v":0},{"$f":"SUM(J9:J13)","v":0},{"$f":"SUM(K9:K13)","v":0},{"$f":"'Exp planification'!H5","v":20000},{"$f":"IF((H8+I8+J8+K8)=0,0,L8-SUM(H8:K8))","v":0},{"$f":"SUM(N9:N13)","v":0},{"$f":"SUM(O9:O13)","v":0},{"$f":"SUM(P9:P13)","v":0},{"$f":"SUM(Q9:Q13)","v":0},{"$f":"'Exp planification'!I5","v":350000},{"$f":"IF((N8+O8+P8+Q8)=0,0,R8-SUM(N8:Q8))","v":0}]
[{"$f":"'Exp planification'!B6","v":"Gap analysis (bio-physical) (stakeholder consultation and consultancy"},null,null,null,null,{"$f":"'Exp planification'!C6","v":45000},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":"Social feasibility study (Stakholder consultation and consultancy)"},null,null,null,null,{"$f":"'Exp planification'!C7","v":60000},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":"First legislative draft "},null,null,null,null,{"$f":"'Exp planification'!C8","v":0},0,null,null,null,null,{"$f":"'Exp planification'!H8","v":5000},0,null,null,null,null,{"$f":"'Exp planification'!I8","v":0},0]
[{"$f":"'Exp planification'!B9","v":"Interministerial consultations"},null,null,null,null,{"$f":"'Exp planification'!C9","v":0},0,null,null,null,null,{"$f":"'Exp planification'!H9","v":10000},0,null,null,null,null,{"$f":"'Exp planification'!I9","v":0},0]
[{"$f":"'Exp planification'!B10","v":"Legistlative draft enacted; gazetting"},null,null,null,null,{"$f":"'Exp planification'!C10","v":0},0,null,null,null,null,{"$f":"'Exp planification'!H10","v":5000},0,null,null,null,null,{"$f":"'Exp planification'!I10","v":0},0]
[{"$f":"'Exp planification'!B11","v":"Physical infrastructure"},null,null,null,null,{"$f":"'Exp planification'!C11","v":0},{"$f":"F14-SUM(B14:E14)","v":0},null,null,null,null,{"$f":"'Exp planification'!H11","v":0},{"$f":"L14-SUM(H14:K14)","v":0},null,null,null,null,{"$f":"'Exp planification'!I11","v":300000},{"$f":"R14-SUM(N14:Q14)","v":300000}]
[{"$f":"'Exp planification'!B12","v":"Management plans and training"},null,null,null,null,{"$f":"'Exp planification'!C12","v":0},{"$f":"IF((B15+C15+D15+E15)=0,0,F15-SUM(B15:E15))","v":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":50000},{"$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":0},{"$f":"'Costs by categories'!H5","v":0},{"$f":"'Costs by categories'!N5","v":0},{"$f":"SUM(C5:E5)","v":0},{"$f":"F5/$F$9","v":{"$error":"#DIV/0!"}}]
[null,"Operating Exp",{"$f":"'Costs by categories'!C5","v":0},{"$f":"'Costs by categories'!I5","v":0},{"$f":"'Costs by categories'!O5","v":0},{"$f":"SUM(C6:E6)","v":0},{"$f":"F6/$F$9","v":{"$error":"#DIV/0!"}}]
[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":{"$error":"#DIV/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":{"$error":"#DIV/0!"}}]
[null,"TOTAL expenses",{"$f":"SUM(C5:C8)","v":0},{"$f":"SUM(D5:D8)","v":0},{"$f":"SUM(E5:E8)","v":0},{"$f":"SUM(F5:F8)","v":0},{"$f":"F9/$F$9","v":{"$error":"#DIV/0!"}}]