Search results

Create the page "Microsoft Excel" on this wiki! See also the search results found.

Page title matches

• Handling Microsoft Excel Spreadsheets Containing Multiple Projects For Version 7.2
  ...the creative selection of '''Row and Swimlane''' fields from the Microsoft Excel '''source plan'''. ...lies to OnePager Bundle ('''OPB''') where '''OPB''' is accessing Microsoft Excel '''source plans'''.
  7 KB (1,088 words) - 21:17, 9 January 2024
• Making Multi-Project Charts from Separate Microsoft Excel Plans for Version 7.2
  ...ID''' field. This is necessary because unlike Microsoft Project, Microsoft Excel does not automatically provide a '''unique identifier''' for rows. Additio ...ery important that the sequence of columns in the '''multiple''' Microsoft Excel '''source plan''' spreadsheets be identical.
  10 KB (1,459 words) - 21:15, 9 January 2024
• Microsoft Excel Fields Available to OnePager Express for Version 7.2
  ...portunity to confirm or change the '''mapping'''. For a typical Microsoft Excel '''source plan''' the second page (page 2) of the '''OnePager choices''' fo ...' on how to categorize the '''column headings''' it finds in the Microsoft Excel '''source plan'''.
  2 KB (277 words) - 21:19, 6 November 2023

Page text matches

• Conditional Formatting with Boolean Fields (OnePager Express)
  The OnePager '''Conditional Formatting''' feature also supports Microsoft Excel '''Boolean''' fields which have only two values. That is, those fields whos 1) As an example, suppose we have the Microsoft Excel plan shown below which consists of three phases and resources consisting of
  3 KB (515 words) - 15:46, 8 December 2016
• Conditional Formatting Actions (OnePager Express)
  .... As a result, OnePager limits you to a maximum of '''eight''' Microsoft Excel plan columns in the '''conditional formatting rule''' set.
  5 KB (740 words) - 15:38, 8 December 2016
• Conditional Formatting Rules and the Legend (OnePager Express)
  ...black with a left pointing arrow symbol. First, let’s see the Microsoft Excel worksheet: ...own above will be applied, and the four tasks highlighted in the Microsoft Excel plan will have these rules applied. Thus, tasks I, J, K, L, and Q will sho
  2 KB (300 words) - 15:40, 8 December 2016
• Conditional Formatting Rules and the Template (OnePager Express)
  ...al formatting rules''' using a column that does not exist in the Microsoft Excel plan, OnePager Express ('''OPX''') will deactivate these specific rules.
  560 B (62 words) - 15:39, 8 December 2016
• Collecting Tasks/Milestones into Rows
  ...ution:''' You must assure that the selected Microsoft Project or Microsoft Excel file column is populated with data appropriate to direct OnePager through t
  4 KB (596 words) - 21:11, 5 May 2016
• Editing Row or Swimlane Labels
  ...enerated automatically based on data in the Microsoft Project or Microsoft Excel plan. However, they can be edited manually.
  1,016 B (138 words) - 23:07, 7 May 2024
• Snapshot-Dependent Row Labels (OnePager Express)
  Certain fields (columns) from Microsoft Excel typically change from snapshot to snapshot and will automatically be update ...to rows and to label rows using one of the above fields from the Microsoft Excel plan.
  4 KB (552 words) - 15:20, 19 April 2016
• Row and Swimlane Sorting
  :(1) In the '''orde'''r given in the Microsoft Project or Microsoft Excel plan. ...der''' specified by a custom column in your Microsoft Project or Microsoft Excel plan.
  2 KB (302 words) - 21:44, 5 May 2016
• Zebra Striping for Rows and Swimlanes (OnePager Express)
  ...ime, or through reconfiguring rows and swimlanes by changing the Microsoft Excel column driving the configuration, OnePager will automatically re-stripe the
  4 KB (608 words) - 17:00, 21 September 2015
• Editing, Repositioning Legend Items, and Formatting the Legend
  ...will not change any underlying data in your Microsoft Project or Microsoft Excel plan.
  5 KB (852 words) - 17:34, 19 February 2017
• Rows/Swimlane Tab
  ...ones into each row based on values from a Microsoft Project or a Microsoft Excel plan’s data column. ...you can group together using values from a Microsoft Project or Microsoft Excel plan’s data column. For example, you could group all rows containing tas
  3 KB (503 words) - 16:55, 6 May 2016
• Task Bars Tab (OnePager Express)
  ...based on” radio button allows you to select a column from your Microsoft Excel plan to assign a data-driven to each task. ...Each endpoint can display the date held in any date column from Microsoft Excel. These properties are essentially the same controls as described above for
  6 KB (899 words) - 16:08, 21 September 2015
• Milestones Tab (OnePager Express)
  ...color. In this option, clicking the drop down provides a list of Microsoft Excel plan columns from which to select. ...the same for Task related Deadlines also allows control over the Microsoft Excel plan column that controls the color and delay color of the deadline decorat
  6 KB (967 words) - 16:07, 21 September 2015
• Legend Tab
  :b) The automatic title may also reflect your Microsoft Project plan columns used for color or shape in conditional formatting.
  10 KB (1,559 words) - 13:03, 10 May 2024
• Advanced Tab (OnePager Pro)
  ...ish dates, the task/milestone name, and the Unique-ID of the task from the Microsoft Project plan. An example is shown below. ...asks (coming in from the second Microsoft Project plan) are from the first Microsoft Project plan when they are clearly not. Having the “Safely combine tasks
  11 KB (1,686 words) - 15:30, 22 September 2015
• Advanced Tab (OnePager Express)
  ...the task/milestone name, and the Unique-ID of the task from the Microsoft Excel plan. An example is shown below. ...king a new project view from the first plan, you open the second Microsoft Excel plan and update the project view in “Replace Snapshot” mode. If the ch
  10 KB (1,672 words) - 15:30, 22 September 2015
• Using Fiscal Years and Weeks (OnePager Express)
  ...t with the single task spanning two standard calendar years. The Microsoft Excel spreadsheet will look like this:
  8 KB (1,320 words) - 16:14, 21 September 2015
• Template Only Features (OnePager Express)
  ...mplates that are designed to focus on summary information from a Microsoft Excel plan. “Detailed” templates are designed to support information at a ta ...bered tasks and milestones that can be imported from the various Microsoft Excel plans. This is necessary so that OnePager can establish a means to support
  8 KB (1,200 words) - 14:53, 22 September 2015
• Splitting and Parsing Columns (OnePager Express)
  ...multiple resources (or anything else). Because assignments from Microsoft Excel often are comma-delimited, this feature enables OnePager to parse the comma ...you want to use color-codes on tasks/milestones based upon your Microsoft Excel plan’s “Resource Names” column as shown below:
  3 KB (527 words) - 15:08, 18 September 2015
• Creating a NEW Project View - OnePager Express
  1) Launch Microsoft Excel and bring up the desired Microsoft Excel plan. 2) Insert a “Flag” column into the Microsoft Excel plan. This will be the flag that OnePager will use to determine which plan
  4 KB (567 words) - 22:34, 17 September 2015