Quoting Spreadsheet - Microsoft excel

IN PROGRESS
Bids
7
Avg Bid (AUD)
$176
Project Budget (AUD)
$30 - $250

Project Description:
We have a quoting spreadsheet created in-house. This system works reasonably well but very clunky and would like it smoother. We would like to streamline the data entry to the one page, all information can be fed into this page and then run through all connecting cells on each page. Is it easier to use drop down boxes to tick what items we want to input to help with the summary page (as below)

We want to then create a summary page which only shows each item used on each page - still in each section but showing materials, hours and machinery. This page will be used as our job costing page so we need the information entered into the spreadsheet as quoted and a column next to it as actual so we can determine profit and loss on each item.

Once the spreadsheet is completed we want it to be able to produce a adjustable gantt chart for the timeline of works allowed for in the quote.

Skills required:
Microsoft
Additional Files: Quote Master.xls
Hire Robcoop05
Project posted by:
Robcoop05 Australia
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 223
in 3 days
$ 200
in 1 days
$ 200
in 3 days
$ 100
in 5 days
$ 100
in 3 days
$ 155
in 3 days
Hire bmartynvw
$ 252
in 30 days