Why I call these calendars are top 5 excel yearly calendars ? Because this is how yearly calendar should be made in excel. From my point of view, if you want to create a yearly calendar using Microsoft Excel, it should be:
1. Easy to customize. It means I or other people who use it can adjust layout, change color, font using excel menu easely.
2. Printed in one page with 12 months layout
3. Generated using excel formula. It means all dates are generated by excel formula, not by typing it manually.
4. Without Macros. I don’t think there is a need to use macro to build this spreadsheet. I found some yearly calendar created using macros and the problems are the spreadsheets only can be used in some version of Microsoft Excel. And this is horrible. How can you use the yearly calendar if the version of Microsoft Excel keep changing and the macro function is not compatible between its version ?
5. Changed by only changing the year. It means it can be used yearly just by typing or selecting targeted year.
And here are the top five based on those point of view :
1. Excel Calendar
This one have holiday and event setting, but if you want to print without detail information about those holiday and event, just clear the print area and set the new print area.
Download
Read the rest of this entry »
March 12th, 2009 | Posted in Personal | No Comments
Will you marry me ? Yes….. And then what next? The wedding… I don’t know whether you have thought about the wedding before you proposed or accepted to get married, but for many people to plan a wedding can be the hardest thing to do, because it involves many things, even if you plan to just have a simple wedding.
Finding the good time and place, organizing the people, are parts of wedding preparation. You can simplify all the preparation by hiring the Wedding Event Organizer to do all the things for your wedding, but still you have to make sure that the organizer will deliver the event as expected and work within your budget.
But, you don’t have worry too much… In this internet era, there are any kind of wedding information available in internet, all you have to do just google it. And if you need some spreadsheets to help you on your wedding preparation, I have filtered some good spreadsheets for you.
Wedding preparation basically just consists of two things, planner and budget, and that’s what I found in internet when I was searching for wedding spreadsheets. I have filtered those spreadsheets into 15 spreadsheets which could give you brief description about wedding preparation. Each spreadsheets have different approach on planning and budgeting, so you can choose the suitable one for you or customize the spreadsheet according to your need. Since all spreadsheets will complement each other, I think there will no item can be missed after you read all the spreadsheets for your wedding preparation.
Read the rest of this entry »
March 8th, 2009 | Posted in Personal | 1 Comment
There are plenty of personal or household budget spreadsheets available in internet which is free to download. I have downloaded more than 30 spreadsheets just to find 1 spreadsheet that can accommodate all my need on creating and controlling my personal budget and expenses. But, it is not easy to find the closest one for my need. I review them all, and I have to remove some duplicate spreadsheets (spreadsheets that only have title differences). I also removed some basic personal budget spreadsheets because the creator just create a plain forms. And finally, I found a spreadsheet from about 15 spreadsheets that I have filtered.
If you are the same with me on try to find the personal budget spreadsheets that can suit your needs, you should see these 15 spreadsheets and find the strength and the weaknesses based on your criteria. And I recommend you to download some of them, test the spreadsheets, and do some customization to see whether it suit your needs or need more adjustment. Some spreadsheets came with a very detailed calculation and analysis, some spreadsheets created with nice layouts, and some others came with the simple budget calculation.
All my review here are based on my personal opinion… After you try it, probably you have different opinion than I am.
Read the rest of this entry »
February 28th, 2009 | Posted in Finance | No Comments
This is my first spreadsheet in this site. I would like to thank my friend at exceltemplate.net which allow me to modify his euro 2008 schedule template to ease me develop the game score prediction spreadsheet. The idea behind this spreadsheet is to make a league of score prediction game, where it the game will last until the final of euro 2008.
I divided this Euro 2008 game score into 4 rounds, i.e group rounds, quarter final, semifinal and final where it rounds have the same rule but different point value. You can change this point value.
The rule for getting point are as follows :
- If the prediction of the match is exactly the same with the results, the player who predicted that will get the maximum point, where in the group round will get 100 and in the final will get 800.
- If the prediction of the match is different in the score results, but the difference of the score is the same, the player who predicted that will get 75% of the maximum point, where in the group round will get 75 and in the final will get 600.
- If the prediction of the match is different in the score results and the score difference, the player still can get 50% of maximum point, where in the group round will get 50 and in the final will get 400.
- The player will get no point at all if their prediction is not correct.
Game guidance :
- Put the maximum player in “Number of Players” cell, the maximum player in this game is 10 (you can modify it if you want more players)
- Put the player name next to the number which shown up after you put the maximum player
- Put your prediction score next to player name in group and knock out prediction scoresheet
- When the result of any euro 2008 matches is revealed, put the results in Euro 2008 result sheet
- See your score in player data and score worksheet.
You can see the display of player scoresheet in the picture below.
Read the rest of this entry »
June 5th, 2008 | Posted in Football, Sports | 1 Comment
