Question regarding the Spredsheet link EX tool

1 visualización (últimos 30 días)
John
John el 22 de Dic. de 2012
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.
I would be grateful if anybody has to time to explain how I could do this?
Thank you
John

Respuestas (1)

Sarah Wait Zaranek
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.
I would probably start with matlabfcn- http://www.mathworks.com/help/exlink/matlabfcn.html

Etiquetas

Productos

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by