Matlab GUI to Excel

CLOSED
Bids
30
Avg Bid (USD)
$196
Project Budget (USD)
$30 - $250

Project Description:
I need a very simple MATLAB gui (R2012b) that connects with an Excel database (via VBA) for load and save functionality.
The Matlab GUI has to have 2 pages with their own tabs (named "first page", and "second page" that would
get highlighted when each tab is selected so it is obvious which page we are in) with the following components:

Page1:
-one push Button labeled "Load Record", tag = loadrecord on the top of the 1st page
-6 edit boxes labeled (Last Name, First Name, Sub ID, Group #, Procedure Date, DOB), in the 1st page
-The corresponding tags of (lastname, firstname, subscriberid, groupnumber, procedure_date, dob)
-one push Button labeled "Save Record", tag = saverecord at the bottom of the 1st page

all edit boxes are Strings.

Page2:
-one pulldown menu consisting of (Last Name, First Name, Sub ID, Group #, Procedure Date, DOB)
-one edit box to enter a text String
-one push button named Search (tag=searchrecord)
-a table that shows 5-10 rows with having the following titles for the columns:
(Index, Last Name, First Name, DOB, Sub ID, Group #, Procedure Date, DOB, Last Modified)
Index starts from 1 and is integer. Columns are arrangable and sortable. Must be able to edit all cells
except for "Last Modified" by double clicking.
-one push button named Load (tag=loadrecord)
-one push button named Save (tag=saverecord)

General idea is to Save records from Matlab GUI into an Excel sheet and Load records back into Matlab GUI from Excel sheets.
During the Save and Load there are certain things that have to be checked such as duplicate records and empty cell and such. I will provide a detailed functionality list for every component mentioned above in the two pages once I choose the right candidate. The best overall developer with the fastest developing time will win. If you take more than a week to develop this please don't contact me.

You must provide all the corresponding files (.m, .fig, Excel file).

Thanks!

Skills required:
Excel, Matlab & Mathematica, SQL, Visual Basic for Apps
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 450
in 9 days
$ 240
in 10 days
Hire bchandra1955
$ 250
in 15 days
Hire hmramezani
$ 250
in 3 days
$ 200
in 5 days
$ 150
in 5 days
$ 500
in 20 days
Hire armand2010
$ 150
in 2 days
$ 120
in 5 days
$ 200
in 3 days