I need a solution to match pipe
- or -
Post a project like this$$
- Posted:
- Proposals: 4
- Remote
- #877675
- Expired
Description
Experience Level: Intermediate
General information for the business: excell expert and data analysys
Description of excel work: hi, this is the problem.
i work in a little oilfield company.
i need a solution to automatize the order to matching the pipe to put in the well.
i explain.
i have 2 stocked pipe, one stock for one diameter, and one stock for other diameter.
this because it's necessary to put 2 parallel string pipe (by different size) togheter in the well.
the problem is that is necessary to find a match pipe to have pipe by pipe always a difference out of the well of +-50 cm. no less of 40, and no more of 100 cm
it's necessary to analize 20- 30 pipe at time, in order of the stocked, find a solution and continue to other stock.
it's necessary to consider that to find a solution generally i have 2 other stock pipe of little measure that help me to find a solution. this other stok it's named "pup joint" and have for each size.
i attach file that i used now. but this not have automation. it's all manual.
in this file i have a list of stock tbg and a matching pipe in "completamento lista discesa".
in this sheet from row 91 start the matching from a stock.
from row 1 to 90 is not to consider is a preassy tool out of stock.
i have already find a solution but not work propely and i search anyone that find a solution for this problem.
Extra notes: i attached one of my solution.
it'scalled pipe matcher. if you click on match pipe my solution find a good solution. but my file it's only for a one size couple. if i have 2 size 2 different stock pipe (look filecalled monte enoc) i not find a valid solution to solve...
Description of excel work: hi, this is the problem.
i work in a little oilfield company.
i need a solution to automatize the order to matching the pipe to put in the well.
i explain.
i have 2 stocked pipe, one stock for one diameter, and one stock for other diameter.
this because it's necessary to put 2 parallel string pipe (by different size) togheter in the well.
the problem is that is necessary to find a match pipe to have pipe by pipe always a difference out of the well of +-50 cm. no less of 40, and no more of 100 cm
it's necessary to analize 20- 30 pipe at time, in order of the stocked, find a solution and continue to other stock.
it's necessary to consider that to find a solution generally i have 2 other stock pipe of little measure that help me to find a solution. this other stok it's named "pup joint" and have for each size.
i attach file that i used now. but this not have automation. it's all manual.
in this file i have a list of stock tbg and a matching pipe in "completamento lista discesa".
in this sheet from row 91 start the matching from a stock.
from row 1 to 90 is not to consider is a preassy tool out of stock.
i have already find a solution but not work propely and i search anyone that find a solution for this problem.
Extra notes: i attached one of my solution.
it'scalled pipe matcher. if you click on match pipe my solution find a good solution. but my file it's only for a one size couple. if i have 2 size 2 different stock pipe (look filecalled monte enoc) i not find a valid solution to solve...
Tommaso A.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
27 Apr 2024
Italy
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies