jeansnkicks/openpert

Automatically exported from code.google.com/p/openpert

openpert's Issues

Enforce "Option Explicit" thorugh-out module

It would be good to enforce that all variables be defined up front.  During 
some of the early development there were a few variables introduced without 
initialization or definition. 

Original issue reported on code.google.com by [email protected] on 24 Jul 2011 at 1:23

Update Copyright notice

Copyright notice must be updated in the Excel plug-in from Creative Commons to 
the BSD new license. A separate copyright menu item is suggested that will 
display the test:

***
Copyright (c) 2011, OpenPERT Project
All rights reserved.

Redistribution and use in source and binary forms, with or without
modification, are permitted provided that the following conditions are met:
    * Redistributions of source code must retain the above copyright
      notice, this list of conditions and the following disclaimer.
    * Redistributions in binary form must reproduce the above copyright
      notice, this list of conditions and the following disclaimer in the
      documentation and/or other materials provided with the distribution.
    * Neither the name of the OpenPERT Project nor the
      names of its contributors may be used to endorse or promote products
      derived from this software without specific prior written permission.

THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
DISCLAIMED. IN NO EVENT SHALL "OPENPERT PROJECT" BE LIABLE FOR ANY
DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
(INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
(INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
***

Original issue reported on code.google.com by [email protected] on 23 Jul 2011 at 11:06

Request for poisson distribution to be added to openpert

Openpert is able to generate a a series of random numbers that follow a 
beta-pert distribution and put them into a named range.  That is really 
convenient.  

I think it would be very helpful if we could extend that functionality to 
include the poisson distribution as well.

Original issue reported on code.google.com by [email protected] on 19 Sep 2011 at 1:19

Allowing CONF passed without quotes from Excel Cell

This may be just my pet peeve, but I am not a fan of having to enter the quotes 
around "M" for CONF in the Excel cell for my OPERT call.  Following code 
inserted in OPERT function before the original "On Error Goto 16" will allow me 
to enter the CONF argument without quotes:

    'following allows conf to be entered without quotes
    Dim sformula As String
    Dim commaPos As Integer, parenPos As Integer

    If IsError(conf) Then
        'if it's an error value, get the entry in the formula
        sformula = Application.Caller.Formula

        'return position of 3rd comma
        commaPos = InStr(1, sformula, ",")
        commaPos = InStr(commaPos + 1, sformula, ",")
        commaPos = InStr(commaPos + 1, sformula, ",")

        'return end of formula to capture 4th argument
        parenPos = Len(sformula)

        conf = Mid(sformula, commaPos + 1, parenPos - commaPos - 1)
    End If

Original issue reported on code.google.com by [email protected] on 27 Jul 2011 at 1:02

opert input values return error on large values

What steps will reproduce the problem?
1. min = 2M, ml=20M max=42M  ==> error

What is the expected output? What do you see instead?
#NUM?

Please use labels and text to provide additional information.

I think the value that the variables are fail to be processed correctly if they 
are really large.

Original issue reported on code.google.com by [email protected] on 3 Oct 2011 at 8:13

Request for binomial distribution to be added to openpert

Openpert is able to generate a a series of random numbers that follow a 
beta-pert distribution and put them into a named range.  That is really 
convenient.  

I think it would be very helpful if we could extend that functionality to 
include the binomial distribution as well.

Original issue reported on code.google.com by [email protected] on 19 Sep 2011 at 1:18

MOPertSim() doesn't run in release 3 0.84

The MOPertSim() function was broken by the change to enable the confidence to 
be either a number of qualitative label.  Must update the MOPertSim to account 
for that too.

Original issue reported on code.google.com by [email protected] on 28 Jul 2011 at 7:27

Request for normal distribution to be added to openpert

Openpert is able to generate a a series of random numbers that follow a 
beta-pert distribution and put them into a named range.  That is really 
convenient.  

I think it would be very helpful if we could extend that functionality to 
include the normal distribution as well.

Original issue reported on code.google.com by [email protected] on 19 Sep 2011 at 1:17

Calculated bins for OPERTSIM

The bins for opertsim are currently static at 20.  It would be great if the 
number of bins were automatically calculated based on some optimization method 
to create a "pretty" histogram.  20 seems to work for most distributions to 
look "pretty" but may not work for all.

Original issue reported on code.google.com by [email protected] on 25 Jul 2011 at 9:26

Allow case-insensitive confidence labels

What steps will reproduce the problem?
1. =OPERT(5,7,10,"vh")

What is the expected output? What do you see instead?
Expect: 7.166386268
Receive: #VALUE!

What version of the product are you using? On what operating system?
1.0 - XP SP, Excel 2010

Please provide any additional information below.

Original issue reported on code.google.com by [email protected] on 10 Aug 2011 at 3:32

Error Handling (MsgBox vs. CVErr)

I wanted to open an issue on the Error Handling.  I'll mark is as low priority.

Original issue reported on code.google.com by [email protected] on 24 Jul 2011 at 1:26

Request for uniform distribution to be added to openpert

Openpert is able to generate a a series of random numbers that follow a 
beta-pert distribution and put them into a named range.  That is really 
convenient.  

I think it would be very helpful if we could extend that functionality to 
include the uniform distribution as well.

Original issue reported on code.google.com by [email protected] on 19 Sep 2011 at 1:18

How do I delete OpenPERT?

I cannot get rid of the add-in. Please provide steps to uninstall OpenPert from 
Excel for Mac O/S.

Original issue reported on code.google.com by [email protected] on 15 Aug 2014 at 2:26