[MLUG] Re: OO.o 3.2 Calc

[Paul Schmidt <schmidthaus57 AT att.net>]

I forgot to mention. The spreadsheet is for $5 in quick-picks, for four 
drawings. That equates to two weeks. The starting date is entered, and 
then the rest of the dates are filled in automatically. It doesn't 
matter if the first date is a Saturday or a Wednesday, it will figure it 
out.

On 08/15/2010 08:19 AM, Paul Schmidt wrote:
> I sent this first, using the wrong email server. Admin: it can be 
> ignored.
>
> On 08/15/2010 01:24 AM, Chad Voelker wrote:
> > Paul-
> >
> > Care to attach a sample spreadsheet? You don't have to share your real
> > winning numbers : )
>
> Only if you promise not to laugh at my amateurish coding! I only 
> taught myself enough to make some spreadsheets at the water plant. I 
> found that I could do everything using the various forms of 'IF', so 
> that is were I stopped learning.
>
> I can share the latest one, the one that I have trouble with. Having 
> it filled out will help to explain how is works. I use quick-picks, so 
> no secrete number will be revealed. The two buttons at the bottom of 
> the page were for things that didn't pan out.
>
> > You could also look into left(), mid(), or right() functions, or even
> > value() should do the trick for ya.
> >
> > -Chad
>
> I tried value(), and it seems to work. I altered one column of the 
> spreadsheet that I am attaching.
>
> Paul