Enjoy life...

Posts

Showing posts from December, 2024

Unprotect/ Unhide worksheets in excel workbook

Right click on file Open with any ZIP editor (WinZip, WinRAR, 7-zip) Locate xl\workbook.xml , Edit using any text editor, Search for workbookProtection Just delete whole line including < > Save! Like delete below whole code: <workbookProtection workbookAlgorithmName="*******" workbookHashValue="***" workbookSaltValue="*****" workbookSpinCount="****" lockStructure="***"/>

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); } }