Email:      Pass:    Pass?

E-mail:

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

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

## Similar Excel Tutorials

Print Only Specific Parts of a Worksheet in Excel
In Excel you can select parts of a worksheet to print while ignoring all of the other data on the worksheet. This a ...
Format Any Element of a Chart in Excel
In this tutorial I am going to go through the Format tab in more detail and show you how to Format every element of ...
Prevent Charts from Printing in Excel
This is how you prevent a chart from appearing when you print from Excel. This is a great feature when you want to ...

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
Vlookup Macro to Return All Matching Results from a Sheet in Excel
- This Excel Macro works like a better Vlookup function because it returns ALL of the matching results. Run the
Excel Macro that Searches Entire Workbook and Returns All Matches
- This is the ultimate Lookup Macro for Excel. It will search every worksheet in the workbook and return all of the mat

## 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

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?

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?

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
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

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.

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

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

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.

Regards,
Minki

Hi Guys

Is there any way to set up excel to communicate with SAP,
I need to use to post a large amount of Data on to SAP with one click?

Hope someone could help how to go about it

many thanks

Benjamin

I'm a brand new programmer in VBA, although I have a background in mathematics and programming (Intel assembler, Fortran, Pascal, BASIC).

I'm trying to write a VBA program to do the following, and seek your high level advice on how I should go about it - the methods and paths used to achieve it. I understand that custom VBA functions cannot change cell values, and this is where I'm having problems identifying the solution path.

Here's the description:

I have an algebraic function in a cell (A1), consisting of cell references holding data used by the function. For example, A1: =3*C5^3 + 4*C5^2 + D9*D10, where C5 holds the 'X' ('x' the unknown) value used by the algebraic function, while D9 and D10 hold other variables in the function.

I wish to integrate this algebraic function by a VBA numerical integrator (which I have already written and is working fine, but currently written as a custom function so it returns its result back to its cell). The function is passed arguments of (1) the cell holding the X value used by the algebraic function (C5), (2) the lower integration limit cell, (3) the upper limit cell, and (4) a relative tolerance cell for use by the exit criteria code of the integrator. As mentioned, I have done this successfully.

Using the two limits passed to it, the integration routine firstly calculates its initial X value. This value is then to be fed back to the cell used by the algebraic function for holding the X value (C5). Once the new X value has been stored into cell C5, the algebraic function (in A1) recalculates, and the new A1 value, f(X), is then to be passed back to the integration routine again, for its actioning, after which the next X value is calculated and then passed back to cell C5, etc, etc, etc.

So functionally, the algebraic function value in cell A1 is to be fed to the VBA integrator, which I have done, and then the next X value calculated by the integrator is to be fed back to the X value cell (C5) for use by the algebraic function. This I have not been able to do.

Eventually the integrator result converges, after which the integration function exits with the integration result in its cell (or another cell if necessary).

I'd appreciate your overall guidance on how I tackle this problem. I'm unsure how to make the best use of Function or Sub options here, and how to put the X value calculated by the integrator back into cell C5 for use by the algebraic function.

I have read numerous Excel books and VBA programming books, but cannot nail a pathway to do the things above.

I'm not seeking code, simply direction. Of course, ANY code or code ideas will still be gratefully accepted! Perhaps there are techniques I could use which lie in other locations on the forum, or elsewhere, perhaps in the guise of programs written for other purposes.

Could anyone offer advice on how I should best solve this problem.

(A new VBA programmer!)

I have a chart with established 4 curves in a standard X and Y graph in an excel worksheet.

I am putting together a program that will allow the user to input an X and Y coordinate - the program will identify one or more of the 4 curves if the X and Y points correlate with one of the existing curves or will display the closest curve along with the modified coordinates to fit the curve.

Is there built-in function with Excel to perform this? Any help would be appreciated.

Hello all,

I have a series of data for which I want to calculate the best-fitting tendency curve.

So I plot data on a graph and select "Display tendency curves", type="Power" and "Display equation" However, if I plot the displayed equation, all the results are significant lower for every case.

How can I get to know the really best fitting equation?

Hi all,

Hope you can help. I am not certain how much of this qualifies as maths and how much qualifies as excel here! But I know certain things I can do on excel I just don't know where.

I have some data and have plotted it on a graph (workbook attached). There are two lines and I am comparing the two, the one above is the better - I have 'ratings' on the x-axis and 'cover' on the y-axis and the top one gets consistently get's better coverage at the same level of ratings - which is what we want.

To compare how much better the one on top is over all the ratings I wanted to find the area underneath each of the curves and then subtract one from the other. This will leave me with the difference in area. But this leaves me with two questions:

1. How do I find the area beneath each of the curves? I believe excel can help with this?

2. What would the unit be? If I calculate the area of a field I have metres on one side (y axis) and metres on the other side (x axis) and hence I have metres squared by multiplying them together. The area would be x....

Hope you can help, I am stuck!

Thanks