Remaster the Climatech Estimating Excel Spreadsheet

In Progress

Climatech needs some fine tuning for its standard estimating sheet. Our estimating sheet is used for construction cost tenders in our business. The sheet is used to compile and present/assess a number of tenders from subcontractors for equipment and trade labour. For a number of years we have been using our standard sheet (refer to attached excel file: "Climatech Current Version Estimating Sheet".

I have compared the sheet to the version used by another company in our corporate group (Sth Air/SAC), and would like to re-do our estimating sheet incorporating elements of that sheet.

I require a very competent and fast working Excel expert to deliver this for us. It wont be difficult Excel work...I simply dont have the time to do it. As this excel sheet will form the basis for large $$ tender bids, it is CRITICAL that the formatting of the cells in the sheet is accurate.

Essentailly, I want the project outcome to be as follows:

A clean, concise and easy to use estimating sheet in accordance with the instructions below; and

Good communication for alterations and changes with the succusful bidder, as there will be some tweaking and fine tuning to get this done right.

Good written english communication skills are essential.

Spreadsheet Requirements/Instructions:

There are 2 spreadsheets attached; "Climatech Current Version Estimating Sheet" ("Old") and SAC Estimating Sheet ("SAC"). We will use elements from both these Sheets to create the "New" sheet

Tab 1 of the New sheet will resemble the layout of the tab in SAC titled "Estimate Summary Form" the pages will run across the screen and print in portrait A4.

As you will note, the title blocks in the SAC sheet are very dated, as this is an old spreadsheet. Need to modernise this. Title Block to resemble the Climatech version in the Old Sheet (ie with the Climatech logo button).

You will note that there are drop down lists in the Old sheet. I would like to keep these if possible....but I dont want to do it with hidden rows. One of my former employees set up this sheet, and the hidden cells create all sorts of problems and are dangerous when estimating as the $$ go missing too easily.

The 2 tabs "RFQ-Equip" & "RFQ-Trade" from the Old Sheet need to be carried over into the New sheet as an extra Tab.

The Sheet "Suppliers" from the SAC sheet should also be carried into the New sheet as an extra Tab

The tab "Sheetmetal Costs" in the old sheet should be carried over to the New sheet, and should be the last tab in the spreadsheet.

Its important that the spreadsheet be user friendly and easily customisable so we can add extra items (eg new suppliers in the drop down lists).

In terms of visual aspects, keep it nice and clean and easy to read.

Ok, I know thats a bit confusing, but I'll provide plenty of feedback to the succusful bidder.

Good luck bidding!

I want the

Skills: Excel

See more: climatech, estimating excel, large excel estimating, excel estimating spreadsheet, the layout company, logo for construction business, labour work, file excel expert, excel spreadsheet business, excel expert up, excel expert skills, create the easy logo, create logo fast easy, create excel form by expert, create construction logo, create a construction logo, cost layout for construction, construction corporate logo, blocks logo for company, excel spreadsheets for business, excel sheet expert, excel expert 2013, tenders, sac, rfq

About the Employer:
( 7 reviews ) Sydney, Australia

Project ID: #4128665

Awarded to:


I've gone through your sheets and don't think this will be a problem at all. As you can see from my experience and portfolio, I have plenty of experience making robust, presentable custom spreadsheets, and the technica More

$70 AUD in 2 days
(1 Review)

8 freelancers are bidding on average $60 for this job


I am ready to have work start asap. thanks

$30 AUD in 1 day
(9 Reviews)

This is my first week using this will be my second project since I joined (if selected). since i am new to this website, I am willing to take projects a ridiculously low bids. Based on your specs, I woul More

$30 AUD in 5 days
(2 Reviews)

Hello, We can have this job done well as we have previously made financial models on similar lines. The SAC and estimates sheet have links to the tabs in the sheet. Looking at the sheet I feel you need a summary tab More

$50 AUD in 2 days
(0 Reviews)

Dear Jdestoop, I would be happy to do this project for you. I am an Excel expert with more than 5 years of experience working at top-ten Wall Street firm. I am available immediately and can complete the project within More

$100 AUD in 2 days
(0 Reviews)

Hello, sir. Let's do it. Thank you.

$90 AUD in 0 days
(0 Reviews)

I have a huge experience in multinational companies and I am sure I can help you very easily.

$60 AUD in 2 days
(0 Reviews)

I am Ready

$50 AUD in 1 day
(0 Reviews)