08 April, 2010

Home / Office Excel Tools

Excel base Programs (Home/Office): Designed by:Jignesh.Parmar.

Home Budget Planner/Investment Tracer.
  • Plan Your Home Budget-Monitor Your Daily Expenses.
  • Monitor and track your Investments in KVP, FD, NSC, MIS, Bonds, LIC, Insurance, Postal, Shares, Mutual Funds, Gold, Gems, and Property.
  • Analysis/Compare your Planned Budget and Actual Expenses by Graph.
  • Analysis/Compare your Total Investment by Graph.
  • Analysis your profit-Loss in Share.
  • Analysis your Daily Expenses.
  • Find out Total investment by individual person.
  • Bank Account Details, Cheques Details, Salary Account Details.
  • Monitor your Monthly withdrawals.
  • Monthly Reminder about mature FD, KVP, Bonds, LIC-Insurance Premium
  • Monthly Reminder about Pending Electrical Bill, Credit card.
  • Monthly Reminder about Money Collections.
  • Monthly Reminder about Birthday, Anniversary.
  • Home equipments inventory and warranty reminder.
  • Monthly Salary Details-Calculate Your Income Tax-Generate Income Tax Form(IR1)
  • Choghadiya
Work Orgenizer and Planner
  • Organizer for Personal / Office Tasks.
  • Reminder for Pending Personal/Office Tasks .
  • Monitor /Plan and Reminder for Your Routine Daily Activities.
  • Monitor /Plan and Reminder for Your long term Goals.
Stock Register
  • Excellent Program for Stock inventory and Billing For sending-Receiving Goods
  • Search Material received/Material Issued
  • Received Purchase order/Issue Dispatch Order
  • Search History of issuing material / Receiving material with amount
  • Trace Balance material.
  • Search Received material / Issue material with the reference of PO.
  • Received Bills entry- Cheques entry
  • Pending Bills-Due amount Details
  • Summary of sending –Receiving material.
Invoice Creator/Tracer.
  • Invoice manager is good program to generate Invoices (up to 500)
  • Generate Invoice-Calculate Taxes.
  • Search/Trace your Invoice by its number.
  • Print out Invoice Copy.
Payroll/Attendance/ESI/P.F/Overtime/Incom Tax/Salary slip Generating.
  • Excellent Program for HR Soluction of small Orgenization (Up to 200 employees).
  • Attendance Register/Leave Register/Overtime Register.
  • Personal Leave History & Graph.
  • Calculate Income Tax of Employees.
  • Generate/ Print out Salary Slips.
  • Generate Total monthly Salary Statement of Employee/Employer
  • Calculate Overtime of Employees.
  • Calculate ESI/P.F/TDS/Pension Scheme.
  • Annual Salary statement of Employee and Employer
  • Generation of Form No-6 (For ESIC)
  • Generation of Form no-3A (PF)
  • Generation of Form no-6A(PF)
Appointment Tracer and Planner.
  • This program is very useful to Trace/Monitor an appointment (more than 10 Manages).
  • Indicate appointment time.
  • Get indication is appointment is overlaps.
  • Search Appointment details.
Salary and Income Tax Calculator
  • Calculate Your Liable Income Tax Amount.
  • Monthly Salary Tracer.
  • Calculate your HRA exemption and other Exemptions.
  • Calculate deduction under Chapter VIA.
  • Generate IRA-1 Form for Income Tax Submission.
Generate Income Tax Return Form(IR-1)
  • Generate IRA-1 Form for Income Tax Submission.
P.P.F Calculator.
  • Calculate your PPF Amount.
  • Find when you will liable for Loan against PPF amount.
  • Calculate Loan amount against PPF.
NSC Interest Calculator
  • Calculate your annual interest of your NSC.
  • Easily calculate NSC Purchased from 1989 to 2003.
Car Loan EMI Calculator.
  • Calculate EMI of Car loan by simply applying Loan amount, Period and Interest rate
Simple and Compound Interest Calculator.
  • Calculate simple and compound interest with the help of Graph.
Saving Calculator
  • Calculate Saving Amount with interest.
Loan and EMI Calculator
  • Calculate EMI of loan by simply applying Loan amount, Period and Interest rate
Cheque Book entry Register
  • Monitor Your Cheque Books Entry
  • Print out Your Cheques.
  • Convert cheque Amount in to word format.
Baby Gender Predection Program
  • Predict gender of Baby as per Chinese Lunar Calendar
Baby Boys/Girls Name and Meaning
  • Name of Baby Boys and Girls (more than 12000)
Address Diary and Reminder
  • Digital Diary and Address Book with detail of Name,Address, Mobil, Fax, Blood Group, Email, Birthday.
  • Search detail by name.
  • Birthday Reminder
Calender for 100 Years.

  • Calender for 100 Years
Small Scale Industry’s Production and Material Stock monitoring.
  • Monitor Production of Material
  • Calculate Amount of raw material.
  • Material Inventory.
  • Analysis/ Search Balance material.
  • Find out material Cost
Restaurant(Table Reservation)Program

  • Excellent Program for small Restaurant for making reservation / waiting list for Tables.
  • Indicate reservation of table /Double reservation.
  • Trace availability of Table.
Train Time Table (Excel Base)-1
Train time Table(Excel Base)-2