Bodgan,

Identifying indents might not add much value other than placing the multi-valued name field on appropriate column so it does not get messed up under complicated resource assignments. A response to Evgeny request, it is something I have no real need for. To communicate schedule I see no substitute to electronic file and viewing the data using the software or the free viewer. For other audience a screen capture or a PDF is enough. 

I use Excel every hour of the day but rarely to transfer Spider Data, even when it is available at a click of the mouse, for these purposes I find Reference Books superior method. Transfer of row color to Excel is implemented but not the indentations within Name field, here text functions might yield desired indentation while other formulas can transfer the Name value to appropriate columns. 

Anyway Spider software somehow creates the indentation flawlessly. 

I entered L1A & L2 values manually I have not worked on the formulas yet.

Note that Skill bar is missing.

I would rather like to see Spider Team finish their work on Tornado Charts for Monte Carlo, something that cannot be done with 3 scenarios approach.

Best Regards,

Rafael

Bodgan,

Thanks, it seems to identify the meaning but still misses to identify hierarchy; in the following figure you will see Resource A under Team 1 and also under a Resource Skill but at a different level as you can see from the hierarchy indentations.

I would label the new field as Objects.

How to display missing Level values is another issue as in the example above resource A is under different hierarchical levels but it is still a resource line. Using two separate level definitions comes to my mind, one level definition for phase and activities and a separate level for assigments, the sum of two will give you the indentation/column number.

In the case of Resource A under Resource Skill - Team 1 phase and activity level would be 2 while assigment level would be 3 for a total of five indentations. Knowing the indentations then transfer to Excel can be performed using a separate column for each indentation instead to a single column. 

I love the way Spider works with the indentations on a single field column, there is a lot behind the scene.

Best Regards,

Rafael

Bodgan,

After scheduling your solution seems to work, with the exception of Teams and Skills.

Best Regards,

Rafael

Evgeny;

RE: Is there are way to add column, which shows, whether this is activity, phase, or resource (I did not manage to find a way).

• It is still pending, looks like Name is a multivalued field and solition is not easy, but the information is there, it is even painted in color.
• Using UDF [user defined fields] and formulas might be an option but looks complicated. Field for Levels only show WBS Level but empty for Activities/Resources/Multi-Resources/Teams.
  • A field to identify Object Type [WBS/Activity/Resource/Multi-Resource/Team] would be handy. It will answer your question, an issue I have been looking at before, and may even add some understanding as to what an Object is.

Rafael

I understand;

• Parameter Fields define what values you will see on the data area at Right Pane, they are selected as shown by Bodgan.
• Objects are represented, as defined by Bodgan, and shown by the Levels displayed on the active Gantt when you create the report.

Best Regards,

Rafael