Iyalayisha kusuka ku-Excel ku-1C: Imiyalo Yokusebenza

Kade kudala, uhlelo oludumile kakhulu phakathi kwama-accountants, abahleli, ososi bezomnotho kanye nabaphathi be-annex 1C. Akunakuphela okuhlukahlukene kokucushwa kwemisebenzi ehlukahlukene, kepha futhi kwasendaweni kumazinga okubalwa kwezimali emazweni amaningana omhlaba. Amabhizinisi amaningi athe xaxa adluliswa kwi-accounting kulolu hlelo. Kepha inqubo yokudlulisela idatha ngesandla kusuka kwezinye izinhlelo zokubalwa kwemali ku-1C isifundo eside nesixakile, esenzeka. Uma ibhizinisi liqoshwe kusetshenziswa i-Excel, inqubo yokudlulisa ingasebenza ngokuzenzakalela futhi isheshiswe.

Kudluliswa idatha kusuka ku-Excel kuya ku-1c

Kudluliswa idatha kusuka ku-Excel ku-1C ayidingeki esikhathini sokuqala sokusebenza nalolu hlelo. Kwesinye isikhathi kuza ngesidingo salokhu, phakathi nathi, phakathi nomsebenzi, udinga ukubeka ezinye izinhlu ezigcinwe encwadini ye-Processor Book. Isibonelo, uma udinga ukudlulisa uhlu lwamanani noma ama-oda avela esitolo online. Endabeni lapho uhlu luncane, khona-ke lingaqhutshwa ngesandla, kepha yini okufanele ngiyenze uma liqukethe amakhulukhulu ezinto? Ukuze usheshise inqubo, ungaphendukela kwezinye izici ezengeziwe.

Cishe zonke izinhlobo zemibhalo zizolungele ukulanda okuzenzakalelayo:

• Uhlu lwe-nomenclature;
• Uhlu lwabalingani;
• Uhlu lwamanani;
• Uhlu lwama-oda;
• Imininingwane mayelana nokuthenga noma ukuthengisa, njll.

Masinyane kufanele kuqashelwe ukuthi ku-1c awekho amathuluzi owakhelwe ngaphakathi angakuvumela ukuthi udlulise idatha kusuka ku-Excel. Ngalezi zinhloso, udinga ukuxhumanisa i-bootloader yangaphandle, okuyifayela ngefomethi ye-EPF.

Ukulungiselela idatha

Sizodinga ukulungiselela idatha ethebula le-Excel uqobo.

1. Noma yiluphi uhlu olulayishwe ku-1C kumele luhlelwe ngendlela efanayo. Awukwazi ukulanda uma kunezinhlobo eziningi zedatha kwikholamu eyodwa noma kuseli, ngokwesibonelo, igama lomuntu nenombolo yalo yocingo. Kulokhu, amarekhodi anjalo anjalo kufanele ahlukaniswe amakholomu ahlukile.



2. Akuvunyelwe ukuba namaseli ahlanganisiwe ngisho nasezihlotsheni. Lokhu kungaholela emiphumeleni engemihle lapho kudluliswa idatha. Ngakho-ke, uma amaseli ahlanganisiwe etholakala, kufanele ahlukaniswe.



3. Uma itafula lomthombo lenziwa lilula ngangokunokwenzeka futhi licacile, ngaphandle kokusebenzisa ubuchwepheshe obuyinkimbinkimbi (ama-macros, amafomula, izinto, kuzosiza ukukhulisa izinkinga ngezinyathelo ezithe xaxa.



4. Qiniseka ukuthi uletha igama lawo wonke amanani ngefomethi eyodwa. Akukho ukuqanjwa okungavunyelwe, ngokwesibonelo, ikhilogremu ekhonjiswe amarekhodi ahlukile: "kg", "kilogram", "kg.". Uhlelo luzobaqonda njengamanani ahlukile, ngakho-ke udinga ukukhetha inketho yenketho eyodwa, futhi okunye kulungiswe ngaphansi kwale template.



5. Qiniseka ukuthi unezikhombi ezihlukile. Okuqukethwe kwanoma iyiphi ikholomu kungadlalwa endimeni yabo, engaphindwa kweminye imigqa: Inombolo yentela yomuntu ngamunye, i-Article, njll. Uma kungekho kukholamu etafuleni elikhona elinenani elifanayo, ungangeza ikholomu eyengeziwe futhi ukhiqize izinombolo ezilula lapho. Lokhu kuyadingeka ukuze lolu hlelo lukhombe idatha emgqeni ngamunye ngokwahlukana, hhayi "ukuhlanganisa" kanyekanye.



6. Iningi labaphathi befayela le-Excel alisebenzi ngefomethi ye-XLSX, kodwa ngefomethi ye-XLS kuphela. Ngakho-ke, uma idokhumenti yethu inokwanda kwe-XLSX, khona-ke kuyadingeka ukuyiguqula. Ukuze wenze lokhu, iya kuthebhu ethi "File" bese uqhafaza ku-"Gcina njenge"

   

   Iwindi longa livula. Ifomethi ye-XLSX ezenzakalelayo izocaciswa enkambu ye- "File File". Sikuguqula ku- "Book Excel 97-2003" bese uqhafaza inkinobho ethi "Gcina".

   

   Ngemuva kwalokho, lo mbhalo uzosindiswa ngendlela oyifunayo.

Ngaphezu kwalezi zenzo zendawo yonke zokulungiswa kwedatha encwadini ye-Excel, kuzodingeka ukuthi ulethe idokhumenti ngokuhambisana nezidingo ze-bootloader ethile, esizoyisebenzisa nje ngezansi.

Ukuxhuma i-bootloader yangaphandle

Xhuma i-bootloader yangaphandle ngesandiso se-EPF kuya kwisengezo 1c kungaba ngaphambi kokulungiswa kwefayela le-Excel nangemva kwalokho. Into esemqoka ukuqala inqubo yokwenza ukulandwa kokubili kwalezi zikhathi zokulungiselela zixazululiwe.

Kunezibamvana ezimbalwa zangaphandle zangaphandle ze-1C, ezidalwe abathuthukisi abahlukahlukene. Sizocubungula isibonelo sisebenzisa ithuluzi lokucubungula imininingwane "Imininingwane yokulanda kusuka kudokhumenti ye-tabular" yenguqulo 1c 8.3.

1. Ngemuva kwefayela kwifomethi ye-EPF elandiwe futhi ligcinwe kwi-Hard Disk yekhompyutha, lazisa uhlelo lwe-1C. Uma ifayela le-EPF ligcwele kulondolozo, khona-ke kufanele lisuswe lapho. Kuphaneli yohlelo lokusebenza olungenhla, cindezela inkinobho esebenzisa imenyu. Kuhlobo 1c 8.3, kuvezwa ngendlela yokujikeleza kuka-Triangle okubhalwe ekunqotweni kwe-orange, engela phansi. Uhlu oluvelayo, ngokulandelana lidlula "ngefayela" kanye "nokuvula" izinto.



2. Iwindi elivulekile lefayela liqala. Iya ku-Directory yendawo yayo, sigqamisa le nto bese uqhafaza inkinobho ethi "Open".



3. Ngemuva kwalokho, i-bootloader izoqala ku-1c.

Ukulanda Ukucutshungulwa "Imininingwane Yokulanda kusuka kudokhumenti yethebula"

Iyalayisha idatha

Enye yezinhlelo zolwazi eziphambili lapho i-1C isebenza khona uhlu lwemikhiqizo nezinsizakalo. Ngakho-ke, ukuchaza inqubo yokulayisha kusuka ku-Excel, sizogxila esibonelweni sokudluliswa kwalolu hlobo lwedatha.

1. Buyela ewindini lokucubungula. Njengoba sizolayisha ibanga lomkhiqizo, bese kuthi "ukulayisha" ipharamitha, ukushintshwa kufanele kume endaweni ethi "Directory". Kodwa-ke, ifakwe kangaka ngokuzenzakalelayo. Kufanele uyishintshe kuphela lapho uzodlulisa enye uhlobo lwedatha: ingxenye yethebula noma irejista yolwazi. Okulandelayo, enkundleni "Ukubuka kwe-Directory" ngokuchofoza inkinobho lapho kuboniswa khona ichashazi. Kuvulwa uhlu olwehliswayo. Kuyo, kufanele sikhethe into ethi "Nomenclature".



2. Emva kwalokho, isandla sibeka ngokuzenzakalelayo izinkambu ezisetshenziswa yilolu hlelo ngalesi siqondisi. Kuyadingeka ukuthi uqaphele ngokushesha ukuthi akudingekile ukugcwalisa zonke izinkambu.



3. Manje vula idokhumenti ephathekayo. Uma igama lamakholamu alo lihlukile egameni lezinkundla ze-1c Directory, eziqukethe okufanelekile, khona-ke udinga ukuqamba kabusha la makholomu ku-Effelle ukuze amagama ahambisane ngokuphelele. Uma kukhona amakholomu etafuleni lapho kungekho analogues ku-Directory, kufanele asuswe. Kuthu, amakholomu anjalo "inani" nelithi "intengo". Kufanele futhi ingezwe ukuthi i-oda lokuhlelwa kwekholomu kudokhumenti kufanele lihambisane kahle nalolo olwethulwe ekusebenzeni. Uma amanye amakholomu aboniswa ku-bootloader awunayo idatha, khona-ke lawa makholomu angashiywa engenalutho, kepha inani laleyo kholomu lapho idatha kufanele ihambisane khona. Ukuze kube lula kanye nesivinini sokuhlela, ungafaka isici esikhethekile se-Excel ukuhambisa ngokushesha amakholomu ngezindawo.

   Ngemuva kwalezi zenzo zenziwa, chofoza isithonjana esithi "Gcina", esimelwe njenge-pictograph ekhombisa i-floppy disk ekhoneni eliphezulu kwesokunxele sewindi. Bese uvala ifayela ngokuchofoza inkinobho yokuvala ejwayelekile.



4. Buyela ewindini le-1C lokucubungula. Chofoza inkinobho ethi "Vula", okuboniswe njengefolda ephuzi.



5. Iwindi elivulekile lefayela liqala. Iya ku-Directory lapho idokhumenti ye-Excel itholakala khona, esidingayo. Ukushintshwa kwefayela okuzenzakalelayo sekubekwe ukwandisa i-MXL. Ukuze ubonise ifayela oyidingayo, kuyadingeka ukuhlela kabusha isikhundla esithi "Excel Sheet". Ngemuva kwalokho, sabela idokhumenti ephathekayo bese sichofoza inkinobho ethi "Open".



6. Emva kwalokho, okuqukethwe kuvulwa esiphathini. Ukuhlola ukunemba kokugcwaliswa kwedatha, chofoza inkinobho ethi "Gcwalisa Ukulawula".



7. Njengoba ubona, ithuluzi lokulawula ukugcwalisa lisitshela ukuthi amaphutha awatholakali.



8. Manje sithuthela kuthebhu "Izilungiselelo". Encwadini yokusesha "Sibeka uphawu emgqeni wokuthi wonke amagama afakwe kwisikhombi se-nomenclature azohlukile. Imvamisa kulokhu kusetshenziswa amasimu "athi" athikili "noma" igama ". Kuyadingeka ukwenza lokho ukuthi lapho ungeza izikhundla ezintsha ohlwini, imininingwane ayizange inikeze.



9. Ngemuva kwayo yonke imininingwane yenziwa futhi izilungiselelo zenziwa, ungaya ekulandeni okuqondile kolwazi ku-Directory. Ukuze wenze lokhu, chofoza idatha ethi "Landa idatha".



10. Inqubo ye-boot yenziwa. Ngemuva kokuyiqeda, ungaya kwinkomba ye-Nemenclature futhi uqiniseke ukuthi yonke imininingwane edingekayo ingezwa lapho.

Isifundo: Ungashintsha kanjani amakholomu ezindaweni eziku-Excel

Silandele inqubo yokwengeza idatha kwinkomba ye-nomenclature ohlelweni 1c 8.3. Kwezinye izincwadi namadokhumenti, ukulanda kuzokwenziwa ngomgomo ofanayo, kepha ngamanye ama-nuances umsebenzisi azokwazi ukuqonda ngokuzimela. Kufanele futhi kuqashelwe ukuthi ama-bootloalers ahlukene ahlukile angahluka inqubo, kepha indlela ephelele ihlala ifana: okokuqala, ukulanda imininingwane kusuka kufayili uye lapho ihlelwe khona, futhi kuphela lapho ingezwa ngqo ku-1C database.