Create Plan using TaskData
Budget: $30 – $250 AUD
Create PoaP using TaskData
Sort or group the Taskdata by Stream and loop through each task data,
IF Stream NOT found on the PoaP sheet, add 2 rows and put Stream Name on Col A and add
. One row for Milestone shapes
. Another row for Task shapes
For each Stream on the PoaP sheet,
If Milestone or Task shape NOT Found based on shape name UniqueId or ShapeID
Create New shape
IF milestone found (i.e.start date = finish date)
create and add milestone shape to Poap and position it
add to the milestone group text name->the corresponding "task name" from Task Data"
IF task found ( i.e.start date <> finish date "not a milestone as above")
create and add Task shape shape to Poap and position it
add to the Task group text name->the corresponding "task name" from Task Data"
Sort or group the Taskdata by Stream and loop through each task data,
IF Stream NOT found on the PoaP sheet, add 2 rows and put Stream Name on Col A and add
. One row for Milestone shapes
. Another row for Task shapes
For each Stream on the PoaP sheet,
If Milestone or Task shape NOT Found based on shape name UniqueId or ShapeID
Create New shape
IF milestone found (i.e.start date = finish date)
create and add milestone shape to Poap and position it
add to the milestone group text name->the corresponding "task name" from Task Data"
IF task found ( i.e.start date <> finish date "not a milestone as above")
create and add Task shape shape to Poap and position it
add to the Task group text name->the corresponding "task name" from Task Data"