ANTIQUE-RADIO-LAB

Antique Radio Forum for Collectors antique-radio-lab.forumotion.com
 
HomeHome  RegisterRegister  FAQFAQ  SearchSearch  Log inLog in  

Share | 
 

 Resistor measurement to compare by Spreadsheet

View previous topic View next topic Go down 
AuthorMessage
Cliff Jones
Site Administrator
Site Administrator
avatar

Join date : 2010-11-22

PostSubject: Resistor measurement to compare by Spreadsheet   2017-02-16, 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
ve1arn
Moderator
Moderator
avatar

Join date : 2010-11-23

PostSubject: Re: Resistor measurement to compare by Spreadsheet   2017-02-19, 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
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» Measurement of WASP-3 b's Rossiter-McLaughlin effect
» 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?

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: