HDTenEightyP/NetNews huggingface dataset:
From: agrawal@ecs.umass.edu
Newsgroups: comp.apps.spreadsheets
Subject: 386 vs. 486 : Different Excel Formats?
Date: 7 Sep 92 09:39:20 GMT


I have a peculiar problem with the way Excel formats ASCII data read from
a file on 2 different machines. The ASCII file contains numbers. In one
case, the real numbers are treated as text, while in the other, they are
treated as numbers. Integers are treated as numbers in both. In the case
where the real numbers are treated as text, The "Format All" Menu selection
shows the format to be "Standard". In the other, it is shown to be
"General".

I am using Excel Version 4.00 with Windows 3.1.   The PC that has the
"General" format is a 386 with no math coprocessor, while the one that
has the "Standard" format is a 486 (with a math coprocessor.) I have
loaded Excel on 2 more 386 machines without a math coprocessor and
got the "General" format.

Can the difference in format be due to the architecture of the machines?
Any help will be greatly appreciated.

-Sanjay Agrawal

Ph: 617-484-9920(work)

did you check the decimal point vs. comma? in some nonEnglish
cultures (German e.g.) the instead of a decimal point a decimal comma is used.
if excel is configured according to that it might misinterpret noninteger
numbers
From: agrawal@ecs.umass.edu
Newsgroups: comp.apps.spreadsheets
Subject: 386 vs. 486 : Different Excel Formats?
Date: 7 Sep 92 09:39:20 GMT


I have a peculiar problem with the way Excel formats ASCII data read from
a file on 2 different machines. The ASCII file contains numbers. In one
case, the real numbers are treated as text, while in the other, they are
treated as numbers. Integers are treated as numbers in both. In the case
where the real numbers are treated as text, The "Format All" Menu selection
shows the format to be "Standard". In the other, it is shown to be
"General". 

I am using Excel Version 4.00 with Windows 3.1.   The PC that has the
"General" format is a 386 with no math coprocessor, while the one that
has the "Standard" format is a 486 (with a math coprocessor.) I have
loaded Excel on 2 more 386 machines without a math coprocessor and
got the "General" format. 

Can the difference in format be due to the architecture of the machines? 
Any help will be greatly appreciated. 

-Sanjay Agrawal

Ph: 617-484-9920(work)
From: banshee@cats.ucsc.edu (Wailer at the Gates of Dawn)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Borland is stupid
Date: 15 Sep 1992 04:01:23 GMT
Organization: University of California, Santa Cruz
NNTP-Posting-Host: am.ucsc.edu
Keywords: Quattro Pro Lotus


gary@resumix.portal.com (Gary M. Lin) writes:
>I don't see any Borland suits at trade shows pushing anything except
>goofy buttons that no one wants.  Then again, what are you waiting for?
We don't wear suits -- well only gorilla suits anyhow.

>Microsoft to finish NT on MIPS and Alpha, so I can run Excel and blow
>the socks off QPro?  Okay, so who cares if Lotus ported 1-2-3 for IBM
>mainframes, but at least they know they can do it on a non-PC system.
NT - plegm-T -- porting to more than one processor family; what a concept!
I say port to nextstep!  (Thats how I'm hoping to get the developers kit
anyhow).

>Then again, I just MIGHT be still upset at Borland for selling me
>SPRINT as the greatest word-processor since sliced bread.  Grrrrrrr!!
Yeah but what other word processor will allow you to write the prime sieve
in its macro language?

-- 
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        |
Newsgroups: comp.apps.spreadsheets
From: phw@genghis.borland.com (Peter Weyzen)
Subject: Re: Borland is stupid
Originator: phw@genghis.borland.com
Keywords: Quattro Pro Lotus
Organization: Borland International
Date: Mon, 14 Sep 1992 03:50:12 GMT

> "Borland is Stupid"

Thanks a lot! 
I'm not sure if I have something nice to say about you?


-- 
--
Peter Weyzen      /  "Some day my log will have
phw@borland.com  /    something to say" -Log Lady
Newsgroups: comp.apps.spreadsheets
From: gary@resumix.portal.com (Gary Lin)
Subject: Borland is stupid
Keywords: Quattro Pro Lotus
Organization: Resumix Inc.
Date: Fri, 11 Sep 92 23:40:36 GMT

What I really want to know is why doesn't Borland port QPro over
to UNIX/X?  Lotus already has a product (albeit sucks!) on UNIX and
is locking up the market.

If they can do a Windows version, they can do X.

						- gary lin
						gary@resumix.portal.com
Newsgroups: comp.apps.spreadsheets
From: andrewm@uws.EDU.AU (Andrew Maclean)
Subject: Paradox 4.0 (FLImport.exe)
Summary: What happened to FLImport?
Keywords: Paradox 4.0
Organization: University of Western Sydney
Date: Mon, 14 Sep 1992 04:02:14 GMT

I just installed Paradox 4.0 and noticed that they did away with FLImport.
This was a useful fixed length file import utility that actually created or
appended records to an existing database file.  It had a nice feature in that
you could actually name the fields.  This was a really useful utility - particularly since some of my fixed length file are greater than 7MB and can have up
to 20 Fields.

Firstly: Have I missed the file - perhaps it has been renamed?
Secondly: If it really doesn't exist is there a simple alternative for
          importing fixed length files?  I really want to use Paradox
          directly & not have to filter the data into eg. a comma delimited
          format (too risky on the basis of extra errors & file space, and
          the problem of naming the fields).


Why drop a perfectly good program - I am sure that they could have updated it
to Paradox 4.0 file formats.  It really doesn't have to support memo fields or
Blobs.  In fact, upon reflection, you could import ASCII data and later convert it to a memo field.

+-----------------------------------------------------------------------------+
| Andrew J. P. Maclean                          E-mail: a.maclean@uws.edu.au  |
| University Planner,                                     andrewm@uws.edu.au  |
| University of Western Sydney,                  Phone: +61 2 678 7848        |
| PO Box 1000, St. Marys, N.S.W. 2760,             Fax: +61 2 678 7804        |
| Australia.                                                                  |
+-----------------------------------------------------------------------------+
From: qqc@mace.cc.purdue.edu (Dm Forsyth)
Newsgroups: comp.apps.spreadsheets
Subject: Re: making check catagory acc
Date: 11 Sep 92 16:21:57 GMT
Organization: Purdue University

In article <31.97.uupcb@pcb.batpad.lgb.ca.us> ken.mason@pcb.batpad.lgb.ca.us (Ken Mason) writes:
>DF.I want to add additional columns (1 associated with each column of values)
>DF.in which to enter the expense catagory (probably numbers between 1 and 15).
>
>        I'm interested in your problem, but you lost me here.  Can you
>        post an extract of how you want it to look, then what you want
>        to do with your data?
>                                                      

Let me restate my question, hopefully more clearly:
  (forget for the moment that I do this in 4 columns instead of 1, just to
fit onto one screen; if necessary, I can repeat the procedure 4 times for that)

I want to have 3 columns:
	1 for a 0/1 value for checks not back from bank
		This is for "database extraction" for outstanding checks,
		and this works, no question here.
	1 for the value of the check
	1 for the catagory of the expense (values maybe 1 to 15)
		This is the part I have the question about.  How to sum
		catagories.

The data could look like this:
	IN	CHECK	CATAGORY
	1	12.00	1
		15.00	5
	1	18.47	1	etc.

It seems there should be some simple way of getting the sums by catagory.

	In this abbreviated example, the sum for catagory 1 should be 30.47
		sums for catagories 2-4 are 0
		sum for catagory 5 = 15
		etc.

I've used @dsum(), in this way:
	Make a criterion table with the titles on one row
		Then on consecutive following rows, 1, 2, 3, .. 15.

It looks something like this:  CHECK	CATAGORY
					1
					2
					3  etc

Then I have a column of @dsums-previous @dsum.
In other words, it looks like
	@dsum(b20.c30,0,k20.L21)
	@dsum(b20.c30,0,k20.L22)-@dsum(b20.c30,0,k20.L21)
	@dsum(b20.c30,0,k20.L23)-@dsum(b20.c30,0,k20.L22)

THIS WORKS!!!!
But, it takes an awfully lot of formulas and seems very messy to do something
that must have been done many times.  

WHO HAS A BETTER WAY?

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
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: A4422DAB@vm.univie.ac.at (Erich Neuwirth)
Subject: Re: making check catagory acc
Organization: University of Vienna
Date: Tue, 15 Sep 1992 08:28:22 GMT

------------------------- Original Article -------------------------
From: qqc@mace.cc.purdue.edu (Dm Forsyth)
Newsgroups: comp.apps.spreadsheets
Subject: Re: making check catagory acc
Date: 11 Sep 92 16:21:57 GMT
Organization: Purdue University

In article <31.97.uupcb@pcb.batpad.lgb.ca.us> ken.mason@pcb.batpad.lgb.ca.us (Ke
>DF.I want to add additional columns (1 associated with each column of values)
>DF.in which to enter the expense catagory (probably numbers between 1 and 15).
>
>        I'm interested in your problem, but you lost me here.  Can you
>        post an extract of how you want it to look, then what you want
>        to do with your data?
>

Let me restate my question, hopefully more clearly:
  (forget for the moment that I do this in 4 columns instead of 1, just to
fit onto one screen; if necessary, I can repeat the procedure 4 times for that)

I want to have 3 columns:
	1 for a 0/1 value for checks not back from bank
		This is for "database extraction" for outstanding checks,
		and this works, no question here.
	1 for the value of the check
	1 for the catagory of the expense (values maybe 1 to 15)
		This is the part I have the question about.  How to sum
		catagories.

The data could look like this:
	IN	CHECK	CATAGORY
	1	12.00	1
		15.00	5
	1	18.47	1	etc.

It seems there should be some simple way of getting the sums by catagory.

	In this abbreviated example, the sum for catagory 1 should be 30.47
		sums for catagories 2-4 are 0
		sum for catagory 5 = 15
		etc.

I've used @dsum(), in this way:
	Make a criterion table with the titles on one row
		Then on consecutive following rows, 1, 2, 3, .. 15.

It looks something like this:  CHECK	CATAGORY
					1
					2
					3  etc

Then I have a column of @dsums-previous @dsum.
In other words, it looks like
	@dsum(b20.c30,0,k20.L21)
	@dsum(b20.c30,0,k20.L22)-@dsum(b20.c30,0,k20.L21)
	@dsum(b20.c30,0,k20.L23)-@dsum(b20.c30,0,k20.L22)

THIS WORKS!!!!
But, it takes an awfully lot of formulas and seems very messy to do something
that must have been done many times.

WHO HAS A BETTER WAY?

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Dale M. Forsyth |  Assoc. Prof. | Purdue University Animal Sciences
qqc@mace.cc.purdue.edu | phone 49-44841 | campus address 2-111 Lilly
 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

if you are useing excel 4.0 you can enter a formula like

=sum(if(b1:b10=3),c1:c10,0))

and enter this as an array formula
(pressing shift-ctrl-return after entering it, ob macs it is
apple-return, i think)

NO ADDITIONAL ROWS AND COLUMNS NEEDED!
array formulas are an extremely useful tool only available in excel!
Newsgroups: comp.apps.spreadsheets
From: mjo@ef2007.efhd.ford.com (Mike O'Connor)
Subject: Re: UNIX Spreadsheet for HP-UX 730
X-Disclaimer: Not an official spokesperson for Ford OPEO
Reply-To: Mike O'Connor <mjo@fmsrl7.srl.ford.com>
Organization: International Affairs, Overseas Engineering, "Fordz"
Date: Thu, 10 Sep 1992 13:58:03 GMT

In article <1992Sep9.205851.26422@midway.uchicago.edu>
stderic7@cicero.spc.uchicago.edu (Eric Camburn) writes:

:I would like to install a spreadsheet program on a Hewlett Packard
:730 workstation with a UNIX operating system.  I'd appreciate knowing
:what companies if any have produced programs for this platform, and 
:any opinions about which programs are better than others.

I've used (and liked) Wingz from Informix.  The latest rev for the HP
is Wingz 1.1b, but Wingz 2.0 is coming out RSN.  Nice, well-behaved X
application.  I'd contact your local Informix person for more info.

						...Mike

-- 
 Michael J. O'Connor           |  Internet:  mjo@fmsrl7.srl.ford.com
 Ford Motor Company, OPEO      |  UUCP:      ...!{backbone}!fmsrl7!mjo
 20000 Rotunda, Bldg. 1-3001   |  Phone:     +1 (313) 248-1260
 Dearborn, MI  48121           |  Fax:       +1 (313) 323-6277
Xref: sparky comp.apps.spreadsheets:479 comp.os.ms-windows.apps:2543
From: 5916rahmank@vms.csd.mu.edu
Newsgroups: comp.apps.spreadsheets,comp.os.ms-windows.apps
Subject: Re: EXCEL question (axis labeling)
Date: Mon, 07 Sep 1992 15:41:56 GMT
Organization: Marquette University - Computer Services
Reply-To: 5916rahmank@vms.csd.mu.edu
NNTP-Posting-Host: vmsd.csd.mu.edu

In article <1992Sep6.132931.597@rhrk.uni-kl.de>, chenina@rhrk.uni-kl.de (Robert Chenina [Chemie]) writes:
>	Hi!
>	Here's my question:
>	When using Excel is it possible to make this axis title:
>
>	                   ----------------> Times font, size=20
>	                   |    |      |
>
>	<DELTA><EPSILON> / l . mol-1 . cm-1
>
>	 ^^^^^  ^^^^^^^           ^^     ^^
>	   |       |              |       |
>	   ---------              ---------
>	       |                      |
>	Symbol or Greek               Helvetica font, superscript, size=16   
>	font, size=20
>
>	Any help will be very appreciated.
>		Thanks,
>			Robert
> --
>  ****************************************************************************
>  * Robert Chenina, Dpt. of Physical Chemistry, University of Kaiserslautern *
>  *          Erwin-Schroedinger-Str, D-6750 Kaiserslautern, Germany          *
>  *             Phone: + 49 631 205 2534, Fax: + 49 631 205 3200             *
>  *                       Email: chenina@rhrk.uni-kl.de                      *
>  ****************************************************************************

One way of doing this is

1. Make the chart on the sheet (not on a chart file with .xlc)
2. Now create a text box below the x-axis
3. Write anything you want with wordprocessing facility in this box.

-Anis.
From: myllynen@klaava.Helsinki.FI (Olli-Pekka Myllynen)
Newsgroups: comp.apps.spreadsheets
Subject: Wingz: Mac files and scripts to Windows?
Keywords: Wingz
Date: 15 Sep 92 19:14:47 GMT
Organization: University of Helsinki

I have been using Wingz on the Macintosh environment for three years
now, and I
am very happy with the application. I have created quite a complex
script for
following the helsinki stock exchange. despite of my efforts to keep
the number
of the spreadsheet files to its minimum, I have now more than 500
files
totalling about 30 Mb.

During the week I have seen several symptoms of breaking down on my
old Mac+.
After five days of intensive fixing and thinking I have to admit that
the time
has come, when I need a new computer. Macs are terribly priced here
in Finland:
with the price of fully functional 486 you get only Mac Classic II. 

I can use the speed of 486 and I think I will learn hacking the
Windows, but
will I lose my Wingz files and scripts? I know there is a Wingz
version for the
Windows, but can it use my scripts? Are Mac and the Windows versions
of Wingz
functionally similar? If not, can anyone tell the differences?

Does the Wingz work decently under Windows?

This is undoubtedly a large question, but when I get some answers, I
can dive
into the details.


If you are not willing to send your views to the world, please email
them to
myllynen@cc.Helsinki.fi

Thank you.
Newsgroups: comp.apps.spreadsheets
Subject: making check catagory acc
From: ken.mason@pcb.batpad.lgb.ca.us (Ken Mason) 
Date: 10 Sep 92 17:39:00 GMT
Reply-To: ken.mason@pcb.batpad.lgb.ca.us (Ken Mason) 
Distribution: world
Organization: The Batchelor Pad PCBoard ~ Long Beach, CA ~ +1 310 494 8084

DF.I want to add additional columns (1 associated with each column of values)
DF.in which to enter the expense catagory (probably numbers between 1 and 15).

        I'm interested in your problem, but you lost me here.  Can you
        post an extract of how you want it to look, then what you want
        to do with your data?
                                                      
Newsgroups: comp.apps.spreadsheets
From: fmonaldo@netnews.jhuapl.edu (Monaldo Francis M. S1R x8648 )
Subject: Re: UNIX Spreadsheet for HP-UX 730
Organization: JHU/Applied Physics Laboratory
Date: Thu, 10 Sep 1992 12:57:54 GMT


We use Xess from Applied Information Systems 1-800-334-5510
on a HP 9000 series 300, though I understand it is also available for
the 700 series.  It less intuitive then say Excel, but has more
scientific and statistical functions. It also allows for real-time links
so that data can be continually updated.  It could act as a front
end for a data acquisition system.  I find it a little slow on a HP340,
but on a 730 it should fly.  Ask for a demo and make your own decision.

One of the things I like about it is that it can export to either
PostScript printers or to a LaTex file.

Frank Monaldo
frank@einstein.jhuapl.edu
From: banshee@cats.ucsc.edu (Wailer at the Gates of Dawn)
Newsgroups: comp.apps.spreadsheets
Subject: Re: Borland is stupid
Keywords: Quattro Pro Lotus
Date: 12 Sep 92 21:28:16 GMT
Organization: University of California, Santa Cruz
NNTP-Posting-Host: am.ucsc.edu


gary@resumix.portal.com (Gary Lin) writes:
>What I really want to know is why doesn't Borland port QPro over
>to UNIX/X?  Lotus already has a product (albeit sucks!) on UNIX and
>is locking up the market.
>If they can do a Windows version, they can do X.

Cause we'd all play nethack and never get any work done.

-- 
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        |
Xref: sparky comp.apps.spreadsheets:478 comp.os.ms-windows.apps:2529
From: chenina@rhrk.uni-kl.de (Robert Chenina [Chemie])
Newsgroups: comp.apps.spreadsheets,comp.os.ms-windows.apps
Subject: EXCEL question (axis labeling)
Date: 6 Sep 92 13:29:31 GMT
Organization: University of Kaiserslautern, Germany


	Hi!
	Here's my question:
	When using Excel is it possible to make this axis title:

	                   ----------------> Times font, size=20
	                   |    |      |

	<DELTA><EPSILON> / l . mol-1 . cm-1

	 ^^^^^  ^^^^^^^           ^^     ^^
	   |       |              |       |
	   ---------              ---------
	       |                      |
	Symbol or Greek               Helvetica font, superscript, size=16   
	font, size=20

	Any help will be very appreciated.
		Thanks,
			Robert
 --
  ****************************************************************************
  * Robert Chenina, Dpt. of Physical Chemistry, University of Kaiserslautern *
  *          Erwin-Schroedinger-Str, D-6750 Kaiserslautern, Germany          *
  *             Phone: + 49 631 205 2534, Fax: + 49 631 205 3200             *
  *                       Email: chenina@rhrk.uni-kl.de                      *
  ****************************************************************************
Newsgroups: comp.apps.spreadsheets
From: jess@gn.ecn.purdue.edu (Jess M Holle)
Subject: Re: import ascii
Keywords: ascii, 123
Organization: Purdue University Engineering Computer Network
Date: Fri, 11 Sep 92 00:35:06 GMT

One comment, MS Excel's reading of text files is VERY slow compared to other
spreadsheets available.

A friend and I just did a test of Wingz vs. Excel for text file importation.
Wingz was MUCH faster.  I don't know Excel very well, but I also believe
that Wingz is somewhat more limited on text formats accepted (i.e. tab
separated columns ONLY, no space or comma separation).

I just thought that this might be of interest to some.

Jess Holle
Newsgroups: comp.apps.spreadsheets
From: WHITESR@APPSTATE.EDU (Steve White)
Subject: Fractional widths in Excel?
Organization: APPALACHIAN STATE UNIVERSITY
Date: Mon, 7 Sep 1992 14:07:17 GMT
X-News-Reader: VMS NEWS 1.24


Is there a way to get Excel/Mac 3.0a or 4.0 to do fractional width
spacing so that when I paste Excel-created picts into Word 4.0,
where fractional widths are enabled, columns of numbers are not
misaligned?  Thx, Steve

Steve White
Bitnet: WHITESR@APPSTATE
Internet: WHITESR@CONRAD.APPSTATE.EDU
Voice: 704-262-6167 (OFFICE)
Newsgroups: comp.apps.spreadsheets
From: louy@ellis.uchicago.edu (janet l mather)
Subject: Re: import ascii
Keywords: ascii, 123
Reply-To: louy@midway.uchicago.edu
Organization: University of Chicago Computing Organizations
Date: Fri, 4 Sep 1992 21:10:00 GMT

In lotus you load the file with /fi then either n for numbers or t for
text.  If you have a string of numbers seperated by spaces in the input
file and prehaps some quoted strings you're done.  If you have to bring
in text then you used the /dp menu do parse the string.  It is pretty
straight forward.
Newsgroups: comp.apps.spreadsheets
From: andrewm@uws.EDU.AU (Andrew Maclean)
Subject: Paradox 4.0 /FLImport
Summary: Apology fo posting to the wrong group.
Organization: University of Western Sydney
Date: Mon, 14 Sep 1992 04:06:58 GMT

I apologize for posting this to the wrong group, but some of it may be
relevant to you.
From: milne@ics.uci.edu (Alastair Milne)
Subject: opinions of multimedia video cards
Newsgroups: comp.ivideodisc
Date: 12 Sep 92 03:30:03 GMT


  My apologies to those who have already seen this.
  I found the subject header had become (none) when this
  posting reached comp.ivideodisc last time.  I tend to ignore
  messages without a subject header, and so, I would think, do others.
  So this is an attempt to get it posted with a header.

  I have received some responses about this, but would certain
  welcome a lot more.  I'm looking for a breadth of opinion,
  particularly from the academic community and language departments.

  Thanks for your patience.

------- Forwarded Message

SUBJECT: OPINIONS OF VIDEO BLASTER, SUPER VIDEO WINDOWS
Date:    Thu, 03 Sep 92 20:12:55 -0700
To:      comp.ivideodisc@ics.uci.edu, comp.multimedia@ics.uci.edu
Cc:      "Rika Yoshii" <ryoshii@ics.uci.edu>
From:    "Alastair Milne" <milne@ics.uci.edu>
- ----------------------------------------


   Hello,

   The clients whose multimedia teaching project we are creating are
   looking for opinions on these two multimedia boards
   [Video Blaster and Super Video Windows].

   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

   Internet: milne@ics.uci.edu
   BITNet: AMILNE@UCI

==================================================

------- End of Forwarded Message

Newsgroups: comp.patents