Attendance Calendar
Posted on August 7, 2009
Filed Under Calendar | 88 Comments
Perhaps this excel file is a combination between monthly and yearly attendance record where you can use some worksheets of this template as a printable monthly attendance forms and collect all monthly data to form employee attendance record for one year period.
This excel file consist of one worksheet of one year attendance worksheet, 12 worksheets of monthly attendance, one worksheet of holiday and one worksheet of employee data. You can enlarge a picture one year attendance worksheet above to see it clearly. In this worksheet, all you have to do just fill the ID of the employee and your targeted year. And all the employee attendance information will reveal automatically. And to make sure that all information will be revealed correctly, you have to fill correctly the rest of the worksheets.
Grocery List
Posted on August 7, 2009
Filed Under Other | 23 Comments
Based on several online dictionaries, a grocery list is defined as a list of heterogenous items that someone wants. Grocery list become popular because it is very rare that somebody can remember many items that he/she has to buy while shopping in a store or a mart. And usually, this list is important while people do their weekly or monthly shopping for their family/household needs.
If you search “grocery list” term in google, you will find many website offering ready made or printable grocery lists. And there are some websites offering you how to create your grocery list online.
This excel file is basically a grocery list maker, where you can put all of your grocery item in one worksheet, select items that you want to buy, and the other worksheet will adjust your selection into a printable grocery list.
Guidance on how to use this grocery list template is as follow :
1. Go into “Item pool” worksheet. I already put many grocery item inside for your reference. You can click the picture below to enlarge it.
Gantt Chart
Posted on July 25, 2009
Filed Under Other | 70 Comments
Gantt chart is a graphical representation of the duration of the tasks against the progression of time where it usually represent a project schedule and achievement. Some people are creating Gantt chart in Microsoft Excel to simplify their project, but with lack of ready-made duration calculation, the Gantt chart created in Excel usually only being used to just show time progress only. That is one reason I created my own Gantt chart. I need a Gantt chart that can be adjusted to represent a project with 5,6 or 7 days duration per week. And it is flexible enough to adjust the duration by entering end date information or just week duration. And I didn’t found that kind of Excel Gantt chart in internet. People just suggested to use Microsoft Office Project for that purposes.
I finished this Gantt chart a month ago, but I don’t feel that this Gantt chart is finished. I think I will still do some refinement in the next version.





