Yawan adadin Takaddun shaida na kasa o DNI za ta bi mu a duk tsawon rayuwarmu kuma za mu yi amfani da shi a lokuta da yawa da kuma kowane irin matakai. A cikin Spain, wannan takarda ta ƙunshi jerin lambobi takwas tare da wasiƙa a ƙarshen (lambar rajistan). A cikin wannan post za mu ga yadda lissafta harafin DNI a cikin Excel ko yin amfani da wasu hanyoyi.
Yawancin mutane sun san lambar ID ta zuciya, har da wasiƙar. Duk da haka, sau da yawa yakan faru mu rikita batun idan ana maganar duba lambobin takardu daban-daban. Wannan yana faruwa akai-akai ga iyaye maza da mata tare da DNI na dukan iyali, ga malaman da ke daukar nauyin karatun su a balaguro ko tafiya na karatu, ga masu horar da kungiyoyin yara lokacin yin rajistar wasanni, da dai sauransu. Akwai lokuta da yawa inda zai iya zama da amfani sosai sanin yadda ake lissafin waccan harafin.
Na gaske Mai amfani harafin DNI shine hana kowa yin amfani da lambar ƙirƙira yayin aiwatar da kowace hanya. Idan muka yi amfani da takamaiman lamba kuma muka sanya wasiƙar da ba ta dace ba a ƙarshe, saƙon kuskure yakan yi tsalle.
Amma gaskiyar ita ce harafin DNI (kuma NIF ko NIE) za a iya ƙidaya daga lambobi a cikin takardar kanta. An kafa wannan bisa doka a cikin labarin 11 na Dokar Sarauta 1553/2005, na Disamba 23: "Takardar Shaida ta Ƙasa za ta tattara lambar sirri na DNI da kuma halin tabbatarwa wanda ya dace da lambar Shaida Tax".
Wannan yana nufin cewa yana yiwuwa a lissafta harafin DNI tare da jerin dabaru da matakai masu sauƙi. Hakanan ta hanyar Excel.
Yi lissafin harafin DNI tare da Excel
Faɗin Excel zai ba mu bayanan da muke nema (harafin DNI) ta amfani da dabaru guda biyu masu sauƙi: EXTRACT aikin rubutu da kuma aikin lissafi SAURAN. Waɗannan su ne matakan da za mu bi don cimma burinmu:
- Da farko, muna buɗe Excel kuma, a cikin cell A1, Muna shigar da lambar ID wanda muke son sanin wakokin.
- Sannan, a cikin tantanin halitta B1 mun shigar da aikin RESDUE tare da ma'auni mai zuwa: = RASUWA (A1).
- Bayan haka, muna amfani da aikin MID don yin lissafin ta atomatik tare da wannan haɗin gwiwa:
= KYAUTATA ("TRWAGMYFPDXBNJZSQVHLCK"; RASUWA(A1;23)+1;1).
Ta yin wannan, harafin DNI zai bayyana a cikin tantanin halitta B1, bayan lambar takarda a cikin tantanin halitta A1. Wannan sauki.
Babban fa'idar lissafin harafin DNI a cikin Excel shine mun samu cikakken abin dogara sakamakonnisantar kuskuren mutum. Hakanan yana da matukar dacewa idan muna buƙatar ƙididdige babban kundin bayanai, tunda za a iya sarrafa dukan tsari.
Sauran hanyoyin da za a lissafta harafin DNI
Lissafin harafin DNI ta amfani da Excel hanya ce mai amfani kuma mara kuskure, amma ba ita kaɗai ba. A gaskiya ma, waɗannan tsarin sun fara zama sananne tun 1990 lokacin da aka ba da DNI tare da wasiƙa a karon farko a Spain.
Ɗaukar wannan ma'auni ya zama dole, la'akari da kurakurai da yawa da aka rubuta: lambobi marasa cikakke, kwafi, tare da canza lamba, da sauransu. A cewar Ma'aikatar Kudi, a ƙarshen 80s kusan 30% na takardun shaidar Mutanen Espanya ba daidai ba ne. Halin da ya sanya hanyoyin gudanarwa na kowane irin rikitarwa da gaske.
Waɗannan su ne wasu daga cikin hanyoyin da aka fi amfani da su tun lokacin kuma har yanzu suna da inganci a yau:
Formula don sanin harafin DNI
Akwai tsari mai sauƙi wanda ke ba mu damar lissafin harafin sarrafawa ko lambobi daidai da lambar DNI. Za mu buƙaci kalkuleta ne kawai, ko ma a'a idan muna da hankali a lissafin hankali. Hanyar ta ƙunshi Raba cikakken lambar ID da 23 (zagaye kashe sakamakon).
El resto, wanda koyaushe zai kasance tsakanin lambobi 0 da 22, zai ba mu damar samun harafin da muke nema. Wannan shi ne tebur (wanda gidan yanar gizon Ma'aikatar Cikin Gida ya ba da shi) wanda za mu iya tuntuɓar kalmomin:
- 0=T
- 1=R
- 2=W
- 3 = A
- 4=G
- 5=M
- 6 = KUMA
- 7=F
- 8 = P
- 9 = D
- 10 = X
- 11=B
- 12 = N
- 13 = J
- 14 = Z
- 15 = Iya
- 16 = Q
- 17 = V
- 18 = H
- 19 = L
- 20=C
- 21=K
- 22 = E
Shafukan yanar gizo don lissafin harafin DNI
Don sanin sakamakon a cikin sauri da sauri, yana da kyau a yi amfani da takamaiman gidan yanar gizon don gano harafin DNI. Waɗannan su ne wasu shawarwari:
letranif.com
Fitar cartanif.com Ba shi da wani rikitarwa. Abin da kawai za ku yi shi ne shigar da lambobin takardar shaidar ɗan ƙasa kuma danna maɓallin. Shafin zai lissafta shi ta atomatik a cikin ƙasa da daƙiƙa guda. Mafi kyawun abu shine cewa sakamakon ya kasance cikakke cikakke kuma abin dogara.
Calculardni.es
Yanar gizo lissafi.es Yana aiki daidai da na baya, kodayake yana ba da ƙarin fa'ida: yana ba mu damar yin lissafin harafin NIE.
Yi lissafin -letra-dni.appspot.com
Har ila yau wani gidan yanar gizon don yin wannan tambaya: Yi lissafin -letra-dni.appspot.com, tare da aiki iri ɗaya da sauran kuma tare da ainihin sakamako na gaggawa.