إصدار السوفتوير 3.11 دليل المستخدم
9-34
Spreadsheet ﻊﺿﻮﻟﺍ ﺓﺮﻛﺍﺫ .6
ﺓﺮﻛﺍﺫ ،ﺔﻓﻮﻔﺼﳌﺍ ﺓﺮﻛﺍﺫ ،ﻒﻠﳌﺍ ﺓﺮﻛﺍﺫ ،ﺔﻤﺋﺎﻘﻟﺍ ﻩﺮﻛﺍﺫ ،ﺕﺍﺮﻴﻐﺘﻣ) ﺔﺒﺳﺎﳊﺍ ﺔﻟﻵﺍ ﺓﺮﻛﺍﺬﻟ ﺔﻔﻠﺘﺨﻣ ﻉﺍﻮﻧﺃ ﻡﺍﺪﺨﺘﺳﺍ ﻚﻨﻜﳝ
.ﻝﻭﺪﳉﺍ ﻰﻟﺍ ﺓﺮﻛﺍﺬﻟﺍ ﻦﻣ ﺕﺎﻧﺎﻴﺒﻟﺍ ﺀﺎﻋﺪﺘﺳﺍ ﻭ ،ﺕﺎﻧﺎﻴﺒﻟﺍ ﻦﻳﺰﺨﺘﻟ (ﻪﺠﺘﳌﺍ
ﺓﺮﻛﺍﺬﻟﺍ ﻰﻟﺍ ﻝﻭﺪﳉﺍ ﺕﺎﻧﺎﻴﺑ ﻆﻔﺣ k
ﺕﺎﻴﻠﻤﻋ ﺮﻈﻧﺍ ،ﺔﻴﻠﻤﻋ ﻞﻛ ﻦﻋ ﻞﻴﺻﺎﻔﺘﻟﺍ ﻦﻣ ﺪﻳﺰﳌ .ﺓﺮﻛﺍﺫ ﻦﻣ ﻉﻮﻧ ﻞﻜﻟ ﺕﺎﻴﻠﻤﻌﻟﺍ ﻦﻳﺰﺨﺗ ﻦﻋ ﺔﻣﺎﻋ ﺓﺮﻈﻧ ﺮﻬﻈﻳ ﻲﻟﺎﺘﻟﺍ ﻝﻭﺪﳉﺍ
.ﻝﻭﺪﺠﻠﻟ ﺔﻌﺑﺎﺘﳌﺍ ﻝﺎﺜﳌﺍ
ﺓﺮﻛﺍﺬﻟﺍ ﻉﻮﻧﻦﻳﺰﺨﺘﻟﺍ ﺔﻴﻠﻤﻋ
ﺕﺍﺮﻴﻐﺘﻣ
(
θ
،r ،Z ﻰﻟﺍ A)
.ﺮﻴﻐﺘﻣ ﻰﻟﺍ ﺓﺪﺣﺍﻭ ﺔﻴﻠﺧ ﺕﺎﻳﻮﺘﺤﻣ ﲔﻴﻌﺗ ﻚﻨﻜﳝ
ﻭ 6(g)3(STORE)1(VAR) ﻰﻠﻋ ﻂﻐﺿﺍ ،ﺓﺪﺣﺍﻭ ﺔﻴﻠﺧ ﺭﺎﻴﺘﺧﺍ ﻢﺘﻳ ﺎﻣﺪﻨﻋ
.ﺓﺮﻫﺎﻈﻟﺍ ﺔﺷﺎﺸﻟﺍ ﻰﻠﻋ ﺮﻴﻐﺘﳌﺍ ﻢﺳﺍ ﺪﻳﺪﺤﺘﺑ ﻢﻗ ﻢﺛ ﻦﻣ
ﺔﻤﺋﺎﻘﻟﺍ ﺓﺮﻛﺍﺫ
(
List 26 ﻰﻟﺍ List 1)
.ﺔﻤﺋﺎﻘﻟﺍ ﺓﺮﻛﺍﺫ ﻲﻓ ﺪﺣﺍﻭ ﺩﻮﻤﻋ ﻭﺍ ﺪﺣﺍﻭ ﻒﺻ ﻲﻓ ﺔﻴﻠﳋﺍ ﻝﺎﺠﻣ ﻲﻓ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻦﻳﺰﺨﺗ ﻚﻨﻜﳝ
ﻂﻐﺿﺍ ،ﺪﺣﺍﻭ ﺩﻮﻤﻋ ﻭﺍ ﺪﺣﺍﻭ ﻒﺻ ﻲﻓ ﺎﻳﻼﳋﺍ ﻝﺎﺠﻣ ﺭﺎﻴﺘﺧﺍ ﻢﺘﻳ ﺎﻣﺪﻨﻋ
ﻰﻠﻋ ﺔﻤﺋﺎﻘﻟﺍ ﺐﻴﺗﺮﺗ ﺪﻳﺪﺤﺘﺑ ﻢﻗ ﻢﺛ ﻦﻣﻭ ،
6(g)3(STORE)2(LIST)
.ﺓﺮﻫﺎﻈﻟﺍ ﺔﺷﺎﺸﻟﺍ
ﻒﻠﳌﺍ ﺓﺮﻛﺍﺫ
(
File 6 ﻰﻟﺍ File 1)
ﻭ ﻑﻮﻔﺻ ﺩﺍﺪﺘﻣﺎﺑ ﻡﻮﻘﺗ ﻲﺘﻟﺍ ﺎﻳﻼﳋﺍ ﻝﺎﺠﻣ ﻲﻓ ﺕﺎﻧﺎﻴﺒﻟﺍ ﻦﻳﺰﺨﺗ ﻚﻨﻜﳝ
ﻂﻐﺿﺍ ،ﺎﻳﻼﳋﺍ ﻝﺎﺠﻣ ﺭﺎﻴﺘﺧﺍ ﻢﺘﻳ ﺎﻣﺪﻨﻋ .ﻒﻠﳌﺍ ﺓﺮﻛﺍﺫ ﻲﻓ ﺓﺩﺪﻌﺘﻣ ﺓﺪﻤﻋﺃ
ﺔﺷﺎﺸﻟﺍ ﻰﻠﻋ ﻒﻠﳌﺍ ﻢﻗﺭ ﺪﻳﺪﺤﺘﺑ ﻢﻗ ﻢﺛ ﻦﻣﻭ ،
6(g)3(STORE)3(FILE)
.ﺓﺮﻫﺎﻈﻟﺍ
ﺩﻮﻤﻌﻟﺍ ﻆﻔﺣ ﻢﺘﻳ ﻭ ،
1 ﺔﻤﺋﺎﻘﻛ ﺩﺪﶈﺍ ﻒﻠﳌﺍ ﻲﻓ ﺭﺎﺘﺍ ﻝﺎﺍ ﻦﻣ ﻝﻭﻷﺍ ﺩﻮﻤﻌﻟﺍ ﻦﻳﺰﺨﺗ ﻢﺘﻳ ﻭ
.ﻪﺑﺎﺷ ﺎﻣ ﻭ ،
2 ﺔﻤﺋﺎﻘﻛ ﻲﻧﺎﺜﻟﺍ
ﺔﻓﻮﻔﺼﳌﺍ ﺓﺮﻛﺍﺫ
(
Mat Z ﻰﻟﺍ Mat A)
ﺓﺪﻤﻋﺃ ﻭ ﻑﻮﻔﺻ ﺩﺍﺪﺘﻣﺎﺑ ﻡﻮﻘﺗ ﻲﺘﻟﺍ ﺎﻳﻼﳋﺍ ﻝﺎﺠﻣ ﻲﻓ ﺕﺎﻧﺎﻴﺑ ﻦﻳﺰﺨﺗ ﻚﻨﻜﳝ
ﻂﻐﺿﺍ ،ﺎﻳﻼﳋﺍ ﻝﺎﺠﻣ ﺭﺎﻴﺘﺧﺍ ﻢﺘﻳ ﺎﻣﺪﻨﻋ .ﺔﻓﻮﻔﺼﳌﺍ ﺓﺮﻛﺍﺫ ﻲﻓ ﺓﺩﺪﻌﺘﻣ
ﻰﻠﻋ ﺔﻓﻮﻔﺼﳌﺍ ﻢﻗﺭ ﺪﻳﺪﺤﺘﺑ ﻢﻗ ﻢﺛ ﻦﻣﻭ
6(g)3(STORE)4(MAT)
.ﺓﺮﻫﺎﻈﻟﺍ ﺔﺷﺎﺸﻟﺍ
ﻆﻔﺣ ﻢﺘﻳ ﻭ ،
1 ﺔﻤﺋﺎﻘﻛ ﺓﺩﺪﺤﻣ ﺔﻓﻮﻔﺼﻣ ﻲﻓ ﺭﺎﺘﺍ ﻝﺎﺍ ﻦﻣ ﻝﻭﻷﺍ ﺩﻮﻤﻌﻟﺍ ﻦﻳﺰﺨﺗ ﻢﺘﻳ ﻭ
.ﻪﺑﺎﺷ ﺎﻣ ﻭ ،
2 ﺔﻤﺋﺎﻘﻛ ﻲﻧﺎﺜﻟﺍ ﺩﻮﻤﻌﻟﺍ
ﻪﺠﺘﳌﺍ ﺓﺮﻛﺍﺫ
(
Vct Z ﻰﻟﺍ Vct A)
ﺓﺮﻛﺍﺫ ﻲﻓ ﺪﺣﺍﻭ ﺩﻮﻤﻋ ﻭﺃ ﺪﺣﺍﻭ ﻒﺻ ﻲﻓ ﺎﻳﻼﳋﺍ ﻦﻣ ﺔﻋﻮﻤﺠﻣ ﻲﻓ ﺕﺎﻧﺎﻴﺑ ﻦﻳﺰﺨﺗ ﻚﻨﻜﳝ
ﻰﻠﻋ ﻂﻐﺿﺍ ،ﺪﺣﺍﻭ ﺩﻮﻤﻋ ﻭﺃ ﺪﺣﺍﻭ ﻒﺻ ﻲﻓ ﺎﻳﻼﳋﺍ ﻦﻣ ﺔﻋﻮﻤﺠﻣ ﺪﻳﺪﲢ ﺀﺎﻨﺛﺃ .ﻪﺠﺘﳌﺍ
.ﺮﻬﻈﺗ ﻲﺘﻟﺍ ﺔﺷﺎﺸﻟﺍ ﻰﻠﻋ ﻪﺠﺘﳌﺍ ﻢﺳﺍ ﺩﺪﺣ ﻢﺛ ،
6(g)3(STORE)5(VCT)
ﺔﻈﺣﻼﻣ
ﺓﺮﻛﺍﺬﺑ ﺔﻴﻠﺧ ﻞﻛ ﻦﻣ ﺺﻨﻟﺍ ﻥﻮﻟ ﺕﺎﻣﻮﻠﻌﻣ ﺚﻳﺭﻮﺗ ﻢﺘﻳ ،ﻒﻠﳌﺍ ﺓﺮﻛﺍﺫ ﻭﺃ ﺔﻤﺋﺎﻘﻟﺍ ﺓﺮﻛﺍﺫ ﻰﻟﺍ ﻝﻭﺪﳉﺍ ﺕﺎﻧﺎﻴﺑ ﻆﻔﺣ ﻢﺘﻳ ﺎﻣﺪﻨﻋ
ﺓﺮﻛﺍﺫ ﻰﻟﺇ ﻭﺃ ﺔﻓﻮﻔﺼﳌﺍ ﺓﺮﻛﺍﺫ ﻰﻟﺇ ﻭﺃ ﺮﻴﻐﺘﻣ ﻰﻟﺇ ﻝﻭﺪﳉﺍ ﺕﺎﻧﺎﻴﺑ ﻆﻔﺣ ﻢﺘﻳ ﺎﻣﺪﻨﻋ ﺺﻨﻟﺍ ﻥﻮﻟ ﺕﺎﻣﻮﻠﻌﻣ ﻲﻨﺜﺘﺴﻳﻭ .ﻞﻘﻨﻟﺍ
.ﻪﺠﺘﳌﺍ
!ﻡﺎﻫ
ﺔﻴﻠﳋﺍ ﻱﻮﺘﲢ ﺎﻣﺪﻨﻋ ﻭ ،ﺕﺎﻧﺎﻴﺑ ﺔﻳﺃ ﻰﻠﻋ ﺔﻴﻠﳋﺍ ﻱﻮﺘﲢ ﻻ ﺎﻣﺪﻨﻋ ﺓﺮﻛﺍﺬﻟﺍ ﻲﻓ ﺕﺎﻧﺎﻴﺑ ﻦﻳﺰﺨﺗ ﺖﻟﻭﺎﺣ ﺍﺫﺍ ﺙﺪﺤﻳ ﺎﻣ ﻲﻠﻳ ﺎﻣ ﺮﺴﻔﻳ
.ﺔﻴﻠﳋ
ERROR ﺔﻟﺎﺳﺭ ﺮﻬﻈﺗ ﺎﻣﺪﻨﻋ ﻭﺍ ،ﺺﻧ ﻰﻠﻋ
.ﺄﻄﳋﺍ ﻊﻘﻳ ،ﺮﻴﻐﺘﳌ ﺕﺎﻧﺎﻴﺑ ﲔﻴﻌﺘﺑ ﺖﻤﻗ ﺍﺫﺍ •
ﻲﻓ ﺏﻮﺘﻜﻣ
0 ـﻟﺍ ﻥﺎﻛ ﺍﺫﺍ ،ﻪﺠﺘﳌﺍ ﺓﺮﻛﺍﺫ ﻭﺃ ،ﺔﻓﻮﻔﺼﳌﺍ ﺓﺮﻛﺍﺫ ﻭﺃ ،ﻒﻠﳌﺍ ﺓﺮﻛﺍﺫ ﻭﺃ ﺔﻤﺋﺎﻘﻟﺍ ﺓﺮﻛﺍﺫ ﻲﻓ ﺕﺎﻧﺎﻴﺑ ﻦﻳﺰﺨﺘﺑ ﺖﻤﻗ ﺍﺫﺍ •
.ﺔﻘﺒﻄﳌﺍ (ﺎﻳﻼﳋﺍ) ﺔﻴﻠﳋﺍ