Antique Radio Forum for Collectors
HomeHome  RegisterRegister  FAQFAQ  SearchSearch  Log inLog in  
The Forum is Now Easier to Navigate. We now Have Catagories then the related Forums.

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   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

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
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: