3e:null 3f:["$","title",null,{"children":"Кодирование промышленных заквасок | Владислав Семипятный | Observable"}] 45:[{"id":"7d596c5595bbfdef4900ee86ca48299b6eff4c9cc304031f6755c9bb4b6055f791c10bb21c0ab1d4e4a20f6122570b31a7ddf6625d811970605b9c0011840294","href":"https://static.observableusercontent.com/files/7d596c5595bbfdef4900ee86ca48299b6eff4c9cc304031f6755c9bb4b6055f791c10bb21c0ab1d4e4a20f6122570b31a7ddf6625d811970605b9c0011840294","name":"coding.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1706864976997.884,"size":10827},{"id":"133ce464ba9c39b7cddbe8baa9e86ede708170fdc49f5fd4fc553da7366276ea83aabcf3023f7d4b522e87c07c6cb6aa231bbcc14d159b25533a782f52535d5f","href":"https://static.observableusercontent.com/files/133ce464ba9c39b7cddbe8baa9e86ede708170fdc49f5fd4fc553da7366276ea83aabcf3023f7d4b522e87c07c6cb6aa231bbcc14d159b25533a782f52535d5f","name":"zaks.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1707141877421.408,"size":11804},{"id":"c0f0da596a3bd3fe42b7917a4c1fbe138081f6087857c80c5d5cfa9a0d08b2863ac6d60a79b9b5408b26700733a0d07de9040dbab724e350afd1dc28f056c50c","href":"https://static.observableusercontent.com/files/c0f0da596a3bd3fe42b7917a4c1fbe138081f6087857c80c5d5cfa9a0d08b2863ac6d60a79b9b5408b26700733a0d07de9040dbab724e350afd1dc28f056c50c","name":"coding@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1706865192347.951,"size":10603}] 43:{"id":"58ceff8fad6cb755","slug":null,"title":"Кодирование промышленных заквасок","thumbnail":"0db438cbaeff0e8bdf2c2edc43984c3dc6529c57207997be7760f44dd8a1209c","access_level":"public","create_time":"$D2024-02-02T09:07:32.769Z","update_time":"$D2024-02-05T14:38:16.834Z","view_time":null,"first_public_time":"$D2024-02-02T09:07:32.769Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"70205af260920136","login":"semipyatniy","name":"Владислав Семипятный","avatar_url":"https://avatars-next.observableusercontent.com/4cd5704db3394a65486a9599a21d1572f5a93f63c97507aa64a78556c2665bcc","tier":"starter_2024","bio":"Зав. лабораторией искусственного интеллекта и наукоемких решений @ВНИМИ, д. т. н.","following":false},"version":247,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"6eab61b4c29e989b","login":"semipyatniy","name":"Vladislav Semipyatniy","avatar_url":"https://avatars-next.observableusercontent.com/4cd5704db3394a65486a9599a21d1572f5a93f63c97507aa64a78556c2665bcc","tier":null,"bio":"Head of the AI and High-Tech Solutions in Food Science Lab","following":false}],"members":[{"type":"individual","id":"6eab61b4c29e989b","login":"semipyatniy","name":"Vladislav Semipyatniy","avatar_url":"https://avatars-next.observableusercontent.com/4cd5704db3394a65486a9599a21d1572f5a93f63c97507aa64a78556c2665bcc","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Кодирование промышленных заквасок","cells":[{"id":0,"value":"# Кодирование промышленных заквасок","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":34,"value":"## Формирование наименования закваски","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":125,"value":"viewof type_s = Inputs.radio([\"Закваска\", \"Сухой бакконцентрат\"], {\n label: html`Тип`,\n value: \"Закваска\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"viewof zaks = Inputs.checkbox(data, {\n label: html`Закваски`,\n format: (x) => x.B\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"viewof freezedry = Inputs.radio([\"Сухая\", \"Замороженная\"], {\n label: html`Тип закваски`,\n value: \"Сухая\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"viewof adds = Inputs.checkbox([\"Высокая вязкость\"], {\n label: html`Дополнительно`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"viewof product = Inputs.radio(\n [\"Творог\", \"Кефир\", \"Сметана\", \"Биолакт\", \"Простокваша\", \"Без продукта\"],\n {\n label: html`Продукт`,\n value: \"Без продукта\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"---\n### Финальное название\n\n
\n

${final_name}

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":210,"value":"{\n if (old_zaks.length == 0) return md`

`;\n\n return md`\nСоответствует наименованиям:\n\nПЭЗ ВНИМИ: ${Array.from(new Set(vnimiPEZ_zaks)).join(\", \")}\n\nТУ ВНИМИ: ${Array.from(new Set(vnimiTU_zaks)).join(\", \")}\n `;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"---\n
\n
\n## Проверка названия","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":137,"value":"viewof naming = Inputs.text({ label: \"Кодировка закваски\" })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"$${(naming == \"\") ? \"\" : recoding()}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":32,"value":"
\n
\n\n## Таблица заквасок","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"data","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"
\n
\n\n### Addendum","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"data = workbook.sheet(0, {\n headers: false,\n // range: \"A1:J10\"\n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"workbook.sheetNames","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":6,"value":"workbook = FileAttachment(\"coding@1.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"final_name = (() => {\n if (zaks.length == 0) return \"\";\n\n let res = \"\";\n\n if (type_s == \"Сухой бакконцентрат\") res += \"DVS \";\n\n res += \"ProdLine \";\n\n res += freezedry == \"Замороженная\" ? \"F\" : \"D\";\n\n res += adds.indexOf(\"Высокая вязкость\") !== -1 ? \"Hv \" : \" \";\n\n const types = zaks\n .map((e) => e.C)\n .sort((a, b) => a.toLowerCase().localeCompare(b.toLowerCase()));\n\n res += types[0];\n\n for (let i = 1; i < types.length; ++i) {\n if (ssf(types[i])[0] == ssf(types[i - 1])[0]) {\n res += ssf(types[i])[1];\n } else {\n res += \"/\" + types[i];\n }\n }\n\n if (product != \"Без продукта\") {\n res += \" (\" + product.toLocaleLowerCase() + \")\";\n }\n\n return res;\n})()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"function ssf(inputString) {\n const digitIndex = inputString.search(/\\d/);\n\n if (digitIndex !== -1) {\n return [inputString.slice(0, digitIndex), inputString.slice(digitIndex)];\n } else {\n return [inputString, \"\"];\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":159,"value":"recoding = () => {\n return \"Не удалось расшифровать\";\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":165,"value":"function 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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"{\n zaks;\n set(viewof product, \"Без продукта\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":174,"value":"workbook1 = FileAttachment(\"zaks.xlsx\").xlsx()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"workbook1.sheetNames","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"zaks_data = workbook1.sheet(0, {\n headers: false\n // range: \"A1:J10\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":182,"value":"zaks_data.map((e) => e.C)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"function findAllIndexes(arr, target) {\n var indexes = [];\n for (var i = 0; i < arr.length; i++) {\n if (arr[i] === target) {\n indexes.push(i);\n }\n }\n return indexes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"old_zaks = final_name == \"\"\n ? []\n : findAllIndexes(\n zaks_data.map((e) => e.C),\n final_name.split(\" (\")[0]\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"vnimiPEZ_zaks = old_zaks.length == 0 ? [] : old_zaks.map((e) => zaks_data[e].A)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"vnimiTU_zaks = old_zaks.length == 0 ? [] : old_zaks.map((e) => zaks_data[e].B)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W45","stdlib":"1"}} 44:"$43:body"