2d:null 2e:["$","title",null,{"children":"Route plan for Hub 3960 Knoxville - 5KM grouping | NB.AI Solutions Team | Observable"}] 33:T74e,kpiTable = { let kpis = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile31Dec)); 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:Tdd3,viewof routeStatsTable = { let routes = []; let mvrpID = JSON.parse(JSON.stringify(solutionFile31Dec)); 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:Ta1a,viewof routeStepsTable = { if (routeStatsTable) { yield Inputs.table(routeStatsTable.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,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 }); }37: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 }); }38: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`; } }39: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 }); }3a: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 }); }3b: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`; } }3c: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 }); }3d: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 }); }3e: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`; } }3f: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 }); }40: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 }); }41: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`; } }42: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 }); }43: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 }); }44: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`; } }45: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 }); }46: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 }); }47: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`; } }48: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 }); }49: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 }); }4a: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`; } }4b:Te7f,styling = html` `4c:[{"id":"1c34b2b8339dd180b8c6aaabc49bd94d434cea6547ccbd6b9a357ac407e3674a06b9778c6e7985acc53513ea93ce4a2f342faaf24c92b04cf5d234230f5c2e07","href":"https://static.observableusercontent.com/files/1c34b2b8339dd180b8c6aaabc49bd94d434cea6547ccbd6b9a357ac407e3674a06b9778c6e7985acc53513ea93ce4a2f342faaf24c92b04cf5d234230f5c2e07","name":"3960-31Dec24.json","type":"application/json","lastModified":1737084529957.856,"size":925621},{"id":"82dfb4bac241fd8fe6ab5da5be3f969f1d8270704129cd2feaab3cd16d4e47030761527769a17258a632f6994a1da3e70948d95057a583609e79fb40ec0be787","href":"https://static.observableusercontent.com/files/82dfb4bac241fd8fe6ab5da5be3f969f1d8270704129cd2feaab3cd16d4e47030761527769a17258a632f6994a1da3e70948d95057a583609e79fb40ec0be787","name":"3960-01Jan25.json","type":"application/json","lastModified":1737085865908.411,"size":759698},{"id":"c335f2b66a38826a2a528107491fc7bc8bf5092a4538e40dabb4d68a51b4101f5194903192b4f37cb31eec60a5048191b5ae06e7b51931c675a2bbf3483b022b","href":"https://static.observableusercontent.com/files/c335f2b66a38826a2a528107491fc7bc8bf5092a4538e40dabb4d68a51b4101f5194903192b4f37cb31eec60a5048191b5ae06e7b51931c675a2bbf3483b022b","name":"3960-02Jan25.json","type":"application/json","lastModified":1737087354134.115,"size":988575},{"id":"fdca6b1f07e81f38bb3777c2680a88b396490285b280ce2dd227458504ba17f66cfbaee11e8b450c962de4f79e89782fa5d3edd1390f738b6c817bdc5a759f91","href":"https://static.observableusercontent.com/files/fdca6b1f07e81f38bb3777c2680a88b396490285b280ce2dd227458504ba17f66cfbaee11e8b450c962de4f79e89782fa5d3edd1390f738b6c817bdc5a759f91","name":"3960-03Jan25.json","type":"application/json","lastModified":1737088388886.791,"size":928577},{"id":"d141ca4eae2ab2c5ed97283b0560d13f0bff4dedaddd83e89d85ec95df024e2f3804ede606af616cb61e100b637cfc6c964e92876eb1a175f54e09672c552521","href":"https://static.observableusercontent.com/files/d141ca4eae2ab2c5ed97283b0560d13f0bff4dedaddd83e89d85ec95df024e2f3804ede606af616cb61e100b637cfc6c964e92876eb1a175f54e09672c552521","name":"3960-04Jan25.json","type":"application/json","lastModified":1737089437797.583,"size":808040},{"id":"c5cf52545f5a892b367f6b3eb64b249739f2a70dd2b80be9d40b73d5ee653a775225bd1f6f041ef4ab1be40048f00ad2c9c193db6fdc85f142d7b98db5532855","href":"https://static.observableusercontent.com/files/c5cf52545f5a892b367f6b3eb64b249739f2a70dd2b80be9d40b73d5ee653a775225bd1f6f041ef4ab1be40048f00ad2c9c193db6fdc85f142d7b98db5532855","name":"3960-05Jan25.json","type":"application/json","lastModified":1737090997703.71,"size":799692},{"id":"56d288fb85e39c013679cd07a61625e372d9e579dfff1283253730188d9c55ef9e5e74afab250183f4ecfd91bc66de4ccbb9e7fb1c20f07d20edfcb6cd1303a5","href":"https://static.observableusercontent.com/files/56d288fb85e39c013679cd07a61625e372d9e579dfff1283253730188d9c55ef9e5e74afab250183f4ecfd91bc66de4ccbb9e7fb1c20f07d20edfcb6cd1303a5","name":"3960-06Jan25.json","type":"application/json","lastModified":1737091694586.865,"size":696515},{"id":"fd4becf00357160e3921a2d5cbc3e65d4e719d66150cfd97f8f4546f8e286b7d76c67d3c4134020de2608b7d44a34848c1ae99e0090e62a7da9cd88e5fffd1aa","href":"https://static.observableusercontent.com/files/fd4becf00357160e3921a2d5cbc3e65d4e719d66150cfd97f8f4546f8e286b7d76c67d3c4134020de2608b7d44a34848c1ae99e0090e62a7da9cd88e5fffd1aa","name":"3960-07Jan25.json","type":"application/json","lastModified":1737092425023.697,"size":993817},{"id":"80777812f9fb47ec982aa9059dfefb38ee8ccd5a5ce2482bfc56aa7df3ddbcfe4050b86a4be649b46e1a81c492eb682286a71905de76275d1fe6ce4ff7668dbb","href":"https://static.observableusercontent.com/files/80777812f9fb47ec982aa9059dfefb38ee8ccd5a5ce2482bfc56aa7df3ddbcfe4050b86a4be649b46e1a81c492eb682286a71905de76275d1fe6ce4ff7668dbb","name":"3960-04Jan25@1.json","type":"application/json","lastModified":1737093067079.123,"size":949391},{"id":"16ede683a1f2d0784a18893b564d4d96864c57b4082e1cedfd32fc2b725547848f23ea5c7c93a4dc5bad276872f1714add6efe48578da7ac9580a7c14dd4b562","href":"https://static.observableusercontent.com/files/16ede683a1f2d0784a18893b564d4d96864c57b4082e1cedfd32fc2b725547848f23ea5c7c93a4dc5bad276872f1714add6efe48578da7ac9580a7c14dd4b562","name":"3960-04Jan25@2.json","type":"application/json","lastModified":1737306487875.152,"size":930911}] 31:{"id":"e311d10447033a7c","slug":"routeplan-hub-3960","title":"Route plan for Hub 3960 Knoxville - 5KM grouping","thumbnail":"c82c61f3776da934a1284e8d4baff86d69a7c12baaa3d0b06b57e924a6627d99","access_level":"public","create_time":"$D2024-12-19T19:35:36.585Z","update_time":"$D2025-01-20T08:37:06.573Z","view_time":null,"first_public_time":"$D2024-12-19T19:35:36.585Z","has_unpublished_edits":null,"fork":true,"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":1500,"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":5,"collection":null,"type":"notebook","body":{"title":"Route plan for Hub 3960 Knoxville - 5KM grouping","cells":[{"id":0,"value":"# Route plan for Hub ${hub} Knoxville - 5KM 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: \"section1\", label: \"31-Dec-2024\" },\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":1307,"value":"md`
${solutionFile31Dec[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1386,"value":"md`### ${daywiseData31Dec} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":461,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":585,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"viewof downloadZipButton = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = JSON.parse(JSON.stringify(solutionFile31Dec));\n const zipBlob = await createdFiles31Dec; // 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":156,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1005,"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":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":988,"value":"$38","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":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1095,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1098,"value":"$3b","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":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1210,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1213,"value":"$3e","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":"$3f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1228,"value":"$40","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1231,"value":"$41","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":"$42","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1246,"value":"$43","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1249,"value":"$44","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":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1264,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1267,"value":"$47","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":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1282,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1285,"value":"$4a","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":"$4b","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(\"3960-31Dec24.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":973,"value":"solutionFile01Jan = await FileAttachment(\"3960-01Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1125,"value":"solutionFile02Jan = await FileAttachment(\"3960-02Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1127,"value":"solutionFile03Jan = await FileAttachment(\"3960-03Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1129,"value":"solutionFile04Jan = await FileAttachment(\"3960-04Jan25@2.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1131,"value":"solutionFile05Jan = await FileAttachment(\"3960-05Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1133,"value":"solutionFile06Jan = await FileAttachment(\"3960-06Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1135,"value":"solutionFile07Jan = await FileAttachment(\"3960-07Jan25.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 = 3960","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":"$W4c","stdlib":"1","titling":"auto"}} 32:"$31:body"