Windows Based for use in Internet Browser
Write a web based scoping / costing application and database used for the creation of scopes of work and cost estimates for home building repairs. It needs to have a clean looking interface, be easy to use and able to store the information inputted as separate estimates.
A sample layout has been attached in excel format.
In the 'Estimate Template':
> Job Details are user inputted and when estimate is saved, details listed on main page
> The sheet needs to be dynamic having the ability to rooms and sub items beneath each room.
> Numbering needs to auto update as a new item or room is added
> Room headings and sizes need to be user inputted
> Trade Categories need to be able to be selected from a drop down list
> Item description is user inputted
> Qty is user inputted
> Unit type to be selected from drop down list
> Rate to be user inputted
> Amount to auto calculate (qty multiplied by the rate)
> All the sub items under a room heading need to be sub totaled against the room title
We also require the ability to have saved templates with rooms preset with items.
When all data is inputted, the estimate needs to be able to be saved. The estimate template information needs to be totaled and displayed in the 'Estimate Summary'. This is a summary of the total of all item amounts containing the relevant trade category and copy across the totals from the base of the estimate. Additionally we require the ability to input alternative quotes against our summary for comparison.
This is an initial project to demonstrate within our business an initial concept. If successful, there will be significant additional work available improving and building on this base.
Open to any programming language / platform however the bigger picture project needs to be sufficient to allow multiple users through the web by a number of different access levels. Storage of inputted information for later manipulation and reporting is important.