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