Re: [dwm] [OT] Suckless way of doing spreadsheet
suckless spreadsheet? Try vicissicalc http://github.com/darius/vicissicalc/tree/master On Sat, May 2, 2009 at 8:11 PM, Kurt H Maier wrote: > On Sat, May 2, 2009 at 12:57 PM, Charlie Kester wrote: >> On Sat 02 May 2009 at 10:32:13 PDT Charlie Kester wrote: >>> >>> There's also an slang-based version of the original sc: >>> >>> http://linux.maruhn.com/sec/slsc.html >> >> Here's a page with downloads links for slsc that actually work: >> >> http://packages.ubuntu.com/dapper/math/slsc > > That's great for ubuntu. Here's source: > ftp://space.mit.edu/pub/davis/slsc/ > > Amusing to see it's been unsupported since 1996 :) > > > # Kurt H Maier > >
Re: [dwm] [OT] Suckless way of doing spreadsheet
On Sat, May 2, 2009 at 12:57 PM, Charlie Kester wrote: > On Sat 02 May 2009 at 10:32:13 PDT Charlie Kester wrote: >> >> There's also an slang-based version of the original sc: >> >> http://linux.maruhn.com/sec/slsc.html > > Here's a page with downloads links for slsc that actually work: > > http://packages.ubuntu.com/dapper/math/slsc That's great for ubuntu. Here's source: ftp://space.mit.edu/pub/davis/slsc/ Amusing to see it's been unsupported since 1996 :) # Kurt H Maier
Re: [dwm] [OT] Suckless way of doing spreadsheet
On Sat 02 May 2009 at 10:32:13 PDT Charlie Kester wrote: There's also an slang-based version of the original sc: http://linux.maruhn.com/sec/slsc.html Here's a page with downloads links for slsc that actually work: http://packages.ubuntu.com/dapper/math/slsc
Re: [dwm] [OT] Suckless way of doing spreadsheet
On Fri 01 May 2009 at 23:43:25 PDT Amit Uttamchandani wrote: On Fri, 1 May 2009 21:43:49 +0200 Antoni Grzymala wrote: How about sc[1], a ncurses based spreadsheet? [1] http://ibiblio.org/pub/Linux/apps/financial/spreadsheet/ Thanks for the tip! Leaving aside the question of whether being ncurses-based suffices to make a program suckless, here are some other ncurses-based spreadsheets: http://www.moria.de/~michael/teapot/ http://www.gnu.org/software/oleo/oleo.html There's also an slang-based version of the original sc: http://linux.maruhn.com/sec/slsc.html
Re: [dwm] [OT] Suckless way of doing spreadsheet
Better if you remove que hash table: BEGIN { FS = "\t+" OFS= "\t" } $2 ~ /[0-9]+\.?[0-9]*/ { car += $2 pro += $3 fat += $4 } END{ print "Totals", car, pro, fat } On Sat, May 2, 2009 at 8:36 AM, Amit Uttamchandani wrote: > On Sat, 2 May 2009 00:00:15 +0200 > pmarin wrote: > >> Do you want to calculate only the total? >> Use hard tabs "\t" to separate columns >> >> My version: >> >> BEGIN { >> FS = "\t+" >> OFS= "\t" >> } >> $2 ~ /[0-9]+\.?[0-9]*/ { >> total["car"] += $2 >> total["pro"] += $3 >> total["fat"] += $4 >> } >> END{ >> print "Totals", total["car"], total["pro"], total["fat"] >> > > Thanks! I think this will do the trick. > >
Re: [dwm] [OT] Suckless way of doing spreadsheet
On Fri, 1 May 2009 21:43:49 +0200 Antoni Grzymala wrote: > > How about sc[1], a ncurses based spreadsheet? > > [1] http://ibiblio.org/pub/Linux/apps/financial/spreadsheet/ > Thanks for the tip!
Re: [dwm] [OT] Suckless way of doing spreadsheet
On Sat, 2 May 2009 00:00:15 +0200 pmarin wrote: > Do you want to calculate only the total? > Use hard tabs "\t" to separate columns > > My version: > > BEGIN { > FS = "\t+" > OFS= "\t" > } > $2 ~ /[0-9]+\.?[0-9]*/ { > total["car"] += $2 > total["pro"] += $3 > total["fat"] += $4 > } > END{ > print "Totals", total["car"], total["pro"], total["fat"] > Thanks! I think this will do the trick.
Re: [dwm] [OT] Suckless way of doing spreadsheet
Do you want to calculate only the total? Use hard tabs "\t" to separate columns My version: BEGIN { FS = "\t+" OFS= "\t+" } $2 ~ /[0-9]+\.?[0-9]*/ { total["car"] += $2 total["pro"] += $3 total["fat"] += $4 } END{ print "Totals", total["car"], total["pro"], total["fat"] } On Fri, May 1, 2009 at 9:39 PM, Amit Uttamchandani wrote: > > I don't have a powerful machine so using OpenOffice was out of the > question. I was happily using gnumeric for sometime but this bug just > killed it for me: > > http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=526379 > > I know this will probably be fixed but I thought there must be a > suckless way to do spreadsheets? I basically am using a > spreadsheet for nutritional purposes and there are no cells that cross > reference each other, etc. So it's quite simple. > > Can I use a text file and awk? > > A typical spreadsheet entry would like this: > > Mon (Non-Workout) > > Meal 6 Carbs Protein Fats > > 10oz reduced fat milk 15.6 11.2 5.6 > 1 scoop whey protein 3 24 1 > 1bsp flaxseed oil 0 0 13.6 > > Totals 18.6 35.2 20.2 > > Thanks for any help... > > Amit > >
Re: [dwm] [OT] Suckless way of doing spreadsheet
Do you want to calculate only the total? Use hard tabs "\t" to separate columns My version: BEGIN { FS = "\t+" OFS= "\t" } $2 ~ /[0-9]+\.?[0-9]*/ { total["car"] += $2 total["pro"] += $3 total["fat"] += $4 } END{ print "Totals", total["car"], total["pro"], total["fat"] On Fri, May 1, 2009 at 9:39 PM, Amit Uttamchandani wrote: > > I don't have a powerful machine so using OpenOffice was out of the > question. I was happily using gnumeric for sometime but this bug just > killed it for me: > > http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=526379 > > I know this will probably be fixed but I thought there must be a > suckless way to do spreadsheets? I basically am using a > spreadsheet for nutritional purposes and there are no cells that cross > reference each other, etc. So it's quite simple. > > Can I use a text file and awk? > > A typical spreadsheet entry would like this: > > Mon (Non-Workout) > > Meal 6 Carbs Protein Fats > > 10oz reduced fat milk 15.6 11.2 5.6 > 1 scoop whey protein 3 24 1 > 1bsp flaxseed oil 0 0 13.6 > > Totals 18.6 35.2 20.2 > > Thanks for any help... > > Amit > >
Re: [dwm] [OT] Suckless way of doing spreadsheet
Amit Uttamchandani dixit (2009-05-01, 12:39): > > I don't have a powerful machine so using OpenOffice was out of the > question. I was happily using gnumeric for sometime but this bug just > killed it for me: > > http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=526379 > > I know this will probably be fixed but I thought there must be a > suckless way to do spreadsheets? I basically am using a > spreadsheet for nutritional purposes and there are no cells that cross > reference each other, etc. So it's quite simple. How about sc[1], a ncurses based spreadsheet? [1] http://ibiblio.org/pub/Linux/apps/financial/spreadsheet/ -- [a]
[dwm] [OT] Suckless way of doing spreadsheet
I don't have a powerful machine so using OpenOffice was out of the question. I was happily using gnumeric for sometime but this bug just killed it for me: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=526379 I know this will probably be fixed but I thought there must be a suckless way to do spreadsheets? I basically am using a spreadsheet for nutritional purposes and there are no cells that cross reference each other, etc. So it's quite simple. Can I use a text file and awk? A typical spreadsheet entry would like this: Mon (Non-Workout) Meal 6 Carbs Protein Fats 10oz reduced fat milk 15.611.25.6 1 scoop whey protein3 24 1 1bsp flaxseed oil 0 0 13.6 Totals 18.635.220.2 Thanks for any help... Amit