{"id":"https://openalex.org/W2997099063","doi":"https://doi.org/10.3906/elk-1909-14","title":"A spreadsheet-based decision support system for examination timetabling","display_name":"A spreadsheet-based decision support system for examination timetabling","publication_year":2019,"publication_date":"2019-11-26","ids":{"openalex":"https://openalex.org/W2997099063","doi":"https://doi.org/10.3906/elk-1909-14","mag":"2997099063"},"language":"en","primary_location":{"id":"doi:10.3906/elk-1909-14","is_oa":false,"landing_page_url":"https://doi.org/10.3906/elk-1909-14","pdf_url":null,"source":{"id":"https://openalex.org/S32837994","display_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","issn_l":"1300-0632","issn":["1300-0632","1303-6203"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318422","host_organization_name":"Scientific and Technological Research Council of Turkey (TUBITAK)","host_organization_lineage":["https://openalex.org/P4310318422"],"host_organization_lineage_names":["Scientific and Technological Research Council of Turkey (TUBITAK)"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5023885015","display_name":"Mehmet G\u00fcray G\u00fcler","orcid":"https://orcid.org/0000-0002-9987-7616"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Mehmet G\u00fcray G\u00dcLER","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5091295092","display_name":"Ebru Ge\u00e7ic\u0131","orcid":"https://orcid.org/0000-0002-7954-9578"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Ebru GE\u00c7\u0130C\u0130","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5023885015"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.1883,"has_fulltext":false,"cited_by_count":15,"citation_normalized_percentile":{"value":0.81983627,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":"28","issue":"3","first_page":"1584","last_page":"1598"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12401","display_name":"Scheduling and Timetabling Solutions","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T12401","display_name":"Scheduling and Timetabling Solutions","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11902","display_name":"Intelligent Tutoring Systems and Adaptive Learning","score":0.9638000130653381,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7075270414352417},{"id":"https://openalex.org/keywords/scheduling","display_name":"Scheduling (production processes)","score":0.6363219618797302},{"id":"https://openalex.org/keywords/decision-support-system","display_name":"Decision support system","score":0.5625766515731812},{"id":"https://openalex.org/keywords/integer-programming","display_name":"Integer programming","score":0.5144403576850891},{"id":"https://openalex.org/keywords/operations-research","display_name":"Operations research","score":0.48784589767456055},{"id":"https://openalex.org/keywords/quality","display_name":"Quality (philosophy)","score":0.4728408455848694},{"id":"https://openalex.org/keywords/institution","display_name":"Institution","score":0.4566454291343689},{"id":"https://openalex.org/keywords/job-shop-scheduling","display_name":"Job shop scheduling","score":0.4249178469181061},{"id":"https://openalex.org/keywords/industrial-engineering","display_name":"Industrial engineering","score":0.32912278175354004},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.3205335736274719},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.2778775691986084},{"id":"https://openalex.org/keywords/operations-management","display_name":"Operations management","score":0.2486865222454071},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.12887665629386902},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.10262632369995117},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.08603394031524658}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7075270414352417},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.6363219618797302},{"id":"https://openalex.org/C107327155","wikidata":"https://www.wikidata.org/wiki/Q330268","display_name":"Decision support system","level":2,"score":0.5625766515731812},{"id":"https://openalex.org/C56086750","wikidata":"https://www.wikidata.org/wiki/Q6042592","display_name":"Integer programming","level":2,"score":0.5144403576850891},{"id":"https://openalex.org/C42475967","wikidata":"https://www.wikidata.org/wiki/Q194292","display_name":"Operations research","level":1,"score":0.48784589767456055},{"id":"https://openalex.org/C2779530757","wikidata":"https://www.wikidata.org/wiki/Q1207505","display_name":"Quality (philosophy)","level":2,"score":0.4728408455848694},{"id":"https://openalex.org/C2780510313","wikidata":"https://www.wikidata.org/wiki/Q178706","display_name":"Institution","level":2,"score":0.4566454291343689},{"id":"https://openalex.org/C55416958","wikidata":"https://www.wikidata.org/wiki/Q6206757","display_name":"Job shop scheduling","level":3,"score":0.4249178469181061},{"id":"https://openalex.org/C13736549","wikidata":"https://www.wikidata.org/wiki/Q4489420","display_name":"Industrial engineering","level":1,"score":0.32912278175354004},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3205335736274719},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2778775691986084},{"id":"https://openalex.org/C21547014","wikidata":"https://www.wikidata.org/wiki/Q1423657","display_name":"Operations management","level":1,"score":0.2486865222454071},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.12887665629386902},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10262632369995117},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.08603394031524658},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C68387754","wikidata":"https://www.wikidata.org/wiki/Q7271585","display_name":"Schedule","level":2,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3906/elk-1909-14","is_oa":false,"landing_page_url":"https://doi.org/10.3906/elk-1909-14","pdf_url":null,"source":{"id":"https://openalex.org/S32837994","display_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","issn_l":"1300-0632","issn":["1300-0632","1303-6203"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310318422","host_organization_name":"Scientific and Technological Research Council of Turkey (TUBITAK)","host_organization_lineage":["https://openalex.org/P4310318422"],"host_organization_lineage_names":["Scientific and Technological Research Council of Turkey (TUBITAK)"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"TURKISH JOURNAL OF ELECTRICAL ENGINEERING & COMPUTER SCIENCES","raw_type":"journal-article"},{"id":"pmh:oai:dergipark.org.tr:article/739716","is_oa":false,"landing_page_url":"https://dergipark.org.tr/tr/pub/tbtkelektrik/issue/54388/739716","pdf_url":null,"source":{"id":"https://openalex.org/S4306401840","display_name":"DergiPark (Istanbul University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I67581229","host_organization_name":"Istanbul University","host_organization_lineage":["https://openalex.org/I67581229"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"\\n                                                                    Volume: 28, Issue: 3\\n                                                                                                    1584-1598\\n                                                                \\n                            ","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W3172150420","https://openalex.org/W2107725657","https://openalex.org/W2112121444","https://openalex.org/W2509452605","https://openalex.org/W2148608945","https://openalex.org/W3112689649","https://openalex.org/W2998357381","https://openalex.org/W2808535280","https://openalex.org/W2101020326","https://openalex.org/W3122821775"],"abstract_inverted_index":{"Examination":[0],"timetabling":[1,61],"is":[2,20,146,157,210,226],"an":[3,204],"inevitable":[4],"problem":[5,34,62],"of":[6,46,72,77,134,139,148,153,165,172,187,214,219,245],"educational":[7,221],"institutions.":[8,222],"Each":[9],"institution":[10],"has":[11],"its":[12],"own":[13],"particular":[14],"limitations;":[15],"however,":[16],"the":[17,21,33,56,59,98,132,135,163,169,173,188,224,230],"main":[18],"structure":[19],"same:":[22],"assigning":[23],"exams":[24,183],"to":[25],"time":[26],"slots":[27],"and":[28,48,64,105,181,190,199,232],"classrooms.":[29],"Several":[30],"institutions":[31],"solve":[32],"manually,":[35],"but":[36],"it":[37,175,209],"becomes":[38],"more":[39],"difficult":[40],"every":[41],"year":[42],"with":[43,178],"increasing":[44],"numbers":[45],"students":[47],"limited":[49],"resources.":[50],"There":[51],"are":[52,86,101],"many":[53],"studies":[54],"in":[55,82,162,212,227],"literature":[57],"addressing":[58,185],"examination":[60],"(ETP)":[63],"providing":[65],"high":[66],"quality":[67],"solutions":[68],"within":[69,238],"reasonable":[70],"amounts":[71],"time.":[73],"Nevertheless,":[74],"almost":[75],"none":[76],"them":[78],"can":[79,200,235],"be":[80,201,236],"used":[81,202],"practice":[83],"since":[84],"they":[85,112],"not":[87,107,194],"converted":[88],"into":[89,159],"a":[90,124,150,160,166,239],"decision":[91],"support":[92],"system":[93],"(DSS).":[94],"Commercial":[95],"DSSs,":[96],"on":[97],"other":[99,220],"hand,":[100],"generally":[102],"transactionally":[103],"based":[104],"do":[106],"have":[108],"optimization":[109],"capabilities,":[110],"i.e.":[111],"prevent":[113],"conflicts":[114,180],"via":[115],"functional":[116],"user":[117],"interfaces.":[118],"In":[119],"this":[120],"study,":[121],"we":[122],"propose":[123],"mixed":[125],"integer":[126],"programming":[127],"(MIP)":[128],"model":[129],"that":[130],"addresses":[131],"ETP":[133,155],"Industrial":[136],"Engineering":[137],"Department":[138],"Y\u0131ld\u0131z":[140],"Technical":[141],"University.":[142],"The":[143],"model,":[144],"which":[145],"capable":[147],"solving":[149],"wide":[151],"range":[152],"similar":[154],"instances,":[156],"embedded":[158],"DSS":[161,225],"form":[164],"spreadsheet.":[167],"Given":[168],"enrollment":[170],"lists":[171],"courses,":[174],"generates":[176],"schedules":[177],"minimum":[179],"consecutive":[182],"while":[184],"requests":[186],"lecturers":[189],"students.":[191],"It":[192],"does":[193],"require":[195],"any":[196],"technical":[197],"knowledge":[198],"by":[203,229],"average":[205],"spreadsheet":[206],"user.":[207],"Moreover,":[208],"flexible":[211],"terms":[213],"use":[215,228],"for":[216],"scheduling":[217],"problems":[218],"Currently,":[223],"department":[231],"real-life":[233],"instances":[234],"solved":[237],"few":[240],"seconds,":[241],"saving":[242],"significant":[243],"amount":[244],"man-hours.":[246]},"counts_by_year":[{"year":2025,"cited_by_count":5},{"year":2024,"cited_by_count":3},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}