Email:      Pass:    Pass?
Advertisements


Free Excel Forum

How To I Do Integration In Excel Xp (calcuating Area Under A Curv.

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Anyone know how to do integration in Excel XP on non-standard curves (ones
without an equation)?





Similar Excel Video Tutorials

Helpful Excel Macros

Determine if a Cell Contains a Function in Excel - Great for Conditional Formatting and Validation - UDF
- Determine if a cell in Excel contains a formula or function with this UDF (user defined function). This function return
WEEKNUM UDF for Excel Versions That Don't Contain This Function - UDF
- This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week in the year on which a particular
Automatically Run a Macro at a Certain Time - i.e. Run a Macro at 4:30PM every day
- Automatically run an Excel macro at a certain time. This allows you to not have to worry about running a macro every da

Similar Topics







Is there a predefined function availible for integration, rather list the function values and multiply with a dx? Is there anything for multi dimentional functions?

Thanks
F


Hi All,

I use Excel in Novell Groupwise integration. Trying to hide and save
Personal.xls the GW Save macro stops with runtime error 91 at
ActiveWorkbook.Save
line,
the GW Close macro at
If Application.ActiveWindow.WindowNumber = 1 Then
line.
Obviously, the integration macros are not prepared for saving a hidden
workbook. Has anybody heard that this bug has been fixed?
Stefi




I've written an iterative numerical integration Sub which works fine. Several arguments are passed to it (cell references).

I now wish to incorporate Solver in the code process so that it reads the integration result, changes the values of two of the argument cells, after which the integration routine runs again, Solver changes the cells again, etc, until the integral is minimised.

Overall:

1. Initial values are set up as the arguments.

2. The integration routine then iteratively calculates the integral, based on the passed arguments.

3. Solver reads the integration result, then changes two of the argument cells.

4. Steps 2 and 3 repeat until Solver determines the integral result found at step 2 has been minimised.

(The final values of the changing cells (arguments) are then used for other things.)

I am unable to define the structure of the VBA code to achieve this.

I call the integration Sub, then call Solver, but Solver does a single pass only.

How do I get the integration sub and Solver to be repeatedly called, until the minimum integral value is found, after which the result is passed back to a cell, and the code terminates?


Anyone know of a resource for a world map integration into Excel 2007?


Hi, I'm not sure if this goes under General or the Programming area, I apologize in advance if I posted this in the wrong area!

I am trying to find the area of intersection between a circle and an ellipse and I was wondering if there was a way to do it in Excel, such as integration.

I have the equation for both the circle and the ellipse, which look something like this:

Circle x^2 + y^2 = 1

Ellipse Ax^2 + B(y-C)^2 = 1

I have the coefficients A and B, and I have the vertical shift of the Ellipse (C).

Thanks in advance, any help would be appreciated!


Hi, this is my first post on ExcelForum. Not sure if this goes under General or the Programming area, I apologize in advance if I posted this in the wrong area!

I am trying to find the area of intersection between a circle and an ellipse and I was wondering if there was a way to do it in Excel, such as integration.

I have the equation for both the circle and the ellipse, which look something like this:

Circle x^2 + y^2 = 1

Ellipse Ax^2 + B(y-C)^2 = 1

I have the coefficients A and B, and I have the vertical shift of the Ellipse (C).

Thanks in advance, any help would be appreciated!


Dear all,

Does anyone have some (relatively) simple code for calculating the Simpson's Rule for integration?

Many thanks in advance.

Regards,
John


I have seen some great posts about colouring the area between 2 lines but I
need to calculate numerically the area between 2 lines. A close estimate
would do. My curves are smoothed lines but they have many roots to fit a
trendline whose equation I could have integrated. If I use straight lines
between points I have too big an error. Even Simpsons Rule is not accurate
enough at times. Is there a way that Excel can return a figure for the area
under a curve - I could even use the number of pixels it has shaded between
the 2 lines!



Does anyone know a quick way to integrate data in the mathematical sense (can't write the integration symbol on this keyboard!) For example, I want to perform the same very simple calculation 'n' times and sum the result E.g.

Sum((A1*A2)+(B1*B2)+(C1*C2) ... (DG1*DG2)+(DH1*DH2))

I don't have the luxury of an intermediate row to store the result of each multiplication which I can sum at the end and I really don't like the huge and repetitive formula (above) which I am using.

Surely there must be a function to do this but nothing jumps out at me and help wasn't... er... helpful!

Any suggestions appreciated!


I have a list of Charge Accounts to which I assigned numbers(1201, 1202). I
also have summaries to which I assigned letters(ENGR). A lookup table feeds
these to a worksheet template. For some reason, my lookup table provides the
wrong answers for the letters:
ENG Yancy MG1 Engineering
PIS Yancy MG2 Project Integration W/O Legacy
PIL Yancy MG2 Project Integration
ESHQ Houck MG3 ESHQ
PSS Cochran MG4 Project Services W/O Taxes and President
PSL Cochran MG4 Project Services W/O President
PSF Cochran MG4 Project Services
RIO Yancy MG5 Regulatory Integration and Outreach

Input Lookup Lookup Lookup

Lookup=VLOOKUP($A44,$A2:$H43,X)
X=Appropriate Column

This is what my lookups return based on the input(I organized it to the same
table for comparison):
ENG Yancy MG1 Engineering
PIS Houck MG3 ESHQ
PIL Yancy MG2 Project Integration
ESHQ Yancy MG1 Engineering
PSS Cochran MG4 Project Services
PSL Cochran MG4 Project Services W/O President
PSF Houck MG3 ESHQ
RIO Yancy MG5 Regulatory Integration and Outreach


Can anyone explain what's going on or offer a solution?







I am looking to do some sort of integration of Excel and Microsoft Outlook for a project... I'll explain

So on Excel we have a "work request sheet" for 2 different designers and they are getting frustrated by not getting email reminders of due dates and would like emails and reminders daily/weekly of when things are do and what not. They also would like these due dates to appear in their Outlook calenders...

I don't know if this is a stupid question, but obviously I am quite new to this so any helpful responses are greatly appreciated. Thanks so much

From another forum..... http://www.mrexcel.com/forum/showthread.php?t=481013


I'd like to do an area-under-the-curve estimation by integrating available points. How can I do this in Excel? I've attached a table with the function that I'd like to integrate. Thanks in advance for useful advice and imparted wisdom.


Hi all

I prepare a sales file for integration to MSDynamics
I report Sales, Taxes, Tenders, and Cash O/S
All formulas are rounded to 2 decmial places
I review the final worksheet and status bar shows Net 0.00 as expected
I then export to .csv file to load to load for Integration
However, the .csv file sums to 2.96296E-12 or
.00000000000296296

My Accounting and IS people tell me this can not be for integartion and posting to work correctly

What can I do to get the .csv file to perfect 0.00?


I am trying to take a pair of waveforms from an oscilloscope, specifically a voltage waveform and a current waveform, that was acquired from the same source. I want to then multiply the the waveforms together and integrate the resulting product. I want to plot this 'integrated product' waveform obtained from the voltage & current waveforms so that I can see the energy over time.

Is there any way I can do this easily and accurately in Excel? I would have the oscilloscope do it all for me, but the scope I have that can perform this function for me is on the fritz and the one I have now will not support an integration math function.


I'm looking for a method to extract complex math formulas from a string. Range classes have the Formula property, but is simply a variant. I'm not sure how excel is interpretting the equation. I would like to feed in a complex formula and recognize both excel built in functions, and user defined functions. I'd like to be able to feed in differential equations (eventually), integration operators, as well as complex polynomials, logarithmic and power functions, and trigonometric functions. It would also be useful for Simpon's Rule integration. This feature would be used for more complex solvers. Im curious as to how to organize the mathematical operators, variables, coefficients and constants.

Can anyone point me in the right direction? I have a few ideas, but I'd like to see how others have done it. When I do a search, all I can find are string functions and excel worksheet functions.

I know there are other math programs available, such as mathcad, matlab, polymath, etc. The formulas in this case would be for simpler means, and wouldn't need as large of a scope.

I might also note that part of the reason i want to do it myself, rather than using math programs, is for the learning experience.


HELP!
I just wonder if Excel 97 is capable to integrate numerical with given parameters in two rows, e.g. I want to calculate the area (which is the integral) from -let's say- B28 to B270 (which are numbers) within A28 and A270 (both which are dates).
Any ideas resp. any links to an add-in (freeware).
Thanks.
Juergen


Hi
I've a set a data with time in onle column and dta values in the others.
I would like to make a vb function that simultates a mathematical intergration, that is a vb function

Function integration(timerange as range, datarange as range,Result as double)

Code:

That does the following
Looping this while the cells in the rimerange <>"" 
dt=timerange(n+1)-timerange(n)
dV=datarange(n+1)-datarange(n)
Result=Result+dt*dV


Could you help me out with this?


I tried tools, options, color tab and the 'reset' button. But the colors
appear to still be different. The colors seemed to change when I was working
in SAP and using the office integration tool. I was generating reports that
automatically appeared in Excel and I was changing the colors in the report
by simply using the format cells option. Since then, I noticed my color
palette looked a bit different. When I bring the color palette up and
position my mouse over some of the colors, the yellow message box will either
tell me the name of the color, or "color scheme". The boxes with the "color
scheme" message are the ones that look different. I have turned off office
integration in SAP, but the problem persists.



Hi all,

I've got a set of data consisting of some curves, displaying time in minutes on the X-axis and the blood concentraction of substance A on the Y-axis. The X-axis consists of 13 measurements (0, 15, 30,...to 180 minutes). So these curves show the concentration of substance A over a 180 minutes period.
Can anyone please explain how to calculate the area under the curve (AUC) of these curves? Is it possible to do that in Excel?
Thx alot!



Hi Guys,

i hav jus joined this forum. need help!!!!!

I have attached a excel sheet wid this thread

There are 2 sets of data. using scatter plot i found the curve for these 2 sets. i have also found the trend equation for these curves.

I want to find the average of the 2 trend equations

1) y = 147e0.003^x
2)y = 14.14e0.014^x

Ans

y = (14.14e0.014^x+ 147e0.003^x)/2

using excel i want to store
1st equation in A
2nd equation in B
Answer in C

Basically what i want to do is extract the equations from the graphs

If you coud create a macro for this it would be great

Plzzz help... Thanxx


Hi Guys,

i hav jus joined this forum. need help!!!!!

I have attached a excel sheet wid this thread

There are 2 sets of data. using scatter plot i found the curve for these 2 sets. i have also found the trend equation for these curves.

I want to find the average of the 2 trend equations

1) y = 147e0.003^x
2)y = 14.14e0.014^x

Ans

y = (14.14e0.014^x+ 147e0.003^x)/2

using excel i want to store
1st equation in A
2nd equation in B
Answer in C

Basically what i want to do is extract the equations from the graphs

If you coud create a macro for this it would be great

Plzzz help... Thanxx

Dear all,

From experiment, i obtained the force as functions of time as attached in excel sheet.

I've currently been trying to integrate the force in terms of time to have the velocity as function of time, followed by another integration for displacement againt time as seen in example image file.

What i've tried is that after ploting the force time history graph, i could get the equation thru trendline; however, the equation line is pretty off to the actual force line due to complex force lines.

So im wondering if there is other way to integrate such complex graph using Excel.

Thank you for your help in advance.

Regards,
Minki