Development of the luminous intensity experiment tool using Excel spreadsheet to display data

One of the factor that influence the light illuminance is the change of distance. Therefore, a luminous intensity experiment is carried out to study this. However, experiment using lux meter has several disadvantages such as taking a long time, the data is unstable and manually record the data. To overcome this problem, a luminous intensity experiment tool based on microcontroller ATMega 328 has been developed to measure illuminance and distance. The data was automatically recorded in the Excel spreadsheet. The illuminance measured by BH1750 sensor meanwhile the distance between the BH1750 sensor and the light source measured by ultrasonic sensor. Therefore, this experiment tool can reduce manual measurement error and save measurement time. Through the experiment, using linear graph, the effect of distance change on the illuminance can be determined. The illuminance is inversely as the square of the distance. Beside of that, using linear regression, the luminous intensity value can be determined.