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

##article.authors##

DOI:

https://doi.org/10.21070/ups.3867

Keywords:

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

Abstract

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.

Downloads

Download data is not yet available.

References

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. https://doi.org/10.21070/jeee-u.v1i2.1171

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). https://doi.org/10.1088/1742-6596/1402/4/044005

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. http://repository.unpas.ac.id/40983/%0Ahttp://repository.unpas.ac.id/40983/1/Ripan 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). https://doi.org/10.21070/pels.v1i2.1026

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. https://doi.org/10.21070/jeeeu.v4i2.539

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). https://doi.org/10.31294/p.v23i1.9861

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

Posted

2024-02-02