EMFPS

27/08/2023

https://emfps.blogspot.com/2023/08/accounting-software-for-dealers-traders.html

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

04/06/2023

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]

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

26/04/2020

Artificial Intelligence by Using Microsoft Excel
Internal Control Systems
In set theory, we define the intersection of many sets as the set containing all common elements belong each set. On the other hand, we have the regions consist of elements which are only in one set and no others. As you can see on below Venn diagram, there are many intersections among sets of “A”, “B”, “C” and “D” and also uncommon areas of these sets. Please be informed that finding and obtaining these common and uncommon regions is very important for someone who is working as an expert in Internal Control Systems. Let me tell you two real examples that I faced them during the period of last year. Example (1): There are often the sales personnel who have access to change unit price of products sold in system. He/ she can be involved in fraud to decrease unit price of many products included in sales invoice for a special customer. Nobody usually care the unit prices on sales invoices, if your company has large variety of the products. As the matter of fact, it is impossible. Now, suppose CEO of company needs to control and compare all sales invoices with the basic unit prices defined on system during the period of the last three months. How can you do?
For any consultancy services in this case, please do not hesitate to send your request to my address: WhatsApp: +989109250225

26/04/2020

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

09/02/2019

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.

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

09/02/2019

Analysis and Design Open Oscillatory Systems with Forced Harmonic Motion (3)

This is an example for the Big Data Science Analysis with Microsoft excel plus VBA to create the value from data.

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

09/02/2019

Analysis and Design Open Oscillatory Systems with Forced Harmonic Motion (2)

This is an example for the Big Data Science Analysis with Microsoft excel plus VBA to create the value from data.

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

09/02/2019

Analysis and Design Open Oscillatory Systems with Forced Harmonic Motion (1)

This is an example for the Big Data Science Analysis with Microsoft excel plus VBA to create the value from data.

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

09/02/2019

A Model for Making Two Ways Stochastic Matrix

This is an example for solving a system of nonlinear equations in two directions by using the Big Data Science Analysis with Microsoft excel plus VBA.

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

09/02/2019

A Model for Accounting Control Systems Made by Using a New Idea in Set Theory

This is a model for solving a system of many linear equations by using the Big Data Science Analysis with Microsoft excel plus VBA.

https://emfps.blogspot.com/2015/10/a-case-of-accounting-control-system.html

Note: "This article gives the idea to professional people someone who are working in the fields of Machine learning, Deep learning, Big Data Science and so on in which they can use other programming languages to solve the problem mentioned in this article. "

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

09/02/2019

A Model for Analysis of Bond Valuation 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. You can also develop this model to analyze the share price of a company.

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"

09/02/2019

Creating New Logic’s Laws by Using Coding in Microsoft Excel

"This is a blog about executive methods for solving of the problem in the field of Management Consulting"