I gang

Sheet cutting function

I require a VBA function created that will calculate the amount of stardard size sheets required to cut a number of smaller sheets from.

Example: Public Function GetSheetsRequired(iSheetHeight as Int, iSheetWidth as Int, iSheetCutHeight as int, iSheetCutWidth as int, iQuantity as int).

Call Example: GetSheetsRequired(1200, 2400, 600, 400, 20) should return 2, as it will require 2 1200 x 2400 sheets to cut 20 600 x 400 sheets.

Be aware that the cut required may be 4000 x 600, in this case only 1 sheet is required, as it is not possible to have one single piece of this size cut from a sheet that is only 1200 x 2400.

Where possible the cut sheet should be in one piece except in cases like the one above.

Evner: Visual Basic

Se mere: number function, int size c, int i, function number, a cut above, sheet, int, function, cut above, cases, size function, call function, vba function, aware, vba sheet, vba sheets, cut size, sheet cut, 400 vba, sheet cutting, 4000, call number, vba calculate return, sheet vba, piece

Om arbejdsgiveren:
( 0 bedømmelser ) Peakhurst, Australia

Projekt ID: #110028

Tildelt til:


This will be a very simple function that will output the number of pieces required and will take care of the exceptional cases also. Pls. award the project and get the delivery on the same day. Thanks, ssTechnosoft.

$30 USD på 1 dag
(0 bedømmelser)

8 freelancere byder i gennemsnit $63 på dette job


Looking forward to working with you

$50 USD in 0 dage
(54 bedømmelser)

Hi, Please check PMB.

$52 USD på 1 dag
(13 bedømmelser)

Please see detail on PMB. regards, Asghar

$90 USD in 2 dage
(4 bedømmelser)

Hello I will like to try this.. PLz see PMB for details..

$100 USD in 2 dage
(3 bedømmelser)

I would be happy to provide you with the service you require and deserve!

$50 USD på 1 dag
(1 bedømmelse)

Dear Sir, Shivam Infonet Pvt. Ltd. is a customer-specific service oriented company has got rich experienced software professionals. We are the Professional Web and application Development Company having 5 years of Flere

$100 USD på 1 dag
(1 bedømmelse)

i will give good knowledge of your project

$30 USD in 2 dage
(0 bedømmelser)