|
|
| 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
|
|
|
| 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 |
|
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