E N D
Resistor Color Codes Abby Weddington
Step 1 Look at your resistor
Step 2 Input the color of your first band. The number of it will show up in the N/A box. Gold, Black, and Silver can not be your 1st band colors
Step 3 Input the color of your second band Gold and Silver can not be your 2nd band color
Step 4 Input the color of your multiplier (3rd band) Gold and Silver can not be your multiplier
Step 5 Input the color of your tolerance (4th band)Last color can only be silver or gold
Step 5 You will get your range and the min-max (minimum and maximum) of your resistor.
you know how to use a resistor calculator your parents must be proud you’re done wow congrats
Making the Calculator By Abby Weddington again
Make the Table First It must be in ascending order, as shown above(clicking Table under Insert and highlighting the data will create it)
Make the Input/Output My Formulas:1st Band: =VLOOKUP(I7,Table2,2)2nd Band: =VLOOKUP(I8,Table2,3)Multiplier: =VLOOKUP(I9,Table2,4) Tolerance: =VLOOKUP(I10,Table2,5) (Low) Range: =(K7+K8)*K9-((K7+K8)*K9)*K10Range: =(K7+K8)*K9 (High) Range: =(K7+K8)*K9+((K7+K8)*K9)*K10
Your formulas Your formulas will be a little different but they will follow the same concept • Formulas for the bands are made with this sort of pattern: =VLOOKUP(cell of input,yourtable,the column number the input is in) • Formulas for the range are complicated..Low Range: =(1st band+2nd band)*Multiplier-((1st band+2nd band)*Multipler)*ToleranceRange: =(1st band+2nd band)*MultiplierHigh Range: =(1st band+2nd band)*Multiplier+((1st band+2nd band)*Multiplier)*Tolerance
What’s VLOOKUP? • It’s a function in Excel (go to the Formulas tab, then Lookup)- The 1st value is where you input the data.- The 2nd value is the table you made.- The 3rd value is the column in the table that you want to correspond with the data you input (the colors column counts as 1, so you would put in 2, 3, 4 etc. for this value)
How to Manually Calculate the Range • The 1st band uses the tenth place (10, 20, 30, 40, etc.) • The 2nd band uses the ones place (1, 2, 3, 4, etc.) • The 3rd band is the multiplier (101, 102, 103, 104, etc.) • The 4th band calculates the range (Gold adds and subtracts 5% and Silver adds and subtracts 10%)(Ex. 100 with Gold would be 95 and 105, while 100 with Silver would be 90 and 110)
Now you’re done! Have fun with your new calculator!