Comprehensive charting from an excel database

Completed Posted Jan 24, 2012 Paid on delivery
Completed 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.

C# Programming Data Processing Graphic Design Mathematics Order Processing

Project ID: #1406030

About the project

14 proposals Remote project Active Feb 7, 2012

Awarded to:

tdSolomons

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 More

$100 USD in 10 days
(29 Reviews)
4.9

14 freelancers are bidding on average $275 for this job

srinichal

I can deliver the code

$520 USD in 5 days
(40 Reviews)
6.5
eperfections

Please see PMB

$525 USD in 5 days
(17 Reviews)
5.5
z0mbie

Hi, please check PM. Thanks!

$300 USD in 3 days
(7 Reviews)
5.0
Ohuma

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
(9 Reviews)
4.7
RotorProgrammer

Hello. I can write program for charting your data from Excel database according to your requirements.

$300 USD in 7 days
(6 Reviews)
3.5
Pichart

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 proje More

$200 USD in 5 days
(7 Reviews)
3.4
cybermath

Please read my private message...

$150 USD in 3 days
(4 Reviews)
3.0
supenparmar

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 Reviews)
0.0
fbfansgone

Please check PMB

$150 USD in 1 day
(0 Reviews)
0.0
vendeta

i have done similar projects.

$300 USD in 2 days
(0 Reviews)
0.0
mkheidzedavid

Hello! I will deliver quickly.

$200 USD in 5 days
(0 Reviews)
2.8
akashtutorial

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 Reviews)
0.0