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.)
xtina: (geeky girl)
Today's thing about Excel that all this time using it, I didn't know:

Say you have a column of names:

Smith, Bob
Jones, Tim

You want to split those out to two columns.  Simple-peasy.  Go to Data > Text To Columns (this is the same in 2007 - it's found in the Data Tools chunk).  That takes you through a wizard that allows you to split the data based on criteria (delimited or fixed width, commas or semicolons, &c).  If you've ever imported a .csv into Excel, it's the same wizard.

ALL THIS TIME.  And I never knew until YESTERDAY.

June 2017

S M T W T F S
    123
45678 910
11121314151617
18192021222324
252627282930 

Most Popular Tags

Style Credit

Page generated 2017-07-28 14:58
Powered by Dreamwidth Studios