article-stack

An analysis report on payroll system with diagrams is the 2nd most visited article. As per visitor’s interest I am writing this article to help you technically design your own payroll system.
I am not aware what computer language you prefer. So attaching source code for sample payroll system in maximum of languages. This is just for your reference and ideas. So you don’t leave any functionality by mistake while designing the whole system. It’ll also help you to complete your payroll system project in less time. And will give you an idea about screen designing.

Visual Basic .net

Account information
username: admin
password: admin

Java applet

Source code

import java.io.*;
import java.awt.*;
import java.awt.Color.*;
import java.awt.event.*;
import java.applet.*;

/*<applet code=train2.class height=300 width=600></applet>*/

public class train2 extends Applet implements
ActionListener,ItemListener

{
	Label name,amount,seats,number;
	TextField na,am,sts,nr;
	TextArea t;
	Choice css;

	Checkbox si,sr;
	CheckboxGroup g;

	Button b,cancel;
	int s,c,d;
	int n1=400;
	int n2=250;
	int n3=100;

	public void init()
	{
		setBackground(Color.yellow);
		setForeground(Color.red);
		setLayout(new FlowLayout());

		na=new TextField(20);
		am=new TextField(20);
		sts=new TextField(20);
		nr=new TextField(20);

		name=new Label("NAME");
		amount=new Label("AMOUNT");
		seats=new Label("SEATS");
		number=new Label("REQUIRED NO OF SEATS");

		css=new Choice();
		css.add("A.C SLEEPER");
		css.add("FIRST CLASS");
		css.add("SECOND CLASS");

		t=new TextArea(40,45);

		g=new CheckboxGroup();
		si=new Checkbox("SATAPTI",g,false);
		sr=new Checkbox("SABARI",g,false);

		b=new Button("SUBMIT");
		cancel=new Button("CANCEL");

		add(name);
		add(na);

		add(seats);
		add(sts);

		add(number);
		add(nr);

		add(si);
		add(sr);

		add(css);

		add(b);

		add(amount);
		add(am);

		add(t);
		add(cancel);

		css.addItemListener(this);
		b.addActionListener(this);
		si.addItemListener (this);
		sr.addItemListener (this);

	}
	public void actionPerformed(ActionEvent ae)
	{

		if(b.getActionCommand().equals("SUBMIT"))
		{
			d=Integer.parseInt(nr.getText());
			s=(Integer.parseInt(sts.getText()))-d;

			if(css.getSelectedItem().equals("A.C SLEEPER"))
				{
					am.setText("400");
				}
			else if(css.getSelectedItem().equals("FIRST CLASS"))
				{
					am.setText("250");
				}
			else
				{
					am.setText("100");
				}

		}

c=((Integer.parseInt(am.getText()))*(Integer.parseInt(nr.getText())));
			t.setText("NAME:"+na.getText()+"
"+"After reservation total no.of
seats are:"
			+s+"
"+"Train name
:"+g.getSelectedCheckbox().getLabel()+"
"+"Class:"+
			css.getSelectedItem()+	"Total number of Rs :"+c);

			if(cancel.getActionCommand().equals("CANCEL"))
			{
				repaint();
		}

	}

        public void itemStateChanged(ItemEvent ie)
        {

        }

}

import java.io.*;
import java.awt.*;
import java.awt.Color.*;
import java.awt.event.*;
import java.applet.*;

/*<applet code=train2.class height=300 width=600></applet>*/

public class train2 extends Applet implements
ActionListener,ItemListener

{
	Label name,amount,seats,number;
	TextField na,am,sts,nr;
	TextArea t;
	Choice css;

	Checkbox si,sr;
	CheckboxGroup g;

	Button b,cancel;
	int s,c,d;
	int n1=400;
	int n2=250;
	int n3=100;

	public void init()
	{
		setBackground(Color.yellow);
		setForeground(Color.red);
		setLayout(new FlowLayout());

		na=new TextField(20);
		am=new TextField(20);
		sts=new TextField(20);
		nr=new TextField(20);

		name=new Label("NAME");
		amount=new Label("AMOUNT");
		seats=new Label("SEATS");
		number=new Label("REQUIRED NO OF SEATS");

		css=new Choice();
		css.add("A.C SLEEPER");
		css.add("FIRST CLASS");
		css.add("SECOND CLASS");

		t=new TextArea(40,45);

		g=new CheckboxGroup();
		si=new Checkbox("SATAPTI",g,false);
		sr=new Checkbox("SABARI",g,false);

		b=new Button("SUBMIT");
		cancel=new Button("CANCEL");

		add(name);
		add(na);

		add(seats);
		add(sts);

		add(number);
		add(nr);

		add(si);
		add(sr);

		add(css);

		add(b);

		add(amount);
		add(am);

		add(t);
		add(cancel);

		css.addItemListener(this);
		b.addActionListener(this);
		si.addItemListener (this);
		sr.addItemListener (this);

	}
	public void actionPerformed(ActionEvent ae)
	{

		if(b.getActionCommand().equals("SUBMIT"))
		{
			d=Integer.parseInt(nr.getText());
			s=(Integer.parseInt(sts.getText()))-d;

			if(css.getSelectedItem().equals("A.C SLEEPER"))
				{
					am.setText("400");
				}
			else if(css.getSelectedItem().equals("FIRST CLASS"))
				{
					am.setText("250");
				}
			else
				{
					am.setText("100");
				}

		}

c=((Integer.parseInt(am.getText()))*(Integer.parseInt(nr.getText())));
			t.setText("NAME:"+na.getText()+"
"+"After reservation total no.of
seats are:"
			+s+"
"+"Train name
:"+g.getSelectedCheckbox().getLabel()+"
"+"Class:"+
			css.getSelectedItem()+	"Total number of Rs :"+c);

			if(cancel.getActionCommand().equals("CANCEL"))
			{
				repaint();
		}
	}

        public void itemStateChanged(ItemEvent ie)
        {
        }
}

Please rescan the downloaded files because I afraid from hackers before GOD

Let me know by your comments if you need more screen shots, source code or something else that can help you.

After writing some articles on java generic I realized that I need a short reference sheet which can remind me about what I learnt or written. So I designed this sheet. It was very difficult to design this short of doodled reference sheet in MS word. Even though I did it after wasting many hours.

Download from here
This area is protected to registered users only.
Some of the examples in sheet refer my previously written articles. Read them once. They’ll help you to remember the actual link between concept and reference syntax.

1. Java Generics – Boys are not allowed in Girls community
2. Java Generics continue
3. End of Java Generic

*Attached contents to this article are under copyright. Don’t modify it or change the reference name. You are free to redistribute the same copy.

Maximum visit to my site are basically for searching articles related to invoice, inventory and payroll. Even though none of the user has requested for any specific article, I am writing this article for supporting such users.

There are some templates which are needful for billing ,sales ,purchase and other invoices. Take their printout or modify as per your need.

Pro Forma Invoice Template – most useful when two companies are doing business together for the first time and for import/export transactions.

Purchase Order Template

Billing Statement

Sales Invoice

*Please note that all templates are in excel format and free to use. They might not be macro enabled due to limit of free version. But best for printing media and your ideas. If you are really willing to create your own macros or formula refer Complete Video series to learn excel

While writing some other articles over Anonymous Classes, I wrote a code to watch over how many bytes of a file has bean read or write. I am sharing that code with all of you to improve understanding in use of anonymous Classes, advanced java concept.

This is very simple and handy code. You can change it as per your need like to keep a watch over file uploading (to limit upload file size), or intimating admin via mail when log file size exceed etc.

This article will also help you to understand need of interfaces over abstract classes.

myFileWriter.java

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStream;
import java.io.OutputStreamWriter;
import java.io.Reader;

/**
 * Copyright (C) 2011 Amit Gupta
 * You are free to redistribute the code or its modified version
 * by giving the credit to original code.
 *
 * This code is useful to understand the concept and
 * importance of anonymous class. And how to reuse java classes
 * @author Amty
 *
 */
public class myFileWriter extends OutputStreamWriter //implements myProgressListener
{
	myProgressListener mpl;
	long pBytesWrite;
	public myFileWriter(OutputStream arg0) {
		super(arg0);
		//mpl=this;
		pBytesWrite=0;
	}

	@Override
	public void write(int c) throws IOException {
		super.write(c);
		pBytesWrite++;
		if(mpl != null){
			mpl.update(pBytesWrite);
		}
	}

	public void setProgressListener(myProgressListener mpl){
		this.mpl = mpl;
	}
	//public void update(long pBytesRead, long pContentLength, int pItems){}

	public static void main(String[] args) throws Exception{
		FileOutputStream fos = new FileOutputStream("D:\\article-stack\\amtyOutput.txt");
		FileInputStream fis = new FileInputStream("D:\\article-stack\\amtyInput.txt");
		InputStreamReader isr = new InputStreamReader(fis, "UTF8");
		Reader in = new BufferedReader(isr);

		myProgressListener mpltest = new myProgressListener() {

			@Override
			public void update(long pBytesWrite) {
				System.out.println(pBytesWrite + "Bytes are written");
			}
		};

		myFileWriter mfw = new myFileWriter(fos);
		mfw.setProgressListener(mpltest);
		int ch;
	    while ((ch = in.read()) > -1) {
	       mfw.write((char) ch);
	    }
	    in.close();
	    mfw.close();
	}
}

myProgressListener.java

public interface myProgressListener {
	public void update(long pBytesWrite);
}

Output:

74381Bytes are written
74382Bytes are written
74383Bytes are written
:
77710Bytes are written
77711Bytes are written
77712Bytes are written
77713Bytes are written
77714Bytes are written

Here is attached code for your reference.
This area is protected to registered users only.

As soon as the semester end is coming, students are downloading sample database most. So here i am including one more database file of books. Attached Zip file includes CSV,XML,MDB,XLS file for your reference. It is not a huge database. It contains a list of around 30-50 books with their author name, price & all. So you’ll not have to waste your time to create it.

Various version of database will help you to use it in any project. It also has images of listed books.
This area is protected to registered users only.

You would have seen many websites showing text with stylish fonts, even if those fonts are not available on client site.
It’s very simple. Just copy paste a CSS code somewhere in HEAD tag.

If you are aware with my new font amty currency then you can do it in next 2 steps very easily.

1. You need fonts(various format) to keep on your web server. You can download them from the download link given in the end of this article.
2. Use the following CSS code in your CSS file or on your webpage

@font-face {
	font-family: 'Conv_AmtyCurrency';
	src: url('fonts/AmtyCurrency.eot');
	src: local('?'),
	url('fonts/AmtyCurrency.woff') format('woff'),
	url('fonts/AmtyCurrency.ttf') format('truetype'),
	url('fonts/AmtyCurrency.svg') format('svg');
	font-weight: normal;
	font-style: normal;
}

Sample Demo & required files

Any big ceremony brings dozens of work, thousands of ritual and a proper arrangement. Even though if you arrange staff to complete everything you must someone to check and watch whether everything has been completed.

Below checklists will arrange your all planning of wedding ion very advance. Most of the versions are in PDF. You also can download the last version available in excel format. So you would be able to modify the list as per your need easily.

PDF

Excel

The Virtual Lab is intended as a flexible teaching and learning tool. It can be used for in-class discussions, pre-lab activities, or novel types of homework problems. The aim of this project is to increase student learning and motivation.

Normally people start feeling their responsibility once they cross age of 30 or when they got married. But some out of them starts planning their budget from the initial halt of their life. Like me…. Ha ha ha..

If you are not very good in finance and avoid bulky & boring clerical work then below excel templates would help you surely to plan your budget

Halt 1 : Personal Budget Planning

Halt 2 : Wedding Budget Planning

Halt 3 : Family Budget Planning

Halt 4 : Kids Money Management

Halt 5 : Retirement Plan

Whenever a new currency symbol gets registered, Unicode is assigned to this. So people can use it in their application. But they need to update their application so that their applications can support new unicodes. Some people and organizations are supposed to use old version of applications due to licensing issue. Or because, updating to new version of application may need update in many existing resources.

On the other hand, using an open source font in your application is not only easy but it’ll require no changes or update in existing resources. In addition, it’ll minimize the effort too.

Best feature of this font is OPEN SOURCE (under GPL). You are free to use it in personal or corporate applications.

Why to use Amty Currency Font instead of Images?
Many of the website designers start using images to display currency symbol at their site. Amty Currency Font is a good replacement of this.

• If you are aware with SEO concepts, there is an extra http request is required for each image on the page (single request for repeating images).
• Size of the images is always greater than fonts.
• You can display fonts in any size, any color with any background color.
• You can use them to generate complex CAPTCHA images.

Worrying about your coming old age, retirement, and pension or saving?

People starts saving once they start earning. But it becomes difficult to figure out whether their saving is enough for their retirement after all big expenses like marriage, medical etc.

Below retirement calculator excel template shall help you to compare two or three different Savings Plans and help to choose the right plan for you.

*click above image for downloading

Preparing a classical ugly textual report using some word editor may make your impression down in your supervisor attention. On the other hand, if you prepare a report containing charts, graphs, figures and data arranged in tabular format then it may require extra technical knowledge and time.
Well!! I have solution for both. Use below excel templates which can minimize your official documentation work as per your need.

1

Timesheet

2

Timeline

3

Gantt Chart

4

Critical Path Method

5

Vacation

1. Ever wondered what it may take to come out of a credit card debt?
2. How long it will take to pay off credit card balance with and without making more monthly payments?
3. What to do to pay off faster?
4. Handout the below excel template Credit Card Payoff Calculator which can help you to answer above questions

With help of this calculator it will be easier to figure out the ways to completely pay off your credit card debt and helps to understand just how much it can really cost you in interest.

*click above image for downloading

If you know how to work with excel then these working sample excel templates shall give you better experience. Here are some excel templates to schedule your weekly,monthly or yearly work, shifts etc. effectively.

A good reason about working with excel sheet is, you need not to install any software.

Download the below excels and organize your time. All the best.

1

Schedule your work

2

Organize work assignments for an entire week

3

Schedule the week

4

Baby feeding Schedule

This database contains enough data for your practice and to test your application completely. Still if you do some changes or populate it with more data then please share it with me. So I can spread your work.

Download here
This area is protected to registered users only.

Don’t you ever find any software which can keep records of your software or applications?

Mr das has a huge library of movies and software. But he ever fails to find out the exact software when he needs. He can’t keep everything in his computer because of memory and virus infection. So he is supposed to burn CD, DVDs. But finding out one DVD out of 100, is really time consuming and frustrating job. Finally, he labeled every DVD. And he maintained a database to manage software and movies. He stored all information about which CD keeps which software, in a MS Access file.

Here I am sharing Mr das’s database with you. It contains enough sample data for practice, if you are solving some SQL exercise or building any database project. Otherwise you can use it for use personal use. You can download more database files from here.

It is MS Access file. Either you can burn it with CD/DVD itself. Or you can keep a central copy saved on your PC. In second case, you would have to increase one more column in attached database file for CD/DVD label entry. So you’ll become able to search your important software.

I had already provided sample database for inventory of goods and an analysis report too.

If you are developing an application for some transport company or for your personal practice then this sample file can help you. You can use this database file for personal or commercial purpose. I am providing this file specially to increase understanding about database designing. You can read analysis report & design for transport based application.

Download here
This area is protected to registered users only.

If you are building some wiki type of application or a project for library or bookstore then this list may be helpful for you. It contains name of 6000+ authors. It also contains date of birth field. But few entries of date of birth are available. You can complete it.

Feel free to use it. And please share it with me, if you so some update in it. I had uploaded many database files for your reference and help. You may list them by db files and can download them.

Download here
This area is protected to registered users only.

Like other articles of db files, I wrote this to provide free and sample database related to inventory. This database file is related to item and customer relationship. It’ll be very helpful if you are trying to solve previously written article on SQL exercise. Otherwise you can use this database to make any inventory project related to small firm or shops deal in selling and buying items.

This database file is available in MS Access format and contains some dummy data for practice. It contains around 4-5 tables. For more data, you would have to populate yourself. Feel free to use this database. And share it with me, if you do some update on it.

Download here
This area is protected to registered users only.

This article is written specially for students who are building an application or project for their own practice or as a college, school assignment. It might help you to improve your analysis level. Here, you will know

• How to relate tables?
• How to separate data into multiple tables?

It’ll help you to build project related to hotel management where people stays, check in and check out. It’ll not help you if you are building an application related to some restaurant.
If you need some more data base you can visit db files tag. My purpose is to make you concentrate on, how to retrieve data not to build data. If you have less time to develop complete your projects or assignment you can use ready to use code and applications from this site. Now the time is to go practically and improve your understanding in retrieval of data and SQL.

Download here
This area is protected to registered users only.