In Progress

Excel to Database GUI Conversion (Email xfer of data)

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.

Phase II.

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,

RMB

Skills: Excel, Java, Windows Desktop

See more: gui excel, create gui excel, creating gui excel, standard programmer, service database access, questions ask, questions to, programmer spreadsheet, programmer email, programmer cost, need programmer cost, me excel, idea need programmer, gui number, covert file, cost programmer, cost format, ask excel, access vendor database, database gui conversion, create gui excel spreadsheets, spreadsheet gui database, database gui excel vba, spreadsheets database gui, gui inputs excel

About the Employer:
( 1 review ) Yorkville, United States

Project ID: #236365

Awarded to:

anamchhabra

I assure to provide you with two gui components - - admin for managing questions/ report building(basic version-can be enhanced on further request) - vendor Gui based on their location/business type response, will b More

$300 USD in 10 days
(1 Review)
3.0

42 freelancers are bidding on average $463 for this job

svet63

VBA developer since 1997. Here is a suggestion: keep Excel spreadsheet and make it user friendly via VBA. It can all be done with VBA: hiding questions from users, making all sorts of reports, emailing, putting a logo, More

$300 USD in 10 days
(64 Reviews)
6.7
minyun

Hi. I have much experience in this same task. Please let me do it for you. Thanks

$300 USD in 5 days
(47 Reviews)
5.7
fstudio

Dear sir, I am very interested in your project, Please see PMB for more details. Thanks. Best Regards.

$500 USD in 7 days
(59 Reviews)
5.6
wsh2

Good day RMB.. {smile} This is hard to quote without seeing the spreadsheet and without knowing the full means of distribution. My initial reaction is to clean up the GUI and keep this in Excel so that no installati More

$699.95 USD in 7 days
(21 Reviews)
5.5
imranamin

Kindly Check PM . Can do it as per yr needs

$650 USD in 45 days
(31 Reviews)
5.4
mdkass

I like the Idea of your project,and I would like to do it for you.

$333 USD in 21 days
(50 Reviews)
5.4
ambar

Hi , Please see my PM.

$400 USD in 60 days
(11 Reviews)
5.1
SICS

I can do this

$750 USD in 15 days
(6 Reviews)
4.6
VLADNOVA

I'll be glad to get this job done for You, Sir. Please see PM for important information. Respectfully, Vlad

$495 USD in 14 days
(7 Reviews)
4.3
trupti

Kindly check PMB.

$500 USD in 10 days
(8 Reviews)
4.1
DaBEAT

Got huge experience.

$550 USD in 15 days
(2 Reviews)
3.6
KellogITSolution

Hello Plz check your PMB for my bid. Regards John

$250 USD in 7 days
(8 Reviews)
3.5
wedoitforyou

Hi, We have a team of IT professionals with 4+ years of experience in developing and maintaining enterprise application in Java/J2EE. We have developers and designers who have worked on all major databases - db2/ora More

$350 USD in 45 days
(3 Reviews)
3.3
msoftsolution

Hi, we can do it

$250 USD in 5 days
(2 Reviews)
3.1
Arcady

I understand your task. Please, see PMB.

$499 USD in 10 days
(1 Review)
2.1
nkarthick

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

$400 USD in 10 days
(0 Reviews)
0.0
rohit1979

I think can be developed with good eye-catchy and well adversed features. We have a good string team who like to take challenges.

$700 USD in 20 days
(0 Reviews)
0.0
ifteebuet

Please check the PM

$300 USD in 10 days
(0 Reviews)
0.0
erictnorris

This sounds pretty easy, only reason I put it at 14 days is due to the tediousness related to the project. I am assuming you would also like a program to create your own questions too, so you would not have to have so More

$300 USD in 14 days
(0 Reviews)
0.0
crowndot

Sir, I have a good experience in conversion and can do the following.

$275 USD in 20 days
(0 Reviews)
0.0