Jurnal Dunia Kesmas
Vol 13, No 2 (2024): Volume 13 Nomor 2

Pengembangan Manajemen Menu Gizi Diet Kesehatan Berbasis VBA (Visual Basic For Aplications) Macro Excel

Effendy, Ibrahim Rully (Unknown)
Prihandini, Yustin Ari (Unknown)



Article Info

Publish Date
09 Aug 2024

Abstract

Public health has become a primary concern in the era of globalization and modernization. However, food consumption surveys in Indonesia indicate low consumption of fatty foods and fruits. Therefore, it is crucial to maintain a balanced diet. Despite offering healthy menus, GoodMeal Catering still relies on manual calculations. This research aims to integrate Visual Basic for Applications (VBA) into Microsoft Excel for designing daily diet menus. This method can assist individuals in planning menus that align with their nutritional needs. Data from the Indonesian Food Composition Table (TKPI) 2020 are used as a database to automatically fulfill macro and micro-nutritional requirements based on the composition of input food items. The result is an application that simplifies menu planning and efficient monitoring of nutrient intake for users. The integrity of TKPI data and collaboration with the Indonesian Ministry of Health provide a robust foundation in nutritional science for designing personalized diets that support health and prevent various diseases

Copyrights © 2024






Journal Info

Abbrev

duniakesmas

Publisher

Subject

Environmental Science Public Health

Description

Jurnal Dunia Kesmas was published by the Faculty of Public Health, Malahayati University with a professional organization of Persatuan Dosen Kesehatan Masyarakat (PDKM). This journal contains articles from research, critical analytical studies in the field of public health (Epidemiology, ...