Messages

Ok thanks, perhaps it could be useful tu add this feature in the future..
I see that if you put it in when you create the activity, then you have the ability to change it later

You cannot view this attachment.

so I think it really misses the feature to just add it to a split activity allready inside the timetable.

I have the same issue...
We have 6 hours per day, some teachers want to work maximum 4h a day, some others are willing to work up to 5h a day one teacher told me he can also work 6hours..

For the teachers willing to work 5 or 6 hours a day I would like this to happen only one day a week.
But then a second day could have a break, so the teacher is at school 5h, but only 4 of them are with students..

I allready put minimum hours per day (2 for each teacher) and maximum hours per day (4, 5 or 6 per day, depending on the teacher).. I also put maximum 1h a day and 3h a week for "ore buca" so hours when the teacher isn't in a class and 2h a day and 3h a week for those teachers who want to stay only 4h in class...

(hope I explained everything well)

Now my problem is that some teachers are working 5 hours two times a week.. I tried "Teachers max span" but it doesn't generate a timetable.. what else could I try to solve this issue?

Allora, quando hai creato le attività hai messo che sono su giorni diversi (con peso al 98% o 99%)?
PS il tuo totale delle ore fa 5 e non 6 

Se invece pensi che quelle piccole da 1+1 possano cadere anche lo stesso giorno (magari in successione) allora assegna una chiave (ad esempio MAT) e un vincolo per gli studenti (gli studenti hanno massimo un certo numero di ore al giorno con chiave MAT)

You cannot view this attachment.

Se decidi di fare così poi puoi scegliere se farle cadere consecutive nel caso te le metta lo stesso giorno oppure se per te è uguale le lasci così come vengono...

So, you can enter the min days between activities constraints and modify multiple constraints at once, or Advanced->Spread activities over the week.

I tried the option Advanced->Spread activities over the week but in my case it isn't what I was searching for...
You also say that I can enter the min days between activities constraint.. but I cannot find it for activities that allready exist..
for the moment I just deleted the activities and created them again with csv import.. but let me know, so perhaps next time I know where to look at.

Thank you!

Oh, then maybe the min days between activities constraints lost their "consecutive if on the same day". But note that FET won't put 3 subactivities on the same day (FET can put 2+1, if there are two subactivities with durations 2 and 1).

oh this is interesting... didn't know the 3 activities thing.. will be useful in order to remove redundant limitations like "maximum number of hours of certain activity per day" etc.

As soon as I can get back to my timetable I will let you know if this worked.

Thank you for your super-quick answer.. but the problem is quite easy.. I don't need to act on the gaps (because this is all set, and because the teacher is in other classes so it doesn't create a gap).
I just want the program to know that if it puts two or three of this activities in the same class the same day I would like that they are consecutive.
This happens without problems when I create the activities from scratch (importing them from excel) but if I don't set this when I create them how can I add it later?

Ho inserito i dati iniziali del mio orario, poi per svariati motivi ho dovuto modificare tutte le ore di lettere creando dei blocchi di ore singole... l'orario si chiude però vedo che talvolta la docente entra in classe 3 volte una singola mattina, in ore NON consecutive.
Posso aggiungere il vincolo "forza consecutive" in un secondo momento?? Da modifica attività o modifica sub-attività non mi sembra di vederlo.. e nemmeno mi pare di aver trovato l'opzione corretta nella finestra tempo.


Grazie

Thank you!!

Ad far as I know, this teacher could change school in a few days..  He just arrived, but there was a problem with assigning the teachers.. so the principal told me not to go mad about this request because it is 99% sure he will change school! 

Good for me, so I can go back to the timetable without this "problem" 

I think you need a customization.

Other solutions might include: add teacher max building changes per week/day, and adding a dummy activity for this teacher, forced in building A on Monday.

This solution is exactly what I was thinking about, but it implies 2 problems: I need to break the rule "not more than 4hours/day", but this could be a minor problem.. and I need the teacher to be able to move from one school to another on the same day (max 3 per week), but not on monday, but how to set this in fet?

I was also thinking to create a dummy activity (4 hours) for a dummy teacher with no students and to place it in building A on mondays, then try to say that at least 2 of the 3 activities of the real teacher are on the same day of dummy activity.. perhaps this could be a workaround?

Hello,
in my school there are 3 buildings and 9 classes (3 for each building).
One teacher has activities in all of these classes, there are 9 activities, each lasts 2 hours.
Usually the timetable of this teacher is like this: on 4 days he works 4 hours and on one day 2hours.

Now to my problem, the teacher would like to be in building A on mondays.. now in building A there are 3 activities total, but on one day he can do only 2.. I don't like to force one class in particular to be on monday, because I don't want to create a too strong constraint.. so I want the program to choose which two activities to put on Monday, but how can I tell the app that I want this teacher in building A?

Thank you in advance! 

Salve
ho modificato e aggiunto alcune righe di codice dello script di Marco Albano, per export in Excel delle tabelle prodotte da Fet per sistemi x64.
Le prove effettuate in Win10 x64 ed Excel 2016 64bit

Buonasera!

intanto grazie mille per il lavoro svolto, è da oggi che cercavo di capire come fare per usare il convertitore di Marco sui miei PC a 64 bit. 
Purtroppo però il file allegato al tuo post mi restituisce un errore.. ho provato con 2 orari differenti, ma il risultato è lo stesso:

Code Select Expand

For i1 = 1 To ndoc
ActiveCell.Offset(i1, 0).Value = docenti(i1)
    For i2 = 1 To nattivita
        If attivita(i2, 0) = docenti(i1) Then
            gg = attivita(i2, 4)
            hh = attivita(i2, 5)
            For i3 = 1 To attivita(i2, 6)       'ATTIVITA(X,6) = durata lezione
                lora = (gg - 1) * nhh + hh + i3 - 1
                prec = ActiveCell.Offset(i1, lora).Value
                If prec <> "" Then prec = prec + "-"
                ActiveCell.Offset(i1, lora).Value = prec + attivita(i2, 1)
            If ((attivita(i2, 7) = 1) And (gcons = 1)) Then
                  ActiveCell.Offset(i1, lora).Font.ColorIndex = 3
            End If
            Next
        End If
    Next
Next
Il messaggio dice: Errore di run-time '13':
Tipo non corrispondente e se clicco su Debug mi colora di giallo la riga: lora = (gg - 1) * nhh + hh + i3 - 1 quindi è lì che qualcosa non gli piace..

Spero di esserti stata d'aiuto.
Patrizia

Ho lo stesso problema.. si è trovata per caso una soluzione nel frattempo? 

Here I am again, sorry if I did not answer earlier but was doing urgent timetable in this days... coming back to my problem..
so here some answers to Vangelis:

question 1. for the moment I have a constraint on maximum days per week for teacher 1 and 2 of 5 days, so fet automatically leaves one day free.. and that's ok for me now.

For the second question:
1. normally teachers should not exceed 4 hours a day and not less than 2h, but on that day they could also teach for 5 hours
2. in this building we have teacher 1 for 18h/week, teacher 2 is in this building for 12h/week (I forgot that he also works on other building for 6h/week sorry!), teacher 3 works in this building for 6h/week and teacher 4 for 9h/week.
3. teacher 1 only one building, teacher 2 works 6h in building S, teacher 3 works 6h in building B and teacher 4 works 9h in building S
4. in would be better to be free hours.. eg the first hour before the usual lessons, or the last hour, but I can also accept gaps
5. our timetable has 5 hours per day

As written in a previous post, I decided to create a new subject, I have added 4 activities in this subject 1h hour per each of the 4 teachers, I have added a new room in my building and told fet that this 4 activities are in this room, I also told fet that this 4 activities are on the same day..

This works, but I have for example a teacher working from 8-9, then a gap, then this activity and then from 11 to 13 another activity.. this is not ok, because when the foreign studends don't attend their lesson this teacher has a two hour gap.. 

I know there is a solution.. but I still can't see it... 

Hello Vangelis,

no, there are some small mistakes:
1. teachers 1 and 2 are in this building 5 days in a week of 6 they have each one day off (but for the moment I dont' know which day, and I suppose it won't be the same day for them)
2. teachers 3 and 4 work in 2 buildings (teacher 3 works 5 days per week (no saturday), teacher 4 only works 4 days per week (no sat and wednesday)
3. only teacher 3 is allowed to move building in the same day

1. we need to have the 4 teachers in the same building ONLY ONE DAY per week
2. on this day only teacher 3 can work in other buildings
3. the gaps don't have to overlap

thank you!

one change per day, and then there is a weekly limit.. in any case my approach worked, but the resulting timetable still needs to be finetuned a lot.. but I will go on trying to use this solution.

What I did not mention is that when one of the 4 teachers meets the foreign students he is not doing activities in a class, he is at school on a free hour..

let's assume teacher Aa that works 2h, then he has 1h free and a 4th last hour of activity... well he meets the students in the third hour, the only thing I need is that each teacher has a different hour free, thats why I was thinking of this "phantom" activity and room, so that I don't have 2 teachers simultaneously.

It's a project to help students in need who didn't finish their studies, so they come approx once a month only one day to do 1h Italian, 1h French, 1h Maths and 1h English