Conversion of Excel-based model to SQL or MySQL

Cancelled Posted Nov 24, 2010 Paid on delivery
Cancelled Paid on delivery

The project is to convert the attached Excel model to one that utilizes a relational data base. We would like to have an object-based application that allows us to build the models (like the one attached), which are customized to each client, in a simpler fashion.

In essence, a sales projection is input(C3), monthly sales forecasts are input (F4,T4,M4 etc) and then related expense percentages added (D22, D23 etc) and it creates a monthly forecast. When Actuals are input (H8,H9,H10 etc), it compares the actual to forecast on a dollar and percentage basis (columns J,K etc). The user can immediately tell if the amount or the percentage for each line item is above or below forecast based on color (red and green). YTD totals are included at the end.

One addition to the attached model we would like to add is the ability to forecast an expense by month (eg, D22 applies a cost for the entire year that is amortized monthly). The desire would be to forecast (for example) Auto Insurance at 1.2% of revenue in January and 1.2% for June only.

Further, the current model is given to clients and they manage the model themselves. The ability to export to HTML or XML and charge a subscription for access would be a welcome addition.

The attached is an example of a single branch. The application needs to allow for branches to be added, which then requires a Consolidated view.

Further, data is collected from a client as an export from Quickbooks. We also have a template that massages and redirects this data for input into the attached model, so once this assignment is done, the template will need to be completed.

.NET Excel Intuit QuickBooks MySQL PHP

Project ID: #864299

About the project

30 proposals Remote project Active Dec 28, 2010

30 freelancers are bidding on average $685 for this job

krishdts

Please check PMB for details.

$1200 USD in 25 days
(105 Reviews)
8.7
ccpplinux

Hi, Please see PMB for demo of a similar project and more details. Best Regards ... ccpplinux

$600 USD in 20 days
(163 Reviews)
7.1
rajtuhin1

I have the maximum number of satisfied customer all over the world (complete 219 projects round the globe). Select me for full satisfaction, maximum quality of the software, value for money and project completion on ti More

$500 USD in 10 days
(143 Reviews)
7.1
barundebnath

Please check your PM.

$750 USD in 20 days
(69 Reviews)
6.6
agilitysoftwares

Please check your PMB after few minutes for more details.

$675 USD in 10 days
(13 Reviews)
6.7
tejas34

Please check PMB.

$800 USD in 16 days
(30 Reviews)
6.0
vbexcel

Ten years experience in developng financial models.

$250 USD in 5 days
(32 Reviews)
5.6
pixarsolution

I have reviewed your requirement and can work for you. Check PM

$500 USD in 8 days
(14 Reviews)
5.7
VirtualHorizon

Dear Project Owner, we have read the terms and conditions of your project and want make sure that it would be completed with in the time that we have given to you. For more details please check PMB. Thanx with wa More

$800 USD in 30 days
(16 Reviews)
4.6
kandiyaar

Hi , Please Check My PMB !

$1500 USD in 1 day
(12 Reviews)
4.8
anjeko

Hello, Please read my PM Regards Jerry

$950 USD in 15 days
(3 Reviews)
4.5
bmircea

Please check PM

$750 USD in 20 days
(1 Review)
3.8
mastersoft1

I'm an experienced C# programmer I can help you

$800 USD in 10 days
(7 Reviews)
3.1
chch50

Hi, I'm ready to work for you on this project.

$500 USD in 5 days
(6 Reviews)
2.5
aadu22

Hello Please Refer An PMB

$1100 USD in 5 days
(1 Review)
1.4
olsoft

can be done.

$250 USD in 14 days
(3 Reviews)
1.9
duy81

Plz check your PMB.

$300 USD in 7 days
(0 Reviews)
0.0
OlegBPavlov

Hi. Please see the PMB.

$600 USD in 18 days
(0 Reviews)
0.0
LajosArpad

Hello, I'm interested in creating a database for you. Best regards, Lajos Arpad.

$500 USD in 1 day
(0 Reviews)
0.0
dreamsoft4u

Highly exp. company of successfully converting large size excel based plant to automated system. Please have a look at PMB.

$1500 USD in 60 days
(1 Review)
0.0