Marmolejo Saucedo, José AntonioJosé AntonioMarmolejo SaucedoRodríguez Aguilar, RománRománRodríguez Aguilar2022-10-242022-10-24201997830303358479783030335854https://scripta.up.edu.mx/handle/20.500.12552/173410.1007/978-3-030-33585-4_1In this manuscript a group of students from an university of Mexico develop a user-friendly university timetabling tool based on a spreadsheet and using Open-Solve optimization software. The developed tool uses 0–1 integer programming to maximize the number of classes with their respective teacher allocated to a classroom in a certain time schedule. It does not solve only one specific case, the user can introduce each semester’s specific information to the spreadsheet and the tool will automatically generate a schedule that maximizes the number of classes assigned using the given time and classroom resources. Each semester the available times and the teacher can be changed for each class according to the needs for that specific semester. The user does not need to be someone who understands linear programming. The tool is developed on a user-friendly way so that the staff of the school can use it without help from the developers. In this paper we will show how this tool was developed for a smaller example and how it works with a real case. © 2020, Springer Nature Switzerland AG.enAssignment problemsMixed-integer programmingTimetablingCombinatorial optimizationIntelligent computingLinear programmingSchedulingSpreadsheetsMixed integer programmingNumber of classResource Types::text::conference output::conference proceedings::conference paper