{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Identification","Registrations","Receipts","States","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Vehicle Registration Fees and Receipts "]
["Macros (automatic actions) must be enabled to use this form. To enable macros in Excel 2007 and later, select Options in the message bar that appears toward the top of the screen, then select \"Enable Content\"\n\n\nYou may also enable macros by selecting: File>Options>Trust Center>Trucst Center Settings>Macro Settings>Enable all macros."]
["Enter data requested in yellow highlighted cells. Note that some cells calculate values automatically from other cells and may not be changed. Do not attempt to change any calculations or locked cells."]
["Paperwork Reduction Burden Statement\n\nThis collection of information is mandatory (23 CFR 420.105) and will be used to \"provide data that support the FHWA's responsibilities to the Congress and to the public.\" Public reporting burden is estimated to average 14 hours per response, including the time for reviewing instructions searching existing data sources, gathering and maintaining the data needed, and completeing and reviewing the collection of information.  No confidentiality is necessary. Please note that an agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB contron number. The OMB control number for this collection is 2125-0032. Send comments regarding this burden estimate, or any other aspect of this collection of information, including suggestions for reducing this burden to: Information Collection Clearance Officer, Federal Highway Administration, 1200 New Jersey Ave, SE, Washington, DC 20590.\n"]
[]
["Press \"Ctrl-k\" to check the document for missing data.\nPress \"Ctrl-r\" to clear all data from the document."]

{"sheet":"Identification","index":1,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Identification Information"]
["Information Item","Response"]
["State"]
["Reporting Date"]
["Notes and Comments"]
["Collecting Agency"]
["Information from the records of:"]
["Compiled under the direction of:"]

{"sheet":"Registrations","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Vehicle Registrations"]
["Vehicle Type","Gov't vehicle registrations snapshot on reporting date","Private vehicle registration snapshot on reporting date"]
["Automobiles"]
["Motorcycles"]
["Motor Bicycles and Mopeds"]
["Passenger Vehicles Sub-Total  ",{"$f":"SUM(B3:B5)","v":0},{"$f":"SUM(C3:C5)","v":0}]
["School Buses"]
["Non-School Buses"]
["Bus Sub-Total  ",{"$f":"SUM(B7:B8)","v":0},{"$f":"SUM(C7:C8)","v":0}]
["Single-Unit Trucks (over 10,000 lbs max GVW)"]
["Truck Tractors"]
["Truck Sub-Total  ",{"$f":"SUM(B10:B11)","v":0},{"$f":"SUM(C10:C11)","v":0}]
["Trailers"]

{"sheet":"Receipts","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Vehicle Registration Fees and Receipts"]
["Types of Fees and Receipts","Fees collected in previous 12 months ending on reporting date"]
["All Vehicle Registration Fees"]
["Dealers' license or permit receipts"]
["Certificates of title receipts (new and transfer)"]
["Fines and penalties receipts"]
["Oversise and/or overweight permit receipts"]
["Other receipts"]
["Total, Receipts and Fees",{"$f":"SUM(B3:B8)","v":0}]

{"sheet":"States","index":4,"n_rows":52,"n_cols":1,"rows_kept":52,"cut":false,"hidden":true,"merged":[]}
[]
["Alabama"]
["Alaska"]
["Arizona"]
["Arkansas"]
["California"]
["Colorado"]
["Connecticut"]
["Delaware"]
["District of Columbia"]
["Florida"]
["Georgia"]
["Hawaii"]
["Idaho"]
["Illinois"]
["Indiana"]
["Iowa"]
["Kansas"]
["Kentucky"]
["Louisiana"]
["Maine"]
["Maryland"]
["Massachusetts"]
["Michigan"]
["Minnesota"]
["Mississippi"]
["Missouri"]
["Montana"]
["Nebraska"]
["Nevada"]
["New Hampshire"]
["New Jersey"]
["New Mexico"]
["New York"]
["North Carolina"]
["North Dakota"]
["Ohio"]
["Oklahoma"]
["Oregon"]
["Pennsylvania"]
["Rhode Island"]
["South Carolina"]
["South Dakota"]
["Tennessee"]
["Texas"]
["Utah"]
["Vermont"]
["Virginia"]
["Washington"]
["West Virginia"]
["Wisconsin"]
["Wyoming"]

{"sheet":"Data","index":5,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["State","Date","Sheet","Col","Row","Cell","Value"]
[0,"00:00:00","Identification","B",5,{"$f":"CONCATENATE(D2,E2)","v":"B5"},{"$f":"INDIRECT(\"'\"&C2&\"'!\"&F2)","v":0}]
[0,"00:00:00","Identification","B",6,{"$f":"CONCATENATE(D3,E3)","v":"B6"},{"$f":"INDIRECT(\"'\"&C3&\"'!\"&F3)","v":0}]
[0,"00:00:00","Identification","B",7,"B7",0]
[0,"00:00:00","Identification","B",8,"B8",0]
[0,"00:00:00","Registrations","B",3,"B3",0]
[0,"00:00:00","Registrations","B",4,"B4",0]
[0,"00:00:00","Registrations","B",5,"B5",0]
[0,"00:00:00","Registrations","B",6,"B6",0]
[0,"00:00:00","Registrations","B",7,"B7",0]
[0,"00:00:00","Registrations","B",8,"B8",0]
[0,"00:00:00","Registrations","B",9,"B9",0]
[0,"00:00:00","Registrations","B",10,"B10",0]
[0,"00:00:00","Registrations","B",11,"B11",0]
[0,"00:00:00","Registrations","B",12,"B12",0]
[0,"00:00:00","Registrations","B",13,"B13",0]
[0,"00:00:00","Registrations","C",3,"C3",0]
[0,"00:00:00","Registrations","C",4,"C4",0]
[0,"00:00:00","Registrations","C",5,"C5",0]
[0,"00:00:00","Registrations","C",6,"C6",0]
[0,"00:00:00","Registrations","C",7,"C7",0]
[0,"00:00:00","Registrations","C",8,"C8",0]
[0,"00:00:00","Registrations","C",9,"C9",0]
[0,"00:00:00","Registrations","C",10,"C10",0]
[0,"00:00:00","Registrations","C",11,"C11",0]
[0,"00:00:00","Registrations","C",12,"C12",0]
[0,"00:00:00","Registrations","C",13,"C13",0]
[0,"00:00:00","Receipts","B",3,"B3",0]
[0,"00:00:00","Receipts","B",4,"B4",0]
[0,"00:00:00","Receipts","B",5,"B5",0]
[0,"00:00:00","Receipts","B",6,"B6",0]
[0,"00:00:00","Receipts","B",7,"B7",0]
[0,"00:00:00","Receipts","B",8,"B8",0]