Excel Base Program for Home / Office.

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

Home Budget Planner/Investment Tracer.

System Requirement: MS Office 2007

 DOWNLOAD FREE TRIAL BUY UNLOCK VERSION

  • 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

Daily Planner/Work Organizer/Performance analyzer

System Requirement: MS Office 2007

 DOWNLOAD FREE TRIAL . BUY UNLOCK VERSION

  • Plan your Daily work schedule with the priority index.
  • Schedule Your Appointment.
  • Monitor Your Target Date and Actual Date for Your Task.
  • Monitor Your pending and Completed Tasks.
  • Analyze your performance of Your Activity

Work Organizer and Planner

 FREE DOWNLOAD

  • 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:

 DOWNLOAD FREE TRIAL. BUY UNLOCK VERSION

  • 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.

FREE DOWNLOAD

  • 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.

Salary Master:(Payroll/Attendance/ESI/P.F/Overtime/Income Tax/Salary slip)

DOWNLOAD FREE TRIAL BUY UNLOCK VERSION

  • Excellent Program for HR Solution of small Organization (Up to 200 employees).
  • Attendance Register-Payroll Register-Generate Salary Slip.
  • Track Employees’ Leave history.
  • Track Income Tax of All Employee.
  • Print out Leave History of Employee.
  • Master Data sheet of All Employees.
  • Leave Calculation sheet.
  • ESI Calculation(Set Your Requirements)
  • P.F Calculation
  • Pension Scheme (not more than 541 rs submission)
  • TDS Calculation
  • Annual Salary statement of Employee and Employer
  • Employer Monthly Salary statement
  • Income Tax Calculations
  • Generation of Form No-6 (For ESIC)
  • Generation of Form no-3A (PF)-6A(PF)
  • Calculate half Day attendance.
  • Calculate overtime automatically (Enter only your Daily working Hours)
  • Enter Employee In Time and Out Time.
  • Generate P.F Challan-ESI Challan
  • Generate Form no 12A-No 3A-No 3- No6
  • Calculate Employees belongs in to ESI at Every month
  • Calculate Employees belongs in to PF at Every month
  • Calculate Total Employee at every month.

Appointment Tracer and Planner.

DOWNLOAD FREE TRAIL        BUY UNLOCK VERSION

  • 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

FREE DOWNLOAD

  • 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)

FREE DOWNLOAD

  • Generate IRA-1 Form for Income Tax Submission.

P.P.F Calculator.

FREE DOWNLOAD          BUY UNLOCK VERSION

  • Calculate your PPF Amount.
  • Find when you will liable for Loan against PPF amount.
  • Calculate Loan amount against PPF.

NSC Interest Calculator

FREE DOWNLOAD         BUY UNLOCK VERSION

  • Calculate your annual interest of your NSC.
  • Easily calculate NSC Purchased from 1989 to 2003.

Car Loan EMI Calculator.

FREE DOWNLOAD   BUY UNLOCK VERSION

  • Calculate EMI of Car loan by simply applying Loan amount, Period and Interest rate

Simple and Compound Interest Calculator.

FREE DOWNLOAD     BUY UNLOCK VERSION

  • Calculate simple and compound interest with the help of Graph.

Saving Calculator

FREE DOWNLOAD            BUY UNLOCK VERSION

  • Calculate Saving Amount with interest.

Loan and EMI Calculator

FREE DOWNLOAD     BUY UNLOCK VERSION

  • Calculate EMI of loan by simply applying Loan amount, Period and Interest rate

Cheque Book entry Register

FREE DOWNLOAD

  • Monitor Your Cheque Books Entry
  • Print out Your Cheques.
  • Convert cheque Amount in to word format.

Baby Gender Prediction Program

FREE DOWNLOAD      BUY UNLOCK VERSION

  • Predict gender of Baby as per Chinese Lunar Calendar

Baby Boys/Girls Name and Meaning

FREE DOWNLOAD       BUY UNLOCK VERSION

  • Name of Baby Boys and Girls (more than 12000)

Address Diary and Reminder

  DOWNLOAD FREE TRAIL     BUY UNLOCK VERSION

  • 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.

FREE DOWNLOAD             BUY UNLOCK VERSION

  • Calender for 100 Years

Small Scale Industry’s Production and Material Stock monitoring.

  DOWNLOAD FREE TRAIL            BUY UNLOCK VERSION

  • Monitor Production of Material
  • Calculate Amount of raw material.
  • Material Inventory.
  • Analysis/ Search Balance material.
  • Find out material Cost

Restaurant(Table Reservation)Program:

DOWNLOAD FREE TRAIL   BUY UNLOCK VERSION

  • 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 FREE DOWNLOAD

Train time Table(Excel Base)-2 FREE DOWNLOAD

Advertisements

About Jignesh.Parmar
Jignesh Parmar has completed M.Tech (Power System Control), B.E(Electrical) from Gujarat University. He has more than 14 years experience in Power Transmission-Power Distribution-Electrical energy theft detection-Electrical Maintenance-Electrical Projects(Planning-Designing-coordination-Execution). He is Presently associate with one of the leading business group as a Deputy Manager at Ahmedabad,India. He is Freelancer Programmer of Advance Excel and design useful Excel Sheets of Electrical Engineering as per IS,NEC,IEC,IEEE codes. He is technical Author for "Electrical Mirror" and "Electrical India" Magazines. He is Technical Blogger and Familiar with English, Hindi, Gujarati, French languages. He wants to Share his experience & knowledge and help technical enthusiasts to find suitable solutions and updating themselves on various Engineering Topics.

2 Responses to Excel Base Program for Home / Office.

  1. Raja Shankar says:

    I Really appreciative very nice webpage Mr jignesh.Parmar

    I would ask some question
    What is the difference between Isolator and Buscoupler in HT LT indoor switchgear
    what is the function of isolator in indoor switchgear.

    thanks in advance.

  2. Bhavnesh says:

    Dear Sir
    i have required new versition 2014-15 so pl demo and price of Home Budget Planner/Investment Trace

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: