southbound
	Los Banos HS	Caltrain local	Caltrain express	Los Banos HS	Caltrain local	Caltrain express	Los Banos HS	Caltrain local	Caltrain express	Los Banos HS	Caltrain local	Caltrain express

SF Transbay	`07:03`	`07:07`	`07:09`	`07:18`	`07:22`	`07:24`	`07:33`	`07:37`	`07:39`	`07:48`	`07:52`	`07:54`
Mission Bay	-	`07:10`	`07:12`	-	`07:25`	`07:27`	-	`07:40`	`07:42`	-	`07:55`	`07:57`
22nd Street	-	`07:14`	`07:16`	-	`07:29`	`07:31`	-	`07:44`	`07:46`	-	`07:59`	`08:01`
Oakdale	-	-	-	-	-	-	-	-	-	-	-	-
Bayshore	-	`07:19`	-	-	`07:34`	-	-	`07:49`	-	-	`08:04`	-
So. San Francisco	-	`07:24`	-	-	`07:39`	-	-	`07:54`	-	-	`08:09`	-
San Bruno	-	`07:27`	-	-	`07:42`	-	-	`07:57`	-	-	`08:12`	-
Millbrae	`07:18` `07:19`	`07:31`	`07:28`	`07:33` `07:34`	`07:46`	`07:43`	`07:48` `07:49`	`08:01`	`07:58`	`08:03` `08:04`	`08:16`	`08:13`
Broadway	-	`07:34`	-	-	`07:49`	-	-	`08:04`	-	-	`08:19`	-
Burlingame	-	`07:36`	-	-	`07:51`	-	-	`08:06`	-	-	`08:21`	-
San Mateo	-	`07:39`	-	-	`07:54`	-	-	`08:09`	-	-	`08:24`	-
Hayward Park	-	-	-	-	-	-	-	-	-	-	-	-
Hillsdale	-	`07:43` `07:44`	`07:36`	-	`07:58` `07:59`	`07:51`	-	`08:13` `08:14`	`08:06`	-	`08:28` `08:29`	`08:21`
Belmont	-	`07:47`	-	-	`08:02`	-	-	`08:17`	-	-	`08:32`	-
San Carlos	-	`07:50`	-	-	`08:05`	-	-	`08:20`	-	-	`08:35`	-
Redwood City	`07:30`	`07:54`	`07:42`	`07:45`	`08:09`	`07:57`	`08:00`	`08:24`	`08:12`	`08:15`	`08:39`	`08:27`
Atherton	-	-	-	-	-	-	-	-	-	-	-	-
Menlo Park	-	`07:58`	-	-	`08:13`	-	-	`08:28`	-	-	`08:43`	-
Palo Alto	-	`08:01`	`07:47`	-	`08:16`	`08:02`	-	`08:31`	`08:17`	-	`08:46`	`08:32`
California Ave	-	`08:04`	-	-	`08:19`	-	-	`08:34`	-	-	`08:49`	-
San Antonio	-	`08:08`	-	-	`08:23`	-	-	`08:38`	-	-	`08:53`	-
Mountain View	-	`08:11`	`07:54`	-	`08:26`	`08:09`	-	`08:41`	`08:24`	-	`08:56`	`08:39`
Sunnyvale	-	`08:15`	-	-	`08:30`	-	-	`08:45`	-	-	`09:00`	-
Lawrence	-	`08:18`	-	-	`08:33`	-	-	`08:48`	-	-	`09:03`	-
Santa Clara	-	`08:23`	`08:03`	-	`08:38`	`08:18`	-	`08:53`	`08:33`	-	`09:08`	`08:48`
College Park	-	-	-	-	-	-	-	-	-	-	-	-
San Jose	`07:49` `07:50`	`08:28`	`08:08`	`08:05`	`08:43`	`08:23`	`08:19` `08:20`	`08:58`	`08:38`	`08:34` `08:35`	`09:13`	`08:53`
Tamien	-	`08:34`		-	`08:49`		-	`09:04`		-	`09:19`

northbound
	Caltrain local	Caltrain express	Los Banos HS	Caltrain local	Caltrain express	Los Banos HS	Caltrain local	Caltrain express	Los Banos HS	Caltrain local	Caltrain express	Los Banos HS

Tamien	`07:04`		-	`07:19`		-	`07:34`		-	`07:49`		-
San Jose	`07:09`	`07:15`	`07:17` `07:18`	`07:24`	`07:30`	`07:32` `07:33`	`07:39`	`07:45`	`07:47` `07:48`	`07:54`	`08:00`	`08:02` `08:03`
College Park	-	-	-	-	-	-	-	-	-	-	-	-
Santa Clara	`07:14`	`07:20`	-	`07:29`	`07:35`	-	`07:44`	`07:50`	-	`07:59`	`08:05`	-
Lawrence	`07:19`	-	-	`07:34`	-	-	`07:49`	-	-	`08:04`	-	-
Sunnyvale	`07:22`	-	-	`07:37`	-	-	`07:52`	-	-	`08:07`	-	-
Mountain View	`07:26`	`07:29`	-	`07:41`	`07:44`	-	`07:56`	`07:59`	-	`08:11`	`08:14`	-
San Antonio	`07:29`	-	-	`07:44`	-	-	`07:59`	-	-	`08:14`	-	-
California Ave	`07:33`	-	-	`07:48`	-	-	`08:03`	-	-	`08:18`	-	-
Palo Alto	`07:36`	`07:35`	-	`07:51`	`07:50`	-	`08:06`	`08:05`	-	`08:21`	`08:20`	-
Menlo Park	`07:39`	-	-	`07:54`	-	-	`08:09`	-	-	`08:24`	-	-
Atherton	-	-	-	-	-	-	-	-	-	-	-	-
Redwood City	`07:43`	`07:41`	`07:38`	`07:58`	`07:56`	`07:53`	`08:13`	`08:11`	`08:08`	`08:28`	`08:26`	`08:23`
San Carlos	`07:47`	-	-	`08:02`	-	-	`08:17`	-	-	`08:32`	-	-
Belmont	`07:49`	-	-	`08:04`	-	-	`08:19`	-	-	`08:34`	-	-
Hillsdale	`07:53` `07:54`	`07:47`	-	`08:08` `08:09`	`08:02`	-	`08:23` `08:24`	`08:17`	-	`08:38` `08:39`	`08:32`	-
Hayward Park	-	-	-	-	-	-	-	-	-	-	-	-
San Mateo	`07:58`	-	-	`08:13`	-	-	`08:28`	-	-	`08:43`	-	-
Burlingame	`08:01`	-	-	`08:16`	-	-	`08:31`	-	-	`08:46`	-	-
Broadway	`08:03`	-	-	`08:18`	-	-	`08:33`	-	-	`08:48`	-	-
Millbrae	`08:06`	`07:55`	`07:48` `07:49`	`08:21`	`08:10`	`08:03` `08:04`	`08:36`	`08:25`	`08:18` `08:19`	`08:51`	`08:40`	`08:33` `08:34`
San Bruno	`08:10`	-	-	`08:25`	-	-	`08:40`	-	-	`08:55`	-	-
So. San Francisco	`08:13`	-	-	`08:28`	-	-	`08:43`	-	-	`08:58`	-	-
Bayshore	`08:18`	-	-	`08:33`	-	-	`08:48`	-	-	`09:03`	-	-
Oakdale	-	-	-	-	-	-	-	-	-	-	-	-
22nd Street	`08:23`	`08:06`	-	`08:38`	`08:21`	-	`08:53`	`08:36`	-	`09:08`	`08:51`	-
Mission Bay	`08:27`	`08:10`	-	`08:42`	`08:25`	-	`08:57`	`08:40`	-	`09:12`	`08:55`	-
SF Transbay	`08:31`	`08:14`	`08:05`	`08:46`	`08:29`	`08:20`	`09:01`	`08:44`	`08:35`	`09:16`	`08:59`	`08:50`

Train data entry form

Graphical Table width: pixels; height: pixels; period shown: minutes; start hour: ; show direction ; title:

Train1 Type: stops: operates: Headway:
Label: SB minutes (0-59): NB minutes (0-59): colour (rrggbb): pad% (0-50): fleet:

Train2 Type: stops: operates: Headway:
Label: SB minutes (0-59): NB minutes (0-59): colour (rrggbb): pad% (0-50): fleet:

Train3 Type: stops: operates: Headway:
Label: SB minutes (0-59): NB minutes (0-59): colour (rrggbb): pad% (0-50): fleet:

Train4 Type: stops: operates: Headway:
Label: SB minutes (0-59): NB minutes (0-59): colour (rrggbb): pad% (0-50): fleet:

Train5 Type: stops: operates: Headway:
Label: SB minutes (0-59): NB minutes (0-59): colour (rrggbb): pad% (0-50): fleet:

(Stop time selector: active when editing a train's stops)
SF Transbay	Mission Bay	22nd Street	Oakdale	Bayshore	So. San Francisco	San Bruno
Millbrae	Broadway	Burlingame	San Mateo	Hayward Park	Hillsdale	Belmont
San Carlos	Redwood City	Atherton	Menlo Park	Palo Alto	California Ave	San Antonio
Mountain View	Sunnyvale	Lawrence	Santa Clara	College Park	San Jose	Tamien

What to display:
Summary (graphical table; text timetable; origin-destination summary scores)
Detailed (graphical; timetable; origin-destination detail scores; origin-destination hourly connections)
Graphical timetable only
Text timetable only
Origin-destination hourly trips+transfers only
Origin-destination timetable quality metrics summary
Origin-destination timetable quality metrics detail

Some help for this data entry form with some example timetables.

See "Formulation of a Service Quality Metric" for an explanation of most of the data in this table.

More explanatory text (about cell background shades, etc) to come...
(Roughly, greener = higher "Effective trip speed"; redder = less competive speed; so-so left unshaded; shortest trips also unshaded.
Shading represents wait-adjusted speed alone, not the speed- and population-weigthed score.)

Total Timetable Service Quality Score = 230
	SF Transbay	Mission Bay	22nd Street	Oakdale	Bayshore	So. San Francisco	San Bruno	Millbrae	Broadway	Burlingame	San Mateo	Hayward Park	Hillsdale	Belmont	San Carlos	Redwood City	Atherton	Menlo Park	Palo Alto	California Ave	San Antonio	Mountain View	Sunnyvale	Lawrence	Santa Clara	College Park	San Jose	Tamien	Total
SF Transbay	-	7 -	11 -	-	17 0.08	22 0.39	27 0.23	24 0.57	30 0.39	33 0.33	35 0.44	-	31 0.48	44 0.35	47 0.40	38 1.17	-	50 0.64	43 1.25	60 0.61	64 0.36	50 0.56	56 0.66	60 0.64	59 0.53	-	64 0.34	75 0.11	10.5
Mission Bay	9 -	-	7 -	-	13 0.07	18 0.37	24 0.23	20 0.59	26 0.40	29 0.34	31 0.45	-	28 0.51	40 0.37	43 0.42	34 1.27	-	46 0.69	40 1.39	57 0.66	60 0.40	46 0.63	52 0.75	56 0.74	55 0.62	-	60 0.40	71 0.12	11.4
22nd Street	12 -	9 -	-	-	9 -	14 0.22	20 0.14	17 0.40	22 0.27	25 0.23	28 0.32	-	24 0.38	36 0.26	39 0.30	30 0.97	-	42 0.53	36 1.08	53 0.51	56 0.31	42 0.51	49 0.61	52 0.60	51 0.52	-	57 0.33	67 0.10	8.6
Oakdale	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Bayshore	17 1.78	13 0.43	9 -	-	-	10 -	14 0.08	17 0.18	20 0.15	23 0.13	25 0.19	-	29 0.19	34 0.18	37 0.21	40 0.50	-	45 0.37	47 0.62	50 0.41	54 0.26	55 0.32	61 0.41	65 0.42	64 0.38	-	69 0.26	80 0.09	7.6
So. San Francisco	22 2.47	18 0.69	14 0.17	-	10 -	-	8 -	12 0.05	15 0.05	17 0.05	20 0.08	-	24 0.09	29 0.09	31 0.11	35 0.28	-	39 0.23	42 0.39	45 0.27	49 0.18	53 0.22	56 0.31	59 0.32	59 0.31	-	64 0.22	75 0.07	6.6
San Bruno	27 3.45	24 0.97	20 0.26	-	14 0.05	8 -	-	8 -	11 -	14 0.03	16 0.06	-	20 0.08	25 0.08	28 0.11	31 0.29	-	36 0.25	38 0.43	41 0.31	45 0.21	48 0.26	52 0.38	56 0.41	55 0.41	-	60 0.29	71 0.10	8.4
Millbrae	24 3.41	20 1.02	17 0.30	-	17 0.05	12 0.04	8 -	-	8 -	10 -	13 -	-	12 0.06	22 0.04	24 0.06	20 0.24	-	29 0.18	26 0.37	38 0.20	42 0.14	31 0.27	37 0.35	40 0.38	39 0.40	-	45 0.28	55 0.09	7.9
Broadway	32 3.52	28 1.03	24 0.29	-	20 0.06	15 0.07	11 -	8 -	-	7 -	10 -	-	14 0.04	18 0.04	21 0.06	25 0.18	-	29 0.18	32 0.32	35 0.23	39 0.17	40 0.23	46 0.33	49 0.36	48 0.39	-	54 0.29	64 0.10	7.9
Burlingame	35 4.29	31 1.26	27 0.36	-	23 0.08	17 0.10	14 0.03	10 -	7 -	-	8 -	-	11 -	16 0.04	19 0.06	22 0.19	-	27 0.20	30 0.36	33 0.27	36 0.20	38 0.26	43 0.39	47 0.44	46 0.48	-	51 0.36	62 0.12	9.5
San Mateo	36 6.61	32 1.98	28 0.57	-	25 0.14	20 0.19	16 0.06	13 -	10 -	8 -	-	-	9 -	13 -	16 0.05	19 0.21	-	24 0.24	27 0.43	30 0.33	33 0.25	38 0.33	41 0.53	44 0.60	43 0.68	-	49 0.52	59 0.17	13.9
Hayward Park	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Hillsdale	31 6.45	28 2.01	24 0.62	-	29 0.12	24 0.19	20 0.07	11 0.13	14 0.05	11 -	9 -	-	-	8 -	11 -	9 0.14	-	18 0.15	16 0.36	24 0.21	28 0.17	23 0.32	29 0.46	33 0.53	32 0.63	-	37 0.48	48 0.15	13.2
Belmont	46 4.07	42 1.23	38 0.37	-	34 0.10	29 0.17	25 0.07	22 0.09	18 0.05	16 0.04	13 -	-	8 -	-	8 -	11 -	-	16 0.10	18 0.20	21 0.16	25 0.14	30 0.18	32 0.32	36 0.38	35 0.48	-	40 0.37	51 0.12	8.6
San Carlos	50 3.58	46 1.09	42 0.33	-	37 0.09	31 0.17	28 0.07	24 0.09	21 0.06	19 0.04	16 0.03	-	11 -	8 -	-	8 -	-	13 0.08	16 0.15	19 0.13	22 0.12	26 0.17	29 0.28	33 0.35	32 0.45	-	37 0.35	48 0.12	7.8
Redwood City	38 7.00	34 2.22	30 0.71	-	40 0.14	35 0.27	31 0.12	20 0.24	25 0.12	22 0.08	19 0.08	-	10 0.06	11 -	8 -	-	-	10 -	9 0.16	15 0.12	19 0.12	17 0.24	23 0.38	27 0.47	26 0.66	-	31 0.53	42 0.17	13.9
Atherton	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Menlo Park	50 3.93	46 1.25	43 0.39	-	45 0.11	39 0.22	36 0.11	29 0.18	29 0.12	27 0.09	24 0.10	-	18 0.07	16 0.05	13 0.05	9 -	-	-	7 -	11 -	14 0.04	17 0.08	21 0.16	25 0.23	24 0.37	-	29 0.32	40 0.11	8.0
Palo Alto	43 4.63	40 1.50	36 0.49	-	47 0.10	42 0.23	38 0.11	24 0.25	32 0.12	30 0.10	27 0.10	-	16 0.09	18 0.06	16 0.06	10 0.08	-	7 -	-	8 -	11 -	11 0.09	18 0.17	21 0.24	20 0.42	-	26 0.35	36 0.11	9.3
California Ave	60 3.96	56 1.26	52 0.40	-	50 0.12	45 0.27	41 0.13	38 0.22	35 0.16	33 0.12	30 0.14	-	24 0.10	21 0.09	19 0.09	15 0.13	-	11 -	8 -	-	8 -	12 -	16 0.14	19 0.22	24 0.34	-	29 0.31	34 0.12	8.3
San Antonio	56 5.10	52 1.65	48 0.54	-	54 0.15	49 0.34	45 0.17	36 0.34	39 0.22	36 0.17	33 0.20	-	26 0.17	25 0.14	22 0.15	18 0.26	-	14 0.08	11 -	8 -	-	8 -	12 0.10	15 0.19	20 0.34	-	25 0.33	31 0.13	10.8
Mountain View	50 5.20	46 1.72	42 0.58	-	55 0.14	49 0.34	46 0.18	31 0.41	39 0.23	37 0.19	34 0.22	-	23 0.22	26 0.16	23 0.18	17 0.37	-	15 0.13	11 0.23	12 -	8 -	-	9 -	12 0.12	13 0.35	-	18 0.33	27 0.11	11.4
Sunnyvale	57 4.49	53 1.49	49 0.50	-	61 0.13	56 0.33	52 0.18	37 0.40	46 0.23	43 0.19	41 0.23	-	30 0.23	32 0.18	29 0.20	26 0.39	-	21 0.18	19 0.30	16 0.15	12 0.06	9 -	-	8 -	13 0.19	-	18 0.22	23 0.10	10.4
Lawrence	60 3.65	56 1.22	52 0.41	-	65 0.11	59 0.29	56 0.16	41 0.36	49 0.22	47 0.18	44 0.22	-	33 0.22	36 0.18	33 0.21	29 0.41	-	25 0.21	22 0.35	19 0.20	15 0.09	12 0.07	8 -	-	9 -	-	15 0.14	20 0.06	9.0
Santa Clara	59 2.62	55 0.89	51 0.31	-	63 0.09	58 0.24	54 0.14	39 0.33	48 0.20	46 0.17	43 0.22	-	32 0.23	34 0.20	32 0.23	26 0.55	-	23 0.30	20 0.56	24 0.26	20 0.14	12 0.19	13 0.13	9 -	-	-	8 -	15 -	8.0
College Park	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
San Jose	64 2.74	60 0.94	57 0.33	-	69 0.10	64 0.28	60 0.16	45 0.38	53 0.25	51 0.21	48 0.28	-	37 0.29	40 0.25	37 0.30	31 0.71	-	29 0.42	26 0.77	29 0.39	25 0.22	18 0.30	18 0.26	15 0.20	8 -	-	-	10 -	9.8
Tamien	75 2.55	71 0.87	68 0.31	-	80 0.09	75 0.28	71 0.16	56 0.36	64 0.24	62 0.21	59 0.27	-	48 0.28	51 0.25	48 0.30	44 0.65	-	40 0.41	37 0.73	34 0.47	31 0.27	27 0.30	23 0.34	20 0.28	15 -	-	10 -	-	9.6
Total	85.5	26.7	8.2		2.1	5.0	2.6	5.6	3.5	2.9	3.7		3.8	3.0	3.6	9.0		5.6	10.4	5.9	3.8	5.5	7.5	8.1	8.9		7.0	2.4	230.4

	Caltrain local operated every 15 minutes using KISS-79MPH-4MW equipment fleet "L".
	Stopping SF Transbay, Mission Bay, 22nd Street, Bayshore, So. San Francisco, San Bruno, Millbrae, Broadway, Burlingame, San Mateo, Hillsdale, Belmont, San Carlos, Redwood City, Menlo Park, Palo Alto, California Ave, San Antonio, Mountain View, Sunnyvale, Lawrence, Santa Clara, San Jose, Tamien
	Caltrain express operated every 15 minutes using KISS-79MPH-4MW equipment fleet "X".
	Stopping SF Transbay, Mission Bay, 22nd Street, Millbrae, Hillsdale, Redwood City, Palo Alto, Mountain View, Santa Clara, San Jose
	Los Banos HS operated every 15 minutes using AGV-100MPH.
	Stopping SF Transbay, Millbrae, Redwood City, San Jose (... Los Banos)

				07:00 07:30 08:00
SF Transbay (KP-1.9) Mission Bay (KP0.3) 22nd Street (KP3.1) Oakdale (KP4.8) Bayshore (KP8.4) So. San Francisco (KP15.0) San Bruno (KP18.7) Millbrae (KP22.1) Broadway (KP24.5) Burlingame (KP26.2) San Mateo (KP28.8) Hayward Park (KP30.8) Hillsdale (KP32.7) Belmont (KP35.3) San Carlos (KP37.4) Redwood City (KP40.9) Atherton (KP44.8) Menlo Park (KP46.5) Palo Alto (KP48.5) California Ave (KP51.2) San Antonio (KP54.9) Mountain View (KP58.1) Sunnyvale (KP62.5) Lawrence (KP65.7) Santa Clara (KP72.0) College Park (KP74.0) San Jose (KP76.5) Tamien (KP78.9)