Solar Irradiation Data Analysis Using Python and SPSS for Rooftop PV Design Based on Energy Import Export to Reduce Household Electricity Bills
Downloads
Solar energy is a promising renewable resource in Indonesia due to the country’s high year-round solar availability. In rooftop photovoltaic systems, solar irradiation is a key factor affecting panel output, particularly on the DC side. This study addresses the limited integration of satellite-based irradiation analysis, technical data processing, statistical modeling, and household electricity consumption in a single framework for rooftop photovoltaic planning. The study aims to analyze the characteristics of solar irradiation in Depok City, estimate the DC output of a 400 Wp monocrystalline module, and simulate the contribution of rooftop photovoltaic systems to reducing grid-imported electricity and household electricity bills. A quantitative approach was applied using hourly NASA POWER data for January 2025 to January 2026 and actual residential electricity bill data from the same period. The irradiation dataset was cleaned and processed using Python, then analyzed in SPSS through descriptive statistics, assumption testing, correlation and simple linear regression. The results indicate that NASA POWER data can provide a reliable basis for estimating rooftop photovoltaic performance and that solar irradiation has a strong relationship with DC output. The simulation further shows that rooftop photovoltaic deployment can significantly reduce electricity imported from the PLN grid and lower household electricity costs under selected capacity scenarios. These findings support the use of integrated data driven methods for rooftop photovoltaic planning in urban residential settings.
Adnyani, N. P., & Suartama, I. M. (2024). Exploring Python programming: A project-based learning approach in higher education. Journal of Education Technology, 8(2), 306–314. https://doi.org/10.23887/jet.v8i2.68694
Amba, M. I., & Dalimi, R. (2023). Economic analysis of hybrid power plant (solar-diesel) on Kawaluso Island, North Sulawesi. Jurnal EECCIS (Electrics, Electronics, Communications, Controls, Informatics, and Systems).
Barus, D. H., & Dalimi, R. (2020). A review of Indonesia grid code adaptation toward variable renewable energy penetration. AIP Conference Proceedings, 2230(1), 050009.
Barus, D. H., & Dalimi, R. (2021). Determining optimal operating reserves toward wind power penetration in Indonesia based on hybrid artificial intelligence. IEEE Access, 9, 165173–165183.
Bayu, H., & Windarta, J. (2021). Tinjauan kebijakan dan regulasi pengembangan PLTS di Indonesia. Jurnal Energi Baru dan Terbarukan, 2(3), 123–132. https://doi.org/10.14710/jebt.2021.10043
Blazev, A. S. (2021). Global energy market trends. River Publishers. https://doi.org/10.1201/9781003152019
Burke, P. J., Widnyana, J., Anjum, Z., Aisbett, E., Resosudarmo, B. P., & Baldwin, K. G. H. (2019). Overcoming barriers to solar and wind energy adoption in two Asian giants: India and Indonesia. Energy Policy, 132, 1216–1228. https://doi.org/10.1016/j.enpol.2019.05.055
Diansyah, I. F. N., Handoko, S., & Windarta, J. (2021). Implementasi dan evaluasi performa pembangkit listrik tenaga surya (PLTS) on grid: Studi kasus SMP N 3 Purwodadi. Transient: Jurnal Ilmiah Teknik Elektro, 10(4), 701–708. https://doi.org/10.14710/transient.v10i4.701-708
Dwisari, V., Sudarti, S., & Yushardi, Y. (2023). Pemanfaatan energi matahari: Masa depan energi terbarukan. OPTIKA: Jurnal Pendidikan Fisika, 7(2), 376–384. https://doi.org/10.37478/optika.v7i2.3322
Dzulkifli, R., Wahyuono, R. A., Suyanto, & Muntini, M. S. (2024). Optimalisasi regulasi PLTS atap di Indonesia: Studi kasus terhadap kendala dan solusi.
Effendi, R. (2023). Analisis penggunaan energi surya fotovoltaik sebagai sumber energi alternatif. Jurnal Teknik Industri Terintegrasi, 6(4), 1298–1302. https://doi.org/10.31004/jutin.v6i4.20634
Fikry, M. R., & Triadi, I. (2024). Evolusi regulasi energi baru terbarukan: Analisis perubahan orientasi aturan PLTS atap. Birokrasi: Jurnal Ilmu Hukum dan Tata Negara, 2(2), 364–373. https://doi.org/10.55606/birokrasi.v2i2.1292
Gunaldi, G., Rahma, I. H. A., & Raharjo, S. E. (2025). Analisis potensi pembangkit listrik tenaga surya (PLTS) atap untuk mendorong net zero emission di kawasan pemukiman.
Kementerian Energi dan Sumber Daya Mineral. (2017). Rencana umum energi nasional (RUEN). Kementerian ESDM.
Kementerian Energi dan Sumber Daya Mineral. (2023). Statistik energi Indonesia 2023. Ditjen EBTKE.
Kurniyanto, F. W., & Setiawan, E. A. (2025). Utilization of advanced metering infrastructure (AMI) data for optimization of load management and dynamic pricing at PLN. Journal Transnational Universal Studies, 3(9), 219–238. https://doi.org/10.58631/jtus.v3i9.178
López, G., Moreno, J. I., Amarís, H., & Salazar, F. (2014). Paving the road toward smart grids through large-scale advanced metering infrastructures. Electric Power Systems Research, 120, 194–205. https://doi.org/10.1016/j.epsr.2014.05.006
Lubis, A. F., Saputra, M. R., & Khotami, R. S. (2025). Hukum dan kebijakan energi terbarukan di Indonesia: Analisis strategi dan implementasi. https://doi.org/10.53866/jimi.v5i2.713
Oktaviansyah, Y., & Makkulau, A. (2023). Penerapan advance metering infrastructure (AMI) di PT PLN (Persero) dalam transformasi sektor energi Indonesia: Tantangan dan prospek masa depan.
Panjidinata, N. A. (2024). Analisis dampak kebijakan pembangkit listrik tenaga surya atap PLN terhadap pengembangan energi terbarukan: Tantangan dalam harmonisasi regulasi investasi energi terbarukan. Commerce Law, 4(2), 488–506. https://doi.org/10.29303/commercelaw.v4i2.5836
Paterakis, N. G., Erdinç, O., & Catalão, J. P. S. (2016). An overview of demand response: Key elements and international experience. Renewable and Sustainable Energy Reviews, 69, 871–891. https://doi.org/10.1016/j.rser.2016.11.167
Pongoh, J., Langie, M., Tuwongkesong, S., Restiawan, W. P., & Tampemawa, J. (2023). PLTS sebagai energi alternatif di Indonesia yang ramah lingkungan. Journal Central Publisher, 1(4), 289–294. https://doi.org/10.60145/jcp.v1i4.87
Purnomo, P., Habibi, M., & MK, I. G. (2026). Penilaian penerapan advanced metering infrastructure pada tahap awal dan keselarasannya dengan roadmap smart grid: Bukti empiris dari Indonesia. Journal of Authentic Research, 5(1), 116–131. https://doi.org/10.36312/ny8yga92
Putra, I., & Manuaba, I. B. G. (2025). Literatur review tantangan dan teknologi dalam pengembangan advance metering infrastructure (AMI). Majalah Ilmiah Teknologi Elektro, 24(1), 1–8. https://doi.org/10.24843/mite.205.v24i01.p01
Rahmanta, M. A., Syamsuddin, A., Tanbar, F., & Damanik, N. (2023). Analisis perkembangan teknologi modul photovoltaic (PV) untuk meningkatkan penetrasi pusat listrik tenaga surya (PLTS) di Indonesia. Jurnal Offshore Oil Production Facilities and Renewable Energy, 7(1), 22–33. https://doi.org/10.30588/jo.v7i1.1509
Raihan, A. (2023). An overview of the energy segment of Indonesia: Present situation, prospects, and forthcoming advancements in renewable energy technology. Journal of Technology Innovations and Energy, 2(3), 37–63. https://doi.org/10.56556/jtie.v2i3.599
Silalahi, D., & Gunawan, D. (2022). Solar energy potentials and opportunity of floating solar PV in Indonesia. Penerbit BRIN. https://doi.org/10.55981/brin.562.c5
Sitopu, J. W., & Purba, I. R. (2021). Pelatihan pengolahan data statistik dengan menggunakan aplikasi SPSS. Development and Sustainable Technology, 3(2), 45–52.
Wayan, I. W., Arnawa, I. W., & Utami, N. P. S. (2022). NASA Power’s: An alternative rainfall data resources for hydrology research and planning activities in Bali Island, Indonesia. Jurnal Inovasi Penelitian dan Edukasi, 3(1), 45–54.
Yasin, M., Apriaskar, E., & Djuniadi, D. (2023). Simulasi monitoring arus, tegangan dan daya panel surya. Emitor: Jurnal Teknik Elektro, 22(2), 87–92. https://doi.org/10.23917/emitor.v22i2.21092
Ye, Y., Qian, Y., Sharif, H., & Tipper, D. (2012). A survey on smart grid communication infrastructures: Motivations, requirements and challenges. IEEE Communications Surveys & Tutorials, 15(1), 5–20. https://doi.org/10.1109/SURV.2012.021312.00034
Yayasan Mitra Hijau. (2021). Pembangunan, operasional dan pemeliharaan PLTS atap: Buku panduan. Yayasan Mitra Hijau.
Copyright (c) 2026 Aprilia Sarah Kristina, Rinaldy Dalimi
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
