The most recent versions of Aspen Plus include the ability to create a linked spreadsheet in Microsoft Excel which can be shared with others who do not have access to the Aspen software: they state, "With Aspen Simulation Workbook, you can automate conceptual design and improve plant decision-making by creating user interfaces for your process models in Microsoft® Excel" .

Below is a link to a recent webinar from Aspen Tech on this subject. (You may need to create a user account with Aspen to view this - there is no cost associated with such accounts). I hope this is helpful!

https://aspentechwebinars.webex.com/ec0701lsp13/eventcenter/recording/recordAction.do?theAction=poprecord&AT=pb&internalRecordTicket=4832534b000000024f8e95daeb57da24673dcbc2cfcb2b21f0c9be2beafd147448c179bcb0980d86&utm_medium=email&renewticket=0&isurlact=true&recordID=35385807&apiname=lsr.php&utm_campaign=04-15-15-ASW-TY.html&utm_source=Eloqua&needFilter=false&format=short&&SP=EC&rID=35385807&RCID=1dac1bf7f60304018c3fd0d1d77f7ecf&siteurl=aspentechwebinars&actappname=ec0701lsp13&actname=%2Feventcenter%2Fframe%2Fg.do&rnd=1604807669&entappname=url0201lsp13&entactname=%2FnbrRecordingURL.do

Thank you very much Mr. Sulkowski. I really appreciate that. That opens me up to a variety of things that could be done with excel workbook. 

Please take a look on the attached paper: 

Fontalvo, J., “Using user models in Matlab® within the Aspen Plus® interface with an Excel® link,” Ingenieria e Investigacion, vol. 34, 2014, pp. 39–43.

The protocol will be similar. 

You don't need to link via excel. You can add to .net project as an COM reference. I don't remember exact reference name but it shoul be similar to aspenhelper or something.

Then you can handle it by trial and error.

Hi.

There is a new complement to link Aspen Plus with Excel. You can also, however, link Aspen Plus with Microsoft Excel manually using a set of macros. You just need to know ho you will import and export data to Aspen plus. Attached you fill find an Excel file linked to a simulation I performed modeling the combustion of biomass. In the Excel file you can change the red cells (in the "Combustion" and "Constants" sheets) as their values will be exported to Aspen Plus. In this file you can also check the macro. What the macro does is to export the data to Aspen Plus, run the simulation, and finally import just the desired data (electricity generated, air emissions, potential heat, and water requirements). After downloading the file please, unzip it, move the "Simulation" folder to your desktop or wherever you want, and do not change the names or the locations of the files within the "Simulation" folder so that the macro can work properly. I recommend you to open the "biomass combustion.bkp" file (located in the "Biomass Combustion" folder) before running the macro in Excel; otherwise it will take too long for the simulation to start. Notice that these files are just a merely academic exercise to show how you could link Aspen Plus to Microsoft Excel, so there are no restrictions in the values you can include in the red cells. Maybe we could work together to improve these files for academic purposes. In the biomass features spreadsheet you will find some data regarding different types of biomass. 

I hope the simulation and the Excel file work properly. Let me know your comments.

Regards.

Please I need some help: can someone explain in details for me how to link aspen plus with Matlab and excel using user model subroutine??  

exp: step by step

-

-

-

-

-

.

.

.

Dears... Currently, I'm working on the valorization of biomass, specifically in the valorization of hemicelluloses to production of furfural. The kinetic model was implemented in Aspen plus, however, this did not work, therefore, I donde in MatLab, then, I'm trying to link the results of matlab (previously send to excel) to Aspen, nevertheless until now, I don't know how to do

I went through all your comments and I clearly understand why you would like to couple excel, Matlab or python (my personal preference) to use special modules or solvers. I have tried it before and it's time consuming. I also think more work needs to be placed in improving the Aspen Simulation Workbook in Excel since it still does not work as expected. One suggestion, if you do not want to dedicate time to learn Fortran, which is not a big difference from Matlab or Python, you can create correlations for your solutions obtained in other software and implement them as calculator blocks in Fortran. That is the fastest way. I hope this helps.