nonethefewer: A heart made out of a motherboard. (geek heart)
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.)
nonethefewer: (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.

Tech tips

May. 27th, 2017 01:47 pm
nonethefewer: (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.
nonethefewer: (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.
nonethefewer: (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.
nonethefewer: (Default)
A thing I found:

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

"Foxit Reader.exe" /p PdfFile.pdf
nonethefewer: (Default)
If you frequently reset IE7 or IE8, for whatever godawful reason, you may be interested in how to disable the Getting Started crap.
nonethefewer: (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).
nonethefewer: (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
nonethefewer: (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*

Holy crap!

May. 30th, 2009 08:05 pm
nonethefewer: (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!
nonethefewer: (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.
nonethefewer: (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.)
nonethefewer: (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.
nonethefewer: (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.
nonethefewer: (Default)
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.
nonethefewer: (Default)
- To disable UAC, go to Start > Control Panel > Security > Security Center, click on "Other security settings", and turn it off there.

- While there, to get rid of the red-X shield and stupid startup notification, click on "Change the way Security Center alerts me" on the left there and choose the right option.
nonethefewer: (Default)
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].
nonethefewer: (Default)
Linkage.

- Copy text from a message box in Windows.  I tested this briefly, and it appears to only work with error messages, which is vastly annoying.  Try instead this freeware.

- How to ask questions the smart way - a guide to asking for technical help.  There are a million best parts, but the one that I want to staple to my users' heads is:

What we are, unapologetically, is hostile to people who seem to be unwilling to think or to do their own homework before asking questions. People like that are time sinks — they take without giving back, and they waste time we could have spent on another question more interesting and another person more worthy of an answer.

- Relatedly, and useful to me: How to Report Bugs Effectively

- Via [livejournal.com profile] hitchhiker: Easily solve “spot the difference” pictures within seconds.
Page generated Jun. 16th, 2025 09:06 pm
Powered by Dreamwidth Studios