Phase I: Immediate
I am using an Excel workbook with 15-spreadsheets as a "form" tool to be completed by vendors. There are about 350 weighted "questions" posed on these spreadsheets, but not all vendors need to complete all spreadsheets or all questions, based on the service they provide. In the end, all the applicable spreadsheets are totaled and the vendor is provided a "score" and deadlines to close open (or low scoring) items.
In short, the spreadsheet is confusing to just about everyone but me and I need to have developed some sort of intuative email-able GUI (Access? Java?) that will only present the applicable questions from the spreadsheets based on a primary questions (type of business, location, etc...) but return the data to me (via email) in a usable and actionable file that I can develop reports from.
The project will require that the programmer covert about 350 lines of questions to the GUI form into buttoned responses (e.g. 0,1,2); create a few "fill in the blanks" lines (e.g. name of business, location, telephone number, etc); and pop-ups for non-compliance responses (e.g. anticipated correction date, owner of process, etc.).
From the user perspective, the process should be very intuative. The GUI should ask some basic information, and based on the vendor response, present a series of questions with buttoned responses (typically 0=does not meet standard; 1=meets standard, and 2=exceeds standard). Any question not scoring 1 should be presented with a pop-up GUI that records corrective action or justification.
From my persepctive, I need the data back in some sort of actionable format (MS Office?) whereby I can create reports of compliance or non-compliance. Moreover; I will need the ability to remove or add questions in the future.
Possibly later this year, budget allowing, would be the inclusion of supporting documents (doc, jpg?) associated with questions not scoring 1 and triggers (email?) based on missed correction deadlines.
I really have no idea what this "should" cost - but am looking for a fair price and delivery.
Thanks for your consideration,
42 freelancers are bidding on average $463 for this job
Sir, I am VBA Developer, i have done more project like this. I can do this project. Please give me a chance to accompolish the task. Thanks & Regards, Karthick