View previous topic :: View next topic |
Author |
Message |
DPlotAdmin Site Admin
Joined: 24 Jun 2003 Posts: 2310 Location: Vicksburg, Mississippi
|
Posted: Fri Feb 13, 2004 5:27 pm Post subject: New Excel examples |
|
|
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:
XYXY
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.
XYYY
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.
XYZSurface
Select an X, a Y, and a Z column (one or more selections). Produce a 3D surface plot.
XYZScatter
Select one or more groups of X,Y,Z columns and produce a 3D scatter plot, one data set per X,Y,Z group.
ZGrid
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. _________________ Visualize Your Data
support@dplot.com |
|
Back to top |
|
|
Ian
Joined: 30 Mar 2004 Posts: 15 Location: Nottingham, UK
|
Posted: Sun Apr 04, 2004 6:51 am Post subject: |
|
|
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 |
|
|
|
|
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
|