Suljettu

Excel Chart Tool

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

Taidot: Excel, Microsoft

Näytä lisää: month december, outlook experts, need experts excel, names generation, microsoft project experts, microsoft outlook expert, microsoft excel 2013 expert, looking excel expert, january month, need number microsoft outlook, file excel expert, experts excel microsoft, expert microsoft excel, excel source, excel experts email, box design drawing, experts excel, gantt project, excel sheet expert, excel expert 2013, outlook 2013, names column, loc, image format excel, gantt

About the Employer:
( 16 reviews ) Doha, Qatar

Projektin tunnus: #4240238

14 freelanceria on tarjonnut keskimäärin 150 $ tähän työhön

bharanisrihari

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

250 $ USD 7 päivässä
(59 arvostelua)
6.3
pkcyber

See you PMB

99 $ USD 1 päivässä
(18 arvostelua)
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 Lisää

250 $ USD 7 päivässä
(22 arvostelua)
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 7 päivässä
(24 arvostelua)
4.8
javed1705

dear sir please check pm

70 $ USD 1 päivässä
(12 arvostelua)
4.1
cosconeaionut

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

190 $ USD 6 päivässä
(6 arvostelua)
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 =============== Lisää

180 $ USD 2 päivässä
(7 arvostelua)
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 4 päivässä
(1 arvostelu)
1.6
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 [url removed, login to view] typing speed is 85 wpm. I am enthusia Lisää

250 $ USD 7 päivässä
(0 arvostelua)
0.0
abdullahdh83

Dear Sir, I am expert on Excel. I am a new freelancer on [url removed, login to view] 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. Lisää

50 $ USD 7 päivässä
(0 arvostelua)
0.0
swakte

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

30 $ USD 4 päivässä
(0 arvostelua)
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 Lisää

30 $ USD 7 päivässä
(0 arvostelua)
0.0
sandeep25101982

Hi [url removed, login to view],MVC,WCF, WPF and HTML CSS JQuery Expert here. My portfolio here [url removed, login to view]

100 $ USD 10 päivässä
(0 arvostelua)
3.8
lisaveta

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

250 $ USD 7 päivässä
(0 arvostelua)
0.0