We plan to construct a simple universal BMI calculator that automatically calculates BMI given weight and height measurements. The calculator can classify weight categories based on patients' BMI and race $($US$/$Europe or Asian population$).$ The calculator allows users to choose to enter numbers in their preferred measurement system, i$.$e$.,$ metric or imperial system, and select the appropriate racial group. give only one input for height and one for weight in either in imperial or metric system and ask for which measurement to select $1$st and then ask for height and weight inputs. Draw a flowchart to summarize the algorithm for the BMI calculator. and build a calculator in excel and explain how it can be done in excel. give step by step process along with data validation?