Extra Costing with SharePoint Currency Columns

Earlier we showed you the basics of IntelliGantt for SharePoint costing with respect to assigned resources and their hourly rates. Now we would like to show you how IntelliGantt will recognize other currency columns in your task list and roll these values into your estimated Cost value.

When you add a Number Column to your SharePoint task list and format it with the Currency option, IntelliGantt will both rollup the column values and add it to your overall Cost column. 'Cost' is a reserved word in IntelliGantt and it represents all your estimated costs rolled together. Additional currency columns are treated as estimates also and, as a result, are added to the overall cost. In the near future you will have 'Actual' values that will roll up all your actual costs in the same manner (basically all currency columns starting with 'Actual'), but that is a future blog post.

For now, let's look at how the estimated cost rollup works. Starting with this example we see two tasks that have assignments and associated assignment costs with them. Additionally, there is an 'Extra Cost' field that is either blank or zero.

Remember you can see how IntelliGantt calculates an assigned cost by either looking at the particular assignment and seeing the Work, Hourly Rate and Level of Effort values:

Or by looking at the 'People' form and seeing the general setting for all a resources work, their standard hourly rate and effort.

This assigned cost goes right into the Cost column that IntelliGantt recognizes as the aggregated estimated cost field and rolls it up for you. Now let's add a value to the 'Extra Cost' column and see what happens. Let's first look at task 'Two', which has neither assignment nor extra cost values.

When we added $10 to the 'Extra Cost' field, two things happened. One, that extra cost was rolled up within the 'Extra Cost' column and two, it was also sent over to the 'Cost' column to be added to the sum estimated cost. We've highlighted all the affected calculations for you.

Similarly if we add $10 to the row right above which has an assignment, first we see the value added and rolled up in the Extra Cost column and also added to the estimated Cost column (and rolled up).

In this way IntelliGantt helps you keep track of both overall and individual costs. At a glance you can see what the entire, total estimated costs are but still see sub sections like assigned costs and 'extra costs' defined by you to help track your business processes.

Change Your Calendar Working Days and Time

In our previous post we introduced how you can give everyone a level of effort and hourly rate so that a cost per task assignment may be calculated. Of course, there are more components to computing this cost, and they are your working day and working time values within a calendar, or many days per week and how much working time per day. By default IntelliGantt for SharePoint 2013 uses Monday through Friday as working days and 8 hours per day of working time (a morning period from 8:00am to noon and an afternoon period from 1:00pm to 5:00pm). This results in a simple project cost as shown below.

You can change both the working days and time via the configuration.js file. This is usually located with your IntelliGantt_Online.aspx or IntelliGantt_Inhouse.aspx file within the Site Assets library. Or it can be in a centralized spot, depending on how you've set up all your SharePoint projects.

Here we see the default working days as defined in an array called 'WorkingDays' within the 'Calendar'. The array is a collection of 7 flags, with the first position representing Sunday. If we want to make Wednesday a non-working day, then we switch 4th flag to '0'.

Now when we see IntelliGantt notice that Wednesday is rendered as non-working time. This also affects the cost calculation as you can see the task costs and rollups have changed as well.

The other piece we can change is the working time per day. Back in configuration.js IntelliGantt has a 'periods' parameter where you can define one or more working time periods per day, their start time and their finish time (in seconds). We can either adjust the 'morning' and 'afternoon' periods by changing the start and finish times, or we can introduce a new period altogether like 'evening'.

Once again we refresh IntelliGantt and see that the cost values have changed again as the new working periods are calculated.

This calendar feature will address issues where countries have different working days and/or working times. We will also be introducing holidays and other special days that are either fully non-working or have distinct working periods.

Simple Assignment Costing with SharePoint 2013

IntelliGantt for SharePoint 2013 enhances basic task list assignments by adding effort and hourly rates for each person and rolling up cost values in a 'Cost' column. There are two main pieces to this feature that we will work through in this blog post.

First, add a new currency column to your task list and name it 'Cost'. IntelliGantt is programmed to look for this 'Cost' column and will store its computed cost values there. IntelliGantt will always compute a cost value, but in order for it to show up in the tool the 'Cost' column needs to be in the active view. Otherwise, if you just have a personal view that shows the 'Cost' column but the other views do not, then in effect you will be the only person able to see the cost values and other people will not.

Second, you will need to supply the effort and hourly rate for each member of the site you want to track this information for. This is done via the 'employee_rates.js' file your IntelliGantt aspx page includes. If you do the basic, minimum installation, then this will be located with your IntelliGantt_Online.aspx page. 

You can co-locate this file with the aspx page as we do when first installing, OR... because we are using all the power of the web, you can also reference a 'global' employee_rates.js file located at a root site that everyone has access to. The benefit of this approach is the file only needs to be generated once. 

One other word about generating the employee_rates.js file. While only you can provide effort and hourly rate information, IntelliGantt can generate the inital employee_rates.js file simply by not referencing one. If IntelliGantt cannot find the employee_rates.js file it will create one using the membership information of the current site. Everyone will then be listed in the 'employee_rates.js' with an Effort of 1.0 (100%) and an HourlyRate of 0.0.

Once we have the 'Cost' column and our employee_rates.js file set up, we can start seeing what things will cost. For example, if you click on the 'Assigned To' cell for a specific task, our rich editor appears that not only lets you adjust the assignments, but also see exactly what each assignment costs.

Here we see that the resource assigned to this task has an hourly rate of $100 and their level of effort is 100%, which in turn means the cost for this 32 hour task is $3200.

You can see everyone's resource information (as defined from the 'employee_rates.js' file) in the 'People' view. Click on the 'People' image at the upper left of IntelliGantt to show this information.

The very first time you open it nothing is selected, so while you see a list of people in the 'All People' selection box, you don't see any values. Simply click on one or more people to see their costing information.

Given the selected person, IntelliGantt will fill in the computed Duration, Work, Effort, Hourly Rate and Estimated Cost values. (Actual Cost as well, but that is a future blog post!).


Notice also that the visible task list in IntelliGantt changed! When you selected a person in the 'People' display, it filters the task list to show only their tasks. This makes it easy to see both their cost and their tasks on a timeline. You can close the 'People' display and it will remember your selection so you have a full view of the filtered Gantt chart.

One more nice little feature is you can collapse tasks and it will show its sub tasks on the same horizontal row, like a swimlane.

Return to the 'People' display to see what your current filter is and the associated costs.

Simple Todo Item Costing with Basecamp

Basecamp by itself does not support levels of effort and hourly rates for people. Basecamp with IntelliGantt, however, most certainly does. We let you provide level of effort and hourly rate values for every person in your Basecamp project. Then, when you assign someone to a task, IntelliGantt will compute the cost for that task by multiplying the work * level of effort * hourly rate for that person. Combined with the cost rollup feature, you can quickly see how much a particular task is costing and even how much an entire project is costing. Here's how it works.

After you have allowed IntelliGantt to communicate with Basecamp and have chosen an account, you can select one or more projects to work with. When you select a project it gives you a quick overview of how much work and cost is involved for all the items in the project.

When you select a person in the 'People' dialog, you can quickly see how much work is assigned to that person and what their default level of effort and hourly rate are.

When you create or edit a task assignment, by default the values come from that users default level of effort and hourly rate. However, you can override this on an assignment-by-assignment basis, should you choose, with specific level of effort and hourly rate for that task assignment.

Put all this together and you can quickly see what the cost for both individual tasks are their rollups are.

Simple Task Costing with SharePoint 2013

The IntelliGantt App for SharePoint 2013 let's you extend the basic user profiles within SharePoint so that you can tracking costs with your Task List items. For each SharePoint person you can give them an hourly rate and a level of effort value that IntelliGantt reads. Then if you assign that person to a task, IntelliGantt will compute it's cost. That is, duration in hours * level of effort * hourly rate. Here's the simplest example to get up and running.

First we must make sure every user profile in SharePoint has an 'Effort' and 'Hourly Rate' field. To do that you'll need administrative rights to your site collection. With these rights go to the SharePoint Admin Center.

Click on the 'User Profiles' and 'Manage User Properties link.

We will want to add these two fields to the 'Custom Properties' of the User Profile field template. Here we've already added the two fields.

The key here is to make sure the field names and data types are exactly what IntelliGantt expects. 'Hourly Rate' should have a field name of 'HourlyRate' and a data type of 'float'. Similarly, 'Effort' should have a field name of 'Effort' and a data type of 'float'.

Now we simply plug in the actual hourly rate and effort values for each user. The administrator can do this our the users themselves by editing their profile information.

When the IntelliGantt App for SharePoint 2013 pulls in a Task List (or two or three) it will check to see if the person assigned to a task has hourly rate and effort information. If so, then you will see cost information calculated for you automatically.