This is great thank you!!! BTW what is the margin of error here. For example if the spreadsheet says I have 44 ft would you run a 40 foot job?
Not without rolling it out for an actual measurement. I have never used the caliper method, but the thickness of the vinyl AND the thickness of the backing
paper or plastic can greatly change the measurement. I keep a strip of
paper taped around my rolls, and inventory the used material on the
paper label every time I slice a job off of the roll. I've never tried to print 40 continuous feet though. When my
paper inventory looks close I will lay it out and do a hand measure to make sure of the relative accuracy of the inventory. Once in awhile if I have forgotten or neglected to mark the
paper strip with the inventory I will pick up a roll that says there are 23 feet (for instance) and I look at the roll and say NO WAY. Then will make a hard measure for accuracy. Hope this makes sense.