1 / 15

Download Presentation
## Resistor Powerpoint

**An Image/Link below is provided (as is) to download presentation**
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.
Content is provided to you AS IS for your information and personal use only.
Download presentation by click this link.
While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
During download, if you can't get a presentation, the file might be deleted by the publisher.

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!

More Related