WI v PAK Test FL

All competitions - pit your wits against the rest :)

Re: WI v PAK Test FL

Postby meninblue » Wed May 10, 2017 2:59 pm

rich1uk wrote:
Adi wrote:
I am asking because i copy paste which is stupid work actually as i think excel offers lot more features and this time wasting manual work can be avoided. But i dont know the method of avoiding those missing players when i enter individual player scores.

What i want to do in my next FL is that i enter batting, fielding , bowling scores and using total formula to calculate total points. Once the player totals are ready, i will mark Not playing or fill color in cell against players who are not playing. The formula should be such that the excel sheet misses out the player marked not playing or colored cell and adds player scores against the remaining 5 players automatically. Then it becomes lot simpler.

Think excel must be capable of this as the requirement is basic and excel is much more advanced.


what i do is copy and paste the formula for the player's total from the match table into the FL team, so for players that are inactive there is nothing to copy over and just gets registered as a zero, it probably means a bit more copy and pasting than it could but once its done after the teams are confirmed everything else happens automatically

google docs is a bit more limited than excel, if i was using excel i think i could make it a bit slicker

if this was something i was doing all the time i would set something up in a database programme like Access but thats a bit of overkill for FLs with 10-20 people playing



:thumb
Test FL's - 8 , ODI and Tests Combo FL's - 1, ODI World Cup - 1, ODI FL's - 7, ODI and T20i combo FL's - 1 ,
T20 Franchisee FL's - 7, T20i Cup FL's- 1, T20 FL's- 5 , 50 Overs Domestic FL's - 1, 40 Overs Domestic FL's- 1
User avatar
meninblue
 
Posts: 25045
Joined: Tue Nov 24, 2009 10:36 am

Re: WI v PAK Test FL

Postby hopeforthebest » Wed May 10, 2017 3:02 pm

Incidentally I have no plans to take over this FL.
Work expands to fill the time available, so why do today what can be put off until tomorrow.


2017 West Indies v Pakistan ODI FL Guru
2016 Bangladesh v England Combined FL Guru
2016 India v New Zealand ODI FL Guru
2015 India v South Africa ODI FL guru.
2013 Ashes fantasy prediction guru
2013 NZ in England combined FL guru.
hopeforthebest
 
Posts: 15058
Joined: Thu Jun 02, 2011 12:50 pm
Location: The Netherlands
Team(s) Supported: Warwickshire and England

Re: WI v PAK Test FL

Postby rich1uk » Wed May 10, 2017 3:02 pm

hopeforthebest wrote:
Arthur Crabtree wrote:Rich posts the table on the site. Surely that's good enough?

Not that anyone asked me.


Knowing what the players individual scores are give a better chance to check errors which occasionally arise and if the info is easy to post why not post it. DFM has multiple FL's running at the same time and he has no problem with it.


you can see what the individual player scores are and how the total score is arrived at on an innings by innings basis if you bothered to look

i look forward to your comprehensive scoring from now on tho
"I know words, i have the best words" - Donald J Trump

2012 SA vs SL ODIs prediction guru 2012 Movie Cup
2012 CB series guru
2012 Music Cup
2012 WI vs Oz Tests prediction guru
rich1uk
 
Posts: 22062
Joined: Mon Jan 24, 2011 1:03 pm

Re: WI v PAK Test FL

Postby rich1uk » Wed May 10, 2017 3:03 pm

hopeforthebest wrote:Incidentally I have no plans to take over this FL.


i guess its cancelled then as i deleted the spreadsheet

apologies folks
"I know words, i have the best words" - Donald J Trump

2012 SA vs SL ODIs prediction guru 2012 Movie Cup
2012 CB series guru
2012 Music Cup
2012 WI vs Oz Tests prediction guru
rich1uk
 
Posts: 22062
Joined: Mon Jan 24, 2011 1:03 pm

Re: WI v PAK Test FL

Postby andy » Wed May 10, 2017 3:13 pm

hopeforthebest wrote:Incidentally I have no plans to take over this FL.



well then pipe down and rein your neck in!! We volunteer to do FL's because it's fun, not so people like you can critcise because they have nothing else to do!

Its a shame this has happened Rich, you always do a great job with FL'S, shame always one person has to ruin it for everyone
2012 - ENG vs SA ODI series winner
2013 - US Open golf winner, WI vs PAK winner , ENG vs OZ ODI and T20 winner
2015- Open golf championship winner
2017 - OZ vs Pak odi'S, AUS vs NZ ODI, NZ vs SA Tests , WI vs PAK tests
2018 - NZ vs Pak t20 FL winner2018 - SA vs Ind test match fl winner US open golf FL [color=#0000FF] - [color=#FF0000]Open golf FL winner



Essex CCC county champions
andy
 
Posts: 19210
Joined: Thu Oct 06, 2011 2:25 pm
Location: Essex
Team(s) Supported: Essex CCC
West ham united
Sunrisers Hyderberad
England

Re: WI v PAK Test FL

Postby hopeforthebest » Wed May 10, 2017 3:17 pm

andy wrote:
hopeforthebest wrote:Incidentally I have no plans to take over this FL.



well then pipe down and rein your neck in!! We volunteer to do FL's because it's fun, not so people like you can critcise because they have nothing else to do!

Its a shame this has happened Rich, you always do a great job with FL'S, shame always one person has to ruin it for everyone


I made simple request and rich reacted badly so don't blame me. If rich hasn't emptied his recycle bin the spreadsheet is still available.
Work expands to fill the time available, so why do today what can be put off until tomorrow.


2017 West Indies v Pakistan ODI FL Guru
2016 Bangladesh v England Combined FL Guru
2016 India v New Zealand ODI FL Guru
2015 India v South Africa ODI FL guru.
2013 Ashes fantasy prediction guru
2013 NZ in England combined FL guru.
hopeforthebest
 
Posts: 15058
Joined: Thu Jun 02, 2011 12:50 pm
Location: The Netherlands
Team(s) Supported: Warwickshire and England

Re: WI v PAK Test FL

Postby andy » Wed May 10, 2017 3:18 pm

there's no need for it though, no one else has issue with way its done except you..so if you think you can do it better, than do it
2012 - ENG vs SA ODI series winner
2013 - US Open golf winner, WI vs PAK winner , ENG vs OZ ODI and T20 winner
2015- Open golf championship winner
2017 - OZ vs Pak odi'S, AUS vs NZ ODI, NZ vs SA Tests , WI vs PAK tests
2018 - NZ vs Pak t20 FL winner2018 - SA vs Ind test match fl winner US open golf FL [color=#0000FF] - [color=#FF0000]Open golf FL winner



Essex CCC county champions
andy
 
Posts: 19210
Joined: Thu Oct 06, 2011 2:25 pm
Location: Essex
Team(s) Supported: Essex CCC
West ham united
Sunrisers Hyderberad
England

Re: WI v PAK Test FL

Postby rich1uk » Wed May 10, 2017 3:19 pm

hopeforthebest wrote:
andy wrote:
hopeforthebest wrote:Incidentally I have no plans to take over this FL.



well then pipe down and rein your neck in!! We volunteer to do FL's because it's fun, not so people like you can critcise because they have nothing else to do!

Its a shame this has happened Rich, you always do a great job with FL'S, shame always one person has to ruin it for everyone


I made simple request and rich reacted badly so don't blame me. If rich hasn't emptied his recycle bin the spreadsheet is still available.


and i explained that the information you were asking for was all there in black and white, and in far more detail than a simple copy and paste would be but you were either too stubborn or too stupid to work out where it was
"I know words, i have the best words" - Donald J Trump

2012 SA vs SL ODIs prediction guru 2012 Movie Cup
2012 CB series guru
2012 Music Cup
2012 WI vs Oz Tests prediction guru
rich1uk
 
Posts: 22062
Joined: Mon Jan 24, 2011 1:03 pm

Re: WI v PAK Test FL

Postby hopeforthebest » Wed May 10, 2017 3:20 pm

hopeforthebest wrote:Rich could you please publish individual player scores fore each game as I find your spreadsheet impossible to understand.


That is hardly an insulting request is it?????
Work expands to fill the time available, so why do today what can be put off until tomorrow.


2017 West Indies v Pakistan ODI FL Guru
2016 Bangladesh v England Combined FL Guru
2016 India v New Zealand ODI FL Guru
2015 India v South Africa ODI FL guru.
2013 Ashes fantasy prediction guru
2013 NZ in England combined FL guru.
hopeforthebest
 
Posts: 15058
Joined: Thu Jun 02, 2011 12:50 pm
Location: The Netherlands
Team(s) Supported: Warwickshire and England

Re: WI v PAK Test FL

Postby hopeforthebest » Wed May 10, 2017 3:28 pm

Well now I'm the villain of this stupid exercise I'm quitting and you'll have no from me.
Work expands to fill the time available, so why do today what can be put off until tomorrow.


2017 West Indies v Pakistan ODI FL Guru
2016 Bangladesh v England Combined FL Guru
2016 India v New Zealand ODI FL Guru
2015 India v South Africa ODI FL guru.
2013 Ashes fantasy prediction guru
2013 NZ in England combined FL guru.
hopeforthebest
 
Posts: 15058
Joined: Thu Jun 02, 2011 12:50 pm
Location: The Netherlands
Team(s) Supported: Warwickshire and England

Re: WI v PAK Test FL

Postby rich1uk » Wed May 10, 2017 3:30 pm

hopeforthebest wrote:
hopeforthebest wrote:Rich could you please publish individual player scores fore each game as I find your spreadsheet impossible to understand.


That is hardly an insulting request is it?????


and i tried to help you to find the information you were looking for, information that i repeat was there in detail on an innings by innings basis, and all i got was a demand that i do it the way you wanted me to
"I know words, i have the best words" - Donald J Trump

2012 SA vs SL ODIs prediction guru 2012 Movie Cup
2012 CB series guru
2012 Music Cup
2012 WI vs Oz Tests prediction guru
rich1uk
 
Posts: 22062
Joined: Mon Jan 24, 2011 1:03 pm

Re: WI v PAK Test FL

Postby Arthur Crabtree » Wed May 10, 2017 3:46 pm

I'll finish it off.

In a spirit of peace and rapprochement!
I always say that everybody's right.
User avatar
Arthur Crabtree
 
Posts: 80417
Joined: Tue May 31, 2011 12:52 pm
Location: Nottingham
Team(s) Supported: Yorkshire.

Re: WI v PAK Test FL

Postby andy » Wed May 10, 2017 3:59 pm

well done Arthur, and thank you. Hope you have made an issue out of something becausee you are too stubborn or clueless, leave it up to you to decide which, to check something for yourself, Rich i hope you re-consider quitting doing FL's, because you do run them well
2012 - ENG vs SA ODI series winner
2013 - US Open golf winner, WI vs PAK winner , ENG vs OZ ODI and T20 winner
2015- Open golf championship winner
2017 - OZ vs Pak odi'S, AUS vs NZ ODI, NZ vs SA Tests , WI vs PAK tests
2018 - NZ vs Pak t20 FL winner2018 - SA vs Ind test match fl winner US open golf FL [color=#0000FF] - [color=#FF0000]Open golf FL winner



Essex CCC county champions
andy
 
Posts: 19210
Joined: Thu Oct 06, 2011 2:25 pm
Location: Essex
Team(s) Supported: Essex CCC
West ham united
Sunrisers Hyderberad
England

Re: WI v PAK Test FL

Postby rich1uk » Wed May 10, 2017 4:04 pm

andy wrote:well done Arthur, and thank you. Hope you have made an issue out of something becausee you are too stubborn or clueless, leave it up to you to decide which, to check something for yourself, Rich i hope you re-consider quitting doing FL's, because you do run them well


not sure if its a combination of toothache, lack of sleep and me being a generally grumpy b@stard at the best of times but just had enough today
"I know words, i have the best words" - Donald J Trump

2012 SA vs SL ODIs prediction guru 2012 Movie Cup
2012 CB series guru
2012 Music Cup
2012 WI vs Oz Tests prediction guru
rich1uk
 
Posts: 22062
Joined: Mon Jan 24, 2011 1:03 pm

Re: WI v PAK Test FL

Postby andy » Wed May 10, 2017 4:06 pm

i know what you mean trust me, but there was no need for hope to have moaned, therefore think anyone would be pissed off tbh
2012 - ENG vs SA ODI series winner
2013 - US Open golf winner, WI vs PAK winner , ENG vs OZ ODI and T20 winner
2015- Open golf championship winner
2017 - OZ vs Pak odi'S, AUS vs NZ ODI, NZ vs SA Tests , WI vs PAK tests
2018 - NZ vs Pak t20 FL winner2018 - SA vs Ind test match fl winner US open golf FL [color=#0000FF] - [color=#FF0000]Open golf FL winner



Essex CCC county champions
andy
 
Posts: 19210
Joined: Thu Oct 06, 2011 2:25 pm
Location: Essex
Team(s) Supported: Essex CCC
West ham united
Sunrisers Hyderberad
England

PreviousNext

Return to The Games Room

Who is online

Users browsing this forum: No registered users and 15 guests