Re: Fireworkz query
Dr Peter Young
wrote:
> I've got a slight problem with Fireworkz and I was wondering if anyone
> knows a quick way around it.
> Is there a way of counting how many cells are 'non empty' or contain a
> particular character?
> I've got a spreadsheet with a number of columns into which I enter "y" or
> "n" to indicate whether something is yes or no. I'm looking for a way of
> counting how many "y"s there are in the whole column, so I can find a total
> yes's.
> Thus, if I'm doing a survey, and put a tick next to each person, I want a
> quick way of seeing how many people said "y" or "n".
dcounta(range,range=<what_you_want_to_count>) works for me.
HTH,
With best wishes,
Peter.
--
Peter \ / zfc Er \ Prestbury, Cheltenham, Glos. GL52
Anne \/ __ __ \ England.
and / / \ | | |\ | / _ \ http://pnyoung.orpheusweb.co.uk
family / \__/ \_/ | \| \__/ \______________ pny...@ormail.co.uk.
John Williams (News)
Vigay <invalid-em...@invalid-domain.co.uk> wrote:
> I've got a spreadsheet with a number of columns into which I enter "y" or
> "n" to indicate whether something is yes or no. I'm looking for a way of
> counting how many "y"s there are in the whole column, so I can find a
> total yes's.
> Thus, if I'm doing a survey, and put a tick next to each person, I want a
> quick way of seeing how many people said "y" or "n".
Can't you do it 'binararily' - use a 0 or a 1 instead for no and yes?
John
--
John Williams, Brittany, Northern France - no attachments to these addresses!
Non-RISC OS posters change user to johnrwilliams or put 'risc' in subject
for reliable contact! Who is John Williams? http://www.picindex.info/author/
Somewhere nice to stay in Brittany? http://petit.four.free.fr/visitors/locate
Christopher Rayson
>> Thus, if I'm doing a survey, and put a tick next to each person, I want a
>> quick way of seeing how many people said "y" or "n".
> Can't you do it 'binararily' - use a 0 or a 1 instead for no and yes?
And if you do it John's way, you can even get Fireworkz to display a tick
icon for '1' and a cross for '0' -- see this post of mine for details:
<ant19181...@cjr43.acad.cai.cam.ac.uk>
Chris
Dave Symes
> Chris
Doesn't go anywhere or do anything. What's missing?
Dave S
--
Brian Howlett
> <ant19181...@cjr43.acad.cai.cam.ac.uk>
> Doesn't go anywhere or do anything. What's missing?
You're using Pluto, so I don't know how Message IDs in posts work for
you, but in MPro I can right click on the link to bring up a menu of
various actions that can be done with it, including fetching the
message from Google Groups or from your own stored messages, amongst
other things.
In this case it is a post from 2005, so unless you don't expire your
newsgroups is probably not available locally. The Google Groups URL is
http://groups.google.com/group/comp.sys.acorn.apps/msg/fa9dc5bbabe7c04a
--
Brian Howlett - Email to From: address deleted unseen
------------------------------------------------------------------
Last year I went fishing with Salvador Dali. He was using a dotted
line. He caught every other fish.
Steve Fryatt
<4fbcc7d...@triffid.co.uk>:
> In article <Pine.LNX.4.64.08...@ophir.damtp.cam.ac.uk>,
> Christopher Rayson <chris...@yahoo.com> wrote:
>
> > And if you do it John's way, you can even get Fireworkz to display a
> > tick icon for '1' and a cross for '0' -- see this post of mine for
> > details: <ant19181...@cjr43.acad.cai.cam.ac.uk>
>
> Doesn't go anywhere or do anything. What's missing?
It's a message ID: your newsreader will need to be able to understand
them. If it's a recent message in a group you subscribe to, it should be
possible to jump straight to it; otherwise, it might be able to look it up
in Google Groups for you (M-Pro can; I don't know about other
newsreaders).
Alternatively, go to http://groups.google.com/advanced_search and stick
the ID (without the angle brackets) into the Message ID field at the
bottom of the page.
--
Steve Fryatt - Leeds, England
Evan Clark
Dave Symes <da...@triffid.co.uk> wrote:
> > Chris
If the article is still within Pluto, double-clicking on it should open
it. Otherwise, it should launch a search of the Google Groups archive
and, if found, open the archive in a browser.
Beware, however, this warning from Mark Fraser in the Pluto mailing list
06 May 2005:
In article <4d66f18...@mfraz.freeserve.co.uk>,
Mark Fraser <ya...@mfraz.freeserve.co.uk> wrote:
> Since moving to Google Groups beta, I've found that trying to view a
> message no longer in Pluto doesn't work. This is because Google have
> changed the way that a Message ID search is performed.
> To get it working again, load !Pluto.Messages into a text editor and
> look for the line that starts Ymsgid:
> This needs to be changed so that it now reads:
> Ymsgid:http://groups.google.co.uk/groups?selm=%s
> This (fingers crossed) should get things working again.
Mark's instructions worked for me.
Evan.
Dave Symes
Evan Clark <ev...@ejclark.fsnet.co.uk> wrote:
[Snip]
> Beware, however, this warning from Mark Fraser in the Pluto mailing list
> 06 May 2005:
> In article <4d66f18...@mfraz.freeserve.co.uk>,
> Mark Fraser <ya...@mfraz.freeserve.co.uk> wrote:
> > Since moving to Google Groups beta, I've found that trying to view a
> > message no longer in Pluto doesn't work. This is because Google have
> > changed the way that a Message ID search is performed.
> > To get it working again, load !Pluto.Messages into a text editor and
> > look for the line that starts Ymsgid:
> > This needs to be changed so that it now reads:
> > Ymsgid:http://groups.google.co.uk/groups?selm=%s
> > This (fingers crossed) should get things working again.
> Mark's instructions worked for me.
> Evan.
Thanks for that bit 'O info Evan.
After making the change in the Pluto.Messages file, I can now access the
article by double clicking the link reference.
Cheers
Dave S
--
Dave Symes
> > <ant19181...@cjr43.acad.cai.cam.ac.uk>
> > Doesn't go anywhere or do anything. What's missing?
> You're using Pluto, so I don't know how Message IDs in posts work for
> you, but in MPro I can right click on the link to bring up a menu of
> various actions that can be done with it, including fetching the
> message from Google Groups or from your own stored messages, amongst
> other things.
> In this case it is a post from 2005, so unless you don't expire your
> newsgroups is probably not available locally. The Google Groups URL is
> http://groups.google.com/group/comp.sys.acorn.apps/msg/fa9dc5bbabe7c04a
Thanks for that Brian.
Ironic the reply was to me and a question I'd asked.
Dave S
--
Brian Carroll
> > <ant19181...@cjr43.acad.cai.cam.ac.uk>
> > Doesn't go anywhere or do anything. What's missing?
> You're using Pluto, so I don't know how Message IDs in posts
> work for you, ...
[Snip]
Pluto scans its message store and displays the message, if
found, in an 'additional viewer' window. If the message is not
in the store the default browser is launched (if not loaded) and
the Google Groups stored message is displayed. It's very fast
and simple to use.
Brian.
--
______________________________________________________________
Brian Carroll, Ripon, N Yorks, UK briancarroll at f2s dot com
______________________________________________________________