Generalized model for HTML5 Gantt charts for resource planning, Part #2

During the last years, we gained a lot of experience in developing HTML5 Gantt charts. It boiled down to a generalized model for resource planning, that is now the basis of our Visual Scheduling Widget. How this model looks, I started to explain in my previous blog post, when I described the data model and its different types of objects we think are relevant to visualize resources and their activities.

In this post, I explain how to map the members of this data model to interactive graphical representations. So the second part of my series of blog posts about our generalized model for HTML5 Gantt charts refers to the concept of mapping.

#2 Our concept of mapping

Two views

Having a data model is nice, but what is needed in the end is an interactive chart that allows a user to work with that data in the most intuitive way possible. Therefore, adequate representation for all members of the data model in the form of a Gantt chart has to be found.

In practice, two types of charts have been proven to be useful and valuable:

  • the Activities view and
  • the Resources view

One can imagine them as the two sides of the same coin. Both present the data model from a different perspective with a different focus.

Extensions of the pure data model for interactive representations

In order to be able to specify all desired aspects of the mapping of the data model to interactive, graphical representations, we added many additional properties to each object type of the data model. These properties – marked by the prefix “pm_”, which stands for “presentation model” – can be used to control the following aspects of the presentation:

  • colours of graphical elements such as bars, table rows, lines, texts, timescale, calendar grids, etc.
  • collapse status of rows/groups (expanded, collapsed)
  • possible interactions (whether a bar can be moved or resized, whether a row can be collapsed or not, which elements are selectable, snapping targets, etc.)
  • design of expanded and of collapsed rows (whether and how child elements should be displayed)
  • visualization of special properties such as constraint dates, status, symbols, etc.

Many of these properties can be set both as default values and as individual values for individual objects. 

Activity view

In this view, activities are listed in the table area of the Gantt chart. In the simplest case, each activity has its own row. In the diagram area, the start and end dates of the activities are represented by bars. Resources and allocations are not of interest in this view type.

If activities are grouped, then the parent activities can be expanded:

Or the parent activity can be interactively collapsed:

Or instead of the parent, only  the children are to be seen:

In any case, the concrete design for collapsed activities can be defined individually for each activity as well as globally by default settings.

Link objects are mapped to arrows between activity bars. The relation type of a link is expressed by the layout of the arrow, which can begin and end at the beginning or the end of a bar depending on the type.

Resource view

Analogous to the activities view, the resources view lists all the resources in the table area of the Gantt chart. In the diagram area, the allocations and their entries are displayed. The calendar entries for non-working times of a resource are visualized by slightly grayed vertical strips.

There are multiple designs for visualizing allocations:

  • An allocation can be represented by a single bar:

  • If it has more than only one entry, then each entry can be displayed as a separate bar:

  • Or the entries are shown together with the allocation itself:

For displaying curves there is a curve area inside each resource row, which can be interactively expanded and collapsed.

A curve object is displayed as a stepped line, possibly with the coloured area below the line. Each curve entry defines a data point of that stepped line.

With stacked curves, not only the stack as a whole is visible but also the single members of the curve stack.

The following figure shows two curve objects, each of them representing the load of a resource caused by an allocation. They are stacked on top of each other and visually distinguishable by two colours. An additional curve object defines the capacity of the resources and is displayed by a line. The area where the stacked curve exceeds the capacity line is highlighted by hatching:

Of course, this is only one possible sample for the use of curves. A lot of further applications for curves are conceivable and you can use curves to express any other semantics.

Last but not least, there is an additional view type – the load view – that is a derivate of the resource view with the curve diagram areas only and without any bars. It is a valuable tool when only the capacities and loads of the resources are of interest, but not the allocations in detail.

Entities table

The entities objects are displayed in a special table – the entities table – that can be displayed on the right side of the Gantt chart.

Find out more about NETRONIC and how it can help your business succeed, or contact allonline365 on  +27 (21) 205 3650 or  info@allonline365.com.

www.allonline365.com

Resource Credit | NETRONIC

 

 

Generalized model for HTML5 Gantt charts for resourcing planning: part #1

gantt charts

Some time ago,  I reported on the way NETRONIC helps its customers develop web applications for scheduling or resource planning by offering custom tailored, interactive HTML5 Gantt charts. Since then, things have evolved outstandingly. My update on this is the following blog post about our new generalized model for resource planning that is today the basis of our Visual Scheduling Widget.

During the past years, we gained a lot of new experiences developing HTML5 charts for customers as well as for our products:

  • A lot of great projects with many customers from different fields of application have been realized successfully.
  • Our cloud-based SaaSproduct just plan it has been successfully extended.
  • Our product portfolio was extended by new products for Microsoft Dynamics 365 Business Central.
  • We created a new product for our customers, looking for an HTML5 Gantt component: the Visual Scheduling Widget.

Main learning effect during time

All-in-all, we have gained a lot of valuable experience, not only with the use of HTML5 techniques but especially with the implementation of scheduling and planning tasks in graphical user interfaces for web browsers. 

At the very beginning of our efforts to develop web applications, the focus was on the realization of pure Gantt functionality. First of all, it was important to have a set of tools for integrating interactive Gantt charts into web applications. But the more projects were implemented together with our customers, the more it became clear that the gap between our level of abstraction and the data and application models of the customers was too wide. So, both worlds had to be brought together to better meet the customers’ needs.

New & generalized Model for Resource Planning

We recognized that all applications of our HTML5 Gantt charts for all the different domains-whether project management, production scheduling, supply chain management or others-have one thing in common: resource planning. Therefore, we have developed a new data model that generalizes all parts of the different domains that are relevant for visual resource scheduling using interactive Gantt charts.

In addition to the pure data model, we have also created a concept of how to map the members of this data model to interactive graphical representations. This concept and the data model represent our new model for resource planning. Based on this model, we extended out NETRONIC Web Application Framework, which we used internally for developing the custom-tailored, interactive HTML5 Gantt chart widgets and that is now available as Visual Scheduling Widget for our customers, as well as for developing our own products in the context of Microsoft Dynamics. So, a broad range of our customers benefits from this new model.

#1 The Data Model

Let’s talk about the data model first:

Objects of the Data Model

The following list provides a detailed overview of the 7 different types of objects involved in the Resource Planning Data Model and their relationships to each other:

1. Activities

The term Activities covers all actions that need to be accomplished within a certain period of time to achieve a specific objective. Examples of activities are tasks in project management or jobs and operations in production planning.

Start and end dates of activity are the two important properties that can be the result of a scheduling process, or that are predefined.

Activities can be grouped. For instance, in project management, a project might be divided into many tasks and each task consists of a set of subtasks and so on. In production planning, jobs are usually subdivided into further jobs and on the lowest level operations are the base activities. Grouping can be achieved by setting the identifier of a parent activity.

Properties such as progress, special types of constraint dates, and baseline dates are also considered in the data model.

2. Resources

Resources, such as machines or personnel, are needed to perform the activities. Besides its general availability defined by a calendar, a resource has a capacity and a load. The latter results from the assignment of activities to a resource and are defined by specific curve objects.

As well as activities, resources might be grouped. Departments consisting of groups of individual resources are examples of a three-level nesting (department>resource group>resource).

3. Allocations and Allocation Entries

Allocations define the assignments of resources to activities and vice versa. Each allocation refers to a maximum of one activity and a maximum of one resource.

In the simplest case, a resource is allocated by an activity for the entire execution period of the activity. Then the allocation will use the start and end dates of the activity itself. But imagine the execution time of an activity is subdivided in different time spans. For instance, if the execution time consists of setup time, a pure runtime, and teardown time, a resource may only be required for setup and teardown, but not at runtime. For this purpose, an allocation can have an array of allocation entries. Each entry has its own start and end date and represents a time span. In the above case, we will define an entry for the setup time and another one for the teardown time.

Of course, this concept of allocations also allows to model many-to-many relationships between activities and resources by using multiple allocations with the same activities and/or resources involved.

4. Calendar and Calendar Entries

As mentioned above, calendars are used to define the general availability of a resource without taking into account the specific capacities. Each calendar has an array of calendar entries that determine whether it is a working or a non-working time for a time period specified by a start and an end.

5. Curves and Curve Point Entries

Curve objects are used to handle time-orientated data such as capacities or loads of resources. They can be simple point curves with an array of curve point entries, each entry defining a point in time and a corresponding value.  Or they can be stacked curves that are built by adding multiple curves. In this way, you can, for example, add all capacities of individual resources in a resource group to a total capacity of this resource group.

To make working with curves easier, you only need to define entries for those points at which the curve changes its value.

6. Links

In addition to grouping, activities can be related to each other in a different way. Think of, for example, chained production operations or complex networks project management tasks. In this case, an activity can only be started if the directly preceding activity has already been finished. Such kinds of relations can be expressed by link objects. 

Each link is directed and refers to a source and a target activity. In addition to these references, a link has one of the well-known relation types (finish-start, start-start, finish-finish).

Since you can create multiple links with the same source or the same target activity, not only simple activity chains, but also more complex networks of activities can be realized.

7. Entities

This kind of object is used to manage arbitrary sets of any grouped objects. An entity can be an activity, a resource, or any other object. In practice, entries are used, for instance, for lists of backlog orders that have not yet been scheduled or for lists of available resources with suitable skills that can be assigned to a certain activity.

The Data Model at a glance

The following figure summarizes all object types described above their relationships. Only those object properties are listed that are essential for understanding the concept of this data model. There are two kinds of objects:

  • objects that are identifiable by an identifier
  • and objects that are part of an identifiable object, but do not have an identifier of their own.

Find out more about NETRONIC and how it can help your business succeed, or contact allonline365 on  +27 (21) 205 3650 or  info@allonline365.com.

www.allonline365.com

Resource Credit | NETRONIC

6 Important Lessons Learned from ERP Implementation Failures

erp

The deployment of new software in your core business activities can improve productivity and efficiency. ERP is one of the tools you can consider acquiring to enhance the operations of your enterprise, but you should also appreciate the fact that the implementation of such software is not straightforward.

An ERP implementation is not always easy and that is why it is important for every member of a business to take the time to pay attention to lessons learned from ERP failures in order to avoid those mistakes during their own implementation. By steering clear of these common mistakes, companies are able to maximize their long-term potential.

1. Poor Software Choices

Taking a closer look at the system requirements before choosing software is a great way to steer clear of this issue. ERP vendors are always going to push a client to purchase their software with all of the bells and whistles but it is imperative that we ask questions to find out everything we need to know.  Try to find out what issues can cause you pain and what are the key areas an ERP should resolve within your business.

2. Lack of Commitment from Leadership

The level of commitment to ERP implementation starts at the very top and if leaders of a company are not willing to put their full weight behind the process, it is doomed to failure from the start. It is needless to say that adopting ERP will affect the core functions of your enterprise, which suggests that the active involvement of top management is critical. Unfortunately, some managers may follow suit, which inhibits the successful implementation of such software.

Bringing all of your managers on board before your company acquires an ERP software is necessary. Top executives need to understand how ERP will affect core business functions as well as give suggestions that will make the implementation process a success. Involving managers in the process of implementing ERP software will also present an ideal opportunity for training to facilitate a smooth transition.

3. Legacy Reflection

Letting go of old habits is a challenge for some business operators and for that reason they may prioritize customization of their new ERP to function like their legacy systems. The problem is that over-customizing ERP is costly, and it also increases the need for future upgrades. 

The idea of enhancing the user experience when installing new software may be a necessity, but ensuring that your latest ERP software resembles your legacy platform is not an option at all.

Acquiring an ERP solution that will address the requirements of your organization is a priority you should never overlook because it will reduce the need for customization. Embracing the fact that successful implementation of new ERP requires your business to adapt accordingly is also a wise idea.

4. Failure to Obtain the Proper Resources

While a team often has the right number of human resources and a lot f available tool at their disposal, that does not mean that the team was able to find the right people or the right tools to match the task at hand. It is important to focus on staffing your team with the right talents an experience to properly handle the job.

5. No Delegation Skills

Decisions need to be made in a timely manner. Companies that are going through the ERP implementation process do not always have the chance to do so because they have not chosen the proper party. Be sure to establish a hierarchy for decision making as early as possible. 

6. Insufficient Training

In order for an ERP implementation to go according to plan, the correct training must take place. The users need to be well versed before the implementation is able to happen. If not, they are going to be forced to turn to the implementation support team every time they need assistance.  This serves a drain on key resources.

allonline365 offers high-quality services like implementation, deployment, training, and support. Take the guesswork out of implementing a new ERP system and let us take care of it. Dynamics 365 Business Central is a top-end ERP system that can help your business grow. To get in touch with allonline365, contact us on  +27 (21) 205 3650 or email  info@allonline365.com.

www.allonline365.com

Resource Credit | K3 Business Technologies

allonline365 Newsletter

Call Now Button