{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["IFTA"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"IFTA","index":0,"n_rows":107,"n_cols":14,"rows_kept":107,"cut":false,"hidden":false,"merged":[[78,4,78,7],[33,4,33,7],[9,6,9,7],[10,6,10,9],[10,1,10,5],[30,2,30,3],[28,2,28,3],[9,1,9,5],[26,7,26,9],[11,1,11,5],[3,1,3,5],[9,8,9,9],[8,8,8,9],[35,4,35,7],[4,4,4,7],[5,4,5,7],[7,6,7,7]]}
[]
[]
[]
[null,"     Diesel Fuel Schedule D.",null,null,null,null,null,null,null,null,{"$f":"TEXT(K5,0)","v":"1"},"for print error"]
[null,null,null,null,"4th Quarter 2014",null,null,null,null,null,{"$f":"+K7+K32+K33","v":1}]
[null,"  Press Ctrl/P to Print",null,null,"October 1, 2014 to December 31, 2014"]
[null,null,null,null,null,"Due Date is","2015-01-31",null,null,null,{"$f":"+K11-K10","v":1}]
[null,"Is this the correct period?",null,null,null,null,null,null,"Mail Date:",null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Ohio 7 digit IFTA Account Number *",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G10),1,0)","v":1}]
[null,"Name on Ohio IFTA Account *",null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(G11),2,0)","v":2}]
[null,{"$f":"IF($K$10+$K$11>0,\"(* Must complete account number and name to print)\",0)","v":"(* Must complete account number and name to print)"}]
[]
[null,"This worksheet is provided to assist you in completing your IFTA return.     It is not a substitute for the return itself,  but should be"]
[null,"submitted along with the IFTA return.        For proper processing, please place this schedule inside the return."]
[null,"This is DIESEL schedule only.    Do not use for gasoline or other fuel types.    Round all miles and gallons to nearest whole number."]
[null,"Error messages will appear below if miles and/or gallons do not add to totals."]
[]
[null,{"$f":"IF(J8>G7,\"Return is mailed after due date. Late fees and interest may be billed to you at a later date, or deducted from refund.\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Calculated"]
[null,"Enter Total Miles Traveled Everywhere - All Jurisdictions:",null,null,null,null,0,null,null,"Tax Due  OR",{"$f":"ROUND(G21,0)","v":0}]
[null,"Enter Total Gallons Placed in Vehicles",null,null,null,null,0,"Calc MPG",null,"Refund",{"$f":"ROUND(G22,0)","v":0}]
[null,"Enter Miles per Gallon (MPG) - round to 2 decimal places",null,null,null,null,null,{"$f":"IF(G22>0,ROUND(K21/K22,2),0)","v":0},null,{"$f":"J105","v":0}]
[null,"If filed after due date please enter number of months late to calculate interest",null,null,null,null,null,null,null,"Months Late"]
[null,{"$f":"IF(K32<>0,\"Error - Total Miles Everywhere Not Equal To State Detail Miles Listed Below by \"&-(K32)&\" miles - Must Fix to Print\",\"When completed - please place this printed schedule inside the IFTA return.\")","v":"When completed - please place this printed schedule inside the IFTA return."}]
[null,{"$f":"IF(K33>0,\"Error - Tax Paid Gallons Exceed Total Gallons by \"&(K33)&\" gallons - Must Fix to Print\",\"\")","v":""}]
[null,{"$f":"IF(F96<E96,\"Column D5 Taxable Miles less than D4 Total Miles: Please explain\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(F96<E96,\"___________________________________\",\"\")","v":""},{"$f":"IF(M94<L94,\"Column D5 Taxable Miles less than D4 Total Miles: Please explain\",\"\")","v":""},{"$f":"IF(N94<M94,\"Column D5 Taxable Miles less than D4 Total Miles: Please explain\",\"\")","v":""}]
[null,"Diesel Schedule"]
[null,"D3","D1",null,"D4","D5","D6","D7","D8","D9",null,null,"D10","D11"]
[null,"Tax",null,null,"Total","Taxable","Taxable","Tax Paid","Net Taxable","Net Tax ",null,null,"Interest","Total "]
[null,"Rate","Jurisdiction",null,"Miles","Miles","Gallons","Gallons","Gallons","Due",null,null,null,"Due"]
[null,0.28000000000000003,"Ohio","OH",0,{"$f":"IF(E32>0,SUM(E32:E32),0)","v":0},{"$f":"IF(E32>0,ROUND(F32/$H$23,0),0)","v":0},0,{"$f":"IF(E32>0,G32-H32,0)","v":0},{"$f":"IF(F32>0,ROUND(B32*I32,2),0)","v":0},{"$f":"+E96-K21","v":0},"miles error",{"$f":"IF(J32>0,ROUND(J32*0.00417*$M$24,2),0)","v":0},{"$f":"IF(J32+M32<>0,ROUND(J32+M32,2),0)","v":0}]
[null,0.16,"Indiana      ","IN",null,0,{"$f":"IF(E33>0,ROUND(F33/$H$23,0),0)","v":0},null,{"$f":"IF(E33>0,G33-H33,0)","v":0},{"$f":"IF(F33>0,ROUND(B33*I33,2),0)","v":0},{"$f":"IF(H96-K22>0,H96-K22,0)","v":0},"Gallons error",{"$f":"IF(J33+J34>0,ROUND((J33+J34)*0.00417*$M$24,2),0)","v":0},{"$f":"IF(J33+M33<>0,ROUND(J33+M33,2),0)","v":0}]
[null,0.11,null,"IN-s","Surcharge",null,null,null,{"$f":"IF(E33>0,G33,0)","v":0},{"$f":"IF(E33>0,ROUND(B34*I34,2),0)","v":0},null,null,null,{"$f":"IF(J34+M34<>0,ROUND(J34+M34,2),0)","v":0}]
[null,0.27500000000000002,"Kentucky   ","KY",null,{"$f":"IF(E35>0,SUM(E35:E35),0)","v":0},{"$f":"IF(E35>0,ROUND(F35/$H$23,0),0)","v":0},null,{"$f":"IF(E35>0,G35-H35,0)","v":0},{"$f":"IF(F35>0,ROUND(B35*I35,2),0)","v":0},null,null,{"$f":"IF(J35+J36>0,ROUND((J35+J36)*0.00417*$M$24,2),0)","v":0},{"$f":"IF(J35+M35<>0,ROUND(J35+M35,2),0)","v":0}]
[null,0.13300000000000001,null,"KY-s","Surcharge",null,null,null,{"$f":"IF(E35>0,G35,0)","v":0},{"$f":"IF(E35>0,ROUND(B36*I36,2),0)","v":0},null,null,null,{"$f":"IF(J36+M36<>0,ROUND(J36-M36,2),0)","v":0}]
[null,0.35,"Michigan","MI",null,{"$f":"IF(E37>0,SUM(E37:E37),0)","v":0},{"$f":"IF(E37>0,ROUND(F37/$H$23,0),0)","v":0},null,{"$f":"IF(E37>0,G37-H37,0)","v":0},{"$f":"IF(F37>0,ROUND(B37*I37,2),0)","v":0},null,null,{"$f":"IF(J37>0,ROUND(J37*0.00417*$M$24,2),0)","v":0},{"$f":"IF(J37+M37<>0,ROUND(J37+M37,2),0)","v":0}]
[null,0.51,"Pennsylvania","PA",null,{"$f":"IF(E38>0,SUM(E38:E38),0)","v":0},0,null,0,{"$f":"IF(F38>0,ROUND(B38*I38,2),0)","v":0},null,null,{"$f":"IF(J38>0,ROUND(J38*0.00417*$M$24,2),0)","v":0},{"$f":"IF(J38+M38<>0,ROUND(J38+M38,2),0)","v":0}]
[null,0.35699999999999998,"West Virginia","WV",null,0,0,null,0,{"$f":"IF(F39>0,ROUND(B39*I39,2),0)","v":0},null,null,0,{"$f":"IF(J39+M39<>0,ROUND(J39+M39,2),0)","v":0}]
[null,0.19,"Alabama","AL",null,0,0,null,0,{"$f":"IF(F40>0,ROUND(B40*I40,2),0)","v":0},null,null,0,{"$f":"IF(J40+M40<>0,ROUND(J40+M40,2),0)","v":0}]
[null,0.26,"Arizona","AZ",null,0,0,null,0,0,null,null,0,0]
[null,0.22500000000000001,"Arkansas","AR",null,0,0,null,0,0,null,null,0,0]
[null,0.44700000000000001,"California","CA",null,0,0,null,0,0,null,null,0,0]
[null,0.20499999999999999,"Colorado","CO",null,0,0,null,0,0,null,null,0,0]
[null,0.54500000000000004,"Connecticut","CT",null,0,0,null,0,0,null,null,0,0]
[null,0.22,"Delaware","DE",null,0,0,null,0,0,null,null,0,0]
[null,0.3337,"Florida","FL",null,0,0,null,0,0,null,null,0,0]
[null,0.17899999999999999,"Georgia   "," GA",null,0,0,null,0,0,null,null,0,0]
[null,0.25,"Idaho","ID",null,0,0,null,0,0,null,null,0,0]
[null,0.434,"Illinois","IL",null,0,0,null,0,0,null,null,0,0]
[null,0.22500000000000001,"Iowa","IA",null,0,0,null,0,0,null,null,0,0]
[null,0.26,"Kansas","KS",null,0,0,null,0,0,null,null,0,0]
[null,0.2,"Louisiana","LA",null,0,0,null,0,0,null,null,0,0]
[null,0.312,"Maine","ME",null,0,0,null,0,0,null,null,0,0]
[null,0.28149999999999997,"Maryland","MD",null,0,0,null,0,0,null,null,0,0]
[null,0.24,"Massachusetts","MA",null,0,0,null,0,0,null,null,0,0]
[null,0.28499999999999998,"Minnesota","MN",null,0,0,null,0,0,null,null,0,0]
[null,0.18,"Mississippi","MS",null,0,0,null,0,0,null,null,0,0]
[null,0.17,"Missouri","MO",null,0,0,null,0,0,null,null,0,0]
[null,0.27750000000000002,"Montana","MT",null,0,0,null,0,0,null,null,0,0]
[null,0.26400000000000001,"Nebraska","NE",null,0,0,null,0,0,null,null,0,0]
[null,0.27,"Nevada","NV",null,0,0,null,0,0,null,null,0,0]
[null,0.222,"New Hampshire","NH",null,0,0,null,0,0,null,null,0,0]
[null,0.17499999999999999,"New Jersey","NJ",null,0,0,null,0,0,null,null,0,0]
[null,0.21,"New Mexico","NM",null,0,0,null,0,0,null,null,0,0]
[null,0.40649999999999997,"New York","NY",null,0,0,null,0,0,null,null,0,0]
[null,0.36499999999999999,"North Carolina","NC",null,0,0,null,0,0,null,null,0,0]
[null,0.23,"North Dakota","ND",null,0,0,null,0,0,null,null,0,0]
[null,0.13,"Oklahoma","OK",null,0,0,null,0,0,null,null,0,0]
[null,0,"Oregon","OR",null,0,0,null,0,0,null,null,0,0]
[null,0.32,"Rhode Island","RI",null,0,0,null,0,0,null,null,0,0]
[null,0.16,"South Carolina","SC",null,0,0,null,0,0,null,null,0,0]
[null,0.22,"South Dakota","SD",null,0,0,null,0,0,null,null,0,0]
[null,0.17,"Tennessee","TN",null,0,0,null,0,0,null,null,0,0]
[null,0.2,"Texas","TX",null,0,0,null,0,0,null,null,0,0]
[null,0.245,"Utah","UT",null,0,0,null,0,0,null,null,0,0]
[null,0.31,"Vermont","VT",null,0,0,null,0,0,null,null,0,0]
[null,0.20200000000000001,"Virginia           ","VA",null,{"$f":"IF(E78>0,SUM(E78:E78),0)","v":0},0,null,0,0,null,null,{"$f":"IF(J78+J79>0,ROUND((J78+J79)*0.00417*$M$24,2),0)","v":0},0]
[null,3.5000000000000003E-2,null,"VA-s","Surcharge",null,null,null,{"$f":"IF(E78>0,G78,0)","v":0},{"$f":"IF(E78>0,ROUND(B79*I79,2),0)","v":0},null,null,null,0]
[null,0.375,"Washington   ","WA",null,{"$f":"IF(E80>0,SUM(E80:E80),0)","v":0},{"$f":"IF(E80>0,ROUND(F80/$H$23,0),0)","v":0},null,{"$f":"IF(E80>0,G80-H80,0)","v":0},{"$f":"IF(F80>0,ROUND(B80*I80,2),0)","v":0},null,null,0,0]
[null,0.32900000000000001,"Wisconsin        ","WI",null,{"$f":"IF(E81>0,SUM(E81:E81),0)","v":0},0,null,0,0,null,null,0,0]
[null,0.24,"Wyoming       ","WY",null,0,0,null,0,0,null,null,0,0]
[null,0.30830000000000002,"Alberta","AB",null,0,0,null,0,0,null,null,0,0]
[null,0.77659999999999996,"British Columbia","BC",null,0,0,null,0,0,null,null,0,0]
[null,0.47949999999999998,"Manitoba","MB",null,0,0,null,0,0,null,null,0,0]
[null,0.65759999999999996,"New Brunswick","NB",null,0,0,null,0,0,null,null,0,0]
[null,0.56520000000000004,"Newfoundland","NL",null,0,0,null,0,0,null,null,0,0]
[null,0.52749999999999997,"Nova Scotia","NS",null,0,0,null,0,0,null,null,0,0]
[null,0.4899,"Ontario","ON",null,0,0,null,0,0,null,null,0,0]
[null,0.69189999999999996,"Prince Edward Is","PE",null,0,0,null,0,0,null,null,0,0]
[null,0.69189999999999996,"Quebec","QC",null,0,0,null,0,0,null,null,0,0]
[null,0.51380000000000003,"Saskatchewan","SK",null,0,0,null,0,0,null,null,0,0]
[null,"Non-IFTA Miles",null,"OT",null,0,0,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J32:J93)","v":0},null,null,{"$f":"SUM(M32:M93)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,{"$f":"SUM(E80:E93)+SUM(E37:E78)+SUM(E35:E35)+SUM(E32:E33)","v":0},{"$f":"SUM(F80:F93)+SUM(F37:F78)+SUM(F35:F35)+SUM(F32:F33)","v":0},null,{"$f":"SUM(H80:H93)+SUM(H37:H78)+SUM(H35:H35)+SUM(H32:H33)","v":0},null,{"$f":"SUM(J32:J92)","v":0},null,null,{"$f":"SUM(M32:M92)","v":0},{"$f":"SUM(N32:N92)","v":0}]
[]
[]
[null,null,null,null,"Net Tax Due",null,null,null,null,{"$f":"N96","v":0}]
[]
[null,null,null," ","Late Fee",null,null,null,null,{"$f":"IF(M24>0,IF(J96>500,J96*0.1,50),\" \")","v":" "}]
[null,null,null,null,"(make check payable to Treasurer, State of Ohio and mail with return to:"]
[null,null,null,null,"Ohio Dept. of Taxation, IFTA, P.O. Box 1799, Columbus, OH  43216-1799)"]
[]
[null,null,null,null,"If tax due record on line G. If refund record on line H (Face of Return)",null,null,null,null,{"$f":"SUM(J99:J104)","v":0}]
[null," "," "]
[null,"4th quarter 2014"]