Find Jobs
Hire Freelancers

Comprehensive charting from an excel database

$100-300 USD

In Progress
Posted over 12 years ago

$100-300 USD

Paid on delivery
I want to have a comprehensive charting from a database. The crucial mathematical aspect of the project is automatic drawing of lines for specified angles from a certain datapoint on the chart. The database has already exist in excel and growing every day, which might be submitted as example. The computer program must be capable to satisfy the conditions as follows: • The first column of the database is historical dates. The second and consecutive (might be hundreds of but not thousands) columns are different numeric values for different products at that day of first column. • The program will draw the chart where X-axis is dates from first column and Y-axis is corresponding values of chosen product. The program simultaneously will draw optionally defined angle lines on the chart. The name of product will be optinal, manually written, at front page. • The related angle lines will start from extreme max and min values at its historical date. The starting extreme max and min dates will be optinal, manually written, at front page. • In order to avoid from charting all database all the time there will be option cell in front page to write how many days before the chosen max or min will be starting point of charting. If blank all database. • There will be 15 different cells, which will define the number of lines to draw as well, in order to write the degrees of angles to draw lines on the chart at the front page. Upward sloppings might be "+" where downwards "-" i.e. cell 1: +15 cell 2: -30 where angles will be one upward 15 degrees and one downward 30 degrees. Every angle line would be different color, where there is no need to be optional. Fixed to visually easy colors are enough. • The same charting capability will be possible for relative values of the products. The relative product will be optinal, manually written, to a cell at the front page. If this cell is blank outright value charting of the chosen product, if this cell is filled relative value charting will be valid. i.e. Let's say chosen product is A and relative chosen product is B then charting and drawing of related angles will use A divided by B, A/B, values. If relative product cell is blank then the chart will use outright values of product A. • The charts would be different window from front page and the program will be capable to draw seperate charts in a different windows depending on changes at optinal cells in the front page. There might be a button of "Draw chart" at the front page, in order to draw seperate chart with given optional cells values at the front page at that moment. • The date and values at X-Y axises, the name of product- if it is valid the name in relative such as A/B, the degrees of angles will be on the chart. I want to see the value and date for a specific data point on the chart by using cursor as well. • Saving and printing has to be possible for charts. I do not force the use any programming language. You will be free to chose which program to use for the project. The only criteria is that it has to be user-friendly common known program with high performance for the needs of project.
Project ID: 1406030

About the project

14 proposals
Remote project
Active 12 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
Awarded to:
User Avatar
Let's [login to view URL] expert in software programming & i have my few softwares selling online. I have read your description & i totally understand required abilities in the software. i will code with Visual Basic.Net. It will take 10 days to code and test the Software. Please send me more details and sample details of few products(a ample database file etc.).
$100 USD in 10 days
4.8 (29 reviews)
4.9
4.9
14 freelancers are bidding on average $275 USD for this job
User Avatar
I can deliver the code
$520 USD in 5 days
4.9 (40 reviews)
6.5
6.5
User Avatar
Please see PMB
$525 USD in 5 days
5.0 (17 reviews)
5.5
5.5
User Avatar
Hi, please check PM. Thanks!
$300 USD in 3 days
5.0 (7 reviews)
5.0
5.0
User Avatar
Experienced Statistician here with excellent use of advanced MS Excel and other statistical softwares with great graphical capabilities. Please see PMB fro details
$300 USD in 5 days
5.0 (9 reviews)
4.7
4.7
User Avatar
Hello. I can write program for charting your data from Excel database according to your requirements.
$300 USD in 7 days
5.0 (6 reviews)
3.5
3.5
User Avatar
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I have view your project description and find that this has something similar to my previous project. I attach the sample file in PM.
$200 USD in 5 days
4.8 (7 reviews)
3.4
3.4
User Avatar
Please read my private message...
$150 USD in 3 days
4.8 (4 reviews)
3.0
3.0
User Avatar
Sir, I am new in freelancer. I have big experience in Data Entry, Web Research, Data processing, Data conversion, Data Extraction and Data Capture. So please give me opportunity to do this .
$300 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please check PMB
$150 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i have done similar projects.
$300 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello! I will deliver quickly.
$200 USD in 5 days
0.0 (0 reviews)
2.8
2.8
User Avatar
we run a coaching institute and have a group of engineers who are willing to work as a freelancer so please contact us . 9990636402 9958036239 ravi jain
$200 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of TURKEY
Istanbul, Turkey
5.0
2
Member since Jan 24, 2012

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.