4 research outputs found
Recommended from our members
Book Review: Saving the Ranch. Conservation Easement Design in the American West, Anthony Anella, John B. Wright
No full textBook Review: Saving the Ranch. Conservation Easement Design in the American West, Anthony Anella, John B. Wright. Island Press, Washington, D.C. (2004).The Rangelands archives are made available by the Society for Range Management and the University of Arizona Libraries. Contact [email protected] for further information.Migrated from OJS platform March 202
Kirjanpitotilien avoimien erien tasaus- ja raportointiprosessin automatisointi Excel-makrolla
No full textOpinnäytetyön tavoite oli automatisoida Yritys X:n Tavaran vastaanotto / laskun vastaanotto -tilien tasaus- ja raportointiprosessi Excel-makroa hyödyntäen. Kyseinen prosessi suoritetaan kerran kuukaudessa manuaalisesti, ja siihen kuluu aikaa noin 2–3 tuntia. Automatisointi mahdollistaa prosessin tehokkaamman suorittamisen ja vapauttaa suorittajan muihin tehtäviin. Tavoiteajaksi prosessin suorittamiseen asetettiin Yritys X:n kanssa 45 minuuttia. Yritys X on suomalaisen kaupan alan yrityksen alaisuudessa operoiva taloushallinto-, palkanlaskenta- ja HR-palveluita tarjoava yksikkö. Tekijä oli opinnäytetyöprosessin aikana työsuhteessa toimeksiantajayritykseen, mutta makroa kehitettiin vapaa-ajalla.
Opinnäytetyössä kehitettiin makroa yhdeksän viikon ajan viikolta 37 viikolle 45. Makro valmistui tämän työn aikana kokonaisuudessaan. Se ajetaan osissa, jotka on jaettu prosessin eri vaiheiden mukaisesti. Osia on yhteensä 10. Makro tekee kaikki prosessiin kuuluvat työvaiheet itse tasauskirjauksia ja sähköpostien lähetystä lukuun ottamatta. Prosessin suorittajalle jää itselleen makron luomien luetteloiden ja sähköpostien oikeellisuuden tarkistus ja kirjausten tekeminen. Prosessi suoritettiin kokonaisuudessaan makroa käyttäen marraskuussa 2023 ja se todettiin toimivaksi. Jatkossa prosessia ei tarvitse siis enää suorittaa manuaalisesti. Makron ajoon kuluu aikaa noin kahdeksan minuuttia, joten ajajalle jää tarkistustyöhön ja kirjausten tekoon aikaa 37 minuuttia, jolloin ollaan vielä tavoitteessa.
Prosessin tehostamisen lisäksi tässä työssä luotua makroa voidaan mahdollisesti hyödyntää jatkossa toimeksiantajayrityksen muiden prosessien automatisoinnissa. Lisäksi tekijän oma osaaminen VBA-ohjelmoinnista ja Excel-makroista kasvoi huomattavasti. Myös opinnäytetyön julkisesta osuudesta voi olla hyötyä muille makrojen kehittämisessä ja luomisessa.The objective of the thesis was to automate the balancing and reporting process of Company X's Goods Receipt/Invoice Receipt accounts using an Excel macro. The process is performed monthly and manually, and it takes approximately 2-3 hours. Automation enables a more efficient execution of the process, freeing up the operator for other tasks. The goal was to reduce the time required for the process to 45 minutes and it was determined in collaboration with Company X. Company X operates as a finance, payroll, and HR services unit under a Finnish retail company. During the thesis process, the author was employed by the client company but developed the macro in their own free time.
The macro development took place over nine weeks from week 37 to week 45, and it was completed entirely during this thesis. The macro is executed in parts, divided according to the different phases of the process, with a total of 10 parts. The macro performs all the steps of the process, except for balancing entries and email sending. The operator is left with the verification of lists and emails created by the macro and making necessary entries. The entire process was carried out using the macro in November 2023, and it was found to be functional. In the future, the process will no longer need to be performed manually. The macro execution takes about eight minutes, leaving the operator with 37 minutes for verification and entry, thus meeting the goal.
In addition to streamlining the process, the macro created in this thesis could potentially be utilized for automating other processes within the client company. Furthermore, the author's proficiency in VBA programming and Excel macros significantly increased. The publicly available portion of the thesis may also be beneficial for others in the development and creation of macros
Real Election Count Application; Case Study: The 2nd Round Padang Election 2014
No full textThe author has conducted research in Padang Commission with the aim of knowing the addition of the current system to make it more optiomal future. In this study the authors use the method of Field Research is to conduct research directly into the field, in this case the authors plunge into Citizens and Agencies KPU Alone. From the results of the data collected, then the author uses Research laboratory methods that process the results of the research data in a computer laboratory. made the development of the information generated from the old system and there is the workings of the system itself by utilizing the computer as a means of replacing the tools and software used in data processing. This design is expected sistemyang authors can replace the old system, in order to achieve the level of effectiveness and efficiency higher. so that the design can be useful for the Commission Padang to obtain accurate results
The social poetics of place making : challenging the control/dichotomous perspective
No full textGrappling with the success of their business ventures and coping with the rise in number of new products FifeX was working on, operating out of their shared office in the St Andrews Technology Centre, the co-founders were feeling more ‘cramped’ than ever before. The decision was made to relocate. Although it was felt to be long overdue, much to their relief they finally moved to larger premises in Tayport in July, 2006. The activity of moving was a starting point for a number of place making activities.
Using the case of FifeX, this thesis explores the process of place making. It seeks to understand place making from ‘inside’ the activity of place making itself. The guiding research question in this thesis is, what happens -during place making- when people move into ‘new’ business premises? More specifically, this thesis asks the following questions: (i) what are the comparative advantages / disadvantages of the alternative ways of explaining place making? and (ii) which theory or combination of theories, has greater explanatory value in analysing place making / moving? The study, which uses FifeX as an empirical setting is best described as an in-depth qualitative narrative exploration, and thus narrates the unfolding processes of deciding to relocate, relocating, moving and place making.
Three different theoretical perspectives (control, engagement, polyphony) were applied, each in turn, to three separate (yet interrelated) instances of place making (a story about a wall, one about chairs, and one about a worktop) in order to cast fresh light on the constitutive talk-entwined-activities of place making. The study demonstrates that although efforts to control space may dominate the discourse and activities of place making, control only explains some of what happens during place making. The findings of the case suggest that place is the outcome of inhabitants’ ongoing experiences and understanding. This thesis argues that alternative theoretical perspectives (engagement and polyphony) are better at explaining what goes on. But because they do not operate ‘naturally’ within the dominant paradigm, it is noted that an alternative practice-based perspective is needed which combines the effectiveness of engagement and polyphony, with the attractiveness of control.
A model is presented to help reflect on place making which provides an alternative route for thinking about relocating, moving, and place making that is expected to create engagement and polyphony in a decent way. The proposed model is centred on thinking directed toward: (i) individual place, (ii) inside space, and (iii) what story(s) the space tell outsiders. The focus is on balancing the tensions that emerge from dialoging on these three aspects of space and place
