PA / Voice Alarm Speaker & Amplifier Design Calculator (100 V / 70 V, Excel)
Size a 100 V / 70 V public address or background music system in minutes. Enter each zone's room size, ceiling height and speaker data, and the workbook works out speaker spacing and count, checks the worst-case sound level against ambient noise, sizes the amplifier with headroom, and checks every speaker line for cable loss.
Features
- Coverage for up to 15 zones: radius, grid spacing, speaker count and SPL check against the ambient noise you enter.
- Amplifier sizing: connected load + adjustable headroom, next standard amplifier size and spare watts. Flags zones that need splitting.
- Cable loss for up to 15 lines: loop resistance, loss in dB and %, and the maximum run for your loss limit, with 0.75–6 mm² conductor choices.
- 100 V or 70 V line, editable copper resistivity, headroom, SPL margin and amplifier sizes.
- Summary of speakers, watts, amplifier power and rows needing attention.
- Every formula is visible. No macros, no add-ins. Works in Excel, LibreOffice and WPS.
- English + Chinese README.
Included: PA_Speaker_Amplifier_Design_Calculator.xlsx, PDF preview, README (EN/中文).
This is a planning and estimating aid, not certified life-safety software. Verify voice alarm designs against your local code and manufacturer data.