DPlot Forum Index DPlot
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

New Excel examples

Post new topic   Reply to topic    DPlot Forum Index -> Excel
View previous topic :: View next topic  
Author Message
Site Admin

Joined: 24 Jun 2003
Posts: 2290
Location: Vicksburg, Mississippi

PostPosted: Fri Feb 13, 2004 5:27 pm    Post subject: New Excel examples Reply with quote

There is a new group of VBA utility functions for Excel available here: [Update: This download has been removed in favor of the Add-In now distributed with DPlot]. Download this file and unzip to the folder of your choice. The file includes dplotlib.dll and 2 Excel .xls files: examples.xls contains several practical examples of the use of the functions in dplotlib.xls. Open both files in Excel. Dplotlib.xls creates a new menu in Excel that hooks to these VBA functions:

Select alternating X,Y columns and produce an XY plot. Use multiple selections if columns aren't adjacent. Selections may have differing numbers of rows.

Same as above, but X is taken from the 1st column in the selection and all subsequent columns are Y values for separate curves. Y columns may have blank cells.

Select an X, a Y, and a Z column (one or more selections). Produce a 3D surface plot.

Select one or more groups of X,Y,Z columns and produce a 3D scatter plot, one data set per X,Y,Z group.

Select a table with X in the first row, Y in the first column, and the remainder of the table filled with Z values for the corresponding X and Y. Produces a 3D surface plot.

There are several advantages to these routines over Copy/Paste with the current version of DPlot:

  • Data is passed as floating point numbers and internally is independent of the formatting. With Copy/Paste, if you only show 2 decimal places then the data is truncated to 2 decimal places in DPlot. Also, Copy/Paste does not allow (currently) dates, times, currencies, etc.

  • Non-adjacent columns. Currently with Copy/Paste, Excel copies ALL data contained within the extents of all selections, even if it isn't selected.

  • Blank cells are interpreted as you'd expect.

  • The VBA routines take a stab at using the same formatting in DPlot that is used in Excel (dates, for example). At the moment this feature is pretty basic and will most likely be improved upon.

You're of course welcome to take a look at the VBA routines in dplotlib.xls and offer suggestions for new features or improvements if you have any.

After a few rounds of comments/suggestions I'll most likely convert dplotlib.xls to an add-in so that you won't need to remember to load it along with your working spreadsheet. You can do the conversion yourself; if you do so be sure to also copy dplotlib.dll to the folder where the dplotlib.xla add-in is saved.

Questions? Problems? Suggestions? Let's hear 'em.
David Hyde
Back to top
View user's profile Send private message Send e-mail Visit poster's website

Joined: 30 Mar 2004
Posts: 15
Location: Nottingham, UK

PostPosted: Sun Apr 04, 2004 6:51 am    Post subject: Reply with quote

Highly impressive... I find the Torus one the most amazing though, considering my indepth love of the Joint European Torus project http://www.jet.efda.org/!!
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    DPlot Forum Index -> Excel All times are GMT - 5 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