3,982 reputation
134192
bio website security.stackexchange.com
location Florida
age 32
visits member for 3 years, 10 months
seen 12 hours ago

I'm not the droid you're looking for.


Jul
16
comment Excel - How to compare columns for equal values
This method is still no good. Instead of returning "Not Found" for items not found, it will show "#N/A" because the VLOOKUP hits an error. I use VLOOKUP as part of my formula for similar situations also, though. I'm posting the write-up now.
Jul
16
comment Excel - How to compare columns for equal values
LOOKUP has a note that it is "provided for backward compatibility". So, another method is probably preferable to ensure compatibility with future (or, at least near-future) versions of Excel. Also, it appears that LOOKUP will return approximate matches when an exact match is not found. This means your IF statement will always return "Found" - try running it with 16 in column B when column A's numbers max at 15.
Jul
16
comment Hybrid HDD randomly parks
@slow_excellence My laptop's fans can get pretty loud too, especially playing Kerbal Space Program. Still, I can sometimes hear the drive park even then. I guess I just got sensitive to HDD sounds, since they used to be the primary means of knowing if your computer was actually working when it might otherwise appear unresponsive.
Jul
16
comment Hybrid HDD randomly parks
@slow_excellence That's currently at 175, which seems really low for the time I've had the drive and how often I hear it park.
Jul
16
comment Hybrid HDD randomly parks
@slow_excellence Thanks for the link. I'm using NirSoft's DiskSmartView to check the S.M.A.R.T. statistics on my drive, but I'm having a hard time figuring out which value should indicate the "spin up/down cycles" mentioned in the article.
Jul
16
asked Hybrid HDD randomly parks
Jul
16
comment Is there a time tracking software available for my needs?
@Alex Actually, it's generally preferred to allow the question to be migrated to the other site instead of cross-posting it. If you haven't already posted on Software Recommendations, please flag your question and provide a note requesting the moderators here to migrate it.
Jul
16
comment Windows 7 Tablet and Local HTML Files
AFAIK, all versions of Windows with IE - all the way back to Windows 95 - are capable of viewing local HTML files just as well as they can view web-based ones. Is there a specific problem you're having with IE on your Windows 7 tablet?
Jul
15
awarded  Popular Question
Jul
15
awarded  Notable Question
Jul
11
awarded  Famous Question
Jul
10
comment Batch script to only run command for 1 machine
I wouldn't personally use IF NOT x == y where IF x NEQ y would be equally effective, but that's just a matter of personal preference. The only way you can use %IP% as an element in your conditional statement is if you have by some means already assigned the system's IP address to that variable - it is not a built-in environment variable, like %COMPUTERNAME% is.
Jul
7
answered Excel column entries modification
Jul
7
answered Batch script to only run command for 1 machine
Jul
7
comment Why does the PowerShell ISE not isolate script variables to the script scope?
I don't see anything in the linked post addressing this behavior.
Jul
5
asked Why does the PowerShell ISE not isolate script variables to the script scope?
Jul
3
comment Why does BitLocker need a minimum volume size of 64 MB?
@FooBar Perhaps, but BitLocker imposes much more unnecessary overhead by far than the file systems do. And, since TrueCrypt has been abandoned (at least until someone forks it) I'm not aware of any other reasonably trusted and free file/container encryption software that's being actively maintained.
Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
Jun
25
comment Windows Remote Assistance over Internet (through NAT)
@AlexD Two different programs, but both use the Terminal Services (AKA Remote Desktop Protocol) on port 3389. technet.microsoft.com/en-us/library/bb457004.aspx