31:T409,printErrors = function(errors) { const perRH = errors.filter( a => a.rh || (a.today && a.val != 'rh.occupant.total' && a.val != 'rh.employee.total') ).map(a => { if (a.today) { return 'DECREASE ' + a.val + ' ' + a.yesterday + ' → ' + a.today; } return '' + a.rh + ' ' + formatDif3(a); }).join('
'); const allRH = errors.filter(a => !(a.rh || (a.today && a.val != 'rh.occupant.total' && a.val != 'rh.employee.total'))).map(a => { if (a.today) { return 'DECREASE ' + a.val + ' ' + a.yesterday + ' → ' + a.today; } if (Object.keys(a).length == 3) { return 'TOTAL DSO ' + formatDif3(a); } const type = (a.agg_occupant || a.agg_employee) ? 'AGG DSO: ' : (a.stats_occupant || a.stats_employee) ? 'STATS: ' : ''; return type + Object.entries(a).map(kv => formatOccEmp(kv[0])+':'+kv[1]).join(' ≠ '); }).join('
'); return perRH + '' + allRH; }32:T6dc,errors_list = all_data.map((a, idx, arr) => { let sumTot = 0; let sumEmp = 0; let sumOcc = 0; const errors = []; homes.forEach(h => { const hTot = a['rh.' + h.id + '.total']; const hEmp = a['rh.' + h.id + '.employee']; const hOcc = a['rh.' + h.id + '.occupant']; if (+hTot != +hEmp + +hOcc) { errors.push({rh: h.id, total: hTot, employee: hEmp, occupant: hOcc}); } sumTot += +hTot; sumEmp += +hEmp; sumOcc += +hOcc; }); const mainStat = stats_data[dateStr(a.date)]; // Check DECREASE if (idx > 0) { for (const prop in a) { checkDecrease(a, arr[idx-1], prop, errors); } const mainStatPrev = stats_data[dateStr(arr[idx-1].date)]; checkDecrease(mainStat, mainStatPrev, 'cases.rh.employee.confirmed.todate', errors); checkDecrease(mainStat, mainStatPrev, 'cases.rh.occupant.confirmed.todate', errors); } const tot = a['rh.total']; const emp = a['rh.employee.total']; const occ = a['rh.occupant.total']; if (tot != emp + occ) { errors.push({total: tot, employee: emp, occupant: occ}); } if (sumTot != tot) { errors.push({total: tot, agg_total: sumTot}); } if (sumEmp != emp) { errors.push({employee: emp, agg_employee: sumEmp}); } if (sumOcc != occ) { errors.push({occupant: occ, agg_occupant: sumOcc}); } if (occ != +mainStat['cases.rh.occupant.confirmed.todate']) { errors.push({occupant: occ, stats_occupant: mainStat['cases.rh.occupant.confirmed.todate']}); } if (emp != +mainStat['cases.rh.employee.confirmed.todate']) { errors.push({employee: emp, stats_employee: mainStat['cases.rh.employee.confirmed.todate']}); } return errors.length == 0 ? null : ({date: a.date, errors: errors}); }).filter(a => a);33:[] 2f:{"title":"DSO Check | COVID-19 Sledilnik.org","cells":[{"id":0,"value":"md`# DSO Check | COVID-19 Sledilnik.org`","pinned":false,"hidden":false,"mode":"ojs"},{"id":30,"value":"html`${\n errors_list.map(e => {\n return '';\n }).reverse().join('')\n}

Date	Errors per RH	Errors
'+dateStr(e.date)+'	'+printErrors(e.errors)+'

`","pinned":true,"hidden":false,"mode":"ojs"},{"id":38,"value":"$31","pinned":true,"hidden":false,"mode":"ojs"},{"id":94,"value":"occImg = function() {\n return Math.random() < 0.5 ? '👴' : '👵';\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":76,"value":"formatOccEmp = function(str) {\n return str.replaceAll('occupant', occImg()).replaceAll('employee','🩺').replaceAll('agg_','∑');\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":58,"value":"formatDif3 = function(a) {\n return '🩺 '+a.employee+' + '+occImg()+' '+a.occupant+' ≠ '+formatDif2(a.total, a.employee + a.occupant);\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":62,"value":"formatDif2 = function(exp, actual) {\n if ((+actual) || actual===0) {\n return '' + exp + ' (' + (actual < exp ? (actual-exp) : ('+' + (actual-exp)))+')';\n }\n return exp;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":13,"value":"$32","pinned":true,"hidden":false,"mode":"ojs"},{"id":125,"value":"checkDecrease = function (newObj, oldObj, prop, errors) {\n if (+newObj[prop] < +oldObj[prop]) {\n errors.push({val: prop, today: newObj[prop], yesterday: oldObj[prop]});\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":16,"value":"homes = Object.keys(all_data[all_data.length-1]).filter(a => a !='rh.total' && a != 'rh.employee.total' && a != 'rh.occupant.total' && a.endsWith('total')).map(a => {\n const spl = a.split('.');\n return ({\n id: spl[1] + '.' + spl[2],\n municipality: spl[1]\n });\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"all_data = d3.csv('https://raw.githubusercontent.com/sledilnik/data/master/csv/retirement_homes.csv', d3.autoType).then(arr => arr.map(\n (a, idx, arr) => {\n for (const propName in a) {\n if (idx > 0 && a[propName] === null) {\n a[propName] = arr[idx-1][propName];\n }\n }\n return a;\n }))","pinned":true,"hidden":false,"mode":"ojs"},{"id":99,"value":"stats_data = d3.csv('https://raw.githubusercontent.com/sledilnik/data/master/csv/stats.csv', d3.autoType).then(\n arr => {\n const retObj = {};\n arr.forEach(d => {\n retObj[dateStr(d.date)] = d\n });\n return retObj;\n }\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":42,"value":"dateStr = d3.utcFormat(\"%Y-%m-%d\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"d3 = require('d3','d3-time')","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W33","stdlib":"1","titling":"auto"}