My quandary... it's related to not being able to evaluate numerically (non-algebraic solutions) with Excel. My Mathematica programming is limited, but I've managed to use Findroot to solve it, but it requires me to manually put in 3#'s, hit enter, then copy paste results back to excel.(adsbygoogle = window.adsbygoogle || []).push({});

However, I'll have to do this serveral thousand times! Lots of data. I really need to automate it... I realize Wolfram sells an applet to plug into Excel, but I don't own it.

Does anybody have any other solutions on how to solve numerically with an excel spreadsheet? I've tried reading Mathematica help to import/process/export... to no avail... I just don't know the language well enough.

By the way, for any curious math folks, equations to be solved are of the form...

exp(-x) - k1*exp(-k2*x) = k3, where k's are constants.

PS - I've created another thread with specific's if anybody well versed with Mathematica is willing to help.

Cheers

**Physics Forums - The Fusion of Science and Community**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Solving numerically with Excel?

Can you offer guidance or do you also need help?

Draft saved
Draft deleted

Loading...

Similar Threads for Solving numerically Excel | Date |
---|---|

Diagonalization of Gigantic Dense Hermitian Matrices | Jun 2, 2017 |

[Solved] Need help figuring out weird formatting in my Outlook e-mail | Nov 23, 2014 |

Consequences of RSA being solved? | Oct 10, 2014 |

TI89 Failing to solve trig system of equation | Feb 5, 2014 |

Solve function for Supernode Circuit Analysis | Oct 9, 2013 |

**Physics Forums - The Fusion of Science and Community**