Help on personalized "slope" function

**excellina** · 12-19-2009, 08:27 AM

I have just found a personalized slope function and I don't understand how it works.

Can you help me ?

note: the "PersonalizedSLOPE" function is set in CELL CC187

PersonalizedSlope(Volume1;Volume2;Cost1;Cost2)
=ARGUMENT("Volume1";1)
=ARGUMENT("Volume2";1)
=ARGUMENT("Cost1";1)
=ARGUMENT("Cost2";1)
=RESULT(1)
=(Cost2/Cost1)^(0,693147180559945/LN(Volume2/Volume1))
=RETURN(CC187)

HOUR | REVENUES | PERFORMANCE
10 | € 88 | € 8,8
20 | € 123 | € 6,2

SLOPE: 0,5

Note: PERFORMANCE is REVENUES/HOUR

In this case values are

[PersonalizedSlope(88;123;8,8;6,2)]
Volume1= 88
Volume2= 123
Cost1= 8,8
Cost2= 6,2

My problem is that excel 2003 slope funtion return me a different value

=SLOPE(D6:D7;C6:C7)

note ( Y value first )

=SLOPE(8,8:6,2;88:123)

=0,076

Why I have a different value ?

How can I check the personalized slope function ?

Thank you in advance

**shg** · 12-19-2009, 02:58 PM

If that's a function that appears in your workbook, it is a custom function someone wrote in VBA. Post the workbook.

**excellina** · 12-19-2009, 04:08 PM

Here the file.

What does this function in your opinion ?

Probably has nothing to do with the excel slope, but then what is ?

thank you anyway

**shg** · 12-19-2009, 05:30 PM

"Slope" is a defined name in the workbook. I don't have a clue what the formulas are supposed to do; they make no sense.

**teylyn** · 12-19-2009, 05:54 PM

These are XLM macros! As in "before VBA"! Haven't seen them in a while. I'm not sure there are even people around here who still know how to work them ....

**teylyn** · 12-19-2009, 06:02 PM

After some serious digging in the brain box ....

Here, I deleted some of the duplicate range names and made sure the macro functions have the workbook scope. Now the slope formula returns a result, instead of the error. You can see what the Slope function does in the FORMU sheet.

It collects the four arguments provided in the function call and then calculates

=(Cost2/Cost1)^(0.693147180559945/LN(Volume2/Volume1))

I'm not sure if this is what you want and how it compares to the current built-in Excel slope function, but you can correct the calculation above to suit your needs.

hth