Find Jobs
Hire Freelancers

Conversion of Excel-based model to SQL or MySQL

$250-750 USD

Cancelled
Posted over 13 years ago

$250-750 USD

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.
Project ID: 864299

About the project

29 proposals
Remote project
Active 13 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
29 freelancers are bidding on average $688 USD for this job
User Avatar
Please check PMB for details.
$1,200 USD in 25 days
4.9 (104 reviews)
8.8
8.8
User Avatar
Hi, Please see PMB for demo of a similar project and more details. Best Regards ... ccpplinux
$600 USD in 20 days
4.9 (166 reviews)
7.1
7.1
User Avatar
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 time. I will communicate through this site + chat + mail + team viewer. -regards : Raj
$500 USD in 10 days
5.0 (143 reviews)
7.1
7.1
User Avatar
Please check your PM.
$750 USD in 20 days
5.0 (72 reviews)
6.7
6.7
User Avatar
Please check your PMB after few minutes for more details.
$675 USD in 10 days
4.6 (13 reviews)
6.7
6.7
User Avatar
Please check PMB.
$800 USD in 16 days
4.9 (30 reviews)
5.9
5.9
User Avatar
Ten years experience in developng financial models.
$250 USD in 5 days
4.9 (33 reviews)
5.7
5.7
User Avatar
I have reviewed your requirement and can work for you. Check PM
$500 USD in 8 days
4.7 (14 reviews)
5.7
5.7
User Avatar
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 warm regards Team Vedang software
$800 USD in 30 days
4.9 (16 reviews)
4.6
4.6
User Avatar
Hi , Please Check My PMB !
$1,500 USD in 1 day
4.5 (12 reviews)
4.8
4.8
User Avatar
Hello, Please read my PM Regards Jerry
$950 USD in 15 days
4.9 (3 reviews)
4.5
4.5
User Avatar
Please check PM
$750 USD in 20 days
5.0 (1 review)
3.8
3.8
User Avatar
I'm an experienced C# programmer I can help you
$800 USD in 10 days
5.0 (5 reviews)
2.9
2.9
User Avatar
Hi, I'm ready to work for you on this project.
$500 USD in 5 days
5.0 (6 reviews)
2.5
2.5
User Avatar
Hello Please Refer An PMB
$1,100 USD in 5 days
5.0 (1 review)
1.4
1.4
User Avatar
can be done.
$250 USD in 14 days
4.0 (3 reviews)
1.9
1.9
User Avatar
Plz check your PMB.
$300 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I'm interested in creating a database for you. Best regards, Lajos Arpad.
$500 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Highly exp. company of successfully converting large size excel based plant to automated system. Please have a look at PMB.
$1,500 USD in 60 days
0.0 (1 review)
0.0
0.0
User Avatar
Hi I want to get this job see my PM
$250 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PAKISTAN
karachi, Pakistan
4.8
101
Payment method verified
Member since May 28, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.