2c:null 2d:["$","title",null,{"children":"333 Payouts Analysis | Ilia Naryzhny | Observable"}] 32:T63e,function input(config) { let {form, type = "text", attributes = {}, action, getValue, title, description, format, submit, options} = config; if (!form) form = html``; const input = form.input; Object.keys(attributes).forEach(key => { const val = attributes[key]; if (val != null) input.setAttribute(key, val); }); if (submit) form.append(html``); form.append(html``); if (title) form.prepend(html`

${title}

`); if (description) form.append(html`

${description}

`); if (format) format = d3format.format(format); if (action) { action(form); } else { const verb = submit ? "onsubmit" : type == "button" ? "onclick" : type == "checkbox" || type == "radio" ? "onchange" : "oninput"; form[verb] = (e) => { e && e.preventDefault(); const value = getValue ? getValue(input) : input.value; if (form.output) form.output.value = format ? format(value) : value; form.value = value; if (verb !== "oninput") form.dispatchEvent(new CustomEvent("input")); }; if (verb !== "oninput") input.oninput = e => e && e.stopPropagation() && e.preventDefault(); if (verb !== "onsubmit") form.onsubmit = (e) => e && e.preventDefault(); form[verb](); } return form; }33:[] 30:{"id":"d89090a34d8750ed","slug":"333-payouts-analysis","title":"333 Payouts Analysis","thumbnail":"d90b6dcf902e688d6876ed618e52593db8042943f3d1b82e8c71a4334fb86fc1","access_level":"public","create_time":"$D2018-10-18T22:09:43.441Z","update_time":"$D2020-03-23T01:45:42.363Z","view_time":null,"first_public_time":"$D2018-10-19T06:01:44.611Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"57e6b6a6a6a292f4","login":"phantomydn","name":"Ilia Naryzhny","avatar_url":"https://avatars-next.observableusercontent.com/39fe61d9856e2acdf2c3dd618697d2f0bade9a476b54e60cfcd328939a14ebd3","tier":"starter_2024"},"version":173,"publish_version":173,"role":null,"authored":false,"authors":[{"type":"individual","id":"73e04c112f9de8c0","login":"phantomydn","name":"Ilia Naryzhny","avatar_url":"https://avatars-next.observableusercontent.com/39fe61d9856e2acdf2c3dd618697d2f0bade9a476b54e60cfcd328939a14ebd3","tier":null}],"members":[{"type":"individual","id":"73e04c112f9de8c0","login":"phantomydn","name":"Ilia Naryzhny","avatar_url":"https://avatars-next.observableusercontent.com/39fe61d9856e2acdf2c3dd618697d2f0bade9a476b54e60cfcd328939a14ebd3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"333 Payouts Analysis","cells":[{"id":0,"value":"md`# 333 Payouts Analysis\n\nDonations: 0x98adc980e39f6f0b55fb9fde128cb8711660df87\n\nThis report provides information about 333v1 debts and payouts.\n\n333v1 Contract: ${addr333v1}
\n333v1 Reimbersement Contracts:
\n${addr333v1reimb.map(addr => \"\"+addr+\"
\")}\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":81,"value":"md`### 333 have to payback to the following investors\nTotal number of unpaid investors: ${nonReimbersed.length}\n\nTotal sum of reimbersements: ${d3.sum(Object.values(reimbersments))} ETH\n\nTotal current debt: ${-d3.sum(nonReimbersed, f(\"total\"))} ETH\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"tabulator(players)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"viewof yourAddr = text({title: \"Enter your ETH Wallet Address to see your stats\", placeholder: \"Your wallet addr\", description: \"Please keep etherscan format\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"{\n if(yourAddr.length!=42) return html`${yourAddr.length}`;\n var you = players.find(function(w) {return w.player.toUpperCase() === yourAddr.toUpperCase();});\n if(you) {\n return md`## ${you.total>=0?\"You are lucky!\":\"333 have to pay you \"+(-you.total)+\" ETH\"}\n\nYour investments: ${you.invested} ETH\n\nYour recieved as accruals: ${you.paid} ETH\n\nYou was reimbersed for: ${you.reimbersed} ETH\n\nYour total balance: ${you.total} ETH\n\nYour ROI: ${100*(you.total)/you.invested} %\n`\n } else {\n return html`

You was not found. If you definetly invested: contact with CryptoManiacs

`\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"txlist = loadTransactions(addr333v1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":32,"value":"investments = d3.nest().key(f(\"from\"))\n .rollup(function(v){ return d3.sum(v, f(\"value\"))/gw;})\n .entries(txlist.filter(noErrors))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"txlistInternal = loadTransactions(addr333v1, true)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"payouts = d3.nest().key(f(\"to\"))\n .rollup(function(v){ return d3.sum(v, f(\"value\"))/gw;})\n .object(txlistInternal.filter(noErrors))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"reimbersmentTxList = {\n var ret = []; \n const rets = await Promise.all(addr333v1reimb.map(addr => loadTransactions(addr, true)));\n return d3.merge(rets);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"reimbersments = d3.nest().key(f(\"to\"))\n .rollup(function(v){ return d3.sum(v, f(\"value\"))/gw;})\n .object(reimbersmentTxList.filter(noErrors))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"players = investments.map(function(i){\n var paid = payouts[i.key] || 0;\n var reimbersed = reimbersments[i.key] || 0;\n return {\n player: i.key,\n invested: i.value,\n paid: paid,\n balance: paid - i.value,\n reimbersed: reimbersed,\n total: paid + reimbersed - i.value\n };\n}).sort(function(a,b){return a.total-b.total})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":83,"value":"nonReimbersed = players.filter(function(p){return p.total<0})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"md`### Addendum`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"addr333v1 = \"0x311f71389e3de68f7b2097ad02c6ad7b2dde4c71\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"addr333v1reimb = [\"0x71D1f21D487e569257D5128BCf04A96AE9B14811\", \"0xa8Df3B6Df5d99d0aC1D6f19e2a687D00002dE70C\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"gw = 1000000000000000000 ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"async function loadTransactions(address, isInternal) {\n var action = isInternal ? \"txlistinternal\" : \"txlist\";\n var startBlock = 0;\n var results = [];\n var isNextNeeded = true;\n for(var i=0; isNextNeeded; i++) {\n var url = \"https://api.etherscan.io/api?module=account&action=\"+action+\"&address=\"+address+\"&startblock=\"+startBlock+\"&endblock=99999999&sort=asc&apikey=8ZRNEW99H7X41CUKXD12XU4VXYDISQD9TG\";\n console.log(\"URL=\"+url);\n var response = await d3.json(url);\n var res = response.result;\n if(res.length==10000) {\n startBlock = +res[res.length-1].blockNumber;\n var j=res.length-1;\n for(; j>=0; j--) {\n if(+res[j].blockNumber-startBlock < 0) break;\n }\n res.splice(j+1);\n }\n else isNextNeeded = false;\n results = i==0?res:results.concat(res);\n //console.log(\"Yelds results length\"+results.length);\n //yield results;\n }\n console.log(\"Results length\"+results.length);\n return results;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"function noErrors(t) {return t.isError==\"0\";}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"function f(name) {return function(d) {return d[name];}}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"$$ = require(\"jquery\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":75,"value":"require(\"jquery-ui\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"tabulator = {\n await require(\"jquery-ui\");\n await require(\"jquery.tabulator\");\n const cssUrl = \"https://cdnjs.cloudflare.com/ajax/libs/tabulator/3.5.3/css/tabulator.min.css\"\n const link=html``;\n\n\n if (window._tabLink) window._tabLink.remove();\n document.body.append(window._tabLink = link);\n return function(data, spec) {\n const div = html`

`;\n if(!spec) spec = {};\n spec.data = data;\n if(!spec.columns && data[0]) {\n //Generate columns\n const sample = data[0];\n spec.columns = [];\n Object.keys(sample).forEach(c=> {\n spec.columns.push({title:c, field:c});\n console.log(c);\n });\n }\n if(!spec.pagination) spec.pagination = \"local\";\n if(!spec.paginationSize) spec.paginationSize = 10;\n $(div).tabulator(spec);\n console.log(div);\n return div;\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"function text(config = {}) {\n const {value, title, description, autocomplete, maxlength, minlength, pattern, placeholder, size, submit} = config;\n if (typeof config == \"string\") value = config;\n const form = input({\n type: \"text\", title, description, submit,\n attributes: {value, autocomplete, maxlength, minlength, pattern, placeholder, size}\n });\n form.output.remove();\n form.input.style.fontSize = \"1em\";\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":119,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":121,"value":"d3format = require(\"d3-format\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1"}} 31:"$30:body"