{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions - Create File","Cover","Schedule","Summary","Tables"],"not_rendered":{"charts":0,"images":17,"macros":1,"external_links":0,"defined_names":8,"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 - Create File","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,2,1],[1,0,1,1]]}
[]
["Instructions For"]
["Minnesota Revenue Fuel Reporting Schedule"]
["1.","Save the original template.  When you begin entering shipment data, resave the "]
[null,"template according to the month you will be filing (example:  August 2007 return could"]
[null,"be saved as \"Aug_2007\").  The next month you will start with the original template"]
[null," and repeat the above step for the next month."]
["2.","Enter all information requested on the \"Cover\" worksheet (click on the \"Cover\" tab below). "]
["3.","Enter all schedule information for summary schedules and transaction schedules on the "]
[null,"Schedule worksheet (click on \"schedule\" tab below).  To sort by column, "]
[null,"click on the column you wish to sort on.  Click again to change sort order.  "]
[null,"Note: Every transaction must contain a schedule code (click on the \"table\" tab below"]
[null," to view schedule, product, mode, and state codes)."]
[null,"Note: All gallons must be entered as whole numbers."]
["4.","Do not skip rows between shipments or leave the schedule code blank.  This may"]
[null,"cause the summary to be inaccurate."]
["5.","Save the Excel workbook and the data input for this tax form for your records.  Do so by "]
[null,"selecting \"File, Save As\" from the menu and then identifying the file name and location."]
["6.","Create a Flat File by clicking on the button below.  You will be required to identify a file name "]
[null,"and location for your flat file.  The summary page is calculated when the file is created.  "]
[]
[]
[]
[]
[]
[null,"If button fails to create flat file, please press CTRL + w to create flat file."]

{"sheet":"Cover","index":1,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[]
[]
["Filing Period:"]
["Period Ending Date (Format of entry  must be \"05/31/04\", MM/DD/YY)"]
["Account Information:"]
["Minnesota License Number (Enter 7 numeric digits of account number \"1234567\")"]
["Location Code (\"1\", \"2\")"]
["Taxpayer's FEIN or SSN"]
["Name (Enter legal name on BOE application)"]
[]
[]
[]
[]
[]
[]
[]
["Return Information:"]
["1. Total Gallons reported",0]
["E-Filing Information:"]
["Sender's FEIN (May be same as taxpayer)"]
["Test/Production (T or P to identify test or production filing. Must be capitalized.)","P"]
["Transaction Set Purpose Code (\"O\" = Original, \"A\" = Amended)","O"]
["No Activity Code (No Activity = \"1\")"]
["Minnesota Revenue Use Only:"]
["Report Type","TOR"]
["File Type","TXT"]
["Version","1.1"]
["File Signature","804832376066"]
["Total Tax Due",0]

{"sheet":"Schedule","index":2,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Schedule Code","Product Code","Supplier Name","Supplier FEIN",null,"Position Hldr","Carrier Name","Carrier FEIN","Mode","Terminal or Origin","Dest. State","Dist/Buyer Name","Dist/Buyer FEIN","Ship Date (mm/dd/yy)","Bill of Lading",null,"Gross Gallons"]

{"sheet":"Summary","index":3,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,1,0,2],[0,4,0,5],[4,0,4,1],[5,0,5,1],[3,0,3,1]]}
["Producers:",{"$f":"IF(Cover!B9<>\"\",Cover!B9,\"Not Available\")","v":"Not Available"},null,"Period:",{"$f":"IF(Cover!B4<>\"\",Cover!B4,\"Invalid Period\")","v":"Invalid Period"}]
[]
[]
["Product",null,"Tax Paid\n Gallons","Tax Free\nGallons","Terminal \nGallons","Exported\nGallons"]
["Alcohol",null,0,0,0,0]
["Biodiesel- Undyed (B100)",null,0,0,0,0]
["Biodiesel  Dyed (B100)",null,0,0,0,0]
["Natural Gasoline",null,0,0,0,0]
["E85",null,0,0,0,0]

{"sheet":"Tables","index":4,"n_rows":63,"n_cols":3,"rows_kept":63,"cut":false,"hidden":false,"merged":[[68,4,70,7],[8,0,8,1],[1,0,1,2],[16,0,16,1]]}
[]
["Schedule Codes"]
["Code","Description","Record"]
["5","Gallons delivered tax collected (sale to non-licensed)","Detail"]
["6","Gallons delivered to licensed distributors or special fuel dealer - tax not collected","Detail"]
["7","Gallons Exported","Detail"]
["10F","Gallons delivered to tax free storage or terminal","Detail"]
[]
["Product Codes"]
["Codes","Description"]
["061","Natural Gasoline"]
["123","Alcohol"]
["284","Biodiesel- Undyed (B100)"]
["290","Biodiesel  Dyed (B100)"]
["079","E85"]
[]
["Terminal Codes"]
["IRS Code","Terminal Name","City"]
["T41MN3400","NuStar Pipeline Operating Partnership, L.P. - Moorhead","Moorhead"]
["T41MN3401","NuStar Pipeline Operating Partnership, L.P. - Sauk Centre","Sauk Centre"]
["T41MN3402","Kinder Morgan Liquid Terminals LLC","Spring Valley"]
["T41MN 3403","NuStar Pipeline Operating Partnership, L.P. - Roseville","Roseville"]
["T41MN3404","Western Refining - St. Paul Park","St. Paul Park"]
["T41MN3405","Magellan Pipeline Company, L.P.","Wrenshall"]
["T41MN3406","Newport Terminal Corporation","Newport"]
["T41MN3407","Flint Hills Resources, LP-Pine Bend","St. Paul"]
["T41MN3410","Superior Refining Company LLC","Esko"]
["T41MN3412","Magellan Pipeline Company, L.P.","Alexandria"]
["T41MN3413","Magellan Pipeline Company, L.P.","Mankato"]
["T41MN3414","Magellan Pipeline Company, L.P.","Marshall"]
["T41MN3415","Magellan Pipeline Company, L.P.-Roseville","St Paul"]
["T41MN3416","Magellan Pipeline Company, L.P.-Rochester","Eyota"]
["T41MN3417","BNSF - Northtown","Minneapolis"]
["T41MN3419","Swissport Fueling Inc","Minneapolis"]
["T41MN3420","Signature Flight Support Corp.","Minneapolis"]
["T41MN3425","Northern States Power Co, Wisconsin","Eau Claire, WI"]
["T41MN3426","NGL Supply Terminal Company LLC - Rosemount","Rosemount"]
["T41MN3800","REG Albert Lea","Glenville"]
["T41MN3801","Minnesota Soybean Processors","Brewster"]
["T41MN3802","EverCat Fuels","Isanti"]
["T41MN3803","Al-Corn Clean Fuel","Claremont"]
["T41MN3804","Archer Daniels Midland","Marshall"]
["T41MN3805","BioFuels Energy-Buffalo Lake Energy, LLC","Fairmont"]
["T41MN3806","Bushmills Ethanol, Inc","Atwater"]
["T41MN3807","Central MN Ethanol Coop","Little Falls"]
["T41MN3808","Chippewa Valley Ethanol Co.","Benson"]
["T41MN3809","Corn Plus, LLP","Winnebago"]
["T41MN3810","DENCO II","Morris"]
["T41MN3811","GEVO","Luverne"]
["T41MN3812","Granite Falls Energy, LLC","Granite Falls"]
["T41MN3813","Green Plains Renewable Energy","Fergus Falls"]
["T41MN3814","Guardian Energy","Janesville"]
["T41MN3815","Heartland Corn Products","Winthrop"]
["T41MN3816","Heron Lake BioEnergy, LLC","Heron Lake"]
["T41MN3817","Highwater Ethanol LLC","Lamberton"]
["T41MN3818","Land O'Lakes","Melrose"]
["T41MN3819","POET Biorefinering - Bingham Lake","Bingham Lake"]
["T41MN3820","POET Biorefinering - Glenville","Albert Lea"]
["T41MN3821","POET Biorefinering - Lake Crystal","Lake Crystal"]
["T41MN3822","POET Biorefinering - Preston","Preston"]
["T41MN3823","Purified Renewable Energy","Buffalo Lake"]
["T41MN3824","Valero Renewable Fuels","Welcome"]
["T41MN3825","HUGO Railyard transfer station","Hugo"]