OR 2 Excel OK. 1a: Excel2007 Office. Excel b OK. 2.,,. ツール アドイン 1b: Excel2003 :,.,.,.,,,.,,. 1. Excel2003.

Save this PDF as:
 WORD  PNG  TXT  JPG

Size: px
Start display at page:

Download "OR 2 Excel 2 3.. 4. OK. 1a: Excel2007 Office. Excel2003 1.. 1b. 2.. 3. OK. 2.,,. ツール アドイン 1b: Excel2003 :,.,.,.,,,.,,. 1. Excel2003."

Transcription

1 OR 2 Excel Excel.,. 2.2, x mathematical programming optimization problem, OR 1., 1 : f(x) h i (x) = 0, i = 1,..., m, g j (x) 0, j = 1,..., l, f(x) h i (x) = 0, i = 1,..., m, g j (x) 0, j = 1,..., l., f, g j, h i : IR n IR., f (objective function), x (decision variable), x h i (x) = 0, i = 1,..., m, g j (x) 0, j = 1,..., l (constraints) 2.,,, 2 : min{f(x) x S} = max{ f(x) x S}., S := {x IR n h i (x) = 0, i = 1,..., m, g j (x) 0, j = 1,..., l}. f, g j, h i, linear programming; LP. 2.3 Excel.,.,. Excel,, Excel2003 :..., Excel2003 : Excel Office, Excel. Excel 1a

2 OR 2 Excel OK. 1a: Excel2007 Office. Excel b OK. 2.,,. ツール アドイン 1b: Excel2003 :,.,.,.,,,.,,. 1. Excel2003.

3 OR 2 Excel 3 2: 2..,,, : 4..,,,. 2.4,. 1 2 Sheet1, 2 X Y A,B,C,,.,. X Y. : X, Y x, y. 4: Sheet1, f f = 90x + 100y. x, y.

4 OR 2 Excel 4,. x, y., A g A, X x 0.2kg, Y y 0.3kg, g A = 0.2x + 0.3y kg. A 27kg, g A 27. B, C. 0, x 0, y 0., LP : f = 90x + 100y g A = 0.2x + 0.3y 27 g B = 0.3x + 0.1y 20 g C = 0.1x + 0.4y 30 x 0, y 0., LP Sheet A,B,C., G5:G7 A,B,C 27, 20, 30. D10 D11 X Y LP x, y. F8 LP f, f : F8 : = D8 * D10 + E8 * E10 =sumproduct(d8:e8,d10:e10 G5, G6, G7, A,B,C LP g A, g B, g C, g A, g B, g C : F5 : = D5 * D10 + E5 * E10 =sumproduct(d5:e5,d10:e10 F6 : = D6 * D10 + E6 * E10 =sumproduct(d6:e6,d10:e10 F7 : = D7 * D10 + E7 * E10 =sumproduct(d7:e7,d10:e10 sumproduct 2. F5 F8 : F5 =sumproduct(d5:e5,d$10:e$10). F5 Ctrl+C, F5 F8.,,, OK. Ctrl+V,..

5 OR 2 Excel 5 5:,,. Excel2003 :,., F8,.., Sheet1 f F8,.. f,.,.., D10:E10..,, g A F5,, 27, OK.,. 6: 3 3, 7,, 8. 7: 1 1 8:

6 OR 2 Excel 6 x 0, y 0,,.,,, OK.,,,. 9:, OK,. 10:,, X : 47.14kg Y : 58.57kg, : 10,100. OK,,.,,,.,.,,,.

7 OR 2 Excel Sheet2, 2 X Y,,,.,,,. X Y. X Y , ,.,, EXCEL ,450,. 8, ,. 2 Sheet3,.. 2.,...., 2450, 8.. Int. 11:,.,, OK.,.

8 OR 2 Excel 8, : 2,500 3, , ,, Sheet ,000 : =MAX(D5:D7)-MIN(D5:D7). 3, 5. 12:.,, OK.,. ショートケーキ 種 類 単 価 250 数 量 24 金 6000 額 チョコケーキ チーズケーキ 合 計 金 数 額 量 ばらつき 67 3 目 的 関 数 予 算 金 額 [ 円 ] 20,000 13: 10 4.

9 OR 2 Excel : f = x + y + z g 1 = 250 x y z 20, 000 g 2 = max{x, y, z} min{x, y, z} 3 x, y, z 5.,,, x, y, z., 2., : f = x + y + z g 1 = 250x + 350y + 300z 20, 000 g 2 = + u + v 3 g 3 = x u 0 g 4 = y u 0 g 5 = z u 0 g 6 = x v 0 g 7 = y v 0 g 8 = z v 0 x, y, z 5, u, v.. 2.6,. 5 2 Sheet5, A B 2 L1 L3 3. A, B 1 60, L1 L3,. L1 L3 20, 30, 50. A, B.. 1 L1 L2 L3 A B A L1, L2, L3 x A1, x A2, x A3, B L1, L2, L3 x B1, x B2, x B3.,. x A1 x B3, P. P = 30 x A x A x A x B x B x B3

10 OR 2 Excel 10,,.. x A1 + x A2 + x A3 60, x B1 + x B2 + x B3 40, x A1 + x B1 = 20, x A2 + x B2 = 30, x A3 + x B3 = 50.,. 14: Excel, : A G7 = D7 + E7 + F7 =sum(d7:f7) B G8 = D8 + E8 + F8 =sum(d8:f8) L1 D9 = D7 + D8 =sum(d7:d8) L2 E9 = E7 + E8 =sum(e7:e8) L3 F9 = F7 + F8 =sum(f7:f8) G4:G5, D4:F4 A, D5:F5 B D7:F7, D8:F8, =D4*D7+E4*E7+F4*F7, =D5*D8+E5*E8+F5*F8, =sumproduct(d4:f4,d7:f7) =sumproduct(d5:f5,d8:f8), H4 =G4+G5 =sum(g4:g5) :.,., A L1 : 20 L2 : 0 L3 : 40,, 3,600. B L1 : 0 L2 : 30 L3 : 10

11 OR 2 Excel 11 16:,,,,.,. 2.7,. 6 2 Sheet6, 5 A E L1 L A B C D E ,, =1, 5. i j 1, x ij,., 0 x ij 1. LP,.

or57_4_175.dvi

or57_4_175.dvi c Excel Excel Excel Excel Microsoft Excel 1. OR Microsoft Excel Excel 1 Excel Excel Excel or 2007 Excel OR Excel Excel LP Excel LP Excel 112 8551 1 13 27 1 Excel Excel Excel 2010 Excel OpenOffice Calc

More information

1 4 2 (1) (B4:B6) (2) (B12:B14) (3) 1 (D4:H4) D5:H243 (4) 240 20 (B8:B10) (5) 240 (B8) 0 1

1 4 2 (1) (B4:B6) (2) (B12:B14) (3) 1 (D4:H4) D5:H243 (4) 240 20 (B8:B10) (5) 240 (B8) 0 1 4 1 4 (1) (2) (3) (4) 1 4 2 (1) (B4:B6) (2) (B12:B14) (3) 1 (D4:H4) D5:H243 (4) 240 20 (B8:B10) (5) 240 (B8) 0 1 4 3 2 2.1 2 Excel 2 (A1:A14 D3:H3 B4,B5,B6) B5 0.035 4 4 2.2 3 1 1 B12: =B5+1 B13: =B12

More information

<4D6963726F736F667420576F7264202D20457863656C20835C838B836F815B82C982E682E990FC8C608C7689E68252>

<4D6963726F736F667420576F7264202D20457863656C20835C838B836F815B82C982E682E990FC8C608C7689E68252> Excel ソルバーで 解 く 線 形 計 画 問 題 2011 年 度 大 阪 大 学 経 済 学 部 大 学 院 経 済 学 研 究 科 目 次 Excel 2007 Excel 1 1 1 3 Excel 2010 Excel 12 12 13 14 i 1.Excel の 準 備 Excel 2007 1.1 ソルバーの 有 効 化 Microsoft Excel データ ソルバー Office

More information

BSE Excel

BSE Excel 200 2 200311110 BSE Excel 1 3 11 1 21 2 20 1 26 2203 2 10 1718 485 13 2 2 6 100 371 12 3 100 679 1 12 2 9 1 29 2 10 1 1-1 2 /kg 1-2 3 1-3 2 http://www.maff.go.jp/ 3 Excel 2 15 1 26 2 2 9 16 1 30 2 10 1-4

More information

FX ) 2

FX ) 2 (FX) 1 1 2009 12 12 13 2009 1 FX ) 2 1 (FX) 2 1 2 1 2 3 2010 8 FX 1998 1 FX FX 4 1 1 (FX) () () 1998 4 1 100 120 1 100 120 120 100 20 FX 100 100 100 1 100 100 100 1 100 1 100 100 1 100 101 101 100 100

More information

... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2

... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2 1 ... 3... 3... 3... 3... 4... 7... 10... 10... 11... 12... 12... 13... 14... 15... 18... 19... 20... 22... 22... 23 2 3 4 5 6 7 8 9 Excel2007 10 Excel2007 11 12 13 - 14 15 16 17 18 19 20 21 22 Excel2007

More information

f(x) x S (optimal solution) f(x ) (optimal value) f(x) (1) 3 GLPK glpsol -m -d -m glpsol -h -m -d -o -y --simplex ( ) --interior --min --max --check -

f(x) x S (optimal solution) f(x ) (optimal value) f(x) (1) 3 GLPK glpsol -m -d -m glpsol -h -m -d -o -y --simplex ( ) --interior --min --max --check - GLPK by GLPK http://mukun mmg.at.infoseek.co.jp/mmg/glpk/ 17 7 5 : update 1 GLPK GNU Linear Programming Kit GNU LP/MIP ILOG AMPL(A Mathematical Programming Language) 1. 2. 3. 2 (optimization problem) X

More information

&

& & & & c & B & c & & aa c c a a nk a a & a aa aaa & A A A A & 7 & & c og og & c c k g a og ok c c & 7 7 n & aa & & & & & & & & & & & g & & a a & & 171 1 & 1 7 1 1 6 de 666 66 6 7 6 f 6 & & c & 1 1 1 1 1

More information

11夏特集号初校.indd

11夏特集号初校.indd 1 2 3 5 50 40 7 6 3 ABC 3 5 A 5% B C 100 3 1 2 3 A 5% 5% 5% B 10% 5% 0% C 20% 10% 15% A 15.8% 15.0% 0.8% B 15.5% 15.0% 0.5% C 12.2% 15.0% 2.8% 2,000 1,500 1,000 500 0 10% 5% 3% 1% 01 5 10 15 20 25 30

More information

1 2 3 4 5 6 X Y ABC A ABC B 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 13 18 30 P331 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 ( ) 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59

More information

26 2 3 4 5 8 9 6 7 2 3 4 5 2 6 7 3 8 9 3 0 4 2 4 3 4 4 5 6 5 7 6 2 2 A B C ABC 8 9 6 3 3 4 4 20 2 6 2 2 3 3 4 4 5 5 22 6 6 7 7 23 6 2 2 3 3 4 4 24 2 2 3 3 4 4 25 6 2 2 3 3 4 4 26 2 2 3 3 27 6 4 4 5 5

More information

( ) ? () 1.1 ( 3 ) j x j 10 j 1 10 j = 1,..., 10 x 1 + x x 10 =

( ) ? () 1.1 ( 3 ) j x j 10 j 1 10 j = 1,..., 10 x 1 + x x 10 = 5 1! (Linear Programming, LP) LP OR LP 1.1 1.1.1 1. 2. 3. 4. 5. ( ) ( ) 1.1 6 1 1.1 ( ) 1 110 2 98 3 85 4 90 5 73 6 62 7 92 8 88 9 79 10 75 1.1.2 4? 900 40 80 120 () 1.1 ( 3 ) j x j 10 j 1 10 j = 1,...,

More information

1 23G 2 1 2 3 4 5 6 7 3 a a b c a 4 1 18G 18G 6 6 3 30 34 2 23G 48 23G 1 25 45 5 20 145mm 20 26 0.6 1.000 0.7 1.000mm a b c a 20 b c 24 28 a c d 3 60 70 / a RC 5 15 b 1 3 c 0.5 1 4 6 5 a 5 1 b a b a d

More information

Excelを使ったAHPの計算方法

Excelを使ったAHPの計算方法 Excel 入門 ( その 3) 23 24 (a) (b) (c) (d) 1 Excel 23 Excel Excel Enter 1 2 Tab 1 Enter 2 AHP n n F2 =B2*C2*D2*E2 25 2 4 30 4 4 30 4 1 30 30 4 1 Excel G2 =F2^(1/4)^Excel 26 1 3 Excel F2 G2 G2 3 1 4 3 4 3 27

More information

untitled

untitled 20 20 6 30 18 30 20 30 1 1 1 2 3 10 2 2 2 22 6 29 2 7 1 2 11 3 21 2 4 6 3 5 9 6 22 2 2 6 7 2 1 16 10 1 16 10 10 2 4 3 3 A4 3 1 2 3 1 55 8 4 63 11 4 8 8 4 8 12 2 17 11 4 4 4 8 12 3 5 4 8 4 12 5 5 6 19 2

More information

account4-1.PDF

account4-1.PDF 12 8 23 13 1 1 2 4 13 TEL 1 13 1 12 2 1 12 4 30 13 1 1 2 13 1 1 Office 13 1 1 13 1 1 1 12 2 1 12 4 30 99 3 office 3.1 4 office 426 147 85 3 6 12 2 1 13 1 31 office 5 2 3 4 5 6 7 8 12 2 1 12 4 30 11 8 1

More information

3.ごみの減量方法.PDF

3.ごみの減量方法.PDF - 7 - - 8 - - 9 - - 10 - - 11 - - 12 - ( 100 ( 100 - 13-123,550,846 111,195,762 92,663,135 ( 12 25 37 49.2 16 33 49 65.6 15 30 44 59.0 2.5kg) ( 5kg) ( 7.5kg) ( k ( 123,550,846 111,195,762 92,663,135 (

More information

16 41 17 22 12 10

16 41 17 22 12 10 1914 11 1897 99 16 41 17 22 12 10 11 10 18 11 2618 12 22 28 15 1912 13 191516 2,930 1914 5,100 43 1.25 11 14 25 34364511 7.54 191420 434849 72 191536 1739 17 1918 1915 60 1913 70 10 10 10 99.5 1898 19034.17.6

More information

製品案内 価格表 2014/4/1

製品案内 価格表 2014/4/1 4 (17) 3 43 5/20370/ 231(504,150) 11 12 10 14-16 10 3 100 17 100kg 5-6 3 13 3 18 18 # # # # #$$ %&$ ' ()* +,-% ' #). +,-%'% / ' # # #$ %&&&'( %)* +'(#$ #$ %&&&'( ++,-). +'(#$ #$ /'( + /0)- +'(#$ %&&&'(

More information

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 ( ) MS-Excel 1 MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 MS-Excel : [Ctrl+s] [Office ] [ ] : [F12] [Office ] [ ] : 3

More information

106 4 4.1 1 25.1 25.4 20.4 17.9 21.2 23.1 26.2 1 24 12 14 18 36 42 24 10 5 15 120 30 15 20 10 25 35 20 18 30 12 4.1 7 min. z = 602.5x 1 + 305.0x 2 + 2

106 4 4.1 1 25.1 25.4 20.4 17.9 21.2 23.1 26.2 1 24 12 14 18 36 42 24 10 5 15 120 30 15 20 10 25 35 20 18 30 12 4.1 7 min. z = 602.5x 1 + 305.0x 2 + 2 105 4 0 1? 1 LP 0 1 4.1 4.1.1 (intger programming problem) 1 0.5 x 1 = 447.7 448 / / 2 1.1.2 1. 2. 1000 3. 40 4. 20 106 4 4.1 1 25.1 25.4 20.4 17.9 21.2 23.1 26.2 1 24 12 14 18 36 42 24 10 5 15 120 30

More information

PowerPoint 2002

PowerPoint 2002 5.1.1 [ ] [ ] 5 1 5.1.2 [ ] 5 2 5.1.3 [ ] [ ] 5 3 5.1.4 [ ] [ ] [ ] 5 4 5.2.1 [ ] [ ] [ ] [ ] [ ] [] [OK] 5 5 5.2.2 [ ] [ ] [ ] [ ] [ ] [] [ ] [ ] [OK] [OK] 5 6 5.2.3 3-D 3-D [ ] [3-D] 3D 5 7 5.2.4 [Ctrl]

More information

untitled

untitled 186 17 100160250 1 10.1 55 2 18.5 6.9 100 38 17 3.2 17 8.4 45 3.9 53 1.6 22 7.3 100 2.3 31 3.4 47 OR OR 3 1.20.76 63.4 2.16 4 38,937101,118 17 17 17 5 1,765 1,424 854 794 108 839 628 173 389 339 57 6 18613

More information

untitled

untitled 1. 3 14 2. 1 12 9 7.1 3. 5 10 17 8 5500 4. 6 11 5. 1 12 101977 1 21 45.31982.9.4 79.71996 / 1997 89.21983 41.01902 6. 7 5 10 2004 30 16.8 37.5 3.3 2004 10.0 7.5 37.0 2004 8. 2 7 9. 6 11 46 37 25 55 10.

More information

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2

MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 ( ) MS-Excel 1 MS-Excel : [ ] [ ] [Applications] [Excel2007] : [Office ] [Excel ] [ ] : [Ctrl+n] [Office ] [ ] : [Ctrl+o] [Office ] [ ] ( ) 2 MS-Excel : [Ctrl+s] [Office ] [ ] : [F12] [Office ] [ ] : 3

More information

O157 6/23 7/4 6 25 1000 117,050 6 14:00~15:30 1 2 22 22 14:30~15:30 8 12 1 5 20 6 20 10 11 30 9 10 6 1 30 6 6 0 30 6 19 0 3 27 6 20 0 50 1 2 6 4 61 1 6 5 1 2 1 2 6 19 6 4 15 6 1 6 30 6 24 30 59

More information

PSCHG000.PS

PSCHG000.PS a b c a ac bc ab bc a b c a c a b bc a b c a ac bc ab bc a b c a ac bc ab bc a b c a ac bc ab bc de df d d d d df d d d d d d d a a b c a b b a b c a b c b a a a a b a b a

More information

PowerPoint プレゼンテーション

PowerPoint プレゼンテーション -1- -2- HTML HTML HTML 10 10 1 100 1 200 -3- Web Web -4-1. CGI URL 2. 3. OK 4. -5- ------------------------------------------------------------- - 1. 2. 3. 4. 5. -------------------------------------------------------------

More information

Excel 2007 Excel 2007 Excel 2007

Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel 2007 Excel Excel Excel Book1 Sheet1 Excel Excel Excel 2002OSWindows XP Excel Excel Excel Excel Office Excel Excel Excel Excel Excel A A5 CtrlC B3 B3 B3 B3 Excel A1

More information

3 65 1 4 5 67 1 2 5 5 3 6 68 23 69 2 6 8m 10m 1. 2. 3. 70 66 600km 11 3 16 21 3 0 3m 2m 0 5m 71 11 3 17 0 5 0 0 72 73 74 75 3 76 77 4 78 79 5 80 81 82 83 2 83 . 84 6 a b c d e f g a b c 3 85 16 86 87 7

More information

Excel基礎講座演習-表紙とはじめにv1.3.doc

Excel基礎講座演習-表紙とはじめにv1.3.doc Future Lifestyle Inc. IT Microsoft Excel 2000 Microsoft Microsoft Corporation B4 11 14 1999 1 C4 E7 C4 E7 2 =C4+D4+E4 SUM MAX MIN B3 F7 Sheet2 1999 2000 3 B3 F7 C4 F7 Delete C4 F7 SUM SUM() C4 SUM 4 B3

More information

Excel97関数編

Excel97関数編 Excel97 SUM Microsoft Excel 97... 1... 1... 1... 2... 3... 3... 4... 5... 6... 6... 7 SUM... 8... 11 Microsoft Excel 97 AVERAGE MIN MAX SUM IF 2 RANK TODAY ROUND COUNT INT VLOOKUP 1/15 Excel A B C A B

More information

untitled

untitled Mail de ECO Standard ...1 EXCEL...2...3 EXCEL...4...11...13...15...17...18 EXCEL OK 1 EXCEL EXCEL MailDeEco No 1 15 2 15 3 15 PDF 4 50 PDF PDF 2 EXCEL OK 3 4 No 1 CSV CSV 2 CSV 3 4 5 CSV CSV CSV 5 ( )

More information

3 9 3 100 2 10 30 12 1 1 2 2 4 3 9 1 250-1- 3 12 2 2 4 2 16 2-2- -3-8 2 6 10 30 11 30 11 2,500 9 2 2 10-4- 2005 2005 5 50-5- 3 30 FM 43 18 23 730 1700 17 11 3 FM 2 1800 30 3 400 1 1 28 3 4 18.1.28-6- 1

More information

AHPを用いた大相撲の新しい番付編成

AHPを用いた大相撲の新しい番付編成 5304050 2008/2/15 1 2008/2/15 2 42 2008/2/15 3 2008/2/15 4 195 2008/2/15 5 2008/2/15 6 i j ij >1 ij ij1/>1 i j i 1 ji 1/ j ij 2008/2/15 7 1 =2.01/=0.5 =1.51/=0.67 2008/2/15 8 1 2008/2/15 9 () u ) i i i

More information

untitled

untitled Excel A D-2 B-2 D-2 B2 C-2 D-2 C2-23 - Enter D-2 B2(1000) C2(5) 5000 D-2 (D-2) (D-2) (D-3) (D-6) - 24 - (D-3) (D-6) D (D-2) =B2*C2 (D-3) =B3*C3 (D-4) =B4*C4 Excel - 25 - $A$1 1000 A-1 (B-1) =$A$1 (B-1)

More information

1 (1) vs. (2) (2) (a)(c) (a) (b) (c) 31 2 (a) (b) (c) LENCHAR

1 (1) vs. (2) (2) (a)(c) (a) (b) (c) 31 2 (a) (b) (c) LENCHAR () 601 1 () 265 OK 36.11.16 20 604 266 601 30.4.5 (1) 91621 3037 (2) 20-12.2 20-13 (3) ex. 2540-64 - LENCHAR 1 (1) vs. (2) (2) 605 50.2.13 41.4.27 10 10 40.3.17 (a)(c) 2 1 10 (a) (b) (c) 31 2 (a) (b) (c)

More information

年計グラフ作成システム

年計グラフ作成システム 2003/01/20 2.00 1/29 2003/01/20...2...3...4...5...7...9... 11...13...15...16...17...18...19...20...21...23...24...26...27 FAQ...29 2/29 2003/01/20 Microsoft Access 2000 Microsoft Excel 3/29 2003/01/20

More information

untitled

untitled Microsoft Excel 1. 2. 3. 4. VBA) A IV 256 BMI (Body Mass Index) AVERAGE,COUNTIF BMI ( kg ) = 22 ( m) 2 BMI (Body Mass Index) BMI = ( kg ( m ) ) 2 BMI BMI 20 BMI 20 24 BMI 24 26.5 BMI 26.5 E1 kg Del Back

More information

Microsoft Word - 倫理 第40,43,45,46講 テキスト.docx

Microsoft Word - 倫理 第40,43,45,46講 テキスト.docx 6 538 ( 552 ) (1) () (2) () ( )( ) 1 vs () (1) (2) () () () ) ()() (3) () ( () 2 () () () ()( ) () (7) (8) () 3 4 5 abc b c 6 a (a) b b ()() 7 c (c) ()() 8 9 10 () 1 ()()() 2 () 3 1 1052 1051 () 1053 11

More information

1 1 ( ) ( 1.1 1.1.1 60% mm 100 100 60 60% 1.1.2 A B A B A 1

1 1 ( ) ( 1.1 1.1.1 60% mm 100 100 60 60% 1.1.2 A B A B A 1 1 21 10 5 1 E-mail: qliu@res.otaru-uc.ac.jp 1 1 ( ) ( 1.1 1.1.1 60% mm 100 100 60 60% 1.1.2 A B A B A 1 B 1.1.3 boy W ID 1 2 3 DI DII DIII OL OL 1.1.4 2 1.1.5 1.1.6 1.1.7 1.1.8 1.2 1.2.1 1. 2. 3 1.2.2

More information

4 1 2 34 56 1

4 1 2 34 56 1 2016 8 2 2 4 1 2 34 56 1 3 2 4 2 78 910 2 1 3 10,000 A 100 A 9,900 9,900 A 100 100 POINT! 4 2 2 2 5 2100 100 3 50 5050100 POINT! 6 3 2 7 ABC 2 10010,0001100 2 100 2 5,000 1 50 32 16,000 13,000 10,000 7,000

More information

2002.N.x.h.L.......g9/20

2002.N.x.h.L.......g9/20 1 2 3 4 5 6 1 2 3 4 5 8 9 1 11 11 12 13 k 14 l 16 m 17 n 18 o 19 k 2 l 2 m 21 n 21 o 22 p 23 q 23 r 24 24 25 26 27 28 k 28 l 29 m 29 3 31 34 42 44 1, 8, 6, 4, 2, 1,2 1, 8 6 4 2 1, 8, 6, 4, 2, 1,2 1, 8

More information

4 4. A p X A 1 X X A 1 A 4.3 X p X p X S(X) = E ((X p) ) X = X E(X) = E(X) p p 4.3p < p < 1 X X p f(i) = P (X = i) = p(1 p) i 1, i = 1,,... 1 + r + r

4 4. A p X A 1 X X A 1 A 4.3 X p X p X S(X) = E ((X p) ) X = X E(X) = E(X) p p 4.3p < p < 1 X X p f(i) = P (X = i) = p(1 p) i 1, i = 1,,... 1 + r + r 4 1 4 4.1 X P (X = 1) =.4, P (X = ) =.3, P (X = 1) =., P (X = ) =.1 E(X) = 1.4 +.3 + 1. +.1 = 4. X Y = X P (X = ) = P (X = 1) = P (X = ) = P (X = 1) = P (X = ) =. Y P (Y = ) = P (X = ) =., P (Y = 1) =

More information

OR#5.key

OR#5.key オペレーションズ リサーチ1 Operations Research 前学期 月曜 3限(3:00-4:30) 8 整数計画モデル Integer Programming 経営A棟106教室 山本芳嗣 筑波大学 大学院 システム情報工学研究科 整数計画問題 2 凸包 最小の凸集合 線形計画問題 変数の整数条件 ctx Ax b x 0 xj は整数 IP LP 3 4 Bx d!!!!!? P NP

More information

( 2 / 35

( 2 / 35 Office 1 / 35 ( 2 / 35 3 / 35 ( 4 / 35 ( 5 / 35 6 / 35 =SUMPRODUCT((C$3:C$42>=$A46)(C$3:C$42

More information

untitled

untitled 1 BASIC (Beginner s All-purpose Symbolic Instruction Code) EXCEL BASIC EXCEL EXCEL VBA (Visual Basic for Applications) 2 3 1.1 Excel Excel Excel Check Point 1. 2. 1.1.1 Sheet1 A Sheet2 Sheet A A10 4 1

More information

02

02 54 163116831 02 1 168 54 158 53 162 53 148 52 152 52 10,000 0 40,000 30,000 20,000 50,000 70,000 60,000 1,000 500 1,500 2,000 0 2,500 3,000 4,000 3,500 4,500 168 54 158 53 162 53 148 52 152 52 03 52148

More information

2 / 29

2 / 29 Office 1 / 29 2 / 29 3 / 29 4 / 29 5 / 29 6 / 29 7 / 29 8 / 29 9 / 29 10 / 29 11 / 29 12 / 29 A 13 / 29 14 / 29 15 / 29 16 / 29 17 / 29 (R) 18 / 29 CD 19 / 29 20 / 29 21 / 29 22 / 29 23 / 29 24 / 29 25

More information

6 12 10661 93100 227213202 222208197 85kg cm 20 64.521 106856142 2 1 4 3 9767 100 35 cm 7747 208198 90kg 23 5828 10661 93100 cm 227213202 10639 61 64.521 85kg 78kg 70kg 61 100 197204.5 cm 15 61

More information

<82D282A982C1746F95F18D908F57967B95B E696E6464>

<82D282A982C1746F95F18D908F57967B95B E696E6464> 1 2 (90cm 70cm 2015) 3 (68cm 28cm 30cm 12kg 2015) (77.5 109.5cm 2015) 4 (22cm 50cm 50cm 4.6kg 2015) (45cm 62.5cm 2015) (47.4cm 62.5cm 2014) 5 (28.5cm 23.5cm) (45cm 62cm 2015) (97cm 107cm 2015) 6 7 8 9

More information

 

  10 44 1.2 5 4 5 3 6-1 - 1 2 3 4 5 1 2 3 4 5 6 7 8 1 2 3 4 5 6 7 8 9 10 TEL TEL 1 2 TEL FAX TEL FAX TEL FAX 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 1 2 3 4 5 6 ( ) ( ) 2

More information

p64大倉.pdf

p64大倉.pdf Web Web 1 17 GP 19 2 GP 2 18 GP 17 Web 17 2007 18 4 2. 1 1 GP OK 2 3 4GP 5 2. 2 1 4 2 3 2. 3 1 2GP 3 2. 4 19 GP GP GP PC GP or or Web 2007 1 3 1 LAN 2 CDDVD 3 3 3. 1 17 18 19 50 3. 2 2 3. 3 Web 4 2 2 3.

More information

180 140 22

180 140 22 21 180 140 22 23 25 50 1 3 350 140 500cm 600 140 24 25 26 27 28 29 30 31 1/12 8.3 1/15 6.7 10 1/8 12.5 1/20 140 90 75 150 60 150 10 30 15 35 2,000 30 32 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 % 100 50 33.3

More information

Excel基礎講座テキスト-表紙と目次v1.3.doc

Excel基礎講座テキスト-表紙と目次v1.3.doc Future Lifestyle Inc. IT Microsoft Excel 2000 Microsoft Microsoft Corporation < > Excel Excel Microsoft Excel = 11 11 1 G11 1 < > Excel Word Excel Sheet1Sheet2Sheet3 OK Sheet2 Sheet3 2 Word Excel Book1.

More information

23 3 11 14 46 9.0 7 10m 40.1m 15,883 2,681 25 4 10 39 40 800 180 24 2425 22 21 24 5 3 21 24 10,899 20,472 13,723 33,007 667 400 79,167 8,620 11,694 10,089 25,131 690 215 56,439 13,614 20,897 15,200 32,213

More information

株主通信:第16期 中間報告書

株主通信:第16期 中間報告書 9 1 20,000 15,000 10,000 5,000 2007/4 2008/4 2009/4 2010/4 2011/4 2012/4 2013/4 01 02 2 3 03 04 4 05 06 5 133,362 206,945 344,360 363,936 67,583 128,114 819 18,583 412,477 846,445 164,935 422,265 1,433,645

More information

P15 P211 1 P1 P4 P2 P3 P4 P17

P15 P211 1 P1 P4 P2 P3 P4 P17 P15 P211 1 P1 P4 P2 P3 P4 P17 P3 P4 P7 P8 P9 2 1 Q A P17 P17 1 2 3 4 3 5 6 7 8 2 P17 Q A P17 4 1 2 3 4 2 P17 P4 P12 P17 P4 5 5 6 7 8 2 P4 P4 6 1 2 3 4 3 P17 P10 P17 7 5 6 7 8 4 0120-096-991 P17 8 1 2 3

More information

t Z

t Z t Z 1 11 1 1 1 1 1 1 1 1 1 1 1 1 UU 1 as a s 1 1 1 1 1 1 G q w e r q q w e r a s 1 1 1 1 1 1 1 a s a gg g q w e r 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1

More information

2 / 43

2 / 43 Office 1 / 43 2 / 43 Access2003 3 / 43 Access2003 1 9 Access2003 4 / 43 5 / 43 6 / 43 7 / 43 8 / 43 9 / 43 10 / 43 11 / 43 12 / 43 13 / 43 14 / 43 15 / 43 16 / 43 17 / 43 18 / 43 19 / 43 20 / 43 21 / 43

More information

/ 2 ( ) ( ) ( ) = R ( ) ( ) 1 1 1/ 3 = 3 2 2/ R :. (topology)

/ 2 ( ) ( ) ( ) = R ( ) ( ) 1 1 1/ 3 = 3 2 2/ R :. (topology) 3 1 3.1. (set) x X x X x X 2. (space) Hilbert Teichmüller 2 R 2 1 2 1 / 2 ( ) ( ) ( ) 1 0 1 + = R 2 0 1 1 ( ) ( ) 1 1 1/ 3 = 3 2 2/ R 2 3 3.1:. (topology) 3.2 30 3 3 2 / 3 3.2.1 S O S (O1)-(O3) (O1) S

More information