Transcription
Overview of E-Ticketing TechnologyRebecca Embacher Advanced Materials and Technology EngineerDecember 2, 2020 2020 MAAPT Virtual ConferenceAMT Website l
DescriptionThis work shall consist of capturingsource, fleet, agency and Contractor dataand compiling this digitalized data (ETicket) into a database for asphalt pavingapplications.Future: other material types will be addedsuch as ready mix concrete, rDataFleet Data
Estimated Number of Asphalt Computer Generated Paper Tickets3 Million Tons / Year15 Tons / Ticket200,000 Tickets / Year170 working days / year1,176 Tickets / working dayConcept for slide from Florida DOT
Paying Inspector Collect and file tickets Review / audit tickets Manually enter ticket quantities into spreadsheets Search for missing tickets Reconcile quantities Report quantities for pay estimateE-Ticketing technology is nowavailable to simplify andautomate some of these tasks!Slide Courtesy of Florida DOT
Expected Benefits
Increased SafetyPaper Ticket Collections: Live Traffic Construction EquipmentInspector no longerstanding on truck haulroads to collect papertickets!Source: IDOT
Increased Accuracy of Tabulations No more lost or damaged paper tickets Increased accuracy in tabulation of quantities (now a database) Ease in developing summary reports Daily, Monthly, Contract Contract, Material Code, etc. Digital Data to Archive for Audits Often unable to copy printed paper tickets (thermal paper, damaged, etc.)
Fleet Data Real-time truck locations and transit routes Better flow rates / identification of in-efficiencies Who’s taking too long? Who’s not using designated haul routes? Why is truck parked? Labor Compliance Documentation and Trucking Payroll
Fleet Data (cont.) Thermal Uniformity Long-Term Pavement Performance(compaction, density, ride, permeability, etc.)Better fleet managementEstimated time of load arrivalMatch Paver Speed to Delivery of MatlBetter coordination of inspection activitiesTrack Mix Design Changes on roadway
Paver Stop Recorded by PMTP Method11:56:4112:05:374 trucks waiting by paver:26dm27dm4w30
2018-2019 Pilot Projects 2018 SP3804-60 TH13 (Ulland Brothers) SP4710-27 TH22 & 55 (Knife River Central) 2019 D1 SP6917-143 TH53 (KGM Contractors, Inc.) D1 SP6920-53 TH53 (KGM Contractors, Inc.) M SP1985-148 TH494 (Minnesota Paving & Materials) D6 SAP085-609-019 CSAH 9, 12, 15, 17 (Rochester Sand & Gravel) 2020 30 Plus Project
Vendors that have Contacted MnDOTMay or May Not Meet Current Requirements1. AlegnaTrax9. RuckIt2. Caterpillar (eRoutes)10. Simple Cloud Solutions3. CemenTech (Concrete only)11. SOP Paving (Spot-On)4. Command Alkon (TrackIt –MOBILEticket)12. Sysdyne – iStrada (Concrete only)5. Earthwave (FleetWatcher)6. Haulhub7. HCSS8. Libra Sentinel13. Topcon14. Transflo15. Tread16. Voegle / Wirtgen Group
Start of Pre-ConstructionProcessE-Ticketing System SetupSetup AppropriateComponentsEnter SourceIdentification Data(Table 7, Section 6.2)into E-TicketingSystem & otherNeeded Fleet DataProvide Training to Engineer(Section 6.6)Source GeofenceSetup Geofences(Section 6.3)End of Pre-ConstructionProcessA1Contract GeofenceProject GeofenceCategory GeofenceMobile Dump GeofenceE-Ticketing Workflow
Pre-ConstructionSourceSource toContractTimeContract toSource TimeEnter Contract LimitsExit Contract LimitsDumpTime atContract
Pre-Construction ActivitiesE-Ticketing System Setup Loadout Software DOS based systems – update to new GEN OS Internet Connectivity Permanent / Portable Plants Truck Information Use same Truck ID at ALL plants and in ETicketing System (16TR 16tr) Maximum Gross Weight Overweight Permit Number Assign Truck ID’s to tracking system Truck Hauler Information Driver Name Hauler Company Name DOT Number Truck Driver Classification
Pre-Construction Activities(When Feature Available) Enter Source Identification Data into ETicketing System Source Identification (AASHTOWare Plant ID) Source Name (John Joe Asphalt Plant 7) Portable Plant (Yes/No) Source Address Source Phone NumberRedundantInformationto Push inSource Data
Setup Pushing Source Data to E-Ticketing SystemCentralized Suppliers (Feature not Currently Available by all Vendors) Data Transmittal Rest APIs Exposed by E-Ticketing Vendors Request Body Format JSON Source Data Availability in E-Ticketing User Interface 2 Minutes Point of Sale to E-Ticketing System 1 Minute E-Ticketing System to User InterfacePhoto Courtesy of Tiller Corporation
Setup Pushing Source Data to E-Ticketing SystemContractor Owned Permanent and Portable Plants E-Ticketing System Solution or Rest API’s / JSON Mitigate issues with possible softwareupdates
Setup GeofencesStatic Geofences: Source, Contract, Project, CategoryMobile Geofence: Dump
Geofence Availability Currently Available Source Contract Mobile Dump Geofences Not Currently Available by all vendors Project Contract
TrainingProvide training to Engineer nolater than 7 calendar days prior tostart of work requiring E-Ticketing
Web and/or application Based PlatformUser Interface
Playback of Breadcrumb Trails
Agency Data EntryUser Interface
Export of E-TicketsCapture D Gross Wei Gross Wei Gross Wei Gross Wei Internal P Job IDJul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 36290.0 80000.0 36.2940.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Jul 18, 201 39920.0 88000.0 39.9244.070119710Jul 18, 201 36290.0 80000.0 36.2940.070119710Jul 18, 201 38100.0 84000.0 38.142.070119710Material 0BSPWEA440BNet WeighNet WeighNet WeighNet WeighTare Weig Tare Weig Tare Weig Tare Weig Ticket NumTruck ID24420.0 53840.0 24.4226.9215420.0 34000.0 15.4217.0893727d24540.0 54100.0 24.5427.0514970.0 33000.0 14.9716.5893818tw24580.0 54200.0 24.5827.114510.0 32000.0 14.5116.0893924d23560.0 51940.0 23.5625.9715100.0 33300.0 15.116.6589402923630.0 52100.0 23.6326.0514060.0 31000.0 14.0615.589411723960.0 52820.0 23.9626.4114830.0 32700.0 14.8316.3589421824640.0 54320.0 24.6427.1615420.0 34000.0 15.4217.0894323d22000.0 48500.0 22.024.2515650.0 34500.0 15.6517.258944N3124560.0 54140.0 24.5627.0715420.0 34000.0 15.4217.0894527d24580.0 54200.0 24.5827.114510.0 32000.0 14.5116.0894724d22200.0 48940.0 22.224.4713610.0 30000.0 13.6115.089485524190.0 53340.0 24.1926.6715100.0 33300.0 15.116.6589492924410.0 53820.0 24.4126.9114060.0 31000.0 14.0615.589511723650.0 52140.0 23.6526.0714830.0 32700.0 14.8316.3589521824310.0 53600.0 24.3126.815420.0 34000.0 15.4217.0895323d24270.0 53500.0 24.2726.7514970.0 33000.0 14.9716.5895418tw22110.0 48740.0 22.1124.3715650.0 34500.0 15.6517.258955N3124360.0 53700.0 24.3626.8514510.0 32000.0 14.5116.0895624d22910.0 50500.0 22.9125.2515880.0 35000.0 15.8817.589573023210.0 51180.0 23.2125.5915100.0 33300.0 15.116.6589582924180.0 53300.0 24.1826.6515420.0 34000.0 15.4217.0895927d21530.0 47460.0 21.5323.7313610.0 30000.0 13.6115.089605521680.0 47800.0 21.6823.914060.0 31000.0 14.0615.5896117
Pre-ConstructionConstructionSourceSource toContractTimeContract toSource TimeEnter Contract LimitsExit Contract LimitsDumpTime atContract
Source DataDigitalized Source Data Imported into E-Ticketing System Agency Project Number Ticket Number Contract Identification Truck ID Source Identification (BP0001) Voided Ticket (Voided, Valid, Orphan) Scale ID Loading Date / Time Silo ID Gross Weight Source Notes Net Weight Mix Design ID Tare Weight Material Code
Generated by Loadout Software or E-Ticketing System Daily Running Total by Mix Designation Weight Contract Total by Mix Designation Weight
Agency/Contractor Data at Source Agency Sample Identification Material Temperature at Source
Fleet DataAt Source Source Geofence NameField Not Currently Available Truck Enters Source Geofence Date / Time Truck Exits Source Geofence Date / Time Time at Source
Pre-ConstructionConstructionSourceSource toContractTimeContract toSource TimeEnter Contract LimitsExit Contract LimitsDumpTime atContract
Enters Contract Limits Contract Geofence NameField Not Currently Available Truck Enters Contract Geofence Date and Time
Pre-ConstructionConstructionSourceSource toContractTimeContract toSource TimeEnter Contract LimitsExit Contract LimitsDumpTime atContract
Dump (Truck Exchange) Paver IDField Not Currently Available by all Vendors Dump Geofence Name Dump Date and Time Dump Lat / LongField Not Currently Available
Dump Agency / Contractor Data(When Fields Available) Sample ID Dump Station Number Material Temp at Field Field Notes Air Temp. Inspector / Contractor Staff ID Split Loads Weight, Pay Items,Location Notes Date and Time Stamp Wasted Material Weight Load Acceptance and Rejection Partial Rejected Load Weight
Dump Agency Data – Independent Verification(Fields Not Currently Available) Date and Time Stamp Lat / Long Station Estimated Net Weight Net Weight on E-Ticket Driver Name Hauler Company Name Approval Inspector ID Notes Randomly within First 10 loads Randomly within next 1,000-ton lotsthereafterInvalid E-Ticket? Randomly within next 500 ton lot Continue until valid for 2 consecutive lots Verify every 1,000 ton lots thereafter
E-Ticketing Data Export Agency Data ExportFeature Not Currently Available Within 1 minute after finalizing data entry Phase I: ASCII, CSV, XLSX or text format Phase II: Import into AASHTOWare Project E-Ticketing Data Export Within 15 minute intervals Phase I: ASCII, CSV, XLSX or text format Phase II: Direct import into AASHTOWare Project Construction and Materials Module Estimating Civil Rights and LaborFeature Not Currently Available
Pre-ConstructionConstructionSourceSource toContractTimeContract toSource TimeEnter Contract LimitsExit Contract LimitsDumpTime atContract
Exits Contract Limits Truck Exits Contract Geofence Date and Time Time at Contract Contract to Source Transit Time
Pre-ConstructionConstructionSourceSource toContractTimeContract toSource TimeEnter Contract LimitsExit Contract LimitsDumpTime atContract
System Failure E-Ticketing system does not collect and/or store data per requirements orwhen data cellular coverage is limited Notify Engineer Source will revert to computer generated weight tickets (or other means asapproved by Engineer)During pilot stages stillusing computer generatedtickets to reconcilequantities
Pay Item2016.609 Quality Management – E-Ticketing TonIncludes:Setup of appropriate E-Ticketing system componentsEntry of trucking, truck hauler, asset tracker and source identification dataSetup of static and mobile geofencesInternet connectivityAssigning / distribution of truck asset trackersSystem monitoringRemote server storageCloud-based software accessibility and data package plans
Rebecca.Embacher@state.mn.us(m) 651-373-5222Thank you again!AMT Website l
E-Ticketing Workflow. Start of Pre -Construction Process Enter Source Identification Data (Table 7, Section 6.2) into E -Ticketing System & other Needed Fleet Data Provide Training to Engineer (Section 6.6) E-Ticketing System Setup Source Geofence Contract Geofence Setup Geofences (Secti