We need a very simple yet very specific program written.
We are working for a distribution company.
As of now they have sales rep that send out emails with attached spreadsheets to all their customers.
The spreadsheets contain the current inventory level and a pricing that is specific to the customer group that the recipient belongs to.
The customer then needs to call in and place his order.
What we want is a script that will automatically generate that information into the spreadsheets based on information that was uploaded through admin_spreadsheets into a MySQL database.
The spreadsheets will then be available to customers anytime they want by logging on to our website.
The System will also email the spreadsheets once a week on a set schedule.
The tricky part is that we want the excel spreadsheets to include a "submit" button that will send the current spreadsheet via e-mail to a sales rep.
this way the customer can just open the spreadsheet (that he downloaded or got by email) and just add desired order quantity, hit submit and he's done.
This is the short description of the project, we obviously will need to include a decent looking website for the customers to access and download their spreadsheets, and a control panel to allow the admin to upload his spreadsheets.
36 freelancers are bidding on average $2683 for this job
I'm very interested in this project, we just finished another complex reports system based on complex sheets where we generate pdfs and pptx with some high end charts, i ll show you a demo in the admin.