Monday 23 November 2009

Arizona The Pick Lotto Results Checker Added

Another addition to the Lotto result checker spreadsheet family is one for the Arizona The Pick Lotto. Details can be found here US Arizona The Pick Lotto Checker. Here's a list of all the other lottery result checker spreadsheets currently available...

UK Lotto Checker
UK Thunderball Checker
Irish Lotto Checker
EuroMillions Checker
US Powerball Checker
US Super Lotto Plus Checker
US Florida Lotto Checker
US Mega Millions Checker
US New York Lotto Checker
US Hot Lotto Checker
US Texas Lotto Checker
US Missouri Lotto Checker
US New Jersey Lotto Checker
US Win For Life Lotto Checker
OZ Lotto Checker
OZ Powerball Checker
SA Lotto Checker
SA Lotto Plus Checker
SA Powerball Checker

Add to Technorati Favorites

Office 2010 Beta Workgroup Problem

I downloaded the beta version of Office 2010 the other day (available here). From what I saw it doesn't look too different to Office 2007 apart from the ribbons having a few different size buttons on. One side affect from having it on my system though seems to have been it blocking my Workgroup from seeing other computers. The computer with the beta on was a Vista laptop and I also have an XP laptop and Ubuntu desktop that can access the workgroup. The XP & Ubuntu computers could see and access the other computers but for some reason Vista couldn't see them. After a lot of messing around and googling to find an answer to no avail it clicked that the problem had only started since I installed Office 2010 beta so I decided to uninstall it and after a reboot the workgroup was back up and accessible. So just a warning if you wan't to try the beta go ahead and download it, it's free so might help you out if you desperately need to work on a spreadsheet but just beware that with it being a beta things might go wrong or other things might be affected.

Add to Technorati Favorites

Wednesday 18 November 2009

Excel Lotto Checker Spreadsheets Added For Missouri, New Jersey & Virginia Lottos

I've just added some lotto checkers for the Missouri Lotto, New Jersey Lotto and the Virginia Win For Life Lotto. All are available in basic and premium formats. For more information click the links below...

US Missouri Lotto Checker
US New Jersey Lotto Checker
US Virginia Win For Life Lotto Checker


Add to Technorati Favorites

Thursday 12 November 2009

Hot Lotto & Texas Lotto Checker Spreadsheets Added

I've just added some lotto checkers for the American Hot Lotto and Texas Lotto. Both are available in basic and premium formats. For more information click the links below...

US Hot Lotto Checker
US Texas Lotto Checker

Add to Technorati Favorites

Saturday 7 November 2009

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


Add to Technorati Favorites

Thursday 5 November 2009

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.

Add to Technorati Favorites

Wednesday 4 November 2009

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!

Add to Technorati Favorites