Know of any Excel VBA or Excel functions that can help with general lottery forecasting?

[angExcelentflea]

Permission to post, admins...

Since this group doesn't have any search function, I have no way of telling if the topic of my post has already been made before.
I am only concerned with general, simple lottery forecasting concerns.

So, I'm wondering if anyone here knows some VBA formulas or Excel functions for the following tasks:


a) Counting the frequency of each number in a lottery game

b) Determine which are "hot" numbers, "cold" numbers and "overdue" numbers within a certain draw period in a lottery game

c) Know how many times a number is paired with another number

Hope you would consider helping me out in this...