Michel Vuijlsteke's weblog

Tales of Drudgery & Boredom.

Tag: excel

Links van 15 november 2017 tot 8 januari 2018

IBM Design Language
Heerlijke stijlgids.

Trump is making Obama great again – The Boston Globe
Beyond the nation’s shores, there are some places around the world, though not many, where Trump is more popular than Obama. A 2017 Pew Research Center survey polled 37 nations across the world about their opinions of the two presidents, and all but two countries rated Obama higher. The ones that preferred Trump? Israel by 7 percentage points and Russia by 42.

Wij vergeleken de tarieven in 100 parkeergarages – Het Nieuwsblad
Voor wie drie uur wil parkeren zijn minstens 55 parkeergarages in België duurder dan de duurste parkings in Gent. Wil je acht uur parkeren dan zijn de duurste Gentse parkeergarages nog steeds goedkoper dan minstens 25 andere parkeergarages in het land.

Anzeigen und Ermittlungen nach Hass auf Baby laufen – Multimedia | heute.at
"Ich hoffe auf einen plötzlichen Kindstod", "Wenn sie 18 ist, ist sie eh schon eine Terroristin" und "Schiebt den Abschaum sofort ab". Hasserfüllte User ließen am Neujahrstag alle Grenzen des Geschmacks und Respekts hinter sich und begegneten dem Wiener Neujahrsbaby Asel mit schockierenden Kommentaren. Dabei dürfte aber auch die Grenze zur Strafrechtlichkeit überschritten worden sein. Auffallend: Viele User posteten mit ihrem echten Namen.

Everyone in Trumpworld Knows He’s an Idiot – The New York Times
There’s an old joke that describes where we are right now: A guy falls from a 50-story building. As he flies by the 25th floor, someone asks how it’s going. “So far, so good!” he says. Eventually, we’ll hit the ground, and assuming America survives, there should be a reckoning to dwarf the defenestration of Harvey Weinstein and his fellow ogres. Trump, Wolff’s reporting shows, has no executive function, no ability to process information or weigh consequences. Expecting him to act in the country’s interest is like demanding that your cat do the dishes. His enablers have no such excuse.

The Systems Thinker – Check In, Check Out: A Tool for “Real” Conversations – The Systems Thinker
Nothing encourages people to share their views more than the knowledge that they will be listened to with empathy. We jump in and out of tasks so frantically that we often have little time left to create the field of appreciation that enables full self-expression. This type of listening can extend beyond the check-in process. Once people begin listening to each other with empathy, they simply can’t go back to their ordinary meeting style. The empathy remains even as they advocate for their views, inquire into other views, and make decisions together.

Stop de borstvoedingsterreur – De Standaard
In oktober ben ik bevallen van mijn derde kind. Het eerste kwam er nu bijna veertien jaar geleden en sindsdien zijn zowat alle richtlijnen en adviezen veranderd: geen fruitpap maar groentepap eerst, flesjes moeten niet langer verwarmd worden en badjes hoeven niet meer dagelijks. Toch is één ding alvast niet veranderd: de borstvoedingsterreur.

The Systems Thinker – Systems Thinkers Must Go Down the Rabbit’s Hole – The Systems Thinker
At the root of every system, every set of paradigms, beats a story so deep that most people are born into it and then die without ever knowing that a different way of viewing the world might exist. Our worldview operates like a cosmic screenplay that we enact each moment of our lives, guiding our actions and, ultimately, creating our reality. When we don’t realize it exists, our worldview manipulates us like a disembodied puppeteer, guiding our actions and thoughts.

Donella H. Meadows, Places to Intervene in a System (1997)
Folks who do systems analysis have a great belief in "leverage points." These are places within a complex system (a corporation, an economy, a living body, a city, an ecosystem) where a small shift in one thing can produce big changes in everything. The systems community has a lot of lore about leverage points. Those of us who were trained by the great Jay Forrester at MIT have absorbed one of his favorite stories. "People know intuitively where leverage points are. Time after time I've done an analysis of a company, and I've figured out a leverage point. Then I've gone to the company and discovered that everyone is pushing it in the wrong direction!"

Michael Wolff: My Insane Year Inside Trump’s White House | Hollywood Reporter
Donald Trump's small staff of factotums, advisors and family began, on Jan. 20, 2017, an experience that none of them, by any right or logic, thought they would — or, in many cases, should — have, being part of a Trump presidency. Hoping for the best, with their personal futures as well as the country's future depending on it, my indelible impression of talking to them and observing them through much of the first year of his presidency, is that they all — 100 percent — came to believe he was incapable of functioning in his job. At Mar-a-Lago, just before the new year, a heavily made-up Trump failed to recognize a succession of old friends. Happy first anniversary of the Trump administration.

Aram Zucker-Scharff on Twitter: “These moments all seem inevitable. Oh, Chrome will be on top forever. But remember all those hip web devs making Firefox only sites back in… https://t.co/Fm2nB3q3id”
These moments all seem inevitable. Oh, Chrome will be on top forever. But remember all those hip web devs making Firefox only sites back in the day? Hubris leads to downfall. Chrome's wings are melting as we speak.

Strategic Storytelling for Designers – UX Design Collective
The hardest part of design is presenting work. This is not an additional skill, it is not a “soft skill,” presentation of ideas is essential to the role of a designer. If you cannot advocate for your ideas or your users, then you are missing fundamental aspects of what it means to design.

Prospect Theory and Loss Aversion: How Users Make Decisions
When choosing among several alternatives, people avoid losses and optimize for sure wins because the pain of losing is greater than the satisfaction of an equivalent gain. UX designs should frame decisions (i.e., questions or options given to users) accordingly.

You Are Not the User: The False-Consensus Effect
The false-consensus effect refers to people’s tendency to assume that others share their beliefs and will behave similarly in a given context. Only people who are very different from them would make different choices.

Net Promoter Score Considered Harmful (and What UX Professionals Can Do About It)
For some reason, NPS thinks that a 6 should be equal to a 0. Nobody else thinks this.

Mind your Manners – a look at late Medieval and Tudor mealtimes and The Banquet | Living History Today
Anyone who has ever seen an old film about the late Medieval/Tudor period can be forgiven for coming away with the idea that feasts were riotous chances to eat and drink far too much, as rowdily as possible. It would seem that everyone present tried to cram as much meat into their mouths as possible before hurling their bones at hungry dogs who prowled in the rushes on the floor. In fact, the only bit of this message that holds any truth at all are the rushes on the floor, and by Queen Elizabeth’s day rush matting which could be taken outside and shaken or swept was becoming far more fashionable.

Tracking Down the Roots of a “Super” Word : Word Routes : Thinkmap Visual Thesaurus
Supercalifragilisticexpialidocious. So many of us learned that outrageous mouthful of a word at an early age, when it was truly a verbal milestone to be able to pronounce it without getting tongue-tied. And just saying the word is an invitation to start singing the song from the classic 1964 Disney movie Mary Poppins. But how did the word come to be? When I heard the news that one of the Mary Poppins songwriters passed away last month, I set about to answer that question, taking me down many unexpected alleyways of 20th-century popular culture.

02 – Supercalafajalistickespeealadojus by RediculusT
The original from 1949. Disney claimed in the later court case the word in their song was a 'common slang word'.

Michael Wolff’s ‘Fire and Fury’: Inside Trump’s White House
Once he lost, Trump would be both insanely famous and a martyr to Crooked Hillary. His daughter Ivanka and son-in-law Jared would be international celebrities. Steve Bannon would become the de facto head of the tea-party movement. Kellyanne Conway would be a cable-news star. Melania Trump, who had been assured by her husband that he wouldn’t become president, could return to inconspicuously lunching. Losing would work out for everybody. Losing was winning. Shortly after 8 p.m. on Election Night, when the unexpected trend — Trump might actually win — seemed confirmed, Don Jr. told a friend that his father, or DJT, as he calls him, looked as if he had seen a ghost. Melania was in tears — and not of joy. There was, in the space of little more than an hour, in Steve Bannon’s not unamused observation, a befuddled Trump morphing into a disbelieving Trump and then into a horrified Trump.

Why Mother Teresa’s sainthood is tainted by controversy | JOE.ie
“A lying, thieving Albanian dwarf”

Origami-Style Cardboard Tents for Homeless in Brussels – The New York Times
With material tents forbidden on the streets of Brussels, homeless people in the Belgian capital are often left without a safe place to sleep. But one entrepreneur seems to have found a way around the rule: origami-style cardboard tents.

The Year the News Accelerated to Trump Speed – The New York Times
One year out, this may be Mr. Trump’s greatest trick: His tornado of news-making has scrambled Americans’ grasp of time and memory, producing a sort of sensory overload that can make even seismic events — of his creation or otherwise — disappear from the collective consciousness and public view. He is the magician who swallows a sword no one thought was part of the act, stuffs a dozen rabbits into a hat before the audience can count them — and then merrily tweets about “Fox & Friends” while the crowd strains to remember what show it had paid to attend in the first place.

Geert Noels: “Frankrijk chanteert België alsof het een kolonie is” | VRT NWS
Frankrijk wil dat ons land het Franse Rafale gevechtsvliegtuig aankoopt om de oude F16’s te vervangen. De Fransen voldoen niet aan de vorm- en procedurevereisten, maar spelen het anders. Zo stellen ze voor dat België 20 miljard euro economische compensaties zouden krijgen bij aankoop van de Franse jets. 16 miljard euro van deze 20 miljard euro zijn echter de optelling van huidige activiteiten van Franse bedrijven over een periode van 20 jaar. Hiermee zegt Frankrijk dat deze activiteiten onzeker zijn als we niet kiezen voor hun jets.

The year’s best film is an 18-hour TV series — ‘Twin Peaks’ | HeraldNet.com
I didn’t see anything else this year that matched Lynch’s wild experimental saga — surely the most expensive avant-garde film ever bankrolled by Hollywood. Lynch’s teeming (if often baffling) imagination was executed with supreme control, and Kyle MacLachlan’s dazed, vacant Dougie Jones was obviously the Man of the Year.

Beyoncé Caught Shapeshifting In Front Of Celebs At Serena Williams’ Wedding
Beyoncé’s legions of fans were dealt a devastating blow when the Single Ladies singer was caught shapeshifting into a reptilian at Serena Williams’ wedding ceremony on Saturday.

Kristina (11) ‘viert’ kerst in terugkeerhuis: “schandalig” | VTM NIEUWS
Staatssecretaris Theo Francken wil niet op de zaak reageren omdat het om een individueel dossier gaat.

The King William’s College quiz 2017 | From the Guardian | The Guardian
Whence the minty bivalves? Which Hungarians masqueraded as sheep? Who beheld the faces of man, lion and ox and eagle? Plus 177 more fiendish questions in the most tortuous quiz of them all

Quitting – Signal v. Noise
We all know people all over the spectrum. Someone who’s been working on something forever that’s never going to work out. And someone who quits every project they start before giving it a fair chance. Then we have those friends who seem to have the magical instinct to know when to quit and when to stick with it until it takes off. So how do you know when to quit? 3 months? A year? Is there some signal to look for?

Wie wir die Datenproduktion neu denken sollten
IT ist zu einer strategisch bedeutsamen Triebfeder für Unternehmen geworden. Wie Ideen aus der Massenfertigung genutzt werden können, um mit Daten digitales Geschäft zu generieren.

Big data meets Big Brother as China moves to rate its citizens | WIRED UK
On June 14, 2014, the State Council of China published an ominous-sounding document called "Planning Outline for the Construction of a Social Credit System". In the way of Chinese policy documents, it was a lengthy and rather dry affair, but it contained a radical idea. What if there was a national trust score that rated the kind of citizen you were?

(14) The Use of ASCII Graphics in Roguelikes: Aesthetic Nostalgia and Semiotic Difference | Mark R Johnson – Academia.edu
This article explores the semiotics of the "roguelike" genre. Most roguelikes reject contemporary advances in graphical technology and instead present their worlds, items, and creatures as American Standard Code for Information Interchange (ASCII) characters. This article first considers why this unusual graphical style has endured over time and argues that it is an aesthetic construction of nostalgia that positions roguelikes within a clear history of gameplay philosophies that challenge the prevailing contemporary assumptions of role-playing games. It second notes that the semantic code for understanding the ASCII characters in each and every roguelike is different and explores the construction of these codes, how players decode them, and the potential difficulties in such decodings. The article then combines these to explore how such visuals represent potential new ground in the study of game semiotics.

As Venezuela Collapses, Children Are Dying of Hunger – The New York Times
Kenyerber Aquino Merchán was 17 months old when he starved to death. His father left before dawn to bring him home from the hospital morgue. He carried Kenyerber’s skeletal frame into the kitchen and handed it to a mortuary worker who makes house calls for Venezuelan families with no money for funerals.

Microsoft Considers Adding Python as an Official Scripting Language to Excel
If approved, Excel users would be able to use Python scripts to interact with Excel documents, their data, and some of Excel's core functions, similar to how Excel currently supports VBA scripts.

jwz: Mitch McConnell, Prince of Dust
Mitch McConnell, prince of dust, took his current form on February 20, 1942, molded of a strange flesh, his mouth open and already seeking. Mitch McConnell, for whom the ghouls slaver, spent his childhood crushing spiders in paper napkins and stuffing them into his mouth, one after the other, and never was he seen to expel them at all. Mitch McConnell, who waits in the gravel pit, attended high school in Georgia, where he sat with the cobwebs and giggled, and would not say where all the town's dogs had gone.

What Omarosa Did Best: Get Fired – The New York Times
Ouch. "We don’t know what exactly Omarosa Manigault Newman did at the White House, but we do know the number one skill she brought to the table — being fired. Donald Trump has now axed her four times: on “The Apprentice” in 2004, on “The Celebrity Apprentice” in 2011 and 2013 and on Tuesday evening. She is really, really good at getting canned. Maybe her true purpose was to remind America of the time when Mr. Trump was popular because he fired people like her, including her."

Fernand Huts weg bij Voka – De Standaard
"You're fired!" "Ha! You can't fire me, I quit!!" — De Antwerpse haven- en logistieke groep Katoen Natie heeft zijn Voka-lidmaatschap opgezegd. Voka zegt dat zij Huts zelf aan de deur hebben gezet.

Mimi O’Donnell Reflects on the Loss of Philip Seymour Hoffman and the Devastation of Addiction – Vogue
Literally two weeks after Phil died, some fellow parents asked me to show up on a Friday morning to man the stall where they sold school paraphernalia. And after the fifth person suggested I should start running, I lost it. “I don’t want to fucking run,” I said. “I want to jump in the river and kill myself.” When I finally did decide to run, it was always at night by the Hudson. The darker and rainier it was, the more violent the water, the better. I couldn’t get enough. Something about the extremity of it, the closeness to death, was weirdly comforting. If I wanted to jump, it was there.

the cake is a lie. | MetaFilter
“Food is often seen in games as a means of survival, mostly as health. A piece of bread stolen off a vendor's table in Skyrim will grant you two health; the cabbage stew at the tavern will grant you 10. In The Legend of Zelda: Breath of the Wild, the spicy pepper steak will take the edge off of cold weather. A game like Castlevania: Symphony of the Night has a huge inventory of food items, many of which are dropped after knocking out enemies. While the enormous variety adds an element of immersiveness into Castlevania, it's often nothing health or a novelty. Though none of these games' food systems could be considered simplistic, they have a narrow view of eating; food is health, and eating is the mechanic in which it's used. It's easy to see food only as a function of survival, but there’s a whole breadth of games—”

This Is The Daily Stormer’s Playbook | HuffPost
"Women can be called the following: slut, whore, bitch, harlot, trollop, slag, skag. Whenever writing about women make sure to follow the prime directive and blame Jew feminism for their behavior."

(215) The Fantastic Masculinity of Newt Scamander – YouTube
Newt Scamander, protagonist of the Harry Potter spinoff, is an unconventional male hero. He performs a refreshingly atypical form of masculinity, especially for the lead in a fantasy adventure story.

PuTTY Begone! Microsoft will ship an OpenSSH client | TechCrunch
What what? "Microsoft has added its own ssh client to Windows, a move that points to more openness on the part of Redmond."

Sneeuw- en ijzelbestrijding | Stad Gent
Fijn om weten.

Belgium’s Lavish Energy Use Sheds Light on More Than Just Its Roads – The New York Times
“What purpose does it serve to illuminate at full power?” The official explanation is that it helps road safety and provides security. But critics doubt this and say the phenomenon sheds light not only on Belgium’s roads but also on a mutually profitable relationship among its politicians, electricity distributors and main energy supplier, Electrabel.

We messed up. We’re sorry, and we’re not rolling out the fees change. – The Patreon Blog
We’ve heard you loud and clear. We’re not going to rollout the changes to our payments system that we announced last week. We still have to fix the problems that those changes addressed, but we’re going to fix them in a different way, and we’re going to work with you to come up with the specifics, as we should have done the first time around.

xkcd: Seven Years
[hart breekt]

NATO Expansion: What Gorbachev Heard | National Security Archive
Declassified documents show security assurances against NATO expansion to Soviet leaders from Baker, Bush, Genscher, Kohl, Gates, Mitterrand, Thatcher, Hurd, Major, and Woerner

How to Get Your First 100k (Active) Users – Winnie
This was probably the biggest mistake we made early on. While we correctly sized up our target market (millennial parents) as heavy consumers of apps, when it comes to growth the web is still hugely important. These days the lion’s share of our organic growth comes from web traffic in the form of organic search, social shares and word of mouth. Mobile-first is great. Mobile-only is not.

Mohammed minder gediscrimineerd op huurmarkt (Brussel) – De Standaard
Door praktijktesten van de stad Gent worden kandidaat-huurders van vreemde origine er minder gediscrimineerd. Toch blijft Vlaams minister Homans ertegen gekant.

The Not Yorker
The Not Yorker is a collection of declined or late cover submissions to The New Yorker, curated by illustrators who love and admire traditional cover illustration. This is a site for celebrating cover art, and great ideas that didn't make it.

FAQ · Storify
Another one bites the dust: "Unfortunately, Storify will no longer be available after May 16, 2018. As of December 12, 2017, no new Storify.com accounts can be created."

Hate Smears India’s Symbol of Love, the Taj Mahal – The New York Times
Millions flock to marvel at its shimmering magnificence, with intricately inlaid and carved white marble inscribed with verses from the Quran, every year. And that is exactly what the Hindu right finds so galling. In October, it came to light that the state of Uttar Pradesh — where the Taj Mahal is located, in the city of Agra, and which is headed by the firebrand Hindu cleric Yogi Adityanath — had omitted the monument from its tourism brochure and cut its funding from the state’s tourism budget. Sangeet Som, a member of the Hindu nationalist Bharatiya Janata Party, railed that the Taj Mahal was “a blot on Indian culture” built by “traitors.”

Bat cave solves mystery of deadly SARS virus — and suggests new outbreak could occur
After a detective hunt across China, researchers chasing the origin of the deadly SARS virus have finally found their smoking gun. In a remote cave in Yunnan province, virologists have identified a single population of horseshoe bats that harbours virus strains with all the genetic building blocks of the one that jumped to humans in 2002, killing almost 800 people around the world.

The Family Gene | Tufts Magazine
There’s a disease you’ve never heard of. No one has. It’s so rare it doesn’t have a name. Just fourteen people are believed to have ever carried the gene for it. Five of them are in this 1979 picture of my family (that’s me there in the center, in green). The rest can all also be found on my family tree. The disease has killed many of the people I love and now I’ve got it, too. So my family has decided to put an end to it.

Jared Kushner is wreaking havoc in the Middle East | Moustafa Bayoumi | Opinion | The Guardian
Here’s where state department diplomacy should kick in. The US ambassador to Qatar could relay messages between the feuding parties to find a solution to the stand-off. So what does the ambassador to Qatar have to say about the Kushner-Salman alliance? Nothing, since there still is no confirmed ambassador to Qatar. What about the US ambassador to Saudi Arabia? That seat’s also vacant. And the US ambassador to Jordan, Morocco, Egypt? Vacant, vacant, and vacant. What about assistant secretary for Near Eastern affairs, a chief strategic post to establish US policy in the region? No one’s been nominated. Deputy assistant secretary for press and public diplomacy? Vacant. It’s partly this vacuum of leadership by Tillerson that has enabled Kushner to forge his powerful alliance with Salman, much to the detriment of the region. And in their zeal to isolate Iran, Kushner and Salman are leaving a wake of destruction around them.

Scientists discover dinosaur trapped in amber in unprecedented find – CNN
The tail of a 99-million-year-old dinosaur has been found entombed in amber, an unprecedented discovery that has blown away scientists.

Catapult | What the World Gets Wrong About My Quadriplegic Husband and Me | Laura Dorwart
When I lie awake at night, the honest-to-god truth is that I don’t fantasize about miracle cures and redemption songs. I dream of ramps. Ramps leading up to showers and houses and waterfalls, to haunted hayrides and carriages and job interviews and Capitol Hill. And level ground that fulfills its rhetorical purpose by keeping everyone on the same plane.

And Now: A Bummer | Jason Scott on Patreon
Essentially: Patreon has changed their fee structure, which translates to it costing more to support folks like me; but they also did it in the most disingenuous way possible, which compounded a bad idea into something much worse.

How Trump’s Jerusalem Move Just Helped Iran Win the Mideast
Trump managed to bring Turkey and Iran together by what they called his “wrong” and “illegal” action. In fact, Rouhani called for all 56 Muslim-majority countries to make a stand against the US. Iranian foreign minister Mohammad Javad Zarif said that Jerusalem will always be Arab and Islamic. The country’s Leader, Ali Khamenei, also weighed in, pledging to organize the Muslim world for a response. So now the Iranians (not Arabs) are the champions of Arab nationalism, while Saudi Arabia and Egypt are supine. So Trump is helping make Iran a leader of the Muslim world. Good job.

Palestinians recognize Texas as part of Mexico – The Beaverton
“We understand that the Mexican state of Texas is a sacred place for many large-buckled Americans, but they can rest assured that a two-state solution or a wall was not feasible,” explained Abbas. “Besides, most people in Texas speak Spanish.”

l’An 2000 – Le Berghain à Berlin et l’éthique du «no photos» – Libération.fr
La lentille du smartphone apparaît en fait comme un bouc-émissaire, comme la métaphore de ce que la scène berlinoise refuse à tout prix : les regards et les jugements. Rentrer au Berghain, c’est apprendre à ne jamais fixer son regard sur ce qui s’y passe. Non pas tourner la tête, mais juste s’en foutre.

Il paraît qu’en Allemagne, les hommes ne draguent pas. Je suis allée vérifier
"Ce soir, il y a un mec qui est venu me parler. Je crois qu’il me draguait mais c'était tellement subtil que je n'en suis pas sûre. On ne sait pas. Les Allemands draguent tellement mal que tu ne sais pas trop ce qu'il se passe."

"Ici, en tant que Française, tu te rends compte à quel point tu as construit ta féminité en étant au centre d'une attention que tu n'as pas désirée."

IFComp 2017
De winnaars van 2017!

Crusader Kings 2 data shows most kills | Rock, Paper, Shotgun
Royal incompetence simulator Crusader Kings 2 is one of the best games ever. Over hundreds of years, sultans and kings create new empires and murder their families. Today a data science man gets in touch to say he recorded a 700-year game in ‘observation’ mode, pulled out all the data like a big reel of cassette tape, shoved it through some kind of magical process I won’t pretend to understand, and came up with statistics on several rulers. This also resulted in detailed “networks” of kills and marriages. The important thing is: this lets us see who had the most babies.

Hi. I love you. | The Bloggess
Do something good and kind.  Laugh loudly.  Don’t wear pants.  Tell people you love them.  Embrace ridiculousness.  Be unapologetically yourself.  Inspire others.  Inspire yourself.  Salute the brave.

Aan Ivo Mechels, generaal-overste van Test-Aankoop – De Standaard
Is het niet mogelijk om in Test-Aankoop een lijst te publiceren van alle OCMW’s van Vlaanderen en daarbij de beste koop kenbaar te maken?

Émeute à Gand: “Ce qui frappe, c’est la différence de traitement médiatique et politique” – Belgique – LeVif.be
Ce qui me choque le plus dans la différence de traitement politico-médiatique de ces deux évènements, c'est que j'ignore s'il est mû par la phobie des jeunes "Marocains" ou par le mépris total pour les Roms.

Time Cube
Children will be blessed for Killing Of Educated Adults Who Ignore 4 Simultaneous  Days Same Earth Rotation. Practicing  Evil  ONEness – Upon Earth Of  Quadrants.  Evil Adult Crime VS Youth.   Supports Lie Of Integration.   1 Educated Are Most Dumb.   Not 1 Human Except Dead 1.   Man Is Paired,  2 Half 4 Self.   1 of God Is Only 1/4 Of God.

Curl Power: Poodles Return to the Field – Garden & Gun
Poodles take a bit longer to train, Louter says, than other hunting breeds. Part of that has to do with their intelligence (the AKC describes them as “very smart”). “When you train Labs, it’s all repetition and building muscle memory,” he explains. “Poodles find that very boring. You have to stay one step ahead of them and switch it up. Sometimes you even have to make it seem like they are the ones in charge.”And though poodles were originally hunting dogs, they’ve essentially had that instinct bred out of them. The AKC lists them as nonsporting. Says Louter: “A decently bred Lab knows what it’s supposed to do in life from a young age. With poodles, we’re trying to wake up those natural instincts, that love of water and that good nose.”

McDonald’s is stealing my dead weasel and it’s insultingly obvious. | The Bloggess
Someone get me a copyright lawyer and a small apron for this poor naked thing.

Chinees godbetert! GO! en het thuistaalbeleid.
Vele keren dit.

Andrew Anglin: The Making of an American Nazi – The Atlantic
How did Andrew Anglin go from being an antiracist vegan to the alt-right’s most vicious troll and propagandist—and how might he be stopped?

Links van 7 december 2014 tot 8 december 2014

How Not to Write an API — On Coding — Medium
One common pattern I see is that most APIs have a REST or NVP based API at it’s core. Then they generally have some method if signing a request. Following that is more than 1 way to send different types of data, between JSON, XML or a file stream. But one pattern always puzzles me. The documentation on these core APIs are usually lacking. Instead, they develop SDKs for specific languages. Now, on the surface, that make sense. Let’s make it easy to use our API in your language of choice. But that idea is flawed.

Programming Modern Systems Like It Was 1984
Imagine you were a professional programmer in 1984, then you went to sleep and woke up 30 years later. How would your development habits be changed by the ubiquitous, consumer-level supercomputers of 2014?

Dementia, Alzheimers and the Wanderers
Six in 10 people with Alzheimer’s and other forms of dementia become lost at least once. Why do they wander, and how do we stop them?

[48924] Please Offer An Excel Export Option
Data is ultimately meant to be consumed by people. This may come as a shock, but most people are not computer programmers. They are not going to read your CSV with Python and process it with Pandas or Numpy. They are not versed in the libcsv API, nor do they possess ambitions to convert your CSV to JSON in order to build a web mashup. Of the grammar of graphics, they know nothing. In all likelihood they are going to open your CSV file in Microsoft Excel 2004, or if you're lucky Microsoft Excel 2007, and they are going to spend hours building pixelated pie charts, bar charts, and 3D line graphs. You might not use Excel to analyze data, but they almost certainly will. So why not accommodate their intentions as well as you can? Isn't programming fundamentally about helping users achieve their goals?

Revealed: victims of UK’s cold war torture camp | UK news | The Guardian
A few were starved or beaten to death, while British soldiers are alleged to have tortured some victims with thumb screws and shin screws recovered from a gestapo prison. The men in the photographs are not Nazis, however, but suspected communists, arrested in 1946 because they were thought to support the Soviet Union, an ally 18 months earlier.

Datum en tijd

Ik ben stekejaloers op Stephen Wolfram’s datavisualisaties. En ik had vroeger data over vanalles (muisbewgingen! toetsaanslagen! programma’s gebruikt!), maar sinds ik op allerlei verschillende computers allerlei dingen doe, is het allemaal wat verwaterd.

Mijn mail, die heb ik in principe nog tot ergens in 1994, maar waar precies de mails van 1994 tot 2004 staan: ik zou er eens heel erg hard naar moeten zoeken.

Ik kan wél gemakkelijk dingen over dit weblog te weten komen, ’t is toch altijd dat. En ik heb geen Mathematica bij de hand liggen, maar uiteindelijk is er met een paar databasequeries en een gewone spreadsheet ook redelijk wat te visualiseren.

Zoals wanneer ik dingen geschreven heb, de afgelopen tien jaar. Elk puntje is een post, de X-as geeft de jaren weer en de Y-as de uren (klik voor detail):

Screen Shot 2012-03-10 at 12.10.09.png

In 2002-2003 waren er heel veel korte postjes van een paar zinnen, vaak als ik voor de televisie hing. In 2004 heb ik een jaar in mijn trekzetel geleefd. Vanaf midden 2009 zat ik vaak in Zaventem te werken bij Sony, wat ’s morgens anderhalf uur of meer trein en bus betekende, en dus geen internet. In 2010 ben ik in Gent komen werken, en werd mijn leven wat regelmatiger.

De horizontale strepen zijn automatische posts van links die ik verzamelde (eerst op delicious, daarna op pinboard).

[Om de grafiek te maken, trouwens, vooropgesteld dat het WordPress is dat achter uw weblog zit: in mysql select date(post_date), time(post_date) from wp_posts where post_status='publish'; doen, het resultaat daarvan in Excel plakken en een scatterplot maken met datum in X-as en tijd in Y-as.]

Met nog minder moeite is het mogelijk om te zien wanneer ik op uurbasis gemiddeld post:

Screen Shot 2012-03-10 at 13.51.27.png

[select time_format(post_date,'%H'), count(id) from wp_posts where post_status='publish' group by extract(hour from post_date);]

…of per minuut:

Screen Shot 2012-03-10 at 13.47.49.png

[select extract(hour_minute from post_date), count(id) from wp_posts where post_status='publish' group by extract(hour_minute from post_date)]

(Ik heb hierboven wel de waarden afgekapt wegens dat die automatische posten van delicieus/pinboard het anders vertekenden: )

Screen Shot 2012-03-10 at 13.59.30.png

Post ik meer tijdens de week of in het weekend? Euh nee, niet echt:

Screen Shot 2012-03-10 at 14.20.05.png

[select date_format(post_date,'%W'), count(id) from wp_posts group where post_status='publish' by date_format(post_date, '%W');]

Is er misschien een verschil in uren, afhankelijk van de dag in de week? Nee, ook niet echt heel erg duidelijk (rood is meer schrijven, groen is minder schrijven):

Screen Shot 2012-03-10 at 14.46.42.png

select date_format(post_date,'%W'), time_format(post_date,'%H'), count(id) from wp_posts group by date_format(post_date, '%W'), time_format(post_date, '%H'); en dan een pivot table maken, en conditional formatting op de cellen (en de cijfers in de cellen number formatting ” “, wat ze dus doet verdwijnen, ha!).

Of als ik toch bezig ben met van die heatmapachtige dingen: het aantal flickr-foto’s dat ik per week post? Waarmee het meteen duidelijk is dat ik sinds een tijd minder foto’s online zet, en ook dat de week met foto’s uit Marokko redelijk veruit de week met de meeste foto’s ooit was:

Screen Shot 2012-03-10 at 15.44.18.png

De cijfers hierboven zijn er van uitgaand dat ik voor zover ik weet praktisch nooit naar Flickr verwijs tenzij naar mijn eigen foto’s: select year(post_date), week(post_date), sum((length(post_content)-length(replace(post_content,'flickr.com','')))/length('flickr.com'))/2 from wp_posts where post_status='publish' group by year(post_date), week(post_date);.

En met dezelfde ruwe teltechniek: over welke kinderen spreek ik, opgeteld per maand?

Screen Shot 2012-03-10 at 16.52.40.png

Of: aantal woorden per post? (Ervan uitgaand dat er ruwweg evenveel woorden als spaties in een tekst staan.)

Screen Shot 2012-03-10 at 17.42.04.png

De puntjes zijn de individuele posts, de lichtste lijn is een gemiddelde per week, de donkere lijn een gemiddelde per maand, en de rode stippellijn het gemiddelde op jaarbasis bekeken.

Afijn ja. 🙂

De tools maken de man (niet) ii

Ik geef het toe: ik word er een beetje kregelig van, als ik zoiets lees van “met welk programmaatje hebt gij dat gemaakt”. Dat is voor mij de andere kant van de zo mogelijk nog meer irritante vaststelling “PowerPoint zuigt”.

It’s a poor workman who blames his tools, zeggen ze, en ze hebben daar overschot van gelijk in. Een min of meer leesbare grafiek maken, heeft weinig of niets te maken met het programma waarin de grafiek gemaakt wordt.

Gegeven een lijst van gegevens in ongeveer deze vorm, die ik met een query uit de WordPress-database gegenereerd heb en dan geopend in Excel (2007, maar dat doet hier niets ter zake):

post_date posts comments postlength words length/post
02/07/2002 415 36 192918 35726 86
03/07/2002 544 100 295672 54754 101
04/07/2002 645 116 360288 66720 103
05/07/2002 428 85 209634 38821 91

Stap één, de kolommen geselecteerd waarin ik geïnteresseerd ben en insert > line chart gedaan. Dat geeft iets in deze zin (alhoewel: ik heb hier al twee van de drie lijnen op één as gezet, en één op de andere as):


…en dan kan een mens zich gaan uitleven in de Mogelijkheden Van Het Programma. Zoiets bijvoorbeeld:


Woohoo! Groots! 3D! Spectaculair! Onleesbaar! Nutteloos!

Nee, ik ben helemaal een gelover in de Tufte School of Infographics: haal alles weg dat niet absoluut noodzakelijk is, en wees zo eerlijk als mogelijk in het voorstellen van de gegevens.

En daar heb je helemaal geen speciaal tool voor nodig, gewoon wat minimale kennis van om het even welk programma waarin je werkt. In mijn geval is dat Excel 2007, maar het had even goed een oudere versie van Excel kunnen zijn, of Illustrator, of voor mijn part Openoffice.org calc.

Stap één: overbodige kleur weghalen. In het ideale geval en als het missiekritisch is, betrouw ik niet op kleur: een redelijk percentage van de volwassen mannen zijn kleurenblind, niet iedereen heeft een kleurenprinter, kleuren hebben een intrinsieke emotionele waarde, etc., etc.


Hier: de achtergrond weggehaald (deed niets te zake), aantal posts en lengte per post in dezelfde kleur gezet en onderscheiden door het soort lijn (discutabel, ik weet het).

Stap twee: overbodige lijnen weghalen. Al die kaders en de lijnen op de assen, brengen die eigenlijk informatie aan? Nee, niet echt. Dus ze mogen weg. De gridlines, die brengen wel informatie aan, maar ze storen omdat ze te nadrukkelijk aanwezig zijn. Dus die mogen in een lichter grijs komen te staan.


Zo. De grafiek is nu wel heel erg gecomprimeerd in de breedte, dus heb ik ze nog wat uitgerekt. Eens ze uitgerekt was, heb ik de data op de Y-as anders geformatteerd (jaar maand, vertikaal ipv dag/maand/jaar, schuin), en heb ik nog vertikale gridlines toegevoegd ook, dat ik gemakelijker kan zien in welke maand iets gebeurt. En om duidelijk te maken welke lijnen op welke as gevolgd moeten worden, heb ik de labels van de assen dezelfde kleur gegeven als de lijnen.

Dat geeft dan dit:



…enfin ja, om maar te zeggen: het tool maakt dus écht niet uit. Koop dit en dit en dit en ge zijt vertrokken.

© 2018 Michel Vuijlsteke's weblog

Thema gemaakt door Anders NorenBoven ↑