{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INSTRUCTIONS","Worklog Entries","Invoice & Receipt Entries","Totals Sheet & Signatures","DNR STAFF ONLY","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[11,0,11,2],[0,0,0,2],[6,0,6,2],[8,0,8,2],[10,0,10,2],[1,0,1,2],[5,0,5,2],[7,0,7,2],[2,0,2,2],[9,0,9,2]]}
["Off-Highway Vehicle Grant-in-Aid Program\nWorksheet 1 - Worklog & Request for Reimbursement",null,null,"A"]
["This worksheet should be used to document work performed on trails enrolled in the GIA program and to request reimbursement for expenses incurred while doing so. This worksheet should be submitted, at minimum, every 90 days after purchasing of goods and services begins or after eligible expenses reach $5,000, whichever comes first."]
["There are 5 tabs within this worksheet. It is important that clubs fill out all appropriate tabs, but the \"Worklog Entries\" tab and the \"Totals Sheet\" tab are required."]
["Blue cells require your input","Green cells contain a dropdown menu","Yellow cells autofill with calculations"]
["Blue and green cells can be copied/pasted","Blue and green cells can be copied/pasted","Yellow cells cannot be copied/pasted"]
["Please fill out one line per expense per date. This may mean there are several lines for one operator on one work day. Ensure you are documenting the number of hours spent performing the specific activity, not the total number of hours in the work day. "]
["If multiple people are performing the same tasks on the same day, such as a club work day or a trail cut, you may submit a document that contains all of their names, activities, and times rather than creating a separate line on the worklog for each volunteer. You would then enter this information on a single line of the \"Worklog Entries\" tab."]
["Rows will automatically adjust in height if additional space is needed to describe work performed."]
["To request reimbursement for an invoice or receipt for supplies, enter all necessary information in the \"Invoice & Receipt Entries\" tab."]
["This worksheet contains a digital signature option. If your club prefers to use physical (wet) signatures, you may continue to do so."]
["Upon completion of this worksheet, please email the form and any supporting documents (invoices/receipts for purchases and services over $100, proof of compliance with competitive bid process guidelines (if applicable), volunteer rosters for work days, etc) to your sponsor. Please email documents as attachments; you are not required to combine any files unless you wish to do so."]
["Examples of RFRs and more information on eligible expenses can be found in the Grant-in-Aid Manual."]

{"sheet":"Worklog Entries","index":1,"n_rows":101,"n_cols":9,"rows_kept":101,"cut":false,"hidden":false,"merged":[[0,0,0,16383]]}
["Worklog Entries"]
["Date","Operator Name","Describe work performed & location","Expense Category","Type","Amount\n(hours/miles)","Item","Cost","Row Total"]
[null,null,null,null," ",null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null," ",null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", VLOOKUP(Table1[[#This Row],[Item]],Lists!$G$2:$H$28,2,FALSE))","v":""},{"$f":"IF(ISBLANK(Table1[[#This Row],[Item]]), \"\", Table1[[#This Row],[Cost]]*Table1[[#This Row],[Amount\n(hours/miles)]])","v":""}]

{"sheet":"Invoice & Receipt Entries","index":2,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Invoice & Receipt Entries"]
["Date","Contractor/Supplier","Describe costs incurred","Expense Category","Cost"]

{"sheet":"Totals Sheet & Signatures","index":3,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[35,0,35,1],[34,3,34,5],[35,3,35,5],[30,0,30,5],[32,0,32,1],[32,3,32,5],[20,3,20,4],[21,3,21,4],[22,3,22,4],[19,0,19,5],[34,0,34,1],[14,0,14,5],[25,0,25,5],[27,0,27,2],[27,3,27,4],[28,3,28,4],[26,0,26,2],[26,3,26,4],[28,0,28,2],[15,1,15,5],[16,1,16,5],[17,1,17,5],[23,3,23,4],[21,0,21,2],[22,0,22,2],[23,0,23,2],[20,0,20,2]]}
["Totals Sheet"]
["Expense Category","Total","x","Reimbursement %","=","Net"]
["Acqusition & Development",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Acquisition & Development\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Acquisition & Development\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.65,"=",{"$f":"B3*0.65","v":0}]
["Adminsitration",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Administration\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Administration\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.65,"=",{"$f":"B4*0.65","v":0}]
["Capital Improvement",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Capital Improvement\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Capital Improvement\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",1,"=",{"$f":"B5","v":0}]
["Facilities",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Facilities\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Facilities\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.65,"=",{"$f":"B6*0.65","v":0}]
["Insurance",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Insurance\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Insurance\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.9,"=",{"$f":"B7*0.9","v":0},null,"2024-10-16T19:02:50"]
["Maintenance",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Maintenance\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Maintenance\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.9,"=",{"$f":"B8*0.9","v":0}]
["New Trail Construction",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"New Trail Construction\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"New Trail Construction\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.75,"=",{"$f":"B9*0.75","v":0},null,"OK TO PAY"]
["Toilets",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Toilets\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Toilets\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.9,"=",{"$f":"B10*0.9","v":0}]
["Trail System Maps",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Trail System Maps\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Trail System Maps\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.65,"=",{"$f":"B11*0.65","v":0}]
["Winter Maintenance",{"$f":"SUMIF('Worklog Entries'!$D$3:$D$101, \"Winter Maintenance\",'Worklog Entries'!$I$3:$I$101) + SUMIF('Invoice & Receipt Entries'!$D$3:$D$101, \"Winter Maintenance\",'Invoice & Receipt Entries'!$E$3:$E$101)","v":0},"x",0.9,"=",0]
["Total expenses",{"$f":"SUM(B3:B12)","v":0},null,"Net request",null,{"$f":"SUM(F3:F12)","v":0}]
[]
["Club info"]
["Trail Name"]
["Club"]
["Sponsor"]
[]
["Grant info"]
["Which grant are you requesting reimbursement from?"]
["Total grant amount awarded"]
["Remaining balance (prior to submitting this RFR)"]
["**If requesting funds from both grants** Amount"]
[]
["Admin cap check"]
["Fiscal Year"]
["Maximum allowed admin amount (15% of total grant)",null,null,{"$f":"IF(ISBLANK(D22), \"\", D22*0.15)","v":""},null,{"$f":"IF(ISBLANK(F22), \"\", F22*0.15)","v":""}]
["Does amount being requested pass admin cap check?",null,null,{"$f":"_xlfn.IFS(ISBLANK(D22), \"\", D28>F4, \"Check passed\", D28<F4, \"Check failed\")","v":""},null,{"$f":"_xlfn.IFS(ISBLANK(F22), \"\", F28>F4, \"Check passed\", F28<F4, \"Check failed\")","v":""}]
[]
["By signing this document, I hereby certify that the materials and/or services shown above have been delivered or fulfilled, have been used foir the above specified Grant-in-Aid trail, and that attached invoices/receipts are original copies, are correct and just, and have not been previosly reimbursed."]
[]
["Trail Administrator Signature",null,null,"Sponsor Signature"]

{"sheet":"DNR STAFF ONLY","index":4,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[11,7,11,11],[10,7,10,11],[14,7,14,11],[12,7,12,11],[13,7,13,11],[16,7,16,11],[17,7,17,11],[15,7,15,11],[30,1,30,5],[31,1,31,5],[32,1,32,5],[1,1,1,5],[2,1,2,5],[3,1,3,5],[4,1,4,5],[7,0,7,5],[24,1,24,5],[25,1,25,5],[19,1,19,5],[18,1,18,5],[17,1,17,5],[12,1,12,5],[11,1,11,5],[10,4,10,5]]}
["DNR Staff Sheet"]
["Club Name"]
["Invoice Name"]
["Date"]
["Area"]
[]
["Have you received all supporting documentation? Invoices, receipts, competitive bids, etc"]
[]
[]
["Fiscal Year"]
["Grant amount","Prior to Payment",null,"After Payment",null,null,null,"Area Supervisor Signature"]
["Contract #"]
["Purchase Order #"]
["PO Line",null,"Amount",null,"Receipt #",null,null,"This invoice is approved for payment by"]
["PO Line",null,"Amount",null,"Receipt #"]
["PO Line",null,"Amount",null,"Receipt #"]
["PO Line",null,"Amount",null,"Receipt #"]
["Vendor Number"]
["Vendor Name"]
["Vendor Address"]
[]
["Only use the table below if club is requesting reimbursement from two different grants"]
["Fiscal Year"]
["Grant amount","Prior to Payment",null,"After Payment"]
["Contract #"]
["Purchase Order #"]
["PO Line",null,"Amount",null,"Receipt #"]
["PO Line",null,"Amount",null,"Receipt #"]
["PO Line",null,"Amount",null,"Receipt #"]
["PO Line",null,"Amount",null,"Receipt #"]
["Vendor Number"]
["Vendor Name"]
["Vendor Address"]

{"sheet":"Lists","index":5,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Type","Transportation","Labor","Equipment","Attachments",null,"Costs",null,null,"Categories"]
[" ",null," ",null,null,null,"Car, pickup, ATV, OHM, ORV",0.7]
["Transportation","Car, pickup, ATV, OHM, ORV","Standard labor cost - $25/hr","Small equipment","Trailer: single axle",null,"1-2 ton truck",1.05,null,"Acquisition & Development"]
["Labor","1-2 ton truck",null,"Handheld electric equipment","Trailer: tandem axle",null,"2.5-10 ton truck",1.4,null,"Administration"]
["Equipment","2.5-10 ton truck",null,"Handheld gas-powered equipment","Trailer: triple axle",null,"10+ ton truck",2.8,null,"Capital Improvement"]
["Attachments","10+ ton truck",null,"Small generator (<3,000 watts)","Non-powered attachments",null,"Standard labor cost - $25/hr",25,null,"Facilities"]
[null,null,null,"Large generator (>3,000 watts)","Power take-off or hydraulic attachments",null,"Small equipment",5,null,"Insurance"]
[null,null,null,"Other equipment 25 HP or less","Dump box <3 cubic yards",null,"Handheld electric equipment",5,null,"Maintenance"]
[null,null,null,"Other equipment 26-50 HP","Dump box 4-8 cubic yards",null,"Handheld gas-powered equipment",7.2,null,"New Trail Construction"]
[null,null,null,"Other equipment 51-80 HP","Dump box 9-12 cubic yards",null,"Small generator (<3,000 watts)",6.2,null,"Toilets"]
[null,null,null,"Other equipment 81-105 HP","Dump box 13+ cubic yards",null,"Large generator (>3,000 watts)",8.8000000000000007,null,"Trail System Maps"]
[null,null,null,"Other equipment 106-157 HP",null,null,"Other equipment 25 HP or less",25,null,"Winter Maintenance"]
[null,null,null,"Other equipment 158-205 HP",null,null,"Other equipment 26-50 HP",43.75]
[null,null,null,"Other equipment 206-250 HP",null,null,"Other equipment 51-80 HP",62.5]
[null,null,null,"Other equipment 251 HP or more",null,null,"Other equipment 81-105 HP",81.25]
[null,null,null,null,null,null,"Other equipment 106-157 HP",100]
[null,null,null,null,null,null,"Other equipment 158-205 HP",112.5]
[null,null,null,null,null,null,"Other equipment 206-250 HP",125]
[null,null,null,null,null,null,"Other equipment 251 HP or more",150]
[null,null,null,null,null,null,"Trailer: single axle",0.25]
[null,null,null,null,null,null,"Trailer: tandem axle",0.35]
[null,null,null,null,null,null,"Trailer: triple axle",0.45]
[null,null,null,null,null,null,"Non-powered attachments",18.75]
[null,null,null,null,null,null,"Power take-off or hydraulic attachments",24]
[null,null,null,null,null,null,"Dump box <3 cubic yards",6.3]
["VLOOKUP([@Item],Lists!$G$2:$H$28,2,FALSE)",null,null,null,null,null,"Dump box 4-8 cubic yards",7.5]
["IF(ISBLANK([@Item]), \"\", VLOOKUP([@Item],Lists!$G$2:$H$28,2,FALSE))",null,null,null,null,null,"Dump box 9-12 cubic yards",10.050000000000001]
[null,null,null,null,null,null,"Dump box 13+ cubic yards",12.56]