31:[{"id":"715979f1d559c671123da789bf3f81add8b853919f55c64429eace9b1f447d0935da431136539719848ffdcf688e7d874be62da25c22500d90fe7fe5f1106515","href":"https://static.observableusercontent.com/files/715979f1d559c671123da789bf3f81add8b853919f55c64429eace9b1f447d0935da431136539719848ffdcf688e7d874be62da25c22500d90fe7fe5f1106515","name":"2023-02-19_bp_recipes.db","type":"application/x-sqlite3","lastModified":1676808850716.676,"size":131072}] 2f:{"title":"Baker's Percentage Recipe Calculator","cells":[{"id":174,"value":"# Baker's Percentage Recipe Calculator\nScale a recipe by proportion of total flour mass, e.g. via Baker's Percentage.\n\nDashboard utilizes a SQLite database in Sixth Normal Form (6NF), and SQL queries perform the majority of data operations. This dramatically increases data reuse, establishes a scalable pattern for adding recipes, and uses `JOIN`s to eliminate a complex chain of JavaScript `reduce` operations.\n\n#### Repoistory\nhttps://github.com/jagrafft/6nf-recipes","pinned":false,"hidden":false,"mode":"md"},{"id":828,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":1238,"value":"# ${selected_recipe_citation[0].title}","pinned":false,"hidden":false,"mode":"md"},{"id":1037,"value":"

\n ${selected_recipe_citation[0].author}. ${selected_recipe_citation[0].title}.\n
\n ${selected_recipe_citation[0].url}\n
\n ${selected_recipe_citation[0].publication_date}; accessed ${selected_recipe_citation[0].access_date}.\n

","pinned":false,"hidden":false,"mode":"md"},{"id":908,"value":"viewof selected_recipe = Inputs.select(\n recipe_list.sort((a,b) => b.title <= a.title),\n {\n label: \"Recipe\",\n format: ((x) => x.title),\n width: 420\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1512,"value":"viewof flour_mass = Inputs.range([0, slider_max], { label: \"Flour\", step: 1, value: selected_recipe_default_mass[0].grams })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1580,"value":"viewof number_of_rounds = Inputs.range([0, 100], { label: \"Number of Rounds\", step: 1, value: 3 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":1714,"value":"SELECT\n -- id,\n ingredient AS Ingredient,\n ROUND(ratio * ${flour_mass}) AS \"Mass (g)\",\n ratio AS Ratio\nFROM\n ingredient_list\nWHERE\n id=${selected_recipe.id}\nORDER BY\n \"Mass (g)\" DESC","pinned":false,"hidden":false,"mode":"sql","output":"selected_recipe_items","database":"2023-02-19_bp_recipes.db"},{"id":1531,"value":"Inputs.table([\n {\n \"Recipe Mass\": selected_recipe_total_mass,\n \"Rounds\": number_of_rounds,\n \"grams/Round\": selected_recipe_total_mass/number_of_rounds\n }\n],\n{\n align: {\n \"Recipe Mass\": \"left\",\n \"Rounds\": \"left\",\n \"grams/Round\": \"left\"\n },\n format: {\n \"grams/Round\": x => parseFloat(x.toFixed(2)),\n \"Recipe Mass\": x => parseFloat(x.toFixed(2))\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1397,"value":"Inputs.button([\n [\"Reset\", () => {\n set(viewof flour_mass, selected_recipe_default_mass[0].grams);\n set(viewof number_of_rounds, 3)\n }\n ]\n])","pinned":false,"hidden":false,"mode":"ojs"},{"id":1755,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1208,"value":"## Notes\n- King Arthur Baking Company Baker's Percentage reference tables are used for all volume-to-mass conversions\n- A \"bootstrap\" script to create the database from a collection of CSV files is available at https://github.com/jagrafft/6nf-recipes\n - File an issue ticket with a **publicly-accessible URL** to suggest new recipes","pinned":false,"hidden":false,"mode":"md"},{"id":1214,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":162,"value":"## Data, Defaults, Functions, and Imports","pinned":false,"hidden":false,"mode":"md"},{"id":1650,"value":"_recipes = FileAttachment(\"2023-02-19_bp_recipes.db\").sqlite()","pinned":false,"hidden":false,"mode":"ojs"},{"id":1216,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":526,"value":"slider_max = 10000","pinned":false,"hidden":false,"mode":"ojs"},{"id":1086,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":1655,"value":"recipe_list = _recipes.query(`\n SELECT\n id,\n title\n FROM\n recipe_list\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1662,"value":"selected_recipe_citation = _recipes.query(`\nSELECT\n id,\n author,\n title,\n publication_date,\n access_date,\n url\nFROM\n citations\nWHERE\n id = ${selected_recipe.id}\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1669,"value":"selected_recipe_default_mass = _recipes.query(`\nSELECT\n id,\n grams\nFROM\n default_masses\nWHERE\n id = ${selected_recipe.id}\n`)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1151,"value":"selected_recipe_total_mass = selected_recipe_items.reduce((a,c) => a += parseFloat(c[\"Mass (g)\"].toFixed(2)), 0)","pinned":false,"hidden":false,"mode":"ojs"},{"id":1384,"value":"// see https://observablehq.com/@observablehq/synchronized-inputs\nfunction set(input, value) {\n input.value = value;\n input.dispatchEvent(new Event(\"input\", {bubbles: true}));\n}","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}