{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PWM Table for LED Fading or Dim"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PWM Table for LED Fading or Dim","index":0,"n_rows":258,"n_cols":19,"rows_kept":258,"cut":false,"hidden":false,"merged":[[8,5,8,10],[8,11,8,14],[40,5,40,8],[41,5,41,8],[3,7,3,10],[4,7,4,10],[5,7,5,10],[6,5,6,10],[6,11,6,14],[7,5,7,10],[7,11,7,14]]}
[null,null,null,null,null,"MAX PWM",65535]
["Index","PWM","PWM2","PWM3",null,"Steps",255,null,null,null,null,null,"Wunschwerte eintragen / Choose values"]
[0,0,0,{"$f":"ROUND(2^($G$5*($A3+1)/$G$2)-1,0)","v":0},null,"Factor",3,null,null,null,null,null,"Zwischenergebnis / Interim results"]
[1,{"$f":"ROUND($G$3*POWER($G$6,A4),0)","v":3},{"$f":"ROUND(2^($G$4*($A4)/$G$2),0)","v":1},0,null,"No-of-Bits1",{"$f":"LOG($G$1)/LOG(2)","v":15.999977986052736},"=LOG2(MAX PWM)",null,null,null,null,"PWM Werte für pwmtable[] / PWM values for pwmtable[]"]
[2,3,{"$f":"ROUND(2^($G$4*($A5+1)/$G$2),0)","v":1},0,null,"No-of-Bits2",{"$f":"LOG($G$1+1)/LOG(2)","v":16},"=LOG2(MAX PWM + 1)"]
[3,3,1,0,null,"Basis",{"$f":"POWER(G1/G3,1/(G2-1))","v":1.0401214750011258},"=(MAX PWM / Factor) ^ (1 / (Steps-1))"]
[4,4,1,0,null,"PWM1[Index] = Round(Factor * Basis^Index); Index=1....Steps-1",null,null,null,null,null,"Originalfunktion / original function"]
[5,4,1,0,null,"PWM2[Index] = Round(2 ^( No-of-Bits1 * (Index+1) / Steps) ); Index=1....Steps-1",null,null,null,null,null,"Alternative Funktion / alternative function"]
[6,4,1,0,null,"PWM3[Index] = Round(2 ^( No-of-Bits2 * (Index+1) / Steps)-1); Index=0....Steps-1",null,null,null,null,null,"Alternative Funktion / alternative function",null,null,null,null,null,null,{"$f":"B3&\",\"&B4&\",\"&B5&\",\"&B6&\",\"&B7&\",\"&B8&\",\"&B9&\",\"&B10&\",\"&B11&\",\"&B12&\",\"&B13&\",\"&B14&\",\"&B15&\",\"&B16&\",\"&B17&\",\"&B18&\",\"&B19&\",\"&B20&\",\"&B21&\",\"&B22&\",\"&B23&\",\"&B24&\",\"&B25&\",\"&B26&\",\"&B27&\",\"&B28&\",\"&B29&\",\"&B30&\",\"&B31&\",\"&B32&\",\"&B33","v":"0,3,3,3,4,4,4,4,4,4,4,5,5,5,5,5,6,6,6,6,7,7,7,7,8,8,8,9,9,9,10"}]
[7,4,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B34&\",\"&B35&\",\"&B36&\",\"&B37&\",\"&B38&\",\"&B39&\",\"&B40&\",\"&B41&\",\"&B42&\",\"&B43&\",\"&B44&\",\"&B45&\",\"&B46&\",\"&B47&\",\"&B48&\",\"&B49&\",\"&B50&\",\"&B51&\",\"&B52&\",\"&B53&\",\"&B54&\",\"&B55&\",\"&B56&\",\"&B57&\",\"&B58&\",\"&B59&\",\"&B60&\",\"&B61&\",\"&B62&\",\"&B63&\",\"&B64","v":"10,11,11,11,12,12,13,13,14,14,15,16,16,17,18,18,19,20,21,21,22,23,24,25,26,27,28,29,31,32,33"}]
[8,4,1,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B65&\",\"&B66&\",\"&B67&\",\"&B68&\",\"&B69&\",\"&B70&\",\"&B71&\",\"&B72&\",\"&B73&\",\"&B74&\",\"&B75&\",\"&B76&\",\"&B77&\",\"&B78&\",\"&B79&\",\"&B80&\",\"&B81&\",\"&B82&\",\"&B83&\",\"&B84&\",\"&B85&\",\"&B86&\",\"&B87&\",\"&B88&\",\"&B89&\",\"&B90&\",\"&B91&\",\"&B92&\",\"&B93&\",\"&B94&\",\"&B95","v":"34,36,37,39,40,42,44,45,47,49,51,53,55,57,60,62,65,67,70,73,76,79,82,85,88,92,96,99,103,108,112"}]
[9,4,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B96&\",\"&B97&\",\"&B98&\",\"&B99&\",\"&B100&\",\"&B101&\",\"&B102&\",\"&B103&\",\"&B104&\",\"&B105&\",\"&B106&\",\"&B107&\",\"&B108&\",\"&B109&\",\"&B110&\",\"&B111&\",\"&B112&\",\"&B113&\",\"&B114&\",\"&B115&\",\"&B116&\",\"&B117&\",\"&B118&\",\"&B119&\",\"&B120&\",\"&B121&\",\"&B122&\",\"&B123&\",\"&B124&\",\"&B125&\",\"&B126","v":"116,121,126,131,136,142,147,153,159,166,172,179,187,194,202,210,218,227,236,246,256,266,277,288,299,311,324,337,350,364,379"}]
[10,4,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B127&\",\"&B128&\",\"&B129&\",\"&B130&\",\"&B131&\",\"&B132&\",\"&B133&\",\"&B134&\",\"&B135&\",\"&B136&\",\"&B137&\",\"&B138&\",\"&B139&\",\"&B140&\",\"&B141&\",\"&B142&\",\"&B143&\",\"&B144&\",\"&B145&\",\"&B146&\",\"&B147&\",\"&B148&\",\"&B149&\",\"&B150&\",\"&B151&\",\"&B152&\",\"&B153&\",\"&B154&\",\"&B155&\",\"&B156&\",\"&B157","v":"394,410,426,443,461,480,499,519,540,561,584,607,632,657,683,711,739,769,800,832,865,900,936,974,1013,1054,1096,1140,1185,1233,1283"}]
[11,5,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B158&\",\"&B159&\",\"&B160&\",\"&B161&\",\"&B162&\",\"&B163&\",\"&B164&\",\"&B165&\",\"&B166&\",\"&B167&\",\"&B168&\",\"&B169&\",\"&B170&\",\"&B171&\",\"&B172&\",\"&B173&\",\"&B174&\",\"&B175&\",\"&B176&\",\"&B177&\",\"&B178&\",\"&B179&\",\"&B180&\",\"&B181&\",\"&B182&\",\"&B183&\",\"&B184&\",\"&B185&\",\"&B186&\",\"&B187&\",\"&B188","v":"1334,1388,1443,1501,1561,1624,1689,1757,1827,1901,1977,2056,2139,2225,2314,2407,2503,2604,2708,2817,2930,3047,3170,3297,3429,3567,3710,3859,4013,4174,4342"}]
[12,5,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B189&\",\"&B190&\",\"&B191&\",\"&B192&\",\"&B193&\",\"&B194&\",\"&B195&\",\"&B196&\",\"&B197&\",\"&B198&\",\"&B199&\",\"&B200&\",\"&B201&\",\"&B202&\",\"&B203&\",\"&B204&\",\"&B205&\",\"&B206&\",\"&B207&\",\"&B208&\",\"&B209&\",\"&B210&\",\"&B211&\",\"&B212&\",\"&B213&\",\"&B214&\",\"&B215&\",\"&B216&\",\"&B217&\",\"&B218&\",\"&B219","v":"4516,4697,4886,5082,5286,5498,5718,5948,6186,6434,6693,6961,7240,7531,7833,8147,8474,8814,9168,9536,9918,10316,10730,11161,11608,12074,12559,13063,13587,14132,14699"}]
[13,5,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B220&\",\"&B221&\",\"&B222&\",\"&B223&\",\"&B224&\",\"&B225&\",\"&B226&\",\"&B227&\",\"&B228&\",\"&B229&\",\"&B230&\",\"&B231&\",\"&B232&\",\"&B233&\",\"&B234&\",\"&B235&\",\"&B236&\",\"&B237&\",\"&B238&\",\"&B239&\",\"&B240&\",\"&B241&\",\"&B242&\",\"&B243&\",\"&B244&\",\"&B245&\",\"&B246&\",\"&B247&\",\"&B248&\",\"&B249&\",\"&B250","v":"15288,15902,16540,17203,17894,18612,19358,20135,20943,21783,22657,23566,24512,25495,26518,27582,28689,29840,31037,32282,33577,34924,36326,37783,39299,40876,42516,44221,45996,47841,49761"}]
[14,5,2,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B251&\",\"&B252&\",\"&B253&\",\"&B254&\",\"&B255&\",\"&B256&\",\"&B257","v":"51757,53834,55993,58240,60577,63007,65535"}]
[15,5,2,1]
[16,6,2,1]
[17,6,2,1]
[18,6,2,1]
[19,6,2,1]
[20,7,2,1]
[21,7,3,2]
[22,7,3,2]
[23,7,3,2]
[24,8,3,2]
[25,8,3,2]
[26,8,3,2]
[27,9,3,2]
[28,9,4,3]
[29,9,4,3]
[30,10,4,3]
[31,10,4,3]
[32,11,4,3]
[33,11,4,3]
[34,11,5,4]
[35,12,5,4]
[36,12,5,4]
[37,13,5,4]
[38,13,5,4,null,"Werte zur Generierung der Tabellen aus dem Democode"]
[39,14,6,5,null,"mithilfe der Funktion PWM"]
[40,14,6,5,null,"Tabelle / Table","MAX PWM","Steps","Factor"]
[41,15,6,5,null,"pwmtable_8A",255,4,4]
[42,16,6,5,null,"pwmtable_8B",255,8,2]
[43,16,7,6,null,"pwmtable_8C",255,16,1.4350000000000001]
[44,17,7,6,null,"pwmtable_8D",255,32,1.21]
[45,18,7,6,null,"pwmtable_10",1023,64,1.115]
[46,18,8,7,null,"pwmtable_16",65535,256,1.04427]
[47,19,8,7]
[48,20,8,7]
[49,21,9,8]
[50,21,9,8]
[51,22,10,9]
[52,23,10,9]
[53,24,10,9]
[54,25,11,10]
[55,26,11,10]
[56,27,12,11]
[57,28,12,11]
[58,29,13,12]
[59,31,14,13]
[60,32,14,13]
[61,33,15,14]
[62,34,15,14]
[63,36,16,15]
[64,37,17,{"$f":"ROUND(2^($G$5*($A67+1)/$G$2)-1,0)","v":16}]
[65,{"$f":"ROUND($G$3*POWER($G$6,A68),0)","v":39},18,17]
[66,40,{"$f":"ROUND(2^($G$4*($A69+1)/$G$2),0)","v":18},17]
[67,42,19,18]
[68,44,20,19]
[69,45,21,20]
[70,47,22,21]
[71,49,23,22]
[72,51,24,23]
[73,53,25,24]
[74,55,26,25]
[75,57,27,26]
[76,60,28,27]
[77,62,30,29]
[78,65,31,30]
[79,67,32,31]
[80,70,34,33]
[81,73,35,34]
[82,76,37,36]
[83,79,39,38]
[84,82,40,39]
[85,85,42,41]
[86,88,44,43]
[87,92,46,45]
[88,96,48,47]
[89,99,50,49]
[90,103,52,51]
[91,108,55,54]
[92,112,57,56]
[93,116,60,59]
[94,121,62,61]
[95,126,65,64]
[96,131,68,67]
[97,136,71,70]
[98,142,74,73]
[99,147,77,76]
[100,153,81,80]
[101,159,84,83]
[102,166,88,87]
[103,172,92,91]
[104,179,96,95]
[105,187,100,99]
[106,194,105,104]
[107,202,110,109]
[108,210,115,114]
[109,218,120,119]
[110,227,125,124]
[111,236,130,129]
[112,246,136,135]
[113,256,142,141]
[114,266,149,148]
[115,277,155,154]
[116,288,162,161]
[117,299,169,168]
[118,311,177,176]
[119,324,185,184]
[120,337,193,192]
[121,350,202,201]
[122,364,210,209]
[123,379,220,219]
[124,394,230,229]
[125,410,240,239]
[126,426,250,249]
[127,443,262,261]
[128,461,273,{"$f":"ROUND(2^($G$5*($A131+1)/$G$2)-1,0)","v":272}]
[129,{"$f":"ROUND($G$3*POWER($G$6,A132),0)","v":480},285,284]
[130,499,{"$f":"ROUND(2^($G$4*($A133+1)/$G$2),0)","v":298},297]
[131,519,311,310]
[132,540,325,324]
[133,561,340,339]
[134,584,355,354]
[135,607,370,370]
[136,632,387,386]
[137,657,404,403]
[138,683,422,421]
[139,711,441,440]
[140,739,460,460]
[141,769,481,480]
[142,800,502,501]
[143,832,525,524]
[144,865,548,547]
[145,900,572,571]
[146,936,598,597]
[147,974,624,623]
[148,1013,652,651]
[149,1054,681,680]
[150,1096,711,710]
[151,1140,743,742]
[152,1185,776,775]
[153,1233,811,810]
[154,1283,847,846]
[155,1334,884,883]
[156,1388,923,923]
[157,1443,965,964]
[158,1501,1007,1006]
[159,1561,1052,1051]
[160,1624,1099,1098]
[161,1689,1148,1147]
[162,1757,1199,1198]
[163,1827,1252,1251]
[164,1901,1308,1307]
[165,1977,1366,1365]
[166,2056,1427,1426]
[167,2139,1490,1489]
[168,2225,1556,1555]
[169,2314,1625,1624]
[170,2407,1698,1697]
[171,2503,1773,1772]
[172,2604,1852,1851]
[173,2708,1934,1933]
[174,2817,2020,2019]
[175,2930,2110,2109]
[176,3047,2204,2203]
[177,3170,2302,2301]
[178,3297,2404,2403]
[179,3429,2511,2510]
[180,3567,2623,2622]
[181,3710,2739,2738]
[182,3859,2861,2860]
[183,4013,2988,2987]
[184,4174,3121,3120]
[185,4342,3260,3259]
[186,4516,3405,3404]
[187,4697,3556,3555]
[188,4886,3714,3713]
[189,5082,3879,3878]
[190,5286,4052,4051]
[191,5498,4232,4231]
[192,5718,4420,{"$f":"ROUND(2^($G$5*($A195+1)/$G$2)-1,0)","v":4419}]
[193,{"$f":"ROUND($G$3*POWER($G$6,A196),0)","v":5948},4616,4615]
[194,6186,{"$f":"ROUND(2^($G$4*($A197+1)/$G$2),0)","v":4822},4821]
[195,6434,5036,5035]
[196,6693,5260,5259]
[197,6961,5494,5493]
[198,7240,5738,5737]
[199,7531,5993,5992]
[200,7833,6259,6258]
[201,8147,6537,6536]
[202,8474,6828,6827]
[203,8814,7131,7131]
[204,9168,7448,7448]
[205,9536,7780,7779]
[206,9918,8125,8124]
[207,10316,8487,8486]
[208,10730,8864,8863]
[209,11161,9258,9257]
[210,11608,9669,9668]
[211,12074,10099,10098]
[212,12559,10548,10547]
[213,13063,11017,11016]
[214,13587,11507,11506]
[215,14132,12018,12017]
[216,14699,12552,12551]
[217,15288,13110,13109]
[218,15902,13693,13692]
[219,16540,14302,14301]
[220,17203,14937,14937]
[221,17894,15601,15601]
[222,18612,16295,16294]
[223,19358,17019,17019]
[224,20135,17776,17775]
[225,20943,18566,18565]
[226,21783,19391,19391]
[227,22657,20253,20252]
[228,23566,21153,21153]
[229,24512,22094,22093]
[230,25495,23076,23075]
[231,26518,24102,24101]
[232,27582,25173,25172]
[233,28689,26292,26291]
[234,29840,27461,27460]
[235,31037,28681,28681]
[236,32282,29956,29956]
[237,33577,31288,31287]
[238,34924,32679,32678]
[239,36326,34131,34131]
[240,37783,35648,35648]
[241,39299,37233,37233]
[242,40876,38888,38888]
[243,42516,40617,40616]
[244,44221,42422,42422]
[245,45996,44308,44307]
[246,47841,46277,46277]
[247,49761,48334,48334]
[248,51757,50483,50483]
[249,53834,52727,52727]
[250,55993,55071,55071]
[251,58240,57519,57519]
[252,60577,60075,60075]
[253,63007,62746,62746]
[254,65535,65535,65535]
[255,68164,68448,68448]