{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Cost-Share Rates","APPLICATION_1","APPLICATION_2","APPLICATION_3","RULES - Attachment","Worksheet_1","Worksheet_2","Worksheet_3","Worksheet_4","Invoice","NMP Certification","Lists"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":85,"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":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,8,5]]}
[]
[null,"Double click on Word document for instructions on how to fill out this application."]

{"sheet":"Cost-Share Rates","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"APPLICATION_1","index":2,"n_rows":50,"n_cols":30,"rows_kept":50,"cut":false,"hidden":false,"merged":[[26,0,26,2],[18,2,18,5],[18,6,18,7],[18,8,18,10],[18,11,18,12],[23,5,23,19],[32,3,32,5],[30,3,30,5],[21,0,22,9],[21,10,22,10],[31,3,31,5],[29,6,29,7],[29,0,33,2],[33,3,33,15],[30,8,30,10],[29,8,29,11],[29,12,29,15],[30,12,30,15],[31,6,31,7],[32,6,32,7],[31,8,31,10],[31,12,31,15],[30,16,30,19],[28,0,28,19],[29,3,29,5],[29,16,29,19],[30,6,30,7],[32,12,32,15],[13,0,13,19],[14,0,14,4],[25,0,25,4],[25,5,25,19],[14,5,14,13],[15,5,15,13],[16,0,16,4],[16,5,16,13],[16,14,16,16],[14,14,14,16],[17,0,17,4],[17,5,17,19],[18,13,18,19],[20,0,20,19],[23,0,23,4],[0,14,0,19],[7,0,7,19],[8,0,8,19],[10,0,10,3],[11,0,12,3],[11,19,12,20],[11,13,12,14],[10,10,10,14],[11,15,12,18],[10,4,10,9],[11,4,12,9],[11,12,12,12],[11,10,12,11],[42,0,46,19],[35,0,37,2],[35,3,36,6],[35,7,36,9],[35,16,36,19],[35,10,36,11],[37,16,37,19],[38,16,39,19],[41,0,41,19],[39,0,40,12],[39,13,39,15],[38,0,38,15],[37,3,37,5],[37,7,37,8],[14,18,14,20],[16,18,16,20],[15,14,15,20],[37,10,37,11],[35,12,36,15],[37,12,37,15],[26,13,26,14],[26,15,26,19],[33,16,33,19],[32,16,32,19],[26,3,26,12],[24,0,24,4],[24,5,24,19],[18,0,18,1],[15,0,15,4],[31,16,31,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*** For MDA Use ***"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreement No.: ________________"]
[null,null,null,null,"Maryland Department of Agriculture",null,null,null,null,null,null,null,null,null,"Date Received: ________________"]
[null,null,null,null,"MANURE TRANSPORT PROJECT PROGRAM",null,null,null,null,null,null,null,null,null,"MACS #: ______________"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"By: _________",null,null,"Date: __________"]
[]
[]
["FAST TRACK APPLICATION — LIVESTOCK"]
["For the Transport of Land-Applied Livestock Manure"]
[]
["Conservation District",null,null,null,"District contact person (If assisted)",null,null,null,null,null,"Transport Date(s)",null,null,null,null,null,"Agreement No."]
[null,null,null,null,null,null,null,null,null,null,null,null,"to",null,null,null,null,null,null,"MT"]
[]
["1. Applicant Information"]
["Applicant Legal Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"SSN (last 4 digits)",null,null,"-----"]
["Farm or Business Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,"or"]
["Mailing Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,"EIN (last 4 digits)",null,null,"-----"]
["City/StateZIP:"]
["County:",null,null,null,null,null,"Phone:",null,null,null,null,"Email:"]
[]
["2. Sending Operation (Operation that produced the manure)"]
["CHECK BOX IF APPLICANT IS THE SENDING OPERATION:"]
[]
["Operator Name:"]
["Farm Name:"]
["Address of Farm:"]
["City/State/ZIP:",null,null,null,null,null,null,null,null,null,null,null,null,"County:"]
[]
["3. Manure Amounts and Eligible Payment (Complete page 2 and the Worksheets before completing this section)"]
["Transport",null,null,"Manure Type",null,null,"Acres",null,"Amount (gal / ton)",null,null,null,"Invoices*",null,null,null,"Transport Costs"]
[null,null,null,"SOLID",null,null,{"$f":"X31","v":0},null,{"$f":"X32","v":0},null,null,"tons",null,null,null,null,{"$f":"IF(M31=\"\",\"\",MIN(AC31,M31))","v":""},null,null,null,null,null,null,{"$f":"Worksheet_1!X47+Worksheet_2!X47+Worksheet_3!X47+Worksheet_4!X47","v":0},"SOLID acres",null,null,null,{"$f":"Worksheet_1!S45+Worksheet_2!S45+Worksheet_3!S45+Worksheet_4!S45","v":0},"SOLID transport"]
[null,null,null,"LIQUID",null,null,{"$f":"X33","v":0},null,{"$f":"X34","v":0},null,null,"gal",null,null,null,null,{"$f":"IF(M32=\"\",\"\",MIN(AC32,M32))","v":""},null,null,null,null,null,null,{"$f":"Worksheet_1!X48+Worksheet_2!X48+Worksheet_3!X48+Worksheet_4!X48","v":0},"SOLID tons",null,null,null,{"$f":"Worksheet_1!T45+Worksheet_2!T45+Worksheet_3!T45+Worksheet_4!T45","v":0},"LIQUID transport"]
[null,null,null,"Totals:",null,null,{"$f":"G31+G32","v":0},null,null,null,null,null,{"$f":"M31+M32","v":0},null,null,null,{"$f":"IF(AND(ISBLANK(Q31),ISBLANK(Q32)),\"\",SUM(Q31,Q32))","v":0},null,null,null,null,null,null,{"$f":"Worksheet_1!X49+Worksheet_2!X49+Worksheet_3!X49+Worksheet_4!X49","v":0},"LIQUID TRANSPORT acres"]
[null,null,null,"Transport cost-share equals 87.5% of actual costs, or $15,000 (whichever is less)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Q33),\"\",MIN(Q33*0.875,15000))","v":0},null,null,null,null,null,null,{"$f":"Worksheet_1!X50+Worksheet_2!X50+Worksheet_3!X50+Worksheet_4!X50","v":0},"LIQUID TRANSPORT gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Worksheet_1!X51+Worksheet_2!X51+Worksheet_3!X51+Worksheet_4!X51","v":0},"LIQUID TRANSPORT NOT INJECTED acres"]
["Injection",null,null,"Acres Eligible for Transport & Injection",null,null,null,"Acres Eligible for Injection Only",null,null,"All Injection Acres",null,"Invoices*",null,null,null,"Injection Costs",null,null,null,null,null,null,{"$f":"Worksheet_1!X52+Worksheet_2!X52+Worksheet_3!X52+Worksheet_4!X52","v":0},"LIQUID TRANSPORT also INJECTED gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Worksheet_1!X53+Worksheet_2!X53+Worksheet_3!X53+Worksheet_4!X53","v":0},"INJECTION acres (all)"]
[null,null,null,{"$f":"X39","v":0},null,null,"+",{"$f":"X40","v":0},null,"=",{"$f":"X39+X40","v":0},null,null,null,null,null,{"$f":"IF(M38=\"\",\"\",MIN(K38*45,M38))","v":""},null,null,null,null,null,null,{"$f":"Worksheet_1!X54+Worksheet_2!X54+Worksheet_3!X54+Worksheet_4!X54","v":0},"INJECTION ONLY gallons"]
["*Add up and attach all invoices for transport and injection performed by the applicant, third parties, and custom haulers.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(ISBLANK(Q34),ISBLANK(Q38)),\"\",SUM(Q34,Q38))","v":0},null,null,null,null,null,null,{"$f":"Worksheet_1!X55+Worksheet_2!X55+Worksheet_3!X55+Worksheet_4!X55","v":0},"INJECTION and TRANSPORT acres"]
["Cost-share is based on 87.5% of eligible transport costs up to a maximum of $15,000, plus a maximum of $45/acre for injection costs.",null,null,null,null,null,null,null,null,null,null,null,null,"PAYMENT:",null,null,null,null,null,null,null,null,null,{"$f":"Worksheet_1!X56+Worksheet_2!X56+Worksheet_3!X56+Worksheet_4!X56","v":0},"INJECTION ONLY acres"]
[]
["4. Signature of Applicant"]
["I certify that the contents of this Application are true to the best of my knowledge, information, and belief. I further certify that I have read the rules atached to this Application for participating in the Manure Transport Project Program (\"MTPP\"). I acknowledge that if I fail to comply with any of the applicable MTPP rules or provide false information in this Application, such actions may result in: (1) being excluded from future MTPP participation, (2) having my payment denied, and (3) being liable to return the full amount of any payment made. I further acknowledge that my application for payment is subject to availability of funds, and that my application may be denied if I am non-compliant with Maryland Department of Agriculture (\"MDA\") programs. I understand that submitting false information may subject me to a civil penalty under State law of not more than $10,000 for each violation and an additional amount of not more than threee times the amount of damages that MDA has sustained."]
[]
[]
[]
[]
[]
[]
["Applicant signature",null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"APPLICATION_2","index":3,"n_rows":33,"n_cols":22,"rows_kept":33,"cut":false,"hidden":false,"merged":[[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[10,9,10,14],[11,9,11,14],[12,9,12,14],[5,15,5,19],[6,15,6,19],[7,15,7,19],[8,15,8,19],[9,15,9,19],[5,9,5,14],[6,9,6,14],[6,5,6,8],[7,5,7,8],[6,0,6,1],[7,0,7,1],[3,0,3,21],[4,0,4,21],[10,15,10,19],[11,15,11,19],[12,15,12,19],[12,0,12,1],[13,0,13,1],[10,5,10,8],[11,5,11,8],[12,5,12,8],[13,5,13,8],[8,5,8,8],[9,5,9,8],[8,0,8,1],[9,0,9,1],[13,15,13,19],[13,9,13,14],[5,2,5,4],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,2,9,4],[21,0,21,21],[0,0,0,7],[24,16,24,18],[25,19,25,21],[26,19,26,21],[25,1,25,4],[26,1,26,4],[23,19,23,21],[24,19,24,21],[24,1,24,4],[22,16,22,18],[22,19,22,21],[22,8,22,10],[23,1,23,4],[23,5,23,7],[23,8,23,10],[23,16,23,18],[22,1,22,4],[22,5,22,7],[22,12,22,15],[23,12,23,15],[1,0,1,8],[10,0,10,1],[11,0,11,1],[25,16,25,18],[5,5,5,8],[5,0,5,1],[26,16,26,18],[27,16,27,18],[28,16,28,18],[27,1,27,4],[28,5,28,7],[28,8,28,10],[24,5,24,7],[25,5,25,7],[24,12,24,15],[25,12,25,15],[24,8,24,10],[25,8,25,10],[20,0,20,21],[15,0,15,7],[15,8,15,11],[15,12,15,19],[27,19,27,21],[28,19,28,21],[7,9,7,14],[8,9,8,14],[9,9,9,14],[29,1,29,4],[26,12,26,15],[27,12,27,15],[28,12,28,15],[29,12,29,15],[32,12,32,15],[32,5,32,7],[29,8,29,10],[30,8,30,10],[29,5,29,7],[30,5,30,7],[31,5,31,7],[26,5,26,7],[27,5,27,7],[26,8,26,10],[27,8,27,10],[30,1,30,4],[31,1,31,4],[32,1,32,4],[28,1,28,4],[31,8,31,10],[32,8,32,10],[29,19,29,21],[30,19,30,21],[31,19,31,21],[32,19,32,21],[29,16,29,18],[30,16,30,18],[31,16,31,18],[32,16,32,18],[30,12,30,15],[31,12,31,15]]}
["Maryland Department of Agriculture",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAST TRACK APPLICATION"]
["MANURE TRANSPORT PROJECT PROGRAM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreement:",null,"____________"]
["5. Manure Sources"]
["List up to 8 manure sources and the location of each. A source will typically be a structure designed to store manure until it can be land-applied. For example: storage tank, pit, lagoon, covered HUA, dry stack pad."]
["Source",null,"Animal Type",null,null,"Consistency1",null,null,null,"Farm Name or Tract #2",null,null,null,null,null,"Property Account ID"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[]
["If Animal type is \"Other,\" please specify:",null,null,null,null,null,null,null,null,null,null,null,"Manure analysis < 2 yrs old must be submitted."]
["NOTES:"]
["1 Based on percent moisture from a manure analysis: SOLID/SEMI-SOLID = 0−82.9%; LIQUID/SLURRY = 83−99.9%."]
["2 Name of the farm or tract number on which the manure storage is located."]
[]
["6. Farms Receiving Manure"]
["List all farms/properties receiving manure. After entering the farms in this table, they will appear in a drop down menu on the worksheets. If a farm or tract encompasses more than one tax parcel, choose and list just one Property Account ID to represent that farm."]
[null,"Farm Name",null,null,null,"Farm / Tract #\n(Optional)",null,null,"Property Acct ID\n(List one per farm)",null,null,null,"Farm Name",null,null,null,"Farm / Tract #\n(optional)",null,null,"Property Acct ID\n(List one per farm)"]
[1,null,null,null,null,null,null,null,null,null,null,11]
[2,null,null,null,null,null,null,null,null,null,null,12]
[3,null,null,null,null,null,null,null,null,null,null,13]
[4,null,null,null,null,null,null,null,null,null,null,14]
[5,null,null,null,null,null,null,null,null,null,null,15]
[6,null,null,null,null,null,null,null,null,null,null,16]
[7,null,null,null,null,null,null,null,null,null,null,17]
[8,null,null,null,null,null,null,null,null,null,null,18]
[9,null,null,null,null,null,null,null,null,null,null,19]
[10,null,null,null,null,null,null,null,null,null,null,20]

{"sheet":"APPLICATION_3","index":4,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[[8,1,9,21],[30,0,30,4],[30,17,30,21],[24,0,24,21],[23,0,23,21],[20,1,20,20],[21,3,21,21],[22,1,22,21],[25,1,25,15],[0,0,0,7],[7,0,7,21],[4,0,4,21],[5,0,5,21],[1,0,1,9],[33,0,35,12],[33,13,35,21],[28,0,28,21],[31,0,32,4],[31,17,32,21],[29,0,29,21],[30,9,30,12],[31,9,32,12],[30,5,32,8],[30,13,32,16]]}
["Maryland Department of Agriculture"]
["MANURE TRANSPORT PROJECT PROGRAM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreement:"]
[]
["FAST TRACK  APPLICATION — LIVESTOCK"]
["For the Transport of Land-Applied Livestock Manure"]
[]
["7. Signature of Sending Operation (Only if different from applicant)"]
[null,"Signature of the sending operation acknowledges that manure generated on their operation was transported to the applicant."]
[]
[]
[]
[]
[null,"Sender (signature)",null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[]
[null,"Print Name"]
[]
[]
[null,"Please print, sign, and mail this application along with all supporting documents to:"]
[null,null,null,"Maryland Department of Agriculture\nConservation Grants, Rm 207\n50 Harry S. Truman Pkwy\nAnnapolis, MD 21401"]
[null,"For questions, contact your local Soil Conservation District office\nor\nMDA Manure Transport Program Office at:  410-841-5864"]
["*** Below for MDA Use ***"]
["8. Comments"]
[null,{"$f":"CONCATENATE(\"Injected gallons is:  \",APPLICATION_1!$X36+APPLICATION_1!$X38,\"  \",\"gallons\")","v":"Injected gallons is:  0  gallons"}]
[]
[]
["9. Approval for Payment"]
["THE MARYLAND DEPARTMENT OF AGRICULTURE RECOMMENDS NET PAYMENT FOR THIS PROJECT AS SHOWN BELOW."]
["Extent Performed",null,null,null,null,null,null,null,null,"Fund Code",null,null,null,null,null,null,null,"Payment Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$"]
[]
["MDA Signature",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]

{"sheet":"RULES - Attachment","index":5,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Maryland Department of Agriculture"]
["MANURE TRANSPORT PROJECT PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreement: ________________"]

{"sheet":"Worksheet_1","index":6,"n_rows":56,"n_cols":25,"rows_kept":56,"cut":false,"hidden":false,"merged":[[5,10,5,13],[8,10,9,10],[5,1,5,2],[7,0,7,13],[8,4,9,4],[8,1,9,1],[8,0,9,0],[5,7,5,9],[8,11,9,11],[8,2,9,2],[8,12,9,13],[8,6,9,6],[8,3,9,3],[38,12,38,13],[8,18,8,19],[8,15,9,15],[8,14,9,14],[8,16,9,16],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[37,12,37,13],[31,12,31,13],[39,12,39,13],[3,5,3,8],[28,12,28,13],[21,12,21,13],[22,12,22,13],[8,5,9,5],[15,12,15,13],[16,12,16,13],[17,12,17,13],[13,12,13,13],[14,12,14,13],[11,12,11,13],[12,12,12,13],[10,12,10,13],[23,12,23,13],[43,12,43,13],[44,0,45,2],[7,14,7,16],[8,7,8,8],[44,9,45,9],[44,12,45,13],[44,8,45,8],[8,9,9,9],[18,12,18,13],[19,12,19,13],[20,12,20,13],[40,12,40,13],[41,12,41,13],[42,12,42,13],[29,12,29,13],[30,12,30,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13]]}
["Maryland Department of Agriculture"]
["MANURE TRANSPORT PROJECT PROGRAM",null,null,null,null,null,null,null,null,"WORKSHEET FOR LIVESTOCK MANURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreement: ____________________"]
["MANURE APPLICATION ─ Fields Receiving Manure from:"]
[]
["Animal Type:",null,null,null,null,null,null,"Manure Consistency:"]
[]
["Enter Field Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Transporter and Injector Information",null,null,null,null,null,null,"(Cost-share)"]
["Receiving Farm Name","Farm/Tract #\n(optional)","Field Number","Crop1","Soil\nP-FIV2","Date of Soil Test","Applied Acres","Manure Application",null,"Units","Manure Injection?","Distance Category (miles)","Maximum Cost-Share by Field",null,"Transporter\n(Name of person, farm or custom operator)","Injected By\n(Name of person, farm or custom operator)","Date(s) applied",null,"(Rate per 1000 gal)",null,null,"MI only"]
[null,null,null,null,null,null,null,"Rate3","Total",null,null,null,null,null,null,null,null,null,"Solid MT","Liq MT only","MI only?","($45 x Acre)","Crop code"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",G11*H11)","v":""},{"$f":"IF(AND(I11>0,$K$6=\"Liquid/Slurry\"),\"gal\",IF(AND(I11>0,$K$6=\"Solid/Semi-solid\"),\"tons\",\"\"))","v":""},null,null,{"$f":"IF(OR(I11=\"\",E11=\"\",E11>499),\"\",PRODUCT(MAX(S11:T11),I11)+V11)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I11),0,IF(AND($K$6=\"Solid/Semi-solid\",E11<=100,W11<9,L11<>\"\"),VLOOKUP(L11,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I11),0,IF(AND($K$6=\"Liquid/Slurry\",E11<=100,W11<9,L11<>\"\",U11<>\"Yes\"),VLOOKUP(L11,Lists!$A$45:$C$52,3,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I11),\"\",IF(AND(AND($K$6=\"Liquid/Slurry\",K11=\"Yes\",E11<500),OR(E11>100,W11>8,L11=\"< 1 mile\",L11=\"Out-of-state\")),\"Yes\",\"\"))","v":""},{"$f":"IF(K11=\"Yes\",G11*45,0)","v":0},{"$f":"IF(ISBLANK(D11),0,VLOOKUP(D11,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H12=\"\",\"\",G12*H12)","v":""},"",null,null,{"$f":"IF(OR(I12=\"\",E12=\"\",E12>499),\"\",PRODUCT(MAX(S12:T12),I12)+V12)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I12),0,IF(AND($K$6=\"Solid/Semi-solid\",E12<=100,W12<9,L12<>\"\"),VLOOKUP(L12,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I12),0,IF(AND($K$6=\"Liquid/Slurry\",E12<=100,W12<9,L12<>\"\",U12<>\"Yes\"),VLOOKUP(L12,Lists!$A$45:$C$52,3,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I12),\"\",IF(AND(AND($K$6=\"Liquid/Slurry\",K12=\"Yes\",E12<500),OR(E12>100,W12>8,L12=\"< 1 mile\",L12=\"Out-of-state\")),\"Yes\",\"\"))","v":""},{"$f":"IF(K12=\"Yes\",G12*45,0)","v":0},{"$f":"IF(ISBLANK(D12),0,VLOOKUP(D12,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I13),0,IF(AND($K$6=\"Solid/Semi-solid\",E13<=100,W13<9,L13<>\"\"),VLOOKUP(L13,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I13),0,IF(AND($K$6=\"Liquid/Slurry\",E13<=100,W13<9,L13<>\"\",U13<>\"Yes\"),VLOOKUP(L13,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D13),0,VLOOKUP(D13,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I14),0,IF(AND($K$6=\"Solid/Semi-solid\",E14<=100,W14<9,L14<>\"\"),VLOOKUP(L14,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I14),0,IF(AND($K$6=\"Liquid/Slurry\",E14<=100,W14<9,L14<>\"\",U14<>\"Yes\"),VLOOKUP(L14,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D14),0,VLOOKUP(D14,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I15),0,IF(AND($K$6=\"Solid/Semi-solid\",E15<=100,W15<9,L15<>\"\"),VLOOKUP(L15,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I15),0,IF(AND($K$6=\"Liquid/Slurry\",E15<=100,W15<9,L15<>\"\",U15<>\"Yes\"),VLOOKUP(L15,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D15),0,VLOOKUP(D15,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I16),0,IF(AND($K$6=\"Solid/Semi-solid\",E16<=100,W16<9,L16<>\"\"),VLOOKUP(L16,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I16),0,IF(AND($K$6=\"Liquid/Slurry\",E16<=100,W16<9,L16<>\"\",U16<>\"Yes\"),VLOOKUP(L16,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D16),0,VLOOKUP(D16,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I17),0,IF(AND($K$6=\"Solid/Semi-solid\",E17<=100,W17<9,L17<>\"\"),VLOOKUP(L17,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I17),0,IF(AND($K$6=\"Liquid/Slurry\",E17<=100,W17<9,L17<>\"\",U17<>\"Yes\"),VLOOKUP(L17,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D17),0,VLOOKUP(D17,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I18),0,IF(AND($K$6=\"Solid/Semi-solid\",E18<=100,W18<9,L18<>\"\"),VLOOKUP(L18,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I18),0,IF(AND($K$6=\"Liquid/Slurry\",E18<=100,W18<9,L18<>\"\",U18<>\"Yes\"),VLOOKUP(L18,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D18),0,VLOOKUP(D18,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I19),0,IF(AND($K$6=\"Solid/Semi-solid\",E19<=100,W19<9,L19<>\"\"),VLOOKUP(L19,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I19),0,IF(AND($K$6=\"Liquid/Slurry\",E19<=100,W19<9,L19<>\"\",U19<>\"Yes\"),VLOOKUP(L19,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D19),0,VLOOKUP(D19,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I20),0,IF(AND($K$6=\"Solid/Semi-solid\",E20<=100,W20<9,L20<>\"\"),VLOOKUP(L20,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I20),0,IF(AND($K$6=\"Liquid/Slurry\",E20<=100,W20<9,L20<>\"\",U20<>\"Yes\"),VLOOKUP(L20,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D20),0,VLOOKUP(D20,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I21),0,IF(AND($K$6=\"Solid/Semi-solid\",E21<=100,W21<9,L21<>\"\"),VLOOKUP(L21,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I21),0,IF(AND($K$6=\"Liquid/Slurry\",E21<=100,W21<9,L21<>\"\",U21<>\"Yes\"),VLOOKUP(L21,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D21),0,VLOOKUP(D21,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I22),0,IF(AND($K$6=\"Solid/Semi-solid\",E22<=100,W22<9,L22<>\"\"),VLOOKUP(L22,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I22),0,IF(AND($K$6=\"Liquid/Slurry\",E22<=100,W22<9,L22<>\"\",U22<>\"Yes\"),VLOOKUP(L22,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D22),0,VLOOKUP(D22,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I23),0,IF(AND($K$6=\"Solid/Semi-solid\",E23<=100,W23<9,L23<>\"\"),VLOOKUP(L23,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I23),0,IF(AND($K$6=\"Liquid/Slurry\",E23<=100,W23<9,L23<>\"\",U23<>\"Yes\"),VLOOKUP(L23,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D23),0,VLOOKUP(D23,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I24),0,IF(AND($K$6=\"Solid/Semi-solid\",E24<=100,W24<9,L24<>\"\"),VLOOKUP(L24,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I24),0,IF(AND($K$6=\"Liquid/Slurry\",E24<=100,W24<9,L24<>\"\",U24<>\"Yes\"),VLOOKUP(L24,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D24),0,VLOOKUP(D24,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I25),0,IF(AND($K$6=\"Solid/Semi-solid\",E25<=100,W25<9,L25<>\"\"),VLOOKUP(L25,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I25),0,IF(AND($K$6=\"Liquid/Slurry\",E25<=100,W25<9,L25<>\"\",U25<>\"Yes\"),VLOOKUP(L25,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D25),0,VLOOKUP(D25,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I26),0,IF(AND($K$6=\"Solid/Semi-solid\",E26<=100,W26<9,L26<>\"\"),VLOOKUP(L26,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I26),0,IF(AND($K$6=\"Liquid/Slurry\",E26<=100,W26<9,L26<>\"\",U26<>\"Yes\"),VLOOKUP(L26,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D26),0,VLOOKUP(D26,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I27),0,IF(AND($K$6=\"Solid/Semi-solid\",E27<=100,W27<9,L27<>\"\"),VLOOKUP(L27,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I27),0,IF(AND($K$6=\"Liquid/Slurry\",E27<=100,W27<9,L27<>\"\",U27<>\"Yes\"),VLOOKUP(L27,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D27),0,VLOOKUP(D27,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I28),0,IF(AND($K$6=\"Solid/Semi-solid\",E28<=100,W28<9,L28<>\"\"),VLOOKUP(L28,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I28),0,IF(AND($K$6=\"Liquid/Slurry\",E28<=100,W28<9,L28<>\"\",U28<>\"Yes\"),VLOOKUP(L28,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D28),0,VLOOKUP(D28,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(I29>0,$K$6=\"Liquid/Slurry\"),\"gal\",IF(AND(I29>0,$K$6=\"Solid/Semi-solid\"),\"tons\",\"\"))","v":""},null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I29),0,IF(AND($K$6=\"Solid/Semi-solid\",E29<=100,W29<9,L29<>\"\"),VLOOKUP(L29,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I29),0,IF(AND($K$6=\"Liquid/Slurry\",E29<=100,W29<9,L29<>\"\",U29<>\"Yes\"),VLOOKUP(L29,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D29),0,VLOOKUP(D29,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I30),0,IF(AND($K$6=\"Solid/Semi-solid\",E30<=100,W30<9,L30<>\"\"),VLOOKUP(L30,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I30),0,IF(AND($K$6=\"Liquid/Slurry\",E30<=100,W30<9,L30<>\"\",U30<>\"Yes\"),VLOOKUP(L30,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D30),0,VLOOKUP(D30,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I31),0,IF(AND($K$6=\"Solid/Semi-solid\",E31<=100,W31<9,L31<>\"\"),VLOOKUP(L31,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I31),0,IF(AND($K$6=\"Liquid/Slurry\",E31<=100,W31<9,L31<>\"\",U31<>\"Yes\"),VLOOKUP(L31,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D31),0,VLOOKUP(D31,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I32),0,IF(AND($K$6=\"Solid/Semi-solid\",E32<=100,W32<9,L32<>\"\"),VLOOKUP(L32,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I32),0,IF(AND($K$6=\"Liquid/Slurry\",E32<=100,W32<9,L32<>\"\",U32<>\"Yes\"),VLOOKUP(L32,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D32),0,VLOOKUP(D32,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I33),0,IF(AND($K$6=\"Solid/Semi-solid\",E33<=100,W33<9,L33<>\"\"),VLOOKUP(L33,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I33),0,IF(AND($K$6=\"Liquid/Slurry\",E33<=100,W33<9,L33<>\"\",U33<>\"Yes\"),VLOOKUP(L33,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D33),0,VLOOKUP(D33,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I34),0,IF(AND($K$6=\"Solid/Semi-solid\",E34<=100,W34<9,L34<>\"\"),VLOOKUP(L34,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I34),0,IF(AND($K$6=\"Liquid/Slurry\",E34<=100,W34<9,L34<>\"\",U34<>\"Yes\"),VLOOKUP(L34,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D34),0,VLOOKUP(D34,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I35),0,IF(AND($K$6=\"Solid/Semi-solid\",E35<=100,W35<9,L35<>\"\"),VLOOKUP(L35,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I35),0,IF(AND($K$6=\"Liquid/Slurry\",E35<=100,W35<9,L35<>\"\",U35<>\"Yes\"),VLOOKUP(L35,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D35),0,VLOOKUP(D35,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I36),0,IF(AND($K$6=\"Solid/Semi-solid\",E36<=100,W36<9,L36<>\"\"),VLOOKUP(L36,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I36),0,IF(AND($K$6=\"Liquid/Slurry\",E36<=100,W36<9,L36<>\"\",U36<>\"Yes\"),VLOOKUP(L36,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D36),0,VLOOKUP(D36,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I37),0,IF(AND($K$6=\"Solid/Semi-solid\",E37<=100,W37<9,L37<>\"\"),VLOOKUP(L37,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I37),0,IF(AND($K$6=\"Liquid/Slurry\",E37<=100,W37<9,L37<>\"\",U37<>\"Yes\"),VLOOKUP(L37,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D37),0,VLOOKUP(D37,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(I38>0,$K$6=\"Liquid/Slurry\"),\"gal\",IF(AND(I38>0,$K$6=\"Solid/Semi-solid\"),\"tons\",\"\"))","v":""},null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I38),0,IF(AND($K$6=\"Solid/Semi-solid\",E38<=100,W38<9,L38<>\"\"),VLOOKUP(L38,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I38),0,IF(AND($K$6=\"Liquid/Slurry\",E38<=100,W38<9,L38<>\"\",U38<>\"Yes\"),VLOOKUP(L38,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D38),0,VLOOKUP(D38,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I39),0,IF(AND($K$6=\"Solid/Semi-solid\",E39<=100,W39<9,L39<>\"\"),VLOOKUP(L39,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I39),0,IF(AND($K$6=\"Liquid/Slurry\",E39<=100,W39<9,L39<>\"\",U39<>\"Yes\"),VLOOKUP(L39,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D39),0,VLOOKUP(D39,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I40),0,IF(AND($K$6=\"Solid/Semi-solid\",E40<=100,W40<9,L40<>\"\"),VLOOKUP(L40,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I40),0,IF(AND($K$6=\"Liquid/Slurry\",E40<=100,W40<9,L40<>\"\",U40<>\"Yes\"),VLOOKUP(L40,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D40),0,VLOOKUP(D40,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I41),0,IF(AND($K$6=\"Solid/Semi-solid\",E41<=100,W41<9,L41<>\"\"),VLOOKUP(L41,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I41),0,IF(AND($K$6=\"Liquid/Slurry\",E41<=100,W41<9,L41<>\"\",U41<>\"Yes\"),VLOOKUP(L41,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D41),0,VLOOKUP(D41,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I42),0,IF(AND($K$6=\"Solid/Semi-solid\",E42<=100,W42<9,L42<>\"\"),VLOOKUP(L42,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I42),0,IF(AND($K$6=\"Liquid/Slurry\",E42<=100,W42<9,L42<>\"\",U42<>\"Yes\"),VLOOKUP(L42,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D42),0,VLOOKUP(D42,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I43),0,IF(AND($K$6=\"Solid/Semi-solid\",E43<=100,W43<9,L43<>\"\"),VLOOKUP(L43,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I43),0,IF(AND($K$6=\"Liquid/Slurry\",E43<=100,W43<9,L43<>\"\",U43<>\"Yes\"),VLOOKUP(L43,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D43),0,VLOOKUP(D43,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I44),0,IF(AND($K$6=\"Solid/Semi-solid\",E44<=100,W44<9,L44<>\"\"),VLOOKUP(L44,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I44),0,IF(AND($K$6=\"Liquid/Slurry\",E44<=100,W44<9,L44<>\"\",U44<>\"Yes\"),VLOOKUP(L44,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D44),0,VLOOKUP(D44,Lists!$A$30:$B$41,2,FALSE))","v":0}]
["Yellow highlighted cells indicate only injection costs are eligible.",null,null,null,null,"All Applied Acres:",{"$f":"SUMIFS(G11:G44,M11:M44,\">0\")","v":0},null,{"$f":"SUMIFS(I11:I44,M11:M44,\">0\")","v":0},"",null,null,{"$f":"SUM(M11:N44)","v":0},null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-solid\",M45,0)","v":0},{"$f":"IF(K6=\"Liquid/Slurry\",M45-V45,0)","v":0},null,{"$f":"SUM(V11:V44)","v":0}]
[null,null,null,null,null,"Injected Acres:",{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",W11:W44,\">0\",M11:M44,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-Solid\",SUMIFS(G11:G44,M11:M44,\">0\"),0)","v":0},"SOLID acres"]
["NOTES:","1Legumes (e.g., soybeans, >25% legume hay) are only eligible for injection costs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-solid\",SUMIFS(I11:I44,M11:M44,\">0\"),0)","v":0},"SOLID tons"]
[null,"2P-FIV≤100 is eligible for transport and/or injection costs. P-FIV 101 to 500 is eligible for injection costs only.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",SUMIFS(G11:G44,T11:T44,\">0\",M11:M44,\">0\"),0)","v":0},"LIQUID TRANSPORT acres"]
[null,"3Maximum application rate for liquid/slurry is 6,000 gal/ac;  Maximum application rate for solid/semi-solid is 10 tons/ac.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",SUMIFS(I11:I44,T11:T44,\">0\",M11:M44,\">0\"),0)","v":0},"LIQUID TRANSPORT gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",G45-G46,0)","v":0},"LIQUID TRANSPORT NOT INJECTED acres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(I11:I44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"<>Yes\")","v":0},"LIQUID TRANSPORT also INJECTED gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",W11:W44,\">0\",M11:M44,\">0\")","v":0},"INJECTION acres (all)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(I11:I44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"Yes\")","v":0},"INJECTION ONLY gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"<>Yes\")","v":0},"INJECTION and TRANSPORT acres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"Yes\")","v":0},"INJECTION ONLY acres"]

{"sheet":"Worksheet_2","index":7,"n_rows":56,"n_cols":25,"rows_kept":56,"cut":false,"hidden":false,"merged":[[7,14,7,16],[8,5,9,5],[3,5,3,8],[5,1,5,2],[5,7,5,9],[5,10,5,13],[7,0,7,13],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,6,9,6],[8,7,8,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[17,12,17,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[13,12,13,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[8,18,8,19],[10,12,10,13],[11,12,11,13],[8,12,9,13],[12,12,12,13],[29,12,29,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[44,0,45,2],[41,12,41,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[40,12,40,13],[42,12,42,13],[43,12,43,13],[44,8,45,8],[44,9,45,9],[44,12,45,13]]}
["Maryland Department of Agriculture"]
["MANURE TRANSPORT PROJECT PROGRAM",null,null,null,null,null,null,null,null,"WORKSHEET FOR LIVESTOCK MANURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreement: ____________________"]
["MANURE APPLICATION ─ Fields Receiving Manure from:"]
[]
["Animal Type:",null,null,null,null,null,null,"Manure Consistency:"]
[]
["Enter Field Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Transporter and Injector Information",null,null,null,null,null,null,"(Cost-share)"]
["Receiving Farm Name","Farm/Tract #\n(optional)","Field Number","Crop1","Soil\nP-FIV2","Date of Soil Test","Applied Acres","Manure Application",null,"Units","Manure Injection?","Distance Category (miles)","Maximum Cost-Share by Field",null,"Transporter\n(Name of person, farm or custom operator)","Injected By\n(Name of person, farm or custom operator)","Date(s) applied",null,"(Rate per 1000 gal)",null,null,"MI only"]
[null,null,null,null,null,null,null,"Rate3","Total",null,null,null,null,null,null,null,null,null,"Solid MT","Liq MT only","MI only?","($45 x Acre)","Crop code"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",G11*H11)","v":""},{"$f":"IF(AND(I11>0,$K$6=\"Liquid/Slurry\"),\"gal\",IF(AND(I11>0,$K$6=\"Solid/Semi-solid\"),\"tons\",\"\"))","v":""},null,null,{"$f":"IF(OR(I11=\"\",E11=\"\",E11>499),\"\",PRODUCT(MAX(S11:T11),I11)+V11)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I11),0,IF(AND($K$6=\"Solid/Semi-solid\",E11<=100,W11<9,L11<>\"\"),VLOOKUP(L11,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I11),0,IF(AND($K$6=\"Liquid/Slurry\",E11<=100,W11<9,L11<>\"\",U11<>\"Yes\"),VLOOKUP(L11,Lists!$A$45:$C$52,3,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I11),\"\",IF(AND(AND($K$6=\"Liquid/Slurry\",K11=\"Yes\",E11<500),OR(E11>100,W11>8,L11=\"< 1 mile\",L11=\"Out-of-state\")),\"Yes\",\"\"))","v":""},{"$f":"IF(K11=\"Yes\",G11*45,0)","v":0},{"$f":"IF(ISBLANK(D11),0,VLOOKUP(D11,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H12=\"\",\"\",G12*H12)","v":""},"",null,null,{"$f":"IF(OR(I12=\"\",E12=\"\",E12>499),\"\",PRODUCT(MAX(S12:T12),I12)+V12)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I12),0,IF(AND($K$6=\"Solid/Semi-solid\",E12<=100,W12<9,L12<>\"\"),VLOOKUP(L12,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I12),0,IF(AND($K$6=\"Liquid/Slurry\",E12<=100,W12<9,L12<>\"\",U12<>\"Yes\"),VLOOKUP(L12,Lists!$A$45:$C$52,3,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I12),\"\",IF(AND(AND($K$6=\"Liquid/Slurry\",K12=\"Yes\",E12<500),OR(E12>100,W12>8,L12=\"< 1 mile\",L12=\"Out-of-state\")),\"Yes\",\"\"))","v":""},{"$f":"IF(K12=\"Yes\",G12*45,0)","v":0},{"$f":"IF(ISBLANK(D12),0,VLOOKUP(D12,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I13),0,IF(AND($K$6=\"Solid/Semi-solid\",E13<=100,W13<9,L13<>\"\"),VLOOKUP(L13,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I13),0,IF(AND($K$6=\"Liquid/Slurry\",E13<=100,W13<9,L13<>\"\",U13<>\"Yes\"),VLOOKUP(L13,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D13),0,VLOOKUP(D13,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I14),0,IF(AND($K$6=\"Solid/Semi-solid\",E14<=100,W14<9,L14<>\"\"),VLOOKUP(L14,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I14),0,IF(AND($K$6=\"Liquid/Slurry\",E14<=100,W14<9,L14<>\"\",U14<>\"Yes\"),VLOOKUP(L14,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D14),0,VLOOKUP(D14,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I15),0,IF(AND($K$6=\"Solid/Semi-solid\",E15<=100,W15<9,L15<>\"\"),VLOOKUP(L15,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I15),0,IF(AND($K$6=\"Liquid/Slurry\",E15<=100,W15<9,L15<>\"\",U15<>\"Yes\"),VLOOKUP(L15,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D15),0,VLOOKUP(D15,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I16),0,IF(AND($K$6=\"Solid/Semi-solid\",E16<=100,W16<9,L16<>\"\"),VLOOKUP(L16,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I16),0,IF(AND($K$6=\"Liquid/Slurry\",E16<=100,W16<9,L16<>\"\",U16<>\"Yes\"),VLOOKUP(L16,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D16),0,VLOOKUP(D16,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I17),0,IF(AND($K$6=\"Solid/Semi-solid\",E17<=100,W17<9,L17<>\"\"),VLOOKUP(L17,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I17),0,IF(AND($K$6=\"Liquid/Slurry\",E17<=100,W17<9,L17<>\"\",U17<>\"Yes\"),VLOOKUP(L17,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D17),0,VLOOKUP(D17,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I18),0,IF(AND($K$6=\"Solid/Semi-solid\",E18<=100,W18<9,L18<>\"\"),VLOOKUP(L18,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I18),0,IF(AND($K$6=\"Liquid/Slurry\",E18<=100,W18<9,L18<>\"\",U18<>\"Yes\"),VLOOKUP(L18,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D18),0,VLOOKUP(D18,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I19),0,IF(AND($K$6=\"Solid/Semi-solid\",E19<=100,W19<9,L19<>\"\"),VLOOKUP(L19,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I19),0,IF(AND($K$6=\"Liquid/Slurry\",E19<=100,W19<9,L19<>\"\",U19<>\"Yes\"),VLOOKUP(L19,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D19),0,VLOOKUP(D19,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I20),0,IF(AND($K$6=\"Solid/Semi-solid\",E20<=100,W20<9,L20<>\"\"),VLOOKUP(L20,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I20),0,IF(AND($K$6=\"Liquid/Slurry\",E20<=100,W20<9,L20<>\"\",U20<>\"Yes\"),VLOOKUP(L20,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D20),0,VLOOKUP(D20,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I21),0,IF(AND($K$6=\"Solid/Semi-solid\",E21<=100,W21<9,L21<>\"\"),VLOOKUP(L21,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I21),0,IF(AND($K$6=\"Liquid/Slurry\",E21<=100,W21<9,L21<>\"\",U21<>\"Yes\"),VLOOKUP(L21,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D21),0,VLOOKUP(D21,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I22),0,IF(AND($K$6=\"Solid/Semi-solid\",E22<=100,W22<9,L22<>\"\"),VLOOKUP(L22,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I22),0,IF(AND($K$6=\"Liquid/Slurry\",E22<=100,W22<9,L22<>\"\",U22<>\"Yes\"),VLOOKUP(L22,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D22),0,VLOOKUP(D22,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I23),0,IF(AND($K$6=\"Solid/Semi-solid\",E23<=100,W23<9,L23<>\"\"),VLOOKUP(L23,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I23),0,IF(AND($K$6=\"Liquid/Slurry\",E23<=100,W23<9,L23<>\"\",U23<>\"Yes\"),VLOOKUP(L23,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D23),0,VLOOKUP(D23,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I24),0,IF(AND($K$6=\"Solid/Semi-solid\",E24<=100,W24<9,L24<>\"\"),VLOOKUP(L24,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I24),0,IF(AND($K$6=\"Liquid/Slurry\",E24<=100,W24<9,L24<>\"\",U24<>\"Yes\"),VLOOKUP(L24,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D24),0,VLOOKUP(D24,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I25),0,IF(AND($K$6=\"Solid/Semi-solid\",E25<=100,W25<9,L25<>\"\"),VLOOKUP(L25,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I25),0,IF(AND($K$6=\"Liquid/Slurry\",E25<=100,W25<9,L25<>\"\",U25<>\"Yes\"),VLOOKUP(L25,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D25),0,VLOOKUP(D25,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I26),0,IF(AND($K$6=\"Solid/Semi-solid\",E26<=100,W26<9,L26<>\"\"),VLOOKUP(L26,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I26),0,IF(AND($K$6=\"Liquid/Slurry\",E26<=100,W26<9,L26<>\"\",U26<>\"Yes\"),VLOOKUP(L26,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D26),0,VLOOKUP(D26,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I27),0,IF(AND($K$6=\"Solid/Semi-solid\",E27<=100,W27<9,L27<>\"\"),VLOOKUP(L27,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I27),0,IF(AND($K$6=\"Liquid/Slurry\",E27<=100,W27<9,L27<>\"\",U27<>\"Yes\"),VLOOKUP(L27,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D27),0,VLOOKUP(D27,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I28),0,IF(AND($K$6=\"Solid/Semi-solid\",E28<=100,W28<9,L28<>\"\"),VLOOKUP(L28,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I28),0,IF(AND($K$6=\"Liquid/Slurry\",E28<=100,W28<9,L28<>\"\",U28<>\"Yes\"),VLOOKUP(L28,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D28),0,VLOOKUP(D28,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I29),0,IF(AND($K$6=\"Solid/Semi-solid\",E29<=100,W29<9,L29<>\"\"),VLOOKUP(L29,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I29),0,IF(AND($K$6=\"Liquid/Slurry\",E29<=100,W29<9,L29<>\"\",U29<>\"Yes\"),VLOOKUP(L29,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D29),0,VLOOKUP(D29,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I30),0,IF(AND($K$6=\"Solid/Semi-solid\",E30<=100,W30<9,L30<>\"\"),VLOOKUP(L30,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I30),0,IF(AND($K$6=\"Liquid/Slurry\",E30<=100,W30<9,L30<>\"\",U30<>\"Yes\"),VLOOKUP(L30,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D30),0,VLOOKUP(D30,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I31),0,IF(AND($K$6=\"Solid/Semi-solid\",E31<=100,W31<9,L31<>\"\"),VLOOKUP(L31,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I31),0,IF(AND($K$6=\"Liquid/Slurry\",E31<=100,W31<9,L31<>\"\",U31<>\"Yes\"),VLOOKUP(L31,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D31),0,VLOOKUP(D31,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I32),0,IF(AND($K$6=\"Solid/Semi-solid\",E32<=100,W32<9,L32<>\"\"),VLOOKUP(L32,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I32),0,IF(AND($K$6=\"Liquid/Slurry\",E32<=100,W32<9,L32<>\"\",U32<>\"Yes\"),VLOOKUP(L32,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D32),0,VLOOKUP(D32,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I33),0,IF(AND($K$6=\"Solid/Semi-solid\",E33<=100,W33<9,L33<>\"\"),VLOOKUP(L33,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I33),0,IF(AND($K$6=\"Liquid/Slurry\",E33<=100,W33<9,L33<>\"\",U33<>\"Yes\"),VLOOKUP(L33,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D33),0,VLOOKUP(D33,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I34),0,IF(AND($K$6=\"Solid/Semi-solid\",E34<=100,W34<9,L34<>\"\"),VLOOKUP(L34,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I34),0,IF(AND($K$6=\"Liquid/Slurry\",E34<=100,W34<9,L34<>\"\",U34<>\"Yes\"),VLOOKUP(L34,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D34),0,VLOOKUP(D34,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I35),0,IF(AND($K$6=\"Solid/Semi-solid\",E35<=100,W35<9,L35<>\"\"),VLOOKUP(L35,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I35),0,IF(AND($K$6=\"Liquid/Slurry\",E35<=100,W35<9,L35<>\"\",U35<>\"Yes\"),VLOOKUP(L35,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D35),0,VLOOKUP(D35,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I36),0,IF(AND($K$6=\"Solid/Semi-solid\",E36<=100,W36<9,L36<>\"\"),VLOOKUP(L36,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I36),0,IF(AND($K$6=\"Liquid/Slurry\",E36<=100,W36<9,L36<>\"\",U36<>\"Yes\"),VLOOKUP(L36,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D36),0,VLOOKUP(D36,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I37),0,IF(AND($K$6=\"Solid/Semi-solid\",E37<=100,W37<9,L37<>\"\"),VLOOKUP(L37,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I37),0,IF(AND($K$6=\"Liquid/Slurry\",E37<=100,W37<9,L37<>\"\",U37<>\"Yes\"),VLOOKUP(L37,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D37),0,VLOOKUP(D37,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I38),0,IF(AND($K$6=\"Solid/Semi-solid\",E38<=100,W38<9,L38<>\"\"),VLOOKUP(L38,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I38),0,IF(AND($K$6=\"Liquid/Slurry\",E38<=100,W38<9,L38<>\"\",U38<>\"Yes\"),VLOOKUP(L38,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D38),0,VLOOKUP(D38,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I39),0,IF(AND($K$6=\"Solid/Semi-solid\",E39<=100,W39<9,L39<>\"\"),VLOOKUP(L39,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I39),0,IF(AND($K$6=\"Liquid/Slurry\",E39<=100,W39<9,L39<>\"\",U39<>\"Yes\"),VLOOKUP(L39,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D39),0,VLOOKUP(D39,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I40),0,IF(AND($K$6=\"Solid/Semi-solid\",E40<=100,W40<9,L40<>\"\"),VLOOKUP(L40,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I40),0,IF(AND($K$6=\"Liquid/Slurry\",E40<=100,W40<9,L40<>\"\",U40<>\"Yes\"),VLOOKUP(L40,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D40),0,VLOOKUP(D40,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I41),0,IF(AND($K$6=\"Solid/Semi-solid\",E41<=100,W41<9,L41<>\"\"),VLOOKUP(L41,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I41),0,IF(AND($K$6=\"Liquid/Slurry\",E41<=100,W41<9,L41<>\"\",U41<>\"Yes\"),VLOOKUP(L41,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D41),0,VLOOKUP(D41,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I42),0,IF(AND($K$6=\"Solid/Semi-solid\",E42<=100,W42<9,L42<>\"\"),VLOOKUP(L42,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I42),0,IF(AND($K$6=\"Liquid/Slurry\",E42<=100,W42<9,L42<>\"\",U42<>\"Yes\"),VLOOKUP(L42,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D42),0,VLOOKUP(D42,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I43),0,IF(AND($K$6=\"Solid/Semi-solid\",E43<=100,W43<9,L43<>\"\"),VLOOKUP(L43,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I43),0,IF(AND($K$6=\"Liquid/Slurry\",E43<=100,W43<9,L43<>\"\",U43<>\"Yes\"),VLOOKUP(L43,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D43),0,VLOOKUP(D43,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I44),0,IF(AND($K$6=\"Solid/Semi-solid\",E44<=100,W44<9,L44<>\"\"),VLOOKUP(L44,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I44),0,IF(AND($K$6=\"Liquid/Slurry\",E44<=100,W44<9,L44<>\"\",U44<>\"Yes\"),VLOOKUP(L44,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D44),0,VLOOKUP(D44,Lists!$A$30:$B$41,2,FALSE))","v":0}]
["Yellow highlighted cells indicate only injection costs are eligible.",null,null,null,null,"All Applied Acres:",{"$f":"SUMIFS(G11:G44,M11:M44,\">0\")","v":0},null,{"$f":"SUMIFS(I11:I44,M11:M44,\">0\")","v":0},"",null,null,{"$f":"SUM(M11:N44)","v":0},null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-solid\",M45,0)","v":0},{"$f":"IF(K6=\"Liquid/Slurry\",M45-V45,0)","v":0},null,{"$f":"SUM(V11:V44)","v":0}]
[null,null,null,null,null,"Injected Acres:",{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",W11:W44,\">0\",M11:M44,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-Solid\",SUMIFS(G11:G44,M11:M44,\">0\"),0)","v":0},"SOLID acres"]
["NOTES:","1Legumes (e.g., soybeans, >25% legume hay) are only eligible for injection costs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-solid\",SUMIFS(I11:I44,M11:M44,\">0\"),0)","v":0},"SOLID tons"]
[null,"2P-FIV≤100 is eligible for transport and/or injection costs. P-FIV 101 to 500 is eligible for injection costs only.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",SUMIFS(G11:G44,T11:T44,\">0\",M11:M44,\">0\"),0)","v":0},"LIQUID TRANSPORT acres"]
[null,"3Maximum application rate for liquid/slurry is 6,000 gal/ac;  Maximum application rate for solid/semi-solid is 10 tons/ac.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",SUMIFS(I11:I44,T11:T44,\">0\",M11:M44,\">0\"),0)","v":0},"LIQUID TRANSPORT gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",G45-G46,0)","v":0},"LIQUID TRANSPORT NOT INJECTED acres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(I11:I44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"<>Yes\")","v":0},"LIQUID TRANSPORT also INJECTED gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",W11:W44,\">0\",M11:M44,\">0\")","v":0},"INJECTION acres (all)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(I11:I44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"Yes\")","v":0},"INJECTION ONLY gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"<>Yes\")","v":0},"INJECTION and TRANSPORT acres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"Yes\")","v":0},"INJECTION ONLY acres"]

{"sheet":"Worksheet_3","index":8,"n_rows":56,"n_cols":25,"rows_kept":56,"cut":false,"hidden":false,"merged":[[7,14,7,16],[8,5,9,5],[3,5,3,8],[5,1,5,2],[5,7,5,9],[5,10,5,13],[7,0,7,13],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,6,9,6],[8,7,8,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[17,12,17,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[13,12,13,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[8,18,8,19],[10,12,10,13],[11,12,11,13],[8,12,9,13],[12,12,12,13],[29,12,29,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[44,0,45,2],[41,12,41,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[40,12,40,13],[42,12,42,13],[43,12,43,13],[44,8,45,8],[44,9,45,9],[44,12,45,13]]}
["Maryland Department of Agriculture"]
["MANURE TRANSPORT PROJECT PROGRAM",null,null,null,null,null,null,null,null,"WORKSHEET FOR LIVESTOCK MANURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreement: ____________________"]
["MANURE APPLICATION ─ Fields Receiving Manure from:"]
[]
["Animal Type:",null,null,null,null,null,null,"Manure Consistency:"]
[]
["Enter Field Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Transporter and Injector Information",null,null,null,null,null,null,"(Cost-share)"]
["Receiving Farm Name","Farm/Tract #\n(optional)","Field Number","Crop1","Soil\nP-FIV2","Date of Soil Test","Applied Acres","Manure Application",null,"Units","Manure Injection?","Distance Category (miles)","Maximum Cost-Share by Field",null,"Transporter\n(Name of person, farm or custom operator)","Injected By\n(Name of person, farm or custom operator)","Date(s) applied",null,"(Rate per 1000 gal)",null,null,"MI only"]
[null,null,null,null,null,null,null,"Rate3","Total",null,null,null,null,null,null,null,null,null,"Solid MT","Liq MT only","MI only?","($45 x Acre)","Crop code"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",G11*H11)","v":""},{"$f":"IF(AND(I11>0,$K$6=\"Liquid/Slurry\"),\"gal\",IF(AND(I11>0,$K$6=\"Solid/Semi-solid\"),\"tons\",\"\"))","v":""},null,null,{"$f":"IF(OR(I11=\"\",E11=\"\",E11>499),\"\",PRODUCT(MAX(S11:T11),I11)+V11)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I11),0,IF(AND($K$6=\"Solid/Semi-solid\",E11<=100,W11<9,L11<>\"\"),VLOOKUP(L11,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I11),0,IF(AND($K$6=\"Liquid/Slurry\",E11<=100,W11<9,L11<>\"\",U11<>\"Yes\"),VLOOKUP(L11,Lists!$A$45:$C$52,3,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I11),\"\",IF(AND(AND($K$6=\"Liquid/Slurry\",K11=\"Yes\",E11<500),OR(E11>100,W11>8,L11=\"< 1 mile\",L11=\"Out-of-state\")),\"Yes\",\"\"))","v":""},{"$f":"IF(K11=\"Yes\",G11*45,0)","v":0},{"$f":"IF(ISBLANK(D11),0,VLOOKUP(D11,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H12=\"\",\"\",G12*H12)","v":""},"",null,null,{"$f":"IF(OR(I12=\"\",E12=\"\",E12>499),\"\",PRODUCT(MAX(S12:T12),I12)+V12)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I12),0,IF(AND($K$6=\"Solid/Semi-solid\",E12<=100,W12<9,L12<>\"\"),VLOOKUP(L12,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I12),0,IF(AND($K$6=\"Liquid/Slurry\",E12<=100,W12<9,L12<>\"\",U12<>\"Yes\"),VLOOKUP(L12,Lists!$A$45:$C$52,3,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I12),\"\",IF(AND(AND($K$6=\"Liquid/Slurry\",K12=\"Yes\",E12<500),OR(E12>100,W12>8,L12=\"< 1 mile\",L12=\"Out-of-state\")),\"Yes\",\"\"))","v":""},{"$f":"IF(K12=\"Yes\",G12*45,0)","v":0},{"$f":"IF(ISBLANK(D12),0,VLOOKUP(D12,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I13),0,IF(AND($K$6=\"Solid/Semi-solid\",E13<=100,W13<9,L13<>\"\"),VLOOKUP(L13,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I13),0,IF(AND($K$6=\"Liquid/Slurry\",E13<=100,W13<9,L13<>\"\",U13<>\"Yes\"),VLOOKUP(L13,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D13),0,VLOOKUP(D13,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I14),0,IF(AND($K$6=\"Solid/Semi-solid\",E14<=100,W14<9,L14<>\"\"),VLOOKUP(L14,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I14),0,IF(AND($K$6=\"Liquid/Slurry\",E14<=100,W14<9,L14<>\"\",U14<>\"Yes\"),VLOOKUP(L14,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D14),0,VLOOKUP(D14,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I15),0,IF(AND($K$6=\"Solid/Semi-solid\",E15<=100,W15<9,L15<>\"\"),VLOOKUP(L15,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I15),0,IF(AND($K$6=\"Liquid/Slurry\",E15<=100,W15<9,L15<>\"\",U15<>\"Yes\"),VLOOKUP(L15,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D15),0,VLOOKUP(D15,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I16),0,IF(AND($K$6=\"Solid/Semi-solid\",E16<=100,W16<9,L16<>\"\"),VLOOKUP(L16,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I16),0,IF(AND($K$6=\"Liquid/Slurry\",E16<=100,W16<9,L16<>\"\",U16<>\"Yes\"),VLOOKUP(L16,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D16),0,VLOOKUP(D16,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I17),0,IF(AND($K$6=\"Solid/Semi-solid\",E17<=100,W17<9,L17<>\"\"),VLOOKUP(L17,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I17),0,IF(AND($K$6=\"Liquid/Slurry\",E17<=100,W17<9,L17<>\"\",U17<>\"Yes\"),VLOOKUP(L17,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D17),0,VLOOKUP(D17,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I18),0,IF(AND($K$6=\"Solid/Semi-solid\",E18<=100,W18<9,L18<>\"\"),VLOOKUP(L18,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I18),0,IF(AND($K$6=\"Liquid/Slurry\",E18<=100,W18<9,L18<>\"\",U18<>\"Yes\"),VLOOKUP(L18,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D18),0,VLOOKUP(D18,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I19),0,IF(AND($K$6=\"Solid/Semi-solid\",E19<=100,W19<9,L19<>\"\"),VLOOKUP(L19,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I19),0,IF(AND($K$6=\"Liquid/Slurry\",E19<=100,W19<9,L19<>\"\",U19<>\"Yes\"),VLOOKUP(L19,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D19),0,VLOOKUP(D19,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I20),0,IF(AND($K$6=\"Solid/Semi-solid\",E20<=100,W20<9,L20<>\"\"),VLOOKUP(L20,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I20),0,IF(AND($K$6=\"Liquid/Slurry\",E20<=100,W20<9,L20<>\"\",U20<>\"Yes\"),VLOOKUP(L20,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D20),0,VLOOKUP(D20,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I21),0,IF(AND($K$6=\"Solid/Semi-solid\",E21<=100,W21<9,L21<>\"\"),VLOOKUP(L21,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I21),0,IF(AND($K$6=\"Liquid/Slurry\",E21<=100,W21<9,L21<>\"\",U21<>\"Yes\"),VLOOKUP(L21,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D21),0,VLOOKUP(D21,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I22),0,IF(AND($K$6=\"Solid/Semi-solid\",E22<=100,W22<9,L22<>\"\"),VLOOKUP(L22,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I22),0,IF(AND($K$6=\"Liquid/Slurry\",E22<=100,W22<9,L22<>\"\",U22<>\"Yes\"),VLOOKUP(L22,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D22),0,VLOOKUP(D22,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I23),0,IF(AND($K$6=\"Solid/Semi-solid\",E23<=100,W23<9,L23<>\"\"),VLOOKUP(L23,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I23),0,IF(AND($K$6=\"Liquid/Slurry\",E23<=100,W23<9,L23<>\"\",U23<>\"Yes\"),VLOOKUP(L23,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D23),0,VLOOKUP(D23,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I24),0,IF(AND($K$6=\"Solid/Semi-solid\",E24<=100,W24<9,L24<>\"\"),VLOOKUP(L24,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I24),0,IF(AND($K$6=\"Liquid/Slurry\",E24<=100,W24<9,L24<>\"\",U24<>\"Yes\"),VLOOKUP(L24,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D24),0,VLOOKUP(D24,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I25),0,IF(AND($K$6=\"Solid/Semi-solid\",E25<=100,W25<9,L25<>\"\"),VLOOKUP(L25,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I25),0,IF(AND($K$6=\"Liquid/Slurry\",E25<=100,W25<9,L25<>\"\",U25<>\"Yes\"),VLOOKUP(L25,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D25),0,VLOOKUP(D25,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I26),0,IF(AND($K$6=\"Solid/Semi-solid\",E26<=100,W26<9,L26<>\"\"),VLOOKUP(L26,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I26),0,IF(AND($K$6=\"Liquid/Slurry\",E26<=100,W26<9,L26<>\"\",U26<>\"Yes\"),VLOOKUP(L26,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D26),0,VLOOKUP(D26,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I27),0,IF(AND($K$6=\"Solid/Semi-solid\",E27<=100,W27<9,L27<>\"\"),VLOOKUP(L27,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I27),0,IF(AND($K$6=\"Liquid/Slurry\",E27<=100,W27<9,L27<>\"\",U27<>\"Yes\"),VLOOKUP(L27,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D27),0,VLOOKUP(D27,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I28),0,IF(AND($K$6=\"Solid/Semi-solid\",E28<=100,W28<9,L28<>\"\"),VLOOKUP(L28,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I28),0,IF(AND($K$6=\"Liquid/Slurry\",E28<=100,W28<9,L28<>\"\",U28<>\"Yes\"),VLOOKUP(L28,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D28),0,VLOOKUP(D28,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I29),0,IF(AND($K$6=\"Solid/Semi-solid\",E29<=100,W29<9,L29<>\"\"),VLOOKUP(L29,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I29),0,IF(AND($K$6=\"Liquid/Slurry\",E29<=100,W29<9,L29<>\"\",U29<>\"Yes\"),VLOOKUP(L29,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D29),0,VLOOKUP(D29,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I30),0,IF(AND($K$6=\"Solid/Semi-solid\",E30<=100,W30<9,L30<>\"\"),VLOOKUP(L30,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I30),0,IF(AND($K$6=\"Liquid/Slurry\",E30<=100,W30<9,L30<>\"\",U30<>\"Yes\"),VLOOKUP(L30,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D30),0,VLOOKUP(D30,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I31),0,IF(AND($K$6=\"Solid/Semi-solid\",E31<=100,W31<9,L31<>\"\"),VLOOKUP(L31,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I31),0,IF(AND($K$6=\"Liquid/Slurry\",E31<=100,W31<9,L31<>\"\",U31<>\"Yes\"),VLOOKUP(L31,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D31),0,VLOOKUP(D31,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I32),0,IF(AND($K$6=\"Solid/Semi-solid\",E32<=100,W32<9,L32<>\"\"),VLOOKUP(L32,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I32),0,IF(AND($K$6=\"Liquid/Slurry\",E32<=100,W32<9,L32<>\"\",U32<>\"Yes\"),VLOOKUP(L32,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D32),0,VLOOKUP(D32,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I33),0,IF(AND($K$6=\"Solid/Semi-solid\",E33<=100,W33<9,L33<>\"\"),VLOOKUP(L33,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I33),0,IF(AND($K$6=\"Liquid/Slurry\",E33<=100,W33<9,L33<>\"\",U33<>\"Yes\"),VLOOKUP(L33,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D33),0,VLOOKUP(D33,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I34),0,IF(AND($K$6=\"Solid/Semi-solid\",E34<=100,W34<9,L34<>\"\"),VLOOKUP(L34,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I34),0,IF(AND($K$6=\"Liquid/Slurry\",E34<=100,W34<9,L34<>\"\",U34<>\"Yes\"),VLOOKUP(L34,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D34),0,VLOOKUP(D34,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I35),0,IF(AND($K$6=\"Solid/Semi-solid\",E35<=100,W35<9,L35<>\"\"),VLOOKUP(L35,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I35),0,IF(AND($K$6=\"Liquid/Slurry\",E35<=100,W35<9,L35<>\"\",U35<>\"Yes\"),VLOOKUP(L35,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D35),0,VLOOKUP(D35,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I36),0,IF(AND($K$6=\"Solid/Semi-solid\",E36<=100,W36<9,L36<>\"\"),VLOOKUP(L36,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I36),0,IF(AND($K$6=\"Liquid/Slurry\",E36<=100,W36<9,L36<>\"\",U36<>\"Yes\"),VLOOKUP(L36,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D36),0,VLOOKUP(D36,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I37),0,IF(AND($K$6=\"Solid/Semi-solid\",E37<=100,W37<9,L37<>\"\"),VLOOKUP(L37,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I37),0,IF(AND($K$6=\"Liquid/Slurry\",E37<=100,W37<9,L37<>\"\",U37<>\"Yes\"),VLOOKUP(L37,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D37),0,VLOOKUP(D37,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I38),0,IF(AND($K$6=\"Solid/Semi-solid\",E38<=100,W38<9,L38<>\"\"),VLOOKUP(L38,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I38),0,IF(AND($K$6=\"Liquid/Slurry\",E38<=100,W38<9,L38<>\"\",U38<>\"Yes\"),VLOOKUP(L38,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D38),0,VLOOKUP(D38,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I39),0,IF(AND($K$6=\"Solid/Semi-solid\",E39<=100,W39<9,L39<>\"\"),VLOOKUP(L39,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I39),0,IF(AND($K$6=\"Liquid/Slurry\",E39<=100,W39<9,L39<>\"\",U39<>\"Yes\"),VLOOKUP(L39,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D39),0,VLOOKUP(D39,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I40),0,IF(AND($K$6=\"Solid/Semi-solid\",E40<=100,W40<9,L40<>\"\"),VLOOKUP(L40,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I40),0,IF(AND($K$6=\"Liquid/Slurry\",E40<=100,W40<9,L40<>\"\",U40<>\"Yes\"),VLOOKUP(L40,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D40),0,VLOOKUP(D40,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I41),0,IF(AND($K$6=\"Solid/Semi-solid\",E41<=100,W41<9,L41<>\"\"),VLOOKUP(L41,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I41),0,IF(AND($K$6=\"Liquid/Slurry\",E41<=100,W41<9,L41<>\"\",U41<>\"Yes\"),VLOOKUP(L41,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D41),0,VLOOKUP(D41,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I42),0,IF(AND($K$6=\"Solid/Semi-solid\",E42<=100,W42<9,L42<>\"\"),VLOOKUP(L42,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I42),0,IF(AND($K$6=\"Liquid/Slurry\",E42<=100,W42<9,L42<>\"\",U42<>\"Yes\"),VLOOKUP(L42,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D42),0,VLOOKUP(D42,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I43),0,IF(AND($K$6=\"Solid/Semi-solid\",E43<=100,W43<9,L43<>\"\"),VLOOKUP(L43,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I43),0,IF(AND($K$6=\"Liquid/Slurry\",E43<=100,W43<9,L43<>\"\",U43<>\"Yes\"),VLOOKUP(L43,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D43),0,VLOOKUP(D43,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I44),0,IF(AND($K$6=\"Solid/Semi-solid\",E44<=100,W44<9,L44<>\"\"),VLOOKUP(L44,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I44),0,IF(AND($K$6=\"Liquid/Slurry\",E44<=100,W44<9,L44<>\"\",U44<>\"Yes\"),VLOOKUP(L44,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D44),0,VLOOKUP(D44,Lists!$A$30:$B$41,2,FALSE))","v":0}]
["Yellow highlighted cells indicate only injection costs are eligible.",null,null,null,null,"All Applied Acres:",{"$f":"SUMIFS(G11:G44,M11:M44,\">0\")","v":0},null,{"$f":"SUMIFS(I11:I44,M11:M44,\">0\")","v":0},"",null,null,{"$f":"SUM(M11:N44)","v":0},null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-solid\",M45,0)","v":0},{"$f":"IF(K6=\"Liquid/Slurry\",M45-V45,0)","v":0},null,{"$f":"SUM(V11:V44)","v":0}]
[null,null,null,null,null,"Injected Acres:",{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",W11:W44,\">0\",M11:M44,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-Solid\",SUMIFS(G11:G44,M11:M44,\">0\"),0)","v":0},"SOLID acres"]
["NOTES:","1Legumes (e.g., soybeans, >25% legume hay) are only eligible for injection costs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-solid\",SUMIFS(I11:I44,M11:M44,\">0\"),0)","v":0},"SOLID tons"]
[null,"2P-FIV≤100 is eligible for transport and/or injection costs. P-FIV 101 to 500 is eligible for injection costs only.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",SUMIFS(G11:G44,T11:T44,\">0\",M11:M44,\">0\"),0)","v":0},"LIQUID TRANSPORT acres"]
[null,"3Maximum application rate for liquid/slurry is 6,000 gal/ac;  Maximum application rate for solid/semi-solid is 10 tons/ac.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",SUMIFS(I11:I44,T11:T44,\">0\",M11:M44,\">0\"),0)","v":0},"LIQUID TRANSPORT gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",G45-G46,0)","v":0},"LIQUID TRANSPORT NOT INJECTED acres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(I11:I44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"<>Yes\")","v":0},"LIQUID TRANSPORT also INJECTED gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",W11:W44,\">0\",M11:M44,\">0\")","v":0},"INJECTION acres (all)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(I11:I44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"Yes\")","v":0},"INJECTION ONLY gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"<>Yes\")","v":0},"INJECTION and TRANSPORT acres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"Yes\")","v":0},"INJECTION ONLY acres"]

{"sheet":"Worksheet_4","index":9,"n_rows":56,"n_cols":25,"rows_kept":56,"cut":false,"hidden":false,"merged":[[7,14,7,16],[8,5,9,5],[3,5,3,8],[5,1,5,2],[5,7,5,9],[5,10,5,13],[7,0,7,13],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,6,9,6],[8,7,8,8],[8,9,9,9],[8,10,9,10],[8,11,9,11],[17,12,17,13],[8,14,9,14],[8,15,9,15],[8,16,9,16],[13,12,13,13],[14,12,14,13],[15,12,15,13],[16,12,16,13],[8,18,8,19],[10,12,10,13],[11,12,11,13],[8,12,9,13],[12,12,12,13],[29,12,29,13],[18,12,18,13],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[24,12,24,13],[25,12,25,13],[26,12,26,13],[27,12,27,13],[28,12,28,13],[44,0,45,2],[41,12,41,13],[30,12,30,13],[31,12,31,13],[32,12,32,13],[33,12,33,13],[34,12,34,13],[35,12,35,13],[36,12,36,13],[37,12,37,13],[38,12,38,13],[39,12,39,13],[40,12,40,13],[42,12,42,13],[43,12,43,13],[44,8,45,8],[44,9,45,9],[44,12,45,13]]}
["Maryland Department of Agriculture"]
["MANURE TRANSPORT PROJECT PROGRAM",null,null,null,null,null,null,null,null,"WORKSHEET FOR LIVESTOCK MANURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agreement: ____________________"]
["MANURE APPLICATION ─ Fields Receiving Manure from:"]
[]
["Animal Type:",null,null,null,null,null,null,"Manure Consistency:"]
[]
["Enter Field Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Transporter and Injector Information",null,null,null,null,null,null,"(Cost-share)"]
["Receiving Farm Name","Farm/Tract #\n(optional)","Field Number","Crop1","Soil\nP-FIV2","Date of Soil Test","Applied Acres","Manure Application",null,"Units","Manure Injection?","Distance Category (miles)","Maximum Cost-Share by Field",null,"Transporter\n(Name of person, farm or custom operator)","Injected By\n(Name of person, farm or custom operator)","Date(s) applied",null,"(Rate per 1000 gal)",null,null,"MI only"]
[null,null,null,null,null,null,null,"Rate3","Total",null,null,null,null,null,null,null,null,null,"Solid MT","Liq MT only","MI only?","($45 x Acre)","Crop code"]
[null,null,null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"\",G11*H11)","v":""},{"$f":"IF(AND(I11>0,$K$6=\"Liquid/Slurry\"),\"gal\",IF(AND(I11>0,$K$6=\"Solid/Semi-solid\"),\"tons\",\"\"))","v":""},null,null,{"$f":"IF(OR(I11=\"\",E11=\"\",E11>499),\"\",PRODUCT(MAX(S11:T11),I11)+V11)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I11),0,IF(AND($K$6=\"Solid/Semi-solid\",E11<=100,W11<9,L11<>\"\"),VLOOKUP(L11,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I11),0,IF(AND($K$6=\"Liquid/Slurry\",E11<=100,W11<9,L11<>\"\",U11<>\"Yes\"),VLOOKUP(L11,Lists!$A$45:$C$52,3,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I11),\"\",IF(AND(AND($K$6=\"Liquid/Slurry\",K11=\"Yes\",E11<500),OR(E11>100,W11>8,L11=\"< 1 mile\",L11=\"Out-of-state\")),\"Yes\",\"\"))","v":""},{"$f":"IF(K11=\"Yes\",G11*45,0)","v":0},{"$f":"IF(ISBLANK(D11),0,VLOOKUP(D11,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H12=\"\",\"\",G12*H12)","v":""},"",null,null,{"$f":"IF(OR(I12=\"\",E12=\"\",E12>499),\"\",PRODUCT(MAX(S12:T12),I12)+V12)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK(I12),0,IF(AND($K$6=\"Solid/Semi-solid\",E12<=100,W12<9,L12<>\"\"),VLOOKUP(L12,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I12),0,IF(AND($K$6=\"Liquid/Slurry\",E12<=100,W12<9,L12<>\"\",U12<>\"Yes\"),VLOOKUP(L12,Lists!$A$45:$C$52,3,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I12),\"\",IF(AND(AND($K$6=\"Liquid/Slurry\",K12=\"Yes\",E12<500),OR(E12>100,W12>8,L12=\"< 1 mile\",L12=\"Out-of-state\")),\"Yes\",\"\"))","v":""},{"$f":"IF(K12=\"Yes\",G12*45,0)","v":0},{"$f":"IF(ISBLANK(D12),0,VLOOKUP(D12,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I13),0,IF(AND($K$6=\"Solid/Semi-solid\",E13<=100,W13<9,L13<>\"\"),VLOOKUP(L13,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I13),0,IF(AND($K$6=\"Liquid/Slurry\",E13<=100,W13<9,L13<>\"\",U13<>\"Yes\"),VLOOKUP(L13,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D13),0,VLOOKUP(D13,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I14),0,IF(AND($K$6=\"Solid/Semi-solid\",E14<=100,W14<9,L14<>\"\"),VLOOKUP(L14,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I14),0,IF(AND($K$6=\"Liquid/Slurry\",E14<=100,W14<9,L14<>\"\",U14<>\"Yes\"),VLOOKUP(L14,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D14),0,VLOOKUP(D14,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I15),0,IF(AND($K$6=\"Solid/Semi-solid\",E15<=100,W15<9,L15<>\"\"),VLOOKUP(L15,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I15),0,IF(AND($K$6=\"Liquid/Slurry\",E15<=100,W15<9,L15<>\"\",U15<>\"Yes\"),VLOOKUP(L15,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D15),0,VLOOKUP(D15,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I16),0,IF(AND($K$6=\"Solid/Semi-solid\",E16<=100,W16<9,L16<>\"\"),VLOOKUP(L16,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I16),0,IF(AND($K$6=\"Liquid/Slurry\",E16<=100,W16<9,L16<>\"\",U16<>\"Yes\"),VLOOKUP(L16,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D16),0,VLOOKUP(D16,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I17),0,IF(AND($K$6=\"Solid/Semi-solid\",E17<=100,W17<9,L17<>\"\"),VLOOKUP(L17,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I17),0,IF(AND($K$6=\"Liquid/Slurry\",E17<=100,W17<9,L17<>\"\",U17<>\"Yes\"),VLOOKUP(L17,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D17),0,VLOOKUP(D17,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I18),0,IF(AND($K$6=\"Solid/Semi-solid\",E18<=100,W18<9,L18<>\"\"),VLOOKUP(L18,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I18),0,IF(AND($K$6=\"Liquid/Slurry\",E18<=100,W18<9,L18<>\"\",U18<>\"Yes\"),VLOOKUP(L18,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D18),0,VLOOKUP(D18,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I19),0,IF(AND($K$6=\"Solid/Semi-solid\",E19<=100,W19<9,L19<>\"\"),VLOOKUP(L19,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I19),0,IF(AND($K$6=\"Liquid/Slurry\",E19<=100,W19<9,L19<>\"\",U19<>\"Yes\"),VLOOKUP(L19,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D19),0,VLOOKUP(D19,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I20),0,IF(AND($K$6=\"Solid/Semi-solid\",E20<=100,W20<9,L20<>\"\"),VLOOKUP(L20,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I20),0,IF(AND($K$6=\"Liquid/Slurry\",E20<=100,W20<9,L20<>\"\",U20<>\"Yes\"),VLOOKUP(L20,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D20),0,VLOOKUP(D20,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I21),0,IF(AND($K$6=\"Solid/Semi-solid\",E21<=100,W21<9,L21<>\"\"),VLOOKUP(L21,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I21),0,IF(AND($K$6=\"Liquid/Slurry\",E21<=100,W21<9,L21<>\"\",U21<>\"Yes\"),VLOOKUP(L21,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D21),0,VLOOKUP(D21,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I22),0,IF(AND($K$6=\"Solid/Semi-solid\",E22<=100,W22<9,L22<>\"\"),VLOOKUP(L22,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I22),0,IF(AND($K$6=\"Liquid/Slurry\",E22<=100,W22<9,L22<>\"\",U22<>\"Yes\"),VLOOKUP(L22,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D22),0,VLOOKUP(D22,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I23),0,IF(AND($K$6=\"Solid/Semi-solid\",E23<=100,W23<9,L23<>\"\"),VLOOKUP(L23,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I23),0,IF(AND($K$6=\"Liquid/Slurry\",E23<=100,W23<9,L23<>\"\",U23<>\"Yes\"),VLOOKUP(L23,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D23),0,VLOOKUP(D23,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I24),0,IF(AND($K$6=\"Solid/Semi-solid\",E24<=100,W24<9,L24<>\"\"),VLOOKUP(L24,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I24),0,IF(AND($K$6=\"Liquid/Slurry\",E24<=100,W24<9,L24<>\"\",U24<>\"Yes\"),VLOOKUP(L24,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D24),0,VLOOKUP(D24,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I25),0,IF(AND($K$6=\"Solid/Semi-solid\",E25<=100,W25<9,L25<>\"\"),VLOOKUP(L25,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I25),0,IF(AND($K$6=\"Liquid/Slurry\",E25<=100,W25<9,L25<>\"\",U25<>\"Yes\"),VLOOKUP(L25,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D25),0,VLOOKUP(D25,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I26),0,IF(AND($K$6=\"Solid/Semi-solid\",E26<=100,W26<9,L26<>\"\"),VLOOKUP(L26,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I26),0,IF(AND($K$6=\"Liquid/Slurry\",E26<=100,W26<9,L26<>\"\",U26<>\"Yes\"),VLOOKUP(L26,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D26),0,VLOOKUP(D26,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I27),0,IF(AND($K$6=\"Solid/Semi-solid\",E27<=100,W27<9,L27<>\"\"),VLOOKUP(L27,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I27),0,IF(AND($K$6=\"Liquid/Slurry\",E27<=100,W27<9,L27<>\"\",U27<>\"Yes\"),VLOOKUP(L27,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D27),0,VLOOKUP(D27,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I28),0,IF(AND($K$6=\"Solid/Semi-solid\",E28<=100,W28<9,L28<>\"\"),VLOOKUP(L28,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I28),0,IF(AND($K$6=\"Liquid/Slurry\",E28<=100,W28<9,L28<>\"\",U28<>\"Yes\"),VLOOKUP(L28,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D28),0,VLOOKUP(D28,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I29),0,IF(AND($K$6=\"Solid/Semi-solid\",E29<=100,W29<9,L29<>\"\"),VLOOKUP(L29,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I29),0,IF(AND($K$6=\"Liquid/Slurry\",E29<=100,W29<9,L29<>\"\",U29<>\"Yes\"),VLOOKUP(L29,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D29),0,VLOOKUP(D29,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I30),0,IF(AND($K$6=\"Solid/Semi-solid\",E30<=100,W30<9,L30<>\"\"),VLOOKUP(L30,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I30),0,IF(AND($K$6=\"Liquid/Slurry\",E30<=100,W30<9,L30<>\"\",U30<>\"Yes\"),VLOOKUP(L30,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D30),0,VLOOKUP(D30,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I31),0,IF(AND($K$6=\"Solid/Semi-solid\",E31<=100,W31<9,L31<>\"\"),VLOOKUP(L31,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I31),0,IF(AND($K$6=\"Liquid/Slurry\",E31<=100,W31<9,L31<>\"\",U31<>\"Yes\"),VLOOKUP(L31,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D31),0,VLOOKUP(D31,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I32),0,IF(AND($K$6=\"Solid/Semi-solid\",E32<=100,W32<9,L32<>\"\"),VLOOKUP(L32,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I32),0,IF(AND($K$6=\"Liquid/Slurry\",E32<=100,W32<9,L32<>\"\",U32<>\"Yes\"),VLOOKUP(L32,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D32),0,VLOOKUP(D32,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I33),0,IF(AND($K$6=\"Solid/Semi-solid\",E33<=100,W33<9,L33<>\"\"),VLOOKUP(L33,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I33),0,IF(AND($K$6=\"Liquid/Slurry\",E33<=100,W33<9,L33<>\"\",U33<>\"Yes\"),VLOOKUP(L33,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D33),0,VLOOKUP(D33,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I34),0,IF(AND($K$6=\"Solid/Semi-solid\",E34<=100,W34<9,L34<>\"\"),VLOOKUP(L34,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I34),0,IF(AND($K$6=\"Liquid/Slurry\",E34<=100,W34<9,L34<>\"\",U34<>\"Yes\"),VLOOKUP(L34,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D34),0,VLOOKUP(D34,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I35),0,IF(AND($K$6=\"Solid/Semi-solid\",E35<=100,W35<9,L35<>\"\"),VLOOKUP(L35,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I35),0,IF(AND($K$6=\"Liquid/Slurry\",E35<=100,W35<9,L35<>\"\",U35<>\"Yes\"),VLOOKUP(L35,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D35),0,VLOOKUP(D35,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I36),0,IF(AND($K$6=\"Solid/Semi-solid\",E36<=100,W36<9,L36<>\"\"),VLOOKUP(L36,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I36),0,IF(AND($K$6=\"Liquid/Slurry\",E36<=100,W36<9,L36<>\"\",U36<>\"Yes\"),VLOOKUP(L36,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D36),0,VLOOKUP(D36,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I37),0,IF(AND($K$6=\"Solid/Semi-solid\",E37<=100,W37<9,L37<>\"\"),VLOOKUP(L37,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I37),0,IF(AND($K$6=\"Liquid/Slurry\",E37<=100,W37<9,L37<>\"\",U37<>\"Yes\"),VLOOKUP(L37,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D37),0,VLOOKUP(D37,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I38),0,IF(AND($K$6=\"Solid/Semi-solid\",E38<=100,W38<9,L38<>\"\"),VLOOKUP(L38,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I38),0,IF(AND($K$6=\"Liquid/Slurry\",E38<=100,W38<9,L38<>\"\",U38<>\"Yes\"),VLOOKUP(L38,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D38),0,VLOOKUP(D38,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I39),0,IF(AND($K$6=\"Solid/Semi-solid\",E39<=100,W39<9,L39<>\"\"),VLOOKUP(L39,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I39),0,IF(AND($K$6=\"Liquid/Slurry\",E39<=100,W39<9,L39<>\"\",U39<>\"Yes\"),VLOOKUP(L39,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D39),0,VLOOKUP(D39,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I40),0,IF(AND($K$6=\"Solid/Semi-solid\",E40<=100,W40<9,L40<>\"\"),VLOOKUP(L40,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I40),0,IF(AND($K$6=\"Liquid/Slurry\",E40<=100,W40<9,L40<>\"\",U40<>\"Yes\"),VLOOKUP(L40,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D40),0,VLOOKUP(D40,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I41),0,IF(AND($K$6=\"Solid/Semi-solid\",E41<=100,W41<9,L41<>\"\"),VLOOKUP(L41,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I41),0,IF(AND($K$6=\"Liquid/Slurry\",E41<=100,W41<9,L41<>\"\",U41<>\"Yes\"),VLOOKUP(L41,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D41),0,VLOOKUP(D41,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I42),0,IF(AND($K$6=\"Solid/Semi-solid\",E42<=100,W42<9,L42<>\"\"),VLOOKUP(L42,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I42),0,IF(AND($K$6=\"Liquid/Slurry\",E42<=100,W42<9,L42<>\"\",U42<>\"Yes\"),VLOOKUP(L42,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D42),0,VLOOKUP(D42,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I43),0,IF(AND($K$6=\"Solid/Semi-solid\",E43<=100,W43<9,L43<>\"\"),VLOOKUP(L43,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I43),0,IF(AND($K$6=\"Liquid/Slurry\",E43<=100,W43<9,L43<>\"\",U43<>\"Yes\"),VLOOKUP(L43,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D43),0,VLOOKUP(D43,Lists!$A$30:$B$41,2,FALSE))","v":0}]
[null,null,null,null,null,null,null,null,"","",null,null,"",null,null,null,null,null,{"$f":"IF(ISBLANK(I44),0,IF(AND($K$6=\"Solid/Semi-solid\",E44<=100,W44<9,L44<>\"\"),VLOOKUP(L44,Lists!$A$45:$C$52,2,FALSE),0))","v":0},{"$f":"IF(ISBLANK(I44),0,IF(AND($K$6=\"Liquid/Slurry\",E44<=100,W44<9,L44<>\"\",U44<>\"Yes\"),VLOOKUP(L44,Lists!$A$45:$C$52,3,FALSE),0))","v":0},"",0,{"$f":"IF(ISBLANK(D44),0,VLOOKUP(D44,Lists!$A$30:$B$41,2,FALSE))","v":0}]
["Yellow highlighted cells indicate only injection costs are eligible.",null,null,null,null,"All Applied Acres:",{"$f":"SUMIFS(G11:G44,M11:M44,\">0\")","v":0},null,{"$f":"SUMIFS(I11:I44,M11:M44,\">0\")","v":0},"",null,null,{"$f":"SUM(M11:N44)","v":0},null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-solid\",M45,0)","v":0},{"$f":"IF(K6=\"Liquid/Slurry\",M45-V45,0)","v":0},null,{"$f":"SUM(V11:V44)","v":0}]
[null,null,null,null,null,"Injected Acres:",{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",W11:W44,\">0\",M11:M44,\">0\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-Solid\",SUMIFS(G11:G44,M11:M44,\">0\"),0)","v":0},"SOLID acres"]
["NOTES:","1Legumes (e.g., soybeans, >25% legume hay) are only eligible for injection costs.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Solid/Semi-solid\",SUMIFS(I11:I44,M11:M44,\">0\"),0)","v":0},"SOLID tons"]
[null,"2P-FIV≤100 is eligible for transport and/or injection costs. P-FIV 101 to 500 is eligible for injection costs only.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",SUMIFS(G11:G44,T11:T44,\">0\",M11:M44,\">0\"),0)","v":0},"LIQUID TRANSPORT acres"]
[null,"3Maximum application rate for liquid/slurry is 6,000 gal/ac;  Maximum application rate for solid/semi-solid is 10 tons/ac.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",SUMIFS(I11:I44,T11:T44,\">0\",M11:M44,\">0\"),0)","v":0},"LIQUID TRANSPORT gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6=\"Liquid/Slurry\",G45-G46,0)","v":0},"LIQUID TRANSPORT NOT INJECTED acres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(I11:I44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"<>Yes\")","v":0},"LIQUID TRANSPORT also INJECTED gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",W11:W44,\">0\",M11:M44,\">0\")","v":0},"INJECTION acres (all)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(I11:I44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"Yes\")","v":0},"INJECTION ONLY gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"<>Yes\")","v":0},"INJECTION and TRANSPORT acres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIFS(G11:G44,K11:K44,\"Yes\",M11:M44,\">0\",U11:U44,\"Yes\")","v":0},"INJECTION ONLY acres"]

{"sheet":"Invoice","index":10,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":false,"merged":[[14,1,14,3],[0,0,0,7],[3,4,3,6],[4,0,4,2],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[13,1,13,3],[2,0,2,7],[1,0,1,7],[15,1,15,3],[16,1,16,3],[17,1,17,3],[19,0,20,0],[19,1,20,3],[29,1,29,3],[19,5,20,5],[19,6,20,6],[19,7,20,7],[21,1,21,3],[22,1,22,3],[23,1,23,3],[19,4,20,4],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[37,0,38,7],[40,0,40,3],[36,0,36,6],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,5,34,6],[33,7,34,7],[35,4,35,6]]}
[" INVOICE"]
["For Manure Transport and/or Injection Performed by the Applicant"]
["(Invoices for transport and injection done by third parties and custom haulers must be provided separately)"]
[null,null,null,null,"INVOICE DATE:  "]
["Service Provider:"]
["Name:"]
["Farm or Company:"]
["Address:"]
["City, State, Zip:"]
["Phone:"]
[]
[]
["Billed To:"]
["Name:","Maryland Department of Agriculture"]
["Address:","Conservation Grants, Rm 207"]
[null,"50 Harry S. Truman Pkwy"]
["City, State, Zip:","Annapolis, MD 21401"]
[]
[]
["DATE","DESCRIPTION",null,null,"Units\n(i.e., gal, ton, ac)","Mileage","Cost per Unit","Total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"PAY THIS AMOUNT",null,{"$f":"SUM(H22:H33)","v":0}]
[]
[]
["The costs shown herin are true and correct to the best of my knowledge."]
[]
[]
[]
["Signature",null,null,null,null,"Date"]

{"sheet":"NMP Certification","index":11,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,0,2,9]]}
[]
["Link to the online fillable form is:"]
["https://mda.maryland.gov/resource_conservation/Documents/macs_manual/3/30_NMP_Certification_Form.pdf"]

{"sheet":"Lists","index":12,"n_rows":52,"n_cols":27,"rows_kept":52,"cut":false,"hidden":true,"merged":[[42,1,42,2]]}
["COUNTIES",null,null,"ANIMAL",null,"PROPERTY",null,"CONSISTENCY",null,null,null,null,"FARMS",null,null,"TRACTS",null,null,"MANURE_SOURCE",null,null,null,"MANURE_SOURCE_CONSIST",null,null,null,"CHECK_LIST"]
[]
["Allegany",null,null,"Dairy",null,{"$f":"APPLICATION_2!P7","v":0},null,"Liquid/Slurry",null,null,null,null,{"$f":"APPLICATION_2!B24","v":0},null,null,{"$f":"APPLICATION_2!F24","v":0},null,null,{"$f":"APPLICATION_2!J7","v":0},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,"√"]
["Anne Arundel",null,null,"Beef",null,{"$f":"APPLICATION_2!P8","v":0},null,"Solid/Semi-solid",null,null,null,null,{"$f":"APPLICATION_2!B25","v":0},null,null,{"$f":"APPLICATION_2!F25","v":0},null,null,{"$f":"APPLICATION_2!J8","v":0},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Baltimore County",null,null,"Swine",null,{"$f":"APPLICATION_2!P9","v":0},null,null,null,null,null,null,{"$f":"APPLICATION_2!B26","v":0},null,null,{"$f":"APPLICATION_2!F26","v":0},null,null,{"$f":"APPLICATION_2!J9","v":0},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Calvert",null,null,"Other",null,{"$f":"APPLICATION_2!P10","v":0},null,null,null,null,null,null,{"$f":"APPLICATION_2!B27","v":0},null,null,{"$f":"APPLICATION_2!F27","v":0},null,null,{"$f":"APPLICATION_2!J10","v":0},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Caroline",null,null,null,null,{"$f":"APPLICATION_2!P11","v":0},null,"CONSISTENCY",null,null,null,null,{"$f":"APPLICATION_2!B28","v":0},null,null,{"$f":"APPLICATION_2!F28","v":0},null,null,{"$f":"APPLICATION_2!J11","v":0}]
["Carroll",null,null,null,null,{"$f":"APPLICATION_2!P12","v":0},null,null,null,null,null,null,{"$f":"APPLICATION_2!B29","v":0},null,null,{"$f":"APPLICATION_2!F29","v":0},null,null,{"$f":"APPLICATION_2!J12","v":0}]
["Catoctin",null,null,null,null,{"$f":"APPLICATION_2!P13","v":0},null,"Liquid",null,null,null,null,{"$f":"APPLICATION_2!B30","v":0},null,null,{"$f":"APPLICATION_2!F30","v":0},null,null,{"$f":"APPLICATION_2!J13","v":0}]
["Cecil",null,null,null,null,{"$f":"APPLICATION_2!P14","v":0},null,"Solid",null,null,null,null,{"$f":"APPLICATION_2!B31","v":0},null,null,{"$f":"APPLICATION_2!F31","v":0},null,null,{"$f":"APPLICATION_2!J14","v":0}]
["Charles",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!B32","v":0},null,null,{"$f":"APPLICATION_2!F32","v":0}]
["Dorchester",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!B33","v":0},null,null,{"$f":"APPLICATION_2!F33","v":0}]
["Frederick",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M24","v":0},null,null,{"$f":"APPLICATION_2!Q24","v":0}]
["Garrett",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M25","v":0},null,null,{"$f":"APPLICATION_2!Q25","v":0}]
["Harford",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M26","v":0},null,null,{"$f":"APPLICATION_2!Q26","v":0}]
["Howard",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M27","v":0},null,null,{"$f":"APPLICATION_2!Q27","v":0}]
["Kent",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M28","v":0},null,null,{"$f":"APPLICATION_2!Q28","v":0}]
["Montgomery",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M29","v":0},null,null,{"$f":"APPLICATION_2!Q29","v":0}]
["Prince George's",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M30","v":0},null,null,{"$f":"APPLICATION_2!Q30","v":0}]
["Queen Anne's",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M31","v":0},null,null,{"$f":"APPLICATION_2!Q31","v":0}]
["St. Mary's",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M32","v":0},null,null,{"$f":"APPLICATION_2!Q32","v":0}]
["Talbot",null,null,null,null,null,null,null,null,null,null,null,{"$f":"APPLICATION_2!M33","v":0},null,null,{"$f":"APPLICATION_2!Q33","v":0}]
["Washington County"]
["Wicomico"]
["Worcester"]
[]
[]
[]
["CROPS","CROP CODE",null,null,null,null,null,null,"LOG_NO",null,null,null,"MI_LIST_LIQ",null,null,"MI_LIST_SOLID"]
[" ",0,null,null,null,null,null,null,null,null,null,null,"No",null,null,"n/a"]
["CORN",1,null,null,null,null,null,null,1,null,null,null,"Yes"]
["BARLEY",2,null,null,null,null,null,null,2]
["Hay(<25% legumes)",3,null,null,null,null,null,null,3]
["OATS",4,null,null,null,null,null,null,4]
["RYE",5,null,null,null,null,null,null,5]
["SORGHUM",6,null,null,null,null,null,null,6,null,null,null,"MI_LIST_LIQ_CLAIM"]
["TRITICALE",7,null,null,null,null,null,null,7,null,null,null,"N"]
["WHEAT",8,null,null,null,null,null,null,8,null,null,null,"Y (high P/leg.)"]
["Soybeans",9,null,null,null,null,null,null,null,null,null,null,"Y (low P)"]
["Hay(>25% legumes)",10]
["Other(contact MDA)",11]
[]
[null,"Cost-share rate",null,"MI only"]
["DISTANCE","Solid","Liquid MT only",">100 FIV"]
["< 1 mile",0,0,45]
["1−5",3.3,1.307E-2,45]
["5.1−10",3.9,1.4319999999999999E-2,45]
["10.1−15",4.5,1.5559999999999999E-2,45]
["15.1−20",5.0999999999999996,1.6809999999999999E-2,45]
["20.1−25",5.7,1.805E-2,45]
[">25 miles",0,0,45]
["Out-of-state",0,0,45]