📊 Google Sheets MIS Automation Dashboard

🚀 Overview

This project is a Google Apps Script-based automation tool designed to simplify MIS reporting, TAT tracking, and dashboard data preparation in Google Sheets.

It helps users automatically generate formulas, track timelines, and convert raw data into structured format for business intelligence tools like Power BI and Looker Studio.

---

🎯 Features

• 📌 Custom menu inside Google Sheets for easy usage
• ⏱️ TAT (Turnaround Time) calculation (hours & days)
• 📊 Sales & MIS dashboard data preparation
• 🔗 IMPORTRANGE helper for multi-sheet data connection
• 🔍 Automated VLOOKUP builder
• 📈 Delay tracking (Planned vs Actual)
• 🗃️ Data transformation (Raw → Database format)
• ⚙️ One-click sheet setup

---

🛠️ Tech Stack

• Google Apps Script (JavaScript)
• Google Sheets
• Excel Formulas & Automation

---

📂 How to Use

1️⃣ Install Script

• Open Google Sheets
• Go to Extensions → Apps Script
• Paste the code and save

---

2️⃣ Initialize Tool

• Reload the sheet
• Click:
  👉 Auto Tools Panel → Initialize Setup

---

3️⃣ Setup Sheets

👉 Auto Tools Panel → Data Processor → Create Base Sheets

---

4️⃣ Use Features

You can now use:

• TAT Calculations
• Delay Tracker
• Import Range Helper
• Lookup Builder

---

📊 Use Cases

• MIS Reporting Automation
• Sales Dashboard Preparation
• Workflow Tracking (TAT & SLA)
• Operations & Performance Analysis

---

💡 Business Impact

• ⏳ Reduces manual work
• 📊 Improves reporting accuracy
• ⚡ Speeds up dashboard creation
• ❌ Minimizes human errors

---

📸 Googlesheet Preview

google sheet

---

🧑‍💻 Author

Ashish Ranjan
📧 ashishranjan11211@gmail.com
🔗 LinkedIn: https://linkedin.com/in/ashishranjanj09

---

⭐ Support

If you found this project useful, give it a ⭐ on GitHub!

---