Search results

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

Page title matches

Page text matches

• Making Multi-Project Graphs from Separate Microsoft Excel Plans for Version 5.3
  ...mportant schedule items. You can do this as long as the related Microsoft Excel plans are constructed with unique '''Task ID''' column contents. This is necessary because unlike Microsoft Project, Microsoft Excel does not automatically provide a unique identifier for rows. Additionally,
  7 KB (1,050 words) - 19:59, 4 March 2016
• ADDING a Snapshot via Pull Operation - OnePager Express for Version 5.3
  ...15/2015 you receive updated status information that updates your Microsoft Excel plan accordingly. You now want to add this latest status information to yo ...that there are two different project views created form this one Microsoft Excel plan:
  9 KB (1,406 words) - 17:07, 4 March 2016
• Creating Another New Project View - OnePager Express Desktop for Version 5.3
  ...is accomplished by inserting two or more '''Flag''' fields into Microsoft Excel plan’s columns and instructing OnePager to produce additional project vi ...r customer. By inserting these three '''flag''' fields into the Microsoft Excel plan and appropriately populating the cells with '''Yes” and “No''', th
  4 KB (700 words) - 16:13, 3 March 2016
• Custom Update (Replacing) of a Snapshot via Pull Operation - OnePager Express for Version 5.3
  ...ly updating the snapshot in view by '''pulling''' in the updated Microsoft Excel plan's '''source file''', OnePager presents you with the standard OnePager 2) For this example, let’s suppose you have a Microsoft Excel plan for which you have already created a snapshot for a particular date, s
  8 KB (1,336 words) - 17:27, 4 March 2016
• Using the OnePager "Data" Tab's "Selected file(s)" Button
  ==Validating Source Files (Microsoft Project or Microsoft Excel)== ...ew named '''BlueGrass 2J-303-Working'''. That project view would have the Microsoft Project name and path name saved in the '''.TAM''' file.
  9 KB (1,536 words) - 17:44, 4 March 2016
• Merging the Wrong Tasks into a Project View for Version 5.3 - OnePager Express
  ...snapshots from period to period with updated information from a Microsoft Excel plan. The tasks that are presented to OnePager in '''UPDATE''' mode should ...Microsoft Excel plan if you are making several project views from the same Microsoft Project plan using several '''flag''' fields.
  11 KB (1,905 words) - 17:48, 4 May 2016
• Making Multi-Project Graphs from Separate Microsoft Excel Plans
  ...n contents. This is necessary because unlike Microsoft Project, Microsoft Excel does not automatically provide a unique identifier for rows. Additionally, ==Preparation for Making a Multi-Project Graph from Separate Microsoft Excel Plans==
  6 KB (906 words) - 16:32, 18 January 2016
• Handling Microsoft Excel Spreadsheets Containing Multiple Projects For Version 5.3
  Representing multiple projects originating in a single Microsoft Excel plan can be easily done using the Rows and Swimlanes feature. ==Multi-Project Excel Spreadsheet==
  4 KB (687 words) - 18:44, 4 March 2016
• Hiding/Unhiding/Moving/Finding/Changing/Resizing Tasks/Milestones for Version 5.3
  ...the integrity of the data received from the Microsoft Project or Microsoft Excel plan that provided the task/milestone’s original '''Start''' and '''Finis
  7 KB (1,167 words) - 21:24, 3 May 2016
• Labeling Task/Milestone Dates for Version 5.3 (OnePager Express)
  ...''' data imported from the Microsoft Excel plan. Every task in a Microsoft Excel plan has a designated '''start and finish date'''. A milestones’ '''start
  6 KB (853 words) - 16:14, 13 July 2016
• Percent complete for Version 5.3 (OnePager Express)
  ...ential that these data be properly represented in the associated Microsoft Excel plan before the data are imported to OnePager Express ('''OPX''').
  6 KB (862 words) - 15:28, 15 March 2016
• Baselines for Version 5.3 (OnePager Express)
  ...sential that the associated data be properly represented in your Microsoft Excel plan before the data are imported to OnePager Express ('''OPX''').
  10 KB (1,513 words) - 14:37, 15 March 2016
• Deadlines for Version 5.3(OnePager Express)
  ...ith '''Start and Finish dates''', a '''deadline date''', and the Microsoft Excel '''Show It''' column set to yes so that OnePager imports the data for all t ...me resembling a '''Deadline date''' column you specified in your Microsoft Excel spreadsheet.
  8 KB (1,241 words) - 15:55, 15 March 2016
• Endpoints for Version 5.3 (OnePager Express)
  The initial association of '''Endpoints 1 through 4''' to Microsoft Excel columns is determined from your initial '''template''' settings input to On ...ow whereby you may configure the '''endpoint''' association with Microsoft Excel spreadsheet columns.
  7 KB (1,032 words) - 16:35, 15 March 2016
• Zebra Striping for Rows and Swimlanes for Version 5.3 (OnePager Express)
  ...hem, or through reconfiguring rows and swimlanes by changing the Microsoft Excel column driving the configuration, OnePager will automatically re-stripe the
  4 KB (631 words) - 22:02, 3 May 2016
• Linking Tasks and Milestones (Adding, Deleting, Modifying) for Version 5.3
  ...does not import dependency information from Microsoft Project or Microsoft Excel.
  6 KB (849 words) - 21:28, 18 March 2016
• Task Bars Tab for Version 5.3 (OnePager Express)
  ...based on''' radio button allows you to select a column from your Microsoft Excel plan to assign a data driven '''color''' to each task. ...'' can display the '''date imported from any date column''' from Microsoft Excel. These properties are controlled essentially the same way as described abo
  7 KB (1,061 words) - 14:33, 9 April 2020
• Milestones Tab for Version 5.3 (OnePager Express)
  ...lor'''. In this option, clicking the dropdown provides a list of Microsoft Excel plan columns from which to select. ...is the same for task related '''deadlines''', also allows control over the Microsoft Project plan column that controls the symbol '''color''' and the symbol's '
  8 KB (1,170 words) - 14:36, 9 April 2020
• Legend Tab for Version 5.3
  ...s based on the name of the column from your Microsoft Project or Microsoft Excel plan you selected for '''Gantt Bar/Milestone Fill Color''' on the '''Task B ...'''automatic title''' may also reflect your Microsoft Project or Microsoft Excel plan columns used for '''color or shape''' in '''conditional formatting'''.
  12 KB (1,715 words) - 15:46, 27 May 2016
• Advanced Tab for Version 5.3 (OnePager Pro)
  ...he '''task/milestone name''', and the '''Unique-ID''' of the task from the Microsoft Project plan. An example is shown below. 2) To avoid confusing OnePager Pro when importing additional Microsoft Project files during the '''Replace''' operation, it is necessary for this
  16 KB (2,353 words) - 15:28, 22 September 2016