{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["1 Information","2 BUDGET ","3.1 Instructions - NPAC","3.2 NPAC","4 Additional Notes "],"not_rendered":{"images":2,"external_links":1,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"1 Information","index":0,"n_rows":66,"n_cols":3,"rows_kept":66,"merged":[[8,0,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[23,0,23,2]]}
{"$rows_empty":8}
["TABLE 1: FULL COST RECOVERY BUDGET - PROJECT INFORMATION"]
["Lead Partner Organisation "]
["Project name"]
["Project number"]
["Project start date"]
["Project end date"]
["Total project cost"]
["Project country"]
["Thematic sector"]
["Budget version"]
["Date of budget revision"]
["Exchange Rate "]
["Prepared by"]
[]
[]
["TABLE 3: Partner details"]
["Partner Name","Name","SME status"]
["Lead Partner Organisation "]
["Partner 1"]
["Partner 2"]
["Partner 3"]
["Partner 4"]
["Partner 5"]
["Partner 6"]
["Partner 7"]
["Partner 8"]
["Partner 9"]
["Partner 10"]
[]
[]
["NOTES"]
{"$rows_empty":19}
[null,"Development Planning","SME"]
[null,"Economic Infrastructure","Not SME"]
[null,"Education"]
[null,"Environment Protection"]
[null,"Health"]
[null,"Humanitarian Assistance"]
[null,"Non-allocable"]
[null,"Other"]

{"sheet":"2 BUDGET ","index":1,"n_rows":85,"n_cols":120,"rows_kept":85,"merged":[[7,0,7,6],[8,0,8,3],[8,4,8,6],[8,7,8,8],[8,9,8,12],[9,0,9,5],[9,7,9,43],[9,44,9,80],[9,81,9,117],[10,6,11,6],[10,7,10,9],[10,13,10,15],[10,16,10,18],[10,19,10,21],[10,22,10,24],[10,25,10,27],[10,28,10,30],[10,31,10,33],[10,34,10,36],[10,37,10,39],[10,40,10,42],[10,50,10,52],[10,53,10,55],[10,56,10,58],[10,59,10,61],[10,62,10,64],[10,65,10,67],[10,68,10,70],[10,71,10,73],[10,74,10,76],[10,77,10,79],[10,87,10,89],[10,90,10,92],[10,93,10,95],[10,96,10,98],[10,99,10,101],[10,102,10,104],[10,105,10,107],[10,108,10,110],[10,111,10,113],[10,114,10,116],[11,1,11,3],[11,7,11,8],[11,44,11,45],[11,81,11,82],[77,13,77,15],[77,16,77,18],[77,19,77,21],[77,22,77,24],[77,25,77,27],[77,28,77,30],[77,31,77,33],[77,34,77,36],[77,37,77,39],[77,40,77,42],[77,50,77,52],[77,53,77,55],[77,56,77,58],[77,59,77,61],[77,62,77,64],[77,65,77,67],[77,68,77,70],[77,71,77,73],[77,74,77,76],[77,77,77,79],[77,87,77,89],[77,90,77,92],[77,93,77,95],[77,96,77,98],[77,99,77,101],[77,102,77,104],[77,105,77,107],[77,108,77,110],[77,111,77,113],[77,114,77,116],[82,13,82,14],[82,16,82,17],[82,19,82,20],[82,22,82,23],[82,25,82,26],[82,28,82,29],[82,31,82,32],[82,34,82,35],[82,37,82,38],[82,40,82,41],[82,50,82,51],[82,53,82,54],[82,56,82,57],[82,59,82,60],[82,62,82,63],[82,65,82,66],[82,68,82,69],[82,71,82,72],[82,74,82,75],[82,77,82,78],[82,87,82,88],[82,90,82,91],[82,93,82,94],[82,96,82,97],[82,99,82,100],[82,102,82,103],[82,105,82,106],[82,108,82,109],[82,111,82,112],[82,114,82,115],[83,13,83,14],[83,16,83,17],[83,19,83,20],[83,22,83,23],[83,25,83,26],[83,28,83,29],[83,31,83,32],[83,34,83,35],[83,37,83,38],[83,40,83,41],[83,50,83,51],[83,53,83,54],[83,56,83,57],[83,59,83,60],[83,62,83,63],[83,65,83,66],[83,68,83,69],[83,71,83,72],[83,74,83,75],[83,77,83,78],[83,87,83,88],[83,90,83,91],[83,93,83,94],[83,96,83,97],[83,99,83,100],[83,102,83,103],[83,105,83,106],[83,108,83,109],[83,111,83,112],[83,114,83,115]]}
{"$rows_empty":7}
["Table 1 below relates to costs for this PROJECT ONLY"]
[]
["TABLE 1: CLASSIFY DIRECT COSTS INTO COST CATEGORIES ",{"$nulls":6},"Budget Projection (Prior Estimate)",{"$nulls":36},"Actual Spend (Final Report)",{"$nulls":36},"Variances",{"$nulls":36},"Yes","Unit cost"]
[{"$nulls":6},"Delivered through partner?","Do not edit: cells update automatically",{"$nulls":5},{"v":1,"d":"Output 1"},null,null,{"v":2,"d":"Output 2"},null,null,{"v":3,"d":"Output 3"},null,null,{"v":4,"d":"Output 4"},null,null,{"v":5,"d":"Output 5"},null,null,{"v":6,"d":"Output 6"},null,null,{"v":7,"d":"Output 7"},null,null,{"v":8,"d":"Output 8"},null,null,{"v":9,"d":"Output 9"},null,null,{"v":10,"d":"Output 10"},{"$nulls":9},{"v":1,"d":"Output 1"},null,null,{"v":2,"d":"Output 2"},null,null,{"v":3,"d":"Output 3"},null,null,{"v":4,"d":"Output 4"},null,null,{"v":5,"d":"Output 5"},null,null,{"v":6,"d":"Output 6"},null,null,{"v":7,"d":"Output 7"},null,null,{"v":8,"d":"Output 8"},null,null,{"v":9,"d":"Output 9"},null,null,{"v":10,"d":"Output 10"},{"$nulls":9},{"v":1,"d":"Output 1"},null,null,{"v":2,"d":"Output 2"},null,null,{"v":3,"d":"Output 3"},null,null,{"v":4,"d":"Output 4"},null,null,{"v":5,"d":"Output 5"},null,null,{"v":6,"d":"Output 6"},null,null,{"v":7,"d":"Output 7"},null,null,{"v":8,"d":"Output 8"},null,null,{"v":9,"d":"Output 9"},null,null,{"v":10,"d":"Output 10"},{"$nulls":3},"No","Regular payment"]
["Line Code","Costs",{"$nulls":3},"Budget Heading (for internal purposes)",null,"Headlines",null,"Line Total","Type","Unit Cost","Name of Unit","No of units","Times repeated","Output 1","No of units","Times repeated","Output 2","No of units","Times repeated","Output 3","No of units","Times repeated","Output 4","No of units","Times repeated","Output 5","No of units","Times repeated","Output 6","No of units","Times repeated","Output 7","No of units","Times repeated","Output 8","No of units","Times repeated","Output 9","No of units","Times repeated","Output 10","Proportion","Headlines",null,"Line Total","Type","Unit Cost","Unit","No of units","Times repeated","Output 1","No of units","Times repeated","Output 2","No of units","Times repeated","Output 3","No of units","Times repeated","Output 4","No of units","Times repeated","Output 5","No of units","Times repeated","Output 6","No of units","Times repeated","Output 7","No of units","Times repeated","Output 8","No of units","Times repeated","Output 9","No of units","Times repeated","Output 10","Proportion","Headlines",null,"Line Total","Type","Unit Cost","Unit","No of units","Times repeated","Output 1","No of units","Times repeated","Output 2","No of units","Times repeated","Output 3","No of units","Times repeated","Output 4","No of units","Times repeated","Output 5","No of units","Times repeated","Output 6","No of units","Times repeated","Output 7","No of units","Times repeated","Output 8","No of units","Times repeated","Output 9","No of units","Times repeated","Output 10","Proportion",null,"Lump sum"]
["A","Inputs",{"$nulls":5},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A13)=1,CONCATENATE($A13, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A13)=3,CONCATENATE($A13, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},{"$f":"P13+S13+V13+Y13+AB13+AE13+AH13+AK13+AN13+AQ13","v":0},{"$nulls":5},{"$f":"PRODUCT($L13*1,N13*1,O13)","v":0},null,null,{"$f":"PRODUCT($L13*1,Q13*1,R13)","v":0},null,null,{"$f":"PRODUCT($L13*1,T13*1,U13)","v":0},null,null,{"$f":"PRODUCT($L13*1,W13*1,X13)","v":0},null,null,{"$f":"PRODUCT($L13*1,Z13*1,AA13)","v":0},null,null,{"$f":"PRODUCT($L13*1,AC13*1,AD13)","v":0},null,null,{"$f":"PRODUCT($L13*1,AF13*1,AG13)","v":0},null,null,{"$f":"PRODUCT($L13*1,AI13*1,AJ13)","v":0},null,null,{"$f":"PRODUCT($L13*1,AL13*1,AM13)","v":0},null,null,{"$f":"PRODUCT($L13*1,AO13*1,AP13)","v":0},{"$f":"IF($H13>0, $H13/$H$73, IF($I13>0, $I13/$H$73, IF($J13>0, $J13/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A13)=1,CONCATENATE($A13, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A13)=3,CONCATENATE($A13, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"BA13+BD13+BG13+BJ13+BM13+BP13+BS13+BV13+BY13+CB13","v":0},{"$nulls":5},{"$f":"PRODUCT($AW13*1,AY13*1,AZ13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BB13*1,BC13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BE13*1,BF13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BH13*1,BI13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BK13*1,BL13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BN13*1,BO13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BQ13*1,BR13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BT13*1,BU13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BW13*1,BX13)","v":0},null,null,{"$f":"PRODUCT($AW13*1,BZ13*1,CA13)","v":0},{"$f":"IF($AS13>0, $AS13/$AS$73, IF($AT13>0, $AT13/$AS$73, IF($AU13>0, $AU13/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"H13-AS13","v":0},0,0,{"$f":"CombineUnits(K13,AV13)","v":{"$error":"#NAME?"}},{"$f":"L13-AW13","v":0},{"$f":"CombineUnits(M13,AX13)","v":{"$error":"#NAME?"}},{"$f":"N13-AY13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AD13-BO13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H13,I13,J13,AS13,AT13,AU13)","v":{"$error":"#NAME?"}}]
["A.1",null,"Health",null,null,"PROJECT ACTIVITIES","No",{"$f":"SUMIF($A$13:$A$136, IF(LEN($A14)=1,CONCATENATE($A14, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},0,{"$f":"P14+S14+V14+Y14+AB14+AE14+AH14+AK14+AN14+AQ14","v":0},{"$nulls":5},{"$f":"PRODUCT($L14*1,N14*1,O14)","v":0},null,null,{"$f":"PRODUCT($L14*1,Q14*1,R14)","v":0},null,null,{"$f":"PRODUCT($L14*1,T14*1,U14)","v":0},null,null,{"$f":"PRODUCT($L14*1,W14*1,X14)","v":0},null,null,{"$f":"PRODUCT($L14*1,Z14*1,AA14)","v":0},null,null,{"$f":"PRODUCT($L14*1,AC14*1,AD14)","v":0},null,null,{"$f":"PRODUCT($L14*1,AF14*1,AG14)","v":0},null,null,{"$f":"PRODUCT($L14*1,AI14*1,AJ14)","v":0},null,null,{"$f":"PRODUCT($L14*1,AL14*1,AM14)","v":0},null,null,{"$f":"PRODUCT($L14*1,AO14*1,AP14)","v":0},{"v":0,"d":"0.0%"},0,0,{"$f":"BA14+BD14+BG14+BJ14+BM14+BP14+BS14+BV14+BY14+CB14","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$f":"CombineUnits(K14,AV14)","v":{"$error":"#NAME?"}},0,{"$f":"CombineUnits(M14,AX14)","v":{"$error":"#NAME?"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H14,I14,J14,AS14,AT14,AU14)","v":{"$error":"#NAME?"}}]
["A.2",null,"WASH",null,null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P15+S15+V15+Y15+AB15+AE15+AH15+AK15+AN15+AQ15","v":0},{"$nulls":5},{"$f":"PRODUCT($L15*1,N15*1,O15)","v":0},null,null,0,null,null,0,null,null,{"$f":"PRODUCT($L15*1,W15*1,X15)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H15,I15,J15,AS15,AT15,AU15)","v":{"$error":"#NAME?"}}]
["A.3",null,"Food",null,null,"PROJECT ACTIVITIES","No",{"$f":"SUMIF($A$13:$A$136, IF(LEN($A16)=1,CONCATENATE($A16, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},0,{"$f":"P16+S16+V16+Y16+AB16+AE16+AH16+AK16+AN16+AQ16","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H16,I16,J16,AS16,AT16,AU16)","v":{"$error":"#NAME?"}}]
["A.4",null,"Livelihoods",null,null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P17+S17+V17+Y17+AB17+AE17+AH17+AK17+AN17+AQ17","v":0},{"$nulls":5},{"$f":"PRODUCT($L17*1,N17*1,O17)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H17,I17,J17,AS17,AT17,AU17)","v":{"$error":"#NAME?"}}]
["A.5",null,"Shelter",null,null,"PROJECT ACTIVITIES","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["A.6",null,"NFIs",null,null,"PROJECT ACTIVITIES","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H19,I19,J19,AS19,AT19,AU19)","v":{"$error":"#NAME?"}}]
["A.7",null,"Education",null,null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P20+S20+V20+Y20+AB20+AE20+AH20+AK20+AN20+AQ20","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["A.8",null,"Cash transfers",null,null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P21+S21+V21+Y21+AB21+AE21+AH21+AK21+AN21+AQ21","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["A.9",null,"Others",null,null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P22+S22+V22+Y22+AB22+AE22+AH22+AK22+AN22+AQ22","v":0},{"$nulls":5},{"$f":"PRODUCT($L22*1,N22*1,O22)","v":0},null,null,{"$f":"PRODUCT($L22*1,Q22*1,R22)","v":0},null,null,{"$f":"PRODUCT($L22*1,T22*1,U22)","v":0},null,null,{"$f":"PRODUCT($L22*1,W22*1,X22)","v":0},null,null,{"$f":"PRODUCT($L22*1,Z22*1,AA22)","v":0},null,null,{"$f":"PRODUCT($L22*1,AC22*1,AD22)","v":0},null,null,{"$f":"PRODUCT($L22*1,AF22*1,AG22)","v":0},null,null,{"$f":"PRODUCT($L22*1,AI22*1,AJ22)","v":0},null,null,{"$f":"PRODUCT($L22*1,AL22*1,AM22)","v":0},null,null,{"$f":"PRODUCT($L22*1,AO22*1,AP22)","v":0},{"v":0,"d":"0.0%"},0,0,{"$f":"BA22+BD22+BG22+BJ22+BM22+BP22+BS22+BV22+BY22+CB22","v":0},{"$nulls":5},{"$f":"PRODUCT($AW22*1,AY22*1,AZ22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BB22*1,BC22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BE22*1,BF22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BH22*1,BI22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BK22*1,BL22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BN22*1,BO22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BQ22*1,BR22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BT22*1,BU22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BW22*1,BX22)","v":0},null,null,{"$f":"PRODUCT($AW22*1,BZ22*1,CA22)","v":0},{"v":0,"d":"0.0%"},{"$f":"H22-AS22","v":0},{"$f":"I22-AT22","v":0},{"$f":"J22-AU22","v":0},{"$f":"CombineUnits(K22,AV22)","v":{"$error":"#NAME?"}},{"$f":"L22-AW22","v":0},{"$f":"CombineUnits(M22,AX22)","v":{"$error":"#NAME?"}},{"$f":"N22-AY22","v":0},{"$f":"O22-AZ22","v":0},{"$f":"P22-BA22","v":0},{"$f":"Q22-BB22","v":0},{"$f":"R22-BC22","v":0},{"$f":"S22-BD22","v":0},{"$f":"T22-BE22","v":0},{"$f":"U22-BF22","v":0},{"$f":"V22-BG22","v":0},{"$f":"W22-BH22","v":0},{"$f":"X22-BI22","v":0},{"$f":"Y22-BJ22","v":0},{"$f":"Z22-BK22","v":0},{"$f":"AA22-BL22","v":0},{"$f":"AB22-BM22","v":0},{"$f":"AC22-BN22","v":0},{"$f":"AD22-BO22","v":0},{"$f":"AE22-BP22","v":0},{"$f":"AF22-BQ22","v":0},{"$f":"AG22-BR22","v":0},{"$f":"AH22-BS22","v":0},{"$f":"AI22-BT22","v":0},{"$f":"AJ22-BU22","v":0},{"$f":"AK22-BV22","v":0},{"$f":"AL22-BW22","v":0},{"$f":"AM22-BX22","v":0},{"$f":"AN22-BY22","v":0},{"$f":"AO22-BZ22","v":0},{"$f":"AP22-CA22","v":0},{"$f":"AQ22-CB22","v":0},{"$f":"ProportionVariance(H22,I22,J22,AS22,AT22,AU22)","v":{"$error":"#NAME?"}}]
["A.10",null,"Partner NPAC (see tab 3.1)",null,null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P23+S23+V23+Y23+AB23+AE23+AH23+AK23+AN23+AQ23","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["B","Transport",{"$nulls":5},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["B.1",null,"Transport of materials",null,null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P25+S25+V25+Y25+AB25+AE25+AH25+AK25+AN25+AQ25","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H25,I25,J25,AS25,AT25,AU25)","v":{"$error":"#NAME?"}}]
["B.1.1",null,null,"International shipping",null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P26+S26+V26+Y26+AB26+AE26+AH26+AK26+AN26+AQ26","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["B.1.2",null,null,"Port handling",null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P27+S27+V27+Y27+AB27+AE27+AH27+AK27+AN27+AQ27","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H27,I27,J27,AS27,AT27,AU27)","v":{"$error":"#NAME?"}}]
["B.1.3",null,null,"Truck rental",null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P28+S28+V28+Y28+AB28+AE28+AH28+AK28+AN28+AQ28","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["C","Security",{"$nulls":5},0,0,0,{"$nulls":5},{"$f":"PRODUCT($L29*1,N29*1,O29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,Q29*1,R29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,T29*1,U29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,W29*1,X29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,Z29*1,AA29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,AC29*1,AD29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,AF29*1,AG29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,AI29*1,AJ29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,AL29*1,AM29*1)","v":0},null,null,{"$f":"PRODUCT($L29*1,AO29*1,AP29*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW29*1,AY29*1,AZ29)","v":0},null,null,{"$f":"PRODUCT($AW29*1,BB29*1,BC29)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},{"$f":"N29-AY29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AC29-BN29","v":0},0,0,0,{"$f":"AG29-BR29","v":0},0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["C.1",null,"Staff",null,null,"PROJECT STAFF COSTS - PAY","No",0,0,{"$f":"P30+S30+V30+Y30+AB30+AE30+AH30+AK30+AN30+AQ30","v":0},{"$nulls":5},{"$f":"PRODUCT($L30*1,N30*1,O30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,Q30*1,R30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,T30*1,U30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,W30*1,X30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,Z30*1,AA30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,AC30*1,AD30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,AF30*1,AG30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,AI30*1,AJ30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,AL30*1,AM30*1)","v":0},null,null,{"$f":"PRODUCT($L30*1,AO30*1,AP30*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW30*1,AY30*1,AZ30)","v":0},null,null,{"$f":"PRODUCT($AW30*1,BB30*1,BC30)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["C.1.1",null,null,"Guard",null,"PROJECT STAFF COSTS - PAY","No",0,0,{"$f":"P31+S31+V31+Y31+AB31+AE31+AH31+AK31+AN31+AQ31","v":0},{"$nulls":33},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW31*1,AY31*1,AZ31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BB31*1,BC31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BE31*1,BF31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BH31*1,BI31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BK31*1,BL31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BN31*1,BO31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BQ31*1,BR31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BT31*1,BU31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BW31*1,BX31*1)","v":0},null,null,{"$f":"PRODUCT($AW31*1,BZ31*1,CA31*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["C.2",null,"Equipment",null,null,"CAPITAL EXPENDITURE ","No",0,0,{"$f":"P32+S32+V32+Y32+AB32+AE32+AH32+AK32+AN32+AQ32","v":0}]
["C.3",null,"Risk Management ",null,null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P33+S33+V33+Y33+AB33+AE33+AH33+AK33+AN33+AQ33","v":0},{"$nulls":5},{"$f":"PRODUCT($L33*1,N33*1,O33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,Q33*1,R33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,T33*1,U33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,W33*1,X33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,Z33*1,AA33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,AC33*1,AD33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,AF33*1,AG33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,AI33*1,AJ33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,AL33*1,AM33*1)","v":0},null,null,{"$f":"PRODUCT($L33*1,AO33*1,AP33*1)","v":0},{"$f":"IF($H32>0, $H32/$H$73, IF($I32>0, $I32/$H$73, IF($J33>0, $J33/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A32)=1,CONCATENATE($A32, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A32)=3,CONCATENATE($A32, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW33*1,AY33*1,AZ33)","v":0},null,null,{"$f":"PRODUCT($AW33*1,BB33*1,BC33)","v":0},null,null,{"$f":"PRODUCT($AW33*1,BE33*1,BF33)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($AS33>0, $AS33/$AS$73, IF($AT33>0, $AT33/$AS$73, IF($AU33>0, $AU33/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"H32-AS33","v":0},{"$f":"I32-AT33","v":0},{"$f":"J33-AU33","v":0},{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H32,I32,J33,AS33,AT33,AU33)","v":{"$error":"#NAME?"}}]
["D","Project logistics and admin (Note: include directly attributable costs only)",{"$nulls":5},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($H34>0, $H34/$H$73, IF($I34>0, $I34/$H$73, IF($J34>0, $J34/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A34)=1,CONCATENATE($A34, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A34)=3,CONCATENATE($A34, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW34*1,AY34*1,AZ34)","v":0},null,null,{"$f":"PRODUCT($AW34*1,BB34*1,BC34)","v":0},null,null,{"$f":"PRODUCT($AW34*1,BE34*1,BF34)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($AS34>0, $AS34/$AS$73, IF($AT34>0, $AT34/$AS$73, IF($AU34>0, $AU34/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["D.1",null,"Country Office",{"$nulls":3},"No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($H35>0, $H35/$H$73, IF($I35>0, $I35/$H$73, IF($J35>0, $J35/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A35)=1,CONCATENATE($A35, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A35)=3,CONCATENATE($A35, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW35*1,AY35*1,AZ35)","v":0},null,null,{"$f":"PRODUCT($AW35*1,BB35*1,BC35)","v":0},null,null,{"$f":"PRODUCT($AW35*1,BE35*1,BF35)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($AS35>0, $AS35/$AS$73, IF($AT35>0, $AT35/$AS$73, IF($AU35>0, $AU35/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["D.1.1",null,null,"Office space (rent, utilities etc)",null,"PROJECT ACTIVITIES","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($H36>0, $H36/$H$73, IF($I36>0, $I36/$H$73, IF($J36>0, $J36/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A36)=1,CONCATENATE($A36, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A36)=3,CONCATENATE($A36, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW36*1,AY36*1,AZ36)","v":0},null,null,{"$f":"PRODUCT($AW36*1,BB36*1,BC36)","v":0},null,null,{"$f":"PRODUCT($AW36*1,BE36*1,BF36)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($AS36>0, $AS36/$AS$73, IF($AT36>0, $AT36/$AS$73, IF($AU36>0, $AU36/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["D.1.2",null,null,"Communications",null,"PROJECT ACTIVITIES","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L37*1,N37*1,O37)","v":0},null,null,{"$f":"PRODUCT($L37*1,Q37*1,R37)","v":0},null,null,{"$f":"PRODUCT($L37*1,T37*1,U37)","v":0},null,null,{"$f":"PRODUCT($L37*1,W37*1,X37)","v":0},null,null,{"$f":"PRODUCT($L37*1,Z37*1,AA37)","v":0},null,null,{"$f":"PRODUCT($L37*1,AC37*1,AD37)","v":0},null,null,{"$f":"PRODUCT($L37*1,AF37*1,AG37)","v":0},null,null,{"$f":"PRODUCT($L37*1,AI37*1,AJ37)","v":0},null,null,{"$f":"PRODUCT($L37*1,AL37*1,AM37)","v":0},null,null,{"$f":"PRODUCT($L37*1,AO37*1,AP37)","v":0},{"$f":"IF($H37>0, $H37/$H$73, IF($I37>0, $I37/$H$73, IF($J37>0, $J37/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A37)=1,CONCATENATE($A37, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A37)=3,CONCATENATE($A37, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW37*1,AY37*1,AZ37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BB37*1,BC37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BE37*1,BF37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BH37*1,BI37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BK37*1,BL37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BN37*1,BO37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BQ37*1,BR37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BT37*1,BU37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BW37*1,BX37*1)","v":0},null,null,{"$f":"PRODUCT($AW37*1,BZ37*1,CA37*1)","v":0},{"$f":"IF($AS37>0, $AS37/$AS$73, IF($AT37>0, $AT37/$AS$73, IF($AU37>0, $AU37/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$f":"CombineUnits(K37,AV37)","v":{"$error":"#NAME?"}},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H37,I37,J37,AS37,AT37,AU37)","v":{"$error":"#NAME?"}}]
["D.1.3",null,null,"Communications - Capital items",null,"CAPITAL EXPENDITURE ","No",0,0,{"$f":"P38+S38+V38+Y38+AB38+AE38+AH38+AK38+AN38+AQ38","v":0}]
["D.1.4",null,null,"Storage",null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P39+S39+V39+Y39+AB39+AE39+AH39+AK39+AN39+AQ39","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($H39>0, $H39/$H$73, IF($I39>0, $I39/$H$73, IF($J39>0, $J39/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A38)=1,CONCATENATE($A38, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A38)=3,CONCATENATE($A38, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW39*1,AY39*1,AZ39)","v":0},null,null,{"$f":"PRODUCT($AW39*1,BB39*1,BC39)","v":0},null,null,{"$f":"PRODUCT($AW39*1,BE39*1,BF39)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($AS39>0, $AS39/$AS$73, IF($AT39>0, $AT39/$AS$73, IF($AU39>0, $AU39/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["D.1.5",null,null,"Bank charges",null,"PROJECT ACTIVITIES","No",0,0,{"$f":"P40+S40+V40+Y40+AB40+AE40+AH40+AK40+AN40+AQ40","v":0},{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A39)=1,CONCATENATE($A39, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A39)=3,CONCATENATE($A39, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW40*1,AY40*1,AZ40)","v":0},null,null,{"$f":"PRODUCT($AW40*1,BB40*1,BC40)","v":0},null,null,{"$f":"PRODUCT($AW40*1,BE40*1,BF40)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["D.1.6",null,null,"Small equipment - capital exp",null,"PROJECT ACTIVITIES","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A40)=1,CONCATENATE($A40, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A40)=3,CONCATENATE($A40, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW41*1,AY41*1,AZ41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BB41*1,BC41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BE41*1,BF41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BH41*1,BI41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BK41*1,BL41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BN41*1,BO41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BQ41*1,BR41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BT41*1,BU41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BW41*1,BX41*1)","v":0},null,null,{"$f":"PRODUCT($AW41*1,BZ41*1,CA41*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ProportionVariance(H41,I41,J41,AS41,AT41,AU41)","v":{"$error":"#NAME?"}}]
["D.1.7",null,null,"Insurance ",null,"PROJECT ACTIVITIES","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L42*1,N42*1,O42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,Q42*1,R42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,T42*1,U42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,W42*1,X42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,Z42*1,AA42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,AC42*1,AD42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,AF42*1,AG42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,AI42*1,AJ42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,AL42*1,AM42*1)","v":0},null,null,{"$f":"PRODUCT($L42*1,AO42*1,AP42*1)","v":0},{"v":0,"d":"0.0%"},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A41)=1,CONCATENATE($A41, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A41)=3,CONCATENATE($A41, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW42*1,AY42*1,AZ42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BB42*1,BC42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BE42*1,BF42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BH42*1,BI42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BK42*1,BL42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BN42*1,BO42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BQ42*1,BR42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BT42*1,BU42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BW42*1,BX42*1)","v":0},null,null,{"$f":"PRODUCT($AW42*1,BZ42*1,CA42*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["D.2",null,"Field Office",{"$nulls":3},"No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L43*1,N43*1,O43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,Q43*1,R43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,T43*1,U43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,W43*1,X43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,Z43*1,AA43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,AC43*1,AD43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,AF43*1,AG43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,AI43*1,AJ43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,AL43*1,AM43*1)","v":0},null,null,{"$f":"PRODUCT($L43*1,AO43*1,AP43*1)","v":0},{"v":0,"d":"0.0%"},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A43)=1,CONCATENATE($A43, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A43)=3,CONCATENATE($A43, \"*\"),\"XYZ\"), $AU$13:$AU$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($AW43*1,AY43*1,AZ43)","v":0},null,null,{"$f":"PRODUCT($AW43*1,BB43*1,BC43)","v":0},null,null,{"$f":"PRODUCT($AW43*1,BE43*1,BF43)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["D.2.1",null,null,"Office space (rent, utilities etc)",null,"PROJECT ACTIVITIES","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L44*1,N44*1,O44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,Q44*1,R44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,T44*1,U44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,W44*1,X44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,Z44*1,AA44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,AC44*1,AD44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,AF44*1,AG44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,AI44*1,AJ44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,AL44*1,AM44*1)","v":0},null,null,{"$f":"PRODUCT($L44*1,AO44*1,AP44*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW44*1,AY44*1,AZ44)","v":0},null,null,{"$f":"PRODUCT($AW44*1,BB44*1,BC44)","v":0},null,null,{"$f":"PRODUCT($AW44*1,BE44*1,BF44)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E","Project Staffing Pay, Training and Travel",{"$nulls":5},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A45)=1,CONCATENATE($A45, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},{"$f":"SUMIF($A$13:$A$136, IF(LEN($A45)=3,CONCATENATE($A45, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},0,{"$nulls":5},{"$f":"PRODUCT($L45*1,N45*1,O45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,Q45*1,R45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,T45*1,U45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,W45*1,X45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,Z45*1,AA45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,AC45*1,AD45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,AF45*1,AG45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,AI45*1,AJ45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,AL45*1,AM45*1)","v":0},null,null,{"$f":"PRODUCT($L45*1,AO45*1,AP45*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW45*1,AY45*1,AZ45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BB45*1,BC45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BE45*1,BF45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BH45*1,BI45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BK45*1,BL45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BN45*1,BO45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BQ45*1,BR45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BT45*1,BU45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BW45*1,BX45*1)","v":0},null,null,{"$f":"PRODUCT($AW45*1,BZ45*1,CA45*1)","v":0},{"v":0,"d":"0.0%"},{"$f":"H45-AS45","v":0},0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.1",null,"National Technical",null,null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L46*1,N46*1,O46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,Q46*1,R46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,T46*1,U46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,W46*1,X46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,Z46*1,AA46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,AC46*1,AD46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,AF46*1,AG46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,AI46*1,AJ46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,AL46*1,AM46*1)","v":0},null,null,{"$f":"PRODUCT($L46*1,AO46*1,AP46*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW46*1,AY46*1,AZ46)","v":0},null,null,{"$f":"PRODUCT($AW46*1,BB46*1,BC46)","v":0},null,null,{"$f":"PRODUCT($AW46*1,BE46*1,BF46)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},{"$f":"N46-AY46","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.1.1",null,null,"[Staff member, e.g. nurse]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":33},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.1.2",null,null,"[Staff member, e.g. nurse]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.2",null,"National Support",null,null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.2.1",null,null,"[Staff member, e.g. programme officer]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.2.2",null,null,"[Staff member, e.g. programme officer]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.3",null,"International Technical",null,null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.3.1",null,null,"[Staff member, e.g. WASH specialist]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.3.2",null,null,"[Staff member, e.g. WASH specialist]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AI54-BT54","v":0},0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.4",null,"International Support",null,null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.4.1",null,null,"[Staff member, e.g. country office manager]",null,"PROJECT STAFF COSTS - PAY","No",null,0,0,{"$nulls":5},{"$f":"PRODUCT($L56*1,N56*1,O56)","v":0},null,null,{"$f":"PRODUCT($L56*1,Q56*1,R56)","v":0},null,null,{"$f":"PRODUCT($L56*1,T56*1,U56)","v":0},null,null,{"$f":"PRODUCT($L56*1,W56*1,X56)","v":0},null,null,{"$f":"PRODUCT($L56*1,Z56*1,AA56)","v":0},null,null,{"$f":"PRODUCT($L56*1,AC56*1,AD56)","v":0},null,null,{"$f":"PRODUCT($L56*1,AF56*1,AG56)","v":0},null,null,{"$f":"PRODUCT($L56*1,AI56*1,AJ56)","v":0},null,null,{"$f":"PRODUCT($L56*1,AL56*1,AM56)","v":0},null,null,{"$f":"PRODUCT($L56*1,AO56*1,AP56)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},{"$f":"L56-AW56","v":0},{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.4.2",null,null,"[Staff member, e.g. country office manager]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.5",null,"Off-shore Technical",null,null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L58*1,N58*1,O58)","v":0},null,null,{"$f":"PRODUCT($L58*1,Q58*1,R58)","v":0},null,null,{"$f":"PRODUCT($L58*1,T58*1,U58)","v":0},null,null,{"$f":"PRODUCT($L58*1,W58*1,X58)","v":0},null,null,{"$f":"PRODUCT($L58*1,Z58*1,AA58)","v":0},null,null,{"$f":"PRODUCT($L58*1,AC58*1,AD58)","v":0},null,null,{"$f":"PRODUCT($L58*1,AF58*1,AG58)","v":0},null,null,{"$f":"PRODUCT($L58*1,AI58*1,AJ58)","v":0},null,null,{"$f":"PRODUCT($L58*1,AL58*1,AM58)","v":0},null,null,{"$f":"PRODUCT($L58*1,AO58*1,AP58)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},{"$f":"L58-AW58","v":0},{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.5.1",null,null,"[Staff member, e.g. public health specialist]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.6",null,"Off-shore Support",null,null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L60*1,N60*1,O60)","v":0},null,null,{"$f":"PRODUCT($L60*1,Q60*1,R60)","v":0},null,null,{"$f":"PRODUCT($L60*1,T60*1,U60)","v":0},null,null,{"$f":"PRODUCT($L60*1,W60*1,X60)","v":0},null,null,{"$f":"PRODUCT($L60*1,Z60*1,AA60)","v":0},null,null,{"$f":"PRODUCT($L60*1,AC60*1,AD60)","v":0},null,null,{"$f":"PRODUCT($L60*1,AF60*1,AG60)","v":0},null,null,{"$f":"PRODUCT($L60*1,AI60*1,AJ60)","v":0},null,null,{"$f":"PRODUCT($L60*1,AL60*1,AM60)","v":0},null,null,{"$f":"PRODUCT($L60*1,AO60*1,AP60)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.6.1",null,null,"[Staff member, e.g. regional director]",null,"PROJECT STAFF COSTS - PAY","No",0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.7",null,"Training",null,null,"PROJECT ACTIVITIES","No",{"$f":"SUMIF($A$13:$A$136, IF(LEN($A62)=1,CONCATENATE($A62, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},0,0,{"$nulls":5},{"$f":"PRODUCT($L62*1,N62*1,O62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,Q62*1,R62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,T62*1,U62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,W62*1,X62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,Z62*1,AA62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,AC62*1,AD62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,AF62*1,AG62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,AI62*1,AJ62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,AL62*1,AM62*1)","v":0},null,null,{"$f":"PRODUCT($L62*1,AO62*1,AP62*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW62*1,AY62*1,AZ62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BB62*1,BC62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BE62*1,BF62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BH62*1,BI62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BK62*1,BL62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BN62*1,BO62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BQ62*1,BR62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BT62*1,BU62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BW62*1,BX62*1)","v":0},null,null,{"$f":"PRODUCT($AW62*1,BZ62*1,CA62*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.8",null,"Non-salary benefits",null,null,"PROJECT STAFF COSTS - TRAVEL & SUBSISTENCE","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L63*1,N63*1,O63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,Q63*1,R63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,T63*1,U63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,W63*1,X63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,Z63*1,AA63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,AC63*1,AD63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,AF63*1,AG63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,AI63*1,AJ63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,AL63*1,AM63*1)","v":0},null,null,{"$f":"PRODUCT($L63*1,AO63*1,AP63*1)","v":0},{"v":0,"d":"0.0%"},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW63*1,AY63*1,AZ63)","v":0},null,null,0,null,null,{"$f":"PRODUCT($AW63*1,BE63*1,BF63)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"v":0,"d":"0.0%"},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},{"$f":"N63-AY63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["E.9",null,"Staff travel",{"$nulls":3},"No",null,0,0,{"$nulls":34},0,0,0,{"$nulls":34},0,0]
["E.9.1",null,null,"International flights",null,"PROJECT STAFF COSTS - TRAVEL & SUBSISTENCE","No",{"$f":"SUMIF($A$13:$A$136, IF(LEN($A65)=1,CONCATENATE($A65, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},0,0,{"$nulls":34},0,0,0,{"$nulls":34},0,0]
["E.9.2",null,null,"Car rental",null,"PROJECT STAFF COSTS - TRAVEL & SUBSISTENCE","No",{"$f":"SUMIF($A$13:$A$136, IF(LEN($A66)=1,CONCATENATE($A66, \"*\"),\"XYZ\"), $J$13:$J$136 )","v":0},0,{"$f":"P66+S66+V66+Y66+AB66+AE66+AH66+AK66+AN66+AQ66","v":0},{"$nulls":34},0,0,0,{"$nulls":34},0,0]
["F","Monitoring and Evaluation ",{"$nulls":5},0,0,{"$f":"P67+S67+V67+Y67+AB67+AE67+AH67+AK67+AN67+AQ67","v":0},{"$nulls":5},0,null,null,{"$f":"PRODUCT($L67*1,Q67*1,R67)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($H67>0, $H67/$H$73, IF($I67>0, $I67/$H$73, IF($J67>0, $J67/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW67*1,AY67*1,AZ67)","v":0},null,null,0,null,null,{"$f":"PRODUCT($AW67*1,BE67*1,BF67)","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"IF($AS67>0, $AS67/$AS$73, IF($AT67>0, $AT67/$AS$73, IF($AU67>0, $AU67/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["F.1",null,"Monitoring",null,null,"MONITORING EVALUATION & LESSONS LEARNED","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L68*1,N68*1,O68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,Q68*1,R68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,T68*1,U68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,W68*1,X68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,Z68*1,AA68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,AC68*1,AD68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,AF68*1,AG68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,AI68*1,AJ68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,AL68*1,AM68*1)","v":0},null,null,{"$f":"PRODUCT($L68*1,AO68*1,AP68*1)","v":0},{"$f":"IF($H68>0, $H68/$H$73, IF($I68>0, $I68/$H$73, IF($J68>0, $J68/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$nulls":5},{"$f":"PRODUCT($AW68*1,AY68*1,AZ68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BB68*1,BC68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BE68*1,BF68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BH68*1,BI68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BK68*1,BL68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BN68*1,BO68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BQ68*1,BR68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BT68*1,BU68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BW68*1,BX68*1)","v":0},null,null,{"$f":"PRODUCT($AW68*1,BZ68*1,CA68*1)","v":0},{"$f":"IF($AS68>0, $AS68/$AS$73, IF($AT68>0, $AT68/$AS$73, IF($AU68>0, $AU68/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["F.2",null,"Evaluation",null,null,"MONITORING EVALUATION & LESSONS LEARNED","No",0,0,0,{"$nulls":5},{"$f":"PRODUCT($L69*1,N69*1,O69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,Q69*1,R69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,T69*1,U69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,W69*1,X69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,Z69*1,AA69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,AC69*1,AD69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,AF69*1,AG69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,AI69*1,AJ69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,AL69*1,AM69*1)","v":0},null,null,{"$f":"PRODUCT($L69*1,AO69*1,AP69*1)","v":0},{"$f":"IF($H69>0, $H69/$H$73, IF($I69>0, $I69/$H$73, IF($J69>0, $J69/$H$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,{"$f":"BA69+BD69+BG69+BJ69+BM69+BP69+BS69+BV69+BY69+CB69","v":0},{"$nulls":5},{"$f":"PRODUCT($AW69*1,AY69*1,AZ69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BB69*1,BC69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BE69*1,BF69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BH69*1,BI69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BK69*1,BL69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BN69*1,BO69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BQ69*1,BR69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BT69*1,BU69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BW69*1,BX69*1)","v":0},null,null,{"$f":"PRODUCT($AW69*1,BZ69*1,CA69*1)","v":0},{"$f":"IF($AS69>0, $AS69/$AS$73, IF($AT69>0, $AT69/$AS$73, IF($AU69>0, $AU69/$AS$73, 0)))","v":{"v":0,"d":"0.0%"}},0,0,0,{"$error":"#NAME?"},0,{"$error":"#NAME?"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#NAME?"}]
["Totals","Do not edit: These cells update automatically",{"$nulls":5},0,0]
["Total of Direct Costs",{"$nulls":6},{"$f":"SUM(H12:H69)","v":0},null,{"$f":"SUM(J12:J69)","v":0},{"$nulls":5},{"$f":"SUM(P12:P69)","v":0},null,null,{"$f":"SUM(S12:S69)","v":0},null,null,{"$f":"SUM(V12:V69)","v":0},null,null,{"$f":"SUM(Y12:Y69)","v":0},null,null,{"$f":"SUM(AB12:AB69)","v":0},null,null,{"$f":"SUM(AE12:AE69)","v":0},null,null,{"$f":"SUM(AH12:AH69)","v":0},null,null,{"$f":"SUM(AK12:AK69)","v":0},null,null,{"$f":"SUM(AN12:AN69)","v":0},null,null,{"$f":"SUM(AQ12:AQ69)","v":0},{"$f":"H71/H$73","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AS12:AS69)","v":0},null,{"$f":"SUM(AU13:AU69)","v":0},{"$nulls":5},{"$f":"SUM(BA12:BA69)","v":0},null,null,{"$f":"SUM(BD12:BD69)","v":0},null,null,{"$f":"SUM(BG12:BG69)","v":0},null,null,{"$f":"SUM(BJ12:BJ69)","v":0},null,null,{"$f":"SUM(BM12:BM69)","v":0},null,null,{"$f":"SUM(BP12:BP69)","v":0},null,null,{"$f":"SUM(BS12:BS69)","v":0},null,null,{"$f":"SUM(BV12:BV69)","v":0},null,null,{"$f":"SUM(BY12:BY69)","v":0},null,null,{"$f":"SUM(CB12:CB69)","v":0},{"$f":"AS71/AS$73","v":{"$error":"#DIV/0!"}},0,0,0,{"$nulls":5},{"$f":"P71-BA71","v":0},null,null,{"$f":"S71-BD71","v":0},null,null,{"$f":"V71-BG71","v":0},null,null,{"$f":"Y71-BJ71","v":0},null,null,{"$f":"AB71-BM71","v":0},null,null,{"$f":"AE71-BP71","v":0},null,null,{"$f":"AH71-BS71","v":0},null,null,{"$f":"AK71-BV71","v":0},null,null,{"$f":"AN71-BY71","v":0},null,null,{"$f":"AQ71-CB71","v":0},{"$error":"#NAME?"}]
["Non-Project-Attributable Costs (%)",{"$nulls":5},{"v":0,"d":"0.0%"},{"$f":"H71*$G72","v":0},null,{"$f":"J71*$G72","v":0},{"$nulls":5},{"$f":"P71*$G72","v":0},null,null,{"$f":"S71*$G72","v":0},null,null,0,null,null,{"$f":"Y71*$G72","v":0},null,null,{"$f":"AB71*$G72","v":0},null,null,{"$f":"AE71*$G72","v":0},null,null,{"$f":"AH71*$G72","v":0},null,null,{"$f":"AK71*$G72","v":0},null,null,{"$f":"AN71*$G72","v":0},null,null,{"$f":"AQ71*$G72","v":0},{"$f":"AR71*$G72","v":{"$error":"#DIV/0!"}},{"$f":"AS71*$G72","v":0},null,{"$f":"AU71*$G72","v":0},{"$nulls":5},{"$f":"BA71*$G72","v":0},null,null,{"$f":"BD71*$G72","v":0},null,null,{"$f":"BG71*$G72","v":0},null,null,{"$f":"BJ71*$G72","v":0},null,null,{"$f":"BM71*$G72","v":0},null,null,{"$f":"BP71*$G72","v":0},null,null,{"$f":"BS71*$G72","v":0},null,null,{"$f":"BV71*$G72","v":0},null,null,{"$f":"BY71*$G72","v":0},null,null,{"$f":"CB71*$G72","v":0},{"$error":"#DIV/0!"},0,0,0,{"$nulls":5},{"$f":"P72-BA72","v":0},null,null,{"$f":"S72-BD72","v":0},null,null,{"$f":"V72-BG72","v":0},null,null,{"$f":"Y72-BJ72","v":0},null,null,{"$f":"AB72-BM72","v":0},null,null,{"$f":"AE72-BP72","v":0},null,null,{"$f":"AH72-BS72","v":0},null,null,{"$f":"AK72-BV72","v":0},null,null,{"$f":"AN72-BY72","v":0},null,null,{"$f":"AQ72-CB72","v":0},{"$error":"#NAME?"}]
["Total",{"$nulls":6},{"$f":"SUM(H71:H72)","v":0},null,{"$f":"SUM(J71:J72)","v":0},{"$nulls":5},{"$f":"SUM(P71:P72)","v":0},null,null,0,null,null,0,null,null,{"$f":"SUM(Y71:Y72)","v":0},null,null,{"$f":"SUM(AB71:AB72)","v":0},null,null,{"$f":"SUM(AE71:AE72)","v":0},null,null,{"$f":"SUM(AH71:AH72)","v":0},null,null,{"$f":"SUM(AK71:AK72)","v":0},null,null,{"$f":"SUM(AN71:AN72)","v":0},null,null,{"$f":"SUM(AQ71:AQ72)","v":0},{"$f":"SUM(AR71:AR72)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AS71:AS72)","v":0},null,{"$f":"SUM(AU71:AU72)","v":0},{"$nulls":5},{"$f":"SUM(BA71:BA72)","v":0},null,null,{"$f":"SUM(BD71:BD72)","v":0},null,null,{"$f":"SUM(BG71:BG72)","v":0},null,null,{"$f":"SUM(BJ71:BJ72)","v":0},null,null,{"$f":"SUM(BM71:BM72)","v":0},null,null,{"$f":"SUM(BP71:BP72)","v":0},null,null,{"$f":"SUM(BS71:BS72)","v":0},null,null,{"$f":"SUM(BV71:BV72)","v":0},null,null,{"$f":"SUM(BY71:BY72)","v":0},null,null,{"$f":"SUM(CB71:CB72)","v":0},{"$error":"#DIV/0!"},0,0,0,{"$nulls":5},{"$f":"P73-BA73","v":0},null,null,{"$f":"S73-BD73","v":0},null,null,{"$f":"V73-BG73","v":0},null,null,{"$f":"Y73-BJ73","v":0},null,null,{"$f":"AB73-BM73","v":0},null,null,{"$f":"AE73-BP73","v":0},null,null,{"$f":"AH73-BS73","v":0},null,null,{"$f":"AK73-BV73","v":0},null,null,{"$f":"AN73-BY73","v":0},null,null,{"$f":"AQ73-CB73","v":0},{"$error":"#NAME?"}]
[{"$nulls":5}," "]
["Fully funded by DFID?",{"$nulls":5},"Yes","DFID funding:",null,null,{"$f":"SUM(M75/H73)","v":{"$error":"#DIV/0!"}},"£",{"$f":"proj_grand_total","v":0},null,null,{"$f":"P73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"S73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"V73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Y73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AH73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AK73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AN73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AQ73*$M$75/$H$73","v":{"$error":"#DIV/0!"}},{"$f":"M75/H73","v":{"$error":"#DIV/0!"}},"DFID funding:",null,null,{"$f":"AX75/AS73","v":{"$error":"#DIV/0!"}},"£",{"$f":"actu_grand_total","v":0},null,null,{"$f":"BA73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BD73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BG73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BJ73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BM73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BP73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BS73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BV73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BY73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},null,null,{"$f":"CB73*$AX$75/$AS$73","v":{"$error":"#DIV/0!"}},{"$f":"AX75/AS73","v":{"$error":"#DIV/0!"}},"DFID funding:",null,null,{"$f":"K75-AV75","v":{"$error":"#DIV/0!"}},"£",{"$nulls":3},{"$f":"P75-BA75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"S75-BD75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"V75-BG75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Y75-BJ75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB75-BM75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE75-BP75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AH75-BS75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AK75-BV75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AN75-BY75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AQ75-CB75","v":{"$error":"#DIV/0!"}},{"$f":"(M75-AX75)/M75","v":{"$error":"#DIV/0!"}}]
["Funds transferred to local and national partners",{"$nulls":11},"insert % value",{"$nulls":36},"insert % value",{"$nulls":36},"insert % value",{"$f":"AY76-N76","v":0},{"$f":"O76-AZ76","v":{"v":0,"d":"£0.00"}},{"$f":"BA76-P76","v":0},0,{"$f":"R76-BC76","v":{"v":0,"d":"£0.00"}},{"$f":"BD76-S76","v":0},0,{"$f":"U76-BF76","v":{"v":0,"d":"£0.00"}},{"$f":"BG76-V76","v":0},0,{"$f":"X76-BI76","v":{"v":0,"d":"£0.00"}},{"$f":"BJ76-Y76","v":0},0,{"$f":"AA76-BL76","v":{"v":0,"d":"£0.00"}},{"$f":"BM76-AB76","v":0},0,{"$f":"AD76-BO76","v":{"v":0,"d":"£0.00"}},{"$f":"BP76-AE76","v":0},0,{"$f":"AG76-BR76","v":{"v":0,"d":"£0.00"}},{"$f":"BS76-AH76","v":0},0,{"$f":"AJ76-BU76","v":{"v":0,"d":"£0.00"}},{"$f":"BV76-AK76","v":0},0,{"$f":"AM76-BX76","v":{"v":0,"d":"£0.00"}},{"$f":"BY76-AN76","v":0},0,{"$f":"AP76-CA76","v":{"v":0,"d":"£0.00"}}]
[]
["Output (as in logframe)",{"$nulls":42},"Total/ average",{"$nulls":36},"Total/ average",{"$nulls":6},{"$f":"CombineUnits(N78,AY78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(Q78,BB78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(T78,BE78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(W78,BH78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(Z78,BK78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(AC78,BN78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(AF78,BQ78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(AI78,BT78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(AL78,BW78)","v":{"$error":"#NAME?"}},null,null,{"$f":"CombineUnits(AO78,BZ78)","v":{"$error":"#NAME?"}},null,null,"Total/ average"]
["Number of direct beneficiaries (per output)",{"$nulls":6},"Household size (if used)",{"$nulls":4},"individuals",null,null,{"$f":"IF($M79=\"households\",N79*$K79,N79)","v":0},null,null,{"$f":"IF($M79=\"households\",Q79*$K79,Q79)","v":0},null,null,{"$f":"IF($M79=\"households\",T79*$K79,T79)","v":0},null,null,{"$f":"IF($M79=\"households\",W79*$K79,W79)","v":0},null,null,{"$f":"IF($M79=\"households\",Z79*$K79,Z79)","v":0},null,null,{"$f":"IF($M79=\"households\",AC79*$K79,AC79)","v":0},null,null,{"$f":"IF($M79=\"households\",AF79*$K79,AF79)","v":0},null,null,{"$f":"IF($M79=\"households\",AI79*$K79,AI79)","v":0},null,null,{"$f":"IF($M79=\"households\",AL79*$K79,AL79)","v":0},null,null,{"$f":"IF($M79=\"households\",AO79*$K79,AO79)","v":0},{"$f":"P79+S79+V79+Y79+AB79+AE79+AH79+AK79+AN79+AQ79","v":{"v":0,"d":"(0)"}},"Household size (if used)",{"$nulls":4},"individuals",null,null,{"$f":"IF($AX79=\"households\",AY79*$AV79,AY79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BB79*$AV79,BB79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BE79*$AV79,BE79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BH79*$AV79,BH79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BK79*$AV79,BK79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BN79*$AV79,BN79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BQ79*$AV79,BQ79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BT79*$AV79,BT79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BW79*$AV79,BW79)","v":0},null,null,{"$f":"IF($AX79=\"households\",BZ79*$AV79,BZ79)","v":0},{"$f":"BA79+BD79+BG79+BJ79+BM79+BP79+BS79+BV79+BY79+CB79","v":{"v":0,"d":"(0)"}},null,{"$f":"AT79-I79","v":0},{"$f":"AU79-J79","v":0},{"$f":"CombineUnits(K79,AV79)","v":{"$error":"#NAME?"}},{"$f":"AW79-L79","v":0},{"$f":"CombineUnits(M79,AX79)","v":{"$error":"#NAME?"}},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),AY79-N79,\"\")","v":""},null,{"$f":"BA79-P79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BB79-Q79,\"\")","v":""},{"$f":"BC79-R79","v":0},{"$f":"BD79-S79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BE79-T79,\"\")","v":""},{"$f":"BF79-U79","v":0},{"$f":"BG79-V79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BH79-W79,\"\")","v":""},{"$f":"BI79-X79","v":0},{"$f":"BJ79-Y79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BK79-Z79,\"\")","v":""},{"$f":"BL79-AA79","v":0},{"$f":"BM79-AB79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BN79-AC79,\"\")","v":""},{"$f":"BO79-AD79","v":0},{"$f":"BP79-AE79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BQ79-AF79,\"\")","v":""},{"$f":"BR79-AG79","v":0},{"$f":"BS79-AH79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BT79-AI79,\"\")","v":""},{"$f":"BU79-AJ79","v":0},{"$f":"BV79-AK79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BW79-AL79,\"\")","v":""},{"$f":"BX79-AM79","v":0},{"$f":"BY79-AN79","v":0},{"$f":"IF(AND($M79=\"households\",$AX79=\"households\"),BZ79-AO79,\"\")","v":""},{"$f":"CA79-AP79","v":0},0,0]
["Number of DFID-attributable direct beneficiaries",{"$nulls":11},{"$f":"M79","v":"individuals"},{"$f":"N79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"P79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"Q79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"S79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"T79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"V79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"W79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"Y79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"Z79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"AB79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"AC79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"AE79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"AF79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"AH79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"AI79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"AK79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"AL79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"AN79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"AO79*$K$75","v":{"$error":"#DIV/0!"}},null,{"$f":"AQ79*$K$75","v":{"$error":"#DIV/0!"}},{"$f":"P80+S80+V80+Y80+AB80+AE80+AH80+AK80+AN80+AQ80","v":{"$error":"#DIV/0!"}},{"$nulls":5},{"$f":"AX79","v":"individuals"},{"$f":"AY79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BA79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BB79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BD79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BE79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BG79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BH79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BJ79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BK79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BM79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BN79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BP79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BQ79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BS79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BT79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BV79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BW79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"BY79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BZ79*$AV$75","v":{"$error":"#DIV/0!"}},null,{"$f":"CB79*$AV$75","v":{"$error":"#DIV/0!"}},{"$f":"BA80+BD80+BG80+BJ80+BM80+BP80+BS80+BV80+BY80+CB80","v":{"$error":"#DIV/0!"}},null,{"$f":"AT80-I80","v":0},{"$f":"AU80-J80","v":0},{"$f":"CombineUnits(K80,AV80)","v":{"$error":"#NAME?"}},{"$f":"AW80-L80","v":0},{"$f":"CombineUnits(M80,AX80)","v":{"$error":"#NAME?"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),AY80-N80,\"\")","v":""},null,{"$f":"BA80-P80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BB80-Q80,\"\")","v":""},{"$f":"BC80-R80","v":0},{"$f":"BD80-S80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BE80-T80,\"\")","v":""},{"$f":"BF80-U80","v":0},{"$f":"BG80-V80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BH80-W80,\"\")","v":""},{"$f":"BI80-X80","v":0},{"$f":"BJ80-Y80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BK80-Z80,\"\")","v":""},{"$f":"BL80-AA80","v":0},{"$f":"BM80-AB80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BN80-AC80,\"\")","v":""},{"$f":"BO80-AD80","v":0},{"$f":"BP80-AE80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BQ80-AF80,\"\")","v":""},{"$f":"BR80-AG80","v":0},{"$f":"BS80-AH80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BT80-AI80,\"\")","v":""},{"$f":"BU80-AJ80","v":0},{"$f":"BV80-AK80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BW80-AL80,\"\")","v":""},{"$f":"BX80-AM80","v":0},{"$f":"BY80-AN80","v":{"$error":"#DIV/0!"}},{"$f":"IF(AND($M80=\"households\",$AX80=\"households\"),BZ80-AO80,\"\")","v":""},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
["Cost per direct beneficiary (CPB)",{"$nulls":14},{"$f":"P73/P79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"S73/S79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"V73/V79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Y73/Y79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB73/AB79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE73/AE79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AH73/AH79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AK73/AK79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AN73/AN79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AQ73/AQ79","v":{"$error":"#DIV/0!"}},{"$f":"H73/AR79","v":{"$error":"#DIV/0!"}},{"$nulls":8},{"$f":"BA73/BA79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BD73/BD79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BG73/BG79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BJ73/BJ79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BM73/BM79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BP73/BP79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BS73/BS79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BV73/BV79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BY73/BY79","v":{"$error":"#DIV/0!"}},null,null,{"$f":"CB73/CB79","v":{"$error":"#DIV/0!"}},{"$f":"AS73/CC79","v":{"$error":"#DIV/0!"}},{"$f":"H81-AS81","v":{"v":0,"d":"£0.00"}},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},null,null,{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"$error":"#DIV/0!"},{"$f":"AR81-CC81","v":{"$error":"#DIV/0!"}}]
[]
["Output indicator (result)",{"$nulls":51},{"$f":"BA79*12","v":0},null,null,{"$f":"BB79","v":0},null,null,{"$f":"BE79*26","v":0},{"$nulls":28},{"$f":"CombineUnits(N83,AY83)","v":{"$error":"#NAME?"}},null,{"$f":"BA83-P83","v":0},{"$f":"CombineUnits(Q83,BB83)","v":{"$error":"#NAME?"}},null,{"$f":"BD83-S83","v":0},{"$f":"CombineUnits(T83,BE83)","v":{"$error":"#NAME?"}},null,{"$f":"BG83-V83","v":0},{"$f":"CombineUnits(W83,BH83)","v":{"$error":"#NAME?"}},null,{"$f":"BJ83-Y83","v":0},{"$f":"CombineUnits(Z83,BK83)","v":{"$error":"#NAME?"}},null,{"$f":"BM83-AB83","v":0},{"$f":"CombineUnits(AC83,BN83)","v":{"$error":"#NAME?"}},null,{"$f":"BP83-AE83","v":0},{"$f":"CombineUnits(AF83,BQ83)","v":{"$error":"#NAME?"}},null,{"$f":"BS83-AH83","v":0},{"$f":"CombineUnits(AI83,BT83)","v":{"$error":"#NAME?"}},null,{"$f":"BV83-AK83","v":0},{"$f":"CombineUnits(AL83,BW83)","v":{"$error":"#NAME?"}},null,{"$f":"BY83-AN83","v":0},{"$f":"CombineUnits(AO83,BZ83)","v":{"$error":"#NAME?"}},null,{"$f":"CB83-AQ83","v":0}]
["DFID-attributable output indicator",{"$nulls":14},{"$f":"P83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"S83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"V83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Y83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AH83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AK83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AN83*$K$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AQ83*$K$75","v":{"$error":"#DIV/0!"}},{"$nulls":9},{"$f":"BA83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BD83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BG83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BJ83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BM83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BP83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BS83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BV83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BY83*$AV$75","v":{"$error":"#DIV/0!"}},null,null,{"$f":"CB83*$AV$75","v":{"$error":"#DIV/0!"}}]
["Unit cost of output (cost per result)",{"$nulls":14},{"$f":"P73/P83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"S73/S83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"V73/V83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"Y73/Y83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AB73/AB83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AE73/AE83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AH73/AH83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AK73/AK83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AN73/AN83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AQ73/AQ83","v":{"$error":"#DIV/0!"}},{"$nulls":9},{"$f":"BA73/BA83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BD73/BD83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BG73/BG83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BJ73/BJ83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BM73/BM83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BP73/BP83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BS73/BS83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BV73/BV83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"BY73/BY83","v":{"$error":"#DIV/0!"}},null,null,{"$f":"CB73/CB83","v":{"$error":"#DIV/0!"}},{"$nulls":7},{"$f":"AY85-N85","v":0},{"$f":"AZ85-O85","v":0},{"$f":"P85-BA85","v":{"$error":"#DIV/0!"}},{"$f":"BB85-Q85","v":0},{"$f":"BC85-R85","v":0},{"$f":"S85-BD85","v":{"$error":"#DIV/0!"}},{"$f":"BE85-T85","v":0},{"$f":"BF85-U85","v":0},{"$f":"V85-BG85","v":{"$error":"#DIV/0!"}},{"$f":"BH85-W85","v":0},{"$f":"BI85-X85","v":0},{"$f":"Y85-BJ85","v":{"$error":"#DIV/0!"}},{"$f":"BK85-Z85","v":0},{"$f":"BL85-AA85","v":0},{"$f":"AB85-BM85","v":{"$error":"#DIV/0!"}},{"$f":"BN85-AC85","v":0},{"$f":"BO85-AD85","v":0},{"$f":"AE85-BP85","v":{"$error":"#DIV/0!"}},{"$f":"BQ85-AF85","v":0},{"$f":"BR85-AG85","v":0},{"$f":"AH85-BS85","v":{"$error":"#DIV/0!"}},{"$f":"BT85-AI85","v":0},{"$f":"BU85-AJ85","v":0},{"$f":"AK85-BV85","v":{"$error":"#DIV/0!"}},{"$f":"BW85-AL85","v":0},{"$f":"BX85-AM85","v":0},{"$f":"AN85-BY85","v":{"$error":"#DIV/0!"}},{"$f":"BZ85-AO85","v":0},{"$f":"CA85-AP85","v":0},{"$f":"AQ85-CB85","v":{"$error":"#DIV/0!"}}]

{"sheet":"3.1 Instructions - NPAC","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"3.2 NPAC","index":3,"n_rows":92,"n_cols":8,"rows_kept":92,"merged":[[7,0,7,7],[8,0,8,7],[10,0,10,3],[10,4,10,6],[11,4,11,6],[12,4,12,6],[14,0,14,7],[23,0,23,7],[42,0,42,4],[43,1,44,1],[43,2,44,2],[43,3,44,3],[68,0,68,6],[92,0,104,9]]}
{"$rows_empty":7}
["PLEASE READ '3.2. Instructions - NPAC' BEFORE COMPLETING THIS SHEET BECAUSE IT MAY NOT BE NECESSARY FOR YOUR ORGANISATION"]
["Tables 1-4 below relate to costs at the WHOLE ORGANISATION LEVEL, Table 5 to this PROJECT ONLY"]
[]
["TABLE 1: CLASSIFY NPAC INTO COST CATEGORIES AND DEFINE METHOD FOR SHARING",{"$nulls":3},"Guidance Notes"]
["Type of NPAC","Administration expenses","Support staff costs ","Governance costs","Categories from audited accounts"]
["Methodology for sharing NPAC","Project Expenditure","Project Expenditure","Project Expenditure","Basis used in audited accounts and which is consistent with UK SORP accounting guidance or similar approaches for organisations which are not following UK SORP"]
[]
["TABLE 2: Calculate 3 year Rolling average of eligible direct costs at the whole organisational level"]
[null,"Year 1","Year 2","Year 3","Three year average","Exceptional adjustments due to material future changes","Adjusted three year average","Notes"]
["Direct Charitable Costs per Audited Accounts",{"$nulls":3},{"$f":"IFERROR(AVERAGEIF(B17:D17,\"<>0\"),0)","v":0},null,{"$f":"E17+F17","v":0}]
["Adjustments (Ineligible direct charitable costs - please specify):"]
[{"$nulls":4},{"$f":"IFERROR(AVERAGEIF(B19:D19,\"<>0\"),0)","v":0},null,{"$f":"E19+F19","v":0}]
[{"$nulls":4},{"$f":"IFERROR(AVERAGEIF(B20:D20,\"<>0\"),0)","v":0},null,0]
[{"$nulls":4},{"$f":"IFERROR(AVERAGEIF(B21:D21,\"<>0\"),0)","v":0},null,0]
["Total eligible direct costs",{"$f":"B17-SUM(B19:B21)","v":0},{"$f":"C17-SUM(C19:C21)","v":0},0,0,{"$f":"F17-SUM(F19:F21)","v":0},0]
[]
["TABLE 3: Calculate 3 year Rolling average of Non-Project Attributable Costs at the whole organisational level"]
["Indirect Costs","Year 1","Year 2","Year 3","Three year average","Exceptional adjustments due to material future changes","Adjusted three year average","Notes"]
["Costs per Audited Accounts allocated to Indirect Costs"]
[{"$f":"B12","v":"Administration expenses"},{"$nulls":3},{"$f":"IFERROR(AVERAGEIF(B27:D27,\"<>0\"),0)","v":0},null,{"$f":"E27+F27","v":0}]
[{"$f":"C12","v":"Support staff costs "},{"$nulls":3},{"$f":"IFERROR(AVERAGEIF(B28:D28,\"<>0\"),0)","v":0},null,{"$f":"E28+F28","v":0}]
[{"$f":"D12","v":"Governance costs"},{"$nulls":3},{"$f":"IFERROR(AVERAGEIF(B29:D29,\"<>0\"),0)","v":0},null,{"$f":"E29+F29","v":0}]
[]
["Ineligible costs (please specify in the notes):"]
[{"$f":"A27","v":"Administration expenses"},{"$nulls":3},{"$f":"IFERROR(AVERAGEIF(B32:D32,\"<>0\"),0)","v":0},null,{"$f":"E32+F32","v":0}]
[{"$f":"A28","v":"Support staff costs "},{"$nulls":3},{"$f":"IFERROR(AVERAGEIF(B33:D33,\"<>0\"),0)","v":0},null,{"$f":"E33+F33","v":0}]
["Governance costs",{"$nulls":3},{"$f":"IFERROR(AVERAGEIF(B34:D34,\"<>0\"),0)","v":0},null,{"$f":"E34+F34","v":0}]
[]
["Eligible NPAC:"]
[{"$f":"A27","v":"Administration expenses"},{"$f":"B27-B32","v":0},{"$f":"C27-C32","v":0},{"$f":"D27-D32","v":0},{"$f":"IFERROR(AVERAGEIF(B37:D37,\"<>0\"),0)","v":0},{"$f":"F27+F32","v":0},{"$f":"E37+F37","v":0}]
[{"$f":"A28","v":"Support staff costs "},{"$f":"B28-B33","v":0},{"$f":"C28-C33","v":0},{"$f":"D28-D33","v":0},{"$f":"IFERROR(AVERAGEIF(B38:D38,\"<>0\"),0)","v":0},0,{"$f":"E38+F38","v":0}]
[{"$f":"A29","v":"Governance costs"},0,{"$f":"C29-C34","v":0},{"$f":"D29-D34","v":0},{"$f":"IFERROR(AVERAGEIF(B39:D39,\"<>0\"),0)","v":0},0,{"$f":"E39+F39","v":0}]
["Historical Indirect Costs",{"$f":"SUM(B37:B39)","v":0},{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":0},{"$f":"SUM(E37:E39)","v":0},0,0]
["Indirect costs as a proportion of direct costs",{"$f":"IFERROR(B40/B22,0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(C40/C22,0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(D40/D22,0)","v":{"v":0,"d":"0.0%"}},{"$f":"IFERROR(E40/E22,0)","v":{"v":0,"d":"0.0%"}},null,{"$f":"IFERROR(G40/G22,0)","v":{"v":0,"d":"0.0%"}}]
[]
["TABLE 4: Breakdown of Eligible ORGANISATIONAL NPAC costs in Year 3 for reference (agrees to Table 3 above)"]
["COST DESCRIPTION:",{"$f":"IF(B12=0,\"\",B12)","v":"Administration expenses"},{"$f":"IF(C12=0,\"\",C12)","v":"Support staff costs "},{"$f":"IF(D12=0,\"\",D12)","v":"Governance costs"},"Notes"]
["Note that the following cost headers are suggested (typical) NPAC costs; they are neither exhaustive nor prescriptive."]
["Rent, rates and utilities"]
["Maintenance and repairs"]
["Equipment"]
["Printing and stationery"]
["Cleaning"]
["IT costs"]
["Bank charges"]
["Consultants"]
["Programme quality support"]
["Phones"]
["Support staff costs"]
["Subscription fees"]
["Legal and professional fees"]
["Support and review visits and annual conference"]
["External audit"]
["Internal audit"]
["Trustee indemnity insurance"]
["Other"]
[]
["Total annual NPAC cost",{"$f":"SUM(B46:B64)","v":0},{"$f":"SUM(C46:C64)","v":0},{"$f":"SUM(D46:D64)","v":0},{"$f":"SUM(B65:D65)","v":0}]
[]
[]
[]
["TABLE 5: CONSORTIUM MEMBER ANNUAL TOTALS FOR THE PROJECT - This table will autopopulate if you are the sole lead partner. For consortia the lead partner (the one liaising with DFID) must manually enter the NPAC % for consortium partners in C79 - F79 as required. Downstream partner NPAC should not be entered into this table - please see FAQ 19."]
[null,"Lead Partner","Partner 2","Partner 3","Partner 4","Partner 5","Total Consortium"]
["TOTAL DIRECT AND DIRECTLY ATTRIBUTALE COSTS per consortium member:"]
["Project Year one ",{"$f":"'[1]2.1 Budget Detail YR1'!AB$80","v":0},{"$f":"'[1]2.1 Budget Detail YR1'!AB$81","v":0},{"$f":"'[1]2.1 Budget Detail YR1'!AB$82","v":0},{"$f":"'[1]2.1 Budget Detail YR1'!AB$83","v":0},{"$f":"'[1]2.1 Budget Detail YR1'!AB$84","v":0},{"$f":"SUM(B72:F72)","v":0}]
["Project Year two",{"$f":"'[1]2.2 Budget Detail YR2>'!P$80","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!P$81","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!P$82","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!P$83","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!P$84","v":0},{"$f":"SUM(B73:F73)","v":0}]
["Project Year three",{"$f":"'[1]2.2 Budget Detail YR2>'!Q$80","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!Q$81","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!Q$82","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!Q$83","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!Q$84","v":0},0]
["Project Year four",{"$f":"'[1]2.2 Budget Detail YR2>'!R$80","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!R$81","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!R$82","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!R$83","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!R$84","v":0},0]
["Project Year five",{"$f":"'[1]2.2 Budget Detail YR2>'!S$80","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!S$81","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!S$82","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!S$83","v":0},{"$f":"'[1]2.2 Budget Detail YR2>'!S$84","v":0},0]
["TOTAL DIRECT AND DIRECTLY ATTRIBUTALE COSTS",{"$f":"SUM(B72:B76)","v":0},{"$f":"SUM(C72:C76)","v":0},0,0,0,0]
[]
["Indirect costs as a proportion of direct costs",{"$f":"G41","v":{"v":0,"d":"0.0%"}}]
[]
["SHARE OF NPAC per consortium member:"]
["Project Year one ",{"$f":"B72*B$79","v":0},{"$f":"C72*C$79","v":0},0,0,0,{"$f":"SUM(B82:F82)","v":0}]
["Project Year two",{"$f":"B73*B$79","v":0},0,0,0,0,{"$f":"SUM(B83:F83)","v":0}]
["Project Year three",0,0,0,0,0,0]
["Project Year four",0,0,0,0,0,0]
["Project Year five",0,0,0,0,0,0]
["TOTAL NPAC",{"$f":"SUM(B82:B86)","v":0},{"$f":"SUM(C82:C86)","v":0},0,0,0,0]
[]
["TOTAL COSTS",{"$f":"B87+B77","v":0},0,0,0,0,0]
[]
[]
["NOTES"]

{"sheet":"4 Additional Notes ","index":4,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[7,0,7,19],[8,2,8,19]]}
{"$rows_empty":7}
["ADDITIONAL NOTES"]
["Ref ","Budget Heading ","Notes "]