Business Rule Engine, Excel Office Automation with Master Page
$30-5000 USD
Closed
Posted over 15 years ago
$30-5000 USD
Paid on delivery
Business Rule Engine, Excel Office Automation with Master Page
Given the use of office automation or cell links between workbooks in Excel, create a method to take a master sheet containing budget amounts for an entire company and create distributions to numerous other company offices' spreadsheets based upon weighted averages, equal divisions, and other equations that would allow a user to select source value, a method of distribution, target offices and cell values. The method should use user friendly prompts to accomplish all these tasks and should result in a table that could be then be used to automate the actual distributions to the individual offices using office automation. It looks like this ability would require a business rule engine to allow the user to dynamicly build calculations.
Some known steps to accomplish this task follow:
Open a master sheet containing the formulas
Open a target sheet (store)
Copy each formula or value of the calculation from each source cell to the appropriate target cell(s)
Save and Open the next target sheet
Repeat across all the target sheets.
This project will be for applying accounting allocations to hundreds of budgets.
In the attached example the General Office Insurace of $800 needs to be allocated to Denver Store, Dallas Store, and Austin Store.
Provide at least the following working examples in the solution.
Example 1: Allocate the amount evenly.
Example 2: Allocate the amount by weighted average of Total Expenses.
Example 3: Allocate a specific amount.
You should have the ability to complete this request based on the examples provided and knowledge of what typical Accounting Applications do in the subject matter area or be willing to research the subject matter as a part of this request. Specific technical specifications are not available.
## 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
Visual Studio 2005
SQL Server 2005
Microsoft Office 2003