1d:{"title":"Discover Solutions","cells":[{"id":5228,"value":"{\n const imgSource = {\n en: FileAttachment(\n \"Discover-solutions.webp\"\n ).url(),\n fr: FileAttachment(\"Discover-solutions-fr.webp\").url()\n };\n const imgUrl = _lang(imgSource);\n return htl.html`

${notebookTitle}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5227,"value":"// pretty view of language toggle\nviewof prettyLanguageView = {\n return Inputs.bind(\n Inputs.radio(languages, {\n label: _lang(nbText.supportNbText.labels.language),\n format: (d) => d.label\n }),\n viewof language\n );\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4753,"value":"tocOneliner({\n heading: `${_lang(nbText.supportNbText.labels.tocTitle)}`,\n skip: [notebookTitle, \"Chopping block\", \"Appendix\"], \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":0,"value":"# ${_lang(nbText.overview.h1)}","pinned":false,"hidden":false,"mode":"md"},{"id":5224,"value":"$${_lang(nbText.overview.blocks.opener1)}","pinned":false,"hidden":false,"mode":"md"},{"id":5708,"value":"industries = await FileAttachment(\"industries (1).csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5773,"value":"SELECT date FROM \"industries (1)\"","pinned":true,"hidden":false,"mode":"sql","output":"","database":"industries (1).csv"},{"id":5722,"value":"Plot.plot({\n marks: [\n Plot.auto(industries, {x: \"unemployed\", y: \"industry\", color: \"#65a7ff\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5756,"value":"#### Fig 1 Bar chart","pinned":false,"hidden":false,"mode":"md"},{"id":5758,"value":"- text\n- text 2\n- text3 ","pinned":false,"hidden":false,"mode":"md"},{"id":5764,"value":"1. text\n2. text 2\n3. text 3","pinned":false,"hidden":false,"mode":"md"},{"id":5772,"value":"image1 = FileAttachment(\"image (1).png\").image()","pinned":true,"hidden":false,"mode":"ojs"},{"id":2983,"value":"# ${_lang(nbText.interventions.h1)}","pinned":false,"hidden":false,"mode":"md"},{"id":5222,"value":"{\n // find total observations\n const raw = d3.sum(\n data_extendedTable2_total,\n (d) => d.observations\n );\n const formatted = Math.round(raw / 1000) * 1000;\n const totalObs = formatNumStandard(formatted, {\n locale: language.locale\n });\n\n const langString = _lang(nbText.interventions.blocks.opener1);\n const formattedString = langString.replace(\n Lang.getRegexForNamedInsertion(\"totalObs\"),\n totalObs\n );\n\n return md`${formattedString}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5273,"value":"viewof selectPracticeInterventions = {\n const data = [...new Set(data_extendedTable2_total.map((d) => d.practice))]\n .map((d) => {\n return { field: d, translation: td.Practice.values?.[d] };\n })\n .sort((a, b) => _lang(a.translation) > _lang(b.translation));\n const nullValue = {\n field: null,\n translation: nbText.inputs.defaults.practice\n };\n const inputData = [nullValue, ...data];\n return Inputs.select(inputData, {\n label: _lang(td.Practice),\n format: (x) => _lang(x.translation)\n });\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":3780,"value":"$1f","pinned":false,"hidden":false,"mode":"ojs"},{"id":5552,"value":"$20","pinned":false,"hidden":false,"mode":"ojs"},{"id":5278,"value":"$21","pinned":false,"hidden":false,"mode":"ojs"},{"id":2991,"value":"# ${_lang(nbText.practicalImpact.meanCropDiff.h1)}","pinned":false,"hidden":false,"mode":"md"},{"id":2993,"value":"$${_lang(nbText.practicalImpact.meanCropDiff.blocks.opener1)}","pinned":false,"hidden":false,"mode":"md"},{"id":4750,"value":"## ${_lang(nbText.practicalImpact.meanCropDiff.h2.meanDiff)}","pinned":false,"hidden":false,"mode":"md"},{"id":5053,"value":"viewof selectCropMeanDiff_new ={\n if (!data_meanDiff_practiceCrop_new || !Array.isArray(data_meanDiff_practiceCrop_new)) {\n return Inputs.select([], {\n label: _lang(td.Crop),\n format: (x) => x ? _lang(x.translation) : ''\n });\n }\n \n const data = [...new Set(data_meanDiff_practiceCrop_new\n .map((d) => d?.Crop)\n .filter((crop) => crop && typeof crop === 'string'))]\n .filter((d) => !d.includes('-001') && !d.includes('-002')) // Exclude sub-species from main dropdown\n .map((d) => {\n return { field: d, translation: td.Crop.values?.[d] };\n })\n .sort((a, b) => _lang(a.translation) > _lang(b.translation));\n return Inputs.select(data, {\n label: _lang(td.Crop),\n value: data.find(x => x.field == 'Maize'),\n format: (x) => _lang(x.translation)\n });\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5375,"value":"$22","pinned":false,"hidden":false,"mode":"ojs"},{"id":5052,"value":"viewof radioSortDotPlotCrop_new = {\n const data = [\n {\n key: \"mean\",\n label: _lang(nbText.inputs.radioSort.fields.mean),\n channel: \"x\",\n reverse: true,\n },\n {\n key: \"observations\",\n label: _lang(nbText.inputs.radioSort.fields.observations),\n channel: \"nObs\",\n reverse: true,\n },\n {\n key: \"alpha\",\n label: _lang(nbText.inputs.radioSort.fields.alpha),\n channel: \"y\",\n reverse: false,\n },\n ]\n return Inputs.radio(data, { label: _lang(nbText.supportNbText.labels.sort), format: d => d.label, value: data.find(x => x.key === 'mean') });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5051,"value":"viewof toggleCIsCrop_new = {\n const data = [\n _lang(nbText.practicalImpact.inputs.toggleConfInt.fields.visible)\n ]\n return Inputs.checkbox(data, {\n label: _lang(nbText.supportNbText.labels.confidenceIntervals)\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5214,"value":"$23","pinned":false,"hidden":false,"mode":"ojs"},{"id":5562,"value":"$24","pinned":false,"hidden":false,"mode":"ojs"},{"id":5298,"value":"viewof selectPracticeMeanDiff = \n{\n const selectedCrop = selectCropMeanDiff_new.field;\n const selectedSubspecies = selectSubspeciesMeanDiff_new?.field;\n const filterCrop = selectedSubspecies || selectedCrop;\n \n const plotData = data_meanDiff_practiceCrop_new.filter(\n (d) => d.Crop === filterCrop\n );\n const practices = [...new Set(plotData.map((d) => d.Practice))]\n .map((d) => {\n return { field: d, translation: td.Practice.values?.[d] };\n })\n .sort((a, b) => _lang(a.translation) > _lang(b.translation));\n const nullValue = {\n field: null,\n translation: nbText.inputs.defaults.practice\n };\n const inputData = [nullValue, ...practices];\n return Inputs.select(inputData, {\n label: _lang(td.Practice),\n format: (x) => _lang(x.translation)\n });\n}\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5301,"value":"$25","pinned":false,"hidden":false,"mode":"ojs"},{"id":5049,"value":"md`### ${_lang(nbText.supportNbText.labels.quickInsights)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5048,"value":"$26","pinned":false,"hidden":false,"mode":"ojs"},{"id":4746,"value":"## ${_lang(nbText.practicalImpact.meanCropDiffAEZ.h2)}","pinned":false,"hidden":false,"mode":"md"},{"id":5210,"value":"md`${_lang(nbText.practicalImpact.meanCropDiffAEZ.blocks.opener1)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5047,"value":"viewof selectCropMeanDiffAEZ = {\n if (!data_meanDiff_aezPracticeCrop_new || !Array.isArray(data_meanDiff_aezPracticeCrop_new)) {\n return Inputs.select([], {\n label: _lang(td.Crop),\n format: (x) => x ? _lang(x.translation) : ''\n });\n }\n \n const data = [\n ...new Set(data_meanDiff_aezPracticeCrop_new\n .map((d) => d?.Crop)\n .filter((crop) => crop && typeof crop === 'string'))]\n .filter((d) => !d.includes('-001') && !d.includes('-002')) // Exclude sub-species from main dropdown\n .map((d) => {\n return { field: d, translation: td.Crop.values?.[d] };\n })\n .sort((a, b) => _lang(a.translation) > _lang(b.translation));\n return Inputs.select(data, {\n label: _lang(td.Crop),\n value: data.find((x) => x.field == \"Maize\"),\n format: (x) => _lang(x.translation)\n });\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5407,"value":"$27","pinned":false,"hidden":false,"mode":"ojs"},{"id":5046,"value":"viewof radioSortDotPlotCropAEZ_new = {\n const data = [\n {\n key: \"mean\",\n label: _lang(nbText.inputs.radioSort.fields.mean),\n channel: \"x\",\n reverse: true\n },\n {\n key: \"observations\",\n label: _lang(nbText.inputs.radioSort.fields.observations),\n channel: \"nObs\",\n reverse: true\n },\n {\n key: \"alpha\",\n label: _lang(nbText.inputs.radioSort.fields.alpha),\n channel: \"y\",\n reverse: false\n }\n ];\n return Inputs.radio(data, {\n label: _lang(nbText.supportNbText.labels.sort),\n format: (d) => d.label,\n value: data.find((x) => x.key === \"mean\")\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5045,"value":"viewof aezSelect_new = {\n // Use sub-species if selected, otherwise use parent crop\n const filterCrop = selectSubspeciesMeanDiffAEZ?.field || selectCropMeanDiffAEZ?.field;\n const data = data_meanDiff_aezPracticeCrop_new.filter(\n (d) => d.Crop === filterCrop\n );\n const aezNames = d3\n .groups(data, (d) => d.AEZ_Class_FAO)\n .map((d) => d[0])\n .sort();\n const options = aezNames.map((d) => ({\n field: d,\n translation: td.AEZ_Class_FAO.values?.[d]\n }));\n const nullValue = {\n field: null,\n translation: nbText.inputs.defaults.aez\n };\n const inputNames = [nullValue, ...options];\n return Inputs.select(inputNames, {\n label: _lang(nbText.supportNbText.labels.highlightAez),\n value: aezNames,\n format: x => _lang(x.translation)\n });\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5044,"value":"viewof toggleCIsCropAEZ_new = {\n const data = [\n _lang(nbText.practicalImpact.inputs.toggleConfInt.fields.visible)\n ];\n return Inputs.checkbox(data, {\n label: _lang(nbText.supportNbText.labels.confidenceIntervals)\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5043,"value":"$28","pinned":false,"hidden":false,"mode":"ojs"},{"id":5042,"value":"plotDotAEZ_new_legend = {return(\nplotDotAEZ_new.legend('color', {columns: 3})\n)}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5567,"value":"$29","pinned":false,"hidden":false,"mode":"ojs"},{"id":5323,"value":"viewof selectPracticeMeanDiffAEZ = \n{\n // Use sub-species if selected, otherwise use parent crop\n const filterCrop = selectSubspeciesMeanDiffAEZ?.field || selectCropMeanDiffAEZ?.field;\n \n const plotData = data_meanDiff_aezPracticeCrop_new.filter(\n (d) => d.Crop === filterCrop\n );\n const practices = [...new Set(plotData.map((d) => d.Practice))]\n .map((d) => {\n return { field: d, translation: td.Practice.values?.[d] };\n })\n .sort((a, b) => _lang(a.translation) > _lang(b.translation));\n const nullValue = {\n field: null,\n translation: nbText.inputs.defaults.practice\n };\n const inputData = [nullValue, ...practices];\n return Inputs.select(inputData, {\n label: _lang(td.Practice),\n format: (x) => _lang(x.translation)\n });\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5327,"value":"$2a","pinned":false,"hidden":false,"mode":"ojs"},{"id":5041,"value":"md`### ${_lang(nbText.supportNbText.labels.quickInsights)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5203,"value":"$2b","pinned":false,"hidden":false,"mode":"ojs"},{"id":2999,"value":"md`# ${_lang(nbText.risks.h1)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3004,"value":"md`${_lang(nbText.risks.blocks.opener)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3854,"value":"// viewof selectPractice = {\n// const data = [null, ...data_lclRisk.map((d) => d.practice).sort()];\n// return Inputs.select(data, {\n// label: _lang(nbText.supportNbText.labels.highlightPractice),\n// unique: true,\n// value: null\n// });\n// }\nviewof selectPractice = {\n const data = d3\n .groups(\n data_lclRisk.map((d) => d.practice),\n (d) => d\n )\n .map((d) => d[0])\n .sort();\n const options = data.map((d) => {\n return { field: d, translation: td.Practice.values[d] };\n }).sort((a,b) => _lang(a.translation) > _lang(b.translation));\n const nullValue = {\n field: null,\n translation: nbText.inputs.defaults.practice\n };\n const inputData = [nullValue, ...options];\n return Inputs.select(inputData, {\n label: _lang(nbText.supportNbText.labels.highlightPractice),\n format: x => _lang(x.translation)\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":3825,"value":"$2c","pinned":false,"hidden":false,"mode":"ojs"},{"id":5573,"value":"$2d","pinned":false,"hidden":false,"mode":"ojs"},{"id":5337,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs"},{"id":4848,"value":"headerQuickInsights = {\n return md`### ${_lang(nbText.supportNbText.labels.quickInsights)}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4912,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":3015,"value":"md`# ${_lang(nbText.adoptionFactors.h1)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":3021,"value":"md`${_lang(nbText.adoptionFactors.blocks.opener1)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5008,"value":"viewof dataAdoptionFactors_select = {\n const options = [...dataAdoptionFactorsMap.keys()]\n .map((d) => {\n return { field: d, translation: td.practices.values?.[d] };\n })\n .map((d) => {\n if (d.field == \"All practices\")\n return { ...d, translation: nbText.inputs.defaults.practice };\n return { ...d };\n });\n const sorted = [\n ...options\n .filter((d) => d.field == \"All practices\"),\n ...options\n .filter((d) => d.field !== \"All practices\")\n .sort((a, b) => _lang(a.translation) > _lang(b.translation))\n ];\n return Inputs.select(sorted, {\n label: _lang(nbText.supportNbText.words.practice.singular),\n format: (x) => _lang(x.translation)\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5007,"value":"viewof radioSortAdoptionFactors = {\n const data = [\n {\n key: \"observations\",\n label: _lang(nbText.inputs.radioSort.fields.observations),\n channel: \"total\",\n reverse: true,\n },\n {\n key: \"alpha\",\n label: _lang(nbText.inputs.radioSort.fields.alpha),\n channel: \"y\",\n reverse: false,\n },\n ]\n return Inputs.radio(data, { label: _lang(nbText.supportNbText.labels.sortBars), format: d => d.label, value: data.find(x => x.key === 'observations') });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5622,"value":"viewof adoptionFactorsChartType =\n{\n return Inputs.radio(\n [\"bar\", \"line\"],\n {\n label: \"Chart Type\",\n format: (d) => d === \"bar\" ? \"Bar Chart\" : \"Line Chart\",\n value: \"bar\"\n }\n );\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5006,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":5586,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":5360,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":5358,"value":"selectAdoptionFactor =\n{\n // Get unique factors from the current practice's data\n const plotData = dataAdoptionFactorsMap.get(dataAdoptionFactors_select.field);\n const uniqueFactors = [...new Set(plotData.map(d => d.factor))].sort();\n \n const options = uniqueFactors.map((d) => {\n return { field: d, translation: td.adoption_factors.values?.[d] };\n }).sort((a, b) => _lang(a.translation) > _lang(b.translation));\n \n const nullValue = {\n field: null,\n translation: { en: \"None\", am: \"ምንም\" }\n };\n \n const inputData = [nullValue, ...options];\n return Inputs.select(inputData, {\n label: _lang(nbText1.adoptionFactors.title),\n format: x => _lang(x.translation)\n });\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5005,"value":"md`### ${_lang(nbText.supportNbText.labels.quickInsights)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5004,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":3024,"value":"md`# ${_lang(nbText.summary.h1)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4946,"value":"md`${_lang(nbText.summary.blocks.opener1)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4945,"value":"md`${_lang(nbText.summary.blocks.opener2)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":4944,"value":"// // dropdown of practices\n// viewof selectResourcePractice = {\n// const data = _.uniq(csaManuals.map(d => d.practice)).sort()\n// return Inputs.select(data, { label: _lang(nbText.supportNbText.words.practice.singular), value: 'Inorganic Fertilizer' });\n// }\n\n// dropdown of practices\nviewof selectResourcePractice = {\n const data = _.uniq(csaManuals.map((d) => d.practice))\n .map((d) => {\n return { field: d, translation: td.summaryPractices.values?.[d] };\n })\n .sort((a, b) => _lang(a.translation) > _lang(b.translation));\n\n return Inputs.select(data, {\n label: _lang(nbText.supportNbText.words.practice.singular),\n format: x => _lang(x.translation),\n value: data.find(x => x.field == \"Inorganic Fertilizer\")\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4943,"value":"html`${csaResourceHtml}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5368,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":5185,"value":"{\n const text = _lang(nbText.methodsSources.h1)\n return md`# ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5184,"value":"{\n const text = _lang(nbText.methodsSources.intro)\n return md` ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5183,"value":"{\n const text = _lang(nbText.methodsSources.h2DataSources)\n return md`## ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5182,"value":"{\n const text = _lang(nbText.methodsSources.h2DataSourcesSubsection)\n return md` ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5181,"value":"{\n const text = _lang(nbText.methodsSources.h2Methods)\n return md`## ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5180,"value":"{\n const text = _lang(nbText.methodsSources.h3Era)\n return md`### ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5179,"value":"{\n const text = _lang(nbText.methodsSources.h3EraSubsection)\n return md` ${text}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":49,"value":"***\n# Appendix\nThis large section includes all the cells that power the notebook.","pinned":false,"hidden":false,"mode":"md"},{"id":1258,"value":"---\n## Work by Topic\n*Cells that power different sections*","pinned":false,"hidden":false,"mode":"md"},{"id":1747,"value":"---\n### Notebook Variables\n_Main variables across notebook_","pinned":false,"hidden":false,"mode":"md"},{"id":1746,"value":"// main title of the notebook\nnotebookTitle = \"Discover Solutions\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5177,"value":"**Language and notebook text**","pinned":false,"hidden":false,"mode":"md"},{"id":5176,"value":"import { Lang } from \"9d356dc4e71e8295\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5175,"value":"Lang","pinned":false,"hidden":false,"mode":"ojs"},{"id":5174,"value":"languages = [\n { key: \"en\", label: \"English\", locale: 'en-US' },\n { key: \"am\", label: \"አማርኛ\", locale: 'am-ET' },\n {key: \"or\", label: \"Afaan Oromoo\", locale: 'or-ET'},\n {key: \"ti\", label: \"ትግርኛ\", locale: 'ti-ET'},\n {key: \"so\", label: \"Soomaali\", locale: 'so-ET'},\n {key: \"af\", label: \"Qafar af\", locale: 'af-ET'}\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":5173,"value":"// get the default language key from parameter, or use default\ndefaultLangKey = {\n const name = \"lang\";\n const list = languages.map((d) => d.key);\n const defaultKey = \"en\";\n\n const queryParam = await Lang.getParamFromList({ name, list });\n\n return queryParam ?? defaultKey;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5172,"value":"// helper shorthand for Lang text-getting\n_lang = Lang.lg(language.key)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5171,"value":"// main toggle of language key\nviewof language = Inputs.radio(languages, {\n label: \"Main language toggle\",\n format: (d) => d.key,\n value: languages.find((x) => x.key === defaultLangKey),\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5630,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":5687,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":5692,"value":"$37","pinned":false,"hidden":false,"mode":"ojs"},{"id":5641,"value":"$38","pinned":false,"hidden":false,"mode":"ojs"},{"id":5637,"value":"$39","pinned":false,"hidden":false,"mode":"ojs"},{"id":5650,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs"},{"id":5170,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs"},{"id":5169,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs"},{"id":5341,"value":"$3d","pinned":false,"hidden":false,"mode":"ojs"},{"id":4739,"value":"---\n### Notebook Styling\n*styling helpers*\nStylesheet is a named cell, which is necessary to include for embeds.","pinned":false,"hidden":false,"mode":"md"},{"id":4738,"value":"**CSS styling**","pinned":false,"hidden":false,"mode":"md"},{"id":4737,"value":"viewof toggleCustomStyling = Inputs.toggle({label: \"Use custom styling\", value: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":4736,"value":"$3e","pinned":false,"hidden":false,"mode":"ojs"},{"id":4735,"value":"**Table of Contents**","pinned":false,"hidden":false,"mode":"md"},{"id":4734,"value":"$3f","pinned":false,"hidden":false,"mode":"ojs"},{"id":4733,"value":"---\n### Dev notes\nHelper to include dev notes, but keep them out of sight","pinned":false,"hidden":false,"mode":"md"},{"id":4732,"value":"function makeDevNotes({\n // adding dev notes as a html summary (collapsible)\n title = \"Plot dev notes\",\n emojis = \"👆🛠\",\n text = md`Update this text using the \\`text\\` field.`\n} = {}) {\n return htl.html`

${title} ${emojis}

${text}

`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4844,"value":"## Sections","pinned":false,"hidden":false,"mode":"md"},{"id":4911,"value":"### Practice/Crop dot plot","pinned":false,"hidden":false,"mode":"md"},{"id":4838,"value":"// // mean diff by crop\n// data_meanDiff_practiceCrop = {\n// const raw = workbook_meanDifference.sheet(\"Practice_Crop\", { headers: true });\n// return raw.filter((d) => {\n// return Object.keys(d).length > 0\n// && meanDiffCropList.includes(d.Crop)\n// });\n// }","pinned":false,"hidden":false,"mode":"ojs"},{"id":4843,"value":"### AEZ Dot Plot","pinned":false,"hidden":false,"mode":"md"},{"id":5037,"value":"data_meanDiff_aezPracticeCrop_new = {\n const raw = await FileAttachment(\"Mean_yield_difference@1.csv\").csv({typed: true})\n \n const formatted = T.tidy(\n raw,\n T.filter((d) => Object.keys(d).length > 0),\n T.rename({\n Mean_T: 'Mean_Treatment',\n Mean_C: 'Mean_Control',\n })\n )\n \n // Load and merge sub-species data\n try {\n const subspeciesData = await data_meanDiff_aezPracticeCrop_subspecies;\n return [...formatted, ...subspeciesData];\n } catch (error) {\n // If sub-species file doesn't exist, return main data only\n return formatted;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5413,"value":"data_meanDiff_aezPracticeCrop_subspecies =\n{\n try {\n const raw = await FileAttachment(\"crop_subspecies_aez@1.csv\").csv({typed: true});\n \n if (!raw || !Array.isArray(raw)) {\n return [];\n }\n \n const formatted = T.tidy(\n raw,\n T.filter((d) => Object.keys(d).length > 0),\n T.rename({\n Mean_T: 'Mean_Treatment',\n Mean_C: 'Mean_Control',\n })\n );\n \n return formatted;\n } catch (error) {\n console.warn('Error loading AEZ sub-species data:', error);\n return [];\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5036,"value":"// aez color scale\naezColor_new = {\n const lookupAEZ = (aez) => _lang(td.AEZ_Class_FAO.values[aez])\n return {\n domain: [\n lookupAEZ('Desert/Arid climate'),\n lookupAEZ(\"Tropics, highland; semi-arid\"),\n lookupAEZ(\"Tropics, lowland; semi-arid\"),\n lookupAEZ(\"Subtropics, moderately cool; sub-humid\"),\n lookupAEZ(\"Tropics, highland; sub-humid\"),\n lookupAEZ(\"Tropics, lowland; sub-humid\"),\n lookupAEZ(\"Tropics, highland; humid\"),\n lookupAEZ(\"Tropics, lowland; humid\"),\n lookupAEZ(\"Land with ample irrigated soils\"),\n lookupAEZ(\"Severe soil/terrain limitations\"),\n lookupAEZ(\"Dominantly urban/built-up land\"),\n ],\n range: [\n \"#F3D6B0\",\n \"#FCA034\",\n \"#F7D732\",\n \"#523D4E\",\n \"#EF6D94\",\n \"#F9B1C1\",\n \"#2A79A8\",\n \"#79A1B7\",\n \"#74B95A\",\n \"#2E7637\",\n \"#B1B1B1\"\n ]\n };\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4872,"value":"viewof toggleColorLegend = Inputs.toggle({label: \"Debug: toggle legend\", value: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":4904,"value":"### Risk","pinned":false,"hidden":false,"mode":"md"},{"id":3841,"value":"data_lclRisk = data_extendedTable2.filter((d) => d.outcome == \"LCL Risk\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":5002,"value":"### Adoption factors","pinned":false,"hidden":false,"mode":"md"},{"id":5001,"value":"adoptionFactorAllLabel = \"All practices\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5000,"value":"rawAdoptionFactors = {\n const raw = await FileAttachment(\"adoption_factors_20mar24.csv\").csv()\n\n return raw.map(d => {\n return {\n index: d[''],\n practice: String(d['practices']),\n factor: String(d['adoption_factors']),\n direction: String(d['direction']),\n n: parseNum(d.n)\n }\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4999,"value":"dataAdoptionFactors = {\n const allPractices = T.tidy(\n rawAdoptionFactors,\n T.groupBy(\n [\"factor\", \"direction\"],\n [\n T.summarize({\n n: T.sum(\"n\")\n })\n ]\n ),\n T.groupBy(\n [\"factor\"],\n [\n T.mutateWithSummary({\n total: T.sum(\"n\")\n })\n ]\n ),\n T.mutate({ perc: (d) => (d.n / d.total) * 100 }),\n T.mutate({ practice: (d) => adoptionFactorAllLabel }),\n T.select([\"practice\", T.everything()])\n );\n\n const wrangled = T.tidy(\n rawAdoptionFactors,\n T.select(T.negate(\"index\")),\n T.groupBy(\n [\"practice\", \"factor\"],\n [T.mutateWithSummary({ total: T.sum(\"n\") })]\n ),\n T.mutate({\n perc: (d) => (d.n / d.total) * 100\n })\n );\n\n return [\n ...wrangled,\n ...allPractices\n ]\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4998,"value":"// mapped adoption data\ndataAdoptionFactorsMap = d3.group(dataAdoptionFactors, d => d.practice)","pinned":false,"hidden":false,"mode":"ojs"},{"id":4997,"value":"adoptionFactorsLookup = ({\n \"Not significant\": _lang(nbText.adoptionFactors.plot.labels.notSig),\n \"Negative\": _lang(nbText.adoptionFactors.plot.labels.neg),\n \"Positive\": _lang(nbText.adoptionFactors.plot.labels.pos),\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":4996,"value":"$40","pinned":false,"hidden":false,"mode":"ojs"},{"id":33,"value":"---\n## Data\n*Data sources*\n- **Extended Table 2**: Study counts based on practice and outcomes\n - From internal Drive: `spotlight2_Extended Table 2.csv`\n - Total version: [GitHub](https://github.com/AdaptationAtlas/solutions/blob/main/data/spotlight2/spotlight2_Extended%20Table%202.csv)\n- **Mean Difference**: mean difference data\n - From internal Drive: `Mean_yield_difference.xlsx`\n- **Barriers data**: From Table 1: Factors determining adoption of agronomic practices and technologies in Sub-Saharan Africa\n - From internal Drive: `Barriers_*.jpg`\n- **CSA Manuals**: List of resources\n - From internal Drive: `CSA Manuals` google sheet, as CSV ","pinned":false,"hidden":false,"mode":"md"},{"id":4445,"value":"### Extended Table 2","pinned":false,"hidden":false,"mode":"md"},{"id":2216,"value":"data_extendedTable2 = {\n // data from file\n const attachment = FileAttachment(\"spotlight2_Extended Table 2.csv\").csv();\n\n // return data\n return attachment.then((x) => {\n return x.map((row) => ({\n practice: String(row.Practice),\n outcome: String(row.Outcome),\n product: String(row.Product),\n is_combo: parseBool(row[\"Is.Combo\"]),\n observations: parseNum(row.Observations),\n studies: parseNum(row.Studies),\n value: parseNum(row.Value),\n sig: parseNum(row.Sig),\n value_se: parseNum(row[\"Value.se\"]),\n ci_low: parseNum(row.CIlow),\n ci_high: parseNum(row.CIhigh),\n source: String(row.Source)\n }));\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4994,"value":"data_extendedTable2_total = {\n // data from file\n const attachment = FileAttachment(\"spotlight2_Extended Table 2@1.csv\").csv();\n\n // return data\n return attachment.then((x) => {\n return x.map((row) => ({\n practice: String(row.Practice),\n outcome: String(row.Outcome),\n product: String(row.Product),\n // is_combo: parseBool(row[\"Is.Combo\"]),\n observations: parseNum(row.Observations),\n studies: parseNum(row.Studies),\n value: parseNum(row.Value),\n sig: parseNum(row.Sig),\n value_se: parseNum(row[\"Value.se\"]),\n ci_low: parseNum(row.CIlow),\n ci_high: parseNum(row.CIhigh),\n // source: String(row.Source)\n }));\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4939,"value":"### CSA manuals","pinned":false,"hidden":false,"mode":"md"},{"id":4938,"value":"csaManuals = {\n const attachment = FileAttachment(\"CSA Manuals - Sheet1.csv\").csv()\n\n // parse columns\n return attachment.then((x) => {\n return x.map(d => ({\n practice: String(d['Practice']).trim(),\n country_region: String(d['Country or Region']).trim(),\n system: String(d['System']).trim(),\n author: String(d['Author']).trim(),\n title: String(d['Title']).trim(),\n link: String(d['Link']).trim()\n }))\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4937,"value":"// selections\ncsaResourceHtml = {\n const data = T.tidy(\n csaManuals,\n T.filter((d) => d.practice == selectResourcePractice.field),\n T.arrange([\"system\", \"title\"])\n );\n const translateSystem = (d) => _lang(td.summarySystems.values?.[d]);\n const systemWord = _lang(td.summarySystems)\n\n const htmlList = data.map((d) => {\n const system = translateSystem(d.system);\n return `

${system}: ${d.title}

`;\n });\n\n return `${systemWord}\n

${htmlList.join(\n \"\"\n )}`;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4444,"value":"### Mean Difference Data (workbook data)\nFrom excel sheet, unpack different tabs\n- Crop choices are backend values for crops with at least 10 studies (20 crops)","pinned":false,"hidden":false,"mode":"md"},{"id":4839,"value":"// list of crops to show for mean difference (study cutoff)\nmeanDiffCropList = [\n 'Maize',\n 'Cowpea',\n 'Sorghum',\n 'Rice',\n 'Pearl Millet',\n 'Cassava or Yuca',\n 'Common Bean',\n 'Groundnut',\n 'Soybean',\n 'Wheat',\n 'Tomato',\n 'Potato',\n 'Yam',\n 'Cotton',\n 'Sugar Cane',\n 'Okra',\n 'Sweet Potato',\n 'Teff',\n 'Pigeon Pea',\n 'Sesame Seed',\n]","pinned":false,"hidden":false,"mode":"ojs"},{"id":4898,"value":"Define a global crop selector for mean difference crop choices","pinned":false,"hidden":false,"mode":"md"},{"id":4897,"value":"// shared column for mean difference dot plots\nviewof selectCropMeanDiff = Inputs.select(meanDiffCropList, {label: \"Crop\", unique: true, sort: true, value: 'Maize'})","pinned":false,"hidden":false,"mode":"ojs"},{"id":4443,"value":"// read excel sheet\n// workbook_meanDifference = FileAttachment(\"Mean_yield_difference.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs"},{"id":5256,"value":"$41","pinned":false,"hidden":false,"mode":"ojs"},{"id":5371,"value":"data_meanDiff_practiceCrop_subspecies =\n{\n try {\n const raw = await FileAttachment(\"crop_subspecies.csv\").csv({typed: true});\n \n if (!raw || !Array.isArray(raw)) {\n \n return [];\n }\n \n const mapped = raw.map(d => {\n return {\n Practice: d['Practice'],\n Crop: d['Crop'],\n N_Obs: d['N_Obs'],\n N_Pub: d[\"N_Pub\"],\n Mean_Treatment: d[\"Mean_T\"],\n Mean_Control: d[\"Mean_C\"],\n Mean_Difference: d[\"Mean_Difference\"],\n Se: d['Se'],\n Lower: d[\"Lower\"],\n Upper: d[\"Upper\"],\n }\n });\n \n \n const uniqueCrops = [...new Set(mapped.map(d => d.Crop))];\n \n \n return mapped;\n } catch (error) {\n \n return [];\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2834,"value":"### Data import functions","pinned":false,"hidden":false,"mode":"md"},{"id":2835,"value":"// TRUE or FALSE strings (from R), otherwise null\nparseBool = (d) => {\n if (d === \"TRUE\") return true;\n if (d === \"FALSE\") return false;\n else return null;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":2837,"value":"// Parsing numbers, blank strings as NaN's\nparseNum = (d) => {\n if (typeof d === \"number\" && !isNaN(d)) return d;\n return d.trim() === \"\" ? NaN : +d;\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4835,"value":"### Formatting functions","pinned":false,"hidden":false,"mode":"md"},{"id":4834,"value":"// format number, long notation\nformatNumCompactLong = function (number, { locale = \"en-US\" } = {}) {\n return new Intl.NumberFormat(locale, {\n notation: \"compact\",\n compactDisplay: \"long\",\n unitDisplay: \"long\"\n }).format(number);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5162,"value":"// format number\nformatNumStandard = function (number, { locale = \"en-US\" } = {}) {\n return new Intl.NumberFormat(locale, {}).format(number);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":4833,"value":"// format number, 2 decimal places\nformatNum = d3.format(\".2f\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":4894,"value":"formatComma = d3.format(',')","pinned":false,"hidden":false,"mode":"ojs"},{"id":4832,"value":"### Color Scales","pinned":false,"hidden":false,"mode":"md"},{"id":4831,"value":"colorYellowGreen = [\"#F7D732\", \"#216729\"]","pinned":false,"hidden":false,"mode":"ojs"},{"id":264,"value":"***\n## Imports\n*External imports*","pinned":false,"hidden":false,"mode":"md"},{"id":265,"value":"import {toc} from \"@nebrius/indented-toc\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":1240,"value":"import {T} from \"@pbeshai/tidyjs\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5014,"value":"{\n const text = `### v1.1.0: adding language conversion\n- language toggle \n\n### v1.0.1: adding M&S\n- Adding methods and sources\n - need to use html for one link with parens\n - use LaTeX for formula\n\n### v1.0 transfer\n- remove older chart code\n\n### v0.11 Data Update\n- Adding updated data sources\n`;\n\n const newestVersion = text.split('###')\n .filter(d => d)\n .map(d => d.trim())\n ?.[0]\n .split('\\n')\n ?.[0]\n\n return makeDevNotes({\n text: md`${text}`,\n title: newestVersion ?? \"Dev notes\",\n emojis: \"🪵✏️\"\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5434,"value":"$42","pinned":false,"hidden":false,"mode":"ojs"},{"id":5459,"value":"exportAEZDotChart2 = \n{\n // Export for _plotDotAEZ_new function (AEZ dot plot)\n // Uses specific detection for dot plot with color legend\n return exportChart(null, 'aez-dot-chart', {\n label: 'Export AEZ Dot Chart',\n // Specific characteristics for _plotDotAEZ_new: dot plot with top axis, color legend, width ~900\n chartCharacteristics: {\n isHorizontalBar: false,\n hasTopAxis: true,\n minWidth: 800,\n maxWidth: 1000,\n hasDots: true,\n hasColorLegend: true\n }\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5480,"value":"function _downloadBlobHelper(blob, filename) {\n return new Promise((resolve, reject) => {\n try {\n const url = URL.createObjectURL(blob);\n const a = document.createElement('a');\n a.href = url;\n a.download = filename;\n a.style.display = 'none';\n document.body.appendChild(a);\n setTimeout(() => {\n a.click();\n setTimeout(() => {\n document.body.removeChild(a);\n URL.revokeObjectURL(url);\n resolve();\n }, 100);\n }, 10);\n } catch (error) {\n reject(error);\n }\n });\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":5482,"value":"function _downloadAsSvgHelper(_downloadBlobHelper, svg, filename) {\n const clone = svg.cloneNode(true);\n const serializer = new XMLSerializer();\n const svgString = serializer.serializeToString(clone);\n const blob = new Blob([svgString], { type: 'image/svg+xml' });\n return _downloadBlobHelper(blob, filename);\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5485,"value":"$43","pinned":false,"hidden":false,"mode":"ojs"},{"id":5488,"value":"$44","pinned":false,"hidden":false,"mode":"ojs"},{"id":5490,"value":"function _showNotificationHelper(html, message, isError = false) {\n const notification = html`

${message}

`;\n \n document.body.appendChild(notification);\n setTimeout(() => {\n if (notification.parentNode) {\n notification.parentNode.removeChild(notification);\n }\n }, isError ? 5000 : 3000);\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":5492,"value":"$45","pinned":false,"hidden":false,"mode":"ojs"},{"id":5496,"value":"$46","pinned":false,"hidden":false,"mode":"ojs"},{"id":5499,"value":"$47","pinned":false,"hidden":false,"mode":"ojs"},{"id":5502,"value":"$48","pinned":false,"hidden":false,"mode":"ojs"},{"id":5505,"value":"$49","pinned":false,"hidden":false,"mode":"ojs"},{"id":5600,"value":"import {usdToEtbExchangeRate} from \"4cb12a271c3cdd5b\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5615,"value":"import {formatCurrencyToBirr} from \"4cb12a271c3cdd5b\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5618,"value":"import {convertToTLU} from \"4cb12a271c3cdd5b\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W4a","stdlib":"1"}