Analysis Tool
I have attached a worksheet with 2 columns. This is a subset of data that represents a monthly invoice. My sample contains a few records, but the invoice typically contains approximately 325-400 entries.
I am seeking a the creation a tool, ideally something in Excel that provides an allocation mechanism. We are still refining the logic but are seeking someone to get us started and assist in generating something functional that can easily be used by non-tech users to get the job done. It involves an automated analysis of data returning certain statistics and results. The initial idea is to provide some VBA form or macro to provides an easy mechanism for selecting the range for the data, then providing the results and recalcs.
Here are the core things that need to solved - some easy, some will need further explanation:
1) [Input] User selects range of data.
1a) [input] User enters a baseline amount. This is an arbitrary amount. It is effectively the cumulative average of previous periods. This amount will be compared against the current average amount. The difference will be displayed. The user will decide later if they wish to base their final results based on the baseline amount.
2) [output] Need to provide a single value representing the average cost of the range of items.
3) [output] Need to identify a list of items which items are over the average cost.
4) [Output] Need to further refine the list of over-the-average items to display items that are (n)percent over the average.
5) Need to provide a recalcualted list that reveals the average amount for each ID, but for IDs above (N) average a prorated amount which represents additional amounts (effectively as a penalty for being above the average). When all items are summed results in new allocation the same sum of the invoice total. This may require further discussion.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Excel ?