{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTIONS","Sources and Uses","Project Budget"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[59,0,59,2],[13,3,14,6]]}
["DEED MAIN STREET REVITALIZATION GRANT APPLICATION"]
["Project Source, Use & Budget Sheet"]
[]
["INSTRUCTIONS:"]
["1. Download & save a copy of this template. You will need to upload a copy with your project's details as part of the application. There are 2 tabs in this workbook that need to be completed."]
["2. On the Sources & Uses Tab detail the total project's funding needs as well as how those funds will be used. "]
["3. Complete the Project Budget tab to the best of your ability "]
["4. Upload the full document with your grant application in the Survey Monkey portal: https://www.surveymonkey.com/r/NorthlandMainStreet2"]
[]
["Below are examples of how to complete the Sources and Uses and Project Budget sections."]
[]
["EXAMPLE TAB 1 - SOURCES & USES",null,null,"In this example, the total project is $330,000. The business is asking for a $100,000 Main Street Grant"]
["Business Name:","Jan's Jams",null,"They have match funding from the owner's cash and are looking to get a bank loan."]
["Contact Name:","Jan Business",null,"This sample project is to renovate an outdoor area to help a business on the Main St corridor expand and improve their space; the funds will be used for construction costs."]
["Project Estimated Completion Date: ","2024-06-30"]
[]
["Project Sources & Uses"]
["Sources:","Amount","Secured Y/N?","Uses","Amount","Bid Received Y/N?","Contractor:"]
["Owner Cash",90000,"Yes","Repair/Renovation",235000,"Y","John's Construction Co"]
["Bank Financing (ABC Bank)",140000,"In Process","Building Construction",0]
["Other (describe)",0,null,"Landscaping",20000,"N","MN Landscaping"]
["Other (describe)",0,null,"Demo/Site Prep",65000,"N","XYZ Demolition"]
["Other (describe)",0,null,"Design/Predesign",10000,"Y","LMN Design Firm"]
["Other (describe)",0,null,"Other (Describe)",0]
[null,0,null,"Other (Describe)",0]
["Grant Requested (max 30% of total)",100000,"Requesting","Other (Describe)",0]
["Total Sources",{"$f":"SUM(B19:B26)","v":330000},null,"Total Uses",{"$f":"SUM(E19:E26)","v":330000}]
[]
["Funding Sources Detail"]
["Organization Name","Source Type (Bank, Equity, Local, Gov't)","Funding Type (Grant, Loan, Cash)","Amount $","Percentage of Total Funds","Contact Name","Email"]
["Main Street Grant","State","Grant",100000,{"$f":"B26/B27","v":0.30303030303030304},"Northland Foundation"]
["ABC Bank","Bank","Loan",140000,{"$f":"B20/B27","v":0.42424242424242425},"Joe Banker","jbank@bank.com"]
["Jan's Jams","Equity","Cash",90000,{"$f":"B19/B27","v":0.27272727272727271},"Jan Business","sample@sample.com"]
[]
[null,null,"Total",{"$f":"SUM(D31:D33)","v":330000},{"$f":"SUM(E31:E33)","v":1}]
[]
["EXAMPLE TAB 2 - PROJECT BUDGET"]
["Vendor/Contractor:","Bid Received Y/N?","Contract Received Y/N?","Description","Budgeted Amount","Work Completed Y/N?","Amount Paid to Date","Date Paid","Remaining","Comments"]
["XYZ Demolition","No","No","Demo",65000,"N",0,null,{"$f":"SUM(E39-G39)","v":65000}]
["John's Construction Co","Yes","No","Insulation",35000,"N",0,null,{"$f":"SUM(E40-G40)","v":35000}]
["John's Construction Co","Yes","No","Sheetrock",50000,"N",0,null,50000]
["John's Construction Co","Yes","No","Framing",75000,"N",0,null,75000]
["John's Construction Co","Yes","No","Interior Paint",15000,"N",0,null,15000]
[null,null,null,"Labor",0,null,0,null,0]
[null,null,null,"Plumbing",0,null,0,null,0]
["John's Construction Co","Yes","No","Doors",17000,"N",0,null,17000]
["John's Construction Co","Yes","No","Windows",17000,"N",0,null,17000]
[null,null,null,"Sub-Floor",0,null,0,null,0]
[null,null,null,"Floor Covering",0,null,0,null,0]
["John's Construction Co","Yes","No","Roof",26000,"N",0,null,26000]
[null,null,null,"Exterior Paint",0,null,0,null,0]
[null,null,null,"Mechanical",0,null,0,null,0]
[null,null,null,"Signage",0,null,0,null,0]
[null,null,null,"Electrical",0,null,0,null,0]
["LMN Design Firm","Yes","Yes","Architect",10000,"N",0,null,10000]
[null,null,null,"Construction Mgt",0,null,0,null,0]
[null,null,null,"Fees",0,null,0,null,0]
["MN Landscaping","No","No","Landscaping",20000,"N",0,null,20000]
[]
[null,null,null,"Totals",{"$f":"SUM(E39:E58)","v":330000},null,{"$f":"SUM(G39:G58)","v":0},null,{"$f":"SUM(I39:I58)","v":330000}]

{"sheet":"Sources and Uses","index":1,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Sources and Uses"]
["Business Name:"]
["Contact Name:"]
["Project Estimated Completion Date: "]
[]
["Project Sources & Uses"]
["Sources:","Amount","Secured Y/N?","Uses","Amount","Bid Received Y/N?","Contractor:"]
["Owner Cash",0,null,"Repair/Renovation",0]
["Bank Financing",0,null,"Building Construction",0]
["Other (describe)",0,null,"Landscaping",0]
["Other (describe)",0,null,"Demo/Site Prep",0]
["Other (describe)",0,null,"Design/Predesign",0]
["Other (describe)",0,null,"Other (Describe)",0]
["Other (describe)",0,null,"Other (Describe)",0]
["Grant Requested (max 30% of total)",0,null,"Other (Describe)",0]
["Total Sources",{"$f":"SUM(B8:B15)","v":0},null,"Total Uses",{"$f":"SUM(E8:E15)","v":0}]
[]
[]
["Funding Sources Detail"]
["Organization Name","Source Type (Bank, Equity, Local, Gov't)","Funding Type (Grant, Loan, Cash)","Amount $","Percentage of Project Funding","Contact Name","Email"]
["Main Street Grant","State","Grant",null,null,"Northland Foundation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Totals",{"$f":"SUM(D22:D31)","v":0},{"$f":"SUM(E21:E31)","v":0}]

{"sheet":"Project Budget","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Vendor/Contractor:","Bid Received Y/N?","Contract Received Y/N?","Description","Budgeted Amount","Work Completed Y/N?","Amount Paid to Date","Date Paid","Remaining","Comments"]
[null,null,null,"Demo",0,null,0,null,{"$f":"SUM(E2-G2)","v":0}]
[null,null,null,"Insulation",0,null,0,null,{"$f":"SUM(E3-G3)","v":0}]
[null,null,null,"Sheetrock",0,null,0,null,0]
[null,null,null,"Framing",0,null,0,null,0]
[null,null,null,"Interior Paint",0,null,0,null,0]
[null,null,null,"Labor",0,null,0,null,0]
[null,null,null,"Plumbing",0,null,0,null,0]
[null,null,null,"Doors",0,null,0,null,0]
[null,null,null,"Windows",0,null,0,null,0]
[null,null,null,"Sub-Floor",0,null,0,null,0]
[null,null,null,"Floor Covering",0,null,0,null,0]
[null,null,null,"Roof",0,null,0,null,0]
[null,null,null,"Exterior Paint",0,null,0,null,0]
[null,null,null,"Mechanical",0,null,0,null,0]
[null,null,null,"Signage",0,null,0,null,0]
[null,null,null,"Electrical",0,null,0,null,0]
[null,null,null,"Architect",0,null,0,null,0]
[null,null,null,"Construction Mgt",0,null,0,null,0]
[null,null,null,"Fees",0,null,0,null,0]
[null,null,null,"Contingency",0,null,0,null,{"$f":"SUM(E21-G21)","v":0}]
[null,null,null,"Other (add)",0,null,0,null,0]
[null,null,null,"Other (add)",0,null,0,null,0]
[null,null,null,"Totals",{"$f":"SUM(E2:E23)","v":0},null,{"$f":"SUM(G2:G23)","v":0},null,{"$f":"SUM(I2:I23)","v":0}]