{ version => '01', contest_name => "Feld Hell Hamvention Sprint", contest_id => 'FH-HAMVENTION-SPRINT', filter => { mode => \"IN ('PSKHELL', 'FMHELL', 'HELL', 'HELL80')", band => \"IN('160M','80M','40M','20M','15M','10M','6M')", }, defaults => { contest_url => 'http://sites.google.com/site/feldhellclub/Home/contests/may-2011-sprint', log_cols => [qw/ call qso_date time_on band spc srx sfx calc1 /], placeholders => [qw/ Address Email FH-Number CATEGORY /], dropbox_options => { CATEGORY => [ 'NA QRP', 'DX QRP', 'NA QRO', 'DX QRO' ], }, update => sub { my $row = shift; my %h; ($h{calc1}) = $row->{srx} =~ /\b0*(\d+)\b/; $h{calc1} ||= 0; return \%h; }, Qs => [ { label => "Club members", weight => 3, group_by => 'call, band', where => { srx =>{'!='=>0} } }, { label => "Non-club members", weight => 1, group_by => 'call, band', where => { srx =>0 } }, { label => "QRP extra", weight => 2, group_by => 'call, band', where => { -nest => [ rx_pwr => { '>', 0, '<=', 5 }, call => { -like => \"'%/qrp'" } ], } }, { label => "ERRORS - unknown DXCC; no mult credit", weight => 0, group_by => 'qso_date,time_on,band,call', where => {dxccprefix=>'??'} }, ], mults => [ { label => 'DXCC', group_by => 'dxccprefix', where => {contest_use=>1} }, { label => 'States', group_by => 'state', where => {contest_use=>1,dxccprefix => 'K'} }, { label => 'Provinces', group_by => 'state', where => {contest_use=>1,dxccprefix => 'VE'} }, ], bonus => [ { label => 'W8H', weight => 50, group_by => 'call,band', where => { call=>'W8H' } }, ], }, years => { 2011 => { sample => '', filter => { qso_date => '20110521', }, }, }, }