User Manual
9-13
ﺎﻳﻼﳋﺍ ﻦﻣ ﻕﺎﻄﻧ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺍ k
ﻊﺟﺍﺮﻣ ﻢﻜﲢ ﻲﺘﻟﺍ ﻡﺎﻜﺣﻷﺍ .ﺎﻳﻼﳋﺍ ﻦﻣ ﺩﺪﺤﻣ ﻕﺎﻄﻧ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺍ ﺪﻳﺮﺗ ﺎﻣﺪﻨﻋ ﺀﻞﳌﺍ ﺮﻣﺃ ﻡﺪﺨﺘﺳﺍ
.ﻖﺼﻠﻟﺍ ﻭ ﺦﺴﻨﻠﻟ ﺔﻠﺛﺎﳑ ﻥﻮﻜﺗ ﺔﻴﺒﺴﻨﻟﺍ ﻭ ﺔﻘﻠﻄﳌﺍ ﺔﻴﻠﳋﺍ ﻢﺳﺍ
ﻝﺎﺧﺩﺈﺑ ﺍﺬﻫ ﻞﻤﻌﺑ ﺀﻞﳌﺍ ﺮﻣﺃ ﻚﻟ ﺢﻤﺴﻳ ، ﻼﺜﻣ
B1, B2، B3 ﺎﻳﻼﳋﺍ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺇ ﻰﻟﺍ ﺝﺎﺘﲢ ﺎﻣﺪﻨﻋ
.ﺔﻟﺎﳊﺍ ﻩﺬﻫ ﻲﻓ ﺔﻴﻠﳋﺍ ﻢﺳﺇ ﻊﺟﺍﺮﳌ ﺀﻞﳌﺍ ﺮﻣﺃ ﺔﻠﻣﺎﻌﻣ ﺔﻴﻔﻴﻛ ﻦﻋ ﻲﻠﻳ ﺎﻣ ﻆﺣﻻ .
B1 ﺔﻴﻠﳋﺍ ﻰﻟﺍ ، ﺓﺮﻣ ﺔﻐﻴﺼﻟﺍ
: ﺍﺬﻫ ﻰﻠﻋ B1 ﺔﻴﻠﳋﺍ ﻱﻮﺘﲢ ﺎﻣﺪﻨﻋ
:ﺍﺬﻬﺑ ﻞﻤﻌﺑ ﺀﻞﳌﺍ ﺮﻣﺃ ﻡﻮﻘﻳ ﻑﻮﺳ
=A1 × 2
A B
1 =A1 × 2
2 =A2 × 2
3 =A3 × 2
ﺎﻳﻼﺨﻠﻟ ﺔﻴﻠﻜﻟﺍ ﺔﺳﺭﺎﻤﳌﺍ ﻥﺃ ﻆﺣﻻ
*
ﺞﺋﺎﺘﻧ ﺮﻬﻈﺗ ﻑﻮﺳ B1, B2, B3
ﻆﺣﻻ ، ﺔﻴﺑﺎﺴﳊﺍ ﺔﻴﻠﻤﻌﻟﺍ
ﺎﻨﻫ ﺔﻨﻴ
ﹼ
ﺒﻣ ﻲﻫ ﺎﻤﻛ ﺔﻐﻴﺼﻟﺍ
=$A$2 × 2
A B
1 =$A$2 × 2
2 =$A$2 × 2
3 =$A$2 × 2
ﺎﻳﻼﳋﺍ ﻕﺎﻄﻧ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﻹ u
.ﺔﻐﻴﺼﻟﺍ ﺲﻔﻧ ﻝﺎﺧﺩﺍ ﺪﻳﺮﺗ ﻱﺬﻟﺍ ﺎﻳﻼﳋﺍ ﻕﺎﻄﻧ ﺮﺘﺧﺍ . 1
.
(9-6 ﺔﺤﻔﺻ) "ﺎﻳﻼﳋﺍ ﻦﻣ ﻕﺎﻄﻧ ﺭﺎﻴﺘﺧﻹ " ﺮﻈﻧﺍ .B1:B3 ﺭﺎﻴﺘﺧﺍ ﻦﻣ ﺪﻛﺄﺘﻧ ﻑﻮﺳ ﻝﺎﺜﳌﺍ ﺍﺬﻫ ﻲﻓ •
.
2(EDIT) 6( g) 1(FILL) ﻂﻐﺿﺇ . 2
.ﺎﻬﻟﺎﺧﺩﺍ ﺪﻳﺮﺗ ﻲﺘﻟﺍ ﺔﻐﻴﺼﻟﺍ ﻞﺧﺩﺍ ، ﺔﺿﻭﺮﻌﳌﺍ ﺀﻞﳌﺍ ﺔﺷﺎﺷ ﻰﻠﻋ .
3
ﻢﺘﻳ ﻲﺘﻟﺍ ﺩﻮﻨﺒﻟﺍ ﺕﺎﻧﺎﻴﺑ ﻝﺎﺧﺩﺍ ﻚﻨﻜﳝ
.ﺔﺷﺎﺸﻟﺍ ﻰﻠﻋ ﺎﻬﻠﻴﻠﻈﺗ
1 ﺓﻮﻄﳋﺍ ﻲﻓ ﺕﺮﺘﺧﺍ ﻲﺘﻟﺍ ﺍﺬﻫ ﺔﻴﻠﳋﺍ ﻕﺎﻄﻧ
ﺐﺒ
ﹼ
ﺴﺘﻳ ﻑﻮﺳ . =A1 × 2 ( !.(=) av(A) b*cw ﻞﺧﺩﺍ ، "ﺔﻐﻴﺼﻟﺍ" ﺮﻄﺴﻟﺍ ﻲﻓ •
."ﺔﻴﻠﳋﺍ ﻕﺎﻄﻧ" ﺮﻄﺴﻟﺍ ﻰﻟﺍ ﺔﻴﻠﳋﺍ ﺮﺷﺆﻣ ﻚﻳﺮﲢ ﻰﻟﺍ w ﻰﻠﻋ ﻂﻐﻀﻟﺍ
ﻰﻟﺍ ﺐﺒ
ﹼ
ﺴﺘﻳ ﻑﻮﺳ ﺔﻴﻟﺎﺘﻟﺍ ﺓﻮﻄﳋﺍ ﺀﺍﺮﺟﺍ ،ﻞﻌﻔﻟﺎﺑ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻰﻠﻋ ﻱﻮﺘﲢ ﺔﻴﻠﳋﺍ ﻕﺎﻄﻧ ﻲﻓ ﺔﻴﻠﺧ ﻱﺍ ﺖﻧﺎﻛ ﺍﺫﺍ
•
. (ﺔﻐﻴﺻ) ﺓﺪﻳﺪﳉﺍ ﺀﻞﳌﺍ ﺕﺎﻧﺎﻴﺒﺑ ﺓﺩﻮﺟﻮﳌﺍ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻝﺍﺪﺒﺘﺳﺍ
.
w ﺡﺎﺘﻔﳌﺍ ﻭﺍ 6 (EXE) ﻰﻠﻋ ﻂﻐﺿﺇ .4
.ﺓﺩﺪﶈﺍ ﺎﻳﻼﳋﺍ ﻦﻣ ﻕﺎﻄﻧ ﻰﻟﺍ ﺔﻐﻴﺼﻟﺍ ﺍﺬﻫ ﻞﺧﺪﻳ ﻑﻮﺳ
•










