Basically with this project we have several items that we are looking to accomplish. We are to export our order processed dates along with the order ship dates - and we are looking to use this data in Excel to create some reporting features to calculate the order turnaround times, and some general stats on our order shipments.
For this report we are basically wanting to gather statistics on our shipments along with calculating certain parameters (explained further in detail in this document)
I have created a sample excel file on how we would like the report to look like in an excel file called Report [url removed, login to view] This finished Excel File is not perfect however we can add some better cosmetic looks to this - we are open to this if it can be improved on.
I have attached sample files for this project in a zipped format for you.