dberkholz/calculate_mileage.sh

## calculate_mileage.sh
#!/bin/bash

for file in */*xls; do
  echo ${file#*/}
  in2csv --sheet 'Expense Report' $file \
    | awk -F, '{if ($5 == "Mileage") {printf "%d\t%.2f\t%s (%.2f mi @ $0.56/mi)\n", $1, $6, $4, $6/0.56 }}'
  echo
done
	#!/bin/bash

	for file in /xls; do
	echo ${file#*/}
	in2csv --sheet 'Expense Report' $file \
	\| awk -F, '{if ($5 == "Mileage") {printf "%d\t%.2f\t%s (%.2f mi @ $0.56/mi)\n", $1, $6, $4, $6/0.56 }}'
	echo
	done