DSF

RogerC;71592 wrote:I do mine the old fashioned way...think of a number, double it add 20%, subtract a couple of pence, add postage and packing and then think 5od it ...I'll charge X amount :rolleyes:

sound very similar to mine!! but i always say call it this or that for friends which when i have a good think later ive usually lost somewhere along the line.

Ok, here's first go at things.

www.dosime.co.uk/DyeSubCalculatorPricing-v1.xlsx

There are five sheets:
1. Customer Quote - Does nothing just shows a simple qty/product/gross/net. You don't need to change anything on this sheet.
2. Quote Calculator - This is where you do most of the work. There are 7 fields you can change to get your prices out.
3. Products - Here you enter all the details that you need for each product.
4. Materials - Same as above. Should work with rolls as well as sheets. The Quote Calculator should tell you how many sheets or rolls you'll need if you enter the correct dimensions.
5. Settings - Lots of little things, VAT, wages, ink cost, stuff like that. As well as postage requirements.

I'll give a go at annotating it next week.

Feel free to comment, suggest changes etc.

Cheers,
J.

Mods, the attachment upload only allows doc, xls, and not docx, xlsx, worth an update/change to the approved list?

Johnny That is Very impressive! Thank you

I can't get the link to do anything?

James990;71730 wrote:I can't get the link to do anything?

Try copy and pasting it to the address bar? I know it works this end.

sharyn;71729 wrote:Johnny That is Very impressive! Thank you

Thanks! Anything you'd change?

very technical, this is excatly what someone like myself really needs to use, but im so old fashioned i find excel difficult, i am definatly going to look into this formula and hopefully change my ways and pricing structure definatly if i want to take my hobby to the next level.
cheers

Dave271069;71738 wrote:very technical, this is excatly what someone like myself really needs to use, but im so old fashioned i find excel difficult, i am definatly going to look into this formula and hopefully change my ways and pricing structure definatly if i want to take my hobby to the next level.
cheers

Hope it's some help to you.
Actually, about 6 months ago, I did a similar paper version, I tell you it was like a census form! But it worked.

For those having problems, I don't think it opens in certain browsers.....

Correct, no matter what I do I can't open it.

James990;71741 wrote:Correct, no matter what I do I can't open it.

Right click and save as?
Do you have a version of excel that is 2010 onwards?