#1 10-50-90 problem with negative values
When I entered the following information:
Description 1% 10% 50% 90% 99% Mean
Strategy 1 -12 11 121 25
Strategy 2 44 186 356 201
Strategy 3 11 195 341 180
I got an error msg generated by the following code:
MsgBox "Values in row " & irow & " are not monotonic." (for Row 1)
I'm pretty sure the initialization routine is initializing the 1% value in the first row to 0, thus causing the problem. I confirmed the suspicion by putting -13 in the 1% slot & everything worked fine.
I'd try to go in & fix the code myself, but with a bunch of finals staring at me, I'd thought I'd leave this to the professionals (especially as I found a work-around).
Hope that's enough to help pinpoint & resolve the problem. Please e-mail me if I can be of further help.
thanks, Steve Hurd
sahurd@stanford.edu
PS: The tool is quite helpful, as I found that creating these charts "from scratch" is a real bear! So thanks!
