+ Reply to Thread
Results 1 to 3 of 3

School College University Timetable Planner Help Please ??

  1. #1
    Registered User
    Join Date
    02-27-2020
    Location
    Edinburgh
    MS-Off Ver
    2020
    Posts
    1

    School College University Timetable Planner Help Please ??

    Hi there,

    I work for a large educational establishment and need to pre plan my timetables outside or SIM Student Information Management system, I currently do this using excel, and it works great, but my process is very labour intensive.

    See screen shot, I work in rows, at the top I have circa 20x staff, in the middle I have 20x programmes/courses/classes, and at the bottom I have 15x rooms / workshops. We also work in 2 semester per year, so every staff/class/room have 2 rows, one for each semester/block.

    I start by giving each class a different colour, and entering in a subject in a class box, then copying it to a designated lecturer and then same to a designated room.

    Instead what I’d like it to do is I enter key words in start of every class box that flag and copy to a specific lecturer and room, ie if I was to enter say RT WS04 – Welding Unit 4 in a box, and it would then take the colour of the box and copy it into the corresponding row for the RT Robert Thompsons lecturers row and then the same for WS04 Workshop 04 room row.

    I don’t have much experience with macro’s but presume this may be needed for above? Any ideas / help?

    Also any pre-made school / college / university timetabling systems I could get a free download of to trial / test?

    Any help would be gratefully appreciated?

    Thanks Jim
    Attached Images Attached Images

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,885

    Re: School College University Timetable Planner Help Please ??

    crossposted: https://www.mrexcel.com/board/thread...lease.1125789/

    Rule 03: Cross-posting Without Telling Us

    Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Read this to understand why we ask you to do this.

    I have added the crosspost reference for you today. Please comply with this and all our rules in the future
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: School College University Timetable Planner Help Please ??

    Hi,

    Pictures are rarely much use. This is a case in point
    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

    That said the very fact that you are using merged cells is I believe going to very complicated to accommodate.
    For something like this Excel works best when there is reasonable consistency in formatting.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. University Project for Transportation school bus
    By Total32 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-20-2017, 01:29 PM
  2. University Project for Transportation school bus
    By Total32 in forum Excel General
    Replies: 6
    Last Post: 10-20-2017, 12:53 PM
  3. Fill planner table relying on data from another table winery planner
    By pleb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2013, 04:54 AM
  4. school timetable
    By kipronopaul in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-20-2013, 01:05 AM
  5. distribute Periods in a school timetable
    By TOTO_POP in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 10-01-2010, 05:06 PM
  6. Sum calculations for university
    By Amnesiac in forum Excel General
    Replies: 6
    Last Post: 09-24-2010, 05:38 PM
  7. school or college timetables?
    By einsteinjrp in forum Excel General
    Replies: 1
    Last Post: 05-25-2005, 07:19 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1