Posted by jpluimers on 2020/03/31
As I need this one day:
To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:
Source: [WayBack] Excel formula: SUMIFS with multiple criteria and OR logic | Exceljet
–jeroen
Posted in Development, Excel, Office, Office 2011 for Mac, Office 2013, Office 2016, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/30
Want : [WayBack] My other computer is a data center Stickers and T-shirts — DevStickers
Via: [WayBack] Ich trage schon seit dem Studium schon keine Uhr mehr, weil ich meine Existenz vor NTP-fähigen Geräten zubringe, von denen die meisten nebenbei bemerkt … – Kristian Köhntopp – Google+
Related: [WayBack] Urs Hölzle – Google+ My other computer is a data center
–jeroen
Posted in Cloud, Fun, Infrastructure, Power User, Quotes | Leave a Comment »
Posted by jpluimers on 2020/03/30
It seems Google Voice has gotten more restrictions over time that I was not aware of: [Archive.is] No forwarding phone number – Google Product Forums:
Bluescat said:
There is no bug involved here. And no, you haven’t stumbled on a way to game the system.Two things have changed.
- With the introduction of Google Hangouts’ ability to place and receive calls via a Google Voice telephone number, the requirement to maintain a 10-digit forwarding phone number was removed. So yes, you can remove all forwarding phone numbers from your account if you wish. However, keep in mind that you have now made it more difficult to access your account from a telephone, to manage your voicemail greetings, listen to messages, set Do Not Disturb mode, etc. Without a forwarding phone number, you have no way to do that over the phone.
- In response to fraud and abuse of the service, Google now requires that users have a valid, working (paid-service) telephone number, which hasn’t been previously used to claim another Google Voice number, to be eligible to be issued a new Google Voice number. This is designed to deter people from collecting multiple Google Voice phone numbers to use for spam, robocalling, stalking, etc. Once that number has been used to claim a Google Voice number, it can’t be used to claim another Google Voice number. However, there’s no requirement that it be left on the account. Removing the forwarding phone from one Google Voice account will not enable that forwarding number to be used to claim a Google Voice number for another account.
So, all you did was use up your husband’s entitlement to a Google Voice number.Finally, a disclaimer: Google Voice cannot be used for emergency 911 calling. Not having some alternative telephone service available for that purpose is a very bad idea.
–jeroen
Posted in Google, GoogleVoice, Power User | Leave a Comment »
Posted by jpluimers on 2020/03/27
HKEY_CURRENT_USER\Software\ODBC\ODBC.INIHKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INIVia: [WayBack] Windows registry on 32 and 64 bit windows, which also explains ODBCINST.INI to define drivers.
–jeroen
Posted in Database Development, Development, ODBC, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2020/03/27
I got this on Windows 10, 8.1 and 7, MacOS and Linux:
C:\bin>nmap -sn 192.168.71.0/24
Starting Nmap 7.80 ( https://nmap.org ) at 2020-03-24 13:44 W. Europe Standard Time
Assertion failed: htn.toclock_running == true, file ..\Target.cc, line 503
Luckily [WayBack] Nmap 7.8 Assertion failed: htn.toclock_running == true · Issue #1764 · nmap/nmap · GitHub has a solution: add the --max-parallelism 100 parameter:
C:\bin>nmap -sn --max-parallelism 100 192.168.71.0/24
Starting Nmap 7.80 ( https://nmap.org ) at 2020-03-24 13:48 W. Europe Standard Time
Nmap scan report for 192.168.71.1
...
Host is up.
Nmap done: 256 IP addresses (50 hosts up) scanned in 54.07 seconds
The other workaround is to have at least one ARP request succeed.
Via [WayBack] “Assertion failed: htn.toclock_running == true, file ..\Target.cc, line 503” – Google Search
–jeroen
Posted in *nix, *nix-tools, nmap, Power User | Leave a Comment »
Posted by jpluimers on 2020/03/27
Af en toe (met name als de batterij bijna leeg geweest is) heeft mijn TomTom XXL een probleem dat deze niet meer reageert op de “Ga door” knop in het scherm met de gegevens van de eigenaar.
Dit lost het op en meestal ben ik dan niet eens de tijdzone kwijt:
Probeer het navigatie systeem te resetten (30 sec. de “aan/uit” knop induwen). Het enige aan gegevens die u kwijt bent, is de tijdszone instelling en de klok.
Source: [WayBack] Meest voorkomende problemen TomTom – TomTom Update
De TomTom XXL gebruik ik nog steeds af en toe: ooit gekocht in de USA had het “World Life-time Map-upgrades”. Dat bleek alleen voor de eerste kaart te zijn die ik had gedownload (USA dus) maar de updates komen nog steeds uit.
–jeroen
Posted in LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2020/03/26
Often when you send large emails the only reply you get is a non-descriptive message like 552 5.3.4 Message size exceeds fixed limit from the SMTP server without an indication what the limit actually is.
Most SMTP servers however implement extensions in the EHLO greeting that returns a SIZE mail parameter. You can query it by hand using this:
telnet aspmx.l.google.com smtp Trying 108.177.119.27... Connected to aspmx.l.google.com. Escape character is '^]'. 220 mx.google.com ESMTP 32si3005669edb.510 - gsmtp EHLO example.org 250-mx.google.com at your service, [80.100.143.119] 250-SIZE 157286400 250-8BITMIME 250-STARTTLS 250-ENHANCEDSTATUSCODES 250-PIPELINING 250-CHUNKING 250 SMTPUTF8 QUIT 221 2.0.0 closing connection 32si3005669edb.510 - gsmtp Connection closed by foreign host.
There you can see the maximum message size at the time of writing is 157286400 bytes which is about 150 megabytes.
There is a nice Python script showing how to obtain it at [WayBack] Getting Information from EHLO | Erle Robotics Python Networking Gitbook Free (note this one does send an email, so you might want to trim the example if you just want to see the size).
More background reading:
smtplib.SMTP.ehlo (also documents esmtp_features)smtplib.SMTP.has_extnThis turns out to be a tad more complex, because DNS functionality isn’t part of core Python, and the rdata part of DNS records ends with a dot, which might not be usable with the SMTP library.
References for me when trimming down:
pip install or pip install --user–jeroen
Posted in Communications Development, Conference Topics, Conferences, Development, Event, Internet protocol suite, Power User, SMTP | Leave a Comment »
Posted by jpluimers on 2020/03/25
Het formulier https://www.e-inwoner.nl/prod/fr/Leiden/Verhuizing_doorgeven/new.digid is een klein beetje stuk, maar gelukkig is er een workaround.
Alle knoppen “Volgende” verversen alleen de linkerkant van het formulier, maar niet de invoervelden.
Dit zie je al bij de eerste stap als je bij “Inleiding” gelikt hebt op “Volgende”: links kom je op “Contactgegevens”, maar de invoervelden laten dat niet zien.
Posted in About, LifeHacker, Personal, Power User | Leave a Comment »
Posted by jpluimers on 2020/03/25
On Mac OS X with stock Python:
All you need to do is
sudo easy_install pip
After this, you might want to upgrade pip:
sudo pip install --upgrade pip
Source: [WayBack] python – How do I install pip on macOS or OS X? – Stack Overflow
You could go the homebrew way, but that means your system will have two Python installations usually causing a nightmare of path dependency orders. In addition, homebrew puts you on the wrong foot, so:
DO NOT DO THIS!
# brew install pip Error: No available formula with the name "pip" Homebrew provides pip via: `brew install python`. However you will then have two Pythons installed on your Mac, so alternatively you can install pip via the instructions at: https://pip.readthedocs.io/en/stable/installing/
–jeroen
Posted in Apple, Development, Mac OS X / OS X / MacOS, macOS 10.12 Sierra, macOS 10.13 High Sierra, Power User, Python, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/03/24
If you want to process the JSON form the Google Take Out, then below are some resources that will help you get started developing
Started developing you say?
Yes, of course the JSON does not match APIs any more, and of course Google has not provided and starting point or guidance.
A perfect execution of Sunset.
So you are on your own with:
All via [WayBack] Continuing the takeout data migration process with a first look at the data that is in the archive. – Edward Morbius – Google+
In the mean time, some people started hosting their HTML take out, for instance:
Here you have to note that the take out does not include media, and many hyperlinks still point to within Google Plus itself, for instance for circles and avatars.
Example:
–jeroen
Posted in Development, G+: GooglePlus, Google, Power User, SocialMedia, Software Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 