Posted by jpluimers on 2019/09/30
For people still using Facebook: visit it using www.facebook.com/?sk=h_chr.
This will open the chronological view of your Facebook feed.
Via:
–jeroen
Posted in Facebook, Power User, SocialMedia | Leave a Comment »
Posted by jpluimers on 2019/09/30
Since I always forget this: [WayBack] Exceljet: Get day name from date
If you need to get the day name (i.e. Monday, Tuesday, etc.) from a date, there are several options depending on your needs.
Basically there are four ways go get the day of the week; the first three are readable, but when ordered, they are ordered alphabetically. The last one is numeric.
Combining the numeric with the text is easier in for instance Pivot Legend Fields (Series).
So here they go (based on the above link), assuming that B4 contains a timestamp:
=WEEKDAY(B4) gives you the numeric weekday (starting with Sunday=1 to Saturday=7) which allows sorting in a meaningful order=TEXT(B4,"dddd") gives you the full day name of B4 in your locale=TEXT(B4,"ddd") gives you the shortened day name of B4 in your locale=CHOOSE(WEEKDAY(B4),"Sun","Mon","Tue","Wed","Thu","Fri","Sat") gives you a name of your liking from a series of 7 textsNote that depending on your locale, these formulas might actually need a semicolon:
=WEEKDAY(B4)=TEXT(B4;"dddd")=TEXT(B4;"ddd")=CHOOSE(WEEKDAY(B4);"Sun";"Mon";"Tue";"Wed";"Thu";"Fri";"Sat")–jeroen
Posted in Excel, Office, Power User | Leave a Comment »
Posted by jpluimers on 2019/09/30
Worthy short read: [WayBack] Meeting Agreements for High Performing Teams – Noteworthy — The Journal Blog
A quote from it:
[WayBack] Patrick Lencioni @patricklencioni: If someone offered me a single piece of evidence to assess the health of an org, I would want to observe the executive team during a meeting
–jeroen
via: [WayBack] Meeting Agreements for High Performing Teams – Noteworthy — The Journal Blog – Marjan Venema – Google+
Posted in Agile, Development, LifeHacker, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2019/09/27
Somehow I misplaced the manuals of my Sony STR-DE205 receiver, including the Operating Instructions.
Sony still makes receivers
I did find [WayBack] Sony STR-DE205 – Manual – AM/FM Stereo Receiver – HiFi Engine which has a Service Manual. It has no operating instructions though.
Luckily, the STR-DE205 is very similar to the Sony STR-DE305, which I found using sony str de205 filetype:pdf operating instructions and having an Operating Instructions copy at [WayBack] pdf.crse.com/manuals/3810995221.pdf.
In fact, all the pictures in that manual look remarkably similar to the STR-DE205, except for one: the remote control:
It has one extra button POWER, which the STR-DE205 lacks, which likely means the STR-DE305 can be powered on remotely (like my trusty Sony MHC-3000 mini set that is slightly older).
Anyway, programming is easy as long as you know you need to press one of the NUMERIC BUTTONS in step 5:
Getting the text out of the PDF was a bit of a pain, as even though it renders, DRM tried to prohibit copying.
Luckily there is a
pdftohtmlwith a-nodrmfeature in Poppler (software) – Wikipedia (unlike the Xpdf – Wikipedia it forked from that does not have this switch) which I got based on these links:
Some more images are below after some Sony STR-DE205 videos.
–jeroen
Posted in Hardware, History, Power User | Leave a Comment »
Posted by jpluimers on 2019/09/27
So I won’t forget; the steps below based on and assumes ~/Versioned is the directory where you keep repositories in:
alt_override tree, shame on GitHub)# cd ~/Versioned # git clone https://github.com/certbot/certbot.git ... # cd certbot # git fetch --all Fetching origin # git checkout alt_override Branch 'alt_override' set up to track remote branch 'alt_override' from 'origin'. Switched to a new branch 'alt_override' # ./certbot-auto --os-packages-only OS packages installed. # ./tools/venv.sh ... very long log ... Please run the following command to activate developer environment: source venv/bin/activate # source ./venv/bin/activate [venv] # venv/bin/certbot renew --force-renewal
–jeroen
Posted in Encryption, Let's Encrypt (letsencrypt/certbot), Power User, Security | Leave a Comment »
The Wiert Corner - irregular stream of stuff 