29:null 2a:["$","title",null,{"children":"Baker's Percentage Recipe Calculator | jason a. grafft | Observable"}] 2f:[{"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}] 2d:{"id":"3ae22ee80e7cd846","slug":"bakers-percentage-calculator","title":"Baker's Percentage Recipe Calculator","thumbnail":"6eb1cf9d64ce79c73a29c8797c424453002fb7e7458a1366081f191860e531d1","access_level":"public","create_time":"$D2020-09-25T22:43:11.656Z","update_time":"$D2023-06-27T17:40:14.355Z","view_time":null,"first_public_time":"$D2021-03-26T19:33:28.832Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"33d714a841c4dfd5","login":"jagrafft","name":"jason a. grafft","avatar_url":"https://avatars-next.observableusercontent.com/50bfa5f99ef282cce89216516d1b5d3a73b8b6d3cc0bd65b3d18608b9b3f8957","tier":"starter_2024"},"version":1765,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"69c7ef7870d59485","login":"jagrafft","name":"jason a. grafft","avatar_url":"https://avatars-next.observableusercontent.com/50bfa5f99ef282cce89216516d1b5d3a73b8b6d3cc0bd65b3d18608b9b3f8957","tier":null}],"members":[{"type":"individual","id":"69c7ef7870d59485","login":"jagrafft","name":"jason a. grafft","avatar_url":"https://avatars-next.observableusercontent.com/50bfa5f99ef282cce89216516d1b5d3a73b8b6d3cc0bd65b3d18608b9b3f8957","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"dba1a694f818fa80","slug":"data-interfaces","title":"Data Interfaces","owner":{"id":"33d714a841c4dfd5","login":"jagrafft","name":"jason a. grafft"}},"type":"notebook","body":{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":828,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1238,"value":"# ${selected_recipe_citation[0].title}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1755,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1214,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":162,"value":"## Data, Defaults, Functions, and Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1650,"value":"_recipes = FileAttachment(\"2023-02-19_bp_recipes.db\").sqlite()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1216,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":526,"value":"slider_max = 10000","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1086,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2e:"$2d:body"