Bereiknamen

Om de bereiknamen kort en inzichtelijk te houden is gekozen voor Engelse omschrijvingen.

Het model bevat de volgende bereiknamen:

BalanceAC =Dates!$AA$2
BalanceFC =Dates!$Z$2
BalanceMAC =Dates!$AA$61
BalanceMFC =Dates!$Z$61
BBformula ='Monthly Forecast'!$E$4:$P$4
BSactual =Input!$E$4
BSmonths =Input!$L$4:$V$4
BSweeks =Input!$F$4:$J$4
ChartBalancesAC =VERSCHUIVING(BalanceAC;FromWeek-1;0)
:VERSCHUIVING(BalanceAC;ToWeek-1;0)
ChartBalancesFC =VERSCHUIVING(BalanceFC;FromWeek-1;0)
:VERSCHUIVING(BalanceFC;ToWeek-1;0)
ChartBalancesMAC =VERSCHUIVING(BalanceMAC;FromMonth-1;0)
:VERSCHUIVING(BalanceMAC;ToMonth-1;0)
ChartBalancesMFC =VERSCHUIVING(BalanceMFC;FromMonth-1;0)
:VERSCHUIVING(BalanceMFC;ToMonth-1;0)
ChartCredAC =VERSCHUIVING(CredAC;FromWeek-1;0)
:VERSCHUIVING(CredAC;ToWeek-1;0)
ChartCredFC =VERSCHUIVING(CredFC;FromWeek-1;0)
:VERSCHUIVING(CredFC;ToWeek-1;0)
ChartCredICAC =VERSCHUIVING(CredICAC;FromWeek-1;0)
:VERSCHUIVING(CredICAC;ToWeek-1;0)
ChartCredICFC =VERSCHUIVING(CredICFC;FromWeek-1;0)
:VERSCHUIVING(CredICFC;ToWeek-1;0)
ChartCredICMAC =VERSCHUIVING(CredMICAC;FromMonth-1;0)
:VERSCHUIVING(CredMICAC;ToMonth-1;0)
ChartCredICMFC =VERSCHUIVING(CredMICFC;FromMonth-1;0)
:VERSCHUIVING(CredMICFC;ToMonth-1;0)
ChartCredMAC =VERSCHUIVING(CredMAC;FromMonth-1;0)
:VERSCHUIVING(CredMAC;ToMonth-1;0)
ChartCredMFC =VERSCHUIVING(CredMFC;FromMonth-1;0)
:VERSCHUIVING(CredMFC;ToMonth-1;0)
ChartDebAC =VERSCHUIVING(DebAC;FromWeek-1;0)
:VERSCHUIVING(DebAC;ToWeek-1;0)
ChartDebFC =VERSCHUIVING(DebFC;FromWeek-1;0)
:VERSCHUIVING(DebFC;ToWeek-1;0)
ChartDebICAC =VERSCHUIVING(DebICAC;FromWeek-1;0)
:VERSCHUIVING(DebICAC;ToWeek-1;0)
ChartDebICFC =VERSCHUIVING(DebICFC;FromWeek-1;0)
:VERSCHUIVING(DebICFC;ToWeek-1;0)
ChartDebICMAC =VERSCHUIVING(DebICMAC;FromMonth-1;0)
:VERSCHUIVING(DebICMAC;ToMonth-1;0)
ChartDebICMFC =VERSCHUIVING(DebICMFC;FromMonth-1;0)
:VERSCHUIVING(DebICMFC;ToMonth-1;0)
ChartDebMAC =VERSCHUIVING(DebMAC;FromMonth-1;0)
:VERSCHUIVING(DebMAC;ToMonth-1;0)
ChartDebMFC =VERSCHUIVING(DebMFC;FromMonth-1;0)
:VERSCHUIVING(DebMFC;ToMonth-1;0)
ChartFinInAC =VERSCHUIVING(FinInAC;FromWeek-1;0)
:VERSCHUIVING(FinInAC;ToWeek-1;0)
ChartFinInFC =VERSCHUIVING(FinInFC;FromWeek-1;0)
:VERSCHUIVING(FinInFC;ToWeek-1;0)
ChartFinInMAC =VERSCHUIVING(FinInMAC;FromMonth-1;0)
:VERSCHUIVING(FinInMAC;ToMonth-1;0)
ChartFinInMFC =VERSCHUIVING(FinInMFC;FromMonth-1;0)
:VERSCHUIVING(FinInMFC;ToMonth-1;0)
ChartFinOutAC =VERSCHUIVING(FinOutAC;FromWeek-1;0)
:VERSCHUIVING(FinOutAC;ToWeek-1;0)
ChartFinOutFC =VERSCHUIVING(FinOutFC;FromWeek-1;0)
:VERSCHUIVING(FinOutFC;ToWeek-1;0)
ChartFinOutMAC =VERSCHUIVING(FinOutMAC;FromMonth-1;0)
:VERSCHUIVING(FinOutMAC;ToMonth-1;0)
ChartFinOutMFC =VERSCHUIVING(FinOutMFC;FromMonth-1;0)
:VERSCHUIVING(FinOutMFC;ToMonth-1;0)
ChartMonths =VERSCHUIVING(StartMonthChart;FromMonth-1;0)
:VERSCHUIVING(StartMonthChart;ToMonth-1;0)
ChartOthInAC =VERSCHUIVING(OthInAC;FromWeek-1;0)
:VERSCHUIVING(OthInAC;ToWeek-1;0)
ChartOthInFC =VERSCHUIVING(OthInFC;FromWeek-1;0)
:VERSCHUIVING(OthInFC;ToWeek-1;0)
ChartOthInMAC =VERSCHUIVING(OthINMAC;FromMonth-1;0)
:VERSCHUIVING(OthINMAC;ToMonth-1;0)
ChartOthInMFC =VERSCHUIVING(OthInMFC;FromMonth-1;0)
:VERSCHUIVING(OthInMFC;ToMonth-1;0)
ChartOthOutAC =VERSCHUIVING(OthOutAC;FromWeek-1;0)
:VERSCHUIVING(OthOutAC;ToWeek-1;0)
ChartOthOutFC =VERSCHUIVING(OthOutFC;FromWeek-1;0)
:VERSCHUIVING(OthOutFC;ToWeek-1;0)
ChartOthOutMAC =VERSCHUIVING(OthOutMAC;FromMonth-1;0)
:VERSCHUIVING(OthOutMAC;ToMonth-1;0)
ChartOthOutMFC =VERSCHUIVING(OthOutMFC;FromMonth-1;0)
:VERSCHUIVING(OthOutMFC;ToMonth-1;0)
ChartPenAC =VERSCHUIVING(PenAC;FromWeek-1;0)
:VERSCHUIVING(PenAC;ToWeek-1;0)
ChartPenFC =VERSCHUIVING(PenFC;FromWeek-1;0)
:VERSCHUIVING(PenFC;ToWeek-1;0)
ChartPenMAC =VERSCHUIVING(PenMAC;FromMonth-1;0)
:VERSCHUIVING(PenMAC;ToMonth-1;0)
ChartPenMFC =VERSCHUIVING(PenMFC;FromMonth-1;0)
:VERSCHUIVING(PenMFC;ToMonth-1;0)
ChartSalAC =VERSCHUIVING(SalAC;FromWeek-1;0)
:VERSCHUIVING(SalAC;ToWeek-1;0)
ChartSalFC =VERSCHUIVING(SalFC;FromWeek-1;0)
:VERSCHUIVING(SalFC;ToWeek-1;0)
ChartSalMAC =VERSCHUIVING(SalMAC;FromMonth-1;0)
:VERSCHUIVING(SalMAC;ToMonth-1;0)
ChartSalMFC =VERSCHUIVING(SalMFC;FromMonth-1;0)
:VERSCHUIVING(SalMFC;ToMonth-1;0)
ChartTaxAC =VERSCHUIVING(TaxAC;FromWeek-1;0)
:VERSCHUIVING(TaxAC;ToWeek-1;0)
ChartTaxFC =VERSCHUIVING(TaxFC;FromWeek-1;0)
:VERSCHUIVING(TaxFC;ToWeek-1;0)
ChartTaxMAC =VERSCHUIVING(TaxMAC;FromMonth-1;0)
:VERSCHUIVING(TaxMAC;ToMonth-1;0)
ChartTaxMFC =VERSCHUIVING(TaxMFC;FromMonth-1;0)
:VERSCHUIVING(TaxMFC;ToMonth-1;0)
ChartVendAC =VERSCHUIVING(VendAC;FromWeek-1;0)
:VERSCHUIVING(VendAC;ToWeek-1;0)
ChartVendFC =VERSCHUIVING(VendFC;FromWeek-1;0)
:VERSCHUIVING(VendFC;ToWeek-1;0)
ChartVendMAC =VERSCHUIVING(VendMAC;FromMonth-1;0)
:VERSCHUIVING(VendMAC;ToMonth-1;0)
ChartVendMFC =VERSCHUIVING(VendMFC;FromMonth-1;0)
:VERSCHUIVING(VendMFC;ToMonth-1;0)
ChartWeeks =VERSCHUIVING(StartWeekChart;FromWeek-1;0)
:VERSCHUIVING(StartWeekChart;ToWeek-1;0)
CredAC =Dates!$AC$2
CredFC =Dates!$AB$2
CredICAC =Dates!$AE$2
CredICFC =Dates!$AD$2
CredMAC =Dates!$AC$61
CredMFC =Dates!$AB$61
CredMICAC =Dates!$AE$61
CredMICFC =Dates!$AD$61
CtrChartSelection1 =Dates!$M$53
CtrChartSelection2 =Dates!$N$53
CtrMonths1 =Info!$E$12
CtrMonths2 =Info!$E$14
CtrView =Dates!$W$5
CtrWeeks1 =Info!$E$19
CtrWeeks2 =Info!$E$21
CtrYears =Dates!$W$1
DebAC =Dates!$AQ$2
DebFC =Dates!$AP$2
DebICAC =Dates!$AS$2
DebICFC =Dates!$AR$2
DebMAC =Dates!$AQ$61
DebMFC =Dates!$AP$61
DebMICAC =Dates!$AS$61
DebMICFC =Dates!$AR$61
FinInAC =Dates!$AY$2
FinInFC =Dates!$AX$2
FinInMAC =Dates!$AY$61
FinInMFC =Dates!$AX$61
FinOutAC =Dates!$AO$2
FinOutFC =Dates!$AN$2
FinOutMAC =Dates!$AO$61
FinOutMFC =Dates!$AN$61
FromMonth =Info!$G$12
FromWeek =Info!$G$19
Input1 =Input!$F$7:$J$14
Input10 =Input!$L$39:$V$44
Input11 =Input!$L$48:$V$56
Input12 =Input!$L$60:$V$60
Input13 =Input!$E$6:$E$14
Input14 =Input!$E$17:$E$26
Input15 =Input!$E$30:$E$36
Input16 =Input!$E$39:$E$44
Input17 =Input!$E$48:$E$56
Input18 =Input!$E$60
Input2 =Input!$F$17:$J$26
Input3 =Input!$F$31:$J$36
Input4 =Input!$F$39:$J$44
Input5 =Input!$F$48:$J$56
Input6 =Input!$F$60:$J$60
Input7 =Input!$L$7:$V$14
Input8 =Input!$L$17:$V$26
Input9 =Input!$L$31:$V$36
InputMonthsFC =Input!$L$4:$V$60
InputWeeksAC =Input!$E$5:$E$60
InputWeeksFC =Input!$F$4:$J$60
InputWkNr =Dates!$J$48
LChartSelection =Dates!$H$53:$H$57
ListMonths =Dates!$G$1:$S$13
ListMonths2 =Dates!$G$15:$S$27
ListMonths3 =Dates!$E$57:$F$68
ListWeekNbrs =Dates!$A$1:$E$53
ListWeeks =Dates!$A$56:$C$79
ListYears =Dates!$V$1:$V$2
LMonths =Dates!$H$2:$H$13
LView =Dates!$V$5:$V$6
mPotentialLease ='Monthly Forecast'!$E$60:$AB$60
NbrMonths ='Monthly Forecast'!$A$1
NbrWeeksAC ='Weekly Actuals'!$A$1
NbrWeeksFC ='Weekly Forecast'!$A$1
Offset1 ='Forecast View'!$B$1
Offset2 ='Forecast View'!$C$1
OffsetActual =Dates!$J$46
OffsetMonth =Dates!$J$45
OffsetWeek =Dates!$J$44
OthInAC =Dates!$AW$2
OthInFC =Dates!$AV$2
OthINMAC =Dates!$AW$61
OthInMFC =Dates!$AV$61
OthOutAC =Dates!$AM$2
OthOutFC =Dates!$AL$2
OthOutMAC =Dates!$AM$61
OthOutMFC =Dates!$AL$61
PenAC =Dates!$AI$2
PenFC =Dates!$AH$2
PenMAC =Dates!$AI$61
PenMFC =Dates!$AH$61
RedundantLineMFC ='Monthly Forecast'!$F$5:$AB$5
RedundantLineWFC ='Weekly Forecast'!$F$5:$BI$5
SalAC =Dates!$AG$2
SalFC =Dates!$AF$2
SalMAC =Dates!$AG$61
SalMFC =Dates!$AF$61
Start1 =Input!$F$7
Start10 =Input!$L$39
Start11 =Input!$L$48
Start12 =Input!$L$60
Start2 =Input!$F$17
Start3 =Input!$F$31
Start4 =Input!$F$39
Start5 =Input!$F$48
Start6 =Input!$F$60
Start7 =Input!$L$7
Start8 =Input!$L$17
Start9 =Input!$L$31
StartInputMFC =MFC!$D$4
StartInputMonthlyFC ='Monthly Forecast'!$D$4
StartInputWeeklyAC ='Weekly Actuals'!$D$5
StartInputWeeklyFC ='Weekly Forecast'!$D$4
StartMonthChart =Dates!$Y$61
StartWeekChart =Dates!$Y$2
TaxAC =Dates!$AK$2
TaxFC =Dates!$AJ$2
TaxMAC =Dates!$AK$61
TaxMFC =Dates!$AJ$61
Text1 =Dates!$H$50
Text2 =Dates!$H$51
ToMonth =Info!$G$14
ToWeek =Info!$G$21
ToYear =Info!$F$21
VendAC =Dates!$AU$2
VendFC =Dates!$AT$2
VendMAC =Dates!$AU$61
VendMFC =Dates!$AT$61
View1 ='Forecast View'!$E$7:$I$14
View10 ='Forecast View'!$K$39:$U$44
View11 ='Forecast View'!$K$48:$U$56
View12 ='Forecast View'!$K$60:$U$60
View2 ='Forecast View'!$E$17:$I$26
View3 ='Forecast View'!$E$31:$I$36
View4 ='Forecast View'!$E$39:$I$44
View5 ='Forecast View'!$E$48:$I$56
View6 ='Forecast View'!$E$60:$I$60
View7 ='Forecast View'!$K$7:$U$14
View8 ='Forecast View'!$K$17:$U$26
View9 ='Forecast View'!$K$31:$U$36
Weeknbr ='Forecast View'!$H$1
WeekNbr2 =Input!$H$1
Weeks =Dates!$A$2:$A$53
WeeksPassed ='Forecast View'!$W$5
wPotentialLease ='Weekly Forecast'!$E$60:$BI$60
Year =Info!$D$6

Artikel als PDF downloaden

Vul hieronder uw e-mailadres in om de PDF-versie van dit artikel te ontvangen:

Invoer verplicht

Personeelsmanagement

Personeelsmanagement

Heeft u ook een verantwoordelijkheid in personeelsmanagement? Kijk dan ook op HR Praktijk Rapporten voor rapporten, whitepapers en e-books over bijvoorbeeld kostenvergoedingen, werkkostenregeling, personeelskosten, loonheffing en de auto van de zaak.

Facilitair management

Facilitair management

Projecten of vragen rondom facilitair management? Kijk dan ook op F-Facts Rapporten voor rapporten, whitepapers en e-books over bijvoorbeeld inkoop & aanbesteden, huisvesting, schoonmaak en energie.