I need to make a class schedule to stick into my new 2005 agenda, which, for some reason, does not already have a page for that. I could draw a bunch of squares on white paper and do it by hand, but I’d rather use the computer.
I need a grid, with days across the top and hours down the side in half-hour intervals. I need to be able to write in the names of my classes, and their location.
Last year I did one using Microsoft Word but it took forever. Actually, I should have saved it, because then I could have just gone back and tweaked it for this year…
Does anyone know of a faster way to do it using another program, or maybe a website that offers a free schedule-builder?
I used Excel, every semester, for this purpose. It is, basically, pre-drawn squares. And it has added bonuses like straight lines (unlike the squares I draw), easy formatting options, resizable squares, and more!
As an added bonus, you can frequently cut and paste the schedule the school’s student info system displays for you directly into an Excel spreadsheet, so that it will require only minimum formatting on your part.
Oooh, I love doing stuff like this! StephenG is right. Excel is perfect for this. It wouldn’t even take long to do if you use auto-fill. It’s really a snap. Need some help?
Ok, I used Excel and got a half-decent schedule. The copy-paste worked, sorta, but the formatting went all wonky. And the rows aren’t all the same height and I can’t fix that. Oh well, it’s good enough for my needs, I guess, but I’ll keep looking for a better way!
Double-clicking the bottom edge of a row or the right edge or a column will make it auto-size itself to fit properly. If it’s not behaving, highlight the problematic cell(s), go to Format, Cells, Alignment, and make sure Wrap Text isn’t checked. Then do it again. Do what Dante said for the heights.
Or email me the spreadsheet, and I’ll send you back a spiffy-looking version, colour-coded or not, depending on your preference.
I think my problem is that it’s trying to keep the formatting from the school’s website. I know how to make the rows the same height but it won’t let me. So I’ll start over tomorrow from scratch. I was trying to save time and look smarter by using the copy-paste, but it ended up being more trouble.
Thanks for the offers of help, but I want to be able to do it. I mean, it’s not brain surgery or anything.
If I can’t get it to work tomorrow, though, I may take one of you up on it!
Antigen, sorry if my post made you feel inadequate or in any way bad. I should no better than to treat something I’ve done for years as a cinch to someone who may never have done it at all. That was rude.
Suffice it to say, I’m sure you’ll be able to get it done. What you want is not too difficult to achieve and it’s probably something you’re just overlooking. You’ll :smack: yourself once you figure it out. We’ve all been there.
When I first started doing things like this, I found that just starting from scratch and formatting it the way I wanted it, usually made it easier to do and I learned a bit about the app in the process.
If you need help, even just to ask, “How do I do this?” we’re here for ya. I’ll try not to be an ass again.
Is it just for one person (you)? Or do you want to handle multiple people’s schedules and be able to view scheduled events for other folks to see who’s free when etc? If the latter, FileMaker.
I started from scratch using Excel and it was much easier to get everything to line up properly. I was just looking for a quicker way using a special, magical program… but hey, this works too.
