ºÝºÝߣ

ºÝºÝߣShare a Scribd company logo

Voltage Drop Calculator for Street Lighting

•Download as PPT, PDF•
•
TAMUK
TAMUK

Voltage drop calculator for street lights. Works with Excel 365. Get file by downloading presentation. Open object presentation. Click 'Enable Content'. Right click over object for "Package Shell Object"->"Activate Content"->Press "OPEN" button to see VDROP folder. Open folder for the files. This is provided "AS IS" with no warranty or guarantees or liability.It is accurate, but make sure to check with your standards to be sure.

1 of 5
Download to read offline
Voltage Drop Calculator for Street Lights. Press a button to select a sheet. If opening for the first time, disable the read only with the Options button to use. Though in Excel 97, this sheet did work with Excel 2007 without any changes. There is Excel VB code used to activate the buttons and other functions.
Enter the cable lengths to find voltage drop. Used drop down menu to select a different wire size. ‘Length to Zero’ resets the cable lengths to zero. ‘Compare to copper’ copies the information to another sheet for comparison.
The lengths are copied and a comparison is show. The copper has a lower voltage drop. Press ‘Return’ to go back to the original sheet.
A sheet for copper wire works the same way.
Multi-conductor sheet. Select the watts in the string. Use the ‘Default To’ to select a single value. Pressing ‘Default To’ will set the sting to 100W for example. The wire size from the transformer to the 1st light can be selected followed by the wire size to rest of the string.

More Related Content

Voltage Drop Calculator for Street Lighting

  • 1. Voltage Drop Calculator for Street Lights. Press a button to select a sheet. If opening for the first time, disable the read only with the Options button to use. Though in Excel 97, this sheet did work with Excel 2007 without any changes. There is Excel VB code used to activate the buttons and other functions.
  • 2. Enter the cable lengths to find voltage drop. Used drop down menu to select a different wire size. ‘Length to Zero’ resets the cable lengths to zero. ‘Compare to copper’ copies the information to another sheet for comparison.
  • 3. The lengths are copied and a comparison is show. The copper has a lower voltage drop. Press ‘Return’ to go back to the original sheet.
  • 4. A sheet for copper wire works the same way.
  • 5. Multi-conductor sheet. Select the watts in the string. Use the ‘Default To’ to select a single value. Pressing ‘Default To’ will set the sting to 100W for example. The wire size from the transformer to the 1st light can be selected followed by the wire size to rest of the string.