The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My work

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,798 other followers

Archive for January 9th, 2017

If anyone ever wants to have a batch of LTE dumb phones built…

Posted by jpluimers on 2017/01/09

via: “SF has lost track of buses because SFMTA didn’t upgrade from 2G (to 3G to 4G to LTE) and AT&T finally turned it off.” – Kristian Köhntopp – Google+

If anyone ever wants to have a batch of LTE dumb phones built:

+Jeroen Wiert Pluimers I’m not aware of simple-voice-only phones with LTE modem. From my former life at a telephone producer i remember costs to get a platform running and the effort spend on special editions, i’d say if you are willing to buy 50000 we could find someone producing this for you. In China. But as written above, a basic-2G service (for M2M and emergency signalling or calls) will stay for long.

–jeroen

Posted in Development, Hardware Development, LifeHacker, Power User | Leave a Comment »

How I remember the German word “Urheberrecht”

Posted by jpluimers on 2017/01/09

Los, heb die Uhr auf. Habe ich das Urheberrecht oder du?

Los, heb die Uhr auf. Habe ich das Urheberrecht oder du?

I’m partially word-blind and an learn by association.

So thanks to the below links, I can now remember Urheberrecht:

It’s about Ur, Heber and Recht.

–jeroen

Posted in LifeHacker, Power User | Leave a Comment »

Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons

Posted by jpluimers on 2017/01/09

To match dd/mm/yyyy and mm/dd/yyyy column values in columns C (Date1) and N (Date2), I used these formulas in row 2:

Meaning: Column: Formula: Explanation:
Date1Text I =TEXT(C2,”dd/mm/yyyy”) Interpret date text of the original text no matter the Excel settings
Date1Value J =DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2)) Encode the date text to an actual date: dd#mm#yyyy format where # is any separator
DatesEqual K =J2=L2 Are the encoded dates equal?
Date2Value L =DATE(RIGHT(M2,4),LEFT(M2,2),MID(M2,4,2)) Encode the date text to an actual date: mm#dd#yyyy format where # is any separator
Date2Text M =TEXT(N2,”mm/dd/yyyy”) Interpret date text of the original text no matter the Excel settings

 

Learn how to convert text values into dates in Excel. This lesson covers a range of different scenarios to help you. The comments have even more examples.

Source: Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons

Posted in Excel, Office, Office 2007, Office 2010, Office 2013, Power User | 1 Comment »

 
%d bloggers like this: