On 2012-06-08 05:48, Eric S. Johansson wrote:
I'm using a spreadsheet to track a project (yes I know not a good idea
but that's what the customer wants). Each task is listed with certain
number of days plus a slip factor. I calculate the project completion
date by summing the number of days and the slope factor and add that
to the previous date (which may have slipped which is why I reference
the next task off of that date).
How can I encapsulate the time calculations so that I use the same
cell equation for all of them? The patter I'm currently using is
letter -1 and letter -2 (number of days for project plus days of
slippage) plus date in number -1 (up one cell).
another question is if I insert a new row because I'm adding a task,
or delete a row, how can I make the total display automatically
without having to tweak the cell numbers?is there any form of symbolic
I might be doing something similar tracking expenditure but can't really
visualise your layout.
I have a column that would be the completion date of each task, that in
your case would be the end date of the previous task + task duration +
slippage of the current task.
I include an IF statement so that if I enter an actual completion date
in a column that is used in place of the date calculated for that
previous task and the new anticipated project completion date is shown
at the end.
You can hide the column calculating each completion date from the
previous so it does not clutter your sheet.
With an example I could help you a bit more.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy