Задание 2 от 7 апреля 2023 на всю неделю вперед - процедура такая же как и в задании 1
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1251">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=Edit-Time-Data href="ЗАДАЧА_РЕФРАКЦИЯ_МЕХАНИКА.files/editdata.mso">
<link rel=OLE-Object-Data href="ЗАДАЧА_РЕФРАКЦИЯ_МЕХАНИКА.files/oledata.mso">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>ЛЮТОВ</o:Author>
<o:LastAuthor>ЛЮТОВ</o:LastAuthor>
<o:Created>2023-04-06T05:30:44Z</o:Created>
<o:LastSaved>2023-04-06T07:11:10Z</o:LastSaved>
<o:Company>НГИА</o:Company>
<o:Version>11.9999</o:Version>
</o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\,";
mso-displayed-thousand-separator:" ";}
@page
{margin:.98in .79in .98in .79in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
.font0
{color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font1
{color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font6
{color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font7
{color:red;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font8
{color:red;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font9
{color:blue;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font10
{color:blue;
font-size:10.0pt;
font-weight:700;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font11
{color:blue;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font12
{color:#993366;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font13
{color:windowtext;
font-size:9.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
.font14
{color:red;
font-size:9.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;
border:none;
mso-protection:locked visible;
mso-style-name:Обычный;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:"Arial Cyr";
mso-generic-font-family:auto;
mso-font-charset:204;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
border:none;
mso-background-source:auto;
mso-pattern:auto;
mso-protection:locked visible;
white-space:nowrap;
mso-rotate:0;}
.xl24
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;}
.xl25
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;}
.xl26
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl27
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
white-space:normal;}
.xl28
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
white-space:normal;}
.xl29
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#FFFF99;
mso-pattern:auto none;
white-space:normal;}
.xl30
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#FFFF99;
mso-pattern:auto none;
white-space:normal;}
.xl31
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#FFFF99;
mso-pattern:auto none;
white-space:normal;}
.xl32
{mso-style-parent:style0;
text-align:center;
border:1.0pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl33
{mso-style-parent:style0;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl34
{mso-style-parent:style0;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#CCFFCC;
mso-pattern:auto none;}
.xl35
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl36
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#CCFFCC;
mso-pattern:auto none;}
.xl37
{mso-style-parent:style0;
color:blue;
font-weight:700;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#FFFF99;
mso-pattern:auto none;}
.xl38
{mso-style-parent:style0;
color:blue;
font-weight:700;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#FFFF99;
mso-pattern:auto none;}
.xl39
{mso-style-parent:style0;
color:blue;
font-weight:700;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#FFFF99;
mso-pattern:auto none;}
.xl40
{mso-style-parent:style0;
color:red;
text-align:center;
border:1.0pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl41
{mso-style-parent:style0;
color:blue;
text-align:center;
border:1.0pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl42
{mso-style-parent:style0;
color:#993366;
text-align:center;
border:1.0pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl43
{mso-style-parent:style0;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;}
.xl44
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;}
.xl45
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;}
.xl46
{mso-style-parent:style0;
text-align:center;
border-top:none;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;}
.xl47
{mso-style-parent:style0;
font-size:9.0pt;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:none;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl48
{mso-style-parent:style0;
font-size:9.0pt;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl49
{mso-style-parent:style0;
font-size:9.0pt;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:none;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl50
{mso-style-parent:style0;
font-size:9.0pt;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:none;
border-left:none;
white-space:normal;}
.xl51
{mso-style-parent:style0;
font-size:9.0pt;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
white-space:normal;}
.xl52
{mso-style-parent:style0;
font-size:9.0pt;
text-align:center;
vertical-align:middle;
border-top:none;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
white-space:normal;}
.xl53
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#CCFFFF;
mso-pattern:auto none;
white-space:normal;}
.xl54
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#CCFFFF;
mso-pattern:auto none;
white-space:normal;}
.xl55
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
vertical-align:middle;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#CCFFFF;
mso-pattern:auto none;
white-space:normal;}
.xl56
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:1.0pt solid windowtext;
background:#CCFFFF;
mso-pattern:auto none;
white-space:normal;}
.xl57
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:none;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#CCFFFF;
mso-pattern:auto none;
white-space:normal;}
.xl58
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
border-top:1.0pt solid windowtext;
border-right:1.0pt solid windowtext;
border-bottom:1.0pt solid windowtext;
border-left:none;
background:#CCFFFF;
mso-pattern:auto none;
white-space:normal;}
.xl59
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
vertical-align:middle;
border:1.0pt solid windowtext;
background:yellow;
mso-pattern:auto none;}
.xl60
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
border:1.0pt solid windowtext;
background:#CCFFCC;
mso-pattern:auto none;}
.xl61
{mso-style-parent:style0;
color:white;
font-weight:700;
text-align:center;
border:1.0pt solid windowtext;
background:#993366;
mso-pattern:auto none;}
.xl62
{mso-style-parent:style0;
color:red;
font-weight:700;
text-align:center;
border:1.0pt solid windowtext;
background:yellow;
mso-pattern:auto none;}
.xl63
{mso-style-parent:style0;
color:white;
font-weight:700;
text-align:center;
vertical-align:middle;
border:1.0pt solid windowtext;
background:#993366;
mso-pattern:auto none;}
.xl64
{mso-style-parent:style0;
background:#993366;
mso-pattern:auto none;}
.xl65
{mso-style-parent:style0;
border-top:none;
border-right:none;
border-bottom:none;
border-left:1.0pt solid windowtext;
background:#993366;
mso-pattern:auto none;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Лист1</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>600</x:HorizontalResolution>
<x:VerticalResolution>600</x:VerticalResolution>
</x:Print>
<x:Zoom>160</x:Zoom>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveCol>8</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>8760</x:WindowHeight>
<x:WindowWidth>16275</x:WindowWidth>
<x:WindowTopX>120</x:WindowTopX>
<x:WindowTopY>75</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple>
<table x:str border=0 cellpadding=0 cellspacing=0 width=449 style='border-collapse:
collapse;table-layout:fixed;width:337pt'>
<col width=77 style='mso-width-source:userset;mso-width-alt:2816;width:58pt'>
<col width=64 span=2 style='width:48pt'>
<col width=68 style='mso-width-source:userset;mso-width-alt:2486;width:51pt'>
<col width=64 style='width:48pt'>
<col width=83 style='mso-width-source:userset;mso-width-alt:3035;width:62pt'>
<col width=29 style='mso-width-source:userset;mso-width-alt:1060;width:22pt'>
<tr height=57 style='mso-height-source:userset;height:42.75pt'>
<td colspan=6 height=57 class=xl29 width=420 style='border-right:1.0pt solid black;
height:42.75pt;width:315pt'>Задача. В какую точку В (<font class="font8">X</font><font
class="font0">=А</font><font class="font6"><sub>1</sub></font><font
class="font0">В=?) следует бежать, чтобы затем достигнуть точки С - финиша за
оптимальное -</font><font class="font7"> минимальное время</font><font
class="font0">?</font></td>
<td rowspan=10 class=xl65 width=29 style='width:22pt'> </td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl32 style='height:16.5pt;border-top:none'>А А<font
class="font6"><sub>1</sub></font><font class="font0">= (м)</font></td>
<td class=xl40 style='border-top:none;border-left:none' x:num>4</td>
<td colspan=2 class=xl33 style='border-right:1.0pt solid black;border-left:
none'>Скорость бега (м/с)</td>
<td colspan=2 class=xl33 style='border-right:1.0pt solid black;border-left:
none'>Скорость плыть (м/с)</td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl32 style='height:16.5pt;border-top:none'>А<font
class="font6"><sub>1</sub></font><font class="font0"> А</font><font
class="font6"><sub>2</sub></font><font class="font0">= (м)</font></td>
<td class=xl42 style='border-top:none;border-left:none' x:num>2</td>
<td colspan=2 class=xl35 style='border-right:1.0pt solid black;border-left:
none' x:num>10</td>
<td colspan=2 class=xl35 style='border-right:1.0pt solid black;border-left:
none' x:num>3</td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl32 style='height:16.5pt;border-top:none'>А<font
class="font6"><sub>2</sub></font><font class="font0">С= (м)</font></td>
<td class=xl41 style='border-top:none;border-left:none' x:num>8</td>
<td class=xl60 style='border-top:none;border-left:none'>Vб/Vп =</td>
<td class=xl61 style='border-top:none;border-left:none'
x:num="3.3333333333333335" x:fmla="=C3/E3">3,3333333</td>
<td class=xl60 style='border-top:none;border-left:none'>X =</td>
<td class=xl62 style='border-top:none;border-left:none' x:num="6.85">6,85</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td colspan=6 height=20 class=xl37 style='border-right:1.0pt solid black;
height:15.0pt'>Используем смысл n<font class="font10"><sub> 21</sub></font><font
class="font9"> = Sin(альфа)/Sin(бета) =Vб/Vп</font></td>
</tr>
<tr height=29 style='mso-height-source:userset;height:21.95pt'>
<td colspan=2 rowspan=3 height=87 class=xl47 width=141 style='border-right:
1.0pt solid black;border-bottom:1.0pt solid black;height:65.85pt;width:106pt'>В
соответствии с геометрическими формулами<span style='mso-spacerun:yes'>
</span>вычисляем в ячейке<font class="font14"> F8</font><font class="font13">
Sin(альфа)/Sin(бета)</font></td>
<td colspan=2 class=xl44 style='border-right:1.0pt solid black'>Sin(альфа) =</td>
<td colspan=2 class=xl46 style='border-right:1.0pt solid black;border-left:
none'>Х/(Х^2+<font class="font7">4</font><font class="font0">^2)^0,5</font></td>
</tr>
<tr height=29 style='mso-height-source:userset;height:21.95pt'>
<td colspan=2 height=29 class=xl43 style='border-right:1.0pt solid black;
height:21.95pt'>Sin(бета) =</td>
<td colspan=2 class=xl24 style='border-right:1.0pt solid black;border-left:
none'>(<font class="font11">8</font><font class="font0">-X)/((</font><font
class="font11">8</font><font class="font0">-X)^2+</font><font class="font12">2</font><font
class="font0">^2)^0,5</font></td>
</tr>
<tr height=29 style='mso-height-source:userset;height:21.95pt'>
<td colspan=3 height=29 class=xl26 width=196 style='border-right:1.0pt solid black;
height:21.95pt;border-left:none;width:147pt'>Sin(альфа)/Sin(бета) =</td>
<td class=xl63 style='border-top:none;border-left:none'
x:num="0.32548569886697115"
x:fmla="=F4/(F4^2+B2^2)^0.5/(8-F4)/((8-F4)^2+B3^2)^0.5">0,325485699</td>
</tr>
<tr height=35 style='mso-height-source:userset;height:26.25pt'>
<td colspan=6 height=35 class=xl53 width=420 style='border-right:1.0pt solid black;
height:26.25pt;width:315pt'>Варьируя значения Х<span
style='mso-spacerun:yes'> </span>в ячейке F4 приходим к решению задачи!</td>
</tr>
<tr height=39 style='mso-height-source:userset;height:29.25pt'>
<td colspan=5 height=39 class=xl56 width=337 style='border-right:1.0pt solid black;
height:29.25pt;width:253pt'>Далее в ячейке F10 найдите и время достижения
точки С</td>
<td class=xl59 style='border-top:none;border-left:none'>???</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td colspan=7 height=17 class=xl64 style='height:12.75pt'> </td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=77 style='width:58pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=68 style='width:51pt'></td>
<td width=64 style='width:48pt'></td>
<td width=83 style='width:62pt'></td>
<td width=29 style='width:22pt'></td>
</tr>
<![endif]>
</table>
</body>
</html>