Closed

Visual Studio (VSTS) parent fields average of children and calculated field

We have Features and Master Features work items. Master Features are parents of Features.

Both the Master Feature and the Feature have the same 3 fields that have values between 1 and 10.

Value to Business

Complexity to Build

Clarity of Requirements

We ONLY want to enter these values for Features, but have an average of these displayed for Master Features. For the Features we will input these manually (as shown). We would like the Master Feature for the child Features to have an average of the values of it's children (see attached diagram).

We also have a VCC column that is calculated from the 3 fields above.

VCC = [Value to Business] + [Clarity of Requirements] + 10 - [Complexity to Build]

For the Master Feature, the VCC value could EITHER be an average of it's childrens values, or calculated from the 3 fields of itself - which ever is easier.

We would like to be able to configure this functionality to hook up other fields or rename fields when needed or change the calculation for how VCC is calculated. Perhaps an XML/JSON configuration file.

My assumption is that it would be an Azure function (Node.js or C#) that reads the VSTS API and updates the values from a webhook. Your response should include instructions and your source code will need to be added to our VSTS instance.

Preference given to developers with good English, non-generic responses, explain their proposed solution (a few sentences is fine), and are available for daily 15-minute calls for the duration of the development between 9am and 10am UK time (we have other similar projects for Visual Studio, VSTS, that you could also potentially do).

PLEASE OUTLINE HOW YOU WOULD GO ABOUT IMPLEMENTING THIS SOLUTION TECHNICALLY.

Skills: .NET, Azure, C# Programming, RESTful, Software Architecture

See more: tfs work item calculated field, tfs query sum column, vsts completed work, tfs effort vs remaining work, tfs 2015 calculated field, vsts calculated field, tfs original estimate remaining completed, tfs work item rollup, please wait document processing crystal visual studio, create custom fields using visual studio 2008, custom fields sharepoint wss example visual studio, custom sharepoint fields visual studio, face recognition visual studio 2008, vb6 visual studio, visual studio 2008 flash, object oriented design visual studio, windows forms visual studio, exe decompiler visual studio, javame visual studio, windows visual studio 2008 windows form

About the Employer:
( 6 reviews ) Grantham, United Kingdom

Project ID: #16540510

13 freelancers are bidding on average £8/hour for this job

qualifiedcoders

Hi I have read your requirements and would like to discuss further as we have expert ASP.NET, MVC, C#, SQL, Web API developers who have developed complex database driven applications with many complex calculations. More

£10 GBP / hour
(105 Reviews)
8.0
youtekdotcom

Dear Sir, Let me do this job for you ! I've been working as a full stack .NET developer for more than 9 years, expert in ASP.Net MVC, ASP.Net Core, HTML 5 and Jquery, Angular JS, Bootstrap and Responsive Design, Rest More

£10 GBP / hour
(77 Reviews)
6.3
managonz

Hi, I am a telecom engineer, based in Spain, with many years of experience building custom applications for my clients. I am an expert in .NET (C#, VB.NET), WPF, Windows Services, Web Services, REST APIs, C/C++ and More

£8 GBP / hour
(14 Reviews)
6.0
£5 GBP / hour
(3 Reviews)
4.9
herbzone127

We carefully read your description about the project and knowledgeably aware about your requirements. As software developers we are interested in your project and also we worked with a development team and will meet More

£5 GBP / hour
(8 Reviews)
3.4
pearly007

 Lead Engineer with experience in design and development of Enterprise software products and solutions  Strong working knowledge on both Web based and Win forms based solutions  Specialized in object-oriented More

£8 GBP / hour
(3 Reviews)
3.2
saytechworld

I have 6+ years of experience of design, developing and deployment n-tier web based applications using .Net platform. Extensive experience in Web based application development using Microsoft.NET technologies includin More

£8 GBP / hour
(4 Reviews)
2.9
raghuviroverseas

hello sir or madam, i read your requirement and i have sound knowledge of ASP.net, c# and sql server. I try to complete your task within deadline. if you are comfortable with this then please msg me on raghuvirover More

£8 GBP / hour
(0 Reviews)
0.0
hanzala3500

i am gives you my 100% hard work for your this project.i wants to serve you by this [login to view URL] please givea me a chance..thanks

£8 GBP / hour
(0 Reviews)
0.0
£8 GBP / hour
(1 Review)
0.0
£8 GBP / hour
(0 Reviews)
0.0
Bazingo

Hi, We are a USA/Singapore based company currently working in different directions and one of them is enterprise software development. We can surely help you with this project as we have the proper expertise that is n More

£11 GBP / hour
(1 Review)
0.0
£11 GBP / hour
(0 Reviews)
0.0