Creating customized Resource Allocation view in Sharepoint

• Freitag, 22. Juni 2012 16:46

   

   
  

  0

  Hello All,

  I want to create a customized view as below that has each week's resource allocation for each project in 2 locations. The rows would be the project name and each project would have two locations(NYC and SFO) along with allocation for NYC and SFO. The two managers in these locations would be maintaining two different sharepoint lists where they enter the start date, project name and the resources allocated to the project for that week. So my job is combine those 2 sharepoint lists and create the below view. For each new project added in the managers sharepoint list, it should create a new row in this view and display the allocation details. I'm facing problems in creating the dynamic rows while combining the lists. Please let know if this is possible in Sharepoint or I'll have to use some other tool.The Overall row should be at the end and any new project should be added in the row above Overall. Please let me know if this is feasible in Sharepoint.

  Project Name	Locations	Jul 2	Jul 9	Jul 16	Jul 23	Jul 30	Aug 6	Aug 13	Aug 27
  9.1 Regression	NYC	12	10
  	SFO	3	4
  Merge UAT	NYC	5
  	SFO	1	1	1	1	1
  Req. Capacity	NYC	17	10
  	SFO	4	5	1	1	1
  	Overall	21	15	1	1	1
  Available Cap.	NYC
  	SFO

  Thank you.

  Rohit B Pillai

  
  

  • Bearbeitet Rohit Pillai Freitag, 22. Juni 2012 16:49
  •  
  • Antworten
  • Zitieren