35:null 36:["$","title",null,{"children":"VISUALIZING THE KATOWICE TRIP BLOCKING WITH GANTT CHARTS - version of 07/09/2026 | Datavisualization | Observable"}] 3c:T5af,summaryStats_shift = { const blockInfo = new Map(); // block -> { vehicleType, start, end, tripCount } let deadheadCount = 0; for (const d of tasks_shift) { const start = new Date(d.startDate); const end = new Date(d.endDate); if (!blockInfo.has(d.block)) { blockInfo.set(d.block, { vehicleType: d.vehicleType, start, end, tripCount: 0 }); } const info = blockInfo.get(d.block); if (start < info.start) info.start = start; if (end > info.end) info.end = end; if (d.isDeadhead) { deadheadCount++; } else { info.tripCount++; } } const blocks = Array.from(blockInfo.values()); const typeCounts = new Map(); for (const b of blocks) { typeCounts.set(b.vehicleType, (typeCounts.get(b.vehicleType) ?? 0) + 1); } const durationsMin = blocks.map(b => (b.end - b.start) / 60000); const tripCounts = blocks.map(b => b.tripCount); return { totalBlocks: blocks.length, totalTrips: d3.sum(tripCounts), totalDeadheads: deadheadCount, typeCounts: Object.fromEntries(typeCounts), tripsPerBlock: { min: d3.min(tripCounts), avg: d3.mean(tripCounts), max: d3.max(tripCounts) }, durationMinutes: { min: d3.min(durationsMin), avg: d3.mean(durationsMin), max: d3.max(durationsMin) }, scheduleStart: d3.min(blocks, b => b.start), scheduleEnd: d3.max(blocks, b => b.end) } }3d:T5b3,summaryStats_noshift = { const blockInfo = new Map(); // block -> { vehicleType, start, end, tripCount } let deadheadCount = 0; for (const d of tasks_noshift) { const start = new Date(d.startDate); const end = new Date(d.endDate); if (!blockInfo.has(d.block)) { blockInfo.set(d.block, { vehicleType: d.vehicleType, start, end, tripCount: 0 }); } const info = blockInfo.get(d.block); if (start < info.start) info.start = start; if (end > info.end) info.end = end; if (d.isDeadhead) { deadheadCount++; } else { info.tripCount++; } } const blocks = Array.from(blockInfo.values()); const typeCounts = new Map(); for (const b of blocks) { typeCounts.set(b.vehicleType, (typeCounts.get(b.vehicleType) ?? 0) + 1); } const durationsMin = blocks.map(b => (b.end - b.start) / 60000); const tripCounts = blocks.map(b => b.tripCount); return { totalBlocks: blocks.length, totalTrips: d3.sum(tripCounts), totalDeadheads: deadheadCount, typeCounts: Object.fromEntries(typeCounts), tripsPerBlock: { min: d3.min(tripCounts), avg: d3.mean(tripCounts), max: d3.max(tripCounts) }, durationMinutes: { min: d3.min(durationsMin), avg: d3.mean(durationsMin), max: d3.max(durationsMin) }, scheduleStart: d3.min(blocks, b => b.start), scheduleEnd: d3.max(blocks, b => b.end) } }3e:[{"id":"7359db0e88028d84ad408cd1ebd64066864dea522258cd4ff3b05d719a2ea76de874bbe147145c3184f580c165bf8892a7fe419802d9c79b1b5c68cf31bc8f83","href":"https://static.observableusercontent.com/files/7359db0e88028d84ad408cd1ebd64066864dea522258cd4ff3b05d719a2ea76de874bbe147145c3184f580c165bf8892a7fe419802d9c79b1b5c68cf31bc8f83","name":"gantt_data.json","type":"application/json","lastModified":1788808787938,"size":1429157},{"id":"71ff23d183854d52548cb4fe2a93130632fbeb333db89c070217f71b1ffc8a7e6d2c0b2b0d8847f1126b92044987ec5fa2b72ea38b84362e4f23922ae1c5339b","href":"https://static.observableusercontent.com/files/71ff23d183854d52548cb4fe2a93130632fbeb333db89c070217f71b1ffc8a7e6d2c0b2b0d8847f1126b92044987ec5fa2b72ea38b84362e4f23922ae1c5339b","name":"gantt_data_noshift.json","type":"application/json","lastModified":1788813272638,"size":1354710}] 3a:{"id":"45856a5b1dc06abd","slug":"visualizing-the-katowice-trip-blocking-with-gantt-charts-version-of-07-09-2026","title":"VISUALIZING THE KATOWICE TRIP BLOCKING WITH GANTT CHARTS - version of 07/09/2026","thumbnail":"9dd45e0b892e92072993ff4ca4aa146c6dd502326dd13b5d401240382f0b8688","access_level":"public","create_time":"$D2026-09-07T20:46:09.651Z","update_time":"$D2026-09-08T12:14:49.674Z","view_time":null,"first_public_time":"$D2026-09-07T20:47:22.609Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"3cbf7c3320748005","login":"datavisualization26","name":"Datavisualization","avatar_url":"https://avatars-next.observableusercontent.com/1206df67436d7d10fa26c2dac38c9781d077427867290a8297710629d3202599","tier":"starter_2024","bio":"","following":false},"version":87,"publish_version":87,"role":null,"authored":false,"authors":[{"type":"individual","id":"40c22961d6b8a229","login":"emilie5","name":"Emilie","avatar_url":"https://avatars-next.observableusercontent.com/168b2fe0d1ce44fc2f440d70b28267eff0beb9b9d74cf31aa100c4f4ec61c14c","tier":null,"bio":"","following":false}],"members":[{"type":"team","id":"3cbf7c3320748005","login":"datavisualization26","name":"Datavisualization","avatar_url":"https://avatars-next.observableusercontent.com/1206df67436d7d10fa26c2dac38c9781d077427867290a8297710629d3202599","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"VISUALIZING THE KATOWICE TRIP BLOCKING WITH GANTT CHARTS - version of 07/09/2026","cells":[{"id":1,"value":"# VISUALIZING THE KATOWICE TRIP BLOCKING WITH GANTT CHARTS - version of 07/09/2026","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"## Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"tasks_shift = FileAttachment(\"gantt_data.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"tasks_noshift = FileAttachment(\"gantt_data_noshift.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"function categorize(d) {\n if (d.isDeadhead) return \"Deadhead\";\n if (d.vehicleType === \"ELECTRIC\") return \"Electric\";\n if (d.vehicleType === \"CONVENTIONAL\") return \"Conventional\"; // fallback for any other/unknown vehicleType\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"colorScale = ({\n domain: [\"Deadhead\", \"Electric\", \"Conventional\"],\n range: [\"red\", \"blue\", \"gold\"],\n legend: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"blockOrder = Array.from(new Set(tasks_shift.map(d => d.block)))\n .sort((a, b) => {\n const na = parseInt(a.match(/\\d+/)?.[0] ?? 0, 10);\n const nb = parseInt(b.match(/\\d+/)?.[0] ?? 0, 10);\n return na - nb;\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"# Summarize","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"## Visualization","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"## With shift","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"html`

${summaryStats_shift.totalBlocks} blocks

${summaryStats_shift.totalTrips} trips

${summaryStats_shift.totalDeadheads} deadheads

Trips/block: min ${summaryStats_shift.tripsPerBlock.min} · avg ${summaryStats_shift.tripsPerBlock.avg.toFixed(1)} · max ${summaryStats_shift.tripsPerBlock.max}

Block duration (min): min ${summaryStats_shift.durationMinutes.min.toFixed(0)} · avg ${summaryStats_shift.durationMinutes.avg.toFixed(0)} · max ${summaryStats_shift.durationMinutes.max.toFixed(0)}

Blocks by type: ${Object.entries(summaryStats_shift.typeCounts).map(([k, v]) => `${k}: ${v}`).join(\" · \")}

Schedule window: ${summaryStats_shift.scheduleStart.toLocaleTimeString()} – ${summaryStats_shift.scheduleEnd.toLocaleTimeString()}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"Plot.plot({\n width: 1100,\n height: blockOrder.length * 14 + 60,\n marginLeft: 90,\n x: {\n type: \"utc\",\n label: \"Time\"\n },\n y: {\n domain: blockOrder,\n label: \"Block\"\n },\n color: colorScale,\n marks: [\n Plot.barX(tasks_shift, {\n x1: d => new Date(d.startDate),\n x2: d => new Date(d.endDate),\n y: \"block\",\n fill: d => categorize(d),\n title: d => `${d.trip}\\n${d.description}`,\n tip: true\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"## Without shift","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"html`

${summaryStats_noshift.totalBlocks} blocks

${summaryStats_noshift.totalTrips} trips

${summaryStats_noshift.totalDeadheads} deadheads

Trips/block: min ${summaryStats_noshift.tripsPerBlock.min} · avg ${summaryStats_noshift.tripsPerBlock.avg.toFixed(1)} · max ${summaryStats_noshift.tripsPerBlock.max}

Block duration (min): min ${summaryStats_noshift.durationMinutes.min.toFixed(0)} · avg ${summaryStats_noshift.durationMinutes.avg.toFixed(0)} · max ${summaryStats_noshift.durationMinutes.max.toFixed(0)}

Blocks by type: ${Object.entries(summaryStats_noshift.typeCounts).map(([k, v]) => `${k}: ${v}`).join(\" · \")}

Schedule window: ${summaryStats_noshift.scheduleStart.toLocaleTimeString()} – ${summaryStats_noshift.scheduleEnd.toLocaleTimeString()}

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"Plot.plot({\n width: 1100,\n height: blockOrder.length * 14 + 60,\n marginLeft: 90,\n x: {\n type: \"utc\",\n label: \"Time\"\n },\n y: {\n domain: blockOrder,\n label: \"Block\"\n },\n color: colorScale,\n marks: [\n Plot.barX(tasks_noshift, {\n x1: d => new Date(d.startDate),\n x2: d => new Date(d.endDate),\n y: \"block\",\n fill: d => categorize(d),\n title: d => `${d.trip}\\n${d.description}`,\n tip: true\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3e","stdlib":"2"}} 3b:"$3a:body"