[VernsVinylGrafx]

not just limited to vinyl. you can use this for anything that requires an "area" to be calculated. calculates hourly shop rate, calculates vinyl according to size, complexity, app tape, substrates, n so on. also has an invoice thats linked up to everything.

EXCEL 2007 ONLY

it SHOULD work just fine. i dont have plans on fixing anything unless somehting is seriously wrong. the sheet is autoprotected cuz there are alot of formulas. no password needed but any calculation made will reprotect the sheet. you can only enter data in certain cells.

please read the readme. it explains a lot.

im currently working on a workflow workbook and a possible revamp using access instead of excel.


it wouldnt let me attach the zip. file is too big? prolly cuz i dont have enough posts so heres a link.

http://vernsvinylgrafx.com/stuff/VinylCalculator.zip


enjoy!

 

[drakesis]

A nice layout, but there is problems with the "command4button", getting errors from your Macro's...?

 

[VernsVinylGrafx]

You need to enable macros. When you first open it up right above the cells theres a blue bar. It says something about security. You have to click the button that says options then enable macros





edit- i just clicked all the buttons n they all work fine on my end. i downloaded the one i uploaded so i was using what you were using.

 

[drakesis]

Macros are enabled, but maybe it's due to using Excel 2003.

 

[VernsVinylGrafx]

Yah, I said in the first post you need Excel 2007. You could try the compatability pack from microsoft.

 

[drakesis]

Yah, I said in the first post you need Excel 2007. You could try the compatability pack from microsoft.

I did, it didn't work. Oh well.

 

[VernsVinylGrafx]

sorry. i designed it in excel 2007. i dont use 2003. i know there are some minor n major differences between the 2 and i have no idea how to convert it over.

 

[Zenergy]

Wow Bill, you know some serious Excel-Fu. That's an excellent calculator - I'm still going through the instructions, but it's amazingly complete.

Thanks for posting - it's a huge help.

 

[insanedecals]

Oh, thanks so much! I have had a wee look and I like it - great job!

Edit to say I am running Excel 2010 and works perfectly so far...

 

[VernsVinylGrafx]

awesome on the excel 2010. im upgrading to that soon!

 

[Threadsplash]

I was so excited when another member gave me this thread to look at, but I am not able to open the link for the calculator...I get a message that says "this site is currently unavailable". Please help!

 

[SquareBiz]

can't get it to work either

 

[VernsVinylGrafx]

works fine for me? thats my personal site. maybe it was down. im not sure. try it again

 

[gardinersigns]

Can't get calculator to work either, any idea?

 

[stillrocking]

Yeah not working at my end either

 

[VernsVinylGrafx]

i got all these PMs and the posts here. the link is not dead and never was. i just clicked it. it works perfectly fine.

 

[scuba_steve2699]

Nice calculator!

 

[gardinersigns]

Please email me link.

[email protected]

 

[Big City]

works great for me!!! awesome: tool/resource to have thank you for posting it for all to use!!!

 

[scuba_steve2699]

If you are looking for another type of calculator - I have a free one posted here that works similar to this one but has a few more features

http://www.t-shirtforums.com/general-t-shirt-selling-discussion/t207622.html#post1215066