Hi and welcome to Thunkable. You’re asking for something that sounds simple but actually requires a lot of work to set up in Thunkable.
My suggestions would be:
- Do all of that in a spreadsheet such as Google Sheets or Airtable and then just get the necessary values.
- Or if you want to use Thunkable for all of the calculations, write an algorithm for what you’re describing and then ask a specific question about a specific step.
·····················································································································
Need help? How to Ask Great Questions 
Debugging A Project API JSON Tutorial
Want to hire a Certified Thunkable Expert? Elevate your app with Tatiang on Fiverr