Excel Chart Tool

Closed

Hello Experts

I’m looking for an excel expert to develop a tool with a very nice interface, format, coloring {overall design} to satisfy the followings:

1-A tab to enter the following data {IN-Input Sheet} and to save them into a table in another tab called {IN-Log}

[url removed, login to view] date: normal date field

[url removed, login to view] : text field

[url removed, login to view]: text field

[url removed, login to view]: text field

[url removed, login to view]: number field

[url removed, login to view]: number field

[url removed, login to view]: text field

[url removed, login to view]: text field

[url removed, login to view]: text field

[url removed, login to view]: text field

[url removed, login to view]: text field

[url removed, login to view] Date: normal date field OR text field for example: {Early Feb, Mid Feb, Late Feb, 1st /2nd H Feb, 1st /2nd /3rd /4th Q Feb}

[url removed, login to view] Date: normal date field OR text field for example: {Early Feb, Mid Feb, Late Feb, 1st /2nd H Feb, 1st /2nd /3rd /4th Q Feb} / or a number of DAYs

[url removed, login to view] Loc : text field

[url removed, login to view] Loc : text field

[url removed, login to view] : text field

[url removed, login to view] : text field

[url removed, login to view]: this field will have a link to a file/image/email in outlook need to be attached to this record

2-A tab to enter the following data {OUT-Input Sheet} and to save them into a table in another tab called {OUT-Log}

[url removed, login to view] date: normal date field

[url removed, login to view] : text field

[url removed, login to view]: text field

[url removed, login to view]: number field

[url removed, login to view]: number field

[url removed, login to view]: text field

[url removed, login to view]: text field

[url removed, login to view] Date: normal date field OR text field for example: {Early Feb, Mid Feb, Late Feb, 1st /2nd H Feb, 1st /2nd /3rd /4th Q Feb}

[url removed, login to view] Date: normal date field OR text field for example: {Early Feb, Mid Feb, Late Feb, 1st /2nd H Feb, 1st /2nd /3rd /4th Q Feb} / or a number of DAYs

[url removed, login to view] Loc : text field

[url removed, login to view] Loc : text field

[url removed, login to view] : text field

[url removed, login to view]: this field will have a link to a file/image/email in outlook need to be attached to this record

3-Sheet { IN-Log }, should list all the records inputted via {IN-Input Sheet} with a check box at the first column of each record {to be used for selection later}

4-Sheet { OUT-Log }, should list all the records inputted via {OUT-Input Sheet} with a check box at the first column of each record {to be used for selection later}

5-Gantt Chart Generation tab {GNT CHRT}: this sheet should have the option to select WHICH sheet I want to draw my Gantt chart from {IN-Log/OUT-Log} and after selecting the sheet, a list of all the fields names for the selected sheet should be displayed to select which ones we want to show to the left side of the Gantt Chart {like what we have in MS Project, we have some fields displayed to the left of each bar having some details about the drawn bar} . Now after selecting which sheet to draw the chart from and what are the fields to show, we need to select the RECORDS from that sheet to draw our chart based on them and their DATE VALUES.

6-When we finish setting all these information and want to generate the chart we should have options for drawing the chart as follow:

[url removed, login to view] the chart for the entire year “Current Year” - DAYS , so we should have a calendar from January to December where every single DAY is shown on the chart to be filled

[url removed, login to view] the chart for the entire year “Current Year” – MONTHS, so we should have a calendar from January to December where every single month is represented with ONE CELL to be filled

[url removed, login to view] the chart for 3 years ahead – MONTHS, so we should have a calendar from January to December for the current year PLUS the same for the next coming 3 years where every single month is represented with ONE CELL to be filled

[url removed, login to view] the chart for 5 years ahead – MONTHS, so we should have a calendar from January to December for the current year PLUS the same for the next coming 5 years where every single month is represented with ONE CELL to be filled

**** Please view attached requirements document for better view and understaning

Skills: Excel, Microsoft

See more: what month is january, what month is december, the month of january, outlook experts, need experts in excel, names generation, microsoft project experts, microsoft outlook expert, microsoft excel 2013 expert, m format in excel, looking for an excel expert, january is the month of, january is month, i need the number for microsoft outlook, file excel expert, experts in excel, experts excel microsoft, experts excel, expert in microsoft excel, excel out source, excel experts email, design chart, box design drawing, all experts excel, gantt project

Project ID: #4240238

14 freelancers are bidding on average $150 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$250 USD in 7 days
(59 Reviews)
6.3
pkcyber

See you PMB

$99 USD in 1 day
(18 Reviews)
5.1
MDavidCrompton

Hi, Have read the full spec and I see no reason why this cannot be achieved, although I am sure there will be a few problems and issues, hence 7 days. I am UK based, a native English speker and have experience of Excel More

$250 USD in 7 days
(22 Reviews)
4.9
pierreho

Dear adel980, your need seems to be clear for me. I can do it. Just be aware that it will requiere some VBA code to make data transfered from one sheet to an other. Looking foreward.

$250 USD in 7 days
(24 Reviews)
4.8
javed1705

dear sir please check pm

$70 USD in 1 day
(12 Reviews)
4.1
cosconeaionut

Hi I can help you with VBA. If you need me contact me. Best regards,Ionut

$190 USD in 6 days
(6 Reviews)
3.6
Tablassus

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check a few sample works in PM. Best regards Filipe Francisco , VB Expert =============== More

$180 USD in 2 days
(7 Reviews)
3.5
vedranvivoda

Hello! Project is explained in detail and seems clear, I'd like to help you out. I attachment you can find sample of excel file which stores inputed data. Check pm for reference

$100 USD in 4 days
(1 Review)
1.6
sandeep25101982

Hi ASP.Net/C#,MVC,WCF, WPF and HTML CSS JQuery Expert here. My portfolio here http://bit.ly/WQdaPS

$100 USD in 10 days
(0 Reviews)
3.8
lisaveta

Hi, I prepared a sample file as a proof of concept - please have a look at your pm

$250 USD in 7 days
(0 Reviews)
0.0
amitchaps

Hi, I am interested in doing this project. We are Excel experts and have done many Data Extract, Analysis and Representation projects in Excel. To review my work you can refer my profile for some ready made Excel Te More

$30 USD in 7 days
(0 Reviews)
0.0
swakte

I am good in Excell. I can do your work as per your requirement within your time.

$30 USD in 4 days
(0 Reviews)
0.0
jellymae02

My last jobs includes ad posting of a certain company. I can assure you that it will imply very good outcome. I am also expert in MS Excel,MS Word application and PDF conversion.My typing speed is 85 wpm. I am enthusia More

$250 USD in 7 days
(0 Reviews)
0.0
abdullahdh83

Dear Sir, I am expert on Excel. I am a new freelancer on freelancer.com but I work in Odesk from 1 year. I read your job posting and I understand you job and I complete your job easily and under time and budget. More

$50 USD in 7 days
(0 Reviews)
0.0