Electrical Programs( Excel Base)


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

(1) Cable Designing Program

FREE DOWNLOAD            BUY UNLOCK VERSION

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

(2) Conduit Size Selection Program

FREE DOWNLOAD               BUY UNLOCK VERSION

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

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

FREE DOWNLOAD.            BUY UNLOCK VERSION

  • 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 Total Load .
  • Calculate Main and Branch Circuit Current.

(4) Selection of Fuse

FREE DOWNLOAD         

  • Calculate Size of Fuse for Electrical Circuit.

(5) Size of Capacitor  For Power Factor Improvements

FREE DOWNLOAD                  BUY UNLOCK VERSION

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

FREE DOWNLOAD                BUY UNLOCK VERSION

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

FREE DOWNLOAD

  • Calculate  Tripping Setting of Circuit Breaker.

(8) Motor Specifications

FREE DOWNLOAD

  • Calculate Various Specification of Motor.

(9) Calculate  Home Electrical Load & Electrical Bill.

FREE DOWNLOAD.               BUY UNLOCK VERSION

  • 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

FREE DOWNLOAD.          BUY UNLOCK VERSION

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

FREE DOWNLOAD.         BUY UNLOCK VERSION

  • 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 Starting/Full Load/Continuous/Non Continuous Load
  • Calculate Size/Type/Tripping setting of Main MCCB.

(12) Calculate Electrical Load of Panel.

FREE DOWNLOAD.           BUY UNLOCK VERSION

  • 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 Starting/Full Load/Continuous/Non Continuous Load
  • Calculate Size of Cables for Each Outgoing Feeder.

(13) Calculate Size of Battery Bank and Inverter.

FREE DOWNLOAD         BUY UNLOCK VERSION

  • Calculate Total Demand Load
  • 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.

FREE DOWNLOAD            BUY UNLOCK VERSION

  • Calculate Total Demand Load
  • 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.

FREE DOWNLOAD         BUY UNLOCK VERSION

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

FREE DOWNLOAD     BUY UNLOCK VERSION

  • Calculate Voltage Drop for  Bus Bar.
  • Select Size of Bus Bar for particular Load.
  • Enter Your Sub Panel Details like Load,Line Length.

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

FREE DOWNLOAD               BUY UNLOCK VERSION

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

FREE DOWNLOAD              BUY UNLOCK VERSION

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

FREE DOWNLOAD                 BUY UNLOCK VERSION

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

 FREE DOWNLOAD.                BUY UNLOCK VERSION

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

  FREE DOWNLOAD.      

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

  FREE DOWNLOAD 

  • 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

 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

Over Load Relay & Contactor for Starter


Over Load Relay & Contactor for Motor Starter:

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

%d bloggers like this: