I am very new to Appsheet and feeling my way to see whether it will be fit for purpose.
I am collaborating with a friend who is an Ag Nutrition consultant who has some complex EXCEL spreadsheets that calculate Nutritional and financial benefits for particular diets\supplements for cattle etc. He wanted to make a App available for his customers so they can explore and track various diets and their calculated benefits.
There are a few user user inputs but most calculations coming from use of VLookups of other Raw data relating to diet components ant the spreadsheet doing the heavy lifting.
I would like to ensure that the App will behave as expected but I have read to minimise calculations etc to ensure fast syncing of data to the source. We would like graphs and dashboard available to highlight the diet performance etc
My question is what is the best way to structure my App for performance, while maintaining the desired outcomes ?