def OnInit(self):
self.splash = A_splash.Novus_Splash(None)
X_utilities.teamDataCheck()
X_utilities.teamDataCheck2()
self.title_lbl = "Entrepreneurship Traning Program"
self.frame = A_frame.Novus_Frame(None, -1, title="Novus " + self.title_lbl)
# wx.Sleep(1)
self.frame.Center()
self.SetTopWindow(self.frame)
self.frame.Maximize()
self.frame.Show()
return True
def GetData1(self):
'''Reads the team data 1 file and returns a formatted
table.'''
X_utilities.teamDataCheck()
file = open(self.data1FP, 'rb')
reader = csv.reader(file, dialect='excel')
table = []
for row in reader:
table.append(row)
file.close()
# Format Output
table[0][1] = int(table[0][1])
# Man. / Pack. Equipment and FG Storage Years 1-3
table[2][1] = int(table[2][1])
table[3][1] = int(table[3][1])
table[4][1] = int(table[4][1])
table[5][1] = int(table[5][1])
table[6][1] = int(table[6][1])
table[7][1] = int(table[7][1])
table[8][1] = int(table[8][1])
table[9][1] = int(table[9][1])
table[10][1] = int(table[10][1])
# Man. / Pack. Equipment and FG Storage Years 4 - 6
table[2][2] = int(table[2][2])
table[3][2] = int(table[3][2])
table[4][2] = int(table[4][2])
table[5][2] = int(table[5][2])
table[6][2] = int(table[6][2])
table[7][2] = int(table[7][2])
table[8][2] = int(table[8][2])
table[9][2] = int(table[9][2])
table[10][1] = int(table[10][1])
table[10][2] = int(table[10][2])
table[2][3] = int(table[2][3])
table[3][3] = int(table[3][3])
table[4][3] = int(table[4][3])
table[5][3] = int(table[5][3])
table[6][3] = int(table[6][3])
# Long Term Debt Amt, Rate, Payback Period - Year 1
table[11][1] = int(table[11][1])
table[11][2] = float(table[11][2])
table[11][3] = int(table[11][3])
# Equity Amount and Shares
table[12][1] = int(table[12][1])
table[12][2] = int(table[12][2])
# Long Term Debt Amt, Rate, Payback Period - Year 1
table[13][1] = int(table[13][1])
table[13][2] = float(table[13][2])
table[13][3] = int(table[13][3])
# Six Years - All Integers
intRows = (14, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26,
27, 28, 29, 30, 31, 32, 39, 40, 41, 42, 43, 44, 45, 46)
for row in intRows:
for i in range(1, 7):
table[row][i] = int(table[row][i])
# Six Years - All Float
floatRows = (15, 33, 34, 35, 36, 37, 38, 47, 48, 49, 50)
for row in floatRows:
for i in range(1, 7):
table[row][i] = round(float(table[row][i]), 3)
# All Historical Performace Info Formatted as Integers
for row in range(51, 71):
for col in range(1, 7):
table[row][col] = int(table[row][col])
return table
def __init__(self, parent, *args, **kwargs):
X_utilities.teamDataCheck()
md = os.path.expanduser('~/')
self.data1FP = os.path.join(md, 'My Documents', 'Novus Data', 'teamData1.csv')
