excel lottery pool manager

Reply #8

SergeM — Wed, 30 Apr 2014 19:58:35 GMT

The solution to the problem is downloading my addin. For this see https://www.lotterypost.com/thread/274354 .

Reply #7

sflottolover — Tue, 08 Apr 2014 16:12:23 GMT

I first learned Lotus 1-2-3 before the initial excel appear. It was the first Excel that I learned and used for five years in managing, and produced accounting reports handed to my accountant, for the 10 units apartment until it was sold. For the busy works on the other jobs, the excel has been untoched over 17 years (now), I really forget most of the usage about the main keys fuctions. Especially for the new keys fuctions of newer 03,07,10,13 (that most after my first learnt). I think it may he... [ More ]

Reply #6

captnpops — Mon, 07 Apr 2014 04:29:13 GMT

I use Idaho which is a string also, but since each number is two digits, I use a row of cells with the offset value of digits in each cell... 1, 4, 7, 10, 13

1 4 7 10 13

16, and point a mid formula to separate.. ie mid(string, offsetcell address, 2).

Reply #5

SergeM — Sun, 06 Apr 2014 22:18:52 GMT

I just found out that the web query on the Texas All Or Nothing doesn't do it anymore in Excel. They changed the output, so instead of getting the values nicely into cells, we get annoying strings like 1 - 2 - 3. That is not very user friendly! I can fix the problem for myself. For others it isn't fixable without doing the manual splitting in Excel.

Reply #4

captnpops — Sun, 06 Apr 2014 13:54:49 GMT

Great point RJOh,

My approach to excel was to develop and use tools/reports and analysis in my everyday job.. As an aerospace beancounter mostly in management, I had the opportunity to use excel in many different environments.

Personnally, the ability to write several what-ifs/then formulas separated the majority of those that are curious and perhaps intimidated to a few that are not only comfortable but anxious for more challenges..

Reply #3

sflottolover — Sun, 06 Apr 2014 03:27:29 GMT

MSFT, office programs could not use properly as I bought my new notebook with window 8. I really cannot use the excel comfortably. There're sometimes, the result comes out not quite perfect. I beleive it is true, update of learning might be neccessary, i hope can learn it again in Hong Kong if it is possible.

Thanks for RJOH suggested.

Reply #2

RJOh — Sat, 05 Apr 2014 15:54:23 GMT

With today's operation systems of 64 bits what you remember doing yesterday doesn't mean much. You have to be continuing to relearn to keep up. With MicroSoft no longer supporting Windows XP in a few days a lot of stuff people learned years ago with have to be relearned to use the newer versions of their programs.

Reply #1

sflottolover — Sat, 05 Apr 2014 14:37:34 GMT

How can I get help to rewise or learn it back? (After a very time have not touched excel nearly all forget how to use.

Your new post seems bring me a twilight. What can i do if i forget my excel's skill? (or need to update with new editions to Excel 7, 10.)

I'm early want to get back my excel memory. (Very long time not touched nearly forgot.

excel lottery pool manager

captnpops — Sat, 05 Apr 2014 13:50:08 GMT

Years ago, I ran a lottery pool for work on an excel spreadsheet as I was an aerospace bean counter.

Now I'm retired and refined the spreadsheet to manage pb and mm for ten tickets for the next five draws, and calculate the winnings. My last tweak allows each spreadsheet user to refresh the pb mm results via a one click refresh of an external query.

I'm out of the pool manager business, just curious if anyone has an interest in managing the pool by filling out the spreadsheet emailing it t... [ More ]