Revise Machine Shop Schedule to track quantity of parts produced relative to the schedule

Ukończone Opublikowano 5 lat temu Płatność przy odbiorze
Ukończone Płatność przy odbiorze

Revise machine shop scheduling tool to track total quantity scheduled, made, and remaining for machines 1-19.

The worksheet should automatically calculate the number of parts produced on the 'Template' Worksheet. As you can see, the machine shop supervisor adds the number of parts produced in the far right column, and it calculates a percentage at the bottom. The problem is that the number at the bottom considers all parts produced, even if they exceeded the production schedule. I need the total number at the bottom to only reflect what is on the original published schedule, and not overruns or other parts. I would still like to track these, but the program should not use them in the total calculation at the bottom. I need this to be added to the template that is created each time the schedule is "Locked and published".

I would like Columns I,J,K to be part of the template when it is created

They should only be able to enter the quantity made in column K.

I and J should come from the schedule

Correction.

Made (column K) should track the column made as they enter the daily quantities complete through the week

And the quantity in column K can never exceed the quantity in column I

For Example, Machine 1 over built 119% for the week

This causes the percent complete at the bottom to be higher than it should.

Excel VBA

Numer ID Projektu: #17043091

O projekcie

4 ofert Zdalny projekt Aktywny 5 lat temu

Przyznany użytkownikowi:

paris2785

Hi, there. My name's Paris Pallas and I'm an experienced and skilled Excel developer. You're welcome to visit my portfolio where you'll get an idea of my professionalism and work quality. I've completed almost 230 p Więcej

$50 USD w ciągu 3 dni
(17 ocen)
5.0

4 freelancerów złożyło ofertę za $110 w tym projekcie

bouslimi1979

Dear, can you please provide the "Template" so it will be more clear and I can understand the logic of the macro you want to code. Thanks

$100 USD w ciągu 2 dni
(6 Oceny)
4.8
Taisho

Hello, I can edit existing VBA code to account for listed changes. However, at this moment there is no file attached to the project, therefore I would appreciate adding it or sending to me, so that I can review the Więcej

$90 USD w ciągu 2 dni
(8 Oceny)
3.8
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$200 USD w ciągu 3 dni
(3 Oceny)
2.3