<html><head><title>Re: Resistance transfer standard (bolo Re: Drziak na testovanie pruzinovymi pinmi)</title>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
</head>
<body>
<span style=" font-family:'Courier New'; font-size: 9pt;">Kdysi jsem v literatuře narazil na stejný problém, ale už to nedohledám.<br>
Pamatuju si:<br>
- U konců mít přesnější hodnoty<br>
- směrem do prostředka se dávají hodnoty s větší tolerancí<br>
- střídá se plus a mínus.<br>
<br>
Tomáš<br>
<br>
<br>
</span><table>
<tr>
<td width=2 bgcolor= #0000ff><br>
</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">rezistory su odmerane. Prvy stlpec je poradove cislo rezistora z pasky, druhy hodnota<br>
</span><table>
<tr>
<td width=132><span style=" font-family:'courier new'; font-size: 9pt;">10k nominal</td>
<td width=161><span style=" font-family:'courier new'; font-size: 9pt;">Value (kOhm)</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">9</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000164</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">1</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000362</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">6</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000424</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">4</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000433</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">5</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000451</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000473</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">15</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000503</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">7</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000592</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">2</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000620</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">11</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000630</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">3</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000660</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">14</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000715</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">12</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000749</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">13</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000789</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">8</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000814</td>
</tr>
</table>
<br><br>
<span style=" font-family:'courier new'; font-size: 9pt;">Vezmeme 12 z nich a zapojime ich do serie. Pomocou skratovacej listy sa daju zapojit paralelne. Podla teorie [1] by mala byt tolerancia seriovej kombinacie a paralelnej kombinacie druha mocnina tolerancie jednotlivych rezistorov, t.j. 0.01% x 0.01% = 0.01 ppm. Excelovy vypocet to nevylucuje:<br>
</span><table>
<tr>
<td width=121><span style=" font-family:'courier new'; font-size: 9pt;">Hodnoty kOhm</td>
<td width=107><span style=" font-family:'courier new'; font-size: 9pt;"> Deliaci pomer</td>
<td width=92><span style=" font-family:'courier new'; font-size: 9pt;"> Chyba pomeru ppm</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000424</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">1</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000789</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,91666822</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">1,690806</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000451</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,83333339</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,0699957</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000715</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,75000138</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">1,8443319</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000503</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,66666717</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,7624535</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000814</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,58333473</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">2,3998536</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000620</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,4999997</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">-0,599963</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000592</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,41666628</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">-0,919944</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000660</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,3333331</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">-0,699957</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000473</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,24999935</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">-2,599841</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000649</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,16666716</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">2,9498201</td>
</tr>
<tr>
<td><span style=" font-family:'courier new'; font-size: 9pt;">10,000630</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">0,0833335</td>
<td><span style=" font-family:'courier new'; font-size: 9pt;">1,999878</td>
</tr>
</table>
</td>
</tr>
</table>
<span style=" font-family:'courier new'; font-size: 9pt;">stredna hodnota 10,000610 kOhm<br>
vsetky seriovo 120,007320 kOhm, vydelene strednou hodnotou 12,0000000<br>
vsetky paralelne 0,833384167 kOhm, vydelene strednou hodnotou 12,0000000<br>
dokonca aj pomer ser/par je 144,0000000<br>
Tato cast zda sa funguje vyborne, stary Hamon to vymyslel perfektne. <br>
A teraz kombinatoricka otazka. Dany geret chceme pouzivat nie len na transfer absolutnej hodnoty odporu a jej presne nasobenie/delenie, ale aj ako velmi presny napatovy delic. Ako vybrat hodnoty tak, aby bola celkova chyba delica co najmensia? T.j. aby kazdy z 12 vystupov bol co najblizsie idealnym 1/12 prirastkom.<br>
Hruba sila asi nebude uplne optimalna, 15! je velmi vela operacii na to aby sa vyskusala kazda kombinacia :-)<br>
Intuitivne som vyskusal prestriedat maly/velky/maly/velky a dava to pouzitelne vysledky. Ale ako by islo najst optimalne riesenie? Len pre zaujimavost. <br>
b.<br>
<br>
[1] Hamon, B. V. "A 1-100 Ω build-up resistor for the calibration of standard resistors." Journal of Scientific Instruments 31.12 (1954): 450 </span><a style=" font-family:'courier new'; font-size: 9pt;" href="https://iopscience.iop.org/article/10.1088/0950-7671/31/12/307/pdf">https://iopscience.iop.org/article/10.1088/0950-7671/31/12/307/pdf</a><br>
<br>
<br>
<br>
<span style=" font-family:'courier new'; font-size: 9pt;">On 14/11/2023 17:31, balu wrote:<br>
Asi som to vyriesil :) udaj sa meni na 7. az 8. mieste, podla toho ako na to dycham. To mi staci. <br>
<br>
<br>
<br>
On 14 Nov 2023, at 16:00, balu </span><a style=" font-family:'courier new'; font-size: 9pt;" href="mailto:balu@k-net.fr"><balu@k-net.fr></a><span style=" font-family:'courier new'; font-size: 9pt;"> wrote:<br>
<br>
<br>
Su to metal foil 0.01% 2512. Presne na tuto otazku budem mat odpoved hned po zaspajkovani :) <br>
Ucelom nie je presna absolutna hodnota, ale najst z kotuca take aby ked sa z toho urobi 12-odporovy delic aby bol co najviac monotonny. A ak bude viditelny rozdiel medzi 0.01% hodnotami najst take aby boli co najrovnakejsie. </body></html>