AISC Properties in Excel: Almost Magic Oct 2017

Watch this “Two simple formulas — this is the magic !” video

Watch this “Accessing the Shape Properties” video

Returning dynamic arrays is concise and efficient.

# get array of keys

@xl_func(": var")
def shape_all_prop_K_15():
    """
    Return shapepropK
    return array length is 89
    """
    sp = V1415S.Shape15
    alphalist = [[name] for name in sp._fields]
    return alphalist

# get array of values

@xl_func("string shape_label: var")
# V is for value in the next function -- not for V as in AISC V1415
def shape_all_prop_V_15(shape_label):
    """
    Return shapepropV
    shape_label: string shape_label
    return array length is 89
    """
    # global dbaisc15

    gasd15 = getattr(V1415S, 'ga_static_dict')

    sp = gasd15[shape_label]
    alphalist = sp.getallproperties().split()
    sp = [[getattr(sp, x)] for x in alphalist]
    return sp