Results Rnd 1

Page 1 of 2 1, 2  Next

Go down

Results Rnd 1 Empty Results Rnd 1

Post by croz on Fri Mar 25, 2011 9:45 am

Click HERE for Results Rnd 1

WOLVES 270 lost to BANGERS 389

TIGERS 372 defeated RAPTORS 340

HEROES 304 lost to MUSTANGS 305

WARTHOGS 292 lost to MAULERS 394

RIDGEBACKS 360 lost to GLADIATORS 370

TERRIERS 386 lost to VIPERS 403








Last edited by croz on Mon Mar 28, 2011 12:54 am; edited 8 times in total

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Fri Mar 25, 2011 9:48 am

Not sure why some of the borders disappear from the cells?

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Megabonus on Fri Mar 25, 2011 10:03 am

great work fellas...........................................

i salute you!!!!!!!!!!!!
avatar
Megabonus
Coach
Coach

Number of posts : 2094
Age : 49
Team Name : Raptors
Captain : Dustin 'Jet' Martin

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Macca on Fri Mar 25, 2011 10:05 am

Evan...why would we trust anything you say Mr "I will play Swan in possies" Pezos?

Macca
Macca
Coach
Coach

Number of posts : 4842
Age : 48
Team Name : Ridgebacks FC
Captain : Ollie Wines

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by gerry on Fri Mar 25, 2011 11:19 am

The results are all Croz's work.
I can't believe that you are now updating it after every game!
Is this done online or in Excel first then uploaded?

_________________
Premiers 2006, 2010, 2011
Never been second.
_____________________________
gerry
gerry
Admin

Number of posts : 3469
Age : 62
Team Name : Terriers
Captain : Scott Pendlebury

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Fri Mar 25, 2011 11:27 am

Excel then uploaded. I spent a bit of time today looking into getting a feed frm the footywire results page.

Bloody Footy Tips!!!!!!!!!! Mad

Bloody Dream Team!!!!! I had Selwood as Vice Captain.

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Fri Mar 25, 2011 11:32 am

Now updated with Friday night scores

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Fri Mar 25, 2011 11:38 am

Hey, Gerry...on my spreadsheets I have also changed it so that I no longer have to have to the 2 highest scoring All Stars in the top 2 positions on the results sheet.

I changed it so that there is a cell (hidden) that calculates the lowest score out of the 3 All Stars and then minuses that score from the Grand Total. Therefore, it will always count only the 2 highest scoring All Stars. Make sense? Not sure why I didnt do that earlier?

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Megabonus on Fri Mar 25, 2011 11:54 am

by Macca Today at 7:05 pm

.Evan...why would we trust anything you say Mr "I will play Swan in possies" Pezos

i didnt say i would do it in game 1....i will do it though and gezza will have to shave his head!!!!!!!!!!!!!!!!!
avatar
Megabonus
Coach
Coach

Number of posts : 2094
Age : 49
Team Name : Raptors
Captain : Dustin 'Jet' Martin

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by gerry on Fri Mar 25, 2011 10:33 pm

Megabonus wrote:
by Macca Today at 7:05 pm

.Evan...why would we trust anything you say Mr "I will play Swan in possies" Pezos

i didnt say i would do it in game 1....i will do it though and gezza will have to shave his head!!!!!!!!!!!!!!!!!

No problem. I think my wig is pretty safe.

_________________
Premiers 2006, 2010, 2011
Never been second.
_____________________________
gerry
gerry
Admin

Number of posts : 3469
Age : 62
Team Name : Terriers
Captain : Scott Pendlebury

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by gerry on Fri Mar 25, 2011 10:34 pm

croz wrote:Hey, Gerry...on my spreadsheets I have also changed it so that I no longer have to have to the 2 highest scoring All Stars in the top 2 positions on the results sheet.

I changed it so that there is a cell (hidden) that calculates the lowest score out of the 3 All Stars and then minuses that score from the Grand Total. Therefore, it will always count only the 2 highest scoring All Stars. Make sense? Not sure why I didnt do that earlier?

I think I get it. I have revamped my game calculator and did the same thing.
Now to come up with some way of calculating the top three all star scores in a game!

_________________
Premiers 2006, 2010, 2011
Never been second.
_____________________________
gerry
gerry
Admin

Number of posts : 3469
Age : 62
Team Name : Terriers
Captain : Scott Pendlebury

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Fri Mar 25, 2011 10:49 pm

I will send you a copy of my spreadsheet and you can see what Ive done...

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Megabonus on Fri Mar 25, 2011 11:53 pm

mmmmmmm...why is goodes in ruck as well as all star???????
avatar
Megabonus
Coach
Coach

Number of posts : 2094
Age : 49
Team Name : Raptors
Captain : Dustin 'Jet' Martin

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Sat Mar 26, 2011 1:42 am

sorry, an incorrect cell reference on my behalf. Now fixed.

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Jason on Sat Mar 26, 2011 1:57 am

As always guys great work. I love the fact you can keep tabs on the scores as the weekend progresses.

One observation though, the last tab that's titled team stats 01 is wrong with its calculation for AS. I am down for a score of 165, where it should be 189. It looks like its only adding up the first 2 AS scores. I dont know what you use that sheet for, but I thought I would point it out anyway.

_________________
2014 Premiers
2014 One Heart Medalist - S. Selwood
Jason
Jason
Admin

Number of posts : 2762
Age : 44
Team Name : Vipers
Captain : Scott Selwood

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by gerry on Sat Mar 26, 2011 4:23 am

Jason wrote:As always guys great work. I love the fact you can keep tabs on the scores as the weekend progresses.

One observation though, the last tab that's titled team stats 01 is wrong with its calculation for AS. I am down for a score of 165, where it should be 189. It looks like its only adding up the first 2 AS scores. I dont know what you use that sheet for, but I thought I would point it out anyway.

165 not enough for you, Jase?
You really are trying to give me a rogering this weekend, aren't you! Crying or Very sad

_________________
Premiers 2006, 2010, 2011
Never been second.
_____________________________
gerry
gerry
Admin

Number of posts : 3469
Age : 62
Team Name : Terriers
Captain : Scott Pendlebury

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Jason on Sat Mar 26, 2011 4:52 am

Our game is far from over Gerry, so i'll take all the points I can!

_________________
2014 Premiers
2014 One Heart Medalist - S. Selwood
Jason
Jason
Admin

Number of posts : 2762
Age : 44
Team Name : Vipers
Captain : Scott Selwood

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Macca on Sat Mar 26, 2011 9:14 am

Jason wrote:Our game is far from over Gerry, so i'll take all the points I can!

I love it when you play the 'far from over' card Jase. silent
Macca
Macca
Coach
Coach

Number of posts : 4842
Age : 48
Team Name : Ridgebacks FC
Captain : Ollie Wines

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Jason on Sat Mar 26, 2011 9:32 am

I cant help it when its true. I may have scored 189 AS points but the advantage I had in this game was negated when Gerry's AS's scored 172 points.


_________________
2014 Premiers
2014 One Heart Medalist - S. Selwood
Jason
Jason
Admin

Number of posts : 2762
Age : 44
Team Name : Vipers
Captain : Scott Selwood

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by gerry on Sat Mar 26, 2011 10:04 am

Jason wrote:I cant help it when its true. I may have scored 189 AS points but the advantage I had in this game was negated when Gerry's AS's scored 172 points.


Yep. I'm hoping for 6 from Banfield who is doing so well at the moment that he has scored -1 Dreamteam points.

_________________
Premiers 2006, 2010, 2011
Never been second.
_____________________________
gerry
gerry
Admin

Number of posts : 3469
Age : 62
Team Name : Terriers
Captain : Scott Pendlebury

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Sat Mar 26, 2011 10:51 am

Thanks, Jase...yes I made a change to the way the results sheet adds up all stars and I forgot to make a change to that sheet. That is the sheet that links to my stats categories sheet. Thanks

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Sat Mar 26, 2011 11:45 pm

Gerry (and others):

Change James Bartel to Jimmy Bartel
Change Robert Gray to Robbie Gray

WTF was I thinking trying to do a reverse slider in AS (difficulty rating 9.2)? Dumb arse.

Jase: Thanks for your above note - has now been rectified. Let me know if you see anything else.

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Jason on Sun Mar 27, 2011 2:26 am

croz wrote:Jase: Thanks for your above note - has now been rectified. Let me know if you see anything else.

No probs Croz, I wouldnt have picked it up if Gerrys AS total wasnt higher than mine. Gave me a heart attack when I saw that!

gerry wrote:
Jason wrote:I cant help it when its true. I may have scored 189 AS points but the advantage I had in this game was negated when Gerry's AS's scored 172 points.


Yep. I'm hoping for 6 from Banfield who is doing so well at the moment that he has scored -1 Dreamteam points.

Gerry, our game is incredibly close. With the players yet to play, based on their 2010 avg's our final score will be 404 to 405. If thats anything close to the way it pans out whoever loses will be hard done by.


_________________
2014 Premiers
2014 One Heart Medalist - S. Selwood
Jason
Jason
Admin

Number of posts : 2762
Age : 44
Team Name : Vipers
Captain : Scott Selwood

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Sun Mar 27, 2011 2:45 am

On another game, it is possible that the Tigers may smash the possessions record!

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by trucker on Sun Mar 27, 2011 3:30 am

no as peake goes in as gilbee did not play and he only got 11

peake would have got more if he wasnt the fucking sub
trucker
trucker
Captain
Captain

Number of posts : 685
Age : 42
Team Name : truckers
Captain : Sam Mitchell / Nicholas Natanui

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Sun Mar 27, 2011 5:16 am

Uh oh...Bad Sunday imminent.

About to go from unloseable to loseable.

Damn you Nathan Djerrkkkkuuurrrraaaa!

Damn you Hanneberrrrry!

Damn you Bob Murphhhhhyyyyy!


_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by gerry on Sun Mar 27, 2011 8:08 am

Jason wrote:
croz wrote:Jase: Thanks for your above note - has now been rectified. Let me know if you see anything else.

No probs Croz, I wouldnt have picked it up if Gerrys AS total wasnt higher than mine. Gave me a heart attack when I saw that!

gerry wrote:
Jason wrote:I cant help it when its true. I may have scored 189 AS points but the advantage I had in this game was negated when Gerry's AS's scored 172 points.


Yep. I'm hoping for 6 from Banfield who is doing so well at the moment that he has scored -1 Dreamteam points.

Gerry, our game is incredibly close. With the players yet to play, based on their 2010 avg's our final score will be 404 to 405. If thats anything close to the way it pans out whoever loses will be hard done by.


I think, once again, you are in the box seat.
It is a bit frustrating that the last game doesn't start until 6.40 Adelaide time.
It's enough to give you indigestion...

_________________
Premiers 2006, 2010, 2011
Never been second.
_____________________________
gerry
gerry
Admin

Number of posts : 3469
Age : 62
Team Name : Terriers
Captain : Scott Pendlebury

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Macca on Sun Mar 27, 2011 8:30 am

Croz, you cant lose...wtf are you talking about boy?
Were even with Cox and McKinley v Kennedy
Macca
Macca
Coach
Coach

Number of posts : 4842
Age : 48
Team Name : Ridgebacks FC
Captain : Ollie Wines

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by croz on Sun Mar 27, 2011 11:52 am

I see that know, but if McKinley kicks nothing (looks like he'll end up with 1 point) then it is Cox v Kennedy.

Kennedy started with 4 marks in the 1st quarter, however Cox has done well.

_________________
Premiers 2003 & 2009
croz
croz
Admin

Number of posts : 2232
Age : 44
Team Name : Gladiators
Captain : Gary Ablett

http://www.arc.acnrep.com

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Macca on Sun Mar 27, 2011 11:53 am

Cox is back to form!
Macca
Macca
Coach
Coach

Number of posts : 4842
Age : 48
Team Name : Ridgebacks FC
Captain : Ollie Wines

Back to top Go down

Results Rnd 1 Empty Re: Results Rnd 1

Post by Sponsored content


Sponsored content


Back to top Go down

Page 1 of 2 1, 2  Next

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum