Creating UDF and Distributing Similar to Activity Usage Spreadsheet

Hi Everyone:

I am trying to figure out a way to distribute a user-defined field (qty) across activities like what is done on the activity usage spreadsheet. I want to avoid entering nonlabor units, etc. as the schedule is updated solely on earned hours. Any suggestions? I am willing to use Excel as an alternative to doing this in P6.

 

Jon

P
Paul Harris 👤 Member for 25 years 2 months

My understanding is that it can not be done. I usually use Exenses to get a cash flow without using resources.

There is an article on my website www.primavera.com under technical articles that shows how this can be achieved using Excel and there are some samples to work with.

Paul E Harris

Eastwood Harris Pty Ltd, Melbourne, Australia

Planning and Scheduling Training Manual & Book Publishers, Consulting and Training

www.eh.com.au

www.eastwoodharris.com

www.primavera.com.au- a Primavera scheduling software resources site

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts