Fuzzy Control System In Excel

March 11, 2020
fuzzy type1_fuzzy excel

I am currently extending my Type-2 Fuzzy Logic Library so that fuzzy controllers can be implemented through its codebase. The implementation is straightforward if you have the correct structures in place; using an inference system, the most popular of which was discussed by Mamdani (Mamdani, Ebrahim H. “Application of fuzzy algorithms for control of simple dynamic plant.” Proceedings of the institution of electrical engineers. Vol. 121. No. 12. IET, 1974.). An illustration of the Mamdani inference system operation is below (taken from wikipedia):

Mamdani FIS

Testing such a system can be a challenge and for this reason I have created a version of Mamdani FIS in Excel. The structure is quite simple; the workbook implements a 2-input, single output system with 2 rules that can be easily extended if necessary. The inputs and outputs contain 3 fuzzy sets each. An ‘input and results’ sheet provides a mechanism so that the discrete inputs are entered for each variable and the resulting fuzzy output can be observed.

The sheet can be downloaded here

Type2Fuzzy Library Implementation: Mendel, Jerry M., and RI Bob John. 'Type-2 fuzzy sets made simple.'

October 27, 2021
type2_fuzzy type2_fuzzy_library fuzzy python

Introduction to type-2 fuzzy sets

October 15, 2021
type_2_fuzzy fuzzy set

Roc Display in Excel

October 3, 2020
machine_learning classifier roc excel
comments powered by Disqus
hugo_cms 11 fuzzy 10 python 9 machine_learning 5 type2_fuzzy_library 5 cnc 4 type1_fuzzy 4 type2_fuzzy 4 r 3 excel 2 iot 2 it2fs 2 weiszfeld_algorithm 2 arduino 1 classifier 1 development 1 game 1 javascript 1 learning 1 mathjax 1 maths 1 mxchip 1 pandas 1 random_walk 1 robot 1 roc 1 set 1 tools 1 type_2_fuzzy 1 vscode 1 wsl 1