The use of spreadsheets to increase the effectiveness of running an estate

V Sloveniji se število kmetijskih gospodarstev od leta 2000 zmanjšuje. Eden od razlogov za ta proces je nedvomno tudi zastarel način vodenja posesti, ki žal še vse prevečkrat temelji zgolj na dolgoletnih izkušnjah gospodarja, ki pa niso nikjer zapisane in se prej ali slej izgubijo. Sodobno kmetijsko gospodarstvo mora biti vodeno kot podjetje z ustrezno informacijsko podporo. V nalogi je prikazana zasnova informacijske podpore v obliki preprostih povezanih elektronskih preglednic s katerimi lahko relativno enostavno in zanesljivo zelo povečamo učinkovitost vodenja posestva. V osnovnih tabelah zbrane podatke o gospodarstvu, kot so podatki o gerkih, strojih, zaposlenih, itd., uporabimo za hitro in enostavno vnašanje zapisov v tabelo o vsakodnevnih delovnih procesih. Zbrani zapisi nam kasneje omogočajo enostavne in učinkovite analize po stroškovnih nosilcih za določeno časovno obdobje. Prava vrednost zbranih zapisov se pokaže šele po določenem časovnem obdobju (eno leto), ko je na osnovi zapisov, zbranih v preteklem obdobju (letu), že možno vnaprej planirati delovne procese za tekoče leto. Prikazana zasnova informacijske podpora že v prikazani osnovni obliki predstavlja dobro osnovo za oblikovanje lastnega geografskega informacijskega sistema (GIS) in zelo učinkovito orodje za povečanje učinkovitosti vodenja posestva. Za uporabo v praksi se mora pred uporabo še dodelati in prilagoditi specifičnim pogojem posameznega posestva.In Slovenia, the number of farming economies has been falling since the year 2000. One of the reasons for this process is without a doubt the old fashioned method of running the estate which is sadly still based on the long term experiences of the landlord which are not written anywhere and get lost sooner or later. The modern farming economy has to be run as a company with an appropriate informational support. In the diploma work a informational support is presented in forms of simple connected spreadsheets with which we can relatively easily surely insure the effectiveness of running the property. In the basic spreadsheets there are information regarding economy such as machines, employees and so on. We use these for a fast and simple input of data regarding everyday processes. The collected data later enable us simple and effective analysis of costs for a certain time period. The correct value of the gathered data is visible after a longer period of time (one year) when the data helps us plan the new work processes for the running year. The given informational support even in its basic form represents a good basis for forming a own geographical informational system (GIS) and is also a very good tool to increase the effectiveness of running the property. To be used in practice the system needs to be adapted to specific conditions of each individual property