Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

Need a formula which will calcullate q-ty of points per week…

Customer Question
Need a formula which will...
Need a formula which will calcullate q-ty of points per week in Gantt-Chart
Submitted: 11 months ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Customer reply replied 11 months ago
the File
Answered in 9 minutes by:
9/14/2017
Microsoft Office Technician: Bhavik Joshi, Computer Software Engineer replied 11 months ago
Bhavik Joshi
Bhavik Joshi, Computer Software Engineer
Category: Microsoft Office
Satisfied Customers: 1,005
Experience: Product Developer at Computer Science Corporation
Verified

Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Bhavik Joshi, Computer Software Engineer replied 11 months ago

I can help you with it. Please let me know how you want me to calculate it, What all factors needs to be considered and give me some expected results for few weeks so that I can test my formula against it.

Ask Your Own Microsoft Office Question
Customer reply replied 11 months ago
Attached Gantt-Chart used for managing Team productivity per week. Gantt-Chart shows size of task. Chart indicate week (it marked by blue/green depends on status) on which this task was planned. I would luke to have a formula which will automatically show team velocity otherwords how many points per week was used. Points can be taken from Column G or J. Points should be calcullated in week when story was finished (e.g. if task goes from one week to enother then it should calcullate points in week when task was finished)
Data should be indicated in Raw #83 Ponts per week: (marked by yellow) under each week.
Microsoft Office Technician: Bhavik Joshi, Computer Software Engineer replied 11 months ago

That I got it but I need to know how you want me to calculate points? What all factors needs to be considered and give me some expected results for few weeks

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Bhavik Joshi, Computer Software Engineer replied 11 months ago

Can we calculate points by dividing Task Duration by Team Size.

Ask Your Own Microsoft Office Question
Customer reply replied 11 months ago
Hello Bhavik,Thanks for Your fast reply, I am interested in sum of points which for tasks which was planned for specific week. For example, on week Aug'04 - there are 5 stories with following Size (Column G): 2+1+13+2 - so total Points per week should be 19 points. So formula should count time and how many points fit into that time range and show this value in marked area
Microsoft Office Technician: Bhavik Joshi, Computer Software Engineer replied 11 months ago

I am sorry, I did not get how you selected only 2+1+13+2 sequence. I am not able to find/identify this in column G for Aug'04.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Bhavik Joshi, Computer Software Engineer replied 11 months ago

For ex. Why you have selected 13 to calculate total points for Aug'04

Ask Your Own Microsoft Office Question
Customer reply replied 11 months ago
I'm put some details into file,please check, hopefully it will explain what I am looking
Customer reply replied 11 months ago
I modified file (simplify),trying to attach it, but +Add files button doesn't work :(
Customer reply replied 11 months ago
Oh, now it's work!
So, let me try to explain.Formula should show values in raw #24. It should analyze what dates from Column H and Column I fits in the specific week and then take values from Column G.For example, In week Aug'5 - there is one task with ID# ***** and Size 3 - so formula should put 2 in L23, for week Aug'12 - there are 2 tasks with IDs# ***** 4 and 5 and Sizes - 2 and 1 - so formula should put 3 in M24
Only one remark, that if task was large and was performed during 2 weeks, then points should be calculated in week when task was finished
Microsoft Office Technician: Bhavik Joshi, Computer Software Engineer replied 11 months ago

okay, I got it. I have started working on it.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Bhavik Joshi, Computer Software Engineer replied 11 months ago

I tried doing it but my code is not working as expected. It is difficult to read the start and end data and identify on which week it is falling.

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

842 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I am trying to create a spreadsheet that does the following,
I am trying to create a spreadsheet that does the following, tracks attendance and applies occurrences for unplanned absence @ 1 point, Tardy @ .5 point, and early departure @ .5 points. Then I need i… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I need to add weeks to my gantt chart to show a total of 20
I need to add weeks to my gantt chart to show a total of 20 weeks. … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
842 satisfied customers
How do I import an Excel file, where I have build a Gantt
How do I import an Excel file, where I have build a Gantt chart, to a MS Powerpoint presentation page? … read more
Steve Fishman
Steve Fishman
BA
23 satisfied customers
I have an excel formula that has a value (FSC) that changes
Hi, I have an excel formula that has a value (FSC) that changes week to week. how do i adjust this formula to keep prior weeks results from changing because of the new value (this week's). last week t… read more
Steve
Steve
Consultant
Bachelor
69 satisfied customers
Develop a spreadsheet model for the following question: A
Develop a spreadsheet model for the following question: A man owns a hot dog stand. he sells 700 hot dogs per month at 3.25 each making total revenue of 2,275. Each hot dog with codiments cost him .70… read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
I'm looking with a semi-complex formula that will calculate
Hello, I'm looking for help with a semi-complex formula that will calculate "due date and time" for a case based on other known attributes of a case (i.e., received date & time and requested due time)… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
How do you take a block of cells that have 12 rows and 52
how do you take a block of cells that have 12 rows and 52 columns and change them to 52 rows and 12 columns?… read more
R. Michael
R. Michael
MIS Analyst
Master\u0027s Degree
22 satisfied customers
10 separate date ranges of data each with 2 columns side my
10 separate date ranges of data each with 2 columns side my side The first row starts: [First Class of Employee working a 14/7 schedule] First Column Second Column 42005 42019 seond row +14 -7 3rd row… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Richard, Good morning I have sent a file to Wikisend file
Richard, Good morning I have sent a file to Wikisend file number 691594.when you open sheet you should be on tab 25 go down to row 34 ( you can see all the data _ shots_weights_300 data points ). I wo… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
Could you please assist in a formula to calculate hours in
Could you please assist in a formula to calculate hours in a day and breaking down to an individual activity? For example in one column I will have the activity e.g. auditing, safety walks etc. In ano… read more
Kamil Anwar
Kamil Anwar
Office Specialist
Bachelor's Degree
219 satisfied customers
I need a formula that will arrange the miles per state in a
I need a formula that will arrange the miles per state in a column for each state. to be more exact, I will have over 20 charts, with just two columns, one for the name of the state, and the other one… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,131 satisfied customers
Trying to create a spreadsheet to do payroll for agriculture,
Trying to create a spreadsheet to do payroll for agriculture, which is paid by piece rate or an agreed min. wage. Their pay must equal at least the min wage agreed upon. I have everything calculating … read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
In a MS Project Gantt chart, I want to filter out all tasks
In a MS Project Gantt chart, I want to filter out all tasks that are completed AND I want to highlight tasks that occur in the upcoming 3 weeks. How do I do this?… read more
comp_audio
comp_audio
Microsoft 365 Ambassador
211 satisfied customers
Hi I want to work out the following. For every hour somebody
Hi I want to work out the following. For every hour somebody works at my company they earn 12.07% of holiday allowance and i don't know what formula to use. so some body works for 10 hours i know they… read more
JACUSTOMER-83mccr04-
JACUSTOMER-83mccr04-
35 satisfied customers
Hello! I have created a chart of an extensive polynomial that
Hello! I have created a chart of an extensive polynomial that properly describes the data I want to model, but I am unable to properly enter the formula from the chart to get the calculated data that … read more
Osbert12
Osbert12
Master\u0027s Degree
412 satisfied customers
I have a Gantt chart that I printed as a PDF, and then converted
I have a Gantt chart that I printed as a PDF, and then converted to *.docx but now I want to get it into a word document...!!!… read more
Val B
Val B
Senior Analyst/Trainer
Associate Degree
48 satisfied customers
Using MS Project 2010 Professional, how do I darken the gridlines
Using MS Project 2010 Professional, how do I darken the gridlines on a Gantt Chart when printing?… read more
Sergio A.
Sergio A.
Security & Technical Specialist
Bachelor\u0027s Degree
395 satisfied customers
I have assigned Cost Resources to tasks. I want to show the
I have assigned Cost Resources to tasks. I want to show the Resource Name on the Gantt Chart bar but when I do it shows the costs associated with the task in brackets next to the Resource Name. I do n… read more
Travis B.
Travis B.
Computer Technician
High School or GED
2,630 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x