HDTenEightyP/NetNews huggingface dataset:
From: Sparky
Newsgroups: comp.apps.spreadsheets
Subject: Re: Excel Macro's help needed!  :)
Date: 14 Aug 92 12:12:35 GMT
Organization: None Worth Mentioning

In article <1992Aug12.174812.15658@cbnewsk.cb.att.com> ayf@pruxp.att.com (Avi
Feldblum) writes:
>Hi,
>
>I'm new to this group and am looking for some excel guru's to ask
>questions of. Here's a basic description of what I am trying to do and
>if anyone thinks they may be able to give me a hand I would appreciate
>it.
>
>I am using Excel 4.0 for Windows. I've set up a workbook (.xlw) that
>contains (at least) four files. One is a macro sheet that contains all
>the macros that I need to use, cmodel.xlm, the second is a database of
>parts, parts.xls, the third is the spreadsheet that the user wants
>filled out, product.xls, and the fourth is just a README file to give
>some info on what the workbook does and to use it.
>
>The basic mode of operation is that the user will list a sequence of
>numbers in column A of the worksheet, and then run a macro that copies
>a series of formulas across the row based on the "class" of the number
>(e.g. 0, <1000, <10000), then takes the actual number and goes out to
>the database worksheet and extracts some data that relates to that
>specific part.
>
>One problem I am running into now is that the formulas may depend on
>something like a tax rate, so I would like to define that as a defined
>name and then the formula would be something like say
>F23*Tax_Rate. What I am finding is that each time it copies that
>formula in, it askes me if I want to use the existing definition of
>that named variable. If there are 30-100 such lines and several such
>variables it drives one crazy. 
>
>So if you have experience writing macros in excel and would be willing
>to answer some questions, please let me know. If you are willing/able
>to respond to emailed questions or take a phone call, please let me
>know.
>
>Thanks in advance.
>
>Avi Feldblum
>AT&T
>avi_feldblum@att.com
>215-939-3748
>

I'll be happy to respond to you via internet (I don't have mail access), but
cannot commit to giving phone advice.  (I'm a consultant and get paid for my
time.)

In answer to your specific problem, try turning error checking off,
"=ERROR(FALSE)", immediately before pasting, then back on again.  This usually
supresses Excel's messaging.

More importantly, using COPY()/PASTE() in macros really gums up the works.  Try
using the OFFSET() function instead.  It effectively copies and pastes, but is
MUCH faster.

Good luck!

-- Sparky
Newsgroups: comp.apps.spreadsheets
From: kdesai@brtph490.NoSubdomain.NoDomain (Kalpit Desai P265)
Subject: Question for Excel users.
Reply-To: kdesai@bnr.ca
Organization: BNR Inc., RTP, NC 27709
Distribution: usa
Date: Thu, 13 Aug 92 13:22:05 GMT

I am new to Excel and have a problem. The problem is that I have 
data that is laid across rows of the spreadsheet. i.e

+=====+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+==
|     | 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
+=====+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+===+==

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. 

What I need is a mechanism to count the number of occurances in a row of
a particular number. The HISTOGRAM plots the data nicely but what I want
is to put the count into another cell.

Appreciate any help.

-- 
+----------------+------------------------------+------------------------+
| Kalpit Desai   |          BNR Inc.,           |  Voice: (919) 991 7902 |
| kdesai@bnr.ca  |     Research Triangle Park   |  FAX:   (919) 991 7001 |
|                |  North Carolina 27709, U.S.A |  ESN:         294 7902 |
+----------------+------------------------------+------------------------+
Newsgroups: comp.apps.spreadsheets
From: mrr1@Ra.MsState.Edu (mark r rauschkolb)
Subject: 123: postscript output?
Keywords: lotus
Reply-To: mrr1@Ra.MsState.Edu
Organization: Mississippi State University
Date: Wed, 19 Aug 1992 18:46:16 GMT

	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
From: userDHAL@mts.ucs.UAlberta.CA (David Halliwell)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Protecting end-points of a named range
Date: 20 Aug 92 23:15:41 GMT
Distribution: comp.apps.spreadsheets
Organization: University Of Alberta, Edmonton Canada

thompson@atlas.socsci.umn.edu (T. Scott Thompson) writes:

>I only use Quattro for my own work, so my "dummy-proofing" is of a very
>personal variety!  However, the following has worked well for me:

>To protect the top and bottom of a COLUMN range, I simply add a cell
>to the top and bottom, include those cells in the range, and
>(optionally) insert something in them that the numeric functions will
>ignore (like a label).  

    Unfortunately, a rather large number of numerical functions do not
ignore labels: they treat them as if they are a valid number with a value
of zero. IMHO this is a major disadvantage of spreadsheets for any serious
numerical work. I would think that the only safe option in your solution
would be the completely blank cell. Is there another trick that you can
use to prevent this problem?

>                        Then I protect just the two "guard cells".  I
>end up with something like this:


>              1      2      3
>         A        -------
>         B          1.2
>         C          3.4
>         D          5.6
>         E        -------
>         F         10.2

>Here I would make A2-E2 be the named range. (Say "DATA") I put the
>labels "/-" in A2 and in E2, which are protected.  B2-D2 are not
>protected, so that they can be erased, deleted, etc.  Cell F2 might
>have something like @SUM(DATA), which simply ignores the labels in A2
>and E2.

   Yes, the @SUM would give the correct total, but @AVG or @COUNT will
think that 5 values are present.

>This scheme also makes it easy to add an extra cell to the top or
>bottom of the range and have it be included in the range
>automatically.

>The same scheme should also work for ROW ranges.  If you do this then
>you can evey use "Hide Column" to prevent the columns corresponding to
>A2 and E2 in the example from showing up.

    This would also make it very easy to leave the cell completely blank,
so all functions will work in the expected way.



Dave Halliwell
Department of Geography
University of Alberta
Edmonton, Alberta
Newsgroups: comp.apps.spreadsheets
From: mrr1@Ra.MsState.Edu (mark r rauschkolb)
Subject: Lotus Question: Calc for 2-3 min when first run?
Reply-To: mrr1@Ra.MsState.Edu
Organization: Mississippi State University
Date: Wed, 19 Aug 1992 18:53:47 GMT

   I have version 3.1 (dos) and when I first enter the program (entering 123 on the
command line) the CALC indicator lights up and it takes 2-3 minutes before I can
type anything.  

WHY?

Thanks
Mark
mrr1@isis.msstate.edu


Newsgroups: comp.apps.spreadsheets
From: ron@bert.cs.byu.edu (Ron Snyder)
Subject: Protecting end-points of a named range
Organization: BYU Computer Science
Distribution: comp.apps.spreadsheets
Date: 19 Aug 92 11:58:27

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.

  If you have had this problem, how did you overcome it?  (Yeah, I know
the best answer is to educate my users, but I feel like this problem
falls into the realm of "dummy-proofing".)

  Thanks in advance for any help you can give me!

--
Ron Snyder <ron@bert.cs.byu.edu>   <snyderrj@coned1.byu.edu>
****************************************************************
Newsgroups: comp.apps.spreadsheets
From: Rick Blaiklock <rmb@bnr.ca>
Subject: Re: calculating interest
Organization: Bell-Northern Research Ltd.
X-Useragent: Nuntius v1.1
Date: Wed, 19 Aug 1992 14:17:00 GMT


In article <2A911B88.4215@orion.oac.uci.edu> Richard Myers,
rmyers@dec5200.acs.uci.edu writes:
>Posted on behalf of a friend:
>Using excel, I want to find the rate of return on an investment where
>I deposit $1000/month for 10 years and wind up with $200,000.


Using the Rate formuala in Excel provides the answer.

=Rate(10*12,-1000,0,200000,0,.1/12)

gives an answer of about .8%

Note that the amount is -, since it is cash paid out. (Otherwise the
formula won't converge.)
...Rick
From: thompson@atlas.socsci.umn.edu (T. Scott Thompson)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Protecting end-points of a named range
Date: 20 Aug 92 20:11:24 GMT
Reply-To: thompson@atlas.socsci.umn.edu
Distribution: comp.apps.spreadsheets
Organization: University of Minnesota

I only use Quattro for my own work, so my "dummy-proofing" is of a very
personal variety!  However, the following has worked well for me:

To protect the top and bottom of a COLUMN range, I simply add a cell
to the top and bottom, include those cells in the range, and
(optionally) insert something in them that the numeric functions will
ignore (like a label).  Then I protect just the two "guard cells".  I
end up with something like this:


              1      2      3
         A        -------
         B          1.2
         C          3.4
         D          5.6
         E        -------
         F         10.2

Here I would make A2-E2 be the named range. (Say "DATA") I put the
labels "/-" in A2 and in E2, which are protected.  B2-D2 are not
protected, so that they can be erased, deleted, etc.  Cell F2 might
have something like @SUM(DATA), which simply ignores the labels in A2
and E2.

This scheme also makes it easy to add an extra cell to the top or
bottom of the range and have it be included in the range
automatically.

The same scheme should also work for ROW ranges.  If you do this then
you can evey use "Hide Column" to prevent the columns corresponding to
A2 and E2 in the example from showing up.

Hope this helps.
Newsgroups: comp.apps.spreadsheets
From: phyfv001@ntnunews.scc.ntnu.edu.tw (phyfv001)
Subject: test
Reply-To: phyfv001@ntnunews.scc.ntnu.edu.tw (phyfv001)
Organization: Digital Equipment Corporation
Date: Thu, 20 Aug 1992 14:58:55 GMT


This is a test.
From: rglew@cs-acad-lan.Lakeheadu.Ca (R. J. Glew)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Protecting end-points of a named range
Date: 20 Aug 1992 22:26:21 GMT
Distribution: comp.apps.spreadsheets
Organization: Lakehead University

In article <RON.92Aug19115827@bert.cs.byu.edu> ron@bert.cs.byu.edu (Ron Snyder) writes:

>  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.

If I understand your question correctly, you want users to be able to add or 
delete rows without losing range name references.


      A       B      C   
1
2    \-      \- 
3   200     123     
4   344     767 
5   666     444
6   335     569
7    \-      \-
8  

/rncFIRST~A2.B7~


User Rules:

"You can delete or add rows ONLY between the two dashed lines."
From: ayf@pruxp.att.com (Avi Feldblum)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Excel Macro's help needed!  :)
Date: 12 Aug 92 17:48:12 GMT
Distribution: na
Organization: AT&T

In article <1992Aug10.153521.20679@nrtpa038.bnr.ca> Sparky writes:
>
>If that's not it, please post some sample code and I'll try again.

Hi,

I'm new to this group and am looking for some excel guru's to ask
questions of. Here's a basic description of what I am trying to do and
if anyone thinks they may be able to give me a hand I would appreciate
it.

I am using Excel 4.0 for Windows. I've set up a workbook (.xlw) that
contains (at least) four files. One is a macro sheet that contains all
the macros that I need to use, cmodel.xlm, the second is a database of
parts, parts.xls, the third is the spreadsheet that the user wants
filled out, product.xls, and the fourth is just a README file to give
some info on what the workbook does and to use it.

The basic mode of operation is that the user will list a sequence of
numbers in column A of the worksheet, and then run a macro that copies
a series of formulas across the row based on the "class" of the number
(e.g. 0, <1000, <10000), then takes the actual number and goes out to
the database worksheet and extracts some data that relates to that
specific part.

One problem I am running into now is that the formulas may depend on
something like a tax rate, so I would like to define that as a defined
name and then the formula would be something like say
F23*Tax_Rate. What I am finding is that each time it copies that
formula in, it askes me if I want to use the existing definition of
that named variable. If there are 30-100 such lines and several such
variables it drives one crazy. 

So if you have experience writing macros in excel and would be willing
to answer some questions, please let me know. If you are willing/able
to respond to emailed questions or take a phone call, please let me
know.

Thanks in advance.

Avi Feldblum
AT&T
avi_feldblum@att.com
215-939-3748
From: rjn@hpfcso.FC.HP.COM (Bob Niland)
Date: Mon, 17 Aug 1992 01:16:36 GMT
Subject: Re: Reading images for CD VIDEO
Organization: Hewlett-Packard/WSY Ft.Collins,CO,USA
Newsgroups: comp.ivideodisc

In comp.ivideodisc, bill@thd.tv.tek.com (William K. McFadden) writes:

>> Does anyone known how, to extract the video (frame by frame) from the
>> disc using Sun's CDROM player.   Or does any know the storage format,
>> so I can decode the video data (assuming I can read the raw data).

> The video is encoded in an analog FM format.  The only way I know of to
> read it is with a laserdisc player. 

Correct.  The video portion is read at a completely different speed as well.
No CD-ROM players known to me can read CDV-5.  They would have to have a
separate composite or Y/C video output in any case, because the bit rate of
digitized video (14 Mbytes/sec or higher) is too fast for SCSI.

> Since it is, I believe, recorded using CLV (constant linear velocity), you
> would need to get an LD player with a frame store to do frame-by-frame
> playback.  I have heard of only one industrial player that can do this.

No such thing exists.  The Pioneer LD-V8000 has frame store, but can't play
5-inch media.  No consumer "combi" players have true frame store (they have
field store).

So, the only solution is to run the output of a consumer combi player into
a frame grabber.

Regards,                                              Hewlett-Packard
Bob Niland      Internet: rjn@FC.HP.COM               3404 East Harmony Road
                CompuServe:  71044,2124               Ft Collins CO 80525-9599

This article represents only the opinion[s] of its author, and is not an
official or unofficial position of, or statement by, the Hewlett-Packard
Company.  The text is provided for informational purposes only.  It is
supplied without warranty of any kind.
Newsgroups: comp.ivideodisc,comp.multimedia
From: wmoore@spike.ucar.edu (Wayne Moore)
Subject: Re: Dual Standard Laservision Players
Organization: COMET/Univ. Corporation for Atmospheric Research, Boulder  CO
Date: Wed, 12 Aug 1992 18:51:26 GMT

In article <1992Aug6.150323.7872@cs.nott.ac.uk> rsxdp@unicorn.nott.ac.uk (D.Pead) writes:
>
>Can anybody suggest a possible supplier for a Dual (PAL/NTSC) Standard
>Laservision player in the US or Canada?
>
>We need to be able to demonstrate our PAL-based IV material at various
>locations in the US and Canada, in particular the ICME 7 conference in
>Quebec City in a few weeks.
>
>Our software uses the Videologic MIC system.

We use MIC System I for DOS and have had no problem using the SONY LDP 3600D 
PAL/NTSC player in either mode.  As for a supplier, you might contact Sony 
directly.  I don't have the number handy.

--Wayne
From: davis@cs.cornell.EDU (Jim Davis)
Newsgroups: comp.patents
Subject: [REQUEST] seeking documentation on old Imlac system or horizontal scrolling
Summary: [REQUEST] Can you prove that horizontal scrolling existed before 1978?
Keywords: Imlac
Date: 18 Aug 92 21:24:24 GMT
Distribution: usa
Organization: Cornell Univ. CS Dept, Ithaca NY 14853
X-Full-Sender-Address: @thialfi.cs.cornell.EDU:davis@cs.cornell.EDU


I post on behalf of a firm trying to defeat an attempt to patent
software horizontal scrolling!  I seek information on a late 70's
system called the Imlac Composer.   (Imlac, a company in Newton,
made a strange minicomputer whose archicture resembled the PDP-8
plus a vector graphics display.  The main product, the Composer,
was an early electronic typesetting machine which produced output
for phototypesetters.  This was before laser printers.)

Anyone with pointers to people, manuals, or working systems (hah!)
>from this system should call Ellen Law (collect) at 312-408-0855.
Or send email to me.

Forgive the odd selection of newsgroups, but I have my reasons
for this selection.

Jim Davis -- davis@cs.cornell.edu -- 607-255-1134
Newsgroups: comp.patents
From: srctran@world.std.com (Gregory Aharonian)
Subject: [INFO] Lots and lots of patents expiring - recession?
Organization: Basser Dept of Computer Science, University of Sydney, Australia
Date: Sun, 16 Aug 1992 16:45:50 GMT

     An interesting observation about patents and recessions.  The March
24th issue of the Official Gazette of the US Patent Office listed about
2000 patents that had expired because the assignee failed to pay the
maintenance fees.  I haven't looked closely, but I suspect many of these
were due to small businesses and individuals not having the money to
maintain their patents, for one commercial reason or another.
     This list of 2000 was an unusual amount for the Gazette, which 
usually lists some patents expiring, but I haven't seen to many with so
many.

Greg Aharonian
Source Translation & Optimization

[mod- this may not be so unusual. In the past the US did not have
renewal fees, now they have them every 4 years. This would result in a
lot higher number of patents actually lapsing were as in the past
they would have not showed up...]
Newsgroups: comp.patents
From: srctran@world.std.com (Gregory Aharonian)
Subject: [INFO] Air Force files patent in 19 countries
Organization: Basser Dept of Computer Science, University of Sydney, Australia
Date: Mon, 10 Aug 1992 16:51:48 GMT

     The U.S. Air Force recently applied for an international patent for
a narrowband digital multi-speaker conferencing device.  The device makes
it possible to conduct multi-speaker conferencing over telephone bandwidth
channels by using digital speech coders.
     Of interest is the countries in which the Air Force has filed the
patent.  They are:   Australia, Brazil, Canada, Switzerland, Czeckoslovakia,
Germany, Denmark, Spain, Finland, United Kingdom, Japan, South Korea,
Luxembourg, Netherlands, Norway, Poland, Sweden and Russia.

Greg Aharonian
Source Translation & Optimization

Newsgroups: comp.patents
From: brendan@gauss.anu.edu.au (Brendan Scott)
Subject: [FTP] Mathematical Algorithms essay available
Organization: Basser Dept of Computer Science, University of Sydney, Australia
Date: Wed, 12 Aug 1992 06:35:56 GMT
X-Mailer: ELM [version 2.2 PL0]

A few days ago, I posted the latex file for an essay on mathematical
algorithms to the newsgroup. 
I have since had requests for the postscript file to be made available. 
The file has been uploaded on extro.su.oz.au in the directory
pub/patents/articles under the name math.algs.essay.ps
Those who are interested may now download a copy for themselves.

Brendan

-- 
Brendan Scott, Australian National University, Canberra.   
(brendan@gauss.anu.edu.au)
Strictly no reproduction for commercial purposes.

Newsgroups: comp.patents
From: wkao@sisler.ucr.edu (wayne kao)
Subject: [REQUEST] Question.
Organization: University of California, Riverside
Distribution: usa
Date: Fri, 7 Aug 1992 03:01:44 GMT



	I'm new at this so please bear with me.

	I've written a pretty good program and I
	used ingres for this program.  Will I be
	able to publish this program commercially?

	I welcome any inputs.  Thank you.


-- 
Wayne Kao  A.K.A. Wahoo 'The Next Great Elvis Impersonator'                
(Just another water molecule in the toilet bowl of life)
wkao@ucrmath.ucr.edu              
University of California, Riverside	

[mod - you will be able to exploit your program commercially..
	unless you have copied the program from someone else...
	However if your program contains novel and inventive features worthy of
	patenting then you may be wise to see a patent attorney before
	publising your program.
	None of this of course should be taken as legal advice....
	For legal advice, see an attorney.
	]
Newsgroups: comp.patents