GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Excel to Database GUI Conversion (Email xfer of data)

   Click here to post similar project

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

Status: Closed (Selected Service Provider)
Selected Providers: selected service provider anamchhabra
Budget: $250-750
Created: 03/11/2008 at 22:32 EDT
Bidding Ends: 03/25/2008 at 22:32 EDT
Project Creator: RMBULL View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
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
Report violation
Job Type:
  • Excel
  • Java
  • Windows
Database: (I don't know)
Operating system: MS Windows
Bid count: 43
Average bid: $ 470

 

Related project
 
NEED a Custom website made Featured
posted by flyeststyle
Budget: $750-1500
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 3

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
diy286
View PM Post PM
$ 500 7 days 03-12-2008 02:53 EDT 9.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/10
(59 reviews)
Dear sir, I am very interested in your project, Please see PMB for more details. Thanks. Best Regards.
imranamin
View PM Post PM
$ 650 45 days 03-12-2008 04:16 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(28 reviews)
Kindly Check PM . Can do it as per yr needs
svet63
View PM Post PM
$ 300 10 days 03-12-2008 09:25 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(19 reviews)
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.
wsh2
View PM Post PM
$ 699.95 7 days 03-12-2008 07:03 EDT 9.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/10
(15 reviews)
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://getafreelancer.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.
krishnadastp
View PM Post PM
$ 750 15 days 03-12-2008 00:10 EDT 9.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/10
(14 reviews)
I can do this
VLADNOVA
View PM Post PM
$ 495 14 days 03-12-2008 08:33 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(8 reviews)
I'll be glad to get this job done for You, Sir. Please see PM for important information. Respectfully, Vlad
KellogITSolution
View PM Post PM
$ 250 7 days 03-13-2008 01:13 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(7 reviews)
Hello Plz check your PMB for my bid. Regards John
wedoitforyou
View PM Post PM
$ 350 45 days 03-22-2008 00:17 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(6 reviews)
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
trupti
View PM Post PM
$ 500 10 days 03-12-2008 07:03 EDT 9.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/109.75/10
(4 reviews)
Kindly check PMB.
toscoreplus10
View PM Post PM
$ 500 45 days 03-12-2008 07:00 EDT 9.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/109.67/10
(3 reviews)
Details in PM. Thank you.
mdkass
View PM Post PM
$ 333 21 days 03-19-2008 18:21 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(3 reviews)
I like the Idea of your project,and I would like to do it for you.
DaBEAT
View PM Post PM
$ 550 15 days 03-12-2008 07:19 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(2 reviews)
Got huge experience.
msoftsolution
View PM Post PM
$ 250 5 days 03-12-2008 08:34 EDT 9.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/10
(2 reviews)
Hi, we can do it
Jenyphur
View PM Post PM
$ 600 7 days 03-12-2008 08:12 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
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
Arcady
View PM Post PM
$ 499 10 days 03-12-2008 08:16 EDT 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
I understand your task. Please, see PMB.
minyun
View PM Post PM
$ 300 5 days 03-12-2008 10:03 EDT 9.05/109.05/109.05/109.05/109.05/109.05/109.05/109.05/109.05/109.05/10
(20 reviews)
Hi. I have much experience in this same task. Please let me do it for you. Thanks
anamchhabra
View PM Post PM
$ 300 10 days 03-18-2008 13:21 EDT 2.00/102.00/102.00/102.00/102.00/102.00/102.00/102.00/102.00/102.00/10
(1 reviews)
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
estebansalsano
View PM Post PM
$ 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.
AanvikG
View PM Post PM
$ 600 10 days 03-12-2008 01:57 EDT (No Feedback Yet)
Please see PMB. Thank you
manjuram
View PM Post PM
$ 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
MohamedNiyaz
View PM Post PM
$ 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
ajay155
View PM Post PM
$ 589 15 days 03-12-2008 11:04 EDT (No Feedback Yet)
hi, Please see PMB, Thanks
sankumarsharma
View PM Post PM
$ 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.
rajbirydv
View PM Post PM
$ 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
karthika2000
View PM Post PM
$ 652 15 days 03-12-2008 15:00 EDT (No Feedback Yet)
expecting the earliest start, R.Sundareswaran
chbohm
View PM Post PM
$ 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
gsrivaishnavi
View PM Post PM
$ 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.
Spiritware
View PM Post PM
$ 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
segeyplus
View PM Post PM
$ 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.
mjohnson61
View PM Post PM
$ 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
venkatramanas
View PM Post PM
$ 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.
dona765
View PM Post PM
$ 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.
ambar
View PM Post PM
$ 400 60 days 03-16-2008 14:58 EDT (No Feedback Yet)
Hi , Please see my PM.
rohit1979
View PM Post PM
$ 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.
nkarthick
View PM Post PM
$ 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
erictnorris
View PM Post PM
$ 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.
crowndot
View PM Post PM
$ 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.
ifteebuet
View PM Post PM
$ 300 10 days 03-21-2008 16:13 EDT (No Feedback Yet)
Please check the PM
bluekart
View PM Post PM
$ 250 5 days 03-22-2008 05:20 EDT (No Feedback Yet)
Please see PMB, Best Regards,
shivdeepreddy
View PM Post PM
$ 250 7 days 03-23-2008 13:50 EDT (No Feedback Yet)
Please see PMB
sarathiflex
View PM Post PM
$ 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.
kgsoft
View PM Post PM
$ 299 5 days 03-25-2008 11:47 EDT (No Feedback Yet)
i am interested
mastervision