xtina: (Default)
"Why the fuck is there an entry in Activity Monitor for "Google Chrome Helper" that's taking up ~98% CPU?!?"

Steps to resolve:

* In Chrome, go to Window > Task Manager, or to [menu dots thing] > More Tools > Task Manager.
* Sort the list by CPU descending.
* Find whatever is making that top entry so horrible and kill it.

In my specific case, it's this entry:

Subframe: http:__hanstrackr[dot]com

It's correct in the CTM. I just don't want folk accidentally clicking it.

I googled on "hanstracker" and got a thread that suggested disabling a couple of specific extensions. The one I disabled that entirely removed this entry was Flatbook. It might be because the hanstracker[dot]com site appears to be down. Regardless, I uninstalled the extension and left annoyed noises on the extension in the Chrome store, because don't do that.
xtina: (Default)
Two tech tips today (ta-dah!).

1) In Google Drive, you can show files sorted by file size across all folders by opening the quota page. To get there, either click on that link, or:

* Hover over the sidebar item showing how much space you've used.
* In the bubble pop-up, you'll see a little teeny tiny "i" next to the Drive line. Click that.

2) The text to search for to block that "Read More" horseshit is "javascript add link to copied text". The first thing to do for this is entirely block Tynt, either through your hosts file or through your ad-blocking plugin. Doing that covers it so well that I often forget that I even have that set.
xtina: (Default)
For my reference later.

* Start Automator.
* Choose "Application".
* For the action, use Run Shell Script.
* Enter the command as you would run it in Terminal.
* Save as [Whatever].app, usually in the Applications folder.

Note: Apps that are run like this don't pick up changes in your .bash_profile. What I did for my Java program was copy out the export line from my .bash_profile and paste it as the first line in the Automator thing.
xtina: (Default)
I have an ongoing list of things I like to clean up, computer-wise, about once a week. I don't by any means go through all of the list; I pick whatever's interesting for me that week. But I do have a calendared reminder each week to clean my shit up.

List. )

Living doc for yours truly.
xtina: (Default)
A thing I found:

To print PDFs from the command line, when you have Foxit Reader installed:

"Foxit Reader.exe" /p PdfFile.pdf

Originally posted on Dreamwidth.  Number of comments so far: comment count unavailable
xtina: (Default)
A thing I found:

To print PDFs from the command line, when you have Foxit Reader installed:

"Foxit Reader.exe" /p PdfFile.pdf
xtina: (Default)
If you frequently reset IE7 or IE8, for whatever godawful reason, you may be interested in how to disable the Getting Started crap.

Originally posted on Dreamwidth.  Number of comments so far: comment count unavailable
xtina: (Default)
If you frequently reset IE7 or IE8, for whatever godawful reason, you may be interested in how to disable the Getting Started crap.
xtina: (Default)
To return the last item in an Excel column:

=INDEX(G:G, COUNTA(G:G) + 3)

INDEX(Array, Row Number)

COUNTA(Value(s))

CountA gets the number of non-blank cells in a range.

Index: the array is all values in column G, and the row number is the count of items in column G.

The +3 is there because cells G1-G3 are empty, in my worksheet.

Source.

* This also works in Google Spreadsheets.
* This mostly works in Zoho Sheet.  First, semicolons, not commas.  Second, it doesn't seem to support G:G; you need to specify G1:G40 (or whatever).
xtina: (Default)
To return the last item in an Excel column:

=INDEX(G:G, COUNTA(G:G) + 3)

INDEX(Array, Row Number)

COUNTA(Value(s))

CountA gets the number of non-blank cells in a range.

Index: the array is all values in column G, and the row number is the count of items in column G.

The +3 is there because cells G1-G3 are empty, in my worksheet.

Source.

* This also works in Google Spreadsheets.
* This mostly works in Zoho Sheet.  First, semicolons, not commas.  Second, it doesn't seem to support G:G; you need to specify G1:G40 (or whatever).
xtina: (Default)
To do basic calculations on the command line in *nix/*nux:

echo 2+2 | bc

Or just type bc, and go from there.

http://linux.die.net/man/1/bc
xtina: (Default)
To do basic calculations on the command line in *nix/*nux:

echo 2+2 | bc

Or just type bc, and go from there.

http://linux.die.net/man/1/bc
xtina: (Default)
The formula to return the text day of the week for a given date in Excel:

=CHOOSE(WEEKDAY(A1, 1), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")

(Also totally works in Google Spreadsheets.)

The WEEKDAY(date, type) function takes a date and returns the number of the day of the week.  So WEEKDAY("2009-06-10", 1) would return 4 - Wednesday is the fourth day of the week.

type in that formula:

* 1 or no value == 1 (Sunday) through 7 (Saturday)
* 2 == 1 (Monday) through 7 (Sunday)
* 3 == 0 (Monday) through 6 (Sunday)

(So US-centric.)

CHOOSE(index#, [item1, item2, ...]) takes two things - an index number, and a set of values to choose from.  (No brackets, though - that's just for ease of descriptifying.)

*makes "and so therefore" gesture*
xtina: (Default)
The formula to return the text day of the week for a given date in Excel:

=CHOOSE(WEEKDAY(A1, 1), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")

(Also totally works in Google Spreadsheets.)

The WEEKDAY(date, type) function takes a date and returns the number of the day of the week.  So WEEKDAY("2009-06-10", 1) would return 4 - Wednesday is the fourth day of the week.

type in that formula:

* 1 or no value == 1 (Sunday) through 7 (Saturday)
* 2 == 1 (Monday) through 7 (Sunday)
* 3 == 0 (Monday) through 6 (Sunday)

(So US-centric.)

CHOOSE(index#, [item1, item2, ...]) takes two things - an index number, and a set of values to choose from.  (No brackets, though - that's just for ease of descriptifying.)

*makes "and so therefore" gesture*
xtina: (Default)
If you use Windows, so.  You know how you can drag a file to another folder?  Apparently you can alt-tab between windows while dragging a file.  I never knew!
xtina: (Default)
If you use Windows, so.  You know how you can drag a file to another folder?  Apparently you can alt-tab between windows while dragging a file.  I never knew!
xtina: (Default)
Windows tip for today:

Say you're copying a bunch of documents from folder1 to folder2, and there are some same-name-plicates.  "This folder already contains a file named 'Your mother.doc'."  There's Yes, Yes To All, No, and Cancel.

To get No To All (so that the same-named files are ignored), hold down the Shift key and click No.
xtina: (Default)
If your Windows computer does those system beeps and you hate it:

* Right-click My Computer and select Manage.
* Expand System Tools and select Device Manager.
* From the View menu, select Show hidden devices.
* Expand Non-Plug and Play Drivers.
* Right-click Beep, and select Disable.
* Reboot.

(Source.)

September 2017

S M T W T F S
     12
3456789
10111213141516
17181920212223
24252627282930

Most Popular Tags

Style Credit

Page generated 2017-09-19 11:49
Powered by Dreamwidth Studios