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":5317,"value":"makeQuartoFlag(\"https://adaptationatlas.github.io/atlas_notebooksV1/notebooks/solutions/notebook.html\")","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":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":3780,"value":"$1f","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 const data = [...new Set(data_meanDiff_practiceCrop_new.map((d) => d.Crop))]\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}","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":"$20","pinned":false,"hidden":false,"mode":"ojs"},{"id":5299,"value":"buildInlineDownloadButton(\n data_meanDiff_aezPracticeCrop_new\n .filter(\n (d) => d.Crop === selectCropMeanDiff_new.field\n ),\n _lang(download_translation),\n `solutionsDifference_${selectCropMeanDiffAEZ.field}`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5049,"value":"md`### ${_lang(nbText.supportNbText.labels.quickInsights)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5048,"value":"$21","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 const data = [\n ...new Set(data_meanDiff_aezPracticeCrop_new.map((d) => d.Crop))\n ]\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}","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 const data = data_meanDiff_aezPracticeCrop_new.filter(\n (d) => d.Crop === selectCropMeanDiffAEZ.field\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}","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":"$22","pinned":false,"hidden":false,"mode":"ojs"},{"id":5042,"value":"plotDotAEZ_new.legend('color', {columns: 3})","pinned":false,"hidden":false,"mode":"ojs"},{"id":5287,"value":"buildInlineDownloadButton(\n data_meanDiff_aezPracticeCrop_new\n .filter(\n (d) => d.Crop === selectCropMeanDiffAEZ.field\n ),\n _lang(download_translation),\n `solutionsDifference_AEZ_${selectCropMeanDiffAEZ.field}`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5041,"value":"md`### ${_lang(nbText.supportNbText.labels.quickInsights)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5203,"value":"$23","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":"$24","pinned":false,"hidden":false,"mode":"ojs"},{"id":5277,"value":"buildInlineDownloadButton(\n data_lclRisk,\n _lang(download_translation),\n `yieldProbability_${_lang(selectPractice.translation).replace(/\\s/g, \"\")}`)","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":"$25","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":5006,"value":"$26","pinned":false,"hidden":false,"mode":"ojs"},{"id":5264,"value":"buildInlineDownloadButton(\n dataAdoptionFactorsMap.get(dataAdoptionFactors_select.field),\n _lang(download_translation),\n `solutionAdoption_${dataAdoptionFactors_select.field.replace(/\\s/g, \"\")}`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":5005,"value":"md`### ${_lang(nbText.supportNbText.labels.quickInsights)}`","pinned":false,"hidden":false,"mode":"ojs"},{"id":5004,"value":"$27","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":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 \"7d46679f7d0d917e\"","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: \"fr\", label: \"Français\", locale: 'fr-FR' }\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":5170,"value":"$28","pinned":false,"hidden":false,"mode":"ojs"},{"id":5169,"value":"$29","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":"$2a","pinned":false,"hidden":false,"mode":"ojs"},{"id":4735,"value":"**Table of Contents**","pinned":false,"hidden":false,"mode":"md"},{"id":4734,"value":"$2b","pinned":false,"hidden":false,"mode":"ojs"},{"id":5260,"value":"import {buildInlineDownloadButton, downloadButtonCSS, download_translation} from \"1bda5f9b60c64223\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":5262,"value":"downloadButtonCSS","pinned":true,"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 return formatted\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":"$2c","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.toTitleCase(_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":"data_meanDiff_practiceCrop_new = {\n const raw = await FileAttachment(\"figure_2_data@1.csv\").csv({typed: true})\n\n return 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}","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":5308,"value":"makeQuartoFlag = (url) => {\n const baseText = _lang(\n {\n en: \"New version available! This notebook has been rebuilt in Quarto for a better experience:\",\n fr: \"Nouvelle version disponible ! Ce carnet a été reconstruit avec Quarto pour une meilleure expérience:\"\n }\n )\n const openText = _lang(\n {\n en: \"Open Updated Notebook\",\n fr: \"Ouvrir le carnet mis à jour\"\n }\n )\n \n return htl.html`\n

\n ${baseText} ${openText} →\n

\n `\n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W2d","stdlib":"1"}