Sanjel-Energy-Services / eService_WorkItems

0 stars 0 forks source link

Sales Forecast Import Issue #178

Open JasonSchneider19 opened 6 months ago

JasonSchneider19 commented 6 months ago

Currently in the sales forecast we have the following: image with a drill order of: image

So the project is 52 wells (104 jobs) The drill order info is 5 well count with iteration 1 and 2 This means that 5 surfaces then 5 intermediates are done, then the remainder of the project. This will be 52 - 5 = 47 wells remaining. On import this will do 5 surfaces, 5 intermediates, then 47 surfaces then 47 intermediates.

The desire is to repeat the drill order & well count of the representative program until the project well count is reached. So for this example: 5 surfaces, 5 Intermediates 5 surfaces, 5 intermediates 5 surfaces, 5 intermediates 5 surfaces, 5 intermediates 5 surfaces, 5 intermediates 5 surfaces, 5 intermediates 5 surfaces, 5 intermediates 5 surfaces, 5 intermediates 5 surfaces, 5 intermediates 5 surfaces, 5 intermediates 4 surfaces

Here is another example: image image

So we expect: 12 surfaces 12 intermediates to start then we will get 32-12 = 20 surfaces then 20 intermediates Using the custom import to start on March 30th: image image image image

The desire is to have 12 surfaces 12 intermediates 12 surfaces (repeat rep program well count & drill order) 12 intermediates (repeat rep program well count & drill order) 8 surfaces (remainder using drill order) 8 intermediates (remainder using drill order)

in an example where there are 2 programs Project = well count = 32 Program 1 = 12 well count, surface (iteration 1), intermediate (iteration 2) Program 2 = 10 well count, surface (iteration 1), intermediate (iteration 2) Representative Program = Program 1 Import should show: 12 surfaces 12 intermediates 10 surfaces 10 intermediates 32-12-10 = 10 surfaces, 10 intermediates

in an example where there are 2 programs Project = well count = 32 Program 1 = 12 well count, surface (iteration 1), intermediate (iteration 2) Program 2 = 10 well count, surface (iteration 1), intermediate (iteration 1) Representative Program = Program 1 Import should show: 12 surfaces 12 intermediates 10 x (surfaces then intermediate) 32-12-10 = 10 surfaces, 10 intermediates

2 ways to help deal with this: 1) Allow a single program to be added multiple times 2) Use the well count of the representative program in the repeat of the remaining wells

awangatsanjel commented 6 months ago

@JasonSchneider19

  1. I think this was a mistake Arcurve made, the drillorder was designed to implement the way you expect.
  2. In theory, we will need a new drill order from the remaining wells. I would like to implement the formal way. Then the shortcut will be available easily.

I think Metashre should be able to do it. I will talk to them for the cost. It can be managed in April project.

JasonSchneider19 commented 6 months ago

@awangatsanjel How do we use the well count and drill order of the representative program? I also think that adding the same program multiple times would be helpful. Then in the sales tool they can control the well count per each added program as desired.

awangatsanjel commented 6 months ago

@JasonSchneider19 All you asked at very beginning are good.