Miscellany

#test the name,value pairs as they appear in the spreadsheet for acceptable values
foo=$(grep ^$n1 $t1); (( ${foo##*,} > $v1)) &&  echo "$foo" >> "$t1.error"
foo=$(grep ^$n2 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n3 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n4 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n5 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n6 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n7 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n8 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n9 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n10 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n11 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n12 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n13 $t1); [[ ${foo##*,} != $v13 ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n14 $t1); [[ ${foo##*,} != $v14 ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n15 $t1); [[ ${foo##*,} != $v15 ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n16 $t1); [[ ${foo##*,} = \"\" || -z ${foo##*,} ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n17 $t1); [[ ${foo##*,} != $v17 ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n18 $t1); [[ ${foo##*,} != $v18 ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n19 $t1); [[ ${foo##*,} != $v19 ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n20 $t1); [[ ${foo##*,} != $v20 ]] && echo "$foo" >> "$t1.error"
foo=$(grep ^$n21 $t1); (( ${foo##*,} > $v21)) &&  echo "$foo" >> "$t1.error"
foo=$(grep ^$n22 $t1); (( ${foo##*,} > $v22)) &&  echo "$foo" >> "$t1.error"
foo=$(grep ^$n23 $t1); (( ${foo##*,} > $v23)) &&  echo "$foo" >> "$t1.error"
foo=$(grep ^$n24 $t1); (( ${foo##*,} < $v24)) &&  echo "$foo" >> "$t1.error"
foo=$(grep ^$n25 $t1); (( ${foo##*,} != $v25)) &&  echo "$foo" >> "$t1.error"
foo=$(grep ^$n26 $t1); (( ${foo##*,} != $v26)) &&  echo "$foo" >> "$t1.error"