Skip to content

Cost Loading/Resource Spreadsheet

Ariel MalibiranMember for 17 years 7 months
Created
10
2
0

guys, need some help here...

I have my resource/cost loaded schedule. Cost is assigned by providing it in the Budgeted Cost for each activities. However, when I'm viewing the resource usage spreadsheet on weekly timescale, the weekly cost for each actvities is calculated on monthly basis, which must be of course should be in weekly too. as i generate the cost tabulation/report it gives me the same loading as the resource usage spreadsheet which is wrong..I did change the Admin Preference Option so the interval to summarize & store resource spreadsheet will be on weekly basis but still i got the wrong one...i'm using p6.

hope someone could help and advise me how to fix this.

 

thank you,

ariel

10 replies

Oldest first
  1. 0
    Raymund de Laza ·

    Ariel, In the User

    Ariel,

    In the User preferences - Resource Analysis, select Interval for Time-Distributed resource cal to desired period.

    Then set your timescale to match the the above setting.

    Make sure in the admin preferences - Time periods uncheck Allow usersto specify the number of work hours ......

     

    Hope this will help.

  2. 0
    Vinod Raturi ·

    Dear All , After having used

    Dear All ,

    After having used P3 for all these years and now  planning in P6 is proving a nightmare . My First impression is it is not all user friendly . I may be wrong but it seems many user friendly options in P3 are  not available in P6.

    Any way guys appreciate if you can solve my problem. I have prepared a resource loaded schedule in P6 and clicked on resource usage icon . I was surprised to see figures in resource usage column long even after my project has ended.

    For eg as per my program labours will be used between april 2012 and dec 2013 and project completion date is Feb 2014. Imagine  my state when i found that 1) Figures for labour usage are being shown even for dec 2021 and is still continuing , and 2) Heading is being shown for another project so i am not sure whether the figure truely represents my opened project.

    Please enlighten on this.

     

    Thanks,

     

    with regards,

    Vinod

  3. 0
    Jerome Soriano ·

    vinod,check if the item

    vinod,

    check if the item having a continuing value in resource usage spreadsheet is cumulative (eq. cumulative labor units..etc).

    cumulative values in p6 resource usage spreadsheet are displayed continuously, but value is not inceasing after the planned project finish.

    just check, this maybe the case.

     

     

    jerome

     

  4. 0
    Ariel Malibiran ·

    Thanks Raymund,it is already

    Thanks Raymund,

    it is already in weekly basis/timescale, but still it is showing for monthly usage..

     

    ariel

  5. 0
    Ariel Malibiran ·

    slide1.jpg

  6. 0
    Ariel Malibiran ·

    slide2.jpg

  7. 0
    Ariel Malibiran ·

    slide3.jpg

  8. 0
    Raymund de Laza ·

    Ariel, In admin Preferences -

    Ariel,

    In admin Preferences - Time Periods, set the Hrs/day.. hrs/wk etc...

    Then on the spreadsheet pane right click and select spreadsheet options, clicCalculate Average and Click Base on Hrs per time period

     

    Hope this will help

  9. 0
    Ariel Malibiran ·

    still doesnt work...totals

    still doesnt work...totals are just divided into 6 automatically-cannot be changed; daily working hours is 8...

  10. 0
    Raymund de Laza ·

    pref.jpg

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?