31:T936,ten_years_ago_data = ([{"Will Ennett":1.2927,"Adam":1.5316,"Chris":0.0539,"Angus":-0.2646,"J-O-N. JON":0.5761,"Daniel Lambauer":0.7354,"Chloe":0.1335,"Mike":0.4075,"Mark Buchanan":-0.548,"Misha":0.0539,"Hugh":-1.9461,"Beth":-2.0258,"_row":"Arrogance"},{"Will Ennett":1.4965,"Adam":0.8056,"Chris":1.1874,"Angus":0.7752,"J-O-N. JON":0.5691,"Daniel Lambauer":-0.2248,"Chloe":0.2904,"Mike":-0.0609,"Mark Buchanan":-1.2974,"Misha":-0.8126,"Hugh":-1.8126,"Beth":-0.9157,"_row":"Dismissiveness"},{"Will Ennett":1.0187,"Adam":0.37,"Chris":-0.3326,"Angus":0.1991,"J-O-N. JON":-0.0351,"Daniel Lambauer":0.1991,"Chloe":0.7845,"Mike":-1.3419,"Mark Buchanan":0.2529,"Misha":-0.3326,"Hugh":0.6674,"Beth":-1.4496,"_row":"Thigh size"},{"Will Ennett":1.4169,"Adam":-0.267,"Chris":0.1007,"Angus":0.6792,"J-O-N. JON":0.4684,"Daniel Lambauer":-0.3208,"Chloe":-1.7939,"Mike":-0.1077,"Mark Buchanan":-0.3724,"Misha":-0.8993,"Hugh":0.1007,"Beth":0.9953,"_row":"Hairyness"},{"Will Ennett":0.6206,"Adam":0.007,"Chris":0.2342,"Angus":-0.281,"J-O-N. JON":-0.5386,"Daniel Lambauer":-0.281,"Chloe":0.363,"Mike":-0.5761,"Mark Buchanan":0.8782,"Misha":-0.7658,"Hugh":0.2342,"Beth":0.1054,"_row":"Irreverence"},{"Will Ennett":0.7002,"Adam":-0.9204,"Chris":-0.6792,"Angus":-0.185,"J-O-N. JON":-1.4379,"Daniel Lambauer":-0.185,"Chloe":0.4473,"Mike":0.4707,"Mark Buchanan":0.9532,"Misha":0.3208,"Hugh":0.3208,"Beth":0.1944,"_row":"Zest for life"},{"Will Ennett":-1.2646,"Adam":0.0234,"Chris":0.4473,"Angus":-0.9368,"J-O-N. JON":-0.1288,"Daniel Lambauer":1.0632,"Chloe":-1.4567,"Mike":0.0796,"Mark Buchanan":-0.0726,"Misha":0.4473,"Hugh":0.4473,"Beth":1.3513,"_row":"Social Skills"},{"Will Ennett":-1.3091,"Adam":-1.1054,"Chris":-0.5129,"Angus":0.2155,"J-O-N. JON":0.0796,"Daniel Lambauer":0.2155,"Chloe":0.555,"Mike":-0.3583,"Mark Buchanan":0.8267,"Misha":-0.5129,"Hugh":1.4871,"Beth":0.4192,"_row":"Footballing Ability"},{"Will Ennett":-2.7424,"Adam":-0.4122,"Chris":0.9274,"Angus":0.4871,"J-O-N. JON":0.267,"Daniel Lambauer":-0.5129,"Chloe":1.0375,"Mike":0.7986,"Mark Buchanan":-1.5222,"Misha":0.9274,"Hugh":-0.0726,"Beth":0.8173,"_row":"Merciless sarcasm"},{"Will Ennett":-1.2295,"Adam":-0.0328,"Chris":-1.4262,"Angus":-0.6885,"J-O-N. JON":0.1803,"Daniel Lambauer":-0.6885,"Chloe":-0.3607,"Mike":0.6885,"Mark Buchanan":0.9016,"Misha":1.5738,"Hugh":0.5738,"Beth":0.5082,"_row":"Tolerance"}])32:T928,now_data = ([{"J-O-N. JON":1.7229,"Chris":2.0277,"Adam":1.6374,"Mark Buchanan":-0.1247,"Daniel Lambauer":1.1801,"Misha":0.5612,"Chloe":-0.0485,"Mike":-0.3718,"Will Ennett":-1.1247,"Hugh":-1.8199,"Angus":-1.8199,"Beth":-1.8199,"_row":"Dismissiveness"},{"J-O-N. JON":1.3187,"Chris":0.5681,"Adam":0.067,"Mark Buchanan":2.4434,"Daniel Lambauer":0.6928,"Misha":0.0046,"Chloe":-0.4942,"Mike":-0.1224,"Will Ennett":-0.5566,"Hugh":-1.3072,"Angus":-1.3072,"Beth":-1.3072,"_row":"Arrogance"},{"J-O-N. JON":0.3326,"Chris":0.7667,"Adam":0.6351,"Mark Buchanan":-0.4503,"Daniel Lambauer":-1.0162,"Misha":-0.4734,"Chloe":0.6582,"Mike":-0.9538,"Will Ennett":0.5497,"Hugh":-0.0162,"Angus":0.9838,"Beth":-1.0162,"_row":"Thigh size"},{"J-O-N. JON":0.1201,"Chris":-0.612,"Adam":0.9238,"Mark Buchanan":0.254,"Daniel Lambauer":-0.4781,"Misha":-1.1432,"Chloe":0.321,"Mike":-0.2055,"Will Ennett":0.254,"Hugh":0.5219,"Angus":-0.4781,"Beth":0.5219,"_row":"Footballing Ability"},{"J-O-N. JON":0.0346,"Chris":0.4965,"Adam":1.4203,"Mark Buchanan":-1.7344,"Daniel Lambauer":-1.2725,"Misha":0.3048,"Chloe":-0.6189,"Mike":-1.0785,"Will Ennett":0.2656,"Hugh":0.7275,"Angus":0.7275,"Beth":0.7275,"_row":"Hairyness"},{"J-O-N. JON":-0.3626,"Chris":0.1363,"Adam":-0.8661,"Mark Buchanan":-0.1132,"Daniel Lambauer":0.3857,"Misha":0.0092,"Chloe":0.0115,"Mike":0.7552,"Will Ennett":-1.1132,"Hugh":0.3857,"Angus":0.3857,"Beth":0.3857,"_row":"Merciless sarcasm"},{"J-O-N. JON":-0.164,"Chris":-0.6836,"Adam":0.2771,"Mark Buchanan":0.0762,"Daniel Lambauer":-0.4434,"Misha":-0.843,"Chloe":0.1963,"Mike":0.8383,"Will Ennett":0.0762,"Hugh":0.5566,"Angus":-0.4434,"Beth":0.5566,"_row":"Irreverence"},{"J-O-N. JON":-1.0647,"Chris":-0.5935,"Adam":-1.6513,"Mark Buchanan":0.1709,"Daniel Lambauer":0.642,"Misha":0.2309,"Chloe":0.2887,"Mike":0.8799,"Will Ennett":0.1709,"Hugh":-0.358,"Angus":0.642,"Beth":0.642,"_row":"Zest for life"},{"J-O-N. JON":-0.9654,"Chris":-0.5035,"Adam":-1.5797,"Mark Buchanan":-0.7344,"Daniel Lambauer":0.7275,"Misha":1.3048,"Chloe":-0.6189,"Mike":-0.0785,"Will Ennett":0.2656,"Hugh":0.7275,"Angus":0.7275,"Beth":0.7275,"_row":"Social Skills"},{"J-O-N. JON":-0.9723,"Chris":-1.6028,"Adam":-0.8637,"Mark Buchanan":0.2125,"Daniel Lambauer":-0.418,"Misha":0.0439,"Chloe":0.3048,"Mike":0.3372,"Will Ennett":1.2125,"Hugh":0.582,"Angus":0.582,"Beth":0.582,"_row":"Tolerance"}])33:T6cf,deltas_data = ([{"Mark Buchanan":1,"Misha":0,"J-O-N. JON":0,"Adam":0,"Chris":0,"Daniel Lambauer":0,"Mike":-1,"Hugh":-1,"Beth":-2,"Chloe":-1,"Angus":-4,"Will Ennett":-3,"_row":"Dismissiveness"},{"Mark Buchanan":3,"Misha":-1,"J-O-N. JON":0,"Adam":-2,"Chris":0,"Daniel Lambauer":-1,"Mike":-1,"Hugh":0,"Beth":0,"Chloe":-1,"Angus":-2,"Will Ennett":-2,"_row":"Arrogance"},{"Mark Buchanan":0,"Misha":1,"J-O-N. JON":0,"Adam":2,"Chris":1,"Daniel Lambauer":-1,"Mike":-1,"Hugh":1,"Beth":0,"Chloe":2,"Angus":0,"Will Ennett":0,"_row":"Hairyness"},{"Mark Buchanan":0,"Misha":-1,"J-O-N. JON":0,"Adam":0,"Chris":-1,"Daniel Lambauer":-1,"Mike":1,"Hugh":0,"Beth":0,"Chloe":0,"Angus":-1,"Will Ennett":0,"_row":"Irreverence"},{"Mark Buchanan":0,"Misha":-1,"J-O-N. JON":0,"Adam":0,"Chris":1,"Daniel Lambauer":-2,"Mike":0,"Hugh":-1,"Beth":0,"Chloe":0,"Angus":0,"Will Ennett":0,"_row":"Thigh size"},{"Mark Buchanan":0,"Misha":-1,"J-O-N. JON":0,"Adam":-1,"Chris":0,"Daniel Lambauer":0,"Mike":0,"Hugh":-1,"Beth":0,"Chloe":0,"Angus":0,"Will Ennett":0,"_row":"Zest for life"},{"Mark Buchanan":0,"Misha":-1,"J-O-N. JON":0,"Adam":2,"Chris":0,"Daniel Lambauer":-1,"Mike":0,"Hugh":-1,"Beth":0,"Chloe":0,"Angus":-1,"Will Ennett":2,"_row":"Footballing Ability"},{"Mark Buchanan":3,"Misha":-1,"J-O-N. JON":0,"Adam":0,"Chris":0,"Daniel Lambauer":1,"Mike":0,"Hugh":1,"Beth":0,"Chloe":0,"Angus":0,"Will Ennett":3,"_row":"Merciless sarcasm"},{"Mark Buchanan":1,"Misha":1,"J-O-N. JON":0,"Adam":-1,"Chris":0,"Daniel Lambauer":0,"Mike":0,"Hugh":1,"Beth":0,"Chloe":2,"Angus":2,"Will Ennett":3,"_row":"Social Skills"},{"Mark Buchanan":1,"Misha":-1,"J-O-N. JON":0,"Adam":0,"Chris":1,"Daniel Lambauer":1,"Mike":0,"Hugh":1,"Beth":1,"Chloe":2,"Angus":2,"Will Ennett":4,"_row":"Tolerance"}])34:[{"id":"eb33a8350ff15c5e0d39842fb0adc1fc265c26aba0ee2c9ee65708891a7fd76c3a158acdc72e9df8f72a410f7d793a4fe7c0182311fe182e5562057de79ccffc","href":"https://static.observableusercontent.com/files/eb33a8350ff15c5e0d39842fb0adc1fc265c26aba0ee2c9ee65708891a7fd76c3a158acdc72e9df8f72a410f7d793a4fe7c0182311fe182e5562057de79ccffc","name":"now.PNG","type":"image/png","lastModified":1664813585309.884,"size":16829},{"id":"1290fdd2a3532ab819472c1f5930c48c61930d9d84a220e16f537294c853b7c74ce4e5e093344a8afff254f9153df18937c119526d401978d6bf8a51d08df400","href":"https://static.observableusercontent.com/files/1290fdd2a3532ab819472c1f5930c48c61930d9d84a220e16f537294c853b7c74ce4e5e093344a8afff254f9153df18937c119526d401978d6bf8a51d08df400","name":"10_years_ago.PNG","type":"image/png","lastModified":1664813585316.042,"size":25708}] 2f:{"title":"Your 'Personal Brand'","cells":[{"id":0,"value":"# Your 'Personal Brand'","pinned":false,"hidden":false,"mode":"md"},{"id":20,"value":"Think of this as a friendship brand progress score card. It's interesting that over 10 years you Dismissiveness and Arrogance scores have shot right down, and Tolerance gone the other way. If I were you I would forward this to your manager at work and use it as a case for promotion.","pinned":false,"hidden":false,"mode":"md"},{"id":574,"value":"Plot.plot({\n marks: [\n Plot.dot(toplines_used_data, {\n x: \"attribute\",\n y: \"score out of 5\",\n fill: \"facet\",\n sort: {x: \"y\", reverse: true}\n }),\n Plot.ruleY([0])\n ],\n width: width,\n height: 275,\n color: {\n legend: true,\n }\n})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":566,"value":"How it breaks down by friend\n\nJust so you can hold a grudge against the right people","pinned":false,"hidden":false,"mode":"md"},{"id":477,"value":"viewof period = Inputs.radio([\"10 years ago\", \"Now\", \"Difference\"], {label: \"Select:\", value: \"10 years ago\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":498,"value":"Inputs.table(used_data, {\n width: {\n \"Attribute\": 100\n },\n columns: columns,\n header: columnHeaders,\n format: tableFormats,\n layout: \"auto\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":559,"value":"desciptions[period]","pinned":false,"hidden":false,"mode":"ojs"},{"id":639,"value":"How it was asked & methodology","pinned":false,"hidden":false,"mode":"md"},{"id":641,"value":"_years_ago = FileAttachment(\"10_years_ago.PNG\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":646,"value":"now = FileAttachment(\"now.PNG\").image()","pinned":false,"hidden":false,"mode":"ojs"},{"id":716,"value":"### [NEXT: Your Net Promoter Score](https://observablehq.com/@mtsvelik/your-net-promoter-score?collection=@mtsvelik/andys-day-of-reckoning)","pinned":false,"hidden":false,"mode":"md"},{"id":719,"value":"# ⠀\n# ⠀\n# ⠀\n# ⠀\n# ⠀\n# ⠀\n### Technical stuff","pinned":false,"hidden":false,"mode":"md"},{"id":446,"value":"Code & data","pinned":false,"hidden":false,"mode":"md"},{"id":510,"value":"dynamicStyles = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":556,"value":"desciptions = ({\n \"10 years ago\": htl.html`Relative scores To ensure comparability between different people's answers I'm relativising the scores. Otherwise you cannot compare for example: Jon's nihilistic sarcasm, with Daniel's relentless positivity. To relativise, scores are indexing with respect to averages across friends / averages across attributes`,\n \"Now\": htl.html`Relative scores To ensure comparability between different people's answers I'm relativising the scores. Otherwise you cannot compare for example: Jon's nihilistic sarcasm, with Daniel's relentless positivity. To relativise, scores are indexing with respect to averages across friends / averages across attributes`,\n \"Difference\": htl.html`Absolute scores Differences in absolute scores by friend: Now - 10 Years Ago`\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":516,"value":"widthCalcs = ({\n \"10 years ago\": (x) => 100,\n \"Now\": (x) => 100,\n \"Difference\": (x) => 100 * (x < 0? -1*x: x) / 5\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":527,"value":"numberFormats = ({\n \"10 years ago\": \".1f\",\n \"Now\": \".1f\",\n \"Difference\": \".0f\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":531,"value":"colorCalcs = ({\n \"10 years ago\": (x) => {\n const red = \"#bc1c0e\"\n const lightRed = \"#bb7471\"\n const grey = \"#d6d9dc\"\n const lightGreen = \"#98d299\"\n const green = \"#167922\"\n let color = \"\"\n if(x < -2.5) {color = red}\n else if((x >= -2.5) && (x < -1)) {color = lightRed}\n else if((x >= -1) && (x <= 1)) {color = grey}\n else if((x > 1) && (x <= 2.5)) {color = lightGreen}\n else (color = green)\n return color\n },\n \"Now\": (x) => {\n const red = \"#bc1c0e\"\n const lightRed = \"#bb7471\"\n const grey = \"#d6d9dc\"\n const lightGreen = \"#98d299\"\n const green = \"#167922\"\n let color = \"\"\n if(x < -2.5) {color = red}\n else if((x >= -2.5) && (x < -1)) {color = lightRed}\n else if((x >= -1) && (x <= 1)) {color = grey}\n else if((x > 1) && (x <= 2.5)) {color = lightGreen}\n else (color = green)\n return color\n },\n \"Difference\": (x) => x < 0? \"#bb7471\": \"#98d299\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":504,"value":"function sparkbar() {\n return x => htl.html`

${d3.format(numberFormats[period])(x.toLocaleString(\"en\")/1)}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":488,"value":"columns = { \n const originalColumns = Object.keys(used_data[0]).filter(o => (o != period) && (o != \"_row\"))\n if(originalColumns.indexOf(rowHeaderColumn) > -1) originalColumns.splice(originalColumns.indexOf(rowHeaderColumn) , 1); \n return [rowHeaderColumn].concat(originalColumns)\n} ","pinned":false,"hidden":false,"mode":"ojs"},{"id":701,"value":"columnHeaders = {\n const obj = {}\n columns.forEach((o,i) => {\n obj[o] = o.split(\" \")[0] \n })\n return obj\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":491,"value":"rowHeaderColumnReplace = (o) => { \n if(typeof o[\"_row\"] != \"undefined\") o[rowHeaderColumn] = o[\"_row\"]\n return o\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":493,"value":"rowHeaderColumn = \"Attribute\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":502,"value":"tableFormats = {\n const o = {}\n columns.forEach((e,i) => {\n if(i != columns.indexOf(rowHeaderColumn)) o[e] = sparkbar(100) //width is percentage of 100\n else o[e]\n })\n return o \n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":485,"value":"used_data = all_data[period].map((o,i) => { \n return {\n \"Attribute\": o[\"_row\"],\n ...o\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":482,"value":"all_data = ({\n \"10 years ago\": ten_years_ago_data,\n \"Now\": now_data,\n \"Difference\": deltas_data\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":37,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":469,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":618,"value":"Friendship brand","pinned":false,"hidden":false,"mode":"md"},{"id":568,"value":"toplines_used_data = brand_toplines_data.map(o => { return {\n attribute: o[\"_row\"],\n \"score out of 5\": o[\"10 years ago\"],\n facet: \"10 years ago\", \n} }).concat(brand_toplines_data.map(o => { return {\n attribute: o[\"_row\"],\n \"score out of 5\": o[\"Now\"],\n facet: \"Now\", \n} }))","pinned":false,"hidden":false,"mode":"ojs"},{"id":55,"value":"brand_toplines_data = ([{\"10 years ago\":4.4,\"Now\":4.2,\"_row\":\"Zest for life\"},{\"10 years ago\":4.5,\"Now\":4.2,\"_row\":\"Irreverence\"},{\"10 years ago\":4,\"Now\":2.9,\"_row\":\"Dismissiveness\"},{\"10 years ago\":3.1,\"Now\":2.1,\"_row\":\"Arrogance\"},{\"10 years ago\":2.2,\"Now\":3.2,\"_row\":\"Tolerance\"},{\"10 years ago\":2.5,\"Now\":2.2,\"_row\":\"Footballing Ability\"},{\"10 years ago\":3.8,\"Now\":4.2,\"_row\":\"Hairyness\"},{\"10 years ago\":4.1,\"Now\":3.9,\"_row\":\"Thigh size\"},{\"10 years ago\":3.4,\"Now\":4.1,\"_row\":\"Social Skills\"},{\"10 years ago\":4.1,\"Now\":4.4,\"_row\":\"Merciless sarcasm\"}])","pinned":false,"hidden":false,"mode":"ojs"},{"id":388,"value":"import{myColor, friends} from \"@mtsvelik/40-years-and-counting-andys-friends\"","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W34","stdlib":"1","titling":"auto"}