Posts

Showing posts from February, 2018

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

Using INDIRECT in Excel

Image
The INDIRECT function in Excel allows you to reference cells by typing the cell position (for instance: "B2"). To clarify this, look at the first example, you can see in the function bar that it's a direct reference.    In the following example, the indirect function is used with the parameter "D3" as text and brings the same result. Now, as the parameter of the indirect function is text, you can concatenate and build the cell reference by using other cells.      It's clear that using a direct reference (example 1) is better than using the indirect function, however, there are cases where is required to build functions dynamically depending on other values and the indirect function is a great tool to consider for these situations.