Welcome, please log-in to participate in this (your) forum, by logging in you agree to abide by the rules of this forum. Until you make your FIRST Login and post, you cannot PM a Member.

Antique Radio Forum for Collectors
HomeHome  RegisterRegister  Log inLog in  FAQFAQ  PublicationsPublications  SearchSearch  
Can't Log In?: 1st. thing is to clean out your cookies. if that doesn't work , click on Contact field.
(registration and/or Login Help ONLY) For other questions go to our FAQs link above.

Share | 

 Resistor measurement to compare by Spreadsheet

Go down 
Cliff Jones
Site Administrator
Site Administrator

Join date : 2010-11-22

PostSubject: Resistor measurement to compare by Spreadsheet   February 16th 2017, 2:13 pm

I worked out a formula to use in a spreadsheet to compare actual printed value on subject resistor and actual measured value.

Resistor needed in OHMs             measured value in OHMs
 1.00                               0.89 
 Resistance Percentage Change -11%


Cell # A1--> "resistor needed in OHMs "  Cell # B2--> "measured value in OHMs "
Cell # A2--> 1.00 Cell # A1--> 0.89 

Cell # A4 --> Resistance Percent Change               Cell # A4 --> -11% 

Formula for cell #A4      =(B2-A2)/ABS(A2)

I'm a Science Thinker, Radio Tinkerer, and all around good guy. Just ask Me!
Back to top Go down

Join date : 2010-11-23

PostSubject: Re: Resistor measurement to compare by Spreadsheet   February 19th 2017, 11:35 am

Nice one Cliff. I have a similar one that I use, but yours looks a bit neater than mine. Think I'll make the switch. Smile
Back to top Go down
Resistor measurement to compare by Spreadsheet
Back to top 
Page 1 of 1
 Similar topics
» Eris vs Pluto
» Current Workload Relative to Capacity
» The atmosphere of GJ 1214 b
» Six High-Precision Transits of OGLE-TR-113b - Orbital period change?
» Lundi 18 avril 2011: vivre en ville ou à la campagne

Permissions in this forum:You cannot reply to topics in this forum
ANTIQUE-RADIO-LAB :: Radio Repair Bench :: Electronic Formulas, Theory, and applications-
Jump to: