A Model for Analysis of Bond Valuation By Using Microsoft Excel plus VBA

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



No comments:

Post a Comment