HDTenEightyP/NetNews huggingface dataset:
From: gyan@unixg.ubc.ca (Gyan P. Sinha)
Subject: Re: import ascii
Keywords: ascii, 123
Organization: University of British Columbia, Vancouver, B.C., Canada
Date: Fri, 4 Sep 1992 19:29:36 GMT

In <Bu282G.FF2@nntp-sc.Intel.COM> crichmon@sedona.intel.com (Chris Richmond) writes:


>Hi,

>	I just loaded up 123W and was wondering how to import ascii data
>into the spreadsheet.  I have an older SS, and I'm pretty sure I could do
>that there.  I have a data aquisition system that I want to plot the data for.
>Are there any FTP sites with FAQ lists, etc??

>Thanks, Chris
>-- 
> Chris Richmond         |     Internet: crichmon@sedona.intel.com
> Intel, Corp. C3-21     |     Phone: (602)-554-8827
> 5000 W. Chandler Blvd. |     This crazy is a world place. 
> Chandler, AZ  85226    |     My think losing I'm mind.
> 
Since excel and 123W are quite similar in many respects, I'll tell you
what I do in excel. You just open the ascii file in excel, just like
you would any other file. You select the entire first column, and 
then go to DATA and then PARSE, from the the menu. If the column
seprarators in your ascii file are not screwed up somehow, asking
excel to guess at the appropriate columns is good enough. If you
like what it guesses, you select ok and it'll format it into
the right number of columns for you. You then save the file as
a normal spreadsheet file.

This has worked for me always except in one instance where it
screwed up the column demarcations for some rows. If your ascii
file is not large, eyeballing and hand fixing should suffice in
such an instance.

Look up help for the parse command in 123W. (or similar expression).

Hope this helps.

Gyan P. Sinha
UBC, Vancouver.
Newsgroups: comp.apps.spreadsheets
From: phalsema@x102a.ess.harris.com (halsema pb 64533)
Subject: Re: Help! Paste Special in Excel (v2.2, Mac)
Date: Tue, 25 Aug 1992 18:31:41 GMT
X-Newsreader: Tin 1.1 PL4
Organization: Harris ESS, Melbourne, Fla.

redgers@ee.ic.ac.uk (Adrian Redgers) writes:
: In MS Excel 2.2 for the Macintosh, after you've done a calculation and
: you want the the results - *not* the formulae - how do you get at them?
: 
: For example I might want to take the results and "Save As..." an MS
: Word document.  Currently I get the formulae :-{

Try doing "Save As..." and setting the file type to text (use the options
button to get at that).  This will save the values as tab delimited text.

: In MS Works there is a command called "Paste Special..." (spreadsheet, 
: Edit menu).  In Excel "Clear..." (Edit menu) looks a bit similar but
: clearing formulae clears the results as well.  Grrrr!

"Clear..." is used for just that, clearing fields.  "Paste Special..." can
be used to paste the values only (i.e. no formulas) into another worksheet.
This won't help you get into Word, unless you want to:
	 1) select range of interest
	 2) copy
	 3) go to a blank space or new worksheet
	 4) select "Paste Special..." values
	 5) copy
	 6) go to Word and paste
Depending on what you're doing either this approach or the save as 
approach will do the job.

   ---Paul
_______________________________________________________________   _________
Paul Halsema               \\      AT&T: (407) 729-3536          |  _   _  |
Harris Corp., GASD          \\ INTERNET:                         |_| |_| | |
MS 102-4827 PO Box 94000     \\   phalsema@x102a.ess.harris.com  |_/\/\/\|_|
Melbourne, FL 32902           \\                                 | |_| |_| |
_______________________________________________________________  |_________|
Newsgroups: comp.apps.spreadsheets
From: dmacneil@kean.ucs.mun.ca
Subject: AccPac and PC-NFS
Organization: Memorial University. St.John's Nfld, Canada
Date: Thu, 27 Aug 1992 13:01:20 GMT

My problem is not with a spreadsheet but hopefully there
is someone in this group using the same accounting
software as I am.

I'm having problems getting an accounting program called
AccPac (Computer Associates Ltd.) to run properly with
PC-NFS 4.0a and a SunSparc2 server.

Is anybody else using this program with PC-NFS 4.0a?

My specific problem seems to be with file locking and
sharing. AccPac does not support PC-NFS directly so
I'm caught in a bit af a void.

Any help would be greatly appreciated. Specifically with
directory protections on the SunSparc and the DOS setup on
the PC end.

Thanks.

-----------------------------------------------------------
David MacNeil
St.John's, Newfoundland, Canada
dmacneil@kean.ucs.mun.ca
Newsgroups: comp.apps.spreadsheets
From: lwv26@cas.org (Larry W. Virden)
Subject: SunOS Lotus 123 - GUI vs CUI
Reply-To: lvirden@cas.org (Larry W. Virden)
Organization: Nedriv Software and Shoe Shiners, Uninc.
Date: Wed, 26 Aug 1992 12:39:25 GMT

We have some users which need access to both the Character and Graphic
User Interface to Lotus on a Sun platform.  Can someone point me to the
appropriate doc for setting things up so they can get the version they
need appropriately?  Thanks!
-- 
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
America Online: lvirden@aol.com
Newsgroups: comp.apps.spreadsheets
From: crichmon@sedona.intel.com (Chris Richmond)
Subject: import ascii
Originator: crichmon@sedona
Keywords: ascii, 123
Reply-To: crichmon@sedona.intel.com
Organization: Intel Corporation
Date: Fri, 4 Sep 1992 15:23:03 GMT


Hi,

	I just loaded up 123W and was wondering how to import ascii data
into the spreadsheet.  I have an older SS, and I'm pretty sure I could do
that there.  I have a data aquisition system that I want to plot the data for.
Are there any FTP sites with FAQ lists, etc??

Thanks, Chris
-- 
 Chris Richmond         |     Internet: crichmon@sedona.intel.com
 Intel, Corp. C3-21     |     Phone: (602)-554-8827
 5000 W. Chandler Blvd. |     This crazy is a world place. 
 Chandler, AZ  85226    |     My think losing I'm mind.
 
Newsgroups: comp.apps.spreadsheets
From: joet@dcatlas.dot.gov (Joe Trott)
Subject: Re: Protecting end-points of a named range
Organization: U.S Dept. of Transportation
Distribution: comp.apps.spreadsheets
Date: Wed, 26 Aug 1992 12:57:33 GMT

ron@bert.cs.byu.edu (Ron Snyder) writes:

>SOFTWARE: Quattro Pro 3.01

>  I have some budget sheets that are used by several accountants
>in my department.  The budget have many(!) named ranges that are 
>accessed by other worksheets.  Today one of the area heads called 
>me because a summary worksheet that refers to these named ranges
>is giving the wrong answers (like ERR).  It didn't take long to 
>figure out that between he and his accountants, some of the endpoints
>of the named ranges had been inadvertently deleted while they were 
>'cleaning' up the budget worksheet.

>  Protecting those rows doesn't work, because sometimes those ranges 
>really _do_ need to be deleted, and I don't want them calling me 
>everytime they want to delete lines in the worksheet.  (They don't want
>that, either. :))

>  Ideally, Borland would have a "Hide Row" option that is similar to 
>the "Hide Column" option, so that I could hide the top and bottom of
>the named ranges, but I am 99% sure that this handy little gadget is
>a figment of my wishes.

I can think of two options.
1) place extra, blank rows (or rows with labels such as \-) in the range
   at the endpoints.  This won't work if the calling formulas cannot deal
   with blanks, but works for things like @sum.  You could also use some
   predetermined dummy values that the calling cell(s) would know to
   factor out of their formulas, like all zeros or all ones.
2) in WYSIWYG mode, you *can* "sort-of" hide a row, by changing its height
   to a ridiculously low number.

-JTT
From: ralf@usun01.UUCP (ralf)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Question for Excel users.
Date: 1 Sep 92 07:34:50 GMT
Organization: Nixdorf Computer AG, Paderborn, Germany

In <1992Aug25.164046.26564@newssrv.edvz.univie.ac.at> A4422DAB@vm.univie.ac.at (Erich Neuwirth) writes:

>What I need to know is how can I find out how many '5's I have in a
>row, or how many '7's I have in a row. I tried DCOUNT but only seems to
>work on columns and not rows. I tried to TRANSLATE the database and then
>use the out put to do a DCOUNT. This method fails if the numbers in the
>database change.

I think I have a solution for you.

>+=====+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+==
>|     | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R
>+=====+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+==
>| DA1 | 4 | 3 | 2 | 6 | 8 | 5 | 8 | 9 | 4 | 3 | 5 | 7 | 4 | 2 | 5 | 6 | 7 | 3
>+=====+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+==
>| DA2 | 3 | 4 | 2 | 3 | 4 | 5 | 7 | 9 | 8 | 9 | 4 | 9 | 0 | 3 | 2 | 5 | 7 | 3
>+=====+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+==
>| DA3 | 4 | 4 | 4 | 4 | 6 | 6 | 6 | 6 | 3 | 3 | 3 | 1 | 1 | 1 | 4 | 4 | 4 | 5
>+=====+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+==
Assuming that the column with your "DA1-3"s in column 1 means "Row 1-3" the
necessary formula will be:

{=sum(if(A1:R3=5;1))}

You might replace the "5" in the formula with an other number in an other cell.
Please note that you have not to enter the curly braces (it's an array-form.).
Enter the formula without them and finish the line with CTRL-SHIFT-ENTER.

I hope this will solve your problem.


MfG/Regards
---------------------------------------+----------------------------------------
Ralf Burghart                          | Phone: [nation | 0] 5251 8 25990
Siemens Nixdorf Informationssysteme AG | Fax  : [nation | 0] 5251 8 25889
IT-Service - Paderborn                 | CompuServe  : 73337,763
                                       | NET  : (usenet) burghart.kd@sni-usa.com
                                       |        (eunet) burghart.kd@sni.de
---------------------------------------+----------------------------------------
From: qqc@mace.cc.purdue.edu (Dm Forsyth)
Newsgroups: comp.apps.spreadsheets
Subject: making check catagory accumulations
Keywords: catagories quattro
Date: 28 Aug 92 15:53:30 GMT
Organization: Purdue University


Can anyone help me with a solution to this?  :
   I want to accumulate expense values by catagory.
I have a program with 4 columns for expense entries (literally checkbook
amounts).  Left of each column is a narrow column for a 1 or 0 as to
whether the amount has yet been reconciled (check back from bank).
I want to add additional columns (1 associated with each column of values)
in which to enter the expense catagory (probably numbers between 1 and 15).
The reason for so many columns is so 1 month's activity can be viewed on
one screen (though it does increase my work by 4X).

How can I get a columns values accumulated according to the value of another
column?  I thought of 2 schemes, but there should be a better way.
1)  created a separate @dsum( , , ) statement for EACH catagory value.  This
method also requires me to have a separate CRITERION TABLE for each @dsum.
If I do a database extract, I have that same exact problem.

2) create a separate @dsum( , , )-'previous cell'  and this keeps me from having
to have SEPARATE CRITERION TABLES (I can get by with one long one for each
value column).  But it still seems like a kludge.

What am I missing here, since this seems like an obvious thing to have been
done many times.

ps.  the 0's or 1's in front of the checks not returned are for a /database
extract procedure for accumulating and summing the outstanding values.  Works
nicely.
ppss and bye the way, this is in QUATTRO, but it's exactly like 123.

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Dale M. Forsyth |  Assoc. Prof. | Purdue University Animal Sciences
qqc@mace.cc.purdue.edu | phone 49-44841 | campus address 2-111 Lilly
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
Newsgroups: comp.apps.spreadsheets
From: ben@nynexst.com
Subject: Public domain spreadsheets
Reply-To: ben@nynexst.com
Organization: Nynex Science & Technology
Date: Fri, 28 Aug 92 17:28:06 GMT

I am looking for public domain spreadsheets. I do not know very much about them
so I do not know what sort of features are desirable. So far I ahve found sc version6.12 
and oleo which was last changed in 1990 and I got it from 
 prep.ai.mit.edu 

Anyone know of any newer or better public domain spreadsheets than these?

Thanks in advance,

Ben Chigier
ben@nynexst.com
From: maria@acpub.duke.edu (Maria Spicer)
Newsgroups: comp.apps.spreadsheets
Subject: Re: help: 123 data table, @dsum()
Summary: Using /data table on "continuous"-type data
Date: 26 Aug 92 21:28:20 GMT
Organization: Duke University; Durham, N.C.

Hi Dave!

I have run up against this problem in the past when trying to make data
tables of SEX vs. AGE, where I wanted AGE to be say, <18, 18-25, 26-30, 
etc., much as you want your dates to be 15Jun92-14Jul92, 15Jul92-14Aug92,
etc., as I understand it.  The only solution I was ever able to come up
with was to create another column next to the AGE column, called "AGEGRP",
where I used a lookup table to assign values based on which range the age
fell into.  For example:

  |  A   |   B   |   C   |   D   |   E   |
--|------|-------|-------|-------|-------|
1 | AGE  | AGEGrp|       | lookup table  |
2 |  15  |   1   |       |  17   |   1   |
3 |  22  |   2   |       |  25   |   2   |
4 |  21  |   2   |       |  30   |   3   |
5 |  43  |   6   |       |  35   |   4   |
6 |  17  |   1   |       |  40   |   5   |
7 |  39  |   4   |       |  45   |   6   |

Where the formulas in column B would be fashioned after 
B2: @vlookup(A2,$table,1), and the range named "table" is 
D2..E7.  Having done this, you can run /Data Table on the
values in column B rather than column A, knowing that 
AgeGrp=1 means Age<18, AgeGrp=2 means Age is 18-25, etc.

This same idea could be applied to your date dilemma.
Use a formula to create a column of date values equal
to the 15th of every month for the given year.  Then use
the same sort of scheme to look up a DateGrp variable
and run your table on it.

There may be a more succinct solution out there, but I haven't
found it.  Send me E-Mail if you want more help with this one.

Have fun!
Maria

-- 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^   Maria Spicer, DP Specialist		maria@soc.duke.edu           ^
^   140 Soc-Psych Bldg			919-660-5602                 ^
^   Duke University, Durham, NC		919-660-4317                 ^
Newsgroups: comp.apps.spreadsheets,comp.graphics,comp.graphics.avs,comp.graphics.explorer,comp.graphics.visualization,news.groups
From: d-lewart@uiuc.edu (Daniel S. Lewart)
Subject: Straw Poll on Gnuplot newsgroup name
Originator: dslg0849@uxa.cso.uiuc.edu
Reply-To: d-lewart@uiuc.edu (Daniel S. Lewart)
Followup-To: news.groups
Organization: University of Illinois at Urbana
Date: Wed, 26 Aug 1992 20:48:42 GMT

These are the comp.apps and comp.graphics branches of the USENET hierarchy:
-------------------------------------------------------------------------------
comp.apps.spreadsheets	Spreadsheets on various platforms.
comp.graphics		Computer graphics, art, animation, image processing.
comp.graphics.avs	The Application Visualization System.
comp.graphics.explorer	The Explorer Modular Visualisation Environment (MVE).
comp.graphics.research	Highly technical computer graphics discussion. (Moderate
comp.graphics.visualization	Info on scientific visualization.
-------------------------------------------------------------------------------

This is a preferential straw poll so we can finally pick a name and have
a vote.  There are three candidates:
	comp.apps.gnuplot
	comp.apps.graphics.gnuplot
	comp.graphics.gnuplot
Of course, write-ins will be counted too.  Please cut out and edit the
section below and email it to me.

Remember email/reply for straw poll and follow-up to news.groups for further
discussion.

Thank you,
Daniel Lewart
d-lewart@uiuc.edu
----8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<---
My votes for Gnuplot group names (1=favorite, 2=second favorite, ...) are:
1)
2)
3)

My name is
My email address is
----8<--------8<--------8<--------8<--------8<--------8<--------8<--------8<---
Newsgroups: comp.apps.spreadsheets
From: cmr@world.std.com (Charles M Richmond)
Subject: Re: 123: postscript output?
Keywords: lotus
Organization: Integrated International Systems Corp. One Longfellow Place, Suite 3309, Boston, Ma.
Date: Wed, 26 Aug 1992 21:20:48 GMT

mrr1@Ra.MsState.Edu (mark r rauschkolb) writes:

>	I've seen a minor mention of postscript in the manual, but it doesn't explain
>how to output a postscript file.  Is it possible?  How Do I do it?

>Thanks

>Mark
>mrr1@isis.msstate.edu


/  print  encoded   


In otherwords print to an encoded file.

Charlie

-- 
*****************************************************************************
*  Charles Richmond 	Integrated International Systems Corporation        *
*  cmr@world.std.com	(Temporary) cmr@chiechan.mro4.dec.com		    *
*  Specializing in UNIX, X, Image Processing, and Communications.           *
From: maria@acpub.duke.edu (Maria Spicer)
Newsgroups: comp.apps.spreadsheets
Subject: Re: 123: postscript output?
Keywords: lotus
Date: 28 Aug 92 14:04:45 GMT
Organization: Duke University; Durham, N.C.

The question raised was how to print to a Postscript file in 123, but
the original poster did not mention which version.  The currently
available version for UNIX has the / Print Encoded option, but if you're
using a PC version, you don't have that.  Instead, you must have the
generic Postscript printer installed (use the install program to add it,
if you don't), and then select it as the printer of choice in / Worksheet
Global Defaults Printer Name, then do / Print File.

--M.
-- 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
^   Maria Spicer, DP Specialist		maria@soc.duke.edu           ^
^   140 Soc-Psych Bldg			919-660-5602                 ^
^   Duke University, Durham, NC		919-660-4317                 ^
Xref: sparky comp.ivideodisc:159 comp.multimedia:2591
From: milne@ics.uci.edu (Alastair Milne)
Newsgroups: comp.ivideodisc,comp.multimedia
Subject: (none)
Date: 4 Sep 92 03:13:06 GMT


   Hello,

   The clients whose multimedia project we are creating are
   looking for opinions on these two multimedia boards.
   Video Blaster I've heard a bit about, enough to suppose
   it's getting somewhat popular.  Super Video Windows is
   new to me -- is this something for use with Windows 3.1?
   (is it even in fact hardware???)

   At present, the project (a set of 10 multimedia programs
   using conversational interactions to help teach Japanese)
   is on IBM's M-Motion card.  But we want to be flexible
   about the delivery vehicle, especially since the people most
   likely to want the project will be the least likely to be
   able to buy expensive equipment -- university language
   departments are the main target.  So our clients are
   very interested in knowing whether these boards are popular
   enough to warrant a bit of additional expense to make
   the Japanese program portable to them.


   Any responses, opinions, experiences, anecdotes, price
   lists, recommendations, praises, cautions, warning, full sets
   of literature on either :-) are welcome.  Particularly, if anybody
   has the manufacturer's addresses for either, that would be very welcome.

   Naturally, if there is enough interest, I will summarise
   for the newsgroup.


   Many thanks in advance,

   Alastair Milne,
   Technical manager,
   Educational Technology Center,
   U. Calif. Irvine
From: Rick_McCormack@mindlink.bc.ca (Rick McCormack)
Newsgroups: comp.ivideodisc
Subject: ? Magazines covering multi-media?
Date: 28 Aug 92 22:36:00 GMT
Organization: MIND LINK! - British Columbia, Canada
Distribution: world

Well, Murphy was RIGHT! I threw out a few files last week, and
today discovered that one I need now was among the casualties.

Could someone send me a copy of the list of magazines that deal
specifically with multimedia?

OR

Point me to an ftp site where such a list lives?

[Abject apologies for stupid behaviour which makes this posting
necessary. And abundant thanks for answers to this quest. :-)  ]

Rick McCormack
--

 _________________________________________________________
| IMAGISTICS Business Theatre Technology | Rick McCormack |
|  Interactive   Effective   Compelling  | Vancouver,  BC |
|________________________________________|________________|
|  UseNet: Rick_McCormack@mindlink.bc.ca |  A O-L: Rique  |
|_________________________________________________________|
From: chrisl@cbmvax.commodore.com (Christian Ludwig - CATS)
Newsgroups: comp.ivideodisc
Subject: Re: WANTED: MCA Discovision
Date: 27 Aug 92 21:07:29 GMT
Organization: Commodore, West Chester, PA

bovine@engin.umich.edu (Mitchell Rohde) writes:
> 
>   Why, you ask?  
> 
>   I do have a more modern machine... but I am currently in the
>  process of fixing a DRAGONS LAIR video arcade machine... it uses
>  one.  If I cannot find one, I will have to interface the 
>  electronics from the game to a new disk player... the discovision
>  had a data port on the back...

I'm sure that there was an AmigaVision flow (AV talk for "program")
in the PD that let an Amiga (running AmigaVision) hooked up to any
old RS232 player behave just like the arcade game.

If you can't find a "real" player, this is probably your best bet.  You could
use nearly any Amiga that had 1.5 meg or greater RAM.


     /// Christian Ludwig - Commodore CATS    (chrisl@cbmvax.commodore.com)
    ///
\\\///   The opinions expressed may not reflect the official position of my
 \XX/    employer.   (Of course that depends on which position they're in!)

Newsgroups: comp.patents
From: William Humphries <humphrie@ssc.wisc.edu>
Subject: [ADMIN] Comp.patents FAQ
Organization: Basser Dept of Computer Science, University of Sydney, Australia
Date: Thu, 27 Aug 1992 17:53:53 GMT


A follow up to a question in the FAQ about "is construction of infringing
devices for user's own amusement."

>From case law:
	"As early as 1813, Justice Story had carved out an execption to
	the prohibition against 'use,' called the experimental use exemption.
	If the patented article was made or used for philisophical purposes (
	today we would substitue purely scientific), amusement or curiosity
	purposes, it was not actionable."

	Whittemore v. Cutter, 29 F. Cas. 1120 (CCD Mass 1813), op cite in
	Krulwicvh, "Statutory Reversal of Roche v. Bolar", Food Drug
	Cosmetic Law Journal, 40, 519-525 (1985).

When Roche Products sued Bolar (a generic drug manufacturer) for infringing
their patent on Dalmane, Bolar claimed that their use of the active ingre-
dient was strictly intended for obtaining FDA approval of the generic
form of Dalmane once Roche's patent expired. Bolar's defense was while
using the active ingredient for obtaining FDA approval to market Dalmane
was not exactly the exception Justice Story described, the Story exception
did leave space for Judicial interpretation.

The appelate court did not agree, but that's moot since the Waxman-Hatch
Amendments to the Food and Drug Act were enacted in 1984.

Bill Humphries
Graduate Student
Department of Economics, UW Madison
humphrie@ssc.wisc.edu
608-262-4543

[mod- I shall include this in the FAQ...]
Newsgroups: comp.patents