Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Resource Allocation

23 replies [Last post]
Wed, 2003-12-24 03:24
Anil Gupta
User offline. Last seen 16 years 37 weeks ago. Offline
Joined: 18 Aug 2003
Posts: 27
Groups: None
Hi All
Would You please let me know whats the fastest way of allocating multiple resources to activities.I tried using Global change...There also i had follow two or three cycles for allocatiion..

I would appreciate the early and elaborate answers..
Thnx in advance
Anil
Top

Replies

Thu, 2004-03-04 02:45
#1
Tara Muddappa
User offline. Last seen 17 years 32 weeks ago. Offline
Joined: 17 Dec 2002
Posts: 26
Groups: None
Hi Muneer,

I am interested in knowing more on CCS software. Could you please email your contact number so that I can speak to you on the phone. (tarabm@emirates.net.ae)

Tara Muddappa
Top
Mon, 2004-03-01 22:50
#2
Mohammed Muneeruddin
User offline. Last seen 6 years 19 weeks ago. Offline
Joined: 11 Jun 2003
Posts: 28
Groups: None
hi friends,
I switched to CCS for being user friendly in resources allocating and cost control. The main thing is that we speak the same language what we did for preparing the estimate.
Further during the pre-bid stage we use the cashflow module for predicting the amount and timing of maximum funding required.

Regards,
muneer
Top
Mon, 2004-03-01 12:53
#3
Luca Basile
User offline. Last seen 9 years 41 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
How is CCS?
I have saw it 3 years ago, and it was not so much user friendly, but was very easy to aggregate resoruce at different level as in Artemeis.

Top
Sat, 2004-02-28 06:55
#4
MK TSE
User offline. Last seen 4 years 24 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Sample Excel with RA is available on P3 CD under folder RA\sample\Excel.. There are several X-L files, each for different purpose.

However, I want a RA in Access2k, CD’s one is Access97 only, who help me?
Top
Fri, 2004-02-27 23:54
#5
Mohammed Muneeruddin
User offline. Last seen 6 years 19 weeks ago. Offline
Joined: 11 Jun 2003
Posts: 28
Groups: None
hi Luca,

Can you please send to me the xl file. my e-mail address is muneer@gb-llc.com.

By the way I switched over to CCS for this same reason of allocating the resources to activities.

Thanks in Advance

Muneer


Top
Fri, 2004-02-27 15:13
#6
Ali Vessali
User offline. Last seen 7 years 22 weeks ago. Offline
Joined: 16 Sep 2001
Posts: 55
Groups: Building Information Modelling, TILOS
Hi Moises,

May I have a copy of that sample you are talking about.
My E-mail address is avessali@ellisdon.com

Cheers,
Ali
Top
Fri, 2004-02-27 07:05
#7
Dinesh Kumar
User offline. Last seen 6 years 29 weeks ago. Offline
Joined: 3 Jan 2004
Posts: 37
Groups: None
Hi Luca,

Can you please send it to me my email address is
dinesh_69@msn.com.

Thanks & regards

D.Dinesh Kumar
Top
Fri, 2004-02-27 01:20
#8
Luca Basile
User offline. Last seen 9 years 41 weeks ago. Offline
Joined: 10 Jul 2003
Posts: 288
Groups: TILOS
If You sent me Your email I will send You an excel application, using RA engine, that will semplify the
resource allocation, as is build up an activity/resource matrix.
And the import export functions are just done clicking on a bottom comand.
Top
Sat, 2004-02-14 07:03
#9
MK TSE
User offline. Last seen 4 years 24 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Moises,
May I know which version of MsAccess you have? I have 97 version and want to get the 2k or later.
I try to convert the code myself but still not successful.
Top
Wed, 2004-02-11 08:30
#10
Forum Guest
User offline. Last seen 17 weeks 3 days ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Hi Moises,

Here is my email address

dinesh_69@msn.com

Thanks a lot
Top
Wed, 2004-02-11 08:27
#11
Zq qz
User offline. Last seen 12 years 45 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
DINESH,
IF OK FOR YOU CAN YOU GIVE ME YOUR E MAIL ADD SO THAT I CAN GIVE YOU SAMPLE.

REGARDS,
Top
Wed, 2004-02-11 07:57
#12
Dinesh Kumar
User offline. Last seen 6 years 29 weeks ago. Offline
Joined: 3 Jan 2004
Posts: 37
Groups: None
Hi Moises,

Can you please explain how to do it.

Thanks & regards

Dinesh
Top
Tue, 2004-02-03 08:20
#13
Zq qz
User offline. Last seen 12 years 45 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Hello Guys,
if your familiar with any dbase prog i. e MS Access this is more efficient by using standard template , then import / export option. thanks
Top
Tue, 2004-02-03 05:01
#14
Podolny Andrew
User offline. Last seen 20 years 26 weeks ago. Offline
Joined: 27 Jan 2004
Posts: 5
Groups: Petro-Chem / Oil & Gas
Hi, guys.
Why don’t you use P3 extensions. See installation diskSupportUtils. There are a lot of utilities in Excel format (see subdir Excel). For resources allocation use ACTIVITY.XLS or ActivityMod.XLS programs (be sure that u have Security level set to Medium in Excel) otherwise the macros won’t work. Check the main worksheet - it’s self-explanatory. Good luck!
Top
Fri, 2004-01-23 22:23
#15
MK TSE
User offline. Last seen 4 years 24 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
To solve one time import only, we need listed add input line on the speadsheet.
Most situation, we fail on the additional lines due to the range of import on shhet is not specified or revised.
e.g. if we export for 10 lines as template, then we change those value and add 10 more lines. Only first 10 lines are import successfully and the new 10 is ignored. It is due to the specified range still lock to the original records.
Top
Wed, 2004-01-21 05:37
#16
Ali Hamouda
User offline. Last seen 8 years 26 weeks ago. Offline
Joined: 3 Feb 2002
Posts: 109
Groups: None
hi Anil.

I am applying the following way :

repeat the activity ID and assign different resources as much as you repeat the ID of the activity in Excel sheet.

ex.

ID Resource

z100h Plumber
z100h welder
z100h helper

and so on for any number of resources

this is similar to import 3 times.but if you repeat the activiy 3 times you will import 1 time

Top
Mon, 2003-12-29 11:10
#17
Bhuvaneswaran Vel...
User offline. Last seen 6 years 26 weeks ago. Offline
Joined: 28 May 2003
Posts: 19
Groups: None
Ok,I think you misunderstood, I told to insert as many similar lines in X-L using macros and u can add the additional recourses automatically in a single import.

Yes, I accept that the step mentioned by importing two or three times will also help. Which ever easier and most familiar we can use.
Regds.,
Top
Sun, 2003-12-28 19:24
#18
MK TSE
User offline. Last seen 4 years 24 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
I don’t use macro, just find and replace, i.e find resource A and replace all by resource B.
Number of key strokes are open X-L, Ctl-H, enter resource A, tab, enter resource B, Ctl-A, save X-L, close X-L.
The X-L is ready for import.
Top
Sun, 2003-12-28 10:27
#19
Bhuvaneswaran Vel...
User offline. Last seen 6 years 26 weeks ago. Offline
Joined: 28 May 2003
Posts: 19
Groups: None
Dear,
But if you use macros in X-L, I feel you can do within one time import. I used it to add several resources in less time.
Any other suggestion we will discuss.
Regds.,
Top
Sat, 2003-12-27 22:18
#20
MK TSE
User offline. Last seen 4 years 24 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Yes, you right. One row for one resource only on spreadsheet.
My practice is each import by Excel is only for one resource. After import, then in Excel find and replace the resource from A to B, save and for another import.
I prefer this methodology for easy control. Each time only one resource import, if any go wrong, easy to trace.
Top
Sat, 2003-12-27 08:29
#21
Anil Gupta
User offline. Last seen 16 years 37 weeks ago. Offline
Joined: 18 Aug 2003
Posts: 27
Groups: None
Thnx gentlemen for your advice,I tried export/import function also.
But incase of Mutliple resources in one activity.It is still a cumbersome method. Comma sintex does n’t work...i have to create separate row with different resouce for allocation..E.g if i have to allocate resource A & B to activity 1 then just by putting A,B in resource Id column, it doesn’t work.It can be done only by creating a separate row for activty id 1 and then allocating both resources separetly in two cells accordingly.
In that case i think global change is still faster method.
Please comment if i am wrong in export / import method or if there is anyother way.
Regards
Anil
Top
Thu, 2003-12-25 23:52
#22
MK TSE
User offline. Last seen 4 years 24 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 550
Groups: None
Use import method is faster than Global change. To prepare the Excel template by export the required field out for data input.
Top
Wed, 2003-12-24 11:46
#23
Bhuvaneswaran Vel...
User offline. Last seen 6 years 26 weeks ago. Offline
Joined: 28 May 2003
Posts: 19
Groups: None
Dear.,
Did u tried to use export/import function through X-L. It is the fastest way to add resources for many activities.

Regards.,
Top