Multi-field/row formula help

[yovindapricila]

Hi everyone, 

I'm trying to transform this original table: 

Weight	Rate 1	Rate 2
1	10	12
1.5	15	19.5
2	20	27

and transform it into smaller fraction:

Weight	Rate 1	Rate 2
1	10	12
1.1	11	13.5
1.2	12	15
1.3	13	16.5
1.4	14	18
1.5	15	19.5
1.6	16	21

Is it something that I can achieve by using Multi Field/Row formula? 

Thanks!!

[echuong1]

Can you explain your logic for how you went from the first table to the second? Is it just adding 0.1 to the weight, adding 1 to the rate1, and 1.5 to rate2 with each subsequent row?

If so, you can use a generate rows to create the additional rows. From there, you can use multi-row formulas to calculate the rates.

[afv2688]

Hello @yovindapricila ,

I created something, don't know if its what you are looking for. Based on the number of rows you want to have it creates a regluar increment on the columns.

Regards

[yovindapricila]

Hi Echuong. Thank you for your reply.

I have 45 rates column that I need to fill out. Is there any simpler solution rather than using 45 multi row formula tools?

[echuong1]

Is the logic for all 45 different for each one? Are you able to elaborate more on what these are? Can you post a sample?

[yovindapricila]

The increment per 0.5kg is not proportional to the rates. Here's an example: 

Weight	Rate 1	Rate 2	Rate 3
1.0	7.39	10.74	7.65
1.5	7.95	11.07	8.26
2.0	8.27	11.83	8.69

so rate1 at 1.1kg would be 7.39 + [(7.95 - 7.38) / 5] = 7.39 + 0.114 = 7.50

rate1 at 1.2kg= 7.50 + 0.114 = 7.614 

rate1 at 1.3kg= 7.61 + 0.114 = 7.724 and so on.