# Calculate Size of Diesel Generator

Home / Download Center / Electrical Software / Calculate Size of Diesel Generator

## Size of Diesel GenSet

This spreadsheet intend to calculate size of needed diesel generator according to the following input parameters:

1. System Voltage ( P-P ) in Volts
2. System Voltage ( P-N ) in Volts
3. Future Load Expansion in %
4. Average Intermittent Use of Equipment (0.7 To 1.0)

You are about to enter following information for each consumer you have in your consumption calculation:

1. Equipment (name)
2. Load Type (linear, non-linear or motor)
3. Supply (1ph or 3ph)
4. Qty (num.)
5. Load (in kW)
6. Starting P.F
7. Running P.F
8. Diversity Factor
9. Motor Starter (Dol, Y-D, auto-transformer, soft starter or frequency converter)

Calculated results consist of:

1. Size of DieselÂ GenSet for linear, Non-linear Load
2. Size of DieselÂ GenSet for motor load
3. Diesel GenSet Efficiency
4. UPL (unit per liter) ofÂ Diesel GenSet
5. Unit power cost ofÂ Diesel GenSet
6. Approximate fuel consumption
 Software: Calculate Size of Diesel Generator (MS Excel Spreadsheet) Version: 22.08.2012 Developer: Jignesh Parmar Size: 138 Kb Price: Free Download: Right here | Get Download Updates | Get Technical articles

### Premium Membership

Premium membership gives you an access to specialized technical articles and extra premium content (electrical guides and software).

Page edited by E.C. (Google).

### 18 Comments

1. John Alias
Mar 10, 2016

can anyone please send the detailed calculations and formulas used in this spreadsheet?…it would be really helpful
Thank you

2. SHANTANU DESHPANDE
Oct 19, 2015

What is the difference between Average Intermittent Use and Diversity Factor ??

3. Faihan
Aug 24, 2015

Good Job
How do I add the Air Conditioning units? Are they linear or non? I only know the ton value of each.
And, What is the correct connection for single phase ACs and lights? Is it Y-D?
I also have a three phase 60 HP submersible pump that sucks 150 Amps on each phase to start and then goes to 90 Amps to run. Your sheet says that the full load Amps is 38 while I see on the DG display 90 Amps on each of the three phases.

4. abel
Jul 29, 2015

What about considering non linear loads in %age of total load in sizing? The limits of such loads govern sizing if exceeded. Any international standards talks about this in sizing the Genset? How it will be applied in the calculation?

5. NEIL MAJUMDER
Apr 27, 2015

Consider a case where EDG is to be started on to a distribution transformer.How to size the DG set then?

6. sriram
Apr 12, 2015

we have total load in kw .how do we arrive at genset capacity??/

7. devadath.g
Jul 21, 2014

How can we conduct the load test of DG set at site?

8. Ahmed
Dec 18, 2013

Engine overload is 10% only not 130 to 150%.

It is depend for Standby application or Prime or base load .
It is better to check and alternator efficiency is about 93 to 96

9. eleng2007
Oct 09, 2013

how to calculate the required daily / monthly fuel tank of generator?

• Edvard
Oct 09, 2013

Hooh, sounds very interesting, but I wouldn’t know really. I guess that eash manufacturer has its own manual or guide you should follow.

Anyway, your question’s answer depends on how many hours generator will work.

• Adrian
Nov 23, 2014

Edvard, Can I get a password to unprotect the spreadsheet?

10. srikanth.shanky
Aug 13, 2013

Wonder that the starting power factor of the motor assumed to be as 0.8 is correct.Normally the value may be 0.2-0.3.The pf at 80% of speed during starting may be 0.6.Moreover the highest rated motor starting with base load and as well as voltage drop need to be considered for DG sizing.
Your feedback please.

11. partoshal
Mar 25, 2013

Iâ€™m not able to download this item. Please guide me.
Thanks a lot

• Edvard
Mar 25, 2013

Link works quite well, I double checked. Maybe you’re having problems with Box.com on your side?

12. Mahesh
Feb 26, 2013

I’m not able to download this. I also tried to download other sheets some time back but faced the same problem.
Please suggest.

13. JaymzSchmerzen
Jan 23, 2013

Real useful.. Double checked my calcs =)

Thanks a lot

14. Jerome
Jan 14, 2013

Sir,

How accurate the spreed sheet is? this have been tested on site?

Thanks!

#### Premium Membership

🔌 Get access to premium electrical guides, technical articles and much more!