Spreadsheet simulation was used to estimate peak current demands of a hypothetical welding line for LRT car bodies for energy management. Power companies factor peak power draw into their rates; high momentary power demands can result in surges and brown-outs. Rates are often based on the power used in KVA, and also on the peak current. Exceeding that peak could result in an extreme penalty. The spreadsheet simulation which developed the peak power demands generated random numbers and maped them onto resistance welder data using Monte Carlo sampling. Peak power usages were developed for the welding line during 10,000 momentary “snapshot” simulations, contracting for a 400 KVA peak, and installing a 400 KVA circuit breaker rather than pay a rate penalty. Results were developed in a few hours using a microcomputer spreadsheet program. Other potential uses of spreadsheet simulation are listed.

This content is only available via PDF.
You do not currently have access to this content.