EXCEL TOOL

(1) Personal Investment -Budget Planner.

  FREE DOWNLOAD        BUY UNLOCK VERSION($)       BUY UNLOCK VERSION(Rs)

  • Plan Your Home Budget-Monitor Your Daily Expenses.
  • Monitor and track your Investments in Fixed Deposit,Bonds,Insurance, Postal, LIC, KVP,NSC,MIS,Shares, Mutual Funds, Gold, Gems, and Property.
  • Analysis your investment:
  • 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.
  • Monthly Reminder:
  • 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.

(2) Salary Master:(Payroll/P.F/Overtime/Salary slip)

FREE DOWNLOAD.      BUY UNLOCK VERSION(RS)       

  • 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.
  • ESI ,P.F,TDS Calculation(Set Your Requirements)
  • Pension Scheme (not more than 541 rs submission)
  • Employer Monthly Salary statement
  • Generation of Form No-6 (For ESIC),Form no-3A (PF)-6A(PF),Form no 12A-No 3A-No 3- No6
  • Calculate half Day attendance.
  • Calculate overtime automatically (Enter only your Daily working Hours)
  • Calculate Employees belongs in to PF at Every month
  • Calculate Total Employee at every month.

(3) Stock Register:

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

(4) National Saving Certificate Interest Calculator

  FREE DOWNLOAD         BUY UNLOCK VERSION

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

(5) Car Loan EMI Calculator.

  FREE DOWNLOAD   BUY UNLOCK VERSION

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

(6) Simple and Compound Interest Calculator.

    FREE DOWNLOAD     BUY UNLOCK VERSION

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

(7) Saving Calculator

  FREE DOWNLOAD          BUY UNLOCK VERSION

  • Calculate Saving Amount with interest.

(8) Loan and EMI Calculator

  FREE DOWNLOAD     BUY UNLOCK VERSION

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

(9) Baby Gender Prediction Program

  FREE DOWNLOAD      BUY UNLOCK VERSION

  • Predict gender of Baby as per Chinese Lunar Calendar

(10) Address Diary and Reminder

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

(11) Calender for 100 Years.

  FREE DOWNLOAD           BUY UNLOCK VERSION

  • Calender for 100 Years

(12) Restaurant(Table Reservation)Program:

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

35 Responses to EXCEL TOOL

  1. Vilas says:

    Dear Sir can u pl throw some light on DGA interpretations in condition monitoring of transformers

  2. Sachin Antapurkar says:

    Dear Sir,
    iam regular follower of your blog , Now I wants purchase some your Excel tools . Which ask to pay in USD is there any provision to in Rs?. Pls Inform.

  3. AJay says:

    sir
    how can we purchase few excel programs on line? thanks
    we want to purchase in INR.

  4. Ashok Bhat says:

    Can u pl send any excel tool for Maximum demand estimate for contract demand KVA decision criteria. It will be useful for new projects implementation

  5. Bob Dale says:

    Jignesh.Parmar — Your blog is very informative. Thank you for taking the time to assemble it. I am looking for information about power transformer nameplate polarity designations. Specifically, I want to understand the meaning of the polarity reference indication which in the case of a delta wye transformer seems to be a dashed line connecting one of the high voltage connections to the center of the HV delta. I have several transformers with this dashed line connected to the H1 corner of the delta, and have a replacement transformer coming that has the reference line connected to the H2 corner. Will I have trouble paralleling these two transformers? (The other polarity markings seem to be the same — Dyn1)

  6. RB Lakhnotra, Deputy Engr - GETCO says:

    Knowledge sharing is best gift to world, you do it. i am really impress from you.

  7. pradeep says:

    Dear Admins,

    I’m designing a Solar Roof-Top Project, in that I need to Give a Back-up supply for 10 hrs during non-Generation hours.

    Peak Load of Home : 1000W

    1. My doubt is can I choose a batter-less ups of 1000 VA with a back-up of 6 Batteries (12V, 150Ah) can It satisfy my needs.
    2. Another doubt is will the batteries get charged if my Solar inverter produces 1.6 KVA for 8 hrs (600 to 800VA excess than the load used).

  8. deepakkumaria says:

    Hi,
    DO you have any excel tool of vectorial loading of a transformer (HV_regulation,LV+regulation,TV)

  9. ATIS says:

    Dear Sir,

    Please let me know are this Excel tools according to IEC standards?

    Dest Regard,

  10. tajinder kumar says:

    Dear sir,
    You have put all the technical notes/articles at single click.its easy to us.i request you to put some electrical drawings also like switch yard drawing etc.it may helpful for everyone.

  11. Hi! Sir, This is Praveen From Varnasco
    we Had recently purchased a payroll master service from u, now we are in the need of “time task manager” Can u pls notify us if u have any service like this or in similar to this pls reply us
    Thank U ……..

  12. sundararaju says:

    sir i want copper bus calculation or selection chart.

  13. Sidhaarth says:

    Hi Sir,

    I have downloaded Address Diary and Reminder, but while opening it is telling ” this excel is in different format” after accepting it in yes some blank sheet open.
    Please help how to access it in original format ?
    Waiting for your reply.
    Thanks in advance.

    Sidhaarth

  14. Sidhaarth says:

    Hi Jignesh Sir,
    How to buy your excels. Urgent requirement for few of your full version excels.
    Kindly let me know how to go through the payment ?

    Thanx and Regards
    Sidhaarth

  15. Sidhaarth says:

    Hi Jignesh Sir,
    I have purchase your personal investment budget planner. How can i change the current dollar currency to INR ? Not convenient to track in dollars until i get in dollars…haha

    Thanx
    Sidhaarth
    sid.vfx8@gmail.com

    • You do not need to get dollars for it HaHa….HaHa..HaHa..
      follow following Path to change currency..
      Just click cell in which You want to change Currency> Right click>Format Cell>Change currency>Set Indian Rupees>Click O.K

  16. J.E. says:

    PL SUGGEST ME HOW TO CALCULATE THE OVER HEAD & UNDER GROUND COMBINED NETWORK THEORETICAL LOSS CALCULATION.

  17. Ashish Shah says:

    How to change US$ currency to INR

  18. bhavnesh says:

    Dear Sir
    new version of Home budget planning available

  19. ashish says:

    HOW TO SELECT EARTHING WIRE FOR PERTICULAR LOAD. SPECIALLY FOR SMALL & LARGE KW MOTOR.

  20. Abdulmanan says:

    sir i am working on the electrical grounding system for my master project and i am using Comsol Muliphyscis can you help me how i model it and also help me to apply input at lightning current sir i am strucked please help me

  21. Mahadeva says:

    Sir,
    could you please help me out to generate electricity consumption database in excel and generate a bill by end of the month.

    we had around 1600 Energy meter and few tenant had more than one energy meter.

    Thank in advance

  22. Monir says:

    Sir i am bangladashi i want to know many think of electronic but i have no ability

  23. Ang ZY says:

    Dear Mr Jignesh
    Do u have email that I can write to you???
    Kindly advise me
    ThankYou
    Ang Zhi Yoong

  24. vinod bhosale says:

    I have a query about distribution system. pl give your email address so that i can able to share it with you.

  25. Y.CHINNA RAO says:

    Very very very use full data to Electrical Engineers.

  26. Sanilal says:

    I need updates

  27. abdul razak says:

    sir i am a ece back ground and i want to learn electrical design course how it will help for my carrier

  28. Rakesh Parmar says:

    Dear Sir,

    I am Rakesh Parmar from Pune, Maharashtra. I want to know that is there any indian standard available for the HT cable route marking on ground for the identification. We are having requirement to provide identification system for the HT cable-22kV route on ground.

  29. Tashi Bhutan says:

    Sir,

    Very impressive work ……..keep it up

  30. Sanjeev Kumar says:

    Dear Jignesh Sir,

    Thanks a lot to make this web site and updating very informative data for electrical engineers.

    Thanks & Regards,
    Sanjeev Kumar

  31. BHATT Ritesh lalitkumar says:

    Respected Sir, i am working in J.M. baxi & CO. I would like to Say for earth of both DG set capacity of 380 KVA.There are Sea area at our site . So kindly guide to us what type of the earthling application for our DG sets.

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: