Tank Costing database
- or -
Post a project like this4838
£20/hr(approx. $25/hr)
- Posted:
- Proposals: 9
- On-site in Edinburgh, GB
- #52527
- Awarded
Excel, Access, VBA Developer Expert. Specializing in Excel and Access VBA automation.
Leeds
1351173626678189574596475128901318192613144833
Description
Experience Level: Intermediate
The initial requirement was to complete the development of an Excel-based application for costing the build and supply of storage tanks. The application is 85-90% complete, but there is a list of known issues, and it has not been tested to the extent that it can be considered fully reliable. In addition, there are a number of further features that could usefully be introduced.
In discussions, the work on this application could be divided primarily into three stages:
1. Finish current development and fully test
2. Improve usability of the interface
3. Develop further functionality to allow the accurate quotation of required work time
The first stage would involve
’· Re-writing 14 VBA macros so that they are properly structured rather than the result of recorded actions
’· As part of the re-write, delivering VBA functions to represent standard calculations such as nominal tank capacity
’· Correcting known issues
’· Providing the ability to update the material cost for steel quantities as required
’· Producing a series of test cases, applying them to the application and providing results
In all, this stage would take around 5 days to complete given access to staff for testing and verification of results.
The second stage would involve
’· Full analysis of the costing and quotation process
’· Improving the process flow through the application
’· Providing additional guidance in the form of system messages and other help information
’· Including validation of user input to prevent simple errors
This stage is more difficult to assess given the requirement for investigation, but would probably also require around 5 days’ work.
The third stage would involve
’· Some simple analysis of the time estimation process
’· Development of appropriate calculations in VBA
’· Collection of timing data for tank construction
’· Verification of calculations
Again, there is some uncertainty to the estimate for this stage because of the investigative element, and 5 days is probably also appropriate.
In discussions, the work on this application could be divided primarily into three stages:
1. Finish current development and fully test
2. Improve usability of the interface
3. Develop further functionality to allow the accurate quotation of required work time
The first stage would involve
’· Re-writing 14 VBA macros so that they are properly structured rather than the result of recorded actions
’· As part of the re-write, delivering VBA functions to represent standard calculations such as nominal tank capacity
’· Correcting known issues
’· Providing the ability to update the material cost for steel quantities as required
’· Producing a series of test cases, applying them to the application and providing results
In all, this stage would take around 5 days to complete given access to staff for testing and verification of results.
The second stage would involve
’· Full analysis of the costing and quotation process
’· Improving the process flow through the application
’· Providing additional guidance in the form of system messages and other help information
’· Including validation of user input to prevent simple errors
This stage is more difficult to assess given the requirement for investigation, but would probably also require around 5 days’ work.
The third stage would involve
’· Some simple analysis of the time estimation process
’· Development of appropriate calculations in VBA
’· Collection of timing data for tank construction
’· Verification of calculations
Again, there is some uncertainty to the estimate for this stage because of the investigative element, and 5 days is probably also appropriate.
Jonny B.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
18 Jul 2011
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