{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Capital","Operating","Summary"],"not_rendered":{"images":3},"read":"whole","date_system":"1900"}

{"sheet":"Capital","index":0,"n_rows":44,"n_cols":8,"rows_kept":44,"merged":[[1,1,1,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[9,1,9,7],[10,1,10,6],[11,1,11,6],[24,1,24,7],[25,1,25,7],[26,1,26,6],[34,1,34,7],[35,1,35,6]]}
[]
[null,"Northern Community Shuttle Program"]
[null,"Capital Budget"]
[]
[null,"Shuttle Service Name:"]
[null,"Prepared By:"]
[null,"Date:"]
[]
[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 Capital Subtotal",{"$f":"SUM(C13:C23)","v":0},{"$f":"SUM(D13:D23)","v":0},{"$f":"SUM(E13:E23)","v":0}]
[null,"Other Eligible Non-Cash:"]
[null,"In-Kind Volunteer Labour, Internal Equipment (Vehicle) Use, 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, Internal\nEquipment Use, or Monetized Donation)"]
[]
[]
[]
[]
[]
[null,"Other Eligible Non-Cash Subtotal",{"$f":"SUM(C28:C32)","v":0},{"$f":"SUM(D28:D32)","v":0},0]
[null,"Eligible Capital Project Budget Total",{"$f":"C24+C33","v":0},{"$f":"D24+D33","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(C37:C41)","v":0},{"$f":"SUM(D37:D41)","v":0},0]
[null,"                        Total Capital Budget",{"$f":"C42+C34","v":0},{"$f":"D42+D34","v":0},0]
[{"$nulls":7},"Published November 10, 2021 – Ver. 1.0"]

{"sheet":"Operating","index":1,"n_rows":44,"n_cols":8,"rows_kept":44,"merged":[[1,1,1,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[9,1,9,7],[10,1,10,6],[11,1,11,6],[24,1,24,7],[25,1,25,7],[26,1,26,6],[34,1,34,7],[35,1,35,6]]}
[]
[null,"Northern Community Shuttle Program"]
[null,"Operating Budget"]
[]
[null,"Shuttle Service Name:"]
[null,"Prepared By:"]
[null,"Date:"]
[]
[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 Operating Subtotal",{"$f":"SUM(C13:C23)","v":0},{"$f":"SUM(D13:D23)","v":0},0]
[null,"Other Eligible Non-Cash:"]
[null,"In-Kind Volunteer Labour, Internal Equipment (Vehicle) Use, 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, Internal\nEquipment Use, or Monetized Donation)"]
[]
[]
[]
[]
[]
[null,"Other Eligible Non-Cash Subtotal",{"$f":"SUM(C28:C32)","v":0},{"$f":"SUM(D28:D32)","v":0},0]
[null,"Eligible Operating Project Budget Total",{"$f":"C24+C33","v":0},{"$f":"D24+D33","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(C37:C41)","v":0},{"$f":"SUM(D37:D41)","v":0},0]
[null,"                        Total Operating Budget",{"$f":"C42+C34","v":0},{"$f":"D42+D34","v":0},0]
[{"$nulls":7},"Published November 10, 2021 – Ver. 1.0"]

{"sheet":"Summary","index":2,"n_rows":48,"n_cols":10,"rows_kept":48,"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],[10,7,10,8],[11,7,12,8],[12,1,12,2],[16,7,16,8],[17,7,18,8],[18,1,18,2],[26,2,26,6],[27,2,27,5],[28,2,28,5],[29,2,29,5],[30,2,30,5],[32,2,32,6],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,4,42,5],[43,4,43,5],[45,7,45,9],[47,6,47,9]]}
[]
[null,"Northern Community Shuttle Program"]
[null,"Project Budget Summary"]
[]
[null,"Shuttle Service Name:"]
[null,"Prepared By:"]
[null,"Date:"]
[]
[]
[null,null,"Budget"]
[{"$nulls":3},"Capital\nYear 1","Capital\nYear 2","Capital\nYear 3","Capital\nTotal","Eligible Capital Budget\n(for application form)"]
[null,null,"Eligible",{"$f":"Capital!C24","v":0},{"$f":"Capital!D24","v":0},{"$f":"Capital!E24","v":0},{"$f":"SUM(D12:F12)","v":0},{"$f":"G12+G13","v":0}]
[null,"Eligible (Non-Cash)",null,{"$f":"Capital!C33","v":0},{"$f":"Capital!D33","v":0},{"$f":"Capital!E33","v":0},{"$f":"SUM(D13:F13)","v":0}]
[null,null,"Ineligible",{"$f":"Capital!C42","v":0},{"$f":"Capital!D42","v":0},{"$f":"Capital!E42","v":0},{"$f":"SUM(D14:F14)","v":0}]
[null,null,"Total",{"$f":"SUM(D12:D14)","v":0},{"$f":"SUM(E12:E14)","v":0},0,{"$f":"SUM(D15:F15)","v":0}]
[]
[{"$nulls":3},"Operating\nYear 1","Operating\nYear 2","Operating\nYear 3","Operating\nTotal","Eligible Operating Budget\n(for application form)"]
[null,null,"Eligible",{"$f":"Operating!C24","v":0},{"$f":"Operating!D24","v":0},{"$f":"Operating!E24","v":0},{"$f":"SUM(D18:F18)","v":0},{"$f":"G18+G19","v":0}]
[null,"Eligible (Non-Cash)",null,{"$f":"Operating!C33","v":0},{"$f":"Operating!D33","v":0},{"$f":"Operating!E33","v":0},{"$f":"SUM(D19:F19)","v":0}]
[null,null,"Ineligible",{"$f":"Operating!C42","v":0},{"$f":"Operating!D42","v":0},{"$f":"Operating!E42","v":0},{"$f":"SUM(D20:F20)","v":0}]
[null,null,"Total",{"$f":"SUM(D18:D20)","v":0},{"$f":"SUM(E18:E20)","v":0},{"$f":"SUM(F18:F20)","v":0},{"$f":"SUM(D21:F21)","v":0}]
[]
[{"$nulls":5},"Eligible Budget",{"$f":"G12+G13+G18+G19","v":0}]
[{"$nulls":5},"Ineligible Budget",{"$f":"G14+G20","v":0}]
[{"$nulls":5},"Total Project Budget",{"$f":"G15+G21","v":0}]
[]
[null,null,"Northern Development Funding Request"]
[{"$nulls":6},"Amount",null,"Requested %"]
[null,null,"Funding Requested for Capital",{"$nulls":4},"*maximum $100,000",{"$f":"G29/(G12+G13)","v":{"$error":"#DIV/0!"}},"*maximum 80%"]
[null,null,"Funding Requested for Operating",{"$nulls":4},"*maximum $150,000",{"$f":"G30/(G18+G19)","v":{"$error":"#DIV/0!"}},"*maximum 80%"]
[null,null,"Total Funding Requested from Northern Development",{"$nulls":3},{"$f":"G29+G30","v":0},"*maximum $200,000",{"$f":"G31/(G12+G13+G18+G19)","v":{"$error":"#DIV/0!"}},"*maximum 80%"]
[]
[null,null,"Other Funding Sources"]
[null,null,"Funding Organization",{"$nulls":3},"Amount","Funding\nConfirmed?","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"}]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},"Total Other Funding",null,{"$f":"SUM(G35:G42)","v":{"v":15000,"d":"$15,000.00"}}]
[{"$nulls":4},"Total Funding",null,{"$f":"G43+G31","v":{"v":15000,"d":"$15,000.00"}}]
[]
[{"$nulls":5},"Difference",{"$f":"G25-G44","v":{"v":-15000,"d":"$(15,000.00)"}},"(Should be zero)"]
[]
[{"$nulls":6},"Published November 10, 2021 – Ver. 1.0"]