Notes

1. Type about:config<ENTER> in firefox address bar
2. *Optional* Type: mousewheel.withnokey<ENTER> in the filter box
3. Set mousewheel.withnokey.sysnumlines to false

   This makes Firefox use its own setting instead of the system-wide setting.

4. Change mousewheel.withnokey.numlines to how many lines you want to scroll at a time.

I use 8

Source: http://episteme.arstechnica.com/groupee/forums/a/tpc/f/99609816/m/480004345731

The following resources allow you to edit any web page and print only what you need to save paper and/or ink.

• Bookmarklets

  To use a bookmarklet, you need to bookmark it; either drag it to your bookmark toolbar or right click the link and choose bookmark this. Next, when you visit a web page you would like to edit, click on that new bookmark. My favorite one is PrintWhatYouLike, there is no extension to install and it is a very easy and efficient.

  1. PrintWhatYouLike Bookmarklet
  2. EditThis Bookmarklet (Demo)
  3. List of bookmarklets to remove (zap) annoyances from web pages
• Firefox Extension
  1. Aardvark

This example Bash script replaces “.JPG” with “.jpg” recursively in the current directory (It can handle filenames with spaces):


#!/bin/bash

find ./ -type f -name "*.JPG" | while read FILE
do
newname=`echo $FILE | sed s/.JPG/.jpg/`
echo $newname
mv "$FILE" "$newname"
done


Convert all characters to lowercase:


#!/bin/bash

find ./ -type f -name "*" | while read FILE
do
newname=`echo $FILE | tr 'a-z' 'A-Z'`
echo $newname
mv "$FILE" "$newname"
done


For example, you have 2 sheets, Sheet1 and Sheet2: they both have a list of part numbers in column A and a list of prices in column B. You want to compare the prices for the same part numbers in each sheets. One way to do this is to copy the prices from Sheet1 to Sheet2 in a third column and then use conditional formatting to highlight the different prices:

Copy this formula in cell C2 of Sheet2 (and then drag it down to the cells below):
=INDEX($Sheet1.A$2:B$3001;MATCH(A2;$Sheet1.A$2:A$3001;0);2)

This formula assumes that there is a maximum of 3000 different products in Sheet1 (starting at cell A2).

Sample file:compare_four_columns.ods

Batch renaming made easy with Renamer

“ReNamer is a very powerful and flexible file renaming tool, which offers all the standard renaming procedures, including prefixes, suffixes, replacements, case changes, as well as removing contents of brackets, adding number sequences, changing file extensions, etc. For advanced users, there is a PascalScript rule, which let users program their very own renaming rule. Program allows you to combine multiple renaming actions as a rule set, applying each action in a logical sequence, which can be saved, loaded, and managed within the program. In addition, it has an ability to rename folders, process regular expressions, Unicode capable, and supports variety of meta tags, such as: ID3v1, ID3v2, EXIF, OLE, AVI, MD5, CRC32, and SHA1.”

Download.