throbscottle
Well-Known Member
I needed to find resistors in a specific ratio a while back, so I made this spreadsheet. I've glammed it up a bit for ETO. Hope it's useful to someone.
Some info about it:
It gives base values only, you have to supply the correct multiplier.
It only gives exact values - by design there is no fudge factor
It will only divide the column1 value by the column2 value, so if the columns are in different series it pays to try them both ways round.
If you want to get at the full formulae, there are 3 hidden columns, G, H and I.
Sheet is protected (no password) for the drop down list items.
I used R1C1 notation for the formulae that use the drop down lists - if you modify it bear this in mind (really I should have used ADDRESS() but wanted to avoid including yet another expression. Wish I had done now. Ho hum.)
I created it in Libre Office - the export to Excel isn't quite perfect - the drop down lists should be the same colour as the cells they cover, and the list below them should be hidden.
Not 100% sure it's working perfectly, would be glad of some peer review!
Think that's all anyone should need to know!
Have fun!
Some info about it:
It gives base values only, you have to supply the correct multiplier.
It only gives exact values - by design there is no fudge factor
It will only divide the column1 value by the column2 value, so if the columns are in different series it pays to try them both ways round.
If you want to get at the full formulae, there are 3 hidden columns, G, H and I.
Sheet is protected (no password) for the drop down list items.
I used R1C1 notation for the formulae that use the drop down lists - if you modify it bear this in mind (really I should have used ADDRESS() but wanted to avoid including yet another expression. Wish I had done now. Ho hum.)
I created it in Libre Office - the export to Excel isn't quite perfect - the drop down lists should be the same colour as the cells they cover, and the list below them should be hidden.
Not 100% sure it's working perfectly, would be glad of some peer review!
Think that's all anyone should need to know!
Have fun!