ASP & PHPE-CommerceE-Mail ServersFlash ToolsFTP ServersHTML ToolsJava & JavaScript ...
Methvin | Estimating Software 1.0 (methvin.org)
. This kitchen and bathroom design software is surprisingly one of its kind if you intend to do DIY kitchen and cabinet planning. With most of the software either paid or free with limited options, this software has a 20 hour free period after which you pay a nominal fee as you go ahead. Jul 04, 2014 Cabinet Solutions Software. Estimating / Job Costing. One of the most unique things about this cabinet software is the ability to customize your standards to how YOU build cabinets. You can change the construction methods, adjust the materials to what you use, switch between European (or frameless) and Face Framed style cabinets with.
eSTM8 Construction Estimating Software 1_1_1_1 (misronet.com)
e-STM8 Construction estimatingsoftware can help you gain a competitive advantage by facilitating your preparation of detailed, profitable bids while managing job costs and subcontractor bids. e-STM8 offers basic and advanced estimating features which ...
1st Choice Electrical EstimatingSoftware ResidentialEstimator is an estimatingsoftware to fit the needs of the most overlooked segment of the electrical industry. It is the only estimatingsoftware designed just for the Residential Contractor. The 1st ...
MEI Steel EstimatingSoftware is a powerful, yet easy to use, tool for estimating the costs associated with steel fabrication projects. We're confident this product represents a cost-effective solution to your estimating needs. But don't just ...
Released: Jan 22, 2012 | Author: MEI Steel | Size: | Shareware
Print estimatingsoftware, production and management for printing and graphic arts. Graphic arts, photocopying, digital printing, binding, etc. Logic Print software copy FREE. Software for calculation of quotes in 1 minute, printing drawings, work orders, ...
Released: Mar 4, 2013 | Author: Logic Print Software, S.L. | Size: 6799 K | Shareware
Category: Business - Vertical Market Apps
Quote IT Estimating Software 10.6 (mie-solutions.com)
Quoting and Estimatingsoftware packages have become vital prerequisites for reducing time, costs, and errors at different levels of the production chain. Modern solutions now allow organizations in manufacturing - and not only - to achieve the best prices ...
Released: Oct 25, 2012 | Author: MIE Solutions | Size: 2775 K | Shareware
Category: Business - Vertical Market Apps
CFF construction estimating software 3 (misronet.com)
CFF3 Construction loan estimatingsoftware has been designed to ensure that you have most of the project variables considered so that the produced Forecasts/estimates are likely to reflect the situation of your specific project. Figures and financial ...
Released: Nov 18, 2012 | Author: www.misronet.com | Size: 444 K | Shareware
Category: Business - Project Management
CFF3 construction estimating software 3 (misronet.com)
CFF3 Construction loan estimatingsoftware has been designed to ensure that you have most of the project variables considered so that the produced Forecasts/estimates are likely to reflect the situation of your specific project. Figures and financial ...
Author: www.misronet.com | Size: 440 K | Demo
Category: Business - Project Management
Pricelynx Cost Estimating 10.1 (pricelynx.co.uk)
The cost estimatingsoftware is designed for pricing all types of project and production costs. The program is flexible enough to accomondate all types of commerce and industries. If you were looking for mechanical or electrical contract costing then ...
InSite SiteWork Earthwork and Utility EstimatingSoftware combines ease-of-use with the most powerful sitework take-off features available. Calculate cut and fill, stripping, strata quantities, paving and concrete materials, topsoil re-spread, areas, ...
Released: May 14, 2012 | Author: InSite Software Inc. | Size: 5324 K | Shareware
Print estimatingsoftware, production and management for printing and graphic arts. Graphic arts, photocopying, digital printing, binding, etc. Logic Print software copy FREE. Software for calculation of quotes in 1 minute, printing drawings, work orders, ...
Released: Nov 1, 2012 | Author: Logic Print Software, S.L. | Size: 4904 K | Shareware
Category: Business - Vertical Market Apps
Cost Estimating 10.1.4.1 (pricelynx.co.uk)
Pricelynx cost estimatingsoftware is a designed for pricing all types of project and production costs. The programs flexibility accommodates all types of commerce and industries from production costing to construction projects. A database can be compiled ...
Released: Nov 30, 2012 | Author: Pricelynx | Size: 7997 K | Shareware
Category: Business - Business Applications
MIE QuoteIT Metal CAM Quote Software 1 (mie-solutions.com)
MIE QuoteIT Metal CAM Quote Software by MIE Solutions is a proven effective quoting and estimatingsoftware package that helps companies come up with accurate and consistent estimates using tables and formulas. The solution comes in the form of a multi-user ...
Author: MIE Solutions | Size: 90327 K | Shareware
Category: Business - Vertical Market Apps
TurboBid 3.0 (turbobid.net)
TurboBid is an electrical estimatingsoftware program that is designed to help all electrical and low voltage contractors win more profitable business by providing them with a systematic process to identify all their costs, maximize crew productivity ...
Released: Jan 11, 2012 | Author: Advanced Electrical Technologies | Size: 101888 K | Shareware
Category: Business - Accounting & Finance
Paint Estimator Pro 5.8 (paintestimator.net)
8 is a 100% complete Paint Estimatingsoftware program (figures costs), which includes the Interior and Exterior PrimaryBid_worksheets, complete material orders list (you view/print for ordering materials), labor form, contract/proposal form (send to ...
Released: Feb 9, 2012 | Author: Paint Estimator Pro | Size: | Commercial
A valuable tool, originally created for Costimator - a cost estimatingsoftware tool for manufacturing - is used to calculate shop rates based on the inputs of Direct labor, Machine Price, Number of employees and Gross Sales combined with eleven default ...
Released: Feb 25, 2012 | Author: MTI Systems, Inc. | Size: | Shareware
Category: Business - Calculators
Contractor's Office 6.1 (priosoft.com)
Whether you call it estimatingsoftware, construction software, construction management software, construction contractor software or handyman software, Contractor’s Office Cost EstimatingSoftware manages your entire business process. If you’re ...
Released: Mar 27, 2012 | Author: PrioSoft | Size: 70123 K | Shareware
Estimatingsoftware for the Metal Roofing sector, includes domestic, industrial and commercial projects. - New Metal Roofing Software, 4 years in development and 1 year real job testing - Designed, developed and tested by a metal roofer - Best value ...
Construction estimatingsoftware for people who need to price work quickly Fast Estimate is the most flexible building estimatingsoftware available today. With the ease of use of a spread sheet and the power of a database, Fast Estimate puts you firmly ...
Category: Business - Office Suites & Support Tools
WinEst PlanX Pro 8.0 (winest.com)
WinEst’s Pro estimatingsoftware enables you to quickly and easily create, manage and integrate detailed project estimates. WinEst Pro uses cost-knowledge management to increase your project productivity and customize your essential documents.
Released: Jan 14, 2012 | Author: WinEstimator inc. | Size: 10752 K | Shareware
Category: Business - Office Suites & Support Tools
Eagle Point Software - Landcadd (eaglepoint.com)
Suite of landscape and irrigation design ...
Teniers: Cabinet of Archduke Leopold William (courses.washington.edu)
Interactive story of one of the most famous artist's ...
Realms of Wonder Comic Tracking Software (realmsofwonder.com)
Spearhead electrical estimatingsoftware. Includes fault loop impedance calculator suitable for Australian standards AS3008 and AS3000. Free demo available from the ...
Building Material Residential Estimating Software (eolnow.com)
We offer time saving software and hardware solutions for blueprint takeoffs and material estimates. Print detailed construction products itemized lists in delivery order quantities. Free demo ...
Easyest Construction Estimating Software (easyest.com)
Easy to use estimatingsoftware for all construction trades. Programs feature integrated accounting, estimating and product management ...
Electrical Estimating Software with Bid and Project Management (conest2000.com)
Fully integrated electrical estimatingsoftware with bid management, project management and time and materials billing solutions provide contractors with dynamic, timesaving software tools designed to help them manage information effectively, efficiently ...
Backed with training, customer support and regular software ...
Estimating Software Solutions, Inc. (estimatingsoftware.com)
Offers the Drywall Estimator software program for 32-bit Windows. Screenshots, testimonials, contact ...
Cabinet Estimating Software Free Downloads - 2000 Shareware periodically updates software information and pricing of Cabinet Estimating Software from the publisher, so some information may be slightly out-of-date. You should confirm all information before relying on it. Software piracy is theft, Using Cabinet Estimating Software crack, password, registration codes, key generators, serial numbers is illegal.
In the last Effective Estimating blog post, I introduced myself and this series of posts. Today we will be spending some time working on a couple models in Excel (it’s not rocket science, but there is a learning curve) so we can learn to not only take our costs and build bullet proof Estimates and Proposals, but also be able to play incredibly valuable ‘What If’ scenarios.
So let’s look at a few ‘What If’ scenarios first, then we will look at some things you can do in Excel that may make playing What-If scenarios possible.
What if we use this wood specie instead of that wood specie?
What if we use this door instead of that door?
What if we use this drawer type instead of that drawer type?
What if I outsource my doors and drawer fronts?
What if I outsource my cabinet components?
What are the financial implications of Outsourcing in general?
Your Estimating system must be bi-lingual, it must speak two languages equally well. It must speak cost and selling price. There must never be a discrepancy between what you tell a client an item will cost, and the reduction made in total job cost if they opt to not purchase that item. At this point, you might ask, how do we accomplish that? On the low end of the scale, we do it with a spreadsheet, on the high end, we do it with a database. A database is beyond the scope of this post, but we’ll cover the basics for using a spreadsheet.
Seeing formula’s used in Excel models is the first step in learning to use this incredibly useful tool (it’s always easier to learn a new thing when it is used in the same context you want to use it in). My life experience tells me that the primary objective of an Estimate is to Sell a Project, but the secondary objective is absolutely no less important, and that is to Create Right Expectations (aka: Manage Customer Expectations).
Managing Expectations just might be the second hardest thing about cabinetmaking (managing employees claiming the top position for most cabinetmakers). Since there are no second chances at first impressions, then I’m thinking we should put our very best foot forward when it comes to the systems we use to produce our Estimates and Proposals, and let these two instruments of communication be our primary method for managing those expectations. Verbal communications are subject to forgetfulness and/or misinterpretation, so they need to be our last resort for managing expectations.
In my Effective Estimating Video Seminar, we will look at the mechanics of making just such a system a reality, and here, in this post, let’s see if I can try to illustrate a small portion of the process effectively. Maybe a step by step set of instructions with images will allow you to do your own sample spreadsheet as a by-product of just following along.
First, lets open a new Blank Workbook in Excel 2016. Then let’s name the first Tab ‘Options’ (right click on the tab > choose Rename > type Options).
Now let’s add a second tab by clicking on the + sign to the right of our first tab and name this new tab Price Worksheet.
Now let’s add our Headings to our Options tab. I like to add a Fill Color and make my Heading text Bold.
Now let’s add our Door Style options, our Design Costs and our Material costs. This portion is nothing more than typed text, and again, I like to make my cost fields have a Fill Color, in this case green (the color of money). You will also need to change the Number type of all the cells related to money from General to Currency is you want your sample spreadsheet to be sexy.
Now let’s go to our Price Worksheet tab and add our Headings. Again, adding a Fill Color to the heading, and making the text Bold.
Now we’ll get a little more technical, select field A2 > On the Data tab, in the Data Tools group, click Data Validation > In the Data Validation dialog box, on the Settings tab, choose ‘List’ in the Allow pull-down > In the Source field, select the Up Arrow to the far right of the field and navigate to the Options tab and select A2 through A12 and click the Up Arrow again, the results in the field should look like this: =Options!$A$2:$A$12 > Click OK.
That’s it, now go click in the A2 cell and you will see a pull-down option appear to the right of the field, and when you click on it, you will see your list of Styles. Choose A for now.
Now, even more technical (but not overly difficult), click in cell B2 > Select the Formulas tab > Select the Lookup and Reference option > Select ‘Vlookup’ near the bottom of the list. You will see a pop-up box like this:
Now let’s fill this thing out. Select the Lookup_Value Field and enter A2 OR click on the Up Arrow and then click cell A2 and click the Down Arrow> Select the Table_array field and enter Options!A2:B12 OR click the Up Arrow and select fields A2 through B12 and click the Down Arrow > Select the Col_index_num and enter 2 > Select the Range-lookup field and type the word False > Click OK. Don’t forget to set your field type to Currency to make it look sexy, and test your field by selecting a different Style from the pull-down list in cell A2.
NOTE: If your Design field does not recalculate when you select another Style, you need to select File > Options > Formulas and make sure the Automatic radio button is selected in the Calculations options area.
Now let’s repeat what we just did with 2 slight variations for our Material field. Click in cell C2 > Select the Formulas tab > Select the Lookup and Reference option > Select Vlookup near the bottom of the list. Select the Lookup_Value Field and enter A2 OR click on the Up Arrow and then click cell A2 and click the Down Arrow > Select the Table_array field and enter Options!A2:C12 OR click the Up Arrow and select fields A2 through C12 and click the Down Arrow > Select the Col_index_num and enter 3 > Select the Range-lookup field and type the word False > Click OK. Don’t forget to set your field type to Currency to make it look sexy, and test your field by selecting a different Style from the pull-down list in cell A2.
That’s it, you’re done. Obviously if you want to build an entire Estimating Spreadsheet, you will need to do a lot more of this work, but that is the key elements. List all your Materials on the Options page, and tie them to your Price Worksheet page. If I wanted to use this to price my doors, I would then either type in a quantity of needed doors, or do something like this for cabinets where I chose a particular cabinet, and that cabinet had number of doors, drawer fronts, drawer boxes, etc., listed out, and when I chose that cabinet, and added a quantity of that cabinet, I would get a door count, then multiply that door count by my NEW Design field for a total Design cost for doors. Obviously calculating door square footage is more complicated, but it would still be done in the same way.
By doing this, these pull-down selection boxes allow you to provide your clients with quick What-If scenarios and the cost implications of using one door over another, one finish over another, one wood specie over another, etc., etc., etc. OR, you could use a database. A database is much harder to do on the front end, but exponentially more flexible when used, and you can provide your clients with gorgeous reports.
So you can check your work, or look to see what you may have missed or entered incorrectly, here is a link the finished spreadsheet we just created:
And here is a link to a really, really, really old spreadsheet that has not been touched since 2001 (we stopped updating it shortly after our Business Partner Estimating Software was introduced, as mentioned in the first post, my new version of this software is now called Custom Cabinet Estimator). Feel free to play with, modify, or change this spreadsheet any way you want. It is yours to keep and do anything you want with it (obviously the pricing in this old spreadsheet is 17 year old, so make sure you update everything before attempting to use it for anything other than experimenting and /or playing around).
Today we covered What-if scenarios, a few Excel tips and tricks and managing Customer Expectations with our Estimates and Proposals. In our next article in this Effective Estimating series, we will delve into the dreaded term “Ballpark Estimate” and the implications of handling this request well or poorly.
To make sure you won’t miss a crucial part of this discussion, enter your email address in the ‘Subscribe to Blog via Email’ field on the right, and each time one of us adds a blog post, you will automatically be notified. Oh, and you won’t hurt our feelings if, depending on where you are seeing this, you Share, Like, Plus or Re-tweet it (there are buttons somewhere on this page to help you with that).
May the Lord bless the work of your hands, heart and mind.