Difference between revisions of "Using Fiscal Years and Weeks for OnePager Express for Version 7.0"

From OnePager Documentation
Jump to: navigation, search
(Created page with "==Overview== ===Template and Project-View Properties Form Time Axis Tabs=== 1) One Pager Pro has always supported '''date labeling''' in both '''calendar year '''and '''fisc...")
 
Line 1: Line 1:
 
==Overview==
 
==Overview==
  
===Template and Project-View Properties Form Time Axis Tabs===
+
===Template and Chart Properties Form Time Axis Tabs===
  
 
1) One Pager Pro has always supported '''date labeling''' in both '''calendar year '''and '''fiscal year '''formats.
 
1) One Pager Pro has always supported '''date labeling''' in both '''calendar year '''and '''fiscal year '''formats.
Line 7: Line 7:
 
2) '''Fiscal year''' formats are available for '''date labeling''' in each of the three '''Time Axis Levels''' and their '''Cells'''.
 
2) '''Fiscal year''' formats are available for '''date labeling''' in each of the three '''Time Axis Levels''' and their '''Cells'''.
  
3) In OnePager Express the controls for the '''Time Axis''' are reorganized to consolidate them in their own '''Template''' form and '''Project-View Properties''' ('''PVP''') form tabs.
+
3) In OnePager Express the controls for the '''Time Axis''' are reorganized to consolidate them in their own '''Template''' form and '''Chart Properties''' form tabs.
  
4) Although consolidated, there are two sub-tabs in the '''Time Axis '''tab for both the '''Template '''and '''PVP '''forms that have settings related to '''Fiscal Year '''appearance in '''Time Axis Levels'''.
+
4) Although consolidated, there are two sub-tabs in the '''Time Axis '''tab for both the '''Template '''and '''Chart Properties '''forms that have settings related to '''Fiscal Year '''appearance in '''Time Axis Levels'''.
  
 
:a) The '''Calendar '''sub-tab’s '''Calendar Settings '''group has two controls related to '''Fiscal year '''as shown below:   
 
:a) The '''Calendar '''sub-tab’s '''Calendar Settings '''group has two controls related to '''Fiscal year '''as shown below:   
Line 30: Line 30:
 
5) Additionally, you have the option to '''show fiscal year date labels''' on tasks and milestones when you select to include '''dates''' as part of task/milestone '''decorations''' such as '''Date labels''', '''Baselines''', '''Deadlines''', and '''Endpoints''' (4 in total).  
 
5) Additionally, you have the option to '''show fiscal year date labels''' on tasks and milestones when you select to include '''dates''' as part of task/milestone '''decorations''' such as '''Date labels''', '''Baselines''', '''Deadlines''', and '''Endpoints''' (4 in total).  
  
6) The '''Template '''and '''PVP '''form both have '''Task Bars''' and '''Milestones '''tabs each with a '''Task Bars '''or '''Milestone Symbols Decorations '''control group as shown below for the '''PVP '''form’s '''Task Bars''' tab:
+
6) The '''Template '''and '''Chart Properties '''form both have '''Task Bars''' and '''Milestones '''tabs each with a '''Task Bars '''or '''Milestone Symbols Decorations '''control group as shown below for the '''Chart Properties '''form’s '''Task Bars''' tab:
  
 
<center>[[File:X61-22_2_2-61-(3)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(3)-10292018.png]]</center>
Line 41: Line 41:
 
:c) The operation of '''fiscal year date format '''controls are discussed in this section:  [[Using Fiscal Years and Weeks for OnePager Express for Version 7.0#About Fiscal Years and Weeks | About Fiscal Years and Weeks]]. 22.2.2-70
 
:c) The operation of '''fiscal year date format '''controls are discussed in this section:  [[Using Fiscal Years and Weeks for OnePager Express for Version 7.0#About Fiscal Years and Weeks | About Fiscal Years and Weeks]]. 22.2.2-70
  
7) For more information on the controls in the '''Template '''and '''PVP '''form’s '''Task Bars''' and '''Milestones '''tab, please see the articles in the list below:
+
7) For more information on the controls in the '''Template '''and '''Chart Properties '''form’s '''Task Bars''' and '''Milestones '''tab, please see the articles in the list below:
  
 
<center>
 
<center>
Line 52: Line 52:
 
==Fiscal Year Configuration of Time Axis Levels==
 
==Fiscal Year Configuration of Time Axis Levels==
  
1) As mentioned above, the controls for '''globally''' '''editing''' the '''fiscal year date format''' configuration of the three OnePager Express '''Time Axis Levels''' are in the '''Template''' form and '''PVP '''form '''Time Axis '''tab’s '''Calendar''' sub-tab and the three '''Level '''sub-tabs ('''Top''', '''Middle''', and '''Bottom''').  The '''PVP '''form for these tabs and sub-tabs is shown above.
+
1) As mentioned above, the controls for '''globally''' '''editing''' the '''fiscal year date format''' configuration of the three OnePager Express '''Time Axis Levels''' are in the '''Template''' form and '''Chart Properties '''form '''Time Axis '''tab’s '''Calendar''' sub-tab and the three '''Level '''sub-tabs ('''Top''', '''Middle''', and '''Bottom''').  The '''Chart Properties '''form for these tabs and sub-tabs is shown above.
  
 
2) There are two steps required to change the '''default calendar year date format '''settings in the three '''Time Axis Levels '''to '''fiscal year date formats'''.
 
2) There are two steps required to change the '''default calendar year date format '''settings in the three '''Time Axis Levels '''to '''fiscal year date formats'''.
Line 66: Line 66:
 
<center>&lt;X61-22_2_2-61-(5)-10292018.png&gt;</center>
 
<center>&lt;X61-22_2_2-61-(5)-10292018.png&gt;</center>
  
:c) Repeat the above step for the '''Middle Time Axis Level '''and '''Bottom Time Axis Level''' where appropriate and the resulting '''Time Axis''' in the project view reflects the '''fiscal year date format '''settings as shown in the example below:
+
:c) Repeat the above step for the '''Middle Time Axis Level '''and '''Bottom Time Axis Level''' where appropriate and the resulting '''Time Axis''' in the chart reflects the '''fiscal year date format '''settings as shown in the example below:
  
 
<center>[[File:X61-22_2_2-61-(6)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(6)-10292018.png]]</center>
Line 87: Line 87:
 
5) Although there are no OnePager Express provided '''Fiscal Year date format types''' for '''Months, Weeks''', etc., you have the capability to create your own using the '''Custom Date Format '''feature.
 
5) Although there are no OnePager Express provided '''Fiscal Year date format types''' for '''Months, Weeks''', etc., you have the capability to create your own using the '''Custom Date Format '''feature.
  
:a) Below is an illustration shown where you can access the '''Custom Date Format '''feature from the '''PVP '''form:
+
:a) Below is an illustration shown where you can access the '''Custom Date Format '''feature from the '''Chart Properties '''form:
  
 
<center>[[File:X61-22_2_2-61-(9)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(9)-10292018.png]]</center>
Line 94: Line 94:
 
:b) For more information on the '''Custom Date Format '''feature, please see the article at:  [[The Custom Date Format Feature for OnePager Express for Version 7.0 | The Custom Date Format Feature for OnePager Express]]. 22.5.2-70
 
:b) For more information on the '''Custom Date Format '''feature, please see the article at:  [[The Custom Date Format Feature for OnePager Express for Version 7.0 | The Custom Date Format Feature for OnePager Express]]. 22.5.2-70
  
==Fiscal Year Configuration in the Project View==
+
==Fiscal Year Configuration in the Chart==
  
1) The previous section above described the configuration of '''fiscal year date formats '''for '''Time Axis Levels'''. This section covers the configuration of '''date formats '''in the project view ('''graph''') where it is desired to represent '''fiscal years '''versus '''calendar years''' in '''dates '''associated with '''decorations '''on tasks and milestones.   
+
1) The previous section above described the configuration of '''fiscal year date formats '''for '''Time Axis Levels'''. This section covers the configuration of '''date formats '''in the '''graph''' where it is desired to represent '''fiscal years '''versus '''calendar years''' in '''dates '''associated with '''decorations '''on tasks and milestones.   
  
2) '''Date labels''' are represented in a standard way for any task/milestone or decoration that have a '''date''' association in the project view. These include:
+
2) '''Date labels''' are represented in a standard way for any task/milestone or decoration that have a '''date''' association in the chart. These include:
  
 
* Tasks/Milestones '''start and finish dates'''
 
* Tasks/Milestones '''start and finish dates'''
Line 109: Line 109:
 
4) Tasks/milestones and their associated decorations ('''baselines''', '''deadlines''', and '''endpoints''') have their '''date label characteristics''' specified globally following the steps outlined below:
 
4) Tasks/milestones and their associated decorations ('''baselines''', '''deadlines''', and '''endpoints''') have their '''date label characteristics''' specified globally following the steps outlined below:
  
:a)  Access the '''Project-View Properties''' ('''PVP''') clicking the button on the OnePager Express '''Home''' ribbon.
+
:a)  Access the '''Chart Properties''' clicking the button on the OnePager Express '''Home''' ribbon.
  
:b) This accesses the '''PVP '''form where you can select either the '''Task bars''' tab or the '''Milestones''' tab to gain access to the appropriate '''decorations''' group of the form as shown below:
+
:b) This accesses the '''Chart Properties '''form where you can select either the '''Task bars''' tab or the '''Milestones''' tab to gain access to the appropriate '''decorations''' group of the form as shown below:
  
 
<center>[[File:X61-22_2_2-61-(3)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(3)-10292018.png]]</center>
Line 129: Line 129:
 
===About Fiscal Years and Weeks===
 
===About Fiscal Years and Weeks===
  
6) Although '''fiscal year date formats '''in '''Time Axis Levels''' are separate for control purposes from the controls over '''fiscal year date formats''' for tasks and milestones, it is often advisable to coordinate '''date formats''' in the project view ('''graph''') with '''date formats '''in the '''Time Axes.'''
+
6) Although '''fiscal year date formats '''in '''Time Axis Levels''' are separate for control purposes from the controls over '''fiscal year date formats''' for tasks and milestones, it is often advisable to coordinate '''date formats''' in the '''graph''' with '''date formats '''in the '''Time Axes.'''
  
7) Accordingly, if you plan to include '''date formats''' in any task/milestone '''decoration''' in your project view, you need to '''edit '''the controls in each specific task/milestone '''decoration''' you are going to use.
+
7) Accordingly, if you plan to include '''date formats''' in any task/milestone '''decoration''' in your chart, you need to '''edit '''the controls in each specific task/milestone '''decoration''' you are going to use.
  
 
8) The following sub-sections provide some useful examples.
 
8) The following sub-sections provide some useful examples.
Line 144: Line 144:
 
<center>&lt;X61-22_2_2-61-(11)-10292018.png&gt;</center>
 
<center>&lt;X61-22_2_2-61-(11)-10292018.png&gt;</center>
  
11) Creating the project view produces this '''graph''' where the '''Time Axis''' is specified globally as a standard '''calendar year''', '''Start dates''' are shown to the left of the tasks and their '''Finish dates''' are shown to the right of the tasks:
+
11) Creating the chart produces this '''graph''' where the '''Time Axis''' is specified globally as a standard '''calendar year''', '''Start dates''' are shown to the left of the tasks and their '''Finish dates''' are shown to the right of the tasks:
  
 
<center>[[File:X61-22_2_2-61-(12)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(12)-10292018.png]]</center>
Line 151: Line 151:
 
:a)  The years shown for the last tasks in the illustration above have '''Start dates''' in 2018 and the last tasks '''Finish dates''' are in 2019.  
 
:a)  The years shown for the last tasks in the illustration above have '''Start dates''' in 2018 and the last tasks '''Finish dates''' are in 2019.  
  
:b)  You now can use the '''Time Axis''' controls accessed through the '''PVP '''form’s '''Time Axis '''tab to access the '''Calendar '''sub-tab.   
+
:b)  You now can use the '''Time Axis''' controls accessed through the '''Chart Properties '''form’s '''Time Axis '''tab to access the '''Calendar '''sub-tab.   
  
 
:c) In the '''Calendar '''sub-tab, validate, for example, that the '''First month of the fiscal year''' dropdown is set to the month of October and the '''Use starting year for FY numbering '''checkbox is unchecked or '''OFF'''.
 
:c) In the '''Calendar '''sub-tab, validate, for example, that the '''First month of the fiscal year''' dropdown is set to the month of October and the '''Use starting year for FY numbering '''checkbox is unchecked or '''OFF'''.
Line 163: Line 163:
 
<center>&lt;X61-22_2_2-61-(13)-10292018.png&gt;</center>
 
<center>&lt;X61-22_2_2-61-(13)-10292018.png&gt;</center>
  
:e) After resetting the '''Top Level''', '''Middle Level''', and '''Bottom Level''' sub-tab controls as described above and clicking the '''Apply '''button on the '''PVP '''form, the project view’s '''Time Axis '''looks like this:  
+
:e) After resetting the '''Top Level''', '''Middle Level''', and '''Bottom Level''' sub-tab controls as described above and clicking the '''Apply '''button on the '''Chart Properties '''form, the chart’s '''Time Axis '''looks like this:  
  
 
<center>[[File:X61-22_2_2-61-(14)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(14)-10292018.png]]</center>
Line 170: Line 170:
 
:f)  Since, for consistency, you want to have the task’s '''Start/Finish dates''' reflect the correct '''fiscal year''' designation to match the configuration of the '''Time Axis''', there is a need to make a few more adjustments:
 
:f)  Since, for consistency, you want to have the task’s '''Start/Finish dates''' reflect the correct '''fiscal year''' designation to match the configuration of the '''Time Axis''', there is a need to make a few more adjustments:
  
::i) First, go to the '''Task Bars '''tab of the '''PVP '''form and click the '''Date Label Properties '''button to access the '''Set date label properties '''form.   
+
::i) First, go to the '''Task Bars '''tab of the '''Chart Properties '''form and click the '''Date Label Properties '''button to access the '''Set date label properties '''form.   
 
::ii) In the '''Set date label properties''' form, click the '''Show start date '''and '''Show finish date '''checkboxes to '''ON'''.
 
::ii) In the '''Set date label properties''' form, click the '''Show start date '''and '''Show finish date '''checkboxes to '''ON'''.
 
::iii) Then select the desired '''Start position '''and '''Finish position''' from the dropdown lists provided.
 
::iii) Then select the desired '''Start position '''and '''Finish position''' from the dropdown lists provided.
Line 179: Line 179:
 
<center>&lt;X61-22_2_2-61-(10)-10292018.png&gt;</center>
 
<center>&lt;X61-22_2_2-61-(10)-10292018.png&gt;</center>
  
12) With the above settings made for the tasks in the project view, the '''Date Labels''' previously added to the task’s '''Labels''' now look like this:
+
12) With the above settings made for the tasks in the chart, the '''Date Labels''' previously added to the task’s '''Labels''' now look like this:
  
 
<center>[[File:X61-22_2_2-61-(15)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(15)-10292018.png]]</center>
Line 198: Line 198:
 
15) The following illustrations define '''weeks''' as beginning on Sundays and define the '''fiscal year''' as beginning in October.  
 
15) The following illustrations define '''weeks''' as beginning on Sundays and define the '''fiscal year''' as beginning in October.  
  
16) These are the two cases of setting the answer to the '''third question''' above to make sure that the feature reflects your desires. The examples show how to answer the '''three questions''' via the '''PVP '''form '''Time Axis '''tab’s three '''Level '''sub-tabs and the '''Calendar''' sub-tab.  
+
16) These are the two cases of setting the answer to the '''third question''' above to make sure that the feature reflects your desires. The examples show how to answer the '''three questions''' via the '''Chart Properties '''form '''Time Axis '''tab’s three '''Level '''sub-tabs and the '''Calendar''' sub-tab.  
  
 
17) The illustration created below displays all three levels on the '''Time Axis'''. The '''Top Level''' shows '''Month '''and '''Fiscal Year'''. The '''Middle Level''' shows '''Week Number '''in '''Fiscal Year''' terms.. The '''Bottom Level''' shows '''Day of the Week'''.  
 
17) The illustration created below displays all three levels on the '''Time Axis'''. The '''Top Level''' shows '''Month '''and '''Fiscal Year'''. The '''Middle Level''' shows '''Week Number '''in '''Fiscal Year''' terms.. The '''Bottom Level''' shows '''Day of the Week'''.  
Line 239: Line 239:
 
:(3)  The '''fourth (4th) day of the year''' in accordance with International Standards Organization ('''ISO''') 8601.
 
:(3)  The '''fourth (4th) day of the year''' in accordance with International Standards Organization ('''ISO''') 8601.
  
19) The selection control for establishing which option you wish to use is located in the '''PVP '''form’s '''Time Axis '''tab in its '''Calendar '''sub-tab’s '''Calendar Settings '''control group as shown below:
+
19) The selection control for establishing which option you wish to use is located in the '''Chart Properties '''form’s '''Time Axis '''tab in its '''Calendar '''sub-tab’s '''Calendar Settings '''control group as shown below:
  
 
<center>[[File:X61-22_2_2-61-(21)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(21)-10292018.png]]</center>
Line 265: Line 265:
 
<center>&lt;X61-22_2_2-61-(24)-10292018.png&gt;</center>
 
<center>&lt;X61-22_2_2-61-(24)-10292018.png&gt;</center>
  
24) Below is a project view with the '''Time Axis''' which correctly shows the '''first week of fiscal year''' 2019 beginning on Sunday, September 30th of '''calendar year''' 2018, which is the '''week that contains the first day of fiscal year''' 2019 (Monday, October 1st of '''calendar year''' 2018).
+
24) Below is a chart with the '''Time Axis''' which correctly shows the '''first week of fiscal year''' 2019 beginning on Sunday, September 30th of '''calendar year''' 2018, which is the '''week that contains the first day of fiscal year''' 2019 (Monday, October 1st of '''calendar year''' 2018).
  
 
<center>[[File:X61-22_2_2-61-(25)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(25)-10292018.png]]</center>
Line 277: Line 277:
 
<center>&lt;X61-22_2_2-61-(26)-10292018.png&gt;</center>
 
<center>&lt;X61-22_2_2-61-(26)-10292018.png&gt;</center>
  
26) The project view shown below displays the '''Time Axis''' where the '''first week of the fiscal year''' contains '''the 4th day of the week''' complying with '''ISO 8601''':
+
26) The chart shown below displays the '''Time Axis''' where the '''first week of the fiscal year''' contains '''the 4th day of the week''' complying with '''ISO 8601''':
  
 
<center>[[File:X61-22_2_2-61-(27)-10292018.png]]</center>
 
<center>[[File:X61-22_2_2-61-(27)-10292018.png]]</center>
Line 293: Line 293:
  
 
[[Category:Version 7.0]]
 
[[Category:Version 7.0]]
[[Category:Editing a Project View]]
+
[[Category:Editing the Chart]]
 
[[Category:Task/Milestone Editing]]
 
[[Category:Task/Milestone Editing]]
 
[[Category:Task/Milestone Decorations]]
 
[[Category:Task/Milestone Decorations]]
Line 301: Line 301:
 
[[Category:Ribbon]]
 
[[Category:Ribbon]]
 
[[Category:Snapshots]]
 
[[Category:Snapshots]]
[[Category:Project Views]]
+
[[Category:Charts]]
 
[[Category:Templates]]
 
[[Category:Templates]]
 
[[Category:Custom Date Formats]]
 
[[Category:Custom Date Formats]]
[[Category:Project-View Properties Form]]
+
[[Category:Chart Properties Form]]
 
[[Category:OnePager Express]]
 
[[Category:OnePager Express]]

Revision as of 16:14, 27 February 2019

Overview

Template and Chart Properties Form Time Axis Tabs

1) One Pager Pro has always supported date labeling in both calendar year and fiscal year formats.

2) Fiscal year formats are available for date labeling in each of the three Time Axis Levels and their Cells.

3) In OnePager Express the controls for the Time Axis are reorganized to consolidate them in their own Template form and Chart Properties form tabs.

4) Although consolidated, there are two sub-tabs in the Time Axis tab for both the Template and Chart Properties forms that have settings related to Fiscal Year appearance in Time Axis Levels.

a) The Calendar sub-tab’s Calendar Settings group has two controls related to Fiscal year as shown below:
X61-22 2 2-61-(1)-10292018.png
<X61-22_2_2-61-(1)-10292018.png>
i) Use the First month of fiscal year to set the beginning month of your fiscal year period using the 12 month dropdown shown above.
ii) Checking the Use starting year for FY numbering checkbox establishes the ending year number as the name of the fiscal year shown in Time Axis Level Cells. Leaving this checkbox unchecked specifies that the starting year number is to be used as the name of the fiscal year shown in Time Axis Level Cells.
b) The Top, Middle, and Bottom sub-tabs in the Time Axis tab also have two controls related to setting Fiscal year date formats as shown here for the Middle sub-tab:
X61-22 2 2-61-(2)-10292018.png
<X61-22_2_2-61-(2)-10292018.png>
c) The two controls shown above are in each of the three Time Axis Level sub-tabs. When the Use fiscal year checkbox is checked, the adjacent Label format list contains fiscal year date formats you can select to populate that Time Axis Level’s Cells.

Task and Milestone Fiscal Year Date Decorations

5) Additionally, you have the option to show fiscal year date labels on tasks and milestones when you select to include dates as part of task/milestone decorations such as Date labels, Baselines, Deadlines, and Endpoints (4 in total).

6) The Template and Chart Properties form both have Task Bars and Milestones tabs each with a Task Bars or Milestone Symbols Decorations control group as shown below for the Chart Properties form’s Task Bars tab:

X61-22 2 2-61-(3)-10292018.png
<X61-22_2_2-61-(3)-10292018.png>
a) The Milestone tab differs from the Task Bars tab in that the Milestone tab does not have a Critical Path Properties or Endpoint Properties set of controls in its Milestone Symbols Decorations control group.
b) Within the four sets of controls shown highlighted above are checkboxes for turning the feature ON and OFF and buttons for accessing their respective Set … properties forms which contain the controls for setting fiscal year date formats for the specific task/milestone decoration.
c) The operation of fiscal year date format controls are discussed in this section: About Fiscal Years and Weeks. 22.2.2-70

7) For more information on the controls in the Template and Chart Properties form’s Task Bars and Milestones tab, please see the articles in the list below:

Task Bars Tab for OnePager Express 21.4.1-70 Milestones Tab for OnePager Express 21.6.1-70

Fiscal Year Configuration of Time Axis Levels

1) As mentioned above, the controls for globally editing the fiscal year date format configuration of the three OnePager Express Time Axis Levels are in the Template form and Chart Properties form Time Axis tab’s Calendar sub-tab and the three Level sub-tabs (Top, Middle, and Bottom). The Chart Properties form for these tabs and sub-tabs is shown above.

2) There are two steps required to change the default calendar year date format settings in the three Time Axis Levels to fiscal year date formats.

a) First, select the First month of the fiscal year using the dropdown selection control in the Calendar Settings sub-group of the Calendar sub-tab of the Time Axis tab and decide if the fiscal year date format for the year should name the starting year or ending year in the appropriate Time Axis Level Cell’s date format:
X61-22 2 2-61-(4)-10292018.png
<X61-22_2_2-61-(4)-10292018.png>
b) The second step is to go to the first Time Axis Level and set the Use fiscal year checkbox to ON and select the desired fiscal year date format from the Label format dropdown:
X61-22 2 2-61-(5)-10292018.png
<X61-22_2_2-61-(5)-10292018.png>
c) Repeat the above step for the Middle Time Axis Level and Bottom Time Axis Level where appropriate and the resulting Time Axis in the chart reflects the fiscal year date format settings as shown in the example below:
X61-22 2 2-61-(6)-10292018.png
<X61-22_2_2-61-(6)-10292018.png>

3) For comparative purposes, if you go back to the Calendar sub-tab and check the Use starting year for fiscal year numbering checkbox to ON, the Top Time Axis Level date label changes to that shown below:

X61-22 2 2-61-(7)-10292018.png
<X61-22_2_2-61-(7)-10292018.png>
a) In the above illustration the Top Time Axis Level’s date format shows the starting year for the year date format.
b) The Middle and Bottom Time Axis Level date formats are unchanged and the Use fiscal year checkbox in each of these two Time Axis Levels remains checked ON.

4) If we revert the year numbering of the Top Time Axis Level to ending year and go to the Middle Time Axis Level and uncheck the Use fiscal year checkbox to OFF, the Time Axis looks like this as annotated below:

X61-22 2 2-61-(8)-10292018.png
<X61-22_2_2-61-(8)-10292018.png>

5) Although there are no OnePager Express provided Fiscal Year date format types for Months, Weeks, etc., you have the capability to create your own using the Custom Date Format feature.

a) Below is an illustration shown where you can access the Custom Date Format feature from the Chart Properties form:
X61-22 2 2-61-(9)-10292018.png
<X61-22_2_2-61-(9)-10292018.png>
b) For more information on the Custom Date Format feature, please see the article at: The Custom Date Format Feature for OnePager Express. 22.5.2-70

Fiscal Year Configuration in the Chart

1) The previous section above described the configuration of fiscal year date formats for Time Axis Levels. This section covers the configuration of date formats in the graph where it is desired to represent fiscal years versus calendar years in dates associated with decorations on tasks and milestones.

2) Date labels are represented in a standard way for any task/milestone or decoration that have a date association in the chart. These include:

  • Tasks/Milestones start and finish dates
  • Baseline start and finish dates
  • Deadline date
  • Endpoint (4 in total) date

3) For all but Time Axis Levels, you have the capability to specify the position of dates with respect to the task, milestone, or decoration and their date font properties.

4) Tasks/milestones and their associated decorations (baselines, deadlines, and endpoints) have their date label characteristics specified globally following the steps outlined below:

a) Access the Chart Properties clicking the button on the OnePager Express Home ribbon.
b) This accesses the Chart Properties form where you can select either the Task bars tab or the Milestones tab to gain access to the appropriate decorations group of the form as shown below:
X61-22 2 2-61-(3)-10292018.png
<X61-22_2_2-61-(3)-10292018.png>
c) When any decoration checkbox is checked, the associated Properties buttons to the right is enabled so you can access the respective Set … properties forms as with the example for Date Label properties below:
X61-22 2 2-61-(10)-10292018.png
<X61-22_2_2-61-(10)-10292018.png>
d) The form above shows typical date control groups for a typical Set … properties form. Choosing to show the dates, the positioning of dates, the selection of the date format, and date font properties are standard throughout OnePager Express.
e) Each of the four (4) Set … properties forms for Task Bars and three (3) for Milestones has a Use fiscal year checkbox and an augmented list with fiscal year date formats when the Use fiscal year checkbox is checked ON.

5) For more information on the contents and use of controls in the four Set … properties forms, please use these reference links: Task Bars Tab for OnePager Express – Gantt Bar Decorations 21.4.1-70 and Milestones Tab for OnePager Express - Milestone Symbol Decorations 21.6.1-70

About Fiscal Years and Weeks

6) Although fiscal year date formats in Time Axis Levels are separate for control purposes from the controls over fiscal year date formats for tasks and milestones, it is often advisable to coordinate date formats in the graph with date formats in the Time Axes.

7) Accordingly, if you plan to include date formats in any task/milestone decoration in your chart, you need to edit the controls in each specific task/milestone decoration you are going to use.

8) The following sub-sections provide some useful examples.

Using Fiscal Years

9) The Use fiscal year checkbox, however, requires some further explanation. When this checkbox is checked ON, OnePager Express expresses years, quarters, month number of the year, week number of the year, and day number of the year relative to the start of the fiscal year.

10) As an example, suppose the source plan portion below has tasks spanning portions of two standard calendar years. The Microsoft Excel source plan looks like this:

X61-22 2 2-61-(11)-10292018.png
<X61-22_2_2-61-(11)-10292018.png>

11) Creating the chart produces this graph where the Time Axis is specified globally as a standard calendar year, Start dates are shown to the left of the tasks and their Finish dates are shown to the right of the tasks:

X61-22 2 2-61-(12)-10292018.png
<X61-22_2_2-61-(12)-10292018.png>
a) The years shown for the last tasks in the illustration above have Start dates in 2018 and the last tasks Finish dates are in 2019.
b) You now can use the Time Axis controls accessed through the Chart Properties form’s Time Axis tab to access the Calendar sub-tab.
c) In the Calendar sub-tab, validate, for example, that the First month of the fiscal year dropdown is set to the month of October and the Use starting year for FY numbering checkbox is unchecked or OFF.
X61-22 2 2-61-(4)-10292018.png
<X61-22_2_2-61-(4)-10292018.png>
d) With this step completed, access the Top Level, Middle Level, and Bottom Level sub-tabs in the desired order and check each sub-tabs Use fiscal year checkbox to ON and select an appropriate Fiscal Year Label format as illustrated below for the Top Time Axis Level sub-tab:
X61-22 2 2-61-(13)-10292018.png
<X61-22_2_2-61-(13)-10292018.png>
e) After resetting the Top Level, Middle Level, and Bottom Level sub-tab controls as described above and clicking the Apply button on the Chart Properties form, the chart’s Time Axis looks like this:
X61-22 2 2-61-(14)-10292018.png
<X61-22_2_2-61-(14)-10292018.png>
f) Since, for consistency, you want to have the task’s Start/Finish dates reflect the correct fiscal year designation to match the configuration of the Time Axis, there is a need to make a few more adjustments:
i) First, go to the Task Bars tab of the Chart Properties form and click the Date Label Properties button to access the Set date label properties form.
ii) In the Set date label properties form, click the Show start date and Show finish date checkboxes to ON.
iii) Then select the desired Start position and Finish position from the dropdown lists provided.
iv) Next, check the Use fiscal year checkbox,.
v) And, lastly, select the fiscal year Date format from the dropdown list as shown below:
X61-22 2 2-61-(10)-10292018.png
<X61-22_2_2-61-(10)-10292018.png>

12) With the above settings made for the tasks in the chart, the Date Labels previously added to the task’s Labels now look like this:

X61-22 2 2-61-(15)-10292018.png
<X61-22_2_2-61-(15)-10292018.png>

Using Fiscal Weeks

13) OnePager Express is able to display the week number of each fiscal year, going sequentially from 1 to 52 (or 53 in some cases).

14) The Fiscal Weeks feature depends on your answer to three (3) questions in setting up the Time Axis:

(1) On what day of the week does each week start (Sunday, Monday, etc.)?
(2) Which month is the first month of the fiscal year?
(3) Is the first week of the fiscal year the first full week, or is it the week that contains the first day of the fiscal year?

15) The following illustrations define weeks as beginning on Sundays and define the fiscal year as beginning in October.

16) These are the two cases of setting the answer to the third question above to make sure that the feature reflects your desires. The examples show how to answer the three questions via the Chart Properties form Time Axis tab’s three Level sub-tabs and the Calendar sub-tab.

17) The illustration created below displays all three levels on the Time Axis. The Top Level shows Month and Fiscal Year. The Middle Level shows Week Number in Fiscal Year terms.. The Bottom Level shows Day of the Week.

a) To achieve the desired result it is necessary to configure each of the three Time Axis Level controls in the Top Level, Middle Level, and Bottom Level as shown in the three illustrations below:
i) The Top Level sub-tab is configured to show Months with a Label format that includes the month-year combination. The year is displayed as the end of the fiscal year.
X61-22 2 2-61-(16)-10292018.png
<X61-22_2_2-61-(16)-10292018.png>
ii) The Middle Level sub-tab is configured to show the Fiscal Week Numbers with the Fiscal Week count starting at the beginning of the Fiscal Year.
X61-22 2 2-61-(17)-10292018.png
<X61-22_2_2-61-(17)-10292018.png>
iii) The Bottom Level sub-tab is configured to display Days of the week using the day abbreviation for the display.
X61-22 2 2-61-(18)-10292018.png
<X61-22_2_2-61-(18)-10292018.png>
b) We can anticipate that configuring the Bottom Time Axis Level in days could create so many Tic Units so as to crowd out the text. OnePager Pager Express detects this condition and provides a warning message as shown below:
X61-22 2 2-61-(19)-10292018.png
<X61-22_2_2-61-(19)-10292018.png>
c) Under such circumstances the recommended is to adjust the Timespan boundaries to present a more pleasing display as is done in the illustration below that incorporates the Time Axis Level settings presented above:
X61-22 2 2-61-(20)-10292018.png
<X61-22_2_2-61-(20)-10292018.png>

Defining the First Week in a Fiscal Year

18) OnePager has three (3) options for defining the first week of the fiscal year as described below. Where the first week of the fiscal year contains:

(1) The first day of the fiscal year.
(2) The first full week of the fiscal year.
(3) The fourth (4th) day of the year in accordance with International Standards Organization (ISO) 8601.

19) The selection control for establishing which option you wish to use is located in the Chart Properties form’s Time Axis tab in its Calendar sub-tab’s Calendar Settings control group as shown below:

X61-22 2 2-61-(21)-10292018.png
<X61-22_2_2-61-(21)-10292018.png>

20) The sub-sections below describe each of these options.

First Week of the Fiscal Year Contains the First Day of the Fiscal Year

21) The setting in the Calendar sub-tab above tells OnePager Express to count fiscal year weeks from the week that contains the first day of each fiscal year. (The form below also shows how to establish Sunday as the first day of the week and October as the first month of the fiscal year.)

X61-22 2 2-61-(22)-10292018.png
<X61-22_2_2-61-(22)-10292018.png>

22) The result from using these settings is shown below. The first week of fiscal year 2019 begins on Sunday, September 30th of calendar year 2018 which is the week that contains the first day of fiscal year 2019 (Monday, October 1st of calendar year 2019).

X61-22 2 2-61-(23)-10292018.png
<X61-22_2_2-61-(23)-10292018.png>

First Week of the Fiscal Year is First Full Week of the Fiscal Year

23) The settings shown below in the Advanced tab tells OnePager to count fiscal year weeks from the first full week of each fiscal year.

X61-22 2 2-61-(24)-10292018.png
<X61-22_2_2-61-(24)-10292018.png>

24) Below is a chart with the Time Axis which correctly shows the first week of fiscal year 2019 beginning on Sunday, September 30th of calendar year 2018, which is the week that contains the first day of fiscal year 2019 (Monday, October 1st of calendar year 2018).

X61-22 2 2-61-(25)-10292018.png
<X61-22_2_2-61-(25)-10292018.png>

First Week of the Fiscal Year Contains the 4th day of the Fiscal Year (ISO 8601)

25) The settings shown below in the Calendar sub-tab tells OnePager Express to count the fiscal year weeks from the first week that contains the 4th day of the year per ISO 8601:

X61-22 2 2-61-(26)-10292018.png
<X61-22_2_2-61-(26)-10292018.png>

26) The chart shown below displays the Time Axis where the first week of the fiscal year contains the 4th day of the week complying with ISO 8601:

X61-22 2 2-61-(27)-10292018.png
<X61-22_2_2-61-(27)-10292018.png>

Related Links

Task Bars Tab for OnePager Express 21.4.1-70

Milestones Tab for OnePager Express 21.6.1-70

The Custom Date Format Feature for OnePager Express 22.5.2-70

(22.2.2-70)