4.33333

4.3 | 3 ratings Rate this file 102 Downloads (last 30 days) File Size: 75.96 KB File ID: #28177
image thumbnail

3D Surface Plots from Excel Data GUI

by Christopher Rouxel

 

12 Jul 2010 (Updated 16 Sep 2011)

Upload data from Excel and plot in 3D as a scatter plot, lsq curve fit, contour plot and others.

| Watch this File

File Information
Description

Allows users to import data from excel and easily create 3D graphs in Matlab. Capable of exporting and importing Z axis matrices, exporting pictures of the graphs, automatic labeling of the surfaces, and tools for comparing two different surfaces. Can be used as a visual aid or for analysis.

 This GUI can be used for many applications in many industries. For example, it can be used to simplify and streamline the design process where the characteristics of a component in a system is highly nonlinear. Using least square fit algorithm, the jumble of data becomes an intuitive 3D surface which can be rotated and the optimal size/speed/etc. can be chosen.

Go from excel to Matlab to .png pictures in a matter of minutes.

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
interpsinc.m

MATLAB release MATLAB 7.8 (R2009a)
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Comments and Ratings (3)
13 Jul 2010 Ying Hu  
08 Oct 2011 Mr Smart  
08 Apr 2012 College of Mechanical and Transportation  
Please login to add a comment or rating.
Updates
12 Jul 2010

-Added variable tolerance button

13 Jul 2010

-Created user-defined tolerance surface button
-Created custom colormap for combine surfaces button
-Rewrote "Excel Import FAQ" button

13 Jul 2010

Shout-out to Doug's Instructional videos

17 Jul 2010

-

18 Jul 2010

-Updated description

21 Jul 2010

-

10 Aug 2010

-

11 Aug 2010

-Title

22 Sep 2010

-

27 Oct 2010

-Cross-platform compatibility bug: the xlsread function works differently on Macs then on PC's. If you are using a PC and have issues, try saving the file in the .CSV format and modifying the code to look for and accept CSV data files.

16 Sep 2011

Deleted the xlsinfo functions which made this file not work on PC's. Now everyone can use it!

Tag Activity for this File
Tag Applied By Date/Time
3d Christopher Rouxel 12 Jul 2010 12:12:29
gui Christopher Rouxel 12 Jul 2010 12:12:29
data import Christopher Rouxel 12 Jul 2010 12:12:29
design Christopher Rouxel 12 Jul 2010 12:12:29
scatter plot Christopher Rouxel 12 Jul 2010 12:12:29
performance map Christopher Rouxel 12 Jul 2010 12:12:29
performance enveloppe Christopher Rouxel 12 Jul 2010 12:12:29
robotics research group Christopher Rouxel 12 Jul 2010 12:12:29
self_rating Matt Fig 12 Jul 2010 23:58:20
lsqcurvefit Christopher Rouxel 13 Jul 2010 00:00:36
gui SHAKIR NAEEM 24 Sep 2010 02:09:51
gui Nik 11 Oct 2010 05:23:09
3d Andrew 13 Oct 2011 22:19:56
3d farid 17 Dec 2011 21:25:20

Contact us at files@mathworks.com