Still looking to put together macro for sum of skips!

[mirage]

re: below/above average.. I'm talking about the skip sum total.. Remember I mentioned adding in a thing so you could see how many times each skip sum happened over the last 104 draws, and that I could put in an average per year along with that.. that's the average I'm talking about..

Re: doctor - I think i'm gunna hafta call him again. Starting friday my right ear started leaking some yummy orangish sticky water running right down my neck.. and boy did i scoop out some nasty stuff with them q-tips.. now of course it's all plugged up and throbbing to my heartbeat.. I wish it was November already

Hello Snides,
Thanks for the info and for the update.
Re: Your health. O' mi Gawd...! Perhaps you should see a doctor asap, as in emergency. Do you have a fever? Q-tips not a good idea. Here's a suggestion - for some good practical advice call Telehealth - government sponsored 24 hour nursing service to get some advice - 1- 866-797-0000. Telehealth very good - professional and thorough. If it were me, I would not risk waiting. At least get some advice immediately.
Some things are more precious than winning money - like not loosing your hearing, your life and your good health! Good luck!!
Keep me posted on how you make out.

 

[Snides]

I don't think it's that big of emergency Mirage.. I've had ear problems since i was a kid.. and this leaky ear thing, had it too, about 2 months ago.. ended with an ear infection and anti-biotics.. this is the worst it has been, i'll admit that.. Doc never seems to concerned, almost like he's expecting the symptoms i have.. and telehealth, I've called them before too, they never seem overly helpful over the phone.. they can't diagnose it very well, and usually just tell you to see your family doctor asap. They did tell me to go to emergency once, that was when i had the most crippling ear infection ever, I had to have someone take me cus I couldn't stand on my own. All they did at the hospital was give me two shots in my a** and send me home..

I'll be fine Mirage, for someone that has perfect ears and likely hasn't had ear infections since being a baby, this must sound horrible, but it's becoming a part of daily life for me..

 

[mirage]

Hello Snides,
Well at least you were able to get my response last eve.
I just briefly checked in on the board before having to retire for the night. I admit I was quite concerned but maybe too reactive. (Perhaps medical issues should be discussed in another general discussion area but o well.)

I've known a number of other people who've had ear problems since small children but usually with time improve.

Here's a couple of other thoughts. Perhaps you've already looked into them and/or know they wont work but...
I have a friend, well an acquaintance, who used to be a GP physician and when I needed a specialist more quickly than what I was able to find in my city he suggested researching to see if there was other specialist, perhaps in another city, who might be able to get me in more quickly. So phoning around and networking - let the office know that you are really in desperate need (time to put one's pride aside) and of course your doctor can switch referral.
Do you know anybody personally who works in a hospital who knows how to push and pull the levers of the system? - Medical professionals have ways around the system that the general public do not.

2nd, and from from what you've said, you've probably been down this route lots of times already, so maybe I'm wasting my breath so to speak, if you are really in bad shape get yourself back down to emergency to one of the better hospitals and refuse to leave until you are seen by a specialist. That's one quick way to get to see a specialist - they usually have someone on call in emerg do they not? Even though you say you will be OK, I am concerned - orange stuff running from your ear sounds like blood in the leakage. Indication of ruptured ear drum? Maybe the Canadian medical system is not adequate to address the nature of your problem. Now if you had the money you could get in quickly to see a top notch specialist in the US... Maybe that would solve your problem.

Once again best of luck. Hope you feel better soon. Keep me posted.

 

[Snides]

I went to see doc today, he gave me another 10 days of amoxicillian, and boy, it's drying me out already, gunna need a few gallons of apple juice..

He also mentioned that there is a new ENT specialists moving into a nearby town and he figures I might be able to get in there before the second week of september. So I'm hoping for a phone call tomorrow or wednesday to see if I have a new appointment. Hopefully that works out and maybe I'll be all fixed up soon..

He didn't sound too concerned about the orangish fluid, but he did cringe a bit when i mentioned it.. it's pretty much the same colour as ear wax, far as i could tell..

I should feel much better in a few days, and then I'll get back to work on finishing your program.. actually, i have tomorrow off, so i may get around to adding the ability to update the databases then. That way you'll at least be able to use it for a bit till I finish off some of the filters I want to add to it, and you'll probably have a few more ideas/suggestions of things to add as well..

 

[mirage]

Hello Snides,
Glad your doc appt got things moving along in positive sounding direction. Sounds like you got doc's attention. Good luck with new ENT specialist - hope you get in to see this person within a month or less.

Re back to program - that would be awesome Snides if I could have the minimum but don't stress yourself. Drink lots of apple juice and take care.
Best of luck.

 

[Snides]

Hey Mirage, sorry to dissappoint, but I havn't touched the program.. good news is I'm starting to get some energy back, and the nagging cough is almost gone..

and the even better news is, Doc got me into the new specialist. I have an appointment on Sept 1st, which is apparently the first day for this fresh out of school specialist. Hopefully he knows enough to figure out my problem without mis-diagnosing me. I'm keeping the appointment with the other specialist just in case

I'm also supposed to pick up my x-ray (that i had done awhile ago) to take with me, so maybe I'll be able to look into my own head and figure out my problem, and I'll be able to see if my brain really is as big as I think it is

 

[mirage]

...and the even better news is, Doc got me into the new specialist. I have an appointment on Sept 1st, which is apparently the first day for this fresh out of school specialist. Hopefully he knows enough to figure out my problem without mis-diagnosing me. I'm keeping the appointment with the other specialist just in case

Re appt - Finally. Only 12 days away. New doc probably just fine. Not burned out and armed with up to the minute medical knowledge.

 

[mirage]

To Snides, (I hope you will come back to visit this board soon someday...) - Did you get to see the specialist and how did it go?

Gosh I hate being on this Q & A section so much. I must seem like a real ___ (you fill in the blank).

I am trying to learn VB myself finally but I have so many other life to-do's and issues on my plate it's slow going.

I got desperate and re-contacted the "math-wizard-professor" guy and he wrote me a program but the idiot gave me a pretty looking product ... that gives me all and every combination of 6 out of 49 in every possible configuration, for example 1, 2, 3, 4, 5, 6, plus ... 1, 3, 2, 4, 5, 6, plus 1, 4, 2, 3, 5, 6, plus 1, 5, 2, 3, 4, 6 plus 1, 6, 2, 3, 4, 5, and then starting with 2, 1, 3, 4, 5, 6 plus etc .... etc etc etc etc etc ..... that equal the sum for one skip. The program takes forever to run, has a humongous number of combinations, way way way more than what it would be for all combos for the 6/49 for a sum of skip (for one sum skip number), and he wants to charge me $800 for this. He's not at all familiar with lotteries and didn't understand what I wanted, but he claims between himself and a tech assistant they spend 100 hours working on this product. (???) Which I find hard to believe. Sleazy if you ask me. I have no choice but to pay up but I am one unhappy camper.

My question is this: What crucial piece of VB technical information did this dumb mathie not include in his programing? If I'm going to pay this guy this kind of money I want the program to at least do what I want it to do - provide all combinations for the 6/49 or 6/45 lottery that will equal one sum of skips. Thanks for any help I can get!

 

[Beaker]

To Snides, (I hope you will come back to visit this board soon someday...) - Did you get to see the specialist and how did it go?

Gosh I hate being on this Q & A section so much. I must seem like a real ___ (you fill in the blank).

I am trying to learn VB myself finally but I have so many other life to-do's and issues on my plate it's slow going.

I got desperate and re-contacted the "math-wizard-professor" guy and he wrote me a program but the idiot gave me a pretty looking product ... that gives me all and every combination of 6 out of 49 in every possible configuration, for example 1, 2, 3, 4, 5, 6, plus ... 1, 3, 2, 4, 5, 6, plus 1, 4, 2, 3, 5, 6, plus 1, 5, 2, 3, 4, 6 plus 1, 6, 2, 3, 4, 5, and then starting with 2, 1, 3, 4, 5, 6 plus etc .... etc etc etc etc etc ..... that equal the sum for one skip. The program takes forever to run, has a humongous number of combinations, way way way more than what it would be for all combos for the 6/49 for a sum of skip (for one sum skip number), and he wants to charge me $800 for this. He's not at all familiar with lotteries and didn't understand what I wanted, but he claims between himself and a tech assistant they spend 100 hours working on this product. (???) Which I find hard to believe. Sleazy if you ask me. I have no choice but to pay up but I am one unhappy camper.

My question is this: What crucial piece of VB technical information did this dumb mathie not include in his programing? If I'm going to pay this guy this kind of money I want the program to at least do what I want it to do - provide all combinations for the 6/49 or 6/45 lottery that will equal one sum of skips. Thanks for any help I can get!

Please tell me you are not going to pay that $$ for 10 lines of code and 30 seconds of work - please.

If you cannot answer in the affirmative I would like to discuss - and offer - my services to you. I won;t charge much - say $50,000 for the first 200 hours.

I will deliver what you want - guaranteed.

 

[mirage]

Please tell me you are not going to pay that $$ for 10 lines of code and 30 seconds of work - please.

If you cannot answer in the affirmative I would like to discuss - and offer - my services to you. I won;t charge much - say $50,000 for the first 200 hours.

I will deliver what you want - guaranteed.

Hi Beaker,

I know you are trying to be ironic or something but please don't laugh at me please...
Yes it is true. I have to be honourable and pay up, even though the other guy was ... well let's just say slick.
I asked for help here and thought I was going to get it but haven't yet and am still waiting. I am doing my best. All I wanted was something pretty simple, but then people felt they had to prove their worth to the rest of the world and things got all complicated.
I still really want this. Even if it takes me years to figure it out myself. However I'd rather not have to take the years it may take for me to figure it out.
The guy wrote the program. As he did point out to me, he isn't familiar with the lottery. And he was too literal or I was not totally and absolutely specific. I thought he would get the obvious but I guess some people don't. They think like computer programs themselves.
If I can get back to him and say look you didn't do what I wanted just please do this and add this in, he would probably be happy to oblige. He is in business and therefore expects to make money but I think he wants to leave his customers happy - that would be normal for a person in business who wants to stay in business of course.

I am an artist not a mathmetician.
Different people have different skills.
.................

So concerning those 10 lines of code and 30 seconds of work, yes I would be happy to accept your offer and pay (with a promissary note contingent on winning one lottery prize) your price of $50,000, or however much you want, for your valuable time and effort to assist me.

 

[Snides]

I'm still here Mirage, I thought I was feeling better for a few days, but as i type my right ear is not sure if it wants to stay plugged, or if it wants to clear up..

I went to the specialist, and I have to return to him on thursday.. He doesn't seem too concerned with my sinuses at the moment, but he mentioned a CT scan could be in the near future. My ear was plugged up and ringing nice 'n loud when i was there on wednesday, so he is concentrating on that right now. He also said that it looks like there is a polyp very close to my eardrum, so that is another reason to focus on the ear more.. He gave me some drops which are trying to open my ear for the hearing test, so I guess I'll know more about what's wrong with my ear on thursday, and if what he saw is a polyp, i suppose someone will warm up their CO2 laser and shoot it off..

I'm sorry this program has been delayed so much, I do plan on finishing it.. I was trying to use a 'microsoft wizard' to do the update portion (which has worked in the past, but now it appears that it doesn't..) So I will make one manually.. It shouldn't take long...

Your math buddy sounds more like a con-man.. apparently he thought you wanted every combination possible that could come out of the machine, instead of a sorted order of the possibilities..

I have 2 out of the next 3 days off work, so I will try to finish the updater in that time.

 

[tomtom]

I might be wrong, but it seems to me that Mirage would like to have only a small macro or code for these sums of skips. For that reason, maybe it’s more convenient to post only that for now, and the rest might wait for some better time?

 

[mirage]

Reply to Snides

Hello Snides
Sorry I couldn't respond last night. I had to be out of town. Glad that you were able to get in to see the specialist Wed. and your ear problem is in process of getting help. Good luck with your Thursday appt.

I can wait for the updater to be completed, and therefore the first version of the program, if it really is just a matter of a week or so. However, if it's longer than that I need to talk to this "math buddy" to get him to fix it before I pay, if possible. Therefore I would need to tell him the macro or at least what to use in the macro so he can fix the program. Do you really think math guy is a con man? Is the solution so easy that it would jump out at anybody who is at all familiar with VB? Or is he just oblivious? He was recommended by another lady who said she knew Excel pretty well and was in business herself writing programs but what I was requesting was a bit beyond her abilities or it would be too much work for her to try to figure it out.
I dunno'...?
Anyway, hope to hear back from you, or someone with a macro, soon. Thanks!

 

[Snides]

I'll try to finish it tonight, or tomorrow.. got a few things i need to do tomorrow though, at latest probably tomorrow night..

Math guy could be a con-man.. or, if he's truly oblivious to lotteries, and lotteries, if he's never played one, heard about one, seen one, or read about one, then maybe he isn't..

The solution is quite easy, at least the solution to your initial question. But when that returns almost half a million combinations, I can't see how useful it would be to you. That's why I started adding in filters in order to reduce the 'bad' combinations and provide more good ones.. I guess I should have stuck to what you actually wanted in the beginning, and you would already have a program to do that simple task. I just couldn't see how it could be of any value when you would still have so many combinations to choose from..

The lady doing the programming, is she just doing it in excel? or does she use VB as well? Trying to to something like this in excel would be insane.. sure the language is almost the same, but you are limited to 65535 lines of results.. and since without filters this question can produce up to 400,000 combinations, you would have to span a few columns to fill in all the results..

Eeeesh, in the time it took to write all that i could have finished the updater..

 

[mirage]

I'll try to finish it tonight, or tomorrow.. got a few things i need to do tomorrow though, at latest probably tomorrow night..

Math guy could be a con-man.. or, if he's truly oblivious to lotteries, and lotteries, if he's never played one, heard about one, seen one, or read about one, then maybe he isn't..

The solution is quite easy, at least the solution to your initial question. But when that returns almost half a million combinations, I can't see how useful it would be to you. That's why I started adding in filters in order to reduce the 'bad' combinations and provide more good ones.. I guess I should have stuck to what you actually wanted in the beginning, and you would already have a program to do that simple task. I just couldn't see how it could be of any value when you would still have so many combinations to choose from..

The lady doing the programming, is she just doing it in excel? or does she use VB as well? Trying to to something like this in excel would be insane.. sure the language is almost the same, but you are limited to 65535 lines of results.. and since without filters this question can produce up to 400,000 combinations, you would have to span a few columns to fill in all the results..

Eeeesh, in the time it took to write all that i could have finished the updater..

Hello Snides,

Yeh, yeh, yeh, slap me upside the head, you are right, about the above, of course. I guess I had some kind of delusion but maybe it wasn't completely delusion at the time that I thought of it, even with say 10's of thousands of combinations for one sum skip value I could take the time to rule out any unlikely combinations and import the remainder list into Excel to eliminate further combinations with filters that I had written myself. It was the sum skip filter that was the rare and difficult one in particular (for me) to solve. Meanwhile I guess I don't know Excel all that well and am struggling to learn VB myself, and even 10's of thousands of combinations would be totally crazy, given that I'm already too busy, going into the fall and my life right now. I was trying to make time to progress the solving and analysing but so much else to do...(!!)
So anything that you can provide as soon as possible would be most helpful. Actually the one that would be extremely useful to me anyway would be the one where one plugs in a line of combos and it checks the sum skip value for that line. How about it?
I guess I'll just pay off the other programmer to get rid of that headache but tell him I'm not happy and that I will get back to him.
Thanks Snides!
...(Sure hope I'm not just doing more of this)...

 

[mirage]

Hello Snides,
How did the doc visit go last Thursday? Any news?

 

[Snides]

The specialist was ready to call me cured, he said the polyp (if it even was one that he saw) had 'melted away'. I assured him that he wasn't finished and there was something else causing problems, so i am now booked for a ct scan of my sinuses in late november.. I still have my november 3rd appointment at the other specialist, so i will be going to that to see what they say. Today I feel like crap, I thought i was feeling better yesterday, but that damn right ear still has some fluid in it somewhere. Everytime i lay down it clogs back up. Oh ya, he gave me a hearing test and said the right ear has some hearing loss, but that it was in low frequencies 300-3000 Hz, which is rare, but i'm guessing that is probably due to the fluid still being in there..

I wish i felt better so I could finish this thing for you, but my eyes are sore looking at this screen.. I'm gunna go jump in the jacuzzi to wash away my problems..

 

[mirage]

The specialist was ready to call me cured, he said the polyp (if it even was one that he saw) had 'melted away'. I assured him that he wasn't finished and there was something else causing problems, so i am now booked for a ct scan of my sinuses in late november.. I still have my november 3rd appointment at the other specialist, so i will be going to that to see what they say. Today I feel like crap, I thought i was feeling better yesterday, but that damn right ear still has some fluid in it somewhere. Everytime i lay down it clogs back up. Oh ya, he gave me a hearing test and said the right ear has some hearing loss, but that it was in low frequencies 300-3000 Hz, which is rare, but i'm guessing that is probably due to the fluid still being in there..

I wish i felt better so I could finish this thing for you, but my eyes are sore looking at this screen.. I'm gunna go jump in the jacuzzi to wash away my problems..

Hello Snides,
I'm so sorry to hear that your ear problem(s) and so on continue. Wishing that some med professional will give you some real assistance soon. Be interested to know how it turns out.
Hope that jacuzzi is of help too!
Hoping you will stick around, and let us know how things go.
Good luck and all the best!

 

[Snides]

I've just been working on the updater, and although i could finish it tonight, i likely won't till tomorrow. I just tested it by updating the latest 649 draw, and I'm adding in the code for on/49 and lottario. you can update all 3 from the same screen.. currently after updating you'll hafta close the whole program and restart it to be able to use the new draw info.. I may change that before tomorrow's release date, but who knows, maybe I won't

I'm adding in a couple of neat features, like automatically entering dates for you (of course you can change them) and I'll try to add some simple error trapping..

in any case Mirage, you should have a program to play with before the next draw.

 

[mirage]

I've just been working on the updater, and although i could finish it tonight, i likely won't till tomorrow. I just tested it by updating the latest 649 draw, and I'm adding in the code for on/49 and lottario. you can update all 3 from the same screen.. currently after updating you'll hafta close the whole program and restart it to be able to use the new draw info.. I may change that before tomorrow's release date, but who knows, maybe I won't

I'm adding in a couple of neat features, like automatically entering dates for you (of course you can change them) and I'll try to add some simple error trapping..

in any case Mirage, you should have a program to play with before the next draw.

[color=royal blue]Wow! More news from Snides! - I guess this means you are feeling much better! That's great to hear! So the new ENT specialist is working out OK?
And great news about the program as well! I/(we?) had come to think that wouldn't be hearing more from you for quite a while. Hope your working strategies go as easily as you envision - - - (with crossed fingers).[/color]