Custom spreadsheet solutions which survive long after the developer has "left the scene", are often those which users accept because they discover it _ among other benefits _ makes their work quicker and easier to do. That is why the best person to develop such solutions tend to be one who works in that area, and is therefore familiar with the way the manual system operates. S/he would have an "insider's" perspective of the best way to introduce automation other users will readily adopt _ even as it solves the identified problem(s).
So, (when considering the automation I speak about) do not think about spreadsheet documents containing one or two click_able buttons that allow a user print a page or copy some cells from one sheet to another. Instead, I want you to picture an application(or Entreprise Information System) that customises the appearance of your spreadsheet workspace(to take advantage of maximum screen capital available on your PC), and offers you custom "floating" data entry forms.
Variable Costs Control/Reduction was a strategy that worked extremely well for the company. Most memorable for me as a brewer, was the manner in which huge monetary savings/profit gains were made by successfully implementing variable cost reduction initiatives. For instance, a brewing ingredient switch was made to a more readily available local alternative which was many times cheaper, resulting in phenomenal savings and progressively increasing profit earnings even though the price of beer produced was not raised. This practice was routinely applied across the brewing and packaging processes in line with a well thought out plan.
In addition, visualise it having dynamic query/report drop menu interfaces, and a variety of custom buttons: for navigation(within and between worksheets), printing, data export (as PDF documents or spreadsheet files), saving, auto_data filtering, auto_charts plotting, auto_backup of files, user login authentication (for documents with sensitive or confidential content) etc.
excel spreadsheet examples
spreadsheet templates for business