Roll Vinyl Calculator

[sarconastic]

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,

[fivestar]

Thanks alot, I will give 'er a go and see how she performs. 

[SandyM114]

Hey, thanks! I can use this! Sandy

[neron15210]

thanks man

[jfought]

this is for me and the other 20 ppl that did not give thanks for all the work that you put into this.


Thank You 

[FireMalt]

Thanks for sharing, and taking the time to create the form... I'll give it a shot in the morning.

[firefighter1138]

 
Excellent, works great.  Had to copy the formula down in last colom.  I like it, gives you a great idea of your cost of materials without using your brain.  I've already got plent of vinyl and all my application tapes put in.  Thank you for takong the time to do this and even bigger thanks for posting it.

Jim

[chefgary]

Thanks
Gary

[Splice]

thanks will check it out! 

[sarconastic]

Thanks everyone for the support. I figure this is one way I can give back a little bit. I filled out that last column that I forgot, and also added a check to make sure it wouldn't error out when there were no totals. I added a Sum at the bottom so you could add a couple vinyls together for a bid or whatever. I didn't change anything on the left side, so if you already put all your stuff into the old one, just Copy and paste it into the fixed one.

Hopefully it helps someone.

[kmerting]

Thanks for posting this!

[Cre8tiveCutter]

Thanx for this I needed something like this!

Renee

[guest]

lol where was this about a year ago when i was doing manual calcs to find this info out? lol

[jfought]

would it be possible to have it total you app tape and vinyl for a job?

[nonabelle]

thanks, will give it a try. thanks for u taking the time and sharing ur program with us.