Project - project 2007 resources help
Asked By loukas_t
23-Nov-09 01:39 PM
Hi all,
Three questions:
1. What the constraint A<B,C means and how can I entering in the MSP?
2. I have 3 kinds of human resources. Lets say for example, kind A are
engineers. I have 8 of them and everyone is costing 1500 Euros/month.
Task A needs 4 engineers. How can I assign them to the task and add the
appropriate cost?
3. I have 3 machines as a resource. Each machine has a usage cost of
3000 euros per task and function cost 2400 euros per month. How can I
assign them in the appropriate tasks? And how can I distribute their
cost?
Thank you in advance
--
loukas_t
------------------------------------------------------------------------
loukas_t's Profile: http://forums.techarena.in/members/153572.htm
View this thread: http://forums.techarena.in/microsoft-project/1274342.htm
http://forums.techarena.in
VBA
(1)
Database
(1)
Window
(1)
Gantt
(1)
Euros
(1)
Max
(1)
Predecessors
(1)
Dapendence
(1)
Rod Gill replied to loukas_t
Hi,
No idea what you mean by A<B,C. Please explain
In the View Resource Sheet
Enter a Resource Engineer.
Set Max units to 800%
Set rate to the relevant Euro / hour (per month is not accurate as number of
working hours per month changes).
Enter Machines as a Resource
Enter cost/use of Euro 3000
Enter hourly rate
For each Task, assign resources (see help for assigning Resources) and costs
will display accurately
In a Gantt Chart select Window Split. Make sure the hours of work estimated
is accurate as Project calculates cost on hours*rate plus cost per use.
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
__________ Information from ESET Smart Security, version of virus signature database 4631 (20091123) __________
The message was checked by ESET Smart Security.
http://www.eset.com
<-> replied to Rod Gill
Rod thank you for the help.
Lets say that A,B,C are tasks and the relationship of these tasks (as a
dapendence) is A<B,C. Does it mean that B and C are predecessors of A or what?
Is it clear?
--
-
Rod Gill replied to <->
A<B means nothing to me except in an algebra context. What does it mean to
you? If you do not know, please ask the person who old you!
--
Rod Gill
Microsoft MVP for Project
Author of the only book on Project VBA, see:
http://www.projectvbabook.com
loukas_t replied to Rod Gill
I found this type of a constraint in a project's contents table. Anyway
I think this declares that task A has predecessors B and C.
Thanks Rod
--
loukas_t
------------------------------------------------------------------------
loukas_t's Profile: http://forums.techarena.in/members/153572.htm
View this thread: http://forums.techarena.in/microsoft-project/1274344.htm
http://forums.techarena.in
Jack Dahlgren MVP replied to loukas_t
I'd ask the person who put it there.
This sort of information needs to be interpreted in order to make any sort
of modeling decision.
-Jack Dahlgren
Server (1) Microsoft Project (1) Project 2003 (1) Project 2007 (1) Office (1) Oracle (1) VBA (1) Hi, You can go three ways: 1) stand alone application using .net and using automation to control Project and send data 2) Use a VBA macro in Project (called from an external program using automation and the Macro method) 3 data to send to project, then the copying of data between programs is slow. Once VBA has all the data it needs it is actually very fast as it is all is easier and quicker to develop code in that C# as you can: * Copy working VBA code to VB easily * VB intellisnese is better * VB allows optional parameters, which given the and maintain. - - Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 4659 (20091203) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com regard to: 1). I thought that 'automation' was no longer possible in Project 2007? 2) VBA macros are probably not up to our needs. There is an enormous amount of VB an ed ally g an ot ters hat ng with Also it this g ture database 4659 (20091203) _ __ __ __ __ _ Proj07 works fine with automation. I use Proj07 with automation, controlling Gantt
Project Developer Help content Project Hi, I found recently that the help available in the VBA Editor has changed for the worse. It looks nicer, but is content free. For instance office.12).aspx) but it used to be easier to get it directly from the VBA Editor. Pressing F1 on an object or proporty would get you the details, now I 1) The Project Object Model reference (1) Neil, With the release of Project 2007, the VBA help file took a turn for the worse and from a recent comment by one of our premier VBA MVPs, Project 2010 is even worse. I would say that if you find a way you need, (e.g. MSDN), then go for it. If I have to write some VBA code in Project 2007 I revert back to the VBA help file in Project 2003. John Project MVP Me too John, Project 2003 VBA help is much better! Don't forget the object browser as another way to find for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature
Enumerate Fields? Project Is there an easy way in VBA to enumerate all the available fields (names, aliases) in MS Project (i.e. "Number1", "Text2 for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 4869 (20100215) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com again, Eric No there is no list of used fields. You have to use some VBA to check them. I have a sample which is a good starting point here: http for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com Rod, If you can rely on a standard then so I cannot query a project for its fields, much like I can query an Access database table for its fields. I feel a painful bout of "manual labor" coming on. Regards for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 4872 (20100216) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com
TimeScaleData in MS Project shows "Unexpected error in method" Project Hi there, using the VBA code for accessing time scaled data I encounter the above error message (Unexpected error in on what line of code, the TimeScaleData line or a line reading the data? In VBA I do not know of any problem. I regularly produced code reading more than 9 for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 5035 (20100416) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com But unfortunately requires the number to be converted with Val Lars, the solution you suggest Ron does not help. I can read in the debug window even that the value I try to access is invalid. Forcing it to be a a consequence of poor code - not as I see myself to be the godfather of VBA programming but I have tried various code excerpts from the web, followed all your suggestions for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature
suggestions? Regards, Luc Project Discussions SQL Server (1) Microsoft Project (1) SystemsDOTcoDOTnz (1) Excel (1) VBA (1) Database (1) Report (1) BaselineSave (1) Hi, VBA is your only solution here I think. You also need to be very, very careful not files corrupt. You may have years or days. My personal solution is to use VBA to read milestone dates from files and to create snapshot master files each week (no for Project - http: / / www.project-systems.co.nz Author of the only book on Project VBA, see: http: / / www.projectvbabook.com _ __ __ __ __ _ Information from ESET Smart Security, version of virus signature database 5022 (20100412) _ __ __ __ __ _ The message was checked by ESET Smart Security. http: / / www.eset.com Copy: = 0, Into: = 1 End Sub You can get there by ALT+F11. A new window opens. In that window find right. This copies all start / finish dates to Start1 / Finish1. If you only want