AnsweredAssumed Answered

Question on role capacity segments in Portfolio XOG

Question asked by Rob-BBT on Apr 7, 2015
Latest reply on Apr 8, 2015 by Rob-BBT

I am looking to build a process that will XOG in the current available capacity for roles into a portfolio plan to show up on the Targets page.  Basically I will do a SQL query to determine what the remaining available # of FTEs is per role factoring out all approved projects resources associated to the roles are booked to.

 

I XOGed out a test portfolio to see how the structure is set up and I am trying to understand how it is getting the values for the segments.  See example:

 

These numbers are really large and also don't fit neatly into even monthly segments as they appear on the Targets page.  I'd like to know what these values are based on as I've tried many different mathematical equations trying to look at the totals and never seem to get close.

 

<Role code="ANALYST_BUSINESS" target="0.0">

                            <capacity>

                                <Segment finish="2015-01-02T00:00:00" start="2015-01-02T00:00:00" sum="53327.01075162037"/>

                                <Segment finish="2015-01-08T00:00:00" start="2015-01-05T00:00:00" sum="227825.67211692382"/>

                                <Segment finish="2015-01-09T00:00:00" start="2015-01-09T00:00:00" sum="56437.93127528658"/>

                                <Segment finish="2015-01-12T00:00:00" start="2015-01-12T00:00:00" sum="56437.93127528658"/>

                                <Segment finish="2015-01-15T00:00:00" start="2015-01-13T00:00:00" sum="170869.25408769285"/>

                                <Segment finish="2015-01-16T00:00:00" start="2015-01-16T00:00:00" sum="54882.471013453476"/>

                                <Segment finish="2015-01-19T00:00:00" start="2015-01-19T00:00:00" sum="1036.9735078887359"/>

                                <Segment finish="2015-01-20T00:00:00" start="2015-01-20T00:00:00" sum="56437.93127528658"/>

                                <Segment finish="2015-01-22T00:00:00" start="2015-01-21T00:00:00" sum="113912.83605846191"/>

                                <Segment finish="2015-01-23T00:00:00" start="2015-01-23T00:00:00" sum="56437.93127528658"/>

                                <Segment finish="2015-01-26T00:00:00" start="2015-01-26T00:00:00" sum="56956.418029230954"/>

                                <Segment finish="2015-01-27T00:00:00" start="2015-01-27T00:00:00" sum="57474.90478317532"/>

                                <Segment finish="2015-01-28T00:00:00" start="2015-01-28T00:00:00" sum="56956.418029230954"/>

                                <Segment finish="2015-01-29T00:00:00" start="2015-01-29T00:00:00" sum="57474.90478317532"/>

                                <Segment finish="2015-01-30T00:00:00" start="2015-01-30T00:00:00" sum="56956.418029230954"/>

                                <Segment finish="2015-02-02T00:00:00" start="2015-02-02T00:00:00" sum="57474.90478317532"/>

                                <Segment finish="2015-02-04T00:00:00" start="2015-02-03T00:00:00" sum="113912.83605846191"/>

                                <Segment finish="2015-02-06T00:00:00" start="2015-02-05T00:00:00" sum="112875.86255057316"/>

                                <Segment finish="2015-02-11T00:00:00" start="2015-02-09T00:00:00" sum="172424.71434952595"/>

                                <Segment finish="2015-02-13T00:00:00" start="2015-02-12T00:00:00" sum="113912.83605846191"/>

                                <Segment finish="2015-02-16T00:00:00" start="2015-02-16T00:00:00" sum="1036.9735078887359"/>

                                <Segment finish="2015-02-17T00:00:00" start="2015-02-17T00:00:00" sum="56437.93127528658"/>

                                <Segment finish="2015-02-18T00:00:00" start="2015-02-18T00:00:00" sum="56956.418029230954"/>

                                <Segment finish="2015-02-20T00:00:00" start="2015-02-19T00:00:00" sum="114949.80956635064"/>

                                <Segment finish="2015-02-23T00:00:00" start="2015-02-23T00:00:00" sum="57474.90478317532"/>

 

Outcomes