Windows Network Location Awareness

A while back I was stuck in this strange world during two conferences. My Windows 7 laptop said there was no Wi-Fi connection (red marking through the network strength indicator) but things were working. That threw me off when things weren't actually working. A colleague mentioned Windows NLA (Network Location Awareness) which could get confused depending on the nature/quality of the network(s) you flip between.

Here are some people's thoughts on the matter: https://www.google.com/?q=windows%20%22network%20location%20awareness%22

Counting the number of times a word appears in a column in Excel

How do you count the number of times a thing appears in a column of text? For example, if you're the type of person who downloads your credit card information, how many purchases did you make at any particular vendor?

If you know the number of things you're counting is small and manageable, using count (if numeric) or counta (if non-numeric) at the bottom might be the way to go. But if you don't (or can't) know, there's an elegant, nifty use of countif that solves the problem instantly - without resorting to PivotTables or any fancy stuff.

(image property of KyleMit on StackOverflow)

You can then filter, group, etc.

COUNTIF(range, criteria) - set the range to the entire column, and just count the thing next to you.

Simple. Brilliant. Love it.

Full article at http://stackoverflow.com/questions/18661016/how-many-times-do-each-value-appear-in-a-column.

Microsoft Word: Find and Replace characters within parentheses

This is something I have to occasionally do, and I'm always re-learning from scratch:

Thing (I want to find and replace) with more stuff (different item to find and replace) and other info (the only consistent thing is that these are in parentheses) in-between.

1. Open the Find-Replace dialog
2. If necessary, click the More button to display and enable Use wildcards
3. The ( is a special character, so you must escape it with \ i.e. \(
4. Use the asterisk * to indicate the anythingness in-between
5. Terminate with \)
1. Your search string looks like \(*\)

Problem: How do I replace the contents between parentheses? Haven't figured that out yet. You use parentheses to demarcate items in a search string - (thing)(item)(stuff) in the Find box are represented as \1\2\3 in the Replace box. But (\()(*)(\)) in the Find box just keeps failing on me.

The trick at http://word.mvps.org/FAQs/General/UsingWildcards.htm doesn't quite seem to be the answer. Any ideas?

Getting Android media apps to ignore certain folders

Just learned this handy tip that I have yet to test out. On Android, you can prevent the media scanner from indexing a directory by placing a file entitled .nomedia in it.

http://android.stackexchange.com/questions/138470/how-to-make-my-car-realize-my-phones-system-sounds-arent-music

http://androidforums.com/threads/whats-a-nomedia-file.307529/

Algorithms can't be racist. It simply must be that Groupon customers fit an extremely slim, beautiful, and white profile. 37/37 deals for white people can't be wrong!

(Screen cap taken 2015-12-10 22:28 Eastern.)

 

You want the simple one-sentence explanation for what caused ISIS? (Karl remarks)

(From https://www.facebook.com/Karlremarks/photos/a.401607333254173.93233.395292190552354/914863288595239)
Holy (@#*&$ I cannot like this enough. How can I get the entire world of people who think They hate Us because They hate Our freedom and are evil borne of sheer evil to read this? What comes from nothing? What is born in a vacuum? What is really that simple?

I don't know why*, but I feel the need to make it crystal clear that I do NOT in any way approve of these Daesh-bags. But it is critical - CRITICAL - to realize that these things don't come out of nothing. They are reactions. But to what? And why against us? Why do we as a population persist in the myth that we're just angels and a bearded white man in the sky has blessed us with exceptional qualities? Why do we believe we're entitled to everything on Earth and there's no recourse? Everyone is either our resource or our enemy?

I really truly ask this - not rhetorically - especially for those who deeply believe that centuries of oppression are just bygones, that ongoing crushing of land, spirit, and people are somebody else's problem - or it doesn't matter because it only happens to faceless brown hordes of non-English speaking non-humans.

There will be no considered answers. There will be no road to Damascus moments. Because this is the Internet. The medium is flat. Our discussions aren't just flattened - they're polarized because humanity is stripped from these stupid comments. They become artificial binaries (us vs. them; we're right, they're wrong; clash of civilizations; G vs E), and everything is supposed to be completely and properly conveyed in one pithy, ironic meme.

If your philosophy is small enough to fit on a bumper sticker (or a meme), clearly you need a new philosophy. Daesh is not a simple problem - it's a systemic problem with wide and deep roots. Simple solutions - especially those that turn to violence (physical, emotional, spiritual) are absolutely guaranteed to fail. You CANNOT bomb and murder people until they love you. IT DOES NOT WORK. And for those who still think killing "them" is the right answer - how's that working out for you so far?

Still with me? This blog is public. Share it. I would really like some answers.

*Probably because this is the Internet, and more people are spoiling for an easy fight than looking for hard understanding.

Suddenly, there was no space left on my hard drive...

Got me a new laptop at work. Its hard drive is bigger than my old work laptop, so I'm storing my big files on it. The drive should have had well over 100 Gb remaining as of today. Imagine my surprise when the drive was almost full.

SpaceSniffer initially told me there was about 100 Gb of inaccessible files. Solution? Run it as administrator.

After that, I discovered the large files were one file. It was related to Windows Indexing, AKA Microsoft Search. SuperUser.com had an oldarticle on my exact issue. (It's on Vista; I'm running 8.1, but the problem is identical.) The upshot? Indexing went crazy, indexing everything I had and everything I linked to. For example, I have my old laptop hard drive mapped as a network drive on my new laptop. It indexed my old laptop drive as if it was relevant to the new laptop. That sort of nonsense.

Here's what worked, as per SuperUser.com:

1. Open services.msc
2. Stop "Windows Search"
3. Rename C:\ProgramData\Microsoft\Search\Data\Applications\Windows\Windows.edb
4. Start "Windows Search"
5. The directory rebuilds Windows.edb
6. Open Control Panel/Indexing Options
7. Click Modify
8. Uncheck Users or whatever else you don't want indexed
9. Click OK

Windows.edb is now < 74 Mb, down from 100 Gb .

Another approach, if you're not afraid of the administrator command prompt:

1. net stop "Windows Search"
2. del %PROGRAMDATA%\Microsoft\Search\Data\Applications\Windows\Windows.edb
3. net start "Windows Search"

One more option (easiest, and least risk): Control Panel > Indexing Options. Turn things off.