2c:null 2d:["$","title",null,{"children":"Hypixel Guild Statistics | Cobus Theunissen | Observable"}] 32:T50f,guildGraph = { i; // just so it refreshes const maxX = d3.max(myGuild, d=>d["Slayer XP"]); const maxY = d3.max(myGuild, d=>d["Average Skill Level"]); const points = await vl.markPoint({tooltip: {"content": "data"}, clip: true}) .width(width-50) .data(myGuild) .encode( vl.y().field('Average Skill Level').scale({domain: [0,maxY]}).title("Average Skill Level"), vl.x().fieldQ('Slayer XP').scale({type: 'sqrt', domain: [0,maxX]}).title("Slayer XP"), //vl.color().fieldQ("averageSkillLevel").title("Average Skill Level"), //vl.shape().fieldN("c_delinquent"), //vl.size().field('combatXp').scale({type: 'sqrt'}).title("Slayer XP") ) .height(500); const line1 = await vl.markLine({clip: true}) .data([{x: 0, y:skillLevelCutoff}, {x: maxX*2 , y:skillLevelCutoff}]) .encode( vl.y().field('y'), vl.x().field('x'), vl.color().value("red"), vl.size().value('2') ); const line2 = await vl.markLine({clip: true}) .data([{x: slayerXpCutoff, y:0}, {x:slayerXpCutoff, y:maxY*2}]) .encode( vl.y().field('y'), vl.x().field('x'), vl.color().value("red"), vl.size().value('2') ); return vl.layer( points, line1, line2 ) .render(); }33:T761,getBestSkyblockProfile = (uuid) => { return fetch(endpoint + `/skyblock/profiles?uuid=${uuid}&key=${API_KEY}`) .then(r => r.json()) .then(r => r.profiles) .then(r => r.map( d => { let xp = 0; const member = d.members[uuid]; // sum up all the slayerXp for each profile if (member && member.slayer_bosses) { for (const [key, value] of Object.entries(member.slayer_bosses)) { xp += (value.xp ? value.xp : 0); } } // get the average combatXp const combatXp = ( (member.experience_skill_combat || 0) + (member.experience_skill_mining || 0) + (member.experience_skill_alchemy || 0) + (member.experience_skill_farming || 0) + (member.experience_skill_taming || 0) + (member.experience_skill_enchanting || 0) + (member.experience_skill_fishing || 0) + (member.experience_skill_foraging || 0))/8; const exactSkillLevel = lookupLevel(combatXp); const averageSkillLevel = ( lookupLevel(member.experience_skill_combat || 0) + lookupLevel(member.experience_skill_mining || 0) + lookupLevel(member.experience_skill_alchemy || 0) + lookupLevel(member.experience_skill_farming || 0) + lookupLevel(member.experience_skill_taming || 0) + lookupLevel(member.experience_skill_enchanting || 0) + lookupLevel(member.experience_skill_fishing || 0) + lookupLevel(member.experience_skill_foraging || 0))/8; return {slayerXp: xp, combatXp: combatXp, exactSkillLevel: exactSkillLevel, averageSkillLevel: averageSkillLevel, ...member} } ).sort((a,b) => b.slayerXp - a.slayerXp)[0] // pick the profile with the largest slayerXp ) .catch(e => e) }34:[{"id":"64659ea7a3621266d0a14033957b358a35942eeac76f239d2767d12bc8e67ad3975c041f9abf95e113e4f354ff180499e6c37858204a188d2d828fb29977ad6d","href":"https://static.observableusercontent.com/files/64659ea7a3621266d0a14033957b358a35942eeac76f239d2767d12bc8e67ad3975c041f9abf95e113e4f354ff180499e6c37858204a188d2d828fb29977ad6d","name":"tables@2.csv","type":"text/csv","lastModified":1593296689697.153,"size":1145}] 30:{"id":"649e7755ccb660c0","slug":"hypixel","title":"Hypixel Guild Statistics","thumbnail":"5bac83135cdce5bcae14c9fc1c20b828525d8b03033139e744030f79c7c8f09a","access_level":"public","create_time":"$D2020-06-27T20:24:06.090Z","update_time":"$D2020-07-22T19:20:45.483Z","view_time":null,"first_public_time":"$D2020-07-03T22:03:34.565Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"5097ed23e9872f77","login":"cobus","name":"Cobus Theunissen","avatar_url":"https://avatars-next.observableusercontent.com/4a17a065d7a0f5f9a64a852f7b26a4f875c2ff69eb17264c3bd9f81e69285c05","tier":"starter_2024"},"version":2780,"publish_version":2780,"role":null,"authored":false,"authors":[{"type":"individual","id":"c1daf2951ad616fb","login":"cobus","name":"Cobus Theunissen","avatar_url":"https://avatars-next.observableusercontent.com/4a17a065d7a0f5f9a64a852f7b26a4f875c2ff69eb17264c3bd9f81e69285c05","tier":null}],"members":[{"type":"individual","id":"c1daf2951ad616fb","login":"cobus","name":"Cobus Theunissen","avatar_url":"https://avatars-next.observableusercontent.com/4a17a065d7a0f5f9a64a852f7b26a4f875c2ff69eb17264c3bd9f81e69285c05","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Hypixel Guild Statistics","cells":[{"id":0,"value":"md`# Hypixel Guild Statistics`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2233,"value":"md`For player **${playerName}**, let's get the stats for his guild **${guildName}**`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2077,"value":"{\n return button({\n value: 'FETCH GUILD DATA',\n //desc:`loaded ${mutable i}`,\n buttonStyle: {\n background: '#7295FF',\n color: 'white'\n },\n onclick: objs => {\n mutable loading = true;\n \n d3.select(objs.button)\n .style('background', '#6786E5')\n .interrupt()\n .transition()\n .duration(300)\n .style('background', '#7295FF');\n \n if (mutable loading) {\n\n objs.output = d3.select(objs.div)\n .insert('a', 'div.desc')\n .attr('class', 'output')\n .style('margin-left', '5px')\n .style('font-size', '11px')\n .style('cursor', 'pointer')\n .style('border', '0.5px solid black')\n .style('border-radius', '5px')\n .style('padding', '5px')\n .on('click', function() {\n this.remove();\n objs.output = '';\n mutable loading = false;\n })\n .html('RESET');\n };\n\n },\n initialize: false\n})}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2151,"value":"html`loaded ${i} of ${guildMembers.length}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1543,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2517,"value":"md`## List of players below the threshold`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2544,"value":"viewof slayerXpCutoff = slider({\n title: 'SLAYER XP THRESHOLD',\n //desc: 'MAY THE FORCE BE WITH YOU.',\n min: 0,\n max: 80000,\n step: 100,\n value: 3000,\n theme: 'default-thin',\n background: {\n type: 'double',\n colors: ['#FF0000', '#FFAAAA']\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2556,"value":"viewof skillLevelCutoff = slider({\n title: 'SKILL LEVEL THRESHOLD',\n //desc: 'MAY THE FORCE BE WITH YOU.',\n min: 0,\n max: 30,\n step: 1,\n value: 15,\n theme: 'default-thin',\n background: {\n type: 'double',\n colors: ['#FF0000', '#FFAAAA']\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2606,"value":"md`There are **${belowCutoff.length}** players below the cutoff`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2519,"value":"belowCutoff = {\n i;\n return myGuild.filter(d => (d[\"Slayer XP\"] < slayerXpCutoff || d[\"Average Skill Level\"] < skillLevelCutoff))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2618,"value":"table(belowCutoff.map(d => {return {name: html`${d.Name}`, \"Slayer XP\": d[\"Slayer XP\"], \"Average Skill Level\": d[\"Average Skill Level\"]}}), {pageSize: 1000})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1960,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2032,"value":"md`## Player Information\nYou can set the UUID below to the UUID of the person whose Guild you want to analyze.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1402,"value":"UUID = ColinUUID","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":654,"value":"playerName = getPlayerName(UUID)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":694,"value":"player = getPlayer(UUID)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":590,"value":"playerSkyblockProfile = getBestSkyblockProfile(UUID)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2036,"value":"md`** Here are some users to choose from **`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4,"value":"DanielUUID = (await (await fetch(endpoint+`/key?key=${API_KEY}`)).json()).record.owner","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"ColinUUID = \"7a3b9bcbf14e4f4fa75703fcb099e305\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"md`## Guild information`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2097,"value":"guildName = {\n const uuid = UUID;\n const guildId = (await (await fetch(endpoint + `/findGuild?byUuid=${uuid}&key=${API_KEY}`)).json()).guild\n \n const guild = (await (await fetch(endpoint + `/guild?id=${guildId}&key=${API_KEY}`)).json()).guild\n return guild.name\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":745,"value":"guildMembers = {\n const uuid = UUID;\n const guildId = (await (await fetch(endpoint + `/findGuild?byUuid=${uuid}&key=${API_KEY}`)).json()).guild\n \n const guild = (await (await fetch(endpoint + `/guild?id=${guildId}&key=${API_KEY}`)).json()).guild\n const members = (await (await guild).members)\n return members\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2229,"value":"md`** Guild Loading... **`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1633,"value":"myGuild = []","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2053,"value":"mutable loading = false;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2723,"value":"delay = 500;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1870,"value":"guildLoader = {\n loading; // so that this is triggered whenever the value changes\n myGuild.length = 0;\n const members = guildMembers; \n const num = members.length;\n mutable i = 0;\n while(mutable i < num && mutable loading) {\n\n let uuid = members[mutable i].uuid;\n let sbProfile = await getBestSkyblockProfile(uuid);\n\n myGuild[mutable i] = {\n //UUID: uuid,\n Name: await getPlayerName(uuid),\n \"Slayer XP\": (sbProfile.slayerXp !== undefined) ? sbProfile.slayerXp : 0,\n \"Average XP\": (sbProfile.combatXp !== undefined) ? sbProfile.combatXp : 0,\n \"Average Skill Level\": (sbProfile.averageSkillLevel !== undefined) ? sbProfile.averageSkillLevel : 0,\n \"Exact Skill Level\": (sbProfile.exactSkillLevel !== undefined) ? sbProfile.exactSkillLevel : 0\n } \n\n if (!loading) break; else mutable i++;\n await Promises.delay(delay); // can't query the api too quickly!\n }\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1940,"value":"mutable i = 0","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":102,"value":"md`## Constants and general functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"API_KEY = \"8086fbbf-a0c5-4315-8f2c-f09a90afc796\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2433,"value":"md`*The API KEY was obtained from Daniel's Minecraft session by typing /key*.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":108,"value":"endpoint = \"https://api.hypixel.net\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":980,"value":"function checkError(response) {\n if (response.status >= 200 && response.status <= 299) {\n return response.json();\n } else {\n throw new Error(response.statusText);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"function getPlayer(uuid){\n return fetch(endpoint + `/player?uuid=${uuid}&key=${API_KEY}`)\n .then(checkError)\n .then(d => d.player)\n .catch(error => {\n return \"Error in getPlayer\"\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":261,"value":"function getPlayerName(uuid) {\n return getPlayer(uuid)\n .then(d => d.displayname)\n .catch(error => {\n return \"Error in getPlayerName\"\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"levelsSkyblock = d3.csvParse(await FileAttachment(\"tables@2.csv\").text(), d3.autoType)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2682,"value":"getBestSkyblockProfile(ColinUUID)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2685,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2744,"value":"lookupLevel = (xp) => {\n let averageSkillLevel = 0; \n let i = 0;\n while (levelsSkyblock[i]) {\n let l = levelsSkyblock[i];\n if (xp < l.TotalXP) {averageSkillLevel = l.Level - 1; break; }\n i++;\n } \n averageSkillLevel += (xp - levelsSkyblock[i-1].TotalXP)/(levelsSkyblock[i].TotalXP - levelsSkyblock[i-1].TotalXP)\n return averageSkillLevel;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2498,"value":"md`for the graph...`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2771,"value":"md`### This is heading 3`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2773,"value":"html``","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":705,"value":"md`## Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1539,"value":"import {vl} from '@vega/vega-lite-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2075,"value":"import {button, slider} from '@bartok32/diy-inputs'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2616,"value":"import {table} from \"@cobus/tables\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":184,"value":"d3=require(\"d3@5\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 31:"$30:body"