Mid-Atlantic Bus Lines Excel Spreadsheet

Microsoft Excel 15.0 Sensitivity Report Worksheet: [MId-tlntic !"s lines.xlsx#$epot 1 Report %reted: &'('(01) *:1+:)) ,M

Variable Cells

%ell $B$3 $C$3 $D$3 $E$3

2e U1 U2 V1 V2

inl Red"ced !/ective ,llo!le ,llo!le 3l"e %ost %oe4cient Increse $ecrese 0.0014285714 0 700 1.000E+030 0 0 0 300 0 1.00000E+030 0 0 0 0 1.00000E+030 0.002 0 0 1.000E+030 0

Constraints

%ell $F$10 $F$11 $F$12 $F$13 $F$14 $F$15 $F$16 $F$17 $F$

inl Shdo %onstrint ,llo!le 2e 3l"e rice R.6. Side Increse D2 -0.5714285714 0 0 1. 1.000E+030 D3 -0.5142857143 0 0 1. 1.000E+030 D4 -0.4285714286 0 0 1. 1.000E+030 D5 -0.0857142857 0 0 1. 1.000E+030 D6 -0.2857142857 0 0 1. 1.000E+030 D7 -0.0571428571 0 0 1. 1.000E+030 D8 -0.3714285714 0 0 1. 1.000E+030 1 1 1 1.000E+030 D1 0 1 0 0. 0.05

,llo!le $ecrese 0.5714285714 0.5142857143 0.4285714286 0.0857142857 0.2857142857 0.0571428571 0.3714285714 1 1

Variables U1

U2

700 0.00142

V1 300 0

!b"e#tie %&n#tion

V2 0 0

0 0. 0.002

1

Constrains D1 D2 D3 D4 D5 D6 D7 D8

700 300 200 400 500 500 800 300 0

30 300 600 700 600 400 500 500 200 0

-40 -50 -50 -50 -40 -50 -40 -30 40

-500 -500 -400 -500 -400 -500 -600 -400 500

0 '( -0.57142 '( -0.514286 '( -0.428571 '( -0.085714 '( -0.285714 '( -0.057143 '( -0.37142 '( 1

0 0 0 0 0 0 0 0 1

Microsoft Excel 15.0 Sensitivity Report Worksheet: [MId-tlntic !"s lines.xlsx#$epot ( Report %reted: &'('(01) *:1):0+ ,M

Variable Cells

%ell $B$3 $C$3 $D$3 $E$3

2e U1 U2 V1 V2

inl Red"ced !/ective ,llo!le 3l"e %ost %oe4cient Increse 0.0001304348 0 300 78.47368421 0.001313043 0 600 450 0.02 0 0 1.00000E+030 0 -32.60865652 0 32.60865652

Constraints

%ell $F$10 $F$11 $F$12 $F$13 $F$14 $F$15 $F$16 $F$17 $F$

inl Shdo %onstrint ,llo!le 2e 3l"e rice R.6. Side Increse D2 -0.126086565 0 0 1.00000E+030 D3 0 0.717313043 0 0.12 D4 -0.1130434783 0 0 1.00000E+030 D5 -0.178260866 0 0 1.00000E+030 D6 -0.231304348 0 0 1.00000E+030 D7 1.110223E-016 0.15652173 0 0.3037037037 D8 -0.282608657 0 0 1.00000E+030 1 0.873130435 1 1.00000E+030 D1 -0.213043478 0 0 1.00000E+030

,llo!le $ecrese 128.57142857 125 3.260865652 1.00000E+030

,llo!le $ecrese 0.126086565 0.8 0.1130434783 0.178260866 0.231304348 0.0857142857 0.282608657 1 0.213043478

D5 D7

7.826087 117.313

40 40

400 600

Variables U1

U2

V1

300 600 0.00013 0.00131 !b"e#tie %&n#tion

V2 0 0.02

0 0

0.87313


700 300 200 400 500 500 800 300 0

300 600 700 600 400 500 500 200 0

-40 -50 -50 -50 -40 -50 -40 -30 50

-500 -500 -400 -500 -400 -500 -600 -400 500

-0.21304 '( -0.126087 '( 1.11E-016 '( -0.113043 '( -0.178261 '( -0.2313 '( 2.22E-016 '( -0.28260 '( 1

0 0 0 0 0 0 0 0 1

Microsoft Excel 15.0 Sensitivity Report Worksheet: [MId-tlntic !"s lines.xlsx#$epot + Report %reted: &'('(01) *:1):17 ,M

Variable Cells

%ell $B$3 $C$3 $D$3 $E$3

2e U1 U2 V1 V2

inl 3l"e 0 0.0014285714 0 0.0025

Red"ced !/ective ,llo!le ,llo!le %ost %oe4cient Increse $ecrese 0 200 0 1.00000E+030 0 700 1.00000E+030 0 0 0 0 1.00000E+030 0 0 1.00000E+030 0

Constraints

%ell $F$10 $F$11 $F$12 $F$13 $F$14 $F$15 $F$16 $F$17 $F$

inl Shdo %onstrint ,llo!le ,llo!le 2e 3l"e rice R.6. Side Increse $ecrese D2 -0.32857142 0 0 1.00000E+030 0.32857142 D3 0 1 0 0.4583333333 1 D4 -0.32857142 0 0 1.00000E+030 0.32857142 D5 -0.4285714286 0 0 1.00000E+030 0.4285714286 D6 -0.5357142857 0 0 1.00000E+030 0.5357142857 D7 -0.7857142857 0 0 1.00000E+030 0.7857142857 D8 -0.7142857143 0 0 1.00000E+030 0.7142857143 1 1 1 1.00000E+030 1 D1 -0.8214285714 0 0 1.00000E+030 0.8214285714

Variables U1

U2

V1

200 700 0 0.00142 !b"e#tie %&n#tion

V2 0 0

0 0.0025

1


700 300 200 400 500 500 800 300 0

300 600 700 600 400 500 500 200 0

-40 -50 -50 -50 -40 -50 -40 -30 50

-500 -500 -400 -500 -400 -500 -600 -400 400

-0.82142 '( -0.32857 '( 0 '( -0.32857 '( -0.428571 '( -0.535714 '( -0.785714 '( -0.714286 '( 1

0 0 0 0 0 0 0 0 1

Microsoft Excel 15.0 Sensitivity Report Worksheet: [MId-tlntic !"s lines.xlsx#$epot ) Report %reted: &'('(01) *:1):)1 ,M

Variable Cells

%ell $B$3 $C$3 $D$3 $E$3

2e U1 U2 V1 V2

inl 3l"e 0.0008510638 0.000361702 0.002553115 0.001744680

Red"ced %ost 0 0 0 0

!/ective ,llo!le %oe4cient Increse 400 350 600 33.333333333 0 0.865652174 0 51.851851852

Constraints

%ell $F$10 $F$11 $F$12 $F$13 $F$14 $F$15 $F$16 $F$17 $F$

inl Shdo %onstrint ,llo!le 2e 3l"e rice R.6. Side Increse D2 -0.182787234 0 0 1.00000E+030 D3 1.110223E-016 0.55744680 0 0.1642857143 D4 -0.078723404 0 0 1.00000E+030 D5 0 0.085106383 0 0.026086565 D6 -0.106382787 0 0 1.00000E+030 D7 0 0.278723404 0 0.3037037037 D8 -0.33114836 0 0 1.00000E+030 1 0.02127656 1 1.00000E+030 D1 -0.078723404 0 0 1.00000E+030

,llo!le $ecrese 21.05263157 280 5.1851851852 8.65652173

,llo!le $ecrese 0.182787234 0.1714285714 0.078723404 0.178260866 0.106382787 0.0444444444 0.33114836 1 0.078723404

D5 D7

15.3115 212.766

40 40

400 600

Variables U1

U2

V1

V2

400 600 0 0 0.000851 0.00036 0.002553 0.001745 !b"e#tie %&n#tion

0.02128


700 300 200 400 500 500 800 300 0

300 600 700 600 400 500 500 200 0

-40 -50 -50 -50 -40 -50 -40 -30 50

-500 -500 -400 -500 -400 -500 -600 -400 500

-0.07872 '( -0.1827 '( 1.11E-016 '( -0.07872 '( 0 '( -0.106383 '( 0 '( -0.33115 '( 1

0 0 0 0 0 0 0 0 1

Microsoft Excel 15.0 Sensitivity Report Worksheet: [MId-tlntic !"s lines.xlsx#$epot 5 Report %reted: &'('(01) *:1):5) ,M

Variable Cells

%ell $B$3 $C$3 $D$3 $E$3

2e U1 U2 V1 V2

inl Red"ced !/ective ,llo!le ,llo!le 3l"e %ost %oe4cient Increse $ecrese 0.0014285714 0 500 140 0 0.0007142857 0 400 0 87.5 0 0 0 0 1.00000E+030 0.0025 0 0 1.00000E+030 0

Constraints

%ell $F$10 $F$11 $F$12 $F$13 $F$14 $F$15 $F$16 $F$17 $F$

inl Shdo %onstrint ,llo!le ,llo!le 2e 3l"e rice R.6. Side Increse $ecrese D2 -0.32857142 0 0 1.00000E+030 0.32857142 D3 -0.2142857143 0 0 1.00000E+030 0.2142857143 D4 -0.25 0 0 1.00000E+030 0.25 D5 0 1 0 0.032608657 0.0227272727 D6 -0.1785714286 0 0 1.00000E+030 0.1785714286 D7 0 0 0 0.01230762 0.0555555556 D8 -0.4285714286 0 0 1.00000E+030 0.4285714286 1 1 1 1.00000E+030 1 D1 -0.0357142857 0 0 1.00000E+030 0.0357142857

Variables U1

U2

V1

500 400 0.00142 0.000714 !b"e#tie %&n#tion

V2 0 0

0 0.0025

1


700 300 200 400 500 500 800 300 0

300 600 700 600 400 500 500 200 0

-40 -50 -50 -50 -40 -50 -40 -30 40

-500 -500 -400 -500 -400 -500 -600 -400 400

-0.035714 '( -0.32857 '( -0.214286 '( -0.25 '( 0 '( -0.178571 '( 0 '( -0.428571 '( 1

0 0 0 0 0 0 0 0 1

Microsoft Excel 15.0 Sensitivity Report Worksheet: [MId-tlntic !"s lines.xlsx#$epot 7 Report %reted: &'('(01) *:15:0* ,M

Variable Cells

%ell $B$3 $C$3 $D$3 $E$3

2e U1 U2 V1 V2

inl 3l"e 0.0008510638 0.000361702 0.002553115 0.001744680


!/ective ,llo!le %oe4cient Increse 500 125 500 21.66666667 0 7.608656522 0 18.51851851

Constraints

%ell $F$10 $F$11 $F$12 $F$13 $F$14 $F$15 $F$16 $F$17 $F$

inl Shdo %onstrint ,llo!le 2e 3l"e rice R.6. Side Increse D2 -0.182787234 0 0 1.00000E+030 D3 1.110223E-016 0.212765574 0 0.1642857143 D4 -0.078723404 0 0 1.00000E+030 D5 1.110223E-016 0.7446808511 0 0.026086565 D6 -0.106382787 0 0 1.00000E+030 D7 2.220446E-016 0.106382787 0 0.3037037037 D8 -0.33114836 0 0 1.00000E+030 1 0.836170213 1 1.00000E+030 D1 -0.078723404 0 0 1.00000E+030

,llo!le $ecrese 184.21052632 100 1.851851851 76.08656522

,llo!le $ecrese 0.182787234 0.1714285714 0.078723404 0.178260866 0.106382787 0.0444444444 0.33114836 1 0.078723404

D5 D7

34.04255 361.7021

40 40

400 600

Variables U1

U2

V1

V2

500 500 0 0 0.000851 0.00036 0.002553 0.001745 !b"e#tie %&n#tion

0.83617


700 300 200 400 500 500 800 300 0

300 600 700 600 400 500 500 200 0

-40 -50 -50 -50 -40 -50 -40 -30 50

-500 -500 -400 -500 -400 -500 -600 -400 500

-0.07872 '( -0.1827 '( 1.11E-016 '( -0.07872 '( 1.11E-016 '( -0.106383 '( 2.22E-016 '( -0.33115 '( 1

0 0 0 0 0 0 0 0 1

Microsoft Excel 15.0 Sensitivity Report Worksheet: [MId-tlntic !"s lines.xlsx#$epot & Report %reted: &'('(01) *:15:(+ ,M

Variable Cells

%ell $B$3 $C$3 $D$3 $E$3

2e U1 U2 V1 V2

inl Red"ced !/ective ,llo!le ,llo!le 3l"e %ost %oe4cient Increse $ecrese 0.0010606061 0 800 0 0 0.0003030303 0 500 0 0 0 0 0 0 1.00000E+030 0.0016666667 0 0 1.00000E+030 0

Constraints

%ell $F$10 $F$11 $F$12 $F$13 $F$14 $F$15 $F$16 $F$17 $F$

inl Shdo %onstrint ,llo!le ,llo!le 2e 3l"e rice R.6. Side Increse $ecrese D2 -0.3333333333 0 0 1.00000E+030 0.3333333333 D3 -0.2424242424 0 0 1.00000E+030 0.2424242424 D4 -0.2272727273 0 0 1.00000E+030 0.2272727273 D5 -0.0151515152 0 0 1.00000E+030 0.0151515152 D6 -0.1515151515 0 0 1.00000E+030 0.1515151515 D7 0 1 0 0.0128205128 0.047610476 D8 -0.287878787 0 0 1.00000E+030 0.287878787 1 1 1 1.00000E+030 1 D1 1.110223E-016 0 0 0.0416666667 0.023805238

D5 D7

40 40

40 600

400 600

Variables U1

U2

V1

800 500 0.001061 0.000303 !b"e#tie %&n#tion

V2 0 0 0 0.001667 1


700 300 200 400 500 500 800 300 0

300 600 700 600 400 500 500 200 0

-40 -50 -50 -50 -40 -50 -40 -30 40

-500 -500 -400 -500 -400 -500 -600 -400 600

1.11E-016 '( -0.333333 '( -0.242424 '( -0.227273 '( -0.015152 '( -0.151515 '( 0 '( -0.28787 '( 1

0 0 0 0 0 0 0 0 1

Microsoft Excel 15.0 Sensitivity Report Worksheet: [MId-tlntic !"s lines.xlsx#$epot 8 Report %reted: &'('(01) *:15:+& ,M

Variable Cells

%ell $B$3 $C$3 $D$3 $E$3

2e U1 U2 V1 V2

inl 3l"e 0.0014285714 0.0007142857 0 0.0025


!/ective ,llo!le %oe4cient Increse 300 20 200 0 0 0 0 1.00000E+030

Constraints

%ell $F$10 $F$11 $F$12 $F$13 $F$14 $F$15 $F$16 $F$17 $F$

inl Shdo %onstrint ,llo!le 2e 3l"e rice R.6. Side Increse D2 -0.32857142 0 0 1.00000E+030 D3 -0.2142857143 0 0 1.00000E+030 D4 -0.25 0 0 1.00000E+030 D5 0 0.142857142 0 0.032608657 D6 -0.1785714286 0 0 1.00000E+030 D7 0 0.2857142857 0 0.01230762 D8 -0.4285714286 0 0 1.00000E+030 1 0.5714285714 1 1.00000E+030 D1 -0.0357142857 0 0 1.00000E+030

,llo!le $ecrese 0 12.5 1.00000E+030 0

,llo!le $ecrese 0.32857142 0.2142857143 0.25 0.0227272727 0.1785714286 0.0555555556 0.4285714286 1 0.0357142857

D5 D7

17.14286 228.5714

40 40

400 600

Variables U1

U2

V1

300 200 0.00142 0.000714 !b"e#tie %&n#tion

V2 0 0

0 0.0025

0.57142


700 300 200 400 500 500 800 300 0

300 600 700 600 400 500 500 200 0

-40 -50 -50 -50 -40 -50 -40 -30 30

-500 -500 -400 -500 -400 -500 -600 -400 400

-0.035714 '( -0.32857 '( -0.214286 '( -0.25 '( 0 '( -0.178571 '( 0 '( -0.428571 '( 1

0 0 0 0 0 0 0 0 1

V)*)B,E

U1 /CE/ ),E

U2 F*E/ ),E

DE!/ 1 ,)DE,) Variables U1

DE!/ 2 B

U2

700 0.00142

V1 300 0

V2 0 0


Variables 0 0.002

1

!b"e#tie %

DE!/ 3 )/! D C Variables U1

U2

DE!/ 4 * V1

200 700 0 0.00142

V2 0 0


Variables 0 0.0025

1

!b"e#tie %

DE!/ 5 *),E Variables U1

DE!/ 6 C U2

V1

500 400 0.00142 0.000714

V2 0 0


Variables 0 0.0025

1

!b"e#tie %

DE!/ 7 )V)) Variables U1

DE!/ 8  U2

800 500 0.001061 0.000303 !b"e#tie %&n#tion

V1 ,)B!* !U*

V1

V2

Variables

0 0 0 0.001667 1

!b"e#tie %

V2 F)C,/ D!,,)*

),/!*E U1

U2

V1

300 600 0.00013 0.00131 &n#tion

V2 0 0.02

0 0

U2

V1

V2

400 600 0 0 0.000851 0.00036 0.002553 0.001745 &n#tion

0.02128

)*,E/! U1

U2

V1

V2

500 500 0 0 0.000851 0.00036 0.002553 0.001745 &n#tion

0.83617

C!V,,E U1

U2

300 200 0.00142 0.000714 &n#tion

40 50 40 40

D2 D4 D6 D8

50 50 50 30

0.87313

C!D U1

D1 D3 D5 D7

V1

V2 0 0

0.57142

0 0.0025

500 400 400 600

700

500 500 500 400

600

49 600

500

19 500

400

39 400

49 400

D!,,)* 300

200

100

0 25

30

35

40 ,)B!* !U*

45

39 500 19 500 29 500

29 400

50

55

Mid-Atlantic Bus Lines Excel Spreadsheet

Recommend Documents