automatic scoring and compair schedules

[Jerk24]

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

[TABLE="width: 224"]
<tbody>[TR]
[TD][/TD]
[TD]YOURS
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gm. 1
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gm. 2
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gm. 3
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
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.

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

 

[Jerk24]

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

[TABLE="width: 836"]
<TBODY>[TR]
[TD][/TD]
[TD]Team 1</SPAN>[/TD]
[TD]Team 2</SPAN>[/TD]
[TD]Team 3</SPAN>[/TD]
[TD]Team 4</SPAN>[/TD]
[TD]Team 5</SPAN>[/TD]
[TD]Team 6</SPAN>[/TD]
[TD]Team 7</SPAN>[/TD]
[TD]Team 8</SPAN>[/TD]
[TD]Team 9</SPAN>[/TD]
[TD]Team 10</SPAN>[/TD]
[TD]Team 11</SPAN>[/TD]
[TD]Team 12</SPAN>[/TD]
[/TR]
[TR]
[TD]Game 1</SPAN>[/TD]
[TD="align: right"]68</SPAN>[/TD]
[TD="align: right"]71</SPAN>[/TD]
[TD="align: right"]70</SPAN>[/TD]
[TD="align: right"]77</SPAN>[/TD]
[TD="align: right"]61</SPAN>[/TD]
[TD="align: right"]68</SPAN>[/TD]
[TD="align: right"]71</SPAN>[/TD]
[TD="align: right"]79</SPAN>[/TD]
[TD="align: right"]75</SPAN>[/TD]
[TD="align: right"]81</SPAN>[/TD]
[TD="align: right"]61</SPAN>[/TD]
[TD="align: right"]71</SPAN>[/TD]
[/TR]
[TR]
[TD]Game 2</SPAN>[/TD]
[TD="align: right"]62</SPAN>[/TD]
[TD="align: right"]72</SPAN>[/TD]
[TD="align: right"]72</SPAN>[/TD]
[TD="align: right"]85</SPAN>[/TD]
[TD="align: right"]55</SPAN>[/TD]
[TD="align: right"]70</SPAN>[/TD]
[TD="align: right"]70</SPAN>[/TD]
[TD="align: right"]76</SPAN>[/TD]
[TD="align: right"]65</SPAN>[/TD]
[TD="align: right"]77</SPAN>[/TD]
[TD="align: right"]70</SPAN>[/TD]
[TD="align: right"]82</SPAN>[/TD]
[/TR]
[TR]
[TD]Game 3</SPAN>[/TD]
[TD="align: right"]73</SPAN>[/TD]
[TD="align: right"]94</SPAN>[/TD]
[TD="align: right"]79</SPAN>[/TD]
[TD="align: right"]91</SPAN>[/TD]
[TD="align: right"]58</SPAN>[/TD]
[TD="align: right"]71</SPAN>[/TD]
[TD="align: right"]76</SPAN>[/TD]
[TD="align: right"]70</SPAN>[/TD]
[TD="align: right"]76</SPAN>[/TD]
[TD="align: right"]85</SPAN>[/TD]
[TD="align: right"]68</SPAN>[/TD]
[TD="align: right"]74</SPAN>[/TD]
[/TR]
[TR]
[TD]Total</SPAN>[/TD]
[TD="align: right"]203</SPAN>[/TD]
[TD="align: right"]237</SPAN>[/TD]
[TD="align: right"]221</SPAN>[/TD]
[TD="align: right"]253[/TD]
[TD="align: right"]174</SPAN>[/TD]
[TD="align: right"]209</SPAN>[/TD]
[TD="align: right"]217</SPAN>[/TD]
[TD="align: right"]225</SPAN>[/TD]
[TD="align: right"]216</SPAN>[/TD]
[TD="align: right"]243</SPAN>[/TD]
[TD="align: right"]199</SPAN>[/TD]
[TD="align: right"]227</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL><COL span=3><COL><COL span=7></COLGROUP>[/TABLE]
the next chart is the schedule that will be updated weekly. that is in AE25:AH31
[TABLE="width: 257"]
<TBODY>[TR]
[TD="colspan: 4"]1/7/2014</SPAN>[/TD]
[/TR]
[TR]
[TD]12</SPAN>[/TD]
[TD]vs</SPAN>[/TD]
[TD]10</SPAN>[/TD]
[TD]BOARD 1</SPAN>[/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD]vs</SPAN>[/TD]
[TD]7</SPAN>[/TD]
[TD]BOARD 2</SPAN>[/TD]
[/TR]
[TR]
[TD]8</SPAN>[/TD]
[TD]vs</SPAN>[/TD]
[TD]9</SPAN>[/TD]
[TD]BOARD 3</SPAN>[/TD]
[/TR]
[TR]
[TD]4</SPAN>[/TD]
[TD]vs</SPAN>[/TD]
[TD]2</SPAN>[/TD]
[TD]BOARD 4</SPAN>[/TD]
[/TR]
[TR]
[TD]3</SPAN>[/TD]
[TD]vs</SPAN>[/TD]
[TD]11</SPAN>[/TD]
[TD]BOARD 5</SPAN>[/TD]
[/TR]
[TR]
[TD]5</SPAN>[/TD]
[TD]vs</SPAN>[/TD]
[TD]6</SPAN>[/TD]
[TD]BOARD 6</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL span=3></COLGROUP>[/TABLE]


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

please let me know if there is anymore information needed.