 |
|
| thanks |
|
|
By Intelinside - Posted on October 4, 2002 - 01:27:24 (#3434)
Current version when comment was posted: 0.1-dev1 |
|
|
|
| Formulas |
|
|
By tpv - Posted on October 3, 2002 - 23:33:32 (#3433)
Current version when comment was posted: 0.1-dev1 |
|
|
The list of formulas is "in the source" (it may be accessible inside the app too, I don't recall).
Read them here: http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/sum-it/sum-it/Resources/FuncNames.txt?rev=1.1.1.1&content-type=text/vnd.viewcvs-markup
The descriptions (in the same order as the names) are here: http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/sum-it/sum-it/Resources/FuncDescs.txt?rev=1.1.1.1&content-type=text/vnd.viewcvs-markup
Now, regarding countif: No equivalent that I can see.
The simplest (?) solution is to have another range (probably on a different sheet) that uses IF( condition, 1, 0) to setup a grid of 1s and 0s.
Then use sum on that grid, to find the number of 1s.
Ugly, but it works.
|
|
| formula's |
|
|
By Intelinside - Posted on October 3, 2002 - 00:52:11 (#3415)
Current version when comment was posted: 0.1-dev1 |
|
|
Anyone got a list of what type of forumla's are avalible for Sum-it? I need countif is there a similar alternative?
|
|
| works fine |
|
|
By moooooooo - Posted on August 26, 2002 - 20:56:00 (#2856)
Current version when comment was posted: 0.1-dev1 |
|
|
yeah i saw that.
i edited the header directly and added sys/socket.h.
probably will break other things but hey, at least i know where it is.
Sum-It seems to work ok though.
|
|
| It works :) |
|
|
By mmu_man - Posted on August 26, 2002 - 05:39:15 (#2846)
Current version when comment was posted: 0.1-dev1 |
|
|
Ok, it compiles and works. Just had to hack a:
ln -s sys/socket.h /boot/develop/headers/be/bone/
to get bsl compile in BONE (doesn't use net funcs, but includes Be.h)
Linking takes time and at least 50 MB of HDD space to work :^)
|
|
| re: re: rez |
|
|
By mmu_man - Posted on August 26, 2002 - 04:38:31 (#2845)
Current version when comment was posted: 0.1-dev1 |
|
|
Ok, thought it was an oldish R4 tool or something (like idestatus...). Thx.
|
|
| bsl |
|
|
By moooooooo - Posted on August 26, 2002 - 02:38:08 (#2841)
Current version when comment was posted: 0.1-dev1 |
|
|
you'll also need bsl
so do the same for co rez but make it co bsl and build and install that
peter
|
|
| cvs instructions |
|
|
By moooooooo - Posted on August 26, 2002 - 02:35:36 (#2840)
Current version when comment was posted: 0.1-dev1 |
|
|
To access Sum-It's CVS repository, create a new directory where you want to do this, open a terminal session type in (copy and paste it) this:
cvs -d:pserver:anonymous@cvs.sum-it.sourceforge.net:/cvsroot/sum-it login
Hit ENTER when prompted for a password
cvs -z3 -d:pserver:anonymous@cvs.sum-it.sourceforge.net:/cvsroot/sum-it co rez
and the files will come on down :)
i have built rez and am buidling Sum-It now :)
peter
|
|
| re:rez |
|
|
By misza - Posted on August 25, 2002 - 15:48:37 (#2836)
Current version when comment was posted: 0.1-dev1 |
|
|
I did a little digging and found it in the cvs for the app.
http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/sum-it/
|
|
| anyone got it compiled in R5 ? |
|
|
By mmu_man - Posted on August 25, 2002 - 14:39:56 (#2835)
Current version when comment was posted: 0.1-dev1 |
|
|
Just tried to compile Sum-It in R5, but it looks for a tool called 'rez', which I presume should be replaced by mwbres or mwdres maybe. If anyone has a handy patch ?
|
|
|
|
|
