Excel DashBoard-2

Excel Dashboard:

I have done a Excel project Topic Name: Analysis of various Indicators of Various countries as i told to you in previous post and i have told to you how to make the dashboards in excel Its so easy!!!!

So let's get started!! I had allocated a project "Analysis of various Indicators of Various countries" .
In the raw of my project contains country name ,Indicators names such as: Population ,Population growth(%),GDP(Gross Domestic Product) and the sub-Indicators which reflect the GDP of country Such as Agriculture,Services,Industry,Import and Export of goods and lot more...and their values with respective to the years for each country.

  
I have arranged the data and filtered out and Make reference sheets for the making of my dashboard.

For getting This Sheet just mail to me :

gaurav_pundir@outlook.com or ranagrv@gmail.com

OR

it will uploaded shortly!!!!

To get More information Please check out my Next Post!!!

Excel DashBoard

Excel Dashboard :

Dashboard is something which contains lot things provides various fields to choose and perform act on same.It contains series of things that are interconnected , whenever you make some changes in any thing of your dashboard ,the entire dashboards reflects old values/calculations are eliminated and new ones added according to user needs.

Making dashboard in Excel is Just Simple thing!! You just have need to know of lots of functions used on excel calculations such as Look-UP functions,Indexing,Matching,Percentage calculations etc.Charts Knowledge in needed..how to choose select data and play with them and arrange the data row and column wise properly.

Therefore, Combine the Functions, Calculations and Charts so that if you change in one thing, It reflects On all things and makes changes dynamically.\

My Dashboard Preview:
 Topic: Analysis of various Indicators of Different Countries.

For Getting more details about Dashboard making go for the next post in MS-Excel Categories.
OR mail to me for making any Dashboard/Excel Project just mail to me:
gaurav_pundir@outlook.com or ranagrv@gmail.com

Arithmetic Mean In Excel

Arithmetic Mean is calculating of mean of the series of numbers.You have to add all the numbers and then divide the obtained sum by the total no.of the given series.
It is very common to measure the central tendency in Excel.

OR simply get the average of the series that is find out the average through AVERAGE function.
Through AVERAGE FUNCTION:

Through SUM FUNCTION:

To get more detail about Excel functions: Refer to Excel Categories.

Mouse handling

This program tells about how to use action Listener methods and its methods along with how to handle the mouse events.whenever you perform such type of functions such as :click,released,drag,move,enter or exit from the window then it reflects your output as by the repaint method:

To Know more about the mouse event functions and its calculations check out the Java Label:

NewClass.java:

import java.awt.event.*;
import java.applet.*;
import java.awt.*;
/*
<applet code="NewClass" width=300 height=100>
</applet>
*/

public class NewClass extends Applet implements MouseListener, MouseMotionListener
{
    String msg=" ";
    int mouseX=0,mouseY=0;
    public void init()
    {
        addMouseListener(this);
        addMouseMotionListener(this);
       
    }
    public void mouseClicked(MouseEvent me)
    {
        mouseX= 0;
        mouseY=10;
        msg="mouse clicked at:"+me.getX()+" ' "+me.getY();
        repaint();
       
    }
    public void mouseEntered(MouseEvent me)
    {
        mouseX=0;
        mouseY=10;
        msg="mouse entered";
        repaint();
       
    }
    public void mouseExited(MouseEvent me)
    { mouseX=0;
        mouseY=10;
        msg="mouse Exited";
        repaint();
       
    }
    public void mousePressed(MouseEvent me)
    {
         mouseX=me.getX();
        mouseY=me.getY();
        msg="Mouse Pressed";
        repaint();
    }
    public void mouseReleased(MouseEvent me)
    {
         mouseX=0;
        mouseY=10;
        msg="mouse Realeased";
        repaint();
    }
    public void mouseDragged(MouseEvent me)
    {
         mouseX=me.getX();
        mouseY=me.getY();
        msg="***";
        showStatus("Dragging mouse at "+ mouseX +" ,"+ mouseY);
        repaint();
    }
    public void mouseMoved(MouseEvent me)
    {
         showStatus("moving mouse at"+ me.getX() + ","+ me.getY());
    }
    public void paint(Graphics g)
    {
        g.drawString(msg,mouseX,mouseY);
    }
}

output:

Optimal Page Replacement C program

OPTIMAL PAGE REPLACEMENT ALGORITHM

Program Description: Optimal Page Replacement refers to the removal of the page that will not be used in the future, for the longest period of time.

Program Code:

#include<stdio.h>
int main()
{
int n,pg[30],fr[10];
int count[10],i,j,k,fault,f,flag,temp,current,c,dist,max,m,cnt,p,x;
fault=0;
dist=0;
k=0;
printf("Enter the total no pages:\t");
scanf("%d",&n);
printf("Enter the sequence:");
for(i=0;i<n;i++)
scanf("%d",&pg[i]);
printf("\nEnter frame size:");
scanf("%d",&f);

for(i=0;i<f;i++)
{
count[i]=0;
fr[i]=-1;
}
for(i=0;i<n;i++)
{
flag=0;
temp=pg[i];
for(j=0;j<f;j++)
{
if(temp==fr[j])
{
flag=1;
break;
}
}
if((flag==0)&&(k<f))
{
fault++;
fr[k]=temp;
k++;
}
else if((flag==0)&&(k==f))
{
fault++;
for(cnt=0;cnt<f;cnt++)
{
current=fr[cnt];
for(c=i;c<n;c++)
{
if(current!=pg[c])
count[cnt]++;
else
break;
}
}
max=0;
for(m=0;m<f;m++)
{
if(count[m]>max)
{
max=count[m];
p=m;
}
}
fr[p]=temp;
}
printf("\npage  %d  frame\t",pg[i]);
for(x=0;x<f;x++)
{
printf("%d\t",fr[x]);
}
}
printf("\nTotal number of faults=%d",fault);
return 0;
}

Output:

Java First Applet Program

This given program demonstrate how the Applet works.How the Function get performed?
To run applet Program First we need to initialize the variables,befor that extends the applet class.

First.java:(Created in NET BEANS IDE )
import java.applet.*;
import java.awt.*;

public class First extends Applet
{
    public void init()
    {
       
    }
    public void start()
    {
       
    }
    public void stop()
    {
       
    }
    public void destroy()
    {
       
    }
    public void paint(Graphics g)
    {
        showStatus("applet Started");
    }
 }

To run this program:
$javac First.java
$appletviewer First

OutPut:

 

 

To get more details follow Java Label....

Applet StartUP

To use Applet in java program or execution can done by only two ways, Before that, Applet are not Stand-alone program.they run either a web browser or an applet viewer provided by JDK (Java Development Kit).

Applet Program does not begin with main() function.It has its own functions such as:
1.void init( ) 
2.Void start( )
3. void stop( )
4. void showStatus( )
5. void destroy( )
6. void paint(Graphics g) defined in AWT component class, where applet will override it.

In Contrast, Swing Applet has different mechanism to execute their program.

To get more details more about java functions : Refer Java Category