{"product_id":"contractor-bid-estimate-calculator","title":"Contractor Bid and Estimate Calculator Spreadsheet","description":"\u003cp\u003eThis contractor bid workbook prices a job from one rate card, so when a carpenter's day rate goes from 285 to 300 you change one cell and every bid line that uses him moves. It is for builders and trades who want an estimating tool that remembers their rates and their results, not just a blank quote form.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eA rate card the bid reads\u003c\/h2\u003e\u003cp\u003eThe rate card holds twenty-five lines covering labor, subcontract, materials and plant. The take-off prices itself from it: you enter the quantities and the rates are looked up. When a supplier puts his prices up, repricing a job takes one cell, not an afternoon.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eA bid with room for 48 lines across nine sections, with rates looked up\u003c\/li\u003e\n\u003cli\u003eA line whose rate comes back as zero turns red and is counted on the summary strip, because a missing rate is how a bid goes out too low\u003c\/li\u003e\n\u003cli\u003eCost and price by section, with each section's share of the bid\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eMarkup you can see on every line\u003c\/h2\u003e\u003cp\u003eOverhead, markup and contingency are applied to each line and shown on each line, rather than added as a hidden percentage at the bottom. Each line's share of the construction bid is visible too: in the demo job, site management is 6% of the total, and you see that before the client does. It works as a markup calculator and an estimate template in one.\u003c\/p\u003e\u003ch2\u003eThe Bids Log\u003c\/h2\u003e\u003cp\u003eThe Bids Log works as a bid tracker for every quote you send: sent, won, lost or pending, with a win rate and the value still out. A win rate that is too high usually means the markup is too low. One that is too low suggests you are pricing work you should not be bidding for. Neither shows up anywhere else.\u003c\/p\u003e\u003ch2\u003eThirteen connected tabs\u003c\/h2\u003e\u003cp\u003eEverything prices off one rate card, so nothing is typed twice. Alongside the materials, bid and bids log tabs, the workbook carries a shop engine underneath with products, pricing, inventory, orders, customers, sales and a dashboard. A Start Here tab walks you through setup in a few minutes, and charts redraw from your own numbers, not static pictures.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.\u003c\/li\u003e\n\u003cli\u003eNo subscription and no bank connection\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eTwo Excel files: one with a worked 190,000 bid and fifteen logged quotes, and a blank one for your own jobs\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eHow do I update my prices?\u003c\/h3\u003e\u003cp\u003eChange the rate once on the rate card. Every bid line that uses that rate is repriced automatically.\u003c\/p\u003e\u003ch3\u003eWhere does the markup go?\u003c\/h3\u003e\u003cp\u003eOverhead, markup and contingency are applied to each line and shown on each line, so you can see exactly how the price is built.\u003c\/p\u003e\u003ch3\u003eCan I track which bids I win?\u003c\/h3\u003e\u003cp\u003eYes. The Bids Log records each quote as sent, won, lost or pending and calculates your win rate and the value still out.\u003c\/p\u003e\u003ch3\u003eHow big a bid can it handle?\u003c\/h3\u003e\u003cp\u003eThe bid has room for 48 lines across nine sections, priced from a rate card of twenty-five lines.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597864665182,"sku":"OPX-087","price":35.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/contractor-bid-estimate-calculator-01.jpg?v=1790832426","url":"https:\/\/opxviashop.com\/products\/contractor-bid-estimate-calculator","provider":"OPXVIA","version":"1.0","type":"link"}