Language-română; Download Modelino.xls & Demo.zip; viosystem@yahoo.com; Limba română
An entire school timetabler, fast and reliable, for any school, college, university ... Schedules anything else: staff-exams-rooms or meetings, congresses, conferences, hospitals ...

Cannot build the complete weekly (monthly or module) timetable of the entire school ?
Are you tired and dizzy from the endless rotations of those hundreds or thousands of periods ?

Limba română                             - Enough with your migraines !                               Limba română

Română            - Enough with working late into the night !             Română

- Enough with your weeks of intellectual overload !

    All you need to know is Excel since all is in EXCEL
You don’t need training, practice or experience nor to use or to learn a new program. All is simplest, easiest, fastest, friendliest - without: button after button, window after window, menu after menu or stupid codes for teachers, activities (school subjects), classes (groups of students)... Your data are not locked (confiscated) in a cursed database nor sliced and scattered behind long paths of buttons, windows and menus, and buried who knows where. Instead, your data are entirely visible in only two Excel sheets (and our results too). So you can copy, sort, filter, format... small or large amounts of data. After all, your work and data are your property.

    Three times teacher friendly
We have three minimizing function one for the total number of gap++ hours+ for teachers, another for the total number of single hour working days and the last for the total number of travels between locations (if your school has multiple locations). This is extremely teacher friendly since nobody else either human or computer (or human with computer) do not achieve such highly results not even for one of these three functions.

    We use only Modelino.xls data format
This file is an extremely efficient way to store or manipulate your data sheets and to verify if they correspond to educational plans. So, input your data into Modelino.xls and send us a copy (an example is on top). Then, with our powerful VIOsystem, we will build your complete timetable with the smallest number of gap++ hours+ for teachers and without unwanted gap hours in the students’ program, missing data or overlapping. If your timetable changes from one week (month or module) to the next, we can generate others, as you need.

    + hours or periods : We call them hours, but periods can have any duration you need.
    ++ gap hour : Sometimes one teacher must wait 4 hours between his 3 working hours if for example he is scheduled to work only in the first, the fourth and the seventh hour. Instead of wasting time, this teacher prefers to work in a compact working program of 3 hours without those 4 waiting hours or gap hours. Our VIOsystem will generate a complete timetable (with all teachers and classes) with a more compact working program for each teacher, minimizing the total number of gap hours for teachers. Moreover, each class can have any working program (with reserved gaps or not), except reserved gaps, each class will have zero (unwanted) gap hours.

      NEWS    (August 2007)

    We can manage the access to different types of labs or resources.
E.g. 1) If you can not work in only 2 Chemistry Labs with 3 or more classes (forms) then we can limit to 2 the maximum number of chemistry periods that can be done simultaneously. In this way all chemistry periods can be done in Chemistry Labs. 2) If you can not have 4 or more classes in the Sports Arena then we can limit to 3 the maximum number of Sports periods that can be done simultaneously. In this way all Sports periods can be done in the Sports Arena. We can do the same for any other similar situations.

    Timetabling a school with multiple locations    (August 2007)
We can build the best timetable for a school with 2 or more buildings situated in different locations even if the teachers traveling from one location to another need some traveling time. With the same teacher friendly approach, we will minimize the total number of travels between different locations.
For example, if it is not possible to set a teacher to work only in one location per day (that means zero travels between locations) then we will set the first part of his working program in one location and the second in a second location leading to only one travel per day, and that for all teachers.

    No more single hour working days    (April 2007)
To build a more compact working-program for each teacher (minimizing the number of gap hours for teachers) leads to some single hour working days for some teachers. Removing them or building the timetable without them seems impossible. But now we can do it having two minimizing function one for the total number of gap hours for teachers and another for the total number of single hour working days. In almost all cases, these two functions will obtain the most compact working program that means zero for both total numbers.

    How can they be such liars?    (August 2006)
We have tested other timetable software with real data and the results are far from favorable: All have complicated databases which allow editing or transferring data only one small item at a time, or they do not allow it at all. About 80% of them sell nothing else (only a database without a manual editor for the timetable). The other 20%, which means less than 5, claim they have a good manual editor and also a powerful automatic generator. Some of those manual editors are acceptable, but those generators fail to come with a complete timetable and manage to build only 90% of the timetable and then stop, losing about 40 of the last periods. Those last periods are the most difficult part because the most conflicts arise for those closest to the end of the timetabling process.
  Their failures are very curious because for each of that real data, our VIO system generates millions (if possible - even billions) of complete timetables (solutions), in order to find the best solution. They may have different approaches, so we have tested them even without teachers' preferences - again they fail. All claim that they can manage with lots of constraints, but they fail even without them.

    Beat that - if you can    (May 2005)
We generate solutions (conflict free and complete timetables up to the last period) even if each teacher has preferences and even more, we minimize the number of the gap periods for teachers. This means that each teacher will have a more compact working-program (each teacher will have to wait less until his/her next working period). If you have only a few teachers with preferences then all teachers can have zero gaps. As an average for difficult situations: half of your teachers will have each only one gap period (non working hour between working hours) inside his/her weekly working program, and the other half none.
  On the one hand, we generate complete timetables while others do not, and on the other hand, you can say that we have the best solutions for your teachers. Even more, it is all simple and convenient because we use the popular Excel tables both for data and results. So, with either small or large amounts of your data you can do whatever you want: copy, sort, filter, format, print, transfer, edit... And you can do the same with the timetables that we will generate for you.

    Outrunning the human brain    (July 2002)
As you know, the human brain is the most powerful computer and (after many years of practice) some humans become very skilled in timetabling. Even where those very skilled humans have failed to build at least one timetable, we build and compare thousands or millions of timetables in order to select the best one !

    Glad and proud to be the first    (August 2001)
The number of permutations (and each another possible timetable) for a timetable with only 1 class with 30 hours (periods) weekly, from which the activities are 2 with 4 hours, 4 with 3 hours and 5 with 2 hours, is N = 30! / 4! 2 / 3! 4 / 2! 5 = 1.110408075747e+25 then for 10 similar classes is N10 = 2.849877000733e+250 and for 40 classes is N 40 = 6.596361768566e+1001 . That means for 1, 10, 20, 30 or 40 classes, a number of possible timetables, with over 25, 250, 500, 750 respectively 1000 digits !!!
  One year has 31536000 seconds then only to count this permutations one PC at 10GHz, need 35210809 years for only 1 class (or 35210809 PCs need one year). Supplement this 35210809 with over 225 digits for 10 classes or over 975 digits for 40 classes to find out the number of years needed only to count all those possible timetables. But, in spite of this tremendous number of timetables, among them only few are solutions and therefore almost all are faulty, because, for example, one teacher can not teach in 2 classrooms in the same time, nor 4 hours of physics to one class in one day... Beside the number of timetables, the number of solutions is absurdly small, so small that you can not put it in words. And if it is for the 40 classes timetable, let's say with 600 digits smaller than the number of timetables, then from 1000 digits will remain 400 digits (10 1000 / 10 600 = 10 400) for the number of solutions. Then how to compare such lots of timetables from that enormous number of solutions in order to find the best one?
  Consequently, there are two insurmountable challenges. On the one hand, to find at least one solution - each solution is hidden between a tremendous number of faulty timetables (10 600 = a number with 600 digits). On the other hand, to find from an enormous number of solutions (10 400 = a number with 400 digits), one with the smallest total number of gap hours for teachers.
  Therefore, we are glad and proud to be the first who come with a solution for such a tremendous and enormous problem.


    Project Manager (resume)

Name: Viorel Corneliu NICA         Date & place of birth: April 30, 1962, Bucuresti        Address: Camil Ressu 9, bl. 58, sc. 1, ap. 32, Bucuresti 3, Romania 743351
E-mail: viosystem@yahoo.com    Phone: 004 0311 026 336 or 004 021 3250 199 . Mobile phone: 004 0741 932 487 or 004 0728 425 514

Objective:     Individually or in a project-team to use technology to build successful solutions for clients

Professional Profile:

- Competent technical guru with years of hands-on experience, researching, inventing, improving or developing projects, sometimes on my own and several my own projects
- Details oriented and quality mind professional, dedicated and self-motivated achiever who is committed to success, able to handle multiple tasks in a high-pressured environment
- Enthusiastic about learning and applying new technologies, skills, concepts and ideas, quickly assimilating them, enhancing current technical expertise, and applying transferable skill sets
- Highly analytical team player with aptitude for quickly scrutinizing environments to identify & prioritize needs/risks and develop solutions
- Strong problem-solver who can design solutions and assist developers, along with a demonstrated talent for analyzing and streamlining complex work processes for improvement opportunities
- Organizer of travels & trips (as a guide too) and of graduating, freshmen or other parties either for students or for teachers, friends...
Excellent Technical and Computer Skills:
Software:   - Word, Excel, Access, Power Point, Internet Explorer, Photo Editor, Corel, Adobe...
- Programming in Visual Basic, HTML, Pascal ...
- Solutions and algorithms developer for any problem
Hardware:  - Pentium 1-4, printers, copying devices... any other consumer or industrial electronics and their associated mechanic or electric part (motors, gears...)

Foreign Languages:     English and French - very good

IMPORTANT ACHIEVEMENTS:

    Recently finished a remarkable project (considered impossible to solve):
Automatic Builder of the Entire School Timetable (www.viosystem.com)
I created VIOsystem, developed and improved its computer program and algorithms so that they might generate the optimal timetable in reasonable time (several tens of minutes). I also achieved the commercial shape (interfaces) of the program and the manual in both Romanian and English and even the WEB site.

    Since the gymnasium years, I was preoccupied with physics and electronics, researching, inventing and obtaining remarkable results despite the lack of official support, so I did everything on my own without anybody's help or support. Thus, although a high-school boy, I designed and achieved: - Walkman and Double Cassette Recorder (4 years before they appeared on the market)
- Hi-fi recording trough telephone lines, in real time (many years before the development of data transmission trough the telephone lines and/or Internet)
moreover, the next two that have never been seen on the market: - Double Tape Recorder with large tapes (not compact cassettes)
- Compact Cassettes Recorder with 8 tracks (2x 2tracks = C60, becomes 4x 2tracks = C120 tape)
Then, during the university years (Faculty of Mathematics), I finished more or less some other projects: - Analog Recording System that raises 3 times (9db) the maximum recording-level on magnetic support, together with the high frequency pre-polarization (bias) raised up from 80 kHz to 400 kHz
- Digital Recording System that raises with other 9db the maximum recording-level on magnetic support. Even after so many years, these systems can improve the Hard Disk Drives tripling their transfer rate and storage capacity.
- Automatic illuminating system with sensors of natural light and/or infrared (for human presence)
- Dynamic Lights automatic system for disco-bars; and many others.

    In 1991, a friend of mine had a commercial business (Laponia SRL) which failed after 1 year in spite of its large finance and favorable conjuncture. Therefore, he asked me to help him. Starting from zero, I had to choose wares, sources of wares and even the shelves for wares, and to arrange them and the rooms' interior to be functional and nice. Despite this and in only 3 months (the school holiday of summer '92), I raised his affair from zero (or losses) to 1 million $(USA) yearly-revenue.

    In other 3 months - the school holiday of summer '94, I helped another friend to open a Disco. Starting again from nothing, I decorated the interior, designed the lights & sound system, purchased, configured and serviced the electronic equipment, created the musical collection and leading the Disco for 1 month.

    All has started in high school with my wish of having a musical collection and of listening it at hi-fi quality. However, at the time, there was not even a double cassette recorder or a cheap and performing recording device - so I had to make them up (for the first time). Therefore, I needed electronics, which needed physics, which needed mathematics. Then, during the Faculty of Mathematics, I discovered its most spectacular application - the computer science. I thus can account for the above-mentioned results and for how they grew that in the end I have both solid knowledge and practical results in mathematics, electronics, mechanics, physics and computer science (hardware and software).
    I involved passion in everything I did and tried my best to use my knowledge achieving practical results, and I still do it.
Education: Master of Science - 1986, Faculty of Mathematics, University of Bucharest 1981-1986
Electrician - 1980, Electroaparataj High School (electronics industry) 1976-1980
Professional Experience:
2000-present   Petru Rares College of Bucharest: Mathematics teacher and form teacher (class advisor), leading the college's Computers Club
1993-2000       19 (RATB) College of Bucharest: Mathematics, computer science and form teacher, leading the college's Computers Club
1990-1993       86 General School of Bucharest: Mathematics, computer science and form teacher, leading the school's Computers Club
1986-1990       Other general schools in Bucharest and countryside: Mathematics, computer science and form teacher, leading the school's Computers Club

1980-1981       Electrician at the Prototypes (research) Department of Electroaparataj S. A.

    scheduling, scheduler, timetabling, timetabler, schedule, timetable, software, block, employee, free, program, medical, staff, shift, room, hospital, school, resource, class, patient, conference, download, group, work, clinic, clinical, personnel, people, facility, classroom, time, doctor, labor, master, rooms, classes, enterprise, meeting, college, excel, university, classrooms, exam, exams, course, courses, congress, builder, generator, maker, automated, automatic, week, weekly, entire, examination, examinations, teacher, teachers, resources, k12, highschool, faculty, meetings, all, primary, middle, secondary, junior, high, make, build, generate, shifts, institute, table, tables, modelino, orar, orare, incadrare, încadrare, angajati, angajați, personal, schimb, sala, sală, săli, camera, cameră, camere, spital, scoala, școală, generala, generală, gimnaziu, liceu, colegiu, facultate, universitate, primar, general, gimnazial, liceal, resurse, clasa, clasă, clase, profesor, profesori, elev, elevi, student, studenti, studenți, pacient, pacienti, pacienți, doctori, conferinta, conferință, grup, munca, muncă, clinica, clinică, timp, miting, examen, examene, curs, cursuri, congres, automat, saptamana, săptămână, saptamanal, săptămânal, intreg, întreg, gratis, gratuit, generat, generare, schimburi, institut, scoli, școli, generale, gimnazii, licee, colegii, facultati, facultăți, universitati, universități, incadrari, încadrări, spitale, congrese, academic, academie, oră, ore, optimizare, optimizat, creator, computer, computerizat, downloads, schedules, timetables, schools, colleges, hospitals, universities, congresses, faculties, academy, hour, hours, k-12, higher, optimize, developer, manager, optimizer, organizer, planner, programmer, constructor, whole, preparation, system, application, booking, building, generating, making, constructing, creating, development, developing, optimization, optimizing, management, managing, programs, programming, organize, organized, organization, organizing, computerized, customizable, customized, customize, plan, plans, planning, administration, full, fully, purpose, pedagogic, pedagogical, PC, best, cheap, cheapest, reliable, flexible, institution, institutions, conferences, study, studies, lesson, lessons, presentation, presentations, show, shows, event, events, facilities, window, windows, service, services, business, businesses, groups, expert, experts, pupil, pupils, students, tutor, tutors, teaching, lecture, lectures, lecturer, lecturers, staffs, term, terms, period, periods, placement, placements, education, educational, choice, choices, campus, campuses, generated, construct, constructed, create, created, develop, developed, optimized, manage, design, designed, ÂĂÎȘȚâăîșț