Queensland Ontario
29-09-2005, 01:15
I am trying to create a formula that allows me to create an available to promise field in an excel spreadsheet that generates an MPS.
My main problem is finding a way to get the formula to recognize where to start and where to stop counting the customer orders.
Can anyone give me an example of how to write an equation to solve the ATP?
Aryavartha
29-09-2005, 01:45
Why do you want to do this in Excel? :confused:
I am trying to create a formula that allows me to create an available to promise field in an excel spreadsheet that generates an MPS.
My main problem is finding a way to get the formula to recognize where to start and where to stop counting the customer orders.
Can anyone give me an example of how to write an equation to solve the ATP?
If you must do this in excel, it may be a bit tedious. I assume you only want to count certain orders based on a limited number of factors. If the variables are something simple like: has this order shipped or has this order already been subtracted from inventory, etc... Then you could simply add some columns that are yes/no checkoffs. Using this column, you could then set up a seperate total column that would only count orders if they had a yes or no in a specific column. You would use the "If-then" function. If you need more detail, ask. Tell me exactly what variables are necessary to determine whether an order should be counted.