Integrate Ms Excel to make it work as a frontend for a application using sql server as backend
$1000-2500 USD
Closed
Posted about 9 years ago
$1000-2500 USD
Paid on delivery
We have our own Demand Planning [login to view URL] this tool we use SQL SERVER/DB2. We want to create an Excel Plug-In for this Demand Planning tool. The objective is to allow Demand Planning process to be carried out on Excel.
The excel should be working as a front-end for this tool and we expect to have all the flexibility in excel that we presently have in our custom front-end. We know that this is possible and someone who have the required expertise can do it a months time.
Before awarding the project, i would like to see a small demo, where you should integrate a small database (SQL SERVER) with excel and then load some data from the database to excel. This part is easy.
Now what i need is to see, is, we will load the data using pivot function in excel and we should have the ability to edit data from the pivot and the edited data should be saved in the database. The standard pivot function doesn't allow editing. This is where you have to create a custom function similar to pivot in excel, where we should have the ability to edit and save data.
The freelancer/ freelance team, who can show me the demo first will be awarded the project
Happy bidding.