3e:null 3f:["$","title",null,{"children":"Prakticheskaya_2 | Матвей Манаков | Observable"}] 45:T4de,const htmlTable = (rows) => { const cols = [ {key: "id", title: "№", w: 50, right: true}, {key: "period", title: "Сроки", w: 130}, {key: "city", title: "Город", w: 160}, {key: "name", title: "Соревнование", w: 460}, {key: "people", title: "Участников (оценка)", w: 150, right: true} ]; return html`

${cols.map(c => html``)}${cols.map(c => html``)} ${rows.map((d, i) => html` ${cols.map(c => html``)} `)}

${c.title}
${d[c.key]}

`; };46:[{"id":"a0f0f9469cb01b537599e31489bba2f73f3f2ed0f2bb294b3b306b9f32789a532919d2a25dcafe2674e9d66c18cc4a714c96fcc14b08e76b4fd4bc6a2e711550","href":"https://static.observableusercontent.com/files/a0f0f9469cb01b537599e31489bba2f73f3f2ed0f2bb294b3b306b9f32789a532919d2a25dcafe2674e9d66c18cc4a714c96fcc14b08e76b4fd4bc6a2e711550","name":"sport_world.csv","type":"text/csv","lastModified":1792050410843,"size":15029}] 43:{"id":"33975d6fc026c207","slug":"prakticheskaya-2","title":"Prakticheskaya_2","thumbnail":"f5d40134dd54889816ba757c43064772ca1c7b5c8d59b8458381fd625c18ac62","access_level":"public","create_time":"$D2026-10-15T07:58:40.500Z","update_time":"$D2026-10-15T20:22:27.677Z","view_time":null,"first_public_time":"$D2026-10-15T20:22:34.109Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"25ebb25689fbc0df","login":"mimoshilo324234234234234234","name":"Матвей Манаков","avatar_url":"https://avatars-next.observableusercontent.com/92e7a32d7b6fe10226381c6ee77b440440351847874381a6df707acaac84e972","tier":"free_2026","bio":""},"version":91,"publish_version":91,"role":null,"authored":false,"authors":[{"type":"individual","id":"818bd1612e8dbed8","login":"mimoshilo324234234234234234","name":"Матвей Манаков","avatar_url":"https://avatars-next.observableusercontent.com/92e7a32d7b6fe10226381c6ee77b440440351847874381a6df707acaac84e972","tier":null,"bio":""}],"members":[{"type":"team","id":"25ebb25689fbc0df","login":"mimoshilo324234234234234234","name":"Матвей Манаков","avatar_url":"https://avatars-next.observableusercontent.com/92e7a32d7b6fe10226381c6ee77b440440351847874381a6df707acaac84e972","tier":"free_2026","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Prakticheskaya_2","cells":[{"id":2,"value":"# Prakticheskaya_2\n","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"Нагрузка на принимающие города: календарь международных соревнований\nПричина исследования. Оргкомитетам и городским службам нужно заранее понимать,где и когда соберётся больше всего участников: от этого зависят гостиницы,\nтранспорт, медицинское обеспечение и число волонтёров.\n\n\n1. В каких городах и в каких месяцах сосредоточено больше всего участников?\n3. Какие соревнования самые массовые?\n4. Сколько мероприятий попадает в «средний» диапазон по числу участников?\n\n\n","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"import {html} from \"npm:htl\";","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"const raw = await FileAttachment(\"sport_world.csv\").csv({typed: true});\n","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"const months = [\"январь\",\"февраль\",\"март\",\"апрель\",\"май\",\"июнь\",\"июль\",\"август\",\"сентябрь\",\"октябрь\",\"ноябрь\",\"декабрь\",\"не указано\"];","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"const data = raw.map(d => {\n const period = (d[\"Сроки проведения\"] ?? \"\").toString().trim() || \"не указано\";\n const place = d[\"Место проведения\"].trim();\n const city = place\n .split(/\\s*–\\s*|-\\s+/)[0]\n .replace(/^(г\\.|д\\.|пгт)\\s*/, \"\")\n .trim();\n const month = period.split(\"-\")[0];\n return {\n id: d[\"номер\"],\n name: d[\"Наименование соревнования\"].trim(),\n period,\n month,\n monthNo: months.indexOf(month),\n place,\n city,\n people: d[\"Ориентировочное число участников\"]\n };\n});","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"const selected = view(Inputs.table(data, {\n columns: [\"id\", \"period\", \"city\", \"name\", \"people\"],\n header: {\n id: \"№\",\n period: \"Сроки\",\n city: \"Город\",\n name: \"Соревнование\",\n people: \"Участников (оценка)\"\n },\n width: {id: 40, period: 110, city: 140, name: 430, people: 130},\n align: {id: \"right\", people: \"right\"},\n sort: \"people\",\n reverse: true,\n rows: 12,\n required: false\n}));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"const shortLabel = d => `${d.id}. ${d.name.length > 48 ? d.name.slice(0, 48) + \"…\" : d.name}`;","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"selected.length === 0\n ? html`Отметьте хотя бы одну строку в таблице выше.`\n : Plot.plot({\n marginLeft: 330,\n marginRight: 40,\n width: 900,\n height: 40 + selected.length * 28,\n x: {label: \"Ориентировочное число участников →\", grid: true},\n y: {label: null},\n marks: [\n Plot.barX(selected, {x: \"people\", y: shortLabel, sort: {y: \"-x\"}, fill: \"#2a6fdb\", tip: true}),\n Plot.text(selected, {x: \"people\", y: shortLabel, text: \"people\", dx: 14}),\n Plot.ruleX([0])\n ]\n })","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"$45","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"htmlTable(data.slice().sort((a, b) => a.monthNo - b.monthNo || b.people - a.people))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"const cities = [...new Set(data.map(d => d.city))].sort((a, b) => a.localeCompare(b, \"ru\"));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"const monthList = months.filter(m => data.some(d => d.month === m));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"const citySel = view(Inputs.select(cities, {label: \"Город\", multiple: true, size: 8, value: []}));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"const monthSel = view(Inputs.select(monthList, {label: \"Месяц начала\", multiple: true, size: 8, value: []}));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"const textQ = view(Inputs.text({label: \"Название содержит\", placeholder: \"например: чемпионат\", width: 400}));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"ЗАДАНИЕ 1\nнужны только 2 числа , а не целый массив\nмассив постоянно пересчитывается\n`Math.min(...arr)` на очень больших массивах падает с ошибкой переполнения\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"const minmax = (() => {\n let min = Infinity, max = -Infinity;\n for (const d of data) { // один проход, без копии и без сортировки\n if (d.people < min) min = d.people;\n if (d.people > max) max = d.people;\n }\n return [min, max];\n})();","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"const peopleFrom = view(Inputs.range(minmax, {label: \"Участников от:\", value: minmax[0], step: 1, width: 400}));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"const peopleTo = view(Inputs.range([peopleFrom, minmax[1]], {label: \"до:\", value: minmax[1], step: 1, width: 400}));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"const filtered = data.filter(d =>\n (citySel.length === 0 || citySel.includes(d.city)) &&\n (monthSel.length === 0 || monthSel.includes(d.month)) &&\n d.name.toLowerCase().includes(textQ.trim().toLowerCase()) &&\n d.people >= peopleFrom && d.people <= peopleTo\n);","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"html`

Найдено: ${filtered.length} из ${data.length} соревнований · всего участников: ${filtered.reduce((s, d) => s + d.people, 0).toLocaleString(\"ru\")}

`","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"ЗАДАНИЕ: bar-объект (canvas) — количество соревнований, удовлетворяющих условию","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"const bar_w = 700;","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"const bar_h = 50;","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"(() => {\n const canvas = document.createElement(\"canvas\");\n canvas.width = bar_w;\n canvas.height = bar_h;\n canvas.style.background = \"hsl(216deg 25% 90%)\";\n const context = canvas.getContext(\"2d\");\n const fillW = filtered.length * bar_w / data.length;\n context.fillStyle = \"hsl(216deg 100% 13%)\";\n context.fillRect(0, 0, fillW, bar_h);\n context.font = \"bold 18px sans-serif\";\n context.textBaseline = \"middle\";\n const inside = fillW > 110;\n context.fillStyle = inside ? \"#fff\" : \"hsl(216deg 100% 13%)\";\n context.fillText(`${filtered.length} из ${data.length}`, inside ? 12 : fillW + 12, bar_h / 2);\n return canvas;\n})()","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"const max_count = data.length;","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"const count = view(Inputs.range([0, max_count], {label: \"для примера работы\", step: 1, value: 35, width: 300}));","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"(() => {\n const canvas = document.createElement(\"canvas\");\n canvas.width = bar_w;\n canvas.height = bar_h;\n canvas.style.background = \"hsl(216deg 25% 90%)\";\n const context = canvas.getContext(\"2d\");\n context.fillStyle = \"hsl(216deg 100% 13%)\";\n context.fillRect(0, 0, count * bar_w / max_count, bar_h);\n return canvas;\n})()","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":34,"value":"Inputs.table(filtered, {\n columns: [\"id\", \"period\", \"city\", \"name\", \"people\"],\n header: {id: \"№\", period: \"Сроки\", city: \"Город\", name: \"Соревнование\", people: \"Участников (оценка)\"},\n width: {id: 40, period: 110, city: 140, name: 430, people: 130},\n align: {id: \"right\", people: \"right\"},\n sort: \"people\",\n reverse: true,\n rows: 12\n})","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"htmlTable(filtered.slice().sort((a, b) => b.people - a.people))","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":" Выводы\nМосква — лидер: 27 из 77 мероприятий и ≈9 600 участников (около 39 %).\nДалее по числу участников: Сочи (≈2 570), Московская область (≈2 100), Казань (≈1 810), Санкт-Петербург (≈1 730).\nПик нагрузки — июль (11 событий, ≈4 180 участников), затем август (≈3 720) и май (≈3 660).\nеньше всего участников — в апреле, октябре и декабре.\nСамое массовое событие — «Шелковый путь» по автоспорту (≈1 500), далее — III зимние Всемирные военные игры в Сочи (≈1 225).\nБольшинство соревнований небольшие: медиана ≈200 участников, 32 события попадают в диапазон 200–600.\n","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W46","stdlib":"2"}} 44:"$43:body"