1.0

1.0 | 1 rating Rate this file 31 downloads (last 30 days) File Size: 1009.88 KB File ID: #13215

Ideal Rankine Cycle Excel Add-In

by David Forstot

 

03 Dec 2006 (Updated 07 Feb 2010)

Code covered by the BSD License  

Integrating MATLAB and Excel - passing structures as input and assigning output to multiple cells.

Download Now | Watch this File

File Information
Description

This demo uses MATLAB Builder for Excel to create an Excel Add-In from a MATLAB function rankine.m. The spreadsheet uses the Add-In to compute the thermodynamic properties of an Ideal Rankine cycle.

Two points of interest to this demo are the use of the MATLAB struct as input and output of the rankine.m function and the distribution of the output values in the struct to multiple cells of the Excel spreadsheet. The use of a struct requires the data passed into and out of the Excel Add-In use the MWStruct object from the MWComUtil library. To distribute the members of the struct into multiple cells for the output, his Add-In is used like an Excel Array function.

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
Ideal Rankine Cycle GUI

Required Products MATLAB Builder EX
MATLAB Compiler
MATLAB release MATLAB 7.9 (2009b)
Other requirements Microsoft Excel
Zip File Content  
Other Files license.txt,
RankineExcel/mcode/build_mcode.m,
RankineExcel/mcode/rankine.m,
RankineExcel/mcode/rankine_addin.prj,
RankineExcel/mcode/XSteam.m,
RankineExcel/Output/rankine_addin.bas,
RankineExcel/Output/rankine_addin_1_0.dll,
RankineExcel/Output/readme.txt,
RankineExcel/readme.pdf,
RankineExcel/UseRankine.xls
Tags for This File  
Everyone's Tags
Tags I've Applied
Add New Tags Please login to tag files.
Comments and Ratings (2)
22 May 2008 iurjhh uzterg  
29 Dec 2008 Tim

eval string in lines 54/55 of of build_mcode.m needs quotes surrounding the 2 file paths if those paths have spaces

Please login to add a comment or rating.
Updates
06 Dec 2006

Updated readme.doc

06 Dec 2006

Fixed units in spreadsheet, mcode, and doc.
Fixed power bug in mcode.

13 Dec 2006

cleaned up typos (3) in VBA code
output cells in spreadsheet remain clear untill a value can be computed - previously displayed zeros.

07 Feb 2010

Updated to work with MATLAB R2009b

Tag Activity for this File
Tag Applied By Date/Time
external interface David Forstot 22 Oct 2008 08:51:06
builder Cristina McIntire 06 Feb 2009 11:00:21
excel struct array Cristina McIntire 06 Feb 2009 11:00:21
 

MATLAB Central Terms of Use

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Terms prior to use.

Contact us at files@mathworks.com