HDTenEightyP/NetNews huggingface dataset:
From: eric@ms.uky.edu (Eric H. Herrin II)
Newsgroups: comp.doc.techreports
Subject: File system tech-report available via anon ftp
Keywords: Viva File System
Date: 27 Jan 93 18:39:11 GMT
Organization: University Of Kentucky, Dept. of Math Sciences
Originator: golding@frans.cs.vu.nl

Ftp from: ftp.ms.uky.edu:/u/ftp/pub/tech-reports/UK/cs/225-93.ps.Z

Tech-report number: 225-93
Date:               January 1993
Title:              The Viva File System
Authors:            Eric H. Herrin II and Raphael A. Finkel
E-mail:		    eric@ms.uky.edu and raphael@ms.uky.edu
Abstract:
        This paper describes the Viva File System or VIFS, a technique for
        high-performance file allocation on disks.  VIFS uses bitmaps  to
        represent  both  free  blocks on the disk and allocated blocks in
        each file.  Allocation bitmaps provide  a  very  fast  method  of
        finding  blocks  close  to  the  last  allocated block in a file.
        Fragments (partial blocks) are used to store  the  overflow  from
        the  last  file  block;  the minimum size of a fragment is chosen
        when the file system is initialized.  Conventional file  systems,
        such  as  the  Berkeley  Fast File System (FFS), can store a file
        containing 96KB of data without using indirect blocks and  around
        16 MB of data for each indirect block.  With the same block size,
        VIFS can store up to about 10 MB of data without  using  indirect
        blocks  and  up to 500 MB of data per indirect block.  The design
        of VIFS allows some previously synchronous  operations  to  occur
        asynchronously,  resulting in significant speed improvements over
        FFS.  VIFS provides multiple  read-ahead  to  maintain  its  high
        speed when several processes are competing for disk accesses.  We
        provide experimental measurements taken from an implementation of
        Viva  in  a  BSD  4.3 kernel.  The measurements show that VIFS is
        significantly faster than FFS for nearly all file  system  opera-
        tions.


-- 
--
|  	Eric H. Herrin II - {rutgers,uunet}!ukma!eric, eric@ms.uky.edu	     |
|			  University of Kentucky			     |
===========================================================================
Co-moderator:  Richard Golding, Computer & Information Sciences, UC Santa Cruz
	    compdoc-techreports-request@ftp.cse.ucsc.edu
Newsgroups: comp.doc.techreports
From: rusu@eniac.seas.upenn.edu (LMRusu)
Newsgroups: comp.apps.spreadsheets
Subject: Excel 4.0 questions -> Please help!!
Date: 22 Jan 93 14:01:17 GMT
Followup-To: comp.os.ms-windows.apps, comp.os.ms-windows.misc
Distribution: usa
Organization: University of Pennsylvania

I have 3 questions about Excel 4.0 for Win:
1. How can I create a subscript or superscript font?
2. How can I create a footnote in a spreadsheet? I would like to have a 
formula or a number in a cell, for example the number 234 and then attached
to it the subscript a ^a which references a footnote.
3. Where can I find some Excel macros and templates? (ftp sites?)

Thanks in advance for your help!

L.R.

--
From: jiangky@vuse.vanderbilt.edu (Keyuan Jiang)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Excel screen flickering
Date: 22 Jan 1993 17:15:56 -0600
Organization: UTexas Mail-to-News Gateway
NNTP-Posting-Host: cs.utexas.edu


There are a couple of workouts for your problem.

1. If you don't want the user to see the changes on screen, you can use
  =ECHO(FALSE) to turn off screen update.

2. If you do want the user to see the changes in a specific area, use
  FORMULA() function to paste data instead of COPY() and PASTE().

Hope this message helps.

Keyuan
From: sbernste@weber.ucsd.edu (Steven Bernstein)
Newsgroups: comp.apps.spreadsheets
Subject: Unsqueezing 123 Files
Date: 21 Jan 1993 06:38:22 GMT
Organization: University of California, San Diego
NNTP-Posting-Host: weber.ucsd.edu


Does anyone know how to "unsqueeze" Lotus 123 files without having
to buy Squeeze?  I was given a number of files that are,
unfortunately, in the .wk! format.  I was wondering if there is a
share ware program or inexpensive conversion utility available that
will uncompress these files.

Any assistance would be greatly appreciated!

Steve Bernstein
University of California, San Diego
sbernste@weber.ucsd.edu
Organization: Arizona State University
Date: Monday, 25 Jan 1993 13:06:31 MST
From: <ATG2G@ASUACAD.BITNET>
Newsgroups: comp.apps.spreadsheets
Subject:    Excel 4.0, linest -> origin


Has anyone experienced difficulty with nonsense output generated
by, e.g., =LINEST(YRANGE,XRANGE,FALSE,TRUE) ?  Using effect coding
in the x-range, I find that linest is returning negative SSs, etc.

Conrad Carlberg

Newsgroups: comp.apps.spreadsheets
From: rlatellb@cc.curtin.edu.au
Subject: Excel 4.0: Super/Sub Scripts?
Organization: Curtin University of Technology
Date: Tue, 26 Jan 1993 07:45:16 GMT

Could someone please inform me as to whether Excel 4.0 can
handle superscripts and subscripts.


Thanks in advance


Bruno


Newsgroups: comp.apps.spreadsheets
From: ra_novy@dal.mobil.com (Robert A. Novy)
Subject: Subscribing to XL Dev List
Followup-To: comp.apps.spreadsheets
Organization: Mobil E&P Technical Center
Date: Thu, 21 Jan 1993 17:09:50 GMT

Please DO NOT send subscription requests for the Excel Developers' List to
the address clay=xldev@cs.cmu.edu.  Doing so sends your request to every
subscriber.  I get enough junk mail on paper.

The List Administrator gives the address for subscribing as
clay=xldev-add@cs.cmu.edu

You might need to put
SUBSCRIBE your-address-here
in the body of the message, or the server might extract your address from
the header.  You'll know it works when you receive a welcome message in
return.

Now if I could only stop the flow of junk mail through the USPS...

Bob Novy
ra_novy@dal.mobil.com
Dallas, TX
From: pr@praxis.co.uk (Peter Rose)
Newsgroups: comp.apps.spreadsheets
Subject: Excel Bugs Request
Date: 21 Jan 93 12:35:46 GMT
Organization: Praxis, Bath, U.K.


Is there a list of Excel V3.0 bugs available? If people know of any bugs,
particularly in the calculation accuracy area could you please mail me.

I will summarise if the response warrents it.


Thanks

    Pete


-- 
                      These are personal opinions only 
         Peter Rose, Praxis plc, 20 Manvers Street, Bath BA1 1PX UK.
Tel:    +44-225-444700.   Email:    pr@praxis.co.uk     Fax: +44-225-465205
Newsgroups: comp.apps.spreadsheets
From: stubaker@casbah.acns.nwu.edu (Stuart Baker)
Subject: Excel & Relational Databases
Organization: Northwestern University, Evanston Illinois.
Date: Thu, 28 Jan 1993 13:33:02 GMT

I have a large Excel spreadsheet that I want to dump information into some sort of
relational database for archiving purposes. I was just trying to get people's
opinion on a database (windows preferrably) that would fit the bill.

---------------------
Stu D. Baker				Mitchell Media Center
Multimedia Services Specialist		Northwestern University Library
E-MAIL: stubaker@nwu.edu		1935 Sheridan Road.
VOICE: 708.467.1984			Evanston, Illinois   60208-2323
FAX: 491-8306
Newsgroups: comp.apps.spreadsheets
From: roberts@ucunix.san.uc.edu (Michael Alan Roberts)
Subject: Conditional execution of a macro (Lotus 1-2-3)
Organization: University of Cincinnati
Date: Fri, 22 Jan 1993 20:50:42 GMT

If you want to execute a macro if a given condition is true, use the
following macro code:

/XIcondition{macro_name}

RTM, there may be a tilde (~) between the condition and the macro that
is to be run.

Hope this helps.

Michael Roberts
roberts@ucunix.san.uc.edu

Newsgroups: comp.apps.spreadsheets
From: hare@snake-1.cae.wisc.edu (John Hare)
Subject: Excel screen flickering
Distribution: usa
Date: 22 Jan 93 16:13:22 CST
Originator: hare@snake-1.cae.wisc.edu



  I'm trying to write a macro that copies alot of data around on the
sheet. I would like the user to see a specific part of the sheet while the 
copying is happening. 

  At the moment I goto each cell/block, copy to the clipboard, goto
destination, and paste.  This causes alot of flickering and jumping around
on the screen.  

  Is there a way to copy cells/blocks from one area to another without the
user knowing it's going on?


  Thanks in advance!
  hare@cae.wisc.edu
-- 
      _    _
     | |  | |
     | |__| |       hare@cae.wisc.edu
   /          \     Apps Suport Staff
Newsgroups: comp.apps.spreadsheets
From: qmdbms@gsusgi2.gsu.edu (Brian Schott)
Subject: Re: Centering across mult. columns in Excel 4
Organization: Georgia State University
Date: Thu, 21 Jan 1993 12:54:41 GMT

cs70353t@uwasa.fi (Jukka Matila) writes:

>In article <C0z00L.Dv4@newsflash.concordia.ca> steeve@cs.concordia.ca (HARDY j g steeve) writes:

>>        The problem is center a heading across multiple columns
>>in Excel 4. Mind you, I do not want to use the header or such a 
>>thing.

I saw a demo of this at our AMUG (Macintosh) meeting last night and cannot
remember exactly how it's done.  I believe, though, that you type the
title into the leftmost cell and press enter. Then you select that cell
and extend the selection to the right to cover the columns you wish to be
centered over. Finally, and here's the part I am least sure of, you may
just double click, or you may click on one of the icons in the toolbar.
That's my recollection, anyhow.

However, the COOLEST thing I saw in the demo by Rob X at Microsoft, was an
automatical document formater.  You simply select your entire spreadsheet,
the rectangle of used cells, and press the autoformat icon in the toolbar.
Excel formats the whole thing artfully with some borders and some color
and some variety of font style, etc. If you don't like the first automatic
format, click again and you get another one to choose from. I think Rob
said there are 15 or 20 styles to choose from.

>Hi all,

>I have a similar problem, but in vertival.

>Does anyone know any way to center variable length text cell in variable
>sized vertical arrea (that is some amout of rows). 

The same technique might work.  Try it and report back?

>Thanks in advance,

>--- juma ---
-- 
Brian Schott/Decision Sciences Dept.             qmdbms@gsusgi2.gsu.edu
College of Business Administration                         404-651-4070
Georgia State University                  interests: approx. reasoning,
Atlanta, Georgia USA 30303-3083     (B=)       decision support systems
From: twcaps@tennyson.lbl.gov (Terry Chan)
Newsgroups: comp.apps.spreadsheets
Subject: Looking for Lotus 1-2-3/Win. Rel 1.1 Executable
Date: 26 Jan 1993 06:19:44 GMT
Organization: Department of Redundancy Department
Reply-To: TWChan@lbl.gov (Terry Chan)
NNTP-Posting-Host: 128.3.12.117

I have inherited a copy of Lotus 1-2-3 for Windows, ver. 1.1
which was infected with the 1575 virus (according to the 
virus list of McAfee).  It seems to be clean now, but the
main executable file (123w.ee) is several bytes longer and
does not run well (i.e., it "hesitates" on loading files where
access to disk appears to "hiccup.")  As it turns out, the
executable file on the original disks were also corrupted.

I sent the diskette back to Lotus, but they have not replied
or sent me back a new diskette.  I would *greatly* appreciate
it if someone could uuencode and send me just that executable
file (or alternately, put it in an ftp site that I could 
get it from).

Thanks much for any help.

Terry Chan
--
Energy and Environment Division   | Internet:  TWChan@lbl.gov
Lawrence Berkeley Laboratory      | 
Berkeley, California  USA  94720  | Yeah, right.
Newsgroups: comp.apps.spreadsheets
From: grov@iis.ethz.ch (Harald Grov)
Subject: WingZ:Importing ascii-files, external functions?
Summary: We have following problem:
Keywords: Wingz, import
Organization: Swiss Federal Institute of Technology (ETH), Zurich, CH
Distribution: comp
Date: Thu, 21 Jan 1993 15:22:50 GMT

Does anybody out there know how to import files without using OPEN file?
I would like to import strings and add them as items to a list box.
Do I really have to write external functions? Do they allready exist? 
Then perhaps some kind soul could tell me where?

Any help appriciated.

Email: grov@iis.ethz.ch or better Hari.Grov@zh014.ubs.ubs.ch

.

Newsgroups: comp.apps.spreadsheets,comp.os.ms-windows.apps
From: rvdv@ktibv.uucp (Richard van der Veen)
Subject: Quattro Pro for windows: QUESTION
Keywords: quattro,windows
Organization: KTI BV
Date: Mon, 25 Jan 1993 10:28:47 GMT

Hi there,

I have the following problem and I hope that someone can help me:

When I use macros to print a spreadsheet, I want to enter the number of
copies dynamically. So I put the following statement in my macro:

    {GetLabel Number of Copies, _Copies}

where _Copies is a named cell. Now I want to use the _Copies name in one
of the following statements, which should be like:

    {Print.Copies _Copies}

The result is

    Invalid number {Print.Copies}
    (Cell Address)

How can you use named cells in such macros ??

Thanks in advance,

Richard.

===============================================================================
 ______              _      __       / Richard v.d. Veen                     /
|  __  \          _ | |    / /      / Voice: +31-(0)79-531624               /
| |__| | _   _   | || |   / /  ____/ E-mail: .....sun4nl!ktibv!rvdv    ____/
|  _  _/| | / /__| || |  / /  /                                       /
| | \ \ | |/ /| __ || |_/ /  /  Me, I'm just a lawnmower,            /
|_|  \_\|___/ |____||____/  /  You can tell me by the way I walk.   /
--------------------------------------------------------------------
KTI BV, P.O. Box 86, 2700 AB  Zoetermeer, The Netherlands         /
------------------------------------------------------------------
From: craiger@nprdc.navy.mil (J. Philip Craiger)
Newsgroups: comp.apps.spreadsheets
Subject: problems with linest() function
Date: 20 Jan 93 20:02:54 GMT
Distribution: usa
Organization: Navy Personnel R&D Center


This solution should solve the problem, but it is difficult to believe
that there isn't a more elegant solution to the problem.  I also find
the same problem when using any of the functions in the analysis
toolpak of ver. 4.0.  If i were to compute a 10x10 correlation matrix,
i would have to go through an select out all cases with missing
values.  If Microsoft is to gain support from the scientific
community, they should try to correct this problem.  Very few real
world data sets that I've come across are absolutely  free of missing
values.  I think their analysis toolpak is great, but has serious
limitations.  
-- 
_______________________________________________

J. Philip Craiger, Ph.D. (Internet: craiger@nprdc.navy.mil)
Navy Personnel Research and Development Center -- Code 161
San Diego, CA  92152-6800       (619-553-7961)
-- 
_______________________________________________

J. Philip Craiger, Ph.D. (Internet: craiger@nprdc.navy.mil)
Navy Personnel Research and Development Center -- Code 161
From: A.D.Bailey@lut.ac.uk
Newsgroups: comp.apps.spreadsheets
Subject: Re: excel graphing help
Date: 26 Jan 93 10:22:59 GMT
Reply-To: A.D.Bailey@lut.ac.uk (Adrian D.Bailey)
Organization: Loughborough University, UK.

In article <43993@sdcc12.ucsd.edu> ee52fas@sdcc15.ucsd.edu (Anand Rao) writes:
>using microsoft excel for the macintosh, is there any way that
>i can graph a function?  the only thing i have been able to dig up
>is the ability to graph data, but i need to graph data AND a
>theoretical function curve to show how well the data fits the
>curve.  is this possible?

The simplest way to do this would be to prepare an extra column,
alongside your data, which contains the formula that you wish to plot.
Then, instead of making a chart of only your data, you make a chart 
with two lines - your data, and the formula.
Hope this helps.
Xref: sparky comp.apps.spreadsheets:860 comp.sys.mac.apps:20508
From: ee52fas@sdcc15.ucsd.edu (Anand Rao)
Newsgroups: comp.apps.spreadsheets,comp.sys.mac.apps
Subject: excel graphing help
Date: 25 Jan 93 02:05:21 GMT
Followup-To: poster

using microsoft excel for the macintosh, is there any way that
i can graph a function?  the only thing i have been able to dig up
is the ability to graph data, but i need to graph data AND a
theoretical function curve to show how well the data fits the
curve.  is this possible?
From: wolff@egr.msu.edu (Dr. Thomas Wolff)
Newsgroups: comp.apps.spreadsheets
Subject: Excel default fonts
Date: 27 Jan 93 15:25:23 GMT
Organization: Civil and Environmental Engineering
NNTP-Posting-Host: carrot2.ce.msu.edu

Question 1:

I want to change my default font from MS Sans Serif to Arial.  
Using Format, Style, Define, Normal, Font, etc...OK seems to save 
a new default with a specific file, but not change the PROGRAM default 
Normal style.  Am I doing something wrong? Can the program default font be 
changed?

Question 2:

The problem that led to this was that printed file name 
headers with the MS Sans Serif font were dropping letters; 
CHOOCHOO.XLS would print (on an HPIIP+) as C___C___.XLS.  Arial prints fine.  Any ideas what's going on here ?
 
Thanks
From: jiangky@vuse.vanderbilt.edu (Keyuan Jiang)
Newsgroups: comp.apps.spreadsheets
Subject: Excel 3.0 Printing (Re:EXCEL 3.0: 50% printout on MAC LaserWriter)
Date: 21 Jan 1993 09:55:22 -0600
Organization: UTexas Mail-to-News Gateway
NNTP-Posting-Host: cs.utexas.edu


Although I am not using Mac, I thought this might be related to printing in
Excel. I have noticed that Excel 4.0 for windows allows one to change the
scalling of printout even if one does NOT use a postscript printer. It was
impossible with Excel 3.0 for windows.

I am using a HP LaserJet IIP. And scalling of printout works fine.

I suspect there might be a similar problem with excel 3.0 and 4.0 for mac.



Keyuan
Newsgroups: comp.apps.spreadsheets
From: roberts@ucunix.san.uc.edu (Michael Alan Roberts)
Subject: Excel graphing question
Organization: University of Cincinnati
Date: Mon, 25 Jan 1993 23:48:44 GMT

using microsoft excel for the macintosh, is there any way that
i can graph a function?  the only thing i have been able to dig up
is the ability to graph data, but i need to graph data AND a
theoretical function curve to show how well the data fits the
curve.  is this possible?

Yes, it is possible. Just write the function as an Excel formula, and
plug in the row numbers as values. Then select both data sets and copy
and paste them into a new chart.

Hope this helps.

Michael Roberts
roberts@ucunix.san.uc.edu
From: covingc@ee.tamu.edu (Mouse)
Newsgroups: comp.apps.spreadsheets
Subject: Old version of Lotus
Date: 24 Jan 1993 09:56:26 GMT
Organization: Texas A&M University
NNTP-Posting-Host: ee.tamu.edu

I have seen Lotus 123 V1 or so running on a Texas Instruments 
Professional Computer, a sort of PC clone thing that TI made
about 1983.  I have the machine, and I'd like to get Lotus for
it to take data with down in my lab.  Newer versions will not
run on the machine. 

If someone out there has an old version of Lotus that they'd 
like to get rid of, sell, trade, etc., please let me know.

Thanks in advance, 
covingc@ee.tamu.edu
Xref: sparky comp.apps.spreadsheets:862 comp.os.ms-windows.apps:7525
From: banshee@cats.ucsc.edu (Wailer at the Gates of Dawn)
Newsgroups: comp.apps.spreadsheets,comp.os.ms-windows.apps
Subject: Re: Quattro Pro for windows: QUESTION
Date: 25 Jan 1993 22:56:17 GMT
Organization: University of California, Santa Cruz
NNTP-Posting-Host: am.ucsc.edu
Keywords: quattro,windows


rvdv@ktibv.uucp (Richard van der Veen) writes:
>When I use macros to print a spreadsheet, I want to enter the number of
>copies dynamically. So I put the following statement in my macro:
>    {GetLabel Number of Copies, _Copies}
>where _Copies is a named cell. Now I want to use the _Copies name in one
>of the following statements, which should be like:
>    {Print.Copies _Copies}

>How can you use named cells in such macros ??

{SetObjectProperty "Print.Copies", +_Copies}

{Print.Copies +A1} _should_ work, but doesn't appear to.  I will submit this
as a bug.

-- 
The Wailer at the Gates of Dawn              | banshee@cats.UCSC.EDU       |
Just who ARE you calling a FROOFROO Head?    |                             |
DoD#0667  "Just a friend of the beast."      | banshee@ucscb.UCSC.EDU      |
2,3,5,7,13,17,19,31,61,89,107,127,521,607....| banshee@ucscb.BITNET        |
From: 5916rahmank@vms.csd.mu.edu ( )
Newsgroups: comp.apps.spreadsheets
Subject: Re: Excel default fonts
Date: 28 Jan 1993 06:13:26 GMT
Organization: Department of EECE, Marquette University
Reply-To: 5916rahmank@vms.csd.mu.edu
NNTP-Posting-Host: vmsf.csd.mu.edu

In article <wolff.6.0@egr.msu.edu>, wolff@egr.msu.edu (Dr. Thomas Wolff) writes:
.>Question 1:
.>
.>I want to change my default font from MS Sans Serif to Arial.  
.>Using Format, Style, Define, Normal, Font, etc...OK seems to save 
.>a new default with a specific file, but not change the PROGRAM default 
.>Normal style.  Am I doing something wrong? Can the program default font be 
.>changed?
>

	Edit the EXCEL4.INI file in the windows directory. Under 
	[Microsoft Excel] add

	FONT=Arial,9 /* to get Arial 9Pt as the default font, for instance */

	-Anis.


>Question 2:
>
>The problem that led to this was that printed file name 
>headers with the MS Sans Serif font were dropping letters; 
>CHOOCHOO.XLS would print (on an HPIIP+) as C___C___.XLS.  Arial prints fine.  Any ideas what's going on here ?
> 
>Thanks
Newsgroups: comp.apps.spreadsheets,comp.os.ms-windows.apps
From: parry@yoyo.cc.monash.edu.au (Tom J Parry)
Subject: Re: Quattro Pro for windows: QUESTION
Followup-To: comp.apps.spreadsheets,comp.os.ms-windows.apps
Originator: parry@yoyo.cc.monash.edu.au
Organization: Monash University, Melb., Australia.
Date: Tue, 26 Jan 1993 05:49:52 GMT

Richard van der Veen (rvdv@ktibv.uucp) wrote:
>     {GetLabel Number of Copies, _Copies}

> where _Copies is a named cell. Now I want to use the _Copies name in one
> of the following statements, which should be like:

>     {Print.Copies _Copies}

> The result is

>     Invalid number {Print.Copies}
>     (Cell Address)

> How can you use named cells in such macros ??

You could use a self-modifying macro that creates the {Print.Copies line
with the string equivalent of _Copies in it, just before executing it. I've
used similar tactics before to get around some macro inadequacies.

-- 
Tom J Parry.
Your reality is a figment of my imagination.
From: Gunnar.Sylthe@nsd.uib.no
Newsgroups: comp.apps.spreadsheets
Subject: XLS-format spec. wanted
Date: 27 Jan 93 11:43:17 GMT
Reply-To: Gunnar.Sylthe@nsd.uib.no
Organization: Norwegian Social Science Data Services


Is there an online specification of the Excel XLS file format available
for anonymous ftp somewhere?

Any and all hints would be appreciated. (References to books are also
welcome!)


--Gunnar


+------------------------------------------------------------------------+
  Gunnar Sylthe                                       Phone: +47-5-212125
  Norwegian Social Science Data Services              Fax:   +47-5-960660
  Hans Holmboes gate 22                   Email: Gunnar.Sylthe@nsd.uib.no
  N-5007 Bergen
  NORWAY
+------------------------------------------------------------------------+
From: fcs$1224@altair.selu.edu
Newsgroups: comp.apps.spreadsheets
Subject: Control seed in @rand of Lotus 1-2-3?
Date: 21 Jan 93 19:30:59 -0600
Organization: Southeastern Louisiana University

Hi:

The @rand function in Lotus 1-2-3 generates numbers such that 0 <
x < 1.  Is there a way to set the beginning seed to a value?  The
purpose is to aid in debugging simulations by getting the same set
of random numbers each time.  I could use the same set of random
numbers by putting all of them in the spreadsheet, but I would
rather generate the same set of random numbers each time.  The
number of random numbers I am using does not lend itself to storing
them.

Thanks,

Tom