{"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":13,"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",255]
["Index","PWM","PWM2","PWM3",null,"Steps",64,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":7.9943534368588569},"=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":8},"=LOG2(MAX PWM + 1)"]
[3,4,1,0,null,"Basis",{"$f":"POWER(G1/G3,1/(G2-1))","v":1.0730641783324963},"=(MAX PWM / Factor) ^ (1 / (Steps-1))"]
[4,4,2,1,null,"PWM1[Index] = Round(Factor * Basis^Index); Index=1....Steps-1",null,null,null,null,null,"Originalfunktion / original function"]
[5,4,2,1,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,5,2,1,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"]
[7,5,2,1]
[8,5,2,1]
[9,6,2,1]
[10,6,3,2]
[11,7,3,2]
[12,7,3,2]
[13,8,3,2]
[14,8,4,3]
[15,9,4,3]
[16,9,4,3]
[17,10,5,4]
[18,11,5,4]
[19,11,6,5]
[20,12,6,5]
[21,13,7,6]
[22,14,7,6]
[23,15,8,7]
[24,16,9,8]
[25,17,9,9]
[26,19,10,9]
[27,20,11,10]
[28,22,12,11]
[29,23,13,12]
[30,25,15,14]
[31,27,16,15]
[32,29,17,16]
[33,31,19,18]
[34,33,21,20]
[35,35,23,22]
[36,38,25,24]
[37,41,27,26]
[38,44,29,28,null,"Werte zur Generierung der Tabellen aus dem Democode"]
[39,47,32,31,null,"mithilfe der Funktion PWM"]
[40,50,35,34,null,"Tabelle / Table","MAX PWM","Steps","Factor"]
[41,54,38,37,null,"pwmtable_8A",255,4,4]
[42,58,41,40,null,"pwmtable_8B",255,8,2]
[43,62,45,44,null,"pwmtable_8C",255,16,1.4350000000000001]
[44,67,49,48,null,"pwmtable_8D",255,32,1.21]
[45,72,54,53,null,"pwmtable_10",1023,64,1.115]
[46,77,59,58,null,"pwmtable_16",65535,256,1.04427]
[47,83,64,63]
[48,89,70,69]
[49,95,76,75]
[50,102,83,82]
[51,109,90,90]
[52,117,98,98]
[53,126,107,107]
[54,135,117,116]
[55,145,128,127]
[56,156,139,139]
[57,167,152,151]
[58,179,165,165]
[59,192,180,180]
[60,206,197,196]
[61,221,214,214]
[62,238,234,234]
[63,255,255,255]
[64,274,278,{"$f":"ROUND(2^($G$5*($A67+1)/$G$2)-1,0)","v":278}]
[65,{"$f":"ROUND($G$3*POWER($G$6,A68),0)","v":294},303,303]
[66,315,{"$f":"ROUND(2^($G$4*($A69+1)/$G$2),0)","v":331},331]
[67,338,361,361]
[68,363,393,394]
[69,389,429,430]
[70,418,467,469]
[71,448,510,511]
[72,481,556,557]
[73,516,606,608]
[74,554,661,663]
[75,594,721,723]
[76,638,786,789]
[77,684,857,860]
[78,734,934,938]
[79,788,1019,1023]
[80,846,1111,1116]
[81,907,1212,1217]
[82,974,1321,1327]
[83,1045,1441,1447]
[84,1121,1571,1578]
[85,1203,1713,1721]
[86,1291,1868,1877]
[87,1385,2037,2047]
[88,1487,2221,2232]
[89,1595,2422,2434]
[90,1712,2641,2655]
[91,1837,2880,2895]
[92,1971,3141,3157]
[93,2115,3425,3443]
[94,2270,3734,3755]
[95,2435,4072,4095]
[96,2613,4440,4466]
[97,2804,4842,4870]
[98,3009,5280,5311]
[99,3229,5757,5792]
[100,3465,6278,6316]
[101,3718,6846,6888]
[102,3990,7465,7511]
[103,4281,8140,8191]
[104,4594,8876,8932]
[105,4930,9679,9741]
[106,5290,10554,10623]
[107,5676,11509,11584]
[108,6091,12550,12633]
[109,6536,13685,13776]
[110,7014,14923,15023]
[111,7526,16272,16383]
[112,8076,17744,17866]
[113,8666,19349,19483]
[114,9299,21099,21246]
[115,9979,23007,23169]
[116,10708,25087,25267]
[117,11490,27356,27553]
[118,12330,29831,30047]
[119,13231,32528,32767]
[120,14197,35470,35733]
[121,15235,38678,38967]
[122,16348,42176,42494]
[123,17542,45991,46340]
[124,18824,50150,50534]
[125,20199,54686,55108]
[126,21675,59632,60096]
[127,23259,65025,65535]
[128,24958,70906,{"$f":"ROUND(2^($G$5*($A131+1)/$G$2)-1,0)","v":71467}]
[129,{"$f":"ROUND($G$3*POWER($G$6,A132),0)","v":26782},77319,77935]
[130,28738,{"$f":"ROUND(2^($G$4*($A133+1)/$G$2),0)","v":84312},84989]
[131,30838,91937,92681]
[132,33091,100252,101069]
[133,35509,109318,110217]
[134,38103,119205,120193]
[135,40887,129986,131071]
[136,43875,141742,142934]
[137,47081,154562,155871]
[138,50520,168541,169978]
[139,54212,183784,185363]
[140,58173,200405,202140]
[141,62423,218530,220435]
[142,66984,238294,240386]
[143,71878,259846,262143]
[144,77130,283346,285869]
[145,82765,308972,311743]
[146,88812,336916,339958]
[147,95301,367387,370727]
[148,102264,400614,404280]
[149,109736,436846,440871]
[150,117754,476355,480773]
[151,126358,519437,524287]
[152,135590,566415,571739]
[153,145497,617643,623486]
[154,156127,673503,679916]
[155,167535,734415,741454]
[156,179775,800837,808562]
[157,192910,873265,881743]
[158,207005,952244,961547]
[159,222130,1038366,1048575]
[160,238360,1132277,1143479]
[161,255775,1234681,1246973]
[162,274463,1346347,1359834]
[163,294517,1468112,1482909]
[164,316035,1600890,1617124]
[165,339126,1745676,1763487]
[166,363904,1903557,1923096]
[167,390492,2075716,2097151]
[168,419024,2263446,2286959]
[169,449639,2468155,2493947]
[170,482492,2691377,2719669]
[171,517744,2934788,2965820]
[172,555573,3200213,3234250]
[173,596166,3489644,3526974]
[174,639724,3805251,3846193]
[175,686465,4149402,4194303]
[176,736621,4524678,4573920]
[177,790441,4933895,4987895]
[178,848194,5380121,5439338]
[179,910167,5866705,5931641]
[180,976668,6397296,6468500]
[181,1048027,6975874,7053949]
[182,1124600,7606780,7692386]
[183,1206768,8294745,8388607]
[184,1294940,9044930,9147841]
[185,1389553,9862963,9975791]
[186,1491080,10754980,10878678]
[187,1600025,11727671,11863282]
[188,1716929,12788334,12937001]
[189,1842375,13944924,14107900]
[190,1976987,15206118,15384774]
[191,2121434,16581375,16777215]
[192,2276434,18081012,{"$f":"ROUND(2^($G$5*($A195+1)/$G$2)-1,0)","v":18295683}]
[193,{"$f":"ROUND($G$3*POWER($G$6,A196),0)","v":2442760},19716277,19951584]
[194,2621238,{"$f":"ROUND(2^($G$4*($A197+1)/$G$2),0)","v":21499438},21757356]
[195,2812757,23443870,23726565]
[196,3018269,25564158,25874003]
[197,3238796,27876207,28215801]
[198,3475436,30397360,30769549]
[199,3729366,33146530,33554431]
[200,4001849,36144336,36591367]
[201,4294241,39413268,39903168]
[202,4607996,42977845,43514714]
[203,4944675,46864806,47453132]
[204,5305954,51103308,51748007]
[205,5693629,55725145,56431602]
[206,6109630,60764985,61539099]
[207,6556025,66260634,67108863]
[208,7035035,72253315,73182734]
[209,7549044,78787980,79806338]
[210,8100609,85913647,87029428]
[211,8692473,93683768,94906265]
[212,9327582,102156625,103496016]
[213,10009094,111395777,112863205]
[214,10740400,121470528,123078198]
[215,11525139,132456449,134217727]
[216,12367213,144435949,146365469]
[217,13270814,157498887,159612676]
[218,14240435,171743251,174058858]
[219,15280901,187275890,189812530]
[220,16397387,204213317,206992032]
[221,17595449,222682583,225726412]
[222,18881046,242822229,246156397]
[223,20260574,264783325,268435455]
[224,21740896,288730606,292730939]
[225,23329377,314843703,319225353]
[226,25033918,343318497,348117716]
[227,26863001,374368581,379625061]
[228,28825724,408226866,413984065]
[229,30931852,445147331,451452824]
[230,33191862,485406920,492312796]
[231,35616998,529307630,536870911]
[232,38219325,577178765,585461880]
[233,41011789,629379415,638450707]
[234,44008281,686301147,696235433]
[235,47223710,748370940,759250124]
[236,50674072,816054390,827968131]
[237,54376531,889859202,902905650]
[238,58349508,970338999,984625593]
[239,62612767,1058097472,1073741823]
[240,67187517,1153792913,1170923761]
[241,72096518,1258143150,1276901416]
[242,77364190,1371930931,1392470868]
[243,83016741,1496009798,1518500249]
[244,89082291,1631310488,1655936264]
[245,95591016,1778847913,1805811300]
[246,102575295,1939728777,1969251187]
[247,110069875,2115159875,2147483647]
[248,118112039,2306457144,2341847523]
[249,126741799,2515055539,2553802833]
[250,136002084,2742519790,2784941737]
[251,145938964,2990556146,3037000499]
[252,156601875,3261025169,3311872528]
[253,168043862,3555955693,3611622602]
[254,180321849,3877560042,3938502375]
[255,193496917,4228250625,4294967295]