Home

JCVGantt Pro 3.2

1. 0 0 The Resource Usage Spreadsheet 2 2 ee ee ee The Total Cost Spreadsheet 2 2 CopyaUserSheet 2 2 ee ee ee Work with Baseline Snapshots Delete a Snapshot ganna amp cee ROMS RAS M eR OSS Example Using a Snapshot in a Spreadsheet Formula Work with Gantt Parts Save a Gantt Part 4 ae KGAA EEE EDR DD OS Insert a Gantt PartintoaGanttchart 2 2 0084 Insert a Gantt Part in a Specific Location o a aaa Manage Gantt Part Folders o aaa a Export Data to External Programs Setting Parameters 105 V vi Table of Contents 12 13 14 Import From Earlier Versions ofJCVGantt 04 Dress Up the Gantt Chart Using with MindManager Differences in Durations 2 1 1 ee Relationships a sar Saree oS S Ga ee ae Raee e eo Cee a Creative Ideas Quick Start with Templates o eee Hyperlinked Projects Board o oaa Executive Status Board aaa Hyperlinked Status Board o anoaaaa 108 109 116 TABLE OF CONTENTS VII viii Table of Contents 20 Minute Quick Start We suggest the first thing you do after installing JCVGantt Pro 3 is to study this chapter In 20 minutes this tutorial walks you through all the major features of JCVGantt Pro 3 To begin open JCVGantt Pro 3 by clicking on it s launch icon After a Welcome screen appears click Start JCVGantt Pro 3 and this screen should appear
2. Fea e pe Show Refresh Sync topic Show Branch BI Users What s JCVGantt notes inJCVGantt lin JCVGani Guide New J Gantt Pro Help Hide the current selected topic branch and all child topics in JCVGantt Display the current selected topic branch and all child topics in JCVGantt Synchronize topic notes in JCVGantt with those in MindManager If not selected then don t show or synchronize notes in JCVGantt Refresh data in JCVGantt with new data in MindManager Used rarely only in special cases Display the current map as project data in a new instance of JCVGantt Pro 24 5 Minute Quick Start for MindManager Users In MindManager select a Topic and then click Show Branch in JCVGantt Next idea LL 4 gt d Write a user s manua then click Show JCVGantt Next idea JCVGanitt Pro will load behind MindManager 7 This allows you to continue brainstorm ing in MindManager while JCVGantt will loyally copy down everything you type as new Gantt tasks USING MINDMANAGER WITH JCVGANTT PRO3 25 Tip You can use ALT TAB to switch back and forth between JCVGanit Pro 3 and Mind Manager In MindManager in the center topic type Things I need to do this week Start In the Tools menu start MindManager s brainstorm mode sala Your screen will look like this Step 1 Enter all your ideas Step 2 Define groups to prioritize Step 3 Drag your ideas fro
3. Switch menus to the Add ins menu 7 ag Home Task Format View Tools Add Ins Snapshots User Sheets Commands JCVGantt Pro 3 User s Guide Ej 12 20 Minute Quick Start QA User Sheets Click the User sheets icon and select Add user sheet Add user sheet User 5 mands A blank spreadsheet opens and a new tab appears User sheet 1 B l Se joo Mi cost User sheet 1 Right click in cell A1 and select Paste Link The amounts you copied appear along with a red square in the upper right corner of each cell User sheet 1 nn as 1 300 00 2 450 00 Double click one of the red squares and you ll see the formula that is used to calculate the value in the cell 5 2 450 07 ADD COLOR 13 Press Enter and notice that the cell reverts to the value of the formula Now select cell A3 and type SUM A1 A2 then press Enter The cell calculates the sum of A1 and A2 User sheet 1 a B 300 00 450 00 DJ MI In the Resource spreadsheet change the value of Cost of wood then press Enter Now go back to the user sheet You ll see that the Cost of wood value in the user sheet reflects the change you just made in the Resource spreadsheet In this manner you can create your own real time calculations from any data you find in the Projects or Resource spreadsheets Add Color Now we ll examine a few other features Go to the Gantt chart and select the Color
4. 0 aaa 35 Mouse Actions 44 464 a a a 38 Change the Project View oaaae 40 iv Table of Contents Set the Display Size ee 41 Scroll Through the Timeline 2 aaa 43 Customize Parameters 53 ONS De e ea a Ghee ao ot oe E 55 Calendar Tab Biase oe wee ee oo RGR EES HEE Ee Ss 56 Multiple Calendars lt 2 G 2 CER awe Chee be eRe ees 59 Work with a Tablet PC or Vista 62 INK GESTES ss oe ab heee Bahra eee de PaaS eae 4 64 Work with Resource Pools 66 Edit Resource Pools 4 2 4 4 b eSB Gow ROS GES SaaS TES Beas 68 Work with Spreadsheets 71 FOUMAPCOIIS e oo a Gu Ges ha GS Soe Se a Se ae Ss 71 Add a Formula to a CEN cue howe eee ew ee SESS ews 72 List of Excel Compatible Functions 0 000000 ee 74 Customize Fields as 2 oad amp wd od oe ey ee SA So ee he J3 Rename Fields Beane gewe Soe ee ea Sea ea oe ey ee 75 Create Drop Down Lists a aaa 76 Hide Fields ick a og eee a oe Be bw nane eeki ka 76 Change the Position ofa Column 2 ee ee ee 76 Resize COMMNS 2 65584 Su Ge ea eee oe oe ho Se ee Gs 71 Use the Shortcut Menus 2 2 6 ee ee ee ee 77 POC so oo be oe ew eae ee et he oe eee we eo oes 78 Change the Cell Type 2 79 The Project Spreadsheet nn anaua 80 Edit the Project Spreadsheet naaa 80 10 11 TABLE OF CONTENTS The Resource Spreadsheet 2 1 ee es RemoveaResourceFromaProject 1 eee eee ee Display Resource CostsontheGanttChart
5. Default currency unit Days in a week Days in a month Default duration unit Day il Show Resource Cost Save Autorecover info every Date format Select the date format to be used in the grids and throughout the program Default currency unit Specify the unit displayed for currency items Default duration unit Set the default unit hour day week and year that the application uses to indicate task duration Regardless of the setting here you can change the setting of any individual task Show Resource Cost When selected the cost of each resource is displayed in the Gantt chart Hours in a day Specify the number of hours in a typical workday The default is 8 Days in a week Specify the number of hours in a typical workweek The default is 5 Click the OK button to save your changes FONTSTAB 55 Fonts Tab The Fonts tab allows you to set the font used by four items in the spreadsheets Fant SIZE Colors Background n Foreground Print task notes a Print task notes title E Italic Bold Sample text JCVGantt Pro 3 User s Guide Ej 56 Customize Parameters To define a font 1 Inthe Item list select the item for which you want to define a font using the following as a guide Group Tasks The font used for tasks that have subtasks also called parent or summary tasks Tasks The font used in task rows Resources The font used in resource rows Default
6. Deiat m Hours in a day Default currency unit Days in a week Days in a month Default duration unit Day Show Resource Cost Save Autorecover info every Resource costs display on the Gantt chart On the Gantt chart stretch any task bar Resource costs are instantly recalculated 0 JCVGantt Pro 3 User s Guide Ej 88 Work with Spreadsheets Carpenter 1800 00 Painter 200 00 The Resource Usage Spreadsheet The Resource Usage spreadsheet shows you the resource usage in all the projects in a particular pool It displays the number of hours per day each resource has been allocated to a task You cannot edit this report but you can copy and paste the information it con tains into another spreadsheet Gray rows indicate the resources of the current resource pool Color coded boxes indi cate the number of hours a resource has been allocated as shown in the table below Resource Is free for the number of hours Indicatec boxes indicate the number of hours that have not been assigned to a resource as shown in the table below Holiday or other non working day No tas Number of hours for which a task is unassigned Day o The Resource Usage spreadsheet tells you instantly whether resources are overloaded or under loaded based on the information in the current project as well as all other projects in the project pool You can see at a glance if other projects are using the resources in your c
7. User s Guide JCVGantt Pro 3 2 Gantt Solution com JCVGantt Pro 3 User s Guide by Charles Guerin third edition Original edition edited by Lyndsey Amott 2007 Gantt Solution Inc and Charles Guerin Management Inc All rights reserved Published simultaneously worldwide All rights reserved No part of this publication may be reproduced in any form or by any means without permission of the author Reproduction or translation of any part of this work beyond that permitted by sections 107 and 108 of the U S copyright law without permission is unlawful It is understood that papers submitted for publication have not been previously and will not be simultaneously published elsewhere If accepted for publication papers will not be published elsewhere in any language without the written con sent of the author We assume no responsibility for statements or views expressed in articles that appear on this site Copies can be made for personal or educational uses his consent does not extend to other kinds of copying such as copying for general distribution for advertising or promotional purposes for creating new collective works or for resale Mindjet and MindManager are registered trademarks of Mindjet LLC SmartMapX and SmartMapX Technology are trademarks of Mindjet All other trademarks are property of their respective owners JCVGantt is a registered trademark of Gantt Solution Inc Charles Guerin Management Inc p
8. Buy the deck plan task Switch back to the Task menu and click the Color icon button Color A color palette appears Eii cna E EEM EHET EEE E m8 i f BEN BREED EN BEE EE EBEREEEEE CLL ial in JCVGantt Pro 3 User s Guide Ej 14 20 Minute Quick Start Select the color orange and click OK The task bar color changes to orange Buy the deck plan Da Now on your own use this feature a few more times to color code your plan Build a deck ZB Buy the deck plan Buy the wood Find carpenter Build the deck Add Notes to a Task The Task Notes feature allows you to link any information to a selected task Select Buy the deck plan then using the mouse point to the Task note a Task note icon at the bottom of the screen The Task note window opens i AA l oa al ADD NOTESTOATASK 15 Type www deckplans com ea h A lp se Now select the words you ve just typed and click the Hyperlink icon The Hyperlink window appears Hyperlink Enter URL or File name Hyperlink http Sawai deckplans com Lj Advanced settings Link name wi deckplans corn Arguments IF the hyperlink contains a command e g an Exe File vou can add additional command line arguments here In the Hyperlink field type http www deckplans com and click OK In the Task notes window add some text Format the text using the desktop publishing J
9. buying the wood is dependent on the purchase of the deck plan To create a dependency we ll multi select the tasks Press CTRL and select Buy the deck plan and while continuing to hold the CTRL key select Buy the wood It should look like this Prior Tree Wed 28 Thu 2 Build a deck I I Buy the deck plan ll r Buy the wood cdf Delete task Unk gi Unlink Click the Link icon SUMMARY TASKS The chart changes to look like this 5 Prior Tree Wed 28 Thu 29 Fri 30 a oo Build a deck Buy the deck plan Buy the wrood Notice that the Buy the wood task bar automatically shifts to the right This is because JCVGantt Pro 3 now knows that you intend to buy the wood after you ve got the deck plan Summary Tasks Notice that the Build a deck task bar now stretches across two days The Build a deck task is a summary task Summary tasks indicate the total amount of time allotted to the sub tasks Typically company executives prefer to see executive summary charts which display only the summary tasks You can create an executive summary chart by clicking the minus icon in the task pane to hide the details of the main tasks Click the plus l icon to reopen the view Now let s say that it takes you two days to find the deck plan perhaps you needed two days of research on the Internet to find the right plan Let s write that on the Gantt by grabbing the right side of the
10. 3 User s Guide 30 5 Minute Quick Start for MindManager Users Enjoy the freedom to work in either program you can shift back and forth at whim and your data will be saved In MindManager in the JCVGantt Pro ribbon tab you can choose which branches you wish to show or hide in JCVGantt using the Show Branch in JCVGantt and Hide Branch in JCVGanit icon buttons Select any branches that you wish to show or hide then click the show or hide icon and those topics will be displayed or hidden as appropriate in JCVGantt Pro 3 The exception to this rule is the Central Topic which is not visible in JCVGantt and therefore has no visibility setting Note one rule though any topic that is marked as Show Branch in JCVGantt will automati cally display its parent topics as summary tasks in JCVGantt The reason for this is that a hierarchal relationship in a Gantt chart implies that a parent has a summarizing relationship with its children that must be maintained When adding a new Topic to the Central Topic the default visibility setting is Hide Branch in JCVGantt When adding subtopics a subtopic is added with no visibility setting of its own and if for ex ample its parent is hidden from JC VGantt the newly added subtopic will also be hidden from JCVGantt The visibility setting of a subtopic may be set later on using the Show Branch in JC VGantt and Hide Branch in JCVGantt icon buttons Getting Sta
11. CHART 33 Float time also called lag time or slack time is time that is scheduled for mishaps and delays Float times are indicated on the Gantt as extensions to the dependency lines Dependency with float time or lag time indicated JCVGantt Pro 3 User s Guide 34 Getting Started The JCVGantt Pro 3 Window JCVGantt Pro 3 sports the new Windows Vista ribbon interface which merges toolbars and menus into a single tabbed ribbon 5 basic menus called Home Task Format View Tools and Add ins group functions together so that they re easy to find If you re editing a task odds are you ll find a useful function in the Task menu If you re formatting a user sheet check the Format menu To change what you see look in the View menu The Add ins menu is a place where additional functions and third party developers can add their own new functions to JCVGanit Pro 3 The Pane Areas The basic window pane structure is shown in the illustration below You will find it helpful Quick Access Menu File function menu Menu Selegtor tabs or oh f Delmi VinPro 3 X 9 Home Tak Format ow Tools Options uiii 3s a a ON a 100 jen ea ro Thre me ice Pa ge gt Tab to launch Gantt 8 jump ioceedediask Yo Gini Chae Pane Resourses FieldName Project Tetalcost Rercunme image Zeomla Zoom Oat EN Fit Gani Retnedh Tank Tree language Parts Pane Fa thew current diie Yo Ghibu Bar n Splitter bar z Project vie
12. Frei gt A I DIN Stain deck icon at the bottom of the screen The Task Note window opens 64 Work witha Tablet PC or Vista Ink Gestures Help q Mew task same level Copy O New task Paste Delete task zoom in ut oom out Many common actions can be done rapidly in JCVGantt Pro 3 using ink gestures These actions include adding new tasks adding subtasks copying tasks pasting tasks deleting tasks cutting marked parts INK GESTURES 65 These actions are performed using the following ink gestures These are the same gestures used in MindManager 7 JCVGantt Pro 3 User s Guide Work with Resource Pools Working with Resources In a project a resource is anyone or anything that aids the project JCVGantt Pro 3 lets you list the people involved in a project and the components you need to purchase in order to make the project happen In general resources have a cost a schedule and a load For example a lawyer might charge 150 per hour be available for one week and be able to work at 50 load In a typical 40 hour week this would mean 20 hours or 3000 lawyers eh Oct 2005 Prior Tree ini roe ep 03 10 2005 Legal Stuff I Lawyer 3000 00 Or you might build a house that requires a 10 000 roof that takes two weeks to build Most project managers handle several projects at the same time often with the same people working on different project
13. a thumbnail Event Planning Tree Analysis for example a popup appears FHEA Failure Modes and displaying all the tasks associated with the item as Planning shown below Event Tree Analysis FTA Fault Tree Analysis Planning Trigger Causes event Risk Consequences Planning Causes outcome causes event Causes outcome causes event Causes outcome Causes event Ad Risk Damage Planning Risk Likelihood Planning fe ollie He i yrs TIEE E STE ea E Fi J Da E d DE Risk Types cae Planning What If Analysis Pe ete Planning Do one of the following Drag a Gantt Part thumbnail into the Gantt pane The tasks associated with this Gantt Part are added to the tree pane and the Gantt pane displays a colored bar for each task in the Gantt Part Double click the Gantt Part that is to be inserted The tasks from the Gantt Part are inserted on the day after the last day of the project JCVGantt Pro 3 User s Guide Ej 98 Work with Gantt Parts Insert a Gantt Part in a Specific Location To insert a Gantt Part as a subtask Drag the Gantt Part to the Gantt pane adjusting the Gantt Part s position until the parent task in the task pane is highlighted The tasks from the Gantt Part are inserted on the same day as the parent task Week 37 Sep 2005 Prior Tree Mon S iit Tue 6 3 task_32 task_1 Jb task_11 Jb task_12 a i t te 7 I
14. before printing lt lt In the File functions menu select Print Preview a lt Use the buttons on the toolbar to examine the document Click Close Manage files Create a New Project To create a new project Do one of the following In the File functions menu click i ee On the Quick Access toolbar click the New tal icon Press Ctrl N The Create New Document window opens Create new document Choose a type of document you want to create ICV document MindManager 6 map MindManager 7 map MindManagerX5 map XML document Za Choose one of the four document types If you have MindManager installed on your machine you can also work with MindManager files If you choose MindManager SCROLL THROUGH THE TIMELINE 49 6 or MindManager 7 all project data is stored in their files Click Ok A blank Gantt chart opens Open an Existing Project Do one of the following In the File functions menu click Press Ctrl O The Open window displays In the Look In field navigate to the folder that contains the file you want to open Select the file then click Open Save a Project To save a project Do one of the following In the File functions menu click Save On the standard toolbar click the Save Document al icon Press Ctrl S If the project is new the Save As win
15. so to MindMan ager s keystrokes so that MindManager users will feel comfortable brain storming tasks and activities in JVCGantt Pro 3 Usersheet Commands The following keyboard commands can be used in the user sheets JCVGantt Pro 3 User s Guide 52 Getting Started View Recent Files In the File functions menu by default the right panel shows Recent files The system displays most recently opened or saved documents Exit JCVGantt To Exit JCVGantt Do one of the following In the File functions menu click Exit D Frint J Parameters gt et ee ieee Click the X in the upper right corner of the main window If this is a new document or if you ve made changes to the document you ll be asked to save it If you do not save it yor changes will be lost 53 Customize Parameters The Parameters Dialog Many project management related variables can all be set from one place the Parameters dialog These variables many aspects of the program including the appearance of graphs and grids calendaring calculation formulas used To open the Parameters dialog Inthe File functions menu select Parameters S Print X Exit Main Tab The Main tab in the Parameters window allows you to set a variety of program wide variables 54 Customize Parameters Parameters Date format Default Hours in a day
16. the left hand slider or is it easier to double click the Percent done icons in MindManager We re not sure Our software developers prefer seeing the percent done in the Gantt chart but most managers seem to prefer the convenience of the double click icons in MindManager Choose your favorite Filtering In MindManager s Task Info pane you can filter the tasks so that you can look at the in formation in unique ways 7 aa z Home Task Format View Tools Options Add Ins s Sync Line Color Syne Fill Color Sync Color Sync Rules 112 Use JCVGantt Pro3 with MindManager When coupled with JCVGantt Pro 3 this feature can produce some amazing views of a project For example this filter setting would show only tasks starting today that end this week that are greater than 5 hours in duration Power Filter Map Markers Starting m Today 2 Task Information v Ending 2 Review Information This Week z Duraton Other Topic Properties r E ja Greater Than AG DIFFERENCES IN DURATIONS 113 Differences in Durations MindManager can currently display only integer non decimal durations JCVGantt Pro 3 however does store decimal durations It even tricks MindManager into storing them but unfortunately not into displaying them You can use the h d and w hours days and weeks notation in either program Some math for you 3 5 d is t
17. 05 15 127 P G oF plan 400 00 Mov 2005 1 2 a 4 5 6 z ra J 10 11 jl2 13 jl4 15 16 i7 18 J19 j0 jl jee jes j4 j5 j0 j7 26 10 11 2005 a Cost of plan 400 00 Click on the timeline and turn the scroll wheel on your mouse The timeline scrolls to the right or left depending on the direction you turned the wheel SAVEAPROJECT 21 Save a Project to view the File menu A Save As Click The Save As window appears In the File name field type a name for your project and click Save JCVGantt Pro 3 User s Guide Ej 22 20 Minute Quick Start Print a Project Do the following Inthe File functions menu select the arrow to the right of the word Print Select Print Preview to view a preview You can then click the Print button to print P New Print x Print D open 2 ow Print Options Save iia ve s ss g Print Preview SI Save As a Print task notes Close aS Import Export E Properties Print gt 5 Minute Quick Start Using Mindmanager with JCVGantt Pro 3 Using DynaSync technology changes you make in MindManager are shown im mediately in JCVGantt Pro 3 and changes you make in JCVGantt Pro 3 show up immediately in MindManager Here s how you do it First start MindManager Pro 7 You ll see a new ribbon bar labeled JCVGantt Pro o D EHQI 0 Mindjet Mind Home Insert Format Review View Export Tools JCVGantt Pro
18. 05 Setup Charge 750 00 2 4 35 30 09 2005 03 10 2005 Technicians Fee 1600 00 5 J 04 10 2005 04 10 2005 0 00 6 22 09 2005 22 09 2005 0 00 L 1 2 3 Purchase labels 3 day s 4 Mix Oil and Store 1 day s 5 Setup Bottling machine 1 day s 6 DofRun 8 000 bottles 2 dayfs if Run Complete 0 days Hina i 9 10 11 12 13 14 15 16 P P f p O CECGOEG 19 20 21 22 23 24 26 27 28 29 Here are some of the things you can do in the Projects spreadsheet Create new tasks by clicking the Insert button on your keyboard Double click a cell to change the data in it Slide and hide fields Edit the Project Spreadsheet To create a subtask or a new task Do one of the following To create a subtask click a task name then press the Insert button on your keyboard To create a new task click a blank row in the Task Name column then press the Insert button on your keyboard EDIT THE PROJECT SPREADSHEET 81 To edit a task 1 Inthe Task Name column double click a task name The Task Properties window opens 2 In the Task Properties window make the required changes then click OK For instructions on using the Task Properties window see Modify Task Properties 0 To change a task duration 1 In the Duration column double click the cell that is to be modified 2 Change the duration value indicating d for days w for weeks or m for months 0 To add a priority
19. 5 0 00 234 00 7 tak 0 00 000 a task o pol mw g er ea 10 Subtotals 59 00 635 20 TE pO 12 Total Project Cost 6954 20 OOOO The Fixed column sums all resources that were marked in the Gantt chart as fixed The Variable column sums all resources that are paid on an hourly daily weekly or an nual basis COPY A USER SHEET 91 Copy a User Sheet Although you can t edit the Total Cost spreadsheet because its data is based on data from the Gantt chart you can copy the data and paste it into your own custom spread sheets There you can make any changes you require To copy to a user sheet 1 Select the cells then right click and select Copy The cells are copied to the clipboard 2 Click the User Sheets Se icon and select Add User Sheet A user sheet opens 3 On the user sheet right click and select Paste The Total Cost data is entered into the user sheet You can now create your own calculations based on the data from the Total Cost report Any changes you make in the Project spreadsheet are reflected in the Gantt chart and vice versa JCVGantt Pro 3 User s Guide 92 Work with Baseline Snapshots Baseline snapshots allow you to see how the time and money have shifted from the budgeted amounts to the actual amounts The multiple base lining feature allows you to get a true picture of your project budget as it evolves The number of snapshots you take depends on the require ments
20. 5 D a Buy ere D EFees 3 rials 1013 10 13 Hrne L 1 hours r Ae dla ET Buy Paint s 1013 10 13 i f Fea Pa R Paint W do Studwork Note FS SF FF and SS indicate Finish to Start Start to Finish Finish to Finish and Start to Start relationships For more information see Dependency Management 115 JCVGantt Pro 3 User s Guide Ej 116 Creative Ideas Quick Start with Templates MindManager comes with zillions of excellent best practice templates to get you off to a running start To open a MindManager template 1 In the Quick Access menu in MindManager click the down arrow to h the right of the New icon i The New Map window opens Default Map S Create a new map based on the default map template From Styles and Templates es Create a new map based on your favorite style or template From Existing Map Create a new map based on 7 an existing map 2 Select From Styles and Templates The New map dialog opens 3 Select the Map Templates tab then select the template you d like to use to start a new project HYPERLINKED PROJECTS BOARD 117 _ j Style Templates Map Templates Choose map Add Map Template New Blank Map Basic org chart Company organization Decision making Department personnel 4 Click OK Select the central topic in the map and on the JCVGaintt ribbon bar click Show in JCV Gantt Pro then click t
21. Buy the deck plan task bar and stretching it to the right by one day 7 Week Tree Wed 23 Thu 24 Fri 25 Sat 26 Sun 27 Mon 28 Build a deck a Buy the deck plan ae ae Bun the woog 3 23 2007 Oh a EELU hi h JCVGantt Pro 3 User s Guide Ej 5 6 20 Minute Quick Start When you release the mouse you ll see that the bars have moved to the right and that the summary bar stretched with it F Week 22 I Tree Wed 23 Thu 24 Fri 25 Sat 26 Sun 27 Mon 28 Tu 15 26 2007 Build a deck EEE Buy the deck plan Buy the wood i Set Duration Try grabbing the center part of the top bar and dragging it one day to the right F Week 22 May 2007 Tree Wed 23 Thu 24 Fri 25 Sat 26 Sun 27 Mon 28 Tue 29 5 24 2007 15 29 2007 Build a deck Buy the deck plan Buy the wood You ll notice that in the above example we moved the start day from Wednesday to Thursday and since our plan is now three days long we crossed a weekend JCVGantt Pro 3 automatically assumes that you don t work on the weekend so in this example it put the end date on Monday This is one of the calendaring features you ll read about in this manual On your own add the following tasks underneath Buy the wood Find carpenter Carpenter builds deck ij Delete task Use Control Mouse Click to select the new tasks then click the Link icon again to link the new tasks to Buy the wood gi Unlink sin
22. CVGantt Pro 3 User s Guide 3 16 20 Minute Quick Start icons in the toolbar ask note Je a amea adatod g f ql l A B viz Create a Template e Any plan you create can be reused in other proj ects In the Task menu find the Gantt Parts group and click the Save all tasks as Gantt Part icon a Save selected tasks as Part The Save as Gantt Part window opens i Gantt Parts Fa Save as Gantt Part Cx Select folder to store Gantt Fart Name your new Gantt Part CREATE A TEMPLATE Click Select folder The Browse for Folder window opens Browse For Folder Select folder to place Gantt Part di gantt parts di Building Blocks di Initiation di Planning and Risks di Planning Models di Xtras Select the Samples folder then click OK In the Name your new Gantt Part field type Build an entire deck and then click OK Save as Gantt Part Select folder to store Gantt Part Name your new Gantt Part Build an entire deck The project is saved as a Gantt Part At the right side of the screen click the Gantt Parts JCVGantt Pro 3 User s Guide Ej 17 18 20 Minute Quick Start icon then click the thumbtack icon to keep the window open Gy i rr rr T a cr i In the Gantt Parts window expand the Gantt Parts folder then select Samples Notice that Build an entire deck appears in the bottom half of the Gantt Parts window ee Backgrou
23. II ASCNCIIFMAMI I A JCVGantt Pro 3 User s Guide Ej 42 Getting Started Single year Weeks in month Days in month Single week Hours in a day Additionally the aes button sizes to the nearest unit size that fits the entire Gantt chart into the current screen size area SCROLL THROUGH THE TIMELINE 43 Scroll Through the Timeline Depending on the zoom setting or the size of the project you might not be able to see the entire Gantt chart on your screen To see the hidden parts of the screen Click the timeline then turn the scroll wheel of your mouse The timeline moves back and forth according to the direction you turned the wheel JCVGantt Pro 3 User s Guide 3 44 Getting Started Keyboard Shortcuts The following four basic keystrokes will come in handy as you use JCVGanit Pro 3 Change the Start Date of the Project To change the start date of a project y lt lt In the Tools menu select Change start date of project The Change Start Date of Project window opens Change start date of project E Start date 5 24 2007 4 May 2007 Sun Mon Tue Wed Thu 24 1 2 3 6 8 9 10 13 15 16 17 20 22 23 faa Zi 8 29 30 l 3 5 6 i B e LO i un on amp A lt Click the arrow button beside the date field A calendar showing the current month appears lt lt Select a new start date To see a different month click the left or right arrow butto
24. In the Priority column double click the cell that is to be modified A priority number appears The priority number increments by 1 each time you double click the cell To indicate the percent done Inthe Percent column double click the cell that is to be modified A marker indicating the percent done appears in the white square each time you dou ble click the cell To change the start or end date Inthe Start Date or End Date column double click the cell that is to be modi fied Do one of the following To change the entire date simply start typing To change the date one number at a time click once on a number in the cell Change the number then if required use the arrow keys on your keyboard to move to a different number JCVGantt Pro 3 User s Guide 3 82 Work with Spreadsheets To select a date from a calendar double click the cell A calendar appears from which you can select the new date To edit resources 1 In the Resources column double click the cell that is to be edited The Task Properties window opens 2 Inthe Task Properties window make the required changes then click OK For instructions on using the Task Properties window see Modify Task Properties 0 To edit costs You cannot edit costs in the Project spreadsheet Costs can be edited in the Re sources spreadsheet the Resources tab For more information see To change data in the Resource Name Cost or Load column EDIT
25. NSERT A GANTT PART IN A SPECIFIC LOCATION 99 To insert a Gantt Part after a task Drag the Gantt Part onto the Gantt chart until the selected date and task are highlighted Week 37 Sep 2005 Prior Tree Mon 5 Tue 6 task _ task_1 BD task_11 AL task_12 2 task aa EL m m To insert a Gantt Part before the first task Drag the Gantt Part onto the Gantt chart and position it above the first task Week 37 Sep 2005 Prior Tree Mon 5 Tue 6 task_1 De r task_11 G _ 4 task 12 task_2 task _ 32 task_ wubee To insert a Gantt Part on any date after the last date of the project Drag the Gantt Part onto the Gantt chart and position it over the empty space at the end of the project Note If you selected a non working day to insert the Gantt Part the tasks are inserted on the next available working day JCVGantt Pro 3 User s Guide Ej 100 Work with Gantt Parts Manage Gantt Part Folders You can add or remove folders in the Gantt Parts window by right clicking any folder ex cept the Backgrounds folder To add a folder 1 Inthe Gantt Parts window right click a folder then select Add folder The Folder Name window opens Create new folder Name your new Gantt Parts folder In the Input Folder field type a name for the folder and click OK The folder is added as a sub folder to the selected folder 0 To remove a folder 1 Inthe Gantt Parts window right click a fo
26. THE PROJECT SPREADSHEET 83 To change a dependency type 1 In the Depend column double click the cell that is to be edited 2 Type the row number at the far left of the spreadsheet of the task on which this task depends Type the dependency type as follows0O FS for a finish to start dependency SF for a start to finish dependency SS for a start to start dependency FF for a finish to finish dependency Changing the dependency type automatically updates the Gantt chart To add or edit a link 1 In the Link column double click the cell that is to be edited or to which you want to add a link 2 Type a new link To edit the Issue Details Recommend or Show column 1 In the appropriate column click once in the cell that is to be edited An arrow button appears 2 Click the arrow button then select the appropriate name from the list or type a new name To create your own columns See Create Fields JCVGantt Pro 3 User s Guide Ej 84 Work with Spreadsheets The Resource Spreadsheet The Resource spreadsheet allows you to edit resource related information Resources Sy Hesource Name Cost EI Studs 500 00 flat 100 00 aa Gyproc 650 00 flat 100 00 Faint 4120 00 flat 100 00 P Carpenter 30 00 hourly 100 00 C5 Painter 50 00 hourly 100 00 The Resource column lists either the name of a person who adds costs to the project or the name of an item that adds costs to the project Th
27. The Save as Gantt Part window opens Save as Gantt Part Select folder to store Gantt Part Select folder Name your new Gantt Part x cancel 1 Click Select Folder The Browse For Folder window opens 96 Work with Gantt Parts Browse For Folder Select folder to place Gantt Part di gantt parts gt D Building Blocks uid Initiation di Planning and Risks gt di Planning Models di Xtras Make New Folder _ Do one of the following Select a folder Click Make New Folder then type a folder name Click Ok In the Name your new Gantt Part field type a name for your Gantt Part Click Ok Insert a Gantt Part into a Gantt chart To insert a Gantt Part into a Gantt chart 1 At the right hand side of the application window click Gantt Parts If you do not see the Gantt Parts icon open the View menu and select Toolbars then select Gantt Parts The Gantt Parts window opens In the Gantt Parts window navigate through the folders and select the folder that contains the required Gantt Parts The Gantt Parts in the selected folder display as thumbnails in the lower part of the window INSERT A GANTT PART INTO A GANTT CHART 97 antl Parks i Backgrounds Gantt parts Building Blocks 7 Initiation 17 New Folder Planning and Risks Risk Analysis and Assessment Strategic Planning H 1 Planning Models 7 Samples Event Tree Analysis If you point the mouse over
28. The font used throughout the program in all other situations 2 Under Font select the font name and the font size 3 Under Colors select background and foreground colors 4 If required select the Italic or Bold check box or both Click OK Calendar Tab The Calendar tab allows you to specify how the system calculates nonworking times and dates Parameters cs Man Fonts Calendar Select active calendar clr May 2007 b Set selected date s to S MTWTFS Use default 1 2 3 4 5 Nonworking time 7 8 9 10 11 12 Nondefault working time 13 1415 16 17 18 19 From To 20 21 22 23 24 25 26 08 00 17 00 A7 28 29 30 31 14 00 18 00 00 00 00 00 CALENDARTAB 57 Edit the Length of Working Days and Add Holidays The calendar displays the current month If you have a company holiday or a Saturday where you expect to work you can use the Set selected date s to area of the window to mark specific dates as working or nonworking The standard working day in JCVGanitt lasts 8 hours with two hours for lunch 08 00 12 00 14 00 18 00 You can change the length of a standard working day the length of the nonworking hours and you can set holidays and nonworking days To change the length of a standard day Select the date on the calendar and then select the Nondefault working time option Next enter the From and To time ranges in the From and To fields You may enter up to three time ranges per day whic
29. a prominent location Hyperlinked Status Board Track your subordinate s to do lists and personal tasks Hyperlink multiple MindManager maps to one central MindManager map then ask your managers or subordinates to link you to their personal status boards This gives you the luxury of being able to assign Next actions to them which they ll see the next time they open their Gantt chart HYPERLINKED STATUS BOARD 119 JCVGantt Pro 3 User s Guide 3 Gantt Solution com
30. add and remove calendars Import allows you to read a calendar definition XML file into the project Export allows you to export a calendar definition file to an XML file that you can share with other project managers Add new allows you to create new calendars and then adjust working and non working time as well as your week templates Remove allows you to remove a calendar from the project One handy use for the XML import export format is for JCVGantt users to be able edit and share their own unique schedules with project managers Import a Calendar To import a calendar 1 Click the Import button The Open window opens 2 Select a Calendar file 3 Click OK The calendar is added to the list of calendars in the Select active calendar field You may now use the other editing functions in the Calendar tab to edit the calendar you ve imported JCVGantt Pro 3 User s Guide 60 Customize Parameters Export a Calendar to XML To export a calendar to XML L In the Select active calendar field click the arrow button then select the calendar that is to be exported Click the Export button The Save as window appears In the File Name field type a name for the calendar Click OK The file is saved as an XML file MULTIPLE CALENDARS 61 Create a Calendar To create a calendar 1 Click Add new The Create New Base Calendar window opens Create New Base Calendar Choose name VARE d Create a new
31. an i l z ipi g A Pe J m y a Far at Biik Ferran Yates Tea agiri Week 2P Jen Sar L Euh jmmy eo w H 2 20 Minute Quick Start Create Tasks Click the New Task icon Anew task and task bar appear on the chart Double click New Task You can now edit the text New task mel Type Build a deck then press Enter Click the New Task icon Double click the entry and type Buy the wood Press Enter then press Enter a second time A new task is added at the same level CREATETASKS 3 Now instead of double clicking just tyoe Buy the deck plan The task name is changed instantly Your screen should look like this Tree Build a deck Buy the wood Buy the deck plar Since you d probably buy wood after you buy the deck plan lets move Buy the deck plan Switch menus to show the Task menu Ty Osa ailas Home Format Shift up Shift down OQOutdent Indent Move Task hift up Click the Shift Task Up i icon or press ALT SHIFT UP ARROW JCVGantt Pro 3 User s Guide Ej 4 20 Minute Quick Start Your plan should look like this Thu 24 Fc Wed 23 15 24 2007 Build a deck r E Buy the deck plar Buy the wood Create a Dependency Now let s link those two items together with a dependency Why Because the plan tells you how much wood to buy therefore
32. base calendar Make a copy of calendar 2 Inthe Choose Name field type a name for the new calendar 3 Do one of the following Select Create a new base calendar A blank calendar in which all dates are set to the default time is created Weekends are marked as non working time Select Make a copy of then click the arrow button and select a calendar from the list Click OK You may now use the other editing functions to edit the calendar you ve created Remove a Calendar To remove a calendar 1 Inthe Select active calendar field click the arrow button then select the calendar that is to be removed 2 Click the Remove button A message box opens asking you to confirm the deletion JCVGantt Pro 3 User s Guide Ej Work with a Tablet PC or Vista Tablet PC Ink If you re using Windows Vista Windows Tablet PC Edition or the free Windows Tablet PC SDK you can use it with a Wacom stylus you are in for a treat JCVGantt Pro 3 supports ink entry for entering new tasks notes and even sup ports gestures so that Tablet PC users never have to use a keyboard To work in ink mode 1 In the Task menu Input mode group Ink icon 2 Double click in the task pane A window opens in which you can write a new task name 3 Click anywhere outside of the window The window closes and the task is added to the task pane 4 Inthe task pane select a task then click the Task note s Task note AIF
33. d and then clicking the arrow button In the list select hourly Resources Resource Hame Calendar Cost Unit 1 Cost of plan Calendar 300 00 flat 2 Cost of wood Calendar 450 00 flat 3 Carpenter Calendar 30 00 FES 4 z E T E J The spreadsheet shows that the cost of the plan is 300 the cost of the wood is 450 and that the carpenter costs 30 per hour COST THE PROJECT Now switch back to the Gantt chart by clicking the Gantt chart tab Gantt chart Project Select Buy the deck plan and then open the Task Info window Click once in the Re sources Name field then click the down arrow and select Cost of plan This links the cost of plan task to the first task Task Info E Resource Name Cost of wood Carpenter In the Gantt chart notice that the cost now appears to the right of the Cost of plan task bar dest of plan 200 00 Select the Buy the wood task and create a dependency link to Cost of wood Next link Carpenter to Build the deck JCVGantt Pro 3 User s Guide 3 9 10 20 Minute Quick Start Your Gantt should look like this Jun 2007 Tree 24 25 26 27 28 29 30 131 1 2 1 4 5 7 IB 10 li 12 13 14 15 16 17 18 19 20 f 16 15 2007 Build a deck Buy the deck plar Buy the wood Find Carpenter Build the deck Carpenter 1650 00 Now add the cost per hour of your search for a carpenter perhaps 20 hour then link it to Find carpenter Wha
34. dow opens In the File name box type a name for the file Click Save JCVGantt Pro 3 User s Guide 50 Getting Started CG Save As xs savein fj Desktop Oo 7 h Name Size Type Date modified a rn Recent Places lj Charles Guerin J Public m Desktop i T Ey p A Computer Chars Guerin a A i Network Computer lt rw i Adobe C53 Mas ip File Folder T i r Network E File name My Gantt ka Save Save as type JCVW3 document jcva To save a project under a new name In the File functions menu click Save As In the File name box type a new name for the file then click Save Close a Project To close a project Do one of the following In the File functions menu click Close In the File functions menu click Open then choose a new project type If this is a new document or if you ve made changes to the document you ll be asked to save it If you do not save it your changes will be lost SCROLL THROUGH THETIMELINE 51 Keyboard Commands Task Commands The following keyboard commands can be used when the cursor is in the tree pane Adds a sub task to a task Adds a sibling task to a list of tasks Asterisk key keypad only Minus key keypad only Plus key keypad only SHIFT ALT arrow key Moves the task up down right or left Note These keystrokes are identical intentionally
35. e Cost column indicates the cost of the resource The Unit column indicates how a cost Is calculated The Load column indicates as a percentage the percentage of time a re source is available For example in the above spreadsheet the painter costs 50 an hour If he were available to work on the project for only half of each week you would set his load to 50 00 Thereafter the Total Cost spreadsheet Total Cost tab would display the painter s costs at 50 Add Edit or Delete Resources To add a resource in MindManager Open the Task Info window and type a name in the Resources field If you have more than one resource separate the names by semi colons as shown below Doug John Fred JCVGantt Pro 3 automatically imports all resources and their associated tasks Resources John Fred Helen THE RESOURCE SPREADSHEET 85 To edit the Resource Name Cost or Load column To add data select an empty cell and type the new data To change the data double click a cell and type the new data To delete the data select a cell then press the Delete button on your key board A message box appears asking you to confirm the deletion To edit the Unit column 1 Click the right hand side of the cell that contains the data you d like to change A box appears listing the cost type 2 Select a new unit cost or type a word such as Flat for example that describes the cost type Resources _ResourceName Co
36. e selected cell or cells Click OK Now when you look at the formula for the selected cell s you will Know what it does CHANGE THE CELLTYPE 79 To delete a variable Inthe Variable field select a variable then press the Backspace key on your keyboard Change the Cell Type Cell Type allows you to define the way a cell is calculated For example you might change a numeric cell to a currency cell in order to show a currency indicator such as along with the number Or you might decide to convert numbers to text To change the cell type 1 Right click a cell and select Cell Type The Cell Type window appears with the cell s current type highlighted Decimal places Numeric format You can select number of digits allowed to the right of the decimal character in a number cell 2 Select the cell type that is to be applied to the cell 0 JCVGantt Pro 3 User s Guide 3 80 Work with Spreadsheets The Project Spreadsheet The Project spreadsheet displays all of the tasks in your project in columns and rows with each row representing a different task Task Name Duration Priority Percent Start Date End Date Resources Cost Dep Produce Essential Oil Bottles 8 day s 22 09 2005 03 10 2005 Tracy Charles Setup Charge Tec 3750 00 Purchase glass bottles 3 day s 22 09 2005 26 09 2005 Tracy 600 00 23 09 2005 27 09 2005 Charles 600 00 23 09 2005 23 09 2005 Tracy 200 00 29 09 2005 29 09 20
37. g SETDURATION 7 The chart should now look something like this j Week 22 May 2007 Tree Wed 23 Thu 24 Fri 25 Sat 26 Sun 27 Mon 28 Tue 29 Wed 30 Thu 31 T T 5 24 2007 15 31 2007 Build a deck Buy the deck plan Buy the wood Find Carpenter Build the deck Earlier you changed the duration of a task by dragging its right border to the right Now let s try another way to set duration Select the Build the deck task bar then click the Task Info icon The Task Info window opens Tip Click the thumbtack to keep the Task info window it locked in place In the Duration field type 7d then press Enter Name Buy the deck plan Priority None Start date 5 24 2007 fae Due Date 5 25 2007 E Complete Ld gs x Duration 7d Milestone Tip 7d means seven days Likewise 7w means seven weeks and 7h means seven hours JCVGantt Pro 3 User s Guide Ej 8 20 Minute Quick Start Notice that the task bar now shows a duration of seven days Cost the Project How much is this project going to cost To find out you must enter some costs Click the Resources tab gt Gantt chart Prom Resources Fit The Resources spreadsheet opens Enter the following information into the spreadsheet as you see in the grid below In the Unit column do the following Leave Cost of plan and Cost of wood as flat Set the unit cost for Carpenter to hourly by selecting the appropriate fiel
38. h allows for two break periods JCVGantt Pro 3 User s Guide 58 Customize Parameters To change the length of working hours 1 Click Set up week template The Week Template window opens Week template EJ Select the region with mouse and dick the appropriate button to set either working or nonworking time a0 22 To set working times drag the mouse to select a region or regions then click the blue Set working time button 0 2 4 6 8 10 12 14 16 18 Sunday Monday Tuesday Wednesday Thursday Friday Saturday 2 Do one of the following 24 Set working time Set nonworking time To set nonworking times drag the mouse to select a region or regions then click the gray Set nonworking time button Click OK Note The Week Template window uses a 24 hour clock To mark a day as a holiday or a nonworking day Select the date of the holiday on the calendar then select the Nonworking time option MULTIPLE CALENDARS 59 To return a date to its default settings Select the date then select the Use default option Multiple Calendars In JCVGantt Pro 3 you can use different calendars for different resources For example you might use a particular calendar for employees who work non standard shifts such as part time or holidays If John works Monday through Friday and Helen works Saturday through Wednesday you d benefit by establishing several calendars In JCVGantt Pro 3 you can import export
39. he Show JCVGantt Pro 3 E icon JCVGantt Pro 3 opens and the mind map is automatically entered into the JCVGantt fields You can create your own map templates in MindManager to kick start any projects and they ll sync directly into JCVGantt Hyperlinked Projects Board You can hyperlink multiple MindManager maps to one central MindManager map Due to the auto refresh capability of JCVGantt Pro 3 you ll be able to navigate to all of the projects in your company from this central map JCVGantt Pro 3 User s Guide 3 118 Creative Ideas Executive Status Board Track all of your projects from one Gantt chart or mind map You have a zillion details on your mind and often ten to fifteen projects running simultane ously How do you track them without going insane 1 Create a MindManager map that has a list of every project you re currently working on Color code each project branch with a different brush color For each item enter a branch with the next five items No more than five however This is for your own personal benefit Now schedule those items in the Gantt chart and add dependencies between projects and tasks as required Each day set the done on each item add items when you delete items that are 100 done Try to maintain three to five Next actions Why Because three to five actions is about as many as most minds can focus on in one shot Print the Gantt chart and the MindManager map and display them in
40. he same as 24 x 3 12 hours 84 hours 3 w 21 days Note We assume that a day equals 24 hours not eight as in some cal endaring systems and that a week has seven days not five as in some calendaring systems One place where this may cause confusion is setting a duration in JCVGantt to less than 1 day may show in MindManager as 0 days If this happens switch the display in MindMan ager task info to hours to see the proper display Relationships MindManager has the ability to show relationships among different topics using a dotted line and the Insert Relationships operation As this is a direct metaphor for dependencies in a Gantt chart you can synchronize JCV Gantt Pro 3 and MindManager so that they work together When you add relationships to a mind map dependencies are automatically assigned in the Gantt chart When you add dependencies in the Gantt chart relationships are automati cally shown in the mind map To activate this feature select the Synchronize MindManager Relationships option in the Options menu JCVGantt Pro 3 User s Guide 114 Use JCVGantt Pro3 with MindManager LE s Home Task a Format View Tools Options Add Ins sync Line Color Syne Fill Color Syne Color d Syne Rules Depending on your point of view this is either really useful or really ugly In any case the feature is there a a Buy Studs ag FEET ae 10 7 Erir 11 day s ads os sas
41. ies window opens JCVGantt Pro 3 User s Guide Ej 36 Getting Started Document properties Name Project name goes here Description Goal of project goes here a a yan In the Name field type the name of the project lt Click OK Shortcut Menus Several panes in the program have shortcut menus which you can access by right clicking The content of these menus depends on the screen you are on For example right clicking in the tree pane shows the following menu lt lt In the Description field type a description of the project 1 EN x t New Ins Delete Del Properties Color Shift up Indent Outdent Cut Ctrl x Copy Ctl THEVIEW MENU 37 Right clicking in the Resources tab shows a similar menu S43 Copy Ctrl C Paste Ctrl V Edit Names JCVGantt Pro 3 User s Guide Ej 38 Getting Started Mouse Actions JCVGanitt Pro 3 is a fairly mouse intensive program that is designed for you to grab and drag items easily Task Commands Mouse Action Click the middle of a task bar and drag it Mores the talor end darren atack left or right Click ue Lieu side of a task bar and drag Aduse me end dale aek it left or right Click the left side of a task bar and drag it Adjusts the percentage complete of the task left or right CTRL click the middle of any task Selects the task and allows multi selecting Double click any task Shows the Properties window C
42. ith a red square in each cell 7 Double click a red square A formula such as Project B1 appears p Edit the formula to read Project Bl Snapshot1 Bl Right click in a cell and in the quick menu select Cell Type The Cell Type window appears 10 Under Formula select Number then click OK The window closes and the cell in Sheet 1 displays 0 00 11 Click Save then open the Project tab 12 Double click one of the cells in the Duration column then change the duration value indicating d for days w for weeks or m for months Click Save then open Sheet1 The value originally displayed has changed to show the er JCVGantt Pro 3 User s Guide 94 Work with Baseline Snapshots ror difference between the planned value and the actual tracked value 0 Using a similar technique you might instead show the percentage of error or any other comparison operation that is relevant to your project Work with Gantt Parts Gantt Parts allow you to save snippets of projects to reusable files so that you can drag and drop them into new projects All project information is saved including resource costing and task information Save a Gantt Part There are two types of Gantt Parts All tasks Gantt Part Selected tasks Gantt Part To save a Gantt Part On the Standard toolbar do one of the following Click the Save All Tasks As Gantt Part i icon Click the Save Selected Tasks and Their Subtasks al icon
43. ject Views group in the View menu shown above permits you to display the proj ect in six possible views Toolbar Icon Function Gantt chart Resources Shows the project as an interactive Gantt bar graph Allows you to edit resource definitions af F a Field Name Allows you to rename fields and create drop down lists Project wb Shows the project in a spreadsheet data entry format on an Excel like spreadsheet Shows you how each resource is being allocated between multiple projects sharing a resource pool Resource usage Total cost Shows live total cost calculations of the project SET THE DISPLAY SIZE 41 Set the Display Size Th gt ee cN 50 7 foomin Zoom Out fe Fit Gantt Zoom The Zoom toolbar shown above allows you to set the display size of the Gantt chart To set the zoom factor Do one of the following Click the arrow button beside the percent field and select a percentage from the list Click the Zoom In icon Click the Zoom Out icon Some examples of use 100 shows your entire project from the earliest start date to the last end date 50 shows your entire project in half the screen area 200 shows half of your project on the screen As you zoom in or out notice that the timeline changes to show different levels of granu larity Years s a i SCNCI FMAMI JAS ONDJFMANI J AS CNDI FMAM
44. las index htm Customize Fields The Field Name spreadsheet shows you the names of all the fields in the system You can change the data in the Preferred Name column The Project spreadsheet and the Resource spreadsheet automatically display the new information For example you might change Task Name to Goals or Incidents Regarding the Drop Down Menu in Grid column Ifan item has a gray background you cannot edit it The Percent Done row row 6 lets you choose between Mindjet style done icon in the Project Grid or standard text Click the arrow to select a differ ent choice All other cells in this column may be edited using comma separated values e g 1 2 3 4 5 Rename Fields You can rename any column in the Field Name spreadsheet The column names in the Project and Resource spreadsheets are automatically updated Why So that you can best manage project information in the language that suits your needs and those of your project To rename a field Select the field then type the new name JCVGantt Pro 3 User s Guide 76 Work with Spreadsheets Create Drop Down Lists Comma separated values show up in the Project or Resource grid as a drop down list that displays the values you ve entered Using them can significantly decrease your data entry times To create a drop down list Inthe Field Names spreadsheet click an empty cell and enter a comma sep arated list Do not insert spaces be
45. lder then select Delete folder A message box opens asking you to confirm the deletion 2 Click Yes to delete the folder otherwise chick No 104 JCVGantt Pro 3 User s Guide Ej 102 Export Data to External Programs Why Export Sometimes you might want to save a Gantt chart or spreadsheet to an indepen dent file format so that you can simply double click the file and see the Gantt You may also own BizTalk servers or other data conversion services that might benefit from having project management information stored in a nice clean XML format to pump to and from your corporation s databases Export to MindManager To export a Gantt chart or spreadsheet to MindManager 1 Open any tab in JCVGantt Pro 3 2 In the File functions menu point to Import Export and select Export to MindManager Note This feature is disabled if MindManager is not installed on your machine The Save as window opens 3 Inthe File name field specify the name of the exported file 4 Click Save Export to Microsoft Project To export a Gantt chart or spreadsheet to Microsoft Project 1 Open any tab in JCVGantt Pro 3 2 A 4 EXPORT TO MICROSOFT EXCEL 103 In the File functions menu point to Import Export and select Export to MS Project Note This feature is disabled if Microsoft Project is not installed on your machine The Save as window opens In the File name field specify the name of the expor
46. les 0 Unassigned L Resource Loading Sep 2005 Thu 22 Fri 23 0 84176 sat 24 0 0 0 0 E C es ee C 0 Sep 2005 Sun 25 Mon 26 E E g g e a g Let s say you can only budget 20 hours out of an employee s 40 hour week to work on your project That s a 50 load If you set the employee s cost to 25 000 per year a 50 load JCVGantt Pro 3 User s Guide 90 Work with Spreadsheets will calculate 50 of any time spent by this resource By adjusting loads you can adjust both fixed and variable expenses from one location Resource loading is equally useful when working with fixed expenses Let s say that lum ber to build a 1000 square foot room costs 2000 If you later decide to change the room to a 500 square foot room you can adjust the load to 50 and the total cost will calculate properly The Total Cost Spreadsheet JCVGantt Pro 3 lets you perform dynamic total cost calculations Simply put the Total Cost spreadsheet continually calculates and recalculates costs as you plan your project It quickly shows you where a project stands according to all the data you ve entered Once you re ready to tell the world about your project you can easily and quickly produce quotations invoices and cost reports by creating custom documents that reference the cost calculations Total cost B C D E A Total cost 3 task_1 0 00 137 00 4 task_2 5 task_3 34 00 128 20 G task
47. lick the arrow icons Repositions a task in the project hierarchy Timeline Commands Mouse Action Rest S Click the timeline bar then use the scroll bar Moves the timeline back and forth Move the scroll bar at bottom of Gantt Displays a different area of the Gantt chart Click Zoom In or Zoom Out Adjusts the size of the view Customize the Quick Access Toolbar The top of the application window has a menu area called the QuickAccessToolbar PEC ESCE For functions you use regularly you can customize what s displayed in it and add func tions to this bar for quick unfettered access MOUSE ACTIONS 39 To customize Quick Access toolbar Right click anywhere on the ribbon bar and you ll see this menu Customize Quick Access Toolbar Reset Quick Access Toolbar G Options B X Customize the Quick Access Toolbar and keyboard shortcuts Choose commands from G Paste Remo cH Print Paste Link ga Print Preview a Cut Show Quick Access Toolbar below the Ribbon Keyboard shortcuts Customize Click the dropdown list underneath Choose commands from and select a menu where you d like to grab an icon or function to show on the Quick Access toolbar Click Add gt gt and Ok and you re done JCVGantt Pro 3 User s Guide Ej 40 Getting Started Change the Project View Gantt chart Field Name Project Resource usage Total cost Project Views The Pro
48. ll distributors r Things I need to do this week TI B Groups Must do Write users manual Sent to printer Go to sales meeting Delegate Send install to CD manuf Call distributors Low priority Call Debbie JCVGantt Pro 3 User s Guide Ej 28 5 Minute Quick Start for MindManager Users Write users manual lt 4 Sent to printer Go to sales meeting Send install to CD manufacturer call distributors Call Debbie Go to JCVGanitt Pro 3 The screen will look something like this Things I need to do this week Wed28 0 Thu29 Fri 30 Sat 1 B Groups Must do Write users manual Sent to printer NE Go to sales meeting pr Delegate Send install to CD manuf Call distributors n Low priority Call Debbie On the Options menu click Sync Fill Color The colors displayed in MindManager are copied over to JCVGantt Pro 3 Edit the chart according to the techniques described in the 20 minute Quick Start chapter USING MINDMANAGER WITH JCVGANTT PRO3 29 Now pick any task and set the Percent of that task to 100 Must do eO Write user s manual EEEE 199 a es ee Go to MindManager Notice that the 100 turned into a checkmark and that the depen dencies show up as relationships In fact anything you change in one program changes in the other This is called real time synchronization and is a central feature of JCVGantt Pro 3 JCVGantt Pro
49. m the left to the group set reece S nn Click once in the Enter all your ideas box then type the following pressing Enter after each entry Write user s manual Send to printer Send install to CD manufacturer Call distributors Go to sales meeting Call Debbie JCVGantt Pro 3 User s Guide Ej 26 5 Minute Quick Start for MindManager Users MindManager creates topics for everything you typed Write user s manual Sent to printer i Send install to CD manufacturer Call distributors l Go to sales meeting Call Debbie Now click once in the Enter group names Brainstorming Group Names box The Brainstorming Group Names window opens Ii Red Must do In the first three boxes type the following Orange Delegate a Must do a Yellow Low Priority Delegate E creen Low priority Blue Violet Click OK The following graphic appears USING MINDMANAGER WITH JCVGANTT PRO3 27 Drag and drop the tasks you brainstormed onto Must do Delegate and Low Priority so that your screen looks like this Write user s manual send to printer Go to sales meeting send install to CD manufacturer Call distributors Call Debbie Drag the Groups onto the main topic and click H oard 0410 1 day s The screen should look something like this C Go to sales meeting ris ae O40 oad 5 1 day s pumttiias P Send install to CD manufacher ol L Ca
50. n Click OK The Gantt chart sets the earliest task item to the date you set 0 SCROLL THROUGH THE TIMELINE 45 Align the Chart with the Current Date or Task m Show critical path om Jump to selected task fF Show current date To align the chart with today s date Gantt Chart View i F Bi r Click the Show current date In the View menu in the Gantt Chart View group icon Today s date is now at the leftmost side of the chart To align the chart with a selected task oe Jump to selected task Select the task then click the icon The selected task is now at the leftmost side of the chart Change the Display Language To change the display language for the user interface In the View menu select Language then choose a language Note This change does not take effect until you exit and re start the ap plication JCVGantt Pro 3 User s Guide Ej 46 Getting Started Print a Gantt chart or Spreadsheet All print functions reside in the File Functions Menu To view the menu click the logo in the top left and you ll see this Print Print Options Print Preview Print task notes Close Import Export D o A amp it Properties Print E Parameters To print a Gantt chart or spreadsheet ya In the File functions menu do one of the following Select Print Click the Print icon on the Quick Access t
51. name appears in the File name field Click Open The map appears in JCVGanit In the File functions menu select Save as The Save as window opens Navigate to the folder in which you want to save the file then in the File name field enter a file name Click Save 106 Setting Parameters Import From Earlier Versions of JCVGantt To import a Gantt chart or spreadsheet from an earlier version of JCVGantt 1 In the File functions menu in JCVGanitt Pro 3 point to Import Export and select Import from JCVG The Open window opens 2 Navigate to the JCVGantt file you want to import and select it The file name appears in the File name field 3 Click Open The file appears in JCVGanit 4 Inthe File functions menu select Save as The Save as window opens 5 Navigate to the folder in which you want to save the file then in the File name field enter a file name 6 Click Save Import From Excel Importing from Excel imports any text and formatting information contained in an Excel file and attempts to load it in a compatible format for JCVGantt Pro 3 One particularly useful way to use this feature is to import some of the free templates that come with Excel such as the billing statement template which can easily be modified to create some very nice looking reports To import a file from Excel 1 Click the User sheets Ea icon and select Add user sheet A new user sheet opens 2 In the File functions menu p
52. nds a Gantt Parts ff Samples Build an entire deck Drag the text onto Tree a ES i 5 6 7 8 9 10 11 12 13 1415 16 E E the Gantt chart RR The saved proj Buy the wood Find carpenter ect is added to Buik the deck the bottom of the gt sm neaect san a5 Buy the wood Cost of wood 450 00 Gantt chart Aana ie AMO i TRACK COMPLETION OF ATASK 19 You can now change the duration start date or any other property of the Gantt Part you just dragged in All costing and project information will update automatically Track Completion of a Task On the Gantt chart select Build the deck and drag the left side of the task bar to the right A black line appears in the middle of the bar and a percentage is displayed Continue dragging all the way to the right until the task is marked as 100 complete These percent complete bars indicate how much of a task is complete Open the Project spreadsheet Notice that the Percent column indicates the percentage of completion for each task If an x appears in the column the associated task is complete Percent a rF Change the Granularity of the View In the View Menu find the Zoom group r s aP 50 7 To To 50 zoomin Zoom Out a Fit Gantt Zoom JCVGantt Pro 3 User s Guide 20 20 Minute Quick Start Click the Zoom in icon The timeline zooms out as shown below Mor 2005 Dec 7005 3l oo 14 el 28 5 12 l 10 11 20
53. of a particular project You might need a snapshot only once a quarter while others might need a monthly or bi weekly snapshot Once you have a number of snapshots you can use the Export All feature to export multiple snapshots to Excel where you can use Excel s analysis tools to graph changes in the budget Create a Snapshot To create a snapshot of the current baseline In the Add ins menu Click the icon then select ge far JCVGantt Pro 3 creates a spreadsheet storing all the values of the current project This spreadsheet is named Snapshot_date 1 and the number in parentheses in creases by one each time you take a snapshot on a particular date A second snapshot for example would be named Snapshot_date 2 DELETEASNAPSHOT 93 Delete a Snapshot To delete a snapshot 1 Display the snapshot that is to be deleted by clicking the appropriate tab Snapshots Snapshotl May 23 2007 2 icon then click Epa aia 2 Click the A window appears asking you to confirm the deletion Example Using a Snapshot in a Spreadsheet Formula 1 Take a snapshot of your project 2 On the Project tab select every item in the Duration column m Right click then in the quick menu select Copy 4 Click the User sheets E icon and select Add user sheet 5 Inthe user sheet select a cell then right click In the quick menu choose Paste link The items you copied now appear in the spreadsheet w
54. oint to Import Export and select Import from Excel The Open window opens 3 Navigate to the Excel file you want to import and select it The file name appears in the File name field IMPORT FROM EARLIER VERSIONS OF JCVGANTT 107 4 Click Open The Excel Pages window opens Excel pages Select page Test case Field name Resourse Total cost Project Snapshots JEY PRO in common MM sheets Loo a a Cancel 5 Inthe Select pages box select the page you wish to import 6 Click OK The sheet is imported into the user sheet JCVGantt Pro 3 User s Guide 108 Dress Up the Gantt Chart Change the Skin To change the skin 1 At the right hand side of the application window click Gantt Parts If you do not see the Gantt Parts icon open the View menu and select Toolbars then select Gantt Parts The Gantt Parts window opens 2 Inthe Gantt Parts window open the Skins folder The bottom half of the window displays two or more skins Do one of the following Double click the icon that represents the desired skin Drag the icon that represents the desired skin to the Gantt chart The task bars on the Gantt chart display the new skin 109 Using with MindManager In general when dealing with task info as it s called in MindManager all the functions and parameters that are available in MindManager have corresponding functions and parameters in JCVGant
55. oolbar A lt If required click Properties to select the page orientation and other settings then click Ok SCROLL THROUGH THE TIMELINE 47 To set print options for a Gantt chart lt lt In the File functions menu select the arrow to the right of Print and click Print Options The Printing Parameters window opens lt lt Select the Tasks Print tab lt lt If required select Print margin lines on page or Always Print Header to print these items x Do one of the following Select Adjust to then set the percent to set the number of pages over which the chart will print Select Fit then type the number of sheets across to set the number of pages over which the chart will print Tip f the text in the tree pane is truncated in printouts on the chart slide the bar that separates the tree pane and the task pane to the right until no text is covered then in the Printing Parameters window set the Adjust to or Fit option to fit across several pages Under Date Parameters set the start and end dates of the printed chart Click OK To set print options for a spreadsheet ya In the File functions menu select Print Options The Printing Parameters window opens Select the Grid Print tab lt Select any of the check boxes to display those options in the printed spreadsheet Click OK JCVGantt Pro 3 User s Guide 3 48 Getting Started To preview the print job
56. rovides technical support services to Gantt Solution Inc The authors welcome corrections to this book Please feel free to send comments on typographical format ting or other errors Simply make a copy of the relevant page of the book mark the error and e mail it to support iaresearch com This boook is designed to be printed or viewed electronically in advanced PDF format As a licensed user of JCVGantt products you may print this book for your own uses To print this book we suggest printing on a full duplex printer on 8 5 by 11 paper and binding using tight spiral binding or paperback TABLE OF CONTENTS IH Contents 1 20 Minute Quick Start CreateTasks 2s we ee be eee eae oe eee ewe ee a8 2 Create a Dependency 2 0 ee ee 4 SUMUNANY Ke e aa a a a GS aa a 5 SECDUINON ea Baeble eRe ae kaana 6 Cost the Proje 4 rce eua eanan Ree eee eS 8 Use FOnnulas 24 aa aa a a ead 11 AAA G0 sp a raske ee ee ee E ee ae 13 AddNotestoaTask 2 ce ee ee eee 14 Createalemplate o o aa a 16 Track Completion ofa Task aaa 19 Change the Granularity ofthe View oaaae 19 Savea Project 9 5 4 cerrara ba ew ee ane 21 Pinta Projeti a Geena amp be oe GO ye oe oe ee ee ee 22 2 5 Minute Quick Start 23 Using Mindmanager with JCVGantt Pro3 2 ww ee 23 3 Getting Started 31 What Is a Gantt chart aaa ee Ree en Sh eae S 31 The JCVGantt Pro 3 Window oaa ee 34 The Pane Areas ouo usununeununan eau 34 TheViewMenu
57. rted What Is a Gantt chart A Gantt chart is a form of bar graph that shows how scheduled information inter relates Tasks are listed in the tree pane on the left side of the graph A timeline of days weeks months and years is displayed along the top of the graph Colored bars provide a visual representation of the tasks Their placement and length on the timeline indicates when a task is scheduled to begin and end 32 Getting Started Dependency lines have an arrow pointing to the next task to show that one task is de pendent on another task s completion A line embedded inside the colored bar and a numerical value at the right of the bar show a task s percentage of completion fence 663 Milestones represented by a small diamond indicate that a particular phase of the project has been reached E E i Project managers often use milestones to indicate when it is desirable to track a project to see whether it is on target or delayed A JCVGantt Pro 3 Gantt chart includes resources costing information float times and percentage complete Resources are either people who perform a task or activity or the tools such as a jack hammer or a front end loader for example that are used to accomplish a task Resource names are shown to right of Task bars A cost view unique to JCVGantt Pro 3 shows the cost associated with the completion of a task Painter 200 00 WHAT IS A GANTT
58. s This can present several problems Nobody likes to have to enter the same information over and over with each project Some people may have different schedules and a different calendar Some people may already be overloaded with work Resource pools allow you to group resource information in the schedule so that all 68 Work with Resource Pools Edit Resource Pools To edit resource pools On the View menu select Parameters The Parameters window opens F Use resource pool Resource pool file Open Merge Create new Projects in resource pool Remove project Open button Opens a new pool file and uses it and its resource in the current project Merge button Merges the projects contained within a pool file into the current pool Save button Saves the current pool file in order to rename it or share it with other users EDIT RESOURCE POOLS 69 Create New button Creates a new pool Use this when you want to start a new pool specifically for the current project Remove Project button Removes a project from a pool Use this if one of the projects has resources you ve decided not to use in the current project JCVGantt Pro 3 User s Guide Ej 70 Work with Resource Pools Work with Spreadsheets Format Cells In user sheets you can format the cells according to your own tastes and re quirements using the Format menu MS Sans Serif ee Font With a little creati
59. st Umt Load Charles 100 00 hourly 100 00 Jett 40 00 weekly 100 00 Doug 5000 00 pearly 100 00 Flooring Maternal 650 00 flat 100 00 Note JCVGanitt Pro 3 treats manually entered cost types as fixed costs To create your own columns See Create Fields To edit the E mail Group Code User1 User2 User3 or User4 column To add data select an empty cell and type the new data To change the data double click a cell and type the new data To delete the data select a cell then press the Delete button on your key board A message box appears asking you to confirm the deletion JCVGantt Pro 3 User s Guide Ej 86 Work with Spreadsheets Remove a Resource From a Project To delete a resource from the project On the Resources tab select a task and press the Delete button on the key board Amessage box appears asking you to confirm the deletion To delete a resource from the project using MindManager 1 In MindManager select each item that is associated with a resource 2 Inthe Task Info pane delete the resource that is no longer required DISPLAY RESOURCE COSTS ONTHE GANTT CHART 87 Display Resource Costs on the Gantt Chart To display resource cost on the Gantt chart 1 On the Resources spreadsheet enter a cost in a task s Cost cell 2 Onthe View menu select Parameters The Parameters window opens 3 On the Main tab select the Show Resource Cost checkbox Parameters Date format
60. t Pro 3 There are a few exceptions to how various data is treated but nothing that should get in your way Total Synchronization One major feature of JCVGantt Pro when used with MindManager is the total syn chronization between the two products Edit something in MindManager and it immediately appears in JCV Gantt Edit something in JCVGantt Pro 3 and it immediately appears in Mind Manager An important thing to understand about this feature is that all changes are stored in MindManager s data model This means that when you save a MindManager file you re also saving all the Gantt chart information along with it That includes attachments links user spreadsheets snapshots and all project information This also means that you ve got one file holding two views of the same informa tion l The one exception is certain Resource pool information which will be added later in 2007 110 Use JCVGantt Pro3 with MindManager Colors Changing the brush fill or text color in MindManager automatically changes the task bar color in JCVGantt Pro 3 Similarly unless you deselect the Automatic checkbox in the Properties window chang ing the task bar color in JCVGantt Pro 3 affects MindManager See also Modify Task Properties Link Gantt Colors to MindManager Colors sync Colors Done The debate is raging is it easier to track projects by setting the Percent Complete in JCVGantt using your mouse to drag
61. t is the total cost of the project To find out click the Total cost tab s gt lt Gantt chart Project Resources Field Name Resource usage Total cost The Total Cost report will look something like this A B C D E Total cost Variable Build a deck 750 00 1660 00 Subtotals 5750 00 1680 00 Total Project Cost 2430 00 ZS a a m in w Fixed costs are those that do not change over time Variable costs are those that are af fected by time USEFORMULAS 11 The total cost of the project is at present 2430 To see this in more detail click the Proj ect tab C Gantt chart Proje The Project spreadsheet opens 2 Task Name Duration Priority Percent Start Date End Date Resources Cost 1 A 16 day s 5 24 2007 6 14 2007 Carpenter Cost of plan Costofwoc 2430 00 Buy the deck plan 7 day s P 5 24 2007 6 1 2007 Cost of plan 300 00 Buy the wood 1 day s P 6 4 2007 6 4 2007 Cost of wood 450 00 Find Carpenter 1 day s P 6 5 2007 6 5 2007 0 00 Build the deck 7 day s P 6 6 2007 6 14 2007 Carpenter 1680 00 Use Formulas All spreadsheets in JCVGantt Pro 3 have functions that are similar to those in Microsoft Excel spreadsheets To see how this works we ll sum the cost of the deck plan and the cost of the wood Select the 300 then SHIFT click the 450 Cost 1680 00 Right click to see the shortcut menu then select Copy
62. ted file Click Save Export To Microsoft Excel To export a Gantt chart or spreadsheet to Excel 1 2 Open any tab in JCVGantt Pro 3 In the File functions menu point to Import Export then do one of the following To export the entire project to a single Excel file select Export All To Excel To export the active spreadsheet select Export Sheet activated only on spreadsheet tabs The Save as window opens In the File name field specify the name of the exported file Click Save JCVGantt Pro 3 User s Guide 104 Export Data to External Programs Export to HTML The Export to HTML feature creates an image of your Gantt chart or spreadsheet and saves it as an HTML file making it easy to send to other people To export a Gantt chart or spreadsheet to HTML L 2 Open any tab in JCVGantt Pro 3 In the File functions menu point to Import Export and select Export to HTML document The Save as window opens In the File name field specify the name of the exported file Click Save 105 Setting Parameters Import From MindManager To import a Gantt chart or spreadsheet from MindManager 1 In the File functions menu in JCVGantt Pro 3 point to Import Export and select Import from MindManager Note This feature is disabled if MindManager is not installed on your machine The Open window opens Navigate to the MindManager map you want to import and select it The map
63. tween the items in the list Hide Fields In the Project and Resources grids you can hide fields that are not relevant to your proj ect This feature can simplify a wordy page into something more readable To hide a field Inthe Projects spreadsheet right click and select the Hide Show option then check or uncheck the columns you want to see Change the Position of a Column You can change the position of the columns in the Resources and Snapshot spread sheets To move a column Drag a column title to the left or right to place the column in another location RESIZE COLUMNS 77 Duration Priority Percent 0 13 day s 0 13 day s 0 13 day s Resize Columns To change column size Place the mouse cursor over the line that divides the column title from its neighbor The cursor changes to a double headed arrow Click and drag to the right or left Use the Shortcut Menus To open a shortcut menu Right click in a cell The contents of the shortcut menu differ according to the spreadsheet you are looking at In the example below the shortcut menu on the left is from the Projects spreadsheet and the one on the right is from a user sheet Copy Ctrl Z Cuk Ctrl Mew F Copy Ctrl C Delete Paske Ctrl Properties Paste Link Hide Show Clear Input From List Edit Mames Edit Mames Cell Type Cut Copy and Paste The Cut Copy and Paste options work the same way as any Windows program
64. urrent project THE RESOURCE USAGE SPREADSHEET 89 Example Using the Resource Usage spreadsheet to make decisions The Gantt chart below shows the steps required to produce a run of 8 000 bottles of an essential oil product Week 40 Sep 2005 Week 41 Oct 2005 Prior Tree Thu 22 Fri23 Sat 24 Sun 25 Mon 26 Tue 27 Wed 28 Thu 29 Fri30 Sati Sun2 Mon3 Tue 4 Wed 5 BY Produce Essential Oil Bottle Purchase glass bottles Purchase labels Mix Oil and Store Setup Bottling machine Do Run 8 000 bottles Run Complete 103 10 2005 tee Feel The resources shown in the Gantt pane are Tracy Charles Setup Charge a flat fee and Technician s Fee an hourly rate The task pane shows the tasks that have been as signed to each resource The Resource Usage spreadsheet shows the number of hours that have been allocated to each resource In the example above Tracy has been over allocated Two full day tasks were assigned to her on the Friday Based on this information you will probably decide to extend the due date for purchasing labels or mixing oil or find another resource to take some load Note The task list includes all the tasks in the resource pool including tasks that are in other projects Resources 1 Tracy 2 Purchase glass bottles 3 Mix Dil and Store 4 Charles 5 Purchase labels E Setup Charge T Setup Bottling machine p Technicians Fee g Do Run 8 000 bott
65. ust replace name with the name of a resource for example ADDAFORMULATOACELL 73 ResourceCost Joe ProjectDuration calculates the total project duration in hours You can use the column name from any spreadsheet in a formula For example Project Task Name 3 will show you the third row of the Task Name column Just put the column name in single quotation marks JCVGantt Pro 3 User s Guide 74 Work with Spreadsheets List of Excel Compatible Functions The following Excel compatible functions can be used in JCVGantt Pro 3 user spread sheets ABS ACOS ACOSH ADD AND ASIN ASINH ATAN ATAN2 ATANH AVERAGE CEILING CHAR CLEAN CODE COMBIN CONCATENATE COS COSH DATE DAY DB DDB DEGREES EVEN EXACT INVERSE ISBLANK ISEVEN ISNONTEXT ISNUMBER ISODD ISREF ISTEXT LEFT LEN LN LOG LOG10 LOWER MAX MEDIAN MID MIN MINUTE MOD MODE MONTH NEG NOT NOW NPER ODD OR PERMUT PI PMT POWER PRODUCT PROPER PV RADIANS RAND RANK REPLACE REPT RIGHT ROUND ROUNDDOWN ROUNDUP SECOND SIGN SIN SINH SLN SQRT SQUARE STDEV STDEVP SUBSTITUTE SU SUMSQ SYD TAN TANH TIME TODAY TRIM TRUNC UPPER URL VAR VARP WEEKDAY XROOT YEAR CUSTOMIZE FIELDS 75 Note We will be documenting these features more fully in a later release In the meantime ou can read about the following JCVGantt Pro 3 features at Tech on the Net http www echonthenet com excel formu
66. vity you can make a rather fancy sheet suitable for printing and perhaps even framing B er E Quotation The Painter Costs The Carpenter Costs Variable Build my Subfloor and Walls 1070 00 5170 00 Materii 1070 00 0 00 Work i 0 00 5170 00 Subtotals 1070 00 5170 00 Total Project Cost 6240 00 72 Work with Spreadsheets To format cells Select any cell or group of cells then use the Format toolbar to change the font size and color the background and foreground colors and to italicize or underline text or change it to bold just as you would in Excel or any other Microsoft Office program If cells do not update automatically click the Refresh icon 0 Note The red squares do not print Add a Formula to a Cell Any cell in a user defined spreadsheet can contain a formula To add a formula to a cell 1 Select the cell then type an equal s sign followed by the formula 2 2 Press Enter The result of the formula appears in the cell along with a small red square in the upper right corner A Double clicking the red square will show the formula so that you can edit it again Note The red square does not show up on printouts or if you export the sheet to Excel Use Built In Formulas The following formulas are built in to JCVGantt Pro ProjectCost calculates the total cost of the project ResourceCost name calculates the cost of the resource In this formula you m
67. w inom Gantt Chart View Pane Column Language Thra reed EF Hertha Week 22 May 2007 Week 23 Jun 20 Tack into 2 Prior Link Holes AEs Tree TH F25 55 SS MA TS WD TILI OF S2 SJ M4 75 WG Strategie a oo ee Sretege Plan Reve lt 4 Vision and Mission a 7 iderety Wate Kerby Ligon z 5 J2 Envircemencal Seen SWOT SaNaT idenbty Serengttes f Sor Sig hurr ch zT erbiy Yieiintiiti 4 gannas Task info Pane Task Tree Pane Kienbty Opportunies i i kerty Threats F ziJ Raentity Srategic IrretE Gap Anahy oie Wha ia pur current postion Ldayis Vitar Go wg arent io pat Beechrearking Hirer wil we raara pap Ginger F i Task Tree jd Strategic Programming Columns Coangert sr epas Evaluates 24 irateyy Stratege Pan Revi Gantt Chart Pane Ink Pen tab to switch to stylus input Project View selection tabs Abe tab te ewitch to word processor entry mode Notes Pane THEVIEW MENU 35 The View Menu A quick way to navigate between windows in JCVGantt Pro 3 is to use the Project views icons in the View menu Just click anyway to change screens instantly Home Task Format View Tools Options Add gt amp amp Resources FieldName Project Total cost Resource usage Gy jaa A o Project Views Name a Project To name a project and add a description In the File functions menu click Properties The Document Propert
68. with one exception At present Paste pastes only numeric information and not formatting informa tion Any formatting information must be added after pasting JCVGantt Pro 3 User s Guide 78 Work with Spreadsheets Paste Link Paste Link pastes the contents of copied cells into another spreadsheet as a formula The new cells are linked to the original cells For example if you copy the first Task Name cell in a user sheet and Paste Link it into a cell in another user sheet the cell in the sec ond user sheet will react to any changes you make to the original cell In other words changes to the original cell propagate instantly to the cell in the second user sheet Clear Clear removes the contents of a cell and any formula that might be contained in it Edit Names Let s say that cell A3 in User sheet 1 contains a formula that converts US dollars to Cana dian dollars Normally this formula would be written as 5 00 A3 You might find it easier to understand the function of the cell if its formula were written as 5 00 US TO CAD This procedure allows you to change the name of a cell so that its name is more meaning ful To change the name a cell 1 Select a cell or a group of cells 2 Right click and choose Edit names The Variables window opens displaying Variablen in the Variable field and in the Value field the range of cells that was selected 3 Inthe Variable field type a meaningful name for th

JCVGantt Pro 3.2

Contents

Download Pdf Manuals

Related Search

Related Contents