MS Project 2010 / Excel Create: S curve and add forecast line based on Remaining work ...
Like totally amazing interchangeable sister outfit accessory swapping or whatever
How to keep bees out of canned beverages?
Normal Operator || T^2|| = ||T||^2
Why these surprising proportionalities of integrals involving odd zeta values?
Are Flameskulls resistant to magical piercing damage?
What is the ongoing value of the Kanban board to the developers as opposed to management
Is Vivien of the Wilds + Wilderness Reclamation a competitive combo?
What's the connection between Mr. Nancy and fried chicken?
Does Prince Arnaud cause someone holding the Princess to lose?
How to break 信じようとしていただけかも知れない into separate parts?
Why do C and C++ allow the expression (int) + 4*5?
Pointing to problems without suggesting solutions
How to leave only the following strings?
How can I introduce the names of fantasy creatures to the reader?
Sorting the characters in a utf-16 string in java
What could prevent concentrated local exploration?
How is an IPA symbol that lacks a name (e.g. ɲ) called?
Who's this lady in the war room?
/bin/ls sorts differently than just ls
A German immigrant ancestor has a "Registration Affidavit of Alien Enemy" on file. What does that mean exactly?
What helicopter has the most rotor blades?
What is the difference between 准时 and 按时?
Does the Pact of the Blade warlock feature allow me to customize the properties of the pact weapon I create?
tabularx column has extra padding at right?
MS Project 2010 / Excel Create: S curve and add forecast line based on Remaining work
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)Add custom colors in Excel 2010Fill handle doesn't work, Excel 2010Excel 2010 Macro to create new sheet, and renameHow to Fix Excel Graph to stop drawing line when data ends (not auto extend line to zero)?Excel 2010 populate based on another sheetExcel 2010, Insert/Create Word Object, Display Page 2 Onlyexcel 2010 add months to 31 day monthexcel 2010 line chart issueBuilding S-Curves for projects in Excel using functions on dates and expected completion percentagesCannot lookup value and create conditional formatting in excel 2010
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel.
I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.
Probably very simple to Super users but I am struggling.
Regards
peter
microsoft-excel-2010 microsoft-project-2010
New contributor
add a comment |
I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel.
I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.
Probably very simple to Super users but I am struggling.
Regards
peter
microsoft-excel-2010 microsoft-project-2010
New contributor
add a comment |
I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel.
I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.
Probably very simple to Super users but I am struggling.
Regards
peter
microsoft-excel-2010 microsoft-project-2010
New contributor
I can created an S curve in excel using planned / actual based on man hours and timescale from Project (task usage, BL hours and Actual hr fields )and put into excel.
I am trying to find a way to use the remaining hours (after changing the status date and Updating Project) but there is no field for that in Task usage. I want to be able to transfer them to excel so that the remaining hours are showing in the timescale used for the S curve and then I can add a forecast line to my graph.
Probably very simple to Super users but I am struggling.
Regards
peter
microsoft-excel-2010 microsoft-project-2010
microsoft-excel-2010 microsoft-project-2010
New contributor
New contributor
New contributor
asked 6 hours ago
Peter NPeter N
11
11
New contributor
New contributor
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Peter N is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1428403%2fms-project-2010-excel-create-s-curve-and-add-forecast-line-based-on-remaining%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Peter N is a new contributor. Be nice, and check out our Code of Conduct.
Peter N is a new contributor. Be nice, and check out our Code of Conduct.
Peter N is a new contributor. Be nice, and check out our Code of Conduct.
Peter N is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1428403%2fms-project-2010-excel-create-s-curve-and-add-forecast-line-based-on-remaining%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown