(UM)
-
Uporaba makro-jev za prenos podatkov Excelovih tabel [Elektronski vir] : diplomsko delo visokošolskega strokovnega študijskega programaMitnjek, TilenBrez računalniške podpore je dandanes skoraj nemogoče poslovati, zlasti v večjih in naprednejših podjetjih. S pomočjo digitalne tehnologije so delovni procesi izvedeni hitreje, natančneje in lažje. V ... logističnem oddelku podjetja, ki izdeluje male hišne gospodinjske aparate, v veliki meri uporabljajo računalniški program Microsoft Excel, s katerim izdelujejo analize, hranijo podatke in načrtujejo odpreme. Obdelovani podatki se tako hranijo v podatkovnih tabelah, med katerimi so si določene precej podobne in imajo vpisane enake podatke. V določenih primerih imajo ti podatki dodeljeno referenco iz druge tabele in se vrednosti samodejno prepisujejo, kar velja le v primeru statičnih oblik podatkovnih tabel. V primeru dinamične strukture podatkovne tabele je treba te podatke vnesti ročno. Posnetek stanja bo omogočil vpogled v obstoječe izvajanje procesa in povezavo podatkov posameznih tabel, na podlagi česar bomo izvedli kritično analizo. Predlagano rešitev nameravamo izpeljati z uporabo makrov, ki bodo prevzeli vlogo prenosa podatkov na ustrezno območje in ki jih bomo priredili Excelovi tabeli. Ker makri potrebujejo sprožilec, bomo v ta namen dodali interaktivni objekt, ki ob kliku nanj aktivira prenos podatkov. Pregled pridobljenih informacij bo razkril morebitne predloge izboljšav povezovanja podatkov med posameznimi tabelami.Type of material - undergraduate thesis ; adult, seriousPublication and manufacture - Celje : [T. Mitnjek], 2023Language - slovenianCOBISS.SI-ID - 184909827
Author
Mitnjek, Tilen
Other authors
Jereb, Borut, 1962- |
Orel Šanko, Nena
Topics
Excel |
podatkovna tabela |
prenos podatkov |
makro |
avtomatizacija |
Excel |
data base |
data transfer |
macro |
automatization
![loading ... loading ...](themes/default/img/ajax-loading.gif)
Shelf entry
Permalink
- URL:
Impact factor
Access to the JCR database is permitted only to users from Slovenia. Your current IP address is not on the list of IP addresses with access permission, and authentication with the relevant AAI accout is required.
Year | Impact factor | Edition | Category | Classification | ||||
---|---|---|---|---|---|---|---|---|
JCR | SNIP | JCR | SNIP | JCR | SNIP | JCR | SNIP |
Select the library membership card:
If the library membership card is not in the list,
add a new one.
DRS, in which the journal is indexed
Database name | Field | Year |
---|
Links to authors' personal bibliographies | Links to information on researchers in the SICRIS system |
---|---|
Mitnjek, Tilen | ![]() |
Jereb, Borut, 1962- | 10011 |
Orel Šanko, Nena | 55073 |
Source: Personal bibliographies
and: SICRIS
Select pickup location:
Material pickup by post
Delivery address:
Address is missing from the member's data.
The address retrieval service is currently unavailable, please try again.
By clicking the "OK" button, you will confirm the pickup location selected above and complete the reservation process.
By clicking the "OK" button, you will confirm the above pickup location and delivery address, and complete the reservation process.
By clicking the "OK" button, you will confirm the address selected above and complete the reservation process.
Notification
Automatic login and reservation service currently not available. You can reserve the material on the Biblos portal or try again here later.
Subject headings in COBISS General List of Subject Headings
Select pickup location
The material from the parent unit is free. If the material is delivered to the pickup location from another unit, the library may charge you for this service.
Pickup location | Material status | Reservation |
---|
Reservation in progress
Please wait a moment.
Reservation was successful.
Reservation failed.
Reservation...
Membership card:
Pickup location: