Matlab GUI to Excel - repost

Closed

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 (this is the keyword for the search)

-one push button named Search (tag=searchrecord)

-one push button named Load (tag=loadrecord)

-a table that shows 7 rows of data read from an Excel sheet called myDatabase saved in C:\project with having the following titles for the columns:

(Index, Last Name, First Name, DOB, Sub ID, Group #, Procedure Date, DOB, Badge, Last Modified)

Index starts from 1 incrementally and is an integer. Columns are re-arrangeable and sortable. Must be able to edit all cells

except for "Last Modified" and "Badge" by double clicking.

-one push button named Edit (tag=editrecord)

-one push button named Save Changes (tag=saverecord)

-one push button named Delete Record (tag = deleterecord) which is only visible when Edit buton is pressed.

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). Matlab must use GUIDE for the GUI.

Thanks!

Skills: Database Administration, Excel, Matlab and Mathematica, SQL, Visual Basic for Apps

See more: vba load, text string search, search text string, matlab developer, excel vba developer, vba right, right vba, matlab all, excel 2013 vba, developer in excel, save to excel, matlab with gui, MATLAB GUI, matlab excel, matlab + it, list to excel, gui matlab, excel duplicate, excel developer, excel 2013, button to load data from, excel vba read page, project database vba excel, vba gui project, mathematica data

Project ID: #4128218

17 freelancers are bidding on average $191 for this job

wahab14

Hi there, I can do it

$225 USD in 7 days
(15 Reviews)
5.0
zoltannagy

Hi. Matlab expert, let's discuss.

$400 USD in 5 days
(5 Reviews)
4.6
VolKa

I am sure can do this. Read PM, please.

$150 USD in 5 days
(15 Reviews)
4.0
hasnatkhurshid

Hi; I can do it for you :)

$200 USD in 15 days
(8 Reviews)
3.8
anujgargiitk

Hi, I have done several projects in Matlab and can do this very easily for you. Please check my profile for more details. Regards

$200 USD in 5 days
(4 Reviews)
3.7
waseemabbas05

Hi I am an experienced MATLAB developer, skilled in GUI development and data reading and writing from any offline platform (excel, text, images). I can help regards

$170 USD in 7 days
(3 Reviews)
3.7
jumbojack

Hello, Matlab expert here. I have sent you a message(PM). Please have a look. I would be glad to work on your project.

$250 USD in 7 days
(9 Reviews)
3.6
talent204

Hi.Can i help?

$190 USD in 3 days
(1 Review)
3.2
nmlemus

Is very late for me right now but tomorrow morning I am goind to send you my GUI prototype. And then you can see if I am the right candidate. I know Matlab very well and work with Matlab and Excel is very easy. Regar More

$150 USD in 2 days
(2 Reviews)
2.4
mvlp

Hi, I do have many skills related with your project. Please consider my offer. Thanks

$90 USD in 2 days
(3 Reviews)
2.2
picMaster100

I like to help. Give me more details.

$150 USD in 5 days
(0 Reviews)
0.0
DonMD

Please see attached file in PM

$220 USD in 3 days
(0 Reviews)
0.0
betaenergy

Dear Sir, We are Reserach and Development company whose working area are : -Digital Motor Control -Analog Design -Electronic Design -Power Electronics -PCB design -Embedded system -Matlab -Simulation of ha More

$200 USD in 4 days
(2 Reviews)
0.0
rahuls4u

Project will be executed by a team of MATLAB experts. All test scenarios with 100% functional coverage will be shared. 3 months of free support. Project Schedule: 1) Share Prototype in 2 day 2) Share temporary delive More

$200 USD in 4 days
(0 Reviews)
0.0
michealjohn2304

Hi, I very good in Matlab & Excel VBA programming. Please give me a chance. Thanks

$80 USD in 3 days
(0 Reviews)
0.0
deepakjain1904

hey, i can do this..please check your PM

$100 USD in 1 day
(0 Reviews)
0.0
ma23

Hi,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

$150 USD in 3 days
(0 Reviews)
0.0
hpmca265

hi i'm interested in your project.

$230 USD in 10 days
(0 Reviews)
0.0
mojo23vw

looks straight forward enough

$250 USD in 2 days
(0 Reviews)
0.0