| Forum Home | ||||
| PC World Chat | ||||
| Thread ID: 135506 | 2013-11-11 20:09:00 | Maths calculation - formula or Excel? | Greg (193) | PC World Chat |
| Post ID | Timestamp | Content | User | ||
| 1359498 | 2013-11-13 19:47:00 | That's cool Dugi.. thanks! | Greg (193) | ||
| 1359499 | 2013-11-13 20:44:00 | No problem, simple compared to using a formula to work out what target port on a new ISAM with 48 port cards will be connected to an existing cabinets POTs lines based on the 30 port POTs systems for example..... actually that's 4 foumlae in 4 columns but the tricky one is =AC12-(48*(INT((AC12-1)/48))) which took me a while to come up with (converts 1-xxx into 1-48, 1-48, 1-48 there's probably a simpler formula). Who'd a thunk High School math had real world applications. With the really hard ones I work it out in pieces then combine the steps into a single formula, sometimes though it's useful to leave the steps in. More realistically though I do the same thing for my own hire purchases, mortgage etc so I can keep a track of it :) |
dugimodo (138) | ||
| 1359500 | 2013-11-14 00:26:00 | Who'd a thunk High School math had real world applications. With the really hard ones I work it out in pieces then combine the steps into a single formula, sometimes though it's useful to leave the steps in. High school math actually has a lot of real world applications. We just don't always realise the uses or implications of algebra or calculus (which I never go up to) when we are 14 and 15 or the teachers don't give students a challenge to put some of the thinking into practice when problem solving. I had to wait till I started getting into interactive web design with JavaScript and jQuery before the concept of a math formula actually started to make sense to me. I did get into a bit of it some years ago when I started learning Macros and stuff in excel. |
Webdevguy (17166) | ||
| 1359501 | 2013-11-14 23:17:00 | No problem, simple compared to using a formula to work out what target port on a new ISAM with 48 port cards will be connected to an existing cabinets POTs lines based on the 30 port POTs systems for example..... actually that's 4 foumlae in 4 columns but the tricky one is =AC12-(48*(INT((AC12-1)/48))) which took me a while to come up with (converts 1-xxx into 1-48, 1-48, 1-48 there's probably a simpler formula). Who'd a thunk High School math had real world applications. Boast boast!!! :lol: :clap As for high school maths... believe this... I failed in my last year, but... got nothing less than A+'s when I studied it in one of my papers in uni - simply because having a slightly more mature mind and having real-life scenarios (ie applied mathematics) to work on gave me the edge. |
Greg (193) | ||
| 1 2 | |||||