Sedang Disiapkan

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.

Kemahiran: Visual Basic

Lihat lagi: 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

Tentang Majikan:
( 0 ulasan ) Peakhurst, Australia

ID Projek: #110028

Dianugerahkan kepada:


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 dalam sehari
(0 Ulasan)

8 pekerja bebas membida secara purata $63 untuk pekerjaan ini


Looking forward to working with you

$50 USD dalam 0 hari
(54 Ulasan)

Hi, Please check PMB.

$52 USD dalam sehari
(13 Ulasan)

Please see detail on PMB. regards, Asghar

$90 USD dalam 2 hari
(4 Ulasan)

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

$100 USD dalam 2 hari
(3 Ulasan)

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

$50 USD dalam sehari
(1 Ulasan)

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 Lagi

$100 USD dalam sehari
(1 Ulasan)

i will give good knowledge of your project

$30 USD dalam 2 hari
(0 Ulasan)