{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Last-Mile Project Budget"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Last-Mile Project Budget","index":0,"n_rows":64,"n_cols":7,"rows_kept":64,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,2,8,5],[9,2,9,5],[10,1,10,2],[11,1,11,5],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,5],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,5],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,5],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,5],[35,1,35,2],[36,1,36,2],[37,1,37,5],[38,1,38,2],[39,1,39,2],[40,1,40,5],[41,1,41,2],[42,1,42,2],[43,1,43,5],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,5],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,5],[55,1,55,5],[56,1,56,4],[57,1,57,4],[58,1,58,4],[59,1,59,4],[60,1,60,5],[61,1,61,4],[62,1,62,5],[63,1,63,4]]}
[null,"Northern Development Initiative Trust"]
[null,"Connecting British Columbia Program - Phase Two"]
[null,"Intake 2 - Last-Mile"]
[null,"TEMPLATE 2 - PROJECT BUDGET"]
[null,"Instructions:"]
[null,"   All costs below are listed as examples - insert values relevant to your project."]
[null,"   Add or delete line items as necessary."]
[null,"   Adjust formulas to incorporate new items as necessary."]
[null,"Project Name:"]
[null,"Prepared By:"]
[null,"Expense Item:",null,"Equipment/\nParts Costs","Labour Costs","Total"]
[null,"Engineering and Project Management"]
[null,"Site survey",null,0,{"v":2500,"d":"$2,500.00"}]
[null,"Project management",null,0,{"v":2000,"d":"$2,000.00"}]
[null,"Subtotal",null,{"$f":"SUM(D13:D14)","v":0},{"$f":"SUM(E13:E14)","v":{"v":4500,"d":"$4,500.00"}},{"$f":"SUM(D15:E15)","v":{"v":4500,"d":"$4,500.00"}}]
[null,"Site Preparation"]
[null,"Site preparation - Level rock for tower base",null,0,{"v":2000,"d":"$2,000.00"}]
[null,"Drilling for rock anchors and fencing",null,{"v":1200,"d":"$1,200.00"},{"v":2000,"d":"$2,000.00"}]
[null,"Concrete",null,{"v":2000,"d":"$2,000.00"},{"v":2000,"d":"$2,000.00"}]
[null,"Fencing and climbing shield",null,{"v":2500,"d":"$2,500.00"},{"v":1000,"d":"$1,000.00"}]
[null,"Subtotal",null,{"$f":"SUM(D17:D20)","v":{"v":5700,"d":"$5,700.00"}},{"$f":"SUM(E17:E20)","v":{"v":7000,"d":"$7,000.00"}},{"$f":"SUM(D21:E21)","v":{"v":12700,"d":"$12,700.00"}}]
[null,"Point of Presence and Tower Locations"]
[null,"Installation two 10 meter tower",null,{"v":5000,"d":"$5,000.00"},{"v":3000,"d":"$3,000.00"}]
[null,"Installation of equipment box on towers",null,{"v":1500,"d":"$1,500.00"},{"v":1000,"d":"$1,000.00"}]
[null,"Installation of uninterruptable power supply (UPS)",null,{"v":1000,"d":"$1,000.00"},{"v":400,"d":"$400.00"}]
[null,"Installation of antennas on tower ",null,{"v":1600,"d":"$1,600.00"},{"v":1200,"d":"$1,200.00"}]
[null,"Installation of wireless radios (access points)",null,{"v":3000,"d":"$3,000.00"},{"v":600,"d":"$600.00"}]
[null,"Installation of conduit and power between point of presence and tower ",null,{"v":500,"d":"$500.00"},{"v":1000,"d":"$1,000.00"}]
[null,"Ethernet cable between wireless radios and Internet gateway service provider equipment",null,{"v":100,"d":"$100.00"},{"v":500,"d":"$500.00"}]
[null,"Subtotal",null,{"$f":"SUM(D23:D29)","v":{"v":12700,"d":"$12,700.00"}},{"$f":"SUM(E23:E29)","v":{"v":7700,"d":"$7,700.00"}},{"$f":"SUM(D30:E30)","v":{"v":20400,"d":"$20,400.00"}}]
[null,"Set Up, Configuration and System Testing"]
[null,"Install router",null,{"v":600,"d":"$600.00"},{"v":200,"d":"$200.00"}]
[null,"Set up, configuration and system testing",null,{"v":1100,"d":"$1,100.00"},{"v":1500,"d":"$1,500.00"}]
[null,"Subtotal",null,{"$f":"SUM(D32:D33)","v":{"v":1700,"d":"$1,700.00"}},{"$f":"SUM(E32:E33)","v":{"v":1700,"d":"$1,700.00"}},{"$f":"SUM(D34:E34)","v":{"v":3400,"d":"$3,400.00"}}]
[null,"Customer Premise "]
[null,"Subscriber units",null,{"v":6000,"d":"$6,000.00"},{"v":1500,"d":"$1,500.00"}]
[null,"Subtotal",null,{"$f":"SUM(D36)","v":{"v":6000,"d":"$6,000.00"}},{"$f":"SUM(E36)","v":{"v":1500,"d":"$1,500.00"}},{"$f":"SUM(D37:E37)","v":{"v":7500,"d":"$7,500.00"}}]
[null,"Other Equipment"]
[null,"Insert description (if applicable)",null,0,0]
[null,"Subtotal",null,{"$f":"SUM(D39)","v":0},{"$f":"SUM(E39)","v":0},{"$f":"SUM(D40:E40)","v":0}]
[null,"One-time Network Set Up Fees"]
[null,"ISP charge",null,0,{"v":500,"d":"$500.00"}]
[null,"Subtotal",null,{"$f":"SUM(D42)","v":0},{"$f":"SUM(E42)","v":{"v":500,"d":"$500.00"}},{"$f":"SUM(D43:E43)","v":{"v":500,"d":"$500.00"}}]
[null,"Miscellaneous"]
[null,"Shipping costs",null,{"v":2000,"d":"$2,000.00"},0]
[null,"Travel",null,0,{"v":5000,"d":"$5,000.00"}]
[null,"Consultation costs",null,{"v":2000,"d":"$2,000.00"},{"v":3000,"d":"$3,000.00"}]
[null,"Subtotal",null,{"$f":"SUM(D45:D47)","v":{"v":4000,"d":"$4,000.00"}},{"$f":"SUM(E45:E47)","v":{"v":8000,"d":"$8,000.00"}},{"$f":"SUM(D48:E48)","v":{"v":12000,"d":"$12,000.00"}}]
[null,"Ineligible Expenses"]
[null,"Permit and licensing costs (ineligible)",null,{"v":5000,"d":"$5,000.00"}]
[null,"Contingency reserve based on risk management plans (ineligible)",null,{"v":5000,"d":"$5,000.00"},{"v":5000,"d":"$5,000.00"}]
[null,"Subtotal",null,{"$f":"SUM(D50:D51)","v":{"v":10000,"d":"$10,000.00"}},{"$f":"SUM(E50:E51)","v":{"v":5000,"d":"$5,000.00"}},{"$f":"SUM(D52:E52)","v":{"v":15000,"d":"$15,000.00"}}]
[null,"Total Eligible Expenses",null,{"$f":"D15+D21+D30+D34+D37+D40+D43+D48","v":{"v":30100,"d":"$30,100.00"}},{"$f":"E15+E21+E30+E34+E37+E40+E43+E48","v":{"v":30900,"d":"$30,900.00"}},{"$f":"F15+F21+F30+F34+F37+F40+F43+F48","v":{"v":61000,"d":"$61,000.00"}}]
[null,"Total Budgeted Expenses",null,{"$f":"D53+D52","v":{"v":40100,"d":"$40,100.00"}},{"$f":"E53+E52","v":{"v":35900,"d":"$35,900.00"}},{"$f":"F53+F52","v":{"v":76000,"d":"$76,000.00"}}]
[]
[null,"Funding Sources"]
[null,"Connecting British Columbia - Phase Two (Intake 2 - Last-Mile) Grant",{"$nulls":3},{"v":30500,"d":"$30,500.00"}]
[null,"Applicant organization",{"$nulls":3},{"v":25000,"d":"$25,000.00"}]
[null,"Other funding sources (bank loans, corporate donations, community support, other grants)",{"$nulls":3},{"v":20500,"d":"$20,500.00"}]
[null,"Total one-time funding",{"$nulls":3},{"$f":"SUM(F57:F59)","v":{"v":76000,"d":"$76,000.00"}}]
[]
[null,"Funding shortfall/overage",{"$nulls":3},{"$f":"F54-F60","v":0},"Must equal $0"]
[]
[null,"Funding Percentage Requested (Requested Grant ÷ Total Eligible Expenses)",{"$nulls":3},{"$f":"F57/F53","v":{"v":0.5,"d":"50.00%"}},"Maximum 50%"]