Replies

1. 
   user-267213 | Oct 19, 2007 05:21am | #1

   I'm something of a spreadsheet freak, and I really like your sheet. It looks like you spent some time on it.

   What do you do if you want to use a different kind of shingle? Just drag the cell's formula down to the appropriate place?

   Thanks for sharing. I'd be interested in your other sheets ;)

1. 
   cargin | Oct 19, 2007 02:26pm | #4

   To change the shingle type I either retype the Oakridge shingle line, or insert a new line and transfer the # of squares.

   On the last two jobs I have bid I have given them the option of Oakridge or Duration.

   I just let the sheet run the numbers on Oakridge, then delete the #of squares from Oakridge and change the # of squares to Duration. Record the difference.

   On the Bid I Write Add $125 for Duration.

   I'll post my Bill Summary. It's a real simple worksheet for figuring time and materials.

   I do this for T&M jobs and also for Bids to see how we did. I usually do a bill Summary part way thru the job to gauge our progress.

   On the Library job we hadn't finished yet so some of the hours and costs have ??? next to them. That was a preliminary summary of the job. I staple the reciepts together and write entered on the top sheet. The I know they are in the summary and any new hours or reciepts can be entered at the end of the job.

   Rich

   Edited 10/19/2007 7:28 am ET by cargin

2. 
   RichBeckman | Oct 19, 2007 07:17am | #2

   I think that is very impressive!! A LOT better than what I have managed.

   Rich Beckman

3. 
   Jim_Allen | Oct 19, 2007 08:07am | #3

   Rich, it looks like you covered most of the roofing materials that I could think of.

   Thank you for your contributions. I'll be interested to see if some other roofers weigh in and discuss the specific numbers and metholodgy.

   jim

   fka (formerly known as) blue