Argiro Roinioti 7/12/2011

Like

2104 Views

Hello,

I have linked the growth of the activity level of a variable to an excel file and for some reason, LEAP can not read the values. The activity level is the number of flights for the aviation sector of transport.

I use the new version of LEAP. The expression I have inserted is GrowthFromYearXL.

Do you have any idea why that happens?

Thank you in advance.

Best Regards,

Argiro

Charlie Heaps 7/12/2011
 

Like

2101 Views

Hi - do you see any error message? What happens on screen when you enter the expression? What exact version are you using?

Thanks

Charlie

-----------------
Hello,

I have linked the growth of the activity level of a variable to an excel file and for some reason, LEAP can not read the values. The activity level is the number of flights for the aviation sector of transport.

I use the new version of LEAP. The expression I have inserted is GrowthFromYearXL.

Do you have any idea why that happens?

Thank you in advance.

Best Regards,

Argiro

Argiro Roinioti 7/12/2011
 

Like

2096 Views

Hi, I do not see any error message, the expression is in blue. The version I am using is 2011.0025.


The graphy looks like this:
https://rapidshare.com/files/2781825957/flights_graph.png

Charlie Heaps 7/12/2011
 

Like

2095 Views

Sorry - I don't have access to Rapidshare - please send exact equation you are typing and email the screenshot to leap@sei-us.org

Thanks

Charlie Heaps 7/12/2011
 

Like

2092 Views

Hi again - I have now seen your chart and it looks as though LEAP is reading some very large growth rates. One possibility is that the Excel range is not formatted properly. Make sure that the range contains pairs of years and growth rate values and make sure the growth rate values are entered as decimal fractions. In other words, a 5% growth rate is entered as 0.05 (not 5!)

Here is an example. I created a range of 6 cells (3 years x 2 values) in an Excel sheet as follows:

2010 0.05
2013 -0.05
2025 0.05

I find the easiest way to use this data is to mark it in Excel as a named range. In this example I simply called the range "fred" and then saved the sheet as "C:\TEMP\TEST.XLSX"

Then in LEAP I created a growth function as follows:

GrowthFromYearXL(c:\temp\test.xlsx, fred)

Note that the above assume US number formatting. You may need to adjust this if you have another kind of number formatting. For example in Spanish speaking countries the above list separator comma is typically replaced by a semi-colon as follows:

GrowthFromYearXL(c:\temp\fred.xlsx; fred)

I hope this helps!

Charlie

Argiro Roinioti 7/13/2011
 

Like

2083 Views

Thank you Charlie,

It apprears indeed that there is some problem with the way the growth values are inserted!

I will make the necessary corrections, thanks again!



Argiro