Calculating Least Common Multiple (LCM) Using VBA Code in Excel
A VBA macro in Excel calculates the Least Common Multiple (LCM) of a list of input values provided from GoldSim. The LCM is then imported by GoldSim and displayed in a dashboard. For comparison, the LCM is also calculated using a Script element that implements an algorithm very similar to the VBA algorithm.
Excel, VBA, spreadsheets
GoldSim Features & Capabilities, Spreadsheets & Databases
GoldSim Technology Group