The program needn't be a shell script invoking awk--you can use a "shebang" line to make the entire thing an awk file. This will help if you use an editor which understands awk syntax (for highlighting etc.). Of course in 1981 you probably didn't have such luxuries, but today we can just remove the "exec awk", the outer quotes and $1, and put this as the first line:
Clever solution - technically. For trips with my friends we use a "money-pot" system where everyone pays a fixed amount into a pot before the trip and everything we do or buy together is paid out of this pot. After the trip the calculation is much easier - refund = (remaining amount / persons) ;-)
I wonder whether it would be possible to extend this concept to get more powerful features, inspired by spreadsheets (and programming languages maybe). Sometimes you need more than a sum or an average, but writing out the formulas in full, repeatedly, seems like a lot of cognitive overhead.
I see in this thread that Emacs org-mode has something like it, but I'm not convinced that stuff like
#+TBLFM: @2$4=vmean($2..$3)
matches the humane, readable, Markdown-esque approach that I'd want to use.
22 comments
[ 2.8 ms ] story [ 64.8 ms ] threadAgain, I'd like to plug http://www.ledger-cli.org. It's similar in spirit, with a reporting program reading a lightly formatted text file.
http://orgmode.org/org.html#The-spreadsheet
(Not affiliated, just a happy user. And there's a nice network effect if more people use it, so more people should use it.)
I have written a python script back in 2007 for calculating two trips expenses: https://github.com/bernardeli/trip_money_organizer
I'm not a Python developer myself, however I was pretty happy with the result. I know it works fine, and have used few times with no issues.
I wonder whether it would be possible to extend this concept to get more powerful features, inspired by spreadsheets (and programming languages maybe). Sometimes you need more than a sum or an average, but writing out the formulas in full, repeatedly, seems like a lot of cognitive overhead.
I see in this thread that Emacs org-mode has something like it, but I'm not convinced that stuff like
matches the humane, readable, Markdown-esque approach that I'd want to use.