A Case Study on the Analytical Design and Simulation of Palm Nut Cracker Using Customized M236 Machine Design Spreadsheet

To facilitate the analysis of large volumes of data and simplify the analytical design and simulation of machine components with high accuracy, the Customized M236 Machine Design Spreadsheet, powered by Microsoft Excel™, was developed. This study presents a case study on the analytical design and simulation of a palm nut cracker's power requirement and process flow using the M236 spreadsheet. Classical frameworks were provided as guides for potential users to navigate the tool. The analytical design determined the total power required to operate the palm nut cracker, and simulation was later performed using pre-developed models. The results indicate that the Customized M236 Machine Design Spreadsheet is a flexible tool that allows for rapid corrections during analysis and simulation.