Closed

Write a cutting length optimization spreadsheet

Hi.

I need someone to write me a excel based spreadsheet that will calculate the minimum wastage when cutting products from a stock length.

For example, we stock tube in 5000mm lengths, and we sell it in every possible length from 200mm to 5000mm. I need to be able to paste a column of lengths into a excel spreadsheet, and it will calculate 1. how many 5000mm tube lengths are required and, 2. what is the most economical way to cut them with the least wastage.

This second point is very important and needs to create a cutting list of the products in order of cut. The 5000mm length needs to be a variable field so the calculator can also be used for profiles that are 6000mm etc.

Also, there will need to be a field that i can enter in the width of the cut (blades vary from [url removed, login to view] to [url removed, login to view]) to ensure that this doesn't affect the cutting list.

Skills: Engineering, Microsoft, PHP, Software Architecture

See more: cut length optimization calculator, length cutting spreadsheet, spreadsheet engineering, calculate and write, cutting stock optimization, stock spreadsheet excel, stock optimization, stock excel spreadsheet, length width calculator php, cut paste products, spreadsheet calculator php, write point click adventure game script, excel spreadsheet field, calculator excel php, point point calculator, write point click adventure game, write point click game, excel create spreadsheet, stock required excel, calculator php excel, stock spreadsheet, excel required stock, excel php calculator, php calculator excel, excel calculator php

About the Employer:
( 0 reviews ) United Kingdom

Project ID: #4665684

10 freelancers are bidding on average £141 for this job

bchandra1955

Professional computer science domain engineer can take care

£142 GBP in 5 days
(29 Reviews)
5.1
miniric3

Kia ora! Mulvays.com are a NZ based web and software design company who have seen you here on the freelance market and are really excited about working with you and treating you to the full service, professional experi More

£618 GBP in 10 days
(5 Reviews)
4.9
thanhhungqb

Dear sir, I am interested in your project. Please see pmb for details. Thanks.

£100 GBP in 3 days
(9 Reviews)
3.5
jaylancer43

Excel VBA Expert. Please check PM for details. Thanks.

£111 GBP in 3 days
(4 Reviews)
2.9
gohan100100

I have a bachelors degree in mechanical engineering and I'm extremely proficient with excel. This would be a piece of cake... and I would actually enjoy doing it.

£76 GBP in 3 days
(0 Reviews)
0.0
faycoyote

i hope you don't have more additional requirement beside on what you've mention here :) ready to help, i'm very negotiable ;)

£111 GBP in 2 days
(0 Reviews)
0.0
MatejD

This can be solved as a simple linear programming problem, which I just spent 3 month listening a course for Operational Research and Optimization. I can easily solve this problem.

£70 GBP in 3 days
(0 Reviews)
0.0
zshah7

I am experienced at using spreadsheet and did alot of similar projects at college

£55 GBP in 5 days
(0 Reviews)
0.0
mechengoffice

I am Mechanical Engineer with fifteen years experience in 2D and 3D drawings of mechanical engineer and metallic constructions. Before 10 years I worked for a company and I had made an excel file with this calculation. More

£100 GBP in 5 days
(0 Reviews)
0.0
zExcel

I can help you accomplish this task in Excel

£28 GBP in 3 days
(0 Reviews)
0.0