It never fails to amaze me how many seed businesses are reliant on spreadsheets to run their seed production and processing operations. Spreadsheets are great, flexible and certainly have a place in the world for doing the things spreadsheets are good at doing â€” like formatting charts and graphs, ad-hoc analysis, and creating simple models â€” but using them for things they are not intended for could be damaging.
Spreadsheets fall short in the following areas:
Reporting:Â Sorting through multiple spreadsheets and countless numbers and transactions to compile the data can be confusing and very, very time consuming. To run a business successfully you need to have full control of your data.
Accuracy:Â Spreadsheets do not standardize processes across the business, so everyone does their own thing in their own way. This means that the data is inaccurate, out of date and not uniform with other data in other spreadsheets.
Accessibility:Â Different people need access to reports and data at any given moment. Having quick, easy access to data is the only way to keep the business running smoothly. If that data is in disparate spreadsheets in different places, this can be disruptive to processes and ultimately cost money.
Productivity:Â How much time do the people using these spreadsheets spend tracking and fixing issues? A study recently showed that regular â€˜spreadsheetâ€™ users were spending up to 18 hours per month doing just that. Thatâ€™s 18 hours per month spent doing non-productive activity.
Security & data integrity:Â Where are these companies keeping their spreadsheets? On a server? On someoneâ€™s laptop? What if you lose the spreadsheet and donâ€™t have a back-up system in place? And how do you know you are updating the latest version of the spreadsheet? Which version of the spreadsheet do you look in to get a single version of the truth?
Regulatory requirements:Â Seed companies are audited regularly to ensure that they are recording the information adequately. If the spreadsheets cannot be relied on for accuracy, this is a major risk and should be of huge concern to a seed business.
The only real way to have accurate and reliable data for reporting and running efficient processes in a business is to invest in a centralized and integrated system. An integrated system enables you to free people from the drudgery of wrestling with spreadsheets and allow them to focus on the important and productive things that would help to grow the business profitably.