
Algebra PreAlgebra and Basic Algebra Math Forum 
 LinkBack  Thread Tools  Display Modes 
November 20th, 2018, 04:39 AM  #1 
Member Joined: Jan 2012 From: Montreal, Canada Posts: 30 Thanks: 0 
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. Code: 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 Thank you kindly for your help. Last edited by skipjack; November 20th, 2018 at 09:34 PM. 
November 20th, 2018, 10:04 PM  #2 
Global Moderator Joined: Dec 2006 Posts: 20,747 Thanks: 2133 
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?

November 20th, 2018, 10:26 PM  #3  
Member Joined: Jan 2012 From: Montreal, Canada Posts: 30 Thanks: 0  Quote:
 
November 21st, 2018, 01:01 PM  #4 
Global Moderator Joined: Dec 2006 Posts: 20,747 Thanks: 2133 
The third column contains "8" and "10" exactly five times, but "12" occurs 6 times. What's the pattern?

November 21st, 2018, 03:59 PM  #5 
Member Joined: Jan 2012 From: Montreal, Canada Posts: 30 Thanks: 0  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.) 
November 21st, 2018, 05:35 PM  #6 
Global Moderator Joined: Dec 2006 Posts: 20,747 Thanks: 2133 
The formula 2floor(n/5)  2floor(n/20) + 6 will produce 12 for n = 20. Will you ever need a 21st row?

November 21st, 2018, 09:34 PM  #7 
Member Joined: Jan 2012 From: Montreal, Canada Posts: 30 Thanks: 0  It's unlikely (very IMO), especially considering the update on dnd 5e  Are characters limited to 20th level in 5e?  Roleplaying Games Stack Exchange.


Tags 
formula, operation, restrictions, table 
Thread Tools  
Display Modes  

Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Formula from table with operation restrictions  DynV  Algebra  5  October 23rd, 2018 07:36 AM 
Make my long table viewable help with table alignment  vs140580  LaTex Help  1  February 25th, 2017 07:53 PM 
Simplifying and Restrictions Homework Help!  HuskO  Algebra  1  July 27th, 2013 09:17 AM 
Do you find the restrictions before or after simplifying?  davedave  Algebra  3  November 7th, 2012 04:56 AM 
Permutations of a multiset with restrictions  restin84  Applied Math  2  February 4th, 2012 05:20 PM 