About a year ago, the Illinois Department of Transportation (IDOT) changed the way it measures & pays for bituminous prime coat. What used to be a simple computation became complicated (just like everything in construction anymore….). The specification requirements were expanded, increasing the degree of surface prep, cleaning & application parameters than with former specifications. IDOT made the change in response to research that has shown the expanded role that prime/tack coats play in the longevity of HMA overlays.

With the new Special Provision (CLICK HERE FOR A COPY), payment calculations also changed. Instead of paying for the total quantity of emulsion applied (in either gallons or pounds of emulsion), IDOT now pays for the residual asphalt (or the actual quantity of bitumen) This requires that the engineer calculate and subtract ALL water (both dilution water AND water in the emulsion) from the volume of material shipped & applied.

OK, so I’m a pretty capable guy. I like to occasionally geek-out on spreadsheets. But for whatever reason, this calculation string was a doosy. Developing formulas, based on the Bill of Lading (as it was shipped to the plant) and then developing respective formulas for the actual delivery was quite tedious. But, with effort comes results. I think I got it.

If you are interested in getting a copy of this worksheet, send me an email link in the COMMENTS below and I’ll try to help you out.

Nice Job

Keep up the good work and thank you.

Looks like a great work sheet. Appreciate that you are willing to share it. BTW, your blogs have been very interesting. Great job!

Thanks Mike! Getting positive feedback like yours is energizing – I really appreciate it!!

Bob, a young engineer from Millennia that works with me asked prime worksheet. Thanks.

Bob, I am a young Resident Engineer and was referred to your blog from a past manager. I have found the material to be extremely well written and a valuable resource to me. I would really appreciate a copy of this worksheet for it would be a great tool for me in the field. Thank you and I look forward to the blogs to come!

Bob,would love a copy of this spreadsheet…..keep up the impressive work

Thanks, Tom! Let me know how it works for you.

–Bob

Rick would like to request a copy this spreadsheet. Much appreciated

Thanks for checking in, Rick. Let me know what you think.

–Bob

Bob– this is Pat Kielty. I jsut finished DOC course last week and saw Tim Hussey there. Can you sent me a link or copy of your spreadsheet.

Hey Bob. I like the look of the layout. I’d like to get a copy of your spreadsheet.

Hi Bob.

Great work! Could I get a copy?

Hey, Bob!

I work in documentation and I would LOVE a copy of your spreadsheet to share with my construction guys and to help me get through this pay item in their reviews.

Hello, Robert. If you could send me a copy of your prime worksheet, I’d appreciate it. Thanks.

Hello dear first thanks for nice works and please send it to me

hmassoud8@gmail.com

Hello Bob,

You done a great job on the worksheet. Please send me a copy of your worksheet, this will help me out so much. Thank you

Thanks, Todd. I hope you find the worksheet helpful.

Hello Bob,

You done a good job on creating the worksheet. Please send me a copy of the worksheet. Thank you

Please send me a copy of the spreadsheet. Will save me a lot of time making my own!

Please send a copy of your prime worksheet, I’d appreciate it. Thanks!

Please send a copy of your prime worksheet, I’d appreciate it. Thanks!

Can you please send me a copy

Thank you

Please Send to me.

Who wouldn’t be interested? Please send me a copy 🙂

Bob, Can you please forward me a copy of this spreadsheet. Thanks.

Hello,

Could I get a copy of the Excel sheet?

This would be very helpful.

Thanks

This worksheet looks very helpful. Could you please send me a excel copy. Thanks

Will do, Kent – Thanks for stopping by the site!

Hey Bob, could you send me the spreadsheet? BTW great blog. Its been a great resource for me.