Π‘ΠΈΠ±ΠΈΡΡΠΊΠ°Ρ Π Π΅Π³ΠΈΠΎΠ½Π°Π»ΡΠ½Π°Ρ ΡΠΊΠΎΠ»Π° Π±ΠΈΠ·Π½Π΅ΡΠ° ΠΠΎΠ½ΡΡΠΎΠ»ΡΠ½Π°Ρ ΡΠ°Π±ΠΎΡΠ°
Visual Basic for Application
1. Π‘ΡΠΎΡΠΌΠΈΡΠΎΠ²Π°ΡΡ ΠΌΠ°ΡΡΠΈΡΡ Π²ΠΈΠ΄Π°
ΠΡΡΠΈΡΠ»ΠΈΡΡ Π² ΡΡΠΎΠΉ ΠΌΠ°ΡΡΠΈΡΠ΅ ΡΡΠΌΠΌΡ ΡΠ΅ΡΠ½ΡΡ
ΡΠ»Π΅ΠΌΠ΅Π½ΡΠΎΠ².
ΠΡΡΠΈΡΠ»ΠΈΡΡ ΠΌΠ°ΠΊΡΠΈΠΌΡΠΌ ΠΈΠ· Π½Π΅ΡΠ΅ΡΠ½ΡΡ
ΡΠ»Π΅ΠΌΠ΅Π½ΡΠΎΠ² Π² ΠΊΠ°ΠΆΠ΄ΠΎΠΉ ΡΡΡΠΎΠΊΠ΅ ΠΌΠ°ΡΡΠΈΡΡ.
ΠΡΡΠΈΡΠ»ΠΈΡΡ ΠΏΡΠΎΠΈΠ·Π²Π΅Π΄Π΅Π½ΠΈΠ΅ ΡΠ»Π΅ΠΌΠ΅Π½ΡΠΎΠ² Π² Π½Π΅ΡΠ΅ΡΠ½ΡΡ
ΡΡΠΎΠ»Π±ΡΠ°Ρ
.
ΠΡΡΠΈΡΠ»ΠΈΡΡ ΠΊΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ΅ΡΠ½ΡΡ
ΡΠ»Π΅ΠΌΠ΅Π½ΡΠΎΠ² Π²ΡΡΠ΅ Π³Π»Π°Π²Π½ΠΎΠΉ Π΄ΠΈΠ°Π³ΠΎΠ½Π°Π»ΠΈ.
Π Π΅ΡΠ΅Π½ΠΈΠ΅ ΠΌΠ°ΡΡΠΈΡΠ° ΠΏΡΠΎΠ³ΡΠ°ΠΌΠΌΠ° visual basic
Option Explicit
Sub pr22()
Dim a (10, 10) As Integer
Dim n As Integer, i As Integer, j As Integer, s As Integer, max As Integer
Dim t As Integer, k As Integer, p As Integer
n = Val (InputBox («ΠΠ²Π΅Π΄ΠΈΡΠ΅ N»))
Range (Cells (1, 1), Cells (100, 100)).Select
Selection.Clear
For i = 1 To n
For j = 1 To n
If i + j = n + 1 Then a (i, j) = 1
If i = j Then a (i, j) = 1
If i < j And i + j < n + 1 Then a (i, j) = 3
If i < j And i + j > n + 1 Then a (i, j) = 2
If i > j And i + j > n + 1 Then a (i, j) = 3
If i > j And i + j < n + 1 Then a (i, j) = 2
Next j
Next i
Cells (1, 1) = «ΠΠΎΠ»ΡΡΠ΅Π½Π½Π°Ρ ΠΌΠ°ΡΡΠΈΡΠ°»
For i = 1 To n
For j = 1 To n
Cells (i + 1, j) = a (i, j)
Next j
Next i
s = 0
For i = 1 To n
For j = 1 To n
If a (i, j) Mod 2 = 0 Then
s = s + a (i, j)
End If
Next j
Next i
Cells (9, 1) = «Π‘ΡΠΌΠΌΠ° ΡΠ΅ΡΠ½ΡΡ
ΡΠ»Π΅ΠΌΠ΅Π½ΡΠΎΠ²=»: Cells (9, 4) = s
For i = 1 To n
max = -3200
If a (i, j) > max Then max = a (i, j)
For j = 1 To n
If a (i, j) Mod 2 <> 0 Then
If a (i, j) > max Then max = a (i, j)
Cells (11, 1) = «ΠΠ°ΠΊΡΠΈΠΌΡΠΌ ΠΈΠ· Π½Π΅ΡΠ΅ΡΠ½ΡΡ
ΡΠ»Π΅ΠΌΠ΅Π½ΡΠΎΠ² Π² ΠΊΠ°ΠΆΠ΄ΠΎΠΉ ΡΡΡΠΎΠΊΠ΅:»: Cells (11, i + 5) = max
End If
Next j
Next i
k=0
For i = 1 To n
For j = 1 To n
If a (i, j) Mod 2 = 0 Then
k = k + 1
End If
Next j
Next i
t = k / 2
Cells (16, 1) = «ΠΠΎΠ»ΠΈΡΠ΅ΡΡΠ²ΠΎ ΡΠ΅ΡΠ½ΡΡ
ΡΠ»Π΅ΠΌΠ΅Π½ΡΠΎΠ² Π²ΡΡΠ΅ Π³Π»Π°Π²Π½ΠΎΠΉ Π΄ΠΈΠ°Π³ΠΎΠ½Π°Π»ΠΈ =»: Cells (16, 7) = t
For j = 1 To n
p = 1
For i = 1 To n
If a (i, j) > 0 Then p = p * a (i, j)
Next i
Cells (13, 1) = «ΠΡΠΎΠΈΠ·Π²Π΅Π΄Π΅Π½ΠΈΠ΅ ΡΠ»Π΅ΠΌΠ΅Π½ΡΠΎΠ² Π² Π½Π΅ΡΠ΅ΡΠ½ΡΡ
ΡΡΠΎΠ»Π±ΡΠ°Ρ
:»: Cells (14, j) = p
j = j + 1
Next j
End Sub