A number of people here have used the roof waste calculator Excel spreadsheet I put together. I’m sure many are experiencing difficulty with State Farm (and others) paying the appropriate/correct amount of material on their claims. We all know the standard bullshit line “10% for gables, 15% for hips” which clearly isn’t adequate for 95% plus of the roofs. By my calculations, the ONLY time 10% works for gables is when it is a simple 2 slope roof and the only time 15% is perfectly adequate for a hip is when it is a simple 4 slope hip. We have utilized this spread sheet quite often to successfully argue our case and get the waste increased to a reasonable number.
I’m not posting this to argue with some douchebag moron like CatSubtractor over whether this type of effort should be necessary or not. Of course it shouldn’t. However, in most cases for us at least, it works, it is the least path of resistance and it gets us paid for the proper amount of material. I’m also not going to debate the math. I purposefully used conservative numbers particularly on the valley underlayer calculations. If you believe the math should be different, have a happy and create your own spread sheet. This one has worked for us. Go to dropbox.com , the username is firstname.lastname@example.org, the password is roofer789 This should allow you to download the Excel file and the one page of user instructions.
I have created a dropbox account specifically to hold these documents. Feel free to download and use them at your convenience. I also posted a simple sheet of instructions. Note you will need Excel 2010 in all likelihood to utilize the spread sheet.
The first sheet, shown below, is where you do the calculations for the roof you are working on. Pretty simple, substitute your Customer’s Name at the top where it says “CUSTOMER”. Fill in the dimensions in the 5 cells with the green border. You can obtain these from whatever source you wish. We sketch our roofs in Xactimate therefore that is where we get our data. The four cells with black borders are all automatically calculated based upon the data you enter. It is important to note the total is for Cap, Starter and Valley Underlayer. It does not include anything for trim scrap. You can click on the red arrow and move the arrow end to whichever waste cell that is appropriate. There is a conclusion box below that (not shown in the image below) where you can type in your argument, such as “7.50% was required strictly for accessories. Add 5% for trim scrap and this roof should use 12.5% as the waste factor.” Once you’ve completed this, print to a pdf or a hard copy, whatever best serves your needs. We have to send this in on almost every supplement with SF, so the PDF comes in handy.
Interestingly enough, the roof shown below came up the past couple of days and I saw it as a perfect example to demonstrate why 10% waste for gable roofs isn’t adequate. This is on all sheets as it illustrates the point trying to be made. The roof drawings are from Xactimate sketch.
The next sheet shows the calculations for these two roofs side by side. I plan to make a version of this for hip roofs in the next few days and will post it in dropbox as well.
Finally, the last sheet simply has some supporting documentation taken from a Manufacturer’s Install Guide. You can find this material just about anywhere.
I hope this helps a few folks here in their efforts to get paid fairly. You may now return to your regular viewing of CatMoron arguing Texas Insurance Law with Alltex.