{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Budget by Year","Summary"],"not_rendered":{"images":3},"read":"whole","date_system":"1900"}

{"sheet":"Budget by Year","index":0,"n_rows":46,"n_cols":8,"rows_kept":46,"merged":[[1,1,1,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[8,1,8,7],[11,1,11,7],[12,1,12,6],[13,1,13,6],[26,1,26,7],[27,1,27,7],[28,1,28,6],[36,1,36,7],[37,1,37,6]]}
[]
[null,"NHCF Capacity Building Program"]
[null,"Budget"]
[]
[null,"Project Name:"]
[null,"Prepared By:"]
[null,"Date:"]
[]
[null,"**Please ensure both tabs of this template are completed**"]
[]
[null,"Expense Item","Year 1\nAmount","Year 2\nAmount","Year 3\nAmount","Vendor","Quote or Detailed\nBreakdown Attached?\n(Yes or No)"]
[null,"Eligible Expenses"]
[null,"* Refer to the Application Guide for eligible costs. PST is eligible. Insert additional rows as necessary."]
[null,"* Please do not combine multiple quotes on a single line."]
{"$rows_empty":11}
[null,"Eligible Expenses Subtotal",{"$f":"SUM(C15:C25)","v":0},{"$f":"SUM(D15:D25)","v":0},{"$f":"SUM(E15:E25)","v":0}]
[null,"Other Eligible Non-Cash:"]
[null,"In-Kind Volunteer Labour, and/or Monetized Donations"]
[null,"* Refer to the Application Guide for other (non-cash) eligiblity. Eligible rates and required attachment(s) are identified in the Application Guide. Insert additional rows as necessary.",{"$nulls":5},"Other Type (use dropdown):\n(In-Kind Volunteer Labour, \nor Monetized Donation)"]
[]
[]
[]
[]
[]
[null,"Other Eligible Non-Cash Subtotal",{"$f":"SUM(C30:C34)","v":0},{"$f":"SUM(D30:D34)","v":0},0]
[null,"Eligible Eligible Project Budget Total",{"$f":"C26+C35","v":0},{"$f":"D26+D35","v":0},0]
[null,"Ineligible Expenses"]
[null,"* Refer to the Application Guide for ineligible costs. GST is ineligible. Insert additional rows as necessary."]
[]
[]
[]
[]
[]
[null,"Ineligible Expenses Subtotal",{"$f":"SUM(C39:C43)","v":0},{"$f":"SUM(D39:D43)","v":0},0]
[null,"                        Total Project Budget",{"$f":"C44+C36","v":0},{"$f":"D44+D36","v":0},0]
[{"$nulls":7},"Published May 26, 2022 – Ver. 1.4"]

{"sheet":"Summary","index":1,"n_rows":44,"n_cols":10,"rows_kept":44,"merged":[[1,1,1,6],[2,1,2,6],[4,1,4,2],[4,3,4,5],[5,1,5,2],[5,3,5,5],[6,1,6,2],[6,3,6,5],[9,2,9,6],[12,1,12,2],[21,2,21,6],[23,1,23,2],[25,1,25,2],[28,2,28,6],[29,2,29,5],[30,2,30,5],[31,2,31,5],[32,2,32,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[38,4,38,5],[39,4,39,5],[41,7,41,10],[43,6,43,10]]}
[]
[null,"NHCF Capacity Building Program"]
[null,"Summary"]
[]
[null,"Project Name:"]
[null,"Prepared By:"]
[null,"Date:"]
[]
[]
[null,null,"Budget"]
[{"$nulls":3},"Year 1","Year 2","Year 3","Total"]
[null,null,"Eligible",{"$f":"'Budget by Year'!C26","v":0},{"$f":"'Budget by Year'!D26","v":0},{"$f":"'Budget by Year'!E26","v":0},{"$f":"SUM(D12:F12)","v":0}]
[null,"Eligible (Non-Cash)",null,{"$f":"'Budget by Year'!C35","v":0},{"$f":"'Budget by Year'!D35","v":0},{"$f":"'Budget by Year'!E35","v":0},{"$f":"SUM(D13:F13)","v":0}]
[null,null,"Total Eligible Budget",{"$f":"SUM(D12:D13)","v":0},{"$f":"SUM(E12:E13)","v":0},{"$f":"SUM(F12:F13)","v":0},{"$f":"SUM(D14:F14)","v":0}]
[null,null,"Ineligible",{"$f":"'Budget by Year'!C44","v":0},{"$f":"'Budget by Year'!D44","v":0},{"$f":"'Budget by Year'!E44","v":0},{"$f":"SUM(D15:F15)","v":0}]
[null,null,"Total Budget",{"$f":"D14+D15","v":0},{"$f":"E14+E15","v":0},{"$f":"F14+F15","v":0},{"$f":"SUM(D16:F16)","v":0}]
[]
[{"$nulls":5},"Eligible Budget",{"$f":"G12+G13","v":0}]
[{"$nulls":5},"Ineligible Budget",{"$f":"G15","v":0}]
[{"$nulls":5},"Total Project Budget",{"$f":"G16","v":0}]
[]
[null,null,"Northern Development Funding Request"]
[{"$nulls":3},"Year 1","Year 2","Year 3","Total"]
[null,"Funding Requested",{"$nulls":4},{"$f":"SUM(D24:F24)","v":0}]
[{"$nulls":3},"*maximum $100,000","*maximum $100,000","*maximum $100,000"]
[null,"Eligible Funding % Requested",null,{"$f":"D24/(D12+D13)","v":{"$error":"#DIV/0!"}},{"$f":"E24/(E12+E13)","v":{"$error":"#DIV/0!"}},{"$f":"F24/(F12+F13)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"*maximum 90%","*maximum 90%","*maximum 90%"]
[]
[null,null,"Other Funding Sources"]
[null,null,"Funding Organization\n*Do not use acronyms*",{"$nulls":3},"Amount","Funding\nConfirmed?","If no, date\ndecision expected","Confirmation\nSupplied?"]
[null,null,"Applicant Organization Example 1",{"$nulls":3},{"v":5000,"d":"$5,000.00"}]
[null,null,"Other Funder Example 2",{"$nulls":3},{"v":10000,"d":"$10,000.00"}]
[]
[]
[]
[]
[]
[null,null,"Non-Cash",{"$nulls":3},{"$f":"G13","v":0}]
[{"$nulls":4},"Total Other Funding",null,{"$f":"SUM(G31:G38)","v":{"v":15000,"d":"$15,000.00"}}]
[{"$nulls":4},"Total Funding",null,{"$f":"G39+G24","v":{"v":15000,"d":"$15,000.00"}}]
[]
[{"$nulls":5},"Difference",{"$f":"G20-G40","v":{"v":-15000,"d":"$(15,000.00)"}},"(Should be zero)"]
[]
[{"$nulls":6},"Published May 26, 2022 – Ver. 1.4"]