2e:null 2f:["$","title",null,{"children":"Apartment block internet usage | senritsu | Observable"}] 34:T503,function renderBlock ({houses, unitsPerHouse}) { const units = houses * unitsPerHouse const occupants = units * averagePersonsPerHousehold const renderUnits = () => Array.from({length: unitsPerHouse}) .map(() => htl.html`

`) const renderHouse = () => htl.html`

${renderUnits()}

` const renderOtherHouses = () => Array.from({length: houses - 1}) .map(() => htl.html`

`) const root = htl.html`

${renderHouse()}

${renderOtherHouses()}

${units} total units ${occupants.toFixed(0)} total occupants

` root.value = { houses, unitsPerHouse, units, occupants } return root }35:[] 32:{"id":"85323f9b0534e9e7","slug":"apartment-block-internet-usage","title":"Apartment block internet usage","thumbnail":"2133983c65ca7f42c88b6dd8f726421c93c15307c6c2b34f9bf6f703c2aec315","access_level":"public","create_time":"$D2021-11-27T06:56:12.067Z","update_time":"$D2021-11-27T16:24:46.468Z","view_time":null,"first_public_time":"$D2021-11-27T15:21:59.844Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"c62aba2ac21021cb","login":"senritsu","name":"","avatar_url":"https://avatars-next.observableusercontent.com/2702f8a42e439426df2d134af708f1c3c3bdfa1a8434dfbeec26dfd7ce6bdcec","tier":"starter_2024"},"version":535,"publish_version":535,"role":null,"authored":false,"authors":[{"type":"individual","id":"cc9712af774c2953","login":"senritsu","name":"","avatar_url":"https://avatars-next.observableusercontent.com/2702f8a42e439426df2d134af708f1c3c3bdfa1a8434dfbeec26dfd7ce6bdcec","tier":null}],"members":[{"type":"individual","id":"cc9712af774c2953","login":"senritsu","name":"","avatar_url":"https://avatars-next.observableusercontent.com/2702f8a42e439426df2d134af708f1c3c3bdfa1a8434dfbeec26dfd7ce6bdcec","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Apartment block internet usage","cells":[{"id":0,"value":"# Apartment block internet usage\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":390,"value":"All bandwidths are given in MBit.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"## Setup","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"viewof averagePersonsPerHousehold = Inputs.range([1, 3], {step: 0.05, value: 2, label: 'Persons per household'})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"viewof block = renderBlock({\n houses: 12,\n unitsPerHouse: 30\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"viewof ageDistributionInBlock = renderAgeDistribution('Age distribution', {young: 0.1, middle: 0.6, old: 0.3}) // assuming a occupant distribution skewed towards affluent middle aged singles/DINKs","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"viewof bandwidthContractRange = renderContract({min: 30, max: 100})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":98,"value":"peakOverlap = 0.5 // assumption: 50% of all usage falls into the same evening/weekend timeslots","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":142,"value":"### Streaming","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":26,"value":"viewof uhdCapability = Inputs.range([0, 1], {step: 0.05, value: 0.3, label: 'UHD Capability'}) // from statista 2021, trend looks like a linear increase by ~5% each year","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"viewof averageBandwidthRequirements = renderStreamingBandwidth({hd: 7, uhd: 25})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"viewof streamingUsageByAge = renderAgeDistribution('Streaming usage', {young: 0.9, middle: 0.6, old: 0.1}) // 2021, last age bracket was more or less guesstimated","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"### Gaming","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":115,"value":"viewof gamerPopulationShare = Inputs.range([0, 1], {step: 0.05, value: 0.4, label: 'Gamer population share'}) // ref [2]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"viewof chanceOfUpdate = Inputs.range([0, 1], {step: 0.01, value: 0.05, label: 'Chance of update'}) // complete guesstimate","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"gameUpdateBandwidthUsage = dotProduct(bandwidthContractRange, {min: 0.4, max: 0.6}) // assuming most gamers have a contract on the higher end of the bandwidth range, and the update will saturate the link","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"gameUpdateSaturationBandwidth = block.occupants * gamerPopulationShare * gameUpdateBandwidthUsage","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":198,"value":"onlineGamingBandwidthUsage = 0.5","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"onlineGamingRatio = 0.3 // rough estimate of how many gamers play online during peak","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"## Expected bandwidth usage","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":97,"value":"estimatedStreamingPeak = \n block.occupants * \n dotProduct(streamingUsageByAge, ageDistributionInBlock) * // ratio of occupants who use streaming\n lerp(averageBandwidthRequirements.hd, averageBandwidthRequirements.uhd, uhdCapability) * // expected bandwidth use given uhd capabilities\n peakOverlap // factor for simultaneous use during peak times","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":338,"value":"estimatedGamingPeak = \n block.occupants *\n gamerPopulationShare *\n (chanceOfUpdate * gameUpdateBandwidthUsage + onlineGamingRatio * onlineGamingBandwidthUsage) *\n peakOverlap","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":76,"value":"# Functions\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":396,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"function renderContract ({min, max}) {\n const {min: saturatedMin, max: saturatedMax} = componentWise({min, max}, x => x * block.units)\n\n const renderDefault = x => htl.html`${x} MBit`\n const renderSaturated = x => htl.html`${x} MBit`\n \n const root = htl.html`Contract options between ${renderDefault(min)} to ${renderDefault(max)} lead to a saturation bandwidth for the whole block between ${renderSaturated(saturatedMin)} and ${renderSaturated(saturatedMax)}.`\n\n root.value = {min, max}\n return root\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":511,"value":"function renderStreamingBandwidth ({hd, uhd}) {\n const {hd: saturatedHd, uhd: saturatedUhd} = componentWise({hd, uhd}, x => x * block.occupants)\n\n const renderDefault = x => htl.html`${x} MBit`\n const renderSaturated = x => htl.html`${x} MBit`\n \n const root = htl.html`Average streaming bandwidth requirements between ${renderDefault(hd)} (HD) and ${renderDefault(uhd)} (UHD) lead to a saturation bandwidth for the whole block between ${renderSaturated(saturatedHd)} (HD) and ${renderSaturated(saturatedUhd)} (UHD).`\n\n root.value = {hd, uhd}\n return root\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":498,"value":"function renderAgeDistribution (label, {young, middle, old}) {\n const asPercent = x => `${(x * 100).toFixed(2)} %`\n const root = htl.html`${label}: 👶 ${asPercent(young)}, 🧑 ${asPercent(middle)}, 🧓 ${asPercent(old)}`\n\n root.value = {young, middle, old}\n return root\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"function lerp (a, b, t) {\n return (1 - t) * a + t * b\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":236,"value":"function dotProduct (v1, v2) {\n return Object.keys(v1).reduce((sum, key) => sum + v1[key] * v2[key], 0)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":255,"value":"function componentWise (v, f) {\n return Object.keys(v).reduce((result, key) => ({...result, [key]: f(v[key])}), {})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"# References\n\n1. https://www.ard-zdf-onlinestudie.de/ardzdf-onlinestudie/videonutzung-online/\n2. https://techjury.net/blog/video-game-demographics/","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 33:"$32:body"