DSF

I had a play with this and love the idea of it just when i add a new product on the quote page i get the product name but all else displays N/A

Any ideas?

Glad you like it, though it still needs more work.
Did you put in a qty at the top? Which cells are you including in 'all else'?
Can you put up some screen shots?
J.

I shall do it later for you chap

Hello Johnny, i have attached a image showing what i think you need to see let me know if anything else.

Ok, that wasn't too bad. Couple of 'false' settings missing in the vlookups.
This one should sort it: www,dosime.co.uk/DyeSubCalculatorPricing-v3.xlsx
J.

Thanks ill take a look at this one now

From what i have found
When i select material, the supplier remains the same.
Under material unused width & length seems to remain in mm is that right, (im just testing with your coaster)
Edit: Under material its reading the unit price & supplier postage from the products sheet, the Supplier name also is not correct.

I must admit this is a very good set up as it is and factors in many costs. I use somthing similar for pricing sign vinyl. Maybe ill upload it when we get a file section.

Edit again: Ive uploaded a modified version that fixed the supplier name and costings
http://www.filedropper.com/copyofdyesubcalculatorpricing-v3


How would it be possible to add a postage type? For example RM or Courier maybe dependent on product size?
Thanks
Daz

Just come across this thread.

This seems like a great idea, However the link only opens to filedropper and unable to download the file.?.

great work though


Regards
Benn

Looks like the second link is missing .xlsx from the end But I don't think it works still! lol.

Hi dazzel,
I've corrected the error you pointed out, linked to the wrong worksheet I'm afraid.
I'm also going to add in a few more things for the next revision as well as fixing problems, if I get it right, it should have a fully pdf/printable quote sheet and cost prediction sheet.
J.

I must say Johnny's skills are second to none on this sort of thing. He has finished working for me today and will be missed.
He has created a number of calculators like this for me for use within my business. All saving me many hours quoting and making quoting a very accurate science. My staff now all have the tools to estimate without constantly asking me...

Wish you all the best John.