Has anyone out there created an excel dart league template?

T

top.jimmy

I've created a 15 week dart league workbook and want to be able to track up
to eight teams playing each week. There are four data/score sheets in each
worksheet for each week. (i.e 2 teams playing against eachother in each
scoresheet)The problem I'm having is getting the 4th score sheet to post to
my master stats worksheet due to "Formula too long." I basically index/match
each worksheet for a specific player...Here's the formula for one player...

$C$305 =player's name, 'Mstr Stats'!$D307=the stat to look for
'WK 1'!$A$32:$W$56=the tabulated scores of the first two team's game
'WK 1'!$B$32:$B$55=the player name match
'WK 1'!$A$32:$W$32=the stat match(i.e. Ton 80's) and so on...to the
second,third or fourth game (but I can't enter the fourth table due to
"formula too long error"

=IF(ISERROR(INDEX('WK 1'!$A$32:$W$56,MATCH($C$305,'WK
1'!$B$32:$B$55,0),MATCH('Mstr Stats'!$D307,'WK
1'!$A$32:$W$32,0))),0,(INDEX('WK 1'!$A$32:$W$56,MATCH($C$305,'WK
1'!$B$32:$B$55,0),MATCH('Mstr Stats'!$D307,'WK
1'!$A$32:$W$32,0))))+IF(ISERROR(INDEX('WK 1'!$Z$32:$AU$56,MATCH($C$305,'WK
1'!$Z$32:$Z$55,0),MATCH('Mstr Stats'!$D307,'WK
1'!$Z$32:$AU$32,0))),0,(INDEX('WK 1'!$Z$32:$AU$56,MATCH($C$305,'WK
1'!$Z$32:$Z$55,0),MATCH('Mstr Stats'!$D307,'WK
1'!$Z$32:$AU$32,0))))+IF(ISERROR(INDEX('WK 1'!$B$89:$W$111,MATCH($C$305,'WK
1'!$B$89:$B$111,0),MATCH('Mstr Stats'!$D307,'WK
1'!$B$89:$V$89,0))),0,(INDEX('WK 1'!$B$89:$W$111,MATCH($C$305,'WK
1'!$B$89:$B$111,0),MATCH('Mstr Stats'!$D307,'WK 1'!$B$89:$V$89,0))))

Any suggestions??? Could I 'Name' each table formula to consolidate the
formula and give more space for the fourth team game. I've gotten this far,
and I know there's a solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top