Reputation
1,397
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
2 11 31
Impact
~233k people reached

Jun
23
awarded  Popular Question
Jun
8
comment Excel Run Length Encoding
I accepted this morning after confirming it worked on the production spreadsheet (needed to make sure it didn't need tweaking to play nice with everything else that one was doing.) I had to use the formulas: Filters don't update every time calls to random regenerated the bit sequence I was using as input and changed the rows that needed filtered as a result.
Jun
8
accepted Excel Run Length Encoding
Jun
6
comment Excel Run Length Encoding
If it's not obvious to anyone else reading this answer; if you need more than 100 data points the column E/F formulas will need edited to take a larger input range.
Jun
6
comment Excel Run Length Encoding
I might be able to use a filter that excludes blank cells in place of the formula in the last two columns. Depends on how nicely it plays with downstream logic in the sheet on Monday morning.
Jun
5
revised Excel Run Length Encoding
clarified
Jun
5
comment Excel Run Length Encoding
@Byron exactly, and fixed.
Jun
5
revised Excel Run Length Encoding
edited body
Jun
5
asked Excel Run Length Encoding
May
28
awarded  Popular Question
May
14
comment Is liquid cooling necessary for high CPU performance over extended periods?
FYI newer versions of Prime95 use FMA instructions in stress testing (and presumably normal prime hunting too); making it function more like a power virus/short term burn test tool than the long term stress tester that it historically was. For my 4790k, IIRC, they pushed it ~20W above TDP at stock speeds/clocks; and 15C above the thermal load of an older non-FMA version. (I was running watercooled so my thermals were reasonable; I wouldn't be so confident about the stock Intel cooler doing well.)
May
10
comment When do I need a pure sine wave UPS?
@WarrenYoung One review site I've seen linked to occasionally did do active PFC/modified sine UPS testing. IIRC the normal result was that the maximum load the PSU could handle was less than the PSU or UPS should've been able to do. I don't recall if it was the PSU, the UPS, or both that was being de-rated; if it was the UPS you might be able to get that PC through an outage by using a more powerful backup for it. I'd probably go with just replacing the PC's power supply rather than deal with any potential headaches down the line from a non-standard config through.
Mar
25
comment How do I tell if my Memory is ECC or Non-ECC?
@DavidGrinberg it means your memory doesn't have ECC. Outside of servers and some high end work stations very few computers use it.
Mar
25
revised How do I tell if my Memory is ECC or Non-ECC?
corrected command
Mar
25
comment How do I tell if my Memory is ECC or Non-ECC?
@kristianp The 2nd command had two typos in it, should've been: wmic memphysical get memoryerrorcorrection (worked for me in 8.1)
Mar
25
suggested approved edit on How do I tell if my Memory is ECC or Non-ECC?
Mar
6
awarded  Nice Question
Mar
3
comment Fully expand email thread in outlook conversation view with single key stroke
@sunk818: I don't think what I'm seeing in 2010 could be called a regression bug. From descriptions of what's going on MS decided to be "clever" and only show an abbreviated subset of messages containing unique text. Any messages that were fully quoted in a reply are initially hidden. If that's changed in 2013, I'd call it a user revolt instead. I have access to MS HUP via my employer, so I can get a copy of 2013 cheaply. I'm not thrilled by the styling changes; but a working tree view combined with all day meetings showing on the appointment list (07 doesn't) is worth it I guess.
Mar
3
comment “How do you want to open this file?” dialog appearing at random after upgrading to Windows 8/8.1
@DavidPostill Unfortunately not. Clicking any other window dismisses the How... window. I tried taping the mouse button down with the intent of removing the tape to release it over the How... window once it appeared, but the cursor was reset to the arrow when the How.. windows appeared.
Mar
3
comment “How do you want to open this file?” dialog appearing at random after upgrading to Windows 8/8.1
@Ramhound If I can't figure out where this is coming from, I might as well nuke it, do a completely clean install and destroy all the random crud that's accumulated over the years. Useful data's easy to restore from backup, it's the 10 zillion desktop applications that would need reinstalled that made porting my existing Win7 install to new hardware and upgrading to win 8 worth the effort.