Wednesday, September 23, 2015

EXCEL Advance Match Function

To check value is avalable
=MATCH(A3,A57:A592,0)

To Get row number of matching value
=MATCH(A3,A57:A592,0)+ROW(A57:A592)-1


Get value of the Cell
=INDIRECT("B"&G5) // B is column and G5 contains row index

Thursday, June 18, 2015

Google Sites

1. Contact Form

Can use JotForm for contact form that send you email from your web site
Ex: OEM contact page http://www.jotform.com/?formID=51298047806461

2. SEO - Search Engine Operator

You can use https://www.xml-sitemaps.com/ to build  site-map for you Google site. Once you build the site map, upload it to your web site using  "Attachment " under "Mange Your Site"

3. Google Web Master

  • Go to "Crawl" -> "SiteMaps" to ubmit the site-map you uploaded.
  • Then "Fetch as Google" and Submit.
4. Adding Sub Menu Tabs/Links

Go to "Edit Site Layout" -> "Edit Horizontal Navigation", And use Arrows to make sub menu/tabs


Saturday, May 2, 2015

MRTG Network Monitor

What it does

You have a router, you want to know what it does all day long? Then MRTG is for you. It will monitor SNMP network devices and draw pretty pictures showing how much traffic has passed through each interface.
Routers are only the beginning. MRTG is being used to graph all sorts of network devices as well as everything else from weather data to vending machines.
MRTG is written in perl and works on Unix/Linux as well as Windows and even Netware systems. MRTG is free software licensed under the Gnu GPL.
Sample Graph