Related Resources: Electrical Electronics Excel Calculators

Voltage Divider for 5% Resistors Calculator Excel Spreadsheet

NOTE:

  • Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
  • This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
  • Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Electrical and Electronics Design, Engineering Resources
Engineering Excel Spreadsheet Downloads

Voltage Divider for 5% Resistors Calculator Excel Spreadsheet

Note: Accessing this resource requires an active Premium Membership with Engineers Edge

Download:

Description: Divider for 5% Resistors Calculator Excel Spreadsheet

This sheet shows the outputs of a voltage divider for standard 5% valued resistors. Vin (currently set at 10V) can be changed to any desired input voltage and the sheet recalculated. Read the values of R1 down the left hand column, and the values of R2 across the top row.

Voltage Divider for 5% Resistors Calculator Excel Spreadsheet