My Math Forum

My Math Forum (
-   Algebra (
-   -   Formula from table with operation restrictions #2 (

DynV November 20th, 2018 04:39 AM

1 Attachment(s)
This request is similar to another of mine, but is about another topic. The similarities are that they abide by the same rules and the formula should be applied in the same system. In the following the only difference will be the 3rd column of the table, from my previous request; it may seem trivial, but it's not. Oh! And I removed a paragraph about a meta matter (in which forum to post the request).

I have a mostly automated profile/sheet/information that I'd like to automate even more as it allow custom formulas using limited data and operations.

In the following table, the column (col) 1 is entered (by the profile/sheet/information) then col 2 is automated and I'd like to do so for col 3; currently col 3 is entered and the user is supposed to verify it's correct when col 1 is changed, but it's more than negligibly forgotten so the user doesn't benefit from having a col 3 as high as possible (using the table constraints). If possible, I'd end up with a custom formula to generate col 3, the only information it could have is col 1 & 2 and the only available operations are arithmetic (+, -, x & /) and rounding (round(), floor() & ceil()). There is no need to figure col 2, it's only there if it helps finding the formula for col 3 (with the restrictions of the previous sentence).
I haven't figured out how to enter a table in this forum (BB code for table doesn't seem to work). The following is a TSV, which I imported into a spreadsheet then printed to the attached PDF.

1        2        6
2        2        6
3        2        6
4        2        6
5        3        8
6        3        8
7        3        8
8        3        8
9        4        8
10        4        10
11        4        10
12        4        10
13        5        10
14        5        10
15        5        12
16        5        12
17        6        12
18        6        12
19        6        12
20        6        12

Step by step: In the profile/sheet/information, a user goes row-by-row, hopefully going all the way to the end but might stop along the way, stopping would have nothing to do with the data. The user currently have to enter col 1 & 3 (as they go along, thus row-by-row), in the profile/sheet/information what's related to col 2 is automated and will always reflect what's in the table (whatever is in col 1, it will become col 2 of the corresponding row). As mentioned currently the data in the profile/sheet/information related to col 3 has to be entered manually with the corresponding disadvantages; it will function incorrectly if a user forget to modify it after changing the data corresponding to col 1, or do so incorrectly, it will be less efficient if it's lower than the corresponding row col 3, it will be breaking the rules if it's higher, so it's better if it's lower than higher, but it would be nice to have the exact data. I would like an algorithm to automatically modify the data related to col 3 so there's no chance of a user forgetting to change it after changing col 1; the only operations allowed are in the 4th sentence, italicized.

Thank you kindly for your help.

skipjack November 20th, 2018 10:04 PM

Except for the 20th row, the third column in row n is now 2floor(n/5) + 6. Are you sure you gave all the values in the third column correctly?

DynV November 20th, 2018 10:26 PM


Originally Posted by skipjack (Post 602560)
Are you sure you gave all the values in the third column correctly?

I think so, you could do a search for "D&D 5e Bardic Inspiration"; here's some results:

skipjack November 21st, 2018 01:01 PM

The third column contains "8" and "10" exactly five times, but "12" occurs 6 times. What's the pattern?

DynV November 21st, 2018 03:59 PM


Originally Posted by skipjack (Post 602573)
What's the pattern?

I sadly have no idea. I wish I could provide a hint.

If you had difficulty understanding the list in my last post, for its points the # in "Bardic Inspiration (d[#])" are col 3. (I was going to edit it (my last post) and mention the update here but can't do so.)

skipjack November 21st, 2018 05:35 PM

The formula 2floor(n/5) - 2floor(n/20) + 6 will produce 12 for n = 20. Will you ever need a 21st row?

DynV November 21st, 2018 09:34 PM


Originally Posted by skipjack (Post 602586)
Will you ever need a 21st row?

It's unlikely (very IMO), especially considering the update on dnd 5e - Are characters limited to 20th level in 5e? - Role-playing Games Stack Exchange.

All times are GMT -8. The time now is 10:48 PM.

Copyright © 2019 My Math Forum. All rights reserved.