{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","INVOICE","SUBGRANTEE ADMIN&PROJ MGNT ","SUBGRANTEE DIRECT EXPENSES","PROJECT IMPL COSTS"],"not_rendered":{"macros":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":6,"rows_kept":21}
[]
[null,"Instructions for completing"]
[null,"DIBG Invoice Template for Requesting Funds"]
[]
[null,"This template is to be completed and signed by Subgrantee"]
[]
["#1","Entries should be made in highlighted cells only.  Invoice TAB receives input from ADMIN and IMPLEMENTATION TABS"]
["#2","Enter Contract Amount or Maximum Reimbursement Amount from Subgrant Agreement Budget"]
["#3","Begin with 'Project Impl Costs' TAB, then 'SUBGRANTEE Direct Exps' TAB, then 'SUBGRANTEE Grant Admininistration & Project Management' costs"]
["#4","Calculations will flow to the appropriate cells from 'Implementation Costs' TAB to 'Invoice' TAB"]
["#5",{"$nulls":4},"from 'Subgrantee Direct Expenses' TAB to 'Subgrantee Grant Admin & Proj Mngt' TAB"]
["#6",{"$nulls":4},"and from 'Subgrantee Grant Admin & Proj Mngt' TAB to 'Invoice' TAB"]
["#7"]
["#8","Review 'Invoice' TAB values for accuracy"]
["#9","If overdrawn on budget please contact us before submitting or the invoice will be rejected"]
["#10","Use Comment box at bottom of Invoice if needed"]
["#11","Sign with Name, Title and Date"]
["#12","Make a pdf of each page and combine the 4 pages into one pdf file. Attach signed vendor invoicing to support Project Inplementation Cost entries.You may claim match on the invoice, however, the 430M form is to be with final invoice."]
[null,"Use file name format  "]
[null,null,"ex.","for agreement  MARC-2021DIBG-02"]
[{"$nulls":3},"use MARC-2021DIBG-02_Inv#1"]

{"sheet":"INVOICE","index":1,"n_rows":46,"n_cols":12,"rows_kept":46,"merged":[[1,2,1,8],[2,0,4,1],[2,3,2,7],[5,3,5,7],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[16,1,16,3],[16,6,16,7],[17,1,19,1],[17,2,19,2],[17,3,19,3],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[17,8,19,8],[17,9,19,9],[45,1,49,5]]}
[]
["[SubGrantee Name]",null,"To Be Used for Round 5 and Later DIBG2021 Project Award Subgrant Agreements"]
["[Project Name in Subgrant Agreement]",null,null,"See Instructions TAB Before Completing"]
[]
[{"$nulls":3},"INVOICE for Request for Funds for DIBG"]
[{"$nulls":3},"FILL * IN * HIGHLIGHTED * FIELDS"]
[]
[]
["BILL TO:","Mount Ascutney Regional Commission",{"$nulls":4}," "]
["INVOICE #:","[Your invoice #]"]
["INVOICE DATE:","[Your Invoice Date]"]
["BILLING PERIOD:","[date range covered]",null,"(example 'Jan-Mar 2020')",{"$nulls":3}," "]
["SUBGRANT #:","[Subgrant agreement #]",null,"(example '@@@-2021DIBG- ##)"]
["PROJECT CATEGORY","choose one of 2 options",null,"(Stormwater or Natural Resources)"]
["MS4 PROJECT? (Y/N)",null," (Y or N)",{"$nulls":7},"  "]
[null," "]
[null,"SUBGRANT AGREEMENT BUDGET TABLE***",{"$nulls":4},"FOR THIS INVOICE REQUEST"]
[null,"SUBGRANT PROJECT BUDGET AMOUNT","SUBGRANT FUNDING AMOUNT","SUBGRANT MATCH PROVIDED","PREVIOUSLY INVOICED","INVOICED TO DATE","THIS INVOICE REQUEST","MATCH AMOUNT THIS INVOICE","REMAINING BALANCE"]
[]
[" "]
["ADMIN & PROJECT MANAGEMENT*",0,0,0,0,{"$f":"E21+G21","v":0},{"$f":"'SUBGRANTEE ADMIN&PROJ MGNT '!H41","v":0},0,{"$f":"C21-F21","v":0}]
["PROJECT IMPLEMENTATION COSTS** (MS4 - 50% Match required)",0,0,0,0,{"$f":"E22+G22","v":0},{"$f":"'PROJECT IMPL COSTS'!I36:I36","v":0},{"$f":"'PROJECT IMPL COSTS'!J36","v":0},{"$f":"C22-F22","v":0}]
["PROJECT IMPLEMENTATION COSTS **(Non-MS4 )",0,0,0,0,0,{"$f":"'PROJECT IMPL COSTS'!I20:I20","v":0},{"$f":"'PROJECT IMPL COSTS'!J20","v":0},0,null,null," "]
["     TOTAL",{"$f":"SUM(B21:B23)","v":0},{"$f":"SUM(C21:C23)","v":0},{"$f":"SUM(D21:D23)","v":0},{"$f":"SUM(E21:E23)","v":0},0,0,{"$f":"SUM(H21:H23)","v":0},{"$f":"SUM(I21:I23)","v":0}]
[]
["*   From 'ADMIN & PROJECT MANAGEMENT' Sheet Tab, page 2"]
["** From PROJECT IMPL COSTS' Sheet Tab, page 4"]
["***Budget from Subgrant Agreement or as amended"]
[]
["MARC Approval Amount sign-off"]
[]
[]
["Subgrantee Signature: ______________________________________________________________________"]
[]
["Name:___________________________________________________________________________________________"]
[]
["Title:__________________________________________________________________Date____________________________"]
[]
["The grantee certifies that Deliverables being billed on this invoice have been completed as outlined in the grant agreement."]
[]
["MARC's Project Manager:______________________________________________Date____________________________"]
[]
["The Grant Manager has verified that Deliverable being billed on this invoice have been completed as outlined in the grant agreement."]
[]
[]
["Comments:"]

{"sheet":"SUBGRANTEE ADMIN&PROJ MGNT ","index":2,"n_rows":46,"n_cols":14,"rows_kept":46,"merged":[[0,2,0,7],[1,2,1,7],[3,2,3,7],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[45,1,45,7]]}
[null,{"$f":"+INVOICE!A2","v":"[SubGrantee Name]"}]
[]
[null,"GRANT ADMIN & PROJECT MANAGEMENT COST"]
[]
[]
[null,"LABOR"]
[{"$nulls":5},"Hourly"]
[null,"Employee Name",null,null,"Hours","Rate",null,"TOTAL COST"]
[]
[null," ",{"$nulls":3},0,{"$f":"E10*F10","v":0},{"$f":"ROUND(G10,2)","v":0}]
[null," ",{"$nulls":3},0,{"$f":"E11*F11","v":0},{"$f":"ROUND(G11,2)","v":0}]
[null," ",{"$nulls":3},0,0,0]
[null," ",{"$nulls":3},0,0,0]
[null," ",{"$nulls":3},0,0,0]
[null," ",{"$nulls":3},0,0,0]
[null," ",{"$nulls":3},0,0,0]
[{"$nulls":4},{"$f":"SUM(E10:E16)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(H10:H16)","v":0}]
[null,"FY Indirect rate (as decimal)","FY23-24",null,null,{"v":0,"d":"0.000"},null,{"$f":"ROUND(G18,2)","v":0}]
[null,"   Subtotal labor & indirect FY23-24",{"$nulls":5},{"$f":"SUM(H17:H18)","v":0}]
[{"$nulls":7}," "]
[]
[null," ",{"$nulls":3},0,{"$f":"E22*F22","v":0},{"$f":"ROUND(G22,2)","v":0}]
[null," ",{"$nulls":3},0,{"$f":"E23*F23","v":0},0]
[null," ",{"$nulls":3},0,0,0]
[null," ",{"$nulls":3},0,0,0]
[null," ",{"$nulls":3},0,0,0]
[null," ",{"$nulls":3},0,0,0]
[null," ",{"$nulls":3},0,0,0,{"$nulls":5},"G"]
[{"$nulls":4},{"$f":"SUM(E22:E28)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"SUM(H22:H28)","v":0}]
[null,"FY Indirect rate (as decimal)","FY24-25",null,null,{"v":0,"d":"0.000"},{"$f":"ROUND(F30*H29,3)","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(G30,2)","v":0},{"$nulls":3}," "]
[null,"   Subtotal labor & indirect FY24-25",{"$nulls":5},{"$f":"SUM(H29:H30)","v":0}]
[]
[null,"TOTAL LABOR AND INDIRECT",{"$nulls":5},{"$f":"H31+H19","v":0}]
[]
[null,"DIRECT EXPENDITURES"]
[null," "]
[null,"Travel/Auto Reimbursement*",{"$nulls":5},{"$f":"'SUBGRANTEE DIRECT EXPENSES'!H21","v":0}]
[null,"Other Direct Expenses*",{"$nulls":5},{"$f":"'SUBGRANTEE DIRECT EXPENSES'!I21","v":0}]
[null,"     TOTAL DIRECT",{"$nulls":5},{"$f":"SUM(H36:H38)","v":0}]
[null,"         * From 'SUBGRANTEE DIRECT EXPS' Sheet"]
[null,"TOTAL LABOR AND DIRECT EXPENDITURES",{"$nulls":5},{"$f":"H33+H39","v":0}]
[]
[]
[]
[]
[null,"Page 2"]

{"sheet":"SUBGRANTEE DIRECT EXPENSES","index":3,"n_rows":27,"n_cols":14,"rows_kept":27,"merged":[[1,3,1,8],[7,2,7,3],[7,9,7,10],[8,2,8,3],[8,9,8,10],[9,2,9,3],[9,9,9,10],[10,2,10,3],[10,9,10,10],[11,2,11,3],[11,9,11,10],[12,2,12,3],[12,9,12,10],[13,2,13,3],[13,9,13,10],[14,2,14,3],[14,9,14,10],[15,2,15,3],[15,9,15,10],[16,2,16,3],[16,9,16,10],[17,2,17,3],[17,9,17,10],[18,2,18,3],[18,9,18,10],[19,2,19,3],[19,9,19,10]]}
[{"$f":"+INVOICE!A2","v":"[SubGrantee Name]"}]
[{"$nulls":3},"SUBGRANTEE DIRECT EXPENDITURES"]
[]
["Auto Mileage Rate ($/mile)",0.655,"(for 2023)",{"$nulls":3}," "]
[null,{"v":0.67,"d":"0.670"},"(for 2024)",{"$nulls":6}," "]
[{"$nulls":3}," ",null,null," ",null,"Other"]
[null,null," ",null,null,"Mileage","Travel / ","Travel / ","Other Direct"]
["EMPLOYEE NAME","Date","Destination",null,"# Miles","Rate","Auto Reimb","Auto Reimb","Expenses","Purpose"]
[" ",{"$nulls":5},{"$f":"E9*F9","v":0},{"$f":"ROUND(G9,2)","v":0},0]
[{"$nulls":6},{"$f":"E10*F10","v":0},{"$f":"ROUND(G10,2)","v":0},0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
[{"$nulls":6},0,0,0]
["Total  Direct Exp",{"$nulls":3},{"$f":"SUM(E9:E20)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(G9:G20)","v":0},{"$f":"SUM(H9:H20)","v":0},{"$f":"SUM(I9:I20)","v":0}]
[]
[]
[null,null,"Page 3"]
[]
[]
[{"$nulls":13},"G"]

{"sheet":"PROJECT IMPL COSTS","index":4,"n_rows":42,"n_cols":12,"rows_kept":42,"merged":[[2,0,2,8],[3,1,4,7],[6,0,6,8],[8,0,8,2],[8,3,8,4],[8,6,8,7],[9,0,9,2],[9,3,9,4],[9,6,9,7],[10,0,10,2],[10,3,10,4],[10,6,10,7],[11,0,11,2],[11,3,11,4],[11,6,11,7],[12,0,12,2],[12,3,12,4],[12,6,12,7],[13,0,13,2],[13,3,13,4],[13,6,13,7],[14,0,14,2],[14,3,14,4],[14,6,14,7],[15,0,15,2],[15,3,15,4],[15,6,15,7],[16,0,16,2],[16,3,16,4],[16,6,16,7],[17,0,17,2],[17,3,17,4],[17,6,17,7],[18,0,18,2],[18,3,18,4],[18,6,18,7],[19,6,19,7],[22,0,22,8],[24,0,24,2],[24,3,24,4],[24,6,24,7],[25,0,25,2],[25,3,25,4],[25,6,25,7],[26,0,26,2],[26,3,26,4],[26,6,26,7],[27,0,27,2],[27,3,27,4],[27,6,27,7],[28,0,28,2],[28,3,28,4],[28,6,28,7],[29,0,29,2],[29,3,29,4],[29,6,29,7],[30,0,30,2],[30,3,30,4],[30,6,30,7],[31,0,31,2],[31,3,31,4],[31,6,31,7],[32,0,32,2],[32,3,32,4],[32,6,32,7],[33,0,33,2],[33,3,33,4],[33,6,33,7],[34,0,34,2],[34,3,34,4],[34,6,34,7],[35,6,35,7],[38,0,38,8]]}
[]
[]
["PROJECT IMPLEMENTATION COSTS "]
[null,"Please list all project costs including municipal billing or other costs to be claimed as match in the 'Match Amount' column. Municipal match costs can be detailed on a 430M form or in an invoice from the Municipality"]
[]
[]
["Non-MS4 PROJECT IMPLEMENTATION COSTS "]
[]
["Contractor/Municipality",null,null,"Invoice #",null,"Inv Date","Invoice Amount",null,"Requested Amount*","Match Amount**"]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0,null,"   DO NOT WRITE IN THIS SPACE"]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["TOTAL",{"$nulls":5},{"$f":"SUM(G10:H19)","v":0},null,0,0,{"$f":"I20+J20","v":0},"check"]
[{"$nulls":8},"(enter portion of TOTAL to be requested)","(enter portion of TOTAL to be match provided)"]
[]
["MS4 (50% Match) PROJECT IMPLEMENTATION COSTS "]
[]
["Contractor/Municipality",null,null,"Invoice #",null,"Inv Date","Invoice Amount",null,"Requested Amount*","Match Amount**"]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0,null,"   DO NOT WRITE IN THIS SPACE"]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
[{"$nulls":6},0]
["TOTAL",{"$nulls":5},{"$f":"SUM(G26:H35)","v":0},null,0,0,{"$f":"I36+J36","v":0},"check"]
[{"$nulls":8},"(enter portion of TOTAL to be requested)","(enter portion of TOTAL to be match provided)"]
[]
["** Use Form 430M for total match back-up documentation and submit with final invoice"]
[]
[]
[{"$nulls":6},"Page 4"]