HDTenEightyP/NetNews huggingface dataset:
From: fbaglew@cs-acad-lan.Lakeheadu.Ca (Richard Glew)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Totals by Catagories?
Date: 6 Nov 1992 20:58:23 GMT
Organization: Lakehead University

In article <92310.110359J0S@psuvm.psu.edu> J0S@psuvm.psu.edu (Jack W. Sharer) writes:

>I have a spread sheet with item amounts in column G and catagories
>in column F.  I've sorted the rows using column F as the key.
>I need to have partial totals of the amounts in column G for each
>catagory in column G.  I've been entering the @SUM(G1..G13),
>@SUM(G14..G17), ... formulas by hand in the "break" rows of column
>H.  (A "break" row is one in which column F changes to a new catagory.)
>This process has become very tedious.  Could you suggest a Quattro
>MACRO which would automate this process?
>Thanks!


In Lotus I use  @DSUM(INPUT,COLUMN,CRITERIA) to do this sort of work.
From: tvh@gnv.ifas.ufl.edu
Newsgroups: comp.apps.spreadsheets
Subject: qpro 4.0 binary sort problem
Date: 9 Nov 92 16:51:04 -0500

Hopefully someone can help me with this problem.  I have approx. 6100 binary
data sets that I need to sort.  However, I only need those sets that are
dissemilar, for many are equal to each other.  Any suggests on how to 
accomplish this, and possibly determine how many of each data set their were
for each type?  Thanks, in advance.
			Tony V. Harrison
From: udarryl@mcl.ucsb.edu (Darryl 'Well)
Newsgroups: comp.apps.spreadsheets
Subject: Excel macro help! !pleh orcam lecxE
Summary: Please help me write a macro to flip text around...
Keywords: macro flip excel help writing stupid
Date: 6 Nov 92 10:21:34 GMT

hey Excel studs and studettes--here's a puzzler for y'all...

once upon a time, in Excel 3.0, i wrote a macro that let me "flip"
text around so that it would read backwards.  e.g. a cell with the
following formula:

=flipit("hello there")

would result in "ereht olleh"

the reason i wanted to do this is so that i could extract the last
word of a string. So the trick was, flip the text around, find the
first word (all the characters up to a space), then flip the text back
around. All this trouble because the find command isn't able to start
at a certain location and work it's way back.

somewhere between then and now, i lost the aforementioned macro.  

it may sound like a pain, but it helps when you're doing data entry.

Instead of having to key in a separate Title (Mr.), First Name,
(Darryl), and Last Name (Lee), you can simply type "Mr. Darryl Lee",
and then derive the following:

a last name (to do sorts upon), and...
a salutation, (like "Mr. Lee")

ANYWAYS, right nowm, my macro looks like this:

A1     flipit
A2     =ARGUMENT("tex",2)
A3     =FOR("count",1,LEN(tex),1)
A4     =count
A5     =(LEN(tex)+1)-count
A6     =REPLACE(tex,count,1,MID(tex,(LEN(tex)+1)-count,1))
A7     =NEXT()
A8     =tex
A9     =RETURN(A6)

(cells a4, and a8, are strictly for debugging purposes, unless you can
think of a better use for them)

but what i get when i type:
=flipit("hello there")

is:
hello therh

if you display values on the macro sheet when this is running, and
give it a really long test, like "hello there everyone in Texas",
you'll see cell A6 run through and replace every letter, but after
each replacement it begins anew with the untouched string.  obviously
i need a temporary variable, but in function macros, the formula
function isn't allowed.

For the life of me i can't figure out how i did it before.  if you can
help, or even find a better way to do it, i'd love to hear from you.

thanks for your time.  please e-mail a response to:
--
-------------------------------cut here--------------------------------------
"Girls are like parking spaces--all the good ones are already taken" --Anlo Liu
"Everywhere I go, it seems to say `no parking'" --Jimmy Yu
Darryl Lee, UC Santa Barbara		     		   udarryl@mcl.ucsb.edu
From: cids05@vaxa.strath.ac.uk (Dr Stephen K Tagg)
Newsgroups: comp.apps.spreadsheets
Subject: Re: @RISK for EXCEL 4.0
Date: 10 Nov 92 10:17:07 GMT
Organization: Univ of Strathclyde, GLASGOW, SCOTLAND

In article <p.foster.35.721296630@fs3.mbs.ac.uk>, 
p.foster@fs3.mbs.ac.uk (Peter Foster) writes:
> Hello all
> 
> I recently placed a notice in this area concerning an add-in for EXCEL 4.0 
> called @RISK. I did get a response but the packages etc. recommended were 
> for the Macintosh! I need this add-in for EXCEL 4.0 for a PC.
> 
Personal Computer Magazine (UK) March 1992 pages 174-183 had a whole comparison
of risk analysis systems including a pointer to @risk, mentioning excel 4.0 for
a PC. The suplier is 4-5-6 world at 0206 44456
I've just phoned them and they're sending me a demo.
The current price is 395 pounds.
-- 
Dr Stephen K Tagg                   Bsc in Psychology, PhD in Architecture
Lecturer, Department of Marketing   IT & Stats for Marketing, Consumer Research
Univ of Strathclyde, GLASGOW        Mental Maps, Multidimensional Scaling, CSCW
G4 0RQ, SCOTLAND Tel 041-552-4400x2409 Fax 552 2802 Email s.k.tagg@uk.ac.strath
Newsgroups: comp.apps.spreadsheets
From: A4422DAB@vm.univie.ac.at (Erich Neuwirth)
Subject: Re: Totals by Catagories?
Organization: University of Vienna
Date: Tue, 10 Nov 1992 15:33:11 GMT

------------------------- Original Article -------------------------
In article <92310.110359J0S@psuvm.psu.edu> J0S@psuvm.psu.edu (Jack W. Sharer) wr

>I have a spread sheet with item amounts in column G and catagories
>in column F.  I've sorted the rows using column F as the key.
>I need to have partial totals of the amounts in column G for each
>catagory in column G.  I've been entering the @SUM(G1..G13),
>@SUM(G14..G17), ... formulas by hand in the "break" rows of column
>H.  (A "break" row is one in which column F changes to a new catagory.)
>This process has become very tedious.  Could you suggest a Quattro
>MACRO which would automate this process?
>Thanks!


> n Lotus I use  @DSUM(INPUT,COLUMN,CRITERIA) to do this sort of work.

in AsEasyAs, a very good Lotus clone with some added functionality
you can do @QSUM("@X=1",range) ore something similar
which allows you to put the selection criterion into the formula
instead of putting it into a criteria range in the sheet.
you have to get the latest version to get this, it is 5.01R
and it is available from simtel and its mirrors in
<msdos.spreadsheets>
From: lakerb@rcwusr.bp.com
Newsgroups: comp.apps.spreadsheets
Subject: Re: RISK for EXCEL 4.00
Date: 5 Nov 92 09:15:56 -0600
Organization: BP Research, Cleveland, OH (USA)

In article <p.foster.15.720714980@fs3.mbs.ac.uk>, p.foster@fs3.mbs.ac.uk (Peter Foster) writes:
> Hello Netters
> 
> Can anyone tell me where (or even if) can I get RISK for Excel ver 4.00.
> 
> I have seen this add-in for 123 for Windows but as I have now upgraded I was 
> wondering whether I could still use this add-in.
> 
> Yours
> 
> Peter Foster
> ################################################################
> # Peter Foster                                                 #
> # Manchester Business School                                   #
> # Manchester, England.                                         #
> #                                                              #
> # E-mail Address:- p.foster%uk.ac.mbs.fs3@cns.umist.ac.uk      #
> #                                                              #
> #           "..Smile, it may never happen!!..."                #
> ################################################################

The program, I believe, is "@RISK" from Palisade Corporation.  The box
indicates that @RISK for Mac Excel works on Mac Excel Version 3.0 or higher.

Palisade
31 Decker Road
Newfield, NY  14867
607-277-8000
FAX:  8001

Rob Lake
BP Research
lake@rcwcl1.dnet.bp.com

Newsgroups: comp.ivideodisc
From: "tony camara" <tony.camara@canrem.com>
Subject: our wedding
Reply-To: "tony camara" <tony.camara@canrem.com>
Organization: Canada Remote Systems
Distribution: comp
Date: 5 Nov 92 02:08:24 EST

I'm looking for a title calles our wedding . Has anyone ever heard of
it ? I'm looking for stuff with specific themes
ex:weddings,christmas,parties,baptizms etc. I''m running an amiga 1000
with 1.5 megs. ANy help would be great thanks .
--
Canada Remote Systems  - Toronto, Ontario
World's Largest PCBOARD System - 416-629-7000/629-7044
Newsgroups: comp.editors
From: boyd@prl.dec.com (Boyd Roberts)
Subject: Re: Anyone use SAM?
Organization: Digital Equipment Corporation - Paris Research Laboratory
Date: Wed, 11 Nov 1992 17:48:18 GMT

In article <721484846.9186@minster.york.ac.uk>, pete@minster.york.ac.uk writes:
> 
> Before I started using Sam I was a dedicated vi addict -- I still use vi for
> editing mail and so on, but for _writing_ on Unix boxes sam is the most 
> transparent tool I've ever come across.  
> 

I use it with mail via a mechanism where you can get it to edit a file
for you.  I set EDITOR to that and my MH like mail user agent invokes it.

Elsewhere, when I need to edit something I go:

    ; B file

B co-operates with sam to hand it a B command with file as an absolute pathname.


Boyd Roberts			boyd@prl.dec.com

``When the going gets wierd, the weird turn pro...''
From: msluyter@ponder.csci.unt.edu (Michael Sluyter)
Newsgroups: comp.editors
Subject: An Unusual question....
Date: 12 Nov 92 04:15:40 GMT
Organization: University of North Texas

Here's a question which may not belong in this group, but I wasn't sure where
else to post it.  It's a typing question.  Not being a formally trainded 
typist, I was wondering if anyone out there used their third finger on 'r'.
Normally I use my index finger, but the 'rt' combination is so frequent that
at times it seems easier to use the third finger on 'r' and then the index
on 't'.  Is there an "officially sanctioned" method?  Once again, my
apologies if there was a better place to post this question.  

Thanks,
Mike
Newsgroups: comp.editors
From: mikeg@asylum.tmc.edu (Michael Grabenstein)
Subject: Re: VI??? GROSS!
Organization: none
Date: Fri, 13 Nov 1992 15:28:21 GMT

	To move blocks around use the named buffers in vi. Then you
can have up to 26 little clipboards. (vi command: "ayy  Where
a is any lower case alpha letter and yy is the yank command.
Get it back by "ap See isn't that easy? :)

	Moving columns around??? What editor will unless it is a 
word processor that can do columns, then its easy. But in vi
my suggestions would be to use a seperate named buffer for each
line in the column and then place and join. (vi command for
getting jsut characters:  "ayl  a is the same as above and yl is
yank letters, getting easier? :)

	The vi editors that wait for esc to be pressed... Remember
that vi works very differently on different terms and it will
work on just about every term known. Plus every manufacuer of
Unix machines seems like they have to change something in vi
so there is some obscure little difference in theirs verses
Everyone elses.
Later,
	Mike
	mikeg@asylum.gsfc.nasa.gov
	or grabenst@umbc3.umbc.edu
Newsgroups: comp.editors
From: rohit@NeoSoft.com (Rohit Mehrotra)
Subject: Re: Brief info?
Organization: NeoSoft Communications Services -- (713) 684-5900
Date: Fri, 6 Nov 1992 21:08:02 GMT
Keywords: Brief

In article <Bx9twB.HEF@cmcl2.nyu.edu> snyder@acf3.nyu.edu (Kirk Snyder) writes:
>
>So far I've found out very little.  I found out that Borland is
>in fact selling it under the Borland name, and that there is a
>*very* cheap upgrade to the Borland version for existing Brief
>owners.  Something like $69.  I also got one recommendation to
>try Crisp instead, with the claim that it does everything Brief
>does and much more.  That's about it.

Some clarification on CRISP. CRISP is only available on UNIX platforms. It is
going to be available for NT in the very near future and maybe under 
WIN-3.1 - (big maybe).

And yes, it is true that CRISP does all that BRIEF does plus a ton more. It 
a full GUI product, however has a character version too. One can run existing
BRIEF macros in CRISP.

>enhancements I would want, but versions for Windows,
>Presentation Manager, or NT might be nice.  At least it would
>give me the feeling that the product will be around a while.
> 

I am sure it will, atleast under DOS, and then from their one can go ahead 
with CRISP.

-- 
Rohit Mehrotra
------------------------------------------------------------------------------
VITAL				| 	10755 Meadowglen Lane, #238
Ph: 713-781-7406		| 	Houston, TX 77042.
From: saverio@lorelei.ece.drexel.edu (Saverio Mercurio)
Newsgroups: comp.editors
Subject: vi FAQ?
Date: 8 Nov 92 22:06:16 GMT
Distribution: usa
Organization: Drexel University, Philadelphia PA


Subject pretty much says it all.  Is there an FAQ list for vi?  If so, where
can I get it?

Thanks in advance...

	-Saverio

saverio@lorelei.ece.drexel.edu
Newsgroups: comp.editors
From: bduncan@ve3ied.UUCP (Bill Duncan)
Subject: Re: Brief info?
Organization: TFMCS
Date: Thu, 5 Nov 1992 04:43:14 GMT
Keywords: Brief

In article <1992Oct28.225639.29556@cmcl2.nyu.edu> snyder@acf3.nyu.edu (Kirk Snyder) writes:
>Does anyone have any info/rumours/speculation on the status of
>Brief?  I know that it was bought by Borland.  I've seen it
>advertised in Programmer's Workshop for $99.  This seems like a
>bargain price.  I'm a bit curious about the reason for the
>bargain price.
> 
>Does Borland intend to continue it as an independent product, or
>incorporate it into their compiler packages?  Might Borland
>transfer parts of it to their compiler packages, and discard the
>rest?  If Borland intends to keep developing it, then the
>current price is a great deal.
> 
>-- Kirk Snyder
>   snyder@depaul.edu
>

I don't know, but am very curious too!  I have been a Brief user since v0.98,
probably around 10 years ago now.  Borland also got the "Sorcerer's Apprentice"
with the deal too of course.  I haven't seen it advertized since the buyout.

Please post a summary of anything you find out here.

Bill Duncan, (bduncan@ve3ied.uucp)
From: stephen@memex.co.uk (Stephen Marley)
Newsgroups: comp.editors
Subject: Re: How to quote % in vi/ex ': ' escape
Date: 6 Nov 92 15:18:57 GMT
Organization: Memex Information Systems Ltd., East Kilbride, Scotland
X-Newsreader: Tin 1.1 PL4

hansm@cs.kun.nl (Hans Mulder) writes:
: 
: ObQuiz: find a situation where you need to quote a character with \^V .
: 

What about substituting ^M for a real ctrl-M.   
eg.

    :%s/\^M/\^V^M/g

This might be useful for converting macros posted in news/mail for real use.
-- 
Stephen Marley
Memex Information Systems Ltd., East Kilbride, G75 0YN, Scotland, UK. 
stephen@memex.co.uk	  Tel: (03552) 33804     Fax: (03552) 39676
Newsgroups: comp.editors
From: ciacovel@telesciences.com (Chris D Iacovelli)
Subject: Re: How to quote % in vi/ex ': ' escape
Organization: TeleSciences CO Systems, Inc.
Date: Tue, 10 Nov 1992 19:09:30 GMT

In article <heinz.689356033@marvin.tuwien.ac.at> heinz@marvin.tuwien.ac.at (Heinz Herbeck) writes:
>Sorry if this is in the FAQ or has been discussed here already. I can vaguely
>remember having read about this problem before, but I can't find any 
>articles about it in my archives (and I can't find the FAQ either).
>
>How can I insert a % into a ':' command in vi, without it being replaced by
>the current filename ?
>For example, I have a file test.c% in my directory, and want to read it into
>the buffer with
>
>:r test.c%
>
>or edit it with
>
>:e test.c%
>
>^V% and ^V^V% don't work.
>
>And, in the same way, how to quote # ?
>
>Any help or hint will be appreciated.
>
>MfG
>HH
>-- 
>- Heinz M. HERBECK       heinz@marvin.tuwien.ac.at       Tel. +43 1 58801-4107 -
>- Technical University of Vienna, Austria  //  Institute for Computer Graphics -
>- Hardware, n. : The part of a computer system that can be kicked.             -

Try using the back slash, \.
This usally works for me.

Hope this helps.

C. Iacovelli
Member, Technical Staff
Telesciences CO Systems
ciacovel@telesciences.com
From: kng@pt.com (Ken Gravenstede)
Newsgroups: comp.editors
Subject: ftp access
Date: 10 Nov 92 22:15:27 GMT
Distribution: usa
Organization: Performance Technologies, Incorporated

I seem to have lost my info on 'ftp mailers'.  If you have info on any please
email to me so that I may once again be able to do 'pseudo anonomous ftp.'

Thanks in advance.

Ken
-- 
__
Ken Gravenstede, Performance Technologies Incorporated	kng@pt.com
315 Science Parkway, Rochester, New York 14620            uupsi!ptsys1!kng
From: aris@lasernet.co.za (Aris Stathakis)
Newsgroups: comp.editors
Subject: Re: Anyone use SAM?
Date: 11 Nov 92 21:14:18 GMT
Article-I.D.: lasernet.1992Nov11.211418.5802
Organization: Lasernet (Pty) Ltd.

In <BEVAN.92Nov9202641@tiger.cs.man.ac.uk> bevan@cs.man.ac.uk (Stephen J Bevan) writes:

>In article <OZ.92Nov6170912@ursa.sis.yorku.ca> oz@ursa.sis.yorku.ca (Ozan Yigit) writes:
>   Neil Weisenfeld writes:
>      Is anyone using Sam? ...

>   Yes, many of us picked it up from the toolchest sometime ago. Nice to see
>   that it is now available to public at large.

When I asked Dennis Ritchie what editor he uses, he said "Sam" :-)

Aris

-- 
Aris Stathakis        Tel:+27 11 887 4220 |Gimme a beer and money sandwich -  
SCO Unix Support      Fax:+27 11 887 1141 |Hold the bread. - Waldo D.R. Dobbs
Lasernet (Pty) Ltd    X25: 06550 11642692 |_________________________________
P.O. Box 78446, Sandton, 2146, R.S.A       Internet: aris@lasernet.co.za
From: hansm@cs.kun.nl (Hans Mulder)
Newsgroups: comp.editors
Subject: Re: How to quote % in vi/ex ': ' escape
Date: 5 Nov 92 17:32:14 GMT
Organization: University of Nijmegen, The Netherlands

In <heinz.689356033@marvin.tuwien.ac.at> heinz@marvin.tuwien.ac.at (Heinz Herbeck) writes:
>How can I insert a % into a ':' command in vi, without it being replaced by
>the current filename ?

>^V% and ^V^V% don't work.

But \% does.

>And, in the same way, how to quote # ?

Similarly: \# .

ObQuiz: find a situation where you need to quote a character with \^V .

--
Have a nice day,

Hans Mulder			hansm@cs.kun.nl
Newsgroups: comp.editors
From: john@storcon.UUCP (John Hunley)
Subject: aXe on RS/6000
Date: Mon, 9 Nov 1992 18:00:58 GMT
Organization: Storage Concepts, Inc.
Keywords: aXe RS6000 AIX

Anybody got aXe (preferably version 3.0.1) running under AIX 3.2 on an RS6000?
From all the porting problems I've seen with aXe and what I know about porting
things to AIX, I don't think I want to tackle it myself (my employer seems to
always want me to work on other things!).
-- 
                            John Hunley
   Storage Concepts, Inc.                  UUCP:  uunet!storcon!john
   1622 Deere Ave.                        Voice:  (714) 852-8511
   Irvine, CA  92714                        FAX:  (714) 557-5064
From: jeffb@csd4.csd.uwm.edu (Jeff Bartig)
Newsgroups: comp.editors
Subject: Re: Brief info?
Date: 10 Nov 1992 19:35:16 GMT
Organization: Computing Services Division, University of Wisconsin - Milwaukee
Distribution: inet
NNTP-Posting-Host: 129.89.7.4
Keywords: Brief

In article <1992Nov10.023030.22823@tous.oau.org> rbt@tous.oau.org (Robert B. Tate) writes:
>>I was on Borland's BBS recently and saw an area for something called
>
>I know about the Compuserve BBS (I'm not a member anymore), but what is
>this other BBS number? I would like to see what is out there for BRIEF.

Borland's BBS phone number is:

		(408) 439-9096
		8 data, 1 stop, no parity
		12/24/96 (I think)

This info is in the READ.ME file that has been included with every
Borland product I've ever purchased.  Brief was located under the
programming section of the BBS.

You might also want to give their TechFax number a try, if you have
a fax machine.  The number is (800) 822-4269.  It is an automated
system that lets you enter a list of document numbers, and it will
send them to your fax machine (Borland pays the phone bill).  You
can have it send you an index of documents, so you will know what is
available.

Jeff

-- 
Jeff Bartig, Dept Programmer | Office: (608) 262-5631
UW-Madison Psychology Dept   | Fax:    (608) 262-4029
1202 W. Johnson St, Rm B29   |
Madison, WI 53706-1611       | E-Mail: jeffb@merlin.psych.wisc.edu
Newsgroups: comp.editors
From: lwv26@cas.org (Larry W. Virden)
Subject: Re: VI??? GROSS!
Followup-To: comp.editors
Reply-To: lvirden@cas.org (Larry W. Virden)
Organization: Nedriv Software and Shoe Shiners, Uninc.
Date: Fri, 13 Nov 1992 12:39:26 GMT

Is it to much to ask folk to hold their flames for either email, or even 
better, write them only for their own amusement?

For instance, in this latest missage, we are told that the original poster 
should:

> It's good that people are still writing editors -- heck, I'm doing it
> myself -- but don't post treatises on editors that you obviously don't
> know about in order to hype your own.

Yes the poster obviously either didn't understand the original msg or
was so consumed by the need to flame that he missed the fact that:

a) in certain modes of operations, vi does indeed hold off updates until
the escape key is pressed

and 

b) vi does indeed not EASILY permit "arbitrary blocks of text".  For instance,
there is no single simple _vi_ command to allow one to take text such as:


Time		Cost		Purpose

4 mins		$2.50		Cycles of processing
2.5 mins	$1.75		Pages of print

and place the Cost column before the Time column.  Columns are what most
people mean when they describe arbitrary blocks of text - not pieces of
a single line or entire lines.




-- 
Larry W. Virden                 UUCP: osu-cis!chemabs!lvirden
Same Mbox: BITNET: lvirden@cas  INET: lvirden@cas.org
Personal: 674 Falls Place,   Reynoldsburg, OH 43068-1614
Newsgroups: comp.editors
From: cheevers@wolf.cs.wisc.edu (John Cheevers)
Subject: Re: VI??? GROSS!
Organization: University of Wisconsin, Madison -- Computer Sciences Dept.
Date: Fri, 13 Nov 1992 19:28:31 GMT

mikeg@asylum.tmc.edu (Michael Grabenstein) writes:
>	Moving columns around??? What editor will unless it is a 
>word processor that can do columns, then its easy. But in vi
>my suggestions would be to use a seperate named buffer for each
>line in the column and then place and join. (vi command for
 ^^^^ word?
>getting jsut characters:  "ayl  a is the same as above and yl is
>yank letters, getting easier? :)

This could give you problems with lining up columns.
An easier way is to pipe the paragraph through awk:

	!} awk '{ printf "\%10s\%10s\%20s\n", $3, $2, $1}'

    or  :10,14 ! awk '{ printf "\%10s\%10s\%20s\n", $3, $2, $1}'

John Cheevers
cheevers@cs.wisc.edu
Newsgroups: comp.editors
From: peschko@guppy.micro.umn.edu (Edward Peschko)
Subject: 'set'ing options in vi.....
Organization: University of Minnesota, Minneapolis: Under Grad Workstation Lab.
Date: Sat, 7 Nov 1992 18:38:24 GMT

hello ---

I was wondering...

as far as the 'set' options are concerned ('set all' giving a list)...
How do you set it so they permanently come up without having to type them in 
constantly??? Also, what are some useful ones to implement? And how do you
make it so they print out to a laser printer in the same way that you have 
specified by your 'set all' commands?


Thanks much... 
(email preferred but not essential...)

Ed Peschko