excel dash board and datebase
- Status: Closed
- Prize: $30
- Entries Received: 16
- Winner: impawan29
Contest Brief
Using the sample excel sheet with:
Sheet is a data entry sheet to capture information via form and output the results.
Ideas are welcome to increase usability/use of use
Easy Dashboard showing overview(preferably one screen - no pivot table is possible)
Top 5 (in order) responses
Bankers (number of leads they have completed)
Totals for each type, source, response
Total Loan Amount for each month
When worksheet opens a VBA form pop up and displays check boxes for each of the Backend options - when submit button is pressed inserts data into the correct month tab and updates dashboard
Tabs for each month
Can add/remove/update backend data
Snap Shot of Year to Date Loan per Month
Need the persons to work with me to get the usability correct.
further projects needed in the future
Recommended Skills
Employer Feedback
“excellent work”
nab7861, Australia.
Top entries from this contest
-
impawan29 India
-
amwazeindia India
-
impawan29 India
-
blui88 India
-
Usman533 Pakistan
-
hosamhasan96 Egypt
-
nisarg21 India
-
akshitarajesh90 India
-
iqbalFayez Bangladesh
-
mtdevil369 Bangladesh
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!