Design and development of a VBA tool to process construction data
- or -
Post a project like this3991
£50(approx. $63)
- Posted:
- Proposals: 1
- Remote
- #249917
- Awarded
Description
Experience Level: Intermediate
Undertake a small project to develop a excel Visual Basic Application (VBA) tool to undertake a task.
The task is: Create a tool to support site clearance condition survey. To support this you are going to create a tool that collects the relevant data for each site via a VBA form, collates ongoing information on the data tab,
analyses and presents the analysis on the summary tab.
The project is to take the outline task presented and create a macro enabled excel file that
demonstrates understanding of advanced excel and the design and coding of a small VBA and
project.
There are many things to present, the spreadsheets itself, the VBA code, the data
collection form, the excel operations and the design tool outcomes.
Need to demonstrate that you have carefully considered the task and undertaken an
appropriate design prior to coding the VBA tool.
Your tool needs to work. The tool should; present a form, collate the data into the data tab, undertake simple analysis using appropriate excel techniques and report a summary. The code should be neatly presented and clearly formatted.
This project needs to be done as quickly as possible, completed by 12:00 midday on the 6th May absolute latest.
The task is: Create a tool to support site clearance condition survey. To support this you are going to create a tool that collects the relevant data for each site via a VBA form, collates ongoing information on the data tab,
analyses and presents the analysis on the summary tab.
The project is to take the outline task presented and create a macro enabled excel file that
demonstrates understanding of advanced excel and the design and coding of a small VBA and
project.
There are many things to present, the spreadsheets itself, the VBA code, the data
collection form, the excel operations and the design tool outcomes.
Need to demonstrate that you have carefully considered the task and undertaken an
appropriate design prior to coding the VBA tool.
Your tool needs to work. The tool should; present a form, collate the data into the data tab, undertake simple analysis using appropriate excel techniques and report a summary. The code should be neatly presented and clearly formatted.
This project needs to be done as quickly as possible, completed by 12:00 midday on the 6th May absolute latest.
Lukas F.
100% (1)Projects Completed
2
Freelancers worked with
2
Projects awarded
25%
Last project
4 Oct 2013
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies