3e:null 3f:["$","title",null,{"children":"Route plan for Hub 3888 Mesquite - 5KM grouping | NB.AI Solutions Team | Observable"}] 45: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 }); }46: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 }); }47: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`; } }48: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 }); }49: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 }); }4a: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`; } }4b: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 }); }4c: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 }); }4d: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`; } }4e: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 }); }4f: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 }); }50: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`; } }51: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 }); }52: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 }); }53: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`; } }54: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 }); }55: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 }); }56: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`; } }57: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 }); }58: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 }); }59: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`; } }5a: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 }); }5b: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 }); }5c: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`; } }5d:Te7f,styling = html` `5e:[{"id":"f27c4ca88a908ce5d139aa23d43bb9eea132862fd323bc7eeab777320cd7aade7675c0339265cedc4ee2239c682ceddb4b1e749c0db97de5672daf93fc2b73ec","href":"https://static.observableusercontent.com/files/f27c4ca88a908ce5d139aa23d43bb9eea132862fd323bc7eeab777320cd7aade7675c0339265cedc4ee2239c682ceddb4b1e749c0db97de5672daf93fc2b73ec","name":"3888-31Dec24.json","type":"application/json","lastModified":1737308034009.98,"size":764317},{"id":"f9cf65028fe2e9009418888e1d2bbfe89c3a3956d7400f64ef65e0f522c6b5d3d94622e8d2596b827e4bcbcfa3cf5ff61dc563b843c12cd01186827144a8a6b1","href":"https://static.observableusercontent.com/files/f9cf65028fe2e9009418888e1d2bbfe89c3a3956d7400f64ef65e0f522c6b5d3d94622e8d2596b827e4bcbcfa3cf5ff61dc563b843c12cd01186827144a8a6b1","name":"3888-01Jan25.json","type":"application/json","lastModified":1737308047685.057,"size":597257},{"id":"03d54221ee02ef63a9f937d0f4163199251ff9c668ce3b1a87194b5c2a0b8a0d3ae59733664ae0c8786d7e00770c6f3da69933b069b3559d382895dac5c3cf1d","href":"https://static.observableusercontent.com/files/03d54221ee02ef63a9f937d0f4163199251ff9c668ce3b1a87194b5c2a0b8a0d3ae59733664ae0c8786d7e00770c6f3da69933b069b3559d382895dac5c3cf1d","name":"3888-02Jan25.json","type":"application/json","lastModified":1737308062592.926,"size":795489},{"id":"0da9f94dc5ab61e206af5d698631e8dcde02f3c49c6caf6a0791667f8793fbdb1c924e52e385f3fa542fd71631db18fc4959810eb61660189b16a404f79f5342","href":"https://static.observableusercontent.com/files/0da9f94dc5ab61e206af5d698631e8dcde02f3c49c6caf6a0791667f8793fbdb1c924e52e385f3fa542fd71631db18fc4959810eb61660189b16a404f79f5342","name":"3888-03Jan25.json","type":"application/json","lastModified":1737308073548.805,"size":760098},{"id":"fbf98eef15bf417ec11dcf5ebc0ef3f30da44c63f968a3aa56e8b8c0b8623ae5b82370134f8e1b642b9b9152321b93f9bff39c85f3d93e0463fbe739c3aa8147","href":"https://static.observableusercontent.com/files/fbf98eef15bf417ec11dcf5ebc0ef3f30da44c63f968a3aa56e8b8c0b8623ae5b82370134f8e1b642b9b9152321b93f9bff39c85f3d93e0463fbe739c3aa8147","name":"3888-04Jan25.json","type":"application/json","lastModified":1737308085364.14,"size":820261},{"id":"9b95698fdbb4e906951ee3b93312f64bcecde2541f63d660d643ddd9885800d0652a89fd1483ca810a820d6202cd4e1b3214f468a4ab96eb3afc7301d6a183a9","href":"https://static.observableusercontent.com/files/9b95698fdbb4e906951ee3b93312f64bcecde2541f63d660d643ddd9885800d0652a89fd1483ca810a820d6202cd4e1b3214f468a4ab96eb3afc7301d6a183a9","name":"3888-05Jan25.json","type":"application/json","lastModified":1737308101970.462,"size":699631},{"id":"1e3149e6eef813d43584895c9c3fcc74646bf45a753abce7f0908c9b2ff1f66584f527da3789f214ef510e5d2fdb1d973e5d10582e95570f9c00cba10d4b5107","href":"https://static.observableusercontent.com/files/1e3149e6eef813d43584895c9c3fcc74646bf45a753abce7f0908c9b2ff1f66584f527da3789f214ef510e5d2fdb1d973e5d10582e95570f9c00cba10d4b5107","name":"3888-06Jan25.json","type":"application/json","lastModified":1737308115237.616,"size":824301},{"id":"e6a124b0a0859de4afd12b019a7cc45a97cf7fadd3aba898633776655c1cc97eb827530e41bb631bb21e2dc7229d80c50e630326c80e6ccbcf270576e21dbd48","href":"https://static.observableusercontent.com/files/e6a124b0a0859de4afd12b019a7cc45a97cf7fadd3aba898633776655c1cc97eb827530e41bb631bb21e2dc7229d80c50e630326c80e6ccbcf270576e21dbd48","name":"3888-07Jan25.json","type":"application/json","lastModified":1737308127172.288,"size":714085}] 43:{"id":"2223957e0dec03bb","slug":"routeplan-hub-3888","title":"Route plan for Hub 3888 Mesquite - 5KM grouping","thumbnail":"ccd4297994acda8da4fa0798970856bbc59fde074044a4f36abacdeb3f93a63c","access_level":"public","create_time":"$D2025-01-19T17:30:22.477Z","update_time":"$D2025-01-20T08:37:55.727Z","view_time":null,"first_public_time":"$D2025-01-19T17:31:19.722Z","has_unpublished_edits":null,"fork":{"id":"e311d10447033a7c","slug":"routeplan-hub-3960","title":"Route plan for Hub 3960 Knoxville - 5KM grouping","owner":{"id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team"}},"stars":0,"starred":false,"owner":{"type":"team","id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team","avatar_url":"https://avatars-next.observableusercontent.com/7a25d1b5deb9c5290b12e4e0914aacdbd4196bb5c3a94c63a0fda0fe706d28b2","tier":"starter_2024","bio":""},"version":1500,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7c6aa4c7c386f728","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":null,"bio":""}],"members":[{"type":"team","id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team","avatar_url":"https://avatars-next.observableusercontent.com/7a25d1b5deb9c5290b12e4e0914aacdbd4196bb5c3a94c63a0fda0fe706d28b2","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Route plan for Hub 3888 Mesquite - 5KM grouping","cells":[{"id":0,"value":"# Route plan for Hub 3888 Mesquite - 5KM grouping","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":353,"value":"----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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 }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1307,"value":"md`
${solutionFile31Dec[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1386,"value":"md`### ${daywiseData31Dec} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":461,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":585,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1005,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1313,"value":"md`
${solutionFile01Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1411,"value":"md`### ${daywiseData01Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":984,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":988,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1023,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1317,"value":"md`
${solutionFile02Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1415,"value":"md`### ${daywiseData02Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1092,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1095,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1098,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1104,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1423,"value":"md`
${solutionFile03Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1419,"value":"md`### ${daywiseData03Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1207,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1210,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1213,"value":"$50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1219,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1427,"value":"md`
${solutionFile04Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1430,"value":"md`### ${daywiseData04Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1225,"value":"$51","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1228,"value":"$52","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1231,"value":"$53","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1237,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1449,"value":"md`
${solutionFile05Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1452,"value":"md`### ${daywiseData05Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1243,"value":"$54","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1246,"value":"$55","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1249,"value":"$56","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1255,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1456,"value":"md`
${solutionFile06Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1459,"value":"md`### ${daywiseData06Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1261,"value":"$57","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1264,"value":"$58","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1267,"value":"$59","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1273,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1463,"value":"md`
${solutionFile07Jan[0].kpis.planDate}
`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1466,"value":"md`### ${daywiseData07Jan} `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1279,"value":"$5a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1282,"value":"$5b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1285,"value":"$5c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1291,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"$5d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":610,"value":"import { zip, zipreader } from \"@fil/jszip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":956,"value":"solutionFile31Dec = await FileAttachment(\"3888-31Dec24.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":973,"value":"solutionFile01Jan = await FileAttachment(\"3888-01Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1125,"value":"solutionFile02Jan = await FileAttachment(\"3888-02Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1127,"value":"solutionFile03Jan = await FileAttachment(\"3888-03Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1129,"value":"solutionFile04Jan = await FileAttachment(\"3888-04Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1131,"value":"solutionFile05Jan = await FileAttachment(\"3888-05Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1133,"value":"solutionFile06Jan = await FileAttachment(\"3888-06Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1135,"value":"solutionFile07Jan = await FileAttachment(\"3888-07Jan25.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1372,"value":"hub = 3888","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1303,"value":"import { Inputs } from \"@observablehq/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W5e","stdlib":"1"}} 44:"$43:body"