31: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 }); }32: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 }); }33: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`; } }34: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 }); }35: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 }); }36: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`; } }37: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 }); }38: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 }); }39: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`; } }3a: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 }); }3b: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 }); }3c: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`; } }3d: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 }); }3e: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 }); }3f: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`; } }40: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 }); }41: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 }); }42: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`; } }43: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 }); }44: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 }); }45: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`; } }46: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 }); }47: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 }); }48: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`; } }49:Te7f,styling = html` `4a:[{"id":"eb3b76ecd113d5765c4b5e9e1573358172bbe464e76ab981cfcc80f771ff9b2aa809717e5bfc01a5c5aaddba6bac0287be956e1a483664c0eef618602f9217a0","href":"https://static.observableusercontent.com/files/eb3b76ecd113d5765c4b5e9e1573358172bbe464e76ab981cfcc80f771ff9b2aa809717e5bfc01a5c5aaddba6bac0287be956e1a483664c0eef618602f9217a0","name":"3308-31Dec24.json","type":"application/json","lastModified":1737394369525.579,"size":568970},{"id":"d2d5d71c3c293c3ec5c37d679ef74eb5aaee91b2f5177ca4a875b697c738730b4b411f4a4c51bdd96194ed6d4a96c8ecbdb896af68acc77b281d58023e761adf","href":"https://static.observableusercontent.com/files/d2d5d71c3c293c3ec5c37d679ef74eb5aaee91b2f5177ca4a875b697c738730b4b411f4a4c51bdd96194ed6d4a96c8ecbdb896af68acc77b281d58023e761adf","name":"3308-01Jan25.json","type":"application/json","lastModified":1737394390198.799,"size":655182},{"id":"6bf0481b9d285ccce08bbe5077081915c4fbf1f3401b718f252bf65b30a13f55a5bee42cf477f8901cf51d45e053b85c9fb13a9d391793d3a13278bcbff31c1d","href":"https://static.observableusercontent.com/files/6bf0481b9d285ccce08bbe5077081915c4fbf1f3401b718f252bf65b30a13f55a5bee42cf477f8901cf51d45e053b85c9fb13a9d391793d3a13278bcbff31c1d","name":"3308-02Jan25.json","type":"application/json","lastModified":1737394417410.265,"size":1000349},{"id":"9852a03ebeaf17af758902b76679043c49151ae45c26ab88fd5c50c2dcae949e328182223a7ef93e8126bda02ff98d1116a975741a17beceac06524ee2be97b3","href":"https://static.observableusercontent.com/files/9852a03ebeaf17af758902b76679043c49151ae45c26ab88fd5c50c2dcae949e328182223a7ef93e8126bda02ff98d1116a975741a17beceac06524ee2be97b3","name":"3308-03Jan25.json","type":"application/json","lastModified":1737394439952.393,"size":1004768},{"id":"acf7a09ce10b79075a883221cb5b5541f92d6b04b2044150c9583c9b2e8b427190271c5e49d45dda0eb71a2d80d0d6b5d364adfbec7a14bc1c24e6e697a0641e","href":"https://static.observableusercontent.com/files/acf7a09ce10b79075a883221cb5b5541f92d6b04b2044150c9583c9b2e8b427190271c5e49d45dda0eb71a2d80d0d6b5d364adfbec7a14bc1c24e6e697a0641e","name":"3308-04Jan25.json","type":"application/json","lastModified":1737394458825.694,"size":897942},{"id":"858ba5c381d879cdbef97cd75a04c27474b82601df09c9fa0f41bb9a6f3e59ec560847a7707d47660bdb857447ab5cc2bae18135e13d28f31669315e5592e0e5","href":"https://static.observableusercontent.com/files/858ba5c381d879cdbef97cd75a04c27474b82601df09c9fa0f41bb9a6f3e59ec560847a7707d47660bdb857447ab5cc2bae18135e13d28f31669315e5592e0e5","name":"3308-05Jan25.json","type":"application/json","lastModified":1737394476586.96,"size":768727},{"id":"be0780eda64d7d1359f5f5aed90af08310a4ffae4961ca9845ca5b04a38d718bba5fa12e713b77146b990df79031cc70d85bd8e578af94f5f38a537f12864bb7","href":"https://static.observableusercontent.com/files/be0780eda64d7d1359f5f5aed90af08310a4ffae4961ca9845ca5b04a38d718bba5fa12e713b77146b990df79031cc70d85bd8e578af94f5f38a537f12864bb7","name":"3308-06Jan25.json","type":"application/json","lastModified":1737394492423.6,"size":709471},{"id":"92a6fe3e04f22752eb7dc24f8ee260addc984ae3b9c5e5818eb292991c667e5eccd092e9980946bffcc0f87347cc4461ae270b91c3adfb321360324f2c1bedb2","href":"https://static.observableusercontent.com/files/92a6fe3e04f22752eb7dc24f8ee260addc984ae3b9c5e5818eb292991c667e5eccd092e9980946bffcc0f87347cc4461ae270b91c3adfb321360324f2c1bedb2","name":"3308-07Jan25.json","type":"application/json","lastModified":1737394507146.296,"size":699761}] 2f:{"title":"Route plan for Hub 3308 Rawleigh - 5KM grouping","cells":[{"id":0,"value":"# Route plan for Hub 3308 Rawleigh - 5KM grouping","pinned":false,"hidden":false,"mode":"md"},{"id":353,"value":"----","pinned":false,"hidden":false,"mode":"md"},{"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 }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1307,"value":"md`
31/12/2024
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1386,"value":"md`### ${daywiseData31Dec} `","pinned":false,"hidden":false,"mode":"ojs"},{"id":461,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":469,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":585,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":156,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1005,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1313,"value":"md`
01/01/2025
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1411,"value":"md`### ${daywiseData01Jan} `","pinned":false,"hidden":false,"mode":"ojs"},{"id":984,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":986,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":988,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1023,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1317,"value":"md`
02/01/2025
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1415,"value":"md`### ${daywiseData02Jan} `","pinned":false,"hidden":false,"mode":"ojs"},{"id":1092,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":1095,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":1098,"value":"$39","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1104,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1423,"value":"md`
${solutionFile03Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1419,"value":"md`### ${daywiseData03Jan} `","pinned":false,"hidden":false,"mode":"ojs"},{"id":1207,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs"},{"id":1210,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs"},{"id":1213,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1219,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1427,"value":"md`
${solutionFile04Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1430,"value":"md`### ${daywiseData04Jan} `","pinned":false,"hidden":false,"mode":"ojs"},{"id":1225,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs"},{"id":1228,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs"},{"id":1231,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1237,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1449,"value":"md`
${solutionFile05Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1452,"value":"md`### ${daywiseData05Jan} `","pinned":false,"hidden":false,"mode":"ojs"},{"id":1243,"value":"$40","pinned":false,"hidden":false,"mode":"ojs"},{"id":1246,"value":"$41","pinned":false,"hidden":false,"mode":"ojs"},{"id":1249,"value":"$42","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1255,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1456,"value":"md`
${solutionFile06Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1459,"value":"md`### ${daywiseData06Jan} `","pinned":false,"hidden":false,"mode":"ojs"},{"id":1261,"value":"$43","pinned":false,"hidden":false,"mode":"ojs"},{"id":1264,"value":"$44","pinned":false,"hidden":false,"mode":"ojs"},{"id":1267,"value":"$45","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1273,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1463,"value":"md`
${solutionFile07Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1466,"value":"md`### ${daywiseData07Jan} `","pinned":false,"hidden":false,"mode":"ojs"},{"id":1279,"value":"$46","pinned":false,"hidden":false,"mode":"ojs"},{"id":1282,"value":"$47","pinned":false,"hidden":false,"mode":"ojs"},{"id":1285,"value":"$48","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1291,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"id":84,"value":"$49","pinned":false,"hidden":false,"mode":"ojs"},{"id":541,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":610,"value":"import { zip, zipreader } from \"@fil/jszip\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":820,"value":"vis = require(\"vis-timeline@latest/standalone/umd/vis-timeline-graph2d.min.js\")","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"id":956,"value":"solutionFile31Dec = await FileAttachment(\"3308-31Dec24.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":973,"value":"solutionFile01Jan = await FileAttachment(\"3308-01Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1125,"value":"solutionFile02Jan = await FileAttachment(\"3308-02Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1127,"value":"solutionFile03Jan = await FileAttachment(\"3308-03Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1129,"value":"solutionFile04Jan = await FileAttachment(\"3308-04Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1131,"value":"solutionFile05Jan = await FileAttachment(\"3308-05Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1133,"value":"solutionFile06Jan = await FileAttachment(\"3308-06Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1135,"value":"solutionFile07Jan = await FileAttachment(\"3308-07Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"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"},{"id":1372,"value":"hub = 3308","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":1303,"value":"import { Inputs } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W4a","stdlib":"1","titling":"auto"}