Page 1 of 1

Seedcode for Aircraft and crew scheduling

PostPosted: Wed Aug 13, 2008 4:18 am
by maidanss
Hi John,
I am looking at a project for seedcode complete but I thought I better ask your opinion first and it depends on the amount and complexity of work whether it can be done or not. It certainly looks complex to me.
I need to modify seedcode to handle Crew scheduling for a small aviation outfit.
They have Aircrafts which go to destinations, flown by flight crew and served by cabin crew.
The Aircrafts and crew have time limitation of how many hours they can each fly in a day and they must have certain time rest between days work periods. The crew must have certain days off in any given 28 days.
I was trying to see what fits in place of projects, contacts, resources and users. Can you may be help me get an overall picture.
Do you think we can fit all this in seedcode and How would you go about fitting all the above in.

PostPosted: Wed Aug 13, 2008 10:06 am
by John Sindelar
Dear Salman,

Sounds like a cool project.

There is probably a need in here for a modification linking more than one resource to a project (a flight). There are a number of ways to make such a mod and I'd be happy to discuss it with you and/or to get you a price for this if you'd like to email me directly.

Aside from that, the *tough* stuff in a project like this really doesn't have much to do with the calendar. Our calendar doesn't have any business rules in it per se, so things like required crew members and and mandatory rest and service times are things you'd need to add to the calendar. But adding them to the calendar is no tougher than building them from scratch.

At the end of the day you're talking about one of two things (and maybe both):

- looking at a scheduled resource and determining if that resource is in compliance with work rules when it comes to a given appointment.

- and/or presenting as available a list of only-those-resources who would be in compliance with work rules if added to a given appointment.

And then there is a similar, but simpler, issue of making sure that a given flight (a project in SeedCode Complete) has all the required staff (resources).

Hope that helps,

PostPosted: Wed Aug 13, 2008 10:33 am
by maidanss
Thanks John,

I see where you are heading here. Would I be right in saying that you think the following:

- Contacts = Aircrafts
- Resources = Crew Members
- Projects = Flights
-Having a portal of resources (crew) related to project (flight)

That alone certainly gives me plenty to work with and thank you most sincerely.

I will work with that and let you know how I get on.

Regards

PostPosted: Wed Aug 13, 2008 11:17 am
by John Sindelar
Yes, though I might leave contacts for people and make aircraft a resource. Contacts might be great for it though.

PostPosted: Wed Aug 13, 2008 9:58 pm
by maidanss
Thanks,


Having looked at the relationships again, you are absolutely right, I will leave contacts for crew and resource for A/Cs. However there is a small issue, that is in the contacts layout (A/C) you a project portal (FLTs) where you would be able to see the rotation of any given A/C.