Posts

Showing posts from April, 2015

Unbrick or Recover Xiaomi Redmi 10A and other MTK devices

Case: Your Redmi 10A (probably other MTK devices too) is not turning on and doesn't react to any button pressed nor cable connection. Requisites:   Dead phone USB Cable  You tried tons of tutorials to unbrick the phone and didn't work This image Willingness to even use Linux to fix it (it's not hard) Steps: Create a bootable USB using the image downloaded. Make sure your computer allows booting from USB. Boot the computer from the bootable USB. When booting, a list of options will be shown. Pick the first one: Boot Live system. Once the system is loaded, go to the right-upper corner to connect to Wi-Fi. Once you have internet, use the Firefox browser (click on the icon in the left-upper corner) and download the Linux version of this tool (SP Flash) and save it in the desktop. Unzip the tool downloaded. Download the fastboot version of the stock ROM . Unzip the ROM, to have the folder and files. Click on 'MTK' icon that is in the desktop. In the command line opene

Getting a Value Giving Column and Row on Excel

Image
Many times it's interesting to see how business requires you to use functions from Excel that you don't even know they exist. In this post I have the following mission: I want to know the value of a cell when I write the column and row, consider that column and row can have any identification.   To get the value from a table you must use 2 functions: Match and Index, Match function gives you the position of a given value in a range, therefore it's necessary to first get the position of the column and the row. Once you have both positions use them into Index function that is going to give you the value located in the position you put related to a given matrix.