Many of you know I use excel to estimate my projects. As a roofer we always charge more for a steeper slope. My spreadsheet has been suprisingly accurate for an average size house, though the formula used is totally flawed in theory. I realized this when trying to plug in a mansard roof.
In any case here is what I am trying to do:
a 12/12 roof is quite steep I'd like to add $25 per square, but at the same time a 18/12 is very steep, in which case I'd like to add $75 per square.
Ok so here's how I'd like it to work and keep knocking my head against the wall. In one field I enter the pitch (1-24) The math forumla computes based on the pitch variable and outputs an upcharge to the total price. The problem I am having is finding some common ground with the formula. I spent an hour inputting as many different formulas as I could think of.
Those of you who don't know what I am talking about can download the spreadhseet http://bestexteriors.com/pricing.xls
In any case here is what I am trying to do:
a 12/12 roof is quite steep I'd like to add $25 per square, but at the same time a 18/12 is very steep, in which case I'd like to add $75 per square.
Ok so here's how I'd like it to work and keep knocking my head against the wall. In one field I enter the pitch (1-24) The math forumla computes based on the pitch variable and outputs an upcharge to the total price. The problem I am having is finding some common ground with the formula. I spent an hour inputting as many different formulas as I could think of.
Those of you who don't know what I am talking about can download the spreadhseet http://bestexteriors.com/pricing.xls