Main Menu
Menu

Show posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Show posts Menu

Messages - Christoph Voelker

#1
Suggestions / Re: Automatic Activity Planning?
June 05, 2019, 02:15:50 PM
I'll send you Excel File and compressed FET File :)
#2
Suggestions / Re: Automatic Activity Planning?
June 05, 2019, 02:10:50 PM
It also doesn't solve when I have really really low values for the minimum hours. Hm, maybe I made some error in the generating code ...  ???
#3
Suggestions / Re: Automatic Activity Planning?
June 05, 2019, 01:54:55 PM
Hello,

thanks for the idea, I think I managed to generate this by Octave code. The FET File is 64 MB.

So, I thought about some "general" minimum value, so I edited the Excel file that the same general value is subtracted from every individual TargetHour. The idea was to distribute the "minus hours" equally over all teachers ...

But at the moment it won't solve, it stops at 337/340 activities. I think it's a bit problematic that this ActivitiesOccupyMaxRealTimeSlotsFromSelection needs a weighting of 100%?

Many greetings!
#4
Suggestions / Re: Automatic Activity Planning?
June 04, 2019, 08:04:04 PM
Thanks a lot. This is looking very good. I can make multiple tables and then check manually the Einsatzplan_teachers_working_hours_table(s).html for negative differences.

I think I can maybe also make this automatic: I could start FET from GNU Octave and generate timetables until no teacher has a difference which is maybe < -6 or so ... while ... do ...

Or is there a possiblity to make this an "overall" contraint?
#5
Suggestions / Re: Automatic Activity Planning?
June 04, 2019, 06:36:21 PM
Wohooo :)

Yes, please.
#6
Suggestions / Re: Automatic Activity Planning?
June 04, 2019, 06:33:11 PM
If you can "easily" write code to generate another HTML file like:

Teacher   TargetHours    ActualHours     Difference
AAA      26      20     -6
BBB      24      24      0
...

... well, Dear Liviu, how could I say "no" to such an offer?!?

#7
Suggestions / Re: Automatic Activity Planning?
June 04, 2019, 05:21:04 PM
Hello there,

the visible output of phase one (Einsatzplan_students_subjects_table.html) is already really nice.

But as we didn't care about a *minimum* of target hours yet, but only that the maximum is not passed over - is there a possibility to sum up the actual hours for each teacher and show it in another output?

Something like:
Teacher   TargetHours    ActualHours
AAA      26      20
BBB      24      24
...

Or is this information in some other file that I could import/convert with GNU Octave?

Greetings and thanks a lot,
Christoph
#8
Suggestions / Re: Automatic Activity Planning?
June 01, 2019, 08:55:52 PM
Okay, thanks for the clarification. I can imagine to do some more GNU Octave tricks between phase1 and phase2 then :)
#9
Suggestions / Re: Automatic Activity Planning?
June 01, 2019, 06:43:19 PM
Our hours/lessons are always 90 minutes and they count as "two".
#10
Suggestions / Re: Automatic Activity Planning?
June 01, 2019, 06:40:29 PM
Hello there,

I just played around with your feature to also make a normal timetable afterwards.

So I add real days and hours (5 days x 4 hours) in normal FET and import groups and activities from phase 1 (FET-AAP [pretty good! :)]).

When I now try to solve the timetable, I get: Cannot optimize for subgroup 19.O-B7 Automatic Group Automatic Subgroup, because the number of hours for subgroup is 23 and you have only 5 days x 4 hours in a week.

So, do I maybe need 8 hours per day?
#11
Suggestions / Re: Automatic Activity Planning?
May 17, 2019, 04:47:45 PM
Hello Liviu et al,

generally I'm totally fine with sharing this. But maybe at a little later stage?

I can imagine sharing the Excel file as well, which then was (for me) the base for the FET automatic activity planning. In that Excel file will then be teacher names like AAAA, BBBB, and randomly distributed "target hours". Maybe we could have a FET custom version, which is then not called "christoph-voelker", but "automatic activity planning" :)

But we will first have to get it working with the Target hours. Or is it working already? :)
#12
Suggestions / X not allowed, empty = allowed
May 17, 2019, 01:59:02 PM
Hello there,

I just wanted to put the point "X not allowed, empty = allowed" regarding the FET GUI up for discussion.

Because maybe it's not that intuitive. I think an "X" marks something "allowed" - like a treasure :) But this is maybe very philosophical. Especially if it is a black X - if it was a red X (forbidden color), maybe it would be different.

And something "not allowed" is maybe then an empty space or "-----".

This just came up to my mind. FET is wonderfully working with "X not allowed, empty = allowed" aswell :)
#13
Suggestions / Re: Automatic Activity Planning?
May 17, 2019, 01:41:22 PM
Hello,

in your example file liviu8.fet you defined 8 ConstraintActivitiesSameStartingDay.

They were all for the hour (= real group) 19.O-B7 connecting theory and practice for each subject.

Do I have to define these 8 constraints for each real group (8*33 = 264 times)? As I can write code to do this automatically, this wouldn't be a problem ...

But can we maybe make a more general constraint about this? Maybe using the activity tags theory and practice?

Thank you ...
#14
Suggestions / Re: Automatic Activity Planning?
May 14, 2019, 04:28:07 PM
Thank you!

Can you read *.xlsx files?

I would like to send you one privately and ask some questions :)

#15
Suggestions / Re: Automatic Activity Planning?
May 14, 2019, 02:31:03 PM
Dear Liviu,

thank you very much for the effort and my own custom version.

I will try to find some time in between to fully understand your example and how to use it. This might take a little as I am "back in school mode" :)

Thanks again,
Christoph