2d:null 2e:["$","title",null,{"children":"BIM Kursplanung | Gerald Illy | Observable"}] 33:T12ac,status_chart = { var height = width < 500 ? width : 300; // var width = 1000; var innerRadius = height / 4; var outerRadius = height / 2; var circleWidth = outerRadius - innerRadius; var cornerRadius = 5; var padAngle = (Math.PI * 2) / 180; var segments = { bildungskarenz: d3.arc()({ innerRadius: innerRadius, outerRadius: innerRadius + circleWidth / 4, startAngle: 0, endAngle: 2 * Math.PI }), bim: d3.arc()({ innerRadius: innerRadius + (circleWidth * 1) / 4, outerRadius: outerRadius, startAngle: 0, endAngle: (2 * Math.PI * wochenstunden_aller_kurse) / kurs_staistik.kurse }), soll: d3.arc()({ innerRadius: innerRadius, outerRadius: innerRadius + circleWidth / 4, startAngle: 0, endAngle: (2 * Math.PI * kurs_staistik.soll.kurse) / kurs_staistik.kurse }), ist: d3.arc()( // .cornerRadius(cornerRadius) // .padAngle(padAngle) { innerRadius: outerRadius - (circleWidth * 3) / 4, outerRadius: outerRadius, startAngle: 0, endAngle: (2 * Math.PI * kurs_staistik.ist.kurse) / kurs_staistik.kurse } ) }; // create svg var svg = d3.select(DOM.svg(width, height)); // draw arcs var arcs = svg .append("g") .style("stroke", "#FFF") .attr("transform", "translate(" + outerRadius + "," + height / 2 + ")"); arcs .append("path") .attr("d", segments.bildungskarenz) .style("fill", "#fd6d6d"); arcs.append("path").attr("d", segments.bim).style("fill", "#e0e0e0"); arcs.append("path").attr("d", segments.soll).style("fill", "#a746b4"); arcs.append("path").attr("d", segments.ist).style("fill", "#27dd54"); // draw legend var data = [ { name: "Bildungskarenz", color: "#fd6d6d", text: "Bildungskarenz: " + Math.round(kurs_staistik.kurse) + " (4h / 7 Tage * 365)" }, { name: "BIM Gesamt", color: "#e0e0e0", text: "BIM Gesamt: " + wochenstunden_aller_kurse }, { name: "Soll", color: "#a746b4", text: "Soll: " + Math.round(kurs_staistik.soll.kurse) }, { name: "Ist", color: "#27dd54", text: "Ist: " + Math.round(kurs_staistik.ist.kurse) } ]; var eye = svg .append("g") .attr("transform", "translate(" + outerRadius + "," + height / 2 + ")") .append("text") .attr("text-anchor", "middle") .attr("font-size", "2em") .attr("dy", "0.35em") .attr("font-weight", "bold") .text( Math.round((kurs_staistik.ist.kurse / kurs_staistik.kurse) * 100) + "%" ); var legend = svg.append("g").attr("class", "legend").attr("dy", "0.35em"); // Bildungskarenz legend .append("circle") .attr("transform", "translate(" + outerRadius * 2.2 + "," + 0 + ")") .attr("cx", -18) .attr("cy", 9) .attr("r", 8) .style("border-radius", "9px") .style("fill", data[0].color); legend .append("text") .attr("transform", "translate(" + outerRadius * 2.2 + "," + 0 + ")") .attr("text-anchor", "start") .attr("font-size", "1.1em") .attr("x", 0) .attr("y", 9) .attr("dy", "0.35em") .text((d) => data[0].text); // BIM Gesamt legend .append("circle") .attr("transform", "translate(" + outerRadius * 2.2 + "," + 30 + ")") .attr("cx", -18) .attr("cy", 9) .attr("r", 8) .style("border-radius", "9px") .style("fill", data[1].color); legend .append("text") .attr("transform", "translate(" + outerRadius * 2.2 + "," + 30 + ")") .attr("text-anchor", "start") .attr("font-size", "1.1em") .attr("x", 0) .attr("y", 9) .attr("dy", "0.35em") .text((d) => data[1].text); // Soll legend .append("circle") .attr("transform", "translate(" + outerRadius * 2.2 + "," + 60 + ")") .attr("cx", -18) .attr("cy", 9) .attr("r", 8) .style("border-radius", "9px") .style("fill", data[2].color); legend .append("text") .attr("transform", "translate(" + outerRadius * 2.2 + "," + 60 + ")") .attr("text-anchor", "start") .attr("font-size", "1.1em") .attr("x", 0) .attr("y", 9) .attr("dy", "0.35em") .text((d) => data[2].text); // Ist legend .append("circle") .attr("transform", "translate(" + outerRadius * 2.2 + "," + 90 + ")") .attr("cx", -18) .attr("cy", 9) .attr("r", 8) .style("border-radius", "9px") .style("fill", data[3].color); legend .append("text") .attr("transform", "translate(" + outerRadius * 2.2 + "," + 90 + ")") .attr("text-anchor", "start") .attr("font-size", "1.1em") .attr("x", 0) .attr("y", 9) .attr("dy", "0.35em") .text((d) => data[3].text); return svg.node(); }34:T4e6,kurs_staistik = { function myDate(d) { var date = new Date(d); return { date: date, dayOfYear: moment(date).dayOfYear(), year: moment(date).year() }; } function delta_days(start, end) { return end.year > start.year ? (end.year - start.year - 1) * 365 + (365 - start.dayOfYear) + end.dayOfYear : end.dayOfYear - start.dayOfYear; } var today = myDate(new Date()); var start = myDate(kurs.start); var end = myDate(kurs.end); var passed_days = delta_days(start, today); var passed_weeks = passed_days / 7; var overall_days = delta_days(start, end) + 1; var overall_weeks = overall_days / 7; var wochenstunden = { gesamt: overall_weeks * kurs.wochenstunden, kurse: overall_weeks * kurs.wochenstunden * kurs.kursanteil, selbststudium: overall_weeks * kurs.wochenstunden * kurs.selbststudium, soll: { gesamt: passed_weeks * kurs.wochenstunden, kurse: passed_weeks * kurs.wochenstunden * kurs.kursanteil, selbststudium: passed_weeks * kurs.wochenstunden * kurs.selbststudium }, ist: { gesamt: undefined, kurse: absolvierte_kurse_wochenstunden, selbststudium: undefined } }; return wochenstunden; }35:T506,function linkNodes(nodes) { // uniform node structure Object.values(nodes).forEach((node) => { node.next = "next" in node ? nodes[node.next] : undefined; node.prev = "prev" in node ? nodes[node.prev] : undefined; // replace node ids by node-reference if ("fork" in node && Array.isArray(node.fork)) { var list = {}; node.fork.forEach((node_id) => { list[node_id] = nodes[node_id]; }); node.fork = list; } else { node.fork = {}; } if ("merge" in node && Array.isArray(node.merge)) { var list = {}; node.merge.forEach((node_id) => { list[node_id] = nodes[node_id]; }); node.merge = list; } else { node.merge = {}; } }); // engage next <-> prev connections Object.values(nodes).forEach((node) => { if (node.next != undefined) { node.next.prev = node; } if (node.prev != undefined) { node.prev.next = node; } }); // engage fork <-> merge connections Object.values(nodes).forEach((node) => { // for each fork-connection Object.values(node.fork).forEach((fork) => { fork.merge[node.id] = node; }); Object.values(node.merge).forEach((merge) => { merge.fork[node.id] = node; }); }); return nodes; }36:T6b7,function order(index) { // add index.cells and index.lanes structure var lanes_oder = []; index.cells = {}; index.lanes = {}; var stack = { ...nodes }; while (Object.keys(stack).length) { // first node of lane var node_id = Object.keys(stack)[0]; delete stack[node_id]; var node = index.nodes[node_id]; var cell_id = getNextID(index.cells) var lane_id = getNextID(index.lanes) var cell_order = [cell_id]; var cell = { id: cell_id, node: node, order: cell_order }; var lane = { id: lane_id, order: lanes_oder, cells: {} }; lane.cells[cell.id] = cell; node.grid = getGrid(lane, cell); index.cells[cell_id] = cell; index.lanes[lane_id] = lane; // order of lanes ... so wie sie daher kommen ... todo lanes_oder.push(lane_id); // forward connection while (node.next) { node = node.next; delete stack[node.id]; cell_id = d3.max(Object.values(index.cells), (d) => d.id + 1); cell_order.push(cell_id); cell = { id: cell_id, node: node, order: cell_order }; index.cells[cell_id] = cell; node.grid = getGrid(lane, cell); lane.cells[cell.id] = cell; } // jump back to first node of lane node = index.nodes[node_id]; // backward connection while (node.prev) { node = node.prev; delete stack[node.id]; cell_id = d3.max(Object.values(index.cells), (d) => d.id + 1); cell_order.unshift(cell_id); cell = { id: cell_id, node: node, order: cell_order }; index.cells[cell_id] = cell; node.grid = getGrid(lane, cell); lane.cells[cell.id] = cell; } } return index; }37:T4c7,function nodes_alligne_vertical(index) { var change = true; var max_iterations = 1000; var iterations = max_iterations; while (change) { if (iterations) { iterations = iterations - 1; } else break; change = false; Object.values(index.lanes).forEach((lane) => { Object.values(lane.cells).forEach((cell) => { if (cell != undefined) { Object.values(cell.node.merge).forEach((prev) => { var idx = cell.node.grid.col(); while (prev.grid.col() >= idx) { change = true; if (idx == cell.order.length - 1) { cell.order.splice(idx, 0, null); } else if (cell.order[idx + 1] == null) { // remove cell ... todo cell.order.splice(idx + 1, 1); cell.order.splice(idx, 0, null); } else { cell.order.splice(idx, 0, null); } if (iterations) { iterations = iterations - 1; } else break; idx = cell.node.grid.col(); } }); } }); }); } log.node_alligne_iterations = max_iterations - iterations; return index; }38:T15bb,view_chart = { // define canvas let data = Object.values(index.nodes); var lane_order = Object.values(index.lanes)[0].order; const margin = { top: 30, right: 10, bottom: 10, left: 30 }; const height = margin.top + lane_order.length * 40; const canvas = { width: width - margin.right - margin.left, height: height - margin.top }; // svg const svg = d3 .create("svg") .attr("viewBox", [0, 0, width, height + margin.bottom]); // define axis scale const xS = 0; const xE = d3.max(Object.values(index.cells), (d) => d.order.length - 1); const Nx = xE - xS + 1; const yS = 0; const yE = lane_order.length - 1; const Ny = yE - yS + 1; // x axis const x = d3 .scaleLinear() .domain([xS - 1 / 2, xE + 1 / 2]) .nice() .rangeRound([margin.left, width - margin.right]); var xAxis = (g, x) => g .attr("transform", `translate(0,${margin.top})`) .call(d3.axisTop(x).ticks(Nx).tickSizeOuter(0)); var gx = svg.append("g").call(xAxis, x); gx.select(".domain").remove(); // y axis const y = d3 .scaleBand() .domain(Object.values(index.lanes).map((d) => d.id)) .rangeRound([margin.top, height]); var yAxis = (g, y) => g .attr("transform", `translate(${margin.left - 5},0)`) .call(d3.axisLeft(y).tickSizeOuter(0).tickSize(-width)); const gy = svg.append("g").call(yAxis, y); gy.selectAll(".tick line") .style("stroke-dasharray", "10,5") .style("opacity", 0.2); gy.select(".domain").remove(); gy.selectAll(".tick text") .attr("font-size", "20") .style("font-family", "Comic Sans MS") .style("font-weight", "bold"); function cell_transition(d, xnew, ynew) { // if cell size should also be zoomed // -> needs to adatpt also zoomed(event) let dx = xnew(d.grid.col()) - (xnew(1) - xnew(0)) / 4; let dy = ynew(d.grid.row()) + ynew.bandwidth() / 4; // else (if node size should not bee zoomed) // let dx = xnew(d.grid.col()) - (x(1) - x(0)) / 4; // let dy = ynew(d.grid.row()) + y.bandwidth() / 4; return `translate(${dx},${dy})`; } // draw // add a group element for each cell let cell = svg .append("g") .style("filter", "drop-shadow(0 1px 2px rgba(0,0,0,.5))") .selectAll(".cell") .data(Object.values(index.nodes)) .enter() .append("g") .attr("class", "cell") .attr("transform", (d) => cell_transition(d, x, y)) .on("mouseover", showDependencies) .on("mouseout", reset); // .on("click", reset); // draw cell shape cell .append("rect") .attr("id", (d) => "rect_" + d.id + "_end") .attr("fill", (d) => d.state ? style.node.fill.state_done : style.node.fill.default ) .style("opacity", (d) => { if (selected_tool == "") return style.node.opacity.default; if (d.tools.find((tool) => tool == selected_tool)) { return style.node.opacity.default; } else return style.node.opacity.background; }) .style("stroke", (d) => d.isAvailable() ? style.node.stroke.color.isAvailable : style.node.stroke.color.default ) .style("stroke-width", style.node.stroke.width) .style("mix-blend-mode", "multiply") .attr("rx", 10) .attr("width", (d) => (x(1) - x(0)) / 2) .attr("height", y.bandwidth() / 2) .append("title") .text((d) => `${d.id} : ${d.name}`); // draw cell text cell .append("text") .lower() .style("fill", style.node.text.color) .style("text-anchor", "middle") .style("font-family", "Comic Sans MS") .style("font-weight", "bold") .attr("x", (x(1) - x(0)) / 4) .attr("y", y.bandwidth() / 4) .attr("dy", "0.35em") .text((d) => d.id); // draw link svg .append("g") .lower() .selectAll("path") .data(compute_links(data, x, y)) .enter() .append("path") .attr("id", (d) => d.id) .attr("d", d3.linkHorizontal()) .attr("stroke", style.path.color) .attr("stroke-opacity", style.path.opacity) .attr("stroke-width", style.path.width) .attr("fill", "none"); function reset(d) { d3.selectAll("rect") .attr("fill", (d) => d.state ? style.node.fill.state_done : style.node.fill.default ) .style("opacity", (d) => { if (selected_tool == "") return style.node.opacity.default; if (d.tools.find((tool) => tool == selected_tool)) { return style.node.opacity.default; } else return style.node.opacity.background; }); d3.selectAll("path") .attr("stroke", style.path.color) .attr("stroke-opacity", style.path.opacity); } function showDependencies(e) { var data = this.__data__; var trace = Object.values(data.inheritance()); trace.push(data); // highlight nodes trace.forEach((node) => { d3.select("#rect_" + node.id + "_end").attr( "fill", style.node.fill.highlight ); }); // highlight paths trace.forEach((node) => { var next = node.next ? trace.find((d) => { return d.id == node.next.id; }) : undefined; var fork = node.fork ? trace.find((d) => Object.values(node.fork).find((fork) => d.id == fork.id) ) : undefined; var id = next ? next.id : fork ? fork.id : undefined; if (id) { d3.select("#path_" + node.id + "_" + id + "_end") .attr("stroke", style.node.fill.highlight) .attr("stroke-opacity", 1) .raise(); } }); } return svg.node(); }39:T5b1,function reorder_lanes(index) { var order = Object.values(index.lanes)[0].order; var N = d3.max(Object.values(index.cells), (d) => d.order.length - 1); for (var col = N; col >= 0; col--) { // get all nodes which are in the selected column var nodes_by_col = Object.values(index.nodes).filter( (node) => node.grid.col() == col ); // sort nodes order by the number of next and fork connections var sorted = nodes_by_col.sort((a, b) => { var Na = countConnections(a); var Nb = countConnections(b); return Nb - Na; }); // reorder lanes // -> move the selected lanes to the top, in the computed order // use of splice // arr.splice(1, 1, "a") ... replaces position arr[1] with "a" // arr.splice(1, 1) ... replaces position arr[1] with nothig = removes entry from array // arr.splice(1, 0) ... does nothing // arr.splice(1, 0,"a") ... inserts "a" at the position arr[1] and shifts the following elements to higher index i+1 var line_nr = 0; sorted.forEach((node) => { if (countConnections(node) >= 1) { // get line id form node grid var line_id = node.grid.lane.id; // remove line var line_idx = order.indexOf(line_id); order.splice(line_idx, 1); // insert line on top below the other modified lines order.splice(line_nr, 0, line_id); line_nr = line_nr + 1; } }); } return order; }3a:T722,## Verbesserungen: - Kurse die oft vorkomme in der liste ganz oben und in klamma die anzahl der kurse in denen sie vorkommen. - ✅Die Spuren mit den wenigsten^/meisten Verbindungen nach oben schieben. sodass spuren mit nur einem knoten ganz oben sind und lange spuren mit vielen verzweigungen und knoten ganz unten sind. Vorgehen spalte fürnspalte und nur für jene spuren die einen knoten in der spalte haben. - ✅Backlog mit Kursen die man schon machen kann anzeigen - ⚡Kurse aus dem Backlog aus der Grafik entfernen, außer sie sind noch für einen anderen Kurs notwendig (optional) - ✅Verbindungen die sich aus semantischen Beschreibungen (Grundlagen > Erweitert) auf einer Bahn zusammenführen (next <> prev) - 🚩zoom & pan aktivieren - ✅Vererben von Abhängigkeiten (bspw. muss 7 nicht mehr von 2 abhängig sein, da 4 bereits von 2 abhängt und 4 kann diese bereits von 3 erben ...) - ✅Zeilen Sortieren, sodass die verbindungen so kurz wie möglich sind (die kruse mit den meisten verzweigungen einheitlich nach unten oder oben sortieren) - ✅Linien ändern, sie sollen immer direkt auf die ebene des nachfolgerknotens gehen und dann horizontal weiter. Überlappungen der Linien vermeiden! - ✅hervorheben aller verbindungen wenn ein Knoten berührt wird - ✅flag einbauen zum markieren bereits absolvierter kurse und hervorheben aller dadurch freigeschalteten kurse - ✅knoten die nur einen prev und der prev nur einen next haben auf einer bahn zeichnen - ⚡Knoten schöner darstellen (zB mit Symbol und Kursbezeichnung) - ⚡Beschreibung zum Kurs einblenden (i) symbol auf Knoten hinzufügen - 🚩information der erforderlichen tools grafisch einbauen - ✅filtern bzw. sortieren nach tools - 🚩größe der knoten entsprechend des Aufwands (Einheiten á 50 min) - 🟡Terminplanung einbauen ... 3b:[{"id":"35c521d3fd0c4778f6f13c0ee15b982c73115e09dc0d58253c0270987c0756fde41b28184d82fe784cbdc17cf0c74be4a9909ebe0dc59e77561bf222ee1d38f6","href":"https://static.observableusercontent.com/files/35c521d3fd0c4778f6f13c0ee15b982c73115e09dc0d58253c0270987c0756fde41b28184d82fe784cbdc17cf0c74be4a9909ebe0dc59e77561bf222ee1d38f6","name":"BIM.jpg","type":"image/jpeg","lastModified":1669641785045.66,"size":118805}] 31:{"id":"3cf6c02efd67e1d9","slug":"bim","title":"BIM Kursplanung","thumbnail":"cd79e8a6f6cc6716af43a3cddb97cc39cc702b15b0a2468fcd5317fdf512851c","access_level":"public","create_time":"$D2022-05-11T19:13:33.003Z","update_time":"$D2022-11-28T13:24:18.699Z","view_time":null,"first_public_time":"$D2022-11-28T08:01:49.820Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"a76703451a31e9d8","login":"gogris","name":"Gerald Illy","avatar_url":"https://avatars-next.observableusercontent.com/886df543dca14b67ddacf3637f250d81f9cce4d89008373a262c133e462d9e60","tier":"starter_2024"},"version":1706,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"66ac448e181f10c8","login":"gogris","name":"Gerald Illy","avatar_url":"https://avatars-next.observableusercontent.com/886df543dca14b67ddacf3637f250d81f9cce4d89008373a262c133e462d9e60","tier":null}],"members":[{"type":"individual","id":"66ac448e181f10c8","login":"gogris","name":"Gerald Illy","avatar_url":"https://avatars-next.observableusercontent.com/886df543dca14b67ddacf3637f250d81f9cce4d89008373a262c133e462d9e60","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"BIM Kursplanung","cells":[{"id":0,"value":"# BIM Kursplanung","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1039,"value":"https://www.academy.side.at/","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1703,"value":"![BIM.jpg](${await FileAttachment(\"BIM.jpg\").url()})\nSource: https://www.heinze.de/architekturobjekt/zoom/12660822/","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":43,"value":"## Kursdaten","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1688,"value":"viewof file = Inputs.file({label: \"Data\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1544,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1697,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"workbook = file.xlsx()\n//workbook = FileAttachment(\"microsoft://BIM Kurse.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"viewof query_string = Inputs.text({ label: \"Search / Query\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"table_data = simplify(\n workbook.sheet(\"Kurse\", {\n headers: true\n })\n).map((row) => {\n if (typeof row.Voraussetzungen === \"string\") {\n row.Voraussetzungen = row.Voraussetzungen.replaceAll(\"\\n\\n\", \"; \");\n }\n var s = row.Einheiten.split(\" \");\n row.Einheiten = parseFloat(s[0].replace(\",\", \".\"));\n return row;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1360,"value":"### Status","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1497,"value":"#### Absolvierte Kurse","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1506,"value":"Anzahl absolvierte Kurse: **${done.length}**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1515,"value":"Absolvierte Wochenstunden aus Kursen: **${absolvierte_kurse_wochenstunden}** (soll: ${significant(kurs_staistik.soll.kurse)})","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1521,"value":"viewof table1 = Inputs.table(done, { columns: [\"ID\", \"Kurs\", \"Einheiten\"] })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1503,"value":"done = table_data.filter((d) => d.Status == 1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1510,"value":"absolvierte_kurse_wochenstunden = {\n var N = 0;\n done.forEach((d) => (N = N + d.Einheiten));\n return N;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1630,"value":"wochenstunden_aller_kurse = {\n var N = 0;\n table_data.forEach((d) => (N = N + d.Einheiten));\n return N;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1573,"value":"viewof color1 = Inputs.color({label: \"Favorite color\", value: \"#4682b4\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1495,"value":"#### Kurs Modell","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1370,"value":"kurs = ({\n wochenstunden: 16,\n kursanteil: 1 / 4,\n selbststudium: 3 / 4,\n wochen: 52,\n start: \"2022-05-09\",\n end: \"2023-05-08\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1440,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"### Tabelle","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":255,"value":"viewof toggle_description = Inputs.toggle({\n label: \"Kursbeschreibung\",\n value: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"view_table = table(search, {\n nully: () => 'No data',\n enableFilter: false,\n enableCSVDownload: false,\n columns: toggle_description\n ? [\"ID\", \"Kurs\", \"Tools\", \"Einheiten\", \"Beschreibung\"]\n : [\"ID\", \"Kurs\", \"Status\", \"Voraussetzungen\"]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"search = table_data.filter(parseQuery(query_string, columns))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"columns = Object.keys(table_data[0]).map((column) => {\n let key;\n if (typeof column == \"string\") {\n key = column;\n column = { key };\n } else {\n key = column.key;\n }\n\n const decimalNumber = table_data.reduce((memo, d) => {\n if (typeof d[key] === \"number\") {\n let frac = (d[key] || \"\").toString().split(\".\")[1];\n if (frac) return Math.max(memo, frac.length);\n }\n return memo;\n }, 0);\n\n return Object.assign(\n {\n name: defaultHumanize(key),\n type: typeof table_data[0][key],\n accessor: (row) => row[key],\n render: (val) => {\n if (decimalNumber && typeof val === \"number\") {\n return val.toFixed(decimalNumber);\n }\n if (val == null || val == undefined) {\n return '-';\n }\n return val;\n }\n },\n column\n );\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"import { defaultHumanize } from \"55afbe74c96b6cf5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":174,"value":"import { parseQuery } from \"55afbe74c96b6cf5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"import { table } from \"55afbe74c96b6cf5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"## Datenmodell","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":536,"value":"#### Input","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":51,"value":"input = {\n var input = [];\n search.forEach((course) => {\n input.push({\n id: course.ID,\n name: course.Kurs.trim(),\n prev: undefined,\n merge: [],\n tools: [],\n state: course.Status,\n lessons: course.Einheiten,\n description: course.Beschreibung.trim(),\n course: course\n });\n });\n\n input.forEach((node) => {\n // seperate tools\n var s = node.course.Tools.split(\",\");\n s.forEach((tool) => {\n node.tools.push(tool.trim());\n });\n\n // seperate and assigne prerequisites\n var s = node.course.Voraussetzungen.split(\";\");\n s.forEach((pre) => {\n var n = input.find(\n (d) => d.name.toLowerCase() == pre.trim().toLowerCase()\n );\n if (n == undefined) {\n console.log(node.id, \"pre not found: \", pre.trim());\n } else {\n node.merge.push(n.id);\n }\n });\n });\n return input;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"nodes = {\n var nodes = {};\n deepCopy(input).forEach((node) => {\n nodes[node.id] = node;\n });\n linkNodes(nodes);\n getInheritance(nodes);\n removeGrandHeritage(nodes);\n allignePrimitives(nodes);\n return nodes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":532,"value":"#### Index","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":108,"value":"index = {\n var index = {\n nodes: nodes\n };\n order(index);\n nodes_alligne_vertical(index);\n reorder_lanes(index);\n getToolsIndex(index);\n\n // simplify looping over a index element\n index.forEach = (element, f) => {\n Object.values(index[element]).forEach(f);\n };\n\n // simplify mountig a new function to a index elements entries\n index.mount = (element, fname, func) => {\n index.forEach(element, (d) => {\n d[fname] = () => {\n return func(d);\n };\n });\n };\n\n // mount additional functions\n index.mount(\"nodes\", \"isAvailable\", isAvailable);\n\n // mount additional functions (explicite vs simplify)\n // Object.values(index.nodes).forEach((node) => {\n // node.isAvailable = () => {\n // return isAvailable(node);\n // };\n // });\n\n return index;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1239,"value":"function getNextID(dict) {\n // requires a dict of objects with numeric id entries\n // obj.id = \n return Object.keys(dict).length == 0\n ? 0\n : d3.max(Object.values(dict), (d) => d.id + 1);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":475,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"function getGrid(lane, cell) {\n return {\n lane: lane,\n cell: cell,\n col: () => cell.order.indexOf(cell.id),\n row: () => lane.order.indexOf(lane.id)\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":563,"value":"log = ({\n node_alligne_iterations: undefined\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":507,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"#### Erbgut\n_Kurse die bereits für einen Vorgänger-Kurs notwendig waren, sind automatisch auch für die Nachfolger-Kurse erforderlich und müssen nicht mehr dargestellt werden._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":323,"value":"Jeder Knoten erhält eine Funktion die das Erbgut vom Vorgänger übernimmt. Beim abrufen des Erbgutes der Vorgänger, werden deren Erbgutfunktionen aufgerufen, sodass schließlich alle Erbgutinformationen aus einer Iteration über alle Vorgänger zusammengebaut wird.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":321,"value":"function getInheritance(nodes) {\n Object.values(nodes).forEach((node) => {\n node.inheritance = () => {\n // add direct inheritance to heritage\n var heritage = { ...node.merge };\n if (node.prev) {\n heritage[node.prev.id] = node.prev;\n }\n Object.values(heritage).forEach((parent) => {\n heritage = { ...heritage, ...parent.inheritance() };\n });\n return heritage;\n };\n });\n return nodes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":385,"value":"function removeGrandHeritage(nodes) {\n // remove all entries in merge which are already part of one of the direct parents\n Object.values(nodes).forEach((node) => {\n var grand_heritage = {};\n Object.values(node.merge).forEach((parent) => {\n grand_heritage = { ...grand_heritage, ...parent.inheritance() };\n });\n Object.keys(grand_heritage).forEach((grand_parent_id) => {\n delete node.merge[grand_parent_id];\n delete nodes[grand_parent_id].fork[node.id];\n });\n });\n return nodes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":414,"value":"function allignePrimitives(nodes) {\n // Bei Knoten bei denen fork und merge auf einander zeigen, werden die einträge auf next und prev übertragen.\n // D.h. wenn fork nur einen eintrag hat und merge des fork-knoten nur einen eintrag hat, dann müssen sie eigentlich ident sein!\n Object.values(nodes).forEach((node) => {\n if (\n Object.values(node.fork).length == 1 &&\n Object.values(Object.values(node.fork)[0].merge).length == 1\n ) {\n if (Object.values(Object.values(node.fork)[0].merge)[0] != node) {\n console.log(\n \"[ERROR]\",\n \"In the function 'allignePrimitives' was an inconsitent fork <> merge relation detected!\"\n );\n }\n var next = Object.values(node.fork)[0];\n node.next = Object.values(node.fork)[0];\n node.fork = {};\n next.prev = node;\n next.merge = {};\n }\n });\n return nodes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":584,"value":"## Backlog\n_Eine Liste von Kursen die bereits gemacht werden können, sortiert nach Anzahl weiterer Kurse, die dadurch direkt ermöglicht werden._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":704,"value":"view_backlog = table(backlog.order, {\n columns: [\"id\", \"name\", \"tools\", \"lessons\"],\n enableCSVDownload: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":588,"value":"backlog = {\n var backlog = {\n nodes: {},\n order: []\n };\n\n // für jeden knoten wird ermittelt ob er schon freigeschaltet ist, d.h. keine vorgänger die noch nicht freigeschaltet sind\n Object.values(index.nodes).forEach((node) => {\n if (node.isAvailable() && node.state == 0) {\n backlog.nodes[node.id] = node;\n }\n // todo\n });\n\n // sortieren nach relevanz, d.h. kurse die viele Kurse freischalten sind relevanter\n backlog.order = Object.values(backlog.nodes).sort((a, b) => {\n var Na = (a.next ? 1 : 0) + Object.keys(a.fork).length;\n var Nb = (b.next ? 1 : 0) + Object.keys(b.fork).length;\n return Nb - Na;\n });\n\n return backlog;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":596,"value":"function isAvailable(node) {\n if (node.prev && node.prev.state == 0) {\n return false;\n }\n\n for (var key in node.merge) {\n let prev = node.merge[key];\n if (prev.state == 0) {\n return false;\n }\n }\n return true;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1229,"value":"## Tools\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1236,"value":"function getToolsIndex(index){\n index.tools = [\"\"];\n Object.values(index.nodes).forEach((node) => {\n node.tools.forEach((tool) => {\n if (index.tools.find((d) => d == tool) == undefined) {\n index.tools.push(tool);\n }\n });\n });\n return index.tools;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1313,"value":"viewof selected_tool = Inputs.select(index.tools.sort(), {\n label: \"Select a Tool\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"## Diagramm","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":117,"value":"$38","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":807,"value":"// Berechnung der Verbindungslinien\n// data ... index der datenpunkte die zu verbinden sind\n// x, y ... x/y Skala Funktionen\nfunction compute_links(data, x, y) {\n var links = [];\n data.forEach((d) => {\n if (d.next) {\n links.push({\n id: \"path_\" + d.id + \"_\" + d.next.id + \"_end\",\n source: [x(d.grid.col()), y(d.grid.row()) + y.bandwidth() / 2],\n target: [x(d.next.grid.col()), y(d.next.grid.row()) + y.bandwidth() / 2]\n });\n }\n Object.values(d.fork).forEach((fork) => {\n links.push({\n id: \"path_\" + d.id + \"_\" + fork.id + \"_end\",\n source: [x(d.grid.col()), y(d.grid.row()) + y.bandwidth() / 2],\n target: [x(fork.grid.col()), y(fork.grid.row()) + y.bandwidth() / 2]\n });\n });\n });\n return links;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":406,"value":"### Spuren sortieren\n_Die relevantesten Spuren, also jene mit den meisten Verzweigungen sollen ganz oben gezeichnet werden._","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1096,"value":"// convert an object with an id into a dict\nfunction object2dict(obj) {\n var d = {};\n if (obj) {\n d[obj.id] = obj;\n return d;\n } else {\n return d;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1200,"value":"function countConnections(node){\n return Object.keys({ ...node.fork, ...object2dict(node.next), ...node.merge, ...object2dict(node.prev)}).length\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1147,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":123,"value":"$3a","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":12,"value":"## Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":17,"value":"simplify = (table) => {\n let stop = table.length;\n for (let i = 0; i < table.length; i++) {\n if (table[i].ID == null) {\n stop = i;\n break;\n }\n }\n return table.splice(0, stop);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"function deepCopy(object) {\n return JSON.parse(JSON.stringify(object));\n //structuredClone())\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":516,"value":"## Style","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":776,"value":"viewof default_color = Inputs.text({ label: \"Hex Color\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":577,"value":"viewof color = Inputs.color({ label: \"Favorite color\", value: default_color })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":926,"value":"colors = ({\n default: \"#000000\",\n view: \"#FFF\",\n highlight: \"#48c1f4\",\n hide: \"#808080\",\n done: \"#2bed12\",\n text: \"#000\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":520,"value":"style = ({\n node: {\n fill: {\n default: colors.view,\n state_done: colors.done,\n highlight: colors.highlight,\n hide: colors.hide\n },\n opacity: {\n default: 1,\n background: 0.5\n },\n stroke: {\n color: {\n default: null,\n isAvailable: colors.done\n },\n width: \"3px\"\n },\n text: {\n color: colors.text\n }\n },\n path: {\n width: 8,\n opacity: 0.3,\n color: colors.default\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1416,"value":"## Import","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1418,"value":"$$ = require(\"jquery\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1430,"value":"// https://momentjs.com/docs/#/get-set/week/\nmoment = require(\"moment\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1475,"value":"import { significant } from \"586378c05df1b2bc\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1537,"value":"import {Sunburst} from \"@d3/sunburst\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3b","stdlib":"1","titling":"auto"}} 32:"$31:body"