EMFPS

You can find attached the links to the excel spreadsheets which include at least a sample of the decision-making methods.
If you need any support do not hesitate to send your request to my email: [email protected]

Decision Making Methods: Shanon Entropy, AHP, ANP, ISM, SAW, TOPSIS, VIKOR, ELECTRE, DEMATEL "This is a blog about executive methods for solving of the problem in the field of Management Consulting"

Artificial Intelligence by Using Microsoft Excel
Controlling Accounts

Suppose your job is controlling and auditing accounts to find out the discrepancies between account receivables (sales) and saving accounts in banking systems. Now, consider a manufacturing company which has the network of chain stores (retail chains) and saving accounts in different banks so that all payments made by customers (Sales) in each store can be distributes and deposited among different saving accounts (below figure) something like a network. There are two types of payment: 1. ATM system 2. POS machines. Assume you are willing to compare the payments of customers (account receivables) with different saving accounts in banks for preparing a trial balance to ensure accuracy and reach the balance to zero for a period of three months. What are your challenges? For example:
1. It is possible, there will be simultaneously the transactions which show exactly the same numbers among different stores and banks.
2. The POS systems usually accumulate the payments made by customers. It means that you will not be able to control the accounts item to item and one by one.
3. Sometimes a customer send to you a payment several times. You are expected to recognize these frauds and to claim on the customer.
And maybe other challenges.
I have designed a model which is able to resolve all above challenges. I name this model something like the Artificial Intelligence by using Microsoft Excel.
If you are interested in having this model, please do not hesitate to send your request to my email: [email protected]
Phone number: +98 9109250225

A Model to Solve a System of Nonlinear Equations by Using Microsoft Excel plus VBA

This is an example for solving a system of nonlinear equations by using the Big Data Science Analysis with Microsoft excel plus VBA.
I would like to inform you that this model is able to solve all linear and nonlinear system of equations only by click in which it gives us less error than traditional methods such as Newton – Raphson , Gauss – Seidel, Jacobian and so on. Don't worry, if you have not any knowledge about traditional methods. Dive into new technology.

A Model to Solve a System of Nonlinear Equations by Using Microsoft Excel plus VBA "This is a blog about executive methods for solving of the problem in the field of Management Consulting"