Excel Visual Basic .
, , , .
, . Microsoft Office Excel .
' | ̳ | ||||||||||
73,3 | 0,25 | 1,3056E-13 | 5,370225 | 2,533125 | |||||||
. 3 | 2 | ||||||||||
³ | ' | ||||||||||
350584,5 | 0,575 | 0,076 | 0,0000122 | ||||||||
ح | Zmax | Zmin | ||||
-6 | -14,5 | ³ | 0,90786163 | 0,956538503 | -6 | |
-4 | -12,5 | ³ | Pmax p | Pmin p | -4 | |
-1 | -9,5 | ³ | 5,91524616 | 2,648220634 | -1 | |
-1,5 | ³ | V | V | |||
5,5 | 2277,89618 | 379,6493641 | ||||
9,5 | Ar | b | ||||
12,5 | 9,594E-12 | 23207,73875 | ||||
14,5 | ||||||
8,5 | ||||||
2,5 | ||||||
-4,5 | ³ | |||||
-2 | -10,5 | ³ | -2 | |||
8,5 | ʳ | -0,33 |
K | ||||
-0,667 | 632,749 | 1004,954 | 4,089555426 | 3,795306132 |
-0,431 | 543,420 | 461,535 | 3,310166983 | 3,114706253 |
-0,078 | 409,426 | 52,109 | 2,722956512 | 2,589292545 |
0,863 | 52,109 | 0,000 | 2,648220634 | 2,521622652 |
0,510 | 186,103 | 2091,794 | 5,648332313 | 5,102004175 |
-0,196 | 454,090 | 1637,703 | 4,997062518 | 4,564634968 |
0,00 |
|
|
Z | Q | ˳ (6.17) | (6.17) | г (-) | ʳ | |
0,928049 | 20,41126 | 7,082488 | 2,881933 | 2,891942626 | 0,010009 | |
0,940951 | 19,40785 | 8,342904 | 2,32627 | 2,337121431 | 0,010852 | |
0,950912 | 13,20728 | 7,056246 | 1,871715 | 1,881733964 | 0,010019 | |
0,952195 | 1,736958 | 1,05684 | 1,643539 | 1,653551728 | 0,010013 | |
0,903276 | 6,203421 | 1,661114 | 3,734495 | 3,744542023 | 0,010047 | |
0,913464 | 14,64808 | 4,240199 | 3,454573 | 3,464584253 | 0,010011 |
: | |||
' | |||
=73,3 | =0,25 | =128*1,02/1000000000000000 | =30 |
. 3 | 2 |
̳ | |||
=53*101325/1000000 | =25*101325/1000000 | =3,46*101325 | =304 |
³ | ' | |||
=0,575 | =872 | =0,076 | =1,22/10^5=101325/1000000 | =101325/ |
̳ | ح | ||
ѳ | =31 | =-6 | =C10-C23 |
=28 | =-4 | =C11-C23 | |
=31 | =-1 | =C12-C23 | |
=30 | =7 | =C13-C23 | |
=31 | =14 | =C14-C23 | |
=30 | =18 | =C15-C23 | |
=31 | =21 | =C16-C23 | |
=31 | =23 | =C17-C23 | |
=30 | =17 | =C18-C23 | |
=31 | =11 | =C19-C23 | |
=30 | =4 | =C20-C23 | |
=31 | =-2 | =C21-C23 | |
=(C10:C21) |
Zmax | ||
=(D10<0;"³";"") | =(D10<0;1;0) | =1-5,5*1000000*E3*$I$3^1,3/$H$3^3,3 |
=(D11<0;"³";"") | =(D11<0;1;0) | Pmax p |
=(D12<0;"³";"") | =(D12<0;1;0) | =E3/G10 |
=(D13<0;"³";"") | =(D13<0;1;0) | V |
=(D14<0;"³";"") | =(D14<0;1;0) | =A3*293*(G12-H12)/(H3*M3) |
=(D15<0;"³";"") | =(D15<0;1;0) | Ar |
=(D16<0;"³";"") | =(D16<0;1;0) | = (()*D3*C3)/(L3*M3*1000000*H3/293) |
=(D17<0;"³";"") | =(D17<0;1;0) | |
=(D18<0;"³";"") | =(D18<0;1;0) | |
=(D19<0;"³";"") | =(D19<0;1;0) | |
=(D20<0;"³";"") | =(D20<0;1;0) | |
=(D21<0;"³";"") | =(D21<0;1;0) | |
ʳ | =F10+F11+F12+F13+F20+F21 |
|
|
Zmin | K | |
=1-5,5*1000000*F3*$I$3^1,3/$H$3^3,3 | =(D10<0;C10;" ") | =(D10<0;(C10-$I$23)/$C$23;" ") |
Pmin p | =(D11<0;C11;" ") | =(D11<0;(C11-$I$23)/$C$23;" ") |
=F3/H10 | =(D12<0;C12;" ") | =(D12<0;(C12-$I$23)/$C$23;" ") |
V | =(D13<0;C13;" ") | =(D13<0;(C13-$I$23)/$C$23;" ") |
=G14/F23 | =(D14<0;C14;" ") | =(D14<0;(C14-$I$23)/$C$23;" ") |
b | =(D15<0;C15;" ") | =(D15<0;(C15-$I$23)/$C$23;" ") |
=(1/K3)*(A3*10^6/(D3*()*B3)) | =(D16<0;C16;" ") | =(D16<0;(C16-$I$23)/$C$23;" ") |
=(D17<0;C17;" ") | =(D17<0;(C17-$I$23)/$C$23;" ") | |
=(D18<0;C18;" ") | =(D18<0;(C18-$I$23)/$C$23;" ") | |
=(D19<0;C19;" ") | =(D19<0;(C19-$I$23)/$C$23;" ") | |
=(D20<0;C20;" ") | =(D20<0;(C20-$I$23)/$C$23;" ") | |
=(D21<0;C21;" ") | =(D21<0;(C21-$I$23)/$C$23;" ") | |
=(I10+I11+I12+I13+I20+I21)/6 | =(J10:J21) |
=(D10<0;$H$14*(1-J10);" ") | =L21-K10 | =(D10<0;$H$12+(L10*(M$3*$H$3/($A$3*293)));0) |
=(D11<0;$H$14*(1-J11);" ") | =L10-K11 | =(D11<0;$H$12+(L11*(M$3*$H$3/($A$3*293)));0) |
=(D12<0;$H$14*(1-J12);" ") | =L11-K12 | =(D12<0;$H$12+(L12*(M$3*$H$3/($A$3*293)));0) |
=(D13<0;$H$14*(1-J13);" ") | =L12-K13 | =(D13<0;$H$12+(L13*(M$3*$H$3/($A$3*293)));0) |
=(D14<0;$H$14*(1-J14);" ") | =(D14<0;$H$12+(L14*(M$3*$H$3/($A$3*293)));0) | |
=(D15<0;$H$14*(1-J15);" ") | =(D15<0;$H$12+(L15*(M$3*$H$3/($A$3*293)));0) | |
=(D16<0;$H$14*(1-J16);" ") | =(D16<0;$H$12+(L16*(M$3*$H$3/($A$3*293)));0) | |
=(D17<0;$H$14*(1-J17);" ") | =(D17<0;$H$12+(L17*(M$3*$H$3/($A$3*293)));0) | |
=(D18<0;$H$14*(1-J18);" ") | =(D18<0;$H$12+(L18*(M$3*$H$3/($A$3*293)));0) | |
=(D19<0;$H$14*(1-J19);" ") | =(D19<0;$H$12+(L19*(M$3*$H$3/($A$3*293)));0) | |
=(D20<0;$H$14*(1-J20);" ") | =$G$14-K20 | =(D20<0;$H$12+(L20*(M$3*$H$3/($A$3*293)));0) |
=(D21<0;$H$14*(1-J21);" ") | =L20-K21 | =(D21<0;$H$12+(L21*(M$3*$H$3/($A$3*293)));0) |
Z | Q | |
=(D10<0;M10/(0,018958*M10+1);0) | =N10/M10 | =(D10<0;K10/B10;" ") |
=(D11<0;M11/(0,018958*M11+1);0) | =N11/M11 | =(D11<0;K11/B11;" ") |
=(D12<0;M12/(0,018958*M12+1);0) | =N12/M12 | =(D12<0;K12/B12;" ") |
=(D13<0;M13/(0,018958*M13+1);0) | =N13/M13 | =(D13<0;K13/B13;" ") |
=(D14<0;K14/B14;" ") | ||
=(D15<0;K15/B15;" ") | ||
=(D16<0;K16/B16;" ") | ||
=(D17<0;K17/B17;" ") | ||
=(D18<0;K18/B18;" ") | ||
=(D19<0;K19/B19;" ") | ||
=(D20<0;M20/(0,018958*M20+1);0) | =N20/M20 | =(D20<0;K20/B20;" ") |
=(D21<0;M21/(0,018958*M21+1);0) | =N21/M21 | =(D21<0;K21/B21;" ") |
|
|
˳ (6.17) | (6.17) | |
7,08248777038711 | =P10/Q10 | =$G$16*((2*N10*1000000*$G$3)-($G$3^2))/(O10*LN($H$16/(Q10))) |
8,34290400496448 | =P11/Q11 | =$G$16*((2*N11*1000000*$G$3)-($G$3^2))/(O11*LN($H$16/(Q11))) |
7,05624562438599 | =P12/Q12 | =$G$16*((2*N12*1000000*$G$3)-($G$3^2))/(O12*LN($H$16/(Q12))) |
1,05684034410612 | =P13/Q13 | =$G$16*((2*N13*1000000*$G$3)-($G$3^2))/(O13*LN($H$16/(Q13))) |
1,66111378083838 | =P20/Q20 | =$G$16*((2*N20*1000000*$G$3)-($G$3^2))/(O20*LN($H$16/(Q20))) |
4,24019886839066 | =P21/Q21 | =$G$16*((2*N21*1000000*$G$3)-($G$3^2))/(O21*LN($H$16/(Q21))) |
г (-) | ʳ |
=S10-R10 | =(Q10;0) |
=S11-R11 | =(Q11;0) |
=S12-R12 | =(Q12;0) |
=S13-R13 | =(Q13;0) |
=S20-R20 | =(Q20;0) |
=S21-R21 | =(Q21;0) |