798 reputation
37
bio website
location Front Royal, VA
age 33
visits member for 4 years
seen 8 hours ago

Jun
13
comment How can I check to see if a group of cells in an Excel spreadsheet have equivalent relative formulas?
<kbd>Ctrl</kbd>+<kbd>`</kbd> is the shortcut for "Show Formulas." In Excel 2010, "Show Formulas" is on the "Formulas" ribbon in the "Formula Auditing" section.
Jun
5
revised Excel Edit Mode: Time without seconds
added 272 characters in body
Jun
2
comment How can I lock images to a cell in excel 2010?
The UI is slightly different in 2010, but the instructions are the same.
Jun
2
answered Excel Edit Mode: Time without seconds
May
27
comment How to draw 12W DC output from PC motherboard/PSU/USB?
@SNag I'm definitely interested in seeing your final solution. It would be worthwhile to post your solution as an answer to this question, in case it is useful to others in a similar situation.
May
8
comment How to draw 12W DC output from PC motherboard/PSU/USB?
I just posted my question over on the Electrical Engineering site: electronics.stackexchange.com/q/109661/41552
May
8
comment How to draw 12W DC output from PC motherboard/PSU/USB?
Also, @Nixda, excellent answer. You went above and beyond in finding all the items for purchase, avoiding any wiring or soldering. Upon consideration, I'm wondering if the sound bar would be bad news for the computer, since it can really draw a lot of power and is variable based on the volume output.
May
8
comment How to draw 12W DC output from PC motherboard/PSU/USB?
@SNag, it's your hardware on the line, and I'm no electrical engineer, but you're fine if your power supply has an over-abundance of amperage. All the outlets in your house have the same voltage, but have different amperage available (limited by circuit breakers). You don't really have to check an outlet's amperage unless you need more amperage than is provided.
Apr
30
comment Autohotkey - remapping keys doesn't work
{Ctrl}{Shift} autohotkey.com/docs/commands/Send.htm
Apr
21
awarded  Caucus
Apr
15
revised How to use Advanced Editing in Notepad++ or similar
Formatted example text as Code Samples for readability. Question really needs more work.
Apr
15
comment How to use Advanced Editing in Notepad++ or similar
Your question is vague. You give the tool you have (Notepad++) and samples of the text you want to edit, but you aren't clear on exactly what you're trying to accomplish. In order to automate a process, there has to be something true of the parts to be changed that is not true of the parts that must remain unchanged. What is this for your example?
Apr
15
suggested suggested edit on How to use Advanced Editing in Notepad++ or similar
Apr
8
comment When pasting, how can I ignore hidden columns in the destination range?
In case somebody wants the AHK solution: gist.github.com/Fluffums/10162893#file-ahk-literaltabpaste-ahk
Apr
8
comment When pasting, how can I ignore hidden columns in the destination range?
I've run into this scenario before as well. In my case, I was pulling data from a source, and running equations on columns I had inserted. I want to be able to paste updated data into the appropriate columns by hiding the equation columns.
Apr
7
comment How can i fix the mean of a column of randomly generated values?
No. =rand()*2 might be what you're looking for, but it won't "always" be 1.
Apr
7
comment When pasting, how can I ignore hidden columns in the destination range?
You inspired me to write an AutoHotKey script to handle this situation. Are you interested in an AutoHotKey solution? Or is that too far out of the scope of this question?
Apr
7
comment When pasting, how can I ignore hidden columns in the destination range?
This would seem like a common enough operation, once you start making use of hidden columns and rows.
Mar
26
answered Can MS Excel use non-printable characters as field separators in CSV files? If so, how?
Mar
26
comment Can MS Excel use non-printable characters as field separators in CSV files? If so, how?
I've added an explanation for how to do it with vanilla Notepad. If there is a built-in way to change the CSV separator, I'd love to hear about it. This method is definitely not something I'd be happy to perform, especially with any regularity.