{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["Template & Instructions","Example CSV-Ready to File","Royalty Rates","Product Codes","Transaction Codes","FAQ"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Template & Instructions","index":0,"n_rows":61,"n_cols":29,"rows_kept":61,"cut":false,"hidden":false,"merged":[[23,18,23,28],[24,24,24,28],[24,19,24,23]]}
["Step 1.","Creating the Excel / CSV worksheet"]
[]
["RECORD TYPE 5 - OGR1 Header. First cell must be 5 to denote record type.",{"$nulls":13}," "]
["Field Name","RET SUB DTE","OGRID","XMIT CTL NBR","SENDER ID","FINAL RET IND","REMIT RET IND","ACCEL ROY SALES MMYY","ACCEL ROY PMT","TOT ROY RPT","TOT INT RPT","TOT ASSMNT PD AMT","TOT ROY & ASSMNT PD","REG CR AMT","LSE CR AMT","ACCEL CLAIM SALES MMYY","ACCEL CLAIM PMT","TOT CR TAKEN","TOT ADV PMT","TOT REMIT AMT","PMT TYP","IO CHK","RET POSTM DTE","REPORTERS REF"]
["Field Description","Return submit date","Oil and Gas Reporting ID Number ","Unique Sequential Number used to identify the file transmission per OGRID and transaction type ","Login ID for Online Filing","Final Return or Not","Remit Return Indicator","Accelerated pmt fields no longer used","Accelerated pmt fields no longer used","Total Royalty reported","Interest reported field no longer used","Total amount paid as Assessments","Total Royalty & Assessments Paid Amount","Total Regular Credits Applied","Total Lease Credit Amount Applied","Accelerated pmt fields no longer used","Accelerated pmt fields no longer used","Total Credit taken","Total Amount of Advance Payment paid or taken as credit ","Total Remittance Amount","Type of Payment","Check from In or Out of NM","Postmark Return","Reporters Use"]
["Type","Numeric","Numeric","Numeric","Alpha","Alpha","Alpha","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Alpha","Numeric","Alpha"]
["Max Length",8,6,9,15,1,1,4,7,7,7,7,7,7,7,4,7,7,7,7.2,2,1,8,20]
["Validation","Format (YYYYMMDD) cannot be future date.","Must be the same OGRID selected at login to online filing.","Must be greater than the last XMIT CTL NBR used in sender's previous file , if the return was accepted. Recommend using the date in YYYYMMDD format. If submitting multiple returns, add a 1 at the end for the first file, 2 for the second, etc.","Validate that SENDER ID on CSV file matches the SENDER ID transmitting the return.","Y, N or Blank","Y, N or Blank","FIELD NOT USED \n(Enter 0)","FIELD NOT USED \n(Enter 0)","Sum of column P of detail lines. Can be negative or positive.","FIELD NOT USED \n(Enter 0)","Sum of all assessments added to return. Cannot be negative - must be 0 or greater.","Sum of columns J & L of this row. Can be negative or positive. ","Sum of all remittance credits added to return. Cannot be negative - must be 0 or greater.","Sum of all lease credits added to return. Cannot be negative - must be 0 or greater.","FIELD NOT USED \n(Enter 0)","FIELD NOT USED \n(Enter 0)","Sum of columns N & O of this row. Cannot be negative - must be 0 or greater.","Used only once per year after advance notices are sent. Can be negative or positive.","Column M minus column R, plus column S. Can be negative or positive.","Accepted values are:\n01 (Fedwire)\n02 (ACH Credit)\n03 (ACH Debit)\n04 (Check)","Values are “I” or “O”","Overlaid with system timestamp. Enter 0.","Optional field. Can be blank."]
[5,20260525,123456,202605251,"SenderID","N","N",0,0,176598,0,4150,180748,3000,0,0,0,3000,0,177748,1,"O",0,"NM-ROY"]
[null,null,null," "]
["RECORD TYPE 4 - Notices",null,"    [ This Record is used When a Payment is Made to an Assessment or a Credit Notice is Applied ]"]
["Field Name","OGRID","INVOICE NUM","AMT APPLIED/PAID"]
["Field Description","Oil and Gas Reporting Id #","Royalty Assessment or Credit Notice #","Amount Paid for the reported assessment or applied for the reported credit."]
["Type","Numeric","Alpha","Numeric"]
["Max Field Length",6,8,9]
["Validation","Must be same as OGRID listed on header row\n(OGR-1).","Must be 8 digits with beginning with “A”  for assessments and “C” for credits.  This # can be found on the notice.","Cannot be negative – must be 0 or greater."]
[4,123456,"A0012355",150]
[4,123456,"A0012456",4000]
[4,123456,"C0023178",3000]
[]
["RECORD TYPE 6  - OGR2 Detail"]
["Field Name","OGRID","SALE MTH/YR NUM","PUN","LEASE","PRD CDE","TRN CDE","ARMS LEN IND","VOL MCF BBLS","NGLS GAL","BTU NUM","GROSS PROCEEDS","TRANSP DED","MKT DED","GAS PROCESSING DED","TOT ROY PAID","REPORTERS USE","REPORTERS REF"]
["Field Description","Oil and Gas Reporting Identifier","Sales month/year","Number used to report on a distinct property, pool, OGRID","Lease Identifier","Product type","Transaction code for detail line entry","Arms Length Indicator","Volume of  Production reported as Oil=BBLS; Gas=MCF","Volume of NGLS in Gallons","BTU/Value","Report Actual (whole) Dollars received for sale of Product before Deductions","Allowable Transportation Deduction","Allowable Deduction for Market Preparation","Gas Processing Deduction","Total Royalty Paid Amount","Reporters Use","Reporters Reference"]
["Type","Numeric","Numeric","Numeric","Alpha Numeric","Numeric","Numeric","Alpha","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Alpha","Alpha","PRE=SUBMISSION QUALITY CHECK -- THE COLUMNS IN THIS SECTION WORK ONLY ON NEW/REBOOK LINES AND MUST BE DELETED/CLEARED BEFORE RETURN IS SUBMITTED"]
["Max Length",6,4,7,6,2,2,1,9,7,5,7,7,9,9,9,20,20,null,"ROYALTY CALCULATION TOOLS (prevent/limit PPAs)",{"$nulls":4},"REPORTING REQUIREMENTS CHECK (limit audit findings)"]
["Validation","Must be same as OGRID listed on header row\n(OGR-1).","MMYY","Must be 7 digits. See Royalty PUN Inquiry. If no PUN found, please enter the last 7 digits of the property's API number","If lease is unknown, please see Royalty PUN Inquiry link.","One or two digit code. See Product Codes tab.","Two digit code. See Transaction Codes tab.","“Y” if arms-length transaction or “N” if not","Can be negative, 0 or greater.","Can be negative, 0 or greater.","Can be negative, 0 or greater.","Can be negative, 0 or greater.","Can be negative, 0 or greater.","Can be negative, 0 or greater.","Can be negative, 0 or greater.","Gross proceeds less deductions, multiplied by royalty rate % - see table. Can be negative, 0 or greater. (Negative royalties allowed only on backout/reversal lines)","Can be blank. Some remitters use the property name or other reference here.","Can be blank. Some remitters use the property name or other reference here.","Ready to submit?","RMD Royalty Calculation ","Difference from reported amount","Is reported value acceptable? \n\nIf within $1 of reported amount, ok to submit, if not, must be corrected.","Do Deductions Exceed Gross Proceeds? \n\nIf no, ok to submit, if yes, must be corrected.","Mixed Positive/Negative Values\n\nLines reported must be either ALL negative or ALL positive","Missing BTUs\n\nAll prod code 3s and 11s require BTUs to be reported.","Missing NGLs\n\nAll prod code 7s and 11s require NGLs to be reported.","Missing Volume\n\nAll lines with reported values must include volumes","No Deducts on Gas Prod Code 4\n\nProd Code 4 is unprocessed gas and should not include deducts","No Gas Processing \nDeducts on Oil\n\nProd Codes 1 and 2 should not contain gas processing deducts."]
[6,123456,326,1399391,"V08026",1,51,"Y",6603,0,0,481957,4957,0,0,79500,0,0,{"$f":"IF(AND(EXACT(V27:AC27,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},{"$f":"ROUND(IF(P27<0,0,IF(G27=65,((L27-M27-N27-O27)*0.05),IF(G27=44,(L27-M27-N27-O27),IF(OR(LEFT(E27,2)=\"VC\",LEFT(E27,2)=\"SR\"),((L27-M27-N27-O27)*0.2),IF(LEFT(E27,2)=\"SG\",((L27-M27-N27-O27)*0.25),IF(LEFT(E27,2)=\"VB\",((L27-M27-N27-O27)*0.1875),IF(LEFT(E27,2)=\"V0\",((L27-M27-N27-O27)*0.16667),IF(LEFT(E27,2)=\"VZ\",((L27-M27-N27-O27)*0.16667),(L27-M27-N27-O27)*0.125)))))))),0)","v":79502},{"$f":"T27-P27","v":2},{"$f":"IF(AND(U27>-2,U27<2),\"Ok to Submit\",\"Calculation Error\")","v":"Calculation Error"},{"$f":"IF(L27<(M27+N27+O27),\"Deducts Exceed Gross Proceeds\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I27:P27,I27:P27<>K27))>0,MIN(_xlfn._xlws.FILTER(I27:P27,I27:P27<>K27))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(K27=0,F27=11),\"Add BTUs\",IF(AND(K27=0,F27=3),\"Add BTUs\",\"Ok to Submit\"))","v":"Ok to Submit"},{"$f":"IF(AND(J27=0,F27=11),\"Add NGLs\",IF(AND(J27=0,F27=7),\"Add NGLs\",\"Ok to Submit\"))","v":"Ok to Submit"},{"$f":"IF(AND(SUM(J27:P27)>0,I27=0),\"Add Vol\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(F27=4,(M27+N27+O27)>0),\"Use Prod Code 11\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(O27<>0,F27=1),\"No Gas Deducts on Oil\",IF(AND(O27<>F27=2),\"No Gas Deducts on Oil\",\"Ok to Submit\"))","v":"Ok to Submit"}]
[6,123456,326,1399391,"VB2250",1,51,"Y",6603,0,0,481957,4957,0,0,89438,0,0,{"$f":"IF(AND(EXACT(V28:AC28,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},{"$f":"ROUND(IF(P28<0,0,IF(G28=65,((L28-M28-N28-O28)*0.05),IF(G28=44,(L28-M28-N28-O28),IF(OR(LEFT(E28,2)=\"VC\",LEFT(E28,2)=\"SR\"),((L28-M28-N28-O28)*0.2),IF(LEFT(E28,2)=\"SG\",((L28-M28-N28-O28)*0.25),IF(LEFT(E28,2)=\"VB\",((L28-M28-N28-O28)*0.1875),IF(LEFT(E28,2)=\"V0\",((L28-M28-N28-O28)*0.16667),IF(LEFT(E28,2)=\"VZ\",((L28-M28-N28-O28)*0.16667),(L28-M28-N28-O28)*0.125)))))))),0)","v":89438},0,{"$f":"IF(AND(U28>-2,U28<2),\"Ok to Submit\",\"Calculation Error\")","v":"Ok to Submit"},{"$f":"IF(L28<(M28+N28+O28),\"Deducts Exceed Gross Proceeds\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I28:P28,I28:P28<>K28))>0,MIN(_xlfn._xlws.FILTER(I28:P28,I28:P28<>K28))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(K28=0,F28=11),\"Add BTUs\",IF(AND(K28=0,F28=3),\"Add BTUs\",\"Ok to Submit\"))","v":"Ok to Submit"},{"$f":"IF(AND(J28=0,F28=11),\"Add NGLs\",IF(AND(J28=0,F28=7),\"Add NGLs\",\"Ok to Submit\"))","v":"Ok to Submit"},{"$f":"IF(AND(SUM(J28:P28)>0,I28=0),\"Add Vol\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(F28=4,(M28+N28+O28)>0),\"Use Prod Code 11\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(O28<>0,F28=1),\"No Gas Deducts on Oil\",IF(AND(O28<>F28=2),\"No Gas Deducts on Oil\",\"Ok to Submit\"))","v":"Ok to Submit"}]
[6,123456,326,1348531,"VB2303",1,51,"Y",238,0,0,19346,0,0,0,1813,0,0,{"$f":"IF(AND(EXACT(V29:AC29,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},3627,1814,"Calculation Error","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I29:P29,I29:P29<>K29))>0,MIN(_xlfn._xlws.FILTER(I29:P29,I29:P29<>K29))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1348531,"VC1120",1,51,"Y",475,0,0,38692,0,0,0,3869,0,0,{"$f":"IF(AND(EXACT(V30:AC30,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},7738,3869,"Calculation Error","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I30:P30,I30:P30<>K30))>0,MIN(_xlfn._xlws.FILTER(I30:P30,I30:P30<>K30))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1348531,"VB2303",11,51,"Y",117,745,1385,453,0,0,-96,103,0,0,{"$f":"IF(AND(EXACT(V31:AC31,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},103,0,"Ok to Submit",{"$f":"IF(L31<(M31+N31+O31),\"Deducts Exceed Gross Proceeds\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I31:P31,I31:P31<>K31))>0,MIN(_xlfn._xlws.FILTER(I31:P31,I31:P31<>K31))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Values should be all + or -"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1348531,"VC1120",11,51,"Y",233,1490,1385,906,0,0,-191,219,0,0,{"$f":"IF(AND(EXACT(V32:AC32,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},219,0,"Ok to Submit",{"$f":"IF(L32<(M32+N32+O32),\"Deducts Exceed Gross Proceeds\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I32:P32,I32:P32<>K32))>0,MIN(_xlfn._xlws.FILTER(I32:P32,I32:P32<>K32))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Values should be all + or -"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1404054,"L05364",1,51,"Y",15374,0,0,1098782,0,0,0,137348,0,0,{"$f":"IF(AND(EXACT(V33:AC33,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},137348,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I33:P33,I33:P33<>K33))>0,MIN(_xlfn._xlws.FILTER(I33:P33,I33:P33<>K33))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1404054,"L05364",1,51,"Y",13217,0,0,906947,0,0,0,113368,0,0,{"$f":"IF(AND(EXACT(V34:AC34,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},113368,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I34:P34,I34:P34<>K34))>0,MIN(_xlfn._xlws.FILTER(I34:P34,I34:P34<>K34))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1404054,"L05364",1,51,"Y",10363,0,0,681600,0,0,1500,85013,0,0,{"$f":"IF(AND(EXACT(V35:AC35,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},85013,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I35:P35,I35:P35<>K35))>0,MIN(_xlfn._xlws.FILTER(I35:P35,I35:P35<>K35))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","No Gas Deducts on Oil"]
[6,123456,326,1404054,"L05364",1,51,"Y",6884,0,0,512123,0,0,1000,63890,0,0,{"$f":"IF(AND(EXACT(V36:AC36,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},63890,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I36:P36,I36:P36<>K36))>0,MIN(_xlfn._xlws.FILTER(I36:P36,I36:P36<>K36))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","No Gas Deducts on Oil"]
[6,123456,326,1379080,"E01935",3,51,"Y",1252,0,1084,3770,459,0,1586,216,0,0,{"$f":"IF(AND(EXACT(V37:AC37,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},216,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I37:P37,I37:P37<>K37))>0,MIN(_xlfn._xlws.FILTER(I37:P37,I37:P37<>K37))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1379080,"E03513",3,51,"Y",1565,0,1084,4712,574,0,1983,270,0,0,{"$f":"IF(AND(EXACT(V38:AC38,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},269,-1,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I38:P38,I38:P38<>K38))>0,MIN(_xlfn._xlws.FILTER(I38:P38,I38:P38<>K38))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1379080,"E05999",3,51,"Y",1252,0,0,3770,459,0,1586,216,0,0,{"$f":"IF(AND(EXACT(V39:AC39,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},216,{"$f":"T39-P39","v":0},{"$f":"IF(AND(U39>-2,U39<2),\"Ok to Submit\",\"Calculation Error\")","v":"Ok to Submit"},{"$f":"IF(L39<(M39+N39+O39),\"Deducts Exceed Gross Proceeds\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I39:P39,I39:P39<>K39))>0,MIN(_xlfn._xlws.FILTER(I39:P39,I39:P39<>K39))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},{"$f":"IF(AND(K39=0,F39=11),\"Add BTUs\",IF(AND(K39=0,F39=3),\"Add BTUs\",\"Ok to Submit\"))","v":"Add BTUs"},{"$f":"IF(AND(J39=0,F39=11),\"Add NGLs\",IF(AND(J39=0,F39=7),\"Add NGLs\",\"Ok to Submit\"))","v":"Ok to Submit"},{"$f":"IF(AND(SUM(J39:P39)>0,I39=0),\"Add Vol\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit",{"$f":"IF(AND(O39<>0,F39=1),\"No Gas Deducts on Oil\",IF(AND(O39<>F39=2),\"No Gas Deducts on Oil\",\"Ok to Submit\"))","v":"Ok to Submit"}]
[6,123456,326,1379080,"E06434",3,51,"Y",2191,0,0,6597,803,0,2776,377,0,0,{"$f":"IF(AND(EXACT(V40:AC40,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},377,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I40:P40,I40:P40<>K40))>0,MIN(_xlfn._xlws.FILTER(I40:P40,I40:P40<>K40))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Add BTUs","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1379080,"E01935",7,51,"Y",0,8730,0,5281,0,0,7000,-215,0,0,{"$f":"IF(AND(EXACT(V41:AC41,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},0,215,"Calculation Error","Deducts Exceed Gross Proceeds",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I41:P41,I41:P41<>K41))>0,MIN(_xlfn._xlws.FILTER(I41:P41,I41:P41<>K41))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Values should be all + or -"},"Ok to Submit","Ok to Submit","Add Vol","Ok to Submit","Ok to Submit"]
[6,123456,326,1379080,"E03513",7,51,"Y",0,10913,0,6601,0,0,7000,-50,0,0,{"$f":"IF(AND(EXACT(V42:AC42,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},0,{"$f":"T42-P42","v":50},"Calculation Error","Deducts Exceed Gross Proceeds",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I42:P42,I42:P42<>K42))>0,MIN(_xlfn._xlws.FILTER(I42:P42,I42:P42<>K42))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Values should be all + or -"},"Ok to Submit","Ok to Submit","Add Vol","Ok to Submit","Ok to Submit"]
[6,123456,326,1379080,"E05999",7,51,"Y",466,8730,0,5281,0,0,590,586,0,0,{"$f":"IF(AND(EXACT(V43:AC43,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},586,{"$f":"T43-P43","v":0},"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I43:P43,I43:P43<>K43))>0,MIN(_xlfn._xlws.FILTER(I43:P43,I43:P43<>K43))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1379080,"E06434",7,51,"Y",815,15278,0,9241,0,0,1032,1026,0,0,{"$f":"IF(AND(EXACT(V44:AC44,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},1026,{"$f":"T44-P44","v":0},"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I44:P44,I44:P44<>K44))>0,MIN(_xlfn._xlws.FILTER(I44:P44,I44:P44<>K44))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1338196,"VB1507",7,51,"Y",1122,24236,0,24637,1643,427,1515,3947,0,0,{"$f":"IF(AND(EXACT(V45:AC45,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},3947,{"$f":"T45-P45","v":0},"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I45:P45,I45:P45<>K45))>0,MIN(_xlfn._xlws.FILTER(I45:P45,I45:P45<>K45))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1354608,"VB1507",7,51,"Y",460,15502,0,15938,1045,270,966,2561,0,0,{"$f":"IF(AND(EXACT(V46:AC46,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},2561,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I46:P46,I46:P46<>K46))>0,MIN(_xlfn._xlws.FILTER(I46:P46,I46:P46<>K46))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1355271,"VB1507",7,51,"Y",1107,37489,0,38685,2524,651,2332,6221,0,0,{"$f":"IF(AND(EXACT(V47:AC47,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},6221,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I47:P47,I47:P47<>K47))>0,MIN(_xlfn._xlws.FILTER(I47:P47,I47:P47<>K47))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1366419,"VB1507",7,51,"Y",0,0,0,47509,3169,821,2918,7612,0,0,{"$f":"IF(AND(EXACT(V48:AC48,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},7613,1,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I48:P48,I48:P48<>K48))>0,MIN(_xlfn._xlws.FILTER(I48:P48,I48:P48<>K48))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Add NGLs","Add Vol","Ok to Submit","Ok to Submit"]
[6,123456,326,1374635,"V08171",7,51,"Y",0,0,0,59486,3825,1022,3545,8516,0,0,{"$f":"IF(AND(EXACT(V49:AC49,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},8516,{"$f":"T49-P49","v":0},"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I49:P49,I49:P49<>K49))>0,MIN(_xlfn._xlws.FILTER(I49:P49,I49:P49<>K49))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Add NGLs","Add Vol","Ok to Submit","Ok to Submit"]
[6,123456,326,1404948,"B04918",4,51,"Y",665,0,0,876,0,0,75,100,0,0,{"$f":"IF(AND(EXACT(V50:AC50,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},100,{"$f":"T50-P50","v":0},"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I50:P50,I50:P50<>K50))>0,MIN(_xlfn._xlws.FILTER(I50:P50,I50:P50<>K50))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Use Prod Code 11","Ok to Submit"]
[6,123456,326,1404948,"K04795",4,51,"Y",3987,0,0,5257,0,0,257,625,0,0,{"$f":"IF(AND(EXACT(V51:AC51,\"Ok to Submit\")),\"Yes\",\"No\")","v":"No"},625,{"$f":"T51-P51","v":0},"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I51:P51,I51:P51<>K51))>0,MIN(_xlfn._xlws.FILTER(I51:P51,I51:P51<>K51))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Use Prod Code 11","Ok to Submit"]
[6,123456,326,1404948,"L06518",4,51,"Y",5596,0,0,7378,0,0,0,922,0,0,{"$f":"IF(AND(EXACT(V52:AC52,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},922,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I52:P52,I52:P52<>K52))>0,MIN(_xlfn._xlws.FILTER(I52:P52,I52:P52<>K52))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1292288,"V06885",4,51,"Y",340,0,0,248,0,0,0,41,0,0,{"$f":"IF(AND(EXACT(V53:AC53,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},41,0,"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I53:P53,I53:P53<>K53))>0,MIN(_xlfn._xlws.FILTER(I53:P53,I53:P53<>K53))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1374195,"E05896",16,51,"Y",21,0,12280,80,0,0,0,10,0,0,{"$f":"IF(AND(EXACT(V54:AC54,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},10,{"$f":"T54-P54","v":0},"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I54:P54,I54:P54<>K54))>0,MIN(_xlfn._xlws.FILTER(I54:P54,I54:P54<>K54))<0),\"Correct Reporting\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[6,123456,326,1374195,"E05898",16,51,"Y",21,0,12280,80,0,0,0,10,0,0,{"$f":"IF(AND(EXACT(V55:AC55,\"Ok to Submit\")),\"Yes\",\"No\")","v":"Yes"},10,{"$f":"T55-P55","v":0},"Ok to Submit","Ok to Submit",{"$f":"IF(AND(MAX(_xlfn._xlws.FILTER(I55:P55,I55:P55<>K55))>0,MIN(_xlfn._xlws.FILTER(I55:P55,I55:P55<>K55))<0),\"Values should be all + or -\",\"Ok to Submit\")","v":"Ok to Submit"},"Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit","Ok to Submit"]
[]
["Step 2.","Delete all rows that do not begin with a Record Type 5, 4, or 6. All that should remain are the blue highlighted cells. See Example - CSV Ready to File. Remove highlighting, save as CSV and submit."]
[]
["RESOURCES"]
["Royalty Filers' Kit"]
["Royalty PUN Inquiry Website"]

{"sheet":"Example CSV-Ready to File","index":1,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[5,"20260525",123456,"202605251","SenderID","N","N",0,0,"607552",0,4150,{"$f":"L1+J1","v":611702},3000,0,0,0,3000,0,{"$f":"M1-R1","v":608702},1,"O",0,"NM-ROY"]
[4,123456,"A0012355",150]
[4,123456,"A0012456",4000]
[4,123456,"C0023178",3000]
[6,123456,326,1399391,"V08026",1,51,"Y",6603,0,0,481957,4957,0,0,79500,0,0]
[6,123456,326,1399391,"VB2250",1,51,"Y",6603,0,0,481957,4957,0,0,89438,0,0]
[6,123456,326,1348531,"VB2303",1,51,"Y",238,0,0,19346,0,0,0,1813,0,0]
[6,123456,326,1348531,"VC1120",1,51,"Y",475,0,0,38692,0,0,0,3869,0,0]
[6,123456,326,1348531,"VB2303",11,51,"Y",117,745,1385,453,0,0,-96,103,0,0]
[6,123456,326,1348531,"VC1120",11,51,"Y",233,1490,1385,906,0,0,-191,219,0,0]
[6,123456,326,1404054,"L05364",1,51,"Y",15374,0,0,1098782,0,0,0,137348,0,0]
[6,123456,326,1404054,"L05364",1,51,"Y",13217,0,0,906947,0,0,0,113368,0,0]
[6,123456,326,1404054,"L05364",1,51,"Y",10363,0,0,681600,0,0,1500,85013,0,0]
[6,123456,326,1404054,"L05364",1,51,"Y",6884,0,0,512123,0,0,1000,63890,0,0]
[6,123456,326,1379080,"E01935",3,51,"Y",1252,0,1084,3770,459,0,1586,216,0,0]
[6,123456,326,1379080,"E03513",3,51,"Y",1565,0,1084,4712,574,0,1983,270,0,0]
[6,123456,326,1379080,"E05999",3,51,"Y",1252,0,0,3770,459,0,1586,216,0,0]
[6,123456,326,1379080,"E06434",3,51,"Y",2191,0,0,6597,803,0,2776,377,0,0]
[6,123456,326,1379080,"E01935",7,51,"Y",0,8730,0,5281,0,0,7000,-215,0,0]
[6,123456,326,1379080,"E03513",7,51,"Y",0,10913,0,6601,0,0,7000,-50,0,0]
[6,123456,326,1379080,"E05999",7,51,"Y",466,8730,0,5281,0,0,590,586,0,0]
[6,123456,326,1379080,"E06434",7,51,"Y",815,15278,0,9241,0,0,1032,1026,0,0]
[6,123456,326,1338196,"VB1507",7,51,"Y",1122,24236,0,24637,1643,427,1515,3947,0,0]
[6,123456,326,1354608,"VB1507",7,51,"Y",460,15502,0,15938,1045,270,966,2561,0,0]
[6,123456,326,1355271,"VB1507",7,51,"Y",1107,37489,0,38685,2524,651,2332,6221,0,0]
[6,123456,326,1366419,"VB1507",7,51,"Y",0,0,0,47509,3169,821,2918,7612,0,0]
[6,123456,326,1374635,"V08171",7,51,"Y",0,0,0,59486,3825,1022,3545,8516,0,0]
[6,123456,326,1404948,"B04918",4,51,"Y",665,0,0,876,0,0,75,100,0,0]
[6,123456,326,1404948,"K04795",4,51,"Y",3987,0,0,5257,0,0,257,625,0,0]
[6,123456,326,1404948,"L06518",4,51,"Y",5596,0,0,7378,0,0,0,922,0,0]
[6,123456,326,1292288,"V06885",4,51,"Y",340,0,0,248,0,0,0,41,0,0]
[6,123456,326,1374195,"E05896",16,51,"Y",21,0,12280,80,0,0,0,10,0,0]
[6,123456,326,1374195,"E05898",16,51,"Y",21,0,12280,80,0,0,0,10,0,0]

{"sheet":"Royalty Rates","index":2,"n_rows":32,"n_cols":3,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[31,0,32,1],[29,0,30,1]]}
["NM STATE LAND OFFICE"]
["ROYALTY MANAGEMENT DIVISION"]
["ROYALTY RATES"]
[]
["LEASE PREFIX *","ROYALTY RATE"]
["X0",0.125]
["00",0.125]
["A0",0.125]
["BA",0.125]
["BH",0.125]
["B1",0.125]
["B0",0.125]
["C0",0.125]
["E0",0.125]
["E1",0.125]
["OG",0.125]
["K0",0.125]
["L0",0.125]
["LG",0.125]
["LH",0.125]
["LZ",0.125]
["SG",0.25]
["SR",0.2]
["V0",0.16667000000000001,"**"]
["VZ",0.16667000000000001,"**"]
["VA",0.125]
["VB",0.1875]
["VC",0.2]
[]
["* Lease Prefix character is Zero, not the letter \"O\""]
[]
["** Use exactly 16.667% for royalty calculation to match system calculation"]

{"sheet":"Product Codes","index":3,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[16,0,16,1]]}
["NM STATE LAND OFFICE"]
["ROYALTY MANAGEMENT DIVISION"]
["PRODUCT CODES"]
[" "," "]
["PRODUCT #","PRODUCT NAME"]
[1,"Oil"]
[2,"Oil Condensate"]
[3,"Gas, processed (residue) gas"]
[4,"Gas, wet"]
[5,"Oil, other liquid hydrocarbons"]
[7,"Gas Plants Products "]
[11,"Gas, Wellhead natural gas"]
[14,"Oil, lost * "]
[16,"Gas lost, flared or vented"]
[17,"Carbon Dioxide gas (CO2)"]
[]
["* Royalties are due on unrecovered spilled oil in excess of 10 BBLS"]

{"sheet":"Transaction Codes","index":4,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
["NM STATE LAND OFFICE"]
["ROYALTY MANAGEMENT DIVISION"]
["TRANSACTION CODES"]
[" "," "]
["CODE #","TRANSACTION NAME","FREQUENCY OF USE"]
[43,"Royalty in kind payment","Rare"]
[44,"Royalty in trespass payment","Infrequent"]
[49,"Unit contraction/expansion","Infrequent"]
[51,"Regular payment","Frequent"]
[52,"Estimated payment","Rare"]
[53,"Correction of estimated payment","Rare"]
[54,"Appeal/Court action payment","Rare"]
[55,"Audit and Compliance exception payment","Frequent"]
[59,"Settlement payment","Rare"]
[60,"Transfer of royalty payment","Rare"]
[63,"Compensatory royalty payment","Rare"]
[65,"Stripper Well reduced royalty payment","Frequent"]

{"sheet":"FAQ","index":5,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[[42,0,42,9],[0,0,0,9],[36,0,36,9],[37,0,37,9],[38,0,38,9],[39,0,39,9],[40,0,40,9],[41,0,41,9],[30,0,30,9],[31,0,31,9],[32,0,32,9],[33,0,33,9],[34,0,34,9],[35,0,35,9],[24,0,24,9],[25,0,25,9],[26,0,26,9],[27,0,27,9],[28,0,28,9],[29,0,29,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[21,0,21,9],[22,0,22,9],[23,0,23,9],[17,0,17,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[6,0,6,9],[7,0,7,9],[8,0,8,9],[9,0,9,9],[10,0,10,9],[13,0,13,9],[16,0,16,9],[11,0,11,9],[12,0,12,9],[14,0,14,9],[15,0,15,9]]}
["Frequently Asked Questions"]
[]
["1. How do I report Negative Gross Proceeds or Negative Net Proceeds?"]
["If the gross price is negative, please report the volumes produced and 0 for your gross proceeds, deductions, and royalties paid.   If only the net price is negative (deductions exceed proceeds), please report the volumes and positive gross proceeds and include allowable deductions equal to the value of the gross proceeds, and 0 for your royalties paid."]
[]
["2. Is there a limit on the number of lines in a return?"]
["For new sales returns, there is no limit. For prior period adjustments (PPAs), no return may be submitted to amend reporting for more than 12 sales periods (1 year) in a single return, and must be split into multiple returns for more than 1 year of amendments or for files with more than 5,000 detail lines. "]
[]
["3. Do we have to amend all reporting if only certain properties' information has changed?"]
["No, full-month amendments are not required. Only detail lines with changes to volumes/values should be submitted. "]
[]
["4. Can I net my current new sales with credit PPAs submitted in the same month?"]
["No, netting payment for new sales returns against amended returns submitted in the same month is not allowed. Amended returns must be processed and credit IDs must be issued before credits can be used for future royalties due."]