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).
"Over_used/Over_spent"(Losses) and "Under_used/Under_spent"(Savings) _ on a monthly basis based on data entered, the program also automatically plotted charts showing trends over a 12 month period.
The assignment was not an accident. Before being redeployed to Benin brewery, I had been involved in "validating" the numerous complex formulas in the custom Lotus 1θι spreadsheet application during its development. The author _ Richard Chambers _ was at the time in charge(as Training Coordinator) of training new entrants, and upon discovering my keen interest in learning, often gave me his laptop to "proof" formulas, links etc. It was he who had told his counterpart in Benin brewery(Joe Sheehy) that I could help out with a problem they were having using the application. And I did resolve the problem _ resulting in my subsequently becoming responsible for the reports collation using the application.
To experience the type of automation I refer to, you can email FREE demos of sample automated Excel VB driven spreadsheet applications like Ƒ) a Training Tracking Database(TM), ƒ) a Fiveƕ) Year Income & Expense Monitor(TM) or Ɠ) an Export Packing List & Invoice Generator(TM) to yourself using the file mailer on my website.
blank spreadsheet templates
what is spreadsheet in excel
excel spreadsheet examples