{ version => '02', contest_name => 'The Rumble psk contest', contest_id => 'TARA-Rumble', filter => { mode => \"LIKE '%PSK%'", band => \"IN('160M','80M','40M','20M','15M','10M','6M')", }, defaults => { contest_url => 'http://www.n2ty.org/seasons/tara_rumble_rules.html', log_cols => [qw/ mycall call qso_date time_on freq band mode rst_sent stx rst_rcvd srx dxccprefix calc1 pfx /], placeholders => [qw/ Category /], dropbox_options => { Category => [qw/ Team Normal Great Super SWL /], }, update => sub { my $row = shift; my $s = $row->{dxccprefix}; if( $s =~ /^(K|VE|JA|VK)$/ ){ my $n = ( $row->{pfx} =~ /(\d+)/g )[-1]; $s .= $n; return { calc1 => $s }; # The Call area (e.g. K4) for K/VE/JA/VK. } return { calc1 => '' }; }, Qs => [ { label => 'QSOs', weight => 1, group_by => 'call, band', where => {} }, ], mults => [ { label => 'DXCC', group_by => 'band,dxccprefix' }, { label => 'K/VE/VK/JA Call Areas', group_by => 'band,calc1', where => { calc1 => {'!='=>''} } }, ], }, years => { 2010 => { sample => '', filter => { qso_date => { -between => [20101002, 20101002] }, }, closed => 1, }, 2011 => { filter => { qso_date => { -between => [20111001, 20111001] }, }, }, }, }