Software developer needed for input/ search engine

We are a strutcural design company looking for a developer who can provide a quote and complete the following task:

We are happy to arrange a meeting for more details.

Create a program which does the following:

*Allows the user input of structural data into a large spreadsheet

*Allows the user to fill out a form which will search for matches (with addditional conditional criteria) within the large spreadsheet and return matches or promp the user that it is missing.

Ideally we would want this to be in VBA but open to suggestions.

Essentially what we want to do is fill out the program on the left with the relevant inputs. Then the program using this information will look up a database and extract the information we require. It will then spit out the summary report with the information we need.

We want advice on what program we should use to code taking into account the speed of output. Would you recommend any other language than VBA? The reason why we thought VBA would be good is because we were going to put the database information into excel. However, if you have any other recommendation of a database program please let me know.

We will have 1000+ entries which corresponds to the jobs that we have done into the database. Each entry will have its set of parameters and sizes used for each element.

We are thinking of having different tabs in the database to help organize this.

For example one tab will possess the following columns:

This is for Purlins (THIS IS THE ELEMENT):

Parameter 1 Parameter 2 Parameter 3 Size
Job Number Wind Speed Snow Load Spacing Used Section Size
11111 40 0.9 600 B8075(2)
11112 42 0 800 B8095

The macro/program will access each column to find the matching value we have inputted into the input sheet and pull out the USED SECTION SIZE which is the final product we require (this will come out in the report).

NOTE: developers must be NZ, Auckland based

Taidot: Yleiset tehtävät, Ohjelmistokehitys

Sijainti: Auckland, New Zealand

Näytä lisää: stackoverflow job listing price, best tech job boards 2016, github job board, best search engine for software developers, stack overflow job board, best tech job boards 2017, web developer job board, best job sites for software engineers, software developer needed in nagpur, software developer needed for amsaar international, python software developer needed, java software developer needed, freelance software developer needed, software developer needed, domo business toolkit software developer needed

Tietoa työnantajasta:
( 0 arvostelua ) New Zealand

Projektin tunnus: #15845291

10 freelanceria on tarjonnut keskimäärin 4318 $ tähän työhön


Well... you can do it in Excel or you can let me write you an application in C# To see an example of controls I would use have a look here [url removed, login to view] Relevant Skills and Lisää

4000 $ NZD 30 päivässä
(9 arvostelua)

Hello I read your job description and attached screenshot carefully. I think PHP / MySQL is good option for your project more than VBA. For excel sheet, I will convert to CSV and import to database. Relevant Skills an Lisää

4705 $ NZD 30 päivässä
(3 arvostelua)
4444 $ NZD 30 päivässä
(1 arvostelu)

Thanks for inviting me to bid on your project. I'm based in Wellington. Can we discuss further on chat as I have few questions. Thanks, Sujal

4111 $ NZD 15 päivässä
(1 arvostelu)

If you're interested in top quality work and communication please read on! You can feel free to check out my portfolio available through my freelancer profile. Relevant Skills and Experience My portfolio is very in de Lisää

4444 $ NZD 30 päivässä
(0 arvostelua)
4444 $ NZD 30 päivässä
(0 arvostelua)

Dear friend, We read through the job details extremely carefully. We wish to have a discussion with you. We have some questions for you. Bluecoded Team Relevant Skills and Experience PHP Proposed Milestones $1500 Lisää

4444 $ NZD 30 päivässä
(0 arvostelua)

Hello, I read the requirement and would like to discuss few points. Let me know your available time so that I can present my suggestions to you to complete the project with quality. Relevant Skills and Experience I ha Lisää

4588 $ NZD 45 päivässä
(0 arvostelua)

I'm local, capable and will advise the customer on development of a sustainable solution. I'm not a data professional that's looking for monetary benefit, I am here to help businesses prosper and see that impact commu Lisää

3000 $ NZD 10 päivässä
(0 arvostelua)

I have experience working with VBA in both MS Access & MS Excel. I would suggest using VBA with Excel, and utilising Index/Match formulae to retrieve the necessary records. I also have considerable experience in MS Lisää

5000 $ NZD 50 päivässä
(0 arvostelua)