Project Detail

Excel to Database GUI Conversion (Email xfer of data)  

Excel to Database GUI Conversion (Email xfer of data) is project number 236365
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: anamchhabra

Budget: $250-750

Created: 03/11/2008 at 22:32 EDT

Bid Count: 43

Average Bid:
$ 470

03/25/2008 at 22:32 EDT

Project Creator: RMBULL
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

Description

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

Messages Posted:3 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

500

7 days

03-12-2008 02:53 EDT

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

help

 

650

45 days

03-12-2008 04:16 EDT

Kindly Check PM . Can do it as per yr needs

help

 

750

15 days

03-12-2008 00:10 EDT

I can do this

help

 

300

10 days

03-12-2008 09:25 EDT

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, etc., etc. In short my bid is for converting your spreadsheet to an user friendly one. Regards, Svet.

help

 

300

5 days

03-12-2008 10:03 EDT

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

help

 

699.95

7 days

03-12-2008 07:03 EDT

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 installation package is required. This would also facilitate distribution by email (you indicated you would like an email response, which infers that the client can also receive email in.) Clearly more discussion is needed. Hello my name is Bill.. I am a VB.Net, VB6, VBA, VBScript, SQL, MsAccess, MsExcel, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed quite a few GAF projects, so you can find additional references for me here: http://elance.com/users/feedback_172391.html I have 20+ years of hands-on Programming and Business Information System experience to include Internet interfacing applications. I have a BS in Accounting / Marketing Minor; graduating with the highest of honors. I am located in Easton PA USA (halfway between Philadelphia and New York City). American english is my only language. I look forward to assisting you in achieving ALL of your goals in your every endeavor. Respectfully, Bill.

help

 

495

14 days

03-12-2008 08:33 EDT

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

help

 

250

7 days

03-13-2008 01:13 EDT

Hello Plz check your PMB for my bid. Regards John

help

 

400

60 days

03-16-2008 14:58 EDT

Hi , Please see my PM.

help

 

350

45 days

03-22-2008 00:17 EDT

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/oracle/sqlserver and mysql as well. We are going to fire you with all our queries in the first 2/3 days then start developing the application. PM us if you are interested. Admin, WeDoIT4U

help

 

500

10 days

03-12-2008 07:03 EDT

Kindly check PMB.

help

 

333

21 days

03-19-2008 18:21 EDT

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

help

 

550

15 days

03-12-2008 07:19 EDT

Got huge experience.

help

 

500

45 days

03-12-2008 07:00 EDT

Details in PM. Thank you.

help

 

250

5 days

03-12-2008 08:34 EDT

Hi, we can do it

help

 

600

7 days

03-12-2008 08:12 EDT

I believe this application should be a web front end with a database back end to store results. That way, you can pull the data back out in any format, access, excel , word, reporting services, etc. With a web front end, there is nothing to deploy so it will solve both of your issues. I'm in Phoenix, AZ and can definitely complete this project for you. Jen

help

 

499

10 days

03-12-2008 08:16 EDT

I understand your task. Please, see PMB.

help

 

300

10 days

03-18-2008 13:21 EDT

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 build the weighted questions dynamically in a user friendly format with pop up feature. Response will be an email with the option to store it in ur database. Supporting Environment Programming language - Java Database - MS Access OS - Windows

help

 

600

10 days

03-12-2008 01:57 EDT

(No Feedback Yet)

Please see PMB. Thank you

help

 

400

25 days

03-17-2008 01:44 EDT

(No Feedback Yet)

Hello Sir/Madam, We are in to a telecom software company dedicated to web based services and located in the southern part of Asia that is India. We specialize in providing high technology, end to end solutions in web development and graphic designs. ASP.net with C#, .net,My SQL, SQL Server,JAVA,J2EE,JAVASCRIPT are some of the technologies we expertise on. Impeccable works with delivery on time are some of the services that we offer. We will be highly obliged if given the opportunity to be of service to you. For more details please check PMB and also we attached some websites we developed, please check it. Thanking you Manjunath R

help

 

750

30 days

03-12-2008 09:29 EDT

(No Feedback Yet)

hI We are much exptised on this kind of work .we built intergation tool for SAP system.which read and take input from excel,plz go through our PM. regards Niyaz

help

 

589

15 days

03-12-2008 11:04 EDT

(No Feedback Yet)

hi, Please see PMB, Thanks

help

 

500

15 days

03-12-2008 11:24 EDT

(No Feedback Yet)

hi, we have a lot of experts. so if u send me that kind of spreadsheets than i will easily conform u about the bid amount and days.

help

 

650

7 days

03-12-2008 13:37 EDT

(No Feedback Yet)

hi i will do ur job withen 7 days max i worked 5 time on same project of a indian company Rajbir

help

 

652

15 days

03-12-2008 15:00 EDT

(No Feedback Yet)

expecting the earliest start, R.Sundareswaran

help

 

500

20 days

03-12-2008 19:30 EDT

(No Feedback Yet)

Hi, I have several ideas in order to fulfill your requirement. I am an experienced Java developer with more than 4 years developing stand alone and web-based application. Kind Regards

help

 

750

7 days

03-12-2008 19:38 EDT

(No Feedback Yet)

Hi im a computer enginner, i suggest for this project implement it in a web plataform, so your vendors can complete it online. Is faster and more easy to upgrade. You don´t have trouble installing it.

help

 

750

30 days

03-12-2008 20:25 EDT

(No Feedback Yet)

I am 10 year experienced software professional developing customized software to the clients like you. I also suggest more options according to their requirements. And also, I deliver it to the client as a packaged software with installation. Here in your project I need to know more details. Pl send the detailed excel sheets to me. We also provide option to show your logo whatever it may be, and also you can change it in future. This software will be deployed as installation where you can send it to your vendors freely without source code. Depending on actual details the bid amount may change.

help

 

250

10 days

03-13-2008 14:41 EDT

(No Feedback Yet)

Hi, I already have done the same kind of project for my previous client. so i can deliver you requirement in the form og java GUI based program with in estimated time. Give me chance and see the performance i deliver to u. Faithfully, Saravanan Velusamy

help

 

250

5 days

03-13-2008 17:39 EDT

(No Feedback Yet)

Hello. I suppose I have quite simple solution for your problem. Look PM please. Sergey S.

help

 

450

21 days

03-15-2008 02:05 EDT

(No Feedback Yet)

if i understand you're reqiurements i feel i can remedy this in access. Regards, Mike Johnson

help

 

400

15 days

03-15-2008 02:39 EDT

(No Feedback Yet)

hi, i have been working on this similar sinario. so if u send me that kind of spreadsheets to work on.

help

 

750

7 days

03-16-2008 05:42 EDT

(No Feedback Yet)

Hi, I have experience in application development and am an expert in Excel. I am interested in working on this project.

help

 

700

20 days

03-17-2008 01:08 EDT

(No Feedback Yet)

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

help

 

400

10 days

03-17-2008 01:21 EDT

(No Feedback Yet)

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

help

 

300

14 days

03-17-2008 11:51 EDT

(No Feedback Yet)

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 someone rewrite the form program every time you have a new question. If you accept my bid, I would work with you to create a clean, modular program with an extremely user-friendly interface for the form "answerers", and create a clean program for you to create/modify questions.

help

 

275

20 days

03-21-2008 05:28 EDT

(No Feedback Yet)

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

help

 

300

10 days

03-21-2008 16:13 EDT

(No Feedback Yet)

Please check the PM

help

 

250

5 days

03-22-2008 05:20 EDT

(No Feedback Yet)

Please see PMB, Best Regards,

help

 

250

7 days

03-23-2008 13:50 EDT

(No Feedback Yet)

Please see PMB

help

 

700

14 days

03-25-2008 09:09 EDT

(No Feedback Yet)

Hi, I read your specification. I am extremely eager to take on this project. I have a good experience in Excel-VBA. I have done two projects using this. If you want i can send both of them. I have a good knowledge on Excel macro and can create charts pivot tables programmatically. I can assure you that you can experience 100% satisfaction and better quality of service from me.

help

 

299

5 days

03-25-2008 11:47 EDT

(No Feedback Yet)

i am interested

help

 

250

15 days

03-25-2008 17:50 EDT

(No Feedback Yet)

Please check your PM

help


    Bid on this Project