Recalculate project with variable ressources

[Jean-Yves]

Hi all,

(Just find out that project.Vba was not active anymore, sorry for X posting)

I looking for a direction/guidance on how to do the above.
For a given project, the ressource are based on the number of student per
course.
Depending on how many student per intake we get, the required ressources
will vary.
How can this parameter be assigned to a variable.
Questions :
Can it done in the project itself, trough a formula (via a custom
function)
Do you do it VBA and wich object can do this

I am a XL VBA specialist, not project, but my collegue asked how this could
be done in ms project.
TIA

Regards,

Jean-Yves TFELT

 

[Rod Gill]

You would have to do this in VBA. However, it doesn't sound like you are
scheduling a Project, so why use MS Project? Why not Excel?

 

[Jean-Yves]

Good morning Rod,

We are planning the training of Radar controller for the next years,
We need to request necessary ressources (classrooms, simulators - positions,
instructors, pseudo pilots, etc ) for each intake
of ab Initio students. Althought we plan the number of student who will be
recruited, we don't now in advance how many will
be successfull at the academy and will be send to our unit for further
training.
So ms project shows us correctly any conflict of ressources (like the
simulator) because the courses are overlapping
We have 3 intakes per year with a unit training phase between 12 and 20
months.

So, if you still have any hint for me to dig in the help file or object
explorer ?
Thank you in advance
Regards
Jean-Yves Tfelt

 

[Rod Gill]

Unless your admin staff are expert Project users I would use Excel. Rather
than a project you are managing an ongoing process, which isn't a project
and has different needs. yes you can get Project to do what you want, but I
doubt it will give a better result and would potentially create many
problems.