contact@overleaptech.com +91 841-291-4356 +91 985-081-5599

Individual Occupancy Chart by Working Day : We developed this for Human Resource (HR) Team

This tool is completely build for employees of the organization & internal teams to know how many process were there and who is working on which project at the same time occupancy of the employee

  • Easy to Operate and can be replicated
  • Easy to Amend/Modify
  • Customized Design as per requirement of client

Tools Used : Microsoft Excel / VBA

Project Audit Tool : We developed this for Finance Team

Why we developed this ?

This tool was developed for one of the client who were looking for excel based solution for managing the Project Audit information for its project Audit.

Tools Used : Microsoft Excel / VBA

Process Automation for sending emails : We developed this for Supply Chain Team

Why we developed this ?

This tool was developed for one of the client who were looking for excel based solution for managing the daily email sending with same process every day of downloading the data and sending emails with today’s data.

Tools Used : Microsoft Excel / VBA

Process Automation for Executive Target Vs Actuals : We developed this for Sales Team

Why we developed this ?

This tool was developed for tracking who achieved the target and who have scored how much

Tools Used : Microsoft Excel / VBA

Process Automation for Inventory Management : We developed this for Sales Team

Why we developed this ?

This tool was developed for tracking Inventory from each region and each NEWS – North East West South with specification from customers

Tools Used : Microsoft Excel / VBA

Process Automation for Request for Quotation : We developed this for Supply Chain Teams

Why we developed this ?

This tool was developed for requesting the information from suppliers who can provide the information and then we can do the analysis post receipt of data

Tools Used : Microsoft Excel / VBA & User form from Excel

Cause and Effect Diagram: We developed this for Supply Chain Teams

Why we developed this ?

The fishbone diagram or Ishikawa diagram is a cause-and-effect diagram that helps managers to track down the reasons for imperfections, variations, defects, or failures. The diagram looks just like a fish's skeleton with the problem at its head and the causes for the problem feeding into the spine.

Tools Used : Microsoft Excel / VBA & User forms from Excel
Entering the information as final output

LOGISTICS - KPI DASHBOARD 2020: We developed this for Logistics Teams

Why we developed this ?

Developed this for logistics team who need OTD , Spend comparison

Tools Used : Microsoft Excel / VBA & User forms from Excel

Astrology Excel Support : We developed this for Astrology

Why we developed this ?

One of our contact required for something in excel where he can track the information on astrology

We have developed this for them which help them to manage their Analysis

Tools Used : Microsoft Excel / VBA & User forms from Excel

Real Estate Dashboard: We developed this for Real Estate Team

Why we developed this ?

One of our client required for something in excel where he can track the information on real estate dashboard

We have developed this for them which help them to manage their Analysis

Tools Used : Microsoft Excel / VBA & User form from Excel

WhatsApp Icon