2d:null 2e:["$","title",null,{"children":"Route plan for Hub 3434 Florida - Without grouping | NB.AI Solutions Team | Observable"}] 33:T74f,kpiTable1 = { let kpis = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile01Jan)); mvrpID.forEach((sol) => { kpis.push(sol.kpis); }); yield Inputs.table(kpis, { columns: [ "planDate", "nbrRoutes", "nbrOrders", "unassigned", "totalItems", "totalTime", "totalDistance", "avgStops" ], header: { planDate: "Plan Date", nbrRoutes: "Routes", nbrOrders: "Orders", unassigned: "Unassigned", totalItems: "Total Items", totalTime: "Total Time", totalDistance: "Total Distance", avgStops: "Avg. Stops per Veh" }, width: { planDate: 80, nbrRoutes: 80, nbrOrders: 80, totalItems: 80, unassigned: 80, totalTime: 120, totalDistance: 120, avgStops: 120 }, format: { planDate: (x) => html`

${x}

`, nbrRoutes: (x) => html`

${x}

`, totalDistance: (x) => html`

${x}

`, avgStops: (x) => html`

${x}

`, unassigned: (x) => html`

${x}

`, totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`

${hours} HR ${minutes} MIN

`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }34:Tdd4,viewof routeStatsTable1 = { let routes = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile01Jan)); mvrpID[0].result.routes.forEach((sol) => { const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let loadWeight = sol.delivery[0]; let loadVolume = sol.delivery[1]; let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; steps.forEach((s) => { if (s.type === "job") { totalItems += parseInt(s.description.split("|")[3]); totalStops++; } }); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, loadWeight: loadWeight, loadVolume: loadVolume, totalItems: totalItems, totalStops: totalStops, totalRouteTime: totalRouteTime }); }); yield Inputs.table(routes, { columns: [ "description", "startTime", "completionTime", "loadWeight", "loadVolume", "totalItems", "totalStops", "totalDelivery", "totalPickup", "totalRetrip", "totalRouteTime", "duration", "service" ], header: { description: "Depot-Vehicle", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time", totalDelivery: "Deliveries", totalPickup: "Pickups", totalRetrip: "Retrips" }, width: { description: 125, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { description: (x) => html`

${x}

`, startTime: (x) => html`

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

`, completionTime: (x) => html`

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

`, loadWeight: (x) => html`

${x} lbs

`, loadVolume: (x) => html`

${x} in³

`, totalItems: (x) => html`

${x}

`, totalStops: (x) => html`

${x}

`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`

${hours} HR ${minutes} MIN

`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`

${hours} HR ${minutes} MIN

`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`

${hours} HR ${minutes} MIN

`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }35:Ta1d,viewof routeStepsTable1 = { if (routeStatsTable1) { yield Inputs.table(routeStatsTable1.steps, { columns: [ "sequence_nbr", "description", "order_id", "delivery_id", "arrival", "departure", "address", "distance", "duration", "service" ], header: { sequence_nbr: "Seq Nbr", description: "Task", arrival: "Arrival", departure: "Departure", distance: "Distance", duration: "Drive Time", service: "Service Time" }, width: { sequence_nbr: 20, order_id: 120, delivery_id: 120, address: 250, arrival: 80, departure: 80 }, format: { description: (x) => { return x.split("|")[4]; }, arrival: (x) => html`

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

`, departure: (x) => html`

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

`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }36:T74f,kpiTable2 = { let kpis = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile02Jan)); mvrpID.forEach((sol) => { kpis.push(sol.kpis); }); yield Inputs.table(kpis, { columns: [ "planDate", "nbrRoutes", "nbrOrders", "unassigned", "totalItems", "totalTime", "totalDistance", "avgStops" ], header: { planDate: "Plan Date", nbrRoutes: "Routes", nbrOrders: "Orders", unassigned: "Unassigned", totalItems: "Total Items", totalTime: "Total Time", totalDistance: "Total Distance", avgStops: "Avg. Stops per Veh" }, width: { planDate: 80, nbrRoutes: 80, nbrOrders: 80, totalItems: 80, unassigned: 80, totalTime: 120, totalDistance: 120, avgStops: 120 }, format: { planDate: (x) => html`
${x}
`, nbrRoutes: (x) => html`
${x}
`, totalDistance: (x) => html`
${x}
`, avgStops: (x) => html`
${x}
`, unassigned: (x) => html`
${x}
`, totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }37:Tdd4,viewof routeStatsTable2 = { let routes = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile02Jan)); mvrpID[0].result.routes.forEach((sol) => { const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let loadWeight = sol.delivery[0]; let loadVolume = sol.delivery[1]; let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; steps.forEach((s) => { if (s.type === "job") { totalItems += parseInt(s.description.split("|")[3]); totalStops++; } }); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, loadWeight: loadWeight, loadVolume: loadVolume, totalItems: totalItems, totalStops: totalStops, totalRouteTime: totalRouteTime }); }); yield Inputs.table(routes, { columns: [ "description", "startTime", "completionTime", "loadWeight", "loadVolume", "totalItems", "totalStops", "totalDelivery", "totalPickup", "totalRetrip", "totalRouteTime", "duration", "service" ], header: { description: "Depot-Vehicle", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time", totalDelivery: "Deliveries", totalPickup: "Pickups", totalRetrip: "Retrips" }, width: { description: 125, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { description: (x) => html`
${x}
`, startTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, loadWeight: (x) => html`
${x} lbs
`, loadVolume: (x) => html`
${x} in³
`, totalItems: (x) => html`
${x}
`, totalStops: (x) => html`
${x}
`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }38:Ta1d,viewof routeStepsTable2 = { if (routeStatsTable2) { yield Inputs.table(routeStatsTable2.steps, { columns: [ "sequence_nbr", "description", "order_id", "delivery_id", "arrival", "departure", "address", "distance", "duration", "service" ], header: { sequence_nbr: "Seq Nbr", description: "Task", arrival: "Arrival", departure: "Departure", distance: "Distance", duration: "Drive Time", service: "Service Time" }, width: { sequence_nbr: 20, order_id: 120, delivery_id: 120, address: 250, arrival: 80, departure: 80 }, format: { description: (x) => { return x.split("|")[4]; }, arrival: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, departure: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }39:T74f,kpiTable3 = { let kpis = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile03Jan)); mvrpID.forEach((sol) => { kpis.push(sol.kpis); }); yield Inputs.table(kpis, { columns: [ "planDate", "nbrRoutes", "nbrOrders", "unassigned", "totalItems", "totalTime", "totalDistance", "avgStops" ], header: { planDate: "Plan Date", nbrRoutes: "Routes", nbrOrders: "Orders", unassigned: "Unassigned", totalItems: "Total Items", totalTime: "Total Time", totalDistance: "Total Distance", avgStops: "Avg. Stops per Veh" }, width: { planDate: 80, nbrRoutes: 80, nbrOrders: 80, totalItems: 80, unassigned: 80, totalTime: 120, totalDistance: 120, avgStops: 120 }, format: { planDate: (x) => html`
${x}
`, nbrRoutes: (x) => html`
${x}
`, totalDistance: (x) => html`
${x}
`, avgStops: (x) => html`
${x}
`, unassigned: (x) => html`
${x}
`, totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }3a:Tdd4,viewof routeStatsTable3 = { let routes = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile03Jan)); mvrpID[0].result.routes.forEach((sol) => { const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let loadWeight = sol.delivery[0]; let loadVolume = sol.delivery[1]; let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; steps.forEach((s) => { if (s.type === "job") { totalItems += parseInt(s.description.split("|")[3]); totalStops++; } }); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, loadWeight: loadWeight, loadVolume: loadVolume, totalItems: totalItems, totalStops: totalStops, totalRouteTime: totalRouteTime }); }); yield Inputs.table(routes, { columns: [ "description", "startTime", "completionTime", "loadWeight", "loadVolume", "totalItems", "totalStops", "totalDelivery", "totalPickup", "totalRetrip", "totalRouteTime", "duration", "service" ], header: { description: "Depot-Vehicle", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time", totalDelivery: "Deliveries", totalPickup: "Pickups", totalRetrip: "Retrips" }, width: { description: 125, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { description: (x) => html`
${x}
`, startTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, loadWeight: (x) => html`
${x} lbs
`, loadVolume: (x) => html`
${x} in³
`, totalItems: (x) => html`
${x}
`, totalStops: (x) => html`
${x}
`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }3b:Ta1d,viewof routeStepsTable3 = { if (routeStatsTable3) { yield Inputs.table(routeStatsTable3.steps, { columns: [ "sequence_nbr", "description", "order_id", "delivery_id", "arrival", "departure", "address", "distance", "duration", "service" ], header: { sequence_nbr: "Seq Nbr", description: "Task", arrival: "Arrival", departure: "Departure", distance: "Distance", duration: "Drive Time", service: "Service Time" }, width: { sequence_nbr: 20, order_id: 120, delivery_id: 120, address: 250, arrival: 80, departure: 80 }, format: { description: (x) => { return x.split("|")[4]; }, arrival: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, departure: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }3c:T74f,kpiTable4 = { let kpis = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile04Jan)); mvrpID.forEach((sol) => { kpis.push(sol.kpis); }); yield Inputs.table(kpis, { columns: [ "planDate", "nbrRoutes", "nbrOrders", "unassigned", "totalItems", "totalTime", "totalDistance", "avgStops" ], header: { planDate: "Plan Date", nbrRoutes: "Routes", nbrOrders: "Orders", unassigned: "Unassigned", totalItems: "Total Items", totalTime: "Total Time", totalDistance: "Total Distance", avgStops: "Avg. Stops per Veh" }, width: { planDate: 80, nbrRoutes: 80, nbrOrders: 80, totalItems: 80, unassigned: 80, totalTime: 120, totalDistance: 120, avgStops: 120 }, format: { planDate: (x) => html`
${x}
`, nbrRoutes: (x) => html`
${x}
`, totalDistance: (x) => html`
${x}
`, avgStops: (x) => html`
${x}
`, unassigned: (x) => html`
${x}
`, totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }3d:Tdd4,viewof routeStatsTable4 = { let routes = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile04Jan)); mvrpID[0].result.routes.forEach((sol) => { const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let loadWeight = sol.delivery[0]; let loadVolume = sol.delivery[1]; let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; steps.forEach((s) => { if (s.type === "job") { totalItems += parseInt(s.description.split("|")[3]); totalStops++; } }); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, loadWeight: loadWeight, loadVolume: loadVolume, totalItems: totalItems, totalStops: totalStops, totalRouteTime: totalRouteTime }); }); yield Inputs.table(routes, { columns: [ "description", "startTime", "completionTime", "loadWeight", "loadVolume", "totalItems", "totalStops", "totalDelivery", "totalPickup", "totalRetrip", "totalRouteTime", "duration", "service" ], header: { description: "Depot-Vehicle", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time", totalDelivery: "Deliveries", totalPickup: "Pickups", totalRetrip: "Retrips" }, width: { description: 125, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { description: (x) => html`
${x}
`, startTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, loadWeight: (x) => html`
${x} lbs
`, loadVolume: (x) => html`
${x} in³
`, totalItems: (x) => html`
${x}
`, totalStops: (x) => html`
${x}
`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }3e:Ta1d,viewof routeStepsTable4 = { if (routeStatsTable4) { yield Inputs.table(routeStatsTable4.steps, { columns: [ "sequence_nbr", "description", "order_id", "delivery_id", "arrival", "departure", "address", "distance", "duration", "service" ], header: { sequence_nbr: "Seq Nbr", description: "Task", arrival: "Arrival", departure: "Departure", distance: "Distance", duration: "Drive Time", service: "Service Time" }, width: { sequence_nbr: 20, order_id: 120, delivery_id: 120, address: 250, arrival: 80, departure: 80 }, format: { description: (x) => { return x.split("|")[4]; }, arrival: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, departure: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }3f:T74f,kpiTable5 = { let kpis = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile05Jan)); mvrpID.forEach((sol) => { kpis.push(sol.kpis); }); yield Inputs.table(kpis, { columns: [ "planDate", "nbrRoutes", "nbrOrders", "unassigned", "totalItems", "totalTime", "totalDistance", "avgStops" ], header: { planDate: "Plan Date", nbrRoutes: "Routes", nbrOrders: "Orders", unassigned: "Unassigned", totalItems: "Total Items", totalTime: "Total Time", totalDistance: "Total Distance", avgStops: "Avg. Stops per Veh" }, width: { planDate: 80, nbrRoutes: 80, nbrOrders: 80, totalItems: 80, unassigned: 80, totalTime: 120, totalDistance: 120, avgStops: 120 }, format: { planDate: (x) => html`
${x}
`, nbrRoutes: (x) => html`
${x}
`, totalDistance: (x) => html`
${x}
`, avgStops: (x) => html`
${x}
`, unassigned: (x) => html`
${x}
`, totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }40:Tdd4,viewof routeStatsTable5 = { let routes = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile05Jan)); mvrpID[0].result.routes.forEach((sol) => { const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let loadWeight = sol.delivery[0]; let loadVolume = sol.delivery[1]; let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; steps.forEach((s) => { if (s.type === "job") { totalItems += parseInt(s.description.split("|")[3]); totalStops++; } }); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, loadWeight: loadWeight, loadVolume: loadVolume, totalItems: totalItems, totalStops: totalStops, totalRouteTime: totalRouteTime }); }); yield Inputs.table(routes, { columns: [ "description", "startTime", "completionTime", "loadWeight", "loadVolume", "totalItems", "totalStops", "totalDelivery", "totalPickup", "totalRetrip", "totalRouteTime", "duration", "service" ], header: { description: "Depot-Vehicle", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time", totalDelivery: "Deliveries", totalPickup: "Pickups", totalRetrip: "Retrips" }, width: { description: 125, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { description: (x) => html`
${x}
`, startTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, loadWeight: (x) => html`
${x} lbs
`, loadVolume: (x) => html`
${x} in³
`, totalItems: (x) => html`
${x}
`, totalStops: (x) => html`
${x}
`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }41:Ta1d,viewof routeStepsTable5 = { if (routeStatsTable5) { yield Inputs.table(routeStatsTable5.steps, { columns: [ "sequence_nbr", "description", "order_id", "delivery_id", "arrival", "departure", "address", "distance", "duration", "service" ], header: { sequence_nbr: "Seq Nbr", description: "Task", arrival: "Arrival", departure: "Departure", distance: "Distance", duration: "Drive Time", service: "Service Time" }, width: { sequence_nbr: 20, order_id: 120, delivery_id: 120, address: 250, arrival: 80, departure: 80 }, format: { description: (x) => { return x.split("|")[4]; }, arrival: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, departure: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }42:T74f,kpiTable6 = { let kpis = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile06Jan)); mvrpID.forEach((sol) => { kpis.push(sol.kpis); }); yield Inputs.table(kpis, { columns: [ "planDate", "nbrRoutes", "nbrOrders", "unassigned", "totalItems", "totalTime", "totalDistance", "avgStops" ], header: { planDate: "Plan Date", nbrRoutes: "Routes", nbrOrders: "Orders", unassigned: "Unassigned", totalItems: "Total Items", totalTime: "Total Time", totalDistance: "Total Distance", avgStops: "Avg. Stops per Veh" }, width: { planDate: 80, nbrRoutes: 80, nbrOrders: 80, totalItems: 80, unassigned: 80, totalTime: 120, totalDistance: 120, avgStops: 120 }, format: { planDate: (x) => html`
${x}
`, nbrRoutes: (x) => html`
${x}
`, totalDistance: (x) => html`
${x}
`, avgStops: (x) => html`
${x}
`, unassigned: (x) => html`
${x}
`, totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }43:Tdd4,viewof routeStatsTable6 = { let routes = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile06Jan)); mvrpID[0].result.routes.forEach((sol) => { const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let loadWeight = sol.delivery[0]; let loadVolume = sol.delivery[1]; let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; steps.forEach((s) => { if (s.type === "job") { totalItems += parseInt(s.description.split("|")[3]); totalStops++; } }); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, loadWeight: loadWeight, loadVolume: loadVolume, totalItems: totalItems, totalStops: totalStops, totalRouteTime: totalRouteTime }); }); yield Inputs.table(routes, { columns: [ "description", "startTime", "completionTime", "loadWeight", "loadVolume", "totalItems", "totalStops", "totalDelivery", "totalPickup", "totalRetrip", "totalRouteTime", "duration", "service" ], header: { description: "Depot-Vehicle", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time", totalDelivery: "Deliveries", totalPickup: "Pickups", totalRetrip: "Retrips" }, width: { description: 125, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { description: (x) => html`
${x}
`, startTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, loadWeight: (x) => html`
${x} lbs
`, loadVolume: (x) => html`
${x} in³
`, totalItems: (x) => html`
${x}
`, totalStops: (x) => html`
${x}
`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }44:Ta1d,viewof routeStepsTable6 = { if (routeStatsTable6) { yield Inputs.table(routeStatsTable6.steps, { columns: [ "sequence_nbr", "description", "order_id", "delivery_id", "arrival", "departure", "address", "distance", "duration", "service" ], header: { sequence_nbr: "Seq Nbr", description: "Task", arrival: "Arrival", departure: "Departure", distance: "Distance", duration: "Drive Time", service: "Service Time" }, width: { sequence_nbr: 20, order_id: 120, delivery_id: 120, address: 250, arrival: 80, departure: 80 }, format: { description: (x) => { return x.split("|")[4]; }, arrival: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, departure: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }45:T74f,kpiTable7 = { let kpis = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile07Jan)); mvrpID.forEach((sol) => { kpis.push(sol.kpis); }); yield Inputs.table(kpis, { columns: [ "planDate", "nbrRoutes", "nbrOrders", "unassigned", "totalItems", "totalTime", "totalDistance", "avgStops" ], header: { planDate: "Plan Date", nbrRoutes: "Routes", nbrOrders: "Orders", unassigned: "Unassigned", totalItems: "Total Items", totalTime: "Total Time", totalDistance: "Total Distance", avgStops: "Avg. Stops per Veh" }, width: { planDate: 80, nbrRoutes: 80, nbrOrders: 80, totalItems: 80, unassigned: 80, totalTime: 120, totalDistance: 120, avgStops: 120 }, format: { planDate: (x) => html`
${x}
`, nbrRoutes: (x) => html`
${x}
`, totalDistance: (x) => html`
${x}
`, avgStops: (x) => html`
${x}
`, unassigned: (x) => html`
${x}
`, totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }46:Tdd4,viewof routeStatsTable7 = { let routes = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile07Jan)); mvrpID[0].result.routes.forEach((sol) => { const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let loadWeight = sol.delivery[0]; let loadVolume = sol.delivery[1]; let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; steps.forEach((s) => { if (s.type === "job") { totalItems += parseInt(s.description.split("|")[3]); totalStops++; } }); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, loadWeight: loadWeight, loadVolume: loadVolume, totalItems: totalItems, totalStops: totalStops, totalRouteTime: totalRouteTime }); }); yield Inputs.table(routes, { columns: [ "description", "startTime", "completionTime", "loadWeight", "loadVolume", "totalItems", "totalStops", "totalDelivery", "totalPickup", "totalRetrip", "totalRouteTime", "duration", "service" ], header: { description: "Depot-Vehicle", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time", totalDelivery: "Deliveries", totalPickup: "Pickups", totalRetrip: "Retrips" }, width: { description: 125, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { description: (x) => html`
${x}
`, startTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, loadWeight: (x) => html`
${x} lbs
`, loadVolume: (x) => html`
${x} in³
`, totalItems: (x) => html`
${x}
`, totalStops: (x) => html`
${x}
`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }47:Ta1d,viewof routeStepsTable7 = { if (routeStatsTable7) { yield Inputs.table(routeStatsTable7.steps, { columns: [ "sequence_nbr", "description", "order_id", "delivery_id", "arrival", "departure", "address", "distance", "duration", "service" ], header: { sequence_nbr: "Seq Nbr", description: "Task", arrival: "Arrival", departure: "Departure", distance: "Distance", duration: "Drive Time", service: "Service Time" }, width: { sequence_nbr: 20, order_id: 120, delivery_id: 120, address: 250, arrival: 80, departure: 80 }, format: { description: (x) => { return x.split("|")[4]; }, arrival: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, departure: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }48:Te7f,styling = html` `49:[{"id":"fb8e3dfbd38eef8b9755ed208cf907d01977500ff0c07513d89d71b418bb619bda69306e808adb94d17a9382e28d009dba2601897526690e6c91062741ed2167","href":"https://static.observableusercontent.com/files/fb8e3dfbd38eef8b9755ed208cf907d01977500ff0c07513d89d71b418bb619bda69306e808adb94d17a9382e28d009dba2601897526690e6c91062741ed2167","name":"3434-01Jan25-Unclustered.json","type":"application/json","lastModified":1737361544729.176,"size":1636080},{"id":"d904249ccd5e737d00173ed556de4053fc399e0a4648f5a89bd746f60fc45bf295bdc7528744102aaa1e331939152445ba7d7489bcb53375fac88997684a7f1b","href":"https://static.observableusercontent.com/files/d904249ccd5e737d00173ed556de4053fc399e0a4648f5a89bd746f60fc45bf295bdc7528744102aaa1e331939152445ba7d7489bcb53375fac88997684a7f1b","name":"3434-07Jan25-Unclustered.json","type":"application/json","lastModified":1737361585906.65,"size":1332562},{"id":"b0d080a837b4671ebfa296c4df62e3da750c96c0dcbd2de11695393451fefab8c2f113e6297c059ce4ac88deba3e54542d1b14cfa8835d90b214e1fdcd008ec8","href":"https://static.observableusercontent.com/files/b0d080a837b4671ebfa296c4df62e3da750c96c0dcbd2de11695393451fefab8c2f113e6297c059ce4ac88deba3e54542d1b14cfa8835d90b214e1fdcd008ec8","name":"3434-02Jan25-Unclustered.json","type":"application/json","lastModified":1737361553103.084,"size":1490472},{"id":"418ceea84fd79531eb43899c80784c7e426b5da4d600256a422e8cef65caa6a3fba7c26625b86daedd7172faf552ce462eabd3b4f297f447700673a1288e8e57","href":"https://static.observableusercontent.com/files/418ceea84fd79531eb43899c80784c7e426b5da4d600256a422e8cef65caa6a3fba7c26625b86daedd7172faf552ce462eabd3b4f297f447700673a1288e8e57","name":"3434-03Jan25-Unclustered.json","type":"application/json","lastModified":1737361559861.618,"size":1348771},{"id":"995462995b6ac1d65e2626ea22b41857858f81516bb56fe289da05f9cda35ad44d7f7977bbd4e626e84e4f6f6889b3c6e5cee05a2e6a84fb437b88c2919ca896","href":"https://static.observableusercontent.com/files/995462995b6ac1d65e2626ea22b41857858f81516bb56fe289da05f9cda35ad44d7f7977bbd4e626e84e4f6f6889b3c6e5cee05a2e6a84fb437b88c2919ca896","name":"3434-04Jan25-Unclustered.json","type":"application/json","lastModified":1737361565997.213,"size":1341386},{"id":"0d71a3126797c705a4f48f8b54e9f42df9c22111fe7fe9d5bf571a9b756609ded1d2986e024563f6127c7d7ae66aa751624ea1c8a1fa5240c618e9229d8fcd94","href":"https://static.observableusercontent.com/files/0d71a3126797c705a4f48f8b54e9f42df9c22111fe7fe9d5bf571a9b756609ded1d2986e024563f6127c7d7ae66aa751624ea1c8a1fa5240c618e9229d8fcd94","name":"3434-05Jan25-Unclustered.json","type":"application/json","lastModified":1737361574014.077,"size":1352632},{"id":"dc5620a33fe7f36e3696abc09ccab309bd881b42827ca282a0779d073dcc98a99579dafb2ee43fc60d8363f37b73aa5e11aa8eed0ea23bda195cdd4914468973","href":"https://static.observableusercontent.com/files/dc5620a33fe7f36e3696abc09ccab309bd881b42827ca282a0779d073dcc98a99579dafb2ee43fc60d8363f37b73aa5e11aa8eed0ea23bda195cdd4914468973","name":"3434-06Jan25-Unclustered.json","type":"application/json","lastModified":1737361579251.256,"size":1369586}] 31:{"id":"680fe2faa9cadf2f","slug":"routeplan-hub-3434-without-grouping","title":"Route plan for Hub 3434 Florida - Without grouping","thumbnail":"a16052ea55bb813788761c28bdbbe64d3c0e4b70cc69da8ca5575b57ed2d1930","access_level":"public","create_time":"$D2025-01-20T08:24:12.162Z","update_time":"$D2025-01-20T08:27:54.390Z","view_time":null,"first_public_time":"$D2025-01-20T08:25:15.777Z","has_unpublished_edits":null,"fork":{"id":"2c89a35dcdb22648","slug":"routeplan-hub-3434","title":"Route plan for Hub 3434 Florida - 5KM grouping","owner":{"id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team"}},"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":1531,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7c6aa4c7c386f728","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":null}],"members":[{"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":0,"collection":null,"type":"notebook","body":{"title":"Route plan for Hub 3434 Florida - Without grouping","cells":[{"id":0,"value":"# Route plan for Hub 3434 Florida - Without grouping","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":353,"value":"----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1300,"value":"viewof section = Inputs.select(\n [\n { value: \"section2\", label: \"01-Jan-2025\" },\n { value: \"section3\", label: \"02-Jan-2025\" },\n { value: \"section4\", label: \"03-Jan-2025\" },\n { value: \"section5\", label: \"04-Jan-2025\" },\n { value: \"section6\", label: \"05-Jan-2025\" },\n { value: \"section7\", label: \"06-Jan-2025\" },\n { value: \"section8\", label: \"07-Jan-2025\" }\n ],\n {\n label: \"Select date to view result:\",\n format: (option) => option.label,\n style: \"position: sticky; top: 0; background: #fff; z-index: 1000;\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1529,"value":"----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1313,"value":"md`
${solutionFile01Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1411,"value":"md`### ${daywiseData01Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":984,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":988,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1009,"value":"viewof downloadZipButton1 = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = JSON.parse(JSON.stringify(solutionFile01Jan));\n const zipBlob = await createdFiles01Jan; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1023,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1317,"value":"md`
${solutionFile02Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1415,"value":"md`### ${daywiseData02Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1092,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1095,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1098,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1101,"value":"viewof downloadZipButton2 = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = JSON.parse(JSON.stringify(solutionFile02Jan));\n const zipBlob = await createdFiles02Jan; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1104,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1423,"value":"md`
${solutionFile03Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1419,"value":"md`### ${daywiseData03Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1207,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1210,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1213,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1216,"value":"viewof downloadZipButton3 = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = JSON.parse(JSON.stringify(solutionFile03Jan));\n const zipBlob = await createdFiles03Jan; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1219,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1427,"value":"md`
${solutionFile04Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1430,"value":"md`### ${daywiseData04Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1225,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1228,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1231,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1234,"value":"viewof downloadZipButton4 = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = JSON.parse(JSON.stringify(solutionFile04Jan));\n const zipBlob = await createdFiles04Jan; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1237,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1449,"value":"md`
${solutionFile05Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1452,"value":"md`### ${daywiseData05Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1243,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1246,"value":"$40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1249,"value":"$41","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1252,"value":"viewof downloadZipButton5 = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = JSON.parse(JSON.stringify(solutionFile05Jan));\n const zipBlob = await createdFiles05Jan; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1255,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1456,"value":"md`
${solutionFile06Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1459,"value":"md`### ${daywiseData06Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1261,"value":"$42","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1264,"value":"$43","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1267,"value":"$44","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1270,"value":"viewof downloadZipButton6 = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = JSON.parse(JSON.stringify(solutionFile06Jan));\n const zipBlob = await createdFiles06Jan; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1273,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1463,"value":"md`
${solutionFile07Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1466,"value":"md`### ${daywiseData07Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1279,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1282,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1285,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1288,"value":"viewof downloadZipButton7 = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = JSON.parse(JSON.stringify(solutionFile07Jan));\n const zipBlob = await createdFiles07Jan; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1291,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"ncc_url_31Dec = `console.nextbillion.ai/route-planner-viewer?id=${theroute31Dec[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1019,"value":"ncc_url_01Jan = `console.nextbillion.ai/route-planner-viewer?id=${theroute01Jan[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1168,"value":"ncc_url_02Jan = `console.nextbillion.ai/route-planner-viewer?id=${theroute02Jan[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1170,"value":"ncc_url_03Jan = `console.nextbillion.ai/route-planner-viewer?id=${theroute03Jan[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1172,"value":"ncc_url_04Jan = `console.nextbillion.ai/route-planner-viewer?id=${theroute04Jan[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1174,"value":"ncc_url_05Jan = `console.nextbillion.ai/route-planner-viewer?id=${theroute05Jan[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1176,"value":"ncc_url_06Jan = `console.nextbillion.ai/route-planner-viewer?id=${theroute06Jan[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1178,"value":"ncc_url_07Jan = `console.nextbillion.ai/route-planner-viewer?id=${theroute07Jan[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":610,"value":"import { zip, zipreader } from \"@fil/jszip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"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":729,"value":"function transformRoutes(routes) {\n const currentLocaleDateTime = (x) =>\n new Date(x * 1000).toLocaleTimeString([], {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false\n });\n\n return routes.map((r) => ({\n description: r.description,\n startTime: currentLocaleDateTime(r.startTime),\n completionTime: currentLocaleDateTime(r.completionTime),\n duration: r.duration,\n distance: r.distance,\n loadWeight: r.loadWeight,\n loadVolume: r.loadVolume,\n totalItems: r.totalItems,\n totalDelivery: r.totalDelivery,\n totalPickup: r.totalPickup,\n totalRetrip: r.totalRetrip,\n totalStops: r.totalStops,\n totalRouteTime: r.totalRouteTime\n }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"function transformSteps(steps) {\n const currentLocaleDateTime = (x) =>\n new Date(x * 1000).toLocaleTimeString([], {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false\n });\n\n return steps.map((step) => ({\n sequence_nbr: step.sequence_nbr,\n type: step.description ? step.description.split(\"|\")[4] : step.type,\n arrival: currentLocaleDateTime(step.arrival),\n departure: currentLocaleDateTime(step.departure),\n order_id: step.order_id,\n delivery_id: step.delivery_id,\n address: step.address,\n distance: step.distance,\n duration: step.duration,\n service: step.service,\n waiting_time: step.waiting_time,\n appointment_window_breach: step.waiting_time == 0 ? \"On-time\" : \"Early\",\n weight: step.weight,\n volume: step.volume,\n location: `${step.location[0]},${step.location[1]}`,\n snapped_location: `${step.snapped_location[0]},${step.snapped_location[1]}`\n }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":697,"value":"theroute31Dec = {\n const mvrpData = solutionFile31Dec;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1017,"value":"theroute01Jan = {\n const mvrpData = solutionFile01Jan;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1180,"value":"theroute02Jan = {\n const mvrpData = solutionFile02Jan;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1182,"value":"theroute03Jan = {\n const mvrpData = solutionFile03Jan;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1184,"value":"theroute04Jan = {\n const mvrpData = solutionFile04Jan;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1186,"value":"theroute05Jan = {\n const mvrpData = solutionFile05Jan;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1188,"value":"theroute06Jan = {\n const mvrpData = solutionFile06Jan;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1190,"value":"theroute07Jan = {\n const mvrpData = solutionFile07Jan;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"createdFiles31Dec = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = JSON.parse(JSON.stringify(solutionFile31Dec));\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1045,"value":"createdFiles01Jan = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = JSON.parse(JSON.stringify(solutionFile01Jan));\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n console.log(routes);\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1192,"value":"createdFiles02Jan = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = JSON.parse(JSON.stringify(solutionFile02Jan));\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n console.log(routes);\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1194,"value":"createdFiles03Jan = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = JSON.parse(JSON.stringify(solutionFile03Jan));\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n console.log(routes);\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1196,"value":"createdFiles04Jan = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = JSON.parse(JSON.stringify(solutionFile04Jan));\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n console.log(routes);\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1198,"value":"createdFiles05Jan = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = JSON.parse(JSON.stringify(solutionFile05Jan));\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n console.log(routes);\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1200,"value":"createdFiles06Jan = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = JSON.parse(JSON.stringify(solutionFile06Jan));\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n console.log(routes);\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1202,"value":"createdFiles07Jan = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = JSON.parse(JSON.stringify(solutionFile07Jan));\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n console.log(routes);\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":655,"value":"function jsonToCSV(jsonArray) {\n if (!jsonArray || jsonArray.length === 0) {\n return \"\";\n }\n\n const keys = Object.keys(jsonArray[0]); // Extract headers from the first object\n const escapeValue = (value) => {\n if (typeof value === \"string\") {\n // Wrap in quotes if it contains commas, quotes, or line breaks\n if (value.includes(\",\") || value.includes('\"') || value.includes(\"\\n\")) {\n return `\"${value.replace(/\"/g, '\"\"')}\"`; // Escape quotes by doubling them\n }\n return value; // No special characters, return as is\n }\n return value ?? \"\"; // Handle null/undefined as empty string\n };\n\n const header = keys.join(\",\"); // Create the header row\n const rows = jsonArray.map((obj) =>\n keys.map((key) => escapeValue(obj[key])).join(\",\")\n ); // Escape values in each row\n\n return [header, ...rows].join(\"\\n\"); // Combine header and rows into the final CSV string\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":956,"value":"solutionFile31Dec = await FileAttachment(\"3434-31Dec24.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":973,"value":"solutionFile01Jan = await FileAttachment(\"3434-01Jan25-Unclustered.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1125,"value":"solutionFile02Jan = await FileAttachment(\"3434-02Jan25-Unclustered.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1127,"value":"solutionFile03Jan = await FileAttachment(\"3434-03Jan25-Unclustered.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1129,"value":"solutionFile04Jan = await FileAttachment(\"3434-04Jan25-Unclustered.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1131,"value":"solutionFile05Jan = await FileAttachment(\"3434-05Jan25-Unclustered.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1133,"value":"solutionFile06Jan = await FileAttachment(\"3434-06Jan25-Unclustered.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1135,"value":"solutionFile07Jan = await FileAttachment(\"3434-07Jan25-Unclustered.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1366,"value":"daywiseData31Dec = {\n var id = JSON.parse(JSON.stringify(solutionFile31Dec));\n var totalOrders = id[0].kpis.nbrOrders + id[0].kpis.unassigned;\n var text =\n id[0].kpis.planDate + \" - Hub \" + hub + \", \" + totalOrders + \" orders\";\n return text;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1396,"value":"daywiseData01Jan = {\n var id = JSON.parse(JSON.stringify(solutionFile01Jan));\n var totalOrders = id[0].kpis.nbrOrders + id[0].kpis.unassigned;\n var text =\n id[0].kpis.planDate + \" - Hub \" + hub + \", \" + totalOrders + \" orders\";\n return text;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1398,"value":"daywiseData02Jan = {\n var id = JSON.parse(JSON.stringify(solutionFile02Jan));\n var totalOrders = id[0].kpis.nbrOrders + id[0].kpis.unassigned;\n var text =\n id[0].kpis.planDate +\n \" - Hub \" +\n hub +\n \", \" +\n totalOrders +\n \" orders\";\n return text;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1400,"value":"daywiseData03Jan = {\n var id = JSON.parse(JSON.stringify(solutionFile03Jan));\n var totalOrders = id[0].kpis.nbrOrders + id[0].kpis.unassigned;\n var text =\n id[0].kpis.planDate + \" - Hub \" + hub + \", \" + totalOrders + \" orders\";\n return text;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1402,"value":"daywiseData04Jan = {\n var id = JSON.parse(JSON.stringify(solutionFile04Jan));\n var totalOrders = id[0].kpis.nbrOrders + id[0].kpis.unassigned;\n var text =\n id[0].kpis.planDate + \" - Hub \" + hub + \", \" + totalOrders + \" orders\";\n return text;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1404,"value":"daywiseData05Jan = {\n var id = JSON.parse(JSON.stringify(solutionFile05Jan));\n var totalOrders = id[0].kpis.nbrOrders + id[0].kpis.unassigned;\n var text =\n id[0].kpis.planDate + \" - Hub \" + hub + \", \" + totalOrders + \" orders\";\n return text;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1406,"value":"daywiseData06Jan = {\n var id = JSON.parse(JSON.stringify(solutionFile06Jan));\n var totalOrders = id[0].kpis.nbrOrders + id[0].kpis.unassigned;\n var text =\n id[0].kpis.planDate + \" - Hub \" + hub + \", \" + totalOrders + \" orders\";\n return text;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1408,"value":"daywiseData07Jan = {\n var id = JSON.parse(JSON.stringify(solutionFile07Jan));\n var totalOrders = id[0].kpis.nbrOrders + id[0].kpis.unassigned;\n var text =\n id[0].kpis.planDate + \" - Hub \" + hub + \", \" + totalOrders + \" orders\";\n return text;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1372,"value":"hub = 3434","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1321,"value":"section_listener = {\n const dropdown = section;\n if (dropdown) {\n console.log(dropdown);\n document\n .getElementById(dropdown.value)\n ?.scrollIntoView({ behavior: \"smooth\", block: \"start\" });\n }\n return dropdown; // Return the selected value for reference\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1303,"value":"import { Inputs } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1","titling":"auto"}} 32:"$31:body"