def loadData(self, file):
data_read_MRCPSP.dataStore(self, file)
qim_df = pd.read_excel("./data/qim.xlsx", columns=[1, 2, 3])
self.qim = qim_df.to_dict(orient="index")
Ofs_df = pd.read_excel("./data/Ofs.xlsx")
self.Ofs = Ofs_df.to_dict(orient="index")
CNfks_df = pd.read_excel("./data/CNfks.xlsx")
for s in range(7):
F_dic = {}
K_dic = {}
for r1 in range(2):
for k in range(3):
if r1 == 0:
K_dic[k] = CNfks_df[k + 1][2 * s]
if r1 == 1:
K_dic[k] = CNfks_df[k + 1][2 * s + 1]
K_dicb = copy.copy(K_dic)
F_dic[r1] = K_dicb
self.CNfks[s] = F_dic
def loadData(self, file_project, file_CNfks, file_Ofs, file_qfs):
data_read_MRCPSP.dataStore(self, file_project)
data_read_MRCPSP.read_CNfks(self, file_CNfks)
data_read_MRCPSP.read_Ofs(self, file_Ofs)
data_read_MRCPSP.read_qfs(self, file_qfs)
def loadData(self,file_project,file_CNfks,file_Ofs,file_qfs):
data_read_MRCPSP.dataStore(self, file_project) #project info
data_read_MRCPSP.read_CNfks(self,file_CNfks) # per order cost
data_read_MRCPSP.read_Ofs(self,file_Ofs) # fix ordercost
data_read_MRCPSP.read_qfs(self,file_qfs) # resource quality