def actual_v_forecast_ytd(self, forecast_selection):
return pretty_PL_format ( ytd_column_forecast(self.merged_pl_budget_data(),forecast_selection))
def actual_v_budget_month(self):
PL = self.merged_pl_budget_data().loc[:,['NL_Month','Budget_Month','Month_Variance']]
return pretty_PL_format(PL)
def actual_v_budget_month_dept(self,dept_selection):
PL = self.merged_dept_data(dept_selection).loc[:,['NL_Month','Budget_Month','Month_Variance']]
return pretty_PL_format(PL)
def actual_v_budget_ytd_dept(self,dept_selection):
# st.write ('testing to see that dept returns in actual v budget function class', dept_selection)
PL = self.merged_dept_data(dept_selection).loc[:,['NL_YTD','Budget_YTD','YTD_Variance']]
return pretty_PL_format(PL)
def actual_v_budget_ytd(self):
PL = self.merged_pl_budget_data().loc[:,['NL_YTD','Budget_YTD','YTD_Variance']]
return pretty_PL_format(PL)
def actual_v_forecast_year_projection_dept(self,ytd_selection, coding_acc_schedule,projection_selection,department):
full_year_forecast = end_of_year_forecast_dept(ytd_selection, self.NL, coding_acc_schedule,projection_selection,Budget_Data, F1_Data, F2_Data,F3_Data,
coding_sort,self.Budget_yr,self.F1_yr,self.F2_yr,self.F3_yr,department)
projection_slice = full_year_forecast.loc[:,['Projection','Budget','Var v. Budget', 'F1','F2','F3']]
return pretty_PL_format ( projection_slice)
def actual_v_forecast_month_dept(self, dept_selection, forecast1_selection):
PL = month_column_forecast(self.merged_dept_data(dept_selection),forecast1_selection)
return pretty_PL_format(PL)
def actual_v_forecast_month(self, forecast1_selection):
return pretty_PL_format ( month_column_forecast(self.merged_pl_budget_data(),forecast1_selection))