Enjoy life...

Posts

Showing posts from 2024

Excel: Unmerge cells and automatically fill the unmerged cells with the content of the merged cell

Unmerge all cells in column A and B Select all rows in column A and B from your first row of data to your last row of data. Press CTRL+G to open the Go To box Click Special Choose Blank Cells In the formula bar enter = then press the Up arrow. You'll end up with a formula like =A1. DO NOT PRESS ENTER Press CTRL+ENTER and this will populate your formula to all selected cells and simulate a "fill down". Copy-paste as values as required.

Change default audio track from Android

Change default audio track of Video from Android itself! It is very annoying to select your desired audio track or language every time after playing a video. Looking for a way to force play the audio track after playing the video? Here is the solution. Download termux Follow steps for changing 'track 2' to default audio track. After downloading, type following commands in termux. pkg update && pkg upgrade pkg install ffmpeg -y termux-setup-storage (android window will open. Search and allow termux for enabling storage access) cd /sdcard (file must be in internal storage) ls (this will give list of folders, navigate to folder containing video file) ffmpeg -i "name of your video file with extension" -map 0:v:0 -map 0:a:1 -map 0:a:0 -c copy "name of your output file with extension" Done!

import java.util.Scanner; public class SipCalculator { public static void main(String[] args) { // Create a scanner object to get user input Scanner sc = new Scanner(System.in); // Get the principal amount, interest rate, and number of years from the user System.out.println("Enter the monthly investment amount:"); double p = sc.nextDouble(); System.out.println("Enter the annual interest rate (in percentage):"); double r = sc.nextDouble(); System.out.println("Enter the number of years:"); int y = sc.nextInt(); // Close the scanner object sc.close(); // Calculate the monthly interest rate and the number of payments double i = r / 12 / 100; int n = y * 12; // Calculate the maturity value using the formula double m = p * (Math.pow(1 + i, n) - 1) / i * (1 + i); // Display the results System.out.println("The total amount invested is: " + p * n); System.out.println("The estimated return is: " + (m - p * n)); System.out.println("The maturity value is: " + m); } }