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


How To I Do Integration In Excel Xp (calcuating Area Under A Curv.  Excel 
View Answers 
Anyone know how to do integration in Excel XP on nonstandard curves (ones
without an equation)?
without an equation)?
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 ...
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 ...
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 ...
In this tutorial I am going to go through the Format tab in more detail and show you how to Format every element of ...
Automatically Shade Every Other Row When You Add Data in Excel
How to make Excel automatically add row shading to every other row when you add data to the spreadsheet. This does ...
How to make Excel automatically add row shading to every other row when you add data to the spreadsheet. This does ...
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
 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
 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
 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
 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
 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
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(yC)^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!
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(yC)^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(yC)^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!
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(yC)^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
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!
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!
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
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 areaunderthecurve 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.
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.
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 Xaxis and the blood concentraction of substance A on the Yaxis. The Xaxis 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!
I've got a set of data consisting of some curves, displaying time in minutes on the Xaxis and the blood concentraction of substance A on the Yaxis. The Xaxis 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
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
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
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
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 bestfitting 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
I have a series of data for which I want to calculate the bestfitting 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 xaxis and 'cover' on the yaxis 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
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 xaxis and 'cover' on the yaxis 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.
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 parentchild 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!!!
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 parentchild 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
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 = "PinPinFree" 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 = "PinPinFree" 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 = "PinPinFree" 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 = "PinPinFree" 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.
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 = "PinPinFree" 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 = "PinPinFree" 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 = "PinPinFree" 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 = "PinPinFree" 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.
How could i do this? Your help will be appreciated. Thank you.
Good day,
I have created several XY 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 have created several XY 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?
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?