Closed

Quoting Spreadsheet - Microsoft excel

This project was awarded to FIBIN for $200 AUD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 AUD
Total Bids
7
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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online