If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Summary of Data from a Range
I have a range of data, which is a weekly sports picking competition at work.
Basically on the left it has the event, and along the top it has my work colleagues names. The sports picks are in the range and are in the form of validation lists. What i would like to do is create an automated summary of who picked what at the close of each week, which i can email out to the guys in the competiton - i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f, g, h, i, j and m I have 8 events per week, with a number of options per event, thus it is not easy or quick to just manually do it! Any suggestions gratefully received! Cheers! |
#2
|
|||
|
|||
Hi!
I have a file that I use to run a weekly NFL pick 'em contest. It sounds just like what you have except I have the "events" (games) listed on the right and then another column with a drop down to enter the winner. The players names are listed across the top and in the column under each players name is another drop down that I use to enter that particular players picks for that week. I then calculate each players record and winning percentage for each week. I do this for each week then I post the results to a website. If you'd like a copy to see if you can use it for your situation post an email address and I'll contact you. Biff "Blobbies" wrote in message ... I have a range of data, which is a weekly sports picking competition at work. Basically on the left it has the event, and along the top it has my work colleagues names. The sports picks are in the range and are in the form of validation lists. What i would like to do is create an automated summary of who picked what at the close of each week, which i can email out to the guys in the competiton - i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f, g, h, i, j and m I have 8 events per week, with a number of options per event, thus it is not easy or quick to just manually do it! Any suggestions gratefully received! Cheers! |
#3
|
|||
|
|||
hi biff
sounds very similar - yes i would be interested in seeing how you've done it. i would also be interested in how you get the players picks in, and how you go about publishing them on a web site. those sorts of things are way beyond me!! my players email me a small spreadsheet with each weeks picks - but that is quite time intensive for me to prepare every week - same with the results, and i also post out everyone's weekly choices too, so they can see how they're getting on during the week! lots of time involved, but fun!! my email is: mike (at) cherries.co.nz thanks for your time to answer! eddie "Biff" wrote: Hi! I have a file that I use to run a weekly NFL pick 'em contest. It sounds just like what you have except I have the "events" (games) listed on the right and then another column with a drop down to enter the winner. The players names are listed across the top and in the column under each players name is another drop down that I use to enter that particular players picks for that week. I then calculate each players record and winning percentage for each week. I do this for each week then I post the results to a website. If you'd like a copy to see if you can use it for your situation post an email address and I'll contact you. Biff "Blobbies" wrote in message ... I have a range of data, which is a weekly sports picking competition at work. Basically on the left it has the event, and along the top it has my work colleagues names. The sports picks are in the range and are in the form of validation lists. What i would like to do is create an automated summary of who picked what at the close of each week, which i can email out to the guys in the competiton - i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f, g, h, i, j and m I have 8 events per week, with a number of options per event, thus it is not easy or quick to just manually do it! Any suggestions gratefully received! Cheers! |
#4
|
|||
|
|||
Biff, I would be interested in seeing your spreadsheet. I am trying to create
one for the guy here that runs it and I just can't think of a good way. Thanks "Biff" wrote: Hi! I have a file that I use to run a weekly NFL pick 'em contest. It sounds just like what you have except I have the "events" (games) listed on the right and then another column with a drop down to enter the winner. The players names are listed across the top and in the column under each players name is another drop down that I use to enter that particular players picks for that week. I then calculate each players record and winning percentage for each week. I do this for each week then I post the results to a website. If you'd like a copy to see if you can use it for your situation post an email address and I'll contact you. Biff "Blobbies" wrote in message ... I have a range of data, which is a weekly sports picking competition at work. Basically on the left it has the event, and along the top it has my work colleagues names. The sports picks are in the range and are in the form of validation lists. What i would like to do is create an automated summary of who picked what at the close of each week, which i can email out to the guys in the competiton - i.e: Event 1: New York Mets: persons a, b, c, d and l , Cleveland: e, f, g, h, i, j and m I have 8 events per week, with a number of options per event, thus it is not easy or quick to just manually do it! Any suggestions gratefully received! Cheers! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
named range, data validation: list non-selected items, and new added items | KR | General Discussion | 1 | June 24th, 2005 05:21 AM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
data range props | Steve M | General Discussion | 0 | April 11th, 2005 10:32 AM |
Data Range | Patrik Karlstrom | Worksheet Functions | 2 | September 27th, 2004 03:18 AM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |