Minimum upgrades

Minimum upgrades southbound
	Pacheco HSR	Caltrain Skip Stop 2	Caltrain Bullet 2	Caltrain Skip Stop 1	Pacheco HSR	Caltrain Skip Stop 2	Caltrain Bullet 1	Caltrain Skip Stop 1

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

Minimum upgrades northbound
	Pacheco HSR	Caltrain Skip Stop 1	Caltrain Bullet 1	Caltrain Skip Stop 2	Pacheco HSR	Caltrain Skip Stop 1	Caltrain Bullet 2	Caltrain Skip Stop 2

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

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:

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

Train7 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.

Timetable Quality Metrics for Minimum upgrades

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 = 204
	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	-	9 -	17 -	-	21 0.07	24 0.35	27 0.23	24 0.56	32 0.37	33 0.33	35 0.44	-	34 0.44	41 0.37	42 0.45	38 1.17	-	43 0.75	44 1.23	52 0.71	54 0.43	48 0.58	59 0.63	62 0.62	66 0.47	-	60 0.36	-	10.6
Mission Bay	9 -	-	-	-	16 0.05	-	23 0.23	23 0.52	28 0.38	33 0.29	31 0.46	-	33 0.43	37 0.40	42 0.43	33 1.29	-	41 0.78	40 1.38	51 0.73	50 0.48	45 0.65	55 0.72	62 0.67	62 0.55	-	57 0.42	-	10.9
22nd Street	17 -	-	-	-	-	18 0.18	-	23 0.29	-	26 0.22	61 0.14	-	31 0.29	63 0.15	35 0.34	58 0.50	-	41 0.54	61 0.64	45 0.60	78 0.23	50 0.43	80 0.37	55 0.57	78 0.34	-	63 0.30	-	6.1
Oakdale	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Bayshore	21 1.45	16 0.33	-	-	-	-	17 0.06	-	21 0.14	-	25 0.20	-	57 0.09	30 0.20	-	34 0.59	-	53 0.31	39 0.74	61 0.34	44 0.32	49 0.36	49 0.52	66 0.41	55 0.44	-	61 0.30	-	6.8
So. San Francisco	24 2.24	-	18 0.14	-	-	-	-	15 0.04	-	19 0.04	-	-	24 0.09	-	27 0.13	52 0.19	-	33 0.27	53 0.31	37 0.33	83 0.11	42 0.27	77 0.22	48 0.40	71 0.26	-	55 0.25	-	5.3
San Bruno	27 3.47	23 0.99	-	-	17 0.04	-	-	-	15 -	-	18 0.06	-	-	23 0.09	-	27 0.33	-	43 0.21	32 0.52	50 0.25	37 0.26	43 0.30	42 0.47	59 0.38	48 0.46	-	54 0.33	-	8.2
Millbrae	24 3.42	23 0.90	23 0.22	-	-	15 0.03	-	-	-	14 -	-	-	15 0.04	-	22 0.06	25 0.19	-	24 0.21	35 0.28	32 0.24	56 0.11	30 0.27	61 0.21	42 0.36	63 0.25	-	42 0.30	-	7.1
Broadway	32 3.53	28 1.05	-	-	21 0.06	-	15 -	-	-	-	13 -	-	-	18 0.04	-	23 0.20	-	38 0.14	28 0.37	46 0.18	32 0.20	38 0.24	37 0.40	55 0.33	44 0.43	-	49 0.31	-	7.5
Burlingame	33 4.52	32 1.21	26 0.37	-	-	19 0.10	-	14 -	-	-	-	-	15 -	-	19 0.06	40 0.11	-	25 0.22	40 0.27	28 0.31	66 0.11	32 0.32	65 0.26	39 0.53	63 0.35	-	44 0.41	-	9.1
San Mateo	35 6.72	31 2.03	61 0.27	-	25 0.14	-	18 0.06	-	13 -	-	-	-	-	15 -	-	19 0.21	-	38 0.15	24 0.48	42 0.23	29 0.29	35 0.36	34 0.63	51 0.52	40 0.73	-	46 0.55	-	13.4
Hayward Park	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Hillsdale	34 5.99	33 1.66	31 0.47	-	56 0.06	24 0.19	-	15 0.10	-	15 -	-	-	-	-	14 -	37 0.04	-	20 0.14	29 0.19	24 0.22	60 0.08	25 0.30	57 0.23	34 0.50	56 0.36	-	37 0.48	-	11.0
Belmont	42 4.47	38 1.38	66 0.21	-	30 0.11	-	23 0.07	-	18 0.05	-	15 -	-	-	-	-	14 -	-	33 0.05	19 0.18	37 0.09	24 0.14	30 0.18	29 0.36	46 0.29	35 0.47	-	41 0.37	-	8.4
San Carlos	42 4.28	41 1.22	35 0.39	-	-	27 0.19	-	22 0.10	-	19 0.04	-	-	14 -	-	-	-	-	16 0.06	-	20 0.13	-	25 0.17	60 0.14	30 0.38	54 0.27	-	38 0.35	-	7.7
Redwood City	39 6.84	34 2.19	60 0.36	-	34 0.16	54 0.17	27 0.13	26 0.18	23 0.13	41 0.05	19 0.08	-	37 0.02	14 -	-	-	-	25 -	15 0.09	38 0.05	20 0.11	23 0.17	25 0.35	40 0.31	31 0.55	-	35 0.47	-	12.4
Atherton	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Menlo Park	43 4.65	42 1.37	41 0.41	-	55 0.09	33 0.26	46 0.08	24 0.22	41 0.08	25 0.10	38 0.06	-	20 0.06	33 0.03	16 0.04	25 -	-	-	-	14 -	-	16 0.08	-	24 0.23	47 0.19	-	28 0.33	-	8.3
Palo Alto	44 4.57	40 1.49	63 0.28	-	39 0.13	54 0.18	32 0.13	34 0.17	28 0.14	39 0.07	24 0.11	-	26 0.06	19 0.06	-	15 0.06	-	-	-	-	15 -	27 0.04	20 0.15	43 0.12	26 0.32	-	30 0.30	-	8.4
California Ave	52 4.58	51 1.38	45 0.47	-	60 0.10	37 0.33	51 0.11	32 0.26	46 0.12	28 0.14	42 0.10	-	24 0.10	37 0.05	20 0.08	38 0.05	-	14 -	-	-	-	15 -	-	20 0.21	44 0.18	-	29 0.30	-	8.6
San Antonio	54 5.25	50 1.72	80 0.33	-	44 0.18	83 0.20	37 0.21	56 0.22	32 0.26	66 0.09	29 0.23	-	59 0.07	24 0.14	-	20 0.23	-	-	15 -	-	-	-	15 0.08	-	21 0.32	-	27 0.31	-	9.9
Mountain View	47 5.55	45 1.77	50 0.49	-	50 0.15	42 0.40	43 0.19	29 0.44	38 0.23	32 0.22	35 0.22	-	25 0.21	30 0.14	25 0.17	23 0.28	-	16 0.12	27 0.10	15 -	-	-	-	15 0.09	-	-	18 0.34	-	11.1
Sunnyvale	59 4.28	55 1.42	80 0.31	-	49 0.16	78 0.24	42 0.22	60 0.25	37 0.29	65 0.13	34 0.28	-	57 0.12	29 0.20	60 0.10	25 0.40	-	-	20 0.28	-	15 0.04	-	-	-	16 0.15	-	22 0.18	-	9.1
Lawrence	62 3.55	61 1.12	55 0.39	-	66 0.11	48 0.37	59 0.15	42 0.34	54 0.20	39 0.22	51 0.19	-	34 0.21	46 0.14	30 0.23	39 0.31	-	24 0.21	43 0.18	20 0.19	-	15 0.06	-	-	-	-	18 0.11	-	8.3
Santa Clara	66 2.34	62 0.80	80 0.20	-	55 0.10	72 0.20	48 0.16	63 0.20	44 0.22	64 0.12	40 0.24	-	57 0.13	35 0.19	54 0.14	31 0.45	-	47 0.15	26 0.43	44 0.14	21 0.13	-	16 0.11	-	-	-	15 -	-	6.4
College Park	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
San Jose	59 2.97	57 1.00	63 0.30	-	61 0.11	55 0.33	54 0.18	41 0.42	49 0.27	44 0.24	46 0.29	-	37 0.29	41 0.25	38 0.30	35 0.64	-	28 0.43	29 0.67	29 0.38	27 0.21	17 0.30	22 0.22	18 0.16	15 -	-	-	-	10.0
Tamien	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-	-
Total	84.7	25.0	5.6		1.8	3.7	2.2	4.3	2.9	2.3	3.1		2.7	2.4	2.5	7.3		4.7	8.3	5.1	3.2	5.1	6.1	7.1	7.1		7.1		204.4

	Caltrain Skip Stop 1 operated every 30 minutes using KISS-100MPH-6MW.
	Stopping SF Transbay, 22nd Street, So. San Francisco, Millbrae, Burlingame, Hillsdale, San Carlos, Menlo Park, California Ave, Mountain View, Lawrence, San Jose
	Caltrain Skip Stop 2 operated every 30 minutes using KISS-100MPH-6MW.
	Stopping SF Transbay, Mission Bay, Bayshore, San Bruno, Broadway, San Mateo, Belmont, Redwood City, Palo Alto, San Antonio, Sunnyvale, Santa Clara, San Jose
	Pacheco HSR operated every 30 minutes using AGV-100MPH.
	Stopping SF Transbay, Millbrae, Redwood City, San Jose (... Los Banos)
	Caltrain Bullet 1 operated every 60 minutes using KISS-100MPH-6MW.
	Stopping SF Transbay, Mission Bay, Millbrae, Redwood City, Menlo Park, Mountain View, San Jose
	Caltrain Bullet 2 operated every 60 minutes using KISS-100MPH-6MW.
	Stopping SF Transbay, Mission Bay, Millbrae, Hillsdale, Palo Alto, Mountain View, San Jose

				07:00 07:30 08:00 08:30 09: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)