Thanks to antville.org
Thursday, 28. October 2004
Google Syntax

I knew that to search only one website
admission site:www.stanford.edu

But I did not know this:
To search within a range of numbers:
DVD player $100...150
(Search for DVD players between $100 and $150)

Other Operator examples
I knew define: syntax that works something like this...
define:computer
definitions of the word computer from around the Web.

But I did now know this:
red * blue
the words red and blue separated by exactly one word.

~auto loan
loan info for both the word auto and its synonyms: truck, car, etc.

Google calculator has a unique % of feature.
45% of 39
Will give you the exact result.

... Link (0 comments) ... Comment


Friday, 22. October 2004
Count Characters in a Excel Cell

To count the total characters (including spaces) in cell A1:
=len(A1)
To count the total characters (not including spaces) in cell A1:
=LEN(SUBSTITUTE(A1," ",""))
To count the total specific characters in Cell A1, for instance the number of times the letter "d" appears in cell A1:
=LEN(A1)-LEN(SUBSTITUTE(A1,"d",""))

... Link (0 comments) ... Comment


Selfish :)

The Web is the most selfish medium ever invented -- people want what they want, where they want it, when they want it.
-- Dan Rosensweig

... Link (0 comments) ... Comment


Desktop + Deskbar

Google Provides Hack For Google Desktop In Google Deskbar.
Google designed the Deskbar with Google Desktop and similar products in mind, because it provided an easy hack to work the Deskbar with Desktop. It's rare Google actually gives this sort of advice themselves, but good for them. Simply:

  1. Go to Google and click on the Desktop tab.
  2. Copy your URL, which should look like this: http://012.3.4.5:4664/&s=6789012345&q=.
  3. Go to the Deskbar and click Options.
  4. Go to Customized Searches, click Add, paste your URL in the URL box, but add {1}
    (it'll look like:http://012.3.4.5:4664/&s=6789012345&q={1}) and name it Google Desktop Search.
  5. That's it, unless you want to fiddle with the options more.

... Link (0 comments) ... Comment


Wednesday, 20. October 2004
Line Breaks in Formulas

If you want to put an address in cell on multiple lines, you can use CHAR(10) (10 being the ASCII code for a line feed).
=c3 & CHAR(10) & C4 & CHAR(10) &C5
If you get a bunch of squares and your text is all on one line, go to Format > Cells > Alignment and check the Wrap Text box.
To create a line feed while typing (i.e., not in a formula), Alt+Enter does the same thing.

... Link (0 comments) ... Comment


Monday, 18. October 2004
Gmail atom feed

You can subscribe to gmail atom feed even if your account doesn't show the Atom logo. You can successfully subscribed to it as a live bookmark in Firefox.
https://gmail.google.com/gmail/feed/atom

... Link (0 comments) ... Comment


Saturday, 16. October 2004
Open Source

....That's not a problem at all. That would be one of the reasons I'm personally a fan of open source: that if *I* want a feature, then I can add it myself, even if I'm the only person in the world who wants it.

... Link (0 comments) ... Comment


Thursday, 7. October 2004
create an email icon

Make an icon for your e-mail address in Gmail, Hotmail, or Yahoo Mail. Niftee....
http://www.nhacks.com/email/index.php

... Link (0 comments) ... Comment


Wednesday, 6. October 2004
Text To Date Conversion

This is a procedure that I often use to convert dates originating from mainframe downloads into an Excel readable format. The dates come across in the following eight character format -> “20040101” - (Jan. 1, 2004).

Sub StringToDate()
Dim d As Range
Dim r As Range
On Error Resume Next
For Each d In Range("A1:A10")
d.Value = Format(DateSerial(Mid(d, 1, 4), Mid(d, 5, 2), Mid(d, 7, 2)), "yyyy/mm/dd")
Next
End Sub

The macro would need to be modified using the Mid worksheet function to allow for differing string lengths.

... Link (0 comments) ... Comment


Tuesday, 5. October 2004
Tips for web developers:

1) Default setting is important: Most of the people leave the default unchanged.
2) Sales people should not dictate the site design.
3) Usability: Programmers should be asked to help 100 new users to register.

... Link (0 comments) ... Comment


Online for 8130 days
Last modified: 10/13/24, 10:18 AM
Status
Youre not logged in ... Login
Menu
... Home
... Tags

Search
Calendar
November 2024
SunMonTueWedThuFriSat
12
3456789
10111213141516
17181920212223
24252627282930
October
Recent updates
Extract words Extract all incorrect
words in first.txt file and all correct ones in second.txt...
by shantanuo (10/13/24, 10:18 AM)
Remove hyperlink in LO writer
1) Select "Internet Link" from Character styles. 2) Right click...
by shantanuo (10/9/24, 8:09 AM)
Templates in LO writer 1)
File > Templates > Save as Template 2) Give it...
by shantanuo (10/9/24, 8:07 AM)
discretize continuous features You can
"discretize" or "bin" continuous features into categorical features. from sklearn.preprocessing...
by shantanuo (4/24/24, 9:33 AM)
User Defined Property You
can create User Defined Property in libreoffice writer. File – Properties...
by shantanuo (1/9/23, 8:52 AM)
Arranging Chapters in the Navigator
To use a custom paragraph style for a heading, choose...
by shantanuo (1/4/23, 8:26 AM)
Use focus mode using Android
phones Settings > Digital Wellbeing and parental controls. Tap your...
by shantanuo (1/1/23, 3:59 AM)
Embed Fonts in document If
you use a font that the recipient is unlike to...
by shantanuo (12/18/22, 10:07 AM)
Using Navigator in Writer To
open the Navigator, select View > Navigator, or press the...
by shantanuo (12/18/22, 10:06 AM)
More about hyphenation The settings
for Tools > Options > Language Settings > Writing Aids...
by shantanuo (12/18/22, 10:04 AM)
link or unlink template If
you are using Libre office then template changer extension is...
by shantanuo (12/16/22, 5:27 AM)
Finding Styles you can select
Edit > Find and Replace > Other Options > Paragraph...
by shantanuo (12/14/22, 7:17 AM)
regex in clac In LibreOffice
Calc, you can use function REGEX for e.g. Begins with...
by shantanuo (12/14/22, 4:40 AM)
Libre Calc tips Turn Off
Grid Lines If you want to turn off grid lines...
by shantanuo (12/13/22, 8:14 AM)
More about Styles You can
goto View - Styles and change "All Styles" to "Applied...
by shantanuo (12/13/22, 7:49 AM)
Page Break Before Every Chapter
If your chapter titles are using the "Heading 2" Style:...
by shantanuo (12/13/22, 6:36 AM)
View and print in different
color Displaying Color in LO but Printing as White Page...
by shantanuo (12/13/22, 6:26 AM)
Change Normal Template in Libreoffice
Writer 1) Open a new file and set your font;...
by shantanuo (12/12/22, 8:45 AM)
Short english words in Devanagari
The list of short english words written in Devanagari. #...
by shantanuo (10/5/22, 9:05 AM)
Card issuing banks CITI
Standard Chartered HSBC American Express HDFC ICICI AXIS INDUS IND Kotak...
by shantanuo (7/16/22, 4:46 AM)
Activate IAM Access To activate
the Activate IAM Access setting, you must log in to...
by shantanuo (7/12/22, 5:52 AM)
use cheat instead of man
wget https://github.com/cheat/cheat/releases/download/4.2.3/cheat-linux-arm64.gz gunzip cheat-linux-arm64.gz chmod 770 cheat-linux-arm64 ./cheat-linux-arm64 mv cheat-linux-arm64...
by shantanuo (7/4/22, 8:53 AM)
python module itertools list of
useful methods of itertools module. permutations combinations combinations_with_replacement zip_longest count...
by shantanuo (9/8/21, 7:50 AM)
wikipedia tools 1) Collection of
useful utilities https://wikipediatools.appspot.com/ 2) all history of a user https://xtools.wmflabs.org/ec/mr.wikisource.org/Shantanuo...
by shantanuo (8/20/21, 6:36 AM)
Duration/Term of Copyright In the
case of original literary, dramatic, musical and artistic works, the...
by shantanuo (8/20/21, 6:26 AM)

RSS feed

Made with Antville
Helma Object Publisher