Estimating With Excel For The Small Contractor YouTube - Page 6 - Business - Contractor Talk

Estimating With Excel For The Small Contractor YouTube

 
Thread Tools Search this Thread Display Modes
Old 04-24-2015, 05:47 PM   #101
Registered User
 
roofing4ever's Avatar
 
Trade: insurance restoration
Join Date: Apr 2015
Posts: 6
Rewards Points: 20

Re: Estimating With Excel For The Small Contractor YouTube


I use the svg estimator program, I used quickbooks before that and some excel thing before. I will never go back and I got a free book with purchase which was pretty awesome
roofing4ever is offline  
The Following User Says Thank You to roofing4ever For This Useful Post:
bartstop (06-27-2015)

Warning: The topics covered on this site include activities in which there exists the potential for serious injury or death. ContractorTalk.com DOES NOT guarantee the accuracy or completeness of any information contained on this site. Always use proper safety precaution and reference reliable outside sources before attempting any construction or remodeling task!

   

Advertisement

 

Old 04-27-2015, 04:00 PM   #102
Member
 
BMiller's Avatar
 
Trade: Custom Home Building, Remodeling
Join Date: Apr 2015
Location: Martinsburg, WV
Posts: 30
Rewards Points: 128

Re: Estimating With Excel For The Small Contractor YouTube


Thanks for the resources!
BMiller is offline  
Old 04-27-2015, 06:51 PM   #103
Pro
 
cargin2's Avatar
 
Trade: Small remodeling contractor
Join Date: Aug 2011
Location: LeMars, IA
Posts: 101
Rewards Points: 115

Re: Estimating With Excel For The Small Contractor YouTube


Quote:
Originally Posted by BMiller View Post
Thanks for the resources!
You are welcome.
Rich
cargin2 is offline  
Sponsored Links
Advertisement
 
Old 05-18-2015, 01:13 PM   #104
Registered User
 
NJProBuilders's Avatar
 
Trade: general contractor
Join Date: May 2015
Location: Midland Park, NJ
Posts: 3
Rewards Points: 6

Re: Estimating With Excel For The Small Contractor YouTube


Hello! Thank You for posting this great information!! I was wondering if you use a spread sheet for formal proposals for the homeowners? If so which program do you use?
NJProBuilders is offline  
Old 05-18-2015, 06:16 PM   #105
Pro
 
cargin2's Avatar
 
Trade: Small remodeling contractor
Join Date: Aug 2011
Location: LeMars, IA
Posts: 101
Rewards Points: 115

Re: Estimating With Excel For The Small Contractor YouTube


Quote:
Originally Posted by NJProBuilders View Post
Hello! Thank You for posting this great information!! I was wondering if you use a spread sheet for formal proposals for the homeowners? If so which program do you use?
Yes, I use Excel for Estimates and Invoices. My estimates are fairly simple. I try to get the information on one page.

I explain how I did this in video #5 and 6.

Rich
cargin2 is offline  
Old 06-04-2015, 11:10 PM   #106
Thread Reading Aficionado
 
Builders Inc.'s Avatar
 
Trade: Building Contractor
Join Date: Feb 2015
Location: Florida
Posts: 1,781
Rewards Points: 1,416

Re: Estimating With Excel For The Small Contractor YouTube


Last weekend I started at 8 pm and got hooked till 4:45 Sunday morning recreating your sheet from the you tube videos. I had to play with your mark-up to make it work with mine.

I would like to add the proposed profit percentage (sales price) and break it down into 1% increments for those jobs where the customer is a stickler. I fluctuate between 10 and 20% depending on how the bidding is going and how sales are going for the month. I also like to know my break even figure before I bid also.

SO as for this mark-up figuring... lets say hypothetically if your overhead is 14% and your profit is 15% then your markup would be 29% or 71% using your sheet? And why dont you add labor and materials and make that your manufacturing cost and add markup for overhead+profit all in one formula.

Like manufacturing cost * (mark-up formula) for the longest I would (in the example) if your O.H. was 14% and profit was 15% then I would add them together to get 29. Then subtract 29 from 100% leaving 71% then divide 100 by 71 = 1.4084507. and that is what I would use to mark-up manufacturing cost to get a 15% profit. (1.4084507) I think your sheets are similar. Do you see a flaw in how I was doing it? Am I missing something?
Builders Inc. is offline  
The Following 2 Users Say Thank You to Builders Inc. For This Useful Post:
imdskydiver (11-04-2016), Unreal Elect (03-17-2016)
Old 06-04-2015, 11:13 PM   #107
Thread Reading Aficionado
 
Builders Inc.'s Avatar
 
Trade: Building Contractor
Join Date: Feb 2015
Location: Florida
Posts: 1,781
Rewards Points: 1,416

Re: Estimating With Excel For The Small Contractor YouTube


Manufacturing cost would be materials and labor and payroll taxes to create said project. Overhead is all the other stuff.
Builders Inc. is offline  
Old 02-25-2016, 05:17 PM   #108
Registered User
 
sbskeeper's Avatar
 
Trade: Renovations
Join Date: Jan 2015
Posts: 3
Rewards Points: 12

Re: Estimating With Excel For The Small Contractor YouTube


Hello all,

First of all, I love this so much. Reading as much as I can before I start building my final calculator in excel and I came across a feature where you can import live internet data in real time, 30 minute increments, etc. More details below.

http://www.groovypost.com/howto/micr...-spreadsheets/

I know its not the best source for materials, but just as a ballpark, I want to try to use Home Depot lumber prices as an average of what to base estimates on. I'm running into a problem where it wants to import too much data that has no relevance to me. Have the same problem anytime I try to use Lowes, etc. I'm working on trying to automate this.

Has anyone else used this sort of feature successfully?

Thanks in advance for any input.

Last edited by sbskeeper; 02-25-2016 at 05:20 PM.
sbskeeper is offline  
The Following User Says Thank You to sbskeeper For This Useful Post:
aptpupil (04-15-2016)
Old 03-17-2016, 02:57 AM   #109
Registered User
 
Unreal Elect's Avatar
 
Trade: Electrical
Join Date: Mar 2016
Location: Durban
Posts: 3
Rewards Points: 10

Re: Estimating With Excel For The Small Contractor YouTube


Brilliant resources. By far the biggest mistakes I made early on was not understanding all the different costs, you have to include everything. I even include in the backend my time for creating the estimates.
Unreal Elect is offline  
The Following User Says Thank You to Unreal Elect For This Useful Post:
cargin2 (04-16-2016)
Old 01-01-2017, 06:57 PM   #110
New Guy
 
TravisD's Avatar
 
Trade: Fence and Deck
Join Date: Jan 2017
Location: Sarnia Ontario
Posts: 1
Rewards Points: 4

Re: Estimating With Excel For The Small Contractor YouTube


Awesome Stuff, really helpful.. Thanks

http://dmccustomcreations.com
TravisD is offline  
Old 01-06-2017, 01:37 PM   #111
http://penncoatinc.com/
 
PennCoat's Avatar
 
Trade: Painting / Epoxy Flooring / Polished Concrete
Join Date: Apr 2014
Location: Lancaster, PA
Posts: 91
Rewards Points: 706

Re: Estimating With Excel For The Small Contractor YouTube


Wow, great post. We use a similar system. But what I appreciate most about the method is that it's easier justifying your cost to a customer.
PennCoat is offline  
Old 02-08-2017, 03:12 PM   #112
Registered User
 
KaplanB's Avatar
 
Trade: General Contractor/Carpenter
Join Date: Feb 2017
Location: Toronto, ON
Posts: 2
Rewards Points: 6

Re: Estimating With Excel For The Small Contractor YouTube


Hi All,

Iíve been reading through this thread, and itís been very insightful to see what many of you have been challenged by in running your own businesses. The concept of estimating is not an exact science as we all know, and a lot of this comes with experience in the business. Having had my own owner/operator carpentry/general contracting firm for several years, as well as my current role as the GM of a medium sized construction company, I can certainly relate.

My path to success started with several setbacks due to not knowing what I was doing with pricing projects, and not tracking financial progress at all. When I say that out loud it sounds even worse then it does in my head! Iíve come a very long way since then, and itís time for me to give back to the community. Over the years Iíve developed a set of spreadsheets, and an innate ability to create these based on specific parameters given to me. Iíd like to share these with you, but as a first step, I am interested to learn how best I can serve this audience.

As mentioned above, my experience is both as a skilled and licensed/certified carpenter as well as a licensed general contractor. As Iíve progressed through my career I learned that it makes much more sense to focus on what I am good at, and if I can use someone elseís system (in this case Excel sheets), then it will help me leverage more time for the other more important tasks I canít hire someone to do.

Folks, please respond here and let me know if youíd be interested in receiving a specialized estimating document formatted for you in Excel. When you do respond, please answer the following questions which will best help describe what your needs are for me :

* Occupation (ie: what trade are you in)
* Geographical location
* Pricing structure (cost/plus or fixed/cost)
* Do you need labour, materials, and sub-contract sections
* Please share if there are any specific items youíd like to see

If you also feel that this would not be a useful thing to obtain, then please share your feedback with me as well!

Thanks!
KaplanB is offline  
The Following User Says Thank You to KaplanB For This Useful Post:
randys Painting (02-13-2017)
Old 02-13-2017, 02:58 PM   #113
Registered User
 
Carol Barns's Avatar
 
Trade: Tree Service/Landscaping
Join Date: Nov 2016
Location: Nanaimo, British Columbia
Posts: 9
Rewards Points: 18

Re: Estimating With Excel For The Small Contractor YouTube


This is awesome stuff. Great information. Thank you
Carol Barns is offline  
Old 02-13-2017, 04:02 PM   #114
Pro
 
cargin2's Avatar
 
Trade: Small remodeling contractor
Join Date: Aug 2011
Location: LeMars, IA
Posts: 101
Rewards Points: 115

Re: Estimating With Excel For The Small Contractor YouTube


You are welcome.
The more information that I can keep in my Bill Worksheet, like how long it takes to do a project, or a portion of a project, the better I am able to estimate future jobs.
When I get home at night, the 1st thing i do after supper is to do hours and invoices.
Myself and my son keep our hours with a time tracking app and most invoices are e-mailed to me.
Most of our jobs are small jobs with unique materials. Not the kind of stuff you would keep a data base of.
And even if I could keep a data base the prices are always changing.
Thanks again.
Rich
cargin2 is offline  
The Following User Says Thank You to cargin2 For This Useful Post:
obdaleccio (02-13-2017)
Old 04-11-2017, 12:54 PM   #115
Member
 
SmallTownJoe's Avatar
 
Trade: General Contractor and Contractor Business Man
Join Date: Apr 2017
Posts: 37
Rewards Points: 82

Re: Estimating With Excel For The Small Contractor YouTube


cargin2, great. I showed this to my buddy who just headed out on his own to start his GC business. It helped him so much.
He is struggling to figure out some of the business aspects of GCing.
Hell, I'll just ask. Could you take a 30 min phone call with me to discuss how you run your business? Because you seem to have good knowledge, It would certainly benefit us.

Thanks for a great post, regardless.
SmallTownJoe is offline  
Old 04-11-2017, 01:14 PM   #116
Pro
 
cargin2's Avatar
 
Trade: Small remodeling contractor
Join Date: Aug 2011
Location: LeMars, IA
Posts: 101
Rewards Points: 115

Re: Estimating With Excel For The Small Contractor YouTube


Thanks for the reply.
Yes I would take a phone call.
No, I am not the best business guy to talk with.
I have learned by making mistakes.
I have 30+ years in the community i work in so I can do some things on reputation. Like doing T&M jobs.

Rich
cargin2 is offline  
The Following User Says Thank You to cargin2 For This Useful Post:
SmallTownJoe (04-11-2017)
Old 04-11-2017, 01:18 PM   #117
Member
 
SmallTownJoe's Avatar
 
Trade: General Contractor and Contractor Business Man
Join Date: Apr 2017
Posts: 37
Rewards Points: 82

Re: Estimating With Excel For The Small Contractor YouTube


Is the # on your profile the best way to reach you? Is there a good time to call?
SmallTownJoe is offline  
Old 04-11-2017, 01:23 PM   #118
Pro
 
cargin2's Avatar
 
Trade: Small remodeling contractor
Join Date: Aug 2011
Location: LeMars, IA
Posts: 101
Rewards Points: 115

Re: Estimating With Excel For The Small Contractor YouTube


That is my home phone.
I could possibly talk later this evening. I have a birthday party for a grand child and I want to mow the yard tonight. Maybe after 9 pm CT.

e-mail me later this evening and I will let you know what time works best.
rich cargin at g mail .com
all one word of course i just jumbled it to keep bots from finding it
cargin2 is offline  
The Following User Says Thank You to cargin2 For This Useful Post:
SmallTownJoe (04-11-2017)
Old 04-11-2017, 01:24 PM   #119
Member
 
SmallTownJoe's Avatar
 
Trade: General Contractor and Contractor Business Man
Join Date: Apr 2017
Posts: 37
Rewards Points: 82

Re: Estimating With Excel For The Small Contractor YouTube


I will certainly email you! Thanks so much Rich!
SmallTownJoe is offline  
Old 05-09-2017, 05:39 PM   #120
Registered User
 
Dewaldt's Avatar
 
Trade: Industrial Electrical
Join Date: May 2017
Location: South Africa
Posts: 1
Rewards Points: 2

Re: Estimating With Excel For The Small Contractor YouTube


I played it at 1.5 speed.

Advertisement

Dewaldt is offline  


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Made in USA product list J.C. General Discussion 378 04-23-2019 05:16 AM
Excel material list festerized File Swap 4 08-14-2012 10:31 AM
Billing on small jobs Philly Dude Business 14 11-16-2008 04:25 PM
Estimating Article Series hatchet Business 15 07-15-2004 11:47 AM

Join Now... It's Fast and FREE!

I am a professional contractor
I am a DIY Homeowner
Drywall Talk is for
PROFESSIONAL CONTRACTORS ONLY!

At DrywallTalk.com we cater exlusivly to professional contractors who make their living as a contractor. Knowing that many homeowners and DIYers are looking for a community to call home, we've created www.DIYChatroom.com DIY Chatroom is full of helpful advices and perfect for DIY homeowners.

Redirecing in 10 seconds
No Thanks
terms of service

Already Have an Account?