## Size of Diesel GenSet

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

- System Voltage ( P-P ) in Volts
- System Voltage ( P-N ) in Volts
- Future Load Expansion in %
- 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:**

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

**Calculated results consist of:**

- Size of Diesel GenSet for linear, Non-linear Load
- Size of Diesel GenSet for motor load
- Diesel GenSet Efficiency
- UPL (unit per liter) of Diesel GenSet
- Unit power cost of Diesel GenSet
- 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 |

mina

hey guys

how can i calculate the Diversity Factor in a utility with 3 3ph motors that are working simultaneously?

vijay

Calculations shown for DG sizing is having minor errors, starting KVA is multiplied twice.

ahmed emara

Hey guys

now I have 1200 ekw generator with fuel consumption 333 l/hr and I need to calculate the efficiency of that generator set

is the efficiency subjected to the following equation ?:

Qin =Wout+Qrej

Then ᶮ ( efficiency ) = Wout/ Qin .. Wout = 1200 Kw

Where Qin = m°f *Cvf

Cvf ( for diesel) = 46000000 j/kg

ρ= 850 Kg/m³

But the result was not good

ᶮ = about 33.17 %

kindly advise me

Regards

John Alias

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

Thank you

SHANTANU DESHPANDE

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

Faihan

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.

abel

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?

NEIL MAJUMDER

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

sriram

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

devadath.g

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

Ahmed

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

eleng2007

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

Edvard

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

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

srikanth.shanky

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.

partoshal

I’m not able to download this item. Please guide me.

Thanks a lot

Edvard

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

Mahesh

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

Please suggest.

JaymzSchmerzen

Real useful.. Double checked my calcs =)

Thanks a lot

Jerome

Sir,

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

Thanks!