Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » Excel sheet needed, can anyone help? » Post Reply

Who Can Post?

All users can post new topics and all users can reply.

Icon:

Formatting Mode:
Normal
Advanced
Help

Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On

Post Options:

Disable smileys?
Turn BBCode off?
Receive email notification of new replies?


Brett	posted on 17th Jun 12 at 23:39
	quote: Originally posted by Fro quote: Originally posted by Brett http://download.cnet.com/Lottery-Syndicate-Manager-Complete-LSMC/3000-2647_4-10203644.html Nice one Brett, going to have a play with that when I'm back to work and see what the functionality is like. Seems to do just about everything you'd need. Let us know how you get on :)
Gaz	posted on 17th Jun 12 at 11:23
	I wanted to set up a section where it could tell you the winnings but as the EURO's have a flexible (non-set) amount when you win it would have to be integrated into their website which I cannot build :-( It had so much potential... I've u2u'd Dan with my version so far anyway.
Fro	posted on 17th Jun 12 at 00:03
	quote: Originally posted by Brett http://download.cnet.com/Lottery-Syndicate-Manager-Complete-LSMC/3000-2647_4-10203644.html Nice one Brett, going to have a play with that when I'm back to work and see what the functionality is like.
pow	posted on 16th Jun 12 at 23:57
	Dan I can help, talk to me on Monday.
Matt L	posted on 16th Jun 12 at 16:45
	Ill give this a go in a bit if you still need it and arent using the link above?
Brett	posted on 16th Jun 12 at 15:51
	http://download.cnet.com/Lottery-Syndicate-Manager-Complete-LSMC/3000-2647_4-10203644.html
Baskey	posted on 16th Jun 12 at 15:36
	I'm not sure what your sheet looks like mate. Post a screen print of the spreadsheet and I will be able to give you a simple formular that will highlight when a ticket has a minimum of 3 of the numbers (so you don't have to manually go through) [Edited on 16-06-2012 by Baskey]
Dan	posted on 16th Jun 12 at 11:36
	If you could make something better like you suggest Gaz, id really appreciate it, i just dont have the skillzz needed nor time, hence not overly fussed about going any further myself
Dan	posted on 16th Jun 12 at 11:35
	Im happy with just looking through to be honest. It will be pretty obvious if theres a win etc.
Gaz	posted on 16th Jun 12 at 11:29
	quote: Originally posted by Dan Proper simple.... http://www.youtube.com/watch?v=kCt7BGKPoKs Conditional formatting, learn something new every day Conditional formatting will work as shown but you have an eliminate still of manually looking to see if someone won a tenner.... thats were formulating it will help you even more... you can take t a step further and have a summery box at the bottom which can tell you if money has been won(I.E, how many numbers on a line match) and then if you really wanted to, have a jackpot input box which calculates a rough winning amount in £.
Gaz	posted on 16th Jun 12 at 11:26
	you just need a fancy lookup if I remember rightly, can you host your document somewhere so we can download the peoples numbers and then have a go at it for you? (https://docs.google.com)
Dan	posted on 16th Jun 12 at 11:26
	Proper simple.... http://www.youtube.com/watch?v=kCt7BGKPoKs Conditional formatting, learn something new every day
Marc	posted on 16th Jun 12 at 11:15
	I reckon its doable if you list 1-49 at the side of everyones name and forulate it that way? I'm sure someone else will be along to tell me to shut up and have a real easy way of doing it!
Dan	posted on 16th Jun 12 at 11:13
	Really? I can do a find all if i control and F and it will list them all, but i really want it to make them stand out at same time so i can check winnings :/
Marc	posted on 16th Jun 12 at 11:08
	I know what you are saying, and I am by no means an expert on Excel. I'm not sure what you want is possible, as surely the forula needed for each candidates number would need a lot of code?
Dan	posted on 16th Jun 12 at 11:00
	As you have probably seen im running the euromillions syndicate, and i need to make my life easier. The numbers are drawn alot earlier than the national lottery site shows them. So i can see the numbers early on other sites. It just means checking them manually. I have a spreadsheet with everyones numbers in seperate coloums/rows. Is it possible to have 7 boxes where i can enter the numbers drawn, and it will highlight the numbers in all the lines? If anyone can knock me something up/show me how ill be very greatful :thumbs: