annotate bin/budget.sh @ 661:1453c8a3747e
STUB: python/clean_whiteboard.py
author |
Jeff Hammel <k0scist@gmail.com> |
date |
Thu, 03 Apr 2014 17:31:43 -0700 |
parents |
25e92f9cf011 |
children |
|
rev |
line source |
492
|
1 #!/bin/bash
|
|
2
|
|
3 # from http://c2.com/doc/expense/
|
|
4
|
|
5 exec awk ' $1 ~ /^[A-Z]+[A-Z0-9]*$/ { if (sums[$1] == "" || $1 == "SUM") { sums[$1] = sum # Define Symbol $1 = sum sum = 0 } else { $1 = sums[$1] # Dereference Symbol } } ($1+0) != 0 {$1 = sprintf("%7.2f", $1)} # Pretty Print {print} $2 == "*" {$1 *= $3} # Explicit Calculations $2 == "/" {$1 /= $3} $2 == "DB" {$1 = -$1} $2 == "CR" {$1 = -$1} NF == 0 {sum = 0} # Implicit Summation {sum += $1} ' $1 |