Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Joycelet
  • Order by date
  1. Joycelet

    Split Pivot Chart Data?

    Hi Thanks for all your help - I was being stupid and had the formula in the wrong spreadsheet. All working as should now! Again Thanks N
  2. Joycelet

    Split Pivot Chart Data?

    Hi Sorry it's a hidden column - Column C. N
  3. Joycelet

    Split Pivot Chart Data?

    Hi I'm sorry that my explanation wasn't very good - I'll try again. The raw data is used to create a pivot table that takes the Resource Group as the Report Filter. The pivot table then shows the dats by months in the rows and by Status in the columns. This is then used to plot a graph - all...
  4. Joycelet

    Split Pivot Chart Data?

    Hi Skip Below is a sample of the raw data: Resource_Group Resource_Names Start_Date Finish_Date % Complete 01/08/2007 01/09/2007 01/10/2007 01/11/2007 01/12/2007 A NJ 12/12/2007 11/01/2008 0% 0.00 0.00 0.00 0.00 15.00 A JJ 27/08/2007 01/02/2008 60% 5.00 21.00 24.00 22.00 22.00 A NJ 08/01/2008...
  5. Joycelet

    Split Pivot Chart Data?

    Hi Thanks for the quick response - what is being returned is the following: Group Code A 0 A 0 A 0 A 0 A 0 A 1 A 1 A 1 A 1 A 1 etc etc. I then concate them into the Full Group: Full Group A - 0 A - 1 Which is great - but then...
  6. Joycelet

    Split Pivot Chart Data?

    Hi I have tried put the code onto the source sheet but because the department can be repeated over 100 times this isn't returning what I need. Below is a sample of the source data: Group Name Start End A NJ 01.01.07 30.01.07 A NJ 02.02.07 02.02.07 B...
  7. Joycelet

    Split Pivot Chart Data?

    Hi I have a pivot table that produces a pivot chart but depending on which department is selected the number of staff can make the chart unreadable. Is there away of saying have only 6 people per chart based on the selection of from the pivot table page? Thanks for any help with this N
  8. Joycelet

    Changing how data is plotted with a PivotChart?

    Hi I'm using a pivot table to plot a chart - if I only plot on person the chart works fine, but I will need to plot by numerous people. The chart is a stacked chart so will show for each month stacked data based on A, B and C for each person. But when I add a person to my pivot table - the...
  9. Joycelet

    TimeScaled Excel Spreadsheet - Networkdays

    ...consideration the % completed and spread this over the remaining months? Any help greatly received =IF(STATUS="FE",0.75,IF(STATUS="E",0.25,1))*IF(OR($D3>H$1,$E3<G$1),0,NETWORKDAYS(IF($D3>=G$1,$D3,G$1),IF($E3>H$1,H$1,$E3)))/21 The spreadsheet is set out as follows: Names Status %...
  10. Joycelet

    removing carriage return from records

    Hi Not sure if you have resolved this - but you need to look at the clean option, which will remove non printable characters and also the find and replace. Find all character returns and replace with a "," Hope this helps Nicola
  11. Joycelet

    Excel working with Timescale Data?

    Hi 1 is the result of the networkday (start date - finish date) - so 1 day out of 21 is 5% I then need to take the 5% and if 50% has been completed it should say 2.5% remaining but I cant seem to get it to produce what i need? Duration % of Month % Complete Remaining 1 4.8% 50.0% 2.4% I...
  12. Joycelet

    Excel working with Timescale Data?

    ...- it will show as 5% in the cell. What I now need to do if take away the % complete from the result? =IF(STATUS="FE",0.75,IF(STATUS="E",0.25,1))*IF(OR($D3>H$1,$E3<G$1),0,NETWORKDAYS(IF($D3>=G$1,$D3,G$1),IF($E3>H$1,H$1,$E3)))-F3 When i try and then set this to / by 21 days and set a...
  13. Joycelet

    Excel working with Timescale Data?

    Hi Thanks - that has worked a treat N
  14. Joycelet

    Excel working with Timescale Data?

    Hi Thanks for the fast response - I have looked at product and that just what i need, i have created: =PRODUCT(D3:E3) How should I combine this with the previous code? N
  15. Joycelet

    Excel working with Timescale Data?

    Hi Skip Sorry for not giving you all the information. Here is the full spreadsheet: Name Status Probabilty Baseline Actual Start_Date Finish_Date NJJ A 100% 1 1 23/08/2007 23/08/2007 NJJ B 75% 5 3.75 17/09/2007 21/09/2007 NJJ B 75% 10 7.5 03/09/2007 14/09/2007 NJJ B 75% 10 7.5 22/10/2007...
  16. Joycelet

    ACT! replacement

    Hi Have a look at Outlook 2007 - as this have a business contact manager included, haven't played with myself but think it maybe something to look at N
  17. Joycelet

    Excel working with Timescale Data?

    Hi Thanks for the quick response - that works great for the standard duration. But i have a modified duration that is a calculated field. How could I get the above formula to look at the calculated duration not the actual duration? The calucation is: If Status A then 100% of actual duration...
  18. Joycelet

    Excel working with Timescale Data?

    Hi This is how the the data is currently set out: NJJ 22 days 06/08/2007 08:00 04/09/2007 17:00 NJJ 10 days 06/08/2007 08:00 17/08/2007 17:00 NJJ 1 day 03/09/2007 08:00 03/09/2007 17:00 NJJ 1 day 04/09/2007 08:00 04/09/2007 17:00 NJJ 0 days 04/09/2007 17:00 04/09/2007 17:00 NJJ 15 days...
  19. Joycelet

    Excel working with Timescale Data?

    Hi I have looked at the workday function but this doesn't seem to give me what I would be looking for - unless I'm missing something? I need excel to look produce something along these lines Resource Name - J F M A M J J etc as columns and then split the work remaining using the start and...
  20. Joycelet

    Excel working with Timescale Data?

    Hi I have exported data out from Project and have the following fields: Resource Name, Status, Work Remaining, Start Date, End Date What i need to be able to do is to show the work remaining by month, taking each month to have 21 working days available. So for example if a task start...

Part and Inventory Search

Back
Top