#### Can I get Excel to determine the line curve formula without graph.

```I am trying to otain a solution for the number where two curves meet.
Specifically trying to determine the expected flow rate given a pump curve
and system curve. The curves shift depending on variables that are read from
a spreadsheet. I can get the curve formulas by graphing them and requesting
the trendline feature, but then I have to manually enter the curve formulas,
set them equal to each other, and solve the equation. Can Excel do this
automatically from two data sets? Any help would be appreciated.
```
 0
12/15/2005 9:56:02 PM
excel.misc 78881 articles. 5 followers.

8 Replies
884 Views

Similar Articles

[PageSpeed] 2

```Hi,

What kind curves are they (i.e., what kind of functions are those trendline
equations) - linear, polynomial, logarithmic, ....? Can you post sample
trendline equations for the pump curve and the system curve?

Regards,
B. R. Ramachandran

> I am trying to otain a solution for the number where two curves meet.
> Specifically trying to determine the expected flow rate given a pump curve
> and system curve. The curves shift depending on variables that are read from
> a spreadsheet. I can get the curve formulas by graphing them and requesting
> the trendline feature, but then I have to manually enter the curve formulas,
> set them equal to each other, and solve the equation. Can Excel do this
> automatically from two data sets? Any help would be appreciated.
```
 0
12/15/2005 11:34:02 PM
```B. R.Ramachandran wrote...
>What kind curves are they (i.e., what kind of functions are those trendline
>equations) - linear, polynomial, logarithmic, ....? Can you post sample
>trendline equations for the pump curve and the system curve?
....

It doesn't matter what kind of curves they are if they're both
functions of a single, common variable (otherwise they couldn't be
graphed together easily). All that's needed is one cell containing the
common X value, one cell for each curve containing the f(x) and g(x)
function values given the common X value and their other respective
parameters, and finally another formula cell calculating the difference
between the two function values. Then use Solver to set that last cell
to zero by changing the X value cell. If the two curve intersect
transversally, Solver shouldn't have any difficulty finding the
intersection point's X value, and both functions will return the same Y
value.

If the two curve intersect nontransversally, e.g., two circles
intersecting at a single point, then Solver might have some difficulty
and the OP would need to play with its options.

>>I am trying to otain a solution for the number where two curves meet.
>>Specifically trying to determine the expected flow rate given a pump curve
>>and system curve. The curves shift depending on variables that are read from
>>a spreadsheet. I can get the curve formulas by graphing them and requesting
>>the trendline feature, but then I have to manually enter the curve formulas,
>>set them equal to each other, and solve the equation. Can Excel do this
>>automatically from two data sets? Any help would be appreciated.

```
 0
hrlngrv (1990)
12/16/2005 12:51:43 AM
```Hi,

Of course "Solver" wouldn't have any difficulty in finding the x- and
y- values of the intersection point of f(x) and g(x) (by making the
difference between the functions equal zero).  However, please note that the
solver solution is a one-time result, and doesn't automatically update when
f(x) and g(x) change; so your have to manually invoke Solver every time the
functions change (I know it is not a big deal, but is certainly an
inconvenience).

The OP did mention, "The curves shift depending on variables that are
read from a spreadsheet........... I can get the curve formulas by graphing
them and requesting the trendline feature, but then I have to manually enter
the curve formulas, set them equal to each other, and solve the equation. Can
Excel do this
automatically from two data sets?".

My purpose of asking the OP for the functional forms of f(x) and g(x)
was that, if both are linear, logarithmic, simple exponential, quadratic, or
power functions (and not higher order polynomials), then the x-value (and
from it, the y-value) of the intersection point can be obtained using
analytical formulas.  Since those formulas will reference the cells
containing the parameters/constants of f(x) and g(x), the solutions will
automatically (and conveniently) update when f(x) and g(x) change.

If f(x) and g(x) are higher-order polynomials or if they are of
different functional forms, analytical solutions may be difficult/impossible
to obtain, and "Solver" is the only recourse.

Regards,
B. R. Ramachandran

"Harlan Grove" wrote:

> B. R.Ramachandran wrote...
> >What kind curves are they (i.e., what kind of functions are those trendline
> >equations) - linear, polynomial, logarithmic, ....? Can you post sample
> >trendline equations for the pump curve and the system curve?
> ....
>
> It doesn't matter what kind of curves they are if they're both
> functions of a single, common variable (otherwise they couldn't be
> graphed together easily). All that's needed is one cell containing the
> common X value, one cell for each curve containing the f(x) and g(x)
> function values given the common X value and their other respective
> parameters, and finally another formula cell calculating the difference
> between the two function values. Then use Solver to set that last cell
> to zero by changing the X value cell. If the two curve intersect
> transversally, Solver shouldn't have any difficulty finding the
> intersection point's X value, and both functions will return the same Y
> value.
>
> If the two curve intersect nontransversally, e.g., two circles
> intersecting at a single point, then Solver might have some difficulty
> and the OP would need to play with its options.
>
> >>I am trying to otain a solution for the number where two curves meet.
> >>Specifically trying to determine the expected flow rate given a pump curve
> >>and system curve. The curves shift depending on variables that are read from
> >>a spreadsheet. I can get the curve formulas by graphing them and requesting
> >>the trendline feature, but then I have to manually enter the curve formulas,
> >>set them equal to each other, and solve the equation. Can Excel do this
> >>automatically from two data sets? Any help would be appreciated.
>
>
```
 0
12/16/2005 3:56:01 AM
```"B. R.Ramachandran" <BRRamachandran@discussions.microsoft.com> wrote...
....
>My purpose of asking the OP for the functional forms of f(x) and g(x)
>was that, if both are linear, logarithmic, simple exponential, quadratic,
>or
>power functions (and not higher order polynomials), then the x-value (and
>from it, the y-value) of the intersection point can be obtained using
>analytical formulas.  Since those formulas will reference the cells
>containing the parameters/constants of f(x) and g(x), the solutions will
>automatically (and conveniently) update when f(x) and g(x) change.
....

If the OP's functions are simple low order polynomials, logarithmic or
exponential functions to begin with, it'd be inefficient for the OP to be
fitting trend lines. And the trend lines aren't necessarily good
approximations for the underlying functions near the point of intersection.
Solver is a manual solution (unless the OP were to use a Calculate event
handler to run Solver whenever the function parameters change upon any
recalc), but it's likely to be more accurate than finding the intersection
point of trend line approximations to the underlying functions.

```
 0
hrlngrv (1990)
12/16/2005 5:33:17 AM
```Hi,

The question, as I understood from the OP's posting, is not how to obtain
f(x) and g(x) for two sets of real-life data; the OP says "I can get the
curve formulas by graphing them and requesting the trendline feature,...".
(Incidentally, the functions have got to be one of the types that the
Trendline tool can handle, which are linear, exponential, logarithmic,
polynomial, ...).  The OP's question, on the other hand, was how to find the
intersection point of f(x) and g(x).

As I did mention in my earlier response, I do agree that Solver can
certainly find the intersection point.  However, my point is, if the solution
for x when f(x)=g(x) can be expressed as an explicit analytical function
(which is possible if both functions are linear, quadratic, simple
exponential, logarithmic, or power functions, and not higher order
polynomials), calculating the intersection point using such an analytical
solution is certainly superior to finding an 'optimized' solution using
Solver.  Any optimization method, including Solver, is limited by the
optimization criteria (algarithm used, convergence criterion, decimal
tolerance, .....), and also on the initial values of the optimization
parameters (in this case x-value of the intersection point).  Of course, for
simple functions such as the ones considered here, the Solver-result may be
as good as the analytical solution, but the analytical solution is absolute.
solutions update when the functions change (As you correctly pointed out, the
same can be accomplished by using Calculate Event Handler to run Solver).

A couple of questions about your remarks.  My apologies if I haven't
understood those remarks correctly.

"If the OP's functions are simple low order polynomials, logarithmic or
exponential functions to begin with, it'd be inefficient for the OP to be
fitting trend lines."  But, aren't those the only function-types that
Trendline handles (besides moving-averages)?  What type of functions would
lend themselves to be efficient to be fit with trendlines?  And, when the
functions do belong to those simple types, how would you efficiently fit them
to real data without using Trendline (or Solver for that matter)?

"And the trend lines aren't necessarily good approximations for the
underlying functions near the point of intersection. Solver is ........
likely to be more accurate than finding the intersection point of trend line
approximations to the underlying functions."
f(x) and g(x) are two functions that happen to intersect at some x,y-point
when somebody plots them out on a common graph; crudely put, the functions
don't even know the existence of each other (If the two functions are
coupled/correlated it is a totally different story).  Any uncertainty in
finding the intersection point of f(x) and g(x) depends on the quality of how
well each function fits its respective x,y-data and how those uncertainties
add up near the intersection point.  Calculating the intersection point using
the analytical solution can not diminish the inherent uncertainty in the
intersection point, but it would certainly not worsen it; on the other hand,
an optimaztion method such as Solver could, in certain situations, add some
extra uncertainty to the solution due to inherent limitations of the method.
But then, when explicit analytical solutions are not possible for a sytem of
equations, one has to resort to optimization methods.

Regards,
B. R. Ramachandran

"Harlan Grove" wrote:

> "B. R.Ramachandran" <BRRamachandran@discussions.microsoft.com> wrote...
> ....
> >My purpose of asking the OP for the functional forms of f(x) and g(x)
> >was that, if both are linear, logarithmic, simple exponential, quadratic,
> >or
> >power functions (and not higher order polynomials), then the x-value (and
> >from it, the y-value) of the intersection point can be obtained using
> >analytical formulas.  Since those formulas will reference the cells
> >containing the parameters/constants of f(x) and g(x), the solutions will
> >automatically (and conveniently) update when f(x) and g(x) change.
> ....
>
> If the OP's functions are simple low order polynomials, logarithmic or
> exponential functions to begin with, it'd be inefficient for the OP to be
> fitting trend lines. And the trend lines aren't necessarily good
> approximations for the underlying functions near the point of intersection.
> Solver is a manual solution (unless the OP were to use a Calculate event
> handler to run Solver whenever the function parameters change upon any
> recalc), but it's likely to be more accurate than finding the intersection
> point of trend line approximations to the underlying functions.
>
>
>
```
 0
12/16/2005 9:02:02 PM
```Polynomial equations are the best fit. As I mentioned, the system pressure
and pump output pressure varies by fluid properties. An example of a data set
from one fluid is as follows:

0	2279	123
300	2254	145
800	2219	277
1300	2192	531
1800	2171	905
2300	2155	1399
2800	2141	2014
3300	2130	2750
3800	2118	3607
4300	2105	4584
4800	2089	5681
5300	2069	6900
5800	2042	8239

Graphing the data and selecting a 3rd order polynomial for the trendline
gives the following equations:

System rate f(x): y=-5E-21x^3=0.002x^2-1E-13x+123.08
Pump rate g(x): y=-2E-09x^3=2E-05x^2-0.0896x+2279.4

The solution for flow rate is where the pump and system pressures are
equivalent, or where the two equations are equal.

Hope this helps.

"B. R.Ramachandran" wrote:

> Hi,
>
> What kind curves are they (i.e., what kind of functions are those trendline
> equations) - linear, polynomial, logarithmic, ....? Can you post sample
> trendline equations for the pump curve and the system curve?
>
> Regards,
> B. R. Ramachandran
>
>
> > I am trying to otain a solution for the number where two curves meet.
> > Specifically trying to determine the expected flow rate given a pump curve
> > and system curve. The curves shift depending on variables that are read from
> > a spreadsheet. I can get the curve formulas by graphing them and requesting
> > the trendline feature, but then I have to manually enter the curve formulas,
> > set them equal to each other, and solve the equation. Can Excel do this
> > automatically from two data sets? Any help would be appreciated.
```
 0
12/19/2005 7:42:02 PM
```Hi.  If I'm not mistaken, I believe your equation results are slightly off
because of display error.
For example, your x^3 term in System Rate should be about 8.34 *10^-12 (vs
When Solving equations, you may find it better to extract the coefficients.
For Example, select 4 horizontal cells and Array enter the following with X
& Y referring to your data.

=LINEST(Y ,X^{1,2,3})  (Ctrl+Shift+Enter)

These coefficients appear correct when compared to the output from another
program.
(System):
8.34352E-12 ,0.000241208 ,1.19407E-05, 123.0624551
(Pump):
-2.02024E-09 ,2.01471E-05, -0.089731972, 2279.045625

Subtract the coef. to get something like...
-2.0285*10^-9*x^3-0.000221*x^2-0.08974*x+2155.98317

Solve the cubic equation (equation =0) to get three real solutions...
-108474.58402
-3389.100225
2890.94350

Only 2890 appears as the feasible solution.
HTH
--
Dana DeLouis
Win XP & Office 2003

news:D86014DD-6BCB-4B56-B47F-1F1C90927330@microsoft.com...
> Polynomial equations are the best fit. As I mentioned, the system pressure
> and pump output pressure varies by fluid properties. An example of a data
> set
> from one fluid is as follows:
>
> 0 2279 123
> 300 2254 145
> 800 2219 277
> 1300 2192 531
> 1800 2171 905
> 2300 2155 1399
> 2800 2141 2014
> 3300 2130 2750
> 3800 2118 3607
> 4300 2105 4584
> 4800 2089 5681
> 5300 2069 6900
> 5800 2042 8239
>
> Graphing the data and selecting a 3rd order polynomial for the trendline
> gives the following equations:
>
> System rate f(x): y=-5E-21x^3=0.002x^2-1E-13x+123.08
> Pump rate g(x): y=-2E-09x^3=2E-05x^2-0.0896x+2279.4
>
> The solution for flow rate is where the pump and system pressures are
> equivalent, or where the two equations are equal.
>
> Hope this helps.
>
> "B. R.Ramachandran" wrote:
>
>> Hi,
>>
>> What kind curves are they (i.e., what kind of functions are those
>> trendline
>> equations) - linear, polynomial, logarithmic, ....? Can you post sample
>> trendline equations for the pump curve and the system curve?
>>
>> Regards,
>> B. R. Ramachandran
>>
>>
>> > I am trying to otain a solution for the number where two curves meet.
>> > Specifically trying to determine the expected flow rate given a pump
>> > curve
>> > and system curve. The curves shift depending on variables that are read
>> > from
>> > a spreadsheet. I can get the curve formulas by graphing them and
>> > requesting
>> > the trendline feature, but then I have to manually enter the curve
>> > formulas,
>> > set them equal to each other, and solve the equation. Can Excel do this
>> > automatically from two data sets? Any help would be appreciated.

```
 0
delouis (422)
12/20/2005 4:02:43 PM
```Hi,

Thre are a few ways by which you can accomplish what you want:

Let's suppose that column flow rates (GPM) are in A2:A14, Pump Pressure are
in B2:B14, and System Pressure are in C2:C14.  Create a column D2:D14 as
follows:
In D2 enter the formula =B2-C2,  and drag the formula down to D14.

Method 1 (Maybe Good!):
By making an inverse plot (a slightly approximate, but very quick, solution)

Make a plot of A2:A14 (Y-axis) and D2:D14 (X-axis) and fit a polynomial
(maybe, 3-rd order) and get the trendline equation.  The constant term is
what you want.  Unfortunately, this result may be about 2-4% off from the
'correct' value.  For example, for your data, the result from this approach
is 2952 gpm  (the trendline equation is  y = 1E-08x3 - 0.0001x2 + 0.8402x +
2952.2) is about 2%  off from the correct value (2891 gpm)
A convenient aspect of this method is that the trendline equation would
automatically update when your original data change.

Method 2 (Better?):
You can use Solver, and solve for the flow rate for which the difference
between Pump Pressure and System Pressure will be zero.  Obtain the trendline
equation for The result obtained would be very good (e.g., 2891 for your
samnple data).  However the inconvenient aspect is that the result WILL NOT
update when your original data change(s).  You have to manually invoke Solver
every time that happens.

Method 3 (Best!): Exploiting Circular Reference.

Select a 1 Row x 4 Column area, and entering the following formula,
=LINEST(D2:D14,A2:A14^{1,2,3}), confirmed with CTRL-SHIFT-ENTER
(for your sample data, 2.029E-09,   2.211E-04,   8.974E-02,   -2.156E+03)

In E2, enter an arbitrary flow rate (gpm) value, say 300.
In F2,      =1.00001*E2
IN G2,     =a*E2^3+b*E2^2+c*E2+d  (where a, b, c, and d are the actual
values of the coefficients from the trendline equation or linest function)
In H2,     =a*F2^3+b*F2^2+c*F2+d
In I2,      =(H2-G2)/(F2-E2)
In J2,      =(I2*E2-G2)/I2

Now comes the interesting part.  Go back to E2 and enter =J2.
Excel will complain and say there is a Circular Reference.  Ignore that.  Go
to "Tools" --> "Options" --> "Calculation" Tab, check "Iteration" --> "OK"

Now Excel will accept the circular reference.  You would notice that E2 and
J2 have become equal.  That is the value you want!  Your sample data yielded
the following results:
2890.9	2891.0	0.0	0.0	1.4	2890.9
The values will update when your original data change.

Regards,
B. R. Ramachandran

> Polynomial equations are the best fit. As I mentioned, the system pressure
> and pump output pressure varies by fluid properties. An example of a data set
> from one fluid is as follows:
>
> 0	2279	123
> 300	2254	145
> 800	2219	277
> 1300	2192	531
> 1800	2171	905
> 2300	2155	1399
> 2800	2141	2014
> 3300	2130	2750
> 3800	2118	3607
> 4300	2105	4584
> 4800	2089	5681
> 5300	2069	6900
> 5800	2042	8239
>
> Graphing the data and selecting a 3rd order polynomial for the trendline
> gives the following equations:
>
> System rate f(x): y=-5E-21x^3=0.002x^2-1E-13x+123.08
> Pump rate g(x): y=-2E-09x^3=2E-05x^2-0.0896x+2279.4
>
> The solution for flow rate is where the pump and system pressures are
> equivalent, or where the two equations are equal.
>
> Hope this helps.
>
> "B. R.Ramachandran" wrote:
>
> > Hi,
> >
> > What kind curves are they (i.e., what kind of functions are those trendline
> > equations) - linear, polynomial, logarithmic, ....? Can you post sample
> > trendline equations for the pump curve and the system curve?
> >
> > Regards,
> > B. R. Ramachandran
> >
> >
> > > I am trying to otain a solution for the number where two curves meet.
> > > Specifically trying to determine the expected flow rate given a pump curve
> > > and system curve. The curves shift depending on variables that are read from
> > > a spreadsheet. I can get the curve formulas by graphing them and requesting
> > > the trendline feature, but then I have to manually enter the curve formulas,
> > > set them equal to each other, and solve the equation. Can Excel do this
> > > automatically from two data sets? Any help would be appreciated.
```
 0
12/20/2005 9:57:06 PM

Similar Artilces:

Formula without using numbers after decimal in the answer
I have a formula that derives the answer from a figure with a decimal. I don't want to use the figures after the decimal. Is there a way to just use the whole number and omit the numbers after the decimal without having to manually key in all these numbers manually? Thanks, Mustang You can use the INT function. This 'rounds down' any number to th nearest integer, e.g. if A1=2.567, a formula in B2 of =INT(A1) return 2 HTH Bruc -- swatsp0 ----------------------------------------------------------------------- swatsp0p's Profile: http://www.excelforum.com/member.php?...

Excel button problem
Hi All I have a macro that copies a worksheet in the active workbook and puts it into a new workbook - then formats it and deletes any buttons on the worksheet. On the first click on the button the macro works ok. On the second click, it fails because the all assigned macros on all buttons in the active workbook changed from "mba" to "book1!mba". Book 1 doesn't exists (wasn't opened, wasn't saved, doesn't have the macros). I've never experienced this problem before?? Can anyone help to solve this problem? FYI The macro to do this is c...

Excel 97 #9
Please can anyone help??? I have two columns in Excel 97. The first contains a list of statu values eg. pending, or granted or withdrawn. The second contains date eg.01/12/1997, 05/06/2003. I woudl like to know how to get all th granted apps before 31/12/2003. Can anyone help please -- Message posted from http://www.ExcelForum.com theres many ways, but an easiest way would be to do a sort. Highlight the 2 columns, click on data, then sort, then sort by status, then by date. this should group them all together. hope this helps...toe >-----Original Message----- >Please can anyo...

New to excel
Hi All, I'm new to Excel ( and to this forum :) ) and so I hope somebody may b able to help me. I've got 2 questions.... QUESTION 1 I've got a spreadsheet which takes data from one worksheet and uses i to calculate data in a second worksheet using the following code formula: =IF('4th November 2005'!B19="","nothing here dude",IF(B19<'4th Novembe 2005'!B19,"UP",IF(B19='4th November 2005'!B19,"Same",IF(B19>'4t November 2005'!B19,"DOWN")))) The problem is, when I create a new worksheet I have...

Looking for Excel Help
I'm a very novice Excel user and am looking for a little help with creating a formula for a spreadsheet I'm creating for my personal use. I would appreciate some assistance if possible. Thanks in advance. Dan --- Message posted from http://www.ExcelForum.com/ Hi Dan! Post a sample of what you want to do. Your question is just a tad open ended <g> -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "DanB4105" <DanB4105.ywtpa@excelfor...

POST or GET?
(apologies if this is OT but I couldn't find an HTTP newsgroup) I am writing an MFC client application which speaks to an HTTP server. The server will send text data to the client, the client will modify and return that data to the server along with a small amount of new data. Should I use GET or POST to get the data from the server? "Richard" <richard@hello.com> wrote in message news:zWudf.14758\$Cq4.8824@newsfe7-gui.ntli.net... > I am writing an MFC client application which speaks to an HTTP server. The > server will send text data to the client, the client...

Count If Formula #4
I need a formula that will figure the following: If column C = 3, count all times < 00:45 If column C = 4, count all times < 00:45 If column C = 3, count all times > 00:46 Thanks. Your description is a bit confused.You have different actions for the same value (C=3). And where are the times, in a different column than C? So, making many assumptions, perhaps =SUMPRODUCT(--(ISNUMBER(MATCH(C1:C200,{3,4},0))),--(D1:D200<TIME(0,45,0)))+S UMPRODUCT(--(C1:C200=5),--(D1:D200<TIME(0,46,0))) -- HTH RP (remove nothere from the email address if mailing direct) "Denise"...

Excel corrupts when asking to update vlookups
We are experiencing weird behavior with some Office 2K3 Excel spreadsheets that contain lots of calculations, but no macros. On some pc’s Excel acts normally, on others you get the error. I have a couple of screen shots available. Any help is appreciated. If desired, send your file to my address below. I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Gu...

Uninstall of mappoint has caused errors with excel
Hi, I am running Office 2003 on the terminal server (windows 2003) and had a copy of mappoint as well. This is a mapping program. We ininstalled mappoint which has caused an error message with Excel and other office products. The error says "Cd:\documents and settings\administrator.ocrdc1\application data\microsoft\addins c:\Program files\common files\microsoft shared\geography\mpoai9.dll is not a valid add-in." I then click OK and excel opens up and everything is fine. The problem is that we are using other programs as well such as Quickbooks that export to excel and t...

How do I overlay text to a row without loosing the text in the ba.
I would like to know how to give an entire row (or column) a text overlay such as "VOID" and still be able to view the text in the underlaying row (or column). Thanks in advance. Use WordArt from the Drawing toolbar. Change the Fill to None. -- Jim Rech Excel MVP "Bruce Charles" <Bruce Charles@discussions.microsoft.com> wrote in message news:C430F6BC-1EBD-461F-A3FA-EC8592C5704C@microsoft.com... |I would like to know how to give an entire row (or column) a text overlay | such as "VOID" and still be able to view the text in the underlaying row (or | c...

Cannot open Outlook, keep getting Send error report of Microsoft.
We are having problems with Outlook 2003. Everytime we try to open, we get this: Send error report to Microsoft. Any ideas why? All windows and office update have been completed. ...

How do I see when new messages without outlook running?
Without Outlook 2003 constantly running, how do I send mail or know when I have new mail? two possible answers... 1) you don't or 2) you acquired a 3rd party app to occasionally poll your pop3/imap account "Leslie Adams" <Leslie Adams@discussions.microsoft.com> wrote in message news:D37C11C7-722C-4E91-9393-735A49C11701@microsoft.com... > Without Outlook 2003 constantly running, how do I send mail or know when I > have new mail? ...

learning Excel #3
Hi, I was considering learning Excel as an additional tool for my data analysis work. Is it better to use data sets that I have previously used with SPSS and apply the same analysis tools as in SPSS? For applying the appropriate tools, I was considering using excel's online help. The second option I have is to use some excel book for data analysis and apply the techniques to data sets provided with the book. Any suggestions????? regards Metal ...

unable to paste Excel 2003 chart into Outlook 2003
(This was posted on "excel.charting" group.) I have a user who's unable to paste an Excel 2003 chart into Outlook 2003 email message. In Outlook options, the checkbox is selected for "Use Microsoft Office Word 2003 to edit e-mail messages". When I tested this on my own computer running the same version of Office, if the box is check, I have no problem pasting; if this box is cleared, I cannot paste. But on his computer, it doesn't work regardless. Thanks and regards, TL ...

How do I Remove a Split from my Comments in Excel 2003? #2
I have set my current workbook to split/freeze the first column and first 2 rows. Now, when I add a comment to the second row (in any column) my comments are cut off if I should scroll down. I don't ever remember the behavior before. And I don't know what I've done to enable it but it's really annoying. How do turn this off ? ...

I am currenly playing a game of Ars Magica. I am using a spreadsheet to compute the info for my character. I am having a probllem with the casting total for spells related to a paticular character. The Formula is as follows : =IF(H13="","--",IF(J13="",INDIRECT(H13),MIN(INDIRECT(H13),INDIRECT(LEFT(J13,2)),INDIRECT(RIGHT(J13,2))))+IF(K13="",INDIRECT(I13),MIN(INDIRECT(I13),INDIRECT(LEFT(K13,2)),INDIRECT(RIGHT(K13,2))))+Sta+IF(N13="",0,\$H\$2)) I am trying to compute the casting total for the spells castable by this character. The total for the ...

Setting a dynamic range in a formula
Hi, I have a column of numbers and I always want the following arra formula to use the last 12 entries: =(PRODUCT(1+D1:D12/100)-1)*100 Any suggestions? Thanks, Phillycheese -- Phillycheese ----------------------------------------------------------------------- Phillycheese5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2419 View this thread: http://www.excelforum.com/showthread.php?threadid=37809 Assuming that Column D contains no blanks, try... =(PRODUCT(1+OFFSET(D1,MAX(0,COUNTA(D:D)-12),0,12,1)/100)-1)*100 ...confirmed with CONTROL+SHIFT+ENTER. Hope th...

get a result of an sql into a field
Hi there I would like to get a result of an sql execution (ms sql server) into aq filed. example i A1 I have a ID number in A2 I would like to get the result of something like this 'select name from address where id=A1' Does this exist in Excel ? Thanks in advance Ralf Here is the sub i have written for loading an Sql Query into th worksheet. Parameters: Server Name DataBase Name SQL Command Target Sheet name Column to begin from Row to begin from ex: CALL LoadData("MyServer","MyDataBase","Select UserName fro TblNames", "QueryData"...

Is anyone an expert with outlook that I can call on the phone?
How do I share calenders between outlook and my MSN Premier account? Assuming you are using the outlook connector, you need to set the msn account to be the default message store then outlook will use the msn calendar as the default. -- Diane Poremsky [MVP - Outlook] Outlook Tips: http://www.outlook-tips.net/ Outlook & Exchange Solutions Center: http://www.slipstick.com Outlook Tips by email: mailto:dailytips-subscribe-request@lists.outlooktips.net EMO - a weekly newsletter about Outlook and Exchange: mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM You can access this...

Expand a surface graph
Hi! This might by a easy question.... I made a surface graph with a table of 5x6 with %. The graph is fine, but I want to make the graph bigger, so I expand the graph the same way I do with other types of graph (pressing on the graph an move the cursor), but it does not work here. Now I habe a small graph, with a lot of blank space- Any help will be appreciate. Best regards! Zek ...

How to move MS Office without reinstalling?
I have an iMac that has had Microsoft Office on it since 2002 or so. Other family members have bought MS Office as well since then. They are all v. X. Each has a unique product ID and the only disc copy I can find for installing MS Office has a key on it. I don't know if it was my original copy. I will soon be reinstalling an OS on the iMac and in the process, I will have to wipe it clean. Is it possible to copy all of the MS Office files to appropriate backup locations, then copy them back when the install is done so I do not have to reinstall from the disc and risk it not be...