反推調光數值table表燈盤特性曲線_v9.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AB	AC
1	操作說明：※禁止使用"剪下(CTRL + X)"，會造成儲存格公式錯亂※A區輸入，調整B區，C區輸出；資料輸入A區，再調整B區輸入燈盤table表的範圍，經由C區輸出反推照度lux表。綠色區域為輸入區，藍色區域為反推PWM(%)、照度輸出區(儲存格AB:AC欄位)。									※專為已手動建燈table表設計※ 如客戶要調整最低亮度，可在不改變原有的曲線條件下快速生成table表(需搭配"調光數值table轉換表.xlsx"將生成的"反推亮度、照度表"直接填入)，如要得到最佳特性曲線可使用手機或照度計快速取得三個數值即可得到最佳特性曲線(0%亮度照度值、最低亮度照度值、最高亮度照度值)，再根據曲線圖微調未知區域的gamma值
2
3
4
5
6
7
8										B區：PWM duty與Lux調整區		數值指定
9										總階數	92
10										最小PWM_duty	0
11										最大PWM_duty，若遇到非最大值(如100 255 1024)使曲線無法正確顯示時可手動填右側欄位	100
12										亮度0%時的LUX MIN(預設20，需指定請填右側欄位)	20
13										最低亮度時的 LUX值(預設10%，需指定請填右側欄位)	1691
14										亮度100%時的LUX MAX(預設16910，需指定請填右側欄位)	16910
15										gamma(預設2.2，需指定請填右側欄位)	2.2
16										低於最低亮度未知區域所用的gamma值(預設3，需指定請填右側欄位)	3
17										最小可亮起之亮度	33
18										最小PWM_duty LUX值對應gamma的亮度%	34.9425
19										最後一筆階數的儲存格位址	$B$119
20
21
22
23
24	A區："燈Table表"-資料輸入區；PWM_duty固定為0
25								轉換成亮度%數最後一筆儲存格位址	gamma lux推算最後一筆儲存格位址	亮度%數精度					lux_index MAX
26								$H$119	$I$119	0.0025					91												C區：反推PWM(%)、照度輸出區
27	lux_index	PWM_duty輸入	找出與前一筆不同(不同為1)	找出當前同數值有幾筆	找出相同數值的分母	相同數值相除	校正後的PWM_duty	轉換成亮度%數	gamma 2.2 lux MAX16910 MIN20推算	亮度0~100%	校正後的照度lux	亮度0~100%	回推索引用index	索引到index的數值	索引到index對應的lux值	舊index值	舊index對應的lux值	相同Index數量	lux遞減值	判斷索引值是否為浮點數	判斷浮點數是否大於下一個遞減值	回推用亮度%數從100~0	回推亮度100~0對應lux值	亮度	gammer照度lux	反推照度lux	PWM(%)	反推照度lux
28	0	0	1	1	1	0	0	0	20	0	20	0	0	100	16910	100	16910	1	0	0	0	100	16910	0	20	20	0	20
29	1	33	1	1	1	0	33	33	1691	0.0025	20.00000127	0.0025	1	99.5	16641.7758	100	16910	1	-268.2241968	1	1	99.5	16641.7758	1	20.67240301	20.04649804	1	20.04649804
30	2	34	1	1	1	0	34	34	1768.085023	0.005	20.00000583	0.005	2	99	16376.80476	99.5	16641.7758	1	-264.9710422	0	0	99	16376.80476	2	23.08955293	20.37198431	2	20.37198431
31	3	35	1	1	1	0	35	35	1846.941033	0.0075	20.00001422	0.0075	3	98	16114.15454	99	16376.80476	1	-262.6502167	0	0	98	16114.15454	3	27.53869911	21.25544703	3	21.25544703
32	4	36	1	1	2	0	36	36	1927.698548	0.01	20.00002677	0.01	4	97.5	15853.82174	98	16114.15454	1	-260.332804	1	1	97.5	15853.82174	4	34.19585748	22.97587445	4	22.97587445
33	5	36	0	2	2	0.5	36.5	36.5	2010.36506	0.0125	20.00004374	0.0125	5	97	15595.80292	97.5	15853.82174	1	-258.0188245	0	0	97	15595.80292	5	43.19335947	25.81225478	5	25.81225478
34	6	37	1	1	2	0	37	37	2094.947946	0.015	20.00006532	0.015	6	96	15340.09462	97	15595.80292	1	-255.7082986	0	0	96	15340.09462	6	54.63876508	30.04357626	6	30.04357626
35	7	37	0	2	2	0.5	37.5	37.5	2181.454469	0.0175	20.00009169	0.0175	7	95.5	15085.82055	96	15340.09462	1	-254.2740668	1	1	95.5	15085.82055	7	68.62340156	35.94882711	7	35.94882711
36	8	38	1	1	1	0	38	38	2270.201159	0.02	20.000123	0.02	8	95	14834.73082	95.5	15085.82055	1	-251.0897263	0	0	95	14834.73082	8	85.22703253	43.80699558	8	43.80699558
37	9	39	1	1	2	0	39	39	2360.583042	0.0225	20.00015938	0.0225	9	94	14585.94112	95	14834.73082	1	-248.7896992	0	0	94	14585.94112	9	104.5207166	53.89706987	9	53.89706987
38	10	39	0	2	2	0.5	39.5	39.5	2452.909745	0.025	20.00020095	0.025	10	93.5	14339.44791	94	14585.94112	1	-246.4932106	1	1	93.5	14339.44791	10	126.5686955	66.49803823	10	66.49803823
39	11	40	1	1	2	0	40	40	2547.188123	0.0275	20.00024783	0.0275	11	93	14095.24763	93.5	14339.44791	1	-244.2002825	0	0	93	14095.24763	11	151.4297122	81.88888889	11	81.88888889
40	12	40	0	2	2	0.5	40.5	40.5	2643.424931	0.03	20.00030012	0.03	12	92	13853.33669	93	14095.24763	1	-241.9109371	0	0	92	13853.33669	12	179.1579699	100.3486101	12	100.3486101
41	13	41	1	1	1	0	41	41	2741.626836	0.0325	20.00035791	0.0325	13	91.5	13613.7115	92	13853.33669	1	-239.625197	1	1	91.5	13613.7115	13	209.8038531	122.15619	13	122.15619
42	14	42	1	1	2	0	42	42	2841.800414	0.035	20.00042129	0.035	14	91	13375.55111	91.5	13613.7115	1	-238.1603837	0	0	91	13375.55111	14	243.4144855	147.5906169	14	147.5906169
43	15	42	0	2	2	0.5	42.5	42.5	2944.309062	0.0375	20.00049034	0.0375	15	90	13140.49437	91	13375.55111	1	-235.0567469	0	0	90	13140.49437	15	280.0341694	176.930879	15	176.930879
44	16	43	1	1	2	0	43	43	3048.452249	0.04	20.00056515	0.04	16	89	12907.71239	90	13140.49437	1	-232.781974	0	0	89	12907.71239	16	319.7047399	210.4559646	16	210.4559646
45	17	43	0	2	2	0.5	43.5	43.5	3154.58635	0.0425	20.00064578	0.0425	17	88.5	12677.20149	89	12907.71239	1	-230.5109001	1	1	88.5	12677.20149	17	362.4658544	248.4448618	17	248.4448618
46	18	44	1	1	1	0	44	44	3262.717608	0.045	20.00073231	0.045	18	88	12448.95794	88.5	12677.20149	1	-228.2435493	0	0	88	12448.95794	18	408.3552323	291.176559	18	291.176559
47	19	45	1	1	3	0	45	45	3372.852193	0.0475	20.00082481	0.0475	19	87	12222.978	88	12448.95794	1	-225.9799464	0	0	87	12222.978	19	457.4088559	338.9300442	19	338.9300442
48	20	45	0	2	3	0.3333333333	45.33333333	45.33333333	3484.996195	0.05	20.00092334	0.05	20	86	11999.25788	87	12222.978	1	-223.7201162	0	0	86	11999.25788	20	509.6611408	391.9843059	20	391.9843059
49	21	45	0	3	3	0.6666666667	45.66666667	45.66666667	3599.155633	0.0525	20.00102797	0.0525	21	85	11777.0314	86	11999.25788	1	-222.2264837	0	0	85	11777.0314	21	565.1450814	450.6183321	21	450.6183321
50	22	46	1	1	2	0	46	46	3715.741983	0.055	20.00113875	0.055	22	84	11557.82731	85	11777.0314	1	-219.2040897	0	0	84	11557.82731	22	623.8923768	515.1111111	22	515.1111111
51	23	46	0	2	2	0.5	46.5	46.5	3833.957096	0.0575	20.00125574	0.0575	23	83	11340.87156	84	11557.82731	1	-216.9557451	0	0	83	11340.87156	23	685.9335399	585.7416312	23	585.7416312
52	24	47	1	1	1	0	47	47	3954.205304	0.06	20.00137899	0.06	24	82.5	11126.16029	83	11340.87156	1	-214.7112771	1	1	82.5	11126.16029	24	751.2979927	662.7888805	24	662.7888805
53	25	48	1	1	2	0	48	48	4076.492353	0.0625	20.00150857	0.0625	25	82	10913.68957	82.5	11126.16029	1	-212.4707128	0	0	82	10913.68957	25	820.0141503	746.5318474	25	746.5318474
54	26	48	0	2	2	0.5	48.5	48.5	4200.823924	0.065	20.00164452	0.065	26	81	10703.45549	82	10913.68957	1	-210.2340796	0	0	81	10703.45549	26	892.1094955	837.24952	26	837.24952
55	27	49	1	1	1	0	49	49	4327.205638	0.0675	20.00178689	0.0675	27	80	10495.45409	81	10703.45549	1	-208.0014053	0	0	80	10495.45409	27	967.610645	935.2208866	27	935.2208866
56	28	50	1	1	1	0	50	50	4455.64305	0.07	20.00193573	0.07	28	79	10288.97322	80	10495.45409	1	-206.48087	0	0	79	10288.97322	28	1046.543408	1040.724935	28	1040.724935
57	29	51	1	1	2	0	51	51	4586.596799	0.0725	20.00209109	0.0725	29	78.5	10085.43286	79	10288.97322	1	-203.5403562	1	1	78.5	10085.43286	29	1128.93284	1154.040654	29	1154.040654
58	30	51	0	2	2	0.5	51.5	51.5	4719.16921	0.075	20.00225302	0.075	30	78	9884.113117	78.5	10085.43286	1	-201.3197441	0	0	78	9884.113117	30	1214.80329	1275.447032	30	1275.447032
59	31	52	1	1	1	0	52	52	4853.813662	0.0775	20.00242155	0.0775	31	77	9685.00991	78	9884.113117	1	-199.103207	0	0	77	9685.00991	31	1304.178445	1405.223057	31	1405.223057
60	32	53	1	1	1	0	53	53	4990.535484	0.08	20.00259673	0.08	32	76.5	9488.119135	77	9685.00991	1	-196.8907751	1	1	76.5	9488.119135	32	1397.081367	1543.647717	32	1543.647717
61	33	54	1	1	1	0	54	54	5129.33995	0.0825	20.00277861	0.0825	33	76	9293.436656	76.5	9488.119135	1	-194.6824789	0	0	76	9293.436656	33	1493.53453	1691	33	1691
62	34	55	1	1	1	0	55	55	5270.232281	0.085	20.00296723	0.085	34	75	9100.958307	76	9293.436656	1	-192.4783498	0	0	75	9100.958307	34	1593.559854	1768.085023	34	1768.085023
63	35	56	1	1	1	0	56	56	5413.217647	0.0875	20.00316262	0.0875	35	74	8910.025299	75	9100.958307	1	-190.9330078	0	0	74	8910.025299	35	1697.178734	1846.941033	35	1846.941033
64	36	57	1	1	1	0	57	57	5558.806835	0.09	20.00336483	0.09	36	73	8721.950169	74	8910.025299	1	-188.0751299	0	0	73	8721.950169	36	1804.412066	1927.698548	36	1927.698548
65	37	58	1	1	1	0	58	58	5706.000866	0.0925	20.00357389	0.0925	37	72.5	8536.066459	73	8721.950169	1	-185.8837094	1	1	72.5	8536.066459	36.5	1859.390552	2010.36506	36.5	2010.36506
66	38	59	1	1	1	0	59	59	5855.303158	0.095	20.00378985	0.095	38	72	8352.369873	72.5	8536.066459	1	-183.6965864	0	0	72	8352.369873	37	1915.280274	2094.947946	37	2094.947946
67	39	60	1	1	2	0	60	60	6006.718686	0.0975	20.00401273	0.0975	39	71	8170.856078	72	8352.369873	1	-181.513795	0	0	71	8170.856078	37.5	1972.083716	2181.454469	37.5	2181.454469
68	40	60	0	2	2	0.5	60.5	60.5	6160.252376	0.1	20.00424258	0.1	40	70	7991.520708	71	8170.856078	1	-179.3353698	0	0	70	7991.520708	38	2029.803333	2270.201159	38	2270.201159
69	41	61	1	1	1	0	61	61	6315.909112	0.1025	20.00447942	0.1025	41	69	7814.359362	70	7991.520708	1	-177.1613461	0	0	69	7814.359362	39	2148.000791	2360.583042	39	2360.583042
70	42	62	1	1	1	0	62	62	6473.693729	0.105	20.00472331	0.105	42	68.5	7638.765856	69	7814.359362	1	-175.5935062	1	1	68.5	7638.765856	39.5	2208.483416	2452.909745	39.5	2452.909745
71	43	63	1	1	1	0	63	63	6634.168077	0.1075	20.00497426	0.1075	43	68	7465.946692	68.5	7638.765856	1	-172.8191637	0	0	68	7465.946692	40	2269.891788	2547.188123	40	2547.188123
72	44	64	1	1	1	0	64	64	6796.2302	0.11	20.00523231	0.11	44	67	7295.288114	68	7465.946692	1	-170.6585785	0	0	67	7295.288114	40.5	2332.228238	2643.424931	40.5	2643.424931
73	45	65	1	1	1	0	65	65	6960.434476	0.1125	20.0054975	0.1125	45	66	7126.785571	67	7295.288114	1	-168.5025428	0	0	66	7126.785571	41	2395.495075	2741.626836	41	2741.626836
74	46	66	1	1	1	0	66	66	7126.785571	0.115	20.00576985	0.115	46	65	6960.434476	66	7126.785571	1	-166.3510953	0	0	65	6960.434476	42	2524.829033	2841.800414	42	2841.800414
75	47	67	1	1	1	0	67	67	7295.288114	0.1175	20.00604941	0.1175	47	64	6796.2302	65	6960.434476	1	-164.2042754	0	0	64	6796.2302	42.5	2590.90066	2944.309062	42.5	2944.309062
76	48	68	1	1	2	0	68	68	7465.946692	0.12	20.00633619	0.12	48	63	6634.168077	64	6796.2302	1	-162.0621235	0	0	63	6634.168077	43	2657.911686	3048.452249	43	3048.452249
77	49	68	0	2	2	0.5	68.5	68.5	7638.765856	0.1225	20.00663024	0.1225	49	62	6473.693729	63	6634.168077	1	-160.4743478	0	0	62	6473.693729	43.5	2725.864313	3154.58635	43.5	3154.58635
78	50	69	1	1	1	0	69	69	7814.359362	0.125	20.00693157	0.125	50	61	6315.909112	62	6473.693729	1	-157.7846172	0	0	61	6315.909112	44	2794.760719	3262.717608	44	3262.717608
79	51	70	1	1	1	0	70	70	7991.520708	0.1275	20.00724022	0.1275	51	60.5	6160.252376	61	6315.909112	1	-155.6567353	1	1	60.5	6160.252376	45	2935.393491	3372.852193	45	3372.852193
80	52	71	1	1	1	0	71	71	8170.856078	0.13	20.00755623	0.13	52	60	6006.718686	60.5	6160.252376	1	-153.5336907	0	0	60	6006.718686	45.33333333	2983.114868	3484.996195	45.33333333	3484.996195
81	53	72	1	1	2	0	72	72	8352.369873	0.1325	20.00787961	0.1325	53	59	5855.303158	60	6006.718686	1	-151.4155279	0	0	59	5855.303158	45.66666667	3031.25918	3599.155633	45.66666667	3599.155633
82	54	72	0	2	2	0.5	72.5	72.5	8536.066459	0.135	20.00821039	0.135	54	58	5706.000866	59	5855.303158	1	-149.3022923	1	0	58	5706.000866	46	3079.827047	3715.741983	46	3715.741983
83	55	73	1	1	1	0	73	73	8721.950169	0.1375	20.00854861	0.1375	55	57	5558.806835	58	5706.000866	1	-147.1940302	1	0	57	5558.806835	46.5	3153.474364	3833.957096	46.5	3833.957096
84	56	74	1	1	1	0	74	74	8910.025299	0.14	20.00889429	0.14	56	56	5413.217647	57	5558.806835	1	-145.5891879	1	0	56	5413.217647	47	3228.078133	3954.205304	47	3954.205304
85	57	75	1	1	1	0	75	75	9100.958307	0.1425	20.00924746	0.1425	57	55	5270.232281	56	5413.217647	1	-142.9853663	1	0	55	5270.232281	48	3380.163205	4076.492353	48	4076.492353
86	58	76	1	1	2	0	76	76	9293.436656	0.145	20.00960814	0.145	58	54	5129.33995	55	5270.232281	1	-140.8923314	0	0	54	5129.33995	48.5	3457.648552	4200.823924	48.5	4200.823924
87	59	76	0	2	2	0.5	76.5	76.5	9488.119135	0.1475	20.00997636	0.1475	59	53	4990.535484	54	5129.33995	1	-138.804466	0	0	53	4990.535484	49	3536.098441	4327.205638	49	4327.205638
88	60	77	1	1	1	0	77	77	9685.00991	0.15	20.01035215	0.15	60	52	4853.813662	53	4990.535484	1	-136.721822	0	0	52	4853.813662	50	3695.899754	4455.64305	50	4455.64305
89	61	78	1	1	2	0	78	78	9884.113117	0.1525	20.01073553	0.1525	61	51.5	4719.16921	52	4853.813662	1	-134.6444522	1	1	51.5	4719.16921	51	3859.582795	4586.596799	51	4586.596799
90	62	78	0	2	2	0.5	78.5	78.5	10085.43286	0.155	20.01112652	0.155	62	51	4586.596799	51.5	4719.16921	1	-132.5724107	0	0	51	4586.596799	51.5	3942.884788	4719.16921	51.5	4719.16921
91	63	79	1	1	1	0	79	79	10288.97322	0.1575	20.01152516	0.1575	63	50	4455.64305	51	4586.596799	1	-130.9537484	0	0	50	4455.64305	52	4027.162971	4853.813662	52	4853.813662
92	64	80	1	1	1	0	80	80	10495.45409	0.16	20.01193146	0.16	64	49	4327.205638	50	4455.64305	1	-128.4374129	0	0	49	4327.205638	53	4198.655447	4990.535484	53	4990.535484
93	65	81	1	1	1	0	81	81	10703.45549	0.1625	20.01234545	0.1625	65	48.5	4200.823924	49	4327.205638	1	-126.3817132	1	1	48.5	4200.823924	54	4374.075156	5129.33995	54	5129.33995
94	66	82	1	1	2	0	82	82	10913.68957	0.165	20.01276716	0.165	66	48	4076.492353	48.5	4200.823924	1	-124.3315715	0	0	48	4076.492353	55	4553.436808	5270.232281	55	5270.232281
95	67	82	0	2	2	0.5	82.5	82.5	11126.16029	0.1675	20.01319661	0.1675	67	47	3954.205304	48	4076.492353	1	-122.287049	0	0	47	3954.205304	56	4736.754897	5413.217647	56	5413.217647
96	68	83	1	1	1	0	83	83	11340.87156	0.17	20.01363381	0.17	68	46.5	3833.957096	47	3954.205304	1	-120.248208	1	1	46.5	3833.957096	57	4924.043706	5558.806835	57	5558.806835
97	69	84	1	1	1	0	84	84	11557.82731	0.1725	20.0140788	0.1725	69	46	3715.741983	46.5	3833.957096	1	-118.2151126	0	0	46	3715.741983	58	5115.317317	5706.000866	58	5706.000866
98	70	85	1	1	1	0	85	85	11777.0314	0.175	20.0145316	0.175	70	45.66666667	3599.155633	46	3715.741983	1	-116.5863497	1	1	45.66666667	3599.155633	59	5310.589616	5855.303158	59	5855.303158
99	71	86	1	1	1	0	86	86	11999.25788	0.1775	20.01499222	0.1775	71	45.33333333	3484.996195	45.66666667	3599.155633	1	-114.1594388	1	1	45.33333333	3484.996195	60	5509.874297	6006.718686	60	6006.718686
100	72	87	1	1	1	0	87	87	12222.978	0.18	20.0154607	0.18	72	45	3372.852193	45.33333333	3484.996195	1	-112.144002	0	0	45	3372.852193	60.5	5611.02551	6160.252376	60.5	6160.252376