Soldato
- Joined
- 23 Mar 2011
- Posts
- 11,100
Hey all!
I was just wondering if it's possible to use Excel in an effective way to help speed up quoting jobs etc.
Pretty sure we had a template in the past but these days do it all manually.
I work at a sub contract engineering company. So often we get requests to product parts in certain quantities, say 10, 20 and 50 for example.
We have to outsource material prices to add to this (which also varies by quantity)
So I'd be after a template to put in the quantity, material cost etc and then excel does some magic to calculate different totals based on the quantity types in, add on VAT etc. just to save us time in calculating it all manually, per quantity etc if that makes sense
Is that possible? I'm sure it's very basic tbh but I have NO knowledge of excel.. well, I haven't used it since school half my lifetime ago.
Thanks! There may even be a rough template out there to start with
I was just wondering if it's possible to use Excel in an effective way to help speed up quoting jobs etc.
Pretty sure we had a template in the past but these days do it all manually.
I work at a sub contract engineering company. So often we get requests to product parts in certain quantities, say 10, 20 and 50 for example.
We have to outsource material prices to add to this (which also varies by quantity)
So I'd be after a template to put in the quantity, material cost etc and then excel does some magic to calculate different totals based on the quantity types in, add on VAT etc. just to save us time in calculating it all manually, per quantity etc if that makes sense
Is that possible? I'm sure it's very basic tbh but I have NO knowledge of excel.. well, I haven't used it since school half my lifetime ago.
Thanks! There may even be a rough template out there to start with