31:T6b1,viewof parameters = { const div = html`

`; div.style.display = 'flex'; div.style.flexWrap = 'wrap'; if (shouldDisplayWageRate) { div.style.justifyContent = 'space-between'; } div.value = {}; const distance = slider({ min: 1, max: 50, step: 1, value: 2, oninput: obj => { div.value.distance = obj.value; div.dispatchEvent(new CustomEvent("input")); }, title: "Distance", desc: "Distance in km", theme: "default-round", background: { type: 'double', colors: ['#79ae98', 'white'] } }); if (!shouldDisplayWageRate) { distance.style.marginRight = '40px'; } const plotSize = slider({ min: 1, max: 40, step: 1, value: 2, oninput: obj => { div.value.plotSize = obj.value; div.dispatchEvent(new CustomEvent("input")); }, title: "Plot size", desc: "Avg. size of a plot in ha", theme: 'default-round', background: { type: 'double', colors: ['#79ae98', 'white'] } }); const laborCosts = slider({ min: 0, max: 25, step: 1, value: 13, oninput: obj => { div.value.laborCosts = obj.value; div.dispatchEvent(new CustomEvent("input")); }, title: "Labor costs", desc: "Avg. gross labor costs per working hour (€/h)", theme: 'default-round', background: { type: 'double', colors: ['#79ae98', 'white'] } }); console.log(laborCosts); laborCosts.style.display = shouldDisplayWageRate ? 'block' : 'none'; div.value = { distance: distance.value, plotSize: plotSize.value, laborCosts: laborCosts.value }; div.append(distance, plotSize, laborCosts); return div; }32:Td0d,chart = new Chart(c.getContext("2d"), { type: 'line', data: { labels: sgms[Object.keys(sgms)[0]] .filter(r => r.region === 'Deutschland') .map(year => year.year) .reverse(), datasets: Object.keys(sgms) // .filter(crop => pricesYieldsDirectCosts[crop][0].sdb > 500) .map((crop, i) => { return { label: crop.split(/\:\:/g)[1], data: sgms[crop] .filter(row => row.region === 'Deutschland') .map(year => { return ( year.sdb - predict( variableMachineCostsRegressionCoefficients[crop].varCosts, 2, 2 ) ); }) .reverse(), backgroundColor: 'rgba(0, 0, 0, 0)', borderColor: i == 6 ? colors[i] : '', pointRadius: 0, borderWidth: 2, pointBackgroundColor: 'white' }; }) }, options: { onHover: function onHover(evt, activeElements) { if (!activeElements || !activeElements.length) return; var datasetIndex = activeElements[0]._datasetIndex; var activeDataset = this.data.datasets[datasetIndex]; this.data.datasets.forEach((dataset, i) => { if (i === datasetIndex) { dataset.borderColor = colors[i]; dataset.pointBorderWidth = 0; dataset.pointHoverBorderWidth = 0; dataset.pointHoverBackgroundColor = 'black'; dataset.pointHoverRadius = 3; } else { dataset.borderColor = ''; dataset.pointRadius = 0; dataset.pointBorderWidth = 0; } }); this.update(); }, hover: { mode: 'nearest', intersect: false }, legend: { display: false }, scales: { yAxes: [ { ticks: { max: queryScale }, gridLines: { display: false } } ], xAxes: [ { gridLines: { display: false } } ] }, tooltips: { mode: 'nearest', intersect: false, bodyFontColor: 'black', titleFontColor: 'black', backgroundColor: 'rgba(0,0,0,0)', custom: function(tooltip) { if (!tooltip) return; // disable displaying the color box; tooltip.displayColors = false; }, callbacks: { label: (tooltipItem, data) => { let label = [data.datasets[tooltipItem.datasetIndex].label] || ''; if (label && label.length) { label.push( 'Gross margin: ' + Math.round(tooltipItem.yLabel).toLocaleString() + ' €/ha' ); if (data.datasets[tooltipItem.datasetIndex].laborRequirement) { label.push( 'Total labor requirement: ' + Math.round( data.datasets[tooltipItem.datasetIndex].laborRequirement ) + ' h/ha' ); } } return label; } } }, plugins: { deferred: { // yOffset: '100%', // defer until 50% of the canvas height are inside the viewport delay: 1500 // delay of 500 ms after the canvas is considered inside the viewport } } } })33:T468,update = (curDist, curSize, curLaborCosts, curRegion, curMethod) => { for (let i = 0; i < chart.data.datasets.length; i++) { const crop = Object.keys(sgms)[i]; const cropData = sgms[crop] .filter(r => r.region === curRegion) .sort((a, b) => a.year - b.year); const laborRequirement = requiredWorkingHours(crop, curSize, curDist); for (let j = 0; j < chart.data.datasets[i].data.length; j++) { chart.data.datasets[i].laborRequirement = laborRequirement; const contributionMargin = cropData[j].sdb - predict( variableMachineCostsRegressionCoefficients[crop].varCosts, curSize, curDist ); if (curMethod === 'Contribution Margin') { chart.data.datasets[i].data[j] = contributionMargin; } else { chart.data.datasets[i].data[j] = contributionMargin - predict( variableMachineCostsRegressionCoefficients[crop].fixCosts, curSize, curDist ) - laborRequirement * calcNetLaborCosts(curLaborCosts); } } } chart.update(); }34:T408,codes = ({ "konventionell/integriert::Mais - Körnermais::wendend, gezogene Saatbettbereitung, Saat": 171, "konventionell/integriert::Mais - Silomais::wendend, gezogene Saatbettbereitung, Saat": 411, "konventionell/integriert::Sommerackerbohnen - Körnergewinnung::wendend, gezogene Saatbettbereitung, Saat": 220, "konventionell/integriert::Sommerhafer - Futterhafer::wendend, gezogene Saatbettbereitung, Saat": 143, "konventionell/integriert::Speisekartoffeln::wendend, gezogene Saatbettbereitung, Legen": 602, "konventionell/integriert::Wintergerste - Futtergerste::wendend, gezogene Saatbettbereitung, Saat": 131, "konventionell/integriert::Winterraps::wendend, gezogene Saatbettbereitung, Saat": 311, "konventionell/integriert::Winterroggen - Mahl- und Brotroggen::wendend, gezogene Saatbettbereitung, Saat": 121, "konventionell/integriert::Winterweizen - Brotweizen::wendend, gezogene Saatbettbereitung, Saat": 115, "konventionell/integriert::Zuckerrüben::wendend, gezogene Saatbettbereitung, Saat": 603 })35:T11f0,Chart = { const Chart = (window.Chart = await require('https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.bundle.js')); // src of the deferred plugin, as requiring bundled versions fails var helpers = Chart.helpers; var STUB_KEY = '$chartjs_deferred'; var MODEL_KEY = '$deferred'; /** * Plugin based on discussion from Chart.js issue #2745. * @see https://github.com/chartjs/Chart.js/issues/2745 */ Chart.defaults.global.plugins.deferred = { xOffset: 0, yOffset: 0, delay: 0 }; function defer(fn, delay) { if (delay) { window.setTimeout(fn, delay); } else { helpers.requestAnimFrame.call(window, fn); } } function computeOffset(value, base) { var number = parseInt(value, 10); if (isNaN(number)) { return 0; } else if (typeof value === 'string' && value.indexOf('%') !== -1) { return (number / 100) * base; } return number; } function chartInViewport(chart) { var options = chart[MODEL_KEY].options; var canvas = chart.chart.canvas; // http://stackoverflow.com/a/21696585 if (!canvas || canvas.offsetParent === null) { return false; } var rect = canvas.getBoundingClientRect(); var dy = computeOffset(options.yOffset || 0, rect.height); var dx = computeOffset(options.xOffset || 0, rect.width); return ( rect.right - dx >= 0 && rect.bottom - dy >= 0 && rect.left + dx <= window.innerWidth && rect.top + dy <= window.innerHeight ); } function onScroll(event) { var node = event.target; var stub = node[STUB_KEY]; if (stub.ticking) { return; } stub.ticking = true; defer(function() { var charts = stub.charts.slice(); var ilen = charts.length; var chart, i; for (i = 0; i < ilen; ++i) { chart = charts[i]; if (chartInViewport(chart)) { unwatch(chart); // eslint-disable-line chart[MODEL_KEY].appeared = true; chart.update(); } } stub.ticking = false; }); } function isScrollable(node) { var type = node.nodeType; if (type === Node.ELEMENT_NODE) { var overflowX = helpers.getStyle(node, 'overflow-x'); var overflowY = helpers.getStyle(node, 'overflow-y'); return ( overflowX === 'auto' || overflowX === 'scroll' || overflowY === 'auto' || overflowY === 'scroll' ); } return node.nodeType === Node.DOCUMENT_NODE; } function watch(chart) { var canvas = chart.chart.canvas; var parent = canvas.parentElement; var stub, charts; while (parent) { if (isScrollable(parent)) { stub = parent[STUB_KEY] || (parent[STUB_KEY] = {}); charts = stub.charts || (stub.charts = []); if (charts.length === 0) { helpers.addEvent(parent, 'scroll', onScroll); } charts.push(chart); chart[MODEL_KEY].elements.push(parent); } parent = parent.parentElement || parent.ownerDocument; } } function unwatch(chart) { chart[MODEL_KEY].elements.forEach(function(element) { var charts = element[STUB_KEY].charts; charts.splice(charts.indexOf(chart), 1); if (!charts.length) { helpers.removeEvent(element, 'scroll', onScroll); delete element[STUB_KEY]; } }); chart[MODEL_KEY].elements = []; } Chart.plugins.register({ id: 'deferred', beforeInit: function(chart, options) { chart[MODEL_KEY] = { options: options, appeared: false, delayed: false, loaded: false, elements: [] }; watch(chart); }, beforeDatasetsUpdate: function(chart, options) { var model = chart[MODEL_KEY]; if (!model.loaded) { if (!model.appeared && !chartInViewport(chart)) { // cancel the datasets update return false; } model.appeared = true; model.loaded = true; unwatch(chart); if (options.delay > 0) { model.delayed = true; defer(function() { model.delayed = false; chart.update(); }, options.delay); return false; } } if (model.delayed) { // in case of delayed update, ensure to block external requests, such // as interacting with the legend label, or direct calls to update() return false; } }, destroy: function(chart) { unwatch(chart); } }); console.log(Chart.plugins); return Chart; }36:T8e8,input = (settings = {}, type) => { if (typeof settings != 'object') return 'Please provide a value!'; let theme = settings.theme ? settings.theme : 'default', initialize = settings.initialize != undefined ? settings.initialize : true, on = type == 'button' ? 'onclick' : type == 'select' ? 'onchange' : 'oninput'; setGlobalStyles(theme); let objs = { title: createElement('title', settings.title, theme, settings), desc: createElement('desc', settings.desc, theme, settings), output: type == 'slider' ? createElement('output', settings.value, theme, settings) : type == 'checkbox' ? createElement('output', settings.label, theme, settings) : '', settings, value: settings.value }; objs.additionalElement = settings.additionalElement ? createElement( settings.additionalElement.name, settings.additionalElement.value, theme, settings ) : ''; (objs[type] = createElement(type, settings.value, theme, settings)), (objs.div = createElement( 'div', [objs.title, objs[type], objs.output, objs.additionalElement, objs.desc], theme, settings )); objs[type][on] = () => { if (!settings.preventUpdate) { objs.div.update(); } if (type == 'slider') objs.progress = (objs.value - settings.min) / (settings.max - settings.min); if (settings.utilities) { for (let [key, func] of Object.entries(settings.utilities)) { func(settings[key], objs); } } if (settings[on]) settings[on](objs); }; objs.div.update = (value = objs[type].value || settings.value) => { value = isNaN(value) ? value : +value; if (type == 'checkbox' && objs.value != false) value = false; else if (type == 'checkbox') value = settings.value; objs.value = value; if (type != 'select') objs[type].value = value; objs.div.value = objs.value; if (type != 'checkbox' && objs.output) objs.output.textContent = objs.value; objs.div.dispatchEvent(new CustomEvent('input')); }; if (settings.preventUpdate) objs.div.update(); if (initialize) { objs[type][on](); } else if (!settings.preventUpdate) { objs.div.update(); } return objs.div; }37:T65a,createElement = (type, text = '', theme = '', settings = '') => { if (text == undefined) return ''; text = type != 'slider' && type != 'checkbox' ? text : ''; let typesMapping = { title: { tag: 'div', mandatoryAttrs: { class: 'title' } }, button: { tag: 'button', mandatoryAttrs: {} }, checkbox: { tag: 'input', mandatoryAttrs: { type: 'checkbox', value: settings.value } }, select: { tag: 'select', mandatoryAttrs: {} }, slider: { tag: 'input', mandatoryAttrs: { type: 'range', min: settings.min, max: settings.max, step: settings.step, value: settings.value } }, output: { tag: 'span', mandatoryAttrs: { class: 'output' } }, desc: { tag: 'div', mandatoryAttrs: { class: 'desc' } }, div: { tag: 'div', mandatoryAttrs: { class: `input-${theme}` } }, caret: { tag: 'svg', mandatoryAttrs: { class: 'caret' } } }; let el = html`<${typesMapping[type].tag}>${text}`; Object.entries(typesMapping[type].mandatoryAttrs).forEach(d => el.setAttribute(d[0], d[1]) ); if (typeof settings[type + 'Attrs'] == 'object') Object.entries(settings[type + 'Attrs']).forEach(d => { if (d[0] == 'class') el.classList.add(d[1]); else el.setAttribute(d[0], d[1]); }); if (typeof settings[type + 'Style'] == 'object') Object.entries(settings[type + 'Style']).forEach( d => (el.style[d[0]] = d[1]) ); return el; }38:T444,setSliderBackground = (settings, objs) => { let type = settings.type, color = settings.color, colors = settings.colors, progress = objs.progress, interpolation = settings.interpolation, custom = false; if (!interpolation) interpolation = d3.interpolate; else custom = true; type == 'normal' ? (objs.slider.style.background = color) : type == 'double' ? (objs.slider.style.background = `linear-gradient(90deg, ${ colors[0] } ${progress * 100}%, ${colors[1]} 0%)`) : type == 'interpolate' ? (objs.slider.style.background = custom ? interpolation(progress) : interpolation(colors[0], colors[1])(progress)) : type == 'progress' ? custom ? (objs.slider.style.background = `linear-gradient(90deg, ${interpolation( progress )} ${progress * 100}%, ${color || interpolation(0)} 0%)`) : (objs.slider.style.background = `linear-gradient(90deg, ${interpolation( colors[0], colors[1] )(progress)} ${progress * 100}%, ${colors[2] || colors[0]} 0%)`) : 0; }39:Tbd8,themes = ` .input-default button, .input-white button, .input-default select, .input-white select { outline: none; -webkit-appearance: none; -moz-appearance: none; appearance: none; opacity: 0.9; height: 30px; margin-left: 0px; padding: 5px 10px 5px 10px; background: #EFEFEF; border: 0.5px solid white; border-radius: 5px; color: #262626; font-family: Avenir, Arial; font-size: 12px; font-weight: 600; cursor: pointer; } .input-white button, .input-white select { color: white; } .input-default select, .input-white select { padding-right: 29px; } .input-default .caret, .input-white .caret { width: 12px; height: 10px; margin-left: -24px; fill: black; pointer-events: none; opacity: 0.75; } .input-white .caret { fill: white; } .input-default input[type = 'range'], .input-default-thin input[type = 'range'], .input-default-round input[type = 'range'], .input-white input[type = 'range'], .input-white-thin input[type = 'range'], .input-white-round input[type = 'range'] { appearance: none; -webkit-appearance: none; width: 200px; height: 5px; border-radius: 1px; background: #E5E5E5; } .input-default input[type = 'range']::-webkit-slider-thumb, .input-white input[type = 'range']::-webkit-slider-thumb { appearance: none; -webkit-appearance: none; width: 15px; height: 15px; background: #545454; cursor: pointer; border: none; border-radius: 5px; } .input-white input[type = 'range']::-webkit-slider-thumb { background: #FCFCFC; border: 1px solid #545454; } .input-default-thin input[type = 'range']::-webkit-slider-thumb, .input-white-thin input[type = 'range']::-webkit-slider-thumb { appearance: none; -webkit-appearance: none; width: 7.5px; height: 20px; background: #545454; cursor: pointer; border: none; border-radius: 2.5px; } .input-white-thin input[type = 'range']::-webkit-slider-thumb { background: #FCFCFC; border: 1px solid #545454; } .input-default-round input[type = 'range']::-webkit-slider-thumb, .input-white-round input[type = 'range']::-webkit-slider-thumb { appearance: none; -webkit-appearance: none; width: 15px; height: 15px; background: #545454; cursor: pointer; border: none; border-radius: 7.5px; } .input-white-round input[type = 'range']::-webkit-slider-thumb { background: #FCFCFC; border: 1px solid #545454; } input[type = 'range']:focus { outline: none; } .output { margin-left: 5px; color: #262626; font-family: Courier; font-size: 14px; } .title { margin-bottom: 3.5px; margin-left: 2.5px; color: black; font-family: Avenir, Arial; font-size: 14px; font-weight: 600; } .desc { margin-top: 6px; margin-left: 2.5px; color: #4C4C4C; font-family: Avenir, Arial; font-size: 12px; } `3a:T492,highlightSlider = (settings, objs) => { settings.lowerAdj = (100 * (settings.lower - objs.settings.min)) / (objs.settings.max - objs.settings.min); settings.upperAdj = (100 * (settings.upper - objs.settings.min)) / (objs.settings.max - objs.settings.min); if (settings.preventUpdate) objs.settings.preventUpdate = true; if ( +objs.slider.value == settings.lower || +objs.slider.value == settings.upper ) { objs.div.update(objs.slider.value); } if ( +objs.slider.value < settings.lower || +objs.slider.value > settings.upper ) { objs.div.update(objs.slider.value); objs.slider.style.background = `linear-gradient(90deg, ${settings.colors.normal} ${settings.lowerAdj}%, ${settings.colors.inactive} ${settings.lowerAdj}%, ${settings.colors.inactive} ${settings.upperAdj}%, ${settings.colors.normal} 0%)`; } else { objs.slider.style.background = `linear-gradient(90deg, ${settings.colors.normal} ${settings.lowerAdj}%, ${settings.colors.active} ${settings.lowerAdj}%, ${settings.colors.active} ${settings.upperAdj}%, ${settings.colors.normal} 0%)`; } }3b:[] 2f:{"title":"Profitability of crop cultivation in Germany","cells":[{"id":0,"value":"md`# Profitability of crop cultivation in Germany`","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"md`This timeseries chart highlights the volatility of crop contribution margins (optionally direct- and labor-cost free revenue) for a selection of crops in Germany. \nYou can adjust the average distance, plot size, and labor costs used for the calculation with the respective sliders. Observe how these factors influence the economic indicators by hovering over the lines in the chart!`","pinned":false,"hidden":false,"mode":"ojs"},{"id":492,"value":"viewof regionAndMethod = {\n const div = html`

`;\n div.style.display = 'flex';\n div.style.flexWrap = 'wrap';\n\n const region = select({\n title: \"Select a region\",\n description: \"\",\n options: regions,\n value: \"Deutschland\"\n });\n\n region.style.marginRight = '40px';\n\n region.querySelector('select[name=\"input\"]').onchange = e => {\n div.value.region = e.target.value;\n };\n\n const method = select({\n title: \"Select an economic indicator\",\n description: \"\",\n options: ['Contribution Margin', 'Direct- and labor-cost free revenue'],\n value: \"Deutschland\"\n });\n\n method.querySelector('select[name=\"input\"]').onchange = e => {\n div.value.method = e.target.value;\n };\n\n div.value = {\n region: region.value,\n method: method.value\n };\n\n div.append(region, method);\n return div;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":518,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":187,"value":"c = DOM.canvas(width, width / 1.6)","pinned":false,"hidden":false,"mode":"ojs"},{"id":169,"value":"md`*Sources: [KTBL SDB](https://daten.ktbl.de/sdb/welcome.do) for timeseries data, variable cost and time requirement regression based on [KTBL Verfahrensrechner Pflanze](https://daten.ktbl.de/vrpflanze/), 120 kW mechanisation*`","pinned":false,"hidden":false,"mode":"ojs"},{"id":343,"value":"md`To distinguish crops with a gross margin lower than 1000 € per ha, you can adjust the maximum y-axis value to be displayed.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":318,"value":"viewof scale = slider({\n min: 500,\n max: 8000,\n step: 50,\n value: queryScale,\n oninput: updateScale,\n title: \"Y-Axis scale\",\n desc:\n \"Adjust the maximum y-axis value, improving readability of crops wiht gross margins below 1000 Euro per ha\",\n theme: 'default-round',\n background: {\n type: 'double',\n colors: ['#79ae98', 'white']\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":643,"value":"md`### Definitions`","pinned":false,"hidden":false,"mode":"ojs"},{"id":648,"value":"md`#### Contribution margin\nThe contribution margin equals the revenue of a production process subtracted by its variable costs. The variable costs are a composite of direct costs (seeds, fertilizer, pesticides) and variable operating costs. The contribution margin covers the fix unit- and overhead costs.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":656,"value":"md`#### Direct- and labor-cost free revenue\n\nThe direct- and labor-cost free revenue (DLFR) is calculated by subtracting the fixed operation costs from the contribution margin of a production process. The DLFR covers the remaining fixed costs such as buildings, rent (incl. land rent), legal costs, as well as other overhead costs. As the DLFR includes the fixed costs of labor (opposed to the contribution margin), it reflects the effects of varying occupancy on the profitability of an operation.\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":182,"value":"md`### Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":665,"value":"md`This part of the notebook contains the relevant code for the calculation of the economic indicators.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":629,"value":"function calcNetLaborCosts(grossWageRate) {\n // calculation according to dlz agrarmanagement (Jan.2013, p. 112ff)\n // using the table presented on page 114, we simplify the calculation of the social security costs by\n // assuming an average expenditure of 22% of the gross wage rate on social security\n const socialSecurityCosts = grossWageRate * 0.22;\n // we assume a workload of 174 hours per month (2088 hours per year)\n const yearlyNetCosts = 12 * 174 * (grossWageRate + socialSecurityCosts);\n // However, 296 hours are reduced accounting for vacation and public holidays, resulting in an effective\n // yearly workload of 1792 hours\n const netWageRate = yearlyNetCosts / 1792;\n return netWageRate;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":61,"value":"function predict(y,size,distance) {\n return y[0]\n + y[1] * size\n + y[2] * Math.pow(size,2)\n + y[3] * distance\n + y[4] * size * distance\n + y[5] * Math.pow(distance,2)\n }","pinned":true,"hidden":false,"mode":"ojs"},{"id":190,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":670,"value":"shouldDisplayWageRate = regionAndMethod.method ===\n \"Direct- and labor-cost free revenue\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":564,"value":"updatedParams = {\n return update(\n parameters.distance,\n parameters.plotSize,\n parameters.laborCosts,\n regionAndMethod.region,\n regionAndMethod.method\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":725,"value":"Object.keys(codes).reduce((arr, crop) => {\n const data = sgms[crop].filter(\n (r) => r.region === \"Brandenburg\" && r.year > 2013 && r.year < 2017\n );\n arr.push({\n Crop: crop,\n Price: d3.mean(data.map((p) => p.price)),\n \"Direct costs\": d3.mean(\n data.map((p) => p.seeds + p.fertilizer + p.pesticides + p.others)\n ),\n \"Variable costs\": predict(\n variableMachineCostsRegressionCoefficients[crop].varCosts,\n 17,\n 2\n )\n });\n return arr;\n}, [])","pinned":true,"hidden":false,"mode":"ojs"},{"id":238,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":321,"value":"updateScale = obj => {\n chart.options.scales.yAxes[0].ticks.max = obj.value;\n chart.update();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":26,"value":"pricesYieldsDirectCosts = fetch('https://gist.githubusercontent.com/chrispahm/924186da3e88c7d2cac8d7bc5a858eae/raw/b2a5061cd5174b963ad1d000f1a51bbf85db8d0c/pricesYieldsDirectCosts.json').then(res => res.json())","pinned":false,"hidden":false,"mode":"ojs"},{"id":31,"value":"variableMachineCostsRegressionCoefficients = fetch(\n 'https://gist.githubusercontent.com/chrispahm/659f263a1a5dc17dd24bf86a0524472f/raw/99c08dd74893e69bac5c7dea7b4496d2250486c3/crop_regression_coefficients.json'\n).then(res => res.json())","pinned":false,"hidden":false,"mode":"ojs"},{"id":708,"value":"{\n const data = [];\n for (const crop in variableMachineCostsRegressionCoefficients) {\n for (const key in variableMachineCostsRegressionCoefficients[crop]) {\n const coefficients = variableMachineCostsRegressionCoefficients[crop][\n key\n ].map((c, i) => {\n data.push({\n crop: codes[crop],\n key,\n coeff: \"c\" + i,\n value: c\n });\n }); //.reduce((coeff, cur, i) => ((coeff[\"c\" + i] = cur), coeff), {});\n }\n }\n return data;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":716,"value":"$34","pinned":true,"hidden":false,"mode":"ojs"},{"id":390,"value":"requiredWorkingHours = (crop, curSize, curDist) => {\n const months = [\n 'JAN',\n 'FEB',\n 'MRZ',\n 'APR',\n 'MAI',\n 'JUN',\n 'JUL',\n 'AUG',\n 'SEP',\n 'OKT',\n 'NOV',\n 'DEZ'\n ];\n return months.reduce(\n (total, month) =>\n (total += predict(\n variableMachineCostsRegressionCoefficients[crop][month],\n curSize,\n curDist\n )),\n 0\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":49,"value":"colors = [\n '#d6e5cd',\n '#eccb89',\n '#d48544',\n '#9b643b',\n '#8db867',\n '#9dd5c0',\n '#79ae98',\n '#a9dbd4',\n '#b5dce1',\n '#c3d1da',\n '#d0d1d3',\n '#daccc3',\n '#b5dce1'\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":689,"value":"d3.mean(\n sgms[\n \"konventionell/integriert::Mais - Silomais::wendend, gezogene Saatbettbereitung, Saat\"\n ]\n .filter((r) => r.region === \"Nordrhein-Westfalen\" && r.year > 2014)\n .map((r) => r.price)\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":480,"value":"sgms = fetch(\n 'https://gist.githubusercontent.com/chrispahm/fd954aefae26e709bcbd9fa9e9dc78d7/raw/d1e9cb7f66837a6f96c0f48b022c537ef820b1c5/crop_sgms.json'\n).then(res => res.json())","pinned":false,"hidden":false,"mode":"ojs"},{"id":484,"value":"regions = [...new Set(sgms[Object.keys(sgms)[0]].map(r => r.region))]","pinned":false,"hidden":false,"mode":"ojs"},{"id":636,"value":"netWageRate = calcNetLaborCosts(parameters.laborCosts)","pinned":false,"hidden":false,"mode":"ojs"},{"id":13,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":334,"value":"queryScale = {\n const value = location.search.split('?scale=');\n if (value.length > 1) {\n return Number(value[1]);\n } else return 8000;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":226,"value":"md`### Range slider code from https://observablehq.com/@shedali/diy-inputs`","pinned":false,"hidden":false,"mode":"ojs"},{"id":208,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":212,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":215,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":218,"value":"setGlobalStyles = function(style) {\n d3.selectAll('.inputStyles')\n .data([style])\n .enter()\n .append('style')\n .attr('class', 'inputStyles')\n .html(themes);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":683,"value":"concious_analytics(html``.href)","pinned":false,"hidden":false,"mode":"ojs"},{"id":686,"value":"import { concious_analytics } from 'ff90685a875a43ac'","pinned":false,"hidden":false,"mode":"ojs"},{"id":220,"value":"$39","pinned":false,"hidden":false,"mode":"ojs"},{"id":223,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"slider = (settings = {}) => {\n settings.min =\n settings.min == undefined ? settings.max - 1 || 0 : settings.min;\n settings.max = settings.max || settings.min + 1 || 1;\n settings.value =\n settings.value == undefined\n ? (settings.min + settings.max) / 2\n : settings.value;\n settings.step =\n settings.step ||\n (settings.max > settings.min\n ? (settings.max - settings.min) / 10\n : (settings.min - settings.max) / 10) ||\n 0.1;\n\n settings.utilities = {};\n\n if (settings.background) {\n settings.utilities.background = setSliderBackground;\n }\n\n if (settings.highlight) {\n settings.utilities.highlight = highlightSlider;\n }\n\n return input(settings, 'slider');\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":489,"value":"import { select } from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":206,"value":"d3 = require('d3@5')","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W3b","stdlib":"1","titling":"auto"}