Gnumeric from USB key or mini-CD?

2005-08-06 Thread Prof J C Nash

This message is both a query and a suggestion.

I am wondering if anyone has run Gnumeric from a USB key or from a CD. 
If so, under what platforms?


My feeling is that one of the biggest obstacles to the wider use and 
adoption of Gnumeric is that folk have to install it. If we had Gnumeric 
on a USB key and/or on a CD (mini CD with logo would be nice, or even 
full size Gnome tools), especially if major platforms were present, 
those of us who use it could run it when we need to, even as guests on 
other machines.


I'm not an expert compilation/configuration, but willing to work on this 
as I think the eventual payback would be large. I'm guessing that lots 
of folk would use Gnumeric / AbiWord etc. if they didn't have to install 
it. My own particular interest is when I need to run ssconvert somewhere 
to extract files from .xls.


Comments on feasibility and desirability welcome.

JN

--
John C. Nash, School of Management, University of Ottawa,
Vanier Hall 451, 136 Jean-Jacques Lussier Private,
P.O. Box 450, Stn A, Ottawa, Ontario, K1N 6N5 Canada
email: nashjc on mail server uottawa.ca, voice mail: 613 562 5800 X 4796
fax 613 562 5164,  Web URL = http://macnash.admin.uottawa.ca
Practical Forecasting for Managers web site is at
http://www.arnoldpublishers.com/support/nash/
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: missing help

2005-08-17 Thread Prof J C Nash
Having persuaded a friend to start using Gnumeric on her first Linux PC, 
I am embarassed that she points out that the Help functionality is not 
present. I don't have her version of Libranet distro (a Debian variant), 
but my own Xandros 3.0.2 let 1.4.2 be installed via apt and it also says 
it cannot find the specified file when I ask for help contents.


I am willing to help find and document this bug, but could use some 
pointers as to the usual place to find the help file. If it turns out 
to simply be mis-located, perhaps we can get someone who knows deb 
packages to assist in fixing.


John Nash, U of Ottawa School of Management

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


New test spreadsheet for normal distribution

2006-04-14 Thread Prof J C Nash

Much, much later than I had intended, I have prepared a more detailed
test of the normal distribution functions (normdist, norminv, normsdist,
normsinv). This is still not complete, but shows some directions that
tests of these functions could take.

The file is at http://macnash.admin.uottawa.ca/files/normtest.xls

There is a rubbish Sheet3 which can be ignored.

I welcome comments, suggestions, and offers of collaboration on this 
work, which I intend to gradually extend to other functions.


JN
--
John C. Nash, School of Management, University of Ottawa,
Vanier Hall 451, 136 Jean-Jacques Lussier Private,
P.O. Box 450, Stn A, Ottawa, Ontario, K1N 6N5 Canada
email: nashjc on mail server uottawa.ca, voice mail: 613 562 5800 X 4796
fax 613 562 5164,  Web URL = http://macnash.admin.uottawa.ca
Practical Forecasting for Managers web site is at
http://www.arnoldpublishers.com/support/nash/
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


test of normal distribution functions

2006-04-15 Thread Prof J C Nash
Morten is right that some values input for inverses tests are not fair 
to any spreadsheet processor. I hope to find ways to provide more 
informative output, that is, how the calculation fares in relation to 
what is reasonable at the default precision. The current example is VERY 
preliminary, and I simply copied values from one test to another.


Some of the more interesting tests are the bounds ones. These allow 
comparison with simple functions that can be locally computed. There are 
other examples of such functions, and a compromise is needed between 
different objectives to get a nice test.


For the moment I am avoiding the r.foo functions. Later on I hope to add 
to the Gnumeric-specific test files. For the moment I'm concentrating on 
ones that can be saved as .xls. I find these useful to send to Excel 
addicts.


JN


--
John C. Nash, School of Management, University of Ottawa,
Vanier Hall 451, 136 Jean-Jacques Lussier Private,
P.O. Box 450, Stn A, Ottawa, Ontario, K1N 6N5 Canada
email: nashjc on mail server uottawa.ca, voice mail: 613 562 5800 X 4796
fax 613 562 5164,  Web URL = http://macnash.admin.uottawa.ca
Practical Forecasting for Managers web site is at
http://www.arnoldpublishers.com/support/nash/
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: compiling gnumeric etc.

2006-04-25 Thread Prof J C Nash

As Morten points out:
 It is not simple and there are more traps than you might

want.




My own experience is that it is not too difficult to GET the code, but 
the configure/compile/link are far from trivial. The main issues in my 
case have been libraries that are not as recent as Gnumeric wants. 
Unfortunately, installing newer libraries can break other 
applications. There are ways round this I've heard about but not tried, 
in large measure because I haven't found a good tutorial that might be 
entitled How to safely build a program that uses more recent libraries 
than your system uses. I'd be happy to learn of such a HowTo, or to 
contribute to its development by being a suitable test stooge.


One thing I have done is use Debian apt-get source gnumeric to get a 
version of the source code I COULD build. In my case I managed fine with 
1.4.3 on a Xandros 3.02 box, and 1.5.9 on Ubuntu Breezy.


JN

--
John C. Nash, School of Management, University of Ottawa,
Vanier Hall 451, 136 Jean-Jacques Lussier Private,
P.O. Box 450, Stn A, Ottawa, Ontario, K1N 6N5 Canada
email: nashjc on mail server uottawa.ca, voice mail: 613 562 5800 X 4796
fax 613 562 5164,  Web URL = http://macnash.admin.uottawa.ca
Practical Forecasting for Managers web site is at
http://www.arnoldpublishers.com/support/nash/
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: gnumeric-list Digest, Vol 27, Issue 1

2006-07-10 Thread Prof J C Nash
I've seen a number of msgs on this list about compiling a verion, 
usually the latest, of Gnumeric. I've tried myself too.

What I haven't found yet, and not only for Gnumeric, is a good how-to on
actually doing such compiling safely and cleanly without disrupting 
one's working environment. That is, I have 2 main working machines, 
one running Xandros 3.02, which gets Gnumeric 1.4.3 (sigh!) using 
apt-get, and Ubuntu Dapper, which get's (as far as I can tell) 1.59 (it 
may have just got to 1.61). But to really check tests, I need the latest 
release.

The difficulties are that if one tries to install the new libraries, 
existing and needed applications can become unworkable. Some sort of 
safe sandbox (chroot environment) is likely needed. But some good, sane, 
advice would be helpful. I've had suggestions of putting up Gentoo, but 
I've played distro-roulette enough to now be very careful about making 
changes. I've also some critical, everyday things I must keep working.

To ensure that I'm not just complaining, if someone sends me rough notes 
and I get things working, I'll be happy to edit and prepare the HowTo 
and to the extent my schedule allows maintain it. I use Linux, but I'm 
prepared to try to help out on other platforms with editing a HowTo or 
possibly running a WinXP boot that I do have available.

JN  (nashjc _AT_ uottawa.ca for off-list communications)

-- 
John C. Nash, School of Management, University of Ottawa,
Vanier Hall 451, 136 Jean-Jacques Lussier Private,
P.O. Box 450, Stn A, Ottawa, Ontario, K1N 6N5 Canada
email: nashjc on mail server uottawa.ca, voice mail: 613 562 5800 X 4796
fax 613 562 5164,  Web URL = http://macnash.admin.uottawa.ca
Practical Forecasting for Managers web site is at
http://www.arnoldpublishers.com/support/nash/
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: accuracy ...

2006-11-11 Thread Prof J C Nash
The discussion is revisiting a lot of work that was done in the 1950s
and 1960s on floating point arithmetic. The gold standard is to
accumulate in a double length mantissa. On some architectures that was
easy to do. The i386 architecture uses IEEE 754 as far as I am aware (I
have not looked at details for a while). This makes it fairly easy to
double length accumulate reals, but almost all current s/w uses doubles
by default (roughly 15 decimal digits equivalent). This means
accumulations have to be done in quad, which wasn't part of the standard
toolkit.

If I ever get jhbuild to complete, I may even be willing to try.

JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Bug Buddy failure!

2007-01-10 Thread Prof J C Nash
I managed to crash Gnumeric 1.7.0 (on Ubuntu Edgy) three times trying 
same operation.

Had one spreadsheet (xls, opened in Gnumeric), added a sheet, copied a 
region from another file (wb3, opened in Gnumeric), tried paste. Bang.

On third try, I'd opened a new spreadsheet and copied the wb3 info there 
first, then copied again.

So then I thought I'd use Bug Buddy. Not so good!

Bug Buddy has encountered an error while submitting your report to the 
Bugzilla server.  Details of the error are included below.

The component specified doesn't exist or has been renamed.  Please 
upgrade to the latest version.

For the record, things work in ooffice 2.

Maybe this is known. If so, I'll try to upgrade asap, though it's easier 
to use Ubuntu package updates.

JN



___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: strings in gnumeric / awk / etc.

2007-01-16 Thread Prof J C Nash

Some of the issues being raised suggest that a spreadsheet is not the 
right analytic tool. How about a data frame in R? There are easy 
transformations from spreadsheet to data-frame and back (and they should 
be better set up but are not to my knowledge!). R allows character 
strings to be converted to factors which can be very useful in some 
analyses e.g., regressions. There are quite a few character handling 
functions, and some support for regexes, though I will not claim any 
expertise in using the latter.

My own opinion, as a supporter of gnumeric, is that we sometimes try too 
hard to do everything in the spreadsheet.

JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: interest rates

2007-02-09 Thread Prof J C Nash
The important issue is what conventions are used for time and rate.

About 25 years ago I tried to get information on this from Canadian
banks. Some were cooperative. As I recall, the three that responded used
three DIFFERENT rules. This was for weekly payment mortgages.

In Canada, there is a little known law that prescribes that mortgage
interest be computed annually or semi-annually, not in advance.
Moreover, if nominal annual rate is over 6%, the borrower must be
provided with a schedule of payments, or everything defaults to the
6% rate after the fact. There've been some interesting commercial
mortgage cases from the early 80s where rates were around 20% and the
schedule was not correct.

To get to monthly, weekly or daily mortgage payments, you have to know
how many periods there are. For monthly payments, we can use 6 months,
so the working rate is 100 * [(1 + nominal_rate/200)^(1/6) - 1 ]

Is everybody still there?

Weekly or daily? Well, there are, as I recall between 181 and 185 days
(I should check this, it's been a while) in a half-year, depending on
the start date and whether one uses calendar date. Or using days, one
has to decide when things end. Or 365/2 = 182/5. But 182.5/7 is a bit
more than 26 weeks, worse in leap years. Which is where the fun begins.

I'm not sure I want to put canned formulas into Gnumeric or any other
spreadsheet for this, and I would definitely like to see more 
transparent output for mortgage payments.

Of course, in the UK (or at least England as Scotland may have its own
rules) most mortgages are demand loans so use floating rates.

JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: Polynomial regression - Warning

2007-10-09 Thread Prof J C Nash
The type of dialog Adrian suggests would be a very sensible feature. 
Sometimes one really does need to do the polynomial regression, even if 
to show the issues, so it is not right to completely bar an approach. 
However, when we have an interested person, it's a good opportunity to 
point them towards potentially better methods. There was some discussion 
of such dialogs in the 80s for statistical software, and there's some of 
these ideas in some of the packages. Certainly I'm interested in helping 
out on this sort of thing, and have been gradually clawing away at other 
stuff I have to do so I can return to the test spreadsheets, which are 
one way to bring the issues to light.

JN


Adrian Custer wrote:
 Lovely repartee, just the sophisticated answer that gnumeric brings to
 the spreadsheet world.

 Any chance you can craft this into a good popup dialog? e.g.

 You are trying to use SOME_METHOD which exists in gnumeric only
 to allow compatibility with other older spreadsheet programs.
 The computations involved in that method are known to be
 exceedingly problematic. However, you might be able to solve
 your problem using SOME_OTHER_METHOD. Would you like to use that
 instead?

 Of course, this is all over my head. I'm merely hoping to leverage your
 40 years of knowledge into a helpful dialog.

 --adrian


 On Tue, 2007-10-09 at 14:46 -0400, Prof J C Nash wrote:
   
 Polynomial regression was where I came into numerical analysis at the 
 beginning of my academic career 40 years ago. It is a dangerously 
 ill-conditioned problem, meaning that the regression parameters are 
 untrustworthy, though the fit, i.e., the model, may be useful if the 
 calculations are done properly. There are ways of doing it that are 
 less dangerous using orthogonal polynomials.

 Just a warning that it should not be a high priority to add. Let the 
 Excel users drive off the cliff. If it is added for Excel compatibility, 
 then I'd still recommend a Gnumeric does Vista and pop up warnings 
 asking if the dangerous move should be allowed. Come to think of it, one 
 could borrow exactly the Vista popups so folk would blame Bill.

 Seriously, think if you really need polynomial regression or can use a 
 less troublesome approach.

 JN

 ___
 gnumeric-list mailing list
 gnumeric-list@gnome.org
 http://mail.gnome.org/mailman/listinfo/gnumeric-list
 
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: Gnumeric dies on two-means, unequal variances.

2007-10-17 Thread Prof J C Nash
In Gnumeric 1.7.8 distributed with Ubuntu 7.04 (Feisty), selecting the 
Statistical Analysis tool, two-means, unequal variances is like doing 
Alt-F4 or Ctrl-Q: Gnumeric closes. Is this a known bug? If not, I'll 
submit a report.

J Nash

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: JHBuild problem in tester for gtk-doc?

2007-12-01 Thread Prof J C Nash
Is anyone else seeing an error in tester.c in the build process for 
Gnumeric when
gtk-doc is being built?

I'm getting what looks to be a pretty straightforward typo (an unexpected
parenthesis error) when running JHBuild.

If this is a known issue, I'll just wait a couple of days.

JN
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: jhbuild / libgsf

2008-03-25 Thread Prof J C Nash
gnumeric.spec.in is not maintained, see bug 159782.
However, 1.14.6 is correct

Morten

The problem, then, is that jhbuild structure (inc. latest modulesets) is out of 
date, as it builds libgsf 1.14.5. 

I'm prepared to learn how to fix such issues and to dedicate some time to 
maintaining and documenting such matters on an ongoing basis. Indeed, I come 
from a management school and have identified this as a (the?) major threat to 
open source projects. However, I can get there a lot quicker -- and save 
developers dealing with msgs on this list related to build problems -- if I get 
some input from someone with expertise and experience with the scripts. Anyone?

JN




___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


jhbuild / libgsf more info.

2008-03-25 Thread Prof J C Nash
In case it helps others:

I managed to get a gnumeric build by downloading libgsf version 1.14.6 
and doing a manual build of it that matched jhbuild, namely

- download from 
http://download.gnome.org/sources/libgsf/1.14/libgsf-1.14.6.tar.gz
to ~/checkout/gnome2/ 
and unpack
- enter the libgsf-1.14.6  directory
- './configure --prefix=/opt/gnome2'  so the build goes to the same 
place as jhbuild's efforts
- 'jhbuild buildone gnumeric' (I'd already run everything else with 
'jhbuild build gnumeric' before getting an error that the libgsf was 
1.14.5).

Hopefully, I can gradually get more proficient in working with the 
scripts and provide information, fixes, and possibly a build-bot on one 
of my research servers. One of the first things will be to get jhbuild 
up to date with gnumeric.

JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: IEEE 754 compliance

2008-05-13 Thread Prof J C Nash
There are some resources for testing by Nelson Beebe at
http://www.math.utah.edu/~beebe/software/ieee/timops.html  From what I 
understand, the main issues are handling of edge effects (underflow, 
overflow, divide by 0, etc.) where compilers may do some things 
different from the standard's prescription. There is, of course, an 
interaction here with hardware that may not provide ways to get at the 
bits (literally).

In my efforts to set up some Gnumeric test worksheets, I've tried to 
contact Beebe without success. He may have retired (I believe he is 
older than I, and I'm on the brink of retirement from teaching, but not 
from Gnumeric!) 

If there is interest, and in particular an example where IEEE754 may be 
important, I'll be happy to dig a bit. I was a corresponding (ie vote by 
mail) member of the IEEE 754 committee back in late 70s. Given the 
arcane detail, it will take a bit of review for me to get fully up to speed.


JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: IEEE 754 compliance

2008-05-13 Thread Prof J C Nash
The complexities of the edge effects are best kept out of the 
spreadsheet, as Morten indicates. However, there are some computations 
that might be influenced by how a particular internal calculation is 
performed. I was earlier looking at the ends of the Gaussian (normal) 
distribution where one gets some weirdness in Excel. This could be 
because very small numbers are handled poorly.

It is in the special functions etc. that I would think Gnumeric and 
other spreadsheets are most likely to be interested in IEEE 754 and its 
revision.

Must admit I was unaware of 754r activity. Thanks Dave. For info, 
there's a nice Wikipedia item at http://en.wikipedia.org/wiki/IEEE_754r 
with a link to a recent essay by Velvel Kahan (who was really the person 
who got all the floating point stuff going, and in the 1960s pretty well 
embarassed IBM into retrofitting the 360 with guard digits for floating 
point) that gives a nice and nasty example using Excel. I've tried this 
in Gnumeric and get somewhat different results, but which I'm sure would 
upset novice users.

JN


Morten Welinder wrote:
 Gnumeric does not let you access NaN etc.  It would interfere with the
 desired semantics.

 Morten
   
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: gnumeric subversion repository query

2008-05-20 Thread Prof J C Nash
In retesting my build process, I'm getting
svn: Network socket initialization failed
at step 5/47 of the build (gnome-common).

This looks like something is wrong with the subversion server rather 
than at my end. Am I correct? If not, any hints where to start debugging?

Cheers, JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: gnumeric subversion repository query

2008-05-21 Thread Prof J C Nash
I'm using anonymous access to my knowledge. And steps 1-4 go OK.

I've just checked that I can run

svn co http://svn.gnome.org/svn/gnome-common/trunk gnome-common

and get an updated version. So the issue is more likely somewhere in the 
scripts (again!).

JN


Adrian Custer wrote:
 Any chance this is due to your ssh key being thrown out? Sounds like the
 right level in the interaction. If you haven't heard, all debian derived
 distros going back a couple of years were generating trivially weak keys
 so everyone is resetting their ssh keys.

 --adrian


 On Tue, 2008-05-20 at 22:14 -0400, Prof J C Nash wrote:
   
 In retesting my build process, I'm getting
 svn: Network socket initialization failed
 at step 5/47 of the build (gnome-common).

 This looks like something is wrong with the subversion server rather 
 than at my end. Am I correct? If not, any hints where to start debugging?

 Cheers, JN

 ___
 gnumeric-list mailing list
 gnumeric-list@gnome.org
 http://mail.gnome.org/mailman/listinfo/gnumeric-list
 
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


svn checkout woes

2008-05-21 Thread Prof J C Nash
Seems there is a bug report
bugs.debian.org      480038

The problem is in the libsvn1 library on client machine. I'll try to 
figure out the fix. It affects a good deal of jhbuild stuff.

JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


jhbuild svn issue

2008-05-22 Thread Prof J C Nash
I've spent some time trying to downgrade subversion from version 
1.4.6dfsg1-4 without success. Apt was VERY persistent in keeping that 
version. Unfortunately, while I can checkout, for example, gnome-common 
using

svn co http://svn.gnome.org/gnome-common/trunk gnome-common

jhbuild gets Network socket initialization failure.  On the web under 
debian bugs I find Peter Samuelson commenting on having such a problem 
and someone else saying they would look into the jhbuild script 
('jhbuild update' fails too).

I'd really rather not start from scratch to rewrite something like 
jhbuild. This looks like some sort of jhbuild / debian mismatch that 
could be nasty to resolve.

JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: build issues

2008-05-26 Thread Prof J C Nash

Following advice from Priit Laes, I got svn working again but had also 
got it going on a new virtual Debian.

Unfortunately, I seem to be getting loads of bugs with jhbuild, 
particularly concerning python-related problems.  This afternoon, I even 
tried blowing away jhbuild and re-installing as per 
live.gnome.org/jhbuild/, but even that is halting with an error claiming 
I have only automake1.8 rather than 1.9, and failing to find COPYING or 
INSTALL.

Are others seeing similar problems? Or is it time to check my hardware?

JN
___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


More on jhbuild scripts

2008-05-29 Thread Prof J C Nash
The default jhbuild modulesets try to get gcrypt elements from a gnupg 
site that no longer is functional. (Stage 2 etc of the build.) Nor are 
individual source codes there, but one can download a large bz2 or gz 
tarball.

Perhaps there's one or two others out there interested in fixing the 
scripts with me. Doing it alone takes far too long, while back and forth 
gets things fixed better and more quickly.

JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: summer of code projects

2008-06-03 Thread Prof J C Nash
This is very good news. In case it is useful (and perhaps others will add 
notes), I've put in some comments on related work:

Mariusz Adamski : 3D Plots
A physics senior from Wroclaw University of Technology in Poland
who will be working with Jean to add surfaces.
 -- Duncan Murdoch (Maths and Stats, U. of Western Ontario) has done quite a 
lot of 
work on the R package RGL. It does rotating 3D graphs. He's approachable and 
helpful.  I've just done a little item on printing very large graphs with him 
that I put up on the r-project.org wiki. R and Gnumeric have a long and 
friendly history.

Daniel Hall : Audit Trails
A CPA studying CS at the University of Alabama at Birmingham.
He will be working with Morten to extend the undo/redo code
to provide persistence.
-- Daniel already has been in touch with me, since the telltable.com / 
telltable-s.sf.net projects were a motivation to this (but I'm hoping Gnumeric 
will make them redundant!) Capturing history is not too difficult, capturing so 
it can be used easily and cleanly is, I think, likely to be quite hard. There 
are some commercial packages out there (System 7 and Wimmer Systems come to 
mind) that seem to be able to ask for very big bucks from the pharmaceutical 
industry for clinical trial data handling and from financial institutions for 
handling their investment analysis models etc.

David Torne Berga : Multi-Dimensional Data Visualization
Will be working with me on 'data slicers' (aka pivots and pilots)
-- There's a hard core of Excel users who claim this is the reason they can 
never use anything else. I believe in one close-to-home case it is the 
justification for spending on 100s of copies of Excel, though possibly only one 
user ever uses them -- the person controlling the purchase!

Best wishes to those working on these projects.

JN


___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: File causes lockup

2008-06-07 Thread Prof J C Nash
Will do what I can. The names occur multiple time on different sheets, 
including in the sheet names, so it is many, many times to sort out. 
Unfortunately, we've been sent explicit instructions that linking names 
and student numbers in files that are shared with non-authorized staff 
is a no-no under Ontario privacy legislation.


JN

Jody Goldberg wrote:

On Sat, Jun 07, 2008 at 12:50:46PM -0400, Prof John Nash wrote:
  
Some teaching assistants sent me a file related to assignment marks that  
has a sheet per student (about 60 sheets), each with graphics. This will  
not load in Gnumeric 1.8.2 that comes with Ubuntu Hardy. There is lots  
of disk activity for over 5 mins, and no keyboard or mouse control of  
machine. Even Ctrl-Alt-Bsp and Ctrl-Alt-Del gave no response. I  
eventually had to hit the power. Confirmed with 2 tries. OO and kspread  
seem OK, as does Excel 2007 in WinXP.





Sounds like we're over allocating memory.

Any chance of fuzzing the student names in a different application
and sending of a copy ?
  

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: bad file

2008-06-07 Thread Prof J C Nash

I've put a sanitized file at macnash.admin.uottawa.ca/files/badfile.zip

I didn't try this on my laptop, which has suffered enough today, but did 
try loading in a Virtualbox instance of Ubuntu Hardy with Gnumeric 1.8.2 
(the Hardy default) installed. This actually loaded the file, but I then 
had to Force quit Gnumeric. Tried twice to be sure.  So it has at 
least some nasties that a likely worth investigation.


Cheers, JN

___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


Re: statistics graphs

2008-06-08 Thread Prof J C Nash

I think Jean is right to rename


We also might rename the plot_boxplot plugin which implements all these
plots to plot_stats.


However, all the univariate distribution graphs are perhaps named something like

plot_stats_dist

since there are 2D and 3D graphs, as well as some of the high dimensional 
graphs (castles, glyphs, faces, etc.) that eventually may get implemented.

It may be worth looking at the R names, not necessarily because they are a 
great choice, but in case we want to borrow ideas/setup etc.

One trap for the unwary: boxplots and histograms etc. on small samples can be 
very misleading and give different results with different packages. This is the 
issue of how to divide 3 chocolate bars among 4 kids. I've some references if 
needed.

Cheers, JN


___
gnumeric-list mailing list
gnumeric-list@gnome.org
http://mail.gnome.org/mailman/listinfo/gnumeric-list