Preprint has been published in a journal as an article
Preprint / Version 1

Spreadsheet Based Automatic Print Cost Calculator

Penghitung Biaya Print Otomatis Berbasis Spreadsheet




Google Spreadsheet, ESP32, Implementation of infrared sensors, color sensor tcs3200


Production Cost Calculation Is a Crucial Factor That Impacts Productivity And Profitability In The Printing Industry. This
Study Presents An Automatic Print Costing Tool That Runs On a Spreadsheet And is Intended To Increase Operational
Efficiency And Calculation Accuracy in Small And Medium-Sized Printing Enterprises (SMEs). With The Use Of Esp32
As a Microcontroller, TCS3200 And Infrared Sensors, This Project Seeks To Create An Automated Print Pricing Spreadsheet
That Would Help Printing SMEs Swiftly And Precisely Determine Product Prices. 
To Show The Cost Computation Findings, an Infrared Sensor To Identify The Number Of  Printed Sheets, a TCS3200 Sensor
To Determine Whether or Not Colored Paper Is Present, And a Push Button Feature to Resume The Calculation And Upload
The Entire Cost To The Spreadsheet. This Strategy Should Decrease Calculation Errors
And Increase Manufacturing Cost Management Effectiveness.


Download data is not yet available.


Solih, A., & Jamaaluddin, J. (2017). Rancang Bangun Pengaman Panel Distribusi Tenaga Listrik Di Lippo Plaza Sidoarjo Dari Kebakaran Berbasis Arduino Nano. JEEE-U (Journal of Electrical and Electronic Engineering-UMSIDA), 1(2), 61–68.

Sulistiyowati, I., Findawati, Y., Ayubi, S. K. A., Jamaaluddin, J., & Sulistyanto, M. P. T. (2019). Cigarette detection system in closed rooms based on Internet of Thing (IoT). Journal of Physics: Conference Series, 1402(4).

Suprayitno, E. A., Sulistyowati, I., & Anshory, I. (2015). Rancang Bangun Sistem Instrumentasi Sinyal Carotid Pulse Dalam Analisa Dinamika Jantung Dengan Metode Continuous Wavelet Transform. JTE-U, 1(1), 1–9.

Susanto A, Safari I, & Kusumah H. (2018). Alat penghitung jumlah lembar kertas berbasis internet of things menggunakan infra red pada PT Indah Kiat. Teknologi Informasi Dan Multimedia, 1(2), 1–6.

Suwandahwana, R. (2019). Perancangan Dan Pembuatan Alat Penghitung Jumlah Lembar Kertas Hasil Proses Cetak. Suwandahwana_143030122_Teknik Mesin.pdf

Syahrorini, S., & Kurniawan, H. (2018). Seleksi Benda Berwarna dengan Conveyor Menggunakan Robot Lengan. Universitas Muhammadiyah Sidoarjo, 1–7.

Ulum, M., Anshory, I., Saputra, D. H. R., & Ayuni, S. D. (2021). Arduino Based Multifunction Fan. Procedia of Engineering and Life Science, 1(2).

Wisaksono, A., Purwanti, Y., Ariyanti, N., & Masruchin, M. (2020). Design of Monitoring and Control of Energy Use in Multi-storey Buildings based on IoT. JEEE-U (Journal of Electrical and Electronic Engineering-UMSIDA), 4(2), 128–135.

Wulandari, S., & Satria, B. (2021). Rancang Bangun Alat Pendeteksi Warna Menggunakan Arduino Uno Berbasis IoT (Internet Of Things). Paradigma - Jurnal Komputer Dan Informatika, 23(1).

Zhou, Yang, & Wang. (2020). No 主観的健康感を中心とした在宅高齢者における 健康関連指標に関する共分散構造分析Title. File:///C:/Users/VERA/Downloads/ASKEP_AGREGAT_ANAK_and_REMAJA_PRINT.Docx, 21(1), 1–9