#!/bin/bash
# this file: go.sh (calls conv_log.sh)
#
outfile="./usage_log"
rm -f $outfile
#
while read fname
do
logdate=$(echo $fname |awk -F "/" '{print $6}' |awk -F "." '{print $1}')
./conv_log.sh $fname $logdate $outfile
done < ./log_read.txt
# eof

# -------------------------------
#!/bin/bash
# this file: conv_log.sh
#
logfile="$1"
logdate="$2"
outfile="$3"
tmpfile="/tmp/energyout.txt"
rm -f $tmpfile
# if the logfile doesn't exist then bailout
if [ ! -f $logfile ]; then
   echo "Logfile doesn't exist, exiting..."
   exit 3
fi
#
cat $logfile |awk -F "," '{print $2}' > $tmpfile
#
kwday=$(perl -nle' $s += $_; END { printf "%.2f", $s*4/3600000 } ' $tmpfile)
#
echo "${logdate},${kwday}"
echo "${logdate},${kwday}" >> $outfile
#
rm -f $tmpfile
#
# eof
#

# input file (log_read.txt)
/usr/local/etc/energy_meter_logs/01-12-2021.log
/usr/local/etc/energy_meter_logs/02-12-2021.log
/usr/local/etc/energy_meter_logs/03-12-2021.log
/usr/local/etc/energy_meter_logs/04-12-2021.log
/usr/local/etc/energy_meter_logs/05-12-2021.log
/usr/local/etc/energy_meter_logs/06-12-2021.log
/usr/local/etc/energy_meter_logs/07-12-2021.log
/usr/local/etc/energy_meter_logs/08-12-2021.log
/usr/local/etc/energy_meter_logs/09-12-2021.log
/usr/local/etc/energy_meter_logs/10-12-2021.log
/usr/local/etc/energy_meter_logs/11-12-2021.log
/usr/local/etc/energy_meter_logs/12-12-2021.log
/usr/local/etc/energy_meter_logs/13-12-2021.log
/usr/local/etc/energy_meter_logs/14-12-2021.log
/usr/local/etc/energy_meter_logs/15-12-2021.log
/usr/local/etc/energy_meter_logs/16-12-2021.log
/usr/local/etc/energy_meter_logs/17-12-2021.log
/usr/local/etc/energy_meter_logs/18-12-2021.log
/usr/local/etc/energy_meter_logs/19-12-2021.log
/usr/local/etc/energy_meter_logs/20-12-2021.log
/usr/local/etc/energy_meter_logs/21-12-2021.log
/usr/local/etc/energy_meter_logs/22-12-2021.log
/usr/local/etc/energy_meter_logs/23-12-2021.log
/usr/local/etc/energy_meter_logs/24-12-2021.log
/usr/local/etc/energy_meter_logs/25-12-2021.log
/usr/local/etc/energy_meter_logs/26-12-2021.log
/usr/local/etc/energy_meter_logs/27-12-2021.log
/usr/local/etc/energy_meter_logs/28-12-2021.log
/usr/local/etc/energy_meter_logs/29-12-2021.log
/usr/local/etc/energy_meter_logs/30-12-2021.log
/usr/local/etc/energy_meter_logs/31-12-2021.log

# output (date,kw)
01-12-2021,47.55
02-12-2021,51.82
03-12-2021,51.22
04-12-2021,50.33
05-12-2021,49.98
06-12-2021,50.47
07-12-2021,57.47
08-12-2021,53.84
09-12-2021,48.53
10-12-2021,47.59
11-12-2021,53.67
12-12-2021,37.75
13-12-2021,35.02
14-12-2021,35.08
15-12-2021,31.75
16-12-2021,36.60
17-12-2021,35.89
18-12-2021,43.98
19-12-2021,48.11
20-12-2021,46.83
21-12-2021,47.53
22-12-2021,52.63
23-12-2021,44.56
24-12-2021,38.98
25-12-2021,50.22
26-12-2021,54.20
27-12-2021,48.61
28-12-2021,43.36
29-12-2021,45.88
30-12-2021,36.24
31-12-2021,28.90