{"text_format":"5","workbook":"xlsx","n_sheets":1,"sheets":["Proposed Budget CAP FIC"],"props":{"last_modified_by":"Eduardo Appleyard"},"custom":{"ContentTypeId":"0x01010025EA6A5D83AC744C8EFBE676476C2123"},"defined_names":["Subtotal_Activity_I","Subtotal_Activity_II","Subtotal_Activity_III","Subtotal_Activity_IV","Subtotal_Activity_V","Subtotal_Activity_VI","Subtotal_Activity_VII","Subtotal_Activity_VIII","Subtotal_Administrative_cost","Subtotal_Audit","Subtotal_Cap_Dev","Subtotal_Equipment","Subtotal_Evaluation","Subtotal_Personnel"],"not_rendered":{"images":2,"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"Proposed Budget CAP FIC","index":0,"n_rows":98,"n_cols":9,"rows_kept":98,"merged":[[1,1,4,6],[1,8,13,8],[5,1,7,6],[8,1,9,6],[11,1,11,2],[11,3,11,7],[12,1,12,2],[12,3,12,7],[13,1,13,2],[13,3,13,7],[15,3,15,7],[16,1,16,2],[16,3,16,7],[17,1,17,2],[17,3,17,7],[18,1,18,2],[18,3,18,7],[19,2,19,8],[20,1,20,2],[21,1,21,8],[33,1,33,2],[34,1,34,8],[46,1,46,2],[47,1,47,8],[59,1,59,2],[60,1,60,8],[72,1,72,2],[73,1,73,8],[85,1,85,2],[86,1,86,8],[91,1,91,2],[92,1,92,8],[96,1,96,2]]}
[]
[null,"Climate Aggregation Platform ",{"$nulls":6},"Instructions:\n1) Enter the name of the lead applicant \n2) Enter the name of the Project\n3) Enter the country of Implementation \n4) For each activity (5):\n- Add the names and roles of the team members involved, their daily rates and number of days of work. \n- Add other costs related to the implementation of the activity (unit price and number of units)\n- For each budget line add the amount that will come from the CAP FIC Award (Up to $40,000 in total). The co-financing and the total budget will be calculated automatically for each budget line.\n5) Also add administrative and other costs in the same manner.\n\nA summary of the total award amount, co-financing and total budget are provided at the top."]
[]
[]
[]
[null,"Financial Innovation Challenge"]
[]
[]
[null,"Proposed Budget Breakdown"]
[]
[]
[null,"Lead Applicant (The Legal Entity)"]
[null,"Name of Project"]
[null,"Country of Implementation"]
[]
[null,null,{"$f":"IF(D17>40000,\"Error - Award cannot exceed USD 40,000\",\"\")","v":""},"Amount",{"$nulls":4},"%"]
[null,"Award from CAP FIC (Up to US$ 40,000) (USD)",null,{"$f":"F98","v":{"v":7000,"d":"$7,000.00"}},{"$nulls":4},{"$f":"D17/D19","v":{"v":0.56,"d":"56%"}}]
[null,"Co-financing from the Applicant (USD)",null,{"$f":"G98","v":{"v":5500,"d":"$5,500.00"}},{"$nulls":4},{"$f":"D18/D19","v":{"v":0.44,"d":"44%"}}]
[null,"Total Budget (USD)",null,{"$f":"SUM(D17:G18)","v":{"v":12500,"d":"$12,500.00"}},{"$nulls":4},{"$f":"I17+I18","v":{"v":1,"d":"100%"}}]
[]
[null,"Category of Expenditure",null,"Unit Price \n(USD)","Number \nof Units","Award from the CAP FIC\n(USD)","Co-financing \n(USD)","Total \n(USD)","Notes"]
[null,"Activity 1 (Add title and description)"]
[null,1,"Personnel",{"$nulls":5}," (List team members involved in the activity, their daily rates + estimated number of days of work for the given Activity)"]
[null,null,"- Name: J. Smith / Role: Project Manager",{"v":500,"d":"$500.00"},5,{"v":1000,"d":"$1,000.00"},{"$f":"H24-F24","v":{"v":1500,"d":"$1,500.00"}},{"$f":"D24*E24","v":{"v":2500,"d":"$2,500.00"}},"(This is an example)"]
[null,null,"- Name / Role",0,null,0,{"$f":"H25-F25","v":0},{"$f":"D25*E25","v":0}]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,2,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,3,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,4,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,5,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,"Sub-Total (Activity 1 costs)",{"$nulls":3},{"$f":"SUM(F24:F33)","v":{"v":1000,"d":"$1,000.00"}},{"$f":"SUM(G24:G33)","v":{"v":1500,"d":"$1,500.00"}},{"v":2500,"d":"$2,500.00"}]
[null,"Activity 2 (Add title and description)"]
[null,1,"Personnel",{"$nulls":5}," (List team members involved in the activity, their daily rates + estimated number of days of work for the given Activity)"]
[null,null,"- Name: J. Smith / Role: Project Manager",{"v":500,"d":"$500.00"},5,{"v":1500,"d":"$1,500.00"},{"$f":"H37-F37","v":{"v":1000,"d":"$1,000.00"}},{"$f":"D37*E37","v":{"v":2500,"d":"$2,500.00"}},"(This is an example)"]
[null,null,"- Name / Role",0,null,0,{"$f":"H38-F38","v":0},{"$f":"D38*E38","v":0}]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,2,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,3,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,4,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,5,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,"Sub-Total (Activity 2 costs)",{"$nulls":3},{"$f":"SUM(F37:F46)","v":{"v":1500,"d":"$1,500.00"}},{"$f":"SUM(G37:G46)","v":{"v":1000,"d":"$1,000.00"}},{"$f":"SUM(H37:H46)","v":{"v":2500,"d":"$2,500.00"}}]
[null,"Activity 3 (Add title and description)"]
[null,1,"Personnel",{"$nulls":5}," (List team members involved in the activity, their daily rates + estimated number of days of work for the given Activity)"]
[null,null,"- Name: J. Smith / Role: Project Manager",{"v":500,"d":"$500.00"},5,{"v":1500,"d":"$1,500.00"},{"$f":"H50-F50","v":{"v":1000,"d":"$1,000.00"}},{"$f":"D50*E50","v":{"v":2500,"d":"$2,500.00"}},"(This is an example)"]
[null,null,"- Name / Role",0,null,0,{"$f":"H51-F51","v":0},{"$f":"D51*E51","v":0}]
[null,null,"- Name / Role",null,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,2,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,3,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,4,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,5,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,"Sub-Total (Activity 3 costs)",{"$nulls":3},{"$f":"SUM(F50:F59)","v":{"v":1500,"d":"$1,500.00"}},{"$f":"SUM(G50:G59)","v":{"v":1000,"d":"$1,000.00"}},{"$f":"SUM(H50:H59)","v":{"v":2500,"d":"$2,500.00"}}]
[null,"Activity 4 (Add title and description)"]
[null,1,"Personnel",{"$nulls":5}," (List team members involved in the activity, their daily rates + estimated number of days of work for the given Activity)"]
[null,null,"- Name: J. Smith / Role: Project Manager",{"v":500,"d":"$500.00"},5,{"v":1500,"d":"$1,500.00"},{"$f":"H63-F63","v":{"v":1000,"d":"$1,000.00"}},{"$f":"D63*E63","v":{"v":2500,"d":"$2,500.00"}},"(This is an example)"]
[null,null,"- Name / Role",0,null,0,{"$f":"H64-F64","v":0},{"$f":"D64*E64","v":0}]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,2,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,3,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,4,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,5,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,"Sub-Total (Activity 4 costs)",{"$nulls":3},{"$f":"SUM(F63:F72)","v":{"v":1500,"d":"$1,500.00"}},{"$f":"SUM(G63:G72)","v":{"v":1000,"d":"$1,000.00"}},{"$f":"SUM(H63:H72)","v":{"v":2500,"d":"$2,500.00"}}]
[null,"Activity 5 (Add title and description)"]
[null,1,"Personnel",{"$nulls":5}," (List team members involved in the activity, their daily rates + estimated number of days of work for the given Activity)"]
[null,null,"- Name: J. Smith / Role: Project Manager",{"v":500,"d":"$500.00"},5,{"v":1500,"d":"$1,500.00"},{"$f":"H76-F76","v":{"v":1000,"d":"$1,000.00"}},{"$f":"D76*E76","v":{"v":2500,"d":"$2,500.00"}},"(This is an example)"]
[null,null,"- Name / Role",0,null,0,{"$f":"H77-F77","v":0},{"$f":"D77*E77","v":0}]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,null,"- Name / Role",0,null,0,0,0]
[null,2,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,3,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,4,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,5,"Other costs add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,"Sub-Total (Activity 5 costs)",{"$nulls":3},{"$f":"SUM(F76:F85)","v":{"v":1500,"d":"$1,500.00"}},{"$f":"SUM(G76:G85)","v":{"v":1000,"d":"$1,000.00"}},{"$f":"SUM(H76:H85)","v":{"v":2500,"d":"$2,500.00"}}]
[null,"Administrative Costs (Specify)"]
[null,1,"Add description (see guidelines for eligible expenses)",0,null,0,{"$f":"H88-F88","v":0},{"$f":"D88*E88","v":0}]
[null,2,"Add description (see guidelines for eligible expenses)",0,null,0,{"$f":"H89-F89","v":0},{"$f":"D89*E89","v":0}]
[null,3,"Add description (see guidelines for eligible expenses)",0,null,0,{"$f":"H90-F90","v":0},0]
[null,4,"Add description (see guidelines for eligible expenses)",0,null,0,0,0]
[null,"Sub-Total (Administrative Costs)",{"$nulls":3},{"$f":"SUM(F88:F91)","v":0},{"$f":"SUM(G88:G91)","v":0},{"$f":"SUM(H88:H91)","v":0}]
[null,"Other Costs (Specify)"]
[null,1,"Add description (see guidelines for eligible expenses)",0,null,null,{"$f":"H94-F94","v":0},{"$f":"D94*E94","v":0}]
[null,2,"Add description (see guidelines for eligible expenses)",0,null,null,{"$f":"H95-F95","v":0},{"$f":"D95*E95","v":0}]
[null,3,"Add description (see guidelines for eligible expenses)",0,null,null,{"$f":"H96-F96","v":0},0]
[null,"Sub-Total (Other Costs)",{"$nulls":3},{"$f":"SUM(F94:F96)","v":0},{"$f":"SUM(G94:G96)","v":0},{"$f":"SUM(H94:H96)","v":0}]
[null,null,"Total",null,null,{"$f":"F34+F47+F60+F73+F86+F92+F97","v":{"v":7000,"d":"$7,000.00"}},{"$f":"G34+G47+G60+G73+G86+G92+G97","v":{"v":5500,"d":"$5,500.00"}},{"$f":"H34+H47+H60+H73+H86+H92+H97","v":{"v":12500,"d":"$12,500.00"}}]