Jina EUC hi tatbiqat tama tatwiruha biwasita “almustakhdimin alnihayiyiyna” fi Excel ‘aw Access walakin lays bialdarurat biaistikhdam maeayir altarmiz ‘aw alhusul ealaa tadrib rasmiin fi majal tiknulujia almaelumati. yaqum muazafu aleamaliaati/BAU bitatwir EUC walays qism tiknulujia almaelumati. tustkhdm tatbiqat hawsabat almustakhdam alnihayiyi aydan fi qawaeid albayanat ‘aw alaistielamat ‘aw albaramij alnasiyat ‘aw almukhrijat min ‘adawat ‘iiedad altaqarir. tamtalik alsharikat almaliat eddan kbyran min eamaliaat tarkhis alaistikhdam alnihayiyi (EUC) almueaqadati. tumathil wahadat alaitihad al’uwrubiyi ghayr almudart khtran kbyran ealaa alsharikati, khasatan tilk aleamilat fi alqitae almalii mithl albunuk washarikat altaamini. yatanawal hadha almanshur alhada min makhatir al’aemal min khilal wujud siasat tarkhis alaistikhdam alnihayiyi (EUC), wakayfiat tanfidhiha. Alhadu min makhatir al’aemal min khilal wujud siasat EUC.
Aalbunuk almarkaziat tabhath fi namudhaj almakhatir waEUC
‘Asdar bank ‘iinjiltira alan byanan ‘ishrafyan raqm SS1/23 – mabadi namudhajiatan li’iidarat almakhatir lilbunuk tuhadid tawaqueat hayyat tahlil almakhatir / alhayyat altanzimiat li’iidarat albunuk lilmakhatir alnamudhajiati. yajib ealaa albunuk almarkaziat fi jamie ‘anha’ alealam alan ‘an tanzur ‘iilaa albunuk washarikat altaamin walmuasasat almaliat al’ukhraa fi biladiha lilta’akud min ‘ana maeayir tarkhis alaitihad al’uwrubiyi ealiat bima yakfi lilhadi min al’akhta’ almaliat wal’iidrar bialsumeat wa’akhta’ al’iiblagh ean albank almarkazi. wayughatiy majmueatan wasieatan min ‘asalib alhisab alkamiyi wal’anzimat wal’asalib watatbiqat hawsabat almustakhdim alnihayiyi (EUCs) walalat alhasibat almustakhdamat fi aleamaliaat alyawmiat lilsharikati, ‘ay ‘ana almukhrajat tudeam alqararat almutakhadhat fima yataealaq bi’anshitat al’aemal aleamat walqararat alastiratijiat waltaseir walmaliati. walmakhatir wa’iidarat ras almal walsuyulat ‘aw altaqarir wal’anshitat almasrifiat altashghiliat al’ukhraa. kan almaweid alnihayiyu lilwafa’ bihadhih almaeayir hu 17 mayu 2024. wahadha bimathabat daewat lilaistiqaz lilsharikat litaqlil makhatir al’aemal min khilal wujud siasat tarkhis alaistikhdam alnihayiyi (EUC).
Tumathil jadawil bayanat Monster Excel khtran kbyran ealaa eamalik tustkhdm jadawil bayanat Excel fi muezam al’aemal almasrifiat waltaaminiat hadhih al’ayami. yumkin tatwir altatbiqat almueaqadat bisureat nisbiatin. wamae dhalika, yumkin lileadid min almustakhdimina, aladhin yutrkwn li’ajhizatihim alkhasati, tatwir jadawil albayanat ‘iilaa “whwsh” libarnamaj Excel. wayahduth hadha eadtan fi halat eadam wujud siasat tarkhis alaistikhdam alnihayiyi (EUC), wayumkin lilmustakhdimin “alqiam bial’ashya’ alkhasat bihim”. altaathir ealaa altaearud altashghilii walmalii lilsharikat almaeniati. ‘iidhan sarat al’umur ealaa nahw khatiin, famin almumkin ‘an tatasabab hadhih al’adawat aydan fi al’iidrar bialsumeati. tatanawal maqalati kayfiat taqlil alhadi min makhatir al’aemal min khilal wujud siasat tarkhis alaistikhdam alnihayiyi (EUC), wakayfiat alqiam bidhalika. tueadu jadawil bayanat Excel almueaqadat jdan alati yataeadhar ealaa al’ashkhas fahmuha ealiat almakhatir watatatalab muealajat EUC (anzur ‘adnahu). tatadaman baed mizat EUC ma yali: eadam wujud ruyat lilsharikat – Alhadu min makhatir al’aemal min khilal wujud siasat EUC
• eadam kifayat alwathayiq • su’ altasmim wanaqs maeayir altarmiz
• duef ‘aw eadam wujud masar altadqiq
• lam yatima akhtibaruha bialkamil / lam yatima altahaquq min sihatiha
• tatatalab altatbiqat almaliat einayatan fayiqatan / laha tathir kabir ealaa alsharikat • eadam wujud ruyat lilsharikat ‘asyilat lilfikri:
• kayf yumkinuk tadqiq eamaliaat EUC almueaqadati?
• kayf yumkin limustakhdim BAU astikhdamuh fi almahami alyawmiat ‘iidha lam yafhamhu?
• limadha nartabik bisabab jadawil albayanat alkabirat ghayr aleamaliati? alquyud albashariat – eatabat milarz eatabat milarz tahtamu bi “aldhaakirat aleamilati” ‘aw aldhaakirat qasirat almadaa. ‘iinaha qudrat aldimagh ealaa alaihtifaz bi’ajza’ mutaeadidat min almaelumat fi nafs alwaqti. kama yatadaman aydan qudratana ealaa aitikhadh alqararat biaistikhdam tilk almaelumati. yuakid qanun milir ‘ana madaa dhakirat al’ashkhas yaqtasir ealaa sabe maelumati. yaqul milir ‘iina dafe eadad “btati” almaelumat fawq hadha alhadi tasabab fi huduth airtibaki, mimaa ‘adaa ‘iilaa aitikhadh qararat ghayr sahihatin. lidhalika, yajib tasmim jadawil bayanat Excel bitariqat tamnae huduth ‘ayi airtibaki. laqad wajahat aleadid min wuhush Excel tawal ‘akthar min 25 eaman min aleamal fi sharikat alkhadamat almasrifiat waltaamini. radi alfiel almuetad lil’iidarat aleulya watiknulujia almaelumat eindama yaktashifun ‘amr hawula’ “alwhush” hu aldhuer walkhawfa, khasatan ‘iidha kan al’amr yataealaq biaitifaqiat tarkhis almustakhdam alnihayiyi (EUC) almuhimat lil’aemali. thuma yaqumun eadtan biaistidea’ khabir fi jadawil albayanat li’iijra’ muealajat EUC wahali almushkilati. fi hadhih almaqalat sa’ulakhis dirasat alhalat alwaqieiati, watiqniaat muealajat jadawil albayanati, wasiasat tarkhis astikhdam almustakhdam (EUC) wasa’unaqish bi’iijaz Office 365. yumkin aleuthur ealaa hadhih alqanabil almawqutat fi ‘ayi makan fi eamlika.
Hal taerif ‘ayn tujad jadawil bayanat Monster fi eamlika? dirasat alhalat 1 laqad jalabatni ‘iihdaa alsharikat alraayidat fi ‘iidarat alsanadiq limuealajat wa’iidarat namudhaj Excel alrayiysii li’iidarat ‘amwal EUC mae almushtaqaat almudamanat alati lam yafhamha ‘ahad, biaistithna’ alshakhs aladhi qam bitatwiriha. laqad kan al’amr hndsyan bialkamil waghayr mustaqara. yumkin ‘an tufsid namadhij Excel alkabirat fi ‘ayi waqta, thuma takhtafi. tadamanat ‘aemal ‘iislah EUC ‘iieadat handasatiha liaistikhdam ealamat tabwib ‘aqala wasigh ‘aqala wataqlil hajm jadwal bayanat Excel min hawalay 100 mijabayt ‘iilaa hawalay 25 mijabayt. thuma ‘asbah al’amr “beydan ean alkhatari”. thuma qumt baed dhalik bi’atmitat baed alkhutuat alyadawiat biaistikhdam VBA. ‘ahad al’ashya’ alhasimat alati wajadtha hu ‘ana natayij alnamudhaj “kanat khatiatan” wakan laha athar khatirat ealaa alsharikati, walati kan min almumkin ‘an tuajih mushkilatan mae PRA / alhayyat altanzimiat bisabab altaqarir ghayr alsahihati. wabaed ‘iieadat alhandasat wa’iidafat hisabat ‘aqwaa ‘asbahat alnatayij sahihatan. kanat almushkilat hi ‘ana barnamaj Excel “takhalaa” ean aleamaliaat alhisabiat nzran liwujud eadad kabir jdan min altabeiaati. dirasat alhalat 2 ‘ahdaratni ‘iihdaa sharikat ‘iieadat altaamin alraayidat li’iislah wa’iieadat tatwir ‘adaat jadwal bayanat Excel li’iiedad taqarir PRA. wabaed baed altahlili, khalasat ‘iilaa ‘anah lam yakun <<mnasban lilgharadi>>. limadha? laqad aistakhdam rawabit milafaat ghayr eamaliatin, waleadid min alnakahat almaktubat bishakl sayiy liramz VBA, (baeduha musajili), waistamara fi alsuquti. kama ‘ana alnatayij kanat khatiatan fi baed al’ahyani/la yumkin alaietimad ealayha (lays mfajyan hqan). kan alhalu aladhi tawasalat ‘iilayh hu tatwir ‘adaat nazifat wamuetamadat ealaa bayanat almuealimat walati tuntij taqarir PRA almatlubat bikafa’at wadiqat binaqrat qalilat ealaa al’azrar. hadha hu ma yumkin ‘an tafealah muealajat EUC lisharikatika. dirasat alhalat 3 jalabatni ‘iihdaa sharikat altaamin alraayidat li’iislah wa’iieadat tatwir ‘adaat taswiat almizaniat aleumumiat alqayimat ealaa barnamaj Excel. laqad kan “whshan” bihajm 100 mija bayit mae ealamat tabwib mutaeadidatin, mae 100000 sajal fi kuli ealamat tabwib (mae 100000 sif sighatin), wayablugh tul aljadwal almihwarii ‘akthar min 50000 safin waishtakawa min aistimrar alsuqut wanafad aldhaakirati. mae eadam wujud mutatalabat tqryban, qumt bitahwil sufuf alsiyghat ‘iilaa qim, wataqsimiha ‘iilaa namudhajin, mae taqsim aljadawil almihwariat ‘iilaa namudhaj munfasili, ‘iilaa janib nuskhat mudamanat min albayanat almatlubati. tatadaman ‘iislahat EUC ‘atmitat aleamaliaat alyadawiat biaistikhdam tatbiqat Visual Basic mae takhfidat kabirat fi aldhaakirat wahajm almilafi waziadatan fi alsureati. ‘iidha tarikat dun muraqabatin, fa’ana muta’akid min ‘anaha qad tufsid wayusbih alnamudhaj ghayr qabil lilaistirdadi.
Kayf tatasalal al’akhta’ watataearad jawdat altaqarir altanzimiat lilkhatar bisabab duef aldawabit ealaa mustawaa albayanat almusadari, walaiftiqar ‘iilaa alraghbat ealaa mustawaa al’iidarat lifiel ‘ayi shay’ hial dhalika. tahtaj alsharikat ‘iilaa taqdir madaa ‘ahamiyat dawabit aljawdat aljayidat eind ‘adnaa mustawaaan. yatimu taghdhiat al’akhta’ alati yatimu ‘iidkhaluha fi bayanat almasdar ‘iilaa al’iidarat aleulya wataqarir albank almarkazi. talmiha: altaqat al’akhta’ eind ‘adnaa mustawaa mumkinin. mithal ealaa nizam ‘iidarat alaiftiradat aladhi eamilat ealayhi, kanat al’akhta’ tazhar fi nizam SQL Server fi ‘aelaa alsilsilat bisabab ‘akhta’ fi bayanat almasadari. li’iislah dhalika, qumt bikitabat altahaquq min sihat albayanat ealaa milafaat masdar EUC liailtiqat al’akhta’ wa’iislahiha. wamin al’amthilat al’ukhraa ealaa nizam almula’at almaliat II ‘iidafat dawabit tadaman ‘iidafat altakhsis bayn fiat al’usul ‘iilaa 100% wal’iiblagh ean alaistithna’ati. eindama yaqum almar’ bimuealajat nisf milyun sijila, tuetabir hadhih alfuhusat balighat al’ahamiyati. eindama yatimu taqdim natayij eamaliaat tarkhis almustakhdam alnihayiyat almuearadat lilkhata ‘iilaa albank almarkazi/aljihat altanzimiati, fa’iina huduth ‘akhta’ fi ‘iiedad altaqarir yueadu amran khtyran.
Tiqniaat muealajat EUC mufidat li’iislah “alwhush” fi Excel almuearadat likhatar alfasad
Ahfaz alnamudhaj bitansiq thunayiyin (yadghat almilafu ‘iilaa tansiq xml) • fi ealamat tabwib majmueat albayanat alkabirat alati tahtawi ealaa siagh mudmanatin, aihtafaz bisighat alsafi aleulawi, wainsakhha walsiqiha kaqim (la tans ‘iieadat alhisab awlaan!) • fi aljadawil almihwariati, qum bimash dhakirat altakhzin almuaqat lilbayanat (yumkin aistikhdam kamiyat kabirat min aldhaakirati) • altaqsim ‘iilaa namudhajayn ‘aw ‘akthar (taqsim albayanat min alhisabati) • altarqiat ‘iilaa Excel/Office 365 64 bit (yumkinuh muealajat ma yasil ‘iilaa 8 tirabayt min aldhaakirati) • bialnisbat lilnamadhij altaalifati, ainsakh al’awraq ‘iilaa musanaf farigh wa’aeida albina’ min albidaya (lays lidieaf alqulubi) • ‘iizalat ealamat altabwib alzaayidati, wanitaqat al’asma’i, warawabit almilafaat alyatimati, waitisalat albayanat • mash alnitaq almustakhdam likuli ealamat tabwib (ytum dhalik eabr wahdat fiat ealamat altabwib wanafidhat tashih al’akhta’i) • ‘iizalat ‘aw astibdal siagh Excel “almutaqalibati” mithl now() warand() wama ‘iilaa dhalika. • murajaeat ‘ayat wazayif waraqat eamal mukhasasa • murajaeat maktabat VBA alati yatimu astikhdamuha Office 365 wa32 bat ‘iilaa 64 bitt wama ‘iilaa dhalik yati Excel 365 mzwdan bimajmueat min alwazayif aljadidat almufidat mithl concat watextjoin waifs waxlookup walati yumkin ‘an tahila mahala wazifat alfahrs/almutabiqa (yumkin ‘iijra’ bahth ealaa aljanib al’aysari). al’ashya’ alati yajib alaintibah ‘iilayha fi Excel 365 hi astidea’at wajihat barmajat altatbiqat (API) alati tatatalab alan bina’ jumlat prtsafe / prtlong li’iidarat 32 wa64 biti. laqad lahazt aydan ‘ana suluk Workbook_open qad taghayar lidha kan eali alqiam bihali badil lidhalika. sa’aqum bieamal maqal akhar ean Excel 365 yataeamaq ‘akthara.
Siasat alaitihad al’uwrubiyi
Tamil albunuk ‘iilaa aitibae nahj ‘akthar andbatan min sharikat altaamini, fima yataealaq bisiasat tarkhis alaitihad al’uwrubiyi (EUC), lakina sharikat altaamin tatahasan bibut’. taemal albunuk mithl Lloyds Banking Group ealaa taqlil makhatir al’aemal min khilal aitibae siasat tarkhis alaistikhdam alnihayiyi (EUC) – waladayha alan siasat tarkhis aistikhdam alaitihad al’uwrubiyi (EUC) alqawiat walmutatawirat jydan. tatadaman mizat siasat EUC aljayidat ma yali:
• jurid lijamie jadawil bayanat Excel waqawaeid bayanat Access alhamat lil’aemal
• tahlil / tasnif altaeqid • tahlili/tasnif makhatir al’aemal
• sahib aleamal fi EUC
• almalik alfaniyu la EUC
• alwathayiq alkamilatu, bima fi dhalik sajal altaghyirat wadalil almustakhdam wadalil alnizam waldalil alfaniyi
• nizam litasjil aldukhul walkhuruj li’iijra’ altaghyirat ealaa sabil almithali. min shirbwint
Ma hu EUC alharijatu?
Hal tatasim bialtaeqid alkafi fima yataealaq biramz vba walwazayif al’iidafiat walsiyagh walwazayif al’ukhraa؟ • hal hi muhimat min alnaahiat altashghiliat wa/’aw laha tathir kabir ealaa ‘iiedad altaqarir almaliiti? ‘iidha kanat al’iijabat biniema, fahi aitifaqiat tarkhis nihayiya (EUC) muhimatan wayajib ‘an takun mutawafiqatan mae aitifaqiat tarkhis almustakhdam alnihayiyi (EUC).
Siasat EUC – Kayfiat Alhusul Ealaa “altasrihi”
Laqad tama taklifi fi sharikat altaamin alati ‘aemal biha halyan, bitanfidh siasat hawkamat EUC, limajmueat min EUC, watanfidh aldawabit al’iidafiati, wa’atmitat VBA waltawthiq la EUC lilhusul ealaa “tamrir aydan”. taqdim almashurat limustakhdimi EUC alakhrin bima yataeayan ealayhim alqiam bih lilhusul ealaa tasrihi. yueadu sijil jard EUC alkhasi bi EUC alharijat ensran ryysyan fi siasat EUC. aleilajat alsahihat hi tariqat alhusul ealaa tasrih likuli EUC. yajib ‘an yakun hunak hadun ‘adnaa min ‘aemal muealajat EUC li’iidafat eanasir altahakum walwathayiq min ‘ajl alhusul ealaa tasrihi. yajib ealaa almutawirin wamuazafi BAU aleamal mean lilhusul ealaa almutatalabat watatwir alhulul waikhtibariha watanfidhiha. fi baed al’ahyan yakun altaghyir fi aleamaliaat altijariat mtlwban bisabab zuhur mushkilat tataealaq bialmakhatiri.
Eilajat EUC
Qad tatasa’al ma hi almuealajat almatlubat hataa tafi aitifaqiat tarkhis almustakhdam alnihayiyi (EUC) bimieyar jayid lisiasat aitifaqiat tarkhis almustakhdam alnihayiyi (EUC)? eadtan ma yahtaj barnamaj Excel EUC dhu al’ahamiyat albalighat ‘iilaa altahaquq min ‘ana albayanat almasdar hi nafsuha alati tama tahmiluha bialfieli. eamaliaat altahaquq lilta’akud min ‘ana albayanat (ruuws alhuquli) fi milafaat al’iidkhal lam tataghayar – ealamat hamra’ kabiratun, waeamaliaat fahs nawe albayanati, wasajal altahakum fi altaghyirati/al’iisdar, walhimayata, watasmim ealamat altabwib tajeal al’amr ‘akthar basatatin, wadalil almustakhdam walwathayiq alfaniyati/alnizamia . sayakun hadha hu alhadu al’adnaa almatluba. bishakl eami, kulama kan jadwal albayanat ‘akthar teqydan, zadat alhajat ‘iilaa muealajat EUC lijaelih “qwyan” bima yakfi lilhusul ealaa tasrihi. tuhadid alqayimat almarjieiat alati qadamatha fi namudhaj altadqiq niqat alduef walthagharat alati tahtaj ‘iilaa muealajat EUC.
Namudhaj Tadqiq Siasat EUC Waqayimat Almurajaea
Laqad qumt bitatwir namudhaj Excel litahdid madaa taeqid aitifaqiat tarkhis almustakhdam alnihayiyi (EUC) wa”‘ahamiyat al’aemali” bimaenaa akhar “hal hi fi nitaq aitifaqiat tarkhis almustakhdam alnihayiyi (EUC) alharijati?” wayuhadid alnumudhaj miqdar al’iislah almatlub lilairtiqa’ ‘iilaa mustawaa siasat aitifaqiat tarkhis almustakhdam alnihayiyi (EUC), wal’ahamu min dhalik tahdid niqat aldueufi. tastahdif al’adaat eamaliaat tarkhis alaistikhdam alnihayiyi (EUC) almutawasitat ‘iilaa shadidat altaeqid walati laha tathir tashghiliun ‘aw wazifayun ‘aw khariji/tanzimiun kabir watahtaj ‘iilaa tasjiliha fi sijil tarkhis alaitihad al’uwrubiyi (EUC). ‘iinaha qayimat marjieiat mufidat lilghayati, walati ‘aqum bimashiha bhthan ean aleilajat almunasibat lijael aitifaqiat tarkhis almustakhdam alnihayiyi (EUC) qawiatan wamafhumatan waladayha dawabit jayidat mae alwathayiqi. wahadha yajealuha amnatan liaistikhdam BAU. Alhadu min makhatir al’aemal min khilal wujud siasat EUC.
Tanfidh Siasat EUC Ealaa Mustawaa Almudir Al’awal
Hataa fi halat wujud siasat rasmiat la EUC, yakun hunak fi baed al’ahyan naqs fi alraghbat fi altanfidh alfielii litilk aldawabiti. yakhudh baed almudirin siasatan EUC ealaa mahmal aljid, walbaed alakhir la yafeal dhalika. al’ashkhas aladhin yakhudhun al’amr ealaa mahmal aljadi hum eadatan al’ashkhas aladhin ladayhim khibratu/khawf min jadawil albayanat “almariqati”, ealaa sabil almithali, talaqawa mukalamatan min al’iidarat altanzimiat lilbank almarkazii bisabab khataan fi al’iiblaghi, waladayhim “dafieu” lieadam ‘iijra’ nafs al’akhta’ maratayn ‘aqum bi’iilqa’ aldaw’ lilmudirin ealaa dawabit EUC almatlubati, ealaa sabil almathali, altahaquq min sihat albayanati, wadawabit VBA, wadalil almustakhdim wadalil alnizami, wasajal altaghyirati/altahakum fi al’iisdar wama ‘iilaa dhalika, wamin almuhimi ‘an yahtaj almudirun ‘iilaa takhsis waqt lihadha aleamal fi khuttihim.
Tadqiq Albank Almarkazii
Tahtaj alsharikat almaliat ‘iilaa ‘an yakun ladayha siasa “qawiatun” li EUC lilaimtithal limaeayir SS1/23 fi almamlakat almutahidati, wajaeal majlis al’iidarat mswwlaan eanha. wahadha shay’ yunzar ‘iilayh bank ‘iinjiltira walbunuk almarkaziat al’ukhraa ean kathaba, lidhalik ‘iidha lam yakun ladayk wahidat bialfieli, faqad han alwaqt litatbiq siasat tarkhis alaitihad al’uwrubiyi (EUC) fi sharikatika, qabl ‘an yaqum albank almarkaziu alkhasu bik bi’iijra’ altadqiqi. qum bihimayat EUCs alkhasat bik waijeal majlis al’iidarat walmusahimin walmunazimin sueada’a. aihsul ealaa fahs EUC almuhimi alkhasi bik wamuealajatih watarqiatih biwasitatina alan. Alhadu min makhatir al’aemal min khilal wujud siasat EUC.
Ritshard ji man FMAAT، MIAP، MBCS hu mutawir EUC, waeilaj EUC wakhabir fi siasat EUC, waqad eamil fi qitae alkhadamat almaliati, fi almajal altanzimii walmakhatiri, li’akthar min 25 eaman. wahu mutakhasis fi tatwir EUC, wabishakl ‘asasiin Excel VBA, watatwir qaeidat bayanat Access waSQL Server. wahu muhasab muahal mhnyan waeudw aydan fi jameiat alkumbiutar albiritaniat wamaehad almuhalilin walmubarmijini. tuasil maeana alan lilhusul ealaa almusaeadat fi taqlil makhatir al’aemal min khilal wujud siasat tarkhis alaistikhdam alnihayiyi (EUC).
#muealajatEUC #qisasAlrueb #muealajatExcel #TaqlilAlmakHatiriEUCAlmuealija #TaklifatMuealajatEUC
#BarnamajMuealajatEUC #AmthilatEalaaMuealajatEUC #EilajEUCpdf
Aitisal
Bayt
#EUCRemediation #ExcelMonsters #MonsterSpreadsheet #ExcelRemediation #ReduceRiskEUCRemediation
#EUCRal-wasatah
#ExcelMonsters
#Monsterjaddoul al-bayanat
#ExcelRemediation
#ReduceRiskEUCRal-wasatah
x
x
use #hashtags ie see emails