{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Budget","Contract Staff Detail","Q1","Q2","Q3","Q4","Q5","Final Report ","Budget Revision 1","Budget Revision","Budget Revision (2)","Budget Revision (3)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":38,"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":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[10,3,10,4],[15,3,15,4]]}
["Instructions for Applicants /Grantees: "]
[]
["Budget Sheet:",null,null,"Q1 Sheet:","For submitting payment requests. Please see the note below about Proof of Payment"]
[null,"Grantee Vendor Name:","Required Field","Grantee Vendor Name:","Autopopulates"]
[null,"Sigma Vendor Number:","Required Field","Sigma Vendor Number:","Autopopulates"]
[null,"Project Name","Required Field","Project Name","Autopopulates"]
[null,"Grant Given Number","Not required for application","Grant Given Number","Autopopulates"]
[null,"Contract Dates To: - From:","Not required for application","Contract Dates To: - From:","Autopopulates"]
[null,"Contact Name: ","Required Field","Contact Name: ","Autopopulates"]
[null,"Contact Name","Required Field","Contact Name","Autopopulates"]
[null,"Tasks/Items:","Required Field. To keep the form simple, combine tasks of the same type for all quarters, for example Purchase Supplies can be used for any equipment or supplies purchased for the project","Expenditures Section"]
[null,"Task Number: ","Required Field, Consecutive Numbers should be used.","Tasks/Items:","Required Field.Use the same task/item names from the budget sheet"]
[null,"Amount:","Required Field: Total Amount for each task","Task Number: ","Required Field,Make sure that the Task Numbers Match those on the Budget Sheet for each expense"]
[null,"Task/Item Total:","Auto Calculates","Amount:","Required Field: Total Amount for each task this period"]
[null,"Indirect Budget:","Not applicable for Recycling Infrastructure Grants","Task/Item Total:","Auto Calculates"]
[null,"Project Budget:","Auto Calculates","Progress Report"]
[null,"Match Budget:","Required Field, Enter the Match percentage for the project. Minimum match required","*All of the columns will autopopulate from the Expenditures Section except fo the Activity This Period Column. This column is used for notes regarding each task. "]
[null,"Grant Budget:","Auto Calculates","*Indirect Amount, Project Amount, Grant Amount, Reimbursement Amount, and Grant Amounts will Autopopulate Based on embedded formulas. "]
[null,null,null,"Match Amount:","Put the total amount of match funds expended for this period. "]
[null,null,null,"Retention Amount is set and will autopopulate. "]
[null,null,null,"Statement of Review and Approval:","You must type your name and sign the quarterly payment request. You can use a digital signature or you can print, sign, and then scan. "]
[]
[]
[null,null,null,"Proof of Payment","1.      Proof of payment.  Proof of payment may be:"]
[null,null,null,null,"a.      Front and back of a cancelled check from the bank showing it was paid"]
[null,null,null,null,"b.      Front of a cancelled check and screenshot or copy of a bank statement that identified the check clearing the bank account."]
[null,null,null,null,"c.      Screenshot or bank state of an ACH, EFT or other electronic payment that provides the necessary detail to support who the payment was made to, the amount and date."]

{"sheet":"Budget","index":1,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[62,7,62,8],[62,18,62,19],[62,5,62,6],[49,7,49,8],[50,7,50,8],[51,7,51,8],[52,7,52,8],[53,7,53,8],[54,7,54,8],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[60,7,60,8],[61,7,61,8],[60,5,60,6],[61,5,61,6],[58,5,58,6],[59,5,59,6],[56,5,56,6],[57,5,57,6],[54,5,54,6],[55,5,55,6],[52,5,52,6],[53,5,53,6],[50,5,50,6],[51,5,51,6],[49,5,49,6],[38,9,38,10],[28,4,28,6],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[25,4,25,6],[26,4,26,6],[27,4,27,6],[26,7,26,8],[27,7,27,8],[23,9,23,10],[28,7,28,8],[36,9,36,10],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[32,7,32,8],[33,7,33,8],[33,9,33,10],[23,4,23,6],[24,4,24,6],[18,7,18,8],[19,7,19,8],[20,7,20,8],[17,7,17,8],[17,9,17,10],[20,4,20,6],[21,4,21,6],[22,4,22,6],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[22,9,22,10],[64,25,64,26],[31,9,31,10],[19,4,19,6],[4,4,4,10],[5,4,5,10],[6,4,6,10],[7,4,7,10],[9,5,9,10],[10,5,10,10],[11,5,11,10],[12,5,12,10],[14,5,14,7],[14,9,14,10],[17,4,17,6],[18,4,18,6],[15,5,15,8]]}
[]
[]
[]
[]
[null,null,null,null,"MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY"]
[null,null,null,null,"MATERIALS MANAGEMENT DIVISION - Recycling Unit"]
[null,null,null,null,"Recycling  Grant"]
[null,null,null,null,"FINANCIAL STATUS REPORT"]
[]
[null,null,null,null,"Grantee / Vendor Name:"]
[null,null,null,null,"Sigma Vendor Number:"]
[null,null,null,null,"Project Name:"]
[null,null,null,null,"Grant Given Number:"]
[null,null,null,null,"Contract Date","From:",null,"To:"]
[null,null,null,null,"Contact Name:",null,null,null,"Contact Number:"]
[null,null,null,null,"Contact Email:"]
[]
[null,null,null,null,"Task/Item",null,null,"Task/Item Number",null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null," ",null,null,null,null,null,0]
[null,null,null,null,"Task/Item Subtotal",null,null,null,null,{"$f":"SUM(J19:K28)","v":0}]
[]
[null,null,null,null,"INDIRECT BUDGET",null,null,null,"Percentage"]
[null,null,null,null,null,null,null,null,0,{"$f":"J29*I32","v":0}]
[null,null,null,null,"PROJECT  BUDGET"]
[null,null,null,null,"Total",null,null,null,null,{"$f":"J32+J29","v":0}]
[]
[null,null,null,null,"MATCH BUDGET",null,null,null,"Percentage"]
[null,null,null,null,"Total",null,null,null,0,{"$f":"PRODUCT(J34,I37)","v":0}]
[null,null,null,null,"GRANT BUDGET"]
[null,null,null,null,"Total",null,null,null,null,{"$f":"(J29+J32)-J37","v":0}]
[]
[]
[null,null,null,null,"Retention Rate:",0.05]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"GRANT","MATCH"]
[null,null,null,null,"Contractor","Budget",null,"Grant Amount",null,"Match Amount",null,"Allowable Indirect","Allowable Indirect"]
[null,null,null,null,null,null,null,null,null,{"$f":"F51-H51","v":0},null,{"$f":"IF(F51<=25000,H51,25000*(H51/(H51+J51)))","v":0},{"$f":"IF(F51<=25000,J51,25000*(J51/(H51+J51)))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"F52-H52","v":0},null,{"$f":"IF(F52<=25000,H52,25000*(H52/(H52+J52)))","v":0},{"$f":"IF(F52<=25000,J52,25000*(J52/(H52+J52)))","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,0,null,0,0]

{"sheet":"Contract Staff Detail","index":2,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":true,"merged":[[32,1,32,8],[33,1,33,8],[1,1,1,11],[7,9,7,11],[3,2,3,8],[4,2,4,8],[5,2,5,3],[7,3,7,4],[7,6,7,8]]}
[]
[null,"STAFFING DETAILS"]
[]
[null,"Grantee Name",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[null,"Project Name",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[null,"Tracking Number",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,"Hourly Rate Range",null,null,"GRANT",null,null,"MATCH"]
[null,"Name","Position Title","Current * ","Projected Highest **","Fringe Rate Percentage","Estimated Hours ","Estimated Salary","Estimated Fringe Total","Estimated Hours ","Estimated Salary","Estimated Fringe Total"]
[null,null,null,null,null,null,null,{"$f":"ROUND(D10*G10,0)","v":0},{"$f":"ROUND(H10*F10,0)","v":0},null,{"$f":"ROUND(D10*J10,0)","v":0},{"$f":"ROUND(F10*K10,0)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"ROUND(H11*F11,0)","v":0},null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,0,0,null,0,0]
[null,null,null,null,null,null,null,{"$f":"ROUND(SUM(H10:H29),0)","v":0},{"$f":"ROUND(SUM(I10:I29),0)","v":0},null,{"$f":"ROUND(SUM(K10:K29),0)","v":0},{"$f":"ROUND(SUM(L10:L29),0)","v":0}]
[]
[null,"* Current hourly rate is the rate for each position when the contract starts."]
[]
[null,"** Projected highest hourly rate is the anticipated maximum rate for each position during the contract period."]

{"sheet":"Q1","index":3,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[24,7,24,8],[29,5,29,6],[27,9,27,10],[27,5,27,6],[23,5,23,6],[23,7,23,8],[26,5,26,6],[26,7,26,8],[29,9,29,10],[29,7,29,8],[23,9,23,10],[24,9,24,10],[24,5,24,6],[44,9,44,10],[52,9,52,10],[26,9,26,10],[31,5,31,6],[30,5,30,6],[28,9,28,10],[28,5,28,6],[28,7,28,8],[33,9,33,10],[34,9,34,10],[35,9,35,10],[27,7,27,8],[31,7,31,8],[30,9,30,10],[30,7,30,8],[41,9,41,10],[42,9,42,10],[43,9,43,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[31,9,31,10],[32,4,32,10],[25,9,25,10],[25,5,25,6],[25,7,25,8],[10,5,10,10],[4,4,4,10],[5,4,5,10],[6,4,6,10],[7,4,7,10],[9,5,9,10],[11,5,11,10],[12,5,12,10],[14,5,14,7],[14,9,14,10],[15,5,15,8],[21,7,21,8],[22,5,22,6],[21,5,21,6],[17,4,18,10],[19,9,19,10],[19,5,19,6],[22,9,22,10],[22,7,22,8],[21,9,21,10],[19,7,19,8],[20,5,20,6],[20,7,20,8],[20,9,20,10],[47,9,47,10],[72,12,72,14],[72,15,72,17],[72,5,72,6],[72,9,72,10],[72,7,72,8],[54,9,54,10],[62,4,64,10],[61,4,61,10],[57,9,57,10],[59,9,59,10],[65,7,65,8],[49,9,49,10]]}
[]
[]
[]
[]
[null,null,null,null,"MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY"]
[null,null,null,null,{"$f":"Budget!E6","v":"MATERIALS MANAGEMENT DIVISION - Recycling Unit"}]
[null,null,null,null,{"$f":"Budget!E7","v":"Recycling  Grant"}]
[null,null,null,null,{"$f":"Budget!E8","v":"FINANCIAL STATUS REPORT"}]
[]
[null,null,null,null,"Grantee / Vendor Name:",{"$f":"IF(Budget!F10 >0,Budget!F10,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Vendor Number:",{"$f":"IF(Budget!F11 >0,Budget!F11,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Project Name:",{"$f":"IF(Budget!F12 >0,Budget!F12,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Grant Given Number:",{"$f":"IF(Budget!F13 >0,Budget!F13,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Report Period:","From:",null,"To:"]
[null,null,null,null,"Contact Name:",{"$f":"IF(Budget!F15>0,Budget!F15,\"TBD\")","v":"TBD"},null,null,"Contact Number:",{"$f":"IF(Budget!J15>0,Budget!J15,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Contact Email:",{"$f":"IF(Budget!F16>0,Budget!F16,\"TBD\")","v":"TBD"}]
[]
[null,null,null,null,"EXPENDITURES\nList all expenditures for the report period and attach invoices from contractors and subcontractors"]
[]
[null,null,null,null,"Task/Item","Invoice Number",null,"Task Number",null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Progress Report"]
[null,null,null,null,"Task/Item","Expended this period","Expended to date","Project Budget","Balance to date","Activity this period"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H19,\" \",\"-\",\" \",Budget!E19)","v":" - "},{"$f":"SUMIF($H$21:$I$32,1,$J$21:$K$32)","v":0},{"$f":"F35","v":0},{"$f":"Budget!J19","v":0},{"$f":"H35-G35","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H20,\" \",\"-\",\" \",Budget!E20)","v":" - "},{"$f":"SUMIF($H$21:$I$32,2,$J$21:$K$32)","v":0},{"$f":"F36","v":0},{"$f":"Budget!J20","v":0},{"$f":"H36-G36","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H21,\" \",\"-\",\" \",Budget!E21)","v":" - "},{"$f":"SUMIF($H$21:$I$32,3,$J$21:$K$32)","v":0},{"$f":"F37","v":0},{"$f":"Budget!J21","v":0},{"$f":"H37-G37","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H22,\" \",\"-\",\" \",Budget!E22)","v":" - "},{"$f":"SUMIF($H$21:$I$32,4,$J$21:$K$32)","v":0},0,{"$f":"Budget!J22","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H23,\" \",\"-\",\" \",Budget!E23)","v":" - "},{"$f":"SUMIF($H$21:$I$32,5,$J$21:$K$32)","v":0},0,{"$f":"Budget!J23","v":0},0,null,null,"=F42"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H24,\" \",\"-\",\" \",Budget!E24)","v":" - "},{"$f":"SUMIF($H$21:$I$32,6,$J$21:$K$32)","v":0},0,{"$f":"Budget!J24","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H25,\" \",\"-\",\" \",Budget!E25)","v":" - "},{"$f":"SUMIF($H$21:$I$32,7,$J$21:$K$32)","v":0},0,{"$f":"Budget!J25","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H26,\" \",\"-\",\" \",Budget!E26)","v":" - "},{"$f":"SUMIF($H$21:$I$32,8,$J$21:$K$32)","v":0},0,{"$f":"Budget!J26","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H27,\" \",\"-\",\" \",Budget!E27)","v":" - "},{"$f":"SUMIF($H$21:$I$32,9,$J$21:$K$32)","v":0},0,{"$f":"Budget!J27","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H28,\" \",\"-\",\" \",Budget!E28)","v":" -  "},{"$f":"SUMIF($H$21:$I$32,10,$J$21:$K$32)","v":0},0,{"$f":"Budget!J28","v":0},0]
[null,null,null,null,"Task Subtotal",{"$f":"SUM(F35:F44)","v":0},{"$f":"SUM(G35:G44)","v":0},{"$f":"SUM(H35:H44)","v":0},{"$f":"SUM(I35:I44)","v":0}]
[]
[null,null,null,null,"INDIRECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F45*Budget!$I$32","v":0},{"$f":"G45*Budget!$I$32","v":0},{"$f":"H45*Budget!$I$32","v":0},{"$f":"I45*Budget!$I$32","v":0}]
[null,null,null,null,"PROJECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F48+F45","v":0},{"$f":"G48+G45","v":0},{"$f":"H48+H45","v":0},{"$f":"I48+I45","v":0}]
[]
[null,null,null,null,"MATCH AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",null,{"$f":"F53","v":0},{"$f":"(H45*Budget!$I$37)+(H48*Budget!$I$37)","v":0},{"$f":"H53-G53","v":0}]
[null,null,null,null,"GRANT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"(F45+F48)-F53","v":0},{"$f":"(G45+G48)-G53","v":0},{"$f":"(H45+H48)-H53","v":0},{"$f":"(I45+I48)-I53","v":0}]
[]
[null,null,null,null,"RENTENTION",{"$f":"Budget!F42","v":0.05}]
[null,null,null,null,"Total",{"$f":"F55*F57","v":0},{"$f":"G55*F57","v":0},{"$f":"H55*F57","v":0},{"$f":"H58-G58","v":0}]
[null,null,null,null,"REIMBURSMENT THIS PERIOD"]
[null,null,null,null,"Total",{"$f":"F55-F58","v":0},{"$f":"G55-G58","v":0},{"$f":"(H45+H48)-H53","v":0},{"$f":"H60-G60","v":0}]
[]
[null,null,null,null,"STATEMENT OF REVIEW AND APPROVAL"]
[null,null,null,null,"“By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant as paid. The grantee acknowledges that falsification of records may result in the termination of this grant contract and other appropriate legal remedies.”"]
[]
[]
[null,null,null,null,"Name:",null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"This Period",null,"Remaining Budget",null,"Remaining Balance",null,null,"GRANT",null,null,"MATCH"]
[null,null,null,null,"Contractor","Grant","Match","Grant","Match","Grant","Match",null,"Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period ","Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period "]
[null,null,null,null,{"$f":"IF(Budget!E51 = 0,\" \",Budget!E51)","v":" "},null,null,{"$f":"Budget!H51","v":0},{"$f":"Budget!J51","v":0},{"$f":"H75-F75","v":0},{"$f":"I75-G75","v":0},null,{"$f":"Budget!L51","v":0},{"$f":"IF(M75>0,M75-F75,0)","v":0},{"$f":"IF(N75>0,M75,M75)","v":0},{"$f":"Budget!M51","v":0},{"$f":"IF(P75>0,P75-G75,0)","v":0},{"$f":"IF(Q75>0,G75,P75)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E52 = 0,\" \",Budget!E52)","v":" "},null,null,{"$f":"Budget!H52","v":0},{"$f":"Budget!J52","v":0},{"$f":"H76-F76","v":0},{"$f":"I76-G76","v":0},null,{"$f":"Budget!L52","v":0},{"$f":"IF(M76>0,M76-F76,0)","v":0},{"$f":"IF(N76>0,F76,M76)","v":0},{"$f":"Budget!M52","v":0},{"$f":"IF(P76>0,P76-G76,0)","v":0},{"$f":"IF(Q76>0,G76,P76)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E53 = 0,\" \",Budget!E53)","v":" "},null,null,{"$f":"Budget!H53","v":0},{"$f":"Budget!J53","v":0},0,{"$f":"I77-G77","v":0},null,{"$f":"Budget!L53","v":0},0,0,{"$f":"Budget!M53","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E54 = 0,\" \",Budget!E54)","v":" "},null,null,{"$f":"Budget!H54","v":0},{"$f":"Budget!J54","v":0},0,0,null,{"$f":"Budget!L54","v":0},0,0,{"$f":"Budget!M54","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E55 = 0,\" \",Budget!E55)","v":" "},null,null,{"$f":"Budget!H55","v":0},{"$f":"Budget!J55","v":0},0,0,null,{"$f":"Budget!L55","v":0},0,0,{"$f":"Budget!M55","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E56 = 0,\" \",Budget!E56)","v":" "},null,null,{"$f":"Budget!H56","v":0},{"$f":"Budget!J56","v":0},0,0,null,{"$f":"Budget!L56","v":0},0,0,{"$f":"Budget!M56","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E57 = 0,\" \",Budget!E57)","v":" "},null,null,{"$f":"Budget!H57","v":0},{"$f":"Budget!J57","v":0},0,0,null,{"$f":"Budget!L57","v":0},0,0,{"$f":"Budget!M57","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E58 = 0,\" \",Budget!E58)","v":" "},null,null,{"$f":"Budget!H58","v":0},{"$f":"Budget!J58","v":0},0,0,null,{"$f":"Budget!L58","v":0},0,0,{"$f":"Budget!M58","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E59 = 0,\" \",Budget!E59)","v":" "},null,null,{"$f":"Budget!H59","v":0},{"$f":"Budget!J59","v":0},0,0,null,{"$f":"Budget!L59","v":0},0,0,{"$f":"Budget!M59","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E60 = 0,\" \",Budget!E60)","v":" "},null,null,{"$f":"Budget!H60","v":0},{"$f":"Budget!J60","v":0},0,0,null,{"$f":"Budget!L60","v":0},0,0,{"$f":"Budget!M60","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E61 = 0,\" \",Budget!E61)","v":" "},null,null,{"$f":"Budget!H61","v":0},{"$f":"Budget!J61","v":0},0,0,null,{"$f":"Budget!L61","v":0},0,0,{"$f":"Budget!M61","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E62 = 0,\" \",Budget!E62)","v":" "},null,null,{"$f":"Budget!H62","v":0},{"$f":"Budget!J62","v":0},0,0,null,{"$f":"Budget!L62","v":0},0,0,{"$f":"Budget!M62","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E63 = 0,\" \",Budget!E63)","v":" "},null,null,{"$f":"Budget!H63","v":0},{"$f":"Budget!J63","v":0},0,0,null,{"$f":"Budget!L63","v":0},0,0,{"$f":"Budget!M63","v":0},0,0]
[null,null,null,null,"TOTAL",{"$f":"SUM(F75:F87)","v":0},0,0,0,0,0,null,{"$f":"SUM(M75:M87)","v":0},0,0,0,0,0]

{"sheet":"Q2","index":4,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[35,9,35,10],[44,9,44,10],[52,9,52,10],[54,9,54,10],[61,4,61,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[47,9,47,10],[57,9,57,10],[59,9,59,10],[34,9,34,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,5,30,6],[30,7,30,8],[30,9,30,10],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,4,32,10],[33,9,33,10],[27,5,27,6],[27,7,27,8],[27,9,27,10],[28,5,28,6],[28,7,28,8],[28,9,28,10],[25,5,25,6],[25,7,25,8],[25,9,25,10],[26,5,26,6],[26,7,26,8],[26,9,26,10],[23,5,23,6],[23,7,23,8],[23,9,23,10],[24,5,24,6],[24,7,24,8],[24,9,24,10],[21,5,21,6],[21,7,21,8],[21,9,21,10],[22,5,22,6],[22,7,22,8],[22,9,22,10],[19,7,19,8],[19,9,19,10],[20,5,20,6],[20,7,20,8],[20,9,20,10],[72,12,72,14],[68,14,68,15],[72,15,72,17],[17,4,18,10],[4,4,4,10],[5,4,5,10],[6,4,6,10],[7,4,7,10],[9,5,9,10],[10,5,10,10],[11,5,11,10],[12,5,12,10],[14,5,14,7],[14,9,14,10],[15,5,15,8],[19,5,19,6],[49,9,49,10],[65,7,65,8],[62,4,64,10],[72,5,72,6],[72,7,72,8],[72,9,72,10]]}
[]
[]
[]
[]
[null,null,null,null,"MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY"]
[null,null,null,null,{"$f":"Budget!E6","v":"MATERIALS MANAGEMENT DIVISION - Recycling Unit"}]
[null,null,null,null,{"$f":"Budget!E7","v":"Recycling  Grant"}]
[null,null,null,null,{"$f":"Budget!E8","v":"FINANCIAL STATUS REPORT"}]
[]
[null,null,null,null,"Grantee / Vendor Name:",{"$f":"IF(Budget!F10 >0,Budget!F10,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Vendor Number:",{"$f":"IF(Budget!F11 >0,Budget!F11,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Project Name:",{"$f":"IF(Budget!F12 >0,Budget!F12,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Grant Given Number:",{"$f":"IF(Budget!F13 >0,Budget!F13,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Report Period:","From:",null,"To:"]
[null,null,null,null,"Contact Name:",{"$f":"IF(Budget!F15>0,Budget!F15,\"TBD\")","v":"TBD"},null,null,"Contact Number:",{"$f":"IF(Budget!J15>0,Budget!J15,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Contact Email:",{"$f":"IF(Budget!F16>0,Budget!F16,\"TBD\")","v":"TBD"}]
[]
[null,null,null,null,"EXPENDITURES\nList all expenditures for the report period and attach invoices from contractors and subcontractors"]
[]
[null,null,null,null,"Task","Invoice Number",null,"Task Number",null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Progress Report"]
[null,null,null,null,"Task","Expended this period","Expended to date","Project Budget","Balance to date","Activity this period"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H19,\" \",\"-\",\" \",Budget!E19)","v":" - "},{"$f":"SUMIF($H$21:$I$32,1,$J$21:$K$32)","v":0},{"$f":"F35+'Q1'!G35","v":0},{"$f":"'Q1'!H35","v":0},{"$f":"H35-G35","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H20,\" \",\"-\",\" \",Budget!E20)","v":" - "},{"$f":"SUMIF($H$21:$I$32,2,$J$21:$K$32)","v":0},{"$f":"F36+'Q1'!G36","v":0},{"$f":"'Q1'!H36","v":0},{"$f":"H36-G36","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H21,\" \",\"-\",\" \",Budget!E21)","v":" - "},{"$f":"SUMIF($H$21:$I$32,3,$J$21:$K$32)","v":0},{"$f":"F37+'Q1'!G37","v":0},{"$f":"'Q1'!H37","v":0},{"$f":"H37-G37","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H22,\" \",\"-\",\" \",Budget!E22)","v":" - "},{"$f":"SUMIF($H$21:$I$32,4,$J$21:$K$32)","v":0},{"$f":"F38+'Q1'!G38","v":0},{"$f":"'Q1'!H38","v":0},{"$f":"H38-G38","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H23,\" \",\"-\",\" \",Budget!E23)","v":" - "},{"$f":"SUMIF($H$21:$I$32,5,$J$21:$K$32)","v":0},{"$f":"F39+'Q1'!G39","v":0},{"$f":"'Q1'!H39","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H24,\" \",\"-\",\" \",Budget!E24)","v":" - "},{"$f":"SUMIF($H$21:$I$32,6,$J$21:$K$32)","v":0},{"$f":"F40+'Q1'!G40","v":0},{"$f":"'Q1'!H40","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H25,\" \",\"-\",\" \",Budget!E25)","v":" - "},{"$f":"SUMIF($H$21:$I$32,7,$J$21:$K$32)","v":0},{"$f":"F41+'Q1'!G41","v":0},{"$f":"'Q1'!H41","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H26,\" \",\"-\",\" \",Budget!E26)","v":" - "},{"$f":"SUMIF($H$21:$I$32,8,$J$21:$K$32)","v":0},{"$f":"F42+'Q1'!G42","v":0},{"$f":"'Q1'!H42","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H27,\" \",\"-\",\" \",Budget!E27)","v":" - "},{"$f":"SUMIF($H$21:$I$32,9,$J$21:$K$32)","v":0},{"$f":"F43+'Q1'!G43","v":0},{"$f":"'Q1'!H43","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H28,\" \",\"-\",\" \",Budget!E28)","v":" -  "},{"$f":"SUMIF($H$21:$I$32,10,$J$21:$K$32)","v":0},{"$f":"F44+'Q1'!G44","v":0},{"$f":"'Q1'!H44","v":0},0]
[null,null,null,null,"Task Subtotal",{"$f":"SUM(F35:F44)","v":0},{"$f":"SUM(G35:G44)","v":0},{"$f":"SUM(H35:H44)","v":0},{"$f":"SUM(I35:I44)","v":0}]
[]
[null,null,null,null,"INDIRECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F45*Budget!$I$32","v":0},{"$f":"G45*Budget!$I$32","v":0},{"$f":"H45*Budget!$I$32","v":0},{"$f":"I45*Budget!$I$32","v":0}]
[null,null,null,null,"PROJECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F48+F43","v":0},{"$f":"G48+G43","v":0},0,0]
[]
[null,null,null,null,"MATCH AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",null,{"$f":"F53+'Q1'!G53","v":0},{"$f":"(H45*Budget!$I$37)+(H48*Budget!$I$37)","v":0},{"$f":"H53-G53","v":0}]
[null,null,null,null,"GRANT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"(F45+F48)-F53","v":0},0,{"$f":"(H45+H48)-H53","v":0},{"$f":"(I45+I48)-I53","v":0}]
[]
[null,null,null,null,"RENTENTION",{"$f":"'Q1'!F57","v":0.05}]
[null,null,null,null,"Total",{"$f":"F55*F57","v":0},{"$f":"G55*F57","v":0},{"$f":"H55*F57","v":0},{"$f":"H58-G58","v":0}]
[null,null,null,null,"REIMBURSMENT THIS PERIOD"]
[null,null,null,null,"Total",{"$f":"F55-F58","v":0},{"$f":"G55-G58","v":0},{"$f":"(H45+H48)-H53","v":0},{"$f":"H60-G60","v":0}]
[]
[null,null,null,null,"STATEMENT OF REVIEW AND APPROVAL"]
[null,null,null,null,"“By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant as paid. The grantee acknowledges that falsification of records may result in the termination of this grant contract and other appropriate legal remedies.”"]
[]
[]
[null,null,null,null,"Name:",null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"This Period",null,"Remaining Budget",null,"Remaining Balance",null,null,"GRANT",null,null,"MATCH"]
[null,null,null,null,"Contractor","Grant","Match","Grant","Match","Grant","Match",null,"Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period ","Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period "]
[null,null,null,null,{"$f":"IF(Budget!E51 = 0,\" \",Budget!E51)","v":" "},null,null,{"$f":"'Q1'!J75","v":0},{"$f":"'Q1'!K75","v":0},{"$f":"H75-F75","v":0},{"$f":"I75-G75","v":0},null,{"$f":"IF('Q1'!N75>0,'Q1'!N75,0)","v":0},{"$f":"IF(M75>0,M75-F75,0)","v":0},{"$f":"IF(M75>0,F75,M75)","v":0},{"$f":"IF('Q1'!Q75>0,'Q1'!Q75,0)","v":0},{"$f":"IF(P75>0,P75-G75,0)","v":0},{"$f":"IF(Q75>0,G75,P75)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E52 = 0,\" \",Budget!E52)","v":" "},null,null,{"$f":"'Q1'!J76","v":0},{"$f":"'Q1'!K76","v":0},{"$f":"H76-F76","v":0},{"$f":"I76-G76","v":0},null,{"$f":"IF('Q1'!N76>0,'Q1'!N76,0)","v":0},{"$f":"IF(M76>0,M76-F76,0)","v":0},{"$f":"IF(M76>0,F76,M76)","v":0},{"$f":"IF('Q1'!Q76>0,'Q1'!Q76,0)","v":0},{"$f":"IF(P76>0,P76-G76,0)","v":0},{"$f":"IF(Q76>0,G76,P76)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E53 = 0,\" \",Budget!E53)","v":" "},null,null,{"$f":"'Q1'!J77","v":0},{"$f":"'Q1'!K77","v":0},0,0,null,{"$f":"IF('Q1'!N77>0,'Q1'!N77,0)","v":0},0,0,{"$f":"IF('Q1'!Q77>0,'Q1'!Q77,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E54 = 0,\" \",Budget!E54)","v":" "},null,null,{"$f":"'Q1'!J78","v":0},{"$f":"'Q1'!K78","v":0},0,0,null,{"$f":"IF('Q1'!N78>0,'Q1'!N78,0)","v":0},0,0,{"$f":"IF('Q1'!Q78>0,'Q1'!Q78,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E55 = 0,\" \",Budget!E55)","v":" "},null,null,{"$f":"'Q1'!J79","v":0},{"$f":"'Q1'!K79","v":0},0,0,null,{"$f":"IF('Q1'!N79>0,'Q1'!N79,0)","v":0},0,0,{"$f":"IF('Q1'!Q79>0,'Q1'!Q79,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E56 = 0,\" \",Budget!E56)","v":" "},null,null,{"$f":"'Q1'!J80","v":0},{"$f":"'Q1'!K80","v":0},0,0,null,{"$f":"IF('Q1'!N80>0,'Q1'!N80,0)","v":0},0,0,{"$f":"IF('Q1'!Q80>0,'Q1'!Q80,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E57 = 0,\" \",Budget!E57)","v":" "},null,null,{"$f":"'Q1'!J81","v":0},{"$f":"'Q1'!K81","v":0},0,0,null,{"$f":"IF('Q1'!N81>0,'Q1'!N81,0)","v":0},0,0,{"$f":"IF('Q1'!Q81>0,'Q1'!Q81,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E58 = 0,\" \",Budget!E58)","v":" "},null,null,{"$f":"'Q1'!J82","v":0},{"$f":"'Q1'!K82","v":0},0,0,null,{"$f":"IF('Q1'!N82>0,'Q1'!N82,0)","v":0},0,0,{"$f":"IF('Q1'!Q82>0,'Q1'!Q82,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E59 = 0,\" \",Budget!E59)","v":" "},null,null,{"$f":"'Q1'!J83","v":0},{"$f":"'Q1'!K83","v":0},0,0,null,{"$f":"IF('Q1'!N83>0,'Q1'!N83,0)","v":0},0,0,{"$f":"IF('Q1'!Q83>0,'Q1'!Q83,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E60 = 0,\" \",Budget!E60)","v":" "},null,null,{"$f":"'Q1'!J84","v":0},{"$f":"'Q1'!K84","v":0},0,0,null,{"$f":"IF('Q1'!N84>0,'Q1'!N84,0)","v":0},0,0,{"$f":"IF('Q1'!Q84>0,'Q1'!Q84,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E61 = 0,\" \",Budget!E61)","v":" "},null,null,{"$f":"'Q1'!J85","v":0},{"$f":"'Q1'!K85","v":0},0,0,null,{"$f":"IF('Q1'!N85>0,'Q1'!N85,0)","v":0},0,0,{"$f":"IF('Q1'!Q85>0,'Q1'!Q85,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E62 = 0,\" \",Budget!E62)","v":" "},null,null,{"$f":"'Q1'!J86","v":0},{"$f":"'Q1'!K86","v":0},0,0,null,{"$f":"IF('Q1'!N86>0,'Q1'!N86,0)","v":0},0,0,{"$f":"IF('Q1'!Q86>0,'Q1'!Q86,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E63 = 0,\" \",Budget!E63)","v":" "},null,null,{"$f":"'Q1'!J87","v":0},{"$f":"'Q1'!K87","v":0},0,0,null,{"$f":"IF('Q1'!N87>0,'Q1'!N87,0)","v":0},0,0,{"$f":"IF('Q1'!Q87>0,'Q1'!Q87,0)","v":0},0,0]
[null,null,null,null,"TOTAL",{"$f":"SUM(F75:F87)","v":0},0,0,0,0,0,null,{"$f":"SUM(M75:M87)","v":0},0,0,0,0,0]

{"sheet":"Q3","index":5,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[28,5,28,6],[28,7,28,8],[28,9,28,10],[43,9,43,10],[42,9,42,10],[33,9,33,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[47,9,47,10],[34,9,34,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,5,30,6],[30,7,30,8],[30,9,30,10],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,4,32,10],[41,9,41,10],[44,9,44,10],[26,5,26,6],[26,7,26,8],[26,9,26,10],[27,5,27,6],[27,7,27,8],[27,9,27,10],[24,5,24,6],[24,7,24,8],[24,9,24,10],[25,5,25,6],[25,7,25,8],[25,9,25,10],[22,5,22,6],[22,7,22,8],[22,9,22,10],[23,5,23,6],[23,7,23,8],[23,9,23,10],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,5,21,6],[21,7,21,8],[21,9,21,10],[72,15,72,17],[17,4,18,10],[4,4,4,10],[5,4,5,10],[6,4,6,10],[7,4,7,10],[9,5,9,10],[10,5,10,10],[11,5,11,10],[12,5,12,10],[14,5,14,7],[14,9,14,10],[15,5,15,8],[19,5,19,6],[19,7,19,8],[19,9,19,10],[49,9,49,10],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,12,72,14],[57,9,57,10],[59,9,59,10],[65,7,65,8],[52,9,52,10],[54,9,54,10],[61,4,61,10],[62,4,64,10]]}
[]
[]
[]
[]
[null,null,null,null,"MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY"]
[null,null,null,null,{"$f":"Budget!E6","v":"MATERIALS MANAGEMENT DIVISION - Recycling Unit"}]
[null,null,null,null,{"$f":"Budget!E7","v":"Recycling  Grant"}]
[null,null,null,null,{"$f":"Budget!E8","v":"FINANCIAL STATUS REPORT"}]
[]
[null,null,null,null,"Grantee / Vendor Name:",{"$f":"IF(Budget!F10 >0,Budget!F10,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Vendor Number:",{"$f":"IF(Budget!F11 >0,Budget!F11,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Project Name:",{"$f":"IF(Budget!F12 >0,Budget!F12,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Grant Given Number:",{"$f":"IF(Budget!F13 >0,Budget!F13,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Report Period:","From:",null,"To:"]
[null,null,null,null,"Contact Name:",{"$f":"IF(Budget!F15>0,Budget!F15,\"TBD\")","v":"TBD"},null,null,"Contact Number:",{"$f":"IF(Budget!J15>0,Budget!J15,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Contact Email:",{"$f":"IF(Budget!F16>0,Budget!F16,\"TBD\")","v":"TBD"}]
[]
[null,null,null,null,"EXPENDITURES\nList all expenditures for the report period and attach invoices from contractors and subcontractors"]
[]
[null,null,null,null,"Task","Invoice Number",null,"Task Number",null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Progress Report"]
[null,null,null,null,"Task","Expended this period","Expended to date","Project Budget","Balance to date","Activity this period"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H19,\" \",\"-\",\" \",Budget!E19)","v":" - "},{"$f":"SUMIF($H$21:$I$32,1,$J$21:$K$32)","v":0},{"$f":"F35+'Q2'!G35","v":0},{"$f":"'Q2'!H35","v":0},{"$f":"H35-G35","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H20,\" \",\"-\",\" \",Budget!E20)","v":" - "},{"$f":"SUMIF($H$21:$I$32,2,$J$21:$K$32)","v":0},{"$f":"F36+'Q2'!G36","v":0},{"$f":"'Q2'!H36","v":0},{"$f":"H36-G36","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H21,\" \",\"-\",\" \",Budget!E21)","v":" - "},{"$f":"SUMIF($H$21:$I$32,3,$J$21:$K$32)","v":0},{"$f":"F37+'Q2'!G37","v":0},{"$f":"'Q2'!H37","v":0},{"$f":"H37-G37","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H22,\" \",\"-\",\" \",Budget!E22)","v":" - "},{"$f":"SUMIF($H$21:$I$32,4,$J$21:$K$32)","v":0},{"$f":"F38+'Q2'!G38","v":0},{"$f":"'Q2'!H38","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H23,\" \",\"-\",\" \",Budget!E23)","v":" - "},{"$f":"SUMIF($H$21:$I$32,5,$J$21:$K$32)","v":0},{"$f":"F39+'Q2'!G39","v":0},{"$f":"'Q2'!H39","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H24,\" \",\"-\",\" \",Budget!E24)","v":" - "},{"$f":"SUMIF($H$21:$I$32,6,$J$21:$K$32)","v":0},{"$f":"F40+'Q2'!G40","v":0},{"$f":"'Q2'!H40","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H25,\" \",\"-\",\" \",Budget!E25)","v":" - "},{"$f":"SUMIF($H$21:$I$32,7,$J$21:$K$32)","v":0},{"$f":"F41+'Q2'!G41","v":0},{"$f":"'Q2'!H41","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H26,\" \",\"-\",\" \",Budget!E26)","v":" - "},{"$f":"SUMIF($H$21:$I$32,8,$J$21:$K$32)","v":0},{"$f":"F42+'Q2'!G42","v":0},{"$f":"'Q2'!H42","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H27,\" \",\"-\",\" \",Budget!E27)","v":" - "},{"$f":"SUMIF($H$21:$I$32,9,$J$21:$K$32)","v":0},{"$f":"F43+'Q2'!G43","v":0},{"$f":"'Q2'!H43","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H28,\" \",\"-\",\" \",Budget!E28)","v":" -  "},{"$f":"SUMIF($H$21:$I$32,10,$J$21:$K$32)","v":0},{"$f":"F44+'Q2'!G44","v":0},{"$f":"'Q2'!H44","v":0},0]
[null,null,null,null,"Task Subtotal",{"$f":"SUM(F35:F44)","v":0},{"$f":"SUM(G35:G44)","v":0},{"$f":"SUM(H35:H44)","v":0},{"$f":"SUM(I35:I44)","v":0}]
[]
[null,null,null,null,"INDIRECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F45*Budget!$I$32","v":0},{"$f":"G45*Budget!$I$32","v":0},{"$f":"H45*Budget!$I$32","v":0},{"$f":"I45*Budget!$I$32","v":0}]
[null,null,null,null,"PROJECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F48+F43","v":0},{"$f":"G48+G43","v":0},0,0]
[]
[null,null,null,null,"MATCH AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",null,{"$f":"F53+'Q2'!G53","v":0},{"$f":"(H45*Budget!$I$37)+(H48*Budget!$I$37)","v":0},{"$f":"(I45*Budget!$I$37)+(I48*Budget!$I$37)","v":0}]
[null,null,null,null,"GRANT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"(F45+F48)-F53","v":0},0,{"$f":"(H45+H48)-H53","v":0},{"$f":"(I45+I48)-I53","v":0}]
[]
[null,null,null,null,"RENTENTION",{"$f":"'Q2'!F57","v":0.05}]
[null,null,null,null,"Total",{"$f":"F55*F57","v":0},{"$f":"G55*F57","v":0},{"$f":"H55*F57","v":0},{"$f":"H58-G58","v":0}]
[null,null,null,null,"REIMBURSMENT THIS PERIOD"]
[null,null,null,null,"Total",{"$f":"F55-F58","v":0},{"$f":"G55-G58","v":0},{"$f":"(H45+H48)-H53","v":0},{"$f":"H60-G60","v":0}]
[]
[null,null,null,null,"STATEMENT OF REVIEW AND APPROVAL"]
[null,null,null,null,"“By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant as paid. The grantee acknowledges that falsification of records may result in the termination of this grant contract and other appropriate legal remedies.”"]
[]
[]
[null,null,null,null,"Name:",null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"This Period",null,"Remaining Budget",null,"Remaining Balance",null,null,"GRANT",null,null,"MATCH"]
[null,null,null,null,"Contractor","Grant","Match","Grant","Match","Grant","Match",null,"Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period ","Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period "]
[null,null,null,null,{"$f":"IF(Budget!E51 = 0,\" \",Budget!E51)","v":" "},null,null,{"$f":"'Q2'!J75","v":0},{"$f":"'Q2'!K75","v":0},{"$f":"H75-F75","v":0},{"$f":"I75-G75","v":0},null,{"$f":"IF('Q2'!N75>0,'Q2'!N75,0)","v":0},{"$f":" IF(M75>0,M75-F75,0)","v":0},{"$f":"IF(M75>0,F75,M75)","v":0},{"$f":"IF('Q2'!Q75>0,'Q2'!Q75,0)","v":0},{"$f":"IF(P75>0,P75-G75,0)","v":0},{"$f":"IF(Q75>0,G75,P75)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E52 = 0,\" \",Budget!E52)","v":" "},null,null,{"$f":"'Q2'!J76","v":0},{"$f":"'Q2'!K76","v":0},{"$f":"H76-F76","v":0},{"$f":"I76-G76","v":0},null,{"$f":"IF('Q2'!N76>0,'Q2'!N76,0)","v":0},{"$f":" IF(M76>0,M76-F76,0)","v":0},{"$f":"IF(M76>0,F76,M76)","v":0},{"$f":"IF('Q2'!Q76>0,'Q2'!Q76,0)","v":0},{"$f":"IF(P76>0,P76-G76,0)","v":0},{"$f":"IF(Q76>0,G76,P76)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E53 = 0,\" \",Budget!E53)","v":" "},null,null,{"$f":"'Q2'!J77","v":0},{"$f":"'Q2'!K77","v":0},0,0,null,{"$f":"IF('Q2'!N77>0,'Q2'!N77,0)","v":0},0,0,{"$f":"IF('Q2'!Q77>0,'Q2'!Q77,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E54 = 0,\" \",Budget!E54)","v":" "},null,null,{"$f":"'Q2'!J78","v":0},{"$f":"'Q2'!K78","v":0},0,0,null,{"$f":"IF('Q2'!N78>0,'Q2'!N78,0)","v":0},0,0,{"$f":"IF('Q2'!Q78>0,'Q2'!Q78,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E55 = 0,\" \",Budget!E55)","v":" "},null,null,{"$f":"'Q2'!J79","v":0},{"$f":"'Q2'!K79","v":0},0,0,null,{"$f":"IF('Q2'!N79>0,'Q2'!N79,0)","v":0},0,0,{"$f":"IF('Q2'!Q79>0,'Q2'!Q79,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E56 = 0,\" \",Budget!E56)","v":" "},null,null,{"$f":"'Q2'!J80","v":0},{"$f":"'Q2'!K80","v":0},0,0,null,{"$f":"IF('Q2'!N80>0,'Q2'!N80,0)","v":0},0,0,{"$f":"IF('Q2'!Q80>0,'Q2'!Q80,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E57 = 0,\" \",Budget!E57)","v":" "},null,null,{"$f":"'Q2'!J81","v":0},{"$f":"'Q2'!K81","v":0},0,0,null,{"$f":"IF('Q2'!N81>0,'Q2'!N81,0)","v":0},0,0,{"$f":"IF('Q2'!Q81>0,'Q2'!Q81,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E58 = 0,\" \",Budget!E58)","v":" "},null,null,{"$f":"'Q2'!J82","v":0},{"$f":"'Q2'!K82","v":0},0,0,null,{"$f":"IF('Q2'!N82>0,'Q2'!N82,0)","v":0},0,0,{"$f":"IF('Q2'!Q82>0,'Q2'!Q82,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E59 = 0,\" \",Budget!E59)","v":" "},null,null,{"$f":"'Q2'!J83","v":0},{"$f":"'Q2'!K83","v":0},0,0,null,{"$f":"IF('Q2'!N83>0,'Q2'!N83,0)","v":0},0,0,{"$f":"IF('Q2'!Q83>0,'Q2'!Q83,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E60 = 0,\" \",Budget!E60)","v":" "},null,null,{"$f":"'Q2'!J84","v":0},{"$f":"'Q2'!K84","v":0},0,0,null,{"$f":"IF('Q2'!N84>0,'Q2'!N84,0)","v":0},0,0,{"$f":"IF('Q2'!Q84>0,'Q2'!Q84,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E61 = 0,\" \",Budget!E61)","v":" "},null,null,{"$f":"'Q2'!J85","v":0},{"$f":"'Q2'!K85","v":0},0,0,null,{"$f":"IF('Q2'!N85>0,'Q2'!N85,0)","v":0},0,0,{"$f":"IF('Q2'!Q85>0,'Q2'!Q85,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E62 = 0,\" \",Budget!E62)","v":" "},null,null,{"$f":"'Q2'!J86","v":0},{"$f":"'Q2'!K86","v":0},0,0,null,{"$f":"IF('Q2'!N86>0,'Q2'!N86,0)","v":0},0,0,{"$f":"IF('Q2'!Q86>0,'Q2'!Q86,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E63 = 0,\" \",Budget!E63)","v":" "},null,null,{"$f":"'Q2'!J87","v":0},{"$f":"'Q2'!K87","v":0},0,0,null,{"$f":"IF('Q1'!N87>0,'Q1'!N87,0)","v":0},0,0,{"$f":"IF('Q2'!Q87>0,'Q2'!Q87,0)","v":0},0,0]
[null,null,null,null,"TOTAL",null,null,{"$f":"'Q2'!J88","v":0},{"$f":"'Q2'!K88","v":0},{"$f":"H88-F88","v":0},{"$f":"I88-G88","v":0},null,{"$f":"SUM(M75:M87)","v":0},0,0,0,0,0]

{"sheet":"Q4","index":6,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[35,9,35,10],[44,9,44,10],[52,9,52,10],[54,9,54,10],[61,4,61,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[57,9,57,10],[59,9,59,10],[34,9,34,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,5,30,6],[30,7,30,8],[30,9,30,10],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,4,32,10],[33,9,33,10],[27,5,27,6],[27,7,27,8],[27,9,27,10],[28,5,28,6],[28,7,28,8],[28,9,28,10],[25,5,25,6],[25,7,25,8],[25,9,25,10],[26,5,26,6],[26,7,26,8],[26,9,26,10],[23,5,23,6],[23,7,23,8],[23,9,23,10],[24,5,24,6],[24,7,24,8],[24,9,24,10],[21,5,21,6],[21,7,21,8],[21,9,21,10],[22,5,22,6],[22,7,22,8],[22,9,22,10],[19,5,19,6],[19,7,19,8],[19,9,19,10],[20,5,20,6],[20,7,20,8],[20,9,20,10],[17,4,18,10],[4,4,4,10],[5,4,5,10],[6,4,6,10],[7,4,7,10],[9,5,9,10],[10,5,10,10],[11,5,11,10],[12,5,12,10],[14,5,14,7],[14,9,14,10],[15,5,15,8],[88,22,88,23],[47,9,47,10],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,12,72,14],[72,15,72,17],[65,7,65,8],[62,4,64,10],[49,9,49,10]]}
[]
[]
[]
[]
[null,null,null,null,"MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY"]
[null,null,null,null,{"$f":"Budget!E6","v":"MATERIALS MANAGEMENT DIVISION - Recycling Unit"}]
[null,null,null,null,{"$f":"Budget!E7","v":"Recycling  Grant"}]
[null,null,null,null,{"$f":"Budget!E8","v":"FINANCIAL STATUS REPORT"}]
[]
[null,null,null,null,"Grantee / Vendor Name:",{"$f":"IF(Budget!F10 >0,Budget!F10,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Vendor Number:",{"$f":"IF(Budget!F11 >0,Budget!F11,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Project Name:",{"$f":"IF(Budget!F12 >0,Budget!F12,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Grant Given Number:",{"$f":"IF(Budget!F13 >0,Budget!F13,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Report Period:","From:",null,"To:"]
[null,null,null,null,"Contact Name:",{"$f":"IF(Budget!F15>0,Budget!F15,\"TBD\")","v":"TBD"},null,null,"Contact Number:",{"$f":"IF(Budget!J15>0,Budget!J15,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Contact Email:",{"$f":"IF(Budget!F16>0,Budget!F16,\"TBD\")","v":"TBD"}]
[]
[null,null,null,null,"EXPENDITURES\nList all expenditures for the report period and attach invoices from contractors and subcontractors"]
[]
[null,null,null,null,"Task","Invoice Number",null,"Task Number",null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Progress Report"]
[null,null,null,null,"Task","Expended this period","Expended to date","Project Budget","Balance to date","Activity this period"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H19,\" \",\"-\",\" \",Budget!E19)","v":" - "},{"$f":"SUMIF($H$21:$I$32,1,$J$21:$K$32)","v":0},{"$f":"F35+'Q3'!G35","v":0},{"$f":"'Q3'!H35","v":0},{"$f":"H35-G35","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H20,\" \",\"-\",\" \",Budget!E20)","v":" - "},{"$f":"SUMIF($H$21:$I$32,2,$J$21:$K$32)","v":0},{"$f":"F36+'Q3'!G36","v":0},{"$f":"'Q3'!H36","v":0},{"$f":"H36-G36","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H21,\" \",\"-\",\" \",Budget!E21)","v":" - "},{"$f":"SUMIF($H$21:$I$32,3,$J$21:$K$32)","v":0},{"$f":"F37+'Q3'!G37","v":0},{"$f":"'Q3'!H37","v":0},{"$f":"H37-G37","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H22,\" \",\"-\",\" \",Budget!E22)","v":" - "},{"$f":"SUMIF($H$21:$I$32,4,$J$21:$K$32)","v":0},{"$f":"F38+'Q3'!G38","v":0},{"$f":"'Q3'!H38","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H23,\" \",\"-\",\" \",Budget!E23)","v":" - "},{"$f":"SUMIF($H$21:$I$32,5,$J$21:$K$32)","v":0},{"$f":"F39+'Q3'!G39","v":0},{"$f":"'Q3'!H39","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H24,\" \",\"-\",\" \",Budget!E24)","v":" - "},{"$f":"SUMIF($H$21:$I$32,6,$J$21:$K$32)","v":0},{"$f":"F40+'Q3'!G40","v":0},{"$f":"'Q3'!H40","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H25,\" \",\"-\",\" \",Budget!E25)","v":" - "},{"$f":"SUMIF($H$21:$I$32,7,$J$21:$K$32)","v":0},{"$f":"F41+'Q3'!G41","v":0},{"$f":"'Q3'!H41","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H26,\" \",\"-\",\" \",Budget!E26)","v":" - "},{"$f":"SUMIF($H$21:$I$32,8,$J$21:$K$32)","v":0},{"$f":"F42+'Q3'!G42","v":0},{"$f":"'Q3'!H42","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H27,\" \",\"-\",\" \",Budget!E27)","v":" - "},{"$f":"SUMIF($H$21:$I$32,9,$J$21:$K$32)","v":0},{"$f":"F43+'Q3'!G43","v":0},{"$f":"'Q3'!H43","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H28,\" \",\"-\",\" \",Budget!E28)","v":" -  "},{"$f":"SUMIF($H$21:$I$32,10,$J$21:$K$32)","v":0},{"$f":"F44+'Q3'!G44","v":0},{"$f":"'Q3'!H44","v":0},0]
[null,null,null,null,"Task Subtotal",{"$f":"SUM(F35:F44)","v":0},{"$f":"SUM(G35:G44)","v":0},{"$f":"SUM(H35:H44)","v":0},0]
[]
[null,null,null,null,"INDIRECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F45*Budget!$I$32","v":0},{"$f":"G45*Budget!$I$32","v":0},{"$f":"H45*Budget!$I$32","v":0},{"$f":"I45*Budget!$I$32","v":0}]
[null,null,null,null,"PROJECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F48+F43","v":0},{"$f":"G48+G43","v":0},0,0]
[]
[null,null,null,null,"MATCH AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",null,{"$f":"F53+'Q3'!G53","v":0},{"$f":"(H45*Budget!$I$37)+(H48*Budget!$I$37)","v":0},{"$f":"(I45*Budget!$I$37)+(I48*Budget!$I$37)","v":0}]
[null,null,null,null,"GRANT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"(F45+F48)-F53","v":0},0,{"$f":"(H45+H48)-H53","v":0},{"$f":"(I45+I48)-I53","v":0}]
[]
[null,null,null,null,"RENTENTION",{"$f":"'Q3'!F57","v":0.05}]
[null,null,null,null,"Total",{"$f":"F55*F57","v":0},{"$f":"G55*F57","v":0},{"$f":"H55*F57","v":0},{"$f":"H58-G58","v":0}]
[null,null,null,null,"REIMBURSMENT THIS PERIOD"]
[null,null,null,null,"Total",{"$f":"F55-F58","v":0},{"$f":"G55-G58","v":0},{"$f":"(H45+H48)-H53","v":0},{"$f":"H60-G60","v":0}]
[]
[null,null,null,null,"STATEMENT OF REVIEW AND APPROVAL"]
[null,null,null,null,"“By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant as paid. The grantee acknowledges that falsification of records may result in the termination of this grant contract and other appropriate legal remedies.”"]
[]
[]
[null,null,null,null,"Name:",null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"This Period",null,"Remaining Budget",null,"Remaining Balance",null,null,"GRANT",null,null,"MATCH"]
[null,null,null,null,"Contractor","Grant","Match","Grant","Match","Grant","Match",null,"Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period ","Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period "]
[null,null,null,null,{"$f":"IF(Budget!E51 = 0,\" \",Budget!E51)","v":" "},null,null,{"$f":"'Q3'!J75","v":0},{"$f":"'Q3'!K75","v":0},{"$f":"H75-F75","v":0},{"$f":"I75-G75","v":0},null,{"$f":"IF('Q3'!N75>0,'Q3'!N75,0)","v":0},{"$f":" IF(M75>0,M75-F75,0)","v":0},{"$f":"IF(M75>0,F75,M75)","v":0},{"$f":"IF('Q3'!Q75>0,'Q3'!Q75,0)","v":0},{"$f":"IF(P75>0,P75-G75,0)","v":0},{"$f":"IF(Q75>0,G75,P75)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E52 = 0,\" \",Budget!E52)","v":" "},null,null,{"$f":"'Q3'!J76","v":0},{"$f":"'Q3'!K76","v":0},{"$f":"H76-F76","v":0},0,null,{"$f":"IF('Q3'!N76>0,'Q3'!N76,0)","v":0},{"$f":" IF(M76>0,M76-F76,0)","v":0},{"$f":"IF(M76>0,F76,M76)","v":0},{"$f":"IF('Q3'!Q76>0,'Q3'!Q76,0)","v":0},{"$f":"IF(P76>0,P76-G76,0)","v":0},{"$f":"IF(Q76>0,G76,P76)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E53 = 0,\" \",Budget!E53)","v":" "},null,null,{"$f":"'Q3'!J77","v":0},{"$f":"'Q3'!K77","v":0},0,0,null,{"$f":"IF('Q3'!N77>0,'Q3'!N77,0)","v":0},0,0,{"$f":"IF('Q3'!Q77>0,'Q3'!Q77,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E54 = 0,\" \",Budget!E54)","v":" "},null,null,{"$f":"'Q3'!J78","v":0},{"$f":"'Q3'!K78","v":0},0,0,null,{"$f":"IF('Q3'!N78>0,'Q3'!N78,0)","v":0},0,0,{"$f":"IF('Q3'!Q78>0,'Q3'!Q78,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E55 = 0,\" \",Budget!E55)","v":" "},null,null,{"$f":"'Q3'!J79","v":0},{"$f":"'Q3'!K79","v":0},0,0,null,{"$f":"IF('Q3'!N79>0,'Q3'!N79,0)","v":0},0,0,{"$f":"IF('Q3'!Q79>0,'Q3'!Q79,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E56 = 0,\" \",Budget!E56)","v":" "},null,null,{"$f":"'Q3'!J80","v":0},{"$f":"'Q3'!K80","v":0},0,0,null,{"$f":"IF('Q3'!N80>0,'Q3'!N80,0)","v":0},0,0,{"$f":"IF('Q3'!Q80>0,'Q3'!Q80,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E57 = 0,\" \",Budget!E57)","v":" "},null,null,{"$f":"'Q3'!J81","v":0},{"$f":"'Q3'!K81","v":0},0,0,null,{"$f":"IF('Q3'!N81>0,'Q3'!N81,0)","v":0},0,0,{"$f":"IF('Q3'!Q81>0,'Q3'!Q81,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E58 = 0,\" \",Budget!E58)","v":" "},null,null,{"$f":"'Q3'!J82","v":0},{"$f":"'Q3'!K82","v":0},0,0,null,{"$f":"IF('Q3'!N82>0,'Q3'!N82,0)","v":0},0,0,{"$f":"IF('Q3'!Q82>0,'Q3'!Q82,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E59 = 0,\" \",Budget!E59)","v":" "},null,null,{"$f":"'Q3'!J83","v":0},{"$f":"'Q3'!K83","v":0},0,0,null,{"$f":"IF('Q3'!N83>0,'Q3'!N83,0)","v":0},0,0,{"$f":"IF('Q3'!Q83>0,'Q3'!Q83,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E60 = 0,\" \",Budget!E60)","v":" "},null,null,{"$f":"'Q3'!J84","v":0},{"$f":"'Q3'!K84","v":0},0,0,null,{"$f":"IF('Q3'!N84>0,'Q3'!N84,0)","v":0},0,0,{"$f":"IF('Q3'!Q84>0,'Q3'!Q84,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E61 = 0,\" \",Budget!E61)","v":" "},null,null,{"$f":"'Q3'!J85","v":0},{"$f":"'Q3'!K85","v":0},0,0,null,{"$f":"IF('Q3'!N85>0,'Q3'!N85,0)","v":0},0,0,{"$f":"IF('Q3'!Q85>0,'Q3'!Q85,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E62 = 0,\" \",Budget!E62)","v":" "},null,null,{"$f":"'Q3'!J86","v":0},{"$f":"'Q3'!K86","v":0},0,0,null,{"$f":"IF('Q3'!N86>0,'Q3'!N86,0)","v":0},0,0,{"$f":"IF('Q3'!Q86>0,'Q3'!Q86,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E63 = 0,\" \",Budget!E63)","v":" "},null,null,{"$f":"'Q3'!J87","v":0},{"$f":"'Q3'!K87","v":0},0,0,null,{"$f":"IF('Q1'!N87>0,'Q1'!N87,0)","v":0},0,0,{"$f":"IF('Q3'!Q87>0,'Q3'!Q87,0)","v":0},0,0]
[null,null,null,null,"TOTAL",null,null,{"$f":"'Q3'!J88","v":0},{"$f":"'Q3'!K88","v":0},{"$f":"H88-F88","v":0},{"$f":"I88-G88","v":0},null,{"$f":"SUM(M75:M87)","v":0},0,0,0,0,0]

{"sheet":"Q5","index":7,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[28,5,28,6],[28,7,28,8],[28,9,28,10],[43,9,43,10],[42,9,42,10],[33,9,33,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[47,9,47,10],[34,9,34,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,5,30,6],[30,7,30,8],[30,9,30,10],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,4,32,10],[41,9,41,10],[44,9,44,10],[26,5,26,6],[26,7,26,8],[26,9,26,10],[27,5,27,6],[27,7,27,8],[27,9,27,10],[24,5,24,6],[24,7,24,8],[24,9,24,10],[25,5,25,6],[25,7,25,8],[25,9,25,10],[22,5,22,6],[22,7,22,8],[22,9,22,10],[23,5,23,6],[23,7,23,8],[23,9,23,10],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,5,21,6],[21,7,21,8],[21,9,21,10],[72,15,72,17],[17,4,18,10],[4,4,4,10],[5,4,5,10],[6,4,6,10],[7,4,7,10],[9,5,9,10],[10,5,10,10],[11,5,11,10],[12,5,12,10],[14,5,14,7],[14,9,14,10],[15,5,15,8],[19,5,19,6],[19,7,19,8],[19,9,19,10],[49,9,49,10],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,12,72,14],[57,9,57,10],[59,9,59,10],[65,7,65,8],[52,9,52,10],[54,9,54,10],[61,4,61,10],[62,4,64,10]]}
[]
[]
[]
[]
[null,null,null,null,"MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY"]
[null,null,null,null,{"$f":"Budget!E6","v":"MATERIALS MANAGEMENT DIVISION - Recycling Unit"}]
[null,null,null,null,{"$f":"Budget!E7","v":"Recycling  Grant"}]
[null,null,null,null,{"$f":"Budget!E8","v":"FINANCIAL STATUS REPORT"}]
[]
[null,null,null,null,"Grantee / Vendor Name:",{"$f":"IF(Budget!F10 >0,Budget!F10,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Vendor Number:",{"$f":"IF(Budget!F11 >0,Budget!F11,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Project Name:",{"$f":"IF(Budget!F12 >0,Budget!F12,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Grant Given Number:",{"$f":"IF(Budget!F13 >0,Budget!F13,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Report Period:","From:",null,"To:"]
[null,null,null,null,"Contact Name:",{"$f":"IF(Budget!F15>0,Budget!F15,\"TBD\")","v":"TBD"},null,null,"Contact Number:",{"$f":"IF(Budget!J15>0,Budget!J15,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Contact Email:",{"$f":"IF(Budget!F16>0,Budget!F16,\"TBD\")","v":"TBD"}]
[]
[null,null,null,null,"EXPENDITURES\nList all expenditures for the report period and attach invoices from contractors and subcontractors"]
[]
[null,null,null,null,"Task","Invoice Number",null,"Task Number",null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Progress Report"]
[null,null,null,null,"Task","Expended this period","Expended to date","Project Budget","Balance to date","Activity this period"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H19,\" \",\"-\",\" \",Budget!E19)","v":" - "},{"$f":"SUMIF($H$21:$I$32,1,$J$21:$K$32)","v":0},{"$f":"F35+'Q4'!G35","v":0},{"$f":"'Q4'!H35","v":0},{"$f":"H35-G35","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H20,\" \",\"-\",\" \",Budget!E20)","v":" - "},{"$f":"SUMIF($H$21:$I$32,2,$J$21:$K$32)","v":0},{"$f":"F36+'Q4'!G36","v":0},{"$f":"'Q4'!H36","v":0},{"$f":"H36-G36","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H21,\" \",\"-\",\" \",Budget!E21)","v":" - "},{"$f":"SUMIF($H$21:$I$32,3,$J$21:$K$32)","v":0},{"$f":"F37+'Q4'!G37","v":0},{"$f":"'Q4'!H37","v":0},{"$f":"H37-G37","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H22,\" \",\"-\",\" \",Budget!E22)","v":" - "},{"$f":"SUMIF($H$21:$I$32,4,$J$21:$K$32)","v":0},{"$f":"F38+'Q4'!G38","v":0},{"$f":"'Q4'!H38","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H23,\" \",\"-\",\" \",Budget!E23)","v":" - "},{"$f":"SUMIF($H$21:$I$32,5,$J$21:$K$32)","v":0},{"$f":"F39+'Q4'!G39","v":0},{"$f":"'Q4'!H39","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H24,\" \",\"-\",\" \",Budget!E24)","v":" - "},{"$f":"SUMIF($H$21:$I$32,6,$J$21:$K$32)","v":0},{"$f":"F40+'Q4'!G40","v":0},{"$f":"'Q4'!H40","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H25,\" \",\"-\",\" \",Budget!E25)","v":" - "},{"$f":"SUMIF($H$21:$I$32,7,$J$21:$K$32)","v":0},{"$f":"F41+'Q4'!G41","v":0},{"$f":"'Q4'!H41","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H26,\" \",\"-\",\" \",Budget!E26)","v":" - "},{"$f":"SUMIF($H$21:$I$32,8,$J$21:$K$32)","v":0},{"$f":"F42+'Q4'!G42","v":0},{"$f":"'Q4'!H42","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H27,\" \",\"-\",\" \",Budget!E27)","v":" - "},{"$f":"SUMIF($H$21:$I$32,9,$J$21:$K$32)","v":0},{"$f":"F43+'Q4'!G43","v":0},{"$f":"'Q4'!H43","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H28,\" \",\"-\",\" \",Budget!E28)","v":" -  "},{"$f":"SUMIF($H$21:$I$32,10,$J$21:$K$32)","v":0},{"$f":"F44+'Q4'!G44","v":0},{"$f":"'Q4'!H44","v":0},0]
[null,null,null,null,"Task Subtotal",{"$f":"SUM(F35:F44)","v":0},{"$f":"SUM(G35:G44)","v":0},0,0]
[]
[null,null,null,null,"INDIRECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F45*Budget!$I$32","v":0},{"$f":"G45*Budget!$I$32","v":0},{"$f":"H45*Budget!$I$32","v":0},{"$f":"I45*Budget!$I$32","v":0}]
[null,null,null,null,"PROJECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F48+F43","v":0},{"$f":"G48+G43","v":0},0,0]
[]
[null,null,null,null,"MATCH AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",null,{"$f":"F53+'Q4'!G53","v":0},{"$f":"(H45*Budget!$I$37)+(H48*Budget!$I$37)","v":0},{"$f":"(I45*Budget!$I$37)+(I48*Budget!$I$37)","v":0}]
[null,null,null,null,"GRANT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"(F45+F48)-F53","v":0},0,{"$f":"(H45+H48)-H53","v":0},{"$f":"(I45+I48)-I53","v":0}]
[]
[null,null,null,null,"RENTENTION",{"$f":"'Q4'!F57","v":0.05}]
[null,null,null,null,"Total",{"$f":"F55*F57","v":0},{"$f":"G55*F57","v":0},{"$f":"H55*F57","v":0},{"$f":"H58-G58","v":0}]
[null,null,null,null,"REIMBURSMENT THIS PERIOD"]
[null,null,null,null,"Total",{"$f":"F55-F58","v":0},{"$f":"G55-G58","v":0},{"$f":"(H45+H48)-H53","v":0},{"$f":"H60-G60","v":0}]
[]
[null,null,null,null,"STATEMENT OF REVIEW AND APPROVAL"]
[null,null,null,null,"“By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant as paid. The grantee acknowledges that falsification of records may result in the termination of this grant contract and other appropriate legal remedies.”"]
[]
[]
[null,null,null,null,"Name:",null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"This Period",null,"Remaining Budget",null,"Remaining Balance",null,null,"GRANT",null,null,"MATCH"]
[null,null,null,null,"Contractor","Grant","Match","Grant","Match","Grant","Match",null,"Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period ","Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period "]
[null,null,null,null,{"$f":"IF(Budget!E51 = 0,\" \",Budget!E51)","v":" "},null,null,{"$f":"'Q4'!J75","v":0},{"$f":"'Q4'!K75","v":0},{"$f":"H75-F75","v":0},{"$f":"I75-G75","v":0},null,{"$f":"IF('Q4'!N75>0,'Q4'!N75,0)","v":0},{"$f":" IF(M75>0,M75-F75,0)","v":0},{"$f":"IF(N75>0,F75,M75)","v":0},{"$f":"IF('Q4'!Q75>0,'Q4'!Q75,0)","v":0},{"$f":"IF(P75>0,P75-G75,0)","v":0},{"$f":"IF(Q75>0,G75,P75)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E52 = 0,\" \",Budget!E52)","v":" "},null,null,{"$f":"'Q4'!J76","v":0},{"$f":"'Q4'!K76","v":0},{"$f":"H76-F76","v":0},0,null,{"$f":"IF('Q4'!N76>0,'Q4'!N76,0)","v":0},{"$f":" IF(M76>0,M76-F76,0)","v":0},{"$f":"IF(N76>0,F76,M76)","v":0},{"$f":"IF('Q4'!Q76>0,'Q4'!Q76,0)","v":0},{"$f":"IF(P76>0,P76-G76,0)","v":0},{"$f":"IF(Q76>0,G76,P76)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E53 = 0,\" \",Budget!E53)","v":" "},null,null,{"$f":"'Q4'!J77","v":0},{"$f":"'Q4'!K77","v":0},0,0,null,{"$f":"IF('Q4'!N77>0,'Q4'!N77,0)","v":0},0,0,{"$f":"IF('Q4'!Q77>0,'Q4'!Q77,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E54 = 0,\" \",Budget!E54)","v":" "},null,null,{"$f":"'Q4'!J78","v":0},{"$f":"'Q4'!K78","v":0},0,0,null,{"$f":"IF('Q4'!N78>0,'Q4'!N78,0)","v":0},0,0,{"$f":"IF('Q4'!Q78>0,'Q4'!Q78,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E55 = 0,\" \",Budget!E55)","v":" "},null,null,{"$f":"'Q4'!J79","v":0},{"$f":"'Q4'!K79","v":0},0,0,null,{"$f":"IF('Q4'!N79>0,'Q4'!N79,0)","v":0},0,0,{"$f":"IF('Q4'!Q79>0,'Q4'!Q79,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E56 = 0,\" \",Budget!E56)","v":" "},null,null,{"$f":"'Q4'!J80","v":0},{"$f":"'Q4'!K80","v":0},0,0,null,{"$f":"IF('Q4'!N80>0,'Q4'!N80,0)","v":0},0,0,{"$f":"IF('Q4'!Q80>0,'Q4'!Q80,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E57 = 0,\" \",Budget!E57)","v":" "},null,null,{"$f":"'Q4'!J81","v":0},{"$f":"'Q4'!K81","v":0},0,0,null,{"$f":"IF('Q4'!N81>0,'Q4'!N81,0)","v":0},0,0,{"$f":"IF('Q4'!Q81>0,'Q4'!Q81,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E58 = 0,\" \",Budget!E58)","v":" "},null,null,{"$f":"'Q4'!J82","v":0},{"$f":"'Q4'!K82","v":0},0,0,null,{"$f":"IF('Q4'!N82>0,'Q4'!N82,0)","v":0},0,0,{"$f":"IF('Q4'!Q82>0,'Q4'!Q82,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E59 = 0,\" \",Budget!E59)","v":" "},null,null,{"$f":"'Q4'!J83","v":0},{"$f":"'Q4'!K83","v":0},0,0,null,{"$f":"IF('Q4'!N83>0,'Q4'!N83,0)","v":0},0,0,{"$f":"IF('Q4'!Q83>0,'Q4'!Q83,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E60 = 0,\" \",Budget!E60)","v":" "},null,null,{"$f":"'Q4'!J84","v":0},{"$f":"'Q4'!K84","v":0},0,0,null,{"$f":"IF('Q4'!N84>0,'Q4'!N84,0)","v":0},0,0,{"$f":"IF('Q4'!Q84>0,'Q4'!Q84,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E61 = 0,\" \",Budget!E61)","v":" "},null,null,{"$f":"'Q4'!J85","v":0},{"$f":"'Q4'!K85","v":0},0,0,null,{"$f":"IF('Q4'!N85>0,'Q4'!N85,0)","v":0},0,0,{"$f":"IF('Q4'!Q85>0,'Q4'!Q85,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E62 = 0,\" \",Budget!E62)","v":" "},null,null,{"$f":"'Q4'!J86","v":0},{"$f":"'Q4'!K86","v":0},0,0,null,{"$f":"IF('Q4'!N86>0,'Q4'!N86,0)","v":0},0,0,{"$f":"IF('Q4'!Q86>0,'Q4'!Q86,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E63 = 0,\" \",Budget!E63)","v":" "},null,null,{"$f":"'Q4'!J87","v":0},{"$f":"'Q4'!K87","v":0},0,0,null,{"$f":"IF('Q1'!N87>0,'Q1'!N87,0)","v":0},0,0,{"$f":"IF('Q4'!Q87>0,'Q4'!Q87,0)","v":0},0,0]
[null,null,null,null,"TOTAL",null,null,{"$f":"'Q4'!J88","v":0},{"$f":"'Q4'!K88","v":0},{"$f":"H88-F88","v":0},{"$f":"I88-G88","v":0},null,{"$f":"SUM(M75:M87)","v":0},0,0,0,0,0]

{"sheet":"Final Report ","index":8,"n_rows":88,"n_cols":18,"rows_kept":88,"cut":false,"hidden":false,"merged":[[28,5,28,6],[28,7,28,8],[28,9,28,10],[43,9,43,10],[42,9,42,10],[33,9,33,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[47,9,47,10],[34,9,34,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,5,30,6],[30,7,30,8],[30,9,30,10],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,4,32,10],[41,9,41,10],[44,9,44,10],[26,5,26,6],[26,7,26,8],[26,9,26,10],[27,5,27,6],[27,7,27,8],[27,9,27,10],[24,5,24,6],[24,7,24,8],[24,9,24,10],[25,5,25,6],[25,7,25,8],[25,9,25,10],[22,5,22,6],[22,7,22,8],[22,9,22,10],[23,5,23,6],[23,7,23,8],[23,9,23,10],[20,5,20,6],[20,7,20,8],[20,9,20,10],[21,5,21,6],[21,7,21,8],[21,9,21,10],[72,15,72,17],[17,4,18,10],[4,4,4,10],[5,4,5,10],[6,4,6,10],[7,4,7,10],[9,5,9,10],[10,5,10,10],[11,5,11,10],[12,5,12,10],[14,5,14,7],[14,9,14,10],[15,5,15,8],[19,5,19,6],[19,7,19,8],[19,9,19,10],[49,9,49,10],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,12,72,14],[57,9,57,10],[59,9,59,10],[65,7,65,8],[52,9,52,10],[54,9,54,10],[61,4,61,10],[62,4,64,10]]}
[]
[]
[]
[]
[null,null,null,null,"MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY"]
[null,null,null,null,{"$f":"Budget!E6","v":"MATERIALS MANAGEMENT DIVISION - Recycling Unit"}]
[null,null,null,null,{"$f":"Budget!E7","v":"Recycling  Grant"}]
[null,null,null,null,{"$f":"Budget!E8","v":"FINANCIAL STATUS REPORT"}]
[]
[null,null,null,null,"Grantee / Vendor Name:",{"$f":"IF(Budget!F10 >0,Budget!F10,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Vendor Number:",{"$f":"IF(Budget!F11 >0,Budget!F11,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Project Name:",{"$f":"IF(Budget!F12 >0,Budget!F12,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Grant Given Number:",{"$f":"IF(Budget!F13 >0,Budget!F13,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Report Period:","From:",null,"To:"]
[null,null,null,null,"Contact Name:",{"$f":"IF(Budget!F15>0,Budget!F15,\"TBD\")","v":"TBD"},null,null,"Contact Number:",{"$f":"IF(Budget!J15>0,Budget!J15,\"TBD\")","v":"TBD"}]
[null,null,null,null,"Contact Email:",{"$f":"IF(Budget!F16>0,Budget!F16,\"TBD\")","v":"TBD"}]
[]
[null,null,null,null,"EXPENDITURES\nList all expenditures for the report period and attach invoices from contractors and subcontractors"]
[]
[null,null,null,null,"Task","Invoice Number",null,"Task Number",null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Progress Report"]
[null,null,null,null,"Task","Expended this period","Expended to date","Project Budget","Balance to date","Activity this period"]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H19,\" \",\"-\",\" \",Budget!E19)","v":" - "},{"$f":"SUMIF($H$21:$I$32,1,$J$21:$K$32)","v":0},{"$f":"F35+'Q5'!G35","v":0},{"$f":"'Q5'!H35","v":0},{"$f":"H35-G35","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H20,\" \",\"-\",\" \",Budget!E20)","v":" - "},{"$f":"SUMIF($H$21:$I$32,2,$J$21:$K$32)","v":0},{"$f":"F36+'Q5'!G36","v":0},{"$f":"'Q5'!H36","v":0},{"$f":"H36-G36","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H21,\" \",\"-\",\" \",Budget!E21)","v":" - "},{"$f":"SUMIF($H$21:$I$32,3,$J$21:$K$32)","v":0},{"$f":"F37+'Q5'!G37","v":0},{"$f":"'Q5'!H37","v":0},{"$f":"H37-G37","v":0}]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H22,\" \",\"-\",\" \",Budget!E22)","v":" - "},{"$f":"SUMIF($H$21:$I$32,4,$J$21:$K$32)","v":0},{"$f":"F38+'Q5'!G38","v":0},{"$f":"'Q5'!H38","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H23,\" \",\"-\",\" \",Budget!E23)","v":" - "},{"$f":"SUMIF($H$21:$I$32,5,$J$21:$K$32)","v":0},{"$f":"F39+'Q5'!G39","v":0},{"$f":"'Q5'!H39","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H24,\" \",\"-\",\" \",Budget!E24)","v":" - "},{"$f":"SUMIF($H$21:$I$32,6,$J$21:$K$32)","v":0},{"$f":"F40+'Q5'!G40","v":0},{"$f":"'Q5'!H40","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H25,\" \",\"-\",\" \",Budget!E25)","v":" - "},{"$f":"SUMIF($H$21:$I$32,7,$J$21:$K$32)","v":0},{"$f":"F41+'Q5'!G41","v":0},{"$f":"'Q5'!H41","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H26,\" \",\"-\",\" \",Budget!E26)","v":" - "},{"$f":"SUMIF($H$21:$I$32,8,$J$21:$K$32)","v":0},{"$f":"F42+'Q5'!G42","v":0},{"$f":"'Q5'!H42","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H27,\" \",\"-\",\" \",Budget!E27)","v":" - "},{"$f":"SUMIF($H$21:$I$32,9,$J$21:$K$32)","v":0},{"$f":"F43+'Q5'!G43","v":0},{"$f":"'Q5'!H43","v":0},0]
[null,null,null,null,{"$f":"_xlfn.CONCAT(Budget!H28,\" \",\"-\",\" \",Budget!E28)","v":" -  "},{"$f":"SUMIF($H$21:$I$32,10,$J$21:$K$32)","v":0},{"$f":"F44+'Q5'!G44","v":0},{"$f":"'Q5'!H44","v":0},0]
[null,null,null,null,"Task Subtotal",{"$f":"SUM(F35:F44)","v":0},{"$f":"SUM(G35:G44)","v":0},0,0]
[]
[null,null,null,null,"INDIRECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F45*Budget!$I$32","v":0},{"$f":"G45*Budget!$I$32","v":0},{"$f":"H45*Budget!$I$32","v":0},{"$f":"I45*Budget!$I$32","v":0}]
[null,null,null,null,"PROJECT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"F48+F43","v":0},{"$f":"G48+G43","v":0},0,0]
[]
[null,null,null,null,"MATCH AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",null,{"$f":"F53+'Q5'!G53","v":0},{"$f":"(H45*Budget!$I$37)+(H48*Budget!$I$37)","v":0},{"$f":"(I45*Budget!$I$37)+(I48*Budget!$I$37)","v":0}]
[null,null,null,null,"GRANT AMOUNT","Expended this period","Expended to date","Project Budget","Balance to date"]
[null,null,null,null,"Total",{"$f":"(F45+F48)-F53","v":0},0,{"$f":"(H45+H48)-H53","v":0},{"$f":"(I45+I48)-I53","v":0}]
[]
[null,null,null,null,"RENTENTION",{"$f":"'Q5'!F57","v":0.05}]
[null,null,null,null,"Total",{"$f":"F55*F57","v":0},{"$f":"G55*F57","v":0},{"$f":"H55*F57","v":0},{"$f":"H58-G58","v":0}]
[null,null,null,null,"REIMBURSMENT THIS PERIOD"]
[null,null,null,null,"Total",{"$f":"F55-F58","v":0},{"$f":"G55-G58","v":0},{"$f":"(H45+H48)-H53","v":0},{"$f":"H60-G60","v":0}]
[]
[null,null,null,null,"STATEMENT OF REVIEW AND APPROVAL"]
[null,null,null,null,"“By submitting this request for payment, the grantee certifies that all expenditures contained are eligible for reimbursement under this grant as paid. The grantee acknowledges that falsification of records may result in the termination of this grant contract and other appropriate legal remedies.”"]
[]
[]
[null,null,null,null,"Name:",null,null,"Signature:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"This Period",null,"Remaining Budget",null,"Remaining Balance",null,null,"GRANT",null,null,"MATCH"]
[null,null,null,null,"Contractor","Grant","Match","Grant","Match","Grant","Match",null,"Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period ","Allowable Indirect","Allowable Ind\nLess Charges","Indirect Cost Basis this Period "]
[null,null,null,null,{"$f":"IF(Budget!E51 = 0,\" \",Budget!E51)","v":" "},null,null,{"$f":"'Q5'!J75","v":0},{"$f":"'Q5'!K75","v":0},{"$f":"H75-F75","v":0},{"$f":"I75-G75","v":0},null,{"$f":"IF('Q5'!N75>0,'Q5'!N75,0)","v":0},{"$f":" IF(M75>0,M75-F75,0)","v":0},{"$f":"IF(N75>0,F75,M75)","v":0},{"$f":"IF('Q5'!Q75>0,'Q5'!Q75,0)","v":0},{"$f":"IF(P75>0,P75-G75,0)","v":0},{"$f":"IF(Q75>0,G75,P75)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E52 = 0,\" \",Budget!E52)","v":" "},null,null,{"$f":"'Q5'!J76","v":0},{"$f":"'Q5'!K76","v":0},{"$f":"H76-F76","v":0},0,null,{"$f":"IF('Q5'!N76>0,'Q5'!N76,0)","v":0},{"$f":" IF(M76>0,M76-F76,0)","v":0},{"$f":"IF(N76>0,F76,M76)","v":0},{"$f":"IF('Q5'!Q76>0,'Q5'!Q76,0)","v":0},{"$f":"IF(P76>0,P76-G76,0)","v":0},{"$f":"IF(Q76>0,G76,P76)","v":0}]
[null,null,null,null,{"$f":"IF(Budget!E53 = 0,\" \",Budget!E53)","v":" "},null,null,{"$f":"'Q5'!J77","v":0},{"$f":"'Q5'!K77","v":0},0,0,null,{"$f":"IF('Q5'!N77>0,'Q5'!N77,0)","v":0},0,0,{"$f":"IF('Q5'!Q77>0,'Q5'!Q77,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E54 = 0,\" \",Budget!E54)","v":" "},null,null,{"$f":"'Q5'!J78","v":0},{"$f":"'Q5'!K78","v":0},0,0,null,{"$f":"IF('Q5'!N78>0,'Q5'!N78,0)","v":0},0,0,{"$f":"IF('Q5'!Q78>0,'Q5'!Q78,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E55 = 0,\" \",Budget!E55)","v":" "},null,null,{"$f":"'Q5'!J79","v":0},{"$f":"'Q5'!K79","v":0},0,0,null,{"$f":"IF('Q5'!N79>0,'Q5'!N79,0)","v":0},0,0,{"$f":"IF('Q5'!Q79>0,'Q5'!Q79,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E56 = 0,\" \",Budget!E56)","v":" "},null,null,{"$f":"'Q5'!J80","v":0},{"$f":"'Q5'!K80","v":0},0,0,null,{"$f":"IF('Q5'!N80>0,'Q5'!N80,0)","v":0},0,0,{"$f":"IF('Q5'!Q80>0,'Q5'!Q80,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E57 = 0,\" \",Budget!E57)","v":" "},null,null,{"$f":"'Q5'!J81","v":0},{"$f":"'Q5'!K81","v":0},0,0,null,{"$f":"IF('Q5'!N81>0,'Q5'!N81,0)","v":0},0,0,{"$f":"IF('Q5'!Q81>0,'Q5'!Q81,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E58 = 0,\" \",Budget!E58)","v":" "},null,null,{"$f":"'Q5'!J82","v":0},{"$f":"'Q5'!K82","v":0},0,0,null,{"$f":"IF('Q5'!N82>0,'Q5'!N82,0)","v":0},0,0,{"$f":"IF('Q5'!Q82>0,'Q5'!Q82,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E59 = 0,\" \",Budget!E59)","v":" "},null,null,{"$f":"'Q5'!J83","v":0},{"$f":"'Q5'!K83","v":0},0,0,null,{"$f":"IF('Q5'!N83>0,'Q5'!N83,0)","v":0},0,0,{"$f":"IF('Q5'!Q83>0,'Q5'!Q83,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E60 = 0,\" \",Budget!E60)","v":" "},null,null,{"$f":"'Q5'!J84","v":0},{"$f":"'Q5'!K84","v":0},0,0,null,{"$f":"IF('Q5'!N84>0,'Q5'!N84,0)","v":0},0,0,{"$f":"IF('Q5'!Q84>0,'Q5'!Q84,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E61 = 0,\" \",Budget!E61)","v":" "},null,null,{"$f":"'Q5'!J85","v":0},{"$f":"'Q5'!K85","v":0},0,0,null,{"$f":"IF('Q5'!N85>0,'Q5'!N85,0)","v":0},0,0,{"$f":"IF('Q5'!Q85>0,'Q5'!Q85,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E62 = 0,\" \",Budget!E62)","v":" "},null,null,{"$f":"'Q5'!J86","v":0},{"$f":"'Q5'!K86","v":0},0,0,null,{"$f":"IF('Q5'!N86>0,'Q5'!N86,0)","v":0},0,0,{"$f":"IF('Q5'!Q86>0,'Q5'!Q86,0)","v":0},0,0]
[null,null,null,null,{"$f":"IF(Budget!E63 = 0,\" \",Budget!E63)","v":" "},null,null,{"$f":"'Q5'!J87","v":0},{"$f":"'Q5'!K87","v":0},0,0,null,{"$f":"IF('Q1'!N87>0,'Q1'!N87,0)","v":0},0,0,{"$f":"IF('Q5'!Q87>0,'Q5'!Q87,0)","v":0},0,0]
[null,null,null,null,"TOTAL",null,null,{"$f":"'Q5'!J88","v":0},{"$f":"'Q5'!K88","v":0},{"$f":"H88-F88","v":0},{"$f":"I88-G88","v":0},null,{"$f":"SUM(M75:M87)","v":0},0,0,0,0,0]

{"sheet":"Budget Revision 1","index":9,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[17,4,17,6],[17,7,17,8],[17,9,17,10],[4,4,4,12],[5,4,5,12],[6,4,6,12],[7,4,7,12],[9,5,9,12],[10,5,10,12],[11,5,11,12],[12,5,12,12],[14,5,14,7],[14,9,14,10],[15,5,15,8],[18,4,18,6],[18,7,18,8],[18,9,18,10],[19,4,19,6],[19,7,19,8],[19,9,19,10],[20,4,20,6],[20,7,20,8],[20,9,20,10],[21,4,21,6],[21,7,21,8],[21,9,21,10],[22,4,22,6],[22,7,22,8],[22,9,22,10],[23,4,23,6],[23,7,23,8],[23,9,23,10],[24,4,24,6],[24,7,24,8],[24,9,24,10],[25,4,25,6],[25,7,25,8],[25,9,25,10],[26,4,26,6],[26,7,26,8],[26,9,26,10],[27,4,27,6],[27,7,27,8],[27,9,27,10],[35,9,35,10],[37,4,38,12],[28,4,28,6],[28,7,28,8],[28,9,28,10],[32,7,32,8],[33,7,33,8],[33,9,33,10],[30,7,30,8],[31,7,31,8],[31,9,31,10]]}
[]
[]
[]
[]
[null,null,null,null,"MICHIGAN DEPARTMENT OF ENVIRONMENT, GREAT LAKES, AND ENERGY"]
[null,null,null,null,{"$f":"Budget!E6","v":"MATERIALS MANAGEMENT DIVISION - Recycling Unit"}]
[null,null,null,null,{"$f":"Budget!E7","v":"Recycling  Grant"}]
[null,null,null,null,{"$f":"Budget!E8","v":"FINANCIAL STATUS REPORT"}]
[]
[null,null,null,null,"Grantee / Vendor Name:",{"$f":"IF(Budget!F10>0,Budget!F10,\" \")","v":" "}]
[null,null,null,null,"Vendor Number:",{"$f":"IF(Budget!F11>0,Budget!F11,\" \")","v":" "}]
[null,null,null,null,"Project Name:",{"$f":"IF(Budget!F12>0,Budget!F12,\" \")","v":" "}]
[null,null,null,null,"Grant Given Number:",{"$f":"IF(Budget!F13>0,Budget!F13,\" \")","v":" "}]
[null,null,null,null,"Contract Date","From:",{"$f":"IF(Budget!G14>0,Budget!G14,\" \")","v":" "},"To:",{"$f":"IF(Budget!I14>0,Budget!I14,\" \")","v":" "}]
[null,null,null,null,"Contact Name:",{"$f":"IF(Budget!F15>0,Budget!F15,\" \")","v":" "},null,null,"Contact Number:",{"$f":"IF(Budget!J15>0,Budget!J15,\" \")","v":" "}]
[null,null,null,null,"Contact Email:",{"$f":"IF(Budget!F16>0,Budget!F16,\" \")","v":" "}]
[]
[null,null,null,null,"Task",null,null,"Task Number",null,"Approved Budget",null,"Proposed Changes","Revised Project Grant Funds"]
[null,null,null,null,{"$f":"IF(Budget!E19>0,Budget!E19,\" \")","v":" "},null,null,{"$f":"IF(Budget!H19>0,Budget!H19,\" \")","v":" "},null,{"$f":"IF(Budget!J19>0,Budget!J19,\" \")","v":" "},null,null,{"$f":"IF(L19<>0,L19+J19,J19)","v":" "}]
[null,null,null,null,{"$f":"IF(Budget!E20>0,Budget!E20,\" \")","v":" "},null,null,{"$f":"IF(Budget!H20>0,Budget!H20,\" \")","v":" "},null,{"$f":"IF(Budget!J20>0,Budget!J20,\" \")","v":" "},null,null,{"$f":"IF(L20<>0,L20+J20,J20)","v":" "}]
[null,null,null,null,{"$f":"IF(Budget!E21>0,Budget!E21,\" \")","v":" "},null,null,{"$f":"IF(Budget!H21>0,Budget!H21,\" \")","v":" "},null,{"$f":"IF(Budget!J21>0,Budget!J21,\" \")","v":" "},null,null," "]
[null,null,null,null,{"$f":"IF(Budget!E22>0,Budget!E22,\" \")","v":" "},null,null,{"$f":"IF(Budget!H22>0,Budget!H22,\" \")","v":" "},null,{"$f":"IF(Budget!J22>0,Budget!J22,\" \")","v":" "},null,null," "]
[null,null,null,null,{"$f":"IF(Budget!E23>0,Budget!E23,\" \")","v":" "},null,null,{"$f":"IF(Budget!H23>0,Budget!H23,\" \")","v":" "},null,{"$f":"IF(Budget!J23>0,Budget!J23,\" \")","v":" "},null,null," "]
[null,null,null,null,{"$f":"IF(Budget!E24>0,Budget!E24,\" \")","v":" "},null,null,{"$f":"IF(Budget!H24>0,Budget!H24,\" \")","v":" "},null,{"$f":"IF(Budget!J24>0,Budget!J24,\" \")","v":" "},null,null," "]
[null,null,null,null,{"$f":"IF(Budget!E25>0,Budget!E25,\" \")","v":" "},null,null,{"$f":"IF(Budget!H25>0,Budget!H25,\" \")","v":" "},null,{"$f":"IF(Budget!J25>0,Budget!J25,\" \")","v":" "},null,null," "]
[null,null,null,null,{"$f":"IF(Budget!E26>0,Budget!E26,\" \")","v":" "},null,null,{"$f":"IF(Budget!H26>0,Budget!H26,\" \")","v":" "},null,{"$f":"IF(Budget!J26>0,Budget!J26,\" \")","v":" "},null,null," "]
[null,null,null,null,{"$f":"IF(Budget!E27>0,Budget!E27,\" \")","v":" "},null,null,{"$f":"IF(Budget!H27>0,Budget!H27,\" \")","v":" "},null,{"$f":"IF(Budget!J27>0,Budget!J27,\" \")","v":" "},null,null," "]
[null,null,null,null,{"$f":"IF(Budget!E28>0,Budget!E28,\" \")","v":" "},null,null,{"$f":"IF(Budget!H28>0,Budget!H28,\" \")","v":" "},null,{"$f":"IF(Budget!J28>0,Budget!J28,\" \")","v":" "},null,null," "]
[null,null,null,null,"Task Subtotal",null,null,null,null,{"$f":"SUM(J19:K28)","v":0},null,{"$f":"SUM(L19:L28)","v":0},{"$f":"SUM(M19:M28)","v":0}]
[]
[null,null,null,null,"INDIRECT RATE"]
[null,null,null,null,null,null,null,{"$f":"Budget!I32","v":0},null,{"$f":"H32*J29","v":0},null,{"$f":"L29*H32","v":0},{"$f":"M29*H32","v":0}]
[null,null,null,null,"MATCH BUDGET"]
[null,null,null,null,"Total",null,null,{"$f":"Budget!$I$37","v":0},null,{"$f":"(J29*$H$34)+(J32*H34)","v":0},null,{"$f":"L29*$H$34","v":0},{"$f":"(M29*$H$34)+(M32*$H$34)","v":0}]
[null,null,null,null,"GRANT BUDGET"]
[null,null,null,null,"Total",null,null,null,null,{"$f":"(J29+J32)-J34","v":0},null,{"$f":"(L29+L32)-L34","v":0},{"$f":"(M29+M32)-M34","v":0}]
[null,null,null,null,"Notes:"]

{"sheet":"Budget Revision","index":10,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":true,"merged":[[65,1,65,6],[2,1,2,9],[3,1,3,9],[4,1,4,9],[7,2,7,9],[8,2,8,9],[11,2,11,4],[11,6,11,9],[9,5,9,6],[9,2,9,3]]}
[]
[]
[null,"MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY"]
[null,{"$f":"Budget!E6:K6","v":{"$error":"#VALUE!"}}]
[null,"BUDGET REVISION"]
[]
[]
[null,"Grantee Organization Name: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[null,"Project Name: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[null,"Tracking Code Number: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},null,"Period Cover",null,null,"Date Submitted"]
[]
[null,null,"GRANT",null,null,null,"MATCH"]
[null,"BUDGET CATEGORIES","Approved Budget","Proposed Change","Revised Project Grant Funds",null,"Approved Local Match","Proposed Change","Revised Local Match Funds","TOTAL              "]
[null,"STAFFING AND FRINGE"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C15:D15)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G15:H15)","v":{"$error":"#REF!"}},{"$f":"SUM(E15,I15)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C16:D16)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G16:H16)","v":{"$error":"#REF!"}},{"$f":"SUM(E16,I16)","v":{"$error":"#REF!"}}]
[null,"Subtotal",{"$f":"SUM(C15:C16)","v":{"$error":"#REF!"}},{"$f":"SUM(D15:D16)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$f":"SUM(H15:H16)","v":0},{"$f":"SUM(I15:I16)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[null,"CONTRACTUAL SERVICES"]
[null,{"$f":"Budget!E19","v":0},{"$f":"Budget!J19","v":0},0,{"$f":"SUM(C20:D20)","v":0},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G20:H20)","v":{"$error":"#REF!"}},{"$f":"SUM(E20,I20)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!E20","v":0},{"$f":"Budget!J20","v":0},0,{"$f":"SUM(C21:D21)","v":0},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G21:H21)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"Budget!E21","v":0},{"$f":"Budget!K21","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E22","v":0},{"$f":"Budget!K22","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E23","v":0},{"$f":"Budget!K23","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E24","v":0},{"$f":"Budget!K24","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E25","v":0},{"$f":"Budget!K25","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E26","v":0},{"$f":"Budget!K26","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E27","v":0},{"$f":"Budget!K27","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E28","v":" "},{"$f":"Budget!K28","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C20:C29)","v":0},0,0,null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"SUM(J20:J29)","v":{"$error":"#REF!"}}]
[]
[null,"SUPPLIES & MATERIALS (itemize)"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C33:D33)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G33:H33)","v":{"$error":"#REF!"}},{"$f":"SUM(E33,I33)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C34:D34)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C33:C42)","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"EQUIPMENT"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C46:D46)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G46:H46)","v":{"$error":"#REF!"}},{"$f":"SUM(E46,I46)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C46:C47)","v":{"$error":"#REF!"}},{"$f":"SUM(D46:D47)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"SUM(J46:J47)","v":{"$error":"#REF!"}}]
[]
[null,"TRAVEL "]
[null,"MILEAGE"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C52:D52)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G52:H52)","v":{"$error":"#REF!"}},{"$f":"SUM(E52,I52)","v":{"$error":"#REF!"}}]
[null,"LODGING"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C54:D54)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G54:H54)","v":{"$error":"#REF!"}},{"$f":"SUM(E54,I54)","v":{"$error":"#REF!"}}]
[null,"MEALS"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C56:D56)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G56:H56)","v":{"$error":"#REF!"}},{"$f":"SUM(E56,I56)","v":{"$error":"#REF!"}}]
[null,"OTHER  (tolls, parking, etc.)"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C58:D58)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G58:H58)","v":{"$error":"#REF!"}},{"$f":"SUM(E58,I58)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C58:C61,C52,C54,C56)","v":{"$error":"#REF!"}},{"$f":"SUM(D58:D61,D52,D54,D56)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"GRANT AND MATCH BUDGET"]
[null,"Subtotal",{"$f":"SUM(C62+C43+C48+C30+C17)","v":{"$error":"#REF!"}},0,{"$f":"SUM(E62+E43+E48+E30+E17)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G62+G43+G48+G30+G17)","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Budget Revision (2)","index":11,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":true,"merged":[[11,2,11,4],[11,6,11,9],[65,1,65,6],[2,1,2,9],[3,1,3,9],[4,1,4,9],[7,2,7,9],[8,2,8,9],[9,2,9,3],[9,5,9,6]]}
[]
[]
[null,"MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY"]
[null,{"$f":"Budget!E6:K6","v":{"$error":"#VALUE!"}}]
[null,"BUDGET REVISION"]
[]
[]
[null,"Grantee Organization Name: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[null,"Project Name: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[null,"Tracking Code Number: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},null,"Period Cover",null,null,"Date Submitted"]
[]
[null,null,"GRANT",null,null,null,"MATCH"]
[null,"BUDGET CATEGORIES","Approved Budget","Proposed Change","Revised Project Grant Funds",null,"Approved Local Match","Proposed Change","Revised Local Match Funds","TOTAL              "]
[null,"STAFFING AND FRINGE"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C15:D15)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G15:H15)","v":{"$error":"#REF!"}},{"$f":"SUM(E15,I15)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C16:D16)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G16:H16)","v":{"$error":"#REF!"}},{"$f":"SUM(E16,I16)","v":{"$error":"#REF!"}}]
[null,"Subtotal",{"$f":"SUM(C15:C16)","v":{"$error":"#REF!"}},{"$f":"SUM(D15:D16)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$f":"SUM(H15:H16)","v":0},{"$f":"SUM(I15:I16)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[null,"CONTRACTUAL SERVICES"]
[null,{"$f":"Budget!E19","v":0},{"$f":"Budget!J19","v":0},0,{"$f":"SUM(C20:D20)","v":0},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G20:H20)","v":{"$error":"#REF!"}},{"$f":"SUM(E20,I20)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!E20","v":0},{"$f":"Budget!J20","v":0},0,{"$f":"SUM(C21:D21)","v":0},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G21:H21)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"Budget!E21","v":0},{"$f":"Budget!K21","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E22","v":0},{"$f":"Budget!K22","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E23","v":0},{"$f":"Budget!K23","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E24","v":0},{"$f":"Budget!K24","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E25","v":0},{"$f":"Budget!K25","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E26","v":0},{"$f":"Budget!K26","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E27","v":0},{"$f":"Budget!K27","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E28","v":" "},{"$f":"Budget!K28","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C20:C29)","v":0},0,0,null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"SUM(J20:J29)","v":{"$error":"#REF!"}}]
[]
[null,"SUPPLIES & MATERIALS (itemize)"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C33:D33)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G33:H33)","v":{"$error":"#REF!"}},{"$f":"SUM(E33,I33)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C34:D34)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C33:C42)","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"EQUIPMENT"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C46:D46)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G46:H46)","v":{"$error":"#REF!"}},{"$f":"SUM(E46,I46)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C46:C47)","v":{"$error":"#REF!"}},{"$f":"SUM(D46:D47)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"SUM(J46:J47)","v":{"$error":"#REF!"}}]
[]
[null,"TRAVEL "]
[null,"MILEAGE"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C52:D52)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G52:H52)","v":{"$error":"#REF!"}},{"$f":"SUM(E52,I52)","v":{"$error":"#REF!"}}]
[null,"LODGING"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C54:D54)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G54:H54)","v":{"$error":"#REF!"}},{"$f":"SUM(E54,I54)","v":{"$error":"#REF!"}}]
[null,"MEALS"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C56:D56)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G56:H56)","v":{"$error":"#REF!"}},{"$f":"SUM(E56,I56)","v":{"$error":"#REF!"}}]
[null,"OTHER  (tolls, parking, etc.)"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C58:D58)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G58:H58)","v":{"$error":"#REF!"}},{"$f":"SUM(E58,I58)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C58:C61,C52,C54,C56)","v":{"$error":"#REF!"}},{"$f":"SUM(D58:D61,D52,D54,D56)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"GRANT AND MATCH BUDGET"]
[null,"Subtotal",{"$f":"SUM(C62+C43+C48+C30+C17)","v":{"$error":"#REF!"}},0,{"$f":"SUM(E62+E43+E48+E30+E17)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G62+G43+G48+G30+G17)","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"Budget Revision (3)","index":12,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":true,"merged":[[11,2,11,4],[11,6,11,9],[65,1,65,6],[2,1,2,9],[3,1,3,9],[4,1,4,9],[7,2,7,9],[8,2,8,9],[9,2,9,3],[9,5,9,6]]}
[]
[]
[null,"MICHIGAN DEPARTMENT OF ENVIRONMENTAL QUALITY"]
[null,{"$f":"Budget!E6:K6","v":{"$error":"#VALUE!"}}]
[null,"BUDGET REVISION"]
[]
[]
[null,"Grantee Organization Name: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[null,"Project Name: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}}]
[null,"Tracking Code Number: ",{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},null,"Period Cover",null,null,"Date Submitted"]
[]
[null,null,"GRANT",null,null,null,"MATCH"]
[null,"BUDGET CATEGORIES","Approved Budget","Proposed Change","Revised Project Grant Funds",null,"Approved Local Match","Proposed Change","Revised Local Match Funds","TOTAL              "]
[null,"STAFFING AND FRINGE"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C15:D15)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G15:H15)","v":{"$error":"#REF!"}},{"$f":"SUM(E15,I15)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C16:D16)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G16:H16)","v":{"$error":"#REF!"}},{"$f":"SUM(E16,I16)","v":{"$error":"#REF!"}}]
[null,"Subtotal",{"$f":"SUM(C15:C16)","v":{"$error":"#REF!"}},{"$f":"SUM(D15:D16)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},{"$f":"SUM(H15:H16)","v":0},{"$f":"SUM(I15:I16)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
[null,"CONTRACTUAL SERVICES"]
[null,{"$f":"Budget!E19","v":0},{"$f":"Budget!J19","v":0},0,{"$f":"SUM(C20:D20)","v":0},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G20:H20)","v":{"$error":"#REF!"}},{"$f":"SUM(E20,I20)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!E20","v":0},{"$f":"Budget!J20","v":0},0,{"$f":"SUM(C21:D21)","v":0},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G21:H21)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"Budget!E21","v":0},{"$f":"Budget!K21","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E22","v":0},{"$f":"Budget!K22","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E23","v":0},{"$f":"Budget!K23","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E24","v":0},{"$f":"Budget!K24","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E25","v":0},{"$f":"Budget!K25","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E26","v":0},{"$f":"Budget!K26","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E27","v":0},{"$f":"Budget!K27","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!E28","v":" "},{"$f":"Budget!K28","v":0},0,0,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C20:C29)","v":0},0,0,null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"SUM(J20:J29)","v":{"$error":"#REF!"}}]
[]
[null,"SUPPLIES & MATERIALS (itemize)"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C33:D33)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G33:H33)","v":{"$error":"#REF!"}},{"$f":"SUM(E33,I33)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C34:D34)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C33:C42)","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"EQUIPMENT"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C46:D46)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G46:H46)","v":{"$error":"#REF!"}},{"$f":"SUM(E46,I46)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C46:C47)","v":{"$error":"#REF!"}},{"$f":"SUM(D46:D47)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$f":"SUM(J46:J47)","v":{"$error":"#REF!"}}]
[]
[null,"TRAVEL "]
[null,"MILEAGE"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C52:D52)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G52:H52)","v":{"$error":"#REF!"}},{"$f":"SUM(E52,I52)","v":{"$error":"#REF!"}}]
[null,"LODGING"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C54:D54)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G54:H54)","v":{"$error":"#REF!"}},{"$f":"SUM(E54,I54)","v":{"$error":"#REF!"}}]
[null,"MEALS"]
[null,null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C56:D56)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G56:H56)","v":{"$error":"#REF!"}},{"$f":"SUM(E56,I56)","v":{"$error":"#REF!"}}]
[null,"OTHER  (tolls, parking, etc.)"]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(C58:D58)","v":{"$error":"#REF!"}},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$f":"SUM(G58:H58)","v":{"$error":"#REF!"}},{"$f":"SUM(E58,I58)","v":{"$error":"#REF!"}}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},null,{"$f":"Budget!#REF!","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,"Subtotal",{"$f":"SUM(C58:C61,C52,C54,C56)","v":{"$error":"#REF!"}},{"$f":"SUM(D58:D61,D52,D54,D56)","v":0},{"$error":"#REF!"},null,{"$error":"#REF!"},0,{"$error":"#REF!"},{"$error":"#REF!"}]
[]
[null,"GRANT AND MATCH BUDGET"]
[null,"Subtotal",{"$f":"SUM(C62+C43+C48+C30+C17)","v":{"$error":"#REF!"}},0,{"$f":"SUM(E62+E43+E48+E30+E17)","v":{"$error":"#REF!"}},null,{"$f":"SUM(G62+G43+G48+G30+G17)","v":{"$error":"#REF!"}},0,{"$error":"#REF!"},{"$error":"#REF!"}]