Spreadsheet: 474281d1470704800-how-are-the-formulas-connected-in-excel-spreadsheet-calculator
Sheet: Calculation

 | Series |  |  |  |  | CCT | Ra |  |  | CCT&Ra | Color code | Phosphor
 | CLU028-1201C4 |  |  |  |  | 5,000K | 80Min | 1 | C4 | 5000K,70Min | 50AL7 | K3
 | CLU028-1202C4 |  |  |  |  | 4,000K | 80Min | 2 | C4 | 4000K,70Min | 40AL7 | K3
 | CLU028-1203C4 |  |  |  |  | 3,500K | 80Min | 3 | C4 | 3000K,70Min | 30AL7 | K3
 | CLU028-1204C4 |  |  |  |  | 3,000K | 80Min | 4 | C4 | 6500K,80Min | 653M2 | K1
 | [NAME] |  |  |  |  | 2,700K | 80Min | 5 | C4 | 5000K,80Min | 503M2 | K1
 | CLU038-1206C4 |  |  |  |  |  |  | 6 | C4 | 4000K,80Min | 403M2 | K1
 | [NAME] |  |  |  |  |  |  | 7 | C4 | 3500K,80Min | 353M2 | K1
 | CLU038-1210C4 |  |  |  |  |  |  | 8 | C4 | 3000K,80Min | 303M2 | K1
 | CLU048-1212C4 |  |  |  |  |  |  | 9 | C4 | 2700K,80Min | 273M2 | K1
 | CLU048-1812C4 |  |  |  |  |  |  | 10 | C4 | 4000K,90Min On BBL | 403H5 | K2
 | CLU048-1818C4 |  |  |  |  |  |  | 11 | C4 | 3500K,90Min On BBL | 353H5 | K2
 | CLU058-1825C4 |  |  |  |  |  |  | 12 | C4 | 3000K,90Min On BBL | 303H5 | K2
 | CLU058-3618C4 |  |  |  |  |  |  | 13 | C4 | 2700K,90Min On BBL | 273H5 | K2
 |  |  |  |  |  |  |  | 14 | C4 | [NAME] | 353H6 | K2
 |  |  |  |  |  |  |  | 15 | C4 | [NAME] | 303H6 | K2
 |  |  |  |  |  |  |  | 16 | C4 | [NAME] | 273H6 | K2
 |  |  |  |  |  |  |  | 17 | C4 | 4000K,97Typ | 403H7 | K4
 |  |  |  |  |  |  |  | 18 | C4 | 3000K,97Typ | 303H7 | K4
 |  |  |  |  |  |  |  | 19 | C4 | 2700K,97Typ | 273H7 | K4
1 | Luminous flux | If (mA) | Vf (V) | Vf_min (V) | Vf_max (V) | Pd (W) | lm/W | lm
2 | Forward current | φv (lm) | Vf (V) | Vf_min (V) | Vf_max (V) | Pd (W) | lm/W | [NAME]
3 |  | lm | If | Vf | lm/W | Vf | lm/W | W
 |  | [Luminous flux] |  |  |  |  | [Forward current]
 | Limit |  |  |  |  |  |  |  |  |  | 90mA,Tj=85C
 | IF Limit | L/L | U/L |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
 |  | 5 | 230 |  |  |  |  |  | Tc=25C定格Lm係数
 | Tc Limit | U/L | L/L |  |  |  |  |  | 1201 | 0.9020030564861431 | 516 | 507 | 491 | 496 | 487 | 479 | 474 | 465 | 445 | 396 | 392 | 384 | 367 |  |  |  | 360 | 350 | 335
 |  | 105 | -40 |  |  |  |  |  | 1202 | 0.9046904167180263 | 1017 | 1002 | 970 | 978 | 960 | 948 | 937 | 918 | 878 | 782 | 773 | 757 | 726 |  |  |  | 714 | 691 | 662
 | Tj Limit | U/L | L/L |  |  |  |  |  | 1203 | 0.9061293061018011 | 1498 | 1476 | 1428 | 1439 | 1414 | 1394 | 1378 | 1352 | 1294 | 1151 | 1137 | 1117 | 1069 | 1080 | 1061 | 1015 | 1049 | 1019 | 976
 |  | 140 | -25 |  |  |  |  |  | 1204 | 0.9082430027209321 | 1960 | 1932 | 1870 | 1884 | 1850 | 1826 | 1805 | 1770 | 1693 | 1507 | 1490 | 1463 | 1399 |  |  |  | 1375 | 1334 | 1276
 |  |  |  |  |  |  |  |  | 1205 | 0.907970961233569 | 2557 | 2519 | 2439 | 2458 | 2414 | 2380 | 2355 | 2309 | 2209 | 1965 | 1943 | 1907 | 1825 | 1847 | 1811 | 1734 | 1792 | 1740 | 1665
係数 |  | y=ax3+bx2+cx+d/y=ax2+bx+c |  |  |  |  |  |  | 1206 | 0.9096001359429358 | 3038 | 2992 | 2897 | 2919 | 2867 | 2827 | 2798 | 2742 | 2625 | 2333 | 2309 | 2265 | 2168 | 2193 | 2151 | 2059 | 2128 | 2066 | 1978
 |  |  |  |  |  |  |  |  | 1208 | 0.9112219496714173 | 3972 | 3913 | 3788 | 3817 | 3749 | 3697 | 3658 | 3586 | 3431 | 3051 | 3020 | 2962 | 2835 | 2868 | 2814 | 2693 | 2784 | 2702 | 2586
 |  | IF(x)-lm%(y) | lm%(x)-IF(y) | IF(x)-VF%(y) | Tc(x)-lm%(y) | Tc(x)-VF%(y) |  |  | 1210 | 0.9120301049298695 | 4931 | 4844 | 4632 | 4691 | 4654 | 4576 | 4470 | 4384 | 4156 | 3776 | 3690 | 3621 | 3433
 | a | 1.011943107474261e-08 | 0.2110576100613537 | -1.693593188046195e-06 | -1.115215453639155e-08 | 2.736688310261316e-06 |  |  | 1212 | 0.9112219496714173 | 6161 | 6069 | 5877 | 5920 | 5815 | 5734 | 5674 | 5562 | 5321 | 4732 | 4682 | 4594 | 4396 | 4448 | 4365 | 4177 | 4317 | 4191 | 4010
 | b | -1.231471911448764e-05 | 8.637416215095387 | 0.001342071179091917 | -4.129448313651976e-06 | -0.0009461375724285068 |  |  | 1812 | 0.9140424956706719 | 9017 | 8883 | 8601 | 8664 | 8511 | 8392 | 8299 | 8140 | 7787 | 6926 | 6848 | 6724 | 6432 |  |  |  | 6318 | 6135 | 5868
 | c | 0.0121191544465139 | 81.02925639301243 | 0.8929316987049016 | -0.001390668665764221 | 1.021943009096161 |  |  | 1818 | 0.9146439910955716 | 13162 | 12965 | 12552 | 12648 | 12423 | 12249 | 12121 | 11881 | 11367 | 10108 | 10003 | 9815 | 9391
 | d | 0.00164825938761221 | 0.1184816447803888 |  | 1.037521874241428 |  |  |  | 1825 | 0.9190238002026351 | 19274 | 18986 | 18382 | 18520 | 18191 | 17936 | 17748 | 17398 | 16645 | 14803 | 14648 | 14372 | 13750
 |  |  |  |  |  |  |  |  | 3618 | 0.9200116006169339 | 26615 | 26148 | 25313 | 25573 | 25120 | 24703 | 24499 | 23958 | 22882 | 20387 | 20219 | 19791 | 18902
 |  |  |  |  |  |  |  |  |  |  | 90mA,Tc25C
 | IF(x)-lm%(y) | lm%(x)-IF(y) | IF(x)-VF%(y) | Tc(x)-lm%(y) | Tc(x)-VF%(y) |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
a |  |  |  |  |  |  | Series | Parallel |  | VF
b |  |  |  |  |  |  | 12 | 1 |  | 35.87874495285147
c |  |  |  |  |  |  | 12 | 2 |  | 35.8547766673443
d |  |  |  |  |  |  | 12 | 3 |  | 35.84175962165477
 |  |  |  |  |  |  | 12 | 4 |  | 35.82240238790332
 |  |  |  |  |  |  | 12 | 5 |  | 35.82490956518151
 |  |  |  |  |  |  | 12 | 6 |  | 35.80982449366535
 |  |  | lm |  |  |  | 12 | 8 |  | 35.79463876903289
 |  |  |  |  |  |  | 12 | 10 |  | 35.78700824680433
 |  |  | Tc |  |  |  | 12 | 12 |  | 35.79463876903289
 |  |  |  |  |  |  | 18 | 12 |  | 53.65173356086223
 |  |  | lm Tc-compensation |  |  |  | 18 | 18 |  | 53.64305422343207
 |  |  |  |  |  |  | 18 | 25 |  | 53.57876393390847
 |  |  |  |  |  |  | 36 | 18 |  | 107.1279910355653
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.92 | 1.08
 |  |  |  |  |  |  | lm/die |  |  |  | lm% | IF/die | IF/PKG | Vftyp | Vfmin | Vfmax | [NAME] | W |  | lm/W | Rj-c | ⊿T j-c | Tj
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.72
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tc Limit | L/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tc Limit | U/L |  | L/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tj Limit | U/L |  | L/L
 |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Tc Limit | IF Limit |  |  |  | Tj Limit | Tj
 |  |  |  |  |  |  |  | 傾き | 切片 | IF Limit |  |  | U/L |  |  | Judgement | L/L |  | U/L | Judgement | Judgement | Shown
 |  |  |  |  |  |  |  | -9.674922168133927 | 1354.489043232639
 |  |  |  |  |  |  |  | -16.92301892628652 | 2369.222532585223
 |  |  |  |  |  |  |  | -23.77699318850733 | 3328.778874711489
 |  |  |  |  |  |  |  | -28.98971279265289 | 4058.559572447055
 |  |  |  |  |  |  |  | -36.64197224556666 | 5129.875839350303
 |  |  |  |  |  |  |  | -41.20700575482905 | 5768.980490085005
 |  |  |  |  |  |  |  | -51.69049224336649 | 7236.668515365642
 |  |  |  |  |  |  |  | -62.75419196733066 | 8785.586391970926
 |  |  |  |  |  |  |  | -77.53573836504972 | 10855.00277304846
 |  |  |  |  |  |  |  | -70.24701151095886 | 9834.581079946376
 |  |  |  |  |  |  |  | -103.2870863321884 | 14460.19131219866
 |  |  |  |  |  |  |  | -125.2532657532762 | 17535.45671576473
 |  |  |  |  |  |  |  | -87.64862609480981 | 12270.80710628172
 |  |  |  |  |  |  |  |  |  | 90mA,Tc25C
 | IF(x)-lm%(y) | lm%(x)-IF(y) | IF(x)-VF%(y) | Tc(x)-lm%(y) | Tc(x)-VF%(y) |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19
a |  |  |  |  |  |  | Series | Parallel |  | VF
b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA | NA
c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA | NA
d
 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA | NA
 |  |  | Tc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA | NA | NA | NA | NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA | NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA | NA | NA | NA | NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA | NA | NA | NA | NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NA | NA | NA | NA | NA | NA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.92 | 1.08
 |  |  |  |  |  |  | lm/die |  |  |  | IF/die | lm | lm Tc-compensation | Vftyp | Vfmin | Vfmax | [NAME] | W |  | lm/W | Rj-c | ⊿T j-c | Tj
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF Limit | L/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tc Limit | U/L |  | L/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tj Limit | U/L |  | L/L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tc Limit | IF Limit |  |  |  | Tj Limit | Tj | NA
 |  |  |  |  |  |  |  |  |  | IF Limit |  |  | U/L |  |  | Judgement | L/L |  | U/L | Judgement | Judgement | Shown | lumen