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: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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