My Math Forum  

Go Back   My Math Forum > High School Math Forum > Algebra

Algebra Pre-Algebra and Basic Algebra Math Forum


Reply
 
LinkBack Thread Tools Display Modes
December 28th, 2018, 02:06 PM   #1
Member
 
Joined: Jan 2012
From: Montreal, Canada

Posts: 30
Thanks: 0

Formula from table with operation restrictions #3

This request is similar others 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. The only significant difference will be the 3rd column of the table, from my previous requests; it may seem trivial, but it's not.

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	0
2	2	0
3	2	0
4	2	0
5	3	0
6	3	0
7	3	0
8	3	1
9	4	1
10	4	1
11	4	1
12	4	1
13	5	1
14	5	2
15	5	2
16	5	2
17	6	2
18	6	2
19	6	2
20	6	2
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 (of the 3rd paragraph), italicized.

Thank you kindly for your help.
DynV is offline  
 
May 8th, 2019, 03:46 PM   #2
Member
 
Joined: Jan 2012
From: Montreal, Canada

Posts: 30
Thanks: 0

Bump. It's been > 4 months, I hope it's ok to do one.
DynV is offline  
June 2nd, 2019, 04:10 AM   #3
Member
 
Joined: Jan 2012
From: Montreal, Canada

Posts: 30
Thanks: 0

The answer was provided by another math help resource. I would have made an update to my previous post but I can't seem to edit it.
DynV is offline  
June 2nd, 2019, 04:12 AM   #4
Math Team
 
topsquark's Avatar
 
Joined: May 2013
From: The Astral plane

Posts: 2,267
Thanks: 934

Math Focus: Wibbly wobbly timey-wimey stuff.
Quote:
Originally Posted by DynV View Post
The answer was provided by another math help resource. I would have made an update to my previous post but I can't seem to edit it.
But you can make a new post in the thead with the correction!

-Dan
topsquark is offline  
June 2nd, 2019, 09:20 AM   #5
Newbie
 
Joined: Oct 2017
From: Egypt

Posts: 15
Thanks: 0

Quote:
Originally Posted by topsquark View Post
But you can make a new post in the thead with the correction!

-Dan
when newbies can edit their posts ?

Last edited by yoyo145; June 2nd, 2019 at 09:22 AM.
yoyo145 is offline  
June 2nd, 2019, 09:35 AM   #6
Member
 
Joined: Jan 2012
From: Montreal, Canada

Posts: 30
Thanks: 0

This thread is becoming weird, I've unsubscribed, perhaps some posts can be deleted then locked.
DynV is offline  
June 2nd, 2019, 12:22 PM   #7
Math Team
 
topsquark's Avatar
 
Joined: May 2013
From: The Astral plane

Posts: 2,267
Thanks: 934

Math Focus: Wibbly wobbly timey-wimey stuff.
Quote:
Originally Posted by yoyo145 View Post
when newbies can edit their posts ?
Members can only edit their posts in the first few minutes. (What is it, a half-hour?) After that only the Mods and Ads(!) can edit them.

-Dan
topsquark is offline  
June 2nd, 2019, 12:23 PM   #8
Math Team
 
topsquark's Avatar
 
Joined: May 2013
From: The Astral plane

Posts: 2,267
Thanks: 934

Math Focus: Wibbly wobbly timey-wimey stuff.
Quote:
Originally Posted by DynV View Post
, perhaps some posts can be deleted then locked.
Why?

-Dan
topsquark is offline  
Reply

  My Math Forum > High School Math Forum > Algebra

Tags
formula, operation, restrictions, table



Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula from table with operation restrictions #2 DynV Algebra 6 November 21st, 2018 09:34 PM
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
Permutations of a multiset with restrictions restin84 Applied Math 2 February 4th, 2012 05:20 PM
Simplifying and Restrictions Homework Help! HuskO Calculus 1 December 31st, 1969 04:00 PM





Copyright © 2019 My Math Forum. All rights reserved.