2d:null 2e:["$","title",null,{"children":"Use Case: Optimizing Route Planning for a Trucking Logistics Company Using Hours of Service (HOS) Reports | NB.AI Solutions Team | Observable"}] 33:T11b8,md`

Overview:

A trucking logistics company is responsible for ensuring that drivers complete pickups and deliveries efficiently while adhering to legal Hours of Service (HOS) regulations. These regulations mandate break times, daily driving limits, and rest periods, which impact the estimated time of arrival (ETA) for each delivery. The company uses a route planning service that integrates HOS compliance to provide more accurate ETAs based on driver schedules.

Problem:

The company's current system does not account for HOS restrictions when calculating delivery times, leading to frequent delays, inaccurate ETAs, and potential regulatory violations. As a result, the company needs a solution that incorporates HOS regulations into route planning to optimize deliveries and comply with legal requirements.

Solution:

The logistics company implements a route planning service that uses real-time data from an Hours of Service Report to dynamically update ETAs for all deliveries in the manifest. This service takes into account the following inputs:

Driver's Current HOS Status: The report provides data on how many hours the driver has already driven, when breaks or rest periods are due, and how much drive time remains for the day.

Planned Pickup and Delivery Schedule: The manifest includes the scheduled pickup and delivery locations, times, and priority levels.

Regulatory Compliance: The system checks the HOS compliance rules, such as a mandatory 30-minute break after 7 hours of driving, an 11-hour daily driving limit, and a 10-hour rest break after the driving limit is reached.

How It Works:

Step 1: Input HOS Data: The driver’s HOS report is fed into the system in real-time, which tracks remaining driving hours and upcoming break times.

Step 2: Manifest Updates: The system cross-references the delivery schedule in the manifest with the driver’s available hours. If the driver is due for a break or rest period, the service updates the delivery ETAs accordingly.

Step 3: Optimize Route: Based on the HOS data and the updated ETAs, the system re-optimizes the delivery sequence, suggesting alternative routes or adjusting the priority of deliveries to minimize delays.

Step 4: Provide Real-Time Feedback: The system sends updated ETAs to customers, dispatchers, and drivers, ensuring transparency and reducing the risk of late deliveries.

Benefits:

Accurate ETA Calculations: By factoring in HOS regulations, the service provides realistic ETAs that prevent missed delivery windows.

Improved Compliance**: Drivers adhere to HOS rules without risking fines or penalties, reducing legal liabilities for the company.

Operational Efficiency: With real-time updates and optimized routes, the company minimizes idle time and maximizes productivity, reducing fuel costs and improving customer satisfaction.

This solution ensures that the logistics company can deliver goods on time while staying compliant with regulatory driving hours, thereby optimizing fleet operations and enhancing customer service.

`34:T51f,viewof panel = Inputs.form(inputs, { template: (v) => htl.html`

${v.departureTime}

${v.currentLocation}

${v.avoids}

${v.truckHeight}

${v.truckWidth}

${v.truckLength}

${v.hazmat}

${v.remainingDriveTimeUntilBreak}

${v.remainingDriveTime}

${v.maxDriveTimeBeforeBreak}

${v.maxDriveTimeBeforeLongBreak}

${v.shortBreakDuration}

${v.endOfDutyBreakDuration}

` })35:T458,viewof selectedStops = { // Function to style each row, with alternating background colors const applyRowStyle = (row, column) => { const isOddRow = row % 2; // Determine if row is odd or even const baseStyle = ` font-family: 'Montserrat', sans-serif; font-size: 12pt; padding: 5px; `; const backgroundColor = isOddRow ? "#f9f4f4" : "#d3cbcb"; // Alternate background color return html`

${column}

`; }; // Use Inputs.table to display the table with the applied styles return Inputs.table(stopData, { columns: ["id", "description", "address"], header: { id: "Nbr", description: "Description", address: "Address" }, format: { id: (value, row) => applyRowStyle(row, value), description: (value, row) => applyRowStyle(row, value), address: (value, row) => applyRowStyle(row, value) }, value: stopData.slice(0, 8), // Limit to the first 7 rows width: { id: 50, description: 200, address: 300 }, required: false, rows: 20 }); }36:Te4c,viewof results = { if (inputData_a) { // Sort selected stops by the sequence number let baseTime = Date.parse(inputs.departureTime.value) / 1000; const stops = selectedStops.sort((a, b) => a.id - b.id); let theLegs = structuredClone(routeMe.routes[0].legs).filter( (obj) => obj.description !== "Summary" ); let stopIdx = 0; theLegs.forEach((l) => { if (l.post_actions == null && l.description != "Summary") { const addressTokens = stops[stopIdx].address.split(","); l.description = `${stops[stopIdx++].description} ${addressTokens[1]},${ addressTokens[2] }`; l.startTime = baseTime; l.endTime = baseTime + l.duration.value; baseTime += l.duration.value; } else if (l.post_actions) { l.description = "Drive to REST STOP"; l.startTime = baseTime; l.endTime = baseTime + l.post_actions[0].duration + l.duration.value; baseTime += l.post_actions[0].duration; baseTime += l.duration.value; } // Add derived sumColumn (sum of distance and duration) l.sumColumn = (l.distance?.value || 0) * 0.0006213712 + (l.duration?.value || 0) / 3600; }); theLegs.push({ description: "Summary", address: "", distance: { value: routeMe.routes[0].distance }, duration: { value: routeMe.routes[0].duration } }); // Add CSS for green highlighting if description includes 'Summary' const applyRowStyle = (row, column) => { const isSummary = theLegs[row].description === "Summary"; const isOdd = row % 2; console.log(isOdd); const style = `font-family: 'Montserrat',sans-serif;font-size: ${ isSummary ? "12pt;" : "10pt;" }${ isSummary ? "background-color: lightgreen;" : isOdd ? "background-color: #f9f4f4;" : "background-color: #d3cbcb;" }`; return html`

${column}

`; }; return Inputs.table(theLegs, { columns: [ "startTime", "endTime", "description", "distance", "duration", "post_actions" ], width: { startTime: 120, endTime: 120, description: 300, distance: 120, duration: 100 }, rows: 18, multiple: false, header: { startTime: "Leg Start Time", endTime: "Leg End Time", description: "Description", distance: "Distance (miles)", duration: "Duration (hrs)", post_actions: "HOS Actions" }, format: { description: (x, row) => applyRowStyle(row, x), startTime: (x, row) => applyRowStyle( row, new Date(x * 1000).toLocaleString([], { hour: "2-digit", minute: "2-digit", hour12: false, month: "2-digit", day: "2-digit" }) ), endTime: (x, row) => applyRowStyle( row, new Date(x * 1000).toLocaleString([], { hour: "2-digit", minute: "2-digit", hour12: false, month: "2-digit", day: "2-digit" }) ), distance: (x, row) => applyRowStyle(row, (x.value * 0.0006213712).toFixed(0)), duration: (x, row) => applyRowStyle(row, (x.value / 3600).toFixed(2)), post_actions: (x, row) => applyRowStyle( row, x ? `${x[0].action.toUpperCase()} ${x[0].duration / 3600}hrs` : "" ) } }); } }37:T1f0f,viewof roMap = { if (!inputData_a) { return; } function createPopupContent(step) { return `

${new Date(step.endTime * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })} ${step.description}

`; } apiKey; const stops = selectedStops.sort((a, b) => a.id - b.id); let theLegs = structuredClone(routeMe.routes[0].legs).filter( (obj) => obj.description !== "Summary" ); let baseTime = Date.parse(inputs.departureTime.value) / 1000; let stopIdx = 0; theLegs.forEach((l) => { if (l.post_actions == null && l.description != "Summary") { const addressTokens = stops[stopIdx].address.split(","); l.description = `${stops[stopIdx++].description} ${addressTokens[1]},${ addressTokens[2] }`; l.startTime = baseTime; l.endTime = baseTime + l.duration.value; baseTime += l.duration.value; } else if (l.post_actions) { l.description = "REST STOP"; l.startTime = baseTime; l.endTime = baseTime + l.post_actions[0].duration + l.duration.value; baseTime += l.post_actions[0].duration; baseTime += l.duration.value; } }); const container = html`

`; yield container; let routePolyline = null; let originMarker = null; let destinationMarker = null; let waypoints = []; let pos = { lat: 40.1177, lng: -83.1265 }; const mapRo = (container.value = new nextbillion.maps.Map({ container: document.getElementById("mapRo"), center: pos, zoom: 8, maxZoom: 18, minZoom: 3, style: "https://api.nextbillion.io/tt/style/1/style/22.2.1-9?map=2/basic_street-dark&traffic_incidents=2/incidents_dark&traffic_flow=2/flow_relative-dark", scrollZoom: true })); const cont = mapRo.map?.getContainer(); if (!cont) return; const attributionElements = cont.querySelectorAll(".maplibregl-ctrl-attrib"); attributionElements.forEach((element) => { if (element && element.parentNode) { element.parentNode.removeChild(element); } }); mapRo.map.on("load", function () { mapRo.map.loadImage( "https://d12qcqjlhp2ahm.cloudfront.net/arrow.png", function (error, image) { if (error) throw error; mapRo.map.addImage("arrow-icon", image); } ); const unescapedPoly = routeMe.routes[0].geometry; let decodedPoly = { type: "FeatureCollection", features: [ { type: "Feature", properties: {}, geometry: { coordinates: nextbillion.utils.polyline .decode(unescapedPoly, 5) .map((c) => c.reverse()), type: "LineString" } } ] }; const firstLabelLayerId = mapRo.map .getStyle() .layers.find((layer) => layer.type === "symbol").id; if (!mapRo.map.getSource("route")) { mapRo.map.addSource("route", { type: "geojson", data: null }); } mapRo.map.getSource("route").setData(decodedPoly); // Remove the route layers if they already exist if (mapRo.map.getLayer("route-casing")) { mapRo.map.removeLayer("route-casing"); } if (mapRo.map.getLayer("route-inner")) { mapRo.map.removeLayer("route-inner"); } // Add outer route line (casing) mapRo.map.addLayer( { id: "route-casing", type: "line", source: "route", layout: { "line-join": "round", "line-cap": "round" }, paint: { "line-color": "#cf9ae2", // Outer color (casing) "line-width": 10 // Outer line thickness } }, firstLabelLayerId ); // Add inner route line (on top of casing) mapRo.map.addLayer( { id: "route-inner", type: "line", source: "route", layout: { "line-join": "round", "line-cap": "round" }, paint: { "line-color": "#ffffff", // Inner color (white) "line-width": 6 // Inner line thickness } }, firstLabelLayerId ); // Add directional arrows along the route mapRo.map.addLayer({ id: "route-arrows", type: "symbol", source: "route", layout: { "symbol-placement": "line", // Place arrows along the line "symbol-spacing": 250, // Adjust the spacing between arrows "icon-image": "arrow-icon", // Use a custom arrow icon "icon-size": 0.35, // Adjust the size of the arrows "icon-allow-overlap": true, // Allow the arrows to overlap with other features "icon-rotation-alignment": "map", // Align arrows to follow the route direction "icon-rotate": 0 // Use the route's bearing to rotate arrows } }); // Animation variables let progress = 0; const arrowSpeed = 0.05; // Control arrow movement speed function animateArrows() { progress += arrowSpeed; // Update the symbol-spacing to create an animation effect mapRo.map.setLayoutProperty( "route-arrows", "symbol-spacing", 50 + (progress % 10) ); // Request the next frame for smooth animation requestAnimationFrame(animateArrows); } // Start the animation animateArrows(); // Group the steps by location //const groupedSteps = groupStepsByLocation(routeMe.routes[0].legs.steps); let stopIdx = 0; theLegs.forEach((l, idx) => { const markerElementStart = document.createElement("div"); markerElementStart.className = "step-marker"; markerElementStart.style.backgroundColor = l.post_actions == null ? "lightgreen" : l.post_actions[0].duration === parseInt(inputData_a.shortBreakDuration) * 3600 ? "lightblue" : "#ef8d8d"; markerElementStart.style.color = "black"; markerElementStart.style.fontFamily = "Montserrat"; markerElementStart.style.fontWeight = "bold"; markerElementStart.style.borderRadius = "50%"; markerElementStart.style.padding = "10px"; markerElementStart.style.width = "5px"; markerElementStart.style.height = "5px"; markerElementStart.style.display = "flex"; markerElementStart.style.alignItems = "center"; markerElementStart.style.justifyContent = "center"; markerElementStart.textContent = idx + 1; const markerStart = new nextbillion.maps.Marker({ element: markerElementStart }) .setLngLat({ lng: l.end_location.longitude, lat: l.end_location.latitude }) .addTo(mapRo.map); // Create a popup with a summary of the steps at this location const popup = new nextbillion.maps.Popup({ closeButton: false, closeOnClick: false }).setHTML(createPopupContent(l)); // Show the popup on mouseenter and hide it on mouseleave markerStart.getElement().addEventListener("mouseenter", () => { popup.setLngLat(markerStart.getLngLat()).addTo(mapRo.map); }); markerStart.getElement().addEventListener("mouseleave", () => { popup.remove(); }); let bounds = decodedPoly.features[0].geometry.coordinates.reduce( function (bounds, coord) { return bounds.extend(coord); }, new nextbillion.maps.LngLatBounds( decodedPoly.features[0].geometry.coordinates[0], decodedPoly.features[0].geometry.coordinates[0] ) ); mapRo.map.fitBounds(bounds, { padding: 20 }); }); }); return mapRo; }38:T7fe,routeMe = { if (!inputData_a) { return; } // Helper function to build the waypoints string const buildWaypoints = (stops) => { return stops .slice(0, -1) // Exclude the last stop as it's the destination .map((stop) => stop.location) .join("|"); // Join locations with '|' as separator }; // Sort the selected stops const stops = selectedStops.sort((a, b) => a.id - b.id); const origin = inputs.currentLocation.value; const destination = stops[stops.length - 1].location; const wayPts = buildWaypoints(stops); // Initialize progress bar update const updateProgress = (interval, maxProgress) => { let progressValue = 0; return setInterval(() => { if (progressValue < maxProgress) { progress.value = progressValue; // Update progress bar progressValue += 1; // Increment progress value } }, interval); }; // Start progress bar updates const progressInterval = updateProgress(100, 150); // 100ms interval, max 150 // Fetch directions API and update progress bar const fetchDirections = async () => { try { const hazmat = inputs.hazmat.value.value === "none" ? "" : `&hazmat=true&hazmat_type=${inputs.hazmat.value.value}`; const response = await fetch( `https://api.nextbillion.io/directions/json?key=${apiKey}&mode=truck&origin=${origin}&destination=${destination}&steps=true&waypoints=${wayPts}&drive_time_limits=${ driveAndRestTimes.driveTimes }&departure_time=1563255734&avoid=${avoidInput}&rest_times=${ driveAndRestTimes.restTimes }${hazmat}&truck_size=0,${( parseFloat(inputs.truckHeight.value) * 30.48 ).toFixed(0)},0&option=flexible` ); const data = await response.json(); return data; } finally { // Ensure progress bar is completed and interval cleared clearInterval(progressInterval); progress.value = 150; } }; // Return the fetched directions data return fetchDirections(); }39:T7c5,driveAndRestTimes = { if (inputData_a) { // Calculate next break and end of day drive times in seconds const nextDriveBreak = calculateNextDriveBreak( inputData_a.remainingDriveTimeUntilBreak * 3600 ); const endOfDayDrive = calculateEndOfDayDrive( inputData_a.remainingDriveTime * 3600 ); // Calculate the time remaining to the long break let timeRemainingToLongBreak = endOfDayDrive - nextDriveBreak; // Determine the initial rest time based on whether the long break is due let restTime = timeRemainingToLongBreak > 0 ? inputData_a.shortBreakDuration * 3600 : inputData_a.endOfDutyBreakDuration * 3600; // If more driving remains before the long break, build the rest time string if (timeRemainingToLongBreak > 0) { restTime = [ restTime, inputData_a.endOfDutyBreakDuration * 3600, inputData_a.shortBreakDuration * 3600 ] .concat( Array(8) .fill([ inputData_a.endOfDutyBreakDuration * 3600, inputData_a.shortBreakDuration * 3600 ]) .flat() ) .join(","); } // Initialize the drive time with the next break, followed by a comma let driveTime = `${nextDriveBreak}`; // If more driving remains before the long break, build the drive time string if (timeRemainingToLongBreak > 0) { const maxDrive = inputData_a.maxDriveTimeBeforeBreak * 3600; const maxLongBreakDrive = inputData_a.maxDriveTimeBeforeLongBreak * 3600; const driveCycle = maxLongBreakDrive - maxDrive; // Add the rest of the drive times, starting with a comma after the first value driveTime += `,${[timeRemainingToLongBreak, maxDrive, driveCycle] .concat(Array(4).fill([maxDrive, driveCycle]).flat()) .join(",")}`; } // Return the drive and rest times return { driveTimes: driveTime, restTimes: restTime }; } }3a:Ta7d,stopData = [ { id: 1, location: "39.8264,-89.6495", address: "1740 Wabash Ave, Springfield, IL 62704", description: "1740 Wabash Ave, Springfield, IL 62704", corrected_coordinates: { lat: 39.8264, lng: -89.6495 }, original_location: "39.826414189,-82.934917607" }, { id: 2, location: "39.6953,-89.6495", address: "2935 E Clear Lake Ave, Springfield, IL 62702", description: "2935 E Clear Lake Ave, Springfield, IL 62702", corrected_coordinates: { lat: 39.6953, lng: -89.6495 }, original_location: "39.695258479, -86.282288892" }, { id: 3, location: "39.5495,-89.2945", address: "1187 E 1500 North Road, Taylorville, IL 62568", description: "1187 E 1500 North Road, Taylorville, IL 62568", corrected_coordinates: { lat: 39.5495, lng: -89.2945 }, original_location: "38.764523163, -90.385572435" }, { id: 4, location: "39.7992,-88.2831", address: "1000 E Southline Rd, Tuscola, IL 61953", description: "1000 E Southline Rd, Tuscola, IL 61953", corrected_coordinates: { lat: 39.7992, lng: -88.2831 }, original_location: "35.3821955330,-97.580015608" }, { id: 5, location: "40.1536,-88.9645", address: "614 W. Van Buren, Clinton, IL", description: "A614 W. Van Buren, Clinton, IL", corrected_coordinates: { lat: 40.1536, lng: -88.9645 }, original_location: "35.0804480850, -106.803704914" }, { id: 6, location: "40.4842,-88.9937", address: "1508 N Main St, Bloomington, IL 61701", description: "1508 N Main St, Bloomington, IL 61701", corrected_coordinates: { lat: 40.4842, lng: -88.9937 }, original_location: "33.388373448,-112.562820269" }, { id: 7, location: "40.6428,-89.5912", address: "420 S Main St, Creve Coeur, IL 61610", description: "420 S Main St, Creve Coeur, IL 61610", corrected_coordinates: { lat: 40.6428, lng: -89.5912 }, original_location: "34.0608766,-117.70619506" }, { id: 8, location: "40.6503,-89.652", address: "300 McKinley Ave, Bartonville, IL 61607", description: "300 McKinley Ave, Bartonville, IL 61607", corrected_coordinates: { lat: 40.6503, lng: -89.652 }, original_location: "34.0608766,-117.70619506" }, { id: 9, location: "41.15559691072346,-96.14976209971408", address: "Scooter Coffee Depot", description: "Scooter Coffee Depot", corrected_coordinates: { lat: 41.15559691072346, lng: -96.14976209971408 }, original_location: "34.0608766,-117.70619506" } ]3b:T96d,inputs = { let newBase = new Date(1739890800000); const inputs = { hazmat: Inputs.select( [ { name: "None", value: "none" }, { name: "Circumstantial", value: "circumstantial" }, { name: "General", value: "general" } ], { label: "Hazmat", format: (x) => x.name, value: "none" } ), truckHeight: Inputs.text({ readonly: false, label: "Truck height (ft)", value: 13.5, width: 45 }), truckWidth: Inputs.text({ readonly: false, label: "width (ft)", value: 8.5, width: 45 }), truckLength: Inputs.text({ readonly: false, label: "length (ft)", value: 72, width: 45 }), mode: Inputs.select(routeStyles, { label: "Routing Mode", format: (x) => x.name, value: routeStyles.find((t) => t.name === "Automobile") }), departureTime: Inputs.datetime({ label: "Report Time", value: newBase }), remainingDriveTimeUntilBreak: Inputs.text({ readonly: false, label: "Remaining Drive Time Until Break (The available driving hours at origin before the driver needs to take a rest break) (hrs)", value: 8, width: 45 }), remainingDriveTime: Inputs.text({ readonly: false, label: "Remaining Drive Time (The available driving hours at origin until the end of duty) (hrs)", value: 11, width: 45 }), shortBreakDuration: Inputs.text({ readonly: false, label: "Short Break Duration (hrs)", value: 0.5, width: 45 }), endOfDutyBreakDuration: Inputs.text({ readonly: false, label: "End of Duty Break Duration (hrs)", value: 10, width: 45 }), maxDriveTimeBeforeBreak: Inputs.text({ readonly: false, label: "Max Drive Time Before Break (hrs)", value: 8, width: 45 }), maxDriveTimeBeforeLongBreak: Inputs.text({ readonly: false, label: "Max Drive Time Before Long Break (hrs)", value: 11, width: 45 }), currentLocation: Inputs.text({ label: "Current truck location (lat,lng)", value: "40.1177,-83.1265", width: 175 }), avoids: Inputs.checkbox( ["Tolls", "Highway", "Left_Turn", "Sharp_Turn", "Right_Turn", "UTurn"], { label: "Avoid on Route", value: [] } ) }; return inputs; }3c:Tbf6,newTimeline = { if (inputData_a) { // Helper function to format the timeline's title with start and end times const formatTimelineTitle = (content, start, end) => { const startTime = new Date(start).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }); const endTime = new Date(end).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }); return `${content}\n${startTime}-${endTime}`; }; // Helper function to create a new leg for driving or resting const createLeg = ( content, startTime, duration, isRest = false, className = "" ) => { const start = startTime * 1000; const end = (startTime + duration) * 1000; return { content: content, start: start, end: end, title: formatTimelineTitle(content, start, end), className: className }; }; // Initialize base time and sorted stops let baseTime = Date.parse(inputs.departureTime.value) / 1000; const stops = selectedStops.sort((a, b) => a.id - b.id); let stopIdx = 0; // Filter out "Summary" legs and clone the leg data let theLegs = structuredClone(routeMe.routes[0].legs).filter( (obj) => obj.description !== "Summary" ); // Iterate through each leg and populate content theLegs.forEach((l) => { const stopDescription = `Drive -> ${stops[stopIdx].description}`; if (!l.post_actions && l.description !== "Summary") { // For driving legs without post_actions const leg = createLeg(stopDescription, baseTime, l.duration.value); Object.assign(l, leg); stopIdx++; baseTime += l.duration.value; } else if (l.post_actions) { // For driving legs with post_actions (i.e., rest breaks) const leg = createLeg(stopDescription, baseTime, l.duration.value); Object.assign(l, leg); baseTime += l.duration.value; // Create a new leg for the rest break const restDuration = l.post_actions[0].duration; const restContent = `Rest -> ${stops[stopIdx].description}`; const restClassName = restDuration === inputData_a.shortBreakDuration * 3600 ? "rest-short-item" : "rest-long-item"; const restLeg = createLeg( restContent, baseTime, restDuration, true, restClassName ); theLegs.push(restLeg); baseTime += restDuration; } }); // Clear and create the timeline visualization let container = document.getElementById("visualization"); container.innerHTML = ""; // Clear previous content let options = { stack: false, showMinorLabels: true, format: { majorLabels: { millisecond: "HH:mm:ss" } } }; // Create and return the new timeline let tl = new vis.Timeline(container, theLegs, options); return tl; } }3d:Te05,html``3e:[] 31:{"id":"38162f327bd9aa70","slug":"hos-eta-route-report","title":"Use Case: Optimizing Route Planning for a Trucking Logistics Company Using Hours of Service (HOS) Reports","thumbnail":"87bb1da44cad8c361d6d33d364a53467713be4954c0cae8a09abb08298e0485f","access_level":"public","create_time":"$D2024-09-23T15:38:35.563Z","update_time":"$D2025-08-15T18:36:15.271Z","view_time":null,"first_public_time":"$D2024-09-25T15:46:39.393Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team","avatar_url":"https://avatars-next.observableusercontent.com/7a25d1b5deb9c5290b12e4e0914aacdbd4196bb5c3a94c63a0fda0fe706d28b2","tier":"starter_2024"},"version":907,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"bcb6b2e256659128","login":"jim-welch","name":"Jim Welch","avatar_url":"https://avatars-next.observableusercontent.com/6334ed2ccd004bd8ab34e9f05c047bf4ef291dea914767f26079d7756d073607","tier":null}],"members":[{"type":"individual","id":"bcb6b2e256659128","login":"jim-welch","name":"Jim Welch","avatar_url":"https://avatars-next.observableusercontent.com/6334ed2ccd004bd8ab34e9f05c047bf4ef291dea914767f26079d7756d073607","tier":null,"role":"editor"},{"type":"team","id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team","avatar_url":"https://avatars-next.observableusercontent.com/7a25d1b5deb9c5290b12e4e0914aacdbd4196bb5c3a94c63a0fda0fe706d28b2","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":{"id":"73d557bcc8a3ebc8","slug":"solutions","title":"Solutions","owner":{"id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team"}},"type":"notebook","body":{"title":"Use Case: Optimizing Route Planning for a Trucking Logistics Company Using Hours of Service (HOS) Reports","cells":[{"id":0,"value":"md`

Use Case: Optimizing Route Planning for a Trucking Logistics Company Using Hours of Service (HOS) Reports

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":552,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"md`

Hours of Service (HOS) Report Details

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"viewof apiKey = secret2(\"apiKey\", {\n title: \"NextBillion.ai API Key\",\n submit: \"Set\",\n description:\n \"Contact support@nextbillion.ai to get your API key\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":231,"value":"md`

Manifest

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":245,"value":"{\n const button = html` `;\n button.onclick = () => {\n mutable inputData_a = panel;\n button.disabled = true;\n };\n return html`${button}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"progress = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":233,"value":"md`

Route Plan

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"md`

Timeline and Map

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":451,"value":"mytimeline = html`\n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":725,"value":"md`

Route Report

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":730,"value":"viewof routeReportTable = {\n if (routeMe) {\n // Add CSS for green highlighting if description includes 'Summary'\n const applyRowStyle = (row, column) => {\n const isOdd = row % 2;\n const style = `font-family: 'Montserrat',sans-serif;font-size:12pt;background-color: ${\n isOdd ? \"#f9f4f4;\" : \"#d3cbcb;\"\n }\"`;\n return html`

${column}

`;\n };\n if (inputData_a) {\n return Inputs.table(routeReport.mileage[0].segment.state, {\n columns: [\"value\", \"distance\"],\n width: {\n value: 120,\n distance: 20\n },\n header: {\n value: \"State\",\n distance: \"Distance (miles)\"\n },\n format: {\n value: (x, r) => applyRowStyle(r, x.split(\"|\")[1]),\n distance: (x, r) => applyRowStyle(r, (x * 0.00062).toFixed(1))\n },\n rows: 18,\n width: 400,\n multiple: false\n });\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":719,"value":"routeReport = {\n if (routeMe) {\n // Fetch directions API and update progress bar\n const fetchRouteReport = async () => {\n const route_data = {\n original_shape: routeMe.routes[0].geometry,\n original_shape_type: \"polyline\"\n };\n const response = await fetch(\n `https://api.nextbillion.io/route_report/json?key=${apiKey}&option=flexible`,\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(route_data)\n }\n );\n const data = await response.json();\n return data;\n };\n\n // Return the fetched directions data\n return fetchRouteReport();\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"// Function to determine the next drive break based on remaining drive time until break\nfunction calculateNextDriveBreak(remainingDriveTimeUntilBreak) {\n const maxDriveTimeWithoutBreak =\n inputData_a.maxDriveTimeBeforeBreak * 60 * 60; // 7 hours in seconds\n return Math.min(remainingDriveTimeUntilBreak, maxDriveTimeWithoutBreak);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":267,"value":"// Function to calculate the remaining drive time for the day\nfunction calculateEndOfDayDrive(remainingDriveTimeUntilEndOfDay) {\n const maxDailyDriveTime = inputData_a.maxDriveTimeBeforeLongBreak * 60 * 60;\n return Math.min(remainingDriveTimeUntilEndOfDay, maxDailyDriveTime);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":776,"value":"avoidInput = {\n if (inputData_a) {\n let avoids = \"\";\n inputData_a.avoids.forEach((av) => (avoids += `${av}|`));\n return avoids.length ? avoids.slice(0, -1) : \"none\";\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"nextbillion = {\n let nextbillion = await require(\"@nbai/nbmap-gl@2.5.1\");\n return nextbillion;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"{\n nextbillion.setApiKey(apiKey);\n return html`Set API key
nextbillion.setApiKey(${apiKey.substr(\n 0,\n 4\n )}....)`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"html`Add the stylesheet for the NB.ai SDK
<link href=\"https://maps-gl.nextbillion.io/maps/v2/api/css\" rel=\"stylesheet\">`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"import {\n parameters,\n routeAvoids,\n languages,\n cities,\n place_types,\n secret2,\n vehicleTypes,\n routeStyles\n} from \"@nbai/nextbillion-ai-dependencies\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"mutable inputData_a = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":447,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":442,"value":"vis = require(\"vis-timeline@latest/standalone/umd/vis-timeline-graph2d.min.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":878,"value":"apiKey","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"stylesheet = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":387,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W3e","stdlib":"1","titling":"auto"}} 32:"$31:body"