|re: what is the best way to use exel in a schedule format? |
Your question is so broad as to be impossible to answer.
re: I need to track percent of completion of about 25 jobs with a cumulative percentage total
That, in and of itself, is quite straight forward.
All you need are cells for each job that hold a formula to calculate the "percent of completion" for each and then one cell to SUM them all.
That said, how you determine the percentage complete is totally up to you. If a job has five tasks, is it as simple as "It's 80% complete when 4 tasks are done" (4*20%) or do the 5 different tasks have different weights? (15%+20%+10%+5%) In other words, 4 out 5 tasks are done, but the job is only 50% complete.
We would need a lot more detail before we could even begin answering your question.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.