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.
xtina: (Default)
If you have a sleep button on your keyboard and you hate it, go to Start > Control Panel > Power Options.  If you're in XP, go to Advanced in the Properties window; if you're in Vista, select "Choose what the power buttons do".  Then change it to fuck off and die do nothing, for Sleep.

May 2017

S M T W T F S
 12 3456
78910111213
14151617181920
21222324252627
28293031   

Most Popular Tags

Style Credit

Page generated 2017-05-25 05:04
Powered by Dreamwidth Studios