Powered By Blogger

Thursday, June 15, 2023

Solving COMPLEX CAPTCHAs by Using an Analytic Model Made by Microsoft Excel

 

Nowadays, there are three types of CAPTCHAs, including text-based, picture-based, and sound-based. One of the most complicated picture-based CAPTCHAs is to match a given number which is equal to the total sum of many other numbers into a picture.

Suppose CAPTCHA gives you a picture of twelve dices and asks you to match a given number such as 48 which is equal to the total sum of some dices in the picture.





It could be impossible because you have to solve 2^12 scenarios (4096 scenarios) in a very short time.

This analytic model can help us to find the answer.



As you can see, we enter the given number into cell “B2” then all numbers of the dices into cell “B3”. If the status is “OK”, this is the answer. Otherwise, the answer is negative or “REJECTED”.

Please see the video of this model:




First, I assume all 12 dices are equal to 6. Then I changed some numbers where the total sum would be equal to the given number.

When the status returns to “OK”, we can obtain one answer or more, which are the alternative answers. 

If you have any question, please do not hesitate to send it to my email:

Soleimani_gh@hotmail.com



Saturday, June 3, 2023

Decision Making Methods: Shanon Entropy, AHP, ANP, ISM, SAW, TOPSIS, VIKOR, ELECTRE, DEMATEL

You can find attached the links to the excel spreadsheets which include at least a sample of the decision-making methods below:


 AHP: 
 https://docs.google.com/spreadsheets/d/16k7sfeXzS5vjxZT0R8syksFKlBhXGzty/edit#gid=107806602


 ANP: https://docs.google.com/spreadsheets/d/1j766DLGXSkyODCr08VGN3z5y9roc4llX/edit#gid=2105940568

 ISM: https://docs.google.com/spreadsheets/d/1U1ZaBVDtkN29mZz6ur-HbsotZVNy82OS/edit#gid=1639052690

 SAW: https://docs.google.com/spreadsheets/d/1Jjnoz79mxKbD5GbkyD8rgJdmok81hTGh/edit#gid=398772179

 TOPSIS: https://docs.google.com/spreadsheets/d/1Jjnoz79mxKbD5GbkyD8rgJdmok81hTGh/edit#gid=398772179

 VIKOR: https://docs.google.com/spreadsheets/d/1Jjnoz79mxKbD5GbkyD8rgJdmok81hTGh/edit#gid=398772179

 ELECTRE: https://docs.google.com/spreadsheets/d/1Jjnoz79mxKbD5GbkyD8rgJdmok81hTGh/edit#gid=398772179

 DEMATEL: https://docs.google.com/spreadsheets/d/1jrHhC2PJJRqF6FTmB2CQgB-GgHvsWuvq/edit#gid=476016403


 10 C Model Decision Making method of ELECTRE: https://docs.google.com/spreadsheets/d/1JI0u4Gu3frs2kBmNmdbyb05xvYrW8BfX/edit#gid=404290178



  If you need any support do not hesitate to send your request to my email: soleimani_gh@hotmail.com

Monday, April 27, 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: soleimani_gh@hotmail.com Phone number: +98 9109250225





Wednesday, October 17, 2018

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








Law (1):

(p → q) I ((p → q) → r) I (((p → q) → r)) → s) I ((((p → q) → r)) → s) → t) I……

This Logic always “TRUE”

Examples:

Law (1) for three propositions (variables)



Law (1) for four propositions (variables)





Law (1) for five propositions (variables)




Law (2):


(p → q) & ((p → q) → r) & (((p → q) → r)) → s) & ((((p → q) → r)) → s) → t) &……

This logic, under below conditions always is “TRUE”:

·     -    p = False and other propositions (variables) are “TRUE”

·      -   p and q = False and other propositions (variables) are “TRUE”

·     -    All propositions (variables) are “TRUE”


Examples:

Law (2) for three propositions (variables)




Law (2) for four propositions (variables)




Law (2) for five propositions (variables)




To be continued .....

Tuesday, September 25, 2018

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



 Following the article of Analysis and Design Open Oscillatory Systems with Forced Harmonic Motion (2), the purpose of this article is to present a model for finding the characteristics of an oscillatory system with forced harmonic motion where the acceleration will be equal zero. In this case, there is an interesting point that is related to an important difference between SHM and an oscillatory system with forced harmonic motion.


If an object is oscillating under simple harmonic motion, its linear velocity will be zero at the highest and lowest points where we have maximum displacement which is named the amplitude (A).On the other hand; at the maximum level of the displacement (x = A), the acceleration has also its maximum magnitude while at the middle (x = 0), acceleration is zero due to stop at those points in order to change direction while velocity gains its maximum magnitude at the equilibrium point (x = 0). At the extreme ends (x = A), when we have the maximum force and kinetic energy, the acceleration has its maximum magnitude. Therefore, the maximum of acceleration magnitude in simple harmonic motion occurs at maximum displacement (A) and acceleration at the middle is zero when we have the displacement equal to zero just like the below diagrams: 





But there is a different story about the oscillatory systems with forced harmonic motion. In this case, at the some points where the displacement is not zero (x = a), we have the acceleration equal to zero. Please see below diagrams:




Now, the question is: What are the characteristics of an oscillatory system with forced harmonic motion where we have the acceleration equal to zero at the point of x = a?
Below model is able to answer above question:






The components of above model are as follows:

1. In right side on cells L6:M6, we have inputs including given data of “Fm”, and “t”.
2. In left side on cells H6:J7, we have other inputs including lower and upper ranges for independent variables of “m”, “b” and “ω″/ω” to reach the answers for the acceleration equal to zero which are the characteristics of driven oscillatory system. Here, there are lower and upper ranges which are changed by click on cell A2 and also this change will again go back by click on cell B2 (Go & Back).
3. On cells I9:I18, we have outputs which are the characteristics for driven oscillatory system responding to the acceleration equal to zero.
You can see below clip as the example for this model:


All researchers and individual people, who are interested in having this model, don’t hesitate to send their request to below addresses:



Sunday, September 2, 2018

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






Following to articles of “Analysis and Design Open Oscillatory Systems with Forced Harmonic Motion (1)” (https://emfps.blogspot.com/2014/02/analysis-and-design-open-oscillatory.html) and “A Model to Solve a System of SHM Equations” (https://emfps.blogspot.com/2018/08/a-model-to-solve-system-of-shm-equations_23.html), the purpose of this article is, to find out the characteristics of unknown open oscillatory system which is under forced harmonic motion in the moment of close to resonance. In this case, three models have been designed. One model presents the results for two independent variables “m”, “b” and  another model gives us the results for three independent variables “m”, “b” and “ω''/ω” and the third model shows us the results for higher than a specific velocity.

Statement of the problem

In many situations of oscillatory motions, we have to control the point of the resonance to prevent a huge collapse of system. On the other hand, sometimes we need to know the width of the resonance curve and the characteristics of the system such as natural frequency to increase the velocity of the system by using a forced harmonic motion. In fact, the question is: What is the amount of the force and angular frequency for a forced harmonic motion where the amplitude and velocity of an oscillatory system will significantly increase? These two models are able to answer to this question.

Model (1): The results for two independent variables “mass” and “linear damping constant”

Please be informed that here we encounter with seven independent variables and we have to process all these variables simultaneously for solving the nonlinear equations. For first try, I breakdown the problem and start my analysis by using the most important independent variables which are “m” and “b” and also utilizing the method mentioned in article of “A Model to Solve a System of SHM Equations” (https://emfps.blogspot.com/2018/08/a-model-to-solve-system-of-shm-equations_23.html) accompanied by some tricks in Microsoft excel. I think this is the easiest way. This model says us what are maximum displacement and velocity for a defined range of “m” and “b” close to the point of the resonance.

Below figure as well as shows you the components of this model:





The components of above model are as follows:
1. In right side on cells K6:M6, we have inputs including given data of “ω″/ω”, “Fm”, and “t”.
2. In left side on cells H6:I7, we have other inputs including lower and upper ranges for independent variables of “m” and “b” to reach the answers which are the solution for driven oscillatory system close to the point of the resonance. Here, there are lower and upper ranges which are changed by click on cell A2 and also this change will again go back by click on cell B2 (Go & Back).
3. On cells I9:I17, we have outputs which are maximum displacement and velocity for driven oscillatory system close to the point of the resonance.
Note: On I9 and I10, we have maximum displacement and velocity for a defined range of “m” and “b”. Please do not consider them as the amplitude of harmonic motion. On cell I16 and I17, we have the amplitude of displacement (A) and the amplitude of velocity (Av).

You can see below clip as the examples for this model:






Model (2): The results for three independent variables “mass”, “linear damping constant” and “ω″/ω”

In this model, there are the defined ranges for “m”, “b” and “ω″/ω” which are our three independent variables and by changing the forced harmonic motion (Fm) and time (t), we are willing to know what are the characteristics of a unknown oscillatory system that give us the maximum displacement and velocity close to the point of the resonance.
Below figure as well as shows you the components of this model:



The components of above model are as follows:

1. In right side on cells L6:M6, we have inputs including given data of “Fm”, and “t”.
2. In left side on cells H6:J7, we have other inputs including lower and upper ranges for independent variables of “m”, “b” and “ω″/ω” to reach the answers which are the solution for driven oscillatory system close to the point of the resonance. Here, there are lower and upper ranges which are changed by click on cell A2 and also this change will again go back by click on cell B2 (Go & Back).
3. On cells J9:J17, we have outputs which are maximum displacement and velocity for driven oscillatory system close to the point of the resonance.
Note: On J9 and J10, we have maximum displacement and velocity for a defined range of “m”, “b” and “ω″/ω”. Please do not consider them as the amplitude of harmonic motion. On cell J16 and J17, we have the amplitude of displacement (A) and the amplitude of velocity (Av).

 You can see below clip as the examples for this model:





Model (3): The results of three independent variables “mass”, “linear damping constant” and “ω″/ω” for higher than a specific velocity


In this model, we want to design an unknown oscillatory system for a specific velocity. We can have all characteristics of the system for focus, lower and higher than a specific velocity. Here, I consider it for a higher than specific velocity. Since there are many answers, I have only fixed 15 answers for this model.

 Below figure as well as shows you the components of this model:



As you can see, all components of this model are the similar to model (2). Only I have added15 absolute value for velocities more than a specific velocity and also on cell M7, we have specific amount of velocity.

You can see below clip as the examples for this model:



Data Analysis and Conclusion


 One of the most important applications of above models is to create the value from data analysis. Please see below results:



Above table shows us that there are many answers for a constant velocity. But if you carefully focus on the results, you will find out an interesting property about driven oscillations and resonance.

What is this property?

If an oscillatory system has very low angular frequency (ω) and linear damping constant (b) in the conditions close to the point of the resonance and in zero time (t =0), surprisingly by increasing the mass, the displacement  (x) will go up and by decreasing the mass, the displacement will go down. In this situation, the amplitude for any changes on mass will stay the constant forever.

All researchers and individual people, who are interested in having these models, don’t hesitate to send their request to below addresses:



Wednesday, August 22, 2018

A Model to Solve a System of SHM Equations



Following to article of “A Model to Solve a System of Nonlinear Equations by Using Microsoft Excel plus VBA” (http://emfps.blogspot.com/2018/02/a-model-to-track-location-of-particle.html), the purpose of this article is, to present another example about solving a system of nonlinear equations for Simple Harmonic Motion (SHM).

Suppose we have two oscillatory motions which are in two perpendicular directions. We can write a system of equations for them as follows:


Assume the angular frequency for both SHMs is the same and also there is the difference between initial phases equal 90 degree. In this case, we will have below system of equations:

This model is able to solve above system of two equations for given data of “x”, “y”, “Ax” and “Ay”.

 There are two methods for finding “ω”, “t” and “φ”. 

Method (1):

The convert of two equations to one equation and solving only one equation for three independent variables in accordance with the method mentioned in article of “Solving a Nonlinear Equation with Many Independent Variables by Using Microsoft Excel plus VBA” (https://emfps.blogspot.com/2016/10/can-we-solve-nonlinear-equation-with.html) as follows:

Below figure as well as shows you the components of this model:


Let me explain you about the components of above model as follows:

1. In right side on cells L6:O6, we have inputs including given data of “x”, “y”, “Ax” and “Ay”.

2. In left side on cells H6:J7, we have other inputs including lower and upper ranges for independent variables of “ω”, “t” and “φ” to reach the answers which are the solution for system of two nonlinear equations. Here, there are lower and upper ranges which are changed by click on cell A2 and also this change will again go back by click on cell B2 (Go & Back).

3. On cells H10:J24, we have outputs which are the answers to above system of two nonlinear equations.

4. On cell M7, we have Error which is the difference between equation of outputs (-y.Ax /x.Ay) and equation of inputs (Tan (ωt+φ))

5. On cells K10:K24, we have the solution of “x” by replacing the answers.

6. On cells M10:M24, we have the solution of “y” by replacing the answers.

7. On cells O10:O24, we have the difference between item 5 (“x”) and cell L6 which are the errors of our answers.

8. On cells P10:P24, we have the difference between item 6 (“y”) and cell M6 which are the errors of our answers.

You can see below clip as the examples for this model:




Method (2):

Using the method stated in article of “A Model to Solve a System of Nonlinear Equations by Using Microsoft Excel plus VBA” (http://emfps.blogspot.com/2018/02/a-model-to-track-location-of-particle.html

In this method, we directly solve a system of two nonlinear equations.  

Below figure as well as shows you the components of this model:



The explanations of the components are the same with method (1) except the error.
You can see below clip as the examples for this model:





All researchers and individual people, who are interested in having this model, don’t hesitate to send 
their request to below addresses: