{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["SRTS Invoice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"SRTS Invoice","index":0,"n_rows":112,"n_cols":18,"rows_kept":112,"cut":false,"hidden":false,"merged":[[111,3,112,4],[111,5,112,6],[111,7,112,9],[110,0,110,9],[111,0,112,2],[25,2,25,4],[38,2,38,8],[1,0,1,9],[0,0,0,9],[81,2,81,7],[33,0,34,8],[35,0,35,9],[28,5,28,8],[29,2,29,4],[29,5,29,8],[30,0,31,8],[60,2,60,8],[61,2,61,8],[51,2,51,8],[52,2,52,8],[53,2,53,8],[54,2,54,8],[55,2,55,8],[56,2,56,8],[57,2,57,8],[58,2,58,8],[59,2,59,8],[106,3,106,9],[107,3,107,9],[108,2,108,9],[98,5,98,7],[98,0,98,4],[104,4,104,7],[76,2,76,6],[77,2,77,6],[78,0,79,8],[92,0,93,8],[107,0,108,1],[101,0,102,1],[105,0,105,9],[98,8,98,9],[87,2,87,7],[88,2,88,7],[89,2,89,7],[90,2,90,7],[104,0,104,3],[80,0,80,9],[100,0,100,1],[91,2,91,7],[2,0,2,9],[81,0,81,1],[23,0,24,1],[6,0,6,9],[10,2,10,3],[3,6,4,7],[5,6,5,7],[24,5,24,8],[24,2,24,4],[3,0,4,3],[14,2,14,3],[20,0,21,8],[9,2,9,3],[16,2,16,3],[23,9,24,9],[23,2,23,8],[64,0,64,9],[65,2,65,6],[75,2,75,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[103,0,103,9],[106,0,106,1],[104,8,104,9],[100,2,100,9],[101,2,101,6],[22,0,22,9],[65,0,65,1],[32,0,32,9],[27,5,27,8],[62,0,63,8],[99,0,99,9],[85,2,85,7],[86,2,86,7],[102,2,102,3],[102,4,102,8],[82,2,82,7],[83,2,83,7],[84,2,84,7],[28,2,28,4],[25,5,25,8],[26,2,26,4],[26,5,26,8],[27,2,27,4],[97,0,97,9],[0,13,1,13],[18,2,18,3],[19,2,19,3],[7,2,7,3],[5,0,5,3],[3,4,3,5],[3,8,5,9],[13,2,13,3],[12,2,12,3],[15,2,15,3],[11,2,11,3],[8,2,8,3],[7,0,7,1],[17,2,17,3],[36,0,36,1],[95,0,96,8],[94,0,94,9],[48,2,48,8],[49,2,49,8],[50,2,50,8],[39,2,39,8],[40,2,40,8],[41,2,41,8],[42,2,42,8],[69,2,69,6],[43,2,43,8],[44,2,44,8],[45,2,45,8],[46,2,46,8],[47,2,47,8],[73,2,73,6],[74,2,74,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[36,2,36,8],[37,2,37,8]]}
["SAFE ROUTES TO SCHOOL SUBCONSULTANT INVOICE",null,null,null,null,null,null,null,null,null,null,null,null,"Include"]
["Payment terms: Net 10 days following MDOT reimbursement to MFF. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
["Organization Name",null,null,null,"Billing Period",null,"Invoice / Ref #",null,"2025-0006 SRTS - \nJN 220282(NI)",null,null,null,null,"y"]
[null,null,null,null,"Start","End",null,null,null,null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y",null,"Max","Max","Max"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y",null,{"$f":"MAX(P8:P23)","v":0},{"$f":"MAX(Q8:Q23)","v":0},{"$f":"MAX(R8:R23)","v":0}]
[{"$f":"IF(N24=\"y\",\"A1\",\"A\")","v":"A"},null,"Employees For each staff person, list name and title, then hourly rate, hours worked, and fringe rate for reporting period.",null,"Hourly Rate","Hours","Salary This Period","Fringe Rate(%)","Fringe This Period","Total",null,null,null,"y",null,"# decimal hourly rate","# decimal hours","# decimal fringe rate"]
[1,null,null,null,null,null,{"$f":"ROUND(E9*F9,2)","v":0},null,{"$f":"ROUND(G9*H9,2)","v":0},{"$f":"G9+I9","v":0},"Employees",null,null,"y",null,{"$f":"IFERROR(LEN(RIGHT(E9,LEN(E9)-FIND(\".\",E9))),0)","v":0},{"$f":"IFERROR(LEN(RIGHT(F9,LEN(F9)-FIND(\".\",F9))),0)","v":0},{"$f":"IFERROR(LEN(RIGHT(H9,LEN(H9)-FIND(\".\",H9))),0)","v":0}]
[{"$f":"A9+1","v":2},null,null,null,null,null,0,null,0,0,"Employees",null,null,"y",null,{"$f":"IFERROR(LEN(RIGHT(E10,LEN(E10)-FIND(\".\",E10))),0)","v":0},{"$f":"IFERROR(LEN(RIGHT(F10,LEN(F10)-FIND(\".\",F10))),0)","v":0},{"$f":"IFERROR(LEN(RIGHT(H10,LEN(H10)-FIND(\".\",H10))),0)","v":0}]
[3,null,null,null,null,null,0,null,0,0,"Employees",null,null,{"$f":"IF(C10<>\"\",\"y\",IF(C11<>\"\",\"y\",IF(J11<>0,\"y\",\"n\")))","v":"n"},null,0,0,0]
[4,null,null,null,null,null,0,null,0,0,"Employees",null,null,{"$f":"IF(C11<>\"\",\"y\",IF(C12<>\"\",\"y\",IF(J12<>0,\"y\",\"n\")))","v":"n"},null,0,0,0]
[5,null,null,null,null,null,0,null,0,0,"Employees",null,null,"n",null,0,0,0]
[6,null,null,null,null,null,0,null,0,0,"Employees",null,null,"n",null,0,0,0]
[7,null,null,null,null,null,0,null,0,0,"Employees",null,null,"n",null,0,0,0]
[8,null,null,null,null,null,0,null,0,0,"Employees",null,null,"n",null,0,0,0]
[9,null,null,null,null,null,0,null,0,0,"Employees",null,null,"n",null,0,0,0]
[{"$f":"A17+1","v":10},null,null,null,null,null,0,null,0,0,"Employees",null,null,"n",null,0,0,0]
[11,null,null,null,null,null,{"$f":"ROUND(E19*F19,2)","v":0},null,{"$f":"ROUND(G19*H19,2)","v":0},{"$f":"G19+I19","v":0},"Employees",null,null,"n",null,0,0,0]
[12,null,null,null,null,null,0,null,0,0,"Employees",null,null,"n",null,0,0,0]
["Employees",null,null,null,null,null,null,null,null,null,null,null,null,"y",null,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J8:J21)","v":0},null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
["A2",null,"Contracted Staff List contracted staff name, type of service, and service period.",null,null,null,null,null,null,"Total",null,null,null,{"$f":"IF(N26=\"y\",\"y\",IF(N27=\"y\",\"y\",IF(N28=\"y\",\"y\",IF(N32=\"y\",\"y\",\"n\"))))","v":"n"}]
[null,null,"Contractor Name",null,null,"Type of Service and Service Period",null,null,null,null,null,null,null,{"$f":"N24","v":"n"}]
[1,null,null,null,null,null,null,null,null,null,"Contracted Staff",null,null,{"$f":"IF(C26<>\"\",\"y\",IF(J26<>0,\"y\",\"n\"))","v":"n"}]
[{"$f":"A26+1","v":2},null,null,null,null,null,null,null,null,null,"Contracted Staff",null,null,{"$f":"IF(C26<>\"\",\"y\",IF(C27<>\"\",\"y\",IF(J27<>0,\"y\",\"n\")))","v":"n"}]
[3,null,null,null,null,null,null,null,null,null,"Contracted Staff",null,null,"n"]
[4,null,null,null,null,null,null,null,null,null,"Contracted Staff",null,null,"n"]
[5,null,null,null,null,null,null,null,null,null,"Contracted Staff",null,null,"n"]
["Contracted Staff",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N$32","v":"n"}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J24:J31)","v":0},null,null,null,{"$f":"IF(J32<>0,\"y\",\"n\")","v":"n"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N$32","v":"n"}]
["PERSONNEL TOTAL - EMPLOYEES AND CONTRACTED",null,null,null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,{"$f":"J22+J32","v":0},null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
["B",null,"Supplies and Materials List program expense category (e.g., 1A-Printing), brief description, (e.g., Staples Orders 5/15/26) and amount. Attach copies of receipts or proof of payment. If any expenses are allocated, show calculation of amount charged.",null,null,null,null,null,null,"Total",null,null,null,"y"]
[1,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"y"]
[{"$f":"A38+1","v":2},null,null,null,null,null,null,null,null,null,"Supplies",null,null,"y"]
[3,null,null,null,null,null,null,null,null,null,"Supplies",null,null,{"$f":"IF(C39<>\"\",\"y\",IF(C40<>\"\",\"y\",IF(J40<>0,\"y\",\"n\")))","v":"n"}]
[4,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[5,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[6,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[7,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[8,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[9,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[10,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[11,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[12,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[13,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[14,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[15,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[16,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[17,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[18,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[19,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[20,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[21,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[22,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[23,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[24,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
[25,null,null,null,null,null,null,null,null,null,"Supplies",null,null,"n"]
["SUPPLIES AND MATERIALS",null,null,null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J37:J63)","v":0},null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
["C",null,"Travel List travel expenses by staff person. In an accompanying travel log include staff name, site locations, mileage, and mileage rate. Also include itemized receipts or proof of payment for any other travel-related expenses.",null,null,null,null,"Mileage $ Amount","Other $ Amount","Total",null,null,null,"y"]
[1,null,null,null,null,null,null,null,null,{"$f":"ROUND(H67+I67,2)","v":0},"Travel",null,null,"y"]
[{"$f":"A67+1","v":2},null,null,null,null,null,null,null,null,{"$f":"ROUND(H68+I68,2)","v":0},"Travel",null,null,"y"]
[3,null,null,null,null,null,null,null,null,0,"Travel",null,null,{"$f":"IF(C68<>\"\",\"y\",IF(C69<>\"\",\"y\",IF(J69<>0,\"y\",\"n\")))","v":"n"}]
[4,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
[5,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
[6,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
[7,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
[8,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
[9,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
[10,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
[11,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
[12,null,null,null,null,null,null,null,null,0,"Travel",null,null,"n"]
["TRAVEL",null,null,null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J66:J79)","v":0},null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
["D",null,"Miscellaneous / Administrative List amount and purpose. Attach copies of receipts or proof of payment. If any expenses are allocated, show calculation of amount charged.",null,null,null,null,null,"Receipt Date","Total",null,null,null,"y"]
[1,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,"y"]
[{"$f":"A83+1","v":2},null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,{"$f":"IF(C83<>\"\",\"y\",IF(C84<>\"\",\"y\",IF(J84<>0,\"y\",\"n\")))","v":"n"}]
[3,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,{"$f":"IF(C84<>\"\",\"y\",IF(C85<>\"\",\"y\",IF(J85<>0,\"y\",\"n\")))","v":"n"}]
[4,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,{"$f":"IF(C85<>\"\",\"y\",IF(C86<>\"\",\"y\",IF(J86<>0,\"y\",\"n\")))","v":"n"}]
[5,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,{"$f":"IF(C86<>\"\",\"y\",IF(C87<>\"\",\"y\",IF(J87<>0,\"y\",\"n\")))","v":"n"}]
[6,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,"n"]
[7,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,"n"]
[8,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,"n"]
[9,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,"n"]
[10,null,null,null,null,null,null,null,null,null,"Space/Misc/Admin",null,null,"n"]
["MISCELLANEOUS / ADMINISTRATIVE",null,null,null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J82:J93)","v":0},null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
["NON-PERSONNEL TOTAL - PROGRAM EXPENSES, TRAVEL, MISC./ADMIN.",null,null,null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,{"$f":"J64+J80+J94","v":0},null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,null,null,null,"SUBTOTAL",null,null,{"$f":"SUM(J35,J64,J80,J94)","v":0},null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
["E",null,"Indirect Costs",null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,"1.  Indirect Cost Rate",null,null,null,null,"Percentage",null,{"$f":"ROUND(I99*I102,2)","v":0},null,null,null,"y"]
[null,null,"2.  Indirect Cost Amount (if not applied to MTDC) \nDescribe basis (e.g. % of salary and fringe) and enter $ amount in column J.",null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,null,null,"INVOICE AMOUNT",null,null,null,{"$f":"I99+J102+J103","v":0},null,null,null,null,"y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"y"]
["F",null,"Authorized Signature and Date",null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,"Printed name of signer",null,null,null,null,null,null,null,null,null,null,"y"]
[null,null,"By my signature, I certify that all payments disbursed by our office are for the purposes outlined in my agency's 2025-0006 Subconsultant SRTS agreement.",null,null,null,null,null,null,null,null,null,null,"y"]
[]
["For MFF Use Only"]
["QC: ",null,null,"SRTS Coordinator Review:",null,"Prg. Ops. Review:",null,"Approval: "]