Solving numerically with Excel?

  • Thread starter Thread starter itedin
  • Start date Start date
  • Tags Tags
    Excel
Click For Summary
The discussion centers on the challenge of numerically solving equations in Excel, specifically the equation exp(-x) - k1*exp(-k2*x) = k3, where k1, k2, and k3 are constants. The user has limited experience with Mathematica and is currently using the FindRoot function, but the process is cumbersome and requires manual input for thousands of iterations. They are seeking alternative solutions to automate this process within Excel, as they do not have access to the Wolfram applet for Excel. A suggested approach is to import the Excel data into MATLAB or R for analysis, which may provide more efficient tools for numerical solutions.
itedin
Messages
2
Reaction score
0
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.

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
 
Last edited:
Computer science news on Phys.org
The general approach I would take would be to import the Excel sheet into a program like MATLAB or R and analyze the data there.
 
Thread 'ChatGPT Examples, Good and Bad'

Thread 'ChatGPT Examples, Good and Bad'

I've been experimenting with ChatGPT. Some results are good, some very very bad. I think examples can help expose the properties of this AI. Maybe you can post some of your favorite examples and tell us what they reveal about the properties of this AI. (I had problems with copy/paste of text and formatting, so I'm posting my examples as screen shots. That is a promising start. :smile: But then I provided values V=1, R1=1, R2=2, R3=3 and asked for the value of I. At first, it said...
View full post »

Similar threads

FindRoot solving of Excel input columns
  • · Replies 3 ·
Replies
3
Views
4K
Automated Air Force Lug Analysis
  • · Replies 5 ·
Replies
5
Views
5K
Excel as Analysis Tool and Homework Aid
  • · Replies 7 ·
Replies
7
Views
8K
4th Order Runge-Kutta method and over/under estimates
  • · Replies 6 ·
Replies
6
Views
3K
Mathematica [Mathematica] How to use for loop to process a list of data
  • · Replies 6 ·
Replies
6
Views
4K
Can someone walk me through solving a PDE numerically?
  • · Replies 12 ·
Replies
12
Views
2K
Need help solving a differential equation numerically
  • · Replies 6 ·
Replies
6
Views
2K
Solving a Double Integral: 0.23 Numerically, Analytically Possible?
  • · Replies 5 ·
Replies
5
Views
2K
Mathematica Numerical solution in Mathematica
  • · Replies 1 ·
Replies
1
Views
5K
Python Solving the heat equation numerically using Python
  • · Replies 4 ·
Replies
4
Views
6K