Paper Sheet calculator

[mattchuma]

Hi guys

I made the attached to use when calculating how many sheets i will need to complete an order.
Could anyone please assist with how i can fix the problem i am currently facing.
As shown on the attached if sizes are entered differently (vice versa) the results are different - practically it is impossible to get 5 cut outs on a sheet as shown on the right side on the attached.

I am appealing for help as i tried and no luck on fixing this, i would appreciate if i can get a better version of the same spreadsheet.

BLEED section - it a drop down list that changes values on Reg marks for cutter & Add cutting gutter and/or bleed.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Paper Sheet calculator
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[mattchuma]

Paper Sheet calculator

Hi guys I made the attached to use when calculating how many sheets i will need to complete an order. Could anyone please assist with how i can fix the problem i am currently facing. As shown on the attached if sizes are entered differently (vice versa) the results are different -...

www.excelforum.com