TimeScaleData

[Juan]

Hi!

I have a question about using TimeScaleData in order to import some values
from MS Project to MS Excel.

I was wondering if it is possible to customize the TimeScaleUnit to make it
pic Resource.TimescaledCost and Resource.TimescaledWork half-monthly.

The aim is to be able to fill in a table in Excel which runs fornightly with
the values of scheduled costs and scheduled work hours. I havent been able to
find a predefined TimeScaleUnit.

I hope there's someone.... who can help me with this.
Thanks in advance.

 

[Jan De Messemaeker]

Hi,

You will have to loop through the daily values and make the appropriate sums
I'm afraid - or make the sums in Excel of course.

Hope his helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Juan]

Hi, Jan.

What a pity, I guess.
Thanks for the information anyway.
I'll try to get it done by looping through the daily values.

Best regards

 

[Rod Gill]

Hi,

The timescaled data handles fortnightly: set timescale to weeks and units to
2. It does not handle half of any unit.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Juan]

Hi,

thanks for your reply!
I would like to ask you something more.
If i do so, am i going to get data half-monthly, that is from the 1st to the
15th and from the 16th to till the end of every month?
Most important is to me to have each 2nd interval starting at the 1st of
every month.
That would be exactly what im looking for.

Thank you again for your help.
Best regards,

 

[Jan De Messemaeker]

Hi,

Two weeks is not a half month I'm afraid, and two times 2 wieeks will not
lead youto the first of next month.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Jack Dahlgren]

I'd get it by day and then aggregate in code using some date math and
different conditions.
It is a fairly difficult piece of code to post here without taking time to
check that it is working correctly, but the basics would be to define some
sort of routine which will add the first 15 TSV's for a month and then the
remaining TSVs and write that out.
It isn't hard to write, but it will take time to test and debug and I don't
have time.

-Jack Dahlgren

 

[Juan]

Hi,

Yes, it seems to be so.
I'll try it daily.

Thanks for the advices.
Kind regards,

Juan.

 

[Juan]

Hi,

thank you for your help.
I will try it as you say.

@all
Of course, I'd be very grateful with any suggestion for this routine.

Best regards,

Juan.