OcUK Photo Comp - Season Five : Round Three - "Work" RESULTS
- Thread starter RichDay
- Start date
Deleted member 11679
Deleted member 11679
Well done people, good round this one 
yak.h'cir said:This months theme is.... "the view from your bedroom window"
Heh.
Since my post about suggesting that theme, I tried to think when I last took some pictures. Ignoring the photos I took at a wedding at the beginning of May (got paid for it), I think it was when I took the picture for this comp!
I think I will rent out my daughter for a weekend or two so I get a chance to!!
PaulStat said:yeah but that's just silly why would you take an average of 3 results when I only have 2
Because Excel won't let me do that without individually calculating all the averages
The problem with excel is really with the season totals. Because it's just a spreadsheet you have to transfer the scores across from the round totals manually inserting new people where necessary. It takes ages! There's 81 people in there so far and we're only on round three! It would take me forever to sort out the averages if I were do to it individually.
When I finally get round to writing some software to administer the results I'll be able to calculate the averages better and produce loads more stats for you guys. I might even be able to produce some funky charts! It'll be a lot quicker too.
RichDay said:Because Excel won't let me do that without individually calculating all the averages
You can do:
=(SUM(A1:C1))/(COUNT(A1:C1))
where A1:C1 is the range of scores for each round for one person. Then just fill down and it will do all of them
COUNT, counts the number of cells which aren't empty, so peoples averages will only be calculated on the rounds they have enterd
Unless that is you put a '0' in the cell....
Gregeff said:You can do:
=(SUM(A1:C1))/(COUNT(A1:C1))
where A1:C1 is the range of scores for each round for one person. Then just fill down and it will do all of them
COUNT, counts the number of cells which aren't empty, so peoples averages will only be calculated on the rounds they have enterd
eh??
English please
ATHRoss,
I have very spurious internet access at the mo, but I'll try the email route anyway. I have a couple of ideas for the next round. If we can't decide between us then perhaps we could googlefight the choices we come up with!
I have very spurious internet access at the mo, but I'll try the email route anyway. I have a couple of ideas for the next round. If we can't decide between us then perhaps we could googlefight the choices we come up with!
congrats to ATHRoss and danza, very well done and great shots they were too!!
quite pleased with my score, im steadily improving as each round goes by
18th overall as well so cant complain.
my shot wasnt taken specifically for the comp, just happened to catch it as i was at donnington on the last day of the comp and as i hadnt got anything else thought i would pop it in thankfully it turned out ok.
looking forward to the next round
quite pleased with my score, im steadily improving as each round goes by
18th overall as well so cant complain.
my shot wasnt taken specifically for the comp, just happened to catch it as i was at donnington on the last day of the comp and as i hadnt got anything else thought i would pop it in
thankfully it turned out ok.looking forward to the next round
Deleted member 11679
Deleted member 11679
antc said:congrats to ATHRoss and danza, very well done and great shots they were too!!
quite pleased with my score, im steadily improving as each round goes by
18th overall as well so cant complain.
my shot wasnt taken specifically for the comp, just happened to catch it as i was at donnington on the last day of the comp and as i hadnt got anything else thought i would pop it in
looking forward to the next round
Had you looked directly across the track after taking this shot you would have seen me and my white lens