Finding a value based on an effective date with multiple criteria

Yanta

Board Regular
Joined
Aug 28, 2011
Messages
54
I have a sheet with pay rates. There are about 80 different pay rates that differ for age, gender and competition type.

Rather than have a sheet with a rate for every day of the year for the past 12 years I'm wondering if there is a way to do this with effective dates.

So when I'm looking up a pay rate I will look at the age, gender and competition type for a team where the date of the game is >= the most recent pay rate change for those criteria.

Pay rates could change for any gender, age or competition type at any time. There is a regular rise March 1 each year, but adhoc changes also occur.

I have the date split into 3 columns (Year, Month, Day), thinking maybe that was the easiest way to do it. Maybe it's best to just use a single date field?

Would be grateful for some pointers.

Thanks

A small snippet...
Code:
[TABLE="width: 1247"]
<tbody>[TR]
[TD="colspan: 3"]Effective Date[/TD]
[TD][/TD]
[TD="colspan: 10"]Boys[/TD]
[TD="colspan: 10"]Girls[/TD]
[/TR]
[TR]
[TD]Year[/TD]
[TD]Mth[/TD]
[TD]Day[/TD]
[TD]Gr[/TD]
[TD]U9[/TD]
[TD]U10[/TD]
[TD]U11[/TD]
[TD]U12[/TD]
[TD]U13[/TD]
[TD]U14[/TD]
[TD]U15[/TD]
[TD]U16[/TD]
[TD]U18[/TD]
[TD]U21[/TD]
[TD]U9[/TD]
[TD]U10[/TD]
[TD]U11[/TD]
[TD]U12[/TD]
[TD]U13[/TD]
[TD]U14[/TD]
[TD]U15[/TD]
[TD]U16[/TD]
[TD]U18[/TD]
[TD]U21[/TD]
[/TR]
[TR]
[TD]2012[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]C[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $ 10.30[/TD]
[TD] $ 10.30[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $ 10.30[/TD]
[TD] $ 10.30[/TD]
[/TR]
[TR]
[TD]2013[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]B[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 12.90[/TD]
[TD] $ 12.90[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 12.90[/TD]
[TD] $ 12.90[/TD]
[/TR]
[TR]
[TD]2013[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]B[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 13.20[/TD]
[TD] $ 13.20[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 12.90[/TD]
[TD] $ 12.90[/TD]
[/TR]
[TR]
[TD]2014[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]B[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 13.50[/TD]
[TD] $ 13.50[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 13.50[/TD]
[TD] $ 13.50[/TD]
[/TR]
</tbody>[/TABLE]
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,730
Office Version
365
Platform
Windows
If I have understood correctly, then don't break up the dates into year/month/day just make sure that the dates are in ascending order.

See if this, copied down, does what you want. It does rely on the age groups for boys and girls being identical - which is the case with your sample.

<b>Lookup Rate</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:83px;" /><col style="width:33px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /><col style="width:51px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; ">Boys</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; ">Girls</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; ">Gr</td><td style="font-size:10pt; text-align:right; ">U9</td><td style="font-size:10pt; text-align:right; ">U10</td><td style="font-size:10pt; text-align:right; ">U11</td><td style="font-size:10pt; text-align:right; ">U12</td><td style="font-size:10pt; text-align:right; ">U13</td><td style="font-size:10pt; text-align:right; ">U14</td><td style="font-size:10pt; text-align:right; ">U15</td><td style="font-size:10pt; text-align:right; ">U16</td><td style="font-size:10pt; text-align:right; ">U18</td><td style="font-size:10pt; text-align:right; ">U21</td><td style="font-size:10pt; text-align:right; ">U9</td><td style="font-size:10pt; text-align:right; ">U10</td><td style="font-size:10pt; text-align:right; ">U11</td><td style="font-size:10pt; text-align:right; ">U12</td><td style="font-size:10pt; text-align:right; ">U13</td><td style="font-size:10pt; text-align:right; ">U14</td><td style="font-size:10pt; text-align:right; ">U15</td><td style="font-size:10pt; text-align:right; ">U16</td><td style="font-size:10pt; text-align:right; ">U18</td><td style="font-size:10pt; text-align:right; ">U21</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-size:10pt; text-align:right; ">1/06/2012</td><td style="font-size:10pt; ">C</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">10.30</td><td style="font-size:10pt; text-align:right; ">10.30</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; text-align:right; ">10.30</td><td style="font-size:10pt; text-align:right; ">10.30</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-size:10pt; text-align:right; ">1/01/2013</td><td style="font-size:10pt; ">B</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">12.90</td><td style="font-size:10pt; text-align:right; ">12.90</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; text-align:right; ">12.90</td><td style="font-size:10pt; text-align:right; ">12.90</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-size:10pt; text-align:right; ">1/03/2013</td><td style="font-size:10pt; ">B</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">13.20</td><td style="font-size:10pt; text-align:right; ">13.20</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">11.30</td><td style="font-size:10pt; text-align:right; ">12.90</td><td style="font-size:10pt; text-align:right; ">12.90</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-size:10pt; text-align:right; ">1/03/2014</td><td style="font-size:10pt; ">B</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">13.50</td><td style="font-size:10pt; text-align:right; ">13.50</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">11.60</td><td style="font-size:10pt; text-align:right; ">13.50</td><td style="font-size:10pt; text-align:right; ">13.50</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-size:10pt; text-align:right; ">25/02/2013</td><td style="font-size:10pt; ">B</td><td style="font-size:10pt; ">Boys</td><td style="font-size:10pt; ">U12</td><td style="font-size:10pt; text-align:right; ">11.00</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-size:10pt; text-align:right; ">25/02/2013</td><td style="font-size:10pt; ">C</td><td style="font-size:10pt; ">Girls</td><td style="font-size:10pt; ">U15</td><td style="font-size:10pt; text-align:right; ">9.70</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-size:10pt; text-align:right; ">1/11/2019</td><td style="font-size:10pt; ">B</td><td style="font-size:10pt; ">Boys</td><td style="font-size:10pt; ">U21</td><td style="font-size:10pt; text-align:right; ">13.50</td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td><td style="font-size:10pt; "> </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >E9</td><td >=INDEX($C$3:$V$6,AGGREGATE<span style=' color:008000; '>(14,6,<span style=' color:#0000ff; '>(ROW<span style=' color:#ff0000; '>(A$3:A$6)</span>-ROW<span style=' color:#ff0000; '>(A$3)</span>+1)</span>/<span style=' color:#0000ff; '>(<span style=' color:#ff0000; '>($B$3:$B$6=B9)</span>*<span style=' color:#ff0000; '>($A$3:$A$6<=A9)</span>)</span>,1)</span>,MATCH<span style=' color:008000; '>(C9,$C$1:$V$1,0)</span>+MATCH<span style=' color:008000; '>(D9,$C$2:$V$2,0)</span>-1)</td></tr></table></td></tr></table>
 
Last edited:

Yanta

Board Regular
Joined
Aug 28, 2011
Messages
54
Sorry, no the age groups for boys and girls are not identical. There are no U13 or U15 girls. Until April 2019 there were no U11 girls. From April 2019 there are no longer any U10 girls -it's been replaced by U11.

I've included them because "One day there 'could be' and U13/U15 girls"

And in my sample you will see that the rates for all U9 - U16 are the same. But they "could" be different. In October 2019 Girls U9 - U11 changed from $15.60 to $11.00 then to $12.50 a week later.

To make matters more complex I only pasted the "regular season" section (competition type). If the game type is SF, PF or GF then it's a final and different rates apply. If the game type is GR or RS then it's grading or regular season, which is the section I posted.

OMG - And yet another criteria - if the competition is After School, then the day of the week also comes into play. Currently they are all the same but the association has stated they could change in the future.

So, for completeness, this is the whole rows with the date in one column as per your advice.

The criteria used for evaluation is in a sheet called 'Payments'. This sheet is called 'Rates 2'

Code:
[TABLE="width: 2988"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 26"]Regular Season[/TD]
[TD="colspan: 26"]Finals[/TD]
[TD]Score[/TD]
[/TR]
[TR]
[TD]Effective Date[/TD]
[TD][/TD]
[TD="colspan: 10"]Boys[/TD]
[TD="colspan: 10"]Girls[/TD]
[TD="colspan: 4"]After School/Miniball[/TD]
[TD="colspan: 2"]Seniors[/TD]
[TD="colspan: 10"]Boys[/TD]
[TD="colspan: 10"]Girls[/TD]
[TD="colspan: 4"]After School[/TD]
[TD="colspan: 2"]Seniors[/TD]
[TD]Table[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Gr[/TD]
[TD]U9[/TD]
[TD]U10[/TD]
[TD]U11[/TD]
[TD]U12[/TD]
[TD]U13[/TD]
[TD]U14[/TD]
[TD]U15[/TD]
[TD]U16[/TD]
[TD]U18[/TD]
[TD]U21[/TD]
[TD]U9[/TD]
[TD]U10[/TD]
[TD]U11[/TD]
[TD]U12[/TD]
[TD]U13[/TD]
[TD]U14[/TD]
[TD]U15[/TD]
[TD]U16[/TD]
[TD]U18[/TD]
[TD]U21[/TD]
[TD]Mon[/TD]
[TD]Tues[/TD]
[TD]Thurs[/TD]
[TD]Fri[/TD]
[TD]Men[/TD]
[TD]Women[/TD]
[TD]U9[/TD]
[TD]U10[/TD]
[TD]U11[/TD]
[TD]U12[/TD]
[TD]U13[/TD]
[TD]U14[/TD]
[TD]U15[/TD]
[TD]U16[/TD]
[TD]U18[/TD]
[TD]U21[/TD]
[TD]U9[/TD]
[TD]U10[/TD]
[TD]U11[/TD]
[TD]U12[/TD]
[TD]U13[/TD]
[TD]U14[/TD]
[TD]U15[/TD]
[TD]U16[/TD]
[TD]U18[/TD]
[TD]U21[/TD]
[TD]Mon[/TD]
[TD]Tues[/TD]
[TD]Thurs[/TD]
[TD]Fri[/TD]
[TD]Men[/TD]
[TD]Women[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2012/06/01[/TD]
[TD]C[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $ 10.30[/TD]
[TD] $ 10.30[/TD]
[TD] $   9.70[/TD]
[TD] $   9.70[/TD]
[TD] $        -[/TD]
[TD] $   9.70[/TD]
[TD] $        -[/TD]
[TD] $   9.70[/TD]
[TD] $        -[/TD]
[TD] $   9.70[/TD]
[TD] $ 10.30[/TD]
[TD] $ 10.30[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $ 10.30[/TD]
[TD] $ 10.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 17.80[/TD]
[TD] $ 17.80[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $        -[/TD]
[TD] $ 15.30[/TD]
[TD] $        -[/TD]
[TD] $ 15.30[/TD]
[TD] $        -[/TD]
[TD] $ 15.30[/TD]
[TD] $ 17.80[/TD]
[TD] $ 17.80[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $ 17.80[/TD]
[TD] $ 17.80[/TD]
[TD] $       5.00[/TD]
[/TR]
[TR]
[TD]2013/01/01[/TD]
[TD]B[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 12.90[/TD]
[TD] $ 12.90[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $        -[/TD]
[TD] $ 11.00[/TD]
[TD] $        -[/TD]
[TD] $ 11.00[/TD]
[TD] $        -[/TD]
[TD] $ 11.00[/TD]
[TD] $ 12.90[/TD]
[TD] $ 12.90[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $ 12.90[/TD]
[TD] $ 12.90[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $ 17.80[/TD]
[TD] $ 17.80[/TD]
[TD] $ 15.30[/TD]
[TD] $ 15.30[/TD]
[TD] $        -[/TD]
[TD] $ 15.30[/TD]
[TD] $        -[/TD]
[TD] $ 15.30[/TD]
[TD] $        -[/TD]
[TD] $ 15.30[/TD]
[TD] $ 17.80[/TD]
[TD] $ 17.80[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $ 17.80[/TD]
[TD] $ 17.80[/TD]
[TD] $       5.00[/TD]
[/TR]
[TR]
[TD]2013/03/01[/TD]
[TD]B[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $ 13.20[/TD]
[TD] $ 13.20[/TD]
[TD] $ 11.30[/TD]
[TD] $ 11.30[/TD]
[TD] $        -[/TD]
[TD] $ 11.30[/TD]
[TD] $        -[/TD]
[TD] $ 11.30[/TD]
[TD] $        -[/TD]
[TD] $ 11.30[/TD]
[TD] $ 12.90[/TD]
[TD] $ 12.90[/TD]
[TD] $   8.70[/TD]
[TD] $   8.70[/TD]
[TD] $   8.70[/TD]
[TD] $   8.70[/TD]
[TD] $ 12.90[/TD]
[TD] $ 13.20[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 18.20[/TD]
[TD] $ 18.20[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $        -[/TD]
[TD] $ 15.90[/TD]
[TD] $        -[/TD]
[TD] $ 15.90[/TD]
[TD] $        -[/TD]
[TD] $ 18.20[/TD]
[TD] $ 18.20[/TD]
[TD] $ 15.90[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $   8.40[/TD]
[TD] $ 18.20[/TD]
[TD] $ 15.90[/TD]
[TD] $       5.00[/TD]
[/TR]
[TR]
[TD]2014/03/01[/TD]
[TD]B[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $ 13.50[/TD]
[TD] $ 13.50[/TD]
[TD] $ 11.60[/TD]
[TD] $ 11.60[/TD]
[TD] $        -[/TD]
[TD] $ 11.60[/TD]
[TD] $        -[/TD]
[TD] $ 11.60[/TD]
[TD] $        -[/TD]
[TD] $ 11.60[/TD]
[TD] $ 13.50[/TD]
[TD] $ 13.50[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $ 13.50[/TD]
[TD] $ 13.50[/TD]
[TD] $ 16.10[/TD]
[TD] $ 16.10[/TD]
[TD] $ 16.10[/TD]
[TD] $ 16.10[/TD]
[TD] $ 16.10[/TD]
[TD] $ 16.10[/TD]
[TD] $ 16.10[/TD]
[TD] $ 16.10[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 16.10[/TD]
[TD] $ 16.10[/TD]
[TD] $        -[/TD]
[TD] $ 16.10[/TD]
[TD] $        -[/TD]
[TD] $ 16.10[/TD]
[TD] $        -[/TD]
[TD] $ 16.10[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2015/03/01[/TD]
[TD]B[/TD]
[TD] $ 11.90[/TD]
[TD] $ 11.90[/TD]
[TD] $ 11.90[/TD]
[TD] $ 11.90[/TD]
[TD] $ 11.90[/TD]
[TD] $ 11.90[/TD]
[TD] $ 11.90[/TD]
[TD] $ 11.90[/TD]
[TD] $ 13.90[/TD]
[TD] $ 13.90[/TD]
[TD] $ 11.90[/TD]
[TD] $ 11.90[/TD]
[TD] $        -[/TD]
[TD] $ 11.90[/TD]
[TD] $        -[/TD]
[TD] $ 11.90[/TD]
[TD] $        -[/TD]
[TD] $ 11.90[/TD]
[TD] $ 13.90[/TD]
[TD] $ 13.90[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $ 13.90[/TD]
[TD] $ 13.90[/TD]
[TD] $ 16.60[/TD]
[TD] $ 16.60[/TD]
[TD] $ 16.60[/TD]
[TD] $ 16.60[/TD]
[TD] $ 16.60[/TD]
[TD] $ 16.60[/TD]
[TD] $ 16.60[/TD]
[TD] $ 16.60[/TD]
[TD] $ 18.80[/TD]
[TD] $ 18.80[/TD]
[TD] $ 16.60[/TD]
[TD] $ 16.60[/TD]
[TD] $        -[/TD]
[TD] $ 16.60[/TD]
[TD] $        -[/TD]
[TD] $ 16.60[/TD]
[TD] $        -[/TD]
[TD] $ 16.60[/TD]
[TD] $ 18.80[/TD]
[TD] $ 18.80[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $   9.00[/TD]
[TD] $ 18.80[/TD]
[TD] $ 18.80[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2016/03/01[/TD]
[TD]B[/TD]
[TD] $ 12.20[/TD]
[TD] $ 12.20[/TD]
[TD] $ 12.20[/TD]
[TD] $ 12.20[/TD]
[TD] $ 12.20[/TD]
[TD] $ 12.20[/TD]
[TD] $ 12.20[/TD]
[TD] $ 12.20[/TD]
[TD] $ 14.20[/TD]
[TD] $ 14.20[/TD]
[TD] $ 12.20[/TD]
[TD] $ 12.20[/TD]
[TD] $        -[/TD]
[TD] $ 12.20[/TD]
[TD] $        -[/TD]
[TD] $ 12.20[/TD]
[TD] $        -[/TD]
[TD] $ 12.20[/TD]
[TD] $ 14.20[/TD]
[TD] $ 14.20[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $ 14.20[/TD]
[TD] $ 14.20[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 19.30[/TD]
[TD] $ 19.30[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $        -[/TD]
[TD] $ 17.00[/TD]
[TD] $        -[/TD]
[TD] $ 17.00[/TD]
[TD] $        -[/TD]
[TD] $ 17.00[/TD]
[TD] $ 19.30[/TD]
[TD] $ 19.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $ 19.30[/TD]
[TD] $ 19.30[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2016/05/01[/TD]
[TD]AR[/TD]
[TD] $ 13.60[/TD]
[TD] $ 13.60[/TD]
[TD] $ 13.60[/TD]
[TD] $ 13.60[/TD]
[TD] $ 13.60[/TD]
[TD] $ 13.60[/TD]
[TD] $ 13.60[/TD]
[TD] $ 13.60[/TD]
[TD] $ 14.70[/TD]
[TD] $ 14.70[/TD]
[TD] $ 13.60[/TD]
[TD] $ 13.60[/TD]
[TD] $        -[/TD]
[TD] $ 13.60[/TD]
[TD] $        -[/TD]
[TD] $ 13.60[/TD]
[TD] $        -[/TD]
[TD] $ 13.60[/TD]
[TD] $ 14.70[/TD]
[TD] $ 14.70[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $ 14.70[/TD]
[TD] $ 14.70[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $        -[/TD]
[TD] $ 17.40[/TD]
[TD] $        -[/TD]
[TD] $ 17.40[/TD]
[TD] $        -[/TD]
[TD] $ 17.40[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2017/03/01[/TD]
[TD]AR[/TD]
[TD] $ 13.80[/TD]
[TD] $ 13.80[/TD]
[TD] $ 13.80[/TD]
[TD] $ 13.80[/TD]
[TD] $ 13.80[/TD]
[TD] $ 13.80[/TD]
[TD] $ 13.80[/TD]
[TD] $ 13.80[/TD]
[TD] $ 14.90[/TD]
[TD] $ 14.90[/TD]
[TD] $ 13.80[/TD]
[TD] $ 13.80[/TD]
[TD] $        -[/TD]
[TD] $ 13.80[/TD]
[TD] $        -[/TD]
[TD] $ 13.80[/TD]
[TD] $        -[/TD]
[TD] $ 13.80[/TD]
[TD] $ 14.90[/TD]
[TD] $ 14.90[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $ 14.90[/TD]
[TD] $ 14.90[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $ 20.00[/TD]
[TD] $ 20.00[/TD]
[TD] $ 17.40[/TD]
[TD] $ 17.40[/TD]
[TD] $        -[/TD]
[TD] $ 17.40[/TD]
[TD] $        -[/TD]
[TD] $ 17.40[/TD]
[TD] $        -[/TD]
[TD] $ 17.40[/TD]
[TD] $ 20.00[/TD]
[TD] $ 20.00[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $   9.30[/TD]
[TD] $ 20.00[/TD]
[TD] $ 20.00[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2018/03/01[/TD]
[TD]AR[/TD]
[TD] $ 14.60[/TD]
[TD] $ 14.60[/TD]
[TD] $ 14.60[/TD]
[TD] $ 14.60[/TD]
[TD] $ 14.60[/TD]
[TD] $ 14.60[/TD]
[TD] $ 14.60[/TD]
[TD] $ 14.60[/TD]
[TD] $ 15.70[/TD]
[TD] $ 15.70[/TD]
[TD] $ 14.60[/TD]
[TD] $ 14.60[/TD]
[TD] $        -[/TD]
[TD] $ 14.60[/TD]
[TD] $        -[/TD]
[TD] $ 14.60[/TD]
[TD] $        -[/TD]
[TD] $ 14.60[/TD]
[TD] $ 15.70[/TD]
[TD] $ 15.70[/TD]
[TD] $ 10.00[/TD]
[TD] $ 10.00[/TD]
[TD] $ 10.00[/TD]
[TD] $ 10.00[/TD]
[TD] $ 15.70[/TD]
[TD] $ 15.80[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 18.50[/TD]
[TD] $ 18.50[/TD]
[TD] $        -[/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 18.50[/TD]
[TD] $        -[/TD]
[TD] $ 18.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 10.20[/TD]
[TD] $ 10.20[/TD]
[TD] $ 10.20[/TD]
[TD] $ 10.20[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2019/03/01[/TD]
[TD]AR[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 15.60[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD][/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 19.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 21.50[/TD]
[TD] $ 21.50[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2019/10/05
[/TD]
[TD]AR[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 11.00[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 15.60[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 14.50[/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 19.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 21.50[/TD]
[TD] $ 21.50[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2019/10/12
[/TD]
[TD]AR[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 15.60[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 12.50[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 15.60[/TD]
[TD] $        -[/TD]
[TD] $ 15.60[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 16.70[/TD]
[TD] $ 16.70[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 19.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 14.50[/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 19.50[/TD]
[TD] $        -[/TD]
[TD] $ 19.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 21.50[/TD]
[TD] $ 21.50[/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2020/03/01[/TD]
[TD]AR[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 15.90[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 15.90[/TD]
[TD] $        -[/TD]
[TD] $ 12.50[/TD]
[TD] $ 15.90[/TD]
[TD] $        -[/TD]
[TD] $ 15.90[/TD]
[TD] $        -[/TD]
[TD] $ 15.90[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 11.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 17.00[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $ 19.80[/TD]
[TD] $ 20.80[/TD]
[TD] $ 20.80[/TD]
[TD] $ 19.80[/TD]
[TD] $        -[/TD]
[TD] $ 14.50[/TD]
[TD] $ 19.80[/TD]
[TD] $        -[/TD]
[TD] $ 19.80[/TD]
[TD] $        -[/TD]
[TD] $ 19.80[/TD]
[TD] $ 20.50[/TD]
[TD] $ 20.50[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 12.60[/TD]
[TD] $ 21.80[/TD]
[TD] $ 21.80[/TD]
[TD] $    10.00[/TD]
[/TR]
</tbody>[/TABLE]
I felt that the entire table was oo large, but that has only confused the issue.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,730
Office Version
365
Platform
Windows
The criteria used for evaluation is in a sheet called 'Payments'.
Perhaps we had better see a section of that as well, including some expected results, manually entered.
Included in those samples as well as a few straight-forward ones should be, for example, the following with explanation of how you get the result manually, provided what I have given are possible combinations.

25 April 2017, AR, Girls, U11, regular season
30 May 2015, AR, Boys, U15, regular season
12 August 2018, C, Boys, U9, regular season

Also examples from Finals, After School & Seniors
 

Yanta

Board Regular
Joined
Aug 28, 2011
Messages
54
Please forgive my hesitation. Last time I tried to explain how this system worked I got zero responses. This really should be in a proper database application, which I just haven't had the time to code... And I'd come back to the same question - how to handle effective dates in SQL. One day I hope to get around to writing the web application for this over MySQL.

Anyway. <deep sigh=""> For context. This is for tracking basketball umpiring (refereeing). Apologies for the length of this post.

There are 7 days a week, 2 sessions per day and and up to 8 games in a session. The below code shows the manually entered game games ([ref stats v8.xlsx]Games!)
Code:
[TABLE="width: 2337"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Slot 1[/TD]
[TD="colspan: 5"]Slot 2[/TD]
[TD="colspan: 5"]Slot 3[/TD]
[TD="colspan: 5"]Slot 4[/TD]
[TD="colspan: 5"]Slot 5[/TD]
[TD="colspan: 5"]Slot 6[/TD]
[TD="colspan: 5"]Slot 7[/TD]
[TD="colspan: 5"]Slot 8 (Wed only)[/TD]
[TD]Game[/TD]
[TD][/TD]
[TD]Outcomes[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]My[/TD]
[TD]Chngd[/TD]
[TD]My[/TD]
[TD]Train[/TD]
[/TR]
[TR]
[TD]ID[/TD]
[TD]WD[/TD]
[TD]Game Date[/TD]
[TD]Sess[/TD]
[TD]Ven[/TD]
[TD]Gndr[/TD]
[TD]Pattern[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Exp[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Exp[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Exp[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Exp[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Exp[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Exp[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Exp[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Crt[/TD]
[TD]Ref[/TD]
[TD]Exp[/TD]
[TD]Gr[/TD]
[TD]Age[/TD]
[TD]Type[/TD]
[TD]Super[/TD]
[TD](T,U,D,R,N)[/TD]
[TD]TF[/TD]
[TD]UF[/TD]
[TD]RPT[/TD]
[TD]Inj[/TD]
[TD]Eval[/TD]
[TD]Rost[/TD]
[TD]Grade[/TD]
[TD]Game[/TD]
[TD]Exp[/TD]
[TD]Games[/TD]
[/TR]
[TR]
[TD="align: right"]1332[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3/10/2019[/TD]
[TD]2[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]GGG[/TD]
[TD]4[/TD]
[TD]296[/TD]
[TD]3[/TD]
[TD]ER[/TD]
[TD]99[/TD]
[TD]3[/TD]
[TD]296[/TD]
[TD]3[/TD]
[TD]C[/TD]
[TD]99[/TD]
[TD]2[/TD]
[TD]357[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD]93[/TD]
[TD]NNN[/TD]
[TD]000[/TD]
[TD]000[/TD]
[TD]000[/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1333[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]8/10/2019[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGGG[/TD]
[TD]1[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]11[/TD]
[TD]1[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]11[/TD]
[TD]1[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]11[/TD]
[TD]1[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]155[/TD]
[TD]NNNN[/TD]
[TD]0000[/TD]
[TD]0000[/TD]
[TD]0000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1334[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]9/10/2019[/TD]
[TD]2[/TD]
[TD]L[/TD]
[TD]G[/TD]
[TD]NGGGG[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]315[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]16[/TD]
[TD]2[/TD]
[TD]289[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD]1[/TD]
[TD]389[/TD]
[TD]4[/TD]
[TD]BR[/TD]
[TD]16[/TD]
[TD]4[/TD]
[TD]383[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]93[/TD]
[TD]NNNNN[/TD]
[TD]00000[/TD]
[TD]00000[/TD]
[TD]00000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1335[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]10/10/2019[/TD]
[TD]2[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]GWG[/TD]
[TD]3[/TD]
[TD]354[/TD]
[TD]4[/TD]
[TD]D[/TD]
[TD]99[/TD]
[TD]4[/TD]
[TD]380[/TD]
[TD]4[/TD]
[TD]ER[/TD]
[TD]99[/TD]
[TD]2[/TD]
[TD]301[/TD]
[TD]4[/TD]
[TD]BR[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]RS[/TD]
[TD]12[/TD]
[TD]NNN[/TD]
[TD]000[/TD]
[TD]000[/TD]
[TD]000[/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1336[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]12/10/2019[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]GGGBGG[/TD]
[TD]4[/TD]
[TD]171[/TD]
[TD]4[/TD]
[TD]BR[/TD]
[TD]13[/TD]
[TD]2[/TD]
[TD]342[/TD]
[TD]4[/TD]
[TD]C[/TD]
[TD]13[/TD]
[TD]4[/TD]
[TD]328[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]328[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]12[/TD]
[TD]5[/TD]
[TD]394[/TD]
[TD]3[/TD]
[TD]BR[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]41[/TD]
[TD]NNNNNN[/TD]
[TD]000000[/TD]
[TD]000000[/TD]
[TD]000000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1337[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]15/10/2019[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGGG[/TD]
[TD]1[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]11[/TD]
[TD]1[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]11[/TD]
[TD]1[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]11[/TD]
[TD]1[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]155[/TD]
[TD]NNNN[/TD]
[TD]0000[/TD]
[TD]0000[/TD]
[TD]0000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1338[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]16/10/2019[/TD]
[TD]2[/TD]
[TD]L[/TD]
[TD]G[/TD]
[TD]GGBGG[/TD]
[TD]3[/TD]
[TD]375[/TD]
[TD]4[/TD]
[TD]CR[/TD]
[TD]14[/TD]
[TD]1[/TD]
[TD]147[/TD]
[TD]5[/TD]
[TD]AR[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]315[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD]4[/TD]
[TD]299[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]93[/TD]
[TD]NNNNN[/TD]
[TD]00000[/TD]
[TD]00000[/TD]
[TD]00000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1339[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]17/10/2019[/TD]
[TD]2[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]GG[/TD]
[TD]3[/TD]
[TD]351[/TD]
[TD]3[/TD]
[TD]ER[/TD]
[TD]99[/TD]
[TD]3[/TD]
[TD]372[/TD]
[TD]3[/TD]
[TD]ER[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]SF[/TD]
[TD]12[/TD]
[TD]NN[/TD]
[TD]01[/TD]
[TD]01[/TD]
[TD]00[/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1340[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]19/10/2019[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]GGGBGG[/TD]
[TD]3[/TD]
[TD]296[/TD]
[TD]3[/TD]
[TD]BR[/TD]
[TD]13[/TD]
[TD]3[/TD]
[TD]388[/TD]
[TD]3[/TD]
[TD]C[/TD]
[TD]13[/TD]
[TD]4[/TD]
[TD]395[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]390[/TD]
[TD]3[/TD]
[TD]B[/TD]
[TD]12[/TD]
[TD]5[/TD]
[TD]395[/TD]
[TD]4[/TD]
[TD]BR[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]41[/TD]
[TD]NNNNNN[/TD]
[TD]000000[/TD]
[TD]000000[/TD]
[TD]000000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1341[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]22/10/2019[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGGG[/TD]
[TD]6[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]155[/TD]
[TD]NNNN[/TD]
[TD]0000[/TD]
[TD]0000[/TD]
[TD]0000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1342[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]23/10/2019[/TD]
[TD]2[/TD]
[TD]L[/TD]
[TD]G[/TD]
[TD]GGGGG[/TD]
[TD]1[/TD]
[TD]315[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]14[/TD]
[TD]4[/TD]
[TD]226[/TD]
[TD]4[/TD]
[TD]C[/TD]
[TD]16[/TD]
[TD]2[/TD]
[TD]314[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD]2[/TD]
[TD]336[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD]1[/TD]
[TD]171[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]93[/TD]
[TD]NNNNN[/TD]
[TD]00000[/TD]
[TD]00000[/TD]
[TD]00000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1343[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]24/10/2019[/TD]
[TD]2[/TD]
[TD]K[/TD]
[TD]W[/TD]
[TD]GG[/TD]
[TD]3[/TD]
[TD]341[/TD]
[TD]4[/TD]
[TD]D[/TD]
[TD]99[/TD]
[TD]3[/TD]
[TD]351[/TD]
[TD]4[/TD]
[TD]ER[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GF[/TD]
[TD]2[/TD]
[TD]NN[/TD]
[TD]00[/TD]
[TD]00[/TD]
[TD]00[/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1344[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]26/10/2019[/TD]
[TD]1[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]GGGBGG[/TD]
[TD]3[/TD]
[TD]333[/TD]
[TD]3[/TD]
[TD]BR[/TD]
[TD]13[/TD]
[TD]3[/TD]
[TD]382[/TD]
[TD]3[/TD]
[TD]C[/TD]
[TD]13[/TD]
[TD]4[/TD]
[TD]396[/TD]
[TD]2[/TD]
[TD]B[/TD]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]3[/TD]
[TD]396[/TD]
[TD]2[/TD]
[TD]B[/TD]
[TD]12[/TD]
[TD]5[/TD]
[TD]391[/TD]
[TD]3[/TD]
[TD]BR[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]41[/TD]
[TD]NNNNNN[/TD]
[TD]000000[/TD]
[TD]000000[/TD]
[TD]000000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1345[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]29/10/2019[/TD]
[TD]1[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]GGGG[/TD]
[TD]6[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]A[/TD]
[TD]11[/TD]
[TD]6[/TD]
[TD]393[/TD]
[TD]4[/TD]
[TD]AR[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]155[/TD]
[TD]NNNN[/TD]
[TD]0000[/TD]
[TD]0000[/TD]
[TD]0000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1346[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]30/10/2019[/TD]
[TD]2[/TD]
[TD]L[/TD]
[TD]G[/TD]
[TD]GGBGG[/TD]
[TD]2[/TD]
[TD]149[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]14[/TD]
[TD]1[/TD]
[TD]314[/TD]
[TD]3[/TD]
[TD]A[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2[/TD]
[TD]171[/TD]
[TD]4[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD]3[/TD]
[TD]375[/TD]
[TD]3[/TD]
[TD]B[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]93[/TD]
[TD]NNNNN[/TD]
[TD]00000[/TD]
[TD]01000[/TD]
[TD]00000[/TD]
[TD][/TD]
[TD][/TD]
[TD]226[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]1347[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]31/10/2019[/TD]
[TD]2[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]GGG[/TD]
[TD]3[/TD]
[TD]351[/TD]
[TD]3[/TD]
[TD]C[/TD]
[TD]99[/TD]
[TD]2[/TD]
[TD]351[/TD]
[TD]3[/TD]
[TD]D[/TD]
[TD]99[/TD]
[TD]3[/TD]
[TD]314[/TD]
[TD]3[/TD]
[TD]B[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]GR[/TD]
[TD]12[/TD]
[TD]NNN[/TD]
[TD]000[/TD]
[TD]000[/TD]
[TD]000[/TD]
[TD][/TD]
[TD][/TD]
[TD]11[/TD]
[TD]AR[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
</deep>

WD=Weekday, Ref=number of referee in the [Ref Stats v8.xlsx]Referees! sheet. Pattern: G=Game,N=Not allocated, B=Break, A=After School Game

This data is referenced/summarized in [Ref Finances.xlsx]Summary!

Code:
[TABLE="width: 2641"]
<tbody>[TR]
[TD]DOW[/TD]
[TD]Ven[/TD]
[TD]Gender[/TD]
[TD]Date[/TD]
[TD]Pattern[/TD]
[TD]Total[/TD]
[TD]A/Grp[/TD]
[TD]G/Typ[/TD]
[TD]Year[/TD]
[TD]Month[/TD]
[TD]Games[/TD]
[TD]Bench[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]Sex[/TD]
[TD][/TD]
[TD]Sess[/TD]
[TD="colspan: 8"]Rate[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]8[/TD]
[TD][/TD]
[TD]Pay[/TD]
[TD]Outcomes[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]11/09/2019[/TD]
[TD]GGNN[/TD]
[TD="align: right"]39.00[/TD]
[TD]J[/TD]
[TD]F[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]ARB[/TD]
[TD]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    39.00[/TD]
[TD]NNNN[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]12/09/2019[/TD]
[TD]GGG[/TD]
[TD="align: right"]50.10[/TD]
[TD]S[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]D C B[/TD]
[TD]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    50.10[/TD]
[TD]NNN[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]K[/TD]
[TD]B[/TD]
[TD]14/09/2019[/TD]
[TD]GGG[/TD]
[TD="align: right"]58.50[/TD]
[TD]J[/TD]
[TD]F[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]9[/TD]
[TD]11[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]A B AR[/TD]
[TD]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    58.50[/TD]
[TD]NNN[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]O[/TD]
[TD]G[/TD]
[TD]17/09/2019[/TD]
[TD]GG[/TD]
[TD="align: right"]39.00[/TD]
[TD]J[/TD]
[TD]F[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]9[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]B AR[/TD]
[TD]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    39.00[/TD]
[TD]NN[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]18/09/2019[/TD]
[TD]NNNN[/TD]
[TD][/TD]
[TD]J[/TD]
[TD]F[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $           -[/TD]
[TD]NNNN[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]19/09/2019[/TD]
[TD]GGG[/TD]
[TD="align: right"]50.10[/TD]
[TD]S[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]D BRBR[/TD]
[TD]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    50.10[/TD]
[TD]NNN[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]K[/TD]
[TD]B[/TD]
[TD]21/09/2019[/TD]
[TD]GGGNN[/TD]
[TD="align: right"]58.50[/TD]
[TD]J[/TD]
[TD]F[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]9[/TD]
[TD]10[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]A ARB[/TD]
[TD]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    58.50[/TD]
[TD]NNNNN[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]26/09/2019[/TD]
[TD]GGG[/TD]
[TD="align: right"]50.10[/TD]
[TD]S[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]ERBRB[/TD]
[TD]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    50.10[/TD]
[TD]NNN[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]3/10/2019[/TD]
[TD]GGG[/TD]
[TD="align: right"]50.10[/TD]
[TD]S[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]ERC B[/TD]
[TD]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    50.10[/TD]
[TD]NNN[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]8/10/2019[/TD]
[TD]GGGG[/TD]
[TD="align: right"]44.00[/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]A ARA AR[/TD]
[TD]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    44.00[/TD]
[TD]NNNN[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]L[/TD]
[TD]G[/TD]
[TD]9/10/2019[/TD]
[TD]NGGGG[/TD]
[TD="align: right"]62.40[/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD]16[/TD]
[TD]16[/TD]
[TD]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]  ARB BRB[/TD]
[TD]2[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    62.40[/TD]
[TD]NNNNN[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]10/10/2019[/TD]
[TD]GWG[/TD]
[TD="align: right"]50.10[/TD]
[TD]S[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]D ERBR[/TD]
[TD]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    50.10[/TD]
[TD]NNN[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]12/10/2019[/TD]
[TD]GGGBGG[/TD]
[TD="align: right"]78.00[/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD][/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]BRC B   B BR[/TD]
[TD]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    78.00[/TD]
[TD]NNNNNN[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]15/10/2019[/TD]
[TD]GGGG[/TD]
[TD="align: right"]50.00[/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]ARARA A[/TD]
[TD]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    50.00[/TD]
[TD]NNNN[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]L[/TD]
[TD]G[/TD]
[TD]16/10/2019[/TD]
[TD]GGBGG[/TD]
[TD="align: right"]63.50[/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]14[/TD]
[TD]16[/TD]
[TD][/TD]
[TD]16[/TD]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]CRAR  B B[/TD]
[TD]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]16[/TD]
[TD][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    63.50[/TD]
[TD]NNNNN[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]L[/TD]
[TD]W[/TD]
[TD]17/10/2019[/TD]
[TD]GG[/TD]
[TD="align: right"]43.00[/TD]
[TD]S[/TD]
[TD]F[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]ERER[/TD]
[TD]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    43.00[/TD]
[TD]NN[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]19/10/2019[/TD]
[TD]GGGBGG[/TD]
[TD="align: right"]78.00[/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD][/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]BRC B   B BR[/TD]
[TD]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]13[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    78.00[/TD]
[TD]NNNNNN[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]K[/TD]
[TD]G[/TD]
[TD]22/10/2019[/TD]
[TD]GGGG[/TD]
[TD="align: right"]50.00[/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]ARA A AR[/TD]
[TD]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    50.00[/TD]
[TD]NNNN[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]L[/TD]
[TD]G[/TD]
[TD]23/10/2019[/TD]
[TD]GGGGG[/TD]
[TD="align: right"]79.10[/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD]14[/TD]
[TD]16[/TD]
[TD]16[/TD]
[TD]16[/TD]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]ARC B B B[/TD]
[TD]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    79.10[/TD]
[TD]NNNNN[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]K[/TD]
[TD]W[/TD]
[TD]24/10/2019[/TD]
[TD]GG[/TD]
[TD="align: right"]43.00[/TD]
[TD]S[/TD]
[TD]F[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD]99[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F[/TD]
[TD]D ER[/TD]
[TD]2[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]99[/TD]
[TD="align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $    43.00[/TD]
[TD]NN[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]O[/TD]
[TD]B[/TD]
[TD]26/10/2019[/TD]
[TD]GGGBGG[/TD]
[TD][/TD]
[TD]J[/TD]
[TD]R[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD][/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD]M[/TD]
[TD]BRC B   B BR[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] $           -[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
G/Type is R=Regular Season (GR, RS), F=Finals (PF, SF, GF) Rate is currently determined by the Age group except where the game type = "A" (After School). This sloppy and does not work well. The rate number for each game is a simple vlookup based on the age.

Code:
=IF(AG1332=0,"",IF(MID($F1332,COLUMN()-24,1)="A",VLOOKUP(AG1332,Rates!$Z$18:$AA$22,2,0),VLOOKUP(AG1332,Rates!$Z$4:$AA$16,2,0)))
That rate number is then used in the [Ref Finances.xls]Payments! Sheet to vlookup the payment for that game/time slot.
The existing rates table only works by year and month and doesn't cater for changes mid month or gender.

Payments snippet...

Code:
[TABLE="width: 1172"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Calculated[/TD]
[TD][/TD]
[TD]Actual[/TD]
[TD]Mentoring[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Game Date[/TD]
[TD]Game 1[/TD]
[TD]Game 2[/TD]
[TD]Game 3[/TD]
[TD]Game 4[/TD]
[TD]Game 5[/TD]
[TD]Game 6[/TD]
[TD]Game 7[/TD]
[TD]Game 8[/TD]
[TD]Pay[/TD]
[TD][/TD]
[TD]Pay[/TD]
[TD]Trainees[/TD]
[TD]Varaiance[/TD]
[/TR]
[TR]
[TD="align: right"]10/09/2019[/TD]
[TD] $             19.50[/TD]
[TD] $             19.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             39.00[/TD]
[TD][/TD]
[TD] $             39.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]11/09/2019[/TD]
[TD] $             19.50[/TD]
[TD] $             19.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             39.00[/TD]
[TD][/TD]
[TD] $             39.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]12/09/2019[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]14/09/2019[/TD]
[TD] $             19.50[/TD]
[TD] $             19.50[/TD]
[TD] $             19.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             58.50[/TD]
[TD][/TD]
[TD] $             58.50[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]17/09/2019[/TD]
[TD] $             19.50[/TD]
[TD] $             19.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             39.00[/TD]
[TD][/TD]
[TD] $             39.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]18/09/2019[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]19/09/2019[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]21/09/2019[/TD]
[TD] $             19.50[/TD]
[TD] $             19.50[/TD]
[TD] $             19.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             58.50[/TD]
[TD][/TD]
[TD] $             58.50[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]26/09/2019[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]3/10/2019[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]8/10/2019[/TD]
[TD] $             11.00[/TD]
[TD] $             11.00[/TD]
[TD] $             11.00[/TD]
[TD] $             11.00[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             44.00[/TD]
[TD][/TD]
[TD] $             44.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]9/10/2019[/TD]
[TD] $                    -[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             62.40[/TD]
[TD][/TD]
[TD] $             62.40[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]10/10/2019[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $             16.70[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $             50.10[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]12/10/2019[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $                    -[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             78.00[/TD]
[TD][/TD]
[TD] $             78.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]15/10/2019[/TD]
[TD] $             12.50[/TD]
[TD] $             12.50[/TD]
[TD] $             12.50[/TD]
[TD] $             12.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             50.00[/TD]
[TD][/TD]
[TD] $             50.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]16/10/2019[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $                    -[/TD]
[TD] $             15.60[/TD]
[TD] $             16.70[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             63.50[/TD]
[TD][/TD]
[TD] $             63.50[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]17/10/2019[/TD]
[TD] $             21.50[/TD]
[TD] $             21.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             43.00[/TD]
[TD][/TD]
[TD] $             43.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]19/10/2019[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $                    -[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             78.00[/TD]
[TD][/TD]
[TD] $             78.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]22/10/2019[/TD]
[TD] $             12.50[/TD]
[TD] $             12.50[/TD]
[TD] $             12.50[/TD]
[TD] $             12.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             50.00[/TD]
[TD][/TD]
[TD] $             50.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]23/10/2019[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $             15.60[/TD]
[TD] $             16.70[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             79.10[/TD]
[TD][/TD]
[TD] $             79.10[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
[TR]
[TD="align: right"]24/10/2019[/TD]
[TD] $             21.50[/TD]
[TD] $             21.50[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $                    -[/TD]
[TD] $             43.00[/TD]
[TD][/TD]
[TD] $             43.00[/TD]
[TD][/TD]
[TD] $                    -[/TD]
[/TR]
</tbody>[/TABLE]
The current rates table... ([Ref Finances.xls]Rates!)

Code:
[TABLE="width: 1057"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 7"]Regular Season[/TD]
[TD="colspan: 7"]Finals[/TD]
[/TR]
[TR]
[TD]Mth[/TD]
[TD]Year[/TD]
[TD]Gr[/TD]
[TD]Minball[/TD]
[TD]A/School[/TD]
[TD]GU9-GU11[/TD]
[TD]U9 - U16[/TD]
[TD]U18 - U21[/TD]
[TD]Seniors[/TD]
[TD]Hoop Time[/TD]
[TD]Minball[/TD]
[TD]A/School[/TD]
[TD]U9 - U16[/TD]
[TD]U18 - U21[/TD]
[TD]Seniors[/TD]
[TD]Hoop Time[/TD]
[TD]Scoring[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $       9.70[/TD]
[TD] $       9.30[/TD]
[TD][/TD]
[TD] $    13.80[/TD]
[TD] $    14.90[/TD]
[TD] $    14.90[/TD]
[TD] $        10.30[/TD]
[TD][/TD]
[TD] $       9.30[/TD]
[TD] $    17.40[/TD]
[TD] $        20.00[/TD]
[TD] $    20.00[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]2018[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    18.50[/TD]
[TD] $        20.80[/TD]
[TD] $    20.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $       9.70[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    17.40[/TD]
[TD] $        20.00[/TD]
[TD] $    20.00[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $       9.70[/TD]
[TD] $    10.20[/TD]
[TD][/TD]
[TD] $    14.60[/TD]
[TD] $    15.70[/TD]
[TD] $    15.70[/TD]
[TD] $        10.20[/TD]
[TD][/TD]
[TD] $    10.20[/TD]
[TD] $    17.40[/TD]
[TD] $        20.00[/TD]
[TD] $    20.00[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD][/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD][/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD][/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD][/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD][/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD][/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD][/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD] $       11.00[/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD] $       12.50[/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]2019[/TD]
[TD]AR[/TD]
[TD] $    10.00[/TD]
[TD] $    11.00[/TD]
[TD] $       12.50[/TD]
[TD] $    15.60[/TD]
[TD] $    16.70[/TD]
[TD] $    16.70[/TD]
[TD] $        11.00[/TD]
[TD][/TD]
[TD] $    12.60[/TD]
[TD] $    19.50[/TD]
[TD] $        20.50[/TD]
[TD] $    21.50[/TD]
[TD][/TD]
[TD] $    10.00[/TD]
[/TR]
</tbody>[/TABLE]
Ignore Hoop Time, it's redundant.

The payment is calculated by 'CHOOSING' the rate from the rates table using the rate number on the summary table.

Code:
=IF(V1352>0,V1352,IF(Summary!Y1351="",0,IF(Summary!$I1351="R",SUMIFS(CHOOSE(Summary!Y1351,Rates!$E$4:$E$112,Rates!$F$4:$F$112,Rates!$H$4:$H$112,Rates!$I$4:$I$112,Rates!$J$4:$J$112,Rates!$K$4:$K$112),Rates!$B$4:$B$112,MONTH($B1352),Rates!$C$4:$C$112,YEAR($B1352)),SUMIFS(CHOOSE(Summary!Y1351,Rates!$L$4:$L$112,Rates!$M$4:$M$112,Rates!$N$4:$N$112,Rates!$O$4:$O$112,Rates!$P$4:$P$112,Rates!$Q$4:$Q$112),Rates!$B$4:$B$112,MONTH($B1352),Rates!$C$4:$C$112,YEAR($B1352)))))
Like I said, sloppy, cumbersome and overly complex. This has just evolved over the last 8 years. It's time I fixed it up properly. I added in the change to the U9-11 and that broke the payments calculation, and it doesn't take gender into account, which it must now do.

Rather than maintain a table of rates for 12 entries per year, I figured it was easier to just have dates when the rates change and find the correct rate to apply based on the game date, age, gender, competition type and game type. (Competition types are Juniors, Seniors and After School - J, S, and A).

The goal is only one place is regularly manually updated - that is the games sheet in [Ref Stats V8.xls]. EVERYTHING else is calculated. New rates are added only when they change. Except for 'Actual pay' which is manually entered. If it differs from expected pay there will be a variance which I can then follow up with the office.

Please let me know if I've missed anything.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,730
Office Version
365
Platform
Windows
I'm afraid it looks too complex for a free public forum like this but perhaps somebody might take up the challenge.
 

Yanta

Board Regular
Joined
Aug 28, 2011
Messages
54
I expected as much. Thanks anyway.

I doubt anyone will take up the challenge. I have other posts that still have no replies on similar topics.

I wrote some date handling code in Cold Fusion and SQL over a decade ago. I doubt I have it lying around, but I might get lucky. Sadly, I think I'm going to have to migrate this to a proper DB app. <sigh>
 

Forum statistics

Threads
1,077,827
Messages
5,336,613
Members
399,092
Latest member
jbwatkins

Some videos you may like

This Week's Hot Topics

Top