{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Budget Summary","Detailed Budget ","Nomenclature","Control"],"not_rendered":{"images":2,"external_links":39,"defined_names":952},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":31,"n_cols":5,"rows_kept":31,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[4,0,4,10],[10,0,12,11],[15,0,15,10],[25,0,25,10],[26,0,26,10]]}
["Tackling the Education and Skills Data Challenge (ESDC) Budgeting Template for Year 2025/26"]
["Instructions"]
["Please read the instructions below before filling out the reporting template."]
[]
["Colour Coding"]
[]
[{"$nulls":4},"Fill in only cells highlighted in this light blue."]
[]
["Interpretation of Key Cost Categories"]
["1. Per Diem"]
["The per diem (DSA) is an all-inclusive daily allowance covering:\n - Accommodation. \n - Meals (breakfast, lunch, dinner) \n - Incidental expenses (e.g., service charges, tips, short-stay utilities like laundry). \nWhen lunch, dinner, or accommodation is provided by event organizers at no cost, the corresponding cost must be deducted from the DSA. \nBreakfast: Usually, part of hotel rates and exempt unless explicitly costed separately. \nNo full per diem allowed if meals/accommodation are covered — even if this differs from local practice. ADEA will enforce these deductions. "]
[]
[]
[]
["2. Transport Costs"]
["The costs include air ticket costs and ground transfer costs that cover departure and destination airports where flights are involved.\nGround transfer will also include costs incurred during the project activity for moving from one location to another. These include car hire or car rental services."]
[]
["3. Conference Package"]
["The costs include the venue hire, coffee breaks/refreshments, and lunch during a meeting or a workshop"]
[]
["4. Facilitation Costs"]
["The cost here may include the trainers' fee, consultants, and any staff costs that may be involved in implementing the proposed activities"]
["Other Costs: Please include costs not directly relatable to the above four components as a subset of the facilitation cost. These costs may include, but are not limited to videography, printing (if applicable)"]
[]
["5. Overhead Costs"]
["Overheads, administrative costs, or other expenses that are not directly accountable/allocable to a specific project. These costs/expenses are related to the general operations of the institution and are shared among projects and/or functions. • Basic examples include but are not limited to utilities, facilities costs, technology support, grants management, accounting, executive oversight, governance, and legal. The project allows for an overhead recovery of up to 8%."]
[]
[]
["In the detailed budget sheet, please use the drop down in Column B to align the budget items to the relevant cost categories."]
[]
["Please refer to the below activities when developing the budget"]

{"sheet":"Budget Summary","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"merged":[[8,2,8,3],[9,2,9,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[29,3,29,4],[30,2,31,2],[30,3,30,4],[31,3,31,4],[32,2,34,2],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,2,36,2],[35,3,35,4],[36,3,36,4]]}
{"$rows_empty":8}
[null,"Fund:","Tackling the Education and Skills Data Challenge (ESDC)"]
[null,"Country of Implementation:","Nigeria"]
[null,"In-country Institution","xxxx"]
[null,"Contract Start Date:","2025-07-22"]
[null,"Contract Reference Number: ","ADEA/C/2025/X"]
[null,"Grant Period:","7/22/2025-7/21/2026"]
[null,"Grant Currency Requested:","USD"]
[null,"Total Budget Amount",{"$f":"D27","v":{"v":3628.8,"d":"3,629"}}]
[]
[]
[]
[null,null,"Cost categories","Budget (USD)"," % terms"]
[null,1,"Transport Costs",{"$f":"'Detailed Budget '!J13","v":{"v":3360,"d":"3,360.00"}},{"$f":"D21/$D$27","v":{"v":0.9259259259259259,"d":"93%"}}]
[null,2,"Per diem Costs",{"$f":"'Detailed Budget '!J25","v":0},{"$f":"D22/$D$27","v":{"v":0,"d":"0%"}}]
[null,3,"Conference Costs",{"$f":"'Detailed Budget '!J38","v":0},{"v":0,"d":"0%"}]
[null,4,"Facilitation Costs",{"$f":"'Detailed Budget '!J52","v":0},{"v":0,"d":"0%"}]
[null,5,"Overhead Costs",{"$f":"'Detailed Budget '!J56","v":{"v":268.8,"d":"268.80"}},{"v":0.07407407407407407,"d":"7%"}]
[{"$nulls":4},{"v":0,"d":"0%"}]
[null,null,"Grand Total ",{"$f":"SUM(D21:D26)","v":{"v":3628.8,"d":"3,628.80"}}]
[]
[]
[null,null,"AUTHORISATION: I certify that these costs are accurate per the estimates for the project activities.    ","On behalf of the in-country institution XXXX"]
[null,null,"NAME"]
[]
[null,null,"SIGNATURE"]
[]
[]
[null,null,"DATE"]
[{"$nulls":3},"September 3rd, 2025"]
[]
[]
[null,"To Note:"]
[null,null,"Only cells highlighted in this light blue are should be edited"]

{"sheet":"Detailed Budget ","index":2,"n_rows":64,"n_cols":10,"rows_kept":64,"merged":[[1,1,1,9],[14,1,14,9],[26,1,26,9],[39,1,39,9],[54,1,54,6],[56,1,56,6],[63,1,63,12]]}
[null,"Category of expense","Expense","Unit Cost  (USD)","Quantity","Unit","Number of Days","Frequency (eg: 3 workshops planned for the EMIS policy development)","Amount (LCY)\ne.g, Rands","Amount (USD)"]
[null,"Activity 1: Name of activity 1"]
[null,"Transport ","Air ticket for person X",250,12,"Person",1,1,null,{"$f":"D3*E3*G3*H3","v":{"v":3000,"d":"3,000"}}]
[null,"Transport ","Local transport"]
[null,"Per diem ","Participants",15,12,"Person",2,1,null,{"$f":"D5*E5*G5*H5","v":360}]
[null,"Conference Package","Coffee break",{"$nulls":6},0]
[null,"Conference Package","Venue rental",{"$nulls":6},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[null,"Total ",{"$nulls":7},{"$f":"SUM(J3:J12)","v":{"v":3360,"d":"3,360"}}]
[]
[null,"Activity 2: Name of activity 2"]
[{"$nulls":9},{"$f":"D16*E16*G16*H16","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[null,"Total",{"$nulls":7},{"$f":"SUM(J16:J24)","v":0}]
[]
[null,"Activity 3: Name of activity 3"]
[{"$nulls":9},{"$f":"D28*E28*G28*H28","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[null,"Total",{"$nulls":7},{"$f":"SUM(J28:J37)","v":0}]
[]
[null,"Activity 4: Name of activity 4"]
[{"$nulls":9},{"$f":"D41*E41*G41*H41","v":0}]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[{"$nulls":9},0]
[null,"Total",{"$nulls":7},{"$f":"SUM(J41:J51)","v":0}]
[]
[]
[null,"Total Direct Costs",{"$nulls":7},{"$f":"J13+J25+J38+J52","v":{"v":3360,"d":"3,360"}}]
[null,"Overhead Recovery (8%)",{"$nulls":7},{"$f":"J55*8%","v":{"v":268.8,"d":"269"}}]
[null,"Total Costs",{"$nulls":7},{"$f":"J55+J56","v":{"v":3628.8,"d":"3,629"}}]
[]
[]
[]
[null,"To Note:"]
[{"$nulls":3},"Only cells highlighted in this light blue are should be edited"]
[]
[null,"LCY: Local currency"]

{"sheet":"Nomenclature","index":3,"n_rows":8,"n_cols":1,"rows_kept":8,"hidden":true}
["Category of expense"]
["Transport "]
["Per diem "]
["Conference Package"]
["Facilitation Costs"]
["Training kits"]
["Video services"]
["Institution fees"]

{"sheet":"Control","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"hidden":true}
[]
[]
[]
[{"$nulls":3},"Cost categories"]
[{"$nulls":3},"Personnel"]
[{"$nulls":3},"Travel "]
[{"$nulls":3},"Consultants "]
[{"$nulls":3},"Direct Supplies and Services "]
[{"$nulls":3},"Equipment "]
[{"$nulls":3},"Other Research "]
[{"$nulls":3},"Subcontracts"]
[{"$nulls":3},"Indirect costs"]