Advertisement
Guest User

Untitled

a guest
May 2nd, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Function AngleC(Bangle, b, C)
  2.     AngleC = Application.Asin((C * Math.Sin(Bangle)) / b) 'Âû÷èñëåíèå óãëà C
  3. End Function
  4. Function AngleA(b, C)
  5.     AngleA = WorksheetFunction.Pi - (b + C) 'Âû÷èñëåíèå óãëà À
  6. End Function
  7.  
  8. Function Astrih(b, Cs)
  9.     Astrih = WorksheetFunction.Pi - (b + Cs)
  10. End Function
  11.  
  12. Function Sidea(A, Bangle, b)
  13.     Sidea = ((b * (Math.Sin(A)) / Math.Sin(Bangle))) 'Âû÷èñëåíèå ñòîðîíû à
  14. End Function
  15. Function Areas(A, C, b)
  16.     Areas = ((A * C * Math.Sin(b)) / 2) 'Âû÷èñëåíèå ïëîùàäè ò-êà
  17. End Function
  18.  
  19. Function Cshtrih(C)
  20.     Cshtrih = WorksheetFunction.Pi - C
  21. End Function
  22.  
  23. Function AmaloeShtrih(b, Astrih, Bangle)
  24.     AmaloeShtrih = (b * Math.Sin(Astrih)) / Math.Sin(Bangle)
  25. End Function
  26.  
  27. Function Sshtrih(AmaloeShtrih, Cmaloe, Bangle)
  28.     Sshtrih = (AmaloeShtrih * Cmaloe * Math.Sin(Bangle)) / 2
  29. End Function
  30.  
  31. Sub Rezult() 'Ïðîöåäóðà äëÿ âûâîäà ðåçóëüòàòîâ
  32. Dim A, b, C, AngleB, AngleC, AngleA, S As Single
  33. Const Pi = 3.14
  34. b = 2: C = 2.5: AngleB = WorksheetFunction.Pi / 4
  35.     AngleC = Application.Asin((C * Sin(AngleB)) / b)
  36.     MsgBox ("AngleC= " & AngleC) 'Âûâîä óãëà Ñ âî âñïëûâàþùåì îêíå
  37.    AngleA = Pi - (AngleB + AngleC)
  38.     MsgBox ("AngleA= " & AngleA) 'Âûâîä óãëà À âî âñïëûâàþùåì îêíå
  39.    A = ((b * Sin(AngleA)) / Sin(AngleB))
  40.     MsgBox ("side a= " & A) 'Âûâîä ñòîðîíû à âî âñïëûâàþùåì îêíå
  41.  
  42.     S = ((A * C * Sin(AngleB)) / 2)
  43.      MsgBox ("S= " & S) 'Âûâîä ïëîùàäè âî ñïëûâàþùåì îêíå
  44.  
  45.     MsgBox ("AngleC in degrees= " & (AngleC * 180) / 3.141) 'Âûâîä óãëà Ñ â ãðàäóñàõ
  46.    MsgBox ("AngleA in degrees= " & (AngleA * 180) / 3.141) 'Âûâîä óãëà A â ãðàäóñàõ
  47. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement