The claims I make above are NOT exaggerated. They are in fact based on my personal experiences doing the foregoing (a). As an manager in the challenging, fast_paced manufacturing work environment of a corporate multinational (b). As a solutions developer for individuals and businesses who use MS Excel for their work.
How A Well Known Corporate Multinational Used Spreadsheet Tracking/Automation To Repeatedly Cut Spending _ And Increase Profits. During my graduate training(while in paid employment), I was redeployed from Guinness Nigeria Plc's corporate headquarters training office(in Lagos) to the Benin brewery training department (in Edo state), where I was assigned the _ additional _ job of using a custom Lotus macros driven Variable Cost Analysis spreadsheet application to generate brewery reports for dispatch to headquarters.
A person with proven competence in this area CAN become "notorious" for developing spreadsheet applications, which eliminate drudgery from the process of using MS Excel to handle large amounts of data. Typically, work that takes hours or days will suddenly take minutes or seconds to finish.
This last point in my opinion is ONE major benefit you must seek to extract, if you choose to engage the services of a developer. S/he should be able to help you develop (in_house) expertise needed to maintain the application AFTER s/he is gone. If you fail to ensure this, all your cost_savings from using the application might end up being spent paying the developer to maintain the application over time in the future!