How to populate a table after submitting a form

[Originws]

Hello everyone, I have created some apps with appsheets useful to facilitate my work but now I find myself unable to understand how to structure the data so that once a field in a form has been filled in, it populates a table with multiple records each with a formula.

The fields of the form are as follows:

ID (automatically generated)
DATE (the date of the test)
HRMAX (heart rate)
SPEED (speed achieved)

EX:

ID: Auto
DATA : 10-11-2023

HR MAX: 180
SPEED: 15,5

Once the form has been filled out, I would like these table to be populated in this way:

DATA                     RANGE FC       FC MIN       FC MAX
10-11-2023         70-76%              126               137
10-11-2023         76-81%              137               146
10-11-2023         81-88%              146               158
10-11-2023         88-93%              158               167
10-11-2023         93-100%            167              180

The date remains today, the ranges remain the same while FC MIN and FC MAX are calculated in this way (FCMAX =180 * 70/100) while FC MAX (FCMAX * 76/100) and so on taking the first and second as reference RANGE FC value.
Obviously I need to create a history because I might want to generate this table even after 2 months following some tests. I wonder if all this is possible with appsheet and above all how best to organize the data.

Thanks to anyone who will help me.