Project Tracker

bobgrand

Board Regular
Joined
Apr 14, 2008
Messages
220
Hello all,

I am searching through the templates for a project tracker. One that will track customer releases by date along with sales orders and corresponding purchase orders to suppliers.

Calculate released quantities against the estimated beginning quantity to know how much remains.
Calculate the cost of goods. How much value has been used to how much is remaining.

Changes can be made to a specific release mid stream. Example. 1 x 500' of Wire for Release 14 was issued on 2/17 to be delivered on 6/18. Release 14 changed to 14-A on 5/15 to 2 x 325' of wire to be delivered on 6/18.

We are using a sheet that someone created but it does not have the structure to track these types of changes. I am working on manipulating the sheet we have now but I was hoping someone could guild me in a direction to a template or if someone has something they wouldn't mind sharing.

Any guidance would be greatly appreciated.

Thank you
Bob
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,005
col Bcol J
orderdatedetailsqtydeliveryupdate dateupdate detailsupdate qtyupdate delivery
12317/02/2018500118/06/201815/05/2018325218/06/2018
45618/02/2018600228/05/2018
CONSTANTLY UP TO DATE ORDER BOOK
ORDERDATEDETAILSQTYDELIVERY
12315/05/2018325218/06/2018
45618/02/2018600228/05/2018
a simple formula checks if column G update date is not blank
and in that case takes the updated order details
otherwise details are as first entered

<colgroup><col><col><col><col span="2"><col span="2"><col><col><col><col></colgroup><tbody>
</tbody>
 

Watch MrExcel Video

Forum statistics

Threads
1,123,354
Messages
5,601,139
Members
414,430
Latest member
jtdinh205

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top