{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["budget_tool","EAP for publication","Summary by APcode","Summary by Year","Resource Budget summary","budget_groups","output codes","FedBudget data","Guidelines"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":41,"comments":0,"pivot_tables":1},"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":"budget_tool","index":0,"n_rows":220,"n_cols":12,"rows_kept":220,"cut":false,"hidden":false,"merged":[[4,0,4,1],[7,0,7,1],[4,3,4,5],[9,2,9,5]]}
["International Federation of Red Cross and Red Crescent Societies ",null,null,null,null,null,null,null,null,null,{"$f":"VERSION","v":"V2024.01"}]
["Early Action Protocol budget tool for National Societies",null,null,null,null,null,null,null,null,null,"DREF202101"]
[]
["National Society",null,null,"Partner National Society",null,null,null,"Appeal Code",null,null,"Date"]
["NS Name",null,null,"Partner National Society",null,null,null,"Mappeal",null,null,"9999-12-31"]
[]
["Early Action Protocol Name (Hazard)",null,null,"From (date)",null,"To (date",null,"Protocol Number",null,"Currency  (LC)    &","Exchange Rate"]
["Hazard Name",null,null,"1900-01-01","TO","9999-12-31",null,"EAPcode",null,"CCX",1]
[]
[null,null,"do not copy/paste to these cells, use the drop down list"]
["Output\nCode","Description","Activity [select]","Implemented by [select]","Year [select]","Budget\nGroup","Quantity","Unit","Unit\nCost","Total Cost LC","Total Cost CHF","Review/Comments"]
["AP005",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP005",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP005",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP005",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP005",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP005","Shelter assistance to households",null,null,null,null,null,null,"AP005",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO01","Shelter and Basic Household Items",null,null,null,null,null,null,null,{"$f":"+J17","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP007",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP007",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP007",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP007",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP007",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP007","Improvement of income sources",null,null,null,null,null,null,"AP007",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO02","Livelihoods ",null,null,null,null,null,null,null,{"$f":"+J24","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP081",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP081",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP081",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP081",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP081",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP081","Multi-purpose cash grants",null,null,null,null,null,null,"AP081",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO03","Multi-purpose Cash",null,null,null,null,null,null,null,{"$f":"+J31","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP107",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP107",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP107",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP107",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP107",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP107","NS health capacity",null,null,null,null,null,null,"AP107",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP108",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP108",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP108",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP108",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP108",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP108","Health services",null,null,null,null,null,null,"AP108",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP109",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP109",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP109",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP109",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP109",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP109","Health services in emergencies",null,null,null,null,null,null,"AP109",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO04","Health",null,null,null,null,null,null,null,{"$f":"+J38+J44+J50","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP110",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP110",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP110",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP110",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP110",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP110","WASH",null,null,null,null,null,null,"AP110",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP111",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP111",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP111",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP111",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP111",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP111","WASH in emergencies",null,null,null,null,null,null,"AP111",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO05","Water, Sanitation & Hygiene",null,null,null,null,null,null,null,{"$f":"+J57+J63","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP114",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP114",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP114",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP114",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP114",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP114","Humanitarian values and principles",null,null,null,null,null,null,"AP114",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP116",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP116",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP116",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP116",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP116",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP116","Protection/gender/inclusion services",null,null,null,null,null,null,"AP116",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP117",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP117",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP117",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP117",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP117",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP117","Protection/gender/inclusion capacity",null,null,null,null,null,null,"AP117",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO06","Protection, Gender and Inclusion",null,null,null,null,null,null,null,{"$f":"+J70+J76+J82","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP115",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP115",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP115",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP115",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP115",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP115","Access to education",null,null,null,null,null,null,"AP115",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO07","Education",null,null,null,null,null,null,null,{"$f":"+J89","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP112",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP112",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP112",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP112",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP112",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP112","Support to migrants and displaced",null,null,null,null,null,null,"AP112",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP113",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP113",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP113",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP113",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP113",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP113","NS Migration & Displacement Capacity",null,null,null,null,null,null,"AP113",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO08","Migration",null,null,null,null,null,null,null,{"$f":"+J96+J102","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP101",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP101",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP101",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP101",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP101",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP101","Climate change adaptation",null,null,null,null,null,null,"AP101",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP103",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP103",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP103",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP103",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP103",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP103","Comm. risk reduction and resilience",null,null,null,null,null,null,"AP103",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP104",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP104",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP104",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP104",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP104",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP104","Assistance to people affected",null,null,null,null,null,null,"AP104",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP105",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP105",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP105",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP105",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP105",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP105","National Society Disaster Management Capacity",null,null,null,null,null,null,"AP105",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP106",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP106",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP106",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP106",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP106",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP106","Disaster Law",null,null,null,null,null,null,"AP106",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO09","Risk Reduction, Climate Adaptation and Recovery",null,null,null,null,null,null,null,{"$f":"+J109+J115+J121+J127+J133","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP129",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP129",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP129",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP129",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP129",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP129","Community engagement/accountability",null,null,null,null,null,null,"AP129",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO10","Community Engagement and Accountability",null,null,null,null,null,null,null,{"$f":"+J140","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP102",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP102",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP102",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP102",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP102",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP102","Climate change mitigation&greening",null,null,null,null,null,null,"AP102",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["PO11","Environmental Sustainability",null,null,null,null,null,null,null,{"$f":"+J147","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP049",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP049",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP049",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP049",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP049",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP049","IFRC coord. in humanitarian system",null,null,null,null,null,null,"AP049",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP118",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP118",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP118",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP118",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP118",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP118","Engagement w. stakeholders",null,null,null,null,null,null,"AP118",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP119",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP119",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP119",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP119",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP119",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP119","Influencing and hum. diplomacy",null,null,null,null,null,null,"AP119",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP120",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP120",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP120",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP120",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP120",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP120","Innovation",null,null,null,null,null,null,"AP120",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP121",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP121",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP121",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP121",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP121",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP121","Digital Transformation",null,null,null,null,null,null,"AP121",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP127",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP127",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP127",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP127",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP127",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP127","Membership Coordination",null,null,null,null,null,null,"AP127",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP128",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP128",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP128",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP128",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP128",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP128","Movement Cooperation",null,null,null,null,null,null,"AP128",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["EA01","Coordination and Partnerships",null,null,null,null,null,null,null,{"$f":"+J154+J160+J166+J172+J178+J184+J190","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP122",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP122",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP122",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP122",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP122",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP122","Secretariat services strengthening",null,null,null,null,null,null,"AP122",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["EA02","Secretariat Services",null,null,null,null,null,null,null,{"$f":"+J197","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP124",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP124",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP124",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP124",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP124",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP124","National Society Development",null,null,null,null,null,null,"AP124",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP125",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP125",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP125",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP125",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP125",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP125","Volunteering development",null,null,null,null,null,null,"AP125",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP126",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP126",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP126",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP126",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["AP126",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Quantity]]*BUDGET[[#This Row],[Unit\nCost]]","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["TOT_AP126","Leadership development",null,null,null,null,null,null,"AP126",{"$f":"SUMIFS(BUDGET[Total Cost LC],BUDGET[Output\nCode],BUDGET[[#This Row],[Unit\nCost]])","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
["EA03","National Society Development",null,null,null,null,null,null,null,{"$f":"+J204+J210+J216","v":0},{"$f":"ROUND(+BUDGET[[#This Row],[Total Cost LC]]*RATE,2)","v":0}]
[null,"DIRECT COSTS total",null,null,null,null,null,null,null,{"$f":"+J18+J25+J32+J51+J64+J83+J90+J103+J134+J141+J148+J191+J198+J217","v":0},{"$f":"+K18+K25+K32+K51+K64+K83+K90+K103+K134+K141+K148+K191+K198+K217","v":0}]
[null,"INDIRECT COSTS",null,null,null,null,null,null,null,{"$f":"ROUND(BUDGET[[#Totals],[Total Cost LC]]*6.5/100,2)","v":0},{"$f":"ROUND(BUDGET[[#Totals],[Total Cost CHF]]*6.5/100,2)","v":0}]
[null,"TOTAL BUDGET",null,null,null,null,null,null,null,{"$f":"+BUDGET[[#Totals],[Total Cost LC]]+J219","v":0},{"$f":"+BUDGET[[#Totals],[Total Cost CHF]]+K219","v":0}]

{"sheet":"EAP for publication","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Early Action Protocol Summary"]
[]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(CODE_EAP,\" - \",NAME_NS)","v":"EAPcode - NS Name"}]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(NAME_EAP)","v":"Hazard Name"}]
[]
[]
[]
["Operating Budget",null,"Readiness","Pre-Pos Stock","Early Action","TOTAL"]
[]
["Planned Operations",null,{"$f":"SUM(C12:C22)","v":0},{"$f":"SUM(D12:D22)","v":0},{"$f":"SUM(E12:E22)","v":0},{"$f":"SUM(F12:F22)","v":0},null,"all amounts inclusive of indirect costs"]
["PO01","Shelter and Basic Household Items",{"$f":"+'Summary by APcode'!D9","v":0},{"$f":"+'Summary by APcode'!E9","v":0},{"$f":"+'Summary by APcode'!F9","v":0},{"$f":"SUM(C12:E12)","v":0},null,{"$f":"+'Summary by APcode'!I9","v":0},{"$f":"+F12-H12","v":0}]
["PO02","Livelihoods ",{"$f":"+'Summary by APcode'!D11","v":0},{"$f":"+'Summary by APcode'!E11","v":0},{"$f":"+'Summary by APcode'!F11","v":0},0,null,{"$f":"+'Summary by APcode'!I11","v":0},0]
["PO03","Multi-purpose Cash",{"$f":"+'Summary by APcode'!D13","v":0},{"$f":"+'Summary by APcode'!E13","v":0},{"$f":"+'Summary by APcode'!F13","v":0},0,null,{"$f":"+'Summary by APcode'!I13","v":0},0]
["PO04","Health",{"$f":"+'Summary by APcode'!D15","v":0},{"$f":"+'Summary by APcode'!E15","v":0},{"$f":"+'Summary by APcode'!F15","v":0},0,null,{"$f":"+'Summary by APcode'!I15","v":0},0]
["PO05","Water, Sanitation & Hygiene",{"$f":"+'Summary by APcode'!D19","v":0},{"$f":"+'Summary by APcode'!E19","v":0},{"$f":"+'Summary by APcode'!F19","v":0},0,null,{"$f":"+'Summary by APcode'!I19","v":0},0]
["PO06","Protection, Gender and Inclusion",{"$f":"+'Summary by APcode'!D22","v":0},{"$f":"+'Summary by APcode'!E22","v":0},{"$f":"+'Summary by APcode'!F22","v":0},0,null,{"$f":"+'Summary by APcode'!I22","v":0},0]
["PO07","Education",{"$f":"+'Summary by APcode'!D26","v":0},{"$f":"+'Summary by APcode'!E26","v":0},{"$f":"+'Summary by APcode'!F26","v":0},0,null,{"$f":"+'Summary by APcode'!I26","v":0},0]
["PO08","Migration",{"$f":"+'Summary by APcode'!D28","v":0},{"$f":"+'Summary by APcode'!E28","v":0},{"$f":"+'Summary by APcode'!F28","v":0},0,null,{"$f":"+'Summary by APcode'!I28","v":0},0]
["PO09","Risk Red., Climate Adapt. and Recovery",{"$f":"+'Summary by APcode'!D31","v":0},{"$f":"+'Summary by APcode'!E31","v":0},{"$f":"+'Summary by APcode'!F31","v":0},0,null,{"$f":"+'Summary by APcode'!I31","v":0},0]
["PO10","Community Engagement and Accountability",{"$f":"+'Summary by APcode'!D37","v":0},{"$f":"+'Summary by APcode'!E37","v":0},{"$f":"+'Summary by APcode'!F37","v":0},0,null,{"$f":"+'Summary by APcode'!I37","v":0},0]
["PO11","Environmental Sustainability",{"$f":"+'Summary by APcode'!D39","v":0},{"$f":"+'Summary by APcode'!E39","v":0},{"$f":"+'Summary by APcode'!F39","v":0},0,null,{"$f":"+'Summary by APcode'!I39","v":0},0]
["Enabling Approaches",null,{"$f":"SUM(C24:C26)","v":0},{"$f":"SUM(D24:D26)","v":0},{"$f":"SUM(E24:E26)","v":0},{"$f":"SUM(F24:F26)","v":0}]
["EA01","Coordination and Partnerships",{"$f":"+'Summary by APcode'!D42","v":0},{"$f":"+'Summary by APcode'!E42","v":0},{"$f":"+'Summary by APcode'!F42","v":0},{"$f":"SUM(C24:E24)","v":0},null,{"$f":"+'Summary by APcode'!I41","v":0},{"$f":"+F24-H24","v":0}]
["EA02","Secretariat Services",{"$f":"+'Summary by APcode'!D50","v":0},{"$f":"+'Summary by APcode'!E50","v":0},{"$f":"+'Summary by APcode'!F50","v":0},{"$f":"SUM(C25:E25)","v":0},null,{"$f":"+'Summary by APcode'!I42","v":0},{"$f":"+F25-H25","v":0}]
["EA03","National Society Strengthening",{"$f":"+'Summary by APcode'!D52","v":0},{"$f":"+'Summary by APcode'!E52","v":0},{"$f":"+'Summary by APcode'!F52","v":0},{"$f":"SUM(C26:E26)","v":0},null,{"$f":"+'Summary by APcode'!I43","v":0},{"$f":"+F26-H26","v":0}]
[null,null,null,null,null,null,null,"check"]
[null,"TOTAL BUDGET ",{"$f":"+C11+C23","v":0},{"$f":"+D11+D23","v":0},{"$f":"+E11+E23","v":0},{"$f":"+F11+F23","v":0},null,{"$f":"+budget_tool!K220","v":0},{"$f":"+F28-H28","v":0}]
["all amounts in Swiss Francs (CHF)"]

{"sheet":"Summary by APcode","index":2,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Early Action Protocol Summary"]
[]
[null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(CODE_EAP,\" - \",NAME_NS)","v":"EAPcode - NS Name"}]
[null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(NAME_EAP)","v":"Hazard Name"}]
["Operating Budget by Output Codes",null,null,"Readiness","Pre-Pos Stock","Early Action","TOTAL"]
["x",null,null,null,null,null,"chf amounts"]
["Planned Operations",null,null,{"$f":"+D9+D11+D13+D15+D19+D22+D26+D28+D31+D37+D39","v":0},{"$f":"+E9+E11+E13+E15+E19+E22+E26+E28+E31+E37+E39","v":0},{"$f":"+F9+F11+F13+F15+F19+F22+F26+F28+F31+F37+F39","v":0},{"$f":"+G9+G11+G13+G15+G19+G22+G26+G28+G31+G37+G39","v":0},null,null,"all amounts inclusive of indirect costs"]
["PO01","Shelter and Basic Household Items",null,{"$f":"SUM(D10)","v":0},{"$f":"SUM(E10)","v":0},{"$f":"SUM(F10)","v":0},{"$f":"SUM(G10)","v":0},null,{"$f":"SUM(I10)","v":0},0]
[null,"AP005","Shelter assistance to households",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B10,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B10,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B10,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D10:F10)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B10))*106.5/100,2)","v":0},{"$f":"+G10-I10","v":0}]
["PO02","Livelihoods ",null,{"$f":"SUM(D12)","v":0},{"$f":"SUM(E12)","v":0},{"$f":"SUM(F12)","v":0},{"$f":"SUM(G12)","v":0},null,{"$f":"SUM(I12)","v":0},{"$f":"SUM(J12)","v":0}]
[null,"AP007","Improvement of income sources",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B12,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B12,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B12,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D12:F12)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B12))*106.5/100,2)","v":0},{"$f":"+G12-I12","v":0}]
["PO03","Multi-purpose Cash",null,{"$f":"SUM(D14)","v":0},{"$f":"SUM(E14)","v":0},{"$f":"SUM(F14)","v":0},{"$f":"SUM(G14)","v":0},null,{"$f":"SUM(I14)","v":0},{"$f":"SUM(J14)","v":0}]
[null,"AP081","Multipurpose cash grants",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B14,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B14,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B14,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D14:F14)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B14))*106.5/100,2)","v":0},{"$f":"+G14-I14","v":0}]
["PO04","Health",null,{"$f":"SUM(D16:D18)","v":0},{"$f":"SUM(E16:E18)","v":0},{"$f":"SUM(F16:F18)","v":0},{"$f":"SUM(G16:G18)","v":0},null,{"$f":"SUM(I16:I18)","v":0},{"$f":"SUM(J16:J18)","v":0}]
[null,"AP107","NS health capacity",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B16,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B16,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B16,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D16:F16)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B16))*106.5/100,2)","v":0},{"$f":"+G16-I16","v":0}]
[null,"AP108","Health services",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B17,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B17,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B17,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D17:F17)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B17))*106.5/100,2)","v":0},{"$f":"+G17-I17","v":0}]
[null,"AP109","Health services in emergencies",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B18,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B18,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B18,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D18:F18)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B18))*106.5/100,2)","v":0},{"$f":"+G18-I18","v":0}]
["PO05","Water, Sanitation & Hygiene",null,{"$f":"SUM(D20:D21)","v":0},{"$f":"SUM(E20:E21)","v":0},{"$f":"SUM(F20:F21)","v":0},{"$f":"SUM(G20:G21)","v":0},null,{"$f":"SUM(I20:I21)","v":0},{"$f":"SUM(J20:J21)","v":0}]
[null,"AP110","WASH",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B20,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B20,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B20,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D20:F20)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B20))*106.5/100,2)","v":0},{"$f":"+G20-I20","v":0}]
[null,"AP111","WASH in emergencies",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B21,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B21,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B21,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D21:F21)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B21))*106.5/100,2)","v":0},{"$f":"+G21-I21","v":0}]
["PO06","Protection, Gender and Inclusion",null,{"$f":"SUM(D23:D25)","v":0},{"$f":"SUM(E23:E25)","v":0},{"$f":"SUM(F23:F25)","v":0},{"$f":"SUM(G23:G25)","v":0},null,{"$f":"SUM(I23:I25)","v":0},{"$f":"SUM(J23:J25)","v":0}]
[null,"AP114","Humanitarian values and principles",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B23,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B23,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B23,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D23:F23)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B23))*106.5/100,2)","v":0},{"$f":"+G23-I23","v":0}]
[null,"AP116","Protection/gender/inclusion services",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B24,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B24,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B24,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D24:F24)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B24))*106.5/100,2)","v":0},{"$f":"+G24-I24","v":0}]
[null,"AP117","Protection/gender/inclusion capacity",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B25,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B25,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B25,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D25:F25)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B25))*106.5/100,2)","v":0},{"$f":"+G25-I25","v":0}]
["PO07","Education",null,{"$f":"SUM(D27)","v":0},{"$f":"SUM(E27)","v":0},{"$f":"SUM(F27)","v":0},{"$f":"SUM(G27)","v":0},null,{"$f":"SUM(I27)","v":0},{"$f":"SUM(J27)","v":0}]
[null,"AP115","Access to education",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B27,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B27,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B27,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D27:F27)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B27))*106.5/100,2)","v":0},{"$f":"+G27-I27","v":0}]
["PO08","Migration",null,{"$f":"SUM(D29:D30)","v":0},{"$f":"SUM(E29:E30)","v":0},{"$f":"SUM(F29:F30)","v":0},{"$f":"SUM(G29:G30)","v":0},null,{"$f":"SUM(I29:I30)","v":0},{"$f":"SUM(J29:J30)","v":0}]
[null,"AP112","Support to migrants and displaced",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B29,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B29,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B29,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D29:F29)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B29))*106.5/100,2)","v":0},{"$f":"+G29-I29","v":0}]
[null,"AP113","NS Migration & Displacement Capacity",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B30,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B30,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B30,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D30:F30)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B30))*106.5/100,2)","v":0},{"$f":"+G30-I30","v":0}]
["PO09","Risk Red., Climate Adapt. and Recovery",null,{"$f":"SUM(D32:D36)","v":0},{"$f":"SUM(E32:E36)","v":0},{"$f":"SUM(F32:F36)","v":0},{"$f":"SUM(G32:G36)","v":0},null,{"$f":"SUM(I32:I36)","v":0},{"$f":"SUM(J32:J36)","v":0}]
[null,"AP101","Climate change adaptation",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B32,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B32,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B32,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D32:F32)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B32))*106.5/100,2)","v":0},{"$f":"+G32-I32","v":0}]
[null,"AP103","Comm. risk reduction and resilience",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B33,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B33,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B33,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D33:F33)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B33))*106.5/100,2)","v":0},{"$f":"+G33-I33","v":0}]
[null,"AP104","Assistance to people affected",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B34,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B34,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B34,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D34:F34)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B34))*106.5/100,2)","v":0},{"$f":"+G34-I34","v":0}]
[null,"AP105","NS DM Capacity",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B35,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B35,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B35,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D35:F35)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B35))*106.5/100,2)","v":0},{"$f":"+G35-I35","v":0}]
[null,"AP106","Disaster Law",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B36,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B36,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B36,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D36:F36)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B36))*106.5/100,2)","v":0},{"$f":"+G36-I36","v":0}]
["PO10","Community Engage. and Accountability",null,{"$f":"SUM(D38)","v":0},{"$f":"SUM(E38)","v":0},{"$f":"SUM(F38)","v":0},{"$f":"SUM(G38)","v":0},null,{"$f":"SUM(I38)","v":0},{"$f":"SUM(J38)","v":0}]
[null,"AP129","Community engagement/accountability",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B38,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B38,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B38,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D38:F38)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B38))*106.5/100,2)","v":0},{"$f":"+G38-I38","v":0}]
["PO11","Environmental Sustainability",null,{"$f":"SUM(D40)","v":0},{"$f":"SUM(E40)","v":0},{"$f":"SUM(F40)","v":0},{"$f":"SUM(G40)","v":0},null,{"$f":"SUM(I40)","v":0},{"$f":"SUM(J40)","v":0}]
[null,"AP102","Climate change mitigation&greening",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B40,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B40,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B40,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D40:F40)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B40))*106.5/100,2)","v":0},{"$f":"+G40-I40","v":0}]
["Enabling Approaches",null,null,{"$f":"+D42+D50+D52","v":0},{"$f":"+E42+E50+E52","v":0},{"$f":"+F42+F50+F52","v":0},{"$f":"+G42+G50+G52","v":0}]
["EA01","Coordination and Partnerships",null,{"$f":"SUM(D43:D49)","v":0},{"$f":"SUM(E43:E49)","v":0},{"$f":"SUM(F43:F49)","v":0},{"$f":"SUM(G43:G49)","v":0},null,{"$f":"SUM(I43:I49)","v":0},{"$f":"SUM(J43:J49)","v":0}]
[null,"AP049","IFRC coord. in humanitarian system",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B43,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B43,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B43,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D43:F43)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B43))*106.5/100,2)","v":0},{"$f":"+G43-I43","v":0}]
[null,"AP118","Engagement w. stakeholders",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B44,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B44,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B44,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B44))*106.5/100,2)","v":0},0]
[null,"AP119","Influencing and hum. diplomacy",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B45,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B45,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B45,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B45))*106.5/100,2)","v":0},0]
[null,"AP120","Innovation",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B46,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B46,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B46,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B46))*106.5/100,2)","v":0},0]
[null,"AP121","Digital Transformation",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B47,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B47,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B47,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B47))*106.5/100,2)","v":0},0]
[null,"AP127","Membership Coordination",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B48,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B48,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B48,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B48))*106.5/100,2)","v":0},0]
[null,"AP128","Movement Cooperation",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B49,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B49,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B49,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B49))*106.5/100,2)","v":0},0]
["EA02","Secretariat Services",null,{"$f":"SUM(D51)","v":0},{"$f":"SUM(E51)","v":0},{"$f":"SUM(F51)","v":0},{"$f":"SUM(G51)","v":0},null,{"$f":"SUM(I51)","v":0},0]
[null,"AP122","Secretariat services strengthening",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B51,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B51,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B51,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D51:F51)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B51))*106.5/100,2)","v":0},{"$f":"+G51-I51","v":0}]
["EA03","National Society Strengthening",null,{"$f":"SUM(D53:D55)","v":0},{"$f":"SUM(E53:E55)","v":0},{"$f":"SUM(F53:F55)","v":0},{"$f":"SUM(G53:G55)","v":0},null,{"$f":"SUM(I53:I55)","v":0},{"$f":"SUM(J53:J55)","v":0}]
[null,"AP124","National Society Development",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B53,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B53,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B53,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D53:F53)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B53))*106.5/100,2)","v":0},{"$f":"+G53-I53","v":0}]
[null,"AP125","Volunteering development",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B54,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B54,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B54,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D54:F54)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B54))*106.5/100,2)","v":0},{"$f":"+G54-I54","v":0}]
[null,"AP126","Leadership development",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B55,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B55,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\"))*106.5/100,2)","v":0},{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B55,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D55:F55)","v":0},null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B55))*106.5/100,2)","v":0},{"$f":"+G55-I55","v":0}]
["x"]
[null,"TOTAL BUDGET",null,{"$f":"+D41+D8","v":0},{"$f":"+E41+E8","v":0},{"$f":"+F41+F8","v":0},{"$f":"+G41+G8","v":0},null,"check",{"$f":"+TOT_BUDGET","v":0},{"$f":"+G57-J57","v":0}]
["all amounts in Swiss Francs (CHF)"]

{"sheet":"Summary by Year","index":3,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"Early Action Protocol Summary"]
[]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(CODE_EAP,\" - \",NAME_NS)","v":"EAPcode - NS Name"}]
[null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(NAME_EAP)","v":"Hazard Name"}]
[]
["Implemented by",null,"YEAR_01","YEAR_02","YEAR_03","YEAR_04","YEAR_05","YEAR_EA","Total CHF",null,null,"CHECK & CORRECT"]
["Host National Society",{"$f":"IF(I8<>0,I8/$I$25,0)","v":0},{"$f":"SUM(C9:C11)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C8:H8)-I8","v":0}]
["Readiness",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\")","v":0},null,{"$f":"SUM(C9:H9)-I9","v":0},{"$f":"+H9","v":0},{"$f":"IF(L9>0, \"Readiness should be budgeted under YEAR_01 to YEAR_05\",\" \")","v":" "}]
["Pre-Pos Stock",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\")","v":0},null,0,{"$f":"+H10","v":0},{"$f":"IF(L10>0, \"Pre-Pos Stock should be budgeted under YEAR_01 to YEAR_05\",\" \")","v":" "}]
["Early Action",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\")","v":0},null,0,{"$f":"SUM(C11:G11)","v":0},{"$f":"IF(L11>0, \"Early Action should be budgeted under YEAR_EA\",\" \")","v":" "}]
["Partner National Society",0,{"$f":"SUM(C13:C15)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C12:H12)-I12","v":0}]
["Readiness",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\")","v":0},null,{"$f":"SUM(C13:H13)-I13","v":0},{"$f":"+H13","v":0},{"$f":"IF(L13>0, \"Readiness should be budgeted under YEAR_01 to YEAR_05\",\" \")","v":" "}]
["Pre-Pos Stock",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\")","v":0},null,0,{"$f":"+H14","v":0},{"$f":"IF(L14>0, \"Pre-Pos Stock should be budgeted under YEAR_01 to YEAR_05\",\" \")","v":" "}]
["Early Action",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\")","v":0},null,0,{"$f":"SUM(C15:G15)","v":0},{"$f":"IF(L15>0, \"Early Action should be budgeted under YEAR_EA\",\" \")","v":" "}]
["subtotal National Society",null,{"$f":"+C8+C12","v":0},0,0,0,0,0,0,null,null,{"$f":"ROUND(500000*100/106.5,2)","v":469483.57},"maximum",{"$f":"+L16-I16","v":469483.57},{"$f":"IF(N16<0, \"Allocation maximum CHF 469,483.57\",\" \")","v":" "}]
["indirect cost Nat. Society",6.5000000000000002E-2,{"$f":"ROUND(C16*6.5/100,2)","v":0},{"$f":"ROUND(D16*6.5/100,2)","v":0},0,0,0,0,0,null,null,{"$f":"ROUND(L16*6.5/100,2)","v":30516.43},"maximum",{"$f":"+L17-I17","v":30516.43},{"$f":"IF(N17<0, \"Allocation maximum CHF 30,516.43\",\" \")","v":" "}]
["TOTAL NATIONAL SOCIETY",null,{"$f":"+C16+C17","v":0},0,0,0,0,0,0,null,null,{"$f":"+L16+L17","v":500000},"maximum",{"$f":"+L18-I18","v":500000},{"$f":"IF(N18<0, \"Allocation maximum CHF 500,000, inclusive indirect costs\",\" \")","v":" "}]
[]
["IFRC",{"$f":"IF(I20<>0,I20/$I$25,0)","v":0},{"$f":"SUM(C21:C23)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C20:H20)-I20","v":0},{"$f":"MIN(500000*10/100,I18*10/100)","v":0},"maximum",{"$f":"+L20-I20","v":0},{"$f":"IF(N20<0, \"IFRC budget maximum 10%\",\" \")","v":" "}]
["Readiness",{"$f":"IF(I21<>0,I21/$I$25,0)","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\")","v":0},null,0,{"$f":"+H21","v":0},{"$f":"IF(L21>0, \"Readiness should be budgeted under YEAR_01 to YEAR_05\",\" \")","v":" "}]
["Pre-Pos Stock",{"$f":"IF(I22<>0,I22/$I$25,0)","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\")","v":0},null,0,{"$f":"+H22","v":0},{"$f":"IF(L22>0, \"Pre-Pos Stock should be budgeted under YEAR_01 to YEAR_05\",\" \")","v":" "}]
["Early Action",{"$f":"IF(I23<>0,I23/$I$25,0)","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_03\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_04\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_05\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"YEAR_EA\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\")","v":0},null,{"$f":"SUM(C23:H23)-I23","v":0},{"$f":"SUM(C23:G23)","v":0},{"$f":"IF(L23>0, \"Early Action should be budgeted under YEAR_EA\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"total checks"]
["DIRECT COSTS TOTAL",{"$f":"IF(I25<>0,I25/$I$25,0)","v":0},{"$f":"+C8+C12+C20","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C25:H25)-I25","v":0},{"$f":"+I25-BUDGET[[#Totals],[Total Cost CHF]]","v":0},{"$f":"IF(L25<0, \"Check Activity/Implemented by or Year Selection - either missing or wrong\",\" \")","v":" "}]
["INDIRECT COSTS",6.5000000000000002E-2,{"$f":"ROUND(C25*6.5/100,2)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C26:H26)-I26","v":0},{"$f":"ROUND(L25*6.5/100,2)","v":0}]
["TOTAL BUDGET",{"$f":"+B25+B26","v":6.5000000000000002E-2},{"$f":"+C25+C26","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C27:H27)-I27","v":0},550000,"maximum",{"$f":"+L27-I27","v":550000},{"$f":"IF(N27<0, \"Allocation maximum CHF 500,000\",\" \")","v":" "}]
[]
[]
[null,null,"YEAR_01","YEAR_02","YEAR_03","YEAR_04","YEAR_05","YEAR_EA","Total CHF",null,null,"per budget tool","variance"]
["Readiness",{"$f":"IF(I31<>0,I31/$I$34,0)","v":0},{"$f":"+C9+C13+C21","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C31:H31)-I31","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"+I31-L31","v":0}]
["Pre-Pos Stock",{"$f":"IF(I32<>0,I32/$I$34,0)","v":0},0,0,0,0,0,0,0,null,0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},0]
["Early Action",{"$f":"IF(I33<>0,I33/$I$34,0)","v":0},0,0,0,0,0,0,0,null,0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},0]
["DIRECT COSTS TOTAL",{"$f":"IF(I34<>0,I34/$I$34,0)","v":0},{"$f":"SUM(C31:C33)","v":0},0,0,0,0,0,0,null,0,{"$f":"+BUDGET[[#Totals],[Total Cost CHF]]","v":0},0,{"$f":"IF(M34<0, \"Check Activity/Implemented by or Year Selection - either missing or wrong\",\" \")","v":" "}]
["INDIRECT COSTS",6.5000000000000002E-2,{"$f":"ROUND(C34*6.5/100,2)","v":0},0,0,0,0,0,0,null,0,{"$f":"+TOT_INDIRECT","v":0},0]
["TOTAL BUDGET",{"$f":"+B34+B35","v":6.5000000000000002E-2},{"$f":"+C34+C35","v":0},0,0,0,0,0,0,null,0,{"$f":"+TOT_BUDGET","v":0},0]

{"sheet":"Resource Budget summary","index":4,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Early Action Protocol Summary"]
[]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(CODE_EAP,\" - \",NAME_NS)","v":"EAPcode - NS Name"}]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(NAME_EAP)","v":"Hazard Name"}]
[]
[null,"Budget Group","Readiness","Pre-Pos Stock","Early Action","Total CHF",null,null,"<= filter to remove 0 lines & fit on one page"]
[null,"RELIEF ITEMS, CONSTRUCTION, SUPPLIES",{"$f":"SUM(C9:C23)","v":0},{"$f":"SUM(D9:D23)","v":0},{"$f":"SUM(E9:E23)","v":0},{"$f":"SUM(F9:F23)","v":0},null,{"$f":"+C8+E8-F8+D8","v":0}]
[500,"Shelter - Relief",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A9,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A9,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A9,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A9)","v":0},null,{"$f":"+C9+E9-F9+D9","v":0}]
[501,"Shelter - Transitional",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A10,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A10,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A10,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A10)","v":0},null,{"$f":"+C10+E10-F10+D10","v":0}]
[502,"Construction - Housing",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A11,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A11,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A11,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A11)","v":0},null,0]
[503,"Construction - Facilities",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A12,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A12,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A12,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A12)","v":0},null,0]
[505,"Construction Materials",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A13,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A13,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A13,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A13)","v":0},null,0]
[510,"Clothing & Textiles",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A14,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A14,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A14,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A14)","v":0},null,0]
[520,"Food",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A15,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A15,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A15,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A15)","v":0},null,0]
[523,"Seeds & Plants",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A16,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A16,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A16,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A16)","v":0},null,0]
[530,"Water, Sanitation & Hygiene",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A17,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A17,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A17,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A17)","v":0},null,0]
[540,"Medical & First Aid",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A18,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A18,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A18,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A18)","v":0},null,0]
[550,"Teaching Materials",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A19,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A19,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A19,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A19)","v":0},null,0]
[560,"Utensils & Tools",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A20,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A20,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A20,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A20)","v":0},null,0]
[570,"Other Supplies & Services",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A21,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A21,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A21,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A21)","v":0},null,0]
[571,"Emergency Response Units",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A22,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A22,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A22,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A22)","v":0},null,0]
[578,"Cash Disbursment",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A23,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A23,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A23,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A23)","v":0},null,0]
[null,"LAND, VEHICLE & EQUIPMENT",{"$f":"SUM(C25:C30)","v":0},{"$f":"SUM(D25:D30)","v":0},{"$f":"SUM(E25:E30)","v":0},{"$f":"SUM(F25:F30)","v":0},null,0]
[580,"Land & Buildings",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A25,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A25,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A25,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A25)","v":0},null,0]
[581,"Vehicles",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A26,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A26,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A26,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A26)","v":0},null,0]
[582,"Computers & Telecom",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A27,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A27,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A27,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A27)","v":0},null,0]
[584,"Office & Household Equipment",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A28,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A28,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A28,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A28)","v":0},null,0]
[587,"Medical Equipment",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A29,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A29,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A29,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A29)","v":0},null,0]
[589,"Other Machinery & Equipment",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A30,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A30,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A30,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A30)","v":0},null,0]
[null,"LOGISTICS, TRANSPORT AND STORAGE",{"$f":"SUM(C32:C35)","v":0},{"$f":"SUM(D32:D35)","v":0},{"$f":"SUM(E32:E35)","v":0},{"$f":"SUM(F32:F35)","v":0},null,0]
[590,"Storage",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A32,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A32,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A32,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A32)","v":0},null,0]
[592,"Distribution & Monitoring",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A33,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A33,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A33,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A33)","v":0},null,0]
[593,"Transport & Vehicles Costs",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A34,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A34,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A34,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A34)","v":0},null,0]
[594,"Logistics Services",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A35,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A35,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A35,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A35)","v":0},null,0]
[null,"PERSONNEL",{"$f":"SUM(C37:C40)","v":0},{"$f":"SUM(D37:D40)","v":0},{"$f":"SUM(E37:E40)","v":0},{"$f":"SUM(F37:F40)","v":0},null,0]
[600,"International Staff",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A37,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A37,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A37,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A37)","v":0},null,0]
[661,"National Staff",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A38,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A38,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A38,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A38)","v":0},null,0]
[662,"National Society Staff",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A39,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A39,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A39,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A39)","v":0},null,0]
[667,"Volunteers",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A40,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A40,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A40,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A40)","v":0},null,0]
[null,"CONSULTANTS & PROFESSIONAL FEES",{"$f":"SUM(C42:C43)","v":0},{"$f":"SUM(D42:D43)","v":0},{"$f":"SUM(E42:E43)","v":0},{"$f":"SUM(F42:F43)","v":0},null,0]
[670,"Consultants",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A42,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A42,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A42,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A42)","v":0},null,0]
[750,"Professional Fees",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A43,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A43,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A43,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A43)","v":0},null,0]
[null,"WORKSHOPS & TRAINING",{"$f":"SUM(C45)","v":0},{"$f":"SUM(D45)","v":0},{"$f":"SUM(E45)","v":0},{"$f":"SUM(F45)","v":0},null,0]
[680,"Workshops & Training",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A45,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A45,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A45,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A45)","v":0},null,0]
[null,"GENERAL EXPENDITURE",{"$f":"SUM(C47:C53)","v":0},{"$f":"SUM(D47:D53)","v":0},{"$f":"SUM(E47:E53)","v":0},{"$f":"SUM(F47:F53)","v":0},null,0]
[700,"Travel",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A47,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A47,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A47,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A47)","v":0},null,0]
[710,"Information & Public Relations",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A48,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A48,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A48,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A48)","v":0},null,0]
[730,"Office Costs",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A49,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A49,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A49,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A49)","v":0},null,0]
[740,"Communications",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A50,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A50,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A50,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A50)","v":0},null,0]
[760,"Financial Charges",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A51,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A51,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A51,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A51)","v":0},null,0]
[790,"Other General Expenses",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A52,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A52,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A52,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A52)","v":0},null,0]
[799,"Shared Office and Services Costs",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A53,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A53,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A53,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A53)","v":0},null,0]
[null,"DEPRECIATION",{"$f":"SUM(C55)","v":0},{"$f":"SUM(D55)","v":0},{"$f":"SUM(E55)","v":0},{"$f":"SUM(F55)","v":0},null,0]
[798,"Assets Depreciation",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A55,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A55,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A55,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A55)","v":0},null,0]
[null,"CASH TRANSFERS TO PARTNERS",{"$f":"SUM(C57:C58)","v":0},{"$f":"SUM(D57:D58)","v":0},{"$f":"SUM(E57:E58)","v":0},{"$f":"SUM(F57:F58)","v":0},null,0]
[830,"Cash Transfers National Societies",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A57,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A57,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A57,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A57)","v":0},null,0]
[831,"Cash Transfers to 3rd Parties",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A58,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A58,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A58,BUDGET[[#Headers],[#Data],[Activity '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A58)","v":0},null,0]
[null,null,null,null,null,null,null,0,"total checks"]
[null,"DIRECT COSTS TOTAL",{"$f":"+C8+C24+C31+C36+C41+C44+C46+C54+C56","v":0},{"$f":"+D8+D24+D31+D36+D41+D44+D46+D54+D56","v":0},{"$f":"+E8+E24+E31+E36+E41+E44+E46+E54+E56","v":0},{"$f":"+F8+F24+F31+F36+F41+F44+F46+F54+F56","v":0},null,0,null,{"$f":"+budget_tool!K218-F60","v":0},{"$f":"IF(J60>0, \"Check Budget Group/Activity Selection - either missing or wrong\",\" \")","v":" "}]
[null,"INDIRECT COSTS",{"$f":"ROUND(C60*6.5/100,2)","v":0},{"$f":"ROUND(D60*6.5/100,2)","v":0},{"$f":"ROUND(E60*6.5/100,2)","v":0},{"$f":"ROUND(F60*6.5/100,2)","v":0},null,0]
[null,"TOTAL BUDGET",{"$f":"+C60+C61","v":0},{"$f":"+D60+D61","v":0},{"$f":"+E60+E61","v":0},{"$f":"+F60+F61","v":0},null,0]

{"sheet":"budget_groups","index":5,"n_rows":74,"n_cols":3,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[null,null,"IFRC - BUDGET GROUPS"]
[]
["Budget Code","Budget Code Name","Description"]
["RELIEF","RELIEF ITEMS, CONSTRUCTION, SUPPLIES","Category used for Supplies to Beneficiaries"]
[500,"Shelter - Relief","Tents, Tarpaulins, Shelter Tool Kits, Iron Sheets etc."]
[501,"Shelter - Transitional","Transitional Shelter, material and cash disbursments"]
[502,"Construction - Housing","Construction costs of permanent housing, housing cash disbursments"]
[503,"Construction - Facilities","Construction costs for education, health, community, warehouse facilities"]
[505,"Construction Materials","Other Construction material: Timber, Paint, Hardware"]
[510,"Clothing & Textiles","Blankets, Sheets, Mattresses, Clothes, Mosquito Nets, Footwear"]
[520,"Food","Cereals, Vegetables, High Energy Biscuits, MREs, Food Parcels"]
[523,"Seeds & Plants","Seeds, Plants, Fertilizers, Livestock and Animal feed"]
[530,"Water, Sanitation & Hygiene","Drinking Water, Water Tanks, Purification, Latrines, WatSan Equipement, Hygiene Parcels, Baby Parcels, Soap"]
[540,"Medical & First Aid","Vaccines, Drugs, Medical Equipment, Kits (First Aid, Cholera, PPE)"]
[550,"Teaching Materials","Books, Teaching Materials and Equipment"]
[560,"Utensils & Tools","Tools, Drums, Jerrycans, Buckets, Cocking Equipment, Kitchen Sets"]
[570,"Other Supplies & Services","Heating, Family Kits, Burial Costs and other"]
[571,"Emergency Response Units","ERU costs funded by IFRC (as per agreement and ERU NS invoice)"]
[578,"Cash Disbursment","All CTP costs (cash, vouchers, 3rd party)"]
["F.ASSETS","LAND, VEHICLE & EQUIPMENT","Procurement of IFRC non capital assests or items of capital nature not owned by the IFRC (NS Assets)"]
[580,"Land & Buildings","Budget group used for:"]
[581,"Vehicles","IFRC NON CAPITAL ASSETS - equipment with a minimum value of CHF 10,000"]
[582,"Computers & Telecom","and maximum value of CHF 9,999 per item"]
[584,"Office & Household Equipment","ITEMS OF CAPITALE NATURE - not owned by the IFRC (above CHF 10,000/item)"]
[587,"Medical Equipment","a) immediate donation to the National Society"]
[589,"Other Machinery & Equipment","b) over which the IFRC will not be in a position to exercise management control"]
["LOGISTICS","LOGISTICS, TRANSPORT AND STORAGE","All costs pertaining to Warehousing, Transport, Vehicles and Logistics Services"]
[590,"Storage","Warhousing, Rubbhalls, Loading/Unloading, Warehousing Equipment, Inspection, Custom Fees, Rental, Warehousing Maintenance"]
[592,"Distribution & Monitoring","Contracted Distribution Services, Shipping Costs, Airfreight, Transport Insurance and Claims, Rail/Road Transport"]
[593,"Transport & Vehicles Costs","Vehicles Costs (fuel, maintenance, spare parts, insurance) and Vehicle rentals (car, truck, aeroplane/helicopter charter), VRP leasing"]
[594,"Logistics Services","Logistics Service Fees, Fleet Management Fee, Fleet Service Fee"]
["STAFF","PERSONNEL","Contractual Costs (for IFRC and National Staff) and National Society/Volunteer staff costs - should not include activity costs such as travel (travel accomodation, perdiem)"]
[600,"International Staff","International contracted staff - IFRC or National Society Staff on Loan recruited internationally"]
[661,"National Staff","IFRC Country Office National Staff - contractual costs per country laws"]
[662,"National Society Staff","National Society staff costs which IFRC has agreed to reimburse as agreed with the National Society"]
[667,"Volunteers","Volunteers incentive and other benefits (t-shirts)"]
["PROF","CONSULTANTS & PROFESSIONAL FEES","Contractual arrangement with professional expert to implement a specific projec or component of a project"]
[670,"Consultants","Contractual arrangement with an individual"]
[750,"Professional Fees","Contractual arrangement with a professional company"]
["WSHOP","WORKSHOPS & TRAINING","For all Workshops, Trainings, Statutory Meetings"]
[680,"Workshops & Training","Cost related to the renting of venue, registration fees, catering services - this does not include travel cost of participants which should be budgeted under Travel"]
["GENERAL","GENERAL EXPENDITURE","General Expenses"]
[700,"Travel","All Travel related expenses (regardless of purpose) - tickets, visa, accomodation, perdiem"]
[710,"Information & Public Relations","Publising Costs (Writing, Editing, Translations, Printing, Design); PR Activities (Events, Materials, Representation Expenses, Souvenirs); Purchase of publications (Books, Newspapers, Subscriptions)"]
[730,"Office Costs","Office Rent, Stationary, Photocopy, Office Equipment and Maintenance, Cleaning and Insurance which are not already included in the country's Shared Office and Services Costs Budget"]
[740,"Communications","Postage, Courier, Phone, Mobile, Internet, Satellite"]
[760,"Financial Charges","Banking Charges, Foreign Exchange gain/loss provisions, Other Financial fees"]
[790,"Other General Expenses","Sundry Expenses"]
[799,"Shared Office and Services Costs","Shared Office and Services Cost allocation as applicable"]
["DEP.","DEPRECIATION","IFRC Assets Depreciation"]
[798,"Assets Depreciation","Depreciation costs of IFRC Assets : vehicles, generators, office equipment, software, buildings"]
["TRFs","CASH TRANSFERS TO PARTNERS","Contributions or Transers made to Partners who are implementing part or a component of a project"]
[830,"Cash Transfers National Societies","Partners are National Societies"]
[831,"Cash Transfers to 3rd Parties","Partners are any other NGO, UN Agency, ICRC or other"]
[]
[]
[]
[]
[null,"Readiness"]
[null,"Pre-Pos Stock"]
[null,"Early Action"]
[]
[]
[null,"YEAR_01"]
[null,"YEAR_02"]
[null,"YEAR_03"]
[null,"YEAR_04"]
[null,"YEAR_05"]
[null,"YEAR_EA"]
[]
[]
[null,"HOST_NS"]
[null,"PARTNER_NS"]
[null,"IFRC"]

{"sheet":"output codes","index":6,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["IFRC - OUTPUT CODES 2021"]
[]
["Group","Group Name","SP&E","SP&E Name","Outcome","Outcome Name","Output","Output Name","OP Plan","OP Plan Name","PLAN","OP RM code","OP Plan Result Matrix","RESULT"]
["SP","Strategic Priority","SP2","Evolving crises and disasters","SP2.2","Disaster and crises response","AP005","Shelter assistance to households","PO","Planned Operations","PO - Planned Operations","PO01","Shelter and Basic Household Items","PO01 - Shelter and Basic Household Items"]
["SP","Strategic Priority","SP2","Evolving crises and disasters","SP2.2","Disaster and crises response","AP007","Improvement of income sources","PO","Planned Operations","PO - Planned Operations","PO02","Livelihoods ","PO02 - Livelihoods "]
["SP","Strategic Priority","SP2","Evolving crises and disasters","SP2.2","Disaster and crises response","AP081","Multipurpose cash grants","PO","Planned Operations","PO - Planned Operations","PO03","Multi-purpose Cash","PO03 - Multi-purpose Cash"]
["SP","Strategic Priority","SP3","Growing gaps in health and wellbeing","SP3.1","National Society Health capacity","AP107","NS health capacity","PO","Planned Operations","PO - Planned Operations","PO04","Health","PO04 - Health"]
["SP","Strategic Priority","SP3","Growing gaps in health and wellbeing","SP3.2","Health services","AP108","Health services","PO","Planned Operations","PO - Planned Operations","PO04","Health","PO04 - Health"]
["SP","Strategic Priority","SP3","Growing gaps in health and wellbeing","SP3.3","Health services in emergencies","AP109","Health services in emergencies","PO","Planned Operations","PO - Planned Operations","PO04","Health","PO04 - Health"]
["SP","Strategic Priority","SP3","Growing gaps in health and wellbeing","SP3.4","Water, Sanitation and Hygiene","AP110","WASH","PO","Planned Operations","PO - Planned Operations","PO05","Water, Sanitation & Hygiene","PO05 - Water, Sanitation & Hygiene"]
["SP","Strategic Priority","SP3","Growing gaps in health and wellbeing","SP3.5","Water, Sanitation and Hygiene in emergencies","AP111","WASH in emergencies","PO","Planned Operations","PO - Planned Operations","PO05","Water, Sanitation & Hygiene","PO05 - Water, Sanitation & Hygiene"]
["SP","Strategic Priority","SP5","Values, Power and Inclusion","SP5.1","Humanitarian values and principles","AP114","Humanitarian values and principles","PO","Planned Operations","PO - Planned Operations","PO06","Protection, Gender and Inclusion","PO06 - Protection, Gender and Inclusion"]
["SP","Strategic Priority","SP5","Values, Power and Inclusion","SP5.3","Protection, gender and inclusion services","AP116","Protection/gender/inclusion services","PO","Planned Operations","PO - Planned Operations","PO06","Protection, Gender and Inclusion","PO06 - Protection, Gender and Inclusion"]
["SP","Strategic Priority","SP5","Values, Power and Inclusion","SP5.4","National Society Protection, Gender and Inclusion capacity","AP117","Protection/gender/inclusion capacity","PO","Planned Operations","PO - Planned Operations","PO06","Protection, Gender and Inclusion","PO06 - Protection, Gender and Inclusion"]
["SP","Strategic Priority","SP5","Values, Power and Inclusion","SP5.2","Access to education","AP115","Access to education","PO","Planned Operations","PO - Planned Operations","PO07","Education","PO07 - Education"]
["SP","Strategic Priority","SP4","Migration and identity","SP4.1","Support to migrants and displaced","AP112","Support to migrants and displaced","PO","Planned Operations","PO - Planned Operations","PO08","Migration","PO08 - Migration"]
["SP","Strategic Priority","SP4","Migration and identity","SP4.2","National Society migration and displacement capacity","AP113","NS Migration & Displacement Capacity","PO","Planned Operations","PO - Planned Operations","PO08","Migration","PO08 - Migration"]
["SP","Strategic Priority","SP1","Climate and environmental crises","SP1.1","Climate change adaptation","AP101","Climate change adaptation","PO","Planned Operations","PO - Planned Operations","PO09","Risk Reduction, Climate Adaptation and Recovery","PO09 - Risk Reduction, Climate Adaptation and Recovery"]
["SP","Strategic Priority","SP2","Evolving crises and disasters","SP2.1","Community risk reduction","AP103","Comm. risk reduction and resilience","PO","Planned Operations","PO - Planned Operations","PO09","Risk Reduction, Climate Adaptation and Recovery","PO09 - Risk Reduction, Climate Adaptation and Recovery"]
["SP","Strategic Priority","SP2","Evolving crises and disasters","SP2.2","Disaster and crises response","AP104","Assistance to people affected","PO","Planned Operations","PO - Planned Operations","PO09","Risk Reduction, Climate Adaptation and Recovery","PO09 - Risk Reduction, Climate Adaptation and Recovery"]
["E","Enabler","E8","Trusted","E8.6","Community engagement and accountability","AP129","Community engagement/accountability","PO","Planned Operations","PO - Planned Operations","PO10","Community Engagement and Accountability","PO10 - Community Engagement and Accountability"]
["SP","Strategic Priority","SP1","Climate and environmental crises","SP1.2","Climate change mitigation and environmental sustainability","AP102","Climate change mitigation&greening","PO","Planned Operations","PO - Planned Operations","PO11","Environmental Sustainability","PO11 - Environmental Sustainability"]
["E","Enabler","E6","Engaged","E6.3","Innovation","AP120","Innovation","EA","Enabling Approaches","EA - Enabling Approaches","EA01","Coordination and Partnerships","EA01 - Coordination and Partnerships"]
["SP","Strategic Priority","SP2","Evolving crises and disasters","SP2.2","Disaster and crises response","AP049","IFRC coord. in humanitarian system","EA","Enabling Approaches","EA - Enabling Approaches","EA01","Coordination and Partnerships","EA01 - Coordination and Partnerships"]
["SP","Strategic Priority","SP2","Evolving crises and disasters","SP2.4","Disaster Law","AP106","Disaster Law","EA","Enabling Approaches","EA - Enabling Approaches","EA01","Coordination and Partnerships","EA01 - Coordination and Partnerships"]
["E","Enabler","E6","Engaged","E6.1","Engagement with stakeholders","AP118","Engagement w. stakeholders","EA","Enabling Approaches","EA - Enabling Approaches","EA01","Coordination and Partnerships","EA01 - Coordination and Partnerships"]
["E","Enabler","E6","Engaged","E6.2","Influencing and humanitarian diplomacy","AP119","Influencing and hum. diplomacy","EA","Enabling Approaches","EA - Enabling Approaches","EA01","Coordination and Partnerships","EA01 - Coordination and Partnerships"]
["E","Enabler","E6","Engaged","E6.4","Digital transformation","AP121","Digital transformation","EA","Enabling Approaches","EA - Enabling Approaches","EA01","Coordination and Partnerships","EA01 - Coordination and Partnerships"]
["E","Enabler","E8","Trusted","E8.4","Membership Coordination","AP127","Membership Coordination","EA","Enabling Approaches","EA - Enabling Approaches","EA01","Coordination and Partnerships","EA01 - Coordination and Partnerships"]
["E","Enabler","E8","Trusted","E8.5","Movement Cooperation","AP128","Movement Cooperation","EA","Enabling Approaches","EA - Enabling Approaches","EA01","Coordination and Partnerships","EA01 - Coordination and Partnerships"]
["E","Enabler","E7","Accountable","E7.1","Secretariat services strengthening","AP122","Secretariat services strengthening","EA","Enabling Approaches","EA - Enabling Approaches","EA02","Secretariat Services","EA02 - Secretariat Services"]
["E","Enabler","E7","Accountable","E7.2","Financing the future","AP123","Financing the future","EA","Enabling Approaches","EA - Enabling Approaches","EA02","Secretariat Services","EA02 - Secretariat Services"]
["SP","Strategic Priority","SP2","Evolving crises and disasters","SP2.3","National Society Disaster Management capacity","AP105","NS DM capacity","EA","Enabling Approaches","EA - Enabling Approaches","EA03","National Society Strengthening","EA03 - National Society Strengthening"]
["E","Enabler","E8","Trusted","E8.1","National Society development","AP124","National Society Development","EA","Enabling Approaches","EA - Enabling Approaches","EA03","National Society Strengthening","EA03 - National Society Development"]
["E","Enabler","E8","Trusted","E8.2","Volunteering development","AP125","Volunteering development","EA","Enabling Approaches","EA - Enabling Approaches","EA03","National Society Strengthening","EA03 - National Society Development"]
["E","Enabler","E8","Trusted","E8.3","Leadership development","AP126","Leadership development","EA","Enabling Approaches","EA - Enabling Approaches","EA03","National Society Strengthening","EA03 - National Society Development"]

{"sheet":"FedBudget data","index":7,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,2,4,7],[1,3,1,7]]}
["International Federation of Red Cross and Red Crescent Societies ",null,null,null,null,null,null,null,{"$f":"VERSION","v":"V2024.01"}]
["Fedbudget data",null,null,"don't forget to refresh the pivot table before exporting to fedbudget"]
[]
[]
["DATA SORT",null,"COPY / PASTE COLUMN DATA TO FEDBUDGET COLUMNS",null,null,null,null,null,"CHECK TOTALS"]
[null,null,"C","D","E","G","O","Q","M"]
[]
["Row Labels","Year","Description","Quantity","Unit","UnitCost","Budget","Output\nCode","Total CHF"]
["Grand Total"]

{"sheet":"Guidelines","index":8,"n_rows":128,"n_cols":9,"rows_kept":128,"cut":false,"hidden":false,"merged":[[110,0,110,8],[61,1,61,7],[104,0,104,8],[105,0,105,8],[108,0,108,8],[123,0,123,8],[122,0,122,8],[10,0,10,8],[118,0,118,8],[17,0,17,8],[20,0,20,8],[83,5,84,8],[100,0,100,8],[101,0,101,8],[113,0,113,8],[114,0,114,8],[35,0,35,7],[52,0,52,7],[62,2,62,7],[63,2,63,7],[109,0,109,8],[5,0,5,8],[7,0,7,8],[6,0,6,8],[11,0,11,8],[76,0,76,8],[29,2,29,7],[65,2,65,7],[60,2,60,7],[75,0,75,8],[32,0,32,8],[33,0,33,8],[43,0,43,8],[53,0,53,8],[64,2,64,7],[50,1,50,7]]}
["International Federation of Red Cross and Red Crescent Societies ",null,null,null,null,null,null,null,"V2024.01"]
["Early Action Protocol (EAP) budget tool for National Societies"]
["Guidelines",null,"The Workbook needs to be saved as a .xlsm (macro-enabled workbook)"]
[]
["Purpose"]
["The [EAP budget template] is a budget tool designed for National Societies when applying for DREF funding to cover the costs of an Early Action Protocol - combining both readiness and early action activities."]
["It is structured in accordance with the IFRC's planning matrix to the level of output code; and by resources required to implement the plan as per the IFRC's budget groups."]
["This template allows for an easy conversion to the IFRC's budget tool FedBudget."]
[]
["Fedbudget"]
["The [EAP budget template] does not replace the IFRC's standard budgeting template [FedBudget], official budget tool to be used by IFRC Project Managers with support from Finance for all IFRC Projects Operating Budgets."]
["The FedBudget template and tutorial videos can be found on FedNet at:"]
["https://fednet.ifrc.org/en/support/finance1/systems-access/FedBudget/"]
[]
["Workbook sheets"]
[]
["budget_tool"]
["This is the main sheet to be completed by the National Society and reviewed by the IFRC Project Manager."]
[]
["Header"]
["The first part of the [budget_tool] is the header where following information should be provided:"]
[null,"National Society","Name of the National Society (Coutry) applying for funding"]
[null,"Partner National Society","Where applicable, name of the Partner National Society co-implementing the EAP"]
[null,"Appeal Code","If available, else to be subsequently added by the IFRC Project Manager"]
[null,"Date","Date at which the budget is drafted (to be updated when revised)"]
[null,"EAP Name (Hazard)","Name of the Hazard for which the Early Action Protocol is submitted"]
[null,"Dates From / To","Indicate the Timeframe for which the Early Action Protocol is submitted"]
[null,"EAP Code","If available, else to be subsequently added by the IFRC Project Manager"]
[null,"Local Currency (LC)","Currency in which the budget is drafted"]
[null,"Exchange Rate","Exchange rate to convert the budget into Swiss Francs (CHF) \nrecommended rate : Oanda.com per date at which the budget is drafted"]
[]
["Budget Table"]
["The budget table is broken down by ouput code (grouped by thematic for reporting purposes)"]
["Each Output code has 5 budget lines, more can be added if required."]
[]
["To add a budget line?"]
["Output\nCode","Description","Activity [select]","Implemented by [select]","Year [select]","Budget\nGroup","Quantity","Unit","Unit\nCost"]
["AP005"]
["AP005"]
["AP005"]
["AP005"]
["TOT_AP005","Shelter assistance to households"]
[]
["A new row is added with the output code cell highlighted in red, att the missing output code"]
["Output\nCode","Description","Activity [select]","Implemented by [select]","Year [select]","Budget\nGroup","Quantity","Unit","Unit\nCost"]
["AP005"]
["AP005"]
[]
["AP005"]
["TOT_AP005","Shelter assistance to households",null,null,null,null,null,null,"AP005"]
["Note","If the output code is not added, the budget line will not be included in the calculations"]
[]
["Budget table headings"]
["Each budget lines should include the following information per example:"]
["Output\nCode","Description","Activity [select]","Implemented by [select]","Year [select]","Budget\nGroup","Quantity","Unit","Unit\nCost"]
["AP005","Volunteering development","Readiness","HOST_NS","YEAR_01",667,100,"perdiem",25]
["AP005","Volunteering development","Readiness","HOST_NS","YEAR_02",667,100,"perdiem",25]
["AP005"]
[]
[null,"Output Code","Output code as per the operating plan"]
[null,"Description","Description of the budget line, specifically the resource required to implement the plan"]
[null,"Drop Down List should never be overwritten with copy/paste from other excel sheets, always use the selection"]
[null,"Activity","Activity is a drop down list enabling the selection between [Readiness], [Pre-Pos Stock] or [Early Action], the budget components of the Early Action Protocol"]
[null,"Implemented by","Implemented by is a drop down list enabling the selection between [Host_NS], [Partner_NS] and [IFRC]: this reflects which partner will incurr the costs"]
[null,"Year","Year is a drop down list enabling the selection of the year in which the activity is to be implemented. Note for Early Action activities, the year to select should be YEAR_EA"]
[null,"Budget Group","Budget Group is a drop down list from the [budget_groups] sheet; select appropriate budget group as per the description and resource required"]
[null,"Quantity and Unit Cost must be completed in order to calculate the budget line"]
[null,"Quantity","Quantity of the resource needed to implement the plan"]
[null,"Unit","Unit measure of the resource needed to implement the plan"]
[null,"Unit Cost","Unit Cost in Local Currency (LC) of the resource needed to implement the plan"]
[null,"Total Cost LC","Calculates the Quantity * Unit Costs in Local Currency (LC)"]
[null,"Total Cost CHF","Calculates the Total Cost LC into Swiss Francs (CHF) as per header rate"]
[]
[]
[]
["review and printing"]
[" To reduce the number of pages for review and/or printing :"]
["Option 1","Filter for budget lines & respective totals only"]
[]
[]
[]
[]
[]
[null,null,null,null,"Option 2","Summary by Ouput codes and Areas, or summary by Areas only, using outline selections"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Select [1]","summarises the budget by planned operations"]
[null,null,null,"Select [2]","summarises the budget by planned operations & output codes"]
[null,null,null,"Select [3]","to open up the table with all details"]
[]
[null,"EAP for publication"]
["This sheet is intended for the publication of the Early Action Protocol as an annex to the narrative. "]
["It summarises the budget by planned operations/areas and enabling approaches."]
[]
[null,null,"Summary by AP Code"]
["This sheet is intended for review of the budget."]
["It summarises the budget by planned operations/areas and enabling approaches by output code."]
[]
[null,null,null,"Summary by Year"]
["This sheet is intended for review of the budget."]
["It summarises the budget by Implementing Partner / Activity / Year."]
["It includes a number of cross-checks such as maximum values, year allocations etc."]
[]
[null,null,null,null,"Resource Budget summary"]
["This sheet is intended for the approval process of the Early Action Protocol as an annex to the EAP's plan/narrative."]
["It summarises the budget by needed resources per IFRC's budget groups"]
[]
[]
[null,null,null,null,"budget_groups"]
["The [budget_groups] sheet lists the IFRC Budget groups codes with their name and description and serves as the drop-down list for the the [budget group] field in the budget_tool."]
[]
[]
[null,null,null,null,null,null,"FedBudget data"]
["This sheet summarises the [budget_tool] table in a format which can be easily copy/paste into Fedbudget."]
["The data is a pivot table which refreshed upon opening of the workbook, but should always be refreshed before exporting data to FedBudget (to ensure that any updates are duly reflected)."]
[]
[]
["Updated on 30/01/2024"]
["EAP202201"]