Chris

nano doesn't come with highlighting on macOS, unless I'm dramatically missing something. So, notes for myself for later:

Source links:

* https://stackoverflow.com/questions/9642617/nano-syntax-highlighting-in-mac-os-x-10-7-lion
* https://github.com/scopatz/nanorc

Steps:

1. Download a .zip file of the repo here.


2. Extract all files from the .zip file.


3. In Terminal, run: mkdir /usr/local/share/nano


4. In Terminal, run: mv ~/Downloads/nanorc-master/*.nanorc /usr/local/share/nano/


5. In Terminal, run: nano ~/.nanorc


6. Add a line like this, for whichever language you want:
   include "/usr/local/share/nano/python.nanorc"


7. Save your file.


8. Quit out of Terminal and reopen to use the shininess.

Note: Apparently nano for the Mac doesn't recognize the header keyword on line 4 of the .nanorc files. You'll have to comment that out with a #. (For more nerdy shit on that, go here.)

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.

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.

If you frequently reset IE7 or IE8, for whatever godawful reason, you may be interested in how to disable the Getting Started crap.

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).

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*

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.

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.

For both non-geeks and forgetful folk: Computer Hope

"The location for free online computer support and computer related information. Computer Hope has been designed to assist all types of computer users with any of their computer related questions as well as a great location to learn more about your computer and its hardware and software."

I tend to use it to see all the switches for various commands, since I forget what they are a lot.  It's especially nice that it holds commands for a bunch of OSes and such - Linux/Unix, Apple, Windows, and MS-DOS, so far as I can tell.  And I don't have to remember the help command for each OS.  (I will admit that while man pages are sometimes useful, often they're cluttered to me.)

Plus the interface is pretty.

For yall afflicted with Excel 2007:

1) You can minimise the Ribbon - right-click, minimise.

2) To manage a named range, hit [Alt][I][D].