Excel Dashboard-3

Excel Dashboard:

As you have seen my dashboard in my previous posts.Now i have completed my project ..and i going to upload that...before uploading i am telling what the major things i have done in my project.

1) Filtering: As i told to you that my project ,contains RAW data of various indicators of different countries with respective to their  years(200-2012) . Therefore,I have divided my data into various fields,firstly countries are divided into continent wise such as Asia, Europe, Africa, Australia, America. The buttons are provided on the above of the dashboard you can go specific continent and choose the country that comes under into the respective continent. Data will fetched automatically from reference sheet and all the previously data will be eliminate and new data will insert into the dashboard and various charts will be created.



2) Prediction: So prediction has been done through the various formulas.As i have given with only data till 2012.So i going to calculate for 3 upcoming years. Lets see how did I calculated this:

let I have two values of last two years of any indicator.
Let In 2011--value1      and      2012--value2
 so value in  2013=((((value2-value1) /value1)*value2)+value2)
Similarly, for next coming two years same formula will be applied .....and .....value will be calculated.

  
3) Profit Calculations: For example, GDP is most important component of every country and is refleted by some factors like services ,industry import and export of goods .So which is better of a country is calculated.

As you can see in above picture, we are in Australia continent and in Turkey country,through calculations we have figure out that in Turkey services gives the maximum GDP.

For Download this file go to my next POST: check out MS-Excel categories.
For any Excel project Contact: gaurav_pundir@outlook.com

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....