automatic scoring and compair schedules

Jerk24

Board Regular
Joined
Oct 10, 2012
Messages
190
Good moring.

I have a sheet were i keep track of a 12 team dart leauge that spans 18 Wks. i have been here before, and had a ton of help.

starting in C3:k3, and C5:K5 is were the first shooters scores. then below that it is C7:k7, and c9:k9 and all the way down to C193:K193

in each weeks score there are three games. 12+6+30 i was hoping there is a way to take each teams score (column B has the shooters team 1, 1.2, 1.3, 1.4 for order purposes) and have the scores totalled by game

YOURS
Gm. 1
Gm. 2
Gm. 3
Total

<tbody>
</tbody>
then compare to the team they shot that week. not sure the easiest place to pull the schedule from. I have a schedule but it is not defined by week, I can place that weeks schedule in a particular set of cells,

After the compairson - i want the results moved to the standing sheet and add the win lose tie or total to what is already there. i know there is alot going on here and i am sure that i missed something.

TEAM #
Team Avg. w/o Hdcp.
High Team Average
Win
Loss
Tie Game
Total
Tie Total
PTS
HI GM
HI TRP
Team Handicap
Point Values
2
1
1
0.5
Team 2
74
21
9
8
50.00
97
259
2
Team 9
73
19
11
5
43.00
93
262
3
Team 4
66
18
12
6
42.00
97
286
9
Team 7
69
15
14
1
6
37.00
95
260
7
Team 3
74
14
14
2
6
36.00
102
266
2
Team 5
55
14
15
1
5
34.00
90
264
19
Team 11
68
14
14
2
4
34.00
96
253
8
Team 8
76
14
14
2
3
33.00
93
257
Team 6
70
13
17
4
30.00
93
253
6
Team 10
66
13
17
3
29.00
99
273
9
Team 12
77
11
18
1
6
29.00
92
255
Team 1
64
10
19
1
4
25.00
92
262
11

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Jerk24

Board Regular
Joined
Oct 10, 2012
Messages
190
Is there a way to compare two cells, based on a table . I have the totals of each game shot now i want to match the teams who shot agaist each other, give the winner a +1 in the winner column, and the loser the +1 in the loses column.

The chart below ranges from AD1:AP4

Team 1</SPAN>Team 2</SPAN>Team 3</SPAN>Team 4</SPAN>Team 5</SPAN>Team 6</SPAN>Team 7</SPAN>Team 8</SPAN>Team 9</SPAN>Team 10</SPAN>Team 11</SPAN>Team 12</SPAN>
Game 1</SPAN>68</SPAN>71</SPAN>70</SPAN>77</SPAN>61</SPAN>68</SPAN>71</SPAN>79</SPAN>75</SPAN>81</SPAN>61</SPAN>71</SPAN>
Game 2</SPAN>62</SPAN>72</SPAN>72</SPAN>85</SPAN>55</SPAN>70</SPAN>70</SPAN>76</SPAN>65</SPAN>77</SPAN>70</SPAN>82</SPAN>
Game 3</SPAN>73</SPAN>94</SPAN>79</SPAN>91</SPAN>58</SPAN>71</SPAN>76</SPAN>70</SPAN>76</SPAN>85</SPAN>68</SPAN>74</SPAN>
Total</SPAN>203</SPAN>237</SPAN>221</SPAN>253174</SPAN>209</SPAN>217</SPAN>225</SPAN>216</SPAN>243</SPAN>199</SPAN>227</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL><COL span=3><COL><COL span=7></COLGROUP>
the next chart is the schedule that will be updated weekly. that is in AE25:AH31
1/7/2014</SPAN>
12</SPAN>vs</SPAN>10</SPAN>BOARD 1</SPAN>
1</SPAN>vs</SPAN>7</SPAN>BOARD 2</SPAN>
8</SPAN>vs</SPAN>9</SPAN>BOARD 3</SPAN>
4</SPAN>vs</SPAN>2</SPAN>BOARD 4</SPAN>
3</SPAN>vs</SPAN>11</SPAN>BOARD 5</SPAN>
5</SPAN>vs</SPAN>6</SPAN>BOARD 6</SPAN>

<TBODY>
</TBODY><COLGROUP><COL><COL span=3></COLGROUP>


The date cell is merged to fit across the whole table.

please let me know if there is anymore information needed.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,582
Messages
5,625,621
Members
416,124
Latest member
DeMoNloK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top