I was sitting here trying to figure up my expenses on a few decals I just made, and thought why not just make a spread sheet that does it for me. So I sat down and figured out the formulas and here ya go. I have attached the Excel file here.
I was going to get a little more advanced, and I am up for suggestions. It will let you put the Name of the vinyl, your Supplier, the width and length, then it calculates your cost per square yard, foot and inch. Then at the end you can put in a length and width for a sign or decal and the number of color layers and with let you know the cost per decal/sign.
It's basically a running list of your materials with some calculations in it. So you get a new roll, you put it in the sheet while you have the invoice handy and then when you need to know what a project it going to cost you enter the numbers. Kind of like a mini Inventory. If you have more rolls that the sheet I sent uses, just copy a row and paste it back in below the bottom. It should copy the formulas etc into the new row.
Let me know what you think. This was done in Excel 2000, but it should open using OpenOffice spreadsheet too if you have it.
***EDIT: Updated this one to the new version,
Roll Vinyl Calculator 2.zip
Roll Vinyl Calculator 2.zip