Advanced Search

Question: Problem of solving lots of cubic functions with maple

Question:Problem of solving lots of cubic functions with maple

dracodoc 12 Maple
complex
April 03 2007
0
Hi, I have a task and I haven't found a good way to work with it. I need to solve cubic functions like this a*x^3+b*x^2+c*x+d=0, where a,b,c,d are calculated from other data by excel, thus can be changed if I changed other parameters. So I have to solve every cubic function defined by these {a,b,c,d} data. And the nature of the experiment need only positive rational root. First I tried to use maple addin for excel. The problem is, it seemed that maple addin doesn't support multiple parameters for expression. For example, it's ok to use =maple("&1*2",A1), but I can't use =maple("solve(&1*x^3+&2*x^2+&3*x+&4,x)",A2:D2). Is it possible to calculate an expression from multiple cell data? Second, I export {a,b,c,d} from excel to csv, then import them into maple spreadsheet. I can solve them in the spreadsheet, but the problem is, sometimes there are complex root, sometimes there are negative rational root, and I only need positive rational root. I tried use fsolve instead of solve to get away complex root, but I can't pick positive root by maple. I think if I can export these roots to file, then I can pick positive value by a little python script, but the problem is, when the spreadsheet was exported, only the first root was exported! Can anybody help me on this problem? Thank you!
Please Wait...