Google ad

Join our group Email:

Friday, June 6, 2008

Euro 2008 spreadsheet

EURO 2008 SPREADSHEET

Track the EURO 2008 action with this easy to use EURO 2008 spreadsheet. Just enter the scoreline and the spreadsheet takes care of everything. If you are phobic at entering the scoreline, simply download the spreadsheet again. The spreadsheet is updated periodically. Also, the spreadsheet is quite light and small. The zipped version is only 38 KB and there is virtually no download time.

Download the EURO 2008 spreadsheet
Download the zipped version of EURO 2008 spreadsheet
Go to the online version of the EURO 2008 spreadsheet (Google spreadsheet)


INSTRUCTIONS TO USE

  1. Download the spreadsheet and ENABLE MACROS.
    • Microsoft Excel 2003 users, click TOOLS menu, select SECURITY and select the MEDIUM option. Now when you open the EURO 2008 spreadsheet, click ENABLE MACROS.
    • Microsoft Excel 2007 users, click the OFFICE LOGO, click EXCEL OPTIONS at the bottom, click TRUST CENTER, click TRUST CENTER SETTINGS, click MACRO SETTINGS and select DISABLE ALL MACROS WITH NOTIFICATION option. Now when you open the EURO 2008 spreadsheet, there would be a notification message SECURITY WARNING MACROS HAVE BEEN DISABLED. Click the OPTIONS button to the right and select ENABLE THIS CONTENT.
    • You need to do this just once before opening the spreadsheet. You can fully trust the spreadsheet and macros are written only to reduce the size and improve the functionality of the euro 2008 spreadsheet.
  2. Select your team from the WELCOME sheet. This shows you the fixtures and results, groups standings and the team squad for your favorite team. This sheet automatically generates everything. So no need to enter anything in this sheet.
  3. Once you select your team in the WELCOME sheet, then it is automatically highlighted in the SCHEDULE sheet. In the SCHEDULE sheet, enter the scoreline after each match is completed (we update this after every match day. So if you don't update just download our spreadsheet again). The spreadsheet automatically calculates the result. The winning team is shown in GREEN, the losing team in RED , and if the match ends in a draw, then both the teams are highlighted in BLUE. Just fill the scoreline and it would automatically generate group standings and points. If the match is decided on penalty, then enter the penalty scoreline.
  4. To know the match timings in your country, select your COUNTRY from the country list.
  5. There are no passwords for the worksheet. Simply unprotect it and explore the formulas. The password for the VBA project is euro2008
  6. We love to hear from you. Share your suggestions and improvements via comments.
Download the EURO 2008 spreadsheet
Download the zipped version of EURO 2008 spreadsheet

Friday, April 18, 2008

IPL Spreadsheet, schedule

Indian Premier League Spreadsheet - Schedule, Fixtures, Results, Squads

The BCCI backed IPL is going to start on 18th APR 2008. Follow the action with our useful and easy to use IPL spreadsheet. Just enter the runs scored, wickets fallen and the overs bowled and the spreadsheet would take care of other calculations. If you feel bored with entering scores, just select the winner from the results box. If you are so fussed, then just download our spreadsheet, we would keep it updating till the IPL is over.

Download the IPL spreadsheet

INSTRUCTIONS TO USE

Follow these simple instructions to use the IPL cricket schedule

  1. If you are a Excel 2003 user, Go to Tools->Macro->Security and select MEDIUM. Reopen the workbook and click ENABLE MACROS. If you are a Excel 2007 user, click the OPTIONS button below the ribbon and and select ENABLE THIS CONTENT. This is required for the proper working of the workbook. Trust us, there are no viruses or adware in our workbook.
  2. In the "WELCOME" sheet, select your favorite team from the MY TEAM drop down box. This would show the IPL schedule and the squad for your favorite team. Click on a player name and it would show the profile of the player (you should have enabled Internet Connection). It would also highlight your team in other worksheets.
  3. Now enter the scores in the "SCHEDULE" sheet. Enter runs, wickets fallen and the overs or you may just select the winner from the RESULTS box. But you should enter the runs, wickets and overs to show up details in the "WELCOME" sheet. If you are fussed about all this, just download the spreadsheet from this site. We would update it regularly till the end of the IPL.
  4. The POINTS TABLE automatically calculates and shows the team with the highest points first. If you have entered the runs, wickets and overs completely in the "SCHEDULE" sheet then there would be no problem in automatically updating the POINTS TABLE
  5. See MATCH TIMINGS in your country in the "MATCH TIMINGS" sheet. Just select the country from the drop down box. Hope we support almost all countries.
  6. The "SQUADS" sheet contains the squad for all teams. Click on a player for more details (Internet Connection required). The "LIVE SCORECARD" sheet updates scorecard (when IPL matches are played) from Cricinfo. Right click and click REFRESH DATA for latest scores.
  7. The sheets are protected without a password. You can just unprotect the sheet and explore the formulas. It is totally free. If you have a better or customized version of the spreadsheet, kindly submit it here
Download the IPL spreadsheet

Friday, January 4, 2008

Excel Calendar Creator

Excel Calendar Creator

Open this file with WinZip
Get it from CNET Download.com!

Now create calendars for any year by just changing the year in infinite number of formats with our Excel Calendar Creator. Customize your calendar by changing font, font color, background color, borders, outline, patterns and save them as themes. Load your themes and make unique calendars of your choice. Make any number of colorful printable yearly calendars.

Open with Winzip
Get it from CNET Download.com!

Download Excel Calendar Creator

Download zipped version of Excel Calendar Creator


Instructions

  • Before opening the file, Go to Tools->Macro->Security and select MEDIUM. On opening the workbook, click ENABLE MACROS
  • Excel 2007 users click the OPTIONS button on the top and then click ENABLE CONTENT
  • Go to Tools->Add Ins and click ANALYSIS TOOLPAK. Excel 2007 users click the OFFICE LOGO, click EXCEL OPTIONS->ADD INS->GO and click ANALYSIS TOOLPAK
  • In the CALENDAR sheet, change the year. That's it! Your yearly calendar is ready.

Feeds, Bookmarks

Subscribe
Subscribe to Excel solutions by Email

Join our group

Google Groups
Subscribe to Free excel spreadsheets
Email:
Visit this group

Relevant pages

Google ad