
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 | Video Courses | Membership | Download Updates |

It is helpful to me as an electrical engineer
Cannot be downloaded.
I’m happy to have professional discussion related to Power
Want to know the standard / reference used for DG sizing calculation and criteria to be followed.
Hi guys.
I am thinking to star a 3 phase motor 75 kw, 460 VAC with a Diesel generator (144 HP rated ), 460 VAC using a soft starter.
Sombody can help me if this is posible?
hey guys
how can i calculate the Diversity Factor in a utility with 3 3ph motors that are working simultaneously?
Better late than never.
The 3 mortors are working simultaneously, so the diversity factor Kd = 1 (*)
If ypu want to estimate the energy consumption per day, you have to use loading factor or utilization factor generaly = 0.80. But if you know the power absorbed by the machine driven by the electric motor, then, the utilization factor Ku = Machine power/Nominal motor power.
The global factor Kg = KdxKu.
If Ku = 0.8, then Kg = 1×0.8 = 0.8.
If the unit nominal power of your motors is Pn = 22 kW, the total power absorbed is : 3×0.8x 22 = 52.8 kW.
If your 3 motors work 8 hours per day, then the energy consumed per day is : E = NxKgxPnxt = 3×0.80x22x8 = 422.4 kWh.
Calculations shown for DG sizing is having minor errors, starting KVA is multiplied twice.