Access based tool to create construction bids. total by room (based on square footage it calculates based on numbers the user enters), type of construction (each bid could have multiple types of construction) and a grand total at the end and print a report. It will need the flexibility to do any number of rooms and any number of items per room. I have a list of items that are universal with name, and price but I will also need the ability to over-ride the price should I chose to.
See Deliverables for more info.
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4) company info print at top of report
following information for each client:
* File #
* Fields marked with asterisk (*) need to be included at the top of every page
program will need to prompt the user for the following
Date of Consultation
Date of Consultation
For each room, I need to enter the following information:
Measurements (in ft) ??" Length, width, height
The program will then need to calculate and output into the report:
Total wall & Ceiling (in sq ft)
Floor and Ceiling (in sq ft)
Walls only (in sq ft)
Base/crown (in linear feet)
The pricing for items in the database based on sq ft will need to calculate quantity times the ‘floor and ceiling’ footages.
There will be two main areas of the bid ??" a UAP section for each room (‘tear down’ phase) and a UNC section (‘rebuild’ phase) for each room. I want to be able to enter item codes for the UAP section and have the corresponding item code for the rebuild entered into the UNC section. This action should happen by default, but I would want the option to go into a room and add/remove items as needed. I also need the ability to edit an item with a depreciation percentage, and have the amount print on the report. The columns in the report include:
Item description (based on the code entered, user will be prompted for this)
Quantity (user will be prompted for this, unless unit measurement is based on sq ft, then program will use the square footage it figured earlier)
Unit measurement (based on code, no prompt)
Unit cost (based on code, but can be overridden)
Depreciation percent (user supplied, but do not prompt)Extended cost (program calculates)
Total Depreciation (program calculates)
Damage (quantity * cost ??" depreciation, program calculates)
Depreciation is not used often, so I do not want it to prompt the user for this number. The user just needs to be able to add this amount if desired. Currently, system uses code of 0 (zero) for anything that doesn’t have a code laid out for it. So if user entered a code that did not have a description, it would need to prompt user for the information.
The report should total by room, and at the end of the report I would like to see individual room totals again, a UAP total for all rooms, a UNC total for all rooms and a GRAND total for all rooms. I will also need to be able to add material tax, and place a % markup and show that amount. Then the report will need to print the final total that includes all rooms, markup, and tax.
Item codes info:
The program would need to allow me to add codes at will. When I click the button that says ‘add code’ I want it to default to the next number available, but let me override it if I want to assign a certain number.
Once we have reached an agreement, I will provide all item codes and verbiage needed for the report in electronic format (Word, or Excel as the programmer would like).
Windows 2000 and greater. Office 2000 and greater.