{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Definitions","GSAR","data validation","Budget Template","Sheet4","Sheet3","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"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":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,1,18,15],[19,1,19,15],[20,1,20,15],[0,1,0,15],[8,1,8,15],[11,1,11,15],[12,1,12,15],[14,1,14,15],[16,1,16,15],[17,1,17,15]]}
[null,"Instructions for the Grant Submission Authorization Request (GSAR) & Budget Form"]
[]
[null,"Click \"Enable Editing\" in the top bar when you open this workbook as it allows it to fully function. Below is a snapshot of where to click:"]
[]
[]
[]
[]
[]
[null,"GSAR: The GSAR form should be filled out with Finance at least a month prior to the proposal deadline. This allows any programmatic and budget questions to be vetted in time for approval. Finance will route to the Dean and then the Provost for approval, depending on the dollar threshold. The grant cannot be submitted until the GSAR is fully approved. The questions on this form are all the key ones that decision-makers use to determine if the College wants to purse the grant with it's compliance, funding and whether it's strategic/supportive to our mission. "]
[]
[null,"Budget Template"]
[null,"Once the GSAR has been approved, use the budget template in this workbook for developing your budget as it lists benefit rates and has an indirect calculation. \nSome sources do not allow indirect costs. This is ok and should be noted if they are not allowed."]
[null,"If for some reason this template does not work for you or it needs to be modified, please contact Vikki Gauvin in the Finance Office (383-6627). The budget template gets submitted with the GSAR."]
[]
[null,"Finance Policy No. 304 was initiated to streamline the process of grant submissions by Champlain College personnel and to ensure that any and all grant applications submitted on behalf of Champlain College are: in the best interest of the institution; do not violate any institutional or legal regulations; and are a good use of the resources of the College, including the time and effort of all employees, faculty and staff. This process is intended to allow for a proper evaluation of each grant proposal and a response back to the requester in a reasonable amount of time. The Champlain College Finance Department is committed to reviewing budget proposals and managing grant awards in a manner compliant with both the College and the respective funding sources."]
[]
[null,"Grant Submission Authorization Request (GSAR) Finance Policy No. 304:"]
[null,"All applications for external funding on behalf of, or administered by, Champlain College must be prepared according to the College's grant seeking process. This process is explained on the Grant website and includes a submission of a Grant Submission Authorization Form and budget at  the outset of the planning process. Please allow time for parties who need to review and sign off on the GSAR and the budget. Failure to obtain the required signature approvals may result in a decision to withdraw the application for submission or to return approved funds to the awarding agency."]
[null,"Important Items to Note"]
[null," - Unless it is required or necessary to have matching funds, the college recommends including in-kind contribution in the narrative rather than in the budget."]
[null," - The college does not typically act as a fiscal sponsor for other agencies and the President also needs to approve this type of grant before it can be applied for."]
[null," - Any new positions that will continue after the grant closes will need a funding plan approved by Finance."]
[null," - Some sources do not allow indirect costs which is ok and should be noted if indirect is not allowed."]
[null," - Time and Effort certifications must be completed within 60 days of fiscal year end for any employee who works on a grant."]
[null," - Format for budget may differ for specific proposals; be sure to check proposal guidelines"]

{"sheet":"Definitions","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,1,0,2],[25,1,25,2]]}
[null,"Definitions:"]
[]
[null,"Type of Project Classifications on the GSAR form:"]
[null,"Academic ","Faculty development, curriculum development, instructional, academic travel, etc."]
[null,"Special Events","Hosting or sponsorship of a conference; guest speaker; arts performance; etc."]
[null,"Student Life or co-curricular programming","Internships, co-ops, special programs, etc."]
[null,"Student Scholarships","Or other student financial aid"]
[null,"Computer Intensive","Computer programming, website or game design, hardware/software purchase, etc"]
[]
[null,"General Grant Terms:"]
[null,"Indirect Costs","The indirect fee offsets the institution’s administrative expenses that have not been directly charged.  These administrative expenses include expenses such as Payroll, Finance, Accounts Payable, People and Technology, buildings, maintenance, electricity, heat, and student accounts; just to name a few. It is the College's practice to re-coup these costs whenever we can. Champlain's indirect rate is 40.5%."]
[null,"Gifts in Kind","Also referred to as in-kind donations, is a kind of charitable giving in which, instead of giving money to buy needed goods and services, the goods and services themselves are given. Gifts in kind are distinguished from gifts of cash. Examples of gifts in-kind that Champlain may provide to the grant include staff time, indirect costs (if they aren't allowed), etc. Unless it is required or necessary to have in-kind funds, the college recommends including in-kind contribution in the narrative rather than in the budget of the grant application."]
[null,"Match (or matching funds)","College Funds that are set to be paid in equal amount to funds available from other sources. Matching fund payments usually arise in situations of charity or public good. The terms cost sharing, in-kind, and matching are often used interchangeably. "]
[null,"Fiscal Sponsor","A fiscal sponsor is a nonprofit organization that provides fiduciary oversight, financial management, and other administrative services to help build the capacity of charitable projects. Also sometimes referred to as fiscal agent. Champlain requires the President's approval before entering into any agreement to act as a fiscal sponsor."]
[null,"Fringe/Benefits","The cost associated with paying staff salary dollars. For each full-time salary dollar paid the college pays 32.35% of this amount towards benefits. For each part-time salary/wage dollar paid the college pays 10% in benefits."]
[null,"FICA","A payroll tax that is a cost of 7.65% for every salary/wage dollar paid. "]
[]
[null,"Is it a Gift or a Grant?"]
[null,"Typical Requirements of a Grant (not characteristics of gifts)"]
[null," ·       The award or agreement binds the university to a scope of work that is specified to a substantial level of detail, or"]
[null,"·         A line item budget is involved, or"]
[null,"·         Financial reports are required and/or the expenses are subject to audit, or"]
[null,"·         Financial reports are required and/or the expenses are subject to audit, or"]
[null,"·         A period of performance is specified, or"]
[null,"·         Unused funds must be returned to the sponsor, or"]
[null,"·         The agreement provided for disposition of either tangible or intangible properties (including equipment, records, formal activity reports, theses    or dissertations, data rights, copyrights, inventions, and research-related material)"]

{"sheet":"GSAR","index":2,"n_rows":56,"n_cols":4,"rows_kept":56,"cut":false,"hidden":false,"merged":[[6,0,6,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[41,0,41,3],[55,0,55,3],[34,0,34,3],[35,0,35,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[40,0,40,3]]}
[null,null,null,"Grant Submission Authorization Request (GSAR)"]
[]
["Project Title:",null,"Application Deadline:"]
[]
["Project Start Date:",null,"Project End Date:"]
[]
["Summary Information "]
[]
["Division/Department:",null,"Guidelines URL:"]
[]
["Grant Request Amount:",null,"Matching funds required or needed?"]
[]
["If yes, Match amount and budget # to cover it:",null,"Total Project Budget"]
[]
["Does the grant require the college to act as a fiscal sponsor (if yes, President needs to approve):",null,"Reporting Requirements?"]
[]
["Funding Source:",null,"Private or Government Funded?"]
[]
["Are Indirect Costs allowed? If so, enter amount:",null,"Are there any new cost to Champlain? If yes, explain in narrative."]
[]
["Type of Project",null,"Partner Organization (if applicable):"]
[]
[]
[]
[]
[]
["Potential Grant Impact (Please check yes or no to the following statements & provide explanation as requested)"]
["                                      This project supports programs or services that Champlain already offers."]
["                                      This project supports the strategic plan."]
["                                      This project will create a new program, service, or facility.                        If Yes:      "]
["                                      This project will create a new faculty/staff position.                                     If Yes:      "]
["                                      This project requires an external audit."]
["                                      The proposed grant funds will replace budgeted institutional funds during the project (budget relief)."]
["                                      The project will require institutional funds to sustain it beyond the grant funding. If Yes, explain below:"]
[]
["                                      This project reflects an existing institutional priority.  If yes, provide details below."]
[]
["                                      The project will require the support of at least one other department. If Yes, list all that apply below:"]
[]
[]
["Project Description (Briefly describe project in two or three sentences; if needed attach additional information)"]
[]
[]
["Required Signatures:","Printed Name","Signature","Date"]
["Project Director:"]
[]
["Finance:"]
[]
["Advancement:"]
[]
["Dean (If Applicable):"]
[]
["Provost (if > $2k) or VP:"]
[]
["President (if request requires fiscal sponsor approval):"]
["*If possible, submit budget draft with form; otherwise Finance approval will be contingent on budget."]

{"sheet":"data validation","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Academic ",null,null,"Yes",null,"Privately Funded"]
["Special Events",null,null,"No",null,"Government Funded"]
["Student Life/Programming"]
["Student Scholarships"]
["Computer Intensive"]
["Equipment Purchase"]
["Construction/Renovation"]
[]
[null,null,null,null,null,"*Approved with concerns"]
[null,null,null,null,null,"*Approval contingent on budget"]

{"sheet":"Budget Template","index":4,"n_rows":88,"n_cols":9,"rows_kept":88,"cut":false,"hidden":false,"merged":[[85,3,85,4],[85,5,85,7],[49,4,49,5],[51,4,51,5],[53,4,53,5],[55,4,55,5],[59,4,59,5],[61,4,61,5],[68,4,68,5],[80,3,80,4],[80,5,80,6],[81,3,81,4],[81,5,81,7],[82,1,83,8]]}
[null,"Grant Budget (include additional breakdown/explanation as needed)",null,null,null,"Project Name:",{"$f":"IF(GSAR!B3=0,\"\",GSAR!B3)","v":""}]
[null,null,null,null,null,null,"Grant Request","Champlain Cost-Share","Total Project Costs"]
[null,"A.","EXISTING PERSONNEL COSTS (existing costs)"]
[null,null,"Full-time Faculty/Staff (501101)","Yearly Salary","% of Time","# YR"]
[null,null,null,null,null,null,{"$f":"D5*E5*F5","v":0},null,{"$f":"G5+H5","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D7*E7*F7","v":0},null,{"$f":"G7+H7","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D9*E9*F9","v":0},null,{"$f":"G9+H9","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D11*E11*F11","v":0},null,{"$f":"G11+H11","v":0}]
[null,null,null,null,null,"Total Full-time Staff salary/Wages",{"$f":"SUM(G5:G11)","v":0},0,0]
[]
[null,null,"Part-time Faculty/Staff (501201)","Yearly Salary","% of Time","# YR"]
[null,null,null,null,null,null,{"$f":"D15*E15*F15","v":0},null,{"$f":"G15+H15","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D17*E17*F17","v":0},null,{"$f":"G17+H17","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D19*E19*F19","v":0},null,{"$f":"G19+H19","v":0}]
[null,null,null,null,null,"Total Part-time Faculty/Staff",{"$f":"SUM(G15:G19)","v":0},0,0]
[null,null,null,null,null,"Total existing personnel FICA (502101)",{"$f":"(G20+G12)*0.0765","v":0},0,0]
[null,null,null,null,null,"Total existing personnel Fringe/Benefits (502314)",{"$f":"(G12*0.3235)+(G20*0.1235)","v":0},0,0]
[]
[null,null,null,null,null,"Total EXISTING PERSONNEL",{"$f":"G12+G20+G21+G22","v":0},0,0]
[]
[null,"B. ","NEW PERSONNEL COSTS (new costs -attach plan of what will happen to positions once grant is completed)"]
[null,null,null,null,"Student hours "]
[null,null,null,"$/hr","for this Project"]
[null,null,"Student Wages ",null,null,null,{"$f":"D29*E29","v":0},null,{"$f":"G29+H29","v":0}]
[]
[null,null,"Full-time Faculty/Staff (501101)","Yearly Salary","% of Time","# YR"]
[null,null,null,null,null,null,{"$f":"D32*E32*F32","v":0},null,{"$f":"G32+H32","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D34*E34*F34","v":0},null,{"$f":"G34+H34","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D36*E36*F36","v":0},null,{"$f":"G36+H36","v":0}]
[null,null,null,null,null,"Total New Full-time Staff salary/Wages",{"$f":"SUM(G32:G36)","v":0},0,0]
[]
[null,null,"Part-time Faculty/Staff (501201)",null,null,"# YR"]
[null,null,null,null,null,null,{"$f":"D40*E40*F40","v":0}]
[]
[null,null,null,null,null,null,{"$f":"D42*E42*F42","v":0}]
[null,null,null,null,null,"Total Part-time Faculty/Staff",{"$f":"SUM(G40:G42)","v":0},0,0]
[null,null,null,null,null,"Total new personnel FICA (502101)",{"$f":"(G43+G37+G29)*0.0765","v":0},0,0]
[null,null,null,null,null,"Total new personnel Fringe/Benefits (502314)",{"$f":"(G37*0.3235)+(G43*0.1235)","v":0},0,0]
[]
[null,null,null,null,null,"Total NEW PERSONNEL",{"$f":"G37+G43+G44+G45+G29","v":0},0,0]
[]
[null,"C.","GRANT SPECIFIC COSTS","Amount","Notes"]
[null,null,"Materials and Supplies",null,null,null,{"$f":"D50","v":0},null,{"$f":"G50+H50","v":0}]
[]
[null,null,"Computer & Hardware",null,null,null,{"$f":"D52","v":0},null,{"$f":"G52+H52","v":0}]
[]
[null,null,"Software",null,null,null,{"$f":"D54","v":0},null,{"$f":"G54+H54","v":0}]
[]
[null,null,"Travel-training",null,null,null,{"$f":"D56","v":0},null,{"$f":"G56+H56","v":0}]
[]
[null,null,"Scholarship",null,null,null,null,null,{"$f":"G58+H58","v":0}]
[]
[null,null,"Contractual services",null,null,null,{"$f":"D60","v":0},null,{"$f":"G60+H60","v":0}]
[]
[null,null,"Other",null,null,null,{"$f":"D62","v":0},null,{"$f":"G62+H62","v":0}]
[null,null,"Contractual services",null,null,null,0]
[null,null,"Advertising",0,null,null,0]
[]
[null,null,null,null,null,"Total OPERATING COSTS",{"$f":"SUM(G50:G62)","v":0},0,0]
[]
[null,"D."," GRANT SPECIFIC EQUIPMENT COSTS >$5,000",null,"Notes"]
[null,null,"Equipment Purchases (useful life > 1 year and a per unit cost > $5k)",null,null,null,{"$f":"D69","v":0},null,{"$f":"G69+H69","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"D71","v":0}]
[]
[null,null,null,null,null,"Total EQUIPMENT COSTS",{"$f":"SUM(G69)","v":0},0,0]
[]
[null,"E.",null,null,null,"Total Direct Expenses for this Project",{"$f":"G73+G66+G47+G24","v":0},0,0]
[]
[null,"F. Indirect Costs for Champlain College (CC's federally approved indirect rate is 40.5%)***",null,null,null,40.5,{"$f":"F77*G75","v":0},{"$f":"F77*H75","v":0},{"$f":"F77*I75","v":0}]
[]
[null,"G. Total Grant Costs (Total Direct + Indirect Costs)",null,null,null,null,{"$f":"G75+G77","v":0},0,0]
[]
[null,"Required Signatures:",null,"Printed Name",null,"Signature",null,"Date"]
[null,"Budget Manager:"]
[null,"I understand this amount will be taken out of my budget if the grant funding is received and am committing funds from the above budget numbers. (Signature needed only If there is cost-share)"]
[]
[]
[null,"**VP of Finance:"]
[null,"**VP of Finance only needs to sign-off if there is a new budget number or new dollars proposed."]
[null,"*** Some sources do not allow indirect costs which is ok and should be noted if indirect is not allowed."]

{"sheet":"Sheet4","index":5,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INDEX(H1:H2,G1,0)","v":"N/A"},null,null,null,null,null,1,"N/A"]
["See Attached In-Kind Budget",null,null,null,null,null,null,"See Attached In-Kind Budget"]

{"sheet":"Sheet3","index":6,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,2,"Yes"]
[null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,"Don't Know"]

{"sheet":"Sheet1","index":7,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INDEX(H1:H3,G1,0)","v":"Yes"},null,null,null,null,null,1,"Yes"]
["No",null,null,null,null,null,null,"No"]
["Limited",null,null,null,null,null,null,"Limited"]

{"sheet":"Sheet2","index":8,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[{"$f":"INDEX(H1:H3,G1,0)","v":"In-Kind"},null,null,null,null,null,1,"In-Kind"]
["Cash",null,null,null,null,null,null,"Cash"]
["Both Cash and In-Kind",null,null,null,null,null,null,"Both Cash and In-Kind"]