Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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 reference?

Many thanks
--- eric

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.