Calc: Shigo da gabatar da jerin bayanai

A cikin wannan labarin, abokin Gaius Baltar ya gabatar mana da jerin dabaru para Kira, kayan aikin shimfidar rubutu don Libre / OpenOffice.

Lokacin da muke fuskantar sabon shiri muna sanya shi ta hanyar maballin ba tare da jagora guda ba, saboda za mu yi amfani da shi lokacin da matsala ta farko ta taso. Kodayake muna dariya tare da jumlar da ta gabata, kashi 99% na matsakaiciyar mai amfani ya faɗi cikin wannan kuskuren da aka ɗauka don kyakkyawan "aikin matakin ofishin mai amfani" na ci gabarsu.

An tsara wannan sakon ne ga waɗancan masu amfani da ƙwarewar da suke son fara amfani da Calc, maƙunsar Libreoffice, amma ba sa son karanta taƙaitaccen amma sun cika shafuka 44 na «Matakan farko tare da Calc».

Kasancewa mai magana mai faɗi sosai, za mu mai da hankali kan yadda ake shigo da bayanai daga fayil ɗin rubutu da shirya takardar don gabatarwar da za a yarda da ita. A rubutu na gaba zamu tsaya domin wakiltar su ta hanyar zane.

Shirye-shirye

Shirin daga abin da na samo bayanan ya ba ni tebur tare da sakamako a cikin tsarin kimiyyar Amurka, ta amfani da '.' azaman mai raba goma. Don kar in canza yanayin yanki na Libreoffice, na yanke shawarar canza '.' ta ',' ta amfani da umarnin «maye gurbin» [ctrl + H] daga Gedit.

Wannan shine asalin fayil:

A cikin abin da na maye gurbin '.' by ','

Barin jerin ta wannan hanyar:

Ina da wadannan fayilolin da yawa. Don kar in cika takardar Calc, tunda nayi niyyar in saka jadawalin ma da yawa, zan kirkiro takardar kowane jerin bayanai.

Shigo da bayanai

Ta rashin aiki za mu je menu na bayanai, amma a Calc ya bambanta. Don shigo da bayanai a cikin fayil na nau'in .txt, .csv da makamantansu, za mu kira shi daga menu 'Fayil> Buɗe'. Kamar yadda muke gani a cikin hoton, babu wani abu mai rikitarwa game da shi.

A halin da nake ciki, na fara daga fayil ɗin rubutu wanda ke da ginshiƙai daban, don haka Calc kai tsaye yana gane rabuwa "Kafaffen faɗi". Idan ba kowane lokaci yake faɗi ɗaya ba, zaka iya matsar da iyakokin jan ƙananan hoto. Idan muna da CSV wanda ke raba layuka tare da alamu, za mu yi amfani da zaɓi "rabu da".

Bayan 'Yayi', zamu lura cewa ya buɗe a cikin sabon fayil ɗin calc. Idan yanzu mun kwashe dukkan bayanan zuwa fayil ɗinmu, zamu iya amfani da fayil ɗin da aka shigo dasu don dawo da duk wani bayanin da muka rasa idan muka yi kuskure a cikin takardarmu.

Tsarin salula

Yanzu zan ba da shawarar yin aiki a cikin tagogi biyu lokacin da zaku motsa bayanai, amma kowane ɗayan yana da abin da ya fi dacewa. Ba shi da matukar damuwa kuma yana da amfani idan muka yi amfani da zuƙowa [CTRL + linzamin motsi].

Tsarin sel:

Da zarar an kwafe bayanan zuwa fayil na, zan daidaita tsarin bayanan. Da farko zan bayyana cewa rukunin farko lambobi ne (daga 10 zuwa 10, har zuwa dubu), don haka ba ni da sha'awar lissafin ilimin kimiyya.

Abu na farko shine gayawa Calc cewa wadannan kwayoyi na nau'in kimiyya ne domin ya gane su haka, sannan kuma zan sake maimaita aikin don tantance cewa ina son su a tsarin lambobi. Duk wannan ana samunsa ta hanyar danna dama da 'Format Cells' (duk da cewa muma muna da ƙayyadaddun ƙimomi a cikin maɓallan maɓallin kayan aiki)

Lura cewa idan muka zaɓi zanen gado da yawa a lokaci guda (riƙe CTRL yayin latsa shafuka masu dacewa), duk canje-canjen da muke yi a cikin takardar aiki za a yi su a cikin sauran waɗanda muka zaɓa.

Bari mu koma shafi na A. Mafi mahimman abu shi ne, ta hanyar tsoho, Calc ya fassara ta da lamba. Tare da wannan tsarin ba za mu iya canza shi ba (tunda da gaske ba haka bane), don haka muka zaɓi 'Kimiyyar'.

Da zarar an karɓa, zamu iya canza wannan shafi zuwa tsarin da ake so. Don yin wannan na maimaita 'Tsarin Tsarin' kuma zaɓi adadi (ba tare da adadi ba, wanda shine zaɓin tsoho). Et voilá!

Don fassara shafi na gaba Ina son tsarin adadi tare da wurare goma, don haka na maimaita matakan: 'Tsarin Tsarin Sel> Kimiyyance> Ok' da 'Tsarin Tsarukan> Lambobi'.

Samun wannan sakamakon:

Ta wannan hanyar tuni na riga na shirya bayanai don fassarawa. Ina bukatar guda daya kawai: shafi na C, wanda sai na canza raka'a. A halin da nake ciki na ninka shi sau dubu. Kamar dai dai, Ina yin wannan a cikin sabon shafi kuma in riƙe tsohuwar a matsayin shafi na C.

Shafin D azaman aikin shafi na C:

Don yin wannan, na danna dama D kuma zaɓi 'Saka Shafi'. Na zabi sel na farko (D3) na latsa '=' don rubuta aikin. Na zabi kwayar da nake so in ninka (C3), rubuta aikin: 'C3 * 1000' saika latsa 'enter'.

Don amfani da wannan lissafin ga dukkan sel na wannan shafi, sai na zaɓi D3 kuma, riƙe ƙasa a ƙasan akwatin dama na wannan sel, na faɗaɗa zaɓin zuwa filin bayanan ƙarshe (D1002 a halin da nake ciki). Idan ka latsa kowane kwayar salula a cikin shafi D zaka ga yana ninka kwayar C da ke kusa da shi sau 1000.

Gani a hankali

Bayan an gama shigo da bayanai, zan daidaita wasu shafuka kuma in sanya teburin ya zama kyakkyawa mai kyan gani. Zamu taimaki kanmu da kan iyakoki da sifofin salo, daidaito da launuka ("sautunan pastel" koyaushe suna yin nasara, kar a wuce ruwa tare da launuka masu kyau ko amfani da baƙi, don Allah ...). Sauran kayan aikin sune 'Haɗa Sel' don tattara bayanan gama gari da 'columnarancin shafi mafi kyau' don taimakawa gani.

A yanzu haka teburina yana kama da wannan, amma kafin mu ƙare, bari mu duba wani muhimmin kayan aikin Calc.

Rashin motsi

Tare da wannan mai amfani (wanda yake cikin 'Duba> Daskare'), zamu iya ganin wasu ƙwayoyin hannu koda lokacin da muke wani wuri a cikin falle. Idan na daskare layuka na biyu na farko (wanda yayi daidai da sunaye da raka'o'in ƙimar) koyaushe zasu kasance a saman.

Ana iya yin hakan a kwance da kuma a tsaye. Don cimma wannan, za mu zaɓi ƙananan tantanin halitta zuwa dama na iyakar da za a saita. A cikin misali na zabi cell A3. A gefe guda, idan ina so in kuma gyara shafi A don a bayyane a kowane lokaci (duk da gungurawa a kwance), Dole ne in zaɓi tantanin halitta B3 in danna menu 'Duba> Daskare'.