Question regarding the Spredsheet link EX tool
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hello,
I have a question regarding the Spredsheet link EX tool for matlab.
I'm only learning matlab so please bear with with.
I created a fuzzy logic model in Matlab. The model outputs the tip to give to a waiter depending on the the quality of the food, service and atmosphere (all score 1-10) in a restaurant.
If I was to evaluate a set of inputs in matlab I would use this code:
Model = readfis('tipping_model');
evalfis([5 6 8], Model);
My question regards calling this function in excel with the spreadsheet link tool.
Here is an example. I have scores from 1-10 for each of the three inputs in Columns A-C. I would like to evaluate them the in the fuzzy logic model and insert the output in column D.
![](https://www.mathworks.com/matlabcentral/images/broken_image.png)
I would be grateful if anybody has to time to explain how I could do this?
Thank you
John
0 comentarios
Respuestas (1)
Sarah Wait Zaranek
el 27 de Dic. de 2012
These sections in the documentation should walk you through the basics of using Spreadsheet Link EX.
0 comentarios
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!