Advance I.T Education

Graph In Mircro Soft Excel 2007

2010-11-23T19:15:00.010+05:00

How do I create a chart in Excel that has two Y-axes and one shared X-axis in Excel 2007

First, select the Insert tab from the toolbar at the top of the screen. In the Charts group, click on the Column button and select the first chart (Clustered Column) under 2-D Column.

A blank chart object should appear in your spreadsheet. Right-click on this chart object and choose "Select Data..." from the popup menu.

When the Select Data Source window appears, we need to enter the data that we want to graph. In this example, we want column A to represent our X-axis and column C to represent our primary Y-axis (left side) and column E to represent our secondary Y-axis (right side). One more complication to this example is that our data is not all in adjacent cells, so we need to select columns A, C, and E separated by commas.
To do this, highlight cells A2 to A7 then type a comma, then highlight cells C2 to C7, then type another comma, and the highlight cells E2 to E7. You should see the following in your Chart data range box:
=Sheet1!$A$2:$A$7,Sheet1!$C$2:$C$7,Sheet1!$E$2:$E$7
Click on the OK button.

Now, right-click on one of the data points for Series2 and select "Change Series Chart Type" from the popup menu.

When the Change Chart Type window appears, select the 4th chart under the Line Chart section. Click on the OK button.

Now when you view the chart, you should see that Series 2 has changed to a line graph. However, we still need to set up a secondary Y-axis as Series 2 is currently using the primary Y-axis to display its data.
To do this, right-click on one of the data points for Series 2 and select "Format Data Series" from the popup menu.

When the Format Data Series window appears, select the "Secondary Axis" radio button. Click on the Close button.

Now, if you want to add axis titles, select the chart and a Layout tab should appear in the toolbar at the top of the screen.
Click on the Layout tab. Then select Axis Titles > Primary Horizontal Axis Title > Title Below Axis.

An Axis Title at the bottom of the graph should appear, just overwrite "Axis Title" with the text that you'd like to see.
Next, under the Layout tab in the toolbar, select Axis Titles > Primary Vertical Axis Title > Horizontal Title.

An Axis Title to the left of the graph should appear, just overwrite "Axis Title" with the text that you'd like to see.
Next, under the Layout tab in the toolbar, select Axis Titles > Secondary Vertical Axis Title > Horizontal Title.

Now, you should see that your chart is designed with a common X-axis and 2 different Y-axes.

Tracking Your Website's Visitors

2010-11-16T10:57:00.000+05:00

Tracking Your Website's Visitors and Statistic in ASP.NET

About this Tutorial

This tutorial lays down the basic architecture of a tracking website and highlights the technical aspects while implementing it using ASP.NET with C#. Tracking websites can record the visitor activity on any site (by pasting their tracking snippet).

The recorded data can be used to generate various useful reports. Screenshots and code snippets are shown where-ever necessary. And, you can also download the Tracking & Statistic - Visual Studio 2005 Project. This tutorial is meant for beginner-level developers and can also be used for learning various aspects of ASP.NET and C#. The todo list in the end can further develop your interest in extending this tutorial and learning more.

Let's start.

How tracking works? And how to implement it in ASP.NET

Tracking of a page can be enabled by pasting a simple html code into that page (normally inserting it before <body>). This simple html code calls the tracker, sends visitor and page's information to the tracker. What is this tracking code actually?

Normally, its a 1x1 pixel invisible image called by the html. That image resides on the tracker. Here is an example that how a tracking script is called.

Here is an example of ASP.NET using C# that how tracker handles the tracking script

Response.Clear();

//Code to record visitor information (elaborated in the next point)

Response.ContentType = "image/jpeg";
Bitmap bmp = new Bitmap(@"c:\spacer.gif");
bmp.Save(this.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);

The code above converts the response type to an image and outputs an invisible image (present as spacer.gif in c:\)
Meanwhile, the script gets hold of the visitor and calling page and records that information.

How to access detailed information of a visitor

In ASP.NET, the Request.ServerVariables collection holds a lot of useful information about the visitor. More about it read in Visitor Informations From Request.ServerVariables Collection tutorial.

For example:

// Getting ip of visitor
string ip = Request.ServerVariables["REMOTE_ADDR"];
// Getting the page which called the script
string page = Request.ServerVariables["HTTP_REFERER"];
// Getting Browser Name of Visitor
if (Request.ServerVariables["HTTP_USER_AGENT"].Contains("MSIE"))
browser = "Internet Explorer";
if (Request.ServerVariables["HTTP_USER_AGENT"].Contains("FireFox"))
browser = "Fire Fox";
if (Request.ServerVariables["HTTP_USER_AGENT"].Contains("Opera"))
browser = "Opera";

Some hands on SQL-Express in Visual Studio 2005

SQL Server Express Edition installs automatically while installing Visual Studio 2005. We can create database tables while working in the same IDE of the visual studio.

In the solution explorer, you can see App_Data item in the menu tree. There we can create new tables, define our constraints, run SQL queries and view database tables.

Figure 1: Portion of the IDE related with SQL Server Express.

How to use the ip2country database and to get visitor's country from his ip in ASP.NET

Knowing the country from which your website visitor belongs is an excellent idea. Unfortunately, this information is not present in any of the cookies or server variables.

However, there are free databases available over internet that can provide a mapping of an ip adress to a country. And they are proved to be 99% correct.

There are various ip-country databases available and all of them are in a standard CSV file format. One of them is available at software77. These data are changed from time to time, so you need to update database regularly, one time per month.

Here is what we will do:

Create a database to hold ip-country database.
Load the CSV file into a database table. And allow our user to update the ip-country db anytime by providing an updated CSV file.

The following screenshot shows creating a database table to store ip-country database.

Figure 2: Adding a New Table in the database to store ip-country data

Figure 3: Asking the user to provide updated ip-country CSV File

The following code snippet shows how to read a file uploaded by FileBrowser control and how to load its content into the db.

// Creating connection with SQL Client

//The connection string can be created with a GUI and can be saved in web.config's AppSettings.
//Here is how to read data from web.config

SqlConnection connection = newSqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
connection.Open();
SqlCommand command = new SqlCommand();
command.Connection = connection;

// Reading uploaded file data line by line and inserting it into the db

StreamReader sr = new StreamReader(FileUpload1.FileContent);
string line;

while ((line = sr.ReadLine())!=null)
{
command.CommandText = @"insert into [ip-country](starting, ending, shortcode, mediumcode, fullname) values("+line+")";
command.ExecuteNonQuery();
}

Dont forget to include System.Data.SqlClient.

With the above code snippet, ip-country database can be updated anytime in the table.

To use the ip-country database, the input ip should be in a long-ip format. The attached project contains that function to convert an ip in dotted format into a long-ip format. The prototype of that function is:

public double Dot2LongIP(string DottedIP)

Here is how we can get visitor's location through his ip using the ip-country db.

command.CommandText = "select fullname from [ip-country] where starting<" + longip + " and ending>"+ longip;
location = ((string)command.ExecuteScalar());

In the above snippet, location is a string and command is and object of SqlCommand. Note that ExecuteScalar is useful when we are interested in getting only a single numeric information from the query. ExecuteReader actually returns first column of the first row of the results.

Figure 4: Here is the look of the database that records tracking information

Using calendar control to select dates, building a query

A calendar control can be used to select dates while running a report. Simply drag and drop the calendar control from the toolbox. Use the SelectionChanged event handler to update the reports. Use Calendar's SelectedDate member to get the date selected.

Figure 5: This is the display of a calendar control (asking user to select date)

To Do List

As previously mentioned, this article builds an architecture for a tracking website. Tracking script works successfully and records visitor's information into the db. Now, its upto you to generate customized reprots from recorded data. Following can be done as a practice:

Tabular reports can be generated by asking user to input starting and ending dates. Reports that may contain total hits, visits (same session), unique visitors (by IP address), top pages etc.
Graphical reports can be generated using the bitmap object and drawing graphs (circles, rectanges, lines) into it. The bitmap object then can be shown to the user on his browser. You can use some third party control or build your own graph (more about this you can find in Make Charts in ASP.NET 2.0 tutorial.
You can group reports to show data per day, per month, per year etc.
.NET's built-in login control can be used to guard this application behind some login.

Earn google Adsense Money

2010-11-16T10:42:00.000+05:00

Earn google Adsense Money - Tutorial

Reactions:

Website Creation Tutorial for Beginners
Many people now a days want to Earn money online from Google. There are many ways and programs that may help you to earn money like PTC Programs, PTR Programs, PTS Programs, Programming Jobs, Stock Exchange and Data Entry Jobs. The problem with these online earning programs like paid to click, paid to read and paid to survey is that many of these programs are scam and you don't know which are the real programs that really pays and if you find some thing really working it may not work in third world countries like us.

So the remaining options are earn through programming, stock exchange and Data Entry jobs. If you are a Programmer then its not that hard for you to earn money on internet but if you are not a Programmer or don't have time to learn then the remaining options are not FREE. You have to pay initial amount to start work in stock exchange and Data Entry jobs. If you have a heavy investment then it may suits you but if you are searching a method which costs less or no money then you come to the right place. The only method left through which you can earn money 100% Guaranteed any where in the world is through Google Adsense.

what is Google Adsense?
So what is Google Adsense programs?. Google Adsense is one of the best methods to earning online . If you are using internet from some time you may already use Google for search purposes or Google services like Gmail, Blogger, youtube etc and surprisingly these services are free of cost.
Are Google mad.. No they offer these services free of cost because they generate money from advertisement. Companies gave them money to advertise there products on Google’s site. Google kept 30% of the revenue and spent 70% revenue for webmasters.

If you have use internet and search websites you have noticed that most of the websites use some kind of advertisement to generate money. This is where Google adsense comes. Google Adsense is a way to generate money on internet for webmasters who own there own website, but not every one on this planet is a programmer or webmaster then what can you do if you are not one of these.

There are many companies and webmasters who can work for. You have to pay one time fee for this once your website is up you can generate money. Only you have to do is to promote your website for traffic. The way you earn money is the amount of clicks on your Google ads.

We are here to help you.
we are here to provide you all the information, guide and Free resources you need to build a blog or website. After reading my entire blog (English) you will be able to plan, create and promote your website or blog. No need to pay someone to teach you the process of creating a website for google adsense program. So what are the things you need to earn money from Google Adsense program.

1. G-Mail Account.
2. Google Adsense Account.
3. Website or Blog (with good rich & unique content).

The amount of money generated is depends upon traffic and quality website material and this is done through SEO(Search Engine Optimization). I will also teach you the process of how to increase your google adsense income. The more clicks on your ads the more money you earn. When your balance reaches 100$ magical figure Google will send you a cheque or you can order your money through western union money transfer with in one day.

VLOOKUP function in Excel 2007

2010-11-08T12:53:00.000+05:00

http://freei11.blogspot.com

VLOOKUP function in Excel 2007

What Does It Do ? This function scans down the row headings at the side of a table to find a specified item. When the item is found, it then scans across to pick a cell entry.

Syntax =VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom,SortedOrUnsorted) The ItemToFind is a single item specified by the user. The RangeToLookIn is the range of data with the row headings at the left hand side. The ColumnToPickFrom is how far across the table the function should look to pick from. The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes, FALSE for no.

Formatting No special formatting is needed.

Example 1 This table is used to find a value based on a specified name and month. The =VLOOKUP() is used to scan down to find the name. The problem arises when we need to scan across to find the month column. To solve the problem the =MATCH() function is used. The =MATCH() looks through the list of names to find the month we require. It then calculates the position of the month in the list. Unfortunately, because the list of months is not as wide as the lookup range, the =MATCH() number is 1 less than we require, so and extra 1 is added to compensate. The =VLOOKUP() now uses this =MATCH() number to look across the columns and picks out the correct cell entry. The =VLOOKUP() uses FALSE at the end of the function to indicate to Excel that the row headings are not sorted.

Example 2 This example shows how the =VLOOKUP() is used to pick the cost of a spare part for different makes of cars. The =VLOOKUP() scans down row headings in column F for the spare part entered in column C. When the make is found, the =VLOOKUP() then scans across to find the price, using the result of the =MATCH() function to find the position of the make of car. The functions use the absolute ranges indicated by the dollar symbol . This ensures that when the formula is copied to more cells, the ranges for =VLOOKUP() and =MATCH() do not change.

Example 3 :In the following example a builders merchant is offering discount on large orders. The Unit Cost Table holds the cost of 1 unit of Brick, Wood and Glass. The Discount Table holds the various discounts for different quantities of each product. The Orders Table is used to enter the orders and calculate the Total. All the calculations take place in the Orders Table. The name of the Item is typed in column C of the Orders Table. The Unit Cost of the item is then looked up in the Unit Cost Table. The FALSE option has been used at the end of the function to indicate that the product names down the side of the Unit Cost Table are not sorted. Using the FALSE option forces the function to search for an exact match. If a match is not found, the function will produce an error. =VLOOKUP(C126,C114:D116,2,FALSE) The discount is then looked up in the Discount Table If the Quantity Ordered matches a value at the side of the Discount Table the =VLOOKUP will look across to find the correct discount. The TRUE option has been used at the end of the function to indicate that the values down the side of the Discount Table are sorted. Using TRUE will allow the function to make an approximate match. If the Quantity Ordered does not match a value at the side of the Discount Table, the next lowest value is used. Trying to match an order of 125 will drop down to 100, and the discount from the 100 row is used. =VLOOKUP(D126,F114:I116,MATCH(C126,G113:I113,0)+1,TRUE)

How to find out Formula in Excel

2010-11-04T10:09:00.001+05:00

You can view all the formula on the worksheet by pressing Ctrl and `.

The ' is the left single quote usually found on the key to left of number 1.

Split Forename and Surname

The following formula are useful when you have one cell containing text which needs

to be split up.

One of the most common examples of this is when a persons Forename and Surname

are entered in full into a cell.

The formula use various text functions to accomplish the task.

Each of the techniques uses the space between the names to identify where to split.

Finding the First Name

Full Name

First Name

Alan Jones

Alan

=LEFT(C14,FIND(" ",C14,1))

Bob Smith

Bob

=LEFT(C15,FIND(" ",C15,1))

Carol Williams

Carol

=LEFT(C16,FIND(" ",C16,1))

Finding the Last Name

Full Name

Last Name

Alan Jones

Jones

=RIGHT(C22,LEN(C22)-FIND(" ",C22))

Bob Smith

Smith

=RIGHT(C23,LEN(C23)-FIND(" ",C23))

Carol Williams

Williams

=RIGHT(C24,LEN(C24)-FIND(" ",C24))

Finding the Last name when a Middle name is present

The formula above cannot handle any more than two names.

If there is also a middle name, the last name formula will be incorrect.

To solve the problem you have to use a much longer calculation.

Full Name

Last Name

Alan David Jones

Jones

Bob John Smith

Smith

Carol Susan Williams

Williams

=RIGHT(C37,LEN(C37)-FIND("#",SUBSTITUTE(C37," ","#",LEN(C37)-LEN(SUBSTITUTE(C37," ","")))))

Finding the Middle name

Full Name

Middle Name

Alan David Jones

David

Bob John Smith

John

Carol Susan Williams

Susan

=LEFT(RIGHT(C45,LEN(C45)-FIND(" ",C45,1)),FIND(" ",RIGHT(C45,LEN(C45)-FIND(" ",C45,1)),1))

Advance Excel 2007

2010-11-01T10:51:00.000+05:00

Microsoft Excel

As you know there are lot of erp software in market erp like Peachtree ,tally software ,account software ,medi cal billing ,tax software, financial soft wares or Software for Finance But We bring you a web site which teach you or guide you to developed a good account, of medi cal billing or Tax Software etc, at you own.

We all know that microsoft excel give a unique platform in excel 2003 and excel 2007 as spreadsheet on excel which give excellent opportunity to build our own software.

In this web site we cover the following topics

how to use excel , spreadsheet on excel ,excel windows xp , macro with excel ,advanced excel ,excel vba macros etc.

2010-11-01T10:35:00.001+05:00