South African Lotto Checker Spreadsheets Added

I've added some new lotto checker files which allow you to check your results for the South African Lotto, Lotto Plus & Powerball draws.

For more details check out:
Lotto
Lotto Plus
Powerball

EOMONTH Problem And Alternative

I've recently had problems with files using the EOMONTH function in 2007. Files with the function in sometimes come up with the following warning message:



Once the file opens the cell with the EOMONTH function in just displays =#N/A
As a result I've created the following function to replace the EOMONTH function. The function uses the same criteria as EOMONTH but uses the word Lastday. The function is used like =Lastday(start_date,months)

Public Function Lastday(datex As Date, mthpls As Integer)

mthpls = mthpls +1

If Month(datex) + mthpls > 12 Then
mth = Month(datex) + mthpls - 12
yr = Year(datex) + 1
Else
mth = Month(datex) + mthpls
yr = Year(datex)
End If
dy = 1
Dim dayx As String
Lastday = Format(DateSerial(yr, mth, dy) - 1, "Short Date")


End Function

It's not fully tested so if you decide to use it and find a problem let me know.

EuroMillions £90 Million - Learn The Secrets!

This weeks EuroMillions jackpot is a massive £90 million! If you want to find out what numbers have been drawn the most or how many odd/even numbers have come out then now's the time to buy the Spreadsheets Direct EuroMillions Checker. The EuroMillions checker also lets you quickly and easily check either a single line, showing you all the times those have won in the past, or multiple lines against each draw letting you see quickly what lines have won.

Buy yours today and see if it makes you rich!

Advertise Your Business Virally With Excel Quizzes

Spending loads on Adwords without much return?

Need to get people to know about your new business?

Want a new way to advertise your business or goods?

Then why not try advertising on

Spreadsheets Direct's Excel quizzes!

How many times have you been sent an Excel quiz by someone you know? If one person in an office downloads a quiz the likelihood is that they will send it on to another 4 or 5 people who in turn will forward it on to their own mates in other offices. A single downloaded quiz could end up on 100 computers in hours and all those people could be looking at your advert!

Spreadsheets Direct's Excel quizzes are currently downloaded around 1000 times a month with new quizzes being added all the time. Current quizzes cover a range of topics including movies, music, television and sport.

Spreadsheets Direct is now offering you the chance to place an image advert or text link on the left hand side of the quizzes starting from just £2.50 a month! Adverts can be linked directly to any page you desire. An added bonus is that, even if you decide not to renew advertising on a quiz, any versions of the quiz that are out there with your advert on will still be showing your advert and could still be being sent round virally giving you click-thrus for a long time to come!

For more information see Advertising Info

Excel Quiz Templates Available To Download

Have you got a quiz you want to share? Download a template here.

1 Answer Template Download

2 Answer Template Download

Send to quizzes@spreadsheetsdirect.com and I'll add them to excelquizzes.blogspot.com so that others can download them.

£85 Million EuroMillions Mega Jackpot!

This Friday's EuroMillions draw is a Mega Draw with a jackpot of £85 Million! If you're in a syndicate and have multiple tickets to check or want to find out what the most drawn numbers are in order to give yourself the best chance for picking your winning numbers then why not invest in the Spreadsheets Direct EuroMillions Number Checker Spreadsheet. The file lets you check single line combinations to see how many times they have won over previous draws or check multiple lines for any past draws to see how many lines have won. You can also easily find what have been drawn the most from any given date so if you find out the most drawn number since the beginning or from just the last few months. The Premium version also gives you extra analysis of the previous 10 draws showing you how many odd/even, high/low balls are drawn, the number range they fell in and consecutive numbers. The EuroMillions Predictor will give you a random selection of numbers but favours numbers drawn the most from a date you select so if you 27 has been drawn 3 or 4 times in the last month the predictor will favour that number more when it picks the numbers.

BUY NOW!!!

excelquizzes.blogspot.com Now Up

For all you quiz fans out there I've created a new blog especially for the Excel ones that I've created. The quizzes are free to download and cover a variety of subjects including film, music and sport.

The blog can be found at excelquizzes.blogspot.com