Software developer needed for input/ search engine
$3000-5000 NZD
货到付款
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
项目ID: #15845291
关于项目
有8名威客正在参与此工作的竞标,均价$4309/小时
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
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 更多
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 更多
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 更多