Close Window   
Free Ebook
Got an Excel Question?
Ask it in our Excel forum!
TeachExcel.com
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



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




View Answers     

Similar Excel Tutorials

Make a Transparent Chart in Excel
How to make a Chart transparent so that it blends in with its background and surroundings in Excel. Hover your mous ...
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 ...
Add Image Background to a Chart in Excel
How to use an image for the background of a chart in Excel. Simple but fun way to spruce up charts. Click the desi ...
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 ...

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


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


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


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


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?

Thanks in advance


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


Hi,

On Excel charts we can shade between curves and axis; how can we shade the area between 2 data curves.


hi everyone.

here's what i want my end result to look like (think hundreds, thousands of line longer):

Column A:
1.4
1.4.1
1.4.1.1
1.4.1.2
1.4.1.3
1.4.2
1.4.2.1
1.4.2.2
1.4.2.3
1.4.2.3.1
1.4.2.4

Column B:
GROUND SYSTEM
Data Comm System Integrator
Program Management
System Engineering
Integration and Test
En Route Contractor
Program Management
System Engineering
Integration and Test
En Route Display System
Implementation


ETC

what i have is thousands of lines (indented to represent parent-child relationships for Column B....what i want is to automate Column A so that I don't have to phyiscally type in AND indent thousands of numbers.

I want to be able to type something into column B and for Column A to automatcially number it BASED on the indentation in column B AND it's order in the spreadsheet.

Also, note that the level (e.g. 1.1.1.1.1.1.1 a.ka. number of decimals ranges from 1 to 15)

can anyone help me please??

i would greatly appreciate it.

Thanks!!!


All,


I want to know whether the integration of Excel & Silverlight is possible.


Basically, the data would be in an excel spreadsheet & the output would
be a Silverlight object (in the same excel workbook).

Can you please share some sample Excel Workbooks that applies the same methodology.

- ansul


When I insert the function pv() it returns an errorr message "You've entered too many arguments for this function." But I haven't called out too many arguments. Even worse is that I can call out functions pm(), pq() or pd() which are all similar but work! Here is the code for these functions:

Option Explicit

Public support As String, length As Double, gamma As Double, x As Double, P As Double, phi As Double, xg As Double, xf As Double, fg As Double, gf As Double, Cp_0 As Double, Cp_1 As Double, Cp_2 As Double, Cp_3 As Double, Cp_4 As Double

Function pv(support, length, gamma, P, phi, x)
'Step Function Variables
xg = 0: xf = 0: gf = 0: fg = 0
If x > gamma Then
xg = 1
End If
If x > phi Then
xf = 1
End If
If gamma > phi Then
gf = gamma - phi
End If
If phi > gamma Then
fg = phi - gamma
End If
'Set Constants Of Integration
Cp_0 = 0: Cp_1 = 0: Cp_2 = 0
If support = "Pin-Pin-Free" Then
Cp_0 = (gf - fg - gamma) / gamma
Cp_1 = -1 - Cp_0
End If
'Calculate Shear
pv = -P * (xf + Cp_0 * xg + Cp_1)
End Function

Function pm(support, length, gamma, P, phi, x)
'Step Function Variables
xg = 0: xf = 0: gf = 0: fg = 0
If x > gamma Then
xg = x - gamma
End If
If x > phi Then
xf = x - phi
End If
If gamma > phi Then
gf = gamma - phi
End If
If phi > gamma Then
fg = phi - gamma
End If
'Set Constants Of Integration
Cp_0 = 0: Cp_1 = 0: Cp_2 = 0
If support = "Pin-Pin-Free" Then
Cp_0 = (gf - fg - gamma) / gamma
Cp_1 = -1 - Cp_0
End If
'Calculate Moment
pm = -P * (xf + Cp_0 * xg + Cp_1 * x + Cp_2)
End Function

Function pq(E, I, support, length, gamma, P, phi, x)
'Step Function Variables
xg = 0: xf = 0: gf = 0: fg = 0
If x > gamma Then
xg = x - gamma
End If
If x > phi Then
xf = x - phi
End If
If gamma > phi Then
gf = gamma - phi
End If
If phi > gamma Then
fg = phi - gamma
End If
'Set Constants Of Integration
Cp_0 = 0: Cp_1 = 0: Cp_2 = 0: Cp_3 = 0
If support = "Pin-Pin-Free" Then
Cp_0 = (gf - fg - gamma) / gamma
Cp_1 = -1 - Cp_0
Cp_3 = -(gf ^ 3 + Cp_1 * gamma ^ 3) / 6 / gamma
End If
'Calculate Slope
pq = -P / E / I * ((xf ^ 2 + Cp_0 * xg ^ 2 + Cp_1 * x ^ 2) / 2 + Cp_2 * x + Cp_3)
End Function

Function pd(E, I, support, length, gamma, P, phi, x)
'Step Function Variables
xg = 0: xf = 0: gf = 0: fg = 0
If x > gamma Then
xg = x - gamma
End If
If x > phi Then
xf = x - phi
End If
If gamma > phi Then
gf = gamma - phi
End If
If phi > gamma Then
fg = phi - gamma
End If
'Set Constants Of Integration
Cp_0 = 0: Cp_1 = 0: Cp_2 = 0: Cp_3 = 0: Cp_4 = 0
If support = "Pin-Pin-Free" Then
Cp_0 = (gf - fg - gamma) / gamma
Cp_1 = -1 - Cp_0
Cp_3 = -(gf ^ 3 + Cp_1 * gamma ^ 3) / 6 / gamma
End If
'Calculate Deflection
pd = -P / E / I * ((xf ^ 3 + Cp_0 * xg ^ 3 + Cp_1 * x ^ 3) / 6 + Cp_2 * x ^ 2 / 2 + Cp_3 * x + Cp_4)
End Function

Any ideas?

Thanks in advance.


I have XY plot. I have plotted two curves in XY plot..and i am doing comparison. I want to shade the are between these two curves.

How could i do this? Your help will be appreciated. Thank you.


Good day,

I have created several X-Y Scatter Charts in excel. My boss wants me to "link" pairs of points with Curves (not lines as in "Line with Marker").

I have done this with "View - Toolbars - Drawing" and then "Autoshapes - Lines - Curves." The problem is that when I go to print the graphs (not as part of the sheet but by themselves), not all the curves print.

I have tried bringing them to the front but that doesn't work. Is there a better way to do this? If not, how do I make the curves stay there?

Thanks,
Michael


I use Excel extensively for performance analysis and have a fairly complex
integration of different spreadsheets in different workbooks. I have found
that there is a physical limitation to the number of cells that I can use in
any one spreadsheet (seems to be about 67,010). Does anyone know how this
limitation can either be removed or increased?