Posts

Home Loan EMI Calculator – Bank Accurate with Prepayment & Extra EMI

Image
Home Loan EMI Calculator (Bank Accurate) Calculate your EMI using the same reducing balance method used by banks. See how paying extra EMIs reduces tenure and saves interest. Loan Amount (₹) Annual Interest Rate (%) Loan Tenure (Years) Extra EMIs per Year (optional) Calculate EMI 📥 Download Google Sheet (Make a Copy) 👉 Enter details and click Calculate EMI Money Split Outstanding Loan Balance Over Time Month EMI Interest Principal Extra EMI Balance
Post a Comment
Read more
Image
Google Form Leave Approval System with Auto Email, Attachments & Manager Action Buttons Google Form Leave Approval System with Auto Email, Attachments & Manager Action Buttons This tutorial shows how to automate leave request approvals using Google Forms, Google Sheets, and Apps Script. Trigger auto emails on form submit CC manager with in-email action buttons Update status in Google Sheet 🧾 Google Form Structure Create a Google Form with the following fields: Full Name Email ID Manager Email ID Leave Type Start Date End Date Duration Reason 📊 Google Sheet Columns After linking your form to Google Sheets, add 3 columns: Status – Manager’s decision Approve Link Reject Link ⚙️ Apps Script Setup Open your linked Sheet → Extensions > Apps Script and paste the following code: ...
Post a Comment
Read more
Image
Send Birthday Email Reminders using Google Sheets & Apps Script Send Automatic Birthday Reminders using Google Sheets & Google Apps Script This tutorial shows you how to use Google Sheets and Apps Script to send automatic email reminders for birthdays — be it for friends, family, or office colleagues. A scheduled trigger will run daily and send beautiful HTML emails when a birthday matches today's date! 📋 Step 1: Setup Google Sheet Create a new Google Sheet and name it Birthday Reminder Tracker . Use the following structure: Column Details Sr No 1 Name Jane Doe Birthday 1995-06-28 Email janedoe@email.com Reminder Time (HH:MM) 09:00 Last Sent (empty) Reminder Time: This lets you define when to send the mail (in 24-hour format like 08:30 or 17:45). Last Sent: This column will be updated automatically to avoid duplicate mails. 💻 Step 2: Add Google Apps Script Click Extensions → Apps Script Clear any default code Pas...
Post a Comment
Read more
Image
Automate Google Sheets Task Tracker with Apps Script ✅ Automate Task Completion in Google Sheets Using Apps Script Welcome to Scripted Success Master ! In this step-by-step guide, you’ll learn how to: Create a task management system in Google Sheets Automatically move completed tasks to a separate sheet Track completion date and calculate TAT (Turnaround Time) Use Google Apps Script to power it all 🧱 Step 1: Create the Google Sheet Structure Sheet 1: Task List Rename the first sheet to Task List and create the following columns: ℹ️ Use Data Validation (Dropdown) in the Status column for values like: Not yet Started , WIP , Completed Sheet 2: Completed Tasks Create a new sheet and rename it to Completed Tasks . Add these headers: Column Header Note A Sr No From Task List B Task Description From Task List C Start Date From Task List D Priority From Task List E Status...
Post a Comment
Read more