#!/bin/tcsh

# (exp1|exp2) matches exp1 or exp2.  \\\( escapes the ( for the shell and grep.
# Same for \\\).  This looks for /2000: or /2001: or /2003: (and so on).
echo "======================================================================"
echo "Use values in 'Total' since the records are only from offsite already." 
echo "======================================================================"
echo Total
foreach y ('2000\|2001\|2002\|2003\|2004\|2005\|2006' 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018)
	echo -n $y " "
	#grep /\\\($y\\\): $1 | cut -f1 -d" " | sort | uniq --count | awk '{if($1<=200) {for(i=0;i<$1;i++) print} else {print}}' | wc -l 
    grep /\\\($y\\\): $1 | wc -l 
    #grep /\\\($y\\\): $1 | cut -f1 -d" " | sort | uniq --count | awk '{if($1<=500) {for(i=0;i<$1;i++) print} else {print}}' | wc -l 
	#grep /\\\($y\\\): $1 | cut -f1 -d" " | sort | wc -l 
	#grep /\\\($y\\\): $1 | cut -f1 -d" " | sort | awk '{if($1<=9999) {for(i=0;i<$1;i++) print} else {print}}' | wc -l 
    ###############################################
    # for VRPN, run the command line below instead
	# grep /\\\($y\\\): $1 | wc -l 
    ###############################################
end

echo Unique
foreach y ('2000\|2001\|2002\|2003\|2004\|2005\|2006' 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018)
	echo -n $y " "
	grep /\\\($y\\\): $1 | cut -f1 -d" " | sort | uniq | wc -l
end

echo Unique offsite
foreach y ('2000\|2001\|2002\|2003\|2004\|2005\|2006' 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018)
	echo -n $y " "
	grep /\\\($y\\\): $1 | cut -f1 -d" " | sort | uniq | grep -v 152.2. | grep -v 152.19. | wc -l
end

echo -n "Unique offsite all years: "
cat $1 | cut -f1 -d" " | sort | uniq | grep -v 152.2. | grep -v 152.19. | wc -l

echo -n "Total all years: "
wc $1