2f:T808,function* createFromTo(sortedMonthly) { let fromTo = []; for (let n = 0; n < sortedMonthly.length - 1; n++) { let from = sortedMonthly[n].map((el) => Object.assign({}, el)); let to = sortedMonthly[n + 1].map((el) => Object.assign({}, el)); // matching nodes from.forEach((f) => { let t = to.filter((el) => dataKey(el) == dataKey(f)); if (t.length == 1) { let weight = Math.min(f.duration, t[0].duration); f.duration -= weight; t[0].duration -= weight; let fromKey = dataKey(f); let toKey = dataKey(t[0]); fromTo.push({ from: f.date + " " + fromKey, to: t[0].date + " " + toKey, weight: weight, name: fromKey, type: "matching" }); } }); // spread remainings while (from.length > 0 && to.length > 0) { let weight = Math.min(from[0].duration, to[0].duration); let fromKey = dataKey(from[0]); let toKey = dataKey(to[0]); fromTo.push({ from: from[0].date + " " + fromKey, to: to[0].date + " " + toKey, weight: weight, name: fromKey, type: "spread" }); [from, to].forEach((el) => { el[0].duration -= weight; if (el[0].duration == 0 || isNaN(el[0].duration)) { el.shift(); } }); } /* // outgoings if (from.length > 0) { let weight = from[0].duration; let fromKey = dataKey(from[0]); fromTo.push({ from: from[0].date + " " + fromKey, to: from[0].date + " " + fromKey, outgoing: true, weight: weight, name: fromKey //colorIndex: nodes.get(fromKey) }); } if (to.length > 0) { let weight = to[0].duration; let toKey = dataKey(to[0]); fromTo.push({ from: to[0].date + " " + toKey, to: to[0].date + " " + toKey, outgoing: true, weight: weight, name: toKey //colorIndex: nodes.get(toKey) }); } */ } yield fromTo; }30:T867,sankey = (fromTo, height, width, asJson) => { const figure = html`

`; const spacing = 30; let chart = { chart: { marginLeft: 200, marginRight: 200, showAxes: true }, title: { text: "C&PS Customer Flow " + year }, xAxis: { categories: [ "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" ].reduce((cat, month) => cat.concat(new Array(spacing).fill(month)), []), tickPositions: [ "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" ].map((month, idx) => spacing * idx), lineWidth: 0 }, yAxis: { visible: false }, series: [ { data: fromTo, levels: [ { level: 0, dataLabels: { enabled: true, align: "right", overflow: "allow", x: -20 //style: "none" } } ] .concat( new Array(10).fill(0).map((v, k) => { return { level: k + 1, dataLabels: { enabled: false } }; }) ) .concat({ level: 11, dataLabels: { enabled: true, align: "left", overflow: "allow", x: 20 //style: "none" } }), turboThreshold: 0, nodes: Array.from(nodes.values()), type: "sankey", tooltip: { headerFormat: "", nodeFormat: "{point.name}
{point.sum:,.1f} PD", pointFormat: "{point.fromNode.name} → {point.toNode.name}
{point.weight:,.1f} PD" } } ], credits: false }; Highcharts.chart(figure, chart); return asJson ? JSON.stringify(chart) : figure; }31:T65b,heatmap = (data, hottest, height, width, asJson) => { const figure = html`

`; let chart = { title: { text: "Hottest Working Days " + year }, xAxis: { //title: { text: "Month" }, categories: [ "", "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" ] }, yAxis: { title: { text: "Day" }, //reversed: true, min: 1, max: 31, startOnTick: false, endOnTick: false, tickInterval: 1 }, colorAxis: [ { minColor: "#ffffff", maxColor: colors[0] }, { min: 0, minColor: "#ffffff", maxColor: colors[2] } ], legend: { enabled: false }, tooltip: { headerFormat: "", pointFormat: "{point.y}.{point.x}.
{point.value:,.1f} PD" }, series: [ { type: "heatmap", data: data, colorAxis: 0, pointPadding: 1, states: { inactive: { opacity: 1 } } }, { type: "heatmap", data: hottest, colorAxis: 1, pointPadding: 1, states: { inactive: { opacity: 1 } } } ], credits: false }; Highcharts.setOptions({ lang: { thousandsSep: ".", decimalPoint: "," } }); Highcharts.chart(figure, chart); return asJson ? JSON.stringify(chart) : figure; }32:T412,employeeValues = { let result = new Map(); wsTimeEntries.forEach((el) => { let dt = el.Start.toISOString().substr(0, 7); if (dt.indexOf(year) < 0 /* || el["Resource Pool"] != "Christian Ruwwe"*/) return; let prj = //el.Project.substr(0, 3) == "INT" // ? el.Project.substr(0, el.Project.indexOf("_")) // : el.Project.indexOf("_") < 0 ? "(misc)" : el.Project; let cust = wsTimeProjects.find((el) => el.Project == prj)?.Customer || "(misc)"; let emp = el["Resource Pool"]; //if (emp.indexOf("Christian Ruwwe") < 0) return; let key = [dt, emp].join("-"); let val = result.get(key) || { date: dt, employee: emp, duration: 0, projects: new Set() }; val.duration += Number(el.Duration) / 60 / 60 / 8; val.projects.add(cust /*prj*/); result.set(key, val); }); result.forEach((res) => (res.projects = Array.from(res.projects.values()))); return Array.from(result.values()).sort((a, b) => b.date.localeCompare(a.date) ); }33:T6f9,customerValues = { let result = new Map(); wsTimeEntries.forEach((el) => { let dt = el.Start.toISOString().substr(0, 10); if (dt.indexOf(year) < 0 /* || el["Resource Pool"] != "Christian Ruwwe"*/) return; let prj = //el.Project.substr(0, 3) == "INT" // ? el.Project.substr(0, el.Project.indexOf("_")) // : el.Project.indexOf("_") < 0 ? "(misc)" : el.Project; let cust = wsTimeProjects.find((el) => el.Project == prj)?.Customer || "(misc)"; //{Key Account: "Audi", Zieltagessatz lt. Budget: 1100} /* let rate = Math.max( ...Object.values(wsCustomerRates).map((el) => cust.indexOf(el["Key Account"]) >= 0 ? Number(el["Zieltagessatz lt. Budget"]) : 0 ) ); */ let rate = Object.values( wsCustomerRates .filter((pos) => pos.Order == prj && pos.Ammount > 6) .reduce( (acc, curr) => { acc.sum += curr.Ammount * curr.Rate; acc.cnt += curr.Ammount; return acc; }, { sum: 0, cnt: 0 } ) ).reduce((acc, curr, idx, arr) => arr[0] / arr[1]); let key = [cust].join("-"); let val = result.get(key) || { customer: cust, project: prj, duration: 0, employees: new Map(), rate: rate }; val.duration += Number(el.Duration) / 60 / 60 / 8; let empKey = el["Resource Pool"]; let empVal = val.employees.get(empKey) || { name: el["Resource Pool"], duration: 0 }; empVal.duration += Number(el.Duration) / 60 / 60 / 8; val.employees.set(empKey, empVal); result.set(key, val); }); result.forEach((res) => (res.employees = Array.from(res.employees.values()))); return Array.from(result.values()); }34:T4a5,bubbles = (data, height, width, asJson) => { const figure = html`

`; let chart = { title: { text: "Customer Ranking " + year }, xAxis: { title: { text: "Daily Rate" }, labels: { format: "{value:.,0f} €" }, gridLineWidth: 1, lineWidth: 0 }, yAxis: { title: { text: "#Employees" }, startOnTick: false, endOnTick: false }, colors: colors, legend: { enabled: false }, tooltip: { headerFormat: "", pointFormat: "{point.name}
{point.x:,.0f} €/Day
{point.y:,.0f} employees
{point.z:,.1f} PD" }, series: [ { type: "bubble", data: data, dataLabels: { enabled: true, format: "{point.name}" //style: "none" //align: "left", //allowOverlap: true }, colorByPoint: true } ], credits: false }; Highcharts.setOptions({ lang: { thousandsSep: ".", decimalPoint: "," } }); Highcharts.chart(figure, chart); return asJson ? JSON.stringify(chart) : figure; }35:T733,colors = { let cplace = [ "#00207a", "#0ce796", "#0058d4", "#7ffac9", "#ff3393", "#fa6d64", "#a84af0", "#ff9900", "#ff5ea1", "#ff7f6b", "#bb68fe", "#ffaf38" ]; let palette = [ "#058DC7", "#50B432", "#ED561B", "#DDDF00", "#24CBE5", "#64E572", "#FF9655", "#FFF263", "#6AF9C4" ]; let dark15 = [ "#6929c4", "#1192e8", "#005d5d", "#9f1853", "#fa4d56", "#570408", "#198038", "#002d9c", "#ee538b", "#b28600", "#009d9a", "#012749", "#8a3800", "#a56eff" ]; let light15 = [ "#8a3ffc", "#33b1ff", "#007d79", "#ff7eb6", "#fa4d56", "#fff1f1", "#6fdc8c", "#4589ff", "#d12771", "#d2a106", "#08bdba", "#bae6ff", "#ba4e00", "#d4bbff" ]; let tableau10 = [ "#1F77B4", "#FF7F0E", "#2CA02C", "#D62728", "#9467BD", "#8C564B", "#CFECF9", "#7F7F7F", "#BCBD22", "#17BECF" ]; let tableau20 = [ "#4379AB", "#96CCEB", "#FF8900", "#FFBC71", "#3DA443", "#76D472", "#BA9900", "#F7CD4B", "#249A95", "#77BEB6", "#F14A54", "#FF9797", "#7B706E", "#BCB0AB", "#E16A96", "#FFBCD3", "#B976A3", "#DCA3CA", "#A3745C", "#DDB3A4" ]; let colorCount = 15; let rand = new Array(colorCount).fill(0).map( (col) => "rgb(" + new Array(3) .fill(0) .map((el) => Math.round(Math.random() * 255)) .join(",") + ")" ); let primaryColor = [255, 0, 0]; let seq = new Array(colorCount) .fill(0) .map( (col, idx) => "rgba(" + primaryColor .concat(Math.round((idx / (colorCount - 1)) * 100) / 100) .join(",") + ")" ); return tableau20; }36:[] 2d:{"title":"Clockified","cells":[{"id":0,"value":"# Clockified","pinned":false,"hidden":false,"mode":"md"},{"id":1307,"value":"year = 2023","pinned":true,"hidden":false,"mode":"ojs"},{"id":5,"value":"viewof timeEntries = Inputs.file({\n label: \"Clockify TimeEntries\",\n accept: \".xlsx\",\n required: true\n})\n// export \"cf.projectControlling.clockifyTimeEntry\", filtered for correct year and with valid projects and users","pinned":true,"hidden":false,"mode":"ojs"},{"id":8,"value":"wbTimeEntries = timeEntries.xlsx({ header: true })","pinned":true,"hidden":false,"mode":"ojs"},{"id":21,"value":"viewof wsTimeEntriesNames = Inputs.radio(wbTimeEntries.sheetNames, {\n value: wbTimeEntries.sheetNames[0]\n})\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":24,"value":"wsTimeEntries = wbTimeEntries.sheet(wsTimeEntriesNames, { headers: true })","pinned":true,"hidden":false,"mode":"ojs"},{"id":29,"value":"viewof entries = Inputs.table(wsTimeEntries)","pinned":true,"hidden":false,"mode":"ojs"},{"id":436,"value":"new Array(12)\n .fill(0)\n .map((m, n) =>\n Math.round(\n wsTimeEntries\n .filter(\n (el) =>\n el.Start.toISOString().indexOf(\n year + \"-\" + (\"0\" + (n + 1)).slice(-2)\n ) >= 0\n )\n .reduce((acc, curr) => acc + Number(curr.Duration) / 60 / 60 / 8, 0)\n )\n )","pinned":true,"hidden":false,"mode":"ojs"},{"id":249,"value":"viewof timeProjects = Inputs.file({\n label: \"Clockify Projects\",\n accept: \".xlsx\",\n required: true\n})\n// export \"cf.projectControlling.project\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":255,"value":"wbTimeProjects = timeProjects.xlsx({ header: true })","pinned":true,"hidden":false,"mode":"ojs"},{"id":263,"value":"viewof wsTimeProjectsNames = Inputs.radio(wbTimeProjects.sheetNames, {\n value: wbTimeProjects.sheetNames[0]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":272,"value":"wsTimeProjects = wbTimeProjects.sheet(wsTimeProjectsNames, { headers: true })","pinned":true,"hidden":false,"mode":"ojs"},{"id":62,"value":"monthlyValues = {\n let result = new Map();\n wsTimeEntries.forEach((el) => {\n let dt = el.Start.toISOString().substr(0, 7);\n if (dt.indexOf(year) < 0 /*|| el[\"Resource Pool\"] != \"Christian Ruwwe\"*/)\n return;\n let prj =\n //el.Project.substr(0, 3) == \"INT\"\n // ? el.Project.substr(0, el.Project.indexOf(\"_\"))\n // :\n el.Project.indexOf(\"_\") < 0 ? \"(misc)\" : el.Project;\n let cust =\n wsTimeProjects.find((el) => el.Project == prj)?.Customer || \"(misc)\";\n let key = [dt, prj].join(\"-\");\n let val = result.get(key) || {\n date: dt,\n project: prj,\n customer: cust,\n duration: 0\n };\n val.duration += Number(el[\"Duration MD\"]); // / 60 / 60 / 8;\n result.set(key, val);\n });\n result.forEach(\n (val) =>\n (val.customer = val.duration < minDuration ? \"(misc)\" : val.customer)\n );\n return Array.from(result.values()).sort((a, b) =>\n b.date.localeCompare(a.date)\n );\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":426,"value":"Plot.plot({\n marks: [\n Plot.barY(\n new Array(12)\n .fill(0)\n .map((m, n) =>\n Math.round(\n monthlyValues\n .filter((el) => el.date == \"2022-\" + (\"0\" + (n + 1)).slice(-2))\n .reduce((acc, curr) => acc + curr.duration, 0)\n )\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":126,"value":"sortedMonthly = {\n let grouped = monthlyValues.reduce((res, curr) => {\n if (res[curr.date] == undefined) {\n res[curr.date] = [];\n }\n res[curr.date].push(curr);\n return res;\n }, {});\n grouped = Array.from(Object.values(grouped)).sort((a, b) =>\n a[0].date.localeCompare(b[0].date == 0)\n );\n grouped.forEach((group) =>\n group.sort((a, b) => a.project.localeCompare(b.project))\n );\n return grouped;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":31,"value":"Plot.plot({\n color: {\n legend: true\n },\n marks: [\n Plot.barY(monthlyValues, {\n x: \"date\",\n y: \"duration\",\n fill: \"customer\" //\"project\"\n }),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":387,"value":"minDuration = 180000 / 60 / 60 / 8","pinned":true,"hidden":false,"mode":"ojs"},{"id":144,"value":"sankey(\n compressedFromTo.sort((a, b) => b.from.localeCompare(a.from)),\n 800,\n 1150\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":308,"value":"dataKey = (data) => data.customer //project;","pinned":true,"hidden":false,"mode":"ojs"},{"id":390,"value":"compressedFromTo = {\n let compressedFromTo = new Map();\n fromTo.forEach((el) => {\n let key = [el.from, el.to].join(\"-\");\n let val = compressedFromTo.get(key);\n if (val == undefined) {\n val = Object.assign({}, el);\n } else {\n val.weight += el.weight;\n }\n compressedFromTo.set(key, val);\n });\n return Array.from(compressedFromTo.values());\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1232,"value":"from = sortedMonthly[10].map((el) => Object.assign({}, el))","pinned":true,"hidden":false,"mode":"ojs"},{"id":1248,"value":"to = sortedMonthly[11].map((el) => Object.assign({}, el))","pinned":true,"hidden":false,"mode":"ojs"},{"id":134,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":1204,"value":"fromTo = createFromTo(sortedMonthly)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1256,"value":"sortedMonthly[0].filter((el) => isNaN(el.duration))","pinned":true,"hidden":false,"mode":"ojs"},{"id":179,"value":"projects = Array.from(\n sortedMonthly.reduce((projects, month) => {\n month.forEach((el) => projects.add(dataKey(el)));\n return projects;\n }, new Set())\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":148,"value":"nodes = sortedMonthly.reduce((nodes, month) => {\n month.forEach((el) => {\n let node = {\n id: el.date + \" \" + dataKey(el),\n name: dataKey(el), // + \"(\" + el.date + \")\",\n color: colors[projects.indexOf(dataKey(el)) % colors.length],\n column: Number(el.date.substr(5, 2)) - 1\n };\n if (Number(el.date.substr(5, 2)) == 12) {\n node.dataLabels = {\n enabled: true,\n align: \"left\",\n position: \"right\"\n };\n }\n nodes.set(el.date + \" \" + dataKey(el), node);\n });\n return nodes;\n}, new Map())","pinned":true,"hidden":false,"mode":"ojs"},{"id":140,"value":"$30","pinned":true,"hidden":false,"mode":"ojs"},{"id":525,"value":"dailyValues = {\n let result = new Map();\n wsTimeEntries.forEach((el) => {\n let dt = el.Start.toISOString().substr(0, 10);\n if (dt.indexOf(year) < 0 /* || el[\"Resource Pool\"] != \"Christian Ruwwe\"*/)\n return;\n\n let prj =\n //el.Project.substr(0, 3) == \"INT\"\n // ? el.Project.substr(0, el.Project.indexOf(\"_\"))\n // :\n el.Project.indexOf(\"_\") < 0 ? \"(misc)\" : el.Project;\n let cust =\n wsTimeProjects.find((el) => el.Project == prj)?.Customer || \"(misc)\";\n\n let key = [dt].join(\"-\");\n let val = result.get(key) || {\n date: dt,\n duration: 0,\n projects: new Set()\n };\n val.duration += Number(el.Duration) / 60 / 60 / 8;\n val.projects.add(prj);\n result.set(key, val);\n });\n\n result.forEach((res) => (res.projects = Array.from(res.projects.values())));\n\n return Array.from(result.values()).sort((a, b) =>\n b.date.localeCompare(a.date)\n );\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1177,"value":"heatmap(\n dailyValues.map((day) => {\n return {\n x: Number(day.date.split(\"-\")[1]),\n y: Number(day.date.split(\"-\")[2]),\n value: Number(day.duration)\n };\n }),\n hottestDays.map((day) => {\n return {\n x: Number(day.key.split(\"-\")[1]),\n y: Number(day.key.split(\"-\")[2]),\n value: Number(day.value)\n };\n }),\n 800,\n 600\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":772,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":540,"value":"Plot.plot({\n caption: \"Hottest Day \" + year,\n width: 600,\n height: 600,\n padding: 0.1,\n grid: true,\n color: {\n type: \"diverging\"\n },\n marks: [\n Plot.cell(\n dailyValues.map((day) => {\n return {\n month: Number(day.date.split(\"-\")[1]),\n day: Number(day.date.split(\"-\")[2]),\n duration: Number(day.duration)\n };\n }),\n {\n x: \"month\",\n y: \"day\",\n fill: \"duration\"\n }\n ),\n Plot.cell(\n hottestDays.map((day) => {\n return {\n month: Number(day.key.split(\"-\")[1]),\n day: Number(day.key.split(\"-\")[2]),\n duration: Number(day.value)\n };\n }),\n {\n x: \"month\",\n y: \"day\",\n fill: \"duration\",\n stroke: \"orange\",\n strokeWidth: 5\n }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":590,"value":"Plot.rect(\n dailyValues.map((day) => {\n return {\n month: Number(day.date.split(\"-\")[1]),\n day:\n Number(day.date.split(\"-\")[2]) +\n new Date(new Date(day.date).setDate(1)).getDay() -\n 1,\n duration: Number(day.duration)\n };\n }),\n Plot.bin(\n { fillOpacity: \"sum\" },\n {\n x: { thresholds: 12, value: \"month\" },\n y: { thresholds: 31, value: \"day\" },\n fillOpacity: \"duration\",\n fill: \"#004488\"\n }\n )\n).plot()","pinned":true,"hidden":false,"mode":"ojs"},{"id":638,"value":"hottestDays = Object.entries(\n dailyValues.reduce((res, curr) => {\n res[curr.date] = (res[curr.date] || 0) + curr.duration;\n return res;\n }, {})\n)\n .map(([k, v]) => {\n return { key: k, value: v };\n })\n .sort((a, b) => b.value - a.value)\n .slice(0, 10)","pinned":true,"hidden":false,"mode":"ojs"},{"id":571,"value":"$32","pinned":true,"hidden":false,"mode":"ojs"},{"id":551,"value":"Plot.plot({\n caption: \"Multitasking \" + year,\n width: 1200,\n height: 600,\n padding: 0.1,\n grid: true,\n color: {\n type: \"diverging\"\n },\n marks: [\n Plot.line(\n employeeValues.map((employee) => {\n return {\n month: employee.date,\n projects: employee.projects.length,\n employee: employee.employee\n };\n }),\n {\n x: \"month\",\n y: \"projects\",\n z: \"employee\"\n }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":1090,"value":"yearlyEmployeeValues.filter((val) => val.project == \"Mercedes-Benz AG\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":1054,"value":"yearlyEmployeeValues = {\n let result = new Map();\n wsTimeEntries.forEach((el) => {\n let dt = el.Start.toISOString().substr(0, 7);\n if (dt.indexOf(year) < 0 /* || el[\"Resource Pool\"] != \"Christian Ruwwe\"*/)\n return;\n\n let prj =\n //el.Project.substr(0, 3) == \"INT\"\n // ? el.Project.substr(0, el.Project.indexOf(\"_\"))\n // :\n el.Project.indexOf(\"_\") < 0 ? \"(misc)\" : el.Project;\n let cust =\n wsTimeProjects.find((el) => el.Project == prj)?.Customer || \"(misc)\";\n let emp = el[\"Resource Pool\"];\n //if (emp.indexOf(\"Christian Ruwwe\") < 0) return;\n\n let key = [emp, cust].join(\"-\");\n let val = result.get(key) || {\n employee: emp,\n duration: 0,\n project: cust\n };\n val.duration += Number(el.Duration) / 60 / 60 / 8;\n result.set(key, val);\n });\n\n return Array.from(result.values());\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":994,"value":"nds = {\n let nodes1 = new Set();\n employeeValues.forEach((emp) => nodes1.add(emp.employee));\n let nodes = Array.from(nodes1).map((node) => {\n return { id: node, marker: { radius: 5 }, color: colors[1] };\n });\n let nodes2 = new Set();\n employeeValues.forEach((emp) =>\n emp.projects.forEach((prj) => nodes2.add(prj))\n );\n nodes = nodes.concat(\n Array.from(nodes2).map((node) => {\n return { id: node, marker: { radius: 15 }, color: colors[5] };\n })\n );\n return nodes;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":986,"value":"sankey(\n lnks1.filter((l) => l.weight >= 15),\n 600,\n 1200\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1082,"value":"wheel(\n lnks1.filter((l) => l.weight > 15),\n [],\n 600,\n 600\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1005,"value":"sankey(\n lnks.filter((l) => l.weight >= 1),\n 600,\n 1200\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1301,"value":"lnks","pinned":true,"hidden":false,"mode":"ojs"},{"id":1084,"value":"wheel(lnks, nds, 800, 800)","pinned":true,"hidden":false,"mode":"ojs"},{"id":1042,"value":"lnks = {\n let weights = new Map();\n yearlyEmployeeValues.forEach((v1) => {\n let key = [v1.employee, v1.project].join(\"|\");\n let weight = weights.get(key) || 0;\n weights.set(key, weight + 1);\n });\n return Array.from(weights.keys()).map((k) => {\n return {\n from: k.split(\"|\")[0],\n to: k.split(\"|\")[1],\n weight: weights.get(k),\n color: colors[9]\n };\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1070,"value":"lnks1 = {\n let weights = new Map();\n yearlyEmployeeValues.forEach((v1) =>\n yearlyEmployeeValues\n .filter((v2) => v1.employee == v2.employee && v1.project != v2.project)\n .forEach((v2) => {\n let key = [v1.project, v2.project]\n .sort((a, b) => a.localeCompare(b))\n .join(\"|\");\n let weight = weights.get(key) || 0;\n weights.set(key, weight + 1);\n })\n );\n return Array.from(weights.keys()).map((k) => {\n return {\n from: k.split(\"|\")[0],\n to: k.split(\"|\")[1],\n weight: weights.get(k)\n };\n });\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":980,"value":"network = (links, nodes, height, width, asJson) => {\n const figure = html`

`;\n\n let chart = {\n title: {\n text: \"Employee Web \" + year\n },\n colors: colors,\n legend: {\n enabled: false\n },\n tooltip: {\n headerFormat: \"\",\n pointFormat: \"{point.fromNode.name} → {point.toNode.name}\"\n },\n series: [\n {\n type: \"networkgraph\",\n turboThreshold: 0,\n data: links,\n nodes: nodes,\n layoutAlgorithm: {\n enableSimulation: true,\n integration: \"euler\",\n friction: -0.9\n },\n colorByPoint: true\n }\n ],\n credits: false\n };\n\n Highcharts.setOptions({ lang: { thousandsSep: \".\", decimalPoint: \",\" } });\n Highcharts.chart(figure, chart);\n\n return asJson ? JSON.stringify(chart) : figure;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":1080,"value":"wheel = (links, nodes, height, width, asJson) => {\n const figure = html`

`;\n\n let chart = {\n title: {\n text: \"Project Collaboration \" + year\n },\n colors: colors,\n legend: {\n enabled: false\n },\n tooltip: {\n headerFormat: \"\",\n pointFormat: \"{point.fromNode.name} → {point.toNode.name}\"\n },\n series: [\n {\n type: \"dependencywheel\", //\"networkgraph\",\n turboThreshold: 0,\n data: links,\n nodes: nodes,\n layoutAlgorithm: {\n enableSimulation: true,\n integration: \"euler\",\n friction: -0.9\n },\n dataLabels: {\n //style: \"none\",\n color: \"#000000\"\n },\n size: \"90%\"\n }\n ],\n credits: false\n };\n\n Highcharts.setOptions({ lang: { thousandsSep: \".\", decimalPoint: \",\" } });\n Highcharts.chart(figure, chart);\n\n return asJson ? JSON.stringify(chart) : figure;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":867,"value":"viewof customerRates = Inputs.file({\n label: \"Daily Rates\",\n accept: \".xlsx\",\n required: true\n})\n// export order positions from workspace CRM","pinned":true,"hidden":false,"mode":"ojs"},{"id":872,"value":"wbCustomerRates = customerRates.xlsx({ header: true })","pinned":true,"hidden":false,"mode":"ojs"},{"id":877,"value":"viewof wsCustomerRateNames = Inputs.radio(wbCustomerRates.sheetNames, {\n value: wbCustomerRates.sheetNames[0]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":884,"value":"wsCustomerRates = wbCustomerRates.sheet(wsCustomerRateNames, { headers: true })","pinned":true,"hidden":false,"mode":"ojs"},{"id":911,"value":"Object.values(\n wsCustomerRates\n .filter((pos) => pos.Order == \"B_3120 (Evaluierung Joint Venture BBAC)\")\n .reduce(\n (acc, curr) => {\n acc.sum += curr.Ammount * curr.Rate;\n acc.cnt += curr.Ammount;\n return acc;\n },\n { sum: 0, cnt: 0 }\n )\n).reduce((acc, curr, idx, arr) => arr[0] / arr[1])","pinned":true,"hidden":false,"mode":"ojs"},{"id":544,"value":"$33","pinned":true,"hidden":false,"mode":"ojs"},{"id":553,"value":"Plot.plot({\n caption: \"Customer \" + year,\n width: 600,\n height: 600,\n padding: 0.1,\n grid: true,\n marks: [\n Plot.dot(\n customerValues\n .map((customer) => {\n return {\n duration: customer.duration,\n rate: customer.rate,\n employees: customer.employees.length\n };\n })\n .filter((customer) => customer.rate > 0 /*&& customer.rate < 2000*/),\n {\n x: \"rate\",\n y: \"employees\",\n r: \"duration\"\n }\n ),\n Plot.text(\n customerValues\n .map((customer) => {\n return {\n customer: customer.customer,\n rate: customer.rate,\n employees: customer.employees.length\n };\n })\n .filter((customer) => customer.rate > 0 && customer.rate < 2000),\n {\n x: \"rate\",\n y: \"employees\",\n text: \"customer\"\n }\n )\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":948,"value":"bubbles(\n customerValues\n .filter((customer) => customer.rate > 0 && customer.rate < 2000)\n .map((customer) => {\n return {\n x: customer.rate,\n y: customer.employees.length,\n z: customer.duration,\n name: customer.customer\n };\n }),\n 600,\n 1000,\n true\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":946,"value":"$34","pinned":true,"hidden":false,"mode":"ojs"},{"id":229,"value":"$35","pinned":true,"hidden":false,"mode":"ojs"},{"id":138,"value":"Highcharts = {\n const Highcharts = await require(\"highcharts\");\n await require(\"highcharts/highcharts-more.js\");\n\n await require(\"highcharts/modules/exporting.js\");\n await require(\"highcharts/modules/export-data.js\");\n await require(\"highcharts/modules/accessibility.js\");\n\n await require(\"highcharts/modules/heatmap.js\");\n await require(\"highcharts/modules/sankey.js\");\n await require(\"highcharts/modules/networkgraph.js\");\n await require(\"highcharts/modules/dependency-wheel.js\");\n\n return Highcharts;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":10,"value":"//import { aq, op } from \"@uwdata/arquero\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":13,"value":"//entries = aq.from(timeEntries)","pinned":true,"hidden":false,"mode":"ojs"},{"id":16,"value":"//entries.view()","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W36","stdlib":"1","titling":"auto"}