North East Buses
Bus Timetable Creation - Printable Version

+- North East Buses (https://northeastbuses.co.uk/forums)
+-- Forum: The Canteen (https://northeastbuses.co.uk/forums/forumdisplay.php?fid=4)
+--- Forum: Off-topic bus chat (https://northeastbuses.co.uk/forums/forumdisplay.php?fid=50)
+--- Thread: Bus Timetable Creation (/showthread.php?tid=2601)



Bus Timetable Creation - ASX_Terranova - 11 Jul 2020

Hi, 
I am a trying to create a professional looking bus timetable but need some assistance. 
My starting point was this but it looks a bit poor.


RE: Bus Timetable Creation - tyresmoke - 11 Jul 2020

(11 Jul 2020, 5:09 pm)ASX_Terranova Hi, 
I am a trying to create a professional looking bus timetable but need some assistance. 
My starting point was this but it looks a bit poor.
I'm by no means an expert but having done a few in the past, I think there's too much colour and they're too strong as well.
It makes it harder for people to look at the timetable in my opinion. It's usually best to stick to softer colours, especially if printing as part of a leaflet.
I've made a few modifications to your M-F Eastbound and taken the colours away. As I say I'm not an expert and it still looks like it's lacking something. See what you think.


RE: Bus Timetable Creation - ASX_Terranova - 11 Jul 2020

(11 Jul 2020, 5:40 pm)tyresmoke I'm by no means an expert but having done a few in the past, I think there's too much colour and they're too strong as well.
It makes it harder for people to look at the timetable in my opinion. It's usually best to stick to softer colours, especially if printing as part of a leaflet.
I've made a few modifications to your M-F Eastbound and taken the colours away. As I say I'm not an expert and it still looks like it's lacking something. See what you think.
Your changes seem really good, still missing a tinge of blue somewhere though I think to match the brand (CoastLink).
Plus £500,000 and few second hand vehicles would top it all off quite nicely.  Big Grin Big Grin


RE: Bus Timetable Creation - streetdeckfan - 11 Jul 2020

(11 Jul 2020, 5:50 pm)ASX_Terranova Your changes seem really good, still missing a tinge of blue somewhere though I think to match the brand (CoastLink).
Plus £500,000 and few second hand vehicles would top it all off quite nicely.  Big Grin Big Grin

What about something like this?

I kept the colours similar to your original to keep with the 'branding' but made it flatter

.xlsx
84-84A Timetable (1).xlsx
Size 27.26 KB / Downloads 29



RE: Bus Timetable Creation - ASX_Terranova - 11 Jul 2020

(11 Jul 2020, 6:09 pm)streetdeckfan What about something like this?

I kept the colours similar to your original to keep with the 'branding' but made it flatter]
Perfect, looks much better thanks. 
How did you do that if you dont mind me asking
I will probably also use the suggested designs for the 85/86, 87/87A, 88 & 89 Ideas as well.
Inspiration came from combinations of 500, 526, 527, 528, 531, 532, 533, 542, 543, 544, 550, 557.


RE: Bus Timetable Creation - streetdeckfan - 11 Jul 2020

(11 Jul 2020, 6:19 pm)ASX_Terranova Perfect, looks much better thanks. 
How did you do that if you dont mind me asking

I will probably also use the suggested designs for the 85/86, 87/87A, 88 & 89 Ideas as well.

All I really did was add the extra columns with the 'then at these minutes' and 'until', and did a Merge and Centre then Rotate Text Up to face it sideways.
The rest was just changing colours and adding borders. I also set the column width on the times to 7 as I thought it felt a bit cramped having them close together.

As someone who makes spreadsheets for fun, it probably only took me a minute or two.


RE: Bus Timetable Creation - Storx - 12 Jul 2020

Your using the wrong software to make timetables, you need to either use HTML/CSS or a proper design software such as Adobe Indesign etc. They won't be using Excel Smile


RE: Bus Timetable Creation - streetdeckfan - 12 Jul 2020

(12 Jul 2020, 1:02 pm)Storx Your using the wrong software to make timetables, you need to either use HTML/CSS or a proper design software such as Adobe Indesign etc. They won't be using Excel Smile

Nah, I bet they're using Publisher Tongue

Seriously though, you'd be surprised how professional you can make things look using only Microsoft Office!


RE: Bus Timetable Creation - Storx - 12 Jul 2020

(12 Jul 2020, 1:26 pm)streetdeckfan Nah, I bet they're using Publisher Tongue

Seriously though, you'd be surprised how professional you can make things look using only Microsoft Office!

Lot of effort tho haha [Image: tongue.png]

I got bored and done one using PHP only took like 5 minutes to do, had to convert it to HTML though as you can't load PHP without a server.


RE: Bus Timetable Creation - streetdeckfan - 12 Jul 2020

(12 Jul 2020, 3:27 pm)Storx Lot of effort tho haha Tongue

I got bored and done one using PHP only took like 5 minutes to do, had to convert it to HTML though as you can't load PHP without a server.

Not really, plus I like just playing around in Excel!

I'm really tempted to just make a full on X-Lines style timetable using only Microsoft Office now