OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

data analysis results graphs

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
hill0093
General User
General User


Joined: 31 Jan 2010
Posts: 7
Location: Minnesota

PostPosted: Sun Jan 31, 2010 1:54 am    Post subject: data analysis results graphs Reply with quote

I do my data analysis in java and want to write a results file that will convert to a graph that can be further manually "touched-up" like adding notes with arrows, adding or changing titles, deleting points, rescaling, resizing, etc.
Do I need to write a small program in an OO language?
I know nothing about OO.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jan 31, 2010 2:31 am    Post subject: Reply with quote

If you write Java programs for data analysis, installing a 150+MB monster of an office suite just for the limited capabilities of its charting module sounds like a foolish idea.
Spreadsheets are kind of programming language for non-programmers and Calc's charting capabilities are not really bad, but almost non-existent compared to the arsenal of tools you have at hand when you are a developer.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
hill0093
General User
General User


Joined: 31 Jan 2010
Posts: 7
Location: Minnesota

PostPosted: Sun Jan 31, 2010 3:26 am    Post subject: Reply with quote

Thanks for the reply.
Sounds like you might be able to make a suggestion.
Would it be inappropriate just because it's not OO?
Please do.
Or maybe I didn't give enough detail.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jan 31, 2010 3:58 am    Post subject: Reply with quote

If you are a Java developer and know nothing about OOo, what makes you think that this massive GUI-application with its tiny chart module has anything to offer for you?
Are there no charting modules for Java developers? At least I have seen some Java programs or applets with impressing charts.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
hill0093
General User
General User


Joined: 31 Jan 2010
Posts: 7
Location: Minnesota

PostPosted: Sun Jan 31, 2010 5:40 am    Post subject: Reply with quote

No I am not a java developer, and apparently we are both know-nothings.
Please refrain from useless posts of put-downs.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jan 31, 2010 6:15 am    Post subject: Reply with quote

Yes, I am a know-nothing, but I know that I am.
YOU wrote:
I do my data analysis in java

Java is a programming language. Doing data analysis in Java takes a qualified developer. Developers who actually do their data analysis don't rely on end user programs like this one when it comes to charting.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
hill0093
General User
General User


Joined: 31 Jan 2010
Posts: 7
Location: Minnesota

PostPosted: Sun Jan 31, 2010 7:00 am    Post subject: Reply with quote

True, I am not qualified. That's why I posted.
Please refrain from more informationless posts
cluttering space in my thread.
I'll accept the put-downs.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jan 31, 2010 8:00 am    Post subject: Reply with quote

OK
http://catb.org/~esr/faqs/smart-questions.html
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
hill0093
General User
General User


Joined: 31 Jan 2010
Posts: 7
Location: Minnesota

PostPosted: Sun Jan 31, 2010 1:15 pm    Post subject: Reply with quote

An idea I have is to write a .csv results file for
MS Excel along with a Visual Basic for applications program that
will run when I load the file to plot the data on a Chart.
Then the plots might be touched-up manually as desired for
the particular end usage.
Does this seem plausible?
My colleagues know how to use Excel for touch-up.

Does OO Calc have a similar or the same programming capability?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Jan 31, 2010 2:14 pm    Post subject: Reply with quote

Java, Python, C++, JavaScript, BeanShell and even a plain stupid Basic dialect can be used to call this API. It's very different and more complicated than VBA.

Talking about csv as database exchange format, OOo comes with a fully integrated database module.
Without a single line of code you can define a connection to a directory of equally structured csv files and link tables as well as queries with dynamic spreadsheet ranges and charts. If your csv happens to come from some other database, you might be able to use the database directly without csv as exchange format.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
hill0093
General User
General User


Joined: 31 Jan 2010
Posts: 7
Location: Minnesota

PostPosted: Sun Jan 31, 2010 8:38 pm    Post subject: Reply with quote

We don't use a data base, but it would be nice if we did.
Don't have time to set it up.

Shall I assume that Calc is at least as easy for my colleagues to use as is Excel for
further manual "touched-up" like adding notes with arrows, adding
or changing titles, deleting points, rescaling, resizing, etc.

Let’s consider two kinds of graphs: scatter plots and line-connected points.
The scatter plots could handle several files of data.
One BufferedImage graph I use now plots the points as it reads them, so
it doesn’t have to store them. That program is used to expand and
replot sections. (but we don’t have to do that.)
Some readers might complain that there are more points than are readable,
but that’s not the point because I want every point to be on the plot, and don’t
want to write a program to see which points are on top of each other.

I’ll need some Java code to get my graphs into Calc, so
I need some examples and coding instruction.
Back to top
View user's profile Send private message
hollowhead
General User
General User


Joined: 29 Jan 2010
Posts: 15

PostPosted: Mon Feb 01, 2010 2:58 am    Post subject: Reply with quote

Consider qtiplot, you can buy it for single use very cheaply packaged up, or compile from the sources for free.

Its a great piece of software that will do everything you want and more.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Feb 01, 2010 5:17 am    Post subject: Reply with quote

CSV is a database format (record sets organized in fields).
Certainly, you do not need any code at all to get csv charted in Calc or in database reports. As already mentioned, there are several charting applications doing their job by magnitudes better than any spreadsheet.

If it is a matter of branding ("has to be like Excel at any cost") then I'd still recommend the original by Microsoft simply because people are never disappointed by Excel, whatever it does, however it fails.

This is the spreadsheet forum of oooforum.org still trying to discuss questions about using spreadsheets from a user's perspective (entering/pasting stuff, calculating with formulas, formatting output, clicking together simple spreadsheet charts, dealing with file formats,...)

There is another forum for API related questions and the world wide largest repository for code snippets in another forum.

development.openoffice.org is the place to start for coders (API coders as well as source code hackers).
An introduction into this highly complex API concepts takes more than one or two weekends. The charting API is not among the trivial parts.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
jrkrideau
Super User
Super User


Joined: 08 Aug 2005
Posts: 6732
Location: Kingston ON Canada

PostPosted: Mon Feb 01, 2010 3:36 pm    Post subject: Reply with quote

hill0093 wrote:
We don't use a data base, but it would be nice if we did.
Don't have time to set it up.

Shall I assume that Calc is at least as easy for my colleagues to use as is Excel for
further manual "touched-up" like adding notes with arrows, adding
or changing titles, deleting points, rescaling, resizing, etc.

Let’s consider two kinds of graphs: scatter plots and line-connected points.
The scatter plots could handle several files of data.
One BufferedImage graph I use now plots the points as it reads them, so
it doesn’t have to store them. That program is used to expand and
replot sections. (but we don’t have to do that.)
Some readers might complain that there are more points than are readable,
but that’s not the point because I want every point to be on the plot, and don’t
want to write a program to see which points are on top of each other.

I’ll need some Java code to get my graphs into Calc, so
I need some examples and coding instruction.
\

Why are you re-inventing the wheel? A decent statistics and graphing package is far more suitable and less time consuming unless you are doing something really, really weird.

Have a look at R. It would likely do anything you want with a lot less work. The graphics several orders of magnitude better than anything that you will get with a spreadsheet program.

R http://www.r-project.org/

For some examples of what you can do with R graphics see some of what it can do.

As far as I can see from your comments on scatter plots and line graphs, your requirements are pretty basic for R.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group