{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["budget_tool","EAP for publication","Summary by APcode","Resource Budget summary","Summary by Year","budget_groups","WBS","Guidelines"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":46,"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":13,"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,null,null,{"$f":"VERSION","v":"V2025.01.2"}]
["Early Action Protocol budget tool for National Societies",null,null,null,null,null,null,null,null,null,null,"DREF202101"]
[]
["National Society",null,null,"Partner National Society",null,null,null,"Protocol Number",null,null,"Protocol Type (mandatory field)",null,"Date"]
["Country National Society",null,null,"Partner National Society",null,null,null,"EAP#",null,null,"Simplified EAP",null,"2025-01-01"]
[]
["Early Action Protocol Name (Hazard)",null,null,"From (date)",null,"To (date",null,"Appeal Code",null,null,"Currency  (LC)    &","Exchange Rate"]
["Name of Hazard",null,null,"2025-01-01","TO","2025-12-31",null,"Code",null,null,"CHF",1]
[]
[null,null,"do not copy/paste to these cells, use the drop down list"]
["Output\nCode","Description","Block [select]","Implemented by [select]","Year [select]","Budget\nGroup","Quantity","Unit","Unit\nCost","Unit Cost CHF","Total Cost LC","Total Cost CHF","Review/Comments"]
["AP005",null,null,null,null,null,null,null,null,{"$f":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K17","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K24","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K31","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K38+K44+K50","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K57+K63","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K70+K76+K82","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K89","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K96+K102","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K109+K115+K121+K127+K133","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K140","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K147","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K154+K160+K166+K172+K178+K184+K190","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K197","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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$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":"+BUDGET[[#This Row],[Total Cost CHF]]/BUDGET[[#This Row],[Quantity]]","v":{"$error":"#DIV/0!"}},{"$f":"+K204+K210+K216","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,null,{"$f":"+K18+K25+K32+K51+K64+K83+K90+K103+K134+K141+K148+K191+K198+K217","v":0},{"$f":"+L18+L25+L32+L51+L64+L83+L90+L103+L134+L141+L148+L191+L198+L217","v":0}]
[null,"INDIRECT COSTS",null,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,null,{"$f":"+BUDGET[[#Totals],[Total Cost LC]]+K219","v":0},{"$f":"+BUDGET[[#Totals],[Total Cost CHF]]+L219","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_APPEAL,\" - \",NAME_NS)","v":"Code - Country National Society"}]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(NAME_EAP)","v":"Name of Hazard"}]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(EAP_TYPE,\" - \",CODE_EAP)","v":"Simplified EAP - EAP#"}]
[]
[]
["Operating Budget",null,"Readiness","Pre-Pos Stock","Early Action","TOTAL",null,"all amounts inclusive of indirect costs"]
[]
["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,{"$f":"SUM(H12:H22)","v":0},{"$f":"+F11-H11","v":0}]
["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'!J9","v":0},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'!J11","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'!J13","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'!J15","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'!J19","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'!J22","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'!J26","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'!J28","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'!J31","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'!J37","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'!J39","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},null,{"$f":"SUM(H24:H26)","v":0},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'!J42","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'!J50","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'!J52","v":0},{"$f":"+F26-H26","v":0}]
[null,null,null,null,null,null,null,"budget tool variance"]
[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!L220","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_APPEAL,\" - \",NAME_NS)","v":"Code - Country National Society"}]
[null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(NAME_EAP)","v":"Name of Hazard"},null,null,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],\"\")","v":0},{"$f":"IF(J5=0,\"\",\"CHECK BUDGET LINES WITHOUT AP CODE\")","v":""}]
[null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(EAP_TYPE,\" - \",CODE_EAP)","v":"Simplified EAP - EAP#"},null,null,"all amounts inclusive of indirect costs"]
["Operating Budget by Output Codes",null,null,"Readiness","Pre-Pos Stock","Early Action","TOTAL",null,null,"direct costs","variance"]
["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,{"$f":"+J9+J11+J13+J15+J19+J22+J26+J28+J31+J37+J39","v":0},0]
["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,null,{"$f":"SUM(J10)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D10:F10)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B10))*106.5/100,2)","v":0},{"$f":"+G10-J10","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,null,{"$f":"SUM(J12)","v":0},{"$f":"SUM(K12)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D12:F12)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B12))*106.5/100,2)","v":0},{"$f":"+G12-J12","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,null,{"$f":"SUM(J14)","v":0},{"$f":"SUM(K14)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D14:F14)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B14))*106.5/100,2)","v":0},{"$f":"+G14-J14","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,null,{"$f":"SUM(J16:J18)","v":0},{"$f":"SUM(K16:K18)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D16:F16)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B16))*106.5/100,2)","v":0},{"$f":"+G16-J16","v":0}]
[null,"AP108","Health services",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B17,BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D17:F17)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B17))*106.5/100,2)","v":0},{"$f":"+G17-J17","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D18:F18)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B18))*106.5/100,2)","v":0},{"$f":"+G18-J18","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,null,{"$f":"SUM(J20:J21)","v":0},{"$f":"SUM(K20:K21)","v":0}]
[null,"AP110","WASH",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B20,BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D20:F20)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B20))*106.5/100,2)","v":0},{"$f":"+G20-J20","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D21:F21)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B21))*106.5/100,2)","v":0},{"$f":"+G21-J21","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,null,{"$f":"SUM(J23:J25)","v":0},{"$f":"SUM(K23:K25)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D23:F23)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B23))*106.5/100,2)","v":0},{"$f":"+G23-J23","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D24:F24)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B24))*106.5/100,2)","v":0},{"$f":"+G24-J24","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D25:F25)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B25))*106.5/100,2)","v":0},{"$f":"+G25-J25","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,null,{"$f":"SUM(J27)","v":0},{"$f":"SUM(K27)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D27:F27)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B27))*106.5/100,2)","v":0},{"$f":"+G27-J27","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,null,{"$f":"SUM(J29:J30)","v":0},{"$f":"SUM(K29:K30)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D29:F29)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B29))*106.5/100,2)","v":0},{"$f":"+G29-J29","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D30:F30)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B30))*106.5/100,2)","v":0},{"$f":"+G30-J30","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,null,{"$f":"SUM(J32:J36)","v":0},{"$f":"SUM(K32:K36)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D32:F32)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B32))*106.5/100,2)","v":0},{"$f":"+G32-J32","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D33:F33)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B33))*106.5/100,2)","v":0},{"$f":"+G33-J33","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D34:F34)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B34))*106.5/100,2)","v":0},{"$f":"+G34-J34","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D35:F35)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B35))*106.5/100,2)","v":0},{"$f":"+G35-J35","v":0}]
[null,"AP106","Disaster Law",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B36,BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D36:F36)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B36))*106.5/100,2)","v":0},{"$f":"+G36-J36","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,null,{"$f":"SUM(J38)","v":0},{"$f":"SUM(K38)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D38:F38)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B38))*106.5/100,2)","v":0},{"$f":"+G38-J38","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,null,{"$f":"SUM(J40)","v":0},{"$f":"SUM(K40)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D40:F40)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B40))*106.5/100,2)","v":0},{"$f":"+G40-J40","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},null,null,{"$f":"+J42+J50+J52","v":0},{"$f":"+K42+K50+K52","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,null,{"$f":"SUM(J43:J49)","v":0},{"$f":"SUM(K43:K49)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D43:F43)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B43))*106.5/100,2)","v":0},{"$f":"+G43-J43","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},0,null,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,null,{"$f":"SUM(J51)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D51:F51)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B51))*106.5/100,2)","v":0},{"$f":"+G51-J51","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,null,{"$f":"SUM(J53:J55)","v":0},{"$f":"SUM(K53:K55)","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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D53:F53)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B53))*106.5/100,2)","v":0},{"$f":"+G53-J53","v":0}]
[null,"AP125","Volunteering development",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B54,BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D54:F54)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B54))*106.5/100,2)","v":0},{"$f":"+G54-J54","v":0}]
[null,"AP126","Leadership development",{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B55,BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\"))*106.5/100,2)","v":0},{"$f":"SUM(D55:F55)","v":0},null,null,{"$f":"ROUND( (SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Output\nCode]],B55))*106.5/100,2)","v":0},{"$f":"+G55-J55","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,null,{"$f":"+J41+J8","v":0},{"$f":"+G57-J57","v":0}]
["all amounts in Swiss Francs (CHF)",null,null,null,null,null,null,null,"per tool",{"$f":"+TOT_BUDGET","v":0},{"$f":"+G57-J58","v":0}]

{"sheet":"Resource Budget summary","index":3,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Early Action Protocol Summary"]
[]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(CODE_APPEAL,\" - \",NAME_NS)","v":"Code - Country National Society"}]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(NAME_EAP)","v":"Name of Hazard"}]
[null,null,null,null,null,{"$f":"_xlfn.CONCAT(EAP_TYPE,\" - \",CODE_EAP)","v":"Simplified EAP - EAP#"}]
[]
[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(C10:C24)","v":0},{"$f":"SUM(D10:D24)","v":0},{"$f":"SUM(E10:E24)","v":0},{"$f":"SUM(F10:F24)","v":0},null,{"$f":"+C9+E9-F9+D9","v":0}]
[500,"Shelter - Relief",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A10,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A10,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A10,BUDGET[[#Headers],[#Data],[Block '[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}]
[501,"Shelter - Transitional",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A11,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A11,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A11,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A11)","v":0},null,{"$f":"+C11+E11-F11+D11","v":0}]
[502,"Construction - Housing",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A12,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A12,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A12,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A12)","v":0},null,0]
[503,"Construction - Facilities",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A13,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A13,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A13,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A13)","v":0},null,0]
[505,"Construction Materials",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A14,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A14,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A14,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A14)","v":0},null,0]
[510,"Clothing & Textiles",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A15,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A15,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A15,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A15)","v":0},null,0]
[520,"Food",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A16,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A16,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A16,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A16)","v":0},null,0]
[523,"Seeds & Plants",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A17,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A17,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A17,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A17)","v":0},null,0]
[530,"Water, Sanitation & Hygiene",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A18,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A18,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A18,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A18)","v":0},null,0]
[540,"Medical & First Aid",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A19,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A19,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A19,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A19)","v":0},null,0]
[550,"Teaching Materials",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A20,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A20,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A20,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A20)","v":0},null,0]
[560,"Utensils & Tools",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A21,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A21,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A21,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A21)","v":0},null,0]
[570,"Other Supplies & Services",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A22,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A22,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A22,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A22)","v":0},null,0]
[571,"Emergency Response Units",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A23,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A23,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A23,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A23)","v":0},null,0]
[578,"Cash Disbursment",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A24,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A24,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A24,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A24)","v":0},null,0]
[null,"LAND, VEHICLE & EQUIPMENT",{"$f":"SUM(C26:C31)","v":0},{"$f":"SUM(D26:D31)","v":0},{"$f":"SUM(E26:E31)","v":0},{"$f":"SUM(F26:F31)","v":0},null,0]
[580,"Land & Buildings",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A26,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A26,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A26,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A26)","v":0},null,0]
[581,"Vehicles",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A27,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A27,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A27,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A27)","v":0},null,0]
[582,"Computers & Telecom",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A28,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A28,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A28,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A28)","v":0},null,0]
[584,"Office & Household Equipment",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A29,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A29,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A29,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A29)","v":0},null,0]
[587,"Medical Equipment",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A30,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A30,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A30,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A30)","v":0},null,0]
[589,"Other Machinery & Equipment",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A31,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A31,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A31,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A31)","v":0},null,0]
[null,"LOGISTICS, TRANSPORT AND STORAGE",{"$f":"SUM(C33:C36)","v":0},{"$f":"SUM(D33:D36)","v":0},{"$f":"SUM(E33:E36)","v":0},{"$f":"SUM(F33:F36)","v":0},null,0]
[590,"Storage",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A33,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A33,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A33,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A33)","v":0},null,0]
[592,"Distribution & Monitoring",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A34,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A34,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A34,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A34)","v":0},null,0]
[593,"Transport & Vehicles Costs",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A35,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A35,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A35,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A35)","v":0},null,0]
[594,"Logistics Services",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A36,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A36,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A36,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A36)","v":0},null,0]
[null,"PERSONNEL",{"$f":"SUM(C38:C41)","v":0},{"$f":"SUM(D38:D41)","v":0},{"$f":"SUM(E38:E41)","v":0},{"$f":"SUM(F38:F41)","v":0},null,0]
[600,"International Staff",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A38,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A38,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A38,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A38)","v":0},null,0]
[661,"National Staff",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A39,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A39,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A39,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A39)","v":0},null,0]
[662,"National Society Staff",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A40,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A40,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A40,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A40)","v":0},null,0]
[667,"Volunteers",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A41,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A41,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A41,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A41)","v":0},null,0]
[null,"CONSULTANTS & PROFESSIONAL FEES",{"$f":"SUM(C43:C44)","v":0},{"$f":"SUM(D43:D44)","v":0},{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},null,0]
[670,"Consultants",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A43,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A43,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A43,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A43)","v":0},null,0]
[750,"Professional Fees",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A44,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A44,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A44,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A44)","v":0},null,0]
[null,"WORKSHOPS & TRAINING",{"$f":"SUM(C46)","v":0},{"$f":"SUM(D46)","v":0},{"$f":"SUM(E46)","v":0},{"$f":"SUM(F46)","v":0},null,0]
[680,"Workshops & Training",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A46,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A46,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A46,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A46)","v":0},null,0]
[null,"GENERAL EXPENDITURE",{"$f":"SUM(C48:C54)","v":0},{"$f":"SUM(D48:D54)","v":0},{"$f":"SUM(E48:E54)","v":0},{"$f":"SUM(F48:F54)","v":0},null,0]
[700,"Travel",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A48,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A48,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A48,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A48)","v":0},null,0]
[710,"Information & Public Relations",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A49,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A49,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A49,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A49)","v":0},null,0]
[730,"Office Costs",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A50,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A50,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A50,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A50)","v":0},null,0]
[740,"Communications",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A51,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A51,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A51,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A51)","v":0},null,0]
[760,"Financial Charges",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A52,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A52,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A52,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A52)","v":0},null,0]
[790,"Other General Expenses",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A53,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A53,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A53,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A53)","v":0},null,0]
[799,"Shared Office and Services Costs",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A54,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A54,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A54,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A54)","v":0},null,0]
[null,"DEPRECIATION",{"$f":"SUM(C56)","v":0},{"$f":"SUM(D56)","v":0},{"$f":"SUM(E56)","v":0},{"$f":"SUM(F56)","v":0},null,0]
[798,"Assets Depreciation",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A56,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A56,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A56,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A56)","v":0},null,0]
[null,"CASH TRANSFERS TO PARTNERS",{"$f":"SUM(C58:C59)","v":0},{"$f":"SUM(D58:D59)","v":0},{"$f":"SUM(E58:E59)","v":0},{"$f":"SUM(F58:F59)","v":0},null,0]
[830,"Cash Transfers National Societies",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A58,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A58,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A58,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A58)","v":0},null,0]
[831,"Cash Transfers to 3rd Parties",{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A59,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A59,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Budget\nGroup]],A59,BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},{"$f":"SUMIFS(BUDGET[Total Cost CHF],BUDGET[Budget\nGroup],A59)","v":0},null,0]
[null,null,null,null,null,null,null,0,"total checks"]
[null,"DIRECT COSTS TOTAL",{"$f":"+C9+C25+C32+C37+C42+C45+C47+C55+C57","v":0},{"$f":"+D9+D25+D32+D37+D42+D45+D47+D55+D57","v":0},{"$f":"+E9+E25+E32+E37+E42+E45+E47+E55+E57","v":0},{"$f":"+F9+F25+F32+F37+F42+F45+F47+F55+F57","v":0},null,0,null,{"$f":"+budget_tool!L218-F61","v":0},{"$f":"IF(J61>0, \"Check Budget Group/Activity Selection - either missing or wrong\",\" \")","v":" "}]
[null,"INDIRECT COSTS",{"$f":"ROUND(C61*6.5/100,2)","v":0},{"$f":"ROUND(D61*6.5/100,2)","v":0},{"$f":"ROUND(E61*6.5/100,2)","v":0},{"$f":"ROUND(F61*6.5/100,2)","v":0},null,0]
[null,"TOTAL BUDGET",{"$f":"+C61+C62","v":0},{"$f":"+D61+D62","v":0},{"$f":"+E61+E62","v":0},{"$f":"+F61+F62","v":0},null,0]

{"sheet":"Summary by Year","index":4,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,"Early Action Protocol Summary",null,null,null,{"$f":"EAP_TYPE","v":"Simplified EAP"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(CODE_APPEAL,\" - \",NAME_NS)","v":"Code - Country National Society"},null,null,null,{"$f":"IF(AND(N2= \"Simplified EAP\", I27>0), \"WARNING - Simplified EAP only 1 Trigger\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(NAME_EAP)","v":"Name of Hazard"},null,null,{"$f":"+B30","v":0},{"$f":"IF(B30>35%,\"WARNING - Readiness > 35%\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(EAP_TYPE,\" - \",CODE_EAP)","v":"Simplified EAP - EAP#"},null,null,{"$f":"IF(AND(J30<>0,J31<>0), (J30+J31)/J33,0)","v":0},{"$f":"IF(M6>65%,\"WARNING - Readiness & Stock > 65%\",\"\")","v":""}]
[]
["Implemented by",null,"YEAR_01","YEAR_02","YEAR_03","YEAR_04","YEAR_05","TRIGGER_01","TRIGGER_02","Total CHF",null,"check totals",null,"maximum threshold","variance"]
["Host National Society",{"$f":"IF(J9<>0,J9/$J$25,0)","v":0},{"$f":"SUM(C10:C12)","v":0},0,0,0,0,{"$f":"SUM(H10:H12)","v":0},0,0,null,{"$f":"SUM(C9:I9)-J9","v":0}]
["Readiness",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\")","v":0},null,0,null,{"$f":"IF(OR(H10>0,I10>0),\"Readiness not compatible with Trigger\", \"\")","v":""}]
["Pre-Pos Stock",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\")","v":0},null,0,null,{"$f":"IF(OR(H11>0,I11>0),\"PrepPos Stock not compatible with Trigger\", \"\")","v":""}]
["Early Action",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"HOST_NS\")","v":0},null,0,null,{"$f":"IF(OR(C12>0,D12>0,E12>0,F12>0,G12>0),\"Year_01to_05 not compatible with Early Action\", \"\")","v":""}]
["Partner National Society",0,{"$f":"SUM(C14:C16)","v":0},0,0,0,0,{"$f":"SUM(H14:H16)","v":0},0,0,null,0]
["Readiness",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\")","v":0},null,0,null,{"$f":"IF(OR(H14>0,I14>0),\"Readiness not compatible with Trigger\", \"\")","v":""}]
["Pre-Pos Stock",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\")","v":0},null,0,null,{"$f":"IF(OR(H15>0,I15>0),\"PrepPos Stock not compatible with Trigger\", \"\")","v":""}]
["Early Action",0,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"PARTNER_NS\")","v":0},null,0,null,{"$f":"IF(OR(C16>0,D16>0,E16>0,F16>0,G16>0),\"Year_01to_05 not compatible with Early Action\", \"\")","v":""}]
["National Society Direct Costs",null,{"$f":"+C9+C13","v":0},{"$f":"+D9+D13","v":0},0,0,0,{"$f":"+H9+H13","v":0},0,0,null,null,null,{"$f":"IF(EAP_TYPE=\"Standard EAP\",845070,IF(EAP_TYPE=\"Simplified EAP\",187793,0))","v":187793},{"$f":"+N17-J17","v":187793},{"$f":"IF(O17<0, \"OVERBUDGET!\", \" \")","v":" "}]
[]
["IFRC",{"$f":"IF(J19<>0,J19/$J$25,0)","v":0},{"$f":"SUM(C20:C22)","v":0},0,0,0,0,{"$f":"SUM(H20:H22)","v":0},0,0,null,{"$f":"SUM(C19:I19)-J19","v":0}]
["Readiness",{"$f":"IF(J20<>0,J20/$J$25,0)","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\")","v":0},null,{"$f":"SUM(C20:I20)-J20","v":0},null,{"$f":"IF(OR(H20>0,I20>0),\"Readiness not compatible with Trigger\", \"\")","v":""}]
["Pre-Pos Stock",{"$f":"IF(J21<>0,J21/$J$25,0)","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\")","v":0},null,{"$f":"SUM(C21:I21)-J21","v":0},null,{"$f":"IF(OR(H21>0,I21>0),\"PrepPos Stock not compatible with Trigger\", \"\")","v":""}]
["Early Action",{"$f":"IF(J22<>0,J22/$J$25,0)","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[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],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_01\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\",BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Year '[select']]],\"TRIGGER_02\")","v":0},{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\",BUDGET[[#Headers],[#Data],[Implemented by '[select']]],\"IFRC\")","v":0},null,{"$f":"SUM(C22:I22)-J22","v":0},null,{"$f":"IF(OR(C22>0,D22>0,E22>0,F22>0,G22>0),\"Year_01to_05 not compatible with Early Action\", \"\")","v":""}]
["IFRC Direct Costs",null,{"$f":"+C19","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(C23:I23)-J23","v":0},null,{"$f":"IF(EAP_TYPE=\"Standard EAP\",46948,IF(EAP_TYPE=\"Simplified EAP\",18779,0))","v":18779},{"$f":"+N23-J23","v":18779},{"$f":"IF(O23<0, \"OVERBUDGET!\", \" \")","v":" "}]
[]
["DIRECT COSTS TOTAL",{"$f":"IF(J25<>0,J25/$J$25,0)","v":0},{"$f":"+C17+C23","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(C25:I25)-J25","v":0},null,{"$f":"+N17+N23","v":206572},{"$f":"+N25-J25","v":206572}]
["INDIRECT COSTS",6.5000000000000002E-2,{"$f":"ROUND(C25*6.5/100,2)","v":0},{"$f":"ROUND(D25*6.5/100,2)","v":0},0,0,0,{"$f":"ROUND(H25*6.5/100,2)","v":0},0,0,null,{"$f":"SUM(C26:I26)-J26","v":0},null,{"$f":"ROUNDUP(N25*6.5/100,0)","v":13428},{"$f":"+N26-J26","v":13428}]
["TOTAL BUDGET",{"$f":"+B25+B26","v":6.5000000000000002E-2},0,0,0,0,0,0,0,0,null,{"$f":"SUM(C27:I27)-J27","v":0},null,{"$f":"+N25+N26","v":220000},{"$f":"+N27-J27","v":220000}]
[]
[null,null,"YEAR_01","YEAR_02","YEAR_03","YEAR_04","YEAR_05","TRIGGER_01","TRIGGER_02","Total CHF",null,null,null,"per budget tool","variance"]
["Readiness",{"$f":"IF(J30<>0,J30/$J$33,0)","v":0},{"$f":"+C10+C14+C20","v":0},0,0,0,0,0,0,0,null,{"$f":"SUM(C30:I30)-J30","v":0},null,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Readiness\")","v":0},{"$f":"+J30-N30","v":0}]
["Pre-Pos Stock",{"$f":"IF(J31<>0,J31/$J$33,0)","v":0},0,0,0,0,0,0,0,0,null,0,null,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Pre-Pos Stock\")","v":0},0]
["Early Action",{"$f":"IF(J32<>0,J32/$J$33,0)","v":0},0,0,0,0,0,0,0,0,null,0,null,{"$f":"SUMIFS(BUDGET[[#Headers],[#Data],[Total Cost CHF]],BUDGET[[#Headers],[#Data],[Block '[select']]],\"Early Action\")","v":0},0]
["DIRECT COSTS TOTAL",{"$f":"IF(J33<>0,J33/$J$33,0)","v":0},{"$f":"SUM(C30:C32)","v":0},0,0,0,0,{"$f":"SUM(H30:H32)","v":0},0,0,null,0,null,{"$f":"+BUDGET[[#Totals],[Total Cost CHF]]","v":0},0,{"$f":"IF(O33<0, \"Check Activity/Implemented by or Year Selection - either missing or wrong\",\" \")","v":" "}]
["INDIRECT COSTS",6.5000000000000002E-2,{"$f":"ROUND(C33*6.5/100,2)","v":0},0,0,0,0,{"$f":"ROUND(H33*6.5/100,2)","v":0},0,0,null,0,null,{"$f":"+TOT_INDIRECT","v":0},0]
["TOTAL BUDGET",{"$f":"+B33+B34","v":6.5000000000000002E-2},{"$f":"+C33+C34","v":0},0,0,0,0,{"$f":"+H33+H34","v":0},0,0,null,0,null,{"$f":"+TOT_BUDGET","v":0},0]

{"sheet":"budget_groups","index":5,"n_rows":75,"n_cols":3,"rows_kept":75,"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,"TRIGGER_01"]
[null,"TRIGGER_02"]
[]
[]
[null,"HOST_NS"]
[null,"PARTNER_NS"]
[null,"IFRC"]

{"sheet":"WBS","index":6,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[3,0,3,5]]}
["International Federation of Red Cross and Red Crescent Societies ",null,null,null,null,{"$f":"VERSION","v":"V2025.01.2"}]
["Data Summary for WBS"]
[]
["don't forget to refresh the pivot table to get most updated data"]
[]
["Implemented by","Year","Output","Budget","Description","Total CHF"]
["(blank)",null,null,null,null,0]
["TOTAL DIRECT COSTS",null,null,null,null,0]

{"sheet":"Guidelines","index":7,"n_rows":125,"n_cols":10,"rows_kept":125,"cut":false,"hidden":false,"merged":[[5,0,5,8],[6,0,6,8],[72,0,72,8],[26,2,26,7],[71,0,71,8],[29,0,29,8],[30,0,30,8],[40,0,40,8],[51,0,51,8],[58,2,58,8],[59,1,59,8],[120,0,120,8],[9,0,9,8],[116,0,116,8],[13,0,13,8],[16,0,16,8],[79,5,80,8],[98,0,98,8],[99,0,99,8],[111,0,111,8],[112,0,112,8],[32,0,32,7],[50,0,50,7],[107,0,107,8],[108,0,108,8],[102,0,102,8],[103,0,103,8],[106,0,106,8],[60,2,60,8],[61,2,61,8],[62,2,62,8],[63,2,63,8]]}
["International Federation of Red Cross and Red Crescent Societies ",null,null,null,null,null,null,null,null,"V2025.01.2"]
["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 under the Early Action Protocol or Simplified Early Action Protocol modality."]
["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."]
[]
["WBS"]
["The [EAP budget template] includes a budget summary under the sheet [WBS] to support the IFRC DREF Operations Project Manager to generate the WBS in IFRC's D365 system "]
[]
["Workbook sheets"]
["budget_tool"]
["This is the main sheet to be completed by the National Society and reviewed by the IFRC DREF Operations 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, subsequently added by the IFRC DREF Operations Project Manager"]
[null,"EAP type","Select whether this is an Early Action Protocol or Simplified Early Action Protocol"]
[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 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 total calculations will not include this budget line"]
[]
["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,\nalways 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"]
[]
["Other  workbook sheets"]
[]
[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 and information."]
["It summarises the budget at output level, grouped by planned operations and enabling approaches."]
[]
[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,"WBS"]
["This sheet summarises the budget by implementing party and ouput to allow the DREF Operations Project Manager an easy reconversion of the data into IFRC's D365 system"]
[]
[]
["Updated 19 August 2025"]
["EAP202201"]