Create an input/output, information system to show and describe the financial health of the business with Microsoft Excel and/or related add-ons and include detailed support documentation on its use:
1) Automate passing email from Microsoft Outlook to Microsoft Excel
2) Format this email data to specs (TBA)
Requirements Importance Rating
1-------------3-------------5
low neutral very Low Maintenance
o Manuel data entry kept to minimum 3
o Automation maximized
Secure
o Restricted access
o Incoming email data obscured but can 4
be referenced in other workbooks
Reliable
o Checks to find errors against known data 5
Easy to Use
o Intuitive user interface 2
o Detailed dashboard to analyze data
Easy to Teach
o Minimum training time 1
Cheap
o Using just Microsoft Excel 2003 4
Networked
o Data linked to hard-copy images 4
Documentation
o Detailed on usage, tips/tricks, cautions/warnings 3
Need working, business-level prototype ready in two weeks maximum (Deadline A). Tweaks and additional features to be added after 3-day trial. Deadline B will be two weeks maximum after the trial period.