## Electrical Programs( Excel Base)

Excel base Programs (Electrical Engineering):        Designed by: Jignesh.Parmar

### (1) Cable Designing Program

• Calculate Voltage drop of Cable.
• Calculate  Size of Cable.
• Calculate Current Capacity of Cable.

### (2) Conduit Size Selection Program

• Calculate Size of Conduit for LT Cable/CAT-5 Cable/Fiber Optical Cable.

### (3) Selection of  MCCB, ELCB  For Main /Branch Circuit.

• Calculate  Size and Type of Main MCCB/RCCB/ELCB for Continuous and Non Continuous Load
• Calculate  Sensitivity of MCCB/RCCB/ELCB.
• Calculate Size of  Cable.
• Calculate Size and Type of Sub Circuit MCCB/MCB for Continuous and Non Continuous Load
• Calculate Main and Branch Circuit Current.

### (4) Selection of Fuse

• Calculate Size of Fuse for Electrical Circuit.

### (5) Size of Capacitor  For Power Factor Improvements

• Calculate Size of Capacitor for Power Factor Improvements.
• Calculate Annual Saving by selection of  Capacitor.
• Calculate Active and Reactive Power.

### (6) Short Circuit Current Calculation at Various Point of Electrical Circuits(Isc).

• Calculate Short Circuit Current  at Substation.
• Calculate Short Circuit Current at Distribution point.
• Calculate Short Circuit Current at Transformer.
• Calculate Short Circuit Current at Main Panel.
• Calculate Short Circuit Current at Sub Distribution Board.

### (7) Circuit Breaker Tripping Settings.

• Calculate  Tripping Setting of Circuit Breaker.

### (8) Motor Specifications

• Calculate Various Specification of Motor.

### (9) Calculate  Home Electrical Load & Electrical Bill.

• Calculate Electrical Bill of Home
• Calculate Size of MCCB/MCB for Domestic Load
• Calculate Electrical Load of Home.

### (10) Calculate Insulation Resistance Value and PI value

• Calculate minimum Insulation Resistance Value for Various Electrical Equipments.
• Calculate IR Value of Electrical Equipments.
• Graph of  IR Value
• Calculate Polarization Index Value with Graph
• Calculate Earth Resistivity.

### (11) Calculate Electrical Load and Energy Consumption of Panel.

• Calculate Continuous and non Continuous Electrical Load of Panel.
• Calculate total Energy Consumption(KWH) in Daily/Monthly of Panel.
• Calculate Size of MCB of each branch circuit of Panel.
• Calculate Voltage / Voltage Difference of Each Phase
• Calculate Unbalanced Load in Neutral Wire.
• Calculate Expected Temperature rise in Each Phase.
• Calculate Load in Each Phase.
• Calculate Size/Type/Tripping setting of Main MCCB.

### (12) Calculate Electrical Load of Panel.

• Calculate Voltage / Voltage Difference of Each Phase
• Calculate Unbalanced Load in Neutral Wire.
• Calculate Expected Temperature rise in Each Phase.
• Calculate Load in Each Phase and Outgoing Feeders.
• Calculate Size of Cables for Each Outgoing Feeder.

### (13) Calculate Size of Battery Bank and Inverter.

• Calculate Size of Battery Bank in Amp.Hr.
• Select Type of Connection of Batteries in Battery Bank
• Select Rating of Each Battery in Battery Bank
• Calculate Size of Inverter.
• Calculate Size/Type/Tripping setting of Main MCCB.

### (14) Calculate Size of Solar Panel / Battery Bank / Inverter.

• Calculate Size of Solar Panel.
• Select Type of Connection of Solar Panel.
• Select Rating of Each Solar Panel.
• Calculate Energy from Solar Panel as per Daily Sun lights.
• Calculate Size Battery Bank.
• Select Type of connection of Batteries in Battery Bank
• Calculate size of Inverter

### (15) Calculate No of Lighting Fittings and Lumen Output.

• Calculate Total Lumen Output for particular Area.
• Calculate Total No of Lighting Lamps.
• Calculate Total No of Lighting Fixtures.
• Calculate No of Fittings along with the Length and Width of Room.

### (16) Calculate Bus Bar Size and Voltage Drop.

• Calculate Voltage Drop for  Bus Bar.
• Select Size of Bus Bar for particular Load.

### (17) Design of Earthing Mat for Sub-Station:

• Program is design as per ANSI/IEEE 80-1986 Code.
• Calculate Step Potential of Switch yard.
• Calculate Touch Potential of Switch yard.
• Calculate Total Length of Earthing Mat Conductor.
• Calculate Size of Earthing Mat Conductor.
• Calculate Total No of Earthing Rods.

### (18) Calculate Touch Voltage and Ground Current.

• Calculate Resistance of Each Phase.
• Calculate  Resistance of neutral/Ground.
• Calculate Neutral Current and Load.
• Calculate Touch Voltage for Metal part to Earth.
• Calculate Body Resistance and Body Current.

### (19) Calculate Size of Diesel Generator.

• Calculate Size of D.G Set for Linear,Non-Linear Load
• Calculate Size of D.G Set for Motor Load
• Calculate D.G Set Efficiency.
• Calculate UPL (Unit per Liter) of D.G Set
• Calculate Unit Power Cost of D.G Set
• Calculate Approximate Fuel Consumption.

### (20) Calculate Size of air conditioning for room.

• Calculate Size of Air Conditioning for Your Room.
• Calculate AC Size in BTU/Hr.
• Calculate AC size in Tone.
• Calculate Heating and Cooling BTU.

### (21) Calculate Transverse Load on PCC/RCC/RSJ/Tublar/RSJ Pole..

• Calculate Crippling load on Pole
• Calculate Wind Load on Pole.
• Calculate wind Load on all Conductors.
• Calculate Transverse Load on Pole
• Decide spacing between Two Conductor as per IS:5613.
• Calculate required Voltage level of Overhead Line according to Distance.

### (22) Calculate % Voltage Regulation of Small Distribution Line.

• Calculate % Voltage Regulation of Small Distribution Line
• Calculate % Voltage drop of Individual Load.
• Calculate % Voltage drop of Various ACSR, AAAC, AAC conductor overhead Line.
• Calculate Receiving end Voltage of Distribution Line.
• Calculate Total % Voltage Regulation of Distribution Line.

## 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

• 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.
• Find out Total investment by individual person.
• Bank Account Details, Cheques Details, Salary Account Details.
• 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)

Daily Planner/Work Organizer/Performance analyzer

System Requirement: MS Office 2007

• Plan your Daily work schedule with the priority index.

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

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

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

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

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

NSC Interest Calculator

• 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
• Convert cheque Amount in to word format.

Baby Gender Prediction 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)

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

## Types of Over Load Relay:

1. Class 10: Would Trip after 10 seconds.
2. Class 20: Would Trip after 20 seconds.
3. Class 30: Would Trip after 30 seconds.
• Over Load Relay should be set 115% to 130% of Motor Full Load Current.
• Class 10 is faster than Class 20 and Class 30 over Load Relay.

## Size of over Load Relay:

 Size Amp Capacity S00 0.1 To 0.4 0.4 To 0.6 1.6 To 6 3 To 12 S0 3 To 12 6 To 25 S2 6 To 25 13 To 50 S3 13 To 50 25 To 100 S6 50 To 200 S10 & S12 55 To 250 200 To 540 300 To 63

## Contactor Coil:

 Coil Voltage (40 To 50 Hz) Suffix 24V T 48V W 110V To 127V A 220V To 240V B 277V H 380V To 415V L

## Type of Contactor for Starter:

 Contactor Application AC1 Non-Inductive or Slightly Inductive ,Resistive Load AC2 Slip Ring Motor AC3 Squirrel Cage Motor AC4 Rapid Start / Stop AC5a Switching of Electrical Discharge Lamp AC5b Switching of Electrical Incandescent Lamp AC6a Switching of Transformer AC6b Switching of Capacitor Bank AC7a Slightly Inductive Load in Household or same type load AC7b Motor Load in Household Application AC8a Hermetic refrigerant Compressor Motor with Manual O/L Reset AC8b Hermetic refrigerant Compressor Motor with Auto O/L Reset AC12 Control of Restive Load and Solid State Load with optocoupler Isolation AC13 Control of Restive Load and Solid State with T/C Isolation AC14 Control of Small Electro Magnetic Load ( <72VA) AC15 Control of Small Electro Magnetic Load ( >72VA)

## Making and Breaking Capacity of Contactor:

 Contactor Making Capacity(Amp) Breaking Capacity (Amp) AC1 1.5 X motor rated current 1.5 X motor rated current AC2 4 X motor rated current 4 X motor rated current AC3 10 X motor rated current 8 X motor rated current AC4 12 X motor rated current 10 X motor rated current AC5a 3 X motor rated current 3 X motor rated current AC5b 1.5 X motor rated current 1.5 X motor rated current AC6a 12 X motor rated current 10 X motor rated current AC6b 12 X motor rated current 10 X motor rated current AC7a 1.5 X motor rated current 1.5 X motor rated current AC7b 8 X motor rated current 8 X motor rated current AC8a 6 X motor rated current 6 X motor rated current AC8b 6 X motor rated current 6 X motor rated current AC12 AC13 10 X motor rated current 1.1 X motor rated current AC14 6 X motor rated current 6 X motor rated current AC15 10 X motor rated current 10 X motor rated current

## Contactor Status:

 Contactor Status Continuity Between  Pins (N/C) Non Continuity Between Pins (N/O) Power Not Applied 32 and 33 21 and 22 11 and 12 A1 and A2 B1 and B2 Power Applied 21 and 22 32 and 33 11 and 12 A1 and A2 B1 and B2

## Main Circuit Voltage of O/L Relay & Contactor:

1. A.C= 240V,415V
2. D.C=230V,460V,600V

## Contactor’s Coil Voltage:

1. A.C= 40V,220V,240V,415V
2. D.C=24V(For PLC),110V,230V,460V

## Rated Current of Contactor: (Thermal and Intermediate Duty):

1. A.C= 6,10,16,25,63,100,160,200,315,400,630,800 Amp
2. D.C= 16,20,80,160,315,1250,8000 Amp.

 Contactor / Relay Setting / Fuse / Cable for DOL STARTER H.P KW FLC Contactor Size (Amp) Relay setting Fuse Cable (mm2) Min Max Cu Allu 0.5 0.37 1 – 0.8 1.17 4 1 1.5 0.75 0.55 1.3 9 1 1.5 4 1 1.5 1 0.74 1.9 9 1.6 2.3 6 1.5 2.5 1.5 1.11 2.6 9 2 3 6 1.5 2.5 2 1.49 3.7 9 2.5 3.7 10 1.5 2.5 3 2.2 4.8 9 4 5.9 16 1.5 2.5 5 3.73 7.8 9 6.3 9.4 20 1.5 2.5 7 5.22 11.2 12 8 11.7 25 2.5 4 10 7.46 16 16 12.5 18.7 25 4 6 12.5 9.32 19 32 16 23.4 32 4 6 15 11.19 20.8 32 16 23.4 50 6 10 20 14.92 28 32 20 30 50 6 10 25 18.65 34 38 32 37.4 63 10 16 30 22.38 40 45 32 47 80 16 25 40 29.84 53 63 50 59 100 25 35 50 37.3 65 70 57 65.5 125 25 50 60 44.76 78 85 70 88.9 125 25 50 75 55.95 96 110 85 98.2 160 50 70 100 74.6 131 140 115 168 200 70 95 125 93.25 156 170 115 168 250 120 150 150 111.9 189 205 160 234 315 150 240 180 134.28 227 250 160 234 355 185 300 215 160.39 271 300 200 299 400 – – 270 201.42 339 400 250 374 500 – – 335 249.91 338 475 320 468 500 – –
 Relay Range & Back up Fuse for DOL Starter H.P KW Full Load Current (amp) Relay Rang(Amp) Back Up Fuse Min Max 10 7.5 13.6 13 To 20 25 50 12.5 9.3 17 13 To 20 25 50 15 11.2 20 20 To 30 35 80 20 14.9 28 20 To 30 60 80 25 18.7 35 30 To 45 60 100 30 22.4 40 30 To 45 80 100 35 26.1 47 45 To 63 80 125
 Relay Range & Back up Fuse for Star / Delta Starter H.P KW Full Load Current (amp) Relay Rang(Amp) Back Up Fuse Min Max 20 14.9 28 13 To 20 60 60 25 18.7 35 20 To 30 60 100 30 22.4 40 20 To 30 60 100 35 26.1 47 20 To 30 80 100 40 29.8 55 30 To 35 80 125 50 37.3 66 30 To 35 100 125 60 44.8 80 45 To 63 100 160 75 55.95 95 45 To 63 125 160