2e:null 2f:["$","title",null,{"children":"Sample Route Mesquite XDT 11/11/24 for Review - Option 1 | Prashanth Hiremath | Observable"}] 34:T745,kpiTable = { let kpis = []; let mvrpID = solutionFile; 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 / 2 }

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

${hours} HR ${minutes} MIN

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

${x}

`, startTime: (x) => html`

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

`, completionTime: (x) => html`

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

`, loadWeight: (x) => html`

${x} lbs

`, loadVolume: (x) => html`

${x} in³

`, totalItems: (x) => html`

${x}

`, totalStops: (x) => html`

${x}

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

${hours} HR ${minutes} MIN

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

${hours} HR ${minutes} MIN

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

${hours} HR ${minutes} MIN

`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }36:T8ec,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`

${x}

`, departure: (x) => html`

${x}

`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }37:T74e,kpiTable1 = { let kpis = []; let mvrpID = solutionFileMaxTasks; 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 / 2 }
`, totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }38:Tdbb,viewof routeStatsTable1 = { let routes = []; let mvrpID = solutionFileMaxTasks; mvrpID[0].result.routes.forEach((sol) => { const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let loadWeight = sol.delivery[0]; let loadVolume = sol.delivery[1]; let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; steps.forEach((s) => { if (s.type === "job") { totalItems += parseInt(s.description.split("|")[3]); totalStops++; } }); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, loadWeight: loadWeight, loadVolume: loadVolume, totalItems: totalItems, totalStops: totalStops, totalRouteTime: totalRouteTime }); }); yield Inputs.table(routes, { columns: [ "description", "startTime", "completionTime", "loadWeight", "loadVolume", "totalItems", "totalStops", "totalDelivery", "totalPickup", "totalRetrip", "totalRouteTime", "duration", "service" ], header: { description: "Depot-Vehicle", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time", totalDelivery: "Deliveries", totalPickup: "Pickups", totalRetrip: "Retrips" }, width: { description: 125, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { description: (x) => html`
${x}
`, startTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, completionTime: (x) => html`
${new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false })}
`, loadWeight: (x) => html`
${x} lbs
`, loadVolume: (x) => html`
${x} in³
`, totalItems: (x) => html`
${x}
`, totalStops: (x) => html`
${x}
`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return html`
${hours} HR ${minutes} MIN
`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }39:T8ef,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`
${x}
`, departure: (x) => html`
${x}
`, completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } else { yield html`Select a route above to view details`; } }3a:Te7f,styling = html` `3b:[{"id":"bbc652de72a615760a49b557f6ea3ac1ddb717188dfad0d2dafd9850a04a2c2215da352354cdc7d7f718e915763e8157e997a05ce4b24f09b4ec757f4a413a0e","href":"https://static.observableusercontent.com/files/bbc652de72a615760a49b557f6ea3ac1ddb717188dfad0d2dafd9850a04a2c2215da352354cdc7d7f718e915763e8157e997a05ce4b24f09b4ec757f4a413a0e","name":"clustered_no_max_tasks_3000m.json","type":"application/json","lastModified":1734608969981.961,"size":733727},{"id":"b206663bb0f46b6c2e5694f98e16f2a11ef5da2f9fe6f746478ff65480374cf6f68ebe63ae202e1e56507703fe7f41adeba0e5be6afc7ff73b581037159461d9","href":"https://static.observableusercontent.com/files/b206663bb0f46b6c2e5694f98e16f2a11ef5da2f9fe6f746478ff65480374cf6f68ebe63ae202e1e56507703fe7f41adeba0e5be6afc7ff73b581037159461d9","name":"clustered_max_tasks_3000m.json","type":"application/json","lastModified":1734608976542.014,"size":744108}] 32:{"id":"7f83138a29636176","slug":"sample-route-mesquite-xdt-11-11-24-for-review","title":"Sample Route Mesquite XDT 11/11/24 for Review - Option 1","thumbnail":"8af63f65dab1f2fdcf7623d7c2aaf5e95cbb2c8df3ed262650751dd1494d2410","access_level":"public","create_time":"$D2024-12-16T07:24:24.108Z","update_time":"$D2024-12-19T11:53:38.562Z","view_time":null,"first_public_time":"$D2024-12-16T07:32:19.271Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"dd0e5f46c5ca7028","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":"starter_2024"},"version":1077,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7c6aa4c7c386f728","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":null}],"members":[{"type":"individual","id":"7c6aa4c7c386f728","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":null,"role":"editor"},{"type":"team","id":"dd0e5f46c5ca7028","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Sample Route Mesquite XDT 11/11/24 for Review - Option 1","cells":[{"id":0,"value":"# Sample Route Mesquite XDT 11/11/24 for Review - Option 1","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":353,"value":"----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":378,"value":"md`### 11/11/24 XDT Mesquite 80 Trucks 360 Orders - No Max Tasks Constraint`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":461,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":585,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":651,"value":"viewof downloadZipButton = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = solutionFile;\n const zipBlob = await createdFiles; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1005,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":996,"value":"md`### 11/11/24 XDT Mesquite 80 Trucks 360 Orders - Max Tasks = 15`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":984,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":988,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1009,"value":"viewof downloadZipButton1 = Inputs.button(\n html``,\n {\n reduce: async () => {\n const mvrpData = solutionFileMaxTasks;\n const zipBlob = await createdFilesMaxTasks; // Get the ZIP Blob\n\n // Create a download link\n const link = document.createElement(\"a\");\n link.href = URL.createObjectURL(zipBlob);\n link.download = `routes_${mvrpData[0].description.split(\"|\")[1]}_${\n mvrpData[0].description.split(\"|\")[2]\n }.zip`;\n link.click();\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1023,"value":"html`\n \n \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"ncc_url = `console.nextbillion.ai/route-planner-viewer?id=${theroute[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1019,"value":"ncc_url_maxTasks = `console.nextbillion.ai/route-planner-viewer?id=${theroute_maxTasks[0].id}&host=api.nextbillion.io`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":610,"value":"import { zip, zipreader } from \"@fil/jszip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"value":"vis = require(\"vis-timeline@latest/standalone/umd/vis-timeline-graph2d.min.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":729,"value":"function transformRoutes(routes) {\n const currentLocaleDateTime = (x) =>\n new Date(x * 1000).toLocaleTimeString([], {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false\n });\n\n return routes.map((r) => ({\n description: r.description,\n startTime: currentLocaleDateTime(r.startTime),\n completionTime: currentLocaleDateTime(r.completionTime),\n duration: r.duration,\n distance: r.distance,\n loadWeight: r.loadWeight,\n loadVolume: r.loadVolume,\n totalItems: r.totalItems,\n totalDelivery: r.totalDelivery,\n totalPickup: r.totalPickup,\n totalRetrip: r.totalRetrip,\n totalStops: r.totalStops,\n totalRouteTime: r.totalRouteTime\n }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"function transformSteps(steps) {\n const currentLocaleDateTime = (x) =>\n new Date(x * 1000).toLocaleTimeString([], {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false\n });\n\n return steps.map((step) => ({\n sequence_nbr: step.sequence_nbr,\n type: step.description ? step.description.split(\"|\")[4] : step.type,\n arrival: currentLocaleDateTime(step.arrival),\n departure: currentLocaleDateTime(step.departure),\n order_id: step.order_id,\n delivery_id: step.delivery_id,\n address: step.address,\n distance: step.distance,\n duration: step.duration,\n service: step.service,\n waiting_time: step.waiting_time,\n appointment_window_breach: step.waiting_time==0 ? \"On-time\": \"Late\",\n weight: step.weight,\n volume: step.volume,\n location: `${step.location[0]},${step.location[1]}`,\n snapped_location: `${step.snapped_location[0]},${step.snapped_location[1]}`\n }));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":697,"value":"theroute = {\n const mvrpData = solutionFile;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1017,"value":"theroute_maxTasks = {\n const mvrpData = solutionFileMaxTasks;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData;\n return routes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"createdFiles = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = solutionFile;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1045,"value":"createdFilesMaxTasks = {\n const z = zip();\n\n // Load your JSON file (e.g., from a file attachment or API response)\n const mvrpData = solutionFileMaxTasks;\n // Assuming mvrpData.routes is an array of route objects\n const routes = mvrpData[0].result.routes;\n\n console.log(routes);\n routes.forEach((r) => {\n r.steps = transformSteps(r.steps);\n });\n // Create CSV files for each route\n routes.forEach((route, index) => {\n const csvContent = jsonToCSV(route.steps); // Convert steps to CSV\n z.file(`route_${route.vehicle}.csv`, csvContent); // Add to ZIP\n });\n\n // Create the route summary CSV file - single CSV\n const new_routes = transformRoutes(routes);\n const csvRoutes = jsonToCSV(new_routes);\n z.file(`routes_${mvrpData[0].description.split(\"|\")[2]}.csv`, csvRoutes);\n // Add the original solution JSON to the ZIP\n z.file(\"solution.json\", JSON.stringify(mvrpData, null, 2));\n\n // Generate the ZIP file as a Blob\n return z.generateAsync({ type: \"blob\" });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":655,"value":"function jsonToCSV(jsonArray) {\n if (!jsonArray || jsonArray.length === 0) {\n return \"\";\n }\n\n const keys = Object.keys(jsonArray[0]); // Extract headers from the first object\n const escapeValue = (value) => {\n if (typeof value === \"string\") {\n // Wrap in quotes if it contains commas, quotes, or line breaks\n if (value.includes(\",\") || value.includes('\"') || value.includes(\"\\n\")) {\n return `\"${value.replace(/\"/g, '\"\"')}\"`; // Escape quotes by doubling them\n }\n return value; // No special characters, return as is\n }\n return value ?? \"\"; // Handle null/undefined as empty string\n };\n\n const header = keys.join(\",\"); // Create the header row\n const rows = jsonArray.map((obj) =>\n keys.map((key) => escapeValue(obj[key])).join(\",\")\n ); // Escape values in each row\n\n return [header, ...rows].join(\"\\n\"); // Combine header and rows into the final CSV string\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":956,"value":"// solutionFile = await FileAttachment(\"mvrp_no_task_constraint.json\").json();\nsolutionFile = await FileAttachment(\"clustered_no_max_tasks_3000m.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":973,"value":"solutionFileMaxTasks = await FileAttachment(\n \"clustered_max_tasks_3000m.json\"\n).json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3b","stdlib":"1","titling":"auto"}} 33:"$32:body"